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",[19,71],"9758bdb6-3df3-11f0-aa9d-76b3cceeab13","favicon.svg","9758be60-3df3-11f0-aa9d-76b3cceeab13",13,["D",1748677687392],"",[19,78],"23b6549e-3df4-11f0-b1d3-76b3cceeab13","pages","dc0cf159-657a-47af-973b-b6ac6a69cc3a",21,["D",1748677922884],"directory",[19,85],"c81f117a-3df3-11f0-85ca-76b3cceeab13","components","43b7f5ce-e08a-4575-9835-aa32720e3694",16,["D",1748677769223],[19,92],"93996c0c-3df3-11f0-a56c-76b3cceeab13",["D",1748677681103],[19],{"_39":198,"_13":199,"_42":200,"_44":-5,"_46":47,"_48":201,"_50":51,"_52":202,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":203,"_18":204},{"_39":97,"_13":19,"_42":45,"_44":-5,"_46":47,"_48":73,"_50":51,"_52":137,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":138,"_18":139},{"_39":113,"_13":114,"_42":115,"_44":-5,"_46":47,"_48":116,"_50":51,"_52":117,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":118,"_18":119},{"_39":104,"_13":105,"_42":106,"_44":-5,"_46":47,"_48":107,"_50":51,"_52":108,"_17":54,"_55":24,"_56":109,"_58":59,"_60":-5,"_110":111,"_18":112},"368edb24-3df2-11f0-881b-76b3cceeab13","README.md","368edbec-3df2-11f0-881b-76b3cceeab13",1,["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","children",[],[105],"3f7fd9cc-3df2-11f0-bac8-76b3cceeab13","shared","880f3960-bddb-46d6-b3fe-96f3354094b6",2,["D",1748677110511],[120,121],[114],{"_39":130,"_13":131,"_42":132,"_44":115,"_46":47,"_48":116,"_50":51,"_52":133,"_17":54,"_55":67,"_56":134,"_58":59,"_60":-5,"_110":135,"_18":136},{"_39":122,"_13":123,"_42":124,"_44":115,"_46":47,"_48":125,"_50":51,"_52":126,"_17":54,"_55":67,"_56":127,"_58":59,"_60":-5,"_110":128,"_18":129},"4f0bfd4e-3df2-11f0-83fb-76b3cceeab13","utils.ts","4f0bfe20-3df2-11f0-83fb-76b3cceeab13",3,["D",1748677136599],"// 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}",[],[114,123],"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}",[],[114,131],["D",1748677681103],[140,141,142,143,144,145],[19],{"_39":91,"_13":92,"_42":93,"_44":45,"_46":47,"_48":94,"_50":51,"_52":169,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":170,"_18":171},{"_39":84,"_13":85,"_42":86,"_44":45,"_46":47,"_48":87,"_50":51,"_52":158,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":159,"_18":160},{"_39":77,"_13":78,"_42":79,"_44":45,"_46":47,"_48":80,"_50":51,"_52":155,"_17":54,"_55":24,"_56":82,"_58":59,"_60":-5,"_110":156,"_18":157},{"_39":70,"_13":71,"_42":72,"_44":45,"_46":47,"_48":73,"_50":51,"_52":152,"_17":54,"_55":24,"_56":75,"_58":59,"_60":-5,"_110":153,"_18":154},{"_39":62,"_13":63,"_42":64,"_44":45,"_46":47,"_48":65,"_50":51,"_52":149,"_17":54,"_55":67,"_56":68,"_58":59,"_60":-5,"_110":150,"_18":151},{"_39":40,"_13":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":146,"_17":54,"_55":24,"_56":57,"_58":59,"_60":-5,"_110":147,"_18":148},["D",1748677726919],[],[19,41],["D",1748677735620],[],[19,63],["D",1748677681103],[],[19,71],["D",1748677687392],[],[19,78],["D",1748677922884],[161],[19,85],{"_39":162,"_13":163,"_42":164,"_44":86,"_46":47,"_48":87,"_50":51,"_52":165,"_17":54,"_55":67,"_56":166,"_58":59,"_60":-5,"_110":167,"_18":168},"23b639c8-3df4-11f0-b1d3-76b3cceeab13","Home.tsx","23b63a7c-3df4-11f0-b1d3-76b3cceeab13",["D",1748677922884],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport PropertyCard from \"../components/PropertyCard.tsx\";\nimport SearchFilters from \"../components/SearchFilters.tsx\";\nimport type { PropertyListing, SearchFilters as SearchFiltersType } from \"../../shared/types.ts\";\nimport { formatNaira } from \"../../shared/utils.ts\";\n\ninterface HomeProps {\n navigate: (route: any, data?: any) => void;\n showAuth: (mode: 'login' | 'register') => void;\n}\n\nexport default function Home({ navigate, showAuth }: HomeProps) {\n const [featuredListings, setFeaturedListings] = useState([]);\n const [recentListings, setRecentListings] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [searchQuery, setSearchQuery] = useState('');\n\n useEffect(() => {\n loadInitialData();\n }, []);\n\n const loadInitialData = async () => {\n try {\n // Check if we have initial data from server\n const initialData = (window as any).__INITIAL_DATA__;\n if (initialData?.featuredListings && initialData?.recentListings) {\n setFeaturedListings(initialData.featuredListings);\n setRecentListings(initialData.recentListings);\n setIsLoading(false);\n return;\n }\n\n // Fetch data from API\n const [featuredResponse, recentResponse] = await Promise.all([\n fetch('/api/listings/featured?limit=6'),\n fetch('/api/listings?limit=8')\n ]);\n\n const [featuredData, recentData] = await Promise.all([\n featuredResponse.json(),\n recentResponse.json()\n ]);\n\n if (featuredData.success) {\n setFeaturedListings(featuredData.data);\n }\n\n if (recentData.success) {\n setRecentListings(recentData.data.data);\n }\n } catch (error) {\n console.error('Error loading initial data:', error);\n } finally {\n setIsLoading(false);\n }\n };\n\n const handleSearch = (filters: SearchFiltersType) => {\n // Navigate to browse page with filters\n navigate('browse', { filters });\n };\n\n const handleQuickSearch = () => {\n if (searchQuery.trim()) {\n navigate('browse', { search: searchQuery.trim() });\n } else {\n navigate('browse');\n }\n };\n\n const stats = [\n { label: 'Active Listings', value: '500+', icon: 'home' },\n { label: 'Happy Tenants', value: '1,200+', icon: 'users' },\n { label: 'Verified Agents', value: '50+', icon: 'shield-check' },\n { label: 'Locations Covered', value: '12+', icon: 'map-pin' },\n ];\n\n const features = [\n {\n icon: 'search',\n title: 'Smart Search',\n description: 'Find properties that match your exact requirements with our advanced search filters.'\n },\n {\n icon: 'shield-check',\n title: 'Verified Listings',\n description: 'All properties are verified by our team to ensure quality and authenticity.'\n },\n {\n icon: 'message-circle',\n title: 'Direct Communication',\n description: 'Chat directly with property agents and schedule inspections seamlessly.'\n },\n {\n icon: 'heart',\n title: 'Save Favorites',\n description: 'Save properties you love and get notified about similar listings.'\n },\n ];\n\n return (\n

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

\n Find Your Perfect Home in{' '}\n Enugu\n

\n Discover quality rental properties across GRA, New Haven, Independence Layout, and more. \n Your dream home is just a click away.\n

\n\n {/* Quick Search */}\n

\n \n setSearchQuery(e.target.value)}\n onKeyPress={(e) => e.key === 'Enter' && handleQuickSearch()}\n className=\"w-full pl-12 pr-4 py-4 text-gray-900 rounded-lg border-0 focus:ring-2 focus:ring-yellow-400 text-lg\"\n />\n

\n \n Search Properties\n \n

\n\n {/* CTA Buttons */}\n

\n navigate('browse')}\n className=\"bg-white text-green-600 font-semibold px-8 py-3 rounded-lg hover:bg-gray-100 transition-colors duration-200\"\n >\n Browse All Properties\n \n showAuth('register')}\n className=\"bg-transparent border-2 border-white text-white font-semibold px-8 py-3 rounded-lg hover:bg-white hover:text-green-600 transition-colors duration-200\"\n >\n List Your Property\n \n

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

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

