EmployeeService.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892
  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. //Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')")
  393. if($is_check){
  394. $data['data'][$key]['crt_time'] = time();
  395. $bool = Depart::whereRaw("binary code = '{$value['code']}'")
  396. ->where('del_time',0)
  397. ->exists();
  398. }else{
  399. if($this->isEmpty($data,'id')) return [false,'id不能为空!'];
  400. $bool = Depart::whereRaw("binary code = '{$value['code']}'")
  401. ->where('id','<>',$data['id'])
  402. ->where('del_time',0)
  403. ->exists();
  404. }
  405. if($bool) return [false,'编码不能重复'];
  406. }
  407. return [true, $data];
  408. }
  409. //检测部门下是否存在人员
  410. public function checkDepartHasPerson($depart_id = []){
  411. if(empty($depart_id)) return false;
  412. $bool = EmployeeDepartPermission::from('employee_depart_permission as a')
  413. ->leftJoin('employee as b','b.id','a.employee_id')
  414. ->where('b.del_time',0)
  415. ->whereIn('a.depart_id',$depart_id)
  416. ->exists();
  417. return $bool;
  418. }
  419. public function teamEdit($data){
  420. list($status,$msg) = $this->teamRule($data,false);
  421. if(!$status) return [$status,$msg];
  422. $model = new Team();
  423. $model = $model->where('id',$data['id'])->first();
  424. $model->title = $data['title'];
  425. $model->code = $data['code'];
  426. $model->save();
  427. return [true,'保存成功!'];
  428. }
  429. public function teamAdd($data,$user){
  430. list($status,$msg) = $this->teamRule($data);
  431. if(!$status) return [$status,$msg];
  432. $model = new Team();
  433. $model->title = $data['title'] ;
  434. $model->code = $data['code'];
  435. $model->save();
  436. return [true,'保存成功!'];
  437. }
  438. public function teamDel($data){
  439. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  440. Team::where('id',$data['id'])->update([
  441. 'del_time'=>time()
  442. ]);
  443. return [true,'删除成功'];
  444. }
  445. public function teamList($data){
  446. $list = Team::where('del_time',0)
  447. ->select('title','id','crt_time','upd_time','code')
  448. ->orderBy('id','desc');
  449. $list = $this->limit($list,'',$data);
  450. return [200,$list];
  451. }
  452. public function teamRule($data,$is_add = true){
  453. if($this->isEmpty($data,'title')) return [false,'名称不存在!'];
  454. if($this->isEmpty($data,'code')) return [false,'编码不存在'];
  455. $model = Team::where('title',$data['title'])
  456. ->where('code',$data['code'])
  457. ->where('del_time',0);
  458. if(! $is_add){
  459. if($this->isEmpty($data,'id')) return [false,'ID不能为空'];
  460. $model->where('id','<>',$data['id']);
  461. }
  462. $bool = $model->exists();
  463. if($bool) return [false,'名称和编码已存在!'];
  464. return [true,''];
  465. }
  466. public function teamDetail($data){
  467. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  468. $result = EmployeeTeamPermission::from('employee_team_permission as a')
  469. ->leftJoin('employee as b','b.id','a.employee_id')
  470. ->where('team_id',$data['id'])
  471. ->select('b.id','b.emp_name','b.number as code')
  472. ->get()->toArray();
  473. return [true,$result];
  474. }
  475. public function employeeRole($data){
  476. $role_ids = [];
  477. $employee_ids = [];
  478. foreach ($data as $v){
  479. if(isset($v['role_id'])){
  480. if(!in_array($v['role_id'],$role_ids)){
  481. $role_ids[] = $v['role_id'];
  482. }
  483. }
  484. if(isset($v['employee_id'])){
  485. if(!in_array($v['employee_id'],$employee_ids)){
  486. $employee_ids[] = $v['employee_id'];
  487. }
  488. }
  489. }
  490. EmployeeMenuPermission::wherein('role_id',$role_ids)->delete();
  491. EmployeeMenuPermission::wherein('employee_id',$employee_ids)->delete();
  492. EmployeeMenuPermission::insert($data);
  493. return [200,'保存成功!'];
  494. }
  495. public function employeeDepart($data){
  496. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  497. DB::beginTransaction();
  498. try {
  499. if($data['type'] == 1){
  500. EmployeeDepartPermission::whereIn('depart_id',$data['insert']['depart_id'])->delete();
  501. }else{
  502. EmployeeDepartPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  503. }
  504. $insert = [];
  505. foreach ($data['insert']['depart_id'] as $t){
  506. foreach ($data['insert']['employee_id'] as $e){
  507. $insert[] = [
  508. 'depart_id' => $t,
  509. 'employee_id' => $e
  510. ];
  511. }
  512. }
  513. EmployeeDepartPermission::insert($insert);
  514. DB::commit();
  515. }catch (\Throwable $exception){
  516. DB::rollBack();
  517. return [false,$exception->getMessage()];
  518. }
  519. return [true,'保存成功!'];
  520. }
  521. public function employeeTeam($data){
  522. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  523. DB::beginTransaction();
  524. try {
  525. if($data['type'] == 1){
  526. EmployeeTeamPermission::whereIn('team_id',$data['insert']['team_id'])->delete();
  527. }else{
  528. EmployeeTeamPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  529. }
  530. $insert = [];
  531. foreach ($data['insert']['team_id'] as $t){
  532. foreach ($data['insert']['employee_id'] as $e){
  533. $insert[] = [
  534. 'team_id' => $t,
  535. 'employee_id' => $e
  536. ];
  537. }
  538. }
  539. EmployeeTeamPermission::insert($insert);
  540. DB::commit();
  541. }catch (\Throwable $exception){
  542. DB::rollBack();
  543. return [false,$exception->getMessage()];
  544. }
  545. return [true,'保存成功!'];
  546. }
  547. public function loginRule($data){
  548. if($this->isEmpty($data,'account')) return [false,'账号不能为空!'];
  549. if($this->isEmpty($data,'password')) return [false,'密码不存在!'];
  550. $res = Employee::where('del_time',0)
  551. ->where('account', $data['account'])
  552. ->get()->toArray();
  553. if(empty($res)) return [false,'账号不存在或已被删除!'];
  554. $res = reset($res);
  555. if(! Hash::check($data['password'], $res['password'])) return [false,'密码错误!'];
  556. if($res['is_admin'] != Employee::IS_ADMIN) return [false,'该账号不能登录!'];
  557. if($res['state'] == Employee::NOT_USE) return [false,'账号停用!'];
  558. return [true, ['id'=>$res['id'], 'name'=>$res['emp_name'], 'account' => $res['account']]];
  559. }
  560. public static function checkUser($userId){
  561. $res = Employee::where('id', $userId)
  562. ->where('del_time',0)
  563. ->where('is_admin',Employee::IS_ADMIN)
  564. ->where('state',Employee::USE)->get()->first();
  565. if(empty($res)) return [false, '该账号无法登录,请联系管理员!'];
  566. return [true, $res];
  567. }
  568. //获取登录账号的角色
  569. public static function getPersonRole($employee_id){
  570. if(empty($employee_id)) return [];
  571. $role = EmployeeRole::where('del_time',0)
  572. ->where('employee_id',$employee_id)
  573. ->select('role_id')
  574. ->get()->toArray();
  575. //组织
  576. $role_id = array_unique(array_column($role,'role_id'));
  577. asort($role_id);
  578. $role_id = array_values($role_id);
  579. return $role_id;
  580. }
  581. //获取登录账号的角色的菜单
  582. public function getMenuByRole($role_id,$user_id){
  583. $menu = SysMenu::where('del_time',0)->select('id')->get()->toArray();
  584. $button = SysMenuButton::where('del_time',0)->select('id','menu_id')->get()->toArray();
  585. $button_map = [];
  586. foreach ($button as $value){
  587. $button_map[$value['menu_id']][] = $value['id'];
  588. }
  589. $object = [];//返回的模型
  590. if($user_id == Employee::SPECIAL_ADMIN){
  591. //超级管理员
  592. foreach ($menu as $value){
  593. $object[] = [
  594. 'type' => 0,//所有权限
  595. 'menu_id' => $value['id'],
  596. 'button' => $button_map[$value['id']] ?? [],
  597. ];
  598. }
  599. return $object;
  600. }
  601. //没绑定角色
  602. if(empty($role_id)) return [];
  603. $search = RoleMenu::whereIn('role_id',$role_id)
  604. ->where('del_time',0)
  605. ->select('menu_id','type')
  606. ->get()->toArray();
  607. $button = $this->fillRoleButton($role_id);
  608. $tmp = [];
  609. foreach ($search as $value){
  610. if(! in_array($value['menu_id'],$tmp)){
  611. $object[] = [
  612. 'menu_id' => $value['menu_id'],
  613. 'type' => $value['type'],
  614. 'button' => $button[$value['menu_id']] ?? [],
  615. ];
  616. $tmp[] = $value['menu_id'];
  617. }
  618. }
  619. unset($tmp);
  620. return $object;
  621. }
  622. //人员直接绑定部门
  623. public function employeeManagerDepart($data,$user){
  624. if($user['id'] != Employee::SPECIAL_ADMIN) return [false,'非ADMIN账号不能操作'];
  625. if($this->isEmpty($data,'employee_id')) return [false,'请选择操作人员'];
  626. if($this->isEmpty($data,'depart_id')) return [false,'请选择部门'];
  627. EmployeeManagerDepart::where('employee_id',$data['employee_id'])->update([
  628. 'del_time' => time()
  629. ]);
  630. $insert = [];
  631. foreach ($data['depart_id'] as $value){
  632. $insert[] = [
  633. 'employee_id' => $data['employee_id'],
  634. 'depart_id' => $value,
  635. 'crt_time' => time(),
  636. 'upd_time' => time(),
  637. ];
  638. }
  639. EmployeeManagerDepart::insert($insert);
  640. return [true,''];
  641. }
  642. //填充角色下的按钮
  643. public function fillRoleButton($role_id){
  644. $button = RoleMenuButton::whereIn('role_id',$role_id)
  645. ->where('del_time',0)
  646. ->select('menu_id','button_id')
  647. ->get()->toArray();
  648. $button_map = [];
  649. foreach ($button as $value){
  650. if(! isset($button_map[$value['menu_id']])){
  651. $button_map[$value['menu_id']][] = $value['button_id'];
  652. }else{
  653. if(! in_array($value['button_id'], $button_map[$value['menu_id']])) $button_map[$value['menu_id']][] = $value['button_id'];
  654. }
  655. }
  656. return $button_map;
  657. }
  658. //获取登录账号的部门
  659. public static function getLoginDepart($employee_id){
  660. if(empty($employee_id)) return ['', '','',''];
  661. //admin账号
  662. if($employee_id == Employee::SPECIAL_ADMIN) return [Depart::RULE_DEPART, '','',''];
  663. //自己绑定的部门 启用的部门
  664. $depart = EmployeeDepartPermission::from('employee_depart_permission as a')
  665. ->join('depart as b','b.id','a.depart_id')
  666. ->where('a.employee_id',$employee_id)
  667. ->where('b.is_use',Depart::IS_UES)
  668. ->select('a.depart_id','b.is_main','b.parent_id')
  669. ->orderBy('a.depart_id','asc')
  670. ->get()->toArray();
  671. $top = $map = $rule = [];
  672. if(! empty($depart)){
  673. $list = Depart::where('del_time',0)->get()->toArray();
  674. $depart_map = array_column($list,null,'id');
  675. foreach ($depart as $value){
  676. if($value['parent_id'] == 0){//顶级
  677. $tmp['depart_id'] = $value['depart_id'];
  678. $tmp['is_main'] = $value['is_main'];
  679. $top[] = $tmp;
  680. $map[$value['depart_id']] = $value['depart_id'];
  681. }else{
  682. $t = self::getTopParentId($value['depart_id'],$list);
  683. if($t && isset($depart_map[$t])) {
  684. $tmp['depart_id'] = $depart_map[$t]['id'];
  685. $tmp['is_main'] = $depart_map[$t]['is_main'];
  686. $top[] = $tmp;
  687. $map[$value['depart_id']] = $t;
  688. }
  689. }
  690. }
  691. foreach ($depart as $value){
  692. if(in_array($value['depart_id'],$rule)) continue;
  693. if(! $value['parent_id']){ //顶级
  694. if($value['is_main']) {//是总公司
  695. //所有部门都有
  696. $rule = array_column($list,'id');
  697. }else{//不是总公司
  698. //自己以及子部门
  699. $depart_id = array_merge(self::getAllIds($list,$map[$value['depart_id']]),[$map[$value['depart_id']]]);
  700. $rule = array_merge_recursive($rule,$depart_id);
  701. }
  702. }else{//非顶级
  703. if($value['is_main']) {//是总社
  704. $top_tmp = $map[$value['depart_id']];
  705. if(! empty($depart_map[$top_tmp]['is_main'])){
  706. //顶级公司是总公司 所有部门都有
  707. $rule = array_column($list,'id');
  708. }else{
  709. //顶级公司是分公司 分公司所有部门
  710. $depart_id = array_merge(self::getAllIds($list,$top_tmp),[$top_tmp]);
  711. $rule = array_merge_recursive($rule,$depart_id);
  712. }
  713. }else{//不是总社
  714. $rule = array_merge($rule,[$value['depart_id']]);
  715. }
  716. }
  717. }
  718. }
  719. return [$depart, $top, $map, array_unique($rule)];
  720. }
  721. public static function getTopParentId($id, $data) {
  722. foreach ($data as $item) {
  723. if ($item['id'] == $id) {
  724. if ($item['parent_id'] == 0) {
  725. // 找到最顶级的id
  726. return $item['id'];
  727. } else {
  728. // 继续递归查找父级
  729. return self::getTopParentId($item['parent_id'], $data);
  730. }
  731. }
  732. }
  733. // 如果没有找到匹配的id,则返回null或者其他你希望的默认值
  734. return 0;
  735. }
  736. public static function getAllIds($data, $id) {
  737. $result = array(); // 存储结果的数组
  738. foreach ($data as $node) {
  739. if ($node['parent_id'] == $id) { // 如果当前节点的父 ID 等于指定 ID,则将该节点添加到结果中
  740. $result[] = $node['id'];
  741. // 递归查询该节点的所有子孙节点,并将结果合并到结果数组中
  742. $result = array_merge($result, self::getAllIds($data, $node['id']));
  743. }
  744. }
  745. return $result;
  746. }
  747. }