Example #1
0
 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' => '删除成功'));
 }
Example #2
0
 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));
 }
Example #3
0
 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));
     }
 }