/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

2 votes326 views2 answers
Laravel create migration file
PHP Laravel
0 vote306 views1 answer
Laravel login shows 404
PHP Laravel
2 votes370 views3 answers
Laravel migration drop foreign keys
PHP Laravel
5 votes394 views5 answers
Unique laravel migration
PHP Laravel
1 vote374 views1 answer
Laravel createmany example
PHP Laravel
9 votes392 views2 answers
Random string value laravel
PHP Laravel
1 vote377 views1 answer
Integer nullable laravel
PHP Laravel
13 votes382 views4 answers
Laravel make migration update table
PHP Laravel
11 votes356 views4 answers
Session variable in laravel
PHP Laravel
15 votes364 views3 answers
Laravel date set timezone
PHP Laravel