Exemple #1
0
    public static function PurchaseOrders()
    {
        $collection = PurchaseOrder::GetAllOrders($_GET['period'], $_GET['all']);
        echo '
				<div class="logo">
				  <h5 style="margin-bottom:-15px;margin-top:0px;font-size:14px;">Date: ' . date('d/m/Y') . '</h5>
				  <h4>ALL PURCHASE ORDERS</h4>';
        if ($_GET['period'] != '' && $_GET['period']) {
            echo '<h5 style="margin-top:-10px">Period: ' . $_GET['period'] . '</h5>';
        }
        echo '</div>

				<table class="table table-bordered table-striped" style="text-align:center;margin-left:0;margin-right:0;width:760px;font-size:12px;">
			      <thead class="title">
			        <tr>
			          <td>DATE</td>
			          <td>ORDER ID</td>
			          <td>COMPANY</td>
			          <td>PURPOSE</td>
			          <td>STATUS</td>
					  <td>TOTAL</td>
			        </tr>
			      </thead>
			      <tbody>';
        $total = 0.0;
        $invoiced = 0.0;
        $itms = 0;
        foreach ($collection as $item) {
            echo '<tr>
			      <td>' . $item->date . '</td>
			      <td>' . $item->id . '</td>
			      <td>' . $item->party->name . '</td>';
            $sql = 'SELECT * FROM purchase_orders WHERE id = ' . $item->id;
            $res = DatabaseHandler::GetRow($sql);
            $vc = PurchaseOrderVoucher::initialize($res);
            echo '<td>' . $vc->description . '</td>';
            if ($item->status == 1) {
                echo '<td style="color:#232836">CREATED</td>';
            } else {
                echo '<td style="color:#27c97b">ORDERED</td>';
                $invoiced += $item->total;
            }
            echo '<td class="text-right" style="padding: 0 5px;"><script>document.writeln((' . $item->total . ').formatMoney(2, \'.\', \',\'));</script></td>
			    </tr>';
            $total += $item->total;
            ++$itms;
        }
        echo '</tbody>
			    </table>
			    <div class="logo">
			    	<p style="margin: 5px 0 0 5px">Total Quotes: <b>' . $itms . '</b></p>
					<p style="margin: 5px 0 0 5px">Total Quoted: <b>Ksh. <script>document.writeln((' . $total . ').formatMoney(2, \'.\', \',\'));</script></b></p>
					<p style="margin: 5px 0 0 5px">Total Invoiced: <b>Ksh. <script>document.writeln((' . $invoiced . ').formatMoney(2, \'.\', \',\'));</script></b></p>
				</div>';
    }