\n \n

{stat.value}

{stat.label}

\n ))}\n

\n\n {/* Featured Properties */}\n

\n Featured Properties\n

\n Handpicked premium properties that offer the best value and amenities in Enugu.\n

\n\n {isLoading ? (\n

\n {[...Array(6)].map((_, index) => (\n

\n ))}\n

\n ) : (\n

\n {featuredListings.map((listing) => (\n navigate('property', listing)}\n onSave={() => {}} // Will implement save functionality\n isSaved={false}\n />\n ))}\n

\n )}\n\n

\n navigate('browse')}\n className=\"btn-primary px-8 py-3\"\n >\n View All Properties\n \n

\n\n {/* Search Filters Section */}\n

\n Find Your Perfect Match\n

\n Use our advanced filters to find properties that meet your specific needs and budget.\n

\n\n \n

\n\n {/* Recent Properties */}\n

\n Recently Added\n

\n Fresh listings from verified agents across Enugu.\n

\n\n {isLoading ? (\n

\n {[...Array(8)].map((_, index) => (\n

\n ))}\n

\n ) : (\n

\n {recentListings.map((listing) => (\n navigate('property', listing)}\n onSave={() => {}}\n isSaved={false}\n compact={true}\n />\n ))}\n

\n )}\n

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

\n Why Choose Enugu Rents?\n

