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
));
*/
}
