public function readCarPreemptionSelectlistForDisplayInGrid($redlabelid) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } if (Auth::user()->isadmin) { $carpreemptions = CarPreemption::whereHas('redlabelhistories', function ($q) use($redlabelid) { $q->where('redlabelid', $redlabelid); })->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']); } else { $carpreemptions = CarPreemption::where('provinceid', Auth::user()->provinceid)->whereHas('redlabelhistories', function ($q) use($redlabelid) { $q->where('redlabelid', $redlabelid); })->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']); } $carpreemptionselectlist = array(); array_push($carpreemptionselectlist, ':เลือกการจอง'); foreach ($carpreemptions as $item) { $buyercustomer = Customer::find($item->buyercustomerid); $buyercustomername = $buyercustomer->title . ' ' . $buyercustomer->firstname . ' ' . $buyercustomer->lastname; $salesmanemployee = Employee::find($item->salesmanemployeeid); $salesmanemployeename = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname; array_push($carpreemptionselectlist, $item->id . ':' . str_pad($item->bookno . '/' . $item->no, strlen($item->bookno . '/' . $item->no) + 15, " ") . str_pad($buyercustomername, strlen($buyercustomername) + 15, " ") . $salesmanemployeename); } return ['carpreemptionselectlist' => implode(";", $carpreemptionselectlist)]; }