A User can create Auctions and Auctions can have an appending Purchase.
I want to fetch all Purchases ( the one that HE SOLD - this user created an Auction and someone else purchased it) from one User by referencing via the Auctions table:
Auctions id | user_id
Purchases id | user_id | auction_id
My Auctions table has a column user_id, which has the same name as the column user_id from the table Purchases.
I thought I can fetch all Purchases with the hasManyThrough method like this:
User Model:
public function sold_purchases()
{
return $this->hasManyThrough(
'App\Purchase', 'App\Auction'
);
}
It works nearly as expected BUT:
The field user_id from the fetched results always has the user_id from the Auction it is referenced by and not the correct user_id as it is in the databse. As they have the same name I guess somehow this gets messed up.
Is there a way to give a synonym to one of those columns? Or am I doing something else wrong?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire