\n \n\n\n","label",[154,64],"frontend","pulls","branches","forks","envVars",{"_162":26,"_164":26},"connections",{"_162":26,"_163":26},"count","unfilledCount","emptyCount",{"_32":270,"_13":261,"_62":255,"_42":-5,"_34":35,"_147":271,"_148":140,"_36":272,"_38":26,"_65":249,"_150":-5,"_66":24,"_152":-5,"_184":273,"_17":274},{"_32":262,"_13":263,"_62":264,"_42":255,"_34":35,"_147":265,"_148":140,"_36":266,"_38":26,"_65":199,"_150":267,"_66":24,"_152":-5,"_184":268,"_17":269},{"_32":252,"_13":253,"_62":254,"_42":255,"_34":35,"_147":256,"_148":140,"_36":257,"_38":26,"_65":199,"_150":258,"_66":24,"_152":-5,"_184":259,"_17":260},{"_32":246,"_13":154,"_62":146,"_42":-5,"_34":35,"_147":247,"_148":140,"_36":248,"_38":26,"_65":249,"_150":-5,"_66":24,"_152":-5,"_184":250,"_17":251},{"_32":238,"_13":239,"_62":240,"_42":146,"_34":35,"_147":241,"_148":140,"_36":242,"_38":26,"_65":199,"_150":243,"_66":24,"_152":-5,"_184":244,"_17":245},{"_32":230,"_13":231,"_62":232,"_42":146,"_34":35,"_147":233,"_148":140,"_36":234,"_38":26,"_65":199,"_150":235,"_66":24,"_152":-5,"_184":236,"_17":237},{"_32":222,"_13":223,"_62":224,"_42":146,"_34":35,"_147":225,"_148":140,"_36":226,"_38":26,"_65":199,"_150":227,"_66":24,"_152":-5,"_184":228,"_17":229},{"_32":214,"_13":215,"_62":216,"_42":146,"_34":35,"_147":217,"_148":140,"_36":218,"_38":26,"_65":199,"_150":219,"_66":24,"_152":-5,"_184":220,"_17":221},{"_32":206,"_13":207,"_62":208,"_42":146,"_34":35,"_147":209,"_148":140,"_36":210,"_38":26,"_65":199,"_150":211,"_66":24,"_152":-5,"_184":212,"_17":213},{"_32":145,"_13":64,"_62":63,"_42":146,"_34":35,"_147":39,"_148":140,"_36":203,"_38":26,"_65":21,"_150":151,"_66":24,"_152":-5,"_184":204,"_17":205},{"_32":194,"_13":195,"_62":196,"_42":146,"_34":35,"_147":197,"_148":140,"_36":198,"_38":26,"_65":199,"_150":200,"_66":24,"_152":-5,"_184":201,"_17":202},{"_32":187,"_13":188,"_62":189,"_42":-5,"_34":35,"_147":109,"_148":140,"_36":190,"_38":26,"_65":21,"_150":191,"_66":24,"_152":-5,"_184":192,"_17":193},{"_32":178,"_13":179,"_62":180,"_42":-5,"_34":35,"_147":86,"_148":140,"_36":181,"_38":26,"_65":182,"_150":183,"_66":24,"_152":-5,"_184":185,"_17":186},"96afbafa-598f-11f1-b217-ee650bb23af1","main.tsx","96afbbcc-598f-11f1-b217-ee650bb23af1",["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",[],[179],"ee1cd124-598f-11f1-b49e-ee650bb23af1","README.md","ee1cd1d8-598f-11f1-b49e-ee650bb23af1",["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",[],[188],"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",[],[154,195],["D",1779860893504],[],[154,64],"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",[],[154,207],"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",[],[154,215],"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",[],[154,223],"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",[],[154,231],"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",[],[154,239],"9965e878-598f-11f1-b217-ee650bb23af1",3,["D",1779860871391],"directory",[169,170,171,172,173,174,175],[154],"a2932adc-598f-11f1-98f0-ee650bb23af1","queries.ts","a2932b72-598f-11f1-98f0-ee650bb23af1","994d0ed4-598f-11f1-b217-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",[],[261,253],"database","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",[],[261,263],"994d0e2a-598f-11f1-b217-ee650bb23af1",2,["D",1779860871228],[166,167],[261],["D",1779860866826],["D",1789518676100],{"_11":12,"_122":69},{"_11":12,"_118":-5,"_68":69,"_30":67,"_119":120,"_121":24},{"_38":109,"_13":16,"_32":35,"_110":71,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":14,"_117":12},"ctx",{"_52":-5,"_142":313,"_314":315,"_316":317,"_318":24,"_319":24,"_320":24,"_321":140,"_322":-5,"_323":-7,"_324":-7,"_325":26,"_326":24,"_327":24,"_328":-5,"_329":24,"_330":24,"_331":24,"_332":-5},"ENV",{"_284":285,"_286":287,"_288":16,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

History · index.html