File size: 2,536 Bytes
78d0e31 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 |
import { type NextRequest, NextResponse } from "next/server"
import { neon } from "@neondatabase/serverless"
const sql = neon(process.env.DATABASE_URL!)
export async function GET(request: NextRequest) {
try {
const { searchParams } = new URL(request.url)
const walletAddress = searchParams.get("wallet")
if (!walletAddress) {
return NextResponse.json({ error: "Wallet address required" }, { status: 400 })
}
// Get user profile
const userResult = await sql`
SELECT * FROM user_profiles WHERE wallet_address = ${walletAddress}
`
if (userResult.length === 0) {
return NextResponse.json({ error: "User not found" }, { status: 404 })
}
const user = userResult[0]
// Get completed modules
const completedModules = await sql`
SELECT ucm.*, lm.title, lm.category
FROM user_completed_modules ucm
JOIN learning_modules lm ON ucm.module_id = lm.id
WHERE ucm.user_id = ${user.id}
ORDER BY ucm.completed_at DESC
`
// Get achievements
const achievements = await sql`
SELECT ua.*, a.title, a.description, a.icon
FROM user_achievements ua
JOIN achievements a ON ua.achievement_id = a.id
WHERE ua.user_id = ${user.id}
ORDER BY ua.achieved_at DESC
`
// Get daily challenges
const dailyChallenges = await sql`
SELECT c.*, COALESCE(ucc.completed_at IS NOT NULL, false) as completed
FROM challenges c
LEFT JOIN user_completed_challenges ucc ON c.id = ucc.challenge_id AND ucc.user_id = ${user.id}
WHERE c.type = 'daily' AND c.active = true
ORDER BY c.created_at DESC
LIMIT 5
`
// Calculate next level XP
const nextLevelXp = user.level * 1000 * 1.2 - user.xp
return NextResponse.json({
user: {
...user,
nextLevelXp: Math.max(0, nextLevelXp),
},
completedModules,
achievements,
dailyChallenges,
stats: {
totalModules: completedModules.length,
totalFLBEarned: completedModules.reduce(
(sum: number, module: any) => sum + Number.parseFloat(module.flb_earned),
0,
),
totalXPEarned: completedModules.reduce(
(sum: number, module: any) => sum + Number.parseInt(module.xp_earned),
0,
),
achievementsCount: achievements.length,
},
})
} catch (error) {
console.error("Error fetching user progress:", error)
return NextResponse.json({ error: "Internal server error" }, { status: 500 })
}
}
|