I am working on E-Commerce application, in which I am fetching the product which has the status 1. But there are situations where I need to fetch the product which has status 2 or 3.
I have overridden the newQuery
method and added a condition for status 1
in that method. Now I want to add another condition for status 2
, but when I add this condition, the where clause will be duplicated in SQL query for that column(the default behavior of query builder).
Below is my code,
public function newQuery($excludeDeleted = true) {
return parent::newQuery($excludeDeleted)
->where('status', 1);
}
When I need to fetch the product with status 2 as below
return $query->where('status', 2);
then the query formed will be as below
select * from `products` where `status` = 1 and `status` = 2
But I need an output like below query
select * from `products` where `status` = 2
Please suggest the way of doing it.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire