[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_327":328,"_329":330},"routes/_app.x.$handle.$name",{"_103":102,"_37":48,"_112":93,"_32":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":30,"_127":128,"_129":62,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",11,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","a2fb862c-03cd-4ef7-9d7e-df8dbd700617","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","API_DOCUMENTATION.md","latestPath","fileId","6c0443ee-a0f1-11f1-8935-1607ee4eb77e","name","fileType","content","# 📡 API Documentation - Perfume POS UAE\n\n## Base URL\n```\nhttps://perfume-pos-uae.val.run\n```\n\nAll endpoints return JSON. Timestamps are in ISO 8601 format.\n\n---\n\n## 🛍️ Product Endpoints\n\n### Get All Products\n```http\nGET /api/products\n```\n\n**Response (200 OK):**\n```json\n[\n {\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"sku\": \"OUD001\",\n \"category\": \"Oud\",\n \"price\": 450,\n \"stock\": 100\n },\n {\n \"id\": 2,\n \"name\": \"Rose Oud\",\n \"sku\": \"OUD002\",\n \"category\": \"Oud\",\n \"price\": 350,\n \"stock\": 100\n }\n]\n```\n\n**cURL Example:**\n```bash\ncurl https://perfume-pos-uae.val.run/api/products\n```\n\n---\n\n### Get Product by ID\n```http\nGET /api/products/{id}\n```\n\n**Parameters:**\n- `id` (path) - Product ID (integer)\n\n**Response (200 OK):**\n```json\n{\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"sku\": \"OUD001\",\n \"category\": \"Oud\",\n \"price\": 450,\n \"cost\": 200,\n \"stock\": 100,\n \"description\": null\n}\n```\n\n**Response (404 Not Found):**\n```json\n{\n \"error\": \"Product not found\"\n}\n```\n\n**cURL Example:**\n```bash\ncurl https://perfume-pos-uae.val.run/api/products/1\n```\n\n---\n\n## 💳 Sales Endpoints\n\n### Create Sale Transaction\n```http\nPOST /api/sales\nContent-Type: application/json\n```\n\n**Request Body:**\n```json\n{\n \"items\": [\n {\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"price\": 450,\n \"quantity\": 2\n },\n {\n \"id\": 3,\n \"name\": \"Musk Al Noor\",\n \"price\": 280,\n \"quantity\": 1\n }\n ],\n \"paymentMethod\": \"cash\"\n}\n```\n\n**Response (200 OK):**\n```json\n{\n \"success\": true,\n \"transactionId\": \"TXN-1692984000000\",\n \"total\": 1444.5,\n \"subtotal\": 1180,\n \"vatAmount\": 59,\n \"itemCount\": 2\n}\n```\n\n**Response (400 Bad Request):**\n```json\n{\n \"error\": \"No items in cart\"\n}\n```\n\n**Response (500 Internal Server Error):**\n```json\n{\n \"error\": \"Failed to process sale\"\n}\n```\n\n**cURL Example:**\n```bash\ncurl -X POST https://perfume-pos-uae.val.run/api/sales \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"items\": [\n {\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"price\": 450,\n \"quantity\": 1\n }\n ],\n \"paymentMethod\": \"card\"\n }'\n```\n\n**Notes:**\n- VAT is automatically calculated at 5%\n- Inventory is reduced immediately\n- Transaction ID is generated automatically\n- All items must have valid IDs\n- Payment methods: \"cash\", \"card\", \"transfer\"\n\n---\n\n## 📊 Report Endpoints\n\n### Get Sales Report\n```http\nGET /api/reports/sales\n```\n\n**Query Parameters:**\n- `startDate` (optional) - Start date (YYYY-MM-DD format)\n- `endDate` (optional) - End date (YYYY-MM-DD format)\n\n**Response (200 OK):**\n```json\n{\n \"sales\": [\n {\n \"id\": 1,\n \"transactionId\": \"TXN-1692984000000\",\n \"total\": 1444.5,\n \"subtotal\": 1180,\n \"vatAmount\": 64.5,\n \"paymentMethod\": \"cash\",\n \"createdAt\": \"2026-08-26T01:56:14.000Z\"\n }\n ],\n \"summary\": {\n \"transactionCount\": 1,\n \"totalRevenue\": 1444.5,\n \"totalVat\": 64.5\n }\n}\n```\n\n**cURL Examples:**\n```bash\n# All sales\ncurl https://perfume-pos-uae.val.run/api/reports/sales\n\n# Sales for specific date\ncurl \"https://perfume-pos-uae.val.run/api/reports/sales?startDate=2026-08-26&endDate=2026-08-26\"\n\n# Sales for date range\ncurl \"https://perfume-pos-uae.val.run/api/reports/sales?startDate=2026-08-01&endDate=2026-08-31\"\n```\n\n---\n\n## 📦 Inventory Endpoints\n\n### Get Inventory Status\n```http\nGET /api/inventory\n```\n\n**Response (200 OK):**\n```json\n{\n \"products\": [\n {\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"sku\": \"OUD001\",\n \"category\": \"Oud\",\n \"price\": 450,\n \"stock\": 98\n }\n ],\n \"stats\": {\n \"totalProducts\": 6,\n \"lowStockItems\": 0,\n \"lowStockList\": []\n }\n}\n```\n\n**cURL Example:**\n```bash\ncurl https://perfume-pos-uae.val.run/api/inventory\n```\n\n**Notes:**\n- Low stock threshold is 20 units\n- `lowStockList` contains products below threshold\n- Stock reflects all sales and adjustments\n\n---\n\n### Update Stock\n```http\nPOST /api/inventory/stock\nContent-Type: application/json\n```\n\n**Request Body:**\n```json\n{\n \"productId\": 1,\n \"quantity\": 50,\n \"type\": \"adjustment\",\n \"reference\": \"REORDER-2026-08-26\"\n}\n```\n\n**Response (200 OK):**\n```json\n{\n \"success\": true\n}\n```\n\n**Response (500 Internal Server Error):**\n```json\n{\n \"error\": \"Failed to update stock\"\n}\n```\n\n**cURL Example:**\n```bash\n# Add stock\ncurl -X POST https://perfume-pos-uae.val.run/api/inventory/stock \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"productId\": 1,\n \"quantity\": 50,\n \"type\": \"restock\",\n \"reference\": \"PO-2026-001\"\n }'\n\n# Reduce stock for damage/shrinkage\ncurl -X POST https://perfume-pos-uae.val.run/api/inventory/stock \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"productId\": 1,\n \"quantity\": -5,\n \"type\": \"adjustment\",\n \"reference\": \"DAMAGED-2026-08-26\"\n }'\n```\n\n**Notes:**\n- Use positive numbers to add stock\n- Use negative numbers to subtract stock\n- Type can be: \"adjustment\", \"restock\", \"return\", \"damage\", etc.\n- Reference is optional but recommended for audit trail\n\n---\n\n## 📈 Dashboard Endpoints\n\n### Get Dashboard Statistics\n```http\nGET /api/dashboard\n```\n\n**Response (200 OK):**\n```json\n{\n \"todaysSales\": 1444.5,\n \"todaysTransactions\": 1,\n \"lowStockAlert\": 0,\n \"totalProducts\": 6\n}\n```\n\n**cURL Example:**\n```bash\ncurl https://perfume-pos-uae.val.run/api/dashboard\n```\n\n---\n\n## 🔄 Data Models\n\n### Product Object\n```json\n{\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"sku\": \"OUD001\",\n \"category\": \"Oud\",\n \"price\": 450,\n \"cost\": 200,\n \"stock\": 100,\n \"description\": null,\n \"barcode\": null,\n \"createdAt\": \"2026-08-26T01:56:14.000Z\",\n \"updatedAt\": \"2026-08-26T01:56:14.000Z\"\n}\n```\n\n### Sale Object\n```json\n{\n \"id\": 1,\n \"transactionId\": \"TXN-1692984000000\",\n \"total\": 1444.5,\n \"subtotal\": 1380,\n \"vatAmount\": 64.5,\n \"paymentMethod\": \"cash\",\n \"status\": \"completed\",\n \"createdAt\": \"2026-08-26T01:56:14.000Z\"\n}\n```\n\n### Cart Item Object (Client-side)\n```json\n{\n \"id\": 1,\n \"name\": \"Oud Al Amerat\",\n \"price\": 450,\n \"quantity\": 2\n}\n```\n\n---\n\n## 🔐 Error Handling\n\nAll errors return appropriate HTTP status codes:\n\n### 400 Bad Request\nSent when request data is invalid:\n```json\n{\n \"error\": \"No items in cart\"\n}\n```\n\n### 404 Not Found\nSent when resource doesn't exist:\n```json\n{\n \"error\": \"Product not found\"\n}\n```\n\n### 500 Internal Server Error\nSent when server encounters an error:\n```json\n{\n \"error\": \"Failed to process sale\"\n}\n```\n\n---\n\n## 📋 Payment Methods\n\nValid payment methods for sales:\n- `\"cash\"` - Cash payment\n- `\"card\"` - Credit/Debit card\n- `\"transfer\"` - Bank transfer\n\n---\n\n## 🔍 Filtering & Searching\n\n### By Category\nProducts are automatically categorized. Available categories:\n- Oud\n- Musk\n- Attar\n- Agarwood\n- Water\n\nFilter in frontend by clicking category buttons.\n\n### By Date Range\nSales reports support date filtering:\n```bash\ncurl \"https://perfume-pos-uae.val.run/api/reports/sales?startDate=2026-08-01&endDate=2026-08-31\"\n```\n\n### By SKU/Name\nSearch is performed client-side in the product catalog.\n\n---\n\n## 📊 Common Queries\n\n### Get all Oud products\n```bash\ncurl https://perfume-pos-uae.val.run/api/products | jq '.[] | select(.category==\"Oud\")'\n```\n\n### Get low stock items\n```bash\ncurl https://perfume-pos-uae.val.run/api/inventory | jq '.lowStockList'\n```\n\n### Get total sales revenue\n```bash\ncurl https://perfume-pos-uae.val.run/api/reports/sales | jq '.summary.totalRevenue'\n```\n\n### Get all transactions by payment method\n```bash\ncurl https://perfume-pos-uae.val.run/api/reports/sales | jq '.sales[] | select(.paymentMethod==\"cash\")'\n```\n\n---\n\n## ⚠️ Rate Limiting\n\nNo rate limiting is currently implemented. Recommended:\n- Max 100 requests per minute per IP\n- Database queries are optimized for performance\n- Bulk operations may need pagination (future feature)\n\n---\n\n## 🔐 Authentication\n\nCurrently, no authentication is required. For future implementation:\n- PIN-based authentication for cashiers\n- API token authentication for integrations\n- Role-based access control\n\n---\n\n## 📝 Notes\n\n- All timestamps are UTC\n- Prices are in AED (Arab Emirates Dirham)\n- VAT is always 5%\n- Database auto-initializes on first request\n- Changes are persisted immediately\n- No transaction rollback on failure (use try-catch in client)\n\n---\n\n## 🆘 Troubleshooting\n\n### Products not loading\n1. Check `/api/products` returns 200\n2. Verify database initialized\n3. Check browser console for errors\n\n### Sales not processing\n1. Verify all items have valid IDs\n2. Check product stock is not 0\n3. Verify network request completed\n\n### Inventory not updating\n1. Check `/api/inventory` after sale\n2. Verify stock adjustment POST returns success\n3. Review inventory movement logs\n\n### Reports showing no data\n1. Verify sales have been processed\n2. Check date range parameters\n3. Try query without date filters\n\n---\n\n**For more details, see [README.md](README.md) and [QUICK_START.md](QUICK_START.md)**\n","createdAt",["D",1787709418488],"branchVersion","branchId","ca6acab9-0471-47bf-83e1-d0aa1c2b75bf","id","541ded6a-9f5e-41f6-b1f6-b7ac30b25722","perfume-pos-uae",["D",1787709252059],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-stack POS for UAE perfume retail with inventory & payments","imageUrl","46851fd6-9a47-485b-8891-db89cbf86507","pinnedFileId","01a03bc6-6207-76cc-b747-3d47da3fc315","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03bc5-1b35-7460-96e1-c82089aa770e","tursoName","541ded6a9f5e41f6b1f6b7ac30b25722","tursoHostname","541ded6a9f5e41f6b1f6b7ac30b25722-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789534231467],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_19":58,"_108":109,"_110":30},"branch",{"_13":92,"_37":93,"_46":45,"_94":47,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":48,"_101":102},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jinzstallionz","handle","displayName","Jinz Stallionz","avatar","https://lh3.googleusercontent.com/a/ACg8ocJAWTrFwG6txw3q-fFuNNMyVL9mI_GhIdB1yzX9tJIknRmFMh3P=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":322,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":323,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":324,"_87":325,"_89":326,"_91":30},"tree",[205,207,217,218,219,220,221,222],"files",[205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222],"counts",{"_195":66,"_196":148,"_197":66,"_198":199,"_200":201},"contents",[134,135,136,137,138,139,140,141],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_46":189,"_37":190,"_35":191,"_144":-5,"_44":45,"_43":192,"_146":62,"_41":193,"_13":66,"_38":187,"_39":-5,"_29":30,"_151":-5,"_32":194},{"_46":183,"_37":184,"_35":185,"_144":-5,"_44":45,"_43":148,"_146":62,"_41":186,"_13":66,"_38":187,"_39":-5,"_29":30,"_151":-5,"_32":188},{"_46":180,"_37":33,"_35":36,"_144":-5,"_44":45,"_43":14,"_146":62,"_41":181,"_13":66,"_38":26,"_39":40,"_29":30,"_151":-5,"_32":182},{"_46":174,"_37":175,"_35":176,"_144":-5,"_44":45,"_43":148,"_146":62,"_41":177,"_13":66,"_38":26,"_39":178,"_29":30,"_151":-5,"_32":179},{"_46":167,"_37":168,"_35":169,"_144":-5,"_44":45,"_43":170,"_146":62,"_41":171,"_13":66,"_38":26,"_39":172,"_29":30,"_151":-5,"_32":173},{"_46":160,"_37":161,"_35":162,"_144":-5,"_44":45,"_43":163,"_146":62,"_41":164,"_13":66,"_38":26,"_39":165,"_29":30,"_151":-5,"_32":166},{"_46":153,"_37":154,"_35":155,"_144":-5,"_44":45,"_43":156,"_146":62,"_41":157,"_13":148,"_38":26,"_39":158,"_29":30,"_151":-5,"_32":159},{"_46":142,"_37":143,"_35":60,"_144":-5,"_44":45,"_43":145,"_146":62,"_41":147,"_13":148,"_38":149,"_39":150,"_29":30,"_151":48,"_32":152},"559192ea-7a12-4b59-918c-50f8dbc62ef0","index.ts","parentId",7,"latest",["D",1787709313189],1,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initializeDatabase, seedDemoData } from \"./db/schema.ts\";\n\nconst app = new Hono();\n\n// Initialize database on startup\nlet dbInitialized = false;\n\nconst ensureDatabase = async () => {\n if (!dbInitialized) {\n await initializeDatabase();\n await seedDemoData();\n dbInitialized = true;\n }\n};\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ===== API ENDPOINTS =====\n\n// Get all products\napp.get(\"/api/products\", async (c) => {\n await ensureDatabase();\n const result = await sqlite.execute(\"SELECT id, name, sku, category, price, stock FROM products ORDER BY category, name\");\n return c.json(result.rows);\n});\n\n// Get product by ID\napp.get(\"/api/products/:id\", async (c) => {\n await ensureDatabase();\n const id = c.req.param(\"id\");\n const result = await sqlite.execute(\n \"SELECT id, name, sku, category, price, cost, stock, description FROM products WHERE id = ?\",\n [id]\n );\n if (result.rows.length === 0) {\n return c.json({ error: \"Product not found\" }, 404);\n }\n return c.json(result.rows[0]);\n});\n\n// Create sale transaction\napp.post(\"/api/sales\", async (c) => {\n await ensureDatabase();\n \n const body = await c.req.json() as any;\n const { items, paymentMethod } = body;\n\n if (!items || items.length === 0) {\n return c.json({ error: \"No items in cart\" }, 400);\n }\n\n try {\n // Calculate totals\n let subtotal = 0;\n for (const item of items) {\n subtotal += item.price * item.quantity;\n }\n const vatAmount = subtotal * 0.05;\n const total = subtotal + vatAmount;\n const transactionId = `TXN-${Date.now()}`;\n\n // Insert sale\n const saleResult = await sqlite.execute(\n `INSERT INTO sales (transactionId, total, subtotal, vatAmount, paymentMethod) \n VALUES (?, ?, ?, ?, ?)`,\n [transactionId, total, subtotal, vatAmount, paymentMethod]\n );\n\n const saleId = saleResult.lastInsertRowid;\n\n // Insert sale items and update inventory\n for (const item of items) {\n // Insert sale item\n await sqlite.execute(\n `INSERT INTO sale_items (saleId, productId, quantity, unitPrice, lineTotal) \n VALUES (?, ?, ?, ?, ?)`,\n [saleId, item.id, item.quantity, item.price, item.price * item.quantity]\n );\n\n // Update product stock\n await sqlite.execute(\n \"UPDATE products SET stock = stock - ? WHERE id = ?\",\n [item.quantity, item.id]\n );\n\n // Log inventory movement\n await sqlite.execute(\n \"INSERT INTO inventory (productId, quantity, type, reference) VALUES (?, ?, ?, ?)\",\n [item.id, item.quantity, \"sale\", transactionId]\n );\n }\n\n return c.json({\n success: true,\n transactionId,\n total,\n subtotal,\n vatAmount,\n itemCount: items.length,\n });\n } catch (error) {\n console.error(\"Sale error:\", error);\n return c.json({ error: \"Failed to process sale\" }, 500);\n }\n});\n\n// Get sales report (by date range)\napp.get(\"/api/reports/sales\", async (c) => {\n await ensureDatabase();\n \n const startDate = c.req.query(\"startDate\");\n const endDate = c.req.query(\"endDate\");\n\n let query = \"SELECT id, transactionId, total, subtotal, vatAmount, paymentMethod, createdAt FROM sales WHERE 1=1\";\n const params: any[] = [];\n\n if (startDate) {\n query += \" AND DATE(createdAt) >= DATE(?)\";\n params.push(startDate);\n }\n\n if (endDate) {\n query += \" AND DATE(createdAt) <= DATE(?)\";\n params.push(endDate);\n }\n\n query += \" ORDER BY createdAt DESC\";\n\n const result = await sqlite.execute(query, params);\n\n // Calculate totals\n const totalSales = (result.rows as any[]).reduce((sum, row) => sum + row.total, 0);\n const totalVat = (result.rows as any[]).reduce((sum, row) => sum + row.vatAmount, 0);\n\n return c.json({\n sales: result.rows,\n summary: {\n transactionCount: result.rows.length,\n totalRevenue: totalSales,\n totalVat,\n },\n });\n});\n\n// Get inventory status\napp.get(\"/api/inventory\", async (c) => {\n await ensureDatabase();\n \n const result = await sqlite.execute(\n \"SELECT id, name, sku, category, price, stock FROM products ORDER BY category, name\"\n );\n\n const lowStock = (result.rows as any[]).filter((p) => p.stock < 20);\n\n return c.json({\n products: result.rows,\n stats: {\n totalProducts: result.rows.length,\n lowStockItems: lowStock.length,\n lowStockList: lowStock,\n },\n });\n});\n\n// Update product stock (for inventory management)\napp.post(\"/api/inventory/stock\", async (c) => {\n await ensureDatabase();\n \n const body = await c.req.json() as any;\n const { productId, quantity, type, reference } = body;\n\n try {\n // Update stock\n await sqlite.execute(\n \"UPDATE products SET stock = stock + ? WHERE id = ?\",\n [quantity, productId]\n );\n\n // Log inventory movement\n await sqlite.execute(\n \"INSERT INTO inventory (productId, quantity, type, reference) VALUES (?, ?, ?, ?)\",\n [productId, quantity, type, reference || null]\n );\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Stock update error:\", error);\n return c.json({ error: \"Failed to update stock\" }, 500);\n }\n});\n\n// Get dashboard stats\napp.get(\"/api/dashboard\", async (c) => {\n await ensureDatabase();\n \n // Today's sales\n const todaySales = await sqlite.execute(\n \"SELECT SUM(total) as total, COUNT(*) as count FROM sales WHERE DATE(createdAt) = DATE('now')\"\n );\n\n // Low stock products\n const lowStock = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM products WHERE stock < 20\"\n );\n\n // Total products\n const totalProducts = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM products\"\n );\n\n return c.json({\n todaysSales: (todaySales.rows[0] as any)?.total || 0,\n todaysTransactions: (todaySales.rows[0] as any)?.count || 0,\n lowStockAlert: (lowStock.rows[0] as any).count,\n totalProducts: (totalProducts.rows[0] as any).count,\n });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;\n","label",[143],"0fa28590-f0d1-4b05-8555-56d33d5e83fe","README.md","01a03bc6-6207-76cc-b747-38367f9b29fe",8,["D",1787709354493],"# 🌹 Perfume POS UAE - Full Stack System\n\nA complete **Point of Sale (POS) system** built for perfume retail in the United Arab Emirates. Full-stack web and mobile-responsive application with inventory management, sales tracking, VAT calculation, and comprehensive reporting.\n\n## ✨ Features\n\n### 🛍️ **Sales & Checkout**\n- Product catalog with search and filtering by category\n- Real-time inventory display (stock levels)\n- Shopping cart management with quantity adjustment\n- Multiple payment methods (Cash, Card, Bank Transfer)\n- Automatic 5% VAT calculation (UAE compliant)\n- Transaction ID generation for every sale\n- Immediate inventory reduction on purchase\n\n### 📦 **Inventory Management**\n- Real-time stock tracking\n- Low stock alerts (items below 20 units)\n- Inventory history and movement logs\n- Stock adjustment interface for receiving/adjustments\n- Categorized product organization\n- Product details: SKU, cost, selling price, description\n\n### 📊 **Reporting & Analytics**\n- Daily sales reports\n- Date range filtering for sales history\n- Transaction summaries with VAT breakdown\n- Inventory status dashboard\n- Sales statistics and trends\n- Revenue tracking by payment method\n\n### 🎨 **UI/UX**\n- **Fully responsive design** - Works on desktop, tablet, and mobile\n- Twind/Tailwind CSS styling\n- Real-time updates\n- Clean, intuitive interface\n- Arabic-ready UI (component structure prepared)\n- Professional typography and spacing\n\n### 🔐 **Data Management**\n- SQLite database for reliable data storage\n- Transactional integrity for sales\n- Complete audit trail via inventory logs\n- Multi-user support structure (ready for expansion)\n- Indexed queries for performance\n\n## 🏗️ Architecture\n\n```\nperfume-pos-uae/\n├── index.ts # Hono HTTP server with API endpoints\n├── db/\n│ └── schema.ts # Database initialization and demo data\n├── frontend/\n│ ├── index.tsx # React app entry point\n│ ├── root.tsx # HTML shell with asset loading\n│ ├── favicon.svg # App icon\n│ └── components/\n│ ├── App.tsx # Main app layout\n│ ├── ProductCatalog.tsx # Product display & search\n│ ├── Cart.tsx # Shopping cart interface\n│ └── Checkout.tsx # Payment processing UI\n└── README.md # Documentation\n```\n\n## 🚀 Getting Started\n\n### Live Demo\nThe app loads with 6 demo perfume products:\n- **Oud Al Amerat** (AED 450)\n- **Rose Oud** (AED 350)\n- **Musk Al Noor** (AED 280)\n- **Attar Al Khaleej** (AED 320)\n- **Agarwood Premium** (AED 550)\n- **Rose Water** (AED 150)\n\nAll products have 100 units in stock initially.\n\n### Quick Start\n1. Visit the live application URL\n2. Browse products by category or search by name/SKU\n3. Add items to cart\n4. Click \"Checkout\" to complete a sale\n5. Choose payment method and confirm\n\n## 📡 API Endpoints\n\n### Products\n```\nGET /api/products # All products with stock\nGET /api/products/:id # Single product details\n```\n\n### Sales\n```\nPOST /api/sales # Create new sale transaction\n Body: { items: [{id, name, price, quantity}], paymentMethod }\n```\n\n### Inventory\n```\nGET /api/inventory # All products with low stock alerts\nPOST /api/inventory/stock # Update stock (receive/adjust)\n Body: { productId, quantity, type, reference }\n```\n\n### Reports\n```\nGET /api/reports/sales # Sales report with filtering\n Query: ?startDate=2026-08-01&endDate=2026-08-31\n```\n\n### Dashboard\n```\nGET /api/dashboard # Stats: today's sales, low stock alerts, totals\n```\n\n## 💾 Database Schema\n\n### Products\n- `id`, `name`, `sku` (unique), `category`, `price`, `cost`, `stock`\n- `description`, `barcode` (for future barcode scanning)\n- Timestamps for tracking\n\n### Sales\n- `id`, `transactionId` (unique), `total`, `subtotal`, `vatAmount`\n- `paymentMethod` (cash, card, transfer)\n- `status`, `createdAt`\n\n### Sale Items (Line Items)\n- Links products to sales with quantity and pricing\n- Stores unit price at time of sale (prevents price change conflicts)\n- Discount field for promotions\n\n### Inventory Log\n- Tracks all stock movements (sales, adjustments, returns)\n- References transaction IDs for traceability\n- Type: \"sale\", \"adjustment\", \"return\", etc.\n\n### Users\n- Structure for multi-user support\n- PIN-based authentication (expandable)\n- Roles: admin, cashier (ready for implementation)\n\n## 🔧 Tech Stack\n\n- **Frontend:** React 18 with TypeScript\n- **Backend:** Hono (lightweight HTTP framework)\n- **Database:** SQLite (Val Town's std/sqlite)\n- **Styling:** Twind (Tailwind CSS runtime)\n- **Runtime:** Deno (on Val Town)\n\n## 💡 Customization\n\n### Adding New Products\nEdit `db/schema.ts` `seedDemoData()` function or use admin panel (future feature)\n\n### Changing VAT Rate\nVAT is calculated as 5% in:\n- `frontend/components/Cart.tsx` (line with `subtotal * 0.05`)\n- `frontend/components/Checkout.tsx` (same calculation)\n- `index.ts` `/api/sales` endpoint\n\nChange `0.05` to your desired rate everywhere.\n\n### Adding Categories\nCategories are auto-detected from products. Add new products with new category names.\n\n### Payment Methods\nUpdate the `

Diff · v11