Esempio n. 1
0
 public function postLikepost()
 {
     $data = Input::all();
     $rules = ["post_id" => 'required|exists:posts,id'];
     $validator = Validator::make($data, $rules);
     if ($validator->fails()) {
         return 404;
     } else {
         $check_like = Like::check_like(Auth::user()->id, $data['post_id']);
         if ($check_like) {
             $unlike = Like::unlike(Auth::user()->id, $data['post_id']);
             if ($unlike) {
                 $total_like = Like::total_like($data['post_id']);
                 $total_like_text = $total_like ? $total_like . " people like this" : "";
                 return json_encode(["like" => "Like", "total_like" => $total_like_text]);
             } else {
                 return 404;
             }
         } else {
             $like = Like::like(Auth::user()->id, $data['post_id']);
             if ($like) {
                 $total_like = Like::total_like($data['post_id']);
                 $total_like_text = $total_like ? $total_like . " people like this" : "";
                 return json_encode(["like" => "Unlike", "total_like" => $total_like_text]);
             } else {
                 return 404;
             }
         }
     }
 }
Esempio n. 2
0
 /**
  * Get all data of post
  * @author Tran Van Moi
  * @since  2015/05/12
  * @return array
  */
 public static function get_all_posts($category_id, $keyword = "", $user_id = false)
 {
     $posts = DB::table('posts');
     $posts->join('users', 'posts.user_id', '=', 'users.id');
     $posts->select('posts.id', 'posts.title', 'posts.content', 'posts.image as image_post', 'posts.created_at', 'posts.updated_at', 'users.image', 'users.name as username', 'users.id as user_id');
     $posts->orderBy('created_at', 'desc');
     $posts->orderBy('updated_at', 'desc');
     if (is_numeric($category_id) && Category::find($category_id)) {
         $posts->where('posts.category_id', '=', $category_id);
     }
     if ($user_id) {
         $posts->where('posts.user_id', '=', $user_id);
     }
     $posts->where('posts.delete_status', '=', 0);
     if ($keyword != "") {
         $posts->where(function ($posts) use($keyword) {
             $posts->where('posts.title', 'like', '%' . $keyword . '%')->orWhere('posts.content', 'like', '%' . $keyword . '%')->orWhere('users.name', 'like', '%' . $keyword . '%');
         });
     }
     $posts = $posts->get();
     foreach ($posts as $key => $value) {
         $path = "./public/images/post/";
         if (File::exists($path . $value->image_post) && $value->image_post != "") {
             $posts[$key]->image_post = URL::to('/') . "/public/images/post/" . $value->image_post;
         } else {
             $posts[$key]->image_post = "";
         }
         $now = gmdate("Y-m-d G:i:s", time() + 7 * 3600);
         $date1 = new DateTime($now);
         $date = $value->updated_at > $value->created_at ? $value->updated_at : $value->created_at;
         $date2 = new DateTime($date);
         $interval = $date1->diff($date2);
         if ($interval->d) {
             $posts[$key]->time = date("F j, Y, g:i a", strtotime($date));
         } else {
             if ($interval->h) {
                 $posts[$key]->time = $interval->h . " hrs";
             } elseif ($interval->i) {
                 $posts[$key]->time = $interval->i . " mins";
             } else {
                 $posts[$key]->time = "Just now";
             }
         }
         unset($posts[$key]->created_at);
         unset($posts[$key]->updated_at);
         $url_image = "";
         if (filter_var($value->image, FILTER_VALIDATE_URL) === false) {
             $posts[$key]->image = URL::to('/') . "/public/images/avatar/" . $value->image;
         }
         $posts[$key]->like = Like::check_like(Auth::user()->id, $value->id);
         $posts[$key]->total_like = Like::total_like($value->id);
         $posts[$key]->comment = \DB::table('comments')->join('users', 'comments.user_id', '=', 'users.id')->select('comments.id', 'comments.content', 'comments.created_at', 'comments.updated_at', 'users.name as username', 'users.id as user_id', 'users.image')->where('comments.post_id', '=', $value->id)->where('comments.delete_status', '=', 0)->orderBy('comments.created_at', 'asc')->orderBy('comments.updated_at', 'asc')->get();
     }
     return $posts;
 }