[V0_FILE]typescriptreact:file="lib/hazardData.ts" isMerged="true" export const hazardData = [ // Natural Hazards { id: 1, name: "Earthquake", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 2, name: "Tornado", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 3, name: "Hurricane", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 4, name: "Flood", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 5, name: "Wildfire", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, // Technological Hazards { id: 20, name: "Power Outage", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 21, name: "IT System Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 22, name: "Communications Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, // Human-Related Hazards { id: 35, name: "Mass Casualty Incident", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 36, name: "Bomb Threat", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, ] [V0_FILE]typescriptreact:file="lib/calculateRisk.ts" isMerged="true" type HazardData = { id: number name: string probability: number alerts: number activations: number humanImpact: number propertyImpact: number businessImpact: number preparedness: number internalResponse: number externalResponse: number } export function calculateRiskScores(hazards: HazardData[]) { const hazardsWithScores = hazards.map((hazard) => { // Skip calculation if probability is 0 (N/A) if (hazard.probability === 0) { return { ...hazard, score: 0 } } // Calculate likelihood score (probability + alerts + activations) const likelihoodScore = hazard.probability + Math.min(hazard.alerts, 3) + Math.min(hazard.activations, 3) // Calculate impact score (human + property + business) const impactScore = hazard.humanImpact + hazard.propertyImpact + hazard.businessImpact // Calculate response score (preparedness + internal + external) // Note: For response, higher values are better, so we invert the scale (3 - value) const responseScore = 3 - hazard.preparedness + (3 - hazard.internalResponse) + (3 - hazard.externalResponse) // Calculate total risk score // Formula: (Likelihood * Impact) + Response const score = likelihoodScore * impactScore + responseScore return { ...hazard, score: Math.max(0, score) } }) // Sort hazards by score (descending) const sortedHazards = [...hazardsWithScores].sort((a, b) => b.score - a.score) // Get top 10 risks for chart const topRisks = sortedHazards .filter((h) => h.score > 0) .slice(0, 10) .map((h) => ({ name: h.name, score: h.score })) // Calculate overall preparedness level const avgPreparedness = calculateAveragePreparedness(hazards) let overallPreparedness = "Unknown" if (avgPreparedness >= 2.5) { overallPreparedness = "Good - The organization is well-prepared for most hazards." } else if (avgPreparedness >= 1.5) { overallPreparedness = "Fair - The organization has moderate preparedness for hazards." } else if (avgPreparedness > 0) { overallPreparedness = "Poor - The organization needs significant improvement in preparedness." } return { hazardsWithScores: sortedHazards, topRisks, overallPreparedness, } } function calculateAveragePreparedness(hazards: HazardData[]) { const relevantHazards = hazards.filter((h) => h.probability > 0) if (relevantHazards.length === 0) { return 0 } const totalPreparedness = relevantHazards.reduce((sum, hazard) => { return sum + hazard.preparedness + hazard.internalResponse + hazard.externalResponse }, 0) return totalPreparedness / (relevantHazards.length * 3) } [V0_FILE]typescriptreact:file="components/hazard-table.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { cn } from "@/lib/utils" type HazardData = { id: number name: string probability: number alerts: number activations: number humanImpact: number propertyImpact: number businessImpact: number preparedness: number internalResponse: number externalResponse: number } type HazardTableProps = { data: HazardData[] setData: React.Dispatch> } const probabilityLabels = ["N/A", "Low", "Moderate", "High"] const impactLabels = ["N/A", "Low", "Moderate", "High"] const responseLabels = ["N/A", "Poor", "Fair", "Good"] export function HazardTable({ data, setData }: HazardTableProps) { const [expandedSection, setExpandedSection] = useState("natural") const updateHazardValue = (id: number, field: keyof HazardData, value: number) => { setData(data.map((hazard) => (hazard.id === id ? { ...hazard, [field]: value } : hazard))) } const handleKeyDown = ( e: React.KeyboardEvent, id: number, field: keyof HazardData, currentValue: number, maxValue = 3, ) => { if (e.key === " " || e.code === "Space") { e.preventDefault() const newValue = (currentValue + 1) % (maxValue + 1) updateHazardValue(id, field, newValue) } else if ((e.key === "Backspace" || e.code === "Backspace") && (field === "alerts" || field === "activations")) { e.preventDefault() const newValue = Math.max(0, currentValue - 1) updateHazardValue(id, field, newValue) } } const renderValueCell = ( id: number, field: keyof HazardData, value: number, labels: string[] = [], bgColorClass = "", ) => { return ( handleKeyDown(e, id, field, value)} onClick={() => { const newValue = (value + 1) % labels.length updateHazardValue(id, field, newValue) }} > {labels.length > 0 ? labels[value] : value} ) } // Group hazards by category const naturalHazards = data.filter((h) => h.id < 20) const technologicalHazards = data.filter((h) => h.id >= 20 && h.id < 35) const humanHazards = data.filter((h) => h.id >= 35) const renderHazardSection = (title: string, hazards: HazardData[], sectionKey: string) => { const isExpanded = expandedSection === sectionKey return (

setExpandedSection(isExpanded ? null : sectionKey)} > {isExpanded ? "▼" : "►"} {title}

