/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 vote144 views1 answer
Laravel 8 Pagination Ui Problem
PHP Laravel
26 votes225 views6 answers
Laravel make model with migration and controller
PHP Laravel
0 vote164 views4 answers
Image Upload in Laravel
PHP Laravel
0 vote131 views2 answers
Laravel join query sum example
PHP Laravel
15 votes146 views4 answers
Laravel session flash 2020
PHP Laravel
2 votes145 views3 answers
Laravel subdays
PHP Laravel
7 votes148 views5 answers
Laravel if else condition in blade file
PHP Laravel
1 vote142 views1 answer
Class 'illuminate support facades input' not found laravel 7
PHP Laravel
10 votes150 views6 answers
Format time laravel
PHP Laravel
0 vote138 views6 answers
Hash password decrypt laravel
PHP Laravel