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