{isExpanded && (

{hazards.map((hazard) => ( {renderValueCell(hazard.id, "probability", hazard.probability, probabilityLabels, "bg-blue-50")} {renderValueCell(hazard.id, "alerts", hazard.alerts, [], "bg-blue-50")} {renderValueCell(hazard.id, "activations", hazard.activations, [], "bg-blue-50")} {renderValueCell(hazard.id, "humanImpact", hazard.humanImpact, impactLabels, "bg-orange-50")} {renderValueCell(hazard.id, "propertyImpact", hazard.propertyImpact, impactLabels, "bg-orange-50")} {renderValueCell(hazard.id, "businessImpact", hazard.businessImpact, impactLabels, "bg-orange-50")} {renderValueCell(hazard.id, "preparedness", hazard.preparedness, responseLabels, "bg-green-50")} {renderValueCell( hazard.id, "internalResponse", hazard.internalResponse, responseLabels, "bg-green-50", )} {renderValueCell( hazard.id, "externalResponse", hazard.externalResponse, responseLabels, "bg-green-50", )} ))}

Hazard	Likelihood	Impact	Response
	Probability	Alerts	Activations	Human	Property	Business	Preparedness	Internal	External
{hazard.name}

)}

) } return (

Press Space to cycle through values. For Alerts and Activations, use Backspace to decrease.

{renderHazardSection("Natural Hazards", naturalHazards, "natural")} {renderHazardSection("Technological Hazards", technologicalHazards, "technological")} {renderHazardSection("Human-Related Hazards", humanHazards, "human")}

) } [V0_FILE]typescriptreact:file="lib/hazard-data.ts" isEdit="true" isMerged="true" export const hazardData = [ // Natural Hazards { id: 1, name: "Earthquake", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 2, name: "Tornado", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 3, name: "Hurricane", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 4, name: "Flood", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 5, name: "Wildfire", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 6, name: "Landslide", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 7, name: "Extreme Heat", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 8, name: "Extreme Cold", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 9, name: "Snowstorm", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 10, name: "Ice Storm", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 11, name: "Drought", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 12, name: "Epidemic", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 13, name: "Pandemic", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 14, name: "Coastal Erosion", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 15, name: "Tsunami", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, // Technological Hazards { id: 20, name: "Power Outage", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 21, name: "IT System Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 22, name: "Communications Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 23, name: "Water System Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 24, name: "HVAC Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 25, name: "Fire Alarm Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 26, name: "Medical Gas Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 27, name: "Medical Vacuum Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 28, name: "Generator Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 29, name: "Transportation Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 30, name: "Fuel Shortage", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 31, name: "Natural Gas Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 32, name: "Sewer Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 33, name: "Steam Failure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 34, name: "Fire", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, // Human-Related Hazards { id: 35, name: "Mass Casualty Incident", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 36, name: "Bomb Threat", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 37, name: "Chemical Spill", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 38, name: "Civil Disturbance", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 39, name: "Labor Action", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 40, name: "Active Shooter", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 41, name: "Hostage Situation", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 42, name: "VIP Situation", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 43, name: "Infant/Child Abduction", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 44, name: "Supply Chain Shortage", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 45, name: "Medication Shortage", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 46, name: "Radiologic Exposure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 47, name: "Biological Exposure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 48, name: "Chemical Exposure", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, { id: 49, name: "Terrorism", probability: 0, alerts: 0, activations: 0, humanImpact: 0, propertyImpact: 0, businessImpact: 0, preparedness: 0, internalResponse: 0, externalResponse: 0, }, ] [V0_FILE]typescriptreact:file="tailwind.config.ts" isEdit="true" isMerged="true" import type { Config } from "tailwindcss" const config = { darkMode: ["class"], content: [ "./pages/**/*.{ts,tsx}", "./components/**/*.{ts,tsx}", "./app/**/*.{ts,tsx}", "./src/**/*.{ts,tsx}", "*.{js,ts,jsx,tsx,mdx}", ], prefix: "", theme: { container: { center: true, padding: "2rem", screens: { "2xl": "1400px", }, }, extend: { colors: { border: "hsl(var(--border))", input: "hsl(var(--input))", ring: "hsl(var(--ring))", background: "hsl(var(--background))", foreground: "hsl(var(--foreground))", primary: { DEFAULT: "hsl(var(--primary))", foreground: "hsl(var(--primary-foreground))", }, secondary: { DEFAULT: "hsl(var(--secondary))", foreground: "hsl(var(--secondary-foreground))", }, destructive: { DEFAULT: "hsl(var(--destructive))", foreground: "hsl(var(--destructive-foreground))", }, muted: { DEFAULT: "hsl(var(--muted))", foreground: "hsl(var(--muted-foreground))", }, accent: { DEFAULT: "hsl(var(--accent))", foreground: "hsl(var(--accent-foreground))", }, popover: { DEFAULT: "hsl(var(--popover))", foreground: "hsl(var(--popover-foreground))", }, card: { DEFAULT: "hsl(var(--card))", foreground: "hsl(var(--card-foreground))", }, }, borderRadius: { lg: "var(--radius)", md: "calc(var(--radius) - 2px)", sm: "calc(var(--radius) - 4px)", }, keyframes: { "accordion-down": { from: { height: "0" }, to: { height: "var(--radix-accordion-content-height)" }, }, "accordion-up": { from: { height: "var(--radix-accordion-content-height)" }, to: { height: "0" }, }, }, animation: { "accordion-down": "accordion-down 0.2s ease-out", "accordion-up": "accordion-up 0.2s ease-out", }, }, }, plugins: [require("tailwindcss-animate")], } satisfies Config export default config [V0_FILE]css:file="app/globals.css" isEdit="true" isMerged="true" @tailwind base; @tailwind components; @tailwind utilities; @layer base { :root { --background: 0 0% 100%; --foreground: 222.2 84% 4.9%; --card: 0 0% 100%; --card-foreground: 222.2 84% 4.9%; --popover: 0 0% 100%; --popover-foreground: 222.2 84% 4.9%; --primary: 221.2 83.2% 53.3%; --primary-foreground: 210 40% 98%; --secondary: 210 40% 96.1%; --secondary-foreground: 222.2 47.4% 11.2%; --muted: 210 40% 96.1%; --muted-foreground: 215.4 16.3% 46.9%; --accent: 210 40% 96.1%; --accent-foreground: 222.2 47.4% 11.2%; --destructive: 0 84.2% 60.2%; --destructive-foreground: 210 40% 98%; --border: 214.3 31.8% 91.4%; --input: 214.3 31.8% 91.4%; --ring: 221.2 83.2% 53.3%; --radius: 0.5rem; --chart-1: 221.2 83.2% 53.3%; --chart-2: 142.1 76.2% 36.3%; --chart-3: 346.8 77.2% 49.8%; --chart-4: 43.3 96.4% 56.3%; --chart-5: 262.1 83.3% 57.8%; --chart-6: 24.6 95% 53.1%; } .dark { --background: 222.2 84% 4.9%; --foreground: 210 40% 98%; --card: 222.2 84% 4.9%; --card-foreground: 210 40% 98%; --popover: 222.2 84% 4.9%; --popover-foreground: 210 40% 98%; --primary: 217.2 91.2% 59.8%; --primary-foreground: 222.2 47.4% 11.2%; --secondary: 217.2 32.6% 17.5%; --secondary-foreground: 210 40% 98%; --muted: 217.2 32.6% 17.5%; --muted-foreground: 215 20.2% 65.1%; --accent: 217.2 32.6% 17.5%; --accent-foreground: 210 40% 98%; --destructive: 0 62.8% 30.6%; --destructive-foreground: 210 40% 98%; --border: 217.2 32.6% 17.5%; --input: 217.2 32.6% 17.5%; --ring: 224.3 76.3% 48%; } } @layer base { * { @apply border-border; } body { @apply bg-background text-foreground; } } [V0_FILE]typescriptreact:file="lib/calculate-risk.ts" isEdit="true" isMerged="true" type HazardData = { id: number name: string probability: number alerts: number activations: number humanImpact: number propertyImpact: number businessImpact: number preparedness: number internalResponse: number externalResponse: number } export function calculateRiskScores(hazards: HazardData[]) { const hazardsWithScores = hazards.map((hazard) => { // Ensure all values are valid numbers const probability = isNaN(hazard.probability) ? 0 : hazard.probability const alerts = isNaN(hazard.alerts) ? 0 : hazard.alerts const activations = isNaN(hazard.activations) ? 0 : hazard.activations const humanImpact = isNaN(hazard.humanImpact) ? 0 : hazard.humanImpact const propertyImpact = isNaN(hazard.propertyImpact) ? 0 : hazard.propertyImpact const businessImpact = isNaN(hazard.businessImpact) ? 0 : hazard.businessImpact const preparedness = isNaN(hazard.preparedness) ? 0 : hazard.preparedness const internalResponse = isNaN(hazard.internalResponse) ? 0 : hazard.internalResponse const externalResponse = isNaN(hazard.externalResponse) ? 0 : hazard.externalResponse // Skip calculation if probability is 0 (N/A) if (probability === 0) { return { ...hazard, score: 0 } } // Calculate likelihood score (probability + alerts + activations) const likelihoodScore = probability + Math.min(alerts, 3) + Math.min(activations, 3) // Calculate impact score (human + property + business) const impactScore = humanImpact + propertyImpact + businessImpact // Calculate response score (preparedness + internal + external) // Note: For response, higher values are better, so we invert the scale (3 - value) const responseScore = 3 - preparedness + (3 - internalResponse) + (3 - externalResponse) // Calculate total risk score // Formula: (Likelihood * Impact) + Response const score = likelihoodScore * impactScore + responseScore // Ensure score is a valid number const safeScore = isNaN(score) ? 0 : score return { ...hazard, score: safeScore } }) // Sort hazards by score (descending) const sortedHazards = [...hazardsWithScores].sort((a, b) => { const scoreA = isNaN(a.score) ? 0 : a.score const scoreB = isNaN(b.score) ? 0 : b.score return scoreB - scoreA }) // Get top 10 risks for chart const topRisks = sortedHazards .filter((h) => h.score > 0) .slice(0, 10) .map((h) => ({ name: h.name, score: h.score })) // Calculate overall preparedness level const avgPreparedness = calculateAveragePreparedness(hazards) let overallPreparedness = "Unknown" if (avgPreparedness >= 2.5) { overallPreparedness = "Good - The organization is well-prepared for most hazards." } else if (avgPreparedness >= 1.5) { overallPreparedness = "Fair - The organization has moderate preparedness for hazards." } else if (avgPreparedness > 0) { overallPreparedness = "Poor - The organization needs significant improvement in preparedness." } return { hazardsWithScores: sortedHazards, topRisks, overallPreparedness, } } function calculateAveragePreparedness(hazards: HazardData[]) { const relevantHazards = hazards.filter((h) => { const probability = isNaN(h.probability) ? 0 : h.probability return probability > 0 }) if (relevantHazards.length === 0) { return 0 } const totalPreparedness = relevantHazards.reduce((sum, hazard) => { const preparedness = isNaN(hazard.preparedness) ? 0 : hazard.preparedness const internalResponse = isNaN(hazard.internalResponse) ? 0 : hazard.internalResponse const externalResponse = isNaN(hazard.externalResponse) ? 0 : hazard.externalResponse return sum + preparedness + internalResponse + externalResponse }, 0) return totalPreparedness / (relevantHazards.length * 3) } [V0_FILE]json:file="package.json" isFixed="true" isEdit="true" isQuickEdit="true" isMerged="true" { "name": "hva-dashboard", "version": "0.1.0", "private": true, "scripts": { "dev": "next dev", "build": "next build", "start": "next start", "lint": "next lint" }, "dependencies": { "@supabase/supabase-js": "^2.38.0", "next": "14.0.0", "react": "^18", "react-dom": "^18", "recharts": "^2.8.0", "lucide-react": "^0.292.0", "xlsx": "^0.18.5", "jspdf": "^2.5.1", "jspdf-autotable": "^3.5.28" }, "devDependencies": { "@types/node": "^20", "@types/react": "^18", "@types/react-dom": "^18", "autoprefixer": "^10", "eslint": "^8", "eslint-config-next": "14.0.0", "postcss": "^8", "tailwindcss": "^3", "typescript": "^5" } } [V0_FILE]typescriptreact:file="lib/excel-generator.ts" isEdit="true" isMerged="true" import * as XLSX from "xlsx" export function generateExcel(assessmentData: any[], results: any) { // Create workbook const wb = XLSX.utils.book_new() // Prepare assessment data with proper headers const assessmentSheetData = [ // Header row [ "ID", "Hazard Name", "Probability", "Number of Alerts", "Number of Activations", "Human Impact", "Property Impact", "Business Impact", "Preparedness", "Internal Response", "External Response", "Risk Score", ], // Data rows ...assessmentData.map((item) => [ item.id, item.name, getProbabilityLabel(item.probability), item.alerts, item.activations, getImpactLabel(item.humanImpact), getImpactLabel(item.propertyImpact), getImpactLabel(item.businessImpact), getResponseLabel(item.preparedness), getResponseLabel(item.internalResponse), getResponseLabel(item.externalResponse), item.score || 0, ]), ] // Create worksheet from array of arrays const assessmentWS = XLSX.utils.aoa_to_sheet(assessmentSheetData) // Set column widths const colWidths = [ { wch: 5 }, // ID { wch: 25 }, // Hazard Name { wch: 12 }, // Probability { wch: 15 }, // Alerts { wch: 18 }, // Activations { wch: 15 }, // Human Impact { wch: 16 }, // Property Impact { wch: 16 }, // Business Impact { wch: 15 }, // Preparedness { wch: 17 }, // Internal Response { wch: 17 }, // External Response { wch: 12 }, // Risk Score ] assessmentWS["!cols"] = colWidths // Style the header row const headerRange = XLSX.utils.decode_range(assessmentWS["!ref"] || "A1:L1") for (let col = headerRange.s.c; col <= headerRange.e.c; col++) { const cellAddress = XLSX.utils.encode_cell({ r: 0, c: col }) if (!assessmentWS[cellAddress]) continue // Set header styling assessmentWS[cellAddress].s = { font: { bold: true, color: { rgb: "FFFFFF" }, }, fill: { fgColor: { rgb: "3B82F6" }, // Blue background }, alignment: { horizontal: "center", vertical: "center", }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } // Style data rows with alternating colors and borders for (let row = 1; row <= assessmentData.length; row++) { for (let col = 0; col < 12; col++) { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (!assessmentWS[cellAddress]) continue assessmentWS[cellAddress].s = { fill: { fgColor: { rgb: row % 2 === 0 ? "F8FAFC" : "FFFFFF" }, // Alternating row colors }, alignment: { horizontal: col === 1 ? "left" : "center", // Left align hazard names, center others vertical: "center", }, border: { top: { style: "thin", color: { rgb: "E5E7EB" } }, bottom: { style: "thin", color: { rgb: "E5E7EB" } }, left: { style: "thin", color: { rgb: "E5E7EB" } }, right: { style: "thin", color: { rgb: "E5E7EB" } }, }, } // Bold and highlight high-risk scores if (col === 11 && assessmentWS[cellAddress].v >= 25) { assessmentWS[cellAddress].s.font = { bold: true, color: { rgb: "DC2626" } } assessmentWS[cellAddress].s.fill = { fgColor: { rgb: "FEE2E2" } } } } } // Freeze the top row assessmentWS["!freeze"] = { xSplit: 0, ySplit: 1 } // Add assessment data worksheet to workbook XLSX.utils.book_append_sheet(wb, assessmentWS, "HVA Assessment Data") // Create summary worksheet if results exist if (results && results.topRisks && results.topRisks.length > 0) { const summaryData = [ ["TIPNOW HVA Assessment Summary"], [""], ["Generated Date:", new Date().toLocaleDateString()], [""], ["Top Risk Hazards:"], ["Rank", "Hazard Name", "Risk Score"], ...results.topRisks.slice(0, 10).map((risk: any, index: number) => [index + 1, risk.name, risk.score]), [""], ["Assessment Statistics:"], ["Total Hazards Assessed:", results.hazardsWithScores.filter((h: any) => h.probability > 0).length], [ "Average Risk Score:", ( results.hazardsWithScores.reduce((sum: number, h: any) => sum + (h.score || 0), 0) / Math.max(results.hazardsWithScores.filter((h: any) => h.probability > 0).length, 1) ).toFixed(1), ], ["High-Risk Hazards (≥25):", results.hazardsWithScores.filter((h: any) => h.score >= 25).length], ] const summaryWS = XLSX.utils.aoa_to_sheet(summaryData) // Set column widths for summary summaryWS["!cols"] = [{ wch: 25 }, { wch: 30 }, { wch: 15 }] // Style the summary sheet // Title styling if (summaryWS["A1"]) { summaryWS["A1"].s = { font: { bold: true, sz: 16, color: { rgb: "3B82F6" } }, alignment: { horizontal: "center" }, } } // Header styling for top risks table const topRisksHeaderRow = 6 for (let col = 0; col < 3; col++) { const cellAddress = XLSX.utils.encode_cell({ r: topRisksHeaderRow - 1, c: col }) if (summaryWS[cellAddress]) { summaryWS[cellAddress].s = { font: { bold: true, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "3B82F6" } }, alignment: { horizontal: "center" }, } } } XLSX.utils.book_append_sheet(wb, summaryWS, "Summary") } // Generate Excel file const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" }) // Create Blob and return const blob = new Blob([excelBuffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }) return blob } function getProbabilityLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getImpactLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getResponseLabel(value: number): string { const labels = ["N/A", "Poor", "Fair", "Good"] return labels[value] || "N/A" } [V0_FILE]sql:file="scripts/create-table-function.sql" isEdit="true" isMerged="true" -- Create a function to create the table if it doesn't exist CREATE OR REPLACE FUNCTION create_hva_table_if_not_exists() RETURNS void LANGUAGE plpgsql SECURITY DEFINER AS $$ BEGIN -- Create the table if it doesn't exist CREATE TABLE IF NOT EXISTS public.hva_assessments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL, assessment_name TEXT NOT NULL, assessment_data JSONB NOT NULL, results_data JSONB NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Enable RLS if not already enabled ALTER TABLE public.hva_assessments ENABLE ROW LEVEL SECURITY; -- Drop existing policies if they exist and recreate them DROP POLICY IF EXISTS "Users can manage their own assessments" ON public.hva_assessments; CREATE POLICY "Users can manage their own assessments" ON public.hva_assessments FOR ALL USING (auth.uid() = user_id); -- Create indexes if they don't exist CREATE INDEX IF NOT EXISTS idx_hva_assessments_user_id ON public.hva_assessments(user_id); CREATE INDEX IF NOT EXISTS idx_hva_assessments_created_at ON public.hva_assessments(created_at DESC); END; $$; [V0_FILE]sql:file="scripts/create-hva-assessments-table.sql" isMerged="true" -- Create the hva_assessments table for individual hazard records CREATE TABLE IF NOT EXISTS public.hva_assessments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, user_id UUID NOT NULL, hazard_name TEXT NOT NULL, score INTEGER NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Enable Row Level Security ALTER TABLE public.hva_assessments ENABLE ROW LEVEL SECURITY; -- Create policy for users to only see their own assessments DROP POLICY IF EXISTS "Users can only see their own assessments" ON public.hva_assessments; CREATE POLICY "Users can only see their own assessments" ON public.hva_assessments FOR ALL USING (auth.uid()::text = user_id::text); -- Create policy for users to insert their own assessments DROP POLICY IF EXISTS "Users can insert their own assessments" ON public.hva_assessments; CREATE POLICY "Users can insert their own assessments" ON public.hva_assessments FOR INSERT WITH CHECK (auth.uid()::text = user_id::text); -- Create an index for better performance CREATE INDEX IF NOT EXISTS idx_hva_assessments_user_id ON public.hva_assessments(user_id); CREATE INDEX IF NOT EXISTS idx_hva_assessments_created_at ON public.hva_assessments(created_at DESC); [V0_FILE]typescriptreact:file="components/Navbar.tsx" isMerged="true" "use client" import Link from "next/link" import { usePathname } from "next/navigation" import { Button } from "@/components/ui/button" import { useAuth } from "@/contexts/AuthContext" import { FileText, History, Home, LogOut, User } from "lucide-react" import { cn } from "@/lib/utils" export function Navbar() { const pathname = usePathname() const { user, signOut } = useAuth() const handleSignOut = async () => { await signOut() } const navItems = [ { href: "/", label: "Home", icon: Home }, { href: "/dashboard", label: "Dashboard", icon: FileText }, { href: "/history", label: "History", icon: History }, ] return (

TIPNOW HVA

{navItems.map((item) => ( {item.label} ))} {user && (

{user.email}

)}

) } [V0_FILE]typescriptreact:file="components/AuthGuard.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { useEffect } from "react" import { useRouter } from "next/navigation" import { useAuth } from "@/contexts/AuthContext" import { Loader2 } from "lucide-react" interface AuthGuardProps { children: React.ReactNode } export function AuthGuard({ children }: AuthGuardProps) { const { user, loading } = useAuth() const router = useRouter() useEffect(() => { if (!loading && !user) { router.push("/login") } }, [user, loading, router]) if (loading) { return (

) } if (!user) { return null // Will redirect } return <>{children} } [V0_FILE]typescriptreact:file="lib/supabaseClient.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { createClient } from "@supabase/supabase-js" const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL! const supabaseAnonKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY! export const supabase = createClient(supabaseUrl, supabaseAnonKey) export type Database = { public: { Tables: { hva_assessments: { Row: { id: string user_id: string assessment_name: string assessment_data: any results_data: any hazard_name: string score: number created_at: string updated_at: string } Insert: { id?: string user_id: string assessment_name: string assessment_data: any results_data: any hazard_name: string score: number created_at?: string updated_at?: string } Update: { id?: string user_id?: string assessment_name?: string assessment_data?: any results_data?: any hazard_name?: string score?: number created_at?: string updated_at?: string } } } } } [V0_FILE]typescriptreact:file="scripts/setup-database.sql" isEdit="true" isQuickEdit="true" isMerged="true" -- Create the hva_assessments table CREATE TABLE IF NOT EXISTS public.hva_assessments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL, assessment_name TEXT NOT NULL, assessment_data JSONB NOT NULL, results_data JSONB NOT NULL, hazard_name TEXT NOT NULL, score INTEGER NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Enable Row Level Security ALTER TABLE public.hva_assessments ENABLE ROW LEVEL SECURITY; -- Create policy for users to only see their own assessments DROP POLICY IF EXISTS "Users can only see their own assessments" ON public.hva_assessments; CREATE POLICY "Users can only see their own assessments" ON public.hva_assessments FOR ALL USING (auth.uid() = user_id); -- Create policy for users to insert their own assessments DROP POLICY IF EXISTS "Users can insert their own assessments" ON public.hva_assessments; CREATE POLICY "Users can insert their own assessments" ON public.hva_assessments FOR INSERT WITH CHECK (auth.uid() = user_id); -- Create policy for users to update their own assessments DROP POLICY IF EXISTS "Users can update their own assessments" ON public.hva_assessments; CREATE POLICY "Users can update their own assessments" ON public.hva_assessments FOR UPDATE USING (auth.uid() = user_id); -- Create policy for users to delete their own assessments DROP POLICY IF EXISTS "Users can delete their own assessments" ON public.hva_assessments; CREATE POLICY "Users can delete their own assessments" ON public.hva_assessments FOR DELETE USING (auth.uid() = user_id); -- Create indexes for better performance CREATE INDEX IF NOT EXISTS idx_hva_assessments_user_id ON public.hva_assessments(user_id); CREATE INDEX IF NOT EXISTS idx_hva_assessments_created_at ON public.hva_assessments(created_at DESC); [V0_FILE]typescriptreact:file="app/dashboard/history/page.tsx" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import { useEffect, useState } from "react" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" import { Button } from "@/components/ui/button" import { Alert, AlertDescription } from "@/components/ui/alert" import { Calendar, FileText, Download, Database, RefreshCw } from "lucide-react" import { supabase } from "@/lib/supabase" import { useAuth } from "@/contexts/AuthContext" import { generateExcel } from "@/lib/excel-generator" import { generatePDF } from "@/lib/pdf-generator" import { checkTableExists } from "@/lib/database-utils" type Assessment = { id: string assessment_name: string created_at: string assessment_data: any results_data: any } export default function HistoryPage() { const [assessments, setAssessments] = useState([]) const [loading, setLoading] = useState(true) const [tableExists, setTableExists] = useState(null) const [isGenerating, setIsGenerating] = useState(null) const [isCheckingTable, setIsCheckingTable] = useState(false) const { user } = useAuth() useEffect(() => { if (user) { checkAndFetchAssessments() } }, [user]) const checkAndFetchAssessments = async () => { if (!user) return setLoading(true) // First check if table exists const exists = await checkTableExists() setTableExists(exists) if (exists) { await fetchAssessments() } else { setLoading(false) } } const fetchAssessments = async () => { if (!user) return try { const { supabase } = require("@/lib/supabase") const { data, error } = await supabase .from("hva_assessments") .select("*") .eq("user_id", user.id) // Filter by authenticated user's ID .order("created_at", { ascending: false }) if (error) { console.error("Error fetching assessments:", error) if (error.message.includes("does not exist")) { setTableExists(false) } } else { // Group assessments by date and get top 3 hazards per assessment const groupedAssessments = data?.reduce((acc: any, assessment: any) => { const dateKey = new Date(assessment.created_at).toDateString() if (!acc[dateKey]) { acc[dateKey] = { date: assessment.created_at, assessment_name: assessment.assessment_name, hazards: [], } } acc[dateKey].hazards.push({ name: assessment.hazard_name, score: assessment.score, }) return acc }, {}) // Convert to array and sort hazards by score, take top 3 const processedAssessments = Object.values(groupedAssessments || {}).map((group: any) => ({ ...group, hazards: group.hazards.sort((a: any, b: any) => b.score - a.score).slice(0, 3), })) setAssessments(processedAssessments || []) setTableExists(true) } } catch (error) { console.error("Error:", error) setTableExists(false) } finally { setLoading(false) } } const tryCreateTable = async () => { setIsCheckingTable(true) try { const { supabase } = require("@/lib/supabase") // Try to call the RPC function to create the table const { error } = await supabase.rpc("create_hva_table_if_not_exists") if (!error) { // Table created successfully, now fetch assessments setTableExists(true) await fetchAssessments() } else { console.error("Could not create table:", error) } } catch (error) { console.error("Error creating table:", error) } finally { setIsCheckingTable(false) } } const deleteAssessment = async (id: string) => { if (!confirm("Are you sure you want to delete this assessment?")) return try { const { error } = await supabase.from("hva_assessments").delete().eq("id", id) if (error) { console.error("Error deleting assessment:", error) alert("Failed to delete assessment") } else { setAssessments(assessments.filter((a) => a.id !== id)) } } catch (error) { console.error("Error:", error) alert("Failed to delete assessment") } } const downloadExcel = async (assessment: Assessment) => { setIsGenerating(assessment.id) try { const blob = generateExcel(assessment.results_data.hazardsWithScores, assessment.results_data) const url = window.URL.createObjectURL(blob) const link = document.createElement("a") link.href = url link.setAttribute( "download", `${assessment.assessment_name}_${new Date(assessment.created_at).toISOString().split("T")[0]}.xlsx`, ) document.body.appendChild(link) link.click() link.parentNode?.removeChild(link) window.URL.revokeObjectURL(url) } catch (error) { console.error("Error generating Excel:", error) alert("Failed to generate Excel file") } finally { setIsGenerating(null) } } const downloadPDF = async (assessment: Assessment) => { setIsGenerating(assessment.id) try { const blob = await generatePDF(assessment.results_data.hazardsWithScores, assessment.results_data) const url = window.URL.createObjectURL(blob) const link = document.createElement("a") link.href = url link.setAttribute( "download", `${assessment.assessment_name}_${new Date(assessment.created_at).toISOString().split("T")[0]}.pdf`, ) document.body.appendChild(link) link.click() link.parentNode?.removeChild(link) window.URL.revokeObjectURL(url) } catch (error) { console.error("Error generating PDF:", error) alert("Failed to generate PDF file") } finally { setIsGenerating(null) } } if (loading) { return (

Assessment History

) } return (

Assessment History

View and manage your previous HVA assessments

{/* Database Setup Required */} {tableExists === false && (

Database Setup Required

The assessment history feature requires a database table. You have two options:

Option 1: Automatic Setup (Try First)

Option 2: Manual Setup

If auto-setup doesn't work, run this in your Supabase SQL Editor:

{`-- Copy and paste this into Supabase SQL Editor
CREATE TABLE IF NOT EXISTS public.hva_assessments (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL,
  assessment_name TEXT NOT NULL,
  assessment_data JSONB NOT NULL,
  results_data JSONB NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

ALTER TABLE public.hva_assessments ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Users can manage their own assessments" ON public.hva_assessments
  FOR ALL USING (auth.uid() = user_id);`}

{/* Show a preview of what the history will look like */} Assessment History Preview

{[1, 2, 3].map((i) => ( Sample Assessment {i}

{new Date().toLocaleDateString()}

Hazards Assessed: 15

))}

)} {/* Normal Content - Table Exists */} {tableExists === true && ( <> {assessments.length === 0 ? (

No assessments yet

Create your first assessment to see it here.

) : (

{assessments.map((assessment: any, index: number) => ( {assessment.assessment_name}

{new Date(assessment.date).toLocaleDateString("en-US", { year: "numeric", month: "short", day: "numeric", hour: "2-digit", minute: "2-digit", })}

Top Hazards: {assessment.hazards.length}

{assessment.hazards.map((hazard: any, hazardIndex: number) => (

{hazardIndex + 1}. {hazard.name} = 25 ? "destructive" : hazard.score >= 15 ? "default" : "secondary"} className="text-xs" > {hazard.score}

))}

)} )}

) } [V0_FILE]typescriptreact:file="app/page.tsx" isEdit="true" isMerged="true" "use client" import Link from "next/link" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { FileText, Shield, TrendingUp, BarChart3 } from "lucide-react" export default function HomePage() { return (

{/* Hero Section */}

TIPNOW Hazard Vulnerability Assessment

Comprehensive risk analysis and emergency preparedness planning for healthcare facilities and organizations.

{/* Features Grid */}

Risk Assessment Evaluate natural, technological, and human-related hazards with comprehensive scoring methodology. Visual Analytics Interactive charts and visualizations to identify top risks and prioritize response efforts. Export Reports Generate professional PDF reports and Excel spreadsheets for documentation and compliance.

) } [V0_FILE]typescriptreact:file="app/layout.tsx" isEdit="true" isMerged="true" import type React from "react" import type { Metadata } from "next" import { Inter } from "next/font/google" import "./globals.css" import { ThemeProvider } from "@/components/theme-provider" import { AuthProvider } from "@/contexts/AuthContext" const inter = Inter({ subsets: ["latin"] }) export const metadata: Metadata = { title: "TIPNOW HVA Dashboard", description: "Hazard Vulnerability Assessment Dashboard", } export default function RootLayout({ children, }: Readonly<{ children: React.ReactNode }>) { return ( {children} ) } [V0_FILE]typescriptreact:file="components/ProtectedRoute.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { useEffect } from "react" import { useRouter } from "next/navigation" import { useAuth } from "@/contexts/AuthContext" import { Auth } from "@/components/Auth" import { Loader2 } from "lucide-react" export function ProtectedRoute({ children }: { children: React.ReactNode }) { const { user, loading } = useAuth() const router = useRouter() useEffect(() => { if (!loading && !user) { // Don't redirect, just show auth component } }, [user, loading, router]) if (loading) { return (

) } if (!user) { return } return <>{children} } [V0_FILE]typescriptreact:file="app/dashboard/page.tsx" isFixed="true" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import { useEffect } from "react" import { useRouter } from "next/navigation" import { useAuth } from "@/contexts/AuthContext" import { HazardAssessment } from "@/components/hazard-assessment" import { Loader2 } from "lucide-react" export default function DashboardPage() { const { user, loading } = useAuth() const router = useRouter() useEffect(() => { if (!loading && !user) { router.push("/login") } }, [user, loading, router]) if (loading) { return (

) } if (!user) { return null // Will redirect } return (

) } [V0_FILE]typescriptreact:file="app/dashboard/layout.tsx" isEdit="true" isMerged="true" import type React from "react" import { Sidebar } from "@/components/Sidebar" import { ProtectedRoute } from "@/components/ProtectedRoute" export default function DashboardLayout({ children, }: { children: React.ReactNode }) { return (

{children}

) } [V0_FILE]typescriptreact:file="app/history/layout.tsx" isEdit="true" isMerged="true" import type React from "react" import { Sidebar } from "@/components/Sidebar" import { ProtectedRoute } from "@/components/ProtectedRoute" export default function HistoryLayout({ children, }: { children: React.ReactNode }) { return (

{children}

) } [V0_FILE]sql:file="scripts/create-hva-table.sql" isEdit="true" isMerged="true" -- Create the hva_assessments table CREATE TABLE IF NOT EXISTS public.hva_assessments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL, assessment_name TEXT NOT NULL, assessment_data JSONB NOT NULL, results_data JSONB NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Enable Row Level Security ALTER TABLE public.hva_assessments ENABLE ROW LEVEL SECURITY; -- Create policy for users to only see their own assessments DROP POLICY IF EXISTS "Users can only see their own assessments" ON public.hva_assessments; CREATE POLICY "Users can only see their own assessments" ON public.hva_assessments FOR ALL USING (auth.uid() = user_id); -- Create policy for users to insert their own assessments DROP POLICY IF EXISTS "Users can insert their own assessments" ON public.hva_assessments; CREATE POLICY "Users can insert their own assessments" ON public.hva_assessments FOR INSERT WITH CHECK (auth.uid() = user_id); -- Create policy for users to update their own assessments DROP POLICY IF EXISTS "Users can update their own assessments" ON public.hva_assessments; CREATE POLICY "Users can update their own assessments" ON public.hva_assessments FOR UPDATE USING (auth.uid() = user_id); -- Create policy for users to delete their own assessments DROP POLICY IF EXISTS "Users can delete their own assessments" ON public.hva_assessments; CREATE POLICY "Users can delete their own assessments" ON public.hva_assessments FOR DELETE USING (auth.uid() = user_id); -- Create indexes for better performance CREATE INDEX IF NOT EXISTS idx_hva_assessments_user_id ON public.hva_assessments(user_id); CREATE INDEX IF NOT EXISTS idx_hva_assessments_created_at ON public.hva_assessments(created_at DESC); [V0_FILE]plaintext:file=".env.local.example" isEdit="true" isMerged="true" # Supabase Configuration NEXT_PUBLIC_SUPABASE_URL=your_supabase_project_url NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_anon_key # Example: # NEXT_PUBLIC_SUPABASE_URL=https://your-project.supabase.co # NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key-here [V0_FILE]typescriptreact:file="components/Sidebar.tsx" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import Link from "next/link" import { usePathname } from "next/navigation" import { FileText, History, PieChart, Plus, LogOut, User } from "lucide-react" import { cn } from "@/lib/utils" import { useAuth } from "@/contexts/AuthContext" import { Button } from "@/components/ui/button" const navItems = [ { title: "New Assessment", href: "/dashboard", icon: Plus, }, { title: "History", href: "/history", icon: History, }, { title: "Pricing", href: "/pricing", icon: PieChart, }, ] export function Sidebar() { const pathname = usePathname() const { user, signOut } = useAuth() const handleSignOut = async () => { await signOut() } return (

HVA Dashboard

{/* User Info Section */}

{user && (

{user.email}

)}

