Error Loading Dashboard

There was an error loading the dashboard: ${error.message}

Please try again later or contact support.

\n \n \n `\n );\n }\n});\n\n/**\n * Serve the log entry page\n * GET /log\n */\ndashboardController.get('/log', async (c) => {\n try {\n // Get the date from query parameter or use today's date\n const date = c.req.query('date') || formatDate(new Date());\n \n // Serve log entry UI\n return c.html(generateLogPageHTML(date));\n } catch (error) {\n console.error(\"Error serving log page:\", error);\n return c.html(\n html`\n \n \n \n Error\n \n \n \n

Error Loading Log Page

There was an error loading the log page: ${error.message}

Please try again later or contact support.

\n \n \n `\n );\n }\n});\n\n/**\n * Generate the HTML for the main dashboard\n * @param data Object containing dashboard data\n * @returns Dashboard HTML string\n */\nfunction generateDashboardHTML(data: {\n todos: any[];\n metrics: any;\n cumulativeMetrics: any;\n analysis: any;\n focusAreas: string[];\n leadsPipeline: any[];\n}) {\n const { todos, metrics, cumulativeMetrics, analysis, focusAreas, leadsPipeline } = data;\n \n // Calculate days remaining in 20-day sprint\n const startDate = new Date('2025-05-08');\n const currentDate = new Date();\n const daysElapsed = Math.floor((currentDate.getTime() - startDate.getTime()) / (1000 * 60 * 60 * 24));\n const daysRemaining = Math.max(0, 20 - daysElapsed);\n \n return html`\n \n \n \n Contract Hunter Dashboard\n \n \n \n \n

Contract Hunter: 20-Day Mission

\n Days Remaining: ${daysRemaining}\n

\n \n

Coach's Analysis

