EmployeeService.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419
  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\SysMenu;
  12. use App\Model\Team;
  13. use Illuminate\Support\Facades\DB;
  14. use Illuminate\Support\Facades\Hash;
  15. /**
  16. * 人员相关
  17. * @package App\Models
  18. */
  19. class EmployeeService extends Service
  20. {
  21. public function employeeEdit($data,$user){
  22. list($status,$msg) = $this->employeeRule($data,false);
  23. if(!$status) return [$status,$msg];
  24. $model = new Employee();
  25. $model = $model->where('id',$data['id'])->first();
  26. $model->id_card = $data['id_card']??'';
  27. $model->number = $data['number'] ;
  28. $model->mobile = $data['mobile'];
  29. $model->emp_name = $data['emp_name'];
  30. $model->is_admin = $data['is_admin'];
  31. if($model->is_admin == 1){
  32. $model->account = $data['account'];
  33. if($data['password'] !== '********'){
  34. $model->password = Hash::make($data['password']);
  35. }
  36. }
  37. $model->save();
  38. return [true,'保存成功!'];
  39. }
  40. public function employeeAdd($data,$user){
  41. list($status,$msg) = $this->employeeRule($data);
  42. if(!$status) return [$status,$msg];
  43. $model = new Employee();
  44. $model->id_card = $data['id_card']??'';
  45. $model->number = $data['number'] ;
  46. $model->mobile = $data['mobile'];
  47. $model->emp_name = $data['emp_name'];
  48. $model->state = 1;
  49. $model->crt_id = $user['id'];
  50. $model->is_admin = $data['is_admin'];
  51. if($model->is_admin == 1){
  52. $model->account = $data['account'];
  53. $model->password = Hash::make($data['password']);
  54. }
  55. $model->save();
  56. return [true,'保存成功!'];
  57. }
  58. public function employeeDel($data){
  59. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  60. Employee::where('id',$data['id'])->update([
  61. 'del_time'=>time()
  62. ]);
  63. return [true,'删除成功'];
  64. }
  65. public function employeeList($data,$user){
  66. $model = Employee::where('del_time',0)
  67. ->where('id','<>',Employee::SPECIAL_ADMIN)
  68. ->select('account','upd_time','id','mark','crt_time','emp_name')
  69. ->orderBy('id','desc');
  70. if(! empty($data['account'])) $model->where('account', 'LIKE', '%'.$data['account'].'%');
  71. if(! empty($data['mark'])) $model->where('mark', 'LIKE', '%'.$data['mark'].'%');
  72. if(! empty($data['role'])) {
  73. $emp = EmployeeRole::where('role_id',$data['role'])
  74. ->select('employee_id')->get()->toArray();
  75. $model->whereIn('id',array_column($emp,'employee_id'));
  76. }
  77. $list = $this->limit($model,'',$data);
  78. //组织数据
  79. $list = $this->organizationEmployeeData($list);
  80. return [true, $list];
  81. }
  82. public function organizationEmployeeData($data) {
  83. if (empty($data['data'])) return $data;
  84. $res = DB::table('employee_role as a')
  85. ->leftJoin('role as b','a.role_id','=','b.id')
  86. ->where('a.del_time',0)
  87. ->where('b.del_time',0)
  88. ->whereIn("a.employee_id",array_column($data['data'],'id'))
  89. ->select('a.employee_id','b.title','b.id')
  90. ->get()->toArray();
  91. $role = $role2 = [];
  92. foreach ($res as $value){
  93. if(isset($role[$value->employee_id])){
  94. $role[$value->employee_id] .= ',' . $value->title;
  95. }else{
  96. $role[$value->employee_id] = $value->title;
  97. }
  98. $role2[$value->employee_id][] = $value->id;
  99. }
  100. foreach ($data['data'] as $key => $value){
  101. $data['data'][$key]['role'] = $role2[$value['id']] ?? [];
  102. $data['data'][$key]['role_name'] = $role[$value['id']] ?? '';
  103. $data['data'][$key]['crt_time'] = $value['crt_time'] ? date('Y-m-d',$value['crt_time']) : '';
  104. }
  105. return $data;
  106. }
  107. public function employeeRule($data,$is_add = true){
  108. if($this->isEmpty($data,'number')) return [false,'工号不存在!'];
  109. if($this->isEmpty($data,'mobile')) return [false,'手机号不存在!'];
  110. if($this->isEmpty($data,'emp_name')) return [false,'姓名不存在!'];
  111. if(! $is_add){
  112. if($this->isEmpty($data,'id')) return [false,'ID不能为空!'];
  113. $bool = Employee::where('number',$data['number'])
  114. ->where('id','<>',$data['id'])
  115. ->where('del_time',0)->exists();
  116. $bool_account = Employee::where('account',$data['account'])
  117. ->where('id','<>',$data['id'])
  118. ->where('del_time',0)->exists();
  119. }else{
  120. $bool = Employee::where('number',$data['number'])
  121. ->where('del_time',0)->exists();
  122. $bool_account = Employee::where('account',$data['account'])
  123. ->where('del_time',0)->exists();
  124. }
  125. if($bool) return [false,'工号已存在!'];
  126. if($bool_account) return [false,'账号已存在!'];
  127. return [true,''];
  128. }
  129. public function roleEdit($data){
  130. list($status,$msg) = $this->roleRule($data);
  131. if(!$status) return [$status,$msg];
  132. $first = Role::where('title',$data['title'])->where('id','<>',$data['id'])->where('del_time',0)->first();
  133. if(!empty($first))return [false,'名称已存在!'];
  134. $model = new Role();
  135. $model = $model->where('id',$data['id'])->first();
  136. $model->title = $data['title'];
  137. $model->save();
  138. return [true,'保存成功!'];
  139. }
  140. public function roleAdd($data,$user){
  141. // if($this->isEmpty($data,'title')) return [201,'名称不存在!'];
  142. list($status,$msg) = $this->roleRule($data);
  143. if(!$status) return [$status,$msg];
  144. $first = SysMenu::where('title',$data['title'])->where('del_time',0)->first();
  145. if(!empty($first))return [false,'名称已存在!'];
  146. $model = new Role();
  147. $model->title = $data['title'] ;
  148. $model->save();
  149. return [true,'保存成功!'];
  150. }
  151. public function roleDel($data){
  152. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  153. Role::where('id',$data['id'])->update([
  154. 'del_time'=>time()
  155. ]);
  156. return [true,'删除成功'];
  157. }
  158. public function roleList($data){
  159. $list = Role::where('del_time',0)->select('title','title','crt_time','id','upd_time')->orderBy('id','desc');
  160. $list = $this->limit($list,'',$data);
  161. return [200,$list];
  162. }
  163. public function roleRule($data){
  164. if($this->isEmpty($data,'title')) return [false,'名称不存在!'];
  165. return [true,''];
  166. }
  167. public function departEdit($data){
  168. list($status,$msg) = $this->departRule($data);
  169. if(!$status) return [$status,$msg];
  170. $first = Depart::where('title',$data['title'])->where('id','<>',$data['id'])->where('del_time',0)->first();
  171. if(!empty($first))return [false,'名称已存在!'];
  172. $model = new Depart();
  173. $model = $model->where('id',$data['id'])->first();
  174. $model->title = $data['title'];
  175. $model->code = $data['code']??'';
  176. $model->save();
  177. return [true,'保存成功!'];
  178. }
  179. public function departAdd($data,$user){
  180. // if($this->isEmpty($data,'title')) return [201,'名称不存在!'];
  181. list($status,$msg) = $this->departRule($data);
  182. if(!$status) return [$status,$msg];
  183. $first = Depart::where('title',$data['title'])->where('id','<>',$data['id'])->where('del_time',0)->first();
  184. if(!empty($first))return [false,'名称已存在!'];
  185. $model = new Depart();
  186. $model->title = $data['title'] ;
  187. $model->code = $data['code'] ?? '' ;
  188. $model->save();
  189. return [true,'保存成功!'];
  190. }
  191. public function departDel($data){
  192. if($this->isEmpty($data,'id')) return [false,'ID必须!'];
  193. Depart::where('id',$data['id'])->update([
  194. 'del_time'=>time()
  195. ]);
  196. return [true,'删除成功'];
  197. }
  198. public function departList($data){
  199. $list = Depart::where('del_time',0)->select('title','crt_time','id','upd_time','code')->orderBy('id','desc');
  200. $list = $this->limit($list,'',$data);
  201. return [200,$list];
  202. }
  203. public function departRule($data){
  204. if($this->isEmpty($data,'title')) return [false,'名称不存在!'];
  205. return [true,''];
  206. }
  207. public function employeeRole($data){
  208. $role_ids = [];
  209. $employee_ids = [];
  210. foreach ($data as $v){
  211. if(isset($v['role_id'])){
  212. if(!in_array($v['role_id'],$role_ids)){
  213. $role_ids[] = $v['role_id'];
  214. }
  215. }
  216. if(isset($v['employee_id'])){
  217. if(!in_array($v['employee_id'],$employee_ids)){
  218. $employee_ids[] = $v['employee_id'];
  219. }
  220. }
  221. }
  222. EmployeeMenuPermission::wherein('role_id',$role_ids)->delete();
  223. EmployeeMenuPermission::wherein('employee_id',$employee_ids)->delete();
  224. EmployeeMenuPermission::insert($data);
  225. return [200,'保存成功!'];
  226. }
  227. public function employeeDepart($data){
  228. if($this->isEmpty($data,'insert')) return [false,'数据不能为空!'];
  229. DB::beginTransaction();
  230. try {
  231. if($data['type'] == 1){
  232. EmployeeDepartPermission::whereIn('depart_id',$data['insert']['depart_id'])->delete();
  233. }else{
  234. EmployeeDepartPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete();
  235. }
  236. $insert = [];
  237. foreach ($data['insert']['depart_id'] as $t){
  238. foreach ($data['insert']['employee_id'] as $e){
  239. $insert[] = [
  240. 'depart_id' => $t,
  241. 'employee_id' => $e
  242. ];
  243. }
  244. }
  245. EmployeeDepartPermission::insert($insert);
  246. DB::commit();
  247. }catch (\Throwable $exception){
  248. DB::rollBack();
  249. return [false,$exception->getMessage()];
  250. }
  251. return [true,'保存成功!'];
  252. }
  253. public function loginRule($data){
  254. if($this->isEmpty($data,'account')) return [false,'账号不能为空!'];
  255. if($this->isEmpty($data,'password')) return [false,'密码不存在!'];
  256. $res = Employee::where('del_time',0)
  257. ->where('account', $data['account'])
  258. ->get()->toArray();
  259. if(empty($res)) return [false,'账号不存在或已被删除!'];
  260. $res = reset($res);
  261. if(! Hash::check($data['password'], $res['password'])) return [false,'密码错误!'];
  262. if($res['is_admin'] != Employee::IS_ADMIN) return [false,'该账号不能登录!'];
  263. if($res['state'] == Employee::NOT_USE) return [false,'账号停用!'];
  264. return [true, ['id'=>$res['id'], 'name'=>$res['emp_name'], 'account' => $res['account']]];
  265. }
  266. public static function checkUser($userId){
  267. $res = Employee::where('id', $userId)
  268. ->where('del_time',0)
  269. ->where('is_admin',Employee::IS_ADMIN)
  270. ->where('state',Employee::USE)->get()->first();
  271. if(empty($res)) return [false, '该账号无法登录,请联系管理员!'];
  272. return [true, $res];
  273. }
  274. //获取登录账号的角色
  275. public static function getPersonRole($employee_id){
  276. if(empty($employee_id)) return [];
  277. $role = EmployeeRole::where('del_time',0)
  278. ->where('employee_id',$employee_id)
  279. ->select('role_id')
  280. ->get()->toArray();
  281. //组织
  282. $role_id = array_column($role,'role_id');
  283. asort($role_id);
  284. $role_id = array_values($role_id);
  285. return $role_id;
  286. }
  287. //获取登录账号的权限部门
  288. public static function getPersonDepart($employee_id){
  289. if(empty($employee_id)) return [];
  290. //admin账号
  291. if($employee_id == Employee::SPECIAL_ADMIN) return [Depart::RULE_DEPART];
  292. //操作人员直接绑定部门
  293. $employee_manager_depart = EmployeeManagerDepart::where('del_time',0)
  294. ->where('employee_id',$employee_id)
  295. ->select('depart_id')
  296. ->get()->toArray();
  297. //操作人员绑定角色
  298. $employee_role = EmployeeRole::from('employee_role as a')
  299. ->leftJoin('role_depart as b','b.role_id','a.role_id')
  300. ->select('b.depart_id','b.role_id')
  301. ->where('a.del_time',0)
  302. ->where('b.del_time',0)
  303. ->where('a.employee_id',$employee_id)
  304. ->get()->toArray();
  305. return array_filter(array_merge_recursive(array_column($employee_manager_depart,'depart_id'),array_column($employee_role,'depart_id')));
  306. }
  307. //人员直接绑定部门
  308. public function employeeManagerDepart($data,$user){
  309. if($user['id'] != Employee::SPECIAL_ADMIN) return [false,'非ADMIN账号不能操作'];
  310. if($this->isEmpty($data,'employee_id')) return [false,'请选择操作人员'];
  311. if($this->isEmpty($data,'depart_id')) return [false,'请选择部门'];
  312. EmployeeManagerDepart::where('employee_id',$data['employee_id'])->update([
  313. 'del_time' => time()
  314. ]);
  315. $insert = [];
  316. foreach ($data['depart_id'] as $value){
  317. $insert[] = [
  318. 'employee_id' => $data['employee_id'],
  319. 'depart_id' => $value,
  320. 'crt_time' => time(),
  321. 'upd_time' => time(),
  322. ];
  323. }
  324. EmployeeManagerDepart::insert($insert);
  325. return [true,''];
  326. }
  327. }