Eloquent withSum Extra Calculation: SubSelect with Raw Query

In this video, I want to show a Laravel Eloquent trick on how to calculate the aggregated data before the aggregation.
Links I've mentioned:
- Spatie Ray: spatie.be/prod...
- Eloquent Subquery Enhancements in Laravel 6.0 laravel-news.c...
- Eloquent Performance Patterns: eloquent-cours...
- - - - -
Support the channel by checking out our products:
- Enroll in my Laravel courses: laraveldaily.t...
- Try our Laravel QuickAdminPanel: bit.ly/quickad...
- Buy my ready-made Laravel scripts: laraveldaily.g...
- Purchase my Livewire Kit: livewirekit.com
- Subscribe to my weekly newsletter: bit.ly/laravel-...

[@intipontt7490]

KZbin is marking my comments as spam it seems. The solution is to use the withAggregate function. Check the source code for the withSum method to see how it works. It' is the method called in the background.

[@intipontt7490]

withAggregate('items as total_price', 'sum(quantity * price)')

[@LaravelDaily]

Wow, didn't think about that one. Interesting how brain works: I really KNEW about this function, but when I get the chance to actually use it, my mind didn't "show" it to me :) Thanks!

[@intipontt7490]

@@LaravelDaily It's not commonly used. The same thing happens to me when I need to add a HAVING clause to my query. I always try to add it inside the WHERE clause, making it throw errors until someone on stackoverflow reminds me it exists for that specific reason.

[@gianfrancobriones]

Why did I just know this now 😭

[@yashpatel7291]

I have 4 years of experience in laravel but I didn't use laravel sub query in my project. 🤭 I will implement that anyway this video impressive for me

[@RedempleMarcelo]

GREATE IHAVE LARAVEL TIPS TOO

[@AlbertCloete]

When those eloquent functions become too complicated I rather just write SQL. I feel it's easier to write and understand. Most people can read SQL easily.

[@oxunjonrahmonov4728]

I searched for this thing for 1 hour, thank you very much

[@AldhiAlbadri]

this channel is very complete discussing laravel..but i still stuck in english language..nice video nice course..

[@spartacusyusuf9989]

I used subSelect but my problem is ordering the result or searching the column when it has an alias

[@renwar]

Not the elegant way, but I am using this: use Illuminate\Database\Eloquent\Builder; use Illuminate\Database\Query\Expression; Order::withSum(['items' => function (Builder $query) { $query->select(new Expression('sum((`items`.`quantity`) * (`items`.`price`)) AS totalPrice')); }], 'totalPrice');

[@intipontt7490]

Isn't new Expression(...) the same as DB::raw(...) ?

[@renwar]

@@intipontt7490 you can't use DB::raw inside "withSum" function.

[@firdavs.ibodullayev]

Thanx for video

[@fajarsetiawansiagian]

thanks for this informatin. i dont think if we can use subquery for this

[@aneeshn933]

machan onnum manasilayilla

[@Xadios7]

Thank youuu

[@NotBeHaris]

Can anyone help me in this query. That i have posts and views so now i want to show popular day and week when most views comes.

[@free2idol1]

can you show your migration and eloquent relation?

[@RedempleMarcelo]

tHANK YOU

Is this method will cause n+1 issue?

[@LaravelDaily]

It shouldn't. But, to be honest, I didn't check.

[@dearlorddd]

@@LaravelDaily I tested it, it is doing a subselect in the query.

[@RedempleMarcelo]

THANK YOU

[@fendysusanto4873]

@@LaravelDaily btw, how to group by(some key) the result? thanks

[@azzamydev]

@@LaravelDaily In my project, n+1 problems occurred

[@LostInAutism]

With my limited knowledge of Laravel, wouldn't it work if you included the table prefixed to the columns? Ex: items.quantity * items.price Appreciate the videos! You always post videos that relate to my current projects and I appreciate that 😊

[@RedempleMarcelo]

THANK YOU