| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309 | <?phpnamespace app\admin\controller\auth;use app\admin\model\AuthGroup;use app\admin\model\AuthGroupAccess;use app\common\controller\Backend;use fast\Random;use fast\Tree;use think\Db;use think\Validate;/** * 管理员管理 * * @icon   fa fa-users * @remark 一个管理员可以有多个角色组,左侧的菜单根据管理员所拥有的权限进行生成 */class Admin extends Backend{    /**     * @var \app\admin\model\Admin     */    protected $model = null;    protected $selectpageFields = 'id,username,nickname,avatar';    protected $searchFields = 'id,username,nickname';    protected $childrenGroupIds = [];    protected $childrenAdminIds = [];    public function _initialize()    {        parent::_initialize();        $this->model = model('Admin');        $this->childrenAdminIds = $this->auth->getChildrenAdminIds($this->auth->isSuperAdmin());        $this->childrenGroupIds = $this->auth->getChildrenGroupIds($this->auth->isSuperAdmin());        $groupList = collection(AuthGroup::where('id', 'in', $this->childrenGroupIds)->select())->toArray();        Tree::instance()->init($groupList);        $groupdata = [];        if ($this->auth->isSuperAdmin()) {            $result = Tree::instance()->getTreeList(Tree::instance()->getTreeArray(0));            foreach ($result as $k => $v) {                $groupdata[$v['id']] = $v['name'];            }        } else {            $result = [];            $groups = $this->auth->getGroups();            foreach ($groups as $m => $n) {                $childlist = Tree::instance()->getTreeList(Tree::instance()->getTreeArray($n['id']));                $temp = [];                foreach ($childlist as $k => $v) {                    $temp[$v['id']] = $v['name'];                }                $result[__($n['name'])] = $temp;            }            $groupdata = $result;        }        $this->view->assign('groupdata', $groupdata);        $this->assignconfig("admin", ['id' => $this->auth->id]);        //门店列表        $company_data = Db::name('company')->column('id,name');        $this->view->assign('company_data', $company_data);    }    /**     * 查看     */    public function index()    {        //设置过滤方法        $this->request->filter(['strip_tags', 'trim']);        if ($this->request->isAjax()) {            //如果发送的来源是Selectpage,则转发到Selectpage            if ($this->request->request('keyField')) {                return $this->selectpage();            }            $childrenGroupIds = $this->childrenGroupIds;            $groupName = AuthGroup::where('id', 'in', $childrenGroupIds)                ->column('id,name');            $authGroupList = AuthGroupAccess::where('group_id', 'in', $childrenGroupIds)                ->field('uid,group_id')                ->select();            $adminGroupName = [];            foreach ($authGroupList as $k => $v) {                if (isset($groupName[$v['group_id']])) {                    $adminGroupName[$v['uid']][$v['group_id']] = $groupName[$v['group_id']];                }            }            $groups = $this->auth->getGroups();            foreach ($groups as $m => $n) {                $adminGroupName[$this->auth->id][$n['id']] = $n['name'];            }            list($where, $sort, $order, $offset, $limit) = $this->buildparams();            $list = $this->model                ->where($where)                ->where('id', 'in', $this->childrenAdminIds)                ->field(['password', 'salt', 'token'], true)                ->order($sort, $order)                ->paginate($limit);            foreach ($list as $k => &$v) {                $groups = isset($adminGroupName[$v['id']]) ? $adminGroupName[$v['id']] : [];                $v['groups'] = implode(',', array_keys($groups));                $v['groups_text'] = implode(',', array_values($groups));            }            unset($v);            $result = array("total" => $list->total(), "rows" => $list->items());            return json($result);        }        return $this->view->fetch();    }    /**     * 添加     */    public function add()    {        if ($this->request->isPost()) {            $this->token();            $params = $this->request->post("row/a");            if ($params) {                Db::startTrans();                try {                    if (!Validate::is($params['password'], '\S{6,30}')) {                        exception(__("Please input correct password"));                    }                    $params['salt'] = Random::alnum();                    $params['password'] = md5(md5($params['password']) . $params['salt']);                    $params['avatar'] = '/assets/img/avatar.png'; //设置新管理员默认头像。                    //公司                    $params['company_id'] = $this->request->post('company_id');                    //公司                    $result = $this->model->validate('Admin.add')->save($params);                    if ($result === false) {                        exception($this->model->getError());                    }                    $group = $this->request->post("group/a");                    //过滤不允许的组别,避免越权                    $group = array_intersect($this->childrenGroupIds, $group);                    if (!$group) {                        exception(__('The parent group exceeds permission limit'));                    }                    $dataset = [];                    foreach ($group as $value) {                        $dataset[] = ['uid' => $this->model->id, 'group_id' => $value];                    }                    model('AuthGroupAccess')->saveAll($dataset);                    Db::commit();                } catch (\Exception $e) {                    Db::rollback();                    $this->error($e->getMessage());                }                $this->success();            }            $this->error(__('Parameter %s can not be empty', ''));        }        return $this->view->fetch();    }    /**     * 编辑     */    public function edit($ids = null)    {        $row = $this->model->get(['id' => $ids]);        if (!$row) {            $this->error(__('No Results were found'));        }        if (!in_array($row->id, $this->childrenAdminIds)) {            $this->error(__('You have no permission'));        }        if ($this->request->isPost()) {            $this->token();            $params = $this->request->post("row/a");            if ($params) {                Db::startTrans();                try {                    if ($params['password']) {                        if (!Validate::is($params['password'], '\S{6,30}')) {                            exception(__("Please input correct password"));                        }                        $params['salt'] = Random::alnum();                        $params['password'] = md5(md5($params['password']) . $params['salt']);                    } else {                        unset($params['password'], $params['salt']);                    }                    //公司                    $params['company_id'] = $this->request->post('company_id');                    //公司                    //这里需要针对username和email做唯一验证                    $adminValidate = \think\Loader::validate('Admin');                    $adminValidate->rule([                        'username' => 'require|regex:\w{3,30}|unique:admin,username,' . $row->id,                        'email'    => 'require|email|unique:admin,email,' . $row->id,                        'mobile'    => 'regex:1[3-9]\d{9}|unique:admin,mobile,' . $row->id,                        'password' => 'regex:\S{32}',                    ]);                    $result = $row->validate('Admin.edit')->save($params);                    if ($result === false) {                        exception($row->getError());                    }                    // 先移除所有权限                    model('AuthGroupAccess')->where('uid', $row->id)->delete();                    $group = $this->request->post("group/a");                    // 过滤不允许的组别,避免越权                    $group = array_intersect($this->childrenGroupIds, $group);                    if (!$group) {                        exception(__('The parent group exceeds permission limit'));                    }                    $dataset = [];                    foreach ($group as $value) {                        $dataset[] = ['uid' => $row->id, 'group_id' => $value];                    }                    model('AuthGroupAccess')->saveAll($dataset);                    Db::commit();                } catch (\Exception $e) {                    Db::rollback();                    $this->error($e->getMessage());                }                $this->success();            }            $this->error(__('Parameter %s can not be empty', ''));        }        $grouplist = $this->auth->getGroups($row['id']);        $groupids = [];        foreach ($grouplist as $k => $v) {            $groupids[] = $v['id'];        }        $this->view->assign("row", $row);        $this->view->assign("groupids", $groupids);        return $this->view->fetch();    }    /**     * 删除     */    public function del($ids = "")    {        if (!$this->request->isPost()) {            $this->error(__("Invalid parameters"));        }        $ids = $ids ? $ids : $this->request->post("ids");        if ($ids) {            $ids = array_intersect($this->childrenAdminIds, array_filter(explode(',', $ids)));            // 避免越权删除管理员            $childrenGroupIds = $this->childrenGroupIds;            $adminList = $this->model->where('id', 'in', $ids)->where('id', 'in', function ($query) use ($childrenGroupIds) {                $query->name('auth_group_access')->where('group_id', 'in', $childrenGroupIds)->field('uid');            })->select();            if ($adminList) {                $deleteIds = [];                foreach ($adminList as $k => $v) {                    $deleteIds[] = $v->id;                }                $deleteIds = array_values(array_diff($deleteIds, [$this->auth->id]));                if ($deleteIds) {                    Db::startTrans();                    try {                        $this->model->destroy($deleteIds);                        model('AuthGroupAccess')->where('uid', 'in', $deleteIds)->delete();                        Db::commit();                    } catch (\Exception $e) {                        Db::rollback();                        $this->error($e->getMessage());                    }                    $this->success();                }                $this->error(__('No rows were deleted'));            }        }        $this->error(__('You have no permission'));    }    /**     * 批量更新     * @internal     */    public function multi($ids = "")    {        // 管理员禁止批量操作        $this->error();    }    /**     * 下拉搜索     */    public function selectpage()    {        $this->dataLimit = 'auth';        $this->dataLimitField = 'id';        return parent::selectpage();    }}
 |