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 PrinterCartridge {
  printerId: number;
  printerName: string;
  cartridges: number[];
}
 
// GET: Retrieve relationships from Fieldpine backend (disabled due to timeout issues)
export async function GET(request: NextRequest) {
  try {
    console.log('[Printers-Cartridges API] Feature disabled due to performance issues');
    
    // Get authentication
    const authData = await getStoredAuth();
    if (!authData || !authData.authenticated) {
      return NextResponse.json(
        { error: 'Authentication required' },
        { status: 401 }
      );
    }
    
    // Return empty array - backend queries time out
    console.log('[Printers-Cartridges API] Returning empty array (backend timeout issue)');
    return NextResponse.json({
      success: true,
      data: []
    });
  } catch (error: any) {
    console.log('[Printers-Cartridges API] Error:', error.message);
    return NextResponse.json({
      success: true,
      data: []
    });
  }
}
 
// POST: Save relationships to Fieldpine backend
export async function POST(request: NextRequest) {
  try {
    console.log('[Printers-Cartridges API] Saving to Fieldpine backend...');
    
    // Get authentication
    const authData = await getStoredAuth();
    if (!authData || !authData.authenticated) {
      return NextResponse.json(
        { error: 'Authentication required' },
        { status: 401 }
      );
    }
    
    const body = await request.json();
    const { relationships } = body;
    
    if (!Array.isArray(relationships)) {
      return NextResponse.json(
        { success: false, error: 'Invalid relationships data' },
        { status: 400 }
      );
    }
 
    // For now, we'll use a simple approach:
    // 1. Delete all existing relationships
    // 2. Insert the new ones via BUCK
    
    try {
      // Delete all existing records using BUCK
      await fieldpineServerApi.apiCall('/GNAP/j/buck', {
        method: 'DELETE',
        params: { '3': 'retailmax.elink.printercartridge' },
        cookie: authData.apiKey,
        useOpenApi: false
      });
    } catch (e) {
      // Ignore delete errors - table may be empty
      console.log('[Printers-Cartridges API] Delete completed or table was empty');
    }
 
    // Insert new relationships as rows
    const rows: any[] = [];
    for (const rel of relationships) {
      for (const cartridgeId of rel.cartridges) {
        // BUCK DATS format: array of values [printerid, cartridgeid]
        rows.push([rel.printerId, cartridgeId]);
      }
    }
 
    if (rows.length > 0) {
      try {
        // Insert all rows in one BUCK call
        await fieldpineServerApi.apiCall('/GNAP/j/buck', {
          method: 'POST',
          params: { '3': 'retailmax.elink.printercartridge' },
          body: { DATS: rows },
          cookie: authData.apiKey,
          useOpenApi: false
        });
        
        console.log(`[Printers-Cartridges API] Saved ${rows.length} relationships to backend`);
      } catch (err) {
        console.error('[Printers-Cartridges API] Error saving relationships:', err);
        throw err;
      }
    }
 
    return NextResponse.json({
      success: true,
      message: 'Relationships saved to backend successfully'
    });
  } catch (error: any) {
    console.error('[Printers-Cartridges API] Error saving:', error);
    return NextResponse.json(
      { success: false, error: error.message || 'Failed to save relationships' },
      { status: 500 }
    );
  }
}