route.ts

Go to the documentation of this file.

import { NextRequest, NextResponse } from "next/server";
import { getRequestContext, validateApiAccess, getStoreApiUrl } from "@/lib/server/sessionUtils";
import { FieldpineServerApi } from "@/lib/server/fieldpineApi";
 
/**
 * Sales Cube API - Multi-dimensional sales analysis
 * Uses ELINK: retailmax.elink.sale.cube
 * 
 * Security: Retail stores can access this (ELINK endpoint)
 * 
 * Provides flexible sales data aggregation and grouping
 * Query params:
 * - mode: Cube mode (default: 6)
 * - dimensions: Comma-separated list of dimensions to group by
 * - measures: Comma-separated list of measures to aggregate
 * - dateFrom/dateTo: Date range (old format)
 * - fromDate/toDate: Date range (franchise report format)
 * - filters: Additional filters as JSON array
 */
export async function GET(request: NextRequest) {
  try {
    // 1. Get session and store context
    const context = await getRequestContext(request);
    
    if (!context) {
      return NextResponse.json(
        { success: false, error: "Unauthorized - Please log in" },
        { status: 401 }
      );
    }
 
    // 2. SECURITY: Validate ELINK access (allowed for retail stores)
    const apiAccessValidation = validateApiAccess(context, 'elink');
    if (!apiAccessValidation.valid) {
      console.warn(`[API Security] ELINK access denied: ${apiAccessValidation.error}`);
      return NextResponse.json(
        { 
          success: false, 
          error: apiAccessValidation.error,
          code: apiAccessValidation.errorCode
        },
        { status: 403 }
      );
    }
 
    const { searchParams } = new URL(request.url);
    const mode = searchParams.get("mode") || "6";
    const dimensions = searchParams.get("dimensions") || "";
    const measures = searchParams.get("measures") || "tax_tot";
    const dateFrom = searchParams.get("dateFrom") || "01-01-2025";
    const dateTo = searchParams.get("dateTo") || "01-01-2026";
    const minAmount = searchParams.get("minAmount") || "0";
    const fromDate = searchParams.get("fromDate");
    const toDate = searchParams.get("toDate");
 
    // 3. Get store-specific API URL for ELINK
    const apiUrl = getStoreApiUrl(context, 'elink');
    const api = new FieldpineServerApi(apiUrl);
 
    console.log(`[Sales Cube API] Loading for ${context.store.name} (mode: ${mode})`);
 
    // Build parameters for sales cube
    const params: Record<string, string | string[]> = {
      "3": "retailmax.elink.sale.cube",
      "100": mode, // Cube mode
      "101": measures, // Measures to aggregate
      "9": []
    };
 
    // Use fromDate/toDate if provided (franchise report format), otherwise dateFrom/dateTo
    if (fromDate && toDate) {
      params["9"] = [
        `f110,4,${fromDate}`,
        `f110,1,${toDate}`
      ];
    } else {
      params["9"] = [
        `f110,4,${dateFrom}`,
        `f110,1,${dateTo}`,
        `f1008,5,${minAmount}`
      ];
    }
 
    // Add dimensions if specified
    if (dimensions) {
      params["102"] = dimensions;
    }
 
    console.log(`[Sales Cube API] Fetching cube analysis`, {
      store: context.store.name,
      mode,
      dimensions,
      measures,
      fromDate: fromDate || dateFrom,
      toDate: toDate || dateTo
    });
 
    const result = await api.buckApiCall(params, context.session.apiKey);
 
    // Return raw BUCK response for franchise report compatibility
    return NextResponse.json(result);
  } catch (error: any) {
    console.error("[Sales Cube API] Error:", error);
    return NextResponse.json(
      { success: false, error: error.message || "Failed to fetch sales cube data" },
      { status: error.status || 500 }
    );
  }
}