private function _getComment($parent_id = 0)
{
$criteria = new CDbCriteria();
$criteria->addCondition(TUtil::qc('model') . "=:model");
$criteria->addCondition(TUtil::qc('pk') . "=:pk");
$criteria->addCondition(TUtil::qc('parent_id') . "=:parent_id");
if ($parent_id == 0) {
$criteria->order = TUtil::qc('create_time') . " desc";
} else {
$criteria->order = TUtil::qc('create_time') . " asc";
}
$criteria->params = array(":model" => $this->_model, ":pk" => $this->_pk, ":parent_id" => $parent_id);
$data = SysComment::model()->findAll($criteria);
$comments = array();
$i = 0;
foreach ($data as $value) {
$comments[$i]["id"] = $value["id"];
$comments[$i]["parent_id"] = $value["parent_id"];
$comments[$i]["rating"] = $value["rating"];
$comments[$i]["content"] = $value["content"];
$comments[$i]["create_time"] = $value["create_time"];
$comments[$i]["create_user"] = $value["create_user"];
$userInfo = User::model()->getUserInfoById($value["create_user"]);
$comments[$i]["user_gender"] = $userInfo["gender"];
$comments[$i]["user_name"] = $userInfo["user_name"];
$comments[$i]["user_avatar"] = User::getAvatar($value["create_user"], $userInfo['avatar'], 'm', $userInfo['gender'], TOrgUtil::userIsOnline($value["create_user"]));
$comments[$i]["chrildren"] = $this->_getComment($value["id"]);
$comments[$i]["enableReply"] = $this->enableReply;
$i++;
}
return $comments;
}
/**
* 更改点评是否显示
*/
public function actionChangesyscommentshow($id)
{
$model = SysComment::model()->findByPk($id);
$show = $model->is_show == 1 ? 0 : 1;
$model->is_show = $show;
if ($model->save()) {
echo "ok";
}
}
?>
<?php
$idString = SysComment::model()->getShowIdStr();
if ($idString != "") {
$comment = Yii::app()->db->createCommand('select *,count(comment_id) as num from sys_comment_reply where is_show=0 and comment_id in (' . $idString . ') group by comment_id order by num desc')->queryAll();
} else {
$comment = Yii::app()->db->createCommand('select *,count(comment_id) as num from sys_comment_reply where is_show=0 and comment_id =0 group by comment_id order by num desc')->queryAll();
}
$i = 0;
$count = array();
if (empty($comment)) {
echo "<div class='alert alert-block alert-info'>暂无最热点评.</div>";
} else {
foreach ($comment as $name) {
$i++;
$model = SysComment::model()->findByPk($name['comment_id']);
if ($i == 6) {
break;
}
?>
<div class="agree-comment" style="padding-left: 6px;">
<div class="comment-list clearfix">
<div class="item clearfix" style="margin-bottom: 6px;position: relative;border-bottom:1px dotted #ccc;">
<div style="width:100%;float: left;">
<div class="u-name"> <a target="_blank" href="<?php
echo $this->createUrl('default/userinfo', array('user_id' => $model->user_id));
?>
"><b><?php
echo User::getNameById($model->user_id);
?>
</b></a> 于 <?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'type' => 'primary', 'label' => $model->isNewRecord = '查询'));
?>
</div>
<?php
$this->endWidget();
?>
</div><!-- search-form -->
</div>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'button', 'label' => '高级搜索', 'icon' => 'icon-search-2', 'htmlOptions' => array("id" => "search", "style" => "margin-left:5px;")));
$columns = array(array('header' => '用户名', 'type' => 'raw', 'value' => 'CHtml::openTag("img", array("src" => Yii::app()->controller->createUrl("getimage",array("id"=>$data->user_id,"type"=>"avatar")),"style"=>"margin-right:4px;height:30px;width:30px;")).CHtml::link(User::getNameById($data->user_id),array("userinfo","user_id"=>$data->user_id),array("target"=>"_blank","data-id"=>$data->user_id,"class"=>"user-label"))'), array('name' => 'content', 'value' => '$data->content'), array('name' => 'tags', 'value' => '$data->tags'), array('header' => '点评时间', 'name' => 'create_time', 'value' => 'date("Y-m-d H:i:s",$data->create_time)'), array('header' => '状态', 'name' => 'is_show', 'value' => '$data->is_show=="0"?"显示":"不显示"'), array('class' => 'bootstrap.widgets.TbButtonColumn', 'header' => '操作', 'template' => '{showcomment}{noshow}{deletecomment}', 'headerHtmlOptions' => array('style' => 'width:60px;text-align:center;'), 'buttons' => array('showcomment' => array('icon' => 'icon-checkmark-2', 'label' => '显示', 'visible' => '$data->is_show=="1" ? true: false', 'url' => 'Yii::app()->controller->createUrl("changesyscommentshow",array("id"=>$data->primaryKey))', 'options' => array('style' => 'margin-left:5px;'), 'click' => "function(){\n \$.fn.yiiGridView.update('sys-comment-grid', {\n type:'GET',\n url:\$(this).attr('href'),\n success:function(data) {\n \$.fn.yiiGridView.update('sys-comment-grid');\n }\n })\n return false;\n }\n "), 'noshow' => array('icon' => 'icon-close-2', 'label' => '不显示', 'visible' => '$data->is_show=="0" ? true: false', 'url' => 'Yii::app()->controller->createUrl("changesyscommentshow",array("id"=>$data->primaryKey))', 'options' => array('style' => 'margin-left:5px;'), 'click' => "function(){\n \$.fn.yiiGridView.update('sys-comment-grid', {\n type:'GET',\n url:\$(this).attr('href'),\n success:function(data) {\n if(data=='ok'){\n \$.fn.yiiGridView.update('sys-comment-grid');\n }else{\n alert('设置失败');\n }\n }\n })\n return false;\n }\n "), 'deletecomment' => array('icon' => 'icon-remove', 'label' => '删除', 'url' => 'Yii::app()->controller->createUrl("deletesyscomment")', 'options' => array('style' => 'margin-left:5px;'), 'click' => "function(){\n var hrefUrl =\$(this).attr('href');\n var id = \$(this).parents('tr').attr('comment-id');\n if(window.confirm('删除评论时，此评论下的回复也会全部删除，确定要删除所选的评论吗?')){\n \$.ajax({ \n url:hrefUrl,\n type:'POST',\n data: {'id':id},\n dataType:'html', \n success: function(data){\n if(data=='ok'){\n alert('删除成功');\n \$.fn.yiiGridView.update('sys-comment-grid');\n }else{\n alert('删除失败');\n }\n }\n });\n return false; \n }\n return false;\n }"))));
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'sys-comment-grid', 'type' => 'striped', 'rowHtmlOptionsExpression' => 'array("comment-id"=>$data->id)', 'dataProvider' => SysComment::model()->search(), 'columns' => $columns));
?>
<script>
$(document).ready(function(){
$('#search').live("click",function (){
if($('.search-form').is(':visible')==false){
$('.search-form').show(500);
}else{
$('.search-form').hide(500);
}
});
$('.search-form form').submit(function(){
$.fn.yiiGridView.update('sys-comment-grid', {
data: $(this).serialize()
});
return false;
<ul class="status-list">
<li><span>问题总数：<?php
echo Question::model()->count();
?>
</span><span>文章总数：<?php
echo Article::model()->count("publish=1");
?>
</span></li>
<li><span>评论总数：<?php
echo Comment::model()->count("parent_id=0") + SysComment::model()->count();
?>
</span><span>会员总数：<?php
echo User::model()->count();
?>
</span></li>
<li><span>回答总数：<?php
echo Answer::model()->count();
?>
</span><span>访问总数：<?php
echo Sys::model()->find()->view_count;
?>
</span></li>
</ul>
