public function index() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $models = FinaceCompany::orderBy('name', 'asc')->get(['id', 'name']); $finacecompanyselectlist = array(); array_push($finacecompanyselectlist, ':เลือกไฟแนนซ์'); foreach ($models as $model) { array_push($finacecompanyselectlist, $model->id . ':' . $model->name); } $models = InterestRateType::has('commissionFinaces')->orderBy('name', 'asc')->get(['id', 'name']); $interestratetypeselectlist = array(); array_push($interestratetypeselectlist, ':เลือกประเภทอัตราดอกเบี้ย'); foreach ($models as $model) { array_push($interestratetypeselectlist, $model->id . ':' . $model->name); } $carmodels = CarModel::whereHas("carbrand", function ($q) { $q->where('ismain', true); })->orderBy('name', 'asc')->get(['id', 'name']); $carmodelselectlist = array(); array_push($carmodelselectlist, ':เลือกแบบ'); foreach ($carmodels as $item) { array_push($carmodelselectlist, $item->id . ':' . $item->name); } $carsubmodels = CarSubModel::has('commissionFinaceCars')->orderBy('name', 'asc')->get(['id', 'name']); $carsubmodelselectlist = array(); array_push($carsubmodelselectlist, '0:ทุกรุ่น'); foreach ($carsubmodels as $item) { array_push($carsubmodelselectlist, $item->id . ':' . $item->name); } return view('settings.commissionfinace', ['finacecompanyselectlist' => implode(";", $finacecompanyselectlist), 'interestratetypeselectlist' => implode(";", $interestratetypeselectlist), 'carmodelselectlist' => implode(";", $carmodelselectlist), 'carsubmodelselectlist' => implode(";", $carsubmodelselectlist)]); }
public function index() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $bookingcustomers = Customer::has('bookingCarPreemptions')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); $bookingcustomerselectlist = array(); foreach ($bookingcustomers as $item) { array_push($bookingcustomerselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } $carmodels = CarModel::has('carPreemptions')->orderBy('name', 'asc')->get(['id', 'name']); $carmodelselectlist = array(); foreach ($carmodels as $item) { array_push($carmodelselectlist, $item->id . ':' . $item->name); } $carsubmodels = CarSubModel::has('carPreemptions')->orderBy('name', 'asc')->get(['id', 'name']); $carsubmodelselectlist = array(); foreach ($carsubmodels as $item) { array_push($carsubmodelselectlist, $item->id . ':' . $item->name); } $colors = Color::has('carPreemptions')->orderBy('code', 'asc')->get(['id', 'code', 'name']); $colorselectlist = array(); foreach ($colors as $item) { array_push($colorselectlist, $item->id . ':' . $item->code . ' - ' . $item->name); } $buyercustomers = Customer::has('buyerCarPreemptions')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); $buyercustomerselectlist = array(); foreach ($buyercustomers as $item) { array_push($buyercustomerselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } $salesmanemployees = Employee::has('salesmanCarPreemptions')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); $salesmanemployeeselectlist = array(); foreach ($salesmanemployees as $item) { array_push($salesmanemployeeselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } $salesmanageremployees = Employee::has('salesmanagerCarPreemptions')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); $salesmanageremployeeselectlist = array(); foreach ($salesmanageremployees as $item) { array_push($salesmanageremployeeselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } $approversemployees = Employee::has('approversCarPreemptions')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); $approversemployeeselectlist = array(); foreach ($approversemployees as $item) { array_push($approversemployeeselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } $pricelists = Pricelist::has('carPreemptions')->orderBy('sellingpricewithaccessories', 'asc')->get(['id', 'sellingpricewithaccessories', 'promotion']); $priceselectlist = array(); foreach ($pricelists as $item) { //if($item->promotion != null && $item->promotion != '') //array_push($priceselectlist,$item->id.':'.$item->sellingpricewithaccessories.' ('.$item->promotion.')'); //else array_push($priceselectlist, $item->id . ':' . $item->sellingpricewithaccessories); } return view('carpreemption', ['bookingcustomerselectlist' => implode(";", $bookingcustomerselectlist), 'carmodelselectlist' => implode(";", $carmodelselectlist), 'carsubmodelselectlist' => implode(";", $carsubmodelselectlist), 'colorselectlist' => implode(";", $colorselectlist), 'buyercustomerselectlist' => implode(";", $buyercustomerselectlist), 'salesmanemployeeselectlist' => implode(";", $salesmanemployeeselectlist), 'salesmanageremployeeselectlist' => implode(";", $salesmanageremployeeselectlist), 'approversemployeeselectlist' => implode(";", $approversemployeeselectlist), 'priceselectlist' => implode(";", $priceselectlist)]); }
public function readSelectlistForDisplayInGrid() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $carsubmodels = CarSubModel::has('commissionFinaceCars')->orderBy('name', 'asc')->get(['id', 'name']); $carsubmodelselectlist = array(); array_push($carsubmodelselectlist, '0:ทุกรุ่น'); foreach ($carsubmodels as $item) { array_push($carsubmodelselectlist, $item->id . ':' . $item->name); } return ['carsubmodelselectlist' => implode(";", $carsubmodelselectlist)]; }
public function readSelectlistForDisplayInGrid() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $models = InterestRateType::has('commissionSpecials')->orderBy('name', 'asc')->get(['id', 'name']); $interestratetypeselectlist = array(); array_push($interestratetypeselectlist, ':เลือกประเภทอัตราดอกเบี้ย'); foreach ($models as $item) { array_push($interestratetypeselectlist, $item->id . ':' . $item->name); } $carsubmodels = CarSubModel::has('commissionSpecials')->orderBy('name', 'asc')->get(['id', 'name']); $carsubmodelselectlist = array(); array_push($carsubmodelselectlist, '0:ทุกรุ่น'); foreach ($carsubmodels as $item) { array_push($carsubmodelselectlist, $item->id . ':' . $item->name); } return ['interestratetypeselectlist' => implode(";", $interestratetypeselectlist), 'carsubmodelselectlist' => implode(";", $carsubmodelselectlist)]; }