<?php
namespace app\admin\controller;

use support\Request;
use app\common\model\User;
use app\common\model\Order;
use app\common\model\Report;

class DashboardController
{
    public function stat(Request $request)
    {
        $today = date('Y-m-d');
        
        $stat = [
            'today_orders' => Order::where('created_at', '>=', $today . ' 00:00:00')->count(),
            'wait_receive_orders' => Order::whereIn('status', ['shipping', 'wait_receive'])->count(),
            'inspecting_orders' => Order::where('status', 'inspecting')->count(),
            'today_reports' => Report::where('created_at', '>=', $today . ' 00:00:00')->count(),
            'total_users' => User::count(),
            'total_amount' => Order::where('status', 'finished')->sum('total_price') ?? 0
        ];
        
        return jsonResponse($stat);
    }
}