本文整理汇总了PHP中app\models\Customer::whereHas方法的典型用法代码示例。如果您正苦于以下问题：PHP Customer::whereHas方法的具体用法？PHP Customer::whereHas怎么用？PHP Customer::whereHas使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\models\Customer的用法示例。
在下文中一共展示了Customer::whereHas方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: searchForTypeA
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)]]);
}示例2: readSelectlistForDisplayInGrid
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)];
}