public static function PurchaseInvoices()
{
$collection = PurchaseInvoice::GetAllInvoices($_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 INVOICES</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>GRN NO</td>
<td>INV NO</td>
<td>COMPANY</td>
<td>TOTAL</td>
</tr>
</thead>
<tbody>';
$total = 0.0;
$itms = 0;
foreach ($collection as $item) {
$party = Supplier::GetSupplier($item['party_id']);
echo '<tr>
<td>' . $item['date'] . '</td>
<td>' . $item['id'] . '</td>
<td>' . $item['invno'] . '</td>
<td>' . $party->name . '</td>
<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 Invoices: <b>' . $itms . '</b></p>
<p style="margin: 5px 0 0 5px">Total Invoiced: <b>Ksh. <script>document.writeln((' . $total . ').formatMoney(2, \'.\', \',\'));</script></b></p>
</div>';
}
public function setSupplier($id)
{
$this->party = Supplier::GetSupplier($id);
}
public static function MakePayment($party, $scope, $supplierid, $amount, $ledgerId, $mode, $voucher, $descr)
{
try {
$supplier = Supplier::GetSupplier($supplierid);
$grns = "";
/*foreach ($payments as $key => $payment) {
$grns .= $key.",";
}*/
$descr .= ' (' . $voucher . ')';
$sql = 'INSERT INTO payments (party_id, grns, amount, ledger_id, mode, voucher_no, description, status) VALUES
(' . $supplierid . ', "' . $grns . '", ' . $amount . ', ' . $ledgerId . ', "' . $mode . '", "' . $voucher . '", "' . $descr . '", 0)';
DatabaseHandler::Execute($sql);
$sql2 = 'SELECT * FROM payments WHERE party_id = ' . $supplierid . ' ORDER BY id DESC LIMIT 0,1';
$res = DatabaseHandler::GetRow($sql2);
$acc = Account::GetAccountByNo($supplierid, 'suppliers', 'Creditors');
$expv = ExpenseVoucher::CreateSupplierProjectExpense($party, $scope, $amount, $acc->ledgerId, $voucher, $descr);
if ($expv) {
$tx = self::initialize($res);
$tx->expVoucher = $expv;
return $tx;
} else {
return false;
}
return self::initialize($res);
} catch (Exception $e) {
}
}
public function generatePurchaseOrder($supplierid, $date, $items)
{
$supplier = Supplier::GetSupplier($supplierid);
$order = PurchaseOrder::CreateOrder($supplier, $date);
foreach ($items as $item) {
$ql = PurchaseOrderLine::Create($order->id, $item['item'], $item['qty'], $item['price']);
$order->addToOrder($ql);
}
$voucher = $order->generate();
if ($voucher) {
echo json_encode($voucher);
} else {
echo 0;
}
}
