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); }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.NegativePaymentRequestApprovalLimitDao#findByChart(java.lang.String) */ public Collection<NegativePaymentRequestApprovalLimit> findByChart(String chartCode) { LOG.debug("Entering findByChart(String)"); Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode); criteria.addIsNull(KFSPropertyConstants.ORGANIZATION_CODE); criteria.addIsNull(KFSPropertyConstants.ACCOUNT_NUMBER); criteria.addAndCriteria(buildActiveCriteria()); Query query = new QueryByCriteria(NegativePaymentRequestApprovalLimit.class, criteria); LOG.debug("Leaving findByChart(String)"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
public Query customizeQuery(Object owner, PersistenceBroker broker, CollectionDescriptor collDescriptor, QueryByCriteria query) { String isClone = this.getAttribute(CLONE_FIELD, "false"); if (isClone.equals("false")) { query.getCriteria().addIsNull("cloneParent"); } else { query.getCriteria().addNotNull("cloneParent"); } return query; } }
/** * * @see org.kuali.kfs.module.bc.document.dataaccess.ImportRequestDao#findAllNonErrorCodeRecords() */ public List<BudgetConstructionRequestMove> findAllNonErrorCodeRecords(String principalId) { Criteria criteria = new Criteria(); criteria.addIsNull("requestUpdateErrorCode"); criteria.addEqualToColumn("principalId", principalId); List<BudgetConstructionRequestMove> records = new ArrayList<BudgetConstructionRequestMove>(getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(BudgetConstructionRequestMove.class, criteria))); return records; }
/** * @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.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.pdp.dataaccess.PaymentDetailDao#getAchPaymentsWithUnsentEmail() */ public Iterator getAchPaymentsWithUnsentEmail() { LOG.debug("getAchPaymentsWithUnsentEmail() started"); Criteria crit = new Criteria(); crit.addEqualTo(PdpPropertyConstants.PaymentDetail.PAYMENT_STATUS_CODE, PdpConstants.PaymentStatusCodes.EXTRACTED); crit.addEqualTo(PdpPropertyConstants.PaymentDetail.PAYMENT_DISBURSEMENT_TYPE_CODE, PdpConstants.DisbursementTypeCodes.ACH); crit.addIsNull(PdpPropertyConstants.PaymentDetail.PAYMENT_GROUP + "." + PdpPropertyConstants.ADVICE_EMAIL_SENT_DATE); return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(PaymentDetail.class,crit)); }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.ReceivingAddressDao#findActiveByChartOrg(java.lang.String,java.lang.String) */ public Collection<ReceivingAddress> findActiveByChartOrg(String chartCode, String orgCode) { LOG.debug("Entering findActiveByChartOrg(String,String)"); Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode); if ( orgCode == null ) criteria.addIsNull(KFSPropertyConstants.ORGANIZATION_CODE); else criteria.addEqualTo(KFSPropertyConstants.ORGANIZATION_CODE, orgCode); criteria.addEqualTo(PurapPropertyConstants.BO_ACTIVE, true); Query query = new QueryByCriteria(ReceivingAddress.class, criteria); LOG.debug("Leaving findActiveByChartOrg(String,String)"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.PaymentRequestDao#getImmediatePaymentRequestsToExtract(java.lang.String) */ public Collection<PaymentRequestDocument> getImmediatePaymentRequestsToExtract(String chartCode) { LOG.debug("getImmediatePaymentRequestsToExtract() started"); Criteria criteria = new Criteria(); if (chartCode != null) { criteria.addEqualTo("processingCampusCode", chartCode); } criteria.addIn("statusCode", Arrays.asList(PaymentRequestStatuses.STATUSES_ALLOWED_FOR_EXTRACTION)); criteria.addIsNull("extractedTimestamp"); criteria.addEqualTo("immediatePaymentIndicator", Boolean.TRUE); return getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(PaymentRequestDocument.class, criteria)); }
/** * @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)); }
/** * 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.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.NegativePaymentRequestApprovalLimitDao#findByChartAndAccount(java.lang.String, * java.lang.String) */ public Collection<NegativePaymentRequestApprovalLimit> findByChartAndAccount(String chartCode, String accountNumber) { LOG.debug("Entering findByChartAndAccount(String, String)"); Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode); criteria.addEqualTo(KFSPropertyConstants.ACCOUNT_NUMBER, accountNumber); criteria.addIsNull(KFSPropertyConstants.ORGANIZATION_CODE); criteria.addAndCriteria(buildActiveCriteria()); Query query = new QueryByCriteria(NegativePaymentRequestApprovalLimit.class, criteria); LOG.debug("Leaving findByChartAndAccount(String, String)"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
@SuppressWarnings("unchecked") public Collection<PortletDefinition> getAllPortletDefinitions() { Criteria c = new Criteria(); c.addIsNull("cloneParent"); Collection<PortletDefinition> list = getPersistenceBrokerTemplate().getCollectionByQuery( QueryFactory.newQuery(PortletDefinitionImpl.class, c)); postLoadColl(list); return list; }
/** * @see org.kuali.kfs.module.purap.document.dataaccess.NegativePaymentRequestApprovalLimitDao#findByChartAndOrganization(java.lang.String, * java.lang.String) */ public Collection<NegativePaymentRequestApprovalLimit> findByChartAndOrganization(String chartCode, String organizationCode) { LOG.debug("Entering findByChartAndOrganization(String, String)"); Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode); criteria.addEqualTo(KFSPropertyConstants.ORGANIZATION_CODE, organizationCode); criteria.addIsNull(KFSPropertyConstants.ACCOUNT_NUMBER); criteria.addAndCriteria(buildActiveCriteria()); Query query = new QueryByCriteria(NegativePaymentRequestApprovalLimit.class, criteria); LOG.debug("Leaving findByChartAndOrganization(String, String)"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
/** * @see org.kuali.kfs.module.cg.dataaccess.ProposalDao#getProposalsToClose(org.kuali.kfs.module.cg.businessobject.Close) */ public Collection<Proposal> getProposalsToClose(ProposalAwardCloseDocument close) { Criteria criteria = new Criteria(); criteria.addIsNull("proposalClosingDate"); criteria.addLessOrEqualThan("proposalSubmissionDate", close.getCloseOnOrBeforeDate()); return (Collection<Proposal>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(Proposal.class, criteria)); }
/** * @see org.kuali.kfs.module.cg.dataaccess.AwardDao#getAwardsToClose(org.kuali.kfs.module.cg.businessobject.Close) */ public Collection<Award> getAwardsToClose(ProposalAwardCloseDocument close) { Criteria criteria = new Criteria(); criteria.addIsNull("awardClosingDate"); criteria.addLessOrEqualThan("awardEntryDate", close.getCloseOnOrBeforeDate()); criteria.addNotEqualTo("awardStatusCode", "U"); return (Collection<Award>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(Award.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)); }
protected Collection<LaborCalculatedSalaryFoundationTracker> findDetailedCSFTrackerRawData(Map fieldValues) { Criteria tempCriteria1 = new Criteria(); tempCriteria1.addEqualTo(KFSPropertyConstants.CSF_DELETE_CODE, LaborConstants.DASHES_DELETE_CODE); Criteria tempCriteria2 = new Criteria(); tempCriteria2.addIsNull(KFSPropertyConstants.CSF_DELETE_CODE); /* KFSPropertyConstants.CSF_DELETE_CODE = "-" OR is null */ tempCriteria2.addOrCriteria(tempCriteria1); Criteria criteria = OJBUtility.buildCriteriaFromMap(fieldValues, new LaborCalculatedSalaryFoundationTracker()); criteria.addAndCriteria(tempCriteria2); Query query = QueryFactory.newQuery(LaborCalculatedSalaryFoundationTracker.class, criteria); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
/** * @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)); }