Skip to content

Instantly share code, notes, and snippets.

@MasterHans
Created August 28, 2021 10:28
Show Gist options
  • Save MasterHans/a22fc543eba7c691464b6793effc455c to your computer and use it in GitHub Desktop.
Save MasterHans/a22fc543eba7c691464b6793effc455c to your computer and use it in GitHub Desktop.
Получить записи из модели по кретериям
$criteria = new CDbCriteria();
$criteria->select = 't.id, t.email';
$criteria->order = 't.created_at';
$criteria->condition = "t.status in (:s1, :s2) AND t.created_at >= :f AND t.created_at <= :u";
$criteria->params = [
':s1' => Users::STATUS_VERIFIED_INCOMPLETE,
':s2' => Users::STATUS_VERIFIED_COMPLETE,
':f' => $date->format('Y-m-d 00:00:00'),
':u' => $date->format('Y-m-d 23:59:59'),
];
return Users::model()->findAll($criteria);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment