[{"_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","a31a1550ad486cf340b818a53bc6ddc8c7db0295","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","eddie_walk","name","crm_OBUO_FARMS","path","backend/routes/financial.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":113,"_114":115,"_116":115,"_117":-5,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","755ce5fe-3fc7-11f0-a0be-76b3cceeab13","createdAt",["D",1748878634852],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","438ac540-3faf-11f0-b6e9-ab0b2f88b858","pinnedFileId","aa24c482-3fc7-11f0-b39e-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","8de6586a-f8f9-4d30-9bd2-782698026a59","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHg4QWVmMkZjWUdaNm1Jc0ZiVGs4UzBabnMifQ","org",{"_93":94,"_134":131,"_12":111},"avatar","branch",{"_137":138,"_95":43,"_101":139,"_140":102,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"version",185,"755d5430-3fc7-11f0-a0be-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":139,"_158":159,"_160":115,"_103":161,"_137":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"fe7d34ba-40a3-11f0-a4ec-76b3cceeab13","financial.ts","fileId","fe7d3596-40a3-11f0-a4ec-76b3cceeab13","parentId","508df672-cfbd-427c-8be9-768fe70216b9","branchId","branchVersion",149,"latest",["D",1748973354187],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createExpense, getAllExpenses, getExpenseById, updateExpense, deleteExpense,\n createRevenue, getAllRevenue, getRevenueById, updateRevenue, deleteRevenue,\n getFinancialSummary, getSalesReport\n} from \"../database/queries.ts\";\nimport type { \n CreateExpenseRequest, Expense, Revenue, FinancialSummary, SalesReport,\n ApiResponse \n} from \"../../shared/types.ts\";\n\nconst financial = new Hono();\n\n// Expense routes\nfinancial.post(\"/expenses\", async (c) => {\n try {\n const expenseData: CreateExpenseRequest = await c.req.json();\n \n // Validate required fields\n const requiredFields = ['category', 'description', 'amount', 'date'];\n for (const field of requiredFields) {\n if (!expenseData[field as keyof CreateExpenseRequest]) {\n return c.json>({\n success: false,\n error: `Missing required field: ${field}`\n }, 400);\n }\n }\n \n // Validate amount is positive\n if (expenseData.amount <= 0) {\n return c.json>({\n success: false,\n error: \"Amount must be greater than 0\"\n }, 400);\n }\n \n const newExpense = await createExpense(expenseData);\n \n return c.json>({\n success: true,\n data: newExpense\n }, 201);\n \n } catch (error) {\n console.error('Error creating expense:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : \"Failed to create expense\"\n }, 500);\n }\n});\n\nfinancial.get(\"/expenses\", async (c) => {\n try {\n const startDate = c.req.query('startDate');\n const endDate = c.req.query('endDate');\n const category = c.req.query('category');\n \n const expenses = await getAllExpenses(startDate, endDate, category);\n \n return c.json>({\n success: true,\n data: expenses\n });\n } catch (error) {\n console.error('Error fetching expenses:', error);\n return c.json>({\n success: false,\n error: \"Failed to fetch expenses\"\n }, 500);\n }\n});\n\nfinancial.get(\"/expenses/: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 expense ID\"\n }, 400);\n }\n \n const expense = await getExpenseById(id);\n if (!expense) {\n return c.json>({\n success: false,\n error: \"Expense not found\"\n }, 404);\n }\n \n return c.json>({\n success: true,\n data: expense\n });\n } catch (error) {\n console.error('Error fetching expense:', error);\n return c.json>({\n success: false,\n error: \"Failed to fetch expense\"\n }, 500);\n }\n});\n\nfinancial.put(\"/expenses/: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 expense ID\"\n }, 400);\n }\n \n const updateData: Partial = await c.req.json();\n const updatedExpense = await updateExpense(id, updateData);\n \n if (!updatedExpense) {\n return c.json>({\n success: false,\n error: \"Expense not found\"\n }, 404);\n }\n \n return c.json>({\n success: true,\n data: updatedExpense\n });\n } catch (error) {\n console.error('Error updating expense:', error);\n return c.json>({\n success: false,\n error: \"Failed to update expense\"\n }, 500);\n }\n});\n\nfinancial.delete(\"/expenses/: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 expense ID\"\n }, 400);\n }\n \n const deleted = await deleteExpense(id);\n if (!deleted) {\n return c.json>({\n success: false,\n error: \"Expense not found\"\n }, 404);\n }\n \n return c.json>({\n success: true\n });\n } catch (error) {\n console.error('Error deleting expense:', error);\n return c.json>({\n success: false,\n error: \"Failed to delete expense\"\n }, 500);\n }\n});\n\n// Revenue routes\nfinancial.post(\"/revenue\", async (c) => {\n try {\n const revenueData = await c.req.json();\n \n // Validate required fields\n const requiredFields = ['source', 'description', 'amount', 'date'];\n for (const field of requiredFields) {\n if (!revenueData[field]) {\n return c.json>({\n success: false,\n error: `Missing required field: ${field}`\n }, 400);\n }\n }\n \n // Validate amount is positive\n if (revenueData.amount <= 0) {\n return c.json>({\n success: false,\n error: \"Amount must be greater than 0\"\n }, 400);\n }\n \n const newRevenue = await createRevenue(revenueData);\n \n return c.json>({\n success: true,\n data: newRevenue\n }, 201);\n \n } catch (error) {\n console.error('Error creating revenue:', error);\n return c.json>({\n success: false,\n error: error instanceof Error ? error.message : \"Failed to create revenue\"\n }, 500);\n }\n});\n\nfinancial.get(\"/revenue\", async (c) => {\n try {\n const startDate = c.req.query('startDate');\n const endDate = c.req.query('endDate');\n const source = c.req.query('source');\n \n const revenue = await getAllRevenue(startDate, endDate, source);\n \n return c.json>({\n success: true,\n data: revenue\n });\n } catch (error) {\n console.error('Error fetching revenue:', error);\n return c.json>({\n success: false,\n error: \"Failed to fetch revenue\"\n }, 500);\n }\n});\n\n// Financial summary and reports\nfinancial.get(\"/summary\", async (c) => {\n try {\n const period = c.req.query('period') || 'month'; // month, quarter, year\n const startDate = c.req.query('startDate');\n const endDate = c.req.query('endDate');\n \n const summary = await getFinancialSummary(period, startDate, endDate);\n \n return c.json>({\n success: true,\n data: summary\n });\n } catch (error) {\n console.error('Error generating financial summary:', error);\n return c.json>({\n success: false,\n error: \"Failed to generate financial summary\"\n }, 500);\n }\n});\n\nfinancial.get(\"/sales-report\", async (c) => {\n try {\n const period = c.req.query('period') || 'month';\n const startDate = c.req.query('startDate');\n const endDate = c.req.query('endDate');\n \n const report = await getSalesReport(period, startDate, endDate);\n \n return c.json>({\n success: true,\n data: report\n });\n } catch (error) {\n console.error('Error generating sales report:', error);\n return c.json>({\n success: false,\n error: \"Failed to generate sales report\"\n }, 500);\n }\n});\n\nexport default financial;","deleted","label",[169,170,152],"backend","routes","permalink","https://www.val.town/x/eddie_walk/crm_OBUO_FARMS/code/backend/routes/financial.ts","extension","actionData","errors"]