EmployeeService.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891
  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,'请选择删除的数据!'];
  130. Employee::whereIn('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'])) {
  140. $employee_id = DB::table('employee_depart_permission')
  141. ->where("depart_id", $data['depart'])
  142. ->select("employee_id")
  143. ->get()->toArray();
  144. $employee_id = array_column($employee_id,'employee_id');
  145. $model->whereIn("id", $employee_id);
  146. }
  147. if(! empty($data['number'])) $model->where('number', 'LIKE', '%'.$data['number'].'%');
  148. if(! empty($data['emp_name'])) $model->where('emp_name', 'LIKE', '%'.$data['emp_name'].'%');
  149. if(! empty($data['state'])) $model->where('state',$data['state']);
  150. if(! empty($data['mobile'])) $model->where('mobile', 'LIKE', '%'.$data['mobile'].'%');
  151. if(! isset($data['all_emp'])) $model->where('id','<>',Employee::SPECIAL_ADMIN);
  152. if(! empty($data['role'])) {
  153. $emp = EmployeeRole::where('role_id',$data['role'])
  154. ->where('del_time',0)
  155. ->select('employee_id')->get()->toArray();
  156. $model->whereIn('id',array_column($emp,'employee_id'));
  157. }
  158. $list = $this->limit($model,'',$data);
  159. //组织数据
  160. $list = $this->organizationEmployeeData($list);
  161. return [true , $list];
  162. }
  163. public function organizationEmployeeData($data) {
  164. if (empty($data['data'])) return $data;
  165. $res = DB::table('employee_role as a')
  166. ->leftJoin('role as b','a.role_id','=','b.id')
  167. ->where('a.del_time',0)
  168. ->where('b.del_time',0)
  169. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  170. ->select('a.employee_id','b.title','b.id')
  171. ->get()->toArray();
  172. $role = $role2 = [];
  173. foreach ($res as $value){
  174. if(isset($role[$value->employee_id])){
  175. $role[$value->employee_id] .= ',' . $value->title;
  176. }else{
  177. $role[$value->employee_id] = $value->title;
  178. }
  179. $role2[$value->employee_id][] = $value->id;
  180. }
  181. $res = DB::table('employee_depart_permission as a')
  182. ->select('a.employee_id','b.title','b.id')
  183. ->join('depart as b','a.depart_id','=','b.id')
  184. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  185. ->orderBy('b.id')
  186. ->get()->toArray();
  187. $depart_title = $depart_id = [];
  188. foreach ($res as $value){
  189. if(isset($depart_title[$value->employee_id])){
  190. $depart_title[$value->employee_id] .= ',' . $value->title;
  191. }else{
  192. $depart_title[$value->employee_id] = $value->title;
  193. }
  194. $depart_id[$value->employee_id][] = $value->id;
  195. }
  196. foreach ($data['data'] as $key => $value){
  197. $data['data'][$key]['role'] = $role2[$value['id']] ?? [];
  198. $data['data'][$key]['role_name'] = $role[$value['id']] ?? '';
  199. $data['data'][$key]['depart'] = $depart_id[$value['id']] ?? [];
  200. $data['data'][$key]['depart_title'] = $depart_title[$value['id']] ?? '';
  201. }
  202. return $data;
  203. }
  204. public function employeeRule($data,$is_add = true){
  205. if($this->isEmpty($data,'number')) return [false,'工号不存在!'];
  206. if($this->isEmpty($data,'emp_name')) return [false,'姓名不存在!'];
  207. if(! $is_add){
  208. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  209. $bool = Employee::where('number',$data['number'])
  210. ->where('id','<>',$data['id'])
  211. ->where('del_time',0)->exists();
  212. }else{
  213. $bool = Employee::where('number',$data['number'])
  214. ->where('del_time',0)->exists();
  215. }
  216. if($bool) return [false,'工号已存在!'];
  217. return [true,''];
  218. }
  219. public function roleEdit($data){
  220. list($status,$msg) = $this->roleRule($data, false);
  221. if(!$status) return [$status,$msg];
  222. $model = new Role();
  223. $model = $model->where('id',$data['id'])->first();
  224. $model->title = $data['title'];
  225. $model->save();
  226. return [true,'保存成功!'];
  227. }
  228. public function roleAdd($data,$user){
  229. list($status,$msg) = $this->roleRule($data);
  230. if(!$status) return [$status,$msg];
  231. $model = new Role();
  232. $model->title = $data['title'] ;
  233. $model->save();
  234. return [true,'保存成功!'];
  235. }
  236. public function roleDel($data){
  237. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  238. $bool = EmployeeRole::where('del_time',0)
  239. ->whereIn('role_id',$data['id'])
  240. ->exists();
  241. if($bool) return [false,'角色已绑定人员!'];
  242. Role::where('id',$data['id'])->update([
  243. 'del_time' => time()
  244. ]);
  245. return [true,'删除成功'];
  246. }
  247. public function roleList($data){
  248. $list = Role::where('del_time',0)
  249. ->select('title','crt_time','id','upd_time')
  250. ->orderBy('id','desc');
  251. if(! empty($data['title'])) $list->where('title', 'LIKE', '%' . $data['title'] . '%');
  252. $list = $this->limit($list,'',$data);
  253. return [200,$list];
  254. }
  255. public function roleRule($data,$is_check = true){
  256. if($this->isEmpty($data,'title')) return [false,'名称不能为空!'];
  257. if($is_check){
  258. $bool = Role::where('title',$data['title'])
  259. ->where('del_time',0)
  260. ->exists();
  261. if($bool) return [false,'角色名称已存在!'];
  262. }else{
  263. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  264. $bool = Role::where('title',$data['title'])
  265. ->where('id','<>',$data['id'])
  266. ->where('del_time',0)
  267. ->exists();
  268. if($bool) return [false,'角色名称已存在!'];
  269. }
  270. return [true,''];
  271. }
  272. public function roleMenu($data){
  273. if(empty($data['role_id'])) return [false,'角色不能为空!'];
  274. if(empty($data['menu'])) return [false,'菜单数据不能为空!'];
  275. DB::beginTransaction();
  276. try {
  277. RoleMenu::where('role_id',$data['role_id'])->update(['del_time' => time()]);
  278. RoleMenuButton::where('role_id',$data['role_id'])->update(['del_time' => time()]);
  279. $insert = $insert2 = [];
  280. foreach ($data['menu'] as $t){
  281. $insert[] = [
  282. 'role_id' => $data['role_id'],
  283. 'menu_id' => $t['menu_id'],
  284. 'type' => $t['type'],
  285. 'crt_time' => time()
  286. ];
  287. if(! empty($t['button'])){
  288. foreach ($t['button'] as $b){
  289. $insert2[] = [
  290. 'role_id' => $data['role_id'],
  291. 'menu_id' => $t['menu_id'],
  292. 'button_id' => $b,
  293. 'crt_time' => time()
  294. ];
  295. }
  296. RoleMenuButton::insert($insert2);
  297. }
  298. }
  299. RoleMenu::insert($insert);
  300. DB::commit();
  301. }catch (\Throwable $exception){
  302. DB::rollBack();
  303. return [false,$exception->getMessage()];
  304. }
  305. return [true,'保存成功!'];
  306. }
  307. public function roleDetail($data){
  308. if(empty($data['role_id'])) return [false,'请选择角色'];
  309. $role = Role::where('id',$data['role_id'])
  310. ->where('del_time',0)
  311. ->select('id','code','title')
  312. ->first();
  313. if(empty($role)) return [false,'角色不存在或已被删除'];
  314. $role = $role->toArray();
  315. $menu = RoleMenu::where('role_id',$data['role_id'])
  316. ->where('del_time',0)
  317. ->select('menu_id','type')
  318. ->get()->toArray();
  319. $button = $this->fillRoleButton([$data['role_id']]);
  320. foreach ($menu as $key => $value){
  321. $menu[$key]['button'] = $button[$value['menu_id']] ?? [];
  322. }
  323. $role['menu'] = $menu;
  324. return [true, $role];
  325. }
  326. public function departEdit($data){
  327. list($status,$msg) = $this->departRule($data,false);
  328. if(!$status) return [$status,$msg];
  329. $update = $msg['data'][0];
  330. $model = new Depart();
  331. $model->where('id',$data['id'])->update($update);
  332. return [true,'保存成功!'];
  333. }
  334. public function departAdd($data,$user){
  335. list($status,$msg) = $this->departRule($data);
  336. if(!$status) return [$status,$msg];
  337. Depart::insert($msg['data']);
  338. return [true,'保存成功!'];
  339. }
  340. public function departDel($data){
  341. list($status,$msg) = $this->checkDepartDel($data);
  342. if(! $status) return [false, $msg];
  343. Depart::whereIn('id',$data['id'])->update([
  344. 'del_time'=>time()
  345. ]);
  346. return [true,'删除成功'];
  347. }
  348. public function checkDepartDel($data){
  349. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  350. $bool = Depart::whereIn('parent_id',$data['id'])->where('del_time',0)->exists();
  351. if($bool) return [false,'部门下有子部门!'];
  352. if($this->checkDepartHasPerson($data['id'])) return [false,'部门下有人员档案!'];
  353. return [true, ''];
  354. }
  355. public function departList($data,$user){
  356. $model = Depart::where('del_time',0)
  357. ->select('title','id','code','parent_id','is_main')
  358. ->orderby('code', 'asc');
  359. if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
  360. if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%');
  361. $list = $model->get()->toArray();
  362. $list_tree = $list;
  363. if(! empty($list_tree)) {
  364. $list_tree = $this->makeTree(0,$list_tree);
  365. $list_tree = $this->set_sort_circle($list_tree);
  366. }
  367. return [200,['data' => $list,'tree' => $list_tree]];
  368. }
  369. public function departRule($data, $is_check = true){
  370. if($this->isEmpty($data,'data')) return [false,'数据不能为空!'];
  371. $code = array_column($data['data'],'code');
  372. $title = array_column($data['data'],'title');
  373. $code = array_map(function($val) {
  374. return $val !== null ? $val : 0;
  375. }, $code);
  376. $title = array_map(function($val) {
  377. return $val !== null ? $val : 0;
  378. }, $title);
  379. $code_count = array_count_values($code);
  380. $title_count = array_count_values($title);
  381. foreach ($code as $value){
  382. if(empty($value)) return [false,'编码不能为空!'];
  383. if($code_count[$value] > 1) return [false,'编码不能重复'];
  384. }
  385. foreach ($title as $value){
  386. if(empty($value)) return [false,'名称不能为空!'];
  387. if($title_count[$value] > 1) return [false,'名称不能重复'];
  388. }
  389. foreach ($data['data'] as $key => $value){
  390. if(empty($value['parent_id'])) $data['data'][$key]['parent_id'] = 0;
  391. $data['data'][$key]['upd_time'] = time();
  392. if($is_check){
  393. $data['data'][$key]['crt_time'] = time();
  394. $bool = Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')")
  395. ->where('del_time',0)
  396. ->exists();
  397. }else{
  398. if($this->isEmpty($data,'id')) return [false,'id不能为空!'];
  399. $bool = Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')")
  400. ->where('id','<>',$data['id'])
  401. ->where('del_time',0)
  402. ->exists();
  403. }
  404. if($bool) return [false,'编码或部门名称不能重复'];
  405. }
  406. return [true, $data];
  407. }
  408. //检测部门下是否存在人员
  409. public function checkDepartHasPerson($depart_id = []){
  410. if(empty($depart_id)) return false;
  411. $bool = EmployeeDepartPermission::from('employee_depart_permission as a')
  412. ->leftJoin('employee as b','b.id','a.employee_id')
  413. ->where('b.del_time',0)
  414. ->whereIn('a.depart_id',$depart_id)
  415. ->exists();
  416. return $bool;
  417. }
  418. public function teamEdit($data){
  419. list($status,$msg) = $this->teamRule($data,false);
  420. if(!$status) return [$status,$msg];
  421. $model = new Team();
  422. $model = $model->where('id',$data['id'])->first();
  423. $model->title = $data['title'];
  424. $model->code = $data['code'];
  425. $model->save();
  426. return [true,'保存成功!'];
  427. }
  428. public function teamAdd($data,$user){
  429. list($status,$msg) = $this->teamRule($data);
  430. if(!$status) return [$status,$msg];
  431. $model = new Team();
  432. $model->title = $data['title'] ;
  433. $model->code = $data['code'];
  434. $model->save();
  435. return [true,'保存成功!'];
  436. }
  437. public function teamDel($data){
  438. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  439. Team::where('id',$data['id'])->update([
  440. 'del_time'=>time()
  441. ]);
  442. return [true,'删除成功'];
  443. }
  444. public function teamList($data){
  445. $list = Team::where('del_time',0)
  446. ->select('title','id','crt_time','upd_time','code')
  447. ->orderBy('id','desc');
  448. $list = $this->limit($list,'',$data);
  449. return [200,$list];
  450. }
  451. public function teamRule($data,$is_add = true){
  452. if($this->isEmpty($data,'title')) return [false,'名称不存在!'];
  453. if($this->isEmpty($data,'code')) return [false,'编码不存在'];
  454. $model = Team::where('title',$data['title'])
  455. ->where('code',$data['code'])
  456. ->where('del_time',0);
  457. if(! $is_add){
  458. if($this->isEmpty($data,'id')) return [false,'ID不能为空'];
  459. $model->where('id','<>',$data['id']);
  460. }
  461. $bool = $model->exists();
  462. if($bool) return [false,'名称和编码已存在!'];
  463. return [true,''];
  464. }
  465. public function teamDetail($data){
  466. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  467. $result = EmployeeTeamPermission::from('employee_team_permission as a')
  468. ->leftJoin('employee as b','b.id','a.employee_id')
  469. ->where('team_id',$data['id'])
  470. ->select('b.id','b.emp_name','b.number as code')
  471. ->get()->toArray();
  472. return [true,$result];
  473. }
  474. public function employeeRole($data){
  475. $role_ids = [];
  476. $employee_ids = [];
  477. foreach ($data as $v){
  478. if(isset($v['role_id'])){
  479. if(!in_array($v['role_id'],$role_ids)){
  480. $role_ids[] = $v['role_id'];
  481. }
  482. }
  483. if(isset($v['employee_id'])){
  484. if(!in_array($v['employee_id'],$employee_ids)){
  485. $employee_ids[] = $v['employee_id'];
  486. }
  487. }
  488. }
  489. EmployeeMenuPermission::wherein('role_id',$role_ids)->delete();
  490. EmployeeMenuPermission::wherein('employee_id',$employee_ids)->delete();
  491. EmployeeMenuPermission::insert($data);
  492. return [200,'保存成功!'];
  493. }
  494. public function employeeDepart($data){
  495. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  496. DB::beginTransaction();
  497. try {
  498. if($data['type'] == 1){
  499. EmployeeDepartPermission::whereIn('depart_id',$data['insert']['depart_id'])->delete();
  500. }else{
  501. EmployeeDepartPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  502. }
  503. $insert = [];
  504. foreach ($data['insert']['depart_id'] as $t){
  505. foreach ($data['insert']['employee_id'] as $e){
  506. $insert[] = [
  507. 'depart_id' => $t,
  508. 'employee_id' => $e
  509. ];
  510. }
  511. }
  512. EmployeeDepartPermission::insert($insert);
  513. DB::commit();
  514. }catch (\Throwable $exception){
  515. DB::rollBack();
  516. return [false,$exception->getMessage()];
  517. }
  518. return [true,'保存成功!'];
  519. }
  520. public function employeeTeam($data){
  521. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  522. DB::beginTransaction();
  523. try {
  524. if($data['type'] == 1){
  525. EmployeeTeamPermission::whereIn('team_id',$data['insert']['team_id'])->delete();
  526. }else{
  527. EmployeeTeamPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  528. }
  529. $insert = [];
  530. foreach ($data['insert']['team_id'] as $t){
  531. foreach ($data['insert']['employee_id'] as $e){
  532. $insert[] = [
  533. 'team_id' => $t,
  534. 'employee_id' => $e
  535. ];
  536. }
  537. }
  538. EmployeeTeamPermission::insert($insert);
  539. DB::commit();
  540. }catch (\Throwable $exception){
  541. DB::rollBack();
  542. return [false,$exception->getMessage()];
  543. }
  544. return [true,'保存成功!'];
  545. }
  546. public function loginRule($data){
  547. if($this->isEmpty($data,'account')) return [false,'账号不能为空!'];
  548. if($this->isEmpty($data,'password')) return [false,'密码不存在!'];
  549. $res = Employee::where('del_time',0)
  550. ->where('account', $data['account'])
  551. ->get()->toArray();
  552. if(empty($res)) return [false,'账号不存在或已被删除!'];
  553. $res = reset($res);
  554. if(! Hash::check($data['password'], $res['password'])) return [false,'密码错误!'];
  555. if($res['is_admin'] != Employee::IS_ADMIN) return [false,'该账号不能登录!'];
  556. if($res['state'] == Employee::NOT_USE) return [false,'账号停用!'];
  557. return [true, ['id'=>$res['id'], 'name'=>$res['emp_name'], 'account' => $res['account']]];
  558. }
  559. public static function checkUser($userId){
  560. $res = Employee::where('id', $userId)
  561. ->where('del_time',0)
  562. ->where('is_admin',Employee::IS_ADMIN)
  563. ->where('state',Employee::USE)->get()->first();
  564. if(empty($res)) return [false, '该账号无法登录,请联系管理员!'];
  565. return [true, $res];
  566. }
  567. //获取登录账号的角色
  568. public static function getPersonRole($employee_id){
  569. if(empty($employee_id)) return [];
  570. $role = EmployeeRole::where('del_time',0)
  571. ->where('employee_id',$employee_id)
  572. ->select('role_id')
  573. ->get()->toArray();
  574. //组织
  575. $role_id = array_unique(array_column($role,'role_id'));
  576. asort($role_id);
  577. $role_id = array_values($role_id);
  578. return $role_id;
  579. }
  580. //获取登录账号的角色的菜单
  581. public function getMenuByRole($role_id,$user_id){
  582. $menu = SysMenu::where('del_time',0)->select('id')->get()->toArray();
  583. $button = SysMenuButton::where('del_time',0)->select('id','menu_id')->get()->toArray();
  584. $button_map = [];
  585. foreach ($button as $value){
  586. $button_map[$value['menu_id']][] = $value['id'];
  587. }
  588. $object = [];//返回的模型
  589. if($user_id == Employee::SPECIAL_ADMIN){
  590. //超级管理员
  591. foreach ($menu as $value){
  592. $object[] = [
  593. 'type' => 0,//所有权限
  594. 'menu_id' => $value['id'],
  595. 'button' => $button_map[$value['id']] ?? [],
  596. ];
  597. }
  598. return $object;
  599. }
  600. //没绑定角色
  601. if(empty($role_id)) return [];
  602. $search = RoleMenu::whereIn('role_id',$role_id)
  603. ->where('del_time',0)
  604. ->select('menu_id','type')
  605. ->get()->toArray();
  606. $button = $this->fillRoleButton($role_id);
  607. $tmp = [];
  608. foreach ($search as $value){
  609. if(! in_array($value['menu_id'],$tmp)){
  610. $object[] = [
  611. 'menu_id' => $value['menu_id'],
  612. 'type' => $value['type'],
  613. 'button' => $button[$value['menu_id']] ?? [],
  614. ];
  615. $tmp[] = $value['menu_id'];
  616. }
  617. }
  618. unset($tmp);
  619. return $object;
  620. }
  621. //人员直接绑定部门
  622. public function employeeManagerDepart($data,$user){
  623. if($user['id'] != Employee::SPECIAL_ADMIN) return [false,'非ADMIN账号不能操作'];
  624. if($this->isEmpty($data,'employee_id')) return [false,'请选择操作人员'];
  625. if($this->isEmpty($data,'depart_id')) return [false,'请选择部门'];
  626. EmployeeManagerDepart::where('employee_id',$data['employee_id'])->update([
  627. 'del_time' => time()
  628. ]);
  629. $insert = [];
  630. foreach ($data['depart_id'] as $value){
  631. $insert[] = [
  632. 'employee_id' => $data['employee_id'],
  633. 'depart_id' => $value,
  634. 'crt_time' => time(),
  635. 'upd_time' => time(),
  636. ];
  637. }
  638. EmployeeManagerDepart::insert($insert);
  639. return [true,''];
  640. }
  641. //填充角色下的按钮
  642. public function fillRoleButton($role_id){
  643. $button = RoleMenuButton::whereIn('role_id',$role_id)
  644. ->where('del_time',0)
  645. ->select('menu_id','button_id')
  646. ->get()->toArray();
  647. $button_map = [];
  648. foreach ($button as $value){
  649. if(! isset($button_map[$value['menu_id']])){
  650. $button_map[$value['menu_id']][] = $value['button_id'];
  651. }else{
  652. if(! in_array($value['button_id'], $button_map[$value['menu_id']])) $button_map[$value['menu_id']][] = $value['button_id'];
  653. }
  654. }
  655. return $button_map;
  656. }
  657. //获取登录账号的部门
  658. public static function getLoginDepart($employee_id){
  659. if(empty($employee_id)) return ['', '','',''];
  660. //admin账号
  661. if($employee_id == Employee::SPECIAL_ADMIN) return [Depart::RULE_DEPART, '','',''];
  662. //自己绑定的部门 启用的部门
  663. $depart = EmployeeDepartPermission::from('employee_depart_permission as a')
  664. ->join('depart as b','b.id','a.depart_id')
  665. ->where('a.employee_id',$employee_id)
  666. ->where('b.is_use',Depart::IS_UES)
  667. ->select('a.depart_id','b.is_main','b.parent_id')
  668. ->orderBy('a.depart_id','asc')
  669. ->get()->toArray();
  670. $top = $map = $rule = [];
  671. if(! empty($depart)){
  672. $list = Depart::where('del_time',0)->get()->toArray();
  673. $depart_map = array_column($list,null,'id');
  674. foreach ($depart as $value){
  675. if($value['parent_id'] == 0){//顶级
  676. $tmp['depart_id'] = $value['depart_id'];
  677. $tmp['is_main'] = $value['is_main'];
  678. $top[] = $tmp;
  679. $map[$value['depart_id']] = $value['depart_id'];
  680. }else{
  681. $t = self::getTopParentId($value['depart_id'],$list);
  682. if($t && isset($depart_map[$t])) {
  683. $tmp['depart_id'] = $depart_map[$t]['id'];
  684. $tmp['is_main'] = $depart_map[$t]['is_main'];
  685. $top[] = $tmp;
  686. $map[$value['depart_id']] = $t;
  687. }
  688. }
  689. }
  690. foreach ($depart as $value){
  691. if(in_array($value['depart_id'],$rule)) continue;
  692. if(! $value['parent_id']){ //顶级
  693. if($value['is_main']) {//是总公司
  694. //所有部门都有
  695. $rule = array_column($list,'id');
  696. }else{//不是总公司
  697. //自己以及子部门
  698. $depart_id = array_merge(self::getAllIds($list,$map[$value['depart_id']]),[$map[$value['depart_id']]]);
  699. $rule = array_merge_recursive($rule,$depart_id);
  700. }
  701. }else{//非顶级
  702. if($value['is_main']) {//是总社
  703. $top_tmp = $map[$value['depart_id']];
  704. if(! empty($depart_map[$top_tmp]['is_main'])){
  705. //顶级部门是总社
  706. //所有部门都有
  707. $rule = array_column($list,'id');
  708. }else{
  709. $depart_id = array_merge(self::getAllIds($list,$map[$value['depart_id']]),[$map[$value['depart_id']]]);
  710. $rule = array_merge_recursive($rule,$depart_id);
  711. }
  712. }else{
  713. $rule = array_merge($rule,[$value['depart_id']]);
  714. }
  715. }
  716. }
  717. }
  718. return [$depart, $top, $map, array_unique($rule)];
  719. }
  720. public static function getTopParentId($id, $data) {
  721. foreach ($data as $item) {
  722. if ($item['id'] == $id) {
  723. if ($item['parent_id'] == 0) {
  724. // 找到最顶级的id
  725. return $item['id'];
  726. } else {
  727. // 继续递归查找父级
  728. return self::getTopParentId($item['parent_id'], $data);
  729. }
  730. }
  731. }
  732. // 如果没有找到匹配的id,则返回null或者其他你希望的默认值
  733. return 0;
  734. }
  735. public static function getAllIds($data, $id) {
  736. $result = array(); // 存储结果的数组
  737. foreach ($data as $node) {
  738. if ($node['parent_id'] == $id) { // 如果当前节点的父 ID 等于指定 ID,则将该节点添加到结果中
  739. $result[] = $node['id'];
  740. // 递归查询该节点的所有子孙节点,并将结果合并到结果数组中
  741. $result = array_merge($result, self::getAllIds($data, $node['id']));
  742. }
  743. }
  744. return $result;
  745. }
  746. }