From b18c5b8db781dd2c057ede09d07f4f88d0eaef0b Mon Sep 17 00:00:00 2001
From: 2369059705@qq.com <2369059705@qq.com>
Date: 星期一, 12 六月 2023 18:42:51 +0800
Subject: [PATCH] 列表高级搜索无效
---
src/main/java/com/product/server/report/service/ReportConfigService.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/product/server/report/service/ReportConfigService.java b/src/main/java/com/product/server/report/service/ReportConfigService.java
index 6a8915c..aa28e6a 100644
--- a/src/main/java/com/product/server/report/service/ReportConfigService.java
+++ b/src/main/java/com/product/server/report/service/ReportConfigService.java
@@ -51,12 +51,18 @@
List<Object> paramList = Lists.newArrayList();
StringBuilder sql = new StringBuilder(512);
+ String queryFilter = " ";
+ if(!BaseUtil.dataTableIsEmpty(fse.getSubDataTable("systemSeniorQueryString"))){
+ queryFilter ="AND"+ queryFilterService.getQueryFilter(fse);
+ }
sql.append("\nSELECT a.uuid,a.type_uuid,a.is_valid,a.org_level_uuid,a.report_name,b.type_name,b.type_group")
.append("\nFROM product_sys_report_config a")
.append("\nLEFT JOIN product_sys_report_type_config b ON a.type_uuid = b.uuid")
- .append("\nwhere (function_uuid is null or function_uuid='') ");
+ .append("\nwhere (function_uuid is null or function_uuid='') ")
+ .append(queryFilter);
+
if (!StringUtils.isEmpty(fse.getString(CmnConst.TYPE_UUID))) {
- sql.append("\nand b.type_group=?");
+ sql.append("\nand b.type_group=? ");
paramList.add(fse.getString(CmnConst.TYPE_UUID));
}
return baseDao.listTable(sql.toString(), paramList.toArray(), pageSize, cpage);
--
Gitblit v1.9.2