ThinkPHP5 WHERE AND OR 实现多条件查询

问题：ThinkPHP查询条件中包含 AND 和 OR 的条件该如何编写代码。

1、查询条件

// 基本查询条件
$where = [
    ['is_shelves',                '=', 1],
    ['is_delete_time',            '=', 0],
];

// 关键词查询
$where_keywords = [
    ['title|address|vice_title|describe', 'LIKE', '%' . $params['keyword'] . '%'],
];

// 范围查询条件
$where_range = [
    ['lng', '>=', $range['minlng']],
    ['lng', '<=', $range['maxlng']],
    ['lat', '>=', $range['minlat']],
    ['lat', '<=', $range['maxlat']],
];

2、使用ThinkPHP5进行查询

$data = Db::name('ParkApply')->field($field)
    ->where(function($query) use ($where){
        $query->where($where);
    })
    ->where(function($query) use ($where_range, $where_keywords){
        $query->where($where_keywords);
        $query->whereOr(function ($query) use($where_range) {
            $query->where($where_range);
        });
    })
    ->order($order_by)->limit($m, $n)->select();

3、生成的SQL

SELECT * FROM `s_park_apply` WHERE  (  `is_shelves` = 1  AND `is_delete_time` = 0 )  AND (  ( `title` LIKE '%银辉路%' OR `address` LIKE '%银辉路%' OR `vice_title` LIKE '%银辉路%' OR `describe` LIKE '%银辉路%' ) OR (  `lng` >= 105.4528834087  AND `lng` <= 105.4631557269  AND `lat` >= 28.89358913307  AND `lat` <= 28.90258234913 ) ) ORDER BY `id` DESC LIMIT 0,20

参考博客链接：

ThinkPHP 5.0 组合多条件whereOr查询

https://blog.csdn.net/weixin_43837229/article/details/101535227

ThinkPHP5框架where实现or查询的两种方法

https://blog.csdn.net/weixin_42330073/article/details/86496940