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 ">
