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>