// 分页数量
 @Action(
     value = "count_invigilators",
     results = {
       @Result(
           type = "json",
           name = "success",
           params = {"contentType", "text/json"})
     })
 public String count() {
   try {
     result.setRecordCount(invigilatorbiz.findInvigilatorPageCount(invigilator, result));
   } catch (Exception e) {
     e.printStackTrace();
   }
   return SUCCESS;
 }
예제 #2
0
 // 分页数量
 @Action(
     value = "count_examroom",
     results = {
       @Result(
           type = "json",
           name = "success",
           params = {"contentType", "text/json"})
     })
 public String count() {
   try {
     result.setRecordCount(examroombiz.findExamRoomPageCount(examroom, result));
   } catch (Exception e) {
     e.printStackTrace();
   }
   return SUCCESS;
 }
 // 条件查询
 @Action(
     value = "findByconditions_invigilators",
     results = {
       @Result(
           type = "json",
           name = "success",
           params = {"contentType", "text/json"})
     })
 public String findByconditions() {
   try {
     result.setList(invigilatorbiz.findByConditions(invigilator, result));
   } catch (Exception e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   }
   return "success";
 }
예제 #4
0
 @Action(
     value = "list_examroom",
     results = {
       @Result(
           type = "json",
           name = "success",
           params = {"contentType", "text/json"})
     })
 public String executes() {
   try {
     result.setList(examroombiz.page(result));
   } catch (Exception e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
   }
   return "success";
 }
예제 #5
0
  /*
   * 查询显示行数
   */
  @Action(
      value = "count_invoice",
      results = {
        @Result(
            type = "json",
            name = "success",
            params = {"contentType", "text/json"})
      })
  public String count() {
    try {
      result.setRecordCount(invoiceBiz.findInvoicePageCountByConditions(invoice, result));

    } catch (Exception e) {
      e.printStackTrace();
      return INPUT;
    }
    return SUCCESS;
  }
