User.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393
  1. <?php
  2. declare (strict_types = 1);
  3. namespace app\admin\controller;
  4. use app\admin\BaseController;use think\App;use think\facade\Db;use think\facade\Validate;
  5. class User extends BaseController{
  6. public function __construct(App $app) {parent::__construct($app);}
  7. /**
  8. * 设置供应商信息
  9. * @return \think\response\Json|void
  10. */
  11. public function EditUserCompany(){
  12. $post = $this->request->only(["token"=>"","nickname"=>"","id"=>"","mobile"=>"","companyArr"=>[]],"post");
  13. $valide = $validate=Validate::rule([
  14. 'nickname|真实姓名' => 'require|max:255',
  15. 'id|账户ID' => 'require|number|gt:0',
  16. 'mobile|手机号' => 'require|number|mobile',
  17. 'companyArr|业务公司' => 'require|array',
  18. ]);
  19. if($valide->check($post)==false) return json_show(1004,$valide->getError());
  20. $isSuper = Db::name("user_role")->alias("a")
  21. ->leftJoin("role b","a.roleid=b.id")
  22. ->where(["a.uid"=>$post['id'],"a.is_del"=>0,"b.level"=>1])
  23. ->findOrEmpty();
  24. if(!empty($isSuper) && !empty($post['companyArr']))return error_show(1002,"超管账户不允许设置关联业务公司");
  25. $saveinfo =[
  26. "id"=>$post['id'],
  27. "nickname"=>$post['nickname'],
  28. "mobile"=>$post['mobile'],
  29. "token"=>$post['token']
  30. ];
  31. $saev= resetinfo($saveinfo);
  32. if(!isset($saev['code'])||$saev['code']!=0){
  33. return error_show(1004,$saev['message']);
  34. }
  35. if(!empty($post['companyArr'])){
  36. $companyinfo = ["id"=>$post['id'],"company"=>$post['companyArr'],"token"=>$post['token']];
  37. $companyset =setUserCompany($companyinfo);
  38. if(!isset($companyset['code'])||$companyset['code']!=0){
  39. return error_show(1004,$companyset['message']);
  40. }
  41. }
  42. return app_show(0,"设置成功");
  43. }
  44. /**
  45. * 用户列表
  46. */
  47. public function userList(){
  48. $post=$this->request->only(["token"=>"","nickname"=>"","relaComNo"=>"","islevel"=>"","username"=>"","companyNo"=>"","status"=>"","page"=>1,"size"=>10],"post");
  49. $post['companyNo']==""? ($post['companyNo']=$post['relaComNo']??""):"";
  50. $where=[["a.is_del","=",0]];
  51. unset($post['relaComNo']);
  52. if($post['companyNo']!=""){
  53. $where[]=["a.companyNo","=",$post['companyNo']];
  54. }
  55. if($post['status']!==''){
  56. $uid =Db::name("user_role")->alias("a")->where(["status"=>1,"is_del"=>0])->where($where)->column("uid");
  57. if($post['status']==1){
  58. $where[]=["a.status","=",1];
  59. $post['uid']= $uid;
  60. }else{
  61. $post['nouid']=$uid;
  62. }
  63. unset($post['status']);
  64. }
  65. if($post["islevel"]!=""){
  66. $where[]=["b.level","=",1];
  67. $uid =Db::name("user_role")->alias("a")
  68. ->leftJoin("role b","a.roleid=b.id")->where($where)->column("uid");
  69. if($post['islevel']==1){
  70. $post['uid']= $uid;
  71. }else{
  72. $post['nouid']=$uid;
  73. }
  74. unset($post["islevel"]);
  75. }
  76. $userinfo=GetUserList($post);
  77. if(empty($userinfo)||$userinfo['code']!=0){
  78. return app_show($userinfo['code'],$userinfo['msg']);
  79. }
  80. $data = $userinfo['data']['list'];
  81. $roleArr = Db::name("user_role")->alias("a")
  82. ->leftJoin("role b","a.roleid=b.id")
  83. ->where($where)
  84. ->column("role_name,roleid,a.status,b.level","a.companyNo");
  85. $list=[];
  86. foreach ($data as $value){
  87. $value['roleid']=$roleArr[$value['companyCode']]['roleid']??"";
  88. $value['com_status']=$roleArr[$value['companyCode']]['status']??"";
  89. $value["role_name"] =$roleArr[$value['companyCode']]['role_name']??"";
  90. $value["role_level"] =$roleArr[$value['companyCode']]['level']??"";
  91. $list[]=$value;
  92. }
  93. return app_show(0,"获取成功",["list"=>$list,"count"=>$userinfo['data']["count"]]);
  94. }
  95. /**获取当前访问用户的信息
  96. * @param token
  97. * @return \think\response\Json
  98. * @throws \think\exception\DbException
  99. */
  100. public function userInfo(){
  101. $post =$this->request->only(["token"=>"","relaComNo"=>""],"post","trim");
  102. $userinfo=GetUserInfo($post['token']);
  103. if(empty($userinfo)||$userinfo['code']!=0){
  104. return app_show(1002,"员工信息不存在");
  105. }
  106. $data = $userinfo['data'];
  107. $where=[["uid","=", $data['id']],["status","=",1],["is_del","=",0]];
  108. if($post['relaComNo']!=""){
  109. $where[]=["companyNo","=",$post['relaComNo']];
  110. }else{
  111. $where[]=["is_main","=",1];
  112. }
  113. $role =Db::name("user_role")->where($where)->findOrEmpty();
  114. if(!empty($role)){
  115. $company_name = Db::name("supplier_info")->where(["code"=>$role['companyNo']])->value("name","");
  116. $roleinfo = Db::name("role")->where(["id"=>$role['roleid']])->field("role_name,level")->find();
  117. }else{
  118. return error_show(1004,'未开通登录权限');
  119. }
  120. if(!empty($data['company_relaton'])){
  121. $roleArr = Db::name("user_role")->alias("a")
  122. ->leftJoin("role b","a.roleid=b.id")
  123. ->where(["a.status"=>1,"a.is_del"=>0,"a.uid"=>$data['id']])
  124. ->column("role_name,roleid,a.status,b.level","a.companyNo");
  125. foreach ($data['company_relaton'] as &$item){
  126. $item['roleid'] =isset($roleArr[$item['companyCode']])?$roleArr[$item['companyCode']]['roleid']:"";
  127. $item['role_name'] =isset($roleArr[$item['companyCode']])?$roleArr[$item['companyCode']]['role_name']:"";
  128. $item['role_status'] =isset($roleArr[$item['companyCode']])?$roleArr[$item['companyCode']]['status']:"";
  129. $item['role_level'] =isset($roleArr[$item['companyCode']])?$roleArr[$item['companyCode']]['level']:"";
  130. }
  131. }
  132. $data['role_name']=$roleinfo['role_name']??'';
  133. $data['company_name']=$company_name??'';
  134. $data['role_level']=$roleinfo['level']??'';
  135. $data['role_id']=$role['roleid']??'';
  136. $data['companyNo']=$role['companyNo']??'';
  137. $data['company_type']=$role['company_type']??'';
  138. return app_show(0,"获取成功",$data);
  139. }
  140. /**
  141. * @return \think\response\Json|void
  142. * @throws \think\db\exception\DataNotFoundException
  143. * @throws \think\db\exception\DbException
  144. * @throws \think\db\exception\ModelNotFoundException
  145. */
  146. public function setStatus(){
  147. $post =$this->request->only(["id"=>"","status"=>"","relaComNo"=>"","token"=>""],"post");
  148. $valide =Validate::rule([
  149. 'id|账户ID' => 'require|number|gt:0',
  150. 'status|状态' => 'require|number|in:0,1',
  151. 'relaComNo|业务公司' => 'require|max:255',
  152. ]);
  153. if($valide->check($post)==false) return error_show(1004,$valide->getError());
  154. $message = $post['status']==1?"启用":"禁用";
  155. $userinfo =Db::name("user_role")->where(["uid"=>$post['id'],"companyNo"=>$post['relaComNo'],"is_del"=>0])
  156. ->find();
  157. if($userinfo==false){
  158. return error_show(1005,"未找到有关账户信息");
  159. }else{
  160. $userinfo['status']=$post['status'];
  161. $userinfo['updatetime']=date("Y-m-d H:i:s");
  162. $sa=Db::name("user_role")->save($userinfo);
  163. }
  164. if($sa==false){
  165. return error_show(1005,"{$message}失败");
  166. }else{
  167. return app_show(0,"{$message}成功");
  168. }
  169. }
  170. //获取所有用户的信息
  171. public function userAll(){
  172. $post=$this->request->only(['relaComNo'=>"","companyNo"=>"","nickname"=>"","roleid"=>"","status"=>""],"post","trim");
  173. $condition = [["is_del","=",0]];
  174. $rolecond=" level in (1,2,3)";
  175. if($post['relaComNo']!=""){
  176. $condition[]=["companyNo","=",$post['relaComNo']];
  177. $rolecond = "level=1 or (level in (2,3) and companyNo ='{$post['relaComNo']}' )";
  178. }
  179. if($post['companyNo']!=""){
  180. $condition[]=["companyNo","=",$post['companyNo']];
  181. $rolecond = "level=1 or (level in (2,3) and companyNo ='{$post['companyNo']}' )";
  182. }
  183. if($post['roleid']!=""){
  184. $condition[]=["roleid","=",$post['roleid']];
  185. $rolecond = "id={$post['roleid']}";
  186. }
  187. if($post['status']!="")$condition[]=["status","=",$post['status']];
  188. if($post['nickname']!="")$condition[]=["nickname","like","%{$post['nickname']}%"];
  189. $list=Db::name("user_role")->where($condition)->select()->toArray();
  190. $role = Db::name("role")->whereRaw($rolecond)->column("role_name,level","id");
  191. foreach ($list as &$value){
  192. $value['role_name']= $role[$value['roleid']]['role_name']??"";
  193. $value['role_level']= $role[$value['roleid']]['level']??"";
  194. $value['companyName']= Db::name("supplier_info")->where(["code"=>$value['companyNo']])->value("name",'');
  195. }
  196. return app_show(0,"获取成功",$list);
  197. }
  198. /**
  199. * 修改用户基础信息
  200. */
  201. public function setRole(){
  202. $post=$this->request->only(["id"=>"","nickname"=>"","relaComNo"=>"","company_type"=>"","roleid"=>""],"post","trim");
  203. $valide=Validate::rule([
  204. "id|账户ID"=>"require|number|gt:0",
  205. "nickname|名称"=>"require|max:255",
  206. "relaComNo|业务公司"=>"require|max:255",
  207. "company_type|业务公司类型"=>"require|number|in:1,2",
  208. "roleid|角色ID"=>"require|number",
  209. ]);
  210. if($valide->check($post)==false) return error_show(1004,$valide->getError());
  211. if($post['roleid']!=0){
  212. $roleinfo =Db::name("role")->where("id","=",$post['roleid'])->find();
  213. if(empty($roleinfo)){
  214. return error_show(1002,"角色不存在");
  215. }
  216. if($roleinfo['status']==0){
  217. return error_show(1002,"角色已禁用");
  218. }
  219. }
  220. $isSuper = Db::name("user_role")->alias("a")
  221. ->leftJoin("role b","a.roleid=b.id")
  222. ->where(["a.uid"=>$post['id'],"a.is_del"=>0,"b.level"=>1])
  223. ->findOrEmpty();
  224. if(!empty($isSuper))return error_show(1002,"超管账户不允许设置其他角色");
  225. $userrole = Db::name("user_role")
  226. ->where(["uid"=>$post['id'],"companyNo"=>$post['relaComNo'],"is_del"=>0])
  227. ->find();
  228. Db::startTrans();
  229. try{
  230. if(empty($userrole)){
  231. $roledata =[
  232. "uid"=>$post['id'],
  233. "roleid"=>$post['roleid'],
  234. "nickname"=>$post['nickname'],
  235. "companyNo"=>$post['relaComNo'],
  236. "company_type"=>$post['company_type'],
  237. "status"=>1,
  238. "addtime"=>date("Y-m-d H:i:s"),
  239. "updatetime"=>date("Y-m-d H:i:s")
  240. ];
  241. $up= Db::name("user_role")->insert($roledata);
  242. }else{
  243. $userrole['roleid'] = $post['roleid'];
  244. $userrole['companyNo'] = $post['relaComNo'];
  245. $userrole['company_type'] =$post['company_type'];
  246. $userrole['updatetime'] = date("Y-m-d H:i:s");
  247. $up=Db::name("user_role")->save($userrole);
  248. }
  249. if($up==false){
  250. Db::rollback();
  251. return error_show(1004,'用户信息更新失败');
  252. }
  253. Db::commit();
  254. return app_show(0,'用户信息更新成功');
  255. }catch (\Exception $e){
  256. Db::rollback();
  257. return error_show(1004,$e->getMessage());
  258. }
  259. }
  260. /**获取用户关联业务公司
  261. * @return \think\response\Json|void
  262. * @throws \think\db\exception\DataNotFoundException
  263. * @throws \think\db\exception\DbException
  264. * @throws \think\db\exception\ModelNotFoundException
  265. */
  266. public function GetCompany(){
  267. $post=$this->request->only(["token"=>"","uid"=>"","companyName"=>"","page"=>1,"size"=>20],"post","trim");
  268. $where=[];
  269. if($post['uid']!=""){
  270. $where[]=["a.uid","=",$post['uid']];
  271. }else{
  272. $where[]=["a.uid","=",$this->uid];
  273. }
  274. if($post['companyName']!=""){
  275. $where[]=["b.name","like","%{$post['companyName']}%"];
  276. }
  277. $count = Db::name("user_role")->alias("a")
  278. ->leftJoin("supplier_info b","a.companyNo=b.code")
  279. ->where($where)
  280. ->count();
  281. $total =ceil($count/$post['size']);
  282. $page = $post['page']>$total ? intval($total):intval($post['page']);
  283. $list = Db::name("user_role")->alias("a")
  284. ->leftJoin("supplier_info b","a.companyNo=b.code")
  285. ->where($where)
  286. ->field("a.uid,a.nickname,roleid,companyNo,b.name as companyName,a.status,a.company_type")
  287. ->page($page,intval($post['size']))
  288. ->select()->toArray();
  289. foreach ($list as &$value){
  290. $value['role_name'] = Db::name("role")->where(["id"=>$value["roleid"]])->value("role_name","");
  291. }
  292. return app_show(0,'获取成功',["list"=>$list,"count"=>$count]);
  293. }
  294. //密码设置
  295. public function setPwd(){
  296. $post=$this->request->only(["id"=>"","password"=>""],"post","trim");
  297. $validate=Validate::rule([
  298. 'id|账户ID' => 'require|number',
  299. 'password|密码' => 'require|min:6|max:200',
  300. ]);
  301. if($validate->check($post)==false) return error_show(1004,$validate->getError());
  302. $data = resetpwd($post);
  303. if(empty($data)||$data['code']!=0){
  304. return error_show($data['code'],$data['message']);
  305. }else{
  306. return app_show(0,"密码修改成功");
  307. }
  308. }
  309. public function usersave(){
  310. $post=$this->request->only(["id"=>"","nickname"=>"","mobile"=>"","email"=>"","relaComNo"=>"","companyArr"=>[],"token"=>""],"post","trim");
  311. $validate=Validate::rule([
  312. 'id|账户ID' => 'number',
  313. 'nickname|真实姓名' => 'require|min:6|max:200',
  314. 'mobile|手机号' => 'require|number|length:11|mobile',
  315. 'email|邮箱' => 'email',
  316. 'companyArr|关联账户' => 'array',
  317. ]);
  318. if($validate->check($post)==false) return error_show(1004,$validate->getError());
  319. if($post['id']!=""){
  320. $isSuper = Db::name("user_role")->alias("a")
  321. ->leftJoin("role b","a.roleid=b.id")
  322. ->where(["a.uid"=>$post['id'],"a.is_del"=>0,"b.level"=>1])
  323. ->findOrEmpty();
  324. if(!empty($isSuper) && !empty($post['companyArr']))return error_show(1002,"超管账户不允许设置关联业务公司");
  325. $saveinfo =[
  326. "id"=>$post['id'],
  327. "nickname"=>$post['nickname'],
  328. "mobile"=>$post['mobile'],
  329. "token"=>$post['token']
  330. ];
  331. $saev= resetinfo($saveinfo);
  332. if(!isset($saev['code'])||$saev['code']!=0){
  333. return error_show(1004,$saev['message']);
  334. }
  335. // if($post['relaComNo']!=""){
  336. // $company =Db::name("supplier_info")->where(["code"=>$post['relaComNo']])->find();
  337. // if($company){
  338. // $temp = [
  339. // "companyCode"=>$company["code"],
  340. // "companyName"=>$company["name"],
  341. // "company_type"=>$company["type"]==3?2:1,
  342. // "is_main"=>1,
  343. // ];
  344. // $post['companyArr'][]=$temp;
  345. // }
  346. // }
  347. if(!empty($post['companyArr'])){
  348. $companyinfo = ["id"=>$post['id'],"company"=>$post['companyArr'],"token"=>$post['token']];
  349. $companyset =setUserCompany($companyinfo);
  350. if(!isset($companyset['code'])||$companyset['code']!=0){
  351. return error_show(1004,$companyset['message']);
  352. }
  353. }
  354. }else{
  355. if($post['relaComNo']!=""){
  356. $company =Db::name("supplier_info")->where(["code"=>$post['relaComNo']])->find();
  357. if($company){
  358. $temp = [
  359. "companyCode"=>$company["code"],
  360. "companyName"=>$company["name"],
  361. "company_type"=>$company["type"]==3?2:1,
  362. "is_main"=>1,
  363. ];
  364. $post['companyArr'][]=$temp;
  365. }
  366. }
  367. $nam = addacount($post);
  368. if(!isset($nam['code'])||$nam['code']!=0){
  369. return error_show(1004,$nam['message']);
  370. }
  371. }
  372. return $post['id']==""?app_show(0,"账户新建成功"):app_show(0,"账户新建失败");
  373. }
  374. }