\n \n\n\n",[],[143,194],"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",[],[143,202],"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",[],[143,210],"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",[],[143,218],"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",[],[143,226],"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",[],[143,234],["D",1779860871391],[168,169,170,171,172,173,174],[143],"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",[],[150,245],"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",[],[150,253],["D",1779860871228],[165,166],[150],["D",1779860866826],["D",1789518676100],{"_11":12,"_89":85},{"_11":12,"_83":-5,"_84":85,"_45":46,"_86":87,"_88":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_78":-5,"_79":-5,"_80":-5,"_81":14,"_82":12},"ctx",{"_71":-5,"_112":301,"_302":303,"_304":305,"_306":38,"_307":38,"_308":38,"_309":110,"_310":-5,"_311":-7,"_312":-7,"_313":128,"_314":38,"_315":38,"_316":-5,"_317":38,"_318":38,"_319":38,"_320":-5},"ENV",{"_272":273,"_274":275,"_276":26,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300},"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"]

Branches1

Branches
1