/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 vote179 views1 answer
Laravel list get x amount in a collection
PHP Laravel
33 votes182 views4 answers
Carbon format date in laravel
PHP Laravel
2 votes178 views2 answers
Check if date between two dates laravel
PHP Laravel
24 votes163 views6 answers
Validation error message in laravel
PHP Laravel
0 vote179 views3 answers
Laravel migration softdelete
PHP Laravel
8 votes183 views3 answers
Laravel date between
PHP Laravel
0 vote186 views2 answers
Get http host laravel
PHP Laravel
18 votes174 views6 answers
Wherein laravel
PHP Laravel
15 votes169 views4 answers
Change existing migration laravel
PHP Laravel
1 vote170 views1 answer
Laravel map array
PHP Laravel