public void add(Enum<?> e, Object obj) { add(e.name(), obj); }
private void addEndAtPeriodOfPerformance(final BigDecimal sum, final PropertyMapping mapping, final AuftragDO order, final AuftragsPositionDO pos, final Calendar startDate) { final Calendar posEndDate = getEndLeistungszeitraumNextMonthEnd(order, pos); int index = this.getMonthIndex(posEndDate, startDate); if (index < 0 || index > 11) { return; } // handle payment difference final Object previousValue = mapping.getMapping().get(monthCols[index].name()); if (previousValue == null && checkAfterMonthBefore(posEndDate)) { mapping.add(monthCols[index], sum); } else { if (checkAfterMonthBefore(posEndDate)) { mapping.add(monthCols[index], sum.add((BigDecimal) previousValue)); } } }
public void addCreditorInvoicesSheet(final MyExcelExporter exporter, final String title, final Collection<EingangsrechnungDO> list) { final ExportSheet sheet = exporter.addSheet(title); sheet.createFreezePane(0, 1); final ContentProvider sheetProvider = sheet.getContentProvider(); final ExportColumn[] cols = new ExportColumn[5]; int i = 0; cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "datum"); cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "faelligkeit"); cols[i] = new I18nExportColumn("gross", "fibu.rechnung.bruttoBetrag", 10); exporter.putCurrencyFormat(sheetProvider, cols[i++]); cols[i++] = new I18nExportColumn("creditor", "fibu.common.creditor", 60); cols[i++] = new I18nExportColumn("subject", PropUtils.getI18nKey(AbstractRechnungDO.class, "betreff"), 100); // column property names sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final EingangsrechnungDO entry : list) { entry.recalculate(); mapping.add("datum", entry.getDatum()); mapping.add("faelligkeit", entry.getFaelligkeit()); mapping.add("gross", entry.getGrossSum()); mapping.add("creditor", entry.getKreditor()); mapping.add("subject", entry.getBetreff()); sheet.addRow(mapping.getMapping(), 0); } }
final PropertyMapping mapping = new PropertyMapping(); for (final Field field : fields) { final PropertyInfo propInfo = field.getAnnotation(PropertyInfo.class); sheet.addRow(mapping.getMapping(), 0);
sheetProvider.putFormat(Col.WORKDAYS, "0.00"); final PropertyMapping mapping = new PropertyMapping();
public void addDebitorInvoicesSheet(final MyExcelExporter exporter, final String title, final Collection<RechnungDO> list) { final ExportSheet sheet = exporter.addSheet(title); sheet.createFreezePane(0, 1); final ContentProvider sheetProvider = sheet.getContentProvider(); final ExportColumn[] cols = new ExportColumn[6]; int i = 0; cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "datum"); cols[i++] = createColumn(exporter, sheet, AbstractRechnungDO.class, "faelligkeit"); cols[i] = new I18nExportColumn("gross", "fibu.rechnung.bruttoBetrag", 10); exporter.putCurrencyFormat(sheetProvider, cols[i++]); cols[i++] = new I18nExportColumn("number", "fibu.rechnung.nummer", 6); cols[i++] = new I18nExportColumn("debitor", "fibu.common.debitor", 60); cols[i++] = new I18nExportColumn("subject", PropUtils.getI18nKey(AbstractRechnungDO.class, "betreff"), 100); // column property names sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final RechnungDO entry : list) { entry.recalculate(); mapping.add("datum", entry.getDatum()); mapping.add("faelligkeit", entry.getFaelligkeit()); mapping.add("gross", entry.getGrossSum()); mapping.add("number", entry.getNummer()); mapping.add("debitor", entry.getKundeAsString()); mapping.add("subject", entry.getBetreff()); sheet.addRow(mapping.getMapping(), 0); } }
calculateIstSum(istSumMap, startDate, pos); if (pos.getStatus() != null && auftragsPositionsStatusToShow.contains(pos.getStatus())) { PropertyMapping mapping = new PropertyMapping(); addPosMapping(mapping, order, pos, startDate); sheet.addRow(mapping.getMapping(), 0);
sheetProvider.putFormat(Col.WORKDAYS, "0.00"); final PropertyMapping mapping = new PropertyMapping();
PropertyMapping mapping = new PropertyMapping(); mapping.add("balanceExpected", BigDecimal.ZERO); mapping.add("balance", new Formula("D" + firstDataRowNumber)); sheet.addRow(mapping.getMapping(), 0); mapping.add("date", current); mapping.add("creditsExpected", NumberHelper.isZeroOrNull(creditsExpected[i]) == true ? "" : creditsExpected[i]); mapping.add("debitsExpected", NumberHelper.isZeroOrNull(debitsExpected[i]) == true ? "" : debitsExpected[i]); mapping.add("balanceExpected", new Formula("D" + rowNumber + "+SUM(B" + rowNumber + ":C" + rowNumber + ")")); mapping.add("credits", NumberHelper.isZeroOrNull(credits[i]) == true ? "" : credits[i]); mapping.add("debits", NumberHelper.isZeroOrNull(debits[i]) == true ? "" : debits[i]); mapping.add("balance", new Formula("G" + rowNumber + "+SUM(E" + rowNumber + ":F" + rowNumber + ")")); sheet.addRow(mapping.getMapping(), 0); current.add(Calendar.DAY_OF_YEAR, 1); mapping = new PropertyMapping(); mapping.add("creditsExpected", new Formula("SUM(B" + firstDataRowNumber + ":B" + sheet.getRowCounter() + ")")); mapping.add("debitsExpected", new Formula("SUM(C" + firstDataRowNumber + ":C" + sheet.getRowCounter() + ")")); mapping.add("balanceExpected", new Formula("D" + firstDataRowNumber + "+SUM(B" + firstDataRowNumber + ":C" + sheet.getRowCounter() + ")")); mapping.add("credits", new Formula("SUM(E" + firstDataRowNumber + ":E" + sheet.getRowCounter() + ")")); mapping.add("debits", new Formula("SUM(F" + firstDataRowNumber + ":F" + sheet.getRowCounter() + ")")); mapping.add("balance", new Formula("G" + firstDataRowNumber + "+SUM(E" + firstDataRowNumber + ":F" + sheet.getRowCounter() + ")")); sheet.addRow(mapping.getMapping(), 0);
sheet.setColumns(columns); final PropertyMapping mapping = new PropertyMapping(); for (final AddressDO address : list) { addAddressMapping(mapping, address, params); sheet.addRow(mapping.getMapping(), 0);
protected void exportExcel() { log.info("Exporting kost1 list."); refresh(); final List<Kost1DO> kost1List = getList(); if (kost1List == null || kost1List.size() == 0) { // Nothing to export. form.addError("validation.error.nothingToExport"); return; } final String filename = "ProjectForge-Kost1Export_" + DateHelper.getDateAsFilenameSuffix(new Date()) + ".xls"; final ExportWorkbook xls = new ExportWorkbook(); final ContentProvider contentProvider = new MyXlsContentProvider(xls); xls.setContentProvider(contentProvider); final ExportSheet sheet = xls.addSheet(ThreadLocalUserContext.getLocalizedString("fibu.kost1.kost1s")); final ExportColumn[] cols = new ExportColumn[] { // new I18nExportColumn(Col.KOST, "fibu.kost1", MyXlsContentProvider.LENGTH_KOSTENTRAEGER), new I18nExportColumn(Col.DESCRIPTION, "description", MyXlsContentProvider.LENGTH_STD), new I18nExportColumn(Col.STATUS, "status", MyXlsContentProvider.LENGTH_STD) }; sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final Kost1DO kost : kost1List) { mapping.add(Col.KOST, kost.getFormattedNumber()); mapping.add(Col.STATUS, kost.getKostentraegerStatus()); mapping.add(Col.DESCRIPTION, kost.getDescription()); sheet.addRow(mapping.getMapping(), 0); } sheet.setZoom(3, 4); // 75% DownloadUtils.setDownloadTarget(xls.getAsByteArray(), filename); }
sheet.setColumns(columns); for (final AuftragDO order : list) { final PropertyMapping mapping = new PropertyMapping(); addOrderMapping(mapping, order); sheet.addRow(mapping.getMapping(), 0); for (final AuftragDO order : list) { for (final AuftragsPositionDO pos : order.getPositionenExcludingDeleted()) { final PropertyMapping mapping = new PropertyMapping(); addPosMapping(mapping, order, pos); sheet.addRow(mapping.getMapping(), 0); final PropertyMapping mapping = new PropertyMapping(); addPaymentsMapping(mapping, order, paymentScheduleDO); sheet.addRow(mapping.getMapping(), 0);
new I18nExportColumn(Col.COMMENT, "comment", MyXlsContentProvider.LENGTH_STD) }; sheet.setColumns(cols); final PropertyMapping mapping = new PropertyMapping(); for (final Kost2DO kost : kost2List) { mapping.add(Col.KOST, kost.getFormattedNumber()); mapping.add(Col.ART, kost.getKost2Art().getName()); mapping.add(Col.FAKTURIERT, kost.getKost2Art().isFakturiert() ? "X" : ""); mapping.add(Col.PROJEKT, KostFormatter.formatProjekt(kost.getProjekt())); mapping.add(Col.STATUS, kost.getKostentraegerStatus()); mapping.add(Col.DESCRIPTION, kost.getDescription()); mapping.add(Col.COMMENT, kost.getComment()); sheet.addRow(mapping.getMapping(), 0);
private void addPaymentsMapping(final PropertyMapping mapping, final AuftragDO order, final PaymentScheduleDO scheduleDO) { mapping.add(PaymentsCol.NUMBER, order.getNummer()); final Short positionNumber = scheduleDO.getPositionNumber(); mapping.add(PaymentsCol.POS_NUMBER, positionNumber != null ? "#" + positionNumber : ""); mapping.add(PaymentsCol.PAY_NUMBER, "#" + scheduleDO.getNumber()); mapping.add(PaymentsCol.AMOUNT, scheduleDO.getAmount()); mapping.add(PaymentsCol.COMMENT, scheduleDO.getComment()); mapping.add(PaymentsCol.REACHED, scheduleDO.isReached() == true ? "x" : ""); mapping.add(PaymentsCol.VOLLSTAENDIG_FAKTURIERT, scheduleDO.isVollstaendigFakturiert() == true ? "x" : ""); mapping.add(PaymentsCol.SCHEDULE_DATE, scheduleDO.getScheduleDate()); }
sheetProvider.putFormat(Col.WEEKENDHOURS, "0.00"); final PropertyMapping mapping = new PropertyMapping(); for (final HRPlanningDO planningSheet : list) { sheet.addRow(mapping.getMapping(), 0);
final List<KontoDO> list = kontoDao.getList(filter); final PropertyMapping mapping = new PropertyMapping(); for (final KontoDO konto : list) { mapping.add(AccountsCol.NUMBER, konto.getNummer()); mapping.add(AccountsCol.NAME, konto.getBezeichnung()); mapping.add(AccountsCol.DATE_OF_LAST_MODIFICATION, konto.getLastUpdate()); mapping.add(AccountsCol.DATE_OF_CREATION, konto.getCreated()); String status = ""; if (konto.isDeleted() == true) { status = ThreadLocalUserContext.getLocalizedString(konto.getStatus().getI18nKey()); mapping.add(AccountsCol.STATUS, status); mapping.add(AccountsCol.DESCRIPTION, konto.getDescription()); sheet.addRow(mapping.getMapping(), 0);
/** * Override this for modifying the object field values. Called by {@link #addList(ExportSheet, List)}. * * @param mapping * @param entry The current entry of the list to add to the Excel sheet. * @param field The field of the entry to add. */ public void addMapping(final PropertyMapping mapping, final Object entry, final Field field) { mapping.add(field.getName(), BeanHelper.getFieldValue(entry, field)); }
final PropertyMapping mapping = new PropertyMapping(); final TaskTree taskTree = TaskTreeHelper.getTaskTree(); final UserGroupCache userGroupCache = TenantRegistryMap.getInstance().getTenantRegistry().getUserGroupCache(); final TaskNode node = taskTree.getTaskNodeById(timesheet.getTaskId()); final PFUserDO user = userGroupCache.getUser(timesheet.getUserId()); mapping.add(Col.USER, user.getFullname()); final Kost2DO kost2 = timesheet.getKost2(); String kost2Name = null; mapping.add(Col.KOST2, kost2Name); mapping.add(Col.PROJEKT, projektName); mapping.add(Col.KUNDE, kundeName); mapping.add(Col.TASK_TITLE, node.getTask().getTitle()); mapping.add(Col.TASK_PATH, TaskFormatter.getTaskPath(timesheet.getTaskId(), null, true, OutputType.PLAIN)); mapping.add(Col.WEEK_OF_YEAR, timesheet.getFormattedWeekOfYear()); mapping.add(Col.DAY_OF_WEEK, dateTimeFormatter.getFormattedDate(timesheet.getStartTime(), DateFormats .getFormatString(DateFormatType.DAY_OF_WEEK_SHORT))); final DateHolder startTime = new DateHolder(timesheet.getStartTime()); final DateHolder stopTime = new DateHolder(timesheet.getStopTime()); mapping.add(Col.START_TIME, startTime); mapping.add(Col.STOP_TIME, stopTime); final BigDecimal seconds = new BigDecimal(timesheet.getDuration() / 1000); // Seconds final BigDecimal duration = seconds.divide(new BigDecimal(60 * 60 * 24), 8, RoundingMode.HALF_UP); // Fraction of day (24 hours) mapping.add(Col.DURATION, duration.doubleValue()); final BigDecimal hours = seconds.divide(new BigDecimal(60 * 60), 2, RoundingMode.HALF_UP); mapping.add(Col.HOURS, hours.doubleValue()); mapping.add(Col.LOCATION, timesheet.getLocation()); mapping.add(Col.REFERENCE, node.getReference());