/** * 展业计划列表 * * @param space * @param page * @param rows * @param request * @param session * @return */ @RequestMapping("spaceList") public @ResponseBody Pagination spaceList( Space space, String page, String rows, HttpServletRequest request, HttpSession session) { Pagination pagination = new Pagination(); if (!StringUtils.isBlank(page)) { pagination.setPage(Integer.valueOf(page)); } if (!StringUtils.isBlank(rows)) { pagination.setPageSize(Integer.valueOf(rows)); } return spaceService.spaceList(pagination, space, page, rows, request, session); }
/** * 保存登记展业计划 * * @param space * @return */ @RequestMapping("saveSpace") public @ResponseBody Message saveSpace(Space space) { Message message = new Message(); Long saveSpace = spaceService.saveSpace(space); if (saveSpace != null && saveSpace > 0) { message.setSuccess(true); message.setMsg("保存成功"); } else { message.setSuccess(false); message.setMsg("保存失败"); } return message; }
/** * 延期 * * @param value * @return */ @RequestMapping(value = "updateSpaceStud") public @ResponseBody Message updateSpaceStud(String value) { return spaceService.updateSpaceStud(value); }
@RequestMapping("downloadExcel") public void downloadExcel( HttpServletResponse response, Pagination pagination, Space space, String page, String rows, HttpServletRequest request, HttpSession session) throws Exception { // response.setContentType("application/msexcel;charset=UTF-8"); pagination.setPageSize(0); pagination = spaceService.downloadExcel(pagination, space, page, rows, request, session); List list = pagination.getRows(); // 获取数据 if (CommonUtil.isNotEmpty(list)) { String title = "执行计划列表"; String[] hearders = new String[] { "大区名字", "分中心", "所属营业部", "计划展业日期", "计划展业时间", "计划展业地点", "人员规划", "预计客户咨询量", "展业状态", "实际展业日期", "实际展业时间", "实际展业地点", "实际参与人员", "实际客户量", "提供照片数量" }; // 表头数组 String[] fields = new String[] { "REGIONNAME", "CITYDEPARTMENTNAME", "AREADEPARTMENTNAME", "SPACEDATE", "SPACETIME", "SPACEPLACE", "PERSONPLANNING", "CUSTOMERCONSULTCOUNT", "SAPCETEXT", "SPACEDATEREALITY", "SPACETIMEREALITY", "SPACEPLACEREALITY", "PARTICIPANTSREALITY", "CUSTOMERCONSULTCOUNTREALITY", "PHOTOCOUNT" }; // 对象属性数组 TableData td = ExcelUtils.createTableData(list, ExcelUtils.createTableHeader(hearders), fields); // JsGridReportBase report = new JsGridReportBase(request, response); jsGridReportBaseXLSXService.jsGridReportBaseXLSXService(request, response); jsGridReportBaseXLSXService.exportToExcel( title, SpringSecurityUtils.getCurrentUserName(), td); } else { String title = "执行计划列表"; String[] hearders = new String[] { "大区名字", "分中心", "所属营业部", "计划展业日期", "计划展业日期", "计划展业时间", "计划展业地点", "人员规划", "预计客户咨询量", "展业状态", "实际展业日期", "实际展业时间", "实际展业地点", "实际参与人员", "实际客户量", "提供照片数量" }; // 表头数组 Space cu = new Space(); list.add(cu); String[] fields = new String[] {}; // 对象属性数组 TableData td = ExcelUtils.createTableData(list, ExcelUtils.createTableHeader(hearders), fields); /* JsGridReportBase report = new JsGridReportBase(request, response); report.exportToExcel(title, SpringSecurityUtils.getCurrentUserName(), td);*/ jsGridReportBaseXLSXService.jsGridReportBaseXLSXService(request, response); jsGridReportBaseXLSXService.exportToExcel( title, SpringSecurityUtils.getCurrentUserName(), td); } }
/** * 保存展业计划 * * @param space * @return */ @RequestMapping("saveExecuteSpace") public @ResponseBody Message saveExecuteSpace(Space space) { return spaceService.saveExecuteSpace(space); }