How to use laratrust roles in where condition ?

I need to show only records in which 'senderid' user has role('broker'). How can I use this condition in the controller ? I am using laratrust for roles management.

        $enquiries = BusinessLead::where('receiverid', $id)->where('status',1)->orderBy('id','DESC')->paginate(25);

MichalOravec

3 years ago

Level 75

$enquiries = BusinessLead::where('receiverid', $id)
    ->where('status', 1)
    ->whereHas('sender', function ($query) {
        $query->hasRole('broker');
    })
    ->orderByDesc('id')
    ->paginate(25);

I assume sender is an relationship to user by senderid.

1 like

FounderStartup

3 years ago

Level 5

@MichalOravec Thanks for your time. I am getting the following error :

Call to undefined method Illuminate\Database\Eloquent\Builder::hasRole()

My model :

class BusinessLead extends Model
{
    use HasFactory;
    protected $guarded = [];

    public function sender(){
        return $this->belongsTo(User::class,'senderid','id');
    }
}

MichalOravec

3 years ago

Best Answer

Level 75

@FounderStartup Try to use whereRoleIs('broker') instead of hasRole('broker') in the query above.

https://laratrust.santigarcor.me/docs/7.x/usage/querying-relationships.html#by-role

1 like

FounderStartup

3 years ago

Level 5

@MichalOravec Yes it worked. Thanks a lot ! :) You are a genius :)

Please or to participate in this conversation.