[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",7,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","backend/routes/auth.ts","latestPath","fileId","ee78161a-3f87-11f0-9fb5-76b3cceeab13","name","auth.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sign, verify } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { findUserByUsername } from \"../database/queries.ts\";\nimport type { LoginRequest, LoginResponse } from \"../../shared/types.ts\";\n\nconst auth = new Hono();\n\nconst JWT_SECRET = Deno.env.get('JWT_SECRET') || 'your-secret-key-change-in-production';\n\n// Simple password verification (in production, use proper hashing)\nfunction verifyPassword(password: string, hash: string): boolean {\n return password === hash; // Replace with proper bcrypt verification\n}\n\nauth.post('/login', async (c) => {\n try {\n const { username, password }: LoginRequest = await c.req.json();\n \n if (!username || !password) {\n return c.json({ error: 'Username and password required' }, 400);\n }\n \n const user = await findUserByUsername(username);\n if (!user || !verifyPassword(password, user.password_hash)) {\n return c.json({ error: 'Invalid credentials' }, 401);\n }\n \n // Create JWT token\n const token = await sign(\n { \n userId: user.id, \n username: user.username, \n role: user.role,\n exp: Math.floor(Date.now() / 1000) + (24 * 60 * 60) // 24 hours\n },\n JWT_SECRET\n );\n \n const response: LoginResponse = {\n user: {\n id: user.id,\n username: user.username,\n role: user.role,\n name: user.name,\n email: user.email,\n created_at: user.created_at\n },\n token\n };\n \n return c.json(response);\n } catch (error) {\n console.error('Login error:', error);\n return c.json({ error: 'Login failed' }, 500);\n }\n});\n\nauth.post('/verify', async (c) => {\n try {\n const authHeader = c.req.header('Authorization');\n if (!authHeader || !authHeader.startsWith('Bearer ')) {\n return c.json({ error: 'No token provided' }, 401);\n }\n \n const token = authHeader.substring(7);\n const payload = await verify(token, JWT_SECRET);\n \n return c.json({ valid: true, payload });\n } catch (error) {\n return c.json({ error: 'Invalid token' }, 401);\n }\n});\n\n// Middleware to verify JWT token\nexport async function authMiddleware(c: any, next: any) {\n try {\n const authHeader = c.req.header('Authorization');\n if (!authHeader || !authHeader.startsWith('Bearer ')) {\n return c.json({ error: 'No token provided' }, 401);\n }\n \n const token = authHeader.substring(7);\n const payload = await verify(token, JWT_SECRET);\n \n c.set('user', payload);\n await next();\n } catch (error) {\n return c.json({ error: 'Invalid token' }, 401);\n }\n}\n\n// Middleware to check user role\nexport function requireRole(role: string) {\n return async (c: any, next: any) => {\n const user = c.get('user');\n if (!user || user.role !== role) {\n return c.json({ error: 'Insufficient permissions' }, 403);\n }\n await next();\n };\n}\n\nexport default auth;","createdAt",["D",1748851350239],"branchVersion","branchId","2db99dbe-3f86-11f0-8623-76b3cceeab13",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"backend/routes","ec25e144-40f7-4a58-a73a-83740b8c7723","routes","directory",["D",1748851350239],"id","2db9599e-3f86-11f0-8623-76b3cceeab13","Intermediary_Quote_Management",["D",1748850597375],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9e6e0a10-3f84-11f0-b6e9-ab0b2f88b858","pinnedFileId","1133d7c0-3f88-11f0-95b6-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5138f308-6b29-49dd-b888-4533bcfac7b4","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kismoflan","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHdXdXkxVTlYSDRsaWZpV2hsN2xGdFdCMFQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_38":235,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":236,"_86":237,"_88":238,"_90":25},"tree",[176,182,184,185],"files",[176,177,178,179,180,181,182,183,184,185],"counts",{"_166":68,"_167":143,"_168":68,"_169":170,"_171":172},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":160,"_32":161,"_30":162,"_139":-5,"_41":42,"_40":163,"_141":64,"_38":164,"_13":68,"_34":47,"_36":-5,"_24":25,"_145":-5,"_27":165},{"_49":154,"_32":155,"_30":156,"_139":-5,"_41":42,"_40":157,"_141":64,"_38":158,"_13":68,"_34":47,"_36":-5,"_24":25,"_145":-5,"_27":159},{"_49":147,"_32":148,"_30":149,"_139":-5,"_41":42,"_40":150,"_141":64,"_38":151,"_13":68,"_34":21,"_36":152,"_24":25,"_145":-5,"_27":153},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":64,"_38":142,"_13":143,"_34":35,"_36":144,"_24":25,"_145":-5,"_27":146},"98533c5c-3f86-11f0-b872-76b3cceeab13","main.tsx","2dbb4812-3f86-11f0-8623-76b3cceeab13","parentId",2,"latest",["D",1748850776216],1,"Create an intermediary quote management app that allows underwriter to approve quotes created by an intermediary, add products, discount quote and load the quotes","label",[137],"b26d7b92-3f87-11f0-bacf-76b3cceeab13","README.md","b26d7c5a-3f87-11f0-bacf-76b3cceeab13",3,["D",1748851249507],"# Quote Management System\n\nA comprehensive quote management application for intermediaries and underwriters.\n\n## Features\n\n- **Intermediary Portal**: Create quotes with KYC, select insurance classes, calculate premiums\n- **Underwriter Portal**: Review, approve, discount, or load quotes\n- **Product Management**: Manage group classes and insurance classes with minimum rates\n- **Quote Calculation**: Automatic calculation with levies (TL 0.2%, PHCF 0.25%, SD 40)\n- **Quote Export**: Print and download approved quotes\n\n## Structure\n\n- `backend/` - Hono API server with database operations\n- `frontend/` - React frontend with intermediary and underwriter interfaces\n- `shared/` - Shared types and utilities\n\n## Database Schema\n\n- `group_classes` - Insurance group classifications\n- `insurance_classes` - Specific insurance types with minimum rates\n- `quotes` - Quote records with KYC and calculation details\n- `users` - User authentication (intermediary/underwriter roles)\n\n## Usage\n\n1. Intermediaries log in and create quotes\n2. Select group class and insurance classes\n3. Enter sum insured amounts\n4. System calculates premiums with levies\n5. Submit for underwriter review\n6. Underwriters can approve, discount, or load quotes\n7. Approved quotes can be printed/downloaded",[148],"bc576834-3f87-11f0-a49c-76b3cceeab13","shared","24d0a50c-e22c-43a9-922d-8efd9328e9c5",4,["D",1748851266117],[155],"ca60053a-3f87-11f0-bacf-76b3cceeab13","backend","3694c80b-9930-49e2-9f84-b149cc3ac9e6",5,["D",1748851289679],[161],"pulls","branches","forks","envVars",{"_173":68,"_175":68},"connections",{"_173":68,"_174":68},"count","unfilledCount","emptyCount",{"_49":160,"_32":161,"_30":162,"_139":-5,"_41":42,"_40":163,"_141":64,"_38":232,"_13":68,"_34":47,"_36":-5,"_24":25,"_145":-5,"_187":233,"_27":234},{"_49":228,"_32":220,"_30":214,"_139":162,"_41":42,"_40":163,"_141":64,"_38":229,"_13":68,"_34":47,"_36":-5,"_24":25,"_145":-5,"_187":230,"_27":231},{"_49":221,"_32":222,"_30":223,"_139":214,"_41":42,"_40":163,"_141":64,"_38":224,"_13":68,"_34":35,"_36":225,"_24":25,"_145":-5,"_187":226,"_27":227},{"_49":211,"_32":212,"_30":213,"_139":214,"_41":42,"_40":215,"_141":64,"_38":216,"_13":68,"_34":35,"_36":217,"_24":25,"_145":-5,"_187":218,"_27":219},{"_49":207,"_32":46,"_30":45,"_139":162,"_41":42,"_40":14,"_141":64,"_38":208,"_13":68,"_34":47,"_36":-5,"_24":25,"_145":-5,"_187":209,"_27":210},{"_49":203,"_32":33,"_30":31,"_139":45,"_41":42,"_40":14,"_141":64,"_38":204,"_13":68,"_34":35,"_36":37,"_24":25,"_145":-5,"_187":205,"_27":206},{"_49":154,"_32":155,"_30":156,"_139":-5,"_41":42,"_40":157,"_141":64,"_38":200,"_13":68,"_34":47,"_36":-5,"_24":25,"_145":-5,"_187":201,"_27":202},{"_49":193,"_32":194,"_30":195,"_139":156,"_41":42,"_40":157,"_141":64,"_38":196,"_13":68,"_34":35,"_36":197,"_24":25,"_145":-5,"_187":198,"_27":199},{"_49":147,"_32":148,"_30":149,"_139":-5,"_41":42,"_40":150,"_141":64,"_38":190,"_13":68,"_34":21,"_36":152,"_24":25,"_145":-5,"_187":191,"_27":192},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":64,"_38":186,"_13":143,"_34":35,"_36":144,"_24":25,"_145":-5,"_187":188,"_27":189},["D",1748850776216],"children",[],[137],["D",1748851249507],[],[148],"bc5754e8-3f87-11f0-a49c-76b3cceeab13","types.ts","bc57559c-3f87-11f0-a49c-76b3cceeab13",["D",1748851266117],"// Shared types for the quote management system\n\nexport interface User {\n id: number;\n username: string;\n role: 'intermediary' | 'underwriter';\n name: string;\n email: string;\n created_at: string;\n}\n\nexport interface GroupClass {\n id: number;\n code: string;\n name: string;\n description?: string;\n}\n\nexport interface InsuranceClass {\n id: number;\n group_class_id: number;\n code: string;\n name: string;\n minimum_rate: number; // Percentage as decimal (e.g., 0.0015 for 0.15%)\n}\n\nexport interface QuoteItem {\n id?: number;\n quote_id?: number;\n insurance_class_id: number;\n insurance_class: InsuranceClass;\n sum_insured: number;\n rate: number; // Applied rate (may be discounted/loaded)\n premium: number;\n}\n\nexport interface Quote {\n id: number;\n quote_number: string;\n intermediary_id: number;\n intermediary_name: string;\n \n // KYC Information\n client_name: string;\n client_email: string;\n client_phone: string;\n client_address: string;\n business_type: string;\n \n // Quote Details\n group_class_id: number;\n group_class: GroupClass;\n items: QuoteItem[];\n \n // Calculations\n total_premium: number;\n tl_levy: number; // 0.2%\n phcf_levy: number; // 0.25%\n sd_levy: number; // 40 flat\n total_amount: number;\n \n // Status and Approval\n status: 'draft' | 'submitted' | 'approved' | 'rejected';\n underwriter_id?: number;\n underwriter_name?: string;\n underwriter_notes?: string;\n discount_percentage?: number;\n load_percentage?: number;\n \n created_at: string;\n updated_at: string;\n approved_at?: string;\n}\n\nexport interface CreateQuoteRequest {\n client_name: string;\n client_email: string;\n client_phone: string;\n client_address: string;\n business_type: string;\n group_class_id: number;\n items: {\n insurance_class_id: number;\n sum_insured: number;\n }[];\n}\n\nexport interface UpdateQuoteRequest {\n status?: 'approved' | 'rejected';\n underwriter_notes?: string;\n discount_percentage?: number;\n load_percentage?: number;\n}\n\nexport interface LoginRequest {\n username: string;\n password: string;\n}\n\nexport interface LoginResponse {\n user: User;\n token: string;\n}\n\n// Calculation constants\nexport const LEVY_RATES = {\n TL: 0.002, // 0.2%\n PHCF: 0.0025, // 0.25%\n SD: 40 // Flat amount\n} as const;\n\n// Utility functions\nexport function calculatePremium(sumInsured: number, rate: number): number {\n return sumInsured * rate;\n}\n\nexport function calculateLevies(totalPremium: number) {\n return {\n tl_levy: totalPremium * LEVY_RATES.TL,\n phcf_levy: totalPremium * LEVY_RATES.PHCF,\n sd_levy: LEVY_RATES.SD\n };\n}\n\nexport function calculateTotalAmount(totalPremium: number) {\n const levies = calculateLevies(totalPremium);\n return totalPremium + levies.tl_levy + levies.phcf_levy + levies.sd_levy;\n}\n\nexport function applyDiscountOrLoad(\n originalRate: number, \n discountPercentage?: number, \n loadPercentage?: number\n): number {\n if (discountPercentage) {\n return originalRate * (1 - discountPercentage / 100);\n }\n if (loadPercentage) {\n return originalRate * (1 + loadPercentage / 100);\n }\n return originalRate;\n}\n\nexport function formatCurrency(amount: number): string {\n return new Intl.NumberFormat('en-KE', {\n style: 'currency',\n currency: 'KES'\n }).format(amount);\n}\n\nexport function formatPercentage(rate: number): string {\n return `${(rate * 100).toFixed(5)}%`;\n}",[],[155,194],["D",1748851266117],[183],[155],"ee781552-3f87-11f0-9fb5-76b3cceeab13",["D",1748851350239],[],[161,46,33],"ee781ff2-3f87-11f0-9fb5-76b3cceeab13",["D",1748851350239],[181],[161,46],"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}",[],[161,220,212],"database","ca5fd3da-3f87-11f0-bacf-76b3cceeab13","migrations.ts","ca5fd498-3f87-11f0-bacf-76b3cceeab13",["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 };",[],[161,220,222],"ca600e36-3f87-11f0-bacf-76b3cceeab13",["D",1748851289679],[178,179],[161,220],["D",1748851289679],[177,180],[161],["D",1748850597375],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":272,"_273":274,"_275":276,"_277":25,"_278":25,"_279":25,"_280":64,"_281":-5,"_282":-7,"_283":-7,"_284":68,"_285":25,"_286":25,"_287":-5,"_288":25,"_289":25,"_290":25,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":92,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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"]

Diff · v7