import { db } from "@/lib/db";

// ─── Achievement definitions ──────────────────────────────────────────────────
// These are upserted into the DB on first use so the table is always populated.

export const ACHIEVEMENT_DEFINITIONS = [
  // Completion milestones
  { name: "first_response",   title: "First Steps",        description: "Submit your first questionnaire response.", icon: "🎯", category: "COMPLETION" as const, xpReward: 25,  rarity: "common",    requirement: { type: "responses", count: 1   } },
  { name: "responses_10",     title: "Getting Started",    description: "Submit 10 questionnaire responses.",        icon: "📝", category: "COMPLETION" as const, xpReward: 50,  rarity: "common",    requirement: { type: "responses", count: 10  } },
  { name: "responses_50",     title: "Dedicated Learner",  description: "Submit 50 questionnaire responses.",        icon: "🏃", category: "COMPLETION" as const, xpReward: 100, rarity: "rare",      requirement: { type: "responses", count: 50  } },
  { name: "responses_100",    title: "Century Club",       description: "Submit 100 questionnaire responses.",       icon: "💯", category: "COMPLETION" as const, xpReward: 200, rarity: "rare",      requirement: { type: "responses", count: 100 } },
  { name: "responses_500",    title: "Power Annotator",    description: "Submit 500 questionnaire responses.",       icon: "⚡", category: "COMPLETION" as const, xpReward: 500, rarity: "epic",      requirement: { type: "responses", count: 500 } },

  // XP milestones
  { name: "xp_100",           title: "Sparks Flying",      description: "Earn 100 XP.",                              icon: "✨", category: "MILESTONE"  as const, xpReward: 10,  rarity: "common",    requirement: { type: "xp", count: 100   } },
  { name: "xp_500",           title: "Rising Star",        description: "Earn 500 XP.",                              icon: "⭐", category: "MILESTONE"  as const, xpReward: 25,  rarity: "common",    requirement: { type: "xp", count: 500   } },
  { name: "xp_1000",          title: "Knowledge Seeker",   description: "Earn 1,000 XP.",                            icon: "🌟", category: "MILESTONE"  as const, xpReward: 50,  rarity: "rare",      requirement: { type: "xp", count: 1000  } },
  { name: "xp_5000",          title: "XP Master",          description: "Earn 5,000 XP.",                            icon: "🏆", category: "MILESTONE"  as const, xpReward: 150, rarity: "epic",      requirement: { type: "xp", count: 5000  } },
  { name: "xp_10000",         title: "Legend",             description: "Earn 10,000 XP.",                           icon: "👑", category: "MILESTONE"  as const, xpReward: 500, rarity: "legendary", requirement: { type: "xp", count: 10000 } },

  // Streak achievements
  { name: "streak_3",         title: "On a Roll",          description: "Maintain a 3-day streak.",                  icon: "🔥", category: "STREAK"     as const, xpReward: 20,  rarity: "common",    requirement: { type: "streak", count: 3  } },
  { name: "streak_7",         title: "Week Warrior",       description: "Maintain a 7-day streak.",                  icon: "🗓️", category: "STREAK"     as const, xpReward: 75,  rarity: "rare",      requirement: { type: "streak", count: 7  } },
  { name: "streak_30",        title: "Monthly Grind",      description: "Maintain a 30-day streak.",                 icon: "📅", category: "STREAK"     as const, xpReward: 300, rarity: "epic",      requirement: { type: "streak", count: 30 } },

  // Quality
  { name: "quality_80",       title: "Quality Contributor", description: "Achieve a quality score of 80+.",          icon: "💎", category: "QUALITY"    as const, xpReward: 50,  rarity: "rare",      requirement: { type: "quality", count: 80 } },
  { name: "quality_95",       title: "Excellence Award",   description: "Achieve a quality score of 95+.",           icon: "🥇", category: "QUALITY"    as const, xpReward: 150, rarity: "epic",      requirement: { type: "quality", count: 95 } },

  // Level milestones
  { name: "level_5",          title: "Levelling Up",       description: "Reach Level 5.",                            icon: "📈", category: "MILESTONE"  as const, xpReward: 50,  rarity: "common",    requirement: { type: "level", count: 5  } },
  { name: "level_10",         title: "Double Digits",      description: "Reach Level 10.",                           icon: "🎖️", category: "MILESTONE"  as const, xpReward: 100, rarity: "rare",      requirement: { type: "level", count: 10 } },
  { name: "level_25",         title: "Veteran",            description: "Reach Level 25.",                           icon: "🎗️", category: "MILESTONE"  as const, xpReward: 250, rarity: "epic",      requirement: { type: "level", count: 25 } },
] as const;

// ─── Seed helper (call once at startup or from a script) ─────────────────────

export async function seedAchievements() {
  for (const def of ACHIEVEMENT_DEFINITIONS) {
    await db.achievement.upsert({
      where: { name: def.name },
      create: { ...def, requirement: def.requirement as any },
      update: { title: def.title, description: def.description, xpReward: def.xpReward },
    });
  }
}

// ─── Check + unlock ───────────────────────────────────────────────────────────

interface UserSnapshot {
  id: string;
  totalResponses: number;
  xpPoints: number;
  streakDays: number;
  level: number;
  avgQualityScore: number | null;
}

interface UnlockedAchievement {
  id: string;
  name: string;
  title: string;
  icon: string;
  xpReward: number;
}

/**
 * Check all achievement conditions for a user and unlock any newly earned ones.
 * Returns the list of newly unlocked achievements so callers can notify the user.
 */
export async function checkAndUnlockAchievements(user: UserSnapshot): Promise<UnlockedAchievement[]> {
  // Fetch all achievements and which ones the user already has
  const [allAchievements, existingUnlocks] = await Promise.all([
    db.achievement.findMany({ where: { isActive: true } }),
    db.userAchievement.findMany({
      where: { userId: user.id },
      select: { achievementId: true },
    }),
  ]);

  const alreadyUnlocked = new Set(existingUnlocks.map((u) => u.achievementId));
  const newlyUnlocked: UnlockedAchievement[] = [];

  for (const achievement of allAchievements) {
    if (alreadyUnlocked.has(achievement.id)) continue;

    const req = achievement.requirement as { type: string; count: number };
    let earned = false;

    switch (req.type) {
      case "responses": earned = user.totalResponses >= req.count; break;
      case "xp":        earned = user.xpPoints >= req.count;       break;
      case "streak":    earned = user.streakDays >= req.count;     break;
      case "level":     earned = user.level >= req.count;          break;
      case "quality":   earned = (user.avgQualityScore ?? 0) >= req.count; break;
    }

    if (!earned) continue;

    // Unlock in DB
    await db.userAchievement.create({
      data: { userId: user.id, achievementId: achievement.id, progress: 100 },
    });

    // Award bonus XP
    if (achievement.xpReward > 0) {
      await db.user.update({
        where: { id: user.id },
        data: { xpPoints: { increment: achievement.xpReward } },
      });
    }

    // Create in-app notification
    await db.notification.create({
      data: {
        userId: user.id,
        type: "ACHIEVEMENT",
        title: `Achievement unlocked: ${achievement.title}`,
        body: achievement.description,
        data: { achievementId: achievement.id, xpAmount: achievement.xpReward },
      },
    });

    newlyUnlocked.push({
      id: achievement.id,
      name: achievement.name,
      title: achievement.title,
      icon: achievement.icon,
      xpReward: achievement.xpReward,
    });
  }

  return newlyUnlocked;
}
