[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_312":313,"_314":315},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/HomePage.tsx","latestPath","fileId","e8c20658-3f97-11f0-ab6c-76b3cceeab13","name","HomePage.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Garden } from \"../../shared/types.ts\";\n\ninterface HomePageProps {\n gardens: Garden[];\n featuredGardens: Garden[];\n onNavigate: (page: string, gardenId?: string) => void;\n}\n\nexport default function HomePage({ gardens, featuredGardens, onNavigate }: HomePageProps) {\n const stats = [\n { icon: 'fas fa-seedling', label: 'Gardens', value: gardens.length.toString() },\n { icon: 'fas fa-map-marker-alt', label: 'Locations', value: '4' },\n { icon: 'fas fa-users', label: 'Happy Clients', value: '500+' },\n { icon: 'fas fa-award', label: 'Years Experience', value: '10+' }\n ];\n\n const features = [\n {\n icon: 'fas fa-shield-alt',\n title: 'Secure Investment',\n description: 'All properties come with proper documentation and legal backing'\n },\n {\n icon: 'fas fa-road',\n title: 'Modern Infrastructure',\n description: 'Well-planned estates with good road networks and utilities'\n },\n {\n icon: 'fas fa-handshake',\n title: 'Flexible Payment',\n description: 'Multiple payment options including installmental plans'\n },\n {\n icon: 'fas fa-headset',\n title: '24/7 Support',\n description: 'Dedicated customer support team ready to assist you'\n }\n ];\n\n return (\n

\n {/* Hero Section */}\n

\n Your Dream Home Awaits\n

\n Discover premium real estate opportunities in Nigeria's most sought-after locations. \n Quality estates, modern amenities, and affordable prices.\n

\n onNavigate('gardens')}\n className=\"btn-primary text-lg px-8 py-4\"\n >\n \n Explore Our Gardens\n \n onNavigate('contact')}\n className=\"btn-secondary text-lg px-8 py-4\"\n >\n \n Contact Us\n \n

\n\n {/* Stats Section */}\n

\n {stats.map((stat, index) => (\n

\n \n

{stat.value}

{stat.label}

\n ))}\n

\n\n {/* Featured Gardens */}\n

\n Featured Gardens\n

\n Discover our premium estate developments with modern amenities and excellent locations\n

\n\n

\n {featuredGardens.map((garden) => (\n

\n \n

{garden.name}

\n \n {garden.location}\n

{garden.description}

\n {garden.priceRange}\n \n {garden.availablePlots} plots available\n \n

\n {garden.amenities.slice(0, 3).map((amenity, index) => (\n \n {amenity}\n \n ))}\n {garden.amenities.length > 3 && (\n \n +{garden.amenities.length - 3} more\n \n )}\n

\n onNavigate('garden-detail', garden.id)}\n className=\"w-full btn-primary\"\n >\n \n View Details\n \n

\n ))}\n

\n\n

\n onNavigate('gardens')}\n className=\"btn-secondary text-lg px-8 py-3\"\n >\n \n View All Gardens\n \n

\n\n {/* Features Section */}\n

\n Why Choose Eagle Majdes?\n

\n We provide comprehensive real estate solutions with a focus on quality, affordability, and customer satisfaction\n

\n\n

\n {features.map((feature, index) => (\n

\n \n

{feature.title}

{feature.description}

\n ))}\n

\n\n {/* CTA Section */}\n

\n Ready to Find Your Perfect Property?\n

\n Join hundreds of satisfied customers who have found their dream homes with Eagle Majdes\n

\n onNavigate('properties')}\n className=\"btn-primary text-lg px-8 py-4\"\n >\n \n Browse Properties\n \n onNavigate('dashboard')}\n className=\"btn-secondary text-lg px-8 py-4\"\n >\n \n Get Started\n \n

