public function index()
{
//var_dump($_SESSION['qq']);
$articleId = $_GET['articleId'];
$article = new ArticleModel();
$content = $article->getArticleById($articleId);
$collect = new CollectModel();
$comment = new CommentModel();
$commentNum = $comment->getCommentCountByArticleId($articleId);
$content['commentNum'] = $commentNum;
if ($this->isLogin()) {
if ($collect->getCollects($article, $_SESSION['qq']['userId'])) {
$this->assign('collects', '已收藏');
} else {
$collectNum = $collect->getCollectCountByuserId($article);
$this->assign('collectNum', $collectNum);
$this->assign('collects', '收藏');
}
}
$this->assign('article', $content);
//评论查询
$comments = $comment->getComment($articleId);
$user = new UserModel();
$arr = array();
foreach ($comments as $key => $val) {
$val[$key]['user'] = $user->getUserById($val['userId']);
}
$this->assign('comments', $comments);
$this->display();
}
/**
* 发表评论
* curl -d "course_id=1&comment_id=1&video_id=0&content=helloaaaaaaaaaa" http://182.92.110.119/comment/publish
*/
function publishAction()
{
$courseId = (int) $this->post("course_id", 0);
$commentId = (int) $this->post("comment_id", 0);
$videoId = (int) $this->post("video_id", 0);
$content = $this->post("content", "");
$time = time();
$comment = array("uid" => $this->uid, "comment_id" => $commentId, "course_id" => $courseId, "video_id" => $videoId, "content" => $content, "create_time" => $time);
$commentModel = new CommentModel();
$id = $commentModel->insertComment($comment);
if ($id) {
$userModel = new UserModel();
$videoModel = new VideoModel();
$courseModel = new CourseModel();
$author = $userModel->getUser($comment['uid']);
$comment['create_time_fmt'] = Common_Time::flow($comment['create_time']);
$comment['author_uid'] = $author['stuff_id'];
$comment['author_name'] = $author['stuff_name'];
$comment['author_avator'] = $author['avator'];
if ($comment['comment_id']) {
$parentComment = $commentModel->getComment($comment['comment_id']);
$beReplyAuthor = $userModel->getUser($parentComment['uid']);
$parentComment['author_uid'] = $beReplyAuthor['stuff_id'];
$parentComment['author_name'] = $beReplyAuthor['stuff_name'];
$parentComment['author_avator'] = $beReplyAuthor['avator'];
$parentComment['create_time_fmt'] = Common_Time::flow($parentComment['create_time']);
$comment['parent_comment'] = $parentComment;
}
if ($comment['video_id']) {
$section = $videoModel->getVideoBelongSection($comment['video_id']);
if (!$section) {
$practiseModel = new PractiseModel();
$practise = $practiseModel->getVideoBelongPractise($comment['video_id'], $courseId);
$comment['practise_seq'] = $practise['seq'];
$section = $courseModel->getSection($practise['section_id']);
}
$chapter = $courseModel->getSection($section["parent_id"]);
$comment["chapter_id"] = $chapter["id"];
$comment["chapter_name"] = $chapter["name"];
$comment["chapter_seq"] = $chapter["seq"];
$comment["section_id"] = $section["id"];
$comment["section_name"] = $section["name"];
$comment["section_seq"] = $section["seq"];
$userVideo = $videoModel->getUserVideoVote($comment['uid'], $comment['video_id']);
$comment["video_like"] = isset($userVideo['like_type']) ? $userVideo['like_type'] : 0;
}
$this->displayJson(Common_Error::ERROR_SUCCESS, array($comment));
}
$this->displayJson(Common_Error::ERROR_MYSQL_EXECUTE);
}
public function getArticleById()
{
$errors = $this->errors;
$articleId = $_GET['articleId'];
//实例化Model
$adminModel = new AdminModel();
//博主
$articleModel = new ArticleModel();
//文章
$articleTypeModel = new ArticleTypeModel();
//文章分类
$articleTagModel = new ArticleTagModel();
//文章标签
$commentModel = new CommentModel();
//评论
$collectModel = new CollectModel();
//文章收藏
//获取所有文章分类
$allTypes = $articleTypeModel->getCatrgoryByAdminId($_SESSION['admin']['adminId']);
$allTypes = formatkey($allTypes, 'typeId');
//设置typeId主键
//获取所有文章标签
$allTags = $articleTagModel->getArticleTag();
$allTags = formatkey($allTags, 'tagId');
//设置typeId主键
$articleInfo = $articleModel->getArticleById($articleId);
if ($articleInfo['tagId']) {
$articleInfo['tagId'] = explode(',', trim($value['tagId'], ','));
}
//查询评论数
$articleInfo['commentCount'] = $commentModel->getCommentCountByArticleId($articleId);
//查询收藏数
$articleInfo['collectCount'] = $collectModel->getCollectCountByArticleId($articleId);
//获取最新的评论
$comment = $commentModel->getComment($articleId, '0,2');
//博主信息
$adminInfo = $adminModel->getAdminById($_SESSION['admin']['adminId']);
$this->assign("admin", $adminInfo);
//文章
$this->assign("article", $articleInfo);
//文章
$this->assign("allTags", $allTags);
//所有文章标签
$this->assign("allTypes", $allTypes);
//某人所有文章分类
$this->assign("comment", $comment);
//某人所有文章分类
}
public function articleInfo()
{
//实例化Model
$articleModel = new ArticleModel();
//文章
$commentModel = new CommentModel();
//评论
$collectModel = new CollectModel();
//文章收藏
$articleId = Data::get($_GET['articleId'], Data::Int);
if (!is_int($articleId) && $articleId <= 0) {
R('Index', 'index');
}
$articleModel->setIncArticleByHitNum($articleId);
//文章信息
$content = $articleModel->getArticleById($articleId);
//文章评论数
$commentNum = $commentModel->getCommentCountByArticleId($articleId);
$content['commentNum'] = $commentNum;
//文章收藏数
$collectNum = $collectModel->getCollectCountByarticleId($articleId);
$content['collectNum'] = $collectNum;
//是否已经收藏
$if_collect = 0;
if ($_SESSION['qq']) {
if ($collectModel->getCollects($articleId, $_SESSION['qq']['userId'])) {
$if_collect = 1;
}
}
//评论查询
$comments = $commentModel->getComment($articleId);
//用户个人信息
$allUserInfo = $this->getAllUserInfo();
//博主个人信息
$blogerInfo = $this->getBlogerInfo($content['adminId']);
//获取所有文章分类
$allTypes = $this->getAllTypes($content['adminId']);
//获取所有文章标签
$allTags = $this->getAllTags();
//文章总数
$count = $this->articleCount($content['adminId']);
//最新三条评论
$latestComments = $this->getLatestComments($content['adminId'], '0,3');
$this->assign('count', $count);
//某博主文章总数
$this->assign("allTags", $allTags);
//所有文章标签
$this->assign("allTypes", $allTypes);
//某人所有文章分类
$this->assign('blogerInfo', $blogerInfo);
//某博主信息
$this->assign('allUserInfo', $allUserInfo);
//某用户信息
$this->assign('latestComments', $latestComments);
//最新三条评论
$this->assign('if_collect', $if_collect);
//是否已经收藏
$this->assign('article', $content);
//文章详情
$this->assign('comments', $comments);
$this->display();
}
