Example #1
0
                        <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);
 }