\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 \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 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 \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",1739848170762],"version",1,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","arthrod","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybGdRZzN2TktCS3JGa24za1JPS2pWT1ZyeWgifQ","forkedVal",{"_113":135,"_129":136,"_98":99,"_118":31,"_137":-5},"1aba1938-d99b-11ef-ae41-e6cdfca9ef9f","stevekrouse","prDisabledHint","interval","slug","arthrod/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 90% 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",[145,148],{"_118":119,"_146":-5,"_116":147,"_113":111},"prId",["D",1739848170762],{"_118":31,"_146":-5,"_116":149,"_113":150},["D",1739847911787],"2b254dc4-eda5-11ef-9c0c-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_158":159,"_224":119,"_225":140,"_226":31,"_94":227},"dependenciesList",[160],{"_100":161,"_162":163},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_98":164,"_95":165,"_100":161,"_102":166,"_103":-5,"_104":105,"_106":167,"_108":168,"_110":169,"_112":26,"_113":169,"_114":170,"_116":171,"_118":172,"_120":26,"_121":173,"_123":174,"_124":119,"_125":119,"_122":175,"_126":31,"_127":-5,"_20":176,"_133":178,"_138":-7,"_141":182,"_183":-5,"_139":184,"_143":185},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;",["D",1737987404484],13,10,13376,21,{"_129":136,"_131":177},"https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_113":179,"_129":180,"_98":164,"_118":181,"_137":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std",6,"LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[186,190,194,198,201,205,209,213,216,220],{"_116":187,"_118":172,"_188":189},["D",1737987404484],"n","1",{"_116":191,"_118":192,"_188":193},["D",1724087412304],12,"2",{"_116":195,"_118":196,"_188":197},["D",1724087404512],11,"3",{"_116":199,"_118":173,"_188":200},["D",1723494410142],"4",{"_116":202,"_118":203,"_188":204},["D",1723494389876],9,"5",{"_116":206,"_118":207,"_188":208},["D",1723494345363],8,"6",{"_116":210,"_118":211,"_188":212},["D",1723494323065],7,"7",{"_116":214,"_118":181,"_188":215},["D",1719604370206],"8",{"_116":217,"_118":218,"_188":219},["D",1719604260994],5,"9",{"_116":221,"_118":222,"_188":223},["D",1719604144103],4,"10","dependenciesCount","valname","page",{"_113":111,"_98":99,"_129":130,"_11":96,"_118":119,"_100":101,"_114":115,"_104":105,"_112":26,"_139":140},"routes/_app","actionData","errors"]

👹 Welcome to Kernel CRM

📋 Customer Conversations

Filter by Tags

🧑 {customerName}

🌽 It's Kernel!