public function readSelectlist($finacecompanyid) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $models = InterestRateType::where('finacecompanyid', $finacecompanyid)->orderBy('name', 'asc')->get(['id', 'name']); return $models; }
public function readSelectlistForDisplayInGrid() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $models = InterestRateType::has('commissionFinaces')->orderBy('name', 'asc')->get(['id', 'name']); $interestratetypeselectlist = array(); array_push($interestratetypeselectlist, ':เลือกประเภทอัตราดอกเบี้ย'); foreach ($models as $item) { array_push($interestratetypeselectlist, $item->id . ':' . $item->name); } return ['interestratetypeselectlist' => implode(";", $interestratetypeselectlist)]; }
public function getbyid($id) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $model = CarPreemption::find($id); $customer = Customer::find($model->buyercustomerid); $model->customer = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname; $carmodel = CarModel::find($model->carmodelid); $carsubmodel = CarSubModel::find($model->carsubmodelid); $model->carmodel = $carmodel->name . '/' . $carsubmodel->name; $color = Color::find($model->colorid); $model->carcolor = $color->code . ' - ' . $color->name; $pricelist = Pricelist::find($model->pricelistid); $model->carprice = $pricelist->sellingpricewithaccessories + $model->colorprice; if (Auth::user()->isadmin) { if ($model->carobjectivetype == 0) { $cars = Car::doesntHave('carPayment')->where('objective', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } else { $cars = Car::doesntHave('carPayment')->where('objective', '!=', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } } else { if ($model->carobjectivetype == 0) { $cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('objective', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } else { $cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('objective', '!=', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } } $model->cars = $cars; if ($model->finacecompanyid != null && $model->finacecompanyid != '') { $finacecompany = FinaceCompany::find($model->finacecompanyid); $model->finacecompany = $finacecompany->name; } if ($model->interestratetypeid != null && $model->interestratetypeid != '') { $interestratetype = InterestRateType::find($model->interestratetypeid); $model->interestratetype = $interestratetype->name; } if ($model->purchasetype == 0) { $model->yodjud = 0; $model->realprice = $model->carprice - $model->discount; } else { $model->yodjud = $model->carprice - $model->discount - $model->down + $model->accessories; $model->realprice = $model->carprice - $model->discount - $model->subdown; } $salesmanemployee = Employee::find($model->salesmanemployeeid); $model->salesmanemployee = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname; $approversemployee = Employee::find($model->approversemployeeid); $model->approversemployee = $approversemployee->title . ' ' . $approversemployee->firstname . ' ' . $approversemployee->lastname; if ($model->carobjectivetype == 0) { $registerprovince = Province::find($model->registerprovinceid); $model->registerprovince = $registerprovince->name; $redlabelhistory = Redlabelhistory::where('carpreemptionid', $id)->first(); if ($redlabelhistory != null) { $redlabel = Redlabel::find($redlabelhistory->redlabelid); $model->redlabel = $redlabel->no; } else { $model->redlabel = "ไม่มีป้าย"; } } else { $model->redlabel = null; } //if($cust->birthdate != null) //$cust->birthdate = date('d-m-Y', strtotime($cust->birthdate)); return $model; }