public List getPendingElectronicInvoices() { LOG.debug("getPendingElectronicInvoices() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("status.code", PurapConstants.PaymentRequestStatuses.PENDING_E_INVOICE); criteria.addEqualTo("isElectronicInvoice", Boolean.TRUE); List invoices = (List) getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(PaymentRequestDocument.class, criteria)); for (Iterator iter = invoices.iterator(); iter.hasNext();) { PaymentRequestDocument p = (PaymentRequestDocument) iter.next(); } return invoices; }
public Iterator<InvoiceRecurrence> getAllInvoiceRecurrences() { LOG.debug("getAllInvoiceRecurrencees() started"); Criteria criteria = new Criteria(); QueryByCriteria query = new QueryByCriteria(InvoiceRecurrence.class, criteria); query.addOrderByAscending("invoiceNumber"); return (Iterator<InvoiceRecurrence>)getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.NegativePaymentRequestApprovalLimitDao#findAboveLimit(org.kuali.rice.kns.util.KualiDecimal) */ public Collection<NegativePaymentRequestApprovalLimit> findAboveLimit(KualiDecimal limit) { LOG.debug("Entering findAboveLimit(KualiDecimal)"); Criteria criteria = new Criteria(); criteria.addGreaterThan("negativePaymentRequestApprovalLimitAmount", limit); criteria.addAndCriteria(buildActiveCriteria()); Query query = new QueryByCriteria(NegativePaymentRequestApprovalLimit.class, criteria); LOG.debug("Leaving findAboveLimit(KualiDecimal)"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.NegativePaymentRequestApprovalLimitDao#findBelowLimit(org.kuali.rice.kns.util.KualiDecimal) */ public Collection<NegativePaymentRequestApprovalLimit> findBelowLimit(KualiDecimal limit) { LOG.debug("Entering findBelowLimit(KualiDecimal)"); Criteria criteria = new Criteria(); criteria.addLessThan("negativePaymentRequestApprovalLimitAmount", limit); criteria.addAndCriteria(buildActiveCriteria()); Query query = new QueryByCriteria(NegativePaymentRequestApprovalLimit.class, criteria); LOG.debug("Leaving findBelowLimit(KualiDecimal)"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
public Iterator<InvoiceRecurrence> getAllActiveInvoiceRecurrences() { LOG.debug("getAllActiveInvoiceRecurrences() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("active", true); QueryByCriteria query = new QueryByCriteria(InvoiceRecurrence.class, criteria); query.addOrderByAscending("invoiceNumber"); return (Iterator<InvoiceRecurrence>)getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * @see org.kuali.kfs.module.ld.dataaccess.LaborLedgerBalanceDao#deleteLedgerBalancesPriorToYear(java.lang.Integer, java.lang.String) */ public void deleteLedgerBalancesPriorToYear(Integer fiscalYear, String chartOfAccountsCode) { LOG.debug("deleteLedgerBalancesPriorToYear() started"); Criteria criteria = new Criteria(); criteria.addLessThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartOfAccountsCode); QueryByCriteria query = new QueryByCriteria(LedgerBalance.class, criteria); getPersistenceBrokerTemplate().deleteByQuery(query); }
/** * @see org.kuali.kfs.fp.dataaccess.DisbursementVoucherDao#getDocumentsByHeaderStatus(java.lang.String) */ public Collection getDocumentsByHeaderStatus(String statusCode) { LOG.debug("getDocumentsByHeaderStatus() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("documentHeader.financialDocumentStatusCode", statusCode); criteria.addEqualTo("disbVchrPaymentMethodCode", DisbursementVoucherConstants.PAYMENT_METHOD_CHECK); return getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(DisbursementVoucherDocument.class, criteria)); } }
public ElectronicInvoiceLoadSummary getElectronicInvoiceLoadSummary(Integer loadId, String vendorDunsNumber) { LOG.debug("getElectronicInvoiceLoadSummary() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("id", loadId); criteria.addEqualTo("vendorDunsNumber", vendorDunsNumber); return (ElectronicInvoiceLoadSummary) getPersistenceBrokerTemplate().getObjectByQuery(new QueryByCriteria(ElectronicInvoiceLoadSummary.class, criteria)); }
/** * @see org.kuali.kfs.pdp.dataaccess.PaymentGroupDao#getAchPaymentsNeedingAdviceNotification() */ public List<PaymentGroup> getAchPaymentsNeedingAdviceNotification() { LOG.debug("getAchPaymentsNeedingAdviceNotification() started"); Criteria criteria = new Criteria(); criteria.addEqualTo(PdpPropertyConstants.PAYMENT_STATUS_CODE, PdpConstants.PaymentStatusCodes.EXTRACTED); criteria.addEqualTo(PdpPropertyConstants.DISBURSEMENT_TYPE_CODE, PdpConstants.DisbursementTypeCodes.ACH); criteria.addIsNull(PdpPropertyConstants.ADVICE_EMAIL_SENT_DATE); return (List<PaymentGroup>) getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(PaymentGroup.class, criteria)); }
/** * @see org.kuali.kfs.module.ld.dataaccess.LaborLedgerEntryDao#deleteLedgerEntriesPriorToYear(java.lang.Integer, java.lang.String) */ public void deleteLedgerEntriesPriorToYear(Integer fiscalYear, String chartOfAccountsCode) { LOG.debug("deleteLedgerEntriesPriorToYear() started"); Criteria criteria = new Criteria(); criteria.addLessThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartOfAccountsCode); QueryByCriteria query = new QueryByCriteria(this.getEntryClass(), criteria); getPersistenceBrokerTemplate().deleteByQuery(query); }
public ElectronicInvoiceItemMapping getByUniqueKeys(Integer headerId, Integer detailId, String invoiceTypeCode) { LOG.debug("getByUniqueKeys() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("vendorHeaderGeneratedId", headerId); criteria.addEqualTo("vendorDetailAssignedId", detailId); criteria.addEqualTo("electronicInvoiceItemTypeCode", invoiceTypeCode); QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class,criteria); return (ElectronicInvoiceItemMapping)getPersistenceBrokerTemplate().getObjectByQuery(qbc); }
public List<PaymentProcess> getAllExtractsToRun() { Criteria c = new Criteria(); c.addEqualTo(PdpPropertyConstants.PaymentProcess.EXTRACTED_IND, false); c.addEqualTo(PdpPropertyConstants.PaymentProcess.FORMATTED_IND, true); return (List<PaymentProcess>) getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(PaymentProcess.class, c)); }
/** * @see org.kuali.kfs.pdp.dataaccess.PaymentDetailDao#getUnprocessedPaidDetails(java.lang.String, java.lang.String) */ public Iterator getUnprocessedPaidDetails(String organization, List<String> subUnits) { LOG.debug("getUnprocessedPaidDetails() started"); Criteria criteria = new Criteria(); criteria.addIn(PdpPropertyConstants.PaymentDetail.PAYMENT_SUBUNIT_CODE, subUnits); criteria.addEqualTo(PdpPropertyConstants.PaymentDetail.PAYMENT_UNIT_CODE, organization); criteria.addEqualTo(PdpPropertyConstants.PaymentDetail.PAYMENT_STATUS_CODE, PdpConstants.PaymentStatusCodes.EXTRACTED); criteria.addIsNull(PdpPropertyConstants.PaymentDetail.PAYMENT_EPIC_PAYMENT_PAID_EXTRACTED_DATE); return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(PaymentDetail.class, criteria)); }
public PurchaseOrderDocument getCurrentPurchaseOrder(Integer id) { Criteria criteria = new Criteria(); criteria.addEqualTo(PurapPropertyConstants.PURAP_DOC_ID, id); criteria.addEqualTo(PurapPropertyConstants.PURCHASE_ORDER_CURRENT_INDICATOR, "Y"); return (PurchaseOrderDocument) getPersistenceBrokerTemplate().getObjectByQuery(new QueryByCriteria(PurchaseOrderDocument.class, criteria)); }
@Override public TimesheetDocumentHeader getNextDocumentHeader(String principalId, DateTime payEndDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay end date is the begin date of the next pay period crit.addEqualTo("beginDate", payEndDate.toDate()); QueryByCriteria query = new QueryByCriteria(TimesheetDocumentHeader.class, crit); query.setStartAtIndex(0); query.setEndAtIndex(1); return (TimesheetDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
protected void clearBothYearsBCPosition(Integer BaseYear) { Integer RequestYear = BaseYear + 1; Criteria criteriaId = new Criteria(); criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionPosition.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
protected void clearBothYearsHeaders(Integer BaseYear) { Integer RequestYear = BaseYear + 1; Criteria criteriaId = new Criteria(); criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionHeader.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
protected void clearBaseYearBCSF(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionCalculatedSalaryFoundationTracker.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
protected void clearBaseYearBCPosition(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionPosition.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
protected void clearBaseYearPendingApptFunding(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(PendingBudgetConstructionAppointmentFunding.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }