/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 votes360 views2 answers
Laravel get column field name
PHP Laravel
0 vote380 views1 answer
Laravel check if model relation exists
PHP Laravel
0 vote370 views1 answer
Laravel role
PHP Laravel
1 vote373 views1 answer
Laravel form action with parameter
PHP Laravel
7 votes342 views4 answers
Laravel chunk
PHP Laravel
1 vote371 views1 answer
Select sum in laravel
PHP Laravel
2 votes345 views3 answers
Laravel fortify
PHP Laravel
0 vote367 views1 answer
Laravel run seeder enter timestamps
PHP Laravel
16 votes372 views4 answers
Add foreign key column laravel 5.8
PHP Laravel
1 vote328 views1 answer
Persian error laravel
PHP Laravel