User.php 31 KB

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