\n \n \n \n\n",[18,67],"a691deac-411c-11f1-86e8-42b51c65c3df",["D",1777172673457],[18,81],"pulls","branches",1,"forks","envVars",{"_198":26,"_200":26},"connections",{"_198":26,"_199":26},"count","unfilledCount","emptyCount",{"_35":327,"_13":318,"_65":312,"_45":-5,"_37":38,"_169":192,"_171":24,"_39":328,"_41":26,"_68":82,"_173":-5,"_69":30,"_174":-5,"_224":329,"_17":330},{"_35":319,"_13":320,"_65":321,"_45":312,"_37":38,"_169":322,"_171":24,"_39":323,"_41":26,"_68":92,"_173":324,"_69":30,"_174":-5,"_224":325,"_17":326},{"_35":309,"_13":310,"_65":311,"_45":312,"_37":38,"_169":313,"_171":24,"_39":314,"_41":26,"_68":92,"_173":315,"_69":30,"_174":-5,"_224":316,"_17":317},{"_35":168,"_13":18,"_65":93,"_45":-5,"_37":38,"_169":170,"_171":24,"_39":306,"_41":26,"_68":82,"_173":-5,"_69":30,"_174":-5,"_224":307,"_17":308},{"_35":187,"_13":81,"_65":80,"_45":93,"_37":38,"_169":75,"_171":24,"_39":303,"_41":26,"_68":82,"_173":-5,"_69":30,"_174":-5,"_224":304,"_17":305},{"_35":295,"_13":296,"_65":297,"_45":80,"_37":38,"_169":298,"_171":24,"_39":299,"_41":26,"_68":92,"_173":300,"_69":30,"_174":-5,"_224":301,"_17":302},{"_35":287,"_13":288,"_65":289,"_45":80,"_37":38,"_169":290,"_171":24,"_39":291,"_41":26,"_68":92,"_173":292,"_69":30,"_174":-5,"_224":293,"_17":294},{"_35":279,"_13":280,"_65":281,"_45":80,"_37":38,"_169":282,"_171":24,"_39":283,"_41":26,"_68":92,"_173":284,"_69":30,"_174":-5,"_224":285,"_17":286},{"_35":271,"_13":272,"_65":273,"_45":80,"_37":38,"_169":274,"_171":24,"_39":275,"_41":26,"_68":92,"_173":276,"_69":30,"_174":-5,"_224":277,"_17":278},{"_35":263,"_13":264,"_65":265,"_45":80,"_37":38,"_169":266,"_171":24,"_39":267,"_41":26,"_68":92,"_173":268,"_69":30,"_174":-5,"_224":269,"_17":270},{"_35":255,"_13":256,"_65":257,"_45":80,"_37":38,"_169":258,"_171":24,"_39":259,"_41":26,"_68":92,"_173":260,"_69":30,"_174":-5,"_224":261,"_17":262},{"_35":183,"_13":67,"_65":66,"_45":93,"_37":38,"_169":42,"_171":24,"_39":252,"_41":26,"_68":21,"_173":185,"_69":30,"_174":-5,"_224":253,"_17":254},{"_35":179,"_13":91,"_65":90,"_45":93,"_37":38,"_169":85,"_171":24,"_39":249,"_41":26,"_68":92,"_173":181,"_69":30,"_174":-5,"_224":250,"_17":251},{"_35":244,"_13":243,"_65":237,"_45":-5,"_37":38,"_169":245,"_171":24,"_39":246,"_41":26,"_68":82,"_173":-5,"_69":30,"_174":-5,"_224":247,"_17":248},{"_35":234,"_13":235,"_65":236,"_45":237,"_37":38,"_169":238,"_171":24,"_39":239,"_41":26,"_68":92,"_173":240,"_69":30,"_174":-5,"_224":241,"_17":242},{"_35":227,"_13":228,"_65":229,"_45":-5,"_37":38,"_169":133,"_171":24,"_39":230,"_41":26,"_68":21,"_173":231,"_69":30,"_174":-5,"_224":232,"_17":233},{"_35":218,"_13":219,"_65":106,"_45":-5,"_37":38,"_169":220,"_171":24,"_39":221,"_41":26,"_68":222,"_173":223,"_69":30,"_174":-5,"_224":225,"_17":226},"a26cbcfc-411c-11f1-843f-42b51c65c3df","main.ts",7,["D",1777172666504],"http","import { Hono } from \"npm:hono\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport {\n createUser, getUserByPhone, getUserById, getAllUsers, getUsersByRole,\n createOrder, getOrdersByStudent, getOrdersByShop, getPendingOrders, getReadyOrders,\n getDeliveringOrders, getAllOrders, updateOrderStatus, getAnalytics,\n} from \"./database/queries.ts\";\nimport { calculateCost } from \"./shared/types.ts\";\nimport type { RegisterPayload, LoginPayload, CreateOrderPayload, AuthSession, OrderStatus } from \"./shared/types.ts\";\n\n// Run migrations on cold start\nlet migrated = false;\nasync function ensureMigrated() {\n if (!migrated) {\n await runMigrations();\n migrated = true;\n }\n}\n\nconst app = new Hono();\n\n// ---- Middleware: ensure DB ----\napp.use(\"*\", async (c, next) => {\n await ensureMigrated();\n await next();\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// ---- Simple password hashing (not bcrypt — lightweight for demo) ----\nasync function hashPassword(password: string): Promise {\n const data = new TextEncoder().encode(password + \"printpal-salt-2024\");\n const hash = await crypto.subtle.digest(\"SHA-256\", data);\n return Array.from(new Uint8Array(hash)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\n// ---- Session helpers (cookie-based JSON token) ----\nfunction getSession(c: any): AuthSession | null {\n const cookie = c.req.header(\"Cookie\") || \"\";\n const match = cookie.match(/pp_session=([^;]+)/);\n if (!match) return null;\n try {\n return JSON.parse(decodeURIComponent(match[1]));\n } catch {\n return null;\n }\n}\n\nfunction setSessionCookie(session: AuthSession): string {\n const val = encodeURIComponent(JSON.stringify(session));\n return `pp_session=${val}; Path=/; HttpOnly; SameSite=Lax; Max-Age=604800`;\n}\n\n// ---- AUTH API ----\napp.post(\"/api/register\", async (c) => {\n const body: RegisterPayload = await c.req.json();\n if (!body.name || !body.phone || !body.password) {\n return c.json({ error: \"Name, phone, and password are required\" }, 400);\n }\n const existing = await getUserByPhone(body.phone);\n if (existing) return c.json({ error: \"Phone number already registered\" }, 409);\n\n const hash = await hashPassword(body.password);\n const user = await createUser(body.name, body.phone, body.email || null, body.role || \"student\", hash);\n const session: AuthSession = { userId: user.id, role: user.role, name: user.name };\n\n return c.json({ user: { id: user.id, name: user.name, role: user.role } }, 201, {\n \"Set-Cookie\": setSessionCookie(session),\n });\n});\n\napp.post(\"/api/login\", async (c) => {\n const body: LoginPayload = await c.req.json();\n const user = await getUserByPhone(body.phone);\n if (!user) return c.json({ error: \"Invalid credentials\" }, 401);\n\n const hash = await hashPassword(body.password);\n if (hash !== user.password_hash) return c.json({ error: \"Invalid credentials\" }, 401);\n\n const session: AuthSession = { userId: user.id, role: user.role, name: user.name };\n return c.json({ user: { id: user.id, name: user.name, role: user.role } }, 200, {\n \"Set-Cookie\": setSessionCookie(session),\n });\n});\n\napp.post(\"/api/logout\", (c) => {\n return c.json({ ok: true }, 200, {\n \"Set-Cookie\": \"pp_session=; Path=/; Max-Age=0\",\n });\n});\n\napp.get(\"/api/me\", (c) => {\n const session = getSession(c);\n if (!session) return c.json({ user: null });\n return c.json({ user: session });\n});\n\n// ---- ORDER API ----\napp.post(\"/api/orders\", async (c) => {\n const session = getSession(c);\n if (!session) return c.json({ error: \"Unauthorized\" }, 401);\n\n const body: CreateOrderPayload = await c.req.json();\n if (!body.delivery_location || !body.print_type) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n const pages = body.pages || 1;\n const copies = body.copies || 1;\n const costs = calculateCost(body.print_type, pages, copies);\n\n const order = await createOrder({\n student_id: session.userId,\n file_name: body.file_name || null,\n text_content: body.text_content || null,\n file_blob_key: body.file_blob_key || null,\n print_type: body.print_type,\n copies,\n pages,\n delivery_location: body.delivery_location,\n ...costs,\n notes: body.notes || null,\n });\n\n return c.json({ order }, 201);\n});\n\napp.get(\"/api/orders/my\", async (c) => {\n const session = getSession(c);\n if (!session) return c.json({ error: \"Unauthorized\" }, 401);\n const orders = await getOrdersByStudent(session.userId);\n return c.json({ orders });\n});\n\napp.get(\"/api/orders/pending\", async (c) => {\n const session = getSession(c);\n if (!session || (session.role !== \"shop\" && session.role !== \"admin\")) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n const orders = await getPendingOrders();\n return c.json({ orders });\n});\n\napp.get(\"/api/orders/shop\", async (c) => {\n const session = getSession(c);\n if (!session || session.role !== \"shop\") return c.json({ error: \"Unauthorized\" }, 401);\n const orders = await getOrdersByShop(session.userId);\n return c.json({ orders });\n});\n\napp.get(\"/api/orders/ready\", async (c) => {\n const session = getSession(c);\n if (!session || (session.role !== \"rider\" && session.role !== \"admin\")) {\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n const orders = await getReadyOrders();\n return c.json({ orders });\n});\n\napp.get(\"/api/orders/delivering\", async (c) => {\n const session = getSession(c);\n if (!session || session.role !== \"rider\") return c.json({ error: \"Unauthorized\" }, 401);\n const orders = await getDeliveringOrders(session.userId);\n return c.json({ orders });\n});\n\napp.patch(\"/api/orders/:id/status\", async (c) => {\n const session = getSession(c);\n if (!session) return c.json({ error: \"Unauthorized\" }, 401);\n\n const orderId = parseInt(c.req.param(\"id\"));\n const { status } = await c.req.json() as { status: OrderStatus };\n\n const extra: any = {};\n if (status === \"accepted\" && session.role === \"shop\") extra.shop_id = session.userId;\n if (status === \"delivering\" && session.role === \"rider\") extra.rider_id = session.userId;\n\n const order = await updateOrderStatus(orderId, status, extra);\n return c.json({ order });\n});\n\n// ---- FILE UPLOAD ----\napp.post(\"/api/upload\", async (c) => {\n const session = getSession(c);\n if (!session) return c.json({ error: \"Unauthorized\" }, 401);\n\n const formData = await c.req.formData();\n const file = formData.get(\"file\") as File;\n if (!file) return c.json({ error: \"No file uploaded\" }, 400);\n\n const key = `printpal/${session.userId}/${Date.now()}-${file.name}`;\n const arrayBuffer = await file.arrayBuffer();\n await blob.set(key, new Uint8Array(arrayBuffer));\n\n return c.json({ fileName: file.name, blobKey: key });\n});\n\n// ---- ADMIN API ----\napp.get(\"/api/admin/users\", async (c) => {\n const session = getSession(c);\n if (!session || session.role !== \"admin\") return c.json({ error: \"Unauthorized\" }, 401);\n const users = await getAllUsers();\n return c.json({ users });\n});\n\napp.get(\"/api/admin/orders\", async (c) => {\n const session = getSession(c);\n if (!session || session.role !== \"admin\") return c.json({ error: \"Unauthorized\" }, 401);\n const orders = await getAllOrders();\n return c.json({ orders });\n});\n\napp.get(\"/api/admin/analytics\", async (c) => {\n const session = getSession(c);\n if (!session || session.role !== \"admin\") return c.json({ error: \"Unauthorized\" }, 401);\n const analytics = await getAnalytics();\n return c.json(analytics);\n});\n\napp.get(\"/api/admin/shops\", async (c) => {\n const session = getSession(c);\n if (!session || session.role !== \"admin\") return c.json({ error: \"Unauthorized\" }, 401);\n const shops = await getUsersByRole(\"shop\");\n return c.json({ shops });\n});\n\n// ---- Error handler ----\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[219],"1a85ae6a-411d-11f1-bd37-42b51c65c3df","README.md","1a85af3c-411d-11f1-bd37-42b51c65c3df",["D",1777172867993],"# 🖨️ PrintPal — Campus Printing & Delivery\n\nA full-stack web platform where university students submit print orders, nearby printing shops accept and print them, and delivery riders bring them to students' doors.\n\n**[🔗 Live App](https://beulahh--a26cbd92411c11f1843f42b51c65c3df.web.val.run)**\n\n## Features\n\n### 👩‍🎓 Students\n- Paste text **or** upload files (PDF, DOCX, images)\n- Choose B&W or Color printing\n- Set copies, pages, and delivery location\n- Real-time order status tracking (Pending → Accepted → Printing → Ready → Delivering → Delivered)\n- Live cost breakdown with transparent pricing\n\n### 🏪 Print Shops\n- View incoming orders with full details\n- Accept or reject print requests\n- Progress tracking: Start Printing → Mark Ready for pickup\n\n### 🏍️ Delivery Riders\n- See orders ready for pickup\n- Claim deliveries and mark as delivered\n\n### 👑 Admin Panel\n- Dashboard with total orders, revenue, commission analytics\n- Users by role breakdown + orders by status chart\n- Full orders table and user management\n- Print shop directory\n\n## Architecture\n\n```mermaid\ngraph TB\n subgraph Frontend[\"Frontend (React + Twind)\"]\n Login[Login/Register Screen]\n Student[Student View]\n Shop[Shop Dashboard]\n Rider[Delivery View]\n Admin[Admin Panel]\n end\n\n subgraph Backend[\"Backend (Hono)\"]\n Auth[Auth API]\n OrderAPI[Orders API]\n UploadAPI[File Upload]\n AdminAPI[Admin API]\n end\n\n subgraph Storage\n SQLite[(SQLite DB)]\n Blobs[(Blob Storage)]\n end\n\n Login --> Auth\n Student --> OrderAPI\n Student --> UploadAPI\n Shop --> OrderAPI\n Rider --> OrderAPI\n Admin --> AdminAPI\n\n Auth --> SQLite\n OrderAPI --> SQLite\n UploadAPI --> Blobs\n AdminAPI --> SQLite\n```\n\n## Pricing (GHS)\n\n| Item | Price |\n|------|-------|\n| B&W per page | GHS 0.50 |\n| Color per page | GHS 2.00 |\n| Delivery fee | GHS 3.00 |\n| Platform commission | 15% of print cost |\n\n## Tech Stack\n\n- **Frontend**: React 18, Twind (Tailwind), Font Awesome\n- **Backend**: Hono (TypeScript)\n- **Database**: Val Town SQLite\n- **File Storage**: Val Town Blob Storage\n- **Auth**: Cookie-based sessions with SHA-256 hashing\n\n## User Roles\n\nRegister with any role to explore:\n- **Student** — Submit and track print orders\n- **Shop** — Accept orders and manage printing\n- **Rider** — Pick up and deliver documents\n- **Admin** — Full platform analytics and management\n",[],[228],"80113ed0-411c-11f1-b9cb-42b51c65c3df","types.ts","801140c4-411c-11f1-b9cb-42b51c65c3df","7845c28e-411c-11f1-b9cb-42b51c65c3df",4,["D",1777172608860],"// ---- Enums ----\nexport type UserRole = \"student\" | \"shop\" | \"rider\" | \"admin\";\nexport type PrintType = \"bw\" | \"color\";\nexport type OrderStatus = \"pending\" | \"accepted\" | \"rejected\" | \"printing\" | \"ready\" | \"delivering\" | \"delivered\";\n\n// ---- Users ----\nexport interface User {\n id: number;\n name: string;\n phone: string;\n email: string | null;\n role: UserRole;\n password_hash: string;\n created_at: string;\n}\n\n// ---- Orders ----\nexport interface Order {\n id: number;\n student_id: number;\n shop_id: number | null;\n rider_id: number | null;\n file_name: string | null;\n text_content: string | null;\n file_blob_key: string | null;\n print_type: PrintType;\n copies: number;\n pages: number;\n delivery_location: string;\n status: OrderStatus;\n print_cost: number;\n delivery_fee: number;\n platform_fee: number;\n total_cost: number;\n notes: string | null;\n created_at: string;\n updated_at: string;\n}\n\n// ---- API payloads ----\nexport interface RegisterPayload {\n name: string;\n phone: string;\n email?: string;\n role: UserRole;\n password: string;\n}\n\nexport interface LoginPayload {\n phone: string;\n password: string;\n}\n\nexport interface CreateOrderPayload {\n text_content?: string;\n file_name?: string;\n file_blob_key?: string;\n print_type: PrintType;\n copies: number;\n pages: number;\n delivery_location: string;\n notes?: string;\n}\n\nexport interface AuthSession {\n userId: number;\n role: UserRole;\n name: string;\n}\n\n// ---- Pricing ----\nexport const PRICING = {\n bw_per_page: 0.50, // GHS per page\n color_per_page: 2.00,\n delivery_fee: 3.00,\n platform_commission: 0.15, // 15%\n} as const;\n\nexport function calculateCost(printType: PrintType, pages: number, copies: number) {\n const pricePerPage = printType === \"bw\" ? PRICING.bw_per_page : PRICING.color_per_page;\n const printCost = pricePerPage * pages * copies;\n const deliveryFee = PRICING.delivery_fee;\n const platformFee = Math.round(printCost * PRICING.platform_commission * 100) / 100;\n const totalCost = Math.round((printCost + deliveryFee + platformFee) * 100) / 100;\n return { printCost, deliveryFee, platformFee, totalCost };\n}\n",[],[243,235],"shared","7845c1f8-411c-11f1-b9cb-42b51c65c3df",2,["D",1777172595784],[215],[243],["D",1777172677601],[],[18,91],["D",1777172670162],[],[18,67],"d775d2d0-411c-11f1-9115-42b51c65c3df","StudentView.tsx","d775d384-411c-11f1-9115-42b51c65c3df",13,["D",1777172755445],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst STATUS_COLORS: Record = {\n pending: \"bg-yellow-100 text-yellow-800\",\n accepted: \"bg-blue-100 text-blue-800\",\n rejected: \"bg-red-100 text-red-800\",\n printing: \"bg-purple-100 text-purple-800\",\n ready: \"bg-indigo-100 text-indigo-800\",\n delivering: \"bg-orange-100 text-orange-800\",\n delivered: \"bg-green-100 text-green-800\",\n};\n\nconst STATUS_ICONS: Record = {\n pending: \"fa-clock\",\n accepted: \"fa-thumbs-up\",\n rejected: \"fa-times-circle\",\n printing: \"fa-print\",\n ready: \"fa-box\",\n delivering: \"fa-truck\",\n delivered: \"fa-check-circle\",\n};\n\nconst PRICING = { bw: 0.50, color: 2.00, delivery: 3.00, commission: 0.15 };\n\nexport function StudentView({ userId }: { userId: number }) {\n const [tab, setTab] = useState<\"order\" | \"history\">(\"order\");\n const [orders, setOrders] = useState([]);\n const [loading, setLoading] = useState(false);\n\n // Order form state\n const [inputMode, setInputMode] = useState<\"text\" | \"file\">(\"text\");\n const [textContent, setTextContent] = useState(\"\");\n const [file, setFile] = useState(null);\n const [printType, setPrintType] = useState<\"bw\" | \"color\">(\"bw\");\n const [copies, setCopies] = useState(1);\n const [pages, setPages] = useState(1);\n const [location, setLocation] = useState(\"\");\n const [notes, setNotes] = useState(\"\");\n const [submitting, setSubmitting] = useState(false);\n const [success, setSuccess] = useState(false);\n\n const fetchOrders = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/orders/my\");\n const data = await res.json();\n setOrders(data.orders || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n useEffect(() => { fetchOrders(); }, []);\n\n const pricePerPage = printType === \"bw\" ? PRICING.bw : PRICING.color;\n const printCost = pricePerPage * pages * copies;\n const platformFee = Math.round(printCost * PRICING.commission * 100) / 100;\n const totalCost = printCost + PRICING.delivery + platformFee;\n\n const handleSubmit = async (e: Event) => {\n e.preventDefault();\n setSubmitting(true);\n setSuccess(false);\n\n try {\n let fileName = null;\n let blobKey = null;\n\n if (inputMode === \"file\" && file) {\n const formData = new FormData();\n formData.append(\"file\", file);\n const uploadRes = await fetch(\"/api/upload\", { method: \"POST\", body: formData });\n const uploadData = await uploadRes.json();\n if (!uploadRes.ok) throw new Error(uploadData.error);\n fileName = uploadData.fileName;\n blobKey = uploadData.blobKey;\n }\n\n const res = await fetch(\"/api/orders\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n text_content: inputMode === \"text\" ? textContent : undefined,\n file_name: fileName,\n file_blob_key: blobKey,\n print_type: printType,\n copies,\n pages,\n delivery_location: location,\n notes: notes || undefined,\n }),\n });\n\n const data = await res.json();\n if (!res.ok) throw new Error(data.error);\n\n setSuccess(true);\n setTextContent(\"\");\n setFile(null);\n setCopies(1);\n setPages(1);\n setLocation(\"\");\n setNotes(\"\");\n fetchOrders();\n } catch (err: any) {\n alert(err.message);\n }\n setSubmitting(false);\n };\n\n return (\n

