From 9db1c6c261049fbdcb104e6c0e07fa544bb42013 Mon Sep 17 00:00:00 2001
From: 杜洪波 <1074825718@qq.com>
Date: 星期三, 14 五月 2025 18:28:14 +0800
Subject: [PATCH] 代码BUG（预警解析异常）
---
src/main/java/com/product/administration/service/CustomerInfoService.java | 48 +++++++++++++++++++++++++-----------------------
1 files changed, 25 insertions(+), 23 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..930fb41 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;
@@ -40,28 +39,31 @@
*/
public DataTableEntity listCustomerInfo(Integer cpage,Integer pageSize,FieldSetEntity fse) {
//鏁版嵁鏉冮檺
-// String dataFilter=permissionService.getDataFilter(CmnConst.CREATED_BY) ;
+ String dataFilter=permissionService.getDataFilter(CmnConst.CREATED_BY);
//楂樼骇鏌ヨ
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(" 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(!StringUtils.isEmpty(dataFilter)) {
-// if (!StringUtils.isEmpty(searchFilter)) {
-// dataFilter+=" AND "+ searchFilter;
-// }
-// }else {
-// if (!StringUtils.isEmpty(searchFilter)) {
-// dataFilter=searchFilter;
-// }
+// StringBuilder sbSql = new StringBuilder();
+// sbSql.append("SELECT \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");
+// if (!BaseUtil.strIsNull(searchFilter)) {
+// sbSql.append("WHERE ").append(searchFilter);
// }
+
+ if(!BaseUtil.strIsNull(dataFilter)) {
+ if (!BaseUtil.strIsNull(searchFilter)) {
+ dataFilter+=" AND "+ searchFilter;
+ }
+ }else {
+ if (!BaseUtil.strIsNull(searchFilter)) {
+ dataFilter=searchFilter;
+ }
+ }
-// DataTableEntity dt=baseDao.listTable(CmnConst.product_project_CUSTOMER, searchFilter, null, null, null, pageSize, cpage);
- DataTableEntity dt = baseDao.listTable(sbSql.toString(), new Object[] {}, pageSize, cpage);
+ DataTableEntity dt=baseDao.listTable(CmnConst.PRODUCT_PROJECT_CUSTOMER, searchFilter, null, null, null, pageSize, cpage);
+// DataTableEntity dt = baseDao.listTable(sbSql.toString(), new Object[] {}, pageSize, cpage);
baseDao.loadPromptData(dt);
return dt;
}
@@ -72,7 +74,7 @@
* @return
*/
public FieldSetEntity findCustomerInfo(String uuid) {
- FieldSetEntity fieldSetEntity = baseDao.getFieldSetEntity(CmnConst.product_project_CUSTOMER, uuid, true);
+ FieldSetEntity fieldSetEntity = baseDao.getFieldSetEntity(CmnConst.PRODUCT_PROJECT_CUSTOMER, uuid, true);
FieldSetEntity fse = this.findCustomerValue(uuid);
fieldSetEntity.setValue("money", fse.getString("money"));
fieldSetEntity.setValue("returnedMoney", fse.getString("returnedMoney"));
@@ -93,7 +95,7 @@
*/
public FieldSetEntity contractProjectMakeMoney(String uuid) {
FieldSetEntity fieldSet = new FieldSetEntity();
- fieldSet.setTableName(CmnConst.product_project_CUSTOMER);
+ fieldSet.setTableName(CmnConst.PRODUCT_PROJECT_CUSTOMER);
//鍚堝悓琛� product_project_contract_info owner
DataTableEntity contractData = baseDao.listTable("product_project_contract_info"," owner = ? and flow_flag = 2 ",new Object[]{uuid});
baseDao.loadPromptData(contractData);
@@ -140,7 +142,7 @@
*/
public FieldSetEntity findCustomerValue(String uuid) {
FieldSetEntity fieldSetEntity = new FieldSetEntity();
- fieldSetEntity.setTableName(CmnConst.product_project_CUSTOMER);
+ fieldSetEntity.setTableName(CmnConst.PRODUCT_PROJECT_CUSTOMER);
//鏌ヨ鍚堝悓閲戦
StringBuffer moneySql = new StringBuffer();
moneySql.append(" SELECT IFNULL(SUM(d.money),0) money FROM ( ")
@@ -223,6 +225,6 @@
@Transactional
public boolean deleteCustomerInfo(String uuid) throws BaseException{
String[] uuids = uuid.split(",");
- return baseDao.delete(CmnConst.product_project_CUSTOMER, BaseUtil.buildQuestionMarkFilter(CmnConst.UUID, uuids.length, true), uuids);
+ return baseDao.delete(CmnConst.PRODUCT_PROJECT_CUSTOMER, BaseUtil.buildQuestionMarkFilter(CmnConst.UUID, uuids.length, true), uuids);
}
}
--
Gitblit v1.9.2