qimall/addons/Mch/backend/controllers/DefaultController.php

<?php

namespace addons\Mch\backend\controllers;

use addons\Mch\common\enums\MchEnum;
use addons\Mch\common\models\Mch;
use addons\Mch\common\models\MchCommission;
use addons\Mch\common\models\MchGoodsRanking;
use addons\Mch\common\models\MchWithdrawLog;
use common\enums\RedisKeyEnum;
use common\enums\StatusEnum;
use common\helpers\ArrayHelper;
use common\helpers\DateHelper;
use common\models\common\Region;

/**
 * 默认控制器
 *
 * Class DefaultController
 * @package addons\Store\backend\controllers
 */
class DefaultController extends BaseController
{
    /**
     * 首页
     *
     * @return string
     */
    public function actionIndex()
    {
        if (!\Yii::$app->request->isAjax) {
            return $this->render('index');
        }
        if (\Yii::$app->request->isGet) {
            $cache = \Yii::$app->cache;
            $cache_key = RedisKeyEnum::BACKEND_CENSUS_KEY . 'mall_id:' . $this->mall_id;
            $data = $cache->get($cache_key);
            if (!empty($data)) {
                return $this->success('success', $data);
            }
            /* 顶部统计 ---- start ---- */
            $time_nodes = DateHelper::yesterDay();
            $query_com = MchCommission::find()
                ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED]);
            // 实际支付金额（实收金额）、待结算佣金、已结算佣金、支付人数、支付订单数量
            $real_pay_amounts = $not_settle_amounts = $settle_amounts = $pay_people_numbers = $pay_order_numbers = 0;
            $yesterday_real_pay_amounts = $yesterday_not_settle_amounts = $yesterday_settle_amounts = $yesterday_pay_people_numbers = $yesterday_pay_order_numbers = 0;
            $user_ids = $yesterday_user_ids = [];
            foreach ($query_com->each(100) as $commission) {
                $real_pay_amounts += $commission->pay_money;
                if ($commission->is_settlement == 1) {
                    $settle_amounts += $commission->amount_received;
                } else {
                    $not_settle_amounts += $commission->amount_received;
                }
                $pay_order_numbers += 1;
                $user_ids[] = $commission->user_id;
                if ($commission->created_at >= $time_nodes['start'] && $commission->created_at <= $time_nodes['start']) {
                    $yesterday_real_pay_amounts += $commission->pay_money;
                    if ($commission->is_settlement == 1) {
                        $yesterday_settle_amounts += $commission->amount_received;
                    } else {
                        $yesterday_not_settle_amounts += $commission->amount_received;
                    }
                    $yesterday_pay_order_numbers += 1;
                    $yesterday_user_ids[] = $commission->user_id;
                }
            }

            $pay_people_numbers = count(array_flip(array_flip($user_ids)));
            $real_pay_amounts = round($real_pay_amounts, 2);
            $not_settle_amounts = round($not_settle_amounts, 2);
            $settle_amounts = round($settle_amounts, 2);

            $yesterday_pay_people_numbers = count(array_flip(array_flip($yesterday_user_ids)));
            $yesterday_real_pay_amounts = round($yesterday_real_pay_amounts, 2);
            $yesterday_not_settle_amounts = round($yesterday_not_settle_amounts, 2);
            $yesterday_settle_amounts = round($yesterday_settle_amounts, 2);

