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)];
}
