bike-admin/app/Http/Controllers/Admin/RechargeOrderController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Filters\RechargeOrderFilter;
use App\Http\Resources\RechargeOrderResource;
use App\Models\AdminMerchant;
use App\Models\AdminUser;
use App\Models\RechargeOrder;
use App\Utils\Admin;
use Carbon\Carbon;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

class RechargeOrderController extends Controller
{
    /**
     * index
     *
     * @param Request $request
     * @param RechargeOrderFilter $rechargeOrderFilter
     * @return \Illuminate\Http\JsonResponse
     * @author Fx
     *
     */
    public function index(Request $request, RechargeOrderFilter $rechargeOrderFilter)
    {
        //
        $rechargeOrder = RechargeOrder::query()->filter($rechargeOrderFilter)
            ->where(AdminMerchant::getMerchantWhere())->with(['areas', 'users'])->orderByDesc('id');
        $admin_id = Admin::user()->id;
        $area_ids = AdminUser::getAreaIdsByAdminId($admin_id);
        $rechargeOrder = $rechargeOrder->where(function ($q) use ($area_ids) {
            $q->whereIn('area_id', $area_ids)->orWhere('area_id', 0);
        });

        $rechargeOrder = $request->get('all') ? $rechargeOrder->get() : $rechargeOrder->paginate();

        return $this->ok(RechargeOrderResource::collection($rechargeOrder));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param \Illuminate\Http\Request $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param int $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param int $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param \Illuminate\Http\Request $request
     * @param int $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param int $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }


    /**
     * 统计充值  当日  当月 statisticsRecharge
     *
     * @param RechargeOrderFilter $rechargeOrderFilter
     * @return \Illuminate\Http\JsonResponse
     * @author Fx
     *
     */
    public function statisticsRecharge(Request $request, RechargeOrderFilter $rechargeOrderFilter)
    {
        $merchant_id = $request->get('merchant_id') ?? '';
        $area_id = $request->get('area_id') ?? '';


        // 本日充值
        $todayRechargeModel = RechargeOrder::query()->filter($rechargeOrderFilter)
            ->where('status', RechargeOrder::PAY_STATUS_OK)
            ->where(AdminMerchant::getMerchantWhere())
            ->where('created_at', '>', Carbon::today());
        if ($merchant_id) $todayRechargeModel->where('merchant_id', $merchant_id);
        if ($area_id) $todayRechargeModel->where('area_id', $area_id);
        $todayRecharge = $todayRechargeModel->sum('pay_money');
        // 本月充值
        $first_day = date('Y-m-01', strtotime(Carbon::today())); //每月一号
        $thisMonthRechargeModel = RechargeOrder::query()->filter($rechargeOrderFilter)
            ->where('status', RechargeOrder::PAY_STATUS_OK)
            ->where(AdminMerchant::getMerchantWhere())
            ->where('created_at', '>', $first_day);
        if ($merchant_id) $thisMonthRechargeModel->where('merchant_id', $merchant_id);
        if ($area_id) $thisMonthRechargeModel->where('area_id', $area_id);
        $thisMonthRecharge = $thisMonthRechargeModel->sum('pay_money');

        return $this->ok([
            'todayRecharge' => $todayRecharge,
            'thisMonthRecharge' => $thisMonthRecharge
        ]);
    }

    /**
     * 总充值 totalRecharge
     *
     * @param RechargeOrderFilter $rechargeOrderFilter
     * @return \Illuminate\Http\JsonResponse
     * @author Fx
     *
     */
    public function totalRecharge(RechargeOrderFilter $rechargeOrderFilter)
    {
        $totalRecharge = RechargeOrder::query()->where(AdminMerchant::getMerchantWhere())->filter($rechargeOrderFilter)
            ->where('status', RechargeOrder::PAY_STATUS_OK)
            ->sum('pay_money');
        return $this->ok($totalRecharge);
    }

    public function rechargeChart(Request $request, RechargeOrderFilter $rechargeOrderFilter)
    {
        $dateBetween = $request->get('dateBetween') ?? '';
        $merchant_id = $request->get('merchant_id') ?? '';
        $area_id = $request->get('area_id') ?? '';

        if (!empty($dateBetween)) {
            $deposit_statistic_date_start = Carbon::parse($dateBetween[0])->subDay()->format('Y-m-d');
            $deposit_statistic_date_end = Carbon::parse($dateBetween[1])->format('Y-m-d');
        } else {
            $deposit_statistic_date_start = date('Y-m-d', strtotime("-8 day"));
            $deposit_statistic_date_end = Carbon::today();
        }

        $chartsModel = RechargeOrder::query()->filter($rechargeOrderFilter)
            ->where(AdminMerchant::getMerchantWhere())
            ->where('created_at', '>', $deposit_statistic_date_start)
            ->where('created_at', '<', $deposit_statistic_date_end);
        if ($merchant_id) $chartsModel->where('merchant_id', $area_id);
        if ($area_id) $chartsModel->where('area_id', $area_id);
        $charts = $chartsModel->selectRaw('DATE_FORMAT(created_at,"%Y/%m/%d") as date,sum(pay_money) as value')
            ->groupBy('date')->get();
        return $this->ok($charts);
    }
}