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; }