/** * @see org.kuali.kfs.vnd.dataaccess.CommodityCodeDao#wildCardCommodityCodeExists(java.lang.String) */ public boolean wildCardCommodityCodeExists(String wildCardCommodityCode) { String commodityCodeString = StringUtils.replace(wildCardCommodityCode, KFSConstants.WILDCARD_CHARACTER, KFSConstants.PERCENTAGE_SIGN); Criteria criteria = new Criteria(); criteria.addLike(VendorPropertyConstants.PURCHASING_COMMODITY_CODE, commodityCodeString); int count = getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(CommodityCode.class, criteria)); boolean exists = ((count > 0) ? true : false); return exists; } }
/** * * @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; } }
/** * * @see org.kuali.kfs.module.endow.dataaccess.KemidReportGroupDao#getKemidsByAttribute(java.lang.String, java.util.List) */ public List<String> getKemidsByAttribute(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[] {EndowPropertyConstants.KEMID}); Iterator<Object> result = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query); //return (List<String>) getPersistenceBrokerTemplate().getCollectionByQuery(query); List<String> kemids = new ArrayList<String>(); while (result.hasNext()) { Object[] data = (Object[]) result.next(); kemids.add(data[0].toString()); } return kemids; }
@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); }
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 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());
/** * @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); }
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 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());
@SuppressWarnings("unchecked") public List<String> getPrincipalNames(String nameFilter, JetspeedPrincipalType type, Long securityDomain) { Criteria criteria = new Criteria(); if (nameFilter != null && nameFilter.length() > 0) { criteria.addLike("name", nameFilter+"%"); } criteria.addEqualTo("type", type.getName()); criteria.addEqualTo("domainId", securityDomain); // check cache String cacheKey = "getPrincipalNames:"+criteria; List<String> principalNames = (List<String>)jspmCache.getPrincipalQuery(cacheKey); if (principalNames != null) { return new ArrayList<String>(principalNames); } // perform query ReportQueryByCriteria query = QueryFactory.newReportQuery(PersistentJetspeedPrincipal.class,criteria); query.setAttributes(new String[]{"name"}); principalNames = new ArrayList<String>(); for (Iterator<Object[]> iter = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query); iter.hasNext(); ) { principalNames.add((String) iter.next()[0]); } // put result in cache jspmCache.putPrincipalQuery(cacheKey, JSPMCache.ANY_ID, null, securityDomain, new ArrayList<String>(principalNames)); // return result return principalNames; }
@Override @SuppressWarnings("unchecked") public List<GracePeriodRule> getGracePeriodRules(String hourFactor, String active, String showHistory) { List<GracePeriodRule> results = new ArrayList<GracePeriodRule>(); Criteria root = new Criteria(); if (StringUtils.isNotBlank(hourFactor)) { root.addLike("hourFactor", hourFactor); } if (StringUtils.isNotBlank(active)) { Criteria activeFilter = new Criteria(); if (StringUtils.equals(active, "Y")) { activeFilter.addEqualTo("active", true); } else if (StringUtils.equals(active, "N")) { activeFilter.addEqualTo("active", false); } root.addAndCriteria(activeFilter); } if (StringUtils.equals(showHistory, "N")) { root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQueryWithoutFilter(GracePeriodRule.class, Collections.EMPTY_LIST, false)); root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(GracePeriodRule.class, Collections.EMPTY_LIST, false)); } Query query = QueryFactory.newQuery(GracePeriodRule.class, root); results.addAll(getPersistenceBrokerTemplate().getCollectionByQuery(query)); return results; }
public Collection getOpenByCustomerName(String customerName) { // 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 ? Criteria criteria = new Criteria(); criteria.addLike("accountsReceivableDocumentHeader.customer.customerName", customerName); 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; }
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; }
@SuppressWarnings("unchecked") public List<PersistentJetspeedPermission> getPermissions(String type, String nameFilter) { Criteria criteria = new Criteria(); criteria.addEqualTo("type", type); if (nameFilter != null && nameFilter.length() > 0) { criteria.addLike("name", nameFilter+"%"); } // check cache String cacheKey = "getPermissions:"+criteria; List<PersistentJetspeedPermission> permissions = (List<PersistentJetspeedPermission>) jspmCache.getPermissionQuery(cacheKey); if (permissions != null) { return new ArrayList<PersistentJetspeedPermission>(permissions); } // perform query QueryByCriteria query = QueryFactory.newQuery(PersistentJetspeedPermissionImpl.class, criteria); query.addOrderByAscending("name"); permissions = (List<PersistentJetspeedPermission>)getPersistenceBrokerTemplate().execute(new ManagedListByQueryCallback(query)); // put result in cache jspmCache.putPermissionQuery(cacheKey, null, null, JSPMCache.ANY_ID, null, new ArrayList<PersistentJetspeedPermission>(permissions)); // return result return permissions; }
/** * * @see org.kuali.kfs.coa.dataaccess.AccountDelegateGlobalDao#getLockingDocumentNumber(java.lang.String, java.lang.String) */ public String getLockingDocumentNumber(String lockingRepresentation, String documentNumber) { String lockingDocNumber = ""; lockingRepresentation = convertForLikeCriteria(lockingRepresentation); // build the query criteria Criteria criteria = new Criteria(); criteria.addLike("lockingRepresentation", lockingRepresentation); // if a docHeaderId is specified, then it will be excluded from the // locking representation test. if (StringUtils.isNotBlank(documentNumber)) { criteria.addNotEqualTo(KNSPropertyConstants.DOCUMENT_NUMBER, documentNumber); } // attempt to retrieve a document based off this criteria MaintenanceLock maintenanceLock = (MaintenanceLock) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(MaintenanceLock.class, criteria)); // if a document was found, then there's already one out there pending, and // we consider it 'locked' and we return the docnumber. if (maintenanceLock != null) { lockingDocNumber = maintenanceLock.getDocumentNumber(); } return lockingDocNumber; }
@SuppressWarnings("unchecked") public List<JetspeedPrincipal> getPrincipals(String nameFilter, JetspeedPrincipalType type, Long securityDomain) { Criteria criteria = new Criteria(); if (nameFilter != null && nameFilter.length() > 0) { criteria.addLike("name", nameFilter+"%"); } criteria.addEqualTo("type", type.getName()); criteria.addEqualTo("domainId", securityDomain); // check cache String cacheKey = "getPrincipals:"+criteria; List<JetspeedPrincipal> principals = (List<JetspeedPrincipal>)jspmCache.getPrincipalQuery(cacheKey); if (principals != null) { return new ArrayList<JetspeedPrincipal>(principals); } // perform query Query query = QueryFactory.newQuery(PersistentJetspeedPrincipal.class,criteria); principals = (List<JetspeedPrincipal>) getPersistenceBrokerTemplate().execute(new ManagedListByQueryCallback(query)); // put result in cache jspmCache.putPrincipalQuery(cacheKey, JSPMCache.ANY_ID, null, securityDomain, new ArrayList<JetspeedPrincipal>(principals)); // return result return principals; }
/** * @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)); }
/** * * @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)); }