Example #1
0
 public function likable()
 {
     $user_id = User::getCurrentUserId();
     //Check if the media was already liked by the user
     $like = Like::where('media_id', $this->id)->where('user_id', $user_id)->first();
     return !(bool) $like;
 }
Example #2
0
 public function update($id)
 {
     $like = new Like();
     $user = Auth::user();
     $id = Input::only('story_id');
     $like->where('user_id', Auth::id)->where('story_id', $id)->first()->delete();
     return Redirect::back();
 }
Example #3
0
 public function removeLike($entry_id)
 {
     $user = JWTAuth::parseToken()->authenticate();
     $newLike['entry_id'] = $entry_id;
     $newLike['user_id'] = $user->id;
     if (Like::where(['entry_id' => $newLike['entry_id'], 'user_id' => $newLike['user_id']])->exists()) {
         Like::where(['entry_id' => $newLike['entry_id'], 'user_id' => $newLike['user_id']])->delete();
     } else {
         abort(403, 'Like is not registered');
     }
 }
Example #4
0
 public function viewReadAll()
 {
     // Set logged in user to a variable.
     $authUser = Auth::user();
     // Find user's likes in database.
     $likes = Like::where('user_id', '=', $authUser->id)->latest('id')->get();
     // Find all photos in the database.
     $photos = Photo::all();
     // Return view with variables.
     return view('likes.viewReadAll')->with('likes', $likes)->with('authUser', $authUser)->with('photos', $photos);
 }
 public function postLike(\Illuminate\Http\Request $request)
 {
     $id = e($request->input('id'));
     $course = Course::findOrFail($id);
     if (Like::where('course', '=', $id)->where('user', '=', \Auth::user()->id)->exists()) {
         $course->likes--;
         $like = Like::where('course', '=', $id)->where('user', '=', \Auth::user()->id)->first();
         $like->delete();
     } else {
         $course->likes++;
         $like = new Like();
         $like->course = $id;
         $like->user = Auth::user()->id;
         $like->save();
     }
     $course->save();
     return view::make('courses.liked', compact('course'));
 }
Example #6
0
 public function getEntries($challengeType, $challenge_id)
 {
     try {
         $userToken = JWTAuth::parseToken()->authenticate();
         $signed_in = true;
     } catch (\Exception $e) {
         $signed_in = false;
     }
     $challenge = Challenge::find($challenge_id);
     $entries = $challenge->entries;
     if ($entries) {
         foreach ($entries as $entry) {
             $user = $entry->user;
             unset($entry->challenge_id);
             unset($entry->created_at);
             unset($entry->updated_at);
             unset($entry->user);
             $entry->userPic = $user->userPic;
             $entry->userName = $user->name;
             $entry->category = $challenge->isWeekly ? 'weekly' : 'monthly';
             $entry->likes = $entry->likesCount();
             if ($signed_in) {
                 $likes = Like::where('user_id', $userToken->id)->get();
                 foreach ($likes as $like) {
                     if ($like->entry_id == $entry->id) {
                         $entry->liked = true;
                     } else {
                         $entry->liked = false;
                     }
                 }
             }
         }
         return $challenge;
     } else {
         return false;
     }
 }
Example #7
0
 public function userLike(User $user)
 {
     $like = Like::where('user_id', $user->id)->where('post_id', $this->id)->first();
     return $like;
 }
 public static function hasLiked($iFromWhereID, $iToUserID, $iUserID, $iLikeFromType, $iLikeFromID)
 {
     $oResult = Like::where($iFromWhereID, $iLikeFromID)->where('to_user_id', $iToUserID)->where('from_user_id', $iUserID)->where('status', Like::LIKE_STATUS_ACTIVE)->get();
     if ($oResult->first()) {
         return $oResult->first()->toArray();
     } else {
         return false;
     }
 }
Example #9
0
 /**
  * Toggle tattoo like
  *
  * @return View
  */
 public function like(Request $request)
 {
     $res = array();
     $res['success'] = false;
     $tattooId = $request->input('id');
     $user = Auth::user();
     if ($user->likes()->where('tattoo_id', $tattooId)->count()) {
         $like = Like::where('tattoo_id', $tattooId)->where('user_id', $user->id)->first();
         if ($like) {
             //already liked so unlike now(delete)
             $like->delete();
             $res['data'] = 'Like';
             //unlike success now show Like
             $res['success'] = true;
             $res['likeCount'] = Like::where('tattoo_id', $tattooId)->count();
         }
     } else {
         $like = new Like();
         $like->tattoo_id = $tattooId;
         $like->user_id = $user->id;
         if ($like->save()) {
             $res['data'] = 'Unlike';
             //like success now show Unlike
             $res['success'] = true;
             $res['likeCount'] = Like::where('tattoo_id', $tattooId)->count();
         }
     }
     return $res;
 }