\n );\n}","createdAt",["D",1748858212606],"branchVersion","branchId","152faf2c-3f95-11f0-b173-76b3cceeab13","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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"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",{"_42":43,"_31":44,"_37":308,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":309,"_79":310,"_81":311,"_83":24},"tree",[168,173,183,186],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186],"counts",{"_158":61,"_159":142,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":157},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":150,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":151},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":143,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":145},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":135,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_26":138},"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",[130],"564c512a-3f97-11f0-9d7b-76b3cceeab13","shared","0b2e8428-772a-40b5-94ae-735ce56fc29e",2,["D",1748857966884],"directory",[140],"8d34ce38-3f97-11f0-b61b-76b3cceeab13","frontend","077505a7-9b72-48b3-a05b-54765d2f1a23",7,["D",1748858059004],[147],"644f5e98-3f97-11f0-9634-76b3cceeab13","backend","4eb8dc60-c7e4-46b4-b604-701b790434da",4,["D",1748857990392],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":305,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":306,"_26":307},{"_42":301,"_31":293,"_29":287,"_132":154,"_40":41,"_39":155,"_134":57,"_37":302,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":303,"_26":304},{"_42":294,"_31":295,"_29":296,"_132":287,"_40":41,"_39":155,"_134":57,"_37":297,"_13":61,"_33":34,"_35":298,"_23":24,"_137":-5,"_188":299,"_26":300},{"_42":284,"_31":285,"_29":286,"_132":287,"_40":41,"_39":288,"_134":57,"_37":289,"_13":61,"_33":34,"_35":290,"_23":24,"_137":-5,"_188":291,"_26":292},{"_42":277,"_31":278,"_29":55,"_132":154,"_40":41,"_39":279,"_134":24,"_37":280,"_13":61,"_33":34,"_35":281,"_23":24,"_137":-5,"_188":282,"_26":283},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":274,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":275,"_26":276},{"_42":270,"_31":245,"_29":241,"_132":148,"_40":41,"_39":265,"_134":57,"_37":271,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":272,"_26":273},{"_42":262,"_31":263,"_29":264,"_132":241,"_40":41,"_39":265,"_134":57,"_37":266,"_13":61,"_33":34,"_35":267,"_23":24,"_137":-5,"_188":268,"_26":269},{"_42":254,"_31":255,"_29":256,"_132":241,"_40":41,"_39":257,"_134":57,"_37":258,"_13":61,"_33":34,"_35":259,"_23":24,"_137":-5,"_188":260,"_26":261},{"_42":246,"_31":247,"_29":248,"_132":241,"_40":41,"_39":249,"_134":57,"_37":250,"_13":61,"_33":34,"_35":251,"_23":24,"_137":-5,"_188":252,"_26":253},{"_42":240,"_31":32,"_29":30,"_132":241,"_40":41,"_39":14,"_134":57,"_37":242,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_188":243,"_26":244},{"_42":232,"_31":233,"_29":234,"_132":148,"_40":41,"_39":235,"_134":57,"_37":236,"_13":61,"_33":20,"_35":237,"_23":24,"_137":-5,"_188":238,"_26":239},{"_42":225,"_31":226,"_29":227,"_132":148,"_40":41,"_39":149,"_134":57,"_37":228,"_13":61,"_33":20,"_35":229,"_23":24,"_137":-5,"_188":230,"_26":231},{"_42":217,"_31":218,"_29":219,"_132":148,"_40":41,"_39":220,"_134":57,"_37":221,"_13":61,"_33":34,"_35":222,"_23":24,"_137":-5,"_188":223,"_26":224},{"_42":209,"_31":210,"_29":211,"_132":148,"_40":41,"_39":212,"_134":57,"_37":213,"_13":61,"_33":20,"_35":214,"_23":24,"_137":-5,"_188":215,"_26":216},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":206,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":207,"_26":208},{"_42":199,"_31":200,"_29":201,"_132":141,"_40":41,"_39":142,"_134":57,"_37":202,"_13":61,"_33":34,"_35":203,"_23":24,"_137":-5,"_188":204,"_26":205},{"_42":191,"_31":192,"_29":193,"_132":141,"_40":41,"_39":194,"_134":57,"_37":195,"_13":61,"_33":34,"_35":196,"_23":24,"_137":-5,"_188":197,"_26":198},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":187,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_188":189,"_26":190},["D",1748857944556],"children",[],[130],"5be10aae-3f97-11f0-a968-76b3cceeab13","utils.ts","5be10b44-3f97-11f0-a968-76b3cceeab13",3,["D",1748857976252],"// 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}",[],[140,192],"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];",[],[140,200],["D",1748857966884],[184,185],[140],"a747c8ac-3f97-11f0-9c1d-76b3cceeab13","style.css","a747c9b0-3f97-11f0-9c1d-76b3cceeab13",9,["D",1748858102752],"/* Custom styles for Eagle Majdes website */\n\n:root {\n --primary-yellow: #F59E0B;\n --primary-teal: #0D9488;\n --dark-gray: #1F2937;\n --light-gray: #F9FAFB;\n}\n\n/* Smooth scrolling */\nhtml {\n scroll-behavior: smooth;\n}\n\n/* Custom scrollbar */\n::-webkit-scrollbar {\n width: 8px;\n}\n\n::-webkit-scrollbar-track {\n background: #f1f1f1;\n}\n\n::-webkit-scrollbar-thumb {\n background: var(--primary-teal);\n border-radius: 4px;\n}\n\n::-webkit-scrollbar-thumb:hover {\n background: #0F766E;\n}\n\n/* Logo styling */\n.logo-container {\n display: flex;\n align-items: center;\n gap: 12px;\n}\n\n.logo-icon {\n width: 40px;\n height: 40px;\n background: linear-gradient(135deg, var(--primary-yellow) 0%, var(--primary-teal) 100%);\n border-radius: 8px;\n display: flex;\n align-items: center;\n justify-content: center;\n position: relative;\n}\n\n.logo-icon::before {\n content: '';\n position: absolute;\n width: 0;\n height: 0;\n border-left: 8px solid transparent;\n border-right: 8px solid transparent;\n border-bottom: 14px solid white;\n top: 6px;\n left: 6px;\n}\n\n.logo-icon::after {\n content: '';\n position: absolute;\n width: 8px;\n height: 14px;\n background: white;\n top: 6px;\n right: 6px;\n}\n\n/* Hero section gradient */\n.hero-gradient {\n background: linear-gradient(135deg, var(--primary-yellow) 0%, var(--primary-teal) 100%);\n}\n\n/* Card hover effects */\n.card-hover {\n transition: all 0.3s ease;\n}\n\n.card-hover:hover {\n transform: translateY(-4px);\n box-shadow: 0 20px 25px -5px rgba(0, 0, 0, 0.1), 0 10px 10px -5px rgba(0, 0, 0, 0.04);\n}\n\n/* Button styles */\n.btn-primary {\n background: linear-gradient(135deg, var(--primary-yellow) 0%, var(--primary-teal) 100%);\n color: white;\n border: none;\n padding: 12px 24px;\n border-radius: 8px;\n font-weight: 600;\n transition: all 0.3s ease;\n cursor: pointer;\n}\n\n.btn-primary:hover {\n transform: translateY(-2px);\n box-shadow: 0 10px 15px -3px rgba(0, 0, 0, 0.1);\n}\n\n.btn-secondary {\n background: white;\n color: var(--primary-teal);\n border: 2px solid var(--primary-teal);\n padding: 10px 22px;\n border-radius: 8px;\n font-weight: 600;\n transition: all 0.3s ease;\n cursor: pointer;\n}\n\n.btn-secondary:hover {\n background: var(--primary-teal);\n color: white;\n}\n\n/* Navigation styles */\n.nav-link {\n position: relative;\n color: var(--dark-gray);\n text-decoration: none;\n font-weight: 500;\n transition: color 0.3s ease;\n}\n\n.nav-link:hover {\n color: var(--primary-teal);\n}\n\n.nav-link.active::after {\n content: '';\n position: absolute;\n bottom: -4px;\n left: 0;\n width: 100%;\n height: 2px;\n background: var(--primary-teal);\n}\n\n/* Garden card styles */\n.garden-card {\n background: white;\n border-radius: 12px;\n overflow: hidden;\n box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.1);\n transition: all 0.3s ease;\n}\n\n.garden-card:hover {\n transform: translateY(-4px);\n box-shadow: 0 20px 25px -5px rgba(0, 0, 0, 0.1);\n}\n\n.garden-card-image {\n width: 100%;\n height: 200px;\n background: linear-gradient(135deg, #E5F3F2 0%, #F0F9FF 100%);\n display: flex;\n align-items: center;\n justify-content: center;\n font-size: 48px;\n color: var(--primary-teal);\n}\n\n/* Status badges */\n.status-badge {\n padding: 4px 12px;\n border-radius: 20px;\n font-size: 12px;\n font-weight: 600;\n text-transform: uppercase;\n}\n\n.status-available {\n background: #D1FAE5;\n color: #065F46;\n}\n\n.status-reserved {\n background: #FEF3C7;\n color: #92400E;\n}\n\n.status-sold {\n background: #FEE2E2;\n color: #991B1B;\n}\n\n/* Chat widget */\n.chat-widget {\n position: fixed;\n bottom: 20px;\n right: 20px;\n z-index: 1000;\n}\n\n.chat-button {\n width: 60px;\n height: 60px;\n border-radius: 50%;\n background: linear-gradient(135deg, var(--primary-yellow) 0%, var(--primary-teal) 100%);\n color: white;\n border: none;\n font-size: 24px;\n cursor: pointer;\n box-shadow: 0 4px 12px rgba(0, 0, 0, 0.15);\n transition: all 0.3s ease;\n}\n\n.chat-button:hover {\n transform: scale(1.1);\n}\n\n.chat-panel {\n position: absolute;\n bottom: 70px;\n right: 0;\n width: 350px;\n height: 400px;\n background: white;\n border-radius: 12px;\n box-shadow: 0 20px 25px -5px rgba(0, 0, 0, 0.1);\n display: flex;\n flex-direction: column;\n overflow: hidden;\n}\n\n.chat-header {\n background: linear-gradient(135deg, var(--primary-yellow) 0%, var(--primary-teal) 100%);\n color: white;\n padding: 16px;\n font-weight: 600;\n}\n\n.chat-messages {\n flex: 1;\n padding: 16px;\n overflow-y: auto;\n display: flex;\n flex-direction: column;\n gap: 12px;\n}\n\n.chat-message {\n max-width: 80%;\n padding: 8px 12px;\n border-radius: 12px;\n font-size: 14px;\n}\n\n.chat-message.user {\n background: var(--primary-teal);\n color: white;\n align-self: flex-end;\n border-bottom-right-radius: 4px;\n}\n\n.chat-message.support {\n background: #F3F4F6;\n color: var(--dark-gray);\n align-self: flex-start;\n border-bottom-left-radius: 4px;\n}\n\n.chat-input {\n padding: 16px;\n border-top: 1px solid #E5E7EB;\n display: flex;\n gap: 8px;\n}\n\n.chat-input input {\n flex: 1;\n padding: 8px 12px;\n border: 1px solid #D1D5DB;\n border-radius: 20px;\n outline: none;\n}\n\n.chat-input input:focus {\n border-color: var(--primary-teal);\n}\n\n.chat-input button {\n padding: 8px 16px;\n background: var(--primary-teal);\n color: white;\n border: none;\n border-radius: 20px;\n cursor: pointer;\n}\n\n/* Responsive design */\n@media (max-width: 768px) {\n .chat-panel {\n width: 300px;\n height: 350px;\n }\n \n .logo-container {\n gap: 8px;\n }\n \n .logo-icon {\n width: 32px;\n height: 32px;\n }\n}\n\n/* Loading spinner */\n.spinner {\n border: 2px solid #f3f3f3;\n border-top: 2px solid var(--primary-teal);\n border-radius: 50%;\n width: 20px;\n height: 20px;\n animation: spin 1s linear infinite;\n}\n\n@keyframes spin {\n 0% { transform: rotate(0deg); }\n 100% { transform: rotate(360deg); }\n}\n\n/* Form styles */\n.form-input {\n width: 100%;\n padding: 12px 16px;\n border: 1px solid #D1D5DB;\n border-radius: 8px;\n outline: none;\n transition: border-color 0.3s ease;\n}\n\n.form-input:focus {\n border-color: var(--primary-teal);\n box-shadow: 0 0 0 3px rgba(13, 148, 136, 0.1);\n}\n\n.form-label {\n display: block;\n margin-bottom: 6px;\n font-weight: 500;\n color: var(--dark-gray);\n}\n\n/* Modal styles */\n.modal-overlay {\n position: fixed;\n top: 0;\n left: 0;\n right: 0;\n bottom: 0;\n background: rgba(0, 0, 0, 0.5);\n display: flex;\n align-items: center;\n justify-content: center;\n z-index: 1000;\n}\n\n.modal-content {\n background: white;\n border-radius: 12px;\n padding: 24px;\n max-width: 500px;\n width: 90%;\n max-height: 90vh;\n overflow-y: auto;\n}\n\n/* Animations */\n.fade-in {\n animation: fadeIn 0.3s ease-in;\n}\n\n@keyframes fadeIn {\n from { opacity: 0; transform: translateY(20px); }\n to { opacity: 1; transform: translateY(0); }\n}\n\n.slide-up {\n animation: slideUp 0.3s ease-out;\n}\n\n@keyframes slideUp {\n from { transform: translateY(100%); }\n to { transform: translateY(0); }\n}",[],[147,210],"ab01503a-3f97-11f0-9a86-76b3cceeab13","index.tsx","ab015102-3f97-11f0-9a86-76b3cceeab13",10,["D",1748858109003],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\n// Get initial data injected from server\nconst initialData = (window as any).__INITIAL_DATA__ || {\n gardens: [],\n contact: {},\n featuredGardens: []\n};\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[147,218],"8d34c35c-3f97-11f0-b61b-76b3cceeab13","index.html","8d34c42e-3f97-11f0-b61b-76b3cceeab13",["D",1748858059004],"\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",[],[147,226],"9146b482-3f97-11f0-bfb2-76b3cceeab13","favicon.svg","9146b54a-3f97-11f0-bfb2-76b3cceeab13",8,["D",1748858065834],"",[],[147,233],"e8c205a4-3f97-11f0-ab6c-76b3cceeab13","61cdcfc6-c5e5-4944-959d-b39f19d6b833",["D",1748858212606],[],[147,245,32],"components","c23c42b4-3f97-11f0-af85-76b3cceeab13","Header.tsx","c23c439a-3f97-11f0-af85-76b3cceeab13",12,["D",1748858147976],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { User } from \"../../shared/types.ts\";\n\ninterface HeaderProps {\n currentPage: string;\n onNavigate: (page: any) => void;\n user: User | null;\n}\n\nexport default function Header({ currentPage, onNavigate, user }: HeaderProps) {\n const [isMobileMenuOpen, setIsMobileMenuOpen] = useState(false);\n\n const navItems = [\n { id: 'home', label: 'Home', icon: 'fas fa-home' },\n { id: 'about', label: 'About', icon: 'fas fa-info-circle' },\n { id: 'gardens', label: 'Gardens', icon: 'fas fa-seedling' },\n { id: 'properties', label: 'Properties', icon: 'fas fa-building' },\n { id: 'contact', label: 'Contact', icon: 'fas fa-phone' }\n ];\n\n return (\n

\n {/* Logo */}\n

onNavigate('home')}>\n

