[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_300":301,"_302":303},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_226":-5,"_20":227,"_22":228,"_229":230,"_231":232,"_26":233,"_24":234,"_235":-5,"_236":-5,"_237":67,"_238":239,"_240":62,"_241":-5,"_242":-5,"_243":244},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Ado","name","group-187-attendance","branchName","main","version","path","frontend/index.html","project",{"_33":169,"_13":14,"_46":170,"_171":-5,"_172":67,"_173":174,"_175":174,"_176":177,"_178":-5,"_179":180,"_181":-5,"_182":67,"_183":-5,"_184":-5,"_185":60,"_186":187,"_188":189,"_190":191,"_192":193,"_194":-5,"_195":196,"_197":196,"_198":199,"_200":199,"_201":199,"_202":196,"_203":196,"_204":205,"_206":207,"_208":209,"_210":67},"tree",[53,54,55,56],"file",{"_33":34,"_35":36,"_37":38,"_13":39,"_40":41,"_42":24,"_17":43,"_44":45,"_46":47,"_48":49,"_50":-5,"_18":51},"contents",[],"upstream","pull","ahead","behind","envVars","id","a6943356-598f-11f1-98f0-ee650bb23af1","branchId","96ad0f58-598f-11f1-b217-ee650bb23af1","fileId","a6943428-598f-11f1-98f0-ee650bb23af1","index.html","content","\n\n\n \n \n Group 187 - Charia B | UDS Attendance\n \n \n \n\n\n

\n \n\n\n","fileType",0,"parentId","9965e940-598f-11f1-b217-ee650bb23af1","createdAt",["D",1779860893504],"branchVersion",6,"label",[52,39],"frontend",{"_33":144,"_13":145,"_37":146,"_44":-5,"_35":36,"_48":147,"_61":62,"_46":148,"_17":43,"_42":82,"_40":-5,"_66":67,"_50":-5,"_68":149,"_18":150},{"_33":79,"_13":52,"_37":45,"_44":-5,"_35":36,"_48":80,"_61":62,"_46":81,"_17":43,"_42":82,"_40":-5,"_66":67,"_50":-5,"_68":83,"_18":84},{"_33":71,"_13":72,"_37":73,"_44":-5,"_35":36,"_48":74,"_61":62,"_46":75,"_17":43,"_42":24,"_40":76,"_66":67,"_50":-5,"_68":77,"_18":78},{"_33":57,"_13":58,"_37":59,"_44":-5,"_35":36,"_48":60,"_61":62,"_46":63,"_17":43,"_42":64,"_40":65,"_66":67,"_50":-5,"_68":69,"_18":70},"96afbafa-598f-11f1-b217-ee650bb23af1","main.tsx","96afbbcc-598f-11f1-b217-ee650bb23af1",1,"latest",true,["D",1779860866841],"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","deleted",false,"children",[],[58],"ee1cd124-598f-11f1-b49e-ee650bb23af1","README.md","ee1cd1d8-598f-11f1-b49e-ee650bb23af1",13,["D",1779861013518],"# 🎓 Group 187 — Charia B Community Attendance\n\n**University for Development Studies (UDS)** — Member Registration & Daily Attendance System\n\n## Features\n\n- **Register Members** — Add group members with their index number (format: `ABC/XXXX/25`), full name, and optional phone number\n- **Sign Daily Attendance** — Members search their name and tap to sign attendance each day (one sign per day)\n- **View Records** — Browse attendance records for any date\n- **Summary Dashboard** — See total attendance days per member with progress bars\n\n## Architecture\n\n```mermaid\ngraph TD\n A[Frontend - React + Twind] -->|API calls| B[Backend - Hono]\n B -->|SQLite| C[(Database)]\n B -->|Serves| A\n```\n\n## API Endpoints\n\n| Method | Endpoint | Description |\n|--------|----------|-------------|\n| `POST` | `/api/members` | Register a new member |\n| `GET` | `/api/members` | List all members (optional `?search=`) |\n| `DELETE` | `/api/members/:id` | Remove a member |\n| `POST` | `/api/attendance` | Sign attendance for a member |\n| `GET` | `/api/attendance` | Get records for a date (optional `?date=`) |\n| `GET` | `/api/attendance/summary` | Get per-member attendance totals |\n",[],[72],"9965e878-598f-11f1-b217-ee650bb23af1",3,["D",1779860871391],"directory",[85,86,87,88,89,90,91],[52],{"_33":136,"_13":137,"_37":138,"_44":45,"_35":36,"_48":139,"_61":62,"_46":140,"_17":43,"_42":97,"_40":141,"_66":67,"_50":-5,"_68":142,"_18":143},{"_33":128,"_13":129,"_37":130,"_44":45,"_35":36,"_48":131,"_61":62,"_46":132,"_17":43,"_42":97,"_40":133,"_66":67,"_50":-5,"_68":134,"_18":135},{"_33":120,"_13":121,"_37":122,"_44":45,"_35":36,"_48":123,"_61":62,"_46":124,"_17":43,"_42":97,"_40":125,"_66":67,"_50":-5,"_68":126,"_18":127},{"_33":112,"_13":113,"_37":114,"_44":45,"_35":36,"_48":115,"_61":62,"_46":116,"_17":43,"_42":97,"_40":117,"_66":67,"_50":-5,"_68":118,"_18":119},{"_33":104,"_13":105,"_37":106,"_44":45,"_35":36,"_48":107,"_61":62,"_46":108,"_17":43,"_42":97,"_40":109,"_66":67,"_50":-5,"_68":110,"_18":111},{"_33":34,"_13":39,"_37":38,"_44":45,"_35":36,"_48":49,"_61":62,"_46":101,"_17":43,"_42":24,"_40":41,"_66":67,"_50":-5,"_68":102,"_18":103},{"_33":92,"_13":93,"_37":94,"_44":45,"_35":36,"_48":95,"_61":62,"_46":96,"_17":43,"_42":97,"_40":98,"_66":67,"_50":-5,"_68":99,"_18":100},"a7a8bfd2-598f-11f1-86aa-ee650bb23af1","index.tsx","a7a8c0b8-598f-11f1-86aa-ee650bb23af1",7,["D",1779860895316],"script","/** @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",[],[52,93],["D",1779860893504],[],[52,39],"d496e6ae-598f-11f1-b49e-ee650bb23af1","ViewRecords.tsx","d496e74e-598f-11f1-b49e-ee650bb23af1",11,["D",1779860970697],"/** @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",[],[52,105],"db54bf98-598f-11f1-86aa-ee650bb23af1","Summary.tsx","db54c042-598f-11f1-86aa-ee650bb23af1",12,["D",1779860982008],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface SummaryRow {\n id: number;\n index_number: string;\n full_name: string;\n total_days: number;\n last_attended: string | null;\n}\n\nexport function Summary() {\n const [data, setData] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetch(\"/api/attendance/summary\")\n .then((r) => r.json())\n .then((d) => { setData(d); setLoading(false); })\n .catch(() => setLoading(false));\n }, []);\n\n const maxDays = Math.max(...data.map((d) => d.total_days), 1);\n\n return (\n

