User.php 31 KB

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