static function checkDuplicatePo($key) { $purchase = new Purchase($key); //Search Duplicate $records = fRecordSet::build('Purchase', array('po_number=' => $purchase->getPoNumber())); if ($records->count() > 1) { //Generate New PO echo 'Duplicate PO'; $exploded = explode('/', $purchase->getPoNumber()); echo (int) $exploded[2] + 1; $exploded[2] = sprintf("%03d", (int) $exploded[2] + 1); $newPONumber = implode('/', $exploded); $purchase->setPoNumber($newPONumber); $purchase->store(); } }
<?php include '../resources/init.php'; $error = false; if (isset($_POST['type'])) { if ($_POST['type'] == "add") { try { $grn = new Good_receipt_note(); $grn->populate(); $purchase = new Purchase($_POST['pr_no']); $purchase->setStatus('completed'); $json_form = fRequest::get('jsonForm'); $jsonForm = fJSON::decode($json_form); if (!$error) { $grn->store(); $purchase->store(); } foreach ($jsonForm as $row) { try { $grn_detail = new Good_receipt_note_detail(); $grn_detail->setDocNumber($_POST['doc_number']); $grn_detail->setItemId($row->{'itemCode'}); $grn_detail->setDescription($row->{'itemDesc'}); $grn_detail->setQuantity($row->{'itemQuan'}); $grn_detail->setAssessment($row->{'assess'}); $grn_detail->setRemark($row->{'remarks'}); if (!$error) { $grn_detail->store(); } } catch (fExpectedException $e) { echo $e->printMessage();
$totalchecker = 0; foreach ($purchase_details as $purchase_detail) { echo "<tr><td>" . $counter . "</td><td>" . $purchase_detail->prepareItemId() . "</td>"; $item = new Inv_item($purchase_detail->getItemId()); echo "<td>" . $purchase_detail->prepareDescription() . "</td><td>" . $purchase_detail->prepareQuantity() . "</td>\n\t\t\t\t\t\t\t \t<td>" . $item->prepareUnitOfMeasure() . "</td><td>" . $purchase_detail->prepareUnitPrice() . "</td>\n\t\t\t\t\t\t\t\t<td>" . $purchase_detail->prepareExtendedPrice() . "</td></tr>"; $totalchecker = $totalchecker + $purchase_detail->getExtendedPrice(); $counter++; } ?> </tbody> <?php $totalchecker = $totalchecker - $purchase->getDiscount(); if ($totalchecker != $purchase->getTotal()) { $purchaseNu = new Purchase($_GET['id']); $purchaseNu->setTotal($totalchecker); $purchaseNu->store(); } ?> <tfoot> <tr><td colspan="5"></td><td>Discount</td><td><?php echo $purchase->prepareDiscount(2); ?> </td></tr> <tr><td colspan="5" id="addRowBTN"><div class="ui-icon ui-icon-circle-plus span-1 last"></div>Add Row</td><td class="tfootCaption">Total</td><td id="purchaseTotal"><?php echo $purchase->prepareTotal(2); ?> </td></tr> </tfoot> </table> <div class="pdbox span-11"><label>Payment Terms</label><br /><?php echo $purchase->preparePayment();