\n {/* Tab nav */}\n

\n setTab(\"order\")}\n class={`flex-1 py-3 rounded-xl font-semibold transition-all ${\n tab === \"order\"\n ? \"bg-blue-600 text-white shadow-lg\"\n : \"bg-white text-gray-600 hover:bg-gray-100\"\n }`}\n >\n New Order\n \n { setTab(\"history\"); fetchOrders(); }}\n class={`flex-1 py-3 rounded-xl font-semibold transition-all ${\n tab === \"history\"\n ? \"bg-blue-600 text-white shadow-lg\"\n : \"bg-white text-gray-600 hover:bg-gray-100\"\n }`}\n >\n My Orders\n {orders.length > 0 && (\n {orders.length}\n )}\n \n

\n\n {/* NEW ORDER TAB */}\n {tab === \"order\" && (\n

\n Submit a Print Request\n

\n\n {success && (\n

\n Order submitted successfully! Check \"My Orders\" for updates.\n

\n )}\n\n

\n {/* Input mode toggle */}\n

\n What do you want to print?\n

\n setInputMode(\"text\")}\n class={`flex-1 py-2.5 rounded-lg border-2 font-medium transition-all ${\n inputMode === \"text\" ? \"border-blue-500 bg-blue-50 text-blue-700\" : \"border-gray-200\"\n }`}\n >\n Paste Text\n \n setInputMode(\"file\")}\n class={`flex-1 py-2.5 rounded-lg border-2 font-medium transition-all ${\n inputMode === \"file\" ? \"border-blue-500 bg-blue-50 text-blue-700\" : \"border-gray-200\"\n }`}\n >\n Upload File\n \n

\n\n {inputMode === \"text\" ? (\n setTextContent(e.target.value)}\n placeholder=\"Paste your assignment text here...\"\n class=\"w-full h-40 px-4 py-3 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 outline-none resize-none\"\n required\n />\n ) : (\n

\n setFile(e.target.files?.[0] || null)}\n class=\"hidden\"\n id=\"file-input\"\n />\n \n \n

{file ? file.name : \"Click to upload (PDF, DOC, TXT, Images)\"}

\n \n

\n )}\n\n {/* Print options */}\n

\n Print Type\n

\n setPrintType(\"bw\")}\n class={`flex-1 py-2.5 rounded-lg border-2 text-sm font-medium transition-all ${\n printType === \"bw\" ? \"border-gray-700 bg-gray-100 text-gray-800\" : \"border-gray-200\"\n }`}\n >\n ⚫ B&W\n \n setPrintType(\"color\")}\n class={`flex-1 py-2.5 rounded-lg border-2 text-sm font-medium transition-all ${\n printType === \"color\" ? \"border-blue-500 bg-blue-50 text-blue-700\" : \"border-gray-200\"\n }`}\n >\n 🌈 Color\n \n

\n\n

\n Copies\n

\n \n {copies}\n \n

\n\n

\n Number of Pages\n setPages(Math.max(1, parseInt(e.target.value) || 1))}\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 outline-none\"\n />\n

\n\n

\n \n Delivery Location\n \n setLocation(e.target.value)}\n placeholder=\"e.g. Akuafo Hall Room 204, UGBS Lecture Hall 3\"\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 outline-none\"\n required\n />\n

\n\n

\n Notes (optional)\n setNotes(e.target.value)}\n placeholder=\"e.g. Staple please, Double-sided...\"\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 outline-none\"\n />\n

