<input type="submit" class="white-button" value="Submit Changes" /> </td> </tr> </tbody> </table> <h2> Order History </h2> <h3> Current Order </h3> <?php $current_order = Order_List::get_orders_for($_SESSION['CustomerID'], 'current'); $current_order->print_orders('current-order', 'orders-table'); if ($current_order->orders) { echo '<a href="menu" class="white-button">Edit Order</a>'; } ?> <h3> Past Orders </h3> <?php $past_orders = Order_List::get_orders_for($_SESSION['CustomerID'], 'past'); $past_orders->print_orders('past-orders', 'orders-table'); ?> </form> </div> <?php require 'footer.php'; ?>
width: 275px; display: block; } .header_image{ text-align: center; } .signature{ font-size: 9pt; } </style> <style type="text/css" media="all"> td{ width: 50%; } .alert{ color:#DA0E11; font-size:20px; font-family: "ROKKITT", "Gill Sans MT", "Myriad Pro", "DejaVu Sans Condensed", Helvetica, Arial, sans-serif, sans-serif; font-size: 12pt; line-height: 1.0; } .fontstyle {font-family: "ROKKITT", "Gill Sans MT", "Myriad Pro", "DejaVu Sans Condensed", Helvetica, Arial, sans-serif, sans-serif; font-size: 11pt; line-height: 1.0; } </style> </head> <body> <?php print_orders(Order_List::get_processing_orders('0', $date, false)->orders, $date_delivery); print_orders(Order_List::get_processing_orders('1', $date, false)->orders, $date_delivery); ?> </body> </html>
/** * Adds order by to SQL query string. * * @param string $sSql sql string * * @return string */ protected function _prepareOrderByQuery($sSql = null) { // calculating sum $sSumQ = getStr()->preg_replace(array("/select .*? from/", "/group by oxorderarticles.oxartnum/"), array("select round( sum(oxorderarticles.oxbrutprice*oxorder.oxcurrate),2) from", ""), $sSql); $this->_aViewData["sumresult"] = oxDb::getDb()->getOne($sSumQ); return parent::_prepareOrderByQuery($sSql); }