Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 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));
 }
Esempio n. 3
0
 /**
  * 广告管理
  *
  */
 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));
 }
Esempio n. 4
0
 /**
  * 广告管理
  *
  */
 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));
 }