// Move that ADOdb pointer! $orders_products_result->MoveNext(); } for ($i = 0; $i < count($order->products); $i++) { $orders_products_id = $order->products[$i]['orders_products_id']; $RowStyle = "dataTableContent"; echo ' <tr class="dataTableRow">' . "\n" . ' <td class="' . $RowStyle . '" valign="top" align="right">' . "<input name='update_products[{$orders_products_id}][qty]' size='2' value='" . $order->products[$i]['qty'] . "'> x</td>\n" . ' <td class="' . $RowStyle . '" valign="top">' . "<input name='update_products[{$orders_products_id}][name]' size='25' value='" . $order->products[$i]['name'] . "'>"; // Has Attributes? if (count($order->products[$i]['attributes']) > 0) { for ($j = 0; $j < count($order->products[$i]['attributes']); $j++) { $orders_products_attributes_id = $order->products[$i]['attributes'][$j]['orders_products_attributes_id']; echo '<br /><nobr><small> <i> - ' . "<input name='update_products[{$orders_products_id}][attributes][{$orders_products_attributes_id}][option]' size='6' value='" . $order->products[$i]['attributes'][$j]['option'] . "'>" . ': ' . "<input name='update_products[{$orders_products_id}][attributes][{$orders_products_attributes_id}][value]' size='10' value='" . $order->products[$i]['attributes'][$j]['value'] . "'>"; echo '</i></small></nobr>'; } } echo ' </td>' . "\n" . ' <td class="' . $RowStyle . '" valign="top">' . "<input name='update_products[{$orders_products_id}][model]' size='12' value='" . $order->products[$i]['model'] . "'>" . '</td>' . "\n" . ' <td class="' . $RowStyle . '" align="center" valign="top">' . "<input name='update_products[{$orders_products_id}][tax]' size='3' value='" . oos_display_tax_value($order->products[$i]['tax']) . "'>" . '%</td>' . "\n" . ' <td class="' . $RowStyle . '" align="right" valign="top">' . "<input name='update_products[{$orders_products_id}][final_price]' size='5' value='" . number_format($order->products[$i]['final_price'], 2, '.', '') . "'>" . '</td>' . "\n" . ' <td class="' . $RowStyle . '" align="right" valign="top">' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" . ' </tr>' . "\n"; } ?> <!-- End Products Listings Block --> <!-- Begin Order Total Block --> <tr> <td align="right" colspan="6"> <table border="0" cellspacing="0" cellpadding="2" width="100%"> <tr> <td align='center' valign='top'><br /><a href="<?php print $_SERVER['PHP_SELF'] . "?oID={$oID}&action=add_product&step=1"; ?> "><u><b><font size='3'><?php echo TEXT_DATE_ORDER_ADDNEW; ?>
} ?> <td class="dataTableContent"><?php echo $rates['tax_priority']; ?> </td> <td class="dataTableContent"><?php echo $rates['tax_class_title']; ?> </td> <td class="dataTableContent"><?php echo $rates['geo_zone_name']; ?> </td> <td class="dataTableContent"><?php echo oos_display_tax_value($rates['tax_rate']); ?> %</td> <td class="dataTableContent" align="right"><?php if (isset($trInfo) && is_object($trInfo) && $rates['tax_rates_id'] == $trInfo->tax_rates_id) { echo oos_image(OOS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $rates['tax_rates_id']) . '">' . oos_image(OOS_IMAGES . 'icon_information.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php // Move that ADOdb pointer! $rates_result->MoveNext(); }
echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; if (count($order->products[$i]['attributes']) > 0) { for ($j = 0, $k = count($order->products[$i]['attributes']); $j < $k; $j++) { echo '<br /><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') { echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; } echo '</i></small></nobr>'; } } echo ' </td>' . "\n"; $serial_number = "Add Serial #"; if (oos_is_not_null($order->products[$i]['serial_number'])) { $serial_number = $order->products[$i]['serial_number']; } echo ' <td class="dataTableContent" valign="top"><a href="' . oos_href_link_admin($aFilename['orders'], 'action=edit&oID=' . $oID . '&serial=' . $i, 'NONSSL') . '">' . $serial_number . '</a></td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top">' . oos_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(oos_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(oos_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; if (oos_is_not_null($_GET['serial']) && $_GET['serial'] == $i && $_GET['serial_updated'] != 1) { echo ' <tr class="dataTableRow">' . "\n" . ' <td class="dataTableContent" colspan="2" valign="top" align="right">Enter Serial #: </td>' . "\n"; echo ' <td class="dataTableContent" colspan="7" valign="top">' . oos_draw_form('serial_form', $aFilename['orders'], 'action=update_serial&oID=' . $oID . '&serial=' . $order->products[$i]['id'], 'post', '') . oos_draw_input_field('serial_number', $serial_number, '', false, 'text', true) . ' ' . oos_image_swap_submits('update', 'update_off.gif', IMAGE_UPDATE) . '</td>' . "\n" . ' </tr>' . "\n"; } } ?> <tr> <td align="right" colspan="9"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = count($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td>
if ( ($k = count($order->products[$i]['attributes'])) > 0) { for ($j = 0; $j < $k; $j++) { echo '<br /><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } echo ' </td>' . "\n"; $serial_number = ""; if (!empty($order->products[$i]['serial_number'])) $serial_number = $order->products[$i]['serial_number']; echo ' <td class="dataTableContent" valign="top">' . $serial_number . '</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td class="dataTableContent" align="right" valign="top">' . oos_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(oos_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(oos_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td align="right" colspan="9"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = count($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n";
if (($k = count($order->products[$i]['attributes'])) > 0) { for ($j = 0; $j < $k; $j++) { echo '<br /><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') { echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; } echo '</i></small></nobr>'; } } echo ' </td>' . "\n"; $serial_number = ""; if (oos_is_not_null($order->products[$i]['serial_number'])) { $serial_number = $order->products[$i]['serial_number']; } echo ' <td class="dataTableContent" valign="top">' . $serial_number . '</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; echo ' <td class="dataTableContent" align="right" valign="top">' . oos_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(oos_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(oos_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td align="right" colspan="9"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = count($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> </table>
$rates_result = $dbconn->Execute($rates_result_raw); while ($rates = $rates_result->fields) { if ((!isset($_GET['tID']) || (isset($_GET['tID']) && ($_GET['tID'] == $rates['tax_rates_id']))) && !isset($trInfo) && (substr($action, 0, 3) != 'new')) { $trInfo = new objectInfo($rates); } if (isset($trInfo) && is_object($trInfo) && ($rates['tax_rates_id'] == $trInfo->tax_rates_id) ) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $trInfo->tax_rates_id . '&action=edit') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $rates['tax_rates_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo $rates['tax_priority']; ?></td> <td class="dataTableContent"><?php echo $rates['tax_class_title']; ?></td> <td class="dataTableContent"><?php echo $rates['geo_zone_name']; ?></td> <td class="dataTableContent"><?php echo oos_display_tax_value($rates['tax_rate']); ?>%</td> <td class="dataTableContent" align="right"><?php if (isset($trInfo) && is_object($trInfo) && ($rates['tax_rates_id'] == $trInfo->tax_rates_id) ) { echo oos_image(OOS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $rates['tax_rates_id']) . '">' . oos_image(OOS_IMAGES . 'icon_information.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php // Move that ADOdb pointer! $rates_result->MoveNext(); } // Close result set $rates_result->Close(); ?> <tr> <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $rates_split->display_count($rates_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_TAX_RATES); ?></td> <td class="smallText" align="right"><?php echo $rates_split->display_links($rates_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?></td>