| | |
|---|
| | | } |
|---|
| | | else if (DATA_SCOPE_DEPT_AND_CHILD.equals(dataScope)) |
|---|
| | | { |
|---|
| | | sqlString.append(StringUtils.format(" OR {}.dept_id IN ( SELECT dept_id FROM sys_dept WHERE dept_id = {} or find_in_set( {} , ancestors ) )", deptAlias, user.getDeptId(), user.getDeptId())); |
|---|
| | | } |
|---|
| | | sqlString.append(StringUtils.format( |
|---|
| | | " OR {}.dept_id IN ( SELECT dept_id FROM sys_dept WHERE dept_id = {} OR {} = ANY(string_to_array(ancestors, ',')::bigint[]) )", |
|---|
| | | deptAlias, user.getDeptId(), user.getDeptId() |
|---|
| | | )); } |
|---|
| | | else if (DATA_SCOPE_SELF.equals(dataScope)) |
|---|
| | | { |
|---|
| | | if (StringUtils.isNotBlank(userAlias)) |
|---|
