es等于不等于查询

xiaopzi123123

于 2024-01-23 10:13:10 发布

阅读量764

点赞数 11

文章标签： elasticsearch

xiaopzi

本文链接：https://blog.csdn.net/nihao123456789222/article/details/135764703

版权

private function getJibingArticle($diseaseName){
        $query = new \yii\elasticsearch\Query;
        $query->from('mysql_cms_article', 'news_info');
        if ($this->isM == 0) {
            $query_arr = [
                'bool' => [
                    'must' => [ //等于
                        ['term' => ['group_name' => "health"]],
                        ['term' => ['jibing_name.keyword' => $diseaseName]],
                        ['term' => ['checked' => 2]],
                        ['term' => ['del' => 0]],
                        ['exists' => ['field' => "redirect_url.keyword"]],
                    ],
                    "must_not" => [ //不等于 category_id不等于13003185和13003186
                        ["term" => ['category_id'=>'13003185']],
                        ["term" => ['category_id'=>'13003186']],
                    ],
                ],
            ];
        } else {
            $query_arr = [
                'bool' => [
                    'must' => [
                        ['term' => ['group_name' => "health"]],
                        ['term' => ['jibing_name.keyword' => $diseaseName]],
                        ['term' => ['checked' => 2]],
                        ['term' => ['del' => 0]],
                        ['exists' => ['field' => "wap_redirect_url.keyword"]],
                    ],
                ],
            ];
        }

        $rows = $query->postFilter($query_arr)->limit(20)->orderBy(['mdt' => SORT_DESC])->all();
}