${analysis.summary || \"No analysis available yet.\"}

\n \n

Focus Areas

${area}
Complete your first daily log to receive focus areas

\n \n

\n Log Today's Progress\n

\n \n

Today's Metrics

${metrics.leads_contacted || 0}

Today's Leads

\n \n

${metrics.responses_received || 0}

Today's Responses

\n \n

${metrics.meetings_scheduled || 0}

Today's Meetings

\n \n

${metrics.proposals_sent || 0}

Today's Proposals

\n \n

Campaign Totals

${cumulativeMetrics.total_leads_contacted || 0}

Total Leads

\n \n

${cumulativeMetrics.total_responses_received || 0}

Total Responses

\n \n

${cumulativeMetrics.total_meetings_scheduled || 0}

Total Meetings

\n \n

${cumulativeMetrics.total_proposals_sent || 0}

Total Proposals

\n \n

Lead Pipeline

\n ${generatePipelineStages(leadsPipeline)}\n

\n \n

Today's Battle Plan

\n${todos.filter(todo => todo.status !== 'completed').length > 0\n ? todos.filter(todo => todo.status !== 'completed').map(todo => html`\n

\n \n

\n ${todo.description}\n

\n ${todo.category} · Priority ${renderPriority(todo.priority)}\n

\n `)\n : html`

No active tasks. Complete your first daily log to receive tasks.

`}\n

\n \n

Recently Completed

\n${todos.filter(todo => todo.status === 'completed').slice(0, 3).length > 0\n ? todos.filter(todo => todo.status === 'completed').slice(0, 3).map(todo => html`\n

\n \n

\n ${todo.description}\n

\n Completed on ${formatDate(new Date(todo.completed_at))}\n

\n `)\n : html`

No completed tasks yet.

`}\n

\n \n \n \n \n `;\n}\n\n/**\n * Generate the HTML for the log entry page\n * @param date The date for the log entry\n * @returns Log entry page HTML string\n */\nfunction generateLogPageHTML(date: string) {\n return html`\n \n \n \n Daily Log Entry\n \n \n \n \n

Daily Log Entry

Date: ${date}

\n \n

What did you accomplish today?

\n \n \n

What challenges did you face?

\n \n \n

How are you feeling about your progress?

\n Mood\n \n

\n \n

\n Hours Worked Today\n \n

\n \n

Progress Metrics

Record your outreach and client acquisition metrics for today

\n \n

\n Leads Contacted\n \n

\n \n

\n Responses Received\n \n

\n \n

\n Meetings Scheduled\n \n

\n \n

\n Proposals Sent\n \n

\n \n

\n Back to Dashboard\n \n

\n \n

Coach's Feedback

\n \n

Next Steps

\n \n

\n Return to Dashboard\n

\n \n \n \n \n `;\n}\n\n/**\n * Generate the HTML for the lead pipeline stages\n * @param leadsPipeline Array of pipeline stages and counts\n * @returns HTML string for pipeline stages\n */\nfunction generatePipelineStages(leadsPipeline: any[]) {\n // Define the stages in order\n const stageOrder = [\n { key: 'new', label: 'New Leads' },\n { key: 'contacted', label: 'Contacted' },\n { key: 'responded', label: 'Responded' },\n { key: 'meeting_scheduled', label: 'Meeting Set' },\n { key: 'proposal_sent', label: 'Proposal Sent' },\n { key: 'negotiating', label: 'Negotiating' },\n { key: 'won', label: 'Won' },\n { key: 'lost', label: 'Lost' }\n ];\n \n // Create a map of counts by stage\n const countsByStage = (leadsPipeline || []).reduce((acc, stage) => {\n acc[stage.status] = stage.count;\n return acc;\n }, {});\n \n // Generate HTML for each stage\nreturn stageOrder.map(stage => html`\n

${stage.label}

${countsByStage[stage.key] || 0}

\n `);\n}\n\n/**\n * Render priority level as a human-readable string\n * @param priority Priority level (1-5)\n * @returns Formatted priority string\n */\nfunction renderPriority(priority: number): string {\n switch (priority) {\n case 1: return \"🔥 CRITICAL\";\n case 2: return \"⚡ High\";\n case 3: return \"⚠️ Medium\";\n case 4: return \"📌 Low\";\n case 5: return \"📝 Backlog\";\n default: return \"Medium\";\n }\n}\n\nexport { dashboardController };\n\n",[],[146,191,198,205],{"_102":214,"_95":215,"_147":216,"_149":199,"_150":136,"_151":217,"_153":117,"_104":218,"_99":152,"_155":175,"_157":219,"_158":27,"_159":-5,"_160":220,"_98":221},"07a8c6e4-2c27-11f0-a538-569c3dd06744","leadController.ts","e4a77560-2c16-11f0-bbcd-569c3dd06744",47,["D",1746720659125],"import { Hono } from 'npm:hono';\nimport { \n addLead, \n getLeads, \n updateLead, \n getLeadsPipeline \n} from '../../database/queries.ts';\n\n// Create a new Hono app for the lead routes\nconst leadController = new Hono();\n\n/**\n * Get all leads, optionally filtered by status\n * GET /api/leads\n * GET /api/leads?status=new\n */\nleadController.get('/', async (c) => {\n try {\n const status = c.req.query('status');\n const leads = await getLeads(status);\n \n return c.json({\n success: true,\n leads\n });\n } catch (error) {\n console.error('Error getting leads:', error);\n return c.json({ \n error: 'Failed to get leads', \n message: error.message \n }, 500);\n }\n});\n\n/**\n * Get lead pipeline summary\n * GET /api/leads/pipeline\n */\nleadController.get('/pipeline', async (c) => {\n try {\n const pipeline = await getLeadsPipeline();\n \n return c.json({\n success: true,\n pipeline\n });\n } catch (error) {\n console.error('Error getting lead pipeline:', error);\n return c.json({ \n error: 'Failed to get lead pipeline', \n message: error.message \n }, 500);\n }\n});\n\n/**\n * Create a new lead\n * POST /api/leads\n */\nleadController.post('/', async (c) => {\n try {\n const leadData = await c.req.json();\n \n // Validate required fields\n if (!leadData.name) {\n return c.json({ \n error: 'Lead name is required' \n }, 400);\n }\n \n // Set default values for optional fields\n const lead = {\n name: leadData.name,\n company: leadData.company,\n position: leadData.position,\n email: leadData.email,\n phone: leadData.phone,\n source: leadData.source,\n status: leadData.status || 'new',\n notes: leadData.notes\n };\n \n // Create the lead\n const result = await addLead(lead);\n \n // Return success response\n return c.json({\n success: true,\n id: result.id,\n lead\n }, 201);\n } catch (error) {\n console.error('Error creating lead:', error);\n return c.json({ \n error: 'Failed to create lead', \n message: error.message \n }, 500);\n }\n});\n\n/**\n * Update an existing lead\n * PUT /api/leads/:id\n */\nleadController.put('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n const leadData = await c.req.json();\n \n // Validate ID\n if (isNaN(id)) {\n return c.json({ \n error: 'Invalid lead ID' \n }, 400);\n }\n \n // Prepare update data\n const updates = {\n name: leadData.name,\n company: leadData.company,\n position: leadData.position,\n email: leadData.email,\n phone: leadData.phone,\n source: leadData.source,\n status: leadData.status,\n last_contact_date: leadData.last_contact_date || (leadData.status ? new Date().toISOString() : undefined),\n notes: leadData.notes\n };\n \n // Update the lead\n const result = await updateLead(id, updates);\n \n // Return success response\n return c.json({\n success: result.success,\n id,\n message: result.success ? 'Lead updated successfully' : result.message\n });\n } catch (error) {\n console.error('Error updating lead:', error);\n return c.json({ \n error: 'Failed to update lead', \n message: error.message \n }, 500);\n }\n});\n\nexport { leadController };\n",[],[146,191,198,215],{"_102":223,"_95":224,"_147":225,"_149":199,"_150":136,"_151":226,"_153":117,"_104":227,"_99":228,"_155":175,"_157":229,"_158":27,"_159":-5,"_160":230,"_98":231},"079e5c36-2c27-11f0-a062-569c3dd06744","logEntryController.ts","caa40f02-2c16-11f0-825c-569c3dd06744",45,["D",1746720659122],3,"import { Hono } from 'npm:hono';\nimport { processLogEntry } from '../../ai/analysis.ts';\nimport { \n storeDailyLog, \n updateProgressMetrics, \n storeInteraction,\n updateTodo\n} from '../../database/queries.ts';\nimport { formatDate } from '../../utils/email.ts';\n\n// Create a new Hono app for the log entry routes\nconst logEntryController = new Hono();\n\n/**\n * Handle daily log entries\n * POST /api/log\n */\nlogEntryController.post('/', async (c) => {\n try {\n // Parse request body\n const content = await c.req.json();\n const logType = content.logType || 'daily'; // Default to daily log\n \n switch(logType) {\n case 'daily':\n return await handleDailyLog(content);\n case 'progress':\n return await handleProgressMetrics(content);\n case 'todo':\n return await handleTodoUpdate(content);\n default:\n return c.json({ error: 'Invalid log type' }, 400);\n }\n } catch (error) {\n console.error('Error handling log entry:', error);\n return c.json({ \n error: 'Failed to process log entry', \n message: error.message \n }, 500);\n }\n});\n\n/**\n * Handle a daily log entry\n * @param content Log entry content\n * @returns Response with feedback\n */\nasync function handleDailyLog(content) {\n try {\n // Prepare log data\n const log = {\n log_date: content.log_date || formatDate(new Date()),\n achievements: content.achievements || '',\n challenges: content.challenges || '',\n mood: content.mood || 3,\n hours_worked: content.hours_worked || 0\n };\n \n // Store the log entry\n await storeDailyLog(log);\n \n // Update progress metrics if included\n if (content.metrics) {\n await updateProgressMetrics({\n metric_date: log.log_date,\n ...content.metrics\n });\n }\n \n // Process entry with AI for analysis\n const analysis = await processLogEntry(content);\n \n // Store the interaction\n await storeInteraction(\n JSON.stringify(content), \n JSON.stringify(analysis), \n 'AI Coach'\n );\n \n // Return immediate feedback\n return new Response(JSON.stringify({\n success: true,\n log_date: log.log_date,\n analysis\n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Error handling daily log:', error);\n return new Response(JSON.stringify({ \n error: 'Failed to process daily log', \n message: error.message \n }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n}\n\n/**\n * Handle a progress metrics update\n * @param content Metrics content\n * @returns Response with status\n */\nasync function handleProgressMetrics(content) {\n try {\n // Prepare metrics data\n const metrics = {\n metric_date: content.metric_date || formatDate(new Date()),\n leads_contacted: content.leads_contacted,\n responses_received: content.responses_received,\n meetings_scheduled: content.meetings_scheduled,\n proposals_sent: content.proposals_sent\n };\n \n // Update the metrics\n const result = await updateProgressMetrics(metrics);\n \n // Return success response\n return new Response(JSON.stringify({\n success: true,\n updated: result.updated,\n metric_date: metrics.metric_date\n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Error handling metrics update:', error);\n return new Response(JSON.stringify({ \n error: 'Failed to update metrics', \n message: error.message \n }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n}\n\n/**\n * Handle a todo update\n * @param content Todo update content\n * @returns Response with status\n */\nasync function handleTodoUpdate(content) {\n try {\n // Validate required fields\n if (!content.id) {\n return new Response(JSON.stringify({ \n error: 'Todo ID is required' \n }), { \n status: 400,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n // Prepare update data\n const updates: {\n status?: string;\n description?: string;\n category?: string;\n priority?: number;\n due_date?: string;\n notes?: string;\n completed_at?: string;\n } = {\n status: content.status,\n description: content.description,\n category: content.category,\n priority: content.priority,\n notes: content.notes\n };\n \n // If marking as completed, add completion timestamp\n if (updates.status === 'completed') {\n updates.completed_at = new Date().toISOString();\n }\n \n // Update the todo\n const result = await updateTodo(content.id, updates);\n \n // Return success response\n return new Response(JSON.stringify({\n success: result.success,\n id: content.id,\n message: result.success ? 'Todo updated successfully' : result.message\n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Error handling todo update:', error);\n return new Response(JSON.stringify({ \n error: 'Failed to update todo', \n message: error.message \n }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n}\n\nexport { logEntryController };\n",[],[146,191,198,224],{"_102":233,"_95":234,"_147":235,"_149":199,"_150":136,"_151":236,"_153":117,"_104":237,"_99":152,"_155":175,"_157":238,"_158":27,"_159":-5,"_160":239,"_98":240},"07762d9c-2c27-11f0-a735-569c3dd06744","todoController.ts","d8956c1e-2c16-11f0-9fbf-569c3dd06744",43,["D",1746720658893],"import { Hono } from 'npm:hono';\nimport { createTodo, getTodos, updateTodo } from '../../database/queries.ts';\n\n// Create a new Hono app for the todo routes\nconst todoController = new Hono();\n\n/**\n * Get all todos, optionally filtered by status\n * GET /api/todos\n * GET /api/todos?status=pending\n */\ntodoController.get('/', async (c) => {\n try {\n const status = c.req.query('status');\n const todos = await getTodos(status);\n \n return c.json({\n success: true,\n todos\n });\n } catch (error) {\n console.error('Error getting todos:', error);\n return c.json({ \n error: 'Failed to get todos', \n message: error.message \n }, 500);\n }\n});\n\n/**\n * Create a new todo\n * POST /api/todos\n */\ntodoController.post('/', async (c) => {\n try {\n const todoData = await c.req.json();\n \n // Validate required fields\n if (!todoData.description || !todoData.category) {\n return c.json({ \n error: 'Description and category are required' \n }, 400);\n }\n \n // Set default values for optional fields\n const todo = {\n description: todoData.description,\n category: todoData.category,\n status: todoData.status || 'pending',\n priority: todoData.priority || 3,\n due_date: todoData.due_date,\n notes: todoData.notes\n };\n \n // Create the todo\n const result = await createTodo(todo);\n \n // Return success response\n return c.json({\n success: true,\n id: result.id,\n todo\n }, 201);\n } catch (error) {\n console.error('Error creating todo:', error);\n return c.json({ \n error: 'Failed to create todo', \n message: error.message \n }, 500);\n }\n});\n\n/**\n * Update an existing todo\n * PUT /api/todos/:id\n */\ntodoController.put('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n const todoData = await c.req.json();\n \n // Validate ID\n if (isNaN(id)) {\n return c.json({ \n error: 'Invalid todo ID' \n }, 400);\n }\n \n // Prepare update data\n const updates: {\n description?: string;\n category?: string;\n status?: string;\n priority?: number;\n due_date?: string;\n notes?: string;\n completed_at?: string;\n } = {\n description: todoData.description,\n category: todoData.category,\n status: todoData.status,\n priority: todoData.priority,\n due_date: todoData.due_date,\n notes: todoData.notes\n };\n \n // If marking as completed, add completion timestamp\n if (updates.status === 'completed') {\n updates.completed_at = new Date().toISOString();\n }\n \n // Update the todo\n const result = await updateTodo(id, updates);\n \n // Return success response\n return c.json({\n success: result.success,\n id,\n message: result.success ? 'Todo updated successfully' : result.message\n });\n } catch (error) {\n console.error('Error updating todo:', error);\n return c.json({ \n error: 'Failed to update todo', \n message: error.message \n }, 500);\n }\n});\n\nexport { todoController };\n",[],[146,191,198,234],[146,191,198],{"_102":243,"_95":244,"_147":245,"_149":192,"_150":136,"_151":246,"_153":117,"_104":247,"_99":228,"_155":175,"_157":248,"_158":27,"_159":-5,"_160":249,"_98":250},"9e350392-2c28-11f0-bd1e-569c3dd06744","app.ts","baa89578-2c16-11f0-aa90-569c3dd06744",56,["D",1746721341298],"import { Hono } from 'npm:hono';\nimport { logger } from 'npm:hono/logger';\nimport { cors } from 'npm:hono/cors';\nimport { prettyJSON } from 'npm:hono/pretty-json';\n\nimport { initializeDatabase } from '../database/migrations.ts'; // Import initializeDatabase\nimport { logEntryController } from './controllers/logEntryController.ts';\nimport { todoController } from './controllers/todoController.ts';\nimport { leadController } from './controllers/leadController.ts';\nimport { dashboardController } from './controllers/dashboardController.ts';\n\n// Create the main Hono application\nconst app = new Hono();\n\n// Initialize the database on application start\ninitializeDatabase().catch(console.error);\n\n// Add global middleware\napp.use('*', logger());\napp.use('*', cors());\napp.use('*', prettyJSON());\n\n// Mount controllers\napp.route('/api/log', logEntryController);\napp.route('/api/todos', todoController);\napp.route('/api/leads', leadController);\napp.route('/', dashboardController);\n\n// Error handling middleware\napp.onError((err, c) => {\n console.error('Application error:', err);\n return c.json({\n success: false,\n error: 'Internal server error',\n message: err.message\n }, 500);\n});\n\nexport { app };\n",[],[146,191,244],{"_102":252,"_95":253,"_147":254,"_149":192,"_150":136,"_151":119,"_153":117,"_104":255,"_99":152,"_155":256,"_157":257,"_158":27,"_159":-5,"_160":258,"_98":259},"2410f9a0-2c27-11f0-a031-569c3dd06744","index.ts","1ebae930-2c17-11f0-a3e0-569c3dd06744",["D",1746720706878],"http","import {app} from './app.ts'\n\n/**\n * Main entry point for the CareerCoach20Day application\n * Serves the Hono application with routes for dashboard, logs, todos, and leads\n */\nexport default app.fetch\n",[],[146,191,253],[146,191],{"_102":262,"_95":263,"_147":264,"_149":148,"_150":136,"_151":228,"_153":117,"_104":265,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":266,"_98":285},"2adc13c6-2c10-11f0-a090-569c3dd06744","database","2adc148e-2c10-11f0-a090-569c3dd06744",["D",1746710839858],[267,276],{"_102":268,"_95":269,"_147":270,"_149":264,"_150":136,"_151":271,"_153":117,"_104":272,"_99":152,"_155":175,"_157":273,"_158":27,"_159":-5,"_160":274,"_98":275},"ff40e382-2c27-11f0-a963-569c3dd06744","migrations.ts","357d9ec6-2c10-11f0-8e9b-569c3dd06744",52,["D",1746721074617],"import {sqlite} from \"https://esm.town/v/stevekrouse/sqlite\"\n\n/**\n * Initialize the database schema for the Career Coach application\n * Creates all required tables if they don't already exist\n */\nexport async function initializeDatabase() {\n // Generate a unique key based on this file's path to avoid collisions\n const KEY = 'careerCoach'\n console.log({KEY})\n\n // Create interactions table - stores conversations between user and coach\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_interactions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp TEXT NOT NULL,\n user_input TEXT NOT NULL,\n coach_response TEXT NOT NULL,\n model_used TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `)\n\n // Create todos table - stores action items with categories and status\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n description TEXT NOT NULL,\n category TEXT NOT NULL, \n status TEXT NOT NULL,\n priority INTEGER NOT NULL,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n completed_at TEXT,\n due_date TEXT,\n notes TEXT\n )\n `)\n\n // Create daily_logs table - stores daily progress and reflections\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_daily_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n log_date TEXT NOT NULL UNIQUE,\n achievements TEXT NOT NULL,\n challenges TEXT NOT NULL,\n mood INTEGER NOT NULL,\n hours_worked INTEGER NOT NULL,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `)\n\n // Create progress_metrics table - stores quantitative progress data\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_progress_metrics (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n metric_date TEXT NOT NULL UNIQUE,\n leads_contacted INTEGER DEFAULT 0,\n responses_received INTEGER DEFAULT 0,\n meetings_scheduled INTEGER DEFAULT 0,\n proposals_sent INTEGER DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `)\n\n // Create coach_analysis table - stores AI coach insights and recommendations\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_coach_analysis (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n analysis_date TEXT NOT NULL UNIQUE,\n analysis_type TEXT NOT NULL,\n summary TEXT NOT NULL,\n focus_areas TEXT NOT NULL,\n recommendations TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `)\n\n // Create leads table - stores potential client information\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_leads (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n company TEXT,\n position TEXT,\n email TEXT,\n phone TEXT,\n source TEXT,\n status TEXT NOT NULL DEFAULT 'new',\n last_contact_date TEXT,\n notes TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `)\n\n console.log(\"Database schema initialized successfully\")\n return \"Database schema initialized successfully\"\n}\n\n// Run the initialization\nawait initializeDatabase()\n",[],[146,263,269],{"_102":277,"_95":278,"_147":279,"_149":264,"_150":136,"_151":280,"_153":117,"_104":281,"_99":209,"_155":175,"_157":282,"_158":27,"_159":-5,"_160":283,"_98":284},"9e11670c-2c28-11f0-9b76-569c3dd06744","queries.ts","4e5b6fea-2c10-11f0-bc42-569c3dd06744",54,["D",1746721341065],"import {sqlite} from \"https://esm.town/v/stevekrouse/sqlite\"\n\n// Generate a unique key based on this file's path to avoid collisions\nconst KEY = 'careerCoach'\n\n/**\n * Database helper functions for the Career Coach application\n * These functions handle all database interactions for the application\n */\n\n// === INTERACTIONS ===\n\n/**\n * Store a new interaction between the user and coach\n */\nexport async function storeInteraction(userInput: string, coachResponse: string, modelUsed: string) {\n const timestamp = new Date().toISOString()\n await sqlite.execute(`\n INSERT INTO ${KEY}_interactions (timestamp, user_input, coach_response, model_used)\n VALUES (?, ?, ?, ?)\n `, [timestamp, userInput, coachResponse, modelUsed])\n\n return {success: true, timestamp}\n}\n\n/**\n * Get recent interactions, limited by count\n */\nexport async function getRecentInteractions(limit: number = 5) {\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_interactions\n ORDER BY timestamp DESC\n LIMIT ?\n `, [limit])\n\n return result.rows\n}\n\n// === TODOS ===\n\n/**\n * Create a new todo item\n */\nexport async function createTodo(todo: {\n description: string\n category: string\n status: string\n priority: number\n due_date?: string\n notes?: string\n}) {\n const {description, category, status, priority, due_date, notes} = todo\n\n const result = await sqlite.execute(`\n INSERT INTO ${KEY}_todos (description, category, status, priority, due_date, notes)\n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING id\n `, [description, category, status, priority, due_date || null, notes || null])\n\n return {success: true, id: result.rows[0].id}\n}\n\n/**\n * Get all todos, optionally filtered by status\n */\nexport async function getTodos(status?: string) {\n let query = `SELECT * FROM ${KEY}_todos`\n let params: any[] = []\n\n if (status) {\n query += ` WHERE status = ?`\n params.push(status)\n }\n\n query += ` ORDER BY priority ASC, created_at DESC`\n\n const result = await sqlite.execute(query, params)\n return result.rows\n}\n\n/**\n * Update a todo item\n */\nexport async function updateTodo(id: number, updates: {\n description?: string\n category?: string\n status?: string\n priority?: number\n due_date?: string\n notes?: string\n completed_at?: string\n}) {\n // Build the SET part of the query dynamically based on provided updates\n const updateFields = Object.entries(updates)\n .filter(([_, value]) => value !== undefined)\n .map(([key, _]) => `${key} = ?`)\n\n const updateValues = Object.entries(updates)\n .filter(([_, value]) => value !== undefined)\n .map(([_, value]) => value)\n\n // If no valid updates, return early\n if (updateFields.length === 0) {\n return {success: false, message: \"No valid updates provided\"}\n }\n\n // Complete the query\n const query = `\n UPDATE ${KEY}_todos\n SET ${updateFields.join(', ')}\n WHERE id = ?\n `\n\n // Execute the query with the update values and the id\n await sqlite.execute(query, [...updateValues, id])\n\n return {success: true}\n}\n\n/**\n * Get recently completed todos\n */\nexport async function getRecentCompletedTasks(limit: number = 5) {\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_todos\n WHERE status = 'completed'\n ORDER BY completed_at DESC\n LIMIT ?\n `, [limit])\n\n return result.rows\n}\n\n// === DAILY LOGS ===\n\n/**\n * Store a new daily log\n */\nexport async function storeDailyLog(log: {\n log_date: string\n achievements: string\n challenges: string\n mood: number\n hours_worked: number\n}) {\n const {log_date, achievements, challenges, mood, hours_worked} = log\n\n // Check if a log for this date already exists\n const existingLog = await sqlite.execute(`\n SELECT id FROM ${KEY}_daily_logs WHERE log_date = ?\n `, [log_date])\n\n if (existingLog.rows.length > 0) {\n // Update existing log\n await sqlite.execute(`\n UPDATE ${KEY}_daily_logs\n SET achievements = ?, challenges = ?, mood = ?, hours_worked = ?\n WHERE log_date = ?\n `, [achievements, challenges, mood, hours_worked, log_date])\n\n return {success: true, updated: true, id: existingLog.rows[0].id}\n } else {\n // Create new log\n const result = await sqlite.execute(`\n INSERT INTO ${KEY}_daily_logs (log_date, achievements, challenges, mood, hours_worked)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id\n `, [log_date, achievements, challenges, mood, hours_worked])\n\n return {success: true, updated: false, id: result.rows[0].id}\n }\n}\n\n/**\n * Get recent daily logs\n */\nexport async function getRecentLogs(limit: number = 5) {\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_daily_logs\n ORDER BY log_date DESC\n LIMIT ?\n `, [limit])\n\n return result.rows\n}\n\n// === PROGRESS METRICS ===\n\n/**\n * Update progress metrics for a specific date\n */\nexport async function updateProgressMetrics(metrics: {\n metric_date: string\n leads_contacted?: number\n responses_received?: number\n meetings_scheduled?: number\n proposals_sent?: number\n}) {\n const {metric_date, leads_contacted, responses_received, meetings_scheduled, proposals_sent} = metrics\n\n // Check if metrics for this date already exist\n const existingMetrics = await sqlite.execute(`\n SELECT * FROM ${KEY}_progress_metrics WHERE metric_date = ?\n `, [metric_date])\n\n if (existingMetrics.rows.length > 0) {\n // Update existing metrics\n const current = existingMetrics.rows[0]\n\n await sqlite.execute(`\n UPDATE ${KEY}_progress_metrics\n SET \n leads_contacted = ?,\n responses_received = ?,\n meetings_scheduled = ?,\n proposals_sent = ?\n WHERE metric_date = ?\n `, [\n leads_contacted ?? Number(current.leads_contacted),\n responses_received ?? Number(current.responses_received),\n meetings_scheduled ?? Number(current.meetings_scheduled),\n proposals_sent ?? Number(current.proposals_sent),\n metric_date\n ])\n\n return {success: true, updated: true}\n } else {\n // Create new metrics entry\n await sqlite.execute(`\n INSERT INTO ${KEY}_progress_metrics \n (metric_date, leads_contacted, responses_received, meetings_scheduled, proposals_sent)\n VALUES (?, ?, ?, ?, ?)\n `, [\n metric_date,\n leads_contacted ?? 0,\n responses_received ?? 0,\n meetings_scheduled ?? 0,\n proposals_sent ?? 0\n ])\n\n return {success: true, updated: false}\n }\n}\n\n/**\n * Get the latest progress metrics\n */\nexport async function getProgressMetrics() {\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_progress_metrics\n ORDER BY metric_date DESC\n LIMIT 1\n `)\n\n if (result.rows.length === 0) {\n // Return default empty metrics if none exist\n return {\n leads_contacted: 0,\n responses_received: 0,\n meetings_scheduled: 0,\n proposals_sent: 0\n }\n }\n\n return result.rows[0]\n}\n\n/**\n * Get cumulative progress metrics\n */\nexport async function getCumulativeMetrics() {\n const result = await sqlite.execute(`\n SELECT \n SUM(leads_contacted) as total_leads_contacted,\n SUM(responses_received) as total_responses_received,\n SUM(meetings_scheduled) as total_meetings_scheduled,\n SUM(proposals_sent) as total_proposals_sent\n FROM ${KEY}_progress_metrics\n `)\n\n return result.rows[0]\n}\n\n// === COACH ANALYSIS ===\n\n/**\n * Store a new coach analysis\n */\nexport async function storeAnalysis(analysis: {\n analysis_date: string\n analysis_type: string\n summary: string\n focus_areas: string\n recommendations: string\n}) {\n const {analysis_date, analysis_type, summary, focus_areas, recommendations} = analysis\n\n // Check if analysis for this date already exists\n const existingAnalysis = await sqlite.execute(`\n SELECT id FROM ${KEY}_coach_analysis \n WHERE analysis_date = ? AND analysis_type = ?\n `, [analysis_date, analysis_type])\n\n if (existingAnalysis.rows.length > 0) {\n // Update existing analysis\n await sqlite.execute(`\n UPDATE ${KEY}_coach_analysis\n SET summary = ?, focus_areas = ?, recommendations = ?\n WHERE analysis_date = ? AND analysis_type = ?\n `, [summary, focus_areas, recommendations, analysis_date, analysis_type])\n\n return {success: true, updated: true, id: existingAnalysis.rows[0].id}\n } else {\n // Create new analysis\n const result = await sqlite.execute(`\n INSERT INTO ${KEY}_coach_analysis \n (analysis_date, analysis_type, summary, focus_areas, recommendations)\n VALUES (?, ?, ?, ?, ?)\n RETURNING id\n `, [analysis_date, analysis_type, summary, focus_areas, recommendations])\n\n return {success: true, updated: false, id: result.rows[0].id}\n }\n}\n\n/**\n * Get the latest analysis\n */\nexport async function getLatestAnalysis() {\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_coach_analysis\n ORDER BY analysis_date DESC, created_at DESC\n LIMIT 1\n `)\n\n if (result.rows.length === 0) {\n // Return default empty analysis if none exists\n return {\n summary: \"No analysis available yet. Complete your first daily log to receive personalized guidance.\",\n focus_areas: \"[]\",\n recommendations: \"[]\"\n }\n }\n\n return result.rows[0]\n}\n\n// === LEADS ===\n\n/**\n * Add a new lead\n */\nexport async function addLead(lead: {\n name: string\n company?: string\n position?: string\n email?: string\n phone?: string\n source?: string\n status?: string\n notes?: string\n}) {\n const {name, company, position, email, phone, source, status, notes} = lead\n\n const result = await sqlite.execute(`\n INSERT INTO ${KEY}_leads \n (name, company, position, email, phone, source, status, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id\n `, [\n name,\n company || null,\n position || null,\n email || null,\n phone || null,\n source || null,\n status || 'new',\n notes || null\n ])\n\n return {success: true, id: result.rows[0].id}\n}\n\n/**\n * Get all leads, optionally filtered by status\n */\nexport async function getLeads(status?: string) {\n let query = `SELECT * FROM ${KEY}_leads`\n let params: any[] = []\n\n if (status) {\n query += ` WHERE status = ?`\n params.push(status)\n }\n\n query += ` ORDER BY last_contact_date DESC, created_at DESC`\n\n const result = await sqlite.execute(query, params)\n return result.rows\n}\n\n/**\n * Get the current lead pipeline summary\n */\nexport async function getLeadsPipeline() {\n const result = await sqlite.execute(`\n SELECT status, COUNT(*) as count\n FROM ${KEY}_leads\n GROUP BY status\n ORDER BY \n CASE \n WHEN status = 'new' THEN 1\n WHEN status = 'contacted' THEN 2\n WHEN status = 'responded' THEN 3\n WHEN status = 'meeting_scheduled' THEN 4\n WHEN status = 'proposal_sent' THEN 5\n WHEN status = 'negotiating' THEN 6\n WHEN status = 'won' THEN 7\n WHEN status = 'lost' THEN 8\n ELSE 9\n END\n `)\n\n return result.rows\n}\n\n/**\n * Update a lead's status and other information\n */\nexport async function updateLead(id: number, updates: {\n name?: string\n company?: string\n position?: string\n email?: string\n phone?: string\n source?: string\n status?: string\n last_contact_date?: string\n notes?: string\n}) {\n // Build the SET part of the query dynamically based on provided updates\n const updateFields = Object.entries(updates)\n .filter(([_, value]) => value !== undefined)\n .map(([key, _]) => `${key} = ?`)\n\n const updateValues = Object.entries(updates)\n .filter(([_, value]) => value !== undefined)\n .map(([_, value]) => value)\n\n // If no valid updates, return early\n if (updateFields.length === 0) {\n return {success: false, message: \"No valid updates provided\"}\n }\n\n // Complete the query\n const query = `\n UPDATE ${KEY}_leads\n SET ${updateFields.join(', ')}\n WHERE id = ?\n `\n\n // Execute the query with the update values and the id\n await sqlite.execute(query, [...updateValues, id])\n\n return {success: true}\n}\n",[],[146,263,278],[146,263],{"_102":287,"_95":288,"_147":289,"_149":148,"_150":136,"_151":290,"_153":117,"_104":291,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":292,"_98":347},"9e7874c8-2c10-11f0-a189-569c3dd06744","routes","9e7875a4-2c10-11f0-a189-569c3dd06744",11,["D",1746711033822],[293,303,313,322,330,339],{"_102":294,"_95":295,"_147":296,"_149":289,"_150":136,"_151":297,"_153":117,"_104":298,"_99":290,"_155":299,"_157":300,"_158":27,"_159":-5,"_160":301,"_98":302},"e3af362a-2cb1-11f0-b15e-569c3dd06744","dailyEmail.ts","b833bfbc-2c10-11f0-9cf0-569c3dd06744",71,["D",1746780298913],"interval","import {generateDailyAnalysis, generateTodaysTasks} from \"../ai/analysis.ts\"\nimport {storeAnalysis} from \"../database/queries.ts\"\nimport {formatDate, sendDailyEmail} from \"../utils/email.ts\"\n\n/**\n * Daily email scheduler\n * Runs at 1 AM IST (7:30 PM UTC previous day)\n * Analyzes progress, generates tasks, and sends daily email\n */\nexport default async function handler() {\n try {\n console.log(\"Starting daily email process\")\n\n // 1. Analyze yesterday's progress\n const analysis = await generateDailyAnalysis()\n console.log(\"Generated daily analysis\")\n\n // 2. Store analysis in database\n await storeAnalysis(analysis)\n console.log(\"Stored analysis in database\")\n\n // 3. Generate tasks for today\n const tasks = await generateTodaysTasks(analysis)\n console.log(\"Generated tasks for today\", tasks, Array.isArray(tasks))\n\n // 4. Generate dashboard URL for logging\n const logUrl = `https://prashamtrivedi-careercoach.val.run/log?date=${formatDate(new Date())}`\n\n // 5. Send email with analysis and tasks\n const emailResult = await sendDailyEmail({\n analysis,\n tasks: tasks['tasks'] ?? [],\n logUrl,\n })\n\n if (emailResult.success) {\n console.log(\"Daily email sent successfully\")\n return {\n success: true,\n message: \"Daily email sent successfully\",\n timestamp: new Date().toISOString(),\n }\n } else {\n console.error(\"Failed to send daily email:\", emailResult.error)\n return {\n success: false,\n error: emailResult.error,\n timestamp: new Date().toISOString(),\n }\n }\n } catch (error) {\n console.error(\"Error in daily email process:\", error)\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString(),\n }\n }\n}",[],[146,288,295],{"_102":304,"_95":305,"_147":306,"_149":289,"_150":136,"_151":307,"_153":117,"_104":308,"_99":309,"_155":256,"_157":310,"_158":27,"_159":-5,"_160":311,"_98":312},"6c251206-2c15-11f0-9414-569c3dd06744","leadManagement.ts","b3b40658-2c11-11f0-80de-569c3dd06744",24,["D",1746713096866],1,"import { getLeads, getLeadsPipeline } from \"../database/queries.ts\";\n\n/**\n * HTTP endpoint for lead management UI\n * Provides a dedicated interface for managing leads and tracking the pipeline\n */\nexport default {\n async handler(req: Request) {\n try {\n const url = new URL(req.url);\n const path = url.pathname;\n \n // Forward API requests to the leads API\n if (path.startsWith(\"/api/\")) {\n const leadsHandler = (await import(\"./leads.ts\")).default;\n return await leadsHandler.handler(req);\n }\n \n // Otherwise serve the lead management UI\n return await serveDashboard(req);\n } catch (error) {\n console.error(\"Error in lead management handler:\", error);\n return new Response(JSON.stringify({ \n error: \"Internal server error\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n};\n\n/**\n * Serve the lead management dashboard UI\n * @param req The HTTP request\n * @returns HTTP response with the dashboard HTML\n */\nasync function serveDashboard(req: Request) {\n try {\n // Get leads from database\n const leads = await getLeads();\n const pipeline = await getLeadsPipeline();\n \n // Serve HTML UI\n return new Response(generateLeadDashboardHTML(leads, pipeline), {\n headers: {\n \"Content-Type\": \"text/html\"\n }\n });\n } catch (error) {\n console.error(\"Error serving lead dashboard:\", error);\n return new Response(`\n \n \n \n Error\n \n \n \n

