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, 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(); } };