public static function getads($pid)
{
$model = new Ad();
$criteria = new CDbCriteria();
$criteria->addCondition("is_show=1 and pid={$pid}");
$criteria->order = 'orderid ASC';
$ads = $model->findAll($criteria);
return $ads;
}
public function run()
{
$model = new Ad();
//条件
$criteria = new CDbCriteria();
$title = trim(Yii::app()->request->getParam('title'));
$position_id = intval(Yii::app()->request->getParam('position_id'));
$title && $criteria->addColumnCondition(array('title' => $title));
$position_id && $criteria->addColumnCondition(array('position_id', $position_id));
$criteria->order = 't.id ASC';
$count = $model->count($criteria);
//分页
$pages = new CPagination($count);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
//查询
$result = $model->findAll($criteria);
$this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages));
}
/**
* 广告管理
*
*/
public function actionIndex()
{
$model = new Ad();
$criteria = new CDbCriteria();
$condition = '1';
$title = $this->_request->getParam('title');
$position_id = $this->_request->getParam('positionID');
$position_id && ($condition .= ' AND position_id =' . $position_id);
$title && ($condition .= ' AND title LIKE \'%' . $title . '%\'');
$criteria->condition = $condition;
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 13;
$pageParams = $this->buildCondition($_GET, array('title'));
$pages->params = is_array($pageParams) ? $pageParams : array();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('ad_index', array('datalist' => $result, 'pagebar' => $pages));
}
/**
* 广告管理
*
*/
public function actionAd()
{
parent::_acl('ad_index');
$model = new Ad();
$criteria = new CDbCriteria();
$condition = '1';
$title = $this->_gets->getParam('title');
$title && ($condition .= ' AND title LIKE \'%' . $title . '%\'');
$criteria->condition = $condition;
//$criteria->params = '';
$criteria->order = 't.id DESC';
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 13;
$pageParams = XUtils::buildCondition($_GET, array('title'));
$pages->params = is_array($pageParams) ? $pageParams : array();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('ad_index', array('datalist' => $result, 'pagebar' => $pages));
}