| | |
|---|
| | | import org.apache.commons.lang3.StringUtils; |
|---|
| | | import org.springframework.data.jpa.domain.Specification; |
|---|
| | | |
|---|
| | | import javax.persistence.criteria.CriteriaBuilder; |
|---|
| | | import javax.persistence.criteria.CriteriaQuery; |
|---|
| | | import javax.persistence.criteria.Predicate; |
|---|
| | | import javax.persistence.criteria.Root; |
|---|
| | | import javax.persistence.criteria.*; |
|---|
| | | import java.util.*; |
|---|
| | | |
|---|
| | | public class ConsultantQuerySpec { |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | 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()]; |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | 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.getArea())) { |
|---|
| | | set.add(criteriaBuilder.like(root.get("serveArea"), "%" + param.getArea() + "%")); |
|---|
| | | Predicate predicate1 = criteriaBuilder.like(root.get("serveArea"), "%" + param.getArea() + "%"); |
|---|
| | | Predicate predicate2 = criteriaBuilder.like(root.get("serveArea"), "%全台%"); |
|---|
| | | |
|---|
| | | Predicate finalPredicate = criteriaBuilder.or(predicate1, predicate2); |
|---|
| | | set.add(finalPredicate); |
|---|
| | | } |
|---|
| | | |
|---|
| | | List<String> allRequirements = Objects.nonNull(param.getRequirements()) ? param.getRequirements() : new ArrayList<>(); |
|---|
