Skip to main content

Yii2 query / query builder: how to use OR condition

By

Yii2 query / query builder: how to use OR condition



You can use some thing like this:

$third_res_count=CustomerReservedTimeslots::find()
    ->select(['COUNT(timeslot_id) AS cnt'])
    ->where([
        'test_date' => $today_date,
        'confirmed' => '1',
    ])
    ->andWhere(['>', 'third_user_id', '0'])
    ->andFilterWhere([
        'or',
        ['like', 'status', 'checked in'],
        ['like', 'status', 'Waiting for check in'],
    ])
    ->one();

















Labels:
































































Popular posts from this blog



















yii, Executing a SQL without calling a Model












By
























 yii, Executing a SQL without calling a Model    <?  $connection = Yii :: app () -> db ; $sql  =  "SELECT id,username FROM users" ; $command  =  $connection -> createCommand ( $sql );             $dataReader = $command -> query ();           $rows = $dataReader -> readAll (); print_r ( $rows ); ?>      

























Read more




























Yii, return to previous url after login or logout












By
























 If you want to return to your previous url after login or logout try this :    <?php  $this -> redirect (Yii :: app () -> request -> urlReferrer ); ?>     To set the return url to be the url that was before the login page or registeration page was called you can put following code in views/layouts/main.php file :     <?php  //this checks id the controller action is not 'login' then it keeps the current url in returnUrl  if (CController :: getAction () -> id != 'login' ) {     Yii :: app () -> user -> setReturnUrl (Yii :: app () -> request -> getUrl ());  }  ?>    

























Read more




























Yii2 Gridview bulk action using checkbox column. How to properly create checkbox column in gridview for bulk actions












By
























 To add a CheckboxColumn to the  yii\grid\GridView , add it to the  columns  configuration as follows:  'columns'  => [      // ...      [          'class'  =>  'yii\grid\CheckboxColumn' ,          // you may configure additional properties here      ], ]        This is the view:  <?= Html :: beginForm ([ 'controller/bulk' ], 'post' );?>  <?= Html :: dropDownList ( 'action' , '' ,[ '' => 'Mark selected as: ' , 'c' => 'Confirmed' , 'nc' => 'No Confirmed' ],[ 'class' => 'dropdown' ,])?>  <?= Html :: submitButton ( 'Send' ,  [ 'class'  =>  'btn btn-info' ,]);?>  <?= GridView :: widget ([  'dataProvider'  =>  $dataProvider ,  'columns'  =>  [  [ 'class'  =>  'yii\grid\CheckboxColumn' ],  'id' ,  ],  ]);  ?>  <?=  Html :: endForm...

























Read more