Group 187 - Charia B | UDS Attendance

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_212":213,"_214":215},"routes/_app.x.$handle.$name",{"_102":101,"_37":49,"_110":92,"_32":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":30,"_125":126,"_127":128,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":-5,"_61":30,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":30},"version",6,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","3a84d427-9b3c-4400-b407-31cf5939dbce","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":26,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","a6943428-598f-11f1-98f0-ee650bb23af1","name","index.html","fileType","content","\n\n\n \n \n Group 187 - Charia B | UDS Attendance\n \n \n \n\n\n

\n \n\n\n","createdAt",["D",1779860893504],"branchVersion","branchId","96ad0f58-598f-11f1-b217-ee650bb23af1","id","96ac6b7a-598f-11f1-b217-ee650bb23af1","group-187-attendance",["D",1779860866826],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Group 187 Charia B - UDS Member Registration & Attendance","imageUrl","8f6d5f70-08e8-11f0-b10f-e5a2093a590f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","609c7a35-8c11-4cc7-8fbe-7b6ea5f8bf62","tursoName","96ac6b7a598f11f1b217ee650bb23af1","tursoHostname","96ac6b7a598f11f1b217ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518676100],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_19":59,"_106":107,"_108":30},"branch",{"_13":91,"_37":92,"_47":46,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":49,"_100":101},"isOwned",13,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Ado","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ1bUVvQndtZUNSRmZyQkpiYklWdVR0d3VFZCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":207,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":-5,"_61":30,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":208,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":209,"_86":210,"_88":211,"_90":30},"tree",[170,173,175],"files",[170,171,172,173,174,175],"counts",{"_160":142,"_161":65,"_162":142,"_163":164,"_165":166},"contents",[133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_47":154,"_37":155,"_35":156,"_139":-5,"_45":46,"_44":157,"_140":128,"_42":158,"_13":142,"_39":152,"_40":-5,"_29":30,"_145":-5,"_32":159},{"_47":147,"_37":148,"_35":149,"_139":-5,"_45":46,"_44":150,"_140":128,"_42":151,"_13":142,"_39":152,"_40":-5,"_29":30,"_145":-5,"_32":153},{"_47":136,"_37":137,"_35":138,"_139":-5,"_45":46,"_44":65,"_140":128,"_42":141,"_13":142,"_39":143,"_40":144,"_29":30,"_145":-5,"_32":146},"96afbafa-598f-11f1-b217-ee650bb23af1","main.tsx","96afbbcc-598f-11f1-b217-ee650bb23af1","parentId","latest",["D",1779860866841],0,"http","import { Hono } from \"npm:hono@4\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport {\n registerMember,\n getMembers,\n signAttendance,\n getAttendanceByDate,\n getAttendanceSummary,\n deleteMember,\n} from \"./database/queries.ts\";\n\nconst app = new Hono();\n\nlet migrated = false;\nasync function ensureMigrated() {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n}\n\napp.onError((err) => Promise.reject(err));\n\napp.post(\"/api/members\", async (c) => {\n await ensureMigrated();\n const body = await c.req.json();\n const { indexNumber, fullName, phone } = body;\n if (!indexNumber || !fullName) {\n return c.json({ success: false, message: \"Index number and full name are required.\" }, 400);\n }\n const idPattern = /^[A-Z]{2,4}\\/\\d{4}\\/\\d{2}$/i;\n if (!idPattern.test(indexNumber.trim())) {\n return c.json({ success: false, message: \"Invalid index number format. Use: ABC/XXXX/25\" }, 400);\n }\n const result = await registerMember(indexNumber.trim().toUpperCase(), fullName.trim(), phone?.trim() || null);\n return c.json(result, result.success ? 201 : 409);\n});\n\napp.get(\"/api/members\", async (c) => {\n await ensureMigrated();\n const search = c.req.query(\"search\") || undefined;\n const members = await getMembers(search);\n return c.json(members);\n});\n\napp.delete(\"/api/members/:id\", async (c) => {\n await ensureMigrated();\n const id = Number(c.req.param(\"id\"));\n const result = await deleteMember(id);\n return c.json(result);\n});\n\napp.post(\"/api/attendance\", async (c) => {\n await ensureMigrated();\n const body = await c.req.json();\n const { memberId } = body;\n if (!memberId) {\n return c.json({ success: false, message: \"Member ID is required.\" }, 400);\n }\n const result = await signAttendance(Number(memberId));\n return c.json(result, result.success ? 200 : 409);\n});\n\napp.get(\"/api/attendance\", async (c) => {\n await ensureMigrated();\n const date = c.req.query(\"date\") || undefined;\n const records = await getAttendanceByDate(date);\n return c.json(records);\n});\n\napp.get(\"/api/attendance/summary\", async (c) => {\n await ensureMigrated();\n const summary = await getAttendanceSummary();\n return c.json(summary);\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/frontend/*\", async (c) => serveFile(c.req.path));\napp.get(\"/*\", async (c) => serveFile(\"/frontend/index.html\"));\n\nexport default app.fetch;\n","label",[137],"9965e878-598f-11f1-b217-ee650bb23af1","frontend","9965e940-598f-11f1-b217-ee650bb23af1",3,["D",1779860871391],"directory",[148],"994d0e2a-598f-11f1-b217-ee650bb23af1","database","994d0ed4-598f-11f1-b217-ee650bb23af1",2,["D",1779860871228],[155],"pulls","branches","forks","envVars",{"_167":142,"_169":142},"connections",{"_167":142,"_168":142},"count","unfilledCount","emptyCount",{"_47":154,"_37":155,"_35":156,"_139":-5,"_45":46,"_44":157,"_140":128,"_42":204,"_13":142,"_39":152,"_40":-5,"_29":30,"_145":-5,"_177":205,"_32":206},{"_47":196,"_37":197,"_35":198,"_139":156,"_45":46,"_44":199,"_140":128,"_42":200,"_13":142,"_39":192,"_40":201,"_29":30,"_145":-5,"_177":202,"_32":203},{"_47":187,"_37":188,"_35":189,"_139":156,"_45":46,"_44":190,"_140":128,"_42":191,"_13":142,"_39":192,"_40":193,"_29":30,"_145":-5,"_177":194,"_32":195},{"_47":147,"_37":148,"_35":149,"_139":-5,"_45":46,"_44":150,"_140":128,"_42":184,"_13":142,"_39":152,"_40":-5,"_29":30,"_145":-5,"_177":185,"_32":186},{"_47":180,"_37":38,"_35":36,"_139":149,"_45":46,"_44":14,"_140":128,"_42":181,"_13":142,"_39":26,"_40":41,"_29":30,"_145":-5,"_177":182,"_32":183},{"_47":136,"_37":137,"_35":138,"_139":-5,"_45":46,"_44":65,"_140":128,"_42":176,"_13":142,"_39":143,"_40":144,"_29":30,"_145":-5,"_177":178,"_32":179},["D",1779860866841],"children",[],[137],"a6943356-598f-11f1-98f0-ee650bb23af1",["D",1779860893504],[],[148,38],["D",1779860871391],[174],[148],"a2932adc-598f-11f1-98f0-ee650bb23af1","queries.ts","a2932b72-598f-11f1-98f0-ee650bb23af1",5,["D",1779860886786],"script","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",[],[155,188],"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",[],[155,197],["D",1779860871228],[171,172],[155],["D",1779860866826],["D",1789518676100],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_19":59,"_106":107,"_108":30},{"_13":91,"_37":92,"_47":46,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":49,"_100":101},"ctx",{"_84":-5,"_130":245,"_246":247,"_248":249,"_250":30,"_251":30,"_252":30,"_253":128,"_254":-5,"_255":-7,"_256":-7,"_257":142,"_258":30,"_259":30,"_260":-5,"_261":30,"_262":30,"_263":30,"_264":-5},"ENV",{"_216":217,"_218":219,"_220":92,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6