Example #10
0
 function setLikeDislike(Request $request)
 {
     $user = Session::get('user');
     if (!isset($user)) {
         return Redirect::back();
     }
     if (Like::where('user_id', $user[5])->where('review_id', $request->review_id)->exists()) {
         Like::where('user_id', $user[5])->where('review_id', $request->review_id)->update(['likeOrDislike' => $request->likeOrDislike]);
     } else {
         $likes = new Like();
         $likes->user_id = $user[5];
         $likes->review_id = $request->review_id;
         $likes->likeOrDislike = $request->likeOrDislike;
         $likes->save();
     }
     return redirect('/relogin');
 }
 function get_comments_by_photo_id()
 {
     $iFromType = Input::get('from_type');
     $iFromID = Input::get('from_id');
     $aLoggedInUser = User::where('id', Session::get('user')['id'])->first()->toArray();
     switch ($iFromType) {
         case Comment::COMMENT_FROM_TYPE_USER:
             $aFromItem = User::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_USER)->where('user_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('user_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         case Comment::COMMENT_FROM_TYPE_CHARACTER:
             $aFromItem = Character::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_CHARACTER)->where('character_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('character_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         case Comment::COMMENT_FROM_TYPE_FAMILY:
             $aFromItem = Family::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_FAMILY)->where('family_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('family_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         case Comment::COMMENT_FROM_TYPE_SPECY:
             $aFromItem = Specy::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_SPECY)->where('specy_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('specy_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         case Comment::COMMENT_FROM_TYPE_PHOTO:
             $aFromItem = Photo::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_PHOTO)->where('photo_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('photo_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         case Comment::COMMENT_FROM_TYPE_POST:
             $aFromItem = Post::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_POST)->where('post_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('post_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         case Comment::COMMENT_FROM_TYPE_MATE:
             $aFromItem = Mate::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_MATE)->where('mate_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('mate_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
         default:
             $aFromItem = User::where('id', $iFromID)->first()->toArray();
             $oItemLikers = Like::where('like_type', Like::LIKE_TYPE_USER)->where('user_id', $aFromItem['id'])->where('status', Like::LIKE_STATUS_ACTIVE)->get();
             $aFromItem['likers'] = is_array($oItemLikers->toArray()) && count($oItemLikers->toArray()) ? $oItemLikers->toArray() : [];
             $aFromItem['logged_in_user']['has_liked'] = LikesController::checkHasLikedInArray($aFromItem['likers'], $aLoggedInUser['id']);
             $oComments = Comment::where('user_id', $iFromID)->where('status', Comment::COMMENT_STATUS_DEFAULT)->get();
             break;
     }
     $oComments = is_array($oComments->toArray()) && count($oComments->toArray() > 0) ? $oComments->toArray() : [];
     $aComments = null;
     $iFromWhereID = null;
     for ($i = 0; $i < count($oComments); $i++) {
         $aComments[$i] = $oComments[$i];
         $aComments[$i]['from_user'] = User::where('id', $oComments[$i]['from_user_id'])->first()->toArray();
         if ($oComments[$i]['comment_photo_id'] > 0) {
             $aComments[$i]['photo_comment'] = Photo::where('id', $oComments[$i]['comment_photo_id'])->first()->toArray();
         }
         $iFromType = $oComments[$i]['comment_from_type'];
         switch ($iFromType) {
             case Comment::COMMENT_FROM_TYPE_USER:
                 $iFromWhereID = "user_id";
                 $aComments[$i]['from'] = User::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             case Comment::COMMENT_FROM_TYPE_CHARACTER:
                 $iFromWhereID = "character_id";
                 $aComments[$i]['from'] = Character::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             case Comment::COMMENT_FROM_TYPE_FAMILY:
                 $iFromWhereID = "family_id";
                 $aComments[$i]['from'] = Family::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             case Comment::COMMENT_FROM_TYPE_SPECY:
                 $iFromWhereID = "specy_id";
                 $aComments[$i]['from'] = Specy::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             case Comment::COMMENT_FROM_TYPE_PHOTO:
                 $iFromWhereID = "photo_id";
                 $aComments[$i]['from'] = Photo::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             case Comment::COMMENT_FROM_TYPE_POST:
                 $iFromWhereID = "post_id";
                 $aComments[$i]['from'] = Post::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             case Comment::COMMENT_FROM_TYPE_MATE:
                 $iFromWhereID = "mate_id";
                 $aComments[$i]['from'] = Mate::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
             default:
                 $iFromWhereID = "user_id";
                 $aComments[$i]['from'] = User::where('id', $oComments[$i][$iFromWhereID])->first()->toArray();
                 break;
         }
     }
     $view = view('users.comments.show')->with('aComments', $aComments);
     $htmlFromWhatView = view('users.comments.partials.partial-comment-from-what-display')->with('aFromItem', $aFromItem)->with('iFromType', $iFromType);
     if ($oComments) {
         return response()->json(['view' => (string) $view, 'status' => true, 'message' => "Successfully archived character", 'what_to_display' => (string) $htmlFromWhatView]);
     } else {
         $htmlFromWhatView = view('users.comments.partials.partial-comment-from-what-display')->with('aFromItem', $aFromItem)->with('iFromType', $iFromType);
         $view = view('users.comments.show')->with('aComments', []);
         if ($htmlFromWhatView != "") {
             return response()->json(['view' => (string) $view, 'status' => true, 'message' => "Successfully archived character", 'what_to_display' => (string) $htmlFromWhatView]);
         } else {
             echo json_encode(array('status' => false, 'message' => "Something went wrong. Please try again later"));
         }
     }
     die;
 }
