Safety Inspection Report — ${escapeHtml(p.name)}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":97,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_116":117,"_118":119,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","dc38e8fa-5127-11f1-a303-ee650bb23af1","name","fileType","http","content","// ─────────────────────────────────────────────────────────────\n// VAL: safety-completion-handler (HTTP val)\n//\n// Called by the safety-checklist page whenever a property\n// crosses into 100% complete. Steps:\n// 1. Re-read Firebase to confirm 100% (browser may be stale)\n// 2. Check the cooldown stamp so we don't re-generate spam PDFs\n// 3. Build the polished HTML report\n// 4. Convert HTML → PDF via Google Drive (upload as Doc, export PDF, cleanup)\n// 5. Move the PDF into the target Shared Drive folder\n// 6. Post the Drive link to #br-safety-inspections\n// 7. Stamp Firebase with _pdf_ = { ts, fileId, url }\n//\n// IMPORTANT: Drive uses Service Account auth. The SA must be added\n// as a content manager/editor on the Shared Drive folder\n// (1nJmXTZdRUiLM11Z2j3FmACKef6yo8F8J).\n// ─────────────────────────────────────────────────────────────\n\nconst FIREBASE_URL =\n \"https://safety-inspection-checklist-default-rtdb.firebaseio.com\";\nconst FIREBASE_PATH = \"safety-inspection-v2\";\nconst DRIVE_FOLDER_ID = \"1qpC0yq58OeMlBU8hNBTOznjqBfKERNnp\";\nconst SLACK_WEBHOOK =\n \"https://hooks.slack.com/services/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\";\n\nconst SA_EMAIL =\n \"bourbon-rentals-sheets@pure-silicon-433919-m9.iam.gserviceaccount.com\";\nconst SA_PRIVATE_KEY = `-----BEGIN PRIVATE KEY-----\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQC0l8/qx0StdCme\n8ur38o8LnFkGZjzNV+s6TnGOGXUtQMv8WCi12qCmdeFg4ZqQ7w0TTYzWqUE5lKgJ\nD3dJI/18tdLT8KX9WD7+RnupTNNMUa3vYehjkeVVwz+ymSvt1r8vub47MmLhuvbY\nQ+yN2Vh1HA5oKmZNucsy98qkFRH9NGY1ggBhtkoDEgXY7T/EaeYAhkhuQ5Reir8a\nlz/kiQ/xVswHW0+HkQVKWpywvoS+4sY2PwnYdG1PFIenyHK2bbCesnlnWrt1nJhs\nHO4Qpf2q/moMtkS98N6F2kwCCAfliMBhZZspzKBX4sxTwuBUn1DtZtP8xoizhUwR\nEq/QmIw3AgMBAAECggEADy43vw+TGVWLbh4TXFZaaepxnVUYxVYfot4XM4+2RuCM\nhSDQA0FmgbelA2TTfl1p5vZ84UqG/hUd7u0K5O4Oj94k48X13g799JfuKzQXCvJO\nwbGkPEJ2Wbg48YVoqOyFU7i0YfuBTmJN/63uA5qCkg2StHTj9qKojxc/RH207mjF\n/zy+pn35Mo0MkdAodGHssoYEu7RVbAGyODasfy1bNfhTbkqCH8qscY5++Cvem4Hz\nGOopKzibUlN/E/+i+at3LcR+DMy01ddX258gAbH/hZxfNTG+LqDip1OZU1qEd74A\njurm3pLX0nl90kwZ+uvkz+VG/sXdEJ0IfsOnf+uWeQKBgQDi5uiw8tblCkRfLIAl\nxZj6n2Zqf1sSzcGta+M9I2LUI8Vi86P/Bc/FXDqT4uJqzadRyOICd7FBIRq2AAvA\n/PiL1eNxdqQRvqH+9JShc+m4n0PiVF4vf3G5WBmqXEPOqA6WdwktBLTrHyenN33B\nU2v6VYOIDknpgjS0nCMB5MQ47QKBgQDLwJmv8GZ+1LtKQJVU5LqoKe6Y8GRjQG8v\nzH65SxPQTdhZwoluDCZy/Ubno/Or7oLZpNX8HViAA3b9IKnr+5wLrhqlLeDrrQay\nDQZ7IvBaEXMFrB/6Frc4gAm+dfTujT5MEwAa/TBRe8WWOg97hjOtCUTjL+wcCKZG\ns81rTchpMwKBgQCsWSCeZ5Z7WxUcBb1A85qDo9gzRJF08v0OMUjmA57p7FHeG5qR\n92QeUTPdaRT6c0OIh8HEhg4Jno+fduF2sbBI5ypf4PI22EpMUpMjH9yD89WocNUp\n1vAXDKhSEsseieCqwbgijdSuU3fXN/s5gZgfCh1ilxflWpWWKpMcuRui8QKBgGQF\njGyeKvKgI8Dzq1sdXbQnwYU6nU1L2EkyrhLwFC3xyP9nTGfFdyqDw0b7aSdB0uJc\n1N8K2OMe0E66ti+uOJBTS6lCuGN5cQv+8OuJ30uXvUtPj/MJK7CEykPBTBe/JpHZ\n0fdty0Z06C4zGl6dJskO/843PEUWyelzYqgGaxeZAoGAchlfJIJ0V+N8QW/HCl/S\nWzcg03XKOM4SNdIXTwJqJnLsMURAeNc0F+UUI4uDI0L+C3EjY631eIF+WoONcP8f\nxDyGMiyN1Ysk70KC++Fse7B85fZoHDTR8k2CrClEZVs6KeVBkZJkLfKG02xYA0rh\nXUoU/RirsjyKrjZTDqut9vE=\n-----END PRIVATE KEY-----`;\n\n// ─── PROPERTIES (must match safety-checklist) ───\nconst PROPERTIES = [\n {\n id: \"park\",\n name: \"Park Place Lodge\",\n canonical: \"1820 E Park Pl (Indiana)\",\n addr: \"1820 E Park Pl, Jeffersonville IN\",\n floors: 2,\n beds: 9,\n },\n {\n id: \"prl\",\n name: \"Persimmon Ridge Lodge\",\n canonical: \"70 Persimmon Ridge Dr (Shelby)\",\n addr: \"70 Persimmon Ridge Dr\",\n floors: 3,\n beds: 7,\n },\n {\n id: \"oak\",\n name: \"The Oak Barrel Lodge\",\n canonical: \"320 Gordon Gutmann Blvd (Indiana)\",\n addr: \"320 Gordon Gutmann Blvd, Jeffersonville IN\",\n floors: 2,\n beds: 6,\n },\n {\n id: \"manor\",\n name: \"Louisville Country Manor\",\n canonical: \"17008 Shelbyville Rd (Jefferson)\",\n addr: \"17008 Shelbyville Rd\",\n floors: 3,\n beds: 7,\n },\n {\n id: \"louisx\",\n name: \"The Louis X — Hotel Buyout\",\n canonical: \"Exclusive Group Hotel Buyout | Private Bar + Event Space\",\n addr: \"751 Vine St\",\n floors: 3,\n beds: 8,\n },\n {\n id: \"lavish\",\n name: \"The Norton Commons Lavish\",\n canonical: \"6408 Passionflower Dr (Jefferson)\",\n addr: \"6408 Passionflower Dr\",\n floors: 3,\n beds: 4,\n },\n {\n id: \"luxe\",\n name: \"The Norton Commons Luxe\",\n canonical: \"9407 Delphinium St (Jefferson)\",\n addr: \"9407 Delphinium St\",\n floors: 3,\n beds: 4,\n },\n {\n id: \"spirit\",\n name: \"The Kentucky Spirit Retreat\",\n canonical: \"9315 Dayflower St (Jefferson)\",\n addr: \"9315 Dayflower St\",\n floors: 3,\n beds: 3,\n },\n {\n id: \"ferndale\",\n name: \"Bourbon Trail Central\",\n canonical: \"9100 Ferndale Rd (Jefferson)\",\n addr: \"9100 Ferndale Rd\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"sleepy\",\n name: \"Harris House — Creekside Retreat\",\n canonical: \"4700 Sleepy Hollow Rd (Oldham)\",\n addr: \"4700 Sleepy Hollow Rd\",\n floors: 2,\n beds: 5,\n },\n {\n id: \"hannah\",\n name: \"Farmhouse Hannah\",\n canonical: \"367 Hannah Rd (Shelby)\",\n addr: \"367 Hannah Rd\",\n floors: 3,\n beds: 3,\n },\n {\n id: \"liberty\",\n name: \"Liberty Belle\",\n canonical: \"902 E Liberty St (Jefferson)\",\n addr: \"902 E Liberty St\",\n floors: 2,\n beds: 3,\n },\n {\n id: \"shelby74\",\n name: \"Bourbon House 2\",\n canonical: \"2074 S Shelby St (Jefferson)\",\n addr: \"2074 S Shelby St\",\n floors: 3,\n beds: 4,\n },\n {\n id: \"shelby76\",\n name: \"Bourbon House 3\",\n canonical: \"2076 S Shelby St (Jefferson)\",\n addr: \"2076 S Shelby St\",\n floors: 2,\n beds: 5,\n },\n {\n id: \"welling\",\n name: \"Bourbon House 4 — The Wellingmoor\",\n canonical: \"3216 Wellingmoor Ave (Jefferson)\",\n addr: \"3216 Wellingmoor Ave\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"booker\",\n name: \"11004 Booker Rd\",\n canonical: \"11004 Booker Rd (Jefferson)\",\n addr: \"11004 Booker Rd\",\n floors: 3,\n beds: 3,\n },\n {\n id: \"cres1\",\n name: \"210 Crescent Ct #1\",\n canonical: \"210 Crescent Ct. #1 (Jefferson)\",\n addr: \"210 Crescent Ct, Unit 1\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"cres2\",\n name: \"210 Crescent Ct #2\",\n canonical: \"210 Crescent Ct. #2 (Jefferson)\",\n addr: \"210 Crescent Ct, Unit 2\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"lagrange\",\n name: \"Lagrange Loft\",\n canonical: \"121 1/2 E Main St (Oldham, Lagrange)\",\n addr: \"121½ E Main St, Lagrange KY\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"bards\",\n name: \"1829 Bardstown Rd\",\n canonical: \"1829 Bardstown Rd (Jefferson)\",\n addr: \"1829 Bardstown Rd\",\n floors: 1,\n beds: 2,\n },\n {\n id: \"douglass\",\n name: \"1894 Douglass Blvd\",\n canonical: \"1894 Douglass Blvd (Jefferson)\",\n addr: \"1894 Douglass Blvd\",\n floors: 1,\n beds: 2,\n },\n {\n id: \"lyric\",\n name: \"The Lyric 185\",\n canonical: \"6324 Meeting St Unit 185 (Jefferson)\",\n addr: \"6324 Meeting St #185\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"cottage\",\n name: \"On the Rocks Cottage\",\n canonical: \"1238 Settlers Trace Road Cottage #31 (Spencer)\",\n addr: \"1238 Settlers Trace Rd, Cottage #31\",\n floors: 3,\n beds: 1,\n },\n {\n id: \"bourbon\",\n name: \"1203 Bourbon Ave\",\n canonical: \"1203 Bourbon Ave (Jefferson)\",\n addr: \"1203 Bourbon Ave\",\n floors: 2,\n beds: 5,\n },\n {\n id: \"lx22\",\n name: \"Suite 22 — Entertainment Suite\",\n canonical: \"Suite 22 - Entertainment Suite\",\n addr: \"751 Vine St, Ste 22\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx23\",\n name: \"Suite 23 — Thunder Over Louisville\",\n canonical: \"Suite 23 - Thunder Over Louisville Suite\",\n addr: \"751 Vine St, Ste 23\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx24\",\n name: \"Suite 24 — Louisville Slugger\",\n canonical: \"Suite 24 - Louisville Slugger Suite\",\n addr: \"751 Vine St, Ste 24\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx25\",\n name: \"Suite 25 — Kentucky Oaks\",\n canonical: \"Suite 25 - Kentucky Oaks Suite\",\n addr: \"751 Vine St, Ste 25\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx32\",\n name: \"Suite 32 — The Bourbon Suite\",\n canonical: \"Suite 32 - The Bourbon Suite\",\n addr: \"751 Vine St, Ste 32\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx33\",\n name: \"Suite 33 — Thomas Edison\",\n canonical: \"Suite 33 - Thomas Edison Suite\",\n addr: \"751 Vine St, Ste 33\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx34\",\n name: \"Suite 34 — Muhammad Ali\",\n canonical: \"Suite 34 - Muhammad Ali Suite\",\n addr: \"751 Vine St, Ste 34\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx35\",\n name: \"Suite 35 — Kentucky Derby\",\n canonical: \"Suite 35 - Kentucky Derby Suite\",\n addr: \"751 Vine St, Ste 35\",\n floors: 1,\n beds: 1,\n },\n];\n\n// ─── CHECKLIST BUILDER (must match safety-checklist) ───\nfunction buildGroups(pid: string, floors: number, beds: number) {\n const F = floors, B = beds;\n const g: any[] = [];\n const smoke: any[] = [];\n for (let b = 1; b <= B; b++) {\n smoke.push({\n id: `${pid}-sm-br${b}`,\n label: `Bedroom ${b} — Smoke & CO detector`,\n detail:\n \"Test button → must sound. Hardwired OR 10-year lithium-ion combo unit. Battery type: replace battery every 5 yrs.\",\n fields: [\n { id: \"tested\", label: \"Last Tested\", type: \"date\" },\n { id: \"exp\", label: \"Expiration Date\", type: \"date_exp\" },\n { id: \"power\", label: \"Power\", type: \"select\" },\n { id: \"battery\", label: \"Battery Last Replaced\", type: \"date\" },\n ],\n });\n }\n for (let f = 1; f <= F; f++) {\n smoke.push({\n id: `${pid}-sm-hall${f}`,\n label: `Floor ${f} — Hallway / Common Area detector`,\n detail:\n \"Test button → must sound. Hardwired OR 10-year lithium-ion combo unit. Battery type: replace battery every 5 yrs.\",\n fields: [\n { id: \"tested\", label: \"Last Tested\", type: \"date\" },\n { id: \"exp\", label: \"Expiration Date\", type: \"date_exp\" },\n { id: \"power\", label: \"Power\", type: \"select\" },\n { id: \"battery\", label: \"Battery Last Replaced\", type: \"date\" },\n ],\n });\n }\n g.push({\n id: `${pid}-smoke`,\n label: \"🔥 Smoke & CO Detectors\",\n tasks: smoke,\n });\n\n const ext: any[] = [];\n for (let f = 1; f <= F; f++) {\n ext.push({\n id: `${pid}-ext-fl${f}`,\n label: `Floor ${f} — Hallway extinguisher`,\n detail:\n \"Readily accessible on this floor. Check expiration. Gauge needle in the green.\",\n fields: [{ id: \"inspected\", label: \"Last Inspected\", type: \"date\" }, {\n id: \"exp\",\n label: \"Expiration Date\",\n type: \"date_exp\",\n }, { id: \"gauge\", label: \"Gauge\", type: \"select\" }],\n });\n }\n ext.push({\n id: `${pid}-ext-kit`,\n label: \"Kitchen — wall-mounted extinguisher\",\n detail:\n \"Within 30ft of cooking area. Check expiration. Gauge needle in the green.\",\n fields: [{ id: \"inspected\", label: \"Last Inspected\", type: \"date\" }, {\n id: \"exp\",\n label: \"Expiration Date\",\n type: \"date_exp\",\n }, { id: \"gauge\", label: \"Gauge\", type: \"select\" }],\n });\n g.push({ id: `${pid}-ext`, label: \"🧯 Fire Extinguishers\", tasks: ext });\n\n const fa: any[] = [];\n for (let f = 1; f <= F; f++) {\n fa.push({\n id: `${pid}-fa-fl${f}`,\n label: `Floor ${f} — First aid kit`,\n detail: \"Accessible, stocked, and sealed\",\n fields: [{ id: \"restocked\", label: \"Last Restocked\", type: \"date\" }],\n });\n }\n g.push({ id: `${pid}-fa`, label: \"🩹 First Aid Kits\", tasks: fa });\n\n const ep: any[] = [];\n for (let f = 1; f <= F; f++) {\n ep.push({\n id: `${pid}-esc-fl${f}`,\n label: `Floor ${f} Kitchen — posted emergency escape plan`,\n detail: \"Includes exits, meeting point, and emergency numbers\",\n fields: [{ id: \"updated\", label: \"Last Updated\", type: \"date\" }],\n });\n }\n g.push({\n id: `${pid}-escape`,\n label: \"🚪 Emergency Escape Plans\",\n tasks: ep,\n });\n\n g.push({\n id: `${pid}-gen`,\n label: \"✅ General Safety\",\n tasks: [\n {\n id: `${pid}-gen-exits`,\n label: \"All exits and egress paths clear and unobstructed\",\n detail: \"Doors, windows, hallways — no blockages\",\n },\n {\n id: `${pid}-gen-lights`,\n label: \"Emergency / flashlight lighting functional\",\n detail: \"Test batteries or hardwired backup lighting\",\n },\n {\n id: `${pid}-gen-gas`,\n label: \"Gas shutoff location marked and communicated\",\n detail: \"Noted in guest instructions and posted at property\",\n },\n {\n id: `${pid}-gen-gfci`,\n label: \"GFCI outlets functional — kitchens & bathrooms\",\n detail: \"Press test/reset on each GFCI outlet\",\n },\n {\n id: `${pid}-gen-stairs`,\n label: \"Stair handrails secure and in good condition\",\n detail: \"No loose balusters, no wobble\",\n },\n {\n id: `${pid}-gen-trip`,\n label: \"No trip hazards throughout property\",\n detail: \"Rugs secured, cords managed, pathways clear\",\n },\n {\n id: `${pid}-gen-outdoor`,\n label: \"Exterior / entry lighting functional\",\n detail: \"All exterior bulbs working\",\n },\n {\n id: `${pid}-gen-lockbox`,\n label: \"Lockbox / backup entry tested — code confirmed\",\n detail: \"Confirm code works and is current\",\n },\n {\n id: `${pid}-gen-numbers`,\n label: \"Emergency numbers posted visibly at property\",\n detail: \"Fire, police, host contact line\",\n },\n {\n id: `${pid}-gen-pool`,\n label: \"Pool / hot tub gate latch functional (if applicable)\",\n detail: \"Self-latching gate, no gaps at base, drain covers secure\",\n },\n ],\n });\n return g;\n}\n\nfunction expLabel(d: string) {\n if (!d) return \"\";\n const days = (new Date(d).getTime() - Date.now()) / 864e5;\n if (days < 0) return \"EXPIRED\";\n if (days < 30) return Math.round(days) + \"d left\";\n if (days < 90) return Math.round(days / 30) + \"mo left\";\n return \"Valid\";\n}\n\n// ─── FIREBASE HELPERS ───────────────────────\nasync function fbGet(path: string): Promise {\n const r = await fetch(`${FIREBASE_URL}/${path}.json`);\n if (!r.ok) return null;\n return r.json();\n}\nasync function fbPut(path: string, data: any): Promise {\n await fetch(`${FIREBASE_URL}/${path}.json`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(data),\n });\n}\n\n// ─── GOOGLE SERVICE ACCOUNT JWT → ACCESS TOKEN ───\nasync function getAccessToken(): Promise {\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const now = Math.floor(Date.now() / 1000);\n const claims = {\n iss: SA_EMAIL,\n scope: \"https://www.googleapis.com/auth/drive\",\n aud: \"https://oauth2.googleapis.com/token\",\n iat: now,\n exp: now + 3600,\n };\n const b64url = (s: string) =>\n btoa(s).replace(/=/g, \"\").replace(/\\+/g, \"-\").replace(/\\//g, \"_\");\n const enc = (o: any) => b64url(JSON.stringify(o));\n const signingInput = `${enc(header)}.${enc(claims)}`;\n\n // Import the PEM private key\n const pemBody = SA_PRIVATE_KEY\n .replace(/-----BEGIN PRIVATE KEY-----/, \"\")\n .replace(/-----END PRIVATE KEY-----/, \"\")\n .replace(/\\s+/g, \"\");\n const der = Uint8Array.from(atob(pemBody), (c) => c.charCodeAt(0));\n const key = await crypto.subtle.importKey(\n \"pkcs8\",\n der,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sigBuf = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n key,\n new TextEncoder().encode(signingInput),\n );\n const sig = btoa(String.fromCharCode(...new Uint8Array(sigBuf))).replace(\n /=/g,\n \"\",\n ).replace(/\\+/g, \"-\").replace(/\\//g, \"_\");\n const jwt = `${signingInput}.${sig}`;\n\n const r = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body:\n `grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=${jwt}`,\n });\n if (!r.ok) throw new Error(\"Token exchange failed: \" + await r.text());\n const j = await r.json();\n return j.access_token;\n}\n\n// ─── DRIVE: HTML → PDF VIA GOOGLE DOC CONVERSION ───\n// Path: upload HTML with mimeType=application/vnd.google-apps.document\n// (Drive auto-converts), then export that Doc as PDF, then delete the Doc.\nasync function htmlToPdfViaDrive(\n html: string,\n filename: string,\n token: string,\n): Promise<{ fileId: string; webViewLink: string }> {\n // 1. Upload HTML, asking Drive to convert to a Google Doc.\n // convert=true is the modern equivalent for v3 — set mimeType to google-apps.document.\n const boundary = \"br_\" + Math.random().toString(36).slice(2);\n const meta = {\n name: filename.replace(/\\.pdf$/i, \"\") + \" (tmp)\",\n mimeType: \"application/vnd.google-apps.document\",\n parents: [DRIVE_FOLDER_ID],\n };\n const multipartBody = `--${boundary}\\r\\n` +\n `Content-Type: application/json; charset=UTF-8\\r\\n\\r\\n` +\n `${JSON.stringify(meta)}\\r\\n` +\n `--${boundary}\\r\\n` +\n `Content-Type: text/html\\r\\n\\r\\n` +\n `${html}\\r\\n` +\n `--${boundary}--`;\n\n const uploadRes = await fetch(\n \"https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart&supportsAllDrives=true\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Content-Type\": `multipart/related; boundary=${boundary}`,\n },\n body: multipartBody,\n },\n );\n if (!uploadRes.ok) {\n throw new Error(\"Doc upload failed: \" + await uploadRes.text());\n }\n const doc = await uploadRes.json();\n const docId = doc.id;\n\n // 2. Export the Doc as PDF\n const pdfRes = await fetch(\n `https://www.googleapis.com/drive/v3/files/${docId}/export?mimeType=application/pdf`,\n { headers: { \"Authorization\": `Bearer ${token}` } },\n );\n if (!pdfRes.ok) {\n await fetch(\n `https://www.googleapis.com/drive/v3/files/${docId}?supportsAllDrives=true`,\n { method: \"DELETE\", headers: { Authorization: `Bearer ${token}` } },\n ).catch(() => {});\n throw new Error(\"PDF export failed: \" + await pdfRes.text());\n }\n const pdfBytes = new Uint8Array(await pdfRes.arrayBuffer());\n\n // 3. Delete the temporary Doc\n await fetch(\n `https://www.googleapis.com/drive/v3/files/${docId}?supportsAllDrives=true`,\n {\n method: \"DELETE\",\n headers: { \"Authorization\": `Bearer ${token}` },\n },\n ).catch(() => {}); // best-effort cleanup\n\n // 4. Upload the PDF bytes as a real PDF file in the target folder\n const pdfBoundary = \"br_pdf_\" + Math.random().toString(36).slice(2);\n const pdfMeta = {\n name: filename,\n mimeType: \"application/pdf\",\n parents: [DRIVE_FOLDER_ID],\n };\n // Build a binary-safe multipart body using Blob\n const head = new Blob([\n `--${pdfBoundary}\\r\\n`,\n `Content-Type: application/json; charset=UTF-8\\r\\n\\r\\n`,\n JSON.stringify(pdfMeta),\n `\\r\\n--${pdfBoundary}\\r\\n`,\n `Content-Type: application/pdf\\r\\n\\r\\n`,\n ]);\n const tail = new Blob([`\\r\\n--${pdfBoundary}--`]);\n const body = new Blob([head, pdfBytes, tail]);\n\n const finalRes = await fetch(\n \"https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart&supportsAllDrives=true&fields=id,webViewLink\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Content-Type\": `multipart/related; boundary=${pdfBoundary}`,\n },\n body,\n },\n );\n if (!finalRes.ok) {\n throw new Error(\"PDF upload failed: \" + await finalRes.text());\n }\n const finalFile = await finalRes.json();\n return { fileId: finalFile.id, webViewLink: finalFile.webViewLink };\n}\n\n// ─── BUILD POLISHED HTML REPORT ───────────────\nfunction generateReport(p: any, state: any): string {\n const groups = buildGroups(p.id, p.floors, p.beds);\n const allTasks = groups.flatMap((g) => g.tasks);\n const total = allTasks.length;\n const ts = (id: string) =>\n state[id] ||\n { checked: false, note: \"\", fields: {}, doneBy: \"\", doneAt: \"\" };\n const done = allTasks.filter((t) => ts(t.id).checked).length;\n const pct = total ? Math.round(done / total * 100) : 0;\n const meta = state[\"_meta_\" + p.id] || {};\n const dateStr = meta.inspDate\n ? new Date(meta.inspDate).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n })\n : new Date().toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n });\n const inspector = meta.inspName || \"Bourbon Rentals\";\n const nextDate = meta.nextDate\n ? new Date(meta.nextDate).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n })\n : \"—\";\n const statusColor = pct === 100\n ? \"#3B6D11\"\n : pct >= 50\n ? \"#854F0B\"\n : \"#8b1a1a\";\n const statusLabel = pct === 100 ? \"PASS\" : pct + \"% Complete\";\n\n let groupsHtml = \"\";\n groups.forEach((grp) => {\n let rows = \"\";\n grp.tasks.forEach((task: any) => {\n const s = ts(task.id);\n const flds = s.fields || {};\n const icon = s.checked ? \"✅\" : \"❌\";\n const noteHtml = s.note\n ? `

