From 2f0789c087589a053f6c80e3bfb17b0a4c2c4514 Mon Sep 17 00:00:00 2001 From: Jack <jack.su@pollex.com.tw> Date: 星期三, 01 十二月 2021 17:54:30 +0800 Subject: [PATCH] Merge branch 'master' of ssh://192.168.0.10:29418/pcalife/PAM --- 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..dda2ade 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.consts.SeniorityQueryConst.*; + 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(StringUtils.isNotEmpty(param.getSeniority()) && !StringUtils.equals(UNLIMITED, param.getSeniority())) { + if(YOUNG.equals(param.getSeniority())) { + set.add(criteriaBuilder.lessThanOrEqualTo(root.get("seniorityYear"), 5)); + } + else if(SENIOR.equals(param.getSeniority())) { + set.add(criteriaBuilder.greaterThan(root.get("seniorityYear"), 5)); + } } if(StringUtils.isNotEmpty(param.getArea())) { -- Gitblit v1.8.0