Correct query for multiplier filters ?

I need to show listings of projects with following filters :

If locality of a city is selected
Type of listings a. for sale b. for purchase c. for rent d. for rent out
type of BHk a. 1 bhk b. 2-3 bhk c. 4 bhk onwards
posted by a. individual b. broker

My present controller query : I am unable to write nested orWhere for the above filters :

      $listings = Listings::with('user','project')
                ->whereHas('project', fn ($query) 
                =>$query->when($request->project_city, fn ($query, $city) 
                => $query->where('project_city', $city))
                ->whereHas('city', fn ($query) => $query->where('status', 1)))
                ->latest()
                ->paginate(5)
                ->withQueryString();

What is the correct query.

Tray2

4 years ago

Level 73

I take it you pass those filters in your request.

Something like this should work.

Listing::where('city', 'like', '%' . $request->city . '%')
		->where('type', 'like', '%' . $request->type . '%')
		->where('posted_by'. 'like' , '%' . $request->posted_by . '%')

1 like

FounderStartup

4 years ago

Level 5

@Tray2 Thanks for your time.

I am using check boxes for filtering.

FounderStartup

4 years ago

Level 5

@Tray2 Kindly note that a user can click two type of BHKs. So how can we use as per your suggestion ?

Tray2

4 years ago

Best Answer

Level 73

@FounderStartup Then you need to use in instead of like and remove the %

1 like

Please or to participate in this conversation.