Example #12
0
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($user_id, $tweet_id)
 {
     $like = Like::where('user_id', $user_id)->where('tweet_id', $tweet_id);
     $like->delete();
     return redirect()->back();
 }
Example #13
0
 public function getLikesCountAttribute()
 {
     return Like::where('user_id', $this->id)->count();
 }
 public function destroy($id)
 {
     $comment = Comment::where('form_id', $id)->delete();
     $form = Form::where('id', $id)->delete();
     $like = Like::where('form_id', $id)->delete();
     return redirect('/form');
 }
Example #15
0
 public function is_liked_by($user)
 {
     return Like::where('tweet_id', $this->id)->where('user_id', $user->id)->first();
 }
 public function get_details()
 {
     $iLimit = 10;
     $iOffset = 0;
     if (Input::get('iOffset')) {
         $iOffset = Input::get('iOffset');
     }
     $htmlView = "";
     $bLoggedInUser = Session::has('user');
     if ($bLoggedInUser) {
         $aLoggedInUser['user'] = User::where('id', Session::get('user')['id'])->first()->toArray();
         $aLoggedInUser['current_character'] = Character::where('id', $aLoggedInUser['user']['current_character_id'])->first()->toArray();
     }
     //$aMate = Mate::query("SELECT * FROM mates WHERE ((from_user_id = 10 OR to_user_id = 10) AND (status = 8 OR status = 9))")->get()->toArray();
     $aMates = DB::select(DB::raw("SELECT * FROM mates WHERE ((from_user_id = " . $aLoggedInUser['user']['id'] . " OR to_user_id = " . $aLoggedInUser['user']['id'] . ") AND (status = " . Mate::MATE_STATUS_ACCEPTED_BY_ADMIN . " OR status = " . Mate::MATE_STATUS_ACCEPTED_BY_USER . "))"));
     $aUserID = [];
     $sUserIDS = "";
     foreach (json_decode(json_encode($aMates), true) as $aMate) {
         if ($aMate['from_user_id'] != $aLoggedInUser['user']['id']) {
             $aUserID[] = $aMate['from_user_id'];
             $sUserIDS = $sUserIDS . $aMate['from_user_id'] . ", ";
         } else {
             $aUserID[] = $aMate['to_user_id'];
             $sUserIDS = $sUserIDS . $aMate['to_user_id'] . ", ";
         }
     }
     $sUserIDS = substr($sUserIDS, 0, -2);
     /* $aData = DB::select(DB::raw("SELECT characters.*, comments.*, likes.*, mates.*, posts.*, users.* FROM users
        LEFT JOIN characters on users.id = characters.user_id
        LEFT JOIN comments on (characters.user_id = comments.from_user_id OR characters.user_id = comments.to_user_id)
        LEFT JOIN likes on (comments.from_user_id = likes.from_user_id OR comments.from_user_id = likes.to_user_id OR comments.to_user_id = likes.from_user_id OR comments.to_user_id = likes.to_user_id)
        LEFT JOIN mates on (likes.from_user_id = mates.from_user_id OR likes.from_user_id = mates.to_user_id OR likes.to_user_id = mates.from_user_id OR likes.to_user_id = mates.to_user_id)
        LEFT JOIN posts on (likes.from_user_id = posts.from_user_id OR likes.from_user_id = posts.to_user_id OR likes.to_user_id = posts.from_user_id OR likes.to_user_id = posts.to_user_id OR likes.from_user_id = posts.user_id OR likes.to_user_id = posts.user_id)
        WHERE users.id = " . $aLoggedInUser['user']['id'] . "
        ORDER BY comments.date_updated, likes.date_updated, likes.date_updated, mates.date_updated, posts.date_updated ASC"));*/
     $oUpdates = DB::select(DB::raw("SELECT * FROM updates WHERE\n                                    status = " . Update::UPDATE_STATUS_ACTIVE . " OR\n                                    status = " . Update::UPDATE_STATUS_ACTIVATED_BY_USER . " OR\n                                    status = " . Update::UPDATE_STATUS_ACTIVATED_BY_ADMIN . " AND\n                                    user_id IN (" . $sUserIDS . ")\n                                    ORDER BY id DESC\n                                    LIMIT {$iOffset}, {$iLimit}"));
     $aUpdates = json_decode(json_encode($oUpdates), true);
     for ($i = 0; $i < count($aUpdates); $i++) {
         $aUpdates[$i]['user'] = User::where('id', $aUpdates[$i]['user_id'])->first()->toArray();
         switch ($aUpdates[$i]['update_type']) {
             case Update::UPDATE_TYPE_USER:
                 break;
             case Update::UPDATE_TYPE_SPECY:
                 break;
             case Update::UPDATE_TYPE_FAMILY:
                 break;
             case Update::UPDATE_TYPE_CHARACTER:
                 $aUpdates[$i]['character'] = Character::where('id', $aUpdates[$i]['character_id'])->first()->toArray();
                 break;
             case Update::UPDATE_TYPE_MATE:
                 break;
             case Update::UPDATE_TYPE_COMMENT:
                 $aUpdates[$i]['comment'] = Comment::where('id', $aUpdates[$i]['comment_id'])->first()->toArray();
                 $aUpdates[$i]['comment']['from_user'] = User::where('id', $aUpdates[$i]['comment']['from_user_id'])->first()->toArray();
                 $aUpdates[$i]['comment']['to_user'] = User::where('id', $aUpdates[$i]['comment']['to_user_id'])->first()->toArray();
                 switch ($aUpdates[$i]['comment']['comment_from_type']) {
                     case Comment::COMMENT_FROM_TYPE_USER:
                         break;
                     case Comment::COMMENT_FROM_TYPE_CHARACTER:
                         break;
                     case Comment::COMMENT_FROM_TYPE_FAMILY:
                         break;
                     case Comment::COMMENT_FROM_TYPE_SPECY:
                         break;
                     case Comment::COMMENT_FROM_TYPE_PHOTO:
                         $aUpdates[$i]['comment']['photo'] = Photo::where('id', $aUpdates[$i]['comment']['photo_id'])->first()->toArray();
                         break;
                     case Comment::COMMENT_FROM_TYPE_POST:
                         break;
                     case Comment::COMMENT_FROM_TYPE_MATE:
                         break;
                 }
                 $htmlView = $htmlView . (string) view('users.pages.partials.comment-show')->with('aUpdate', $aUpdates[$i]);
                 break;
             case Update::UPDATE_TYPE_PHOTO:
                 break;
             case Update::UPDATE_TYPE_LIKE:
                 $aUpdates[$i]['like'] = Like::where('id', $aUpdates[$i]['like_id'])->first()->toArray();
                 break;
             case Update::UPDATE_TYPE_POST:
                 $aUpdates[$i]['post'] = Post::where('id', $aUpdates[$i]['post_id'])->first()->toArray();
                 break;
         }
     }
     return response()->json(['status' => true, 'message' => "Successfully submitted comment", 'view' => (string) $htmlView]);
 }
