/** * Retrieves a document number for a credit memo by user defined criteria and sorts the values ascending if orderByAscending * parameter is true, descending otherwise. * * @param criteria - list of criteria to use in the retrieve * @param orderByAscending - boolean indicating results should be sorted ascending, descending otherwise * @return - Iterator of document numbers */ protected Iterator<Object[]> getDocumentNumbersOfCreditMemoByCriteria(Criteria criteria, boolean orderByAscending) { LOG.debug("getDocumentNumberOfCreditMemoByCriteria() started"); ReportQueryByCriteria rqbc = new ReportQueryByCriteria(VendorCreditMemoDocument.class, criteria); rqbc.setAttributes(new String[] { KFSPropertyConstants.DOCUMENT_NUMBER }); if (orderByAscending) { rqbc.addOrderByAscending(KFSPropertyConstants.DOCUMENT_NUMBER); } else { rqbc.addOrderByDescending(KFSPropertyConstants.DOCUMENT_NUMBER); } return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rqbc); }
protected Iterator<Object[]> getDocumentNumbersOfCorrectionReceivingByCriteria(Criteria criteria, boolean orderByAscending) { ReportQueryByCriteria rqbc = new ReportQueryByCriteria(CorrectionReceivingDocument.class, criteria); rqbc.setAttributes(new String[] { KFSPropertyConstants.DOCUMENT_NUMBER }); if (orderByAscending) { rqbc.addOrderByAscending(KFSPropertyConstants.DOCUMENT_NUMBER); } else { rqbc.addOrderByDescending(KFSPropertyConstants.DOCUMENT_NUMBER); } return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rqbc); }
/** * Retrieves a document number for a payment request by user defined criteria and sorts the values ascending if orderByAscending * parameter is true, descending otherwise. * * @param criteria - list of criteria to use in the retrieve * @param orderByAscending - boolean to sort results ascending if true, descending otherwise * @return - Iterator of document numbers */ protected Iterator<Object[]> getDocumentNumbersOfPaymentRequestByCriteria(Criteria criteria, boolean orderByAscending) { LOG.debug("getDocumentNumberOfPaymentRequestByCriteria() started"); ReportQueryByCriteria rqbc = new ReportQueryByCriteria(PaymentRequestDocument.class, criteria); rqbc.setAttributes(new String[] { KFSPropertyConstants.DOCUMENT_NUMBER }); if (orderByAscending) { rqbc.addOrderByAscending(KFSPropertyConstants.DOCUMENT_NUMBER); } else { rqbc.addOrderByDescending(KFSPropertyConstants.DOCUMENT_NUMBER); } return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rqbc); }
protected Iterator<Object[]> getDocumentNumbersOfBulkReceivingByCriteria(Criteria criteria, boolean orderByAscending) { ReportQueryByCriteria rqbc = new ReportQueryByCriteria(BulkReceivingDocument.class, criteria); rqbc.setAttributes(new String[] { KFSPropertyConstants.DOCUMENT_NUMBER }); if (orderByAscending) { rqbc.addOrderByAscending(KFSPropertyConstants.DOCUMENT_NUMBER); }else { rqbc.addOrderByDescending(KFSPropertyConstants.DOCUMENT_NUMBER); } return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rqbc); }
/** * Retrieves a document number for a payment request by user defined criteria and sorts the values ascending if orderByAscending * parameter is true, descending otherwise. * * @param criteria - list of criteria to use in the retrieve * @param orderByAscending - boolean to sort results ascending if true, descending otherwise * @return - Iterator of document numbers */ protected Iterator<Object[]> getDocumentNumbersOfReceivingLineByCriteria(Criteria criteria, boolean orderByAscending) { ReportQueryByCriteria rqbc = new ReportQueryByCriteria(LineItemReceivingDocument.class, criteria); rqbc.setAttributes(new String[] { KFSPropertyConstants.DOCUMENT_NUMBER }); if (orderByAscending) { rqbc.addOrderByAscending(KFSPropertyConstants.DOCUMENT_NUMBER); } else { rqbc.addOrderByDescending(KFSPropertyConstants.DOCUMENT_NUMBER); } return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rqbc); }