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';
 
export async function GET(
  request: NextRequest,
  context: { params: Promise<{ id: string }> }
) {
  try {
    const { id: saleId } = await context.params;
 
    // Get authentication from server-side store
    const authData = await getStoredAuth();
    if (!authData?.authenticated) {
      return NextResponse.json({ error: 'Not authenticated' }, { status: 401 });
    }
 
    // Fetch sale details using saleflat.list for denormalized data with line items
    console.log(`[Sale Details API] Fetching sale ${saleId}`);
    
    // Use saleflat.list which returns denormalized sale data including line items and payments
    let response = await fieldpineServerApi.buckApiCall(
      {
        '3': 'retailmax.elink.saleflat.list',
        '9': `f100,eq,${saleId}`, // Filter by sale ID
        '8': '1000'
      },
      authData.apiKey
    );
 
    console.log(`[Sale Details API] saleflat.list returned ${response?.DATS?.length || 0} records`);
 
    if (!response?.DATS || response.DATS.length === 0) {
      // Fallback to sale.list if saleflat doesn't work
      console.log(`[Sale Details API] Trying sale.list with picking filter...`);
      response = await fieldpineServerApi.buckApiCall(
        {
          '3': 'retailmax.elink.sale.list',
          '9': 'f108,in,200,202',
          '10': '2000,2001,2003,7000,905,906,907,130,131,133,902',
          '8': '1000'
        },
        authData.apiKey
      );
 
      const sale = response?.DATS?.find((s: any) => s.f100 == saleId);
      
      if (!sale) {
        return NextResponse.json(
          { success: false, error: `Sale ${saleId} not found` },
          { status: 404 }
        );
      }
 
      console.log(`[Sale Details API] Found sale ${saleId} via sale.list (no line items available)`);
      return NextResponse.json({
        success: true,
        data: sale
      });
    }
 
    // saleflat.list returns one row per line item, so we need to aggregate
    const saleRows = response.DATS;
    const firstRow = saleRows[0];
    
    // Build LINE array from flat rows
    const lineItems = saleRows.map((row: any) => ({
      f200: row.f200, // Product ID
      f202: row.f202, // Qty
      f205: row.f205, // Total Price
      f212: row.f212, // Description
      f213: row.f213, // PLU
      f303: row.f303, // Total Inc Tax
      f304: row.f304, // Total Ex Tax
      f305: row.f305  // Tax
    }));
 
    // Build sale object with aggregated data
    const sale: any = {
      f100: firstRow.f100,
      f101: firstRow.f101,
      f102: firstRow.f102,
      f108: firstRow.f108,
      f109: firstRow.f109,
      f117: firstRow.f117,
      f125: firstRow.f125,
      f130: firstRow.f130,
      f133: firstRow.f133,
      LINE: lineItems,
      PAYM: firstRow.PAYM, // Payments might still be in sub-array
      CUST: firstRow.CUST,
      DELI: firstRow.DELI
    };
 
    console.log(`[Sale Details API] Built sale ${saleId} with ${lineItems.length} line items`);
    
    return NextResponse.json({
      success: true,
      data: sale
    });
  } catch (error: any) {
    console.error('[Sale Details API] Error fetching sale details:', error);
    console.error('[Sale Details API] Error message:', error?.message);
    return NextResponse.json(
      { success: false, error: error?.message || 'Failed to fetch sale details' },
      { status: 500 }
    );
  }
}