public static function getLastReview() { $criteria = new CDbCriteria(); $criteria->condition = 'active = ' . self::STATUS_ACTIVE; $criteria->limit = 1; $criteria->order = 'date_created DESC'; $lastReview = Reviews::model()->find($criteria); return $lastReview; }
public function actionIndex() { $criteria = new CDbCriteria(); //$criteria->order = 'sorter'; $criteria->order = 'date_created DESC'; $criteria->condition = 'active=' . Reviews::STATUS_ACTIVE; $pages = new CPagination(Reviews::model()->count($criteria)); $pages->pageSize = param('module_reviews_itemsPerPage', 10); $pages->applyLimit($criteria); $reviews = Reviews::model()->cache(param('cachingTime', 1209600), Reviews::getCacheDependency())->findAll($criteria); $this->render('index', array('reviews' => $reviews, 'pages' => $pages)); }
public function actionIndex() { $this->pageTitle = "论坛首页"; // 论坛公告 $notices = Notices::model()->find(); // 讨论区类别 $bbsType = BbsType::model()->findAll(); // 话题计数 $bbsCount = BbsInfo::model()->count(); // 回帖计数 $revCount = Reviews::model()->count(); // 用户计数 $userCount = UserInfo::model()->count(); // 绑定数据 $data = array('notices' => $notices, 'bbsType' => $bbsType, 'bbsCount' => $bbsCount, 'revCount' => $revCount, 'userCount' => $userCount); $this->render('index', $data); }
public function actionIndex($articleId) { $this->pageTitle = "新闻页"; //查询当前新闻的所有评论 $reviews = Reviews::model()->findAll("articleId={$articleId}"); //查询当前显示的新闻 $sql = "select * from newsArticles a inner join newsTypes b on a.typeId=b.typeId and articleId={$articleId}"; $db = Yii::app()->db; $st = $db->createCommand($sql); $newsInfo = $st->queryRow(); //新闻id没有对应的新闻 if ($newsInfo == NULL) { $this->redirect(__APP__ . "/success/index/act/nocontent"); } $data = array("newsInfo" => $newsInfo, "reviews" => $reviews); $this->render("index", $data); }
/** * @method run */ public function run() { $reviewsConfig = ReviewsConfig::model()->find(); $criteria = new CDbCriteria(); $criteria->order = 'date_create DESC'; if ($reviewsConfig->premoder and Yii::app()->user->isGuest) { $criteria->condition = 'public = :public'; $criteria->params = array(':public' => true); } $dataProvider = Reviews::model()->findAll($criteria); /* $dataProvider = new CActiveDataProvider('Reviews', array( 'criteria' => $criteria, 'pagination' => false, )); */ $this->render('reviews', array('dataProvider' => $dataProvider)); return parent::run(); }
/** * 删除评论,此评论只有超级管理员能删除 * @param [int] $reId [评论Id] * @param [int] $bbsId [论坛话题ID] */ public function actiondelReview($reId, $bbsId) { $result = Reviews::model()->deleteByPK("{$reId}"); $this->redirect("index.php?r=reaction/index/act/delReview/rst/{$result}/bbsId/{$bbsId}"); }
/** * 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 Zal the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Reviews::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
<div class="col-xs-12 col-sm-3" > <div class="block-left" style="margin-bottom:40px;"> <?php $this->renderPartial('application.views.common.tags'); ?> </div> </div> <div class="col-xs-12 col-sm-6 text-center"> <img class="img-responsive" id="goToNextSlideReview" style="margin:0px auto 0px auto;cursor:pointer;" src="/img/btn-reviews.png" onmouseover="this.src='/img/btn-reviews_active.png'" onmouseout="this.src='/img/btn-reviews.png'" /> <div class="ex-reviews"> <ul id="exp-reviews-slider"> <?php $reviews = Reviews::model()->active()->findAll(); if ($reviews) { foreach ($reviews as $review) { // $src = $review->getOrigFilePath().$review->image; $src = Yii::app()->createAbsoluteUrl($review->getUrl('120x120xC', 'adaptiveResizeQuadrant')); ?> <li> <div class=""> <div class="ex-review row"> <div class="col-xs-12 col-sm-3 ex-review-pic"> <img class="img-responsive" src="<?php echo $src; ?> " /> </div> <div class="col-xs-12 ex-review-text col-sm-9 text-left ">