Reports and Analytics

enum ReportType {
  DAILY      // Single day snapshot
  WEEKLY     // 7-day period
  MONTHLY    // Calendar month
  QUARTERLY  // 3-month period
  CUSTOM     // User-defined date range
}

model ReportSession {
  id           String     @id
  supervisorId String
  supervisor   User
  
  reportType  ReportType @default(CUSTOM)
  title       String?
  periodStart DateTime
  periodEnd   DateTime
  
  // Cached metrics at report generation time
  totalOfficers  Int     @default(0)
  totalUnions    Int     @default(0)
  totalMembers   Int     @default(0)
  totalLoans     Int     @default(0)
  activeLoans    Int     @default(0)
  completedLoans Int     @default(0)
  defaultedLoans Int     @default(0)
  
  totalDisbursed   Decimal @default(0) @db.Decimal(14, 2)
  totalRepaid      Decimal @default(0) @db.Decimal(14, 2)
  totalOutstanding Decimal @default(0) @db.Decimal(14, 2)
  collectionRate   Decimal @default(0) @db.Decimal(5, 2)
  
  // Full report data snapshot
  reportData Json?
  
  // Officer performance breakdown
  officerMetrics Json?
  
  generatedAt DateTime @default(now())
}

// POST /api/supervisor-reports/generate
const generateReport = async (data: {
  supervisorId?: string;  // Admin can specify
  reportType: 'DAILY' | 'WEEKLY' | 'MONTHLY' | 'QUARTERLY' | 'CUSTOM';
  periodStart: Date;
  periodEnd: Date;
  title?: string;
}) => {
  // Calculates metrics for date range
  // Saves report session
  // Returns complete report data
}

// GET /api/supervisor-reports/dashboard?supervisorId=xxx&periodStart=2024-01-01&periodEnd=2024-12-31
const getDashboard = async (params: {
  supervisorId?: string;  // Admin can view any supervisor
  periodStart?: Date;
  periodEnd?: Date;
}) => {
  return {
    summary: {
      totalOfficers: number;
      totalUnions: number;
      totalMembers: number;
      totalLoans: number;
      activeLoans: number;
      // ... more metrics
    },
    officers: Array<{
      id: string;
      name: string;
      metrics: {
        unionsCount: number;
        membersCount: number;
        loansCount: number;
        // ... performance data
      }
    }>,
    unions: Array<{
      id: string;
      name: string;
      officer: string;
      metrics: {
        // ... union data
      }
    }>,
    trends: {
      // ... time-series data
    }
  };
}

// Get real-time dashboard
GET /api/supervisor-reports/dashboard?supervisorId=xxx&periodStart=2024-01-01&periodEnd=2024-12-31

// Generate new report session
POST /api/supervisor-reports/generate
Body: {
  supervisorId?: string;  // Admin only
  reportType: 'DAILY' | 'WEEKLY' | 'MONTHLY' | 'QUARTERLY' | 'CUSTOM';
  periodStart: Date;
  periodEnd: Date;
  title?: string;
}

// Get all report sessions
GET /api/supervisor-reports/sessions?supervisorId=xxx&page=1&limit=10

// Get report session by ID
GET /api/supervisor-reports/sessions/:id?supervisorId=xxx

// Delete report session
DELETE /api/supervisor-reports/sessions/:id

// Get credit officers under supervisor
GET /api/supervisor-reports/officers?supervisorId=xxx