Gulf Coast Woodworks

\n Tree removal • Trimming • Stump grinding — Crestview, Florida & the\n Gulf Coast\n

\n\n

Instant Estimate

\n How many trees?\n \n \n Tree height (ft)\n \n \n Trunk diameter (in)\n \n \n Complexity\n \n \n \n \n \n \n \n Stump grinding\n \n \n Brush & log haul-away\n \n \n

Rough estimate

\n \n Recalculate\n \n

\n \n \n\n

Request a Quote / Schedule

\n \n Name\n \n \n Phone\n \n \n Email\n \n \n Street Address\n \n \n City\n \n \n ZIP\n \n \n\n

\n Trees\n \n \n Height (ft)\n \n \n Diameter (in)\n \n \n Complexity\n \n \n \n \n \n \n

\n Stump grinding\n

\n Haul-away\n

\n\n Notes\n \n \n\n \n Send Inquiry\n \n

\n \n

\n\n

\n Serving Crestview, Baker, Niceville, Fort Walton Beach, and\n surrounding Gulf Coast communities.\n

\n Estimates shown are rough ballparks. Final price depends on on-site\n assessment, access, utilities, and permitting.\n

\n\n \n\n \n \n \n `;\n\nconst adminPage = (rows: any[]) =>\n html`\n \n \n \n \n \n Admin — Gulf Coast Woodworks\n \n \n \n

Inquiries (${rows.length})

\n Export CSV\n