HVA Dashboard v1.0

) } [V0_FILE]typescriptreact:file="components/sidebar.tsx" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import Link from "next/link" import { usePathname } from "next/navigation" import { FileText, History, PieChart, Plus, LogOut, User } from "lucide-react" import { cn } from "@/lib/utils" import { useAuth } from "@/contexts/AuthContext" import { Button } from "@/components/ui/button" const navItems = [ { title: "New Assessment", href: "/dashboard", icon: Plus, }, { title: "History", href: "/history", icon: History, }, { title: "Pricing", href: "/pricing", icon: PieChart, }, ] export function Sidebar() { const pathname = usePathname() const { user, signOut } = useAuth() const handleSignOut = async () => { await signOut() window.location.href = "/dashboard" } return (

TIPNOW HVA

{/* User Info Section */}

{user && (

{user.email}

)}

TIPNOW HVA Dashboard v1.0

) } [V0_FILE]typescriptreact:file="app/pricing/page.tsx" isMerged="true" "use client" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Badge } from "@/components/ui/badge" import { Check, Star, Zap, Shield, Users, BarChart3 } from "lucide-react" export default function PricingPage() { const plans = [ { name: "Basic", price: "$29", period: "/month", description: "Perfect for small healthcare facilities", features: [ "Up to 5 assessments per month", "Basic PDF reports", "Email support", "Standard hazard database", "Basic analytics", ], icon: Shield, popular: false, buttonText: "Get Started", buttonVariant: "outline" as const, }, { name: "Professional", price: "$79", period: "/month", description: "Ideal for medium-sized organizations", features: [ "Unlimited assessments", "Enhanced PDF reports with charts", "Priority email & phone support", "Custom hazard categories", "Advanced analytics dashboard", "Team collaboration tools", "Historical trend analysis", ], icon: Zap, popular: true, buttonText: "Start Free Trial", buttonVariant: "default" as const, }, { name: "Enterprise", price: "$199", period: "/month", description: "For large healthcare systems", features: [ "Everything in Professional", "Multi-facility management", "Custom branding", "API access", "Dedicated account manager", "On-site training", "Custom integrations", "Compliance reporting", "24/7 phone support", ], icon: Users, popular: false, buttonText: "Contact Sales", buttonVariant: "outline" as const, }, ] return (

Choose Your Plan

Comprehensive hazard vulnerability assessment tools for healthcare facilities of all sizes

{/* Feature highlights */}

Advanced Analytics

HIPAA Compliant

Team Collaboration

{plans.map((plan) => ( {plan.popular && (

Is there a free trial?

Yes! Professional plan includes a 14-day free trial with full access to all features.

Can I change plans anytime?

Absolutely. You can upgrade or downgrade your plan at any time with prorated billing.

Is my data secure?

Yes, we're HIPAA compliant with enterprise-grade security and encryption.

Do you offer training?

Professional plans include online training, Enterprise includes on-site training.

{/* Contact CTA */}

Need a Custom Solution?

Contact our team to discuss enterprise pricing and custom implementations.

) } [V0_FILE]typescriptreact:file="app/pricing/layout.tsx" isMerged="true" import type React from "react" import { Sidebar } from "@/components/Sidebar" import { ProtectedRoute } from "@/components/ProtectedRoute" export default function PricingLayout({ children, }: { children: React.ReactNode }) { return (

{children}

) } [V0_FILE]typescriptreact:file="lib/pdf-generator.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { jsPDF } from "jspdf" import "jspdf-autotable" import type { UserOptions } from "jspdf-autotable" // Extend the jsPDF type to include autoTable declare module "jspdf" { interface jsPDF { autoTable: (options: UserOptions) => jsPDF } } export async function generatePDF(assessmentData: any[], results: any) { const doc = new jsPDF() const pageWidth = doc.internal.pageSize.width const pageHeight = doc.internal.pageSize.height let currentPage = 1 // Color palette const colors = { primary: [59, 130, 246], // Blue secondary: [16, 185, 129], // Green accent: [245, 101, 101], // Red warning: [251, 146, 60], // Orange info: [139, 92, 246], // Purple gray: [107, 114, 128], lightGray: [243, 244, 246], white: [255, 255, 255], dark: [31, 41, 55], } // Helper function to add page numbers const addPageNumber = () => { doc.setFontSize(10) doc.setTextColor(...colors.gray) doc.text(`Page ${currentPage}`, pageWidth - 20, pageHeight - 10) currentPage++ } // Helper function to add section divider const addSectionDivider = (y: number) => { doc.setDrawColor(...colors.primary) doc.setLineWidth(0.5) doc.line(20, y, pageWidth - 20, y) } // Helper function to create gradient effect (simulated with multiple rectangles) const addSimpleRect = (x: number, y: number, width: number, height: number, color: number[]) => { doc.setFillColor(...color) doc.rect(x, y, width, height, "F") } // COVER PAGE // Background gradient effect addSimpleRect(0, 0, pageWidth, pageHeight, colors.primary) // White content area doc.setFillColor(...colors.white) doc.roundedRect(30, 40, pageWidth - 60, pageHeight - 80, 10, 10, "F") // Logo placeholder doc.setFillColor(...colors.primary) doc.circle(pageWidth / 2, 80, 20, "F") doc.setTextColor(...colors.white) doc.setFontSize(16) doc.setFont("helvetica", "bold") doc.text("HVA", pageWidth / 2, 85, { align: "center" }) // Title doc.setFontSize(32) doc.setTextColor(...colors.dark) doc.setFont("helvetica", "bold") doc.text("TIPNOW HVA REPORT", pageWidth / 2, 120, { align: "center" }) // Subtitle doc.setFontSize(18) doc.setTextColor(...colors.gray) doc.setFont("helvetica", "normal") doc.text("Hazard Vulnerability Assessment", pageWidth / 2, 135, { align: "center" }) // Date and time doc.setFontSize(12) doc.setTextColor(...colors.gray) const currentDate = new Date().toLocaleDateString("en-US", { year: "numeric", month: "long", day: "numeric", hour: "2-digit", minute: "2-digit", }) doc.text(`Generated on: ${currentDate}`, pageWidth / 2, 150, { align: "center" }) // Summary statistics box const summaryY = 170 doc.setFillColor(...colors.lightGray) doc.roundedRect(50, summaryY, pageWidth - 100, 60, 5, 5, "F") doc.setDrawColor(...colors.primary) doc.setLineWidth(1) doc.roundedRect(50, summaryY, pageWidth - 100, 60, 5, 5, "S") doc.setFontSize(16) doc.setTextColor(...colors.dark) doc.setFont("helvetica", "bold") doc.text("Assessment Overview", pageWidth / 2, summaryY + 15, { align: "center" }) // Calculate summary statistics const totalHazards = assessmentData.filter((h) => h.probability > 0).length const totalRiskScore = results.hazardsWithScores.reduce((sum: number, h: any) => sum + (h.score || 0), 0) const avgRiskScore = totalHazards > 0 ? (totalRiskScore / totalHazards).toFixed(1) : "0" const highRiskHazards = results.hazardsWithScores.filter((h: any) => h.score >= 25).length const highRiskPercentage = totalHazards > 0 ? ((highRiskHazards / totalHazards) * 100).toFixed(1) : "0" doc.setFontSize(12) doc.setFont("helvetica", "normal") doc.setTextColor(...colors.gray) const statsY = summaryY + 30 doc.text(`Total Hazards Assessed: ${totalHazards}`, 60, statsY) doc.text(`Average Risk Score: ${avgRiskScore}`, 60, statsY + 10) doc.text(`High-Risk Hazards: ${highRiskHazards} (${highRiskPercentage}%)`, 60, statsY + 20) addPageNumber() // PAGE 2: EXECUTIVE SUMMARY & INSIGHTS doc.addPage() // Header doc.setFillColor(...colors.primary) doc.rect(0, 0, pageWidth, 25, "F") doc.setTextColor(...colors.white) doc.setFontSize(18) doc.setFont("helvetica", "bold") doc.text("Executive Summary & AI Insights", 20, 17) let yPos = 40 // AI-Powered Insights Section doc.setFillColor(...colors.info) doc.roundedRect(15, yPos, pageWidth - 30, 8, 2, 2, "F") doc.setTextColor(...colors.white) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("🤖 AI-Powered Risk Analysis", 20, yPos + 6) yPos += 20 doc.setTextColor(...colors.dark) doc.setFontSize(11) doc.setFont("helvetica", "normal") // Generate AI insights based on data const insights = generateAIInsights(results.hazardsWithScores, results.topRisks) doc.text("Based on your assessment data, our AI analysis identifies the following key insights:", 20, yPos) yPos += 15 insights.forEach((insight: string, index: number) => { doc.setFillColor(...colors.lightGray) doc.roundedRect(20, yPos - 3, pageWidth - 40, 12, 2, 2, "F") doc.setTextColor(...colors.dark) doc.text(`${index + 1}. ${insight}`, 25, yPos + 4) yPos += 20 }) // Recommended Actions yPos += 10 doc.setFillColor(...colors.secondary) doc.roundedRect(15, yPos, pageWidth - 30, 8, 2, 2, "F") doc.setTextColor(...colors.white) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("📋 Priority Action Items", 20, yPos + 6) yPos += 20 const actions = generateRecommendedActions(results.topRisks) actions.forEach((action: string, index: number) => { doc.setFillColor(index === 0 ? [254, 226, 226] : index === 1 ? [255, 237, 213] : [220, 252, 231]) doc.roundedRect(20, yPos - 3, pageWidth - 40, 15, 2, 2, "F") doc.setTextColor(...colors.dark) doc.setFont("helvetica", "bold") doc.text(`Priority ${index + 1}:`, 25, yPos + 4) doc.setFont("helvetica", "normal") doc.text(action, 25, yPos + 10) yPos += 22 }) addPageNumber() // PAGE 3: VISUAL ANALYTICS doc.addPage() // Header doc.setFillColor(...colors.accent) doc.rect(0, 0, pageWidth, 25, "F") doc.setTextColor(...colors.white) doc.setFontSize(18) doc.setFont("helvetica", "bold") doc.text("Risk Analytics Dashboard", 20, 17) // Top 10 Risks Bar Chart if (results && results.topRisks && results.topRisks.length > 0) { yPos = 40 doc.setFontSize(14) doc.setTextColor(...colors.dark) doc.setFont("helvetica", "bold") doc.text("Top 10 Risk Hazards", 20, yPos) const chartStartY = yPos + 10 const chartHeight = 80 const chartWidth = pageWidth - 40 const maxScore = Math.max(...results.topRisks.slice(0, 10).map((r: any) => r.score)) // Chart background doc.setFillColor(...colors.lightGray) doc.roundedRect(20, chartStartY, chartWidth, chartHeight, 3, 3, "F") // Draw bars with gradient colors const barColors = [ [239, 68, 68], [245, 101, 101], [251, 146, 60], [252, 176, 64], [250, 204, 21], [163, 230, 53], [34, 197, 94], [20, 184, 166], [59, 130, 246], [147, 51, 234], ] results.topRisks.slice(0, 10).forEach((risk: any, index: number) => { const barHeight = (risk.score / maxScore) * (chartHeight - 20) const barWidth = (chartWidth - 40) / 10 - 2 const xPos = 25 + index * (barWidth + 2) const yBarPos = chartStartY + chartHeight - 10 - barHeight // Simple colored bar instead of gradient const color = barColors[index] || colors.primary doc.setFillColor(...color) doc.rect(xPos, yBarPos, barWidth, barHeight, "F") // Score label on top doc.setFontSize(8) doc.setTextColor(...colors.dark) doc.text(risk.score.toString(), xPos + barWidth / 2, yBarPos - 2, { align: "center" }) // Hazard name doc.text( risk.name.length > 8 ? risk.name.substring(0, 8) + "..." : risk.name, xPos + barWidth / 2, chartStartY + chartHeight + 8, { align: "center" }, ) }) // Risk Distribution Pie Chart yPos = chartStartY + chartHeight + 30 doc.setFontSize(14) doc.setTextColor(...colors.dark) doc.setFont("helvetica", "bold") doc.text("Risk Distribution", 20, yPos) const pieChartY = yPos + 15 const pieRadius = 25 const pieCenterX = 60 const pieCenterY = pieChartY + pieRadius // Calculate risk distribution const lowRisk = results.hazardsWithScores.filter((h: any) => h.score > 0 && h.score < 15).length const mediumRisk = results.hazardsWithScores.filter((h: any) => h.score >= 15 && h.score < 25).length const highRisk = results.hazardsWithScores.filter((h: any) => h.score >= 25).length const total = lowRisk + mediumRisk + highRisk if (total > 0) { const startAngle = 0 const segments = [ { value: lowRisk, color: colors.secondary, label: "Low Risk" }, { value: mediumRisk, color: colors.warning, label: "Medium Risk" }, { value: highRisk, color: colors.accent, label: "High Risk" }, ] segments.forEach((segment, index) => { if (segment.value > 0) { const angle = (segment.value / total) * 360 // Draw pie segment (simplified as rectangles for jsPDF limitations) doc.setFillColor(...segment.color) const segmentHeight = (segment.value / total) * 40 doc.rect(pieCenterX + index * 15, pieCenterY, 12, segmentHeight, "F") // Legend doc.setFillColor(...segment.color) doc.rect(120, pieChartY + index * 15, 8, 8, "F") doc.setTextColor(...colors.dark) doc.setFontSize(10) doc.text( `${segment.label}: ${segment.value} (${((segment.value / total) * 100).toFixed(1)}%)`, 135, pieChartY + index * 15 + 6, ) } }) } } addPageNumber() // PAGE 4: DETAILED DATA TABLE doc.addPage() // Header doc.setFillColor(...colors.secondary) doc.rect(0, 0, pageWidth, 25, "F") doc.setTextColor(...colors.white) doc.setFontSize(18) doc.setFont("helvetica", "bold") doc.text("Detailed Assessment Data", 20, 17) // Prepare data for the comprehensive table const tableData = assessmentData.map((item) => [ item.name, getProbabilityLabel(item.probability), item.alerts.toString(), item.activations.toString(), getImpactLabel(item.humanImpact), getImpactLabel(item.propertyImpact), getImpactLabel(item.businessImpact), getResponseLabel(item.preparedness), getResponseLabel(item.internalResponse), getResponseLabel(item.externalResponse), (item.score || 0).toString(), ]) doc.autoTable({ startY: 35, head: [ [ "Hazard", "Probability", "Alerts", "Activations", "Human Impact", "Property Impact", "Business Impact", "Preparedness", "Internal Response", "External Response", "Risk Score", ], ], body: tableData, theme: "striped", headStyles: { fillColor: colors.secondary, textColor: colors.white, fontStyle: "bold", fontSize: 9, halign: "center", }, bodyStyles: { fontSize: 8, halign: "center", }, columnStyles: { 0: { cellWidth: 25, halign: "left" }, // Hazard name 10: { cellWidth: 15, fontStyle: "bold" }, // Risk Score }, alternateRowStyles: { fillColor: colors.lightGray, }, margin: { left: 10, right: 10 }, didParseCell: (data) => { // Highlight high-risk scores if (data.column.index === 10 && Number.parseInt(data.cell.text[0]) >= 25) { data.cell.styles.fillColor = [254, 226, 226] data.cell.styles.textColor = [185, 28, 28] data.cell.styles.fontStyle = "bold" } }, }) addPageNumber() // PAGE 5: RECOMMENDATIONS & NEXT STEPS doc.addPage() // Header doc.setFillColor(...colors.info) doc.rect(0, 0, pageWidth, 25, "F") doc.setTextColor(...colors.white) doc.setFontSize(18) doc.setFont("helvetica", "bold") doc.text("Recommendations & Next Steps", 20, 17) yPos = 40 // Implementation Timeline doc.setFillColor(...colors.warning) doc.roundedRect(15, yPos, pageWidth - 30, 8, 2, 2, "F") doc.setTextColor(...colors.white) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("📅 Implementation Timeline", 20, yPos + 6) yPos += 20 const timeline = [ { period: "Immediate (0-30 days)", actions: "Address top 3 critical risks, emergency supply check" }, { period: "Short-term (1-3 months)", actions: "Staff training, equipment upgrades, policy updates" }, { period: "Medium-term (3-6 months)", actions: "System improvements, partnership agreements" }, { period: "Long-term (6-12 months)", actions: "Infrastructure upgrades, comprehensive drills" }, ] timeline.forEach((item, index) => { doc.setFillColor(...colors.lightGray) doc.roundedRect(20, yPos - 3, pageWidth - 40, 18, 2, 2, "F") doc.setTextColor(...colors.dark) doc.setFont("helvetica", "bold") doc.text(item.period, 25, yPos + 4) doc.setFont("helvetica", "normal") doc.text(item.actions, 25, yPos + 12) yPos += 25 }) // Contact Information yPos += 20 doc.setFillColor(...colors.primary) doc.roundedRect(15, yPos, pageWidth - 30, 8, 2, 2, "F") doc.setTextColor(...colors.white) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("📞 Support & Resources", 20, yPos + 6) yPos += 20 doc.setTextColor(...colors.dark) doc.setFontSize(11) doc.setFont("helvetica", "normal") doc.text("For additional support and resources:", 20, yPos) doc.text("• Emergency Management Consultation", 25, yPos + 12) doc.text("• Training Program Development", 25, yPos + 20) doc.text("• Technology Implementation Support", 25, yPos + 28) addPageNumber() return doc.output("blob") } // AI Insights Generation function generateAIInsights(hazardsWithScores: any[], topRisks: any[]): string[] { const insights = [] // Analyze risk patterns const highRiskCount = hazardsWithScores.filter((h) => h.score >= 25).length const totalAssessed = hazardsWithScores.filter((h) => h.score > 0).length if (highRiskCount > totalAssessed * 0.3) { insights.push( "Your facility shows elevated risk exposure across multiple hazard categories, indicating need for comprehensive preparedness enhancement.", ) } // Analyze top risk categories const naturalRisks = topRisks.filter( (r: any) => r.name.includes("Earthquake") || r.name.includes("Flood") || r.name.includes("Hurricane"), ) const techRisks = topRisks.filter( (r: any) => r.name.includes("Power") || r.name.includes("IT") || r.name.includes("System"), ) if (naturalRisks.length > 0) { insights.push( "Natural hazards represent significant risks - consider geographic-specific emergency protocols and backup systems.", ) } if (techRisks.length > 0) { insights.push( "Technology-related vulnerabilities detected - infrastructure redundancy and IT disaster recovery plans are critical.", ) } // Default insight if none generated if (insights.length === 0) { insights.push( "Assessment shows manageable risk levels with opportunities for targeted improvements in high-scoring areas.", ) } return insights.slice(0, 3) } // Recommended Actions Generation function generateRecommendedActions(topRisks: any[]): string[] { const actions = [] if (topRisks.length > 0) { actions.push( `Immediate focus on ${topRisks[0].name} mitigation - develop specific response protocols and resource allocation.`, ) } if (topRisks.length > 1) { actions.push(`Enhance preparedness for ${topRisks[1].name} through staff training and equipment procurement.`) } actions.push("Establish quarterly risk assessment reviews and update emergency response plans based on findings.") return actions } function getProbabilityLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getImpactLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getResponseLabel(value: number): string { const labels = ["N/A", "Poor", "Fair", "Good"] return labels[value] || "N/A" } [V0_FILE]typescriptreact:file="lib/pdf-generator-fixed.ts" isMerged="true" import { jsPDF } from "jspdf" import "jspdf-autotable" import type { UserOptions } from "jspdf-autotable" // Extend the jsPDF type to include autoTable declare module "jspdf" { interface jsPDF { autoTable: (options: UserOptions) => jsPDF } } export async function generatePDF(assessmentData: any[], results: any) { try { const doc = new jsPDF() const pageWidth = doc.internal.pageSize.width const pageHeight = doc.internal.pageSize.height let currentPage = 1 // Color palette (RGB values) const colors = { primary: [59, 130, 246], secondary: [16, 185, 129], accent: [245, 101, 101], warning: [251, 146, 60], gray: [107, 114, 128], lightGray: [243, 244, 246], white: [255, 255, 255], dark: [31, 41, 55], } // Helper function to add page numbers const addPageNumber = () => { doc.setFontSize(10) doc.setTextColor(107, 114, 128) doc.text(`Page ${currentPage}`, pageWidth - 20, pageHeight - 10) currentPage++ } // COVER PAGE // Background doc.setFillColor(59, 130, 246) doc.rect(0, 0, pageWidth, pageHeight, "F") // White content area doc.setFillColor(255, 255, 255) doc.rect(30, 40, pageWidth - 60, pageHeight - 80, "F") // Logo circle doc.setFillColor(59, 130, 246) doc.circle(pageWidth / 2, 80, 20, "F") doc.setTextColor(255, 255, 255) doc.setFontSize(16) doc.setFont("helvetica", "bold") doc.text("HVA", pageWidth / 2, 85, { align: "center" }) // Title doc.setFontSize(28) doc.setTextColor(31, 41, 55) doc.setFont("helvetica", "bold") doc.text("TIPNOW HVA REPORT", pageWidth / 2, 120, { align: "center" }) // Subtitle doc.setFontSize(16) doc.setTextColor(107, 114, 128) doc.setFont("helvetica", "normal") doc.text("Hazard Vulnerability Assessment", pageWidth / 2, 135, { align: "center" }) // Date doc.setFontSize(12) const currentDate = new Date().toLocaleDateString("en-US", { year: "numeric", month: "long", day: "numeric", }) doc.text(`Generated on: ${currentDate}`, pageWidth / 2, 150, { align: "center" }) // Summary box doc.setFillColor(243, 244, 246) doc.rect(50, 170, pageWidth - 100, 60, "F") doc.setDrawColor(59, 130, 246) doc.setLineWidth(1) doc.rect(50, 170, pageWidth - 100, 60, "S") doc.setFontSize(14) doc.setTextColor(31, 41, 55) doc.setFont("helvetica", "bold") doc.text("Assessment Summary", pageWidth / 2, 185, { align: "center" }) // Calculate summary statistics const totalHazards = assessmentData.filter((h) => h.probability > 0).length const totalRiskScore = results.hazardsWithScores.reduce((sum: number, h: any) => sum + (h.score || 0), 0) const avgRiskScore = totalHazards > 0 ? (totalRiskScore / totalHazards).toFixed(1) : "0" const highRiskHazards = results.hazardsWithScores.filter((h: any) => h.score >= 25).length doc.setFontSize(11) doc.setFont("helvetica", "normal") doc.setTextColor(107, 114, 128) doc.text(`Total Hazards Assessed: ${totalHazards}`, 60, 200) doc.text(`Average Risk Score: ${avgRiskScore}`, 60, 210) doc.text(`High-Risk Hazards: ${highRiskHazards}`, 60, 220) addPageNumber() // PAGE 2: TOP RISKS CHART doc.addPage() // Header doc.setFillColor(59, 130, 246) doc.rect(0, 0, pageWidth, 25, "F") doc.setTextColor(255, 255, 255) doc.setFontSize(18) doc.setFont("helvetica", "bold") doc.text("Risk Analysis Dashboard", 20, 17) // Chart section if (results && results.topRisks && results.topRisks.length > 0) { let yPos = 40 doc.setFontSize(16) doc.setTextColor(31, 41, 55) doc.setFont("helvetica", "bold") doc.text("Top 10 Risk Hazards", 20, yPos) const chartStartY = yPos + 15 const chartHeight = 100 const chartWidth = pageWidth - 40 const maxScore = Math.max(...results.topRisks.slice(0, 10).map((r: any) => r.score)) // Chart background doc.setFillColor(248, 250, 252) doc.rect(20, chartStartY, chartWidth, chartHeight, "F") doc.setDrawColor(229, 231, 235) doc.setLineWidth(0.5) doc.rect(20, chartStartY, chartWidth, chartHeight, "S") // Draw bars const barColors = [ [239, 68, 68], // Red [245, 101, 101], // Light red [251, 146, 60], // Orange [252, 176, 64], // Light orange [250, 204, 21], // Yellow [163, 230, 53], // Light green [34, 197, 94], // Green [20, 184, 166], // Teal [59, 130, 246], // Blue [147, 51, 234], // Purple ] results.topRisks.slice(0, 10).forEach((risk: any, index: number) => { if (risk.score && maxScore > 0) { const barHeight = (risk.score / maxScore) * (chartHeight - 30) const barWidth = (chartWidth - 40) / 10 - 4 const xPos = 25 + index * (barWidth + 4) const yBarPos = chartStartY + chartHeight - 15 - barHeight // Draw bar const color = barColors[index] || [59, 130, 246] doc.setFillColor(color[0], color[1], color[2]) doc.rect(xPos, yBarPos, barWidth, barHeight, "F") // Score label doc.setFontSize(8) doc.setTextColor(31, 41, 55) doc.text(risk.score.toString(), xPos + barWidth / 2, yBarPos - 3, { align: "center" }) // Hazard name const truncatedName = risk.name.length > 10 ? risk.name.substring(0, 10) + "..." : risk.name doc.text(truncatedName, xPos + barWidth / 2, chartStartY + chartHeight + 8, { align: "center", maxWidth: barWidth, }) } }) // AI Insights section yPos = chartStartY + chartHeight + 30 doc.setFillColor(139, 92, 246) doc.rect(20, yPos, pageWidth - 40, 8, "F") doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("AI-Powered Insights", 25, yPos + 6) yPos += 20 doc.setTextColor(31, 41, 55) doc.setFontSize(11) doc.setFont("helvetica", "normal") const insights = generateAIInsights(results.hazardsWithScores, results.topRisks) insights.forEach((insight: string, index: number) => { doc.setFillColor(243, 244, 246) doc.rect(25, yPos - 2, pageWidth - 50, 12, "F") doc.text(`${index + 1}. ${insight}`, 30, yPos + 4, { maxWidth: pageWidth - 60 }) yPos += 18 }) } addPageNumber() // PAGE 3: DETAILED DATA TABLE doc.addPage() // Header doc.setFillColor(16, 185, 129) doc.rect(0, 0, pageWidth, 25, "F") doc.setTextColor(255, 255, 255) doc.setFontSize(18) doc.setFont("helvetica", "bold") doc.text("Detailed Assessment Data", 20, 17) // Prepare table data const tableData = assessmentData .filter((item) => item.probability > 0) .map((item) => [ item.name, getProbabilityLabel(item.probability), item.alerts.toString(), item.activations.toString(), getImpactLabel(item.humanImpact), getImpactLabel(item.propertyImpact), getImpactLabel(item.businessImpact), getResponseLabel(item.preparedness), getResponseLabel(item.internalResponse), getResponseLabel(item.externalResponse), (item.score || 0).toString(), ]) doc.autoTable({ startY: 35, head: [ [ "Hazard", "Probability", "Alerts", "Activations", "Human Impact", "Property Impact", "Business Impact", "Preparedness", "Internal Response", "External Response", "Risk Score", ], ], body: tableData, theme: "striped", headStyles: { fillColor: [16, 185, 129], textColor: [255, 255, 255], fontStyle: "bold", fontSize: 9, halign: "center", }, bodyStyles: { fontSize: 8, halign: "center", }, columnStyles: { 0: { cellWidth: 25, halign: "left" }, 10: { cellWidth: 15, fontStyle: "bold" }, }, alternateRowStyles: { fillColor: [248, 250, 252], }, margin: { left: 10, right: 10 }, }) addPageNumber() return doc.output("blob") } catch (error) { console.error("PDF Generation Error:", error) throw new Error("Failed to generate PDF report. Please try again.") } } // Helper functions function generateAIInsights(hazardsWithScores: any[], topRisks: any[]): string[] { const insights = [] const highRiskCount = hazardsWithScores.filter((h) => h.score >= 25).length const totalAssessed = hazardsWithScores.filter((h) => h.score > 0).length if (highRiskCount > totalAssessed * 0.3) { insights.push( "High risk exposure detected across multiple categories - comprehensive preparedness review recommended.", ) } if (topRisks.length > 0) { insights.push(`Primary concern: ${topRisks[0].name} requires immediate attention and resource allocation.`) } insights.push("Regular assessment updates and staff training will improve overall preparedness scores.") return insights.slice(0, 3) } function getProbabilityLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getImpactLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getResponseLabel(value: number): string { const labels = ["N/A", "Poor", "Fair", "Good"] return labels[value] || "N/A" } [V0_FILE]typescriptreact:file="lib/excel-generator-enhanced.ts" isMerged="true" import * as XLSX from "xlsx" export function generateExcel(assessmentData: any[], results: any) { // Create workbook const wb = XLSX.utils.book_new() // MAIN ASSESSMENT SHEET - Kaiser Style const mainSheetData = [ // Header section ["TIPNOW HVA", "", "", "", "", "", "", "", "", "", "", ""], ["Emergency Management", "", "", "", "", "", "", "", "", "", "", ""], ["", "", "", "", "", "", "", "", "", "", "", ""], ["Summary For - HEALTHCARE FACILITY", "", "", "", "", "", "", "", "", "", "", ""], ["", "", "", "", "", "", "", "", "", "", "", ""], // Alert Type Summary ["ALERT TYPE", "OCCURRENCE", "", "", "", "", "", "", "", "", "", ""], [ "Natural Hazards", assessmentData.filter((h) => h.id < 20 && h.probability > 0).length, "", "", "", "", "", "", "", "", "", "", ], [ "Technological Hazards", assessmentData.filter((h) => h.id >= 20 && h.id < 35 && h.probability > 0).length, "", "", "", "", "", "", "", "", "", "", ], [ "Human-Related Hazards", assessmentData.filter((h) => h.id >= 35 && h.probability > 0).length, "", "", "", "", "", "", "", "", "", "", ], [ "High Risk (≥25)", results.hazardsWithScores.filter((h: any) => h.score >= 25).length, "", "", "", "", "", "", "", "", "", "", ], [ "Medium Risk (15-24)", results.hazardsWithScores.filter((h: any) => h.score >= 15 && h.score < 25).length, "", "", "", "", "", "", "", "", "", "", ], [ "Low Risk (<15)", results.hazardsWithScores.filter((h: any) => h.score > 0 && h.score < 15).length, "", "", "", "", "", "", "", "", "", "", ], ["Total Assessed", assessmentData.filter((h) => h.probability > 0).length, "", "", "", "", "", "", "", "", "", ""], ["", "", "", "", "", "", "", "", "", "", "", ""], // Top 10 HVA Section ["YEAR", "", "", "", "", "", "", "", "", "", "", ""], ["TOP 10 HVA", "RANK", "OCCURRENCE", "HVA RANK", "", "", "", "", "", "", "", ""], ...results.topRisks .slice(0, 10) .map((risk: any, index: number) => [risk.name, index + 1, risk.score, index + 1, "", "", "", "", "", "", "", ""]), ["", "", "", "", "", "", "", "", "", "", "", ""], // Detailed Assessment Data ["DETAILED ASSESSMENT DATA", "", "", "", "", "", "", "", "", "", "", ""], ["", "", "", "", "", "", "", "", "", "", "", ""], [ "ID", "Hazard Name", "Probability", "Number of Alerts", "Number of Activations", "Human Impact", "Property Impact", "Business Impact", "Preparedness", "Internal Response", "External Response", "Risk Score", ], ...assessmentData.map((item) => [ item.id, item.name, getProbabilityLabel(item.probability), item.alerts, item.activations, getImpactLabel(item.humanImpact), getImpactLabel(item.propertyImpact), getImpactLabel(item.businessImpact), getResponseLabel(item.preparedness), getResponseLabel(item.internalResponse), getResponseLabel(item.externalResponse), item.score || 0, ]), ] const mainWS = XLSX.utils.aoa_to_sheet(mainSheetData) // Set column widths const colWidths = [ { wch: 8 }, // ID { wch: 25 }, // Hazard Name { wch: 12 }, // Probability { wch: 15 }, // Alerts { wch: 18 }, // Activations { wch: 15 }, // Human Impact { wch: 16 }, // Property Impact { wch: 16 }, // Business Impact { wch: 15 }, // Preparedness { wch: 17 }, // Internal Response { wch: 17 }, // External Response { wch: 12 }, // Risk Score ] mainWS["!cols"] = colWidths // STYLING - Kaiser Permanente Style // Main header (TIPNOW HVA) if (mainWS["A1"]) { mainWS["A1"].s = { font: { bold: true, sz: 18, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "1F4E79" } }, // Dark blue like Kaiser alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } // Emergency Management subtitle if (mainWS["A2"]) { mainWS["A2"].s = { font: { bold: true, sz: 12, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "4472C4" } }, // Medium blue alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } // Summary section header if (mainWS["A4"]) { mainWS["A4"].s = { font: { bold: true, sz: 11, color: { rgb: "000000" } }, fill: { fgColor: { rgb: "D9E2F3" } }, // Light blue alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } // Alert Type section headers const alertTypeRow = 6 for (let col = 0; col < 3; col++) { const cellAddress = XLSX.utils.encode_cell({ r: alertTypeRow - 1, c: col }) if (mainWS[cellAddress]) { mainWS[cellAddress].s = { font: { bold: true, sz: 11, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "4472C4" } }, alignment: { horizontal: "center", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } } // Alert type data rows with alternating colors for (let row = alertTypeRow; row < alertTypeRow + 7; row++) { for (let col = 0; col < 3; col++) { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (mainWS[cellAddress]) { mainWS[cellAddress].s = { font: { sz: 10 }, fill: { fgColor: { rgb: row % 2 === 0 ? "F2F2F2" : "FFFFFF" } }, alignment: { horizontal: col === 0 ? "left" : "center", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "CCCCCC" } }, bottom: { style: "thin", color: { rgb: "CCCCCC" } }, left: { style: "thin", color: { rgb: "CCCCCC" } }, right: { style: "thin", color: { rgb: "CCCCCC" } }, }, } } } } // Top 10 HVA section headers const top10Row = 16 for (let col = 0; col < 4; col++) { const cellAddress = XLSX.utils.encode_cell({ r: top10Row, c: col }) if (mainWS[cellAddress]) { mainWS[cellAddress].s = { font: { bold: true, sz: 11, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "4472C4" } }, alignment: { horizontal: "center", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } } // Top 10 data rows for (let row = top10Row + 1; row < top10Row + 11; row++) { for (let col = 0; col < 4; col++) { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (mainWS[cellAddress]) { mainWS[cellAddress].s = { font: { sz: 10 }, fill: { fgColor: { rgb: row % 2 === 0 ? "F2F2F2" : "FFFFFF" } }, alignment: { horizontal: col === 0 ? "left" : "center", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "CCCCCC" } }, bottom: { style: "thin", color: { rgb: "CCCCCC" } }, left: { style: "thin", color: { rgb: "CCCCCC" } }, right: { style: "thin", color: { rgb: "CCCCCC" } }, }, } // Highlight high risk scores if (col === 2) { // Risk score column const score = Number(mainWS[cellAddress].v) if (score >= 25) { mainWS[cellAddress].s.fill = { fgColor: { rgb: "FFE6E6" } } mainWS[cellAddress].s.font = { ...mainWS[cellAddress].s.font, color: { rgb: "CC0000" }, bold: true } } } } } } // Detailed data section header const detailHeaderRow = 29 if (mainWS[XLSX.utils.encode_cell({ r: detailHeaderRow, c: 0 })]) { mainWS[XLSX.utils.encode_cell({ r: detailHeaderRow, c: 0 })].s = { font: { bold: true, sz: 12, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "1F4E79" } }, alignment: { horizontal: "left", vertical: "center" }, } } // Detailed data table headers const dataHeaderRow = 31 for (let col = 0; col < 12; col++) { const cellAddress = XLSX.utils.encode_cell({ r: dataHeaderRow, c: col }) if (mainWS[cellAddress]) { mainWS[cellAddress].s = { font: { bold: true, sz: 10, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "4472C4" } }, alignment: { horizontal: "center", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } } // Detailed data rows for (let row = dataHeaderRow + 1; row < dataHeaderRow + 1 + assessmentData.length; row++) { for (let col = 0; col < 12; col++) { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (mainWS[cellAddress]) { mainWS[cellAddress].s = { font: { sz: 9 }, fill: { fgColor: { rgb: row % 2 === 0 ? "F8F9FA" : "FFFFFF" } }, alignment: { horizontal: col === 1 ? "left" : "center", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "E5E7EB" } }, bottom: { style: "thin", color: { rgb: "E5E7EB" } }, left: { style: "thin", color: { rgb: "E5E7EB" } }, right: { style: "thin", color: { rgb: "E5E7EB" } }, }, } // Highlight high-risk scores in the last column if (col === 11) { const score = Number(mainWS[cellAddress].v) if (score >= 25) { mainWS[cellAddress].s.fill = { fgColor: { rgb: "FEE2E2" } } mainWS[cellAddress].s.font = { ...mainWS[cellAddress].s.font, color: { rgb: "DC2626" }, bold: true } } else if (score >= 15) { mainWS[cellAddress].s.fill = { fgColor: { rgb: "FEF3C7" } } mainWS[cellAddress].s.font = { ...mainWS[cellAddress].s.font, color: { rgb: "D97706" } } } } } } } // Merge cells for headers mainWS["!merges"] = [ { s: { r: 0, c: 0 }, e: { r: 0, c: 11 } }, // TIPNOW HVA header { s: { r: 1, c: 0 }, e: { r: 1, c: 11 } }, // Emergency Management { s: { r: 3, c: 0 }, e: { r: 3, c: 11 } }, // Summary section { s: { r: 14, c: 0 }, e: { r: 14, c: 11 } }, // YEAR header { s: { r: 28, c: 0 }, e: { r: 28, c: 11 } }, // Detailed data header ] // Add the main worksheet XLSX.utils.book_append_sheet(wb, mainWS, "HVA Assessment - Kaiser Style") // Generate Excel file const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" }) const blob = new Blob([excelBuffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }) return blob } function getProbabilityLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getImpactLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getResponseLabel(value: number): string { const labels = ["N/A", "Poor", "Fair", "Good"] return labels[value] || "N/A" } [V0_FILE]typescriptreact:file="lib/excel-generator-kaiser-professional.ts" isFixed="true" isEdit="true" isQuickEdit="true" isMerged="true" import * as XLSX from "xlsx" export function generateExcel(assessmentData: any[], results: any) { // Create workbook const wb = XLSX.utils.book_new() // Create the main Kaiser-style sheet data const sheetData = [ // Row 1: Main Header - Kaiser Permanente style ["Kaiser Permanente", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 2: Subtitle - Emergency Management ["Emergency Management", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 3: Empty ["", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 4: Site info ["Hazards - HEALTHCARE FACILITY", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 5: Tool description ["Hazard Vulnerability Assessment Tool", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 6-7: Empty ["", "", "", "", "", "", "", "", "", "", "", "", "", ""], ["", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 8: Severity formula header - spans multiple columns ["", "", "", "", "", "", "", "SEVERITY = ( MAGNITUDE - MITIGATION )", "", "", "", "", "", ""], // Row 9: Main column headers [ "Alert Type", "", "PROBABILITY", "ALERTS", "ACTIVATIONS", "HUMAN IMPACT", "PROPERTY IMPACT", "BUSINESS IMPACT", "PREPARED-NESS", "INTERNAL RESPONSE", "EXTERNAL RESPONSE", "", "RISK", "", ], // Row 10: Column descriptions [ "", "", "Likelihood this will occur", "", "", "Possibility of death or injury", "Physical losses and damages", "Interruption of services", "Preplanning", "Time, effectiveness, resources", "Community/Mutual Aid staff and supplies", "", "* Relative threat", "", ], // Row 11: Empty ["", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 12: SCORE header ["SCORE", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Row 13-16: Scoring system with proper descriptions [ "", "", "0 = N/A", "Number of", "Number of", "0 = N/A", "0 = N/A", "0 = N/A", "0 = N/A", "0 = N/A", "0 = N/A", "", "0 - 100%", "", ], [ "", "", "1 = Low", "Alerts", "Activations", "1 = Low", "1 = Low", "1 = Low", "1 = High", "1 = High", "1 = High", "", "", "", ], [ "", "", "2 = Moderate", "", "", "2 = Moderate", "2 = Moderate", "2 = Moderate", "2 = Moderate", "2 = Moderate", "2 = Moderate", "", "", "", ], ["", "", "3 = High", "", "", "3 = High", "3 = High", "3 = High", "3 = Low", "3 = Low", "3 = Low", "", "", ""], // Row 17: Empty ["", "", "", "", "", "", "", "", "", "", "", "", "", ""], // Add assessment data rows (only assessed hazards) ...assessmentData .filter((item) => item.probability > 0) .map((item) => [ item.name, "", item.probability, item.alerts, item.activations, item.humanImpact, item.propertyImpact, item.businessImpact, item.preparedness, item.internalResponse, item.externalResponse, "", item.score || 0, "", ]), ] const ws = XLSX.utils.aoa_to_sheet(sheetData) // Set column widths to match Kaiser format exactly ws["!cols"] = [ { wch: 25 }, // A: Alert Type { wch: 2 }, // B: Spacer { wch: 12 }, // C: Probability { wch: 10 }, // D: Alerts { wch: 12 }, // E: Activations { wch: 12 }, // F: Human Impact { wch: 12 }, // G: Property Impact { wch: 12 }, // H: Business Impact { wch: 12 }, // I: Preparedness { wch: 12 }, // J: Internal Response { wch: 15 }, // K: External Response { wch: 2 }, // L: Spacer { wch: 10 }, // M: Risk { wch: 2 }, // N: Spacer ] // KAISER PERMANENTE PROFESSIONAL STYLING // Main header - Kaiser Permanente (Row 1) - Dark Blue with White Text if (ws["A1"]) { ws["A1"].s = { font: { bold: true, sz: 16, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "1F4E79" } }, // Kaiser dark blue alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "medium", color: { rgb: "000000" } }, bottom: { style: "medium", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } // Emergency Management (Row 2) - Medium Blue if (ws["A2"]) { ws["A2"].s = { font: { bold: true, sz: 12, color: { rgb: "FFFFFF" } }, fill: { fgColor: { rgb: "4472C4" } }, // Kaiser medium blue alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } // Site info (Row 4) - Bold black text if (ws["A4"]) { ws["A4"].s = { font: { bold: true, sz: 11 }, alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } // Tool description (Row 5) if (ws["A5"]) { ws["A5"].s = { font: { sz: 10 }, alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } // Severity formula header (Row 8) - Yellow background with black border for (let col = 7; col <= 10; col++) { const cellAddress = XLSX.utils.encode_cell({ r: 7, c: col }) if (ws[cellAddress]) { ws[cellAddress].s = { font: { bold: true, sz: 11, color: { rgb: "000000" } }, fill: { fgColor: { rgb: "FFFF99" } }, // Yellow background alignment: { horizontal: "center", vertical: "center" }, border: { top: { style: "medium", color: { rgb: "000000" } }, bottom: { style: "medium", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } } // Column headers (Row 9) - Different colors for each category like Kaiser const headerColors = [ { col: 0, color: "D9E2F3", textColor: "000000" }, // Light blue for Alert Type { col: 1, color: "FFFFFF", textColor: "000000" }, // White spacer { col: 2, color: "B4C6E7", textColor: "000000" }, // Light blue for Probability { col: 3, color: "B4C6E7", textColor: "000000" }, // Light blue for Alerts { col: 4, color: "B4C6E7", textColor: "000000" }, // Light blue for Activations { col: 5, color: "F8CBAD", textColor: "000000" }, // Light orange for Human Impact { col: 6, color: "F8CBAD", textColor: "000000" }, // Light orange for Property Impact { col: 7, color: "F8CBAD", textColor: "000000" }, // Light orange for Business Impact { col: 8, color: "C6E0B4", textColor: "000000" }, // Light green for Preparedness { col: 9, color: "C6E0B4", textColor: "000000" }, // Light green for Internal Response { col: 10, color: "C6E0B4", textColor: "000000" }, // Light green for External Response { col: 11, color: "FFFFFF", textColor: "000000" }, // White spacer { col: 12, color: "FFFF99", textColor: "000000" }, // Yellow for Risk { col: 13, color: "FFFFFF", textColor: "000000" }, // White spacer ] // Apply header styling (Row 9) headerColors.forEach(({ col, color, textColor }) => { const cellAddress = XLSX.utils.encode_cell({ r: 8, c: col }) if (ws[cellAddress]) { ws[cellAddress].s = { font: { bold: true, sz: 10, color: { rgb: textColor } }, fill: { fgColor: { rgb: color } }, alignment: { horizontal: "center", vertical: "center", wrapText: true }, border: { top: { style: "medium", color: { rgb: "000000" } }, bottom: { style: "medium", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } }) // Description row (Row 10) - Same colors as headers headerColors.forEach(({ col, color, textColor }) => { const cellAddress = XLSX.utils.encode_cell({ r: 9, c: col }) if (ws[cellAddress]) { ws[cellAddress].s = { font: { sz: 9, color: { rgb: textColor } }, fill: { fgColor: { rgb: color } }, alignment: { horizontal: "center", vertical: "center", wrapText: true }, border: { top: { style: "medium", color: { rgb: "000000" } }, bottom: { style: "medium", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } }) // SCORE header (Row 12) - Gray background if (ws["A12"]) { ws["A12"].s = { font: { bold: true, sz: 11, color: { rgb: "000000" } }, fill: { fgColor: { rgb: "D9D9D9" } }, // Gray background alignment: { horizontal: "left", vertical: "center" }, border: { top: { style: "medium", color: { rgb: "000000" } }, bottom: { style: "medium", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } // Scoring system rows (Rows 13-16) - Same colors as main headers for (let row = 12; row <= 15; row++) { headerColors.forEach(({ col, color, textColor }) => { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (ws[cellAddress]) { ws[cellAddress].s = { font: { sz: 8, color: { rgb: textColor } }, fill: { fgColor: { rgb: color } }, alignment: { horizontal: "center", vertical: "center" }, border: { top: { style: "medium", color: { rgb: "000000" } }, bottom: { style: "medium", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } } }) } // Data rows styling (starting from row 18) - Professional borders and colors const dataStartRow = 17 const dataRows = assessmentData.filter((item) => item.probability > 0).length for (let row = dataStartRow; row < dataStartRow + dataRows; row++) { headerColors.forEach(({ col, color }) => { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (ws[cellAddress]) { // Use same colors as headers but slightly lighter for data rows let bgColor = color if (color === "B4C6E7") bgColor = "E8F1FF" else if (color === "F8CBAD") bgColor = "FFF2E8" else if (color === "C6E0B4") bgColor = "F0F8E8" else if (color === "FFFF99") bgColor = "FFFFCC" else if (color === "D9E2F3") bgColor = "F0F4FF" ws[cellAddress].s = { font: { sz: 9, color: { rgb: "000000" } }, fill: { fgColor: { rgb: bgColor } }, alignment: { horizontal: col === 0 ? "left" : "center", vertical: "center", }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "medium", color: { rgb: "000000" } }, right: { style: "medium", color: { rgb: "000000" } }, }, } // Highlight high risk scores in red if (col === 12 && ws[cellAddress].v >= 25) { ws[cellAddress].s.fill = { fgColor: { rgb: "FF9999" } } ws[cellAddress].s.font = { ...ws[cellAddress].s.font, bold: true, color: { rgb: "CC0000" } } } } }) } // Merge cells for headers - exactly like Kaiser format ws["!merges"] = [ // Main headers { s: { r: 0, c: 0 }, e: { r: 0, c: 13 } }, // Kaiser Permanente { s: { r: 1, c: 0 }, e: { r: 1, c: 13 } }, // Emergency Management { s: { r: 3, c: 0 }, e: { r: 3, c: 13 } }, // Site info { s: { r: 4, c: 0 }, e: { r: 4, c: 13 } }, // Tool description // Severity formula - spans 4 columns { s: { r: 7, c: 7 }, e: { r: 7, c: 10 } }, // Severity formula // Risk column header { s: { r: 8, c: 12 }, e: { r: 8, c: 13 } }, // Risk header { s: { r: 9, c: 12 }, e: { r: 9, c: 13 } }, // Risk description // Score section { s: { r: 11, c: 0 }, e: { r: 11, c: 1 } }, // SCORE header ] // Set row heights for professional appearance ws["!rows"] = [ { hpt: 30 }, // Row 1 - Kaiser Permanente header { hpt: 25 }, // Row 2 - Emergency Management { hpt: 15 }, // Row 3 { hpt: 20 }, // Row 4 - Site info { hpt: 18 }, // Row 5 - Tool description { hpt: 10 }, // Row 6 { hpt: 10 }, // Row 7 { hpt: 25 }, // Row 8 - Severity formula { hpt: 40 }, // Row 9 - Column headers { hpt: 50 }, // Row 10 - Descriptions { hpt: 15 }, // Row 11 { hpt: 20 }, // Row 12 - SCORE { hpt: 30 }, // Row 13-16 - Scoring system { hpt: 30 }, { hpt: 30 }, { hpt: 30 }, { hpt: 15 }, // Row 17 ] // Add the worksheet to workbook XLSX.utils.book_append_sheet(wb, ws, "Kaiser HVA Professional") // Generate Excel file const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" }) const blob = new Blob([excelBuffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }) return blob } [V0_FILE]typescriptreact:file="lib/excel-generator-simple.ts" isEdit="true" isMerged="true" import * as XLSX from "xlsx" interface HazardData { id: number name: string category: string probability: number alerts: number activations: number humanImpact: number propertyImpact: number businessImpact: number preparedness: number internalResponse: number externalResponse: number riskScore: number } // Convert numeric values to text labels const getTextValue = (value: number, type: "probability" | "impact" | "response"): string => { if (value === 0) return "N/A" switch (type) { case "probability": switch (value) { case 1: return "Low" case 2: return "Moderate" case 3: return "High" default: return "N/A" } case "impact": switch (value) { case 1: return "Low" case 2: return "Moderate" case 3: return "High" default: return "N/A" } case "response": switch (value) { case 1: return "Poor" case 2: return "Fair" case 3: return "Good" default: return "N/A" } } } export function generateExcel(assessmentData: any[], results: any): Blob { // Create workbook const wb = XLSX.utils.book_new() // Prepare data for Excel - exactly like the image format const excelData = assessmentData.map((hazard, index) => ({ ID: hazard.id || index + 1, "Hazard Name": hazard.name, Probability: getTextValue(hazard.probability, "probability"), "Number of Alerts": hazard.alerts || 0, "Number of Activations": hazard.activations || 0, "Human Impact": getTextValue(hazard.humanImpact, "impact"), "Property Impact": getTextValue(hazard.propertyImpact, "impact"), "Business Impact": getTextValue(hazard.businessImpact, "impact"), Preparedness: getTextValue(hazard.preparedness, "response"), "Internal Response": getTextValue(hazard.internalResponse, "response"), "External Response": getTextValue(hazard.externalResponse, "response"), "Risk Score": hazard.score || 0, })) // Create worksheet const ws = XLSX.utils.json_to_sheet(excelData) // Set column widths const colWidths = [ { wch: 5 }, // ID { wch: 25 }, // Hazard Name { wch: 12 }, // Probability { wch: 15 }, // Number of Alerts { wch: 18 }, // Number of Activations { wch: 15 }, // Human Impact { wch: 15 }, // Property Impact { wch: 15 }, // Business Impact { wch: 15 }, // Preparedness { wch: 17 }, // Internal Response { wch: 17 }, // External Response { wch: 12 }, // Risk Score ] ws["!cols"] = colWidths // Get the range of the worksheet const range = XLSX.utils.decode_range(ws["!ref"] || "A1") // Style the header row with background color and proper alignment for (let col = range.s.c; col <= range.e.c; col++) { const cellAddress = XLSX.utils.encode_cell({ r: 0, c: col }) if (ws[cellAddress]) { ws[cellAddress].s = { font: { bold: true, color: { rgb: "FFFFFF" }, // White text }, fill: { fgColor: { rgb: "4472C4" }, // Blue background for headers }, alignment: { horizontal: "center", vertical: "top", // Top alignment as requested wrapText: true, }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } } // Style data rows with proper alignment and borders for (let row = range.s.r + 1; row <= range.e.r; row++) { for (let col = range.s.c; col <= range.e.c; col++) { const cellAddress = XLSX.utils.encode_cell({ r: row, c: col }) if (ws[cellAddress]) { ws[cellAddress].s = { alignment: { horizontal: col === 1 ? "left" : "center", // Hazard name left-aligned, others centered vertical: "top", // Top alignment for all cells }, border: { top: { style: "thin", color: { rgb: "000000" } }, bottom: { style: "thin", color: { rgb: "000000" } }, left: { style: "thin", color: { rgb: "000000" } }, right: { style: "thin", color: { rgb: "000000" } }, }, } } } } // Add worksheet to workbook XLSX.utils.book_append_sheet(wb, ws, "HVA Assessment") // Generate Excel file const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" }) const blob = new Blob([excelBuffer], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }) return blob } [V0_FILE]typescriptreact:file="components/HazardTable.tsx" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { ChevronDown, ChevronRight, Info } from "lucide-react" import { cn } from "@/lib/utils" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" type HazardData = { id: number name: string probability: number alerts: number activations: number humanImpact: number propertyImpact: number businessImpact: number preparedness: number internalResponse: number externalResponse: number } type HazardTableProps = { data: HazardData[] setData: React.Dispatch> } const probabilityLabels = ["N/A", "Low", "Moderate", "High"] const impactLabels = ["N/A", "Low", "Moderate", "High"] const responseLabels = ["N/A", "Poor", "Fair", "Good"] export default function HazardTable({ data, setData }: HazardTableProps) { const [expandedSection, setExpandedSection] = useState("natural") const updateHazardValue = (id: number, field: keyof HazardData, value: number) => { setData(data.map((hazard) => (hazard.id === id ? { ...hazard, [field]: value } : hazard))) } const handleKeyDown = ( e: React.KeyboardEvent, id: number, field: keyof HazardData, currentValue: number, maxValue = 3, ) => { const safeValue = isNaN(currentValue) ? 0 : currentValue if (e.key === " " || e.code === "Space") { e.preventDefault() const newValue = (safeValue + 1) % (maxValue + 1) updateHazardValue(id, field, newValue) } else if ((e.key === "Backspace" || e.code === "Backspace") && (field === "alerts" || field === "activations")) { e.preventDefault() const newValue = Math.max(0, safeValue - 1) updateHazardValue(id, field, newValue) } } const renderValueCell = ( id: number, field: keyof HazardData, value: number, labels: string[] = [], bgColorClass = "", textColorClass = "text-gray-900", ) => { const safeValue = isNaN(value) ? 0 : value return ( handleKeyDown(e, id, field, safeValue)} onClick={() => { const newValue = labels.length > 0 ? (safeValue + 1) % labels.length : (safeValue + 1) % 4 updateHazardValue(id, field, newValue) }} >

{labels.length > 0 ? labels[safeValue] || "N/A" : safeValue.toString()} {labels.length === 0 && Count}

) } // Group hazards by category const naturalHazards = data.filter((h) => h.id < 20) const technologicalHazards = data.filter((h) => h.id >= 20 && h.id < 35) const humanHazards = data.filter((h) => h.id >= 35) const renderHazardSection = (title: string, hazards: HazardData[], sectionKey: string, iconColor: string) => { const isExpanded = expandedSection === sectionKey const completedHazards = hazards.filter((h) => h.probability > 0).length return ( setExpandedSection(isExpanded ? null : sectionKey)} >

{isExpanded ? ( ) : ( )} {title} {completedHazards}/{hazards.length} assessed

{isExpanded ? "Click to collapse" : "Click to expand"}

{/* Fixed height container to prevent layout shifts */}

{/* Fixed table container with consistent spacing */}

{hazards.map((hazard, index) => ( {renderValueCell( hazard.id, "probability", hazard.probability, probabilityLabels, "bg-blue-50 hover:bg-blue-100", "text-blue-900", )} {renderValueCell( hazard.id, "alerts", hazard.alerts, [], "bg-blue-50 hover:bg-blue-100", "text-blue-900", )} {renderValueCell( hazard.id, "activations", hazard.activations, [], "bg-blue-50 hover:bg-blue-100", "text-blue-900", )} {renderValueCell( hazard.id, "humanImpact", hazard.humanImpact, impactLabels, "bg-orange-50 hover:bg-orange-100", "text-orange-900", )} {renderValueCell( hazard.id, "propertyImpact", hazard.propertyImpact, impactLabels, "bg-orange-50 hover:bg-orange-100", "text-orange-900", )} {renderValueCell( hazard.id, "businessImpact", hazard.businessImpact, impactLabels, "bg-orange-50 hover:bg-orange-100", "text-orange-900", )} {renderValueCell( hazard.id, "preparedness", hazard.preparedness, responseLabels, "bg-green-50 hover:bg-green-100", "text-green-900", )} {renderValueCell( hazard.id, "internalResponse", hazard.internalResponse, responseLabels, "bg-green-50 hover:bg-green-100", "text-green-900", )} {renderValueCell( hazard.id, "externalResponse", hazard.externalResponse, responseLabels, "bg-green-50 hover:bg-green-100", "text-green-900", )} ))}

Hazard	Likelihood Factors	Impact Assessment	Response Capability
	Probability	Alerts	Activations	Human	Property	Business	Preparedness	Internal	External
#{hazard.id} {hazard.name}

) } return (

{/* Instructions Card */}

How to Use This Assessment

Space - Cycle through values for all fields

Backspace - Decrease Alerts and Activations counts

Click any cell to cycle through values, or use keyboard shortcuts for faster entry.

{/* Hazard Sections */} {renderHazardSection("Natural Hazards", naturalHazards, "natural", "blue")} {renderHazardSection("Technological Hazards", technologicalHazards, "technological", "orange")} {renderHazardSection("Human-Related Hazards", humanHazards, "human", "green")}

) } [V0_FILE]typescriptreact:file="lib/supabase.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { createClient } from "@supabase/supabase-js" const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL! const supabaseAnonKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY! export const supabase = createClient(supabaseUrl, supabaseAnonKey) export type Database = { public: { Tables: { hva_assessments: { Row: { id: string user_id: string assessment_name: string assessment_data: any results_data: any created_at: string updated_at: string } Insert: { id?: string user_id: string assessment_name: string assessment_data: any results_data: any created_at?: string updated_at?: string } Update: { id?: string user_id?: string assessment_name?: string assessment_data?: any results_data?: any created_at?: string updated_at?: string } } } } } [V0_FILE]sql:file="scripts/fix-hva-table-v2.sql" isMerged="true" -- Drop the existing table if it has the wrong structure DROP TABLE IF EXISTS public.hva_assessments; -- Create the correct hva_assessments table structure CREATE TABLE public.hva_assessments ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL, assessment_name TEXT NOT NULL, assessment_data JSONB NOT NULL, results_data JSONB NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Enable Row Level Security ALTER TABLE public.hva_assessments ENABLE ROW LEVEL SECURITY; -- Drop existing policies if they exist DROP POLICY IF EXISTS "Users can manage their own assessments" ON public.hva_assessments; DROP POLICY IF EXISTS "Users can only see their own assessments" ON public.hva_assessments; DROP POLICY IF EXISTS "Users can insert their own assessments" ON public.hva_assessments; DROP POLICY IF EXISTS "Users can update their own assessments" ON public.hva_assessments; DROP POLICY IF EXISTS "Users can delete their own assessments" ON public.hva_assessments; -- Create comprehensive policy for all operations CREATE POLICY "Users can manage their own assessments" ON public.hva_assessments FOR ALL USING (auth.uid() = user_id); -- Create indexes for better performance CREATE INDEX IF NOT EXISTS idx_hva_assessments_user_id ON public.hva_assessments(user_id); CREATE INDEX IF NOT EXISTS idx_hva_assessments_created_at ON public.hva_assessments(created_at DESC); -- Create function to automatically update updated_at timestamp CREATE OR REPLACE FUNCTION update_updated_at_column() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ language 'plpgsql'; -- Create trigger to automatically update updated_at DROP TRIGGER IF EXISTS update_hva_assessments_updated_at ON public.hva_assessments; CREATE TRIGGER update_hva_assessments_updated_at BEFORE UPDATE ON public.hva_assessments FOR EACH ROW EXECUTE FUNCTION update_updated_at_column(); [V0_FILE]typescriptreact:file="lib/database-utils.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { supabase } from "./supabase" export async function ensureTableExists() { try { // Try to create the table if it doesn't exist const { error } = await supabase.rpc("create_hva_table_if_not_exists") if (error) { console.log("RPC function not available, table may need manual creation") return false } return true } catch (error) { console.log("Could not ensure table exists:", error) return false } } export async function checkTableExists() { try { const { error } = await supabase.from("hva_assessments").select("id").limit(1) return !error || !error.message.includes("does not exist") } catch (error) { return false } } export async function testDatabaseConnection() { try { // Test basic connection const { data, error } = await supabase.from("hva_assessments").select("count").limit(1) if (error) { console.error("Database connection test failed:", error) return false } console.log("Database connection successful") return true } catch (error) { console.error("Database connection error:", error) return false } } export async function debugUserAssessments(userId: string) { try { const { data, error } = await supabase.from("hva_assessments").select("*").eq("user_id", userId) console.log("User assessments debug:", { userId, data, error }) return { data, error } } catch (error) { console.error("Debug error:", error) return { data: null, error } } } [V0_FILE]sql:file="scripts/setup-auth-policies.sql" isMerged="true" -- Enable RLS on auth.users if needed (usually handled by Supabase) -- This script ensures proper email uniqueness at the database level -- Create a function to check for duplicate emails (if needed) CREATE OR REPLACE FUNCTION check_email_uniqueness() RETURNS TRIGGER AS $$ BEGIN -- Check if email already exists (case-insensitive) IF EXISTS ( SELECT 1 FROM auth.users WHERE LOWER(email) = LOWER(NEW.email) AND id != COALESCE(NEW.id, '00000000-0000-0000-0000-000000000000'::uuid) ) THEN RAISE EXCEPTION 'Email address already exists'; END IF; RETURN NEW; END; $$ LANGUAGE plpgsql; -- Note: You typically cannot create triggers on auth.users in Supabase -- This is just for reference - Supabase handles email uniqueness automatically -- Ensure our HVA assessments table has proper constraints ALTER TABLE public.hva_assessments ADD CONSTRAINT unique_user_assessment_name UNIQUE (user_id, assessment_name); -- Create index for faster email lookups (if we had access to auth.users) -- CREATE UNIQUE INDEX IF NOT EXISTS idx_users_email_unique ON auth.users (LOWER(email)); [V0_FILE]typescriptreact:file="hooks/useEmailValidation.ts" isMerged="true" "use client" import { useState } from "react" import { supabase } from "@/lib/supabase" export function useEmailValidation() { const [isChecking, setIsChecking] = useState(false) const checkEmailExists = async (email: string): Promise => { if (!email || !isValidEmail(email)) return false setIsChecking(true) try { // Try to sign in with a dummy password to check if email exists const { error } = await supabase.auth.signInWithPassword({ email: email.toLowerCase().trim(), password: "dummy_password_check_12345", }) // If error is about invalid credentials, email exists if (error && error.message.includes("Invalid login credentials")) { return true } // If error is about email not confirmed, email exists if (error && error.message.includes("Email not confirmed")) { return true } return false } catch (error) { return false } finally { setIsChecking(false) } } const isValidEmail = (email: string): boolean => { const emailRegex = /^[^\s@]+@[^\s@]+\.[^\s@]+$/ return emailRegex.test(email) } const validatePassword = (password: string) => { const errors = [] if (password.length < 6) { errors.push("Password must be at least 6 characters long") } // Add more password requirements if needed // if (!/[A-Z]/.test(password)) { // errors.push('Password must contain at least one uppercase letter') // } // if (!/[0-9]/.test(password)) { // errors.push('Password must contain at least one number') // } return { isValid: errors.length === 0, errors, } } return { checkEmailExists, isValidEmail, validatePassword, isChecking, } } [V0_FILE]typescriptreact:file="components/Auth.tsx" isFixed="true" isEdit="true" isQuickEdit="true" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs" import { useAuth } from "@/contexts/AuthContext" import { Loader2, Shield, AlertCircle } from "lucide-react" import { checkEmailExists } from "@/lib/auth" export function Auth() { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [loading, setLoading] = useState(false) const [message, setMessage] = useState("") const [emailChecking, setEmailChecking] = useState(false) const { signIn, signUp } = useAuth() // Check email as user types (debounced) const handleEmailChange = async (e: React.ChangeEvent) => { const newEmail = e.target.value setEmail(newEmail) // Clear previous messages setMessage("") // Only check if email looks valid if (newEmail.includes("@") && newEmail.includes(".")) { setEmailChecking(true) // Add a small delay to avoid too many requests setTimeout(async () => { const exists = await checkEmailExists(newEmail) if (exists) { setMessage("This email is already registered. Please sign in instead.") } setEmailChecking(false) }, 500) } } const handleSignIn = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signIn(email, password) if (error) { if (error.message.includes("Invalid login credentials")) { setMessage("Invalid email or password. Please check your credentials.") } else { setMessage(error.message) } } setLoading(false) } const handleSignUp = async (e: React.FormEvent) => { e.preventDefault() // Don't proceed if email already exists if (message.includes("already registered")) { return } setLoading(true) setMessage("") const { error } = await signUp(email, password) if (error) { setMessage(error.message) } else { setMessage("Account created! Check your email for the confirmation link.") // Clear form on success setEmail("") setPassword("") } setLoading(false) } const isEmailTaken = message.includes("already registered") return (

TIPNOW HVA Sign in to access your Hazard Vulnerability Assessments Sign In Sign Up {message && (

{message}

)}

) } [V0_FILE]typescriptreact:file="contexts/AuthContext.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { createContext, useContext, useEffect, useState } from "react" import type { User } from "@supabase/supabase-js" import { supabase } from "@/lib/supabase" import { checkEmailExists } from "@/lib/auth" type AuthContextType = { user: User | null loading: boolean signIn: (email: string, password: string) => Promise<{ error: any }> signUp: (email: string, password: string) => Promise<{ error: any }> signOut: () => Promise } const AuthContext = createContext(undefined) export function AuthProvider({ children }: { children: React.ReactNode }) { const [user, setUser] = useState(null) const [loading, setLoading] = useState(true) useEffect(() => { const getInitialSession = async () => { const { data: { session }, } = await supabase.auth.getSession() setUser(session?.user ?? null) setLoading(false) } getInitialSession() const { data: { subscription }, } = supabase.auth.onAuthStateChange(async (event, session) => { setUser(session?.user ?? null) setLoading(false) }) return () => subscription.unsubscribe() }, []) const signIn = async (email: string, password: string) => { const { error } = await supabase.auth.signInWithPassword({ email: email.toLowerCase().trim(), password, }) return { error } } const signUp = async (email: string, password: string) => { const normalizedEmail = email.toLowerCase().trim() // Check if email already exists before attempting signup const emailExists = await checkEmailExists(normalizedEmail) if (emailExists) { return { error: { message: "This email is already registered. Please sign in instead.", }, } } const { data, error } = await supabase.auth.signUp({ email: normalizedEmail, password, }) // Additional check for Supabase errors if (error) { if ( error.message.includes("already registered") || error.message.includes("already exists") || error.message.includes("User already registered") ) { return { error: { message: "This email is already registered. Please sign in instead.", }, } } } return { error } } const signOut = async () => { await supabase.auth.signOut() } const value = { user, loading, signIn, signUp, signOut, } return {children} } export function useAuth() { const context = useContext(AuthContext) if (context === undefined) { throw new Error("useAuth must be used within an AuthProvider") } return context } [V0_FILE]typescriptreact:file="lib/pdf-generator-kaiser-style.ts" isEdit="true" isQuickEdit="true" isMerged="true" import { jsPDF } from "jspdf" import "jspdf-autotable" import type { UserOptions } from "jspdf-autotable" declare module "jspdf" { interface jsPDF { autoTable: (options: UserOptions) => jsPDF } } export async function generatePDF(assessmentData: any[], results: any): Promise { try { const doc = new jsPDF() const pageWidth = doc.internal.pageSize.width const pageHeight = doc.internal.pageSize.height let yPosition = 20 // Helper function to safely add text const safeAddText = (text: string, x: number, y: number, options?: any) => { try { // Ensure text is a string and coordinates are numbers const safeText = String(text || "") const safeX = Number(x) || 20 const safeY = Number(y) || 20 if (safeText.length > 0) { doc.text(safeText, safeX, safeY, options) } return safeY + 7 } catch (error) { console.warn("Text rendering error:", error) return y + 7 } } // Helper function to check page break const checkPageBreak = (requiredSpace = 20) => { if (yPosition + requiredSpace > pageHeight - 20) { doc.addPage() yPosition = 20 } } // TITLE PAGE doc.setFontSize(24) doc.setFont("helvetica", "bold") yPosition = safeAddText("TIPNOW HVA REPORT", 20, yPosition) yPosition += 10 doc.setFontSize(16) doc.setFont("helvetica", "normal") yPosition = safeAddText("Hazard Vulnerability Assessment", 20, yPosition) yPosition += 20 // Date doc.setFontSize(12) const currentDate = new Date().toLocaleDateString("en-US", { year: "numeric", month: "long", day: "numeric", }) yPosition = safeAddText(`Generated: ${currentDate}`, 20, yPosition) yPosition += 20 // SUMMARY SECTION doc.setFontSize(16) doc.setFont("helvetica", "bold") yPosition = safeAddText("Assessment Summary", 20, yPosition) yPosition += 15 doc.setFontSize(11) doc.setFont("helvetica", "normal") // Calculate safe statistics const totalHazards = Array.isArray(assessmentData) ? assessmentData.length : 0 const assessedHazards = Array.isArray(assessmentData) ? assessmentData.filter((h) => h && typeof h.probability === "number" && h.probability > 0).length : 0 const hazardsWithScores = results?.hazardsWithScores || [] const highRiskCount = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && typeof h.score === "number" && h.score >= 25).length : 0 const mediumRiskCount = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && typeof h.score === "number" && h.score >= 15 && h.score < 25).length : 0 const lowRiskCount = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && typeof h.score === "number" && h.score > 0 && h.score < 15).length : 0 // Summary statistics const summaryStats = [ `Total Hazards: ${totalHazards}`, `Hazards Assessed: ${assessedHazards}`, `High Risk (≥25): ${highRiskCount}`, `Medium Risk (15-24): ${mediumRiskCount}`, `Low Risk (<15): ${lowRiskCount}`, ] summaryStats.forEach((stat) => { checkPageBreak(10) yPosition = safeAddText(`• ${stat}`, 25, yPosition) yPosition += 5 }) yPosition += 15 // TOP RISKS SECTION const topRisks = results?.topRisks || [] if (Array.isArray(topRisks) && topRisks.length > 0) { checkPageBreak(60) doc.setFontSize(16) doc.setFont("helvetica", "bold") yPosition = safeAddText("Top Risk Hazards", 20, yPosition) yPosition += 15 doc.setFontSize(10) doc.setFont("helvetica", "bold") yPosition = safeAddText("Rank Hazard Name Risk Score", 20, yPosition) yPosition += 10 doc.setFont("helvetica", "normal") // Display top 10 risks safely topRisks.slice(0, 10).forEach((risk, index) => { checkPageBreak(8) if (risk && typeof risk.name === "string" && typeof risk.score === "number") { const rank = String(index + 1).padEnd(6) const name = String(risk.name).substring(0, 40).padEnd(42) const score = String(risk.score) yPosition = safeAddText(`${rank}${name}${score}`, 20, yPosition) } yPosition += 2 }) yPosition += 15 } // DETAILED DATA SECTION if (Array.isArray(assessmentData) && assessmentData.length > 0) { checkPageBreak(80) doc.setFontSize(16) doc.setFont("helvetica", "bold") yPosition = safeAddText("Detailed Assessment Data", 20, yPosition) yPosition += 15 // Filter assessed hazards safely const assessedData = assessmentData.filter( (item) => item && typeof item.probability === "number" && item.probability > 0 && typeof item.name === "string", ) if (assessedData.length > 0) { // Create simple table data const tableData = assessedData.slice(0, 15).map((item) => { const safeName = String(item.name || "Unknown").substring(0, 30) const safeProb = String(item.probability || 0) const safeHuman = String(item.humanImpact || 0) const safeProp = String(item.propertyImpact || 0) const safeBusiness = String(item.businessImpact || 0) const safeScore = String(item.score || 0) return [safeName, safeProb, safeHuman, safeProp, safeBusiness, safeScore] }) // Try autoTable with error handling try { doc.autoTable({ head: [["Hazard Name", "Prob", "Human", "Property", "Business", "Score"]], body: tableData, startY: yPosition, theme: "grid", headStyles: { fillColor: [52, 152, 219], textColor: [255, 255, 255], fontSize: 10, }, bodyStyles: { fontSize: 9, }, columnStyles: { 0: { cellWidth: 60 }, 1: { cellWidth: 20 }, 2: { cellWidth: 20 }, 3: { cellWidth: 20 }, 4: { cellWidth: 20 }, 5: { cellWidth: 20 }, }, }) // Update yPosition after table yPosition = (doc as any).lastAutoTable?.finalY + 15 || yPosition + 100 } catch (tableError) { console.warn("AutoTable failed, using text fallback:", tableError) // Fallback to simple text table doc.setFontSize(9) doc.setFont("helvetica", "bold") yPosition = safeAddText("Hazard Name Prob Human Prop Bus Score", 20, yPosition) yPosition += 8 doc.setFont("helvetica", "normal") tableData.forEach((row) => { checkPageBreak(8) const line = `${row[0].padEnd(30)} ${row[1].padEnd(5)} ${row[2].padEnd(6)} ${row[3].padEnd(5)} ${row[4].padEnd(4)} ${row[5]}` yPosition = safeAddText(line, 20, yPosition) }) yPosition += 15 } } } // RECOMMENDATIONS SECTION checkPageBreak(60) doc.setFontSize(16) doc.setFont("helvetica", "bold") yPosition = safeAddText("Recommendations", 20, yPosition) yPosition += 15 doc.setFontSize(11) doc.setFont("helvetica", "normal") const recommendations = [ "Develop comprehensive emergency response plans for high-risk hazards", "Implement regular training and drill programs for staff", "Establish monitoring systems for early warning and detection", "Review and update this assessment annually", "Prioritize resource allocation based on identified risk levels", ] recommendations.forEach((rec, index) => { checkPageBreak(15) yPosition = safeAddText(`${index + 1}. ${rec}`, 25, yPosition) yPosition += 8 }) // Add page numbers safely const totalPages = doc.getNumberOfPages() for (let i = 1; i <= totalPages; i++) { doc.setPage(i) doc.setFontSize(10) doc.setTextColor(128, 128, 128) safeAddText(`Page ${i} of ${totalPages}`, pageWidth - 40, pageHeight - 10) } // Reset text color doc.setTextColor(0, 0, 0) return doc.output("blob") } catch (error) { console.error("PDF Generation Error:", error) // Create minimal error PDF try { const errorDoc = new jsPDF() errorDoc.setFontSize(16) errorDoc.setFont("helvetica", "bold") errorDoc.text("PDF Generation Error", 20, 30) errorDoc.setFontSize(12) errorDoc.setFont("helvetica", "normal") errorDoc.text("Unable to generate the full report.", 20, 50) errorDoc.text("Please try again or contact support.", 20, 65) return errorDoc.output("blob") } catch (fallbackError) { console.error("Even error PDF failed:", fallbackError) // Return empty blob as last resort return new Blob(["PDF generation failed"], { type: "application/pdf" }) } } } // Simplified helper functions function getProbabilityLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getImpactLabel(value: number): string { const labels = ["N/A", "Low", "Moderate", "High"] return labels[value] || "N/A" } function getResponseLabel(value: number): string { const labels = ["N/A", "Poor", "Fair", "Good"] return labels[value] || "N/A" } [V0_FILE]typescriptreact:file="components/hazard-assessment.tsx" isEdit="true" isMerged="true" "use client" import { useState } from "react" import { Download, FileSpreadsheet, Calculator, TrendingUp, AlertTriangle, CheckCircle, Save, Info, FileText, Lightbulb, } from "lucide-react" import { Button } from "@/components/ui/button" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" import { Progress } from "@/components/ui/progress" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { calculateRiskScores } from "@/lib/calculate-risk" import { hazardData } from "@/lib/hazard-data" import { supabase } from "@/lib/supabase" import { useAuth } from "@/contexts/AuthContext" import HazardTable from "@/components/HazardTable" export function HazardAssessment() { const [assessmentData, setAssessmentData] = useState(hazardData) const [results, setResults] = useState(null) const [isGenerating, setIsGenerating] = useState(false) const [isSaving, setIsSaving] = useState(false) const [assessmentName, setAssessmentName] = useState("") const [saveMessage, setSaveMessage] = useState("") const { user } = useAuth() const handleCalculate = async () => { console.log("Calculating risk scores...") const calculatedResults = calculateRiskScores(assessmentData) console.log("Calculated results:", calculatedResults) setResults(calculatedResults) // Auto-save if user is logged in if (user) { await saveAssessment(calculatedResults, true) } } const generateUniqueAssessmentName = async (baseName: string, userId: string): Promise => { let uniqueName = baseName let counter = 1 while (true) { // Check if this name already exists for this user const { data, error } = await supabase .from("hva_assessments") .select("id") .eq("user_id", userId) .eq("assessment_name", uniqueName) .limit(1) if (error) { console.error("Error checking name uniqueness:", error) // If we can't check, just use the name with timestamp return `${baseName} ${new Date().toISOString().split("T")[0]} ${Date.now()}` } if (!data || data.length === 0) { // Name is unique return uniqueName } // Name exists, try with counter uniqueName = `${baseName} (${counter})` counter++ // Prevent infinite loop if (counter > 100) { return `${baseName} ${Date.now()}` } } } const saveAssessment = async (calculatedResults?: any, isAutoSave = false) => { if (!user) { if (!isAutoSave) { setSaveMessage("Please log in to save assessments") setTimeout(() => setSaveMessage(""), 3000) } return } setIsSaving(true) if (!isAutoSave) setSaveMessage("") try { const resultsToSave = calculatedResults || results let baseName = assessmentName.trim() || `Assessment ${new Date().toLocaleDateString()}` // Ensure we have valid data to save if (!resultsToSave || !resultsToSave.hazardsWithScores) { if (!isAutoSave) { setSaveMessage("No assessment data to save. Please calculate risk scores first.") setTimeout(() => setSaveMessage(""), 3000) } return } // Validate that we have actual assessment data (not all zeros) const assessedHazards = assessmentData.filter((h) => h.probability > 0) if (assessedHazards.length === 0) { if (!isAutoSave) { setSaveMessage("Please complete at least one hazard assessment before saving.") setTimeout(() => setSaveMessage(""), 3000) } return } // For auto-save, always generate a unique name with timestamp if (isAutoSave) { baseName = `Auto-saved ${new Date().toLocaleString()}` } else { // For manual save, ensure the name is unique baseName = await generateUniqueAssessmentName(baseName, user.id) } console.log("Saving assessment:", { user_id: user.id, assessment_name: baseName, assessed_hazards_count: assessedHazards.length, }) // First, check if table exists by trying a simple query const { error: testError } = await supabase.from("hva_assessments").select("id").limit(1) if (testError && testError.message.includes("does not exist")) { if (!isAutoSave) { setSaveMessage("Database table not found. Please contact support to set up the database.") setTimeout(() => setSaveMessage(""), 5000) } console.error("Table does not exist:", testError) return } // Proceed with insert const { data, error } = await supabase .from("hva_assessments") .insert({ user_id: user.id, assessment_name: baseName, assessment_data: assessmentData, results_data: resultsToSave, }) .select() if (error) { console.error("Save error details:", { message: error.message, details: error.details, hint: error.hint, code: error.code, }) if (!isAutoSave) { if (error.message.includes("duplicate key") || error.message.includes("unique constraint")) { // This shouldn't happen now with our unique name generation, but just in case const fallbackName = `${baseName} ${Date.now()}` setSaveMessage(`Name conflict detected. Trying with: "${fallbackName}"`) // Try once more with timestamp const { data: retryData, error: retryError } = await supabase .from("hva_assessments") .insert({ user_id: user.id, assessment_name: fallbackName, assessment_data: assessmentData, results_data: resultsToSave, }) .select() if (retryError) { setSaveMessage(`Error saving: ${retryError.message}`) } else { setSaveMessage(`Assessment saved as: "${fallbackName}"`) setAssessmentName("") } } else if (error.message.includes("permission")) { setSaveMessage("Permission denied. Please check your account permissions.") } else { setSaveMessage(`Error saving: ${error.message}`) } setTimeout(() => setSaveMessage(""), 5000) } } else { console.log("Assessment saved successfully:", data) if (!isAutoSave) { setSaveMessage(`Assessment saved successfully as: "${baseName}"`) setAssessmentName("") setTimeout(() => setSaveMessage(""), 3000) } } } catch (error) { console.error("Unexpected save error:", error) if (!isAutoSave) { setSaveMessage("Unexpected error saving assessment. Please try again.") setTimeout(() => setSaveMessage(""), 3000) } } finally { setIsSaving(false) } } // Debug function to test database connection const testDatabaseConnection = async () => { if (!user) { setSaveMessage("Please log in first") return } try { console.log("Testing database connection...") // Test 1: Check if table exists const { data: tableTest, error: tableError } = await supabase.from("hva_assessments").select("count").limit(1) console.log("Table test result:", { tableTest, tableError }) if (tableError) { setSaveMessage(`Database Error: ${tableError.message}`) return } // Test 2: Check user permissions const { data: permTest, error: permError } = await supabase .from("hva_assessments") .select("*") .eq("user_id", user.id) .limit(1) console.log("Permission test result:", { permTest, permError }) if (permError) { setSaveMessage(`Permission Error: ${permError.message}`) return } // Test 3: Check existing assessments count const { count, error: countError } = await supabase .from("hva_assessments") .select("*", { count: "exact", head: true }) .eq("user_id", user.id) if (countError) { setSaveMessage(`Count Error: ${countError.message}`) return } setSaveMessage(`Database connection successful! You have ${count || 0} saved assessments.`) setTimeout(() => setSaveMessage(""), 5000) } catch (error) { console.error("Database test error:", error) setSaveMessage("Database connection failed") } } const handleDownloadExcel = async () => { if (!results) return try { setIsGenerating(true) // Use the simple Excel generator const { generateExcel } = await import("@/lib/excel-generator-simple") const blob = generateExcel(results.hazardsWithScores, results) const url = window.URL.createObjectURL(blob) const link = document.createElement("a") link.href = url link.setAttribute("download", `TIPNOW_HVA_Simple_${new Date().toISOString().split("T")[0]}.xlsx`) document.body.appendChild(link) link.click() link.parentNode?.removeChild(link) window.URL.revokeObjectURL(url) } catch (error) { console.error("Error generating Excel:", error) alert("Failed to generate Excel file. Please try again.") } finally { setIsGenerating(false) } } const handleDownloadPDF = async () => { if (!results) return try { setIsGenerating(true) // Use the universal PDF generator const { generatePDF } = await import("@/lib/pdf-generator-universal") const blob = await generatePDF(results.hazardsWithScores, results) const url = window.URL.createObjectURL(blob) const link = document.createElement("a") link.href = url link.setAttribute("download", `TIPNOW_HVA_Report_${new Date().toISOString().split("T")[0]}.pdf`) document.body.appendChild(link) link.click() link.parentNode?.removeChild(link) window.URL.revokeObjectURL(url) } catch (error) { console.error("Error generating PDF:", error) alert("Failed to generate PDF report. Please try again.") } finally { setIsGenerating(false) } } // Generate intelligent analysis based on assessment data const generateAnalysis = () => { if (!results || !results.topRisks || results.topRisks.length === 0) return null const topRisks = results.topRisks.slice(0, 5) const highRisks = topRisks.filter((risk: any) => risk && risk.score >= 25) const mediumRisks = topRisks.filter((risk: any) => risk && risk.score >= 15 && risk.score < 25) const assessedHazards = assessmentData.filter((h) => h.probability > 0) // Categorize hazards by ID ranges (not by category property) const naturalHazards = assessedHazards.filter((h) => h.id < 20) const technologicalHazards = assessedHazards.filter((h) => h.id >= 20 && h.id < 35) const humanHazards = assessedHazards.filter((h) => h.id >= 35) // Safe access to top risk names const getTopRiskName = (index: number) => { return topRisks[index] && topRisks[index].name ? topRisks[index].name : "Unknown Hazard" } const getTopRiskScore = (index: number) => { return topRisks[index] && topRisks[index].score ? topRisks[index].score : 0 } const analysis = { overview: `This Hazard Vulnerability Assessment analyzed ${assessmentData.length} potential hazards, with ${assessedHazards.length} hazards identified as applicable to your facility. The assessment reveals ${highRisks.length} high-risk hazards (score ≥25) and ${mediumRisks.length} medium-risk hazards (score 15-24) that require immediate attention and resource allocation.`, riskProfile: highRisks.length > 0 && highRisks[0] ? `Your facility faces significant risk exposure, with ${getTopRiskName(0)} presenting the highest threat (Risk Score: ${getTopRiskScore(0)}). This indicates a critical need for enhanced preparedness measures and immediate mitigation strategies.` : mediumRisks.length > 0 && topRisks[0] ? `Your facility maintains a moderate risk profile, with ${getTopRiskName(0)} as the primary concern (Risk Score: ${getTopRiskScore(0)}). While no critical threats were identified, continued vigilance and preparedness improvements are recommended.` : "Your facility demonstrates excellent risk management with no high-priority threats identified. Continue maintaining current preparedness standards.", categoryAnalysis: `Risk distribution analysis shows: ${naturalHazards.length} natural hazards, ${technologicalHazards.length} technological hazards, and ${humanHazards.length} human-related hazards are applicable to your facility. ${ naturalHazards.length > technologicalHazards.length && naturalHazards.length > humanHazards.length ? "Natural hazards represent your primary risk category, suggesting the need for weather monitoring systems and environmental preparedness protocols." : technologicalHazards.length > humanHazards.length ? "Technological hazards dominate your risk profile, indicating the importance of infrastructure maintenance and backup systems." : "Human-related hazards are your primary concern, emphasizing the need for security measures and staff training programs." }`, recommendations: [ highRisks.length > 0 && highRisks[0] ? `Immediate Action Required: Develop comprehensive emergency response plans for ${getTopRiskName(0)}, including staff training, resource allocation, and communication protocols.` : "Maintain current preparedness levels and conduct regular drills to ensure readiness.", topRisks.length >= 3 ? `Resource Prioritization: Focus emergency preparedness investments on the top 3 identified risks: ${topRisks .slice(0, 3) .filter((r: any) => r && r.name) .map((r: any) => r.name) .join(", ")}.` : topRisks.length > 0 ? `Resource Prioritization: Focus emergency preparedness investments on ${getTopRiskName(0)}.` : "Resource Prioritization: Continue current resource allocation strategies.", assessedHazards.some((h) => h.preparedness < 2) ? "Preparedness Gap: Several hazards show inadequate preparedness scores. Implement training programs and resource acquisition to address these vulnerabilities." : "Preparedness Strength: Your facility demonstrates good preparedness across assessed hazards. Continue regular updates and training.", "Annual Review: Conduct this assessment annually or after significant operational changes to maintain current risk awareness and preparedness levels.", ], keyFindings: [ topRisks.length > 0 ? `Highest Risk: ${getTopRiskName(0)} (Score: ${getTopRiskScore(0)})` : "No high-risk hazards identified", `Total Applicable Hazards: ${assessedHazards.length} of ${assessmentData.length}`, `Risk Categories: ${naturalHazards.length} Natural, ${technologicalHazards.length} Technological, ${humanHazards.length} Human-Related`, `Assessment Completion: ${((assessedHazards.length / assessmentData.length) * 100).toFixed(0)}% of hazards evaluated`, ], } return analysis } // Calculate progress statistics const totalHazards = assessmentData.length const assessedHazards = assessmentData.filter((h) => h.probability > 0).length const progressPercentage = (assessedHazards / totalHazards) * 100 // Prepare chart data - ensure it's always valid const chartData = results?.topRisks?.length > 0 ? results.topRisks.slice(0, 10).map((risk: any) => ({ name: risk.name.length > 15 ? risk.name.substring(0, 15) + "..." : risk.name, score: Number(risk.score) || 0, fullName: risk.name, })) : [] const analysis = generateAnalysis() return (

{/* Header Section */}

Hazard Vulnerability Assessment

TIPNOW Format - Comprehensive Risk Analysis

{assessedHazards}/{totalHazards}

Hazards Assessed

{/* Instructions Section */} Instructions for Completing the HVA

Important: This HVA tool is a comprehensive risk assessment document. Complete it as it pertains to your specific facility and operational environment.

Assessment Process

Review each hazard category (Natural, Technological, Human-Related)
For each relevant hazard, assess the Probability (0-3 scale)
Enter historical Alerts and Activations data
Evaluate potential Impact across Human, Property, and Business domains
Assess your organization's Response Capability
Click "Calculate Risk Scores" to generate your risk analysis

Scoring Guidelines

Probability Scale:

• 0 (N/A): Not applicable to your facility
• 1 (Low): Unlikely to occur
• 2 (Moderate): Possible occurrence
• 3 (High): Likely to occur

Impact & Response:

Rate from 0 (N/A) to 3 (High/Good) based on potential severity and your preparedness level.

Assessment Considerations

PROBABILITY Factors:

• Known historical risk patterns
• Geographic and environmental factors
• Seasonal or cyclical patterns
• Regional vulnerability assessments
• Expert predictions and forecasts

IMPACT Considerations:

Human: Staff, patient, visitor safety
Property: Replacement and repair costs
Business: Operational disruption
• Revenue loss potential
• Regulatory compliance issues
• Reputation and public image

RESPONSE Capabilities:

Preparedness: Plans, training, drills
Internal: Staff, supplies, resources
External: Community partnerships
• Emergency supply availability
• Backup system functionality
• Communication protocols

Best Practices

• Involve multidisciplinary team members in the assessment process
• Review and update assessments annually or after significant incidents
• Use historical data from the past 10 years when available
• Consider worst-case scenarios during peak operational periods
• Document assumptions and rationale for future reference

{/* Assessment Name Input */} {user && ( Assessment Details

Assessment Name (Optional) setAssessmentName(e.target.value)} className="mt-1" />

Leave blank for auto-generated name. Duplicate names will be automatically numbered.

{results && ( )}

{saveMessage && (

{saveMessage}

)} )} {/* Assessment Form */} Assessment Form {progressPercentage.toFixed(0)}% Complete {/* Stable container to prevent layout shifts */}

{/* Fixed height container for submit button to prevent layout shifts */}

{/* Results Section */} {results && (

{/* Chart Section */}

Top Risk Hazards {chartData.length > 0 ? (

{/* Title */}

Risk Score Visualization

{/* Custom Horizontal Bar Chart */}

{chartData.map((risk: any, index: number) => { const maxScore = Math.max(...chartData.map((r: any) => r.score)) const barWidth = (risk.score / maxScore) * 100 // Color palette matching PDF const colors = [ "bg-red-500", // Red for highest risk "bg-yellow-500", // Yellow/Orange "bg-orange-500", // Orange "bg-yellow-400", // Light Orange "bg-lime-500", // Light Green "bg-green-500", // Green "bg-cyan-500", // Cyan/Blue "bg-blue-500", // Blue "bg-purple-500", // Purple "bg-pink-500", // Pink ] const barColor = colors[index] || "bg-blue-500" return (

{/* Hazard name */}

{risk.name} {risk.score}

{/* Bar */}

{risk.score}

) })}

{/* Legend */}

High Risk (≥25)

Medium Risk (15-24)

Low Risk (<15)

) : (

No Risk Data Available

Complete the assessment and calculate risk scores to view the chart.

)}

{/* Summary Section */}

Assessment Summary {results.topRisks && results.topRisks.length > 0 ? ( <>

Priority Actions Required:

{index + 1} {risk.name} {risk.score}

Resource Priorities:

Emergency response equipment
Staff training programs
Communication systems

Overall Preparedness:

{results.overallPreparedness || "Good"}

) : (

Complete the assessment to view summary

)} {/* Export Section */} {results && results.topRisks && results.topRisks.length > 0 && ( Export Reports )}

)} {/* Risk Analysis & Recommendations Section */} {results && analysis && ( Risk Analysis & Professional Recommendations

{/* Executive Summary */}

Executive Summary

{analysis.overview}

{/* Risk Profile Analysis */}

Risk Profile Analysis

{analysis.riskProfile}

{analysis.categoryAnalysis}

{/* Key Findings */}

Key Findings

{analysis.keyFindings.map((finding, index) => (

{finding}

))}

{/* Professional Recommendations */}

Professional Recommendations

{analysis.recommendations.map((recommendation, index) => (

{recommendation}

))}

{/* Next Steps */}

Recommended Next Steps

Review and validate assessment results with your emergency management team
Prioritize resource allocation based on identified high-risk hazards
Develop or update emergency response plans for top-priority risks
Schedule regular training and drills for identified scenarios
Establish monitoring systems for early warning and detection
Plan for annual reassessment and continuous improvement

)}

) } [V0_FILE]typescriptreact:file="app/history/page.tsx" isEdit="true" isMerged="true" "use client" import { useEffect, useState } from "react" import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" import { Button } from "@/components/ui/button" import { Calendar, FileText, Loader2, Download } from "lucide-react" import { supabase } from "@/lib/supabase" import { useAuth } from "@/contexts/AuthContext" import Link from "next/link" type Assessment = { id: string assessment_name: string created_at: string assessment_data: any results_data: any topHazards: any[] totalAssessed: number } export default function HistoryPage() { const [assessments, setAssessments] = useState([]) const [loading, setLoading] = useState(true) const [isGenerating, setIsGenerating] = useState(null) const { user } = useAuth() const [tableExists, setTableExists] = useState(true) useEffect(() => { if (user) { fetchAssessments() } }, [user]) const fetchAssessments = async () => { if (!user) return try { console.log("Fetching assessments for user:", user.id) const { data, error } = await supabase .from("hva_assessments") .select("*") .eq("user_id", user.id) .order("created_at", { ascending: false }) .limit(5) // Get only the most recent 5 assessments if (error) { console.error("Error fetching assessments:", error) if (error.message.includes("does not exist")) { setTableExists(false) } } else { console.log("Fetched assessments:", data) // Process individual assessments (no grouping by date) const processedAssessments = data?.map((assessment: any) => { // Safely access nested data const topRisks = assessment.results_data?.topRisks || [] const hazardsWithScores = assessment.results_data?.hazardsWithScores || [] return { id: assessment.id, assessment_name: assessment.assessment_name, created_at: assessment.created_at, assessment_data: assessment.assessment_data, results_data: assessment.results_data, // Get top 3 hazards for preview topHazards: topRisks.slice(0, 3), totalAssessed: hazardsWithScores.filter((h: any) => h.score > 0).length, } }) || [] console.log("Processed assessments:", processedAssessments) setAssessments(processedAssessments) setTableExists(true) } } catch (error) { console.error("Unexpected error:", error) setTableExists(false) } finally { setLoading(false) } } const deleteAssessment = async (id: string) => { if (!confirm("Are you sure you want to delete this assessment?")) return try { const { error } = await supabase.from("hva_assessments").delete().eq("id", id) if (error) { console.error("Error deleting assessment:", error) alert("Failed to delete assessment") } else { setAssessments(assessments.filter((a) => a.id !== id)) } } catch (error) { console.error("Error:", error) alert("Failed to delete assessment") } } const downloadExcel = async (assessment: Assessment) => { setIsGenerating(assessment.id) try { const { generateExcel } = await import("@/lib/excel-generator-simple") const blob = generateExcel(assessment.results_data.hazardsWithScores, assessment.results_data) const url = window.URL.createObjectURL(blob) const link = document.createElement("a") link.href = url link.setAttribute( "download", `${assessment.assessment_name}_${new Date(assessment.created_at).toISOString().split("T")[0]}.xlsx`, ) document.body.appendChild(link) link.click() link.parentNode?.removeChild(link) window.URL.revokeObjectURL(url) } catch (error) { console.error("Error generating Excel:", error) alert("Failed to generate Excel file") } finally { setIsGenerating(null) } } const downloadPDF = async (assessment: Assessment) => { setIsGenerating(assessment.id) try { console.log("Downloading PDF for assessment:", assessment.assessment_name) // Use the universal PDF generator that handles different data formats const { generatePDF } = await import("@/lib/pdf-generator-universal") // Pass the entire assessment object to the universal generator const blob = await generatePDF(assessment) if (!blob || blob.size === 0) { throw new Error("Generated PDF is empty") } const url = window.URL.createObjectURL(blob) const link = document.createElement("a") link.href = url // Create safe filename const safeName = assessment.assessment_name.replace(/[^a-zA-Z0-9]/g, "_") const dateStr = new Date(assessment.created_at).toISOString().split("T")[0] link.setAttribute("download", `${safeName}_${dateStr}.pdf`) document.body.appendChild(link) link.click() link.parentNode?.removeChild(link) window.URL.revokeObjectURL(url) } catch (error) { console.error("Error generating PDF:", error) alert(`Failed to generate PDF: ${error instanceof Error ? error.message : "Unknown error"}`) } finally { setIsGenerating(null) } } if (!user) { return