\n We make finding and renting properties in Enugu simple, secure, and stress-free.\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 New Home?\n

\n Join thousands of satisfied tenants who found their perfect home through Enugu Rents.\n

\n navigate('browse')}\n className=\"bg-white text-green-600 font-semibold px-8 py-3 rounded-lg hover:bg-gray-100 transition-colors duration-200\"\n >\n Start Browsing\n \n showAuth('register')}\n className=\"bg-transparent border-2 border-white text-white font-semibold px-8 py-3 rounded-lg hover:bg-white hover:text-green-600 transition-colors duration-200\"\n >\n Create Account\n \n

\n );\n}",[],[19,85,163],["D",1748677769223],[172,173,174],[19,92],{"_39":191,"_13":192,"_42":193,"_44":93,"_46":47,"_48":94,"_50":51,"_52":194,"_17":54,"_55":67,"_56":195,"_58":59,"_60":-5,"_110":196,"_18":197},{"_39":183,"_13":184,"_42":185,"_44":93,"_46":47,"_48":186,"_50":51,"_52":187,"_17":54,"_55":67,"_56":188,"_58":59,"_60":-5,"_110":189,"_18":190},{"_39":175,"_13":176,"_42":177,"_44":93,"_46":47,"_48":178,"_50":51,"_52":179,"_17":54,"_55":67,"_56":180,"_58":59,"_60":-5,"_110":181,"_18":182},"eedbbd22-3df3-11f0-8881-76b3cceeab13","Header.tsx","eedbbef8-3df3-11f0-8881-76b3cceeab13",19,["D",1748677834214],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User } from \"../../shared/types.ts\";\n\ninterface HeaderProps {\n user: User | null;\n navigate: (route: any, data?: any) => void;\n showAuth: (mode: 'login' | 'register') => void;\n onLogout: () => void;\n currentRoute: string;\n}\n\nexport default function Header({ user, navigate, showAuth, onLogout, currentRoute }: HeaderProps) {\n const [isMobileMenuOpen, setIsMobileMenuOpen] = useState(false);\n const [isUserMenuOpen, setIsUserMenuOpen] = useState(false);\n\n const navItems = [\n { label: 'Home', route: 'home', path: '/' },\n { label: 'Browse', route: 'browse', path: '/browse' },\n { label: 'About', route: 'about', path: '/about' },\n { label: 'Contact', route: 'contact', path: '/contact' },\n { label: 'FAQ', route: 'faq', path: '/faq' },\n ];\n\n const handleNavClick = (route: string) => {\n navigate(route as any);\n setIsMobileMenuOpen(false);\n };\n\n const handleUserMenuClick = () => {\n setIsUserMenuOpen(!isUserMenuOpen);\n };\n\n const handleLogout = () => {\n onLogout();\n setIsUserMenuOpen(false);\n };\n\n return (\n

\n {/* Logo */}\n

\n handleNavClick('home')}\n className=\"flex items-center space-x-2 text-xl font-bold text-gray-900 hover:text-green-600 transition-colors duration-200\"\n >\n

\n \n

\n Enugu Rents\n \n

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

