两个模型的雄辩查询

Question

I need your help, please! I have two models customer and membership. Customer hasMany Memberships. I need to extract all customers with a membership active. I did this but it extracts only memberships, without customers data. How can I change it to solve the problem?

Membership::has("customer")
    ->forCompany($companyId)
    ->whereIn('state', ['ATTIVA', 'IN ATTESA DI ESITO', 'DA INVIARE'])
    ->where(function ($query) {
        $query
            ->where('end_date', '>=', Carbon::now()->toDateString())
            ->orWhereNull('end_date');
    })

Answer 1

If you want the customers data with membership you must write the query from Customers model and not the Membership model. In case you want to eager load the membership with customers data, you must use with() method.

So here is the query you want:

$customers = Customer::whereHas("memberships",function($q) use ($companyId){

    return $q->forCompany($companyId)
              ->whereIn('state', ['ATTIVA', 'IN ATTESA DI ESITO', 'DA INVIARE'])
              ->where(function ($query) {
                   $query->where('end_date', '>=', Carbon::now()->toDateString())
                         ->orWhereNull('end_date');
               });

})->with('memberships')->get();

So, you can access the memberships of each customer like so:

foreach($customers as $customer)
    $memberships = $customer->memberships;

Notice : don't forget to define the membersips() method in Customer model. Remember to eager load the memberships with customer data using ->with() method. and don't forget to use ->get() at the end of query.

Here you can read about eager loading.