Ratings and Reviews System

interface Rating {
  id: string;
  lawyer_id: string;
  user_id: string;
  rating: number;           // 1-5 stars
  comment: string | null;
  created_at: string;
  updated_at?: string;
  user: {
    id: string;
    display_name: string;
    avatar_url?: string;
  };
  service_type?: string;
  helpful_count?: number;
}

// Eligibility check
const checkIfCanReview = async (lawyerId: string, userId: string) => {
  // 1. Check for existing review
  const existingReview = await ratingService.getUserRating(lawyerId, userId);
  if (existingReview) return false;
  
  // 2. Check for completed consultations or appointments
  const consultations = await supabase
    .from('consultations')
    .select('id')
    .eq('client_id', userId)
    .eq('lawyer_id', lawyerId)
    .eq('status', 'completed');
    
  const appointments = await supabase
    .from('appointments')
    .select('id')
    .eq('user_id', userId)
    .eq('lawyer_id', lawyerId)
    .eq('status', 'completed');
    
  return (consultations?.length > 0) || (appointments?.length > 0);
};

type ReviewStatus = 'pending' | 'approved' | 'rejected';

const stats = await ratingService.getLawyerRatingStats(lawyerId);

// Returns:
{
  average: 4.5,    // Rounded to 1 decimal place
  count: 24        // Total number of approved reviews
}

{
  5: 15,  // 15 five-star reviews
  4: 6,   // 6 four-star reviews
  3: 2,   // 2 three-star reviews
  2: 1,   // 1 two-star review
  1: 0    // 0 one-star reviews
}

5 ⭐ ████████████████████ 15
4 ⭐ ████████             6
3 ⭐ ███                  2
2 ⭐ █                    1
1 ⭐                      0

<ReviewCard>
  <Avatar src={user.avatar_url} alt={user.display_name} />
  <Header>
    <Name>{user.display_name}</Name>
    <Badge>Verificado</Badge>
    <Rating stars={5} />
    <TimeAgo>hace 3 semanas</TimeAgo>
  </Header>
  <ServiceType>Derecho de Familia</ServiceType>
  <Comment>
    Excelente abogado. Me ayudó con mi caso de tuición y fue muy
    profesional durante todo el proceso. Altamente recomendado.
  </Comment>
  <Actions>
    <Button>👍 Útil (5)</Button>
    <Button>👎 No útil</Button>
  </Actions>
</ReviewCard>

const [isHelpful, setIsHelpful] = useState(false);
const [isNotHelpful, setIsNotHelpful] = useState(false);

const handleHelpful = () => {
  setIsHelpful(!isHelpful);
  setIsNotHelpful(false);  // Clear opposite vote
  onHelpful?.(review.id);
};

await ratingService.updateRating(ratingId, {
  rating: 4,
  comment: "Updated review text"
}, userId);

await ratingService.deleteRating(ratingId, userId);

<Badge className="bg-green-100 text-green-800">
  Verificado
</Badge>

ratingService = {
  // Get all ratings for a lawyer
  getRatingsByLawyer(lawyerId: string): Promise<Rating[]>
  
  // Get a user's rating for a lawyer
  getUserRating(lawyerId: string, userId: string): Promise<Rating | null>
  
  // Create a new rating
  createRating(input: CreateRatingInput, userId: string): Promise<Rating>
  
  // Update existing rating
  updateRating(ratingId: string, input: UpdateRatingInput, userId: string): Promise<Rating>
  
  // Delete a rating
  deleteRating(ratingId: string, userId: string): Promise<void>
  
  // Get statistics
  getLawyerRatingStats(lawyerId: string): Promise<{
    average: number;
    count: number;
  }>
}