From e97b734831482ccc56ef2457c8cde9892d16d7f9 Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期三, 29 五月 2024 11:58:29 +0800
Subject: [PATCH] feat：问答增加排序
---
src/main/java/com/mindskip/xzs/service/impl/QuestionAnswerServiceImpl.java | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/service/impl/QuestionAnswerServiceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/QuestionAnswerServiceImpl.java
index 0694389..3d4c38d 100644
--- a/src/main/java/com/mindskip/xzs/service/impl/QuestionAnswerServiceImpl.java
+++ b/src/main/java/com/mindskip/xzs/service/impl/QuestionAnswerServiceImpl.java
@@ -15,6 +15,7 @@
import org.springframework.util.StringUtils;
import java.util.List;
+import java.util.Objects;
/**
* @author gonghl
@@ -41,7 +42,7 @@
new LambdaQueryChainWrapper<>(questionAnswerMapper)
.like(StringUtils.hasText(questionAnswerVO.getQuestion()), QuestionAnswer::getQuestion, questionAnswerVO.getQuestion())
.or(StringUtils.hasText(questionAnswerVO.getQuestion()), wrapper -> wrapper.like(QuestionAnswer::getAnswer, questionAnswerVO.getQuestion()))
- .orderByDesc(QuestionAnswer::getId)
+ .orderByAsc(QuestionAnswer::getSequence)
.list());
}
@@ -49,8 +50,20 @@
public List<QuestionAnswer> list() {
return new LambdaQueryChainWrapper<>(questionAnswerMapper)
.eq(QuestionAnswer::getStatus, QuestionAnswerStatusEnum.ENABLE.getCode())
+ .orderByAsc(QuestionAnswer::getSequence)
.list();
}
+
+
+ @Override
+ public Integer getLastSequence() {
+ QuestionAnswer one = new LambdaQueryChainWrapper<>(questionAnswerMapper)
+ .orderByDesc(QuestionAnswer::getSequence)
+ .last("limit 1")
+ .one();
+ return Objects.isNull(one) ? 1 : one.getSequence() + 1;
+ }
+
}
--
Gitblit v1.8.0