\n {/* Logo will be styled with CSS */}\n

Eagle Majdes

Homes & Services

\n\n {/* Desktop Navigation */}\n

\n {navItems.map((item) => (\n onNavigate(item.id)}\n className={`nav-link flex items-center space-x-2 px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n currentPage === item.id\n ? 'text-teal-600 bg-teal-50'\n : 'text-gray-700 hover:text-teal-600 hover:bg-gray-50'\n }`}\n >\n \n {item.label}\n \n ))}\n

\n\n {/* User Actions */}\n

\n {user ? (\n

\n {user.name.charAt(0).toUpperCase()}\n

\n onNavigate('dashboard')}\n className=\"btn-secondary text-sm\"\n >\n \n Dashboard\n \n

\n ) : (\n onNavigate('dashboard')}\n className=\"btn-primary text-sm\"\n >\n \n Login\n \n )}\n

\n\n {/* Mobile menu button */}\n

\n setIsMobileMenuOpen(!isMobileMenuOpen)}\n className=\"text-gray-700 hover:text-teal-600 focus:outline-none\"\n >\n \n \n

\n\n {/* Mobile Navigation */}\n {isMobileMenuOpen && (\n

\n {navItems.map((item) => (\n {\n onNavigate(item.id);\n setIsMobileMenuOpen(false);\n }}\n className={`nav-link flex items-center space-x-3 px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n currentPage === item.id\n ? 'text-teal-600 bg-teal-50'\n : 'text-gray-700 hover:text-teal-600 hover:bg-gray-50'\n }`}\n >\n \n {item.label}\n \n ))}\n \n {/* Mobile user actions */}\n

\n {user ? (\n {\n onNavigate('dashboard');\n setIsMobileMenuOpen(false);\n }}\n className=\"flex items-center space-x-3 px-3 py-2 text-sm font-medium text-gray-700 hover:text-teal-600\"\n >\n

\n {user.name.charAt(0).toUpperCase()}\n

\n Dashboard\n \n ) : (\n {\n onNavigate('dashboard');\n setIsMobileMenuOpen(false);\n }}\n className=\"flex items-center space-x-3 px-3 py-2 text-sm font-medium text-teal-600\"\n >\n \n Login\n \n )}\n

\n )}\n

