/** * Add like on review, checkin or photo * * @param $request * @return mixed */ public function addAction(Request $request) { $data = $request->json()->get('Like'); $type = $data['type']; $type_id = $data['type_id']; $user_id = $data['user_id']; $user_data = Users::find($user_id); if (is_null($user_data)) { return showErrorResponse('Invalid user'); } $is_liked = Like::isLiked($user_id, $type, $type_id); if ($is_liked) { $like_count = Like::getCount($type, $type_id); $json_return[KeyParser::data] = array(KeyParser::type => $type, KeyParser::type_id => $type_id, KeyParser::user_id => $user_id, KeyParser::is_existing => CONSTANTS::LIKE_IS_EXISTING, KeyParser::like_count => $like_count); return response()->json($json_return); } switch ($type) { case CONSTANTS::REVIEW: $like_object = Reviews::find($type_id); $like_type = CONSTANTS::NOTIFICATION_TYPE_LIKE_REVIEW; if (!$like_object) { $status_code = CONSTANTS::ERROR_CODE_REVIEW_MISSING; } break; case CONSTANTS::CHECKIN: $like_object = CheckIns::find($type_id); $like_type = CONSTANTS::NOTIFICATION_TYPE_LIKE_CHECKIN; if (!$like_object) { $status_code = CONSTANTS::ERROR_CODE_CHECKIN_MISSING; } break; case CONSTANTS::PHOTO: $like_object = Photos::find($type_id); $like_type = CONSTANTS::NOTIFICATION_TYPE_LIKE_PHOTO; if (!$like_object) { $status_code = CONSTANTS::ERROR_CODE_PHOTO_MISSING; } break; default: return showErrorResponse('Invalid type', HTTP_ACCEPTED, CONSTANTS::ERROR_CODE_INVALID_TYPE); } if (!isset($like_object)) { return showErrorResponse('Invalid type id', HTTP_ACCEPTED, $status_code); } if (!Restaurants::isExists($like_object->restaurant_id)) { return showErrorResponse('Restaurant data not found', HTTP_ACCEPTED, CONSTANTS::ERROR_CODE_GENERAL); } try { $like_data = new Like(); $query_response = $like_data->addLike($type_id, $type, $user_id, $like_object, $like_type); } catch (\Exception $e) { return showErrorResponse($e->getMessage()); } $json_return[KeyParser::data] = array(KeyParser::type => $query_response->type, KeyParser::type_id => $query_response->type_id, KeyParser::user_id => $query_response->user_id, KeyParser::is_existing => CONSTANTS::LIKE_IS_NOT_EXISTING, KeyParser::like_count => Like::getCount($type, $type_id)); return response()->json($json_return); }
/** * Output JSON output of comments in a checkin * * @param $id * @return Response */ public function viewByCheckinAction($id) { $checkin = CheckIns::find($id); if (!$checkin) { return showErrorResponse('Checkin not found', HTTP_ACCEPTED, CONSTANTS::ERROR_CODE_CHECKIN_MISSING); } if (!Restaurants::isExists($checkin->restaurant_id)) { return showErrorResponse('Restaurant data not found', HTTP_ACCEPTED, CONSTANTS::ERROR_CODE_GENERAL); } $json_return = array(KeyParser::data => array(), KeyParser::comment_count => 0, KeyParser::page => array()); $comments = Comments::getByTypePaginate(CONSTANTS::CHECKIN, $id); if ($comments->count()) { foreach ($comments as $comment) { $json_return[KeyParser::data][] = array(KeyParser::comment => ModelFormatter::commentFormat($comment), KeyParser::user => Users::find($comment->user_id)); } $json_return[KeyParser::comment_count] = Comments::getCountByType(CONSTANTS::CHECKIN, $id); $json_return[KeyParser::page] = array(KeyParser::current => $comments->currentPage(), KeyParser::number => $comments->lastPage()); } return response()->json($json_return); }
function checkTypeId($type, $type_id) { switch ($type) { case CONSTANTS::REVIEW: $object = Reviews::find($type_id); $message = "Review does not exist"; $error_code = CONSTANTS::ERROR_CODE_REVIEW_MISSING; break; case CONSTANTS::CHECKIN: $object = CheckIns::find($type_id); $message = "Checkin does not exist"; $error_code = CONSTANTS::ERROR_CODE_CHECKIN_MISSING; break; case CONSTANTS::BOOKMARK: $object = Bookmarks::find($type_id); $message = "Bookmark does not exist"; $error_code = CONSTANTS::ERROR_CODE_GENERAL; break; case CONSTANTS::COMMENT: $object = Comments::find($type_id); $message = "Comment does not exist"; $error_code = CONSTANTS::ERROR_CODE_GENERAL; break; case CONSTANTS::PHOTO: $object = Photos::find($type_id); $message = "Photo does not exist"; $error_code = CONSTANTS::ERROR_CODE_PHOTO_MISSING; break; case CONSTANTS::RESTAURANT: $object = Restaurants::find($type_id); $message = "Restaurant does not exist"; $error_code = CONSTANTS::ERROR_CODE_GENERAL; break; case 'user': $object = Users::find($type_id); $message = "User does not exist"; $error_code = CONSTANTS::ERROR_CODE_GENERAL; break; default: return showErrorResponse('Invalid type', HTTP_ACCEPTED, CONSTANTS::ERROR_CODE_INVALID_TYPE); } if (!$object) { return showErrorResponse($message, HTTP_ACCEPTED, $error_code); } return false; }
/** * Delete a restaurant and all data associated with it * * @param Request $request * @return \Illuminate\Http\RedirectResponse */ public function deleteAction(Request $request) { try { $errors = array(); if (!$request->isMethod('POST')) { throw new Exception('Must be a POST request.'); } $is_ajax = $request->ajax(); $connection = DB::connection(); $connection->beginTransaction(); $restaurant_id = $request->input('id'); $restaurant = Restaurants::find($restaurant_id); if (!$restaurant) { throw new Exception('Restaurant not found'); } $bookmarks = Bookmarks::where('restaurant_id', $restaurant_id); if ($bookmarks->get()->count()) { $bookmarks->delete(); } $check_ins = CheckIns::where('restaurant_id', $restaurant_id); if ($check_ins->get()->count()) { $check_ins->delete(); } $photos = PhotosCms::where('restaurant_id', $restaurant_id); if ($photos->get()->count()) { $photos->delete(); } $restaurants_category = RestaurantsCategory::where('restaurant_id', $restaurant_id); if ($restaurants_category->get()->count()) { $restaurants_category->delete(); } $reviews = Reviews::where('restaurant_id', $restaurant_id); if ($reviews->get()->count()) { $reviews->delete(); } $restaurant->delete(); $connection->commit(); if ($is_ajax) { header('Content-Type: application/json'); $success[] = 'Restaurant ID ' . $restaurant_id . ' has been deleted'; echo json_encode(array('success' => $success)); exit; } else { $success[] = 'Restaurant ID ' . $restaurant_id . ' has been deleted'; \Session::flush('success', $success); return redirect()->back(); } } catch (Exception $e) { $connection->rollBack(); if ($is_ajax) { header('Content-Type: application/json'); $errors[] = $e->getMessage(); \Session::flush('errors', $errors); echo json_encode(array('errors' => $e->getMessage())); exit; } else { $errors[] = $e->getMessage(); \Session::flush('errors', $errors); return redirect()->back(); } } }
/** * Delete Checkin * @param $id * @throws $e */ public function deleteCheckin($id) { $connection = $this->getConnection(); try { $connection->beginTransaction(); $checkin = CheckIns::find($id); if ($checkin) { //delete checkin $checkin->delete(); //delete activities $activities = new Activities(); $activities->deleteActivity(CONSTANTS::CHECKIN, $id); //delete comments $comments = new Comments(); $comments->deleteCommentByType(CONSTANTS::CHECKIN, $id); //delete likes $like = new Like(); $like->deleteLikes(CONSTANTS::CHECKIN, $id); } else { throw new \Exception('No checkin found'); } $connection->commit(); } catch (\Exception $e) { $connection->rollBack(); throw $e; } }
/** * Review Delete * route: checkin/delete/{id} * * @param $id * @return request */ public function deleteAction($id) { try { $checkin = new CheckIns(); $checkin->deleteCheckin($id); $json_return[KeyParser::data] = array(KeyParser::id => $id, KeyParser::is_success => CONSTANTS::DELETE_SUCCESS); } catch (\Exception $e) { $message = "Failed to delete checkin with ID {$id}"; return showErrorResponse($message); } return response()->json($json_return); }
/** * Returns an array of restaurant data for use /bookmarks/user/{user_id} API * * @param Restaurants $data * @return array */ public static function restaurantBookmarkListViewFormat(Restaurants $data) { $short_restaurant_url = route('short_restaurant_view', ['encoded_id' => recordEncode($data->id)]); $array_return = array(KeyParser::id => $data->id, KeyParser::name => $data->name, KeyParser::short_url => $short_restaurant_url, KeyParser::address => $data->address, KeyParser::telephone => $data->telephone, KeyParser::budget => $data->budget, KeyParser::can_deliver => $data->can_deliver, KeyParser::can_dinein => $data->can_dinein, KeyParser::can_dineout => $data->can_dineout, KeyParser::is_24hours => $data->is_24hours, KeyParser::operating_to => $data->operating_to, KeyParser::operating_from => $data->operating_from, KeyParser::smoking => $data->smoking, KeyParser::credit_card => $data->credit_card, KeyParser::longitude => $data->longitude, KeyParser::latitude => $data->latitude, KeyParser::rating => $data->rating, KeyParser::review_count => Reviews::getByRestaurantId($data->id)->count(), KeyParser::checkin_count => CheckIns::getByRestaurantId($data->id)->count(), KeyParser::view_count => $data->view_count, KeyParser::status_close => $data->status_close, KeyParser::status_verify => $data->status_verify, KeyParser::user_id => $data->user_id, KeyParser::thumbnail => $data->thumbnail); return $array_return; }
/** * Add new comment to table * * @param $text * @param $type * @param $type_id * @param $user_id * @throws \Exception */ public function addComment($text, $type, $type_id, $user_id) { $connection = $this->getConnection(); try { $connection->beginTransaction(); $type_object = null; switch ($type) { case CONSTANTS::REVIEW: $type_object = Reviews::find($type_id); if (!$type_object) { //Review not Found throw new \Exception(CONSTANTS::ERROR_CODE_REVIEW_MISSING); } $this->type = CONSTANTS::REVIEW; $comment_type = CONSTANTS::NOTIFICATION_TYPE_COMMENT_ON_REVIEW; break; case CONSTANTS::CHECKIN: $type_object = CheckIns::find($type_id); if (!$type_object) { throw new \Exception(CONSTANTS::ERROR_CODE_CHECKIN_MISSING); } $this->type = CONSTANTS::CHECKIN; $comment_type = CONSTANTS::NOTIFICATION_TYPE_COMMENT_ON_CHECKIN; break; case CONSTANTS::PHOTO: $type_object = Photos::find($type_id); if (!$type_object) { throw new \Exception(CONSTANTS::ERROR_CODE_PHOTO_MISSING); } $this->type = CONSTANTS::PHOTO; $comment_type = CONSTANTS::NOTIFICATION_TYPE_COMMENT_ON_PHOTO; break; default: throw new \Exception(CONSTANTS::ERROR_CODE_INVALID_TYPE); } $this->type_id = $type_id; $this->comment = $text; $this->status = CONSTANTS::STATUS_ENABLED; $this->user_id = $user_id; $this->date_created = date('Y-m-d H:i:s'); $this->save(); $restaurant_id = $type_object['restaurant_id']; $owner_id = $type_object['user_id']; if ($user_id != $owner_id) { $notification_data = new Notification(); $notification_data->addCommentNotification($user_id, $owner_id, $comment_type, $type_id, $restaurant_id); } $connection->commit(); } catch (\Exception $e) { $connection->rollBack(); throw $e; } }
/** * Get the review, checkin, bookmark, follow, photos, comments, and notification data of a user * * @param $id * @param $viewer_id * @return array */ public static function getStatistics($id, $viewer_id = false) { $user = self::find($id); if (!$user) { return array(); } $user_array = ModelFormatter::userLongFormat($user); $user_array[KeyParser::review_count] = Reviews::getCountByUserId($id); $user_array[KeyParser::checkin_count] = CheckIns::getCountByUserId($id); $user_array[KeyParser::bookmark_count] = Bookmarks::getCountByUserId($id); $user_array[KeyParser::following_count] = Follow::getCountByUserId($id, CONSTANTS::FOLLOW_FOLLOWED); $user_array[KeyParser::follower_count] = Follow::getCountByUserId($id, CONSTANTS::FOLLOW_FOLLOWER); $user_array[KeyParser::photo_count] = Photos::getCountByUserId($id); $user_array[KeyParser::comment_count] = Comments::getCountByUserId($id); $user_array[KeyParser::unread_notification_count] = Notification::getNotificationByUserToCustomPaginate(CONSTANTS::NOTIFICATION_STATUS_UNREAD, CONSTANTS::ORDER_DESC, $id, null, true); $user_array[KeyParser::new_notification_count] = Notification::getNotificationByUserToCustomPaginate(CONSTANTS::NOTIFICATION_STATUS_NEW, CONSTANTS::ORDER_DESC, $id, null, true); if ($viewer_id) { $user_array[KeyParser::is_followed_by_viewer] = Follow::isFollowed($viewer_id, $id); } return $user_array; }
/** * Returns either review, checkin, or bookmark activity based on $type parameter. * * @param $type - activity type. Either 'checkin', 'review', or 'bookmark' * @param $type_id - ID for checkin/review/bookmark activity * @return mixed */ public static function getActivityType($type, $type_id) { $arr = array(); switch ($type) { case CONSTANTS::CHECKIN: $check_in = CheckIns::find($type_id); if ($check_in) { $arr[KeyParser::checkin] = ModelFormatter::checkinFormat($check_in); } else { $arr[KeyParser::checkin] = array(); } $photos = Photos::getByType(CONSTANTS::CHECKIN, $type_id); $arr[KeyParser::photos] = Photos::convertPhotosToArray($photos); break; case CONSTANTS::REVIEW: $review = Reviews::find($type_id); if ($review) { $arr[KeyParser::review] = ModelFormatter::reviewFormat($review); } else { $arr[KeyParser::review] = array(); } $photos = Photos::getByType(CONSTANTS::REVIEW, $type_id); $arr[KeyParser::photos] = Photos::convertPhotosToArray($photos); break; case CONSTANTS::PHOTO_UPLOAD_RESTAURANT: $photos = Photos::where('id', $type_id)->get(); $arr[KeyParser::photos] = Photos::convertPhotosToArray($photos); break; } unset($photos_arr); return $arr; }