User.php 31 KB

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