/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

4 votes274 views2 answers
Laravel sum group by
PHP Laravel
0 vote288 views1 answer
How to clear artisan in laravel
PHP Laravel
0 vote241 views2 answers
Laravel blade empty
PHP Laravel
0 vote333 views2 answers
Laravel rename file ftp
PHP Laravel
0 vote263 views1 answer
Update function laravel 7
PHP Laravel
1 vote292 views2 answers
Url segment in laravel
PHP Laravel
7 votes270 views4 answers
Laravel blade uppercase
PHP Laravel
1 vote294 views3 answers
Unique check two clolumn in laravel validation
PHP Laravel
0 vote284 views1 answer
Form validation nullable laravel
PHP Laravel
0 vote261 views3 answers
Laravel model where in
PHP Laravel