huahuibao/app-ghs/controllers/StatKdController.php

<?php

namespace ghs\controllers;

use biz\stat\classes\StatKdClass;
use biz\stat\classes\StatRefundClass;
use common\components\dateUtil;
use Yii;
use common\components\util;

class StatKdController extends BaseController
{

    //开单收入统计 ssh 20211017
    public function actionProfile()
    {
        $get = Yii::$app->request->get();
        $where = [];
        $where['mainId'] = $this->mainId;
        $searchTime = $get['searchTime'] ?? 'today';
        if (!empty($searchTime)) {
            $startTime = $get['startTime'] ?? '';
            $endTime = $get['endTime'] ?? '';
            $period = dateUtil::formatTime($searchTime, $startTime, $endTime, true);
            $where['time'] = ['between', [$period['startTime'], $period['endTime']]];
        }
        $kdList = StatKdClass::getAllByCondition($where, null, '*');
        $kd = ['wx' => 0, 'alipay' => 0, 'balance' => 0, 'cash' => 0, 'bank' => 0, 'debt' => 0, 'amount' => 0];
        if (!empty($kdList)) {
            foreach ($kdList as $key => $item) {
                $kd['wx'] = bcadd($kd['wx'], $item['wx'], 2);
                $kd['alipay'] = bcadd($kd['alipay'], $item['alipay'], 2);
                $kd['balance'] = bcadd($kd['balance'], $item['balance'], 2);
                $kd['cash'] = bcadd($kd['cash'], $item['cash'], 2);
                $kd['bank'] = bcadd($kd['bank'], $item['bank'], 2);
                $kd['debt'] = bcadd($kd['debt'], $item['debt'], 2);
                $kd['amount'] = bcadd($kd['amount'], $item['amount'], 2);
            }
        }
        $refund = ['wx' => 0, 'alipay' => 0, 'balance' => 0, 'cash' => 0, 'bank' => 0, 'debt' => 0, 'amount' => 0];
        $refundList = StatRefundClass::getAllByCondition($where, null, '*');
        if (!empty($refundList)) {
            foreach ($refundList as $key => $item) {
                $refund['wx'] = bcadd($refund['wx'], $item['wx'], 2);
                $refund['alipay'] = bcadd($refund['alipay'], $item['alipay'], 2);
                $refund['balance'] = bcadd($refund['balance'], $item['balance'], 2);
                $refund['cash'] = bcadd($refund['cash'], $item['cash'], 2);
                $refund['bank'] = bcadd($refund['bank'], $item['bank'], 2);
                $refund['debt'] = bcadd($refund['debt'], $item['debt'], 2);
                $refund['amount'] = bcadd($refund['amount'], $item['amount'], 2);
            }
        }
        $arr = [
            ['name' => '微信支付', 'kd' => floatval($kd['wx']), 'refund' => floatval($refund['wx'])],
            ['name' => '支付宝', 'kd' => floatval($kd['alipay']), 'refund' => floatval($refund['alipay'])],
            ['name' => '欠账', 'kd' => floatval($kd['debt']), 'refund' => floatval($refund['debt'])],
            ['name' => '余额', 'kd' => floatval($kd['balance']), 'refund' => floatval($refund['balance'])],
            ['name' => '现金', 'kd' => floatval($kd['cash']), 'refund' => floatval($refund['cash'])],
            ['name' => '银行卡', 'kd' => floatval($kd['bank']), 'refund' => floatval($refund['bank'])],
            ['name' => '总计', 'kd' => floatval($kd['amount']), 'refund' => floatval($refund['amount'])],
        ];
        $income = floatval(bcsub($kd['amount'], $refund['amount'], 2));
        util::success(['list' => $arr, 'income' => $income]);
    }

}