minongyun/application/admin/controller/Dashboard.php

<?php

namespace app\admin\controller;

use app\admin\model\Admin;
use app\admin\model\User;
use app\common\controller\Backend;
use app\common\model\Attachment;
use fast\Date;
use think\Db;

/**
 * 控制台
 *
 * @icon   fa fa-dashboard
 * @remark 用于展示当前系统中的统计数据、统计报表及重要实时数据
 */
class Dashboard extends Backend
{

    /**
     * 查看
     */
    public function index()
    {
        try {
            \think\Db::execute("SET @@sql_mode='';");
        } catch (\Exception $e) {

        }
        $column = [];
        $starttime = Date::unixtime('day', -6);
        $endtime = Date::unixtime('day', 0, 'end');
        $joinlist = Db("user")->where('jointime', 'between time', [$starttime, $endtime])
            ->field('jointime, status, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(jointime), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->select();
        for ($time = $starttime; $time <= $endtime;) {
            $column[] = date("Y-m-d", $time);
            $time += 86400;
        }
        $userlist = array_fill_keys($column, 0);
        foreach ($joinlist as $k => $v) {
            $userlist[$v['join_date']] = $v['nums'];
        }

        $dbTableList = Db::query("SHOW TABLE STATUS");
        $addonList = get_addon_list();
        $totalworkingaddon = 0;
        $totaladdon = count($addonList);
        foreach ($addonList as $index => $item) {
            if ($item['state']) {
                $totalworkingaddon += 1;
            }
        }
        $this->view->assign([
            'totaluser'         => User::count(),
            'totaladdon'        => $totaladdon,
            'totaladmin'        => Admin::count(),
            'totalcategory'     => \app\common\model\Category::count(),
            'todayusersignup'   => User::whereTime('jointime', 'today')->count(),
            'todayuserlogin'    => User::whereTime('logintime', 'today')->count(),
            'sevendau'          => User::whereTime('jointime|logintime|prevtime', '-7 days')->count(),
            'thirtydau'         => User::whereTime('jointime|logintime|prevtime', '-30 days')->count(),
            'threednu'          => User::whereTime('jointime', '-3 days')->count(),
            'sevendnu'          => User::whereTime('jointime', '-7 days')->count(),
            'dbtablenums'       => count($dbTableList),
            'dbsize'            => array_sum(array_map(function ($item) {
                return $item['Data_length'] + $item['Index_length'];
            }, $dbTableList)),
            'totalworkingaddon' => $totalworkingaddon,
            'attachmentnums'    => Attachment::count(),
            'attachmentsize'    => Attachment::sum('filesize'),
            'picturenums'       => Attachment::where('mimetype', 'like', 'image/%')->count(),
            'picturesize'       => Attachment::where('mimetype', 'like', 'image/%')->sum('filesize'),
        ]);

        $this->assignconfig('column', array_keys($userlist));
        $this->assignconfig('userdata', array_values($userlist));

        $date = date('Y-m-d');
        $company_id = $_SESSION['think']['admin']['company_id'];//查询对应公司id
        //配方单
        $formuladate = Db::name('formula')->where('company_id',$company_id)->where('create',">",$date)->count();
        $this->view->assign('formuladate',$formuladate);
        $formula = Db::name('formula')->where('company_id',$company_id)->count();
        $this->view->assign('formula',$formula);
        //订单
        $orderdate = Db::name('order')->where('company_id',$company_id)->where('create',">",$date)->count();
        $this->view->assign('orderdate',$orderdate);
        $order = Db::name('order')->where('company_id',$company_id)->count();
        $this->view->assign('order',$order);
        //库存
        $stockdate = Db::name('stock')->where('company_id',$company_id)->where('create',">",$date)->count();
        $this->view->assign('stockdate',$stockdate);
        $stock = Db::name('stock')->where('company_id',$company_id)->count();
        $this->view->assign('stock',$stock);
        //管理员
        $admin = Db::name('admin')->where('company_id',$company_id)->count();
        $this->view->assign('admin',$admin);
        return $this->view->fetch();
    }

    public function ecDashboard(){
        $company_id = $_SESSION['think']['admin']['company_id'];//查询对应公司id
        /**
         * 查出此公司一周内每一天的订单数量，返回到前台
         * 1、组合日期数组
         * 2、根据日期循环查询订单量，返回数据
        */
        $date = strtotime(date('Y-m-d'));
        $oneDay = 24*60*60;
        $data = array();
        for ($i=6;$i>=0;$i--){
           if ($i == 0){
               $data[$i] = date('Y-m-d',$date);
           }else{
               $data[$i] = date('Y-m-d',$date - $oneDay * $i);
           }
        }
        sort($data);//数组重新拍序
        $order = array();
        foreach ($data as $key=>$value){
            /**
             * 拼接下日期，查询当日0点到24点
            */
            $map = array();
            $start_value = $value.' 00:00:00';
            $end_value = $value.' 24:00:00';
            $map['create'] = array('between time',[$start_value,$end_value]);
            $order[$key] = Db::name('order')->where('company_id',$company_id)->where($map)->count();
        }
        return $order;
    }



    function getDateFromRange($startdate, $enddate)
    {
        $stimestamp = strtotime($startdate);
        $etimestamp = strtotime($enddate);
        // 计算日期段内有多少天
        $days = ($etimestamp - $stimestamp) / 86400 + 1;
        // 保存每天日期
        $date = array();
        for ($i = 0; $i < $days; $i++) {
            $date[] = date('Y-m-d', $stimestamp + (86400 * $i));
        }
        return $date;
    }
}