\n Loading application...\n

\n \n \n\n",[],[263,265],"5790c278-3f88-11f0-b79d-76b3cceeab13","QuoteList.tsx","5790c340-3f88-11f0-b79d-76b3cceeab13","fc4ba284-ceb7-4935-a881-06503217234b",17,["D",1748851526563],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Quote } from \"../../shared/types.ts\";\nimport { formatCurrency } from \"../../shared/types.ts\";\n\ninterface QuoteListProps {\n quotes: Quote[];\n loading: boolean;\n onViewQuote: (quote: Quote) => void;\n onRefresh: () => void;\n userRole: string;\n}\n\nexport default function QuoteList({ quotes, loading, onViewQuote, onRefresh, userRole }: QuoteListProps) {\n const getStatusBadge = (status: string) => {\n const baseClasses = \"status-badge\";\n switch (status) {\n case 'draft':\n return `${baseClasses} status-draft`;\n case 'submitted':\n return `${baseClasses} status-submitted`;\n case 'approved':\n return `${baseClasses} status-approved`;\n case 'rejected':\n return `${baseClasses} status-rejected`;\n default:\n return baseClasses;\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n if (loading) {\n return (\n

\n Loading quotes...\n

\n );\n }\n\n return (\n

\n {userRole === 'intermediary' ? 'My Quotes' : 'All Quotes'}\n

\n {userRole === 'intermediary' \n ? 'A list of all your insurance quotes including their status and details.'\n : 'Review and manage insurance quotes from intermediaries.'\n }\n

\n \n Refresh\n \n

\n\n {quotes.length === 0 ? (\n

\n \n \n \n

No quotes

\n {userRole === 'intermediary' \n ? 'Get started by creating a new quote.'\n : 'No quotes have been submitted for review yet.'\n }\n

\n ) : (\n

\n {quotes.map((quote) => (\n onViewQuote(quote)}\n >\n

\n \n {quote.quote_number.slice(-3)}\n \n

\n {quote.quote_number}\n

\n {quote.client_name}\n

\n \n {quote.status}\n \n

\n\n

\n Group Class:\n {quote.group_class?.name}\n

\n Total Amount:\n \n {formatCurrency(quote.total_amount)}\n \n

\n {userRole === 'underwriter' && (\n

\n Intermediary:\n {quote.intermediary_name}\n

\n )}\n

\n\n

\n Created: {formatDate(quote.created_at)}\n {quote.approved_at && (\n Approved: {formatDate(quote.approved_at)}\n )}\n

\n\n {quote.underwriter_notes && (\n

\n Notes: \n {quote.underwriter_notes}\n

\n )}\n

\n ))}\n

\n )}\n \n );\n}",[],[263,281,273],"components","7ca89180-3f88-11f0-814f-76b3cceeab13","QuoteForm.tsx","7ca89266-3f88-11f0-814f-76b3cceeab13",18,["D",1748851588762],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { \n Quote, \n GroupClass, \n InsuranceClass, \n CreateQuoteRequest \n} from \"../../shared/types.ts\";\nimport { \n calculatePremium, \n calculateLevies, \n calculateTotalAmount, \n formatCurrency, \n formatPercentage \n} from \"../../shared/types.ts\";\n\ninterface QuoteFormProps {\n token: string;\n onQuoteCreated: (quote: Quote) => void;\n onCancel: () => void;\n}\n\ninterface QuoteItem {\n insurance_class_id: number;\n sum_insured: number;\n}\n\nexport default function QuoteForm({ token, onQuoteCreated, onCancel }: QuoteFormProps) {\n const [groupClasses, setGroupClasses] = useState([]);\n const [insuranceClasses, setInsuranceClasses] = useState([]);\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState('');\n\n const [formData, setFormData] = useState({\n client_name: '',\n client_email: '',\n client_phone: '',\n client_address: '',\n business_type: '',\n group_class_id: 0\n });\n\n const [quoteItems, setQuoteItems] = useState([]);\n\n useEffect(() => {\n loadGroupClasses();\n }, []);\n\n useEffect(() => {\n if (formData.group_class_id) {\n loadInsuranceClasses(formData.group_class_id);\n }\n }, [formData.group_class_id]);\n\n const loadGroupClasses = async () => {\n try {\n const response = await fetch('/api/products/group-classes', {\n headers: { 'Authorization': `Bearer ${token}` }\n });\n if (response.ok) {\n const data = await response.json();\n setGroupClasses(data);\n }\n } catch (error) {\n console.error('Error loading group classes:', error);\n }\n };\n\n const loadInsuranceClasses = async (groupId: number) => {\n try {\n const response = await fetch(`/api/products/group-classes/${groupId}/insurance-classes`, {\n headers: { 'Authorization': `Bearer ${token}` }\n });\n if (response.ok) {\n const data = await response.json();\n setInsuranceClasses(data);\n setQuoteItems([]); // Reset items when group changes\n }\n } catch (error) {\n console.error('Error loading insurance classes:', error);\n }\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: name === 'group_class_id' ? parseInt(value) : value\n }));\n };\n\n const addQuoteItem = () => {\n setQuoteItems(prev => [...prev, { insurance_class_id: 0, sum_insured: 0 }]);\n };\n\n const removeQuoteItem = (index: number) => {\n setQuoteItems(prev => prev.filter((_, i) => i !== index));\n };\n\n const updateQuoteItem = (index: number, field: keyof QuoteItem, value: number) => {\n setQuoteItems(prev => prev.map((item, i) => \n i === index ? { ...item, [field]: value } : item\n ));\n };\n\n const calculateQuoteTotals = () => {\n let totalPremium = 0;\n \n const itemsWithPremiums = quoteItems.map(item => {\n const insuranceClass = insuranceClasses.find(ic => ic.id === item.insurance_class_id);\n if (!insuranceClass || !item.sum_insured) return { ...item, premium: 0 };\n \n const premium = calculatePremium(item.sum_insured, insuranceClass.minimum_rate);\n totalPremium += premium;\n \n return { ...item, premium, insuranceClass };\n });\n\n const levies = calculateLevies(totalPremium);\n const totalAmount = calculateTotalAmount(totalPremium);\n\n return {\n items: itemsWithPremiums,\n totalPremium,\n ...levies,\n totalAmount\n };\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n try {\n // Validate form\n if (!formData.client_name || !formData.client_email || !formData.group_class_id) {\n throw new Error('Please fill in all required fields');\n }\n\n if (quoteItems.length === 0) {\n throw new Error('Please add at least one insurance class');\n }\n\n const validItems = quoteItems.filter(item => \n item.insurance_class_id > 0 && item.sum_insured > 0\n );\n\n if (validItems.length === 0) {\n throw new Error('Please complete all quote items');\n }\n\n const requestData: CreateQuoteRequest = {\n ...formData,\n items: validItems\n };\n\n const response = await fetch('/api/quotes', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify(requestData)\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Failed to create quote');\n }\n\n onQuoteCreated(data);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Failed to create quote');\n } finally {\n setLoading(false);\n }\n };\n\n const quoteTotals = calculateQuoteTotals();\n\n return (\n

