EmployeeService.php 29 KB

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