[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","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","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_149":150,"_171":172,"_173":-5},"handle","Sandra_Ozumba","name","Freelance101","path","backend/routes/jobs.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_148":20},"id","c64f0be6-3fdf-11f0-8202-76b3cceeab13","createdAt",["D",1748889078572],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b3bfda50-3f94-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","screenshotVersion","likeCount","494564c9-ef48-479b-8c04-cbb954570bd4","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2taaTVINFpVOWRZQjE5NUIyd3V5ZTdyRCJ9","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":116,"_146":96,"_147":94},"version",1,"c652153e-3fdf-11f0-8202-76b3cceeab13","projectId","forkedBranchId","2bc67188-3f97-11f0-93b1-76b3cceeab13","forkedBranchVersion",22,"forkedProjectPrivacy","forkedProjectId","2bc6190e-3f97-11f0-93b1-76b3cceeab13","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":136,"_158":135,"_159":160,"_103":161,"_134":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"c6580886-3fdf-11f0-8202-76b3cceeab13","jobs.ts","fileId","1a9fedb1-deb4-4b0c-817f-c11cb821b542","parentId","4105804b-d11d-4afe-a216-24c0c033c950","branchId","branchVersion","latest",true,["D",1748889078572],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { authMiddleware } from \"./auth.ts\";\nimport { \n createJob, \n getJobs, \n getJobById, \n updateJob,\n createJobApplication,\n getJobApplications\n} from \"../database/queries.ts\";\nimport type { ApiResponse, Job, JobApplication } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs\njobs.get(\"/\", async (c) => {\n try {\n const status = c.req.query(\"status\");\n const limit = parseInt(c.req.query(\"limit\") || \"50\");\n \n const filters: any = { limit };\n if (status) filters.status = status;\n \n const jobsList = await getJobs(filters);\n\n return c.json>({\n success: true,\n data: jobsList\n });\n\n } catch (error) {\n console.error(\"Get jobs error:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch jobs\" \n }, 500);\n }\n});\n\n// Get single job\njobs.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ \n success: false, \n error: \"Invalid job ID\" \n }, 400);\n }\n\n const job = await getJobById(id);\n \n if (!job) {\n return c.json({ \n success: false, \n error: \"Job not found\" \n }, 404);\n }\n\n return c.json>({\n success: true,\n data: job\n });\n\n } catch (error) {\n console.error(\"Get job error:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch job\" \n }, 500);\n }\n});\n\n// Create new job (requires authentication, clients only)\njobs.post(\"/\", authMiddleware, async (c) => {\n try {\n const currentUser = c.get(\"user\");\n const jobData = await c.req.json();\n\n const { title, description, budget_min, budget_max, budget_type, skills_required, deadline } = jobData;\n\n if (!title || !description || !budget_type || !skills_required) {\n return c.json({ \n success: false, \n error: \"Missing required fields\" \n }, 400);\n }\n\n if (!['fixed', 'hourly'].includes(budget_type)) {\n return c.json({ \n success: false, \n error: \"Invalid budget type\" \n }, 400);\n }\n\n // Validate skills_required is a valid JSON array\n let skillsArray;\n try {\n skillsArray = typeof skills_required === 'string' ? JSON.parse(skills_required) : skills_required;\n if (!Array.isArray(skillsArray)) {\n throw new Error(\"Skills must be an array\");\n }\n } catch (e) {\n return c.json({ \n success: false, \n error: \"Skills required must be a valid array\" \n }, 400);\n }\n\n const job = await createJob({\n client_id: currentUser.userId,\n title,\n description,\n budget_min: budget_min ? parseFloat(budget_min) : undefined,\n budget_max: budget_max ? parseFloat(budget_max) : undefined,\n budget_type,\n skills_required: JSON.stringify(skillsArray),\n deadline\n });\n\n return c.json>({\n success: true,\n data: job\n });\n\n } catch (error) {\n console.error(\"Create job error:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create job\" \n }, 500);\n }\n});\n\n// Update job (requires authentication, job owner only)\njobs.put(\"/:id\", authMiddleware, async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const currentUser = c.get(\"user\");\n \n if (isNaN(id)) {\n return c.json({ \n success: false, \n error: \"Invalid job ID\" \n }, 400);\n }\n\n const job = await getJobById(id);\n if (!job) {\n return c.json({ \n success: false, \n error: \"Job not found\" \n }, 404);\n }\n\n // Only job owner can update\n if (job.client_id !== currentUser.userId) {\n return c.json({ \n success: false, \n error: \"Unauthorized\" \n }, 403);\n }\n\n const updates = await c.req.json();\n \n // Validate skills_required if provided\n if (updates.skills_required) {\n try {\n const skillsArray = typeof updates.skills_required === 'string' \n ? JSON.parse(updates.skills_required) \n : updates.skills_required;\n if (!Array.isArray(skillsArray)) {\n throw new Error(\"Skills must be an array\");\n }\n updates.skills_required = JSON.stringify(skillsArray);\n } catch (e) {\n return c.json({ \n success: false, \n error: \"Skills required must be a valid array\" \n }, 400);\n }\n }\n\n const updatedJob = await updateJob(id, updates);\n\n return c.json>({\n success: true,\n data: updatedJob\n });\n\n } catch (error) {\n console.error(\"Update job error:\", error);\n return c.json({ \n success: false, \n error: \"Failed to update job\" \n }, 500);\n }\n});\n\n// Apply to job (requires authentication, freelancers only)\njobs.post(\"/:id/apply\", authMiddleware, async (c) => {\n try {\n const jobId = parseInt(c.req.param(\"id\"));\n const currentUser = c.get(\"user\");\n \n if (isNaN(jobId)) {\n return c.json({ \n success: false, \n error: \"Invalid job ID\" \n }, 400);\n }\n\n const job = await getJobById(jobId);\n if (!job) {\n return c.json({ \n success: false, \n error: \"Job not found\" \n }, 404);\n }\n\n if (job.status !== 'open') {\n return c.json({ \n success: false, \n error: \"Job is not open for applications\" \n }, 400);\n }\n\n const { proposal, proposed_rate } = await c.req.json();\n\n if (!proposal) {\n return c.json({ \n success: false, \n error: \"Proposal is required\" \n }, 400);\n }\n\n const application = await createJobApplication({\n job_id: jobId,\n freelancer_id: currentUser.userId,\n proposal,\n proposed_rate: proposed_rate ? parseFloat(proposed_rate) : undefined\n });\n\n return c.json>({\n success: true,\n data: application\n });\n\n } catch (error) {\n console.error(\"Apply to job error:\", error);\n if (error.message?.includes(\"UNIQUE constraint failed\")) {\n return c.json({ \n success: false, \n error: \"You have already applied to this job\" \n }, 409);\n }\n return c.json({ \n success: false, \n error: \"Failed to apply to job\" \n }, 500);\n }\n});\n\n// Get job applications (requires authentication, job owner only)\njobs.get(\"/:id/applications\", authMiddleware, async (c) => {\n try {\n const jobId = parseInt(c.req.param(\"id\"));\n const currentUser = c.get(\"user\");\n \n if (isNaN(jobId)) {\n return c.json({ \n success: false, \n error: \"Invalid job ID\" \n }, 400);\n }\n\n const job = await getJobById(jobId);\n if (!job) {\n return c.json({ \n success: false, \n error: \"Job not found\" \n }, 404);\n }\n\n // Only job owner can view applications\n if (job.client_id !== currentUser.userId) {\n return c.json({ \n success: false, \n error: \"Unauthorized\" \n }, 403);\n }\n\n const applications = await getJobApplications(jobId);\n\n return c.json>({\n success: true,\n data: applications\n });\n\n } catch (error) {\n console.error(\"Get job applications error:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch applications\" \n }, 500);\n }\n});\n\nexport default jobs;","deleted","label",[169,170,152],"backend","routes","permalink","https://www.val.town/x/Sandra_Ozumba/Freelance101/code/backend/routes/jobs.ts","extension","actionData","errors"]