\n \n \n \n ${[\n \"created_at\",\n \"name\",\n \"phone\",\n \"email\",\n \"city\",\n \"service\",\n \"tree_count\",\n \"height\",\n \"diameter\",\n \"complexity\",\n \"stump\",\n \"haul\",\n \"estimate\",\n \"notes\",\n ].map((h) =>\n ``\n ).join(\"\")}\n \n \n \n ${rows.map((r) =>\n `\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n `\n ).join(\"\")}\n \n

${h}
${escapeHtml(r.created_at)}	${escapeHtml(r.name)}	${escapeHtml(r.phone)}	${escapeHtml(r.email)}	${escapeHtml(r.city)}	${escapeHtml(r.service)}	${r.tree_count}	${r.tree_height_ft} ft	${r.trunk_diameter_in} in	${escapeHtml(r.complexity)}	${r.stump_grinding ? \"✓\" : \"\"}	${r.haul_away ? \"✓\" : \"\"}	$${\n Number(r.estimate_usd \|\| 0).toLocaleString()\n }	${escapeHtml(r.notes)}

\n Basic Auth: use your ADMIN_PASSWORD (username blank). Keep this URL\n private.\n

\n \n \n `;\n\nfunction escapeHtml(s: any) {\n return String(s ?? \"\").replaceAll(\"&\", \"&\").replaceAll(\"<\", \"<\")\n .replaceAll(\">\", \">\").replaceAll('\"', \""\");\n}\n\n// ✅ Correct Val Town export\nexport default async function handler(req: Request): Promise {\n return app.fetch(req);\n}",[],[175],{"_105":183,"_96":184,"_156":185,"_158":-5,"_159":142,"_160":186,"_162":22,"_107":187,"_101":188,"_165":166,"_167":179,"_168":22,"_169":-5,"_170":189,"_99":190},"ff49f9fc-81e2-11f0-9168-0224a6c84d84","main.tsx","b2dbf5c4-81b6-11f0-ad2b-0224a6c84d84",9,["D",1756147239401],6,[],[184],{"_105":192,"_96":193,"_156":194,"_158":-5,"_159":142,"_160":195,"_162":22,"_107":196,"_101":32,"_165":197,"_167":73,"_168":22,"_169":-5,"_170":198,"_99":199},"75a5c220-8210-11f0-8654-0224a6c84d84","new-file-6879.tsx","75a5c2de-8210-11f0-8654-0224a6c84d84",16,["D",1756166765325],"script",[],[193],{"_105":201,"_96":202,"_156":203,"_158":-5,"_159":142,"_160":204,"_162":22,"_107":205,"_101":164,"_165":166,"_167":206,"_168":22,"_169":-5,"_170":207,"_99":208},"9f92f7ec-8210-11f0-8bf6-0224a6c84d84","new-file-8759.tsx","7834c22a-8210-11f0-94ae-0224a6c84d84",19,["D",1756166835663],"// Gulf Coast Woodworks — Single-file val.run website & API\n// Version 2.0 - Refactored for improved UX, calculations, and admin functionality.\n//\n// Features:\n// - Public landing page with a unified, interactive estimator and inquiry form.\n// - Inquiry form POSTs to backend and persists to Val Town SQLite.\n// - Admin table view (basic auth) to list, manage status of, and export submissions.\n//\n// Setup (in Val Town):\n// 1) Create an HTTP val with this file.\n// 2) Add an environment variable: ADMIN_PASSWORD = \n// 3) Run once to auto-create/update the SQLite table.\n// 4) Your public URL is this val's .web.val.run endpoint.\n// 5) Visit /admin with Basic Auth (username can be blank) and your ADMIN_PASSWORD.\n\nimport { Hono } from \"npm:hono@3\";\nimport { html } from \"npm:hono/html\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ---------- DB ----------\n// Added a 'status' column to track inquiry lifecycle.\nconst INIT_SQL = `\n CREATE TABLE IF NOT EXISTS inquiries (\n id TEXT PRIMARY KEY,\n created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now')),\n name TEXT,\n phone TEXT,\n email TEXT,\n address TEXT,\n city TEXT,\n zip TEXT,\n service TEXT,\n tree_count INTEGER,\n tree_height_ft INTEGER,\n trunk_diameter_in INTEGER,\n complexity TEXT,\n stump_grinding INTEGER,\n haul_away INTEGER,\n notes TEXT,\n estimate_usd INTEGER,\n ip TEXT,\n status TEXT NOT NULL DEFAULT 'new'\n );\n\n -- Add status column if it doesn't exist (for migration)\n PRAGMA user_version; -- This is a simple way to check schema version if needed.\n`;\n// A simple migration strategy: we'll add the column if it's missing.\nconst MIGRATION_SQL = `ALTER TABLE inquiries ADD COLUMN status TEXT NOT NULL DEFAULT 'new';`;\n\n\nlet initPromise: Promise | null = null;\nasync function ensureTables() {\n if (!initPromise) {\n initPromise = (async () => {\n await sqlite.execute(INIT_SQL);\n // Try to add the status column. This will fail safely if it already exists.\n try {\n await sqlite.execute(MIGRATION_SQL);\n console.log(\"Migration successful: 'status' column added.\");\n } catch (e) {\n if (!e.message.includes(\"duplicate column name\")) {\n console.error(\"Migration failed:\", e);\n }\n }\n })();\n }\n await initPromise;\n}\n\n\n// ---------- Pricing Engine (v2) ----------\nconst PRICING = {\n baseByHeight: [\n { max: 30, base: 300 },\n { max: 60, base: 650 },\n { max: 90, base: 1200 },\n { max: Infinity, base: 1800 },\n ],\n diameterAddPerInch: 15,\n diameterFreeInches: 8, // The first N inches of diameter don't add to the cost.\n complexityMultiplier: {\n easy: 1.0,\n medium: 1.35,\n hard: 1.75,\n },\n // Added a volume discount using a power function.\n // The cost per tree decreases as the number of trees increases.\n // n^0.95 applies a gentle discount for multi-tree jobs.\n volumeDiscountExponent: 0.95,\n stumpGrindingPerStump: 150,\n haulAwayFlat: 200,\n};\n\nfunction computeEstimateUSD(\n tree_count: number,\n tree_height_ft: number,\n trunk_diameter_in: number,\n complexity: \"easy\" | \"medium\" | \"hard\",\n stump_grinding: boolean,\n haul_away: boolean,\n): number {\n const baseBand = PRICING.baseByHeight.find((b) => tree_height_ft <= b.max)!;\n\n let perTreeCost = baseBand.base +\n PRICING.diameterAddPerInch * Math.max(0, trunk_diameter_in - PRICING.diameterFreeInches);\n\n perTreeCost *= PRICING.complexityMultiplier[complexity];\n\n // Apply volume discount to the tree removal portion of the cost.\n const numTrees = Math.max(1, tree_count);\n let total = (perTreeCost * numTrees) * Math.pow(numTrees, PRICING.volumeDiscountExponent - 1);\n\n if (stump_grinding) {\n total += PRICING.stumpGrindingPerStump * numTrees;\n }\n if (haul_away) {\n total += PRICING.haulAwayFlat;\n }\n\n // Round to nearest $5 for a cleaner estimate.\n return Math.round(total / 5) * 5;\n}\n\n// ---------- Auth ----------\nconst ADMIN_PASSWORD = Deno.env.get(\"ADMIN_PASSWORD\") ?? \"\";\n\nfunction requireAdmin(c: any) {\n if (ADMIN_PASSWORD === \"\") {\n return c.text(\"ADMIN_PASSWORD environment variable not set.\", 500);\n }\n const auth = c.req.header(\"authorization\");\n if (!auth || !auth.startsWith(\"Basic \")) {\n return c.text(\"Auth required\", 401, {\n \"WWW-Authenticate\": 'Basic realm=\"Gulf Coast Woodworks Admin\"',\n });\n }\n try {\n const [_, b64] = auth.split(\" \");\n const [user, pass] = atob(b64).split(\":\");\n if (pass === ADMIN_PASSWORD) return null; // authorized\n } catch (e) {\n // Malformed header\n }\n return c.text(\"Unauthorized\", 401, {\n \"WWW-Authenticate\": 'Basic realm=\"Gulf Coast Woodworks Admin\"',\n });\n}\n\n// ---------- App ----------\nconst app = new Hono();\n\n// Middleware for ensuring tables exist and adding basic security headers.\napp.use(\"*\", async (c, next) => {\n await ensureTables();\n c.header(\"X-Content-Type-Options\", \"nosniff\");\n c.header(\"X-Frame-Options\", \"DENY\");\n await next();\n});\n\n// Home page\napp.get(\"/\", (c) => c.html(page()));\n\n// API: compute estimate (server-side)\napp.post(\"/api/estimate\", async (c) => {\n const body = await c.req.json();\n const data = sanitizeInquiry(body);\n const estimate = computeEstimateUSD(\n data.tree_count,\n data.tree_height_ft,\n data.trunk_diameter_in,\n data.complexity,\n Boolean(data.stump_grinding),\n Boolean(data.haul_away),\n );\n return c.json({ estimate_usd: estimate });\n});\n\n// API: save inquiry\napp.post(\"/api/inquiries\", async (c) => {\n const ip = c.req.header(\"x-forwarded-for\") || c.req.header(\"cf-connecting-ip\") || \"\";\n const body = await c.req.json();\n const data = sanitizeInquiry(body);\n const estimate = computeEstimateUSD(\n data.tree_count,\n data.tree_height_ft,\n data.trunk_diameter_in,\n data.complexity,\n Boolean(data.stump_grinding),\n Boolean(data.haul_away),\n );\n const id = crypto.randomUUID();\n await sqlite.execute({\n sql: `INSERT INTO inquiries (\n id, name, phone, email, address, city, zip, service, tree_count, tree_height_ft, trunk_diameter_in,\n complexity, stump_grinding, haul_away, notes, estimate_usd, ip, status\n ) VALUES (\n :id, :name, :phone, :email, :address, :city, :zip, :service, :tree_count, :tree_height_ft, :trunk_diameter_in,\n :complexity, :stump_grinding, :haul_away, :notes, :estimate_usd, :ip, 'new'\n )`,\n args: { id, ...data, estimate_usd: estimate, ip },\n });\n return c.json({ ok: true, id, estimate_usd: estimate });\n});\n\n// Admin: list inquiries\napp.get(\"/admin\", async (c) => {\n const gate = requireAdmin(c);\n if (gate) return gate;\n const { rows } = await sqlite.execute(\"SELECT * FROM inquiries ORDER BY created_at DESC\");\n return c.html(adminPage(rows ?? []));\n});\n\n// Admin: CSV export\napp.get(\"/admin/export.csv\", async (c) => {\n const gate = requireAdmin(c);\n if (gate) return gate;\n const { columns, rows } = await sqlite.execute(\"SELECT * FROM inquiries ORDER BY created_at DESC\");\n const headers = columns?.map((c) => c.name) ?? [];\n const csv = [headers.join(\",\")].concat(\n (rows ?? []).map((r) => headers.map((h) => csvEscape(r[h])).join(\",\")),\n ).join(\"\\n\");\n const filename = `inquiries-${new Date().toISOString().slice(0, 10)}.csv`;\n return c.body(csv, 200, {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\": `attachment; filename=\"${filename}\"`,\n });\n});\n\n// ---------- Helpers ----------\nfunction csvEscape(v: any) {\n const s = String(v ?? \"\");\n return /[\",\\n]/.test(s) ? `\"${s.replace(/\"/g, '\"\"')}\"` : s;\n}\n\nconst entityMap = {\n \"&\": \"&\",\n \"<\": \"<\",\n \">\": \">\",\n '\"': \""\",\n \"'\": \"'\",\n \"/\": \"/\",\n};\nfunction escapeHtml(s: any) {\n return String(s ?? \"\").replace(/[&<>\"'/]/g, (char) => entityMap[char]);\n}\n\n\nfunction sanitizeInquiry(b: any) {\n const pick = (k: string, len = 255) => String(b?.[k] ?? \"\").trim().slice(0, len);\n const num = (k: string, def = 0, min = 0, max = 1000) => {\n const n = Number(b?.[k]);\n return Number.isFinite(n) ? Math.max(min, Math.min(max, n)) : def;\n };\n const bool = (k: string) => b?.[k] ? 1 : 0;\n const complexity = pick(\"complexity\").toLowerCase();\n const safeComplexity = ([\"easy\", \"medium\", \"hard\"] as const).includes(complexity as any)\n ? complexity as any\n : \"medium\";\n\n return {\n name: pick(\"name\"),\n phone: pick(\"phone\"),\n email: pick(\"email\"),\n address: pick(\"address\"),\n city: pick(\"city\"),\n zip: pick(\"zip\"),\n service: pick(\"service\", 100),\n tree_count: num(\"tree_count\", 1, 1, 100),\n tree_height_ft: num(\"tree_height_ft\", 30, 5, 200),\n trunk_diameter_in: num(\"trunk_diameter_in\", 10, 2, 100),\n complexity: safeComplexity,\n stump_grinding: bool(\"stump_grinding\"),\n haul_away: bool(\"haul_away\"),\n notes: pick(\"notes\", 1000),\n };\n}\n\n// ---------- HTML Templates ----------\nconst page = () =>\n html`\n \n \n \n \n \n Gulf Coast Woodworks — Tree Removal, Crestview FL\n \n \n \n \n \n

Gulf Coast Woodworks

\n Tree Removal • Trimming • Stump Grinding — Crestview, Florida &\n the Gulf Coast\n

\n\n

Get an Instant Estimate & Schedule Service

\n Use the form below to get a rough estimate. If the price looks right,\n fill in your contact details and send the inquiry. We'll confirm the\n details and schedule a visit.\n

\n 1. Job Details\n

\n How many trees?\n \n

\n Avg. Height (ft)\n \n

\n Avg. Diameter (in)\n \n

\n Complexity\n \n

\n \n Stump Grinding\n

\n \n Haul Away Debris\n

\n \n

Rough Estimate

\n\n

\n 2. Your Information\n \n

\n Name\n \n

\n Phone\n \n

\n Service Address\n \n

\n Notes (optional)\n \n

\n\n \n

\n \n

\n\n \n \n \n `;\n\nconst adminPage = (rows: any[]) =>\n html`\n \n \n \n \n \n Admin — Gulf Coast Woodworks\n \n \n \n \n

Inquiries (${rows.length})

\n \n Export CSV\n \n

\n \n \n \n ${[\"Date\", \"Status\", \"Contact\", \"Location\", \"Job\", \"Estimate\", \"Notes\"].map(h =>\n ``\n ).join(\"\")}\n \n \n \n ${rows.map(r => `\n \n \n \n \n \n \n \n \n \n `).join(\"\")}\n \n

${h}
${r.created_at.slice(0, 10)}	${escapeHtml(r.status)}	\n ${escapeHtml(r.name)} \n ${escapeHtml(r.phone)} \n ${escapeHtml(r.email)} \n	\n ${escapeHtml(r.address)} \n ${escapeHtml(r.city)}, ${escapeHtml(r.zip)} \n	\n ${r.tree_count} tree(s) @ ~${r.tree_height_ft}' x ${r.trunk_diameter_in}\"\n ${escapeHtml(r.complexity)} \n \n ${r.stump_grinding ? \"✓ Stump\" : \"\"} ${r.haul_away ? \"✓ Haul\" : \"\"}\n \n	$${Number(r.estimate_usd \|\| 0).toLocaleString()}	\n ${escapeHtml(r.notes)} \n

\n \n \n `;\n\n// ✅ Correct Val Town export\nexport default async function handler(req: Request): Promise {\n return app.fetch(req);\n}",[],[202],"files",[154,173,182,191,200],"counts",{"_213":32,"_214":215,"_216":32,"_217":218},"pulls","branches",1,"forks","envVars",{"_219":215,"_220":32},"count","emptyCount","contents",[],"file",{"_105":155,"_159":142,"_156":157,"_96":100,"_167":73,"_165":166,"_101":164,"_158":-5,"_107":225,"_160":161,"_169":-5,"_99":226},["D",1756165809998],[100],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_94":95,"_96":97,"_98":44,"_101":102,"_99":100,"_103":235,"_152":240,"_209":256,"_223":257,"_221":260,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":266,"_217":-5},{"_105":106,"_96":97,"_107":236,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":117,"_118":119,"_120":119,"_121":-5,"_122":32,"_16":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":237,"_136":238,"_139":239,"_151":22},["D",1756128213303],{"_94":95,"_134":135},{"_94":95,"_138":135,"_14":115},{"_101":141,"_96":44,"_105":142,"_143":106,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":97,"_150":95},[241,244,247,250,253],{"_105":155,"_96":100,"_156":157,"_158":-5,"_159":142,"_160":161,"_162":22,"_107":163,"_101":164,"_165":166,"_167":73,"_168":22,"_169":-5,"_170":242,"_99":243},[],[100],{"_105":174,"_96":175,"_156":176,"_158":-5,"_159":142,"_160":177,"_162":22,"_107":178,"_101":32,"_165":166,"_167":179,"_168":22,"_169":-5,"_170":245,"_99":246},[],[175],{"_105":183,"_96":184,"_156":185,"_158":-5,"_159":142,"_160":186,"_162":22,"_107":187,"_101":188,"_165":166,"_167":179,"_168":22,"_169":-5,"_170":248,"_99":249},[],[184],{"_105":192,"_96":193,"_156":194,"_158":-5,"_159":142,"_160":195,"_162":22,"_107":196,"_101":32,"_165":197,"_167":73,"_168":22,"_169":-5,"_170":251,"_99":252},[],[193],{"_105":201,"_96":202,"_156":203,"_158":-5,"_159":142,"_160":204,"_162":22,"_107":205,"_101":164,"_165":166,"_167":206,"_168":22,"_169":-5,"_170":254,"_99":255},[],[202],[241,244,247,250,253],{"_105":155,"_96":100,"_156":157,"_158":-5,"_159":142,"_160":161,"_162":22,"_107":258,"_101":164,"_165":166,"_167":73,"_168":22,"_169":-5,"_99":259},["D",1756165809998],[100],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

ziggyware

Gulf-Coast-Woodworks