@Override public Long count(List<String> searchFields, String keywords, String where) { Query<?> q = ds().createQuery(clazz); if (keywords != null && !keywords.equals("")) { List<Criteria> cl = new ArrayList<Criteria>(); String[] sa = keywords.split("[\\W]+"); for (String f : fillSearchFieldsIfEmpty_(searchFields)) { for (String s : sa) { cl.add(q.criteria(f).containsIgnoreCase(keywords)); } } q.or(cl.toArray(new Criteria[]{})); } processWhere(q, where); return q.countAll(); }
@Override public List<play.db.Model> fetch(int offset, int size, String orderBy, String order, List<String> searchFields, String keywords, String where) { if (orderBy == null) orderBy = keyName(); if ("DESC".equalsIgnoreCase(order)) orderBy = null == orderBy ? null : "-" + orderBy; Query<? extends Model> q = ds().createQuery(clazz).offset(offset) .limit(size); if (null != orderBy) q = q.order(orderBy); if (keywords != null && !keywords.equals("")) { List<Criteria> cl = new ArrayList<Criteria>(); String[] sa = keywords.split("[\\W]+"); for (String f : fillSearchFieldsIfEmpty_(searchFields)) { List<Criteria> cl0 = new ArrayList<Criteria>(); for (String s : sa) { cl0.add(q.criteria(f).containsIgnoreCase(s)); } cl.add(q.and(cl0.toArray(new Criteria[]{}))); } q.or(cl.toArray(new Criteria[]{})); } processWhere(q, where); List<play.db.Model> l = new ArrayList<play.db.Model>(); l.addAll(q.asList()); return l; }
switch(date) { case TODAY: { query.field(insertedOnDate).containsIgnoreCase(LocalDate.now().format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).containsIgnoreCase(LocalDate.now().minusDays(1).format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).containsIgnoreCase(CalendarUtils.yearAndMonth(LocalDate.now())); break; query.field(insertedOnDate).containsIgnoreCase(CalendarUtils.yearAndMonth(LocalDate.now().minusMonths(1))); break;
query.criteria("name").containsIgnoreCase(filter.getFilter()), query.criteria("description").containsIgnoreCase(filter.getFilter()) );
query.field(filtersDTO.getName()).containsIgnoreCase(value1.toString()); break; .containsIgnoreCase(LocalDate.now().format(DateTimeFormatter.ISO_DATE)); break; .containsIgnoreCase(LocalDate.now().minusDays(1).format(DateTimeFormatter.ISO_DATE)); break; query.field(filtersDTO.getName()).containsIgnoreCase(CalendarUtils.yearAndMonth(LocalDate.now())); break; query.field(filtersDTO.getName()).containsIgnoreCase(CalendarUtils.yearAndMonth(LocalDate.now().minusMonths(1))); break; query.field(filtersDTO.getName()).containsIgnoreCase(CalendarUtils.year(LocalDate.now())); break;