From 40ba87b958d3b53f2eef4f95eb3add6548f35006 Mon Sep 17 00:00:00 2001 From: wayne <wayne8692wayne8692@gmail.com> Date: 星期五, 03 十二月 2021 11:18:48 +0800 Subject: [PATCH] [update] 我的顧問清單新增預約單歷史明細、預約單的更新API、預約單的邏輯刪除API --- 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