echo TABLE_HEADING_COMMENTS; ?> </b></td> </tr> <?php $orders_status_historytable = $oostable['orders_status_history']; $orders_history_result = $dbconn->Execute("SELECT orders_status_id, date_added, customer_notified, comments FROM {$orders_status_historytable} WHERE orders_id = '" . oos_db_input($oID) . "' ORDER BY date_added"); if ($orders_history_result->RecordCount()) { while ($orders_history = $orders_history_result->fields) { echo ' <tr>' . "\n" . ' <td class="smallText" align="center">' . oos_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">'; if ($orders_history['customer_notified'] == '1') { echo oos_image(OOS_IMAGES . 'icons/tick.gif', ICON_TICK) . "</td>\n"; } else { echo oos_image(OOS_IMAGES . 'icons/cross.gif', ICON_CROSS) . "</td>\n"; } echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" . ' <td class="smallText">' . nl2br(oosDBOutput($orders_history['comments'])) . ' </td>' . "\n" . ' </tr>' . "\n"; // Move that ADOdb pointer! $orders_history_result->MoveNext(); } } else { echo ' <tr>' . "\n" . ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> <tr> <td class="main"><br /><b><?php echo TABLE_HEADING_COMMENTS; ?> </b></td> </tr>
} ?> </tr> <?php $orders_history_result = $dbconn->Execute("select * from " . $oostable['orders_status_history'] . " WHERE orders_id = '" . oos_db_input($oID) . "' order by date_added"); if ($orders_history_result->RecordCount()) { while ($orders_history = $orders_history_result->fields) { echo ' <tr>' . "\n" . ' <td class="smallText" align="center">' . oos_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">'; if ($orders_history['customer_notified'] == '1') { echo oos_image(OOS_IMAGES . 'icons/tick.gif', ICON_TICK) . "</td>\n"; } else { echo oos_image(OOS_IMAGES . 'icons/cross.gif', ICON_CROSS) . "</td>\n"; } echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n"; if ($CommentsWithStatus) { echo ' <td class="smallText">' . nl2br(oosDBOutput($orders_history['comments'])) . ' </td>' . "\n"; } echo ' </tr>' . "\n"; // Move that ADOdb pointer! $orders_history_result->MoveNext(); } } else { echo ' <tr>' . "\n" . ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> <tr> <td class="main"><br /><b><?php echo TABLE_HEADING_COMMENTS;
$total_cost += $total_products_price; $products_ordered .= $oOrder->products[$i]['qty'] . ' x ' . $oOrder->products[$i]['name'] . ' (' . $oOrder->products[$i]['model'] . ') = ' . $oCurrencies->display_price($oOrder->products[$i]['final_price'], $oOrder->products[$i]['tax'], $oOrder->products[$i]['qty']) . $products_ordered_attributes . "\n"; } $oOrderTotalModules->apply_credit(); // lets start with the email confirmation $email_order = STORE_NAME . "\n" . $aLang['email_separator'] . "\n" . $aLang['email_text_order_number'] . ' ' . $insert_id . "\n" . $aLang['email_text_invoice_url'] . ' ' . oos_href_link($aPages['account_history_info'], 'order_id=' . $insert_id, 'SSL', false) . "\n" . $aLang['email_text_date_ordered'] . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; if ($oOrder->info['comments']) { $email_order .= oosDBOutput($oOrder->info['comments']) . "\n\n"; } if (isset($_SESSION['campaigns_id'])) { $email_order .= $aLang['email_separator'] . "\n" . $aLang['email_text_campaigns'] . "\n" . oos_get_campaigns_name($_SESSION['campaigns_id']) . "\n\n"; } $email_order .= $aLang['email_text_products'] . "\n" . $aLang['email_separator'] . "\n" . $products_ordered . $aLang['email_separator'] . "\n";