            // 待审核提现、待贷款提现
            $waiting_audit_withdraw_amounts = $waiting_pay_withdraw_amounts = 0;
            $yesterday_waiting_audit_withdraw_amounts = $yesterday_waiting_pay_withdraw_amounts = 0;
            $query_withdraw = MchWithdrawLog::find()
                ->select('withdraw_status,actual_num')
                ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED, 'withdraw_status' => [0, 1]]);
            foreach ($query_withdraw->each(100) as $withdraw) {
                if ($withdraw->withdraw_status == 0) {
                    $waiting_audit_withdraw_amounts += $withdraw->actual_num;
                } else {
                    $waiting_pay_withdraw_amounts += $withdraw->actual_num;
                }
                if ($commission->created_at >= $time_nodes['start'] && $commission->created_at <= $time_nodes['start']) {
                    if ($withdraw->withdraw_status == 0) {
                        $yesterday_waiting_audit_withdraw_amounts += $withdraw->actual_num;
                    } else {
                        $yesterday_waiting_pay_withdraw_amounts += $withdraw->actual_num;
                    }
                }
            }
            $waiting_audit_withdraw_amounts = round($waiting_audit_withdraw_amounts, 2);
            $waiting_pay_withdraw_amounts = round($waiting_pay_withdraw_amounts, 2);
            $yesterday_waiting_audit_withdraw_amounts = round($yesterday_waiting_audit_withdraw_amounts, 2);
            $yesterday_waiting_pay_withdraw_amounts = round($yesterday_waiting_pay_withdraw_amounts, 2);

            // 待审核门店数量
            $waiting_audit_store_numbers = $yesterday_waiting_audit_store_numbers = 0;
            $query_store = Mch::find()
                ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED]);
            foreach ($query_store->andWhere(['check_status' => MchEnum::CHECK_WAITING])->each(200) as $store) {
                $waiting_audit_store_numbers += 1;
                if ($store->created_at >= $time_nodes['start'] && $store->created_at <= $time_nodes['start']) {
                    $yesterday_waiting_audit_store_numbers += 1;
                }
            }
            /* 顶部统计 ---- end ---- */
            /* 门店销售排名 ---- start ---- */
            $store_good_ranking_list = MchGoodsRanking::find()
                ->select('store_id,sales_money')
                ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED])
                ->orderBy('sales_money desc')
                ->limit(10)
                ->asArray()
                ->all();
            if (empty($store_good_ranking_list)) {
                $store_good_ranking_list = [
                    1 => ['store_id' => 1, 'sales_money' => 1234],
                    2 => ['store_id' => 2, 'sales_money' => 222],
                    3 => ['store_id' => 3, 'sales_money' => 2342],
                ];
            }

            if (!empty($store_good_ranking_list)) {
                $store_ids = array_column($store_good_ranking_list, 'store_id');
                $stores = Mch::find()
                    ->select('id,store_name,logo_img')
                    ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED, 'id' => $store_ids])
                    ->asArray()
                    ->indexBy('id')
                    ->all();
                foreach ($store_good_ranking_list as &$list) {
                    $store = $stores[$list['store_id']] ?? [];
                    $list['store_name'] = $store['store_name'] ?? '';
                    $list['logo_img'] = $store['logo_img'] ?? '';
                }
            }
            /* 门店销售排名 ---- end ---- */
            /* 省级地区销售排名 ---- start ---- */
            $store_datas = [];
            $regions = Region::find()->select('id,name')->where(['level' => 1])->asArray()->indexBy('id')->all();
            $query_store = Mch::find()
                ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED])
                ->andWhere(['check_status' => 1]);
            foreach ($query_store->each(200) as $store) {
                $store_datas[$store->province_id]['region_name'] = $regions[$store->province_id]['name'] ?? '';
                if (!isset($store_datas[$store->province_id]['store_numbers'])) {
                    $store_datas[$store->province_id]['store_numbers'] = 0;
                }
                $store_datas[$store->province_id]['store_numbers'] += 1;
                if (!isset($store_datas[$store->province_id]['sale_amounts'])) {
                    $store_datas[$store->province_id]['sale_amounts'] = 0;
                }
                $store_datas[$store->province_id]['sale_amounts'] += $store->total_order_money;
            }
            $store_datas = array_values($store_datas);
            $store_datas = ArrayHelper::arraySort($store_datas, 'sale_amounts', 'asc');
            // $store_datas = ArrayHelper::multisort(array_values($store_datas), 'sale_amounts', 'asc');
            // 门店总数
            $all_store_numbers = array_sum(array_column($store_datas, 'store_numbers'));
            $all_sale_amounts = array_sum(array_column($store_datas, 'sale_amounts'));

            /* 省级地区销售排名 ---- end ---- */

            $data = [
                'currTime' => date('Y-m-d H:i:s'),
                'statistics' => [
                    'pay_people_numbers' => $pay_people_numbers,
                    'real_pay_amounts' => $real_pay_amounts,
                    'not_settle_amounts' => $not_settle_amounts,
                    'settle_amounts' => $settle_amounts,
                    'pay_order_numbers' => $pay_order_numbers,
                    'yesterday_pay_order_numbers' => $yesterday_pay_order_numbers,
                    'waiting_audit_withdraw_amounts' => $waiting_audit_withdraw_amounts,
                    'waiting_pay_withdraw_amounts' => $waiting_pay_withdraw_amounts,
                    'waiting_audit_store_numbers' => $waiting_audit_store_numbers,
                    'yesterday_pay_people_numbers' => $yesterday_pay_people_numbers,
                    'yesterday_real_pay_amounts' => $yesterday_real_pay_amounts,
                    'yesterday_not_settle_amounts' => $yesterday_not_settle_amounts,
                    'yesterday_settle_amounts' => $yesterday_settle_amounts,
                    'yesterday_waiting_audit_withdraw_amounts' => $yesterday_waiting_audit_withdraw_amounts,
                    'yesterday_waiting_pay_withdraw_amounts' => $yesterday_waiting_pay_withdraw_amounts,
                    'yesterday_waiting_audit_store_numbers' => $yesterday_waiting_audit_store_numbers,
                ],
                'store_good_ranking_list' => $store_good_ranking_list,
                'region_ranking_list' => $store_datas,
                'map' => [
                    $all_store_numbers, $all_sale_amounts
                ],
                'total_store_numbers' => $all_store_numbers,
                'total_sale_amounts' => $all_sale_amounts,
            ];
            // 统计结果缓存半个小时
            $cache->set($data, $cache_key, 1800);
            return $this->success('success', $data);
        }
    }
}