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; }
/** * 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 $id the ID of the model to be loaded * @return Ad the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Ad::model()->withEavAttributes()->with('author', 'category', 'city', 'photos')->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function getAds() { $cri = new CDbCriteria(array('order' => 'sort_order asc')); $ads = Ad::model()->findAll($cri); return $ads; }