EmployeeService.php 27 KB

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