[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_257":258,"_259":260},"routes/_app.x.$handle.$name",{"_103":102,"_37":50,"_111":93,"_32":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":30,"_126":127,"_128":129,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":-5,"_62":30,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",11,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","3a84d427-9b3c-4400-b407-31cf5939dbce","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/ViewRecords.tsx","latestPath","fileId","d496e74e-598f-11f1-b49e-ee650bb23af1","name","ViewRecords.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface AttendanceRecord {\n id: number;\n date: string;\n signed_at: string;\n index_number: string;\n full_name: string;\n phone: string | null;\n}\n\nexport function ViewRecords() {\n const [records, setRecords] = useState([]);\n const [date, setDate] = useState(new Date().toISOString().split(\"T\")[0]);\n const [loading, setLoading] = useState(false);\n\n const fetchRecords = async () => {\n setLoading(true);\n try {\n const res = await fetch(`/api/attendance?date=${date}`);\n const data = await res.json();\n setRecords(data);\n } catch {\n console.error(\"Failed to fetch records\");\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchRecords();\n }, [date]);\n\n const displayDate = new Date(date + \"T00:00:00\").toLocaleDateString(\"en-GB\", {\n weekday: \"long\",\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n });\n\n return (\n

\n {/* Date Picker */}\n

\n \n Select Date\n

\n setDate(e.target.value)}\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 outline-none transition text-gray-800\"\n />\n

{displayDate}

\n\n {/* Records Table */}\n

\n \n Attendance Records\n

\n \n {records.length} present\n \n

\n\n {loading ? (\n

\n \n

Loading records...

\n ) : records.length === 0 ? (\n

\n \n

No attendance records for this date.

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n {records.map((r, i) => (\n \n \n \n \n \n \n ))}\n \n

#	Index No.	Full Name	Time Signed
{i + 1}	{r.index_number}	{r.full_name}	\n {new Date(r.signed_at + \"Z\").toLocaleTimeString(\"en-GB\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n })}\n

\n )}\n

\n );\n}\n","createdAt",["D",1779860970697],"branchVersion","branchId","96ad0f58-598f-11f1-b217-ee650bb23af1","id","96ac6b7a-598f-11f1-b217-ee650bb23af1","group-187-attendance",["D",1779860866826],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Group 187 Charia B - UDS Member Registration & Attendance","imageUrl","8f6d5f70-08e8-11f0-b10f-e5a2093a590f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","609c7a35-8c11-4cc7-8fbe-7b6ea5f8bf62","tursoName","96ac6b7a598f11f1b217ee650bb23af1","tursoHostname","96ac6b7a598f11f1b217ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518676100],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":106},"org",{"_103":102,"_104":-5,"_105":106,"_19":60,"_107":108,"_109":30},"branch",{"_13":92,"_37":93,"_48":47,"_94":49,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":50,"_101":102},"isOwned",13,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Ado","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ1bUVvQndtZUNSRmZyQkpiYklWdVR0d3VFZCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":252,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":-5,"_62":30,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":253,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":254,"_87":255,"_89":256,"_91":30},"tree",[171,174,181],"files",[171,172,173,174,175,176,177,178,179,180,181],"counts",{"_161":143,"_162":66,"_163":143,"_164":165,"_166":167},"contents",[134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_48":155,"_37":156,"_35":157,"_140":-5,"_46":47,"_45":158,"_141":129,"_43":159,"_13":143,"_39":153,"_41":-5,"_29":30,"_146":-5,"_32":160},{"_48":148,"_37":149,"_35":150,"_140":-5,"_46":47,"_45":151,"_141":129,"_43":152,"_13":143,"_39":153,"_41":-5,"_29":30,"_146":-5,"_32":154},{"_48":137,"_37":138,"_35":139,"_140":-5,"_46":47,"_45":66,"_141":129,"_43":142,"_13":143,"_39":144,"_41":145,"_29":30,"_146":-5,"_32":147},"96afbafa-598f-11f1-b217-ee650bb23af1","main.tsx","96afbbcc-598f-11f1-b217-ee650bb23af1","parentId","latest",["D",1779860866841],0,"http","import { Hono } from \"npm:hono@4\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n registerMember,\n getMembers,\n signAttendance,\n getAttendanceByDate,\n getAttendanceSummary,\n deleteMember,\n} from \"./database/queries.ts\";\n\nconst app = new Hono();\n\nlet migrated = false;\nasync function ensureMigrated() {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n}\n\napp.onError((err) => Promise.reject(err));\n\napp.post(\"/api/members\", async (c) => {\n await ensureMigrated();\n const body = await c.req.json();\n const { indexNumber, fullName, phone } = body;\n if (!indexNumber || !fullName) {\n return c.json({ success: false, message: \"Index number and full name are required.\" }, 400);\n }\n const idPattern = /^[A-Z]{2,4}\\/\\d{4}\\/\\d{2}$/i;\n if (!idPattern.test(indexNumber.trim())) {\n return c.json({ success: false, message: \"Invalid index number format. Use: ABC/XXXX/25\" }, 400);\n }\n const result = await registerMember(indexNumber.trim().toUpperCase(), fullName.trim(), phone?.trim() || null);\n return c.json(result, result.success ? 201 : 409);\n});\n\napp.get(\"/api/members\", async (c) => {\n await ensureMigrated();\n const search = c.req.query(\"search\") || undefined;\n const members = await getMembers(search);\n return c.json(members);\n});\n\napp.delete(\"/api/members/:id\", async (c) => {\n await ensureMigrated();\n const id = Number(c.req.param(\"id\"));\n const result = await deleteMember(id);\n return c.json(result);\n});\n\napp.post(\"/api/attendance\", async (c) => {\n await ensureMigrated();\n const body = await c.req.json();\n const { memberId } = body;\n if (!memberId) {\n return c.json({ success: false, message: \"Member ID is required.\" }, 400);\n }\n const result = await signAttendance(Number(memberId));\n return c.json(result, result.success ? 200 : 409);\n});\n\napp.get(\"/api/attendance\", async (c) => {\n await ensureMigrated();\n const date = c.req.query(\"date\") || undefined;\n const records = await getAttendanceByDate(date);\n return c.json(records);\n});\n\napp.get(\"/api/attendance/summary\", async (c) => {\n await ensureMigrated();\n const summary = await getAttendanceSummary();\n return c.json(summary);\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/frontend/*\", async (c) => serveFile(c.req.path));\napp.get(\"/*\", async (c) => serveFile(\"/frontend/index.html\"));\n\nexport default app.fetch;\n","label",[138],"9965e878-598f-11f1-b217-ee650bb23af1","frontend","9965e940-598f-11f1-b217-ee650bb23af1",3,["D",1779860871391],"directory",[149],"994d0e2a-598f-11f1-b217-ee650bb23af1","database","994d0ed4-598f-11f1-b217-ee650bb23af1",2,["D",1779860871228],[156],"pulls","branches","forks","envVars",{"_168":143,"_170":143},"connections",{"_168":143,"_169":143},"count","unfilledCount","emptyCount",{"_48":155,"_37":156,"_35":157,"_140":-5,"_46":47,"_45":158,"_141":129,"_43":249,"_13":143,"_39":153,"_41":-5,"_29":30,"_146":-5,"_183":250,"_32":251},{"_48":241,"_37":242,"_35":243,"_140":157,"_46":47,"_45":244,"_141":129,"_43":245,"_13":143,"_39":40,"_41":246,"_29":30,"_146":-5,"_183":247,"_32":248},{"_48":233,"_37":234,"_35":235,"_140":157,"_46":47,"_45":236,"_141":129,"_43":237,"_13":143,"_39":40,"_41":238,"_29":30,"_146":-5,"_183":239,"_32":240},{"_48":148,"_37":149,"_35":150,"_140":-5,"_46":47,"_45":151,"_141":129,"_43":230,"_13":143,"_39":153,"_41":-5,"_29":30,"_146":-5,"_183":231,"_32":232},{"_48":222,"_37":223,"_35":224,"_140":150,"_46":47,"_45":225,"_141":129,"_43":226,"_13":143,"_39":40,"_41":227,"_29":30,"_146":-5,"_183":228,"_32":229},{"_48":214,"_37":215,"_35":216,"_140":150,"_46":47,"_45":217,"_141":129,"_43":218,"_13":143,"_39":40,"_41":219,"_29":30,"_146":-5,"_183":220,"_32":221},{"_48":206,"_37":207,"_35":208,"_140":150,"_46":47,"_45":209,"_141":129,"_43":210,"_13":143,"_39":40,"_41":211,"_29":30,"_146":-5,"_183":212,"_32":213},{"_48":202,"_37":38,"_35":36,"_140":150,"_46":47,"_45":14,"_141":129,"_43":203,"_13":143,"_39":40,"_41":42,"_29":30,"_146":-5,"_183":204,"_32":205},{"_48":194,"_37":195,"_35":196,"_140":150,"_46":47,"_45":197,"_141":129,"_43":198,"_13":143,"_39":26,"_41":199,"_29":30,"_146":-5,"_183":200,"_32":201},{"_48":186,"_37":187,"_35":188,"_140":150,"_46":47,"_45":189,"_141":129,"_43":190,"_13":143,"_39":40,"_41":191,"_29":30,"_146":-5,"_183":192,"_32":193},{"_48":137,"_37":138,"_35":139,"_140":-5,"_46":47,"_45":66,"_141":129,"_43":182,"_13":143,"_39":144,"_41":145,"_29":30,"_146":-5,"_183":184,"_32":185},["D",1779860866841],"children",[],[138],"a7a8bfd2-598f-11f1-86aa-ee650bb23af1","index.tsx","a7a8c0b8-598f-11f1-86aa-ee650bb23af1",7,["D",1779860895316],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport ReactDOM from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\n\nconst root = ReactDOM.createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[149,187],"a6943356-598f-11f1-98f0-ee650bb23af1","index.html","a6943428-598f-11f1-98f0-ee650bb23af1",6,["D",1779860893504],"\n\n\n \n \n Group 187 - Charia B | UDS Attendance\n \n \n \n\n\n

\n \n\n\n",[],[149,195],"d496e6ae-598f-11f1-b49e-ee650bb23af1",["D",1779860970697],[],[149,38],"cba50b0c-598f-11f1-b49e-ee650bb23af1","SignAttendance.tsx","cba50bb6-598f-11f1-b49e-ee650bb23af1",10,["D",1779860955690],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Member {\n id: number;\n index_number: string;\n full_name: string;\n}\n\nexport function SignAttendance() {\n const [members, setMembers] = useState([]);\n const [search, setSearch] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [signingId, setSigningId] = useState(null);\n const [message, setMessage] = useState<{ type: \"success\" | \"error\"; text: string } | null>(null);\n const [todayCount, setTodayCount] = useState(0);\n\n useEffect(() => {\n fetch(\"/api/members\").then((r) => r.json()).then(setMembers);\n fetch(\"/api/attendance\").then((r) => r.json()).then((data) => setTodayCount(data.length));\n }, []);\n\n const filtered = search\n ? members.filter(\n (m) =>\n m.full_name.toLowerCase().includes(search.toLowerCase()) ||\n m.index_number.toLowerCase().includes(search.toLowerCase()),\n )\n : members;\n\n const handleSign = async (memberId: number) => {\n setMessage(null);\n setSigningId(memberId);\n try {\n const res = await fetch(\"/api/attendance\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ memberId }),\n });\n const data = await res.json();\n setMessage({ type: data.success ? \"success\" : \"error\", text: data.message });\n if (data.success) {\n setTodayCount((c) => c + 1);\n }\n } catch {\n setMessage({ type: \"error\", text: \"Network error. Please try again.\" });\n } finally {\n setSigningId(null);\n }\n };\n\n const today = new Date().toLocaleDateString(\"en-GB\", {\n weekday: \"long\",\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n });\n\n return (\n

\n {/* Date & Stats */}\n

\n \n

Today's Date

{today}

\n \n

Signed Today

{todayCount} / {members.length} members

\n\n {/* Message */}\n {message && (\n

\n \n {message.text}\n

\n )}\n\n {/* Sign Attendance */}\n

\n \n Sign Attendance\n

\n\n

\n setSearch(e.target.value)}\n placeholder=\"Search your name or index number...\"\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 outline-none transition text-gray-800\"\n />\n

\n\n {members.length === 0 ? (\n

\n \n

No members registered. Go to Register tab first.

\n ) : filtered.length === 0 ? (\n

\n \n

No matching members found.

\n ) : (\n

\n {filtered.map((m) => (\n \n

{m.full_name}

{m.index_number}

\n handleSign(m.id)}\n disabled={signingId === m.id}\n className=\"bg-indigo-600 hover:bg-indigo-700 disabled:bg-gray-400 text-white px-4 py-2 rounded-lg text-sm font-medium transition-all active:scale-95\"\n >\n {signingId === m.id ? (\n \n ) : (\n Sign\n )}\n \n

\n ))}\n

\n )}\n

