[{"_1":2,"_333":-5,"_334":-5},"loaderData",{"_3":4,"_96":97,"_275":276,"_332":-5},"root",{"_5":6,"_33":34,"_65":66},"ctx",{"_7":8,"_19":20,"_21":-5,"_22":23,"_24":25,"_26":27,"_28":27,"_29":27,"_30":31,"_32":27},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers",false,"preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f2e94683099514edb6729d0e2d4c4a4d16ae21f4","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","fd7e47ba602df66e0f857b45e802b861","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":44,"_72":73,"_74":73,"_75":27,"_76":73,"_77":73,"_78":73,"_79":73,"_80":73,"_81":73,"_82":73,"_83":73,"_84":85,"_94":27,"_95":27},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_86":27,"_87":73,"_88":89,"_90":73,"_91":44,"_92":27,"_93":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_98":99,"_100":101,"_102":42,"_103":73,"_104":-7,"_105":106,"_146":147,"_252":253,"_254":255,"_260":261,"_248":-5,"_271":-5,"_272":-5,"_273":27,"_274":27},"handle","DHIRAJ7655","name","Attendancetracker","branchName","path","version","project",{"_107":108,"_100":101,"_109":110,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":-5,"_119":27,"_120":-5,"_121":31,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_131":27,"_21":132,"_135":136},"id","7840f768-3f65-11f0-8979-76b3cceeab13","createdAt",["D",1748836549023],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","31cbc510-3f65-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","screenshotVersion","likeCount","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","isOwned",{"_98":99,"_133":134},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4dzVadVNocFFOMWdNOERhblZUbm44TU5saSJ9","branch",{"_104":137,"_100":42,"_107":138,"_139":108,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":101,"_145":99},7,"78416e32-3f65-11f0-8979-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","projectName","userHandle","tree",[148,226,242],{"_107":149,"_100":150,"_151":152,"_153":-5,"_154":138,"_155":156,"_157":158,"_109":159,"_104":31,"_160":161,"_162":-5,"_163":27,"_164":-5,"_165":166,"_103":225},"b5c74754-3f65-11f0-a4cc-76b3cceeab13","backend","fileId","6aa774a4-a054-48db-ad75-1008956a675f","parentId","branchId","branchVersion",3,"latest",true,["D",1748836652237],"fileType","directory","content","deleted","label","children",[167,192],{"_107":168,"_100":169,"_151":170,"_153":152,"_154":138,"_155":156,"_157":158,"_109":171,"_104":31,"_160":161,"_162":-5,"_163":27,"_164":-5,"_165":172,"_103":191},"b5c748e4-3f65-11f0-a4cc-76b3cceeab13","database","68470509-1318-47fd-8b98-355621456109",["D",1748836652237],[173,182],{"_107":174,"_100":175,"_151":176,"_153":170,"_154":138,"_155":156,"_157":158,"_109":177,"_104":31,"_160":178,"_162":179,"_163":27,"_164":-5,"_165":180,"_103":181},"b5c739da-3f65-11f0-a4cc-76b3cceeab13","migrations.ts","b5c73a7a-3f65-11f0-a4cc-76b3cceeab13",["D",1748836652237],"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names with version for easy schema updates\nexport const TABLES = {\n EMPLOYEES: 'employees_v1',\n ATTENDANCE: 'attendance_records_v1'\n};\n\nexport async function runMigrations() {\n console.log('Running database migrations...');\n \n // Create employees table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.EMPLOYEES} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n employee_id TEXT UNIQUE NOT NULL,\n first_name TEXT NOT NULL,\n last_name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n department TEXT NOT NULL,\n position TEXT NOT NULL,\n hire_date TEXT NOT NULL,\n is_active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create attendance records table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.ATTENDANCE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n employee_id INTEGER NOT NULL,\n clock_in DATETIME NOT NULL,\n clock_out DATETIME,\n date TEXT NOT NULL,\n total_hours REAL,\n status TEXT DEFAULT 'clocked-in',\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (employee_id) REFERENCES ${TABLES.EMPLOYEES}(id)\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_employees_employee_id \n ON ${TABLES.EMPLOYEES}(employee_id)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_attendance_employee_date \n ON ${TABLES.ATTENDANCE}(employee_id, date)\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_attendance_date \n ON ${TABLES.ATTENDANCE}(date)\n `);\n\n // Insert sample data if tables are empty\n const employeeCount = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLES.EMPLOYEES}`);\n if (employeeCount[0].count === 0) {\n await insertSampleData();\n }\n\n console.log('Database migrations completed successfully');\n}\n\nasync function insertSampleData() {\n console.log('Inserting sample data...');\n \n const sampleEmployees = [\n {\n employee_id: 'EMP001',\n first_name: 'John',\n last_name: 'Doe',\n email: 'john.doe@company.com',\n department: 'Engineering',\n position: 'Software Developer',\n hire_date: '2023-01-15'\n },\n {\n employee_id: 'EMP002',\n first_name: 'Jane',\n last_name: 'Smith',\n email: 'jane.smith@company.com',\n department: 'Marketing',\n position: 'Marketing Manager',\n hire_date: '2023-02-01'\n },\n {\n employee_id: 'EMP003',\n first_name: 'Mike',\n last_name: 'Johnson',\n email: 'mike.johnson@company.com',\n department: 'Engineering',\n position: 'Senior Developer',\n hire_date: '2022-11-10'\n },\n {\n employee_id: 'EMP004',\n first_name: 'Sarah',\n last_name: 'Wilson',\n email: 'sarah.wilson@company.com',\n department: 'HR',\n position: 'HR Specialist',\n hire_date: '2023-03-20'\n }\n ];\n\n for (const employee of sampleEmployees) {\n await sqlite.execute(`\n INSERT INTO ${TABLES.EMPLOYEES} \n (employee_id, first_name, last_name, email, department, position, hire_date)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n employee.employee_id,\n employee.first_name,\n employee.last_name,\n employee.email,\n employee.department,\n employee.position,\n employee.hire_date\n ]);\n }\n\n console.log('Sample data inserted successfully');\n}",[],[150,169,175],{"_107":183,"_100":184,"_151":185,"_153":170,"_154":138,"_155":186,"_157":158,"_109":187,"_104":31,"_160":178,"_162":188,"_163":27,"_164":-5,"_165":189,"_103":190},"cc4a4e72-3f65-11f0-bdb3-76b3cceeab13","queries.ts","cc4a4f62-3f65-11f0-bdb3-76b3cceeab13",4,["D",1748836690008],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { \n Employee, \n AttendanceRecord, \n CreateEmployeeRequest, \n UpdateEmployeeRequest,\n AttendanceStatus,\n DailyReport \n} from \"../../shared/types.ts\";\n\n// Employee queries\nexport class EmployeeQueries {\n static async getAll(): Promise {\n const rows = await sqlite.execute(`\n SELECT * FROM ${TABLES.EMPLOYEES} \n WHERE is_active = 1 \n ORDER BY first_name, last_name\n `);\n \n return rows.map(this.mapRowToEmployee);\n }\n\n static async getById(id: number): Promise {\n const rows = await sqlite.execute(`\n SELECT * FROM ${TABLES.EMPLOYEES} WHERE id = ?\n `, [id]);\n \n return rows.length > 0 ? this.mapRowToEmployee(rows[0]) : null;\n }\n\n static async getByEmployeeId(employeeId: string): Promise {\n const rows = await sqlite.execute(`\n SELECT * FROM ${TABLES.EMPLOYEES} WHERE employee_id = ?\n `, [employeeId]);\n \n return rows.length > 0 ? this.mapRowToEmployee(rows[0]) : null;\n }\n\n static async create(data: CreateEmployeeRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${TABLES.EMPLOYEES} \n (employee_id, first_name, last_name, email, department, position, hire_date)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n data.employeeId,\n data.firstName,\n data.lastName,\n data.email,\n data.department,\n data.position,\n data.hireDate\n ]);\n\n const employee = await this.getById(result.lastInsertRowId);\n if (!employee) throw new Error('Failed to create employee');\n return employee;\n }\n\n static async update(id: number, data: UpdateEmployeeRequest): Promise {\n const updates: string[] = [];\n const values: any[] = [];\n\n if (data.employeeId !== undefined) {\n updates.push('employee_id = ?');\n values.push(data.employeeId);\n }\n if (data.firstName !== undefined) {\n updates.push('first_name = ?');\n values.push(data.firstName);\n }\n if (data.lastName !== undefined) {\n updates.push('last_name = ?');\n values.push(data.lastName);\n }\n if (data.email !== undefined) {\n updates.push('email = ?');\n values.push(data.email);\n }\n if (data.department !== undefined) {\n updates.push('department = ?');\n values.push(data.department);\n }\n if (data.position !== undefined) {\n updates.push('position = ?');\n values.push(data.position);\n }\n if (data.hireDate !== undefined) {\n updates.push('hire_date = ?');\n values.push(data.hireDate);\n }\n if (data.isActive !== undefined) {\n updates.push('is_active = ?');\n values.push(data.isActive ? 1 : 0);\n }\n\n updates.push('updated_at = CURRENT_TIMESTAMP');\n values.push(id);\n\n await sqlite.execute(`\n UPDATE ${TABLES.EMPLOYEES} \n SET ${updates.join(', ')} \n WHERE id = ?\n `, values);\n\n const employee = await this.getById(id);\n if (!employee) throw new Error('Employee not found after update');\n return employee;\n }\n\n static async delete(id: number): Promise {\n await sqlite.execute(`\n UPDATE ${TABLES.EMPLOYEES} \n SET is_active = 0, updated_at = CURRENT_TIMESTAMP \n WHERE id = ?\n `, [id]);\n }\n\n private static mapRowToEmployee(row: any): Employee {\n return {\n id: row.id,\n employeeId: row.employee_id,\n firstName: row.first_name,\n lastName: row.last_name,\n email: row.email,\n department: row.department,\n position: row.position,\n hireDate: row.hire_date,\n isActive: Boolean(row.is_active),\n createdAt: row.created_at,\n updatedAt: row.updated_at\n };\n }\n}\n\n// Attendance queries\nexport class AttendanceQueries {\n static async clockIn(employeeId: number, notes?: string): Promise {\n const now = new Date().toISOString();\n const date = now.split('T')[0];\n\n // Check if already clocked in today\n const existing = await this.getTodayRecord(employeeId);\n if (existing && !existing.clockOut) {\n throw new Error('Employee is already clocked in');\n }\n\n const result = await sqlite.execute(`\n INSERT INTO ${TABLES.ATTENDANCE} \n (employee_id, clock_in, date, status, notes)\n VALUES (?, ?, ?, 'clocked-in', ?)\n `, [employeeId, now, date, notes || null]);\n\n const record = await this.getById(result.lastInsertRowId);\n if (!record) throw new Error('Failed to create attendance record');\n return record;\n }\n\n static async clockOut(employeeId: number, notes?: string): Promise {\n const record = await this.getTodayRecord(employeeId);\n if (!record || record.clockOut) {\n throw new Error('No active clock-in found for today');\n }\n\n const now = new Date().toISOString();\n const clockInTime = new Date(record.clockIn);\n const clockOutTime = new Date(now);\n const totalHours = (clockOutTime.getTime() - clockInTime.getTime()) / (1000 * 60 * 60);\n\n await sqlite.execute(`\n UPDATE ${TABLES.ATTENDANCE} \n SET clock_out = ?, total_hours = ?, status = 'present', notes = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [now, totalHours, notes || record.notes, record.id]);\n\n const updatedRecord = await this.getById(record.id);\n if (!updatedRecord) throw new Error('Failed to update attendance record');\n return updatedRecord;\n }\n\n static async getStatus(employeeId: number): Promise {\n const record = await this.getTodayRecord(employeeId);\n \n return {\n employeeId,\n isClocked: Boolean(record && !record.clockOut),\n clockInTime: record?.clockIn,\n currentSession: record && !record.clockOut ? record : undefined\n };\n }\n\n static async getHistory(employeeId: number, limit = 30): Promise {\n const rows = await sqlite.execute(`\n SELECT * FROM ${TABLES.ATTENDANCE} \n WHERE employee_id = ? \n ORDER BY date DESC, clock_in DESC \n LIMIT ?\n `, [employeeId, limit]);\n\n return rows.map(this.mapRowToAttendance);\n }\n\n static async getDailyReport(date: string): Promise {\n // Get all active employees\n const employees = await EmployeeQueries.getAll();\n \n // Get attendance records for the date\n const attendanceRows = await sqlite.execute(`\n SELECT a.*, e.first_name, e.last_name, e.employee_id as emp_id\n FROM ${TABLES.ATTENDANCE} a\n JOIN ${TABLES.EMPLOYEES} e ON a.employee_id = e.id\n WHERE a.date = ? AND e.is_active = 1\n `, [date]);\n\n const attendanceMap = new Map();\n attendanceRows.forEach(row => {\n attendanceMap.set(row.employee_id, this.mapRowToAttendance(row));\n });\n\n const employeeReports = employees.map(employee => {\n const attendance = attendanceMap.get(employee.id);\n let status: 'present' | 'absent' | 'late' | 'clocked-in' = 'absent';\n \n if (attendance) {\n if (attendance.status === 'clocked-in') {\n status = 'clocked-in';\n } else if (attendance.status === 'present') {\n // Check if late (assuming 9 AM is standard start time)\n const clockInTime = new Date(attendance.clockIn);\n const standardStart = new Date(attendance.clockIn);\n standardStart.setHours(9, 0, 0, 0);\n status = clockInTime > standardStart ? 'late' : 'present';\n }\n }\n\n return {\n employee,\n attendance,\n status\n };\n });\n\n const presentCount = employeeReports.filter(r => r.status === 'present' || r.status === 'clocked-in').length;\n const lateCount = employeeReports.filter(r => r.status === 'late').length;\n const absentCount = employees.length - presentCount - lateCount;\n\n return {\n date,\n totalEmployees: employees.length,\n presentEmployees: presentCount,\n absentEmployees: absentCount,\n lateEmployees: lateCount,\n attendanceRate: employees.length > 0 ? (presentCount / employees.length) * 100 : 0,\n employees: employeeReports\n };\n }\n\n private static async getTodayRecord(employeeId: number): Promise {\n const today = new Date().toISOString().split('T')[0];\n const rows = await sqlite.execute(`\n SELECT * FROM ${TABLES.ATTENDANCE} \n WHERE employee_id = ? AND date = ?\n ORDER BY clock_in DESC\n LIMIT 1\n `, [employeeId, today]);\n\n return rows.length > 0 ? this.mapRowToAttendance(rows[0]) : null;\n }\n\n private static async getById(id: number): Promise {\n const rows = await sqlite.execute(`\n SELECT * FROM ${TABLES.ATTENDANCE} WHERE id = ?\n `, [id]);\n\n return rows.length > 0 ? this.mapRowToAttendance(rows[0]) : null;\n }\n\n private static mapRowToAttendance(row: any): AttendanceRecord {\n return {\n id: row.id,\n employeeId: row.employee_id,\n clockIn: row.clock_in,\n clockOut: row.clock_out || undefined,\n date: row.date,\n totalHours: row.total_hours || undefined,\n status: row.status,\n notes: row.notes || undefined,\n createdAt: row.created_at,\n updatedAt: row.updated_at\n };\n }\n}",[],[150,169,184],[150,169],{"_107":193,"_100":194,"_151":195,"_153":152,"_154":138,"_155":196,"_157":158,"_109":197,"_104":31,"_160":161,"_162":-5,"_163":27,"_164":-5,"_165":198,"_103":224},"db8358d4-3f65-11f0-aee7-76b3cceeab13","routes","330405be-b248-4b58-9e2c-b1d31ad37aaf",5,["D",1748836715544],[199,208,216],{"_107":200,"_100":201,"_151":202,"_153":195,"_154":138,"_155":203,"_157":158,"_109":204,"_104":31,"_160":178,"_162":205,"_163":27,"_164":-5,"_165":206,"_103":207},"e8990334-3f65-11f0-b478-76b3cceeab13","attendance.ts","e89903ca-3f65-11f0-b478-76b3cceeab13",6,["D",1748836737501],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { AttendanceQueries, EmployeeQueries } from \"../database/queries.ts\";\nimport type { ClockInRequest, ClockOutRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst attendance = new Hono();\n\n// Clock in employee\nattendance.post(\"/clock-in\", async (c) => {\n try {\n const body = await c.req.json() as ClockInRequest;\n \n if (!body.employeeId) {\n return c.json({\n success: false,\n error: \"Employee ID is required\"\n } as ApiResponse, 400);\n }\n\n // Verify employee exists and is active\n const employee = await EmployeeQueries.getById(body.employeeId);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n if (!employee.isActive) {\n return c.json({\n success: false,\n error: \"Employee is not active\"\n } as ApiResponse, 400);\n }\n\n const record = await AttendanceQueries.clockIn(body.employeeId, body.notes);\n return c.json({\n success: true,\n data: record,\n message: `${employee.firstName} ${employee.lastName} clocked in successfully`\n } as ApiResponse);\n } catch (error) {\n if (error.message.includes('already clocked in')) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 409);\n }\n \n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Clock out employee\nattendance.post(\"/clock-out\", async (c) => {\n try {\n const body = await c.req.json() as ClockOutRequest;\n \n if (!body.employeeId) {\n return c.json({\n success: false,\n error: \"Employee ID is required\"\n } as ApiResponse, 400);\n }\n\n // Verify employee exists\n const employee = await EmployeeQueries.getById(body.employeeId);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n const record = await AttendanceQueries.clockOut(body.employeeId, body.notes);\n return c.json({\n success: true,\n data: record,\n message: `${employee.firstName} ${employee.lastName} clocked out successfully`\n } as ApiResponse);\n } catch (error) {\n if (error.message.includes('No active clock-in')) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 409);\n }\n \n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get current attendance status for employee\nattendance.get(\"/status/:employeeId\", async (c) => {\n try {\n const employeeId = parseInt(c.req.param(\"employeeId\"));\n if (isNaN(employeeId)) {\n return c.json({\n success: false,\n error: \"Invalid employee ID\"\n } as ApiResponse, 400);\n }\n\n // Verify employee exists\n const employee = await EmployeeQueries.getById(employeeId);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n const status = await AttendanceQueries.getStatus(employeeId);\n return c.json({\n success: true,\n data: status\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get attendance history for employee\nattendance.get(\"/history/:employeeId\", async (c) => {\n try {\n const employeeId = parseInt(c.req.param(\"employeeId\"));\n if (isNaN(employeeId)) {\n return c.json({\n success: false,\n error: \"Invalid employee ID\"\n } as ApiResponse, 400);\n }\n\n const limit = parseInt(c.req.query(\"limit\") || \"30\");\n if (isNaN(limit) || limit < 1 || limit > 100) {\n return c.json({\n success: false,\n error: \"Limit must be between 1 and 100\"\n } as ApiResponse, 400);\n }\n\n // Verify employee exists\n const employee = await EmployeeQueries.getById(employeeId);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n const history = await AttendanceQueries.getHistory(employeeId, limit);\n return c.json({\n success: true,\n data: {\n employee,\n records: history\n }\n } as ApiResponse<{ employee: typeof employee; records: typeof history }>);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get all employees with their current status\nattendance.get(\"/status\", async (c) => {\n try {\n const employees = await EmployeeQueries.getAll();\n const statusPromises = employees.map(async (employee) => {\n const status = await AttendanceQueries.getStatus(employee.id);\n return {\n employee,\n status\n };\n });\n\n const employeeStatuses = await Promise.all(statusPromises);\n \n return c.json({\n success: true,\n data: employeeStatuses\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\nexport default attendance;",[],[150,194,201],{"_107":209,"_100":210,"_151":211,"_153":195,"_154":138,"_155":196,"_157":158,"_109":212,"_104":31,"_160":178,"_162":213,"_163":27,"_164":-5,"_165":214,"_103":215},"db8328c8-3f65-11f0-aee7-76b3cceeab13","employees.ts","db8329a4-3f65-11f0-aee7-76b3cceeab13",["D",1748836715544],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { EmployeeQueries } from \"../database/queries.ts\";\nimport type { CreateEmployeeRequest, UpdateEmployeeRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst employees = new Hono();\n\n// Get all employees\nemployees.get(\"/\", async (c) => {\n try {\n const employeeList = await EmployeeQueries.getAll();\n return c.json({\n success: true,\n data: employeeList\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get employee by ID\nemployees.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid employee ID\"\n } as ApiResponse, 400);\n }\n\n const employee = await EmployeeQueries.getById(id);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n return c.json({\n success: true,\n data: employee\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Create new employee\nemployees.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as CreateEmployeeRequest;\n \n // Validate required fields\n const requiredFields = ['employeeId', 'firstName', 'lastName', 'email', 'department', 'position', 'hireDate'];\n for (const field of requiredFields) {\n if (!body[field as keyof CreateEmployeeRequest]) {\n return c.json({\n success: false,\n error: `Missing required field: ${field}`\n } as ApiResponse, 400);\n }\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.email)) {\n return c.json({\n success: false,\n error: \"Invalid email format\"\n } as ApiResponse, 400);\n }\n\n // Validate hire date format (YYYY-MM-DD)\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(body.hireDate)) {\n return c.json({\n success: false,\n error: \"Invalid hire date format. Use YYYY-MM-DD\"\n } as ApiResponse, 400);\n }\n\n const employee = await EmployeeQueries.create(body);\n return c.json({\n success: true,\n data: employee,\n message: \"Employee created successfully\"\n } as ApiResponse, 201);\n } catch (error) {\n if (error.message.includes('UNIQUE constraint failed')) {\n return c.json({\n success: false,\n error: \"Employee ID or email already exists\"\n } as ApiResponse, 409);\n }\n \n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Update employee\nemployees.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid employee ID\"\n } as ApiResponse, 400);\n }\n\n const body = await c.req.json() as UpdateEmployeeRequest;\n \n // Validate email format if provided\n if (body.email) {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.email)) {\n return c.json({\n success: false,\n error: \"Invalid email format\"\n } as ApiResponse, 400);\n }\n }\n\n // Validate hire date format if provided\n if (body.hireDate) {\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(body.hireDate)) {\n return c.json({\n success: false,\n error: \"Invalid hire date format. Use YYYY-MM-DD\"\n } as ApiResponse, 400);\n }\n }\n\n const employee = await EmployeeQueries.update(id, body);\n return c.json({\n success: true,\n data: employee,\n message: \"Employee updated successfully\"\n } as ApiResponse);\n } catch (error) {\n if (error.message.includes('UNIQUE constraint failed')) {\n return c.json({\n success: false,\n error: \"Employee ID or email already exists\"\n } as ApiResponse, 409);\n }\n \n if (error.message.includes('not found')) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n \n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Delete employee (soft delete)\nemployees.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid employee ID\"\n } as ApiResponse, 400);\n }\n\n // Check if employee exists\n const employee = await EmployeeQueries.getById(id);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n await EmployeeQueries.delete(id);\n return c.json({\n success: true,\n message: \"Employee deleted successfully\"\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\nexport default employees;",[],[150,194,210],{"_107":217,"_100":218,"_151":219,"_153":195,"_154":138,"_155":137,"_157":158,"_109":220,"_104":31,"_160":178,"_162":221,"_163":27,"_164":-5,"_165":222,"_103":223},"fd1ec12c-3f65-11f0-ab30-76b3cceeab13","reports.ts","fd1ec1f4-3f65-11f0-ab30-76b3cceeab13",["D",1748836771928],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { AttendanceQueries, EmployeeQueries } from \"../database/queries.ts\";\nimport type { ApiResponse, EmployeeReport } from \"../../shared/types.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"../database/migrations.ts\";\n\nconst reports = new Hono();\n\n// Get daily attendance report\nreports.get(\"/daily\", async (c) => {\n try {\n const date = c.req.query(\"date\") || new Date().toISOString().split('T')[0];\n \n // Validate date format\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(date)) {\n return c.json({\n success: false,\n error: \"Invalid date format. Use YYYY-MM-DD\"\n } as ApiResponse, 400);\n }\n\n const report = await AttendanceQueries.getDailyReport(date);\n return c.json({\n success: true,\n data: report\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get employee-specific report\nreports.get(\"/employee/:id\", async (c) => {\n try {\n const employeeId = parseInt(c.req.param(\"id\"));\n if (isNaN(employeeId)) {\n return c.json({\n success: false,\n error: \"Invalid employee ID\"\n } as ApiResponse, 400);\n }\n\n const days = parseInt(c.req.query(\"days\") || \"30\");\n if (isNaN(days) || days < 1 || days > 365) {\n return c.json({\n success: false,\n error: \"Days must be between 1 and 365\"\n } as ApiResponse, 400);\n }\n\n // Verify employee exists\n const employee = await EmployeeQueries.getById(employeeId);\n if (!employee) {\n return c.json({\n success: false,\n error: \"Employee not found\"\n } as ApiResponse, 404);\n }\n\n // Calculate date range\n const endDate = new Date();\n const startDate = new Date();\n startDate.setDate(endDate.getDate() - days);\n\n const startDateStr = startDate.toISOString().split('T')[0];\n const endDateStr = endDate.toISOString().split('T')[0];\n\n // Get attendance records for the period\n const attendanceRecords = await sqlite.execute(`\n SELECT * FROM ${TABLES.ATTENDANCE}\n WHERE employee_id = ? AND date BETWEEN ? AND ?\n ORDER BY date DESC\n `, [employeeId, startDateStr, endDateStr]);\n\n // Calculate statistics\n const totalDays = days;\n const presentDays = attendanceRecords.filter(r => r.status === 'present').length;\n const absentDays = totalDays - presentDays;\n const totalHours = attendanceRecords\n .filter(r => r.total_hours)\n .reduce((sum, r) => sum + r.total_hours, 0);\n const averageHours = presentDays > 0 ? totalHours / presentDays : 0;\n const attendanceRate = totalDays > 0 ? (presentDays / totalDays) * 100 : 0;\n\n // Get recent attendance (last 10 records)\n const recentAttendance = await AttendanceQueries.getHistory(employeeId, 10);\n\n const report: EmployeeReport = {\n employee,\n totalDays,\n presentDays,\n absentDays,\n totalHours: Math.round(totalHours * 100) / 100,\n averageHours: Math.round(averageHours * 100) / 100,\n attendanceRate: Math.round(attendanceRate * 100) / 100,\n recentAttendance\n };\n\n return c.json({\n success: true,\n data: report\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get weekly attendance summary\nreports.get(\"/weekly\", async (c) => {\n try {\n const weekOffset = parseInt(c.req.query(\"week\") || \"0\");\n if (isNaN(weekOffset) || weekOffset < -52 || weekOffset > 0) {\n return c.json({\n success: false,\n error: \"Week offset must be between -52 and 0\"\n } as ApiResponse, 400);\n }\n\n // Calculate week start and end dates\n const today = new Date();\n const currentWeekStart = new Date(today);\n currentWeekStart.setDate(today.getDate() - today.getDay()); // Start of current week (Sunday)\n \n const weekStart = new Date(currentWeekStart);\n weekStart.setDate(currentWeekStart.getDate() + (weekOffset * 7));\n \n const weekEnd = new Date(weekStart);\n weekEnd.setDate(weekStart.getDate() + 6);\n\n const startDateStr = weekStart.toISOString().split('T')[0];\n const endDateStr = weekEnd.toISOString().split('T')[0];\n\n // Get daily reports for the week\n const dailyReports = [];\n for (let i = 0; i < 7; i++) {\n const date = new Date(weekStart);\n date.setDate(weekStart.getDate() + i);\n const dateStr = date.toISOString().split('T')[0];\n \n const dailyReport = await AttendanceQueries.getDailyReport(dateStr);\n dailyReports.push(dailyReport);\n }\n\n // Calculate week summary\n const totalEmployees = dailyReports[0]?.totalEmployees || 0;\n const avgAttendanceRate = dailyReports.reduce((sum, day) => sum + day.attendanceRate, 0) / 7;\n const totalPresent = dailyReports.reduce((sum, day) => sum + day.presentEmployees, 0);\n const totalAbsent = dailyReports.reduce((sum, day) => sum + day.absentEmployees, 0);\n\n const weeklyReport = {\n weekStart: startDateStr,\n weekEnd: endDateStr,\n totalEmployees,\n averageAttendanceRate: Math.round(avgAttendanceRate * 100) / 100,\n totalPresent,\n totalAbsent,\n dailyReports\n };\n\n return c.json({\n success: true,\n data: weeklyReport\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\n// Get department-wise attendance summary\nreports.get(\"/department\", async (c) => {\n try {\n const date = c.req.query(\"date\") || new Date().toISOString().split('T')[0];\n \n // Validate date format\n const dateRegex = /^\\d{4}-\\d{2}-\\d{2}$/;\n if (!dateRegex.test(date)) {\n return c.json({\n success: false,\n error: \"Invalid date format. Use YYYY-MM-DD\"\n } as ApiResponse, 400);\n }\n\n // Get all employees grouped by department\n const employees = await EmployeeQueries.getAll();\n const departmentMap = new Map();\n\n employees.forEach(emp => {\n if (!departmentMap.has(emp.department)) {\n departmentMap.set(emp.department, []);\n }\n departmentMap.get(emp.department).push(emp);\n });\n\n // Get attendance data for each department\n const departmentReports = [];\n for (const [department, deptEmployees] of departmentMap) {\n const attendancePromises = deptEmployees.map(async (emp: any) => {\n const status = await AttendanceQueries.getStatus(emp.id);\n return { employee: emp, status };\n });\n\n const employeeStatuses = await Promise.all(attendancePromises);\n const presentCount = employeeStatuses.filter(es => es.status.isClocked).length;\n const attendanceRate = deptEmployees.length > 0 ? (presentCount / deptEmployees.length) * 100 : 0;\n\n departmentReports.push({\n department,\n totalEmployees: deptEmployees.length,\n presentEmployees: presentCount,\n absentEmployees: deptEmployees.length - presentCount,\n attendanceRate: Math.round(attendanceRate * 100) / 100,\n employees: employeeStatuses\n });\n }\n\n return c.json({\n success: true,\n data: {\n date,\n departments: departmentReports\n }\n } as ApiResponse<{ date: string; departments: typeof departmentReports }>);\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n } as ApiResponse, 500);\n }\n});\n\nexport default reports;",[],[150,194,218],[150,194],[150],{"_107":227,"_100":228,"_151":229,"_153":-5,"_154":138,"_155":230,"_157":158,"_109":231,"_104":31,"_160":161,"_162":-5,"_163":27,"_164":-5,"_165":232,"_103":241},"ac09e6ea-3f65-11f0-bb0d-76b3cceeab13","shared","cdbd2a60-660f-4718-8bb2-4accc0ced5a6",2,["D",1748836635899],[233],{"_107":234,"_100":235,"_151":236,"_153":229,"_154":138,"_155":230,"_157":158,"_109":237,"_104":31,"_160":178,"_162":238,"_163":27,"_164":-5,"_165":239,"_103":240},"ac09dbf0-3f65-11f0-bb0d-76b3cceeab13","types.ts","ac09dc9a-3f65-11f0-bb0d-76b3cceeab13",["D",1748836635899],"// Shared type definitions for the attendance tracker\n\nexport interface Employee {\n id: number;\n employeeId: string;\n firstName: string;\n lastName: string;\n email: string;\n department: string;\n position: string;\n hireDate: string;\n isActive: boolean;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface AttendanceRecord {\n id: number;\n employeeId: number;\n clockIn: string;\n clockOut?: string;\n date: string;\n totalHours?: number;\n status: 'present' | 'absent' | 'partial' | 'clocked-in';\n notes?: string;\n createdAt: string;\n updatedAt: string;\n}\n\nexport interface AttendanceStatus {\n employeeId: number;\n isClocked: boolean;\n clockInTime?: string;\n currentSession?: AttendanceRecord;\n}\n\nexport interface DailyReport {\n date: string;\n totalEmployees: number;\n presentEmployees: number;\n absentEmployees: number;\n lateEmployees: number;\n attendanceRate: number;\n employees: Array<{\n employee: Employee;\n attendance?: AttendanceRecord;\n status: 'present' | 'absent' | 'late' | 'clocked-in';\n }>;\n}\n\nexport interface EmployeeReport {\n employee: Employee;\n totalDays: number;\n presentDays: number;\n absentDays: number;\n totalHours: number;\n averageHours: number;\n attendanceRate: number;\n recentAttendance: AttendanceRecord[];\n}\n\n// API Request/Response types\nexport interface CreateEmployeeRequest {\n employeeId: string;\n firstName: string;\n lastName: string;\n email: string;\n department: string;\n position: string;\n hireDate: string;\n}\n\nexport interface UpdateEmployeeRequest extends Partial {\n isActive?: boolean;\n}\n\nexport interface ClockInRequest {\n employeeId: number;\n notes?: string;\n}\n\nexport interface ClockOutRequest {\n employeeId: number;\n notes?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n message?: string;\n}\n\n// Utility types\nexport type AttendanceStatusType = 'present' | 'absent' | 'partial' | 'clocked-in';\nexport type ReportPeriod = 'daily' | 'weekly' | 'monthly' | 'yearly';",[],[228,235],[228],{"_107":243,"_100":244,"_151":245,"_153":-5,"_154":138,"_155":246,"_157":158,"_109":247,"_104":31,"_160":248,"_162":249,"_163":27,"_164":-5,"_165":250,"_103":251},"a549fc1e-3f65-11f0-bf5c-76b3cceeab13","README.md","a549fce6-3f65-11f0-bf5c-76b3cceeab13",1,["D",1748836624572],"file","# Employee Attendance Tracker\n\nA comprehensive attendance tracking system built with Hono, SQLite, and modern TypeScript.\n\n## Features\n\n- **Employee Management**: Add, edit, and manage employee records\n- **Attendance Tracking**: Clock in/out functionality with timestamp tracking\n- **Reporting**: View attendance reports and statistics\n- **Real-time Updates**: Live attendance status updates\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── employees.ts # Employee CRUD operations\n│ │ ├── attendance.ts # Attendance tracking endpoints\n│ │ └── reports.ts # Reporting endpoints\n│ └── index.ts # Main Hono app entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── EmployeeList.tsx # Employee management\n│ │ ├── AttendanceTracker.tsx # Clock in/out interface\n│ │ └── Reports.tsx # Attendance reports\n│ ├── services/\n│ │ └── api.ts # API service layer\n│ ├── types/\n│ │ └── index.ts # TypeScript interfaces\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared type definitions\n\n```\n\n## API Endpoints\n\n### Employees\n- `GET /api/employees` - List all employees\n- `POST /api/employees` - Create new employee\n- `PUT /api/employees/:id` - Update employee\n- `DELETE /api/employees/:id` - Delete employee\n\n### Attendance\n- `POST /api/attendance/clock-in` - Clock in employee\n- `POST /api/attendance/clock-out` - Clock out employee\n- `GET /api/attendance/status/:employeeId` - Get current status\n- `GET /api/attendance/history/:employeeId` - Get attendance history\n\n### Reports\n- `GET /api/reports/daily` - Daily attendance report\n- `GET /api/reports/employee/:id` - Employee-specific report\n\n## Getting Started\n\n1. The backend will automatically set up the database tables on first run\n2. Navigate to the app to start managing employees and tracking attendance\n3. Use the attendance tracker to clock employees in and out\n4. View reports to analyze attendance patterns\n\n## Technology Stack\n\n- **Backend**: Hono (Express-like framework for Deno)\n- **Database**: SQLite with automatic migrations\n- **Frontend**: TypeScript with React-like components\n- **Styling**: TailwindCSS for responsive design",[],[244],"files",[148,167,173,182,192,199,208,216,226,233,242],"counts",{"_256":31,"_257":246,"_258":31,"_259":31},"pulls","branches","forks","envVars","contents",[262,265,268],{"_107":149,"_100":150,"_151":152,"_153":-5,"_154":138,"_155":156,"_157":158,"_109":263,"_104":31,"_160":161,"_162":-5,"_163":27,"_164":-5,"_103":264},["D",1748836652237],[150],{"_107":227,"_100":228,"_151":229,"_153":-5,"_154":138,"_155":230,"_157":158,"_109":266,"_104":31,"_160":161,"_162":-5,"_163":27,"_164":-5,"_103":267},["D",1748836635899],[228],{"_107":243,"_100":244,"_151":245,"_153":-5,"_154":138,"_155":246,"_157":158,"_109":269,"_104":31,"_160":248,"_162":249,"_163":27,"_164":-5,"_103":270},["D",1748836624572],[244],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history",{"_98":99,"_100":101,"_102":42,"_105":277,"_281":282,"_330":31,"_331":27},{"_107":108,"_100":101,"_109":278,"_111":-5,"_112":27,"_113":114,"_115":-5,"_116":-5,"_12":117,"_118":-5,"_119":27,"_120":-5,"_121":31,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_131":27,"_21":279,"_135":280},["D",1748836549023],{"_98":99,"_133":134},{"_104":137,"_100":42,"_107":138,"_139":108,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":101,"_145":99},"history",[283,288,293,301,306,317,325],{"_151":219,"_104":137,"_109":284,"_154":138,"_252":285},["D",1748836771928],[286],{"_107":217,"_154":138,"_151":219,"_100":218,"_162":221,"_160":178,"_104":31,"_153":195,"_109":284,"_155":137,"_164":-5,"_157":158,"_163":27,"_103":287},[150,194,218],{"_151":202,"_104":203,"_109":289,"_154":138,"_252":290},["D",1748836737501],[291],{"_107":200,"_154":138,"_151":202,"_100":201,"_162":205,"_160":178,"_104":31,"_153":195,"_109":289,"_155":203,"_164":-5,"_157":158,"_163":27,"_103":292},[150,194,201],{"_151":195,"_104":196,"_109":294,"_154":138,"_252":295},["D",1748836715544],[296,298],{"_107":193,"_154":138,"_151":195,"_100":194,"_162":-5,"_160":161,"_104":31,"_153":152,"_109":294,"_155":196,"_164":-5,"_157":158,"_163":27,"_103":297},[150,194],{"_107":209,"_154":138,"_151":211,"_100":210,"_162":213,"_160":178,"_104":31,"_153":195,"_109":299,"_155":196,"_164":-5,"_157":158,"_163":27,"_103":300},["D",1748836715544],[150,194,210],{"_151":185,"_104":186,"_109":302,"_154":138,"_252":303},["D",1748836690008],[304],{"_107":183,"_154":138,"_151":185,"_100":184,"_162":188,"_160":178,"_104":31,"_153":170,"_109":302,"_155":186,"_164":-5,"_157":158,"_163":27,"_103":305},[150,169,184],{"_151":176,"_104":156,"_109":307,"_154":138,"_252":308},["D",1748836652237],[309,311,314],{"_107":174,"_154":138,"_151":176,"_100":175,"_162":179,"_160":178,"_104":31,"_153":170,"_109":307,"_155":156,"_164":-5,"_157":158,"_163":27,"_103":310},[150,169,175],{"_107":168,"_154":138,"_151":170,"_100":169,"_162":-5,"_160":161,"_104":31,"_153":152,"_109":312,"_155":156,"_164":-5,"_157":158,"_163":27,"_103":313},["D",1748836652237],[150,169],{"_107":149,"_154":138,"_151":152,"_100":150,"_162":-5,"_160":161,"_104":31,"_153":-5,"_109":315,"_155":156,"_164":-5,"_157":158,"_163":27,"_103":316},["D",1748836652237],[150],{"_151":229,"_104":230,"_109":318,"_154":138,"_252":319},["D",1748836635899],[320,322],{"_107":227,"_154":138,"_151":229,"_100":228,"_162":-5,"_160":161,"_104":31,"_153":-5,"_109":318,"_155":230,"_164":-5,"_157":158,"_163":27,"_103":321},[228],{"_107":234,"_154":138,"_151":236,"_100":235,"_162":238,"_160":178,"_104":31,"_153":229,"_109":323,"_155":230,"_164":-5,"_157":158,"_163":27,"_103":324},["D",1748836635899],[228,235],{"_151":245,"_104":246,"_109":326,"_154":138,"_252":327},["D",1748836624572],[328],{"_107":243,"_154":138,"_151":245,"_100":244,"_162":249,"_160":248,"_104":31,"_153":-5,"_109":326,"_155":246,"_164":-5,"_157":158,"_163":27,"_103":329},[244],"page","hasNext","routes/_app","actionData","errors"]