Java Code Examples for org.hibernate.criterion.Projections

The following are top voted examples for showing how to use org.hibernate.criterion.Projections. These examples are extracted from open source projects. You can vote up the examples you like and your votes will be used in our system to generate more good examples.
Example 1
Project: sjk   File: AppDaoImpl.java   View source code 9 votes vote down vote up
@Override
public List<App> getAppsOfDropMarket(Session session, String marketName, Integer currentPage, Integer pageSize) {
    ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("pkname"));
    proList.add(Projections.property("signatureSha1"));
    Criteria cri = session.createCriteria(App.class);
    cri.setProjection(proList);
    cri.setMaxResults(pageSize);
    cri.setFirstResult(HibernateHelper.firstResult(currentPage, pageSize));
    List<Object[]> list = HibernateHelper.list(cri);
    List<App> apps = null;
    if (list != null) {
        apps = new ArrayList<App>(list.size());
        for (Object[] obj : list) {
            App e = new App();
            e.setPkname((String) obj[0]);
            e.setSignatureSha1((String) obj[1]);
            apps.add(e);
        }
        list.clear();
    }
    return apps;
}
 
Example 2
Project: Equella   File: BasicItemSerializerProvider.java   View source code 7 votes vote down vote up
@Override
public void prepareItemQuery(ItemSerializerState state)
{
	final DetachedCriteria criteria = state.getItemQuery();
	final ProjectionList projection = state.getItemProjection();

	if( state.hasCategory(ItemSerializerService.CATEGORY_BASIC) )
	{
		projection.add(Projections.property("name.id"), NAME_ALIAS);
		projection.add(Projections.property("description.id"), DESC_ALIAS);
	}

	if( state.hasCategory(ItemSerializerService.CATEGORY_METADATA) )
	{
		criteria.createAlias("itemXml", "itemXml");
		projection.add(Projections.property("itemXml.xml"), METADATA_ALIAS);
	}
}
 
Example 3
Project: dhus-core   File: NetworkUsageDao.java   View source code 6 votes vote down vote up
public long getDownloadedSizeByUserSince (final User user, final Date date)
{
   Long result =
         getHibernateTemplate ().execute (new HibernateCallback<Long> ()
         {
            @Override
            public Long doInHibernate (Session session)
                  throws HibernateException, SQLException
            {
               Criteria criteria = session.createCriteria (
                     NetworkUsage.class);
               criteria.setProjection (Projections.sum ("size"));
               criteria.add (Restrictions.eq ("isDownload", true));
               criteria.add (Restrictions.eq ("user", user));
               criteria.add (Restrictions.gt ("date", date));
               return (Long) criteria.uniqueResult ();
            }
         });
   return (result == null) ? 0 : result;
}
 
Example 4
Project: OSWf-OSWorkflow-fork   File: HibernatePersistentVarsDAO.java   View source code 6 votes vote down vote up
@SuppressWarnings("unchecked")
protected Collection<String> getKeysImpl(Session session, Long piid, String prefix, Type type) throws HibernateException {

    if( piid == null )
        return Collections.EMPTY_LIST;

    Criteria criteria = session.createCriteria(getPersistentClass())
        .add(Restrictions.eq("processInstanceId", piid))
        .setProjection(Projections.property("key"));

    if (prefix != null)
        criteria.add(Restrictions.ilike("key", prefix, MatchMode.START));
        
    if(type != null)
        criteria.add(Restrictions.eq("type", type.getValue()));
    
    return criteria.list();
}
 
Example 5
Project: FlashBoard   File: UserDaoImpl.java   View source code 6 votes vote down vote up
@Override
public List<String> getAllNewUsers(){
	Session session = HibernateUtil.getSession();
	List<String> newUsers = new ArrayList<>();
	
	Criteria criteria;
	
	try {
		criteria = session.createCriteria(User.class);
		newUsers = criteria.add(Restrictions.like("approved", false)).setProjection(Projections.property("username")).list();
	}
	catch(HibernateException he) {
		he.printStackTrace();
	}finally {
		session.close();
	}
	
	if(newUsers.isEmpty()) {
		newUsers = null; 
	}
	
	return newUsers;
}
 