\n \n Attendance Summary\n

\n Total attendance days per member across all dates.\n

\n\n {loading ? (\n

\n \n

Loading summary...

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

\n \n

No data yet. Register members and sign attendance first.

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n \n {data.map((row, i) => (\n \n \n \n \n \n \n \n ))}\n \n

#	Index No.	Full Name	Days Present	Last Seen
{i + 1}	{row.index_number}	{row.full_name}	\n \n \n \n \n {row.total_days}\n \n	\n {row.last_attended\n ? new Date(row.last_attended + \"T00:00:00\").toLocaleDateString(\"en-GB\", {\n day: \"numeric\",\n month: \"short\",\n year: \"numeric\",\n })\n : \"Never\"}\n

\n )}\n

\n );\n}\n",[],[52,113],"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",[],[52,121],"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",[],[52,129],"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",[],[52,137],"994d0e2a-598f-11f1-b217-ee650bb23af1","database","994d0ed4-598f-11f1-b217-ee650bb23af1",2,["D",1779860871228],[151,152],[145],{"_33":161,"_13":162,"_37":163,"_44":146,"_35":36,"_48":164,"_61":62,"_46":165,"_17":43,"_42":97,"_40":166,"_66":67,"_50":-5,"_68":167,"_18":168},{"_33":153,"_13":154,"_37":155,"_44":146,"_35":36,"_48":156,"_61":62,"_46":157,"_17":43,"_42":97,"_40":158,"_66":67,"_50":-5,"_68":159,"_18":160},"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",[],[145,154],"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",[],[145,162],"96ac6b7a-598f-11f1-b217-ee650bb23af1",["D",1779860866826],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Group 187 Charia B - UDS Member Registration & Attendance","imageUrl","userId","8f6d5f70-08e8-11f0-b10f-e5a2093a590f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_225":221},"org",{"_11":12,"_219":-5,"_220":221,"_179":180,"_222":223,"_224":67},"branch",{"_17":74,"_13":16,"_33":36,"_211":169,"_212":-5,"_213":-5,"_214":-5,"_215":-5,"_216":-5,"_217":14,"_218":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ1bUVvQndtZUNSRmZyQkpiYklWdVR0d3VFZCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":169,"_13":14,"_46":295,"_171":-5,"_172":67,"_173":174,"_175":174,"_176":177,"_178":-5,"_179":180,"_181":-5,"_182":67,"_183":-5,"_184":-5,"_185":60,"_186":187,"_188":189,"_190":191,"_192":296,"_194":-5,"_195":196,"_197":196,"_198":199,"_200":199,"_201":199,"_202":196,"_203":196,"_204":297,"_206":298,"_208":299,"_210":67},[256,259,267,268],"files",[256,257,258,259,260,261,262,263,264,265,266,267,268],"counts",{"_247":43,"_248":60,"_249":43,"_32":250,"_251":252},[],{"_33":34,"_13":39,"_37":38,"_44":45,"_35":36,"_48":49,"_61":62,"_46":245,"_17":43,"_42":24,"_40":41,"_66":67,"_50":-5,"_18":246},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1779860893504],[52,39],"pulls","branches","forks",{"_253":43,"_255":43},"connections",{"_253":43,"_254":43},"count","unfilledCount","emptyCount",{"_33":144,"_13":145,"_37":146,"_44":-5,"_35":36,"_48":147,"_61":62,"_46":148,"_17":43,"_42":82,"_40":-5,"_66":67,"_50":-5,"_68":293,"_18":294},{"_33":161,"_13":162,"_37":163,"_44":146,"_35":36,"_48":164,"_61":62,"_46":165,"_17":43,"_42":97,"_40":166,"_66":67,"_50":-5,"_68":291,"_18":292},{"_33":153,"_13":154,"_37":155,"_44":146,"_35":36,"_48":156,"_61":62,"_46":157,"_17":43,"_42":97,"_40":158,"_66":67,"_50":-5,"_68":289,"_18":290},{"_33":79,"_13":52,"_37":45,"_44":-5,"_35":36,"_48":80,"_61":62,"_46":81,"_17":43,"_42":82,"_40":-5,"_66":67,"_50":-5,"_68":287,"_18":288},{"_33":136,"_13":137,"_37":138,"_44":45,"_35":36,"_48":139,"_61":62,"_46":140,"_17":43,"_42":97,"_40":141,"_66":67,"_50":-5,"_68":285,"_18":286},{"_33":128,"_13":129,"_37":130,"_44":45,"_35":36,"_48":131,"_61":62,"_46":132,"_17":43,"_42":97,"_40":133,"_66":67,"_50":-5,"_68":283,"_18":284},{"_33":120,"_13":121,"_37":122,"_44":45,"_35":36,"_48":123,"_61":62,"_46":124,"_17":43,"_42":97,"_40":125,"_66":67,"_50":-5,"_68":281,"_18":282},{"_33":112,"_13":113,"_37":114,"_44":45,"_35":36,"_48":115,"_61":62,"_46":116,"_17":43,"_42":97,"_40":117,"_66":67,"_50":-5,"_68":279,"_18":280},{"_33":104,"_13":105,"_37":106,"_44":45,"_35":36,"_48":107,"_61":62,"_46":108,"_17":43,"_42":97,"_40":109,"_66":67,"_50":-5,"_68":277,"_18":278},{"_33":34,"_13":39,"_37":38,"_44":45,"_35":36,"_48":49,"_61":62,"_46":101,"_17":43,"_42":24,"_40":41,"_66":67,"_50":-5,"_68":275,"_18":276},{"_33":92,"_13":93,"_37":94,"_44":45,"_35":36,"_48":95,"_61":62,"_46":96,"_17":43,"_42":97,"_40":98,"_66":67,"_50":-5,"_68":273,"_18":274},{"_33":71,"_13":72,"_37":73,"_44":-5,"_35":36,"_48":74,"_61":62,"_46":75,"_17":43,"_42":24,"_40":76,"_66":67,"_50":-5,"_68":271,"_18":272},{"_33":57,"_13":58,"_37":59,"_44":-5,"_35":36,"_48":60,"_61":62,"_46":63,"_17":43,"_42":64,"_40":65,"_66":67,"_50":-5,"_68":269,"_18":270},[],[58],[],[72],[],[52,93],[],[52,39],[],[52,105],[],[52,113],[],[52,121],[],[52,129],[],[52,137],[260,261,262,263,264,265,266],[52],[],[145,154],[],[145,162],[257,258],[145],["D",1779860866826],["D",1789518676100],{"_11":12,"_225":221},{"_11":12,"_219":-5,"_220":221,"_179":180,"_222":223,"_224":67},{"_17":74,"_13":16,"_33":36,"_211":169,"_212":-5,"_213":-5,"_214":-5,"_215":-5,"_216":-5,"_217":14,"_218":12},"ctx",{"_204":-5,"_242":333,"_334":335,"_336":337,"_338":67,"_339":67,"_340":67,"_341":62,"_342":-5,"_343":-7,"_344":-7,"_345":43,"_346":67,"_347":67,"_348":-5,"_349":67,"_350":67,"_351":67,"_352":-5},"ENV",{"_304":305,"_306":307,"_308":16,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332},"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"]