/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

1 vote227 views1 answer
Laravel make:listner
PHP Laravel
2 votes224 views1 answer
Laravel get subdomain
PHP Laravel
0 vote232 views1 answer
Laravel deploy without moving public directory
PHP Laravel
7 votes236 views5 answers
Laravel remove public from url
PHP Laravel
0 vote255 views1 answer
Array helper array_push laravel
PHP Laravel
0 vote247 views1 answer
Laravel scheduler on shared hosting
PHP Laravel
0 vote250 views1 answer
Laravel package for getID3()
PHP Laravel
16 votes222 views4 answers
Add foreign key column laravel 5.8
PHP Laravel
21 votes205 views6 answers
Laravel seeder update
PHP Laravel
6 votes218 views3 answers
Laravel foreach loop index from 1
PHP Laravel