Example 6
Project: FlashBoard   File: UserDaoImpl.java   View source code 6 votes vote down vote up
@SuppressWarnings("unchecked")
@Override
public List<String> getAllPromotees(){
	Session session = HibernateUtil.getSession();
	List<String> promotees = new ArrayList<>();
	
	Criteria criteria;
	
	try {
		criteria = session.createCriteria(User.class);
		promotees = criteria.add(Restrictions.ge("avgScore", 70.0))
				.add(Restrictions.like("approved", true))
				.setProjection(Projections.property("username")).list();
	}
	catch(HibernateException he) {
		he.printStackTrace();
	}finally {
		session.close();
	}
	
	if(promotees.isEmpty()) {
		promotees = null; 
	}
	
	return promotees;
}
 
Example 7
Project: ctsms   File: InputFieldDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetEcrfFieldMaxSelectionSetValueCount(Long trialId) throws Exception {
	org.hibernate.Criteria inputFieldCriteria = createInputFieldCriteria();
	inputFieldCriteria.add(
			Restrictions.in("fieldType", SELECT_FIELD_TYPES)); // no AUTOCOMPLETE!
	org.hibernate.Criteria ecrfFieldCriteria = inputFieldCriteria.createCriteria("ecrfFields", "ecrfFields0", CriteriaSpecification.INNER_JOIN);
	ecrfFieldCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));

	org.hibernate.Criteria selectionSetValueCriteria = inputFieldCriteria.createCriteria("selectionSetValues","inputFieldSelectionSetValues", CriteriaSpecification.INNER_JOIN);

	inputFieldCriteria.setProjection(Projections.projectionList()
			.add(Projections.groupProperty("ecrfFields0.id"))
			.add(Projections.alias(Projections.count("inputFieldSelectionSetValues.id"),"selectionSetValuesCount")));

	inputFieldCriteria.addOrder(Order.desc("selectionSetValuesCount"));
	inputFieldCriteria.setMaxResults(1);
	long maxSelectionSetValues = 0l;
	try {
		maxSelectionSetValues = (Long) ((Object[]) inputFieldCriteria.list().iterator().next())[1];
	} catch (Exception e) {

	}
	return maxSelectionSetValues;
}
 
Example 8
Project: ctsms   File: UserPermissionProfileDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(
		Long userId, PermissionProfile profile, PermissionProfileGroup profileGroup, Boolean active)
				throws Exception {
	org.hibernate.Criteria userPermissionProfileCritria = createUserPermissionProfileCriteria();
	if (userId != null) {
		userPermissionProfileCritria.add(Restrictions.eq("user.id", userId.longValue()));
	}
	if (profile != null) {
		userPermissionProfileCritria.add(Restrictions.eq("profile", profile));
	}
	if (profileGroup != null) {
		userPermissionProfileCritria.add(Restrictions.in("profile", PermissionProfileGrouping.getProfilesFromPermissionProfileGroup(profileGroup)));
	}
	if (active != null) {
		userPermissionProfileCritria.add(Restrictions.eq("active", active.booleanValue()));
	}
	return (Long) userPermissionProfileCritria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 9
Project: ctsms   File: ECRFFieldValueDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(Long probandListEntryId, Long ecrfId, String section, boolean excludeAuditTrail, Boolean optional) throws Exception {
	org.hibernate.Criteria ecrfFieldValueCriteria = createEcrfFieldValueCriteria("ecrfFieldValue0");
	// if (probandListEntryId != null) {
	ecrfFieldValueCriteria.add(Restrictions.eq("listEntry.id", probandListEntryId.longValue()));
	// }
	org.hibernate.Criteria ecrfFieldCriteria = ecrfFieldValueCriteria.createCriteria("ecrfField", "ecrfField0"); // , CriteriaSpecification.INNER_JOIN);
	ecrfFieldCriteria.add(Restrictions.eq("ecrf.id", ecrfId.longValue()));
	// if (series != null) {
	// ecrfFieldCriteria.add(Restrictions.eq("series", series.booleanValue()));
	// }
	if (optional != null) {
		ecrfFieldCriteria.add(Restrictions.eq("optional", optional.booleanValue()));
	}
	if (section != null && section.length() > 0) {
		ecrfFieldCriteria.add(Restrictions.eq("section", section));
	} else {
		ecrfFieldCriteria.add(Restrictions.or(Restrictions.eq("section", ""), Restrictions.isNull("section")));
	}
	if (excludeAuditTrail) {
		applyEcrfFieldValueMaxIdSubCriteria(ecrfFieldValueCriteria, ecrfFieldCriteria, null, probandListEntryId, null);
	}
	return (Long) ecrfFieldValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 10
Project: ctsms   File: InventoryBookingDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(Long inventoryId, Long probandId, Long trialId,
		Long courseId, Long onBehalfOfId) throws Exception {
	Criteria bookingCriteria = createBookingCriteria();
	if (inventoryId != null) {
		bookingCriteria.add(Restrictions.eq("inventory.id", inventoryId.longValue()));
	}
	if (probandId != null) {
		bookingCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
	}
	if (trialId != null) {
		bookingCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
	}
	if (courseId != null) {
		bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
	}
	if (onBehalfOfId != null) {
		bookingCriteria.add(Restrictions.eq("onBehalfOf.id", onBehalfOfId.longValue()));
	}
	return (Long) bookingCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 11
Project: admin-shiro   File: AdminService.java   View source code 6 votes vote down vote up
@SuppressWarnings("unchecked")
public Pagination<AdminDO> pageAdminsByConditions(Integer pageIndex, Integer pageSize, Map<String, Object> params){
    //获取记录总数
    Criteria criteria = daoSupport.createCriteria(AdminDO.class);
    //相当于 select count(uid)
    criteria.setProjection(Projections.count("uid"));
    //设置查询条件
    if (Objects.nonNull(params)) {
        criteria.add(Restrictions.allEq(params));
    }
    criteria.add(Restrictions.eq("editEnable", Boolean.TRUE));
    Long total = (Long) criteria.uniqueResult();

    //开始查询列表,首先清除count查询所用Projection
    criteria.setProjection(null);
    criteria.setFirstResult((pageIndex - 1)* pageSize);
    criteria.setMaxResults(pageIndex * pageSize);
    List<AdminDO> admins = criteria.list();

    Pagination<AdminDO> pagination = new Pagination<AdminDO>(Long.valueOf(pageIndex), Long.valueOf(pageSize), total);
    pagination.setItems(admins);
    return pagination;
}
 
Example 12
Project: ctsms   File: InquiryValueDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(Long trialId, Boolean active, Boolean activeSignup, Long probandId) throws Exception {
	org.hibernate.Criteria inquiryValueCriteria = createInquiryValueCriteria();
	if (probandId != null) {
		inquiryValueCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
	}
	if (trialId != null || active != null) {
		org.hibernate.Criteria inquiryCriteria = inquiryValueCriteria.createCriteria("inquiry", CriteriaSpecification.INNER_JOIN);
		if (trialId != null) {
			inquiryCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
		}
		if (active != null) {
			inquiryCriteria.add(Restrictions.eq("active", active.booleanValue()));
		}
		if (activeSignup != null) {
			inquiryCriteria.add(Restrictions.eq("activeSignup", activeSignup.booleanValue()));
		}
	}
	return (Long) inquiryValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 13
Project: SandBoxNGSB   File: QuoteDAOImpl.java   View source code 6 votes vote down vote up
@Override
public QuotePE getLast(String sigle) {
	Session session = getSession();

	DetachedCriteria  maxDate = DetachedCriteria.forClass(QuotePE.class);
	maxDate.add(Restrictions.eq("symbol", sigle));
	maxDate.setProjection(Projections.max("creationDateTime"));
	
   	Criteria criteria = session.createCriteria(QuotePE.class);
   	criteria.add(Restrictions.eq("symbol", sigle));
   	criteria.add(Property.forName("creationDateTime").eq(maxDate));
   	
	QuotePE pe = (QuotePE) criteria.uniqueResult();
	session.close();
	
	return pe;
}
 
Example 14
Project: sjk   File: AppDaoImpl.java   View source code 6 votes vote down vote up
@Override
public long countForSearchingRolling(Short catalog, Integer subCatalog, String keywords) {
    Criteria cri = getSession().createCriteria(Rollinfo.class);
    Criteria appCriteria = cri.createCriteria("app", JoinType.LEFT_OUTER_JOIN);

    if (catalog != null) {
        appCriteria.add(Restrictions.eq("catalog", catalog));
    }
    if (subCatalog != null) {
        appCriteria.add(Restrictions.eq("subCatalog", subCatalog));
    }

    if (keywords != null && !keywords.isEmpty()) {
        appCriteria.add(Restrictions.like("name", keywords, MatchMode.START));
    }
    cri.setProjection(Projections.rowCount());
    List<Long> list = HibernateHelper.list(cri);
    return list.get(0);
}
 
Example 15
Project: ctsms   File: ECRFFieldValueDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected Long handleGetMaxIndex(Long probandListEntryId, Long ecrfId, String section) throws Exception {
	org.hibernate.Criteria ecrfFieldValueCriteria = createEcrfFieldValueCriteria(null);
	if (probandListEntryId != null) {
		ecrfFieldValueCriteria.add(Restrictions.eq("listEntry.id", probandListEntryId.longValue()));
	}
	ecrfFieldValueCriteria.add(Restrictions.isNotNull("index"));
	org.hibernate.Criteria ecrfFieldCriteria = ecrfFieldValueCriteria.createCriteria("ecrfField");
	ecrfFieldCriteria.add(Restrictions.eq("ecrf.id", ecrfId.longValue()));
	ecrfFieldCriteria.add(Restrictions.eq("series", true));
	if (section != null && section.length() > 0) {
		ecrfFieldCriteria.add(Restrictions.eq("section", section));
	} else {
		ecrfFieldCriteria.add(Restrictions.or(Restrictions.eq("section", ""), Restrictions.isNull("section")));
	}
	return (Long) ecrfFieldValueCriteria.setProjection(Projections.max("index")).uniqueResult();
}
 
Example 16
Project: ctsms   File: ProbandAddressDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(Long probandId, Boolean deliver, Boolean afnus, Boolean wireTransfer) throws Exception {
	org.hibernate.Criteria probandAddressCriteria = createAddressCriteria();
	if (probandId != null) {
		probandAddressCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
	}
	if (deliver != null) {
		probandAddressCriteria.add(Restrictions.eq("deliver", deliver.booleanValue()));
	}
	if (afnus != null) {
		probandAddressCriteria.add(Restrictions.eq("afnus", afnus.booleanValue()));
	}
	if (wireTransfer != null) {
		probandAddressCriteria.add(Restrictions.eq("wireTransfer", wireTransfer.booleanValue()));
	}
	return (Long) probandAddressCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 17
Project: ctsms   File: StreetDaoImpl.java   View source code 6 votes vote down vote up
/**
 * @inheritDoc
 */
@Override
protected Collection<String> handleFindZipCodes(String countryName, String zipCodePrefix, String cityName, String streetName, Integer limit)
{
	org.hibernate.Criteria streetCriteria = createStreetCriteria();
	if (!CommonUtil.isEmptyString(countryName)) {
		streetCriteria.add(Restrictions.eq("countryName", countryName));
	}
	CategoryCriterion.apply(streetCriteria, new CategoryCriterion(zipCodePrefix, "zipCode", MatchMode.START));
	if (!CommonUtil.isEmptyString(cityName)) {
		streetCriteria.add(Restrictions.eq("cityName", cityName));
	}
	if (!CommonUtil.isEmptyString(streetName)) {
		streetCriteria.add(Restrictions.eq("streetName", streetName));
	}
	streetCriteria.add(Restrictions.not(Restrictions.or(Restrictions.eq("zipCode", ""), Restrictions.isNull("zipCode"))));
	streetCriteria.addOrder(Order.asc("zipCode"));
	streetCriteria.setProjection(Projections.distinct(Projections.property("zipCode")));
	CriteriaUtil.applyLimit(limit,
			Settings.getIntNullable(SettingCodes.ZIP_CODE_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS, DefaultSettings.ZIP_CODE_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT),
			streetCriteria);
	return streetCriteria.list();
}
 
Example 18
Project: ctsms   File: ECRFFieldValueDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(Long probandListEntryId, Long ecrfId, boolean excludeAuditTrail, Boolean series, Boolean optional) throws Exception {
	org.hibernate.Criteria ecrfFieldValueCriteria = createEcrfFieldValueCriteria("ecrfFieldValue0");
	// if (probandListEntryId != null) {
	ecrfFieldValueCriteria.add(Restrictions.eq("listEntry.id", probandListEntryId.longValue()));
	// }
	org.hibernate.Criteria ecrfFieldCriteria = ecrfFieldValueCriteria.createCriteria("ecrfField", "ecrfField0"); // , CriteriaSpecification.INNER_JOIN);
	ecrfFieldCriteria.add(Restrictions.eq("ecrf.id", ecrfId.longValue()));
	// if (ecrfId != null) {
	// ecrfFieldCriteria = ecrfFieldValueCriteria.createCriteria("ecrfField", "ecrfField0", CriteriaSpecification.INNER_JOIN);
	// ecrfFieldValueCriteria.add(Restrictions.eq("ecrfField.id", ecrfFieldId.longValue()));
	// }
	// org.hibernate.Criteria ecrfFieldCriteria = null;
	if (series != null) {
		ecrfFieldCriteria.add(Restrictions.eq("series", series.booleanValue()));
	}
	if (optional != null) {
		ecrfFieldCriteria.add(Restrictions.eq("optional", optional.booleanValue()));
	}
	if (excludeAuditTrail) {
		applyEcrfFieldValueMaxIdSubCriteria(ecrfFieldValueCriteria, ecrfFieldCriteria, null, probandListEntryId, null);
	}
	return (Long) ecrfFieldValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 19
Project: ctsms   File: ProbandContactDetailValueDaoImpl.java   View source code 6 votes vote down vote up
@Override
protected long handleGetCount(Long probandId, Boolean notify, Boolean na, Boolean email, Boolean phone) throws Exception {
	org.hibernate.Criteria probandContactDetailValueCriteria = createContactDetailValueCriteria();
	if (probandId != null) {
		probandContactDetailValueCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
	}
	if (notify != null) {
		probandContactDetailValueCriteria.add(Restrictions.eq("notify", notify.booleanValue()));
	}
	if (na != null) {
		probandContactDetailValueCriteria.add(Restrictions.eq("na", na.booleanValue()));
	}
	if (email != null || phone != null) {
		org.hibernate.Criteria typeCriteria = probandContactDetailValueCriteria.createCriteria("type");
		if (email != null) {
			typeCriteria.add(Restrictions.eq("email", email.booleanValue()));
		}
		if (phone != null) {
			typeCriteria.add(Restrictions.eq("phone", phone.booleanValue()));
		}
	}
	return (Long) probandContactDetailValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 20
Project: dhus-core   File: HibernateDao.java   View source code 5 votes vote down vote up
public int count (DetachedCriteria detached)
{
   Session session = getSessionFactory ().getCurrentSession ();
   Criteria criteria = detached.getExecutableCriteria (session);
   criteria.setProjection(Projections.rowCount());
   Object result = criteria.uniqueResult ();
   return ((Number) result).intValue ();
}
 
Example 21
Project: ctsms   File: MimeTypeDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected long handleGetCount(String mimeType,
		FileModule module) throws Exception {
	org.hibernate.Criteria mimeTypeCriteria = createMimeTypeCriteria();
	if (mimeType != null && mimeType.length() > 0) {
		mimeTypeCriteria.add(Restrictions.eq("mimeType", mimeType));
	}
	if (module != null) {
		mimeTypeCriteria.add(Restrictions.eq("module", module));
	}
	return (Long) mimeTypeCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 22
Project: ctsms   File: ProbandListEntryTagValueDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected long handleGetCountByField(Long inputFieldId) throws Exception {
	org.hibernate.Criteria listEntryTagValueCriteria = createListEntryTagValueCriteria();
	if (inputFieldId != null) {
		org.hibernate.Criteria tagCriteria = listEntryTagValueCriteria.createCriteria("tag", CriteriaSpecification.INNER_JOIN);
		tagCriteria.add(Restrictions.eq("field.id", inputFieldId.longValue()));
	}
	return (Long) listEntryTagValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 23
Project: lemon   File: HibernateGenericDao.java   View source code 5 votes vote down vote up
/**
 * 获得总记录数.
 * 
 * @param criteria
 *            条件
 * @return 总数
 */
@Transactional(readOnly = true)
public Integer getCount(Criteria criteria) {
    Object result = criteria.setProjection(Projections.rowCount())
            .uniqueResult();

    return HibernateUtils.getNumber(result);
}
 
Example 24
Project: sdudoc   File: BookDaoImpl.java   View source code 5 votes vote down vote up
@Override
public Pager<Book> showBookByStyle(String style, int pageNo, int pageSize) {
	
	Session session = sessionFactory.getCurrentSession();
	Criteria criteria = session.createCriteria(Book.class);
	criteria.add(Restrictions.eq("bookStyle", style));
	long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
	criteria.setProjection(null);
	criteria.addOrder(Order.desc("clickTimes"));
	criteria.setFirstResult((pageNo - 1) * pageSize);
	criteria.setMaxResults(pageSize);
	List<Book> results = criteria.list();
	Pager<Book> page=new Pager<Book>(pageSize, pageNo, recordTotal, results);
	return page;
}
 
Example 25
Project: ctsms   File: ProbandDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected long handleGetChildrenCount(Long probandId) throws Exception {
	org.hibernate.Criteria probandCriteria = createProbandCriteria(null);
	probandCriteria.add(Restrictions.idEq(probandId.longValue()));
	org.hibernate.Criteria parentsCriteria = probandCriteria.createCriteria("parents", CriteriaSpecification.INNER_JOIN);
	return (Long) parentsCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 26
Project: ctsms   File: ProbandListEntryTagDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected long handleGetCountByField(Long inputFieldId) throws Exception {
	org.hibernate.Criteria listEntryTagCriteria = createListEntryTagCriteria();
	if (inputFieldId != null) {
		listEntryTagCriteria.add(Restrictions.eq("field.id", inputFieldId.longValue()));
	}
	return (Long) listEntryTagCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 27
Project: sdudoc   File: BookDaoImpl.java   View source code 5 votes vote down vote up
public Pager<Book> showBookByClickTimes(int pageNo, int pageSize) {
	Session session = sessionFactory.getCurrentSession();
	Criteria criteria = session.createCriteria(Book.class);
	long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
	criteria.setProjection(null);
	criteria.addOrder(Order.desc("clickTimes"));
	criteria.setFirstResult((pageNo - 1) * pageSize);
	criteria.setMaxResults(pageSize);
	List<Book> results = criteria.list();
	Pager<Book> page=new Pager<Book>(pageSize, pageNo, recordTotal, results);
	return page;
	
}
 
Example 28
Project: ctsms   File: FileDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected long handleGetCount(FileModule module, Long id, String logicalPath,
		Boolean active, Boolean image, String mimeType) throws Exception {
	org.hibernate.Criteria fileCriteria = createFileCriteria();
	applyModuleIdCriterions(fileCriteria, module, id);
	if (logicalPath != null && logicalPath.length() > 0) {
		fileCriteria.add(Restrictions.eq("logicalPath", CommonUtil.fixLogicalPathFolderName(logicalPath)));
	}
	if (active != null) {
		fileCriteria.add(Restrictions.eq("active", active.booleanValue()));
	}
	applyContentTypeCriterions(fileCriteria, image, mimeType);
	return (Long) fileCriteria.setProjection(Projections.rowCount()).uniqueResult();
}
 
Example 29
Project: sdudoc   File: LogDaoImpl.java   View source code 5 votes vote down vote up
@SuppressWarnings("unchecked")
@Override
public Pager<SysLog> listLogAllByPage(int pageNo, int pageSize) {
	Session session = sessionFactory.getCurrentSession();
	Criteria criteria = session.createCriteria(SysLog.class);
	long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
	criteria.setProjection(null);
	criteria.addOrder(Order.desc("time"));
	criteria.setFirstResult((pageNo - 1) * pageSize);
	criteria.setMaxResults(pageSize);
	List<SysLog> results = criteria.list();
	return new Pager<SysLog>(pageSize, pageNo, recordTotal, results);
}
 
Example 30
Project: sdudoc   File: CollectDaoImpl.java   View source code 5 votes vote down vote up
@Override
public Pager<Collect> listCollectsByUser(int userId, int pageNo, int pageSize) {
	Session session = sessionFactory.getCurrentSession();
	Criteria criteria = session.createCriteria(Collect.class);
	criteria.add(Restrictions.eq("userId", userId));
	long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
	criteria.setProjection(null);
	criteria.addOrder(Order.desc("collectDate"));
	criteria.setFirstResult((pageNo - 1) * pageSize);
	criteria.setMaxResults(pageSize);
	List<Collect> results = criteria.list();
	return new Pager<Collect>(pageSize, pageNo, recordTotal, results);
}
 
Example 31
Project: ctsms   File: PermissionDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected Collection<Permission> handleFindByServiceMethodUser(
		String serviceMethod, Long userId, Boolean profilePermissionActive,
		Boolean userPermissionProfileActive) throws Exception {
	org.hibernate.Criteria permissionCritria = createPermissionCriteria();
	if (serviceMethod != null) {
		permissionCritria.add(Restrictions.eq("serviceMethod", serviceMethod));
	}
	if (userId != null || profilePermissionActive != null || userPermissionProfileActive != null) {
		org.hibernate.Criteria profilePermissionCritria = permissionCritria.createCriteria("profilePermissions", CriteriaSpecification.LEFT_JOIN);
		if (profilePermissionActive != null) {
			profilePermissionCritria.add(Restrictions.eq("active", profilePermissionActive.booleanValue()));
		}
		if (userId != null || userPermissionProfileActive != null) {
			DetachedCriteria subQuery = DetachedCriteria.forClass(UserPermissionProfileImpl.class, "userPermissionProfile"); // IMPL!!!!
			subQuery.setProjection(Projections.projectionList().add(Projections.property("profile")));
			if (userId != null) {
				subQuery.add(Restrictions.eq("user.id", userId.longValue()));
			}
			if (userPermissionProfileActive != null) {
				subQuery.add(Restrictions.eq("active", userPermissionProfileActive.booleanValue()));
			}
			profilePermissionCritria.add(Subqueries.propertyIn("profile", subQuery));
		}
	}
	return permissionCritria.list();
}
 
Example 32
Project: ctsms   File: AspSubstanceDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected Collection<String> handleFindAspSubstanceNames(String nameInfix, Integer limit) {
	org.hibernate.Criteria aspSubstanceCriteria = createAspSubstanceCriteria(true);
	applyAspSubstanceNameCriterions(aspSubstanceCriteria, nameInfix);
	aspSubstanceCriteria.add(Restrictions.not(Restrictions.or(Restrictions.eq("name", ""), Restrictions.isNull("name"))));
	aspSubstanceCriteria.addOrder(Order.asc("name"));
	aspSubstanceCriteria.setProjection(Projections.distinct(Projections.property("name")));
	CriteriaUtil.applyLimit(limit, Settings.getIntNullable(SettingCodes.ASP_SUBSTANCE_NAME_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS,
			DefaultSettings.ASP_SUBSTANCE_NAME_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT), aspSubstanceCriteria);
	return aspSubstanceCriteria.list();
}
 
Example 33
Project: Equella   File: ItemSerializerState.java   View source code 5 votes vote down vote up
public void addPrivilege(String priv)
{
	if( privileges.isEmpty() )
	{
		addOwnerQuery();
		addCollectionQuery();
		addStatusQuery();
		itemProjection.add(Projections.property("metadataSecurityTargets"), SECURITY_ALIAS);
	}
	privileges.add(priv);
}
 
Example 34
Project: Equella   File: ItemSerializerState.java   View source code 5 votes vote down vote up
public void addStatusQuery()
{
	if( !statusAdded )
	{
		itemProjection.add(Projections.property("status"), STATUS_ALIAS);
		statusAdded = true;
	}

}
 
Example 35
Project: ctsms   File: MimeTypeDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected Collection<String> handleFindFileNameExtensions(FileModule module, Boolean image)
		throws Exception {
	org.hibernate.Criteria mimeTypeCriteria = createMimeTypeCriteria();
	if (module != null) {
		mimeTypeCriteria.add(Restrictions.eq("module", module));
	}
	if (image != null) {
		mimeTypeCriteria.add(Restrictions.eq("image", image.booleanValue()));
	}
	mimeTypeCriteria.setProjection(Projections.distinct(Projections.property("fileNameExtensions")));
	return mimeTypeCriteria.list();
}
 
Example 36
Project: Equella   File: AllVersionsWhereClause.java   View source code 5 votes vote down vote up
@Override
public void addWhere(ItemSerializerState state)
{
	ProjectionList projections = state.getItemProjection();
	DetachedCriteria criteria = state.getItemQuery();
	criteria.add(Restrictions.eq("uuid", uuid));
	criteria.addOrder(Order.asc(PROPERTY_VERSION));
	projections.add(Projections.property(PROPERTY_VERSION), ALIAS_VERSION);
}
 
Example 37
Project: ctsms   File: IcdSystCategoryDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected Collection<String> handleFindCategoryPreferredRubricLabels(
		String preferredRubricLabelInfix, Integer limit) throws Exception {
	org.hibernate.Criteria icdSystCategoryCriteria = this.getSession().createCriteria(IcdSystCategory.class);
	icdSystCategoryCriteria.setCacheable(true);
	CategoryCriterion.apply(icdSystCategoryCriteria, new CategoryCriterion(preferredRubricLabelInfix, "preferredRubricLabel", MatchMode.ANYWHERE));
	icdSystCategoryCriteria.add(Restrictions.not(Restrictions.or(Restrictions.eq("preferredRubricLabel", ""), Restrictions.isNull("preferredRubricLabel"))));
	// icdSystCategoryCriteria.add(Restrictions.eq("revision",
	// Settings.getString(SettingCodes.ICD_SYSTEMATICS_REVISION, Bundle.SETTINGS, DefaultSettings.ICD_SYSTEMATICS_REVISION)));
	icdSystCategoryCriteria.addOrder(Order.asc("preferredRubricLabel"));
	icdSystCategoryCriteria.setProjection(Projections.distinct(Projections.property("preferredRubricLabel")));
	CriteriaUtil.applyLimit(limit, Settings.getIntNullable(SettingCodes.ICD_SYST_CATEGORY_PREFERRED_RUBRIC_LABEL_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS,
			DefaultSettings.ICD_SYST_CATEGORY_PREFERRED_RUBRIC_LABEL_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT), icdSystCategoryCriteria);
	return icdSystCategoryCriteria.list();
}
 
Example 38
Project: ctsms   File: OpsSystBlockDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected Collection<String> handleFindBlockPreferredRubricLabels(
		String preferredRubricLabelInfix, Integer limit) throws Exception {
	org.hibernate.Criteria opsSystBlockCriteria = this.getSession().createCriteria(OpsSystBlock.class);
	opsSystBlockCriteria.setCacheable(true);
	CategoryCriterion.apply(opsSystBlockCriteria, new CategoryCriterion(preferredRubricLabelInfix, "preferredRubricLabel", MatchMode.ANYWHERE));
	opsSystBlockCriteria.add(Restrictions.not(Restrictions.or(Restrictions.eq("preferredRubricLabel", ""), Restrictions.isNull("preferredRubricLabel"))));
	// opsSystBlockCriteria.add(Restrictions.eq("revision", Settings.getString(SettingCodes.OPS_SYSTEMATICS_REVISION, Bundle.SETTINGS,
	// DefaultSettings.OPS_SYSTEMATICS_REVISION)));
	opsSystBlockCriteria.addOrder(Order.asc("preferredRubricLabel"));
	opsSystBlockCriteria.setProjection(Projections.distinct(Projections.property("preferredRubricLabel")));
	CriteriaUtil.applyLimit(limit, Settings.getIntNullable(SettingCodes.OPS_SYST_BLOCK_PREFERRED_RUBRIC_LABEL_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS,
			DefaultSettings.OPS_SYST_BLOCK_PREFERRED_RUBRIC_LABEL_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT), opsSystBlockCriteria);
	return opsSystBlockCriteria.list();
}
 
Example 39
Project: ctsms   File: TitleDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected Collection<String> handleFindTitles(String titlePrefix, Integer limit)
		throws Exception {
	org.hibernate.Criteria titleCriteria = this.getSession().createCriteria(Title.class);
	titleCriteria.setCacheable(true);
	CategoryCriterion.apply(titleCriteria, new CategoryCriterion(titlePrefix, "title", MatchMode.START));
	titleCriteria.add(Restrictions.not(Restrictions.or(Restrictions.eq("title", ""), Restrictions.isNull("title"))));
	titleCriteria.addOrder(Order.asc("title"));
	titleCriteria.setProjection(Projections.distinct(Projections.property("title")));
	CriteriaUtil.applyLimit(limit,
			Settings.getIntNullable(SettingCodes.TITLE_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS, DefaultSettings.TITLE_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT),
			titleCriteria);
	return titleCriteria.list();
}
 
Example 40
Project: ctsms   File: InventoryTagValueDaoImpl.java   View source code 5 votes vote down vote up
@Override
protected long handleGetCount(
		Long inventoryId) throws Exception {
	org.hibernate.Criteria tagValueCriteria =createTagValueCriteria();
	if (inventoryId != null) {
		tagValueCriteria.add(Restrictions.eq("inventory.id", inventoryId.longValue()));
	}
	return (Long) tagValueCriteria.setProjection(Projections.rowCount()).uniqueResult();
}