youting/application/admin/controller/unishop/Dashboard.php

<?php

namespace app\admin\controller\unishop;

use app\admin\model\unishop\Goods;
use app\admin\model\unishop\Income;
use app\common\controller\Backend;
use fast\Date;

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

    public function _initialize()
    {
        parent::_initialize();
    }

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

        }
        $column = [];
        $starttime = Date::unixtime('day', -30);
        $endtime = Date::unixtime('day', 0, 'end');
        $joinlist = Db("unishop_order")
            ->where('status = 1 and have_paid != 0')
            ->where('createtime', 'between time', [$starttime, $endtime])
            ->field('createtime, COUNT(*) AS nums, DATE_FORMAT(FROM_UNIXTIME(createtime), "%m-%d") AS create_time')
            ->group('createtime')
            ->select();
        for ($time = $starttime; $time <= $endtime;) {
            $column[] = date("m-d", $time);
            $time += 86400;
        }
        $orderlist = array_fill_keys($column, 0);
        foreach ($joinlist as $k => $v) {
            $orderlist[$v['create_time']] = $v['nums'];
        }

        $this->view->assign([
            'totalCategory' => \app\admin\model\unishop\Category::count(),
            'goodsNums' => \app\admin\model\unishop\Product::count(),
            'orderNums' => (new \app\admin\model\unishop\Order)->where('status = 1 and have_paid != 0')->count(),
            'totalCoupon' => \app\admin\model\unishop\Coupon::count(),
            'totalAds' => \app\admin\model\unishop\Ads::count(),
            'orderAmount' => (new Income)->sum('order_amount'),
        ]);

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

    /**
     * 收入明细
     */
    public function income()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags']);

        try {
            \think\Db::execute("SET @@sql_mode='';");
        } catch (\Exception $e) {

        }

        $model = new Income();
        list($where, $sort, $order, $offset, $limit) = $this->buildparams();
        $total = $model
            ->where($where)
            ->field('DATE_FORMAT(FROM_UNIXTIME(date_time), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->count();

        $list = $model
            ->where($where)
            ->field('date_time,SUM(order_amount) as order_amount,COUNT(*) as order_nums,DATE_FORMAT(FROM_UNIXTIME(date_time), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->order($sort, $order)
            ->limit($offset, $limit)
            ->select();

        $result = array(
            "total" => $total,
            "rows" => $list,
            'join_date' => array_column($list, 'join_date'),
            'order_amount' => array_column($list, 'order_amount'),
            'order_nums' => array_column($list, 'order_nums'),
        );

        return json($result);
    }


    /**
     * 商品销量
     */
    public function goods()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags']);

        try {
            \think\Db::execute("SET @@sql_mode='';");
        } catch (\Exception $e) {

        }

        $model = new Goods();
        list($where, $sort, $order, $offset, $limit) = $this->buildparams();
        $total = $model
            ->where($where)
            ->field('DATE_FORMAT(FROM_UNIXTIME(date_time), "%Y-%m-%d") AS join_date')
            ->group('join_date')
            ->count();

        $list = $model
            ->where($where)
            ->field('date_time,SUM(number) as sell_total,product_id,product_name,DATE_FORMAT(FROM_UNIXTIME(date_time), "%Y-%m-%d") AS join_date')
            ->group('join_date,product_id')
            ->order($sort, $order)
            ->order('sell_total', 'desc')
            ->limit($offset, $limit)
            ->select();

        $result = array(
            "total" => $total,
            "rows" => $list
        );

        return json($result);
    }
}