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:

- - - - -
Support the channel by checking out our products:

Laravel Daily

Рекомендации по теме

Комментарии

Youtube 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.

intipontt

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

yashpatel

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.

AlbertCloete

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

oxunjonrahmonov

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

AldhiAlbadri

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

spartacusyusuf

Not the elegant way, but I am using this:

use
use

Order::withSum(['items' => function (Builder $query) {
$query->select(new * (`items`.`price`)) AS totalPrice'));
}], 'totalPrice');

renwar

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

fajarsetiawansiagian

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.

NotBeHaris

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 😊

LostInAutism

Eloquent withSum Extra Calculation: SubSelect with Raw Query

Eloquent withSum Extra Calculation: SubSelect with Raw Query

Laravel SubSelect Example: addSelect VS Collection Map

Laravel Eloquent Advanced Subqueries

3 Eloquent Methods You Did Not Know for Selecting Specific Columns #laravel #shorts

Laravel Advanced Eloquent | order using subquery

Laravel Eloquent Tips - Work with Advance Subqueries in Eloquent

withSum, withMax, with...() Methods - Eloquent Tricks

New in Laravel 8: withSum/withMax/withAvg on Relationships

Eloquent withCount with Conditions and Aliases

Eloquent Example: Group Data with Multiple Calculations

Increase Your Laravel Speed with This Game-Changing Subquery AddSelect Technique!

SQL : Laravel Eloquent: sum with groupBy

MySQL : Join and SUM in Laravel ELoquent

Laravel Advanced Subqueries | Subquery Ordering

Eloquent: 3 Ways to Sum Pivot Column in Many-to-Many Relationship

PHP : Laravel Eloquent Sum of relation's column

How to Easily Retrieve The Sum of Related Records in Laravel #laravel #shorts

Laravel 10 Fundamental [Part 96] - Query Builder - Using Subquery

Laravel 9 - Exemples avancées de requêtes Eloquent

Laravel Eloquent Sub Query

Laravel Eloquent Report: Group By Year with Raw Queries

MySQL : How to get sum of two different columns with Laravel Query Builder?

Laravel Eloquent Tips - Work with `withMin` and `withMax` and `withAvg` method in Eloquent

Laravel Joining | Laravel Subquery join | Laravel 8 | Laravel tutorial | Learning Points