@Override public List<BalanceTransfer> getAllBalanceTransferByEffectiveDate( LocalDate effectiveDate) { List<BalanceTransfer> balanceTransfers = new ArrayList<BalanceTransfer>(); Criteria effDate = new Criteria(); effDate.addGreaterOrEqualThan("effectiveDate", effectiveDate.toDate()); Query query = QueryFactory.newQuery(BalanceTransfer.class,effDate); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if(c != null) balanceTransfers.addAll(c); return balanceTransfers; }
@Override public List<LeavePayout> getAllLeavePayoutsByEffectiveDate( LocalDate effectiveDate) { List<LeavePayout> leavePayouts = new ArrayList<LeavePayout>(); Criteria effDate = new Criteria(); effDate.addGreaterOrEqualThan("effectiveDate", effectiveDate.toDate()); Query query = QueryFactory.newQuery(LeavePayout.class,effDate); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if(c != null) leavePayouts.addAll(c); return leavePayouts; }
/** * 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)); }
@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)); }
/** * @see org.kuali.kfs.gl.dataaccess.EncumbranceDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(Encumbrance.class, criteria); return getPersistenceBrokerTemplate().getCount(query); } }
/** * @see org.kuali.kfs.gl.dataaccess.AccountBalanceDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(AccountBalance.class, criteria); return getPersistenceBrokerTemplate().getCount(query); }
/** * @see org.kuali.kfs.gl.dataaccess.LedgerEntryBalancingDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(Entry.class, criteria); return getPersistenceBrokerTemplate().getCount(query); } }
/** * @see org.kuali.kfs.gl.dataaccess.BalancingDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(Balance.class, criteria); return getPersistenceBrokerTemplate().getCount(query); }
/** * @see org.kuali.kfs.gl.dataaccess.BalancingDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(LedgerBalance.class, criteria); return getPersistenceBrokerTemplate().getCount(query); } }
/** * @see org.kuali.kfs.gl.dataaccess.LedgerEntryHistoryBalancingDao#findSumRowCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findSumRowCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(EntryHistory.class, criteria); reportQuery.setAttributes(new String[] { "sum(" + KFSPropertyConstants.ROW_COUNT + ")"}); Iterator<Object[]> iterator = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(reportQuery); Object[] returnResult = TransactionalServiceUtils.retrieveFirstAndExhaustIterator(iterator); return ObjectUtils.isNull(returnResult[0]) ? 0 : ((BigDecimal) returnResult[0]).intValue(); } }
@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; }
@SuppressWarnings("rawtypes") @Override public List<LeaveBlockBo> getLeaveBlocks(String principalId, LocalDate beginDate, LocalDate endDate) { List<LeaveBlockBo> leaveBlocks = new ArrayList<LeaveBlockBo>(); Criteria root = new Criteria(); root.addEqualTo("principalId", principalId); root.addGreaterOrEqualThan("leaveDate", beginDate.toDate()); root.addLessOrEqualThan("leaveDate", endDate.toDate()); // root.addEqualTo("active", true); Query query = QueryFactory.newQuery(LeaveBlockBo.class, root); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if (c != null) { leaveBlocks.addAll(c); } return leaveBlocks; }
@Override public List<BalanceTransfer> getAllBalanceTransfersForAccrualCategoryRuleByDate( String accrualRuleId, LocalDate asOfDate) { Criteria crit = new Criteria(); List<BalanceTransfer> balanceTransfers = new ArrayList<BalanceTransfer>(); crit.addGreaterOrEqualThan("effectiveDate",asOfDate.toDate()); Criteria accrualCategory = new Criteria(); accrualCategory.addEqualTo("accrualCategoryRule", accrualRuleId); crit.addAndCriteria(accrualCategory); 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.gl.dataaccess.LedgerEntryBalancingDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(getEntryClass(), criteria); return getPersistenceBrokerTemplate().getCount(query); }
@Override public List<LeaveBlockBo> getLeaveBlocksWithAccrualCategory(String principalId, LocalDate beginDate, LocalDate endDate, String accrualCategory) { List<LeaveBlockBo> leaveBlocks = new ArrayList<LeaveBlockBo>(); Criteria root = new Criteria(); root.addEqualTo("principalId", principalId); root.addGreaterOrEqualThan("leaveDate", beginDate.toDate()); root.addLessOrEqualThan("leaveDate", endDate.toDate()); root.addEqualTo("accrualCategory", accrualCategory); // root.addEqualTo("active", true); Query query = QueryFactory.newQuery(LeaveBlockBo.class, root); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if (c != null) { leaveBlocks.addAll(c); } return leaveBlocks; }
@Override public List<LeaveBlockBo> getLeaveBlocks(String principalId, String accrualCategory, LocalDate beginDate, LocalDate endDate) { List<LeaveBlockBo> leaveBlocks = new ArrayList<LeaveBlockBo>(); Criteria root = new Criteria(); root.addEqualTo("principalId", principalId); root.addGreaterOrEqualThan("leaveDate", beginDate.toDate()); root.addLessOrEqualThan("leaveDate", endDate.toDate()); root.addEqualTo("accrualCategory", accrualCategory); // root.addEqualTo("active", true); Query query = QueryFactory.newQuery(LeaveBlockBo.class, root); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if (c != null) { leaveBlocks.addAll(c); } return leaveBlocks; }
/** * @see org.kuali.kfs.gl.dataaccess.LedgerEntryBalancingDao#findSumRowCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findSumRowCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(LaborEntryHistory.class, criteria); reportQuery.setAttributes(new String[] { ConsolidationUtil.sum(KFSPropertyConstants.ROW_COUNT)}); Iterator<Object[]> iterator = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(reportQuery); Object[] returnResult = TransactionalServiceUtils.retrieveFirstAndExhaustIterator(iterator); return ObjectUtils.isNull(returnResult[0]) ? 0 : ((BigDecimal) returnResult[0]).intValue(); } }
@Override public List<BalanceTransfer> getBalanceTransfers(String viewPrincipal, LocalDate beginPeriodDate, LocalDate endPeriodDate) { // TODO Auto-generated method stub List<BalanceTransfer> balanceTransfers = new ArrayList<BalanceTransfer>(); Criteria crit = new Criteria(); crit.addEqualTo("principalId",viewPrincipal); Criteria effDate = new Criteria(); effDate.addGreaterOrEqualThan("effectiveDate", beginPeriodDate.toDate()); effDate.addLessOrEqualThan("effectiveDate", endPeriodDate.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; }
@Override public List<LeavePayout> getLeavePayouts(String viewPrincipal, LocalDate beginPeriodDate, LocalDate endPeriodDate) { // TODO Auto-generated method stub List<LeavePayout> leavePayouts = new ArrayList<LeavePayout>(); Criteria crit = new Criteria(); crit.addEqualTo("principalId",viewPrincipal); Criteria effDate = new Criteria(); effDate.addGreaterOrEqualThan("effectiveDate", beginPeriodDate.toDate()); effDate.addLessOrEqualThan("effectiveDate", endPeriodDate.toDate()); crit.addAndCriteria(effDate); Query query = QueryFactory.newQuery(LeavePayout.class,crit); Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query); if(c != null) leavePayouts.addAll(c); return leavePayouts; }
/** * * @see org.kuali.kfs.module.endow.dataaccess.TransactionArchiveDao#getTransactionArchiveByKemidsAndPostedDate(java.lang.String, java.lang.String, java.util.Date, java.util.Date, java.lang.String, java.lang.String) */ public List<TransactionArchive> getTransactionArchiveByKemidsAndPostedDate(String kemid, String endowmentOption, java.util.Date beginningDate, java.util.Date endingDate, String closedIndicator, String transactionSubType) { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.TRANSACTION_ARCHIVE_KEM_ID, kemid); criteria.addEqualTo(EndowPropertyConstants.TRANSACTION_ARCHIVE_SUB_TYPE_CODE, transactionSubType); criteria.addGreaterOrEqualThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, beginningDate); criteria.addLessOrEqualThan(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE, endingDate); QueryByCriteria qbc = QueryFactory.newQuery(TransactionArchive.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.TRANSACTION_ARCHIVE_POSTED_DATE); return (List<TransactionArchive>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }