public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(SiteVisitsImpl.class) .add(Expression.eq("siteId", siteId)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
public Object doInHibernate(Session session) throws HibernateException { return session.createCriteria(RWikiCurrentObject.class).add( Expression.ge("version", since)).add( //$NON-NLS-1$ Expression.eq("realm", realm)).addOrder( //$NON-NLS-1$ Order.desc("version")).list(); //$NON-NLS-1$ } };
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(SiteActivityImpl.class) .add(Expression.eq("siteId", siteId)) .add(Expression.in("eventId", events)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(ResourceStatImpl.class) .add(Expression.eq("siteId", siteId)); if(!showAnonymousAccessEvents) c.add(Expression.ne("userId", "?")); if(userIdList != null && userIdList.size() > 0) c.add(Expression.in("userId", userIdList)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(EventStatImpl.class) .add(Expression.eq("siteId", siteId)) .add(Expression.in("eventId", events)); if(!showAnonymousAccessEvents) c.add(Expression.ne("userId", "?")); if(userIdList != null && userIdList.size() > 0) c.add(Expression.in("userId", userIdList)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
public int getChannelMessagesCount(ChatChannel channel, String context, Date date) { if (channel == null) { // default to the first one List<ChatChannel> channels = getContextChannels(context, true); if (channels != null && channels.size() > 0) { channel = channels.iterator().next(); } } int count = 0; if (channel != null) { Criteria c = this.getSession().createCriteria(ChatMessage.class); c.add(Expression.eq("chatChannel", channel)); if (date != null) { c.add(Expression.ge("messageDate", date)); } c.setProjection(Projections.rowCount()); Integer countInt = (Integer) c.uniqueResult(); if (countInt != null) { count = countInt.intValue(); } } return count; }
c.add(Expression.eq("chatChannel", channel)); if (localDate != null) { c.add(Expression.ge("messageDate", localDate));