Level 10
Before pagination use orderby and provide the column you want to sort.
May 25, 2021
12
Level 6
Sort product after searching product
I am doing an e-commerce project, I got a list of products displayed in product_searched_list.blade.php after search query or after going through category dropdown. i want to sort the list of the product after searching how can i implement such functionality
method for a list of the product after search
public function product_search(Request $request){
$querys=$request->search_query;
if($request->category=='all'){
$product = Product::where(function ($query) use ($querys) {
$query->where("name","like","%".$querys."%")
->orWhere("description","like","%".$querys."%")
->orWhere("color","like","%".$querys."%")
->orWhere("size","like","%".$querys."%");
})->paginate(8) ;
}else{
$category=Category::where('slug',$request->category)->firstOrFail();
$cat_id=$category->id;
$product = Product::where('category_id',$cat_id)->where(function ($query) use ($querys) {
$query->where("name","like","%".$querys."%")
->orWhere("description","like","%".$querys."%")
->orWhere("color","like","%".$querys."%")
->orWhere("size","like","%".$querys."%");
})->paginate(8);
}
return view('frontend.product_list')->with('product',$product);
}
this result is displayed in product_searched_list.blade.php...in this blade file ...i want to do some sort query how can i implement such functionality
Level 55
@anilkumarthakur60 and... what's the problem?
Product::where(...)
->orderBy('name')
->paginate(8);
Level 6
searched result is displayed in a page ....after displaying the product i want to do some sorting query ....
Level 55
@anilkumarthakur60 I don't understand what you mean. Can you explain?
Level 10
What I think you can do is you have to send one more variable(sort) to the same request for searching the product. If the value for the sort is true then use orderby or else everything will remain the same.
Level 75
Start thinking about your code...
public function search(Request $request)
{
$products = Product::when($request->search, function ($query, $search) {
return $query->where(function ($query) use ($search) {
$query->where('name', 'like', $search = "%{$search}%")
->orWhere('description', 'like', $search)
->orWhere('color', 'like', $search)
->orWhere('size', 'like', $search);
});
})->when($request->category && $request->category != 'all', function ($query) use ($requst) {
return $query->whereHas('category', function ($query) use ($request) {
$query->where('slug', $request->category);
});
})->orderBy('something')->paginate(8);
return view('frontend.product-list', compact('products'));
}
Level 6
thank you so much
Level 6
i have again a few queries for you.....does this work even for passing subcategory slug by making change in above code
public function search(Request $request)
{
$products = Product::when($request->search, function ($query, $search) {
return $query->where(function ($query) use ($search) {
$query->where('name', 'like', $search = "%{$search}%")
->orWhere('description', 'like', $search)
->orWhere('color', 'like', $search)
->orWhere('size', 'like', $search);
});
})->when($request->category && $request->category != 'all', function ($query) use ($requst) {
return $query->whereHas('category', function ($query) use ($request) {
$query->where('slug', $request->category);
});
})->when($request->sub_category, function ($query) use ($requst) {
return $query->whereHas('sub_category', function ($query) use ($request) {
$query->where('slug', $request->sub_category);
});
})->orderBy('something')->paginate(8);
return view('frontend.product-list', compact('products'));
}
Level 75
>when($request->sub_category, function ($query) use ($requst) {
return $query->whereHas('sub_category', function ($query) use ($request) {
$query->where('slug', $request->sub_category); // here use sub_category and not category
});
})
->orderBy('something') // here use your real column from products table
Level 6
i got all about this...never done this type of query before thank you so much
Level 75
Level 6
how can we keep this collection in cache
Please or to participate in this conversation.