public function searchForTypeA(Request $request) { $key = $request->input('key', null); $value = $request->input('value', null); if ($key && $value != null) { $customers = Customer::whereHas('information', function ($query) use($key, $value) { $query->where('type', 'A')->where($key, 'like', '%' . $value . '%'); }); } else { $customers = Customer::whereHas('information', function ($query) { $query->where('type', 'A'); }); } $customers = $customers->with('information'); return response()->json(['success' => true, 'data' => ['customers' => $customers->orderBy('id', 'desc')->paginate(20)]]); }
public function readSelectlistForDisplayInGrid() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $customers = Customer::whereHas('buyerCarPreemptions.redlabelhistories', function ($q) { $q->whereNull('returndate'); })->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); $customerselectlist = array(); foreach ($customers as $item) { array_push($customerselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname); } return ['customerselectlist' => implode(";", $customerselectlist)]; }