Please log in to view your assessment history.

} if (loading) { return (

Assessment History

) } return (

Assessment History

View and manage your previous HVA assessments

{assessments.length === 0 ? (

No assessments yet

Create your first assessment to see it here.

) : (

{assessments.map((assessment) => ( {assessment.assessment_name}

{new Date(assessment.created_at).toLocaleDateString("en-US", { year: "numeric", month: "short", day: "numeric", hour: "2-digit", minute: "2-digit", })}

Hazards Assessed: {assessment.totalAssessed}

{assessment.topHazards.length > 0 && (

Top Risks: {assessment.topHazards.map((hazard: any, index: number) => (

{index + 1}. {hazard.name} = 25 ? "destructive" : hazard.score >= 15 ? "default" : "secondary"} className="text-xs" > {hazard.score}

))}

)}

))}

)}

) } [V0_FILE]typescriptreact:file="components/LoginForm.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { useRouter } from "next/navigation" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs" import { useAuth } from "@/contexts/AuthContext" import { Loader2, Shield, ArrowLeft } from "lucide-react" import { supabase } from "@/lib/supabase" export function LoginForm() { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [loading, setLoading] = useState(false) const [message, setMessage] = useState("") const [showForgotPassword, setShowForgotPassword] = useState(false) const [forgotPasswordEmail, setForgotPasswordEmail] = useState("") const [forgotPasswordLoading, setForgotPasswordLoading] = useState(false) const [forgotPasswordMessage, setForgotPasswordMessage] = useState("") const { signIn, signUp } = useAuth() const router = useRouter() const handleSignIn = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signIn(email, password) if (error) { setMessage(error.message) } else { router.push("/dashboard") } setLoading(false) } const handleSignUp = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signUp(email, password) if (error) { // Check if it's a duplicate email error and show the specific message if ( error.message.includes("already registered") || error.message.includes("already exists") || error.message.includes("User already registered") || error.message.includes("duplicate") ) { setMessage("This email is already registered. Try signing in or resetting your password.") } else { setMessage(error.message) } } else { setMessage("Check your email for the confirmation link!") } setLoading(false) } const handleForgotPassword = async (e: React.FormEvent) => { e.preventDefault() setForgotPasswordLoading(true) setForgotPasswordMessage("") try { const { error } = await supabase.auth.resetPasswordForEmail(forgotPasswordEmail, { redirectTo: `${window.location.origin}/reset-password`, }) if (error) { setForgotPasswordMessage(error.message) } else { setForgotPasswordMessage("Password reset email sent! Check your inbox.") } } catch (error) { setForgotPasswordMessage("An error occurred. Please try again.") } setForgotPasswordLoading(false) } const resetForgotPasswordForm = () => { setShowForgotPassword(false) setForgotPasswordEmail("") setForgotPasswordMessage("") setForgotPasswordLoading(false) } if (showForgotPassword) { return (

Reset Password Enter your email to receive a password reset link {forgotPasswordMessage && (

{forgotPasswordMessage}

)}

) } return (

TIPNOW HVA Sign in to access your Hazard Vulnerability Assessments Sign In Sign Up {message && (

{message}

)}

) } [V0_FILE]typescriptreact:file="lib/auth.ts" isEdit="true" isMerged="true" import { supabase } from "./supabase" // Function to check if email already exists export const checkEmailExists = async (email: string): Promise => { try { // Try to sign in with a dummy password to check if email exists const { error } = await supabase.auth.signInWithPassword({ email: email.toLowerCase().trim(), password: "dummy_password_check_12345", }) // If error is about invalid credentials, email exists if (error && error.message.includes("Invalid login credentials")) { return true } // If error is about email not confirmed, email exists if (error && error.message.includes("Email not confirmed")) { return true } // If no error or different error, email might not exist return false } catch (error) { console.error("Error checking email:", error) return false } } export const signUp = async (email: string, password: string) => { // Normalize email const normalizedEmail = email.toLowerCase().trim() // First, check if email already exists const emailExists = await checkEmailExists(normalizedEmail) if (emailExists) { return { data: null, error: { message: "This email is already registered. Try signing in or resetting your password." }, } } // Proceed with signup if email doesn't exist const { data, error } = await supabase.auth.signUp({ email: normalizedEmail, password, }) // Double-check for any Supabase duplicate email errors if (error) { if ( error.message.includes("already registered") || error.message.includes("already exists") || error.message.includes("User already registered") || error.message.includes("duplicate") ) { return { data: null, error: { message: "This email is already registered. Try signing in or resetting your password." }, } } } return { data, error } } export const signIn = async (email: string, password: string) => { const { data, error } = await supabase.auth.signInWithPassword({ email: email.toLowerCase().trim(), password, }) if (data.user) { localStorage.setItem("user_id", data.user.id) sessionStorage.setItem("user_id", data.user.id) } return { data, error } } export const signOut = async () => { const { error } = await supabase.auth.signOut() localStorage.removeItem("user_id") sessionStorage.removeItem("user_id") return { error } } export const getCurrentUser = () => { return supabase.auth.getUser() } export const getStoredUserId = () => { return localStorage.getItem("user_id") || sessionStorage.getItem("user_id") } [V0_FILE]typescriptreact:file="components/AuthForm.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { useState } from "react" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs" import { signIn, signUp } from "@/lib/auth" import { Shield, Loader2 } from "lucide-react" import { supabase } from "@/lib/supabase" interface AuthFormProps { onAuthSuccess: () => void } export function AuthForm({ onAuthSuccess }: AuthFormProps) { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [loading, setLoading] = useState(false) const [message, setMessage] = useState("") const handleSignIn = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signIn(email, password) if (error) { setMessage(error.message) } else { onAuthSuccess() } setLoading(false) } const handleSignUp = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signUp(email, password) if (error) { setMessage(error.message) } else { setMessage("Check your email for the confirmation link!") } setLoading(false) } const handleForgotPassword = async () => { // Check if email is entered and valid const emailRegex = /^[^\s@]+@[^\s@]+\.[^\s@]+$/ if (!email || !emailRegex.test(email)) { alert("Please enter your email first.") return } try { const { error } = await supabase.auth.resetPasswordForEmail(email) if (error) { alert("Something went wrong. Try again.") } else { alert("Password reset email sent! Check your inbox.") } } catch (error) { alert("Something went wrong. Try again.") } } return (

