/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

53 votes364 views6 answers
Laravel make seeder
PHP Laravel
0 vote189 views1 answer
Object of class stdclass could not be converted to string php laravel
PHP Laravel
42 votes160 views5 answers
Create controller laravel with model
PHP Laravel
22 votes165 views2 answers
Where status is null sql in laravel
PHP Laravel
0 vote155 views1 answer
Laravel move/rename file ftp
PHP Laravel
0 vote170 views1 answer
Back() with errors in laravel
PHP Laravel
3 votes156 views2 answers
Laravel find by field
PHP Laravel
3 votes166 views2 answers
Laravel route multiple methods
PHP Laravel
0 vote158 views1 answer
Skip model accessor laravel8
PHP Laravel
0 vote165 views1 answer
Laravel subtract date
PHP Laravel