Examples with BooleanBuilder com.querydsl.core.BooleanBuilder used on opensource projects

Example 21 with BooleanBuilder

use of com.querydsl.core.BooleanBuilder in project spring-data-commons by spring-projects.

the class QuerydslDefaultBinding method bind.

/*
	 * (non-Javadoc)
	 * @see org.springframework.data.web.querydsl.QueryDslPredicateBuilder#buildPredicate(org.springframework.data.mapping.PropertyPath, java.lang.Object)
	 */
@Override
@SuppressWarnings({ "unchecked", "rawtypes" })
public Optional<Predicate> bind(Path<?> path, Collection<? extends Object> value) {
    Assert.notNull(path, "Path must not be null!");
    Assert.notNull(value, "Value must not be null!");
    if (value.isEmpty()) {
        return Optional.empty();
    }
    if (path instanceof CollectionPathBase) {
        BooleanBuilder builder = new BooleanBuilder();
        for (Object element : value) {
            builder.and(((CollectionPathBase) path).contains(element));
        }
        return Optional.of(builder.getValue());
    }
    if (path instanceof SimpleExpression) {
        if (value.size() > 1) {
            return Optional.of(((SimpleExpression) path).in(value));
        }
        return Optional.of(((SimpleExpression) path).eq(value.iterator().next()));
    }
    throw new IllegalArgumentException(String.format("Cannot create predicate for path '%s' with type '%s'.", path, path.getMetadata().getPathType()));
}

Example 22 with BooleanBuilder

use of com.querydsl.core.BooleanBuilder in project hse-cws by holuhoev.

the class FacultyDatasource method getFacultyFilter.

public DataSourceResult getFacultyFilter(final Integer instituteId, final String name) {
    QFaculty qFaculty = QFaculty.faculty;
    BooleanBuilder builder = new BooleanBuilder();
    if (instituteId != null) {
        builder.and(qFaculty.instituteId.eq(instituteId));
    }
    if (name != null && !name.isEmpty()) {
        builder.and(qFaculty.name.containsIgnoreCase(name));
    }
    Sort sort = new Sort(Sort.Direction.ASC, "name");
    Iterable<Faculty> faculties = facultyRepository.findAll(builder, sort);
    return DataSourceResult.create(faculties);
}

Example 23 with BooleanBuilder

use of com.querydsl.core.BooleanBuilder in project hse-cws by holuhoev.

the class GroupDatasource method getGroupFilter.

public DataSourceResult getGroupFilter(final Integer facultyId, final Integer instituteId, final Course course, final String number, final EducationType educationType) {
    QGroup qGroup = QGroup.group;
    BooleanBuilder builder = new BooleanBuilder();
    if (facultyId != null) {
        builder.and(qGroup.facultyId.eq(facultyId));
    }
    if (instituteId != null) {
        builder.and(qGroup.instituteId.eq(instituteId));
    }
    if (course != null) {
        builder.and(qGroup.course.eq(course));
    }
    if (number != null) {
        builder.and(qGroup.number.containsIgnoreCase(number));
    }
    if (educationType != null) {
        builder.and(qGroup.educationType.eq(educationType));
    }
    Sort sort = new Sort(Sort.Direction.ASC, "course", "number");
    Iterable<Group> groups = groupRepository.findAll(builder, sort);
    return DataSourceResult.create(groups, new HashMap<>());
}

Example 24 with BooleanBuilder

use of com.querydsl.core.BooleanBuilder in project hse-cws by holuhoev.

the class LecturerWorkloadDatasource method getLecturerSumWorkload.

