/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 vote340 views1 answer
Laravel get week dates
PHP Laravel
0 vote329 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP Laravel
0 vote359 views2 answers
Laravel collection keys
PHP Laravel
0 vote362 views1 answer
Laravel eloquent save method return value
PHP Laravel
1 vote313 views2 answers
Time left laravel seconds
PHP Laravel
-1 vote379 views1 answer
Create user with tinker php laravel
PHP Laravel
16 votes305 views4 answers
Laravel auth helper function
PHP Laravel
5 votes315 views2 answers
Laravel collection chunk
PHP Laravel
0 vote327 views1 answer
Laravel create pivot migration
PHP Laravel
18 votes313 views4 answers
Protected table laravel
PHP Laravel