package com.tourmade.crm.action;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import com.tourmade.crm.common.action.BaseSimpleFormController;
import com.tourmade.crm.common.framework.bean.QueryResult;
import com.tourmade.crm.common.framework.util.JSONUtilS;
import com.tourmade.crm.common.model.base.value.baseconfig.PageHelper;
import com.tourmade.crm.csv.CSVUtil;
import com.tourmade.crm.entity.AgencyAchievementStats;
import com.tourmade.crm.entity.AgencyOrderStatus;
import com.tourmade.crm.entity.CaseAllotStats;
import com.tourmade.crm.entity.CaseSourceStats;
import com.tourmade.crm.entity.ContactRealStats;
import com.tourmade.crm.entity.CustomerSourceLevelStats;
import com.tourmade.crm.entity.EntityList;
import com.tourmade.crm.entity.ReasonOfDrainingStats;
import com.tourmade.crm.entity.SellerCoverStats;
import com.tourmade.crm.entity.SellerNotAskStats;
import com.tourmade.crm.entity.SellerNotAskStatsD;
import com.tourmade.crm.entity.UserAchRate;
import com.tourmade.crm.entity.UserAchievement;
import com.tourmade.crm.service.StatisticsService;
import net.sf.json.JSONArray;
/**
* 统计分析类
*
* @author fjw
*
*/
@Controller
@RequestMapping("/statistics")
public class StatisticsController extends BaseSimpleFormController {
@Autowired
private StatisticsService service;
/**
* 跟单员询单状态统计
*
* @param model
* @return
*/
@RequestMapping(value = "/usercasestatusstats.html", method = { RequestMethod.POST, RequestMethod.GET })
public String userAchievementStatsView(Model model) {
String source = "case.source";
List<EntityList> sourceList = service.getParameterInfo(source);
JSONArray sourceResult = JSONArray.fromObject(sourceList);
model.addAttribute("source", sourceResult);
model.addAttribute("startTime", getLastMothFirstDay());
model.addAttribute("endTime", getLastMothLastDay());
return "/statistics/userCaseStatusStats";
}
/**
* 跟单员dateTables请求
*
* @param request
* @param session
* @param model
* @param customerId
* @param page
* @return
*/
@RequestMapping(value = "/usercasestatusstats.do", produces = "application/json;charset=utf-8")
@ResponseBody
public String queryData(PageHelper page, String startCreateDateTime, String endCreateDateTime, String source) {
QueryResult<UserAchievement> userAchievementList = queryUserCaseStatusMethod(startCreateDateTime,
endCreateDateTime, source);
String result = JSONUtilS.object2json(userAchievementList);
return result;
}
public QueryResult<UserAchievement> queryUserCaseStatusMethod(String startCreateDateTime, String endCreateDateTime,
String source) {
// 设置查询参数
Map<String, Object> map = new HashMap<>();
map.put("source", source);
if (startCreateDateTime == null || startCreateDateTime.trim() == "") {
startCreateDateTime = getLastMothFirstDay();
}
if (endCreateDateTime == null || endCreateDateTime.trim() == "") {
endCreateDateTime = getLastMothLastDay();
}
map.put("startCreateTime", startCreateDateTime + " 00:00:00");
map.put("endCreateTime", endCreateDateTime + " 23:59:59");
QueryResult<UserAchievement> userAchievementList = service.queryUserAchievementStats(map);
QueryResult<UserAchievement> userAchievementList2 = service.queryUserAchievementStatsTotal(map);
List<UserAchievement> data = userAchievementList2.getData();
data.get(0).setUserName("合计");
userAchievementList.getData().addAll(data);
return userAchievementList;
}
/**
* 返回沟通方式统计界面
*
* @param model
* @return
*/
@RequestMapping(value = "/contactrealstats.html", method = { RequestMethod.POST, RequestMethod.GET })
public String contactRealStatsView(Model model) {
model.addAttribute("startTime", getLastMothFirstDay());
model.addAttribute("endTime", getLastMothLastDay());
return "/statistics/contactRealStats";
}
/**
* 沟通方式请求方法
*
* @param page
* @param startCreateDateTime
* @param endCreateDateTime
* @return
*/
@RequestMapping(value = "/contactrealstats.do", produces = "application/json;charset=utf-8")
@ResponseBody
public String queryContactReal(PageHelper page, String startCreateDateTime, String endCreateDateTime) {
QueryResult<ContactRealStats> contactRealList = queryContactRealMethod(startCreateDateTime, endCreateDateTime);
String result = JSONUtilS.object2json(contactRealList);
return result;
}
public QueryResult<ContactRealStats> queryContactRealMethod(String startCreateDateTime, String endCreateDateTime) {
// 设置查询参数
Map<String, Object> map = new HashMap<>();
if (startCreateDateTime == null || startCreateDateTime.trim() == "") {
startCreateDateTime = getLastMothFirstDay();
}
if (endCreateDateTime == null || endCreateDateTime.trim() == "") {
endCreateDateTime = getLastMothLastDay();
}
map.put("startCreateTime", startCreateDateTime + " 00:00:00");
map.put("endCreateTime", endCreateDateTime + " 23:59:59");
QueryResult<ContactRealStats> contactRealList = service.queryContactReal(map);
QueryResult<ContactRealStats> contactRealList2 = service.queryContactRealTotal(map);
List<ContactRealStats> data = contactRealList2.getData();
data.get(0).setContactName("合计");
contactRealList.getData().addAll(data);
return contactRealList;
}
/**
* 返回流失原因界面
*
* @param model
* @return
*/
@RequestMapping(value = "/reasonofdrainingstats.html", method = { RequestMethod.POST, RequestMethod.GET })
public String reasonOfDrainingView(Model model) {
model.addAttribute("startTime", getLastMothFirstDay());
model.addAttribute("endTime", getLastMothLastDay());
return "/statistics/reasonOfDrainingStats";
}
/**
* 无效原因dataTables请求
*
* @param model
* @return
*/
@RequestMapping(value = "/reasonofdrainingstats1.do", produces = "application/json;charset=utf-8")
@ResponseBody
public String queryReasonOfDraining1(PageHelper page, String startCreateDateTime, String endCreateDateTime) {
QueryResult<ReasonOfDrainingStats> contactRealList = queryReasonOfDraining1Method(startCreateDateTime,
endCreateDateTime);
String result = JSONUtilS.object2json(contactRealList);
return result;
}
public QueryResult<ReasonOfDrainingStats> queryReasonOfDraining1Method(String startCreateDateTime,
String endCreateDateTime) {
// 设置查询参数
Map<String, Object> map = new HashMap<>();
if (startCreateDateTime == null || startCreateDateTime.trim() == "") {
startCreateDateTime = getLastMothFirstDay();
}
if (endCreateDateTime == null || endCreateDateTime.trim() == "") {
endCreateDateTime = getLastMothLastDay();
}
map.put("startCreateTime", startCreateDateTime + " 00:00:00");
map.put("endCreateTime", endCreateDateTime + " 23:59:59");
QueryResult<ReasonOfDrainingStats> contactRealList = service.queryReasonOfDraining(map);
QueryResult<ReasonOfDrainingStats> contactRealList2 = service.queryReasonOfDrainingTotal(map);
List<ReasonOfDrainingStats> data = contactRealList2.getData();
data.get(0).setReasonOfDrainingName("合计");
contactRealList.getData().addAll(data);
return contactRealList;
}
/**
* 未成行原因dataTables请求
*
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
毕业设计基于java实现智能医院挂号系统源码.zip 毕业设计基于java实现智能医院挂号系统源码.zip 毕业设计基于java实现智能医院挂号系统源码.zip 毕业设计基于java实现智能医院挂号系统源码.zip 毕业设计基于java实现智能医院挂号系统源码.zip 毕业设计基于java实现智能医院挂号系统源码.zip
资源推荐
资源详情
资源评论
![thumb](https://img-home.csdnimg.cn/images/20210720083646.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![py](https://img-home.csdnimg.cn/images/20210720083646.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
共 758 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/8b9566d6b7ee402eb11b3ab031c6660f_fl1768317420.jpg!1)
FL1768317420
- 粉丝: 4993
- 资源: 5729
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)