\n\n {/* Price breakdown */}\n

Cost Breakdown

Printing ({pages}p × {copies}c × GHS {pricePerPage.toFixed(2)})GHS {printCost.toFixed(2)}

Delivery FeeGHS {PRICING.delivery.toFixed(2)}

Platform Fee (15%)GHS {platformFee.toFixed(2)}

TotalGHS {totalCost.toFixed(2)}

\n\n \n {submitting ? <>Submitting... : <>Submit Print Request}\n \n \n

\n )}\n\n {/* HISTORY TAB */}\n {tab === \"history\" && (\n

\n {loading ? (\n

\n ) : orders.length === 0 ? (\n

\n \n

No orders yet. Submit your first print request!

\n ) : (\n orders.map((order: any) => (\n

\n Order #{order.id}\n \n \n {order.status.charAt(0).toUpperCase() + order.status.slice(1)}\n \n

{order.print_type === \"bw\" ? \"B&W\" : \"Color\"} · {order.copies} copies · {order.pages} pages

{order.delivery_location}

\n {order.file_name &&

{order.file_name}

}\n

\n {new Date(order.created_at).toLocaleDateString()}\n GHS {order.total_cost.toFixed(2)}\n

\n ))\n )}\n

\n )}\n

\n );\n}\n",[],[18,81,256],"e64bea1a-411c-11f1-9115-42b51c65c3df","ShopDashboard.tsx","e64beaec-411c-11f1-9115-42b51c65c3df",14,["D",1777172780373],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst STATUS_COLORS: Record = {\n pending: \"bg-yellow-100 text-yellow-800\",\n accepted: \"bg-blue-100 text-blue-800\",\n printing: \"bg-purple-100 text-purple-800\",\n ready: \"bg-green-100 text-green-800\",\n};\n\nexport function ShopDashboard({ userId }: { userId: number }) {\n const [tab, setTab] = useState<\"pending\" | \"myorders\">(\"pending\");\n const [pendingOrders, setPendingOrders] = useState([]);\n const [myOrders, setMyOrders] = useState([]);\n const [loading, setLoading] = useState(false);\n\n const fetchPending = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/orders/pending\");\n const data = await res.json();\n setPendingOrders(data.orders || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n const fetchMyOrders = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/orders/shop\");\n const data = await res.json();\n setMyOrders(data.orders || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n useEffect(() => { fetchPending(); fetchMyOrders(); }, []);\n\n const updateStatus = async (orderId: number, status: string) => {\n try {\n await fetch(`/api/orders/${orderId}/status`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status }),\n });\n fetchPending();\n fetchMyOrders();\n } catch (err: any) {\n alert(err.message);\n }\n };\n\n const OrderCard = ({ order, actions }: { order: any; actions: any }) => (\n

