route.ts

Go to the documentation of this file.

import { NextRequest, NextResponse } from "next/server";
import { getStoredAuth } from "@/lib/server/auth";
import { fieldpineServerApi } from "@/lib/server/fieldpineApi";
 
/**
 * GET /api/v1/reports/trading-summary
 * Get trading summary for date range
 * Uses retailmax.elink.summary.trading
 */
export async function GET(request: NextRequest) {
  try {
    const authData = await getStoredAuth();
    if (!authData?.apiKey) {
      return NextResponse.json(
        { success: false, error: "Unauthorized" },
        { status: 401 }
      );
    }
 
    const searchParams = request.nextUrl.searchParams;
    const dateFrom = searchParams.get("dateFrom") || new Date().toISOString().split('T')[0];
    const dateTo = searchParams.get("dateTo");
    const groupBy = searchParams.get("groupBy"); // 'location', 'srcuid' (lane/till), or null for totals
 
    // Build the filter - date range
    const dateFilter = dateTo 
      ? `f101,100,${dateFrom},${dateTo}`
      : `f101,100,${dateFrom}`;
 
    const buckParams: Record<string, string> = {
      "3": "retailmax.elink.summary.trading",
      "10": "311,320", // Fields to return
      "9": dateFilter
    };
 
    // Add grouping if specified
    if (groupBy) {
      buckParams["15"] = `2,${groupBy}`;
    }
 
    console.log("[Trading Summary API] Params:", buckParams);
 
    const result = await fieldpineServerApi.buckApiCall(buckParams, authData.apiKey);
 
    console.log("[Trading Summary API] Result:", {
      hasData: !!result,
      resultKeys: Object.keys(result || {})
    });
 
    return NextResponse.json({
      success: true,
      data: result,
      meta: {
        dateFrom,
        dateTo,
        groupBy: groupBy || 'totals'
      },
    });
  } catch (error: any) {
    console.error("[Trading Summary API] Error:", error);
    return NextResponse.json(
      { success: false, error: error.message || "Failed to fetch trading summary" },
      { status: 500 }
    );
  }
}