public function run() { $model = new Comment(); //条件 $criteria = new CDbCriteria(); $type = trim(Yii::app()->request->getParam('type')); $type && $criteria->addColumnCondition(array('type' => $type)); $status = trim(Yii::app()->request->getParam('status')); $status && $criteria->addColumnCondition(array('status' => $status)); $title = trim(Yii::app()->request->getParam('content')); $title && $criteria->addSearchCondition('content', $title); $criteria->order = 't.id DESC'; $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 10; $pages->applyLimit($criteria); //查询 $result = $model->findAll($criteria); //全部类型 $model_types = ModelType::model()->findAll(); Yii::app()->clientScript->registerCssFile($this->controller->_static_public . "/js/kindeditor/code/prettify.css"); Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/kindeditor/code/prettify.js", CClientScript::POS_END); $this->controller->render('index', array('model' => $model, 'model_types' => $model_types, 'datalist' => $result, 'pagebar' => $pages)); }
public function run() { $controller = $this->getController(); $this->_setting = $controller->_setting; $this->_stylePath = $controller->_stylePath; $this->_static_public = $controller->_static_public; $controller->_seoTitle = Yii::t('common', 'User Center') . ' - ' . Yii::t('common', 'My Comments') . ' - ' . $this->_setting['site_name']; //加载css,js Yii::app()->clientScript->registerCssFile($this->_stylePath . "/css/user.css"); Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/jquery/jquery.js"); //我的评论 $uid = Yii::app()->user->id; $comment_mod = new Comment(); $model_type = new ModelType(); $uid = Yii::app()->user->id; $criteria = new CDbCriteria(); $criteria->condition = 't.user_id=' . $uid; $criteria->order = 't.id DESC'; //分页 $count = $comment_mod->count($criteria); $pages = new CPagination($count); $pages->pageSize = 15; $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $datalist = $comment_mod->findAll($criteria); foreach ((array) $datalist as $k => $v) { $c_mod_class = $controller->_content_models[$v->type]; $c_mod_name = strtolower($c_mod_class); $content_mod = new $c_mod_class(); $content = $content_mod->findByPk($v->topic_id); $datalist[$k]['title'] = $content->title; $datalist[$k]['url'] = $controller->createUrl($c_mod_name . '/view', array('id' => $content->id)); } $controller->render('my_comments', array('datalist' => $datalist)); }
/** * 评论管理 * */ public function actionIndex() { $this->_model_type = ModelType::model()->findAll(); $model = new Comment(); $criteria = new CDbCriteria(); $condition = '1'; $status = $this->_request->getParam('status'); $title = $this->_request->getParam('postTitle'); $content = $this->_request->getParam('content'); $type = $this->_request->getParam('type') ? $this->_request->getParam('type') : $this->_type_ids['post']; $type && ($condition .= " AND type={$type}"); $status && ($condition .= " AND t.status='{$status}'"); $table = array_search($type, $this->_type_ids); if ($table == 'goods') { $title && ($condition .= " AND {$table}.goods_name LIKE '%{$title} %'"); } else { $title && ($condition .= " AND {$table}.title LIKE '%{$title} %'"); } $content && ($condition .= ' AND t.content LIKE \'%' . $content . '%\''); $criteria->condition = $condition; $criteria->order = 't.id DESC'; $criteria->with = array($table); $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; $pageParams = $this->buildCondition($_GET, array('postTitle', 'status', 'content', 'type')); $pages->params = is_array($pageParams) ? $pageParams : array(); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); Yii::app()->clientScript->registerCssFile($this->_static_public . "/js/kindeditor/code/prettify.css"); Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/kindeditor/code/prettify.js", CClientScript::POS_END); $this->render('index', array('datalist' => $result, 'pagebar' => $pages, 'table' => $table)); }
public function run() { $controller = $this->getController(); $controller->_seoTitle = Yii::t('common', 'User Center') . ' - ' . Yii::t('common', 'My Comments') . ' - ' . $controller->_setting['site_name']; //我的评论 $uid = Yii::app()->user->id; $comment_mod = new Comment(); $criteria = new CDbCriteria(); $criteria->addColumnCondition(array('t.user_id' => $uid)); $criteria->order = 't.id DESC'; //分页 $count = $comment_mod->count($criteria); $pages = new CPagination($count); $pages->pageSize = 15; $pages->applyLimit($criteria); $datalist = $comment_mod->findAll($criteria); foreach ((array) $datalist as $k => $v) { $c_mod_class = $controller->_content_models[$v->type]; $c_mod_name = strtolower($c_mod_class); $content_mod = new $c_mod_class(); $content = $content_mod->findByPk($v->content_id); $datalist[$k]['title'] = $content->title; $datalist[$k]['url'] = $controller->createUrl($c_mod_name . '/view', array('id' => $content->id)); } $controller->render('my_comments', array('datalist' => $datalist, 'pages' => $pages)); }
/** * Get a list of comments * * @param Request $request * @param string $params * @return void */ protected static function get($request, $params) { try { $comments = Comment::query($request->get('queryParams'), $request->include); } catch (OutOfBoundsException $e) { $comments = Comment::findAll($request->include); } static::response($comments, 200); }
function moderation($page = 0) { $this->display('comment/views/moderation', array('comments' => Comment::findAll(), 'page' => $page)); }
public function run() { $this->controller->layout = false; $view_url = Yii::app()->request->getParam('view_url'); $content_id = Yii::app()->request->getParam('content_id'); $topic_type = Yii::app()->request->getParam('topic_type'); $cur_url = Yii::app()->request->hostinfo . Yii::app()->request->getUrl(); $post = false; //评论类型 switch ($topic_type) { case 'post': $post = Post::model()->findByPk($content_id); break; case 'image': $post = Image::model()->findByPk($content_id); break; case 'soft': $post = Soft::model()->findByPk($content_id); break; case 'video': $post = Video::model()->findByPk($content_id); break; } if (!$post) { throw new CHttpException(404, Yii::t('admin', 'Loading Error')); } //评论内容 $model = new Comment('create'); $criteria = new CDbCriteria(); $criteria->with = array('user'); $criteria->addColumnCondition(array('content_id' => $content_id)); $criteria->addColumnCondition(array('t.status' => Comment::STATUS_SHOW)); $criteria->addColumnCondition(array('type' => $this->controller->_type_ids[$topic_type])); $criteria->addCondition('u.uid > 0'); $criteria->order = 't.id DESC'; $criteria->select = 't.id, user_id, content_id, content, t.create_time '; //分页 $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 10; $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $comments = $model->findAll($criteria); //回复 if ($comments) { foreach ($comments as $c) { $replies[$c->id] = Reply::model()->with('user')->findAll(array('condition' => 'cid = ' . $c->id . ' AND t.status = "' . Reply::STATUS_SHOW . '" AND u.uid > 0', 'order' => 'id')); } } else { $comments = array(); $replies = array(); } if (Yii::app()->request->isPostRequest) { $uid = Yii::app()->user->id; if (!$uid) { $this->message('script', Yii::t('common', 'You Need Login')); } $model->attributes = $_POST['Comment']; $model->content_id = $content_id; $model->type = $this->controller->_type_ids[$topic_type]; $model->user_id = $uid; $model->status = 'N'; $model->client_ip = Yii::app()->request->userHostAddress; $model->create_time = time(); $ret_url = $_POST['ret_url']; if ($model->save()) { $this->controller->message('script', Yii::t('common', 'Submit Success, Waiting Pass'), $ret_url); } } $data = array('model' => $model, 'view_url' => $view_url, 'cur_url' => $cur_url, 'comments' => $comments, 'pagebar' => $pages, 'replies' => $replies); $this->controller->render('create', $data); }
function index() { $this->display('comment/views/index', array('comments' => Comment::findAll())); }
/** * 提交评论 * * @return [type] [description] */ public function actionCreate() { $this->layout = false; $view_url = $this->_request->getParam('view_url'); $topic_id = $this->_request->getParam('topic_id'); $topic_type = $this->_request->getParam('topic_type'); $cur_url = $this->_request->hostinfo . $this->_request->getUrl(); $post = false; //评论类型 switch ($topic_type) { case 'post': $post = Post::model()->findByPk($topic_id); break; case 'image': $post = Image::model()->findByPk($topic_id); break; case 'soft': $post = Soft::model()->findByPk($topic_id); break; case 'video': $post = Video::model()->findByPk($topic_id); break; } if (!$post) { throw new CHttpException(404, Yii::t('admin', 'Submit Error')); break; } //评论内容 $model = new Comment('create'); $criteria = new CDbCriteria(); $condition = "topic_id={$topic_id} AND status='Y' AND type={$this->_type_ids[$topic_type]}"; $criteria->condition = $condition; $criteria->order = 'id DESC'; $criteria->select = "id, user_id, topic_id, content, create_time "; //分页 $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 10; $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $comments = $model->findAll($criteria); //回复 if ($comments) { foreach ((array) $comments as $c) { $replies[$c->id] = Reply::model()->findAll('cid=:cid AND status=:status ORDER BY id', array(':cid' => $c->id, ':status' => 'Y')); } } //加载css,js Yii::app()->clientScript->registerCssFile($this->_stylePath . "/css/comment.css"); Yii::app()->clientScript->registerCssFile($this->_static_public . "/js/kindeditor/code/prettify.css"); Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/jquery/jquery.js"); Yii::app()->clientScript->registerScriptFile($this->_static_public . "/js/kindeditor/code/prettify.js", CClientScript::POS_END); if ($this->_request->isPostRequest) { $uid = Yii::app()->user->id; if (!$uid) { $this->message('script', Yii::t('common', 'You Need Login')); } $model->attributes = $_POST['Comment']; $model->topic_id = $topic_id; $model->type = $this->_type_ids[$topic_type]; $model->user_id = $uid; $model->status = 'N'; $model->client_ip = $this->_request->userHostAddress; $model->create_time = time(); $ret_url = $_POST['ret_url']; if ($model->save()) { $this->message('script', Yii::t('common', 'Submit Success, Waiting Pass'), $ret_url); //$this->redirect($ret_url); } } $data = array('model' => $model, 'view_url' => $view_url, 'cur_url' => $cur_url, 'comments' => $comments, 'pagebar' => $pages, 'replies' => $replies); $this->render('create', $data); }
<?php require_once "../models/db.php"; require_once "../models/Comment.php"; require_once "../models/User.php"; $result = array(); $names = array(); $comments; $user = new User(); if ($_GET["time"] == "") { $comments = Comment::findAll($dbh); } else { $comments = Comment::findNewComments($_GET["time"], $dbh); } foreach ($comments as $comment) { $user->find($comment->author_id, $dbh); array_push($names, $user->name); } array_push($result, $comments); array_push($result, $names); header("Content-type: text/json"); echo json_encode($result);