User.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980
  1. <?php
  2. namespace app\common\model;
  3. use app\hander\HelpHander;
  4. use think\Db;
  5. use think\Exception;
  6. use think\Model;
  7. class User extends Model
  8. {
  9. public $sex = [
  10. "未知",
  11. "男",
  12. "女"
  13. ];
  14. protected function setPasswordAttr($value){
  15. if(trim($value)){
  16. return password_hash($value, PASSWORD_DEFAULT);
  17. }
  18. return '';
  19. }
  20. public function addUser(){
  21. $data = [
  22. 'id' => input('id/d',0),
  23. 'account' => input('account','','trim'),
  24. 'real_name' => input('real_name','','trim'),
  25. 'mobile' => input('mobile','','trim'),
  26. 'password' => input('password','','trim'),
  27. 'depId' => input('depId/d',0),
  28. 'rolesId' => input('rolesId/d',0),
  29. 'enable' => input('enable/d',1),
  30. 'addr_id' => input('addr_id/d',0),
  31. 'sort'=>input('sort',0,'trim'),
  32. 'type_id' => input('type_id/d', 0),
  33. 'sex' => input('sex/d', 0),
  34. ];
  35. $orgId = cur_org_id();
  36. $result = validate('User')->check($data,[],'add');
  37. if(true !== $result){
  38. $this->error = validate('User')->getError();
  39. return false;
  40. }
  41. Db::startTrans();
  42. try{
  43. $id = $data['id'];
  44. unset($data['id']);
  45. $depId = $data['depId'];
  46. $rolesId = $data['rolesId'];
  47. unset($data['depId']);
  48. unset($data['rolesId']);
  49. $role = Db::name('roles')
  50. ->where('id',$rolesId)
  51. ->find();
  52. if($rolesId!=7 && $role['parent_id']!=7){
  53. unset($data['type_id']);
  54. }
  55. if($id > 0){
  56. $ids = $id;
  57. if(!$data['password']){
  58. unset($data['password']);
  59. }
  60. $data['update_time'] = date('Y-m-d H:i:s');
  61. $ret = $this->allowField(true)->save($data,['id'=>$id]);
  62. if(!$ret){
  63. \exception('操作失败');
  64. }
  65. $ud = Db::name('user_dep')->where('user_id',$id)->find();
  66. if(!$ud){
  67. Db::name('user_dep')->insert(['user_id'=>$id,'dep_id'=>$depId]);
  68. }else{
  69. Db::name('user_dep')->where('user_id',$id)->setField('dep_id',$depId);
  70. }
  71. $ur = Db::name('user_roles')->where('user_id',$id)->find();
  72. if(!$ur){
  73. Db::name('user_roles')->insert(['user_id'=>$id,'roles_id'=>$rolesId]);
  74. }else{
  75. Db::name('user_roles')->where('user_id',$id)->setField('roles_id',$rolesId);
  76. }
  77. $rolesParentId = Db::name('roles')
  78. ->where('id',$rolesId)
  79. ->value('parent_id');
  80. if($rolesParentId==11){
  81. $check = Db::name('worker')
  82. ->where('user_id',$id)->find();
  83. if(empty($check)){
  84. $a = [
  85. 'user_id'=>$id
  86. ];
  87. $res = Db::name('worker')
  88. ->insertGetId($a);
  89. if(!$res){
  90. \exception('护工保存失败');
  91. }
  92. }
  93. }
  94. }else{
  95. $data['password'] = password_hash($data['password'], PASSWORD_DEFAULT);
  96. $data['create_time'] = date('Y-m-d H:i:s');
  97. $data['ip'] = request()->ip();
  98. $ret = $this->insertGetId($data);
  99. $ids = $ret;
  100. if(!$ret){
  101. \exception('操作失败');
  102. }
  103. Db::name('user_org')->insert(['user_id'=>$ids,'org_id'=>$orgId]);
  104. Db::name('user_dep')->insert(['user_id'=>$ids,'dep_id'=>$depId]);
  105. Db::name('user_roles')->insert(['user_id'=>$ids,'roles_id'=>$rolesId]);
  106. $rolesParentId = Db::name('roles')
  107. ->where('id',$rolesId)
  108. ->value('parent_id');
  109. if($rolesParentId==11){
  110. Db::name('worker')
  111. ->where('user_id',$ids)
  112. ->delete();
  113. $a = [
  114. 'user_id'=>$ids
  115. ];
  116. $res = Db::name('worker')
  117. ->insertGetId($a);
  118. if(!$res){
  119. \exception('护工保存失败');
  120. }
  121. }
  122. }
  123. model('Wlps')->updateYsUser($ids,$data['real_name'],$data['mobile'],$rolesId,$orgId);
  124. Db::commit();
  125. return true;
  126. }catch (Exception $e){
  127. Db::rollback();
  128. $this->error = $e->getMessage();
  129. return false;
  130. }
  131. }
  132. public function wxaddUser(){
  133. $data = [
  134. 'id' => input('id/d',0),
  135. 'real_name' => input('real_name','','trim'),
  136. 'enable' => input('enable/d',1),
  137. ];
  138. $result = validate('User')->check($data,[],'wxedit');
  139. if(true !== $result){
  140. $this->error = validate('User')->getError();
  141. return false;
  142. }
  143. Db::startTrans();
  144. try{
  145. $id = $data['id'];
  146. unset($data['id']);
  147. if($id > 0){
  148. $data['update_time'] = date('Y-m-d H:i:s');
  149. $ret = $this->allowField(true)->save($data,['id'=>$id]);
  150. if(!$ret){
  151. \exception('操作失败');
  152. }
  153. }else{
  154. }
  155. Db::commit();
  156. return true;
  157. }catch (Exception $e){
  158. Db::rollback();
  159. $this->error = $e->getMessage();
  160. return false;
  161. }
  162. }
  163. public function addCompany(){
  164. $data = [
  165. 'id' => input('id/d',0),
  166. 'account' => input('account','','trim'),
  167. 'real_name' => input('real_name','','trim'),
  168. 'mobile' => input('mobile','','trim'),
  169. 'password' => input('password','','trim'),
  170. 'orgs' => input('orgs','','trim'),
  171. 'rolesId' => input('rolesId/d',0),
  172. 'enable' => input('enable/d',1),
  173. 'type' => 1
  174. ];
  175. $result = validate('User')->check($data,[],'addCompany');
  176. if(true !== $result){
  177. $this->error = validate('User')->getError();
  178. return false;
  179. }
  180. Db::startTrans();
  181. try{
  182. $id = $data['id'];
  183. unset($data['id']);
  184. $rolesId = $data['rolesId'];
  185. unset($data['rolesId']);
  186. if($rolesId == 1){ //超级管理员
  187. $data['orgs'] = '';
  188. }
  189. if($id > 0){
  190. if(!$data['password']){
  191. unset($data['password']);
  192. }
  193. $data['update_time'] = date('Y-m-d H:i:s');
  194. $ret = $this->allowField(true)->save($data,['id'=>$id]);
  195. if(!$ret){
  196. \exception('操作失败');
  197. }
  198. Db::name('user_roles')->where('user_id',$id)->setField('roles_id',$rolesId);
  199. }else{
  200. $data['create_time'] = date('Y-m-d H:i:s');
  201. $data['ip'] = request()->ip();
  202. $ret = $this->allowField(true)->save($data);
  203. if(!$ret){
  204. \exception('操作失败');
  205. }
  206. Db::name('user_roles')->insert(['user_id'=>$this->id,'roles_id'=>$rolesId]);
  207. }
  208. Db::commit();
  209. return true;
  210. }catch (Exception $e){
  211. Db::rollback();
  212. $this->error = $e->getMessage();
  213. return false;
  214. }
  215. }
  216. // 修改密码
  217. public function modifyPass($data){
  218. $result = validate('User')->check($data,[],'modifyPass');
  219. if(true !== $result){
  220. $this->error = validate('User')->getError();
  221. return false;
  222. }
  223. $info = Db::name('user')->where('id',$data['id'])->where('del',0)->find();
  224. if(!$info){
  225. $this->error = '用户不存在';
  226. return false;
  227. }
  228. if (!password_verify($data['oldpass'], $info['password'])) {
  229. $this->error = "旧密码错误";
  230. return false;
  231. }
  232. $data['update_time'] = date('Y-m-d H:i:s');
  233. $sdata = [
  234. 'update_time' => date('Y-m-d H:i:s'),
  235. 'password' => $data['pass'],
  236. 'login' => 1
  237. ];
  238. $ret = $this->allowField(true)->save($sdata,['id'=>$data['id']]);
  239. if(!$ret){
  240. $this->error = "密码修改失败";
  241. return false;
  242. }
  243. return true;
  244. }
  245. //app登录
  246. public function login($accountName,$password){
  247. // 登录限流
  248. $ret = (new \app\common\util\ThrottlesUtil(config('app.login_throttles')))->tooManyAttempts($accountName);
  249. if($ret){
  250. $this->error ='账号已被锁定,请稍后重试';
  251. return false;
  252. }
  253. // 登录是根据账号和手机号组成,先查账号再查手机号
  254. $user = Db::name('user')
  255. ->where('account',$accountName)
  256. ->where('del',0)
  257. ->find();
  258. if(empty($user)){
  259. $user = Db::name('user')
  260. ->where('mobile',$accountName)
  261. ->where('del',0)
  262. ->find();
  263. }
  264. if(empty($user)){
  265. $this->error = '账号或密码错误';
  266. return false;
  267. }
  268. $pass = aes_decrypt($password);
  269. if(!password_verify($pass, $user['password'])){
  270. $this->error = '账号或密码错误';
  271. return false;
  272. }
  273. $token = $this->authLogin($user['id']);
  274. if(!$token){
  275. $this->error = '登录失败';
  276. return false;
  277. }
  278. // 登录成功,重置限流
  279. (new \app\common\util\ThrottlesUtil(config('app.login_throttles')))->resetAttempts($accountName);
  280. return ['user_id' => $user['id'],'token' => $token];
  281. }
  282. private function authLogin($userId,$openid=''){
  283. Db::startTrans();
  284. try{
  285. $res = Db::name('user')->where('id',$userId)->update([
  286. 'last_login_time' => date('Y-m-d H:i:s')
  287. ]);
  288. if(!$res){
  289. \exception('登录失败');
  290. }
  291. $token = model('Token')->updateToken($userId);
  292. if(!$token){
  293. \exception(model('Token')->getError());
  294. }
  295. if($openid){
  296. $ret = Db::name('user_oauth')->insert([
  297. 'user_id' => $userId,
  298. 'openid' => $openid,
  299. 'type' => 1,
  300. 'create_time' => date('Y-m-d H:i:s')
  301. ]);
  302. if (!$ret) {
  303. \exception('事务失败');
  304. }
  305. }
  306. Db::commit();
  307. return $token;
  308. }catch (Exception $e){
  309. Db::rollback();
  310. $this->error = $e->getMessage();
  311. return false;
  312. }
  313. }
  314. // 小程序手机号登录
  315. public function wxpLogin($phone,$orgId){
  316. // 1.检查用户是否存在,存在登录,不存在告诉用户进行下一步
  317. $user = Db::name('user')->where('mobile',$phone)->where('del',0)->find();
  318. if(!$user){ // 不存在注册
  319. HelpHander::error('用户不存在',2,['phone'=>$phone]); // 用户进行下一步
  320. Db::startTrans();
  321. try{
  322. $data = [
  323. 'account' => md5($phone.$orgId.get_unique_id().time()),
  324. 'real_name' => $phone,
  325. 'mobile' => $phone,
  326. 'password' => $phone,
  327. 'enable' => 1,
  328. 'type' => 2,
  329. 'last_login_time' => date('Y-m-d H:i:s'),
  330. ];
  331. $data['create_time'] = date('Y-m-d H:i:s');
  332. $data['ip'] = request()->ip();
  333. $ret = $this->allowField(true)->save($data);
  334. if(!$ret){
  335. \exception('操作失败');
  336. }
  337. $userId = $this->id;
  338. $token = model('Token')->updateToken($userId);
  339. if(!$token){
  340. \exception(model('Token')->getError());
  341. }
  342. Db::name('user_org')->insert([
  343. 'user_id' => $userId,
  344. 'org_id' => $orgId
  345. ]);
  346. Db::commit();
  347. }catch (Exception $e){
  348. Db::rollback();
  349. $this->error = $e->getMessage();
  350. return false;
  351. }
  352. return ['user_id' => $userId,'token' => $token,'org_id' => $orgId];
  353. }else{
  354. if($user['enable'] != 1){
  355. HelpHander::error('用户被禁用,请联系管理员');
  356. }
  357. // 获取用户组织
  358. $uo = Db::name('user_org')->where('user_id',$user['id'])->find();
  359. if(!$uo){
  360. Db::name('user_org')->insert([
  361. 'user_id' => $user['id'],
  362. 'org_id' => $orgId
  363. ]);
  364. $curOrgId = $orgId;
  365. }else{
  366. $curOrgId = $uo['org_id'];
  367. }
  368. $org = Db::name('org')->where('id',$curOrgId)->where('del',0)->where('enable',1)->where('type',2)->find();
  369. if(!$org){
  370. $this->error = "项目不存在或已禁用";
  371. return false;
  372. }
  373. Db::startTrans();
  374. try{
  375. $data = [
  376. 'last_login_time' => date('Y-m-d H:i:s'),
  377. ];
  378. $ret = Db::name('user')->where('id',$user['id'])->update($data);
  379. if(!$ret){
  380. \exception('操作失败');
  381. }
  382. $token = model('Token')->updateToken($user['id']);
  383. if(!$token){
  384. \exception(model('Token')->getError());
  385. }
  386. Db::commit();
  387. }catch (Exception $e){
  388. Db::rollback();
  389. $this->error = $e->getMessage();
  390. return false;
  391. }
  392. return ['user_id' => $user['id'],'token' => $token,'org_id' => $curOrgId];
  393. }
  394. }
  395. // 小程序登录
  396. public function wxLogin($openid,$nickname,$avatar,$orgId){
  397. $oauth = Db::name('user_oauth')
  398. ->where('openid',$openid)
  399. ->where('type',1)
  400. ->find();
  401. if($oauth){
  402. return $this->wxPreLogin($openid,$orgId);
  403. }
  404. $org = Db::name('org')->where('id',$orgId)->where('del',0)->where('enable',1)->where('type',2)->find();
  405. if(!$org){
  406. $this->error = "项目不存在";
  407. return false;
  408. }
  409. Db::startTrans();
  410. try{
  411. $data = [
  412. 'account' => $orgId.'_'.$openid,
  413. 'real_name' => $nickname,
  414. 'head_image' => $avatar,
  415. 'mobile' => '',
  416. 'password' => $openid,
  417. 'enable' => 1,
  418. 'type' => 2,
  419. 'last_login_time' => date('Y-m-d H:i:s'),
  420. ];
  421. $data['create_time'] = date('Y-m-d H:i:s');
  422. $data['ip'] = request()->ip();
  423. $ret = $this->allowField(true)->save($data);
  424. if(!$ret){
  425. \exception('操作失败');
  426. }
  427. $userId = $this->id;
  428. $token = model('Token')->updateToken($userId);
  429. if(!$token){
  430. \exception(model('Token')->getError());
  431. }
  432. if($openid){
  433. $ret = Db::name('user_oauth')->insert([
  434. 'user_id' => $userId,
  435. 'openid' => $openid,
  436. 'type' => 1,
  437. 'create_time' => date('Y-m-d H:i:s')
  438. ]);
  439. if (!$ret) {
  440. \exception('事务失败');
  441. }
  442. }
  443. Db::name('user_org')->insert([
  444. 'user_id' => $userId,
  445. 'org_id' => $orgId
  446. ]);
  447. Db::commit();
  448. }catch (Exception $e){
  449. Db::rollback();
  450. $this->error = $e->getMessage();
  451. return false;
  452. }
  453. return ['user_id' => $userId,'token' => $token];
  454. }
  455. // 微信小程序预登陆
  456. public function wxPreLogin($openid,$orgId){
  457. $org = Db::name('org')->where('id',$orgId)->where('del',0)->where('enable',1)->where('type',2)->find();
  458. if(!$org){
  459. $this->error = "项目不存在";
  460. return false;
  461. }
  462. $oauth = Db::name('user_oauth')
  463. ->where('openid',$openid)
  464. ->where('type',1)
  465. ->find();
  466. if(empty($oauth)){ // 账号不存在注册一个
  467. $data = [
  468. 'account' => $orgId.'_'.$openid,
  469. 'real_name' => "",
  470. 'mobile' => '',
  471. 'password' => $openid,
  472. 'head_image' => "",
  473. 'enable' => 1,
  474. 'type' => 2,
  475. ];
  476. $data['create_time'] = date('Y-m-d H:i:s');
  477. $data['ip'] = request()->ip();
  478. $ret = $this->allowField(true)->save($data);
  479. if(!$ret){
  480. \exception('操作失败');
  481. }
  482. $userId = $this->id;
  483. $uoData = [
  484. 'openid'=>$openid,
  485. 'user_id'=>$userId,
  486. 'create_time'=>date('Y-m-d H:i:s'),
  487. 'type'=>1
  488. ];
  489. $uo = Db::name('user_oauth')->insert($uoData);
  490. if(!$uo){
  491. $this->error = '登录失败';
  492. return false;
  493. }
  494. }else{
  495. $userId = $oauth['user_id'];
  496. }
  497. $user = Db::name('user')
  498. ->where('id',$userId)
  499. ->where('del',0)
  500. ->find();
  501. if(empty($user)){
  502. $this->error = '账号不存在';
  503. return false;
  504. }
  505. $uo = Db::name('user_org')->where('user_id',$user['id'])->where('org_id',$orgId)->find();
  506. if(!$uo){
  507. Db::name('user_org')->insert([
  508. 'user_id' => $user['id'],
  509. 'org_id' => $orgId
  510. ]);
  511. }
  512. $token = $this->authLogin($user['id'],'',$orgId);
  513. if(!$token){
  514. $this->error = '登录失败';
  515. return false;
  516. }
  517. return ['user_id' => $user['id'],'token' => $token,'org_name' => $org['name']];
  518. }
  519. /**
  520. * 专项保洁获取人员
  521. *
  522. * @author wst
  523. * @date 2021/9/6 10:45
  524. */
  525. public function getCleanWorker(){
  526. $list = (new WorkTypeMode())->getRolesUser(14,cur_org_id());
  527. $arr = [];
  528. foreach ($list as $k=>$v){
  529. if(!empty($v['user'])){
  530. foreach ($v['user'] as $k1=>$v1){
  531. $arr[] = [
  532. 'id'=>$v1['id'],
  533. 'title'=>$v1['real_name'],
  534. ];
  535. }
  536. }
  537. }
  538. return $arr;
  539. }
  540. /**
  541. * 设备台账获取人员
  542. *
  543. * @author wst
  544. * @date 2021/9/8 14:59
  545. * @return array
  546. */
  547. public function getDeviceWorker(){
  548. $list = (new WorkTypeMode())->getRolesUser(10,cur_org_id());
  549. $arr = [];
  550. foreach ($list as $k=>$v){
  551. if(!empty($v['user'])){
  552. foreach ($v['user'] as $k1=>$v1){
  553. $arr[] = [
  554. 'id'=>$v1['id'],
  555. 'title'=>$v1['real_name'],
  556. ];
  557. }
  558. }
  559. }
  560. return $arr;
  561. }
  562. /**
  563. * 巡更模块获取人员
  564. *
  565. * @author wst
  566. * @date 2021/9/8 15:00
  567. * @return array
  568. */
  569. public function getPatrolWorker($id){
  570. $list = (new WorkTypeMode())->getRolesUser($id,cur_org_id());
  571. $arr = [];
  572. foreach ($list as $k=>$v){
  573. if(!empty($v['user'])){
  574. foreach ($v['user'] as $k1=>$v1){
  575. $arr[] = [
  576. 'id'=>$v1['id'],
  577. 'title'=>$v1['real_name'],
  578. ];
  579. }
  580. }
  581. }
  582. return $arr;
  583. }
  584. /**
  585. * 医废获取人员
  586. *
  587. * @author wst
  588. * @date 2021/9/8 15:01
  589. * @param string $test
  590. * @return bool
  591. */
  592. public function getWasteWorker(){
  593. $list = (new WorkTypeMode())->getRolesUser(11,cur_org_id());
  594. $arr = [];
  595. foreach ($list as $k=>$v){
  596. if(!empty($v['user'])){
  597. foreach ($v['user'] as $k1=>$v1){
  598. $arr[] = [
  599. 'id'=>$v1['id'],
  600. 'title'=>$v1['real_name'],
  601. ];
  602. }
  603. }
  604. }
  605. return $arr;
  606. }
  607. /**
  608. * 获取医废未转运提示人员
  609. *
  610. * @author wst
  611. * @date 2021/9/8 15:01
  612. * @param string $test
  613. * @return bool
  614. */
  615. public function getWasteWorkerList(){
  616. $user = Db::name('user')
  617. ->alias('u')
  618. ->field('u.id,u.real_name as title')
  619. ->join('user_org uo','uo.user_id=u.id')
  620. ->where([
  621. 'uo.org_id'=>cur_org_id(),
  622. 'u.del'=>0,
  623. 'u.enable'=>1,
  624. ])
  625. ->select();
  626. return $user;
  627. }
  628. /**
  629. * 获取用户消息
  630. * @param $userId
  631. */
  632. public function info($userId,$orgId=0){
  633. $user = Db::name('user')
  634. ->where('id',$userId)
  635. ->where('del',0)
  636. ->where('enable',1)
  637. ->field('id,real_name,mobile,type,head_image,work,station,addr_id,device_sn,login')
  638. ->find();
  639. if(!$user){
  640. $this->error = '用户不存在或被禁用';
  641. return false;
  642. }
  643. $dep = Db::name('user_dep')
  644. ->alias('ud')
  645. ->join('dep d','d.id = ud.dep_id')
  646. ->field('d.id,d.title')
  647. ->where('ud.user_id',$userId)
  648. ->find();
  649. $user['dep_id'] = $dep?$dep['id']:0;
  650. $user['dep_name'] = $dep?$dep['title']:'';
  651. $addrTitle = Db::name('address')
  652. ->where('id',$user['addr_id'])
  653. ->value('title');
  654. $user['addr_title'] = $user['addr_id']>0?$addrTitle:'';
  655. $roles = Db::name('user_roles')
  656. ->alias('ur')
  657. ->join('roles r','r.id = ur.roles_id')
  658. ->field('r.id,r.name,r.parent_id')
  659. ->where('ur.user_id',$userId)
  660. ->find();
  661. $user['roles_id'] = $roles?$roles['id']:0;
  662. $user['roles_name'] = $roles?$roles['name']:'';
  663. $parentId = $roles?$roles['parent_id']:0;
  664. $user['userType'] = $parentId==3?1:2;//2其它1客户
  665. $user['workTypeMode'] = '';
  666. $user['isTwoDispatch'] = 2;
  667. if($user['roles_id'] >0){
  668. $rolesInfo = Db::name('roles')
  669. ->where('id',$user['roles_id'])
  670. ->find();
  671. $user['workTypeMode'] = $rolesInfo['work_type_mode'];
  672. $user['isTwoDispatch'] = $rolesInfo['level'];
  673. }
  674. return $user;
  675. }
  676. /*
  677. * 获取某组织下全部人员
  678. * @param $orgId
  679. */
  680. public function gerUserAll($orgId = 0){
  681. $user = Db::name('user')
  682. ->alias('u')
  683. ->field('u.id,u.real_name as title')
  684. ->join('user_org uo','u.id=uo.user_id')
  685. ->where('uo.org_id',$orgId)
  686. ->where('enable',1)
  687. ->where('del',0)
  688. ->select();
  689. return $user;
  690. }
  691. //获取二级调度角色下用户、
  692. public function get_two_dispatch_user($rolesId){
  693. $user = Db::name('user_roles')
  694. ->alias('a')
  695. ->join('user u','a.user_id=u.id')
  696. ->where('a.roles_id',$rolesId)
  697. ->where('u.del',0)
  698. ->where('u.enable',1)
  699. ->where('u.type',0)
  700. ->select();
  701. return $user;
  702. }
  703. //后台获取所有二级调度角色
  704. public function get_two_dispatch_role($orgId,$type){
  705. $map[] = ['enable','=',1];
  706. $map[] = ['level','=',2];
  707. $map[] = ['del','=',0];
  708. $map[] = ['parent_id','=',9];
  709. $map[] = ['org_id','=',$orgId];
  710. $map[] = ['','exp',Db::raw("FIND_IN_SET(".$type.",work_type_mode)")];
  711. $role = Db::name('roles')
  712. ->field('id,name as title')
  713. ->where($map)
  714. ->select();
  715. return $role;
  716. }
  717. //api获取所有二级调度角色
  718. public function get_two_dispatch_role1($orgId,$type){
  719. $map[] = ['enable','=',1];
  720. $map[] = ['level','=',2];
  721. $map[] = ['del','=',0];
  722. $map[] = ['parent_id','=',9];
  723. $map[] = ['org_id','=',$orgId];
  724. $map[] = ['','exp',Db::raw("FIND_IN_SET(".$type.",work_type_mode)")];
  725. $role = Db::name('roles')
  726. ->field('id,name as realName')
  727. ->where($map)
  728. ->select();
  729. return $role;
  730. }
  731. // 根据id获取用户信息
  732. public function getUserInfo($id){
  733. $info = Db::name('user')
  734. ->where('id',$id)
  735. ->where('del',0)
  736. ->find();
  737. return $info;
  738. }
  739. //获取所有调度
  740. public function get_dispatch_user($orgId){
  741. $roles = Db::name('roles')
  742. ->where('parent_id',9)
  743. ->where('org_id',$orgId)
  744. ->where('del',0)
  745. ->where('enable',1)
  746. ->column('id');
  747. if(empty($roles)){
  748. return [];
  749. }
  750. $user = Db::name('user')
  751. ->alias('a')
  752. ->join('user_roles u','a.id=u.user_id')
  753. ->where('u.roles_id','in',$roles)
  754. ->where('a.del',0)
  755. ->where('a.enable',1)
  756. ->where('a.type',0)
  757. ->select();
  758. return $user;
  759. }
  760. /**
  761. * 获取拥有陪护模块权限的人
  762. * @param $orgId
  763. */
  764. public function get_ph_dispatch_user($orgId){
  765. $appId = Db::name('app_icon')->where('mode',25)->value('id');
  766. if(!$appId){
  767. return [];
  768. }
  769. $map[] = ['org_id','=',$orgId];
  770. $map[] = ['del','=',0];
  771. $map[] = ['enable','=',1];
  772. $map[] = ['','exp',Db::raw("FIND_IN_SET('appauths','".$appId."')")];
  773. $roles = Db::name('roles')->where($map)->column('id');
  774. if(empty($roles)){
  775. return [];
  776. }
  777. $user = Db::name('user')
  778. ->alias('a')
  779. ->join('user_roles u','a.id=u.user_id')
  780. ->where('u.roles_id','in',$roles)
  781. ->where('a.del',0)
  782. ->where('a.enable',1)
  783. ->where('a.type',0)
  784. ->select();
  785. return $user;
  786. }
  787. /**
  788. * 运送获取人员
  789. *
  790. * @author wst
  791. * @date 2021/9/8 14:59
  792. * @return array
  793. */
  794. public function getConveyWorker(){
  795. $list = (new WorkTypeMode())->getRolesUser(6,cur_org_id());
  796. $arr = [];
  797. foreach ($list as $k=>$v){
  798. if(!empty($v['user'])){
  799. foreach ($v['user'] as $k1=>$v1){
  800. $arr[] = [
  801. 'id'=>$v1['id'],
  802. 'title'=>$v1['real_name'],
  803. ];
  804. }
  805. }
  806. }
  807. return $arr;
  808. }
  809. public function wxRegister($post){
  810. $post['id'] = 0;
  811. $result = validate('User')->check($post,[],'wxadd');
  812. if(true !== $result){
  813. $this->error = validate('User')->getError();
  814. return false;
  815. }
  816. $data = [
  817. 'mobile' => $post['mobile'],
  818. 'real_name' => $post['real_name'],
  819. 'password' => $post['password'],
  820. ];
  821. Db::startTrans();
  822. try{
  823. $data['account'] = md5($data['mobile'].$data['password'].get_unique_id().time());
  824. $data['password'] = password_hash($data['password'], PASSWORD_DEFAULT);
  825. $data['create_time'] = date('Y-m-d H:i:s');
  826. $data['ip'] = request()->ip();
  827. $data['update_time'] = date('Y-m-d H:i:s');
  828. $data['last_login_time'] = date('Y-m-d H:i:s');
  829. $data['type'] = 2;
  830. $data['enable'] = 1;
  831. $data['del'] = 0;
  832. $uid = Db::name('user')->insertGetId($data);
  833. if(!$uid){
  834. \exception('操作失败');
  835. }
  836. Db::name('user_org')->insert(['user_id'=>$uid,'org_id'=>$post['orgId']]);
  837. if($post['depId'] > 0){
  838. Db::name('user_dep')->insert(['user_id'=>$uid,'dep_id'=>$post['depId']]);
  839. }
  840. $token = model('Token')->updateToken($uid);
  841. if(!$token){
  842. \exception(model('Token')->getError());
  843. }
  844. Db::commit();
  845. return ['user_id' => $uid,'token' => $token,'org_id' => $post['orgId']];
  846. }catch (Exception $e){
  847. Db::rollback();
  848. $this->error = $e->getMessage();
  849. return false;
  850. }
  851. }
  852. /**
  853. * 绿化养护获取人员
  854. *
  855. * @author wst
  856. * @date 2021/9/6 10:45
  857. */
  858. public function getGreenWorker() {
  859. $list = (new WorkTypeMode())->getRolesUser(19, cur_org_id());
  860. $arr = [];
  861. foreach ($list as $k => $v) {
  862. if (!empty($v['user'])) {
  863. foreach ($v['user'] as $k1 => $v1) {
  864. $arr[] = [
  865. 'id' => $v1['id'],
  866. 'title' => $v1['real_name'],
  867. ];
  868. }
  869. }
  870. }
  871. return $arr;
  872. }
  873. public function getYsUser($orgId,$work=0){
  874. $list = (new WorkTypeMode())->getRolesUser(3,$orgId,1);
  875. $arr = [];
  876. foreach ($list as $k=>$v){
  877. if(!empty($v['user'])){
  878. foreach ($v['user'] as $k1=>$v1){
  879. $arr[] = [
  880. 'id'=>$v1['id'],
  881. 'real_name'=>$v1['real_name'],
  882. ];
  883. }
  884. }
  885. }
  886. return $arr;
  887. }
  888. public function getWorkTypeModeUser($id,$orgId,$work=0){
  889. $list = (new WorkTypeMode())->getRolesUser($id,$orgId,$work);
  890. $arr = [];
  891. foreach ($list as $k=>$v){
  892. if(!empty($v['user'])){
  893. foreach ($v['user'] as $k1=>$v1){
  894. $arr[] = [
  895. 'id'=>$v1['id'],
  896. 'title'=>$v1['real_name'],
  897. ];
  898. }
  899. }
  900. }
  901. return $arr;
  902. }
  903. }