public function search($begin, $end)
{
$condition = 'time>=:begin AND time<=:end';
$params = ['begin' => $begin, 'end' => $end];
$model = Logging::model();
$pager = new CPagination($model->count($condition, $params));
$pager->setPageSize(100);
$logging = $model->findAll(['condition' => $condition, 'params' => $params, 'offset' => $pager->getOffset(), 'limit' => $pager->getLimit(), 'order' => 'time desc']);
$this->render('index', ['logging' => new RedArrayDataProvider($logging), 'pager' => $pager]);
}
public function actionIndex()
{
$pageSize = 10;
$criteria = new CDbCriteria();
//$criteria->condition = 'collumnName1 = :id';
$criteria->order = 'id DESC';
//$criteria->params = array(':id' => $id);
$itemCount = Logging::model()->count($criteria);
$pagination = new CPagination($itemCount);
$pagination->setPageSize($pageSize);
$pagination->applyLimit($criteria);
// the trick is here!
$logEntries = Logging::model()->findAll($criteria);
$this->render('index', array('entries' => $logEntries, 'itemCount' => $itemCount, 'pageSize' => $pageSize, 'pagination' => $pagination));
}
public function actionFlush()
{
$this->forcePostRequest();
Logging::model()->deleteAll();
$this->redirect($this->createUrl('index'));
}
