Map<String, LocalDate> week = CalendarUtils.firstAndLastDaysOfWeek(LocalDate.now()); query.field(insertedOnDate).greaterThanOrEq(week.get("first").format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).lessThanOrEq(week.get("last").format(DateTimeFormatter.ISO_DATE)); break; Map<String, LocalDate> week = CalendarUtils.firstAndLastDaysOfWeek(LocalDate.now().minusWeeks(1)); query.field(insertedOnDate).greaterThanOrEq(week.get("first").format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).lessThanOrEq(week.get("last").format(DateTimeFormatter.ISO_DATE)); break;
query.field(filtersDTO.getName()).lessThanOrEq(value2); break; query.field(filtersDTO.getName()).lessThanOrEq(value1); break; Map<String, LocalDate> week = CalendarUtils.firstAndLastDaysOfWeek(LocalDate.now()); query.field(filtersDTO.getName()).greaterThanOrEq(week.get("first").format(DateTimeFormatter.ISO_DATE)); query.field(filtersDTO.getName()).lessThanOrEq(week.get("last").format(DateTimeFormatter.ISO_DATE)); break; Map<String, LocalDate> week = CalendarUtils.firstAndLastDaysOfWeek(LocalDate.now().minusWeeks(1)); query.field(filtersDTO.getName()).greaterThanOrEq(week.get("first").format(DateTimeFormatter.ISO_DATE)); query.field(filtersDTO.getName()).lessThanOrEq(week.get("last").format(DateTimeFormatter.ISO_DATE)); break;
/** * finds job by date ranges * @param createdBefore date - "Includes the day listed", example: "2016-08-08T18:04:23.514Z" * @param createdAfter date - "Includes the day listed", example: "2016-08-08T18:04:23.514Z" * @return List of LGJob items found */ public List<LGJob> getAllByDateRange(Date createdBefore, Date createdAfter) { Query<LGJob> query; if ((createdBefore != null) && (createdAfter == null) ) { query = getDatastore().createQuery(LGJob.class) .field("createDate").lessThanOrEq(createdBefore); } else if ((createdBefore == null) && (createdAfter != null)) { query = getDatastore().createQuery(LGJob.class) .field("createDate").greaterThanOrEq(createdAfter); } else { query = getDatastore().createQuery(LGJob.class) .filter("createDate <=", createdBefore) .filter("createDate >=", createdAfter); } return query.asList(); }