All files / src/app/api/referrals/stats route.ts

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
84
85
86
87
88
89
90
91
92
93
94
95
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
export const dynamic = "force-dynamic";

import { NextRequest, NextResponse } from 'next/server';
import { Session } from "next-auth";
import { prisma } from "@/lib/prisma";
import {
  withAuth,
  withErrorHandling,
  successResponse,
  ApiError,
  ApiSuccessResponse,
  ApiErrorResponse } from "@/lib/api";
import { RouteContext } from "@/lib/api/middleware";

/**
 * GET /api/referrals/stats
 * Get user's referral statistics
 */
async function handleGet(
  request: NextRequest,
  context: RouteContext | undefined,
  session: Session
): Promise<NextResponse<ApiSuccessResponse<unknown> | ApiErrorResponse>> {
  const userId = session.user.id;

  const user = await prisma.user.findUnique({
    where: { id: userId },
    select: { id: true }});

  if (!user) {
    throw ApiError.notFound("User");
  }

  // Get all referrals made by this user
  const referrals = await prisma.referral.findMany({
    where: {
      referrerId: user.id,
      refereeId: { not: null }, // Only count actual referrals
    },
    include: {
      referee: {
        select: {
          name: true,
          createdAt: true}}},
    orderBy: { createdAt: "desc" }});

  // Calculate stats
  const totalReferrals = referrals.length;
  const signedUp = referrals.filter((r) => r.status !== "pending").length;
  const purchased = referrals.filter(
    (r) => r.status === "purchased" || r.status === "rewarded"
  ).length;
  const rewarded = referrals.filter((r) => r.referrerRewarded).length;
  const pendingRewards = referrals.filter(
    (r) => r.status === "purchased" && !r.referrerRewarded
  ).length;

  // Get program info for reward calculation
  const program = await prisma.referralProgram.findFirst({
    where: { isActive: true }});

  let totalEarned = 0;
  if (program && program.referrerReward) {
    const reward = program.referrerReward as { type: string; value: number };
    if (reward.type === "credit" || reward.type === "points") {
      totalEarned = rewarded * reward.value;
    }
  }

  // Recent referrals for display
  const recentReferrals = referrals.slice(0, 10).map((r) => ({
    id: r.id,
    refereeName: r.referee?.name || "Anonymous",
    status: r.status,
    referrerRewarded: r.referrerRewarded,
    createdAt: r.createdAt,
    convertedAt: r.convertedAt}));

  return successResponse({
    stats: {
      totalReferrals,
      signedUp,
      purchased,
      rewarded,
      pendingRewards,
      totalEarned,
      conversionRate:
        totalReferrals > 0
          ? Math.round((purchased / totalReferrals) * 100)
          : 0},
    recentReferrals});
}

export const GET = withErrorHandling(withAuth(handleGet));