exporter.putCurrencyFormat(sheetProvider, exportColumn); exportColumn = new I18nExportColumn("debitsExpected", "plugins.liquidityplanning.common.debit"); cols[colNo++] = exportColumn; exporter.putCurrencyFormat(sheetProvider, exportColumn); exportColumn = new I18nExportColumn("balanceExpected", "plugins.liquidityplanning.forecast.balance"); cols[colNo++] = exportColumn; exporter.putCurrencyFormat(sheetProvider, exportColumn); exporter.putCurrencyFormat(sheetProvider, exportColumn); exportColumn = new I18nExportColumn("debits", "plugins.liquidityplanning.common.debit"); cols[colNo++] = exportColumn; exporter.putCurrencyFormat(sheetProvider, exportColumn); exportColumn = new I18nExportColumn("balance", "plugins.liquidityplanning.forecast.balance"); cols[colNo++] = exportColumn; exporter.putCurrencyFormat(sheetProvider, exportColumn);
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); } }
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); } }