All files / src/app/api/user/affiliate/sales 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
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
export const dynamic = "force-dynamic";

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

/**
 * GET /api/user/affiliate/sales
 * Get current user's affiliate sales
 */
async function handleGet(
  request: NextRequest,
  _context: RouteContext | undefined,
  _session: Session,
  user: AuthenticatedUser
): Promise<NextResponse<ApiSuccessResponse<unknown> | ApiErrorResponse>> {
  // Get user's affiliate account
  const affiliate = await prisma.affiliate.findUnique({
    where: { userId: user.id }});

  if (!affiliate) {
    throw ApiError.notFound("Affiliate account");
  }

  const { searchParams } = new URL(request.url);
  const page = parseInt(searchParams.get("page") || "1");
  const limit = parseInt(searchParams.get("limit") || "20");
  const status = searchParams.get("status") || "";

  const skip = (page - 1) * limit;

  // Build where clause
  const where: Record<string, unknown> = {
    affiliateId: affiliate.id};

  if (status) {
    where.status = status;
  }

  const [sales, total] = await Promise.all([
    prisma.affiliateSale.findMany({
      where,
      skip,
      take: limit,
      orderBy: { createdAt: "desc" },
      select: {
        id: true,
        orderId: true,
        orderTotal: true,
        commissionType: true,
        commissionRate: true,
        commissionAmount: true,
        status: true,
        approvedAt: true,
        rejectedAt: true,
        rejectionReason: true,
        paidAt: true,
        createdAt: true}}),
    prisma.affiliateSale.count({ where }),
  ]);

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

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