本文整理匯總了PHP中app\Product::whereHas方法的典型用法代碼示例。如果您正苦於以下問題:PHP Product::whereHas方法的具體用法?PHP Product::whereHas怎麽用?PHP Product::whereHas使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Product
的用法示例。
在下文中一共展示了Product::whereHas方法的3個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: index
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(\App\Product $productModel, \App\Category $categoryModel)
{
$category_id = request('cat');
$categories = $categoryModel->all()->lists('title', 'id');
if ($category_id) {
$categoryModel->findOrFail($category_id);
$products = $productModel->whereHas('categories', function ($query) use($category_id) {
$query->where('category_id', $category_id);
})->get()->toArray();
} else {
$products = $productModel->all()->toArray();
}
return view('product.index', compact('products', 'categories', 'category_id'));
}
示例2: index
public function index(Request $request)
{
if ($request->has('filter')) {
$filter = $request->input('filter');
$products = Product::whereHas('categories', function ($q) use($filter) {
$q->whereIn('categories.id', $filter);
})->simplePaginate(10);
} else {
$filter = "";
$products = Product::with('categories')->simplePaginate(10);
}
$categories = Category::withDepth()->get();
$categories = $categories->toTree();
return view('products.index', ['products' => $products, 'categories' => $categories, 'filter' => $filter]);
}
示例3: searchByColor
public static function searchByColor($id)
{
return Product::whereHas('colors', function ($query) use($id) {
$query->where('id', $id);
})->get();
}