\n ${followup.message.replace(/\\n/g, '
')}\n

\n

\n This is an automated follow-up from your operations dashboard.\n

`\n });\n\n // Update follow-up status\n await updateFollowup(id, { \n status: \"sent\",\n completed_at: new Date().toISOString()\n });\n\n // Update client's last contact\n const client = await getClientById(followup.client_id);\n if (client) {\n await updateClient(followup.client_id, {\n last_contact: new Date().toISOString()\n });\n }\n \n return c.json({ \n success: true, \n data: { \n id, \n status: \"sent\", \n sent_to: followup.client_email,\n completed_at: new Date().toISOString()\n } \n });\n } catch (error) {\n console.error(\"Error sending follow-up:\", error);\n return c.json({ success: false, error: \"Failed to send follow-up\" }, 500);\n }\n});\n\n// Process all due follow-ups (automation endpoint)\nfollowups.post(\"/process-due\", async (c) => {\n try {\n const dueFollowups = await getDueFollowups();\n const emailFollowups = dueFollowups.filter(f => f.type === \"email\" && f.status === \"scheduled\");\n \n const results = [];\n \n for (const followup of emailFollowups) {\n try {\n // Send email\n await email({\n to: followup.client_email,\n subject: followup.subject,\n text: followup.message,\n html: `

\n ${followup.message.replace(/\\n/g, '
')}\n

\n

\n This is an automated follow-up from your operations dashboard.\n

`\n });\n\n // Update follow-up status\n await updateFollowup(followup.id, { \n status: \"sent\",\n completed_at: new Date().toISOString()\n });\n\n results.push({\n id: followup.id,\n client_name: followup.client_name,\n subject: followup.subject,\n status: \"sent\"\n });\n } catch (error) {\n console.error(`Error sending follow-up ${followup.id}:`, error);\n results.push({\n id: followup.id,\n client_name: followup.client_name,\n subject: followup.subject,\n status: \"failed\",\n error: error.message\n });\n }\n }\n \n return c.json({ \n success: true, \n data: {\n processed: results.length,\n successful: results.filter(r => r.status === \"sent\").length,\n failed: results.filter(r => r.status === \"failed\").length,\n results\n }\n });\n } catch (error) {\n console.error(\"Error processing due follow-ups:\", error);\n return c.json({ success: false, error: \"Failed to process due follow-ups\" }, 500);\n }\n});\n\n// Mark follow-up as completed (for non-email types)\nfollowups.patch(\"/:id/complete\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const body = await c.req.json();\n \n const updates: Partial = {\n status: \"completed\",\n completed_at: new Date().toISOString()\n };\n\n // Add notes if provided\n if (body.notes) {\n updates.message = body.notes.trim();\n }\n\n const success = await updateFollowup(id, updates);\n \n if (!success) {\n return c.json({ success: false, error: \"Follow-up not found\" }, 404);\n }\n \n return c.json({ success: true, data: { id, ...updates } });\n } catch (error) {\n console.error(\"Error completing follow-up:\", error);\n return c.json({ success: false, error: \"Failed to complete follow-up\" }, 500);\n }\n});\n\nexport default followups;",[],[153,197,213],{"_104":221,"_95":222,"_154":223,"_156":198,"_157":139,"_158":224,"_160":161,"_106":225,"_100":32,"_163":181,"_165":226,"_166":22,"_167":-5,"_168":227,"_98":228},"349f0a16-3f9e-11f0-a252-76b3cceeab13","kpis.ts","349f0aca-3f9e-11f0-a252-76b3cceeab13",9,["D",1748860916860],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getLatestKPIs, getKPIHistory, createKPI } from \"../database/queries.ts\";\nimport type { KPI } from \"../../shared/types.ts\";\n\nconst kpis = new Hono();\n\n// Get latest KPIs\nkpis.get(\"/\", async (c) => {\n try {\n const latestKPIs = await getLatestKPIs();\n return c.json({ success: true, data: latestKPIs });\n } catch (error) {\n console.error(\"Error fetching KPIs:\", error);\n return c.json({ success: false, error: \"Failed to fetch KPIs\" }, 500);\n }\n});\n\n// Get KPI history\nkpis.get(\"/:name/history\", async (c) => {\n try {\n const name = c.req.param(\"name\");\n const days = parseInt(c.req.query(\"days\") || \"30\");\n \n if (days < 1 || days > 365) {\n return c.json({ \n success: false, \n error: \"Days parameter must be between 1 and 365\" \n }, 400);\n }\n\n const history = await getKPIHistory(name, days);\n return c.json({ success: true, data: history });\n } catch (error) {\n console.error(\"Error fetching KPI history:\", error);\n return c.json({ success: false, error: \"Failed to fetch KPI history\" }, 500);\n }\n});\n\n// Create/update KPI\nkpis.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.name || body.value === undefined || body.target === undefined || !body.unit || !body.category) {\n return c.json({ \n success: false, \n error: \"Missing required fields: name, value, target, unit, category\" \n }, 400);\n }\n\n // Validate category\n if (![\"sales\", \"productivity\", \"customer\", \"financial\"].includes(body.category)) {\n return c.json({ \n success: false, \n error: \"Invalid category. Must be: sales, productivity, customer, or financial\" \n }, 400);\n }\n\n // Validate numeric values\n const value = parseFloat(body.value);\n const target = parseFloat(body.target);\n \n if (isNaN(value) || isNaN(target)) {\n return c.json({ \n success: false, \n error: \"Value and target must be valid numbers\" \n }, 400);\n }\n\n const kpiData: Omit = {\n name: body.name.trim(),\n value,\n target,\n unit: body.unit.trim(),\n category: body.category,\n date: body.date || new Date().toISOString().split('T')[0] // Use today if no date provided\n };\n\n const kpiId = await createKPI(kpiData);\n \n return c.json({ \n success: true, \n data: { id: kpiId, ...kpiData } \n }, 201);\n } catch (error) {\n console.error(\"Error creating KPI:\", error);\n return c.json({ success: false, error: \"Failed to create KPI\" }, 500);\n }\n});\n\n// Bulk create KPIs (for daily updates)\nkpis.post(\"/bulk\", async (c) => {\n try {\n const body = await c.req.json();\n \n if (!Array.isArray(body.kpis)) {\n return c.json({ \n success: false, \n error: \"Request body must contain a 'kpis' array\" \n }, 400);\n }\n\n const results = [];\n const errors = [];\n\n for (let i = 0; i < body.kpis.length; i++) {\n const kpi = body.kpis[i];\n \n try {\n // Validate required fields\n if (!kpi.name || kpi.value === undefined || kpi.target === undefined || !kpi.unit || !kpi.category) {\n errors.push({\n index: i,\n error: \"Missing required fields: name, value, target, unit, category\"\n });\n continue;\n }\n\n // Validate category\n if (![\"sales\", \"productivity\", \"customer\", \"financial\"].includes(kpi.category)) {\n errors.push({\n index: i,\n error: \"Invalid category. Must be: sales, productivity, customer, or financial\"\n });\n continue;\n }\n\n // Validate numeric values\n const value = parseFloat(kpi.value);\n const target = parseFloat(kpi.target);\n \n if (isNaN(value) || isNaN(target)) {\n errors.push({\n index: i,\n error: \"Value and target must be valid numbers\"\n });\n continue;\n }\n\n const kpiData: Omit = {\n name: kpi.name.trim(),\n value,\n target,\n unit: kpi.unit.trim(),\n category: kpi.category,\n date: kpi.date || new Date().toISOString().split('T')[0]\n };\n\n const kpiId = await createKPI(kpiData);\n results.push({ id: kpiId, ...kpiData });\n } catch (error) {\n errors.push({\n index: i,\n error: error.message\n });\n }\n }\n \n return c.json({ \n success: errors.length === 0,\n data: {\n created: results.length,\n failed: errors.length,\n results,\n errors\n }\n }, errors.length > 0 ? 207 : 201); // 207 Multi-Status if there are errors\n } catch (error) {\n console.error(\"Error bulk creating KPIs:\", error);\n return c.json({ success: false, error: \"Failed to bulk create KPIs\" }, 500);\n }\n});\n\n// Get KPI summary by category\nkpis.get(\"/summary/:category\", async (c) => {\n try {\n const category = c.req.param(\"category\");\n \n if (![\"sales\", \"productivity\", \"customer\", \"financial\"].includes(category)) {\n return c.json({ \n success: false, \n error: \"Invalid category. Must be: sales, productivity, customer, or financial\" \n }, 400);\n }\n\n const allKPIs = await getLatestKPIs();\n const categoryKPIs = allKPIs.filter(kpi => kpi.category === category);\n \n const summary = {\n category,\n total_kpis: categoryKPIs.length,\n avg_performance: categoryKPIs.length > 0 \n ? Math.round((categoryKPIs.reduce((sum, kpi) => sum + (kpi.value / kpi.target * 100), 0) / categoryKPIs.length) * 10) / 10\n : 0,\n on_target: categoryKPIs.filter(kpi => kpi.value >= kpi.target).length,\n below_target: categoryKPIs.filter(kpi => kpi.value < kpi.target).length,\n kpis: categoryKPIs\n };\n \n return c.json({ success: true, data: summary });\n } catch (error) {\n console.error(\"Error fetching KPI summary:\", error);\n return c.json({ success: false, error: \"Failed to fetch KPI summary\" }, 500);\n }\n});\n\nexport default kpis;",[],[153,197,222],{"_104":230,"_95":231,"_154":232,"_156":198,"_157":139,"_158":233,"_160":161,"_106":234,"_100":32,"_163":181,"_165":235,"_166":22,"_167":-5,"_168":236,"_98":237},"fbaa5a94-3f9d-11f0-811b-76b3cceeab13","staff.ts","fbaa5b66-3f9d-11f0-811b-76b3cceeab13",6,["D",1748860821307],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllStaff, getStaffById, createStaff, updateStaff } from \"../database/queries.ts\";\nimport type { Staff } from \"../../shared/types.ts\";\n\nconst staff = new Hono();\n\n// Get all staff members\nstaff.get(\"/\", async (c) => {\n try {\n const staffMembers = await getAllStaff();\n return c.json({ success: true, data: staffMembers });\n } catch (error) {\n console.error(\"Error fetching staff:\", error);\n return c.json({ success: false, error: \"Failed to fetch staff\" }, 500);\n }\n});\n\n// Get staff member by ID\nstaff.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const staffMember = await getStaffById(id);\n \n if (!staffMember) {\n return c.json({ success: false, error: \"Staff member not found\" }, 404);\n }\n \n return c.json({ success: true, data: staffMember });\n } catch (error) {\n console.error(\"Error fetching staff member:\", error);\n return c.json({ success: false, error: \"Failed to fetch staff member\" }, 500);\n }\n});\n\n// Create new staff member\nstaff.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.name || !body.email || !body.role || !body.department) {\n return c.json({ \n success: false, \n error: \"Missing required fields: name, email, role, department\" \n }, 400);\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.email)) {\n return c.json({ \n success: false, \n error: \"Invalid email format\" \n }, 400);\n }\n\n const staffData: Omit = {\n name: body.name.trim(),\n email: body.email.toLowerCase().trim(),\n role: body.role.trim(),\n department: body.department.trim(),\n active: body.active !== undefined ? Boolean(body.active) : true\n };\n\n const staffId = await createStaff(staffData);\n \n return c.json({ \n success: true, \n data: { id: staffId, ...staffData } \n }, 201);\n } catch (error) {\n console.error(\"Error creating staff member:\", error);\n \n // Handle unique constraint violation for email\n if (error.message?.includes(\"UNIQUE constraint failed\")) {\n return c.json({ \n success: false, \n error: \"Email address already exists\" \n }, 409);\n }\n \n return c.json({ success: false, error: \"Failed to create staff member\" }, 500);\n }\n});\n\n// Update staff member\nstaff.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const body = await c.req.json();\n \n // Remove fields that shouldn't be updated directly\n const { id: _, created_at, ...updates } = body;\n \n // Validate email if provided\n if (updates.email) {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(updates.email)) {\n return c.json({ \n success: false, \n error: \"Invalid email format\" \n }, 400);\n }\n updates.email = updates.email.toLowerCase().trim();\n }\n\n // Trim string fields\n if (updates.name) updates.name = updates.name.trim();\n if (updates.role) updates.role = updates.role.trim();\n if (updates.department) updates.department = updates.department.trim();\n \n // Convert active to boolean if provided\n if (updates.active !== undefined) updates.active = Boolean(updates.active);\n\n const success = await updateStaff(id, updates);\n \n if (!success) {\n return c.json({ success: false, error: \"Staff member not found or no changes made\" }, 404);\n }\n \n return c.json({ success: true, data: { id, ...updates } });\n } catch (error) {\n console.error(\"Error updating staff member:\", error);\n \n // Handle unique constraint violation for email\n if (error.message?.includes(\"UNIQUE constraint failed\")) {\n return c.json({ \n success: false, \n error: \"Email address already exists\" \n }, 409);\n }\n \n return c.json({ success: false, error: \"Failed to update staff member\" }, 500);\n }\n});\n\n// Deactivate staff member (soft delete)\nstaff.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n \n const success = await updateStaff(id, { active: false });\n \n if (!success) {\n return c.json({ success: false, error: \"Staff member not found\" }, 404);\n }\n \n return c.json({ success: true, data: { id, active: false } });\n } catch (error) {\n console.error(\"Error deactivating staff member:\", error);\n return c.json({ success: false, error: \"Failed to deactivate staff member\" }, 500);\n }\n});\n\nexport default staff;",[],[153,197,231],{"_104":239,"_95":240,"_154":241,"_156":198,"_157":139,"_158":199,"_160":161,"_106":242,"_100":32,"_163":181,"_165":243,"_166":22,"_167":-5,"_168":244,"_98":245},"efa836b2-3f9d-11f0-bab9-76b3cceeab13","tasks.ts","efa83770-3f9d-11f0-bab9-76b3cceeab13",["D",1748860801157],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllTasks, getTasksByStaff, createTask, updateTask } from \"../database/queries.ts\";\nimport type { Task } from \"../../shared/types.ts\";\n\nconst tasks = new Hono();\n\n// Get all tasks\ntasks.get(\"/\", async (c) => {\n try {\n const staffId = c.req.query(\"staff_id\");\n const tasks = staffId \n ? await getTasksByStaff(parseInt(staffId))\n : await getAllTasks();\n \n return c.json({ success: true, data: tasks });\n } catch (error) {\n console.error(\"Error fetching tasks:\", error);\n return c.json({ success: false, error: \"Failed to fetch tasks\" }, 500);\n }\n});\n\n// Create new task\ntasks.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n if (!body.title || !body.assigned_to || !body.assigned_by) {\n return c.json({ \n success: false, \n error: \"Missing required fields: title, assigned_to, assigned_by\" \n }, 400);\n }\n\n const taskData: Omit = {\n title: body.title,\n description: body.description || \"\",\n assigned_to: parseInt(body.assigned_to),\n assigned_by: parseInt(body.assigned_by),\n priority: body.priority || \"medium\",\n status: body.status || \"pending\",\n due_date: body.due_date,\n estimated_hours: body.estimated_hours ? parseFloat(body.estimated_hours) : undefined,\n actual_hours: body.actual_hours ? parseFloat(body.actual_hours) : undefined,\n completed_at: body.completed_at\n };\n\n const taskId = await createTask(taskData);\n \n return c.json({ \n success: true, \n data: { id: taskId, ...taskData } \n }, 201);\n } catch (error) {\n console.error(\"Error creating task:\", error);\n return c.json({ success: false, error: \"Failed to create task\" }, 500);\n }\n});\n\n// Update task\ntasks.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const body = await c.req.json();\n \n // Remove fields that shouldn't be updated directly\n const { id: _, created_at, ...updates } = body;\n \n // Convert numeric fields\n if (updates.assigned_to) updates.assigned_to = parseInt(updates.assigned_to);\n if (updates.assigned_by) updates.assigned_by = parseInt(updates.assigned_by);\n if (updates.estimated_hours) updates.estimated_hours = parseFloat(updates.estimated_hours);\n if (updates.actual_hours) updates.actual_hours = parseFloat(updates.actual_hours);\n\n const success = await updateTask(id, updates);\n \n if (!success) {\n return c.json({ success: false, error: \"Task not found or no changes made\" }, 404);\n }\n \n return c.json({ success: true, data: { id, ...updates } });\n } catch (error) {\n console.error(\"Error updating task:\", error);\n return c.json({ success: false, error: \"Failed to update task\" }, 500);\n }\n});\n\n// Update task status (quick endpoint for status changes)\ntasks.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const { status } = await c.req.json();\n \n if (![\"pending\", \"in_progress\", \"completed\", \"cancelled\"].includes(status)) {\n return c.json({ \n success: false, \n error: \"Invalid status. Must be: pending, in_progress, completed, or cancelled\" \n }, 400);\n }\n\n const updates: Partial = { status };\n if (status === \"completed\") {\n updates.completed_at = new Date().toISOString();\n }\n\n const success = await updateTask(id, updates);\n \n if (!success) {\n return c.json({ success: false, error: \"Task not found\" }, 404);\n }\n \n return c.json({ success: true, data: { id, status, completed_at: updates.completed_at } });\n } catch (error) {\n console.error(\"Error updating task status:\", error);\n return c.json({ success: false, error: \"Failed to update task status\" }, 500);\n }\n});\n\nexport default tasks;",[],[153,197,240],[153,197],{"_104":248,"_95":249,"_154":250,"_156":155,"_157":139,"_158":251,"_160":22,"_106":252,"_100":32,"_163":181,"_165":253,"_166":22,"_167":-5,"_168":254,"_98":255},"3edb8054-3f9e-11f0-bc22-76b3cceeab13","index.ts","3edb80fe-3f9e-11f0-bc22-76b3cceeab13",10,["D",1748860934036],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { getDashboardData } from \"./database/queries.ts\";\n\n// Import route modules\nimport tasks from \"./routes/tasks.ts\";\nimport staff from \"./routes/staff.ts\";\nimport clients from \"./routes/clients.ts\";\nimport followups from \"./routes/followups.ts\";\nimport kpis from \"./routes/kpis.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n await runMigrations();\n dbInitialized = true;\n }\n}\n\n// API Routes\napp.route(\"/api/tasks\", tasks);\napp.route(\"/api/staff\", staff);\napp.route(\"/api/clients\", clients);\napp.route(\"/api/followups\", followups);\napp.route(\"/api/kpis\", kpis);\n\n// Dashboard data endpoint\napp.get(\"/api/dashboard\", async (c) => {\n try {\n await initializeDatabase();\n const dashboardData = await getDashboardData();\n return c.json({ success: true, data: dashboardData });\n } catch (error) {\n console.error(\"Error fetching dashboard data:\", error);\n return c.json({ success: false, error: \"Failed to fetch dashboard data\" }, 500);\n }\n});\n\n// Health check endpoint\napp.get(\"/api/health\", (c) => {\n return c.json({ \n success: true, \n data: { \n status: \"healthy\", \n timestamp: new Date().toISOString(),\n database: dbInitialized ? \"initialized\" : \"pending\"\n } \n });\n});\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main application\napp.get(\"/\", async (c) => {\n try {\n await initializeDatabase();\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial dashboard data to avoid extra round-trips\n const dashboardData = await getDashboardData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.html(`\n \n Operations Dashboard - Error\n \n

Error Loading Dashboard

There was an error initializing the operations dashboard.

Error: ${error.message}

Try Again

\n \n \n `, 500);\n }\n});\n\n// Catch-all for SPA routing\napp.get(\"*\", async (c) => {\n try {\n await initializeDatabase();\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial dashboard data\n const dashboardData = await getDashboardData();\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving SPA route:\", error);\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default app;",[],[153,249],[153],{"_104":258,"_95":259,"_154":260,"_156":-5,"_157":139,"_158":261,"_160":161,"_106":262,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":263,"_98":281},"4826f8f0-3f9e-11f0-a252-76b3cceeab13","frontend","ca87641f-8761-4f10-9189-dfb8aeb95af1",11,["D",1748860949630],[264,273],{"_104":265,"_95":266,"_154":267,"_156":260,"_157":139,"_158":261,"_160":161,"_106":268,"_100":32,"_163":269,"_165":270,"_166":22,"_167":-5,"_168":271,"_98":272},"4826ec48-3f9e-11f0-a252-76b3cceeab13","index.html","4826ed10-3f9e-11f0-a252-76b3cceeab13",["D",1748860949630],"file","\n\n\n \n \n Operations Dashboard\n \n \n 📊\">\n \n\n\n

Loading Operations Dashboard...

\n \n \n\n",[],[259,266],{"_104":274,"_95":275,"_154":276,"_156":260,"_157":139,"_158":101,"_160":161,"_106":277,"_100":32,"_163":181,"_165":278,"_166":22,"_167":-5,"_168":279,"_98":280},"4b476eac-3f9e-11f0-a252-76b3cceeab13","index.tsx","4b476f74-3f9e-11f0-a252-76b3cceeab13",["D",1748860954878],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[259,275],[259],{"_104":283,"_95":284,"_154":285,"_156":-5,"_157":139,"_158":286,"_160":161,"_106":287,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":288,"_98":297},"bd3f9f58-3f9d-11f0-aa00-76b3cceeab13","shared","e8f1adae-8c6e-4f0c-a2f2-6e28351fccfc",2,["D",1748860716584],[289],{"_104":290,"_95":291,"_154":292,"_156":285,"_157":139,"_158":286,"_160":161,"_106":293,"_100":32,"_163":181,"_165":294,"_166":22,"_167":-5,"_168":295,"_98":296},"bd3f9120-3f9d-11f0-aa00-76b3cceeab13","types.ts","bd3f91f2-3f9d-11f0-aa00-76b3cceeab13",["D",1748860716584],"// Shared TypeScript types for the operations dashboard\n\nexport interface Staff {\n id: number;\n name: string;\n email: string;\n role: string;\n department: string;\n active: boolean;\n created_at: string;\n}\n\nexport interface Task {\n id: number;\n title: string;\n description: string;\n assigned_to: number;\n assigned_by: number;\n priority: 'low' | 'medium' | 'high' | 'urgent';\n status: 'pending' | 'in_progress' | 'completed' | 'cancelled';\n due_date: string;\n created_at: string;\n completed_at?: string;\n estimated_hours?: number;\n actual_hours?: number;\n}\n\nexport interface Client {\n id: number;\n name: string;\n email: string;\n phone?: string;\n company?: string;\n status: 'active' | 'inactive' | 'prospect';\n last_contact: string;\n next_followup?: string;\n notes?: string;\n created_at: string;\n}\n\nexport interface FollowUp {\n id: number;\n client_id: number;\n type: 'email' | 'call' | 'meeting';\n subject: string;\n message: string;\n scheduled_date: string;\n status: 'scheduled' | 'sent' | 'completed' | 'cancelled';\n created_at: string;\n completed_at?: string;\n}\n\nexport interface KPI {\n id: number;\n name: string;\n value: number;\n target: number;\n unit: string;\n category: 'sales' | 'productivity' | 'customer' | 'financial';\n date: string;\n created_at: string;\n}\n\nexport interface DashboardData {\n tasks: {\n total: number;\n pending: number;\n in_progress: number;\n completed: number;\n overdue: number;\n };\n staff: {\n total: number;\n active: number;\n workload: Array<{\n staff_id: number;\n name: string;\n task_count: number;\n }>;\n };\n clients: {\n total: number;\n active: number;\n prospects: number;\n followups_due: number;\n };\n kpis: Array<{\n name: string;\n value: number;\n target: number;\n percentage: number;\n trend: 'up' | 'down' | 'stable';\n }>;\n}\n\nexport interface TaskWithStaff extends Task {\n assigned_to_name: string;\n assigned_by_name: string;\n}\n\nexport interface ClientWithFollowups extends Client {\n pending_followups: number;\n last_followup_date?: string;\n}\n\nexport interface APIResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[284,291],[284],{"_104":299,"_95":300,"_154":116,"_156":-5,"_157":139,"_158":301,"_160":161,"_106":302,"_100":32,"_163":269,"_165":303,"_166":22,"_167":-5,"_168":304,"_98":305},"b607e0ec-3f9d-11f0-a7e9-76b3cceeab13","README.md",1,["D",1748860704477],"# Operations Dashboard\n\nA comprehensive operations dashboard for small businesses that streamlines staff task assignments, monitors KPIs, and automates client follow-ups.\n\n## Features\n\n### 📋 Task Management\n- Create and assign tasks to staff members\n- Track task progress and completion\n- Priority-based task organization\n- Due date management and notifications\n\n### 📊 KPI Monitoring\n- Real-time dashboard with key metrics\n- Visual charts and graphs\n- Performance tracking over time\n- Customizable KPI targets\n\n### 🤝 Client Follow-up Automation\n- Automated follow-up scheduling\n- Email templates and customization\n- Client interaction history\n- Follow-up status tracking\n\n### 👥 Staff Management\n- Staff member profiles and roles\n- Task assignment and workload tracking\n- Performance metrics per staff member\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── tasks.ts # Task management endpoints\n│ │ ├── staff.ts # Staff management endpoints\n│ │ ├── kpis.ts # KPI tracking endpoints\n│ │ ├── clients.ts # Client management endpoints\n│ │ └── followups.ts # Follow-up automation endpoints\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── Dashboard.tsx # Main dashboard view\n│ │ ├── TaskManager.tsx # Task management interface\n│ │ ├── KPICharts.tsx # KPI visualization\n│ │ ├── StaffPanel.tsx # Staff management\n│ │ └── ClientFollowup.tsx # Client follow-up interface\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The app runs on Val Town with HTTP trigger\n2. Database uses SQLite for data persistence\n3. Frontend uses React with TailwindCSS\n4. Charts powered by Chart.js\n5. Email automation uses Val Town's email service\n\n## Usage\n\n- Access the dashboard at the main URL\n- Create staff members and assign roles\n- Set up KPI targets and tracking\n- Create tasks and assign to staff\n- Configure automated client follow-ups\n- Monitor real-time metrics and performance\n\n## Environment Variables\n\n- `OPENAI_API_KEY` - For AI-powered task suggestions (optional)\n- `EMAIL_FROM` - Default email sender for follow-ups\n\n## API Endpoints\n\n- `GET /api/dashboard` - Dashboard data\n- `GET/POST /api/tasks` - Task management\n- `GET/POST /api/staff` - Staff management\n- `GET/POST /api/kpis` - KPI tracking\n- `GET/POST /api/clients` - Client management\n- `GET/POST /api/followups` - Follow-up automation",[],[300],"files",[151,170,176,185,195,202,211,220,229,238,247,257,264,273,282,289,298],"counts",{"_310":32,"_311":301,"_312":32,"_313":32},"pulls","branches","forks","envVars","contents",[316,319,322,325,328],{"_104":203,"_95":204,"_154":205,"_156":198,"_157":139,"_158":206,"_160":161,"_106":317,"_100":32,"_163":181,"_165":208,"_166":22,"_167":-5,"_98":318},["D",1748860849307],[153,197,204],{"_104":212,"_95":213,"_154":214,"_156":198,"_157":139,"_158":215,"_160":161,"_106":320,"_100":32,"_163":181,"_165":217,"_166":22,"_167":-5,"_98":321},["D",1748860885996],[153,197,213],{"_104":221,"_95":222,"_154":223,"_156":198,"_157":139,"_158":224,"_160":161,"_106":323,"_100":32,"_163":181,"_165":226,"_166":22,"_167":-5,"_98":324},["D",1748860916860],[153,197,222],{"_104":230,"_95":231,"_154":232,"_156":198,"_157":139,"_158":233,"_160":161,"_106":326,"_100":32,"_163":181,"_165":235,"_166":22,"_167":-5,"_98":327},["D",1748860821307],[153,197,231],{"_104":239,"_95":240,"_154":241,"_156":198,"_157":139,"_158":199,"_160":161,"_106":329,"_100":32,"_163":181,"_165":243,"_166":22,"_167":-5,"_98":330},["D",1748860801157],[153,197,240],{"_104":196,"_95":197,"_154":198,"_156":155,"_157":139,"_158":199,"_160":161,"_106":332,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":333},["D",1748860801157],[153,197],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":342,"_149":347,"_306":399,"_269":400,"_314":402,"_413":-5,"_414":22,"_415":-5,"_416":-5,"_417":-5,"_418":419},{"_104":105,"_95":96,"_106":343,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":116,"_117":22,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":344,"_133":345,"_136":346,"_148":22},["D",1748860557871],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_104":139,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[348,381,390,396],{"_104":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_106":162,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":349,"_98":380},[350,359,377],{"_104":171,"_95":172,"_154":173,"_156":155,"_157":139,"_158":159,"_160":161,"_106":174,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":351,"_98":358},[352,355],{"_104":177,"_95":178,"_154":179,"_156":173,"_157":139,"_158":159,"_160":161,"_106":180,"_100":32,"_163":181,"_165":182,"_166":22,"_167":-5,"_168":353,"_98":354},[],[153,172,178],{"_104":186,"_95":187,"_154":188,"_156":173,"_157":139,"_158":189,"_160":161,"_106":190,"_100":32,"_163":181,"_165":191,"_166":22,"_167":-5,"_168":356,"_98":357},[],[153,172,187],[153,172],{"_104":196,"_95":197,"_154":198,"_156":155,"_157":139,"_158":199,"_160":161,"_106":200,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":360,"_98":376},[361,364,367,370,373],{"_104":203,"_95":204,"_154":205,"_156":198,"_157":139,"_158":206,"_160":161,"_106":207,"_100":32,"_163":181,"_165":208,"_166":22,"_167":-5,"_168":362,"_98":363},[],[153,197,204],{"_104":212,"_95":213,"_154":214,"_156":198,"_157":139,"_158":215,"_160":161,"_106":216,"_100":32,"_163":181,"_165":217,"_166":22,"_167":-5,"_168":365,"_98":366},[],[153,197,213],{"_104":221,"_95":222,"_154":223,"_156":198,"_157":139,"_158":224,"_160":161,"_106":225,"_100":32,"_163":181,"_165":226,"_166":22,"_167":-5,"_168":368,"_98":369},[],[153,197,222],{"_104":230,"_95":231,"_154":232,"_156":198,"_157":139,"_158":233,"_160":161,"_106":234,"_100":32,"_163":181,"_165":235,"_166":22,"_167":-5,"_168":371,"_98":372},[],[153,197,231],{"_104":239,"_95":240,"_154":241,"_156":198,"_157":139,"_158":199,"_160":161,"_106":242,"_100":32,"_163":181,"_165":243,"_166":22,"_167":-5,"_168":374,"_98":375},[],[153,197,240],[153,197],{"_104":248,"_95":249,"_154":250,"_156":155,"_157":139,"_158":251,"_160":22,"_106":252,"_100":32,"_163":181,"_165":253,"_166":22,"_167":-5,"_168":378,"_98":379},[],[153,249],[153],{"_104":258,"_95":259,"_154":260,"_156":-5,"_157":139,"_158":261,"_160":161,"_106":262,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":382,"_98":389},[383,386],{"_104":265,"_95":266,"_154":267,"_156":260,"_157":139,"_158":261,"_160":161,"_106":268,"_100":32,"_163":269,"_165":270,"_166":22,"_167":-5,"_168":384,"_98":385},[],[259,266],{"_104":274,"_95":275,"_154":276,"_156":260,"_157":139,"_158":101,"_160":161,"_106":277,"_100":32,"_163":181,"_165":278,"_166":22,"_167":-5,"_168":387,"_98":388},[],[259,275],[259],{"_104":283,"_95":284,"_154":285,"_156":-5,"_157":139,"_158":286,"_160":161,"_106":287,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":391,"_98":395},[392],{"_104":290,"_95":291,"_154":292,"_156":285,"_157":139,"_158":286,"_160":161,"_106":293,"_100":32,"_163":181,"_165":294,"_166":22,"_167":-5,"_168":393,"_98":394},[],[284,291],[284],{"_104":299,"_95":300,"_154":116,"_156":-5,"_157":139,"_158":301,"_160":161,"_106":302,"_100":32,"_163":269,"_165":303,"_166":22,"_167":-5,"_168":397,"_98":398},[],[300],[348,350,352,355,359,361,364,367,370,373,377,381,383,386,390,392,396],{"_104":196,"_95":197,"_154":198,"_156":155,"_157":139,"_158":199,"_160":161,"_106":332,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":401},[153,197],[403,405,407,409,411],{"_104":203,"_95":204,"_154":205,"_156":198,"_157":139,"_158":206,"_160":161,"_106":317,"_100":32,"_163":181,"_165":208,"_166":22,"_167":-5,"_98":404},[153,197,204],{"_104":212,"_95":213,"_154":214,"_156":198,"_157":139,"_158":215,"_160":161,"_106":320,"_100":32,"_163":181,"_165":217,"_166":22,"_167":-5,"_98":406},[153,197,213],{"_104":221,"_95":222,"_154":223,"_156":198,"_157":139,"_158":224,"_160":161,"_106":323,"_100":32,"_163":181,"_165":226,"_166":22,"_167":-5,"_98":408},[153,197,222],{"_104":230,"_95":231,"_154":232,"_156":198,"_157":139,"_158":233,"_160":161,"_106":326,"_100":32,"_163":181,"_165":235,"_166":22,"_167":-5,"_98":410},[153,197,231],{"_104":239,"_95":240,"_154":241,"_156":198,"_157":139,"_158":199,"_160":161,"_106":329,"_100":32,"_163":181,"_165":243,"_166":22,"_167":-5,"_98":412},[153,197,240],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]