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) {
  try {
    const authData = await getStoredAuth();
    if (!authData?.authenticated) {
      return NextResponse.json(
        { success: false, error: 'Authentication required' },
        { status: 401 }
      );
    }
 
    // Fetch products with filter a5
    const result = await fieldpineServerApi.buckApiCall({
      "3": "retailmax.elink.products",
      "8": "150000",
      "9": "f503,0,a5", // Note: Using a5 filter as per user's request
      "10": "113,349,100,101,105,103,113s,1101,1102",
      "18": "1101,1102"
    }, authData.apiKey);
 
    const products = result.DATS || [];
 
    // Group products by PLU code (f105)
    const pluGroups = new Map<string, any[]>();
    
    products.forEach((product: any) => {
      const plu = product.f105;
      
      // Only process products with a PLU
      if (plu && plu.trim() !== '') {
        if (!pluGroups.has(plu)) {
          pluGroups.set(plu, []);
        }
        pluGroups.get(plu)!.push(product);
      }
    });
 
    // Find PLUs with duplicates (more than one product)
    const duplicates: any[] = [];
    
    pluGroups.forEach((productList: any, plu: string) => {
      if (productList.length > 1) {
        duplicates.push({
          plu: plu,
          count: productList.length,
          products: productList.map((p: any) => ({
            id: p.f100,
            name: p.f101,
            price: p.f103,
            cost: p.f108,
            salesInfo: p.f1102 || 'No sales data'
          }))
        });
      }
    });
 
    // Sort by count (most duplicates first)
    duplicates.sort((a: any, b: any) => b.count - a.count);
 
    return NextResponse.json({
      success: true,
      data: {
        duplicates,
        totalProducts: products.length,
        duplicatePLUCount: duplicates.length,
        totalDuplicateProducts: duplicates.reduce((sum, d) => sum + d.count, 0)
      }
    });
 
  } catch (error: any) {
    console.error('Error fetching duplicate PLU data:', error);
    return NextResponse.json(
      { success: false, error: error.message || 'Failed to fetch duplicate PLU data' },
      { status: 500 }
    );
  }
}