[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_230":231,"_232":233},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","5322ffa4-3136-11f0-a084-569c3dd06744","name","index.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { cors } from \"https://esm.sh/@hono/cors@0.0.8\";\nimport { readFile, serveFile, parseProject } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport apiRoutes from \"./routes/api.ts\";\n\n// Initialize the 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// Add CORS middleware\napp.use(\"*\", cors());\n\n// Run migrations on startup\napp.use(\"*\", async (c, next) => {\n try {\n await runMigrations();\n } catch (error) {\n console.error(\"Migration error:\", error);\n }\n await next();\n});\n\n// API routes\napp.route(\"/api\", apiRoutes);\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// Serve the main HTML page with initial data\napp.get(\"/\", async c => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get project info for view source link\n const projectInfo = parseProject(import.meta.url);\n const viewSourceUrl = projectInfo.links.self.project;\n \n // Replace placeholders with actual data\n html = html.replace(\"__VIEW_SOURCE_URL__\", viewSourceUrl);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index:\", error);\n return c.text(\"Error loading application. Please try again later.\", 500);\n }\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;","createdAt",["D",1747276984122],"branchVersion","branchId","0899cc42-3136-11f0-a36f-569c3dd06744","id","089964be-3136-11f0-a36f-569c3dd06744","create",["D",1747276859072],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","charmaine","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":226,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":227,"_78":228,"_80":229,"_82":24},"tree",[160,167,169],"files",[160,161,162,163,164,165,166,167,168,169],"counts",{"_150":60,"_151":131,"_152":60,"_153":154,"_155":156},"contents",[124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":144,"_31":145,"_29":146,"_130":-5,"_40":41,"_39":147,"_132":56,"_37":148,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":149},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_132":56,"_37":141,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":143},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":56,"_37":133,"_13":60,"_33":20,"_35":134,"_23":24,"_135":-5,"_26":136},"33a01388-3136-11f0-b784-569c3dd06744","README.md","33a01428-3136-11f0-b784-569c3dd06744","parentId",1,"latest",["D",1747276931253],"# Personal CRM\n\nA simple personal Customer Relationship Management (CRM) system built on Val Town.\n\n## Features\n\n- Store and manage contacts\n- Track interactions with contacts (calls, emails, meetings)\n- Search and filter contacts\n- Add notes and reminders\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ └── queries.ts # DB query functions\n│ ├── routes/ # Route modules\n│ │ └── api.ts # API endpoints\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── ContactList.tsx # List of contacts\n│ │ ├── ContactDetail.tsx # Contact details view\n│ │ ├── ContactForm.tsx # Add/edit contact form\n│ │ └── InteractionForm.tsx # Add interaction form\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend JS entry point\n└── shared/\n └── types.ts # Shared types and interfaces\n```\n\n## How to Use\n\n1. Visit the HTTP endpoint to access the CRM interface\n2. Add contacts with their details\n3. Record interactions with your contacts\n4. Search and filter to find specific contacts\n\n## Technologies Used\n\n- Backend: Hono, SQLite\n- Frontend: React, Tailwind CSS\n- Shared: TypeScript","label",[128],"364f8956-3136-11f0-b784-569c3dd06744","shared","13acfb30-d58d-4833-af59-7204cf2571ba",2,["D",1747276935757],"directory",[138],"3aa16254-3136-11f0-a98c-569c3dd06744","backend","c1e5f7b3-ff70-4acc-b793-a1bdd91064ac",3,["D",1747276943006],[145],"pulls","branches","forks","envVars",{"_157":60,"_159":60},"connections",{"_157":60,"_158":60},"count","unfilledCount","emptyCount",{"_42":144,"_31":145,"_29":146,"_130":-5,"_40":41,"_39":147,"_132":56,"_37":223,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_171":224,"_26":225},{"_42":219,"_31":211,"_29":205,"_130":146,"_40":41,"_39":147,"_132":56,"_37":220,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_171":221,"_26":222},{"_42":212,"_31":213,"_29":214,"_130":205,"_40":41,"_39":147,"_132":56,"_37":215,"_13":60,"_33":34,"_35":216,"_23":24,"_135":-5,"_171":217,"_26":218},{"_42":202,"_31":203,"_29":204,"_130":205,"_40":41,"_39":206,"_132":56,"_37":207,"_13":60,"_33":34,"_35":208,"_23":24,"_135":-5,"_171":209,"_26":210},{"_42":198,"_31":197,"_29":191,"_130":146,"_40":41,"_39":192,"_132":56,"_37":199,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_171":200,"_26":201},{"_42":188,"_31":189,"_29":190,"_130":191,"_40":41,"_39":192,"_132":56,"_37":193,"_13":60,"_33":34,"_35":194,"_23":24,"_135":-5,"_171":195,"_26":196},{"_42":184,"_31":32,"_29":30,"_130":146,"_40":41,"_39":14,"_132":24,"_37":185,"_13":60,"_33":34,"_35":36,"_23":24,"_135":-5,"_171":186,"_26":187},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_132":56,"_37":181,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_171":182,"_26":183},{"_42":174,"_31":175,"_29":176,"_130":139,"_40":41,"_39":140,"_132":56,"_37":177,"_13":60,"_33":34,"_35":178,"_23":24,"_135":-5,"_171":179,"_26":180},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":56,"_37":170,"_13":60,"_33":20,"_35":134,"_23":24,"_135":-5,"_171":172,"_26":173},["D",1747276931253],"children",[],[128],"364f8460-3136-11f0-b784-569c3dd06744","types.ts","364f850a-3136-11f0-b784-569c3dd06744",["D",1747276935757],"// Shared types for the Personal CRM\n\nexport interface Contact {\n id?: number;\n name: string;\n email?: string;\n phone?: string;\n company?: string;\n notes?: string;\n created_at?: string;\n updated_at?: string;\n}\n\nexport type InteractionType = 'call' | 'email' | 'meeting' | 'other';\n\nexport interface Interaction {\n id?: number;\n contact_id: number;\n type: InteractionType;\n notes?: string;\n date: string;\n created_at?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[138,175],["D",1747276935757],[168],[138],"5322fedc-3136-11f0-a084-569c3dd06744",["D",1747276984122],[],[145,32],"4c9841c6-3136-11f0-9aa1-569c3dd06744","api.ts","4c9842a2-3136-11f0-9aa1-569c3dd06744","374c1afc-3393-44f6-9222-5f278139f437",5,["D",1747276973145],"import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { \n getAllContacts, \n getContactById, \n createContact, \n updateContact, \n deleteContact,\n searchContacts,\n getInteractionsByContactId,\n createInteraction,\n deleteInteraction\n} from \"../database/queries.ts\";\nimport { Contact, Interaction } from \"../../shared/types.ts\";\n\nconst api = new Hono();\n\n// Contacts endpoints\napi.get(\"/contacts\", async (c) => {\n try {\n const searchQuery = c.req.query(\"q\");\n const contacts = searchQuery \n ? await searchContacts(searchQuery)\n : await getAllContacts();\n \n return c.json({ success: true, data: contacts });\n } catch (error) {\n console.error(\"Error fetching contacts:\", error);\n return c.json({ success: false, error: \"Failed to fetch contacts\" }, 500);\n }\n});\n\napi.get(\"/contacts/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const contact = await getContactById(id);\n \n if (!contact) {\n return c.json({ success: false, error: \"Contact not found\" }, 404);\n }\n \n return c.json({ success: true, data: contact });\n } catch (error) {\n console.error(\"Error fetching contact:\", error);\n return c.json({ success: false, error: \"Failed to fetch contact\" }, 500);\n }\n});\n\napi.post(\"/contacts\", async (c) => {\n try {\n const contact = await c.req.json() as Contact;\n \n if (!contact.name) {\n return c.json({ success: false, error: \"Name is required\" }, 400);\n }\n \n const id = await createContact(contact);\n return c.json({ success: true, data: { id } }, 201);\n } catch (error) {\n console.error(\"Error creating contact:\", error);\n return c.json({ success: false, error: \"Failed to create contact\" }, 500);\n }\n});\n\napi.put(\"/contacts/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const contact = await c.req.json() as Contact;\n \n if (!contact.name) {\n return c.json({ success: false, error: \"Name is required\" }, 400);\n }\n \n const success = await updateContact(id, contact);\n \n if (!success) {\n return c.json({ success: false, error: \"Contact not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error updating contact:\", error);\n return c.json({ success: false, error: \"Failed to update contact\" }, 500);\n }\n});\n\napi.delete(\"/contacts/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const success = await deleteContact(id);\n \n if (!success) {\n return c.json({ success: false, error: \"Contact not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting contact:\", error);\n return c.json({ success: false, error: \"Failed to delete contact\" }, 500);\n }\n});\n\n// Interactions endpoints\napi.get(\"/contacts/:id/interactions\", async (c) => {\n try {\n const contactId = parseInt(c.req.param(\"id\"));\n const interactions = await getInteractionsByContactId(contactId);\n \n return c.json({ success: true, data: interactions });\n } catch (error) {\n console.error(\"Error fetching interactions:\", error);\n return c.json({ success: false, error: \"Failed to fetch interactions\" }, 500);\n }\n});\n\napi.post(\"/interactions\", async (c) => {\n try {\n const interaction = await c.req.json() as Interaction;\n \n if (!interaction.contact_id || !interaction.type || !interaction.date) {\n return c.json({ \n success: false, \n error: \"Contact ID, type, and date are required\" \n }, 400);\n }\n \n const id = await createInteraction(interaction);\n return c.json({ success: true, data: { id } }, 201);\n } catch (error) {\n console.error(\"Error creating interaction:\", error);\n return c.json({ success: false, error: \"Failed to create interaction\" }, 500);\n }\n});\n\napi.delete(\"/interactions/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const success = await deleteInteraction(id);\n \n if (!success) {\n return c.json({ success: false, error: \"Interaction not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting interaction:\", error);\n return c.json({ success: false, error: \"Failed to delete interaction\" }, 500);\n }\n});\n\nexport default api;",[],[145,197,189],"routes","4c9867dc-3136-11f0-9aa1-569c3dd06744",["D",1747276973145],[165],[145,197],"42e97848-3136-11f0-8f7a-569c3dd06744","queries.ts","42e9792e-3136-11f0-8f7a-569c3dd06744","0c5a3a9d-173a-4d53-a564-c4eaa3105491",4,["D",1747276956902],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Contact, Interaction } from \"../../shared/types.ts\";\nimport { CONTACTS_TABLE, INTERACTIONS_TABLE } from \"./migrations.ts\";\n\n// Contact queries\nexport async function getAllContacts(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${CONTACTS_TABLE} ORDER BY name ASC`);\n return result.rows as Contact[];\n}\n\nexport async function getContactById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CONTACTS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows.length > 0 ? (result.rows[0] as Contact) : null;\n}\n\nexport async function createContact(contact: Contact): Promise {\n const { name, email, phone, company, notes } = contact;\n const result = await sqlite.execute(\n `INSERT INTO ${CONTACTS_TABLE} (name, email, phone, company, notes) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [name, email || null, phone || null, company || null, notes || null]\n );\n return result.rows[0].id as number;\n}\n\nexport async function updateContact(id: number, contact: Contact): Promise {\n const { name, email, phone, company, notes } = contact;\n const result = await sqlite.execute(\n `UPDATE ${CONTACTS_TABLE} \n SET name = ?, email = ?, phone = ?, company = ?, notes = ?, updated_at = datetime('now')\n WHERE id = ?`,\n [name, email || null, phone || null, company || null, notes || null, id]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function deleteContact(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${CONTACTS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function searchContacts(query: string): Promise {\n const searchTerm = `%${query}%`;\n const result = await sqlite.execute(\n `SELECT * FROM ${CONTACTS_TABLE} \n WHERE name LIKE ? OR email LIKE ? OR company LIKE ? OR notes LIKE ?\n ORDER BY name ASC`,\n [searchTerm, searchTerm, searchTerm, searchTerm]\n );\n return result.rows as Contact[];\n}\n\n// Interaction queries\nexport async function getInteractionsByContactId(contactId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${INTERACTIONS_TABLE} \n WHERE contact_id = ? \n ORDER BY date DESC`,\n [contactId]\n );\n return result.rows as Interaction[];\n}\n\nexport async function createInteraction(interaction: Interaction): Promise {\n const { contact_id, type, notes, date } = interaction;\n const result = await sqlite.execute(\n `INSERT INTO ${INTERACTIONS_TABLE} (contact_id, type, notes, date) \n VALUES (?, ?, ?, ?) RETURNING id`,\n [contact_id, type, notes || null, date]\n );\n return result.rows[0].id as number;\n}\n\nexport async function deleteInteraction(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${INTERACTIONS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rowsAffected > 0;\n}",[],[145,211,203],"database","3aa15a98-3136-11f0-a98c-569c3dd06744","migrations.ts","3aa15b74-3136-11f0-a98c-569c3dd06744",["D",1747276943006],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - change these when modifying schema\nexport const CONTACTS_TABLE = 'personal_crm_contacts';\nexport const INTERACTIONS_TABLE = 'personal_crm_interactions';\n\nexport async function runMigrations() {\n // Create contacts table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CONTACTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT,\n phone TEXT,\n company TEXT,\n notes TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )\n `);\n\n // Create interactions table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${INTERACTIONS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n contact_id INTEGER NOT NULL,\n type TEXT NOT NULL,\n notes TEXT,\n date TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (contact_id) REFERENCES ${CONTACTS_TABLE} (id) ON DELETE CASCADE\n )\n `);\n\n console.log(\"Migrations completed successfully\");\n}",[],[145,211,213],"3aa16498-3136-11f0-a98c-569c3dd06744",["D",1747276943006],[162,163],[145,211],["D",1747276943006],[161,164,166],[145],["D",1747276859072],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":263,"_264":265,"_266":267,"_268":24,"_269":24,"_270":24,"_271":56,"_272":-5,"_273":-7,"_274":-7,"_275":60,"_276":24,"_277":24,"_278":-5,"_279":24,"_280":24,"_281":24,"_282":-5},"ENV",{"_234":235,"_236":237,"_238":84,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262},"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"]

Diff · v6