jeudi 8 décembre 2016

Laravel hasManyThrough, with belongs to

Not sure how clear is the question title, I will try to elaborate:

Tables:

repairs (Model: Repair):

id
id_supplier
id_store

suppliers (Model: Supplier):

id

store (Model: Store):

id

Relations:

Repair:

public function supplier() {
    return $this->belongsTo('App\Supplier', 'id_supplier');
}

Supplier:

public function repairs() {
    return $this->hasMany('App\Repair', 'id_supplier');
}

Store:

public function repairs() {
    return $this->hasMany('App\Repair', 'id_store');
}

What i need from here is to get all suppliers a given store worked with, through the repairs that were made there, so my first thought it was hasManyThrough :

Store:

public function suppliers() {
    return $this->hasManyThrough('App\Supplier', 'App\Repair', 'id_supplier', '<NO IDEIA WHAT'S HERE>');
}

What am I missing? Is this the right way?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire