/** * * @see org.kuali.kfs.module.endow.dataaccess.KemidReportGroupDao#getAttributeValues(java.lang.String, java.util.List) */ public List<String> getAttributeValues(String attributeName, List<String> values) { Criteria criteria = new Criteria(); for (String value : values) { Criteria c = new Criteria(); if (value.contains(KFSConstants.WILDCARD_CHARACTER)) { c.addLike(attributeName, value.trim().replace(KFSConstants.WILDCARD_CHARACTER, KFSConstants.PERCENTAGE_SIGN)); } else { c.addEqualTo(attributeName, value.trim()); } criteria.addOrCriteria(c); } ReportQueryByCriteria query = new ReportQueryByCriteria(KemidReportGroup.class, criteria, true); query.setAttributes(new String[] {attributeName}); Iterator<Object> result = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query); //return (List<String>) getPersistenceBrokerTemplate().getCollectionByQuery(query); List<String> attributeValues = new ArrayList<String>(); while (result.hasNext()) { Object[] data = (Object[]) result.next(); attributeValues.add(data[0].toString()); } return attributeValues; } }
@SuppressWarnings("unchecked") public Collection<SSOSite> getSites(String filter) { Criteria finalCriteria = new Criteria(); if (StringUtils.isNotEmpty(filter)){ filter = filter.replaceAll("%", "\\%"); filter = "%"+filter+"%"; Criteria urlCriteria = new Criteria(); urlCriteria.addLike("url", filter); finalCriteria.addOrCriteria(urlCriteria); Criteria nameCriteria = new Criteria(); nameCriteria.addLike("name", filter); finalCriteria.addOrCriteria(nameCriteria); } Query query = QueryFactory.newQuery(SSOSiteImpl.class, finalCriteria); return getPersistenceBrokerTemplate().getCollectionByQuery(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.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; }
/** * Builds a sub criteria object joined with an 'AND' or 'OR' (depending on splitValue) using the split values of propertyValue. Then joins back the * sub criteria to the main criteria using an 'AND'. */ private void addLogicalOperatorCriteria(String propertyName, String propertyValue, Class propertyType, boolean caseInsensitive, Criteria criteria, String splitValue) { String[] splitPropVal = StringUtils.split(propertyValue, splitValue); Criteria subCriteria = new Criteria(); for (int i = 0; i < splitPropVal.length; i++) { Criteria predicate = new Criteria(); addCriteria(propertyName, splitPropVal[i], propertyType, caseInsensitive, false, predicate); if (splitValue.equals(SearchOperator.OR.op())) { subCriteria.addOrCriteria(predicate); } if (splitValue.equals(SearchOperator.AND.op())) { subCriteria.addAndCriteria(predicate); } } criteria.addAndCriteria(subCriteria); }
@Override public List<TimeBlockBo> getIntersectingTimeBlocks(String principalId, Interval interval) { Criteria rootCriteria = new Criteria(); rootCriteria.addEqualTo("principalId", principalId); Criteria orCriteria = new Criteria(); Criteria beginCriteria = new Criteria(); Criteria endCriteria = new Criteria(); Timestamp intervalStart = new Timestamp(interval.getStartMillis()); Timestamp intervalEnd = new Timestamp(interval.getEndMillis()); beginCriteria.addBetween("beginTimestamp", intervalStart, intervalEnd); endCriteria.addBetween("endTimestamp", intervalStart, intervalEnd); orCriteria.addOrCriteria(beginCriteria); orCriteria.addOrCriteria(endCriteria); rootCriteria.addAndCriteria(orCriteria); Query query = QueryFactory.newQuery(TimeBlockBo.class, rootCriteria); List<TimeBlockBo> timeBlocks = (List<TimeBlockBo>) this.getPersistenceBrokerTemplate().getCollectionByQuery(query); return timeBlocks == null || timeBlocks.isEmpty() ? new ArrayList<TimeBlockBo>() : timeBlocks; }
/** * @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)); }
criteriaForFundGroup.addIn(fundGroupFieldName, fundGroupCodes); criteriaForSubFundGroup.addOrCriteria(criteriaForFundGroup);
/** * 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; }
/** * This method builds the query to fetch the monthly budget general ledger lines to be loaded * * @param fiscalYear : the year to be loaded * @return query for fetching monthly budget rows */ protected QueryByCriteria queryForBudgetConstructionMonthly(Integer fiscalYear) { // we only select rows which have non-zero budget amounts // on this object, proxy=true, so we can do a regular query for a business object instead of a report query Criteria criteriaID = new Criteria(); criteriaID.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear); // we want to test for at least one non-zero monthly amount Criteria orCriteriaID = new Criteria(); Iterator<String[]> monthlyPeriods = BCConstants.BC_MONTHLY_AMOUNTS.iterator(); while (monthlyPeriods.hasNext()) { // the first array element is the amount field name (the second is the corresponding accounting period) String monthlyAmountName = monthlyPeriods.next()[0]; Criteria amountCriteria = new Criteria(); amountCriteria.addNotEqualTo(monthlyAmountName, new KualiInteger(0)); orCriteriaID.addOrCriteria(amountCriteria); } criteriaID.addAndCriteria(orCriteriaID); QueryByCriteria queryID = new QueryByCriteria(BudgetConstructionMonthly.class, criteriaID); return queryID; }
protected Iterator<Object[]> findConsolidatedCSFTrackerRawData(Map fieldValues, List<String> groupByList, List<String> attributeList) { 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); ReportQueryByCriteria query = QueryFactory.newReportQuery(LaborCalculatedSalaryFoundationTracker.class, criteria); String[] groupBy = (String[]) groupByList.toArray(new String[groupByList.size()]); query.addGroupBy(groupBy); String[] attributes = (String[]) attributeList.toArray(new String[attributeList.size()]); query.setAttributes(attributes); return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query); }
/** adds a composite predicate to a Criteria. */ private void addCompositePredicate(final CompositePredicate p, final Criteria parent, LookupCustomizer.Transform<Predicate, Predicate> transform) { for (Predicate ip : p.getPredicates()) { final Criteria inner = new Criteria(); addPredicate(ip, inner, transform); if (p instanceof AndPredicate) { parent.addAndCriteria(inner); } else if (p instanceof OrPredicate) { parent.addOrCriteria(inner); } else { throw new UnsupportedPredicateException(p); } } }
protected Criteria buildPayTypeCriteria(Map<Integer, Set<String>> payPeriods, List<String> balanceTypes, Map<String, Set<String>> earnCodePayGroupMap) { Criteria criteria = new Criteria(); Criteria criteriaForPayPeriods = new Criteria(); for (Integer fiscalYear : payPeriods.keySet()) { Criteria criteriaForFiscalYear = new Criteria(); criteriaForFiscalYear.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear); criteriaForFiscalYear.addIn(KFSPropertyConstants.UNIVERSITY_FISCAL_PERIOD_CODE, payPeriods.get(fiscalYear)); criteriaForPayPeriods.addOrCriteria(criteriaForFiscalYear); } Criteria criteriaForBalanceTypes = new Criteria(); criteriaForBalanceTypes.addIn(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE, balanceTypes); Criteria criteriaForEarnCodePayGroup = new Criteria(); for (String payGroup : earnCodePayGroupMap.keySet()) { Criteria criteriaForEarnPay = new Criteria(); criteriaForEarnPay.addEqualTo(KFSPropertyConstants.PAY_GROUP, payGroup); criteriaForEarnPay.addIn(KFSPropertyConstants.EARN_CODE, earnCodePayGroupMap.get(payGroup)); criteriaForEarnCodePayGroup.addOrCriteria(criteriaForEarnPay); } criteria.addAndCriteria(criteriaForPayPeriods); criteria.addAndCriteria(criteriaForBalanceTypes); criteria.addAndCriteria(criteriaForEarnCodePayGroup); return criteria; }
/** * @see org.kuali.kfs.module.ec.dataaccess.EffortCertificationReportDefinitionDao#getOverlappingReportDefinitions(org.kuali.kfs.module.ec.businessobject.EffortCertificationReportDefinition) */ public List<EffortCertificationReportDefinition> getAllOtherActiveByType(EffortCertificationReportDefinition effortCertificationReportDefinition) { Criteria criteria = new Criteria(); criteria.addEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_TYPE_CODE, effortCertificationReportDefinition.getEffortCertificationReportTypeCode()); criteria.addEqualTo(KFSPropertyConstants.ACTIVE, true); Criteria subCriteria = new Criteria(); Criteria subCriteriaReportNumber = new Criteria(); subCriteria.addNotEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, effortCertificationReportDefinition.getUniversityFiscalYear()); subCriteriaReportNumber.addNotEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_NUMBER, effortCertificationReportDefinition.getEffortCertificationReportNumber()); subCriteria.addOrCriteria(subCriteriaReportNumber); criteria.addAndCriteria(subCriteria); Collection col = getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(EffortCertificationReportDefinition.class, criteria)); Iterator i = col.iterator(); List<EffortCertificationReportDefinition> overlappingReportDefinitions = new ArrayList(); while (i.hasNext()) { EffortCertificationReportDefinition temp = (EffortCertificationReportDefinition) i.next(); overlappingReportDefinitions.add(temp); } return overlappingReportDefinitions; }
@SuppressWarnings("unchecked") public Collection<SSOSite> getSites(Collection<SSOUser> users) { if (users.size() > 0){ Criteria queryCriteria = new Criteria(); for (SSOUser u : users){ Criteria domainCriteria = new Criteria(); domainCriteria.addEqualTo("securityDomainId",u.getDomainId()); queryCriteria.addOrCriteria(domainCriteria); } QueryByCriteria query = QueryFactory.newQuery(SSOSiteImpl.class, queryCriteria); query.addOrderByAscending("name"); return getPersistenceBrokerTemplate().getCollectionByQuery(query); } else { return Collections.EMPTY_LIST; } }
/** * @see org.kuali.kfs.module.ec.dataaccess.EffortCertificationReportDefinitionDao#getAllByYearAndPositionCode(java.lang.Integer, java.lang.String) */ public List<EffortCertificationReport> getAllByYearAndPositionCode(Integer fiscalYear, String positionObjectCode) { Criteria criteria = new Criteria(); criteria.addEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_BEGIN_FISCAL_YEAR, fiscalYear); Criteria criteria2 = new Criteria(); criteria2.addEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_END_FISCAL_YEAR, fiscalYear); criteria.addOrCriteria(criteria2); criteria.addEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_POSITIONS + "." + EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_POSITION_OBJECT_GROUP_CODE, positionObjectCode); return (List<EffortCertificationReport>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(EffortCertificationReportDefinition.class, criteria)); } }
/** * * @see org.kuali.kfs.module.endow.dataaccess.KemidBenefittingOrganizationDao#getBenefittingOrganizations(java.util.List) */ public List<KemidBenefittingOrganization> getBenefittingOrganizations(List<String> kemids) { Criteria criteria1 = new Criteria(); Criteria criteria2 = new Criteria(); criteria1.addEqualTo(EndowPropertyConstants.ENDOWCODEBASE_ACTIVE_INDICATOR, true); for (String kemid : kemids) { Criteria c = new Criteria(); c.addEqualTo(EndowPropertyConstants.KEMID, kemid.trim()); criteria2.addOrCriteria(c); } criteria1.addAndCriteria(criteria2); QueryByCriteria queryByCriteria = QueryFactory.newQuery(KemidBenefittingOrganization.class, criteria1); queryByCriteria.addOrderByAscending(EndowPropertyConstants.KEMID); return (List<KemidBenefittingOrganization>) getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria); }
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); }
/** * 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); } }
/** * @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)); }