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";
 
/**
 * Sales Statistics API
 * 
 * Provides various sales statistics endpoints:
 * - ?type=today - Today's overall stats
 * - ?type=department - Today's stats by department
 * - ?type=hourly - Sales broken down by hour
 * - ?type=store - Sales by store/location
 * - ?type=payment - Sales by payment method
 * - ?type=staff - Sales by staff member
 */
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 type = searchParams.get("type") || "today";
 
    let endpoint: string;
    let params: Record<string, string> = {};
 
    switch (type) {
      case "today":
        // Overall today's statistics
        params = {
          "3": "retailmax.elink.stats.today"
        };
        break;
 
      case "department":
        // Today's stats by department
        params = {
          "3": "retailmax.elink.stats.today.department"
        };
        break;
 
      case "hourly":
        // Sales grouped by hour - use sale.totals.group with hour dimension
        params = {
          "3": "retailmax.elink.sale.totals.group",
          "15": "hour", // Group by hour
          "9": "f110,5,today" // Filter: sales >= today
        };
        break;
 
      case "daily":
        // Sales grouped by day for the last 7 days
        params = {
          "3": "retailmax.elink.sale.totals.group",
          "15": "day", // Group by day
          "9": "f110,5,today-7" // Filter: sales >= 7 days ago
        };
        break;
 
      case "store":
        // Sales grouped by store/location
        params = {
          "3": "retailmax.elink.sale.totals.group",
          "15": "location", // Group by location
          "9": "f110,5,today"
        };
        break;
 
      case "payment":
        // Get flat sale list with payment details
        params = {
          "3": "retailmax.elink.saleflat.list",
          "9": "f110,5,today",
          "10": "110,120,130,140" // Include sale fields + payment info
        };
        break;
 
      case "staff":
        // Sales grouped by staff/teller
        params = {
          "3": "retailmax.elink.sale.totals.group",
          "15": "teller", // Group by staff
          "9": "f110,5,today"
        };
        break;
 
      default:
        return NextResponse.json(
          { success: false, error: "Invalid type parameter" },
          { status: 400 }
        );
    }
 
    console.log(`[Sales Stats API] Fetching ${type} stats`);
    
    const result = await fieldpineServerApi.buckApiCall(params, authData.apiKey!);
 
    console.log(`[Sales Stats API] Result for ${type}:`, {
      hasDats: !!result.DATS,
      datsLength: result.DATS?.length,
      resultKeys: Object.keys(result)
    });
 
    return NextResponse.json({
      success: true,
      data: result,
      type,
      source: "elink",
    });
  } catch (error: any) {
    console.error("[Sales Stats API] Error:", error);
    return NextResponse.json(
      { success: false, error: error.message || "Failed to fetch sales statistics" },
      { status: error.status || 500 }
    );
  }
}