Reviews & Ratings

// Model: Review.java
package org.generation.socialNetwork.reviews.model;

@Entity
@Table(name = "reviews")
public class Review {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long reviewId;
    
    private Long tripId;      // The completed trip
    private Long tourId;      // The tour that was reviewed
    private Long guideId;     // The guide being reviewed
    private Long touristId;   // Who wrote the review
    
    private Integer rating;   // Numeric rating (typically 1-5)
    private String comment;   // Written review text
    
    private Integer likesCount;   // Number of likes
    private Integer repliesCount; // Number of replies
    
    private LocalDateTime createdAt;
    private LocalDateTime updatedAt;
    private LocalDateTime deletedAt;  // Soft delete support
}

private LocalDateTime deletedAt;  // null = active, non-null = deleted

// Model: ReviewReply.java
@Entity
@Table(name = "review_replies")
public class ReviewReply {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long replyId;
    
    private Long reviewId;    // Parent review
    private Long guideId;     // Who replied (typically the guide)
    
    private String message;   // Reply content
    
    private LocalDateTime createdAt;
    private LocalDateTime updatedAt;
}

// GuideProfile.java
private BigDecimal ratingAvg;     // Average of all review ratings
private Integer reviewsCount;     // Total number of reviews

-- Calculate average rating
SELECT AVG(rating) as rating_avg, COUNT(*) as reviews_count
FROM reviews
WHERE guide_id = ? AND deleted_at IS NULL

// Tour.java
private BigDecimal ratingAvg;     // Average rating for this tour
private Integer bookingsCount;    // Total bookings (includes reviews)

GET    /api/v1/reviews
GET    /api/v1/reviews/{id}
POST   /api/v1/reviews
PUT    /api/v1/reviews/{id}
DELETE /api/v1/reviews/{id}

GET    /api/v1/review-replies
GET    /api/v1/review-replies/{id}
POST   /api/v1/review-replies
PUT    /api/v1/review-replies/{id}
DELETE /api/v1/review-replies/{id}

POST /api/v1/reviews
{
  "tripId": 789,
  "tourId": 42,
  "guideId": 456,
  "touristId": 123,
  "rating": 5,
  "comment": "Amazing experience! The guide was knowledgeable and friendly. Highly recommend this tour!",
  "createdAt": "2024-06-16T10:00:00Z"
}

POST /api/v1/review-replies
{
  "reviewId": 555,
  "guideId": 456,
  "message": "Thank you so much for the wonderful review! It was a pleasure showing you around Tokyo. Hope to see you again soon!",
  "createdAt": "2024-06-16T15:30:00Z"
}

// Update review reply count
PUT /api/v1/reviews/555
{
  "repliesCount": 1
}

-- Calculate new average after review is created
UPDATE guide_profiles
SET rating_avg = (
  SELECT AVG(rating)
  FROM reviews
  WHERE guide_id = 456 AND deleted_at IS NULL
),
reviews_count = (
  SELECT COUNT(*)
  FROM reviews
  WHERE guide_id = 456 AND deleted_at IS NULL
)
WHERE user_id = 456;

PUT /api/v1/reviews/555
{
  "deletedAt": "2024-06-20T09:00:00Z"
}

// Recalculate guide ratings after deletion

// Show only 5-star reviews
GET /api/v1/reviews?guideId=456&rating=5

// Show reviews with photos (if implemented)
GET /api/v1/reviews?guideId=456&hasPhotos=true

// Show verified reviews (from completed trips)
GET /api/v1/reviews?guideId=456&verified=true

// Check if review is verified
const isVerified = review.tripId && 
  tripBooking.status === 'COMPLETED' &&
  tripBooking.touristId === review.touristId;