@SuppressWarnings("unchecked")
protected List<Object[]> getSavedSearchDetails(Long savedSearchQueryID, String type) {
SavedSearchRetriever.AlertType alertType = SavedSearchRetriever.AlertType.valueOf(type);
DetachedCriteria criteria =
DetachedCriteria.forClass(UserProfile.class)
.setProjection(
Projections.distinct(
Projections.projectionList()
.add(Projections.property("ss.ID"))
.add(Projections.property("email"))
.add(Projections.property("ss.searchName"))))
.createAlias("savedSearches", "ss")
.createAlias("ss.searchQuery", "q")
.add(Restrictions.eq("q.ID", savedSearchQueryID));
if (alertType == SavedSearchRetriever.AlertType.WEEKLY) {
criteria.add(Restrictions.eq("ss.weekly", true));
}
if (alertType == SavedSearchRetriever.AlertType.MONTHLY) {
criteria.add(Restrictions.eq("ss.monthly", true));
}
return (List<Object[]>) hibernateTemplate.findByCriteria(criteria);
}
public void prepareDateRange() throws Exception {
DetachedCriteria criteria = DetachedCriteria.forClass(ConfirmationRecord.class);
ProjectionList pjl = Projections.projectionList();
pjl.add(Projections.property("cycleFrom"));
pjl.add(Projections.property("cycleTo"));
criteria.setProjection(Projections.distinct(pjl));
List<?> list = confirmationRecordService.findByCriteria(criteria);
if (list.size() > 0) {
Object[] objs = list.toArray();
selectionCycleFrom = new ArrayList<>();
selectionCycleFrom.add(new SelectItem(null, "Please Select"));
cycleTos = new ArrayList<>();
for (Object obj : objs) {
if (obj instanceof Object[]) {
Object[] innerObjs = (Object[]) obj;
if (innerObjs.length == 2) {
Date dFrom = DateUtil.convStringToDate(MS_SQL_DATE_PATTERN, innerObjs[0].toString());
Date dTo = DateUtil.convStringToDate(MS_SQL_DATE_PATTERN, innerObjs[1].toString());
selectionCycleFrom.add(
new SelectItem(
DateUtil.convDateToString(SIMPLE_DATE_PATTERN, dFrom),
DateUtil.convDateToString(DISPLAY_DATE_PATTERN, dFrom)));
cycleTos.add(DateUtil.convDateToString(SIMPLE_DATE_PATTERN, dTo));
} else {
System.err.println("ERR: obj[] length not eq to 2");
}
}
}
}
}
@SuppressWarnings("unchecked")
public List<String> listStringByFields(String field) {
Criteria criteria = getCurrentSession().createCriteria(Titem.class);
criteria.setProjection(Projections.distinct(Projections.property(field)));
criteria.addOrder(Order.asc(field));
List<String> list = criteria.list();
return list;
}
@Override
public int getFormsCount(Person owner) {
DetachedCriteria criteria = DetachedCriteria.forClass(type);
criteria.setProjection(Projections.distinct(Projections.countDistinct("formName")));
if (owner != null) criteria.add(Restrictions.eq("person.personId", owner.getPersonId()));
return DataAccessUtils.intResult(getHibernateTemplate().findByCriteria(criteria));
}
public List<String> getSharedListUserNames() {
DetachedCriteria criteria = DetachedCriteria.forClass(CustomSeriesList.class);
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("userName"));
criteria.setProjection(Projections.distinct(projectionList));
List<String> results = new ArrayList<String>();
results = getHibernateTemplate().findByCriteria(criteria);
return results;
}
@SuppressWarnings("unchecked")
@Override
public ResultList getUnique(String key, String query) {
Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PersonName.class);
criteria.add(Restrictions.ilike(key, query + "%"));
criteria.setProjection(Projections.distinct(Projections.property(key)));
criteria.setMaxResults(20);
return new ResultList(criteria.list());
}
@Override
@SuppressWarnings("unchecked")
public List<String> getFormNames(Person owner) {
DetachedCriteria criteria = DetachedCriteria.forClass(type);
criteria.setProjection(Projections.distinct(Projections.property("formName")));
if (owner != null) criteria.add(Restrictions.eq("person.personId", owner.getPersonId()));
return getHibernateTemplate().findByCriteria(criteria);
}
private <P> Criteria buildProjectionCriteria(
Class<P> projectClass, Criteria criteria, Projection projections, boolean distinctResult) {
if (distinctResult) {
criteria.setProjection(Projections.distinct(projections));
} else {
criteria.setProjection(projections);
}
return criteria.setResultTransformer(Transformers.aliasToBean(projectClass));
}
@SuppressWarnings("unchecked")
public List<String> getAllHomeDepartments(ObjectStatus status) {
Criteria criteria = createCriteria();
if (status != null) criteria.add(Restrictions.eq("objectStatus", status));
criteria.add(Restrictions.isNotNull("departmentName"));
criteria.setProjection(
Projections.projectionList()
.add(Projections.distinct(Projections.property("departmentName"))));
return ((List<String>) criteria.list());
}
@SuppressWarnings("unchecked")
@Override
public List<Oficina> listarOficinas(Integer idInscricaoCurso) {
Criteria criteria = getSession().createCriteria(Oficina.class);
DetachedCriteria subCriteria = DetachedCriteria.forClass(SelecaoOficina.class);
subCriteria.add(Property.forName("inscricaoCurso.id").eq(idInscricaoCurso));
subCriteria.setProjection(Projections.distinct(Projections.property("oficina.id")));
criteria.add(Property.forName("id").in(subCriteria));
return criteria.list();
}
@SuppressWarnings("unchecked")
@Override
public List<Integer> recuperarIdsOficinasDisponiveis(Integer idCursoSelecionado) {
Criteria criteria = getSession().createCriteria(Oficina.class);
if (idCursoSelecionado != null && !idCursoSelecionado.equals(0)) {
criteria.createAlias("curso", "curso");
criteria.add(Restrictions.eq("curso.id", idCursoSelecionado));
criteria.setProjection(Projections.distinct(Projections.property("id")));
}
return criteria.list();
}
public List<DmAccount> getListOwnerByPermittedAccount(
String accountId, Integer permissionLevelStart) {
DmAccount permittedAccount = null;
if (accountId != null) {
permittedAccount = new DmAccount();
permittedAccount.setId(accountId);
}
List<DmAccount> ownerList = null;
if (permittedAccount != null) {
Criteria crit = getSession().createCriteria(DmFolder.class);
crit.setProjection(Projections.distinct(Projections.property("owner")));
crit.add(Restrictions.ne("owner", permittedAccount));
// crit.setProjection(Projections.property("owner"));
// crit.add(Restrictions.eq("owner", accountOwner));
// crit.add(Restrictions.isNull("parent"));
// crit.addOrder(Order.asc("name"));
// if (permissionLevelStart != null) {
// crit.createCriteria("permissionList").add(Restrictions.ge("permissionType",
// permissionLevelStart));
// }
// Criterion permissionCrit = null;
Conjunction conjunction = Restrictions.conjunction();
if (permissionLevelStart != null) {
conjunction.add(Restrictions.ge("permissionType", permissionLevelStart));
}
conjunction.add(Restrictions.eq("account", permittedAccount));
crit.createCriteria("permissionList").add(conjunction);
ownerList = crit.list();
// if (ownerList != null) {
// for (DmAccount owner : ownerList) {
// System.out.println("name = " + owner.getName());
// }
// }
// start - get children for each child (trigger lazy fetch)
// for (DmFolder folderTmp : folderList) {
// if (folderTmp.getChildList() != null) {
// folderTmp.getChildList().size();
// }
// }
// end - get children for each child (trigger lazy fetch)
}
return ownerList;
// return null;
}
@SuppressWarnings("unchecked")
@Override
public List<Oficina> recuperarOficina(Integer idCurso, Integer idPacote) {
Criteria criteria = getSession().createCriteria(Oficina.class);
DetachedCriteria subCriteria = DetachedCriteria.forClass(PacoteOficina.class);
subCriteria.createAlias("pacote", "p");
subCriteria.add(Property.forName("p.id").eq(idPacote));
subCriteria.createAlias("p.curso", "c");
subCriteria.add(Property.forName("c.id").eq(idCurso));
subCriteria.setProjection(Projections.distinct(Projections.property("oficina.id")));
criteria.add(Property.forName("id").in(subCriteria));
return criteria.list();
}
@Override
protected Set<String> loadInitialShardNames(Properties properties, BuildContext buildContext) {
ServiceManager serviceManager = buildContext.getServiceManager();
SessionFactory sessionFactory =
serviceManager.requestService(HibernateSessionFactoryService.class).getSessionFactory();
Session session = sessionFactory.openSession();
try {
Criteria initialShardsCriteria = session.createCriteria(Animal.class);
initialShardsCriteria.setProjection(Projections.distinct(Property.forName("type")));
@SuppressWarnings("unchecked")
List<String> initialTypes = initialShardsCriteria.list();
return new HashSet<String>(initialTypes);
} finally {
session.close();
}
}
public Collection<String> findAllQuantificationNames() throws DataAccessException {
DetachedCriteria criteria = DetachedCriteria.forClass(AimQuantification.class, "q");
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("name"));
criteria.setProjection(Projections.distinct(projectionList));
Collection<String> names = new ArrayList<String>();
Collection<String> results = getHibernateTemplate().findByCriteria(criteria);
for (String result : results) {
names.add(result);
}
return names;
}
@Override
public List<String> fetchDistinctCampaignIds() {
Session session = null;
List<String> list = null;
try {
session = sessionFactory.openSession();
Criteria criteria = session.createCriteria(CampaignInfo.class);
ProjectionList projList = Projections.projectionList();
projList.add(Projections.property("campaignId"));
criteria.setProjection(Projections.distinct(projList));
list = criteria.list();
} catch (HibernateException e) {
LOGGER.error("HibernateException while Geeting Campaign ID >>" + e.getMessage());
} finally {
session.clear();
}
return list;
}
private List<Object[]> getSharedListResult(List<String> seriesUids) {
List<Object[]> results = new ArrayList<Object[]>();
if (seriesUids != null && seriesUids.size() != 0) {
DetachedCriteria criteria = DetachedCriteria.forClass(CustomSeriesListAttribute.class);
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("csl.userName"));
projectionList.add(Projections.property("csl.name"));
projectionList.add(Projections.property("seriesInstanceUid"));
criteria.setProjection(Projections.distinct(projectionList));
criteria.createAlias("parent", "csl");
criteria.add(Restrictions.in("seriesInstanceUid", seriesUids));
results = getHibernateTemplate().findByCriteria(criteria);
}
return results;
}
public List<String> findBallTypes() {
return getSession()
.createCriteria(GameEntity.class)
.setProjection(Projections.distinct(Projections.property("ballType")))
.list();
}
@Override
public List<OnmsAssetRecord> getDistinctProperties() {
DetachedCriteria criteria = DetachedCriteria.forClass(OnmsAssetRecord.class);
ProjectionList projList = Projections.projectionList();
projList.add(
Projections.alias(Projections.property("additionalhardware"), "additionalhardware"));
projList.add(Projections.alias(Projections.property("address1"), "address1"));
projList.add(Projections.alias(Projections.property("address2"), "address2"));
projList.add(Projections.alias(Projections.property("admin"), "admin"));
projList.add(Projections.alias(Projections.property("assetNumber"), "assetNumber"));
projList.add(Projections.alias(Projections.property("autoenable"), "autoenable"));
projList.add(Projections.alias(Projections.property("building"), "building"));
projList.add(Projections.alias(Projections.property("category"), "category"));
projList.add(Projections.alias(Projections.property("circuitId"), "circuitId"));
projList.add(Projections.alias(Projections.property("city"), "city"));
projList.add(Projections.alias(Projections.property("comment"), "comment"));
projList.add(Projections.alias(Projections.property("connection"), "connection"));
projList.add(Projections.alias(Projections.property("cpu"), "cpu"));
projList.add(Projections.alias(Projections.property("department"), "department"));
projList.add(Projections.alias(Projections.property("description"), "description"));
projList.add(Projections.alias(Projections.property("displayCategory"), "displayCategory"));
projList.add(Projections.alias(Projections.property("division"), "division"));
projList.add(Projections.alias(Projections.property("enable"), "enable"));
projList.add(Projections.alias(Projections.property("floor"), "floor"));
projList.add(Projections.alias(Projections.property("hdd1"), "hdd1"));
projList.add(Projections.alias(Projections.property("hdd2"), "hdd2"));
projList.add(Projections.alias(Projections.property("hdd3"), "hdd3"));
projList.add(Projections.alias(Projections.property("hdd4"), "hdd4"));
projList.add(Projections.alias(Projections.property("hdd5"), "hdd5"));
projList.add(Projections.alias(Projections.property("hdd6"), "hdd6"));
projList.add(Projections.alias(Projections.property("inputpower"), "inputpower"));
projList.add(Projections.alias(Projections.property("lease"), "lease"));
projList.add(Projections.alias(Projections.property("maintcontract"), "maintcontract"));
projList.add(Projections.alias(Projections.property("manufacturer"), "manufacturer"));
projList.add(Projections.alias(Projections.property("modelNumber"), "modelNumber"));
projList.add(Projections.alias(Projections.property("notifyCategory"), "notifyCategory"));
projList.add(Projections.alias(Projections.property("numpowersupplies"), "numpowersupplies"));
projList.add(Projections.alias(Projections.property("operatingSystem"), "operatingSystem"));
projList.add(Projections.alias(Projections.property("pollerCategory"), "pollerCategory"));
projList.add(Projections.alias(Projections.property("port"), "port"));
projList.add(Projections.alias(Projections.property("rack"), "rack"));
projList.add(Projections.alias(Projections.property("ram"), "ram"));
projList.add(Projections.alias(Projections.property("region"), "region"));
projList.add(Projections.alias(Projections.property("room"), "room"));
projList.add(Projections.alias(Projections.property("serialNumber"), "serialNumber"));
projList.add(Projections.alias(Projections.property("slot"), "slot"));
projList.add(Projections.alias(Projections.property("snmpcommunity"), "snmpcommunity"));
projList.add(Projections.alias(Projections.property("state"), "state"));
projList.add(Projections.alias(Projections.property("storagectrl"), "storagectrl"));
projList.add(Projections.alias(Projections.property("supportPhone"), "supportPhone"));
projList.add(Projections.alias(Projections.property("thresholdCategory"), "thresholdCategory"));
projList.add(Projections.alias(Projections.property("username"), "username"));
projList.add(Projections.alias(Projections.property("vendor"), "vendor"));
projList.add(Projections.alias(Projections.property("vendorAssetNumber"), "vendorAssetNumber"));
projList.add(Projections.alias(Projections.property("vendorFax"), "vendorFax"));
projList.add(Projections.alias(Projections.property("vendorPhone"), "vendorPhone"));
projList.add(Projections.alias(Projections.property("zip"), "zip"));
criteria.setProjection(Projections.distinct(projList));
criteria.setResultTransformer(Transformers.aliasToBean(OnmsAssetRecord.class));
@SuppressWarnings("unchecked")
List<OnmsAssetRecord> result = getHibernateTemplate().findByCriteria(criteria);
return result;
}