/**
  * 展业计划列表
  *
  * @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);
 }