Compliance Setup

// packages/workbooks-db/src/schema/workbooks/compliance-phase1f.ts

interface ComplianceSchedule {
  id: string;
  assetId: string;
  requirementId: string;
  
  // Timing
  dueDate: Date;
  gracePeriodExpiry: Date;
  leadTimeDate: Date; // When to create job
  
  // Status
  status: "upcoming" | "due" | "overdue" | "completed" | "missed";
  
  // Linked entities
  generatedJobId?: string;
  completedJobId?: string;
}

interface AssetComplianceOverride {
  assetId: string;
  requirementId: string;
  
  // Override frequency
  frequencyOverride?: {
    value: number;
    unit: "days" | "weeks" | "months" | "years";
  };
  
  // Override timing
  leadTimeOverride?: number;
  gracePeriodOverride?: number;
  
  // Skip entirely
  skipped?: boolean;
  skipReason?: string;
  
  // Anchor date
  anchorDate?: Date; // Custom start date for calculations
}

// Locations in different jurisdictions may have different requirements
const locationOverrides = {
  locationId: "loc_123",
  jurisdictionOverride: "NYC", // Use NYC codes instead of state default
  additionalRequirements: ["local_fire_001"],
  exemptRequirements: ["state_hvac_quarterly"], // Exempt from this
};

┌─────────────────────────────────────────────────────────────┐
│  COMPLIANCE OVERVIEW                                         │
├─────────────────────────────────────────────────────────────┤
│                                                              │
│  Compliant    ████████████████████████████░░░░  85%  (425)  │
│  Due Soon     ██░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░  8%   (40)   │
│  Overdue      █░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░  4%   (20)   │
│  Missed       ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░  3%   (15)   │
│                                                              │
├─────────────────────────────────────────────────────────────┤
│  UPCOMING THIS WEEK                                          │
│  ├── 12 Fire Extinguisher Monthly Inspections               │
│  ├── 5 HVAC Filter Replacements                             │
│  └── 3 Sprinkler Quarterly Inspections                      │
│                                                              │
│  OVERDUE ITEMS (Action Required)                            │
│  ├── [!] Asset #1234 - Annual sprinkler test (3 days)      │
│  └── [!] Asset #5678 - Fire alarm inspection (1 day)       │
└─────────────────────────────────────────────────────────────┘

const calculateComplianceRisk = (asset: Asset): RiskLevel => {
  const schedules = getAssetSchedules(asset.id);
  
  const overdue = schedules.filter(s => s.status === "overdue");
  const missed = schedules.filter(s => s.status === "missed");
  
  if (missed.length > 0) return "critical";
  if (overdue.length > 0) return "high";
  
  const dueSoon = schedules.filter(s => 
    s.status === "upcoming" && 
    differenceInDays(s.dueDate, new Date()) <= 7
  );
  
  if (dueSoon.length > 0) return "medium";
  
  return "low";
};