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