StatisticalController.php

<?php
/**
 * 统计
 * @link http://www.heshop.com/
 * @copyright Copyright (c) 2020 HeShop Software LLC
 * @license http://www.heshop.com/license/
 */
namespace leadmall\api;

use basics\api\BasicsController as BasicsModules;
use leadmall\Map;
use Yii;

class StatisticalController extends BasicsModules implements Map
{

    /**
     * 重写父类
     * @return [type] [description]
     */
    public function actions()
    {
        $actions = parent::actions();
        unset($actions['create']);
        unset($actions['update']);
        return $actions;
    }

    public function actionIndex()
    {

        $behavior = Yii::$app->request->get('behavior', '');

        switch ($behavior) {
            case 'userstatistical': //用户统计
                return $this->userStatistical();
                break;
            case 'storeCount': //店铺统计
                return $this->storeCount();
                break;
            case 'nearTwoDay': //最近两天统计
                return $this->nearTwoDay();
                break;
            case 'exportGoods': //商品销售统计导出
                return $this->exportGoods();
                break;
            case 'exportUsers': //用户消费统计导出
                return $this->exportUsers();
                break;
            default:
                Error('未定义操作');
                break;
        }

    }

    public function userStatistical()
    {
        return $this->runModule('users', 'index', "statistical");
    }

    public function storeCount()
    {
        $AppID       = Yii::$app->params['AppID'];
        $merchant_id = 1;
        $where       = ['AppID' => $AppID];

        $unpaid        = M('order', 'Order')::find()->where(['and', $where, ['status' => 100, 'is_deleted' => 0]])->count();
        $unsent        = M('order', 'Order')::find()->where(['and', $where, ['status' => 201, 'is_deleted' => 0]])->count();
        $order_after   = M('order', 'OrderAfter')::find()->where(['and', $where, ['<', 'status', 200]])->count();
        $user_number   = M('users', 'User')::find()->where($where)->count();
        $income_amount = M('order', 'Order')::find()->where(['and', $where, ['>', 'status', 200]])->sum('pay_amount');
        $out_amount    = M('order', 'OrderAfter')::find()->where(['and', $where, ['status' => 200], ['<>', 'type', 2]])->sum('actual_refund');

        $data = [
            'unpaid'        => $unpaid,
            'unsent'        => $unsent,
            'order_after'   => $order_after,
            'user_number'   => $user_number,
            'income_amount' => round(($income_amount - $out_amount), 2),
        ];

        return $data;
    }

