User.php 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919
  1. <?php
  2. declare (strict_types=1);
  3. namespace app\admin\controller;
  4. use think\facade\Db;
  5. use app\admin\model\ActionLog;
  6. use think\facade\Validate;
  7. use app\admin\common\User as CommonUser;
  8. //运营账户
  9. class User extends Base
  10. {
  11. //登录
  12. public function login()
  13. {
  14. $param = $this->request->only(['username', 'password'], 'post', 'trim');
  15. $val = Validate::rule([
  16. 'username|用户名' => 'require',
  17. 'password|密码' => 'require',
  18. ]);
  19. if (!$val->check($param)) return json_show(1004, $val->getError());
  20. $user = new CommonUser();
  21. $rs = $user->login(array_merge($param, ['plat_code' => 'cx']));
  22. $rs = json_decode($rs, true);
  23. if(!isset($rs['code'])|| $rs['code']!=0) return json_show(1004,$rs['message']);
  24. $role =Db::name('user_role')
  25. ->where(['uid'=>$rs['data']['id'],'is_main'=>1,'is_del'=>0])
  26. ->findOrEmpty();
  27. if(empty($role)) return json_show(1004,'未开通登录权限');
  28. $company_name = Db::name('supplier')
  29. ->where(['code' => $role['companyNo']])
  30. ->value('name', '');
  31. $roleinfo = Db::name('role')
  32. ->where(['id' => $role['roleid']])
  33. ->field('role_name,level')
  34. ->find();
  35. //数据合并
  36. $data = array_merge($rs['data'], [
  37. 'role_name' => $roleinfo['role_name'] ?? '',
  38. 'company_name' => $company_name ?? '',
  39. 'role_level' => $roleinfo['level'] ?? '',
  40. 'role_id' => $role['roleid'] ?? '',
  41. 'companyNo' => $role['companyNo'] ?? '',
  42. 'company_type' => $role['company_type'] ?? '',
  43. ]);
  44. return json_show(0,'登录成功',$data);
  45. }
  46. public function list(){
  47. $param = $this->request->only(['nickname' => '', 'username' => '', 'status' => '', 'page' => 1, 'size' => 10, 'uid' => '', 'nuid' => '','companyNo'=>''], 'post', 'trim');
  48. $userCommon = new CommonUser();
  49. $rs = $userCommon->GetUserlist($param);
  50. $rs = json_decode($rs, true);
  51. return json_show($rs['code'], $rs['message'], $rs['data']);
  52. }
  53. //删除
  54. public function delete()
  55. {
  56. $param = $this->request->only(['ids'], 'post', 'trim');
  57. $val = Validate::rule([
  58. 'ids' => 'require|array|max:100',
  59. ]);
  60. if (!$val->check($param)) return json_show(1004, $val->getError());
  61. if (in_array($this->uid, $param['ids'])) return json_show(1004, '自己不能删除自己');
  62. $userCommon = new CommonUser();
  63. $rs = $userCommon->userDelete($param);
  64. $rs = json_decode($rs, true);
  65. return json_show($rs['code'], $rs['message'], $rs['data']);
  66. }
  67. //详情
  68. public function userInfo()
  69. {
  70. /**
  71. * $post = $this->request->post();
  72. * $token = isset($post['token']) ? trim($post['token']) : "";
  73. * if ($token == "") {
  74. * return app_show(101, 'token不能为空');
  75. * }
  76. * $effetc = VerifyTokens($token);
  77. * if (!empty($effetc) && $effetc['code'] != 0) {
  78. * return app_show($effetc['code'], $effetc['message']);
  79. * }
  80. * $userinfo = GetUserInfo($token);
  81. * if (empty($userinfo) || $userinfo['code'] != 0) {
  82. * return app_show(102, "员工信息不存在");
  83. * }
  84. * $id = isset($post['id']) && $post['id'] !== "" ? trim($post['id']) : "";
  85. * if ($id == "") {
  86. * return error_show(1004, "id不能为空");
  87. * }
  88. * $to = GetInfoById($token, ['id' => $id]);
  89. * if (empty($to) || $to['code'] != 0) {
  90. * return app_show(1002, "员工信息不存在");
  91. * }
  92. * // $nickname = isset($to['data']['nickname']) &&$to['data']['nickname']!="" ? $to['data']['nickname'] :"" ;
  93. * $data = $to['data'];
  94. * $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $data['id'])
  95. * ->field("roleid,role_name,business_all,uid,a.status")->find();
  96. * $data['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
  97. * $data['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
  98. * $data['status'] = isset($role['status']) ? $role['status'] : '0';
  99. * $st = Db::name('user_business')->where(['userid' => $role['uid'], "is_del" => 0])->field('businessid,is_main')->select()->toArray();
  100. * $val = [];
  101. * if (!empty($st)) {
  102. * foreach ($st as $itom) {
  103. * $tep = [];
  104. * $business = Db::name('business')->where(['id' => $itom['businessid'], "is_del" => 0])->field("company,companyNo")->find();
  105. * $tep['company'] = isset($business['company']) ? $business['company'] : "";
  106. * $tep['companyNo'] = isset($business['companyNo']) ? $business['companyNo'] : "";
  107. * $tep['businessid'] = $itom['businessid'];
  108. * $tep['is_main'] = $itom['is_main'];
  109. * $val[] = $tep;
  110. * }
  111. * }
  112. * $data['business'] = $val;
  113. * $info = [];
  114. * $stn = Db::name('user_platform')->where(['uid' => $role['uid']])->find();
  115. * if ($stn != false) {
  116. * $plat = isset($stn['platform']) ? explode(",", $stn['platform']) : "";
  117. * if ($plat != "") {
  118. * $platform = Db::name('platform')->where(['id' => $plat, 'is_del' => 0])->column("id,platform_name,platform_code");
  119. * $info = $platform;
  120. * }
  121. *
  122. * }
  123. * $depart = Db::name("depart_user")->where([["uid", "=", $data['id']], ["is_del", "=", 0]])->column("itemid");
  124. * $data['depart'] = "";
  125. *
  126. * if (!empty($depart)) {
  127. * $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")->select()->toArray();
  128. * if (!empty($deparname)) {
  129. * foreach ($deparname as $ky => $item) {
  130. * $deparname[$ky]['depart_code'] = array_filter(explode("-", $item['depart_link']));
  131. * }
  132. * }
  133. * $data['depart'] = $deparname;
  134. * }
  135. * $data['platform'] = $info;
  136. *
  137. * return app_show(0, "获取成功", $data);
  138. * **/
  139. // $id = $this->request->post('id/d', 0, "trim");
  140. $userCommon = new CommonUser();
  141. $rs = json_decode($userCommon->GetUserInfo(['id' => $this->uid]), true);
  142. $rs['data']['level'] = $this->level;
  143. return json_show($rs['code'], $rs['message'], $rs['data']);
  144. }
  145. /**
  146. * @param token
  147. * @param passwd
  148. * @return \think\response\Json
  149. * @throws \think\exception\DbException
  150. */
  151. public function resetPwd()
  152. {
  153. $post = $this->request->post();
  154. $token = isset($post['token']) ? trim($post['token']) : "";
  155. if ($token == "") {
  156. return error_show(101, 'token不能为空');
  157. }
  158. $effetc = VerifyTokens($token);
  159. if (!empty($effetc) && $effetc['code'] != 0) {
  160. return error_show($effetc['code'], $effetc['message']);
  161. }
  162. $newPwd = isset($post['newpwd']) ? trim($post['newpwd']) : "";
  163. if ($newPwd == "") {
  164. return error_show(1001, '新密码不能为空');
  165. }
  166. $oldpwd = isset($post['oldpwd']) ? trim($post['oldpwd']) : "";
  167. if ($oldpwd == "") {
  168. return error_show(1002, "原密码不能为空");
  169. }
  170. $data = resetpasswd($token, ['newpwd' => $newPwd, 'oldpwd' => $oldpwd]);
  171. if (empty($userinfo) || $userinfo['code'] != 0) {
  172. return error_show($userinfo['code'], $userinfo['message']);
  173. } else {
  174. return app_show(0, "密码修改成功");
  175. }
  176. }
  177. public function userAll()
  178. {
  179. $post = $this->request->post();
  180. $token = isset($post['token']) ? trim($post['token']) : "";
  181. if ($token == "") {
  182. return app_show(101, 'token不能为空');
  183. }
  184. $effetc = VerifyTokens($token);
  185. if (!empty($effetc) && $effetc['code'] != 0) {
  186. return app_show($effetc['code'], $effetc['message']);
  187. }
  188. if (isset($post['status']) && $post['status'] !== '') {
  189. $uid = Db::name("user_role")->where(["status" => 1, "is_del" => 0])->column("uid");
  190. if ($post['status'] == 1) {
  191. $post['uid'] = $uid;
  192. } else {
  193. $post['nouid'] = $uid;
  194. }
  195. unset($post['status']);
  196. }
  197. $userinfo = GetAccountall($token, $post);
  198. if (empty($userinfo) || $userinfo['code'] != 0) {
  199. return app_show(1002, "员工信息不存在");
  200. }
  201. $data = $userinfo['data'];
  202. $list = [];
  203. foreach ($data as $value) {
  204. $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $value['id'])
  205. ->field("roleid,role_name,a.status")->find();
  206. $value['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
  207. $value['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
  208. $depart = Db::name("depart_user")->where([["uid", "=", $value['id']], ["is_del", "=", 0]])->column("itemid");
  209. $value['depart'] = "";
  210. $value['status'] = isset($role['status']) ? $role['status'] : '0';
  211. if (!empty($depart)) {
  212. $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")
  213. ->select()->toArray();
  214. array_walk($deparname, function (&$v) {
  215. $v = array_filter(explode("-", $v['depart_link']));
  216. });
  217. $value['depart'] = $deparname;
  218. }
  219. $list[] = $value;
  220. }
  221. return app_show(0, "获取成功", $list);
  222. }
  223. /**
  224. * @return \think\response\Json|void
  225. * @throws \think\db\exception\DataNotFoundException
  226. * @throws \think\db\exception\DbException
  227. * @throws \think\db\exception\ModelNotFoundException
  228. * @throws \think\exception\DbException
  229. */
  230. public function userList()
  231. {
  232. $post = $this->request->post();
  233. $token = isset($post['token']) ? trim($post['token']) : "";
  234. if ($token == "") {
  235. return app_show(101, 'token不能为空');
  236. }
  237. $effetc = VerifyTokens($token);
  238. if (!empty($effetc) && $effetc['code'] != 0) {
  239. return app_show($effetc['code'], $effetc['message']);
  240. }
  241. $itemid = isset($post['itemid']) && $post['itemid'] !== "" ? intval($post['itemid']) : "";
  242. if ($itemid !== "") {
  243. $uids = Db::name("depart_user")->where([["itemid", "=", $itemid], ["is_del", "=", 0]])->column("uid");
  244. $post['uid'] = $uids;
  245. }
  246. if (isset($post['status']) && $post['status'] !== '') {
  247. $uid = Db::name("user_role")->where(["status" => 1, "is_del" => 0])->column("uid");
  248. if ($post['status'] == 1) {
  249. $post['uid'] = isset($uids) ? array_unique(array_merge($uids, $uid)) : $uid;
  250. } else {
  251. $post['nouid'] = $uid;
  252. }
  253. unset($post['status']);
  254. }
  255. $userinfo = GetList($token, $post);
  256. if (empty($userinfo) || $userinfo['code'] != 0) {
  257. return app_show($userinfo['code'], $userinfo['msg']);
  258. }
  259. $data = $userinfo['data']['list'];
  260. $list = [];
  261. foreach ($data as $value) {
  262. $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $value['id'])
  263. ->field("roleid,role_name,a.status")->find();
  264. $value['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
  265. $value['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
  266. $depart = Db::name("depart_user")->where([["uid", "=", $data['uid']], ["is_del", "=", 0]])->column("itemid");
  267. $value['depart'] = "";
  268. $value['status'] = isset($role['status']) ? $role['status'] : '0';
  269. if (!empty($depart)) {
  270. $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")
  271. ->select()->toArray();
  272. $value['depart'] = $deparname;
  273. $value['depart_code'] = [];
  274. if (!empty($deparname)) {
  275. foreach ($deparname as $item) {
  276. $value['depart_code'][] = array_filter(explode("-", $item['depart_link']));
  277. }
  278. }
  279. }
  280. $list[] = $value;
  281. }
  282. return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]);
  283. }
  284. //账户角色列表
  285. public function userRoleList()
  286. {
  287. $post = $this->request->only(["token" => "", "nickname" => "", "relaComNo" => "", "islevel" => "", "username" => "", "companyNo" => "", "status" => "", "page" => 1, "size" => 10], "post");
  288. if ($this->level == 1) {
  289. $companyNo = $post['companyNo'] ?? "";
  290. } else {
  291. $companyNo = $post['relaComNo'] ?? "";
  292. $post['companyNo'] = $post['relaComNo'] ?? "";
  293. }
  294. $where = [["a.is_del", "=", 0]];
  295. unset($post['relaComNo']);
  296. if ($post['companyNo'] != "") {
  297. $where[] = ["a.companyNo", "=", $companyNo];
  298. }
  299. if ($post['status'] !== '') {
  300. $uid = Db::name("user_role")->alias("a")->where(["status" => 1, "is_del" => 0])->where($where)->column("uid");
  301. if ($post['status'] == 1) {
  302. $where[] = ["a.status", "=", 1];
  303. $post['uid'] = $uid;
  304. } else {
  305. $post['nuid'] = $uid;
  306. }
  307. unset($post['status']);
  308. }
  309. if ($post["islevel"] != "") {
  310. $uid = Db::name("user_role")->alias("a")
  311. ->leftJoin("role b", "a.roleid=b.id")->where([["b.level", "=", 1], ["a.is_del", "=", 0]])->where($where)->column
  312. ("uid");
  313. if ($post['islevel'] == 1) {
  314. $post['uid'] = $uid;
  315. } else {
  316. $post['nuid'] = $uid;
  317. }
  318. unset($post["islevel"]);
  319. }
  320. // var_dump($post);
  321. // $userinfo=GetUserList($post);
  322. $userCommon = new CommonUser();
  323. $userinfo = $userCommon->GetList($post);
  324. $userinfo = json_decode($userinfo, true);
  325. if (empty($userinfo) || $userinfo['code'] != 0) {
  326. return app_show($userinfo['code'], $userinfo['msg']);
  327. }
  328. $data = $userinfo['data']['list'];
  329. $list = [];
  330. foreach ($data as $value) {
  331. $roleArr = Db::name("user_role")->alias("a")
  332. ->leftJoin("role b", "a.roleid=b.id")
  333. ->where(["uid" => $value['id'], "a.companyNo" => $value['companyCode'], "is_del" => 0])
  334. ->field("role_name,roleid,a.status,b.level")->findOrEmpty();
  335. $value['roleid'] = $roleArr['roleid'] ?? "";
  336. $value['status'] = $value['status'] == 1 ? ($roleArr['status'] ?? 0) : 0;
  337. $value["role_name"] = $roleArr['role_name'] ?? "";
  338. $value["role_level"] = $roleArr['level'] ?? "";
  339. $list[] = $value;
  340. }
  341. return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]);
  342. }
  343. //账号角色修改
  344. public function setRole()
  345. {
  346. $post = $this->request->only(["id" => "", "nickname" => "", "mobile" => "", "relaComNo" => "", "companyNo" => "", "roleid" => "", "token" => ""], "post", "trim");
  347. $valide = Validate::rule([
  348. "id|账户ID" => "require|number|gt:0",
  349. "nickname|名称" => "require|max:255",
  350. "mobile|手机号" => "require|mobile",
  351. "relaComNo|业务公司" => "max:255",
  352. "companyNo|业务公司" => "max:255",
  353. "roleid|角色ID" => "require|number",
  354. ]);
  355. if ($valide->check($post) == false) return json_show(1004, $valide->getError());
  356. if ($post['roleid'] != 0) {
  357. $roleinfo = Db::name("role")->where("id", "=", $post['roleid'])->find();
  358. if (empty($roleinfo)) return json_show(1002, "角色不存在");
  359. if ($roleinfo['status'] == 0) return json_show(1002, "角色已禁用");
  360. if ($roleinfo['level'] == 1) return json_show(1002, "超管级别角色不允许设置");
  361. }
  362. if ($this->level == 1) $companyNo = isset($post['companyNo']) && $post['companyNo'] !== '' ? trim($post['companyNo']) : "";
  363. else $companyNo = isset($post['relaComNo']) && $post['relaComNo'] !== '' ? trim($post['relaComNo']) : "";
  364. if ($companyNo == "") return json_show(1004, "业务公司编号不能为空");
  365. $company = Db::name("supplier_info")->where(["code" => $companyNo])->find();
  366. if ($company == false) return json_show(1004, "业务公司不存在");
  367. $isSuper = Db::name("user_role")->alias("a")
  368. ->leftJoin("role b", "a.roleid=b.id")
  369. ->where(["a.uid" => $post['id'], "a.is_del" => 0, "b.level" => 1])
  370. ->findOrEmpty();
  371. if (!empty($isSuper)) return json_show(1002, "超管账户不允许设置其他角色");
  372. $userrole = Db::name("user_role")
  373. ->where(["uid" => $post['id'], "companyNo" => $companyNo, "is_del" => 0])
  374. ->find();
  375. $ismain = Db::name("user_role")->where(["uid" => $post['id'], "is_main" => 1, "is_del" => 0])->find();
  376. Db::startTrans();
  377. try {
  378. if (empty($userrole)) {
  379. $roledata = [
  380. "uid" => $post['id'],
  381. "roleid" => $post['roleid'],
  382. "nickname" => $post['nickname'],
  383. "companyNo" => $companyNo,
  384. "company_type" => $company["type"] == 3 ? 2 : 1,
  385. "is_main" => $ismain ? 0 : 1,
  386. "status" => 1,
  387. "addtime" => date("Y-m-d H:i:s"),
  388. "updatetime" => date("Y-m-d H:i:s")
  389. ];
  390. $companyarr = [
  391. [
  392. "companyCode" => $company["code"],
  393. "companyName" => $company["name"],
  394. "company_type" => $company["type"] == 3 ? 2 : 1,
  395. "is_main" => $ismain ? 0 : 1
  396. ]
  397. ];
  398. $companyinfo = ["id" => $post['id'], "company" => $companyarr, "token" => $post['token']];
  399. $userCommon = new \app\admin\common\User();
  400. $companyset = $userCommon->handle('setcompany', $companyinfo);
  401. if (!isset($companyset['code']) || $companyset['code'] != 0) return json_show(1004, $companyset['message']);
  402. $up = Db::name("user_role")->insert($roledata);
  403. } else {
  404. $userrole['roleid'] = $post['roleid'];
  405. $userrole['nickname'] = $post['nickname'];
  406. $userrole['companyNo'] = $companyNo;
  407. $userrole['company_type'] = $company["type"] == 3 ? 2 : 1;
  408. $userrole['updatetime'] = date("Y-m-d H:i:s");
  409. $up = Db::name("user_role")->where(["uid" => $post['id'], "companyNo" => $companyNo, "is_del" => 0])->save($userrole);
  410. }
  411. $saveinfo = [
  412. "id" => $post['id'],
  413. "nickname" => $post['nickname'],
  414. "mobile" => $post['mobile'],
  415. "token" => $post['token']
  416. ];
  417. // $saev = resetinfo($saveinfo);
  418. $userCommon = new \app\admin\common\User();
  419. $saev = $userCommon->handle('usersave', $saveinfo);
  420. if (!isset($saev['code']) || $saev['code'] != 0) {
  421. return json_show(1004, $saev['message']);
  422. }
  423. if ($up == false) {
  424. Db::rollback();
  425. return json_show(1004, '用户信息更新失败');
  426. }
  427. Db::commit();
  428. return json_show(0, '用户信息更新成功');
  429. } catch (\Exception $e) {
  430. Db::rollback();
  431. return json_show(1004, $e->getMessage());
  432. }
  433. }
  434. //修改
  435. public function UserSave()
  436. {
  437. /**
  438. * $post = $this->request->post();
  439. * $toke = isset($post['token']) ? trim($post['token']) : "";
  440. * if ($toke == "") {
  441. * return app_show(100, "token不能为空");
  442. * }
  443. * $verify = VerifyTokens($toke);
  444. * if ($verify['code'] != 0) {
  445. * return app_show($verify['code'], $verify['message']);
  446. * }
  447. * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : "";
  448. * if ($userid == "") {
  449. * return error_show(1004, "参数id 不能为空");
  450. * }
  451. *
  452. * $nickname = isset($post['nickname']) ? trim($post['nickname']) : "";
  453. * if ($nickname == "") {
  454. * return app_show(1001, "昵称不能为空");
  455. * }
  456. * $mobile = isset($post['mobile']) ? trim($post['mobile']) : "";
  457. * if ($mobile == "") {
  458. * return app_show(1002, "手机号不能为空");
  459. * }
  460. * if (checkMobile($mobile) == false) {
  461. * return app_show(1002, "手机号格式不正确");
  462. * }
  463. * $email = isset($post['email']) ? trim($post['email']) : "";
  464. * $role = isset($post['role']) ? intval($post['role']) : 0;
  465. * if ($role != 0) {
  466. * $roleinfo = Db::name("role")->where("id", "=", $role)->find();
  467. * if (empty($roleinfo)) {
  468. * return error_show(1002, "角色不存在");
  469. * }
  470. * if ($roleinfo['status'] == 0) {
  471. * return error_show(1002, "角色已禁用");
  472. * }
  473. * }
  474. * $itemid = isset($post['itemid']) && $post['itemid'] !== "" ? $post['itemid'] : "";
  475. * $item_arr = [];
  476. * if ($itemid !== "") {
  477. * foreach ($itemid as $value) {
  478. * $item_arr[] = end($value);
  479. * }
  480. * $iteminfo = Db::name("company_item")->where(["id" => $item_arr, 'is_del' => 0])->select()->toArray();
  481. * if (empty($iteminfo)) {
  482. * return error_show(1002, "未找到部门信息");
  483. * }
  484. * }
  485. * $companyArr = isset($post['companyArr']) && !empty($post['companyArr']) ? $post['companyArr'] : "";
  486. * if ($companyArr == "") {
  487. * return error_show(1004, "参数companyArr不能为空");
  488. * }
  489. * $compArr = [];
  490. * foreach ($companyArr as $value) {
  491. * $tmp = [];
  492. * if (!isset($value['businessid']) || $value['businessid'] == '') {
  493. * return error_show(1004, "参数业务公司businessid不能为空");
  494. * }
  495. * $tmp['userid'] = $userid;
  496. * $tmp['businessid'] = $value['businessid'];
  497. * $tmp['is_main'] = isset($value['is_main']) ? $value['is_main'] : 0;
  498. * $tmp['is_del'] = 0;
  499. * $tmp['addtime'] = date("Y-m-d H:i:s");
  500. * $tmp['updatetime'] = date("Y-m-d H:i:s");
  501. * $compArr[] = $tmp;
  502. * }
  503. * $platform = isset($post['platform']) && !empty($post['platform']) ? $post['platform'] : "";
  504. * if ($platform == "") {
  505. * return error_show(1004, "参数platform不能为空");
  506. * }
  507. * $plta = Db::name("platform")->where(["id" => $platform, "is_del" => 0])->select()->toArray();
  508. * if (empty($plta)) {
  509. * return error_show(1004, "未找到可用平台");
  510. * }
  511. * $userplat = Db::name("user_platform")->where(["uid" => $userid, "is_del" => 0])->find();
  512. *
  513. * $isall = isset($post['is_all']) && $post['is_all'] !== "" ? intval($post['is_all']) : "0";
  514. *
  515. * Db::startTrans();
  516. * try {
  517. * $sc = Db::name("user_business")->where(["userid" => $userid, "is_del" => 0])->select()->toArray();
  518. * if (!empty($sc)) {
  519. * $del = Db::name("user_business")->where(["userid" => $userid, "is_del" => 0])->save(["is_del" => 1,
  520. * "updatetime" => date("Y-m-d H:i:s")]);
  521. * if ($del == false) {
  522. * Db::rollback();
  523. * return error_show(1005, '业务公司添加失败');
  524. * }
  525. * }
  526. * if (!empty($compArr)) {
  527. * $in = Db::name("user_business")->insertAll($compArr);
  528. * if ($in == 0) {
  529. * Db::rollback();
  530. * return error_show(1005, '业务公司添加失败');
  531. * }
  532. * }
  533. *
  534. * if ($userplat == false) {
  535. * $userplat = [
  536. * "uid" => $userid,
  537. * "platform" => implode(",", $platform),
  538. * "is_del" => 0,
  539. * "addtime" => date("Y-m-d H:i:s"),
  540. * "updatetime" => date("Y-m-d H:i:s")
  541. * ];
  542. * } else {
  543. * $userplat['platform'] = implode(",", $platform);
  544. * $userplat['updatetime'] = date("Y-m-d H:i:s");
  545. * }
  546. * $patup = Db::name("user_platform")->save($userplat);
  547. * if ($patup == false) {
  548. * Db::rollback();
  549. * return error_show(1005, '业务平台添加失败');
  550. * }
  551. * $userrole = Db::name("user_role")->where(["uid" => $userid, "is_del" => 0])->find();
  552. * if (empty($userrole)) {
  553. * $roledata = [
  554. * "uid" => $userid,
  555. * "roleid" => $role,
  556. * "status" => 1,
  557. * "business_all" => $isall,
  558. * "addtime" => date("Y-m-d H:i:s"),
  559. * "updatetime" => date("Y-m-d H:i:s")
  560. * ];
  561. * $up = Db::name("user_role")->insert($roledata);
  562. * } else {
  563. * $userrole['roleid'] = $role;
  564. * $userrole['business_all'] = $isall;
  565. * $userrole['updatetime'] = date("Y-m-d H:i:s");
  566. * $up = Db::name("user_role")->save($userrole);
  567. * }
  568. * if ($up) {
  569. * Db::name("depart_user")->where(["uid" => $userid])->save(['is_del' => 1]);
  570. * if (isset($item_arr) && !empty($item_arr)) {
  571. * foreach ($item_arr as $v) {
  572. * $depin = [
  573. * "uid" => $userid,
  574. * "nickname" => $nickname,
  575. * "itemid" => $v,
  576. * "is_del" => 0,
  577. * "updatetime" => date("Y-m-d H:i:s")
  578. * ];
  579. * $ist = Db::name("depart_user")->where(["uid" => $userid, "itemid" => $v])->find();
  580. * if ($ist) {
  581. * $up = Db::name("depart_user")->where(["uid" => $userid, "itemid" => $v])->save($depin);
  582. * } else {
  583. * $depin['addtime'] = date("Y-m-d H:i:s");
  584. * $up = Db::name("depart_user")->insert($depin);
  585. * }
  586. * if ($up == false) {
  587. * Db::rollback();
  588. * return error_show(1005, '用户部门更新失败');
  589. * }
  590. * }
  591. * }
  592. * } else {
  593. * Db::rollback();
  594. * return error_show(1005, '角色更新失败');
  595. * }
  596. * $data = [
  597. * "id" => $userid,
  598. * "nickname" => $nickname,
  599. * "mobile" => $mobile,
  600. * "email" => $email
  601. * ];
  602. * $save = resetinfo($toke, $data);
  603. * if (!empty($save) && $save['code'] != 0) {
  604. * Db::rollback();
  605. * return error_show($save['code'], $save['message']);
  606. * }
  607. * Db::commit();
  608. * return app_show(0, "更新成功");
  609. * } catch (\Exception $e) {
  610. * Db::rollback();
  611. * return app_show(1002, $e->getMessage());
  612. * }
  613. *
  614. * **/
  615. $post = $this->request->only(["id", "nickname", "mobile", "email" => "", "portrait" => "", "sex" => ""], "post", 'trim');
  616. $validate = Validate::rule([
  617. 'id|主键ID' => 'require|number|gt:0',
  618. 'nickname|名称' => 'require|max:255',
  619. 'mobile|手机号' => 'require|mobile',
  620. 'email|名称' => 'email',
  621. 'sex|性别' => 'number|in:0,1,2',
  622. ]);
  623. if ($validate->check($post) == false) return json_show(1004, $validate->getError());
  624. $userCommon = new CommonUser();
  625. $rs = json_decode($userCommon->userSave($post), true);
  626. return json_show($rs['code'], $rs['message'], $rs['data']);
  627. }
  628. //修改密码
  629. public function setPwd()
  630. {
  631. /**
  632. * $post = $this->request->post();
  633. * $token = isset($post['token']) ? trim($post['token']) : "";
  634. * if ($token == "") {
  635. * return error_show(101, 'token不能为空');
  636. * }
  637. * $effetc = VerifyTokens($token);
  638. * if (!empty($effetc) && $effetc['code'] != 0) {
  639. * return error_show($effetc['code'], $effetc['message']);
  640. * }
  641. * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : "";
  642. * if ($userid == "") {
  643. * return error_show(1004, "参数id 不能为空");
  644. * }
  645. * $newPwd = isset($post['password']) ? trim($post['password']) : "";
  646. * if ($newPwd == "") {
  647. * return error_show(1001, '密码不能为空');
  648. * }
  649. *
  650. * $data = resetpwd($token, ["id" => $userid, 'password' => $newPwd]);
  651. * if (empty($data) || $data['code'] != 0) {
  652. * return error_show($data['code'], $data['message']);
  653. * } else {
  654. * return app_show(0, "密码修改成功");
  655. * }
  656. * **/
  657. $post = $this->request->only(["id", "password"], "post", "trim");
  658. $validate = Validate::rule([
  659. 'id|账户ID' => 'require|number',
  660. 'password|密码' => 'require|min:6|max:200',
  661. ]);
  662. if (!$validate->check($post)) return json_show(1004, $validate->getError());
  663. $userCommon = new CommonUser();
  664. $rs = json_decode($userCommon->resetPasswd($post), true);
  665. return json_show($rs['code'], $rs['message'], $rs['data']);
  666. }
  667. //启禁用
  668. public function userStatus()
  669. {
  670. /**
  671. * $post = $this->request->post();
  672. * $toke = isset($post['token']) ? trim($post['token']) : "";
  673. * if ($toke == "") {
  674. * return app_show(100, "token不能为空");
  675. * }
  676. * $verify = VerifyTokens($toke);
  677. * if ($verify['code'] != 0) {
  678. * return app_show($verify['code'], $verify['message']);
  679. * }
  680. * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : "";
  681. * if ($userid == "") {
  682. * return error_show(1004, "参数userid 不能为空");
  683. * }
  684. * $status = isset($post['status']) && $post['status'] != "" ? intval($post['status']) : "";
  685. *
  686. * if ($status === "") {
  687. * return error_show(1004, "参数status 不能为空");
  688. * }
  689. * if (!in_array($status, [0, 1])) {
  690. * return error_show(1004, "参数status无效");
  691. * }
  692. * $message = $status == 1 ? "启用" : "禁用";
  693. * $userinfo = Db::name("user_role")->where(["uid" => $userid, "is_del" => 0])->find();
  694. * if ($userinfo == false) {
  695. * $data = [
  696. * "uid" => $userid,
  697. * "roleid" => 0,
  698. * "status" => $status,
  699. * "is_del" => 0,
  700. * "addtime" => date("Y-m-d H:i:s"),
  701. * "updatetime" => date("Y-m-d H:i:s"),
  702. * ];
  703. * $sa = Db::name("user_role")->save($data);
  704. * } else {
  705. * $userinfo['status'] = $status;
  706. * $userinfo['updatetime'] = date("Y-m-d H:i:s");
  707. * $sa = Db::name("user_role")->save($userinfo);
  708. * }
  709. * if ($sa == false) {
  710. * return error_show(1005, "{$message}失败");
  711. * } else {
  712. *
  713. * return app_show(0, "{$message}成功");
  714. * }
  715. *
  716. * // $set = resetstatus($toke,["id"=>$userid,"status"=>$status]);
  717. * //
  718. * // if(empty($set)||$set['code']!=0){
  719. * // return error_show(1005,"{$message}失败");
  720. * // }else{
  721. * // D
  722. * // return app_show(0,"{$message}成功");
  723. * // }
  724. * **/
  725. $post = $this->request->only(["id", "status"], "post", 'trim');
  726. $validate = Validate::rule([
  727. 'id|主键ID' => 'require|number|gt:0',
  728. 'status|状态' => 'require|number|in:0,1',
  729. ]);
  730. if (!$validate->check($post)) return json_show(1004, $validate->getError());
  731. $userCommon = new CommonUser();
  732. $rs = json_decode($userCommon->resetState($post), true);
  733. return json_show($rs['code'], $rs['message'], $rs['data']);
  734. }
  735. public function getinfo()
  736. {
  737. $post = $this->request->post();
  738. $token = isset($post['token']) ? trim($post['token']) : "";
  739. if ($token == "") {
  740. return app_show(101, 'token不能为空');
  741. }
  742. $effetc = VerifyTokens($token);
  743. if (!empty($effetc) && $effetc['code'] != 0) {
  744. return app_show($effetc['code'], $effetc['message']);
  745. }
  746. $userinfo = GetUserInfo($token);
  747. if (empty($userinfo) || $userinfo['code'] != 0) {
  748. return app_show(102, "员工信息不存在");
  749. }
  750. $data = $userinfo['data'];
  751. $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $data['id'])
  752. ->field("roleid,role_name,business_all,uid")->find();
  753. $data['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
  754. $data['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
  755. $st = Db::name('user_business')->where(['userid' => $role['uid'], "is_del" => 0])->field('businessid,is_main')->select()->toArray();
  756. $val = [];
  757. if (!empty($st)) {
  758. foreach ($st as $itom) {
  759. $tep = [];
  760. $business = Db::name('business')->where(['id' => $itom['businessid'], "is_del" => 0])->field("company,companyNo")->find();
  761. $tep['company'] = isset($business['company']) ? $business['company'] : "";
  762. $tep['companyNo'] = isset($business['companyNo']) ? $business['companyNo'] : "";
  763. $tep['businessid'] = $itom['businessid'];
  764. $tep['is_main'] = $itom['is_main'];
  765. $val[] = $tep;
  766. }
  767. }
  768. $data['private_field'] = [];
  769. if ($data['roleid'] != "") {
  770. $action = Db::name("role_action")->where(["role_id" => $data['roleid'], "status" => 1])->find();
  771. if ($action != false) {
  772. $data['private_field'] = isset($action['private_field']) && $action['private_field'] != "" ? explode(",",$action['private_field']) : [];
  773. }
  774. }
  775. $data['business'] = $val;
  776. $info = [];
  777. $stn = Db::name('user_platform')->where(['uid' => $role['uid']])->find();
  778. if ($stn != false) {
  779. $plat = isset($stn['platform']) ? explode(",", $stn['platform']) : "";
  780. if ($plat != "") {
  781. $platform = Db::name('platform')->where(['id' => $plat, 'is_del' => 0])->column("id,platform_name,platform_code");
  782. $info = $platform;
  783. }
  784. }
  785. $depart = Db::name("depart_user")->where([["uid", "=", $data['id']], ["is_del", "=", 0]])->column("itemid");
  786. $data['depart'] = "";
  787. if (!empty($depart)) {
  788. $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")->select()->toArray();
  789. if (!empty($deparname)) {
  790. foreach ($deparname as $ky => $item) {
  791. $deparname[$ky]['depart_code'] = array_filter(explode("-", $item['depart_link']));
  792. }
  793. }
  794. $data['depart'] = $deparname;
  795. }
  796. $data['platform'] = $info;
  797. return app_show(0, "获取成功", $data);
  798. }
  799. //超管账号列表
  800. public function userSingleList()
  801. {
  802. $post = $this->request->only(["token" => "", "nickname" => "", "relaComNo" => "", "islevel" => "", "username" => "", "companyNo" => "", "status" => "", "page" => 1, "size" => 10], "post");
  803. if ($this->level == 1) {
  804. $companyNo = $post['companyNo'] ?? "";
  805. } else {
  806. $companyNo = $post['relaComNo'] ?? "";
  807. $post['companyNo'] = $post['relaComNo'] ?? "";
  808. }
  809. $where = [["a.is_del", "=", 0]];
  810. unset($post['relaComNo']);
  811. if ($post['companyNo'] != "") {
  812. $where[] = ["a.companyNo", "=", $companyNo];
  813. }
  814. if ($post["islevel"] != "") {
  815. $uid = Db::name("user_role")->alias("a")
  816. ->leftJoin("role b", "a.roleid=b.id")->where([["b.level", "=", 1], ["a.is_del", "=", 0]])->where($where)->column
  817. ("uid");
  818. if ($post['islevel'] == 1) $post['uid'] = $uid;
  819. else $post['nuid'] = $uid;
  820. unset($post["islevel"]);
  821. }
  822. $userCommon = new \app\admin\common\User();
  823. $userinfo = $userCommon->GetAccountall($post);
  824. $userinfo = json_decode($userinfo,true);
  825. if (empty($userinfo) || $userinfo['code'] != 0) return app_show($userinfo['code'], $userinfo['msg']);
  826. $data = $userinfo['data']['list'];
  827. $list = [];
  828. foreach ($data as $value) {
  829. if (isset($value['company_relaton']) && !empty($value['company_relaton'])) {
  830. foreach ($value['company_relaton'] as &$item) {
  831. $roleArr = Db::name("user_role")->alias("a")
  832. ->leftJoin("role b", "a.roleid=b.id")
  833. ->where(["uid" => $value['id'], "a.companyNo" => $item['companyCode'], "is_del" => 0])
  834. ->field("role_name,roleid,a.status,b.level")->findOrEmpty();
  835. $item['roleid'] = $roleArr['roleid'] ?? "";
  836. $item['status'] = $roleArr['status'] ?? 0;
  837. $item["role_name"] = $roleArr['role_name'] ?? "";
  838. $item["role_level"] = $roleArr['level'] ?? "";
  839. }
  840. }
  841. $value['roleid'] = $roleArr['roleid'] ?? "";
  842. $value['status'] = $value['status'] ?? 0;
  843. $value["role_name"] = $roleArr['role_name'] ?? "";
  844. $value["role_level"] = $roleArr['level'] ?? "";
  845. $list[] = $value;
  846. }
  847. return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]);
  848. }
  849. }