public function reply() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); // $receiver_id = Input::get('receiver_id'); $com_id = Input::get('com_id'); $content = Input::get('content'); // $receiver = User::find($receiver_id); // if(!isset($receiver)) // return Response::json(array('errCode'=>2, 'message'=>'[数据库中没有receiver_id对应的user]被评论者不存在')); if (empty($content)) { return Response::json(array('errCode' => 3, 'message' => '[content没有内容]请填写评论论文!')); } $join_com = ArticleJoinCom::find($com_id); if (!isset($join_com)) { return Response::json(array('errCode' => 4, 'message' => '[com_id对应的评论不存在]你回复的评论不存在!')); } //新增回复 $reply = new ArticleJoinReply(); $reply->receiver_id = $join_com->sender_id; $reply->sender_id = $user->id; $reply->com_id = $com_id; $reply->content = $content; if (!$reply->save()) { return Response::json(array('errCode' => 5, 'message' => '[数据库问题]回复失败!')); } return Response::Json(array('errCode' => 0, 'message' => '回复成功!')); }
public function dUserNotice() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); $join_coms = ArticleJoinCom::where('receiver_id', '=', $user->id)->where('is_delete', '=', 0)->get(); $replys = ArticleJoinReply::where('receiver_id', '=', $user->id)->where('is_delete', '=', 0)->get(); try { DB::transaction(function () use($replys, $join_coms) { if (count($join_coms) != 0) { foreach ($join_coms as $com) { $com->is_delete = 1; $com->save(); } } if (count($replys) != 0) { foreach ($replys as $reply) { $reply->is_delete = 1; $reply->save(); } } }); } catch (\Exception $e) { return Response::json(array('errCode' => 11, '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 run() { ArticleJoinReply::create(['com_id' => 1, 'sender_id' => 1, 'receiver_id' => 2, 'content' => '阿登这是你评论的']); ArticleJoinReply::create(['com_id' => 2, 'sender_id' => 2, 'receiver_id' => 1, 'content' => '阿登这是你评论的']); ArticleJoinReply::create(['com_id' => 3, 'sender_id' => 1, 'receiver_id' => 2, 'content' => '阿登这是你评论的']); // ArticleJoinReply::create([ // 'com_id' =>4, // 'sender_id' => 2, // 'receiver_id'=> 1, // 'content' => '阿登这是你评论的' // ]); // ArticleJoinReply::create([ // 'com_id' =>1, // 'sender_id' => 5, // 'receiver_id'=> 1, // 'content' => '阿登这是你评论的' // ]); // ArticleJoinReply::create([ // 'com_id' =>1, // 'sender_id' => 5, // 'receiver_id'=> 2, // 'content' => '阿登这是你评论的' // ]); // ArticleJoinReply::create([ // 'com_id' =>1, // 'sender_id' => 5, // 'receiver_id'=> 3, // 'content' => '阿登这是你评论的' // ]); // ArticleJoinReply::create([ // 'com_id' =>1, // 'sender_id' => 5, // 'receiver_id'=> 4, // 'content' => '阿登这是你评论的' // ]); }