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')); }