Note: ${\n escapeHtml(s.note)\n }

`\n : \"\";\n let fieldsHtml = \"\";\n if (task.fields && task.fields.length) {\n const parts = task.fields.map((f: any) => {\n const val = flds[f.id] || \"—\";\n const displayVal = f.type === \"date_exp\" && flds[f.id]\n ? `${flds[f.id]} (${expLabel(flds[f.id])})`\n : val;\n return `${f.label}: ${\n escapeHtml(String(displayVal))\n }`;\n }).join(\"\");\n fieldsHtml =\n `

${parts}

`;\n }\n const doneByHtml = s.checked && s.doneBy\n ? `

By ${\n escapeHtml(s.doneBy)\n }${s.doneAt ? \" · \" + escapeHtml(s.doneAt) : \"\"}

`\n : \"\";\n rows += `\n ${icon}\n \n

${escapeHtml(task.label)}

${\n escapeHtml(task.detail || \"\")\n }

\n ${fieldsHtml}${doneByHtml}${noteHtml}\n \n `;\n });\n const grpDone = grp.tasks.filter((t: any) => ts(t.id).checked).length;\n groupsHtml += `\n

\n ${grp.label}\n ${grpDone}/${grp.tasks.length}\n

\n ${rows}

`;\n });\n\n return `\n\n\n\nSafety Inspection Report — ${escapeHtml(p.name)}\n\n\n\n

Bourbon Rentals

${\n escapeHtml(p.name)\n }

${\n escapeHtml(p.addr)\n }

${p.floors} floor${\n p.floors > 1 ? \"s\" : \"\"\n } · ${p.beds} bedrooms

${statusLabel}

${done} of ${total} items passed

\n\n

Inspection Date

${dateStr}

Inspector

${\n escapeHtml(inspector)\n }

Next Inspection Due

${nextDate}

\n\n ${groupsHtml}\n\n

\n Bourbon Rentals · Louisville, KY · bourbonrentals.com\n Generated ${\n new Date().toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n })\n }\n

\n\n`;\n}\n\nfunction escapeHtml(s: string): string {\n return String(s ?? \"\")\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\n// ─── SLACK ────────────────────────────────────\nasync function postSlack(text: string, blocks?: any) {\n await fetch(SLACK_WEBHOOK, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ text, ...(blocks ? { blocks } : {}) }),\n }).catch((err) => console.error(\"Slack post failed\", err));\n}\n\n// ─── MAIN HANDLER ─────────────────────────────\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"OK — POST {pid} to trigger.\", { status: 200 });\n }\n\n let body: any;\n try {\n body = await req.json();\n } catch {\n return new Response(\"Bad JSON\", { status: 400 });\n }\n const pid: string = body.pid;\n const triggeredBy: string = body.triggeredBy || \"Team\";\n if (!pid) return new Response(\"Missing pid\", { status: 400 });\n\n const p = PROPERTIES.find((x) => x.id === pid);\n if (!p) return new Response(\"Unknown property: \" + pid, { status: 404 });\n\n // Pull full state from Firebase (don't trust the browser's count)\n const state = await fbGet(FIREBASE_PATH);\n if (!state) return new Response(\"No state in Firebase\", { status: 500 });\n\n // Verify 100% server-side\n const groups = buildGroups(p.id, p.floors, p.beds);\n const tasks = groups.flatMap((g) => g.tasks);\n const done = tasks.filter((t) => state[t.id]?.checked).length;\n if (done !== tasks.length) {\n return new Response(\n JSON.stringify({\n ok: false,\n reason: \"not_100pct\",\n done,\n total: tasks.length,\n }),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n // Build + upload\n try {\n const token = await getAccessToken();\n const html = generateReport(p, state);\n // Filename: \"[Canonical Name] — Safety Inspection — MM.DD.YYYY.pdf\"\n // Full date (not just month) so multiple inspections in the same\n // month each get their own clearly-named record.\n const rawName = (p as any).canonical || p.name;\n // Drive accepts most chars but rejects / and \\. Replace those + collapse whitespace.\n const safeName = rawName.replace(/[\\/\\\\]/g, \"-\").replace(/\\s+/g, \" \")\n .trim();\n const d = new Date();\n const mm = String(d.getMonth() + 1).padStart(2, \"0\");\n const dd = String(d.getDate()).padStart(2, \"0\");\n const yyyy = d.getFullYear();\n const filename =\n `${safeName} — Safety Inspection — ${mm}.${dd}.${yyyy}.pdf`;\n\n const { fileId, webViewLink } = await htmlToPdfViaDrive(\n html,\n filename,\n token,\n );\n const driveUrl = webViewLink ||\n `https://drive.google.com/file/d/${fileId}/view`;\n\n // Stamp Firebase with the most recent completion so the monthly\n // alert can check \"is this property past its 6mo nextDate?\"\n await fbPut(`${FIREBASE_PATH}/_pdf_${pid}`, {\n ts: Date.now(),\n fileId,\n url: driveUrl,\n filename,\n triggeredBy,\n });\n\n // Slack\n const meta = state[\"_meta_\" + pid] || {};\n const inspector = meta.inspName || triggeredBy;\n const inspDate = meta.inspDate\n ? new Date(meta.inspDate).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n })\n : new Date().toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n await postSlack(\n `✅ *Safety inspection PASSED* — ${p.name}`,\n [\n {\n type: \"section\",\n text: {\n type: \"mrkdwn\",\n text: `✅ *Safety inspection PASSED — ${p.name}*\\n${p.addr}`,\n },\n },\n {\n type: \"context\",\n elements: [\n { type: \"mrkdwn\", text: `Inspector: *${inspector}*` },\n { type: \"mrkdwn\", text: `Inspected: *${inspDate}*` },\n { type: \"mrkdwn\", text: `${tasks.length}/${tasks.length} items` },\n ],\n },\n {\n type: \"actions\",\n elements: [\n {\n type: \"button\",\n text: { type: \"plain_text\", text: \"📄 Open PDF in Drive\" },\n url: driveUrl,\n style: \"primary\",\n },\n ],\n },\n ],\n );\n\n return new Response(\n JSON.stringify({ ok: true, pid, fileId, driveUrl, filename }),\n {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n } catch (err: any) {\n console.error(\"completion-handler error:\", err);\n await postSlack(\n `⚠️ Safety inspection completed for *${p.name}* but PDF generation failed: ${err.message}`,\n );\n return new Response(JSON.stringify({ ok: false, error: err.message }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n}","// ─────────────────────────────────────────────────────────────\n// VAL: safety-completion-handler (HTTP val)\n//\n// Called by the safety-checklist page whenever a property\n// crosses into 100% complete. Steps:\n// 1. Re-read Firebase to confirm 100% (browser may be stale)\n// 2. Check the cooldown stamp so we don't re-generate spam PDFs\n// 3. Build the polished HTML report\n// 4. Convert HTML → PDF via Google Drive (upload as Doc, export PDF, cleanup)\n// 5. Move the PDF into the target Shared Drive folder\n// 6. Post the Drive link to #br-safety-inspections\n// 7. Stamp Firebase with _pdf_ = { ts, fileId, url }\n//\n// IMPORTANT: Drive uses Service Account auth. The SA must be added\n// as a content manager/editor on the Shared Drive folder\n// (1nJmXTZdRUiLM11Z2j3FmACKef6yo8F8J).\n// ─────────────────────────────────────────────────────────────\n\nconst FIREBASE_URL =\n \"https://safety-inspection-checklist-default-rtdb.firebaseio.com\";\nconst FIREBASE_PATH = \"safety-inspection-v2\";\nconst DRIVE_FOLDER_ID = \"1qpC0yq58OeMlBU8hNBTOznjqBfKERNnp\";\nconst SLACK_WEBHOOK =\n \"https://hooks.slack.com/services/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\";\n\nconst SA_EMAIL =\n \"bourbon-rentals-sheets@pure-silicon-433919-m9.iam.gserviceaccount.com\";\nconst SA_PRIVATE_KEY = `-----BEGIN PRIVATE KEY-----\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQC0l8/qx0StdCme\n8ur38o8LnFkGZjzNV+s6TnGOGXUtQMv8WCi12qCmdeFg4ZqQ7w0TTYzWqUE5lKgJ\nD3dJI/18tdLT8KX9WD7+RnupTNNMUa3vYehjkeVVwz+ymSvt1r8vub47MmLhuvbY\nQ+yN2Vh1HA5oKmZNucsy98qkFRH9NGY1ggBhtkoDEgXY7T/EaeYAhkhuQ5Reir8a\nlz/kiQ/xVswHW0+HkQVKWpywvoS+4sY2PwnYdG1PFIenyHK2bbCesnlnWrt1nJhs\nHO4Qpf2q/moMtkS98N6F2kwCCAfliMBhZZspzKBX4sxTwuBUn1DtZtP8xoizhUwR\nEq/QmIw3AgMBAAECggEADy43vw+TGVWLbh4TXFZaaepxnVUYxVYfot4XM4+2RuCM\nhSDQA0FmgbelA2TTfl1p5vZ84UqG/hUd7u0K5O4Oj94k48X13g799JfuKzQXCvJO\nwbGkPEJ2Wbg48YVoqOyFU7i0YfuBTmJN/63uA5qCkg2StHTj9qKojxc/RH207mjF\n/zy+pn35Mo0MkdAodGHssoYEu7RVbAGyODasfy1bNfhTbkqCH8qscY5++Cvem4Hz\nGOopKzibUlN/E/+i+at3LcR+DMy01ddX258gAbH/hZxfNTG+LqDip1OZU1qEd74A\njurm3pLX0nl90kwZ+uvkz+VG/sXdEJ0IfsOnf+uWeQKBgQDi5uiw8tblCkRfLIAl\nxZj6n2Zqf1sSzcGta+M9I2LUI8Vi86P/Bc/FXDqT4uJqzadRyOICd7FBIRq2AAvA\n/PiL1eNxdqQRvqH+9JShc+m4n0PiVF4vf3G5WBmqXEPOqA6WdwktBLTrHyenN33B\nU2v6VYOIDknpgjS0nCMB5MQ47QKBgQDLwJmv8GZ+1LtKQJVU5LqoKe6Y8GRjQG8v\nzH65SxPQTdhZwoluDCZy/Ubno/Or7oLZpNX8HViAA3b9IKnr+5wLrhqlLeDrrQay\nDQZ7IvBaEXMFrB/6Frc4gAm+dfTujT5MEwAa/TBRe8WWOg97hjOtCUTjL+wcCKZG\ns81rTchpMwKBgQCsWSCeZ5Z7WxUcBb1A85qDo9gzRJF08v0OMUjmA57p7FHeG5qR\n92QeUTPdaRT6c0OIh8HEhg4Jno+fduF2sbBI5ypf4PI22EpMUpMjH9yD89WocNUp\n1vAXDKhSEsseieCqwbgijdSuU3fXN/s5gZgfCh1ilxflWpWWKpMcuRui8QKBgGQF\njGyeKvKgI8Dzq1sdXbQnwYU6nU1L2EkyrhLwFC3xyP9nTGfFdyqDw0b7aSdB0uJc\n1N8K2OMe0E66ti+uOJBTS6lCuGN5cQv+8OuJ30uXvUtPj/MJK7CEykPBTBe/JpHZ\n0fdty0Z06C4zGl6dJskO/843PEUWyelzYqgGaxeZAoGAchlfJIJ0V+N8QW/HCl/S\nWzcg03XKOM4SNdIXTwJqJnLsMURAeNc0F+UUI4uDI0L+C3EjY631eIF+WoONcP8f\nxDyGMiyN1Ysk70KC++Fse7B85fZoHDTR8k2CrClEZVs6KeVBkZJkLfKG02xYA0rh\nXUoU/RirsjyKrjZTDqut9vE=\n-----END PRIVATE KEY-----`;\n\n// ─── PROPERTIES (must match safety-checklist) ───\nconst PROPERTIES = [\n {\n id: \"park\",\n name: \"Park Place Lodge\",\n canonical: \"1820 E Park Pl (Indiana)\",\n addr: \"1820 E Park Pl, Jeffersonville IN\",\n floors: 2,\n beds: 9,\n },\n {\n id: \"prl\",\n name: \"Persimmon Ridge Lodge\",\n canonical: \"70 Persimmon Ridge Dr (Shelby)\",\n addr: \"70 Persimmon Ridge Dr\",\n floors: 3,\n beds: 7,\n },\n {\n id: \"oak\",\n name: \"The Oak Barrel Lodge\",\n canonical: \"320 Gordon Gutmann Blvd (Indiana)\",\n addr: \"320 Gordon Gutmann Blvd, Jeffersonville IN\",\n floors: 2,\n beds: 6,\n },\n {\n id: \"manor\",\n name: \"Louisville Country Manor\",\n canonical: \"17008 Shelbyville Rd (Jefferson)\",\n addr: \"17008 Shelbyville Rd\",\n floors: 3,\n beds: 7,\n },\n {\n id: \"louisx\",\n name: \"The Louis X — Hotel Buyout\",\n canonical: \"Exclusive Group Hotel Buyout | Private Bar + Event Space\",\n addr: \"751 Vine St\",\n floors: 3,\n beds: 8,\n },\n {\n id: \"lavish\",\n name: \"The Norton Commons Lavish\",\n canonical: \"6408 Passionflower Dr (Jefferson)\",\n addr: \"6408 Passionflower Dr\",\n floors: 3,\n beds: 4,\n },\n {\n id: \"luxe\",\n name: \"The Norton Commons Luxe\",\n canonical: \"9407 Delphinium St (Jefferson)\",\n addr: \"9407 Delphinium St\",\n floors: 3,\n beds: 4,\n },\n {\n id: \"spirit\",\n name: \"The Kentucky Spirit Retreat\",\n canonical: \"9315 Dayflower St (Jefferson)\",\n addr: \"9315 Dayflower St\",\n floors: 3,\n beds: 3,\n },\n {\n id: \"ferndale\",\n name: \"Bourbon Trail Central\",\n canonical: \"9100 Ferndale Rd (Jefferson)\",\n addr: \"9100 Ferndale Rd\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"sleepy\",\n name: \"Harris House — Creekside Retreat\",\n canonical: \"4700 Sleepy Hollow Rd (Oldham)\",\n addr: \"4700 Sleepy Hollow Rd\",\n floors: 2,\n beds: 5,\n },\n {\n id: \"hannah\",\n name: \"Farmhouse Hannah\",\n canonical: \"367 Hannah Rd (Shelby)\",\n addr: \"367 Hannah Rd\",\n floors: 3,\n beds: 3,\n },\n {\n id: \"shelby74\",\n name: \"Bourbon House 2\",\n canonical: \"2074 S Shelby St (Jefferson)\",\n addr: \"2074 S Shelby St\",\n floors: 3,\n beds: 4,\n },\n {\n id: \"shelby76\",\n name: \"Bourbon House 3\",\n canonical: \"2076 S Shelby St (Jefferson)\",\n addr: \"2076 S Shelby St\",\n floors: 2,\n beds: 5,\n },\n {\n id: \"welling\",\n name: \"Bourbon House 4 — The Wellingmoor\",\n canonical: \"3216 Wellingmoor Ave (Jefferson)\",\n addr: \"3216 Wellingmoor Ave\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"booker\",\n name: \"11004 Booker Rd\",\n canonical: \"11004 Booker Rd (Jefferson)\",\n addr: \"11004 Booker Rd\",\n floors: 3,\n beds: 3,\n },\n {\n id: \"cres1\",\n name: \"210 Crescent Ct #1\",\n canonical: \"210 Crescent Ct. #1 (Jefferson)\",\n addr: \"210 Crescent Ct, Unit 1\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"cres2\",\n name: \"210 Crescent Ct #2\",\n canonical: \"210 Crescent Ct. #2 (Jefferson)\",\n addr: \"210 Crescent Ct, Unit 2\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"lagrange\",\n name: \"Lagrange Loft\",\n canonical: \"121 1/2 E Main St (Oldham, Lagrange)\",\n addr: \"121½ E Main St, Lagrange KY\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"bards\",\n name: \"1829 Bardstown Rd\",\n canonical: \"1829 Bardstown Rd (Jefferson)\",\n addr: \"1829 Bardstown Rd\",\n floors: 1,\n beds: 2,\n },\n {\n id: \"douglass\",\n name: \"1894 Douglass Blvd\",\n canonical: \"1894 Douglass Blvd (Jefferson)\",\n addr: \"1894 Douglass Blvd\",\n floors: 1,\n beds: 2,\n },\n {\n id: \"lyric\",\n name: \"The Lyric 185\",\n canonical: \"6324 Meeting St Unit 185 (Jefferson)\",\n addr: \"6324 Meeting St #185\",\n floors: 1,\n beds: 3,\n },\n {\n id: \"cottage\",\n name: \"On the Rocks Cottage\",\n canonical: \"1238 Settlers Trace Road Cottage #31 (Spencer)\",\n addr: \"1238 Settlers Trace Rd, Cottage #31\",\n floors: 3,\n beds: 1,\n },\n {\n id: \"lawrenceburg\",\n name: \"Storybook Stone Home\",\n canonical: \"502 S Main St (Lawrenceburg)\",\n addr: \"502 S Main St, Lawrenceburg KY\",\n floors: 3,\n beds: 5,\n },\n {\n id: \"bourbon\",\n name: \"1203 Bourbon Ave\",\n canonical: \"1203 Bourbon Ave (Jefferson)\",\n addr: \"1203 Bourbon Ave\",\n floors: 2,\n beds: 5,\n },\n {\n id: \"lx22\",\n name: \"Suite 22 — Entertainment Suite\",\n canonical: \"Suite 22 - Entertainment Suite\",\n addr: \"751 Vine St, Ste 22\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx23\",\n name: \"Suite 23 — Thunder Over Louisville\",\n canonical: \"Suite 23 - Thunder Over Louisville Suite\",\n addr: \"751 Vine St, Ste 23\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx24\",\n name: \"Suite 24 — Louisville Slugger\",\n canonical: \"Suite 24 - Louisville Slugger Suite\",\n addr: \"751 Vine St, Ste 24\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx25\",\n name: \"Suite 25 — Kentucky Oaks\",\n canonical: \"Suite 25 - Kentucky Oaks Suite\",\n addr: \"751 Vine St, Ste 25\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx32\",\n name: \"Suite 32 — The Bourbon Suite\",\n canonical: \"Suite 32 - The Bourbon Suite\",\n addr: \"751 Vine St, Ste 32\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx33\",\n name: \"Suite 33 — Thomas Edison\",\n canonical: \"Suite 33 - Thomas Edison Suite\",\n addr: \"751 Vine St, Ste 33\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx34\",\n name: \"Suite 34 — Muhammad Ali\",\n canonical: \"Suite 34 - Muhammad Ali Suite\",\n addr: \"751 Vine St, Ste 34\",\n floors: 1,\n beds: 1,\n },\n {\n id: \"lx35\",\n name: \"Suite 35 — Kentucky Derby\",\n canonical: \"Suite 35 - Kentucky Derby Suite\",\n addr: \"751 Vine St, Ste 35\",\n floors: 1,\n beds: 1,\n },\n];\n\n// ─── CHECKLIST BUILDER (must match safety-checklist) ───\nfunction buildGroups(pid: string, floors: number, beds: number) {\n const F = floors, B = beds;\n const g: any[] = [];\n const smoke: any[] = [];\n for (let b = 1; b <= B; b++) {\n smoke.push({\n id: `${pid}-sm-br${b}`,\n label: `Bedroom ${b} — Smoke & CO detector`,\n detail:\n \"Test button → must sound. Hardwired OR 10-year lithium-ion combo unit. Battery type: replace battery every 5 yrs.\",\n fields: [\n { id: \"tested\", label: \"Last Tested\", type: \"date\" },\n { id: \"exp\", label: \"Expiration Date\", type: \"date_exp\" },\n { id: \"power\", label: \"Power\", type: \"select\" },\n { id: \"battery\", label: \"Battery Last Replaced\", type: \"date\" },\n ],\n });\n }\n for (let f = 1; f <= F; f++) {\n smoke.push({\n id: `${pid}-sm-hall${f}`,\n label: `Floor ${f} — Hallway / Common Area detector`,\n detail:\n \"Test button → must sound. Hardwired OR 10-year lithium-ion combo unit. Battery type: replace battery every 5 yrs.\",\n fields: [\n { id: \"tested\", label: \"Last Tested\", type: \"date\" },\n { id: \"exp\", label: \"Expiration Date\", type: \"date_exp\" },\n { id: \"power\", label: \"Power\", type: \"select\" },\n { id: \"battery\", label: \"Battery Last Replaced\", type: \"date\" },\n ],\n });\n }\n g.push({\n id: `${pid}-smoke`,\n label: \"🔥 Smoke & CO Detectors\",\n tasks: smoke,\n });\n\n const ext: any[] = [];\n for (let f = 1; f <= F; f++) {\n ext.push({\n id: `${pid}-ext-fl${f}`,\n label: `Floor ${f} — Hallway extinguisher`,\n detail:\n \"Readily accessible on this floor. Check expiration. Gauge needle in the green.\",\n fields: [{ id: \"inspected\", label: \"Last Inspected\", type: \"date\" }, {\n id: \"exp\",\n label: \"Expiration Date\",\n type: \"date_exp\",\n }, { id: \"gauge\", label: \"Gauge\", type: \"select\" }],\n });\n }\n ext.push({\n id: `${pid}-ext-kit`,\n label: \"Kitchen — wall-mounted extinguisher\",\n detail:\n \"Within 30ft of cooking area. Check expiration. Gauge needle in the green.\",\n fields: [{ id: \"inspected\", label: \"Last Inspected\", type: \"date\" }, {\n id: \"exp\",\n label: \"Expiration Date\",\n type: \"date_exp\",\n }, { id: \"gauge\", label: \"Gauge\", type: \"select\" }],\n });\n g.push({ id: `${pid}-ext`, label: \"🧯 Fire Extinguishers\", tasks: ext });\n\n const fa: any[] = [];\n for (let f = 1; f <= F; f++) {\n fa.push({\n id: `${pid}-fa-fl${f}`,\n label: `Floor ${f} — First aid kit`,\n detail: \"Accessible, stocked, and sealed\",\n fields: [{ id: \"restocked\", label: \"Last Restocked\", type: \"date\" }],\n });\n }\n g.push({ id: `${pid}-fa`, label: \"🩹 First Aid Kits\", tasks: fa });\n\n const ep: any[] = [];\n for (let f = 1; f <= F; f++) {\n ep.push({\n id: `${pid}-esc-fl${f}`,\n label: `Floor ${f} Kitchen — posted emergency escape plan`,\n detail: \"Includes exits, meeting point, and emergency numbers\",\n fields: [{ id: \"updated\", label: \"Last Updated\", type: \"date\" }],\n });\n }\n g.push({\n id: `${pid}-escape`,\n label: \"🚪 Emergency Escape Plans\",\n tasks: ep,\n });\n\n g.push({\n id: `${pid}-gen`,\n label: \"✅ General Safety\",\n tasks: [\n {\n id: `${pid}-gen-exits`,\n label: \"All exits and egress paths clear and unobstructed\",\n detail: \"Doors, windows, hallways — no blockages\",\n },\n {\n id: `${pid}-gen-lights`,\n label: \"Emergency / flashlight lighting functional\",\n detail: \"Test batteries or hardwired backup lighting\",\n },\n {\n id: `${pid}-gen-gas`,\n label: \"Gas shutoff location marked and communicated\",\n detail: \"Noted in guest instructions and posted at property\",\n },\n {\n id: `${pid}-gen-gfci`,\n label: \"GFCI outlets functional — kitchens & bathrooms\",\n detail: \"Press test/reset on each GFCI outlet\",\n },\n {\n id: `${pid}-gen-stairs`,\n label: \"Stair handrails secure and in good condition\",\n detail: \"No loose balusters, no wobble\",\n },\n {\n id: `${pid}-gen-trip`,\n label: \"No trip hazards throughout property\",\n detail: \"Rugs secured, cords managed, pathways clear\",\n },\n {\n id: `${pid}-gen-outdoor`,\n label: \"Exterior / entry lighting functional\",\n detail: \"All exterior bulbs working\",\n },\n {\n id: `${pid}-gen-lockbox`,\n label: \"Lockbox / backup entry tested — code confirmed\",\n detail: \"Confirm code works and is current\",\n },\n {\n id: `${pid}-gen-numbers`,\n label: \"Emergency numbers posted visibly at property\",\n detail: \"Fire, police, host contact line\",\n },\n {\n id: `${pid}-gen-pool`,\n label: \"Pool / hot tub gate latch functional (if applicable)\",\n detail: \"Self-latching gate, no gaps at base, drain covers secure\",\n },\n ],\n });\n return g;\n}\n\nfunction expLabel(d: string) {\n if (!d) return \"\";\n const days = (new Date(d).getTime() - Date.now()) / 864e5;\n if (days < 0) return \"EXPIRED\";\n if (days < 30) return Math.round(days) + \"d left\";\n if (days < 90) return Math.round(days / 30) + \"mo left\";\n return \"Valid\";\n}\n\n// ─── FIREBASE HELPERS ───────────────────────\nasync function fbGet(path: string): Promise {\n const r = await fetch(`${FIREBASE_URL}/${path}.json`);\n if (!r.ok) return null;\n return r.json();\n}\nasync function fbPut(path: string, data: any): Promise {\n await fetch(`${FIREBASE_URL}/${path}.json`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(data),\n });\n}\n\n// ─── GOOGLE SERVICE ACCOUNT JWT → ACCESS TOKEN ───\nasync function getAccessToken(): Promise {\n const header = { alg: \"RS256\", typ: \"JWT\" };\n const now = Math.floor(Date.now() / 1000);\n const claims = {\n iss: SA_EMAIL,\n scope: \"https://www.googleapis.com/auth/drive\",\n aud: \"https://oauth2.googleapis.com/token\",\n iat: now,\n exp: now + 3600,\n };\n const b64url = (s: string) =>\n btoa(s).replace(/=/g, \"\").replace(/\\+/g, \"-\").replace(/\\//g, \"_\");\n const enc = (o: any) => b64url(JSON.stringify(o));\n const signingInput = `${enc(header)}.${enc(claims)}`;\n\n // Import the PEM private key\n const pemBody = SA_PRIVATE_KEY\n .replace(/-----BEGIN PRIVATE KEY-----/, \"\")\n .replace(/-----END PRIVATE KEY-----/, \"\")\n .replace(/\\s+/g, \"\");\n const der = Uint8Array.from(atob(pemBody), (c) => c.charCodeAt(0));\n const key = await crypto.subtle.importKey(\n \"pkcs8\",\n der,\n { name: \"RSASSA-PKCS1-v1_5\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sigBuf = await crypto.subtle.sign(\n \"RSASSA-PKCS1-v1_5\",\n key,\n new TextEncoder().encode(signingInput),\n );\n const sig = btoa(String.fromCharCode(...new Uint8Array(sigBuf))).replace(\n /=/g,\n \"\",\n ).replace(/\\+/g, \"-\").replace(/\\//g, \"_\");\n const jwt = `${signingInput}.${sig}`;\n\n const r = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body:\n `grant_type=urn:ietf:params:oauth:grant-type:jwt-bearer&assertion=${jwt}`,\n });\n if (!r.ok) throw new Error(\"Token exchange failed: \" + await r.text());\n const j = await r.json();\n return j.access_token;\n}\n\n// ─── DRIVE: HTML → PDF VIA GOOGLE DOC CONVERSION ───\n// Path: upload HTML with mimeType=application/vnd.google-apps.document\n// (Drive auto-converts), then export that Doc as PDF, then delete the Doc.\nasync function htmlToPdfViaDrive(\n html: string,\n filename: string,\n token: string,\n): Promise<{ fileId: string; webViewLink: string }> {\n // 1. Upload HTML, asking Drive to convert to a Google Doc.\n // convert=true is the modern equivalent for v3 — set mimeType to google-apps.document.\n const boundary = \"br_\" + Math.random().toString(36).slice(2);\n const meta = {\n name: filename.replace(/\\.pdf$/i, \"\") + \" (tmp)\",\n mimeType: \"application/vnd.google-apps.document\",\n parents: [DRIVE_FOLDER_ID],\n };\n const multipartBody = `--${boundary}\\r\\n` +\n `Content-Type: application/json; charset=UTF-8\\r\\n\\r\\n` +\n `${JSON.stringify(meta)}\\r\\n` +\n `--${boundary}\\r\\n` +\n `Content-Type: text/html\\r\\n\\r\\n` +\n `${html}\\r\\n` +\n `--${boundary}--`;\n\n const uploadRes = await fetch(\n \"https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart&supportsAllDrives=true\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Content-Type\": `multipart/related; boundary=${boundary}`,\n },\n body: multipartBody,\n },\n );\n if (!uploadRes.ok) {\n throw new Error(\"Doc upload failed: \" + await uploadRes.text());\n }\n const doc = await uploadRes.json();\n const docId = doc.id;\n\n // 2. Export the Doc as PDF\n const pdfRes = await fetch(\n `https://www.googleapis.com/drive/v3/files/${docId}/export?mimeType=application/pdf`,\n { headers: { \"Authorization\": `Bearer ${token}` } },\n );\n if (!pdfRes.ok) {\n await fetch(\n `https://www.googleapis.com/drive/v3/files/${docId}?supportsAllDrives=true`,\n { method: \"DELETE\", headers: { Authorization: `Bearer ${token}` } },\n ).catch(() => {});\n throw new Error(\"PDF export failed: \" + await pdfRes.text());\n }\n const pdfBytes = new Uint8Array(await pdfRes.arrayBuffer());\n\n // 3. Delete the temporary Doc\n await fetch(\n `https://www.googleapis.com/drive/v3/files/${docId}?supportsAllDrives=true`,\n {\n method: \"DELETE\",\n headers: { \"Authorization\": `Bearer ${token}` },\n },\n ).catch(() => {}); // best-effort cleanup\n\n // 4. Upload the PDF bytes as a real PDF file in the target folder\n const pdfBoundary = \"br_pdf_\" + Math.random().toString(36).slice(2);\n const pdfMeta = {\n name: filename,\n mimeType: \"application/pdf\",\n parents: [DRIVE_FOLDER_ID],\n };\n // Build a binary-safe multipart body using Blob\n const head = new Blob([\n `--${pdfBoundary}\\r\\n`,\n `Content-Type: application/json; charset=UTF-8\\r\\n\\r\\n`,\n JSON.stringify(pdfMeta),\n `\\r\\n--${pdfBoundary}\\r\\n`,\n `Content-Type: application/pdf\\r\\n\\r\\n`,\n ]);\n const tail = new Blob([`\\r\\n--${pdfBoundary}--`]);\n const body = new Blob([head, pdfBytes, tail]);\n\n const finalRes = await fetch(\n \"https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart&supportsAllDrives=true&fields=id,webViewLink\",\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${token}`,\n \"Content-Type\": `multipart/related; boundary=${pdfBoundary}`,\n },\n body,\n },\n );\n if (!finalRes.ok) {\n throw new Error(\"PDF upload failed: \" + await finalRes.text());\n }\n const finalFile = await finalRes.json();\n return { fileId: finalFile.id, webViewLink: finalFile.webViewLink };\n}\n\n// ─── BUILD POLISHED HTML REPORT ───────────────\nfunction generateReport(p: any, state: any): string {\n const groups = buildGroups(p.id, p.floors, p.beds);\n const allTasks = groups.flatMap((g) => g.tasks);\n const total = allTasks.length;\n const ts = (id: string) =>\n state[id] ||\n { checked: false, note: \"\", fields: {}, doneBy: \"\", doneAt: \"\" };\n const done = allTasks.filter((t) => ts(t.id).checked).length;\n const pct = total ? Math.round(done / total * 100) : 0;\n const meta = state[\"_meta_\" + p.id] || {};\n const dateStr = meta.inspDate\n ? new Date(meta.inspDate).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n })\n : new Date().toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n });\n const inspector = meta.inspName || \"Bourbon Rentals\";\n const nextDate = meta.nextDate\n ? new Date(meta.nextDate).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n })\n : \"—\";\n const statusColor = pct === 100\n ? \"#3B6D11\"\n : pct >= 50\n ? \"#854F0B\"\n : \"#8b1a1a\";\n const statusLabel = pct === 100 ? \"PASS\" : pct + \"% Complete\";\n\n let groupsHtml = \"\";\n groups.forEach((grp) => {\n let rows = \"\";\n grp.tasks.forEach((task: any) => {\n const s = ts(task.id);\n const flds = s.fields || {};\n const icon = s.checked ? \"✅\" : \"❌\";\n const noteHtml = s.note\n ? `

Diff · v8