package cn.ksource.web.facade.wechat.ewyw;
|
|
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.core.dao.BaseDao;
|
import cn.ksource.core.dao.SqlParameter;
|
import cn.ksource.core.page.PageInfo;
|
import cn.ksource.core.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.JsonUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.core.web.WebUtil;
|
import cn.ksource.web.Constants;
|
import cn.ksource.web.service.file.FileService;
|
|
@Service("ewSatisFacade")
|
public class EwSatisFacadeImpl implements EwSatisFacade {
|
|
@Autowired
|
private BaseDao baseDao;
|
|
@Autowired
|
private FileService fileService;
|
|
@Override
|
public List ewMyMonthCalendar(Map<String, String> params) {
|
String year = params.get("year");
|
String type = params.get("type");
|
long nowTime = DateUtil.getCurrentDate6();
|
if(!StringUtil.notEmpty(year)) {
|
year = DateUtil.getToday("yyyy");
|
}
|
//初始化月份数据
|
List<Map> allMonth = new ArrayList<Map>();
|
List<Map> cardmsg = queryZcsatisCount(params.get("userId"),type);
|
Map cacheMap = new HashMap();
|
for(Map map:cardmsg){
|
cacheMap.put(map.get("CARD_MONTH"), map.get("STATE"));
|
}
|
|
for(int i=1;i<=12;i++) {
|
Map map = new HashMap();
|
map.put("year", year);
|
String month = i<10?("0"+i):(""+i);
|
map.put("month", month);
|
System.out.println(year+month);
|
long yearMonth = ConvertUtil.obj2Long(year+month);
|
if(!StringUtil.isEmpty(ConvertUtil.obj2StrBlank(cacheMap.get(yearMonth)))){
|
map.put("state", cacheMap.get(yearMonth));
|
}
|
int compareTime = 0;
|
if(yearMonth>nowTime) {
|
compareTime = 1;
|
} else if (yearMonth==nowTime) {
|
compareTime = 2;
|
} else {
|
compareTime = 3;
|
}
|
map.put("compareTime", compareTime);
|
|
allMonth.add(map);
|
}
|
System.err.println(JsonUtil.list2Json(allMonth));
|
|
return allMonth;
|
}
|
|
@Override
|
public int queryIncisatisCount(Map<String, String> params) {
|
|
StringBuilder sql = new StringBuilder();
|
sql.append("SELECT COUNT(WB.ID) ");
|
sql.append("FROM SC_WORKFLOW_INCIDENT B,WORKFLOW_BASE WB , ORDER_SATIS_INFO C WHERE C.BUSINESS_ID = WB.ID AND WB.BUSINESS_ID = B.ID ");
|
sql.append("AND WB.BUSINESSTYPE = :businessType ");
|
params.put("businessType",ConvertUtil.obj2StrBlank( Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT));
|
String orderName = params.get("name");
|
if(StringUtil.notEmpty(orderName)) {
|
sql.append(" AND WB.WFNAME LIKE :orderName ");
|
params.put("orderName", "%"+orderName+"%");
|
}
|
return baseDao.queryForInteger(sql.toString(),params);
|
}
|
|
@Override
|
public PageInfo queryIncisatisData(PageInfo pageInfo,Map<String, String> params) {
|
|
StringBuilder sql = new StringBuilder();
|
sql.append("SELECT 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("WB.CURRENT_NODE_ID,WB.CURRENT_NODE_NAME,WB.CUSTOMER_NAME,WB.PROJECT_NAME,WB.CURRENT_DEALER_NAME,WB.BUSINESS_ID,WB.WFSTATE,C.SCORE ");
|
sql.append("FROM SC_WORKFLOW_INCIDENT B,WORKFLOW_BASE WB , ORDER_SATIS_INFO C WHERE C.BUSINESS_ID = WB.ID AND WB.BUSINESS_ID = B.ID ");
|
sql.append("AND WB.BUSINESSTYPE = :businessType ");
|
params.put("businessType", ConvertUtil.obj2StrBlank(Constants.WORKFLOW_BASE_BUSINESS_TYPE_INCIDENT));
|
String orderName = params.get("name");
|
if(StringUtil.notEmpty(orderName)) {
|
sql.append(" AND WB.WFNAME LIKE :orderName ");
|
params.put("orderName", "%"+orderName+"%");
|
}
|
sql.append( " ORDER BY WB.CREATETIME DESC ");
|
return baseDao.queryforSplitPageInfo(pageInfo,sql.toString(),params);
|
}
|
|
@Override
|
public List<Map> queryZcsatisCount(String userId, String type) {
|
StringBuilder sql = new StringBuilder();
|
sql.append("SELECT C.CARD_MONTH,C.STATE FROM SC_CUSTOMER_ZC_UESR A , AUDITING_SATIS_INFO C WHERE C.USER_ID = A.USER_ID ");
|
Map paramMap = new HashMap();
|
if(!"1".equals(type)){
|
sql.append(" AND A.USER_ID = :userId ");
|
paramMap.put("userId", userId);
|
}
|
|
sql.append(" GROUP BY C.CARD_MONTH ");
|
|
return baseDao.queryForList(sql.toString(), paramMap);
|
}
|
|
@Override
|
public List queryZcsatisData(Map<String, String> params) {
|
String year = params.get("year");
|
String month = params.get("month");
|
String userId = params.get("userId");
|
String ismy = params.get("ismy");
|
StringBuilder sql = new StringBuilder();
|
sql.append("SELECT A.USER_NAME AS ALLUSER,C.*,A.CUSTOMER_ID FROM SC_CUSTOMER_ZC_UESR A , AUDITING_SATIS_INFO C WHERE C.USER_ID = A.USER_ID ");
|
Map paramMap = new HashMap();
|
|
String showmonth = year+month;
|
if(StringUtil.notEmpty(showmonth)) {
|
sql.append(" AND C.CARD_MONTH LIKE :showmonth ");
|
paramMap.put("showmonth", "%"+showmonth+"%");
|
}
|
|
if(StringUtil.notEmpty(ismy)) {
|
|
sql.append(" AND A.USER_ID = :userId ");
|
paramMap.put("userId", userId);
|
}
|
|
sql.append( " ORDER BY C.SUBMIT_TIME DESC ");
|
return baseDao.queryForList(sql.toString(),paramMap);
|
}
|
|
@Override
|
public List ewMonthCalendar(Map<String, String> params) {
|
String year = params.get("year");
|
String type = params.get("type");
|
long nowTime = DateUtil.getCurrentDate6();
|
if(!StringUtil.notEmpty(year)) {
|
year = DateUtil.getToday("yyyy");
|
}
|
//初始化月份数据
|
List<Map> allMonth = new ArrayList<Map>();
|
Map cardmsg = queryZcSatisSpCount();
|
List<Map> allcard = (List)cardmsg.get("allcard");
|
List<Map> spcard = (List)cardmsg.get("spcard");
|
Map cacheMap = new HashMap();
|
Map spcacheMap = new HashMap();
|
for(Map map:allcard){
|
cacheMap.put(map.get("CARD_MONTH"), map.get("NUM"));
|
}
|
for(Map map:spcard){
|
spcacheMap.put(map.get("CARD_MONTH"), map.get("NUM"));
|
}
|
for(int i=1;i<=12;i++) {
|
Map map = new HashMap();
|
map.put("year", year);
|
String month = i<10?("0"+i):(""+i);
|
map.put("month", month);
|
System.out.println(year+month);
|
long yearMonth = ConvertUtil.obj2Long(year+month);
|
if(!StringUtil.isEmpty(ConvertUtil.obj2StrBlank(cacheMap.get(yearMonth)))){
|
map.put("state", 1);
|
if(!StringUtil.isEmpty(ConvertUtil.obj2StrBlank(spcacheMap.get(yearMonth)))){
|
map.put("num", 1);
|
}
|
}
|
int compareTime = 0;
|
if(yearMonth>nowTime) {
|
compareTime = 1;
|
} else if (yearMonth==nowTime) {
|
compareTime = 2;
|
} else {
|
compareTime = 3;
|
}
|
map.put("compareTime", compareTime);
|
|
allMonth.add(map);
|
}
|
System.err.println(JsonUtil.list2Json(allMonth));
|
|
return allMonth;
|
}
|
|
@Override
|
public Map queryZcSatisSpCount() {
|
StringBuilder sql = new StringBuilder();
|
sql.append("SELECT C.CARD_MONTH,COUNT(A.ID) NUM FROM SC_CUSTOMER_ZC_UESR A , AUDITING_SATIS_INFO C WHERE C.USER_ID = A.USER_ID ");
|
|
sql.append(" GROUP BY C.CARD_MONTH ");
|
StringBuilder sql1 = new StringBuilder();
|
sql1.append("SELECT C.CARD_MONTH,COUNT(A.ID) NUM FROM SC_CUSTOMER_ZC_UESR A , AUDITING_SATIS_INFO C WHERE C.USER_ID = A.USER_ID AND C.STATE = 1 ");
|
|
sql1.append(" GROUP BY C.CARD_MONTH ");
|
|
List<Map> allcard = baseDao.queryForList(sql.toString());
|
List<Map> spcard = baseDao.queryForList(sql1.toString());
|
Map result = new HashMap();
|
result.put("allcard", allcard);
|
result.put("spcard", spcard);
|
return result;
|
}
|
|
}
|
