PHP Ad::model方法代码示例

 public function run()
 {
     $ids = Yii::app()->request->getParam('id');
     $command = Yii::app()->request->getParam('command');
     empty($ids) && $this->controller->message('error', Yii::t('admin', 'No Select'));
     if (!is_array($ids)) {
         $ids = array($ids);
     }
     $criteria = new CDbCriteria();
     $criteria->addInCondition('id', $ids);
     switch ($command) {
         case 'delete':
             //删除
             Ad::model()->deleteAll($criteria);
             break;
         case 'show':
             //显示
             Ad::model()->updateAll(['status' => Ad::STATUS_SHOW], $criteria);
             break;
         case 'hide':
             //隐藏
             Ad::model()->updateAll(['status' => Ad::STATUS_HIDE], $criteria);
             break;
         default:
             $this->controller->message('error', Yii::t('admin', 'Error Operation'));
     }
     $this->controller->message('success', Yii::t('admin', 'Batch Operate Success'));
 }

 public function run()
 {
     //SEO
     $this->controller->_seoTitle = $this->controller->_setting['seo_title'];
     $this->controller->_seoKeywords = $this->controller->_setting['seo_keywords'];
     $this->controller->_seoDescription = $this->controller->_setting['seo_description'];
     //头部banner
     $index_top_banner = Ad::model()->getAdOne(4);
     //中部banner
     $index_mid_banner = Ad::model()->getAdOne(3);
     //底部banner
     $index_bottom_banner = Ad::model()->getAdOne(5);
     //最新资讯
     $news_new = Post::model()->getList(array('limit' => 20));
     //热门资讯
     $news_hot = Post::model()->getList(array('order' => 't.view_count DESC, t.id DESC', 'limit' => 20));
     //最新图集
     $image_new = Image::model()->getList(array('limit' => 10));
     //热门图集
     $image_hot = Image::model()->getList(array('limit' => 10, 'order' => 'view_count DESC, t.id DESC'));
     //最新软件
     $soft_new = Soft::model()->getList(array('limit' => 20));
     //热门软件
     $soft_hot = Soft::model()->getList(array('limit' => 10, 'order' => 'down_count DESC, t.id DESC'));
     //最新视频
     $video_new = Video::model()->findAll("status=:status AND catalog_id = 13 ORDER BY id DESC Limit 20", array(':status' => 'Y'));
     //热门视频
     $video_hot = Video::model()->findAll("status=:status AND catalog_id = 13 ORDER BY view_count DESC, video_score DESC, id DESC Limit 20", array(':status' => 'Y'));
     //友情链接
     $link_logos = Link::model()->findAll("logo !='' AND status='Y'", array('order' => 'sortorder ASC, id DESC'));
     $link_texts = Link::model()->findAll("logo ='' AND status='Y'", array('order' => 'sortorder ASC, id DESC'));
     $this->controller->render('index', array('index_top_banner' => $index_top_banner, 'index_mid_banner' => $index_mid_banner, 'index_bottom_banner' => $index_bottom_banner, 'link_logos' => $link_logos, 'link_texts' => $link_texts, 'news_new' => $news_new, 'news_hot' => $news_hot, 'image_new' => $image_new, 'image_hot' => $image_hot, 'soft_new' => $soft_new, 'soft_hot' => $soft_hot, 'video_new' => $video_new, 'video_hot' => $video_hot));
 }

 public static function saveAdToRt($adID)
 {
     $ad = Ad::model()->findByPk($adID);
     $connection = new CDbConnection(Yii::app()->params['sphinx']['dsn'], Yii::app()->params['sphinx']['user'], Yii::app()->params['sphinx']['pass']);
     $connection->active = true;
     $sphinxIndexes = Yii::app()->params['sphinx']['indexes'];
     $rt = $sphinxIndexes['rt'][0];
     $sql = "INSERT INTO {$rt} (id, title, description, added)\n                VALUES (:id, :title, :description, :added)";
     $command = $connection->createCommand($sql);
     $command->execute(array(':id' => $ad->id, ':title' => $ad->title, ':description' => $ad->description, ':added' => time()));
 }

 /**
  * 判断数据是否存在
  * 
  * return \$this->model
  */
 public function loadModel()
 {
     if ($this->model === null) {
         if (isset($_GET['id'])) {
             $this->model = Ad::model()->findbyPk($_GET['id']);
         }
         if ($this->model === null) {
             throw new CHttpException(404, Yii::t('common', 'The requested page does not exist.'));
         }
     }
     return $this->model;
 }

 /**
  * This is the default 'index' action that is invoked
  * when an action is not explicitly requested by users.
  */
 public function actionIndex()
 {
     $criteria = new CDbCriteria();
     $criteria->addInCondition('level', array(1, 2));
     $criteria->order = 'root, lft';
     $categories = Category::model()->findAll($criteria);
     $form = new SearchForm();
     $criteria = new CDbCriteria(array('condition' => 'status="published"', 'order' => 'added DESC', 'with' => array('photos'), 'limit' => 20));
     $models = Ad::model()->withEavAttributes()->findAll($criteria);
     $dp = new CActiveDataProvider('Ad', array('data' => $models, 'pagination' => false));
     $regionList = Region::model()->getRegionList();
     $this->render('index', array('categories' => $categories, 'form' => $form, 'dataProvider' => $dp, 'regionList' => $regionList));
 }

 /**
  * This is the default 'index' action that is invoked
  * when an action is not explicitly requested by users.
  */
 public function actionIndex()
 {
     //首页banner幻灯片
     $banner = Ad::model()->findAll('position_id=:pid', array(':pid' => 1));
     //SEO
     $this->_seoTitle = $this->_setting['seo_title'];
     $this->_seoKeywords = $this->_setting['seo_keywords'];
     $this->_seoDescription = $this->_setting['seo_description'];
     //加载css,js
     Yii::app()->clientScript->registerCssFile($this->_stylePath . "/css/index.css");
     Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/jquery/jquery.js");
     //友情链接
     $link_logos = Link::model()->findAll("logo !='' AND status_is='Y'", array('order' => 'sortorder ASC, id DESC'));
     $link_texts = Link::model()->findAll("logo ='' or logo is null AND status_is='Y'", array('order' => 'sortorder ASC, id DESC'));
     $this->render('index', compact(array('link_logos', 'link_texts')));
 }

 /**
  * This is the default 'index' action that is invoked
  * when an action is not explicitly requested by users.
  */
 public function actionIndex()
 {
     //首页banner幻灯片
     $banner = Ad::model()->findAll('position_id=:pid', array(':pid' => 1));
     //SEO
     $this->_seoTitle = $this->_setting['seo_title'];
     $this->_seoKeywords = $this->_setting['seo_keywords'];
     $this->_seoDescription = $this->_setting['seo_description'];
     //加载css,js
     Yii::app()->clientScript->registerCssFile($this->_stylePath . "/css/index.css");
     Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/jquery/jquery.js");
     Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/jquery/jquery.easytabs.min.js");
     //头部banner
     $index_top_banner = Ad::model()->getAdOne(4);
     //中部banner
     $index_mid_banner = Ad::model()->getAdOne(3);
     //底部banner
     $index_bottom_banner = Ad::model()->getAdOne(5);
     //最新资讯
     Yii::app()->cache && ($news_new = Yii::app()->cache->get('news_new'));
     if ($news_new == false) {
         $news_new = Post::model()->getList(array('limit' => 20));
         Yii::app()->cache && Yii::app()->cache->set('news_new', $news_new);
     }
     //热门资讯
     Yii::app()->cache && ($news_hot = Yii::app()->cache->get('news_host'));
     if ($news_hot == false) {
         $news_hot = Post::model()->getList(array('order' => 't.view_count DESC, t.id DESC', 'limit' => 20));
         Yii::app()->cache && Yii::app()->cache->set('news_hot', $news_hot);
     }
     //最新图集
     $image_new = Image::model()->getList(array('limit' => 10));
     //热门图集
     $image_hot = Image::model()->getList(array('limit' => 10, 'order' => 'view_count DESC, t.id DESC'));
     //最新软件
     $soft_new = Soft::model()->getList(array('limit' => 20));
     //热门软件
     $soft_hot = Soft::model()->getList(array('limit' => 10, 'order' => 'down_count DESC, t.id DESC'));
     //最新视频
     //$video_new = Video::model()->findAll("status=:status AND catalog_id = 13 ORDER BY id DESC Limit 20", array(':status'=>'Y'));
     //热门视频
     //$video_hot = Video::model()->findAll("status=:status AND catalog_id = 13 ORDER BY view_count DESC, video_score DESC, id DESC Limit 20", array(':status'=>'Y'));
     //友情链接
     $link_logos = Link::model()->findAll("logo !='' AND status_is='Y'", array('order' => 'sortorder ASC, id DESC'));
     $link_texts = Link::model()->findAll("logo ='' or logo is null AND status_is='Y'", array('order' => 'sortorder ASC, id DESC'));
     $this->render('index', compact(array('index_top_banner', 'index_mid_banner', 'index_bottom_banner', 'link_logos', 'link_texts', 'news_new', 'news_hot', 'image_new', 'image_hot', 'soft_new', 'soft_hot', 'video_new', 'video_hot')));
 }

 /**
  * This is the default 'index' action that is invoked
  * when an action is not explicitly requested by users.
  */
 public function actionIndex()
 {
     $ads = Ad::model()->findAll();
     $posts = Post::model()->findAll(new CDbCriteria(array('limit' => 5, 'order' => 'id desc')));
     $hotCategories = Category::model()->hot()->level(2)->limit(3)->findAll();
     $hotItems = array();
     foreach ($hotCategories as $hotCategory) {
         $hotItems[$hotCategory->name] = Item::getItemsByCategory($hotCategory, 4);
     }
     $newCategories = Category::model()->new()->level(2)->limit(3)->findAll();
     $newItems = array();
     foreach ($newCategories as $key => $newCategory) {
         if ($key == 0) {
             $newItems[$newCategory->name] = Item::getItemsByCategory($newCategory, 7);
         } else {
             $newItems[$newCategory->name] = Item::getItemsByCategory($newCategory, 8);
         }
     }
     Yii::app()->params['ads'] = $ads;
     //        $newItems[0] = array_slice($newItems[0], 7);
     $this->render('index', array('ads' => $ads, 'posts' => $posts, 'hotCategories' => $hotCategories, 'hotItems' => $hotItems, 'newCategories' => $newCategories, 'newItems' => $newItems));
 }

