private Stream<Condition> getCondition(Long start, Long end) { return Stream.of(C_PAGE_VIEW.CREATE_TIME.ge(new Timestamp(start)), C_PAGE_VIEW.CREATE_TIME.le(new Timestamp(end))); }
protected Condition runAfterCondition(String resourceType) { if (resourceType == null) { return PROCESS_INSTANCE.RUN_AFTER.isNull() .or(PROCESS_INSTANCE.RUN_AFTER.le(new Date())); } return DSL.trueCondition(); }
return field.lt(condition.getValue()); case LTE: return field.le(condition.getValue()); case NE: return field.ne(condition.getValue());
q.START_AT.le(currentTimestamp()))));
Map<String, Object> e = tx.select(TRIGGER_SCHEDULE.TRIGGER_ID, TRIGGER_SCHEDULE.FIRE_AT) .from(TRIGGER_SCHEDULE) .where(TRIGGER_SCHEDULE.FIRE_AT.le(currentTimestamp())) .limit(1) .forUpdate()
public ArticleDetail getDetail(String id) { CArticle article = C_ARTICLE.as("a"); CArticle before = C_ARTICLE.as("b"); CArticle next = C_ARTICLE.as("n"); CArticle inner = C_ARTICLE.as("i"); ArticleDetail a = dao.execute(e -> { return e.select(Fields.all(article.fields(), before.ID.as("beforeId"), before.TITLE.as("beforeTitle"), next.ID.as("nextId"), next.TITLE.as("nextTitle") )).from(article) .leftJoin(before).on(before.ID.eq(e.select(inner.ID).from(inner).where(article.CREATE_TIME.ge(inner.CREATE_TIME)).and(inner.ID.ne(article.ID).and(inner.STATUS.eq(Article.STATUS_PUBLISH))).orderBy(inner.CREATE_TIME.desc()).limit(0, 1))) .leftJoin(next).on((next.ID.eq(e.select(inner.ID).from(inner).where(article.CREATE_TIME.le(inner.CREATE_TIME)).and(inner.ID.ne(article.ID).and(inner.STATUS.eq(Article.STATUS_PUBLISH))).orderBy(inner.CREATE_TIME).limit(0, 1)))) .where(article.ID.eq(id)) .fetchOne(r -> { return dao.mapperEntityEx(r, ArticleDetail.class); }); }); List<Tag> tags = articleTagService.findTags(a.getId()); a.setTags(tags); return a; }