0

I am taking sum of all orders by week, month and year. My code is like this:

$current_day = Order::whereDate('created_at', Carbon::today())
                    ->where('order_status', 'Complete')
                    ->sum('total_amount');
$current_week = Order::whereBetween('created_at', [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()])
                    ->where('order_status', 'Complete')
                    ->sum('total_amount');
$current_month = Order::whereMonth('created_at', date('m'))
                    ->whereYear('created_at', date('Y'))
                    ->where('order_status', 'Complete')
                    ->sum('total_amount');

How can I take all this information by one SQL request?

Improve this question
3
Related questions
2769
How can I prevent SQL injection in PHP?
4342
How do I UPDATE from a SELECT in SQL Server?
3327
How to add a column with a default value to an existing table in SQL Server?
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.