export interface TrainingSummaryReportData {
  year: number;
  summary: {
    total_programs: number;
    total_sessions: number;
    completed_sessions: number;
    total_enrollments: number;
    completed_enrollments: number;
    completion_rate: number;
    unique_employees: number;
    total_cost: number;
  };
  by_category: Record<string, { programs: number; sessions: number }>;
  by_provider: Record<string, { sessions: number; cost: number }>;
}

export interface EmployeeTrainingHistoryItem {
  id: string;
  session_id: string;
  program_name: string;
  session_title: string;
  provider: string;
  status: string;
  start_date: string | null;
  end_date: string | null;
  score: number | null;
}

export interface EmployeeCertificationItem {
  id: string;
  certification_name: string;
  certificate_number: string | null;
  status: string;
  issue_date: string | null;
  expiry_date: string | null;
}

export interface EmployeeTrainingRecordData {
  employee_id: string;
  training_history: EmployeeTrainingHistoryItem[];
  certifications: EmployeeCertificationItem[];
  evaluations_submitted: number;
  total_trainings: number;
  completed_trainings: number;
}

export interface ComplianceCertificationItem {
  certification_id: string;
  name: string;
  issuing_body: string | null;
  validity_months: number | null;
  total_holders: number;
  active: number;
  expired: number;
  expiring_soon: number;
  compliance_rate: number;
}

export interface ComplianceReportData {
  certifications: ComplianceCertificationItem[];
  overall: {
    total_mandatory_certifications: number;
    total_holders: number;
    active: number;
    compliance_rate: number;
  };
}