[{"_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",95,"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\";\nconst CATALOG_DB_ID = \"6e3b26affcb0499fb6570fd3f1acc9df\";\n\n// ── Notion API helpers ────────────────────────────────────────────────────────\n\nasync function notionFetch(path: string, body: any = 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\nfunction getTitle(prop: any) {\n return prop?.title?.map((t: any) => t.plain_text).join(\"\") || null;\n}\n\nfunction getRichText(prop: any) {\n if (!prop) return null;\n if (prop.type === \"rich_text\") {\n return prop.rich_text?.map((t: any) => t.plain_text).join(\"\") || null;\n }\n if (prop.type === \"multi_select\") {\n return prop.multi_select?.map((s: any) => s.name).join(\", \") || null;\n }\n if (prop.type === \"select\") return prop.select?.name || null;\n return null;\n}\n\nfunction getNumber(prop: any) {\n return prop?.number ?? null;\n}\n\n// Universal Regex URL Extractor — pulls raw http(s) links out of any Notion JSON response\nfunction extractUrlFromAnyNotionStructure(data: any): string | null {\n if (!data) return null;\n const jsonStr = typeof data === \"string\" ? data : JSON.stringify(data);\n const match = jsonStr.match(/https?:\\/\\/[^\\s\"'\\\\]+/i);\n if (!match) return null;\n return match[0].replace(/\\\\/g, \"\");\n}\n\nfunction getFileUrl(prop: any) {\n return extractUrlFromAnyNotionStructure(prop);\n}\n\n// Case & Whitespace Insensitive Property Matcher\nfunction tryProp(properties: any, ...names: string[]) {\n if (!properties) return null;\n const keys = Object.keys(properties);\n\n for (const name of names) {\n const target = name.trim().toLowerCase();\n const match = keys.find((k) => k.trim().toLowerCase() === target);\n if (match) return properties[match];\n }\n\n for (const name of names) {\n const target = name.trim().toLowerCase();\n const match = keys.find((k) => k.toLowerCase().includes(target));\n if (match) return properties[match];\n }\n\n return null;\n}\n\nfunction getSpecSheetUrl(properties: any): string | null {\n if (!properties) return null;\n\n const directProp = tryProp(\n properties,\n \"Spec Sheet PDF\",\n \"Spec Sheet\",\n \"Spec Sheet (PDF)\",\n \"Equipment Spec Sheet\",\n \"🚫 Equipment Specs (pdf)\",\n \"Equipment Specs (pdf)\",\n \"PDF\",\n );\n if (directProp) {\n const url = extractUrlFromAnyNotionStructure(directProp);\n if (url) return url;\n }\n\n for (const key of Object.keys(properties)) {\n const lower = key.toLowerCase();\n if (lower.includes(\"spec\") || lower.includes(\"pdf\")) {\n const url = extractUrlFromAnyNotionStructure(properties[key]);\n if (url) return url;\n }\n }\n\n return null;\n}\n\n// Multi-tier Rollup & Relation Resolver for Spec Sheets\nasync function fetchSpecSheetUrl(page: any): Promise {\n const p = page.properties;\n\n // 1. Direct check on page object\n let url = getSpecSheetUrl(p);\n if (url) return url;\n\n // 2. Fetch via Notion's Page Property Endpoint (required by Notion API for Rollups)\n const specProp = tryProp(\n p,\n \"Spec Sheet PDF\",\n \"Spec Sheet\",\n \"Spec Sheet (PDF)\",\n \"Equipment Spec Sheet\",\n );\n if (specProp?.id) {\n try {\n const propData = await notionFetch(\n `/pages/${page.id}/properties/${specProp.id}`,\n );\n url = extractUrlFromAnyNotionStructure(propData);\n if (url) return url;\n } catch (e) {\n console.error(\"Rollup property endpoint fetch failed:\", e);\n }\n }\n\n // 3. Fallback: Follow the \"Spec Sheet Source\" relation directly to the source page\n const relProp = tryProp(p, \"Spec Sheet Source\", \"Spec Sheet\", \"Source\");\n const relId = relProp?.relation?.[0]?.id;\n if (relId) {\n try {\n const sourcePage = await notionFetch(`/pages/${relId}`);\n url = extractUrlFromAnyNotionStructure(sourcePage.properties);\n if (url) return url;\n } catch (e) {\n console.error(\"Relation source page fetch failed:\", e);\n }\n }\n\n return null;\n}\n\nfunction getField(prop: any) {\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: any) => s.name).join(\", \") || null;\n case \"rich_text\":\n return prop.rich_text?.map((t: any) => t.plain_text).join(\"\") || null;\n case \"title\":\n return prop.title?.map((t: any) => 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 case \"url\":\n return prop.url || null;\n default:\n return null;\n }\n}\n\nfunction escHtml(str: any) {\n if (str == null) return \"\";\n return String(str)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\nfunction formatMoney(val: string | null) {\n if (!val) return null;\n if (val.trim().startsWith(\"$\")) return val;\n const num = Number(val.replace(/[^0-9.-]+/g, \"\"));\n if (isNaN(num)) return val;\n return \"$\" + num.toLocaleString(\"en-US\");\n}\n\nfunction formatClearance(val: string | null) {\n if (!val) return null;\n const trimmed = val.trim();\n if (!trimmed) return null;\n if (trimmed.endsWith('\"')) return trimmed;\n if (!isNaN(Number(trimmed))) return `${trimmed}\"`;\n return trimmed;\n}\n\nfunction getDimVal(properties: any, ...names: string[]) {\n const prop = tryProp(properties, ...names);\n if (!prop) return null;\n if (prop.number != null) return String(prop.number);\n const str = getField(prop);\n if (!str) return null;\n const cleaned = str.replace(/[\"”]/g, \"\").trim();\n return cleaned || null;\n}\n\n// ── Main handler ──────────────────────────────────────────────────────────────\n\nexport default async function handler(req: Request) {\n const url = new URL(req.url);\n\n if (url.pathname === \"/catalog\" || url.pathname === \"/catalog/\") {\n return handleCatalog(url.searchParams.get(\"proposal_id\") || null);\n }\n\n const withPricing = url.pathname === \"/pricing\" ||\n url.pathname === \"/pricing/\";\n\n const proposalIdRaw = url.searchParams.get(\"proposal_id\");\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 ──────────────────────────────────────────────────────────\n\nasync function handleProposal(proposalId: number, withPricing = false) {\n try {\n let dbId = Deno.env.get(\"PROPOSALS_DB_ID\");\n let queryResult: any;\n\n try {\n queryResult = await notionFetch(`/databases/${dbId}/query`, {});\n } catch (firstErr: any) {\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: any) =>\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 const proposal = queryResult.results?.find((page: any) => {\n const idProp = page.properties[\"Proposal ID\"];\n return idProp?.unique_id?.number === 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 const clientNameKey = Object.keys(pProps).find((k) =>\n k.toLowerCase().includes(\"client facing\")\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 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 const equipmentRelKey = Object.keys(pProps).find((k) => {\n const prop = pProps[k];\n if (prop?.type !== \"relation\") {\n return false;\n }\n const lower = k.toLowerCase();\n return (\n lower.includes(\"recommended\") ||\n lower.includes(\"equipment\") ||\n lower.includes(\"master output\")\n );\n });\n\n const equipmentIds = equipmentRelKey && pProps[equipmentRelKey]?.relation\n ? pProps[equipmentRelKey].relation.map((r: any) => r.id)\n : [];\n\n if (!equipmentIds.length) {\n return respond(\n buildPage(\n clientName,\n [],\n salesExecName,\n salesExecEmail,\n proposalId,\n withPricing,\n ),\n );\n }\n\n const equipmentPages = await Promise.all(\n equipmentIds.map((id: string) => notionFetch(`/pages/${id}`)),\n );\n\n const equipment = await Promise.all(\n equipmentPages.map(async (page: any) => {\n const p = page.properties;\n\n const nameRaw = 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 const image = getFileUrl(\n tryProp(\n p,\n \"Equipment Image\",\n \"🚫 Equipment Image\",\n \"Image\",\n \"Images\",\n \"Photo\",\n ),\n );\n\n const specSheet = await fetchSpecSheetUrl(page);\n\n const leadTime = getNumber(\n tryProp(p, \"Lead Time (weeks)\", \"Lead Time (Weeks)\"),\n );\n\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 const optionalAddons = getRichText(\n tryProp(\n p,\n \"Optional Add-ons\",\n \"Optional Add-Ons\",\n \"Optional add-ons\",\n ),\n );\n\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 const width = getDimVal(\n p,\n \"Width (in)\",\n \"W (in)\",\n \"Width\",\n \"W\",\n \"🚫 Width (in)\",\n );\n const depth = getDimVal(\n p,\n \"Depth (in)\",\n \"D (in)\",\n \"Depth\",\n \"D\",\n \"🚫 Depth (in)\",\n );\n const height = getDimVal(\n p,\n \"Height (in)\",\n \"H (in)\",\n \"Height\",\n \"H\",\n \"🚫 Height (in)\",\n );\n\n const leftRightClearance = formatClearance(\n getField(\n tryProp(\n p,\n \"L/R Clearance\",\n \"L/R clearance\",\n \"Left/Right Clearance\",\n \"🚫 Left/Right Clearance\",\n \"L/R\",\n ),\n ),\n );\n const frontBackClearance = formatClearance(\n getField(\n tryProp(\n p,\n \"F/B Clearance\",\n \"F/B clearance\",\n \"Front/Back Clearance\",\n \"🚫 Front/Back Clearance\",\n \"F/B\",\n ),\n ),\n );\n const topBottomClearance = formatClearance(\n getField(\n tryProp(\n p,\n \"T/B Clearance\",\n \"T/B clearance\",\n \"Top/Bottom Clearance\",\n \"🚫 Top/Bottom Clearance\",\n \"T/B\",\n ),\n ),\n );\n\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 const waterline = getField(tryProp(p, \"Waterline\", \"🚫 Waterline\"));\n const floorDrain = getField(\n tryProp(p, \"Floor Drain\", \"🚫 Floor Drain\"),\n );\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(\n p,\n \"Countertop Hole Size (in)\",\n \"🚫 Countertop Hole Size (in)\",\n ),\n );\n\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 const name = nameRaw ||\n (modelNum ? `Model ${modelNum}` : \"Unnamed Item\");\n\n const rental1yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"1-YR Rental Rate to Client\",\n \"1-Yr Rental\",\n \"1-YR Rental\",\n \"1-Year Rental\",\n \"1 Yr Rental\",\n \"1 YR Rental\",\n ),\n ),\n )\n : null;\n const rental2yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"2-YR Rental Rate to Client\",\n \"2-YR Rental\",\n \"2-Yr Rental\",\n \"2-Year Rental\",\n \"2 Yr Rental\",\n \"2 YR Rental\",\n ),\n ),\n )\n : null;\n const rental3yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"3-YR Rental Rate to Client\",\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 )\n : null;\n const spend1yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"1-YR Program Inclusive Rate to Client\",\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 )\n : null;\n const spend2yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"2-YR Program Inclusive Rate to Client\",\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 )\n : null;\n const spend3yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"3-YR Program Inclusive Rate to Client\",\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 )\n : null;\n\n return {\n name,\n image,\n specSheet,\n leadTime,\n necessaryAddons,\n optionalAddons,\n brand: brand ? brand.trim() : null,\n category: category ? category.trim() : null,\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\n return respond(\n buildPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n withPricing,\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: string, status = 200) {\n return new Response(html, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction errorPage(title: string, message: string) {\n return `\n\n\n \n \n Crafty Delivers\n \n\n\n

${escHtml(title)}

${escHtml(message)}

\n\n`;\n}\n\n// ── Page builders ─────────────────────────────────────────────────────────────\n\nfunction buildPricingPage(\n clientName: string,\n equipment: any[],\n salesExecName: string | null,\n salesExecEmail: string | null,\n proposalId: number,\n) {\n return buildPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n true,\n );\n}\n\nfunction buildPage(\n clientName: string,\n equipment: any[],\n salesExecName: string | null,\n salesExecEmail: string | null,\n proposalId: number,\n withPricing = false,\n) {\n const displayEmail = salesExecEmail || \"hello@craftydelivers.com\";\n const preparedBy = salesExecName\n ? \"Prepared by \" + escHtml(salesExecName) + \" · \"\n : \"\";\n\n const equipmentJson = JSON.stringify(equipment);\n\n const categories = [\n ...new Set(\n equipment\n .map((i) => (i.category ? String(i.category).trim() : null))\n .filter((c) => c && c.length > 0),\n ),\n ].sort();\n\n const categoryCheckboxes = categories\n .map(\n (c) =>\n '' +\n escHtml(c) +\n \"\",\n )\n .join(\"\");\n\n const brands = [\n ...new Set(\n equipment\n .map((i) => (i.brand ? String(i.brand).trim() : null))\n .filter((b) => b && b.length > 0),\n ),\n ].sort();\n\n const brandCheckboxes = brands\n .map(\n (b) =>\n '' +\n escHtml(b) +\n \"\",\n )\n .join(\"\");\n\n const categoryHtml = categoryCheckboxes\n ? '

All Categories▾

' +\n categoryCheckboxes + \"

\"\n : \"\";\n\n const brandHtml = brandCheckboxes\n ? '

All Brands▾

' +\n brandCheckboxes + \"

\"\n : \"\";\n\n const pricingHeaders = withPricing\n ? \"1-Yr Rental2-Yr Rental3-Yr Rental1-Yr Spend Min2-Yr Spend Min3-Yr Spend Min\"\n : \"\";\n\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\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 ${pricingHeaders}\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

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: number | string | null = null) {\n try {\n const allPages: any[] = [];\n let cursor: string | null = null;\n do {\n const body: any = 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 const items = await Promise.all(\n allPages.map(async (page: any) => {\n const p = page.properties;\n const specSheet = await fetchSpecSheetUrl(page);\n return {\n name: getTitle(tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\")) ||\n \"Unnamed\",\n image: getFileUrl(\n tryProp(p, \"Equipment Image\", \"🚫 Equipment Image\"),\n ),\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,\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:\n 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: any) => s.name) || [];\n }\n if (prop.type === \"select\") {\n return prop.select?.name ? [prop.select.name] : [];\n }\n return [];\n })(),\n };\n }),\n );\n\n const validItems = items.filter((i) => i.name !== \"Unnamed\");\n\n const categories = [\n ...new Set(validItems.map((i) => i.category).filter(Boolean)),\n ].sort();\n const subCatMap: any = {};\n for (const item of validItems) {\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 const markets = [...new Set(validItems.flatMap((i) => i.markets))].sort();\n\n const leadTimes = [\n ...new Set(validItems.map((i) => i.leadTime).filter((v) => v != null)),\n ].sort((a: number, b: number) => a - b);\n\n return respond(\n buildCatalogPage(\n validItems,\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: any[],\n categories: string[],\n subCatMap: any,\n markets: string[],\n leadTimes: number[],\n proposalId: number | string | null = 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: string, val: any, label: string) =>\n '' + escHtml(label) + \"\";\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((\n [k, v]: [string, any],\n ) => [k, [...v].sort()]),\n ),\n );\n\n const backLinkHtml = proposalId\n ? '← Back to my proposal'\n : \"\";\n\n const subCatDropdownHtml = subCatCheckboxes\n ? '

All Sub-categories▾

' +\n subCatCheckboxes + \"

\"\n : \"\";\n\n const marketDropdownHtml = marketCheckboxes\n ? '

All Markets▾

' +\n marketCheckboxes + \"

\"\n : \"\";\n\n const leadTimeDropdownHtml = leadTimeCheckboxes\n ? '

Any Lead Time▾

' +\n leadTimeCheckboxes + \"

\"\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 equipment Crafty offers

\n\n

\n \n\n

\n All Categories▾\n

${categoryCheckboxes}

\n\n ${subCatDropdownHtml}\n ${marketDropdownHtml}\n ${leadTimeDropdownHtml}\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 \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\";\nconst CATALOG_DB_ID = \"6e3b26affcb0499fb6570fd3f1acc9df\";\n\n// ── Notion API helpers ────────────────────────────────────────────────────────\n\nasync function notionFetch(path: string, body: any = 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\nfunction getTitle(prop: any) {\n return prop?.title?.map((t: any) => t.plain_text).join(\"\") || null;\n}\n\nfunction getRichText(prop: any) {\n if (!prop) return null;\n if (prop.type === \"rich_text\") {\n return prop.rich_text?.map((t: any) => t.plain_text).join(\"\") || null;\n }\n if (prop.type === \"multi_select\") {\n return prop.multi_select?.map((s: any) => s.name).join(\", \") || null;\n }\n if (prop.type === \"select\") return prop.select?.name || null;\n return null;\n}\n\nfunction getNumber(prop: any) {\n return prop?.number ?? null;\n}\n\n// Universal Regex URL Extractor — pulls raw http(s) links out of any Notion JSON response\nfunction extractUrlFromAnyNotionStructure(data: any): string | null {\n if (!data) return null;\n const jsonStr = typeof data === \"string\" ? data : JSON.stringify(data);\n const match = jsonStr.match(/https?:\\/\\/[^\\s\"'\\\\]+/i);\n if (!match) return null;\n return match[0].replace(/\\\\/g, \"\");\n}\n\nfunction getFileUrl(prop: any) {\n return extractUrlFromAnyNotionStructure(prop);\n}\n\n// Case & Whitespace Insensitive Property Matcher\nfunction tryProp(properties: any, ...names: string[]) {\n if (!properties) return null;\n const keys = Object.keys(properties);\n\n for (const name of names) {\n const target = name.trim().toLowerCase();\n const match = keys.find((k) => k.trim().toLowerCase() === target);\n if (match) return properties[match];\n }\n\n for (const name of names) {\n const target = name.trim().toLowerCase();\n const match = keys.find((k) => k.toLowerCase().includes(target));\n if (match) return properties[match];\n }\n\n return null;\n}\n\nfunction getSpecSheetUrl(properties: any): string | null {\n if (!properties) return null;\n\n const directProp = tryProp(\n properties,\n \"Spec Sheet PDF\",\n \"Spec Sheet\",\n \"Spec Sheet (PDF)\",\n \"Equipment Spec Sheet\",\n \"🚫 Equipment Specs (pdf)\",\n \"Equipment Specs (pdf)\",\n \"PDF\",\n );\n if (directProp) {\n const url = extractUrlFromAnyNotionStructure(directProp);\n if (url) return url;\n }\n\n for (const key of Object.keys(properties)) {\n const lower = key.toLowerCase();\n if (lower.includes(\"spec\") || lower.includes(\"pdf\")) {\n const url = extractUrlFromAnyNotionStructure(properties[key]);\n if (url) return url;\n }\n }\n\n return null;\n}\n\n// Multi-tier Rollup & Relation Resolver for Spec Sheets\nasync function fetchSpecSheetUrl(page: any): Promise {\n const p = page.properties;\n\n // 1. Direct check on page object\n let url = getSpecSheetUrl(p);\n if (url) return url;\n\n // 2. Fetch via Notion's Page Property Endpoint (required by Notion API for Rollups)\n const specProp = tryProp(\n p,\n \"Spec Sheet PDF\",\n \"Spec Sheet\",\n \"Spec Sheet (PDF)\",\n \"Equipment Spec Sheet\",\n );\n if (specProp?.id) {\n try {\n const propData = await notionFetch(\n `/pages/${page.id}/properties/${specProp.id}`,\n );\n url = extractUrlFromAnyNotionStructure(propData);\n if (url) return url;\n } catch (e) {\n console.error(\"Rollup property endpoint fetch failed:\", e);\n }\n }\n\n // 3. Fallback: Follow the \"Spec Sheet Source\" relation directly to the source page\n const relProp = tryProp(p, \"Spec Sheet Source\", \"Spec Sheet\", \"Source\");\n const relId = relProp?.relation?.[0]?.id;\n if (relId) {\n try {\n const sourcePage = await notionFetch(`/pages/${relId}`);\n url = extractUrlFromAnyNotionStructure(sourcePage.properties);\n if (url) return url;\n } catch (e) {\n console.error(\"Relation source page fetch failed:\", e);\n }\n }\n\n return null;\n}\n\nfunction getField(prop: any) {\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: any) => s.name).join(\", \") || null;\n case \"rich_text\":\n return prop.rich_text?.map((t: any) => t.plain_text).join(\"\") || null;\n case \"title\":\n return prop.title?.map((t: any) => 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 case \"url\":\n return prop.url || null;\n default:\n return null;\n }\n}\n\nfunction escHtml(str: any) {\n if (str == null) return \"\";\n return String(str)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\nfunction formatMoney(val: string | null) {\n if (!val) return null;\n if (val.trim().startsWith(\"$\")) return val;\n const num = Number(val.replace(/[^0-9.-]+/g, \"\"));\n if (isNaN(num)) return val;\n return \"$\" + num.toLocaleString(\"en-US\");\n}\n\nfunction formatClearance(val: string | null) {\n if (!val) return null;\n const trimmed = val.trim();\n if (!trimmed) return null;\n if (trimmed.endsWith('\"')) return trimmed;\n if (!isNaN(Number(trimmed))) return `${trimmed}\"`;\n return trimmed;\n}\n\nfunction getDimVal(properties: any, ...names: string[]) {\n const prop = tryProp(properties, ...names);\n if (!prop) return null;\n if (prop.number != null) return String(prop.number);\n const str = getField(prop);\n if (!str) return null;\n const cleaned = str.replace(/[\"”]/g, \"\").trim();\n return cleaned || null;\n}\n\n// ── Main handler ──────────────────────────────────────────────────────────────\n\nexport default async function handler(req: Request) {\n const url = new URL(req.url);\n\n if (url.pathname === \"/catalog\" || url.pathname === \"/catalog/\") {\n return handleCatalog(url.searchParams.get(\"proposal_id\") || null);\n }\n\n const withPricing = url.pathname === \"/pricing\" ||\n url.pathname === \"/pricing/\";\n\n const proposalIdRaw = url.searchParams.get(\"proposal_id\");\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 ──────────────────────────────────────────────────────────\n\nasync function handleProposal(proposalId: number, withPricing = false) {\n try {\n let dbId = Deno.env.get(\"PROPOSALS_DB_ID\");\n let queryResult: any;\n\n try {\n queryResult = await notionFetch(`/databases/${dbId}/query`, {});\n } catch (firstErr: any) {\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: any) =>\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 const proposal = queryResult.results?.find((page: any) => {\n const idProp = page.properties[\"Proposal ID\"];\n return idProp?.unique_id?.number === 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 const clientNameKey = Object.keys(pProps).find((k) =>\n k.toLowerCase().includes(\"client facing\")\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 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 const equipmentRelKey = Object.keys(pProps).find((k) => {\n const prop = pProps[k];\n if (prop?.type !== \"relation\") {\n return false;\n }\n const lower = k.toLowerCase();\n return (\n lower.includes(\"recommended\") ||\n lower.includes(\"equipment\") ||\n lower.includes(\"master output\")\n );\n });\n\n const equipmentIds = equipmentRelKey && pProps[equipmentRelKey]?.relation\n ? pProps[equipmentRelKey].relation.map((r: any) => r.id)\n : [];\n\n if (!equipmentIds.length) {\n return respond(\n buildPage(\n clientName,\n [],\n salesExecName,\n salesExecEmail,\n proposalId,\n withPricing,\n ),\n );\n }\n\n const equipmentPages = await Promise.all(\n equipmentIds.map((id: string) => notionFetch(`/pages/${id}`)),\n );\n\n const equipment = await Promise.all(\n equipmentPages.map(async (page: any) => {\n const p = page.properties;\n\n const nameRaw = 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 const image = getFileUrl(\n tryProp(\n p,\n \"Equipment Image\",\n \"🚫 Equipment Image\",\n \"Image\",\n \"Images\",\n \"Photo\",\n ),\n );\n\n const specSheet = await fetchSpecSheetUrl(page);\n\n const leadTime = getNumber(\n tryProp(p, \"Lead Time (weeks)\", \"Lead Time (Weeks)\"),\n );\n\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 const optionalAddons = getRichText(\n tryProp(\n p,\n \"Optional Add-ons\",\n \"Optional Add-Ons\",\n \"Optional add-ons\",\n ),\n );\n\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 const width = getDimVal(\n p,\n \"Width (in)\",\n \"W (in)\",\n \"Width\",\n \"W\",\n \"🚫 Width (in)\",\n );\n const depth = getDimVal(\n p,\n \"Depth (in)\",\n \"D (in)\",\n \"Depth\",\n \"D\",\n \"🚫 Depth (in)\",\n );\n const height = getDimVal(\n p,\n \"Height (in)\",\n \"H (in)\",\n \"Height\",\n \"H\",\n \"🚫 Height (in)\",\n );\n\n const leftRightClearance = formatClearance(\n getField(\n tryProp(\n p,\n \"L/R Clearance\",\n \"L/R clearance\",\n \"Left/Right Clearance\",\n \"🚫 Left/Right Clearance\",\n \"L/R\",\n ),\n ),\n );\n const frontBackClearance = formatClearance(\n getField(\n tryProp(\n p,\n \"F/B Clearance\",\n \"F/B clearance\",\n \"Front/Back Clearance\",\n \"🚫 Front/Back Clearance\",\n \"F/B\",\n ),\n ),\n );\n const topBottomClearance = formatClearance(\n getField(\n tryProp(\n p,\n \"T/B Clearance\",\n \"T/B clearance\",\n \"Top/Bottom Clearance\",\n \"🚫 Top/Bottom Clearance\",\n \"T/B\",\n ),\n ),\n );\n\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 const waterline = getField(tryProp(p, \"Waterline\", \"🚫 Waterline\"));\n const floorDrain = getField(\n tryProp(p, \"Floor Drain\", \"🚫 Floor Drain\"),\n );\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(\n p,\n \"Countertop Hole Size (in)\",\n \"🚫 Countertop Hole Size (in)\",\n ),\n );\n\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 const name = nameRaw ||\n (modelNum ? `Model ${modelNum}` : \"Unnamed Item\");\n\n const rental1yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"1-YR Rental Rate to Client\",\n \"1-Yr Rental\",\n \"1-YR Rental\",\n \"1-Year Rental\",\n \"1 Yr Rental\",\n \"1 YR Rental\",\n ),\n ),\n )\n : null;\n const rental2yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"2-YR Rental Rate to Client\",\n \"2-YR Rental\",\n \"2-Yr Rental\",\n \"2-Year Rental\",\n \"2 Yr Rental\",\n \"2 YR Rental\",\n ),\n ),\n )\n : null;\n const rental3yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"3-YR Rental Rate to Client\",\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 )\n : null;\n const spend1yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"1-YR Program Inclusive Rate to Client\",\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 )\n : null;\n const spend2yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"2-YR Program Inclusive Rate to Client\",\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 )\n : null;\n const spend3yr = withPricing\n ? formatMoney(\n getField(\n tryProp(\n p,\n \"3-YR Program Inclusive Rate to Client\",\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 )\n : null;\n\n return {\n name,\n image,\n specSheet,\n leadTime,\n necessaryAddons,\n optionalAddons,\n brand: brand ? brand.trim() : null,\n category: category ? category.trim() : null,\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\n return respond(\n buildPage(\n clientName,\n equipment,\n salesExecName,\n salesExecEmail,\n proposalId,\n withPricing,\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: string, status = 200) {\n return new Response(html, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction errorPage(title: string, message: string) {\n return `\n\n\n \n \n Crafty Delivers\n \n\n\n

${escHtml(title)}

${escHtml(message)}

All Categories▾

' +\n categoryCheckboxes + \"

\"\n : \"\";\n\n const brandHtml = brandCheckboxes\n ? '

All Brands▾

' +\n brandCheckboxes + \"

${escHtml(clientName)}

Your recommended equipment, curated by the Crafty team

\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 ${pricingHeaders}\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

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: number | string | null = null) {\n try {\n const allPages: any[] = [];\n let cursor: string | null = null;\n do {\n const body: any = 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 const items = await Promise.all(\n allPages.map(async (page: any) => {\n const p = page.properties;\n const specSheet = await fetchSpecSheetUrl(page);\n return {\n name: getTitle(tryProp(p, \"Master Name\", \"Name\", \"Equipment Name\")) ||\n \"Unnamed\",\n image: getFileUrl(\n tryProp(p, \"Equipment Image\", \"🚫 Equipment Image\"),\n ),\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,\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:\n 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: any) => s.name) || [];\n }\n if (prop.type === \"select\") {\n return prop.select?.name ? [prop.select.name] : [];\n }\n return [];\n })(),\n };\n }),\n );\n\n const validItems = items.filter((i) => i.name !== \"Unnamed\");\n\n const categories = [\n ...new Set(validItems.map((i) => i.category).filter(Boolean)),\n ].sort();\n const subCatMap: any = {};\n for (const item of validItems) {\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 const markets = [...new Set(validItems.flatMap((i) => i.markets))].sort();\n\n const leadTimes = [\n ...new Set(validItems.map((i) => i.leadTime).filter((v) => v != null)),\n ].sort((a: number, b: number) => a - b);\n\n return respond(\n buildCatalogPage(\n validItems,\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: any[],\n categories: string[],\n subCatMap: any,\n markets: string[],\n leadTimes: number[],\n proposalId: number | string | null = 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: string, val: any, label: string) =>\n '' + escHtml(label) + \"\";\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((\n [k, v]: [string, any],\n ) => [k, [...v].sort()]),\n ),\n );\n\n const backLinkHtml = \"\";\n\n const subCatDropdownHtml = subCatCheckboxes\n ? '

All Sub-categories▾

' +\n subCatCheckboxes + \"

\"\n : \"\";\n\n const marketDropdownHtml = marketCheckboxes\n ? '

All Markets▾

' +\n marketCheckboxes + \"

\"\n : \"\";\n\n const leadTimeDropdownHtml = leadTimeCheckboxes\n ? '

Any Lead Time▾

' +\n leadTimeCheckboxes + \"

\"\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 equipment Crafty offers

\n\n

\n \n\n

\n All Categories▾\n

${categoryCheckboxes}

\n\n ${subCatDropdownHtml}\n ${marketDropdownHtml}\n ${leadTimeDropdownHtml}\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 \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",1789411951332],"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",1789489305251],"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",103,"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},"d5b92977-5bc8-402b-bfb7-c16bd865ca34","parentId","latest",["D",1789411951332],94,"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",1789411951332],"children",[],[28],["D",1784151566055],["D",1789489305251],{"_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","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v95