\n \n );\n}\n",[],[149,207],"c0d51de8-598f-11f1-95cf-ee650bb23af1","RegisterMember.tsx","c0d51eb0-598f-11f1-95cf-ee650bb23af1",9,["D",1779860937551],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Member {\n id: number;\n index_number: string;\n full_name: string;\n phone: string | null;\n registered_at: string;\n}\n\nexport function RegisterMember() {\n const [indexNumber, setIndexNumber] = useState(\"\");\n const [fullName, setFullName] = useState(\"\");\n const [phone, setPhone] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [message, setMessage] = useState<{ type: \"success\" | \"error\"; text: string } | null>(null);\n const [members, setMembers] = useState([]);\n const [search, setSearch] = useState(\"\");\n\n const fetchMembers = async () => {\n const params = search ? `?search=${encodeURIComponent(search)}` : \"\";\n const res = await fetch(`/api/members${params}`);\n const data = await res.json();\n setMembers(data);\n };\n\n useEffect(() => {\n fetchMembers();\n }, [search]);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setMessage(null);\n setLoading(true);\n try {\n const res = await fetch(\"/api/members\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ indexNumber, fullName, phone: phone || undefined }),\n });\n const data = await res.json();\n setMessage({ type: data.success ? \"success\" : \"error\", text: data.message });\n if (data.success) {\n setIndexNumber(\"\");\n setFullName(\"\");\n setPhone(\"\");\n fetchMembers();\n }\n } catch {\n setMessage({ type: \"error\", text: \"Network error. Please try again.\" });\n } finally {\n setLoading(false);\n }\n };\n\n const handleDelete = async (id: number, name: string) => {\n if (!confirm(`Remove ${name} from the group?`)) return;\n await fetch(`/api/members/${id}`, { method: \"DELETE\" });\n fetchMembers();\n };\n\n return (\n

