@Override public LeaveCalendarDocumentHeader getNextDocumentHeader(String principalId, DateTime endDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay end date is the begin date of the next pay period crit.addEqualTo("beginDate", endDate.toDate()); QueryByCriteria query = new QueryByCriteria(LeaveCalendarDocumentHeader.class, crit); query.setStartAtIndex(0); query.setEndAtIndex(1); return (LeaveCalendarDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
@Override public TimesheetDocumentHeader getNextDocumentHeader(String principalId, DateTime payEndDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay end date is the begin date of the next pay period crit.addEqualTo("beginDate", payEndDate.toDate()); QueryByCriteria query = new QueryByCriteria(TimesheetDocumentHeader.class, crit); query.setStartAtIndex(0); query.setEndAtIndex(1); return (TimesheetDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
/** * Document header IDs are ordered, so an ID less than the current will * always be previous to current. */ public TimesheetDocumentHeader getPreviousDocumentHeader(String principalId, DateTime payBeginDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay begin date is the end date of the previous pay period crit.addEqualTo("endDate", payBeginDate.toDate()); QueryByCriteria query = new QueryByCriteria(TimesheetDocumentHeader.class, crit); query.addOrderByDescending("documentId"); query.setStartAtIndex(0); query.setEndAtIndex(1); return (TimesheetDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
/** * Document header IDs are ordered, so an ID less than the current will * always be previous to current. */ public LeaveCalendarDocumentHeader getPreviousDocumentHeader(String principalId, DateTime beginDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay begin date is the end date of the previous pay period crit.addEqualTo("endDate", beginDate.toDate()); QueryByCriteria query = new QueryByCriteria(LeaveCalendarDocumentHeader.class, crit); query.addOrderByDescending("documentId"); query.setStartAtIndex(0); query.setEndAtIndex(1); return (LeaveCalendarDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
ojbQuery.setStartAtIndex(startAtIndex);