List of usage examples for org.apache.poi.xwpf.usermodel ParagraphAlignment CENTER
ParagraphAlignment CENTER
To view the source code for org.apache.poi.xwpf.usermodel ParagraphAlignment CENTER.
Click Source Link
From source file:org.cgiar.ccafs.marlo.action.summaries.AnualReportPOISummaryAction.java
License:Open Source License
private void createTableJ() { if (reportSynthesisPMU.getReportSynthesisFinancialSummary() .getReportSynthesisFinancialSummaryBudgets() != null && !reportSynthesisPMU.getReportSynthesisFinancialSummary() .getReportSynthesisFinancialSummaryBudgets().isEmpty()) { reportSynthesisPMU.getReportSynthesisFinancialSummary() .setBudgets(new ArrayList<>(reportSynthesisPMU.getReportSynthesisFinancialSummary() .getReportSynthesisFinancialSummaryBudgets().stream().filter(t -> t.isActive()) .collect(Collectors.toList()))); } else {/* www. j a v a2s. c o m*/ flagshipLiaisonInstitutions.sort(Comparator.comparing(LiaisonInstitution::getAcronym)); reportSynthesisPMU.getReportSynthesisFinancialSummary().setBudgets(new ArrayList<>()); for (LiaisonInstitution liInstitution : flagshipLiaisonInstitutions) { ReportSynthesisFinancialSummaryBudget financialSummaryBudget = new ReportSynthesisFinancialSummaryBudget(); financialSummaryBudget.setLiaisonInstitution(liInstitution); reportSynthesisPMU.getReportSynthesisFinancialSummary().getBudgets().add(financialSummaryBudget); } List<PowbExpenditureAreas> expAreas = new ArrayList<>(powbExpenditureAreasManager.findAll().stream() .filter(x -> x.isActive() && !x.getIsExpenditure()).collect(Collectors.toList())); for (PowbExpenditureAreas powbExpenditureAreas : expAreas) { ReportSynthesisFinancialSummaryBudget financialSummaryBudget = new ReportSynthesisFinancialSummaryBudget(); financialSummaryBudget.setExpenditureArea(powbExpenditureAreas); reportSynthesisPMU.getReportSynthesisFinancialSummary().getBudgets().add(financialSummaryBudget); } } List<ReportSynthesisFinancialSummaryBudget> reportSynthesisFinancialSummaryBudgetList = reportSynthesisPMU .getReportSynthesisFinancialSummary().getBudgets(); List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = { new POIField("", ParagraphAlignment.CENTER), new POIField( this.getText("annualReport.financial.tableJ.budget", new String[] { String.valueOf(this.getSelectedYear()) }) + "*", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField(this.getText("annualReport.financial.tableJ.expenditure") + "*", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField(this.getText("annualReport.financial.tableJ.difference") + "*", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER) }; POIField[] sHeader2 = { new POIField(" ", ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w1w2"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w3bilateral"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.total"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w1w2"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w3bilateral"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.total"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w1w2"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w3bilateral"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.total"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); List<POIField> header2 = Arrays.asList(sHeader2); headers.add(header); headers.add(header2); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; double totalW1w2Difference = 0.0, totalW3Difference = 0.0, grandTotalDifference = 0.0; if (reportSynthesisFinancialSummaryBudgetList != null && !reportSynthesisFinancialSummaryBudgetList.isEmpty()) { for (ReportSynthesisFinancialSummaryBudget reportSynthesisFinancialSummaryBudget : reportSynthesisFinancialSummaryBudgetList) { String category = ""; Double w1w2Planned = 0.0, w3Planned = 0.0, w1w2Actual = 0.0, w3Actual = 0.0, totalPlanned = 0.0, totalActual = 0.0, w1w2Difference = 0.0, w3Difference = 0.0, totalDifference = 0.0; /** Getting category name **/ if (reportSynthesisFinancialSummaryBudget.getLiaisonInstitution() != null) { category = reportSynthesisFinancialSummaryBudget.getLiaisonInstitution().getComposedName(); } else if (reportSynthesisFinancialSummaryBudget.getExpenditureArea() .getExpenditureArea() != null) { category = reportSynthesisFinancialSummaryBudget.getExpenditureArea().getExpenditureArea(); } if (reportSynthesisFinancialSummaryBudget.getW1Planned() != null) { w1w2Planned = reportSynthesisFinancialSummaryBudget.getW1Planned(); } if (reportSynthesisFinancialSummaryBudget.getW3Planned() != null) { w3Planned = reportSynthesisFinancialSummaryBudget.getW3Planned() + reportSynthesisFinancialSummaryBudget.getBilateralPlanned(); } totalPlanned = w1w2Planned + w3Planned; if (reportSynthesisFinancialSummaryBudget.getW1Actual() != null) { w1w2Actual = reportSynthesisFinancialSummaryBudget.getW1Actual(); } if (reportSynthesisFinancialSummaryBudget.getW3Actual() != null) { w3Actual = reportSynthesisFinancialSummaryBudget.getW3Actual() + reportSynthesisFinancialSummaryBudget.getBilateralActual(); } totalActual = w1w2Actual + w3Actual; w1w2Difference = w1w2Planned - w1w2Actual; w3Difference = w3Planned - w3Actual; totalDifference = totalPlanned - totalActual; totalw1w2Planned += w1w2Planned; totalW3Planned += w3Planned; grandTotalPlanned += totalPlanned; totalw1w2Actual += w1w2Actual; totalW3Actual += w3Actual; grandTotalActual += totalActual; totalW1w2Difference += w1w2Difference; totalW3Difference += w3Difference; grandTotalDifference += totalDifference; POIField[] sData = { new POIField(category, ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w1w2Planned / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w3Planned / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(totalPlanned / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w1w2Actual / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w3Actual / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(totalActual / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w1w2Difference / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w3Difference / 1000, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(totalDifference / 1000, 2)), ParagraphAlignment.CENTER) }; data = Arrays.asList(sData); datas.add(data); } } Boolean bold = true; String blackColor = "000000"; POIField[] sData = { new POIField("CRP Total", ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalw1w2Planned / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalW3Planned / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(grandTotalPlanned / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalw1w2Actual / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalW3Actual / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(grandTotalActual / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalW1w2Difference / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalW3Difference / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(grandTotalDifference / 1000, 2)), ParagraphAlignment.CENTER, bold, blackColor), }; data = Arrays.asList(sData); datas.add(data); poiSummary.textTable(document, headers, datas, true, "tableJAnnualReport"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
public void createTableA1() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = { new POIField(this.getText("expectedProgress.tableA.fp"), ParagraphAlignment.CENTER), new POIField(this.getText("expectedProgress.tableA.subIDO"), ParagraphAlignment.CENTER), new POIField(this.getText("summaries.powb.tableA1.outcomes"), ParagraphAlignment.CENTER), new POIField(this.getSelectedYear() + " Budget " + this.getText("expectedProgress.tableA.w1w2"), ParagraphAlignment.CENTER), new POIField( this.getSelectedYear() + " Budget " + this.getText("expectedProgress.tableA.w3bilateral"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header);/*from w ww .j av a2 s.com*/ String FP, subIDO = "", outcomes; List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; for (CrpProgram flagship : flagships) { int flagshipIndex = 0; data = new ArrayList<>(); for (CrpProgramOutcome outcome : flagship.getOutcomes()) { subIDO = ""; for (CrpOutcomeSubIdo subIdo : outcome.getSubIdos()) { if (subIdo.getSrfSubIdo() != null) { if (subIDO.isEmpty()) { if (subIdo.getSrfSubIdo().getSrfIdo().isIsCrossCutting()) { subIDO = " CC " + subIdo.getSrfSubIdo().getDescription(); } else { subIDO = " " + subIdo.getSrfSubIdo().getDescription(); } } else { if (subIdo.getSrfSubIdo().getSrfIdo().isIsCrossCutting()) { subIDO += "\n CC " + subIdo.getSrfSubIdo().getDescription(); } else { subIDO += "\n " + subIdo.getSrfSubIdo().getDescription(); } } } } outcomes = outcome.getComposedName(); if (flagshipIndex == 0) { FP = flagship.getAcronym(); } else { FP = " "; } Boolean bold = false; String blackColor = "000000"; String redColor = "c00000"; POIField[] sData = { new POIField(FP, ParagraphAlignment.CENTER, bold, blackColor), new POIField(subIDO, ParagraphAlignment.LEFT, bold, blackColor), new POIField(outcomes, ParagraphAlignment.LEFT, bold, blackColor), new POIField("To be completed", ParagraphAlignment.CENTER, bold, redColor), new POIField("To be completed", ParagraphAlignment.CENTER, bold, redColor) }; data = Arrays.asList(sData); datas.add(data); flagshipIndex++; } } poiSummary.textTable(document, headers, datas, false, "tableA"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableA2() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = { new POIField(this.getText("expectedProgress.tableA.fp"), ParagraphAlignment.CENTER), new POIField(this.getText("summaries.powb.tableA1.outcomes"), ParagraphAlignment.CENTER), new POIField(this.getText("expectedProgress.tableA.milestone") + "*", ParagraphAlignment.CENTER), new POIField(this.getText("expectedProgress.tableA.meansVerification"), ParagraphAlignment.CENTER), new POIField(this.getText("expectedProgress.tableA.assessment"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header);/* w w w . ja v a 2s .c om*/ String FP, outcomes, milestone, assessment, meansVerifications; List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; for (CrpProgram flagship : flagships) { data = new ArrayList<>(); int outcome_index = 0; for (CrpProgramOutcome outcome : flagship.getOutcomes()) { int milestone_index = 0; for (CrpMilestone crpMilestone : outcome.getMilestones()) { Boolean isFlagshipRow = (outcome_index == 0) && (milestone_index == 0); Boolean isOutcomeRow = (milestone_index == 0); if (isFlagshipRow) { FP = flagship.getAcronym(); } else { FP = " "; } if (isOutcomeRow) { outcomes = outcome.getComposedName(); } else { outcomes = " "; } milestone = crpMilestone.getComposedName(); PowbExpectedCrpProgress milestoneProgress = this .getPowbExpectedCrpProgressProgram(crpMilestone.getId(), flagship.getId()); assessment = milestoneProgress.getAssesmentName() != null && !milestoneProgress.getAssesmentName().trim().isEmpty() ? milestoneProgress.getAssesmentName() : " "; meansVerifications = milestoneProgress.getMeans() != null && !milestoneProgress.getMeans().trim().isEmpty() ? milestoneProgress.getMeans() : " "; POIField[] sData = { new POIField(FP, ParagraphAlignment.CENTER), new POIField(outcomes, ParagraphAlignment.LEFT), new POIField(milestone, ParagraphAlignment.LEFT), new POIField(meansVerifications, ParagraphAlignment.LEFT), new POIField(assessment, ParagraphAlignment.CENTER) }; data = Arrays.asList(sData); datas.add(data); milestone_index++; } outcome_index++; } } poiSummary.textTable(document, headers, datas, false, "tableA"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableB() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = {/*from ww w. j a v a 2s . c om*/ new POIField(this.getText("evidenceRelevant.table.plannedTopic"), ParagraphAlignment.CENTER), new POIField(this.getText("evidenceRelevant.tablePlannedStudies.geographicScope"), ParagraphAlignment.CENTER), new POIField(this.getText("evidenceRelevant.tablePlannedStudies.relevant"), ParagraphAlignment.CENTER), new POIField(this.getText("evidenceRelevant.tablePlannedStudies.comments"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; this.getFpPlannedList(this.getFlagships(), this.getSelectedPhase().getId()); for (PowbEvidencePlannedStudyDTO powbEvidencePlannedStudyDTO : flagshipPlannedList.stream().filter(p -> p .getProjectExpectedStudy() != null && p.getProjectExpectedStudy().getType() != null && (p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.OUTCOMECASESTUDY.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.IMPACTASSESMENT.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.ADOPTIONSTUDY.getId())) .collect(Collectors.toList())) { String plannedStudy = "", geographicScope = "", revelantSubIDO = "", comments = ""; plannedStudy = powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getTopicStudy() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getTopicStudy().trim().isEmpty() ? powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getTopicStudy() : " "; geographicScope = powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getScopeName() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getScopeName().trim().isEmpty() ? powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getScopeName() : " "; if (powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSubIdo() != null && powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSubIdo().getDescription() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSubIdo().getDescription().trim() .isEmpty()) { revelantSubIDO += " " + powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSubIdo().getDescription(); } if (powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSloIndicator() != null && powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSloIndicator().getTitle() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSloIndicator().getTitle().trim() .isEmpty()) { if (revelantSubIDO.isEmpty()) { revelantSubIDO += " " + powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSloIndicator().getTitle(); } else { revelantSubIDO += "\n " + powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getSrfSloIndicator().getTitle(); } } if (revelantSubIDO.isEmpty()) { revelantSubIDO = " "; } comments = powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getComments() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getComments().trim().isEmpty() ? powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getComments() : " "; POIField[] sData = { new POIField(plannedStudy, ParagraphAlignment.CENTER), new POIField(geographicScope, ParagraphAlignment.CENTER), new POIField(revelantSubIDO, ParagraphAlignment.LEFT), new POIField(comments, ParagraphAlignment.LEFT) }; data = Arrays.asList(sData); datas.add(data); } poiSummary.textTable(document, headers, datas, false, "tableB"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableC() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = {/*from w ww. j a v a2 s . c om*/ new POIField(this.getText("crossCuttingDimensions.tableC.crossCutting"), ParagraphAlignment.CENTER), new POIField(this.getText("crossCuttingDimensions.tableC.principal"), ParagraphAlignment.CENTER), new POIField(this.getText("crossCuttingDimensions.tableC.significant"), ParagraphAlignment.CENTER), new POIField(this.getText("crossCuttingDimensions.tableC.notTargeted"), ParagraphAlignment.CENTER), new POIField(this.getText("crossCuttingDimensions.tableC.overall"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; this.tableCInfo(this.getSelectedPhase()); if (tableC != null) { POIField[] sData = { new POIField("Gender", ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageGenderPrincipal() / 100, 4)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageGenderSignificant() / 100, 4)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageGenderNotScored() / 100, 4)), ParagraphAlignment.CENTER), new POIField(String.valueOf((int) tableC.getTotal()), ParagraphAlignment.CENTER) }; data = Arrays.asList(sData); datas.add(data); POIField[] sData2 = { new POIField("Youth", ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageYouthPrincipal() / 100, 4)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageYouthSignificant() / 100, 4)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageYouthNotScored() / 100, 4)), ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER) }; data = Arrays.asList(sData2); datas.add(data); POIField[] sData3 = { new POIField("CapDev", ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageCapDevPrincipal() / 100, 4)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageCapDevSignificant() / 100, 4)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(tableC.getPercentageCapDevNotScored() / 100, 4)), ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER) }; data = Arrays.asList(sData3); datas.add(data); } poiSummary.textTable(document, headers, datas, true, "tableC"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableD() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = { new POIField(this.getText("crpStaffing.tableD.category"), ParagraphAlignment.CENTER), new POIField(this.getText("crpStaffing.tableD.female"), ParagraphAlignment.CENTER), new POIField(this.getText("crpStaffing.tableD.male"), ParagraphAlignment.CENTER), new POIField(this.getText("crpStaffing.tableD.total"), ParagraphAlignment.CENTER), new POIField(this.getText("crpStaffing.tableD.percFemale"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header);/*from w ww .ja v a 2 s . c o m*/ List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; Double totalFemale = 0.0, totalMale = 0.0, totalFemaleNoCg = 0.0, totalMaleNoCg = 0.0; for (PowbCrpStaffingCategories crpStaffingCategory : powbCrpStaffingCategoriesManager.findAll().stream() .filter(c -> c.isActive()).collect(Collectors.toList())) { String category = ""; Double female = 0.0, femaleNoCg = 0.0, totalFTE = 0.0, femalePercentaje = 0.0, male = 0.0, maleNoCg = 0.0; category = crpStaffingCategory.getCategory(); if (powbSynthesisPMU != null) { List<PowbSynthesisCrpStaffingCategory> powbSynthesisCrpStaffingCategoryList = crpStaffingCategory .getPowbSynthesisCrpStaffingCategory().stream() .sorted((c1, c2) -> c1.getId().compareTo(c2.getId())).filter(pc -> pc.isActive() && pc.getPowbSynthesis() != null && pc.getPowbSynthesis().equals(powbSynthesisPMU)) .collect(Collectors.toList()); if (powbSynthesisCrpStaffingCategoryList != null && powbSynthesisCrpStaffingCategoryList.size() > 0) { PowbSynthesisCrpStaffingCategory powbSynthesisCrpStaffingCategory = powbSynthesisCrpStaffingCategoryList .get(0); female = powbSynthesisCrpStaffingCategory.getFemale() != null ? powbSynthesisCrpStaffingCategory.getFemale() : 0.0; femaleNoCg = powbSynthesisCrpStaffingCategory.getFemaleNoCgiar() != null ? powbSynthesisCrpStaffingCategory.getFemaleNoCgiar() : 0.0; femalePercentaje = powbSynthesisCrpStaffingCategory.getFemalePercentage() / 100.0; male = powbSynthesisCrpStaffingCategory.getMale() != null ? powbSynthesisCrpStaffingCategory.getMale() : 0.0; maleNoCg = powbSynthesisCrpStaffingCategory.getMaleNoCgiar() != null ? powbSynthesisCrpStaffingCategory.getMaleNoCgiar() : 0.0; totalFemale += female; totalFemaleNoCg += femaleNoCg; totalMale += male; totalMaleNoCg += maleNoCg; totalFTE = powbSynthesisCrpStaffingCategory.getTotalFTE(); } } POIField[] sData = { new POIField(category, ParagraphAlignment.LEFT), new POIField(String.valueOf(round(female, 2)) + " (" + round(femaleNoCg, 2) + ")", ParagraphAlignment.CENTER), new POIField(String.valueOf(round(male, 2)) + " (" + round(maleNoCg, 2) + ")", ParagraphAlignment.CENTER), new POIField(String.valueOf(round(totalFTE, 2)), ParagraphAlignment.CENTER), new POIField(percentageFormat.format(round(femalePercentaje, 4)), ParagraphAlignment.CENTER) }; data = Arrays.asList(sData); datas.add(data); } PowbSynthesisCrpStaffingCategory powbSynthesisCrpStaffingCategory = new PowbSynthesisCrpStaffingCategory(); powbSynthesisCrpStaffingCategory.setMale(totalMale); powbSynthesisCrpStaffingCategory.setMaleNoCgiar(totalMaleNoCg); powbSynthesisCrpStaffingCategory.setFemale(totalFemale); powbSynthesisCrpStaffingCategory.setFemaleNoCgiar(totalFemaleNoCg); Boolean bold = true; String blackColor = "000000"; POIField[] sData = { new POIField("Total CRP", ParagraphAlignment.LEFT, bold, blackColor), new POIField( String.valueOf(round(powbSynthesisCrpStaffingCategory.getFemale(), 2)) + " (" + round(powbSynthesisCrpStaffingCategory.getFemaleNoCgiar(), 2) + ")", ParagraphAlignment.CENTER, bold, blackColor), new POIField( String.valueOf(round(powbSynthesisCrpStaffingCategory.getMale(), 2)) + " (" + round(powbSynthesisCrpStaffingCategory.getMaleNoCgiar(), 2) + ")", ParagraphAlignment.CENTER, bold, blackColor), new POIField(String.valueOf(round(powbSynthesisCrpStaffingCategory.getTotalFTE(), 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField( percentageFormat .format(round(powbSynthesisCrpStaffingCategory.getFemalePercentage() / 100.0, 4)), ParagraphAlignment.CENTER, bold, blackColor) }; data = Arrays.asList(sData); datas.add(data); poiSummary.textTable(document, headers, datas, false, "tableD"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableE() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = { new POIField("", ParagraphAlignment.CENTER), new POIField( this.getText("financialPlan.tableE.plannedBudget", new String[] { String.valueOf(this.getSelectedYear()) }), ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField("", ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.comments"), ParagraphAlignment.CENTER) }; POIField[] sHeader2 = { new POIField(" ", ParagraphAlignment.CENTER), new POIField( this.getText("financialPlan.tableE.carryOver", new String[] { String.valueOf(this.getSelectedYear() - 1) }), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w1w2"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.w3bilateral"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.centerFunds"), ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableE.total"), ParagraphAlignment.CENTER), new POIField(" ", ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); List<POIField> header2 = Arrays.asList(sHeader2); headers.add(header);// ww w . jav a2 s . co m headers.add(header2); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; powbSynthesisPMU.setPowbFinancialPlannedBudgetList(powbSynthesisPMU.getPowbFinancialPlannedBudget().stream() .filter(fp -> fp.isActive()).collect(Collectors.toList())); // Flagships List<LiaisonInstitution> flagships = this.getFlagships(); if (flagships != null && !flagships.isEmpty()) { for (LiaisonInstitution flagship : flagships) { Double carry = 0.0, w1w2 = 0.0, w3Bilateral = 0.0, center = 0.0, total = 0.0; String category = "", comments = ""; category = flagship.getAcronym(); PowbFinancialPlannedBudget powbFinancialPlannedBudget = this .getPowbFinancialPlanBudget(flagship.getId(), true); if (powbFinancialPlannedBudget != null) { w1w2 = powbFinancialPlannedBudget.getW1w2() != null ? powbFinancialPlannedBudget.getW1w2() : 0.0; carry = powbFinancialPlannedBudget.getCarry() != null ? powbFinancialPlannedBudget.getCarry() : 0.0; w3Bilateral = powbFinancialPlannedBudget.getW3Bilateral() != null ? powbFinancialPlannedBudget.getW3Bilateral() : 0.0; center = powbFinancialPlannedBudget.getCenterFunds() != null ? powbFinancialPlannedBudget.getCenterFunds() : 0.0; total = powbFinancialPlannedBudget.getTotalPlannedBudget() != null ? powbFinancialPlannedBudget.getTotalPlannedBudget() : 0.0; comments = powbFinancialPlannedBudget.getComments() == null || powbFinancialPlannedBudget.getComments().trim().isEmpty() ? " " : powbFinancialPlannedBudget.getComments(); } totalCarry += carry; totalw1w2 += w1w2; totalw3Bilateral += w3Bilateral; totalCenter += center; grandTotal += total; POIField[] sData = { new POIField(category, ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(carry, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w1w2, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w3Bilateral, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(center, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(total, 2)), ParagraphAlignment.CENTER), new POIField(comments, ParagraphAlignment.LEFT) }; data = Arrays.asList(sData); datas.add(data); } } // Expenditure areas List<PowbExpenditureAreas> powbExpenditureAreas = this.getPlannedBudgetAreas(); if (powbExpenditureAreas != null && !powbExpenditureAreas.isEmpty()) { for (PowbExpenditureAreas powbExpenditureArea : powbExpenditureAreas) { Double carry = 0.0, w1w2 = 0.0, w3Bilateral = 0.0, center = 0.0, total = 0.0; String category = "", comments = ""; category = powbExpenditureArea.getExpenditureArea(); PowbFinancialPlannedBudget powbFinancialPlannedBudget = this .getPowbFinancialPlanBudget(powbExpenditureArea.getId(), false); if (powbFinancialPlannedBudget != null) { w1w2 = powbFinancialPlannedBudget.getW1w2() != null ? powbFinancialPlannedBudget.getW1w2() : 0.0; carry = powbFinancialPlannedBudget.getCarry() != null ? powbFinancialPlannedBudget.getCarry() : 0.0; w3Bilateral = powbFinancialPlannedBudget.getW3Bilateral() != null ? powbFinancialPlannedBudget.getW3Bilateral() : 0.0; center = powbFinancialPlannedBudget.getCenterFunds() != null ? powbFinancialPlannedBudget.getCenterFunds() : 0.0; total = powbFinancialPlannedBudget.getTotalPlannedBudget() != null ? powbFinancialPlannedBudget.getTotalPlannedBudget() : 0.0; comments = powbFinancialPlannedBudget.getComments() == null || powbFinancialPlannedBudget.getComments().trim().isEmpty() ? " " : powbFinancialPlannedBudget.getComments(); } totalCarry += carry; totalw1w2 += w1w2; totalw3Bilateral += w3Bilateral; totalCenter += center; grandTotal += total; POIField[] sData = { new POIField(category, ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(carry, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w1w2, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(w3Bilateral, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(center, 2)), ParagraphAlignment.CENTER), new POIField(currencyFormat.format(round(total, 2)), ParagraphAlignment.CENTER), new POIField(comments, ParagraphAlignment.LEFT) }; data = Arrays.asList(sData); datas.add(data); } } Boolean bold = true; String blackColor = "000000"; POIField[] sData = { new POIField("CRP Total", ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalCarry, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalw1w2, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalw3Bilateral, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(totalCenter, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(currencyFormat.format(round(grandTotal, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(" ", ParagraphAlignment.LEFT, bold, blackColor) }; data = Arrays.asList(sData); datas.add(data); poiSummary.textTable(document, headers, datas, false, "tableE"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableF() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = {/*from www . j a v a 2 s .c o m*/ new POIField(this.getText("financialPlan.tableF.expenditureArea") + "*", ParagraphAlignment.CENTER), new POIField( this.getText("financialPlan.tableF.estimatedPercentage", new String[] { String.valueOf(this.getSelectedYear()) }) + "**", ParagraphAlignment.CENTER), new POIField(this.getText("financialPlan.tableF.comments"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; Double totalEstimatedPercentajeFS = 0.0; // Expenditure areas for (PowbExpenditureAreas powbExpenditureArea : powbExpenditureAreasManager.findAll().stream() .filter(a -> a.isActive() && a.getIsExpenditure()).collect(Collectors.toList())) { Double estimatedPercentajeFS = 0.0; String expenditureArea = "", commentsSpace = ""; expenditureArea = powbExpenditureArea.getExpenditureArea(); if (powbSynthesisPMU != null) { List<PowbFinancialExpenditure> powbFinancialExpenditureList = powbExpenditureArea .getPowbFinancialExpenditures().stream() .filter(f -> f.isActive() && f.getPowbSynthesis().equals(powbSynthesisPMU)) .collect(Collectors.toList()); if (powbFinancialExpenditureList != null && !powbFinancialExpenditureList.isEmpty()) { PowbFinancialExpenditure powbFinancialExpenditure = powbFinancialExpenditureList.get(0); estimatedPercentajeFS = powbFinancialExpenditure.getW1w2Percentage(); commentsSpace = powbFinancialExpenditure.getComments() == null || powbFinancialExpenditure.getComments().trim().isEmpty() ? " " : powbFinancialExpenditure.getComments(); totalEstimatedPercentajeFS += estimatedPercentajeFS; } } POIField[] sData = { new POIField(expenditureArea, ParagraphAlignment.LEFT), new POIField(percentageFormat.format(round(estimatedPercentajeFS / 100, 4)), ParagraphAlignment.CENTER), new POIField(commentsSpace, ParagraphAlignment.LEFT) }; data = Arrays.asList(sData); datas.add(data); } Boolean bold = true; String blackColor = "000000"; POIField[] sData = { new POIField("Total Funding (Amount)", ParagraphAlignment.LEFT, bold, blackColor), new POIField(currencyFormat.format(round((totalw1w2 * totalEstimatedPercentajeFS) / 100, 2)), ParagraphAlignment.CENTER, bold, blackColor), new POIField(" ", ParagraphAlignment.LEFT, bold, blackColor) }; data = Arrays.asList(sData); datas.add(data); poiSummary.textTable(document, headers, datas, true, "tableF"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableG() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = {/*from w w w . ja v a2 s . com*/ new POIField(this.getText("summaries.powb.tableG.crpName"), ParagraphAlignment.CENTER), new POIField(this.getText("summaries.powb.tableG.description"), ParagraphAlignment.CENTER), new POIField(this.getText("summaries.powb.tableG.relevantFP"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; for (PowbSynthesis powbSynthesis : powbSynthesisList) { List<PowbCollaborationGlobalUnit> powbCollaborationGlobalUnitList = powbSynthesis .getPowbCollaborationGlobalUnits().stream().filter(c -> c.isActive()) .collect(Collectors.toList()); if (powbCollaborationGlobalUnitList != null && !powbCollaborationGlobalUnitList.isEmpty()) { for (PowbCollaborationGlobalUnit powbCollaborationGlobalUnit : powbCollaborationGlobalUnitList) { String crpPlatform = " ", descriptionCollaboration = " ", relevantFP = " "; if (powbCollaborationGlobalUnit.getGlobalUnit() != null) { crpPlatform = powbCollaborationGlobalUnit.getGlobalUnit().getAcronym() != null && !powbCollaborationGlobalUnit.getGlobalUnit().getAcronym().isEmpty() ? powbCollaborationGlobalUnit.getGlobalUnit().getAcronym() : powbCollaborationGlobalUnit.getGlobalUnit().getName(); } descriptionCollaboration = powbCollaborationGlobalUnit.getBrief() != null && !powbCollaborationGlobalUnit.getBrief().isEmpty() ? powbCollaborationGlobalUnit.getBrief() : " "; relevantFP = powbCollaborationGlobalUnit.getFlagship() != null && !powbCollaborationGlobalUnit.getFlagship().isEmpty() ? powbCollaborationGlobalUnit.getFlagship() : " "; POIField[] sData = { new POIField(crpPlatform, ParagraphAlignment.CENTER), new POIField(descriptionCollaboration, ParagraphAlignment.LEFT), new POIField(relevantFP, ParagraphAlignment.LEFT) }; data = Arrays.asList(sData); datas.add(data); } } } poiSummary.textTable(document, headers, datas, false, "tableG"); }
From source file:org.cgiar.ccafs.marlo.action.summaries.POWBPOISummaryAction.java
License:Open Source License
private void createTableH() { List<List<POIField>> headers = new ArrayList<>(); POIField[] sHeader = {//from w w w . java 2s .c o m new POIField( this.getText("monitoringLearning.table.plannedStudies", new String[] { String.valueOf(this.getSelectedYear()) }), ParagraphAlignment.CENTER), new POIField(this.getText("monitoringLearning.table.comments"), ParagraphAlignment.CENTER) }; List<POIField> header = Arrays.asList(sHeader); headers.add(header); List<List<POIField>> datas = new ArrayList<>(); List<POIField> data; this.getFpPlannedList(this.getFlagships(), this.getSelectedPhase().getId()); for (PowbEvidencePlannedStudyDTO powbEvidencePlannedStudyDTO : flagshipPlannedList.stream().filter(p -> p .getProjectExpectedStudy() != null && p.getProjectExpectedStudy().getType() != null && (p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.EVAULATION.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.IMPACTASSESMENT.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.LEARNING.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.IMPACTCASESTUDY.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.CRP_PTF.getId() || p.getProjectExpectedStudy().getType() == TypeExpectedStudiesEnum.REVIEW.getId())) .collect(Collectors.toList())) { String plannedStudy = "", comments = ""; plannedStudy = powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getTopicStudy() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getTopicStudy().trim().isEmpty() ? powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getTopicStudy() : " "; comments = powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getComments() != null && !powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getComments().trim().isEmpty() ? powbEvidencePlannedStudyDTO.getProjectExpectedStudy().getComments() : " "; POIField[] sData = { new POIField(plannedStudy, ParagraphAlignment.LEFT), new POIField(comments, ParagraphAlignment.LEFT) }; data = Arrays.asList(sData); datas.add(data); } poiSummary.textTable(document, headers, datas, false, "tableH"); }