package cn.ksource.web.controller.business.pages.customermanage;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestMethod;
|
import org.springframework.web.servlet.ModelAndView;
|
|
import cn.ksource.beans.SC_PARTNER_CUSTOMER_INFO;
|
import cn.ksource.core.page.PageInfo;
|
import cn.ksource.core.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.ParamsMapUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.core.web.SysInfo;
|
import cn.ksource.core.web.WebUtil;
|
import cn.ksource.web.Constants;
|
import cn.ksource.web.facade.JsglFacade;
|
import cn.ksource.web.facade.customermanage.CustomerManageFacade;
|
import cn.ksource.web.service.DataDictionaryService;
|
import cn.ksource.web.service.file.FileService;
|
import cn.ksource.web.util.ExcelSupport;
|
import cn.ksource.web.util.ExcelUtil;
|
|
|
/**
|
* 基础管理--客户管理--客户信息控制器
|
* @author lixiang
|
* */
|
@Controller
|
@RequestMapping("/business/pages/customermanage")
|
public class CustomerManageController {
|
|
@Autowired
|
private CustomerManageFacade customerManageFacade;
|
|
@Autowired
|
private JsglFacade jsglFacade;
|
|
@Autowired
|
private DataDictionaryService dataDictionaryService;
|
|
@Autowired
|
private FileService fileService;
|
|
/**
|
* 客户信息列表
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping("customerManageList.html")
|
public ModelAndView getCustomerList(HttpServletRequest request,HttpServletResponse response){
|
ModelAndView view = new ModelAndView("/business/pages/customermanage/customerManageList");
|
//查询事件类型数据字典
|
List types = dataDictionaryService.getDataDictionaryByCategoryKey(Constants.INCIDENT_TYPE);
|
view.addObject("types", types);
|
//查询该加盟商的事件优先级
|
List<Map> eventPri = dataDictionaryService.getDataDictionaryByCategoryKey(Constants.EVENT_PRI);
|
view.addObject("eventPri", eventPri);
|
//查询事件影响度数据字典
|
List<Map> eventDg = dataDictionaryService.getDataDictionaryByCategoryKey(Constants.EVENT_EFFECT_DG);
|
view.addObject("eventDg", eventDg);
|
return view;
|
}
|
|
/**
|
* 查询客户列表
|
*/
|
@RequestMapping(value="customerData.html",method=RequestMethod.POST)
|
public ModelAndView customerData(HttpServletRequest request,PageInfo pageInfo) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/customerData");
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
PageInfo info = customerManageFacade.queryCustomerData(params,pageInfo);
|
modelAndView.addObject("info", info);
|
return modelAndView;
|
}
|
|
|
/**
|
* 查询客户列表总数量
|
*/
|
@RequestMapping(value="customerCount.html",method=RequestMethod.POST)
|
public void customerCount(HttpServletRequest request,HttpServletResponse response) {
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
int count = customerManageFacade.queryCustomerCount(params);
|
WebUtil.write(response, String.valueOf(count));
|
}
|
|
/**
|
* 跳转到添加或者修改页面
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping(value = "customerManageAdd.html", method = RequestMethod.GET)
|
public ModelAndView partnerMsgAdd(HttpServletRequest request, HttpServletResponse response) {
|
String id = request.getParameter("id");
|
List users = jsglFacade.getUsersByRoleKey(Constants.ROLE_OPERATION);
|
List<Map> hangyeList = dataDictionaryService.getDataDictionaryByCategoryKey("INDUSTRY_TYPE");//行业
|
ModelAndView view= new ModelAndView("/business/pages/customermanage/customerManageAdd");
|
if(StringUtil.isBlank(id)){
|
view.addObject("partner", new SC_PARTNER_CUSTOMER_INFO());
|
}else{
|
Map map = customerManageFacade.getPartnerCostomerById(id);
|
view.addObject("partner", map);
|
view.addObject("customerFiles", fileService.getFileList(id));
|
}
|
view.addObject("hangye",hangyeList);
|
view.addObject("users",users);
|
return view;
|
}
|
|
/**
|
* 添加/修改客户信息
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequestMapping(value="customerManageAdd.html", method=RequestMethod.POST)
|
public ModelAndView addIncidentForDeskSubmit(HttpServletRequest request, HttpServletResponse response,SC_PARTNER_CUSTOMER_INFO sc_partner_info) {
|
customerManageFacade.addPartnerCustomer(sc_partner_info,request);
|
return WebUtil.sysInfoPage(request, "操作成功！",
|
"window.top.query();window.top.hideDialog(0);",
|
SysInfo.Success,"");
|
}
|
|
/**
|
* 获取客户拥有的账号数量
|
* @param request
|
* @param response
|
*/
|
@RequestMapping("getCustomerCount.html")
|
public void getUserCount(HttpServletRequest request,HttpServletResponse response){
|
if (customerManageFacade.getCustomerCount(request)) {
|
WebUtil.write(response, "1");
|
} else {
|
WebUtil.write(response, "0");
|
}
|
}
|
|
/**
|
* 客户状态修改
|
* @param request
|
* @param response
|
*/
|
@RequestMapping("updateStatus.html")
|
public void updateStatus(HttpServletRequest request,HttpServletResponse response) {
|
customerManageFacade.updateStatus(request);
|
WebUtil.write(response, "1");
|
}
|
|
/**
|
* 检查客户编号是否存在
|
* */
|
@RequestMapping("checkCusCode.html")
|
public void checkCusCode(HttpServletRequest request,HttpServletResponse response) {
|
String id=request.getParameter("id");
|
String result = customerManageFacade.checkCusCodeTwo(request.getParameter("code"),id);
|
WebUtil.write(response, result);
|
}
|
|
|
/**
|
* 跳转到客户详情界面
|
*/
|
@RequestMapping("customerinfo.html")
|
public ModelAndView customerDetail(HttpServletRequest request,HttpServletResponse response) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/customerinfo");
|
|
//查询客户基本信息
|
String id = request.getParameter("customerId");
|
if(StringUtil.notEmpty(id)) {
|
Map baseMsg = customerManageFacade.queryCustomerBaseMsg(id);
|
modelAndView.addObject("baseMsg", baseMsg);
|
|
//查询子账号信息
|
List subs = customerManageFacade.queryCtmChildAcountList(id);
|
modelAndView.addObject("subs", subs);
|
}
|
return modelAndView;
|
}
|
|
|
|
/**
|
* 查询客户工单
|
*/
|
@RequestMapping("customerorder.html")
|
public ModelAndView proplinkorder(HttpServletRequest request,HttpServletResponse response) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/customerorder");
|
//查询客户基本信息
|
String id = request.getParameter("customerId");
|
if(StringUtil.notEmpty(id)) {
|
Map baseMsg = customerManageFacade.queryCustomerBaseMsg(id);
|
modelAndView.addObject("baseMsg", baseMsg);
|
}
|
return modelAndView;
|
}
|
|
/**
|
* 查询关联工单数据
|
*/
|
@RequestMapping("customerOrderData.html")
|
public ModelAndView proplinkorderData(HttpServletRequest request,PageInfo pageInfo) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/customerOrderData");
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
//查询设备关联工单
|
PageInfo orders = customerManageFacade.queryCustomerOrder(pageInfo,params);
|
modelAndView.addObject("orders", orders);
|
return modelAndView;
|
}
|
|
/**
|
* 查询关联工单数量
|
*/
|
@RequestMapping("customerOrderCount.html")
|
public void proplinkorderCount(HttpServletRequest request,HttpServletResponse response) {
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
//查询设备关联工单
|
int count = customerManageFacade.queryCustomerOrderCount(params);
|
WebUtil.write(response, String.valueOf(count));
|
}
|
|
|
/**
|
* 查询客户的维保设备
|
*/
|
@RequestMapping("wbsb.html")
|
public ModelAndView wbsb(HttpServletRequest request,HttpServletResponse response) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/wbsb");
|
//查询客户基本信息
|
String id = request.getParameter("customerId");
|
if(StringUtil.notEmpty(id)) {
|
Map baseMsg = customerManageFacade.queryCustomerBaseMsg(id);
|
modelAndView.addObject("baseMsg", baseMsg);
|
|
//查询设备三级分类
|
List categorys = customerManageFacade.queryDeviceMsg(id);
|
modelAndView.addObject("categorys", categorys);
|
|
}
|
return modelAndView;
|
}
|
|
|
/**
|
* 查询客户设备
|
*/
|
@RequestMapping("catedevices.html")
|
public ModelAndView catedevices(HttpServletRequest request) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/catedevices");
|
String id = request.getParameter("customerId");
|
if(StringUtil.notEmpty(id)) {
|
Map baseMsg = customerManageFacade.queryCustomerBaseMsg(id);
|
modelAndView.addObject("baseMsg", baseMsg);
|
}
|
return modelAndView;
|
}
|
|
|
/**
|
* 查询客户设备数据
|
*/
|
@RequestMapping("cateDeviceData.html")
|
public ModelAndView cateDeviceData(HttpServletRequest request,PageInfo pageInfo) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/cateDeviceData");
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
//查询客户设备数据
|
PageInfo devices = customerManageFacade.queryCateDeviceData(pageInfo,params);
|
modelAndView.addObject("devices", devices);
|
return modelAndView;
|
}
|
|
/**
|
* 查询关联工单数量
|
*/
|
@RequestMapping("cateDeviceCount.html")
|
public void cateDeviceCount(HttpServletRequest request,HttpServletResponse response) {
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
//查询设备数量
|
int count = customerManageFacade.queryCateDeviceCount(params);
|
WebUtil.write(response, String.valueOf(count));
|
}
|
|
|
/*
|
@Resource(name="ciHealthPlanFacade")
|
private CiHealthPlanFacade ciHealthPlanFacade;*/
|
/**
|
* 跳转到客户巡检计划(巡检计划报表)页面
|
*/
|
@RequestMapping("planRp.html")
|
public ModelAndView dutyerRp(HttpServletRequest request,HttpServletResponse response) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/planRp");
|
|
//Map report = ciHealthPlanFacade.planReport(request);
|
|
String year = request.getParameter("year");
|
if(!StringUtil.notEmpty(year)) {
|
year = DateUtil.getToday("yyyy");
|
}
|
//modelAndView.addObject("report", report);
|
modelAndView.addObject("year", year);
|
|
String customerId = request.getParameter("customerId");
|
|
SC_PARTNER_CUSTOMER_INFO info = new SC_PARTNER_CUSTOMER_INFO(customerId).getInstanceById();
|
modelAndView.addObject("customerName", info.getCustomer_name());
|
|
modelAndView.addObject("today", DateUtil.getCurrentDate8());
|
|
return modelAndView;
|
}
|
|
|
|
/**
|
* 跳转到日常巡检列表
|
*/
|
@RequestMapping("rcxj.html")
|
public ModelAndView rcxj(HttpServletRequest request,HttpServletResponse response) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/rcxj");
|
String id = request.getParameter("customerId");
|
if(StringUtil.notEmpty(id)) {
|
Map baseMsg = customerManageFacade.queryCustomerBaseMsg(id);
|
modelAndView.addObject("baseMsg", baseMsg);
|
}
|
return modelAndView;
|
}
|
|
|
/**
|
* 查询日常巡检列表数据
|
*/
|
@RequestMapping("rcxjData.html")
|
public ModelAndView rcxjData(HttpServletRequest request,PageInfo pageInfo) {
|
ModelAndView modelAndView = new ModelAndView("/business/pages/customermanage/rcxjData");
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
PageInfo xjs = customerManageFacade.queryXjReportData(pageInfo,params);
|
modelAndView.addObject("xjs", xjs);
|
return modelAndView;
|
}
|
|
|
|
/**
|
* 查询日常巡检总数量
|
*/
|
@RequestMapping("rcxjCount.html")
|
public void rcxjCount(HttpServletRequest request,HttpServletResponse response) {
|
Map<String,String> params = ParamsMapUtil.getParameterMap(request);
|
int count = customerManageFacade.queryXjReportCount(params);
|
WebUtil.write(response, String.valueOf(count));
|
}
|
/**
|
* 导出
|
* @param request
|
* @param response
|
* @param dto
|
*/
|
@SuppressWarnings({ "unchecked", "rawtypes" })
|
@RequestMapping("/exportCustomerName.html")
|
public void export(HttpServletRequest request, HttpServletResponse response) {
|
Map param=ParamsMapUtil.getParameterMap(request);
|
param.put("beginTime", ConvertUtil.obj2Str(param.get("valid_begin_date")));
|
param.put("endTime", ConvertUtil.obj2Str(param.get("valid_end_date")));
|
param.put("cusName", ConvertUtil.obj2Str(param.get("cusName")));
|
param.put("state", ConvertUtil.obj2Str(param.get("state")));
|
List<Map> list=customerManageFacade.queryCustomerDataList(param);
|
if(list.size()>0){
|
for(Map map:list){
|
map.put("CREATE_TIME", DateUtil.format("yyyy-MM-dd HH:mm:ss",map.get("CREATE_TIME")));
|
if(ConvertUtil.obj2Str(map.get("CUSTOMER_STATE")).equals("1")){
|
map.put("CUSTOMER_STATE", "启用");
|
}else{
|
map.put("CUSTOMER_STATE", "禁用");
|
}
|
}
|
}
|
List<ExcelSupport> excelSupportList = new ArrayList<ExcelSupport>();
|
ExcelSupport excelSupport1 = new ExcelSupport("项目名称", "CUSTOMER_NAME");
|
ExcelSupport excelSupport2 = new ExcelSupport("项目简称", "SHORT_NAME");
|
ExcelSupport excelSupport3 = new ExcelSupport("手机", "PHONE");
|
ExcelSupport excelSupport4 = new ExcelSupport("开通时间", "CREATE_TIME");
|
ExcelSupport excelSupport5 = new ExcelSupport("状态", "CUSTOMER_STATE");
|
ExcelSupport excelSupport6 = new ExcelSupport("所属省", "PROVINCE_NAME");
|
ExcelSupport excelSupport7 = new ExcelSupport("所属市", "CITY_NAME");
|
ExcelSupport excelSupport8 = new ExcelSupport("所属县名称", "COUNTY_NAME");
|
ExcelSupport excelSupport9 = new ExcelSupport("详细地址", "ADDRESS");
|
ExcelSupport excelSupport10 = new ExcelSupport("所属行业名称", "INDUSTRY_NAME");
|
ExcelSupport excelSupport11 = new ExcelSupport("创建人姓名", "CREATE_USER_NAME");
|
ExcelSupport excelSupport12 = new ExcelSupport("联系人", "CONTACT");
|
ExcelSupport excelSupport13 = new ExcelSupport("联系人电话", "PHONE");
|
ExcelSupport excelSupport14 = new ExcelSupport("邮箱", "EMAIL");
|
ExcelSupport excelSupport15 = new ExcelSupport("项目编码", "CUSTOMER_CODE");
|
ExcelSupport excelSupport16 = new ExcelSupport("运维经理名称", "YWJL_NAME");
|
excelSupportList.add(excelSupport1);
|
excelSupportList.add(excelSupport2);
|
excelSupportList.add(excelSupport3);
|
excelSupportList.add(excelSupport4);
|
excelSupportList.add(excelSupport5);
|
excelSupportList.add(excelSupport6);
|
excelSupportList.add(excelSupport7);
|
excelSupportList.add(excelSupport8);
|
excelSupportList.add(excelSupport9);
|
excelSupportList.add(excelSupport10);
|
excelSupportList.add(excelSupport11);
|
excelSupportList.add(excelSupport12);
|
excelSupportList.add(excelSupport13);
|
excelSupportList.add(excelSupport14);
|
excelSupportList.add(excelSupport15);
|
excelSupportList.add(excelSupport16);
|
try {
|
ExcelUtil.exportExcel(excelSupportList, list, response, "项目信息导出");
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
|
|
}
|
