Add-Edit-Website

\n \n

\n Website Logo (100x50px)\n

\n $\"Preview\"$ \n

\n \n \n

\n Website URL\n \n

\n \n \n

\n \n \n \n Active\n \n

\n \n \n

\n Associated User\n \n

\n \n \n

User Information

\n Name\n

\n Position\n

\n Type\n

\n Status\n

Unsaved

\n \n \n

\n \n \n \n

\n \n \n

Admin Types

Master Admin
Data
Competition
Accounting
Administrative
Sales
Systems

\n \n

User Types

Customer
Distributor
Master Distributor
Engineer

\n \n \n

Websites

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

Logo	URL	Active	User	Position	Type	Actions

\n \n \n\n",[19,68],"9f22eb58-3433-11f0-9dab-9e149126039e",["D",1747605676623],"directory",[19],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":70,"_47":48,"_49":89,"_17":51,"_52":76,"_53":-5,"_55":56,"_57":-5,"_86":90,"_18":91},{"_36":80,"_13":81,"_39":82,"_41":-5,"_43":44,"_45":83,"_47":48,"_49":84,"_17":51,"_52":64,"_53":85,"_55":56,"_57":-5,"_86":87,"_18":88},"8de2357e-3433-11f0-8c4b-9e149126039e","index.ts","8de23632-3433-11f0-8c4b-9e149126039e",1,["D",1747605647675],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// Initialize the Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main route - serve the dashboard\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get initial data for the dashboard\n const websites = await getWebsites();\n const users = await getUsers();\n \n // Inject data to avoid extra round-trips\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API endpoints\napp.post(\"/api/website\", async c => {\n try {\n const data = await c.req.json();\n const result = await saveWebsite(data);\n return c.json({ success: true, id: result.id });\n } catch (error) {\n console.error(\"Error saving website:\", error);\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\napp.delete(\"/api/website/:id\", async c => {\n try {\n const id = c.req.param(\"id\");\n await deleteWebsite(parseInt(id));\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting website:\", error);\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\napp.get(\"/api/website/:id\", async c => {\n try {\n const id = c.req.param(\"id\");\n const website = await getWebsiteById(parseInt(id));\n return c.json(website);\n } catch (error) {\n console.error(\"Error getting website:\", error);\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\napp.post(\"/api/upload-image\", async c => {\n try {\n const formData = await c.req.formData();\n const file = formData.get(\"image\") as File;\n \n if (!file) {\n return c.json({ success: false, error: \"No image provided\" }, 400);\n }\n \n // Convert to buffer\n const arrayBuffer = await file.arrayBuffer();\n const buffer = new Uint8Array(arrayBuffer);\n \n // Generate a unique key for the image\n const key = `website_image_${Date.now()}`;\n \n // Store the image in blob storage\n await blob.set(key, buffer);\n \n return c.json({ success: true, key });\n } catch (error) {\n console.error(\"Error uploading image:\", error);\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\napp.get(\"/api/image/:key\", async c => {\n try {\n const key = c.req.param(\"key\");\n const image = await blob.get(key);\n \n if (!image) {\n return c.json({ success: false, error: \"Image not found\" }, 404);\n }\n \n return new Response(image, {\n headers: {\n \"Content-Type\": \"image/jpeg\"\n }\n });\n } catch (error) {\n console.error(\"Error getting image:\", error);\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Database functions\nasync function initDatabase() {\n // Create websites table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS websites (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n image_key TEXT,\n url TEXT,\n is_active INTEGER DEFAULT 1,\n user_id INTEGER,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n \n // Create users table for demo purposes\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n position TEXT,\n type TEXT\n )\n `);\n \n // Insert some demo users if none exist\n const users = await sqlite.execute(`SELECT COUNT(*) as count FROM users`);\n if (users.rows[0].count === 0) {\n await sqlite.execute(`\n INSERT INTO users (name, position, type) VALUES \n ('Alfonso Zambrano', 'Sales Executive', 'Sales'),\n ('John Doe', 'Engineer', 'Engineer'),\n ('Jane Smith', 'Customer Support', 'Customer')\n `);\n }\n}\n\nasync function getWebsites() {\n const result = await sqlite.execute(`\n SELECT w.*, u.name, u.position, u.type\n FROM websites w\n LEFT JOIN users u ON w.user_id = u.id\n ORDER BY w.id DESC\n `);\n return result.rows;\n}\n\nasync function getWebsiteById(id: number) {\n const result = await sqlite.execute(`\n SELECT w.*, u.name, u.position, u.type\n FROM websites w\n LEFT JOIN users u ON w.user_id = u.id\n WHERE w.id = ?\n `, [id]);\n \n return result.rows[0] || null;\n}\n\nasync function saveWebsite(data: any) {\n if (data.id) {\n // Update existing website\n await sqlite.execute(`\n UPDATE websites\n SET image_key = ?, url = ?, is_active = ?, user_id = ?\n WHERE id = ?\n `, [data.image_key, data.url, data.is_active ? 1 : 0, data.user_id, data.id]);\n return { id: data.id };\n } else {\n // Insert new website\n const result = await sqlite.execute(`\n INSERT INTO websites (image_key, url, is_active, user_id)\n VALUES (?, ?, ?, ?)\n `, [data.image_key, data.url, data.is_active ? 1 : 0, data.user_id]);\n \n return { id: result.lastInsertId };\n }\n}\n\nasync function deleteWebsite(id: number) {\n await sqlite.execute(`DELETE FROM websites WHERE id = ?`, [id]);\n}\n\nasync function getUsers() {\n const result = await sqlite.execute(`SELECT * FROM users`);\n return result.rows;\n}\n\n// Initialize database on startup\ninitDatabase().catch(console.error);\n\n// Export the Hono app\nexport default app.fetch;","children",[],[81],["D",1747605676623],[92,93,94],[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":101,"_17":51,"_52":24,"_53":72,"_55":56,"_57":-5,"_86":102,"_18":103},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":98,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_86":99,"_18":100},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":95,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_86":96,"_18":97},["D",1747605701637],[],[19,38],["D",1747605748930],[],[19,60],["D",1747605676623],[],[19,68],"0dd90ef2-3433-11f0-b490-9e149126039e",["D",1747605432877],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","6d1a8823-fe10-45f4-bcbd-a770965a4076","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","d5bd8050-8cc2-42da-9363-b43822f64a95","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_156":152},"org",{"_11":12,"_150":-5,"_151":152,"_113":114,"_153":154,"_155":56},"branch",{"_17":62,"_13":16,"_36":44,"_142":104,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":14,"_149":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJtcnh0RGp4ZnpzRUc0OHdPcU9janhocmpxSiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":104,"_13":14,"_49":207,"_106":-5,"_107":56,"_108":109,"_110":109,"_111":-5,"_112":-5,"_113":114,"_115":-5,"_116":56,"_117":-5,"_118":-5,"_119":51,"_120":121,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_135":208,"_137":209,"_139":210,"_141":56},[192,196],"files",[192,193,194,195,196],"counts",{"_183":51,"_184":83,"_185":51,"_32":186,"_187":188},[177,178,179],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":70,"_47":48,"_49":75,"_17":51,"_52":76,"_53":-5,"_55":56,"_57":-5,"_18":176},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":71,"_17":51,"_52":24,"_53":72,"_55":56,"_57":-5,"_18":182},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":63,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_18":181},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_18":180},[19,38],[19,60],[19,68],"pulls","branches","forks",{"_189":51,"_191":51},"connections",{"_189":51,"_190":51},"count","unfilledCount","emptyCount",{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":70,"_47":48,"_49":89,"_17":51,"_52":76,"_53":-5,"_55":56,"_57":-5,"_86":205,"_18":206},{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":101,"_17":51,"_52":24,"_53":72,"_55":56,"_57":-5,"_86":203,"_18":204},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":98,"_17":51,"_52":64,"_53":65,"_55":56,"_57":-5,"_86":201,"_18":202},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":95,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_86":199,"_18":200},{"_36":80,"_13":81,"_39":82,"_41":-5,"_43":44,"_45":83,"_47":48,"_49":84,"_17":51,"_52":64,"_53":85,"_55":56,"_57":-5,"_86":197,"_18":198},[],[81],[],[19,38],[],[19,60],[],[19,68],[193,194,195],[19],["D",1747605432877],{"_11":12,"_156":152},{"_11":12,"_150":-5,"_151":152,"_113":114,"_153":154,"_155":56},{"_17":62,"_13":16,"_36":44,"_142":104,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":14,"_149":12},"ctx",{"_135":-5,"_173":244,"_245":246,"_247":248,"_249":56,"_250":56,"_251":56,"_252":48,"_253":-5,"_254":-7,"_255":-7,"_256":51,"_257":56,"_258":56,"_259":-5,"_260":56,"_261":56,"_262":56,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":16,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]