public function getIndex()
{
$rating = new Rating();
$rating = Rating::where('ven_id', '=', '14')->avg('rvalue');
echo $rating;
//return 'Ratings';
}
public static function deleteLike($rating_id)
{
$error_code = ApiResponse::OK;
$user_id = Session::get('user_id');
if (Rating::where('id', $rating_id)->first()) {
$like = Like::where('rating_id', $rating_id)->where('user_id', $user_id)->first();
if ($like) {
//update like_count on rating
$like_rating = Rating::where('id', $like->rating_id)->first();
if ($like_rating != null) {
$like_rating->like_count = $like_rating->like_count - 1;
$like_rating->save();
}
$like->delete();
$data = 'Like deleted';
} else {
$error_code = ApiResponse::NOT_EXISTED_LIKE;
$data = ApiResponse::getErrorContent(ApiResponse::NOT_EXISTED_LIKE);
}
} else {
$error_code = ApiResponse::UNAVAILABLE_RATING;
$data = ApiResponse::getErrorContent(ApiResponse::UNAVAILABLE_RATING);
}
return array("code" => $error_code, "data" => $data);
}
public function testGetRatingDetailSuccess()
{
$this->setUpRating();
$response = $this->call('GET', 'api/rating/1');
$rating_infor = Rating::where('id', 1)->with('wine')->first();
$this->assertEquals(array("code" => ApiResponse::OK, "data" => $rating_infor->toArray()), json_decode($response->getContent(), true));
}
public function testUpdateRatingSuccess()
{
$this->setUpRating();
$_params = $this->_params;
//dd(json_encode($_params));
$response = $this->action('POST', 'RatingController@update', array('id' => 1), array('data' => json_encode($_params), '_method' => 'PUT'));
//get created login information
$rating_infor = Rating::where('id', 1)->first();
$this->assertEquals(array("code" => ApiResponse::OK, "data" => $rating_infor->toArray()), json_decode($response->getContent(), true));
}
/**
* Override delete method
* Delete topic itself and all it's comments, ratings, and view counter
*/
public function delete()
{
$tid = $this->id;
// delete view counter
Counter::where("[entityId] = ? AND [entityTypeId] = ?", [$tid, Topic::ENTITY_TYPE])->delete();
Rating::where("[entityId] = ? AND [entityType] = ?", [$tid, Topic::ENTITY_TYPE])->delete();
RatingStatistic::where("[entityId] = ? AND [entityType] = ?", [$tid, Topic::ENTITY_TYPE])->delete();
Comment::where("[topicId] = ?", $tid)->delete();
parent::delete();
}
public function deleteIssue()
{
if (Auth::user()->isAdmin()) {
$issue_id = Input::get('issue_id');
$deletedRatings = Rating::where('issue_id', '=', $issue_id)->delete();
$deletedIssueFollows = IssueFollow::where('issue_id', '=', $issue_id)->delete();
$issue = Issue::find($issue_id);
$issue->delete();
} else {
return App::abort(404);
}
}
public static function getRating($type, $id)
{
$rating = 0;
$ratings = Rating::where('item_id', $id)->where('item_type', $type)->get();
$numRatings = sizeof($ratings);
if ($numRatings) {
for ($i = 0; $i < $numRatings; $i++) {
$rating += $ratings[$i]['rating'];
}
$rating = $rating / $numRatings;
}
return array('rating' => $rating, 'numRatings' => $numRatings);
}
public static function getActivity()
{
$user_id = Session::get('user_id');
$error_code = ApiResponse::OK;
$act = array();
$ratings = Rating::where('user_id', $user_id)->get();
foreach ($ratings as $rating) {
$likes = Like::where('rating_id', $rating->id)->whereNotIn('user_id', [$user_id])->get();
if ($likes) {
$title = 'like';
foreach ($likes as $like) {
$act[] = Rating::getProfile($like->user_id, $title, $like->id, $rating->id, $like->updated_at);
}
}
$comments = Comment::where('rating_id', $rating->id)->whereNotIn('user_id', [$user_id])->get();
if ($comments) {
$title = 'comment';
foreach ($comments as $comment) {
$act[] = Rating::getProfile($comment->user_id, $title, $comment->id, $rating->id, $comment->updated_at);
}
}
$wishlists = Wishlist::where('wine_unique_id', $rating->wine_unique_id)->whereNotIn('user_id', [$user_id])->get();
if ($wishlists) {
$title = 'wishlist';
foreach ($wishlists as $wishlist) {
$act[] = Rating::getProfile($wishlist->user_id, $title, $wishlist->id, $rating->id, $wishlist->updated_at);
}
}
}
$user_follow = Follow::where('to_id', $user_id)->get();
if ($user_follow) {
$title = 'follow';
foreach ($user_follow as $user) {
$act[] = Rating::getProfile($user->from_id, $title, $user->id, null, $user->updated_at);
}
}
$data = Rating::orderBy($act, 'updated_at');
return array("code" => $error_code, "data" => $data);
}
public function calculateRating($username)
{
$username1 = User::where('username', '=', $username)->get();
if ($username1->isEmpty()) {
return Response::json(array($username . ' not valid'));
}
$username2 = Rating::where('seller', '=', $username)->get();
if ($username2->isEmpty()) {
return Response::json(array('name' => $username, 'rating' => "There is no Rating against {$username}"));
}
$ratings = Rating::where('seller', '=', $username)->get();
$sum = 0;
$count = 0;
foreach ($ratings as $rating) {
$sum += $rating->rating_number;
$count = $count + 1;
}
$average = $sum / $count;
return Response::json(array('name' => $username, 'rating' => $average));
}
public static function getProfieLastRate($user_id)
{
$error_code = ApiResponse::OK;
$pagination = ApiResponse::pagination();
if ($pagination == false) {
$error_code = ApiResponse::URL_NOT_EXIST;
$data = ApiResponse::getErrorContent(ApiResponse::URL_NOT_EXIST);
} else {
$page = $pagination['page'];
$limit = $pagination['limit'];
if (User::where('user_id', $user_id)->first()) {
$last_rates = Rating::where('user_id', $user_id)->orderBy('updated_at', 'desc')->with('wine')->forPage($page, $limit)->get();
foreach ($last_rates as $last_rate) {
$last_rate->winery = Winery::where('id', $last_rate->wine->winery_id)->first();
if ($last_rate->wine->image_url != null) {
$last_rate->wine->image_url = URL::asset($last_rate->wine->image_url);
}
if ($last_rate->wine->wine_flag != null) {
$last_rate->wine->wine_flag = URL::asset($last_rate->wine->wine_flag);
}
}
$data = $last_rates->toArray();
} else {
$error_code = ApiResponse::UNAVAILABLE_USER;
$data = ApiResponse::getErrorContent(ApiResponse::UNAVAILABLE_USER);
}
}
return array("code" => $error_code, "data" => $data);
}
public static function searchWinefromMywine($input)
{
$error_code = ApiResponse::OK;
$wine_unique_id = array();
$data = array();
$user_id = Session::get('user_id');
if (!empty($input['text'])) {
$text = $input['text'];
$ratings = Rating::where('user_id', $user_id)->where('is_my_wine', 1)->get();
if ($ratings) {
foreach ($ratings as $rating) {
$wine_unique_id[] = $rating->wine_unique_id;
}
if ($wine_unique_id != null) {
$wishlists = Wishlist::where('user_id', $user_id)->whereNotIn('wine_unique_id', $wine_unique_id)->get();
} else {
$wishlists = Wishlist::where('user_id', $user_id)->get();
}
if ($wishlists) {
foreach ($wishlists as $wishlist) {
$wine_unique_id[] = $wishlist->wine_unique_id;
}
}
}
if ($wine_unique_id != null) {
$wines = Wine::where('name', 'LIKE', '%' . $text . '%')->whereIn('wine_unique_id', $wine_unique_id)->with('winery')->get();
if ($wines) {
foreach ($wines as $wine) {
if ($wine->image_url != null) {
$wine->image_url = URL::asset($wine->image_url);
}
if ($wine->wine_flag != null) {
$wine->wine_flag = URL::asset($wine->wine_flag);
}
$data[] = $wine;
}
}
}
} else {
$error_code = ApiResponse::MISSING_PARAMS;
$data = $input;
}
return array("code" => $error_code, "data" => $data);
}
public static function deleteComment($rating_id, $id)
{
$comment = Comment::where('id', '=', $id)->first();
$error_code = ApiResponse::OK;
if (Rating::where('id', $rating_id)->first()) {
if ($comment) {
$comment_profile = Profile::where('user_id', $comment->user_id)->first();
if ($comment_profile != null) {
$comment_profile->comment_count = $comment_profile->comment_count - 1;
$comment_profile->save();
}
//update comment_count on rating
$comment_rating = Rating::where('id', $comment->rating_id)->first();
if ($comment_rating != null) {
$comment_rating->comment_count = $comment_rating->comment_count - 1;
$comment_rating->save();
$comment->delete();
}
$data = 'Comment deleted';
} else {
$error_code = ApiResponse::UNAVAILABLE_COMMENT;
$data = ApiResponse::getErrorContent(ApiResponse::UNAVAILABLE_COMMENT);
}
} else {
$error_code = ApiResponse::UNAVAILABLE_RATING;
$data = ApiResponse::getErrorContent(ApiResponse::UNAVAILABLE_RATING);
}
return array("code" => $error_code, "data" => $data);
}
public static function deleteGroup(Group $group)
{
Rating::where("[entityId] = ? AND [entityType] = ?", [$group->id, Group::ENTITY_TYPE])->delete();
RatingStatistic::where("[entityId] = ? AND [entityType] = ?", [$group->id, Group::ENTITY_TYPE])->delete();
Counter::where("[entityId] = ? AND [entityTypeId] = ?", [$group->id, Group::ENTITY_TYPE])->delete();
$topics = Topic::find("groupId", $group->id)->all();
foreach ($topics as $topic) {
$topic->delete();
}
GroupUser::where("[groupId] = ?", $group->id)->delete();
$group->delete();
}
public function testGetProfileLastRateSucess()
{
$this->setUpRating();
$user_id = $this->_user_id;
$per_page = 10;
$page = 1;
$response = $this->action('GET', 'ProfileController@get_profile_Last_rate', array('user_id' => $user_id));
$last_rate = Rating::where('user_id', $user_id)->orderBy('updated_at', 'desc')->with('wine')->forPage($page, $per_page)->get();
foreach ($last_rate as $last_rates) {
$last_rates->winery = Winery::where('id', $last_rates->wine->winery_id)->first()->toArray();
if ($last_rates->wine->image_url != null) {
$last_rates->wine->image_url = URL::asset($last_rates->wine->image_url);
}
if ($last_rates->wine->wine_flag != null) {
$last_rates->wine->wine_flag = URL::asset($last_rates->wine->wine_flag);
}
}
$data = $last_rate;
$this->assertEquals(array("code" => ApiResponse::OK, "data" => $data->toArray()), json_decode($response->getContent(), true));
}
public function testSearchWineSuccess()
{
$data = array();
$_params = $this->_params;
$response = $this->action('POST', 'WineController@search', array(), array('data' => json_encode($_params)));
$user_id = $this->_user_id;
$wine = Wine::where('name', 'LIKE', '%wi%')->with('winery')->get();
if ($wine) {
foreach ($wine as $wines) {
if ($wines->image_url != null) {
$wines->image_url = URL::asset($wines->image_url);
}
if ($wines->wine_flag != null) {
$wines->wine_flag = URL::asset($wines->wine_flag);
}
$ratings = Rating::where('user_id', $user_id)->where('wine_unique_id', $wines->wine_unique_id)->where('is_my_wine', 1)->first();
if ($ratings) {
$data[] = $wines;
} else {
$wishlist = Wishlist::where('user_id', $user_id)->where('wine_unique_id', $wines->wine_unique_id)->first();
if ($wishlist) {
$data[] = $wines;
}
}
}
}
$this->assertEquals(array("code" => ApiResponse::OK, "data" => $data), json_decode($response->getContent(), true));
}
/**
* Delete plus-rating data
*/
public function delete()
{
if (isset($this->entityType) && isset($this->entityId)) {
Rating::where("[entityId] = ? AND [entityType] = ?", [$this->entityId, $this->entityType])->delete();
RatingStatistic::where("[entityId] = ? AND [entityType] = ?", [$this->entityId, $this->entityType])->delete();
}
}
/**
* Remove the specified beer from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$ratings = Rating::where('beer_id', '=', $id)->get();
foreach ($ratings as $rating) {
Rating::destroy($rating->rating_id);
}
Beer::destroy($id);
return Response::json(['all good' => $id]);
}
