Laravel whereHas not getting any results?

Question

I have a Restaurant Model, each restaurant has a Contact Model, and each Contact is related to a City Model:

Restaurant.php:

public function contact()
{
  return $this->hasOne('App\Contact','rest_id');
}

Contact.php:

public function restaurant()
{
  return $this->belongsTo('App\Restaurant','rest_id','id'); 
}

public function city()
{
  return $this->belongsTo('App\City');
}

City.php:

public function contacts()
{
  return $this->hasMany('App\Contact');
}

now, what I want to do is search the restaurant names, alongside city names.
my controller code for searching is like this:

// the purpose of this condition is to keep the query empty until applying desired filters
$data = Restaurant::where('id', '=', '0');
$cityRest=$request->cityRest ;
if (!empty($cityRest)) {

  $nameFilter = Restaurant::where('name', 'like', "%$cityRest%");

  $contactFilter = Restaurant::whereHas('contact', function ($contact) use ($cityRest) {

    $contact->where('address', 'like', "%$cityRest%");

    $contact->whereHas('city', function ($city) use ($cityRest) {
      $city->where('cityName', 'like', "%$cityRest%");
    });

  });

  $data = $data->union($nameFilter);
  $data = $data->union($contactFilter);
}

$data->get();

when searching for restaurant name,the results are returned correctly,but when searching for city names nothing is returned, although there is restaurants with contact models that has a city???

could you try using a `orWhereHas` instead of a `whereHas` inside your `contactFilter` e.g.: `$contact->orWhereHas('city'...` — Remul, Aug 15 '19 at 15:17

score 1 · Accepted Answer · answered Aug 16 '19 at 07:21

You have to use a orWhereHas instead of a whereHas.

With the whereHas you are searching for restaurants where the contact.address AND the city.name match your input.

By using the orWhereHas you are searching for restaurants where the contact.address OR the city.name match your input.

The AND and OR operators are used to filter records based on more than one condition:

The AND operator displays a record if all the conditions separated by AND are TRUE.
The OR operator displays a record if any of the conditions separated by OR is TRUE.

source

Try this:

$contactFilter = Restaurant::whereHas('contact', function ($contact) use ($cityRest) {

    $contact->where('address', 'like', "%$cityRest%");

    $contact->orWhereHas('city', function ($city) use ($cityRest) {
        $city->where('cityName', 'like', "%$cityRest%");
    });

});

score 0 · Answer 2 · answered Aug 15 '19 at 13:54

0

You are searching "%$cityRest%" as string.

I think it should be like this:

Restaurant::where('name', 'like', "%".$cityRest."%");

answered Aug 15 '19 at 13:54

kevinp1005

23
7

review php for string interpenetration,I should give you a vote down,but I won't – aghed aljlad Aug 15 '19 at 17:54

Laravel whereHas not getting any results?

2 Answers2