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';
 
/**
 * Pareto Analysis (80/20 Rule)
 * BUCK: retailmax.elink.product.paretolist
 * Returns top performing products by various metrics
 */
export async function GET(request: NextRequest) {
  try {
    const authData = await getStoredAuth();
    if (!authData || !authData.authenticated) {
      return NextResponse.json(
        { error: 'Authentication required' },
        { status: 401 }
      );
    }
 
    const { searchParams } = new URL(request.url);
    
    // Date filters
    const startDate = searchParams.get('startDate');
    const endDate = searchParams.get('endDate');
    const limit = searchParams.get('limit') || '50';
    
    // Analysis type: basketrate, grossmargin, returns, volume, revenue
    const type = searchParams.get('type') || 'revenue';
 
    // Build BUCK parameters
    const params: string[] = [
      '3=retailmax.elink.product.paretolist',
      `8=${limit}`
    ];
 
    // Add date filters
    if (startDate) {
      params.push(`9=f102,4,${startDate}`);
    }
    if (endDate) {
      params.push(`9=f102,1,${endDate}`);
    }
 
    // Set analysis type
    switch (type) {
      case 'basketrate':
        params.push('100=1'); // Sort by basket rate
        break;
      case 'grossmargin':
        params.push('100=2'); // Sort by gross margin
        break;
      case 'returns':
        params.push('100=3'); // Sort by return rate
        break;
      case 'volume':
        params.push('100=4'); // Sort by units sold
        break;
      case 'revenue':
      default:
        params.push('100=5'); // Sort by revenue (default)
        break;
    }
 
    const query = params.join('&');
    const url = `/GNAP/j/buck?${query}`;
 
    console.log('[Pareto Analysis] BUCK query:', url);
 
    const result = await fieldpineServerApi.apiCall(url, {
      cookie: authData.apiKey,
      useOpenApi: false
    });
 
    // Process BUCK response
    if (result && result.DATS && Array.isArray(result.DATS)) {
      const products = result.DATS.map((item: any, index: number) => ({
        rank: index + 1,
        productId: item.f200,
        productName: item.f201,
        barcode: item.f202,
        unitsSold: item.f210,
        revenue: item.f211,
        cost: item.f212,
        grossProfit: item.f213,
        grossMargin: item.f214,
        basketRate: item.f220, // % of transactions containing this item
        returnRate: item.f221,
        averagePrice: item.f222,
        supplierId: item.f230,
        supplierName: item.f231,
        departmentId: item.f240,
        departmentName: item.f241,
        percentOfTotal: item.f250 // Cumulative % contribution
      }));
 
      // Calculate 80/20 breakpoint
      const breakpoint = products.findIndex((p: any) => p.percentOfTotal >= 80);
      
      return NextResponse.json({
        success: true,
        data: products,
        count: products.length,
        type,
        analysis: {
          top20PercentCount: Math.ceil(products.length * 0.2),
          eightyPercentBreakpoint: breakpoint > 0 ? breakpoint : products.length,
          top20PercentRevenue: products.slice(0, Math.ceil(products.length * 0.2))
            .reduce((sum: number, p: any) => sum + (p.revenue || 0), 0)
        },
        source: 'buck'
      });
    }
 
    return NextResponse.json({
      success: true,
      data: [],
      count: 0,
      type,
      source: 'buck'
    });
 
  } catch (error) {
    console.error('[Pareto Analysis] Error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch pareto analysis' },
      { status: 500 }
    );
  }
}