Laravel where on relationship object

Question

I m developing a web API with Laravel 5 0 but I m not sure about a specific query I m trying to build   My classes are as follows   class Event extends Model        protected  table    events       public  timestamps   false       public function participants                 return  this- gt hasMany  App Participant    IDEvent    ID               public function owner                 return  this- gt hasOne  App User    ID    IDOwner              and  class Participant extends Model        protected  table    participants       public  timestamps   false       public function user                 return  this- gt belongTo  App User    IDUser    ID               public function event                 return  this- gt belongTo  App Event    IDEvent    ID              Now  I want to get all the events with a specific participant  I tried with   Event  with  participants  - gt where  IDUser   1 - gt get      but the where condition is applied on the Event and not on its Participants  The following gives me an exception   Participant  where  IDUser   1 - gt event  - gt get      I know that I can write this    list   Participant  where  IDUser   1 - gt get    for  item in  list        event    item- gt event            other code         but it doesn t seem very efficient to send so many queries to the server   What is the best way to perform a where through a model relationship using Laravel 5 and Eloquent

User · Answer

I created a custom query scope in BaseModel (my all models extends this class):

/**
 * Add a relationship exists condition (BelongsTo).
 *
 * @param  Builder        $query
 * @param  string|Model   $relation   Relation string name or you can try pass directly model and method will try guess relationship
 * @param  mixed          $modelOrKey
 * @return Builder|static
 */
public function scopeWhereHasRelated(Builder $query, $relation, $modelOrKey = null)
{
    if ($relation instanceof Model && $modelOrKey === null) {
        $modelOrKey = $relation;
        $relation   = Str::camel(class_basename($relation));
    }

    return $query->whereHas($relation, static function (Builder $query) use ($modelOrKey) {
        return $query->whereKey($modelOrKey instanceof Model ? $modelOrKey->getKey() : $modelOrKey);
    });
}

You can use it in many contexts for example:

Event::whereHasRelated('participants', 1)->isNotEmpty(); // where has participant with id = 1

Furthermore, you can try to omit relationship name and pass just model:

$participant = Participant::find(1);
Event::whereHasRelated($participant)->first(); // guess relationship based on class name and get id from model instance

User · Answer

return Deal  with   redeem    gt  function  q            q- gt where  user id        1          - gt get      this worked for me

User · Answer

With multiple joins  use something like this code   someId   44  Event  with   quot owner quot    quot participants quot    gt  function  q  use  someId        q- gt where  participants IdUser        1          q- gt where  some other field    someId

User · Answer

OOT  A bit OOT  but this question is the most closest topic with my question  Here is an example if you want to show Event where ALL participant meet certain requirement  Let s say  event where ALL the participant has fully paid  So  it WILL NOT return events which having one or more participants that haven t fully paid   Simply use the whereDoesntHave of the others 2 statuses  Let s say the statuses are haven t paid at all  eq 1   paid some of it  eq 2   and fully paid  eq 3  Event  whereDoesntHave  participants   function   query       return  query- gt whereRaw  payment   1 or payment   2      - gt get     Tested on Laravel 5 8 - 7 x

User · Answer

The correct syntax to do this on your relations is   Event  whereHas  participants   function   query        return  query- gt where  IDUser        1     - gt get      Read more at https   laravel com docs 5 8 eloquent-relationships eager-loading

User · Answer

Cermbo s answer is not related to this question  In their answer  Laravel will give you all Events if each Event has  participants  with IdUser of 1   But if you want to get all Events with all  participants  provided that all  participants  have a IdUser of 1  then you should do something like this    Event  with   participants    gt  function  q        q- gt where  participants IdUser        1         N B   in where use your table name  not Model name

[php] Laravel where on relationship object

Examples related to php

Examples related to laravel

Examples related to eloquent

Examples related to relationship

Examples related to where-clause