deshu/application/admin/controller/Uuser.php

<?php

namespace app\admin\controller;

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

/**
 * 系统用户管理
 * Class Uuser
 * @package app\admin\controller
 */
class Uuser 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 = '系统用户管理';
        $this->level = $level;
        $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['levels'] = $v['level'];
            $v['level'] = $level[$v['level']];
//
//            $len =  strlen($v['content']);
//            $str = '';
//            $num = ceil($len/20);
//            for ($i=0;$i<$num;$i++) {
//                if ($i==0) {
//                    $str = substr($v['content'],0,20);
//
//                } else {
//                    $str = $str. substr($v['content'],$i*20,$i*20+20).'<br />';
//                }
//
//            }
//            $v['content'] = $str;
        }

    }
    /**
     * 添加系统用户
     * @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\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function edits()
    {


        $this->applyCsrfToken();
        if ($this->request->isGet()) {
            $this->verify = false;
            $this->_form($this->table, 'edits');
        } else {

            $post = $this->request->post();

            $data = [];
            if (isset($post['pwd']) && !empty($post['pwd'])) {
                if ($post['pwd'] != $post['repassword']) return $this->error('两次密码输入不一致');

                $data['pwd'] = md5(md5($post['pwd']));
            }

            $data['username'] = $post['username'];
            $data['mobile'] = $post['mobile'];
            $data['avatar'] = $post['avatar'];
            $data['content'] = $post['content'];

            $upd = Db::name('user')->where('id',$post['id'])->update($data);

            if ($upd) {
                return $this->success('编辑成功');
            } else {
                return $this->error('编辑失败');
            }
//            $upd = Db::name('where')
        }

    }
    /**
     * 编辑系统用户修改其他信息
     * @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 beizhu()
    {
        $this->applyCsrfToken();
        if ($this->request->isGet()) {
            $this->verify = false;
            $this->_form($this->table, 'beizhu');
        } else {

            $post = $this->request->post();

            $data['content'] = $post['content'];

            $upd = Db::name('user')->where('id',$post['id'])->update($data);

            if ($upd) {
                return $this->success('编辑成功');
            } else {
                return $this->error('编辑失败');
            }
//            $upd = Db::name('where')
        }

    }
    /**
     * 修改用户密码
     * @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()
    {
        $id = $this->request->post('id');

        $del = Db::name('user')->where('id',$id)->delete();

        if ($del) {

            Db::name('user_appointment')->where('uid',$id)->delete();
            Db::name('user_weixiu_baobei')->where('uid',$id)->delete();
            return $this->success('删除成功');
        } else {
            return $this->error('删除失败');
        }
        if (in_array('10000', explode(',', $this->request->post('id')))) {
            $this->error('系统超级账号禁止删除！');
        }
        $this->applyCsrfToken();
        $this->_delete($this->table);
    }

}