\n );\n}",[],[147,245,247],"d1dd59c4-3f97-11f0-abb5-76b3cceeab13","Footer.tsx","d1dd5a82-3f97-11f0-abb5-76b3cceeab13",13,["D",1748858174196],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { ContactInfo } from \"../../shared/types.ts\";\n\ninterface FooterProps {\n contact: ContactInfo;\n}\n\nexport default function Footer({ contact }: FooterProps) {\n const currentYear = new Date().getFullYear();\n\n return (\n \n );\n}",[],[147,245,255],"b40bd056-3f97-11f0-b092-76b3cceeab13","App.tsx","b40bd13c-3f97-11f0-b092-76b3cceeab13",11,["D",1748858124166],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport Header from \"./Header.tsx\";\nimport Footer from \"./Footer.tsx\";\nimport HomePage from \"./HomePage.tsx\";\nimport AboutPage from \"./AboutPage.tsx\";\nimport GardensPage from \"./GardensPage.tsx\";\nimport GardenDetailPage from \"./GardenDetailPage.tsx\";\nimport PropertiesPage from \"./PropertiesPage.tsx\";\nimport DashboardPage from \"./DashboardPage.tsx\";\nimport PaymentPage from \"./PaymentPage.tsx\";\nimport ContactPage from \"./ContactPage.tsx\";\nimport ChatWidget from \"./ChatWidget.tsx\";\nimport type { Garden, ContactInfo, User } from \"../../shared/types.ts\";\n\ninterface AppProps {\n initialData: {\n gardens: Garden[];\n contact: ContactInfo;\n featuredGardens: Garden[];\n };\n}\n\ntype Page = 'home' | 'about' | 'gardens' | 'garden-detail' | 'properties' | 'dashboard' | 'payment' | 'contact';\n\nexport default function App({ initialData }: AppProps) {\n const [currentPage, setCurrentPage] = useState('home');\n const [selectedGarden, setSelectedGarden] = useState(null);\n const [user, setUser] = useState(null);\n const [gardens] = useState(initialData.gardens);\n\n // Simple routing based on hash\n useEffect(() => {\n const handleHashChange = () => {\n const hash = window.location.hash.slice(1);\n if (hash.startsWith('garden/')) {\n const gardenId = hash.split('/')[1];\n const garden = gardens.find(g => g.id === gardenId);\n if (garden) {\n setSelectedGarden(garden);\n setCurrentPage('garden-detail');\n }\n } else if (['home', 'about', 'gardens', 'properties', 'dashboard', 'payment', 'contact'].includes(hash)) {\n setCurrentPage(hash as Page);\n } else {\n setCurrentPage('home');\n }\n };\n\n handleHashChange();\n window.addEventListener('hashchange', handleHashChange);\n return () => window.removeEventListener('hashchange', handleHashChange);\n }, [gardens]);\n\n const navigateTo = (page: Page, gardenId?: string) => {\n if (page === 'garden-detail' && gardenId) {\n window.location.hash = `garden/${gardenId}`;\n } else {\n window.location.hash = page;\n }\n };\n\n const renderPage = () => {\n switch (currentPage) {\n case 'home':\n return ;\n case 'about':\n return ;\n case 'gardens':\n return ;\n case 'garden-detail':\n return selectedGarden ? : ;\n case 'properties':\n return ;\n case 'dashboard':\n return ;\n case 'payment':\n return ;\n case 'contact':\n return ;\n default:\n return ;\n }\n };\n\n return (\n

\n {renderPage()}\n

\n );\n}",[],[147,245,263],"b40be0f0-3f97-11f0-b092-76b3cceeab13",["D",1748858124166],[175,176,177,178],[147,245],["D",1748858059004],[174,179,180,181,182],[147],"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;",[],[153,278],"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}",[],[153,293,285],"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}",[],[153,293,295],"644f6078-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],[170,171],[153,293],["D",1748857990392],[169,172],[153],["D",1748856998657],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":345,"_346":347,"_348":349,"_350":24,"_351":24,"_352":24,"_353":57,"_354":-5,"_355":-7,"_356":-7,"_357":61,"_358":24,"_359":24,"_360":-5,"_361":24,"_362":24,"_363":24,"_364":-5},"ENV",{"_316":317,"_318":319,"_320":85,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344},"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 · v14