User.php 30 KB

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