protected void exportExcelWithCostAssignments() { refresh(); final RechnungFilter filter = new RechnungFilter(); final RechnungFilter src = form.getSearchFilter(); filter.setFromDate(src.getFromDate()); filter.setToDate(src.getToDate()); final List<EingangsrechnungDO> rechnungen = eingangsrechnungDao.getList(filter); if (rechnungen == null || rechnungen.size() == 0) { // Nothing to export. form.addError("validation.error.nothingToExport"); return; } final String filename = "ProjectForge-" + getString("fibu.common.creditor") + "-" + getString("menu.fibu.kost") + "_" + DateHelper.getDateAsFilenameSuffix(new Date()) + ".xls"; final byte[] xls = kostZuweisungExport.exportRechnungen(rechnungen, getString("fibu.common.creditor"), kontoCache); if (xls == null || xls.length == 0) { log.error("Oups, xls has zero size. Filename: " + filename); return; } DownloadUtils.setDownloadTarget(xls, filename); }
queryFilter.addOrder(Order.desc("kreditor")); final List<EingangsrechnungDO> list = getList(queryFilter); if (myFilter.isShowAll() == true || myFilter.isDeleted() == true) { return list;
/** * Calculates expected dates of payments inside the last year (-365 days). */ private LiquidityForecast getForecast() { // Consider only invoices of the last year: final java.sql.Date fromDate = new DayHolder().add(Calendar.DAY_OF_YEAR, -365).getSQLDate(); { final List<RechnungDO> paidInvoices = rechnungDao.getList(new RechnungFilter().setShowBezahlt().setFromDate(fromDate)); forecast.calculateExpectedTimeOfPayments(paidInvoices); final List<RechnungDO> invoices = rechnungDao.getList(new RechnungFilter().setShowUnbezahlt()); forecast.setInvoices(invoices); } { final List<EingangsrechnungDO> paidInvoices = eingangsrechnungDao.getList(new RechnungFilter().setShowBezahlt().setFromDate(fromDate)); forecast.calculateExpectedTimeOfCreditorPayments(paidInvoices); final List<EingangsrechnungDO> creditorInvoices = eingangsrechnungDao.getList(new RechnungFilter().setListType(RechnungFilter.FILTER_UNBEZAHLT)); forecast.setCreditorInvoices(creditorInvoices); } final List<LiquidityEntryDO> list = liquidityEntryDao.getList(new LiquidityFilter().setPaymentStatus(PaymentStatus.UNPAID)); forecast.set(list); forecast.build(); return forecast; }
private void checkNoAccess(Serializable id, EingangsrechnungDO eingangsrechnung, String who) { try { RechnungFilter filter = new RechnungFilter(); eingangsrechnungDao.getList(filter); fail("AccessException expected: " + who + " users should not have select list access to invoices."); } catch (AccessException ex) { // OK } try { eingangsrechnungDao.getById(id); fail("AccessException expected: " + who + " users should not have select access to invoices."); } catch (AccessException ex) { // OK } checkNoHistoryAccess(id, eingangsrechnung, who); checkNoWriteAccess(id, eingangsrechnung, who); }