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';
 
interface ProductLowPrice {
  f100: number;      // Product ID
  f101: string;      // Product name
  f103: number;      // Price (sell price)
  f104?: number;     // ?
  f105: string;      // PLU/SKU
  f106?: number;     // ?
  f108?: number;     // Cost price
  f113?: number;     // ?
  f350?: number;     // ?
  f1101?: any;       // ?
  f1102?: string;    // Sales info
}
 
export async function GET(request: NextRequest) {
  try {
    // Verify authentication
    const authData = await getStoredAuth();
    if (!authData || !authData.authenticated) {
      return NextResponse.json(
        { error: 'Authentication required' },
        { status: 401 }
      );
    }
    
    console.log('[Products Priced Low] Fetching low-priced products...');
    
    // Fetch products priced below cost using BUCK API
    // Based on: https://iig.cwanz.online/GNAP/j/buck?3=retailmax.elink.products&10=113,349,100,101,105,103,113s,1101,1102&18=1101,1102&9=f503,0,a1&8=150000
    const result = await fieldpineServerApi.buckApiCall({
      "3": "retailmax.elink.products",
      "8": "150000",   // Limit to 150000 products
      "9": "f503,0,a1", // Filter: f503 equals "a1" (likely active products)
      "10": "113,349,100,101,105,103,113s,1101,1102", // Fields to return
      "18": "1101,1102" // Sort by these fields
    }, authData.apiKey);
    
    console.log('[Products Priced Low] BUCK result:', {
      hasRootType: !!result?.RootType,
      hasDats: !!result?.DATS,
      datsLength: result?.DATS?.length || 0
    });
    
    // Extract product data
    const products: ProductLowPrice[] = result?.DATS || [];
    
    if (!products || products.length === 0) {
      console.log('[Products Priced Low] No products found');
      return NextResponse.json({
        success: true,
        products: [],
        message: 'No low-priced products found'
      });
    }
    
    console.log('[Products Priced Low] Found', products.length, 'products');
    
    // Filter and transform products
    const lowPricedProducts = products
      .filter(p => {
        const sellPrice = p.f103 || 0;
        const costPrice = p.f108 || 0;
        // Only include products where sell price is less than cost price
        return costPrice > 0 && sellPrice < costPrice;
      })
      .map(p => {
        const sellPrice = p.f103 || 0;
        const costPrice = p.f108 || 0;
        const margin = costPrice > 0 ? ((sellPrice - costPrice) / costPrice) * 100 : 0;
        
        return {
          id: p.f100,
          sku: p.f105 || '',
          name: p.f101 || 'Unknown Product',
          cost: costPrice,
          sellPrice: sellPrice,
          margin: margin,
          salesInfo: p.f1102 || '',
          rawData: p
        };
      })
      .sort((a, b) => a.margin - b.margin); // Sort by margin (worst first)
    
    console.log('[Products Priced Low] Filtered to', lowPricedProducts.length, 'products below cost');
    
    return NextResponse.json({
      success: true,
      products: lowPricedProducts,
      totalProducts: products.length,
      lowPricedCount: lowPricedProducts.length,
      source: 'elink'
    });
  } catch (error: any) {
    console.error('Products Priced Low API error:', error);
    return NextResponse.json(
      { success: false, error: error.message || 'Failed to fetch low-priced products' },
      { status: 500 }
    );
  }
}