feat：问答增加排序

龚焕茏

2024-05-29 e97b734831482ccc56ef2457c8cde9892d16d7f9

feat：问答增加排序

 src/main/java/com/mindskip/xzs/controller/admin/QuestionAnswerController.java

@@ -73,4 +73,9 @@
        return RestResponse.ok("操作成功");
    }

    @GetMapping("getLastSequence")
    public RestResponse<Integer> getLastSequence() {
        return RestResponse.ok(questionAnswerService.getLastSequence());
    }

}

 src/main/java/com/mindskip/xzs/domain/QuestionAnswer.java

@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.annotation.TableName;
import com.mindskip.xzs.domain.enums.QuestionAnswerStatusEnum;
import lombok.Data;
import lombok.experimental.Accessors;

import java.io.Serializable;

@@ -15,6 +16,7 @@
 */
@TableName(value = "t_question_answer")
@Data
@Accessors(chain = true)
public class QuestionAnswer implements Serializable {

    @TableId(type = IdType.AUTO)
@@ -28,6 +30,8 @@

    private QuestionAnswerStatusEnum status;

    private Integer sequence;

    @TableLogic
    private Boolean deleted;


 src/main/java/com/mindskip/xzs/domain/vo/QuestionAnswerVO.java

@@ -25,6 +25,8 @@

    private QuestionAnswerStatusEnum status;

    private Integer sequence;

    private Boolean deleted;

    private static final long serialVersionUID = 1L;

 src/main/java/com/mindskip/xzs/service/QuestionAnswerService.java

@@ -16,4 +16,5 @@

    void updateStatus(Integer id);

    Integer getLastSequence();
}

 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;
    }

}