/** * @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); }
@Override public List<LeavePayout> getAllLeavePayoutsMarkedPayoutForPrincipalId( String principalId) { Criteria crit = new Criteria(); List<LeavePayout> leavePayouts = new ArrayList<LeavePayout>(); crit.addEqualTo("principalId",principalId); Criteria payoutCrit = new Criteria(); payoutCrit.addNotNull("earnCode"); crit.addAndCriteria(payoutCrit); Query query = QueryFactory.newQuery(LeavePayout.class,crit); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if(c != null) leavePayouts.addAll(c); return leavePayouts; }
/** * This is the default impl that comes with Kuali - uses OJB. * * @see org.kuali.rice.krad.dao.BusinessObjectDao#countMatching(java.lang.Class, java.util.Map, java.util.Map) */ public int countMatching(Class clazz, Map<String, ?> positiveFieldValues, Map<String, ?> negativeFieldValues) { Criteria criteria = buildCriteria(positiveFieldValues); Criteria negativeCriteria = buildNegativeCriteria(negativeFieldValues); criteria.addAndCriteria(negativeCriteria); return getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(clazz, 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; }
/** * @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); }
/** * @see org.kuali.rice.krad.dao.BusinessObjectDao#findMatchingActive(java.lang.Class, java.util.Map) */ public <T extends BusinessObject> Collection<T> findMatchingActive(Class<T> clazz, Map<String, ?> fieldValues) { Criteria criteria = buildCriteria(fieldValues); criteria.addAndCriteria(buildActiveCriteria()); return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, criteria)); }
/** * @see org.kuali.kfs.coa.dataaccess.AccountDao#getActiveAccountsForFiscalOfficer(java.lang.String) */ public Iterator<Account> getActiveAccountsForFiscalOfficer(String principalId) { Criteria criteria = new Criteria(); criteria.addEqualTo("accountFiscalOfficerSystemIdentifier", principalId); criteria.addEqualTo("active", true); criteria.addAndCriteria(getAccountNotExpiredCriteria()); return (Iterator<Account>)getPersistenceBrokerTemplate().getIteratorByQuery(QueryFactory.newQuery(Account.class, criteria)); }
/** * @see org.kuali.kfs.coa.dataaccess.AccountDao#getExpiredAccountsForAccountSupervisor(java.lang.String) */ public Iterator<Account> getExpiredAccountsForAccountSupervisor(String principalId) { Criteria criteria = new Criteria(); criteria.addEqualTo("accountsSupervisorySystemsIdentifier", principalId); criteria.addEqualTo("active", true); criteria.addAndCriteria(getAccountExpiredCriteria()); return (Iterator<Account>)getPersistenceBrokerTemplate().getIteratorByQuery(QueryFactory.newQuery(Account.class, criteria)); }
/** * @see org.kuali.kfs.coa.dataaccess.AccountDao#getActiveAccountsForAccountSupervisor(java.lang.String) */ public Iterator<Account> getActiveAccountsForAccountSupervisor(String principalId) { Criteria criteria = new Criteria(); criteria.addEqualTo("accountsSupervisorySystemsIdentifier", principalId); criteria.addEqualTo("active", true); criteria.addAndCriteria(getAccountNotExpiredCriteria()); return (Iterator<Account>)getPersistenceBrokerTemplate().getIteratorByQuery(QueryFactory.newQuery(Account.class, criteria)); }
/** * @see org.kuali.kfs.coa.dataaccess.AccountDao#getExpiredAccountsForFiscalOfficer(java.lang.String) */ public Iterator<Account> getExpiredAccountsForFiscalOfficer(String principalId) { Criteria criteria = new Criteria(); criteria.addEqualTo("accountFiscalOfficerSystemIdentifier", principalId); criteria.addEqualTo("active", true); criteria.addAndCriteria(getAccountExpiredCriteria()); return (Iterator<Account>)getPersistenceBrokerTemplate().getIteratorByQuery(QueryFactory.newQuery(Account.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); }
@Override public SystemLunchRule getSystemLunchRule(LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(SystemLunchRule.class, asOfDate, Collections.EMPTY_LIST, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(SystemLunchRule.class, Collections.EMPTY_LIST, false)); Criteria activeFilter = new Criteria(); // Inner Join For Activity activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(SystemLunchRule.class, root); return (SystemLunchRule)this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
@Override public PositionTypeBo getPositionType(String positionType, LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("positionType", positionType); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionTypeBo.class, asOfDate, PositionTypeBo.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionTypeBo.class, PositionTypeBo.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(PositionTypeBo.class, root); return (PositionTypeBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
@Override public PositionReportGroupBo getPositionReportGroup(String positionReportGroup, LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("positionReportGroup", positionReportGroup); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionReportGroupBo.class, asOfDate, PositionReportGroupBo.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionReportGroupBo.class, PositionReportGroupBo.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(PositionReportGroupBo.class, root); return (PositionReportGroupBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
@Override public PositionReportSubCategoryBo getActivePositionReportSubCat(String pstnRptSubCat, LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("positionReportSubCat", pstnRptSubCat); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionReportSubCategoryBo.class, asOfDate, PositionReportSubCategoryBo.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionReportSubCategoryBo.class, PositionReportSubCategoryBo.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(PositionReportSubCategoryBo.class, root); return (PositionReportSubCategoryBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
public GracePeriodRule getGracePeriodRule(LocalDate asOfDate){ GracePeriodRule gracePeriodRule = null; Criteria root = new Criteria(); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(GracePeriodRule.class, asOfDate, Collections.EMPTY_LIST, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(GracePeriodRule.class, Collections.EMPTY_LIST, false)); Criteria activeFilter = new Criteria(); // Inner Join For Activity activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(GracePeriodRule.class, root); Object obj = this.getPersistenceBrokerTemplate().getObjectByQuery(query); if (obj != null) { gracePeriodRule = (GracePeriodRule) obj; } return gracePeriodRule; }
@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); }
@SuppressWarnings("unchecked") @Override public ShiftDifferentialRuleType getActiveShiftDifferentialRuleType(String name, LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("name", name); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(ShiftDifferentialRuleType.class, asOfDate, ShiftDifferentialRuleType.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(ShiftDifferentialRuleType.class, ShiftDifferentialRuleType.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); // Inner Join For Activity activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(ShiftDifferentialRuleType.class, root); ShiftDifferentialRuleType obj = (ShiftDifferentialRuleType) this.getPersistenceBrokerTemplate().getObjectByQuery(query); return obj; }
@Override public PositionReportTypeBo getPositionReportType(String positionReportType, LocalDate asOfDate) { Criteria root = new Criteria(); root.addEqualTo("positionReportType", positionReportType); root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionReportTypeBo.class, asOfDate, PositionReportTypeBo.BUSINESS_KEYS, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionReportTypeBo.class, PositionReportTypeBo.BUSINESS_KEYS, false)); Criteria activeFilter = new Criteria(); // Inner Join For Activity activeFilter.addEqualTo("active", true); root.addAndCriteria(activeFilter); Query query = QueryFactory.newQuery(PositionReportTypeBo.class, root); return (PositionReportTypeBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query); } }