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.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.core.web.WebUtil;
|
|
@Service("ewWorkplanFacade")
|
public class EwWorkplanFacadeImpl implements EwWorkplanFacade {
|
|
@Autowired
|
private BaseDao baseDao;
|
|
@Override
|
public Map queryDailyCalandar(Map<String, String> params) {
|
String year = params.get("year");
|
String month = params.get("month");
|
String cusId = params.get("cusId");
|
|
if(!StringUtil.notEmpty(year)) {
|
year = DateUtil.getToday("yyyy");
|
}
|
if(!StringUtil.notEmpty(month)) {
|
month = DateUtil.getToday("MM");
|
}
|
|
String time = new String();
|
long nMonth = DateUtil.getCurrentDate6();
|
String yearMonth = year+month;
|
if(String.valueOf(nMonth).equals(yearMonth)) {
|
time = DateUtil.getToday("yyyyMMdd");
|
} else {
|
time = yearMonth+"01";
|
}
|
|
//所在周的前一个周日和后一个周六
|
Long[] sunSat = DateUtil.getSundaySaturday(Long.valueOf(time));
|
|
List<String> weekDays = DateUtil.getBetweenTwoDateCycleList(String.valueOf(sunSat[0]), String.valueOf(sunSat[1]), 2, 1, "yyyyMMdd", "yyyyMMdd");
|
|
|
//查询该月的第一天和最后一天
|
String[] dates = StringUtil.queryFirstLastDate(year,month);
|
//查询第一天属于周几
|
long firstDay = ConvertUtil.obj2Long(dates[0].replaceAll("-", ""));
|
long endDay = ConvertUtil.obj2Long(dates[1].replaceAll("-", ""));
|
int week = DateUtil.getDayOfWeek(firstDay);
|
|
List<String> allDate = new ArrayList<String>();
|
for(int i=week; i>0; i--) {
|
allDate.add(ConvertUtil.obj2StrBlank(DateUtil.getDateAdd(firstDay, -i, 8)));
|
}
|
|
List<String> list = new ArrayList<String>();
|
list = DateUtil.getBetweenTwoDateList(ConvertUtil.obj2StrBlank(firstDay), ConvertUtil.obj2StrBlank(endDay), 2, "yyyyMMdd");
|
|
for(String str : list) {
|
allDate.add(str.replaceAll("-", ""));
|
}
|
|
int lastSize = 42-allDate.size();
|
for(int i=1; i<=lastSize; i++) {
|
allDate.add(ConvertUtil.obj2StrBlank(DateUtil.getDateAdd(endDay, i, 8)));
|
}
|
|
|
Map paramMap = new HashMap();
|
List<Map> reportList = new ArrayList<Map>();
|
StringBuilder builder = new StringBuilder();
|
builder.append(" SELECT COUNT(PATROL_DATE) AS NUM,PATROL_DATE AS REPORT_DATE FROM CI_DAILY_PATROL WHERE PATROL_DATE >= :beginTime AND PATROL_DATE <= :endTime ");
|
|
paramMap.put("beginTime", allDate.get(0));
|
paramMap.put("endTime", allDate.get(allDate.size()-1));
|
|
if(StringUtil.isNotBlank(params.get("userId"))) {
|
builder.append(" AND USER_ID=:userId ");
|
paramMap.put("userId", params.get("userId"));
|
}
|
|
if(StringUtil.isNotBlank(cusId)){
|
builder.append(" AND CUS_ID = :cusId ");
|
paramMap.put("cusId", cusId);
|
}
|
|
builder.append(" GROUP BY PATROL_DATE ORDER BY PATROL_DATE DESC ");
|
reportList = baseDao.queryForList(builder.toString(),paramMap);
|
|
Map cacheMap = new HashMap();
|
for(Map map : reportList) {
|
cacheMap.put(map.get("REPORT_DATE"), map);
|
}
|
|
List resultList = new ArrayList();
|
List weekList = new ArrayList();
|
|
String today = DateUtil.getToday("yyyyMMdd");
|
for(String str : allDate) {
|
long strLong = ConvertUtil.obj2Long(str);
|
if(cacheMap.containsKey(strLong)) {
|
Map map = (Map)cacheMap.get(strLong);
|
//判断当天是否已经巡检过
|
map.put("isCheck", 1);
|
|
//判断是不是当月,如果不是当月当月颜色不一致
|
String nowMonth = DateUtil.format("MM", str);
|
if(month.equals(nowMonth)) {
|
map.put("nowMonth", 1);
|
} else {
|
map.put("nowMonth", 2);
|
}
|
//展示的日期（天）
|
map.put("showMonth", DateUtil.format("dd", str));
|
|
//查询是否是当天之前
|
|
|
if(str.equals(today)) {
|
map.put("isTody", "1");
|
} else {
|
if(ConvertUtil.obj2Long(today)>ConvertUtil.obj2Long(str)) {
|
map.put("isTody", "2");
|
} else {
|
map.put("isTody", "0");
|
}
|
}
|
|
if(weekDays.contains(str)) {
|
weekList.add(map);
|
}
|
|
resultList.add(map);
|
} else {
|
Map map = new HashMap();
|
map.put("isCheck", 2);
|
map.put("REPORT_DATE", str);
|
String nowMonth = DateUtil.format("MM", str);
|
if(month.equals(nowMonth)) {
|
map.put("nowMonth", 1);
|
} else {
|
map.put("nowMonth", 2);
|
}
|
map.put("showMonth", DateUtil.format("dd", str));
|
if(str.equals(today)) {
|
map.put("isTody", "1");
|
} else {
|
if(ConvertUtil.obj2Long(today)>ConvertUtil.obj2Long(str)) {
|
map.put("isTody", "2");
|
} else {
|
map.put("isTody", "0");
|
}
|
}
|
resultList.add(map);
|
|
if(weekDays.contains(str)) {
|
weekList.add(map);
|
}
|
}
|
}
|
|
Map resultMap = new HashMap();
|
resultMap.put("monthDays", resultList);
|
resultMap.put("weekDays", weekList);
|
|
return resultMap;
|
}
|
|
@Override
|
public List<Map> queryMyReportByDate(Map<String, String> params) {
|
String selectSql = new String();
|
SqlParameter paramMap = new SqlParameter("userId",params.get("userId"));
|
String beginDate = params.get("beginDate");
|
String endDate = params.get("endDate");
|
|
if(!StringUtil.notEmpty(endDate)) {
|
endDate = beginDate;
|
}
|
if(beginDate.equals(endDate)) {
|
selectSql = "SELECT * FROM CI_DAILY_PATROL WHERE USER_ID=:userId AND PATROL_DATE = :date ";
|
paramMap.put("date", beginDate);
|
} else {
|
selectSql = "SELECT * FROM CI_DAILY_PATROL WHERE USER_ID=:userId AND PATROL_DATE BETWEEN :beginTime AND :endTime ORDER BY PATROL_DATE DESC ";
|
paramMap.put("beginTime", beginDate);
|
paramMap.put("endTime", endDate);
|
}
|
|
String cusId = params.get("cusId");
|
if(StringUtil.notEmpty(cusId)) {
|
selectSql += " AND CUS_ID = :cusId";
|
paramMap.put("cusId", cusId);
|
}
|
List<Map> reports = baseDao.queryForList(selectSql,paramMap);
|
return reports;
|
}
|
|
@Override
|
public List<Map> queryReportByDate(Map<String, String> params) {
|
StringBuilder builder = new StringBuilder();
|
SqlParameter paramMap = new SqlParameter();
|
String beginDate = params.get("beginDate");
|
String endDate = params.get("endDate");
|
if(!StringUtil.notEmpty(endDate)) {
|
endDate = beginDate;
|
}
|
|
if(beginDate.equals(endDate)) {
|
builder = new StringBuilder("SELECT * FROM CI_DAILY_PATROL WHERE PATROL_DATE = :date ");
|
paramMap.put("date", beginDate);
|
} else {
|
builder = new StringBuilder("SELECT * FROM CI_DAILY_PATROL WHERE PATROL_DATE BETWEEN :beginTime AND :endTime ");
|
paramMap.put("beginTime", beginDate);
|
paramMap.put("endTime", endDate);
|
}
|
|
String cusId = params.get("cusId");
|
if(StringUtil.notEmpty(cusId)) {
|
builder.append(" AND CUS_ID = :cusId");
|
paramMap.put("cusId", cusId);
|
}
|
builder.append(" ORDER BY PATROL_DATE DESC ");
|
List<Map> reports = baseDao.queryForList(builder.toString(),paramMap);
|
return reports;
|
}
|
|
|
|
}
|
