gaoyixia/application/admin/controller/Index.php

<?php

// +----------------------------------------------------------------------
// | ThinkAdmin
// +----------------------------------------------------------------------
// | 版权所有 2014~2019 广州楚才信息科技有限公司 [ http://www.cuci.cc ]
// +----------------------------------------------------------------------
// | 官方网站: http://demo.thinkadmin.top
// +----------------------------------------------------------------------
// | 开源协议 ( https://mit-license.org )
// +----------------------------------------------------------------------
// | gitee 代码仓库：https://gitee.com/zoujingli/ThinkAdmin
// | github 代码仓库：https://github.com/zoujingli/ThinkAdmin
// +----------------------------------------------------------------------

namespace app\admin\controller;

use app\api\controller\Order;
use app\common\model\BillApply;
use app\common\model\GoodsOrder;
use app\common\model\LevelOrder;
use app\common\model\StoreOrderRefund;
use app\common\model\UserForum;
use app\common\model\UserDatum;
use app\common\model\UserArticle;
use app\common\model\UserReport;
use app\common\model\UserVideo;
use app\order\controller\StoreOrder;
use library\Controller;
use library\service\AdminService;
use library\service\MenuService;
use library\tools\Data;
use think\Console;
use think\Db;
use think\exception\HttpResponseException;

/**
 * 系统公共操作
 * Class Index
 * @package app\admin\controller
 */
class Index extends Controller
{

    /**
     * 显示后台首页
     * @throws \ReflectionException
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function index()
    {
        $this->title = '系统管理后台';
        $auth = AdminService::instance()->apply(true);
        $this->menus = MenuService::instance()->getTree();
        $where[] = ['f.is_deleted','=',0];
        $where[] = ['f.is_new','=',1];
        //问答
        $forum = UserForum::alias('f')
            ->field("f.*,u.name,u.phone,u.headimg,IFNULL((SELECT  count(r.id) reply_num FROM dd_forum_reply as r where r.forum_id = f.id AND r.is_deleted = 0),0) reply_num")
            ->leftJoin('store_member u','u.id = f.user_id')
            ->where($where)
            ->order('sort desc,f.id desc')->count();
        if($forum > 0){
            $this->forum = 1; //有新增
        }else{
            $this->forum = 0; //无新增
        }
        //资料
        $datum = UserDatum::alias('f')->where($where)->count();
        if($datum > 0){
            $this->datum = 1; //有新增
        }else{
            $this->datum = 0; //无新增
        }
        //图文
        $article = UserArticle::alias('f')->where($where)->count();
        if($article > 0){
            $this->article = 1; //有新增
        }else{
            $this->article = 0; //无新增
        }
        //图文
        $video = UserVideo::alias('f')->where($where)->count();
        if($video > 0){
            $this->video = 1; //有新增
        }else{
            $this->video = 0; //无新增
        }
        //商城订单
        $order = GoodsOrder::alias('f')->where($where)->count();
        if($order > 0){
            $this->order = 1; //有新增
        }else{
            $this->order = 0; //无新增
        }
        //会员订单
        $level_order = LevelOrder::alias('f')->where($where)->count();
        if($level_order > 0){
            $this->level_order = 1; //有新增
        }else{
            $this->level_order = 0; //无新增
        }
        //售后订单
        $refund_order = StoreOrderRefund::alias('f')->where($where)->count();
        if($refund_order > 0){
            $this->refund_order = 1; //有新增
        }else{
            $this->refund_order = 0; //无新增
        }
        //开票申请
        $bill_apply = BillApply::alias('f')->where($where)->count();
        if($bill_apply > 0){
            $this->bill_apply = 1; //有新增
        }else{
            $this->bill_apply = 0; //无新增
        }
        //评论举报-资料
        $datum_report = UserReport::alias('f')->where($where)->where('type',10)->count();
        if($datum_report > 0){
            $this->datum_report = 1; //有新增
        }else{
            $this->datum_report = 0; //无新增
        }
        //评论举报-图文
        $article_report = UserReport::alias('f')->where($where)->where('type',8)->count();
        if($article_report > 0){
            $this->article_report = 1; //有新增
        }else{
            $this->article_report = 0; //无新增
        }
        //评论举报-视频
        $video_report = UserReport::alias('f')->where($where)->where('type',2)->count();
        if($video_report > 0){
            $this->video_report = 1; //有新增
        }else{
            $this->video_report = 0; //无新增
        }

        if (empty($this->menus) && !$auth->isLogin()) {
            $this->redirect('@admin/login');
        } else {
            $this->fetch();
        }
    }

    /**
     * 后台环境信息
     */
    public function main()
    {
        $this->think_ver = \think\App::VERSION;
        $this->mysql_ver = Db::query('select version() as ver')[0]['ver'];
        $beginYesterday=mktime(0,0,0,date('m'),date('d')-1,date('Y'));
        $endYesterday=mktime(0,0,0,date('m'),date('d'),date('Y'))-1;
        $beginToday=mktime(0,0,0,date('m'),date('d'),date('Y'));
        $endToday=mktime(0,0,0,date('m'),date('d')+1,date('Y'))-1;

        $user_num = \app\common\model\User::where('status',1)->where('is_deleted',0)->count();
        $agency_num =  \app\common\model\User::where('is_agency',1)->where('is_deleted',0)->count();
        $partner_num =  \app\common\model\User::where('is_partner',1)->where('is_deleted',0)->count();
        $goods_num =  \app\common\model\StoreGoods::where('is_deleted',0)->count();
        $order_num =  \app\common\model\GoodsOrder::where('status','>=',1)->count();
        $order_money =  \app\common\model\GoodsOrder::where('status','>=',1)->sum('price_total');
        $gift_order_num =  \app\common\model\GiftOrder::count();
        $gift_order_money =  \app\common\model\GiftOrder::where('status',1)->sum('price_total');
        $news_num =  \app\common\model\InformationArticle::where('is_deleted',0)->count();
        $video_num =  \app\common\model\VideoIntro::where('is_deleted',0)->count();

        $new_user =  \app\common\model\User::where('status',1)->whereBetweenTime('create_at',$beginToday,$endToday)->count();


        $data = [
            'user_num' => $user_num,
            'agency_num' => $agency_num,
            'partner_num' => $partner_num,
            'goods_num' => $goods_num,
            'order_num' => $order_num,
            'order_money' => $order_money,
            'news_num' => $news_num,
            'video_num' => $video_num,
            'new_user' => $new_user,
            'gift_order_num' => $gift_order_num,
            'gift_order_money' => $gift_order_money,
        ];
        $this->assign('data',$data);
        $this->fetch();
    }

