查询多个状态随意组合

最新推荐文章于 2023-07-20 12:24:19 发布

请叫我靓仔丶

最新推荐文章于 2023-07-20 12:24:19 发布

阅读量180

点赞数

分类专栏：日常记录文章标签： java

本文链接：https://blog.csdn.net/github_39019743/article/details/120191849

版权

日常记录专栏收录该内容

24 篇文章 0 订阅

订阅专栏

		List<Object> list = new ArrayList<>();
        BoolQueryBuilder search = getBoolQueryBuilder(games);

        SearchResponse searchRequestBuilder = client.prepareSearch("game_index")
                .setTypes("test")
                .setQuery(search)
                .setFrom(searchRequest.getPageNumber() - 1).setSize(searchRequest.getPageSize()).setExplain(true)
                .get();

        SearchHits searchHits = searchRequestBuilder.getHits();
        for (SearchHit searchHit : searchHits) {
            list.add(JSON.parseObject(searchHit.getSourceAsString()).get("id").toString());
        }

  /**
     * 提取的搜索条件吧。。。。。
     *
     * @param games
     * @return
     */
    private BoolQueryBuilder getBoolQueryBuilder(TbGames games) {
        return QueryBuilders.boolQuery()
                .must(gameUtils.getStatus(Integer.parseInt(games.getStatus())))
                .must(QueryBuilders.matchQuery("gameName", gameUtils.checkWord(games.getGameName())).boost(5));
    }

public class GameUtils {


    /**
     * 状态,0:有效,1:升级中,2:测试,3:禁止推广,4:无效,5:预约。
     */
    public static final int STATUS_ZERO = 1;
    public static final int STATUS_ONE = STATUS_ZERO << 1;
    public static final int STATUS_TWO = STATUS_ZERO << 2;
    public static final int STATUS_THREE = STATUS_ZERO << 3;
    public static final int STATUS_FOUR = STATUS_ZERO << 4;
    public static final int STATUS_FIVE = STATUS_ZERO << 5;
    public static final int STATUS_SIX = STATUS_ZERO << 6;


    /**
     * 游戏状态吧....
     *
     * @param status
     */
    public BoolQueryBuilder getStatus(int status) {

        BoolQueryBuilder queryBuilder = QueryBuilders.boolQuery();

        // 状态,0:有效,1:升级中,2:测试,3:禁止推广,4:无效,5:预约。
        if ((status & STATUS_ZERO) == STATUS_ZERO) {
            queryBuilder.should(QueryBuilders.termQuery("status", 0));
        }
        if ((status & STATUS_ONE) == STATUS_ONE) {
            queryBuilder.should(QueryBuilders.termQuery("status", 1));
        }
        if ((status & STATUS_TWO) == STATUS_TWO) {
            queryBuilder.should(QueryBuilders.termQuery("status", 2));
        }
        if ((status & STATUS_THREE) == STATUS_THREE) {
            queryBuilder.should(QueryBuilders.termQuery("status", 3));
        }
        if ((status & STATUS_FOUR) == STATUS_FOUR) {
            queryBuilder.should(QueryBuilders.termQuery("status", 4));
        }
        if ((status & STATUS_FIVE) == STATUS_FIVE) {
            queryBuilder.should(QueryBuilders.termQuery("status", 5));
        }
        if ((status & STATUS_SIX) == STATUS_SIX) {
            queryBuilder.should(QueryBuilders.termQuery("status", 6));
        }
        return queryBuilder;
    }
}