/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

16 votes138 views3 answers
Laravel request validate
PHP Laravel
0 vote169 views1 answer
Laravel Customizing Missing Model Behavior
PHP Laravel
0 vote135 views2 answers
Laravel loop variable
PHP Laravel
0 vote140 views2 answers
Laravel permission to vuejs
PHP Laravel
7 votes128 views2 answers
Last recode of DB using laravel
PHP Laravel
0 vote136 views1 answer
How to get post by comment in laravel
PHP Laravel
0 vote133 views2 answers
Count with condition laravel
PHP Laravel
1 vote133 views2 answers
How set field after another field in migration in laravel
PHP Laravel
0 vote148 views1 answer
Laravel toastr option
PHP Laravel
1 vote144 views1 answer
How can set defult value for yield in laravel
PHP Laravel