[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_165":166,"_167":168},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":49,"_121":-5,"_122":-5,"_123":124},"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":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",91,"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.tsx","latestPath","fileId","ac847914-27aa-11f0-9edc-569c3dd06744","name","fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\n\nfunction LoginScreen({ onLogin }) {\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n try {\n const response = await fetch(\"/login\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ password }),\n });\n\n if (response.ok) {\n onLogin();\n setError(\"\");\n } else {\n const result = await response.json();\n setError(result.message || \"Incorrect password\");\n }\n } catch (error) {\n setError(\"Login failed. Please try again.\");\n }\n };\n\n return (\n

\n );\n}\n\nfunction CustomerInteractionForm({ onSubmit }) {\n const [email, setEmail] = useState(\"\");\n const [firstName, setFirstName] = useState(\"\");\n const [lastName, setLastName] = useState(\"\");\n const [interactionDate, setInteractionDate] = useState(new Date().toLocaleDateString(\"en-US\"));\n const [notes, setNotes] = useState(\"\");\n const [additionalNotesLink, setAdditionalNotesLink] = useState(\"\");\n const formRef = useRef(null);\n const emailInputRef = useRef(null);\n const [tags, setTags] = useState([]);\n const [tagInput, setTagInput] = useState(\"\");\n\n // Fetch previous customer details when email changes\n useEffect(() => {\n const fetchCustomerDetails = async () => {\n if (!email) return;\n\n try {\n const response = await fetch(`/get-customer-details?email=${encodeURIComponent(email)}`);\n if (response.ok) {\n const customerDetails = await response.json();\n if (customerDetails) {\n setFirstName(customerDetails.first_name || \"\");\n setLastName(customerDetails.last_name || \"\");\n }\n }\n } catch (error) {\n console.error(\"Error fetching customer details:\", error);\n }\n };\n\n fetchCustomerDetails();\n }, [email]);\n\n // Add keyboard shortcut for form submission\n // Inside CustomerInteractionForm component\n useEffect(() => {\n const handleKeyDown = (e) => {\n // If we're in the tag input, let handleTagInput handle cmd-k\n if (e.target.className === \"tag-input\") {\n return;\n }\n\n // For other inputs, handle cmd-k normally\n if ((e.metaKey || e.ctrlKey) && e.key.toLowerCase() === \"k\") {\n e.preventDefault();\n formRef.current?.requestSubmit();\n }\n };\n\n // Add event listener to window\n window.addEventListener(\"keydown\", handleKeyDown, true);\n\n // Cleanup event listener\n return () => {\n window.removeEventListener(\"keydown\", handleKeyDown, true);\n };\n }, []);\n\n useEffect(() => {\n emailInputRef.current?.focus();\n }, []);\n\n const handleTagInput = (e) => {\n // Stop cmd-k from removing tags\n if ((e.metaKey || e.ctrlKey) && e.key.toLowerCase() === \"k\") {\n e.preventDefault();\n formRef.current?.requestSubmit();\n return;\n }\n\n if (e.key === \"Enter\" || e.key === \",\") {\n e.preventDefault();\n const newTag = tagInput.trim();\n if (newTag && !tags.includes(newTag)) {\n setTags([...tags, newTag]);\n }\n setTagInput(\"\");\n }\n };\n\n const removeTag = (tagToRemove, event) => {\n // If this was triggered by a keyboard event, don't remove the tag\n if (event && (event.metaKey || event.ctrlKey)) {\n return;\n }\n setTags(tags.filter(tag => tag !== tagToRemove));\n };\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n try {\n const response = await fetch(\"/add-interaction\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n firstName,\n lastName,\n email,\n interactionDate,\n notes,\n additionalNotesLink,\n tags, // Add this line\n }),\n });\n if (response.ok) {\n setFirstName(\"\");\n setLastName(\"\");\n setEmail(\"\");\n setNotes(\"\");\n setAdditionalNotesLink(\"\");\n setTags([]); // Reset tags\n setInteractionDate(new Date().toLocaleDateString(\"en-US\"));\n onSubmit();\n }\n } catch (error) {\n console.error(\"Error submitting interaction:\", error);\n }\n };\n\n return (\n

\n setEmail(e.target.value)}\n required\n />\n

\n setFirstName(e.target.value)}\n required\n />\n setLastName(e.target.value)}\n required\n />\n