Example #17
0
 public function getUnlikeCountAttribute()
 {
     return Like::where('proposal_id', $this->id)->where('like', 0)->count();
 }
Example #18
0
 public function storeLike(Request $request, $name)
 {
     $data = $request->all();
     if ($data['like'] == "true") {
         $data['like'] = true;
     } else {
         $data['like'] = false;
     }
     $data['user_id'] = Auth::user()->id;
     //CHECK WHETHER LIKED OR DISLIKED AND REACT ACCORDINGLY
     $likeObject = new Like();
     $isLike = $likeObject->isLike($data['user_id'], $data['post_id']);
     $isDislike = $likeObject->isDislike($data['user_id'], $data['post_id']);
     if (!$isLike && !$isDislike) {
         //if not liked and not disliked
         Like::create($data);
     } elseif ($isLike && !$isDislike && $data['like'] == true) {
         //already liked,not disliked,pressed like button
         //dd("already liked,not disliked,pressed like button");
         Like::where(['post_id' => $data['post_id'], 'user_id' => $data['user_id']])->delete();
     } elseif ($isLike && !$isDislike && $data['like'] == false) {
         //already liked,not disliked,but pressed dislike button
         //dd("already liked,not disliked,but pressed dislike button");
         Like::where(['post_id' => $data['post_id'], 'user_id' => $data['user_id']])->update(array('like' => false));
     } elseif (!$isLike && $isDislike && $data['like'] == true) {
         //not liked,already disliked,but pressed like button
         //dd("not liked,already disliked,but pressed like button");
         Like::where(['post_id' => $data['post_id'], 'user_id' => $data['user_id']])->update(array('like' => true));
     } elseif (!$isLike && $isDislike && $data['like'] == false) {
         //not liked,already disliked,but pressed dislike button
         //dd("not liked,already disliked,but pressed dislike button");
         Like::where(['post_id' => $data['post_id'], 'user_id' => $data['user_id']])->delete();
     }
     $post = Post::find($data['post_id']);
     $countLikeDislike = null;
     $countLikeDislike['likes'] = $post->Likes()->count();
     $countLikeDislike['dislikes'] = $post->Dislikes()->count();
     $countLikeDislike['icon_flag'] = $data['like'];
     return $countLikeDislike;
 }
