public function incentivemodel() { //$cust_group = DB::table('customers')->groupBy('CustGroup')->get(['CustGroup']); //dd($cust_group); //return view('pages.addpoform')->with('cust_group',$cust_group); $data_model = PmtProductModel::distinct()->select('pdmodel_code', 'pdmodel_desc')->orderBy('pdmodel_code', 'asc')->get(); //dd($data_cust); return view('sales.incentive_model')->with('model', $data_model); }
public function editOrder() { if (!empty(Request::input('doc_no'))) { $id = Request::input('id'); $can = Request::input('can'); if ($can == "Y") { $status = "OCL"; } else { $status = "PAL"; } $data_entity = Entity::where('entity_code', 'CXXXX')->get(['entity_tname', 'cos_no', 'sale_type', 'tax_rate']); $cos_entity = "B10"; $doc_code = "PO"; $cust_name = $data_entity[0]->entity_tname; $cos_no = $data_entity[0]->cos_no; $tax_rate = $data_entity[0]->tax_rate; $ddate = date_create_from_format('d/m/Y', Request::input('doc_date')); $doc_date = date_format($ddate, 'Y-m-d'); $rdate = date_create_from_format('d/m/Y', Request::input('req_date')); $req_date = date_format($rdate, 'Y-m-d'); $getqty = Request::input('qty'); $getprice = Request::input('price'); $disc_amt = Request::input('disc_amt'); $count_qty = count($getqty); $tot_amt = 0; $net_amt = 0; for ($j = 0; $j < $count_qty; $j++) { $tot_amt += $getqty[$j] * $getprice[$j]; } $net_amt = $tot_amt - $disc_amt; $tot_qty = array_sum($getqty); $data_cos_mast = array('cos_entity' => $cos_entity, 'cos_no' => $cos_no, 'doc_code' => $doc_code, 'doc_no' => Request::input('doc_no'), 'doc_date' => $doc_date, 'req_date' => $req_date, 'pmt_no' => Request::input('pmt_no'), 'cust_code' => 'CXXXX', 'cust_name' => $cust_name, 'ship_titlename' => Request::input('ship_titlename'), 'ship_custname' => Request::input('ship_custname'), 'ship_custsurname' => Request::input('ship_custsurname'), 'ship_address1' => Request::input('ship_address1'), 'ship_address2' => Request::input('ship_address2'), 'prov_code' => Request::input('prov_code'), 'prov_name' => Request::input('prov_name'), 'post_code' => Request::input('post_code'), 'ship_tel' => Request::input('tel'), 'email_address' => Request::input('email_address'), 'gp1' => Request::input('gp1'), 'gp2' => Request::input('gp2'), 'gp3' => Request::input('gp3'), 'pay_code' => Request::input('pay_code'), 'pay_name' => Request::input('pay_name'), 'vat_rate' => $tax_rate, 'doc_status' => $status, 'tot_qty' => $tot_qty, 'tot_amt' => $tot_amt, 'tot_netamt' => $net_amt, 'tot_discamt' => Request::input('disc_amt'), 'created_by' => 'admin', 'created_at' => date('Y-m-d H:i:s')); //Insert to po_head $cos_invmast_insert = DB::table('cos_invmast')->insertGetId($data_cos_mast); //Insert to po_details if ($cos_invmast_insert) { //รับค่าตัวà¹à¸›à¸£à¸²à¸ˆà¸²à¸ JQuery เป็นตัวà¹à¸›à¸£à¸² Array $getprodcode = Request::input('procode'); $getprodname = Request::input('proname'); $getqty = Request::input('qty'); $getprice = Request::input('price'); $getsp_size = Request::input('sp_size'); $getsp_size_desc = Request::input('sp_size_desc'); $getprodset = Request::input('prodset'); $count_item = count($getprodcode); //dd($count_item); // ถ้าทีà¸à¸²à¸£à¸šà¸±à¸™à¸—ึà¸à¸£à¸²à¸¢à¸à¸²à¸£à¸ªà¸´à¸™à¸„้า if ($count_item) { $item = 1; $item_prod = 1; for ($i = 0; $i < $count_item; $i++) { $data_cos_det = array('cos_invmast_id' => $cos_invmast_insert, 'cos_entity' => $cos_entity, 'cos_no' => $cos_no, 'doc_code' => $doc_code, 'doc_no' => Request::input('doc_no'), 'item' => $item, 'prod_code' => $getprodcode[$i], 'prod_name' => $getprodname[$i], 'qty' => $getqty[$i], 'sale_price' => $getprice[$i], 'amt' => $getqty[$i] * $getprice[$i], 'vat_rate' => $tax_rate, 'sp_size' => $getsp_size[$i], 'sp_size_desc' => $getsp_size_desc[$i], 'created_by' => 'admin', 'created_at' => date('Y-m-d H:i:s')); DB::table('cos_invdet')->insert($data_cos_det); $data_prod = PmtProductModel::where('pmt_product_set_id', $getprodset[$i])->first(); $data_set = array('cos_invmast_id' => $cos_invmast_insert, 'item' => $item_prod, 'prod_code' => $data_prod->prod_code, 'prod_name' => $data_prod->prod_tname, 'barcode' => $data_prod->bar_code, 'uom_code' => $data_prod->uom_code, 'sale_price' => $getprice[$i], 'qty' => $getqty[$i], 'amt' => $getqty[$i] * $getprice[$i], 'sp_size_desc' => $getsp_size_desc[$i], 'created_by' => 'admin', 'created_at' => date('Y-m-d H:i:s')); //dd($data_set); DB::table('cos_invdet_product')->insert($data_set); $item_prod++; $item++; } if (!empty($id)) { $delete_mast = CosInvmast::where('id', $id)->delete(); $delete_det = CosInvdet::where('cos_invmast_id', $id)->delete(); $delete_product = CosInvdetProduct::where('cos_invmast_id', $id)->delete(); } return "Edit_Success"; } } } }