SpringBoot联表查询ES门店和商品索引，分页排序返回门店商品集合

在Spring Boot环境下，可以使用RestHighLevelClient来查询Elasticsearch中的门店索引和商品索引，并按照门店位置进行排序。以下是一个示例代码：\n\njava\nimport org.elasticsearch.action.search.SearchRequest;\nimport org.elasticsearch.action.search.SearchResponse;\nimport org.elasticsearch.client.RequestOptions;\nimport org.elasticsearch.client.RestHighLevelClient;\nimport org.elasticsearch.index.query.BoolQueryBuilder;\nimport org.elasticsearch.index.query.QueryBuilders;\nimport org.elasticsearch.search.builder.SearchSourceBuilder;\nimport org.elasticsearch.search.sort.GeoDistanceSortBuilder;\nimport org.elasticsearch.search.sort.SortOrder;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.stereotype.Service;\n\n@Service\npublic class StoreProductService {\n \n @Autowired\n private RestHighLevelClient client;\n \n public List<StoreProduct> searchStoreProductsByMerchantId(String merchantId, int page, int size) throws IOException {\n SearchRequest searchRequest = new SearchRequest("store_index");\n SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();\n BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();\n \n // 添加商户id过滤条件\n boolQueryBuilder.must(QueryBuilders.termQuery("merchantId", merchantId));\n searchSourceBuilder.query(boolQueryBuilder);\n \n // 设置分页\n searchSourceBuilder.from((page - 1) * size);\n searchSourceBuilder.size(size);\n \n // 添加排序，按门店位置进行排序\n GeoDistanceSortBuilder sortBuilder = new GeoDistanceSortBuilder("location", 40, 50);\n sortBuilder.order(SortOrder.ASC);\n searchSourceBuilder.sort(sortBuilder);\n \n searchRequest.source(searchSourceBuilder);\n \n SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);\n \n // 解析搜索结果并返回门店商品集合\n // ...\n }\n}\n\n\n上述代码中，我们使用RestHighLevelClient来创建一个搜索请求SearchRequest，并构建搜索条件SearchSourceBuilder。在搜索条件中，我们使用BoolQueryBuilder来添加商户id的过滤条件，并设置分页和排序规则。最后，通过调用client.search方法执行搜索请求，并解析搜索结果进行返回。\n\n请注意，上述代码只是一个示例，具体的解析搜索结果和返回门店商品集合的逻辑需要根据实际情况进行实现。