elasticsearch实战-复合查询（复杂sql的es转换实现）

最新推荐文章于 2024-08-30 16:23:11 发布

碧海潮声吹玉箫

最新推荐文章于 2024-08-30 16:23:11 发布

阅读量3.4k

点赞数 1

分类专栏：实战文章标签： elasticsearch java

本文链接：https://blog.csdn.net/lmx1989219/article/details/104050264

版权

实战专栏收录该内容

15 篇文章 2 订阅

订阅专栏

海量订单数据用搜索引擎来实现检索

基础篇请查看这里

demo展示了bool查询构建的嵌套查询，涉及and/or/between/limit等

单纯的过滤建议使用filter方法，must也可以只不过性能略低（需要计算打分）。


    public PageResponse<List<OrderNewDto>> getOrderNewList(OrderQryReq searchOrgReq) {
        String keyword = searchOrgReq.getKeyword().toLowerCase();
        BoolQueryBuilder conditionQueryBuilder = QueryBuilders.boolQuery();
        //兼容空格输入多个关键字的检索
        Iterator<String> kws = Splitter.on(" ").split(keyword).iterator();
        while (kws.hasNext()) {
            String kw = kws.next().trim();
            BoolQueryBuilder keywordQueryBuilder = QueryBuilders.boolQuery();
            //构建关键字查询
            keywordQueryBuilder.should(QueryBuilders.prefixQuery("order_no", kw));
            keywordQueryBuilder.should(QueryBuilders.prefixQuery("order_code", kw));
            keywordQueryBuilder.should(QueryBuilders.termQuery("username.pinyin", kw));
            keywordQueryBuilder.should(QueryBuilders.prefixQuery("username.pinyin", kw));
            keywordQueryBuilder.should(QueryBuilders.termQuery("username.ik", kw));
            keywordQueryBuilder.should(QueryBuilders.prefixQuery("phone.keyword", kw));
            conditionQueryBuilder.must(keywordQueryBuilder);
        }
        conditionQueryBuilder.filter(QueryBuilders.termQuery("order_type", 1));
        //构建条件查询
        if (searchOrgReq.getCreateUserId() != null)
            conditionQueryBuilder.filter(QueryBuilders.termQuery("xiaosr_id", searchOrgReq.getCreateUserId()));
        if (searchOrgReq.getUserId() != null)
            conditionQueryBuilder.filter(QueryBuilders.termQuery("user_id", searchOrgReq.getUserId()));
        if (searchOrgReq.getOrderStatus() != null)
            conditionQueryBuilder.filter(QueryBuilders.termQuery("order_status", searchOrgReq.getOrderStatus()));
        if (searchOrgReq.getIsEnter() != null && searchOrgReq.getIsEnter() == 1)
            conditionQueryBuilder.filter(QueryBuilders.termQuery("payed_price", 0));
        if (searchOrgReq.getOrderStatus() != null)
            conditionQueryBuilder.filter(QueryBuilders.termQuery("order_status", searchOrgReq.getOrderStatus()));
        if (searchOrgReq.getStartTime() != null)
            conditionQueryBuilder.filter(QueryBuilders.rangeQuery("order_time").gte(LocalDateTime.parse(searchOrgReq.getStartTime(),
                    DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")).minusHours(8).toString()));
        if (searchOrgReq.getEndTime() != null)
            conditionQueryBuilder.filter(QueryBuilders.rangeQuery("order_time").lte(LocalDateTime.parse(searchOrgReq.getEndTime(),
                    DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")).minusHours(8).toString()));

        NativeSearchQuery nativeSearchQuery = new NativeSearchQuery(StringUtils.isBlank(keyword) ? QueryBuilders.matchAllQuery() : conditionQueryBuilder);
        nativeSearchQuery.addIndices("order_new");
        nativeSearchQuery.addTypes("order");
        nativeSearchQuery.setPageable(PageRequest.of(searchOrgReq.getPage(), searchOrgReq.getPageSize()));
        nativeSearchQuery.addSort(Sort.by("order_time").descending());
        SearchHits searchHits = elasticsearchTemplate.query(nativeSearchQuery, SearchResponse::getHits);
        List<OrderNewDto> categories = new ArrayList<>();
        for (SearchHit searchHit : searchHits) {
            JSONObject jsonObject = new JSONObject(searchHit.getSourceAsMap());
            categories.add(jsonObject.toJavaObject(OrderNewDto.class));
        }
        return PageResponse.<List<OrderNewDto>>builder()
                .totalSize((int) searchHits.getTotalHits())
                .currentPage(searchOrgReq.getPage())
                .pageSize(searchOrgReq.getPageSize())
                .data(categories)
                .result(ResponseCodeEnum.SUCCESS.getCode())
                .build();
    }