\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().toISOString().split(\"T\")[0]);\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().toISOString().split(\"T\")[0]);\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} qualified 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 \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 const data = await response.json();\n setIsAuthenticated(data.authenticated);\n } catch (error) {\n console.error(\"Error checking authentication:\", error);\n setIsAuthenticated(false);\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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n const result = await sqlite.execute(`\n SELECT COUNT(DISTINCT \n SUBSTR(email, INSTR(email, '@') + 1)\n ) as count \n FROM ${KEY}_interactions_${SCHEMA_VERSION}\n WHERE email LIKE '%@%'\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 === \"GET\" && new URL(request.url).pathname === \"/check-auth\") {\n return new Response(\n JSON.stringify({ authenticated: isAuthenticated(request) }),\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({ error: \"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({ error: \"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({ error: \"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 \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 input[type=\"date\"]::-webkit-calendar-picker-indicator {\n filter: invert(1);\n opacity: 0.7;\n cursor: pointer;\n}\n\n.interaction-form input[type=\"date\"]::-webkit-calendar-picker-indicator:hover {\n opacity: 1;\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 margin-top: 10px;\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",1738521177970],"version",99,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","juecd","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ya3kyd3VJTE9vOWRJMVhnRVBuVG9xZXZhcEsifQ","forkedVal","interval","slug","juecd/CRM","description","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. I had Townie build 70% of this successfully! == Set your password in your Val.Town environment variables. Command+K within the Notes or Link to Notes field submits the Customer Interaction.","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,197,201,205,209,213,217,221,225,229,233,237,241,245,249,253,257,261,265,269,273,277,281,285,289,293,297,301,305,309,313,317,321,325,329,333,337,341,345,349,353,357,361,365,369,373,377,381,385,389,393,397,401,405,409,413,417,421,425,429,433,437,441,445,449,453,457,461,465,469,473,477,481,485,489,493,497,501,505,509,513,517,521,525,529,532,535],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1738521177970],{"_118":146,"_143":-5,"_116":147,"_113":148},98,["D",1738114292393],"c54a8718-dde0-11ef-839c-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},97,["D",1737645742081],"d788be78-d99d-11ef-afa1-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},96,["D",1737582881827],"7be731a4-d90b-11ef-a74b-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},95,["D",1737582822314],"586f8398-d90b-11ef-a1f0-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},94,["D",1737582745243],"2a7f114c-d90b-11ef-8baf-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},93,["D",1737582675789],"011a1e00-d90b-11ef-89d3-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},92,["D",1737582443077],"7665cd0e-d90a-11ef-a00c-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},91,["D",1737582356761],"42f05084-d90a-11ef-ad34-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},90,["D",1737582111303],"b0a28b3e-d909-11ef-a29d-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},89,["D",1737581958719],"55b02f4c-d909-11ef-b2db-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},88,["D",1737581487256],"3caccd58-d908-11ef-902f-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},87,["D",1737581356358],"eea77a18-d907-11ef-b8a1-e6cdfca9ef9f",{"_118":194,"_143":-5,"_116":195,"_113":196},86,["D",1737581055243],"3b2cbffc-d907-11ef-8e7d-e6cdfca9ef9f",{"_118":198,"_143":-5,"_116":199,"_113":200},85,["D",1737580769264],"90b81f8a-d906-11ef-97a5-e6cdfca9ef9f",{"_118":202,"_143":-5,"_116":203,"_113":204},84,["D",1737580507808],"f4e0e862-d905-11ef-b4d9-e6cdfca9ef9f",{"_118":206,"_143":-5,"_116":207,"_113":208},83,["D",1737558669627],"1c4eefda-d8d3-11ef-9468-e6cdfca9ef9f",{"_118":210,"_143":-5,"_116":211,"_113":212},82,["D",1737558417239],"85dfaf08-d8d2-11ef-83d3-e6cdfca9ef9f",{"_118":214,"_143":-5,"_116":215,"_113":216},81,["D",1737558096533],"c6b9ba74-d8d1-11ef-ad1e-e6cdfca9ef9f",{"_118":218,"_143":-5,"_116":219,"_113":220},80,["D",1737557857060],"37fb8a42-d8d1-11ef-9e19-e6cdfca9ef9f",{"_118":222,"_143":-5,"_116":223,"_113":224},79,["D",1737557642731],"b83bdb9a-d8d0-11ef-a900-e6cdfca9ef9f",{"_118":226,"_143":-5,"_116":227,"_113":228},78,["D",1737557269484],"d9c228f6-d8cf-11ef-bbd2-e6cdfca9ef9f",{"_118":230,"_143":-5,"_116":231,"_113":232},77,["D",1737557088227],"6dba049e-d8cf-11ef-8bc4-e6cdfca9ef9f",{"_118":234,"_143":-5,"_116":235,"_113":236},76,["D",1737557056113],"5a95cb82-d8cf-11ef-8078-e6cdfca9ef9f",{"_118":238,"_143":-5,"_116":239,"_113":240},75,["D",1737556986488],"3114b9e4-d8cf-11ef-a212-e6cdfca9ef9f",{"_118":242,"_143":-5,"_116":243,"_113":244},74,["D",1737556785313],"b92c6f44-d8ce-11ef-8761-e6cdfca9ef9f",{"_118":246,"_143":-5,"_116":247,"_113":248},73,["D",1737556764128],"ac8af90e-d8ce-11ef-b723-e6cdfca9ef9f",{"_118":250,"_143":-5,"_116":251,"_113":252},72,["D",1737556538126],"25d84e7a-d8ce-11ef-9a91-e6cdfca9ef9f",{"_118":254,"_143":-5,"_116":255,"_113":256},71,["D",1737556402620],"d51248b0-d8cd-11ef-9f3f-e6cdfca9ef9f",{"_118":258,"_143":-5,"_116":259,"_113":260},70,["D",1737556309076],"9d4f07e2-d8cd-11ef-9cfc-e6cdfca9ef9f",{"_118":262,"_143":-5,"_116":263,"_113":264},69,["D",1737556150400],"3ebbd5a2-d8cd-11ef-8ae0-e6cdfca9ef9f",{"_118":266,"_143":-5,"_116":267,"_113":268},68,["D",1737556057538],"0762c8a4-d8cd-11ef-b4bb-e6cdfca9ef9f",{"_118":270,"_143":-5,"_116":271,"_113":272},67,["D",1737554329296],"0145b7b4-d8c9-11ef-8509-e6cdfca9ef9f",{"_118":274,"_143":-5,"_116":275,"_113":276},66,["D",1737554296491],"edb7923a-d8c8-11ef-b1f4-e6cdfca9ef9f",{"_118":278,"_143":-5,"_116":279,"_113":280},65,["D",1737516455514],"d2bed0fe-d870-11ef-92a1-e6cdfca9ef9f",{"_118":282,"_143":-5,"_116":283,"_113":284},64,["D",1737516432874],"c53dbbe8-d870-11ef-8ee8-e6cdfca9ef9f",{"_118":286,"_143":-5,"_116":287,"_113":288},63,["D",1737516278614],"694c1b68-d870-11ef-9fe6-e6cdfca9ef9f",{"_118":290,"_143":-5,"_116":291,"_113":292},62,["D",1737516121994],"0bf0c7f2-d870-11ef-9536-e6cdfca9ef9f",{"_118":294,"_143":-5,"_116":295,"_113":296},61,["D",1737515931408],"9a59e736-d86f-11ef-8b0c-e6cdfca9ef9f",{"_118":298,"_143":-5,"_116":299,"_113":300},60,["D",1737515838634],"630cc884-d86f-11ef-b0c6-e6cdfca9ef9f",{"_118":302,"_143":-5,"_116":303,"_113":304},59,["D",1737515657365],"f700dfa4-d86e-11ef-8cb9-e6cdfca9ef9f",{"_118":306,"_143":-5,"_116":307,"_113":308},58,["D",1737515537913],"afce8244-d86e-11ef-ac3b-e6cdfca9ef9f",{"_118":310,"_143":-5,"_116":311,"_113":312},57,["D",1737515274264],"12a77610-d86e-11ef-8d9a-e6cdfca9ef9f",{"_118":314,"_143":-5,"_116":315,"_113":316},56,["D",1737515064756],"95c8c3d8-d86d-11ef-b8f7-e6cdfca9ef9f",{"_118":318,"_143":-5,"_116":319,"_113":320},55,["D",1737514736064],"d1dd1884-d86c-11ef-abf8-e6cdfca9ef9f",{"_118":322,"_143":-5,"_116":323,"_113":324},54,["D",1737514655447],"a1cfccfe-d86c-11ef-9882-e6cdfca9ef9f",{"_118":326,"_143":-5,"_116":327,"_113":328},53,["D",1737514538951],"5c603b7c-d86c-11ef-ab86-e6cdfca9ef9f",{"_118":330,"_143":-5,"_116":331,"_113":332},52,["D",1737514320272],"da07ea9e-d86b-11ef-8be1-e6cdfca9ef9f",{"_118":334,"_143":-5,"_116":335,"_113":336},51,["D",1737514149260],"741a3566-d86b-11ef-adb4-e6cdfca9ef9f",{"_118":338,"_143":-5,"_116":339,"_113":340},50,["D",1737514025837],"2a89d514-d86b-11ef-bc85-e6cdfca9ef9f",{"_118":342,"_143":-5,"_116":343,"_113":344},49,["D",1737513933655],"f3990c5a-d86a-11ef-a046-e6cdfca9ef9f",{"_118":346,"_143":-5,"_116":347,"_113":348},48,["D",1737513909407],"e522a0f0-d86a-11ef-b677-e6cdfca9ef9f",{"_118":350,"_143":-5,"_116":351,"_113":352},47,["D",1737513851600],"c2ae6e28-d86a-11ef-9d82-e6cdfca9ef9f",{"_118":354,"_143":-5,"_116":355,"_113":356},46,["D",1737513666798],"54882e2a-d86a-11ef-b7e5-e6cdfca9ef9f",{"_118":358,"_143":-5,"_116":359,"_113":360},45,["D",1737512207171],"ee87552c-d866-11ef-8c71-e6cdfca9ef9f",{"_118":362,"_143":-5,"_116":363,"_113":364},44,["D",1737512168146],"d7450bd4-d866-11ef-8393-e6cdfca9ef9f",{"_118":366,"_143":-5,"_116":367,"_113":368},43,["D",1737512108178],"b3862f66-d866-11ef-a322-e6cdfca9ef9f",{"_118":370,"_143":-5,"_116":371,"_113":372},42,["D",1737511913783],"3fa7e472-d866-11ef-8971-e6cdfca9ef9f",{"_118":374,"_143":-5,"_116":375,"_113":376},41,["D",1737511856071],"1d4153c8-d866-11ef-a2d9-e6cdfca9ef9f",{"_118":378,"_143":-5,"_116":379,"_113":380},40,["D",1737511788714],"f51bb08c-d865-11ef-90c9-e6cdfca9ef9f",{"_118":382,"_143":-5,"_116":383,"_113":384},39,["D",1737511055278],"3ff2820e-d864-11ef-ab8b-e6cdfca9ef9f",{"_118":386,"_143":-5,"_116":387,"_113":388},38,["D",1737510111984],"0db3cf98-d862-11ef-8b92-e6cdfca9ef9f",{"_118":390,"_143":-5,"_116":391,"_113":392},37,["D",1737509976095],"bcb464ea-d861-11ef-b900-e6cdfca9ef9f",{"_118":394,"_143":-5,"_116":395,"_113":396},36,["D",1737509761850],"3d00dc92-d861-11ef-a6b2-e6cdfca9ef9f",{"_118":398,"_143":-5,"_116":399,"_113":400},35,["D",1737509712158],"1f620b5c-d861-11ef-97e4-e6cdfca9ef9f",{"_118":402,"_143":-5,"_116":403,"_113":404},34,["D",1737509691492],"131157d6-d861-11ef-80d0-e6cdfca9ef9f",{"_118":406,"_143":-5,"_116":407,"_113":408},33,["D",1737509564355],"c749bef6-d860-11ef-862c-e6cdfca9ef9f",{"_118":410,"_143":-5,"_116":411,"_113":412},32,["D",1737509279910],"1dbe9db6-d860-11ef-8df7-e6cdfca9ef9f",{"_118":414,"_143":-5,"_116":415,"_113":416},31,["D",1737509166767],"da4e874e-d85f-11ef-b7ae-e6cdfca9ef9f",{"_118":418,"_143":-5,"_116":419,"_113":420},30,["D",1737507109417],"100746d2-d85b-11ef-91ef-e6cdfca9ef9f",{"_118":422,"_143":-5,"_116":423,"_113":424},29,["D",1737507030489],"e0fb7eee-d85a-11ef-982f-e6cdfca9ef9f",{"_118":426,"_143":-5,"_116":427,"_113":428},28,["D",1737506936231],"a8cd3e9a-d85a-11ef-9c10-e6cdfca9ef9f",{"_118":430,"_143":-5,"_116":431,"_113":432},27,["D",1737506731310],"2ea8e2fe-d85a-11ef-8cef-e6cdfca9ef9f",{"_118":434,"_143":-5,"_116":435,"_113":436},26,["D",1737506593772],"dcaf5f14-d859-11ef-90b9-e6cdfca9ef9f",{"_118":438,"_143":-5,"_116":439,"_113":440},25,["D",1737506423215],"7705d2d8-d859-11ef-931f-e6cdfca9ef9f",{"_118":442,"_143":-5,"_116":443,"_113":444},24,["D",1737506289292],"2731cdc0-d859-11ef-a7c1-e6cdfca9ef9f",{"_118":446,"_143":-5,"_116":447,"_113":448},23,["D",1737506200588],"f2528edc-d858-11ef-a7c1-e6cdfca9ef9f",{"_118":450,"_143":-5,"_116":451,"_113":452},22,["D",1737506086163],"ae202378-d858-11ef-9efc-e6cdfca9ef9f",{"_118":454,"_143":-5,"_116":455,"_113":456},21,["D",1737505795924],"011fc3fe-d858-11ef-a890-e6cdfca9ef9f",{"_118":458,"_143":-5,"_116":459,"_113":460},20,["D",1737505781294],"f8697354-d857-11ef-a540-e6cdfca9ef9f",{"_118":462,"_143":-5,"_116":463,"_113":464},19,["D",1737505720892],"d4676380-d857-11ef-a890-e6cdfca9ef9f",{"_118":466,"_143":-5,"_116":467,"_113":468},18,["D",1737505599619],"8c1f126c-d857-11ef-91a2-e6cdfca9ef9f",{"_118":470,"_143":-5,"_116":471,"_113":472},17,["D",1737505564933],"7771e98e-d857-11ef-8580-e6cdfca9ef9f",{"_118":474,"_143":-5,"_116":475,"_113":476},16,["D",1737505482699],"466deb26-d857-11ef-a745-e6cdfca9ef9f",{"_118":478,"_143":-5,"_116":479,"_113":480},15,["D",1737505418854],"20600ef0-d857-11ef-9ce6-e6cdfca9ef9f",{"_118":482,"_143":-5,"_116":483,"_113":484},14,["D",1737505142413],"7b9a9c5a-d856-11ef-878f-e6cdfca9ef9f",{"_118":486,"_143":-5,"_116":487,"_113":488},13,["D",1737505109190],"67cc7fcc-d856-11ef-bd38-e6cdfca9ef9f",{"_118":490,"_143":-5,"_116":491,"_113":492},12,["D",1737505045122],"419d97f0-d856-11ef-bedf-e6cdfca9ef9f",{"_118":494,"_143":-5,"_116":495,"_113":496},11,["D",1737505009842],"2c952c24-d856-11ef-9df0-e6cdfca9ef9f",{"_118":498,"_143":-5,"_116":499,"_113":500},10,["D",1737504794591],"ac49a900-d855-11ef-aa5e-e6cdfca9ef9f",{"_118":502,"_143":-5,"_116":503,"_113":504},9,["D",1737504577153],"2aaecd12-d855-11ef-9e88-e6cdfca9ef9f",{"_118":506,"_143":-5,"_116":507,"_113":508},8,["D",1737504156933],"3036a544-d854-11ef-ae90-e6cdfca9ef9f",{"_118":510,"_143":-5,"_116":511,"_113":512},7,["D",1737503878699],"8a6055b6-d853-11ef-b7d5-e6cdfca9ef9f",{"_118":514,"_143":-5,"_116":515,"_113":516},6,["D",1737503819779],"6740bda0-d853-11ef-8fa0-e6cdfca9ef9f",{"_118":518,"_143":-5,"_116":519,"_113":520},5,["D",1737503715238],"28f0c23e-d853-11ef-8e5c-e6cdfca9ef9f",{"_118":522,"_143":-5,"_116":523,"_113":524},4,["D",1737503581139],"d904e548-d852-11ef-b2fc-e6cdfca9ef9f",{"_118":526,"_143":-5,"_116":527,"_113":528},3,["D",1737503520500],"b4ddf074-d852-11ef-9a70-e6cdfca9ef9f",{"_118":90,"_143":-5,"_116":530,"_113":531},["D",1737503422128],"7a3b92a0-d852-11ef-9054-e6cdfca9ef9f",{"_118":125,"_143":-5,"_116":533,"_113":534},["D",1737503278947],"24e42a60-d852-11ef-80aa-e6cdfca9ef9f",{"_118":31,"_143":-5,"_116":536,"_113":537},["D",1737503122519],"c7a7ec10-d851-11ef-8310-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.forks",{"_545":546,"_596":90,"_597":137,"_598":31,"_94":599},"forksList",[547,569],{"_100":548,"_549":550},"1a7d8ec8-d99b-11ef-ae41-e6cdfca9ef9f","initialData",{"_98":99,"_95":551,"_100":548,"_102":-5,"_103":-5,"_104":105,"_106":552,"_108":109,"_110":553,"_112":26,"_113":553,"_114":554,"_116":555,"_118":31,"_120":26,"_121":31,"_123":31,"_124":125,"_126":31,"_122":125,"_127":31,"_128":-5,"_20":556,"_134":559,"_135":-7,"_138":561,"_562":-5,"_136":563,"_140":564},"a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","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 90% 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.","1aba1938-d99b-11ef-ae41-e6cdfca9ef9f","/** @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 {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}

📝 {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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 === \"GET\" && new URL(request.url).pathname === \"/check-auth\") {\n return new Response(\n JSON.stringify({ authenticated: isAuthenticated(request) }),\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({ error: \"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({ error: \"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({ error: \"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 );\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().toISOString().split(\"T\")[0]);\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 {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}

📝 {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

CRM

\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 = new URL(import.meta.url).pathname.split(\"/\").at(-1);\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_TEMPLATE_PASSWORD\") || \"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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 if (!isAuthenticated(request)) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\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 === \"GET\" && new URL(request.url).pathname === \"/check-auth\") {\n return new Response(\n JSON.stringify({ authenticated: isAuthenticated(request) }),\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({ error: \"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({ error: \"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({ error: \"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 CRM\n \n \n \n \n \n

👹 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!

Welcome to Your CRM

📋 Customer Conversations

Filter by Tags

🧑 {customerName}

CRM