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';
 
/**
 * Teller/Staff Performance Statistics
 * ELINK: retailmax.elink.sale.totals.group (grouped by teller)
 * Returns sales performance by staff member
 */
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 locationId = searchParams.get('locationId');
 
    // Build BUCK parameters for teller-grouped sales totals
    const buckParams: Record<string, string | string[]> = {
      "3": "retailmax.elink.sale.totals.group",
      "10": "11000", // Request field 11000 series (quartile stats)
      "15": "2,1,tid", // Group by teller ID
      "13": "120", // Sort by sales amount (f120)
      "8": "200" // Limit
    };
 
    // Add date filters
    const filters: string[] = [];
    if (startDate) {
      filters.push(`f110,4,${startDate}`); // f110 >= startDate
    }
    if (endDate) {
      filters.push(`f110,1,${endDate}`); // f110 < endDate
    }
    if (locationId) {
      filters.push(`f7,0,${locationId}`); // Filter by location
    }
    
    if (filters.length > 0) {
      buckParams["9"] = filters;
    }
    
    const result = await fieldpineServerApi.buckApiCall(buckParams, context.session.apiKey);
    
    // Extract APPD array from BUCK response
    const tellerData = result?.APPD || [];
    
    console.log(`[Teller Performance] Loaded performance data for ${tellerData.length} tellers`);
    
    return NextResponse.json({ 
      success: true, 
      data: tellerData,
      source: 'elink'
    });
    
  } catch (error) {
    console.error('[Teller Performance] Error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch teller performance', details: error instanceof Error ? error.message : 'Unknown error' },
      { status: 500 }
    );
  }
}