[{"_1":2,"_173":-5,"_174":-5},"loaderData",{"_3":4,"_96":97,"_172":-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/embed.x.$handle.$name.$",{"_98":99,"_100":101,"_102":103,"_104":105,"_146":147,"_169":170,"_171":-5},"handle","DHIRAJ7655","name","Attendancetracker","path","backend/routes/employees.ts","project",{"_106":107,"_100":101,"_108":109,"_110":-5,"_111":27,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":-5,"_118":27,"_119":-5,"_120":31,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_130":27,"_21":131,"_134":135},"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,"_132":133},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4dzVadVNocFFOMWdNOERhblZUbm44TU5saSJ9","branch",{"_136":137,"_100":42,"_106":138,"_139":107,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":101,"_145":99},"version",7,"78416e32-3f65-11f0-8979-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","projectName","userHandle","file",{"_106":148,"_100":149,"_150":151,"_152":153,"_154":138,"_155":156,"_157":158,"_108":159,"_136":31,"_160":161,"_162":163,"_164":27,"_165":-5,"_102":166},"db8328c8-3f65-11f0-aee7-76b3cceeab13","employees.ts","fileId","db8329a4-3f65-11f0-aee7-76b3cceeab13","parentId","330405be-b248-4b58-9e2c-b1d31ad37aaf","branchId","branchVersion",5,"latest",true,["D",1748836715544],"fileType","script","content","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;","deleted","label",[167,168,149],"backend","routes","permalink","https://www.val.town/x/DHIRAJ7655/Attendancetracker/code/backend/routes/employees.ts","extension","routes/embed","actionData","errors"]