[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_334":335,"_336":337},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_246":-5,"_20":247,"_22":248,"_249":250,"_251":252,"_26":253,"_24":254,"_255":-5,"_256":-5,"_257":61,"_258":259,"_260":52,"_261":-5,"_262":-5,"_263":264},"routes/_app.x.$handle.$name.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","project",{"_40":189,"_13":14,"_53":190,"_191":-5,"_192":61,"_193":194,"_195":194,"_196":197,"_198":-5,"_199":200,"_201":-5,"_202":61,"_203":-5,"_204":-5,"_205":118,"_206":207,"_208":209,"_210":211,"_212":213,"_214":-5,"_215":216,"_217":216,"_218":219,"_220":219,"_221":219,"_222":216,"_223":216,"_224":225,"_226":227,"_228":229,"_230":61},"tree",[111,112,113,114],"file",{"_40":106,"_13":19,"_43":46,"_45":-5,"_47":48,"_49":107,"_51":52,"_53":108,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_18":110},"contents",[33,34,35,36,37,38,39],"upstream","pull","ahead","behind","envVars",{"_40":99,"_13":100,"_43":101,"_45":46,"_47":48,"_49":102,"_51":52,"_53":103,"_17":55,"_56":57,"_58":104,"_60":61,"_62":-5,"_18":105},{"_40":92,"_13":93,"_43":94,"_45":46,"_47":48,"_49":95,"_51":52,"_53":96,"_17":55,"_56":57,"_58":97,"_60":61,"_62":-5,"_18":98},{"_40":85,"_13":86,"_43":87,"_45":46,"_47":48,"_49":88,"_51":52,"_53":89,"_17":55,"_56":57,"_58":90,"_60":61,"_62":-5,"_18":91},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":82,"_17":55,"_56":57,"_58":83,"_60":61,"_62":-5,"_18":84},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":75,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_18":77},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":68,"_17":55,"_56":24,"_58":69,"_60":61,"_62":-5,"_18":70},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_18":63},"id","a7a8bfd2-598f-11f1-86aa-ee650bb23af1","index.tsx","fileId","a7a8c0b8-598f-11f1-86aa-ee650bb23af1","parentId","9965e940-598f-11f1-b217-ee650bb23af1","branchId","96ad0f58-598f-11f1-b217-ee650bb23af1","branchVersion",7,"latest",true,"createdAt",["D",1779860895316],0,"fileType","script","content","/** @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","deleted",false,"label",[19,42],"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",[19,65],"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",[19,72],"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",[19,79],"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",[19,86],"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",[19,93],"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",[19,100],"9965e878-598f-11f1-b217-ee650bb23af1",3,["D",1779860871391],"directory",[19],{"_40":164,"_13":165,"_43":166,"_45":-5,"_47":48,"_49":167,"_51":52,"_53":168,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_122":169,"_18":170},{"_40":106,"_13":19,"_43":46,"_45":-5,"_47":48,"_49":107,"_51":52,"_53":133,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_122":134,"_18":135},{"_40":125,"_13":126,"_43":127,"_45":-5,"_47":48,"_49":128,"_51":52,"_53":129,"_17":55,"_56":24,"_58":130,"_60":61,"_62":-5,"_122":131,"_18":132},{"_40":115,"_13":116,"_43":117,"_45":-5,"_47":48,"_49":118,"_51":52,"_53":119,"_17":55,"_56":120,"_58":121,"_60":61,"_62":-5,"_122":123,"_18":124},"96afbafa-598f-11f1-b217-ee650bb23af1","main.tsx","96afbbcc-598f-11f1-b217-ee650bb23af1",1,["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","children",[],[116],"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",[],[126],["D",1779860871391],[136,137,138,139,140,141,142],[19],{"_40":99,"_13":100,"_43":101,"_45":46,"_47":48,"_49":102,"_51":52,"_53":161,"_17":55,"_56":57,"_58":104,"_60":61,"_62":-5,"_122":162,"_18":163},{"_40":92,"_13":93,"_43":94,"_45":46,"_47":48,"_49":95,"_51":52,"_53":158,"_17":55,"_56":57,"_58":97,"_60":61,"_62":-5,"_122":159,"_18":160},{"_40":85,"_13":86,"_43":87,"_45":46,"_47":48,"_49":88,"_51":52,"_53":155,"_17":55,"_56":57,"_58":90,"_60":61,"_62":-5,"_122":156,"_18":157},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":152,"_17":55,"_56":57,"_58":83,"_60":61,"_62":-5,"_122":153,"_18":154},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":149,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_122":150,"_18":151},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":146,"_17":55,"_56":24,"_58":69,"_60":61,"_62":-5,"_122":147,"_18":148},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":143,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_122":144,"_18":145},["D",1779860895316],[],[19,42],["D",1779860893504],[],[19,65],["D",1779860970697],[],[19,72],["D",1779860982008],[],[19,79],["D",1779860955690],[],[19,86],["D",1779860937551],[],[19,93],["D",1779860911511],[],[19,100],"994d0e2a-598f-11f1-b217-ee650bb23af1","database","994d0ed4-598f-11f1-b217-ee650bb23af1",2,["D",1779860871228],[171,172],[165],{"_40":181,"_13":182,"_43":183,"_45":166,"_47":48,"_49":184,"_51":52,"_53":185,"_17":55,"_56":57,"_58":186,"_60":61,"_62":-5,"_122":187,"_18":188},{"_40":173,"_13":174,"_43":175,"_45":166,"_47":48,"_49":176,"_51":52,"_53":177,"_17":55,"_56":57,"_58":178,"_60":61,"_62":-5,"_122":179,"_18":180},"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",[],[165,174],"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",[],[165,182],"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,"_245":241},"org",{"_11":12,"_239":-5,"_240":241,"_199":200,"_242":243,"_244":61},"branch",{"_17":128,"_13":16,"_40":48,"_231":189,"_232":-5,"_233":-5,"_234":-5,"_235":-5,"_236":-5,"_237":14,"_238":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ1bUVvQndtZUNSRmZyQkpiYklWdVR0d3VFZCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_40":189,"_13":14,"_53":329,"_191":-5,"_192":61,"_193":194,"_195":194,"_196":197,"_198":-5,"_199":200,"_201":-5,"_202":61,"_203":-5,"_204":-5,"_205":118,"_206":207,"_208":209,"_210":211,"_212":330,"_214":-5,"_215":216,"_217":216,"_218":219,"_220":219,"_221":219,"_222":216,"_223":216,"_224":331,"_226":332,"_228":333,"_230":61},[290,293,301,302],"files",[290,291,292,293,294,295,296,297,298,299,300,301,302],"counts",{"_281":55,"_282":118,"_283":55,"_32":284,"_285":286},[267,268,269,270,271,272,273],{"_40":106,"_47":48,"_43":46,"_13":19,"_58":-5,"_56":109,"_17":55,"_45":-5,"_53":265,"_49":107,"_62":-5,"_18":266},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1779860871391],[19],{"_40":99,"_13":100,"_43":101,"_45":46,"_47":48,"_49":102,"_51":52,"_53":103,"_17":55,"_56":57,"_58":104,"_60":61,"_62":-5,"_18":280},{"_40":92,"_13":93,"_43":94,"_45":46,"_47":48,"_49":95,"_51":52,"_53":96,"_17":55,"_56":57,"_58":97,"_60":61,"_62":-5,"_18":279},{"_40":85,"_13":86,"_43":87,"_45":46,"_47":48,"_49":88,"_51":52,"_53":89,"_17":55,"_56":57,"_58":90,"_60":61,"_62":-5,"_18":278},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":82,"_17":55,"_56":57,"_58":83,"_60":61,"_62":-5,"_18":277},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":75,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_18":276},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":68,"_17":55,"_56":24,"_58":69,"_60":61,"_62":-5,"_18":275},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_18":274},[19,42],[19,65],[19,72],[19,79],[19,86],[19,93],[19,100],"pulls","branches","forks",{"_287":55,"_289":55},"connections",{"_287":55,"_288":55},"count","unfilledCount","emptyCount",{"_40":164,"_13":165,"_43":166,"_45":-5,"_47":48,"_49":167,"_51":52,"_53":168,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_122":327,"_18":328},{"_40":181,"_13":182,"_43":183,"_45":166,"_47":48,"_49":184,"_51":52,"_53":185,"_17":55,"_56":57,"_58":186,"_60":61,"_62":-5,"_122":325,"_18":326},{"_40":173,"_13":174,"_43":175,"_45":166,"_47":48,"_49":176,"_51":52,"_53":177,"_17":55,"_56":57,"_58":178,"_60":61,"_62":-5,"_122":323,"_18":324},{"_40":106,"_13":19,"_43":46,"_45":-5,"_47":48,"_49":107,"_51":52,"_53":133,"_17":55,"_56":109,"_58":-5,"_60":61,"_62":-5,"_122":321,"_18":322},{"_40":99,"_13":100,"_43":101,"_45":46,"_47":48,"_49":102,"_51":52,"_53":161,"_17":55,"_56":57,"_58":104,"_60":61,"_62":-5,"_122":319,"_18":320},{"_40":92,"_13":93,"_43":94,"_45":46,"_47":48,"_49":95,"_51":52,"_53":158,"_17":55,"_56":57,"_58":97,"_60":61,"_62":-5,"_122":317,"_18":318},{"_40":85,"_13":86,"_43":87,"_45":46,"_47":48,"_49":88,"_51":52,"_53":155,"_17":55,"_56":57,"_58":90,"_60":61,"_62":-5,"_122":315,"_18":316},{"_40":78,"_13":79,"_43":80,"_45":46,"_47":48,"_49":81,"_51":52,"_53":152,"_17":55,"_56":57,"_58":83,"_60":61,"_62":-5,"_122":313,"_18":314},{"_40":71,"_13":72,"_43":73,"_45":46,"_47":48,"_49":74,"_51":52,"_53":149,"_17":55,"_56":57,"_58":76,"_60":61,"_62":-5,"_122":311,"_18":312},{"_40":64,"_13":65,"_43":66,"_45":46,"_47":48,"_49":67,"_51":52,"_53":146,"_17":55,"_56":24,"_58":69,"_60":61,"_62":-5,"_122":309,"_18":310},{"_40":41,"_13":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":143,"_17":55,"_56":57,"_58":59,"_60":61,"_62":-5,"_122":307,"_18":308},{"_40":125,"_13":126,"_43":127,"_45":-5,"_47":48,"_49":128,"_51":52,"_53":129,"_17":55,"_56":24,"_58":130,"_60":61,"_62":-5,"_122":305,"_18":306},{"_40":115,"_13":116,"_43":117,"_45":-5,"_47":48,"_49":118,"_51":52,"_53":119,"_17":55,"_56":120,"_58":121,"_60":61,"_62":-5,"_122":303,"_18":304},[],[116],[],[126],[],[19,42],[],[19,65],[],[19,72],[],[19,79],[],[19,86],[],[19,93],[],[19,100],[294,295,296,297,298,299,300],[19],[],[165,174],[],[165,182],[291,292],[165],["D",1779860866826],["D",1789518676100],{"_11":12,"_245":241},{"_11":12,"_239":-5,"_240":241,"_199":200,"_242":243,"_244":61},{"_17":128,"_13":16,"_40":48,"_231":189,"_232":-5,"_233":-5,"_234":-5,"_235":-5,"_236":-5,"_237":14,"_238":12},"ctx",{"_224":-5,"_262":367,"_368":369,"_370":371,"_372":61,"_373":61,"_374":61,"_375":52,"_376":-5,"_377":-7,"_378":-7,"_379":55,"_380":61,"_381":61,"_382":-5,"_383":61,"_384":61,"_385":61,"_386":-5},"ENV",{"_338":339,"_340":341,"_342":16,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366},"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"]