Eagle Majdes Homes and Services - Premium Real Estate Development

\n \n \n \n\n",[],[146,203],"9146b482-3f97-11f0-bfb2-76b3cceeab13",["D",1748858065834],[],[146,32],["D",1748858059004],[173,174],[146],"872915da-3f97-11f0-a526-76b3cceeab13","index.ts",6,["D",1748858048864],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { \n createUser, \n getUserById, \n getUserByEmail,\n createProperty,\n getPropertiesByGarden,\n getAvailableProperties,\n createPayment,\n updatePaymentStatus,\n createBooking,\n addUserInterest,\n removeUserInterest,\n saveChatMessage,\n getChatMessages\n} from \"./database/queries.ts\";\nimport { GARDENS_DATA, CONTACT_INFO } from \"../shared/types.ts\";\nimport { generateId, validateEmail, validatePhone } from \"../shared/utils.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\n// Comment out after first run for better performance\nawait runMigrations();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main page with initial data injection\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial data to avoid extra round-trips\n const initialData = {\n gardens: GARDENS_DATA,\n contact: CONTACT_INFO,\n featuredGardens: GARDENS_DATA.filter(g => g.featured)\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes\n\n// Get all gardens\napp.get(\"/api/gardens\", c => {\n return c.json(GARDENS_DATA);\n});\n\n// Get specific garden\napp.get(\"/api/gardens/:id\", c => {\n const gardenId = c.req.param(\"id\");\n const garden = GARDENS_DATA.find(g => g.id === gardenId);\n \n if (!garden) {\n return c.json({ error: \"Garden not found\" }, 404);\n }\n \n return c.json(garden);\n});\n\n// Get properties for a garden\napp.get(\"/api/gardens/:id/properties\", async c => {\n const gardenId = c.req.param(\"id\");\n const properties = await getPropertiesByGarden(gardenId);\n return c.json(properties);\n});\n\n// Get all available properties\napp.get(\"/api/properties\", async c => {\n const properties = await getAvailableProperties();\n return c.json(properties);\n});\n\n// User registration/login\napp.post(\"/api/users\", async c => {\n const body = await c.req.json();\n const { name, email, phone } = body;\n \n if (!name || !email || !phone) {\n return c.json({ error: \"Name, email, and phone are required\" }, 400);\n }\n \n if (!validateEmail(email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n \n if (!validatePhone(phone)) {\n return c.json({ error: \"Invalid phone format\" }, 400);\n }\n \n // Check if user already exists\n const existingUser = await getUserByEmail(email);\n if (existingUser) {\n return c.json(existingUser);\n }\n \n // Create new user\n const userId = generateId();\n const user = await createUser({\n id: userId,\n name,\n email,\n phone\n });\n \n return c.json(user, 201);\n});\n\n// Get user by ID\napp.get(\"/api/users/:id\", async c => {\n const userId = c.req.param(\"id\");\n const user = await getUserById(userId);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n return c.json(user);\n});\n\n// Add user interest\napp.post(\"/api/users/:id/interests\", async c => {\n const userId = c.req.param(\"id\");\n const { gardenId } = await c.req.json();\n \n if (!gardenId) {\n return c.json({ error: \"Garden ID is required\" }, 400);\n }\n \n await addUserInterest(userId, gardenId);\n return c.json({ success: true });\n});\n\n// Remove user interest\napp.delete(\"/api/users/:id/interests/:gardenId\", async c => {\n const userId = c.req.param(\"id\");\n const gardenId = c.req.param(\"gardenId\");\n \n await removeUserInterest(userId, gardenId);\n return c.json({ success: true });\n});\n\n// Create booking\napp.post(\"/api/bookings\", async c => {\n const body = await c.req.json();\n const { userId, propertyId, notes } = body;\n \n if (!userId || !propertyId) {\n return c.json({ error: \"User ID and Property ID are required\" }, 400);\n }\n \n const booking = await createBooking({\n id: generateId(),\n userId,\n propertyId,\n status: 'pending',\n createdAt: new Date().toISOString(),\n notes\n });\n \n return c.json(booking, 201);\n});\n\n// Create payment\napp.post(\"/api/payments\", async c => {\n const body = await c.req.json();\n const { userId, propertyId, amount, paymentMethod } = body;\n \n if (!userId || !propertyId || !amount || !paymentMethod) {\n return c.json({ error: \"All payment fields are required\" }, 400);\n }\n \n const payment = await createPayment({\n id: generateId(),\n userId,\n propertyId,\n amount,\n currency: 'NGN',\n status: 'pending',\n paymentMethod,\n createdAt: new Date().toISOString()\n });\n \n return c.json(payment, 201);\n});\n\n// Update payment status (webhook endpoint)\napp.post(\"/api/payments/:id/status\", async c => {\n const paymentId = c.req.param(\"id\");\n const { status } = await c.req.json();\n \n if (!['pending', 'completed', 'failed'].includes(status)) {\n return c.json({ error: \"Invalid status\" }, 400);\n }\n \n await updatePaymentStatus(paymentId, status);\n return c.json({ success: true });\n});\n\n// Chat endpoints\napp.post(\"/api/chat\", async c => {\n const body = await c.req.json();\n const { message, sessionId } = body;\n \n if (!message || !sessionId) {\n return c.json({ error: \"Message and session ID are required\" }, 400);\n }\n \n // Save user message\n const userMessage = await saveChatMessage({\n message,\n sender: 'user',\n timestamp: sessionId\n });\n \n // Auto-reply for demo (in production, this would integrate with a real chat system)\n const autoReply = \"Thank you for your message! Our support team will get back to you shortly. For immediate assistance, please call us at 08164878281.\";\n \n const supportMessage = await saveChatMessage({\n message: autoReply,\n sender: 'support',\n timestamp: sessionId\n });\n \n return c.json([userMessage, supportMessage]);\n});\n\napp.get(\"/api/chat/:sessionId\", async c => {\n const sessionId = c.req.param(\"sessionId\");\n const messages = await getChatMessages(sessionId);\n return c.json(messages);\n});\n\n// Contact info endpoint\napp.get(\"/api/contact\", c => {\n return c.json(CONTACT_INFO);\n});\n\n// Health check\napp.get(\"/api/health\", c => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\nexport default app;",[],[152,217],"74e24c2a-3f97-11f0-bcad-76b3cceeab13","queries.ts","74e24d6a-3f97-11f0-bcad-76b3cceeab13","f40c1e4f-74be-4df9-b2fe-9577187f3cfe",5,["D",1748858018202],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { User, Property, Payment, Booking, ChatMessage } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (id, name, email, phone) VALUES (?, ?, ?, ?)`,\n [user.id, user.name, user.email, user.phone]\n );\n \n return {\n ...user,\n interests: [],\n payments: [],\n bookings: []\n };\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE id = ?`,\n [id]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n const interests = await getUserInterests(id);\n const payments = await getUserPayments(id);\n const bookings = await getUserBookings(id);\n \n return {\n id: user.id,\n name: user.name,\n email: user.email,\n phone: user.phone,\n interests,\n payments,\n bookings\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE email = ?`,\n [email]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n return getUserById(user.id);\n}\n\n// Property queries\nexport async function createProperty(property: Property): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.PROPERTIES} \n (id, garden_id, plot_number, size, price, status, description, coordinates_lat, coordinates_lng) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n property.id,\n property.gardenId,\n property.plotNumber,\n property.size,\n property.price,\n property.status,\n property.description,\n property.coordinates?.lat || null,\n property.coordinates?.lng || null\n ]\n );\n \n return property;\n}\n\nexport async function getPropertiesByGarden(gardenId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PROPERTIES} WHERE garden_id = ? ORDER BY plot_number`,\n [gardenId]\n );\n \n return result.map(row => ({\n id: row.id,\n gardenId: row.garden_id,\n plotNumber: row.plot_number,\n size: row.size,\n price: row.price,\n status: row.status as Property['status'],\n description: row.description,\n coordinates: row.coordinates_lat && row.coordinates_lng ? {\n lat: row.coordinates_lat,\n lng: row.coordinates_lng\n } : undefined\n }));\n}\n\nexport async function getAvailableProperties(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PROPERTIES} WHERE status = 'available' ORDER BY garden_id, plot_number`\n );\n \n return result.map(row => ({\n id: row.id,\n gardenId: row.garden_id,\n plotNumber: row.plot_number,\n size: row.size,\n price: row.price,\n status: row.status as Property['status'],\n description: row.description,\n coordinates: row.coordinates_lat && row.coordinates_lng ? {\n lat: row.coordinates_lat,\n lng: row.coordinates_lng\n } : undefined\n }));\n}\n\n// Payment queries\nexport async function createPayment(payment: Payment): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.PAYMENTS} \n (id, user_id, property_id, amount, currency, status, payment_method, reference) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n payment.id,\n payment.userId,\n payment.propertyId,\n payment.amount,\n payment.currency,\n payment.status,\n payment.paymentMethod,\n payment.id // Using payment ID as reference for now\n ]\n );\n \n return payment;\n}\n\nexport async function updatePaymentStatus(paymentId: string, status: Payment['status']): Promise {\n const completedAt = status === 'completed' ? new Date().toISOString() : null;\n \n await sqlite.execute(\n `UPDATE ${TABLES.PAYMENTS} SET status = ?, completed_at = ? WHERE id = ?`,\n [status, completedAt, paymentId]\n );\n}\n\nexport async function getUserPayments(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.PAYMENTS} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n propertyId: row.property_id,\n amount: row.amount,\n currency: row.currency,\n status: row.status as Payment['status'],\n paymentMethod: row.payment_method,\n createdAt: row.created_at,\n completedAt: row.completed_at\n }));\n}\n\n// Booking queries\nexport async function createBooking(booking: Booking): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.BOOKINGS} (id, user_id, property_id, status, notes) \n VALUES (?, ?, ?, ?, ?)`,\n [booking.id, booking.userId, booking.propertyId, booking.status, booking.notes]\n );\n \n return booking;\n}\n\nexport async function getUserBookings(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.BOOKINGS} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.map(row => ({\n id: row.id,\n userId: row.user_id,\n propertyId: row.property_id,\n status: row.status as Booking['status'],\n createdAt: row.created_at,\n notes: row.notes\n }));\n}\n\n// Interest queries\nexport async function addUserInterest(userId: string, gardenId: string): Promise {\n const interestId = Math.random().toString(36).substr(2, 9);\n \n await sqlite.execute(\n `INSERT OR IGNORE INTO ${TABLES.INTERESTS} (id, user_id, garden_id) VALUES (?, ?, ?)`,\n [interestId, userId, gardenId]\n );\n}\n\nexport async function removeUserInterest(userId: string, gardenId: string): Promise {\n await sqlite.execute(\n `DELETE FROM ${TABLES.INTERESTS} WHERE user_id = ? AND garden_id = ?`,\n [userId, gardenId]\n );\n}\n\nexport async function getUserInterests(userId: string): Promise {\n const result = await sqlite.execute(\n `SELECT garden_id FROM ${TABLES.INTERESTS} WHERE user_id = ?`,\n [userId]\n );\n \n return result.map(row => row.garden_id);\n}\n\n// Chat queries\nexport async function saveChatMessage(message: Omit): Promise {\n const id = Math.random().toString(36).substr(2, 9);\n \n await sqlite.execute(\n `INSERT INTO ${TABLES.CHAT_MESSAGES} (id, session_id, message, sender) VALUES (?, ?, ?, ?)`,\n [id, message.timestamp, message.message, message.sender] // Using timestamp as session_id for simplicity\n );\n \n return { ...message, id };\n}\n\nexport async function getChatMessages(sessionId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.CHAT_MESSAGES} WHERE session_id = ? ORDER BY created_at ASC`,\n [sessionId]\n );\n \n return result.map(row => ({\n id: row.id,\n message: row.message,\n sender: row.sender as ChatMessage['sender'],\n timestamp: row.created_at\n }));\n}",[],[152,232,224],"database","644f50f6-3f97-11f0-9634-76b3cceeab13","migrations.ts","644f5344-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database table names with versioning for schema changes\nexport const TABLES = {\n USERS: 'eagle_majdes_users_v1',\n PROPERTIES: 'eagle_majdes_properties_v1',\n PAYMENTS: 'eagle_majdes_payments_v1',\n BOOKINGS: 'eagle_majdes_bookings_v1',\n INTERESTS: 'eagle_majdes_interests_v1',\n CHAT_MESSAGES: 'eagle_majdes_chat_messages_v1'\n};\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.USERS} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n phone TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Properties table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PROPERTIES} (\n id TEXT PRIMARY KEY,\n garden_id TEXT NOT NULL,\n plot_number TEXT NOT NULL,\n size TEXT NOT NULL,\n price INTEGER NOT NULL,\n status TEXT DEFAULT 'available' CHECK (status IN ('available', 'reserved', 'sold')),\n description TEXT,\n coordinates_lat REAL,\n coordinates_lng REAL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Payments table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PAYMENTS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n property_id TEXT NOT NULL,\n amount INTEGER NOT NULL,\n currency TEXT DEFAULT 'NGN',\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'completed', 'failed')),\n payment_method TEXT,\n reference TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n completed_at DATETIME,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (property_id) REFERENCES ${TABLES.PROPERTIES}(id)\n )\n `);\n\n // Bookings table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.BOOKINGS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n property_id TEXT NOT NULL,\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'cancelled')),\n notes TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (property_id) REFERENCES ${TABLES.PROPERTIES}(id)\n )\n `);\n\n // User interests table (many-to-many relationship)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.INTERESTS} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n garden_id TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n UNIQUE(user_id, garden_id)\n )\n `);\n\n // Chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.CHAT_MESSAGES} (\n id TEXT PRIMARY KEY,\n session_id TEXT NOT NULL,\n message TEXT NOT NULL,\n sender TEXT NOT NULL CHECK (sender IN ('user', 'support')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed successfully');\n}",[],[152,232,234],"644f6078-3f97-11f0-9634-76b3cceeab13",["D",1748857990392],[169,170],[152,232],["D",1748857990392],[168,171],[152],["D",1748856998657],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"ctx",{"_76":-5,"_121":284,"_285":286,"_287":288,"_289":24,"_290":24,"_291":24,"_292":56,"_293":-5,"_294":-7,"_295":-7,"_296":60,"_297":24,"_298":24,"_299":-5,"_300":24,"_301":24,"_302":24,"_303":-5},"ENV",{"_255":256,"_257":258,"_259":84,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","899124c68db8496248a17ee95f074b807335ea7b","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v8