echo "\t\t\t</div>\n";
}
echo "\t\t\t<input type='hidden' id='item_count' value='" . $itemsCnt . "'/>";
echo "\t\t</form>\n";
echo "\t\t</div>\n";
echo "\t</div>\n";
echo "\t<br clear='all'/><br/><br/>\n";
echo "\t<table class='sofort_table'>\n";
echo "\t\t<tr class='sofort_htr'>\n";
echo "\t\t\t<td class='sofort_htd' align='center' width='16%'>" . TABLE_HEADING_DATE_ADDED . "</td>\n";
echo "\t\t\t<td class='sofort_htd' align='center' width='16%'>" . TABLE_HEADING_CUSTOMER_NOTIFIED . "</td>\n";
echo "\t\t\t<td class='sofort_htd' align='center' width='16%'>" . TABLE_HEADING_STATUS . "</td>\n";
echo "\t\t\t<td class='sofort_htd' align='center' width='52%'>" . TABLE_HEADING_COMMENTS . "</td>\n";
echo "\t\t</tr>\n";
$ordersHistoryQuery = shopDbQuery('SELECT orders_status_id, date_added, customer_notified, comments FROM ' . TABLE_ORDERS_STATUS_HISTORY . ' WHERE orders_id = \'' . $oID . '\' ORDER BY date_added');
if (shopDbNumRows($ordersHistoryQuery)) {
$i = 0;
while ($ordersHistory = shopDbFetchArray($ordersHistoryQuery)) {
$bgColor = $i % 2 ? '#E0E0E0' : '#FAFAFA';
$i++;
echo "\t\t<tr class='sofort_tr' style='background-color:" . $bgColor . "'>\n";
echo "\t\t\t<td class='sofort_td' align='center'>" . shopDatetimeShort($ordersHistory['date_added']) . "</td>\n";
echo "\t\t\t<td class='sofort_td' align='center'>";
if ($ordersHistory['customer_notified'] == '1') {
echo "<img src='" . shopGetIconPath() . "ok.gif' />";
} elseif ($ordersHistory['customer_notified'] == '-1') {
echo "<img src='" . shopGetIconPath() . "lock.gif' />";
} else {
echo "<img src='" . shopGetIconPath() . "error.gif' />";
}
echo "</td>\n";
/**
* Checks if total exists; updates or deletes if true; inserts if false
* @param int $ordersId
* @param string $class
* @param string $title
* @param string $text
* @param float $value
* @param string $addCond
*/
protected function _checkAndUpdateTotal($ordersId, $class, $title, $text, $value, $sortOrder, $addCond = '')
{
if (shopDbNumRows(shopDbQuery('SELECT * FROM ' . TABLE_ORDERS_TOTAL . ' WHERE orders_id = "' . $ordersId . '" AND class = "' . $class . '"' . $addCond)) != 0) {
if ($value != 0 || $class == 'ot_shipping') {
shopDbQuery('UPDATE ' . TABLE_ORDERS_TOTAL . ' SET value = "' . $value . '" , text = "' . $text . '" WHERE orders_id = "' . $ordersId . '" AND class = "' . $class . '"' . $addCond);
} else {
shopDbQuery('DELETE FROM ' . TABLE_ORDERS_TOTAL . ' WHERE orders_id = "' . $ordersId . '" AND class = "' . $class . '"' . $addCond);
}
} else {
if ($value != 0 || $class == 'ot_shipping') {
$data = array('value' => $value, 'text' => $text, 'orders_id' => $ordersId, 'class' => $class, 'title' => $title, 'sort_order' => $sortOrder);
shopDbPerform(TABLE_ORDERS_TOTAL, $data);
}
}
}