\n {user ? (\n

\n \n

\n {user.name}\n \n \n\n {/* User Dropdown */}\n {isUserMenuOpen && (\n

\n {\n handleNavClick('dashboard');\n setIsUserMenuOpen(false);\n }}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-50 transition-colors duration-200\"\n >\n \n Dashboard\n \n {\n handleNavClick('dashboard');\n setIsUserMenuOpen(false);\n }}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-50 transition-colors duration-200\"\n >\n \n Saved Properties\n \n {\n handleNavClick('dashboard');\n setIsUserMenuOpen(false);\n }}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-50 transition-colors duration-200\"\n >\n \n Settings\n \n

\n \n \n Logout\n \n

\n )}\n

\n ) : (\n

\n showAuth('login')}\n className=\"text-sm font-medium text-gray-700 hover:text-green-600 transition-colors duration-200\"\n >\n Login\n \n showAuth('register')}\n className=\"btn-primary text-sm\"\n >\n Sign Up\n \n

\n )}\n

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

\n setIsMobileMenuOpen(!isMobileMenuOpen)}\n className=\"text-gray-700 hover:text-green-600 transition-colors duration-200\"\n >\n \n \n

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

\n {navItems.map((item) => (\n handleNavClick(item.route)}\n className={`text-left text-sm font-medium transition-colors duration-200 ${\n currentRoute === item.route\n ? 'text-green-600'\n : 'text-gray-700 hover:text-green-600'\n }`}\n >\n {item.label}\n \n ))}\n \n {/* Mobile User Menu */}\n {user ? (\n

\n \n

\n {user.name}\n

\n handleNavClick('dashboard')}\n className=\"block w-full text-left text-sm text-gray-700 hover:text-green-600 transition-colors duration-200 mb-2\"\n >\n \n Dashboard\n \n \n \n Logout\n \n

\n ) : (\n

\n showAuth('login')}\n className=\"text-left text-sm font-medium text-gray-700 hover:text-green-600 transition-colors duration-200\"\n >\n Login\n \n showAuth('register')}\n className=\"btn-primary text-sm w-full\"\n >\n Sign Up\n \n

\n )}\n

\n\n {/* Click outside to close user menu */}\n {isUserMenuOpen && (\n setIsUserMenuOpen(false)}\n >\n )}\n

