route.ts

Go to the documentation of this file.

import { NextRequest, NextResponse } from 'next/server';
import { FieldpineServerApi } from '@/lib/server/fieldpineApi';
import { getRequestContext, validateApiAccess, getStoreApiUrl } from '@/lib/server/sessionUtils';
 
/**
 * Sales Totals Report
 * ELINK: retailmax.elink.sale.totals
 * Core sales reporting endpoint (46 uses)
 */
export async function GET(request: NextRequest) {
  try {
    // Get session context
    const context = await getRequestContext(request);
    if (!context || !context.isAuthenticated) {
      return NextResponse.json(
        { error: 'Authentication required' },
        { status: 401 }
      );
    }
 
    // Validate ELINK access
    if (!validateApiAccess(context, 'elink')) {
      return NextResponse.json(
        { error: 'ELINK access not permitted for this store type' },
        { status: 403 }
      );
    }
 
    const { searchParams } = new URL(request.url);
    
    // Date filters
    const startDate = searchParams.get('startDate');
    const endDate = searchParams.get('endDate');
    
    // Grouping options
    const groupBy = searchParams.get('groupBy'); // day, week, month, location, teller
    
    // Location and teller filters
    const locationId = searchParams.get('locationId');
    const tellerId = searchParams.get('tellerId');
    
    // Sort field
    const sortBy = searchParams.get('sortBy') || 'date';
 
    // Create store-specific API instance
    const storeApiUrl = getStoreApiUrl(context, 'elink');
    const api = new FieldpineServerApi(storeApiUrl, context.session.apiKey);
 
    console.log('[Sales Totals] Calling ELINK: retailmax.elink.sale.totals');
 
    // Build BUCK parameters
    const buckParams: Record<string, string | string[]> = {
      "3": "retailmax.elink.sale.totals",
      "10": "102,131,132,140,141,210,211,212,213,214" // Field selection
    };
 
    // Add date filters
    const filters: string[] = [];
    if (startDate) {
      filters.push(`f102,4,${startDate}`); // f102 >= startDate
    }
    if (endDate) {
      filters.push(`f102,1,${endDate}`); // f102 <= endDate
    }
    if (locationId) {
      filters.push(`f131,0,${locationId}`); // f131 = locationId
    }
    if (tellerId) {
      filters.push(`f140,0,${tellerId}`); // f140 = tellerId
    }
    if (filters.length > 0) {
      buckParams["9"] = filters;
    }
 
    // Add grouping
    if (groupBy) {
      switch (groupBy) {
        case 'day':
          buckParams["15"] = "102"; // Group by date
          break;
        case 'location':
          buckParams["15"] = "131"; // Group by location
          break;
        case 'teller':
          buckParams["15"] = "140"; // Group by teller
          break;
        case 'department':
          buckParams["15"] = "133"; // Group by department
          break;
      }
    }
 
    // Add sort
    switch (sortBy) {
      case 'date':
        buckParams["13"] = "completeddt";
        break;
      case 'revenue':
        buckParams["13"] = "211"; // f211 = revenue
        break;
      case 'units':
        buckParams["13"] = "210"; // f210 = units
        break;
      default:
        buckParams["13"] = "completeddt";
    }
 
    // Use store-specific URL for API calls
    const result = await api.buckApiCall(buckParams, context.session.apiKey, context.store.url);
 
    // Process ELINK response
    if (result && result.DATS && Array.isArray(result.DATS)) {
      const totals = result.DATS.map((item: any) => ({
        date: item.f102,
        locationId: item.f131,
        locationName: item.f132,
        tellerId: item.f140,
        tellerName: item.f141,
        departmentId: item.f133,
        departmentName: item.f134,
        totalUnits: item.f210,
        totalRevenue: item.f211,
        totalCost: item.f212,
        grossProfit: item.f213,
        grossMargin: item.f214,
        transactionCount: item.f220,
        averageTransaction: item.f221,
        taxCollected: item.f230,
        discountGiven: item.f231
      }));
 
      // Calculate overall summary
      const summary = {
        totalRevenue: totals.reduce((sum: number, t: any) => sum + (t.totalRevenue || 0), 0),
        totalUnits: totals.reduce((sum: number, t: any) => sum + (t.totalUnits || 0), 0),
        totalCost: totals.reduce((sum: number, t: any) => sum + (t.totalCost || 0), 0),
        totalProfit: totals.reduce((sum: number, t: any) => sum + (t.grossProfit || 0), 0),
        totalTransactions: totals.reduce((sum: number, t: any) => sum + (t.transactionCount || 0), 0),
        averageMargin: 0,
        averageTransaction: 0
      };
 
      if (summary.totalRevenue > 0) {
        summary.averageMargin = (summary.totalProfit / summary.totalRevenue) * 100;
      }
      if (summary.totalTransactions > 0) {
        summary.averageTransaction = summary.totalRevenue / summary.totalTransactions;
      }
 
      return NextResponse.json({
        success: true,
        data: totals,
        summary,
        count: totals.length,
        groupBy,
        source: 'elink'
      });
    }
 
    return NextResponse.json({
      success: true,
      data: [],
      summary: {},
      count: 0,
      groupBy,
      source: 'elink'
    });
 
  } catch (error) {
    console.error('[Sales Totals] Error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch sales totals' },
      { status: 500 }
    );
  }
}