From 11f925fdce0f58d1f321f3a13a3f3e84221c6912 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期一, 13 十一月 2023 09:27:14 +0800
Subject: [PATCH] 整理代码

---
 consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java |   23 ++++++++++++++++++-----
 1 files changed, 18 insertions(+), 5 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java
index 95321c8..99b1cbd 100644
--- a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java
@@ -2,12 +2,9 @@
 
 import com.consum.base.Constants;
 import com.consum.base.pojo.FinSysTenantDepartmentParam;
-import com.consum.base.util.IdUtil;
-import com.consum.model.po.BaseCategory;
-import com.consum.model.po.FinSysTenant;
+import com.consum.base.core.utils.IdUtil;
 import com.consum.model.po.FinSysTenantDepartment;
 import com.consum.model.po.FinSysTenantUser;
-import com.iplatform.model.po.S_user_core;
 import com.walker.db.page.GenericPager;
 import com.walker.infrastructure.utils.DateUtils;
 import com.walker.infrastructure.utils.StringUtils;
@@ -47,7 +44,6 @@
             sql.append(" and TENANT_ID =:TENANT_ID ");
             paramts.put("TENANT_ID", tenantId);
         }
-
         return this.get(sql.toString(), paramts, new FinSysTenantDepartment());
     }
 
@@ -149,4 +145,21 @@
         department.setUpdateBy(currentUser.getUserName());
         return this.update(department);
     }
+
+    /**
+     * 鏍规嵁鏈烘瀯id鏌ヨ閮ㄩ棬
+     * @param agencyId
+     * @return
+     */
+    public List<FinSysTenantDepartment> getByTenantId(Long agencyId) {
+        StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1 and is_delete = 0 ");
+        HashMap<String, Object> paramts = new HashMap<>();
+
+        //鏈烘瀯id
+        if (agencyId != null) {
+            sql.append(" and TENANT_ID =:TENANT_ID ");
+            paramts.put("TENANT_ID", agencyId);
+        }
+        return this.select(sql.toString(), paramts, new FinSysTenantDepartment());
+    }
 }

--
Gitblit v1.9.1