From 00fa2194d460b9aec12750bd9381099036593fa3 Mon Sep 17 00:00:00 2001
From: 18756 <1875631620@qq.com>
Date: 星期一, 02 九月 2024 17:46:55 +0800
Subject: [PATCH] 会议室功能优化9.2
---
src/main/java/com/product/administration/service/CustomerInfoService.java | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/product/administration/service/CustomerInfoService.java b/src/main/java/com/product/administration/service/CustomerInfoService.java
index 3f742ff..638814f 100644
--- a/src/main/java/com/product/administration/service/CustomerInfoService.java
+++ b/src/main/java/com/product/administration/service/CustomerInfoService.java
@@ -8,7 +8,6 @@
import com.product.administration.config.CmnConst;
import com.product.administration.service.ide.ICustomerInfoService;
-import com.product.common.lang.StringUtils;
import com.product.core.dao.BaseDao;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
@@ -45,11 +44,14 @@
String searchFilter=queryFilterService.getQueryFilter(fse);
StringBuilder sbSql = new StringBuilder();
sbSql.append("SELECT \n");
- sbSql.append(" A.uuid, A.customer_manager, A.customer_manager_leader,A.business_agent, \n");
+ sbSql.append(" A.uuid,A.customer_name, A.customer_manager, A.customer_manager_leader,A.business_agent, \n");
sbSql.append(" CONCAT(B.linkman, '-', B.mobile) AS customer_contact \n");
sbSql.append("FROM product_project_customer A \n");
sbSql.append("LEFT JOIN product_project_customer_sub B ON B.customer_uuid = A.uuid \n");
- sbSql.append(searchFilter);
+ if (!BaseUtil.strIsNull(searchFilter)) {
+ sbSql.append("WHERE ").append(searchFilter);
+ }
+
// if(!StringUtils.isEmpty(dataFilter)) {
// if (!StringUtils.isEmpty(searchFilter)) {
// dataFilter+=" AND "+ searchFilter;
--
Gitblit v1.9.2