where('dept_category', self::DEPT_CATEGORY)->first(); $deptSuperPath = $deptInfo->dept_super_path; $where[] = ['dept_super_path', 'like', "{$deptSuperPath}%"]; return SysDept::where($where)->pluck('dept_id')->toArray(); } /** * Notes: 获取团队信息 * User: yb * Date: 2024/8/14 * Time: 16:30 * @return */ public static function getTeams() { $where = [ ['dept_category', '=', self::DEPT_CATEGORY] ]; $data = SysDept::where($where)->select(['dept_id', 'dept_super_id', 'dept_super_path', 'dept_name'])->get(); return $data; } /** * Notes: 根据部门id获取部门信息 * User: yb * Date: 2024/8/14 * Time: 16:35 * @param $id */ public static function getTeamList($id) { $deptSuperPath = SysDept::where('dept_id', $id)->value('dept_super_path'); $deptList = SysDept::where('dept_super_path', 'like', "{$deptSuperPath}%")->where('dept_category', self::DEPT_CATEGORY)->get(); if ($deptList->isEmpty()) { return []; } else { return $deptList; } } }