\n {/* Registration Form */}\n

\n \n Register New Member\n

\n\n {message && (\n

\n \n {message.text}\n

\n )}\n\n

\n \n Index Number *\n \n setIndexNumber(e.target.value.toUpperCase())}\n placeholder=\"e.g. ABC/1234/25\"\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 outline-none transition text-gray-800 font-mono\"\n required\n />\n

Format: ABC/XXXX/25

\n\n

\n \n Full Name *\n \n setFullName(e.target.value)}\n placeholder=\"e.g. Adombire Atanga Lazurus\"\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 outline-none transition text-gray-800\"\n required\n />\n

\n\n

\n \n Phone Number (optional)\n \n setPhone(e.target.value)}\n placeholder=\"e.g. 0241234567\"\n className=\"w-full px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 outline-none transition text-gray-800\"\n />\n

\n\n \n {loading ? (\n Registering...\n ) : (\n Register Member\n )}\n \n \n

\n\n {/* Members List */}\n

\n \n Registered Members\n

\n \n {members.length} member{members.length !== 1 ? \"s\" : \"\"}\n \n

\n\n

\n setSearch(e.target.value)}\n placeholder=\"Search by name or index number...\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 outline-none transition text-gray-800 text-sm\"\n />\n

\n\n {members.length === 0 ? (\n

\n \n

No members registered yet.

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n \n {members.map((m, i) => (\n \n \n \n \n \n \n \n ))}\n \n

#	Index No.	Full Name	Phone
{i + 1}	{m.index_number}	{m.full_name}	{m.phone \|\| \"—\"}	\n handleDelete(m.id, m.full_name)}\n className=\"text-red-400 hover:text-red-600 transition\"\n title=\"Remove member\"\n >\n \n \n

\n )}\n

\n );\n}\n",[],[149,215],"b14fc72e-598f-11f1-95cf-ee650bb23af1","App.tsx","b14fc7ec-598f-11f1-95cf-ee650bb23af1",8,["D",1779860911511],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { RegisterMember } from \"./RegisterMember.tsx\";\nimport { SignAttendance } from \"./SignAttendance.tsx\";\nimport { ViewRecords } from \"./ViewRecords.tsx\";\nimport { Summary } from \"./Summary.tsx\";\n\ntype Page = \"register\" | \"sign\" | \"records\" | \"summary\";\n\nexport function App() {\n const [page, setPage] = useState(\"sign\");\n\n const tabs: { key: Page; label: string; icon: string }[] = [\n { key: \"sign\", label: \"Sign\", icon: \"fa-pen-to-square\" },\n { key: \"register\", label: \"Register\", icon: \"fa-user-plus\" },\n { key: \"records\", label: \"Records\", icon: \"fa-list-check\" },\n { key: \"summary\", label: \"Summary\", icon: \"fa-chart-bar\" },\n ];\n\n return (\n

