protected DOListExcelExporter createExcelExporter(final String filenameIdentifier) { return new DOListExcelExporter(filenameIdentifier); }
protected void exportExcel(final String filenameIdentifier, final String sheetTitle) { refresh(); final DOListExcelExporter exporter = createExcelExporter(filenameIdentifier); if (exporter == null) { // Nothing to export. form.addError("validation.error.nothingToExport"); return; } final List<?> list = getList(); if (list != null && list.size() > 0) { final ExportSheet sheet = exporter.addSheet(sheetTitle != null ? sheetTitle : "data"); exporter.addList(sheet, list); if (exporter.isExcelAutoFilter() == true) { sheet.setAutoFilter(); } } exporter.onBeforeDownload(); if (exporter.getWorkbook().getNumberOfSheets() == 0) { // Nothing to export. form.addError("validation.error.nothingToExport"); return; } DownloadUtils.setDownloadTarget(exporter.getWorkbook().getAsByteArray(), exporter.getFilename()); }
/** * @see ExcelExporter#addMapping(PropertyMapping, java.lang.Object, * java.lang.reflect.Field) */ @Override public void addMapping(final PropertyMapping mapping, final Object entry, final Field field) { if ("month".equals(field.getName()) == true) { final EmployeeSalaryDO salary = (EmployeeSalaryDO) entry; // Excel month starts with 1 instead of 0: mapping.add(field.getName(), salary.getMonth() + 1); } else { super.addMapping(mapping, entry, field); } } };
/** * @see org.projectforge.export.DOListExcelExporter#putFieldFormat(ContentProvider, * java.lang.reflect.Field, org.projectforge.common.anots.PropertyInfo, ExportColumn) */ @Override public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo, final ExportColumn exportColumn) { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn); if ("dateOfPayment".equals(field.getName()) == true) { exportColumn.setWidth(12); } else if ("paid".equals(field.getName()) == true) { exportColumn.setWidth(8); } else if ("subject".equals(field.getName()) == true) { exportColumn.setWidth(40); } else if ("comment".equals(field.getName()) == true) { exportColumn.setWidth(80); } }
/** * @see ExcelExporter#addMapping(PropertyMapping, java.lang.Object, * java.lang.reflect.Field) */ @Override public void addMapping(final PropertyMapping mapping, final Object entry, final Field field) { if ("skill".equals(field.getName()) == true) { final SkillDO skill = ((SkillRatingDO) entry).getSkill(); mapping.add(field.getName(), skill != null ? skill.getTitle() : ""); } else { super.addMapping(mapping, entry, field); } } };
/** * @see org.projectforge.export.MyExcelExporter#putFieldFormat(ContentProvider, * java.lang.reflect.Field, org.projectforge.common.anots.PropertyInfo, ExportColumn) */ @Override public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo, final ExportColumn exportColumn) { if ("month".equals(field.getName()) == true) { sheetProvider.putFormat(exportColumn, "mmm"); exportColumn.setWidth(6); } else if ("year".equals(field.getName()) == true) { sheetProvider.putFormat(exportColumn, "#"); exportColumn.setWidth(6); } else { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn); } }
/** * @see ExcelExporter#addMapping(PropertyMapping, java.lang.Object, * java.lang.reflect.Field) */ @Override public void addMapping(final PropertyMapping mapping, final Object entry, final Field field) { if ("training".equals(field.getName()) == true) { final SkillDO skill = ((TrainingAttendeeDO) entry).getTraining().getSkill(); mapping.add(field.getName(), skill != null ? skill.getTitle() : ""); } else { super.addMapping(mapping, entry, field); } } };
/** * @see ExcelExporter#addMapping(PropertyMapping, java.lang.Object, * java.lang.reflect.Field) */ @Override public void addMapping(final PropertyMapping mapping, final Object entry, final Field field) { if ("konto".equals(field.getName()) == true) { Integer kontoNummer = null; final Integer kontoId = ((EingangsrechnungDO) entry).getKontoId(); if (kontoId != null) { final KontoDO konto = kontoCache.getKonto(kontoId); if (konto != null) { kontoNummer = konto.getNummer(); } } mapping.add(field.getName(), kontoNummer != null ? kontoNummer : ""); } else { super.addMapping(mapping, entry, field); } }
/** * @see ExcelExporter#addMapping(PropertyMapping, java.lang.Object, * java.lang.reflect.Field) */ @Override public void addMapping(final PropertyMapping mapping, final Object entry, final Field field) { if ("kunde".equals(field.getName()) == true) { final RechnungDO rechnung = (RechnungDO) entry; mapping.add(field.getName(), KundeFormatter.formatKundeAsString(rechnung.getKunde(), rechnung.getKundeText())); } else if ("konto".equals(field.getName()) == true) { Integer kontoNummer = null; final KontoDO konto = kontoCache.getKonto((RechnungDO) entry); if (konto != null) { kontoNummer = konto.getNummer(); } mapping.add(field.getName(), kontoNummer != null ? kontoNummer : ""); } else { super.addMapping(mapping, entry, field); } }