`, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_258":259,"_260":261},"routes/_app.x.$handle.$name",{"_101":100,"_32":45,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":60,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",27,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","ef02d66e-acf1-11f1-8f7e-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nlet ready: Promise | undefined;\n\nexport function initDb() {\n if (!ready) ready = (async () => {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n password TEXT NOT NULL,\n role TEXT NOT NULL CHECK(role IN ('super_admin','counsellor')),\n status TEXT NOT NULL DEFAULT 'active',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS leads (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n candidate_name TEXT NOT NULL,\n ec_id TEXT NOT NULL UNIQUE,\n phone TEXT NOT NULL,\n email TEXT DEFAULT '',\n country TEXT DEFAULT '',\n program TEXT DEFAULT '',\n counsellor_id INTEGER,\n status TEXT NOT NULL DEFAULT 'New',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(counsellor_id) REFERENCES users(id)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS follow_ups (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n lead_id INTEGER NOT NULL,\n counsellor_id INTEGER NOT NULL,\n scheduled_date TEXT NOT NULL,\n scheduled_time TEXT NOT NULL,\n completed_at TEXT,\n note TEXT,\n next_followup_date TEXT,\n next_followup_time TEXT,\n status TEXT NOT NULL DEFAULT 'pending' CHECK(status IN ('pending','completed')),\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(lead_id) REFERENCES leads(id),\n FOREIGN KEY(counsellor_id) REFERENCES users(id)\n )`);\n // Lead profile extensions used by the Europe Careers enquiry form.\n for (const sql of [\n `ALTER TABLE leads ADD COLUMN lead_type TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN dob TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN current_city TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN qualification TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN experience TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN language_level TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN preferred_country TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN source TEXT DEFAULT 'CRM'`\n ]) { try { await sqlite.execute(sql); } catch {} }\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_followups_due ON follow_ups(scheduled_date, scheduled_time, status)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_followups_lead ON follow_ups(lead_id, created_at DESC)`);\n const count = await sqlite.execute(`SELECT COUNT(*) AS c FROM users`);\n if (Number((count.rows[0] as any)?.c || 0) === 0) {\n await sqlite.execute({sql:`INSERT INTO users (name,email,password,role) VALUES (?,?,?,?)`, args:[\"Super Admin\",\"admin@europecareers.com\",\"admin123\",\"super_admin\"]});\n await sqlite.execute({sql:`INSERT INTO users (name,email,password,role) VALUES (?,?,?,?)`, args:[\"Rahul Counsellor\",\"rahul@europecareers.com\",\"rahul123\",\"counsellor\"]});\n await sqlite.execute({sql:`INSERT INTO users (name,email,password,role) VALUES (?,?,?,?)`, args:[\"Priya Counsellor\",\"priya@europecareers.com\",\"priya123\",\"counsellor\"]});\n }\n })();\n return ready;\n}\n\nexport { sqlite };\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nlet ready: Promise | undefined;\n\nexport function initDb() {\n if (!ready) ready = (async () => {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n password TEXT NOT NULL,\n role TEXT NOT NULL CHECK(role IN ('super_admin','counsellor')),\n status TEXT NOT NULL DEFAULT 'active',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS leads (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n candidate_name TEXT NOT NULL,\n ec_id TEXT NOT NULL UNIQUE,\n phone TEXT NOT NULL,\n email TEXT DEFAULT '',\n country TEXT DEFAULT '',\n program TEXT DEFAULT '',\n counsellor_id INTEGER,\n status TEXT NOT NULL DEFAULT 'New',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(counsellor_id) REFERENCES users(id)\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS follow_ups (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n lead_id INTEGER NOT NULL,\n counsellor_id INTEGER NOT NULL,\n scheduled_date TEXT NOT NULL,\n scheduled_time TEXT NOT NULL,\n completed_at TEXT,\n note TEXT,\n next_followup_date TEXT,\n next_followup_time TEXT,\n status TEXT NOT NULL DEFAULT 'pending' CHECK(status IN ('pending','completed')),\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(lead_id) REFERENCES leads(id),\n FOREIGN KEY(counsellor_id) REFERENCES users(id)\n )`);\n // Lead profile extensions used by the Europe Careers enquiry form.\n for (const sql of [\n `ALTER TABLE leads ADD COLUMN lead_type TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN dob TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN current_city TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN qualification TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN experience TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN language_level TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN preferred_country TEXT DEFAULT ''`,\n `ALTER TABLE leads ADD COLUMN source TEXT DEFAULT 'CRM'`,\n `ALTER TABLE leads ADD COLUMN lead_temperature TEXT DEFAULT 'Cold'`,\n `ALTER TABLE leads ADD COLUMN notes TEXT DEFAULT ''`\n ]) { try { await sqlite.execute(sql); } catch {} }\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_followups_due ON follow_ups(scheduled_date, scheduled_time, status)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_followups_lead ON follow_ups(lead_id, created_at DESC)`);\n const count = await sqlite.execute(`SELECT COUNT(*) AS c FROM users`);\n if (Number((count.rows[0] as any)?.c || 0) === 0) {\n await sqlite.execute({sql:`INSERT INTO users (name,email,password,role) VALUES (?,?,?,?)`, args:[\"Super Admin\",\"admin@europecareers.com\",\"admin123\",\"super_admin\"]});\n await sqlite.execute({sql:`INSERT INTO users (name,email,password,role) VALUES (?,?,?,?)`, args:[\"Rahul Counsellor\",\"rahul@europecareers.com\",\"rahul123\",\"counsellor\"]});\n await sqlite.execute({sql:`INSERT INTO users (name,email,password,role) VALUES (?,?,?,?)`, args:[\"Priya Counsellor\",\"priya@europecareers.com\",\"priya123\",\"counsellor\"]});\n }\n })();\n return ready;\n}\n\nexport { sqlite };\n","createdAt",["D",1789031275653],"branchVersion","branchId","398d1cc9-8d86-4c4c-b719-baeac445feeb","id","c2c4de1c-ac75-46c6-bae3-140bce9b41c9","europe-careers-crm",["D",1789029036131],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Europe Careers call-focused CRM","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/89e2c936-3779-44fe-ac05-33566fc05a01/square512?exp=1789592399&sig=8840317cc661d076e1200125e983ff9ff5e38945875ab81314972722cf34898e","f007d3fe-0142-4134-8bc5-d309aa62c030","pinnedFileId","01a08a70-b0f3-7058-9d1e-0aa6e04fe885","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a085c1-b560-76ae-8210-c20c2a71a6a5","tursoName","c2c4de1cac7546c6bae3140bce9b41c9","tursoHostname","c2c4de1cac7546c6bae3140bce9b41c9-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789550457365],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"isOwned",401,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","shubhamsingh","handle","displayName","Shubham Singh","avatar","https://lh3.googleusercontent.com/a/ACg8ocJsbxTyyQF93TMC5EMaDyttNcoees_fgoJx-kjJsyD3ARH3vXQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":253,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":254,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":255,"_85":256,"_87":257,"_89":25},"tree",[182,189,190,191,192],"files",[182,183,184,185,186,187,188,189,190,191,192],"counts",{"_172":64,"_173":156,"_174":64,"_175":176,"_177":178},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":166,"_32":167,"_30":168,"_139":-5,"_41":42,"_40":156,"_141":60,"_38":169,"_13":64,"_33":170,"_35":-5,"_24":25,"_146":-5,"_27":171},{"_43":160,"_32":161,"_30":162,"_139":-5,"_41":42,"_40":156,"_141":60,"_38":163,"_13":64,"_33":20,"_35":164,"_24":25,"_146":-5,"_27":165},{"_43":153,"_32":154,"_30":155,"_139":-5,"_41":42,"_40":156,"_141":60,"_38":157,"_13":64,"_33":20,"_35":158,"_24":25,"_146":-5,"_27":159},{"_43":149,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":25,"_38":150,"_13":151,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":152},{"_43":137,"_32":138,"_30":58,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":143,"_33":144,"_35":145,"_24":25,"_146":147,"_27":148},"f1364bdb-5bc8-42bc-818f-672009442057","index.ts","parentId",19,"latest",["D",1789031013809],6,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport { initDb, sqlite } from \"./db.ts\";\n\nconst app = new Hono();\nawait initDb();\nconst STATUSES=[\"New\",\"Contacted\",\"Interested\",\"Follow-Up\",\"Qualified\",\"Converted\",\"Not Interested\",\"Not Reachable\",\"Lost\"];\nconst nowParts=()=>new Intl.DateTimeFormat(\"en-CA\",{timeZone:\"Asia/Kolkata\",year:\"numeric\",month:\"2-digit\",day:\"2-digit\",hour:\"2-digit\",minute:\"2-digit\",hour12:false}).formatToParts(new Date()).reduce((a:any,p)=>({...a,[p.type]:p.value}),{});\nconst todayIST=()=>{const p=nowParts();return `${p.year}-${p.month}-${p.day}`};\nconst timeIST=()=>{const p=nowParts();return `${p.hour}:${p.minute}`};\nconst nowIST=()=>`${todayIST()}T${timeIST()}:00+05:30`;\nconst validTime=(t:string)=>/^([01]\\d|2[0-3]):[0-5]\\d$/.test(t)&&t>=\"09:00\"&&t<=\"18:00\";\nconst token=()=>crypto.randomUUID()+crypto.randomUUID();\nasync function auth(c:any,next:any){const sid=c.req.header(\"X-Session-ID\");if(!sid)return c.json({error:\"Authentication required\"},401);const r=await sqlite.execute({sql:`SELECT s.user_id,u.name,u.email,u.role,u.status FROM sessions s JOIN users u ON u.id=s.user_id WHERE s.token=? AND u.status='active' LIMIT 1`,args:[sid]});if(!r.rows[0])return c.json({error:\"Session expired. Please login again.\"},401);c.set(\"user\",r.rows[0]);return next()}\nconst admin=(c:any)=>c.get(\"user\")?.role===\"super_admin\";\napp.get(\"/\",c=>c.html(Root()));app.get(\"/__immutable/*\",c=>serveImmutableFile(c.req.path));app.get(\"/source\",c=>c.redirect(parseVal().links.self.val));\napp.post(\"/api/login\",async c=>{const b=await c.req.json();const id=String(b.identifier||\"\").trim().toLowerCase();const r=await sqlite.execute({sql:`SELECT id,name,email,role,status FROM users WHERE lower(email)=? AND password=? AND status='active' LIMIT 1`,args:[id,String(b.password||\"\")]});if(!r.rows[0])return c.json({error:\"Invalid login credentials\"},401);const sid=token();await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS sessions(token TEXT PRIMARY KEY,user_id INTEGER NOT NULL,created_at TEXT NOT NULL)`});await sqlite.execute({sql:`INSERT INTO sessions(token,user_id,created_at) VALUES(?,?,?)`,args:[sid,Number((r.rows[0] as any).id),nowIST()]});return c.json({user:r.rows[0],sessionId:sid})});\napp.post(\"/api/logout\",auth,async c=>{const sid=c.req.header(\"X-Session-ID\");await sqlite.execute({sql:`DELETE FROM sessions WHERE token=?`,args:[sid]});return c.json({ok:true})});\napp.get(\"/api/me\",auth,c=>c.json({user:c.get(\"user\"),today:todayIST(),time:timeIST()}));\napp.get(\"/api/counsellors\",auth,async c=>c.json({items:(await sqlite.execute(`SELECT id,name,email,role,status,created_at FROM users WHERE role='counsellor' ORDER BY name`)).rows}));\napp.post(\"/api/counsellors\",auth,async c=>{if(!admin(c))return c.json({error:\"Admin access required\"},403);const b=await c.req.json();if(!b.name||!b.email||!b.password)return c.json({error:\"Name, email and password required\"},400);try{await sqlite.execute({sql:`INSERT INTO users(name,email,password,role) VALUES(?,?,?,'counsellor')`,args:[b.name.trim(),b.email.trim().toLowerCase(),b.password]});return c.json({ok:true})}catch{return c.json({error:\"Email already exists\"},400)}});\napp.delete(\"/api/counsellors/:id\",auth,async c=>{if(!admin(c))return c.json({error:\"Admin access required\"},403);const id=Number(c.req.param(\"id\"));const x=await sqlite.execute({sql:`SELECT COUNT(*) c FROM leads WHERE counsellor_id=?`,args:[id]});if(Number((x.rows[0] as any).c)>0)return c.json({error:\"Reassign all leads before deleting this counsellor\"},400);await sqlite.execute({sql:`DELETE FROM users WHERE id=? AND role='counsellor'`,args:[id]});return c.json({ok:true})});\napp.get(\"/api/leads\",auth,async c=>{const q=c.req.query(),u=c.get(\"user\"),p:any[]=[],w:string[]=[];if(u.role!==\"super_admin\"){w.push(`l.counsellor_id=?`);p.push(Number(u.user_id))}if(q.search){w.push(`(l.candidate_name LIKE ? OR l.ec_id LIKE ? OR l.phone LIKE ? OR l.email LIKE ?)`);const s=`%${q.search}%`;p.push(s,s,s,s)}for(const [k,col] of [[\"country\",\"l.country\"],[\"program\",\"l.program\"],[\"counsellor\",\"l.counsellor_id\"],[\"status\",\"l.status\"]] as any[])if(q[k]){w.push(`${col}=?`);p.push(q[k])}const r=await sqlite.execute({sql:`SELECT l.*,u.name counsellor_name,(SELECT scheduled_date||' '||scheduled_time FROM follow_ups f WHERE f.lead_id=l.id AND f.status='pending' ORDER BY f.scheduled_date,f.scheduled_time LIMIT 1) next_followup,(SELECT note FROM follow_ups f WHERE f.lead_id=l.id AND f.status='completed' ORDER BY f.id DESC LIMIT 1) latest_note FROM leads l LEFT JOIN users u ON u.id=l.counsellor_id ${w.length?`WHERE ${w.join(' AND ')}`:\"\"} ORDER BY l.created_at DESC`,args:p});return c.json({items:r.rows})});\napp.post(\"/api/leads\",auth,async c=>{if(!admin(c))return c.json({error:\"Only Super Admin can create leads\"},403);const b=await c.req.json();if(!b.candidate_name||!b.ec_id||!b.phone)return c.json({error:\"Candidate Name, EC ID and Phone are required\"},400);try{const r=await sqlite.execute({sql:`INSERT INTO leads(candidate_name,ec_id,phone,email,country,program,counsellor_id,status,lead_type,dob,current_city,qualification,experience,language_level,preferred_country,source,created_at,updated_at) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,datetime('now'),datetime('now'))`,args:[b.candidate_name,b.ec_id,b.phone,b.email||\"\",b.country||\"\",b.program||\"\",b.counsellor_id?Number(b.counsellor_id):null,b.status||\"New\",b.lead_type||\"\",b.dob||\"\",b.current_city||\"\",b.qualification||\"\",b.experience||\"\",b.language_level||\"\",b.preferred_country||\"\",b.source||\"CRM\"]});return c.json({id:Number(r.lastInsertRowid)})}catch{return c.json({error:\"EC ID already exists\"},400)}});\napp.put(\"/api/leads/:id\",auth,async c=>{const b=await c.req.json(),id=Number(c.req.param(\"id\")),u=c.get(\"user\");const own=await sqlite.execute({sql:`SELECT counsellor_id FROM leads WHERE id=?`,args:[id]});if(!own.rows[0])return c.json({error:\"Lead not found\"},404);if(u.role!==\"super_admin\"&&Number((own.rows[0] as any).counsellor_id)!==Number(u.user_id))return c.json({error:\"You can only edit assigned leads\"},403);if(!STATUSES.includes(b.status))return c.json({error:\"Invalid status\"},400);await sqlite.execute({sql:`UPDATE leads SET candidate_name=?,ec_id=?,phone=?,email=?,country=?,program=?,counsellor_id=?,status=?,lead_type=?,dob=?,current_city=?,qualification=?,experience=?,language_level=?,preferred_country=?,source=?,updated_at=datetime('now') WHERE id=?`,args:[b.candidate_name,b.ec_id,b.phone,b.email||\"\",b.country||\"\",b.program||\"\",u.role==='super_admin'?(b.counsellor_id?Number(b.counsellor_id):null):(Number(u.user_id)),b.status,b.lead_type||\"\",b.dob||\"\",b.current_city||\"\",b.qualification||\"\",b.experience||\"\",b.language_level||\"\",b.preferred_country||\"\",b.source||\"CRM\",id]});return c.json({ok:true})});\napp.delete(\"/api/leads/:id\",auth,async c=>{if(!admin(c))return c.json({error:\"Admin access required\"},403);const id=Number(c.req.param(\"id\"));const x=await sqlite.execute({sql:`SELECT COUNT(*) c FROM follow_ups WHERE lead_id=?`,args:[id]});if(Number((x.rows[0] as any).c)>0)return c.json({error:\"Cannot delete a lead with follow-up history\"},400);await sqlite.execute({sql:`DELETE FROM leads WHERE id=?`,args:[id]});return c.json({ok:true})});\napp.get(\"/api/leads/:id\",auth,async c=>{const id=Number(c.req.param(\"id\")),u=c.get(\"user\");const a=await sqlite.execute({sql:`SELECT l.*,u.name counsellor_name,(SELECT scheduled_date||' '||scheduled_time FROM follow_ups f WHERE f.lead_id=l.id AND f.status='pending' ORDER BY f.scheduled_date,f.scheduled_time LIMIT 1) next_followup FROM leads l LEFT JOIN users u ON u.id=l.counsellor_id WHERE l.id=?`,args:[id]});if(!a.rows[0])return c.json({error:\"Lead not found\"},404);if(u.role!==\"super_admin\"&&Number((a.rows[0] as any).counsellor_id)!==Number(u.user_id))return c.json({error:\"Access denied\"},403);const h=await sqlite.execute({sql:`SELECT f.*,u.name counsellor_name FROM follow_ups f JOIN users u ON u.id=f.counsellor_id WHERE f.lead_id=? ORDER BY f.id DESC`,args:[id]});return c.json({lead:a.rows[0],history:h.rows})});\napp.post(\"/api/follow-ups\",auth,async c=>{const b=await c.req.json(),u=c.get(\"user\"),d=String(b.scheduled_date||\"\"),t=String(b.scheduled_time||\"\");if(!b.lead_id||!/^\\d{4}-\\d{2}-\\d{2}$/.test(d)||!validTime(t))return c.json({error:\"Valid date and time (09:00–18:00 IST) are required\"},400);const lead=await sqlite.execute({sql:`SELECT counsellor_id FROM leads WHERE id=?`,args:[Number(b.lead_id)]});if(!lead.rows[0])return c.json({error:\"Lead not found\"},404);const cid=admin(c)?Number(b.counsellor_id||0):Number(u.user_id);if(!cid)return c.json({error:\"Counsellor is required\"},400);if(!admin(c)&&Number((lead.rows[0] as any).counsellor_id)!==Number(u.user_id))return c.json({error:\"You can only schedule follow-ups for assigned leads\"},403);await sqlite.execute({sql:`INSERT INTO follow_ups(lead_id,counsellor_id,scheduled_date,scheduled_time,status,created_at) VALUES(?,?,?,?, 'pending',datetime('now'))`,args:[Number(b.lead_id),cid,d,t]});await sqlite.execute({sql:`UPDATE leads SET counsellor_id=?,updated_at=datetime('now') WHERE id=?`,args:[cid,Number(b.lead_id)]});return c.json({ok:true})});\napp.post(\"/api/follow-ups/:id/complete\",auth,async c=>{const id=Number(c.req.param(\"id\")),b=await c.req.json(),u=c.get(\"user\"),note=String(b.note||\"\").trim(),nd=String(b.next_followup_date||\"\"),nt=String(b.next_followup_time||\"\");if(note.length<2)return c.json({error:\"Follow-Up Notes are required\"},400);if((nd&&!nt)||(!nd&&nt)||(nt&&!validTime(nt)))return c.json({error:\"Next follow-up date/time are required together and time must be 09:00–18:00 IST\"},400);const r=await sqlite.execute({sql:`SELECT * FROM follow_ups WHERE id=? AND status='pending' LIMIT 1`,args:[id]});if(!r.rows[0])return c.json({error:\"Follow-up is missing or already completed\"},404);const f=r.rows[0] as any;if(u.role!==\"super_admin\"&&Number(f.counsellor_id)!==Number(u.user_id))return c.json({error:\"You can only complete your own follow-ups\"},403);const stm:any[]=[{sql:`UPDATE follow_ups SET completed_at=?,note=?,next_followup_date=?,next_followup_time=?,status='completed' WHERE id=?`,args:[nowIST(),note,nd||null,nt||null,id]}];if(nd)stm.push({sql:`INSERT INTO follow_ups(lead_id,counsellor_id,scheduled_date,scheduled_time,status,created_at) VALUES(?,?,?,?, 'pending',datetime('now'))`,args:[f.lead_id,f.counsellor_id,nd,nt]});await sqlite.batch(stm);return c.json({ok:true})});\napp.get(\"/api/follow-ups\",auth,async c=>{const q=c.req.query(),u=c.get(\"user\"),p:any[]=[],w:string[]=[],today=todayIST(),now=timeIST(),mode=q.mode||\"today\";if(u.role!==\"super_admin\"){w.push(`f.counsellor_id=?`);p.push(Number(u.user_id))}if(mode==='today'){w.push(`f.scheduled_date=? AND f.status='pending'`);p.push(today)}else if(mode==='overdue'){w.push(`f.status='pending' AND (f.scheduled_date? OR (f.scheduled_date=? AND f.scheduled_time>=?))`);p.push(today,today,now)}else if(mode==='completed')w.push(`f.status='completed'`);else w.push(`1=1`);if(q.counsellor){w.push(`f.counsellor_id=?`);p.push(q.counsellor)}if(q.candidate){w.push(`(l.candidate_name LIKE ? OR l.ec_id LIKE ? OR l.phone LIKE ?)`);p.push(`%${q.candidate}%`,`%${q.candidate}%`,`%${q.candidate}%`)}const r=await sqlite.execute({sql:`SELECT f.*,l.candidate_name,l.ec_id,l.phone,l.country,l.program,l.status lead_status,u.name counsellor_name FROM follow_ups f JOIN leads l ON l.id=f.lead_id JOIN users u ON u.id=f.counsellor_id WHERE ${w.join(' AND ')} ORDER BY f.scheduled_date ASC,f.scheduled_time ASC,f.id DESC`,args:p});return c.json({items:r.rows,today,now})});\napp.get(\"/api/dashboard\",auth,async c=>{const u=c.get(\"user\"),today=todayIST(),now=timeIST(),p:any[]=[today,today,today,now],scope=u.role==='super_admin'?``:` AND f.counsellor_id=${Number(u.user_id)}`,leadScope=u.role==='super_admin'?``:` WHERE counsellor_id=${Number(u.user_id)}`;const k=await sqlite.execute({sql:`SELECT (SELECT COUNT(*) FROM leads${leadScope}) total,(SELECT COUNT(*) FROM leads WHERE date(created_at)=date('now')${u.role==='super_admin'?'':` AND counsellor_id=${Number(u.user_id)}`}) new_leads,(SELECT COUNT(*) FROM follow_ups f WHERE f.status='pending' AND f.scheduled_date=?${scope}) today,(SELECT COUNT(*) FROM follow_ups f WHERE f.status='pending' AND (f.scheduled_date{console.error(err);return new Response(\"Internal Server Error\",{status:500})});\nexport default app.fetch;\n","label","europecrm",[138],"71616360-1ec5-4bbf-af03-a90c1a92e013",["D",1789031275653],2,[28],"c0eca97f-4777-4071-ae4c-127e6f7d808f","README.md","01a08a70-b0f3-7058-9d1e-07eb950f89b8",1,["D",1789029036131],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"root.tsx\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[154],"d8991706-f27d-4a75-8a01-f1f4e32c43b3","CHANGELOG.md","01a08a70-b0f3-7058-9d1e-010ffdae1146",["D",1789029036131],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v27