TIPNOW HVA Sign in to access your Hazard Vulnerability Assessments Sign In Sign Up {message && (

{message}

)}

) } [V0_FILE]typescriptreact:file="app/login/page.tsx" isEdit="true" isMerged="true" "use client" import type React from "react" import { useState, useEffect } from "react" import { useRouter } from "next/navigation" import { Button } from "@/components/ui/button" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs" import { useAuth } from "@/contexts/AuthContext" import { Loader2, Shield } from "lucide-react" import { supabase } from "@/lib/supabase" export default function LoginPage() { const [email, setEmail] = useState("") const [password, setPassword] = useState("") const [loading, setLoading] = useState(false) const [message, setMessage] = useState("") const [currentTab, setCurrentTab] = useState("signin") const { signIn, signUp } = useAuth() const router = useRouter() // Clear error message when switching to sign in tab useEffect(() => { if (currentTab === "signin" && message.includes("already registered")) { setMessage("") } }, [currentTab, message]) const handleSignIn = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signIn(email, password) if (error) { setMessage(error.message) } else { router.push("/dashboard") } setLoading(false) } const handleSignUp = async (e: React.FormEvent) => { e.preventDefault() setLoading(true) setMessage("") const { error } = await signUp(email, password) if (error) { // Check if it's a duplicate email error and show the specific message if ( error.message.includes("already registered") || error.message.includes("already exists") || error.message.includes("User already registered") || error.message.includes("duplicate") ) { setMessage("This email is already registered. Please sign in instead.") } else { setMessage(error.message) } } else { setMessage("Check your email for the confirmation link!") } setLoading(false) } const handleForgotPassword = async () => { if (!email) { alert("Please enter your email first.") return } try { const { error } = await supabase.auth.resetPasswordForEmail(email, { redirectTo: `${window.location.origin}/reset-password`, }) if (error) { alert("Something went wrong. Try again.") } else { alert("Password reset email sent! Check your inbox.") } } catch (error) { alert("Something went wrong. Try again.") } } return (

