From 6e06bba1c89f8077e29d0fbf0ce12f89f027d8d2 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 22 六月 2022 16:16:37 +0800
Subject: [PATCH] fix(预防性防护): MySQL=》DMSQL
---
src/cn/ksource/web/facade/servicelist/SlaProjectFacadeImpl.java | 20 +++++++++-----------
1 files changed, 9 insertions(+), 11 deletions(-)
diff --git a/src/cn/ksource/web/facade/servicelist/SlaProjectFacadeImpl.java b/src/cn/ksource/web/facade/servicelist/SlaProjectFacadeImpl.java
index 8e15191..ce5d8a1 100644
--- a/src/cn/ksource/web/facade/servicelist/SlaProjectFacadeImpl.java
+++ b/src/cn/ksource/web/facade/servicelist/SlaProjectFacadeImpl.java
@@ -1,15 +1,5 @@
package cn.ksource.web.facade.servicelist;
-import java.util.ArrayList;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-
-import javax.servlet.http.HttpServletRequest;
-
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
import cn.ksource.beans.CONFIG_DATA_DICTIONARY;
import cn.ksource.beans.CUSTOMER_CONTACTS;
import cn.ksource.beans.SC_SERVCE_CATEGORY;
@@ -24,6 +14,14 @@
import cn.ksource.web.SysConstants;
import cn.ksource.web.facade.incident.IncidentFacade;
import cn.ksource.web.service.UserService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import javax.servlet.http.HttpServletRequest;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
@@ -42,7 +40,7 @@
@Override
public PageInfo queryProjectContacts(Map<String, String> params,
PageInfo pageInfo) {
- StringBuilder sql = new StringBuilder("SELECT DISTINCT * FROM CUSTOMER_CONTACTS WHERE CUSTOMER_ID = :customerId");
+ StringBuilder sql = new StringBuilder("SELECT DISTINCT ID , CUSTOMER_ID , CONTACT_NAME , YWKS , ZW , TELEPHONE , MOBILE , LEVEL_ID , LEVEL_NAME , IS_SATIS , STATE , LOGIN_NAME , PASSWORD , EMAIL , QQ_OPEN_ID , ISEMAIL , ISPHONE , ALLOW_LOGIN , WECHAT_OPEN_ID , SUB_CUSTOMER_ID , SUB_CUSTOMER_NAME , CONTACTS_TYPE , IME FROM CUSTOMER_CONTACTS WHERE CUSTOMER_ID = :customerId");
queryProjectContactsIf(params, sql);
sql.append(" ORDER BY ALLOW_LOGIN ASC,IS_SATIS DESC,STATE ASC");
return baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
--
Gitblit v1.9.1