Create New Quote

\n Enter client information and select insurance classes to generate a quote.\n

\n\n

\n {/* Client Information */}\n

Client Information

\n \n Client Name *\n \n \n

\n\n

\n \n Email *\n \n \n

\n\n

\n \n Phone\n \n \n

\n\n

\n \n Business Type\n \n \n

\n\n

\n \n Address\n \n \n

\n\n {/* Group Class Selection */}\n

\n \n Group Class *\n \n \n \n {groupClasses.map(gc => (\n \n ))}\n \n

\n\n {/* Insurance Classes */}\n {formData.group_class_id > 0 && (\n

Insurance Classes

\n \n Add Item\n \n

\n\n {quoteItems.map((item, index) => (\n

\n \n Insurance Class\n \n updateQuoteItem(index, 'insurance_class_id', parseInt(e.target.value))}\n className=\"mt-1 block w-full py-2 px-3 border border-gray-300 bg-white rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm\"\n >\n \n {insuranceClasses.map(ic => (\n \n ))}\n \n

\n\n

\n \n Sum Insured\n \n updateQuoteItem(index, 'sum_insured', parseFloat(e.target.value) || 0)}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n\n

\n \n Premium\n \n

\n {formatCurrency(quoteTotals.items[index]?.premium || 0)}\n

\n\n

\n removeQuoteItem(index)}\n className=\"inline-flex items-center p-2 border border-transparent rounded-md text-red-600 hover:bg-red-50 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-red-500\"\n >\n ×\n \n

\n ))}\n\n {/* Quote Summary */}\n {quoteItems.length > 0 && (\n

Quote Summary

\n Total Premium:\n {formatCurrency(quoteTotals.totalPremium)}\n

\n TL Levy (0.2%):\n {formatCurrency(quoteTotals.tl_levy)}\n

\n PHCF Levy (0.25%):\n {formatCurrency(quoteTotals.phcf_levy)}\n

\n SD Levy:\n {formatCurrency(quoteTotals.sd_levy)}\n

\n Total Amount:\n {formatCurrency(quoteTotals.totalAmount)}\n

\n )}\n

\n )}\n\n {error && (\n

{error}

\n )}\n

\n\n

\n \n Cancel\n \n \n {loading ? (\n <>\n

\n Creating...\n \n ) : (\n 'Create Quote'\n )}\n \n

\n );\n}",[],[263,281,283],"ac0baed0-3f88-11f0-881b-76b3cceeab13","QuoteDetail.tsx","ac0baf7a-3f88-11f0-881b-76b3cceeab13",19,["D",1748851668297],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Quote, UpdateQuoteRequest } from \"../../shared/types.ts\";\nimport { formatCurrency, formatPercentage } from \"../../shared/types.ts\";\n\ninterface QuoteDetailProps {\n quote: Quote;\n token: string;\n userRole: string;\n onQuoteUpdated: (quote: Quote) => void;\n onBack: () => void;\n}\n\nexport default function QuoteDetail({ quote, token, userRole, onQuoteUpdated, onBack }: QuoteDetailProps) {\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState('');\n const [showUnderwriterForm, setShowUnderwriterForm] = useState(false);\n const [underwriterData, setUnderwriterData] = useState({\n status: quote.status,\n underwriter_notes: quote.underwriter_notes || '',\n discount_percentage: quote.discount_percentage || 0,\n load_percentage: quote.load_percentage || 0\n });\n\n const canSubmit = userRole === 'intermediary' && quote.status === 'draft';\n const canUnderwrite = userRole === 'underwriter' && (quote.status === 'submitted' || quote.status === 'approved');\n const canPrint = quote.status === 'approved';\n\n const handleSubmitQuote = async () => {\n setLoading(true);\n setError('');\n\n try {\n const response = await fetch(`/api/quotes/${quote.id}/submit`, {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${token}`\n }\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Failed to submit quote');\n }\n\n onQuoteUpdated(data);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Failed to submit quote');\n } finally {\n setLoading(false);\n }\n };\n\n const handleUnderwriterUpdate = async () => {\n setLoading(true);\n setError('');\n\n try {\n const updateData: UpdateQuoteRequest = {\n status: underwriterData.status as 'approved' | 'rejected',\n underwriter_notes: underwriterData.underwriter_notes || undefined,\n discount_percentage: underwriterData.discount_percentage || undefined,\n load_percentage: underwriterData.load_percentage || undefined\n };\n\n const response = await fetch(`/api/quotes/${quote.id}`, {\n method: 'PUT',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify(updateData)\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Failed to update quote');\n }\n\n onQuoteUpdated(data);\n setShowUnderwriterForm(false);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Failed to update quote');\n } finally {\n setLoading(false);\n }\n };\n\n const handlePrint = async () => {\n try {\n const response = await fetch(`/api/quotes/${quote.id}/print`, {\n headers: {\n 'Authorization': `Bearer ${token}`\n }\n });\n\n if (response.ok) {\n window.print();\n } else {\n const data = await response.json();\n setError(data.error || 'Failed to generate print data');\n }\n } catch (error) {\n setError('Failed to print quote');\n }\n };\n\n const getStatusBadge = (status: string) => {\n const baseClasses = \"status-badge\";\n switch (status) {\n case 'draft':\n return `${baseClasses} status-draft`;\n case 'submitted':\n return `${baseClasses} status-submitted`;\n case 'approved':\n return `${baseClasses} status-approved`;\n case 'rejected':\n return `${baseClasses} status-rejected`;\n default:\n return baseClasses;\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n return (\n

