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';
 
/**
 * GET /api/v1/elink/sales/flat
 * Fetch flattened sales list with line items, customer, and product details
 * Query params:
 * - startDate: Start date filter (YYYY-MM-DD)
 * - endDate: End date filter (YYYY-MM-DD)
 * - limit: Max number of records (default 200)
 * - includeCustomer: Include customer details (default true)
 * - includeProduct: Include product details (default true)
 */
export async function GET(request: NextRequest) {
  try {
    const context = await getRequestContext(request);
    if (!context?.session) {
      return NextResponse.json(
        { success: false, error: 'Not authenticated' },
        { status: 401 }
      );
    }
 
    const { searchParams } = new URL(request.url);
    const startDate = searchParams.get('startDate');
    const endDate = searchParams.get('endDate');
    const limit = searchParams.get('limit') || '200';
    const includeCustomer = searchParams.get('includeCustomer') !== 'false';
    const includeProduct = searchParams.get('includeProduct') !== 'false';
 
    console.log('[Sales Flat] Fetching flat sales list:', {
      startDate,
      endDate,
      limit,
      includeCustomer,
      includeProduct
    });
 
    // Build BUCK parameters for retailmax.elink.saleflat.list
    const buckParams: Record<string, string> = {
      '3': 'retailmax.elink.saleflat.list',
      '8': limit,
      '103': includeCustomer ? '1' : '0', // Include customer details
      '104': includeProduct ? '1' : '0', // Include product details
      // Field list: sale date, location name, sale ID, total, tax, payment method, product, qty, line total
      '10': '102,106,101,107,104,201,202,203,301'
    };
 
    // Add date filters if provided
    if (startDate) {
      buckParams['9'] = `f102,4,${startDate}`; // >= start date
    }
    if (endDate) {
      buckParams['9.1'] = `f102,1,${endDate}`; // <= end date
    }
 
    console.log('[Sales Flat] BUCK params:', buckParams);
 
    const result = await fieldpineServerApi.buckApiCall(buckParams, context.session.apiKey);
 
    if (!result || !result.APPT) {
      return NextResponse.json({
        success: true,
        data: [],
        message: 'No sales found for the specified period'
      });
    }
 
    console.log(`[Sales Flat] Successfully fetched ${result.APPT.length} line items`);
    
    return NextResponse.json({
      success: true,
      data: result.APPT,
      count: result.APPT.length
    });
 
  } catch (error) {
    console.error('[Sales Flat] Error:', error);
    
    // Check if it's a 403 error
    if (error instanceof Error && error.message.includes('403')) {
      return NextResponse.json(
        { 
          success: false, 
          error: 'Authentication expired. Please log in again.'
        },
        { status: 403 }
      );
    }
 
    return NextResponse.json(
      { 
        success: false, 
        error: error instanceof Error ? error.message : 'Failed to fetch sales data'
      },
      { status: 500 }
    );
  }
}