Review system

export const reviews = pgTable('reviews', {
  id: uuid('id').primaryKey().defaultRandom(),
  transactionId: uuid('transaction_id').references(() => transactions.id),
  reviewerId: uuid('reviewer_id').references(() => users.id),
  sellerId: uuid('seller_id').references(() => users.id),
  itemId: uuid('item_id').references(() => items.id),

  overallRating: integer('overall_rating').notNull(), // 1-5
  itemAccuracyRating: integer('item_accuracy_rating'),
  shippingRating: integer('shipping_rating'),
  communicationRating: integer('communication_rating'),

  comment: text('comment'),
  photos: jsonb('photos').$type<string[]>(),

  sellerResponse: text('seller_response'),
  sellerRespondedAt: timestamp('seller_responded_at'),

  isVerifiedPurchase: boolean('is_verified_purchase').default(true),
  createdAt: timestamp('created_at').defaultNow(),
});

export const sellerStats = pgTable('seller_stats', {
  sellerId: uuid('seller_id').primaryKey().references(() => users.id),
  totalReviews: integer('total_reviews').default(0),
  averageRating: decimal('average_rating', { precision: 2, scale: 1 }),
  totalSales: integer('total_sales').default(0),
  avgResponseTime: integer('avg_response_time'), // minutes
  avgShipTime: integer('avg_ship_time'), // hours
  trustScore: integer('trust_score').default(0), // 0-100
});

function calculateTrustScore(seller: SellerStats): number {
  let score = 0;

  // Rating weight (40%)
  if (seller.averageRating) {
    score += (seller.averageRating / 5) * 40;
  }

  // Sales volume (25%)
  const salesScore = Math.min(seller.totalSales / 100, 1) * 25;
  score += salesScore;

  // Response time (15%)
  if (seller.avgResponseTime < 60) score += 15;
  else if (seller.avgResponseTime < 240) score += 10;
  else if (seller.avgResponseTime < 1440) score += 5;

  // Shipping speed (15%)
  if (seller.avgShipTime < 24) score += 15;
  else if (seller.avgShipTime < 48) score += 10;
  else if (seller.avgShipTime < 72) score += 5;

  // Account age (5%)
  const accountAgeMonths = getAccountAgeMonths(seller.userId);
  score += Math.min(accountAgeMonths / 12, 1) * 5;

  return Math.round(score);
}

async function submitReview(data: ReviewInput) {
  // Verify purchase
  const transaction = await db.query.transactions.findFirst({
    where: and(
      eq(transactions.id, data.transactionId),
      eq(transactions.buyerId, data.reviewerId),
      eq(transactions.status, 'completed'),
    ),
  });

  if (!transaction) throw new Error('Invalid transaction');

  // Create review
  const review = await db.insert(reviews).values({
    ...data,
    isVerifiedPurchase: true,
  }).returning();

  // Update seller stats
  await updateSellerStats(transaction.sellerId);

  return review;
}