    /**
     * 修改密码
     * @login true
     * @param integer $id
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function pass($id)
    {
        $this->applyCsrfToken();
        if (intval($id) !== intval(session('user.id'))) {
            $this->error('只能修改当前用户的密码！');
        }
        if (!AdminService::instance()->isLogin()) {
            $this->error('需要登录才能操作哦！');
        }
        if ($this->request->isGet()) {
            $this->verify = true;
            $this->_form('SystemUser', 'admin@user/pass', 'id', [], ['id' => $id]);
        } else {
            $data = $this->_input([
                'password'    => $this->request->post('password'),
                'repassword'  => $this->request->post('repassword'),
                'oldpassword' => $this->request->post('oldpassword'),
            ], [
                'oldpassword' => 'require',
                'password'    => 'require|min:4',
                'repassword'  => 'require|confirm:password',
            ], [
                'oldpassword.require' => '旧密码不能为空！',
                'password.require'    => '登录密码不能为空！',
                'password.min'        => '登录密码长度不能少于4位有效字符！',
                'repassword.require'  => '重复密码不能为空！',
                'repassword.confirm'  => '重复密码与登录密码不匹配，请重新输入！',
            ]);
            $user = Db::name('SystemUser')->where(['id' => $id])->find();
            if (md5($data['oldpassword']) !== $user['password']) {
                $this->error('旧密码验证失败，请重新输入！');
            }
            if (Data::save('SystemUser', ['id' => $user['id'], 'password' => md5($data['password'])])) {
                $this->success('密码修改成功，下次请使用新密码登录！', '');
            } else {
                $this->error('密码修改失败，请稍候再试！');
            }
        }
    }

    /**
     * 修改用户资料
     * @login true
     * @param integer $id 会员ID
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function info($id = 0)
    {
        if (!AdminService::instance()->isLogin()) {
            $this->error('需要登录才能操作哦！');
        }
        $this->applyCsrfToken();
        if (intval($id) === intval(session('user.id'))) {
            $this->_form('SystemUser', 'admin@user/form', 'id', [], ['id' => $id]);
        } else {
            $this->error('只能修改登录用户的资料！');
        }
    }

    /**
     * 清理运行缓存
     * @auth true
     */
    public function clearRuntime()
    {
        try {
            Console::call('clear');
            Console::call('xclean:session');
            $this->success('清理运行缓存成功！');
        } catch (HttpResponseException $exception) {
            throw $exception;
        } catch (\Exception $e) {
            $this->error("清理运行缓存失败，{$e->getMessage()}");
        }
    }

    /**
     * 压缩发布系统
     */
    public function buildOptimize()
    {
        try {
            Console::call('optimize:route');
            Console::call('optimize:schema');
            Console::call('optimize:autoload');
            Console::call('optimize:config');
            $this->success('压缩发布成功！');
        } catch (HttpResponseException $exception) {
            throw $exception;
        } catch (\Exception $e) {
            $this->error("压缩发布失败，{$e->getMessage()}");
        }
    }

}