pig/application/admin/controller/Dashboard.php

<?php

namespace app\admin\controller;

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

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

    //定义协会 进出
    protected $_assoc = [
        'out'=>[2],//安徽协会 产地
        'in'=>[5],//上海协会 销售地
    ];

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

        $adminid = $this->auth->id;

        $where = [];
        if (in_array($adminid, $this->_assoc['in'])) {//销售地
            $province = 'province_id';
            //SELECT * ,COUNT(*) AS s   FROM `pi_p_order` WHERE province_id = 1 GROUP BY company_id
            //SELECT c.name,COUNT(*) AS num ,SUM(num) AS sums FROM `pi_p_order` AS o LEFT JOIN `pi_p_company` AS c ON o.`company_id` = c.id  WHERE o.province_id = 1 AND o.createtime>1122 AND o.`createtime`<234 GROUP BY o.company_id
            $pie_filed = 'company_id';
            $where[$province] = ['in',$this->auth->province_id];
            $sql_where = 'province_id = '.$this->auth->province_id;
        } elseif (in_array($adminid, $this->_assoc['out'])) {//产地
            $province = 'source_id';
            $pie_filed = 'customer_id';
            $where[$province] = ['in',$this->auth->province_id];
            $sql_where = 'source_id = '.$this->auth->province_id;
            //SELECT * ,COUNT(*) AS s   FROM `pi_p_order` WHERE source_id = 1 GROUP BY customer_id
        } else {//屠宰场
            $province = 'company_id';
            $pie_filed = 'customer_id';
            $where[$province] = ['in',$this->auth->company_id];
            $sql_where = 'company_id = '.$this->auth->company_id;
            ////SELECT * ,COUNT(*) AS s   FROM `pi_p_order` WHERE source_id = 1 GROUP BY customer_id
        }

        //缓存图表
        $key = __FILE__.__FUNCTION__.'orders'.json_encode($adminid);
        $orders = Cache::get($key);
        $orders = false;
        if (!$orders) {
            $column = [];
            $starttime = Date::unixtime('day', -6);
            $endtime = Date::unixtime('day', 0, 'end');
        //$joinlist = Db("p_order")->where('jointime', 'between time', [$starttime, $endtime])->field('jointime, status, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(jointime), "%Y-%m-%d") AS join_date')
            $joinlist = Db("p_order")->where($where)->field('leavetime, status,COUNT(*) AS nums, SUM(num) AS sum, DATE_FORMAT(FROM_UNIXTIME(leavetime), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->select();
            for ($time = $starttime; $time <= $endtime;) {
                $column[] = date("Y-m-d", $time);
                $time += 86400;
            }
            $codelist = array_fill_keys($column, 0);//sum
            $orderlist = array_fill_keys($column, 0);//count
            foreach ($joinlist as $k => $v) {
                $codelist[$v['join_date']] = $v['sum'];
                $orderlist[$v['join_date']] = $v['nums'];
            }

            $dbTableList = Db::query("SHOW TABLE STATUS");
            $datalist = [
            'totalcode'       => Order::where($where)->sum('num'),//码总数
            'totalorder'       => Order::where($where)->count(),//订单总数
            //'totaladdon'      => count(get_addon_list()),
            //'totaladmin'      => Admin::count();
            'todaycode' => Order::where($where)->whereTime('leavetime', 'today')->sum('num'),//码总数
            'todayorder'  => Order::where($where)->whereTime('leavetime', 'today')->count(),//订单总数
            'sevencode'        => Order::where($where)->whereTime('leavetime', '-7 days')->sum('num'),
            'sevenorder'        => Order::where($where)->whereTime('leavetime', '-7 days')->count(),
            'thirtycode'       => Order::where($where)->whereTime('leavetime', '-30 days')->sum('num'),
            'thirtyorder'       => Order::where($where)->whereTime('leavetime', '-30 days')->count(),

            'totalcategory'   => \app\common\model\Category::count(),
            'dbtablenums'     => count($dbTableList),
            'dbsize'          => array_sum(array_map(function ($item) {
                return $item['Data_length'] + $item['Index_length'];
            }, $dbTableList)),
            'attachmentnums'  => Attachment::count(),
            'attachmentsize'  => Attachment::sum('filesize'),
            'picturenums'     => Attachment::where('mimetype', 'like', 'image/%')->count(),
            'picturesize'     => Attachment::where('mimetype', 'like', 'image/%')->sum('filesize'),
            ];


            //饼图 7
            $pielist = Db::query('SELECT c.name,COUNT(*) AS num ,SUM(num) AS sums FROM `pi_p_order` AS o LEFT JOIN `pi_p_company` AS c ON o.`'.$pie_filed.'` = c.id  WHERE o.'.$sql_where.' AND o.leavetime>='.$starttime.' AND o.`leavetime`<'.$endtime.' GROUP BY o.`'.$pie_filed.'` ;');

            $piecolumn = [];
            $piedata = [];
            foreach ($pielist as $key => $value) {
                $piecolumn[] = $value['name'].'('.$value['num'].'笔)';
                //$piecolumn[] = $value['name'].'：码个数'.$value['sums'].','.'订单数'.$value['num'];
                $temp = [];
                $temp['value'] = $value['sums'];
                //$temp['name'] = $value['name'].'：码个数'.$value['sums'].','.'订单数'.$value['num'];
                $temp['name'] = $value['name'].'('.$value['num'].'笔)';
                $piedata[] = $temp;
            }

            //饼图 30
            $starttime30 = Date::unixtime('day', -29);
            $pielist30 = Db::query('SELECT c.name,COUNT(*) AS num ,SUM(num) AS sums FROM `pi_p_order` AS o LEFT JOIN `pi_p_company` AS c ON o.`'.$pie_filed.'` = c.id  WHERE o.'.$sql_where.' AND o.leavetime>='.$starttime30.' AND o.`leavetime`<'.$endtime.' GROUP BY o.`'.$pie_filed.'` ;');

            $piecolumn30 = [];
            $piedata30 = [];
            foreach ($pielist as $key => $value) {
                $piecolumn30[] = $value['name'].'('.$value['num'].'笔)';
                
                $temp = [];
                $temp['value'] = $value['sums'];
                
                $temp['name'] =  $value['name'].'('.$value['num'].'笔)';
                $piedata30[] = $temp;
            }
  /*          print_r($piecolumn);
            print_r($piedata);
            exit; */
            $orders = [];
            $orders['codelist'] = $codelist;
            $orders['orderlist'] = $orderlist;
            $orders['datalist'] = $datalist;
            $orders['piecolumn'] = $piecolumn;
            $orders['piedata'] = $piedata;
            $orders['piecolumn30'] = $piecolumn30;
            $orders['piedata30'] = $piedata30;
            Cache::set($key, $orders, 300);
        }

        $this->view->assign($orders['datalist']);
        $this->assignconfig('column', array_keys($orders['codelist']));
        $this->assignconfig('codelistdata', array_values($orders['codelist']));
        $this->assignconfig('orderlistdata', array_values($orders['orderlist']));
        $this->assignconfig('piecolumn', $orders['piecolumn']);
        $this->assignconfig('piedata', $orders['piedata']);
        $this->assignconfig('piecolumn30', $orders['piecolumn30']);
        $this->assignconfig('piedata30', $orders['piedata30']);

        $this->assign('isadmin', $this->auth->id == 1);

        return $this->view->fetch();
    }
}