Comments (4)
staudenmeir
commented on August 16, 2024
Hi @mokhosh,
Have you compared the executed queries of $user->products()->get() vs. $user->products?
Does the users table have a column named products by any chance?
from eloquent-has-many-deep.
mokhosh
commented on August 16, 2024
This is the query for products()->get():
select `products`.*, `purchases`.`user_id` as `laravel_through_key` from `products` inner join `product_purchase` on `product_purchase`.`product_id` = `products`.`id` inner join `purchases` on `purchases`.`id` = `product_purchase`.`purchase_id` where `purchases`.`user_id` = 1;and this is the one for products property:
select `products`.*, `cart_product`.`cart_id` as `pivot_cart_id`, `cart_product`.`product_id` as `pivot_product_id`, `cart_product`.`quantity` as `pivot_quantity` from `products` inner join `cart_product` on `products`.`id` = `cart_product`.`product_id` where `cart_product`.`cart_id` = 1I don't have products field on users table.
from eloquent-has-many-deep.
staudenmeir
commented on August 16, 2024
Please share the whole User model.
from eloquent-has-many-deep.
mokhosh
commented on August 16, 2024
🤦♂️
I started removing irrelevant code from the model to share it here and I found this:
public function getProductsAttribute()
{
return $this->cart->products;
}Sorry for taking your time. Thanks!
from eloquent-has-many-deep.
Related Issues (20)
- Using with a Belongs To Many? HOT 1
- Data duplication on hasManyTrough with pivot HOT 3
- Relations not shown in artisan command model:show HOT 3
- Ambigious column reference 'id' HOT 1
- I can't get to conclude this relationship HOT 1
- HasOneTrhough MorphOne HOT 1
- issue with composite keys when doing a relation between 2 tables HOT 2
- collision with compoships HOT 1
- need help with hasManyDeep with belongsTo HOT 2
- distinct - paginate HOT 1
- Public Page -> belongsTo CompanyBranch -> morphMany Addresses HOT 1
- HasManyDeep Relation Issue HOT 2
- relations eager loading HOT 2
- I'm getting the results for all users - help please HOT 3
- Pivots not returned the same way HOT 3
- HasOneDeep is not generic HOT 5
- Laravel 11 HOT 4
- CompositeKey not included when installed. HOT 3
- Select without laravel_through_key doesnt return query result with PHP while query direct on db does HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from eloquent-has-many-deep.