\n setInteractionDate(e.target.value)}\n required\n />\n {/* Move the Key Takeaway and Additional Notes fields BEFORE the tags */}\n setNotes(e.target.value)}\n required\n />\n setAdditionalNotesLink(e.target.value)}\n />\n {/* Tags section moved to the end */}\n

\n {tags.map(tag => (\n \n {tag}\n removeTag(tag, e)}\n className=\"tag-remove\"\n >\n ×\n \n \n ))}\n

\n setTagInput(e.target.value)}\n onKeyDown={handleTagInput}\n className=\"tag-input\"\n />\n

\n \n \n );\n}\n\nfunction InteractionList() {\n const [customerInteractions, setCustomerInteractions] = useState({});\n const [copiedEmail, setCopiedEmail] = useState(null);\n const [currentPage, setCurrentPage] = useState(1);\n const [totalInteractions, setTotalInteractions] = useState(0);\n const [selectedTags, setSelectedTags] = useState([]);\n const [availableTags, setAvailableTags] = useState([]);\n const [tagCounts, setTagCounts] = useState({});\n const [uniqueCustomerCount, setUniqueCustomerCount] = useState(0);\n\n const fetchUniqueCustomerCount = async () => {\n try {\n const response = await fetch(\"/get-unique-customer-count\");\n const data = await response.json();\n setUniqueCustomerCount(data.count);\n } catch (error) {\n console.error(\"Error fetching unique customer count:\", error);\n }\n };\n\n useEffect(() => {\n fetchInteractions();\n fetchUniqueCustomerCount();\n }, [currentPage, selectedTags]);\n\n useEffect(() => {\n setCurrentPage(1);\n }, [selectedTags]);\n\n const handleCopyEmail = async (email) => {\n try {\n await navigator.clipboard.writeText(email);\n setCopiedEmail(email);\n setTimeout(() => setCopiedEmail(null), 2000);\n } catch (err) {\n console.error(\"Failed to copy email:\", err);\n }\n };\n\n const handleDeleteInteraction = async (id) => {\n try {\n const response = await fetch(\"/delete-interaction\", {\n method: \"DELETE\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ id }),\n });\n\n if (response.ok) {\n fetchInteractions();\n }\n } catch (error) {\n console.error(\"Error deleting interaction:\", error);\n }\n };\n\n const handleTagSelect = (tag) => {\n setSelectedTags(prev =>\n prev.includes(tag)\n ? prev.filter(t => t !== tag)\n : [...prev, tag]\n );\n };\n\n const fetchInteractions = async () => {\n try {\n const response = await fetch(`/get-interactions?page=${currentPage}`);\n const data = await response.json();\n\n // Set available tags and counts from server data\n setTagCounts(data.tagCounts);\n setAvailableTags(Object.keys(data.tagCounts));\n\n // Filter interactions based on selected tags\n const filteredInteractions = selectedTags.length > 0\n ? data.interactions.filter(interaction => {\n if (!interaction.tags) return false;\n const interactionTags = interaction.tags.split(\",\").map(tag => tag.trim());\n return selectedTags.every(tag => interactionTags.includes(tag));\n })\n : data.interactions;\n\n // Group filtered interactions by customer\n const groupedInteractions = filteredInteractions.reduce((acc, interaction) => {\n const customerKey = `${interaction.first_name} ${interaction.last_name}`;\n if (!acc[customerKey]) {\n acc[customerKey] = [];\n }\n acc[customerKey].push(interaction);\n return acc;\n }, {});\n\n setCustomerInteractions(groupedInteractions);\n\n // Update total count based on whether filters are applied\n if (selectedTags.length > 0) {\n // Need to get total count of filtered interactions from server\n const filteredCountResponse = await fetch(`/get-filtered-count?tags=${selectedTags.join(\",\")}`);\n const filteredCountData = await filteredCountResponse.json();\n setTotalInteractions(filteredCountData.count);\n } else {\n setTotalInteractions(data.total);\n }\n } catch (error) {\n console.error(\"Error fetching interactions:\", error);\n }\n };\n\n useEffect(() => {\n fetchInteractions();\n }, [currentPage, selectedTags]);\n\n return (\n

📋 Customer Conversations

\n \n We've spoken to {uniqueCustomerCount} customers 🙂‍↕️\n \n\n {/* Tag Filter Section */}\n

Filter by Tags

\n {availableTags.map(tag => (\n handleTagSelect(tag)}\n className={`tag-pill ${selectedTags.includes(tag) ? \"selected\" : \"\"}`}\n >\n {tag} {tagCounts[tag] ? `(${tagCounts[tag]})` : \"\"}\n \n ))}\n

\n {selectedTags.length > 0 && (\n setSelectedTags([])}\n className=\"pagination-button\"\n >\n Clear Filters\n \n )}\n

\n\n {/* Display when no results match filters */}\n {Object.keys(customerInteractions).length === 0 && selectedTags.length > 0 && (\n

\n No interactions found with the selected tags.\n

\n )}\n\n {Object.entries(customerInteractions).map(([customerName, interactions]) => (\n

🧑 {customerName}

\n 📧{\" \"}\n \n handleCopyEmail(interactions[0].email)}\n className=\"copyable-email\"\n >\n {interactions[0].email}\n {\" \"}\n {copiedEmail === interactions[0].email && \"✓\"}\n

\n {interactions.map((interaction) => (\n

📝 {interaction.notes}

\n {interaction.additional_notes_link && (\n

\n 🔗{\" \"}\n \n Notes\n \n

\n )}\n {interaction.tags && (\n

\n {interaction.tags.split(\",\").map(tag => (\n \n {tag.trim()}\n \n ))}\n

\n )}\n

\n \n 📅 {new Date(interaction.interaction_date + \"T00:00:00\").toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n timeZone: Intl.DateTimeFormat().resolvedOptions().timeZone,\n })}\n \n handleDeleteInteraction(interaction.id)}\n title=\"Delete interaction\"\n >\n 🗑️\n \n

\n ))}\n

\n ))}\n\n

\n setCurrentPage(prev => Math.max(prev - 1, 1))}\n disabled={currentPage === 1}\n className=\"pagination-button\"\n >\n Previous\n \n Page {currentPage} of {Math.ceil(totalInteractions / 10)}\n setCurrentPage(prev => prev + 1)}\n disabled={currentPage >= Math.ceil(totalInteractions / 10)}\n className=\"pagination-button\"\n >\n Next\n \n

\n );\n}\n\nfunction App() {\n const [isAuthenticated, setIsAuthenticated] = useState(false);\n const [refreshList, setRefreshList] = useState(0);\n\n useEffect(() => {\n // Check authentication status when component mounts\n checkAuth();\n }, []);\n\n const checkAuth = async () => {\n try {\n const response = await fetch(\"/check-auth\");\n if (response.ok) {\n setIsAuthenticated(true);\n }\n } catch (error) {\n console.error(\"Error checking authentication:\", error);\n }\n };\n\n const handleLogin = () => {\n setIsAuthenticated(true);\n };\n\n const handleLogout = () => {\n setIsAuthenticated(false);\n };\n\n const handleInteractionSubmit = () => {\n setRefreshList(prev => prev + 1);\n };\n\n if (!isAuthenticated) {\n return ;\n }\n\n return (\n

🌽 It's Kernel!

\n \n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"CRM\";\n const SCHEMA_VERSION = 4; // Increment schema version\n\n // Retrieve the admin password from environment variable\n const ADMIN_PASSWORD = Deno.env.get(\"CRM_PWD\") || \"default_fallback_password\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_interactions_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n first_name TEXT NOT NULL,\n last_name TEXT NOT NULL,\n email TEXT NOT NULL,\n interaction_date DATE NOT NULL,\n notes TEXT NOT NULL,\n additional_notes_link TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_tags_${SCHEMA_VERSION} (\n interaction_id INTEGER,\n tag TEXT NOT NULL,\n FOREIGN KEY (interaction_id) REFERENCES ${KEY}_interactions_${SCHEMA_VERSION}(id),\n PRIMARY KEY (interaction_id, tag)\n )\n `);\n\n const isAuthenticated = (request) => {\n const cookie = request.headers.get(\"cookie\");\n if (!cookie) return false;\n\n const authCookie = cookie.split(\";\")\n .find(c => c.trim().startsWith(\"auth=\"));\n if (!authCookie) return false;\n\n const [_, token] = authCookie.split(\"=\");\n // You might want to use a more secure comparison method in production\n return token === ADMIN_PASSWORD;\n };\n\n // New endpoint to get customer details by email\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-customer-details\") {\n const url = new URL(request.url);\n const email = url.searchParams.get(\"email\");\n\n if (!email) {\n return new Response(JSON.stringify(null), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const result = await sqlite.execute(\n `\n SELECT first_name, last_name \n FROM ${KEY}_interactions_${SCHEMA_VERSION} \n WHERE email = ? \n ORDER BY timestamp DESC \n LIMIT 1\n `,\n [email],\n );\n\n return new Response(JSON.stringify(result.rows[0] || null), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-unique-customer-count\") {\n const result = await sqlite.execute(`\n SELECT COUNT(DISTINCT email) as count \n FROM ${KEY}_interactions_${SCHEMA_VERSION}\n `);\n\n return new Response(\n JSON.stringify({ count: result.rows[0].count }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-filtered-count\") {\n const url = new URL(request.url);\n const tags = url.searchParams.get(\"tags\")?.split(\",\") || [];\n\n if (tags.length === 0) {\n return new Response(\n JSON.stringify({ count: 0 }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n // Build a query that counts interactions that have ALL the specified tags\n const placeholders = tags.map(() => \"?\").join(\",\");\n const result = await sqlite.execute(\n `\n WITH tagged_interactions AS (\n SELECT interaction_id\n FROM ${KEY}_tags_${SCHEMA_VERSION}\n WHERE tag IN (${placeholders})\n GROUP BY interaction_id\n HAVING COUNT(DISTINCT tag) = ?\n )\n SELECT COUNT(*) as count\n FROM ${KEY}_interactions_${SCHEMA_VERSION} i\n INNER JOIN tagged_interactions ti ON i.id = ti.interaction_id\n `,\n [...tags, tags.length],\n );\n\n return new Response(\n JSON.stringify({ count: result.rows[0].count }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/login\") {\n const { password } = await request.json();\n if (password === ADMIN_PASSWORD) {\n return new Response(JSON.stringify({ success: true }), {\n headers: {\n \"Content-Type\": \"application/json\",\n // Set cookie to expire in 30 days\n \"Set-Cookie\": `auth=${password}; Path=/; Max-Age=2592000; SameSite=Strict; HttpOnly`,\n },\n });\n } else {\n return new Response(JSON.stringify({ message: \"Incorrect password\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/add-interaction\") {\n if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ message: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n const { firstName, lastName, email, interactionDate, notes, additionalNotesLink, tags = [] } = await request.json();\n\n try {\n // Insert interaction\n const result = await sqlite.execute(\n `INSERT INTO ${KEY}_interactions_${SCHEMA_VERSION} \n (first_name, last_name, email, interaction_date, notes, additional_notes_link) \n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [firstName, lastName, email, interactionDate, notes, additionalNotesLink || null],\n );\n\n const interactionId = result.rows[0].id;\n\n // Insert tags if there are any\n if (tags && tags.length > 0) {\n for (const tag of tags) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_tags_${SCHEMA_VERSION} (interaction_id, tag) VALUES (?, ?)`,\n [interactionId, tag],\n );\n }\n }\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error in add-interaction:\", error);\n return new Response(\n JSON.stringify({\n success: false,\n error: \"Failed to save interaction\",\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-interactions\") {\n if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ message: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n const url = new URL(request.url);\n const page = parseInt(url.searchParams.get(\"page\") || \"1\");\n const limit = 10;\n const offset = (page - 1) * limit;\n\n // First, get the paginated interactions\n const result = await sqlite.execute(\n `\n SELECT i.*, GROUP_CONCAT(t.tag) as tags \n FROM ${KEY}_interactions_${SCHEMA_VERSION} i \n LEFT JOIN ${KEY}_tags_${SCHEMA_VERSION} t ON i.id = t.interaction_id \n GROUP BY i.id\n ORDER BY i.interaction_date DESC, i.timestamp DESC \n LIMIT ? OFFSET ?\n `,\n [limit, offset],\n );\n\n // Second, get the total count of interactions\n const countResult = await sqlite.execute(`\n SELECT COUNT(*) as total FROM ${KEY}_interactions_${SCHEMA_VERSION}\n `);\n\n // Third, get the total count for each tag across ALL interactions\n const tagCountResult = await sqlite.execute(`\n SELECT tag, COUNT(DISTINCT interaction_id) as count\n FROM ${KEY}_tags_${SCHEMA_VERSION}\n GROUP BY tag\n `);\n\n // Convert tag counts array to an object for easier frontend consumption\n const tagCounts = {};\n tagCountResult.rows.forEach(row => {\n tagCounts[row.tag] = row.count;\n });\n\n return new Response(\n JSON.stringify({\n interactions: result.rows,\n total: countResult.rows[0].total,\n tagCounts: tagCounts, // Add this to the response\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (request.method === \"DELETE\" && new URL(request.url).pathname === \"/delete-interaction\") {\n if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ message: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n const { id } = await request.json();\n try {\n // First delete the tags associated with this interaction\n await sqlite.execute(\n `DELETE FROM ${KEY}_tags_${SCHEMA_VERSION} WHERE interaction_id = ?`,\n [id],\n );\n\n // Then delete the interaction\n await sqlite.execute(\n `DELETE FROM ${KEY}_interactions_${SCHEMA_VERSION} WHERE id = ?`,\n [id],\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error deleting interaction:\", error);\n return new Response(\n JSON.stringify({\n success: false,\n error: \"Failed to delete interaction\",\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n return new Response(\n `\n \n \n 🌽 Kernel CRM\n \n \n \n \n \n

\n setEmail(e.target.value)}\n required\n />\n

\n setFirstName(e.target.value)}\n required\n />\n setLastName(e.target.value)}\n required\n />\n

\n {tags.map(tag => (\n \n {tag}\n removeTag(tag, e)}\n className=\"tag-remove\"\n >\n ×\n \n \n ))}\n

\n setTagInput(e.target.value)}\n onKeyDown={handleTagInput}\n className=\"tag-input\"\n />\n

📋 Customer Conversations

\n \n We've spoken to {uniqueCustomerCount} customers 🙂‍↕️\n \n\n {/* Tag Filter Section */}\n

Filter by Tags

\n {selectedTags.length > 0 && (\n setSelectedTags([])}\n className=\"pagination-button\"\n >\n Clear Filters\n \n )}\n

\n\n {/* Display when no results match filters */}\n {Object.keys(customerInteractions).length === 0 && selectedTags.length > 0 && (\n

\n No interactions found with the selected tags.\n

\n )}\n\n {Object.entries(customerInteractions).map(([customerName, interactions]) => (\n

🧑 {customerName}

\n 📧{\" \"}\n \n handleCopyEmail(interactions[0].email)}\n className=\"copyable-email\"\n >\n {interactions[0].email}\n {\" \"}\n {copiedEmail === interactions[0].email && \"✓\"}\n

\n {interactions.map((interaction) => (\n

📝 {interaction.notes}

\n {interaction.additional_notes_link && (\n

\n 🔗{\" \"}\n \n Notes\n \n

\n )}\n {interaction.tags && (\n

\n {interaction.tags.split(\",\").map(tag => (\n \n {tag.trim()}\n \n ))}\n

\n )}\n

\n ))}\n

\n ))}\n\n

🌽 It's Kernel!

\n \n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"CRM\";\n const SCHEMA_VERSION = 4; // Increment schema version\n\n // Retrieve the admin password from environment variable\n const ADMIN_PASSWORD = Deno.env.get(\"CRM_PWD\") || \"default_fallback_password\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_interactions_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n first_name TEXT NOT NULL,\n last_name TEXT NOT NULL,\n email TEXT NOT NULL,\n interaction_date DATE NOT NULL,\n notes TEXT NOT NULL,\n additional_notes_link TEXT,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_tags_${SCHEMA_VERSION} (\n interaction_id INTEGER,\n tag TEXT NOT NULL,\n FOREIGN KEY (interaction_id) REFERENCES ${KEY}_interactions_${SCHEMA_VERSION}(id),\n PRIMARY KEY (interaction_id, tag)\n )\n `);\n\n const isAuthenticated = (request) => {\n const cookie = request.headers.get(\"cookie\");\n if (!cookie) return false;\n\n const authCookie = cookie.split(\";\")\n .find(c => c.trim().startsWith(\"auth=\"));\n if (!authCookie) return false;\n\n const [_, token] = authCookie.split(\"=\");\n // You might want to use a more secure comparison method in production\n return token === ADMIN_PASSWORD;\n };\n\n // New endpoint to get customer details by email\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-customer-details\") {\n const url = new URL(request.url);\n const email = url.searchParams.get(\"email\");\n\n if (!email) {\n return new Response(JSON.stringify(null), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const result = await sqlite.execute(\n `\n SELECT first_name, last_name \n FROM ${KEY}_interactions_${SCHEMA_VERSION} \n WHERE email = ? \n ORDER BY timestamp DESC \n LIMIT 1\n `,\n [email],\n );\n\n return new Response(JSON.stringify(result.rows[0] || null), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-unique-customer-count\") {\n const result = await sqlite.execute(`\n SELECT COUNT(DISTINCT email) as count \n FROM ${KEY}_interactions_${SCHEMA_VERSION}\n `);\n\n return new Response(\n JSON.stringify({ count: result.rows[0].count }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-filtered-count\") {\n const url = new URL(request.url);\n const tags = url.searchParams.get(\"tags\")?.split(\",\") || [];\n\n if (tags.length === 0) {\n return new Response(\n JSON.stringify({ count: 0 }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n // Build a query that counts interactions that have ALL the specified tags\n const placeholders = tags.map(() => \"?\").join(\",\");\n const result = await sqlite.execute(\n `\n WITH tagged_interactions AS (\n SELECT interaction_id\n FROM ${KEY}_tags_${SCHEMA_VERSION}\n WHERE tag IN (${placeholders})\n GROUP BY interaction_id\n HAVING COUNT(DISTINCT tag) = ?\n )\n SELECT COUNT(*) as count\n FROM ${KEY}_interactions_${SCHEMA_VERSION} i\n INNER JOIN tagged_interactions ti ON i.id = ti.interaction_id\n `,\n [...tags, tags.length],\n );\n\n return new Response(\n JSON.stringify({ count: result.rows[0].count }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/login\") {\n const { password } = await request.json();\n if (password === ADMIN_PASSWORD) {\n return new Response(JSON.stringify({ success: true }), {\n headers: {\n \"Content-Type\": \"application/json\",\n // Set cookie to expire in 30 days\n \"Set-Cookie\": `auth=${password}; Path=/; Max-Age=2592000; SameSite=Strict; HttpOnly`,\n },\n });\n } else {\n return new Response(JSON.stringify({ message: \"Incorrect password\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/add-interaction\") {\n const { firstName, lastName, email, interactionDate, notes, additionalNotesLink, tags = [] } = await request.json();\n\n try {\n // Insert interaction\n const result = await sqlite.execute(\n `INSERT INTO ${KEY}_interactions_${SCHEMA_VERSION} \n (first_name, last_name, email, interaction_date, notes, additional_notes_link) \n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [firstName, lastName, email, interactionDate, notes, additionalNotesLink || null],\n );\n\n const interactionId = result.rows[0].id;\n\n // Insert tags if there are any\n if (tags && tags.length > 0) {\n for (const tag of tags) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_tags_${SCHEMA_VERSION} (interaction_id, tag) VALUES (?, ?)`,\n [interactionId, tag],\n );\n }\n }\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error in add-interaction:\", error);\n return new Response(\n JSON.stringify({\n success: false,\n error: \"Failed to save interaction\",\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/get-interactions\") {\n const url = new URL(request.url);\n const page = parseInt(url.searchParams.get(\"page\") || \"1\");\n const limit = 10;\n const offset = (page - 1) * limit;\n\n // First, get the paginated interactions\n const result = await sqlite.execute(\n `\n SELECT i.*, GROUP_CONCAT(t.tag) as tags \n FROM ${KEY}_interactions_${SCHEMA_VERSION} i \n LEFT JOIN ${KEY}_tags_${SCHEMA_VERSION} t ON i.id = t.interaction_id \n GROUP BY i.id\n ORDER BY i.interaction_date DESC, i.timestamp DESC \n LIMIT ? OFFSET ?\n `,\n [limit, offset],\n );\n\n // Second, get the total count of interactions\n const countResult = await sqlite.execute(`\n SELECT COUNT(*) as total FROM ${KEY}_interactions_${SCHEMA_VERSION}\n `);\n\n // Third, get the total count for each tag across ALL interactions\n const tagCountResult = await sqlite.execute(`\n SELECT tag, COUNT(DISTINCT interaction_id) as count\n FROM ${KEY}_tags_${SCHEMA_VERSION}\n GROUP BY tag\n `);\n\n // Convert tag counts array to an object for easier frontend consumption\n const tagCounts = {};\n tagCountResult.rows.forEach(row => {\n tagCounts[row.tag] = row.count;\n });\n\n return new Response(\n JSON.stringify({\n interactions: result.rows,\n total: countResult.rows[0].total,\n tagCounts: tagCounts, // Add this to the response\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (request.method === \"DELETE\" && new URL(request.url).pathname === \"/delete-interaction\") {\n const { id } = await request.json();\n try {\n // First delete the tags associated with this interaction\n await sqlite.execute(\n `DELETE FROM ${KEY}_tags_${SCHEMA_VERSION} WHERE interaction_id = ?`,\n [id],\n );\n\n // Then delete the interaction\n await sqlite.execute(\n `DELETE FROM ${KEY}_interactions_${SCHEMA_VERSION} WHERE id = ?`,\n [id],\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error deleting interaction:\", error);\n return new Response(\n JSON.stringify({\n success: false,\n error: \"Failed to delete interaction\",\n }),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n return new Response(\n `\n \n \n 🌽 Kernel CRM\n \n \n \n \n \n

\n \n \n \n View Source\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif;\n max-width: 600px;\n margin: 0 auto;\n padding: 20px;\n background-color: #1a1a1a;\n color: #e0e0e0;\n}\n\n.login-container {\n display: flex;\n justify-content: center;\n align-items: center;\n height: 100vh;\n background-color: #1a1a1a;\n}\n\n.login-form {\n background-color: #2d2d2d;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.3);\n width: 100%;\n max-width: 350px;\n display: flex;\n flex-direction: column;\n gap: 15px;\n}\n\n.login-form input {\n padding: 10px;\n border: 1px solid #404040;\n border-radius: 4px;\n background-color: #333333;\n color: #e0e0e0;\n}\n\n.login-form button {\n background-color: #0066cc;\n color: white;\n border: none;\n padding: 10px;\n border-radius: 4px;\n cursor: pointer;\n}\n\n.error-message {\n color: #ff6b6b;\n margin: 0;\n text-align: center;\n}\n\n.crm-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 20px;\n}\n\n.crm-container {\n background-color: #2d2d2d;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n padding: 20px;\n}\n\n.interaction-form {\n display: flex;\n flex-direction: column;\n gap: 10px;\n margin-bottom: 20px;\n}\n\n.name-inputs {\n display: flex;\n gap: 10px;\n}\n\n.name-inputs input {\n flex: 1;\n}\n\n.interaction-form input,\n.interaction-form textarea {\n padding: 10px;\n border: 1px solid #404040;\n border-radius: 4px;\n background-color: #333333;\n color: #e0e0e0;\n}\n\n.interaction-form > button {\n background-color: #0066cc;\n color: white;\n border: none;\n padding: 10px;\n border-radius: 4px;\n cursor: pointer;\n}\n\n.interaction-list {\n display: flex;\n flex-direction: column;\n gap: 15px;\n}\n\n.customer-interaction-group {\n background-color: #333333;\n border-radius: 4px;\n padding: 15px;\n border: 1px solid #404040;\n}\n\n.customer-interaction-group h3 {\n margin-top: 0;\n margin-bottom: 10px;\n color: #e0e0e0;\n}\n\n.interaction-card {\n background-color: #2d2d2d;\n border-radius: 4px;\n padding: 10px;\n margin-bottom: 10px;\n box-shadow: 0 2px 4px rgba(0,0,0,0.2);\n}\n\n.interaction-card small {\n color: #a0a0a0;\n display: block;\n margin-top: 5px;\n}\n\n.interaction-card a {\n color: #5c9eff;\n text-decoration: none;\n}\n\n.interaction-card a:hover {\n text-decoration: underline;\n}\n\n.copyable-email {\n cursor: pointer;\n}\n\n.copyable-email:hover {\n text-decoration: underline;\n}\n\n.interaction-footer {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-top: 5px;\n}\n\n.delete-button {\n cursor: pointer;\n}\n\n.pagination-controls {\n display: flex;\n justify-content: center;\n align-items: center;\n gap: 15px;\n margin-top: 20px;\n padding: 10px;\n}\n\n.pagination-button {\n background-color: #404040;\n color: #e0e0e0;\n border: none;\n padding: 8px 16px;\n border-radius: 4px;\n cursor: pointer;\n margin-top: 10px;\n}\n\n.pagination-button:disabled {\n background-color: #333333;\n color: #666666;\n cursor: not-allowed;\n}\n\n.tags-input-container {\n margin: 10px 0;\n}\n\n.tags-list {\n display: flex;\n flex-wrap: wrap;\n gap: 5px;\n margin-bottom: 5px;\n}\n\n.tag-input {\n width: 100%;\n padding: 8px;\n border: 1px solid #404040;\n border-radius: 4px;\n background-color: #333333;\n color: #e0e0e0;\n}\n\n.tag-pill {\n background-color: #404040;\n color: #e0e0e0;\n padding: 4px 12px;\n border-radius: 16px;\n font-size: 14px;\n display: inline-flex;\n align-items: center;\n margin-right: 5px;\n cursor: pointer;\n border: none;\n transition: all 0.2s ease;\n}\n\n.tag-pill:hover {\n background-color: #505050;\n}\n\n.tag-pill.selected {\n background-color: #0066cc;\n color: white;\n}\n\n.tag-pill.selected:hover {\n background-color: #0056b3;\n}\n\n.tag-remove {\n border: none;\n background-color: transparent;\n color: #fff;\n}\n\n.customer-conversations {\n margin: 0;\n}\n`;","createdAt",["D",1737582111303],"branchVersion","branchId","ac81c5ac-27aa-11f0-9edc-569c3dd06744","id","ac81852e-27aa-11f0-9edc-569c3dd06744","CRM",["D",1746227444056],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","dbb6f458-af0e-4422-9aad-3eabc43285a7","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01f2c078-e797-48a0-8730-8efb4e7e899b","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",100,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","juecd","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ya3kyd3VJTE9vOWRJMVhnRVBuVG9xZXZhcEsifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":161,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":162,"_79":163,"_81":164,"_83":25},"tree",[152,153],"files",[152,153],"counts",{"_141":61,"_142":137,"_143":144,"_145":146,"_147":148},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":137,"_129":49,"_38":138,"_13":61,"_33":20,"_35":139,"_24":25,"_132":-5,"_27":140},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"aecb3762-27aa-11f0-9edc-569c3dd06744","parentId","latest",["D",1737582111303],90,"label",[28],"ac849796-27aa-11f0-9edc-569c3dd06744","README.md","ac849818-27aa-11f0-9edc-569c3dd06744",1,["D",1737503122519],"I needed a lightweight CRM to track user conversations. I wanted it to be dead simple to use to reduce the amount of manual data entry I have to do. I also want to use keyboard shortcuts as much as possible.\n\nI had Townie build 70% of this successfully!\n\n==\n- Set your password in your Val.Town environment variables.\n- Command+K within the Notes or Link to Notes field submits the Customer Interaction.",[135],"pulls","branches","forks",2,"envVars",{"_149":61,"_151":61},"connections",{"_149":61,"_150":61},"count","unfilledCount","emptyCount",{"_43":134,"_32":135,"_30":136,"_128":-5,"_41":42,"_40":137,"_129":49,"_38":158,"_13":61,"_33":20,"_35":139,"_24":25,"_132":-5,"_155":159,"_27":160},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":154,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_155":156,"_27":157},["D",1737582111303],"children",[],[28],["D",1737503122519],[],[135],["D",1746227444056],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":198,"_199":200,"_201":202,"_203":25,"_204":25,"_205":25,"_206":49,"_207":-5,"_208":-7,"_209":-7,"_210":61,"_211":25,"_212":25,"_213":-5,"_214":25,"_215":25,"_216":25,"_217":-5},"ENV",{"_169":170,"_171":172,"_173":85,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197},"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"]

👹 Welcome to Kernel CRM

📋 Customer Conversations

Filter by Tags

🧑 {customerName}

🌽 It's Kernel!

👹 Welcome to Kernel CRM

📋 Customer Conversations

Filter by Tags

🧑 {customerName}

🌽 It's Kernel!

Diff · v91