fix : MySQL=》DMSQL

cy

2022-06-27 150ced737ad5d16d476df143c7e4238fc6b8b998

fix : MySQL=》DMSQL

 src/cn/ksource/web/facade/satis/SatisfactionFacadeImpl.java

@@ -1,21 +1,6 @@
package cn.ksource.web.facade.satis;

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.AUDITING_SATIS_INFO;
import cn.ksource.beans.CUSTOMER_SATIS_TEMPLATE;
import cn.ksource.beans.ORDER_SATIS_INFO;
import cn.ksource.beans.SC_WORKFLOW_INCIDENT;
import cn.ksource.beans.SC_WORKFLOW_INCIDENT_LOCAL;
import cn.ksource.beans.WORKFLOW_BASE;
import cn.ksource.beans.*;
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.page.PageInfo;
@@ -27,6 +12,14 @@
import cn.ksource.web.Constants;
import cn.ksource.web.facade.incident.IncidentFacade;
import cn.ksource.web.service.file.FileService;
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;

@Service("satisfationFacade")
public class SatisfactionFacadeImpl implements SatisfactionFacade {
@@ -66,7 +59,7 @@
            Map<String, String> params) {
        
        StringBuilder sql = new StringBuilder();
        sql.append("SELECT DISTINCT WB.ID,WB.ORDER_CODE,WB.ENDTIME,WB.WFNAME,WB.BUSINESSTYPE,WB.CREATERNAME,WB.CREATETIME,WB.WFNOTE,B.CONTACT_NAME,B.CONTACT_PHONE, ");
        sql.append("SELECT DISTINCT WB.ID,WB.ORDER_CODE,WB.ENDTIME,WB.WFNAME,WB.BUSINESSTYPE,WB.CREATERNAME,WB.CREATETIME,B.CONTACT_NAME,B.CONTACT_PHONE, ");
        sql.append("WB.CURRENT_NODE_ID,WB.CURRENT_NODE_NAME,WB.CUSTOMER_NAME,WB.CURRENT_DEALER_NAME,WB.BUSINESS_ID,WB.WFSTATE,C.SCORE ");
        sql.append("FROM SC_WORKFLOW_INCIDENT B,WORKFLOW_BASE WB LEFT JOIN ORDER_SATIS_INFO C ON C.BUSINESS_ID = WB.ID  WHERE WB.BUSINESS_ID = B.ID ");
        sql.append("AND WB.BUSINESSTYPE = :businessType ");
@@ -82,7 +75,7 @@
            Map<String, String> params) {
        
        StringBuilder sql = new StringBuilder();
        sql.append("SELECT DISTINCT WB.ID,WB.ORDER_CODE,WB.ENDTIME,WB.WFNAME,WB.BUSINESSTYPE,WB.CREATERNAME,WB.CREATETIME,WB.WFNOTE,B.CONTACT_NAME,B.CONTACT_PHONE, ");
        sql.append("SELECT DISTINCT WB.ID,WB.ORDER_CODE,WB.ENDTIME,WB.WFNAME,WB.BUSINESSTYPE,WB.CREATERNAME,WB.CREATETIME,B.CONTACT_NAME,B.CONTACT_PHONE, ");
        sql.append("WB.CURRENT_NODE_ID,WB.CURRENT_NODE_NAME,WB.CUSTOMER_NAME,WB.CURRENT_DEALER_NAME,WB.BUSINESS_ID,WB.WFSTATE,C.SCORE ");
        sql.append("FROM SC_WORKFLOW_INCIDENT_LOCAL B,WORKFLOW_BASE WB LEFT JOIN ORDER_SATIS_INFO C ON C.BUSINESS_ID = WB.ID  WHERE WB.BUSINESS_ID = B.ID ");
        sql.append("AND WB.BUSINESSTYPE = :businessType ");

 src/cn/ksource/web/service/knowledge/KmRecordServiceImpl.java

@@ -1,19 +1,17 @@
package cn.ksource.web.service.knowledge;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.beans.GG_USER;
import cn.ksource.beans.KM_LIBRARY;
import cn.ksource.beans.KM_RECORD;
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.StringUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Service
public class KmRecordServiceImpl implements KmRecordService {
    
@@ -29,7 +27,7 @@
        Map cacheMap = new HashMap();
        for(Map map:list){
            int score = ConvertUtil.obj2Int(map.get("SCORE"));
            cacheMap.put(map.get("TYPE"),score);
            cacheMap.put(ConvertUtil.obj2Integer(map.get("TYPE")),score);
        }
        KM_RECORD record = new KM_RECORD();
        record.setLibrary_id(id).setType(ConvertUtil.obj2Integer(params.get("type"))).setScore(ConvertUtil.obj2Integer(cacheMap.get(ConvertUtil.obj2Integer(params.get("type")))))