From 33032d320cb75854def7391026b0401f1bfb8360 Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期六, 11 五月 2024 17:26:02 +0800
Subject: [PATCH] 20240511修改: 分发单优化， 分类，物品，分发单明细，采购单明细数据导入
---
consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 50 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
index f4d749d..f017e97 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
@@ -168,4 +168,54 @@
}
return this.select(sql.toString(), paramts, new FinSysTenantDepartment());
}
+
+ @Override
+ public FinSysTenantDepartment getByTenantIdAndName(Long agencyId, String name) {
+ 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 =:tenantId ");
+ paramts.put("tenantId", agencyId);
+ }
+ // name
+ if (name != null) {
+ sql.append(" and name =:name ");
+ paramts.put("name", name);
+ }
+ List<FinSysTenantDepartment> select = this.select(sql.toString(), paramts, new FinSysTenantDepartment());
+ if(select!=null && select.size()>0){
+ return select.get(0);
+ }
+ return null;
+ }
+
+ @Override
+ public List<FinSysTenantDepartment> queryDataList(FinSysTenantDepartmentParam param) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1");
+ HashMap<String, Object> paramts = new HashMap<>();
+ // 缂栧彿
+ if (!StringUtils.isEmpty(param.getCode())) {
+ sql.append(" and code =:code ");
+ paramts.put("code", param.getCode());
+ }
+ List<FinSysTenantDepartment> select = this.select(sql.toString(), paramts, new FinSysTenantDepartment());
+ return select;
+ }
+
+ /**
+ * 鏍规嵁閮ㄩ棬鍜屾満鏋勫悕鏌ユ壘瀵瑰簲鐨勯儴闂ㄤ俊鎭�
+ * @param tenantName
+ * @param departmentName
+ * @return
+ */
+ @Override
+ public FinSysTenantDepartment queryIdByTenDepName(String tenantName, String departmentName ) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department \n" +
+ "WHERE TENANT_ID = ( SELECT id FROM fin_sys_tenant WHERE NAME = '"+tenantName+"' LIMIT 1 ) AND NAME = '"+departmentName+"' LIMIT 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+ return this.get(sql.toString(), paramts, new FinSysTenantDepartment());
+ }
+
}
--
Gitblit v1.9.1