TIPNOW HVA Sign in to access your Hazard Vulnerability Assessments Sign In Sign Up {message && (

{message}

)}

) } [V0_FILE]typescriptreact:file="lib/pdf-generator-universal.ts" isEdit="true" import { jsPDF } from "jspdf" import "jspdf-autotable" import type { UserOptions } from "jspdf-autotable" declare module "jspdf" { interface jsPDF { autoTable: (options: UserOptions) => jsPDF } } // Universal data normalizer to handle different data structures function normalizeAssessmentData(rawData: any): { assessmentData: any[] results: any hazardsWithScores: any[] topRisks: any[] } { try { // Handle case where rawData is the results object directly if (rawData && rawData.hazardsWithScores && rawData.topRisks) { return { assessmentData: rawData.hazardsWithScores || [], results: rawData, hazardsWithScores: rawData.hazardsWithScores || [], topRisks: rawData.topRisks || [], } } // Handle case where we have separate assessment_data and results_data if (rawData && rawData.assessment_data && rawData.results_data) { return { assessmentData: Array.isArray(rawData.assessment_data) ? rawData.assessment_data : [], results: rawData.results_data || {}, hazardsWithScores: rawData.results_data?.hazardsWithScores || [], topRisks: rawData.results_data?.topRisks || [], } } // Handle case where rawData is an array (assessment data) if (Array.isArray(rawData)) { return { assessmentData: rawData, results: {}, hazardsWithScores: rawData.filter((h) => h && typeof h.score === "number" && h.score > 0), topRisks: [], } } // Fallback for unknown structure return { assessmentData: [], results: {}, hazardsWithScores: [], topRisks: [], } } catch (error) { console.warn("Error normalizing data:", error) return { assessmentData: [], results: {}, hazardsWithScores: [], topRisks: [], } } } // Safe text rendering function function safeText(doc: jsPDF, text: any, x: number, y: number, options?: any): number { try { const safeTextValue = String(text || "").trim() const safeX = Number(x) || 20 const safeY = Number(y) || 20 if (safeTextValue.length > 0 && safeX >= 0 && safeY >= 0) { doc.text(safeTextValue, safeX, safeY, options) } return safeY + 7 } catch (error) { console.warn("Text rendering error:", error) return y + 7 } } // Safe number extraction function safeNumber(value: any, defaultValue = 0): number { const num = Number(value) return isNaN(num) ? defaultValue : num } // Safe string extraction function safeString(value: any, maxLength = 50): string { return String(value || "").substring(0, maxLength) } // Get user-friendly risk level description function getRiskLevelDescription(score: number): { level: string; description: string } { if (score >= 25) { return { level: "Critical Risk", description: "Requires immediate attention and action" } } else if (score >= 15) { return { level: "Moderate Risk", description: "Needs monitoring and planning" } } else { return { level: "Low Risk", description: "Routine monitoring sufficient" } } } // Categorize hazards by type function categorizeHazards(hazards: any[]): { natural: number; technological: number; human: number } { const categories = { natural: 0, technological: 0, human: 0 } hazards.forEach((hazard) => { const name = safeString(hazard?.name || "", 50).toLowerCase() // Natural hazards if ( name.includes("tornado") || name.includes("hurricane") || name.includes("flood") || name.includes("earthquake") || name.includes("wildfire") || name.includes("storm") || name.includes("drought") || name.includes("heat") || name.includes("cold") || name.includes("landslide") || name.includes("avalanche") || name.includes("lightning") ) { categories.natural++ } // Technological hazards else if ( name.includes("chemical") || name.includes("nuclear") || name.includes("cyber") || name.includes("power") || name.includes("infrastructure") || name.includes("transport") || name.includes("industrial") || name.includes("explosion") || name.includes("fire") ) { categories.technological++ } // Human-related hazards else if ( name.includes("terrorism") || name.includes("violence") || name.includes("civil") || name.includes("pandemic") || name.includes("disease") || name.includes("contamination") ) { categories.human++ } // Default to natural if unclear else { categories.natural++ } }) return categories } // Color scheme for risk levels const COLORS = { high: [220, 53, 69], // Red medium: [255, 193, 7], // Yellow/Orange low: [40, 167, 69], // Green primary: [13, 110, 253], // Blue secondary: [108, 117, 125], // Gray background: [248, 249, 250], // Light gray white: [255, 255, 255], dark: [33, 37, 41], } // Draw colored rectangle function drawColoredRect(doc: jsPDF, x: number, y: number, width: number, height: number, color: number[]) { try { doc.setFillColor(color[0], color[1], color[2]) doc.rect(x, y, width, height, "F") } catch (error) { console.warn("Rectangle drawing error:", error) } } // Draw metric box with improved formatting function drawMetricBox( doc: jsPDF, x: number, y: number, width: number, height: number, title: string, value: string, color: number[], ) { try { // Background with subtle shadow effect doc.setFillColor(245, 245, 245) doc.rect(x + 1, y + 1, width, height, "F") // Main background doc.setFillColor(255, 255, 255) doc.rect(x, y, width, height, "F") // Border doc.setDrawColor(color[0], color[1], color[2]) doc.setLineWidth(1.5) doc.rect(x, y, width, height) // Title bar drawColoredRect(doc, x, y, width, 15, color) // Title text doc.setTextColor(255, 255, 255) doc.setFontSize(9) doc.setFont("helvetica", "bold") doc.text(title, x + width / 2, y + 10, { align: "center" }) // Value text doc.setTextColor(color[0], color[1], color[2]) doc.setFontSize(20) doc.setFont("helvetica", "bold") doc.text(value, x + width / 2, y + height / 2 + 8, { align: "center" }) doc.setTextColor(0, 0, 0) // Reset color } catch (error) { console.warn("Metric box drawing error:", error) } } // Draw professional bar chart with fixed positioning function drawBarChart(doc: jsPDF, x: number, y: number, width: number, data: any[]) { try { const maxValue = Math.max(...data.map((d) => safeNumber(d.value, 0))) if (maxValue === 0) return y + 20 const barHeight = 14 const spacing = 10 let currentY = y data.forEach((item, index) => { const barWidth = (safeNumber(item.value, 0) / maxValue) * (width - 140) const color = item.color || COLORS.primary const score = safeNumber(item.value, 0) // Bar background (full width) doc.setFillColor(240, 240, 240) doc.rect(x + 110, currentY, width - 140, barHeight, "F") // Main bar (proportional width) doc.setFillColor(color[0], color[1], color[2]) doc.rect(x + 110, currentY, barWidth, barHeight, "F") // Bar border doc.setDrawColor(200, 200, 200) doc.setLineWidth(0.5) doc.rect(x + 110, currentY, width - 140, barHeight) // Hazard name (left side) doc.setTextColor(0, 0, 0) doc.setFontSize(10) doc.setFont("helvetica", "normal") doc.text(safeString(item.name, 25), x, currentY + 9) // Score value (right side, outside the bar to avoid overlap) doc.setFont("helvetica", "bold") doc.setFontSize(11) doc.text(String(score), x + width - 25, currentY + 9) currentY += barHeight + spacing }) return currentY + 10 } catch (error) { console.warn("Bar chart drawing error:", error) return y + 100 } } // Draw clean risk distribution chart function drawRiskDistributionChart(doc: jsPDF, x: number, y: number, width: number, data: any[]) { try { const total = data.reduce((sum, item) => sum + safeNumber(item.value, 0), 0) if (total === 0) return y + 60 const chartHeight = 30 let currentX = x // Draw proportional segments data.forEach((item, index) => { const value = safeNumber(item.value, 0) const segmentWidth = (value / total) * width const color = item.color || COLORS.primary // Draw segment doc.setFillColor(color[0], color[1], color[2]) doc.rect(currentX, y, segmentWidth, chartHeight, "F") // Segment border doc.setDrawColor(255, 255, 255) doc.setLineWidth(2) doc.rect(currentX, y, segmentWidth, chartHeight) // Percentage label on segment if wide enough if (segmentWidth > 25) { doc.setTextColor(255, 255, 255) doc.setFontSize(10) doc.setFont("helvetica", "bold") const percentage = ((value / total) * 100).toFixed(0) doc.text(`${percentage}%`, currentX + segmentWidth / 2, y + chartHeight / 2 + 3, { align: "center" }) } currentX += segmentWidth }) // Legend below chart let legendY = y + chartHeight + 15 const legendX = x data.forEach((item, index) => { const color = item.color || COLORS.primary const value = safeNumber(item.value, 0) const percentage = ((value / total) * 100).toFixed(1) // Legend color box doc.setFillColor(color[0], color[1], color[2]) doc.rect(legendX, legendY, 10, 8, "F") // Legend border doc.setDrawColor(200, 200, 200) doc.setLineWidth(0.5) doc.rect(legendX, legendY, 10, 8) // Legend text with user-friendly description doc.setTextColor(0, 0, 0) doc.setFontSize(9) doc.setFont("helvetica", "normal") doc.text(`${item.name}: ${value} (${percentage}%)`, legendX + 15, legendY + 6) legendY += 12 }) return legendY + 10 } catch (error) { console.warn("Risk distribution chart error:", error) return y + 80 } } export async function generatePDF(inputData: any, inputResults?: any): Promise { try { console.log("PDF Generator - Input data:", { inputData, inputResults }) // Normalize the data regardless of input format let normalizedData if (inputResults) { // Called from main assessment (two parameters) normalizedData = normalizeAssessmentData({ assessment_data: inputData, results_data: inputResults, }) } else { // Called from history (one parameter that contains everything) normalizedData = normalizeAssessmentData(inputData) } console.log("PDF Generator - Normalized data:", normalizedData) const { assessmentData, results, hazardsWithScores, topRisks } = normalizedData const doc = new jsPDF() const pageWidth = doc.internal.pageSize.width const pageHeight = doc.internal.pageSize.height let yPos = 20 // Helper function for page breaks const checkPageBreak = (requiredSpace = 20) => { if (yPos + requiredSpace > pageHeight - 20) { doc.addPage() yPos = 20 } } // Calculate comprehensive statistics const totalHazards = Array.isArray(assessmentData) ? assessmentData.length : 0 const assessedHazards = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && safeNumber(h.score) > 0).length : 0 const highRiskCount = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && safeNumber(h.score) >= 25).length : 0 const mediumRiskCount = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && safeNumber(h.score) >= 15 && safeNumber(h.score) < 25).length : 0 const lowRiskCount = Array.isArray(hazardsWithScores) ? hazardsWithScores.filter((h) => h && safeNumber(h.score) > 0 && safeNumber(h.score) < 15).length : 0 // Categorize hazards const hazardCategories = categorizeHazards(hazardsWithScores) // Get highest risk hazard const highestRisk = Array.isArray(topRisks) && topRisks.length > 0 ? topRisks[0] : hazardsWithScores.reduce( (max, hazard) => (safeNumber(hazard?.score) > safeNumber(max?.score) ? hazard : max), { name: "None", score: 0 }, ) // Calculate completion rate const completionRate = totalHazards > 0 ? ((assessedHazards / totalHazards) * 100).toFixed(0) : "0" // ==================== COVER PAGE ==================== // Header banner drawColoredRect(doc, 0, 0, pageWidth, 50, COLORS.primary) // Title doc.setTextColor(255, 255, 255) doc.setFontSize(24) doc.setFont("helvetica", "bold") doc.text("TIPNOW HVA", pageWidth / 2, 20, { align: "center" }) doc.setFontSize(14) doc.setFont("helvetica", "normal") doc.text("Emergency Management Report", pageWidth / 2, 35, { align: "center" }) // Reset colors and position doc.setTextColor(0, 0, 0) yPos = 70 // Report info doc.setFontSize(16) doc.setFont("helvetica", "bold") doc.text("Hazard Vulnerability Assessment", 20, yPos) yPos += 15 doc.setFontSize(11) doc.setFont("helvetica", "normal") const currentDate = new Date().toLocaleDateString("en-US", { year: "numeric", month: "long", day: "numeric", }) doc.text(`Assessment Date: ${currentDate}`, 20, yPos) yPos += 8 doc.text(`Report Generated: ${new Date().toLocaleString()}`, 20, yPos) yPos += 25 // Quick overview doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Assessment Overview", 20, yPos) yPos += 12 doc.setFontSize(10) doc.setFont("helvetica", "normal") doc.text(`Total Hazards Identified: ${totalHazards}`, 25, yPos) yPos += 8 doc.text(`Hazards Assessed: ${assessedHazards}`, 25, yPos) yPos += 8 doc.text(`Critical Risk Hazards: ${highRiskCount}`, 25, yPos) yPos += 8 doc.text(`Moderate Risk Hazards: ${mediumRiskCount}`, 25, yPos) yPos += 8 doc.text(`Low Risk Hazards: ${lowRiskCount}`, 25, yPos) // ==================== EXECUTIVE SUMMARY (PAGE 2) ==================== doc.addPage() yPos = 20 // Page header drawColoredRect(doc, 0, 0, pageWidth, 20, COLORS.primary) doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Executive Summary", 20, 13) doc.setTextColor(0, 0, 0) yPos = 35 // Executive summary text doc.setFontSize(11) doc.setFont("helvetica", "normal") const summaryText = `This Hazard Vulnerability Assessment analyzed ${totalHazards} potential hazards, with ${assessedHazards} hazards identified as applicable to your facility. The assessment reveals ${highRiskCount} critical risk hazard(s) and ${mediumRiskCount} moderate risk hazard(s) that require immediate attention and resource allocation.` // Split text into lines to fit page width const lines = doc.splitTextToSize(summaryText, pageWidth - 40) lines.forEach((line: string) => { doc.text(line, 20, yPos) yPos += 6 }) yPos += 10 // Metric boxes in clean 2x3 grid with user-friendly labels const boxWidth = 80 const boxHeight = 40 const spacing = 15 // Row 1 drawMetricBox(doc, 20, yPos, boxWidth, boxHeight, "Total Hazards", String(totalHazards), COLORS.primary) drawMetricBox( doc, 20 + boxWidth + spacing, yPos, boxWidth, boxHeight, "Assessed", String(assessedHazards), COLORS.secondary, ) // Row 2 yPos += boxHeight + spacing drawMetricBox(doc, 20, yPos, boxWidth, boxHeight, "Critical Risk", String(highRiskCount), COLORS.high) drawMetricBox( doc, 20 + boxWidth + spacing, yPos, boxWidth, boxHeight, "Moderate Risk", String(mediumRiskCount), COLORS.medium, ) // Row 3 yPos += boxHeight + spacing drawMetricBox(doc, 20, yPos, boxWidth, boxHeight, "Low Risk", String(lowRiskCount), COLORS.low) yPos += boxHeight + 25 // Risk level explanation doc.setFontSize(12) doc.setFont("helvetica", "bold") doc.text("Risk Level Guide", 20, yPos) yPos += 12 doc.setFontSize(10) doc.setFont("helvetica", "normal") doc.text("• Critical Risk (Score 25+): Requires immediate attention and action", 25, yPos) yPos += 8 doc.text("• Moderate Risk (Score 15-24): Needs monitoring and planning", 25, yPos) yPos += 8 doc.text("• Low Risk (Score below 15): Routine monitoring sufficient", 25, yPos) // ==================== RISK PROFILE ANALYSIS (PAGE 3) ==================== doc.addPage() yPos = 20 // Page header drawColoredRect(doc, 0, 0, pageWidth, 20, COLORS.primary) doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Risk Profile Analysis", 20, 13) doc.setTextColor(0, 0, 0) yPos = 35 // Risk profile analysis text doc.setFontSize(11) doc.setFont("helvetica", "normal") if (highestRisk && safeNumber(highestRisk.score) > 0) { const riskProfileText = `Your facility faces significant risk exposure, with ${safeString(highestRisk.name, 30)} presenting the highest threat (Risk Score: ${safeNumber(highestRisk.score)}). This indicates a critical need for enhanced preparedness measures and immediate mitigation strategies.` const riskLines = doc.splitTextToSize(riskProfileText, pageWidth - 40) riskLines.forEach((line: string) => { doc.text(line, 20, yPos) yPos += 6 }) yPos += 10 } const categoryText = `Risk distribution analysis shows: ${hazardCategories.natural} natural hazards, ${hazardCategories.technological} technological hazards, and ${hazardCategories.human} human-related hazards are applicable to your facility. ${hazardCategories.natural > 0 ? "Natural hazards represent your primary risk category, suggesting the need for weather monitoring systems and environmental preparedness protocols." : ""}` const categoryLines = doc.splitTextToSize(categoryText, pageWidth - 40) categoryLines.forEach((line: string) => { doc.text(line, 20, yPos) yPos += 6 }) yPos += 15 // Key Findings section doc.setFontSize(12) doc.setFont("helvetica", "bold") doc.text("Key Findings", 20, yPos) yPos += 12 doc.setFontSize(10) doc.setFont("helvetica", "normal") if (highestRisk && safeNumber(highestRisk.score) > 0) { doc.text(`Highest Risk: ${safeString(highestRisk.name, 30)} (Score: ${safeNumber(highestRisk.score)})`, 25, yPos) yPos += 8 } doc.text(`Total Applicable Hazards: ${assessedHazards} of ${totalHazards}`, 25, yPos) yPos += 8 doc.text( `Risk Categories: ${hazardCategories.natural} Natural, ${hazardCategories.technological} Technological, ${hazardCategories.human} Human-Related`, 25, yPos, ) yPos += 8 doc.text(`Assessment Completion: ${completionRate}% of hazards evaluated`, 25, yPos) yPos += 15 // Risk distribution data with user-friendly names const riskData = [ { name: "Critical Risk", value: highRiskCount, color: COLORS.high }, { name: "Moderate Risk", value: mediumRiskCount, color: COLORS.medium }, { name: "Low Risk", value: lowRiskCount, color: COLORS.low }, ].filter((item) => item.value > 0) if (riskData.length > 0) { doc.setFontSize(12) doc.setFont("helvetica", "bold") doc.text("Risk Level Distribution", 20, yPos) yPos += 15 // Draw clean distribution chart yPos = drawRiskDistributionChart(doc, 20, yPos, pageWidth - 40, riskData) yPos += 15 // Summary table doc.setFontSize(12) doc.setFont("helvetica", "bold") doc.text("Risk Summary", 20, yPos) yPos += 15 try { const riskTableData = riskData.map((item) => { const percentage = assessedHazards > 0 ? ((item.value / assessedHazards) * 100).toFixed(1) : "0.0" return [ item.name, String(item.value), `${percentage}%`, item.value === highRiskCount ? "Immediate Action Required" : item.value === mediumRiskCount ? "Monitor & Plan" : "Routine Monitoring", ] }) doc.autoTable({ head: [["Risk Level", "Count", "Percentage", "Recommended Action"]], body: riskTableData, startY: yPos, theme: "grid", headStyles: { fillColor: COLORS.primary, textColor: [255, 255, 255], fontSize: 10, fontStyle: "bold", }, bodyStyles: { fontSize: 9, }, columnStyles: { 0: { cellWidth: 45, halign: "left" }, 1: { cellWidth: 20, halign: "center" }, 2: { cellWidth: 25, halign: "center" }, 3: { cellWidth: 70, halign: "left" }, }, margin: { left: 20, right: 20 }, }) yPos = (doc as any).lastAutoTable?.finalY + 20 || yPos + 60 } catch (error) { console.warn("Risk table error:", error) yPos += 40 } } // ==================== TOP PRIORITY RISKS (PAGE 4) ==================== if (Array.isArray(topRisks) && topRisks.length > 0) { doc.addPage() yPos = 20 // Page header drawColoredRect(doc, 0, 0, pageWidth, 20, COLORS.high) doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Top Priority Risks", 20, 13) doc.setTextColor(0, 0, 0) yPos = 35 // Top risks chart const topRisksData = topRisks.slice(0, 8).map((risk) => ({ name: safeString(risk?.name, 25), value: safeNumber(risk?.score), color: safeNumber(risk?.score) >= 25 ? COLORS.high : safeNumber(risk?.score) >= 15 ? COLORS.medium : COLORS.low, })) doc.setFontSize(12) doc.setFont("helvetica", "bold") doc.text("Risk Ranking", 20, yPos) yPos += 15 yPos = drawBarChart(doc, 20, yPos, pageWidth - 40, topRisksData) yPos += 15 // Detailed table checkPageBreak(80) doc.setFontSize(12) doc.setFont("helvetica", "bold") doc.text("Detailed Risk Assessment", 20, yPos) yPos += 15 const topRisksTableData = topRisks.slice(0, 8).map((risk, index) => { const safeName = safeString(risk?.name, 30) const safeScore = safeNumber(risk?.score) const riskLevel = getRiskLevelDescription(safeScore) const probability = safeNumber(risk?.probability) const maxImpact = Math.max( safeNumber(risk?.humanImpact), safeNumber(risk?.propertyImpact), safeNumber(risk?.businessImpact), ) return [String(index + 1), safeName, String(probability), String(maxImpact), String(safeScore), riskLevel.level] }) if (topRisksTableData.length > 0) { try { doc.autoTable({ head: [["Rank", "Hazard Name", "Probability", "Max Impact", "Risk Score", "Risk Level"]], body: topRisksTableData, startY: yPos, theme: "striped", headStyles: { fillColor: COLORS.high, textColor: [255, 255, 255], fontSize: 9, fontStyle: "bold", }, bodyStyles: { fontSize: 8, }, alternateRowStyles: { fillColor: [248, 249, 250], }, columnStyles: { 0: { cellWidth: 15, halign: "center" }, 1: { cellWidth: 60, halign: "left" }, 2: { cellWidth: 25, halign: "center" }, 3: { cellWidth: 25, halign: "center" }, 4: { cellWidth: 25, halign: "center" }, 5: { cellWidth: 30, halign: "center" }, }, margin: { left: 20, right: 20 }, }) yPos = (doc as any).lastAutoTable?.finalY + 15 || yPos + 100 } catch (tableError) { console.warn("Top risks table failed:", tableError) yPos += 60 } } } // ==================== COMPREHENSIVE ASSESSMENT DATA (PAGE 5+) ==================== if (Array.isArray(hazardsWithScores) && hazardsWithScores.length > 0) { doc.addPage() yPos = 20 // Page header drawColoredRect(doc, 0, 0, pageWidth, 20, COLORS.primary) doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Comprehensive Assessment Data", 20, 13) doc.setTextColor(0, 0, 0) yPos = 35 // Filter and prepare detailed data const detailedData = hazardsWithScores .filter((item) => item && safeNumber(item.score) > 0) .map((item, index) => { const riskLevel = getRiskLevelDescription(safeNumber(item.score)) return [ String(index + 1), safeString(item.name, 25), String(safeNumber(item.probability)), String(safeNumber(item.humanImpact)), String(safeNumber(item.propertyImpact)), String(safeNumber(item.businessImpact)), String(safeNumber(item.score)), riskLevel.level.replace(" Risk", ""), ] }) if (detailedData.length > 0) { try { doc.autoTable({ head: [["#", "Hazard Name", "Prob", "Human", "Property", "Business", "Score", "Risk Level"]], body: detailedData, startY: yPos, theme: "striped", headStyles: { fillColor: COLORS.primary, textColor: [255, 255, 255], fontSize: 9, fontStyle: "bold", }, bodyStyles: { fontSize: 8, }, alternateRowStyles: { fillColor: [248, 249, 250], }, columnStyles: { 0: { cellWidth: 12, halign: "center" }, 1: { cellWidth: 45, halign: "left" }, 2: { cellWidth: 18, halign: "center" }, 3: { cellWidth: 18, halign: "center" }, 4: { cellWidth: 20, halign: "center" }, 5: { cellWidth: 20, halign: "center" }, 6: { cellWidth: 18, halign: "center" }, 7: { cellWidth: 23, halign: "center" }, }, margin: { left: 20, right: 20 }, }) yPos = (doc as any).lastAutoTable?.finalY + 15 || yPos + 100 } catch (detailedTableError) { console.warn("Detailed table failed:", detailedTableError) yPos += 100 } } } // ==================== PROFESSIONAL RECOMMENDATIONS (PAGE 6) ==================== doc.addPage() yPos = 20 // Page header drawColoredRect(doc, 0, 0, pageWidth, 20, COLORS.secondary) doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Professional Recommendations", 20, 13) doc.setTextColor(0, 0, 0) yPos = 35 doc.setFontSize(10) doc.setFont("helvetica", "normal") // Immediate Action Required if (highRiskCount > 0 && highestRisk && safeNumber(highestRisk.score) >= 25) { doc.setFont("helvetica", "bold") doc.text("Immediate Action Required:", 20, yPos) yPos += 8 doc.setFont("helvetica", "normal") const actionText = `Develop comprehensive emergency response plans for ${safeString(highestRisk.name, 30)}, including staff training, resource allocation, and communication protocols.` const actionLines = doc.splitTextToSize(actionText, pageWidth - 40) actionLines.forEach((line: string) => { doc.text(line, 25, yPos) yPos += 6 }) yPos += 10 } // Resource Prioritization if (topRisks && topRisks.length > 0) { doc.setFont("helvetica", "bold") doc.text("Resource Prioritization:", 20, yPos) yPos += 8 doc.setFont("helvetica", "normal") const top3Risks = topRisks .slice(0, 3) .map((r) => safeString(r?.name, 20)) .join(", ") const priorityText = `Focus emergency preparedness investments on the top 3 identified risks: ${top3Risks}.` const priorityLines = doc.splitTextToSize(priorityText, pageWidth - 40) priorityLines.forEach((line: string) => { doc.text(line, 25, yPos) yPos += 6 }) yPos += 10 } // Preparedness Gap if (assessedHazards < totalHazards) { doc.setFont("helvetica", "bold") doc.text("Preparedness Gap:", 20, yPos) yPos += 8 doc.setFont("helvetica", "normal") const gapText = `Several hazards show inadequate preparedness scores. Implement training programs and resource acquisition to address these vulnerabilities.` const gapLines = doc.splitTextToSize(gapText, pageWidth - 40) gapLines.forEach((line: string) => { doc.text(line, 25, yPos) yPos += 6 }) yPos += 10 } // Annual Review doc.setFont("helvetica", "bold") doc.text("Annual Review:", 20, yPos) yPos += 8 doc.setFont("helvetica", "normal") const reviewText = `Conduct this assessment annually or after significant operational changes to maintain current risk awareness and preparedness levels.` const reviewLines = doc.splitTextToSize(reviewText, pageWidth - 40) reviewLines.forEach((line: string) => { doc.text(line, 25, yPos) yPos += 6 }) yPos += 15 // ==================== RECOMMENDED NEXT STEPS ==================== checkPageBreak(120) // Section header drawColoredRect(doc, 0, yPos - 5, pageWidth, 20, COLORS.primary) doc.setTextColor(255, 255, 255) doc.setFontSize(14) doc.setFont("helvetica", "bold") doc.text("Recommended Next Steps", 20, yPos + 8) doc.setTextColor(0, 0, 0) yPos += 25 doc.setFontSize(10) doc.setFont("helvetica", "normal") const nextSteps = [ "Review and validate assessment results with your emergency management team", "Prioritize resource allocation based on identified critical risk hazards", "Develop or update emergency response plans for top-priority risks", "Schedule regular training and drills for identified scenarios", "Establish monitoring systems for early warning and detection", "Plan for annual reassessment and continuous improvement", "Coordinate with local emergency services and mutual aid partners", "Document all preparedness measures and maintain current inventories", ] nextSteps.forEach((step, index) => { checkPageBreak(12) doc.text(`${index + 1}. ${step}`, 25, yPos) yPos += 10 }) yPos += 15 // Footer note doc.setFontSize(9) doc.setFont("helvetica", "italic") doc.setTextColor(100, 100, 100) doc.text("This assessment should be reviewed regularly and updated as conditions change.", 20, yPos) yPos += 8 doc.text("For questions about this report, contact your emergency management coordinator.", 20, yPos) // Add page numbers and footer const totalPages = doc.getNumberOfPages() for (let i = 1; i <= totalPages; i++) { doc.setPage(i) // Footer doc.setFontSize(8) doc.setTextColor(128, 128, 128) doc.text(`TIPNOW HVA Report - ${new Date().toLocaleDateString()}`, 20, pageHeight - 10) doc.text(`Page ${i} of ${totalPages}`, pageWidth - 40, pageHeight - 10) } // Reset text color doc.setTextColor(0, 0, 0) console.log("Comprehensive PDF generated successfully") return doc.output("blob") } catch (error) { console.error("PDF Generation Error:", error) // Create minimal error PDF try { const errorDoc = new jsPDF() // Error page header drawColoredRect(errorDoc, 0, 0, errorDoc.internal.pageSize.width, 30, COLORS.high) errorDoc.setTextColor(255, 255, 255) errorDoc.setFontSize(14) errorDoc.setFont("helvetica", "bold") errorDoc.text("PDF Generation Error", 20, 20) errorDoc.setTextColor(0, 0, 0) errorDoc.setFontSize(11) errorDoc.setFont("helvetica", "normal") errorDoc.text("Unable to generate the full report.", 20, 50) errorDoc.text("Please try again or contact support.", 20, 65) if (error instanceof Error) { errorDoc.text(`Error: ${error.message}`, 20, 85) } return errorDoc.output("blob") } catch (fallbackError) { console.error("Even error PDF failed:", fallbackError) return new Blob(["PDF generation failed"], { type: "application/pdf" }) } } }