List of usage examples for org.apache.commons.lang3.time DateUtils addMilliseconds
public static Date addMilliseconds(final Date date, final int amount)
From source file:org.zanata.model.Activity.java
@Transient public Date getEndDate() { return DateUtils.addMilliseconds(approxTime, endOffsetMillis); }
From source file:storybook.model.dao.LocationDAOImpl.java
public long countByPersonLocationDate(Person person, Location location, Date date) { date = DateUtil.getZeroTimeDate(date); Query query = session/*from ww w .j ava 2 s .co m*/ .createQuery("select count(s) from Scene as s" + " join s.persons as p" + " join s.locations as l" + " where p=:person and l=:location" + " and s.sceneTs between :tsStart and :tsEnd"); query.setEntity("person", person); query.setEntity("location", location); Timestamp tsStart = new Timestamp(date.getTime()); date = DateUtils.addDays(date, 1); date = DateUtils.addMilliseconds(date, -1); Timestamp tsEnd = new Timestamp(date.getTime()); query.setTimestamp("tsStart", tsStart); query.setTimestamp("tsEnd", tsEnd); return (Long) query.uniqueResult(); }
From source file:storybook.model.dao.SceneDAOImpl.java
@SuppressWarnings("unchecked") public List<Scene> findByDate(Date date) { if (date == null) { return new ArrayList<Scene>(); }/* ww w . j a va 2 s . co m*/ Query query = session.createQuery("select s from Scene as s" + " where s.sceneTs between :tsStart and :tsEnd" + " order by s.sceneTs, s.sceneno"); Timestamp tsStart = new Timestamp(date.getTime()); date = DateUtils.addDays(date, 1); date = DateUtils.addMilliseconds(date, -1); Timestamp tsEnd = new Timestamp(date.getTime()); query.setTimestamp("tsStart", tsStart); query.setTimestamp("tsEnd", tsEnd); return (List<Scene>) query.list(); }
From source file:storybook.model.dao.SceneDAOImpl.java
@SuppressWarnings("unchecked") public List<Scene> findByStrandAndDate(Strand strand, Date date) { if (date == null) { return new ArrayList<Scene>(); }//from www. ja v a 2 s.c o m // OLD: Query query = session // .createQuery("from Scene s where s.sceneTs = :sceneTs and s.strand=:strand order by s.sceneTs"); Query query = session.createQuery("select s from Scene as s" + " left join s.chapter as ch" + " where s.sceneTs between :tsStart and :tsEnd and s.strand=:strand" + " order by s.sceneTs, ch.chapterno, s.sceneno"); Timestamp tsStart = new Timestamp(date.getTime()); Date date2 = DateUtils.addDays(date, 1); date2 = DateUtils.addMilliseconds(date2, -1); Timestamp tsEnd = new Timestamp(date2.getTime()); query.setTimestamp("tsStart", tsStart); query.setTimestamp("tsEnd", tsEnd); query.setEntity("strand", strand); List<Scene> ret = query.list(); // find scenes with relative date List<Scene> scenes = findScenesWithRelativeSceneId(); for (Scene scene : scenes) { if (!scene.getStrand().getId().equals(strand.getId())) { continue; } Scene relativeScene = (Scene) session.get(Scene.class, scene.getRelativeSceneId()); Date sceneDate = scene.getRelativeDate(relativeScene); if (sceneDate == null) { continue; } if (sceneDate.compareTo(date) != 0) { continue; } ret.add(scene); } return ret; }
From source file:storybook.model.hbn.dao.SceneDAOImpl.java
@SuppressWarnings("unchecked") public List<Scene> findByDate(Date date) { if (date == null) { return new ArrayList<>(); }/*from www .ja va 2 s.co m*/ Query query = session.createQuery("select s from Scene as s" + " where s.sceneTs between :tsStart and :tsEnd" + " order by s.sceneTs, s.sceneno"); Timestamp tsStart = new Timestamp(date.getTime()); date = DateUtils.addDays(date, 1); date = DateUtils.addMilliseconds(date, -1); Timestamp tsEnd = new Timestamp(date.getTime()); query.setTimestamp("tsStart", tsStart); query.setTimestamp("tsEnd", tsEnd); return (List<Scene>) query.list(); }
From source file:storybook.model.hbn.dao.SceneDAOImpl.java
@SuppressWarnings("unchecked") public List<Scene> findByStrandAndDate(Strand strand, Date date) { if (date == null) { return new ArrayList<>(); }// w ww . ja v a 2 s .co m // OLD: Query query = session // .createQuery("from Scene s where s.sceneTs = :sceneTs and s.strand=:strand order by s.sceneTs"); Query query = session.createQuery("select s from Scene as s" + " left join s.chapter as ch" + " where s.sceneTs between :tsStart and :tsEnd and s.strand=:strand" + " order by s.sceneTs, ch.chapterno, s.sceneno"); Timestamp tsStart = new Timestamp(date.getTime()); Date date2 = DateUtils.addDays(date, 1); date2 = DateUtils.addMilliseconds(date2, -1); Timestamp tsEnd = new Timestamp(date2.getTime()); query.setTimestamp("tsStart", tsStart); query.setTimestamp("tsEnd", tsEnd); query.setEntity("strand", strand); List<Scene> ret = query.list(); // find scenes with relative date List<Scene> scenes = findScenesWithRelativeSceneId(); for (Scene scene : scenes) { if (!scene.getStrand().getId().equals(strand.getId())) { continue; } Scene relativeScene = (Scene) session.get(Scene.class, scene.getRelativeSceneId()); Date sceneDate = scene.getRelativeDate(relativeScene); if (sceneDate == null) { continue; } if (sceneDate.compareTo(date) != 0) { continue; } ret.add(scene); } return ret; }