/** * @see org.kuali.kfs.gl.dataaccess.LedgerBalanceHistoryBalancingDao#findDistinctFiscalYears() */ public List<Integer> findDistinctFiscalYears() { Criteria crit = new Criteria(); ReportQueryByCriteria q = QueryFactory.newReportQuery(BalanceHistory.class, crit); q.setAttributes(new String[] { KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR }); q.setDistinct(true); Iterator<Object[]> years = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(q); List<Integer> yearList = new ArrayList<Integer>(); while (years != null && years.hasNext()) { Object[] year = years.next(); yearList.add(new Integer(year[0].toString())); } return yearList; } }
/** * @see org.kuali.kfs.gl.dataaccess.LedgerBalanceHistoryBalancingDao#findDistinctFiscalYears() */ public List<Integer> findDistinctFiscalYears() { Criteria crit = new Criteria(); ReportQueryByCriteria q = QueryFactory.newReportQuery(LaborBalanceHistory.class, crit); q.setAttributes(new String[] { KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR }); q.setDistinct(true); Iterator<Object[]> years = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(q); List<Integer> yearList = new ArrayList<Integer>(); while (years != null && years.hasNext()) { Object[] year = years.next(); yearList.add(new Integer(year[0].toString())); } return yearList; } }
/** * @see org.kuali.kfs.module.ld.dataaccess.LaborLedgerEntryDao#findEmployeesWithPayType(java.util.Map, java.util.List, java.util.List) */ public List<String> findEmployeesWithPayType(Map<Integer, Set<String>> payPeriods, List<String> balanceTypes, Map<String, Set<String>> earnCodePayGroupMap) { Criteria criteria = this.buildPayTypeCriteria(payPeriods, balanceTypes, earnCodePayGroupMap); ReportQueryByCriteria query = QueryFactory.newReportQuery(this.getEntryClass(), criteria); query.setAttributes(new String[] { KFSPropertyConstants.EMPLID }); query.setDistinct(true); Iterator<Object[]> employees = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query); List<String> employeeList = new ArrayList<String>(); while (employees != null && employees.hasNext()) { Object[] emplid = employees.next(); employeeList.add(emplid == null ? "" : emplid[0].toString()); } return employeeList; }
/** * @see org.kuali.kfs.coa.dataaccess.IndirectCostRecoveryExclusionAccountDao#existByAccount(java.lang.String, java.lang.String) */ public boolean existByAccount(String chartOfAccountsCode, String accountNumber) { LOG.debug("existByAccount() started"); Criteria crit = new Criteria(); crit.addEqualTo("chartOfAccountsCode", chartOfAccountsCode); crit.addEqualTo("accountNumber", accountNumber); ReportQueryByCriteria q = QueryFactory.newReportQuery(IndirectCostRecoveryExclusionAccount.class, crit); q.setAttributes(new String[] { "chartOfAccountsCode" }); q.setDistinct(true); Iterator iter = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(q); return iter.hasNext(); }
query.setDistinct(true);
/** * Return an iterator of keys of all documents referenced by origin entries in a given group * * @param oeg Group the origin entry group to find entries in, by origin entry * @return Iterator of java.lang.Object[] with report data about all of the distinct document numbers/type code/origination code combinations of origin entries in the group * @see org.kuali.kfs.gl.dataaccess.OriginEntryDao#getDocumentsByGroup(org.kuali.kfs.gl.businessobject.OriginEntryGroup) */ public Iterator getDocumentsByGroup(OriginEntryGroup oeg) { LOG.debug("getDocumentsByGroup() started"); Criteria criteria = new Criteria(); criteria.addEqualTo(ENTRY_GROUP_ID, oeg.getId()); ReportQueryByCriteria q = QueryFactory.newReportQuery(entryClass, criteria); q.setAttributes(new String[] { KFSPropertyConstants.DOCUMENT_NUMBER, "financialDocumentTypeCode", "financialSystemOriginationCode" }); q.setDistinct(true); return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(q); }
public Set<String> getUserNames(org.apache.jetspeed.om.portlet.PortletDefinition portletdefinition, String windowId) { Set<String> userNames = new TreeSet<String>(); String appName = portletdefinition.getApplication().getName(); String portletName = portletdefinition.getPortletName(); Criteria c = new Criteria(); c.addEqualTo(DTYPE, DISCRIMINATOR_USER); c.addEqualTo(APPLICATION_NAME, appName); c.addEqualTo(PORTLET_NAME, portletName); c.addEqualTo(ENTITY_ID, windowId); c.addNotEqualTo(USER_NAME, EMPTY_VALUE); ReportQueryByCriteria query = QueryFactory.newReportQuery(DatabasePreference.class, c); query.setAttributes(new String[] {USER_NAME, "id" }); query.setDistinct(true); Iterator<Object[]> userObjects = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query); while (userObjects.hasNext()) { userNames.add((String) userObjects.next()[0]); } return userNames; }