zhongshen_project/addon/store/shop/controller/Stat.php

<?php
/**
 * Niushop商城系统 - 团队十年电商经验汇集巨献!
 * =========================================================
 * Copy right 2019-2029 上海牛之云网络科技有限公司, 保留所有权利。
 * ----------------------------------------------
 * 官方网址: https://www.niushop.com
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用。
 * 任何企业和个人不允许对程序代码以任何形式任何目的再发布。
 * =========================================================
 */

namespace addon\store\shop\controller;

use app\model\store\Stat as StatModel;
use app\model\store\Store as StoreModel;
use app\shop\controller\BaseShop;
use app\model\system\UserGroup;
use Carbon\Carbon;
use think\validate\ValidateRule;


class Stat extends BaseShop
{
    /**
     * 门店统计数据
     */
    public function store()
    {
        $user_info = $this->user_info;
        $user_id = $user_info['uid'];
        $uwhere['uid'] = $user_id;
        $UgObj = new UserGroup();
        
        $where = [] ;
        $where[]=[ 'site_id', '=', $this->site_id ];
        if(!$user_info['is_admin']){
             $user_store_list =$UgObj->getUserList($uwhere,'uid,store_id');
             $store_id_arr = array_column($user_store_list['data'],'store_id');
             $where[]=['store_id','in',$store_id_arr] ;
        }
            
      

        $store_list = ( new StoreModel() )->getStoreList($where, 'store_id,store_name');
        $this->assign('store_list', $store_list[ 'data' ]);
        $this->assign('today', Carbon::today()->toDateString());
        $this->assign('yesterday', Carbon::yesterday()->toDateString());
        return $this->fetch('stat/store');
    }

    /**
     * 统计数据总和
     */
    public function statTotal()
    {
        if (request()->isAjax()) {
            $store_id = input('store_id', 0);
            $start_time = $end_time = input('start_time', strtotime(date('Y-m-d', time())));
            $end_time = input('end_time', time());

            if ($start_time > $end_time) {
                $start_time = input('end_time');
                $end_time = input('start_time');
            }
            $store_id_arr = [];
            $userGroupModel = new UserGroup();
            $userInfo = $this->user_info;


            if(!$userInfo['is_admin']){
                $userGroupWhere['uid'] = $userInfo['uid'];
                $userGroupList = $userGroupModel->getUserList($userGroupWhere,'uid,store_id');
                $store_id_arr = array_column($userGroupList['data'],'store_id');
            }
            
            $stat_model = new StatModel();

            $data = $stat_model->getShopStatSum($this->site_id, $start_time, $end_time, $store_id,$store_id_arr);
            return $data;
        }
    }

    /**
     * 获取天统计趋势数据
     */
    public function dayStatData()
    {
        if (request()->isAjax()) {
            $store_id = input('store_id', 0);
            $start_time = input('start_time', strtotime(date('Y-m-d', strtotime('-6 day'))));
            $end_time = input('end_time', time());

            if ($start_time > $end_time) {
                $start_time = input('end_time');
                $end_time = input('start_time');
            }
            
            if($store_id==0){
                $store_id_arr = [];
                $userGroupModel = new UserGroup();
                $userInfo = $this->user_info;
                $userGroupWhere['uid'] = $userInfo['uid'];
                $userGroupList = $userGroupModel->getUserList($userGroupWhere,'uid,store_id');
                $store_id_arr = array_column($userGroupList['data'],'store_id');
                if(!empty($store_id_arr) &&  !$userInfo['is_admin']){
                    $store_id = $store_id_arr;
                }
            }
            
            $stat_model = new StatModel();
            $fields = $stat_model->getStatField();
            $fields[] = 'expected_earnings_total_money';

            $stat_list = $stat_model->getShopStatList($this->site_id, $start_time, $end_time, $store_id)[ 'data' ];
            $stat_lists = [];
            foreach($stat_list as $slv){
                $slsk = $slv['day'];
                unset($slv['day']);
                $stat_lists[$slsk] = $slv;
            }
//            dump($stat_lists);die;
            // $array_key = array_keys($stat_list[0]);
            //  return success(0, '', $stat_list);
             
            // $stat_list = array_map(function($item) {
            //     $item[ 'day_time' ] = date('Y-m-d', $item[ 'day_time' ]);
            //     return $item;
            // }, $stat_list);
            // $stat_list = array_column($stat_list, null, 'day_time');

            $day = ceil(( $end_time - $start_time ) / 86400);

            $time = [];
            for ($i = 0; $i < $day; $i++) {
                $date = date('Y-m-d', $start_time + $i * 86400);
                $time[] = $date;
                $day = date('d', $start_time + $i * 86400);
                dump($day);
            }die;
            $data[ 'time' ] = $time;
            // return success(0, '', $data);
            foreach ($fields as $field) {
                $value = [];
                // $time = [];
                // for ($i = 0; $i < $day; $i++) {
                //     $date = date('Y-m-d', $start_time + $i * 86400);
                //     $time[] = $date;
                //     $value[] = isset($stat_list[ $date ]) ? $stat_list[ $date ][ $field ] : 0;
                // }
                $value = array_column($stat_list,$field);
                // foreach ($stat_list as &$slv){
                //   if()
                // }
                $data[ $field ] = $value;
                // $data[ 'time' ] = $time;
            }
            return success(0, '', $data);
        }
    }

    /**
     * 获取小时统计趋势数据
     */
    public function hourStatData()
    {
        if (request()->isAjax()) {
            $time = input('start_time', time());
            $store_id = input('store_id', 0);
            $carbon = Carbon::createFromTimestamp($time);

            $stat_model = new StatModel();
            $fields = $stat_model->getStatHourField();
            $fields[] = 'expected_earnings_total_money';

            if($store_id==0){
                $store_id_arr = [];
                $userGroupModel = new UserGroup();
                $userInfo = $this->user_info;
                $userGroupWhere['uid'] = $userInfo['uid'];
                $userGroupList = $userGroupModel->getUserList($userGroupWhere,'uid,store_id');
                $store_id_arr = array_column($userGroupList['data'],'store_id');
                if(!empty($store_id_arr) &&  !$userInfo['is_admin']){
                    $store_id = $store_id_arr;
                }
            }


            $stat_list = $stat_model->getShopStatHourList($this->site_id, $carbon->year, $carbon->month, $carbon->day, $store_id)[ 'data' ];

            $data = [];
            $empty = array_map(function() { return 0; }, range(0, 23, 1));
            if (!empty($stat_list)) {
                $stat_list = array_column($stat_list, null, 'hour');
                foreach ($fields as $field) {
                    $value = [];
                    for ($i = 0; $i < 24; $i++) {
                        $value[ $i ] = isset($stat_list[ $i ]) ? $stat_list[ $i ][ $field ] : 0;
                    }
                    $data[ $field ] = $value;
                }
            } else {
                foreach ($fields as $field) {
                    $data[ $field ] = $empty;
                }
            }
            $data[ 'time' ] = array_map(function($value) { return $value . '时'; }, range(0, 23, 1));
            return success(0, '', $data);
        }
    }
}