[{"_1":2,"_349":-5,"_350":-5},"loaderData",{"_3":4,"_91":92,"_291":292},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","ff0419d68e57d8cc3e37e5d3da688157c5dd37c6","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":43,"_98":99,"_100":101,"_102":103,"_148":149,"_272":273,"_274":275,"_280":281,"_268":282,"_285":-5,"_286":-5,"_287":22,"_288":22,"_289":290},"handle","Lenny254","name","PointofSale","branchName","path","backend/routes/static.ts","version",9,"project",{"_104":105,"_95":96,"_106":107,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_147":22},"id","b55c75a0-358d-11f0-a131-9e149126039e","createdAt",["D",1747754319784],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","9e4a73e0-ed2f-11ef-af12-67b5d5b0b458","pinnedFileId","pinPreview","screenshotVersion","likeCount","3adbf8df-2c00-42d3-9fb1-3e9b778b76f3","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3YWdMcTZRcHViZGJId3RRQnBVbHNRVzByVyJ9","org",{"_93":94,"_134":131},"avatar","branch",{"_100":137,"_95":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},34,"b55ce0d0-358d-11f0-a131-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[150,246,262],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_106":161,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":168,"_98":245},"0fa69662-358e-11f0-831b-9e149126039e","backend","fileId","086c0e31-a0d9-4526-95e6-55e7c2f5d362","parentId","branchId","branchVersion",3,"latest",true,["D",1747754471232],"fileType","directory","content","deleted","label","children",[169,194],{"_104":170,"_95":171,"_153":172,"_155":154,"_156":138,"_157":158,"_159":160,"_106":173,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":174,"_98":193},"0fa69932-358e-11f0-831b-9e149126039e","database","761b15d0-57fb-4886-a5b5-e7ca29f8b636",["D",1747754471232],[175,184],{"_104":176,"_95":177,"_153":178,"_155":172,"_156":138,"_157":158,"_159":22,"_106":179,"_100":32,"_162":180,"_164":181,"_165":22,"_166":-5,"_167":182,"_98":183},"0fa62664-358e-11f0-831b-9e149126039e","migrations.ts","0fa62718-358e-11f0-831b-9e149126039e",["D",1747754471232],"script","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use these constants throughout the app\nexport const TABLES = {\n PRODUCTS: 'pos_products',\n USERS: 'pos_users',\n SALES: 'pos_sales',\n SALE_ITEMS: 'pos_sale_items',\n};\n\nexport async function runMigrations() {\n // Create products table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.PRODUCTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n price REAL NOT NULL,\n stock INTEGER NOT NULL DEFAULT 0,\n category TEXT NOT NULL,\n barcode TEXT,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )\n `);\n\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.USERS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL UNIQUE,\n password_hash TEXT NOT NULL,\n role TEXT NOT NULL CHECK(role IN ('admin', 'cashier')),\n created_at TEXT NOT NULL\n )\n `);\n\n // Create sales table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.SALES} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n total_amount REAL NOT NULL,\n payment_method TEXT NOT NULL CHECK(payment_method IN ('cash', 'card', 'other')),\n created_at TEXT NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS} (id)\n )\n `);\n\n // Create sale items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.SALE_ITEMS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n sale_id INTEGER NOT NULL,\n product_id INTEGER NOT NULL,\n quantity INTEGER NOT NULL,\n price_per_unit REAL NOT NULL,\n total_price REAL NOT NULL,\n FOREIGN KEY (sale_id) REFERENCES ${TABLES.SALES} (id),\n FOREIGN KEY (product_id) REFERENCES ${TABLES.PRODUCTS} (id)\n )\n `);\n\n // Create default admin user if none exists\n const adminExists = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLES.USERS} WHERE role = 'admin'`\n );\n \n if (adminExists[0].count === 0) {\n // Default password is 'admin123' - should be changed immediately\n await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (username, password_hash, role, created_at) \n VALUES (?, ?, ?, ?)`,\n ['admin', '$2a$10$JNVCmA.qOzQYeJXBzNx7aOLXRxNIxfA9XUXTEh7rIgJdIGWdIQBDu', 'admin', new Date().toISOString()]\n );\n }\n}\n\n// Run this function to reset the database (for development only)\nexport async function resetDatabase() {\n for (const table of Object.values(TABLES)) {\n await sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\n }\n await runMigrations();\n}",[],[152,171,177],{"_104":185,"_95":186,"_153":187,"_155":172,"_156":138,"_157":188,"_159":160,"_106":189,"_100":32,"_162":180,"_164":190,"_165":22,"_166":-5,"_167":191,"_98":192},"2356e0e0-358e-11f0-9ccd-9e149126039e","queries.ts","2356e1a8-358e-11f0-9ccd-9e149126039e",4,["D",1747754504296],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport { Product, Sale, SaleItem, User } from \"../../shared/types.ts\";\nimport * as bcrypt from \"https://deno.land/x/bcrypt@v0.4.1/mod.ts\";\n\n// Product queries\nexport async function getAllProducts(): Promise {\n return await sqlite.execute(`SELECT * FROM ${TABLES.PRODUCTS} ORDER BY name ASC`);\n}\n\nexport async function getProductById(id: number): Promise {\n const results = await sqlite.execute(\n `SELECT * FROM ${TABLES.PRODUCTS} WHERE id = ?`,\n [id]\n );\n return results.length > 0 ? results[0] : null;\n}\n\nexport async function createProduct(product: Omit): Promise {\n const now = new Date().toISOString();\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.PRODUCTS} (name, price, stock, category, barcode, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [product.name, product.price, product.stock, product.category, product.barcode || null, now, now]\n );\n return result[0].id;\n}\n\nexport async function updateProduct(id: number, product: Partial>): Promise {\n const current = await getProductById(id);\n if (!current) return false;\n\n const updates = [];\n const values = [];\n\n for (const [key, value] of Object.entries(product)) {\n if (key !== 'id' && key !== 'created_at' && key !== 'updated_at') {\n updates.push(`${key} = ?`);\n values.push(value);\n }\n }\n\n if (updates.length === 0) return true;\n\n updates.push('updated_at = ?');\n values.push(new Date().toISOString());\n values.push(id);\n\n await sqlite.execute(\n `UPDATE ${TABLES.PRODUCTS} SET ${updates.join(', ')} WHERE id = ?`,\n values\n );\n return true;\n}\n\nexport async function deleteProduct(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TABLES.PRODUCTS} WHERE id = ?`,\n [id]\n );\n return result.rowsAffected > 0;\n}\n\nexport async function updateProductStock(id: number, quantityChange: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${TABLES.PRODUCTS} \n SET stock = stock + ?, updated_at = ?\n WHERE id = ? AND stock + ? >= 0`,\n [quantityChange, new Date().toISOString(), id, quantityChange]\n );\n return result.rowsAffected > 0;\n}\n\n// User queries\nexport async function getUserByUsername(username: string): Promise {\n const results = await sqlite.execute(\n `SELECT id, username, role, created_at FROM ${TABLES.USERS} WHERE username = ?`,\n [username]\n );\n return results.length > 0 ? results[0] : null;\n}\n\nexport async function verifyUser(username: string, password: string): Promise {\n const results = await sqlite.execute(\n `SELECT id, username, password_hash, role, created_at FROM ${TABLES.USERS} WHERE username = ?`,\n [username]\n );\n \n if (results.length === 0) return null;\n \n const user = results[0];\n const passwordMatch = await bcrypt.compare(password, user.password_hash);\n \n if (!passwordMatch) return null;\n \n // Don't return the password hash\n delete user.password_hash;\n return user;\n}\n\nexport async function createUser(username: string, password: string, role: 'admin' | 'cashier'): Promise {\n const passwordHash = await bcrypt.hash(password);\n const now = new Date().toISOString();\n \n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (username, password_hash, role, created_at)\n VALUES (?, ?, ?, ?)\n RETURNING id`,\n [username, passwordHash, role, now]\n );\n \n return result[0].id;\n}\n\n// Sales queries\nexport async function createSale(\n userId: number, \n items: Array<{ productId: number; quantity: number; }>,\n paymentMethod: 'cash' | 'card' | 'other'\n): Promise {\n // Start a transaction\n await sqlite.execute('BEGIN TRANSACTION');\n \n try {\n let totalAmount = 0;\n const now = new Date().toISOString();\n \n // Calculate total and verify stock\n for (const item of items) {\n const product = await getProductById(item.productId);\n if (!product) throw new Error(`Product with ID ${item.productId} not found`);\n if (product.stock < item.quantity) throw new Error(`Insufficient stock for product: ${product.name}`);\n \n totalAmount += product.price * item.quantity;\n }\n \n // Create the sale record\n const saleResult = await sqlite.execute(\n `INSERT INTO ${TABLES.SALES} (user_id, total_amount, payment_method, created_at)\n VALUES (?, ?, ?, ?)\n RETURNING id`,\n [userId, totalAmount, paymentMethod, now]\n );\n \n const saleId = saleResult[0].id;\n \n // Add sale items and update stock\n for (const item of items) {\n const product = await getProductById(item.productId);\n if (!product) throw new Error(`Product with ID ${item.productId} not found`);\n \n // Add sale item\n await sqlite.execute(\n `INSERT INTO ${TABLES.SALE_ITEMS} (sale_id, product_id, quantity, price_per_unit, total_price)\n VALUES (?, ?, ?, ?, ?)`,\n [saleId, item.productId, item.quantity, product.price, product.price * item.quantity]\n );\n \n // Update product stock\n await updateProductStock(item.productId, -item.quantity);\n }\n \n // Commit the transaction\n await sqlite.execute('COMMIT');\n return saleId;\n } catch (error) {\n // Rollback on error\n await sqlite.execute('ROLLBACK');\n throw error;\n }\n}\n\nexport async function getSaleById(id: number): Promise {\n const saleResults = await sqlite.execute(\n `SELECT s.id, s.user_id, u.username, s.total_amount, s.payment_method, s.created_at\n FROM ${TABLES.SALES} s\n JOIN ${TABLES.USERS} u ON s.user_id = u.id\n WHERE s.id = ?`,\n [id]\n );\n \n if (saleResults.length === 0) return null;\n \n const sale = saleResults[0] as Sale;\n \n // Get sale items\n const itemResults = await sqlite.execute(\n `SELECT si.id, si.sale_id, si.product_id, p.name as product_name, \n si.quantity, si.price_per_unit, si.total_price\n FROM ${TABLES.SALE_ITEMS} si\n JOIN ${TABLES.PRODUCTS} p ON si.product_id = p.id\n WHERE si.sale_id = ?`,\n [id]\n );\n \n sale.items = itemResults as SaleItem[];\n return sale;\n}\n\nexport async function getRecentSales(limit: number = 20): Promise {\n const saleResults = await sqlite.execute(\n `SELECT s.id, s.user_id, u.username, s.total_amount, s.payment_method, s.created_at\n FROM ${TABLES.SALES} s\n JOIN ${TABLES.USERS} u ON s.user_id = u.id\n ORDER BY s.created_at DESC\n LIMIT ?`,\n [limit]\n );\n \n const sales = saleResults as Sale[];\n \n // Get items for each sale\n for (const sale of sales) {\n const itemResults = await sqlite.execute(\n `SELECT si.id, si.sale_id, si.product_id, p.name as product_name, \n si.quantity, si.price_per_unit, si.total_price\n FROM ${TABLES.SALE_ITEMS} si\n JOIN ${TABLES.PRODUCTS} p ON si.product_id = p.id\n WHERE si.sale_id = ?`,\n [sale.id]\n );\n \n sale.items = itemResults as SaleItem[];\n }\n \n return sales;\n}\n\n// Dashboard queries\nexport async function getDashboardStats() {\n // Get total sales count\n const totalSalesResult = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLES.SALES}`\n );\n const totalSales = totalSalesResult[0].count;\n \n // Get total revenue\n const totalRevenueResult = await sqlite.execute(\n `SELECT SUM(total_amount) as total FROM ${TABLES.SALES}`\n );\n const totalRevenue = totalRevenueResult[0].total || 0;\n \n // Get low stock items count\n const lowStockResult = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLES.PRODUCTS} WHERE stock < 5`\n );\n const lowStockItems = lowStockResult[0].count;\n \n // Get top selling products\n const topProductsResult = await sqlite.execute(\n `SELECT p.name, SUM(si.quantity) as quantity\n FROM ${TABLES.SALE_ITEMS} si\n JOIN ${TABLES.PRODUCTS} p ON si.product_id = p.id\n GROUP BY si.product_id\n ORDER BY quantity DESC\n LIMIT 5`\n );\n \n return {\n totalSales,\n totalRevenue,\n lowStockItems,\n topProducts: topProductsResult\n };\n}",[],[152,171,186],[152,171],{"_104":195,"_95":196,"_153":197,"_155":154,"_156":138,"_157":198,"_159":160,"_106":199,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":200,"_98":244},"2aa1feac-358e-11f0-8619-9e149126039e","routes","ec187c90-367b-4316-9f8d-3124ef0499e6",5,["D",1747754516532],[201,209,218,227,236],{"_104":202,"_95":203,"_153":204,"_155":197,"_156":138,"_157":198,"_159":160,"_106":205,"_100":32,"_162":180,"_164":206,"_165":22,"_166":-5,"_167":207,"_98":208},"2aa1f132-358e-11f0-8619-9e149126039e","auth.ts","2aa1f204-358e-11f0-8619-9e149126039e",["D",1747754516532],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { createUser, getUserByUsername, verifyUser } from \"../database/queries.ts\";\n\n// Secret key for JWT - in production, use an environment variable\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"pos-system-secret-key\";\n\nconst auth = new Hono();\n\n// Apply JWT middleware\nauth.use(\n \"/verify\",\n jwt({\n secret: JWT_SECRET,\n })\n);\n\n// Login endpoint\nauth.post(\"/login\", async (c) => {\n try {\n const { username, password } = await c.req.json();\n\n if (!username || !password) {\n return c.json({ success: false, error: \"Username and password are required\" }, 400);\n }\n\n const user = await verifyUser(username, password);\n\n if (!user) {\n return c.json({ success: false, error: \"Invalid username or password\" }, 401);\n }\n\n // Generate JWT token\n const token = await jwt.sign({ id: user.id, username: user.username, role: user.role }, JWT_SECRET);\n\n return c.json({\n success: true,\n data: {\n token,\n user: {\n id: user.id,\n username: user.username,\n role: user.role\n }\n }\n });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({ success: false, error: \"Authentication failed\" }, 500);\n }\n});\n\n// Register endpoint (admin only)\nauth.post(\"/register\", async (c) => {\n try {\n const { username, password, role } = await c.req.json();\n \n // Validate input\n if (!username || !password) {\n return c.json({ success: false, error: \"Username and password are required\" }, 400);\n }\n \n if (role !== \"admin\" && role !== \"cashier\") {\n return c.json({ success: false, error: \"Role must be either 'admin' or 'cashier'\" }, 400);\n }\n \n // Check if username already exists\n const existingUser = await getUserByUsername(username);\n if (existingUser) {\n return c.json({ success: false, error: \"Username already exists\" }, 409);\n }\n \n // Create new user\n const userId = await createUser(username, password, role);\n \n return c.json({\n success: true,\n data: { id: userId, username, role }\n });\n } catch (error) {\n console.error(\"Registration error:\", error);\n return c.json({ success: false, error: \"Registration failed\" }, 500);\n }\n});\n\n// Verify token endpoint\nauth.get(\"/verify\", async (c) => {\n // JWT middleware already verified the token\n const payload = c.get(\"jwtPayload\");\n return c.json({ success: true, data: payload });\n});\n\nexport default auth;",[],[152,196,203],{"_104":210,"_95":211,"_153":212,"_155":197,"_156":138,"_157":213,"_159":160,"_106":214,"_100":32,"_162":180,"_164":215,"_165":22,"_166":-5,"_167":216,"_98":217},"45fd4544-358e-11f0-87aa-9e149126039e","dashboard.ts","45fd4602-358e-11f0-87aa-9e149126039e",8,["D",1747754562428],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { getDashboardStats } from \"../database/queries.ts\";\n\n// Secret key for JWT - in production, use an environment variable\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"pos-system-secret-key\";\n\nconst dashboard = new Hono();\n\n// Apply JWT middleware to all routes\ndashboard.use(\"*\", jwt({ secret: JWT_SECRET }));\n\n// Get dashboard statistics\ndashboard.get(\"/stats\", async (c) => {\n try {\n const stats = await getDashboardStats();\n return c.json({ success: true, data: stats });\n } catch (error) {\n console.error(\"Error fetching dashboard stats:\", error);\n return c.json({ success: false, error: \"Failed to fetch dashboard statistics\" }, 500);\n }\n});\n\nexport default dashboard;",[],[152,196,211],{"_104":219,"_95":220,"_153":221,"_155":197,"_156":138,"_157":222,"_159":160,"_106":223,"_100":32,"_162":180,"_164":224,"_165":22,"_166":-5,"_167":225,"_98":226},"387b929a-358e-11f0-ba64-9e149126039e","products.ts","387b9380-358e-11f0-ba64-9e149126039e",6,["D",1747754539769],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { \n getAllProducts, \n getProductById, \n createProduct, \n updateProduct, \n deleteProduct,\n updateProductStock\n} from \"../database/queries.ts\";\n\n// Secret key for JWT - in production, use an environment variable\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"pos-system-secret-key\";\n\nconst products = new Hono();\n\n// Apply JWT middleware to all routes\nproducts.use(\"*\", jwt({ secret: JWT_SECRET }));\n\n// Get all products\nproducts.get(\"/\", async (c) => {\n try {\n const products = await getAllProducts();\n return c.json({ success: true, data: products });\n } catch (error) {\n console.error(\"Error fetching products:\", error);\n return c.json({ success: false, error: \"Failed to fetch products\" }, 500);\n }\n});\n\n// Get product by ID\nproducts.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid product ID\" }, 400);\n }\n \n const product = await getProductById(id);\n if (!product) {\n return c.json({ success: false, error: \"Product not found\" }, 404);\n }\n \n return c.json({ success: true, data: product });\n } catch (error) {\n console.error(\"Error fetching product:\", error);\n return c.json({ success: false, error: \"Failed to fetch product\" }, 500);\n }\n});\n\n// Create new product (admin only)\nproducts.post(\"/\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n if (payload.role !== \"admin\") {\n return c.json({ success: false, error: \"Admin access required\" }, 403);\n }\n \n const productData = await c.req.json();\n \n // Validate required fields\n if (!productData.name || productData.price === undefined || !productData.category) {\n return c.json({ \n success: false, \n error: \"Name, price, and category are required\" \n }, 400);\n }\n \n // Validate price and stock\n if (typeof productData.price !== \"number\" || productData.price < 0) {\n return c.json({ success: false, error: \"Price must be a positive number\" }, 400);\n }\n \n if (productData.stock !== undefined && (typeof productData.stock !== \"number\" || productData.stock < 0)) {\n return c.json({ success: false, error: \"Stock must be a positive number\" }, 400);\n }\n \n const productId = await createProduct({\n name: productData.name,\n price: productData.price,\n stock: productData.stock || 0,\n category: productData.category,\n barcode: productData.barcode\n });\n \n return c.json({ \n success: true, \n data: { id: productId, ...productData } \n }, 201);\n } catch (error) {\n console.error(\"Error creating product:\", error);\n return c.json({ success: false, error: \"Failed to create product\" }, 500);\n }\n});\n\n// Update product (admin only)\nproducts.put(\"/:id\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n if (payload.role !== \"admin\") {\n return c.json({ success: false, error: \"Admin access required\" }, 403);\n }\n \n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid product ID\" }, 400);\n }\n \n const productData = await c.req.json();\n \n // Validate price and stock if provided\n if (productData.price !== undefined && (typeof productData.price !== \"number\" || productData.price < 0)) {\n return c.json({ success: false, error: \"Price must be a positive number\" }, 400);\n }\n \n if (productData.stock !== undefined && (typeof productData.stock !== \"number\" || productData.stock < 0)) {\n return c.json({ success: false, error: \"Stock must be a positive number\" }, 400);\n }\n \n const success = await updateProduct(id, productData);\n if (!success) {\n return c.json({ success: false, error: \"Product not found\" }, 404);\n }\n \n const updatedProduct = await getProductById(id);\n return c.json({ success: true, data: updatedProduct });\n } catch (error) {\n console.error(\"Error updating product:\", error);\n return c.json({ success: false, error: \"Failed to update product\" }, 500);\n }\n});\n\n// Delete product (admin only)\nproducts.delete(\"/:id\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n if (payload.role !== \"admin\") {\n return c.json({ success: false, error: \"Admin access required\" }, 403);\n }\n \n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid product ID\" }, 400);\n }\n \n const success = await deleteProduct(id);\n if (!success) {\n return c.json({ success: false, error: \"Product not found\" }, 404);\n }\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error deleting product:\", error);\n return c.json({ success: false, error: \"Failed to delete product\" }, 500);\n }\n});\n\n// Update product stock (admin only)\nproducts.patch(\"/:id/stock\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n if (payload.role !== \"admin\") {\n return c.json({ success: false, error: \"Admin access required\" }, 403);\n }\n \n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid product ID\" }, 400);\n }\n \n const { quantity } = await c.req.json();\n if (quantity === undefined || typeof quantity !== \"number\") {\n return c.json({ success: false, error: \"Quantity adjustment is required\" }, 400);\n }\n \n const success = await updateProductStock(id, quantity);\n if (!success) {\n return c.json({ \n success: false, \n error: \"Product not found or insufficient stock for removal\" \n }, 404);\n }\n \n const updatedProduct = await getProductById(id);\n return c.json({ success: true, data: updatedProduct });\n } catch (error) {\n console.error(\"Error updating product stock:\", error);\n return c.json({ success: false, error: \"Failed to update product stock\" }, 500);\n }\n});\n\nexport default products;",[],[152,196,220],{"_104":228,"_95":229,"_153":230,"_155":197,"_156":138,"_157":231,"_159":160,"_106":232,"_100":32,"_162":180,"_164":233,"_165":22,"_166":-5,"_167":234,"_98":235},"4214f918-358e-11f0-80be-9e149126039e","sales.ts","4214f9ea-358e-11f0-80be-9e149126039e",7,["D",1747754555873],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { createSale, getSaleById, getRecentSales } from \"../database/queries.ts\";\n\n// Secret key for JWT - in production, use an environment variable\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"pos-system-secret-key\";\n\nconst sales = new Hono();\n\n// Apply JWT middleware to all routes\nsales.use(\"*\", jwt({ secret: JWT_SECRET }));\n\n// Create a new sale\nsales.post(\"/\", async (c) => {\n try {\n const payload = c.get(\"jwtPayload\");\n const { items, paymentMethod } = await c.req.json();\n \n // Validate input\n if (!items || !Array.isArray(items) || items.length === 0) {\n return c.json({ success: false, error: \"Sale must include at least one item\" }, 400);\n }\n \n if (!paymentMethod || ![\"cash\", \"card\", \"other\"].includes(paymentMethod)) {\n return c.json({ success: false, error: \"Valid payment method is required\" }, 400);\n }\n \n // Validate each item\n for (const item of items) {\n if (!item.productId || typeof item.productId !== \"number\") {\n return c.json({ success: false, error: \"Each item must have a valid productId\" }, 400);\n }\n \n if (!item.quantity || typeof item.quantity !== \"number\" || item.quantity <= 0) {\n return c.json({ success: false, error: \"Each item must have a positive quantity\" }, 400);\n }\n }\n \n // Create the sale\n const saleId = await createSale(payload.id, items, paymentMethod);\n \n // Get the complete sale with items\n const sale = await getSaleById(saleId);\n \n return c.json({ success: true, data: sale }, 201);\n } catch (error) {\n console.error(\"Error creating sale:\", error);\n \n // Handle specific errors\n if (error.message && error.message.includes(\"Insufficient stock\")) {\n return c.json({ success: false, error: error.message }, 400);\n }\n \n return c.json({ success: false, error: \"Failed to create sale\" }, 500);\n }\n});\n\n// Get a sale by ID\nsales.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid sale ID\" }, 400);\n }\n \n const sale = await getSaleById(id);\n if (!sale) {\n return c.json({ success: false, error: \"Sale not found\" }, 404);\n }\n \n return c.json({ success: true, data: sale });\n } catch (error) {\n console.error(\"Error fetching sale:\", error);\n return c.json({ success: false, error: \"Failed to fetch sale\" }, 500);\n }\n});\n\n// Get recent sales\nsales.get(\"/\", async (c) => {\n try {\n const limit = c.req.query(\"limit\") ? parseInt(c.req.query(\"limit\")) : 20;\n \n const sales = await getRecentSales(limit);\n return c.json({ success: true, data: sales });\n } catch (error) {\n console.error(\"Error fetching sales:\", error);\n return c.json({ success: false, error: \"Failed to fetch sales\" }, 500);\n }\n});\n\nexport default sales;",[],[152,196,229],{"_104":237,"_95":238,"_153":239,"_155":197,"_156":138,"_157":101,"_159":160,"_106":240,"_100":32,"_162":180,"_164":241,"_165":22,"_166":-5,"_167":242,"_98":243},"4baa987a-358e-11f0-b3fc-9e149126039e","static.ts","4baa9a8c-358e-11f0-b3fc-9e149126039e",["D",1747754571954],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst static_routes = new Hono();\n\n// Serve the main HTML file\nstatic_routes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Add view source link\n const viewSourceUrl = import.meta.url.replace(\"esm.sh\", \"val.town\");\n const viewSourceScript = `\n \n `;\n \n html = html.replace(\"\", `${viewSourceScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\n// Serve frontend static files\nstatic_routes.get(\"/frontend/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve shared files\nstatic_routes.get(\"/shared/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\nexport default static_routes;",[],[152,196,238],[152,196],[152],{"_104":247,"_95":248,"_153":249,"_155":-5,"_156":138,"_157":250,"_159":160,"_106":251,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":252,"_98":261},"06a2aeca-358e-11f0-80bf-9e149126039e","shared","b32166be-5c6b-4454-a0f4-92c383c4d325",2,["D",1747754456134],[253],{"_104":254,"_95":255,"_153":256,"_155":249,"_156":138,"_157":250,"_159":160,"_106":257,"_100":32,"_162":180,"_164":258,"_165":22,"_166":-5,"_167":259,"_98":260},"06a28f3a-358e-11f0-80bf-9e149126039e","types.ts","06a2900c-358e-11f0-80bf-9e149126039e",["D",1747754456134],"// Shared types for the POS system\n\nexport interface Product {\n id: number;\n name: string;\n price: number;\n stock: number;\n category: string;\n barcode?: string;\n created_at: string;\n updated_at: string;\n}\n\nexport interface User {\n id: number;\n username: string;\n role: 'admin' | 'cashier';\n created_at: string;\n}\n\nexport interface SaleItem {\n id: number;\n sale_id: number;\n product_id: number;\n product_name: string;\n quantity: number;\n price_per_unit: number;\n total_price: number;\n}\n\nexport interface Sale {\n id: number;\n user_id: number;\n username: string;\n total_amount: number;\n payment_method: 'cash' | 'card' | 'other';\n created_at: string;\n items: SaleItem[];\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}\n\nexport interface DashboardStats {\n totalSales: number;\n totalRevenue: number;\n lowStockItems: number;\n topProducts: {\n name: string;\n quantity: number;\n }[];\n}",[],[248,255],[248],{"_104":263,"_95":264,"_153":265,"_155":-5,"_156":138,"_157":266,"_159":160,"_106":267,"_100":32,"_162":268,"_164":269,"_165":22,"_166":-5,"_167":270,"_98":271},"02c5da8e-358e-11f0-bd19-9e149126039e","README.md","02c5db4c-358e-11f0-bd19-9e149126039e",1,["D",1747754449658],"file","# Mobile-Friendly POS System\n\nA point of sale system with inventory management and sales tracking capabilities, optimized for mobile devices.\n\n## Features\n\n- Product inventory management\n- Sales tracking and history\n- User authentication\n- Receipt generation\n- Basic reporting\n- Mobile-friendly interface\n\n## Project Structure\n\n- `/backend` - Server API and database operations\n- `/frontend` - User interface components and pages\n- `/shared` - Shared types and utilities\n\n## Getting Started\n\nAccess the POS system by visiting the HTTP endpoint of this Val.\n\n## Technologies Used\n\n- Backend: Hono (API framework), SQLite (database)\n- Frontend: React, TailwindCSS\n- Shared: TypeScript for type definitions",[],[264],"files",[150,169,175,184,194,201,209,218,227,236,246,253,262],"counts",{"_276":32,"_277":266,"_278":32,"_279":32},"pulls","branches","forks","envVars","contents",[],{"_104":237,"_95":238,"_153":239,"_155":197,"_156":138,"_157":101,"_159":160,"_106":283,"_100":32,"_162":180,"_164":241,"_165":22,"_166":-5,"_98":284},["D",1747754571954],[152,196,238],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":293,"_148":298,"_272":338,"_268":339,"_280":341,"_342":-5,"_343":22,"_344":-5,"_345":-5,"_346":-5,"_347":348},{"_104":105,"_95":96,"_106":294,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":295,"_132":296,"_135":297,"_147":22},["D",1747754319784],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[299,329,335],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":160,"_106":161,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":300,"_98":328},[301,310],{"_104":170,"_95":171,"_153":172,"_155":154,"_156":138,"_157":158,"_159":160,"_106":173,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":302,"_98":309},[303,306],{"_104":176,"_95":177,"_153":178,"_155":172,"_156":138,"_157":158,"_159":22,"_106":179,"_100":32,"_162":180,"_164":181,"_165":22,"_166":-5,"_167":304,"_98":305},[],[152,171,177],{"_104":185,"_95":186,"_153":187,"_155":172,"_156":138,"_157":188,"_159":160,"_106":189,"_100":32,"_162":180,"_164":190,"_165":22,"_166":-5,"_167":307,"_98":308},[],[152,171,186],[152,171],{"_104":195,"_95":196,"_153":197,"_155":154,"_156":138,"_157":198,"_159":160,"_106":199,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":311,"_98":327},[312,315,318,321,324],{"_104":202,"_95":203,"_153":204,"_155":197,"_156":138,"_157":198,"_159":160,"_106":205,"_100":32,"_162":180,"_164":206,"_165":22,"_166":-5,"_167":313,"_98":314},[],[152,196,203],{"_104":210,"_95":211,"_153":212,"_155":197,"_156":138,"_157":213,"_159":160,"_106":214,"_100":32,"_162":180,"_164":215,"_165":22,"_166":-5,"_167":316,"_98":317},[],[152,196,211],{"_104":219,"_95":220,"_153":221,"_155":197,"_156":138,"_157":222,"_159":160,"_106":223,"_100":32,"_162":180,"_164":224,"_165":22,"_166":-5,"_167":319,"_98":320},[],[152,196,220],{"_104":228,"_95":229,"_153":230,"_155":197,"_156":138,"_157":231,"_159":160,"_106":232,"_100":32,"_162":180,"_164":233,"_165":22,"_166":-5,"_167":322,"_98":323},[],[152,196,229],{"_104":237,"_95":238,"_153":239,"_155":197,"_156":138,"_157":101,"_159":160,"_106":240,"_100":32,"_162":180,"_164":241,"_165":22,"_166":-5,"_167":325,"_98":326},[],[152,196,238],[152,196],[152],{"_104":247,"_95":248,"_153":249,"_155":-5,"_156":138,"_157":250,"_159":160,"_106":251,"_100":32,"_162":163,"_164":-5,"_165":22,"_166":-5,"_167":330,"_98":334},[331],{"_104":254,"_95":255,"_153":256,"_155":249,"_156":138,"_157":250,"_159":160,"_106":257,"_100":32,"_162":180,"_164":258,"_165":22,"_166":-5,"_167":332,"_98":333},[],[248,255],[248],{"_104":263,"_95":264,"_153":265,"_155":-5,"_156":138,"_157":266,"_159":160,"_106":267,"_100":32,"_162":268,"_164":269,"_165":22,"_166":-5,"_167":336,"_98":337},[],[264],[299,301,303,306,310,312,315,318,321,324,329,331,335],{"_104":237,"_95":238,"_153":239,"_155":197,"_156":138,"_157":101,"_159":160,"_106":283,"_100":32,"_162":180,"_164":241,"_165":22,"_166":-5,"_98":340},[152,196,238],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]