model = new StaffModel(); $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); $tree = Tree::instance()->init($groupList,'pid'); // halt($tree); $groupdata = []; $authlist = []; if ($this->auth->isSuperAdmin()) { $result = Tree::instance()->getTreeList(Tree::instance()->getTreeArray(0)); $authlist = $result; foreach ($result as $k => $v) { $groupdata[$v['id']] = $v['name']; } } else { $result = []; $groups = $this->auth->getGroups(); // halt($groups); // $childlist = Tree::instance()->getTreeList(Tree::instance()->getTreeArray($n['id'])); // $authlist = $groups; $authlist = $groups; // halt($authlist); foreach ($groups as $m => $n) { $childlist = Tree::instance()->getTreeList(Tree::instance()->getTreeArray($n['id'])); $temp = []; foreach ($childlist as $k => $v) { $authlist[] = $v; $temp[$v['id']] = $v['name']; } $result[__($n['name'])] = $temp; } $groupdata = $result; } // $groupList // halt($authlist); $channelList = []; foreach($authlist as &$val){ $val = str_replace(' ','',str_replace('├','',str_replace('└','',str_replace(' ', '', $val)))); $data = [ 'id' => $val['id'], 'parent' => $val['pid'] ? $val['pid'] : '#', 'text' => $val['name'], ]; $channelList[] = $data; // if() } $lookup = []; foreach ($channelList as $item) { $lookup[$item['id']] = $item; } // 遍历数组,检查并更新 parent foreach ($channelList as &$item) { $parentId = $item['parent']; // 如果上级不存在,则将上级 ID 改为 # if (!isset($lookup[$parentId])) { $item['parent'] = '#'; } } //halt($channelList); $this->assignconfig('channelList', $channelList); // halt($channelList); $this->view->assign('groupdata', $groupdata); } public function export(){ $list = $this->model->where('status', '1')->where('deletetime','null')->select(); $data = []; foreach ($list as $item){ $group_ids = $item['group_ids']; $group_name =implode(',',AuthGroup::where("find_in_set(id, '$group_ids')")->column('name')); //halt($item); $data[]=[ 'staff'=>$item['name'], //姓名 'group_name'=>$group_name, 'post'=>$item['post'], ]; } $title = [ '姓名', '部门', '岗位', ]; $file = export_excel($title, $data, '通讯录'); if ($file['filePath']) { $this->success('导出成功', '', $file); } $this->error('导出失败'); } /** * 员工列表 * @return string */ public function index() { $this->request->filter(['strip_tags']); if ($this->request->isAjax()) { // 单独处理组别 $filter = $this->request->get("filter", ''); $op=$this->request->get("op", '', 'trim'); $filter = (array)json_decode($filter, true); $op = (array)json_decode($op, true); $dateFilter=[];//将筛选的值放在这里 if(isset($filter['group_ids'])){ // $dateFilter=$filter['createtime']; $dateFilter['group_ids'] = $filter['group_ids']; unset($filter['group_ids']); unset($op['group_ids']); //去掉了createtime 的filter 重新组织到 request中 交给下面 buildparams()方法去构建query 的条件 \think\Request::instance()->get(['filter'=>json_encode($filter)]); \think\Request::instance()->get(['op'=>json_encode($op)]); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $wheres=[]; $wheres['id']=['in',StaffModel::getMyStaffIds()]; // halt($this->model // ->where($where)->fetchSql()->where(function($query)use($dateFilter){ // if(!empty($dateFilter['group_ids'])){ // foreach (explode(',',$dateFilter['group_ids']) as $id) { // $query->whereRaw("FIND_IN_SET($id, group_ids) > 0"); // } // } // })->select()); $list = $this->model->with(['parent','admin','staffrole']) ->where($where)->order($sort, $order)->where(function($query)use($dateFilter){ if(!empty($dateFilter['group_ids'])){ foreach (explode(',',$dateFilter['group_ids']) as $id) { $query->whereOr('FIND_IN_SET(' . $id . ', group_ids) > 0'); } } })->where('status',"<>",2)->paginate($limit); $row = $list->items(); $result = array("total" => $list->total(), "rows" => $row); return json($result); } return $this->view->fetch(); } /** * 添加员工 * @return string */ public function add() { if ($this->request->isAjax()) { $data = $this->request->post('row/a'); $mobile=$data['mobile']; $count = StaffModel::where(['mobile'=>$mobile])->count(); if($count > 0){ $this->error('员工手机号已存在'); } $newSalt = substr(md5(uniqid(true)), 0, 6); $newPassword = md5(md5($data['password']) . $newSalt); $data['salt'] = $newSalt; $data['password'] = $newPassword; $data['status'] = 1; if(!empty($data['img'])){ $data['img'] = '/assets/img/avatar.png'; //设置新管理员默认头像。 } if(empty($data['sr'])){ $data['sr'] = strtotime($data['sr']); } Db::startTrans(); try { $group = $this->request->post("group/a"); //过滤不允许的组别,避免越权 $group = array_intersect($this->childrenGroupIds, $group); if (!$group) { exception(__('The parent group exceeds permission limit')); } $data['group_ids']=implode(',',$group); // halt(1); $result = $this->model->save($data); Db::commit(); }catch (Exception $e){ Db::rollback(); $this->error($e->getMessage()); } if (!$result) { $this->error('提交失败'); } $this->success('提交成功'); } $staffname = StaffModel::where([])->column('id,name'); $staffs = ['' => '无']; foreach ($staffname as $id => $name) { $staffs[$id] = $name; } $this->view->assign('roles',StaffRole::where([])->column('name','id')); $this->view->assign('staffs', $staffs); return $this->view->fetch(); } /** * 修改员工 * @param null $ids * @return string */ public function edit($ids = null) { $map['id'] = $ids; if ($this->request->isAjax()) { $data = $this->request->post('row/a'); if($data['password']){ $newSalt = substr(md5(uniqid(true)), 0, 6); $newPassword = md5(md5($data['password']) . $newSalt); $data['salt'] = $newSalt; $data['password'] = $newPassword; }else{ unset($data['password']); } $mobile=$data['mobile']; $count = StaffModel::where(['mobile'=>$mobile,'id'=>['neq',$ids]])->count(); if($count > 0){ $this->error('员工手机号已存在'); } if(empty($data['img'])){ $data['img'] = '/assets/img/avatar.png'; //设置新管理员默认头像。 } if(!empty($data['sr'])){ $data['sr'] = strtotime($data['sr']); } // halt($data); Db::startTrans(); try { $group = $this->request->post("group/a",[]); //过滤不允许的组别,避免越权 $group = array_intersect($this->childrenGroupIds, $group); if (!$group) { exception(__('The parent group exceeds permission limit')); } $data['group_ids']=implode(',',$group); $data['id']=$map['id']; $result=$this->model->save($data,$map); Db::commit(); }catch (Exception $e){ Db::rollback(); $this->error($e->getMessage()); } if (!$result) { $this->error('修改失败'); } $this->success('修改成功'); } $data = StaffModel::where($map)->find(); $data['sr'] = date('Y-m-d',$data['sr']); $this->view->assign("row", $data); $staffname = StaffModel::where([])->column('id,name'); $staffs = ['' => '无']; foreach ($staffname as $id => $name) { $staffs[$id] = $name; } $this->view->assign('roles',StaffRole::where([])->column('name','id')); $this->view->assign('staffs', $staffs); return $this->view->fetch(); } /** * 删除员工 */ public function del($ids = null) { if ($this->request->isAjax()) { $map['id'] = array('in', $ids); $findinfo = StaffModel::where($map)->select(); foreach($findinfo as $k=>$v){ if($v['admin_id'] ==1){ $this->error('管理员不可删除'); } } $result = StaffModel::destroy($map); if (!$result) { $this->error('删除失败'); } $cids = Customer::where(['owner_staff_id' => $ids])->column('id'); try { foreach ($cids as $id) { Customer::moveSeas($id); } } catch (Exception $e) { $this->error($e->getMessage()); } $this->success('删除成功'); } return $this->view->fetch(); } /** * 更新状态禁用账号 */ public function update_status() { $id = input('ids'); $status = input('status', 2, 'intval'); $staff = $this->model->where(['id' => $id])->find(); if (empty($staff)) { $this->error('员工不存在'); } if ($this->model->isUpdate(true)->save(['id' => $id, 'status' => $status])) { $this->success('操作成功'); } $this->error('操作失败'); } /** * 获取员工角色 */ public function getstaffrole(){ $model=new StaffRole(); $result = $model->where([])->field('id,name')->select(); $searchlist = []; foreach ($result as $key => $value) { $searchlist[] = ['id' => $value['id'], 'name' => $value['name']]; } $data = ['searchlist' => $searchlist]; $this->success('', null, $data); } /** * 获取管理员账户 */ public function admin_username() { $params = input('name', ''); $where['username'] = array('like', '%' . $params . '%'); $list = Admin::where($where)->field('id,username as name')->select(); $data['list'] = $list; return json_encode($data); } /** * 获取管理员邮箱 */ public function admin_email() { $params = input('name', ''); $where['email'] = array('like', '%' . $params . '%'); $list = Admin::where($where)->field('id,email as name')->select(); $data['list'] = $list; return json_encode($data); } /** * 获取当前登录员工信息 */ public function info() { $staff = $this->getStaff(); if ($staff) { // 获取admin用户名 $adminUsername = ''; if ($staff->admin_id) { $admin = \app\admin\model\Admin::get($staff->admin_id); if ($admin) { $adminUsername = $admin->username; } } return $this->success('获取成功', '', [ 'id' => $staff->id, 'name' => $staff->name, 'mobile' => $staff->mobile, 'email' => $staff->email, 'admin_id' => $staff->admin_id, 'admin_username' => $adminUsername ]); } else { return $this->error('未找到员工信息'); } } public function selectpage(){ $param = $this->request->param(); $count = $this->model->with(['parent','admin','staffrole']) ->where('status',"<>",2) ->where('name','LIKE','%'.$param['name'].'%') ->count(); $list = $this->model->with(['parent','admin','staffrole']) ->where('status',"<>",2) ->where('name','LIKE','%'.$param['name'].'%') ->page($param['pageNumber'], $param['pageSize']) ->select(); $result = array("total" => $count, "rows" => $list); return json($result); } }