From 985a45dc5017872196ee9c3ae0af3094c223bb0e Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 22 十二月 2023 11:26:55 +0800
Subject: [PATCH] 代码整理

---
 consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java |    9 ++++++---
 1 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
index cfb4b42..3052027 100644
--- a/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/FinSysTenantUserController.java
@@ -27,6 +27,7 @@
 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;
@@ -496,7 +497,7 @@
         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);
     }
@@ -818,6 +819,8 @@
         // 閮ㄩ棬
         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();
@@ -829,8 +832,8 @@
             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());

--
Gitblit v1.9.1