Yii:根据最高平均评分获取数据
[英] Yii: Getting data on the basis of highest average rating
本文介绍了Yii:根据最高平均评分获取数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我是一个 yiibie，我想从我的NgoRateReviewNgo"表中获得前 5 个非政府组织.前 5 个 Ngo 的条件是首先找到 Ngo 的平均评分，然后显示平均评分最高的 5 个 Ngo.这是我的视图文件的代码，包含 SQL 查询
<div class="banner"><img src="<?php echo Yii::app()->request->baseurl;?>/img/stat1.jpg" style="width: 1170px"></div><!--横幅在此结束--><br><div class="container" style="background-color:#7AC5CD"><div class="row"><div class="col-md-6"><h3 style='text-align:center;文字装饰:下划线；字体系列:无衬线；颜色:黑色'>Ngo 的月明智前 5 名</h3><br><?phpfor($month = 1 ; $month <=12 ; $month++){'
';$dateObj = DateTime::createFromFormat('!m', $month);$monthName = $dateObj->format('F');echo "<h3 style='text-align:center;color:black;'> " .$monthName ."</h3>";$user=UserRateReviewNgo::model()->findAll(array('条件' =>'YEAR(date_created)=:year 和 MONTH(date_created)=:month','参数' =>数组(':year'=>2016, ':month'=>$month),'选择'='=>'max(rate),ngo_id','组' =>'ngo_id','order'='rate DESC','限制' =>5));$val = 100;foreach($user as $show) {$model = Ngo::model()->findByAttributes(array('id'=>$show->ngo_id,));如果(isset($模型)){echo "<div><h4><a href='".Yii::app()->request->baseUrl."/ngo/ngopage?id=$model->id'><p style='color:black;font-family:Lucida Sans Unicode;'>".$model->ngo_name ."</p></a></h4></div><div class='progress'><div class='progress-bar progress-bar-danger progress-bar-striped active' role='progressbar'aria-valuenow='" . $val ."' aria-valuemin='0' aria-valuemax='100' style='width: ". $val ."%;'>" . $val ."</div>
";$val = $val -21.23;} }}?>
<div class="col-md-5 col-md-offset-1"><h3 style='text-align:center;文字装饰:下划线；字体系列:无衬线；颜色:黑色'>年度最佳 Ngo 5 强</h3><br><?php//年份$val = 100;foreach($userYear as $show){$model = Ngo::model()->findByAttributes(array('id'=>$show->ngo_id,));如果(isset($模型)){echo "<div><h4><a href='".Yii::app()->request->baseUrl."/ngo/ngopage?id=$model->id'><p style='color:black; font-family:Lucida Sans Unicode;'>".$model->ngo_name ."</p></a></h4></div><div class='progress'><div class='progress-bar progress-bar-success progress-bar-striped active' role='progressbar'aria-valuenow='" . $val ."' aria-valuemin='0' aria-valuemax='100' style='width: ". $val ."%;'>" . $val ."</div>
";$val = $val -17.96;}}?>
</div><!--这里主要结束--></div><!--容器在此结束-->
请帮我解决这个问题.
解决方案
这应该是查询
$user=UserRateReviewNgo::model()->findAll(array('条件' =>'YEAR(date_created)=:year 和 MONTH(date_created)=:month','参数' =>数组(':year'=>2016, ':month'=>$month),'选择'=>'avg(rate),ngo_id','组' =>'ngo_id','order'='rate DESC','限制' =>5));
I am a yiibie and I want to get the top 5 ngo's from my "NgoRateReviewNgo" table. The condition for the top 5 Ngo's is that it should first find the average rating of the Ngo's and after that those 5 Ngo's which have highest average rating gets displayed. This is the code for my view file and contains the SQL query
<div class="main">
<div class="banner">
<img src="<?php echo Yii::app()->request->baseurl;?>/img/stat1.jpg" style="width: 1170px">
</div><!--banner ending here--><br>
<div class="container" style="background-color:#7AC5CD">
<div class="row">
<div class="col-md-6">
<h3 style='text-align:center; text-decoration: underline;font-family: sans-serif; color: black'>Top 5 Ngo's month wise</h3>
<br>
<?php
for($month = 1 ; $month <=12 ; $month++)
{
'<br>' ;
$dateObj = DateTime::createFromFormat('!m', $month);
$monthName = $dateObj->format('F');
echo "<h3 style='text-align:center;color:black;'> " . $monthName . "</h3>";
$user=UserRateReviewNgo::model()->findAll(array(
'condition' => 'YEAR(date_created)=:year and MONTH(date_created)=:month',
'params' => array(':year'=>2016, ':month'=>$month),
'select'=>'max(rate),ngo_id',
'group' => 'ngo_id',
'order'=>'rate DESC',
'limit' => 5
));
$val = 100;
foreach($user as $show) {
$model = Ngo::model()->findByAttributes(array('id'=>$show->ngo_id,));
if (isset($model)) {
echo "<div><h4><a href='".Yii::app()->request->baseUrl."/ngo/ngopage?id=$model->id'><p style='color:black;font-family:Lucida Sans Unicode;'>" . $model->ngo_name ."</p></a></h4></div>
<div class='progress'>
<div class='progress-bar progress-bar-danger progress-bar-striped active' role='progressbar'
aria-valuenow='" . $val ."' aria-valuemin='0' aria-valuemax='100' style='width: ". $val ."%;'>" . $val .
"</div>
</div>";
$val = $val -21.23;
} }}
?>
</div>
<div class="col-md-5 col-md-offset-1">
<h3 style='text-align:center; text-decoration: underline;font-family: sans-serif; color: black'>Top 5 Ngo's of the year</h3>
<br>
<?php // the for the year
$val = 100;
foreach($userYear as $show)
{
$model = Ngo::model()->findByAttributes(array('id'=>$show->ngo_id,));
if (isset($model))
{
echo "<div><h4><a href='".Yii::app()->request->baseUrl."/ngo/ngopage?id=$model->id'><p style='color:black; font-family:Lucida Sans Unicode;'>" . $model->ngo_name ."</p></a></h4></div>
<div class='progress'>
<div class='progress-bar progress-bar-success progress-bar-striped active' role='progressbar'
aria-valuenow='" . $val ."' aria-valuemin='0' aria-valuemax='100' style='width: ". $val ."%;'>" . $val .
"</div>
</div>";
$val = $val -17.96;
}
}
?>
</div>
</div>
</div><!--main ending here-->
</div><!--Container ending here-->
Please help me with this.
解决方案
this should be the query
$user=UserRateReviewNgo::model()->findAll(array(
'condition' => 'YEAR(date_created)=:year and MONTH(date_created)=:month',
'params' => array(':year'=>2016, ':month'=>$month),
'select'=>'avg(rate),ngo_id',
'group' => 'ngo_id',
'order'=>'rate DESC',
'limit' => 5
));
这篇关于Yii:根据最高平均评分获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
