Property Management System

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","skhomes","name","SKHomesTenantManagement","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","0c58b030-2783-11f0-b46e-569c3dd06744","main.tsx","fileId","0c17a0f4-2783-11f0-b46e-569c3dd06744","parentId","branchId","0c14a584-2783-11f0-b46e-569c3dd06744","branchVersion",11,"latest",true,"createdAt",["D",1736749772054],10,"fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\n// [Previous code remains unchanged]\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"SKHomesTenantManagement\";\n const SCHEMA_VERSION = 3;\n\n // CSS definition moved inside the server function\n const css = `\n body {\n font-family: Arial, sans-serif;\n max-width: 1200px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n }\n\n h1 {\n text-align: center;\n color: #333;\n }\n\n .tab-navigation {\n display: flex;\n justify-content: center;\n margin-bottom: 20px;\n }\n\n .tab-navigation button {\n margin: 0 10px;\n padding: 10px 20px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n transition: background-color 0.3s;\n }\n\n .tab-navigation button:hover {\n background-color: #45a049;\n }\n\n .property-form, .tenant-form, .lease-form, .payment-form {\n background-color: white;\n padding: 20px;\n border-radius: 8px;\n box-shadow: 0 2px 4px rgba(0,0,0,0.1);\n margin-bottom: 20px;\n }\n\n .property-form input, \n .property-form select,\n .tenant-form input, \n .tenant-form select,\n .lease-form input, \n .lease-form select,\n .payment-form input, \n .payment-form select {\n width: 100%;\n padding: 10px;\n margin-bottom: 10px;\n border: 1px solid #ddd;\n border-radius: 4px;\n }\n\n .property-form button, \n .tenant-form button,\n .lease-form button,\n .payment-form button {\n width: 100%;\n padding: 10px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n }\n\n .property-list, \n .tenant-list,\n .lease-list,\n .payment-list {\n display: grid;\n grid-template-columns: repeat(auto-fill, minmax(250px, 1fr));\n gap: 15px;\n }\n\n .property-card, \n .tenant-card,\n .lease-card,\n .payment-card {\n background-color: white;\n border-radius: 8px;\n padding: 15px;\n box-shadow: 0 2px 4px rgba(0,0,0,0.1);\n }\n\n .card-actions {\n display: flex;\n justify-content: space-between;\n margin-top: 10px;\n }\n\n .card-actions button {\n flex: 1;\n margin: 0 5px;\n padding: 5px;\n background-color: #2196F3;\n color: white;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n }\n\n .card-actions button:last-child {\n background-color: #f44336;\n }\n\n footer {\n text-align: center;\n margin-top: 20px;\n padding: 10px;\n background-color: #f1f1f1;\n }\n\n footer a {\n color: #333;\n text-decoration: none;\n display: flex;\n justify-content: center;\n align-items: center;\n gap: 10px;\n }\n\n footer a:hover {\n color: #4CAF50;\n }\n `;\n\n // [Previous table creation code remains unchanged]\n\n // Payment routes\n if (request.method === 'GET' && new URL(request.url).pathname === '/payments') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_payments_${SCHEMA_VERSION}`);\n return new Response(JSON.stringify(result.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/payments') {\n const data = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_payments_${SCHEMA_VERSION} \n (leaseId, amount, paymentDate, paymentMethod, status) \n VALUES (?, ?, ?, ?, ?)`,\n [\n data.leaseId, \n data.amount, \n data.paymentDate, \n data.paymentMethod, \n data.status\n ]\n );\n return new Response('Payment added', { status: 201 });\n }\n\n if (request.method === 'PUT' && /^\\/payments\\/\\d+$/.test(new URL(request.url).pathname)) {\n const id = new URL(request.url).pathname.split('/').pop();\n const data = await request.json();\n \n await sqlite.execute(\n `UPDATE ${KEY}_payments_${SCHEMA_VERSION} \n SET leaseId = ?, amount = ?, paymentDate = ?, \n paymentMethod = ?, status = ?\n WHERE id = ?`,\n [\n data.leaseId, \n data.amount, \n data.paymentDate, \n data.paymentMethod, \n data.status,\n id\n ]\n );\n return new Response('Payment updated', { status: 200 });\n }\n\n if (request.method === 'DELETE' && /^\\/payments\\/\\d+$/.test(new URL(request.url).pathname)) {\n const id = new URL(request.url).pathname.split('/').pop();\n await sqlite.execute(`DELETE FROM ${KEY}_payments_${SCHEMA_VERSION} WHERE id = ?`, [id]);\n return new Response('Payment deleted', { status: 200 });\n }\n\n // Properties routes\n if (request.method === 'GET' && new URL(request.url).pathname === '/properties') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_properties_2`);\n return new Response(JSON.stringify(result.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Render the main HTML page\n return new Response(`\n \n \n Property Management System\n \n \n \n \n

\n \n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\n// [Rest of the previous code remains unchanged]","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1736749772054],"children",[],[35],"0c1455e8-2783-11f0-b46e-569c3dd06744",["D",1746210424532],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","91d3365e-1092-4441-b95f-32fa91469e7d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","85fa5374-d90c-4239-8aa5-e325d1a41afd","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJyVzdqcUkyMFZ6R3M3bVprQ1JsZFZzckhSQiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":148,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":149,"_95":150,"_97":151,"_99":53},[145],"files",[145],"counts",{"_135":77,"_136":137,"_138":77,"_31":139,"_140":141},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches",1,"forks",{"_142":77,"_144":77},"connections",{"_142":77,"_143":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":146,"_18":147},[],[35],["D",1746210424532],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":185,"_186":187,"_188":189,"_190":53,"_191":53,"_192":53,"_193":44,"_194":-5,"_195":-7,"_196":-7,"_197":77,"_198":53,"_199":53,"_200":-5,"_201":53,"_202":53,"_203":53,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":16,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code