lundi 27 avril 2020

Laravel - Count of items through with belongs to

A company can have many delivery dates. A delivery date may have many entries. The Entry model contains

public function company()
{
    return $this->belongsTo(Company::class);
}

public function delivery_date()
{
    return $this->belongsTo(MgDeliveryDate::class,  'mg_delivery_date_id');
}

What I want is a count of how many entries each delivery date has for each company. For example, something like

$companies = Company->with('delivery_dates', 'delivery_dates.entries')->withCount('delivery_dates.entries')

So if my data was

Company            Delivery Date          Entry Number
   A                   1/2/2020                1
   A                   1/2/2020                2
   A                   2/2/2020                3
   B                   1/2/2020                4

I would get two companies, company A with two delivery dates and a count of 2 for the first date(1/2/2020) and 1 for the second date(2/2/2020) and company B with one delivery date, with an entry count of 1.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire