Beaded Bags Boutique - Handcrafted Elegance

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_276":277,"_278":279},"routes/_app.x.$handle.$name",{"_94":93,"_31":43,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/style.css","latestPath","fileId","7ef623f8-3f9c-11f0-b27f-76b3cceeab13","name","style.css","fileType","content","/* Custom styles for Beaded Bags Boutique */\n\n/* Smooth scrolling */\nhtml {\n scroll-behavior: smooth;\n}\n\n/* Custom gradient backgrounds */\n.gradient-bg {\n background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);\n}\n\n.gradient-purple {\n background: linear-gradient(135deg, #a855f7 0%, #ec4899 100%);\n}\n\n/* Product card hover effects */\n.product-card {\n transition: all 0.3s ease;\n}\n\n.product-card:hover {\n transform: translateY(-4px);\n box-shadow: 0 20px 25px -5px rgba(0, 0, 0, 0.1), 0 10px 10px -5px rgba(0, 0, 0, 0.04);\n}\n\n/* Cart animation */\n.cart-bounce {\n animation: cartBounce 0.6s ease-in-out;\n}\n\n@keyframes cartBounce {\n 0%, 20%, 50%, 80%, 100% {\n transform: translateY(0);\n }\n 40% {\n transform: translateY(-10px);\n }\n 60% {\n transform: translateY(-5px);\n }\n}\n\n/* Button hover effects */\n.btn-primary {\n background: linear-gradient(135deg, #8b5cf6 0%, #a855f7 100%);\n transition: all 0.3s ease;\n}\n\n.btn-primary:hover {\n background: linear-gradient(135deg, #7c3aed 0%, #9333ea 100%);\n transform: translateY(-1px);\n box-shadow: 0 10px 15px -3px rgba(139, 92, 246, 0.3);\n}\n\n/* Loading shimmer effect */\n.shimmer {\n background: linear-gradient(90deg, #f0f0f0 25%, #e0e0e0 50%, #f0f0f0 75%);\n background-size: 200% 100%;\n animation: shimmer 1.5s infinite;\n}\n\n@keyframes shimmer {\n 0% {\n background-position: -200% 0;\n }\n 100% {\n background-position: 200% 0;\n }\n}\n\n/* Custom scrollbar */\n::-webkit-scrollbar {\n width: 8px;\n}\n\n::-webkit-scrollbar-track {\n background: #f1f1f1;\n}\n\n::-webkit-scrollbar-thumb {\n background: #c1c1c1;\n border-radius: 4px;\n}\n\n::-webkit-scrollbar-thumb:hover {\n background: #a1a1a1;\n}\n\n/* Form focus styles */\n.form-input:focus {\n outline: none;\n border-color: #8b5cf6;\n box-shadow: 0 0 0 3px rgba(139, 92, 246, 0.1);\n}\n\n/* Badge styles */\n.badge {\n display: inline-flex;\n align-items: center;\n padding: 0.25rem 0.75rem;\n border-radius: 9999px;\n font-size: 0.75rem;\n font-weight: 500;\n text-transform: uppercase;\n letter-spacing: 0.05em;\n}\n\n.badge-success {\n background-color: #dcfce7;\n color: #166534;\n}\n\n.badge-warning {\n background-color: #fef3c7;\n color: #92400e;\n}\n\n.badge-info {\n background-color: #dbeafe;\n color: #1e40af;\n}\n\n/* Mobile responsive adjustments */\n@media (max-width: 640px) {\n .product-grid {\n grid-template-columns: repeat(1, 1fr);\n }\n \n .cart-sidebar {\n width: 100%;\n height: 100%;\n }\n}\n\n/* Print styles */\n@media print {\n .no-print {\n display: none !important;\n }\n}","createdAt",["D",1748860182594],"branchVersion","branchId","03abe386-3f9c-11f0-b85d-76b3cceeab13","id","03ab8daa-3f9c-11f0-b85d-76b3cceeab13","Beadebag",["D",1748859975748],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","60ebba60-3f8f-11f0-b6e9-ab0b2f88b858","pinnedFileId","6ea28bc2-3f9c-11f0-8902-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","2243bf8b-8ef5-4c18-918d-14c6707a7329","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","gracie1","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2NId3R5cW9NN3ByZ08wZ3dpeWJJU1lTWSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":272,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":273,"_78":274,"_80":275,"_82":24},"tree",[167,176,179,181],"files",[167,168,169,170,171,172,173,174,175,176,177,178,179,180,181],"counts",{"_157":60,"_158":132,"_159":60,"_160":161,"_162":163},"contents",[124,125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":151,"_31":152,"_29":153,"_131":-5,"_39":40,"_38":154,"_133":56,"_36":155,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_26":156},{"_41":145,"_31":146,"_29":147,"_131":-5,"_39":40,"_38":148,"_133":56,"_36":149,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_26":150},{"_41":138,"_31":139,"_29":140,"_131":-5,"_39":40,"_38":141,"_133":56,"_36":142,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_26":144},{"_41":128,"_31":129,"_29":130,"_131":-5,"_39":40,"_38":132,"_133":56,"_36":134,"_13":60,"_33":20,"_34":135,"_23":24,"_136":-5,"_26":137},"35cf52b2-3f9c-11f0-afa4-76b3cceeab13","README.md","35cf5384-3f9c-11f0-afa4-76b3cceeab13","parentId",1,"latest",["D",1748860059863],"# Beaded Bags E-commerce Website\n\nA complete e-commerce platform for selling handcrafted beaded bags with shopping cart functionality, order management, and customer features.\n\n## Features\n\n- **Product Catalog**: Browse beautiful beaded bags with detailed descriptions and images\n- **Shopping Cart**: Add/remove items, adjust quantities, view totals\n- **Customer Orders**: Place orders with contact information\n- **Admin Panel**: Manage products and view orders (basic implementation)\n- **Responsive Design**: Works on desktop and mobile devices\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── products.ts # Product API endpoints\n│ │ ├── orders.ts # Order API endpoints\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React application\n│ │ ├── ProductCard.tsx # Individual product display\n│ │ ├── Cart.tsx # Shopping cart component\n│ │ └── OrderForm.tsx # Checkout form\n│ ├── index.html # Main HTML template\n│ ├── index.tsx # Frontend entry point\n│ └── style.css # Custom styles\n├── shared/\n│ └── types.ts # Shared TypeScript types\n└── README.md\n```\n\n## Technology Stack\n\n- **Backend**: Hono (TypeScript API framework)\n- **Frontend**: React 18.2.0 with TypeScript\n- **Database**: SQLite for product and order storage\n- **Styling**: TailwindCSS\n- **Deployment**: Val Town platform\n\n## Getting Started\n\n1. The backend automatically sets up the database on first run\n2. Sample beaded bag products are pre-loaded\n3. Visit the main page to start shopping\n4. Add items to cart and proceed to checkout\n\n## API Endpoints\n\n- `GET /api/products` - Get all products\n- `POST /api/products` - Add new product (admin)\n- `GET /api/orders` - Get all orders (admin)\n- `POST /api/orders` - Place new order\n- `GET /api/orders/:id` - Get specific order\n\n## Database Schema\n\n### Products Table\n- id (INTEGER PRIMARY KEY)\n- name (TEXT)\n- description (TEXT)\n- price (REAL)\n- image_url (TEXT)\n- category (TEXT)\n- in_stock (BOOLEAN)\n- created_at (DATETIME)\n\n### Orders Table\n- id (INTEGER PRIMARY KEY)\n- customer_name (TEXT)\n- customer_email (TEXT)\n- customer_phone (TEXT)\n- shipping_address (TEXT)\n- items (TEXT) - JSON array of cart items\n- total_amount (REAL)\n- status (TEXT)\n- created_at (DATETIME)\n\n## Future Enhancements\n\n- Payment integration (Stripe/PayPal)\n- User authentication and accounts\n- Product reviews and ratings\n- Inventory management\n- Order tracking\n- Email notifications\n- Advanced admin dashboard","label",[129],"3944f212-3f9c-11f0-8902-76b3cceeab13","shared","bc1baa3a-fef4-42ca-a50c-34e9bd02c7e3",2,["D",1748860065632],"directory",[139],"74594f10-3f9c-11f0-b40a-76b3cceeab13","frontend","9cfd62c7-a7f4-473b-b2b6-56ad010d23c8",9,["D",1748860164784],[146],"4608b6be-3f9c-11f0-93d2-76b3cceeab13","backend","49ce3d59-b9c2-459d-97ac-e1597c001084",3,["D",1748860087081],[152],"pulls","branches","forks","envVars",{"_164":60,"_166":60},"connections",{"_164":60,"_165":60},"count","unfilledCount","emptyCount",{"_41":151,"_31":152,"_29":153,"_131":-5,"_39":40,"_38":154,"_133":56,"_36":269,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_183":270,"_26":271},{"_41":265,"_31":257,"_29":251,"_131":153,"_39":40,"_38":154,"_133":56,"_36":266,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_183":267,"_26":268},{"_41":258,"_31":259,"_29":260,"_131":251,"_39":40,"_38":154,"_133":24,"_36":261,"_13":60,"_33":190,"_34":262,"_23":24,"_136":-5,"_183":263,"_26":264},{"_41":248,"_31":249,"_29":250,"_131":251,"_39":40,"_38":252,"_133":56,"_36":253,"_13":60,"_33":190,"_34":254,"_23":24,"_136":-5,"_183":255,"_26":256},{"_41":244,"_31":227,"_29":221,"_131":153,"_39":40,"_38":231,"_133":56,"_36":245,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_183":246,"_26":247},{"_41":236,"_31":237,"_29":238,"_131":221,"_39":40,"_38":239,"_133":56,"_36":240,"_13":60,"_33":190,"_34":241,"_23":24,"_136":-5,"_183":242,"_26":243},{"_41":228,"_31":229,"_29":230,"_131":221,"_39":40,"_38":231,"_133":56,"_36":232,"_13":60,"_33":190,"_34":233,"_23":24,"_136":-5,"_183":234,"_26":235},{"_41":218,"_31":219,"_29":220,"_131":221,"_39":40,"_38":222,"_133":56,"_36":223,"_13":60,"_33":190,"_34":224,"_23":24,"_136":-5,"_183":225,"_26":226},{"_41":211,"_31":212,"_29":54,"_131":153,"_39":40,"_38":213,"_133":24,"_36":214,"_13":60,"_33":190,"_34":215,"_23":24,"_136":-5,"_183":216,"_26":217},{"_41":145,"_31":146,"_29":147,"_131":-5,"_39":40,"_38":148,"_133":56,"_36":208,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_183":209,"_26":210},{"_41":201,"_31":202,"_29":203,"_131":147,"_39":40,"_38":148,"_133":56,"_36":204,"_13":60,"_33":20,"_34":205,"_23":24,"_136":-5,"_183":206,"_26":207},{"_41":197,"_31":32,"_29":30,"_131":147,"_39":40,"_38":14,"_133":56,"_36":198,"_13":60,"_33":20,"_34":35,"_23":24,"_136":-5,"_183":199,"_26":200},{"_41":138,"_31":139,"_29":140,"_131":-5,"_39":40,"_38":141,"_133":56,"_36":194,"_13":60,"_33":143,"_34":-5,"_23":24,"_136":-5,"_183":195,"_26":196},{"_41":186,"_31":187,"_29":188,"_131":140,"_39":40,"_38":141,"_133":56,"_36":189,"_13":60,"_33":190,"_34":191,"_23":24,"_136":-5,"_183":192,"_26":193},{"_41":128,"_31":129,"_29":130,"_131":-5,"_39":40,"_38":132,"_133":56,"_36":182,"_13":60,"_33":20,"_34":135,"_23":24,"_136":-5,"_183":184,"_26":185},["D",1748860059863],"children",[],[129],"3944eaba-3f9c-11f0-8902-76b3cceeab13","types.ts","3944ebe6-3f9c-11f0-8902-76b3cceeab13",["D",1748860065632],"script","// Shared types for the beaded bags e-commerce application\n\nexport interface Product {\n id: number;\n name: string;\n description: string;\n price: number;\n image_url: string;\n category: string;\n in_stock: boolean;\n created_at: string;\n}\n\nexport interface CartItem {\n product: Product;\n quantity: number;\n}\n\nexport interface Order {\n id?: number;\n customer_name: string;\n customer_email: string;\n customer_phone: string;\n shipping_address: string;\n items: CartItem[];\n total_amount: number;\n status: 'pending' | 'processing' | 'shipped' | 'delivered' | 'cancelled';\n created_at?: string;\n}\n\nexport interface CreateOrderRequest {\n customer_name: string;\n customer_email: string;\n customer_phone: string;\n shipping_address: string;\n items: CartItem[];\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[139,187],["D",1748860065632],[180],[139],"7ef6233a-3f9c-11f0-b27f-76b3cceeab13",["D",1748860182594],[],[146,32],"745944e8-3f9c-11f0-b40a-76b3cceeab13","index.html","745946be-3f9c-11f0-b40a-76b3cceeab13",["D",1748860164784],"\n\n\n \n \n Beaded Bags Boutique - Handcrafted Elegance\n \n \n \n \n \n \n \n \n \n \n \n \n 👜\">\n\n\n

\n \n

Loading beautiful beaded bags...

\n\n \n \n\n",[],[146,202],["D",1748860164784],[177,178],[146],"6ea28af0-3f9c-11f0-8902-76b3cceeab13","index.ts",8,["D",1748860155127],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport products from \"./routes/products.ts\";\nimport orders from \"./routes/orders.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait runMigrations();\n\n// API routes\napp.route(\"/api/products\", products);\napp.route(\"/api/orders\", orders);\n\n// Static file serving and main page\napp.route(\"/\", staticRoutes);\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({ error: \"Not found\" }, 404);\n});\n\nexport default app;",[],[152,212],"6987150e-3f9c-11f0-bd82-76b3cceeab13","static.ts","698715cc-3f9c-11f0-bd82-76b3cceeab13","c200fc19-dd90-4e06-b0c5-da5995f5589d",7,["D",1748860146632],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { getAllProducts } from \"../database/queries.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\nstaticRoutes.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial product data to avoid extra round-trips\n const products = await getAllProducts();\n const categories = [...new Set(products.map(p => p.category))];\n \n const initialData = {\n products,\n categories\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default staticRoutes;",[],[152,227,219],"routes","58cd3252-3f9c-11f0-bed4-76b3cceeab13","products.ts","58cd332e-3f9c-11f0-bed4-76b3cceeab13",5,["D",1748860118565],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllProducts, getProductById, getProductsByCategory, createProduct } from \"../database/queries.ts\";\nimport type { ApiResponse, Product } from \"../../shared/types.ts\";\n\nconst products = new Hono();\n\n// Get all products\nproducts.get(\"/\", async (c) => {\n try {\n const category = c.req.query(\"category\");\n let productList: Product[];\n \n if (category) {\n productList = await getProductsByCategory(category);\n } else {\n productList = await getAllProducts();\n }\n \n const response: ApiResponse = {\n success: true,\n data: productList\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch products\"\n };\n return c.json(response, 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 const response: ApiResponse = {\n success: false,\n error: \"Invalid product ID\"\n };\n return c.json(response, 400);\n }\n \n const product = await getProductById(id);\n if (!product) {\n const response: ApiResponse = {\n success: false,\n error: \"Product not found\"\n };\n return c.json(response, 404);\n }\n \n const response: ApiResponse = {\n success: true,\n data: product\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch product\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new product (admin endpoint)\nproducts.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n const { name, description, price, image_url, category, in_stock = true } = body;\n \n if (!name || !description || !price || !image_url || !category) {\n const response: ApiResponse = {\n success: false,\n error: \"Missing required fields\"\n };\n return c.json(response, 400);\n }\n \n const productId = await createProduct({\n name,\n description,\n price: parseFloat(price),\n image_url,\n category,\n in_stock\n });\n \n const response: ApiResponse = {\n success: true,\n data: productId\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to create product\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get unique categories\nproducts.get(\"/categories/list\", async (c) => {\n try {\n const allProducts = await getAllProducts();\n const categories = [...new Set(allProducts.map(p => p.category))];\n \n const response: ApiResponse = {\n success: true,\n data: categories\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch categories\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default products;",[],[152,227,229],"6327cce4-3f9c-11f0-85eb-76b3cceeab13","orders.ts","6327cd70-3f9c-11f0-85eb-76b3cceeab13",6,["D",1748860135943],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createOrder, getAllOrders, getOrderById, updateOrderStatus } from \"../database/queries.ts\";\nimport type { ApiResponse, Order, CreateOrderRequest } from \"../../shared/types.ts\";\n\nconst orders = new Hono();\n\n// Create new order\norders.post(\"/\", async (c) => {\n try {\n const body: CreateOrderRequest = await c.req.json();\n const { customer_name, customer_email, customer_phone, shipping_address, items } = body;\n \n if (!customer_name || !customer_email || !shipping_address || !items || items.length === 0) {\n const response: ApiResponse = {\n success: false,\n error: \"Missing required fields or empty cart\"\n };\n return c.json(response, 400);\n }\n \n // Calculate total amount\n const total_amount = items.reduce((sum, item) => sum + (item.product.price * item.quantity), 0);\n \n const orderId = await createOrder({\n customer_name,\n customer_email,\n customer_phone: customer_phone || \"\",\n shipping_address,\n items,\n total_amount\n });\n \n const response: ApiResponse = {\n success: true,\n data: orderId\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to create order\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get all orders (admin endpoint)\norders.get(\"/\", async (c) => {\n try {\n const orderList = await getAllOrders();\n \n const response: ApiResponse = {\n success: true,\n data: orderList\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch orders\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get order by ID\norders.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid order ID\"\n };\n return c.json(response, 400);\n }\n \n const order = await getOrderById(id);\n if (!order) {\n const response: ApiResponse = {\n success: false,\n error: \"Order not found\"\n };\n return c.json(response, 404);\n }\n \n const response: ApiResponse = {\n success: true,\n data: order\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch order\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update order status (admin endpoint)\norders.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const { status } = await c.req.json();\n \n if (isNaN(id) || !status) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid order ID or status\"\n };\n return c.json(response, 400);\n }\n \n const validStatuses = ['pending', 'processing', 'shipped', 'delivered', 'cancelled'];\n if (!validStatuses.includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status value\"\n };\n return c.json(response, 400);\n }\n \n const updated = await updateOrderStatus(id, status);\n if (!updated) {\n const response: ApiResponse = {\n success: false,\n error: \"Order not found\"\n };\n return c.json(response, 404);\n }\n \n const response: ApiResponse = {\n success: true,\n data: true\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to update order status\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default orders;",[],[152,227,237],"58cd4436-3f9c-11f0-bed4-76b3cceeab13",["D",1748860118565],[172,173,174],[152,227],"503f97ec-3f9c-11f0-8bab-76b3cceeab13","queries.ts","503f9882-3f9c-11f0-8bab-76b3cceeab13","946eabf9-17ea-4588-9229-01b929447eb5",4,["D",1748860104221],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PRODUCTS_TABLE, ORDERS_TABLE } from \"./migrations.ts\";\nimport type { Product, Order, CartItem } from \"../../shared/types.ts\";\n\n// Product queries\nexport async function getAllProducts(): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${PRODUCTS_TABLE} ORDER BY created_at DESC`);\n return results.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n image_url: row.image_url,\n category: row.category,\n in_stock: Boolean(row.in_stock),\n created_at: row.created_at\n }));\n}\n\nexport async function getProductById(id: number): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${PRODUCTS_TABLE} WHERE id = ?`, [id]);\n if (results.length === 0) return null;\n \n const row = results[0];\n return {\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n image_url: row.image_url,\n category: row.category,\n in_stock: Boolean(row.in_stock),\n created_at: row.created_at\n };\n}\n\nexport async function getProductsByCategory(category: string): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${PRODUCTS_TABLE} WHERE category = ? ORDER BY created_at DESC`, [category]);\n return results.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n image_url: row.image_url,\n category: row.category,\n in_stock: Boolean(row.in_stock),\n created_at: row.created_at\n }));\n}\n\nexport async function createProduct(product: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${PRODUCTS_TABLE} (name, description, price, image_url, category, in_stock) VALUES (?, ?, ?, ?, ?, ?)`,\n [product.name, product.description, product.price, product.image_url, product.category, product.in_stock ? 1 : 0]\n );\n return result.lastInsertRowid;\n}\n\n// Order queries\nexport async function createOrder(orderData: {\n customer_name: string;\n customer_email: string;\n customer_phone: string;\n shipping_address: string;\n items: CartItem[];\n total_amount: number;\n}): Promise {\n const itemsJson = JSON.stringify(orderData.items);\n \n const result = await sqlite.execute(\n `INSERT INTO ${ORDERS_TABLE} (customer_name, customer_email, customer_phone, shipping_address, items, total_amount) VALUES (?, ?, ?, ?, ?, ?)`,\n [\n orderData.customer_name,\n orderData.customer_email,\n orderData.customer_phone,\n orderData.shipping_address,\n itemsJson,\n orderData.total_amount\n ]\n );\n \n return result.lastInsertRowid;\n}\n\nexport async function getAllOrders(): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${ORDERS_TABLE} ORDER BY created_at DESC`);\n return results.map(row => ({\n id: row.id,\n customer_name: row.customer_name,\n customer_email: row.customer_email,\n customer_phone: row.customer_phone,\n shipping_address: row.shipping_address,\n items: JSON.parse(row.items),\n total_amount: row.total_amount,\n status: row.status,\n created_at: row.created_at\n }));\n}\n\nexport async function getOrderById(id: number): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${ORDERS_TABLE} WHERE id = ?`, [id]);\n if (results.length === 0) return null;\n \n const row = results[0];\n return {\n id: row.id,\n customer_name: row.customer_name,\n customer_email: row.customer_email,\n customer_phone: row.customer_phone,\n shipping_address: row.shipping_address,\n items: JSON.parse(row.items),\n total_amount: row.total_amount,\n status: row.status,\n created_at: row.created_at\n };\n}\n\nexport async function updateOrderStatus(id: number, status: string): Promise {\n const result = await sqlite.execute(\n `UPDATE ${ORDERS_TABLE} SET status = ? WHERE id = ?`,\n [status, id]\n );\n return result.changes > 0;\n}",[],[152,257,249],"database","4608a5ca-3f9c-11f0-93d2-76b3cceeab13","migrations.ts","4608a69c-3f9c-11f0-93d2-76b3cceeab13",["D",1748860087081],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst PRODUCTS_TABLE = 'beaded_bags_products_v1';\nconst ORDERS_TABLE = 'beaded_bags_orders_v1';\n\nexport async function runMigrations() {\n // Create products table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PRODUCTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n price REAL NOT NULL,\n image_url TEXT NOT NULL,\n category TEXT NOT NULL,\n in_stock BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create orders table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ORDERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n customer_name TEXT NOT NULL,\n customer_email TEXT NOT NULL,\n customer_phone TEXT,\n shipping_address TEXT NOT NULL,\n items TEXT NOT NULL,\n total_amount REAL NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Check if we need to seed sample data\n const existingProducts = await sqlite.execute(`SELECT COUNT(*) as count FROM ${PRODUCTS_TABLE}`);\n if (existingProducts[0].count === 0) {\n await seedSampleProducts();\n }\n}\n\nasync function seedSampleProducts() {\n const sampleProducts = [\n {\n name: \"Elegant Evening Clutch\",\n description: \"Handcrafted beaded clutch perfect for special occasions. Features intricate gold and silver beadwork with a secure magnetic closure.\",\n price: 89.99,\n image_url: \"https://maxm-imggenurl.web.val.run/elegant-beaded-evening-clutch-gold-silver-intricate-pattern\",\n category: \"Evening Bags\"\n },\n {\n name: \"Bohemian Crossbody Bag\",\n description: \"Colorful beaded crossbody bag with adjustable strap. Perfect for festivals and casual outings with vibrant turquoise and coral beads.\",\n price: 65.99,\n image_url: \"https://maxm-imggenurl.web.val.run/bohemian-beaded-crossbody-bag-colorful-turquoise-coral\",\n category: \"Crossbody Bags\"\n },\n {\n name: \"Vintage Pearl Handbag\",\n description: \"Classic handbag adorned with lustrous pearls and delicate beadwork. Timeless design with comfortable handles.\",\n price: 124.99,\n image_url: \"https://maxm-imggenurl.web.val.run/vintage-pearl-beaded-handbag-classic-elegant-white\",\n category: \"Handbags\"\n },\n {\n name: \"Tribal Pattern Tote\",\n description: \"Large tote bag featuring traditional tribal beadwork patterns. Spacious interior perfect for daily use.\",\n price: 78.99,\n image_url: \"https://maxm-imggenurl.web.val.run/tribal-pattern-beaded-tote-bag-traditional-geometric\",\n category: \"Tote Bags\"\n },\n {\n name: \"Floral Beaded Purse\",\n description: \"Delicate purse with beautiful floral beadwork in soft pastels. Features a chain strap and silk lining.\",\n price: 95.99,\n image_url: \"https://maxm-imggenurl.web.val.run/floral-beaded-purse-pastel-colors-chain-strap\",\n category: \"Purses\"\n },\n {\n name: \"Geometric Mini Bag\",\n description: \"Modern mini bag with bold geometric beaded patterns. Perfect statement piece for contemporary fashion.\",\n price: 55.99,\n image_url: \"https://maxm-imggenurl.web.val.run/geometric-beaded-mini-bag-modern-bold-patterns\",\n category: \"Mini Bags\"\n },\n {\n name: \"Sunset Gradient Clutch\",\n description: \"Stunning clutch with gradient beadwork mimicking a beautiful sunset. Orange, pink, and gold beads create a mesmerizing effect.\",\n price: 110.99,\n image_url: \"https://maxm-imggenurl.web.val.run/sunset-gradient-beaded-clutch-orange-pink-gold\",\n category: \"Evening Bags\"\n },\n {\n name: \"Ocean Wave Shoulder Bag\",\n description: \"Medium shoulder bag inspired by ocean waves. Blue and white beads create flowing wave patterns.\",\n price: 85.99,\n image_url: \"https://maxm-imggenurl.web.val.run/ocean-wave-beaded-shoulder-bag-blue-white-flowing\",\n category: \"Shoulder Bags\"\n }\n ];\n\n for (const product of sampleProducts) {\n await sqlite.execute(\n `INSERT INTO ${PRODUCTS_TABLE} (name, description, price, image_url, category) VALUES (?, ?, ?, ?, ?)`,\n [product.name, product.description, product.price, product.image_url, product.category]\n );\n }\n}\n\nexport { PRODUCTS_TABLE, ORDERS_TABLE };",[],[152,257,259],"4608b984-3f9c-11f0-93d2-76b3cceeab13",["D",1748860087081],[169,170],[152,257],["D",1748860087081],[168,171,175],[152],["D",1748859975748],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"ctx",{"_76":-5,"_121":309,"_310":311,"_312":313,"_314":24,"_315":24,"_316":24,"_317":56,"_318":-5,"_319":-7,"_320":-7,"_321":60,"_322":24,"_323":24,"_324":-5,"_325":24,"_326":24,"_327":24,"_328":-5},"ENV",{"_280":281,"_282":283,"_284":84,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v10