Eagle Majdes Homes and Services - Premium Real Estate Development

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_245":246,"_247":248},"routes/_app.x.$handle.$name",{"_100":99,"_32":49,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_21":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_37":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",7,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":21,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","8d34c42e-3f97-11f0-b61b-76b3cceeab13","name","index.html","fileType","content","\n\n\n \n \n Eagle Majdes Homes and Services - Premium Real Estate Development\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

\n \n \n \n\n","createdAt",["D",1748858059004],"branchVersion","branchId","152faf2c-3f95-11f0-b173-76b3cceeab13",{"_30":44,"_32":43,"_34":45,"_35":-5,"_37":46,"_39":14,"_40":41,"_24":25},"frontend","077505a7-9b72-48b3-a05b-54765d2f1a23","directory",["D",1748858059004],"id","152f65bc-3f95-11f0-b173-76b3cceeab13","Eaglemajdes",["D",1748856998657],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","872916a2-3f97-11f0-a526-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","180d29bb-29b4-41f4-a984-6297ecbf663d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_47":41,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"isOwned",27,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","godinoarts","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_37":241,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":60,"_61":62,"_63":62,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":242,"_84":243,"_86":244,"_88":25},"tree",[169,174,176,179],"files",[169,170,171,172,173,174,175,176,177,178,179],"counts",{"_159":66,"_160":147,"_161":66,"_162":163,"_164":165},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":153,"_32":154,"_30":155,"_137":-5,"_40":41,"_39":156,"_139":62,"_37":157,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":158},{"_47":150,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_139":62,"_37":151,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":152},{"_47":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":62,"_37":148,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_27":149},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":25,"_37":140,"_13":66,"_34":21,"_35":141,"_24":25,"_142":-5,"_27":143},"48fd236e-3f97-11f0-bcf9-76b3cceeab13","README.md","48fd2418-3f97-11f0-bcf9-76b3cceeab13","parentId",1,"latest",["D",1748857944556],"# Eagle Majdes Homes and Services Website\n\nA professional real estate website for Eagle Majdes Homes and Services, specializing in estate development and land sales.\n\n## Project Structure\n\n### Backend (`/backend/`)\n- `index.ts` - Main Hono server with API routes\n- `database/` - SQLite database setup and queries\n- `routes/` - API route handlers\n\n### Frontend (`/frontend/`)\n- `index.html` - Main HTML template\n- `index.tsx` - React application entry point\n- `components/` - React components\n- `style.css` - Custom styles\n\n### Shared (`/shared/`)\n- `types.ts` - TypeScript interfaces and types\n- `utils.ts` - Shared utility functions\n\n## Features\n\n- 🏡 Multiple estate \"Gardens\" showcase\n- 💰 Payment system with Naira (₦) support\n- 👤 User dashboard for tracking interests and payments\n- 💬 Live chat support\n- 📱 Responsive design\n- 🎨 Modern UI with icons and clean design\n\n## Gardens/Estates\n\n1. Jason's Garden\n2. Eagle's Garden\n3. Victoria's Garden\n4. Samuel's Garden\n5. Grace's Garden\n6. David's Garden\n7. Faith's Garden\n\n## Locations\n\n- Most gardens: Ogbeke Nike, Ama-Awji Nike, Agbogazi Nike\n- One estate: Centenary City, Enugu\n\n## Contact Information\n\n**Phone:** 08164878281, 09031232662, 09029217460\n**Address:** Suite C15 Elim Plaza, Ebeano Tunnel, Ogui Enugu, Enugu State\n**Social Media:** Facebook: Eagle_Majdes, Instagram: EagleMajdes, TikTok: Eagle_Majdesltd","label",[135],"564c512a-3f97-11f0-9d7b-76b3cceeab13","shared","0b2e8428-772a-40b5-94ae-735ce56fc29e",2,["D",1748857966884],[145],"8d34ce38-3f97-11f0-b61b-76b3cceeab13",["D",1748858059004],[43],"644f5e98-3f97-11f0-9634-76b3cceeab13","backend","4eb8dc60-c7e4-46b4-b604-701b790434da",4,["D",1748857990392],[154],"pulls","branches","forks","envVars",{"_166":66,"_168":66},"connections",{"_166":66,"_167":66},"count","unfilledCount","emptyCount",{"_47":153,"_32":154,"_30":155,"_137":-5,"_40":41,"_39":156,"_139":62,"_37":238,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_181":239,"_27":240},{"_47":234,"_32":226,"_30":220,"_137":155,"_40":41,"_39":156,"_139":62,"_37":235,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_181":236,"_27":237},{"_47":227,"_32":228,"_30":229,"_137":220,"_40":41,"_39":156,"_139":62,"_37":230,"_13":66,"_34":189,"_35":231,"_24":25,"_142":-5,"_181":232,"_27":233},{"_47":217,"_32":218,"_30":219,"_137":220,"_40":41,"_39":221,"_139":62,"_37":222,"_13":66,"_34":189,"_35":223,"_24":25,"_142":-5,"_181":224,"_27":225},{"_47":210,"_32":211,"_30":60,"_137":155,"_40":41,"_39":212,"_139":25,"_37":213,"_13":66,"_34":189,"_35":214,"_24":25,"_142":-5,"_181":215,"_27":216},{"_47":150,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_139":62,"_37":207,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_181":208,"_27":209},{"_47":203,"_32":33,"_30":31,"_137":44,"_40":41,"_39":14,"_139":62,"_37":204,"_13":66,"_34":21,"_35":36,"_24":25,"_142":-5,"_181":205,"_27":206},{"_47":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":62,"_37":200,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_181":201,"_27":202},{"_47":193,"_32":194,"_30":195,"_137":146,"_40":41,"_39":147,"_139":62,"_37":196,"_13":66,"_34":189,"_35":197,"_24":25,"_142":-5,"_181":198,"_27":199},{"_47":184,"_32":185,"_30":186,"_137":146,"_40":41,"_39":187,"_139":62,"_37":188,"_13":66,"_34":189,"_35":190,"_24":25,"_142":-5,"_181":191,"_27":192},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":25,"_37":180,"_13":66,"_34":21,"_35":141,"_24":25,"_142":-5,"_181":182,"_27":183},["D",1748857944556],"children",[],[135],"5be10aae-3f97-11f0-a968-76b3cceeab13","utils.ts","5be10b44-3f97-11f0-a968-76b3cceeab13",3,["D",1748857976252],"script","// Shared utility functions\n\nexport function formatCurrency(amount: number, currency: string = 'NGN'): string {\n if (currency === 'NGN') {\n return `₦${amount.toLocaleString()}`;\n }\n return `${currency} ${amount.toLocaleString()}`;\n}\n\nexport function formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n}\n\nexport function generateId(): string {\n return Math.random().toString(36).substr(2, 9);\n}\n\nexport function slugify(text: string): string {\n return text\n .toLowerCase()\n .replace(/[^\\w\\s-]/g, '')\n .replace(/[\\s_-]+/g, '-')\n .replace(/^-+|-+$/g, '');\n}\n\nexport function validateEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\nexport function validatePhone(phone: string): boolean {\n const phoneRegex = /^[\\+]?[0-9\\s\\-\$\$]{10,}$/;\n return phoneRegex.test(phone);\n}\n\nexport function truncateText(text: string, maxLength: number): string {\n if (text.length <= maxLength) return text;\n return text.substr(0, maxLength) + '...';\n}\n\nexport function getInitials(name: string): string {\n return name\n .split(' ')\n .map(word => word.charAt(0).toUpperCase())\n .join('')\n .substr(0, 2);\n}",[],[145,185],"564c41c6-3f97-11f0-9d7b-76b3cceeab13","types.ts","564c427a-3f97-11f0-9d7b-76b3cceeab13",["D",1748857966884],"// Shared TypeScript types and interfaces\n\nexport interface Garden {\n id: string;\n name: string;\n location: string;\n description: string;\n priceRange: string;\n availablePlots: number;\n totalPlots: number;\n amenities: string[];\n images: string[];\n featured: boolean;\n}\n\nexport interface Property {\n id: string;\n gardenId: string;\n plotNumber: string;\n size: string;\n price: number;\n status: 'available' | 'reserved' | 'sold';\n description: string;\n coordinates?: {\n lat: number;\n lng: number;\n };\n}\n\nexport interface User {\n id: string;\n name: string;\n email: string;\n phone: string;\n interests: string[]; // Garden IDs\n payments: Payment[];\n bookings: Booking[];\n}\n\nexport interface Payment {\n id: string;\n userId: string;\n propertyId: string;\n amount: number;\n currency: 'NGN';\n status: 'pending' | 'completed' | 'failed';\n paymentMethod: string;\n createdAt: string;\n completedAt?: string;\n}\n\nexport interface Booking {\n id: string;\n userId: string;\n propertyId: string;\n status: 'pending' | 'confirmed' | 'cancelled';\n createdAt: string;\n notes?: string;\n}\n\nexport interface ChatMessage {\n id: string;\n message: string;\n sender: 'user' | 'support';\n timestamp: string;\n}\n\nexport interface ContactInfo {\n phones: string[];\n address: string;\n social: {\n facebook: string;\n instagram: string;\n tiktok: string;\n };\n}\n\nexport const CONTACT_INFO: ContactInfo = {\n phones: ['08164878281', '09031232662', '09029217460'],\n address: 'Suite C15 Elim Plaza, Ebeano Tunnel, Ogui Enugu, Enugu State',\n social: {\n facebook: 'Eagle_Majdes',\n instagram: 'EagleMajdes',\n tiktok: 'Eagle_Majdesltd'\n }\n};\n\nexport const GARDENS_DATA: Garden[] = [\n {\n id: 'jasons-garden',\n name: \"Jason's Garden\",\n location: 'Ogbeke Nike',\n description: 'A premium residential estate with modern amenities and excellent infrastructure.',\n priceRange: '₦2.5M - ₦5M',\n availablePlots: 45,\n totalPlots: 100,\n amenities: ['24/7 Security', 'Good Road Network', 'Electricity', 'Water Supply', 'Drainage System'],\n images: [],\n featured: true\n },\n {\n id: 'eagles-garden',\n name: \"Eagle's Garden\",\n location: 'Ama-Awji Nike',\n description: 'Our flagship estate offering luxury living with comprehensive facilities.',\n priceRange: '₦3M - ₦7M',\n availablePlots: 32,\n totalPlots: 80,\n amenities: ['Gated Community', 'Recreation Center', 'Shopping Complex', 'School', 'Hospital'],\n images: [],\n featured: true\n },\n {\n id: 'victorias-garden',\n name: \"Victoria's Garden\",\n location: 'Agbogazi Nike',\n description: 'Affordable housing solution with quality infrastructure and peaceful environment.',\n priceRange: '₦1.8M - ₦4M',\n availablePlots: 67,\n totalPlots: 120,\n amenities: ['Security', 'Road Network', 'Electricity', 'Water'],\n images: [],\n featured: false\n },\n {\n id: 'samuels-garden',\n name: \"Samuel's Garden\",\n location: 'Ogbeke Nike',\n description: 'Family-oriented estate with excellent connectivity and modern amenities.',\n priceRange: '₦2.2M - ₦4.5M',\n availablePlots: 28,\n totalPlots: 90,\n amenities: ['Playground', 'Security', 'Good Roads', 'Power Supply'],\n images: [],\n featured: false\n },\n {\n id: 'graces-garden',\n name: \"Grace's Garden\",\n location: 'Centenary City, Enugu',\n description: 'Premium estate in the heart of Enugu with luxury amenities and prime location.',\n priceRange: '₦4M - ₦8M',\n availablePlots: 15,\n totalPlots: 50,\n amenities: ['Luxury Clubhouse', 'Swimming Pool', 'Gym', 'Security', 'Parking'],\n images: [],\n featured: true\n },\n {\n id: 'davids-garden',\n name: \"David's Garden\",\n location: 'Ama-Awji Nike',\n description: 'Serene residential estate perfect for young families and professionals.',\n priceRange: '₦2M - ₦4.2M',\n availablePlots: 41,\n totalPlots: 85,\n amenities: ['Security', 'Good Roads', 'Electricity', 'Water Supply'],\n images: [],\n featured: false\n },\n {\n id: 'faiths-garden',\n name: \"Faith's Garden\",\n location: 'Agbogazi Nike',\n description: 'Peaceful estate with natural surroundings and modern infrastructure.',\n priceRange: '₦1.9M - ₦3.8M',\n availablePlots: 53,\n totalPlots: 110,\n amenities: ['Green Spaces', 'Security', 'Road Network', 'Utilities'],\n images: [],\n featured: false\n }\n];",[],[145,194],["D",1748857966884],[177,178],[145],"8d34c35c-3f97-11f0-b61b-76b3cceeab13",["D",1748858059004],[],[43,33],["D",1748858059004],[175],[43],"872915da-3f97-11f0-a526-76b3cceeab13","index.ts",6,["D",1748858048864],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { \n createUser, \n getUserById, \n getUserByEmail,\n createProperty,\n getPropertiesByGarden,\n getAvailableProperties,\n createPayment,\n updatePaymentStatus,\n createBooking,\n addUserInterest,\n removeUserInterest,\n saveChatMessage,\n getChatMessages\n} from \"./database/queries.ts\";\nimport { GARDENS_DATA, CONTACT_INFO } from \"../shared/types.ts\";\nimport { generateId, validateEmail, validatePhone } from \"../shared/utils.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\n// Comment out after first run for better performance\nawait runMigrations();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main page with initial data injection\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const initialData = {\n gardens: GARDENS_DATA,\n contact: CONTACT_INFO,\n featuredGardens: GARDENS_DATA.filter(g => g.featured)\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes\n\n// Get all gardens\napp.get(\"/api/gardens\", c => {\n return c.json(GARDENS_DATA);\n});\n\n// Get specific garden\napp.get(\"/api/gardens/:id\", c => {\n const gardenId = c.req.param(\"id\");\n const garden = GARDENS_DATA.find(g => g.id === gardenId);\n \n if (!garden) {\n return c.json({ error: \"Garden not found\" }, 404);\n }\n \n return c.json(garden);\n});\n\n// Get properties for a garden\napp.get(\"/api/gardens/:id/properties\", async c => {\n const gardenId = c.req.param(\"id\");\n const properties = await getPropertiesByGarden(gardenId);\n return c.json(properties);\n});\n\n// Get all available properties\napp.get(\"/api/properties\", async c => {\n const properties = await getAvailableProperties();\n return c.json(properties);\n});\n\n// User registration/login\napp.post(\"/api/users\", async c => {\n const body = await c.req.json();\n const { name, email, phone } = body;\n \n if (!name || !email || !phone) {\n return c.json({ error: \"Name, email, and phone are required\" }, 400);\n }\n \n if (!validateEmail(email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n \n if (!validatePhone(phone)) {\n return c.json({ error: \"Invalid phone format\" }, 400);\n }\n \n // Check if user already exists\n const existingUser = await getUserByEmail(email);\n if (existingUser) {\n return c.json(existingUser);\n }\n \n // Create new user\n const userId = generateId();\n const user = await createUser({\n id: userId,\n name,\n email,\n phone\n });\n \n return c.json(user, 201);\n});\n\n// Get user by ID\napp.get(\"/api/users/:id\", async c => {\n const userId = c.req.param(\"id\");\n const user = await getUserById(userId);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n return c.json(user);\n});\n\n// Add user interest\napp.post(\"/api/users/:id/interests\", async c => {\n const userId = c.req.param(\"id\");\n const { gardenId } = await c.req.json();\n \n if (!gardenId) {\n return c.json({ error: \"Garden ID is required\" }, 400);\n }\n \n await addUserInterest(userId, gardenId);\n return c.json({ success: true });\n});\n\n// Remove user interest\napp.delete(\"/api/users/:id/interests/:gardenId\", async c => {\n const userId = c.req.param(\"id\");\n const gardenId = c.req.param(\"gardenId\");\n \n await removeUserInterest(userId, gardenId);\n return c.json({ success: true });\n});\n\n// Create booking\napp.post(\"/api/bookings\", async c => {\n const body = await c.req.json();\n const { userId, propertyId, notes } = body;\n \n if (!userId || !propertyId) {\n return c.json({ error: \"User ID and Property ID are required\" }, 400);\n }\n \n const booking = await createBooking({\n id: generateId(),\n userId,\n propertyId,\n status: 'pending',\n createdAt: new Date().toISOString(),\n notes\n });\n \n return c.json(booking, 201);\n});\n\n// Create payment\napp.post(\"/api/payments\", async c => {\n const body = await c.req.json();\n const { userId, propertyId, amount, paymentMethod } = body;\n \n if (!userId || !propertyId || !amount || !paymentMethod) {\n return c.json({ error: \"All payment fields are required\" }, 400);\n }\n \n const payment = await createPayment({\n id: generateId(),\n userId,\n propertyId,\n amount,\n currency: 'NGN',\n status: 'pending',\n paymentMethod,\n createdAt: new Date().toISOString()\n });\n \n return c.json(payment, 201);\n});\n\n// Update payment status (webhook endpoint)\napp.post(\"/api/payments/:id/status\", async c => {\n const paymentId = c.req.param(\"id\");\n const { status } = await c.req.json();\n \n if (!['pending', 'completed', 'failed'].includes(status)) {\n return c.json({ error: \"Invalid status\" }, 400);\n }\n \n await updatePaymentStatus(paymentId, status);\n return c.json({ success: true });\n});\n\n// Chat endpoints\napp.post(\"/api/chat\", async c => {\n const body = await c.req.json();\n const { message, sessionId } = body;\n \n if (!message || !sessionId) {\n return c.json({ error: \"Message and session ID are required\" }, 400);\n }\n \n // Save user message\n const userMessage = await saveChatMessage({\n message,\n sender: 'user',\n timestamp: sessionId\n });\n \n // Auto-reply for demo (in production, this would integrate with a real chat system)\n const autoReply = \"Thank you for your message! Our support team will get back to you shortly. For immediate assistance, please call us at 08164878281.\";\n \n const supportMessage = await saveChatMessage({\n message: autoReply,\n sender: 'support',\n timestamp: sessionId\n });\n \n return c.json([userMessage, supportMessage]);\n});\n\napp.get(\"/api/chat/:sessionId\", async c => {\n const sessionId = c.req.param(\"sessionId\");\n const messages = await getChatMessages(sessionId);\n return c.json(messages);\n});\n\n// Contact info endpoint\napp.get(\"/api/contact\", c => {\n return c.json(CONTACT_INFO);\n});\n\n// Health check\napp.get(\"/api/health\", c => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\nexport default app;",[],[154,211],"74e24c2a-3f97-11f0-bcad-76b3cceeab13","queries.ts","74e24d6a-3f97-11f0-bcad-76b3cceeab13","f40c1e4f-74be-4df9-b2fe-9577187f3cfe",5,["D",1748858018202],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { User, Property, Payment, Booking, ChatMessage } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (id, name, email, phone) VALUES (?, ?, ?, ?)`,\n [user.id, user.name, user.email, user.phone]\n );\n \n return {\n ...user,\n interests: [],\n payments: [],\n bookings: []\n };\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n const interests = await getUserInterests(id);\n const payments = await getUserPayments(id);\n const bookings = await getUserBookings(id);\n \n return {\n id: user.id,\n name: user.name,\n email: user.email,\n phone: user.phone,\n interests,\n payments,\n bookings\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE email = ?`,\n [email]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n return getUserById(user.id);\n}\n\n// Property queries\nexport async function createProperty(property: Property): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.PROPERTIES} \n (id, garden_id, plot_number, size, price, status, description, coordinates_lat, coordinates_lng) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n property.id,\n property.gardenId,\n property.plotNumber,\n property.size,\n property.price,\n property.status,\n property.description,\n property.coordinates?.lat || null,\n property.coordinates?.lng || null\n ]\n );\n \n return property;\n}\n\nexport async function getPropertiesByGarden(gardenId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PROPERTIES} WHERE garden_id = ? ORDER BY plot_number`,\n [gardenId]\n );\n \n return result.map(row => ({\n id: row.id,\n gardenId: row.garden_id,\n plotNumber: row.plot_number,\n size: row.size,\n price: row.price,\n status: row.status as Property['status'],\n description: row.description,\n coordinates: row.coordinates_lat && row.coordinates_lng ? {\n lat: row.coordinates_lat,\n lng: row.coordinates_lng\n } : undefined\n }));\n}\n\nexport async function getAvailableProperties(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PROPERTIES} WHERE status = 'available' ORDER BY garden_id, plot_number`\n );\n \n return result.map(row => ({\n id: row.id,\n gardenId: row.garden_id,\n plotNumber: row.plot_number,\n size: row.size,\n price: row.price,\n status: row.status as Property['status'],\n description: row.description,\n coordinates: row.coordinates_lat && row.coordinates_lng ? {\n lat: row.coordinates_lat,\n lng: row.coordinates_lng\n } : undefined\n }));\n}\n\n// Payment queries\nexport async function createPayment(payment: Payment): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.PAYMENTS} \n (id, user_id, property_id, amount, currency, status, payment_method, reference) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n payment.id,\n payment.userId,\n payment.propertyId,\n payment.amount,\n payment.currency,\n payment.status,\n payment.paymentMethod,\n payment.id // Using payment ID as reference for now\n ]\n );\n \n return payment;\n}\n\nexport async function updatePaymentStatus(paymentId: string, status: Payment['status']): Promise {\n const completedAt = status === 'completed' ? new Date().toISOString() : null;\n \n await sqlite.execute(\n `UPDATE ${TABLES.PAYMENTS} SET status = ?, completed_at = ? WHERE id = ?`,\n [status, completedAt, paymentId]\n );\n}\n\nexport async function getUserPayments(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PAYMENTS} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n propertyId: row.property_id,\n amount: row.amount,\n currency: row.currency,\n status: row.status as Payment['status'],\n paymentMethod: row.payment_method,\n createdAt: row.created_at,\n completedAt: row.completed_at\n }));\n}\n\n// Booking queries\nexport async function createBooking(booking: Booking): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.BOOKINGS} (id, user_id, property_id, status, notes) \n VALUES (?, ?, ?, ?, ?)`,\n [booking.id, booking.userId, booking.propertyId, booking.status, booking.notes]\n );\n \n return booking;\n}\n\nexport async function getUserBookings(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.BOOKINGS} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n propertyId: row.property_id,\n status: row.status as Booking['status'],\n createdAt: row.created_at,\n notes: row.notes\n }));\n}\n\n// Interest queries\nexport async function addUserInterest(userId: string, gardenId: string): Promise {\n const interestId = Math.random().toString(36).substr(2, 9);\n \n await sqlite.execute(\n `INSERT OR IGNORE INTO ${TABLES.INTERESTS} (id, user_id, garden_id) VALUES (?, ?, ?)`,\n [interestId, userId, gardenId]\n );\n}\n\nexport async function removeUserInterest(userId: string, gardenId: string): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLES.INTERESTS} WHERE user_id = ? AND garden_id = ?`,\n [userId, gardenId]\n );\n}\n\nexport async function getUserInterests(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT garden_id FROM ${TABLES.INTERESTS} WHERE user_id = ?`,\n [userId]\n );\n \n return result.map(row => row.garden_id);\n}\n\n// Chat queries\nexport async function saveChatMessage(message: Omit): Promise {\n const id = Math.random().toString(36).substr(2, 9);\n \n await sqlite.execute(\n `INSERT INTO ${TABLES.CHAT_MESSAGES} (id, session_id, message, sender) VALUES (?, ?, ?, ?)`,\n [id, message.timestamp, message.message, message.sender] // Using timestamp as session_id for simplicity\n );\n \n return { ...message, id };\n}\n\nexport async function getChatMessages(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.CHAT_MESSAGES} WHERE session_id = ? ORDER BY created_at ASC`,\n [sessionId]\n );\n \n return result.map(row => ({\n id: row.id,\n message: row.message,\n sender: row.sender as ChatMessage['sender'],\n timestamp: row.created_at\n }));\n}",[],[154,226,218],"database","644f50f6-3f97-11f0-9634-76b3cceeab13","migrations.ts","644f5344-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database table names with versioning for schema changes\nexport const TABLES = {\n USERS: 'eagle_majdes_users_v1',\n PROPERTIES: 'eagle_majdes_properties_v1',\n PAYMENTS: 'eagle_majdes_payments_v1',\n BOOKINGS: 'eagle_majdes_bookings_v1',\n INTERESTS: 'eagle_majdes_interests_v1',\n CHAT_MESSAGES: 'eagle_majdes_chat_messages_v1'\n};\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.USERS} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n phone TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Properties table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PROPERTIES} (\n id TEXT PRIMARY KEY,\n garden_id TEXT NOT NULL,\n plot_number TEXT NOT NULL,\n size TEXT NOT NULL,\n price INTEGER NOT NULL,\n status TEXT DEFAULT 'available' CHECK (status IN ('available', 'reserved', 'sold')),\n description TEXT,\n coordinates_lat REAL,\n coordinates_lng REAL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Payments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PAYMENTS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n property_id TEXT NOT NULL,\n amount INTEGER NOT NULL,\n currency TEXT DEFAULT 'NGN',\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'completed', 'failed')),\n payment_method TEXT,\n reference TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (property_id) REFERENCES ${TABLES.PROPERTIES}(id)\n )\n `);\n\n // Bookings table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.BOOKINGS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n property_id TEXT NOT NULL,\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'cancelled')),\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (property_id) REFERENCES ${TABLES.PROPERTIES}(id)\n )\n `);\n\n // User interests table (many-to-many relationship)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.INTERESTS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n garden_id TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n UNIQUE(user_id, garden_id)\n )\n `);\n\n // Chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.CHAT_MESSAGES} (\n id TEXT PRIMARY KEY,\n session_id TEXT NOT NULL,\n message TEXT NOT NULL,\n sender TEXT NOT NULL CHECK (sender IN ('user', 'support')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed successfully');\n}",[],[154,226,228],"644f6078-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],[171,172],[154,226],["D",1748857990392],[170,173],[154],["D",1748856998657],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":58,"_104":105,"_106":25},{"_13":89,"_32":90,"_47":41,"_91":48,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":49,"_98":99},"ctx",{"_82":-5,"_127":278,"_279":280,"_281":282,"_283":25,"_284":25,"_285":25,"_286":62,"_287":-5,"_288":-7,"_289":-7,"_290":66,"_291":25,"_292":25,"_293":-5,"_294":25,"_295":25,"_296":25,"_297":-5},"ENV",{"_249":250,"_251":252,"_253":90,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","899124c68db8496248a17ee95f074b807335ea7b","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"]

Diff · v7