/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

0 vote206 views1 answer
Cloudinary laravel
PHP Laravel
0 vote196 views1 answer
Laravel replace white space with dash
PHP Laravel
1 vote204 views3 answers
Delete a migration laravel
PHP Laravel
21 votes235 views2 answers
Long text in laravel migration
PHP Laravel
1 vote196 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote194 views1 answer
Laravel collection forPage
PHP Laravel
0 vote184 views1 answer
Laravel apache public folder
PHP Laravel
7 votes226 views3 answers
Laravel where has
PHP Laravel
0 vote201 views1 answer
How to update all row in laravel
PHP Laravel
0 vote200 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel