@RequestMapping(value = "/exportExcel", produces = "text/plain;charset=utf-8")
public ModelAndView exportExcel(
Page page,
HxServiceTicketVO serviceTicketVO,
HttpServletRequest request,
String tableField,
String tableHeader,
HttpServletResponse response,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_installDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_installDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_saleDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_saleDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_serviceDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_serviceDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_checkDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_checkDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_createDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_createDate_end)
throws Exception {
SysUser sysUser = (SysUser) request.getSession().getAttribute(Constrants.USER_INFO);
Map<String, Object> map = BeanMapUtils.convertBean(serviceTicketVO);
map.put("mod_installDate_st", mod_installDate_st);
map.put("mod_installDate_end", mod_installDate_end);
map.put("mod_saleDate_st", mod_saleDate_st);
map.put("mod_saleDate_end", mod_saleDate_end);
map.put("mod_serviceDate_st", mod_serviceDate_st);
map.put("mod_serviceDate_end", mod_serviceDate_end);
map.put("mod_checkDate_st", mod_checkDate_st);
map.put("mod_checkDate_end", mod_checkDate_end);
map.put("mod_createDate_st", mod_createDate_st);
map.put("mod_createDate_end", mod_createDate_end);
// 普通用户
map.put("customerType", "01");
map.put("createOrganization", hxOrganizationService.getChild(sysUser.getCompanyId()));
page.setParam(map);
List<Map<String, Object>> list = serviceTicketCreateService.getServiceTicketPageList(page);
new DecoderUtil<HxServiceTicketVO>().decodeURI(serviceTicketVO);
String header = URLDecoder.decode(tableHeader, "UTF-8");
header = header.replaceAll("<br/>", "");
ViewExcel viewExcel =
new ViewExcel(
"服务单导出" + DateUtils.formatDateTime(new Date(), DateUtils.FORMAT_THREE),
tableField,
header,
list);
return new ModelAndView(viewExcel);
}
@RequestMapping(value = "/getServiceTicketPageList", produces = "text/plain;charset=utf-8")
@ResponseBody
public String getServiceTicketPageList(
Page page,
HxServiceTicketVO serviceTicketVO,
HttpServletRequest request,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_installDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_installDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_saleDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_saleDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_serviceDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_serviceDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_checkDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_checkDate_end,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_createDate_st,
@DateTimeFormat(pattern = "yyyy-MM-dd") Date mod_createDate_end)
throws Exception {
Calendar calendar = Calendar.getInstance();
SysUser sysUser = (SysUser) request.getSession().getAttribute(Constrants.USER_INFO);
Map<String, Object> map = BeanMapUtils.convertBean(serviceTicketVO);
map.put("mod_installDate_st", mod_installDate_st);
if (mod_installDate_end != null) {
calendar.setTime(mod_installDate_end);
calendar.set(
calendar.get(Calendar.YEAR),
calendar.get(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH),
23,
59,
59);
map.put("mod_installDate_end", calendar.getTime());
}
map.put("mod_saleDate_st", mod_saleDate_st);
if (mod_saleDate_end != null) {
calendar.setTime(mod_saleDate_end);
calendar.set(
calendar.get(Calendar.YEAR),
calendar.get(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH),
23,
59,
59);
map.put("mod_saleDate_end", calendar.getTime());
}
map.put("mod_serviceDate_st", mod_serviceDate_st);
if (mod_serviceDate_end != null) {
calendar.setTime(mod_serviceDate_end);
calendar.set(
calendar.get(Calendar.YEAR),
calendar.get(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH),
23,
59,
59);
map.put("mod_serviceDate_end", calendar.getTime());
}
map.put("mod_checkDate_st", mod_checkDate_st);
if (mod_checkDate_end != null) {
calendar.setTime(mod_checkDate_end);
calendar.set(
calendar.get(Calendar.YEAR),
calendar.get(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH),
23,
59,
59);
map.put("mod_checkDate_end", calendar.getTime());
}
map.put("mod_createDate_st", mod_createDate_st);
if (mod_createDate_end != null) {
calendar.setTime(mod_createDate_end);
calendar.set(
calendar.get(Calendar.YEAR),
calendar.get(Calendar.MONTH),
calendar.get(Calendar.DAY_OF_MONTH),
23,
59,
59);
map.put("mod_createDate_end", calendar.getTime());
}
map.put("createMan", sysUser.getUserAccount());
// 普通用户
// map.put("customerType", "01");
map.put("createOrganization", hxOrganizationService.getChild(sysUser.getCompanyId()));
page.setParam(map);
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
if (!"GMZB".equals(sysUser.getCompanyId())) {
list = serviceTicketCreateService.getServiceTicketPageList(page);
} else {
list = serviceTicketCreateService.getGMZBPageList(page);
}
return JsonUtil.writeListToDataGrid(page.getTotalResult(), list);
}