Yii 2.0 andFilterWhere null auto ignore

In Yii 2.0's search() function, if try use andFilterWhere and null together, the generated SQL will auto skip the null one, this topic show how to fix it.

Yii 2.0 use andWhere() Do and or query

In Yii 2.0 Framework, use andWhere() function run DB(MySQL) Query like A = 1 or B = 1