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';
 
/**
 * Purchase Orders Summary
 * BUCK: retailmax.elink.purchaseorder.summary
 * Returns overview of purchase orders
 */
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);
    
    // Filters
    const startDate = searchParams.get('startDate');
    const endDate = searchParams.get('endDate');
    const limit = searchParams.get('limit') || '100';
    const status = searchParams.get('status'); // pending, received, cancelled
    const supplierId = searchParams.get('supplierId');
 
    // Build BUCK parameters
    const params: string[] = [
      '3=retailmax.elink.purchaseorder.summary',
      `8=${limit}`
    ];
 
    // Add date filters
    if (startDate) {
      params.push(`9=f102,4,${startDate}`); // PO date
    }
    if (endDate) {
      params.push(`9=f102,1,${endDate}`);
    }
 
    // Add supplier filter
    if (supplierId) {
      params.push(`9=f220,2,${supplierId}`);
    }
 
    // Add status filter
    if (status) {
      let statusCode = '0';
      switch (status) {
        case 'pending':
          statusCode = '1';
          break;
        case 'received':
          statusCode = '2';
          break;
        case 'cancelled':
          statusCode = '9';
          break;
      }
      params.push(`9=f110,2,${statusCode}`);
    }
 
    const query = params.join('&');
    const url = `/GNAP/j/buck?${query}`;
 
    console.log('[PO Summary] 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 orders = result.DATS.map((item: any) => ({
        orderId: item.f100,
        orderNumber: item.f101,
        orderDate: item.f102,
        supplierId: item.f220,
        supplierName: item.f221,
        status: item.f110,
        statusName: item.f111,
        totalItems: item.f210,
        totalUnits: item.f211,
        totalCost: item.f212,
        receivedDate: item.f103,
        receivedItems: item.f213,
        receivedUnits: item.f214,
        receivedCost: item.f215,
        locationId: item.f131,
        locationName: item.f132,
        notes: item.f120
      }));
 
      // Calculate summary statistics
      const summary = {
        totalOrders: orders.length,
        totalCost: orders.reduce((sum: number, o: any) => sum + (o.totalCost || 0), 0),
        pendingOrders: orders.filter((o: any) => o.status === 1).length,
        receivedOrders: orders.filter((o: any) => o.status === 2).length,
        cancelledOrders: orders.filter((o: any) => o.status === 9).length
      };
 
      return NextResponse.json({
        success: true,
        data: orders,
        count: orders.length,
        summary,
        source: 'buck'
      });
    }
 
    return NextResponse.json({
      success: true,
      data: [],
      count: 0,
      source: 'buck'
    });
 
  } catch (error) {
    console.error('[PO Summary] Error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch purchase orders' },
      { status: 500 }
    );
  }
}