\n {/* Header */}\n

\n Quote {quote.quote_number}\n

\n Created on {formatDate(quote.created_at)}\n

\n \n {quote.status}\n \n \n ← Back\n \n

\n\n {/* Print Header */}\n

Insurance Quote

Quote Number: {quote.quote_number}

Generated on {formatDate(new Date().toISOString())}

\n\n

\n {/* Main Content */}\n

\n {/* Client Information */}\n

\n Client Information\n

Name: \n {quote.client_name}\n
Email: \n {quote.client_email}\n
Phone: \n {quote.client_phone}\n
Business Type: \n {quote.business_type}\n
Address: \n {quote.client_address}\n

\n\n {/* Quote Items */}\n

\n Insurance Coverage\n

\n Group Class: {quote.group_class?.name}\n

\n \n \n \n \n \n \n \n \n \n \n {quote.items.map((item, index) => (\n \n \n \n \n \n \n ))}\n \n

\n Insurance Class\n	\n Sum Insured\n	\n Rate\n	\n Premium\n
\n \n {item.insurance_class.name} \n Code: {item.insurance_class.code} \n \n	\n {formatCurrency(item.sum_insured)}\n	\n {formatPercentage(item.rate)}\n {item.rate !== item.insurance_class.minimum_rate && (\n \n (Original: {formatPercentage(item.insurance_class.minimum_rate)})\n \n )}\n	\n {formatCurrency(item.premium)}\n

\n\n {/* Sidebar */}\n

\n {/* Quote Summary */}\n

\n Quote Summary\n

Total Premium: \n {formatCurrency(quote.total_premium)}\n
TL Levy (0.2%): \n {formatCurrency(quote.tl_levy)}\n
PHCF Levy (0.25%): \n {formatCurrency(quote.phcf_levy)}\n
SD Levy: \n {formatCurrency(quote.sd_levy)}\n
Total Amount: \n {formatCurrency(quote.total_amount)}\n

\n\n {/* Actions */}\n

\n Actions\n

