final PropertyMapping mapping = new PropertyMapping(); for (final Field field : fields) { final PropertyInfo propInfo = field.getAnnotation(PropertyInfo.class);
sheetProvider.putFormat(Col.WORKDAYS, "0.00"); final PropertyMapping mapping = new PropertyMapping();
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();
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); final PropertyMapping mapping = new PropertyMapping(); for (final AddressDO address : list) { addAddressMapping(mapping, address, params);
final PropertyMapping mapping = new PropertyMapping(); final PFUserDO user = getUserGroupCache().getUser(salary.getEmployee().getUserId()); Validate.isTrue(year == salary.getYear()); final PropertyMapping mapping = new PropertyMapping(); mapping.add(ExcelColumn.MITARBEITER, user.getFullname()); mapping.add(ExcelColumn.SUMME, "***");
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());
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); } }
sheetProvider.putFormat(Col.ID, "0"); final PropertyMapping mapping = new PropertyMapping(); final TaskTree taskTree = TaskTreeHelper.getTaskTree(); final UserGroupCache userGroupCache = TenantRegistryMap.getInstance().getTenantRegistry().getUserGroupCache();
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); } }
sheetProvider.putFormat(Col.WEEKENDHOURS, "0.00"); final PropertyMapping mapping = new PropertyMapping(); for (final HRPlanningDO planningSheet : list) {
sheetProvider.putFormat(InvoicesCol.DATE, "dd.MM.yyyy"); final PropertyMapping mapping = new PropertyMapping(); for (final KostZuweisungDO zuweisung : list) { final AbstractRechnungsPositionDO position;
final List<KontoDO> list = kontoDao.getList(filter); final PropertyMapping mapping = new PropertyMapping(); for (final KontoDO konto : list) { mapping.add(AccountsCol.NUMBER, konto.getNummer());
PropertyMapping mapping = new PropertyMapping(); mapping.add("balanceExpected", BigDecimal.ZERO); mapping.add("balance", new Formula("D" + firstDataRowNumber)); 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() + ")"));