route.ts

Go to the documentation of this file.

import { NextRequest, NextResponse } from 'next/server';
import { fieldpineServerApi } from '@/lib/server/fieldpineApi';
import { getRequestContext } from '@/lib/server/sessionUtils';
 
/**
 * Daily Sales Statistics (Day of Week)
 * ELINK: retailmax.elink.sale.cube with dispmode=dow
 * Returns sales aggregated by day of week
 */
export async function GET(request: NextRequest) {
  try {
    const context = await getRequestContext(request);
    if (!context?.session) {
      return NextResponse.json(
        { error: 'Authentication required' },
        { status: 401 }
      );
    }
 
    const { searchParams } = new URL(request.url);
    const startDate = searchParams.get('startDate');
    const endDate = searchParams.get('endDate');
    const location = searchParams.get('location');
 
    // Build BUCK request parameters for day-of-week cube
    const buckParams: Record<string, string> = {
      "3": "retailmax.elink.sale.cube",
      "12": "dow" // Display mode: day of week
    };
 
    // Add date filters if provided
    if (startDate) {
      buckParams["9"] = `f110,4,${startDate}`;
    }
    if (endDate) {
      // Add as second date filter
      const key = startDate ? "9.1" : "9";
      buckParams[key] = `f110,1,${endDate}`;
    }
 
    // Add location filter if provided
    if (location && location !== '0') {
      buckParams["7"] = location;
    }
 
    const data = await fieldpineServerApi.buckApiCall(buckParams, context.session.apiKey);
 
    return NextResponse.json(data);
  } catch (error: any) {
    console.error('Error fetching daily sales:', error);
    return NextResponse.json(
      { error: error.message || 'Failed to fetch daily sales' },
      { status: 500 }
    );
  }
}