From 653566dd3199a36fcff30ea9b9f31087e59ce3ed Mon Sep 17 00:00:00 2001
From: Jack <jack.su@pollex.com.tw>
Date: 星期四, 25 十一月 2021 21:32:39 +0800
Subject: [PATCH] [UPDATE] 新增重複帳號註冊的檢核,直接拋出500的錯誤訊息 [UPDATE] 調整dev設定檔(auto-commit=false),解決mvnw jdbc連線失敗的問題

---
 pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java |    6 +++---
 1 files changed, 3 insertions(+), 3 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 986591e..0fdb98e 100644
--- a/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java
+++ b/pamapi/src/main/java/com/pollex/pam/service/ConsultantQuerySpec.java
@@ -34,12 +34,12 @@
                 }
 
                 if(Objects.nonNull(param.getAvgScore()) && param.getAvgScore().intValue() != 0) {
-                    set.add(criteriaBuilder.between(root.get("avgScore"), param.getAvgScore().intValue() - 1, param.getAvgScore().intValue() + 1));
+                    set.add(criteriaBuilder.equal(root.get("avgScore"), param.getAvgScore()));
                 }
 
                 Predicate[] predicates = new Predicate[set.size()];
                 predicates = set.toArray(predicates);
-                return criteriaBuilder.or(predicates);
+                return criteriaBuilder.and(predicates);
             }
         };
     }
@@ -58,7 +58,7 @@
                 }
 
                 if(Objects.nonNull(param.getAvgScore()) && param.getAvgScore().intValue() != 0) {
-                    set.add(criteriaBuilder.between(root.get("avgScore"), param.getAvgScore().intValue() - 1, param.getAvgScore().intValue() + 1));
+                    set.add(criteriaBuilder.equal(root.get("avgScore"), param.getAvgScore()));
                 }
 
                 if(StringUtils.isNotEmpty(param.getArea())) {

--
Gitblit v1.8.0