So, let's say I have a table with just id, date, and sales. I want a laravel eloquent query that shows the accumulated sales so far for that date for the month. For example:

What I want:

The above table is what I want from Eloquent, the actual table is without Acc.

I don't want to create a new column, I just want to show the accumulated through the eloquent query. Thank you!

CodePudding user response：

is not clear if you have a model already, but you mention you want to use eloquend. Let's assume you have a model called Sales. In your controller:

$sales = Sales::all();

$accTotal = $sales->map(function($sale){
   $add  = $sale->acc;  
});

return $add;