EmployeeService.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850
  1. <?php
  2. namespace App\Service;
  3. use App\Model\Depart;
  4. use App\Model\Employee;
  5. use App\Model\EmployeeDepartPermission;
  6. use App\Model\EmployeeManagerDepart;
  7. use App\Model\EmployeeMenuPermission;
  8. use App\Model\EmployeeRole;
  9. use App\Model\EmployeeTeamPermission;
  10. use App\Model\Role;
  11. use App\Model\RoleMenu;
  12. use App\Model\RoleMenuButton;
  13. use App\Model\SysMenu;
  14. use App\Model\SysMenuButton;
  15. use App\Model\Team;
  16. use Illuminate\Support\Facades\DB;
  17. use Illuminate\Support\Facades\Hash;
  18. use Mockery\Exception;
  19. /**
  20. * 人员相关
  21. * @package App\Models
  22. */
  23. class EmployeeService extends Service
  24. {
  25. public function employeeEdit($data,$user){
  26. list($status,$msg) = $this->employeeRule($data,false);
  27. if(!$status) return [$status,$msg];
  28. try {
  29. DB::beginTransaction();
  30. $model = new Employee();
  31. $model = $model->where('id',$data['id'])->first();
  32. $model->number = $data['number'];
  33. $model->emp_name = $data['emp_name'];
  34. $model->mobile = $data['mobile'] ?? '';
  35. $model->leave_time = $data['leave_time'] ?? '';
  36. $model->entry_time = $data['entry_time'] ?? '';
  37. $model->is_admin = $data['is_admin'];
  38. if($model->is_admin == 1){
  39. $model->account = $data['number'];
  40. if($data['password'] !== '********'){
  41. $model->password = Hash::make($data['password']);
  42. }
  43. }
  44. $model->save();
  45. EmployeeDepartPermission::where('employee_id',$data['id'])->delete();
  46. if(isset($data['depart'])){
  47. $insert = [];
  48. foreach ($data['depart'] as $value){
  49. $insert[] = [
  50. 'employee_id' => $model->id,
  51. 'depart_id' => $value,
  52. ];
  53. }
  54. EmployeeDepartPermission::insert($insert);
  55. }
  56. EmployeeRole::where('employee_id',$data['id'])->update([
  57. 'del_time' => time()
  58. ]);
  59. if(isset($data['role'])){
  60. $insert = [];
  61. foreach ($data['role'] as $value){
  62. $insert[] = [
  63. 'employee_id' => $model->id,
  64. 'role_id' => $value,
  65. 'crt_time' => time(),
  66. 'upd_time' => time(),
  67. ];
  68. }
  69. EmployeeRole::insert($insert);
  70. }
  71. DB::commit();
  72. }catch (\Exception $exception){
  73. DB::rollBack();
  74. return [false, $exception->getMessage()];
  75. }
  76. return [true,''];
  77. }
  78. public function employeeAdd($data,$user){
  79. list($status,$msg) = $this->employeeRule($data);
  80. if(!$status) return [$status,$msg];
  81. try{
  82. DB::beginTransaction();
  83. $model = new Employee();
  84. $model->number = $data['number'];
  85. $model->emp_name = $data['emp_name'];
  86. $model->mobile = $data['mobile'] ?? '';
  87. $model->leave_time = $data['leave_time'] ?? '';
  88. $model->entry_time = $data['entry_time'] ?? '';
  89. $model->state = 1;
  90. $model->crt_id = $user['id'];
  91. $model->is_admin = $data['is_admin'];
  92. if($model->is_admin == 1){
  93. $model->account = $data['number'];
  94. if($data['password'] !== '********'){
  95. $model->password = Hash::make($data['password']);
  96. }
  97. }
  98. $model->save();
  99. if(isset($data['depart'])){
  100. $insert = [];
  101. foreach ($data['depart'] as $value){
  102. $insert[] = [
  103. 'employee_id' => $model->id,
  104. 'depart_id' => $value,
  105. ];
  106. }
  107. EmployeeDepartPermission::insert($insert);
  108. }
  109. if(isset($data['role'])){
  110. $insert = [];
  111. foreach ($data['role'] as $value){
  112. $insert[] = [
  113. 'employee_id' => $model->id,
  114. 'role_id' => $value,
  115. 'crt_time' => time(),
  116. 'upd_time' => time(),
  117. ];
  118. }
  119. EmployeeRole::insert($insert);
  120. }
  121. DB::commit();
  122. }catch (Exception $e){
  123. DB::rollBack();
  124. return [false, $e->getMessage()];
  125. }
  126. return [true,''];
  127. }
  128. public function employeeDel($data){
  129. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  130. Employee::where('id',$data['id'])->update([
  131. 'del_time'=>time()
  132. ]);
  133. return [true,'删除成功'];
  134. }
  135. public function employeeList($data,$user){
  136. $model = Employee::where('del_time',0)
  137. ->select('number','mobile','emp_name','id','entry_time','leave_time','is_admin','state')
  138. ->orderBy('id','desc');
  139. if(! empty($data['depart_id'])) {
  140. $depart = Depart::where('del_time',0)
  141. ->select('id','parent_id')
  142. ->get()->toArray();
  143. $result = array_merge($this->getAllDescendants($depart,$data['depart_id']),[$data['depart_id']]);
  144. $employee_id = DB::table('employee_depart_permission')
  145. ->whereIn("depart_id", $result)
  146. ->select("employee_id")
  147. ->get()->toArray();
  148. $employee_id = array_column($employee_id,'employee_id');
  149. $model->whereIn("id", $employee_id);
  150. }
  151. if(! empty($data['number'])) $model->where('number', 'LIKE', '%'.$data['number'].'%');
  152. if(! empty($data['emp_name'])) $model->where('emp_name', 'LIKE', '%'.$data['emp_name'].'%');
  153. if(! empty($data['state'])) $model->where('state',$data['state']);
  154. if(! empty($data['mobile'])) $model->where('mobile', 'LIKE', '%'.$data['mobile'].'%');
  155. if(! isset($data['all_emp'])) $model->where('id','<>',Employee::SPECIAL_ADMIN);
  156. if(! empty($data['role'])) {
  157. $emp = EmployeeRole::where('role_id',$data['role'])
  158. ->where('del_time',0)
  159. ->select('employee_id')->get()->toArray();
  160. $model->whereIn('id',array_column($emp,'employee_id'));
  161. }
  162. $list = $this->limit($model,'',$data);
  163. //组织数据
  164. $list = $this->organizationEmployeeData($list);
  165. return [true , $list];
  166. }
  167. public function organizationEmployeeData($data) {
  168. if (empty($data['data'])) return $data;
  169. $res = DB::table('employee_role as a')
  170. ->leftJoin('role as b','a.role_id','=','b.id')
  171. ->where('a.del_time',0)
  172. ->where('b.del_time',0)
  173. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  174. ->select('a.employee_id','b.title','b.id')
  175. ->get()->toArray();
  176. $role = $role2 = [];
  177. foreach ($res as $value){
  178. if(isset($role[$value->employee_id])){
  179. $role[$value->employee_id] .= ',' . $value->title;
  180. }else{
  181. $role[$value->employee_id] = $value->title;
  182. }
  183. $role2[$value->employee_id][] = $value->id;
  184. }
  185. $res = DB::table('employee_depart_permission as a')
  186. ->select('a.employee_id','b.title','b.id')
  187. ->join('depart as b','a.depart_id','=','b.id')
  188. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  189. ->orderBy('b.id')
  190. ->get()->toArray();
  191. $depart_title = $depart_id = [];
  192. foreach ($res as $value){
  193. if(isset($depart_title[$value->employee_id])){
  194. $depart_title[$value->employee_id] .= ',' . $value->title;
  195. }else{
  196. $depart_title[$value->employee_id] = $value->title;
  197. }
  198. $depart_id[$value->employee_id][] = $value->id;
  199. }
  200. foreach ($data['data'] as $key => $value){
  201. $data['data'][$key]['role'] = $role2[$value['id']] ?? [];
  202. $data['data'][$key]['role_name'] = $role[$value['id']] ?? '';
  203. $data['data'][$key]['depart'] = $depart_id[$value['id']] ?? [];
  204. $data['data'][$key]['depart_title'] = $depart_title[$value['id']] ?? '';
  205. }
  206. return $data;
  207. }
  208. public function employeeRule($data,$is_add = true){
  209. if($this->isEmpty($data,'number')) return [false,'工号不存在!'];
  210. if($this->isEmpty($data,'emp_name')) return [false,'姓名不存在!'];
  211. if(! $is_add){
  212. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  213. $bool = Employee::where('number',$data['number'])
  214. ->where('id','<>',$data['id'])
  215. ->where('del_time',0)->exists();
  216. }else{
  217. $bool = Employee::where('number',$data['number'])
  218. ->where('del_time',0)->exists();
  219. }
  220. if($bool) return [false,'工号已存在!'];
  221. return [true,''];
  222. }
  223. public function roleEdit($data){
  224. list($status,$msg) = $this->roleRule($data, false);
  225. if(!$status) return [$status,$msg];
  226. $model = new Role();
  227. $model = $model->where('id',$data['id'])->first();
  228. $model->title = $data['title'];
  229. $model->save();
  230. return [true,'保存成功!'];
  231. }
  232. public function roleAdd($data,$user){
  233. list($status,$msg) = $this->roleRule($data);
  234. if(!$status) return [$status,$msg];
  235. $model = new Role();
  236. $model->title = $data['title'] ;
  237. $model->save();
  238. return [true,'保存成功!'];
  239. }
  240. public function roleDel($data){
  241. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  242. $bool = EmployeeRole::where('del_time',0)
  243. ->whereIn('role_id',$data['id'])
  244. ->exists();
  245. if($bool) return [false,'角色已绑定人员!'];
  246. Role::where('id',$data['id'])->update([
  247. 'del_time' => time()
  248. ]);
  249. return [true,'删除成功'];
  250. }
  251. public function roleList($data){
  252. $list = Role::where('del_time',0)
  253. ->select('title','crt_time','id','upd_time')
  254. ->orderBy('id','desc');
  255. if(! empty($data['title'])) $list->where('title', 'LIKE', '%' . $data['title'] . '%');
  256. $list = $this->limit($list,'',$data);
  257. return [200,$list];
  258. }
  259. public function roleRule($data,$is_check = true){
  260. if($this->isEmpty($data,'title')) return [false,'名称不能为空!'];
  261. if($is_check){
  262. $bool = Role::where('title',$data['title'])
  263. ->where('del_time',0)
  264. ->exists();
  265. if($bool) return [false,'角色名称已存在!'];
  266. }else{
  267. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  268. $bool = Role::where('title',$data['title'])
  269. ->where('id','<>',$data['id'])
  270. ->where('del_time',0)
  271. ->exists();
  272. if($bool) return [false,'角色名称已存在!'];
  273. }
  274. return [true,''];
  275. }
  276. public function roleMenu($data){
  277. if(empty($data['role_id'])) return [false,'角色不能为空!'];
  278. if(empty($data['menu'])) return [false,'菜单数据不能为空!'];
  279. DB::beginTransaction();
  280. try {
  281. RoleMenu::where('role_id',$data['role_id'])->update(['del_time' => time()]);
  282. RoleMenuButton::where('role_id',$data['role_id'])->update(['del_time' => time()]);
  283. $insert = $insert2 = [];
  284. foreach ($data['menu'] as $t){
  285. $insert[] = [
  286. 'role_id' => $data['role_id'],
  287. 'menu_id' => $t['menu_id'],
  288. 'type' => $t['type'],
  289. 'crt_time' => time()
  290. ];
  291. if(! empty($t['button'])){
  292. foreach ($t['button'] as $b){
  293. $insert2[] = [
  294. 'role_id' => $data['role_id'],
  295. 'menu_id' => $t['menu_id'],
  296. 'button_id' => $b,
  297. 'crt_time' => time()
  298. ];
  299. }
  300. RoleMenuButton::insert($insert2);
  301. }
  302. }
  303. RoleMenu::insert($insert);
  304. DB::commit();
  305. }catch (\Throwable $exception){
  306. DB::rollBack();
  307. return [false,$exception->getMessage()];
  308. }
  309. return [true,'保存成功!'];
  310. }
  311. public function roleDetail($data){
  312. if(empty($data['role_id'])) return [false,'请选择角色'];
  313. $role = Role::where('id',$data['role_id'])
  314. ->where('del_time',0)
  315. ->select('id','code','title')
  316. ->first();
  317. if(empty($role)) return [false,'角色不存在或已被删除'];
  318. $role = $role->toArray();
  319. $menu = RoleMenu::where('role_id',$data['role_id'])
  320. ->where('del_time',0)
  321. ->select('menu_id','type')
  322. ->get()->toArray();
  323. $button = $this->fillRoleButton([$data['role_id']]);
  324. foreach ($menu as $key => $value){
  325. $menu[$key]['button'] = $button[$value['menu_id']] ?? [];
  326. }
  327. $role['menu'] = $menu;
  328. return [true, $role];
  329. }
  330. public function departEdit($data){
  331. list($status,$msg) = $this->departRule($data,false);
  332. if(!$status) return [$status,$msg];
  333. $update = $msg['data'][0];
  334. $model = new Depart();
  335. $model->where('id',$data['id'])->update($update);
  336. return [true,'保存成功!'];
  337. }
  338. public function departAdd($data,$user){
  339. list($status,$msg) = $this->departRule($data);
  340. if(!$status) return [$status,$msg];
  341. Depart::insert($msg['data']);
  342. return [true,'保存成功!'];
  343. }
  344. public function departDel($data){
  345. list($status,$msg) = $this->checkDepartDel($data);
  346. if(! $status) return [false, $msg];
  347. Depart::whereIn('id',$data['id'])->update([
  348. 'del_time'=>time()
  349. ]);
  350. return [true,'删除成功'];
  351. }
  352. public function checkDepartDel($data){
  353. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  354. $bool = Depart::whereIn('parent_id',$data['id'])->where('del_time',0)->exists();
  355. if($bool) return [false,'部门下有子部门!'];
  356. if($this->checkDepartHasPerson($data['id'])) return [false,'部门下有人员档案!'];
  357. return [true, ''];
  358. }
  359. public function departList($data,$user){
  360. $model = Depart::where('del_time',0)
  361. ->select('title','id','code','parent_id','is_main')
  362. ->orderby('code', 'asc');
  363. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  364. if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
  365. $list = $model->get()->toArray();
  366. $list_tree = $list;
  367. if(! empty($list_tree)) {
  368. $list_tree = $this->makeTree(0,$list_tree);
  369. $list_tree = $this->set_sort_circle($list_tree);
  370. }
  371. return [200,['data' => $list,'tree' => $list_tree]];
  372. }
  373. public function departRule($data, $is_check = true){
  374. if($this->isEmpty($data,'data')) return [false,'数据不能为空!'];
  375. $code = array_column($data['data'],'code');
  376. $title = array_column($data['data'],'title');
  377. $code = array_map(function($val) {
  378. return $val !== null ? $val : 0;
  379. }, $code);
  380. $title = array_map(function($val) {
  381. return $val !== null ? $val : 0;
  382. }, $title);
  383. $code_count = array_count_values($code);
  384. $title_count = array_count_values($title);
  385. foreach ($code as $value){
  386. if(empty($value)) return [false,'编码不能为空!'];
  387. if($code_count[$value] > 1) return [false,'编码不能重复'];
  388. }
  389. foreach ($title as $value){
  390. if(empty($value)) return [false,'名称不能为空!'];
  391. if($title_count[$value] > 1) return [false,'名称不能重复'];
  392. }
  393. foreach ($data['data'] as $key => $value){
  394. if(empty($value['parent_id'])) $data['data'][$key]['parent_id'] = 0;
  395. $data['data'][$key]['upd_time'] = time();
  396. if($is_check){
  397. $data['data'][$key]['crt_time'] = time();
  398. $bool = Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')")
  399. ->where('del_time',0)
  400. ->exists();
  401. }else{
  402. if($this->isEmpty($data,'id')) return [false,'id不能为空!'];
  403. $bool = Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')")
  404. ->where('id','<>',$data['id'])
  405. ->where('del_time',0)
  406. ->exists();
  407. }
  408. if($bool) return [false,'编码或部门名称不能重复'];
  409. }
  410. return [true, $data];
  411. }
  412. //检测部门下是否存在人员
  413. public function checkDepartHasPerson($depart_id = []){
  414. if(empty($depart_id)) return false;
  415. $bool = EmployeeDepartPermission::from('employee_depart_permission as a')
  416. ->leftJoin('employee as b','b.id','a.employee_id')
  417. ->where('b.del_time',0)
  418. ->whereIn('a.depart_id',$depart_id)
  419. ->exists();
  420. return $bool;
  421. }
  422. public function teamEdit($data){
  423. list($status,$msg) = $this->teamRule($data,false);
  424. if(!$status) return [$status,$msg];
  425. $model = new Team();
  426. $model = $model->where('id',$data['id'])->first();
  427. $model->title = $data['title'];
  428. $model->code = $data['code'];
  429. $model->save();
  430. return [true,'保存成功!'];
  431. }
  432. public function teamAdd($data,$user){
  433. list($status,$msg) = $this->teamRule($data);
  434. if(!$status) return [$status,$msg];
  435. $model = new Team();
  436. $model->title = $data['title'] ;
  437. $model->code = $data['code'];
  438. $model->save();
  439. return [true,'保存成功!'];
  440. }
  441. public function teamDel($data){
  442. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  443. Team::where('id',$data['id'])->update([
  444. 'del_time'=>time()
  445. ]);
  446. return [true,'删除成功'];
  447. }
  448. public function teamList($data){
  449. $list = Team::where('del_time',0)
  450. ->select('title','id','crt_time','upd_time','code')
  451. ->orderBy('id','desc');
  452. $list = $this->limit($list,'',$data);
  453. return [200,$list];
  454. }
  455. public function teamRule($data,$is_add = true){
  456. if($this->isEmpty($data,'title')) return [false,'名称不存在!'];
  457. if($this->isEmpty($data,'code')) return [false,'编码不存在'];
  458. $model = Team::where('title',$data['title'])
  459. ->where('code',$data['code'])
  460. ->where('del_time',0);
  461. if(! $is_add){
  462. if($this->isEmpty($data,'id')) return [false,'ID不能为空'];
  463. $model->where('id','<>',$data['id']);
  464. }
  465. $bool = $model->exists();
  466. if($bool) return [false,'名称和编码已存在!'];
  467. return [true,''];
  468. }
  469. public function teamDetail($data){
  470. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  471. $result = EmployeeTeamPermission::from('employee_team_permission as a')
  472. ->leftJoin('employee as b','b.id','a.employee_id')
  473. ->where('team_id',$data['id'])
  474. ->select('b.id','b.emp_name','b.number as code')
  475. ->get()->toArray();
  476. return [true,$result];
  477. }
  478. public function employeeRole($data){
  479. $role_ids = [];
  480. $employee_ids = [];
  481. foreach ($data as $v){
  482. if(isset($v['role_id'])){
  483. if(!in_array($v['role_id'],$role_ids)){
  484. $role_ids[] = $v['role_id'];
  485. }
  486. }
  487. if(isset($v['employee_id'])){
  488. if(!in_array($v['employee_id'],$employee_ids)){
  489. $employee_ids[] = $v['employee_id'];
  490. }
  491. }
  492. }
  493. EmployeeMenuPermission::wherein('role_id',$role_ids)->delete();
  494. EmployeeMenuPermission::wherein('employee_id',$employee_ids)->delete();
  495. EmployeeMenuPermission::insert($data);
  496. return [200,'保存成功!'];
  497. }
  498. public function employeeDepart($data){
  499. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  500. DB::beginTransaction();
  501. try {
  502. if($data['type'] == 1){
  503. EmployeeDepartPermission::whereIn('depart_id',$data['insert']['depart_id'])->delete();
  504. }else{
  505. EmployeeDepartPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  506. }
  507. $insert = [];
  508. foreach ($data['insert']['depart_id'] as $t){
  509. foreach ($data['insert']['employee_id'] as $e){
  510. $insert[] = [
  511. 'depart_id' => $t,
  512. 'employee_id' => $e
  513. ];
  514. }
  515. }
  516. EmployeeDepartPermission::insert($insert);
  517. DB::commit();
  518. }catch (\Throwable $exception){
  519. DB::rollBack();
  520. return [false,$exception->getMessage()];
  521. }
  522. return [true,'保存成功!'];
  523. }
  524. public function employeeTeam($data){
  525. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  526. DB::beginTransaction();
  527. try {
  528. if($data['type'] == 1){
  529. EmployeeTeamPermission::whereIn('team_id',$data['insert']['team_id'])->delete();
  530. }else{
  531. EmployeeTeamPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  532. }
  533. $insert = [];
  534. foreach ($data['insert']['team_id'] as $t){
  535. foreach ($data['insert']['employee_id'] as $e){
  536. $insert[] = [
  537. 'team_id' => $t,
  538. 'employee_id' => $e
  539. ];
  540. }
  541. }
  542. EmployeeTeamPermission::insert($insert);
  543. DB::commit();
  544. }catch (\Throwable $exception){
  545. DB::rollBack();
  546. return [false,$exception->getMessage()];
  547. }
  548. return [true,'保存成功!'];
  549. }
  550. public function loginRule($data){
  551. if($this->isEmpty($data,'account')) return [false,'账号不能为空!'];
  552. if($this->isEmpty($data,'password')) return [false,'密码不存在!'];
  553. $res = Employee::where('del_time',0)
  554. ->where('account', $data['account'])
  555. ->get()->toArray();
  556. if(empty($res)) return [false,'账号不存在或已被删除!'];
  557. $res = reset($res);
  558. if(! Hash::check($data['password'], $res['password'])) return [false,'密码错误!'];
  559. if($res['is_admin'] != Employee::IS_ADMIN) return [false,'该账号不能登录!'];
  560. if($res['state'] == Employee::NOT_USE) return [false,'账号停用!'];
  561. return [true, ['id'=>$res['id'], 'name'=>$res['emp_name'], 'account' => $res['account']]];
  562. }
  563. public static function checkUser($userId){
  564. $res = Employee::where('id', $userId)
  565. ->where('del_time',0)
  566. ->where('is_admin',Employee::IS_ADMIN)
  567. ->where('state',Employee::USE)->get()->first();
  568. if(empty($res)) return [false, '该账号无法登录,请联系管理员!'];
  569. return [true, $res];
  570. }
  571. //获取登录账号的角色
  572. public static function getPersonRole($employee_id){
  573. if(empty($employee_id)) return [];
  574. $role = EmployeeRole::where('del_time',0)
  575. ->where('employee_id',$employee_id)
  576. ->select('role_id')
  577. ->get()->toArray();
  578. //组织
  579. $role_id = array_unique(array_column($role,'role_id'));
  580. asort($role_id);
  581. $role_id = array_values($role_id);
  582. return $role_id;
  583. }
  584. //获取登录账号的角色的菜单
  585. public function getMenuByRole($role_id,$user_id){
  586. $menu = SysMenu::where('del_time',0)->select('id')->get()->toArray();
  587. $button = SysMenuButton::where('del_time',0)->select('id','menu_id')->get()->toArray();
  588. $button_map = [];
  589. foreach ($button as $value){
  590. $button_map[$value['menu_id']][] = $value['id'];
  591. }
  592. $object = [];//返回的模型
  593. if($user_id == Employee::SPECIAL_ADMIN){
  594. //超级管理员
  595. foreach ($menu as $value){
  596. $object[] = [
  597. 'type' => 0,//所有权限
  598. 'menu_id' => $value['id'],
  599. 'button' => $button_map[$value['id']] ?? [],
  600. ];
  601. }
  602. return $object;
  603. }
  604. //没绑定角色
  605. if(empty($role_id)) return [];
  606. $search = RoleMenu::whereIn('role_id',$role_id)
  607. ->where('del_time',0)
  608. ->select('menu_id','type')
  609. ->get()->toArray();
  610. $button = $this->fillRoleButton($role_id);
  611. $tmp = [];
  612. foreach ($search as $value){
  613. if(! in_array($value['menu_id'],$tmp)){
  614. $object[] = [
  615. 'menu_id' => $value['menu_id'],
  616. 'type' => $value['type'],
  617. 'button' => $button[$value['menu_id']] ?? [],
  618. ];
  619. $tmp[] = $value['menu_id'];
  620. }
  621. }
  622. unset($tmp);
  623. return $object;
  624. }
  625. //获取登录账号的权限部门 暂时不用了
  626. public static function getPersonDepart($employee_id){
  627. if(empty($employee_id)) return [];
  628. //admin账号
  629. if($employee_id == Employee::SPECIAL_ADMIN) return [Depart::RULE_DEPART];
  630. //操作人员直接绑定部门
  631. $employee_manager_depart = EmployeeManagerDepart::where('del_time',0)
  632. ->where('employee_id',$employee_id)
  633. ->select('depart_id')
  634. ->get()->toArray();
  635. //操作人员绑定角色
  636. $employee_role = EmployeeRole::from('employee_role as a')
  637. ->leftJoin('role_depart as b','b.role_id','a.role_id')
  638. ->select('b.depart_id','b.role_id')
  639. ->where('a.del_time',0)
  640. ->where('b.del_time',0)
  641. ->where('a.employee_id',$employee_id)
  642. ->get()->toArray();
  643. return array_filter(array_merge_recursive(array_column($employee_manager_depart,'depart_id'),array_column($employee_role,'depart_id')));
  644. }
  645. //人员直接绑定部门
  646. public function employeeManagerDepart($data,$user){
  647. if($user['id'] != Employee::SPECIAL_ADMIN) return [false,'非ADMIN账号不能操作'];
  648. if($this->isEmpty($data,'employee_id')) return [false,'请选择操作人员'];
  649. if($this->isEmpty($data,'depart_id')) return [false,'请选择部门'];
  650. EmployeeManagerDepart::where('employee_id',$data['employee_id'])->update([
  651. 'del_time' => time()
  652. ]);
  653. $insert = [];
  654. foreach ($data['depart_id'] as $value){
  655. $insert[] = [
  656. 'employee_id' => $data['employee_id'],
  657. 'depart_id' => $value,
  658. 'crt_time' => time(),
  659. 'upd_time' => time(),
  660. ];
  661. }
  662. EmployeeManagerDepart::insert($insert);
  663. return [true,''];
  664. }
  665. //填充角色下的按钮
  666. public function fillRoleButton($role_id){
  667. $button = RoleMenuButton::whereIn('role_id',$role_id)
  668. ->where('del_time',0)
  669. ->select('menu_id','button_id')
  670. ->get()->toArray();
  671. $button_map = [];
  672. foreach ($button as $value){
  673. if(! isset($button_map[$value['menu_id']])){
  674. $button_map[$value['menu_id']][] = $value['button_id'];
  675. }else{
  676. if(! in_array($value['button_id'], $button_map[$value['menu_id']])) $button_map[$value['menu_id']][] = $value['button_id'];
  677. }
  678. }
  679. return $button_map;
  680. }
  681. //获取登录账号的部门
  682. public static function getLoginDepart($employee_id){
  683. $is_main = 0;//是否总社
  684. if(empty($employee_id)) return ['', $is_main];
  685. //admin账号
  686. if($employee_id == Employee::SPECIAL_ADMIN) {
  687. $is_main = 1;
  688. return [Depart::RULE_DEPART, $is_main];
  689. }
  690. //自己绑定的部门 启用的部门
  691. $depart = EmployeeDepartPermission::from('employee_depart_permission as a')
  692. ->join('depart as b','b.id','a.depart_id')
  693. ->where('a.employee_id',$employee_id)
  694. ->where('b.is_use',Depart::IS_UES)
  695. ->select('a.depart_id','b.is_main')
  696. ->get()->toArray();
  697. if(! empty($depart)){
  698. foreach ($depart as $value){
  699. if($value['is_main'] > 0) {
  700. $is_main = 1;
  701. continue;
  702. }
  703. }
  704. }
  705. return [$depart, $is_main];
  706. }
  707. }