route.ts

Go to the documentation of this file.

import { NextRequest, NextResponse } from "next/server";
import { fieldpineServerApi } from "@/lib/server/fieldpineApi";
import { getStoredAuth } from "@/lib/server/auth";
 
/**
 * Product Performance Report API
 * 
 * Get product sales performance statistics
 * Query params:
 * - department: Department ID to filter by (optional)
 * - groupBy: 'product' | 'customer' | 'staff' (default: 'product')
 * - limit: Number of results (default: 20)
 * - dateFrom: Start date filter (default: 'today')
 */
export async function GET(request: NextRequest) {
  try {
    const authData = await getStoredAuth();
    if (!authData) {
      return NextResponse.json({ error: "Unauthorized" }, { status: 401 });
    }
 
    const { searchParams } = new URL(request.url);
    const department = searchParams.get("department");
    const groupBy = searchParams.get("groupBy") || "product";
    const limit = searchParams.get("limit") || "20";
    const dateFrom = searchParams.get("dateFrom") || "today";
 
    // Map groupBy to field codes
    const groupByMap: Record<string, string> = {
      product: "pid",
      customer: "cid",
      staff: "tid",
    };
 
    const groupByField = groupByMap[groupBy] || "pid";
 
    // Build parameters
    const params: Record<string, string | string[]> = {
      "3": "retailmax.elink.stats.product.performance",
      "9": [`f102,4,${dateFrom}`], // Date filter
      "15": `2,${groupByField}`, // Group by
      "8": limit,
      "100": "1",
    };
 
    // Add department filter if specified
    if (department) {
      (params["9"] as string[]).push(`f105,0,${department}`);
    }
 
    console.log(`[Product Performance API] Fetching performance for ${groupBy}`, {
      department,
      dateFrom,
      limit
    });
 
    const result = await fieldpineServerApi.buckApiCall(params, authData.apiKey!);
 
    return NextResponse.json({
      success: true,
      data: result,
      params: {
        department,
        groupBy,
        limit,
        dateFrom
      }
    });
  } catch (error: any) {
    console.error("[Product Performance API] Error:", error);
    return NextResponse.json(
      { success: false, error: error.message || "Failed to fetch product performance" },
      { status: error.status || 500 }
    );
  }
}