huahuibao/app-ghs/controllers/StatKdController.php

<?php

namespace ghs\controllers;

use biz\stat\classes\StatKdClass;
use biz\stat\classes\StatRefundClass;
use bizGhs\order\classes\OrderClass;
use bizHd\order\classes\SettleClass;
use common\components\dateUtil;
use common\components\dict;
use Yii;
use common\components\util;
use bizHd\order\classes\OrderClass as HdOrderClass;
use bizGhs\clear\classes\ClearClass;

class StatKdController extends BaseController
{

    //各渠道收入 ssh 20220711
    public function actionChannel()
    {
        //批发开单 零售开单 批发结账 零售结账

        $todayDate = date('Y-m-d');
        $todayStartTime = $todayDate . ' 00:00:00';
        $todayEndTime = $todayDate . ' 23:59:59';

        $arr = [
            //系统收入
            'system' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '批发', 'num' => 2, 'amount' => 100],
                    ['name' => '零售', 'num' => 2, 'amount' => 100],
                    ['name' => '批发结账', 'num' => 2, 'amount' => 100],
                    ['name' => '零售结账', 'num' => 2, 'amount' => 100],
                ],
            ],
            'kfWx' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '客1', 'num' => 3, 'amount' => 100],
                    ['name' => '客2', 'num' => 3, 'amount' => 100],
                ],
            ],
            'debt' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '批发欠款', 'num' => 3, 'amount' => 30],
                    ['name' => '零售欠款', 'num' => 3, 'amount' => 30],
                ],
            ],
            'cash' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '批发', 'num' => 3, 'amount' => 30],
                    ['name' => '零售', 'num' => 3, 'amount' => 30],
                    ['name' => '批发结账', 'num' => 2, 'amount' => 100],
                    ['name' => '零售结账', 'num' => 2, 'amount' => 100],
                ],
            ],
            'aliPay' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '批发', 'num' => 3, 'amount' => 30],
                    ['name' => '零售', 'num' => 3, 'amount' => 30],
                    ['name' => '批发结账', 'num' => 2, 'amount' => 100],
                    ['name' => '零售结账', 'num' => 2, 'amount' => 100],
                ],
            ],
            'bankCard' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '批发', 'num' => 3, 'amount' => 30],
                    ['name' => '零售', 'num' => 3, 'amount' => 30],
                    ['name' => '批发结账', 'num' => 2, 'amount' => 100],
                    ['name' => '零售结账', 'num' => 2, 'amount' => 100],
                ],
            ],
            'mt' => ['value' => 100, 'num' => 3,],
            'other' => [
                'value' => 100,
                'num' => 3,
                'category' => [
                    ['name' => '批发', 'num' => 3, 'amount' => 30],
                    ['name' => '零售', 'num' => 3, 'amount' => 30],
                    ['name' => '批发结账', 'num' => 2, 'amount' => 100],
                    ['name' => '零售结账', 'num' => 2, 'amount' => 100],
                ],
            ],
        ];

        //批发开单
        $where = ['shopId' => $this->shopId, 'status' => ['in', [OrderClass::ORDER_STATUS_UN_SEND, OrderClass::ORDER_STATUS_SENDING, OrderClass::ORDER_STATUS_COMPLETE]]];
        $where['payTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $ghsOrderList = OrderClass::getAllByCondition($where, null, '*');
        if (!empty($ghsOrderList)) {
            foreach ($ghsOrderList as $ghsKey => $ghsOrder) {
                $payWay = $ghsOrder['payWay'] ?? 0;
                $actPrice = $ghsOrder['actPrice'] ?? 0;
                $debtPrice = $ghsOrder['debtPrice'] ?? 0;
                $onlinePay = $ghsOrder['onlinePay'] ?? dict::getDict('onlinePay', 'not');
                if ($debtPrice > 0) {
                    //不管是否结清，只要$debtPrice > 0，说明曾经订单是欠款

                } else {
                    if ($onlinePay == dict::getDict('onlinePay', 'yes')) {

                    } else {
                        //使用支付方式的
                        switch ($payWay) {
                            case dict::getDict('payWay', 'wxPay'):

                                //要记录是客服几收的钱

                                break;
                            case dict::getDict('payWay', 'alipay'):
                                break;
                            case dict::getDict('payWay', 'cash'):
                                break;
                            case dict::getDict('payWay', 'bankCard'):
                                break;
                            case dict::getDict('payWay', 'unknown'):
                                break;
                            default:
                        }
                    }
                }
            }
        }

        //零售开单
        $hdWhere = ['shopId' => $this->shop['lsShopId'], 'status' => ['in', [HdOrderClass::ORDER_STATUS_UN_SEND, HdOrderClass::ORDER_STATUS_SENDING, HdOrderClass::ORDER_STATUS_COMPLETE]]];
        $hdWhere['payTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $hdOrderList = HdOrderClass::getAllByCondition($hdWhere, null, '*');
        foreach ($hdOrderList as $hdKey => $hdOrder) {
            $payWay = $hdOrder['payWay'] ?? 0;
            $mainPay = $hdOrder['mainPay'] ?? 0;
            $cash = $hdOrder['cash'] ?? 0;
        }

        //批发结帐收入
        $clearWhere = ['ghsShopId' => $this->shopId, 'status' => 2];
        $clearWhere['payTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $clearList = ClearClass::getAllByCondition($clearWhere, null, '*');
        if (!empty($clearList)) {
            foreach ($clearList as $cKey => $clear) {
                $payWay = $clear['payWay'] ?? 0;
                $actPrice = $clear['actPrice'] ?? 0;
            }
        }

        //零售结账收入
        $settleWhere = ['shopId' => $this->shopId, 'status' => 2];
        $settleWhere['payTime'] = ['between', [$todayStartTime, $todayEndTime]];
        $settleList = SettleClass::getAllByCondition($settleWhere, null, '*');
        if (!empty($settleList)) {
            foreach ($settleList as $sKey => $settle) {
                $payWay = $settle['payWay'] ?? 0;
                $actPrice = $settle['actPrice'] ?? 0;
            }
        }

    }

    //开单收入统计 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]);
    }

}