[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_113":95,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":30,"_131":-5,"_132":-5,"_133":134},"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":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",6,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","a6deb686-346b-486d-89a0-5efbb0a73085","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","database/queries.ts","latestPath","fileId","8c288232-411c-11f1-b9cb-42b51c65c3df","name","queries.ts","fileType","script","content","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","createdAt",["D",1777172629147],"branchVersion","branchId","75d9c676-411c-11f1-99a0-42b51c65c3df","id","75d93756-411c-11f1-99a0-42b51c65c3df","printpal",["D",1777172591721],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Campus printing & delivery platform for university students","imageUrl","c827e2c0-1bf5-11f0-a1c1-fda95a61b6d1","pinnedFileId","a26cbd92-411c-11f1-843f-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","9fead931-b2c2-4bde-a5a6-c7316333f0c8","tursoName","75d93756411c11f199a042b51c65c3df","tursoHostname","75d93756411c11f199a042b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789531852468],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":108},"org",{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","beulahh","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ2c2liNW5nSGFhNjlRWDJobzBoSEhtRHk5cCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":206,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":207,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":208,"_89":209,"_91":210,"_93":30},"tree",[170,173,174],"files",[170,171,172,173,174,175],"counts",{"_160":68,"_161":157,"_162":68,"_163":164,"_165":166},"contents",[135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":154,"_37":155,"_35":156,"_141":-5,"_46":47,"_45":157,"_143":64,"_43":158,"_13":68,"_39":145,"_41":-5,"_29":30,"_146":-5,"_32":159},{"_48":148,"_37":149,"_35":150,"_141":-5,"_46":47,"_45":151,"_143":64,"_43":152,"_13":68,"_39":145,"_41":-5,"_29":30,"_146":-5,"_32":153},{"_48":138,"_37":139,"_35":140,"_141":-5,"_46":47,"_45":142,"_143":64,"_43":144,"_13":68,"_39":145,"_41":-5,"_29":30,"_146":-5,"_32":147},"7845c1f8-411c-11f1-b9cb-42b51c65c3df","shared","7845c28e-411c-11f1-b9cb-42b51c65c3df","parentId",2,"latest",["D",1777172595784],"directory","label",[139],"786eb338-411c-11f1-b9cb-42b51c65c3df","frontend","786eb40a-411c-11f1-b9cb-42b51c65c3df",3,["D",1777172596052],[149],"780caac6-411c-11f1-929f-42b51c65c3df","database","780cab70-411c-11f1-929f-42b51c65c3df",1,["D",1777172595407],[155],"pulls","branches","forks","envVars",{"_167":68,"_169":68},"connections",{"_167":68,"_168":68},"count","unfilledCount","emptyCount",{"_48":154,"_37":155,"_35":156,"_141":-5,"_46":47,"_45":157,"_143":64,"_43":203,"_13":68,"_39":145,"_41":-5,"_29":30,"_146":-5,"_182":204,"_32":205},{"_48":195,"_37":196,"_35":197,"_141":156,"_46":47,"_45":198,"_143":64,"_43":199,"_13":68,"_39":40,"_41":200,"_29":30,"_146":-5,"_182":201,"_32":202},{"_48":191,"_37":38,"_35":36,"_141":156,"_46":47,"_45":14,"_143":64,"_43":192,"_13":68,"_39":40,"_41":42,"_29":30,"_146":-5,"_182":193,"_32":194},{"_48":148,"_37":149,"_35":150,"_141":-5,"_46":47,"_45":151,"_143":64,"_43":188,"_13":68,"_39":145,"_41":-5,"_29":30,"_146":-5,"_182":189,"_32":190},{"_48":138,"_37":139,"_35":140,"_141":-5,"_46":47,"_45":142,"_143":64,"_43":185,"_13":68,"_39":145,"_41":-5,"_29":30,"_146":-5,"_182":186,"_32":187},{"_48":176,"_37":177,"_35":178,"_141":140,"_46":47,"_45":179,"_143":64,"_43":180,"_13":68,"_39":40,"_41":181,"_29":30,"_146":-5,"_182":183,"_32":184},"80113ed0-411c-11f1-b9cb-42b51c65c3df","types.ts","801140c4-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","children",[],[139,177],["D",1777172595784],[175],[139],["D",1777172596052],[],[149],"8c288142-411c-11f1-b9cb-42b51c65c3df",["D",1777172629147],[],[155,38],"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",[],[155,196],["D",1777172595407],[171,172],[155],["D",1777172591721],["D",1789531852468],{"_105":104,"_112":108},{"_105":104,"_106":-5,"_107":108,"_19":60,"_109":110,"_111":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_132":244,"_245":246,"_247":248,"_249":30,"_250":30,"_251":30,"_252":64,"_253":-5,"_254":-7,"_255":-7,"_256":68,"_257":30,"_258":30,"_259":-5,"_260":30,"_261":30,"_262":30,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":95,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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 · v6