/** * Append Custom Quick Filter */ protected void appendCustomQuickFilter(StringBuilder hql, Map<String, Object> params, QuickFilter filter) { if (filter.hasFilter()) { hql.append(" AND ( upper(p.description) like upper(:filter) "); hql.append(" OR upper(processDefinitionEntity.name) like upper(:filter) "); hql.append(" OR upper(task.name) like upper(:filter) "); if (filter.isRascunho()) { hql.append(" OR ").append(JPAQueryUtil.formattDateTimeClause("currentFormVersion.inclusionDate", "filter")); hql.append(" OR ").append(JPAQueryUtil.formattDateTimeClause("currentDraftEntity.editionDate", "filter")); } else { hql.append(" OR ").append(JPAQueryUtil.formattDateTimeClause("ta.beginDate", "filter")); hql.append(" OR ").append(JPAQueryUtil.formattDateTimeClause("pie.beginDate", "filter")); } hql.append(" OR p.id like :filter ) "); params.put("filter", "%" + filter.getFilter() + "%"); } }
params.put("sim", SimNao.SIM); if (!filtro.isRascunho() && siglasProcesso != null && !siglasProcesso.isEmpty()) { hql.append(" AND ( processDefinitionEntity.key in (:siglasProcesso) "); params.put("siglasProcesso", siglasProcesso); if (filtro.isRascunho()) { hql.append(" AND p.processInstanceEntity is null "); } else {
private void appendSort(StringBuilder hql, QuickFilter filtro, boolean count) { if (filtro.getSortProperty() != null) { hql.append(mountSort(filtro.getSortProperty(), filtro.isAscending())); } else if (!count) { if (filtro.isRascunho()) { hql.append(mountSort("creationDate", false)); } else { hql.append(mountSort("processBeginDate", false)); } } }
private void appendFilterByFlowDefinitionAbbreviation() { if (!quickFilter.isRascunho() && quickFilter.getProcessesAbbreviation() != null && !quickFilter.getProcessesAbbreviation().isEmpty()) { BooleanExpression expr = $.flowDefinitionEntity.key.in(quickFilter.getProcessesAbbreviation()); if (quickFilter.getTypesNames() != null && !quickFilter.getTypesNames().isEmpty()) { expr = expr.or($.formType.abbreviation.in(quickFilter.getTypesNames())); } whereClause.and(expr); } }
@Nonnull private void appendWhere() { appendFilterByApplicant(); appendFilterByFlowDefinitionAbbreviation(); appendFilterByQuickFilter(); appendFilterByTasks(); if (quickFilter.isRascunho()) { appendFilterByRequirementsWithoutFlowInstance(); } else { appendFilterByRequirementsWithFlowInstance(); appendFilterByCurrentTask(); } }
private void configure(Session session) { query = new RequirementSearchQuery(session); $ = ctx.getAliases(); quickFilter = ctx.getQuickFilter(); whereClause = query.getWhereClause(); ctx.setQuery(query); if (quickFilter.isRascunho()) { query.setDefaultOrder(new OrderSpecifier<>(Order.ASC, Expressions.stringPath("creationDate"))); } else { query.setDefaultOrder(new OrderSpecifier<>(Order.ASC, Expressions.stringPath("processBeginDate"))); } }