public function run() { ArticleJoinCom::create(['sender_id' => 2, 'receiver_id' => 1, 'join_id' => 1, 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘']); ArticleJoinCom::create(['sender_id' => 1, 'receiver_id' => 2, 'join_id' => 2, 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘']); ArticleJoinCom::create(['sender_id' => 2, 'receiver_id' => 1, 'join_id' => 3, 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘']); // ArticleJoinCom::create([ // 'sender_id'=>5, // 'receiver_id'=>1, // 'join_id' => 1, // 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘', // ]); // ArticleJoinCom::create([ // 'sender_id'=>5, // 'receiver_id'=>2, // 'join_id' => 1, // 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘', // ]); // ArticleJoinCom::create([ // 'sender_id'=>5, // 'receiver_id'=>3, // 'join_id' => 1, // 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘', // ]); // ArticleJoinCom::create([ // 'sender_id'=>5, // 'receiver_id'=>1, // 'join_id' => 2, // 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘', // ]); // ArticleJoinCom::create([ // 'sender_id'=>5, // 'receiver_id'=>2, // 'join_id' => 2, // 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘', // ]); // ArticleJoinCom::create([ // 'sender_id'=>5, // 'receiver_id'=>3, // 'join_id' => 2, // 'content' => '我灯儿的飘,我灯二的飘飘飘飘飘', // ]); }
public function dUserReply() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); $reply_id = Input::get('reply_id'); if (!isset($reply_id)) { return Response::json(array('errCode' => 2, 'message' => '请传入评论的id')); } $reply = ArticleJoinCom::find($reply_id); if (!isset($reply)) { return Response::json(array('errCode' => 3, 'message' => '该评论不存在')); } $reply->is_delete = 1; if (!$reply->save()) { return Response::json(array('errCode' => 4, 'message' => '[服务器错误]')); } return Response::json(array('errCode' => 0, 'message' => '删除成功')); }
public function brefUser() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); // $user = User::find(5); // Auth::login(); // dd($user); $per_page = Input::get('per_page'); $page = Input::get('page'); $join_coms = ArticleJoinCom::where('receiver_id', '=', $user->id)->where('is_delete', '=', 0)->orderBy('created_at', 'desc')->get(); if (count($join_coms) != 0) { foreach ($join_coms as $com) { $com_sender = User::find($com->sender_id); $com->avatar = $com_sender->avatar; $com->username = $com_sender->username; $com->type = "comment"; } } $replys = ArticleJoinReply::where('receiver_id', '=', $user->id)->where('status', '=', 0)->where('is_delete', '=', 0)->orderBy('created_at', 'desc')->get(); if (count($replys) != 0) { foreach ($replys as $reply) { $reply->join_id = ArticleJoinCom::where('id', '=', $reply->com_id)->first()->join_id; $reply_sender = User::find($reply->sender_id); $reply->avatar = $reply_sender->avatar; $reply->username = $reply_sender->username; $reply->type = "reply"; } } $notices = array_merge($join_coms->toArray(), $replys->toArray()); //总页数 $total = ceil(count($notices) / $per_page); //排序 $notices = StaticController::arraySortByCreatedAt($notices); //分页 $notices = StaticController::page($per_page, $page, $notices); // dd(count($notices)); return Response::json(array('errCode' => 0, 'message' => '返回回复者头像和名字', 'notices' => $notices, 'total' => $total)); }
public function involve() { //参与话题内容 $join_id = Input::get('join_id'); $article_join = ArticleJoin::find($join_id); if (!isset($article_join)) { return Response::json(array('errCode' => 1, 'message' => '没有该参与话题内容!')); } $article_join_parts = ArticleJoinPart::where('join_id', '=', $join_id)->orderBy('id', 'asc')->get(); foreach ($article_join_parts as $part) { if ($part->type == 'url') { $part->img = StaticController::imageWH($part->content); } } //评论内容 $per_page = Input::get('per_page'); $page = Input::get('page'); $join_coms = ArticleJoinCom::where('join_id', '=', $join_id)->with(['replies' => function ($query) { $query->select('com_id', 'content', 'sender_id')->orderBy('id', 'asc'); }, 'sender' => function ($query) { $query->select('id', 'username', 'avatar'); }, 'replies.sender' => function ($query) { $query->select('id', 'username'); }])->get(); foreach ($join_coms as $join_com) { $user = $join_com->sender; $join_com->username = $user->username; $join_com->avatar = $user->avatar; $join_com->replys = $join_com->replies; if (count($join_com->replys) != 0) { foreach ($join_com->replys as $reply) { // dd($reply); $reply->reply_name = $reply->sender->username; unset($reply->sender); } } unset($join_com->replies); unset($join_com->sender); } // //总页数 $total = ceil(count($join_coms) / $per_page); // //文章 $join_coms = StaticController::page($per_page, $page, $join_coms); // $join_coms = DB::table('article_join_coms')->where('join_id', '=', $join_id)->get(); // //总页数 // $total = ceil(count($join_coms)/$per_page); // //文章 // $join_coms = StaticController::page($per_page,$page,$join_coms); // if( $join_coms ) // { // foreach($join_coms as $join_com) // { // $join_com->username = User::find($join_com->sender_id)->username; // $join_com->avatar = User::find($join_com->sender_id)->avatar; // $join_com->replys = ArticleJoinReply::where('com_id', '=', $join_com->id)->orderBy('id','asc')->get(); // if(count($join_com->replys)!=0) // { // foreach($join_com->replys as $reply) // { // $reply->reply_name = User::find($reply->sender_id)->username; // } // } // } // } //是否喜欢 $type = $this->isJoinLike($join_id); if ($page == 1) { return Response::json(array('errCode' => 0, 'message' => '返回参与话题详情', 'article_join' => $article_join, 'article_join_parts' => $article_join_parts, 'join_coms' => $join_coms, 'total' => $total, 'type' => $type)); } else { return Response::json(array('errCode' => 0, 'message' => '返回参与话题详情', 'join_coms' => $join_coms, 'total' => $total, 'type' => $type)); } }
public function dreply() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); $reply_id = Input::get('reply_id'); $reply = ArticleJoinCom::find($reply_id); if (!isset($reply)) { return Response::Json(array('errCode' => 2, 'message' => '[reply_id对应的回复不存在]此回复不存在!')); } if ($reply->sender_id != $user->id) { return Response::Json(array('errCode' => 3, 'message' => '[权限不够]不可删除别人的回复!')); } if (!$reply->delete()) { return Response::json(array('errCode' => 4, 'message' => '[数据库错误]删除失败')); } return Response::json(array('errCode' => 0, 'message' => '删除成功')); }
public function joinComs() { $paginator = ArticleJoinCom::select('id', 'content', 'sender_id', 'created_at')->where('join_id', Input::get('join_id'))->with(['sender' => function ($query) { $query->select('id', 'username', 'avatar'); }, 'replies' => function ($query) { $query->select('com_id', 'content', 'sender_id'); }, 'replies.sender' => function ($query) { $query->select('id', 'username'); }])->orderBy('created_at', 'desc')->paginate((int) Input::get('per_page')); $join_coms = $paginator->getCollection(); foreach ($join_coms as $comment) { $user = $comment->sender; $comment->username = $user->username; $comment->avatar = $user->avatar; foreach ($comment->replies as $reply) { $reply->reply_name = $reply->sender->username; unset($reply->com_id); unset($reply->sender); } unset($comment->sender); // unset 用户信息 } return Response::json(['errCode' => 0, 'message' => '返回参与话题详情', 'join_coms' => $join_coms, 'total' => $paginator->getTotal()]); /* $join_id = Input::get('join_id'); //评论内容 $per_page = Input::get('per_page'); $page = Input::get('page'); $join_coms = DB::table('article_join_coms')->where('join_id', '=', $join_id)->orderBy('created_at','desc')->get(); //总页数 $total = ceil(count($join_coms) / $per_page); //文章 $join_coms = StaticController::page($per_page,$page,$join_coms); if( $join_coms ) { foreach($join_coms as $join_com) { $join_com->username = User::find($join_com->sender_id)->username; $join_com->avatar = User::find($join_com->sender_id)->avatar; $join_com->replys = ArticleJoinReply::where('com_id', '=', $join_com->id)->orderBy('id','asc')->get(); if(count($join_com->replys)!=0) { foreach($join_com->replys as $reply) { $reply->reply_name = User::find($reply->sender_id)->username; } } } } return Response::json(array('errCode'=>0, 'message'=>'返回参与话题详情', 'join_coms' => $join_coms, 'total' => $total )); */ }