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 Detail Report (Line-by-Line)
 * ELINK: retailmax.elink.saleflat.list
 * Returns detailed line items for all sales transactions
 */
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'); // YYYY-MM-DD
    const endDate = searchParams.get('endDate'); // YYYY-MM-DD
    const limit = searchParams.get('limit') || '200';
    
    // Location filter
    const locationId = searchParams.get('locationId');
    
    // Department filter
    const departmentId = searchParams.get('departmentId');
 
    // Create store-specific API instance
    const storeApiUrl = getStoreApiUrl(context, 'elink');
    const api = new FieldpineServerApi(storeApiUrl, context.session.apiKey);
 
    console.log('[Sales Detail] Calling ELINK: retailmax.elink.saleflat.list');
 
    // Build BUCK parameters
    const buckParams: Record<string, string | string[]> = {
      "3": "retailmax.elink.saleflat.list",
      "8": limit, // Limit records
      "103": "1", // Include product details
      "104": "1"  // Include customer details
    };
 
    // Add date and other filters
    const filters: string[] = [];
    if (startDate) {
      filters.push(`f102,4,${startDate}`); // Start date (f102 = sale date)
    }
    if (endDate) {
      filters.push(`f102,1,${endDate}`); // End date
    }
    if (locationId) {
      filters.push(`f131,2,${locationId}`); // f131 = location
    }
    if (departmentId) {
      filters.push(`f133,2,${departmentId}`); // f133 = department
    }
    if (filters.length > 0) {
      buckParams["9"] = filters;
    }
 
    const result = await api.buckApiCall(buckParams, context.session.apiKey);
 
    // Process BUCK response
    if (result && result.DATS && Array.isArray(result.DATS)) {
      const sales = result.DATS.map((item: any) => ({
        saleId: item.f100,
        saleDate: item.f102,
        productId: item.f200,
        productName: item.f201,
        barcode: item.f202,
        quantity: item.f210,
        unitPrice: item.f211,
        lineTotal: item.f212,
        locationId: item.f131,
        locationName: item.f132,
        departmentId: item.f133,
        departmentName: item.f134,
        tellerId: item.f140,
        tellerName: item.f141,
        customerId: item.f300,
        customerName: item.f301,
        paymentType: item.f250,
        tax: item.f213,
        discount: item.f214
      }));
 
      return NextResponse.json({
        success: true,
        data: sales,
        count: sales.length,
        source: 'elink'
      });
    }
 
    return NextResponse.json({
      success: true,
      data: [],
      count: 0,
      source: 'elink'
    });
 
  } catch (error) {
    console.error('[Sales Detail] Error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch sales detail' },
      { status: 500 }
    );
  }
}