public static function createPO($data)
{
$po = $data['PO'];
$userID = $data['userID'];
$entries = json_decode($data['entries']);
$POSeries = PurchaseOrders::PONumseries();
$PONo = PurchaseOrders::getPONum();
$ID = $PONo[0]->idNum;
$Voucher = $PONo[0]->numSeries + 1;
DB::table('tbl_series')->where('idNum', $ID)->update(['numSeries' => $Voucher]);
$result = DB::table('tbl_po')->insertGetId(['po_num' => $POSeries[0]->PO, 'supplier' => $po['supplier'], 'branch' => $po['branch'], 'PO_date' => Carbon::NOW(), 'bank' => $po['bank'], 'purchasing_agent' => $po['POAgent'], 'requestedby' => $po['brName'], 'mop' => $po['mop'], 'userID' => $userID]);
for ($i = 0; $i < count($entries); $i++) {
$var = $entries[$i];
$quantity = $var->qty;
$unit = $var->unit;
$Items = $var->Items;
$unitPrice = $var->unitPrice;
$total = $var->total;
DB::table('tbl_po_items')->insert(['poID' => $result, 'items' => $Items, 'qty' => $quantity, 'unit' => $unit, 'unit_price' => $unitPrice, 'total' => $total]);
}
if ($result) {
$results['success'] = 'true';
$results['msg'] = 'New Purchase Order has been saved.';
} else {
$results['success'] = 'false';
$results['msg'] = 'WARNING: Unknown error occur while saving the record';
}
return $results;
}
public function getPOLists()
{
$data = PurchaseOrders::getPOLists();
return response()->json($data);
}
