Promise Luxury — Kenya's Premier Luxury Booking Platform

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_274":275,"_276":277},"routes/_app.x.$handle.$name",{"_110":109,"_37":50,"_118":96,"_32":119,"_13":14,"_120":-5,"_11":121,"_122":123,"_124":125,"_126":127,"_128":129,"_26":-5,"_130":131,"_132":133,"_134":30,"_135":136,"_137":65,"_138":-5,"_139":-5,"_140":141},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":60,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":30},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5620ba45-fba8-4799-911e-c795c45b7a21","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/components/Navbar.tsx","latestPath","fileId","02aa4e22-811e-11f1-8008-1607ee4eb77e","name","Navbar.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport type { User, Settings } from \"./App.tsx\";\n\nexport function Navbar({ user, settings, navigate, onLogout }: {\n user: User | null;\n settings: Settings | null;\n navigate: (path: string) => void;\n onLogout: () => void;\n}) {\n const linkClass = \"text-gray-700 hover:text-amber-600 cursor-pointer transition-colors font-medium\";\n\n return (\n

navigate(\"/\")}>\n 🏨\n \n {settings?.company_name || \"Promise Luxury\"}\n \n

\n navigate(\"/\")}>Home\n navigate(\"/listings\")}>Listings\n navigate(\"/about\")}>About\n navigate(\"/contact\")}>Contact\n {user ? (\n <>\n navigate(\"/dashboard\")}>My Dashboard\n Logout\n \n ) : (\n <>\n navigate(\"/login\")}>Login\n navigate(\"/register\")}>\n Sign Up\n \n \n )}\n

\n \n

navigate(\"/\")}>Home

navigate(\"/listings\")}>Listings

navigate(\"/about\")}>About

navigate(\"/contact\")}>Contact

\n {user ? (\n <>\n

navigate(\"/dashboard\")}>My Dashboard

Logout

\n \n ) : (\n <>\n

navigate(\"/login\")}>Login

navigate(\"/register\")}>Sign Up

\n \n )}\n

\n );\n}\n","createdAt",["D",1784210131879],"branchVersion","branchId","827741f1-f985-4e4e-993d-9c3cead1a367","id","fabf4cca-35d8-4e47-9b54-1715c5277af7","promise-luxury",["D",1784209850342],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Kenya luxury booking platform with customer & admin dashboards","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789549199&sig=78a5bc27f03474c98a49b09a954e18cc6dd63f22ba19ce3e096717a88d3522b5","6b71ea3a-ecc6-4d2b-923b-f7a069e6f0e3","pinnedFileId","019f6b31-c02d-73ee-96f7-d143daf1b77c","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f6ae1-cdd4-762c-a4db-de889f147efc","tursoName","fabf4cca35d84e479b541715c5277af7","tursoHostname","fabf4cca35d84e479b541715c5277af7-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_110":109,"_117":113},"org",{"_110":109,"_111":109,"_112":113,"_19":61,"_114":115,"_116":30},"branch",{"_13":95,"_37":96,"_48":47,"_97":49,"_98":99,"_100":101,"_102":55,"_103":104,"_105":106,"_107":50,"_108":109},"isOwned",34,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",89,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","weruuweru","handle","displayName","avatar","https://avatars.githubusercontent.com/u/305836342?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":269,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":60,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":270,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":271,"_90":272,"_92":273,"_94":30},"tree",[197,205,206,207],"files",[197,198,199,200,201,202,203,204,205,206,207],"counts",{"_187":69,"_188":163,"_189":69,"_190":191,"_192":193},"contents",[153,154,155,156],"upstreamProject",{"_48":104,"_37":149,"_57":150,"_59":60,"_54":55,"_88":151},"upstreamBranch",{"_48":99,"_43":142,"_143":144,"_37":96,"_97":104,"_13":145,"_98":-5,"_100":-5,"_146":147,"_52":-5,"_94":30,"_54":55,"_108":148,"_70":106,"_107":149},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","Starter template with client-side React & Hono server",{"_110":148,"_117":152},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789549199&sig=85ec03bbe2ae9af315fa5e89fceebe840b59020b3ec43df39e2ab37ef0d215ad",{"_48":181,"_37":182,"_35":183,"_159":-5,"_46":47,"_45":163,"_161":65,"_43":184,"_13":69,"_39":185,"_41":-5,"_29":30,"_166":-5,"_32":186},{"_48":175,"_37":176,"_35":177,"_159":-5,"_46":47,"_45":163,"_161":65,"_43":178,"_13":69,"_39":26,"_41":179,"_29":30,"_166":-5,"_32":180},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":171,"_161":65,"_43":172,"_13":69,"_39":40,"_41":173,"_29":30,"_166":-5,"_32":174},{"_48":157,"_37":158,"_35":63,"_159":-5,"_46":47,"_45":160,"_161":65,"_43":162,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_32":167},"ae5f19a3-793e-4ca2-83f9-16cd146ee0e1","index.ts","parentId",3,"latest",["D",1784210080100],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { createHash } from \"node:crypto\";\nimport { initDB, getSettings } from \"./db.ts\";\n\nconst app = new Hono();\n\n// Initialize DB on first load\nawait initDB();\n\n// ============ AUTH HELPERS ============\nfunction hashPassword(pw: string): string {\n return createHash(\"sha256\").update(pw).digest(\"hex\");\n}\n\nfunction makeToken(userId: number, role: string): string {\n return btoa(`${userId}:${role}:${Date.now()}`);\n}\n\nfunction parseToken(token: string): { userId: number; role: string } | null {\n try {\n const decoded = atob(token);\n const [userId, role] = decoded.split(\":\");\n return { userId: parseInt(userId), role };\n } catch {\n return null;\n }\n}\n\nfunction getAuth(c: any): { userId: number; role: string } | null {\n const token = c.req.header(\"Authorization\")?.replace(\"Bearer \", \"\");\n if (!token) return null;\n return parseToken(token);\n}\n\nfunction requireAdmin(c: any): { userId: number; role: string } | null {\n const auth = getAuth(c);\n if (!auth || auth.role !== \"admin\") return null;\n return auth;\n}\n\nfunction requireAuth(c: any): { userId: number; role: string } | null {\n return getAuth(c);\n}\n\n// ============ STATIC FILES ============\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ============ PUBLIC API ============\napp.get(\"/api/settings\", async (c) => {\n const settings = await getSettings();\n return c.json(settings);\n});\n\napp.get(\"/api/listings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const category = c.req.query(\"category\");\n const search = c.req.query(\"search\");\n let sql = \"SELECT * FROM listings WHERE status = 'active'\";\n const args: any[] = [];\n if (category && category !== \"all\") {\n sql += \" AND category = ?\";\n args.push(category);\n }\n if (search) {\n sql += \" AND (title LIKE ? OR description LIKE ? OR location LIKE ?)\";\n args.push(`%${search}%`, `%${search}%`, `%${search}%`);\n }\n sql += \" ORDER BY created_at DESC\";\n const result = await sqlite.execute({ sql, args });\n return c.json({ listings: result.rows });\n});\n\napp.get(\"/api/listings/:id\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const id = c.req.param(\"id\");\n const listing = await sqlite.execute({\n sql: \"SELECT * FROM listings WHERE id = ?\",\n args: [id],\n });\n if (!listing.rows.length) return c.json({ error: \"Not found\" }, 404);\n const reviews = await sqlite.execute({\n sql: \"SELECT r.*, u.name as user_name FROM reviews r JOIN users u ON r.user_id = u.id WHERE r.listing_id = ?\",\n args: [id],\n });\n return c.json({ listing: listing.rows[0], reviews: reviews.rows });\n});\n\napp.get(\"/api/categories\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const result = await sqlite.execute(\n \"SELECT DISTINCT category FROM listings WHERE status = 'active'\",\n );\n return c.json({ categories: result.rows.map((r: any) => r.category) });\n});\n\n// ============ AUTH ROUTES ============\napp.post(\"/api/auth/register\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const body = await c.req.json();\n const { name, email, phone, password } = body;\n if (!name || !email || !password) {\n return c.json({ error: \"Name, email and password are required\" }, 400);\n }\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM users WHERE email = ?\",\n args: [email],\n });\n if (existing.rows.length) {\n return c.json({ error: \"Email already registered\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"INSERT INTO users (name, email, phone, password, role) VALUES (?, ?, ?, ?, 'customer')\",\n args: [name, email, phone || null, hashPassword(password)],\n });\n const userId = result.lastInsertRowid as number;\n const token = makeToken(userId, \"customer\");\n return c.json({\n token,\n user: { id: userId, name, email, phone, role: \"customer\" },\n });\n});\n\napp.post(\"/api/auth/login\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const body = await c.req.json();\n const { email, password } = body;\n const result = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE email = ?\",\n args: [email],\n });\n if (!result.rows.length) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n const user = result.rows[0] as any;\n if (user.password !== hashPassword(password)) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n const token = makeToken(user.id, user.role);\n return c.json({\n token,\n user: {\n id: user.id,\n name: user.name,\n email: user.email,\n phone: user.phone,\n role: user.role,\n },\n });\n});\n\napp.get(\"/api/auth/me\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAuth(c);\n if (!auth) return c.json({ error: \"Unauthorized\" }, 401);\n const result = await sqlite.execute({\n sql: \"SELECT id, name, email, phone, role FROM users WHERE id = ?\",\n args: [auth.userId],\n });\n if (!result.rows.length) return c.json({ error: \"Not found\" }, 404);\n return c.json({ user: result.rows[0] });\n});\n\n// ============ CUSTOMER BOOKINGS ============\napp.post(\"/api/bookings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAuth(c);\n if (!auth) return c.json({ error: \"Please log in\" }, 401);\n const body = await c.req.json();\n const { listing_id, booking_date, guests, payment_method } = body;\n const listing = await sqlite.execute({\n sql: \"SELECT * FROM listings WHERE id = ? AND status = 'active'\",\n args: [listing_id],\n });\n if (!listing.rows.length) return c.json({ error: \"Listing not found\" }, 404);\n const l = listing.rows[0] as any;\n const total = l.price * (guests || 1);\n const result = await sqlite.execute({\n sql: \"INSERT INTO bookings (user_id, listing_id, booking_date, guests, total_amount, status, payment_method, payment_status) VALUES (?, ?, ?, ?, ?, 'pending', ?, 'unpaid')\",\n args: [auth.userId, listing_id, booking_date, guests || 1, total, payment_method || \"mpesa\"],\n });\n const bookingId = result.lastInsertRowid as number;\n // Simulate payment success for demo\n await sqlite.execute({\n sql: \"UPDATE bookings SET payment_status = 'paid', status = 'confirmed' WHERE id = ?\",\n args: [bookingId],\n });\n return c.json({\n booking_id: bookingId,\n status: \"confirmed\",\n total_amount: total,\n message: \"Booking confirmed! Payment received via \" + (payment_method || \"M-Pesa\"),\n });\n});\n\napp.get(\"/api/bookings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAuth(c);\n if (!auth) return c.json({ error: \"Please log in\" }, 401);\n const result = await sqlite.execute({\n sql: `SELECT b.*, l.title as listing_title, l.image_url as listing_image, l.location as listing_location\n FROM bookings b JOIN listings l ON b.listing_id = l.id\n WHERE b.user_id = ? ORDER BY b.created_at DESC`,\n args: [auth.userId],\n });\n return c.json({ bookings: result.rows });\n});\n\napp.post(\"/api/bookings/:id/cancel\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAuth(c);\n if (!auth) return c.json({ error: \"Please log in\" }, 401);\n const id = c.req.param(\"id\");\n await sqlite.execute({\n sql: \"UPDATE bookings SET status = 'cancelled' WHERE id = ? AND user_id = ?\",\n args: [id, auth.userId],\n });\n return c.json({ success: true });\n});\n\n// ============ REVIEWS ============\napp.post(\"/api/reviews\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAuth(c);\n if (!auth) return c.json({ error: \"Please log in\" }, 401);\n const body = await c.req.json();\n const { listing_id, rating, comment } = body;\n await sqlite.execute({\n sql: \"INSERT INTO reviews (listing_id, user_id, rating, comment) VALUES (?, ?, ?, ?)\",\n args: [listing_id, auth.userId, rating, comment],\n });\n return c.json({ success: true });\n});\n\n// ============ ADMIN API ============\n// Admin dashboard stats\napp.get(\"/api/admin/stats\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n if (!requireAdmin(c)) return c.json({ error: \"Admin access required\" }, 403);\n const today = new Date().toISOString().split(\"T\")[0];\n const [bookings, revenue, pending, customers, listings, todayBookings] = await Promise.all([\n sqlite.execute(\"SELECT COUNT(*) as count FROM bookings\"),\n sqlite.execute(\"SELECT COALESCE(SUM(total_amount),0) as total FROM bookings WHERE payment_status = 'paid'\"),\n sqlite.execute(\"SELECT COUNT(*) as count FROM bookings WHERE status = 'pending'\"),\n sqlite.execute(\"SELECT COUNT(*) as count FROM users WHERE role = 'customer'\"),\n sqlite.execute(\"SELECT COUNT(*) as count FROM listings\"),\n sqlite.execute({ sql: \"SELECT COUNT(*) as count FROM bookings WHERE booking_date = ?\", args: [today] }),\n ]);\n return c.json({\n totalBookings: (bookings.rows[0] as any).count,\n totalRevenue: (revenue.rows[0] as any).total,\n pendingPayments: (pending.rows[0] as any).count,\n totalCustomers: (customers.rows[0] as any).count,\n totalListings: (listings.rows[0] as any).count,\n todayBookings: (todayBookings.rows[0] as any).count,\n });\n});\n\n// Admin listings management\napp.get(\"/api/admin/listings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n if (!requireAdmin(c)) return c.json({ error: \"Admin access required\" }, 403);\n const result = await sqlite.execute(\"SELECT * FROM listings ORDER BY created_at DESC\");\n return c.json({ listings: result.rows });\n});\n\napp.post(\"/api/admin/listings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAdmin(c);\n if (!auth) return c.json({ error: \"Admin access required\" }, 403);\n const body = await c.req.json();\n const result = await sqlite.execute({\n sql: \"INSERT INTO listings (title, description, price, category, image_url, capacity, location, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\",\n args: [body.title, body.description, body.price, body.category || \"general\", body.image_url, body.capacity || 2, body.location || \"Nairobi, Kenya\", body.status || \"active\"],\n });\n await sqlite.execute({\n sql: \"INSERT INTO admin_logs (admin_id, action, detail) VALUES (?, 'create_listing', ?)\",\n args: [auth.userId, body.title],\n });\n return c.json({ success: true, id: result.lastInsertRowid });\n});\n\napp.put(\"/api/admin/listings/:id\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAdmin(c);\n if (!auth) return c.json({ error: \"Admin access required\" }, 403);\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE listings SET title=?, description=?, price=?, category=?, image_url=?, capacity=?, location=?, status=? WHERE id=?\",\n args: [body.title, body.description, body.price, body.category, body.image_url, body.capacity, body.location, body.status, id],\n });\n return c.json({ success: true });\n});\n\napp.delete(\"/api/admin/listings/:id\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAdmin(c);\n if (!auth) return c.json({ error: \"Admin access required\" }, 403);\n const id = c.req.param(\"id\");\n await sqlite.execute({ sql: \"DELETE FROM listings WHERE id = ?\", args: [id] });\n await sqlite.execute({\n sql: \"INSERT INTO admin_logs (admin_id, action, detail) VALUES (?, 'delete_listing', ?)\",\n args: [auth.userId, id],\n });\n return c.json({ success: true });\n});\n\n// Admin bookings management\napp.get(\"/api/admin/bookings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n if (!requireAdmin(c)) return c.json({ error: \"Admin access required\" }, 403);\n const result = await sqlite.execute(\n `SELECT b.*, l.title as listing_title, u.name as customer_name, u.email as customer_email, u.phone as customer_phone\n FROM bookings b JOIN listings l ON b.listing_id = l.id JOIN users u ON b.user_id = u.id\n ORDER BY b.created_at DESC`,\n );\n return c.json({ bookings: result.rows });\n});\n\napp.put(\"/api/admin/bookings/:id/status\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAdmin(c);\n if (!auth) return c.json({ error: \"Admin access required\" }, 403);\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE bookings SET status = ? WHERE id = ?\",\n args: [body.status, id],\n });\n await sqlite.execute({\n sql: \"INSERT INTO admin_logs (admin_id, action, detail) VALUES (?, 'update_booking_status', ?)\",\n args: [auth.userId, `Booking #${id} -> ${body.status}`],\n });\n return c.json({ success: true });\n});\n\n// Admin customers\napp.get(\"/api/admin/customers\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n if (!requireAdmin(c)) return c.json({ error: \"Admin access required\" }, 403);\n const result = await sqlite.execute(\n `SELECT u.id, u.name, u.email, u.phone, u.created_at,\n COUNT(b.id) as total_bookings, COALESCE(SUM(b.total_amount),0) as total_spent\n FROM users u LEFT JOIN bookings b ON u.id = b.user_id\n WHERE u.role = 'customer' GROUP BY u.id ORDER BY u.created_at DESC`,\n );\n return c.json({ customers: result.rows });\n});\n\n// Admin settings\napp.put(\"/api/admin/settings\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n const auth = requireAdmin(c);\n if (!auth) return c.json({ error: \"Admin access required\" }, 403);\n const body = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE settings SET\n company_name=?, tagline=?, contact_email=?, contact_phone=?, whatsapp=?,\n address=?, hero_image=?, logo_url=?, primary_color=?, about_text=?,\n facebook=?, instagram=?, twitter=?, mpesa_enabled=?, card_enabled=?,\n updated_at=datetime('now') WHERE id=1`,\n args: [\n body.company_name, body.tagline, body.contact_email, body.contact_phone, body.whatsapp,\n body.address, body.hero_image, body.logo_url, body.primary_color, body.about_text,\n body.facebook, body.instagram, body.twitter, body.mpesa_enabled ? 1 : 0, body.card_enabled ? 1 : 0,\n ],\n });\n await sqlite.execute({\n sql: \"INSERT INTO admin_logs (admin_id, action, detail) VALUES (?, 'update_settings', 'Updated site settings')\",\n args: [auth.userId],\n });\n return c.json({ success: true });\n});\n\n// Admin logs\napp.get(\"/api/admin/logs\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n if (!requireAdmin(c)) return c.json({ error: \"Admin access required\" }, 403);\n const result = await sqlite.execute(\n \"SELECT l.*, u.name as admin_name FROM admin_logs l LEFT JOIN users u ON l.admin_id = u.id ORDER BY l.created_at DESC LIMIT 50\",\n );\n return c.json({ logs: result.rows });\n});\n\n// Admin revenue chart data\napp.get(\"/api/admin/revenue\", async (c) => {\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite/main.ts\");\n if (!requireAdmin(c)) return c.json({ error: \"Admin access required\" }, 403);\n const result = await sqlite.execute(\n `SELECT DATE(created_at) as date, SUM(total_amount) as revenue, COUNT(*) as bookings\n FROM bookings WHERE payment_status = 'paid'\n GROUP BY DATE(created_at) ORDER BY date DESC LIMIT 30`,\n );\n return c.json({ data: result.rows });\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","label",[158],"f2d7a860-029e-43fd-ac54-53eb03a8a18e","db.ts","c343a03a-811d-11f1-b481-1607ee4eb77e",2,["D",1784210025491],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDB() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n phone TEXT,\n password TEXT NOT NULL,\n role TEXT DEFAULT 'customer',\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS settings (\n id INTEGER PRIMARY KEY DEFAULT 1,\n company_name TEXT DEFAULT 'Promise Luxury',\n tagline TEXT DEFAULT 'Experience Luxury in Kenya',\n contact_email TEXT DEFAULT 'info@promiseluxury.co.ke',\n contact_phone TEXT DEFAULT '+254700000000',\n whatsapp TEXT DEFAULT '+254700000000',\n address TEXT DEFAULT 'Nairobi, Kenya',\n hero_image TEXT DEFAULT 'https://images.unsplash.com/photo-1564501049412-61c2a3083791?w=1200',\n logo_url TEXT DEFAULT '',\n primary_color TEXT DEFAULT '#b8860b',\n about_text TEXT DEFAULT 'Promise Luxury is Kenya''s premier luxury booking platform, offering curated experiences across the country.',\n facebook TEXT DEFAULT '',\n instagram TEXT DEFAULT '',\n twitter TEXT DEFAULT '',\n mpesa_enabled INTEGER DEFAULT 1,\n card_enabled INTEGER DEFAULT 1,\n updated_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS listings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n price REAL NOT NULL,\n category TEXT DEFAULT 'general',\n image_url TEXT DEFAULT 'https://images.unsplash.com/photo-1582719478250-c89cae4dc85b?w=800',\n gallery TEXT DEFAULT '[]',\n status TEXT DEFAULT 'active',\n capacity INTEGER DEFAULT 2,\n location TEXT DEFAULT 'Nairobi, Kenya',\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS bookings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n listing_id INTEGER NOT NULL,\n booking_date TEXT NOT NULL,\n guests INTEGER DEFAULT 1,\n total_amount REAL NOT NULL,\n status TEXT DEFAULT 'pending',\n payment_method TEXT DEFAULT '',\n payment_status TEXT DEFAULT 'unpaid',\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (user_id) REFERENCES users(id),\n FOREIGN KEY (listing_id) REFERENCES listings(id)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS reviews (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n listing_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n rating INTEGER NOT NULL,\n comment TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (listing_id) REFERENCES listings(id),\n FOREIGN KEY (user_id) REFERENCES users(id)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS admin_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n admin_id INTEGER,\n action TEXT NOT NULL,\n detail TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n // Seed default admin\n {\n sql: `INSERT OR IGNORE INTO users (id, name, email, phone, password, role) VALUES (1, 'Admin', 'admin@promiseluxury.co.ke', '+254700000000', 'admin123', 'admin')`,\n },\n // Seed default settings row\n {\n sql: `INSERT OR IGNORE INTO settings (id) VALUES (1)`,\n },\n // Seed sample listings\n {\n sql: `INSERT OR IGNORE INTO listings (id, title, description, price, category, image_url, capacity, location) VALUES\n (1, 'Maasai Mara Luxury Safari', 'Experience the wild like never before. 3-day luxury safari with premium tented camps, gourmet dining, and expert guides.', 85000, 'Safari', 'https://images.unsplash.com/photo-1516426122078-c2317674d2b3?w=800', 6, 'Maasai Mara, Kenya'),\n (2, 'Diani Beach Villa Retreat', 'Private beachfront villa with infinity pool, personal chef, and daily housekeeping. Sleeps up to 8 guests.', 120000, 'Beach', 'https://images.unsplash.com/photo-1519046904884-53103b34b206?w=800', 8, 'Diani Beach, Kenya'),\n (3, 'Mount Kenya Helicopter Tour', 'Scenic helicopter flight over Mount Kenya with champagne picnic at the base. A once-in-a-lifetime experience.', 45000, 'Adventure', 'https://images.unsplash.com/photo-1464822759023-fed622ff2c3d?w=800', 4, 'Mount Kenya, Kenya'),\n (4, 'Nairobi Luxury Penthouse', '5-star penthouse suite in Westlands with city views, jacuzzi, and concierge service. Perfect for business or leisure.', 35000, 'Accommodation', 'https://images.unsplash.com/photo-1566073771259-6a8506099948?w=800', 4, 'Nairobi, Kenya'),\n (5, 'Lamu Island Yacht Charter', 'Private yacht charter around the Lamu archipelago. Snorkeling, fishing, and sunset dinners included.', 200000, 'Yacht', 'https://images.unsplash.com/photo-1546577962-5f0625c5a8b1?w=800', 10, 'Lamu, Kenya'),\n (6, 'Amboseli Elephant Safari', '2-day luxury safari in Amboseli with views of Kilimanjaro. Luxury lodge accommodation and game drives.', 65000, 'Safari', 'https://images.unsplash.com/photo-1549366057-5b7fb5d44c6e?w=800', 6, 'Amboseli, Kenya')`,\n },\n // Seed sample reviews\n {\n sql: `INSERT OR IGNORE INTO reviews (id, listing_id, user_id, rating, comment) VALUES\n (1, 1, 1, 5, 'Absolutely incredible experience! The guides were knowledgeable and the camps were luxurious.'),\n (2, 2, 1, 5, 'Best beach vacation ever. The private chef was a game changer.')`,\n },\n ]);\n}\n\nexport function rowToObj(row: Record): Record {\n return row;\n}\n\nexport async function getSettings() {\n const result = await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\");\n return result.rows[0] ?? {};\n}\n",[169],"c2dc17b6-e51b-4b59-b778-c8be00998cf9","README.md","019f6b31-c02d-73ee-96f7-cf2010151530",["D",1784209850342],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n",[176],"9daa81ff-2465-4374-8775-8b4627f84cfd","frontend","019f6b31-c02d-73ee-96f7-c84ac42958c4",["D",1784209850342],"directory",[182],"pulls","branches","forks","envVars",{"_194":69,"_196":69},"connections",{"_194":69,"_195":69},"count","unfilledCount","emptyCount",{"_48":181,"_37":182,"_35":183,"_159":-5,"_46":47,"_45":163,"_161":65,"_43":266,"_13":69,"_39":185,"_41":-5,"_29":30,"_166":-5,"_209":267,"_32":268},{"_48":262,"_37":246,"_35":242,"_159":183,"_46":47,"_45":163,"_161":65,"_43":263,"_13":69,"_39":185,"_41":-5,"_29":30,"_166":-5,"_209":264,"_32":265},{"_48":254,"_37":255,"_35":256,"_159":242,"_46":47,"_45":257,"_161":30,"_43":258,"_13":163,"_39":40,"_41":259,"_29":30,"_166":-5,"_209":260,"_32":261},{"_48":247,"_37":248,"_35":249,"_159":242,"_46":47,"_45":163,"_161":30,"_43":250,"_13":69,"_39":40,"_41":251,"_29":30,"_166":-5,"_209":252,"_32":253},{"_48":241,"_37":38,"_35":36,"_159":242,"_46":47,"_45":14,"_161":65,"_43":243,"_13":69,"_39":40,"_41":42,"_29":30,"_166":-5,"_209":244,"_32":245},{"_48":233,"_37":234,"_35":235,"_159":183,"_46":47,"_45":236,"_161":65,"_43":237,"_13":163,"_39":26,"_41":238,"_29":30,"_166":-5,"_209":239,"_32":240},{"_48":225,"_37":226,"_35":227,"_159":183,"_46":47,"_45":228,"_161":30,"_43":229,"_13":163,"_39":26,"_41":230,"_29":30,"_166":-5,"_209":231,"_32":232},{"_48":218,"_37":219,"_35":220,"_159":183,"_46":47,"_45":163,"_161":65,"_43":221,"_13":69,"_39":40,"_41":222,"_29":30,"_166":-5,"_209":223,"_32":224},{"_48":175,"_37":176,"_35":177,"_159":-5,"_46":47,"_45":163,"_161":65,"_43":215,"_13":69,"_39":26,"_41":179,"_29":30,"_166":-5,"_209":216,"_32":217},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":171,"_161":65,"_43":212,"_13":69,"_39":40,"_41":173,"_29":30,"_166":-5,"_209":213,"_32":214},{"_48":157,"_37":158,"_35":63,"_159":-5,"_46":47,"_45":160,"_161":65,"_43":208,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_209":210,"_32":211},["D",1784210080100],"children",[],[158],["D",1784210025491],[],[169],["D",1784209850342],[],[176],"34ebc707-f4a6-43ee-b4b8-60360f67bb14","index.tsx","019f6b31-c02d-73ee-96f7-c70f4902b8f0",["D",1784209850342],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[182,219],"c6c5da1e-08ca-46fc-8e35-640c4e4e60ae","index.html","019f6b31-c02d-73ee-96f7-c0378305c52d",5,["D",1784210089390],"\n\n \n \n \n Promise Luxury — Kenya's Premier Luxury Booking Platform\n \n \n \n \n \n

\n \n \n \n\n",[],[182,226],"12dc12eb-6902-48df-9b3a-ddca7d9797ae","favicon.svg","019f6b31-c02d-73ee-96f7-bfad34e7207a",4,["D",1784210089389],"\n\n",[],[182,234],"8e752db4-3138-44b3-9e91-6d7ec802cd6a","019f6b31-c02d-73ee-96f7-ba5c7f1b1e87",["D",1784210131879],[],[182,246,38],"components","022c3a91-0d62-4332-adc0-3aef339df8db","Counter.tsx","019f6b31-c02d-73ee-96f7-b716b6dacabb",["D",1784209850342],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[182,246,248],"92eded6f-609e-4f87-949b-561cc1de8525","App.tsx","019f6b31-c02c-7268-bf81-f7d3551f41f9",6,["D",1784210113818],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { Navbar } from \"./Navbar.tsx\";\nimport { Footer } from \"./Footer.tsx\";\nimport { Home } from \"./pages/Home.tsx\";\nimport { Listings } from \"./pages/Listings.tsx\";\nimport { ListingDetail } from \"./pages/ListingDetail.tsx\";\nimport { Login } from \"./pages/Login.tsx\";\nimport { Register } from \"./pages/Register.tsx\";\nimport { CustomerDashboard } from \"./pages/CustomerDashboard.tsx\";\nimport { About } from \"./pages/About.tsx\";\nimport { Contact } from \"./pages/Contact.tsx\";\nimport { AdminLogin } from \"./pages/admin/AdminLogin.tsx\";\nimport { AdminDashboard } from \"./pages/admin/AdminDashboard.tsx\";\nimport { AdminListings } from \"./pages/admin/AdminListings.tsx\";\nimport { AdminBookings } from \"./pages/admin/AdminBookings.tsx\";\nimport { AdminCustomers } from \"./pages/admin/AdminCustomers.tsx\";\nimport { AdminSettings } from \"./pages/admin/AdminSettings.tsx\";\n\nexport interface User {\n id: number;\n name: string;\n email: string;\n phone: string;\n role: string;\n}\n\nexport interface Settings {\n company_name: string;\n tagline: string;\n contact_email: string;\n contact_phone: string;\n whatsapp: string;\n address: string;\n hero_image: string;\n logo_url: string;\n primary_color: string;\n about_text: string;\n facebook: string;\n instagram: string;\n twitter: string;\n mpesa_enabled: number;\n card_enabled: number;\n}\n\nfunction parseHash(): { route: string; params: Record } {\n const hash = window.location.hash.slice(1) || \"/\";\n const [path, queryStr] = hash.split(\"?\");\n const params: Record = {};\n if (queryStr) {\n queryStr.split(\"&\").forEach((p) => {\n const [k, v] = p.split(\"=\");\n params[k] = decodeURIComponent(v || \"\");\n });\n }\n return { route: path, params };\n}\n\nexport function App() {\n const [user, setUser] = useState(null);\n const [settings, setSettings] = useState(null);\n const [routeInfo, setRouteInfo] = useState(parseHash());\n const [loading, setLoading] = useState(true);\n\n const api = useCallback(async (path: string, opts: RequestInit = {}) => {\n const token = localStorage.getItem(\"pl_token\");\n const headers: Record = {\n \"Content-Type\": \"application/json\",\n ...(opts.headers as Record || {}),\n };\n if (token) headers[\"Authorization\"] = `Bearer ${token}`;\n const res = await fetch(path, { ...opts, headers });\n return res.json();\n }, []);\n\n useEffect(() => {\n // Load settings\n api(\"/api/settings\").then((s) => setSettings(s));\n // Check if logged in\n const token = localStorage.getItem(\"pl_token\");\n if (token) {\n api(\"/api/auth/me\").then((data) => {\n if (data.user) setUser(data.user);\n else localStorage.removeItem(\"pl_token\");\n setLoading(false);\n });\n } else {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n const handler = () => setRouteInfo(parseHash());\n window.addEventListener(\"hashchange\", handler);\n return () => window.removeEventListener(\"hashchange\", handler);\n }, []);\n\n const navigate = (path: string) => {\n window.location.hash = path;\n window.scrollTo(0, 0);\n };\n\n const login = (token: string, u: User) => {\n localStorage.setItem(\"pl_token\", token);\n setUser(u);\n };\n\n const logout = () => {\n localStorage.removeItem(\"pl_token\");\n setUser(null);\n navigate(\"/\");\n };\n\n if (loading) {\n return (\n

Loading Promise Luxury…

\n );\n }\n\n const { route, params } = routeInfo;\n\n // Admin routes\n if (route.startsWith(\"/admin\")) {\n if (route === \"/admin/login\") {\n return ;\n }\n if (!user || user.role !== \"admin\") {\n navigate(\"/admin/login\");\n return null;\n }\n return (\n

\n {route === \"/admin\" && }\n {route === \"/admin/listings\" && }\n {route === \"/admin/bookings\" && }\n {route === \"/admin/customers\" && }\n {route === \"/admin/settings\" && }\n

\n );\n }\n\n // Public/customer routes\n return (\n

\n \n

\n {route === \"/\" && }\n {route === \"/listings\" && }\n {route === \"/listing\" && }\n {route === \"/login\" && }\n {route === \"/register\" && }\n {route === \"/dashboard\" && }\n {route === \"/about\" && }\n {route === \"/contact\" && }\n

\n );\n}\n",[],[182,246,255],"e3b32691-0b32-4747-84d1-859e3e88a88d",["D",1784209850342],[199,200,201],[182,246],["D",1784209850342],[198,202,203,204],[182],["D",1784209850342],["D",1789472446807],{"_110":109,"_117":113},{"_110":109,"_111":109,"_112":113,"_19":61,"_114":115,"_116":30},{"_13":95,"_37":96,"_48":47,"_97":49,"_98":99,"_100":101,"_102":55,"_103":104,"_105":106,"_107":50,"_108":109},"ctx",{"_88":-5,"_139":307,"_308":309,"_310":311,"_312":30,"_313":30,"_314":30,"_315":65,"_316":-5,"_317":-7,"_318":-7,"_319":69,"_320":30,"_321":30,"_322":-5,"_323":30,"_324":30,"_325":30,"_326":-5},"ENV",{"_278":279,"_280":281,"_282":96,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v7