public DataSourceResult getLecturerSumWorkload(final Integer chairId, final String fio, final LocalDate fromDate, final LocalDate toDate, final Integer top, final Integer skip, final Boolean fetchTotal) {
    QLecturer qLecturer = QLecturer.lecturer;
    QLecturerWorkload qLecturerWorkload = QLecturerWorkload.lecturerWorkload;
    BooleanBuilder lecturerBuilder = new BooleanBuilder();
    BooleanBuilder workloadBuilder = new BooleanBuilder();
    if (chairId != null) {
        lecturerBuilder.and(qLecturer.chairId.eq(chairId));
    }
    if (fio != null && !fio.isEmpty()) {
        lecturerBuilder.and(qLecturer.fio.containsIgnoreCase(fio));
    }
    if (fromDate != null) {
        workloadBuilder.and(qLecturerWorkload.date.after(fromDate));
    }
    if (toDate != null) {
        workloadBuilder.and(qLecturerWorkload.date.before(toDate));
    }
    Iterable<Lecturer> lecturers;
    if (top != null) {
        String orderByString = "fio";
        Pageable limit = PageRequest.of(skip, top, Sort.Direction.ASC, orderByString);
        lecturers = lecturerRepository.findAll(lecturerBuilder, limit);
    } else {
        lecturers = lecturerRepository.findAll(lecturerBuilder);
    }
    List<LecturerSumWorkload> result = StreamSupport.stream(lecturers.spliterator(), false).map(lecturer -> {
        BooleanBuilder builder = new BooleanBuilder();
        builder.and(workloadBuilder).and(qLecturerWorkload.lecturerId.eq(lecturer.getId()));
        Integer workload = StreamSupport.stream(lecturerWorkloadRepository.findAll(builder).spliterator(), false).mapToInt(LecturerWorkload::getWorkload).sum();
        return new LecturerSumWorkload(lecturer.getFio(), workload, lecturer.getId());
    }).collect(Collectors.toList());
    Map<String, Object> hints = new HashMap<>();
    hints.put("paging", true);
    if (fetchTotal != null && fetchTotal) {
        Long count = lecturerWorkloadRepository.count(lecturerBuilder);
        hints.put("total", count);
    }
    return DataSourceResult.create(result, hints);
}

Example 25 with BooleanBuilder

use of com.querydsl.core.BooleanBuilder in project kylo by Teradata.

the class JpaBatchJobExecutionProvider method getJobStatusCount.

/**
 * Get count of Jobs grouped by Status
 * Streaming Feeds are given a count of 1 if they are running, regardless of the number of active running flows
 */
@Override
public List<JobStatusCount> getJobStatusCount(String filter) {
    QJpaBatchJobExecution jobExecution = QJpaBatchJobExecution.jpaBatchJobExecution;
    QJpaBatchJobInstance jobInstance = QJpaBatchJobInstance.jpaBatchJobInstance;
    QJpaOpsManagerFeed feed = QJpaOpsManagerFeed.jpaOpsManagerFeed;
    BooleanBuilder whereBuilder = new BooleanBuilder();
    if (StringUtils.isNotBlank(filter)) {
        whereBuilder.and(GenericQueryDslFilter.buildFilter(jobExecution, filter));
    }
    ConstructorExpression<JpaBatchJobExecutionStatusCounts> expr = Projections.constructor(JpaBatchJobExecutionStatusCounts.class, JobStatusDslQueryExpressionBuilder.jobState().as("status"), jobExecution.jobExecutionId.count().as("count"));
    JPAQuery<?> query = factory.select(expr).from(jobExecution).innerJoin(jobInstance).on(jobExecution.jobInstance.jobInstanceId.eq(jobInstance.jobInstanceId)).innerJoin(feed).on(jobInstance.feed.id.eq(feed.id)).where(whereBuilder.and(feed.isStream.eq(false)).and(FeedAclIndexQueryAugmentor.generateExistsExpression(feed.id, controller.isEntityAccessControlled()))).groupBy(jobExecution.status);
    List<JobStatusCount> stats = (List<JobStatusCount>) query.fetch();
    // merge in streaming feed stats
    List<? extends NifiFeedStats> streamingFeedStats = feedStatisticsProvider.findFeedStats(true);
    if (streamingFeedStats != null) {
        if (stats == null) {
            stats = new ArrayList<>();
        }
        Long runningCount = streamingFeedStats.stream().filter(s -> s.getRunningFeedFlows() > 0L).count();
        if (runningCount > 0) {
            JobStatusCount runningStatusCount = stats.stream().filter(s -> s.getStatus().equalsIgnoreCase(BatchJobExecution.RUNNING_DISPLAY_STATUS)).findFirst().orElse(null);
            if (runningStatusCount != null) {
                runningCount = runningStatusCount.getCount() + runningCount;
                runningStatusCount.setCount(runningCount);
            } else {
                JpaBatchJobExecutionStatusCounts runningStreamingFeedCounts = new JpaBatchJobExecutionStatusCounts();
                runningStreamingFeedCounts.setCount(runningCount);
                runningStreamingFeedCounts.setStatus(BatchJobExecution.RUNNING_DISPLAY_STATUS);
                stats.add(runningStreamingFeedCounts);
            }
        }
    }
    return stats;
}