    public function nearTwoDay()
    {
        $yesterday = strtotime('yesterday');
        $today     = strtotime(date("Y-m-d"));

        $AppID = Yii::$app->params['AppID'];
        $where = ['and', ['AppID' => $AppID], ['>=', 'created_time', $yesterday]];

        $visit_data = M('statistical', 'VisitLog')::find()->where($where)->select('UID,created_time')->asArray()->all();
        $order_data = M('order', 'Order')::find()->where(['and', $where, ['>', 'status', 200]])->select('pay_amount,UID,created_time')->asArray()->all();

        $visit_list       = [];
        $pay_amount_list  = [];
        $num_order_list   = [];
        $num_buyer_list   = [];
        $today_visit_list = [];

        for ($i = 0; $i < 48; $i++) {
            $visit          = [];
            $pay_amount     = 0;
            $num_order      = 0;
            $num_buyer      = [];
            $start_time     = $yesterday + $i * 3600;
            $end_time       = $yesterday + ($i + 1) * 3600;
            $new_visit_data = [];
            foreach ($visit_data as $v1) {
                if ($v1['created_time'] >= $start_time && $v1['created_time'] < $end_time) {
                    array_push($visit, $v1['UID']);
                    if ($v1['created_time'] >= $today) {
                        array_push($today_visit_list, $v1['UID']);
                    }
                } else {
                    array_push($new_visit_data, $v1);
                }
            }
            $visit_data = $new_visit_data;

            $new_order_data = [];
            foreach ($order_data as $v2) {
                if ($v2['created_time'] >= $start_time && $v2['created_time'] < $end_time) {
                    $pay_amount += $v2['pay_amount'];
                    $num_order++;
                    array_push($num_buyer, $v2['UID']);
                } else {
                    array_push($new_order_data, $v2);
                }
            }
            $order_data = $new_order_data;

            $visit_list[$i]      = count(array_unique($visit));
            $pay_amount_list[$i] = round($pay_amount, 2);
            $num_order_list[$i]  = $num_order;
            $num_buyer_list[$i]  = count(array_unique($num_buyer));
        }

        $yesterday_list = [
            'visit_list'      => array_slice($visit_list, 0, 24),
            'pay_amount_list' => array_slice($pay_amount_list, 0, 24),
            'num_order_list'  => array_slice($num_order_list, 0, 24),
            'num_buyer_list'  => array_slice($num_buyer_list, 0, 24),
        ];

        $today_list = [
            'visit_list'      => array_slice($visit_list, 24, 24),
            'pay_amount_list' => array_slice($pay_amount_list, 24, 24),
            'num_order_list'  => array_slice($num_order_list, 24, 24),
            'num_buyer_list'  => array_slice($num_buyer_list, 24, 24),
        ];

        $today_visit      = count(array_unique($today_visit_list));
        $today_pay_amount = array_sum($today_list['pay_amount_list']);
        $today_num_order  = array_sum($today_list['num_order_list']);
        $today_num_buyer  = array_sum($today_list['num_buyer_list']);
        return [
            'today_visit'      => $today_visit,
            'today_pay_amount' => round($today_pay_amount, 2),
            'today_num_order'  => $today_num_order,
            'today_num_buyer'  => $today_num_buyer,
            'yesterday_list'   => $yesterday_list,
            'today_list'       => $today_list,
        ];

    }

    public function exportGoods()
    {
        $sort        = Yii::$app->request->get('sort', '');
        $sort        = to_array($sort);
        $merchant_id = 1;
        $AppID       = Yii::$app->params['AppID'];
        $where       = ['is_recycle' => 0, 'merchant_id' => $merchant_id, 'AppID' => $AppID];
        $orderBy     = [];
        foreach ($sort as $key => $value) {
            $orderBy[$key] = $value === 'ASC' ? SORT_ASC : SORT_DESC;
        }
        $data = M('goods', 'Goods')::find()
            ->where($where)
            ->orderBy($orderBy)
            ->limit(100)
            ->select('id,name,sales,sales_amount')
            ->asArray()
            ->all();

        $tHeader = ['排名', 'ID', '名称', '销量', '销售额'];

        $list = [];
        foreach ($data as $key => $value) {
            $arr = [$key + 1, $value['id'], $value['name'], $value['sales'], (float) $value['sales_amount']];
            array_push($list, $arr);
        }
        return ['tHeader' => $tHeader, 'list' => $list];

    }

    public function exportUsers()
    {
        $sort        = Yii::$app->request->get('sort', '');
        $sort        = to_array($sort);
        $merchant_id = 1;
        $AppID       = Yii::$app->params['AppID'];
        $where       = ['user.is_deleted' => 0, 'user.AppID' => $AppID];
        $orderBy     = [];
        foreach ($sort as $key => $value) {
            $orderBy['statistical.' . $key] = $value === 'ASC' ? SORT_ASC : SORT_DESC;
        }
        $data = M('users', 'User')::find()
            ->alias('user')
            ->joinWith([
                'statistical as statistical',
            ])
            ->where($where)
            ->orderBy($orderBy)
            ->select('user.id,user.nickname,statistical.buy_number,statistical.buy_amount')
            ->distinct()
            ->asArray()
            ->all();

        $tHeader = ['排名', 'ID', '用户', '支付金额', '支付件数'];

        $list = [];
        foreach ($data as $key => $value) {
            $buy_amount = $value['statistical'] ? $value['statistical']['buy_amount'] : 0.00;
            $buy_number = $value['statistical'] ? $value['statistical']['buy_number'] : 0;
            $arr        = [$key + 1, $value['id'], $value['nickname'], (float) $buy_amount, $buy_number];
            array_push($list, $arr);
        }
        return ['tHeader' => $tHeader, 'list' => $list];

    }

}