Laravel many through relation filter using single where condition

Question

I have set of users, customers and they are related, and it will change every month, my requirement is get active month user for customers.

My Customer Model


public function executives()
    {
        return $this->belongsToMany(User::class, 'user_customer_mapping', 'user_customer_mapping_customer_id', 'user_customer_mapping_user_id');
    }

user_customer_mapping table have a Column for month with values like (Y-m), i need to find "2020-10" executive for all customers


$month= '2020-10';
$Executive = $customer->executives()->where('user_farmer_mapping_season', $month)->first();
return ($fieldExecutive) ? $fieldExecutive->name : 'N/A';

Brian Lee · Accepted Answer · 2020-11-25 05:50:07Z

1

Start by adding withPivot to your relationship so the additional pivot table columns are loaded also:

public function executives()
{
    return $this->belongsToMany(User::class, 'user_customer_mapping', 'user_customer_mapping_customer_id', 'user_customer_mapping_user_id')
                ->withPivot('month');
}

Next, use wherePivot to query against the pivot table column(s):

$month= '2020-10';
$Executive = $customer->executives()->wherePivot('month', $month)->first();
return ($fieldExecutive) ? $fieldExecutive->name : 'N/A';

answered Nov 25, 2020 at 5:50

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel many through relation filter using single where condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related