Level 73
Have you tried another order?
A::where('id', 1)->with('b')->with('c')->first();
Oct 13, 2021
20
Level 1
Laravel eager loading - one to many relation
Hello laravel dev.
I have three tables let's say A, B, C
A
-----------
-id
-main_location_id // **main location entry = 1**
B
-----------
-id
-a_id
-allocated_qty
C
-----------
-id
-a_id
-location_id // **main location enrty + other locations entry- 1,2,3**
-total_qty
-aval_qty
Relation:
table A has many of B
table A also has many of C
Query:
A::with(['B'])
->with(['C']) // here I got all location object from C tables, but I only want main_location_id = location_id data object + its qty
->where('a.id', 1)
->first();
I don't understand how will I get location_id, total_qty, aval_qty from table C through table A which has c.location_id = a.main_location_id
Even I don't know if I'm doing right?
is this possible?
please help me with this
Many thanks!
Level 1
@Tray2 yes I have tried, I'm getting same result
Level 73
Something like?
SELECT *
FROM a, b ,c
WHERE a.id = c.id
AND a.main_location_id = c.location_id
AND a.id = b.a_id
Level 1
@Tray2 Thanks for the reply
Yes I'm expecting the same result as you have mentioned in the raw query but don't get how to do with eager loading
Level 73
@M@rty Then use the select that I gave you with the db facade.
DB::select('SELECT *
FROM a, b ,c
WHERE a.id = c.id
AND a.main_location_id = c.location_id
AND a.id = b.a_id');
Level 1
@Tray2 Is there any way with eager loading, if yes then, please guide me for the same
because if I don't want to end up with an eloquent-resources collection for managing JSON response https://laravel.com/docs/8.x/eloquent-resources
Level 73
@M@rty In my example you would be using the query builder and that is what eloquent does behind the scenes. So it would be quite easy to convert it to json if you need to.
Level 63
If you use with(), the query will return all the fields of the relationship.
What information do you exactly want to retrieve ?
As a similar code, I generally do this.
A::with(['b'])->with(['c'])->find(1);
Level 1
@vincent15000 Actually,
with(['C'])
here I got all location objects from C tables, but I only want main_location_id = location_id data object + its total_qty, aval_qty
Level 63
@M@rty How have you declared the relationships in your A model ?
You should have something like this.
public function b()
{
return $this->hasMany('App\Models\B');
}
public function c()
{
return $this->hasMany('App\Models\C');
}
Level 1
@vincent15000 yes, right
Level 63
@M@rty Can you do a dd() of the result of your query and post it here ?
Level 1
@vincent15000 do you mean raw query, right?
Level 63
@M@rty I mean this.
$results = A::with(['b'])->with(['c'])->find(1);
dd($results);
Level 3
Hello, you can create hasMany relation with two condition using this package: https://github.com/topclaudy/compoships. It should solve your problem
Level 1
@jqodirov Do I have to create a separate model?
Level 3
@M@rty No you should add
use \Awobaz\Compoships\Compoships;
to your Model.
In your case relation:
public function c()
{
return $this->hasMany('C', ['a_id', 'location_id'], ['id', 'main_location_id']);
}
1 like
Level 1
@jqodirov Should I have to write inverse of the relationship?
Level 1
@jqodirov Thanks you are the savior!!!
Level 3
@M@rty No, you don't have to
Please or to participate in this conversation.