From 4df02e3b839a30ff2c68243820b48734f585baa1 Mon Sep 17 00:00:00 2001
From: wayne <wayne8692wayne8692@gmail.com>
Date: 星期二, 01 三月 2022 14:29:49 +0800
Subject: [PATCH] [update] [todo 136030] 調整滿意度篩選的機制，改由指定分數扣0.5分作為查詢
---
pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java | 3 ++-
1 files changed, 2 insertions(+), 1 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 cc9d20d..b9cba74 100644
--- a/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java
+++ b/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java
@@ -20,6 +20,7 @@
return new Specification<Consultant>() {
@SuppressWarnings("FieldNameHidesFieldInSuperclass")
private static final long serialVersionUID = 6644524130903161741L;
+ private static final float QUERY_AVG_SCORE_OFFSET = 0.5f;
@Override
public Predicate toPredicate(Root<Consultant> root, CriteriaQuery<?> query, CriteriaBuilder criteriaBuilder) {
@@ -36,7 +37,7 @@
}
if(Objects.nonNull(param.getAvgScore()) && param.getAvgScore().intValue() != 0) {
- set.add(criteriaBuilder.greaterThanOrEqualTo(root.get("avgScore"), param.getAvgScore().intValue()));
+ set.add(criteriaBuilder.greaterThanOrEqualTo(root.get("avgScore"), param.getAvgScore().intValue() - QUERY_AVG_SCORE_OFFSET));
}
if(StringUtils.isNotEmpty(param.getSeniority()) && !StringUtils.equals(UNLIMITED, param.getSeniority())) {
--
Gitblit v1.8.0