Error Loading Lead Dashboard

There was an error loading the dashboard: ${error.message}

Please try again later or contact support.

\n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n }\n}\n\n/**\n * Generate the HTML for the lead management dashboard\n * @param leads Array of leads\n * @param pipeline Lead pipeline data\n * @returns Dashboard HTML\n */\nfunction generateLeadDashboardHTML(leads: any[], pipeline: any[]) {\n return `\n \n \n \n Lead Management - Contract Hunter\n \n \n \n \n

Lead Management

Track and manage potential clients to secure your contract

\n \n

\n Back to Dashboard\n \n

\n \n

Lead Pipeline

\n ${generatePipelineStages(pipeline)}\n

\n \n

Lead Tracker

\n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n ${leads.length > 0 \n ? leads.map(lead => `\n \n \n \n \n \n \n \n \n `).join('')\n : ''\n }\n \n

Name	Company	Email	Status	Last Contact	Actions
${lead.name \|\| ''}	${lead.company \|\| ''}	${lead.email \|\| ''}	${formatStatus(lead.status \|\| 'new')}	${formatDate(lead.last_contact_date)}	\n \n \n
No leads yet. Click \"Add New Lead\" to get started.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n `;\n}\n\n/**\n * Generate the HTML for the lead pipeline stages\n * @param pipeline Array of pipeline stages and counts\n * @returns HTML for pipeline stages\n */\nfunction generatePipelineStages(pipeline: any[]) {\n // Define the stages in order\n const stageOrder = [\n { key: 'new', label: 'New Leads' },\n { key: 'contacted', label: 'Contacted' },\n { key: 'responded', label: 'Responded' },\n { key: 'meeting_scheduled', label: 'Meeting Set' },\n { key: 'proposal_sent', label: 'Proposal Sent' },\n { key: 'negotiating', label: 'Negotiating' },\n { key: 'won', label: 'Won' },\n { key: 'lost', label: 'Lost' }\n ];\n \n // Create a map of counts by stage\n const countsByStage = (pipeline || []).reduce((acc, stage) => {\n acc[stage.status] = stage.count;\n return acc;\n }, {});\n \n // Generate HTML for each stage\n return stageOrder.map(stage => `\n

${stage.label}

${countsByStage[stage.key] || 0}

\n `).join('');\n}\n\n/**\n * Format status for display\n * @param status Status code\n * @returns Formatted status string\n */\nfunction formatStatus(status: string): string {\n switch (status) {\n case 'new': return 'New Lead';\n case 'contacted': return 'Contacted';\n case 'responded': return 'Responded';\n case 'meeting_scheduled': return 'Meeting Set';\n case 'proposal_sent': return 'Proposal Sent';\n case 'negotiating': return 'Negotiating';\n case 'won': return 'Won';\n case 'lost': return 'Lost';\n default: return status;\n }\n}\n\n/**\n * Format a date as a readable string\n * @param dateString Date string\n * @returns Formatted date string\n */\nfunction formatDate(dateString?: string): string {\n if (!dateString) return 'Never';\n \n const date = new Date(dateString);\n if (isNaN(date.getTime())) return 'Invalid date';\n \n return date.toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n}\n",[],[146,288,305],{"_102":314,"_95":315,"_147":316,"_149":289,"_150":136,"_151":317,"_153":117,"_104":318,"_99":31,"_155":256,"_157":319,"_158":27,"_159":-5,"_160":320,"_98":321},"7fff81ca-2c11-11f0-babd-569c3dd06744","leads.ts","7fff827e-2c11-11f0-babd-569c3dd06744",17,["D",1746711412194],"import { addLead, getLeads, updateLead, getLeadsPipeline } from \"../database/queries.ts\";\n\n/**\n * HTTP endpoint for lead management\n * Handles creating, reading, updating, and filtering leads\n */\nexport default {\n async handler(req: Request) {\n const url = new URL(req.url);\n const path = url.pathname;\n \n // Handle different routes and HTTP methods\n if (path.endsWith(\"/pipeline\") && req.method === \"GET\") {\n // Get lead pipeline summary\n return await handleGetPipeline();\n } else if (req.method === \"GET\") {\n // Get leads, optionally filtered by status\n const status = url.searchParams.get(\"status\");\n return await handleGetLeads(status);\n } else if (req.method === \"POST\") {\n // Create a new lead\n try {\n const leadData = await req.json();\n return await handleCreateLead(leadData);\n } catch (error) {\n console.error(\"Error parsing request body:\", error);\n return new Response(JSON.stringify({ \n error: \"Invalid request body\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n } else if (req.method === \"PUT\") {\n // Update an existing lead\n try {\n const leadData = await req.json();\n return await handleUpdateLead(leadData);\n } catch (error) {\n console.error(\"Error parsing request body:\", error);\n return new Response(JSON.stringify({ \n error: \"Invalid request body\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n } else {\n // Method not allowed\n return new Response(\"Method not allowed\", { status: 405 });\n }\n }\n};\n\n/**\n * Handle GET request to retrieve leads\n * @param status Optional status filter\n * @returns Response with leads\n */\nasync function handleGetLeads(status?: string) {\n try {\n const leads = await getLeads(status);\n \n return new Response(JSON.stringify({\n success: true,\n leads\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error getting leads:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to get leads\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle GET request to retrieve lead pipeline\n * @returns Response with pipeline stages and counts\n */\nasync function handleGetPipeline() {\n try {\n const pipeline = await getLeadsPipeline();\n \n return new Response(JSON.stringify({\n success: true,\n pipeline\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error getting lead pipeline:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to get lead pipeline\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle POST request to create a new lead\n * @param leadData Lead data\n * @returns Response with created lead\n */\nasync function handleCreateLead(leadData: any) {\n try {\n // Validate required fields\n if (!leadData.name) {\n return new Response(JSON.stringify({ \n error: \"Lead name is required\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n // Set default values for optional fields\n const lead = {\n name: leadData.name,\n company: leadData.company,\n position: leadData.position,\n email: leadData.email,\n phone: leadData.phone,\n source: leadData.source,\n status: leadData.status || \"new\",\n notes: leadData.notes\n };\n \n // Create the lead\n const result = await addLead(lead);\n \n // Return success response\n return new Response(JSON.stringify({\n success: true,\n id: result.id,\n lead\n }), {\n status: 201,\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error creating lead:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to create lead\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle PUT request to update an existing lead\n * @param leadData Lead data with id\n * @returns Response with update status\n */\nasync function handleUpdateLead(leadData: any) {\n try {\n // Validate required fields\n if (!leadData.id) {\n return new Response(JSON.stringify({ \n error: \"Lead ID is required\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n // Prepare update data\n const updates = {\n name: leadData.name,\n company: leadData.company,\n position: leadData.position,\n email: leadData.email,\n phone: leadData.phone,\n source: leadData.source,\n status: leadData.status,\n last_contact_date: leadData.last_contact_date || (leadData.status ? new Date().toISOString() : undefined),\n notes: leadData.notes\n };\n \n // Update the lead\n const result = await updateLead(leadData.id, updates);\n \n // Return success response\n return new Response(JSON.stringify({\n success: result.success,\n id: leadData.id,\n message: result.success ? \"Lead updated successfully\" : result.message\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error updating lead:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to update lead\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n",[],[146,288,315],{"_102":323,"_95":324,"_147":115,"_149":289,"_150":136,"_151":325,"_153":117,"_104":326,"_99":309,"_155":256,"_157":327,"_158":27,"_159":-5,"_160":328,"_98":329},"3e0e045e-2c15-11f0-9c02-569c3dd06744","logEntry.ts",23,["D",1746713019542],"import { processLogEntry } from \"../ai/analysis.ts\";\nimport { \n storeDailyLog, \n updateProgressMetrics, \n storeInteraction \n} from \"../database/queries.ts\";\nimport { formatDate } from \"../utils/email.ts\";\n\n/**\n * HTTP endpoint to handle log entries\n * Processes daily logs, progress metrics, and todo updates\n */\nexport default {\n async handler(req: Request) {\n // Only handle POST requests\n if (req.method !== \"POST\") {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n \n try {\n // Parse incoming request\n const content = await req.json();\n const logType = content.logType || \"daily\"; // Default to daily log\n \n switch(logType) {\n case 'daily':\n return await handleDailyLog(content);\n case 'progress':\n return await handleProgressMetrics(content);\n case 'todo':\n return await handleTodoUpdate(content);\n default:\n return new Response(\"Invalid log type\", { status: 400 });\n }\n } catch (error) {\n console.error(\"Error handling log entry:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to process log entry\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n }\n};\n\n/**\n * Handle a daily log entry\n * @param content Log entry content\n * @returns Response with feedback\n */\nasync function handleDailyLog(content) {\n try {\n // Prepare log data\n const log = {\n log_date: content.log_date || formatDate(new Date()),\n achievements: content.achievements || \"\",\n challenges: content.challenges || \"\",\n mood: content.mood || 3,\n hours_worked: content.hours_worked || 0\n };\n \n // Store the log entry\n await storeDailyLog(log);\n \n // Update progress metrics if included\n if (content.metrics) {\n await updateProgressMetrics({\n metric_date: log.log_date,\n ...content.metrics\n });\n }\n \n // Process entry with AI for analysis\n const analysis = await processLogEntry(content);\n \n // Store the interaction\n await storeInteraction(\n JSON.stringify(content), \n JSON.stringify(analysis), \n \"AI Coach\"\n );\n \n // Return immediate feedback\n return new Response(JSON.stringify({\n success: true,\n log_date: log.log_date,\n analysis\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error handling daily log:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to process daily log\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle a progress metrics update\n * @param content Metrics content\n * @returns Response with status\n */\nasync function handleProgressMetrics(content) {\n try {\n // Prepare metrics data\n const metrics = {\n metric_date: content.metric_date || formatDate(new Date()),\n leads_contacted: content.leads_contacted,\n responses_received: content.responses_received,\n meetings_scheduled: content.meetings_scheduled,\n proposals_sent: content.proposals_sent\n };\n \n // Update the metrics\n const result = await updateProgressMetrics(metrics);\n \n // Return success response\n return new Response(JSON.stringify({\n success: true,\n updated: result.updated,\n metric_date: metrics.metric_date\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error handling metrics update:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to update metrics\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle a todo update\n * @param content Todo update content\n * @returns Response with status\n */\nasync function handleTodoUpdate(content) {\n try {\n // Validate required fields\n if (!content.id) {\n return new Response(JSON.stringify({ \n error: \"Todo ID is required\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n // Prepare update data\n const updates = {\n status: content.status,\n description: content.description,\n category: content.category,\n priority: content.priority,\n notes: content.notes\n };\n \n // If marking as completed, add completion timestamp\n if (updates.status === \"completed\") {\n updates.completed_at = new Date().toISOString();\n }\n \n // Update the todo\n const result = await updateTodo(content.id, updates);\n \n // Return success response\n return new Response(JSON.stringify({\n success: result.success,\n id: content.id,\n message: result.success ? \"Todo updated successfully\" : result.message\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error handling todo update:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to update todo\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n// Importing the updateTodo function here to avoid circular dependencies\nasync function updateTodo(id: number, updates: any) {\n // Build the SET part of the query dynamically based on provided updates\n const updateFields = Object.entries(updates)\n .filter(([_, value]) => value !== undefined)\n .map(([key, _]) => `${key} = ?`);\n \n const updateValues = Object.entries(updates)\n .filter(([_, value]) => value !== undefined)\n .map(([_, value]) => value);\n \n // If no valid updates, return early\n if (updateFields.length === 0) {\n return { success: false, message: \"No valid updates provided\" };\n }\n \n // Get a unique key for the table name\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n \n // Import sqlite directly here to avoid circular dependencies\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n \n // Complete the query\n const query = `\n UPDATE ${KEY}_todos\n SET ${updateFields.join(', ')}\n WHERE id = ?\n `;\n \n // Execute the query with the update values and the id\n await sqlite.execute(query, [...updateValues, id]);\n \n return { success: true };\n}\n",[],[146,288,324],{"_102":331,"_95":332,"_147":333,"_149":289,"_150":136,"_151":334,"_153":117,"_104":335,"_99":31,"_155":256,"_157":336,"_158":27,"_159":-5,"_160":337,"_98":338},"6947744c-2c11-11f0-8a2b-569c3dd06744","todos.ts","69477514-2c11-11f0-8a2b-569c3dd06744",16,["D",1746711374078],"import { createTodo, getTodos, updateTodo } from \"../database/queries.ts\";\n\n/**\n * HTTP endpoint for todo management\n * Handles creating, reading, updating, and filtering todos\n */\nexport default {\n async handler(req: Request) {\n const url = new URL(req.url);\n \n // Handle different HTTP methods\n if (req.method === \"GET\") {\n // Get todos, optionally filtered by status\n const status = url.searchParams.get(\"status\");\n return await handleGetTodos(status);\n } else if (req.method === \"POST\") {\n // Create a new todo\n try {\n const todoData = await req.json();\n return await handleCreateTodo(todoData);\n } catch (error) {\n console.error(\"Error parsing request body:\", error);\n return new Response(JSON.stringify({ \n error: \"Invalid request body\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n } else if (req.method === \"PUT\") {\n // Update an existing todo\n try {\n const todoData = await req.json();\n return await handleUpdateTodo(todoData);\n } catch (error) {\n console.error(\"Error parsing request body:\", error);\n return new Response(JSON.stringify({ \n error: \"Invalid request body\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n } else {\n // Method not allowed\n return new Response(\"Method not allowed\", { status: 405 });\n }\n }\n};\n\n/**\n * Handle GET request to retrieve todos\n * @param status Optional status filter\n * @returns Response with todos\n */\nasync function handleGetTodos(status?: string) {\n try {\n const todos = await getTodos(status);\n \n return new Response(JSON.stringify({\n success: true,\n todos\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error getting todos:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to get todos\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle POST request to create a new todo\n * @param todoData Todo data\n * @returns Response with created todo\n */\nasync function handleCreateTodo(todoData: any) {\n try {\n // Validate required fields\n if (!todoData.description || !todoData.category) {\n return new Response(JSON.stringify({ \n error: \"Description and category are required\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n // Set default values for optional fields\n const todo = {\n description: todoData.description,\n category: todoData.category,\n status: todoData.status || \"pending\",\n priority: todoData.priority || 3,\n due_date: todoData.due_date,\n notes: todoData.notes\n };\n \n // Create the todo\n const result = await createTodo(todo);\n \n // Return success response\n return new Response(JSON.stringify({\n success: true,\n id: result.id,\n todo\n }), {\n status: 201,\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error creating todo:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to create todo\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n\n/**\n * Handle PUT request to update an existing todo\n * @param todoData Todo data with id\n * @returns Response with update status\n */\nasync function handleUpdateTodo(todoData: any) {\n try {\n // Validate required fields\n if (!todoData.id) {\n return new Response(JSON.stringify({ \n error: \"Todo ID is required\" \n }), { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n \n // Prepare update data\n const updates = {\n description: todoData.description,\n category: todoData.category,\n status: todoData.status,\n priority: todoData.priority,\n due_date: todoData.due_date,\n notes: todoData.notes\n };\n \n // If marking as completed, add completion timestamp\n if (updates.status === \"completed\") {\n updates.completed_at = new Date().toISOString();\n }\n \n // Update the todo\n const result = await updateTodo(todoData.id, updates);\n \n // Return success response\n return new Response(JSON.stringify({\n success: result.success,\n id: todoData.id,\n message: result.success ? \"Todo updated successfully\" : result.message\n }), {\n headers: { \"Content-Type\": \"application/json\" }\n });\n } catch (error) {\n console.error(\"Error updating todo:\", error);\n return new Response(JSON.stringify({ \n error: \"Failed to update todo\", \n message: error.message \n }), { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n });\n }\n}\n",[],[146,288,332],{"_102":340,"_95":341,"_147":342,"_149":289,"_150":136,"_151":135,"_153":117,"_104":343,"_99":228,"_155":299,"_157":344,"_158":27,"_159":-5,"_160":345,"_98":346},"3e6c0dcc-2cb2-11f0-9932-569c3dd06744","weeklyEmail.ts","bf28ae2c-2c10-11f0-99e5-569c3dd06744",["D",1746780451146],"import {generateWeeklyAnalysis} from \"../ai/analysis.ts\"\nimport {sendWeeklyEmail} from \"../utils/email.ts\"\nimport {storeAnalysis, getProgressMetrics} from \"../database/queries.ts\"\n\n/**\n * Weekly analysis scheduler\n * Runs Sunday at 4 PM IST (10:30 AM UTC)\n * Generates comprehensive weekly analysis and strategy\n */\nexport default async function handler() {\n try {\n console.log(\"Starting weekly analysis process\")\n\n // 1. Generate comprehensive weekly analysis\n const weeklyAnalysis = await generateWeeklyAnalysis()\n console.log(\"Generated weekly analysis\")\n\n // 2. Store analysis in database\n await storeAnalysis({\n analysis_date: new Date().toISOString().split('T')[0],\n analysis_type: \"weekly\",\n summary: weeklyAnalysis.summary,\n focus_areas: JSON.stringify(weeklyAnalysis.focus_areas || []),\n recommendations: JSON.stringify(weeklyAnalysis.recommendations || [])\n })\n console.log(\"Stored weekly analysis in database\")\n\n // 3. Prepare strategy for the email\n const strategy = {\n primary_objective: weeklyAnalysis.strategy?.primary_objective || \"Secure a contract\",\n key_tactics: weeklyAnalysis.strategy?.key_tactics || [],\n days_remaining: weeklyAnalysis.strategy?.days_remaining || 0\n }\n\n // 4. Get current progress metrics\n const progressMetrics = await getProgressMetrics()\n\n // 5. Send weekly email\n const emailResult = await sendWeeklyEmail({\n weeklyAnalysis,\n strategy,\n progressMetrics\n })\n\n if (emailResult.success) {\n console.log(\"Weekly email sent successfully\")\n return {\n success: true,\n message: \"Weekly email sent successfully\",\n timestamp: new Date().toISOString()\n }\n } else {\n console.error(\"Failed to send weekly email:\", emailResult.error)\n return {\n success: false,\n error: emailResult.error,\n timestamp: new Date().toISOString()\n }\n }\n } catch (error) {\n console.error(\"Error in weekly analysis process:\", error)\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString()\n }\n }\n\n};\n",[],[146,288,341],[146,288],{"_102":349,"_95":350,"_147":351,"_149":148,"_150":136,"_151":352,"_153":117,"_104":353,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":354,"_98":373},"7e96eec8-2c10-11f0-8712-569c3dd06744","utils","7e96ef9a-2c10-11f0-8712-569c3dd06744",9,["D",1746710980334],[355,364],{"_102":356,"_95":357,"_147":358,"_149":351,"_150":136,"_151":359,"_153":117,"_104":360,"_99":309,"_155":175,"_157":361,"_158":27,"_159":-5,"_160":362,"_98":363},"6f0d796c-2cb1-11f0-a99e-569c3dd06744","email.ts","9b7d1e9a-2c10-11f0-8204-569c3dd06744",63,["D",1746780103236],"import { email } from \"https://esm.town/v/std/email\";\n\n/**\n * Email utility functions for the Career Coach application\n * Handles sending daily and weekly emails with analytics and tasks\n */\n\n/**\n * Format a date as YYYY-MM-DD\n * @param date The date to format\n * @returns Formatted date string\n */\nexport function formatDate(date: Date): string {\n return date.toISOString().split('T')[0];\n}\n\n/**\n * Send a daily email with analysis and tasks\n * @param data Object containing analysis, tasks, and logUrl\n * @returns Result of the email sending operation\n */\nexport async function sendDailyEmail(data: {\n analysis: any;\n tasks: any[];\n logUrl: string;\n}) {\n \n try {\n // Generate the email content\n const emailContent = await generateDailyEmailContent(data);\n \n // Send the email\n const result = await email({\n to: \"prash2488@gmail.com\", // Replace with environment variable in production\n subject: `Career Coach: Daily Brief (${formatDate(new Date())})`,\n html: emailContent,\n text: generatePlainTextVersion(emailContent)\n });\n \n console.log(\"Daily email sent successfully\");\n return { success: true, result };\n } catch (error) {\n console.error(\"Error sending daily email:\", error);\n return { success: false, error: error.message };\n }\n}\n\n/**\n * Send a weekly email with analysis and strategy\n * @param data Object containing weeklyAnalysis, strategy, and progressMetrics\n * @returns Result of the email sending operation\n */\nexport async function sendWeeklyEmail(data: {\n weeklyAnalysis: any;\n strategy: any;\n progressMetrics: any;\n}) {\n const { weeklyAnalysis, strategy, progressMetrics } = data;\n \n try {\n // Generate the email content\n const emailContent = await generateWeeklyEmailContent(data);\n \n // Send the email\n const result = await email({\n to: \"prash2488@gmail.com\", // Replace with environment variable in production\n subject: `Career Coach: Weekly War Room (${formatDate(new Date())})`,\n html: emailContent,\n text: generatePlainTextVersion(emailContent)\n });\n \n console.log(\"Weekly email sent successfully\");\n return { success: true, result };\n } catch (error) {\n console.error(\"Error sending weekly email:\", error);\n return { success: false, error: error.message };\n }\n}\n\n/**\n * Generate the HTML content for the daily email\n * @param data Object containing analysis, tasks, and logUrl\n * @returns HTML content for the email\n */\nasync function generateDailyEmailContent(data: {\n analysis: any;\n tasks: any[];\n logUrl: string;\n}) {\n const { analysis, tasks, logUrl } = data;\n \n // Parse focus areas from JSON string if needed\n const focusAreas = typeof analysis.focus_areas === 'string' \n ? JSON.parse(analysis.focus_areas) \n : analysis.focus_areas || [];\n \n return `\n

Career Coach: Daily Brief

\n \n

Yesterday's Analysis

${analysis.summary}

\n \n

Focus Areas

${area}

\n \n

Today's Battle Plan

\n ${task.description}\n
Priority: ${renderPriority(task.priority)}
\n
Category: ${task.category}
\n
Expected outcome: ${task.expected_outcome}
\n

\n \n

\n LOG TODAY'S PROGRESS\n

\n \n

\n Remember: Every action gets you closer to that contract. Let's make today count!\n

\n `;\n}\n\n/**\n * Generate the HTML content for the weekly email\n * @param data Object containing weeklyAnalysis, strategy, and progressMetrics\n * @returns HTML content for the email\n */\nasync function generateWeeklyEmailContent(data: {\n weeklyAnalysis: any;\n strategy: any;\n progressMetrics: any;\n}) {\n const { weeklyAnalysis, strategy, progressMetrics } = data;\n \n // Parse arrays from JSON strings if needed\n const victories = typeof weeklyAnalysis.victories === 'string' \n ? JSON.parse(weeklyAnalysis.victories) \n : weeklyAnalysis.victories || [];\n \n const challenges = typeof weeklyAnalysis.challenges === 'string' \n ? JSON.parse(weeklyAnalysis.challenges) \n : weeklyAnalysis.challenges || [];\n \n const keyTactics = typeof strategy.key_tactics === 'string' \n ? JSON.parse(strategy.key_tactics) \n : strategy.key_tactics || [];\n \n return `\n

Career Coach: Weekly War Room

\n \n

Week in Review

${weeklyAnalysis.summary}

\n \n

Victories

${v}

\n \n

Challenges

${c}

\n \n

Progress Metrics

\n \n

${progressMetrics.leads_contacted || 0}

Leads Contacted

\n \n

${progressMetrics.responses_received || 0}

Responses Received

\n \n

${progressMetrics.meetings_scheduled || 0}

Meetings Scheduled

\n \n

${progressMetrics.proposals_sent || 0}

Proposals Sent

\n \n

Next Week's Battle Strategy

\n \n

Primary Objective

${strategy.primary_objective}

\n \n

Key Tactics

${tactic}

\n \n

\n \"The greatest battles are won by generals who can turn setbacks into opportunities.\"\n

\n \n

Days Remaining: ${strategy.days_remaining} - Let's make them count.

\n `;\n}\n\n/**\n * Generate a plain text version of the HTML email for email clients that don't support HTML\n * @param htmlContent The HTML content to convert\n * @returns Plain text version of the email\n */\nfunction generatePlainTextVersion(htmlContent: string): string {\n // This is a very basic HTML to plain text conversion\n // In a production environment, you might want to use a dedicated library\n return htmlContent\n .replace(/]*>/gi, '')\n .replace(/<\\/div>/gi, '\\n\\n')\n .replace(/]*>/gi, '# ')\n .replace(/<\\/h1>/gi, '\\n\\n')\n .replace(/]*>/gi, '## ')\n .replace(/<\\/h2>/gi, '\\n\\n')\n .replace(/]*>/gi, '### ')\n .replace(/<\\/h3>/gi, '\\n\\n')\n .replace(/]*>/gi, '')\n .replace(/<\\/p>/gi, '\\n\\n')\n .replace(//gi, '\\n')\n .replace(/]*>/gi, '- ')\n .replace(/<\\/li>/gi, '\\n')\n .replace(/]*>/gi, '\\n')\n .replace(/<\\/ul>/gi, '\\n')\n .replace(/]*>/gi, '\\n')\n .replace(/<\\/ol>/gi, '\\n')\n .replace(/]*href=\"([^\"]*)\"[^>]*>(.*?)<\\/a>/gi, '$2 ($1)')\n .replace(/]*>(.*?)<\\/strong>/gi, '*$1*')\n .replace(/<[^>]*>/g, '') // Remove any remaining HTML tags\n .replace(/ /g, ' ')\n .replace(/&/g, '&')\n .replace(/</g, '<')\n .replace(/>/g, '>')\n .replace(/"/g, '\"')\n .replace(/'/g, \"'\")\n .replace(/\\n\\s*\\n\\s*\\n/g, '\\n\\n') // Remove excessive newlines\n .trim();\n}\n\n/**\n * Render priority level as a human-readable string\n * @param priority Priority level (1-5)\n * @returns Formatted priority string\n */\nfunction renderPriority(priority: number): string {\n switch (priority) {\n case 1: return \"🔥 CRITICAL\";\n case 2: return \"⚡ High\";\n case 3: return \"⚠️ Medium\";\n case 4: return \"📌 Low\";\n case 5: return \"📝 Backlog\";\n default: return \"Medium\";\n }\n}\n",[],[146,350,357],{"_102":365,"_95":366,"_147":367,"_149":351,"_150":136,"_151":368,"_153":117,"_104":369,"_99":309,"_155":175,"_157":370,"_158":27,"_159":-5,"_160":371,"_98":372},"9e390fdc-2c28-11f0-a8e4-569c3dd06744","initialization.ts","c07a066c-2c11-11f0-8e45-569c3dd06744",57,["D",1746721341300],"import { initializeDatabase } from \"../database/migrations.ts\";\nimport { createTodo, updateProgressMetrics, storeAnalysis } from \"../database/queries.ts\";\nimport { formatDate } from \"./email.ts\";\n\n/**\n * Initialization utility for the Career Coach system\n * Sets up the database and creates initial data\n */\n\n/**\n * Initialize the Career Coach system\n * Creates database tables and initial data\n */\nexport async function initializeSystem() {\n try {\n console.log(\"Starting system initialization...\");\n \n // Step 1: Initialize database schema\n await initializeDatabase();\n console.log(\"Database schema initialized\");\n \n // Step 2: Set up initial progress metrics for today\n const today = formatDate(new Date());\n await updateProgressMetrics({\n metric_date: today,\n leads_contacted: 0,\n responses_received: 0,\n meetings_scheduled: 0,\n proposals_sent: 0\n });\n console.log(\"Initial progress metrics created\");\n \n // Step 3: Create initial analysis\n await storeAnalysis({\n analysis_date: today,\n analysis_type: \"daily\",\n summary: \"Welcome to your 20-Day Contract Hunter journey! This system will help you track your progress and provide strategic guidance to secure a contract within 20 days. Start by logging your daily activities and progress metrics.\",\n focus_areas: JSON.stringify([\n \"Set up your outreach strategy\",\n \"Prepare your portfolio highlights\",\n \"Identify your initial target markets\"\n ]),\n recommendations: JSON.stringify([\n \"Complete your first daily log to receive personalized recommendations\",\n \"Add your first few leads to the lead tracker\",\n \"Review the dashboard daily to track your progress\"\n ])\n });\n console.log(\"Initial analysis created\");\n \n // Step 4: Create initial todos\n const initialTodos = [\n {\n description: \"Create a list of 10 potential clients to contact\",\n category: \"outreach\",\n status: \"pending\",\n priority: 1,\n notes: \"Focus on companies that need serverless architecture and AI integration\"\n },\n {\n description: \"Update your portfolio with recent AI and serverless projects\",\n category: \"portfolio\",\n status: \"pending\",\n priority: 1,\n notes: \"Highlight your experience with AWS Lambda, OpenAI, and TypeScript\"\n },\n {\n description: \"Craft a customizable outreach message template\",\n category: \"outreach\",\n status: \"pending\",\n priority: 2,\n notes: \"Focus on solving problems rather than selling services\"\n },\n {\n description: \"Set up a system to track your outreach efforts\",\n category: \"admin\",\n status: \"pending\",\n priority: 2,\n notes: \"Use the lead management dashboard to track progress\"\n },\n {\n description: \"Create a quick demo project showcasing your expertise\",\n category: \"portfolio\",\n status: \"pending\",\n priority: 3,\n notes: \"Consider a micro-SaaS or API that demonstrates your skills\"\n }\n ];\n \n for (const todo of initialTodos) {\n await createTodo(todo);\n }\n console.log(\"Initial todos created\");\n \n // Step 5: Update initialization status\n console.log(\"System initialization complete!\");\n \n return {\n success: true,\n message: \"Career Coach system initialized successfully\",\n timestamp: new Date().toISOString()\n };\n } catch (error) {\n console.error(\"Error initializing system:\", error);\n return {\n success: false,\n error: error.message,\n timestamp: new Date().toISOString()\n };\n }\n}\n\n",[],[146,350,366],[146,350],{"_102":375,"_95":253,"_147":376,"_149":148,"_150":136,"_151":377,"_153":117,"_104":378,"_99":228,"_155":256,"_157":379,"_158":27,"_159":380,"_160":381,"_98":382},"8bb7a5f4-2c22-11f0-8b3c-569c3dd06744","f1bc9254-2c10-11f0-bb1f-569c3dd06744",33,["D",1746718733294],"// CareerCoach20Day/backend/index.ts\nimport handler from './api/index.ts';\n\nexport default handler;\n","prashamtrivedi-careercoach",[],[146,253],[146],{"_102":385,"_95":386,"_147":387,"_149":-5,"_150":136,"_151":388,"_153":117,"_104":389,"_99":31,"_155":390,"_157":391,"_158":27,"_159":-5,"_160":392,"_98":393},"8bc3a548-2c22-11f0-977b-569c3dd06744",".vtignore","8bc3a642-2c22-11f0-977b-569c3dd06744",35,["D",1746718733306],"file",".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[],[386],{"_102":395,"_95":396,"_147":397,"_149":-5,"_150":136,"_151":309,"_153":117,"_104":398,"_99":31,"_155":390,"_157":399,"_158":27,"_159":-5,"_160":400,"_98":401},"26893966-2c10-11f0-82df-569c3dd06744","README.md","26893ace-2c10-11f0-82df-569c3dd06744",["D",1746710832604],"# ValTown Career Coach: The 20-Day Contract Hunter\n\nA strategic career coaching system designed to help software professionals secure contracts within 20 days.\n\n## Overview\n\nThis system provides:\n- Daily progress tracking and analysis\n- AI-powered task prioritization\n- Progress metrics visualization\n- Strategic career guidance tailored to your situation\n- Email notifications with daily and weekly updates\n\n## Features\n\n- **Daily Email System**: Sends personalized guidance each morning\n- **Log Entry System**: Tracks accomplishments, challenges, and metrics\n- **Weekly Analysis**: Provides comprehensive strategy review\n- **Model Selection**: Uses different AI models based on task complexity\n- **Coach AI Analysis**: Provides direct, unfiltered career advice\n\n## Getting Started\n\n1. Visit the dashboard at: [CareerCoach Dashboard](https://www.val.town/x/prashamtrivedi/CareerCoach20Day/backend/index)\n2. Log your daily activities and progress metrics\n3. Check your email each morning for your daily battle plan\n4. Complete the recommended high-priority tasks\n5. Review weekly analysis every Sunday\n\n## Tech Stack\n\n- ValTown serverless functions\n- SQLite database for persistent storage\n- OpenAI API for AI-powered analysis and recommendations\n- Email integration for notifications\n- Browser-based dashboard with interactive UI\n\n## Purpose\n\nThis project aims to help you secure a meaningful contract within 20 days, leveraging real-time AI analysis to optimize your approach to the market. Every feature is designed with one goal: landing you a contract as quickly as possible.\n",[],[396],{"_102":403,"_95":404,"_147":405,"_149":-5,"_150":136,"_151":406,"_153":117,"_104":407,"_99":31,"_155":390,"_157":408,"_158":27,"_159":-5,"_160":409,"_98":410},"8bbad7ce-2c22-11f0-9bb4-569c3dd06744","deno.json","8bbad86e-2c22-11f0-9bb4-569c3dd06744",34,["D",1746718733296],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[],[404],"files",[144,162,169,179,189,196,203,213,222,232,242,251,261,267,276,286,293,303,313,322,330,339,348,355,364,374,384,394,402],"counts",{"_415":31,"_416":309,"_417":31,"_418":31},"pulls","branches","forks","envVars","contents",[421,424,427,430],{"_102":145,"_95":146,"_147":148,"_149":-5,"_150":136,"_151":152,"_153":117,"_104":422,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_98":423},["D",1746710836315],[146],{"_102":385,"_95":386,"_147":387,"_149":-5,"_150":136,"_151":388,"_153":117,"_104":425,"_99":31,"_155":390,"_157":391,"_158":27,"_159":-5,"_98":426},["D",1746718733306],[386],{"_102":395,"_95":396,"_147":397,"_149":-5,"_150":136,"_151":309,"_153":117,"_104":428,"_99":31,"_155":390,"_157":399,"_158":27,"_159":-5,"_98":429},["D",1746710832604],[396],{"_102":403,"_95":404,"_147":405,"_149":-5,"_150":136,"_151":406,"_153":117,"_104":431,"_99":31,"_155":390,"_157":408,"_158":27,"_159":-5,"_98":432},["D",1746718733296],[404],"upstream","emptyEnvVars","isNew","routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":41,"_99":-7,"_98":68,"_100":438,"_142":442,"_411":530,"_390":-7,"_419":531,"_433":-5,"_540":27,"_541":-5},{"_102":103,"_95":96,"_104":439,"_106":-5,"_107":27,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":115,"_116":117,"_118":119,"_120":31,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":27,"_21":440,"_133":441},["D",1746710817937],{"_93":94,"_131":132},{"_99":135,"_95":41,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5},[443,521,524,527],{"_102":145,"_95":146,"_147":148,"_149":-5,"_150":136,"_151":152,"_153":117,"_104":154,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":444,"_98":520},[445,454,478,487,508,517],{"_102":163,"_95":164,"_147":165,"_149":148,"_150":136,"_151":166,"_153":117,"_104":167,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":446,"_98":453},[447,450],{"_102":170,"_95":171,"_147":172,"_149":165,"_150":136,"_151":173,"_153":117,"_104":174,"_99":31,"_155":175,"_157":176,"_158":27,"_159":-5,"_160":448,"_98":449},[],[146,164,171],{"_102":180,"_95":181,"_147":182,"_149":165,"_150":136,"_151":183,"_153":117,"_104":184,"_99":152,"_155":175,"_157":185,"_158":27,"_159":-5,"_160":451,"_98":452},[],[146,164,181],[146,164],{"_102":190,"_95":191,"_147":192,"_149":148,"_150":136,"_151":193,"_153":117,"_104":194,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":455,"_98":477},[456,471,474],{"_102":197,"_95":198,"_147":199,"_149":192,"_150":136,"_151":200,"_153":117,"_104":201,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":457,"_98":470},[458,461,464,467],{"_102":204,"_95":205,"_147":206,"_149":199,"_150":136,"_151":207,"_153":117,"_104":208,"_99":209,"_155":175,"_157":210,"_158":27,"_159":-5,"_160":459,"_98":460},[],[146,191,198,205],{"_102":214,"_95":215,"_147":216,"_149":199,"_150":136,"_151":217,"_153":117,"_104":218,"_99":152,"_155":175,"_157":219,"_158":27,"_159":-5,"_160":462,"_98":463},[],[146,191,198,215],{"_102":223,"_95":224,"_147":225,"_149":199,"_150":136,"_151":226,"_153":117,"_104":227,"_99":228,"_155":175,"_157":229,"_158":27,"_159":-5,"_160":465,"_98":466},[],[146,191,198,224],{"_102":233,"_95":234,"_147":235,"_149":199,"_150":136,"_151":236,"_153":117,"_104":237,"_99":152,"_155":175,"_157":238,"_158":27,"_159":-5,"_160":468,"_98":469},[],[146,191,198,234],[146,191,198],{"_102":243,"_95":244,"_147":245,"_149":192,"_150":136,"_151":246,"_153":117,"_104":247,"_99":228,"_155":175,"_157":248,"_158":27,"_159":-5,"_160":472,"_98":473},[],[146,191,244],{"_102":252,"_95":253,"_147":254,"_149":192,"_150":136,"_151":119,"_153":117,"_104":255,"_99":152,"_155":256,"_157":257,"_158":27,"_159":-5,"_160":475,"_98":476},[],[146,191,253],[146,191],{"_102":262,"_95":263,"_147":264,"_149":148,"_150":136,"_151":228,"_153":117,"_104":265,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":479,"_98":486},[480,483],{"_102":268,"_95":269,"_147":270,"_149":264,"_150":136,"_151":271,"_153":117,"_104":272,"_99":152,"_155":175,"_157":273,"_158":27,"_159":-5,"_160":481,"_98":482},[],[146,263,269],{"_102":277,"_95":278,"_147":279,"_149":264,"_150":136,"_151":280,"_153":117,"_104":281,"_99":209,"_155":175,"_157":282,"_158":27,"_159":-5,"_160":484,"_98":485},[],[146,263,278],[146,263],{"_102":287,"_95":288,"_147":289,"_149":148,"_150":136,"_151":290,"_153":117,"_104":291,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":488,"_98":507},[489,492,495,498,501,504],{"_102":294,"_95":295,"_147":296,"_149":289,"_150":136,"_151":297,"_153":117,"_104":298,"_99":290,"_155":299,"_157":300,"_158":27,"_159":-5,"_160":490,"_98":491},[],[146,288,295],{"_102":304,"_95":305,"_147":306,"_149":289,"_150":136,"_151":307,"_153":117,"_104":308,"_99":309,"_155":256,"_157":310,"_158":27,"_159":-5,"_160":493,"_98":494},[],[146,288,305],{"_102":314,"_95":315,"_147":316,"_149":289,"_150":136,"_151":317,"_153":117,"_104":318,"_99":31,"_155":256,"_157":319,"_158":27,"_159":-5,"_160":496,"_98":497},[],[146,288,315],{"_102":323,"_95":324,"_147":115,"_149":289,"_150":136,"_151":325,"_153":117,"_104":326,"_99":309,"_155":256,"_157":327,"_158":27,"_159":-5,"_160":499,"_98":500},[],[146,288,324],{"_102":331,"_95":332,"_147":333,"_149":289,"_150":136,"_151":334,"_153":117,"_104":335,"_99":31,"_155":256,"_157":336,"_158":27,"_159":-5,"_160":502,"_98":503},[],[146,288,332],{"_102":340,"_95":341,"_147":342,"_149":289,"_150":136,"_151":135,"_153":117,"_104":343,"_99":228,"_155":299,"_157":344,"_158":27,"_159":-5,"_160":505,"_98":506},[],[146,288,341],[146,288],{"_102":349,"_95":350,"_147":351,"_149":148,"_150":136,"_151":352,"_153":117,"_104":353,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_160":509,"_98":516},[510,513],{"_102":356,"_95":357,"_147":358,"_149":351,"_150":136,"_151":359,"_153":117,"_104":360,"_99":309,"_155":175,"_157":361,"_158":27,"_159":-5,"_160":511,"_98":512},[],[146,350,357],{"_102":365,"_95":366,"_147":367,"_149":351,"_150":136,"_151":368,"_153":117,"_104":369,"_99":309,"_155":175,"_157":370,"_158":27,"_159":-5,"_160":514,"_98":515},[],[146,350,366],[146,350],{"_102":375,"_95":253,"_147":376,"_149":148,"_150":136,"_151":377,"_153":117,"_104":378,"_99":228,"_155":256,"_157":379,"_158":27,"_159":380,"_160":518,"_98":519},[],[146,253],[146],{"_102":385,"_95":386,"_147":387,"_149":-5,"_150":136,"_151":388,"_153":117,"_104":389,"_99":31,"_155":390,"_157":391,"_158":27,"_159":-5,"_160":522,"_98":523},[],[386],{"_102":395,"_95":396,"_147":397,"_149":-5,"_150":136,"_151":309,"_153":117,"_104":398,"_99":31,"_155":390,"_157":399,"_158":27,"_159":-5,"_160":525,"_98":526},[],[396],{"_102":403,"_95":404,"_147":405,"_149":-5,"_150":136,"_151":406,"_153":117,"_104":407,"_99":31,"_155":390,"_157":408,"_158":27,"_159":-5,"_160":528,"_98":529},[],[404],[443,445,447,450,454,456,458,461,464,467,471,474,478,480,483,487,489,492,495,498,501,504,508,510,513,517,521,524,527],[532,534,536,538],{"_102":145,"_95":146,"_147":148,"_149":-5,"_150":136,"_151":152,"_153":117,"_104":422,"_99":31,"_155":156,"_157":-5,"_158":27,"_159":-5,"_98":533},[146],{"_102":385,"_95":386,"_147":387,"_149":-5,"_150":136,"_151":388,"_153":117,"_104":425,"_99":31,"_155":390,"_157":391,"_158":27,"_159":-5,"_98":535},[386],{"_102":395,"_95":396,"_147":397,"_149":-5,"_150":136,"_151":309,"_153":117,"_104":428,"_99":31,"_155":390,"_157":399,"_158":27,"_159":-5,"_98":537},[396],{"_102":403,"_95":404,"_147":405,"_149":-5,"_150":136,"_151":406,"_153":117,"_104":431,"_99":31,"_155":390,"_157":408,"_158":27,"_159":-5,"_98":539},[404],"showCompareCallout","pull","routes/_app","actionData","errors"]

Error Loading Dashboard

Error Loading Log Page

Coach's Analysis

Focus Areas

Today's Metrics

Campaign Totals

Lead Pipeline

Today's Battle Plan

Recently Completed

What did you accomplish today?

What challenges did you face?

How are you feeling about your progress?

Progress Metrics

Coach's Feedback

Next Steps

${stage.label}

Error Loading Lead Dashboard

Lead Pipeline

Lead Tracker

Add New Lead

Edit Lead

Update Lead Status

${stage.label}

Career Coach: Daily Brief

Yesterday's Analysis

Focus Areas

Today's Battle Plan

Career Coach: Weekly War Room

Week in Review

Victories

Challenges

Progress Metrics

${progressMetrics.leads_contacted || 0}

${progressMetrics.responses_received || 0}

${progressMetrics.meetings_scheduled || 0}

${progressMetrics.proposals_sent || 0}

Next Week's Battle Strategy

Primary Objective

Key Tactics