\n {/* Header */}\n

\n 🎓\n

Group 187 — Charia B Community

University for Development Studies (UDS)

\n\n {/* Navigation */}\n \n\n {/* Main Content */}\n

\n {page === \"register\" && }\n {page === \"sign\" && }\n {page === \"records\" && }\n {page === \"summary\" &&

}\n

\n\n {/* Footer */}\n \n

\n );\n}\n",[],[149,223],["D",1779860871391],[175,176,177,178,179,180],[149],"a2932adc-598f-11f1-98f0-ee650bb23af1","queries.ts","a2932b72-598f-11f1-98f0-ee650bb23af1",5,["D",1779860886786],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function registerMember(indexNumber: string, fullName: string, phone: string | null) {\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM members WHERE index_number = ?\",\n args: [indexNumber],\n });\n if (existing.rows.length > 0) {\n return { success: false, message: \"A member with this index number is already registered.\" };\n }\n await sqlite.execute({\n sql: \"INSERT INTO members (index_number, full_name, phone) VALUES (?, ?, ?)\",\n args: [indexNumber, fullName, phone],\n });\n return { success: true, message: `${fullName} registered successfully!` };\n}\n\nexport async function getMembers(search?: string) {\n if (search) {\n const result = await sqlite.execute({\n sql: `SELECT * FROM members \n WHERE index_number LIKE ? OR full_name LIKE ? \n ORDER BY full_name ASC`,\n args: [`%${search}%`, `%${search}%`],\n });\n return result.rows;\n }\n const result = await sqlite.execute(\"SELECT * FROM members ORDER BY full_name ASC\");\n return result.rows;\n}\n\nexport async function deleteMember(id: number) {\n await sqlite.execute({ sql: \"DELETE FROM attendance WHERE member_id = ?\", args: [id] });\n await sqlite.execute({ sql: \"DELETE FROM members WHERE id = ?\", args: [id] });\n return { success: true, message: \"Member removed.\" };\n}\n\nexport async function signAttendance(memberId: number) {\n // Check member exists\n const member = await sqlite.execute({ sql: \"SELECT * FROM members WHERE id = ?\", args: [memberId] });\n if (member.rows.length === 0) {\n return { success: false, message: \"Member not found.\" };\n }\n\n // Check if already signed today\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM attendance WHERE member_id = ? AND date = date('now')\",\n args: [memberId],\n });\n if (existing.rows.length > 0) {\n return { success: false, message: \"This member has already signed attendance today.\" };\n }\n\n await sqlite.execute({\n sql: \"INSERT INTO attendance (member_id) VALUES (?)\",\n args: [memberId],\n });\n\n const m = member.rows[0] as any;\n return { success: true, message: `Attendance signed for ${m.full_name}!` };\n}\n\nexport async function getAttendanceByDate(date?: string) {\n const targetDate = date || \"date('now')\";\n const sql = date\n ? `SELECT a.id, a.date, a.signed_at, m.index_number, m.full_name, m.phone\n FROM attendance a JOIN members m ON a.member_id = m.id\n WHERE a.date = ? ORDER BY a.signed_at ASC`\n : `SELECT a.id, a.date, a.signed_at, m.index_number, m.full_name, m.phone\n FROM attendance a JOIN members m ON a.member_id = m.id\n WHERE a.date = date('now') ORDER BY a.signed_at ASC`;\n\n const result = date\n ? await sqlite.execute({ sql, args: [date] })\n : await sqlite.execute(sql);\n return result.rows;\n}\n\nexport async function getAttendanceSummary() {\n const result = await sqlite.execute(`\n SELECT m.id, m.index_number, m.full_name, \n COUNT(a.id) as total_days,\n MAX(a.date) as last_attended\n FROM members m\n LEFT JOIN attendance a ON m.id = a.member_id\n GROUP BY m.id\n ORDER BY m.full_name ASC\n `);\n return result.rows;\n}\n",[],[156,234],"9c6f17d8-598f-11f1-b217-ee650bb23af1","migrations.ts","9c6f1896-598f-11f1-b217-ee650bb23af1",4,["D",1779860876484],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS members (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n index_number TEXT NOT NULL UNIQUE,\n full_name TEXT NOT NULL,\n phone TEXT,\n registered_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS attendance (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n member_id INTEGER NOT NULL,\n date TEXT NOT NULL DEFAULT (date('now')),\n signed_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE CASCADE,\n UNIQUE(member_id, date)\n )`,\n },\n ]);\n}\n",[],[156,242],["D",1779860871228],[172,173],[156],["D",1779860866826],["D",1789518676100],{"_103":102,"_110":106},{"_103":102,"_104":-5,"_105":106,"_19":60,"_107":108,"_109":30},{"_13":92,"_37":93,"_48":47,"_94":49,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":50,"_101":102},"ctx",{"_85":-5,"_131":290,"_291":292,"_293":294,"_295":30,"_296":30,"_297":30,"_298":129,"_299":-5,"_300":-7,"_301":-7,"_302":143,"_303":30,"_304":30,"_305":-5,"_306":30,"_307":30,"_308":30,"_309":-5},"ENV",{"_261":262,"_263":264,"_265":93,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11