Spring Data MongoDB中结合文本搜索与排序的实践指南

// WarrantyModel.java
import org.springframework.data.annotation.Id;
import org.springframework.data.mongodb.core.index.TextIndexed;
import org.springframework.data.mongodb.core.mapping.Document;
import org.springframework.stereotype.Component;
import java.time.LocalDate;

@Component
@Document("Warranty")
public class WarrantyModel {

    @Id
    public String id;

    @TextIndexed
    public String car;
    @TextIndexed
    public String part;
    public String store;
    @TextIndexed
    public String partNumber;
    public String warranty;
    public LocalDate date; // 用于排序的日期字段

    // Constructors, getters, and setters...
}

// WarrantiesRepository.java
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.mongodb.repository.MongoRepository;
import org.springframework.data.mongodb.repository.Query;
import org.springframework.stereotype.Repository;

@Repository
public interface WarrantiesRepository extends MongoRepository<WarrantyModel, String> {

    // 1. 派生查询方法：不带搜索条件时，按日期降序排序并分页
    public Page<WarrantyModel> findAllByOrderByDateDesc(PageRequest pageRequest);

    // 2. 自定义查询方法：进行文本搜索，并明确指定按日期降序排序
    // value 属性定义了文本搜索条件
    // sort 属性定义了排序规则：{'date': -1} 表示按date字段降序
    @Query(value = "{$text: {$search: ?0}}", sort = "{'date': -1}")
    public Page<WarrantyModel> findAllByOrderByDateDesc(String search, PageRequest pageRequest);

    // ... 其他方法，例如按ID、汽车、部件、部件号查询
    public WarrantyModel getWarrantyById(String id);
    public WarrantyModel getWarrantyByCar(String car);
    public WarrantyModel getWarrantyByPart(String part);
    public WarrantyModel getWarrantyBypartNumber(String partNumber);
}

// Controller
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.servlet.ModelAndView;

@Controller
public class WarrantyController {

    private final WarrantiesRepository warrantiesRepository;
    private int currentPage = 0; // 示例分页参数
    private int pageSize = 10;   // 示例分页参数

    public WarrantyController(WarrantiesRepository warrantiesRepository) {
        this.warrantiesRepository = warrantiesRepository;
    }

    @PostMapping("/warranties/search")
    public ModelAndView getLiveWarranties(@RequestBody String search, Model model) {
        // 假设search是带引号的字符串，需要去除引号
        String input = search.substring(1, search.length() - 1);
        Page<WarrantyModel> warranties;
        PageRequest pageRequest = PageRequest.of(currentPage, pageSize);

        // 根据搜索输入是否为空来决定调用哪个Repository方法
        if (input.isEmpty()) { // 更准确的判断是否为空
            warranties = warrantiesRepository.findAllByOrderByDateDesc(pageRequest);
        } else {
            // 调用带有文本搜索和排序的Repository方法
            warranties = warrantiesRepository.findAllByOrderByDateDesc(input, pageRequest);
        }

        ModelAndView mv = new ModelAndView("warranties::search");
        mv.addObject("warranties", warranties);
        return mv;
    }
}