コード例 #1
0
  @RequestMapping(value = "queryAccountInformationChangeList")
  public @ResponseBody Pagination queryAccountInformationChangeList(
      @RequestParam(required = false) String page,
      @RequestParam(required = false) String rows,
      HttpSession session,
      String paramJsonMap,
      String sort,
      String order) {
    Pagination pagination = new Pagination();
    if (!StringUtils.isBlank(page)) {
      pagination.setPage(Integer.valueOf(page));
    }
    if (!StringUtils.isBlank(rows)) {
      pagination.setPageSize(Integer.valueOf(rows));
    }
    // 添加权限查询
    List<String> authList = SpringSecurityUtils.getAuthList(session);
    String sqlsid = "";
    if (authList.size() > 0) {
      for (String e : authList) {
        if (sqlsid != null) {
          sqlsid = sqlsid + "'" + e + "'" + ",";
        } else {
          sqlsid = "'" + e + "'" + ",";
        }
      }
      sqlsid = sqlsid.substring(0, sqlsid.length() - 1);
    }

    System.out.println(sqlsid);
    System.out.println(sqlsid);
    System.out.println(sqlsid);
    System.out.println(sqlsid);
    Map<String, String> pramMap = new HashMap<String, String>();

    pramMap.put("authList", sqlsid);
    pramMap.put("sort", sort);
    pramMap.put("order", order);

    if (!"".equals(paramJsonMap) && paramJsonMap != null) {
      Map<String, String> temp = JsonUtil.getObject(paramJsonMap);
      String businessNumber = temp.get("businessNumber");
      String name = temp.get("name");
      pramMap.put("businessNumber", businessNumber);
      pramMap.put("name", name);
    }

    pagination = modifyCatdAppService.queryAccountInformationChangeList(pagination, pramMap);

    return pagination;
  }
コード例 #2
0
 @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);
   }
 }