krot

yii2 andFilterWhere

Apr 5th, 2018
103
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.             //$hSQL->andFilterWhere(['like', '[fo].name', Yii::$app->request->get('filter')['name']])
  2.             $hSQL->andFilterWhere(['like', '[fo].name', Yii::$app->request->get('filter')['name'].'%',false])
  3.             //->where(['like', 'user', $this->username );
  4. $hSQL->andWhere(         
  5.             'CONVERT(DATE,[p].date_load)=
  6.             CONVERT(DATE,\''.Yii::$app->request->get('filter')['date_load'].'\')'
  7.             );
RAW Paste Data