Yii的Where条件

#标准写法

$stat_book_list = BookSaleChangeLog::find()
->select( [ 'book_id','SUM(quantity) AS total_count','SUM(price) AS total_pay_money' ] )
->andWhere([  'between','created_time',$time_start,$time_end ])
->groupBy('book_id')->asArray()->all();


$query = Project::find()
            ->where(['dept_id'=>$dept_id])
            ->all();

#写完之后一定要加上one()或者是all()


#对比
['>', 'id', 1]                                        // 生成：id > 1
['<', 'id', 100]                                      // 生成：id < 100
['=', 'id', 10]                                       // 生成：id = 10
['>=', 'id', 1]                                       // 生成：id >= 1
['<=', 'id', 100]                                     // 生成：id <= 100
['!=', 'id', 10]                                      // 生成：id != 10
 
#并联
['and', 'id' => 1, 'id' => 2]                        // 生成：id=1 AND id=2
['and', 'id=1', 'id=2']                              // 生成：id=1 AND id=2
['and', 'type=1', ['or', 'id=1', 'id=2']]            // 生成：type=1 AND (id=1 OR id=2)
 
#OR
['or', ['type' => [7, 8, 9]], ['id' => [1, 2, 3]]]   
// 生成：(type IN (7, 8, 9) OR (id IN (1, 2, 3)))

#NOT
['not', ['attribute' => null]]                       // 生成：NOT (attribute IS NULL)
 
#between
['between', 'id', 1, 10]                             // 生成：id BETWEEN 1 AND 10
['not between', 'id', 1, 10]                         // 生成：id NOT BETWEEN 1 AND 10
 
#IN
['in', 'id', [1, 2, 3]]                               // 生成：id IN (1, 2, 3)
['id' => [4, 8, 15]]								  // 生成：id IN (4, 8, 15)
['not in', 'id', [1, 2, 3]]                           // 生成：id NOT IN (1, 2, 3)
['in', ['id', 'name'], [['id' => 1, 'name' => 'foo'], ['id' => 2, 'name' => 'bar']]]  
// 生成：(`id`, `name`) IN ((1, 'foo'), (2, 'bar'))
 
#子查询
#用子查询作为IN条件的值
['in', 'user_id', (new Query())->select('id')->from('users')->where(['active' => 1])]
 
#模糊查询
['like', 'name', 'tester']                             
// 生成：name LIKE '%tester%'

['like', 'name', ['test', 'sample']]                   
// 生成：name LIKE '%test%' AND name LIKE '%sample%'

['like', 'name', '%tester', false]                     
// 生成：name LIKE '%tester' 这是自定义查询方式，要传入值为false的运算数3，并且自行添加%

['or like', 'name', ['test', 'sample']]                 
// 生成：name LIKE '%test%' OR name LIKE '%sample%'

['not like', 'name', 'tester']                          
// 生成：name NOT LIKE '%tester%'

['or not like', 'name', ['test', 'sample']]             
// 生成：name NOT LIKE '%test%' OR name NOT LIKE '%sample%'
 
['exists', (new Query())->select('id')->from('users')->where(['active' => 1])] 
// 生成：EXISTS (SELECT "id" FROM "users" WHERE "active"=1)