Breaking News: Grepper is joining You.com. Read the official announcement!

filter product by multiple brands , colors, price, attributes, discount % and product rating from different tables migrations laravel

Cloudy Onward answered on October 17, 2023 Popularity 1/10 Helpfulness 1/10

answer filter product by multiple brands , colors, price, attributes, discount % and product rating from different tables migrations laravel

filter product by multiple brands , colors, price, attributes, discount % and product rating from different tables migrations laravel

Comment

$brands = ['Brand1', 'Brand2'];
$colors = ['Color1', 'Color2'];
$minPrice = 50;
$maxPrice = 200;
$attributes = ['Attribute1', 'Attribute2'];
$minDiscount = 10;
$maxDiscount = 30;
$minRating = 4;

$products = Product::whereHas('brand', function ($query) use ($brands) {
    $query->whereIn('name', $brands);
})
->whereHas('color', function ($query) use ($colors) {
    $query->whereIn('name', $colors);
})
->where('price', '>=', $minPrice)
->where('price', '<=', $maxPrice)
->whereHas('attributes', function ($query) use ($attributes) {
    $query->whereIn('name', $attributes);
})
->whereHas('discount', function ($query) use ($minDiscount, $maxDiscount) {
    $query->where('percentage', '>=', $minDiscount)
          ->where('percentage', '<=', $maxDiscount);
})
->whereHas('ratings', function ($query) use ($minRating) {
    $query->where('rating', '>=', $minRating);
})
->get();

Popularity 1/10 Helpfulness 1/10 Language php

Source: chat.openai.com

Tags: discount filter laravel php product rating

Link to this answer
Share Copy Link

Contributed on Oct 17 2023

Cloudy Onward

0 Answers Avg Quality 2/10

filter product by multiple brands , colors, price, attributes, discount % and product rating from different tables migrations laravel

Contents

More Related Answers

filter product by multiple brands , colors, price, attributes, discount % and product rating from different tables migrations laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.