employeeOtherRule($data,$user); if(!$status) return [$status,$msg]; try { DB::beginTransaction(); $model = new Employee(); $model = $model->where('id',$user['id'])->first(); $model->password = Hash::make($data['new_password']); $model->save(); DB::commit(); }catch (\Exception $exception){ DB::rollBack(); return [false, $exception->getMessage()]; } return [true,'']; } public function employeeOtherRule($data,$user){ if(! isset($data['old_password'])) return [false,'请输入原密码']; if($data['old_password'] == "") return [false,'原密码不能为空']; if(! isset($data['new_password'])) return [false,'请输入新密码']; if($data['new_password'] == "") return [false,'新密码不能为空']; if(! isset($data['re_password'])) return [false,'请输入确认密码']; if($data['re_password'] == "") return [false,'确认密码不能为空']; if(! Hash::check($data['old_password'], $user['password'])) return [false,'原密码错误']; if($data['new_password'] == $data['old_password']) return [false,'原密码与新密码一致']; if($data['new_password'] !== $data['re_password']) return [false,'新密码与确认密码不一致']; return [true,'']; } /** * 用户编辑 * @param $data * @param $user * @return array */ public function employeeEdit($data,$user){ list($status,$msg) = $this->employeeRule($data,false); if(!$status) return [$status,$msg]; try { DB::beginTransaction(); $model = new Employee(); $model = $model->where('id',$data['id'])->first(); $model->number = $data['number']; $model->emp_name = $data['emp_name']; $model->mobile = $data['mobile'] ?? ''; $model->leave_time = $data['leave_time'] ?? ''; $model->entry_time = $data['entry_time'] ?? ''; $model->state = empty($data['leave_time']) ? Employee::USE : Employee::NOT_USE; $model->is_admin = $data['is_admin']; $model->account = $data['number']; if($model->is_admin == 1){ if($data['password'] !== '******'){ $model->password = Hash::make($data['password']); } } $model->save(); EmployeeDepartPermission::where('employee_id',$data['id'])->delete(); if(isset($data['depart'])){ $insert = []; foreach ($data['depart'] as $value){ $insert[] = [ 'employee_id' => $model->id, 'depart_id' => $value, ]; } EmployeeDepartPermission::insert($insert); } EmployeeRole::where('employee_id',$data['id'])->update([ 'del_time' => time() ]); if(isset($data['role'])){ $insert = []; foreach ($data['role'] as $value){ $insert[] = [ 'employee_id' => $model->id, 'role_id' => $value, 'crt_time' => time(), 'upd_time' => time(), ]; } EmployeeRole::insert($insert); } DB::commit(); }catch (\Exception $exception){ DB::rollBack(); return [false, $exception->getMessage()]; } return [true,'']; } /** * 用户新增 * @param $data * @param $user * @return array */ public function employeeAdd($data,$user){ list($status,$msg) = $this->employeeRule($data); if(!$status) return [$status,$msg]; try{ DB::beginTransaction(); $model = new Employee(); $model->number = $data['number']; $model->emp_name = $data['emp_name']; $model->mobile = $data['mobile'] ?? ''; $model->leave_time = $data['leave_time'] ?? ''; $model->entry_time = $data['entry_time'] ?? ''; $model->state = empty($data['leave_time']) ? Employee::USE : Employee::NOT_USE; $model->crt_id = $user['id']; $model->is_admin = $data['is_admin']; $model->account = $data['number']; if($model->is_admin == 1){ if($data['password'] !== '********'){ $model->password = Hash::make($data['password']); } } $model->save(); if(isset($data['depart'])){ $insert = []; foreach ($data['depart'] as $value){ $insert[] = [ 'employee_id' => $model->id, 'depart_id' => $value, ]; } EmployeeDepartPermission::insert($insert); } if(isset($data['role'])){ $insert = []; foreach ($data['role'] as $value){ $insert[] = [ 'employee_id' => $model->id, 'role_id' => $value, 'crt_time' => time(), 'upd_time' => time(), ]; } EmployeeRole::insert($insert); } DB::commit(); }catch (Exception $e){ DB::rollBack(); return [false, $e->getMessage()]; } return [true,'']; } /** * 用户删除 * @param $data * @return array */ public function employeeDel($data){ if($this->isEmpty($data,'id')) return [false,'请选择删除的数据!']; Employee::whereIn('id',$data['id'])->update([ 'del_time'=>time() ]); EmployeeRole::where('del_time',0)->whereIn('employee_id',$data['id'])->update([ 'del_time'=>time() ]); return [true,'删除成功']; } /** * 用户列表 * @param $data * @param $user * @return array */ public function employeeList($data,$user){ $model = Employee::where('del_time',0) ->select('number','mobile','emp_name','id','entry_time','leave_time','is_admin','state') ->orderBy('id','desc'); if(! empty($data['depart'])) { $depart = Depart::where('del_time',0) ->select('id','parent_id') ->get()->toArray(); $result = array_merge($this->getAllDescendants($depart,$data['depart']),[$data['depart']]); $employee_id = DB::table('employee_depart_permission') ->whereIn("depart_id", $result) ->select("employee_id") ->get()->toArray(); $employee_id = array_column($employee_id,'employee_id'); $model->whereIn("id", $employee_id); }else{ $employee_id = $this->getEmployee($user); $model->whereIn('id',$employee_id); } if(! empty($data['number'])) $model->where('number', 'LIKE', '%'.$data['number'].'%'); if(! empty($data['emp_name'])) $model->where('emp_name', 'LIKE', '%'.$data['emp_name'].'%'); if(! empty($data['state'])) $model->where('state',$data['state']); if(! empty($data['mobile'])) $model->where('mobile', 'LIKE', '%'.$data['mobile'].'%'); if(! isset($data['all_emp'])) $model->where('id','<>',Employee::SPECIAL_ADMIN); if(! empty($data['role'])) { $emp = EmployeeRole::where('role_id',$data['role']) ->where('del_time',0) ->select('employee_id')->get()->toArray(); $model->whereIn('id',array_column($emp,'employee_id')); } if($user['id'] != Employee::SPECIAL_ADMIN) $model->where('is_manager',0); $list = $this->limit($model,'',$data); //组织数据 $list = $this->organizationEmployeeData($list); return [true , $list]; } /** * 用户数据组装 * @param $data * @return array */ public function organizationEmployeeData($data) { if (empty($data['data'])) return $data; $res = DB::table('employee_role as a') ->leftJoin('role as b','a.role_id','=','b.id') ->where('a.del_time',0) ->where('b.del_time',0) ->whereIn("a.employee_id",array_column($data['data'],'id')) ->select('a.employee_id','b.title','b.id') ->get()->toArray(); $role = $role2 = []; foreach ($res as $value){ if(isset($role[$value->employee_id])){ $role[$value->employee_id] .= ',' . $value->title; }else{ $role[$value->employee_id] = $value->title; } $role2[$value->employee_id][] = $value->id; } $res = DB::table('employee_depart_permission as a') ->select('a.employee_id','b.title','b.id') ->join('depart as b','a.depart_id','=','b.id') ->whereIn("a.employee_id",array_column($data['data'],'id')) ->orderBy('b.id') ->get()->toArray(); $depart_title = $depart_id = []; foreach ($res as $value){ if(isset($depart_title[$value->employee_id])){ $depart_title[$value->employee_id] .= ',' . $value->title; }else{ $depart_title[$value->employee_id] = $value->title; } $depart_id[$value->employee_id][] = $value->id; } foreach ($data['data'] as $key => $value){ $data['data'][$key]['role'] = $role2[$value['id']] ?? []; $data['data'][$key]['role_name'] = $role[$value['id']] ?? ''; $data['data'][$key]['depart'] = $depart_id[$value['id']] ?? []; $data['data'][$key]['depart_title'] = $depart_title[$value['id']] ?? ''; } return $data; } //获取当前顶级部门下人员id public function getEmployee($user){ $top_depart_id = $user['depart_top'][0] ?? []; $top_depart_id = $top_depart_id['depart_id'] ?? 0; $list = Depart::where('del_time',0)->select('id','parent_id')->get()->toArray(); // 查找所有子级id $childIds = $this->findChildIds($top_depart_id, $list); $childIds[] = $top_depart_id; $employee_id = EmployeeDepartPermission::whereIn('depart_id',$childIds) ->select("employee_id") ->get()->toArray(); return array_unique(array_column($employee_id,'employee_id')); } /** * 用户参数规则 * @param $data * @param $is_add * @return array */ public function employeeRule($data,$is_add = true){ if($this->isEmpty($data,'number')) return [false,'工号不存在!']; if($this->isEmpty($data,'emp_name')) return [false,'姓名不存在!']; if(empty($data['depart'])) return [false,'部门不能为空']; $mobile = $data['mobile'] ?? ""; $number = $data['number'] ?? ""; if(! $is_add){ if($this->isEmpty($data,'id')) return [false,'ID不能为空!']; $bool = Employee::where('del_time',0) ->where('id','<>',$data['id']) ->where(function ($query) use ($mobile, $number){ $query->where('number', $number); $query->when(! empty($mobile), function ($query) use ($mobile) { return $query->orWhere('mobile', $mobile); }); })->exists(); }else{ $bool = Employee::where('del_time',0) ->where(function ($query) use ($mobile, $number){ $query->where('number', $number); $query->when(! empty($mobile), function ($query) use ($mobile) { return $query->orWhere('mobile', $mobile); }); })->exists(); } if($bool) return [false,'工号或手机号码已存在!']; return [true,'']; } /** * 角色编辑 * @param $data * @return array */ public function roleEdit($data,$user){ list($status,$msg) = $this->roleRule($data,$user, false); if(!$status) return [$status,$msg]; $model = new Role(); $model = $model->where('id',$data['id'])->first(); $model->title = $data['title']; $model->save(); return [true,'保存成功!']; } /** * 角色新增 * @param $data * @param $user * @return array */ public function roleAdd($data,$user){ list($status,$msg) = $this->roleRule($data,$user); if(!$status) return [$status,$msg]; $model = new Role(); $model->title = $data['title'] ; $model->depart_id = $data['depart_id'] ?? 0; $model->top_depart_id = $data['top_depart_id'] ?? 0; $model->save(); return [true,'保存成功!']; } /** * 角色删除 * @param $data * @return array */ public function roleDel($data){ if($this->isEmpty($data,'id')) return [false,'ID必须!']; $bool = EmployeeRole::where('del_time',0) ->whereIn('role_id',$data['id']) ->exists(); if($bool) return [false,'角色已绑定人员!']; Role::where('id',$data['id'])->update([ 'del_time' => time() ]); RoleMenu::where('del_time',0)->where('role_id',$data['id'])->update([ 'del_time' => time() ]); RoleMenuButton::where('del_time',0)->where('role_id',$data['id'])->update([ 'del_time' => time() ]); return [true,'删除成功']; } /** * 角色列表 * @param $data * @return array */ public function roleList($data,$user){ $model = Role::TopClear($user,$data); $model = $model->where('del_time',0) ->select('title','crt_time','id','upd_time') ->orderBy('id','desc'); if(! empty($data['title'])) $model->where('title', 'LIKE', '%' . $data['title'] . '%'); $list = $this->limit($model,'',$data); return [200,$list]; } /** * 角色参数规则 * @param $data * @param $is_check * @return array */ public function roleRule(&$data,$user, $is_check = true){ if($this->isEmpty($data,'title')) return [false,'名称不能为空!']; //所属部门 以及 顶级部门 if(empty($data['depart_id'])) $data['depart_id'] = $this->getDepart($user); $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0; if($is_check){ $bool = Role::where('title',$data['title']) ->where('top_depart_id',$data['top_depart_id']) ->where('del_time',0) ->exists(); if($bool) return [false,'角色名称已存在!']; }else{ if($this->isEmpty($data,'id')) return [false,'ID不能为空!']; $top_depart_id = Role::where('id',$data['id'])->value('top_depart_id'); $bool = Role::where('title',$data['title']) ->where('top_depart_id',$top_depart_id) ->where('id','<>',$data['id']) ->where('del_time',0) ->exists(); if($bool) return [false,'角色名称已存在!']; } return [true,'']; } /** * 角色菜单更新 * @param $data * @return array */ public function roleMenu($data){ if(empty($data['role_id'])) return [false,'角色不能为空!']; if(empty($data['menu'])) return [false,'菜单数据不能为空!']; DB::beginTransaction(); try { RoleMenu::where('del_time',0)->where('role_id',$data['role_id'])->update(['del_time' => time()]); RoleMenuButton::where('del_time',0)->where('role_id',$data['role_id'])->update(['del_time' => time()]); $insert = $insert2 = []; foreach ($data['menu'] as $t){ $insert[] = [ 'role_id' => $data['role_id'], 'menu_id' => $t['menu_id'], 'type' => $t['type'], 'crt_time' => time() ]; if(! empty($t['button'])){ foreach ($t['button'] as $b){ $insert2[] = [ 'role_id' => $data['role_id'], 'menu_id' => $t['menu_id'], 'button_id' => $b, 'crt_time' => time() ]; } RoleMenuButton::insert($insert2); } } RoleMenu::insert($insert); DB::commit(); }catch (\Throwable $exception){ DB::rollBack(); return [false,$exception->getMessage()]; } return [true,'保存成功!']; } /** * 角色详情 * @param $data * @return array */ public function roleDetail($data){ if(empty($data['role_id'])) return [false,'请选择角色']; $role = Role::where('id',$data['role_id']) ->where('del_time',0) ->select('id','title') ->first(); if(empty($role)) return [false,'角色不存在或已被删除']; $role = $role->toArray(); $menu = RoleMenu::where('role_id',$data['role_id']) ->where('del_time',0) ->select('menu_id','type') ->get()->toArray(); $button = $this->fillRoleButton([$data['role_id']]); foreach ($menu as $key => $value){ $menu[$key]['button'] = $button[$value['menu_id']] ?? []; } $role['menu'] = $menu; return [true, $role]; } /** * 部门编辑 * @param $data * @return array */ public function departEdit($data, $user){ list($status,$msg) = $this->departRule($data,$user,false); if(!$status) return [$status,$msg]; $update = $msg['data'][0]; $model = new Depart(); $model->where('id',$data['id'])->update($update); return [true,'保存成功!']; } /** * 部门新增 * @param $data * @param $user * @return array */ public function departAdd($data,$user){ list($status,$msg) = $this->departRule($data,$user); if(!$status) return [$status,$msg]; try { DB::beginTransaction(); $time = time(); foreach ($msg['data'] as $value){ $model = new Depart(); $model->parent_id = $value['parent_id']; $model->title = $value['title']; $model->code = $value['code']; $model->is_main = $value['is_main']; $model->basic_type_id = $value['basic_type_id'] ?? 0; $model->rate = $value['rate'] ?? 0; $model->notify_id = $value['notify_id'] ?? 0; $model->save(); $depart_id = $model->id; if(empty($depart_id)) { DB::rollBack(); return [false,'部门新建失败']; } if(empty($value['parent_id'])){ $m = new Storehouse(); $m->title = $value['title']; $m->depart_id = $depart_id; $m->top_depart_id = $depart_id; $m->crt_id = $user['id']; $m->save(); if(empty($m->id)) { DB::rollBack(); return [false,'仓库生成失败']; } $employee = new Employee(); $number = "admin" . $value['code']; $employee->number = $number; $employee->emp_name = $value['title'] . "管理员账号"; $employee->entry_time = date('Y-m-d'); $employee->state = 1; $employee->crt_id = $user['id']; $employee->is_admin = 1; $employee->account = $number; $employee->password = Hash::make("password"); $employee->is_manager = 1; $employee->save(); if(empty($employee->id)) { DB::rollBack(); return [false,'管理员账号生成失败']; } $depart = new EmployeeDepartPermission(); $depart->employee_id = $employee->id; $depart->depart_id = $depart_id; $depart->save(); if(empty($depart->id)) { DB::rollBack(); return [false,'管理员账号部门关联生成失败']; } //公司系统设置 ProductInventorySet::insert(['top_depart_id' => $depart_id, 'param_one' => 1, 'crt_time' => $time]); // if(! empty($value['is_main'])){ // //总供应商 所有分社可见 // Supplier::insert([ // 'title' => $value['title'], // 'crt_id' => $user['id'], // 'crt_time' => $time, // 'depart_id' => $depart_id, // 'top_depart_id' => $depart_id, // 'is_main' => Supplier::is_main, // ]); // } } } DB::commit(); }catch (\Exception $exception){ DB::rollBack(); return [false,$exception->getMessage()]; } return [true,'保存成功!']; } /** * 部门删除 * @param $data * @return array */ public function departDel($data){ list($status,$msg) = $this->checkDepartDel($data); if(! $status) return [false, $msg]; Depart::whereIn('id',$data['id'])->update([ 'del_time'=>time() ]); return [true,'删除成功']; } /** * 判断部门是否可以删除 * @param $data * @return array */ public function checkDepartDel($data){ if($this->isEmpty($data,'id')) return [false,'ID必须!']; $bool = Depart::whereIn('parent_id',$data['id'])->where('del_time',0)->exists(); if($bool) return [false,'部门下有子部门!']; if($this->checkDepartHasPerson($data['id'])) return [false,'部门下有人员档案!']; $bool = ProductInventory::where('top_depart_id',$data['id'])->where('del_time',0)->exists(); if($bool) return [false,'部门下的仓库有产品信息!']; return [true, '']; } /** * 部门列表 * @param $data * @param $user * @return array */ public function departList($data,$user){ $model = Depart::where('del_time',0) ->select('title','id','code','parent_id','is_main','basic_type_id','rate','notify_id') ->orderby('id', 'asc'); if(! empty($data['get_top']) && $data['get_top'] == 1){ //指派销售 $depart_id = $this->getDepartIdListOfMySales($user); $model->whereIn('id', $depart_id); }else{ if($user['id'] != Employee::SPECIAL_ADMIN && ! $user['is_all_depart'] && empty($data['get_top'])){ $depart_id = $this->getDepartIdList($user); $model->whereIn('id',$depart_id); } } if(isset($data['parent_id'])) $model->where('parent_id', $data['parent_id']); if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%'); if(! empty($data['code'])) $model->where('code', 'LIKE', '%'.$data['code'].'%'); $list = $model->get()->toArray(); $list = $this->fillDepartList($list, $user); $list_tree = $list; if(! empty($list_tree)) { $list_tree = $this->makeTree(0,$list_tree); $list_tree = $this->set_sort_circle($list_tree); } return [200,['data' => $list,'tree' => $list_tree]]; } public function fillDepartList($list,$user){ if(empty($list)) return $list; $basic = BasicType::where('del_time',0) ->whereIn('id', array_unique(array_column($list,'basic_type_id'))) ->pluck('title','id')->toArray(); $emp_map = Employee::whereIn('id',array_unique(array_column($list,'notify_id'))) ->pluck('emp_name','id') ->toArray(); foreach ($list as $key => $value){ $list[$key]['basic_type_title'] = $basic[$value['basic_type_id']] ?? ''; $list[$key]['is_show_basic_type'] = $user['is_all_depart']; $list[$key]['notify_name'] = $emp_map[$value['notify_id']] ?? ''; } return $list; } //获取可见的部门范围 public function getDepartIdList($user){ $list = Depart::where('del_time',0)->select('id','parent_id')->get()->toArray(); $result = []; foreach ($user['depart_range'] as $v){ // 查找所有父级id $parentIds = $this->findParentIds($v, $list); // 查找所有子级id $childIds = $this->findChildIds($v, $list); // 合并父级和子级id $tmp = array_merge($parentIds, $childIds, [$v]); $result = array_merge($result,$tmp); } return array_unique($result); } //获取指派销售时的部门 public function getDepartIdListOfMySales($user){ $top = $user['depart_top'][0] ?? []; $top = $top['depart_id'] ?? 0; $list = Depart::where('del_time',0)->select('id','parent_id')->get()->toArray(); // 查找所有子级id $childIds = $this->findChildIds($top, $list); $result = array_merge($childIds, [$top]); return $result; } /** * 部门参数规则 * @param $data * @param $is_check * @return array */ public function departRule($data,$user, $is_check = true){ if($this->isEmpty($data,'data')) return [false,'数据不能为空!']; $code = array_column($data['data'],'code'); $title = array_column($data['data'],'title'); $code = array_map(function($val) { return $val !== null ? $val : 0; }, $code); $title = array_map(function($val) { return $val !== null ? $val : 0; }, $title); $code_count = array_count_values($code); $title_count = array_count_values($title); foreach ($code as $value){ if(empty($value)) return [false,'编码不能为空!']; if($code_count[$value] > 1) return [false,'编码不能重复']; } foreach ($title as $value){ if(empty($value)) return [false,'名称不能为空!']; if($title_count[$value] > 1) return [false,'名称不能重复']; } $count = 0; foreach ($data['data'] as $value){ if(empty($value['parent_id']) && ! empty($value['is_main'])) $count ++; } if($count > 1) return [false,'顶级总社只允许存在一个!']; if($count == 1){ $id = $data['id'] ?? 0; $bool = Depart::where('del_time',0) ->where('parent_id',0) ->where('is_main',1) ->when(! empty($id), function ($query) use ($id) { return $query->where('id', '<>',$id); }) ->exists(); if($bool) return [false,'顶级总社只允许存在一个!']; } foreach ($data['data'] as $key => $value){ if(empty($value['parent_id'])) $data['data'][$key]['parent_id'] = 0; $data['data'][$key]['upd_time'] = time(); //Depart::whereRaw("(binary code = '{$value['code']}' OR title = '{$value['title']}')") if($is_check){ if(empty($user['is_all_depart']) && empty($value['parent_id'])) return [false,'上级部门必须选择']; $data['data'][$key]['crt_time'] = time(); $bool = Depart::whereRaw("binary code = '{$value['code']}'") ->where('del_time',0) ->exists(); }else{ if($this->isEmpty($data,'id')) return [false,'id不能为空!']; $bool = Depart::whereRaw("binary code = '{$value['code']}'") ->where('id','<>',$data['id']) ->where('del_time',0) ->exists(); } if($bool) return [false,'编码不能重复']; } return [true, $data]; } /** * 检测部门下是否存在人员 * @param $depart_id * @return false */ public function checkDepartHasPerson($depart_id = []){ if(empty($depart_id)) return false; $bool = EmployeeDepartPermission::from('employee_depart_permission as a') ->leftJoin('employee as b','b.id','a.employee_id') ->where('b.del_time',0) ->whereIn('a.depart_id',$depart_id) ->exists(); return $bool; } /** * 班组编辑 * @param $data * @return array */ public function teamEdit($data){ list($status,$msg) = $this->teamRule($data,false); if(!$status) return [$status,$msg]; $model = new Team(); $model = $model->where('id',$data['id'])->first(); $model->title = $data['title']; $model->code = $data['code']; $model->save(); return [true,'保存成功!']; } /** * 班组新增 * @param $data * @param $user * @return array */ public function teamAdd($data,$user){ list($status,$msg) = $this->teamRule($data); if(!$status) return [$status,$msg]; $model = new Team(); $model->title = $data['title'] ; $model->code = $data['code']; $model->save(); return [true,'保存成功!']; } /** * 班组删除 * @param $data * @return array */ public function teamDel($data){ if($this->isEmpty($data,'id')) return [false,'ID必须!']; Team::where('id',$data['id'])->update([ 'del_time'=>time() ]); return [true,'删除成功']; } /** * 班组列表 * @param $data * @return array */ public function teamList($data){ $list = Team::where('del_time',0) ->select('title','id','crt_time','upd_time','code') ->orderBy('id','desc'); $list = $this->limit($list,'',$data); return [200,$list]; } /** * 班组参数规则 * @param $data * @param $is_add * @return array */ public function teamRule($data,$is_add = true){ if($this->isEmpty($data,'title')) return [false,'名称不存在!']; if($this->isEmpty($data,'code')) return [false,'编码不存在']; $model = Team::where('title',$data['title']) ->where('code',$data['code']) ->where('del_time',0); if(! $is_add){ if($this->isEmpty($data,'id')) return [false,'ID不能为空']; $model->where('id','<>',$data['id']); } $bool = $model->exists(); if($bool) return [false,'名称和编码已存在!']; return [true,'']; } /** * 班组详情 * @param $data * @return array */ public function teamDetail($data){ if($this->isEmpty($data,'id')) return [false,'ID不能为空!']; $result = EmployeeTeamPermission::from('employee_team_permission as a') ->leftJoin('employee as b','b.id','a.employee_id') ->where('team_id',$data['id']) ->select('b.id','b.emp_name','b.number as code') ->get()->toArray(); return [true,$result]; } /** * 人员权限 * @param $data * @return array */ public function employeeRole($data){ $role_ids = []; $employee_ids = []; foreach ($data as $v){ if(isset($v['role_id'])){ if(!in_array($v['role_id'],$role_ids)){ $role_ids[] = $v['role_id']; } } if(isset($v['employee_id'])){ if(!in_array($v['employee_id'],$employee_ids)){ $employee_ids[] = $v['employee_id']; } } } EmployeeMenuPermission::wherein('role_id',$role_ids)->delete(); EmployeeMenuPermission::wherein('employee_id',$employee_ids)->delete(); EmployeeMenuPermission::insert($data); return [200,'保存成功!']; } /** * 人员部门关系更新 * @param $data * @return array */ public function employeeDepart($data){ if($this->isEmpty($data,'insert')) return [false,'数据不能为空!']; DB::beginTransaction(); try { if($data['type'] == 1){ EmployeeDepartPermission::whereIn('depart_id',$data['insert']['depart_id'])->delete(); }else{ EmployeeDepartPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete(); } $insert = []; foreach ($data['insert']['depart_id'] as $t){ foreach ($data['insert']['employee_id'] as $e){ $insert[] = [ 'depart_id' => $t, 'employee_id' => $e ]; } } EmployeeDepartPermission::insert($insert); DB::commit(); }catch (\Throwable $exception){ DB::rollBack(); return [false,$exception->getMessage()]; } return [true,'保存成功!']; } /** * 人员班组关系更新 * @param $data * @return array */ public function employeeTeam($data){ if($this->isEmpty($data,'insert')) return [false,'数据不能为空!']; DB::beginTransaction(); try { if($data['type'] == 1){ EmployeeTeamPermission::whereIn('team_id',$data['insert']['team_id'])->delete(); }else{ EmployeeTeamPermission::whereIn('employee_id',$data['insert']['employee_id'])->delete(); } $insert = []; foreach ($data['insert']['team_id'] as $t){ foreach ($data['insert']['employee_id'] as $e){ $insert[] = [ 'team_id' => $t, 'employee_id' => $e ]; } } EmployeeTeamPermission::insert($insert); DB::commit(); }catch (\Throwable $exception){ DB::rollBack(); return [false,$exception->getMessage()]; } return [true,'保存成功!']; } /** * 登陆参数规则 * @param $data * @return array */ public function loginRule($data){ if($this->isEmpty($data,'account')) return [false,'账号不能为空!']; if($this->isEmpty($data,'password')) return [false,'密码不存在!']; $account = $data['account']; $res = Employee::where('del_time',0) ->where(function ($query)use($account) { $query->where('account', $account) ->orWhere('mobile', $account); }) ->get()->toArray(); if(empty($res)) return [false,'账号不存在或已被删除!']; if(count($res) > 1) return [false,'该手机号检测出多个账户,请联系后台!']; $res = reset($res); if(! Hash::check($data['password'], $res['password'])) return [false,'密码错误!']; if($res['is_admin'] != Employee::IS_ADMIN) return [false,'该账号不能登录!']; if($res['state'] == Employee::NOT_USE) return [false,'账号停用!']; //门店的信息(即将废弃) // $return = EmployeeService::getLoginDepartfq($res['id']); // $is_main = $return[4] ?? 0; // $depart_top = $return[1] ?? []; // $depart_top_title = $depart_top[0]['title'] ?? ""; // $depart_top_id = $depart_top[0]['depart_id'] ?? 0; //门店的信息 $login_message = EmployeeService::getLoginMessage($res['id']); return [true, ['id'=>$res['id'],'name'=>$res['emp_name'],'all_top'=> $login_message]]; } /** * 检查人员信息 * @param $userId * @return array */ public static function checkUser($userId){ $res = Employee::where('id', $userId) ->where('del_time',0) ->where('is_admin',Employee::IS_ADMIN) ->where('state',Employee::USE)->get()->first(); if(empty($res)) return [false, '该账号无法登录,请联系管理员!']; return [true, $res]; } /** * 获取登录账号的角色 * @param $employee_id * @return array */ public static function getPersonRole($employee_id){ if(empty($employee_id) || $employee_id == Employee::SPECIAL_ADMIN) return []; $role = EmployeeRole::where('del_time',0) ->where('employee_id',$employee_id) ->select('role_id') ->get()->toArray(); //组织 $role_id = array_unique(array_column($role,'role_id')); asort($role_id); $role_id = array_values($role_id); return $role_id; } public static function getPersonRoleQx($role_id = []){ if(empty($role_id)) return []; $role = RoleMenu::where('del_time',0) ->whereIn('role_id',$role_id) ->select('menu_id','type') ->get()->toArray(); $sysmenu = SysMenu::where('del_time',0) ->where('is_authority','>',0) ->select('id') ->get()->toArray(); $sysmenu = array_column($sysmenu,'id'); $return = []; foreach ($role as $value){ if(! in_array($value['menu_id'],$sysmenu)) continue; if(isset($return[$value['menu_id']]) && $return[$value['menu_id']] < $value['type']){ $return[$value['menu_id']] = $value['type']; }else{ $return[$value['menu_id']] = $value['type']; } } return $return; } public static function getSpecialButton($role_id,$user){ $return = []; $special_button = config('specialButton'); if($user == Employee::SPECIAL_ADMIN) { foreach ($special_button as $value){ $return[] = $value['id']; } return $return; } $role_button = RoleMenuButton::where('del_time',0) ->where('button_id','<',0) ->whereIn('role_id',$role_id) ->select('menu_id','button_id') ->get()->toArray(); foreach ($role_button as $value){ $return[] = $value['button_id']; } return $return; } //通过角色获取菜单 public function getMenuByRoleInList($user){ $role_id = $user['role'] ?? []; $menu = SysMenu::where('del_time',0)->select('id')->get()->toArray(); if($user['id'] == Employee::SPECIAL_ADMIN) return array_column($menu,'id'); //没绑定角色 if(empty($role_id)) return []; $role_menu = RoleMenu::whereIn('role_id',$role_id) ->where('del_time',0) ->select('menu_id') ->get()->toArray(); return array_column($role_menu,'menu_id'); } //通过角色获取菜单以及按钮 public function getMenuByRole($user){ $role_id = $user['role'] ?? []; $menu = SysMenu::where('del_time',0)->select('id','uri')->get()->toArray(); $button = SysMenuButton::where('del_time',0)->select('id','title','sort','func','menu_id')->get()->toArray(); $button_map = []; foreach ($button as $value){ $button_map[$value['menu_id']][] = $value; } $object = []; //超级管理员 if($user['id'] == Employee::SPECIAL_ADMIN){ foreach ($menu as $value){ $object[] = [ 'id' => $value['id'], // 'type' => 0,//所有权限 'uri' => $value['uri'], 'button' => $button_map[$value['id']] ?? [], ]; } }else{ //没绑定角色 if(empty($role_id)) return []; $search = RoleMenu::whereIn('role_id',$role_id) ->where('del_time',0) ->select('menu_id','type') ->get()->toArray(); $menu_map = array_column($menu,'uri','id'); //该角色下 菜单里所有按钮 $button_menu = $this->fillRoleButton($role_id); $button_t = array_column($button,null,'id'); foreach ($search as $value){ $bt = $button_menu[$value['menu_id']] ?? []; $new = []; foreach ($bt as $b){ if(! empty($button_t[$b])) $new[] = $button_t[$b]; } $object[] = [ 'id' => $value['menu_id'], 'uri' => $menu_map[$value['menu_id']] ?? '', // 'type' => $value['type'], 'button' => $new, ]; } } return $object; } /** * 人员直接绑定部门 * @param $data * @param $user * @return array */ public function employeeManagerDepart($data,$user){ if($user['id'] != Employee::SPECIAL_ADMIN) return [false,'非ADMIN账号不能操作']; if($this->isEmpty($data,'employee_id')) return [false,'请选择操作人员']; if($this->isEmpty($data,'depart_id')) return [false,'请选择部门']; EmployeeManagerDepart::where('employee_id',$data['employee_id'])->update([ 'del_time' => time() ]); $insert = []; foreach ($data['depart_id'] as $value){ $insert[] = [ 'employee_id' => $data['employee_id'], 'depart_id' => $value, 'crt_time' => time(), 'upd_time' => time(), ]; } EmployeeManagerDepart::insert($insert); return [true,'']; } /** * 填充角色下的按钮 * @param $role_id * @return array */ public function fillRoleButton($role_id){ $button = RoleMenuButton::whereIn('role_id',$role_id) ->where('del_time',0) ->select('menu_id','button_id') ->get()->toArray(); $button_map = []; foreach ($button as $value){ if(! isset($button_map[$value['menu_id']])){ $button_map[$value['menu_id']][] = $value['button_id']; }else{ if(! in_array($value['button_id'], $button_map[$value['menu_id']])) $button_map[$value['menu_id']][] = $value['button_id']; } } return $button_map; } /** * 获取登录账号的部门 * @param $employee_id * @return array|string[] */ public static function getLoginDepart($employee_id, $top_depart_id = 0){ if(empty($employee_id)) return []; //自己绑定的部门 启用的部门 $depart = EmployeeDepartPermission::from('employee_depart_permission as a') ->join('depart as b','b.id','a.depart_id') ->where('a.employee_id',$employee_id) ->where('b.is_use',Depart::IS_UES) ->select('a.depart_id','b.is_main','b.parent_id','b.basic_type_id','b.title') ->orderBy('b.parent_id','asc') ->orderBy('b.is_main','desc') ->orderBy('a.depart_id','asc') ->get()->toArray(); $top = $map = $rule = $head = []; $res_data = [];//获取当前所在部门(也可能是门店 为了 depart_id) $my_depart = [];//当前门店下 我勾选的门店以及部门信息 $is_all_depart = $is_behind_main = 0; if(! empty($depart)){ //库存校验 $set_map = ProductInventorySet::where('del_time',0)->pluck('param_one','top_depart_id')->toArray(); //所有部门 $list = Depart::where('del_time',0)->get()->toArray(); $depart_map = array_column($list,null,'id'); foreach ($depart as $key => $value){ if($value['parent_id'] == 0){ $is_stock = $set_map[$value['depart_id']] ?? 1; $depart[$key]['is_stock'] = $is_stock; $top[$value['depart_id']] = [ 'depart_id' => $value['depart_id'], 'is_main' => $value['is_main'], 'basic_type_id' => $value['basic_type_id'], 'title' => $value['title'], 'is_stock' => $is_stock, ]; $map[$value['depart_id']] = $value['depart_id']; if(! empty($value['is_main']) && ! $is_behind_main) $is_behind_main = 1; if($value['depart_id'] == $top_depart_id) { $my_depart[] = $depart[$key]; if(empty($res_data)){ $res_data = $depart[$key]; }else{ if($value['depart_id'] >= $res_data['depart_id']) $res_data = $depart[$key]; } } }else{ $t = self::getTopParentId($value['depart_id'],$list); if($t && isset($depart_map[$t])) { $is_stock = $set_map[$t] ?? 1; $depart[$key]['is_stock'] = $is_stock; $t_tmp = $depart_map[$t] ?? []; if( ! isset($top[$t_tmp['id']])){ $top[$t_tmp['id']] = [ 'depart_id' => $t_tmp['id'], 'is_main' => $t_tmp['is_main'], 'basic_type_id' => $t_tmp['basic_type_id'], 'title' => $t_tmp['title'], 'is_stock' => $set_map[$t] ?? 1, ]; } $map[$value['depart_id']] = $t; if(! empty($t_tmp['is_main']) && ! $is_behind_main) $is_behind_main = 1; } if($t == $top_depart_id){ $my_depart[] = $depart[$key]; if(empty($res_data)){ $res_data = $depart[$key]; }else{ if($value['depart_id'] >= $res_data['depart_id']) $res_data = $depart[$key]; } } } } //-------------重组当前所在门店 $top = array_values($top); usort($top, function($a, $b) { return $b['is_main'] - $a['is_main']; }); if(! empty($top_depart_id)){ $targetArray = null; foreach ($top as $key => $value) { if ($value['depart_id'] == $top_depart_id) { $targetArray = $value; unset($top[$key]); // 从原数组中移除目标数组 break; // 找到后跳出循环 } } if ($targetArray) array_unshift($top, $targetArray); } //-------------重组当前所在门店 //-------------拥有的数据权限(门店、部门) $my_top = $top[0] ?? []; foreach ($my_depart as $value){ if(in_array($value['depart_id'],$rule)) continue; if(! $value['parent_id']){ //顶级 if(! empty($value['is_main']) && ! $is_all_depart) $is_all_depart = 1; if($value['is_main']) {//是总公司 //所有部门都有 $rule = array_column($list,'id'); }else{//不是总公司 //自己以及子部门 $depart_id = array_merge(self::getAllIds($list,$map[$value['depart_id']]),[$map[$value['depart_id']]]); $rule = array_merge_recursive($rule,$depart_id); } }else{//非顶级 if(! empty($my_top['is_main']) && $value['is_main'] && ! $is_all_depart) $is_all_depart = 1; if($value['is_main']) {//是总社 $top_tmp = $map[$value['depart_id']]; if(! empty($depart_map[$top_tmp]['is_main'])){ //顶级公司是总公司 所有部门都有 $rule = array_column($list,'id'); }else{ //顶级公司是分公司 分公司所有部门 $depart_id = array_merge(self::getAllIds($list,$top_tmp),[$top_tmp]); $rule = array_merge_recursive($rule,$depart_id); } }else{//不是总社 $rule = array_merge($rule,[$value['depart_id']]); } } } //-------------拥有的数据权限(门店、部门) //总店 foreach ($list as $value){ if(empty($value['parent_id']) && ! empty($value['is_main'])) $head = $value; } } $rule = array_unique($rule); return [$depart,$top,$map,$rule,$is_all_depart,$head,$is_behind_main,$res_data]; } //获取用户的所属门店信息 public static function getLoginMessage($employee_id){ if(empty($employee_id)) return []; //自己绑定的部门 启用的部门 $depart = EmployeeDepartPermission::from('employee_depart_permission as a') ->join('depart as b','b.id','a.depart_id') ->where('a.employee_id',$employee_id) ->where('b.is_use',Depart::IS_UES) ->select('a.depart_id','b.is_main','b.parent_id','b.basic_type_id','b.title') ->orderBy('b.parent_id','asc') ->orderBy('b.is_main','desc') ->orderBy('a.depart_id','asc') ->get()->toArray(); $top = []; if(! empty($depart)){ //所有部门 $list = Depart::where('del_time',0)->get()->toArray(); $depart_map = array_column($list,null,'id'); foreach ($depart as $value){ if($value['parent_id'] == 0){//顶级 if(! isset($top[$value['depart_id']])){ $top[$value['depart_id']] = [ 'depart_id' => $value['depart_id'], 'is_main' => $value['is_main'], 'title' => $value['title'], ]; } }else{ //门店 $t = self::getTopParentId($value['depart_id'],$list); if($t && isset($depart_map[$t])) { $t_tmp = $depart_map[$t] ?? []; $is_all_depart = 0; if(! empty($t_tmp['is_main']) && $value['is_main']) $is_all_depart = 1; if(! isset($top[$t_tmp['id']])){ $top[$t_tmp['id']] = [ 'depart_id' => $t_tmp['id'], 'is_main' => $is_all_depart, 'title' => $t_tmp['title'], ]; }else{ if(! empty($is_all_depart)) $top[$t_tmp['id']]['is_main'] = $is_all_depart; } } } } } $top = array_values($top); usort($top, function($a, $b) { return $b['is_main'] - $a['is_main']; }); return $top; } public static function getLoginDepartfq($employee_id){ if(empty($employee_id)) return []; //自己绑定的部门 启用的部门 $depart = EmployeeDepartPermission::from('employee_depart_permission as a') ->join('depart as b','b.id','a.depart_id') ->where('a.employee_id',$employee_id) ->where('b.is_use',Depart::IS_UES) ->select('a.depart_id','b.is_main','b.parent_id','b.basic_type_id','b.title') ->orderBy('b.parent_id','asc') ->orderBy('b.is_main','desc') ->orderBy('a.depart_id','asc') ->get()->toArray(); $top = $map = $rule = $head = []; $is_all_depart = $is_behind_main = 0; if(! empty($depart)){ //库存校验 $set_map = ProductInventorySet::where('del_time',0)->pluck('param_one','top_depart_id')->toArray(); //所有部门 $list = Depart::where('del_time',0)->get()->toArray(); $depart_map = array_column($list,null,'id'); foreach ($depart as $key => $value){ if($value['parent_id'] == 0){//顶级 $is_stock = $set_map[$value['depart_id']] ?? 1; $depart[$key]['is_stock'] = $is_stock; $top[$value['depart_id']] = [ 'depart_id' => $value['depart_id'], 'is_main' => $value['is_main'], 'basic_type_id' => $value['basic_type_id'], 'title' => $value['title'], 'is_stock' => $is_stock, ]; $map[$value['depart_id']] = $value['depart_id']; if(! empty($value['is_main']) && ! $is_all_depart) $is_all_depart = 1; if(! empty($value['is_main']) && ! $is_behind_main) $is_behind_main = 1; }else{ $t = self::getTopParentId($value['depart_id'],$list); if($t && isset($depart_map[$t])) { $is_stock = $set_map[$t] ?? 1; $depart[$key]['is_stock'] = $is_stock; $t_tmp = $depart_map[$t] ?? []; $top[$t_tmp['id']] = [ 'depart_id' => $t_tmp['id'], 'is_main' => $t_tmp['is_main'], 'basic_type_id' => $t_tmp['basic_type_id'], 'title' => $t_tmp['title'], 'is_stock' => $set_map[$t] ?? 1, ]; $map[$value['depart_id']] = $t; if(! empty($t_tmp['is_main']) && $value['is_main'] && ! $is_all_depart) $is_all_depart = 1; if(! empty($t_tmp['is_main']) && ! $is_behind_main) $is_behind_main = 1; } } } foreach ($depart as $value){ if(in_array($value['depart_id'],$rule)) continue; if(! $value['parent_id']){ //顶级 if($value['is_main']) {//是总公司 //所有部门都有 $rule = array_column($list,'id'); }else{//不是总公司 //自己以及子部门 $depart_id = array_merge(self::getAllIds($list,$map[$value['depart_id']]),[$map[$value['depart_id']]]); $rule = array_merge_recursive($rule,$depart_id); } }else{//非顶级 if($value['is_main']) {//是总社 $top_tmp = $map[$value['depart_id']]; if(! empty($depart_map[$top_tmp]['is_main'])){ //顶级公司是总公司 所有部门都有 $rule = array_column($list,'id'); }else{ //顶级公司是分公司 分公司所有部门 $depart_id = array_merge(self::getAllIds($list,$top_tmp),[$top_tmp]); $rule = array_merge_recursive($rule,$depart_id); } }else{//不是总社 $rule = array_merge($rule,[$value['depart_id']]); } } } foreach ($list as $value){ if(empty($value['parent_id']) && ! empty($value['is_main'])) $head = $value; } } $top = array_values($top); $rule = array_unique($rule); return [$depart, $top, $map, $rule, $is_all_depart, $head, $is_behind_main]; } /** * 获取顶级id * @param $id * @param $data * @return int */ public static function getTopParentId($id, $data) { foreach ($data as $item) { if ($item['id'] == $id) { if ($item['parent_id'] == 0) { // 找到最顶级的id return $item['id']; } else { // 继续递归查找父级 return self::getTopParentId($item['parent_id'], $data); } } } // 如果没有找到匹配的id,则返回null或者其他你希望的默认值 return 0; } /** * 递归获取所有id * @param $data * @param $id * @return array */ public static function getAllIds($data, $id) { $result = array(); // 存储结果的数组 foreach ($data as $node) { if ($node['parent_id'] == $id) { // 如果当前节点的父 ID 等于指定 ID,则将该节点添加到结果中 $result[] = $node['id']; // 递归查询该节点的所有子孙节点,并将结果合并到结果数组中 $result = array_merge($result, self::getAllIds($data, $node['id'])); } } return $result; } public static function checkWxUser($userId){ $res = Employee::where('id', $userId) ->where('del_time',0) ->where('state',Employee::USE)->get()->first(); if(empty($res)) return [false, '该账号无法登录,请联系管理员!']; return [true, $res]; } }