<div class="main-container col1-layout">
    <div class="main container show-bg">
        <div class="preface grid-full in-col1">
            <div class="the-slideshow-wrapper nested-container clearer">
                <div class="the-slideshow gen-slider-arrows2 gen-slider-pager1 gen-slider-pager1-pos-bottom-right grid12-9  ">

                    <!--<div class="viewport" style="overflow: hidden; position: relative; height: 390px;">-->
                        <ul class="slides">
                            <?php 
$ad_list = Ad::model()->findAll();
foreach ($ad_list as $k => $a) {
    ?>
                            <li>
                                <a title="Click to see all features" href="<?php 
    echo $a->url;
    ?>
">
                                    <?php 
    echo CHtml::image(F::baseUrl() . '/../../upload/ad/' . $a->pic);
    ?>
                                    <div class="caption dark3">
                                        <h2 class="heading permanent"><?php 
    echo $a->title;
    ?>
</h2>
                                        <p><?php 
    echo $a->content;
    ?>
</p>
                                    </div>
                                </a>

 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param integer the ID of the model to be loaded
  */
 public function loadModel($id)
 {
     $model = Ad::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }

 public function run()
 {
     $cri = new CDbCriteria(array('order' => 'sort_order asc'));
     $ads = Ad::model()->findAll($cri);
     $this->render('ad', array('ads' => $ads));
 }

 /**
  * 批量操作
  *
  */
 public function actionBatch()
 {
     if ($this->method() == 'GET') {
         $command = trim($_GET['command']);
         $ids = intval($_GET['id']);
     } else {
         if ($this->method() == 'POST') {
             $command = trim($_POST['command']);
             $ids = $_POST['id'];
         } else {
             $this->message('errorBack', Yii::t('admin', 'Only POST Or GET'));
         }
     }
     empty($ids) && $this->message('error', Yii::t('admin', 'No Select'));
     switch ($command) {
         case 'adDelete':
             foreach ((array) $ids as $id) {
                 $adModel = Ad::model()->findByPk($id);
                 if ($adModel) {
                     Uploader::deleteFile($adModel->attach_file);
                     $adModel->delete();
                 }
             }
             break;
         case 'adVerify':
             foreach ((array) $ids as $id) {
                 $adModel = Ad::model()->findByPk($id);
                 if ($adModel) {
                     $adModel->status = 'Y';
                     $adModel->save();
                 }
             }
             break;
         case 'adUnVerify':
             foreach ((array) $ids as $id) {
                 $adModel = Ad::model()->findByPk($id);
                 if ($adModel) {
                     $adModel->status = 'N';
                     $adModel->save();
                 }
             }
             break;
         default:
             throw new CHttpException(404, Yii::t('admin', 'Error Operation'));
             break;
     }
     $this->message('success', Yii::t('admin', 'Batch Operate Success'), $this->createUrl('index'));
 }

 public static function getad($id)
 {
     $ad = Ad::model()->find('id=:id', array('id' => $id));
     return $ad;
 }

 public function getAds()
 {
     $cri = new CDbCriteria(array('condition' => 'theme LIKE "%default%"', 'order' => 'sort_order asc'));
     $ads = Ad::model()->findAll($cri);
     return $ads;
 }

 /**
  * @author: Biner
  * @date: 2010-12-14上午02:23:42
  * @description: 获得广告
  */
 public function getAds($limit = 8, $location_id)
 {
     if ($limit == 0) {
         $rows = array();
     } else {
         $rows = Ad::model()->getAdList($limit, 0, $location_id);
     }
     return $rows;
 }