/** * @see * org.kuali.kfs.pdp.dataaccess.PaymentGroupDao#getDisbursementNumbersByDisbursementType(java.lang.Integer, * java.lang.String, java.lang.String) */ public List<Integer> getDisbursementNumbersByDisbursementTypeAndBankCode( Integer pid, String disbursementType, String bankCode) { if (LOG.isDebugEnabled()) { LOG.debug("getDisbursementNumbersByDisbursementType() started"); } List<Integer> results = new ArrayList<Integer>(); Criteria criteria = new Criteria(); criteria.addEqualTo(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_PROCESS_ID, pid); criteria.addEqualTo( PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_TYPE_CODE, disbursementType); criteria.addEqualTo(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_BANK_CODE, bankCode); String[] fields = new String[] {PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_NBR}; ReportQueryByCriteria rq = QueryFactory.newReportQuery(PaymentGroup.class, fields, criteria, true); rq.addOrderBy(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_NBR, true); Iterator i = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rq); while (i.hasNext()) { Object[] data = (Object[]) i.next(); BigDecimal d = (BigDecimal) data[0]; results.add(new Integer(d.intValue())); } return results; }
/** * Given a process id and a disbursement type, finds a distinct list of bank codes used by payment * groups within that payment process * * @param pid payment process to query payment groups of * @param disbursementType the type of disbursements to query * @return a sorted List of bank codes */ public List<String> getDistinctBankCodesForProcessAndType(Integer pid, String disbursementType) { List<String> results = new ArrayList<String>(); Criteria criteria = new Criteria(); criteria.addEqualTo(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_PROCESS_ID, pid); criteria.addEqualTo( PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_TYPE_CODE, disbursementType); String[] fields = new String[] {PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_BANK_CODE}; ReportQueryByCriteria rq = QueryFactory.newReportQuery(PaymentGroup.class, fields, criteria, true); rq.addOrderBy(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_BANK_CODE, true); Iterator iter = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rq); while (iter.hasNext()) { final Object[] row = (Object[]) iter.next(); final String bankCode = (String) row[0]; results.add(bankCode); } return results; }