/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 vote237 views1 answer
Required_unless laravel
PHP Laravel
0 vote209 views1 answer
Laravel chain query builder
PHP Laravel
0 vote206 views1 answer
File original extensions laravel
PHP Laravel
2 votes198 views2 answers
Empty table in laravel
PHP Laravel
2 votes188 views2 answers
Confirm popup laravel
PHP Laravel
0 vote198 views1 answer
Laravel mail success or failure
PHP Laravel
3 votes228 views1 answer
Sms laravel
PHP Laravel
1 vote189 views3 answers
Laravel invoice toturial
PHP Laravel
1 vote230 views2 answers
If null blade laravel
PHP Laravel
7 votes221 views3 answers
Laravel seed migrate
PHP Laravel