| | |
|---|
| | | import com.alibaba.excel.event.AnalysisEventListener; |
|---|
| | | import com.alibaba.excel.exception.ExcelDataConvertException; |
|---|
| | | import com.consum.base.BaseController; |
|---|
| | | import com.consum.base.core.type.StatesType; |
|---|
| | | import com.consum.base.core.utils.CommonUtil; |
|---|
| | | import com.consum.base.core.utils.MapperUtil; |
|---|
| | | import com.consum.base.core.utils.PageUtil; |
|---|
| | |
|---|
| | | finSysTenantUser.setStatus(user.getStatus()); |
|---|
| | | finSysTenantUserService.update(finSysTenantUser); |
|---|
| | | // 2.更新平台用户 S_USER_CORE |
|---|
| | | S_user_core userCore = buildUpdateUserCore(tenantUser); |
|---|
| | | S_user_core userCore = buildUpdateUserCore(finSysTenantUser); |
|---|
| | | this.userService.update(userCore); |
|---|
| | | return ResponseValue.success(1); |
|---|
| | | } |
|---|
| | |
|---|
| | | // 部门 |
|---|
| | | FinSysTenantDepartment finSysTenantDepartment = new FinSysTenantDepartment(); |
|---|
| | | finSysTenantDepartment.setTenantId(agencyId); |
|---|
| | | finSysTenantDepartment.setStatus(StatesType.NORMAL.getValue()); |
|---|
| | | finSysTenantDepartment.setIsDelete(0); |
|---|
| | | List<FinSysTenantDepartment> tenantDepartmentList = |
|---|
| | | finSysTenantDepartmentService.select(finSysTenantDepartment); |
|---|
| | | List<DepartmentVO> departmentVOList = Lists.newArrayList(); |
|---|
| | |
|---|
| | | departmentVO.setName(department.getName()); |
|---|
| | | departmentVO.setType("department"); |
|---|
| | | |
|---|
| | | String sql = "SELECT SYS_USER_ID,USER_NAME FROM " + "fin_sys_tenant_user " |
|---|
| | | + "WHERE SYS_DEPT_ID =:deptId AND SYS_USER_ID NOT IN(SELECT MANAGER_ID FROM base_warehouse_manager)"; |
|---|
| | | String sql = "SELECT SYS_USER_ID,USER_NAME FROM fin_sys_tenant_user " |
|---|
| | | + "WHERE STATUS =1 and SYS_DEPT_ID =:deptId AND SYS_USER_ID NOT IN(SELECT MANAGER_ID FROM base_warehouse_manager)"; |
|---|
| | | Map<String, Object> param = new HashMap<>(); |
|---|
| | | param.put("deptId", id); |
|---|
| | | List<Map<String, Object>> select = finSysTenantUserService.select(sql, param, new MapperUtil()); |
|---|
