mysql - 如果星期一至星期日，Laravel 从数据库中确定日期

Question

互联网上的 friend 们，你们好!

我有一个每周从数据库中获取数据的查询。现在我可以得到如下图所示的结果。

查询:

         return static::selectRaw('SUM(total) as total')
            ->selectRaw('COUNT(*) as total_orders')
            ->whereBetween('created_at', [now()->startOfWeek(), now()->endOfWeek()])
            ->whereNotIn('status', ['canceled', 'refunded'])
            ->selectRaw('EXTRACT(DAY FROM created_at) as day')
            ->groupBy(DB::raw('EXTRACT(DAY FROM created_at)'))
            ->orderby('day')
            ->get();

在我的 Controller 中

        return response()->json([
            'data' => Order::salesAnalytics(),
        ]);

结果

The problem is how can I show it to my chartjs like this see picture below.

Answer 1

您可以使用此数组根据日期编号确定日期名称

days_numbers = [
 0 => 'saturday',
 1 => 'sunday',
 2 => 'monday',
 3 => 'thuesday',
 4 => 'wednesday',
 5 => 'thursday',
 6 => 'friday',
];

您可以使用它来获取日期索引:

$day_index = fmod($day_number, 7);