bot-28/app/Http/Controllers/admin/Home.php

<?php

namespace App\Http\Controllers\admin;

use App\Constants\HttpStatus;
use App\Http\Controllers\Controller;
use App\Models\PaymentOrder;
use App\Models\Recharge;
use App\Models\User;
use App\Services\PaymentOrderService;
use Illuminate\Validation\ValidationException;
use Exception;
use Carbon\Carbon;
use App\Models\Withdraw;

class Home extends Controller
{
    public function index()
    {

        try {
            request()->validate([
                'start_date' => ['nullable', 'date_format:Y-m-d'],
                'end_date' => ['nullable', 'date_format:Y-m-d', 'after_or_equal:start_date'],
            ]);

            $start = request()->input('start_date');
            $end = request()->input('end_date');
            if (empty($end)) $end = date('Y-m-d');
            if (empty($start)) $start = date('Y-m-d');
            $end = Carbon::createFromFormat('Y-m-d', $end)->addDay()->format('Y-m-d');

            //新增会员统计
            $query = User::query();
            $query->where('from','<>',2)->whereBetween('created_at', [$start, $end]);
            $totalUser = (float)$query->count('id');
            
            $query = PaymentOrder::query();
            $query->whereBetween('created_at', [$start, $end]);
            $query1 = clone $query;
            $totalAmount = (float)$query1->where('type', 2)->sum('amount');


            $query1 = clone $query;
            $totalPending = (float)$query1->where('type', 2)->where('status', 0)->sum('amount');
            $query1 = clone $query;
            $totalProcessing = (float)$query1->where('type', 2)->where('status', 1)->sum('amount');
            $query1 = clone $query;
            $totalSuccess = (float)$query1->where('type', 2)->where('status', 2)->sum('amount');
            $query1 = clone $query;
            $totalFail = (float)$query1->where('type', 2)->where('status', 3)->sum('amount');


            $query1 = clone $query;
            $rechargeRmbTotalAmount = (float)$query1->where('type', 1)->sum('amount');
            $query1 = clone $query;
            $rechargeRmbTotalPending = (float)$query1->where('type', 1)->where('status', 0)->sum('amount');
            $query1 = clone $query;
            $rechargeRmbTotalProcessing = (float)$query1->where('type', 1)->where('status', 1)->sum('amount');
            $query1 = clone $query;
            $rechargeRmbTotalSuccess = (float)$query1->where('type', 1)->where('status', 2)->sum('amount');
            $query1 = clone $query;
            $rechargeRmbTotalFail = (float)$query1->where('type', 1)->where('status', 3)->sum('amount');


            $query = Withdraw::query();
            $query->whereBetween('created_at', [$start, $end]);
            $query1 = clone $query;
            $usdTotalAmount = (float)$query1->sum('amount');
            $query1 = clone $query;
            $usdTotalSuccess = (float)$query1->where('status', 1)->sum('amount');
            $query1 = clone $query;
            $usdTotalFail = (float)$query1->where('status', 2)->sum('amount');


            $query = Recharge::query();
            $query->whereBetween('created_at', [$start, $end]);
            $query1 = clone $query;
            $rechargeTotalAmount = (float)$query1->sum('amount');
            $query1 = clone $query;
            $rechargeTotalSuccess = (float)$query1->where('status', 1)->sum('amount');
            $query1 = clone $query;
            $rechargeTotalFail = (float)$query1->where('status', 2)->sum('amount');

            $result = [
                'start' => $start,
                'end' => $end,
                'recharge_usd' => [
                    'total_amount' => $rechargeTotalAmount,
                    'total_success' => $rechargeTotalSuccess,
                    'total_fail' => $rechargeTotalFail,
                ],
                'recharge_rmb' => [
                    'total_amount' => $rechargeRmbTotalAmount,
                    'total_success' => $rechargeRmbTotalSuccess,
                    'total_fail' => $rechargeRmbTotalFail,
                    'total_processing' => $rechargeRmbTotalProcessing,
                    'total_pending' => $rechargeRmbTotalPending
                ],

                'withdraw_usdt' => [
                    'total_fail' => $usdTotalFail,
                    'total_success' => $usdTotalSuccess,
                    'total_amount' => $usdTotalAmount,
                ],
                'withdraw_rmb' => [
                    'total_fail' => $totalFail,
                    'total_success' => $totalSuccess,
                    'total_amount' => $totalAmount,
                    'total_processing' => $totalProcessing,
                    'total_pending' => $totalPending
                ],
                'total_user' => $totalUser,

            ];
        } catch (ValidationException $e) {
            return $this->error(HttpStatus::CUSTOM_ERROR, $e->validator->errors()->first());
        } catch (Exception $e) {
            return $this->error($e->getCode(), $e->getmessage());
        }
        return $this->success($result);
    }
}