[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_160":161,"_162":163},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":53,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"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":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",42,"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","a6ef5ef2-8095-11f1-9fb5-1607ee4eb77e","name","fileType","http","content","// ─────────────────────────────────────────────────────────────────────────────\n// Crafty Delivers — Client Equipment Proposal Page\n// Deploy this file to Val.town as an HTTP handler.\n//\n// Required environment variables (set in Val.town → Settings → Environment):\n// NOTION_API_KEY — your Notion integration token\n// PROPOSALS_DB_ID — the Client Equipment Proposals database ID\n// ─────────────────────────────────────────────────────────────────────────────\n\nconst NOTION_VERSION = \"2022-06-28\";\n\n// ── Notion API helpers ────────────────────────────────────────────────────────\n\nasync function notionFetch(path, body = null) {\n const res = await fetch(`https://api.notion.com/v1${path}`, {\n method: body ? \"POST\" : \"GET\",\n headers: {\n \"Authorization\": `Bearer ${Deno.env.get(\"NOTION_API_KEY\")}`,\n \"Notion-Version\": NOTION_VERSION,\n \"Content-Type\": \"application/json\",\n },\n ...(body && { body: JSON.stringify(body) }),\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Notion API ${res.status}: ${text}`);\n }\n return res.json();\n}\n\n// Returns string from a title property\nfunction getTitle(prop) {\n return prop?.title?.map(t => t.plain_text).join(\"\") || null;\n}\n\n// Returns string from rich_text, multi_select, or select property\nfunction getRichText(prop) {\n if (!prop) return null;\n if (prop.type === \"rich_text\") return prop.rich_text?.map(t => t.plain_text).join(\"\") || null;\n if (prop.type === \"multi_select\") return prop.multi_select?.map(s => s.name).join(\", \") || null;\n if (prop.type === \"select\") return prop.select?.name || null;\n return null;\n}\n\n// Returns number value\nfunction getNumber(prop) {\n return prop?.number ?? null;\n}\n\n// Returns URL from a files property\nfunction getFileUrl(prop) {\n if (!prop?.files?.length) return null;\n const f = prop.files[0];\n return f.type === \"external\" ? f.external.url : (f.file?.url ?? null);\n}\n\n// Generic field reader — handles checkbox, number, select, rich_text, multi_select, title, formula\nfunction getField(prop) {\n if (!prop) return null;\n switch (prop.type) {\n case \"checkbox\": return prop.checkbox === true ? \"Yes\" : prop.checkbox === false ? \"No\" : null;\n case \"number\": return prop.number != null ? String(prop.number) : null;\n case \"select\": return prop.select?.name || null;\n case \"multi_select\": return prop.multi_select?.map(s => s.name).join(\", \") || null;\n case \"rich_text\": return prop.rich_text?.map(t => t.plain_text).join(\"\") || null;\n case \"title\": return prop.title?.map(t => t.plain_text).join(\"\") || null;\n case \"formula\": return prop.formula?.string || (prop.formula?.number != null ? String(prop.formula.number) : null);\n case \"email\": return prop.email || null;\n default: return null;\n }\n}\n\n// Try a list of property names, return the first one that exists\nfunction tryProp(properties, ...names) {\n for (const name of names) {\n if (properties[name] !== undefined) return properties[name];\n }\n return null;\n}\n\nfunction escHtml(str) {\n if (str == null) return \"\";\n return String(str)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\nconst CATALOG_DB_ID = \"388ae2b9bd0480a29f2be68ca84d1089\";\n\n// ── Main handler ──────────────────────────────────────────────────────────────\n\nexport default async function handler(req) {\n const url = new URL(req.url);\n\n // Route to catalog page\n if (url.pathname === \"/catalog\" || url.pathname === \"/catalog/\") {\n return handleCatalog(url.searchParams.get(\"proposal_id\") || null);\n }\n\n // Determine if this is a pricing proposal\n const withPricing = url.pathname === \"/pricing\" || url.pathname === \"/pricing/\";\n\n const proposalIdRaw = url.searchParams.get(\"proposal_id\");\n // Accept both plain numbers (\"5\") and prefixed format (\"PROP-5\")\n const proposalIdNum = proposalIdRaw ? parseInt(proposalIdRaw.replace(/^[^0-9]*/, \"\"), 10) : NaN;\n\n if (!proposalIdRaw || isNaN(proposalIdNum)) {\n return respond(errorPage(\"Invalid link\", \"This proposal link is missing or invalid. Please contact your Crafty Delivers representative.\"));\n }\n\n return handleProposal(proposalIdNum, withPricing);\n}\n\n// ── Proposal handler (shared by standard and pricing routes) ──────────────────\n\nasync function handleProposal(proposalId, withPricing = false) {\n try {\n // 1. Resolve the actual database ID (handles case where ID is a page containing the database)\n let dbId = Deno.env.get(\"PROPOSALS_DB_ID\");\n let queryResult;\n\n try {\n queryResult = await notionFetch(`/databases/${dbId}/query`, {});\n } catch (firstErr) {\n if (firstErr.message.includes(\"is a page, not a database\")) {\n const blocks = await notionFetch(`/blocks/${dbId}/children`);\n const dbBlock = blocks.results?.find(b => b.type === \"child_database\");\n if (!dbBlock) throw new Error(\"No database found inside the provided page ID\");\n dbId = dbBlock.id;\n queryResult = await notionFetch(`/databases/${dbId}/query`, {});\n } else {\n throw firstErr;\n }\n }\n\n console.log(\"Total proposals fetched:\", queryResult.results?.length);\n\n // 2. Find proposal matching the URL ID\n const proposal = queryResult.results?.find(page => {\n const idProp = page.properties[\"Proposal ID\"];\n return idProp?.unique_id?.number === parseInt(proposalId);\n });\n\n if (!proposal) {\n return respond(errorPage(\"Proposal not found\", \"We couldn't find this proposal. Please check your link or contact your Crafty Delivers representative.\"));\n }\n const pProps = proposal.properties;\n\n // Debug: log all proposal property keys and the raw SE Email value\n console.log(\"Proposal property keys:\", Object.keys(pProps));\n console.log(\"SE Email raw:\", JSON.stringify(pProps[\"SE Email\"]));\n\n // 3. Extract client name\n // Debug: log all proposal property keys to confirm exact field names\n console.log(\"All proposal property keys:\", JSON.stringify(Object.keys(pProps)));\n const clientNameKey = Object.keys(pProps).find(k => k.toLowerCase().includes(\"client facing\"));\n console.log(\"Client Facing key found:\", clientNameKey);\n if (clientNameKey) console.log(\"Client Facing raw value:\", JSON.stringify(pProps[clientNameKey]));\n\n const clientName =\n (clientNameKey ? (getRichText(pProps[clientNameKey]) || getTitle(pProps[clientNameKey]) || getField(pProps[clientNameKey])) : null) ||\n getRichText(pProps[\"Client Facing Page Name\"]) ||\n getTitle(pProps[\"Client Facing Page Name\"]) ||\n getRichText(pProps[\"✏️ Client Facing Page Name (e.g. Jaco, Ltd's Equipment)\"]) ||\n getTitle(pProps[\"✏️ Client Facing Page Name (e.g. Jaco, Ltd's Equipment)\"]) ||\n getTitle(pProps[\"Page Name\"]) ||\n getTitle(pProps[\"Name\"]) ||\n \"Your Company\";\n\n // 3b. Extract sales exec name and email\n const salesExecKey = Object.keys(pProps).find(k => k.toLowerCase().includes(\"sales exec\"));\n const salesExecName =\n (salesExecKey ? (getRichText(pProps[salesExecKey]) || getTitle(pProps[salesExecKey]) || getField(pProps[salesExecKey])) : null) ||\n getRichText(pProps[\"Sales Exec\"]) ||\n getTitle(pProps[\"Sales Exec\"]) ||\n getField(pProps[\"Sales Exec\"]) ||\n null;\n\n const salesExecEmail =\n pProps[\"SE Email\"]?.formula?.string ||\n getField(pProps[\"SE Email\"]) ||\n null;\n\n // 4. Get related equipment page IDs\n const equipmentIds =\n pProps[\" ✏️ Recommended Equipment\"]?.relation?.map(r => r.id) ||\n pProps[\"Crafty Equipment Catalog\"]?.relation?.map(r => r.id) ||\n [];\n\n if (!equipmentIds.length) {\n return respond(buildPage(clientName, [], salesExecName, salesExecEmail, proposalId));\n }\n\n // 5. Fetch all equipment pages in parallel\n const equipmentPages = await Promise.all(\n equipmentIds.map(id => notionFetch(`/pages/${id}`))\n );\n\n // Debug: log equipment property keys from first item so we can confirm field names\n if (equipmentPages.length > 0) {\n console.log(\"Equipment property keys:\", Object.keys(equipmentPages[0].properties));\n const p0 = equipmentPages[0].properties;\n for (const [k, v] of Object.entries(p0)) {\n if (v.type === \"title\") {\n console.log(`TITLE field: \"${k}\" =`, JSON.stringify(v.title?.map(t => t.plain_text)));\n }\n if (k.toLowerCase().includes(\"lead\")) {\n console.log(`LEAD TIME field: \"${k}\": type=${v.type}, value=`, JSON.stringify(v[v.type]));\n }\n }\n }\n\n // 6. Parse each equipment page\n const equipment = equipmentPages.map(page => {\n const p = page.properties;\n\n // Name: \"Master Name\" is the title field in this database\n const nameRaw =\n getTitle(tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\", \"Item Name\")) ||\n getField(tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\", \"Item Name\")) ||\n null;\n\n // Image\n const image = getFileUrl(\n tryProp(p, \"Equipment Image\", \"🚫 Equipment Image\", \"Image\", \"Images\", \"Photo\")\n );\n\n // Spec sheet PDF\n const specSheet = getFileUrl(\n tryProp(p, \"Spec Sheet PDF\", \"🚫 Equipment Specs (pdf)\", \"Spec Sheet\", \"Equipment Specs (pdf)\")\n );\n\n // Lead time — single field \"Lead Time (weeks)\" in this database\n const leadTime = getNumber(tryProp(p, \"Lead Time (weeks)\", \"Lead Time (Weeks)\"));\n\n // Add-ons — \"Card — Necessary Add-Ons\" is a pre-computed formula on the equipment record\n const addOnProp = tryProp(p, \"Card — Necessary Add-Ons\", \"Required Add-ons\", \"Necessary Add-Ons\", \"Necessary add-ons\", \"Required Add-Ons\");\n const necessaryAddons = getField(addOnProp) || getRichText(addOnProp);\n console.log(\"necessaryAddons value:\", JSON.stringify(necessaryAddons));\n const optionalAddons = getRichText(\n tryProp(p, \"Optional Add-ons\", \"Optional Add-Ons\", \"Optional add-ons\")\n );\n\n // Brand / category\n const brand = getField(tryProp(p, \"Brand Name\", \"Brand\", \"🚫 Brand Name\", \"🚫 Brand\"));\n const category = getField(tryProp(p, \"Category\", \"🚫 Category\"));\n const subCategory = getField(tryProp(p, \"Sub-category\", \"Sub-Category\", \"Subcategory\", \"🚫 Sub-category\", \"🚫 Sub-Category\"));\n\n // Dimensions\n const width = getNumber(tryProp(p, \"Width (in)\", \"🚫 Width (in)\"));\n const depth = getNumber(tryProp(p, \"Depth (in)\", \"🚫 Depth (in)\"));\n const height = getNumber(tryProp(p, \"Height (in)\", \"🚫 Height (in)\"));\n\n // Clearances\n const leftRightClearance = getField(tryProp(p, \"Left/Right Clearance\", \"🚫 Left/Right Clearance\"));\n const frontBackClearance = getField(tryProp(p, \"Front/Back Clearance\", \"🚫 Front/Back Clearance\"));\n const topBottomClearance = getField(tryProp(p, \"Top/Bottom Clearance\", \"🚫 Top/Bottom Clearance\"));\n\n // Electrical\n const voltageRequired = getField(tryProp(p, \"Voltage Required\", \"🚫 Voltage Required\"));\n const hertzRequired = getField(tryProp(p, \"Hertz Required\", \"🚫 Hertz Required\"));\n const electricalAmps = getField(tryProp(p, \"Electrical Amps\", \"🚫 Electrical Amps\"));\n const electricalPlug = getField(tryProp(p, \"Electrical Plug\", \"🚫 Electrical Plug\"));\n\n // Plumbing / install\n const waterline = getField(tryProp(p, \"Waterline\", \"🚫 Waterline\"));\n const floorDrain = getField(tryProp(p, \"Floor Drain\", \"🚫 Floor Drain\"));\n const countertopHole = getField(tryProp(p, \"Countertop Holes Required\", \"Countertop Hole(s) Required\", \"🚫 Countertop Holes Required\"));\n const countertopHoleSize = getField(tryProp(p, \"Countertop Hole Size (in)\", \"🚫 Countertop Hole Size (in)\"));\n\n // General\n const capacity = getField(tryProp(p, \"Capacity\", \"🚫 Capacity\"));\n const headcount = getField(tryProp(p, \"Headcount this machine serves\",\"🚫 Headcount this machine serves\"));\n const modelNum = getField(tryProp(p, \"Model #\", \"🚫 Model #\", \"Model Number\"));\n\n // If name wasn't found, fall back to model number, then generic label\n const name = nameRaw || (modelNum ? `Model ${modelNum}` : \"Unnamed Item\");\n\n // Pricing fields (only fetched/used on the pricing route)\n if (withPricing) {\n const pricingKeys = Object.keys(p).filter(k =>\n k.toLowerCase().includes(\"rental\") || k.toLowerCase().includes(\"spend\") || k.toLowerCase().includes(\"yr\")\n );\n console.log(\"Pricing-related field names:\", JSON.stringify(pricingKeys));\n pricingKeys.forEach(k => console.log(` \"${k}\": type=${p[k].type}, value=`, JSON.stringify(p[k][p[k].type])));\n }\n const rental1yr = withPricing ? getField(tryProp(p, \"1-Yr Rental\", \"1-YR Rental\", \"1-Year Rental\", \"1 Yr Rental\", \"1 YR Rental\")) : null;\n const rental2yr = withPricing ? getField(tryProp(p, \"2-YR Rental\", \"2-Yr Rental\", \"2-Year Rental\", \"2 Yr Rental\", \"2 YR Rental\")) : null;\n const rental3yr = withPricing ? getField(tryProp(p, \"3-YR Rental\", \"3-Yr Rental\", \"3-Year Rental\", \"3 Yr Rental\", \"3 YR Rental\", \"3-YR rental\")) : null;\n const spend1yr = withPricing ? getField(tryProp(p, \"1 - YR Spend Minimum for Free Equipment\", \"1-YR Spend Minimum for Free Equipment\", \"1-Yr Spend Minimum for Free Equipment\", \"1 YR Spend Minimum for Free Equipment\", \"1 Yr Spend Minimum\")) : null;\n const spend2yr = withPricing ? getField(tryProp(p, \"2 - YR Spend Minimum for Free Equipment\", \"2-YR Spend Minimum for Free Equipment\", \"2-Yr Spend Minimum for Free Equipment\", \"2 YR Spend Minimum for Free Equipment\", \"2 Yr Spend Minimum\")) : null;\n const spend3yr = withPricing ? getField(tryProp(p, \"3 - YR Spend Minimum for Free Equipment\", \"3-YR Spend Minimum for Free Equipment\", \"3-Yr Spend Minimum for Free Equipment\", \"3 YR Spend Minimum for Free Equipment\", \"3 Yr Spend Minimum\")) : null;\n\n return {\n name, image, specSheet, leadTime,\n necessaryAddons, optionalAddons,\n brand, category, subCategory,\n width, depth, height, leftRightClearance, frontBackClearance, topBottomClearance,\n voltageRequired, hertzRequired, electricalAmps, electricalPlug,\n waterline, floorDrain, countertopHole, countertopHoleSize,\n capacity, headcount, modelNum,\n rental1yr, rental2yr, rental3yr, spend1yr, spend2yr, spend3yr,\n };\n });\n\n if (withPricing) {\n return respond(buildPricingPage(clientName, equipment, salesExecName, salesExecEmail, proposalId));\n }\n return respond(buildPage(clientName, equipment, salesExecName, salesExecEmail, proposalId));\n\n } catch (err) {\n console.error(\"Proposal page error:\", err);\n return respond(\n errorPage(\"Something went wrong\", \"Please try refreshing the page. If the problem persists, contact your Crafty Delivers representative.\"),\n 500\n );\n }\n}\n\n// ── Response helper ───────────────────────────────────────────────────────────\n\nfunction respond(html, status = 200) {\n return new Response(html, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\n// ── Error page ────────────────────────────────────────────────────────────────\n\nfunction errorPage(title, message) {\n return `\n\n\n \n \n Crafty Delivers\n \n\n\n

${escHtml(title)}

${escHtml(message)}

\n\n`;\n}\n\n// ── Main page builder ─────────────────────────────────────────────────────────\n\nfunction buildPricingPage(clientName, equipment, salesExecName, salesExecEmail, proposalId) {\n return buildPage(clientName, equipment, salesExecName, salesExecEmail, proposalId, true);\n}\n\nfunction buildPage(clientName, equipment, salesExecName, salesExecEmail, proposalId, withPricing = false) {\n\n // Pre-compute footer values to avoid quote conflicts inside template literals\n const displayEmail = salesExecEmail || \"hello@craftydelivers.com\";\n\n // Helper: renders a spec row only if value is non-null/non-empty\n const row = (label, value) => {\n if (value == null || value === \"\") return \"\";\n return `

\n ${escHtml(label)}\n ${escHtml(String(value))}\n

`;\n };\n\n // Helper: renders a section header inside a card (only if there's content)\n const section = (title, ...rows) => {\n const content = rows.join(\"\");\n if (!content) return \"\";\n return `

${escHtml(title)}

${content}

`;\n };\n\n // Gallery cards\n const galleryCards = equipment.length\n ? equipment.map(item => {\n const dimStr = (item.height != null || item.width != null || item.depth != null)\n ? [\n item.height != null ? `${item.height}\" H` : null,\n item.width != null ? `${item.width}\" W` : null,\n item.depth != null ? `${item.depth}\" D` : null,\n ].filter(Boolean).join(\" × \")\n : null;\n\n return `

\n ${item.image\n ? ` $\"${escHtml(item.name)}\"$ `\n : `

No image available

`}\n

${escHtml(item.name)}

\n\n ${section(\"Equipment Details\",\n row(\"Brand\", item.brand),\n row(\"Category\", item.category),\n row(\"Sub-category\", item.subCategory),\n row(\"Lead Time\", item.leadTime != null ? `${item.leadTime} weeks` : null)\n )}\n\n ${section(\"Serving Info\",\n row(\"Headcount Serviced\", item.headcount),\n row(\"Capacity\", item.capacity)\n )}\n\n ${section(\"Add-Ons\",\n row(\"Required\", item.necessaryAddons),\n row(\"Optional\", item.optionalAddons)\n )}\n\n ${section(\"Specs\",\n row(\"Waterline\", item.waterline),\n row(\"Floor Drain\", item.floorDrain),\n row(\"Voltage\", item.voltageRequired),\n row(\"Hertz\", item.hertzRequired),\n row(\"Amps\", item.electricalAmps),\n row(\"Plug Type\", item.electricalPlug),\n row(\"Countertop Hole\", item.countertopHole),\n row(\"Hole Size (in)\", item.countertopHoleSize)\n )}\n\n ${section(\"Dimensions\",\n row(\"H × W × D\", dimStr),\n row(\"Left/Right Clearance\", item.leftRightClearance),\n row(\"Front/Back Clearance\", item.frontBackClearance),\n row(\"Top/Bottom Clearance\", item.topBottomClearance)\n )}\n\n ${withPricing ? section(\"Pricing\",\n row(\"1-Yr Rental\", item.rental1yr),\n row(\"2-Yr Rental\", item.rental2yr),\n row(\"3-Yr Rental\", item.rental3yr),\n row(\"1-Yr Spend Min (Free Equip)\", item.spend1yr),\n row(\"2-Yr Spend Min (Free Equip)\", item.spend2yr),\n row(\"3-Yr Spend Min (Free Equip)\", item.spend3yr)\n ) : \"\"}\n\n

\n ${item.specSheet\n ? `View Spec Sheet →`\n : \"\"}\n

`;\n }).join(\"\")\n : `

No equipment has been added to this proposal yet.

`;\n\n // Table rows\n const tableRows = equipment.length\n ? equipment.map(item => {\n const td = (v, link = false) => {\n if (link && v) return `View →`;\n return `${escHtml(v) || \"—\"}`;\n };\n\n return `\n \n ${item.image ? ` $\"${escHtml(item.name)}\"$ ` : `

`}\n \n \n ${escHtml(item.name)}\n \n ${td(item.brand)}\n ${td(item.category)}\n ${td(item.subCategory)}\n ${td(item.modelNum)}\n ${td(item.necessaryAddons ? item.necessaryAddons.replace(/, /g, \" | \").trim() : null)}\n ${item.leadTime != null ? `${item.leadTime} wks` : \"—\"}\n ${item.width != null ? `${item.width}\"` : \"—\"}\n ${item.depth != null ? `${item.depth}\"` : \"—\"}\n ${item.height != null ? `${item.height}\"` : \"—\"}\n ${td(item.leftRightClearance)}\n ${td(item.frontBackClearance)}\n ${td(item.topBottomClearance)}\n ${td(item.countertopHole)}\n ${td(item.countertopHoleSize)}\n ${td(item.waterline)}\n ${td(item.floorDrain)}\n ${td(item.capacity)}\n ${td(item.headcount)}\n ${td(item.specSheet, true)}\n ${withPricing ? `${td(item.rental1yr)}${td(item.rental2yr)}${td(item.rental3yr)}${td(item.spend1yr)}${td(item.spend2yr)}${td(item.spend3yr)}` : \"\"}\n `;\n }).join(\"\")\n : `No equipment added yet.`;\n\n // Full HTML\n return `\n\n\n \n \n Equipment Proposal — ${escHtml(clientName)}\n \n \n\n\n\n\n\n

${escHtml(clientName)}

Your recommended equipment, curated by the Crafty team

\n ${equipment.length} item${equipment.length !== 1 ? \"s\" : \"\"}\n

\n\n

\n ${galleryCards}\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${withPricing ? `` : \"\"}\n \n \n \n ${tableRows}\n \n

	Equipment	Brand	Category	Sub-category	Model #	Required Add-ons	Lead Time (wks)	W (in)	D (in)	H (in)	Left/Right Clearance	Front/Back Clearance	Top/Bottom Clearance	Countertop Hole(s)	Hole Size (in)	Waterline	Floor Drain	Capacity	Headcount	Spec Sheet	1-Yr Rental	2-Yr Rental	3-Yr Rental	1-Yr Spend Min	2-Yr Spend Min	3-Yr Spend Min

\n\n

Looking for something else?

\n Browse the full equipment catalog →\n

\n\n\n\n\n\n\n`;\n}\n\n// ── Catalog handler ───────────────────────────────────────────────────────────\n\nasync function handleCatalog(proposalId = null) {\n try {\n // Fetch all equipment with pagination (Notion returns max 100 per request)\n const allPages = [];\n let cursor = null;\n do {\n const body = cursor ? { start_cursor: cursor } : {};\n const result = await notionFetch(`/databases/${CATALOG_DB_ID}/query`, body);\n allPages.push(...(result.results || []));\n cursor = result.has_more ? result.next_cursor : null;\n } while (cursor);\n\n // Parse each equipment record\n const items = allPages.map(page => {\n const p = page.properties;\n return {\n name: getTitle(tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\")) || \"Unnamed\",\n image: getFileUrl(tryProp(p, \"Equipment Image\", \"🚫 Equipment Image\")),\n brand: getField(tryProp(p, \"Brand Name\", \"Brand\")),\n category: getField(tryProp(p, \"Category\")),\n subCategory: getField(tryProp(p, \"Sub-category\")),\n leadTime: getNumber(tryProp(p, \"Lead Time (weeks)\", \"Lead Time (Weeks)\")),\n modelNum: getField(tryProp(p, \"Model #\")),\n specSheet: getFileUrl(tryProp(p, \"Spec Sheet PDF\")),\n capacity: getField(tryProp(p, \"Capacity\")),\n height: getNumber(tryProp(p, \"Height (in)\")),\n width: getNumber(tryProp(p, \"Width (in)\")),\n depth: getNumber(tryProp(p, \"Depth (in)\")),\n waterline: getField(tryProp(p, \"Waterline\")),\n floorDrain: getField(tryProp(p, \"Floor Drain\")),\n voltage: getField(tryProp(p, \"Voltage Required\")),\n hertz: getField(tryProp(p, \"Hertz Required\")),\n amps: getField(tryProp(p, \"Electrical Amps\")),\n plug: getField(tryProp(p, \"Electrical Plug\")),\n countertopHole: getField(tryProp(p, \"Countertop Holes Required\", \"Countertop Hole(s) Required\")),\n countertopHoleSize: getField(tryProp(p, \"Countertop Hole Size (in)\")),\n leftRight: getField(tryProp(p, \"Left/Right Clearance\")),\n frontBack: getField(tryProp(p, \"Front/Back Clearance\")),\n topBottom: getField(tryProp(p, \"Top/Bottom Clearance\")),\n headcount: getField(tryProp(p, \"Headcount this machine serves\")),\n addons: getField(tryProp(p, \"Required Add-ons\", \"Necessary Add-Ons\")) || getRichText(tryProp(p, \"Required Add-ons\", \"Necessary Add-Ons\")),\n optionalAddons: getRichText(tryProp(p, \"Optional Add-ons\", \"Optional Add-Ons\")),\n markets: (() => {\n const prop = tryProp(p, \"Available Markets\", \"Markets\", \"Market\");\n if (!prop) return [];\n if (prop.type === \"multi_select\") return prop.multi_select?.map(s => s.name) || [];\n if (prop.type === \"select\") return prop.select?.name ? [prop.select.name] : [];\n return [];\n })(),\n };\n }).filter(i => i.name !== \"Unnamed\");\n\n // Collect unique categories and subcategories for filter dropdowns\n const categories = [...new Set(items.map(i => i.category).filter(Boolean))].sort();\n const subCatMap = {};\n for (const item of items) {\n if (item.category && item.subCategory) {\n if (!subCatMap[item.category]) subCatMap[item.category] = new Set();\n subCatMap[item.category].add(item.subCategory);\n }\n }\n\n // Unique markets (flattened from all items)\n const markets = [...new Set(items.flatMap(i => i.markets))].sort();\n\n // Unique lead times (sorted numerically)\n const leadTimes = [...new Set(items.map(i => i.leadTime).filter(v => v != null))].sort((a, b) => a - b);\n\n return respond(buildCatalogPage(items, categories, subCatMap, markets, leadTimes, proposalId));\n } catch (err) {\n console.error(\"Catalog error:\", err);\n return respond(errorPage(\"Something went wrong\", \"Unable to load the equipment catalog. Please try again.\"), 500);\n }\n}\n\n// ── Catalog page builder ──────────────────────────────────────────────────────\n\nfunction buildCatalogPage(items, categories, subCatMap, markets, leadTimes, proposalId = null) {\n const dataJson = JSON.stringify(items.map(item => ({\n name: item.name,\n image: item.image || \"\",\n brand: item.brand || \"\",\n category: item.category || \"\",\n subCategory: item.subCategory || \"\",\n leadTime: item.leadTime,\n modelNum: item.modelNum || \"\",\n specSheet: item.specSheet || \"\",\n capacity: item.capacity || \"\",\n height: item.height,\n width: item.width,\n depth: item.depth,\n waterline: item.waterline || \"\",\n floorDrain: item.floorDrain || \"\",\n voltage: item.voltage || \"\",\n hertz: item.hertz || \"\",\n amps: item.amps || \"\",\n plug: item.plug || \"\",\n countertopHole: item.countertopHole || \"\",\n countertopHoleSize: item.countertopHoleSize || \"\",\n leftRight: item.leftRight || \"\",\n frontBack: item.frontBack || \"\",\n topBottom: item.topBottom || \"\",\n headcount: item.headcount || \"\",\n addons: item.addons || \"\",\n optionalAddons: item.optionalAddons || \"\",\n markets: item.markets || [],\n })));\n\n const mkCheckbox = (filterName, val, label) =>\n `${escHtml(label)}`;\n\n const categoryCheckboxes = categories.map(c => mkCheckbox(\"category\", c, c)).join(\"\");\n const allSubCats = [...new Set(items.map(i => i.subCategory).filter(Boolean))].sort();\n const subCatCheckboxes = allSubCats.map(s => mkCheckbox(\"subcategory\", s, s)).join(\"\");\n const marketCheckboxes = markets.map(m => mkCheckbox(\"market\", m, m)).join(\"\");\n const leadTimeCheckboxes = leadTimes.map(lt => mkCheckbox(\"leadtime\", lt, lt + \" weeks\")).join(\"\");\n\n const subCatMapJson = JSON.stringify(\n Object.fromEntries(Object.entries(subCatMap).map(([k, v]) => [k, [...v].sort()]))\n );\n\n return `\n\n\n \n \n Equipment Catalog — Crafty Delivers\n \n \n\n\n\n\n\n

Equipment Catalog

Full Equipment Catalog

Browse all ${items.length} pieces of equipment Crafty offers

\n\n

\n \n\n

\n All Categories▾\n

${categoryCheckboxes}

\n\n ${subCatCheckboxes ? `

\n All Sub-categories▾\n

${subCatCheckboxes}

` : \"\"}\n\n ${marketCheckboxes ? `

\n All Markets▾\n

${marketCheckboxes}

` : \"\"}\n\n ${leadTimeCheckboxes ? `

\n Any Lead Time▾\n

${leadTimeCheckboxes}

` : \"\"}\n\n \n ${items.length} items\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

	Equipment	Brand	Category	Sub-category	Model #	Required Add-ons	Lead Time (wks)	W (in)	D (in)	H (in)	Left/Right Clearance	Front/Back Clearance	Top/Bottom Clearance	Countertop Hole(s)	Hole Size (in)	Waterline	Floor Drain	Capacity	Headcount	Spec Sheet

\n\n\n\n\n\n\n`;\n}","// ─────────────────────────────────────────────────────────────────────────────\n// Crafty Delivers — Client Equipment Proposal Page\n// Deploy this file to Val.town as an HTTP handler.\n//\n// Required environment variables (set in Val.town → Settings → Environment):\n// NOTION_API_KEY — your Notion integration token\n// PROPOSALS_DB_ID — the Client Equipment Proposals database ID\n// ─────────────────────────────────────────────────────────────────────────────\n\nconst NOTION_VERSION = \"2022-06-28\";\n\n// ── Notion API helpers ────────────────────────────────────────────────────────\n\nasync function notionFetch(path, body = null) {\n const res = await fetch(`https://api.notion.com/v1${path}`, {\n method: body ? \"POST\" : \"GET\",\n headers: {\n \"Authorization\": `Bearer ${Deno.env.get(\"NOTION_API_KEY\")}`,\n \"Notion-Version\": NOTION_VERSION,\n \"Content-Type\": \"application/json\",\n },\n ...(body && { body: JSON.stringify(body) }),\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Notion API ${res.status}: ${text}`);\n }\n return res.json();\n}\n\n// Returns string from a title property\nfunction getTitle(prop) {\n return prop?.title?.map((t) => t.plain_text).join(\"\") || null;\n}\n\n// Returns string from rich_text, multi_select, or select property\nfunction getRichText(prop) {\n if (!prop) return null;\n if (prop.type === \"rich_text\") {\n return prop.rich_text?.map((t) => t.plain_text).join(\"\") || null;\n }\n if (prop.type === \"multi_select\") {\n return prop.multi_select?.map((s) => s.name).join(\", \") || null;\n }\n if (prop.type === \"select\") return prop.select?.name || null;\n return null;\n}\n\n// Returns number value\nfunction getNumber(prop) {\n return prop?.number ?? null;\n}\n\n// Returns URL from a files property\nfunction getFileUrl(prop) {\n if (!prop?.files?.length) return null;\n const f = prop.files[0];\n return f.type === \"external\" ? f.external.url : (f.file?.url ?? null);\n}\n\n// Generic field reader — handles checkbox, number, select, rich_text, multi_select, title, formula\nfunction getField(prop) {\n if (!prop) return null;\n switch (prop.type) {\n case \"checkbox\":\n return prop.checkbox === true\n ? \"Yes\"\n : prop.checkbox === false\n ? \"No\"\n : null;\n case \"number\":\n return prop.number != null ? String(prop.number) : null;\n case \"select\":\n return prop.select?.name || null;\n case \"multi_select\":\n return prop.multi_select?.map((s) => s.name).join(\", \") || null;\n case \"rich_text\":\n return prop.rich_text?.map((t) => t.plain_text).join(\"\") || null;\n case \"title\":\n return prop.title?.map((t) => t.plain_text).join(\"\") || null;\n case \"formula\":\n return prop.formula?.string ||\n (prop.formula?.number != null ? String(prop.formula.number) : null);\n case \"email\":\n return prop.email || null;\n default:\n return null;\n }\n}\n\n// Try a list of property names, return the first one that exists\nfunction tryProp(properties, ...names) {\n for (const name of names) {\n if (properties[name] !== undefined) return properties[name];\n }\n return null;\n}\n\nfunction escHtml(str) {\n if (str == null) return \"\";\n return String(str)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\nconst CATALOG_DB_ID = \"388ae2b9bd0480a29f2be68ca84d1089\";\n\n// ── Main handler ──────────────────────────────────────────────────────────────\n\nexport default async function handler(req) {\n const url = new URL(req.url);\n\n // Route to catalog page\n if (url.pathname === \"/catalog\" || url.pathname === \"/catalog/\") {\n return handleCatalog(url.searchParams.get(\"proposal_id\") || null);\n }\n\n // Determine if this is a pricing proposal\n const withPricing = url.pathname === \"/pricing\" ||\n url.pathname === \"/pricing/\";\n\n const proposalIdRaw = url.searchParams.get(\"proposal_id\");\n // Accept both plain numbers (\"5\") and prefixed format (\"PROP-5\")\n const proposalIdNum = proposalIdRaw\n ? parseInt(proposalIdRaw.replace(/^[^0-9]*/, \"\"), 10)\n : NaN;\n\n if (!proposalIdRaw || isNaN(proposalIdNum)) {\n return respond(\n errorPage(\n \"Invalid link\",\n \"This proposal link is missing or invalid. Please contact your Crafty Delivers representative.\",\n ),\n );\n }\n\n return handleProposal(proposalIdNum, withPricing);\n}\n\n// ── Proposal handler (shared by standard and pricing routes) ──────────────────\n\nasync function handleProposal(proposalId, withPricing = false) {\n try {\n // 1. Resolve the actual database ID (handles case where ID is a page containing the database)\n let dbId = Deno.env.get(\"PROPOSALS_DB_ID\");\n let queryResult;\n\n try {\n queryResult = await notionFetch(`/databases/${dbId}/query`, {});\n } catch (firstErr) {\n if (firstErr.message.includes(\"is a page, not a database\")) {\n const blocks = await notionFetch(`/blocks/${dbId}/children`);\n const dbBlock = blocks.results?.find((b) =>\n b.type === \"child_database\"\n );\n if (!dbBlock) {\n throw new Error(\"No database found inside the provided page ID\");\n }\n dbId = dbBlock.id;\n queryResult = await notionFetch(`/databases/${dbId}/query`, {});\n } else {\n throw firstErr;\n }\n }\n\n console.log(\"Total proposals fetched:\", queryResult.results?.length);\n\n // 2. Find proposal matching the URL ID\n const proposal = queryResult.results?.find((page) => {\n const idProp = page.properties[\"Proposal ID\"];\n return idProp?.unique_id?.number === parseInt(proposalId);\n });\n\n if (!proposal) {\n return respond(\n errorPage(\n \"Proposal not found\",\n \"We couldn't find this proposal. Please check your link or contact your Crafty Delivers representative.\",\n ),\n );\n }\n const pProps = proposal.properties;\n\n // Debug: log all proposal property keys and the raw SE Email value\n console.log(\"Proposal property keys:\", Object.keys(pProps));\n console.log(\"SE Email raw:\", JSON.stringify(pProps[\"SE Email\"]));\n\n // 3. Extract client name\n // Debug: log all proposal property keys to confirm exact field names\n console.log(\n \"All proposal property keys:\",\n JSON.stringify(Object.keys(pProps)),\n );\n const clientNameKey = Object.keys(pProps).find((k) =>\n k.toLowerCase().includes(\"client facing\")\n );\n console.log(\"Client Facing key found:\", clientNameKey);\n if (clientNameKey) {\n console.log(\n \"Client Facing raw value:\",\n JSON.stringify(pProps[clientNameKey]),\n );\n }\n\n const clientName = (clientNameKey\n ? (getRichText(pProps[clientNameKey]) ||\n getTitle(pProps[clientNameKey]) || getField(pProps[clientNameKey]))\n : null) ||\n getRichText(pProps[\"Client Facing Page Name\"]) ||\n getTitle(pProps[\"Client Facing Page Name\"]) ||\n getRichText(\n pProps[\"✏️ Client Facing Page Name (e.g. Jaco, Ltd's Equipment)\"],\n ) ||\n getTitle(\n pProps[\"✏️ Client Facing Page Name (e.g. Jaco, Ltd's Equipment)\"],\n ) ||\n getTitle(pProps[\"Page Name\"]) ||\n getTitle(pProps[\"Name\"]) ||\n \"Your Company\";\n\n // 3b. Extract sales exec name and email\n const salesExecKey = Object.keys(pProps).find((k) =>\n k.toLowerCase().includes(\"sales exec\")\n );\n const salesExecName = (salesExecKey\n ? (getRichText(pProps[salesExecKey]) || getTitle(pProps[salesExecKey]) ||\n getField(pProps[salesExecKey]))\n : null) ||\n getRichText(pProps[\"Sales Exec\"]) ||\n getTitle(pProps[\"Sales Exec\"]) ||\n getField(pProps[\"Sales Exec\"]) ||\n null;\n\n const salesExecEmail = pProps[\"SE Email\"]?.formula?.string ||\n getField(pProps[\"SE Email\"]) ||\n null;\n\n // 4. Get related equipment page IDs\n const equipmentIds =\n pProps[\" ✏️ Recommended Equipment\"]?.relation?.map((r) =>\n r.id\n ) ||\n pProps[\"Crafty Equipment Catalog\"]?.relation?.map((r) => r.id) ||\n [];\n\n if (!equipmentIds.length) {\n return respond(\n buildPage(clientName, [], salesExecName, salesExecEmail, proposalId),\n );\n }\n\n // 5. Fetch all equipment pages in parallel\n const equipmentPages = await Promise.all(\n equipmentIds.map((id) => notionFetch(`/pages/${id}`)),\n );\n\n // Debug: log equipment property keys from first item so we can confirm field names\n if (equipmentPages.length > 0) {\n console.log(\n \"Equipment property keys:\",\n Object.keys(equipmentPages[0].properties),\n );\n const p0 = equipmentPages[0].properties;\n for (const [k, v] of Object.entries(p0)) {\n if (v.type === \"title\") {\n console.log(\n `TITLE field: \"${k}\" =`,\n JSON.stringify(v.title?.map((t) => t.plain_text)),\n );\n }\n if (k.toLowerCase().includes(\"lead\")) {\n console.log(\n `LEAD TIME field: \"${k}\": type=${v.type}, value=`,\n JSON.stringify(v[v.type]),\n );\n }\n }\n }\n\n // 6. Parse each equipment page\n const equipment = equipmentPages.map((page) => {\n const p = page.properties;\n\n // Name: \"Master Name\" is the title field in this database\n const nameRaw =\n getTitle(\n tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\", \"Item Name\"),\n ) ||\n getField(\n tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\", \"Item Name\"),\n ) ||\n null;\n\n // Image\n const image = getFileUrl(\n tryProp(\n p,\n \"Equipment Image\",\n \"🚫 Equipment Image\",\n \"Image\",\n \"Images\",\n \"Photo\",\n ),\n );\n\n // Spec sheet PDF\n const specSheet = getFileUrl(\n tryProp(\n p,\n \"Spec Sheet PDF\",\n \"🚫 Equipment Specs (pdf)\",\n \"Spec Sheet\",\n \"Equipment Specs (pdf)\",\n ),\n );\n\n // Lead time — single field \"Lead Time (weeks)\" in this database\n const leadTime = getNumber(\n tryProp(p, \"Lead Time (weeks)\", \"Lead Time (Weeks)\"),\n );\n\n // Add-ons — \"Card — Necessary Add-Ons\" is a pre-computed formula on the equipment record\n const addOnProp = tryProp(\n p,\n \"Card — Necessary Add-Ons\",\n \"Required Add-ons\",\n \"Necessary Add-Ons\",\n \"Necessary add-ons\",\n \"Required Add-Ons\",\n );\n const necessaryAddons = getField(addOnProp) || getRichText(addOnProp);\n console.log(\"necessaryAddons value:\", JSON.stringify(necessaryAddons));\n const optionalAddons = getRichText(\n tryProp(p, \"Optional Add-ons\", \"Optional Add-Ons\", \"Optional add-ons\"),\n );\n\n // Brand / category\n const brand = getField(\n tryProp(p, \"Brand Name\", \"Brand\", \"🚫 Brand Name\", \"🚫 Brand\"),\n );\n const category = getField(tryProp(p, \"Category\", \"🚫 Category\"));\n const subCategory = getField(\n tryProp(\n p,\n \"Sub-category\",\n \"Sub-Category\",\n \"Subcategory\",\n \"🚫 Sub-category\",\n \"🚫 Sub-Category\",\n ),\n );\n\n // Dimensions\n const width = getNumber(tryProp(p, \"Width (in)\", \"🚫 Width (in)\"));\n const depth = getNumber(tryProp(p, \"Depth (in)\", \"🚫 Depth (in)\"));\n const height = getNumber(tryProp(p, \"Height (in)\", \"🚫 Height (in)\"));\n\n // Clearances\n const leftRightClearance = getField(\n tryProp(p, \"Left/Right Clearance\", \"🚫 Left/Right Clearance\"),\n );\n const frontBackClearance = getField(\n tryProp(p, \"Front/Back Clearance\", \"🚫 Front/Back Clearance\"),\n );\n const topBottomClearance = getField(\n tryProp(p, \"Top/Bottom Clearance\", \"🚫 Top/Bottom Clearance\"),\n );\n\n // Electrical\n const voltageRequired = getField(\n tryProp(p, \"Voltage Required\", \"🚫 Voltage Required\"),\n );\n const hertzRequired = getField(\n tryProp(p, \"Hertz Required\", \"🚫 Hertz Required\"),\n );\n const electricalAmps = getField(\n tryProp(p, \"Electrical Amps\", \"🚫 Electrical Amps\"),\n );\n const electricalPlug = getField(\n tryProp(p, \"Electrical Plug\", \"🚫 Electrical Plug\"),\n );\n\n // Plumbing / install\n const waterline = getField(tryProp(p, \"Waterline\", \"🚫 Waterline\"));\n const floorDrain = getField(tryProp(p, \"Floor Drain\", \"🚫 Floor Drain\"));\n const countertopHole = getField(\n tryProp(\n p,\n \"Countertop Holes Required\",\n \"Countertop Hole(s) Required\",\n \"🚫 Countertop Holes Required\",\n ),\n );\n const countertopHoleSize = getField(\n tryProp(p, \"Countertop Hole Size (in)\", \"🚫 Countertop Hole Size (in)\"),\n );\n\n // General\n const capacity = getField(tryProp(p, \"Capacity\", \"🚫 Capacity\"));\n const headcount = getField(\n tryProp(\n p,\n \"Headcount this machine serves\",\n \"🚫 Headcount this machine serves\",\n ),\n );\n const modelNum = getField(\n tryProp(p, \"Model #\", \"🚫 Model #\", \"Model Number\"),\n );\n\n // If name wasn't found, fall back to model number, then generic label\n const name = nameRaw || (modelNum ? `Model ${modelNum}` : \"Unnamed Item\");\n\n // Pricing fields (only fetched/used on the pricing route)\n if (withPricing) {\n const pricingKeys = Object.keys(p).filter((k) =>\n k.toLowerCase().includes(\"rental\") ||\n k.toLowerCase().includes(\"spend\") || k.toLowerCase().includes(\"yr\")\n );\n console.log(\n \"Pricing-related field names:\",\n JSON.stringify(pricingKeys),\n );\n pricingKeys.forEach((k) =>\n console.log(\n ` \"${k}\": type=${p[k].type}, value=`,\n JSON.stringify(p[k][p[k].type]),\n )\n );\n }\n const rental1yr = withPricing\n ? getField(\n tryProp(\n p,\n \"1-Yr Rental\",\n \"1-YR Rental\",\n \"1-Year Rental\",\n \"1 Yr Rental\",\n \"1 YR Rental\",\n ),\n )\n : null;\n const rental2yr = withPricing\n ? getField(\n tryProp(\n p,\n \"2-YR Rental\",\n \"2-Yr Rental\",\n \"2-Year Rental\",\n \"2 Yr Rental\",\n \"2 YR Rental\",\n ),\n )\n : null;\n const rental3yr = withPricing\n ? getField(\n tryProp(\n p,\n \"3-YR Rental\",\n \"3-Yr Rental\",\n \"3-Year Rental\",\n \"3 Yr Rental\",\n \"3 YR Rental\",\n \"3-YR rental\",\n ),\n )\n : null;\n const spend1yr = withPricing\n ? getField(\n tryProp(\n p,\n \"1 - YR Spend Minimum for Free Equipment\",\n \"1-YR Spend Minimum for Free Equipment\",\n \"1-Yr Spend Minimum for Free Equipment\",\n \"1 YR Spend Minimum for Free Equipment\",\n \"1 Yr Spend Minimum\",\n ),\n )\n : null;\n const spend2yr = withPricing\n ? getField(\n tryProp(\n p,\n \"2 - YR Spend Minimum for Free Equipment\",\n \"2-YR Spend Minimum for Free Equipment\",\n \"2-Yr Spend Minimum for Free Equipment\",\n \"2 YR Spend Minimum for Free Equipment\",\n \"2 Yr Spend Minimum\",\n ),\n )\n : null;\n const spend3yr = withPricing\n ? getField(\n tryProp(\n p,\n \"3 - YR Spend Minimum for Free Equipment\",\n \"3-YR Spend Minimum for Free Equipment\",\n \"3-Yr Spend Minimum for Free Equipment\",\n \"3 YR Spend Minimum for Free Equipment\",\n \"3 Yr Spend Minimum\",\n ),\n )\n : null;\n\n return {\n name,\n image,\n specSheet,\n leadTime,\n necessaryAddons,\n optionalAddons,\n brand,\n category,\n subCategory,\n width,\n depth,\n height,\n leftRightClearance,\n frontBackClearance,\n topBottomClearance,\n voltageRequired,\n hertzRequired,\n electricalAmps,\n electricalPlug,\n waterline,\n floorDrain,\n countertopHole,\n countertopHoleSize,\n capacity,\n headcount,\n modelNum,\n rental1yr,\n rental2yr,\n rental3yr,\n spend1yr,\n spend2yr,\n spend3yr,\n };\n });\n\n if (withPricing) {\n return respond(\n buildPricingPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n ),\n );\n }\n return respond(\n buildPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n ),\n );\n } catch (err) {\n console.error(\"Proposal page error:\", err);\n return respond(\n errorPage(\n \"Something went wrong\",\n \"Please try refreshing the page. If the problem persists, contact your Crafty Delivers representative.\",\n ),\n 500,\n );\n }\n}\n\n// ── Response helper ───────────────────────────────────────────────────────────\n\nfunction respond(html, status = 200) {\n return new Response(html, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\n// ── Error page ────────────────────────────────────────────────────────────────\n\nfunction errorPage(title, message) {\n return `\n\n\n \n \n Crafty Delivers\n \n\n\n

${escHtml(title)}

${escHtml(message)}

\n\n`;\n}\n\n// ── Main page builder ─────────────────────────────────────────────────────────\n\nfunction buildPricingPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n) {\n return buildPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n true,\n );\n}\n\nfunction buildPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n withPricing = false,\n) {\n // Pre-compute footer values to avoid quote conflicts inside template literals\n const displayEmail = salesExecEmail || \"hello@craftydelivers.com\";\n\n // Helper: renders a spec row only if value is non-null/non-empty\n const row = (label, value) => {\n if (value == null || value === \"\") return \"\";\n return `

\n ${escHtml(label)}\n ${escHtml(String(value))}\n

${\n escHtml(title)\n }

${content}

`;\n };\n\n // Gallery cards\n const galleryCards = equipment.length\n ? equipment.map((item) => {\n const dimStr =\n (item.height != null || item.width != null || item.depth != null)\n ? [\n item.height != null ? `${item.height}\" H` : null,\n item.width != null ? `${item.width}\" W` : null,\n item.depth != null ? `${item.depth}\" D` : null,\n ].filter(Boolean).join(\" × \")\n : null;\n\n return `

\n ${\n item.image\n ? ` $\"${\n$ `\n : `

No image available

`\n }\n

${escHtml(item.name)}

\n\n ${\n section(\n \"Equipment Details\",\n row(\"Brand\", item.brand),\n row(\"Category\", item.category),\n row(\"Sub-category\", item.subCategory),\n row(\n \"Lead Time\",\n item.leadTime != null ? `${item.leadTime} weeks` : null,\n ),\n )\n }\n\n ${\n section(\n \"Serving Info\",\n row(\"Headcount Serviced\", item.headcount),\n row(\"Capacity\", item.capacity),\n )\n }\n\n ${\n section(\n \"Add-Ons\",\n row(\"Required\", item.necessaryAddons),\n row(\"Optional\", item.optionalAddons),\n )\n }\n\n ${\n section(\n \"Specs\",\n row(\"Waterline\", item.waterline),\n row(\"Floor Drain\", item.floorDrain),\n row(\"Voltage\", item.voltageRequired),\n row(\"Hertz\", item.hertzRequired),\n row(\"Amps\", item.electricalAmps),\n row(\"Plug Type\", item.electricalPlug),\n row(\"Countertop Hole\", item.countertopHole),\n row(\"Hole Size (in)\", item.countertopHoleSize),\n )\n }\n\n ${\n section(\n \"Dimensions\",\n row(\"H × W × D\", dimStr),\n row(\"Left/Right Clearance\", item.leftRightClearance),\n row(\"Front/Back Clearance\", item.frontBackClearance),\n row(\"Top/Bottom Clearance\", item.topBottomClearance),\n )\n }\n\n ${\n withPricing\n ? section(\n \"Pricing\",\n row(\"1-Yr Rental\", item.rental1yr),\n row(\"2-Yr Rental\", item.rental2yr),\n row(\"3-Yr Rental\", item.rental3yr),\n row(\"1-Yr Spend Min (Free Equip)\", item.spend1yr),\n row(\"2-Yr Spend Min (Free Equip)\", item.spend2yr),\n row(\"3-Yr Spend Min (Free Equip)\", item.spend3yr),\n )\n : \"\"\n }\n\n

\n ${\n item.specSheet\n ? `View Spec Sheet →`\n : \"\"\n }\n

`;\n }).join(\"\")\n : `

No equipment has been added to this proposal yet.

`;\n\n // Table rows\n const tableRows = equipment.length\n ? equipment.map((item) => {\n const td = (v, link = false) => {\n if (link && v) {\n return `View →`;\n }\n return `${escHtml(v) || \"—\"}`;\n };\n\n return `\n \n ${\n item.image\n ? ` $\"${\n$ `\n : `

`\n }\n \n \n ${escHtml(item.name)}\n \n ${td(item.brand)}\n ${td(item.category)}\n ${td(item.subCategory)}\n ${td(item.modelNum)}\n ${\n escHtml(\n item.necessaryAddons\n ? item.necessaryAddons.replace(/, /g, \" | \").trim()\n : \"\",\n ) || \"—\"\n }\n ${item.leadTime != null ? `${item.leadTime} wks` : \"—\"}\n ${item.width != null ? `${item.width}\"` : \"—\"}\n ${item.depth != null ? `${item.depth}\"` : \"—\"}\n ${item.height != null ? `${item.height}\"` : \"—\"}\n ${td(item.leftRightClearance)}\n ${td(item.frontBackClearance)}\n ${td(item.topBottomClearance)}\n ${td(item.countertopHole)}\n ${td(item.countertopHoleSize)}\n ${td(item.waterline)}\n ${td(item.floorDrain)}\n ${td(item.capacity)}\n ${td(item.headcount)}\n ${td(item.specSheet, true)}\n ${\n withPricing\n ? `${td(item.rental1yr)}${td(item.rental2yr)}${td(item.rental3yr)}${\n td(item.spend1yr)\n }${td(item.spend2yr)}${td(item.spend3yr)}`\n : \"\"\n }\n `;\n }).join(\"\")\n : `No equipment added yet.`;\n\n // Full HTML\n return `\n\n\n \n \n Equipment Proposal — ${escHtml(clientName)}\n \n \n\n\n\n\n\n

${escHtml(clientName)}

Your recommended equipment, curated by the Crafty team

\n ${equipment.length} item${\n equipment.length !== 1 ? \"s\" : \"\"\n }\n

\n\n

\n ${galleryCards}\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${\n withPricing\n ? ``\n : \"\"\n }\n \n \n \n ${tableRows}\n \n

	Equipment	Brand	Category	Sub-category	Model #	Required Add-ons	Lead Time (wks)	W (in)	D (in)	H (in)	Left/Right Clearance	Front/Back Clearance	Top/Bottom Clearance	Countertop Hole(s)	Hole Size (in)	Waterline	Floor Drain	Capacity	Headcount	Spec Sheet	1-Yr Rental	2-Yr Rental	3-Yr Rental	1-Yr Spend Min	2-Yr Spend Min	3-Yr Spend Min

\n\n

Looking for something else?

\n Browse the full equipment catalog →\n

\n\n\n\n\n\n\n`;\n}\n\n// ── Catalog handler ───────────────────────────────────────────────────────────\n\nasync function handleCatalog(proposalId = null) {\n try {\n // Fetch all equipment with pagination (Notion returns max 100 per request)\n const allPages = [];\n let cursor = null;\n do {\n const body = cursor ? { start_cursor: cursor } : {};\n const result = await notionFetch(\n `/databases/${CATALOG_DB_ID}/query`,\n body,\n );\n allPages.push(...(result.results || []));\n cursor = result.has_more ? result.next_cursor : null;\n } while (cursor);\n\n // Parse each equipment record\n const items = allPages.map((page) => {\n const p = page.properties;\n return {\n name: getTitle(tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\")) ||\n \"Unnamed\",\n image: getFileUrl(tryProp(p, \"Equipment Image\", \"🚫 Equipment Image\")),\n brand: getField(tryProp(p, \"Brand Name\", \"Brand\")),\n category: getField(tryProp(p, \"Category\")),\n subCategory: getField(tryProp(p, \"Sub-category\")),\n leadTime: getNumber(\n tryProp(p, \"Lead Time (weeks)\", \"Lead Time (Weeks)\"),\n ),\n modelNum: getField(tryProp(p, \"Model #\")),\n specSheet: getFileUrl(tryProp(p, \"Spec Sheet PDF\")),\n capacity: getField(tryProp(p, \"Capacity\")),\n height: getNumber(tryProp(p, \"Height (in)\")),\n width: getNumber(tryProp(p, \"Width (in)\")),\n depth: getNumber(tryProp(p, \"Depth (in)\")),\n waterline: getField(tryProp(p, \"Waterline\")),\n floorDrain: getField(tryProp(p, \"Floor Drain\")),\n voltage: getField(tryProp(p, \"Voltage Required\")),\n hertz: getField(tryProp(p, \"Hertz Required\")),\n amps: getField(tryProp(p, \"Electrical Amps\")),\n plug: getField(tryProp(p, \"Electrical Plug\")),\n countertopHole: getField(\n tryProp(\n p,\n \"Countertop Holes Required\",\n \"Countertop Hole(s) Required\",\n ),\n ),\n countertopHoleSize: getField(tryProp(p, \"Countertop Hole Size (in)\")),\n leftRight: getField(tryProp(p, \"Left/Right Clearance\")),\n frontBack: getField(tryProp(p, \"Front/Back Clearance\")),\n topBottom: getField(tryProp(p, \"Top/Bottom Clearance\")),\n headcount: getField(tryProp(p, \"Headcount this machine serves\")),\n addons: getField(tryProp(p, \"Required Add-ons\", \"Necessary Add-Ons\")) ||\n getRichText(tryProp(p, \"Required Add-ons\", \"Necessary Add-Ons\")),\n optionalAddons: getRichText(\n tryProp(p, \"Optional Add-ons\", \"Optional Add-Ons\"),\n ),\n markets: (() => {\n const prop = tryProp(p, \"Available Markets\", \"Markets\", \"Market\");\n if (!prop) return [];\n if (prop.type === \"multi_select\") {\n return prop.multi_select?.map((s) => s.name) || [];\n }\n if (prop.type === \"select\") {\n return prop.select?.name\n ? [prop.select.name]\n : [];\n }\n return [];\n })(),\n };\n }).filter((i) => i.name !== \"Unnamed\");\n\n // Collect unique categories and subcategories for filter dropdowns\n const categories = [\n ...new Set(items.map((i) => i.category).filter(Boolean)),\n ].sort();\n const subCatMap = {};\n for (const item of items) {\n if (item.category && item.subCategory) {\n if (!subCatMap[item.category]) subCatMap[item.category] = new Set();\n subCatMap[item.category].add(item.subCategory);\n }\n }\n\n // Unique markets (flattened from all items)\n const markets = [...new Set(items.flatMap((i) => i.markets))].sort();\n\n // Unique lead times (sorted numerically)\n const leadTimes = [\n ...new Set(items.map((i) => i.leadTime).filter((v) => v != null)),\n ].sort((a, b) => a - b);\n\n return respond(\n buildCatalogPage(\n items,\n categories,\n subCatMap,\n markets,\n leadTimes,\n proposalId,\n ),\n );\n } catch (err) {\n console.error(\"Catalog error:\", err);\n return respond(\n errorPage(\n \"Something went wrong\",\n \"Unable to load the equipment catalog. Please try again.\",\n ),\n 500,\n );\n }\n}\n\n// ── Catalog page builder ──────────────────────────────────────────────────────\n\nfunction buildCatalogPage(\n items,\n categories,\n subCatMap,\n markets,\n leadTimes,\n proposalId = null,\n) {\n const dataJson = JSON.stringify(items.map((item) => ({\n name: item.name,\n image: item.image || \"\",\n brand: item.brand || \"\",\n category: item.category || \"\",\n subCategory: item.subCategory || \"\",\n leadTime: item.leadTime,\n modelNum: item.modelNum || \"\",\n specSheet: item.specSheet || \"\",\n capacity: item.capacity || \"\",\n height: item.height,\n width: item.width,\n depth: item.depth,\n waterline: item.waterline || \"\",\n floorDrain: item.floorDrain || \"\",\n voltage: item.voltage || \"\",\n hertz: item.hertz || \"\",\n amps: item.amps || \"\",\n plug: item.plug || \"\",\n countertopHole: item.countertopHole || \"\",\n countertopHoleSize: item.countertopHoleSize || \"\",\n leftRight: item.leftRight || \"\",\n frontBack: item.frontBack || \"\",\n topBottom: item.topBottom || \"\",\n headcount: item.headcount || \"\",\n addons: item.addons || \"\",\n optionalAddons: item.optionalAddons || \"\",\n markets: item.markets || [],\n })));\n\n const mkCheckbox = (filterName, val, label) =>\n `${\n escHtml(label)\n }`;\n\n const categoryCheckboxes = categories.map((c) => mkCheckbox(\"category\", c, c))\n .join(\"\");\n const allSubCats = [\n ...new Set(items.map((i) => i.subCategory).filter(Boolean)),\n ].sort();\n const subCatCheckboxes = allSubCats.map((s) =>\n mkCheckbox(\"subcategory\", s, s)\n ).join(\"\");\n const marketCheckboxes = markets.map((m) => mkCheckbox(\"market\", m, m)).join(\n \"\",\n );\n const leadTimeCheckboxes = leadTimes.map((lt) =>\n mkCheckbox(\"leadtime\", lt, lt + \" weeks\")\n ).join(\"\");\n\n const subCatMapJson = JSON.stringify(\n Object.fromEntries(\n Object.entries(subCatMap).map(([k, v]) => [k, [...v].sort()]),\n ),\n );\n\n return `\n\n\n \n \n Equipment Catalog — Crafty Delivers\n \n \n\n\n\n\n\n

Equipment Catalog

Full Equipment Catalog

Browse all ${items.length} pieces of equipment Crafty offers

\n\n

\n \n\n

\n All Categories▾\n

${categoryCheckboxes}

\n\n ${\n subCatCheckboxes\n ? `

\n All Sub-categories▾\n

${subCatCheckboxes}

`\n : \"\"\n }\n\n ${\n marketCheckboxes\n ? `

\n All Markets▾\n

${marketCheckboxes}

`\n : \"\"\n }\n\n ${\n leadTimeCheckboxes\n ? `

\n Any Lead Time▾\n

${leadTimeCheckboxes}

`\n : \"\"\n }\n\n \n ${items.length} items\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

	Equipment	Brand	Category	Sub-category	Model #	Required Add-ons	Lead Time (wks)	W (in)	D (in)	H (in)	Left/Right Clearance	Front/Back Clearance	Top/Bottom Clearance	Countertop Hole(s)	Hole Size (in)	Waterline	Floor Drain	Capacity	Headcount	Spec Sheet

\n\n\n\n\n\n\n`;\n}","createdAt",["D",1784253365600],"branchVersion","branchId","d9173fb0-7cee-4312-b7ab-6676aed6f528","id","b8ed6460-d6c5-4677-bcf5-9d4137c9fe16","crafty-proposal",["D",1784151566055],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","acc7a2fa-d279-4cb2-94dd-8dc8de63cc82","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f677f-d538-71c9-ad61-bdad765ff408","tursoName","b8ed6460d6c54677bcf59d4137c9fe16","tursoHostname","b8ed6460d6c54677bcf59d4137c9fe16-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789576313835],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",106,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","beckyreese","handle","displayName","Becky Reese","avatar","https://lh3.googleusercontent.com/a/ACg8ocJOWdjVnWSdE70h6X4aaagH9YLjFFcolj3y9awn9ckxsQkTFk8=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":155,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":156,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":157,"_83":158,"_85":159,"_87":25},"tree",[150],"files",[150],"counts",{"_138":62,"_139":140,"_141":62,"_142":143,"_144":145},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":136,"_27":137},"34005b7d-c41a-48b1-a2ed-ae6ad082befc","parentId","latest",["D",1784253365600],41,"label","craftydelivers",[28],"pulls","branches",1,"forks","envVars",{"_146":148,"_149":62},"connections",{"_146":62,"_147":62},"count","unfilledCount",2,"emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":151,"_13":134,"_33":34,"_35":37,"_24":25,"_135":136,"_152":153,"_27":154},["D",1784253365600],"children",[],[28],["D",1784151566055],["D",1789576313835],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":193,"_194":195,"_196":197,"_198":25,"_199":25,"_200":25,"_201":58,"_202":-5,"_203":-7,"_204":-7,"_205":62,"_206":25,"_207":25,"_208":-5,"_209":25,"_210":25,"_211":25,"_212":-5},"ENV",{"_164":165,"_166":167,"_168":89,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v42