Reporting & Analytics

// Executive dashboard metrics
interface ExecutiveDashboard {
  period: 'today' | 'week' | 'month' | 'quarter' | 'year';
  metrics: {
    // Financial
    inventoryValue: number;
    inventoryValueChange: number; // vs. previous period
    
    // Operational
    ordersFulfilled: number;
    fulfillmentRate: number; // percentage
    averageOrderTime: number; // minutes
    
    // Accuracy
    pickAccuracy: number; // percentage
    inventoryAccuracy: number; // percentage
    perfectOrderRate: number; // percentage
    
    // Productivity
    ordersPerEmployee: number;
    costPerOrder: number;
    utilizationRate: number; // percentage
    
    // Customer
    onTimeDelivery: number; // percentage
    returnRate: number; // percentage
    customerSatisfaction: number; // score
  };
  alerts: Alert[];
  topProducts: Product[];
  bottlenecks: Bottleneck[];
}

// Custom report definition
interface CustomReport {
  id: string;
  name: string;
  description?: string;
  dataSource: string;
  fields: ReportField[];
  filters: ReportFilter[];
  grouping?: ReportGrouping;
  sorting: ReportSort[];
  formatting: ReportFormatting;
  schedule?: ReportSchedule;
}

interface ReportField {
  name: string;
  label: string;
  type: 'string' | 'number' | 'date' | 'boolean';
  format?: string;
  calculation?: 'sum' | 'avg' | 'count' | 'min' | 'max';
}

// Report email configuration
interface ReportEmailConfig {
  reportId: string;
  schedule: {
    frequency: 'daily' | 'weekly' | 'monthly' | 'event';
    time?: string; // HH:MM format
    dayOfWeek?: number; // 0-6 for weekly
    dayOfMonth?: number; // 1-31 for monthly
    eventTrigger?: string; // for event-based
  };
  recipients: {
    to: string[];
    cc?: string[];
    bcc?: string[];
  };
  format: 'xlsx' | 'pdf' | 'csv';
  subject: string;
  body?: string;
  attachData: boolean; // false = link only
}