dimanche 7 avril 2019

How can I convert mysql to laravel eloquent left join?

Mysql query like this :

SELECT id, name, TotalMeal, TotalCollection
FROM users a
LEFT JOIN (SELECT user_id, SUM( braekfast + dinner + lanch ) AS TotalMeal
FROM meals
GROUP BY user_id)b ON a.id = b.user_id
LEFT JOIN (SELECT user_id, SUM( amount ) AS TotalCollection
FROM collections
GROUP BY user_id)c ON a.id = c.user_id
LIMIT 0 , 30


I want to convert it to laravel eloquent, but i'm confused.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire