[{"_1":2,"_180":-5,"_181":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":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","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_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":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","1f1a009cadcf7353a37b999b92a7f8af633192ea","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",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":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",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_155":156,"_177":178,"_179":-5},"handle","Mouhak","name","my-first-val","path","backend/routes/projects.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":-5,"_112":-5,"_12":113,"_114":115,"_116":117,"_118":117,"_119":-5,"_120":33,"_14":121,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_154":20},"id","c0416410-41a6-11f0-b07e-76b3cceeab13","createdAt",["D",1749084489435],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b4fcfa60-41a6-11f0-a933-b14e0af544f0","pinnedFileId","c049a616-41a6-11f0-b07e-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","e472d355-967c-4f88-94c6-a3576ff331c2","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeTRDU3ZUOHAwTzhHaVE3RkhOM2IzWWoxV3IifQ","org",{"_95":96,"_138":135,"_12":113,"_139":140},"avatar","tier","free","branch",{"_143":144,"_97":45,"_103":145,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},"version",27,"c041aa42-41a6-11f0-b07e-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":157,"_97":158,"_159":160,"_161":162,"_163":145,"_164":165,"_166":117,"_105":167,"_143":33,"_168":169,"_170":171,"_172":20,"_173":-5,"_99":174},"2dec5dc2-4219-11f0-9043-76b3cceeab13","projects.ts","fileId","2dec5e6c-4219-11f0-9043-76b3cceeab13","parentId","e1d9f16e-2350-4063-b0ca-4d97566fd4d1","branchId","branchVersion",17,"latest",["D",1749133636049],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { requireAuth, requireAgency } from \"./auth.ts\";\nimport {\n getAllProjects,\n getProjectsByCustomerId,\n getProjectById,\n createProject,\n updateProject,\n getDashboardStats,\n createProjectUpdate\n} from \"../database/queries.ts\";\nimport type { User, Project, ApiResponse, ProjectFormData, DashboardStats } from \"../../shared/types.ts\";\n\nconst projects = new Hono();\n\n// Get dashboard stats\nprojects.get(\"/stats\", requireAuth(), async (c) => {\n try {\n const user = c.get('user') as User;\n const customerId = user.role === 'customer' ? user.id : undefined;\n \n const stats = await getDashboardStats(customerId);\n \n return c.json>({\n success: true,\n data: stats\n });\n } catch (error) {\n console.error(\"Error fetching dashboard stats:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch dashboard stats\"\n }, 500);\n }\n});\n\n// Get all projects (agency) or user's projects (customer)\nprojects.get(\"/\", requireAuth(), async (c) => {\n try {\n const user = c.get('user') as User;\n let projectList: Project[];\n\n if (user.role === 'agency') {\n projectList = await getAllProjects();\n } else {\n projectList = await getProjectsByCustomerId(user.id);\n }\n\n return c.json>({\n success: true,\n data: projectList\n });\n } catch (error) {\n console.error(\"Error fetching projects:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch projects\"\n }, 500);\n }\n});\n\n// Get specific project\nprojects.get(\"/:id\", requireAuth(), async (c) => {\n try {\n const projectId = parseInt(c.req.param('id'));\n const user = c.get('user') as User;\n \n const project = await getProjectById(projectId);\n \n if (!project) {\n return c.json>({\n success: false,\n error: \"Project not found\"\n }, 404);\n }\n\n // Check if customer can access this project\n if (user.role === 'customer' && project.customer_id !== user.id) {\n return c.json>({\n success: false,\n error: \"Access denied\"\n }, 403);\n }\n\n return c.json>({\n success: true,\n data: project\n });\n } catch (error) {\n console.error(\"Error fetching project:\", error);\n return c.json>({\n success: false,\n error: \"Failed to fetch project\"\n }, 500);\n }\n});\n\n// Create new project (agency only)\nprojects.post(\"/\", requireAuth(), requireAgency(), async (c) => {\n try {\n const projectData = await c.req.json() as ProjectFormData & { customer_id: number };\n \n if (!projectData.title || !projectData.customer_id) {\n return c.json>({\n success: false,\n error: \"Title and customer ID are required\"\n }, 400);\n }\n\n const project = await createProject(projectData);\n \n // Create initial project update\n const user = c.get('user') as User;\n await createProjectUpdate({\n project_id: project.id,\n user_id: user.id,\n title: \"Project Created\",\n description: `Project \"${project.title}\" has been created and assigned.`,\n update_type: \"general\"\n });\n\n return c.json>({\n success: true,\n data: project\n }, 201);\n } catch (error) {\n console.error(\"Error creating project:\", error);\n return c.json>({\n success: false,\n error: \"Failed to create project\"\n }, 500);\n }\n});\n\n// Update project\nprojects.put(\"/:id\", requireAuth(), async (c) => {\n try {\n const projectId = parseInt(c.req.param('id'));\n const user = c.get('user') as User;\n const updates = await c.req.json() as Partial;\n \n const existingProject = await getProjectById(projectId);\n \n if (!existingProject) {\n return c.json>({\n success: false,\n error: \"Project not found\"\n }, 404);\n }\n\n // Check permissions\n if (user.role === 'customer' && existingProject.customer_id !== user.id) {\n return c.json>({\n success: false,\n error: \"Access denied\"\n }, 403);\n }\n\n // Customers can only update certain fields\n if (user.role === 'customer') {\n const allowedFields = ['description'];\n const filteredUpdates = Object.keys(updates)\n .filter(key => allowedFields.includes(key))\n .reduce((obj, key) => {\n obj[key] = updates[key as keyof typeof updates];\n return obj;\n }, {} as any);\n \n if (Object.keys(filteredUpdates).length === 0) {\n return c.json>({\n success: false,\n error: \"No valid fields to update\"\n }, 400);\n }\n \n Object.assign(updates, filteredUpdates);\n }\n\n const updatedProject = await updateProject(projectId, updates);\n \n if (!updatedProject) {\n return c.json>({\n success: false,\n error: \"Failed to update project\"\n }, 500);\n }\n\n // Create project update entry\n const changedFields = Object.keys(updates).join(', ');\n await createProjectUpdate({\n project_id: projectId,\n user_id: user.id,\n title: \"Project Updated\",\n description: `Project details updated: ${changedFields}`,\n update_type: \"general\"\n });\n\n return c.json>({\n success: true,\n data: updatedProject\n });\n } catch (error) {\n console.error(\"Error updating project:\", error);\n return c.json>({\n success: false,\n error: \"Failed to update project\"\n }, 500);\n }\n});\n\n// Delete project (agency only)\nprojects.delete(\"/:id\", requireAuth(), requireAgency(), async (c) => {\n try {\n const projectId = parseInt(c.req.param('id'));\n \n const project = await getProjectById(projectId);\n if (!project) {\n return c.json>({\n success: false,\n error: \"Project not found\"\n }, 404);\n }\n\n // In a real app, you'd want to soft delete or archive\n // For now, we'll just return success (implement actual deletion if needed)\n \n return c.json>({\n success: true\n });\n } catch (error) {\n console.error(\"Error deleting project:\", error);\n return c.json>({\n success: false,\n error: \"Failed to delete project\"\n }, 500);\n }\n});\n\nexport default projects;","deleted","label",[175,176,158],"backend","routes","permalink","https://www.val.town/x/Mouhak/my-first-val/code/backend/routes/projects.ts","extension","actionData","errors"]