yii2.0 中数据查询中 or、in、between 及session的使用

HTML：

<div>
    <form class="form-inline " method="get" action="<?=Url::to(['companylist']);?>">
        <div class="form-group">
            <input type="text" name="name" style="width: 80%; display:inline;" class="form-control input-sm" placeholder="配电室编号 或 配电室名称" value="<?=$_GET['name'];?>">
            <button type="submit" style="float: right" class="btn btn-primary btn-sm">查询</button>
        </div>
    </form>
</div> 
控制器的查询条件：
$data = Concentrator::find()->andWhere(['in', 'id', $cIds]);
if ($_GET['name']) {
    $data->andWhere(['or', ['like', 'number', $_GET['name']], ['like', 'name', $_GET['name']]]);
}
//in
$data->andWhere(['in', 'state', [1, 2, 3]]);
//between
$data->andFilterWhere(['between', 'create_time', $start_date, $end_date]);
$rowset = $data->all();
 echo $data->createCommand()->getRawSql(); //输出sql语句

 

['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)

['between', 'id', 1, 10] //id BETWEEN 1 AND 10

['not between', 'id', 1, 10] //not id BETWEEN 1 AND 10

['in', 'id', [1, 2, 3]] //id IN (1, 2, 3)

['not in', 'id', [1, 2, 3]] //not id IN (1, 2, 3)

['like', 'name', 'tester'] //name LIKE '%tester%'

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

['not like', 'name', ['or', 'test', 'sample']] //not name LIKE '%test%' OR not name LIKE '%sample%'

['like', 'name', '%tester', false] // name LIKE '%tester'

['exists','id', $userQuery] //EXISTS (sub-query) | not exists

['>', 'age', 10] //age>10
where(['<>','id',10])  //不等于

 

session:
$session = Yii::$app->session;
$session['user'] = [
    'id' => 1,
    'username' => 'yiiuser',
];
echo $session['user']['id'];
echo $session['user']['username'];