Enugu Rents - Find Your Perfect Home in Enugu

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_281":282,"_283":284},"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":62,"_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",12,"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","9399573a-3df3-11f0-a56c-76b3cceeab13","name","index.html","fileType","content","\n\n\n \n \n Enugu Rents - Find Your Perfect Home in Enugu\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 \n \n \n \n \n \n \n \n\n\n \n

Loading Enugu Rents...

\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",1748677681103],"branchVersion","branchId","26269cf4-3df2-11f0-bc6a-76b3cceeab13",{"_30":44,"_32":43,"_34":45,"_35":-5,"_37":46,"_39":14,"_40":41,"_24":25},"frontend","7c4acf6a-2bf9-4e22-90e9-a0a9b6a21dc2","directory",["D",1748677681103],"id","262621b6-3df2-11f0-bc6a-76b3cceeab13","EnuguRent",["D",1748677067986],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","79b7b0aa-3df3-11f0-9a07-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",21,"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":277,"_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":278,"_84":279,"_86":280,"_88":25},"tree",[169,178,180,183],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182,183],"counts",{"_159":66,"_160":138,"_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":62,"_37":140,"_13":66,"_34":21,"_35":141,"_24":25,"_142":-5,"_27":143},"368edb24-3df2-11f0-881b-76b3cceeab13","README.md","368edbec-3df2-11f0-881b-76b3cceeab13","parentId",1,"latest",["D",1748677095510],"# 🏠 Enugu Rents - Real Estate Web Application\n\nA professional, sleek, and interactive real estate web application for browsing and listing rental properties in Enugu, Nigeria.\n\n## 🚀 Features\n\n- **User Registration & Authentication**: Secure account system for property listing\n- **Property Listings**: Comprehensive rental listings with detailed information\n- **Advanced Search & Filters**: Location, price range, and feature-based filtering\n- **Property Details**: High-quality image galleries and detailed property information\n- **Live Chat System**: Connect renters with listing agents\n- **Mobile Responsive**: Optimized for all devices\n- **Modern UI/UX**: Clean, intuitive interface with smooth animations\n\n## 📁 Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── auth.ts # Authentication routes\n│ │ ├── listings.ts # Property listing routes\n│ │ ├── users.ts # User management routes\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── Header.tsx # Navigation header\n│ │ ├── Footer.tsx # Site footer\n│ │ ├── PropertyCard.tsx # Property listing card\n│ │ ├── PropertyDetail.tsx # Property detail view\n│ │ ├── SearchFilters.tsx # Search and filter component\n│ │ ├── ChatWidget.tsx # Live chat component\n│ │ └── Auth/ # Authentication components\n│ ├── pages/\n│ │ ├── Home.tsx # Homepage\n│ │ ├── Browse.tsx # Browse listings\n│ │ ├── About.tsx # About page\n│ │ ├── Contact.tsx # Contact page\n│ │ ├── FAQ.tsx # FAQ page\n│ │ └── Dashboard.tsx # User dashboard\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n└── shared/\n ├── types.ts # Shared TypeScript types\n └── utils.ts # Shared utility functions\n```\n\n## 🎨 Design System\n\n- **Colors**: Green (#22C55E), Navy Blue (#1E40AF), Slate (#64748B), White (#FFFFFF)\n- **Typography**: Modern, clean fonts optimized for readability\n- **Icons**: Intuitive property feature icons with tooltips\n- **Responsive**: Mobile-first design approach\n\n## 🏘️ Enugu Locations\n\nThe app includes real areas and estates in Enugu:\n- New Haven\n- GRA (Government Reserved Area)\n- Independence Layout\n- Trans-Ekulu\n- Abakpa\n- Uwani\n- Achara Layout\n\n## 🛠️ Technology Stack\n\n- **Frontend**: React 18.2.0 with TypeScript\n- **Backend**: Hono framework\n- **Database**: SQLite\n- **Styling**: TailwindCSS\n- **Icons**: Lucide React icons\n\n## 🚀 Getting Started\n\nThe application is deployed on Val Town. Access the main entry point through the HTTP trigger on `backend/index.ts`.\n\n## 📱 Key Features\n\n### Property Listings Include:\n- Price in Nigerian Naira (₦)\n- Location within Enugu\n- Agent Fee, Legal Fee, Maintenance Fee\n- Full property description\n- Number of bedrooms and bathrooms\n- Kitchen, parking, security details\n- Power supply and furnishing status\n\n### User Experience:\n- Smooth page transitions\n- Hover effects and animations\n- Mobile-responsive design\n- Live chat with property agents\n- Advanced search and filtering\n- Property image galleries\n\n## 🔐 Security\n\n- Secure user authentication\n- Form validation and sanitization\n- Protected routes for user dashboards\n- Environment variable management for sensitive data","label",[135],"3f7fd9cc-3df2-11f0-bac8-76b3cceeab13","shared","880f3960-bddb-46d6-b3fe-96f3354094b6",2,["D",1748677110511],[145],"93996c0c-3df3-11f0-a56c-76b3cceeab13",["D",1748677681103],[43],"6c6a5070-3df2-11f0-a26b-76b3cceeab13","backend","3c52c2ce-281f-4c49-83f8-b9d2695a823c",4,["D",1748677185868],[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":274,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_185":275,"_27":276},{"_47":270,"_32":262,"_30":256,"_137":155,"_40":41,"_39":156,"_139":62,"_37":271,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_185":272,"_27":273},{"_47":263,"_32":264,"_30":265,"_137":256,"_40":41,"_39":156,"_139":62,"_37":266,"_13":66,"_34":193,"_35":267,"_24":25,"_142":-5,"_185":268,"_27":269},{"_47":253,"_32":254,"_30":255,"_137":256,"_40":41,"_39":257,"_139":62,"_37":258,"_13":138,"_34":193,"_35":259,"_24":25,"_142":-5,"_185":260,"_27":261},{"_47":249,"_32":232,"_30":226,"_137":155,"_40":41,"_39":244,"_139":62,"_37":250,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_185":251,"_27":252},{"_47":241,"_32":242,"_30":243,"_137":226,"_40":41,"_39":244,"_139":62,"_37":245,"_13":66,"_34":193,"_35":246,"_24":25,"_142":-5,"_185":247,"_27":248},{"_47":233,"_32":234,"_30":235,"_137":226,"_40":41,"_39":236,"_139":62,"_37":237,"_13":66,"_34":193,"_35":238,"_24":25,"_142":-5,"_185":239,"_27":240},{"_47":223,"_32":224,"_30":225,"_137":226,"_40":41,"_39":227,"_139":62,"_37":228,"_13":66,"_34":193,"_35":229,"_24":25,"_142":-5,"_185":230,"_27":231},{"_47":214,"_32":215,"_30":60,"_137":155,"_40":41,"_39":216,"_139":25,"_37":217,"_13":138,"_34":218,"_35":219,"_24":25,"_142":220,"_185":221,"_27":222},{"_47":150,"_32":43,"_30":44,"_137":-5,"_40":41,"_39":14,"_139":62,"_37":211,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_185":212,"_27":213},{"_47":207,"_32":33,"_30":31,"_137":44,"_40":41,"_39":14,"_139":62,"_37":208,"_13":66,"_34":21,"_35":36,"_24":25,"_142":-5,"_185":209,"_27":210},{"_47":144,"_32":145,"_30":146,"_137":-5,"_40":41,"_39":147,"_139":62,"_37":204,"_13":66,"_34":45,"_35":-5,"_24":25,"_142":-5,"_185":205,"_27":206},{"_47":197,"_32":198,"_30":199,"_137":146,"_40":41,"_39":147,"_139":62,"_37":200,"_13":66,"_34":193,"_35":201,"_24":25,"_142":-5,"_185":202,"_27":203},{"_47":188,"_32":189,"_30":190,"_137":146,"_40":41,"_39":191,"_139":62,"_37":192,"_13":66,"_34":193,"_35":194,"_24":25,"_142":-5,"_185":195,"_27":196},{"_47":134,"_32":135,"_30":136,"_137":-5,"_40":41,"_39":138,"_139":62,"_37":184,"_13":66,"_34":21,"_35":141,"_24":25,"_142":-5,"_185":186,"_27":187},["D",1748677095510],"children",[],[135],"4f0bfd4e-3df2-11f0-83fb-76b3cceeab13","utils.ts","4f0bfe20-3df2-11f0-83fb-76b3cceeab13",3,["D",1748677136599],"script","// Shared utility functions for Enugu Rents\n\nimport type { EnuguLocation, PowerSupplyType, FurnishingType } from './types.ts';\n\n// Format currency in Nigerian Naira\nexport function formatNaira(amount: number): string {\n return new Intl.NumberFormat('en-NG', {\n style: 'currency',\n currency: 'NGN',\n minimumFractionDigits: 0,\n maximumFractionDigits: 0,\n }).format(amount);\n}\n\n// Format phone number for Nigerian format\nexport function formatPhoneNumber(phone: string): string {\n // Remove all non-digits\n const cleaned = phone.replace(/\\D/g, '');\n \n // Handle Nigerian phone numbers\n if (cleaned.startsWith('234')) {\n return `+${cleaned}`;\n } else if (cleaned.startsWith('0')) {\n return `+234${cleaned.slice(1)}`;\n } else if (cleaned.length === 10) {\n return `+234${cleaned}`;\n }\n \n return phone;\n}\n\n// Validate email format\nexport function isValidEmail(email: string): boolean {\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return emailRegex.test(email);\n}\n\n// Validate Nigerian phone number\nexport function isValidNigerianPhone(phone: string): boolean {\n const cleaned = phone.replace(/\\D/g, '');\n \n // Check for valid Nigerian phone patterns\n if (cleaned.startsWith('234') && cleaned.length === 13) return true;\n if (cleaned.startsWith('0') && cleaned.length === 11) return true;\n if (cleaned.length === 10) return true;\n \n return false;\n}\n\n// Generate slug from title\nexport function generateSlug(title: string): string {\n return title\n .toLowerCase()\n .replace(/[^a-z0-9\\s-]/g, '')\n .replace(/\\s+/g, '-')\n .replace(/-+/g, '-')\n .trim();\n}\n\n// Calculate total move-in cost\nexport function calculateTotalCost(\n rent: number,\n agentFee: number,\n legalFee: number,\n maintenanceFee: number\n): number {\n return rent + agentFee + legalFee + maintenanceFee;\n}\n\n// Get location display name with emoji\nexport function getLocationDisplay(location: EnuguLocation): string {\n const locationEmojis: Record = {\n \"New Haven\": \"🏙️ New Haven\",\n \"GRA\": \"🏛️ GRA\",\n \"Independence Layout\": \"🏘️ Independence Layout\",\n \"Trans-Ekulu\": \"🌆 Trans-Ekulu\",\n \"Abakpa\": \"🏡 Abakpa\",\n \"Uwani\": \"🏠 Uwani\",\n \"Achara Layout\": \"🏘️ Achara Layout\",\n \"Coal Camp\": \"⛏️ Coal Camp\",\n \"Ogbete\": \"🏪 Ogbete\",\n \"Emene\": \"🌳 Emene\",\n \"Asata\": \"🏞️ Asata\",\n \"Maryland\": \"🏢 Maryland\"\n };\n \n return locationEmojis[location] || location;\n}\n\n// Get power supply icon\nexport function getPowerSupplyIcon(powerSupply: PowerSupplyType): string {\n const icons: Record = {\n \"24/7 Power\": \"⚡\",\n \"Generator Backup\": \"🔌\",\n \"Solar Power\": \"☀️\",\n \"PHCN Only\": \"🏭\",\n \"Hybrid\": \"🔋\"\n };\n \n return icons[powerSupply] || \"⚡\";\n}\n\n// Get furnishing icon\nexport function getFurnishingIcon(furnishing: FurnishingType): string {\n const icons: Record = {\n \"Fully Furnished\": \"🛋️\",\n \"Semi Furnished\": \"🪑\",\n \"Unfurnished\": \"📦\"\n };\n \n return icons[furnishing] || \"📦\";\n}\n\n// Truncate text with ellipsis\nexport function truncateText(text: string, maxLength: number): string {\n if (text.length <= maxLength) return text;\n return text.slice(0, maxLength).trim() + '...';\n}\n\n// Format date for display\nexport function formatDate(dateString: string): string {\n const date = new Date(dateString);\n return date.toLocaleDateString('en-NG', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n}\n\n// Format relative time (e.g., \"2 days ago\")\nexport function formatRelativeTime(dateString: string): string {\n const date = new Date(dateString);\n const now = new Date();\n const diffInMs = now.getTime() - date.getTime();\n const diffInDays = Math.floor(diffInMs / (1000 * 60 * 60 * 24));\n \n if (diffInDays === 0) return 'Today';\n if (diffInDays === 1) return 'Yesterday';\n if (diffInDays < 7) return `${diffInDays} days ago`;\n if (diffInDays < 30) return `${Math.floor(diffInDays / 7)} weeks ago`;\n if (diffInDays < 365) return `${Math.floor(diffInDays / 30)} months ago`;\n \n return `${Math.floor(diffInDays / 365)} years ago`;\n}\n\n// Debounce function for search\nexport function debounce any>(\n func: T,\n wait: number\n): (...args: Parameters) => void {\n let timeout: number | undefined;\n \n return (...args: Parameters) => {\n clearTimeout(timeout);\n timeout = setTimeout(() => func(...args), wait);\n };\n}\n\n// Generate WhatsApp chat URL\nexport function generateWhatsAppURL(phone: string, message: string): string {\n const formattedPhone = formatPhoneNumber(phone).replace('+', '');\n const encodedMessage = encodeURIComponent(message);\n return `https://wa.me/${formattedPhone}?text=${encodedMessage}`;\n}\n\n// Validate password strength\nexport function validatePassword(password: string): {\n isValid: boolean;\n errors: string[];\n} {\n const errors: string[] = [];\n \n if (password.length < 8) {\n errors.push('Password must be at least 8 characters long');\n }\n \n if (!/[A-Z]/.test(password)) {\n errors.push('Password must contain at least one uppercase letter');\n }\n \n if (!/[a-z]/.test(password)) {\n errors.push('Password must contain at least one lowercase letter');\n }\n \n if (!/\\d/.test(password)) {\n errors.push('Password must contain at least one number');\n }\n \n return {\n isValid: errors.length === 0,\n errors\n };\n}\n\n// Generate random property images (placeholder)\nexport function generatePlaceholderImages(count: number = 3): string[] {\n const images: string[] = [];\n for (let i = 1; i <= count; i++) {\n images.push(`https://picsum.photos/800/600?random=${Math.random()}`);\n }\n return images;\n}",[],[145,189],"3f7fcca2-3df2-11f0-bac8-76b3cceeab13","types.ts","3f7fcd74-3df2-11f0-bac8-76b3cceeab13",["D",1748677110511],"// Shared TypeScript types for Enugu Rents\n\nexport interface User {\n id: number;\n email: string;\n name: string;\n phone?: string;\n created_at: string;\n is_verified: boolean;\n}\n\nexport interface PropertyListing {\n id: number;\n title: string;\n description: string;\n price: number; // Monthly rent in Naira\n location: EnuguLocation;\n agent_fee: number;\n legal_fee: number;\n maintenance_fee: number;\n bedrooms: number;\n bathrooms: number;\n has_kitchen: boolean;\n has_parking: boolean;\n has_security: boolean;\n power_supply: PowerSupplyType;\n furnishing: FurnishingType;\n images: string[]; // Array of image URLs\n agent_id: number;\n agent_name: string;\n agent_phone: string;\n agent_email: string;\n created_at: string;\n updated_at: string;\n is_active: boolean;\n is_featured: boolean;\n}\n\nexport type EnuguLocation = \n | \"New Haven\"\n | \"GRA\"\n | \"Independence Layout\"\n | \"Trans-Ekulu\"\n | \"Abakpa\"\n | \"Uwani\"\n | \"Achara Layout\"\n | \"Coal Camp\"\n | \"Ogbete\"\n | \"Emene\"\n | \"Asata\"\n | \"Maryland\";\n\nexport type PowerSupplyType = \n | \"24/7 Power\"\n | \"Generator Backup\"\n | \"Solar Power\"\n | \"PHCN Only\"\n | \"Hybrid\";\n\nexport type FurnishingType = \n | \"Fully Furnished\"\n | \"Semi Furnished\"\n | \"Unfurnished\";\n\nexport interface PropertyFeatures {\n bedrooms: number;\n bathrooms: number;\n has_kitchen: boolean;\n has_parking: boolean;\n has_security: boolean;\n power_supply: PowerSupplyType;\n furnishing: FurnishingType;\n}\n\nexport interface SearchFilters {\n location?: EnuguLocation;\n min_price?: number;\n max_price?: number;\n bedrooms?: number;\n bathrooms?: number;\n has_kitchen?: boolean;\n has_parking?: boolean;\n has_security?: boolean;\n power_supply?: PowerSupplyType;\n furnishing?: FurnishingType;\n}\n\nexport interface ChatMessage {\n id: number;\n listing_id: number;\n sender_id: number;\n sender_name: string;\n message: string;\n timestamp: string;\n is_agent: boolean;\n}\n\nexport interface AuthResponse {\n success: boolean;\n user?: User;\n token?: string;\n message?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n message?: string;\n error?: string;\n}\n\nexport interface PaginatedResponse {\n data: T[];\n total: number;\n page: number;\n limit: number;\n total_pages: number;\n}\n\n// Form interfaces\nexport interface LoginForm {\n email: string;\n password: string;\n}\n\nexport interface RegisterForm {\n name: string;\n email: string;\n phone: string;\n password: string;\n confirm_password: string;\n}\n\nexport interface PropertyForm {\n title: string;\n description: string;\n price: number;\n location: EnuguLocation;\n agent_fee: number;\n legal_fee: number;\n maintenance_fee: number;\n bedrooms: number;\n bathrooms: number;\n has_kitchen: boolean;\n has_parking: boolean;\n has_security: boolean;\n power_supply: PowerSupplyType;\n furnishing: FurnishingType;\n images: string[];\n}\n\nexport interface ContactForm {\n name: string;\n email: string;\n phone: string;\n subject: string;\n message: string;\n}",[],[145,198],["D",1748677110511],[181,182],[145],"9399565e-3df3-11f0-a56c-76b3cceeab13",["D",1748677681103],[],[43,33],["D",1748677681103],[179],[43],"7bbbf848-3df3-11f0-bfbc-76b3cceeab13","index.ts",11,["D",1748677641066],"http","// Main backend entry point for Enugu Rents\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations, seedSampleData } from \"./database/migrations.ts\";\nimport { PropertyQueries } from \"./database/queries.ts\";\nimport authRoutes from \"./routes/auth.ts\";\nimport listingsRoutes from \"./routes/listings.ts\";\nimport staticRoutes from \"./routes/static.ts\";\nimport type { ApiResponse } from \"../shared/types.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// CORS middleware (Val Town handles CORS automatically, but keeping for completeness)\napp.use('*', cors({\n origin: '*',\n allowMethods: ['GET', 'POST', 'PUT', 'DELETE', 'OPTIONS'],\n allowHeaders: ['Content-Type', 'Authorization'],\n}));\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n console.log(\"Initializing database...\");\n await runMigrations();\n \n // Seed sample data only if no listings exist\n const existingListings = await PropertyQueries.getFeaturedListings(1);\n if (existingListings.length === 0) {\n await seedSampleData();\n }\n \n dbInitialized = true;\n console.log(\"Database initialized successfully!\");\n }\n}\n\n// Health check endpoint\napp.get('/api/health', async (c) => {\n await initializeDatabase();\n \n return c.json({\n success: true,\n message: 'Enugu Rents API is running',\n timestamp: new Date().toISOString(),\n version: '1.0.0'\n } as ApiResponse);\n});\n\n// API routes\napp.route('/api/auth', authRoutes);\napp.route('/api/listings', listingsRoutes);\n\n// Contact form endpoint\napp.post('/api/contact', async (c) => {\n try {\n const body = await c.req.json();\n \n // Validate required fields\n const requiredFields = ['name', 'email', 'subject', 'message'];\n for (const field of requiredFields) {\n if (!body[field] || body[field].trim().length === 0) {\n return c.json({\n success: false,\n message: `${field} is required`\n } as ApiResponse, 400);\n }\n }\n \n // In a real application, you would send an email here\n // For now, we'll just log the contact form submission\n console.log('Contact form submission:', {\n name: body.name,\n email: body.email,\n phone: body.phone,\n subject: body.subject,\n message: body.message,\n timestamp: new Date().toISOString()\n });\n \n return c.json({\n success: true,\n message: 'Thank you for your message. We will get back to you soon!'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Contact form error:', error);\n return c.json({\n success: false,\n message: 'Failed to send message. Please try again.'\n } as ApiResponse, 500);\n }\n});\n\n// Statistics endpoint\napp.get('/api/stats', async (c) => {\n try {\n await initializeDatabase();\n \n // Get basic statistics\n const allListings = await PropertyQueries.getListings({}, 1, 1000);\n const featuredListings = await PropertyQueries.getFeaturedListings(100);\n \n // Calculate location distribution\n const locationStats: Record = {};\n allListings.data.forEach(listing => {\n locationStats[listing.location] = (locationStats[listing.location] || 0) + 1;\n });\n \n // Calculate price ranges\n const prices = allListings.data.map(l => l.price);\n const avgPrice = prices.length > 0 ? Math.round(prices.reduce((a, b) => a + b, 0) / prices.length) : 0;\n const minPrice = prices.length > 0 ? Math.min(...prices) : 0;\n const maxPrice = prices.length > 0 ? Math.max(...prices) : 0;\n \n return c.json({\n success: true,\n data: {\n total_listings: allListings.total,\n featured_listings: featuredListings.length,\n location_distribution: locationStats,\n price_stats: {\n average: avgPrice,\n minimum: minPrice,\n maximum: maxPrice\n }\n }\n } as ApiResponse);\n \n } catch (error) {\n console.error('Stats error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch statistics'\n } as ApiResponse, 500);\n }\n});\n\n// Static file routes\napp.route('/', staticRoutes);\n\n// Serve main application\napp.get('/', async (c) => {\n try {\n await initializeDatabase();\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const featuredListings = await PropertyQueries.getFeaturedListings(6);\n const recentListings = await PropertyQueries.getListings({}, 1, 8);\n \n const initialData = {\n featuredListings,\n recentListings: recentListings.data,\n timestamp: new Date().toISOString()\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error('Serve index error:', error);\n return c.text('Error loading application', 500);\n }\n});\n\n// Catch-all route for SPA routing\napp.get('*', async (c) => {\n try {\n // For SPA routes, serve the main index.html\n const path = c.req.path;\n \n // Check if it's an API route that doesn't exist\n if (path.startsWith('/api/')) {\n return c.json({\n success: false,\n message: 'API endpoint not found'\n } as ApiResponse, 404);\n }\n \n // For all other routes, serve the SPA\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject route-specific data if needed\n let initialData: any = { timestamp: new Date().toISOString() };\n \n if (path.startsWith('/listing/')) {\n // Extract listing ID from path\n const listingId = parseInt(path.split('/')[2]);\n if (!isNaN(listingId)) {\n const listing = await PropertyQueries.getListingById(listingId);\n if (listing) {\n initialData.currentListing = listing;\n }\n }\n } else if (path === '/browse') {\n const listings = await PropertyQueries.getListings({}, 1, 12);\n initialData.browseListings = listings;\n }\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error('SPA route error:', error);\n return c.text('Error loading page', 500);\n }\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;","enugurent",[],[154,215],"679d0578-3df3-11f0-9b6e-76b3cceeab13","static.ts","679d062c-3df3-11f0-9b6e-76b3cceeab13","c47297f0-e210-40b5-aa47-ff7f724b397b",9,["D",1748677607301],"// Static file serving routes for Enugu Rents\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", async (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve shared files\nstaticRoutes.get(\"/shared/*\", async (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve favicon\nstaticRoutes.get(\"/favicon.ico\", async (c) => {\n return serveFile(\"/frontend/favicon.svg\", import.meta.url);\n});\n\n// Serve robots.txt\nstaticRoutes.get(\"/robots.txt\", async (c) => {\n return c.text(`User-agent: *\nAllow: /\n\nSitemap: ${c.req.url.replace(c.req.path, '')}/sitemap.xml`);\n});\n\n// Serve sitemap.xml\nstaticRoutes.get(\"/sitemap.xml\", async (c) => {\n const baseUrl = c.req.url.replace(c.req.path, '');\n \n const sitemap = `\n\n \n ${baseUrl}/\n daily\n 1.0\n \n \n ${baseUrl}/browse\n daily\n 0.9\n \n \n ${baseUrl}/about\n monthly\n 0.7\n \n \n ${baseUrl}/contact\n monthly\n 0.7\n \n \n ${baseUrl}/faq\n monthly\n 0.6\n \n`;\n\n return c.text(sitemap, 200, {\n 'Content-Type': 'application/xml'\n });\n});\n\nexport default staticRoutes;",[],[154,232,224],"routes","5cff08a0-3df3-11f0-93a1-76b3cceeab13","listings.ts","5cff0954-3df3-11f0-93a1-76b3cceeab13",8,["D",1748677589498],"// Property listings routes for Enugu Rents\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n PropertyQueries, \n ChatQueries, \n SavedListingsQueries, \n InspectionQueries,\n UserQueries \n} from \"../database/queries.ts\";\nimport { requireAuth } from \"./auth.ts\";\nimport type { \n PropertyForm, \n SearchFilters, \n ApiResponse, \n PaginatedResponse, \n PropertyListing \n} from \"../../shared/types.ts\";\n\nconst listings = new Hono();\n\n// Get all listings with filters and pagination\nlistings.get('/', async (c) => {\n try {\n const query = c.req.query();\n const page = parseInt(query.page || '1');\n const limit = parseInt(query.limit || '12');\n \n // Build filters from query parameters\n const filters: SearchFilters = {};\n \n if (query.location) filters.location = query.location as any;\n if (query.min_price) filters.min_price = parseInt(query.min_price);\n if (query.max_price) filters.max_price = parseInt(query.max_price);\n if (query.bedrooms) filters.bedrooms = parseInt(query.bedrooms);\n if (query.bathrooms) filters.bathrooms = parseInt(query.bathrooms);\n if (query.has_kitchen) filters.has_kitchen = query.has_kitchen === 'true';\n if (query.has_parking) filters.has_parking = query.has_parking === 'true';\n if (query.has_security) filters.has_security = query.has_security === 'true';\n if (query.power_supply) filters.power_supply = query.power_supply as any;\n if (query.furnishing) filters.furnishing = query.furnishing as any;\n \n const result = await PropertyQueries.getListings(filters, page, limit);\n \n return c.json({\n success: true,\n data: result\n } as ApiResponse>);\n \n } catch (error) {\n console.error('Get listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch listings'\n } as ApiResponse, 500);\n }\n});\n\n// Get featured listings\nlistings.get('/featured', async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '6');\n const featuredListings = await PropertyQueries.getFeaturedListings(limit);\n \n return c.json({\n success: true,\n data: featuredListings\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get featured listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch featured listings'\n } as ApiResponse, 500);\n }\n});\n\n// Get single listing by ID\nlistings.get('/:id', async (c) => {\n try {\n const id = parseInt(c.req.param('id'));\n if (isNaN(id)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n const listing = await PropertyQueries.getListingById(id);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Increment view count\n await PropertyQueries.incrementViews(id);\n \n return c.json({\n success: true,\n data: listing\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch listing'\n } as ApiResponse, 500);\n }\n});\n\n// Create new listing (requires authentication)\nlistings.post('/', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const body: PropertyForm = await c.req.json();\n \n // Validate required fields\n const requiredFields = [\n 'title', 'description', 'price', 'location', \n 'bedrooms', 'bathrooms', 'power_supply', 'furnishing'\n ];\n \n for (const field of requiredFields) {\n if (!body[field] && body[field] !== 0) {\n return c.json({\n success: false,\n message: `${field} is required`\n } as ApiResponse, 400);\n }\n }\n \n // Validate numeric fields\n if (body.price <= 0 || body.bedrooms < 0 || body.bathrooms < 0) {\n return c.json({\n success: false,\n message: 'Price must be positive and bedroom/bathroom counts cannot be negative'\n } as ApiResponse, 400);\n }\n \n // Get user details for agent info\n const user = await UserQueries.getUserById(userId);\n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as ApiResponse, 404);\n }\n \n // Create listing data\n const listingData = {\n ...body,\n agent_id: userId,\n agent_name: user.name,\n agent_phone: user.phone || '',\n agent_email: user.email,\n agent_fee: body.agent_fee || 0,\n legal_fee: body.legal_fee || 0,\n maintenance_fee: body.maintenance_fee || 0,\n images: body.images || []\n };\n \n const listing = await PropertyQueries.createListing(listingData);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Failed to create listing'\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n data: listing,\n message: 'Listing created successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Create listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to create listing'\n } as ApiResponse, 500);\n }\n});\n\n// Update listing (requires authentication and ownership)\nlistings.put('/:id', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const id = parseInt(c.req.param('id'));\n const body = await c.req.json();\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists and user owns it\n const existingListing = await PropertyQueries.getListingById(id);\n if (!existingListing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n if (existingListing.agent_id !== userId) {\n return c.json({\n success: false,\n message: 'You can only update your own listings'\n } as ApiResponse, 403);\n }\n \n // Filter allowed update fields\n const allowedFields = [\n 'title', 'description', 'price', 'location', 'agent_fee', \n 'legal_fee', 'maintenance_fee', 'bedrooms', 'bathrooms', \n 'has_kitchen', 'has_parking', 'has_security', 'power_supply', \n 'furnishing', 'images'\n ];\n \n const updates: any = {};\n for (const field of allowedFields) {\n if (body[field] !== undefined) {\n updates[field] = body[field];\n }\n }\n \n if (Object.keys(updates).length === 0) {\n return c.json({\n success: false,\n message: 'No valid fields to update'\n } as ApiResponse, 400);\n }\n \n const success = await PropertyQueries.updateListing(id, updates);\n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to update listing'\n } as ApiResponse, 500);\n }\n \n const updatedListing = await PropertyQueries.getListingById(id);\n return c.json({\n success: true,\n data: updatedListing,\n message: 'Listing updated successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Update listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to update listing'\n } as ApiResponse, 500);\n }\n});\n\n// Delete listing (requires authentication and ownership)\nlistings.delete('/:id', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const id = parseInt(c.req.param('id'));\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n const success = await PropertyQueries.deleteListing(id, userId);\n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to delete listing or listing not found'\n } as ApiResponse, 404);\n }\n \n return c.json({\n success: true,\n message: 'Listing deleted successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Delete listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to delete listing'\n } as ApiResponse, 500);\n }\n});\n\n// Get user's own listings\nlistings.get('/my/listings', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const userListings = await PropertyQueries.getListingsByAgent(userId);\n \n return c.json({\n success: true,\n data: userListings\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get user listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch your listings'\n } as ApiResponse, 500);\n }\n});\n\n// Save/unsave listing\nlistings.post('/:id/save', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Check if already saved\n const isAlreadySaved = await SavedListingsQueries.isListingSaved(userId, listingId);\n \n let success: boolean;\n let message: string;\n \n if (isAlreadySaved) {\n success = await SavedListingsQueries.unsaveListing(userId, listingId);\n message = success ? 'Listing removed from saved' : 'Failed to remove from saved';\n } else {\n success = await SavedListingsQueries.saveListing(userId, listingId);\n message = success ? 'Listing saved successfully' : 'Failed to save listing';\n }\n \n if (!success) {\n return c.json({\n success: false,\n message\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n message,\n data: { saved: !isAlreadySaved }\n } as ApiResponse);\n \n } catch (error) {\n console.error('Save listing error:', error);\n return c.json({\n success: false,\n message: 'Failed to save/unsave listing'\n } as ApiResponse, 500);\n }\n});\n\n// Get saved listings\nlistings.get('/my/saved', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const savedListings = await SavedListingsQueries.getSavedListings(userId);\n \n return c.json({\n success: true,\n data: savedListings\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get saved listings error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch saved listings'\n } as ApiResponse, 500);\n }\n});\n\n// Send message to agent\nlistings.post('/:id/chat', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n const body = await c.req.json();\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n if (!body.message || body.message.trim().length === 0) {\n return c.json({\n success: false,\n message: 'Message cannot be empty'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Get user details\n const user = await UserQueries.getUserById(userId);\n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as ApiResponse, 404);\n }\n \n // Create chat message\n const message = await ChatQueries.createMessage({\n listing_id: listingId,\n sender_id: userId,\n sender_name: user.name,\n message: body.message.trim(),\n is_agent: userId === listing.agent_id\n });\n \n if (!message) {\n return c.json({\n success: false,\n message: 'Failed to send message'\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n data: message,\n message: 'Message sent successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Send message error:', error);\n return c.json({\n success: false,\n message: 'Failed to send message'\n } as ApiResponse, 500);\n }\n});\n\n// Get chat messages for a listing\nlistings.get('/:id/chat', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Get messages\n const messages = await ChatQueries.getMessagesByListing(listingId);\n \n // Mark messages as read\n await ChatQueries.markMessagesAsRead(listingId, userId);\n \n return c.json({\n success: true,\n data: messages\n } as ApiResponse);\n \n } catch (error) {\n console.error('Get chat messages error:', error);\n return c.json({\n success: false,\n message: 'Failed to fetch messages'\n } as ApiResponse, 500);\n }\n});\n\n// Request inspection\nlistings.post('/:id/inspection', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const listingId = parseInt(c.req.param('id'));\n const body = await c.req.json();\n \n if (isNaN(listingId)) {\n return c.json({\n success: false,\n message: 'Invalid listing ID'\n } as ApiResponse, 400);\n }\n \n // Validate required fields\n if (!body.preferred_date || !body.preferred_time) {\n return c.json({\n success: false,\n message: 'Preferred date and time are required'\n } as ApiResponse, 400);\n }\n \n // Check if listing exists\n const listing = await PropertyQueries.getListingById(listingId);\n if (!listing) {\n return c.json({\n success: false,\n message: 'Listing not found'\n } as ApiResponse, 404);\n }\n \n // Get user details\n const user = await UserQueries.getUserById(userId);\n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as ApiResponse, 404);\n }\n \n // Create inspection request\n const success = await InspectionQueries.createRequest({\n listing_id: listingId,\n requester_id: userId,\n requester_name: user.name,\n requester_phone: user.phone || '',\n requester_email: user.email,\n preferred_date: body.preferred_date,\n preferred_time: body.preferred_time,\n message: body.message\n });\n \n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to create inspection request'\n } as ApiResponse, 500);\n }\n \n return c.json({\n success: true,\n message: 'Inspection request sent successfully'\n } as ApiResponse);\n \n } catch (error) {\n console.error('Request inspection error:', error);\n return c.json({\n success: false,\n message: 'Failed to request inspection'\n } as ApiResponse, 500);\n }\n});\n\nexport default listings;",[],[154,232,234],"3642f424-3df3-11f0-8ab3-76b3cceeab13","auth.ts","3642f4c4-3df3-11f0-8ab3-76b3cceeab13",7,["D",1748677524511],"// Authentication routes for Enugu Rents\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sign, verify } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { setCookie, getCookie, deleteCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport { UserQueries } from \"../database/queries.ts\";\nimport type { AuthResponse, LoginForm, RegisterForm } from \"../../shared/types.ts\";\nimport { isValidEmail, isValidNigerianPhone, validatePassword } from \"../../shared/utils.ts\";\n\nconst auth = new Hono();\n\n// JWT secret - in production, this should be in environment variables\nconst JWT_SECRET = Deno.env.get('JWT_SECRET') || 'enugu-rents-secret-key-2024';\n\n// Simple password hashing (in production, use bcrypt or similar)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'enugu-salt');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nasync function verifyPassword(password: string, hash: string): Promise {\n const hashedInput = await hashPassword(password);\n return hashedInput === hash;\n}\n\n// Generate JWT token\nasync function generateToken(userId: number, email: string): Promise {\n const payload = {\n userId,\n email,\n exp: Math.floor(Date.now() / 1000) + (24 * 60 * 60), // 24 hours\n };\n return await sign(payload, JWT_SECRET);\n}\n\n// Verify JWT token\nexport async function verifyToken(token: string): Promise<{ userId: number; email: string } | null> {\n try {\n const payload = await verify(token, JWT_SECRET) as any;\n return { userId: payload.userId, email: payload.email };\n } catch {\n return null;\n }\n}\n\n// Middleware to check authentication\nexport async function requireAuth(c: any, next: any) {\n const token = getCookie(c, 'auth_token') || c.req.header('Authorization')?.replace('Bearer ', '');\n \n if (!token) {\n return c.json({ success: false, message: 'Authentication required' }, 401);\n }\n \n const user = await verifyToken(token);\n if (!user) {\n return c.json({ success: false, message: 'Invalid or expired token' }, 401);\n }\n \n // Add user info to context\n c.set('user', user);\n await next();\n}\n\n// Register new user\nauth.post('/register', async (c) => {\n try {\n const body: RegisterForm = await c.req.json();\n \n // Validate input\n if (!body.name || !body.email || !body.password || !body.confirm_password) {\n return c.json({\n success: false,\n message: 'All fields are required'\n } as AuthResponse, 400);\n }\n \n if (!isValidEmail(body.email)) {\n return c.json({\n success: false,\n message: 'Invalid email format'\n } as AuthResponse, 400);\n }\n \n if (body.phone && !isValidNigerianPhone(body.phone)) {\n return c.json({\n success: false,\n message: 'Invalid Nigerian phone number format'\n } as AuthResponse, 400);\n }\n \n if (body.password !== body.confirm_password) {\n return c.json({\n success: false,\n message: 'Passwords do not match'\n } as AuthResponse, 400);\n }\n \n const passwordValidation = validatePassword(body.password);\n if (!passwordValidation.isValid) {\n return c.json({\n success: false,\n message: passwordValidation.errors.join(', ')\n } as AuthResponse, 400);\n }\n \n // Check if user already exists\n const existingUser = await UserQueries.getUserByEmail(body.email);\n if (existingUser) {\n return c.json({\n success: false,\n message: 'User with this email already exists'\n } as AuthResponse, 400);\n }\n \n // Hash password and create user\n const passwordHash = await hashPassword(body.password);\n const user = await UserQueries.createUser({\n email: body.email,\n name: body.name,\n phone: body.phone,\n password_hash: passwordHash\n });\n \n if (!user) {\n return c.json({\n success: false,\n message: 'Failed to create user account'\n } as AuthResponse, 500);\n }\n \n // Generate token and set cookie\n const token = await generateToken(user.id, user.email);\n setCookie(c, 'auth_token', token, {\n httpOnly: true,\n secure: true,\n sameSite: 'Strict',\n maxAge: 24 * 60 * 60 // 24 hours\n });\n \n return c.json({\n success: true,\n user,\n token,\n message: 'Account created successfully'\n } as AuthResponse);\n \n } catch (error) {\n console.error('Registration error:', error);\n return c.json({\n success: false,\n message: 'Internal server error'\n } as AuthResponse, 500);\n }\n});\n\n// Login user\nauth.post('/login', async (c) => {\n try {\n const body: LoginForm = await c.req.json();\n \n // Validate input\n if (!body.email || !body.password) {\n return c.json({\n success: false,\n message: 'Email and password are required'\n } as AuthResponse, 400);\n }\n \n if (!isValidEmail(body.email)) {\n return c.json({\n success: false,\n message: 'Invalid email format'\n } as AuthResponse, 400);\n }\n \n // Get user with password\n const userWithPassword = await UserQueries.getUserWithPassword(body.email);\n if (!userWithPassword) {\n return c.json({\n success: false,\n message: 'Invalid email or password'\n } as AuthResponse, 401);\n }\n \n // Verify password\n const isValidPassword = await verifyPassword(body.password, userWithPassword.password_hash);\n if (!isValidPassword) {\n return c.json({\n success: false,\n message: 'Invalid email or password'\n } as AuthResponse, 401);\n }\n \n // Remove password from user object\n const { password_hash, ...user } = userWithPassword;\n \n // Generate token and set cookie\n const token = await generateToken(user.id, user.email);\n setCookie(c, 'auth_token', token, {\n httpOnly: true,\n secure: true,\n sameSite: 'Strict',\n maxAge: 24 * 60 * 60 // 24 hours\n });\n \n return c.json({\n success: true,\n user,\n token,\n message: 'Login successful'\n } as AuthResponse);\n \n } catch (error) {\n console.error('Login error:', error);\n return c.json({\n success: false,\n message: 'Internal server error'\n } as AuthResponse, 500);\n }\n});\n\n// Logout user\nauth.post('/logout', async (c) => {\n deleteCookie(c, 'auth_token');\n return c.json({\n success: true,\n message: 'Logged out successfully'\n } as AuthResponse);\n});\n\n// Get current user\nauth.get('/me', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const user = await UserQueries.getUserById(userId);\n \n if (!user) {\n return c.json({\n success: false,\n message: 'User not found'\n } as AuthResponse, 404);\n }\n \n return c.json({\n success: true,\n user\n } as AuthResponse);\n \n } catch (error) {\n console.error('Get user error:', error);\n return c.json({\n success: false,\n message: 'Internal server error'\n } as AuthResponse, 500);\n }\n});\n\n// Update user profile\nauth.put('/profile', requireAuth, async (c) => {\n try {\n const { userId } = c.get('user');\n const body = await c.req.json();\n \n // Validate input\n const allowedFields = ['name', 'phone'];\n const updates: any = {};\n \n for (const field of allowedFields) {\n if (body[field] !== undefined) {\n if (field === 'phone' && body[field] && !isValidNigerianPhone(body[field])) {\n return c.json({\n success: false,\n message: 'Invalid Nigerian phone number format'\n } as AuthResponse, 400);\n }\n updates[field] = body[field];\n }\n }\n \n if (Object.keys(updates).length === 0) {\n return c.json({\n success: false,\n message: 'No valid fields to update'\n } as AuthResponse, 400);\n }\n \n const success = await UserQueries.updateUser(userId, updates);\n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to update profile'\n } as AuthResponse, 500);\n }\n \n const updatedUser = await UserQueries.getUserById(userId);\n return c.json({\n success: true,\n user: updatedUser,\n message: 'Profile updated successfully'\n } as AuthResponse);\n \n } catch (error) {\n console.error('Update profile error:', error);\n return c.json({\n success: false,\n message: 'Internal server error'\n } as AuthResponse, 500);\n }\n});\n\n// Change password\nauth.put('/password', requireAuth, async (c) => {\n try {\n const { userId, email } = c.get('user');\n const body = await c.req.json();\n \n if (!body.current_password || !body.new_password || !body.confirm_password) {\n return c.json({\n success: false,\n message: 'All password fields are required'\n } as AuthResponse, 400);\n }\n \n if (body.new_password !== body.confirm_password) {\n return c.json({\n success: false,\n message: 'New passwords do not match'\n } as AuthResponse, 400);\n }\n \n const passwordValidation = validatePassword(body.new_password);\n if (!passwordValidation.isValid) {\n return c.json({\n success: false,\n message: passwordValidation.errors.join(', ')\n } as AuthResponse, 400);\n }\n \n // Verify current password\n const userWithPassword = await UserQueries.getUserWithPassword(email);\n if (!userWithPassword) {\n return c.json({\n success: false,\n message: 'User not found'\n } as AuthResponse, 404);\n }\n \n const isValidCurrentPassword = await verifyPassword(body.current_password, userWithPassword.password_hash);\n if (!isValidCurrentPassword) {\n return c.json({\n success: false,\n message: 'Current password is incorrect'\n } as AuthResponse, 401);\n }\n \n // Hash new password and update\n const newPasswordHash = await hashPassword(body.new_password);\n const success = await UserQueries.updateUser(userId, { password_hash: newPasswordHash } as any);\n \n if (!success) {\n return c.json({\n success: false,\n message: 'Failed to update password'\n } as AuthResponse, 500);\n }\n \n return c.json({\n success: true,\n message: 'Password updated successfully'\n } as AuthResponse);\n \n } catch (error) {\n console.error('Change password error:', error);\n return c.json({\n success: false,\n message: 'Internal server error'\n } as AuthResponse, 500);\n }\n});\n\nexport default auth;",[],[154,232,242],"36430db0-3df3-11f0-8ab3-76b3cceeab13",["D",1748677524511],[174,175,176],[154,232],"1d0f402a-3df3-11f0-98ac-76b3cceeab13","queries.ts","85b2f38e-3df2-11f0-8e23-76b3cceeab13","7ade9417-6732-4cfa-a418-7bcd50dde1a4",6,["D",1748677482224],"// Database query functions for Enugu Rents\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n User, \n PropertyListing, \n SearchFilters, \n ChatMessage, \n PaginatedResponse \n} from \"../../shared/types.ts\";\n\n// User queries\nexport class UserQueries {\n static async createUser(userData: {\n email: string;\n name: string;\n phone?: string;\n password_hash: string;\n }): Promise {\n try {\n const result = await sqlite.execute(`\n INSERT INTO users_v1 (email, name, phone, password_hash)\n VALUES (?, ?, ?, ?)\n `, [userData.email, userData.name, userData.phone || null, userData.password_hash]);\n \n if (result.changes > 0) {\n return await this.getUserById(result.lastInsertRowid as number);\n }\n return null;\n } catch (error) {\n console.error('Error creating user:', error);\n return null;\n }\n }\n \n static async getUserByEmail(email: string): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT id, email, name, phone, is_verified, created_at\n FROM users_v1 \n WHERE email = ?\n `, [email]);\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n } catch (error) {\n console.error('Error getting user by email:', error);\n return null;\n }\n }\n \n static async getUserById(id: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT id, email, name, phone, is_verified, created_at\n FROM users_v1 \n WHERE id = ?\n `, [id]);\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n } catch (error) {\n console.error('Error getting user by ID:', error);\n return null;\n }\n }\n \n static async getUserWithPassword(email: string): Promise<(User & { password_hash: string }) | null> {\n try {\n const result = await sqlite.execute(`\n SELECT id, email, name, phone, password_hash, is_verified, created_at\n FROM users_v1 \n WHERE email = ?\n `, [email]);\n \n return result.rows.length > 0 ? result.rows[0] as (User & { password_hash: string }) : null;\n } catch (error) {\n console.error('Error getting user with password:', error);\n return null;\n }\n }\n \n static async updateUser(id: number, updates: Partial): Promise {\n try {\n const setClause = Object.keys(updates)\n .map(key => `${key} = ?`)\n .join(', ');\n \n const values = Object.values(updates);\n values.push(id);\n \n const result = await sqlite.execute(`\n UPDATE users_v1 \n SET ${setClause}, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, values);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error updating user:', error);\n return false;\n }\n }\n}\n\n// Property listing queries\nexport class PropertyQueries {\n static async createListing(listingData: Omit): Promise {\n try {\n const result = await sqlite.execute(`\n INSERT INTO property_listings_v1 (\n title, description, price, location, agent_fee, legal_fee, maintenance_fee,\n bedrooms, bathrooms, has_kitchen, has_parking, has_security, power_supply,\n furnishing, images, agent_id, agent_name, agent_phone, agent_email\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n listingData.title, listingData.description, listingData.price, listingData.location,\n listingData.agent_fee, listingData.legal_fee, listingData.maintenance_fee,\n listingData.bedrooms, listingData.bathrooms, listingData.has_kitchen,\n listingData.has_parking, listingData.has_security, listingData.power_supply,\n listingData.furnishing, JSON.stringify(listingData.images), listingData.agent_id,\n listingData.agent_name, listingData.agent_phone, listingData.agent_email\n ]);\n \n if (result.changes > 0) {\n return await this.getListingById(result.lastInsertRowid as number);\n }\n return null;\n } catch (error) {\n console.error('Error creating listing:', error);\n return null;\n }\n }\n \n static async getListingById(id: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT * FROM property_listings_v1 WHERE id = ? AND is_active = TRUE\n `, [id]);\n \n if (result.rows.length > 0) {\n const listing = result.rows[0] as any;\n listing.images = JSON.parse(listing.images || '[]');\n return listing as PropertyListing;\n }\n return null;\n } catch (error) {\n console.error('Error getting listing by ID:', error);\n return null;\n }\n }\n \n static async getListings(\n filters: SearchFilters = {},\n page: number = 1,\n limit: number = 12\n ): Promise> {\n try {\n const offset = (page - 1) * limit;\n let whereClause = 'WHERE is_active = TRUE';\n const params: any[] = [];\n \n // Build filter conditions\n if (filters.location) {\n whereClause += ' AND location = ?';\n params.push(filters.location);\n }\n \n if (filters.min_price) {\n whereClause += ' AND price >= ?';\n params.push(filters.min_price);\n }\n \n if (filters.max_price) {\n whereClause += ' AND price <= ?';\n params.push(filters.max_price);\n }\n \n if (filters.bedrooms) {\n whereClause += ' AND bedrooms >= ?';\n params.push(filters.bedrooms);\n }\n \n if (filters.bathrooms) {\n whereClause += ' AND bathrooms >= ?';\n params.push(filters.bathrooms);\n }\n \n if (filters.has_kitchen !== undefined) {\n whereClause += ' AND has_kitchen = ?';\n params.push(filters.has_kitchen);\n }\n \n if (filters.has_parking !== undefined) {\n whereClause += ' AND has_parking = ?';\n params.push(filters.has_parking);\n }\n \n if (filters.has_security !== undefined) {\n whereClause += ' AND has_security = ?';\n params.push(filters.has_security);\n }\n \n if (filters.power_supply) {\n whereClause += ' AND power_supply = ?';\n params.push(filters.power_supply);\n }\n \n if (filters.furnishing) {\n whereClause += ' AND furnishing = ?';\n params.push(filters.furnishing);\n }\n \n // Get total count\n const countResult = await sqlite.execute(`\n SELECT COUNT(*) as total FROM property_listings_v1 ${whereClause}\n `, params);\n \n const total = countResult.rows[0].total as number;\n \n // Get listings with pagination\n const listingsResult = await sqlite.execute(`\n SELECT * FROM property_listings_v1 \n ${whereClause}\n ORDER BY is_featured DESC, created_at DESC\n LIMIT ? OFFSET ?\n `, [...params, limit, offset]);\n \n const listings = listingsResult.rows.map((row: any) => {\n row.images = JSON.parse(row.images || '[]');\n return row as PropertyListing;\n });\n \n return {\n data: listings,\n total,\n page,\n limit,\n total_pages: Math.ceil(total / limit)\n };\n } catch (error) {\n console.error('Error getting listings:', error);\n return {\n data: [],\n total: 0,\n page,\n limit,\n total_pages: 0\n };\n }\n }\n \n static async getFeaturedListings(limit: number = 6): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT * FROM property_listings_v1 \n WHERE is_active = TRUE AND is_featured = TRUE\n ORDER BY created_at DESC\n LIMIT ?\n `, [limit]);\n \n return result.rows.map((row: any) => {\n row.images = JSON.parse(row.images || '[]');\n return row as PropertyListing;\n });\n } catch (error) {\n console.error('Error getting featured listings:', error);\n return [];\n }\n }\n \n static async getListingsByAgent(agentId: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT * FROM property_listings_v1 \n WHERE agent_id = ? AND is_active = TRUE\n ORDER BY created_at DESC\n `, [agentId]);\n \n return result.rows.map((row: any) => {\n row.images = JSON.parse(row.images || '[]');\n return row as PropertyListing;\n });\n } catch (error) {\n console.error('Error getting listings by agent:', error);\n return [];\n }\n }\n \n static async updateListing(id: number, updates: Partial): Promise {\n try {\n const updateFields = { ...updates };\n if (updateFields.images) {\n updateFields.images = JSON.stringify(updateFields.images) as any;\n }\n \n const setClause = Object.keys(updateFields)\n .map(key => `${key} = ?`)\n .join(', ');\n \n const values = Object.values(updateFields);\n values.push(id);\n \n const result = await sqlite.execute(`\n UPDATE property_listings_v1 \n SET ${setClause}, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, values);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error updating listing:', error);\n return false;\n }\n }\n \n static async incrementViews(id: number): Promise {\n try {\n const result = await sqlite.execute(`\n UPDATE property_listings_v1 \n SET views_count = views_count + 1\n WHERE id = ?\n `, [id]);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error incrementing views:', error);\n return false;\n }\n }\n \n static async deleteListing(id: number, agentId: number): Promise {\n try {\n const result = await sqlite.execute(`\n UPDATE property_listings_v1 \n SET is_active = FALSE, updated_at = CURRENT_TIMESTAMP\n WHERE id = ? AND agent_id = ?\n `, [id, agentId]);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error deleting listing:', error);\n return false;\n }\n }\n}\n\n// Chat message queries\nexport class ChatQueries {\n static async createMessage(messageData: {\n listing_id: number;\n sender_id: number;\n sender_name: string;\n message: string;\n is_agent: boolean;\n }): Promise {\n try {\n const result = await sqlite.execute(`\n INSERT INTO chat_messages_v1 (listing_id, sender_id, sender_name, message, is_agent)\n VALUES (?, ?, ?, ?, ?)\n `, [\n messageData.listing_id,\n messageData.sender_id,\n messageData.sender_name,\n messageData.message,\n messageData.is_agent\n ]);\n \n if (result.changes > 0) {\n return await this.getMessageById(result.lastInsertRowid as number);\n }\n return null;\n } catch (error) {\n console.error('Error creating message:', error);\n return null;\n }\n }\n \n static async getMessageById(id: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT * FROM chat_messages_v1 WHERE id = ?\n `, [id]);\n \n return result.rows.length > 0 ? result.rows[0] as ChatMessage : null;\n } catch (error) {\n console.error('Error getting message by ID:', error);\n return null;\n }\n }\n \n static async getMessagesByListing(listingId: number, limit: number = 50): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT * FROM chat_messages_v1 \n WHERE listing_id = ?\n ORDER BY created_at ASC\n LIMIT ?\n `, [listingId, limit]);\n \n return result.rows as ChatMessage[];\n } catch (error) {\n console.error('Error getting messages by listing:', error);\n return [];\n }\n }\n \n static async markMessagesAsRead(listingId: number, userId: number): Promise {\n try {\n const result = await sqlite.execute(`\n UPDATE chat_messages_v1 \n SET is_read = TRUE\n WHERE listing_id = ? AND sender_id != ?\n `, [listingId, userId]);\n \n return result.changes >= 0;\n } catch (error) {\n console.error('Error marking messages as read:', error);\n return false;\n }\n }\n}\n\n// Saved listings queries\nexport class SavedListingsQueries {\n static async saveListing(userId: number, listingId: number): Promise {\n try {\n const result = await sqlite.execute(`\n INSERT OR IGNORE INTO saved_listings_v1 (user_id, listing_id)\n VALUES (?, ?)\n `, [userId, listingId]);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error saving listing:', error);\n return false;\n }\n }\n \n static async unsaveListing(userId: number, listingId: number): Promise {\n try {\n const result = await sqlite.execute(`\n DELETE FROM saved_listings_v1 \n WHERE user_id = ? AND listing_id = ?\n `, [userId, listingId]);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error unsaving listing:', error);\n return false;\n }\n }\n \n static async getSavedListings(userId: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT p.* FROM property_listings_v1 p\n INNER JOIN saved_listings_v1 s ON p.id = s.listing_id\n WHERE s.user_id = ? AND p.is_active = TRUE\n ORDER BY s.created_at DESC\n `, [userId]);\n \n return result.rows.map((row: any) => {\n row.images = JSON.parse(row.images || '[]');\n return row as PropertyListing;\n });\n } catch (error) {\n console.error('Error getting saved listings:', error);\n return [];\n }\n }\n \n static async isListingSaved(userId: number, listingId: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT 1 FROM saved_listings_v1 \n WHERE user_id = ? AND listing_id = ?\n `, [userId, listingId]);\n \n return result.rows.length > 0;\n } catch (error) {\n console.error('Error checking if listing is saved:', error);\n return false;\n }\n }\n}\n\n// Inspection request queries\nexport class InspectionQueries {\n static async createRequest(requestData: {\n listing_id: number;\n requester_id: number;\n requester_name: string;\n requester_phone: string;\n requester_email: string;\n preferred_date: string;\n preferred_time: string;\n message?: string;\n }): Promise {\n try {\n const result = await sqlite.execute(`\n INSERT INTO inspection_requests_v1 (\n listing_id, requester_id, requester_name, requester_phone, \n requester_email, preferred_date, preferred_time, message\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n requestData.listing_id,\n requestData.requester_id,\n requestData.requester_name,\n requestData.requester_phone,\n requestData.requester_email,\n requestData.preferred_date,\n requestData.preferred_time,\n requestData.message || null\n ]);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error creating inspection request:', error);\n return false;\n }\n }\n \n static async getRequestsByListing(listingId: number): Promise {\n try {\n const result = await sqlite.execute(`\n SELECT * FROM inspection_requests_v1 \n WHERE listing_id = ?\n ORDER BY created_at DESC\n `, [listingId]);\n \n return result.rows;\n } catch (error) {\n console.error('Error getting inspection requests:', error);\n return [];\n }\n }\n \n static async updateRequestStatus(\n requestId: number, \n status: string, \n agentResponse?: string\n ): Promise {\n try {\n const result = await sqlite.execute(`\n UPDATE inspection_requests_v1 \n SET status = ?, agent_response = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?\n `, [status, agentResponse || null, requestId]);\n \n return result.changes > 0;\n } catch (error) {\n console.error('Error updating inspection request status:', error);\n return false;\n }\n }\n}",[],[154,262,254],"database","6c6a343c-3df2-11f0-a26b-76b3cceeab13","migrations.ts","6c6a34f0-3df2-11f0-a26b-76b3cceeab13",["D",1748677185868],"// Database migrations for Enugu Rents\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Run all migrations\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n \n await createUsersTable();\n await createPropertyListingsTable();\n await createChatMessagesTable();\n await createSavedListingsTable();\n await createInspectionRequestsTable();\n \n console.log(\"Database migrations completed successfully!\");\n}\n\n// Users table\nasync function createUsersTable() {\n const TABLE_NAME = 'users_v1';\n \n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n name TEXT NOT NULL,\n phone TEXT,\n password_hash TEXT NOT NULL,\n is_verified BOOLEAN DEFAULT FALSE,\n verification_token TEXT,\n reset_token TEXT,\n reset_token_expires TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n \n // Create indexes\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_users_email ON ${TABLE_NAME}(email)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_users_verification_token ON ${TABLE_NAME}(verification_token)`);\n}\n\n// Property listings table\nasync function createPropertyListingsTable() {\n const TABLE_NAME = 'property_listings_v1';\n \n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n price INTEGER NOT NULL,\n location TEXT NOT NULL,\n agent_fee INTEGER DEFAULT 0,\n legal_fee INTEGER DEFAULT 0,\n maintenance_fee INTEGER DEFAULT 0,\n bedrooms INTEGER NOT NULL,\n bathrooms INTEGER NOT NULL,\n has_kitchen BOOLEAN DEFAULT TRUE,\n has_parking BOOLEAN DEFAULT FALSE,\n has_security BOOLEAN DEFAULT FALSE,\n power_supply TEXT NOT NULL,\n furnishing TEXT NOT NULL,\n images TEXT, -- JSON array of image URLs\n agent_id INTEGER NOT NULL,\n agent_name TEXT NOT NULL,\n agent_phone TEXT NOT NULL,\n agent_email TEXT NOT NULL,\n is_active BOOLEAN DEFAULT TRUE,\n is_featured BOOLEAN DEFAULT FALSE,\n views_count INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (agent_id) REFERENCES users_v1(id)\n )`);\n \n // Create indexes\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_location ON ${TABLE_NAME}(location)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_price ON ${TABLE_NAME}(price)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_bedrooms ON ${TABLE_NAME}(bedrooms)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_agent_id ON ${TABLE_NAME}(agent_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_active ON ${TABLE_NAME}(is_active)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_listings_featured ON ${TABLE_NAME}(is_featured)`);\n}\n\n// Chat messages table\nasync function createChatMessagesTable() {\n const TABLE_NAME = 'chat_messages_v1';\n \n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n listing_id INTEGER NOT NULL,\n sender_id INTEGER NOT NULL,\n sender_name TEXT NOT NULL,\n message TEXT NOT NULL,\n is_agent BOOLEAN DEFAULT FALSE,\n is_read BOOLEAN DEFAULT FALSE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (listing_id) REFERENCES property_listings_v1(id),\n FOREIGN KEY (sender_id) REFERENCES users_v1(id)\n )`);\n \n // Create indexes\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_chat_listing_id ON ${TABLE_NAME}(listing_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_chat_sender_id ON ${TABLE_NAME}(sender_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_chat_created_at ON ${TABLE_NAME}(created_at)`);\n}\n\n// Saved listings table (for users to save properties)\nasync function createSavedListingsTable() {\n const TABLE_NAME = 'saved_listings_v1';\n \n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n listing_id INTEGER NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1(id),\n FOREIGN KEY (listing_id) REFERENCES property_listings_v1(id),\n UNIQUE(user_id, listing_id)\n )`);\n \n // Create indexes\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_saved_user_id ON ${TABLE_NAME}(user_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_saved_listing_id ON ${TABLE_NAME}(listing_id)`);\n}\n\n// Inspection requests table\nasync function createInspectionRequestsTable() {\n const TABLE_NAME = 'inspection_requests_v1';\n \n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n listing_id INTEGER NOT NULL,\n requester_id INTEGER NOT NULL,\n requester_name TEXT NOT NULL,\n requester_phone TEXT NOT NULL,\n requester_email TEXT NOT NULL,\n preferred_date TEXT NOT NULL,\n preferred_time TEXT NOT NULL,\n message TEXT,\n status TEXT DEFAULT 'pending', -- pending, confirmed, cancelled, completed\n agent_response TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (listing_id) REFERENCES property_listings_v1(id),\n FOREIGN KEY (requester_id) REFERENCES users_v1(id)\n )`);\n \n // Create indexes\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_inspection_listing_id ON ${TABLE_NAME}(listing_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_inspection_requester_id ON ${TABLE_NAME}(requester_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_inspection_status ON ${TABLE_NAME}(status)`);\n}\n\n// Seed sample data\nexport async function seedSampleData() {\n console.log(\"Seeding sample data...\");\n \n // Create sample users\n await createSampleUsers();\n await createSampleListings();\n \n console.log(\"Sample data seeded successfully!\");\n}\n\nasync function createSampleUsers() {\n const users = [\n {\n email: 'agent1@enuguproperties.com',\n name: 'Chidi Okafor',\n phone: '+2348123456789',\n password_hash: 'hashed_password_1', // In real app, this would be properly hashed\n is_verified: true\n },\n {\n email: 'agent2@enuguproperties.com',\n name: 'Amaka Nwankwo',\n phone: '+2348123456790',\n password_hash: 'hashed_password_2',\n is_verified: true\n },\n {\n email: 'agent3@enuguproperties.com',\n name: 'Emeka Ugwu',\n phone: '+2348123456791',\n password_hash: 'hashed_password_3',\n is_verified: true\n }\n ];\n \n for (const user of users) {\n try {\n await sqlite.execute(`\n INSERT OR IGNORE INTO users_v1 (email, name, phone, password_hash, is_verified)\n VALUES (?, ?, ?, ?, ?)\n `, [user.email, user.name, user.phone, user.password_hash, user.is_verified]);\n } catch (error) {\n console.log(`User ${user.email} already exists`);\n }\n }\n}\n\nasync function createSampleListings() {\n const listings = [\n {\n title: 'Luxury 3-Bedroom Apartment in GRA',\n description: 'Beautiful 3-bedroom apartment in the heart of GRA with modern amenities, 24/7 security, and excellent road network. Perfect for families and professionals.',\n price: 800000,\n location: 'GRA',\n agent_fee: 100000,\n legal_fee: 50000,\n maintenance_fee: 25000,\n bedrooms: 3,\n bathrooms: 3,\n has_kitchen: true,\n has_parking: true,\n has_security: true,\n power_supply: '24/7 Power',\n furnishing: 'Semi Furnished',\n images: JSON.stringify([\n 'https://picsum.photos/800/600?random=1',\n 'https://picsum.photos/800/600?random=2',\n 'https://picsum.photos/800/600?random=3'\n ]),\n agent_id: 1,\n agent_name: 'Chidi Okafor',\n agent_phone: '+2348123456789',\n agent_email: 'agent1@enuguproperties.com',\n is_featured: true\n },\n {\n title: 'Modern 2-Bedroom Flat in New Haven',\n description: 'Spacious 2-bedroom flat in New Haven with excellent ventilation, tiled floors, and close proximity to major roads and markets.',\n price: 450000,\n location: 'New Haven',\n agent_fee: 60000,\n legal_fee: 30000,\n maintenance_fee: 15000,\n bedrooms: 2,\n bathrooms: 2,\n has_kitchen: true,\n has_parking: false,\n has_security: true,\n power_supply: 'Generator Backup',\n furnishing: 'Unfurnished',\n images: JSON.stringify([\n 'https://picsum.photos/800/600?random=4',\n 'https://picsum.photos/800/600?random=5'\n ]),\n agent_id: 2,\n agent_name: 'Amaka Nwankwo',\n agent_phone: '+2348123456790',\n agent_email: 'agent2@enuguproperties.com',\n is_featured: false\n },\n {\n title: 'Executive 4-Bedroom Duplex in Independence Layout',\n description: 'Executive 4-bedroom duplex with boys quarter, spacious compound, and modern fittings. Ideal for large families.',\n price: 1200000,\n location: 'Independence Layout',\n agent_fee: 150000,\n legal_fee: 75000,\n maintenance_fee: 40000,\n bedrooms: 4,\n bathrooms: 4,\n has_kitchen: true,\n has_parking: true,\n has_security: true,\n power_supply: 'Solar Power',\n furnishing: 'Fully Furnished',\n images: JSON.stringify([\n 'https://picsum.photos/800/600?random=6',\n 'https://picsum.photos/800/600?random=7',\n 'https://picsum.photos/800/600?random=8',\n 'https://picsum.photos/800/600?random=9'\n ]),\n agent_id: 3,\n agent_name: 'Emeka Ugwu',\n agent_phone: '+2348123456791',\n agent_email: 'agent3@enuguproperties.com',\n is_featured: true\n },\n {\n title: 'Affordable 1-Bedroom Apartment in Uwani',\n description: 'Clean and affordable 1-bedroom apartment in Uwani. Perfect for young professionals and students.',\n price: 250000,\n location: 'Uwani',\n agent_fee: 35000,\n legal_fee: 20000,\n maintenance_fee: 10000,\n bedrooms: 1,\n bathrooms: 1,\n has_kitchen: true,\n has_parking: false,\n has_security: false,\n power_supply: 'PHCN Only',\n furnishing: 'Unfurnished',\n images: JSON.stringify([\n 'https://picsum.photos/800/600?random=10',\n 'https://picsum.photos/800/600?random=11'\n ]),\n agent_id: 1,\n agent_name: 'Chidi Okafor',\n agent_phone: '+2348123456789',\n agent_email: 'agent1@enuguproperties.com',\n is_featured: false\n },\n {\n title: 'Spacious 3-Bedroom Bungalow in Trans-Ekulu',\n description: 'Well-built 3-bedroom bungalow with large compound, water supply, and good road access.',\n price: 600000,\n location: 'Trans-Ekulu',\n agent_fee: 80000,\n legal_fee: 40000,\n maintenance_fee: 20000,\n bedrooms: 3,\n bathrooms: 2,\n has_kitchen: true,\n has_parking: true,\n has_security: false,\n power_supply: 'Hybrid',\n furnishing: 'Semi Furnished',\n images: JSON.stringify([\n 'https://picsum.photos/800/600?random=12',\n 'https://picsum.photos/800/600?random=13',\n 'https://picsum.photos/800/600?random=14'\n ]),\n agent_id: 2,\n agent_name: 'Amaka Nwankwo',\n agent_phone: '+2348123456790',\n agent_email: 'agent2@enuguproperties.com',\n is_featured: false\n }\n ];\n \n for (const listing of listings) {\n try {\n await sqlite.execute(`\n INSERT OR IGNORE INTO property_listings_v1 (\n title, description, price, location, agent_fee, legal_fee, maintenance_fee,\n bedrooms, bathrooms, has_kitchen, has_parking, has_security, power_supply,\n furnishing, images, agent_id, agent_name, agent_phone, agent_email, is_featured\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n listing.title, listing.description, listing.price, listing.location,\n listing.agent_fee, listing.legal_fee, listing.maintenance_fee,\n listing.bedrooms, listing.bathrooms, listing.has_kitchen, listing.has_parking,\n listing.has_security, listing.power_supply, listing.furnishing, listing.images,\n listing.agent_id, listing.agent_name, listing.agent_phone, listing.agent_email,\n listing.is_featured\n ]);\n } catch (error) {\n console.log(`Listing \"${listing.title}\" may already exist`);\n }\n }\n}",[],[154,262,264],"6c6a521e-3df2-11f0-a26b-76b3cceeab13",["D",1748677185868],[171,172],[154,262],["D",1748677185868],[170,173,177],[154],["D",1748677067986],{"_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":314,"_315":316,"_317":318,"_319":25,"_320":25,"_321":25,"_322":62,"_323":-5,"_324":-7,"_325":-7,"_326":66,"_327":25,"_328":25,"_329":-5,"_330":25,"_331":25,"_332":25,"_333":-5},"ENV",{"_285":286,"_287":288,"_289":90,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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 · v12