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

<?php

namespace addons\Happiness\backend\controllers;

use addons\Happiness\common\models\HappinessStore;
use addons\Happiness\common\enums\HappinessEnum;


use addons\Happiness\common\logic\store\StoreCensus;
use addons\Happiness\common\models\HappinessGoodsRanking;
use addons\Happiness\common\models\HappinessStoreCommission;
use addons\Happiness\common\models\HappinessWithdrawLog;
use common\enums\RedisKeyEnum;
use common\enums\StatusEnum;
use common\helpers\ArrayHelper;
use common\helpers\DateHelper;
use common\models\common\CommissionLog;
use common\models\common\Region;
use Yii;
use common\controllers\AddonsController;

/**
 * 默认控制器
 *
 * Class DefaultController
 * @package addons\Happiness\backend\controllers
 */
class DefaultController extends BaseController
{
    
    public function actionIndex()
    {
        if (!\Yii::$app->request->isAjax) {
            return $this->render('index');
        }
        if (\Yii::$app->request->isGet) {

            $time_nodes = DateHelper::yesterDay();
            $result = $this->getYesterdayData($time_nodes);
            list($waiting_audit_withdraw_amounts, $waiting_pay_withdraw_amounts) = $this->getWithdrawData();

            /* 顶部统计 ---- end ---- */
            $store_good_ranking_list = $this->getStoreGoodRankingList();
            /* 省级地区销售排名 ---- start ---- */
            $store_datas = $this->getStoreDatas();
            /* 省级地区销售排名 ---- end ---- */

            // 门店总数
            $all_store_numbers = array_sum(array_column($store_datas, 'store_numbers'));
            $all_sale_amounts = round(array_sum(array_column($store_datas, 'sale_amounts')), 2);
            $data = [
                'currTime' => date('Y-m-d H:i:s'),
                'statistics' => [
                    'pay_people_numbers' => $this->getPayPeopleNumbers(),
                    'real_pay_amounts' => $this->getRealPayAmounts(),
                    'not_settle_amounts' => $this->getNotSettleAmounts(),
                    // 'settle_amounts' => $this->getSettleAmounts(),
                    'pay_order_numbers' => $this->getPayOrderNumbers(),
                    'waiting_audit_withdraw_amounts' => $waiting_audit_withdraw_amounts,
                    'waiting_pay_withdraw_amounts' => $waiting_pay_withdraw_amounts,
                    // 'waiting_audit_store_numbers' => $this->getWaitingAuditStoreNumbers(),

                    'yesterday_pay_order_numbers' => $result['yesterday_pay_order_numbers'],
                    'yesterday_pay_people_numbers' => $result['yesterday_pay_people_numbers'],
                    'yesterday_real_pay_amounts' => $result['yesterday_real_pay_amounts'],
                    'yesterday_not_settle_amounts' => $result['yesterday_not_settle_amounts'],
                    'yesterday_settle_amounts' => $result['yesterday_settle_amounts'],
                    'yesterday_waiting_audit_withdraw_amounts' => $result['yesterday_waiting_audit_withdraw_amounts'],
                    'yesterday_waiting_pay_withdraw_amounts' => $result['yesterday_waiting_pay_withdraw_amounts'],
                    'yesterday_waiting_audit_store_numbers' => $result['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,
            ];
            return $this->success('success', $data);
        }
    }

    public function getStoreGoodRankingList()
    {
        $store_good_ranking_list = HappinessGoodsRanking::find()
            ->select('store_id,sum(sales_money) as sales_money')
            ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED])
            ->orderBy('sales_money desc')
            ->groupBy('store_id')
            ->limit(10)
            ->asArray()
            ->all();
            
        if (empty($store_good_ranking_list)) {
            $store_good_ranking_list = [];
        }

        if (!empty($store_good_ranking_list)) {
            $store_ids = array_column($store_good_ranking_list, 'store_id');
            $stores = HappinessStore::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'] ?? '';
            }
        }
        return $store_good_ranking_list;
    }

    public function getStoreDatas()
    {
        $store_datas = [];
        $regions = Region::find()->select('id,name')->where(['level' => 1])->asArray()->indexBy('id')->all();

        $page = 1;
        $limit = 200;
        do {
            $offset = ($page - 1) * $limit;
            $page++;
            $stores = HappinessStore::find()
                ->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED])
                ->limit($limit)
                ->offset($offset)
                ->all();
            if (!empty($stores)) {
                foreach ($stores 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[$store->province_id]['sale_amounts'] = bcadd($store_datas[$store->province_id]['sale_amounts'], $store->total_order_money, 2);
                }
            }
        } while ($stores);

        $store_datas = ArrayHelper::arraySort($store_datas, 'sale_amounts', 'desc');
        $store_datas = array_values($store_datas);
        return $store_datas;
    }


    //实收金额
    public function getRealPayAmounts()
    {
        $key = HappinessEnum::STORE_REAL_PAY_AMOUNTS . ':' . $this->mall_id;
        $res = \Yii::$app->redis->get($key);//待结算
        if (!empty($res)) return $res;
        $realPayAmounts = HappinessStoreCommission::find()->where(['mall_id' => $this->mall_id, 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED], 'is_settlement' => [0,1]])
            ->sum('amount_received');
        if(empty($realPayAmounts)) $realPayAmounts = 0;
        \Yii::$app->redis->set($key,$realPayAmounts);
        return $realPayAmounts;
    }

    //待结算
    public function getNotSettleAmounts()
    {
        $key = HappinessEnum::STORE_NOT_SETTLE_AMOUNTS . ':' . $this->mall_id;
        $res = \Yii::$app->redis->get($key);//待结算
        if (!empty($res)) return $res;
        $not_settle_amounts = HappinessStoreCommission::find()->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED, 'is_settlement' => 0])
            ->sum('amount_received');
        if(empty($not_settle_amounts)) $not_settle_amounts = 0;
        \Yii::$app->redis->set($key,$not_settle_amounts);
        return $not_settle_amounts;
    }

    //给会员的佣金
    public function getSettleAmounts()
    {
        $key = HappinessEnum::STORE_SETTLE_AMOUNTS . ':' . $this->mall_id;
        $res = \Yii::$app->redis->get($key);//给会员的佣金
        if (!empty($res)) return $res;

        $settle_amounts = CommissionLog::find()->where(['mall_id' => $this->mall_id, 'source_table' => ['store_order_detail', 'store_cashier_order']])->sum('change_num');
        if(empty($settle_amounts)) $settle_amounts = 0;
        \Yii::$app->redis->set($key,$settle_amounts);
        return $settle_amounts;
    }

    //支付人数
    public function getPayPeopleNumbers()
    {
        $key = HappinessEnum::STORE_PAY_PEOPLE_NUMBERS . ':' . $this->mall_id;
        $res = \Yii::$app->redis->get($key);//支付人数
        if (!empty($res)) return $res;
        $mall_id = $this->mall_id;
        $sql = "select count(*) as counts from (select user_id from qimall_addons_happiness_store_commission where mall_id = {$mall_id} and status in(0,1) group by user_id) t";
        $result = \Yii::$app->db->createCommand($sql)->queryAll();
        if(empty($result[0]['counts'])) $result[0]['counts'] = 0;
        \Yii::$app->redis->set($key,$result[0]['counts']);
        return $result[0]['counts'];
    }

    //支付订单数
    public function getPayOrderNumbers()
    {
        $key = HappinessEnum::STORE_PAY_ORDER_NUMBERS . ':' . $this->mall_id;
        $res = \Yii::$app->redis->get($key);//支付订单数
        if (!empty($res)) return $res;
        $pay_order_numbers = HappinessStoreCommission::find()->where(['mall_id' => $this->mall_id, 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]])
            ->count();
        if(empty($pay_order_numbers)) $pay_order_numbers = 0;
        \Yii::$app->redis->set($key,$pay_order_numbers);
        return $pay_order_numbers;
    }

    //待审核门店
    // public function getWaitingAuditStoreNumbers()
    // {
    //     $key = HappinessEnum::STORE_WAITING_AUDIT_STORE_NUMBERS . ':' . $this->mall_id;
    //     $res = \Yii::$app->redis->get($key);//待审核门店
    //     if (!empty($res)) return $res;
    //     $waiting_audit_store_numbers = HappinessStore::find()->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED, 'check_status' => StoreEnum::CHECK_WAITING])->count();

    //     if(empty($waiting_audit_store_numbers)) $waiting_audit_store_numbers = 0;
    //     \Yii::$app->redis->set($key,$waiting_audit_store_numbers);
    //     return $waiting_audit_store_numbers;

    // }

    public function getWithdrawData()
    {
        $list = HappinessWithdrawLog::lists([
            'where' => [
                ['mall_id' => $this->mall_id], ['status' => StatusEnum::ENABLED], ['withdraw_status' => [0, 1]]
            ],
            'group' => 'withdraw_status',
            'select' => 'withdraw_status,sum(num) as num'
        ]);
        $waiting_audit_withdraw_amounts = 0;
        $waiting_pay_withdraw_amounts = 0;
        foreach ($list as $item) {
            if ($item['withdraw_status'] == 0) {
                $waiting_audit_withdraw_amounts = $item['num'];
            }
            if ($item['withdraw_status'] == 1) {
                $waiting_pay_withdraw_amounts = $item['num'];
            }
        }
        return [$waiting_audit_withdraw_amounts, $waiting_pay_withdraw_amounts];


    }



    public function getYesterdayData($time_nodes)
    {
        $yesterday = date('Y-m-d',strtotime("-1 days"));
        $key = HappinessEnum::STORE_GLOBAL_STATISTICS_YESTERDAY . ':' . $this->mall_id.':'.$yesterday;
        $result = \Yii::$app->redis->get($key);
        if (!empty($result)) {
            return json_decode($result, true);
        }
        $obj = new StoreCensus($this->mall_id, $time_nodes['start'], $time_nodes['end']);
        $yesterday_pay_order_numbers = $obj->getPayOrderNumbers();
        $yesterday_pay_people_numbers = $obj->getPayPeopleNumbers();
        $yesterday_real_pay_amounts = $obj->getRealPayAmounts();
        $yesterday_not_settle_amounts = $obj->getNotSettleAmounts();
        // $yesterday_settle_amounts = $obj->getSettleAmounts();
        list($yesterday_waiting_audit_withdraw_amounts, $yesterday_waiting_pay_withdraw_amounts) = $obj->getWithdrawData();
        // $yesterday_waiting_audit_store_numbers = $obj->getWaitingAuditStoreNumbers();
        $data =  [
            'yesterday_pay_order_numbers' => $yesterday_pay_order_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,
        ];
        \Yii::$app->redis->set($key,json_encode($data));
        return $data;
    }
}