\n );\n}",[],[19,92,176],"02111ebe-3df4-11f0-bf43-76b3cceeab13","Footer.tsx","02111f4a-3df4-11f0-bf43-76b3cceeab13",20,["D",1748677866441],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\n\ninterface FooterProps {\n navigate: (route: any) => void;\n}\n\nexport default function Footer({ navigate }: FooterProps) {\n const currentYear = new Date().getFullYear();\n\n const quickLinks = [\n { label: 'Home', route: 'home' },\n { label: 'Browse Properties', route: 'browse' },\n { label: 'About Us', route: 'about' },\n { label: 'Contact', route: 'contact' },\n { label: 'FAQ', route: 'faq' },\n ];\n\n const locations = [\n 'GRA',\n 'New Haven',\n 'Independence Layout',\n 'Trans-Ekulu',\n 'Uwani',\n 'Abakpa',\n ];\n\n const propertyTypes = [\n 'Apartments',\n 'Houses',\n 'Duplexes',\n 'Bungalows',\n 'Commercial',\n 'Shared Apartments',\n ];\n\n return (\n \n );\n}",[],[19,92,184],"c81f00b8-3df3-11f0-85ca-76b3cceeab13","App.tsx","c81f0158-3df3-11f0-85ca-76b3cceeab13",["D",1748677769223],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport Header from \"./Header.tsx\";\nimport Footer from \"./Footer.tsx\";\nimport ChatWidget from \"./ChatWidget.tsx\";\nimport Home from \"../pages/Home.tsx\";\nimport Browse from \"../pages/Browse.tsx\";\nimport About from \"../pages/About.tsx\";\nimport Contact from \"../pages/Contact.tsx\";\nimport FAQ from \"../pages/FAQ.tsx\";\nimport Dashboard from \"../pages/Dashboard.tsx\";\nimport PropertyDetail from \"./PropertyDetail.tsx\";\nimport AuthModal from \"./Auth/AuthModal.tsx\";\nimport type { User, PropertyListing } from \"../../shared/types.ts\";\n\n// Simple router implementation\ntype Route = 'home' | 'browse' | 'about' | 'contact' | 'faq' | 'dashboard' | 'property';\n\ninterface AppState {\n currentRoute: Route;\n currentUser: User | null;\n showAuthModal: boolean;\n authMode: 'login' | 'register';\n currentListing: PropertyListing | null;\n isLoading: boolean;\n}\n\nexport default function App() {\n const [state, setState] = useState({\n currentRoute: 'home',\n currentUser: null,\n showAuthModal: false,\n authMode: 'login',\n currentListing: null,\n isLoading: true\n });\n\n // Initialize app and check authentication\n useEffect(() => {\n initializeApp();\n setupRouting();\n }, []);\n\n const initializeApp = async () => {\n try {\n // Check if user is already authenticated\n const response = await fetch('/api/auth/me', {\n credentials: 'include'\n });\n \n if (response.ok) {\n const data = await response.json();\n if (data.success && data.user) {\n setState(prev => ({ ...prev, currentUser: data.user }));\n }\n }\n } catch (error) {\n console.error('Failed to check authentication:', error);\n } finally {\n setState(prev => ({ ...prev, isLoading: false }));\n }\n };\n\n const setupRouting = () => {\n // Simple client-side routing\n const path = window.location.pathname;\n let route: Route = 'home';\n let listingId: number | null = null;\n\n if (path === '/browse') {\n route = 'browse';\n } else if (path === '/about') {\n route = 'about';\n } else if (path === '/contact') {\n route = 'contact';\n } else if (path === '/faq') {\n route = 'faq';\n } else if (path === '/dashboard') {\n route = 'dashboard';\n } else if (path.startsWith('/listing/')) {\n route = 'property';\n const id = parseInt(path.split('/')[2]);\n if (!isNaN(id)) {\n listingId = id;\n loadPropertyDetails(id);\n }\n }\n\n setState(prev => ({ ...prev, currentRoute: route }));\n\n // Handle browser back/forward\n window.addEventListener('popstate', () => {\n setupRouting();\n });\n };\n\n const loadPropertyDetails = async (id: number) => {\n try {\n setState(prev => ({ ...prev, isLoading: true }));\n \n // Check if we have initial data\n const initialData = (window as any).__INITIAL_DATA__;\n if (initialData?.currentListing?.id === id) {\n setState(prev => ({ \n ...prev, \n currentListing: initialData.currentListing,\n isLoading: false \n }));\n return;\n }\n\n const response = await fetch(`/api/listings/${id}`);\n const data = await response.json();\n \n if (data.success) {\n setState(prev => ({ \n ...prev, \n currentListing: data.data,\n isLoading: false \n }));\n } else {\n console.error('Failed to load property:', data.message);\n setState(prev => ({ ...prev, isLoading: false }));\n }\n } catch (error) {\n console.error('Error loading property:', error);\n setState(prev => ({ ...prev, isLoading: false }));\n }\n };\n\n const navigate = (route: Route, data?: any) => {\n let path = '/';\n \n switch (route) {\n case 'browse':\n path = '/browse';\n break;\n case 'about':\n path = '/about';\n break;\n case 'contact':\n path = '/contact';\n break;\n case 'faq':\n path = '/faq';\n break;\n case 'dashboard':\n path = '/dashboard';\n break;\n case 'property':\n if (data?.id) {\n path = `/listing/${data.id}`;\n setState(prev => ({ ...prev, currentListing: data }));\n }\n break;\n }\n\n window.history.pushState({}, '', path);\n setState(prev => ({ ...prev, currentRoute: route }));\n };\n\n const showAuth = (mode: 'login' | 'register' = 'login') => {\n setState(prev => ({ \n ...prev, \n showAuthModal: true, \n authMode: mode \n }));\n };\n\n const hideAuth = () => {\n setState(prev => ({ ...prev, showAuthModal: false }));\n };\n\n const handleAuthSuccess = (user: User) => {\n setState(prev => ({ \n ...prev, \n currentUser: user, \n showAuthModal: false \n }));\n \n // Show success message\n if ((window as any).EnuguRents?.showToast) {\n (window as any).EnuguRents.showToast('Welcome to Enugu Rents!', 'success');\n }\n };\n\n const handleLogout = async () => {\n try {\n await fetch('/api/auth/logout', {\n method: 'POST',\n credentials: 'include'\n });\n \n setState(prev => ({ ...prev, currentUser: null }));\n \n if ((window as any).EnuguRents?.showToast) {\n (window as any).EnuguRents.showToast('Logged out successfully', 'success');\n }\n \n // Redirect to home if on dashboard\n if (state.currentRoute === 'dashboard') {\n navigate('home');\n }\n } catch (error) {\n console.error('Logout error:', error);\n }\n };\n\n const renderCurrentPage = () => {\n if (state.isLoading) {\n return (\n

