All files / src/app/api/admin/referrals/rewards 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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
export const dynamic = "force-dynamic";

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

/**
 * GET /api/admin/referrals/rewards
 * List reward history (who got what, when)
 */
async function handleGet(request: NextRequest): Promise<NextResponse<ApiSuccessResponse<unknown> | ApiErrorResponse>> {
  const { searchParams } = new URL(request.url);
  const page = parseInt(searchParams.get("page") || "1");
  const limit = parseInt(searchParams.get("limit") || "20");
  const type = searchParams.get("type"); // "referrer" or "referee"
  const status = searchParams.get("status"); // "rewarded", "pending"
  const dateFrom = searchParams.get("dateFrom");
  const dateTo = searchParams.get("dateTo");

  const skip = (page - 1) * limit;

  // Build where clause based on reward type
  const where: {
    referrerRewarded?: boolean;
    refereeRewarded?: boolean;
    status?: string;
    createdAt?: { gte?: Date; lte?: Date };
  } = {};

  if (type === "referrer") {
    where.referrerRewarded = true;
  } else if (type === "referee") {
    where.refereeRewarded = true;
  }

  if (status === "rewarded") {
    where.status = "rewarded";
  } else if (status === "pending") {
    where.status = {
      in: ["pending", "signed_up", "purchased"] } as unknown as string;
  }

  if (dateFrom || dateTo) {
    where.createdAt = {};
    if (dateFrom) {
      where.createdAt.gte = new Date(dateFrom);
    }
    if (dateTo) {
      where.createdAt.lte = new Date(dateTo);
    }
  }

  const [referrals, total] = await Promise.all([
    prisma.referral.findMany({
      where: {
        OR: [{ referrerRewarded: true }, { refereeRewarded: true }],
        ...(type === "referrer" ? { referrerRewarded: true } : {}),
        ...(type === "referee" ? { refereeRewarded: true } : {}),
        ...(status ? { status } : {}),
        ...(dateFrom || dateTo ? { createdAt: where.createdAt } : {}) },
      skip,
      take: limit,
      include: {
        program: true },
      orderBy: { createdAt: "desc" } }),
    prisma.referral.count({
      where: {
        OR: [{ referrerRewarded: true }, { refereeRewarded: true }] } }),
  ]);

  // Get user info for referrers and referees
  const userIds = new Set<number>();
  referrals.forEach((r) => {
    userIds.add(r.referrerId);
    if (r.refereeId) userIds.add(r.refereeId);
  });

  const users = await prisma.user.findMany({
    where: { id: { in: [...userIds] } },
    select: { id: true, email: true, name: true } });
  const userMap = new Map(users.map((u) => [u.id, u]));

  // Format rewards list
  const rewards: Array<{
    id: number;
    referralCode: string;
    type: "referrer" | "referee";
    userId: number;
    user: { id: number; email: string; name: string } | null;
    reward: unknown;
    status: string;
    programName: string;
    createdAt: Date;
  }> = [];

  referrals.forEach((referral) => {
    const referrer = userMap.get(referral.referrerId);
    const referee = referral.refereeId
      ? userMap.get(referral.refereeId)
      : null;

    if (referral.referrerRewarded && (!type || type === "referrer")) {
      rewards.push({
        id: referral.id,
        referralCode: referral.referralCode,
        type: "referrer",
        userId: referral.referrerId,
        user: referrer
          ? {
              id: referrer.id,
              email: referrer.email,
              name: referrer.name || "N/A" }
          : null,
        reward: referral.program.referrerReward,
        status: referral.status,
        programName: referral.program.name,
        createdAt: referral.createdAt });
    }

    if (referral.refereeRewarded && referee && (!type || type === "referee")) {
      rewards.push({
        id: referral.id,
        referralCode: referral.referralCode,
        type: "referee",
        userId: referral.refereeId!,
        user: {
          id: referee.id,
          email: referee.email,
          name: referee.name || "N/A" },
        reward: referral.program.refereeReward,
        status: referral.status,
        programName: referral.program.name,
        createdAt: referral.createdAt });
    }
  });

  return successResponse({
    rewards,
    pagination: {
      page,
      limit,
      total,
      totalPages: Math.ceil(total / limit) } });
}

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