test/app/Http/Controllers/Admin/NumController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

/**
 * 每日数据
 * Class NumController
 * @package App\Http\Controllers\Admin
 */
class NumController extends Controller
{
    //每日数据仪表
    public function index()
    {
        $ymdList = [];
        for ($i = 1; $i <= 7; $i++) {
            $ymdList[] = date('Ymd', strtotime('-' . $i . ' day'));
        }

        $numList = DB::table('num')
            ->selectRaw('SUM(traffic) AS traffic,SUM(inquire) AS inquire,SUM(top10) AS top10,ymd')
            ->whereIn('ymd', $ymdList)
            ->groupBy('ymd')->get()->keyBy('ymd')->toArray();
        $trafficY = $inquireY = $keywordY = [];
        foreach ($ymdList as $ymd) {
            $trafficY[] = $numList[$ymd]->traffic ?? 0;
            $inquireY[] = $numList[$ymd]->inquire ?? 0;
            $keywordY[] = $numList[$ymd]->top10 ?? 0;
        }

        return view('admin.num.index', [
            'trafficLine' => [
                'xAxis' => $ymdList,
                'yAxis' => $trafficY,
            ],
            'inquireLine' => [
                'xAxis' => $ymdList,
                'yAxis' => $inquireY,
            ],
            'keywordLine' => [
                'xAxis' => $ymdList,
                'yAxis' => $keywordY,
            ],
        ]);
    }
}