\n );\n }\n\n switch (state.currentRoute) {\n case 'browse':\n return ;\n case 'about':\n return ;\n case 'contact':\n return ;\n case 'faq':\n return ;\n case 'dashboard':\n if (!state.currentUser) {\n showAuth('login');\n return ;\n }\n return ;\n case 'property':\n if (!state.currentListing) {\n return (\n

Property Not Found

The property you're looking for doesn't exist or has been removed.

\n navigate('browse')}\n className=\"btn-primary\"\n >\n Browse Properties\n \n

\n );\n }\n return (\n \n );\n default:\n return ;\n }\n };\n\n return (\n

\n \n

\n {renderCurrentPage()}\n

\n \n

\n );\n}",[],[19,92,192],"6c6a5070-3df2-11f0-a26b-76b3cceeab13","backend","3c52c2ce-281f-4c49-83f8-b9d2695a823c",4,["D",1748677185868],[205,206,207],[199],{"_39":251,"_13":252,"_42":253,"_44":200,"_46":47,"_48":201,"_50":51,"_52":254,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":255,"_18":256},{"_39":218,"_13":219,"_42":220,"_44":200,"_46":47,"_48":221,"_50":51,"_52":222,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":223,"_18":224},{"_39":208,"_13":209,"_42":210,"_44":200,"_46":47,"_48":211,"_50":51,"_52":212,"_17":125,"_55":213,"_56":214,"_58":59,"_60":215,"_110":216,"_18":217},"d349b406-3df3-11f0-92bc-76b3cceeab13","index.ts","79b7b0aa-3df3-11f0-9a07-76b3cceeab13",18,["D",1748677787957],"http","// Main backend entry point for Enugu Rents\n\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\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// 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",[],[199,209],"36430db0-3df3-11f0-8ab3-76b3cceeab13","routes","c47297f0-e210-40b5-aa47-ff7f724b397b",7,["D",1748677524511],[225,226,227],[199,219],{"_39":244,"_13":245,"_42":246,"_44":220,"_46":47,"_48":221,"_50":51,"_52":247,"_17":54,"_55":67,"_56":248,"_58":59,"_60":-5,"_110":249,"_18":250},{"_39":236,"_13":237,"_42":238,"_44":220,"_46":47,"_48":239,"_50":51,"_52":240,"_17":54,"_55":67,"_56":241,"_58":59,"_60":-5,"_110":242,"_18":243},{"_39":228,"_13":229,"_42":230,"_44":220,"_46":47,"_48":231,"_50":51,"_52":232,"_17":54,"_55":67,"_56":233,"_58":59,"_60":-5,"_110":234,"_18":235},"679d0578-3df3-11f0-9b6e-76b3cceeab13","static.ts","679d062c-3df3-11f0-9b6e-76b3cceeab13",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;",[],[199,219,229],"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;",[],[199,219,237],"3642f424-3df3-11f0-8ab3-76b3cceeab13","auth.ts","3642f4c4-3df3-11f0-8ab3-76b3cceeab13",["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;",[],[199,219,245],"6c6a521e-3df2-11f0-a26b-76b3cceeab13","database","7ade9417-6732-4cfa-a418-7bcd50dde1a4",["D",1748677185868],[257,258],[199,252],{"_39":267,"_13":268,"_42":269,"_44":253,"_46":47,"_48":201,"_50":51,"_52":270,"_17":54,"_55":67,"_56":271,"_58":59,"_60":-5,"_110":272,"_18":273},{"_39":259,"_13":260,"_42":261,"_44":253,"_46":47,"_48":262,"_50":51,"_52":263,"_17":107,"_55":67,"_56":264,"_58":59,"_60":-5,"_110":265,"_18":266},"1d0f402a-3df3-11f0-98ac-76b3cceeab13","queries.ts","85b2f38e-3df2-11f0-8e23-76b3cceeab13",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}",[],[199,252,260],"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}",[],[199,252,268],"262621b6-3df2-11f0-bc6a-76b3cceeab13",["D",1748677067986],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","9f231b20-245a-11f0-8dad-2dee4ee35618","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","180d29bb-29b4-41f4-a984-6297ecbf663d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_326":322},"org",{"_11":12,"_320":-5,"_321":322,"_283":284,"_323":324,"_325":59},"branch",{"_17":87,"_13":16,"_39":47,"_312":274,"_313":-5,"_314":-5,"_315":-5,"_316":-5,"_317":-5,"_318":14,"_319":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd010SXRiaEJnVE9NcW5sOTJ4c1poV0x5YnIifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_39":274,"_13":14,"_52":440,"_276":-5,"_277":59,"_278":279,"_280":279,"_281":-5,"_282":-5,"_283":284,"_285":210,"_286":51,"_287":51,"_288":-5,"_289":54,"_290":291,"_292":-5,"_293":-5,"_294":-5,"_295":-5,"_296":297,"_298":297,"_299":300,"_301":300,"_302":300,"_303":297,"_304":297,"_305":441,"_307":442,"_309":443,"_311":59},[368,377,388,391],"files",[368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391],"counts",{"_359":54,"_360":107,"_361":54,"_32":362,"_363":364},[347,348,349,350,351,352],{"_39":97,"_13":19,"_42":45,"_44":-5,"_46":47,"_48":73,"_50":51,"_52":98,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_18":346},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_39":91,"_13":92,"_42":93,"_44":45,"_46":47,"_48":94,"_50":51,"_52":95,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_18":358},{"_39":84,"_13":85,"_42":86,"_44":45,"_46":47,"_48":87,"_50":51,"_52":88,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_18":357},{"_39":77,"_13":78,"_42":79,"_44":45,"_46":47,"_48":80,"_50":51,"_52":81,"_17":54,"_55":24,"_56":82,"_58":59,"_60":-5,"_18":356},{"_39":70,"_13":71,"_42":72,"_44":45,"_46":47,"_48":73,"_50":51,"_52":74,"_17":54,"_55":24,"_56":75,"_58":59,"_60":-5,"_18":355},{"_39":62,"_13":63,"_42":64,"_44":45,"_46":47,"_48":65,"_50":51,"_52":66,"_17":54,"_55":67,"_56":68,"_58":59,"_60":-5,"_18":354},{"_39":40,"_13":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_17":54,"_55":24,"_56":57,"_58":59,"_60":-5,"_18":353},[19,41],[19,63],[19,71],[19,78],[19,85],[19,92],"pulls","branches","forks",{"_365":54,"_367":54},"connections",{"_365":54,"_366":54},"count","unfilledCount","emptyCount",{"_39":198,"_13":199,"_42":200,"_44":-5,"_46":47,"_48":201,"_50":51,"_52":202,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":438,"_18":439},{"_39":251,"_13":252,"_42":253,"_44":200,"_46":47,"_48":201,"_50":51,"_52":254,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":436,"_18":437},{"_39":267,"_13":268,"_42":269,"_44":253,"_46":47,"_48":201,"_50":51,"_52":270,"_17":54,"_55":67,"_56":271,"_58":59,"_60":-5,"_110":434,"_18":435},{"_39":259,"_13":260,"_42":261,"_44":253,"_46":47,"_48":262,"_50":51,"_52":263,"_17":107,"_55":67,"_56":264,"_58":59,"_60":-5,"_110":432,"_18":433},{"_39":218,"_13":219,"_42":220,"_44":200,"_46":47,"_48":221,"_50":51,"_52":222,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":430,"_18":431},{"_39":244,"_13":245,"_42":246,"_44":220,"_46":47,"_48":221,"_50":51,"_52":247,"_17":54,"_55":67,"_56":248,"_58":59,"_60":-5,"_110":428,"_18":429},{"_39":236,"_13":237,"_42":238,"_44":220,"_46":47,"_48":239,"_50":51,"_52":240,"_17":54,"_55":67,"_56":241,"_58":59,"_60":-5,"_110":426,"_18":427},{"_39":228,"_13":229,"_42":230,"_44":220,"_46":47,"_48":231,"_50":51,"_52":232,"_17":54,"_55":67,"_56":233,"_58":59,"_60":-5,"_110":424,"_18":425},{"_39":208,"_13":209,"_42":210,"_44":200,"_46":47,"_48":211,"_50":51,"_52":212,"_17":125,"_55":213,"_56":214,"_58":59,"_60":215,"_110":422,"_18":423},{"_39":97,"_13":19,"_42":45,"_44":-5,"_46":47,"_48":73,"_50":51,"_52":137,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":420,"_18":421},{"_39":91,"_13":92,"_42":93,"_44":45,"_46":47,"_48":94,"_50":51,"_52":169,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":418,"_18":419},{"_39":191,"_13":192,"_42":193,"_44":93,"_46":47,"_48":94,"_50":51,"_52":194,"_17":54,"_55":67,"_56":195,"_58":59,"_60":-5,"_110":416,"_18":417},{"_39":183,"_13":184,"_42":185,"_44":93,"_46":47,"_48":186,"_50":51,"_52":187,"_17":54,"_55":67,"_56":188,"_58":59,"_60":-5,"_110":414,"_18":415},{"_39":175,"_13":176,"_42":177,"_44":93,"_46":47,"_48":178,"_50":51,"_52":179,"_17":54,"_55":67,"_56":180,"_58":59,"_60":-5,"_110":412,"_18":413},{"_39":84,"_13":85,"_42":86,"_44":45,"_46":47,"_48":87,"_50":51,"_52":158,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":410,"_18":411},{"_39":162,"_13":163,"_42":164,"_44":86,"_46":47,"_48":87,"_50":51,"_52":165,"_17":54,"_55":67,"_56":166,"_58":59,"_60":-5,"_110":408,"_18":409},{"_39":77,"_13":78,"_42":79,"_44":45,"_46":47,"_48":80,"_50":51,"_52":155,"_17":54,"_55":24,"_56":82,"_58":59,"_60":-5,"_110":406,"_18":407},{"_39":70,"_13":71,"_42":72,"_44":45,"_46":47,"_48":73,"_50":51,"_52":152,"_17":54,"_55":24,"_56":75,"_58":59,"_60":-5,"_110":404,"_18":405},{"_39":62,"_13":63,"_42":64,"_44":45,"_46":47,"_48":65,"_50":51,"_52":149,"_17":54,"_55":67,"_56":68,"_58":59,"_60":-5,"_110":402,"_18":403},{"_39":40,"_13":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":146,"_17":54,"_55":24,"_56":57,"_58":59,"_60":-5,"_110":400,"_18":401},{"_39":113,"_13":114,"_42":115,"_44":-5,"_46":47,"_48":116,"_50":51,"_52":117,"_17":54,"_55":89,"_56":-5,"_58":59,"_60":-5,"_110":398,"_18":399},{"_39":130,"_13":131,"_42":132,"_44":115,"_46":47,"_48":116,"_50":51,"_52":133,"_17":54,"_55":67,"_56":134,"_58":59,"_60":-5,"_110":396,"_18":397},{"_39":122,"_13":123,"_42":124,"_44":115,"_46":47,"_48":125,"_50":51,"_52":126,"_17":54,"_55":67,"_56":127,"_58":59,"_60":-5,"_110":394,"_18":395},{"_39":104,"_13":105,"_42":106,"_44":-5,"_46":47,"_48":107,"_50":51,"_52":108,"_17":54,"_55":24,"_56":109,"_58":59,"_60":-5,"_110":392,"_18":393},[],[105],[],[114,123],[],[114,131],[389,390],[114],[],[19,41],[],[19,63],[],[19,71],[],[19,78],[],[19,85,163],[383],[19,85],[],[19,92,176],[],[19,92,184],[],[19,92,192],[379,380,381],[19,92],[378,382,384,385,386,387],[19],[],[199,209],[],[199,219,229],[],[199,219,237],[],[199,219,245],[373,374,375],[199,219],[],[199,252,260],[],[199,252,268],[370,371],[199,252],[369,372,376],[199],["D",1748677067986],{"_11":12,"_326":322},{"_11":12,"_320":-5,"_321":322,"_283":284,"_323":324,"_325":59},{"_17":87,"_13":16,"_39":47,"_312":274,"_313":-5,"_314":-5,"_315":-5,"_316":-5,"_317":-5,"_318":14,"_319":12},"ctx",{"_305":-5,"_343":477,"_478":479,"_480":481,"_482":59,"_483":59,"_484":59,"_485":51,"_486":-5,"_487":-7,"_488":-7,"_489":54,"_490":59,"_491":59,"_492":-5,"_493":59,"_494":59,"_495":59,"_496":-5},"ENV",{"_448":449,"_450":451,"_452":16,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]