deshu/application/admin/controller/Users.php

<?php

namespace app\admin\controller;

use library\Controller;
use library\tools\Data;
use think\Db;

/**
 * 系统用户管理
 * Class Users
 * @package app\admin\controller
 */
class Users extends Controller
{

    /**
     * 指定当前数据表
     * @var string
     */
    public $table = 'user';

    /**
     * 系统用户管理
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {

        $level = $this->request->get('level');

        if (!$level) $level = 0;

        $where['level'] = $level;
        $this->title = '系统用户管理';
        $query = $this->_query($this->table)->where($where)->like('username,mobile')->equal('is_deleted');
        $query->dateBetween('login_at,create_at')->where($where)->order('id desc')->page();
    }
    /**
     * 数据列表处理
     */
    protected function _index_page_filter(&$data)
    {
      $level = [
      '0' => '业主',
      '1' => '德叔客户',
      '2' => '分销客户',
      ];
      foreach($data as &$v) {

         $v['level'] = $level[$v['level']];
      }

    }
    /**
     * 添加系统用户
     * @auth true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function add()
    {
        $this->applyCsrfToken();
        $this->_form($this->table, 'form');
    }

    /**
     * 编辑系统用户
     * @auth true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function edit()
    {


        $this->applyCsrfToken();

        $this->_form($this->table, 'form');


    }

    /**
     * 修改用户密码
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function pass()
    {
        $this->applyCsrfToken();
        if ($this->request->isGet()) {
            $this->verify = false;
            $this->_form($this->table, 'pass');
        } else {
            $post = $this->request->post();
            $data = [
              'uid' => $post['id'],
              'video' => $post['logo'],
              'image' => $post['image'],
              'create_time' => date('Y-m-d H:i',time()),

            ];
            $add = Db::name('user_image')->insert($data);
             if ($add) {
                $this->success('上传成功', '');
             } else {
                    $this->error('上传成功');
             }

        }
    }

    /**
     * 表单数据处理
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function _form_filter(&$data)
    {
     $type = $this->request->get('type');
     $data['type'] = $type;

        if ($this->request->isPost()) {


            if ($data['integral'] == 0) {
               $this->error("请输入要修改数值");
            }

            $user = Db::name('user')->where('id',$data['id'])->find();
            if (substr($data['integral'],0,1)=='-') {

               $integralStr = $data['integral'];
               $integral = $user['integral']-abs($data['integral']);

               if ($integral<0) $integral = 0;
            } else {
               $integralStr = '+'.$data['integral'];
               $integral = $user['integral'] + $data['integral'];

            }
            $data['integral'] = $integral;

            $ins = [
            'uid' => $data['id'],
            'resan' => $data['resan'],
            'create_time' => date('Y-m-d H:i',time()),
            'integral' => $integralStr,
            ];

            Db::name('user_integral_history')->insert($ins);
            // 用户权限处理
            $data['authorize'] = (isset($data['authorize']) && is_array($data['authorize'])) ? join(',', $data['authorize']) : '';
            // 用户账号重复检查
            if (isset($data['id'])) unset($data['username']);
            elseif (Db::name($this->table)->where(['username' => $data['username'], 'is_deleted' => '0'])->count() > 0) {
                $this->error("账号{$data['username']}已经存在，请使用其它账号！");
            }
        } else {
            $data['authorize'] = explode(',', isset($data['authorize']) ? $data['authorize'] : '');
            $this->authorizes = Db::name('SystemAuth')->where(['status' => '1'])->order('sort desc,id desc')->select();
        }
    }

    /**
     * 禁用系统用户
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function forbid()
    {
        if (in_array('10000', explode(',', $this->request->post('id')))) {
            $this->error('系统超级账号禁止操作！');
        }
        $this->applyCsrfToken();
        $this->_save($this->table, ['status' => '0']);
    }

    /**
     * 启用系统用户
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function resume()
    {
        $this->applyCsrfToken();
        $this->_save($this->table, ['status' => '1']);
    }

    /**
     * 删除系统用户
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function remove()
    {
        if (in_array('10000', explode(',', $this->request->post('id')))) {
            $this->error('系统超级账号禁止删除！');
        }
        $this->applyCsrfToken();
        $this->_delete($this->table);
    }

}