/** * @see org.kuali.kfs.pdp.dataaccess.PendingTransactionDao#getUnextractedTransactions() */ public Iterator<GlPendingTransaction> getUnextractedTransactions() { LOG.debug("save() started"); Criteria criteria = new Criteria(); criteria.addEqualTo(PdpPropertyConstants.PROCESS_IND, false); Criteria criteria2 = new Criteria(); criteria2.addIsNull(PdpPropertyConstants.PROCESS_IND); criteria.addOrCriteria(criteria2); return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(GlPendingTransaction.class, criteria)); }
/** * @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)); }
@Override public List<BalanceTransfer> getAllBalanceTransferForPrincipalIdAsOfDate( String principalId, LocalDate effectiveDate) { List<BalanceTransfer> balanceTransfers = new ArrayList<BalanceTransfer>(); Criteria crit = new Criteria(); crit.addEqualTo("principalId",principalId); Criteria effDate = new Criteria(); effDate.addGreaterOrEqualThan("effectiveDate", effectiveDate.toDate()); crit.addAndCriteria(effDate); Query query = QueryFactory.newQuery(BalanceTransfer.class,crit); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if(c != null) balanceTransfers.addAll(c); return balanceTransfers; }
/** * Builds a Criteria object for active field set to true * @return Criteria */ private Criteria buildActiveCriteria(){ Criteria criteria = new Criteria(); criteria.addEqualTo(KRADPropertyConstants.ACTIVE, true); return criteria; }
/** * Builds a criteria to find non-expired accounts * @return a Criteria for non-expired accounts */ protected Criteria getAccountNotExpiredCriteria() { Criteria criteria = new Criteria(); criteria.addIsNull("accountExpirationDate"); Criteria notYetExpiredCriteria = new Criteria(); notYetExpiredCriteria.addGreaterThan("accountExpirationDate", dateTimeService.getCurrentSqlDate()); criteria.addOrCriteria(notYetExpiredCriteria); return criteria; }
/** * @see org.kuali.kfs.coa.batch.dataaccess.impl.FiscalYearMakerHelperImpl#createSelectionCriteria(java.lang.Integer) */ @Override public Criteria createSelectionCriteria(Integer baseFiscalYear) { // get default criteria equal to base year and active Criteria criteria = super.createSelectionCriteria(baseFiscalYear); // or with criteria to pick up budget dummy object for base year (active or inactive) Criteria criteriaBdg = new Criteria(); criteriaBdg.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, baseFiscalYear); criteriaBdg.addEqualTo(KFSPropertyConstants.FINANCIAL_OBJECT_CODE, KFSConstants.BudgetConstructionConstants.OBJECT_CODE_2PLG); criteria.addOrCriteria(criteriaBdg); return criteria; }
@Override public PositionReportCategoryBo getPositionReportCat(String positionReportCat, LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("positionReportCat", positionReportCat); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionReportCategoryBo.class, asOfDate, PositionReportCategoryBo.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionReportCategoryBo.class, PositionReportCategoryBo.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); // Inner Join For Activity activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(PositionReportCategoryBo.class, root); return (PositionReportCategoryBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
/** * @see org.kuali.kfs.module.endow.dataaccess.KemidHistoricalCashDao#getHistoricalCashRecords(java.util.List, org.kuali.rice.kns.util.KualiInteger, org.kuali.rice.kns.util.KualiInteger) */ public List<KemidHistoricalCash> getHistoricalCashRecords(List<String> kemids, KualiInteger beginningMed, KualiInteger endingMed) { Criteria criteria = new Criteria(); Collection<KualiInteger> monthEndIds = new ArrayList<KualiInteger>(); monthEndIds.add(beginningMed); monthEndIds.add(endingMed); if (kemids != null) { for (String kemid : kemids) { Criteria c = new Criteria(); if (kemid.contains(KFSConstants.WILDCARD_CHARACTER)) { c.addLike(EndowPropertyConstants.KEMID, kemid.trim().replace(KFSConstants.WILDCARD_CHARACTER, KFSConstants.PERCENTAGE_SIGN)); } else { c.addEqualTo(EndowPropertyConstants.KEMID, kemid.trim()); } criteria.addOrCriteria(c); } } criteria.addIn(EndowPropertyConstants.ENDOWMENT_HIST_CASH_MED_ID, monthEndIds); 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.endow.dataaccess.IncomeDistributionForPooledFundDao#getKemidPayoutInstructionForECT(java.lang.String) */ public List<KemidPayoutInstruction> getKemidPayoutInstructionForECT(String kemid, Date currentDate) { Criteria crit = new Criteria(); Criteria crit2 = new Criteria(); Criteria crit21 = new Criteria(); crit.addEqualTo(EndowPropertyConstants.KEMID_PAY_INC_KEMID, kemid); crit.addNotEqualTo(EndowPropertyConstants.KEMID_PAY_INC_TO_KEMID, kemid); crit.addLessOrEqualThan(EndowPropertyConstants.KEMID_PAY_INC_START_DATE, currentDate); crit2.addGreaterThan(EndowPropertyConstants.KEMID_PAY_INC_END_DATE, currentDate); crit21.addIsNull(EndowPropertyConstants.KEMID_PAY_INC_END_DATE); crit2.addOrCriteria(crit21); crit.addAndCriteria(crit2); return (List<KemidPayoutInstruction>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(KemidPayoutInstruction.class, crit)); }
/** * * @see org.kuali.kfs.module.purap.document.dataaccess.PaymentRequestDao#getPaymentRequestsToExtractForVendor(java.lang.String, org.kuali.kfs.module.purap.util.VendorGroupingHelper) */ public Collection<PaymentRequestDocument> getPaymentRequestsToExtractForVendor(String campusCode, VendorGroupingHelper vendor, Date onOrBeforePaymentRequestPayDate) { LOG.debug("getPaymentRequestsToExtract() started"); List statuses = new ArrayList(); statuses.add(PurapConstants.PaymentRequestStatuses.AUTO_APPROVED); statuses.add(PurapConstants.PaymentRequestStatuses.DEPARTMENT_APPROVED); Criteria criteria = new Criteria(); criteria.addEqualTo("processingCampusCode", campusCode); criteria.addIn("statusCode", statuses); criteria.addIsNull("extractedTimestamp"); criteria.addEqualTo("holdIndicator", Boolean.FALSE); Criteria c1 = new Criteria(); c1.addLessOrEqualThan("paymentRequestPayDate", onOrBeforePaymentRequestPayDate); Criteria c2 = new Criteria(); c2.addEqualTo("immediatePaymentIndicator", Boolean.TRUE); c1.addOrCriteria(c2); criteria.addAndCriteria(c1); 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(PaymentRequestDocument.class, criteria)); }
/** * @see org.kuali.kfs.module.endow.dataaccess.CashSweepModelDao#getCashSweepModelWithNextPayDateEqualToCurrentDate() */ public List<CashSweepModel> getCashSweepModelWithNextPayDateEqualToCurrentDate(Date currentDate) { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.CASH_SWEEP_MODEL_NEXT_DUE_DATE, currentDate); criteria.addNotNull(EndowPropertyConstants.CASH_SWEEP_MODEL_FREQUENCY_CDOE); criteria.addEqualTo(EndowPropertyConstants.CASH_SWEEP_MODEL_ACTIVE_INDICATOR, "Y"); return (List<CashSweepModel>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(CashSweepModel.class, criteria)); }
public Collection getOpenByCustomerNameByCustomerType(String customerName, String customerTypeCode) { // select i.* // from ar_doc_hdr_t h inner join ar_inv_doc_t i // on h.fdoc_nbr = i.fdoc_nbr // inner join ar_cust_t c // on h.cust_nbr = c.cust_nbr // where c.cust_nm like ? and c.cust_typ_cd = ? Criteria criteria = new Criteria(); criteria.addLike("accountsReceivableDocumentHeader.customer.customerName", customerName); criteria.addEqualTo("accountsReceivableDocumentHeader.customer.customerTypeCode", customerTypeCode); criteria.addEqualTo("openInvoiceIndicator", "true"); criteria.addEqualTo("documentHeader.financialDocumentStatusCode", KFSConstants.DocumentStatusCodes.APPROVED); QueryByCriteria qbc = QueryFactory.newQuery(CustomerInvoiceDocument.class, criteria); Collection customerinvoicedocuments = getPersistenceBrokerTemplate().getCollectionByQuery(qbc); List invoiceList = new ArrayList(customerinvoicedocuments); return invoiceList; }
/** * Given a date, finds all origin entry groups that were created on or after that date * @param day the date that defines recency - all qualifying origin entries groups will have been created on or after that day * @return a Collection of OriginEntryGroup records * @see org.kuali.kfs.gl.dataaccess.OriginEntryGroupDao#getRecentGroups(Date) */ public Collection<OriginEntryGroup> getRecentGroups(Date day) { LOG.debug("getOlderGroups() started"); Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(DATE, day); return getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(OriginEntryGroup.class, criteria)); }
public List<PositionAppointmentBo> getPositionAppointmentList(String positionAppointment, String groupKeyCode, LocalDate asOfDate) { Criteria root = new Criteria(); root.addLike("UPPER(`pstn_appointment`)", positionAppointment.toUpperCase()); root.addLike("UPPER(groupKeyCode)", groupKeyCode.toUpperCase()); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionAppointmentBo.class, asOfDate, PositionAppointmentBo.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionAppointmentBo.class, PositionAppointmentBo.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter);
public Map getDefaultItemMappingMap() { LOG.debug("getDefaultItemMappingMap() started"); Criteria criteria = new Criteria(); criteria.addIsNull("vendorHeaderGeneratedIdentifier"); criteria.addIsNull("vendorDetailAssignedIdentifier"); criteria.addEqualTo("active", true); return this.getItemMappingMap(criteria); }
/** * add the status code into the given criteria. The status code can be categorized into approved and all. * * @param criteria the given criteria * @param isApproved the flag that indictates if only approved status code can be added into the given searach criteria */ protected void addStatusCode(Criteria criteria, boolean isOnlyApproved) { // add criteria for the approved pending entries if (isOnlyApproved) { criteria.addIn("documentHeader.financialDocumentStatusCode", this.buildApprovalCodeList()); criteria.addNotEqualTo(KFSPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE, KFSConstants.PENDING_ENTRY_APPROVED_STATUS_CODE.PROCESSED); } else { Criteria subCriteria1 = new Criteria(); subCriteria1.addNotEqualTo(KFSPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE, KFSConstants.PENDING_ENTRY_APPROVED_STATUS_CODE.PROCESSED); Criteria subCriteria2 = new Criteria(); subCriteria2.addIsNull(KFSPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE); subCriteria1.addOrCriteria(subCriteria2); criteria.addAndCriteria(subCriteria1); } }
public TimesheetDocumentHeader getDocumentHeaderForDate(String principalId, DateTime asOfDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); crit.addLessOrEqualThan("beginDate", asOfDate.toDate()); crit.addGreaterThan("endDate", asOfDate.toDate()); QueryByCriteria query = new QueryByCriteria(TimesheetDocumentHeader.class, crit); return (TimesheetDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); } }
List<LeaveAdjustment> results = new ArrayList<LeaveAdjustment>(); Criteria root = new Criteria(); Criteria effectiveDateFilter = new Criteria(); if (fromEffdt != null) { effectiveDateFilter.addGreaterOrEqualThan("effectiveDate", fromEffdt.toDate()); effectiveDateFilter.addLessOrEqualThan("effectiveDate", toEffdt.toDate()); effectiveDateFilter.addLessOrEqualThan("effectiveDate", LocalDate.now().toDate()); root.addAndCriteria(effectiveDateFilter); root.addLike("UPPER(principalId)", principalId.toUpperCase()); // KPME-2695 in case principal id is not a number root.addLike("UPPER(accrualCategory)", accrualCategory.toUpperCase()); // KPME-2695 root.addLike("UPPER(earnCode)", earnCode.toUpperCase()); // KPME-2695
@Override public List<LeaveBlockBo> getLeaveBlocks(LocalDate leaveDate, String accrualCategory, String principalId) { Criteria root = new Criteria(); root.addLessOrEqualThan("leaveDate", leaveDate.toDate()); root.addEqualTo("accrualCategory", accrualCategory); root.addEqualTo("principalId", principalId); Query query = QueryFactory.newQuery(LeaveBlockBo.class, root); List<LeaveBlockBo> leaveBlocks = (List<LeaveBlockBo>) this.getPersistenceBrokerTemplate().getCollectionByQuery(query); return leaveBlocks; }
@SuppressWarnings("unchecked") @Override public List<TimeBlockBo> getTimeBlocksWithEarnCode(String earnCode, DateTime effDate) { Criteria root = new Criteria(); root.addEqualTo("earnCode", earnCode); root.addGreaterOrEqualThan("beginTimestamp", effDate.toDate()); return (List<TimeBlockBo>) this.getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(TimeBlockBo.class, root)); }