/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 vote140 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
6 votes122 views4 answers
Laravel spatie asigne role
PHP Laravel
44 votes154 views6 answers
Call seeder laravel
PHP Laravel
0 vote137 views4 answers
Laravel upload image
PHP Laravel
0 vote125 views1 answer
Import facade URL laravel
PHP Laravel
0 vote124 views1 answer
Laravel storage save file folder on disk
PHP Laravel
2 votes159 views1 answer
Laravel test dbms connection
PHP Laravel
26 votes138 views6 answers
Drop foreign key laravel
PHP Laravel
2 votes178 views3 answers
Laravel get query result as array
PHP Laravel
0 vote142 views1 answer
Laravel list all tbales
PHP Laravel