\n {canSubmit && (\n \n {loading ? 'Submitting...' : 'Submit for Review'}\n \n )}\n\n {canUnderwrite && (\n setShowUnderwriterForm(!showUnderwriterForm)}\n className=\"w-full inline-flex justify-center py-2 px-4 border border-gray-300 shadow-sm text-sm font-medium rounded-md text-gray-700 bg-white hover:bg-gray-50 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-indigo-500\"\n >\n {showUnderwriterForm ? 'Cancel Review' : 'Review Quote'}\n \n )}\n\n {canPrint && (\n \n Print Quote\n \n )}\n

\n\n {/* Underwriter Form */}\n {showUnderwriterForm && (\n

\n Underwriter Review\n

\n \n Decision\n \n setUnderwriterData(prev => ({ ...prev, status: e.target.value }))}\n className=\"mt-1 block w-full py-2 px-3 border border-gray-300 bg-white rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm\"\n >\n \n \n \n \n

\n\n

\n \n Discount % (optional)\n \n setUnderwriterData(prev => ({ \n ...prev, \n discount_percentage: parseFloat(e.target.value) || 0,\n load_percentage: 0 \n }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n\n

\n \n Load % (optional)\n \n setUnderwriterData(prev => ({ \n ...prev, \n load_percentage: parseFloat(e.target.value) || 0,\n discount_percentage: 0 \n }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n\n

\n \n Notes\n \n setUnderwriterData(prev => ({ ...prev, underwriter_notes: e.target.value }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n\n \n {loading ? 'Updating...' : 'Update Quote'}\n \n

\n )}\n\n {/* Quote History */}\n {(quote.underwriter_name || quote.underwriter_notes) && (\n

\n Review History\n

Reviewed by: \n {quote.underwriter_name}\n
Approved on: \n {formatDate(quote.approved_at)}\n
Rate Adjustment: \n {quote.discount_percentage ? `${quote.discount_percentage}% Discount` : ''}\n {quote.load_percentage ? `${quote.load_percentage}% Load` : ''}\n
Notes: \n {quote.underwriter_notes}\n

\n )}\n

\n\n {error && (\n

{error}

\n )}\n

\n );\n}",[],[263,281,291],"d6a490c6-3f88-11f0-8dad-76b3cceeab13","ProductManagement.tsx","d6a49170-3f88-11f0-8dad-76b3cceeab13",["D",1748851739762],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { GroupClass, InsuranceClass } from \"../../shared/types.ts\";\nimport { formatPercentage } from \"../../shared/types.ts\";\n\ninterface ProductManagementProps {\n token: string;\n userRole: string;\n onBack: () => void;\n}\n\nexport default function ProductManagement({ token, userRole, onBack }: ProductManagementProps) {\n const [groupClasses, setGroupClasses] = useState([]);\n const [insuranceClasses, setInsuranceClasses] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState('');\n const [activeTab, setActiveTab] = useState<'groups' | 'insurance'>('groups');\n\n // Form states\n const [showGroupForm, setShowGroupForm] = useState(false);\n const [showInsuranceForm, setShowInsuranceForm] = useState(false);\n const [editingRate, setEditingRate] = useState(null);\n\n const [groupForm, setGroupForm] = useState({\n code: '',\n name: '',\n description: ''\n });\n\n const [insuranceForm, setInsuranceForm] = useState({\n group_class_id: 0,\n code: '',\n name: '',\n minimum_rate: 0\n });\n\n const [newRate, setNewRate] = useState(0);\n\n useEffect(() => {\n loadData();\n }, []);\n\n const loadData = async () => {\n setLoading(true);\n try {\n const [groupResponse, insuranceResponse] = await Promise.all([\n fetch('/api/products/group-classes', {\n headers: { 'Authorization': `Bearer ${token}` }\n }),\n fetch('/api/products/insurance-classes', {\n headers: { 'Authorization': `Bearer ${token}` }\n })\n ]);\n\n if (groupResponse.ok) {\n const groupData = await groupResponse.json();\n setGroupClasses(groupData);\n }\n\n if (insuranceResponse.ok) {\n const insuranceData = await insuranceResponse.json();\n setInsuranceClasses(insuranceData);\n }\n } catch (error) {\n console.error('Error loading data:', error);\n setError('Failed to load product data');\n } finally {\n setLoading(false);\n }\n };\n\n const handleCreateGroup = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n try {\n const response = await fetch('/api/products/group-classes', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify(groupForm)\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Failed to create group class');\n }\n\n setGroupClasses(prev => [...prev, data]);\n setGroupForm({ code: '', name: '', description: '' });\n setShowGroupForm(false);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Failed to create group class');\n } finally {\n setLoading(false);\n }\n };\n\n const handleCreateInsurance = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n try {\n const response = await fetch('/api/products/insurance-classes', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify({\n ...insuranceForm,\n minimum_rate: insuranceForm.minimum_rate / 100 // Convert percentage to decimal\n })\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Failed to create insurance class');\n }\n\n setInsuranceClasses(prev => [...prev, data]);\n setInsuranceForm({ group_class_id: 0, code: '', name: '', minimum_rate: 0 });\n setShowInsuranceForm(false);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Failed to create insurance class');\n } finally {\n setLoading(false);\n }\n };\n\n const handleUpdateRate = async (id: number) => {\n setLoading(true);\n setError('');\n\n try {\n const response = await fetch(`/api/products/insurance-classes/${id}/rate`, {\n method: 'PUT',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`\n },\n body: JSON.stringify({\n minimum_rate: newRate / 100 // Convert percentage to decimal\n })\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Failed to update rate');\n }\n\n setInsuranceClasses(prev => prev.map(ic => \n ic.id === id ? data : ic\n ));\n setEditingRate(null);\n setNewRate(0);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Failed to update rate');\n } finally {\n setLoading(false);\n }\n };\n\n if (userRole !== 'underwriter') {\n return (\n

Access Denied

\n Only underwriters can access product management.\n

\n \n Go Back\n \n

\n );\n }\n\n if (loading && groupClasses.length === 0) {\n return (\n

\n Loading products...\n

\n );\n }\n\n return (\n

Product Management

\n Manage insurance group classes and their associated insurance classes with minimum rates.\n

\n \n ← Back to Quotes\n \n

\n\n {/* Tabs */}\n

\n setActiveTab('groups')}\n className={`py-2 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'groups'\n ? 'border-indigo-500 text-indigo-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Group Classes\n \n setActiveTab('insurance')}\n className={`py-2 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'insurance'\n ? 'border-indigo-500 text-indigo-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Insurance Classes\n \n

\n\n {error && (\n

{error}

\n )}\n\n {/* Group Classes Tab */}\n {activeTab === 'groups' && (\n

Group Classes

\n setShowGroupForm(!showGroupForm)}\n className=\"inline-flex items-center justify-center rounded-md border border-transparent bg-indigo-600 px-4 py-2 text-sm font-medium text-white shadow-sm hover:bg-indigo-700\"\n >\n {showGroupForm ? 'Cancel' : 'Add Group Class'}\n \n

\n\n {showGroupForm && (\n

\n Create New Group Class\n

\n \n Code *\n \n setGroupForm(prev => ({ ...prev, code: e.target.value }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n \n Name *\n \n setGroupForm(prev => ({ ...prev, name: e.target.value }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n \n Description\n \n setGroupForm(prev => ({ ...prev, description: e.target.value }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n \n {loading ? 'Creating...' : 'Create Group Class'}\n \n

\n )}\n\n

\n
\n
\n
\n
\n {group.code} - {group.name}\n
\n {group.description && (\n
{group.description}
\n )}\n
\n
\n
\n

\n )}\n\n {/* Insurance Classes Tab */}\n {activeTab === 'insurance' && (\n

Insurance Classes

\n setShowInsuranceForm(!showInsuranceForm)}\n className=\"inline-flex items-center justify-center rounded-md border border-transparent bg-indigo-600 px-4 py-2 text-sm font-medium text-white shadow-sm hover:bg-indigo-700\"\n >\n {showInsuranceForm ? 'Cancel' : 'Add Insurance Class'}\n \n

\n\n {showInsuranceForm && (\n

\n Create New Insurance Class\n

\n \n Group Class *\n \n setInsuranceForm(prev => ({ ...prev, group_class_id: parseInt(e.target.value) }))}\n className=\"mt-1 block w-full py-2 px-3 border border-gray-300 bg-white rounded-md shadow-sm focus:outline-none focus:ring-indigo-500 focus:border-indigo-500 sm:text-sm\"\n >\n \n {groupClasses.map(gc => (\n \n ))}\n \n

\n \n Code *\n \n setInsuranceForm(prev => ({ ...prev, code: e.target.value }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n \n Name *\n \n setInsuranceForm(prev => ({ ...prev, name: e.target.value }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n \n Minimum Rate (%) *\n \n setInsuranceForm(prev => ({ ...prev, minimum_rate: parseFloat(e.target.value) || 0 }))}\n className=\"mt-1 focus:ring-indigo-500 focus:border-indigo-500 block w-full shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n

\n \n {loading ? 'Creating...' : 'Create Insurance Class'}\n \n

\n )}\n\n

\n \n \n \n \n \n \n \n \n \n \n \n {insuranceClasses.map((insurance) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Code\n	\n Name\n	\n Group Class\n	\n Minimum Rate\n	\n Actions\n
\n {insurance.code}\n	\n {insurance.name}\n	\n {groupClasses.find(gc => gc.id === insurance.group_class_id)?.name}\n	\n {editingRate === insurance.id ? (\n \n setNewRate(parseFloat(e.target.value) \|\| 0)}\n className=\"w-20 focus:ring-indigo-500 focus:border-indigo-500 block shadow-sm sm:text-sm border-gray-300 rounded-md\"\n />\n %\n \n ) : (\n formatPercentage(insurance.minimum_rate)\n )}\n	\n {editingRate === insurance.id ? (\n \n handleUpdateRate(insurance.id)}\n disabled={loading}\n className=\"text-indigo-600 hover:text-indigo-900 disabled:opacity-50\"\n >\n Save\n \n {\n setEditingRate(null);\n setNewRate(0);\n }}\n className=\"text-gray-600 hover:text-gray-900\"\n >\n Cancel\n \n \n ) : (\n {\n setEditingRate(insurance.id);\n setNewRate(insurance.minimum_rate * 100);\n }}\n className=\"text-indigo-600 hover:text-indigo-900\"\n >\n Edit Rate\n \n )}\n

\n )}\n

\n );\n}",[],[263,281,299],"3558e686-3f88-11f0-8dcb-76b3cceeab13","Login.tsx","3558e758-3f88-11f0-8dcb-76b3cceeab13",15,["D",1748851469155],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User, LoginRequest } from \"../../shared/types.ts\";\n\ninterface LoginProps {\n onLogin: (user: User, token: string) => void;\n}\n\nexport default function Login({ onLogin }: LoginProps) {\n const [formData, setFormData] = useState({\n username: '',\n password: ''\n });\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState('');\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n try {\n const response = await fetch('/api/auth/login', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(formData)\n });\n\n const data = await response.json();\n\n if (!response.ok) {\n throw new Error(data.error || 'Login failed');\n }\n\n onLogin(data.user, data.token);\n } catch (error) {\n setError(error instanceof Error ? error.message : 'Login failed');\n } finally {\n setLoading(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n setFormData(prev => ({\n ...prev,\n [e.target.name]: e.target.value\n }));\n };\n\n return (\n

\n Quote Management System\n

\n Sign in to your account\n

\n \n \n

\n );\n}",[],[263,281,306],"453cdada-3f88-11f0-a4e7-76b3cceeab13","Dashboard.tsx","453cdba2-3f88-11f0-a4e7-76b3cceeab13",16,["D",1748851495811],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport QuoteList from \"./QuoteList.tsx\";\nimport QuoteForm from \"./QuoteForm.tsx\";\nimport QuoteDetail from \"./QuoteDetail.tsx\";\nimport ProductManagement from \"./ProductManagement.tsx\";\nimport type { User, Quote } from \"../../shared/types.ts\";\n\ninterface DashboardProps {\n user: User;\n token: string;\n onLogout: () => void;\n}\n\ntype View = 'quotes' | 'create-quote' | 'quote-detail' | 'products';\n\nexport default function Dashboard({ user, token, onLogout }: DashboardProps) {\n const [currentView, setCurrentView] = useState('quotes');\n const [selectedQuote, setSelectedQuote] = useState(null);\n const [quotes, setQuotes] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n loadQuotes();\n }, []);\n\n const loadQuotes = async () => {\n try {\n const response = await fetch('/api/quotes', {\n headers: {\n 'Authorization': `Bearer ${token}`\n }\n });\n\n if (response.ok) {\n const data = await response.json();\n setQuotes(data);\n }\n } catch (error) {\n console.error('Error loading quotes:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleQuoteCreated = (quote: Quote) => {\n setQuotes(prev => [quote, ...prev]);\n setCurrentView('quotes');\n };\n\n const handleQuoteUpdated = (updatedQuote: Quote) => {\n setQuotes(prev => prev.map(q => q.id === updatedQuote.id ? updatedQuote : q));\n setSelectedQuote(updatedQuote);\n };\n\n const handleViewQuote = (quote: Quote) => {\n setSelectedQuote(quote);\n setCurrentView('quote-detail');\n };\n\n const renderContent = () => {\n switch (currentView) {\n case 'quotes':\n return (\n \n );\n case 'create-quote':\n return (\n setCurrentView('quotes')}\n />\n );\n case 'quote-detail':\n return selectedQuote ? (\n setCurrentView('quotes')}\n />\n ) : null;\n case 'products':\n return (\n setCurrentView('quotes')}\n />\n );\n default:\n return null;\n }\n };\n\n return (\n

\n {/* Header */}\n

\n Quote Management System\n

\n \n {user.role}\n \n

\n \n

\n \n Welcome, {user.name}\n \n \n Sign out\n \n

\n\n {/* Navigation */}\n

\n setCurrentView('quotes')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n currentView === 'quotes'\n ? 'border-indigo-500 text-indigo-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Quotes\n \n \n {user.role === 'intermediary' && (\n setCurrentView('create-quote')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n currentView === 'create-quote'\n ? 'border-indigo-500 text-indigo-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Create Quote\n \n )}\n \n {user.role === 'underwriter' && (\n setCurrentView('products')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n currentView === 'products'\n ? 'border-indigo-500 text-indigo-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n Product Management\n \n )}\n

\n\n {/* Main Content */}\n

\n {renderContent()}\n

\n );\n}",[],[263,281,314],"285bd51a-3f88-11f0-8dcb-76b3cceeab13","App.tsx","285bd5f6-3f88-11f0-8dcb-76b3cceeab13",14,["D",1748851447361],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport Login from \"./Login.tsx\";\nimport Dashboard from \"./Dashboard.tsx\";\nimport type { User } from \"../../shared/types.ts\";\n\ninterface AppState {\n user: User | null;\n token: string | null;\n loading: boolean;\n}\n\nexport default function App() {\n const [state, setState] = useState({\n user: null,\n token: null,\n loading: true\n });\n\n useEffect(() => {\n // Check for existing token in localStorage\n const token = localStorage.getItem('auth_token');\n const userData = localStorage.getItem('user_data');\n \n if (token && userData) {\n try {\n const user = JSON.parse(userData);\n setState({ user, token, loading: false });\n } catch (error) {\n console.error('Error parsing stored user data:', error);\n localStorage.removeItem('auth_token');\n localStorage.removeItem('user_data');\n setState({ user: null, token: null, loading: false });\n }\n } else {\n setState({ user: null, token: null, loading: false });\n }\n }, []);\n\n const handleLogin = (user: User, token: string) => {\n localStorage.setItem('auth_token', token);\n localStorage.setItem('user_data', JSON.stringify(user));\n setState({ user, token, loading: false });\n };\n\n const handleLogout = () => {\n localStorage.removeItem('auth_token');\n localStorage.removeItem('user_data');\n setState({ user: null, token: null, loading: false });\n };\n\n if (state.loading) {\n return (\n

\n Loading...\n

\n );\n }\n\n if (!state.user || !state.token) {\n return ;\n }\n\n return ;\n}",[],[263,281,322],"285bdf24-3f88-11f0-8dcb-76b3cceeab13",["D",1748851447361],[210,211,212,213,214,215,216],[263,281],"1db4fbaa-3f88-11f0-95b6-76b3cceeab13",["D",1748851429491],[209,217,218],[263],"14ae56e6-3f88-11f0-bc4c-76b3cceeab13","index.ts",11,["D",1748851414343],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations, seedData } from \"./database/migrations.ts\";\nimport auth from \"./routes/auth.ts\";\nimport quotes from \"./routes/quotes.ts\";\nimport products from \"./routes/products.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait runMigrations();\nawait seedData();\n\n// API Routes\napp.route('/api/auth', auth);\napp.route('/api/quotes', quotes);\napp.route('/api/products', products);\n\n// Health check\napp.get('/api/health', (c) => {\n return c.json({ status: 'ok', timestamp: new Date().toISOString() });\n});\n\n// Serve frontend files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data injection\napp.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial configuration\n const config = {\n apiUrl: '/api',\n appName: 'Quote Management System',\n version: '1.0.0'\n };\n \n const configScript = ``;\n \n html = html.replace(\"\", `${configScript}`);\n return c.html(html);\n } catch (error) {\n console.error('Error serving index:', error);\n return c.text('Error loading application', 500);\n }\n});\n\n// Catch-all for SPA routing\napp.get(\"*\", async c => {\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (error) {\n return c.text('Page not found', 404);\n }\n});\n\nexport default app;",[],[172,338],["D",1748851373466],[],[172,92,81],["D",1748851393565],[],[172,92,90],["D",1748851350239],[],[172,92,66],["D",1748851350239],[204,205,206],[172,92],"e3d00af6-3f87-11f0-a7be-76b3cceeab13","queries.ts","e3d00bd2-3f87-11f0-a7be-76b3cceeab13","73663d09-c23d-4db5-b795-4a8c4c7ba00d",6,["D",1748851332344],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { \n User, \n GroupClass, \n InsuranceClass, \n Quote, \n QuoteItem,\n CreateQuoteRequest,\n UpdateQuoteRequest \n} from \"../../shared/types.ts\";\nimport { calculatePremium, calculateLevies, calculateTotalAmount, applyDiscountOrLoad } from \"../../shared/types.ts\";\n\n// User queries\nexport async function findUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.users} WHERE username = ?`,\n [username]\n );\n return result[0] || null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.users} WHERE id = ?`,\n [id]\n );\n return result[0] || null;\n}\n\n// Group Classes queries\nexport async function getAllGroupClasses(): Promise {\n return await sqlite.execute(`SELECT * FROM ${TABLES.group_classes} ORDER BY name`);\n}\n\nexport async function getGroupClassById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.group_classes} WHERE id = ?`,\n [id]\n );\n return result[0] || null;\n}\n\n// Insurance Classes queries\nexport async function getInsuranceClassesByGroupId(groupId: number): Promise {\n return await sqlite.execute(\n `SELECT * FROM ${TABLES.insurance_classes} WHERE group_class_id = ? ORDER BY code`,\n [groupId]\n );\n}\n\nexport async function getInsuranceClassById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.insurance_classes} WHERE id = ?`,\n [id]\n );\n return result[0] || null;\n}\n\nexport async function getAllInsuranceClasses(): Promise {\n return await sqlite.execute(`\n SELECT ic.*, gc.name as group_name \n FROM ${TABLES.insurance_classes} ic\n JOIN ${TABLES.group_classes} gc ON ic.group_class_id = gc.id\n ORDER BY gc.name, ic.code\n `);\n}\n\n// Quote queries\nexport async function createQuote(\n intermediaryId: number, \n intermediaryName: string, \n data: CreateQuoteRequest\n): Promise {\n // Generate quote number\n const quoteNumber = `Q${Date.now()}`;\n \n // Get insurance classes for rate calculation\n const insuranceClasses = await Promise.all(\n data.items.map(item => getInsuranceClassById(item.insurance_class_id))\n );\n \n // Calculate quote items\n const quoteItems = data.items.map((item, index) => {\n const insuranceClass = insuranceClasses[index];\n if (!insuranceClass) throw new Error(`Insurance class ${item.insurance_class_id} not found`);\n \n const premium = calculatePremium(item.sum_insured, insuranceClass.minimum_rate);\n return {\n insurance_class_id: item.insurance_class_id,\n sum_insured: item.sum_insured,\n rate: insuranceClass.minimum_rate,\n premium\n };\n });\n \n // Calculate totals\n const totalPremium = quoteItems.reduce((sum, item) => sum + item.premium, 0);\n const levies = calculateLevies(totalPremium);\n const totalAmount = calculateTotalAmount(totalPremium);\n \n // Insert quote\n const quoteResult = await sqlite.execute(`\n INSERT INTO ${TABLES.quotes} (\n quote_number, intermediary_id, intermediary_name,\n client_name, client_email, client_phone, client_address, business_type,\n group_class_id, total_premium, tl_levy, phcf_levy, sd_levy, total_amount\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n quoteNumber, intermediaryId, intermediaryName,\n data.client_name, data.client_email, data.client_phone, data.client_address, data.business_type,\n data.group_class_id, totalPremium, levies.tl_levy, levies.phcf_levy, levies.sd_levy, totalAmount\n ]);\n \n const quoteId = quoteResult.lastInsertRowid;\n \n // Insert quote items\n for (const item of quoteItems) {\n await sqlite.execute(`\n INSERT INTO ${TABLES.quote_items} (quote_id, insurance_class_id, sum_insured, rate, premium)\n VALUES (?, ?, ?, ?, ?)\n `, [quoteId, item.insurance_class_id, item.sum_insured, item.rate, item.premium]);\n }\n \n return await getQuoteById(quoteId as number) as Quote;\n}\n\nexport async function getQuoteById(id: number): Promise {\n // Get quote with group class\n const quoteResult = await sqlite.execute(`\n SELECT q.*, gc.code as group_code, gc.name as group_name, gc.description as group_description\n FROM ${TABLES.quotes} q\n JOIN ${TABLES.group_classes} gc ON q.group_class_id = gc.id\n WHERE q.id = ?\n `, [id]);\n \n if (!quoteResult[0]) return null;\n \n const quote = quoteResult[0];\n \n // Get quote items with insurance class details\n const itemsResult = await sqlite.execute(`\n SELECT qi.*, ic.code as insurance_code, ic.name as insurance_name, ic.minimum_rate\n FROM ${TABLES.quote_items} qi\n JOIN ${TABLES.insurance_classes} ic ON qi.insurance_class_id = ic.id\n WHERE qi.quote_id = ?\n ORDER BY ic.code\n `, [id]);\n \n const items: QuoteItem[] = itemsResult.map(item => ({\n id: item.id,\n quote_id: item.quote_id,\n insurance_class_id: item.insurance_class_id,\n insurance_class: {\n id: item.insurance_class_id,\n group_class_id: quote.group_class_id,\n code: item.insurance_code,\n name: item.insurance_name,\n minimum_rate: item.minimum_rate\n },\n sum_insured: item.sum_insured,\n rate: item.rate,\n premium: item.premium\n }));\n \n return {\n ...quote,\n group_class: {\n id: quote.group_class_id,\n code: quote.group_code,\n name: quote.group_name,\n description: quote.group_description\n },\n items\n };\n}\n\nexport async function getQuotesByIntermediaryId(intermediaryId: number): Promise {\n const quotesResult = await sqlite.execute(`\n SELECT q.*, gc.code as group_code, gc.name as group_name\n FROM ${TABLES.quotes} q\n JOIN ${TABLES.group_classes} gc ON q.group_class_id = gc.id\n WHERE q.intermediary_id = ?\n ORDER BY q.created_at DESC\n `, [intermediaryId]);\n \n return quotesResult;\n}\n\nexport async function getQuotesForUnderwriter(): Promise {\n const quotesResult = await sqlite.execute(`\n SELECT q.*, gc.code as group_code, gc.name as group_name\n FROM ${TABLES.quotes} q\n JOIN ${TABLES.group_classes} gc ON q.group_class_id = gc.id\n WHERE q.status IN ('submitted', 'approved', 'rejected')\n ORDER BY q.created_at DESC\n `);\n \n return quotesResult;\n}\n\nexport async function updateQuoteStatus(\n quoteId: number, \n underwriterId: number, \n underwriterName: string, \n data: UpdateQuoteRequest\n): Promise {\n const quote = await getQuoteById(quoteId);\n if (!quote) return null;\n \n let updateFields = ['underwriter_id = ?', 'underwriter_name = ?', 'updated_at = CURRENT_TIMESTAMP'];\n let updateValues = [underwriterId, underwriterName];\n \n if (data.status) {\n updateFields.push('status = ?');\n updateValues.push(data.status);\n \n if (data.status === 'approved') {\n updateFields.push('approved_at = CURRENT_TIMESTAMP');\n }\n }\n \n if (data.underwriter_notes) {\n updateFields.push('underwriter_notes = ?');\n updateValues.push(data.underwriter_notes);\n }\n \n if (data.discount_percentage !== undefined) {\n updateFields.push('discount_percentage = ?');\n updateValues.push(data.discount_percentage);\n }\n \n if (data.load_percentage !== undefined) {\n updateFields.push('load_percentage = ?');\n updateValues.push(data.load_percentage);\n }\n \n // If discount or load is applied, recalculate premiums\n if (data.discount_percentage !== undefined || data.load_percentage !== undefined) {\n // Update quote items with new rates\n for (const item of quote.items) {\n const newRate = applyDiscountOrLoad(\n item.insurance_class.minimum_rate, \n data.discount_percentage, \n data.load_percentage\n );\n const newPremium = calculatePremium(item.sum_insured, newRate);\n \n await sqlite.execute(`\n UPDATE ${TABLES.quote_items} \n SET rate = ?, premium = ? \n WHERE id = ?\n `, [newRate, newPremium, item.id]);\n }\n \n // Recalculate quote totals\n const newTotalPremium = quote.items.reduce((sum, item) => {\n const newRate = applyDiscountOrLoad(\n item.insurance_class.minimum_rate, \n data.discount_percentage, \n data.load_percentage\n );\n return sum + calculatePremium(item.sum_insured, newRate);\n }, 0);\n \n const newLevies = calculateLevies(newTotalPremium);\n const newTotalAmount = calculateTotalAmount(newTotalPremium);\n \n updateFields.push('total_premium = ?', 'tl_levy = ?', 'phcf_levy = ?', 'total_amount = ?');\n updateValues.push(newTotalPremium, newLevies.tl_levy, newLevies.phcf_levy, newTotalAmount);\n }\n \n updateValues.push(quoteId);\n \n await sqlite.execute(`\n UPDATE ${TABLES.quotes} \n SET ${updateFields.join(', ')}\n WHERE id = ?\n `, updateValues);\n \n return await getQuoteById(quoteId);\n}\n\nexport async function submitQuote(quoteId: number): Promise {\n await sqlite.execute(`\n UPDATE ${TABLES.quotes} \n SET status = 'submitted', updated_at = CURRENT_TIMESTAMP\n WHERE id = ? AND status = 'draft'\n `, [quoteId]);\n \n return await getQuoteById(quoteId);\n}\n\n// Product management queries\nexport async function createGroupClass(code: string, name: string, description?: string): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLES.group_classes} (code, name, description)\n VALUES (?, ?, ?)\n `, [code, name, description || null]);\n \n return await getGroupClassById(result.lastInsertRowid as number) as GroupClass;\n}\n\nexport async function createInsuranceClass(\n groupClassId: number, \n code: string, \n name: string, \n minimumRate: number\n): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLES.insurance_classes} (group_class_id, code, name, minimum_rate)\n VALUES (?, ?, ?, ?)\n `, [groupClassId, code, name, minimumRate]);\n \n return await getInsuranceClassById(result.lastInsertRowid as number) as InsuranceClass;\n}\n\nexport async function updateInsuranceClassRate(id: number, minimumRate: number): Promise {\n await sqlite.execute(`\n UPDATE ${TABLES.insurance_classes} \n SET minimum_rate = ?\n WHERE id = ?\n `, [minimumRate, id]);\n \n return await getInsuranceClassById(id);\n}",[],[172,366,358],"database","ca5fd3da-3f87-11f0-bacf-76b3cceeab13","migrations.ts","ca5fd498-3f87-11f0-bacf-76b3cceeab13",5,["D",1748851289679],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names with version suffix for schema changes\nconst TABLES = {\n users: 'users_v1',\n group_classes: 'group_classes_v1',\n insurance_classes: 'insurance_classes_v1',\n quotes: 'quotes_v1',\n quote_items: 'quote_items_v1'\n};\n\nexport async function runMigrations() {\n console.log('Running database migrations...');\n\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.users} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n role TEXT NOT NULL CHECK (role IN ('intermediary', 'underwriter')),\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Group Classes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.group_classes} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n code TEXT UNIQUE NOT NULL,\n name TEXT NOT NULL,\n description TEXT\n )\n `);\n\n // Insurance Classes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.insurance_classes} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n group_class_id INTEGER NOT NULL,\n code TEXT NOT NULL,\n name TEXT NOT NULL,\n minimum_rate REAL NOT NULL,\n FOREIGN KEY (group_class_id) REFERENCES ${TABLES.group_classes}(id),\n UNIQUE(group_class_id, code)\n )\n `);\n\n // Quotes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.quotes} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n quote_number TEXT UNIQUE NOT NULL,\n intermediary_id INTEGER NOT NULL,\n intermediary_name TEXT NOT NULL,\n \n client_name TEXT NOT NULL,\n client_email TEXT NOT NULL,\n client_phone TEXT NOT NULL,\n client_address TEXT NOT NULL,\n business_type TEXT NOT NULL,\n \n group_class_id INTEGER NOT NULL,\n total_premium REAL NOT NULL DEFAULT 0,\n tl_levy REAL NOT NULL DEFAULT 0,\n phcf_levy REAL NOT NULL DEFAULT 0,\n sd_levy REAL NOT NULL DEFAULT 0,\n total_amount REAL NOT NULL DEFAULT 0,\n \n status TEXT NOT NULL DEFAULT 'draft' CHECK (status IN ('draft', 'submitted', 'approved', 'rejected')),\n underwriter_id INTEGER,\n underwriter_name TEXT,\n underwriter_notes TEXT,\n discount_percentage REAL,\n load_percentage REAL,\n \n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n approved_at DATETIME,\n \n FOREIGN KEY (intermediary_id) REFERENCES ${TABLES.users}(id),\n FOREIGN KEY (underwriter_id) REFERENCES ${TABLES.users}(id),\n FOREIGN KEY (group_class_id) REFERENCES ${TABLES.group_classes}(id)\n )\n `);\n\n // Quote Items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.quote_items} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n quote_id INTEGER NOT NULL,\n insurance_class_id INTEGER NOT NULL,\n sum_insured REAL NOT NULL,\n rate REAL NOT NULL,\n premium REAL NOT NULL,\n FOREIGN KEY (quote_id) REFERENCES ${TABLES.quotes}(id) ON DELETE CASCADE,\n FOREIGN KEY (insurance_class_id) REFERENCES ${TABLES.insurance_classes}(id)\n )\n `);\n\n console.log('Database migrations completed');\n}\n\nexport async function seedData() {\n console.log('Seeding initial data...');\n\n // Check if data already exists\n const existingUsers = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLES.users}`);\n if (existingUsers[0].count > 0) {\n console.log('Data already exists, skipping seed');\n return;\n }\n\n // Create default users (in production, use proper password hashing)\n await sqlite.execute(`\n INSERT INTO ${TABLES.users} (username, password_hash, role, name, email) VALUES\n ('intermediary1', 'password123', 'intermediary', 'John Intermediary', 'john@intermediary.com'),\n ('underwriter1', 'password123', 'underwriter', 'Jane Underwriter', 'jane@underwriter.com')\n `);\n\n // Create Engineering Group Class\n await sqlite.execute(`\n INSERT INTO ${TABLES.group_classes} (code, name, description) VALUES\n ('ENG', 'Engineering Class Group', 'Engineering and construction related insurance classes')\n `);\n\n const groupResult = await sqlite.execute(`SELECT id FROM ${TABLES.group_classes} WHERE code = 'ENG'`);\n const groupId = groupResult[0].id;\n\n // Create Insurance Classes for Engineering Group\n await sqlite.execute(`\n INSERT INTO ${TABLES.insurance_classes} (group_class_id, code, name, minimum_rate) VALUES\n (${groupId}, '21', 'Plant and Machinery', 0.0015),\n (${groupId}, '22', 'Loss of profit', 0.0015),\n (${groupId}, '23', 'Electronic Equipment', 0.002),\n (${groupId}, '24', 'Other; Specify', 0.002),\n (${groupId}, '25', 'Contractors/Erection All Risks', 0.00175)\n `);\n\n // Add more group classes\n await sqlite.execute(`\n INSERT INTO ${TABLES.group_classes} (code, name, description) VALUES\n ('MOTOR', 'Motor Insurance', 'Vehicle and motor insurance classes'),\n ('FIRE', 'Fire Insurance', 'Fire and allied perils insurance classes')\n `);\n\n console.log('Initial data seeded successfully');\n}\n\nexport { TABLES };",[],[172,366,368],"ca600e36-3f87-11f0-bacf-76b3cceeab13",["D",1748851289679],[201,202],[172,366],"ca60053a-3f87-11f0-bacf-76b3cceeab13",["D",1748851289679],[200,203,207],[172],["D",1748850597375],{"_11":12,"_142":72},{"_11":12,"_138":-5,"_71":72,"_31":70,"_139":140,"_141":30},{"_41":129,"_13":16,"_35":38,"_130":95,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":-5,"_136":14,"_137":12},"ctx",{"_54":-5,"_161":420,"_421":422,"_423":424,"_425":30,"_426":30,"_427":30,"_428":24,"_429":-5,"_430":-7,"_431":-7,"_432":26,"_433":30,"_434":30,"_435":-5,"_436":30,"_437":30,"_438":30,"_439":-5},"ENV",{"_391":392,"_393":394,"_395":16,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411,"_412":413,"_414":415,"_416":417,"_418":419},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

\n {userRole === 'intermediary' ? 'My Quotes' : 'All Quotes'}\n

No quotes

\n {quote.quote_number}\n

Create New Quote

Client Information

Insurance Classes

Quote Summary

\n Quote {quote.quote_number}\n

Insurance Quote

\n Client Information\n

\n Insurance Coverage\n

\n Quote Summary\n

\n Actions\n

\n Underwriter Review\n

\n Review History\n

Access Denied

Product Management

Group Classes

\n Create New Group Class\n

\n {group.code} - {group.name}\n

Insurance Classes

\n Create New Insurance Class\n

\n Quote Management System\n

Demo Accounts:

History · routes