public function run() { $model = new MailLog(); //条件 $criteria = new CDbCriteria(); $accept = trim(Yii::app()->request->getParam('accept')); //收件人 $subject = trim(Yii::app()->request->getParam('subject')); //主题 $start_time = Yii::app()->request->getParam('start_time'); $end_time = Yii::app()->request->getParam('end_time'); $accept && $criteria->addSearchCondition('accept', $accept); $subject && $criteria->addSearchCondition('subject', $subject); $start_time && $criteria->compare('sendtime', '>=' . strtotime($start_time)); $end_time && $criteria->compare('sendtime', '<=' . strtotime($end_time)); $criteria->order = 't.id DESC'; $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 20; $pages->applyLimit($criteria); //查询 $result = $model->findAll($criteria); $this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages)); }
/** * 评论管理 * */ public function actionIndex() { $model = new MailLog(); $criteria = new CDbCriteria(); $condition = '1'; $accept = $this->_request->getParam('accept'); //收件人 $subject = $this->_request->getParam('subject'); //主题 $start_time = $this->_request->getParam('start_time'); $end_time = $this->_request->getParam('end_time'); $accept && ($condition .= " AND accept='{$accept}'"); $subject && ($condition .= " AND subject like '%{$subject}%'"); //发送时间查询 $start_time && ($start_time = strtotime($start_time)); $end_time && ($end_time = strtotime($end_time)); $start_time && $end_time && ($condition .= " AND sendtime BETWEEN {$start_time} AND {$end_time}"); $criteria->condition = $condition; $criteria->order = 't.id DESC'; $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 20; $pageParams = $this->buildCondition($_GET, array('accept', 'subject', 'start_time', 'end_time')); $pages->params = is_array($pageParams) ? $pageParams : array(); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->render('index', array('datalist' => $result, 'pagebar' => $pages, 'model' => $model)); }