/PHP/Laravel/Laravel eloquent get 3 months

Laravel eloquent get 3 months

$dateS = Carbon::now()->startOfMonth()->subMonth(3);
$dateE = Carbon::now()->startOfMonth(); 
$TotalSpent = DB::table('orders')
->select('total_cost','placed_at')
->whereBetween('placed_at',[$dateS,$dateE])
->where(['deleted' => '0', 'delivery_address_id' => $DeliveryAddress->id])
->sum('total_cost');

Source: stackoverflow.com

Similar codes

13 votes345 views3 answers
How to change existing migration laravel
PHP Laravel
0 vote356 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel
1 vote331 views2 answers
Laravel migration check if table has column
PHP Laravel
0 vote312 views3 answers
Laravel model where in
PHP Laravel
1 vote341 views1 answer
Foreign key nullable in laravel
PHP Laravel
1 vote352 views1 answer
Laravel artisan progress bar
PHP Laravel
5 votes308 views2 answers
Laravel collection chunk
PHP Laravel
4 votes340 views3 answers
Laravel check environment hlper
PHP Laravel
15 votes333 views3 answers
Laravel date set timezone
PHP Laravel
3 votes330 views6 answers
Laravel cors
PHP Laravel