request->only(['username', 'password'], 'post', 'trim'); $val = Validate::rule([ 'username|用户名' => 'require', 'password|密码' => 'require', ]); if (!$val->check($param)) return json_show(1004, $val->getError()); $user = CommonUser::getIns(); $rs = $user->login(array_merge($param, ['plat_code' => 'cx'])); $rs = json_decode($rs, true); if (!isset($rs['code']) || $rs['code'] != 0) return json_show(1004, $rs['message']); switch ($rs['data']['level']){ case 1: $role = [ 'role_name' => '', 'role_level' => $rs['data']['level'], 'role_id' => env('default_admin_addcount_role_id',1),//指定一个默认角色id,1超管 ]; break; case 2: case 3: //获取默认公司 $default = array_column($rs['data']['company_relaton'], 'companyNo', 'is_main'); if (!isset($default) || !isset($default[1])) return json_show(1004, '没有默认公司,无法登录'); $role = Db::name('user_role') ->alias('a') ->field('a.roleid role_id,b.role_name,b.role_level') ->leftJoin('role b', 'b.id=a.roleid') ->where(['a.uid' => $rs['data']['id'], 'a.companyNo' => $default[1], 'a.is_del' => 0]) ->findOrEmpty(); if (empty($role)) return json_show(1004, '没有默认角色,无法登录,请联系管理员'); break; default: return json_show(1004, '没有默认角色,无法登录,请联系管理员'); } $data = array_merge($rs['data'], [ 'role_name' => $role['role_name'], 'role_level' => $role['role_level'], 'role_id' => $role['role_id'], ]); return json_show(0, '登录成功', $data); } public function list() { $param = $this->request->only(['nickname' => '', 'username' => '', 'status' => '', 'page' => 1, 'size' => 10, 'uid' => '', 'nuid' => '', 'companyNo' => ''], 'post', 'trim'); $param['level'] = 1;//只筛选超管用户 $userCommon = CommonUser::getIns(); $rs = $userCommon->GetUserlist($param); $rs = json_decode($rs, true); return json_show($rs['code'], $rs['message'], $rs['data']); } //删除 public function delete() { $param = $this->request->only(['ids'], 'post', 'trim'); $val = Validate::rule([ 'ids' => 'require|array|max:100', ]); if (!$val->check($param)) return json_show(1004, $val->getError()); if (in_array($this->uid, $param['ids'])) return json_show(1004, '自己不能删除自己'); $userCommon = CommonUser::getIns(); $rs = $userCommon->userDelete($param); $rs = json_decode($rs, true); return json_show($rs['code'], $rs['message'], $rs['data']); } //详情 public function userInfo() { $userCommon = CommonUser::getIns(); $rs = json_decode($userCommon->GetUserInfo(['id' => $this->uid]), true); $rs['data']['level'] = $this->level; return json_show($rs['code'], $rs['message'], $rs['data']); } /** * @param token * @param passwd * @return \think\response\Json * @throws \think\exception\DbException */ public function resetPwd() { $post = $this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if ($token == "") { return error_show(101, 'token不能为空'); } $effetc = VerifyTokens($token); if (!empty($effetc) && $effetc['code'] != 0) { return error_show($effetc['code'], $effetc['message']); } $newPwd = isset($post['newpwd']) ? trim($post['newpwd']) : ""; if ($newPwd == "") { return error_show(1001, '新密码不能为空'); } $oldpwd = isset($post['oldpwd']) ? trim($post['oldpwd']) : ""; if ($oldpwd == "") { return error_show(1002, "原密码不能为空"); } $data = resetpasswd($token, ['newpwd' => $newPwd, 'oldpwd' => $oldpwd]); if (empty($userinfo) || $userinfo['code'] != 0) { return error_show($userinfo['code'], $userinfo['message']); } else { return app_show(0, "密码修改成功"); } } //获取所有账号 public function userAll() { $post = $this->request->post(); // $token = isset($post['token']) ? trim($post['token']) : ""; // if ($token == "") { // return app_show(101, 'token不能为空'); // } // $effetc = VerifyTokens($token); // if (!empty($effetc) && $effetc['code'] != 0) { // return app_show($effetc['code'], $effetc['message']); // } // if (isset($post['status']) && $post['status'] !== '') { // $uid = Db::name("user_role")->where(["status" => 1, "is_del" => 0])->column("uid"); // if ($post['status'] == 1) { // $post['uid'] = $uid; // } else { // $post['nouid'] = $uid; // } // unset($post['status']); // } $post['level'] = 2; $userCommon = \app\admin\common\User::getIns(); $userlist = $userCommon->handle('userall', $post); // if (!isset($userlist['code']) || $userlist['code'] != 0) return json_show($userlist['code'], $userlist['message'], $userlist['data']); // $userinfo = GetAccountall($token, $post); // if (empty($userinfo) || $userinfo['code'] != 0) { // return app_show(1002, "员工信息不存在"); // } // $all_uid = array_column($userlist['data'],'id'); //所有角色 // $role = Db::name("user_role") // ->alias('a') // ->leftJoin('role b', "a.roleid = b.id") // ->where("a.uid", "in", $all_uid) // ->column('a.roleid,b.role_name','a.uid'); // $list = []; // foreach ($userlist['data'] as &$value) { // $role = Db::name("user_role") // ->alias('a') // ->leftJoin('role b', "a.roleid = b.id") // ->where("a.uid", "=", $value['id']) // ->field("roleid,role_name,a.status") // ->find(); // $value['roleid'] = $role[$value['id']]['roleid'] ?? 0; // $value['role_name'] = $role[$value['id']]['role_name'] ?? ''; // $depart = Db::name("depart_user")->where([["uid", "=", $value['id']], ["is_del", "=", 0]])->column("itemid"); // $value['depart'] = ""; // $value['status'] = isset($role['status']) ? $role['status'] : '0'; // if (!empty($depart)) { // $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link") // ->select()->toArray(); // // array_walk($deparname, function (&$v) { // $v = array_filter(explode("-", $v['depart_link'])); // }); // $value['depart'] = $deparname; // } // $list[] = $value; // } // return app_show(0, "获取成功", $userlist['data']); } /** * @return \think\response\Json|void * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function userList() { $post = $this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if ($token == "") { return app_show(101, 'token不能为空'); } $effetc = VerifyTokens($token); if (!empty($effetc) && $effetc['code'] != 0) { return app_show($effetc['code'], $effetc['message']); } $itemid = isset($post['itemid']) && $post['itemid'] !== "" ? intval($post['itemid']) : ""; if ($itemid !== "") { $uids = Db::name("depart_user")->where([["itemid", "=", $itemid], ["is_del", "=", 0]])->column("uid"); $post['uid'] = $uids; } if (isset($post['status']) && $post['status'] !== '') { $uid = Db::name("user_role")->where(["status" => 1, "is_del" => 0])->column("uid"); if ($post['status'] == 1) { $post['uid'] = isset($uids) ? array_unique(array_merge($uids, $uid)) : $uid; } else { $post['nouid'] = $uid; } unset($post['status']); } $userinfo = GetList($token, $post); if (empty($userinfo) || $userinfo['code'] != 0) { return app_show($userinfo['code'], $userinfo['msg']); } $data = $userinfo['data']['list']; $list = []; foreach ($data as $value) { $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $value['id']) ->field("roleid,role_name,a.status")->find(); $value['roleid'] = isset($role['roleid']) ? $role['roleid'] : ""; $value['role_name'] = isset($role['role_name']) ? $role['role_name'] : ""; $depart = Db::name("depart_user")->where([["uid", "=", $data['uid']], ["is_del", "=", 0]])->column("itemid"); $value['depart'] = ""; $value['status'] = isset($role['status']) ? $role['status'] : '0'; if (!empty($depart)) { $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link") ->select()->toArray(); $value['depart'] = $deparname; $value['depart_code'] = []; if (!empty($deparname)) { foreach ($deparname as $item) { $value['depart_code'][] = array_filter(explode("-", $item['depart_link'])); } } } $list[] = $value; } return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]); } //账户角色列表 public function userRoleList() { $post = $this->request->only(["token" => "", "nickname" => "", "relaComNo" => "", "level" => "", "username" => "", "companyNo" => "", "status" => "", "page" => 1, "size" => 10], "post"); if ($this->level == 2) { // $companyNo = $post['relaComNo'] ?? ""; $post['companyNo'] = $post['relaComNo'] ?? ""; } $where = [["a.is_del", "=", 0]]; unset($post['relaComNo']); if ($post['companyNo'] != "") { $where[] = ["a.companyNo", "=", $post['companyNo']]; } if ($post['status'] !== '') { $uid = Db::name("user_role") ->alias("a") ->where(["status" => 1, "is_del" => 0]) ->where($where) ->column("uid"); if ($post['status'] == 1) { $where[] = ["a.status", "=", 1]; $post['uid'] = $uid; } else $post['nuid'] = $uid; unset($post['status']); } $userCommon = CommonUser::getIns(); $userinfo = $userCommon->GetList($post); $userinfo = json_decode($userinfo, true); if (empty($userinfo) || $userinfo['code'] != 0) { return app_show($userinfo['code'], $userinfo['msg']); } $data = $userinfo['data']['list']; $list = []; foreach ($data as $value) { $tmp_where=["uid" => $value['id'],"is_del" => 0]; if ($value['level'] != 1) $tmp_where['a.companyNo'] = $value['companyCode']; $roleArr = Db::name("user_role") ->alias("a") ->leftJoin("role b", "a.roleid=b.id") ->where($tmp_where) ->field("role_name,roleid,a.status") ->order(['a.companyNo'=>'desc']) ->findOrEmpty(); $value['roleid'] = $roleArr['roleid'] ?? ""; $value['status'] = $value['status'] == 1 ? ($roleArr['status'] ?? 0) : 0; $value["role_name"] = $roleArr['role_name'] ?? ""; $value["role_level"] = $value['level'] ?? ""; $list[] = $value; } return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]); } //账号角色修改 public function setRole() { //if ($this->level == 1) return json_show(1004, '超管账号不允许设置角色'); $post = $this->request->only(["id", "roleid", 'companyNo'], "post", "trim"); //待修改的账户详情 $userCommon = \app\admin\common\User::getIns(); $userinfo = $userCommon->handle('userinfo', ['id' => $post['id']]); if (!isset($userinfo['code']) || $userinfo['code'] != 0) return json_show($userinfo['code'], $userinfo['message'], $userinfo['data']); $post['level'] = $userinfo['data']['level']; if ($post['level'] == 1) return json_show(1004, '超管账号不允许设置角色'); $valide = Validate::rule([ "id|账户ID" => "require|number|gt:0", // "nickname|名称" => "require|max:255", // "mobile|手机号" => "require|mobile", // "relaComNo|业务公司" => "max:255", "roleid|角色ID" => "require|number|gt:0", "companyNo|业务公司" => "requireIf:level,2|max:255", ]); if ($valide->check($post) == false) return json_show(1004, $valide->getError()); if ($post['roleid'] != 0) { $roleinfo = Db::name("role") ->field('id,status') ->where("id", $post['roleid']) ->find(); if (empty($roleinfo)) return json_show(1002, "角色不存在"); if ($roleinfo['status'] == 0) return json_show(1002, "角色已禁用"); // if ($roleinfo['level'] == 1) return json_show(1002, "超管级别角色不允许设置"); } // if ($this->level == 1) $companyNo = isset($post['companyNo']) && $post['companyNo'] !== '' ? trim($post['companyNo']) : ""; // else $companyNo = isset($post['relaComNo']) && $post['relaComNo'] !== '' ? trim($post['relaComNo']) : ""; // if ($companyNo == "") return json_show(1004, "业务公司编号不能为空"); // $company = Db::name("supplier_info")->where(["code" => $companyNo])->find(); // if ($company == false) return json_show(1004, "业务公司不存在"); // $isSuper = Db::name("user_role")->alias("a") // ->leftJoin("role b", "a.roleid=b.id") // ->where(["a.uid" => $post['id'], "a.is_del" => 0, "b.level" => 1]) // ->findOrEmpty(); // if (!empty($isSuper)) return json_show(1002, "超管账户不允许设置其他角色"); $where = [ ['uid', '=', $post['id']], ['is_del', '=', 0], ]; $is_main = 1; $company_type = 0; if ($post['companyNo'] != '') { $tmp = $userCommon->handle('userCompanyList', ['account_id' => $post['id'], 'companyCode' => $post['companyNo']]); if (!isset($tmp['code']) || $tmp['code'] != 0) return json_show($tmp['code'], $tmp['message'], $tmp['data']); if ($tmp['data']['count'] != 1) return json_show(1005, '尚未绑定该公司'); $is_main = $tmp['data']['list'][0]['is_main']; $company_type = $tmp['data']['list'][0]['company_type']; $where[] = ['companyNo', '=', $post['companyNo']]; } $userrole = Db::name("user_role") ->field('id') ->where($where) ->find(); // $ismain = Db::name("user_role")->where(["uid" => $post['id'], "is_main" => 1, "is_del" => 0])->find(); Db::startTrans(); try { if (empty($userrole)) { $roledata = [ "uid" => $post['id'], "roleid" => $post['roleid'], "nickname" => $userinfo['data']['nickname']??"", "companyNo" => $post['companyNo'] != '' ? $post['companyNo'] : '', "company_type" => $company_type, "is_main" => $is_main, "status" => 1, "addtime" => date("Y-m-d H:i:s"), "updatetime" => date("Y-m-d H:i:s") ]; // $companyarr = [ // [ // "companyCode" => $company["code"], // "companyName" => $company["name"], // "company_type" => $company["type"] == 3 ? 2 : 1, // "is_main" => $ismain ? 0 : 1 // ] // ]; // $companyinfo = ["id" => $post['id'], "company" => $companyarr, "token" => $post['token']]; // $userCommon = \app\admin\common\User::getIns(); // $companyset = $userCommon->handle('setcompany', $companyinfo); // if (!isset($companyset['code']) || $companyset['code'] != 0) return json_show(1004, $companyset['message']); $userrole['id'] = Db::name("user_role")->insertGetId($roledata); } else { // $userrole['roleid'] = $post['roleid']; // $userrole['nickname'] = $post['nickname']; // $userrole['companyNo'] = $companyNo; // $userrole['company_type'] = $company["type"] == 3 ? 2 : 1; // $userrole['updatetime'] = date("Y-m-d H:i:s"); $up = Db::name("user_role") ->where('id', $userrole['id']) ->update([ "company_type" => $company_type, "nickname" => $userinfo['data']['nickname']??"", "is_main" => $is_main, 'roleid' => $post['roleid'], 'updatetime' => date("Y-m-d H:i:s"), ]); } //设置默认角色 if ($is_main == 1) { Db::name('user_role') ->where(["uid" => $post['id'], "is_del" => 0]) ->where('id', '<>', $userrole['id']) ->update(['is_main' => 0]); } // $saveinfo = [ // "id" => $post['id'], // "nickname" => $post['nickname'], // "mobile" => $post['mobile'], // "token" => $post['token'] // ]; // $saev = resetinfo($saveinfo); // $userCommon = \app\admin\common\User::getIns(); // $saev = $userCommon->handle('usersave', $saveinfo); // if (!isset($saev['code']) || $saev['code'] != 0) { // return json_show(1004, $saev['message']); // } // if ($up == false) { // Db::rollback(); // return json_show(1004, '用户信息更新失败'); // } Db::commit(); return json_show(0, '操作成功'); } catch (\Exception $e) { Db::rollback(); return json_show(1004, '操作失败,' . $e->getMessage()); } } //修改 public function UserSave() { /** * $post = $this->request->post(); * $toke = isset($post['token']) ? trim($post['token']) : ""; * if ($toke == "") { * return app_show(100, "token不能为空"); * } * $verify = VerifyTokens($toke); * if ($verify['code'] != 0) { * return app_show($verify['code'], $verify['message']); * } * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : ""; * if ($userid == "") { * return error_show(1004, "参数id 不能为空"); * } * * $nickname = isset($post['nickname']) ? trim($post['nickname']) : ""; * if ($nickname == "") { * return app_show(1001, "昵称不能为空"); * } * $mobile = isset($post['mobile']) ? trim($post['mobile']) : ""; * if ($mobile == "") { * return app_show(1002, "手机号不能为空"); * } * if (checkMobile($mobile) == false) { * return app_show(1002, "手机号格式不正确"); * } * $email = isset($post['email']) ? trim($post['email']) : ""; * $role = isset($post['role']) ? intval($post['role']) : 0; * if ($role != 0) { * $roleinfo = Db::name("role")->where("id", "=", $role)->find(); * if (empty($roleinfo)) { * return error_show(1002, "角色不存在"); * } * if ($roleinfo['status'] == 0) { * return error_show(1002, "角色已禁用"); * } * } * $itemid = isset($post['itemid']) && $post['itemid'] !== "" ? $post['itemid'] : ""; * $item_arr = []; * if ($itemid !== "") { * foreach ($itemid as $value) { * $item_arr[] = end($value); * } * $iteminfo = Db::name("company_item")->where(["id" => $item_arr, 'is_del' => 0])->select()->toArray(); * if (empty($iteminfo)) { * return error_show(1002, "未找到部门信息"); * } * } * $companyArr = isset($post['companyArr']) && !empty($post['companyArr']) ? $post['companyArr'] : ""; * if ($companyArr == "") { * return error_show(1004, "参数companyArr不能为空"); * } * $compArr = []; * foreach ($companyArr as $value) { * $tmp = []; * if (!isset($value['businessid']) || $value['businessid'] == '') { * return error_show(1004, "参数业务公司businessid不能为空"); * } * $tmp['userid'] = $userid; * $tmp['businessid'] = $value['businessid']; * $tmp['is_main'] = isset($value['is_main']) ? $value['is_main'] : 0; * $tmp['is_del'] = 0; * $tmp['addtime'] = date("Y-m-d H:i:s"); * $tmp['updatetime'] = date("Y-m-d H:i:s"); * $compArr[] = $tmp; * } * $platform = isset($post['platform']) && !empty($post['platform']) ? $post['platform'] : ""; * if ($platform == "") { * return error_show(1004, "参数platform不能为空"); * } * $plta = Db::name("platform")->where(["id" => $platform, "is_del" => 0])->select()->toArray(); * if (empty($plta)) { * return error_show(1004, "未找到可用平台"); * } * $userplat = Db::name("user_platform")->where(["uid" => $userid, "is_del" => 0])->find(); * * $isall = isset($post['is_all']) && $post['is_all'] !== "" ? intval($post['is_all']) : "0"; * * Db::startTrans(); * try { * $sc = Db::name("user_business")->where(["userid" => $userid, "is_del" => 0])->select()->toArray(); * if (!empty($sc)) { * $del = Db::name("user_business")->where(["userid" => $userid, "is_del" => 0])->save(["is_del" => 1, * "updatetime" => date("Y-m-d H:i:s")]); * if ($del == false) { * Db::rollback(); * return error_show(1005, '业务公司添加失败'); * } * } * if (!empty($compArr)) { * $in = Db::name("user_business")->insertAll($compArr); * if ($in == 0) { * Db::rollback(); * return error_show(1005, '业务公司添加失败'); * } * } * * if ($userplat == false) { * $userplat = [ * "uid" => $userid, * "platform" => implode(",", $platform), * "is_del" => 0, * "addtime" => date("Y-m-d H:i:s"), * "updatetime" => date("Y-m-d H:i:s") * ]; * } else { * $userplat['platform'] = implode(",", $platform); * $userplat['updatetime'] = date("Y-m-d H:i:s"); * } * $patup = Db::name("user_platform")->save($userplat); * if ($patup == false) { * Db::rollback(); * return error_show(1005, '业务平台添加失败'); * } * $userrole = Db::name("user_role")->where(["uid" => $userid, "is_del" => 0])->find(); * if (empty($userrole)) { * $roledata = [ * "uid" => $userid, * "roleid" => $role, * "status" => 1, * "business_all" => $isall, * "addtime" => date("Y-m-d H:i:s"), * "updatetime" => date("Y-m-d H:i:s") * ]; * $up = Db::name("user_role")->insert($roledata); * } else { * $userrole['roleid'] = $role; * $userrole['business_all'] = $isall; * $userrole['updatetime'] = date("Y-m-d H:i:s"); * $up = Db::name("user_role")->save($userrole); * } * if ($up) { * Db::name("depart_user")->where(["uid" => $userid])->save(['is_del' => 1]); * if (isset($item_arr) && !empty($item_arr)) { * foreach ($item_arr as $v) { * $depin = [ * "uid" => $userid, * "nickname" => $nickname, * "itemid" => $v, * "is_del" => 0, * "updatetime" => date("Y-m-d H:i:s") * ]; * $ist = Db::name("depart_user")->where(["uid" => $userid, "itemid" => $v])->find(); * if ($ist) { * $up = Db::name("depart_user")->where(["uid" => $userid, "itemid" => $v])->save($depin); * } else { * $depin['addtime'] = date("Y-m-d H:i:s"); * $up = Db::name("depart_user")->insert($depin); * } * if ($up == false) { * Db::rollback(); * return error_show(1005, '用户部门更新失败'); * } * } * } * } else { * Db::rollback(); * return error_show(1005, '角色更新失败'); * } * $data = [ * "id" => $userid, * "nickname" => $nickname, * "mobile" => $mobile, * "email" => $email * ]; * $save = resetinfo($toke, $data); * if (!empty($save) && $save['code'] != 0) { * Db::rollback(); * return error_show($save['code'], $save['message']); * } * Db::commit(); * return app_show(0, "更新成功"); * } catch (\Exception $e) { * Db::rollback(); * return app_show(1002, $e->getMessage()); * } * * **/ $post = $this->request->only(["id", "nickname", "mobile", "email" => "", "portrait" => "", "sex" => ""], "post", 'trim'); $validate = Validate::rule([ 'id|主键ID' => 'require|number|gt:0', 'nickname|名称' => 'require|max:255', 'mobile|手机号' => 'require|mobile', 'email|名称' => 'email', 'sex|性别' => 'number|in:0,1,2', ]); if ($validate->check($post) == false) return json_show(1004, $validate->getError()); $userCommon = CommonUser::getIns(); $rs = json_decode($userCommon->userSave($post), true); return json_show($rs['code'], $rs['message'], $rs['data']); } //修改密码 public function setPwd() { /** * $post = $this->request->post(); * $token = isset($post['token']) ? trim($post['token']) : ""; * if ($token == "") { * return error_show(101, 'token不能为空'); * } * $effetc = VerifyTokens($token); * if (!empty($effetc) && $effetc['code'] != 0) { * return error_show($effetc['code'], $effetc['message']); * } * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : ""; * if ($userid == "") { * return error_show(1004, "参数id 不能为空"); * } * $newPwd = isset($post['password']) ? trim($post['password']) : ""; * if ($newPwd == "") { * return error_show(1001, '密码不能为空'); * } * * $data = resetpwd($token, ["id" => $userid, 'password' => $newPwd]); * if (empty($data) || $data['code'] != 0) { * return error_show($data['code'], $data['message']); * } else { * return app_show(0, "密码修改成功"); * } * **/ $post = $this->request->only(["id", "password"], "post", "trim"); $validate = Validate::rule([ 'id|账户ID' => 'require|number', 'password|密码' => 'require|min:6|max:200', ]); if (!$validate->check($post)) return json_show(1004, $validate->getError()); $userCommon = CommonUser::getIns(); $rs = json_decode($userCommon->resetPasswd($post), true); return json_show($rs['code'], $rs['message'], $rs['data']); } //启禁用 public function userStatus() { /** * $post = $this->request->post(); * $toke = isset($post['token']) ? trim($post['token']) : ""; * if ($toke == "") { * return app_show(100, "token不能为空"); * } * $verify = VerifyTokens($toke); * if ($verify['code'] != 0) { * return app_show($verify['code'], $verify['message']); * } * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : ""; * if ($userid == "") { * return error_show(1004, "参数userid 不能为空"); * } * $status = isset($post['status']) && $post['status'] != "" ? intval($post['status']) : ""; * * if ($status === "") { * return error_show(1004, "参数status 不能为空"); * } * if (!in_array($status, [0, 1])) { * return error_show(1004, "参数status无效"); * } * $message = $status == 1 ? "启用" : "禁用"; * $userinfo = Db::name("user_role")->where(["uid" => $userid, "is_del" => 0])->find(); * if ($userinfo == false) { * $data = [ * "uid" => $userid, * "roleid" => 0, * "status" => $status, * "is_del" => 0, * "addtime" => date("Y-m-d H:i:s"), * "updatetime" => date("Y-m-d H:i:s"), * ]; * $sa = Db::name("user_role")->save($data); * } else { * $userinfo['status'] = $status; * $userinfo['updatetime'] = date("Y-m-d H:i:s"); * $sa = Db::name("user_role")->save($userinfo); * } * if ($sa == false) { * return error_show(1005, "{$message}失败"); * } else { * * return app_show(0, "{$message}成功"); * } * * // $set = resetstatus($toke,["id"=>$userid,"status"=>$status]); * // * // if(empty($set)||$set['code']!=0){ * // return error_show(1005,"{$message}失败"); * // }else{ * // D * // return app_show(0,"{$message}成功"); * // } * **/ $post = $this->request->only(["id", "status"], "post", 'trim'); $validate = Validate::rule([ 'id|主键ID' => 'require|number|gt:0', 'status|状态' => 'require|number|in:0,1', ]); if (!$validate->check($post)) return json_show(1004, $validate->getError()); $userCommon = CommonUser::getIns(); $rs = json_decode($userCommon->resetState($post), true); return json_show($rs['code'], $rs['message'], $rs['data']); } public function getinfo() { $post = $this->request->post(); $token = isset($post['token']) ? trim($post['token']) : ""; if ($token == "") { return app_show(101, 'token不能为空'); } $effetc = VerifyTokens($token); if (!empty($effetc) && $effetc['code'] != 0) { return app_show($effetc['code'], $effetc['message']); } $userinfo = GetUserInfo($token); if (empty($userinfo) || $userinfo['code'] != 0) { return app_show(102, "员工信息不存在"); } $data = $userinfo['data']; $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $data['id']) ->field("roleid,role_name,business_all,uid")->find(); $data['role_name'] = isset($role['role_name']) ? $role['role_name'] : ""; $data['roleid'] = isset($role['roleid']) ? $role['roleid'] : ""; $st = Db::name('user_business')->where(['userid' => $role['uid'], "is_del" => 0])->field('businessid,is_main')->select()->toArray(); $val = []; if (!empty($st)) { foreach ($st as $itom) { $tep = []; // $business = Db::name('business')->where(['id' => $itom['businessid'], "is_del" => 0])->field("company,companyNo")->find(); //这个地方是根据业务企业id来匹配的,无法去sys_user查找 $tep['company'] = '';//isset($business['company']) ? $business['company'] : ""; $tep['companyNo'] = '';//isset($business['companyNo']) ? $business['companyNo'] : ""; $tep['businessid'] = $itom['businessid']; $tep['is_main'] = $itom['is_main']; $val[] = $tep; } } $data['private_field'] = []; if ($data['roleid'] != "") { $action = Db::name("role_action")->where(["role_id" => $data['roleid'], "status" => 1])->find(); if ($action != false) { $data['private_field'] = isset($action['private_field']) && $action['private_field'] != "" ? explode(",", $action['private_field']) : []; } } $data['business'] = $val; $info = []; $stn = Db::name('user_platform')->where(['uid' => $role['uid']])->find(); if ($stn != false) { $plat = isset($stn['platform']) ? explode(",", $stn['platform']) : ""; if ($plat != "") { $platform = Db::name('platform')->where(['id' => $plat, 'is_del' => 0])->column("id,platform_name,platform_code"); $info = $platform; } } $depart = Db::name("depart_user")->where([["uid", "=", $data['id']], ["is_del", "=", 0]])->column("itemid"); $data['depart'] = ""; if (!empty($depart)) { $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")->select()->toArray(); if (!empty($deparname)) { foreach ($deparname as $ky => $item) { $deparname[$ky]['depart_code'] = array_filter(explode("-", $item['depart_link'])); } } $data['depart'] = $deparname; } $data['platform'] = $info; return app_show(0, "获取成功", $data); } //超管账号列表 public function userSingleList() { $post = $this->request->only(["token" => "", "nickname" => "", "relaComNo" => "", "username" => "", "companyNo" => "", "status" => "", "page" => 1, "size" => 10], "post"); if ($this->level == 1) { $companyNo = $post['companyNo'] ?? ""; } else { $companyNo = $post['relaComNo'] ?? ""; $post['companyNo'] = $post['relaComNo'] ?? ""; } $where = [["a.is_del", "=", 0]]; unset($post['relaComNo']); if ($post['companyNo'] != "") { $where[] = ["a.companyNo", "=", $companyNo]; } // if ($post["islevel"] != "") { // $uid = Db::name("user_role")->alias("a") // ->leftJoin("role b", "a.roleid=b.id")->where([["b.level", "=", 1], ["a.is_del", "=", 0]])->where($where)->column // ("uid"); // if ($post['islevel'] == 1) $post['uid'] = $uid; // else $post['nuid'] = $uid; // // unset($post["islevel"]); // } $userCommon = \app\admin\common\User::getIns(); $userinfo = $userCommon->GetAccountall($post); $userinfo = json_decode($userinfo, true); if (empty($userinfo) || $userinfo['code'] != 0) return app_show($userinfo['code'], $userinfo['msg']); $data = $userinfo['data']['list']; $list = []; foreach ($data as $value) { if (isset($value['company_relaton']) && !empty($value['company_relaton'])) { foreach ($value['company_relaton'] as &$item) { $roleArr = Db::name("user_role") ->alias("a") ->leftJoin("role b", "a.roleid=b.id") ->where(["uid" => $value['id'], "a.companyNo" => $item['companyCode'], "is_del" => 0]) ->field("role_name,roleid,a.status") ->findOrEmpty(); $item['roleid'] = $roleArr['roleid'] ?? ""; $item['status'] = $roleArr['status'] ?? 0; $item["role_name"] = $roleArr['role_name'] ?? ""; $item["role_level"] = $value['level']; } } $value['roleid'] = $roleArr['roleid'] ?? ""; $value['status'] = $value['status'] ?? 0; $value["role_name"] = $roleArr['role_name'] ?? ""; $value["role_level"] = $value['level'] ?? ""; $list[] = $value; } return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]); } //修改密码 public function passSetByPassword() { $param = $this->request->only(['old_pass', 'new_pass'], 'post', 'trim'); $param['uid'] = $this->uid; $userCommon = \app\admin\common\User::getIns(); $rs = $userCommon->handle('passSetByPassword', $param); return json_show($rs['code'], $rs['message'], $rs['data']); } }