\n Order #{order.id}\n \n {order.status.toUpperCase()}\n \n

\n\n

{order.print_type === \"bw\" ? \"B&W\" : \"Color\"}

{order.copies} copies, {order.pages} pages

{order.delivery_location}

\n {order.file_name &&

{order.file_name}

}\n {order.text_content && (\n

\n {order.text_content.slice(0, 200)}{order.text_content.length > 200 ? \"...\" : \"\"}\n

\n )}\n {order.notes &&

{order.notes}

}\n

\n\n

\n GHS {order.total_cost?.toFixed(2)}\n

{actions}

\n );\n\n return (\n

\n { setTab(\"pending\"); fetchPending(); }}\n class={`flex-1 py-3 rounded-xl font-semibold transition-all ${\n tab === \"pending\" ? \"bg-blue-600 text-white shadow-lg\" : \"bg-white text-gray-600 hover:bg-gray-100\"\n }`}\n >\n Incoming\n {pendingOrders.length > 0 && (\n {pendingOrders.length}\n )}\n \n { setTab(\"myorders\"); fetchMyOrders(); }}\n class={`flex-1 py-3 rounded-xl font-semibold transition-all ${\n tab === \"myorders\" ? \"bg-blue-600 text-white shadow-lg\" : \"bg-white text-gray-600 hover:bg-gray-100\"\n }`}\n >\n My Orders\n \n

\n\n {loading ? (\n

\n ) : tab === \"pending\" ? (\n pendingOrders.length === 0 ? (\n

\n \n

No pending orders. You're all caught up!

\n ) : (\n pendingOrders.map((order) => (\n \n updateStatus(order.id, \"rejected\")}\n class=\"px-4 py-2 bg-red-100 text-red-700 rounded-lg text-sm font-medium hover:bg-red-200 transition\"\n >\n Reject\n \n updateStatus(order.id, \"accepted\")}\n class=\"px-4 py-2 bg-green-600 text-white rounded-lg text-sm font-medium hover:bg-green-700 transition\"\n >\n Accept\n \n \n }\n />\n ))\n )\n ) : (\n myOrders.length === 0 ? (\n

\n \n

No accepted orders yet.

\n ) : (\n myOrders.map((order) => (\n \n {order.status === \"accepted\" && (\n updateStatus(order.id, \"printing\")}\n class=\"px-4 py-2 bg-purple-600 text-white rounded-lg text-sm font-medium hover:bg-purple-700 transition\"\n >\n Start Printing\n \n )}\n {order.status === \"printing\" && (\n updateStatus(order.id, \"ready\")}\n class=\"px-4 py-2 bg-green-600 text-white rounded-lg text-sm font-medium hover:bg-green-700 transition\"\n >\n Mark Ready\n \n )}\n {(order.status === \"ready\" || order.status === \"delivering\" || order.status === \"delivered\") && (\n \n {order.status === \"ready\" ? \"Waiting for rider...\" : order.status === \"delivering\" ? \"Out for delivery\" : \"Delivered ✓\"}\n \n )}\n \n }\n />\n ))\n )\n )}\n

\n );\n}\n",[],[18,81,264],"bcaac23a-411c-11f1-843f-42b51c65c3df","LoginScreen.tsx","bcaac2f8-411c-11f1-843f-42b51c65c3df",12,["D",1777172710529],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nconst ROLES = [\n { value: \"student\", label: \"Student\", icon: \"fa-graduation-cap\", desc: \"Submit print orders\" },\n { value: \"shop\", label: \"Print Shop\", icon: \"fa-store\", desc: \"Accept & print orders\" },\n { value: \"rider\", label: \"Delivery Rider\", icon: \"fa-motorcycle\", desc: \"Deliver documents\" },\n { value: \"admin\", label: \"Admin\", icon: \"fa-shield-halved\", desc: \"Manage platform\" },\n];\n\nexport function LoginScreen({ onLogin }: { onLogin: (user: any) => void }) {\n const [isRegister, setIsRegister] = useState(false);\n const [name, setName] = useState(\"\");\n const [phone, setPhone] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [role, setRole] = useState(\"student\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n\n const handleSubmit = async (e: Event) => {\n e.preventDefault();\n setError(\"\");\n setLoading(true);\n\n try {\n const url = isRegister ? \"/api/register\" : \"/api/login\";\n const body = isRegister\n ? { name, phone, email: email || undefined, password, role }\n : { phone, password };\n\n const res = await fetch(url, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n\n const data = await res.json();\n if (!res.ok) throw new Error(data.error || \"Something went wrong\");\n onLogin(data.user);\n } catch (err: any) {\n setError(err.message);\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n {/* Logo */}\n

🖨️

PrintPal

Campus Printing & Delivery

\n\n {/* Form Card */}\n

\n {isRegister ? \"Create Account\" : \"Welcome Back\"}\n

\n\n {error && (\n

\n {error}\n

\n )}\n\n

\n {isRegister && (\n <>\n

\n Full Name\n setName(e.target.value)}\n placeholder=\"Kwame Mensah\"\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent outline-none transition\"\n required\n />\n

\n\n

\n Email (optional)\n setEmail(e.target.value)}\n placeholder=\"kwame@university.edu\"\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent outline-none transition\"\n />\n

\n\n {/* Role selector */}\n

\n I am a...\n

\n {ROLES.map((r) => (\n setRole(r.value)}\n class={`p-3 rounded-lg border-2 text-left transition-all ${\n role === r.value\n ? \"border-blue-500 bg-blue-50 text-blue-700\"\n : \"border-gray-200 hover:border-gray-300\"\n }`}\n >\n \n

{r.label}

\n \n ))}\n

\n \n )}\n\n

\n Phone Number\n setPhone(e.target.value)}\n placeholder=\"0241234567\"\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent outline-none transition\"\n required\n />\n

\n\n

\n Password\n setPassword(e.target.value)}\n placeholder=\"••••••••\"\n class=\"w-full px-4 py-2.5 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent outline-none transition\"\n required\n />\n

\n\n \n {loading ? (\n <>Please wait...\n ) : isRegister ? (\n <>Create Account\n ) : (\n <>Log In\n )}\n \n \n\n

\n { setIsRegister(!isRegister); setError(\"\"); }}\n class=\"text-blue-600 hover:text-blue-700 text-sm font-medium\"\n >\n {isRegister ? \"Already have an account? Log In\" : \"New here? Create Account\"}\n \n

\n );\n}\n",[],[18,81,272],"efd35e6a-411c-11f1-9563-42b51c65c3df","DeliveryView.tsx","efd35f14-411c-11f1-9563-42b51c65c3df",15,["D",1777172796312],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function DeliveryView({ userId }: { userId: number }) {\n const [tab, setTab] = useState<\"available\" | \"active\">(\"available\");\n const [readyOrders, setReadyOrders] = useState([]);\n const [activeOrders, setActiveOrders] = useState([]);\n const [loading, setLoading] = useState(false);\n\n const fetchReady = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/orders/ready\");\n const data = await res.json();\n setReadyOrders(data.orders || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n const fetchActive = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/orders/delivering\");\n const data = await res.json();\n setActiveOrders(data.orders || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n useEffect(() => { fetchReady(); fetchActive(); }, []);\n\n const updateStatus = async (orderId: number, status: string) => {\n try {\n await fetch(`/api/orders/${orderId}/status`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status }),\n });\n fetchReady();\n fetchActive();\n } catch (err: any) {\n alert(err.message);\n }\n };\n\n return (\n

\n { setTab(\"available\"); fetchReady(); }}\n class={`flex-1 py-3 rounded-xl font-semibold transition-all ${\n tab === \"available\" ? \"bg-blue-600 text-white shadow-lg\" : \"bg-white text-gray-600 hover:bg-gray-100\"\n }`}\n >\n Available Pickups\n {readyOrders.length > 0 && (\n {readyOrders.length}\n )}\n \n { setTab(\"active\"); fetchActive(); }}\n class={`flex-1 py-3 rounded-xl font-semibold transition-all ${\n tab === \"active\" ? \"bg-blue-600 text-white shadow-lg\" : \"bg-white text-gray-600 hover:bg-gray-100\"\n }`}\n >\n My Deliveries\n \n

\n\n {loading ? (\n

\n ) : tab === \"available\" ? (\n readyOrders.length === 0 ? (\n

\n \n

No orders ready for pickup right now.

\n ) : (\n readyOrders.map((order) => (\n

\n Order #{order.id}\n GHS {order.delivery_fee?.toFixed(2)} delivery\n

Deliver to: {order.delivery_location}

{order.print_type === \"bw\" ? \"B&W\" : \"Color\"} · {order.copies} copies · {order.pages} pages

\n {order.notes &&

{order.notes}

}\n

\n updateStatus(order.id, \"delivering\")}\n class=\"w-full py-2.5 bg-orange-500 hover:bg-orange-600 text-white rounded-lg font-semibold transition\"\n >\n Pick Up & Deliver\n \n

\n ))\n )\n ) : (\n activeOrders.length === 0 ? (\n

\n \n

No active deliveries.

\n ) : (\n activeOrders.map((order) => (\n

\n Order #{order.id}\n \n In Transit\n \n

\n \n Deliver to: {order.delivery_location}\n

\n updateStatus(order.id, \"delivered\")}\n class=\"w-full py-2.5 bg-green-600 hover:bg-green-700 text-white rounded-lg font-semibold transition\"\n >\n Mark as Delivered\n \n

\n ))\n )\n )}\n

\n );\n}\n",[],[18,81,280],"afc83692-411c-11f1-a498-42b51c65c3df","App.tsx","afc83840-411c-11f1-a498-42b51c65c3df",11,["D",1777172688579],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { LoginScreen } from \"./LoginScreen.tsx\";\nimport { StudentView } from \"./StudentView.tsx\";\nimport { ShopDashboard } from \"./ShopDashboard.tsx\";\nimport { DeliveryView } from \"./DeliveryView.tsx\";\nimport { AdminPanel } from \"./AdminPanel.tsx\";\n\ninterface UserSession {\n userId: number;\n role: string;\n name: string;\n}\n\nexport function App() {\n const [user, setUser] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const checkSession = useCallback(async () => {\n try {\n const res = await fetch(\"/api/me\");\n const data = await res.json();\n setUser(data.user);\n } catch {\n setUser(null);\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => { checkSession(); }, [checkSession]);\n\n const handleLogout = async () => {\n await fetch(\"/api/logout\", { method: \"POST\" });\n setUser(null);\n };\n\n if (loading) {\n return (\n

🖨️

Loading PrintPal...

\n );\n }\n\n if (!user) {\n return ;\n }\n\n return (\n

\n {/* Header */}\n

\n 🖨️\n

PrintPal

\n \n \n {user.name}\n ({user.role})\n \n \n Logout\n \n

\n\n {/* Main content */}\n

\n {user.role === \"student\" && }\n {user.role === \"shop\" && }\n {user.role === \"rider\" && }\n {user.role === \"admin\" && }\n

\n\n {/* Footer */}\n \n

\n );\n}\n",[],[18,81,288],"06787a10-411d-11f1-843f-42b51c65c3df","AdminPanel.tsx","06787ae2-411d-11f1-843f-42b51c65c3df",16,["D",1777172834351],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst STATUS_COLORS: Record = {\n pending: \"bg-yellow-100 text-yellow-800\",\n accepted: \"bg-blue-100 text-blue-800\",\n rejected: \"bg-red-100 text-red-800\",\n printing: \"bg-purple-100 text-purple-800\",\n ready: \"bg-indigo-100 text-indigo-800\",\n delivering: \"bg-orange-100 text-orange-800\",\n delivered: \"bg-green-100 text-green-800\",\n};\n\nconst ROLE_COLORS: Record = {\n student: \"bg-blue-100 text-blue-800\",\n shop: \"bg-green-100 text-green-800\",\n rider: \"bg-orange-100 text-orange-800\",\n admin: \"bg-purple-100 text-purple-800\",\n};\n\nexport function AdminPanel() {\n const [tab, setTab] = useState<\"overview\" | \"orders\" | \"users\" | \"shops\">(\"overview\");\n const [analytics, setAnalytics] = useState(null);\n const [orders, setOrders] = useState([]);\n const [users, setUsers] = useState([]);\n const [shops, setShops] = useState([]);\n const [loading, setLoading] = useState(false);\n\n const fetchAnalytics = async () => {\n try {\n const res = await fetch(\"/api/admin/analytics\");\n setAnalytics(await res.json());\n } catch { /* ignore */ }\n };\n\n const fetchOrders = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/admin/orders\");\n setOrders((await res.json()).orders || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n const fetchUsers = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/admin/users\");\n setUsers((await res.json()).users || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n const fetchShops = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/admin/shops\");\n setShops((await res.json()).shops || []);\n } catch { /* ignore */ }\n setLoading(false);\n };\n\n useEffect(() => { fetchAnalytics(); }, []);\n\n const tabs = [\n { key: \"overview\", label: \"Overview\", icon: \"fa-chart-pie\", action: fetchAnalytics },\n { key: \"orders\", label: \"Orders\", icon: \"fa-list\", action: fetchOrders },\n { key: \"users\", label: \"Users\", icon: \"fa-users\", action: fetchUsers },\n { key: \"shops\", label: \"Shops\", icon: \"fa-store\", action: fetchShops },\n ];\n\n const StatCard = ({ icon, label, value, color }: any) => (\n

\n \n

{value}

{label}

\n );\n\n return (\n

\n {/* Tab nav */}\n

\n {tabs.map((t) => (\n { setTab(t.key as any); t.action(); }}\n class={`flex-1 py-2.5 rounded-lg text-sm font-semibold transition-all ${\n tab === t.key ? \"bg-blue-600 text-white\" : \"text-gray-600 hover:bg-gray-100\"\n }`}\n >\n {t.label}\n \n ))}\n

\n\n {/* OVERVIEW */}\n {tab === \"overview\" && analytics && (\n

\n \n \n \n s + (r.count || 0), 0) || 0}\n color=\"border-purple-600\"\n />\n

\n\n {/* Users by role */}\n

Users by Role

\n {(analytics.usersByRole || []).map((r: any) => (\n

\n \n {r.role}\n \n {r.count}\n

\n ))}\n

\n\n {/* Orders by status */}\n

Orders by Status

\n {(analytics.ordersByStatus || []).map((s: any) => (\n

\n \n {s.status}\n \n

\n {s.count}\n

\n ))}\n

\n )}\n\n {/* ORDERS */}\n {tab === \"orders\" && (\n loading ? (\n

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n \n \n {orders.map((o) => (\n \n \n \n \n \n \n \n \n ))}\n \n

ID	Type	Location	Status	Total	Date
#{o.id}	{o.print_type === \"bw\" ? \"B&W\" : \"Color\"} · {o.copies}c · {o.pages}p	{o.delivery_location}	\n {o.status}\n	GHS {o.total_cost?.toFixed(2)}	{new Date(o.created_at).toLocaleDateString()}

\n {orders.length === 0 &&

No orders yet

}\n

\n )\n )}\n\n {/* USERS */}\n {tab === \"users\" && (\n loading ? (\n

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n \n {users.map((u) => (\n \n \n \n \n \n \n \n ))}\n \n

ID	Name	Phone	Role	Joined
#{u.id}	{u.name}	{u.phone}	\n {u.role}\n	{new Date(u.created_at).toLocaleDateString()}

\n {users.length === 0 &&

No users yet

}\n

\n )\n )}\n\n {/* SHOPS */}\n {tab === \"shops\" && (\n loading ? (\n

\n ) : (\n

\n {shops.length === 0 ? (\n

\n \n

No printing shops registered yet.

\n ) : (\n shops.map((s) => (\n

\n \n

{s.name}

{s.phone} · {s.email || \"No email\"}

#{s.id}

\n ))\n )}\n

\n )\n )}\n \n );\n}\n",[],[18,81,296],["D",1777172673457],[206,207,208,209,210,211],[18,81],["D",1777172596052],[205,212,213],[18],"8c288142-411c-11f1-b9cb-42b51c65c3df","queries.ts","8c288232-411c-11f1-b9cb-42b51c65c3df","780cab70-411c-11f1-929f-42b51c65c3df",6,["D",1777172629147],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Order, User, UserRole, OrderStatus } from \"../shared/types.ts\";\n\n// ---- Users ----\n\nexport async function createUser(name: string, phone: string, email: string | null, role: UserRole, passwordHash: string): Promise {\n const result = await sqlite.execute({\n sql: \"INSERT INTO users (name, phone, email, role, password_hash) VALUES (?, ?, ?, ?, ?) RETURNING *\",\n args: [name, phone, email, role, passwordHash],\n });\n return result.rows[0] as unknown as User;\n}\n\nexport async function getUserByPhone(phone: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE phone = ?\",\n args: [phone],\n });\n return (result.rows[0] as unknown as User) ?? null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [id],\n });\n return (result.rows[0] as unknown as User) ?? null;\n}\n\nexport async function getAllUsers(): Promise {\n const result = await sqlite.execute(\"SELECT id, name, phone, email, role, created_at FROM users ORDER BY created_at DESC\");\n return result.rows as unknown as User[];\n}\n\nexport async function getUsersByRole(role: UserRole): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT id, name, phone, email, role, created_at FROM users WHERE role = ? ORDER BY created_at DESC\",\n args: [role],\n });\n return result.rows as unknown as User[];\n}\n\n// ---- Orders ----\n\nexport async function createOrder(order: {\n student_id: number;\n file_name: string | null;\n text_content: string | null;\n file_blob_key: string | null;\n print_type: string;\n copies: number;\n pages: number;\n delivery_location: string;\n print_cost: number;\n delivery_fee: number;\n platform_fee: number;\n total_cost: number;\n notes: string | null;\n}): Promise {\n const result = await sqlite.execute({\n sql: `INSERT INTO orders (student_id, file_name, text_content, file_blob_key, print_type, copies, pages, delivery_location, print_cost, delivery_fee, platform_fee, total_cost, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n args: [\n order.student_id, order.file_name, order.text_content, order.file_blob_key,\n order.print_type, order.copies, order.pages, order.delivery_location,\n order.print_cost, order.delivery_fee, order.platform_fee, order.total_cost, order.notes,\n ],\n });\n return result.rows[0] as unknown as Order;\n}\n\nexport async function getOrdersByStudent(studentId: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM orders WHERE student_id = ? ORDER BY created_at DESC\",\n args: [studentId],\n });\n return result.rows as unknown as Order[];\n}\n\nexport async function getOrdersByShop(shopId: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM orders WHERE shop_id = ? ORDER BY created_at DESC\",\n args: [shopId],\n });\n return result.rows as unknown as Order[];\n}\n\nexport async function getPendingOrders(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM orders WHERE status = 'pending' ORDER BY created_at ASC\");\n return result.rows as unknown as Order[];\n}\n\nexport async function getReadyOrders(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM orders WHERE status = 'ready' ORDER BY updated_at ASC\");\n return result.rows as unknown as Order[];\n}\n\nexport async function getDeliveringOrders(riderId: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM orders WHERE rider_id = ? AND status = 'delivering' ORDER BY updated_at ASC\",\n args: [riderId],\n });\n return result.rows as unknown as Order[];\n}\n\nexport async function getAllOrders(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM orders ORDER BY created_at DESC\");\n return result.rows as unknown as Order[];\n}\n\nexport async function updateOrderStatus(orderId: number, status: OrderStatus, extra?: { shop_id?: number; rider_id?: number }): Promise {\n let sql = \"UPDATE orders SET status = ?, updated_at = datetime('now')\";\n const args: any[] = [status];\n\n if (extra?.shop_id !== undefined) {\n sql += \", shop_id = ?\";\n args.push(extra.shop_id);\n }\n if (extra?.rider_id !== undefined) {\n sql += \", rider_id = ?\";\n args.push(extra.rider_id);\n }\n\n sql += \" WHERE id = ? RETURNING *\";\n args.push(orderId);\n\n const result = await sqlite.execute({ sql, args });\n return result.rows[0] as unknown as Order;\n}\n\n// ---- Analytics ----\nexport async function getAnalytics() {\n const [ordersRes, usersRes, revenueRes, statusRes] = await Promise.all([\n sqlite.execute(\"SELECT COUNT(*) as total FROM orders\"),\n sqlite.execute(\"SELECT role, COUNT(*) as count FROM users GROUP BY role\"),\n sqlite.execute(\"SELECT SUM(total_cost) as revenue, SUM(platform_fee) as commission FROM orders WHERE status = 'delivered'\"),\n sqlite.execute(\"SELECT status, COUNT(*) as count FROM orders GROUP BY status\"),\n ]);\n\n return {\n totalOrders: (ordersRes.rows[0] as any)?.total ?? 0,\n usersByRole: usersRes.rows as any[],\n revenue: (revenueRes.rows[0] as any)?.revenue ?? 0,\n commission: (revenueRes.rows[0] as any)?.commission ?? 0,\n ordersByStatus: statusRes.rows as any[],\n };\n}\n",[],[318,310],"database","828c3f34-411c-11f1-843f-42b51c65c3df","migrations.ts","828c3fd4-411c-11f1-843f-42b51c65c3df",5,["D",1777172613023],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\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 phone TEXT NOT NULL UNIQUE,\n email TEXT,\n role TEXT NOT NULL DEFAULT 'student',\n password_hash TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_id INTEGER NOT NULL,\n shop_id INTEGER,\n rider_id INTEGER,\n file_name TEXT,\n text_content TEXT,\n file_blob_key TEXT,\n print_type TEXT NOT NULL DEFAULT 'bw',\n copies INTEGER NOT NULL DEFAULT 1,\n pages INTEGER NOT NULL DEFAULT 1,\n delivery_location TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending',\n print_cost REAL NOT NULL DEFAULT 0,\n delivery_fee REAL NOT NULL DEFAULT 0,\n platform_fee REAL NOT NULL DEFAULT 0,\n total_cost REAL NOT NULL DEFAULT 0,\n notes TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (student_id) REFERENCES users(id),\n FOREIGN KEY (shop_id) REFERENCES users(id),\n FOREIGN KEY (rider_id) REFERENCES users(id)\n )`,\n },\n ]);\n}\n",[],[318,320],"780caac6-411c-11f1-929f-42b51c65c3df",["D",1777172595407],[202,203],[318],["D",1777172591721],["D",1789531852468],{"_11":12,"_146":72},{"_11":12,"_142":-5,"_71":72,"_31":70,"_143":144,"_145":30},{"_41":133,"_13":16,"_35":38,"_134":95,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":14,"_141":12},"ctx",{"_55":-5,"_165":369,"_370":371,"_372":373,"_374":30,"_375":30,"_376":30,"_377":24,"_378":-5,"_379":-7,"_380":-7,"_381":26,"_382":30,"_383":30,"_384":-5,"_385":30,"_386":30,"_387":30,"_388":-5},"ENV",{"_340":341,"_342":343,"_344":16,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368},"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"]

History · frontend