Example usage for org.apache.poi.xssf.streaming SXSSFWorkbook SXSSFWorkbook

Introduction

In this page you can find the example usage for org.apache.poi.xssf.streaming SXSSFWorkbook SXSSFWorkbook.

Prototype

public SXSSFWorkbook() 

Source Link

Document

Construct a new workbook with default row window size

Usage

From source file:com.globalsight.everest.qachecks.QAChecker.java

License:Apache License

public String runQAChecksAndGenerateReport(long taskId) throws Exception {
    Task task = ServerProxy.getTaskManager().getTask(taskId);
    Company company = CompanyWrapper.getCompanyById(task.getCompanyId());
    if (!company.getEnableQAChecks()) {
        return null;
    }/*from ww w .  j a v  a 2  s  .  c o  m*/
    Workflow workflow = task.getWorkflow();
    GlobalSightLocale targetLocale = workflow.getTargetLocale();
    GlobalSightLocale sourceLocale = workflow.getJob().getSourceLocale();
    String srcLang = sourceLocale.getDisplayName(m_uiLocale);
    String trgLang = targetLocale.getDisplayName(m_uiLocale);

    logger.info("Running QA Checks and generating report on " + task.getTaskDisplayName() + "["
            + sourceLocale.toString() + "_" + targetLocale.toString() + "].");

    Workbook workbook = new SXSSFWorkbook();

    Sheet sheet = workbook.createSheet(targetLocale.toString());
    sheet.protectSheet("");

    addTitle(workbook, sheet);

    addHiddenInfoForUpload(workbook, sheet, taskId);

    addLanguageHeader(workbook, sheet);

    writeLanguageInfo(workbook, sheet, srcLang, trgLang);

    addSegmentHeader(workbook, sheet);

    boolean hasErrors = writeSegmentInfo(workbook, sheet, workflow);
    String reportPath = saveReportFile(workbook, task);

    if (hasErrors) {
        logger.info("Done QA Checks, report " + reportPath + " is saved.");
    } else {
        logger.info("Done QA Checks, no issues reported. Report " + reportPath + " is saved.");
    }
    return reportPath;
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.CommentXlsReportHelper.java

License:Apache License

/**
 * Generates the Excel report and spits it to the outputstream The report
 * consists of all in progress workflows that are currently at a reviewOnly
 * stage.//from  w  ww  .ja va 2 s.co m
 * 
 * @return File
 * @exception Exception
 */
public void generateReport(HttpServletRequest p_request, HttpServletResponse p_response) throws Exception {
    uiLocale = (Locale) p_request.getSession().getAttribute(WebAppConstants.UILOCALE);
    bundle = PageHandler.getBundle(p_request.getSession());
    userId = (String) p_request.getSession(false).getAttribute(WebAppConstants.USER_NAME);
    String companyId = (String) p_request.getSession().getAttribute("current_company_id");
    CompanyThreadLocal.getInstance().setIdValue(companyId);
    // show Priority or not
    setShowPriority(p_request);
    s_logger.debug("showPriority:" + showPriority);
    // show Category or not
    setShowCategory(p_request);
    setStatus(p_request);
    setSourceAndTarget(p_request);

    Workbook p_workbook = new SXSSFWorkbook();
    createSheets(p_request, p_workbook, p_response);

    // Cancelled the report, return nothing.
    if (isCancelled()) {
        p_response.sendError(p_response.SC_NO_CONTENT);
        return;
    }

    ServletOutputStream out = p_response.getOutputStream();
    p_workbook.write(out);
    out.close();
    ((SXSSFWorkbook) p_workbook).dispose();
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.customize.ExcelReportWriter.java

License:Apache License

public ExcelReportWriter(ResourceBundle bundle) throws IOException {
    this.bundle = bundle;
    this.workbook = new SXSSFWorkbook();
    this.setFormats();
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.CharacterCountReportGenerator.java

License:Apache License

/**
 * Generates Excel reports/*from   w  w w . j a  v  a2s  .  c  om*/
 * 
 * @param p_jobIDS
 *            Job ID List
 * @param p_targetLocales
 *            Target Locales List
 * @param p_companyName
 *            Company Name
 * @throws Exception
 */
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    if (p_jobIDS == null || p_jobIDS.size() == 0) {
        p_jobIDS = m_jobIDS;
        p_targetLocales = m_targetLocales;
    } else if (m_jobIDS == null || m_jobIDS.size() == 0) {
        m_jobIDS = p_jobIDS;
    }
    List<File> workBooks = new ArrayList<File>();
    int finishedJobNum = 0;
    for (long jobID : p_jobIDS) {
        // Cancel generate reports.
        if (isCancelled())
            return null;

        Job job = ServerProxy.getJobHandler().getJobById(jobID);
        if (job == null)
            continue;
        setAllCellStyleNull();

        File file = ReportHelper.getXLSReportFile(getReportType(), job);
        Workbook workBook = new SXSSFWorkbook();
        createReport(workBook, job, p_targetLocales);

        FileOutputStream out = new FileOutputStream(file);
        workBook.write(out);
        out.close();
        ((SXSSFWorkbook) workBook).dispose();

        // Write total Segment Count
        FileInputStream fis = new FileInputStream(file);
        Workbook workbook = ExcelUtil.getWorkbook(file.getAbsolutePath(), fis);
        List<GlobalSightLocale> jobTL = ReportHelper.getTargetLocals(job);
        for (GlobalSightLocale trgLocale : p_targetLocales) {
            if (!jobTL.contains(trgLocale))
                continue;

            Sheet sheet = ExcelUtil.getSheet(workbook, trgLocale.toString());
            Row row = getRow(sheet, 4);
            Cell cell = getCell(row, 3);
            cell.setCellValue(totalSegmentCount.get(trgLocale.getDisplayName(m_uiLocale)).toString());
        }
        out = new FileOutputStream(file);
        workbook.write(out);
        out.close();
        workBooks.add(file);

        // Sets Reports Percent.
        setPercent(++finishedJobNum);
    }

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.CommentsAnalysisReportGenerator.java

License:Apache License

/**
 * Generates Excel report// w  w  w . j ava 2 s. c  o m
 * 
 * @param p_jobIDS
 *            Job ID List
 * @param p_targetLocales
 *            Target Locales List
 * @param p_companyName
 *            Company Name
 * @throws Exception
 */
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    ArrayList<String> stateList = ReportHelper.getAllJobStatusList();
    stateList.remove(Job.PENDING);

    if (p_jobIDS == null || p_jobIDS.size() == 0) {
        p_jobIDS = m_jobIDS;
        p_targetLocales = m_targetLocales;
    } else if (m_jobIDS == null || m_jobIDS.size() == 0) {
        m_jobIDS = p_jobIDS;
    }
    List<File> workBooks = new ArrayList<File>();
    String dateFormat = request.getParameter(WebAppConstants.DATE_FORMAT);
    Workbook combinedWorkBook = new SXSSFWorkbook();
    List<Job> jobsList = new ArrayList<Job>();
    Set<String> stateSet = new HashSet<String>();
    Set<String> projectSet = new HashSet<String>();
    if (dateFormat == null) {
        dateFormat = DEFAULT_DATE_FORMAT;
    }

    int finishedJobNum = 0;
    for (long jobID : p_jobIDS) {
        // Cancel generate reports.
        if (isCancelled())
            return null;

        Job job = ServerProxy.getJobHandler().getJobById(jobID);
        if (job == null || !stateList.contains(job.getState()))
            continue;

        stateSet.add(job.getDisplayState());
        projectSet.add(job.getProject().getName());
        if (isCombineAllJobs) {
            jobsList.add(job);
            createReport(combinedWorkBook, job, p_targetLocales, dateFormat);
        } else {
            setAllCellStyleNull();
            Workbook workBook = new SXSSFWorkbook();
            createReport(workBook, job, p_targetLocales, dateFormat);
            File file = getFile(reportType, job, workBook);
            FileOutputStream out = new FileOutputStream(file);
            workBook.write(out);
            out.close();
            ((SXSSFWorkbook) workBook).dispose();
            workBooks.add(file);
        }

        // Sets Reports Percent.
        setPercent(++finishedJobNum);
    }

    if (isCombineAllJobs) {
        File file = getFile(reportType + TAG_COMBINED, null, combinedWorkBook);
        addCriteriaSheet(combinedWorkBook, jobsList, stateSet, projectSet);
        FileOutputStream out = new FileOutputStream(file);
        combinedWorkBook.write(out);
        out.close();
        ((SXSSFWorkbook) combinedWorkBook).dispose();
        workBooks.add(file);
    }

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.ImplementedCommentsCheckReportGenerator.java

License:Apache License

/**
 * Generates Excel report/*from w ww .j  a v  a  2  s . co  m*/
 * 
 * @param p_jobIDS
 *            Job ID List
 * @param p_targetLocales
 *            Target Locales List
 * @param p_companyName
 *            Company Name
 * @throws Exception
 */
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    ArrayList<String> stateList = ReportHelper.getAllJobStatusList();
    stateList.remove(Job.PENDING);

    if (p_jobIDS == null || p_jobIDS.size() == 0) {
        p_jobIDS = m_jobIDS;
        p_targetLocales = m_targetLocales;
    } else if (m_jobIDS == null || m_jobIDS.size() == 0) {
        m_jobIDS = p_jobIDS;
    }
    List<File> workBooks = new ArrayList<File>();
    String dateFormat = request.getParameter(WebAppConstants.DATE_FORMAT);
    Set<String> stateSet = new HashSet<String>();
    Set<String> projectSet = new HashSet<String>();
    if (dateFormat == null) {
        dateFormat = DEFAULT_DATE_FORMAT;
    }

    int finishedJobNum = 0;
    for (long jobID : p_jobIDS) {
        // Cancel generate reports.
        if (isCancelled())
            return null;

        Job job = ServerProxy.getJobHandler().getJobById(jobID);
        if (job == null || !stateList.contains(job.getState()))
            continue;

        stateSet.add(job.getDisplayState());
        projectSet.add(job.getProject().getName());

        setAllCellStyleNull();
        Workbook workBook = new SXSSFWorkbook();
        createReport(workBook, job, p_targetLocales, dateFormat);
        File file = getFile(reportType, job, workBook);
        FileOutputStream out = new FileOutputStream(file);
        workBook.write(out);
        out.close();
        ((SXSSFWorkbook) workBook).dispose();
        workBooks.add(file);

        // Sets Reports Percent.
        setPercent(++finishedJobNum);
    }

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportForIPTranslatorGenerator.java

License:Apache License

@Override
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {
    // Generate Report from HttpServletRequest.
    if (p_jobIDS == null || p_jobIDS.size() == 0) {
        return generateReport(m_request);
    }/* ww  w.j a v  a2 s . co  m*/

    File file = ReportHelper.getXLSReportFile(getReportType(), null);
    Workbook workbook = new SXSSFWorkbook();
    HashSet<Job> jobs = new HashSet<Job>(ReportHelper.getJobListByIDS(p_jobIDS));
    m_data.wantsAllLocales = true;
    m_data.wantsAllProjects = true;
    m_data.setDateFormatString("MM/dd/yy hh:mm:ss a z");
    m_data.jobIds = p_jobIDS;
    HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = reportDataMap(jobs, false, false);
    if (projectMap != null && projectMap.size() > 0) {
        // Create sheets in Workbook.
        createSheets(workbook, projectMap, false);
        FileOutputStream out = new FileOutputStream(file);
        workbook.write(out);
        out.close();
        ((SXSSFWorkbook) workbook).dispose();
        List<File> workBooks = new ArrayList<File>();
        workBooks.add(file);
        return ReportHelper.moveReports(workBooks, m_userId);
    } else {
        return new File[0];
    }
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportForIPTranslatorGenerator.java

License:Apache License

/**
 * Generates the Excel report as a temp file and returns the temp file. The
 * report consists of all jobs for the given PM, this year, on a month by
 * month basis.// w  w  w  . java2 s  .  c  o  m
 * 
 * @return File
 * @exception Exception
 */
private File[] generateReport(HttpServletRequest p_request) throws Exception {
    String[] months = getMonths();
    File file = ReportHelper.getXLSReportFile(getReportType(), null);
    Workbook p_workbook = new SXSSFWorkbook();
    int currentMonth = m_calendar.get(Calendar.MONTH);
    int year;
    if (p_request.getParameter("year") != null) {
        year = Integer.parseInt(p_request.getParameter("year"));
    } else {
        year = m_calendar.get(Calendar.YEAR);
    }
    if (year != m_calendar.get(Calendar.YEAR))
        currentMonth = 11;

    boolean wroteSomething = false;
    boolean recalculateFinishedWorkflow = false;
    String recalcParam = p_request.getParameter("recalc");
    if (recalcParam != null && recalcParam.length() > 0) {
        recalculateFinishedWorkflow = java.lang.Boolean.valueOf(recalcParam).booleanValue();
    }

    // For "Dell Review Report Issue"
    // Gets the tag that marks whether needs to separates "Dell_Review" or
    // not.
    // Default value is "false".
    boolean includeExReview = false;

    String reviewParam = p_request.getParameter("review");
    if ((reviewParam != null) && (reviewParam.length() > 0)) {
        includeExReview = java.lang.Boolean.valueOf(reviewParam).booleanValue();
    }

    // For "Add Job Id into online job report" issue
    isJobIdVisible = isJobIdVisible(p_request);
    String isReportForYear = p_request.getParameter("reportForThisYear");
    String isReportForDetail = p_request.getParameter("reportForDetail");
    // Generate Report By Year
    if (isReportForYear != null && isReportForYear.equals("on")) {
        int i = 0;
        for (i = 0; i <= currentMonth; i++) {
            // For "Dell Review Report Issue"
            // Add new parameter "includeExReview" to the signature.
            HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = getProjectDataForMonth(p_request,
                    i, recalculateFinishedWorkflow, includeExReview);

            // Cancel the report.
            if (isCancelled())
                return new File[0];

            if (projectMap.size() > 0) {
                // This sheets array has two elements.
                // sheets[MONTH_SHEET], the original monthSheet.
                // sheets[MONTH_REVIEW_SHEET], new monthly Dell_Review
                // sheet.
                Sheet[] sheets = new Sheet[2];
                IntHolder[] rows = new IntHolder[2];

                String sheetTitle = months[i] + " " + year;
                sheets[MONTH_SHEET] = p_workbook.createSheet(sheetTitle);

                // m_data.isTradosStyle by default is true, matches trados for UI is hidden
                if (m_data.isTradosStyle()) {
                    addTitle(p_workbook, sheets[MONTH_SHEET]);
                    addHeaderTradosStyle(p_workbook, sheets[MONTH_SHEET], MONTH_SHEET);
                } else {
                    addTitle(p_workbook, sheets[MONTH_SHEET]);
                    addHeader(p_workbook, sheets[MONTH_SHEET], MONTH_SHEET);
                }

                rows[MONTH_SHEET] = new IntHolder(4);

                if (includeExReview) {
                    String sheetReviewTitle = m_bundle.getString("lb_review") + " " + months[i] + " " + year;
                    sheets[MONTH_REVIEW_SHEET] = p_workbook.createSheet(sheetReviewTitle);
                    if (m_data.isTradosStyle()) {
                        addTitle(p_workbook, sheets[MONTH_REVIEW_SHEET]);
                        addHeaderTradosStyle(p_workbook, sheets[MONTH_REVIEW_SHEET], MONTH_REVIEW_SHEET);
                    } else {
                        addTitle(p_workbook, sheets[MONTH_REVIEW_SHEET]);
                        addHeader(p_workbook, sheets[MONTH_REVIEW_SHEET], MONTH_REVIEW_SHEET);
                    }
                    rows[MONTH_REVIEW_SHEET] = new IntHolder(4);
                }

                if (m_data.isTradosStyle()) {
                    writeProjectDataTradosStyle(projectMap, p_workbook, sheets, includeExReview, rows);
                } else {
                    writeProjectData(projectMap, p_workbook, sheets, includeExReview, rows);
                }
                wroteSomething = true;
            }
        }

        if (!wroteSomething) {
            // just write out the first sheet to avoid Excel problems
            i = 0;
            String sheetTitle = months[currentMonth] + " " + year;
            Sheet monthSheet = p_workbook.createSheet(sheetTitle);
            if (m_data.isTradosStyle()) {
                addTitle(p_workbook, monthSheet);
                addHeaderTradosStyle(p_workbook, monthSheet, MONTH_SHEET);
            } else {
                addTitle(p_workbook, monthSheet);
                addHeader(p_workbook, monthSheet, MONTH_SHEET);
            }

            if (includeExReview) {
                String sheetReviewTitle = "Review " + months[currentMonth] + " " + year;
                Sheet monthReviewSheet = p_workbook.createSheet(sheetReviewTitle);
                if (m_data.isTradosStyle()) {
                    addTitle(p_workbook, monthReviewSheet);
                    addHeaderTradosStyle(p_workbook, monthReviewSheet, MONTH_REVIEW_SHEET);
                } else {
                    addTitle(p_workbook, monthReviewSheet);
                    addHeader(p_workbook, monthReviewSheet, MONTH_REVIEW_SHEET);
                }
            }
        }

        // Create "Criteria" Sheet
        addParamsSheet(p_workbook, (String) p_request.getParameter("year"), recalculateFinishedWorkflow);

        FileOutputStream out = new FileOutputStream(file);
        p_workbook.write(out);
        out.close();
        ((SXSSFWorkbook) p_workbook).dispose();
    }
    // Generate Report by Creation Date Range.
    else if (isReportForDetail != null && isReportForDetail.endsWith("on")) {
        // For "Dell Review Report Issue"
        // Add new parameter "includeExReview" to the signature.
        HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = getProjectDataForMonth(p_request, 0,
                recalculateFinishedWorkflow, includeExReview);

        // Cancel the report.
        if (isCancelled())
            return new File[0];

        // Create sheets in Workbook.
        createSheets(p_workbook, projectMap, includeExReview);

        // Create "Criteria" Sheet  
        addParamsSheet(p_workbook, (String) p_request.getParameter("year"), recalculateFinishedWorkflow);

        FileOutputStream out = new FileOutputStream(file);
        p_workbook.write(out);
        out.close();
        ((SXSSFWorkbook) p_workbook).dispose();
    }

    List<File> workBooks = new ArrayList<File>();
    workBooks.add(file);
    return ReportHelper.moveReports(workBooks, m_userId);
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.OnlineJobsReportGenerator.java

License:Apache License

/**
 * Generates the Excel report as a temp file and returns the temp file. The
 * report consists of all jobs for the given PM, this year, on a month by
 * month basis./*from  w  w w. java 2s .  c o m*/
 * 
 * @return File
 * @exception Exception
 */
private File[] generateReport(HttpServletRequest p_request) throws Exception {
    String[] months = getMonths();
    File file = ReportHelper.getXLSReportFile(getReportType(), null);
    Workbook p_workbook = new SXSSFWorkbook();
    int currentMonth = m_calendar.get(Calendar.MONTH);
    int year;
    if (p_request.getParameter("year") != null) {
        year = Integer.parseInt(p_request.getParameter("year"));
    } else {
        year = m_calendar.get(Calendar.YEAR);
    }
    if (year != m_calendar.get(Calendar.YEAR))
        currentMonth = 11;

    boolean wroteSomething = false;
    boolean recalculateFinishedWorkflow = false;
    String recalcParam = p_request.getParameter("recalc");
    if (recalcParam != null && recalcParam.length() > 0) {
        recalculateFinishedWorkflow = java.lang.Boolean.valueOf(recalcParam).booleanValue();
    }

    // For "Dell Review Report Issue"
    // Gets the tag that marks whether needs to separates "Dell_Review" or
    // not.
    // Default value is "false".
    boolean includeExReview = false;

    String reviewParam = p_request.getParameter("review");
    if ((reviewParam != null) && (reviewParam.length() > 0)) {
        includeExReview = java.lang.Boolean.valueOf(reviewParam).booleanValue();
    }

    // For "Add Job Id into online job report" issue
    isJobIdVisible = isJobIdVisible(p_request);
    String isReportForYear = p_request.getParameter("reportForThisYear");
    String isReportForDetail = p_request.getParameter("reportForDetail");
    // Generate Report By Year
    if (isReportForYear != null && isReportForYear.equals("on")) {
        int i = 0;
        for (i = 0; i <= currentMonth; i++) {
            // For "Dell Review Report Issue"
            // Add new parameter "includeExReview" to the signature.
            HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = getProjectDataForMonth(p_request,
                    i, recalculateFinishedWorkflow, includeExReview);

            // Cancel the report.
            if (isCancelled())
                return new File[0];

            if (projectMap.size() > 0) {
                // This sheets array has two elements.
                // sheets[MONTH_SHEET], the original monthSheet.
                // sheets[MONTH_REVIEW_SHEET], new monthly Dell_Review
                // sheet.
                Sheet[] sheets = new Sheet[2];
                IntHolder[] rows = new IntHolder[2];

                String sheetTitle = months[i] + " " + year;
                sheets[MONTH_SHEET] = p_workbook.createSheet(sheetTitle);
                if (m_data.isTradosStyle()) {
                    addTitle(p_workbook, sheets[MONTH_SHEET]);
                    addHeaderTradosStyle(p_workbook, sheets[MONTH_SHEET], MONTH_SHEET);
                } else {
                    addTitle(p_workbook, sheets[MONTH_SHEET]);
                    addHeader(p_workbook, sheets[MONTH_SHEET], MONTH_SHEET);
                }

                rows[MONTH_SHEET] = new IntHolder(4);

                if (includeExReview) {
                    String sheetReviewTitle = m_bundle.getString("lb_review") + " " + months[i] + " " + year;
                    sheets[MONTH_REVIEW_SHEET] = p_workbook.createSheet(sheetReviewTitle);
                    if (m_data.isTradosStyle()) {
                        addTitle(p_workbook, sheets[MONTH_REVIEW_SHEET]);
                        addHeaderTradosStyle(p_workbook, sheets[MONTH_REVIEW_SHEET], MONTH_REVIEW_SHEET);
                    } else {
                        addTitle(p_workbook, sheets[MONTH_REVIEW_SHEET]);
                        addHeader(p_workbook, sheets[MONTH_REVIEW_SHEET], MONTH_REVIEW_SHEET);
                    }
                    rows[MONTH_REVIEW_SHEET] = new IntHolder(4);
                }

                if (m_data.isTradosStyle()) {
                    writeProjectDataTradosStyle(projectMap, p_workbook, sheets, includeExReview, rows);
                } else {
                    writeProjectData(projectMap, p_workbook, sheets, includeExReview, rows);
                }
                wroteSomething = true;
            }
        }

        if (!wroteSomething) {
            // just write out the first sheet to avoid Excel problems
            i = 0;
            String sheetTitle = months[currentMonth] + " " + year;
            Sheet monthSheet = p_workbook.createSheet(sheetTitle);
            if (m_data.isTradosStyle()) {
                addTitle(p_workbook, monthSheet);
                addHeaderTradosStyle(p_workbook, monthSheet, MONTH_SHEET);
            } else {
                addTitle(p_workbook, monthSheet);
                addHeader(p_workbook, monthSheet, MONTH_SHEET);
            }

            if (includeExReview) {
                String sheetReviewTitle = "Review " + months[currentMonth] + " " + year;
                Sheet monthReviewSheet = p_workbook.createSheet(sheetReviewTitle);
                if (m_data.isTradosStyle()) {
                    addTitle(p_workbook, monthReviewSheet);
                    addHeaderTradosStyle(p_workbook, monthReviewSheet, MONTH_REVIEW_SHEET);
                } else {
                    addTitle(p_workbook, monthReviewSheet);
                    addHeader(p_workbook, monthReviewSheet, MONTH_REVIEW_SHEET);
                }
            }
        }

        // Create "Criteria" Sheet
        addParamsSheet(p_workbook, (String) p_request.getParameter("year"), recalculateFinishedWorkflow);

        FileOutputStream out = new FileOutputStream(file);
        p_workbook.write(out);
        out.close();
        ((SXSSFWorkbook) p_workbook).dispose();
    }
    // Generate Report by Creation Date Range.
    else if (isReportForDetail != null && isReportForDetail.endsWith("on")) {
        // For "Dell Review Report Issue"
        // Add new parameter "includeExReview" to the signature.
        HashMap<String, HashMap<String, ProjectWorkflowData>> projectMap = getProjectDataForMonth(p_request, 0,
                recalculateFinishedWorkflow, includeExReview);

        // Cancel the report.
        if (isCancelled())
            return new File[0];

        // Create sheets in Workbook.
        createSheets(p_workbook, projectMap, includeExReview);

        // Create "Criteria" Sheet
        addParamsSheet(p_workbook, (String) p_request.getParameter("year"), recalculateFinishedWorkflow);

        FileOutputStream out = new FileOutputStream(file);
        p_workbook.write(out);
        out.close();
        ((SXSSFWorkbook) p_workbook).dispose();
    }

    List<File> workBooks = new ArrayList<File>();
    workBooks.add(file);
    return ReportHelper.moveReports(workBooks, m_userId);
}

---

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.generator.PostReviewQAReportGenerator.java

License:Apache License

@Override
public File[] generateReports(List<Long> p_jobIDS, List<GlobalSightLocale> p_targetLocales) throws Exception {

    List<File> workBooks = new ArrayList<File>();
    for (long jobID : p_jobIDS) {
        if (cancel)
            return new File[0];

        Job job = ServerProxy.getJobHandler().getJobById(jobID);
        if (job == null)
            continue;

        Workbook workBook = new SXSSFWorkbook();
        createReport(workBook, job, p_targetLocales, m_dateFormat);
        File file = getFile(getReportType(), job, workBook);
        FileOutputStream out = new FileOutputStream(file);
        workBook.write(out);// www .ja va2 s. c  o m
        out.close();
        ((SXSSFWorkbook) workBook).dispose();

        workBooks.add(file);
    }

    return ReportHelper.moveReports(workBooks, m_userId);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• »