예제 #6
0
  // @SuppressWarnings("unchecked")
  @Action(
      value = "list_invoice",
      results = {
        @Result(
            name = "success",
            type = "json",
            params = {"contentType", "text/json"})
      })
  public String execute() throws Exception {

    try {
      list = invoiceBiz.findInvoicePageListByConditions(invoice, result);
      result.setList(list);
    } catch (Exception e) {
      e.printStackTrace();
    }
    return SUCCESS;
  }
  /**
   * 导出学生集合
   *
   * @return
   * @throws Exception
   */
  @Action(
      value = "excel_export_list_student",
      results = {
        @Result(
            name = "success",
            type = "json",
            params = {"contentType", "text/json"})
      })
  public String excelExportListStudent() throws Exception {
    if (stuStage != null
        && !"".equals(stuStage)
        && !stuStage.equals("0")
        && student.getStatus() == 0) {
      List<StudentStatus> stuStatusList = this.stuStatusBiz.findStatusNamesByStageCode(stuStage);
      StringBuffer statusSB = new StringBuffer("");
      if (stuStatusList != null && stuStatusList.size() > 0) {
        for (StudentStatus ss : stuStatusList) {
          if (statusSB.toString().equals("")) {
            statusSB = new StringBuffer(ss.getId() + "");
          } else {
            statusSB.append("," + ss.getId());
          }
        }
        if (!statusSB.toString().equals("")) {
          student.setStatusIds(statusSB.toString());
        }
      }
    }

    PageResult<Student> pr = new PageResult<Student>();

    // 检查导出结果是否为空
    int count = studentBiz.findStudentsPageCountByBaseConditions(student);
    if (count == 0) {
      downloadUrl = "error" + Constants.EXPORT_EXCEL_ERROR_NO_3;
      return SUCCESS;
    }
    // 设置下载任务导出数据数量上限
    dataMaxCount = Constants.EXPORT_EXCEL_MAX_COUNT; // 如果配置文件异常则默认导出数据数量上限
    if (Config.getProperty("export.maxcount") != null) {
      try {
        dataMaxCount = Config.getIntProperty("export.maxcount");
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
    // 检查导入结果是否超过上限
    if (count > dataMaxCount) {
      downloadUrl = "error" + Constants.EXPORT_EXCEL_ERROR_NO_4;
      return SUCCESS;
    }

    int $page = 1; // 起始索引
    // 设置一次导入的数据量
    int $pageSize = Constants.EXPORT_EXCEL_MAX_PAGE_SIZE; // 如果配置文件异常则默认导出数据数量上限
    if (Config.getProperty("export.maxpagesize") != null) {
      try {
        $pageSize = Config.getIntProperty("export.maxpagesize");
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
    boolean only = true;
    OutputStream os = null;

    // 导出的excel数据集合
    List<StudentDataExportTemplate> studentDataExportTemplateList =
        new ArrayList<StudentDataExportTemplate>();

    // 导出的随机目录
    long ctm = System.currentTimeMillis();

    UserTask userTask = new UserTask();
    userTask.setCreateTime(new Date());
    userTask.setDownloadSumCount(0);
    userTask.setPath(ctm + "");
    userTask.setTitle("呼叫中心|在线客服|学生列表|学生导出");
    userTask.setUserId(super.getUser().getUserId());
    // 任务添加失败
    int errorno = taskBiz.addTask(userTask);
    if (errorno != Constants.EXPORT_EXCEL_FINISH) {
      downloadUrl = "error" + errorno;
      return SUCCESS;
    }

    String path = Config.getProperty("export.excel.tmp") + ctm;

    // 创建导出的工具类对象
    ExcelExport<StudentDataExportTemplate> ex = new ExcelExport<StudentDataExportTemplate>();
    // 创建随机目录
    FileUtil.CheckCreateDR(application.getRealPath(path));

    // 不分页
    pr.setPageSize($pageSize);
    pr.setPage(true);
    pr.setOrder("branchId");

    List<Student> studentList = null;

    while (only || (studentList != null && studentList.size() != 0)) {
      pr.setCurrentPageIndex($page);
      studentList = studentBiz.findStudentsPageListByBaseConditions(student, pr);
      if (studentList != null) {
        for (Student student : studentList) {
          // 市场途径
          BaseDict basedict = basedictBiz.findBaseDictById(student.getEnrollmentWay());
          // 合作方
          Channel channel = channelBiz.findChannel(student.getChannelId());
          StudentDataExportTemplate studentDataExportTemplate = new StudentDataExportTemplate();
          studentDataExportTemplate.setBranchName(student.getBranchName());
          studentDataExportTemplate.setFollowUpUserName(student.getFollowUpName());
          studentDataExportTemplate.setStudentName(student.getName());
          studentDataExportTemplate.setEnrollmentBatchName(
              student.getAcademyenrollbatchName()); // ???
          studentDataExportTemplate.setAcademyName(student.getSchoolName());
          studentDataExportTemplate.setLevelName(student.getLevelName());
          studentDataExportTemplate.setMajorName(student.getMajorName());
          studentDataExportTemplate.setStudentDataSource(
              ConstantsStudentDataSourceMap.getCode(student.getStudentDataSource()));
          studentDataExportTemplate.setEnrollmentSource(student.getEnrollmentSourceName1());
          studentDataExportTemplate.setChannelName(channel == null ? "未知" : channel.getName());
          studentDataExportTemplate.setEnrollmentWay(basedict == null ? "--" : basedict.getName());
          studentDataExportTemplate.setCallStatus(
              ConstantsCallStatusMap.getCode(student.getCallStatus()));
          studentDataExportTemplate.setIsChannelTypeChecked(
              ConstantsChannelTypeCheckedMap.getCode(student.getIsChannelTypeChecked()));
          studentDataExportTemplate.setStatus(
              ConstantsStudentStatusMap.getCode(student.getStatus()));
          studentDataExportTemplate.setCertNo(student.getCertNo());
          studentDataExportTemplate.setMobile(student.getMobile());
          studentDataExportTemplate.setPhone(student.getPhone());
          studentDataExportTemplate.setRegistrationTime(
              student.getRegistrationTime() == null
                  ? ""
                  : student.getRegistrationTime().toString().substring(0, 10));
          studentDataExportTemplate.setRemark(student.getRemark());
          studentDataExportTemplateList.add(studentDataExportTemplate);
        }
        // 随机产生的文件名称前缀
        String dateStr = DateUtil.dateToStringWithTime(new Date());
        // 随机产生的文件名称以及后缀
        String filePath = dateStr + ".xls";
        // 文件全目录
        String tempPath = application.getRealPath(path) + File.separator + filePath;
        // 创建流对象

        os = new FileOutputStream(tempPath);
        // 开始导出
        ex.exportExcel("导出结果", studentDataExportTemplateList, os);
        // 关闭流
        os.close();
        studentDataExportTemplateList.clear();
        os = null;
        $page++;
        only = false;
        if (studentList.size() < $pageSize) {
          break;
        }
      }
    }
    // 压缩文件
    File inFile = new File(application.getRealPath(path));
    ZipOutputStream zos =
        new ZipOutputStream(new FileOutputStream((application.getRealPath(path) + ".zip.tmp")));
    ZipUtil.zipFile(inFile, zos, "");

    zos.close();
    zos = null;
    // 执行改名
    FileUtil.renamed(application.getRealPath(path), ".zip.tmp", ".zip");
    System.out.println(downloadUrl = path + ".zip");
    return SUCCESS;
  }