Example #19
0
 public function likeUnlike($id, $action)
 {
     //Get Proposal
     $proposal = $this->proposalsRepository->find($id);
     //Get User
     if (!Auth::check()) {
         // The user is not logged in...
         // Retrieve UUID from Cookie
         $user_id = null;
         $unique = Cookie::get('uuid');
     } else {
         //Retrieve UUID from User
         $user_id = Auth::user()->id;
         $unique = Auth::user()->uuid;
     }
     //Possible Values: Null, 0 or 1
     $existing_like = Like::where('uuid', $unique)->where('proposal_id', $id)->value('like');
     switch ($existing_like) {
         // Already Unliked
         case '0':
             switch ($action) {
                 case 'like':
                     Like::where('uuid', $unique)->where('proposal_id', $id)->update(['like' => $action == 'like']);
                     Session::flash('flash_msg', 'Você voltou a curtir essa Ideia Legislativa!');
                     break;
                 case 'unlike':
                     Session::flash('error_msg', 'Você já deixou de curtir essa Ideia Legislativa!');
                     break;
             }
             break;
             // Already Liked
         // Already Liked
         case '1':
             switch ($action) {
                 case 'like':
                     Session::flash('error_msg', 'Você já curtiu essa Ideia Legislativa!');
                     break;
                 case 'unlike':
                     Like::where('uuid', $unique)->where('proposal_id', $id)->update(['like' => $action == 'like']);
                     Session::flash('flash_msg', 'Você deixou de curtir essa Ideia Legislativa!');
                     break;
             }
             break;
             // New Like
         // New Like
         case null:
             //dd($existing_like, $action, $str_action);
             Like::create(['user_id' => $user_id, 'uuid' => $unique, 'proposal_id' => $proposal->id, 'like' => $action == 'like', 'ip_address' => Request::ip()]);
             $approval_url = route('proposal.approval', $id);
             $msg = 'Sua curtida foi computada com sucesso. Caso queira apoiar oficialmente esta proposta, <a href="' . $approval_url . '">clique aqui</a>.';
             Session::flash('flash_msg', $msg);
             break;
     }
     return redirect()->back();
 }