protected Iterator<Object[]> findCurrentFundsRawData(Map fieldValues) { Criteria criteria = OJBUtility.buildCriteriaFromMap(fieldValues, new LedgerBalance()); criteria.addEqualTo(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE, KFSConstants.BALANCE_TYPE_ACTUAL); List<String> objectTypeCodes = new ArrayList<String>(); objectTypeCodes.add(LaborConstants.BalanceInquiries.EMPLOYEE_FUNDING_EXPENSE_OBJECT_TYPE_CODE); objectTypeCodes.add(LaborConstants.BalanceInquiries.EMPLOYEE_FUNDING_NORMAL_OP_EXPENSE_OBJECT_TYPE_CODE); criteria.addIn(KFSPropertyConstants.FINANCIAL_OBJECT_TYPE_CODE, objectTypeCodes); return this.findFundsRawData(criteria); }
/** * build the query for encumbrance search * * @param fieldValues a Map of values to use as keys for the query * @return an OJB query */ protected Query getOpenEncumbranceQuery(Map fieldValues) { Criteria criteria = OJBUtility.buildCriteriaFromMap(fieldValues, new Encumbrance()); criteria.addIn(KFSPropertyConstants.BALANCE_TYPE_CODE, Arrays.asList(KFSConstants.ENCUMBRANCE_BALANCE_TYPE)); return QueryFactory.newQuery(Encumbrance.class, criteria); }
public Collection<NonAppliedHolding> getNonAppliedHoldingsByListOfDocumentNumbers(List<String> docNumbers) { Criteria criteria = new Criteria(); criteria.addIn("referenceFinancialDocumentNumber", docNumbers); QueryByCriteria query = QueryFactory.newQuery(NonAppliedHolding.class, criteria); return new ArrayList<NonAppliedHolding>(this.getPersistenceBrokerTemplate().getCollectionByQuery(query)); }
/** * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchivesCountByDocumentTypeNameAndETranCode(String, long) */ public long getTransactionArchivesCountByDocumentTypeNameAndETranCode(String feeMethodCode, Date transactionPostedDate) { long totalTransactionArchives = 0; Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_TYPE_CODE, getTypeCodes(feeMethodCode)); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_ETRAN_CODE, getETranCodes(feeMethodCode)); criteria.addGreaterThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, transactionPostedDate); QueryByCriteria query = QueryFactory.newQuery(TransactionArchive.class, criteria); totalTransactionArchives = getPersistenceBrokerTemplate().getCollectionByQuery(query).size(); return totalTransactionArchives; }
/** * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchivesCountByDocumentTypeNameAndETranCode(String, long) */ public long getTransactionArchivesCountByDocumentTypeNameAndETranCode(String feeMethodCode, Date transactionPostedDate) { long totalTransactionArchives = 0; Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_TYPE_CODE, getTypeCodes(feeMethodCode)); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_ETRAN_CODE, getETranCodes(feeMethodCode)); criteria.addGreaterThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, transactionPostedDate); QueryByCriteria query = QueryFactory.newQuery(TransactionArchive.class, criteria); totalTransactionArchives = getPersistenceBrokerTemplate().getCollectionByQuery(query).size(); return totalTransactionArchives; }
/** * @see org.kuali.kfs.module.ld.dataaccess.LaborObjectDao#findAllLaborObjectInPositionGroups(java.util.Map, java.util.List) */ public Collection<LaborObject> findAllLaborObjectInPositionGroups(Map<String, Object> fieldValues, List<String> positionGroupCodes) { LOG.debug("Start findAllLaborObjectInPositionGroups()"); Criteria criteria = OJBUtility.buildCriteriaFromMap(fieldValues, new LaborObject()); criteria.addIn(KFSPropertyConstants.POSITION_OBJECT_GROUP_CODE, positionGroupCodes); QueryByCriteria query = QueryFactory.newQuery(LaborObject.class, criteria); return getPersistenceBrokerTemplate().getCollectionByQuery(query); } }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.CreditMemoDao#getCreditMemosToExtract(java.lang.String) */ public Iterator<VendorCreditMemoDocument> getCreditMemosToExtract(String chartCode) { LOG.debug("getCreditMemosToExtract() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("processingCampusCode", chartCode); criteria.addIn("statusCode", Arrays.asList(CreditMemoStatuses.STATUSES_ALLOWED_FOR_EXTRACTION)); criteria.addIsNull("extractedTimestamp"); criteria.addEqualTo("holdIndicator", Boolean.FALSE); return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(VendorCreditMemoDocument.class, criteria)); }
/** * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchivesCountByETranCode(String, long) */ public long getTransactionArchivesCountByETranCode(String feeMethodCode, Date transactionPostedDate) { long totalTransactionArchives = 0; Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_ETRAN_CODE, getETranCodes(feeMethodCode)); criteria.addGreaterThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, transactionPostedDate); QueryByCriteria query = QueryFactory.newQuery(TransactionArchive.class, criteria); totalTransactionArchives = getPersistenceBrokerTemplate().getCollectionByQuery(query).size(); return totalTransactionArchives; }
/** * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchivesCountByETranCode(String, long) */ public long getTransactionArchivesCountByETranCode(String feeMethodCode, Date transactionPostedDate) { long totalTransactionArchives = 0; Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_ETRAN_CODE, getETranCodes(feeMethodCode)); criteria.addGreaterThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, transactionPostedDate); QueryByCriteria query = QueryFactory.newQuery(TransactionArchive.class, criteria); totalTransactionArchives = getPersistenceBrokerTemplate().getCollectionByQuery(query).size(); return totalTransactionArchives; }
/** * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchivesCountByDocumentTypeName(String, long) */ public long getTransactionArchivesCountByDocumentTypeName(String feeMethodCode, Date transactionPostedDate) { long totalTransactionArchives = 0; Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_TYPE_CODE, getTypeCodes(feeMethodCode)); criteria.addGreaterThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, transactionPostedDate); QueryByCriteria query = QueryFactory.newQuery(TransactionArchive.class, criteria); totalTransactionArchives = getPersistenceBrokerTemplate().getCollectionByQuery(query).size(); return totalTransactionArchives; }
/** * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchivesCountByDocumentTypeName(String, long) */ public long getTransactionArchivesCountByDocumentTypeName(String feeMethodCode, Date transactionPostedDate) { long totalTransactionArchives = 0; Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.TRANSACTION_ARCHIVE_TYPE_CODE, getTypeCodes(feeMethodCode)); criteria.addGreaterThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, transactionPostedDate); QueryByCriteria query = QueryFactory.newQuery(TransactionArchive.class, criteria); totalTransactionArchives = getPersistenceBrokerTemplate().getCollectionByQuery(query).size(); return totalTransactionArchives; }
/** * @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)); }
/** * This method retrieves all CustomerInvoiceDetail objects for the accountNumber if invoiceNumber is from the invoiceNumberList * @return CustomerInvoiceDetail objects */ public Collection getCustomerInvoiceDetailsByAccountNumberByInvoiceDocumentNumbers(String accountNumber,List documentNumbers) { Criteria criteria = new Criteria(); criteria.addIn(KNSPropertyConstants.DOCUMENT_NUMBER, documentNumbers); criteria.addEqualTo(KFSConstants.CustomerOpenItemReport.ACCOUNT_NUMBER, accountNumber); return getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(CustomerInvoiceDetail.class, criteria)); } }
/** * @see org.kuali.kfs.module.endow.dataaccess.SecurityDao#getSecuritiesByClassCodeWithUnitsGreaterThanZero(java.lang.String[]) */ public List<Security> getSecuritiesByClassCodeWithUnitsGreaterThanZero(List<String> classCodes) { Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.SECURITY_CLASS_CODE, classCodes); criteria.addGreaterThan(EndowPropertyConstants.SECURITY_UNITS_HELD, 0); return (List<Security>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(Security.class, criteria)); }
@Override public List<LeaveBlockHistory> getLeaveBlockHistories(String principalId, List<String> requestStatus) { Criteria recordCriteria = new Criteria(); recordCriteria.addEqualTo("principalId", principalId); if (requestStatus != null) { recordCriteria.addIn("requestStatus", requestStatus); } Query query = QueryFactory.newQuery(LeaveBlockHistory.class, recordCriteria); return (List<LeaveBlockHistory>) this.getPersistenceBrokerTemplate() .getCollectionByQuery(query); }
public Collection getByDocumentNumbers(List documentNumbers) { Criteria criteria = new Criteria(); criteria.addIn(KFSConstants.CustomerOpenItemReport.DOCUMENT_NUMBER, documentNumbers); return getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(getDocumentHeaderBaseClass(), criteria)); } }
/** * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getPBGLSalarySettingRows(java.lang.String, * java.util.List) */ public List getPBGLSalarySettingRows(String documentNumber, List salarySettingObjects) { List pbglSalarySettingRows = new ArrayList(); // need to make sure we are getting the data that was updated by the jdbc benefits calc calls getPersistenceBrokerTemplate().clearCache(); Criteria criteria = new Criteria(); criteria.addEqualTo("documentNumber", documentNumber); criteria.addIn("financialObjectCode", salarySettingObjects); QueryByCriteria query = QueryFactory.newQuery(PendingBudgetConstructionGeneralLedger.class, criteria); pbglSalarySettingRows = (List) getPersistenceBrokerTemplate().getCollectionByQuery(query); return pbglSalarySettingRows; }
/** * * @see org.kuali.kfs.module.endow.dataaccess.KemidHistoricalCashDao#getHistoricalCashRecords(java.util.List, org.kuali.rice.kns.util.KualiInteger) */ public List<KemidHistoricalCash> getHistoricalCashRecords(List<String> kemids, KualiInteger medId) { Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.ENDOWMENT_HIST_CASH_KEMID, kemids); criteria.addEqualTo(EndowPropertyConstants.ENDOWMENT_HIST_CASH_MED_ID, medId); QueryByCriteria qbc = QueryFactory.newQuery(KemidHistoricalCash.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.ENDOWMENT_HIST_CASH_KEMID); return (List<KemidHistoricalCash>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.CreditMemoDao#getCreditMemosToExtractByVendor(java.lang.String, java.lang.Integer, java.lang.Integer) */ public Collection<VendorCreditMemoDocument> getCreditMemosToExtractByVendor(String chartCode, VendorGroupingHelper vendor ) { LOG.debug("getCreditMemosToExtractByVendor() started"); Criteria criteria = new Criteria(); criteria.addEqualTo( "processingCampusCode", chartCode ); criteria.addIn( "statusCode", Arrays.asList(CreditMemoStatuses.STATUSES_ALLOWED_FOR_EXTRACTION) ); criteria.addIsNull( "extractedTimestamp" ); criteria.addEqualTo( "holdIndicator", Boolean.FALSE ); criteria.addEqualTo( "vendorHeaderGeneratedIdentifier", vendor.getVendorHeaderGeneratedIdentifier() ); criteria.addEqualTo( "vendorDetailAssignedIdentifier", vendor.getVendorDetailAssignedIdentifier() ); criteria.addEqualTo( "vendorCountryCode", vendor.getVendorCountry() ); criteria.addLike( "vendorPostalCode", vendor.getVendorPostalCode() + "%" ); return getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(VendorCreditMemoDocument.class, criteria)); }
public List<PendingBudgetConstructionAppointmentFunding> getFundingRecords(BudgetConstructionPayRateHolding holdingRecord, Integer budgetYear, List objectCodeValues) { Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, budgetYear); criteria.addIn(KFSPropertyConstants.FINANCIAL_OBJECT_CODE, objectCodeValues); criteria.addEqualTo(KFSPropertyConstants.EMPLID, holdingRecord.getEmplid()); criteria.addEqualTo(KFSPropertyConstants.POSITION_NUMBER, holdingRecord.getPositionNumber()); criteria.addEqualTo(KFSPropertyConstants.ACTIVE, "Y"); List<PendingBudgetConstructionAppointmentFunding> records = (List<PendingBudgetConstructionAppointmentFunding>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(PendingBudgetConstructionAppointmentFunding.class, criteria)); return records; }