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';
 
/**
 * Today's Statistics
 * BUCK: retailmax.elink.stats.today
 * Essential dashboard statistics (26 uses)
 */
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);
    
    // Optional location filter
    const locationId = searchParams.get('locationId');
 
    // Build BUCK parameters
    const params: string[] = [
      '3=retailmax.elink.stats.today'
    ];
 
    // Add location filter if specified
    if (locationId) {
      params.push(`9=f131,0,${locationId}`);
    }
 
    const query = params.join('&');
    const url = `/GNAP/j/buck?${query}`;
 
    console.log('[Stats Today] 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)) {
      // Usually returns a single record with today's stats
      const stats = result.DATS[0] || {};
      
      const todayStats = {
        // Sales metrics
        totalSales: stats.f210 || 0,
        totalRevenue: stats.f211 || 0,
        totalCost: stats.f212 || 0,
        grossProfit: stats.f213 || 0,
        grossMargin: stats.f214 || 0,
        
        // Transaction metrics
        transactionCount: stats.f220 || 0,
        averageTransaction: stats.f221 || 0,
        itemsPerTransaction: stats.f222 || 0,
        
        // Customer metrics
        customersToday: stats.f300 || 0,
        newCustomers: stats.f301 || 0,
        returningCustomers: stats.f302 || 0,
        
        // Payment metrics
        cashSales: stats.f250 || 0,
        cardSales: stats.f251 || 0,
        creditSales: stats.f252 || 0,
        
        // Tax and discounts
        taxCollected: stats.f230 || 0,
        discountGiven: stats.f231 || 0,
        
        // Comparison to yesterday
        yesterdayRevenue: stats.f400 || 0,
        revenueChange: stats.f401 || 0,
        revenueChangePercent: stats.f402 || 0,
        
        // Time tracking
        firstSaleTime: stats.f500 || null,
        lastSaleTime: stats.f501 || null,
        busyHour: stats.f502 || null,
        
        // Location info
        locationId: stats.f131 || null,
        locationName: stats.f132 || null,
        
        // Timestamp
        generatedAt: new Date().toISOString()
      };
 
      // Calculate some derived metrics
      if (todayStats.yesterdayRevenue > 0) {
        todayStats.revenueChangePercent = 
          ((todayStats.totalRevenue - todayStats.yesterdayRevenue) / todayStats.yesterdayRevenue) * 100;
      }
 
      return NextResponse.json({
        success: true,
        data: todayStats,
        source: 'buck'
      });
    }
 
    // Return empty stats if no data
    return NextResponse.json({
      success: true,
      data: {
        totalSales: 0,
        totalRevenue: 0,
        transactionCount: 0,
        customersToday: 0,
        generatedAt: new Date().toISOString()
      },
      source: 'buck'
    });
 
  } catch (error) {
    console.error('[Stats Today] Error:', error);
    return NextResponse.json(
      { error: 'Failed to fetch today\'s statistics' },
      { status: 500 }
    );
  }
}