From 6dd264601727f2e7ae70e5caa99f137fdad6546c Mon Sep 17 00:00:00 2001 From: wayne <wayne8692wayne8692@gmail.com> Date: 星期二, 30 十一月 2021 19:45:31 +0800 Subject: [PATCH] [add] 【todo 131189】新增嚴選配對年資篩選功能 --- pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java | 15 +++++++++++++-- 1 files changed, 13 insertions(+), 2 deletions(-) diff --git a/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java b/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java index 45f936f..3163411 100644 --- a/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java +++ b/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java @@ -9,6 +9,8 @@ import javax.persistence.criteria.*; import java.util.*; +import static com.pollex.pam.enums.SeniorityQueryEnum.*; + public class ConsultantQuerySpec { private ConsultantQuerySpec() { } @@ -31,7 +33,7 @@ } if(Objects.nonNull(param.getAvgScore()) && param.getAvgScore().intValue() != 0) { - set.add(criteriaBuilder.equal(root.get("avgScore"), param.getAvgScore())); + set.add(criteriaBuilder.greaterThanOrEqualTo(root.get("avgScore"), param.getAvgScore().intValue())); } Predicate[] predicates = new Predicate[set.size()]; @@ -55,7 +57,16 @@ } if(Objects.nonNull(param.getAvgScore()) && param.getAvgScore().intValue() != 0) { - set.add(criteriaBuilder.equal(root.get("avgScore"), param.getAvgScore())); + set.add(criteriaBuilder.greaterThanOrEqualTo(root.get("avgScore"), param.getAvgScore().intValue())); + } + + if(Objects.nonNull(param.getSeniority()) && param.getSeniority() != UNLIMITED) { + if(param.getSeniority() == YOUNG) { + set.add(criteriaBuilder.lessThanOrEqualTo(root.get("seniorityYear"), 5)); + } + else if(param.getSeniority() == SENIOR) { + set.add(criteriaBuilder.greaterThan(root.get("seniorityYear"), 5)); + } } if(StringUtils.isNotEmpty(param.getArea())) { -- Gitblit v1.8.0