[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_331":332,"_333":334},"routes/_app.x.$handle.$name",{"_96":95,"_32":46,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":59,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",17,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/database/migrations.ts","latestPath","fileId","4608a69c-3f9c-11f0-93d2-76b3cceeab13","name","migrations.ts","fileType","script","content","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 };","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 && existingProducts.length > 0 && 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 };","createdAt",["D",1748860348876],"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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":14,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","gracie1","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2NId3R5cW9NN3ByZ08wZ3dpeWJJU1lTWSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":327,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":328,"_81":329,"_83":330,"_85":25},"tree",[169,178,187,189],"files",[169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189],"counts",{"_159":63,"_160":134,"_161":63,"_162":163,"_164":165},"contents",[126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":153,"_32":154,"_30":155,"_133":-5,"_42":43,"_41":156,"_135":59,"_39":157,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_27":158},{"_44":147,"_32":148,"_30":149,"_133":-5,"_42":43,"_41":150,"_135":59,"_39":151,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_27":152},{"_44":140,"_32":141,"_30":142,"_133":-5,"_42":43,"_41":143,"_135":59,"_39":144,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_27":146},{"_44":130,"_32":131,"_30":132,"_133":-5,"_42":43,"_41":134,"_135":59,"_39":136,"_13":63,"_34":20,"_36":137,"_24":25,"_138":-5,"_27":139},"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",[131],"3944f212-3f9c-11f0-8902-76b3cceeab13","shared","bc1baa3a-fef4-42ca-a50c-34e9bd02c7e3",2,["D",1748860065632],"directory",[141],"74594f10-3f9c-11f0-b40a-76b3cceeab13","frontend","9cfd62c7-a7f4-473b-b2b6-56ad010d23c8",9,["D",1748860164784],[148],"4608b6be-3f9c-11f0-93d2-76b3cceeab13","backend","49ce3d59-b9c2-459d-97ac-e1597c001084",3,["D",1748860087081],[154],"pulls","branches","forks","envVars",{"_166":63,"_168":63},"connections",{"_166":63,"_167":63},"count","unfilledCount","emptyCount",{"_44":153,"_32":154,"_30":155,"_133":-5,"_42":43,"_41":156,"_135":59,"_39":324,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_191":325,"_27":326},{"_44":320,"_32":315,"_30":309,"_133":155,"_42":43,"_41":156,"_135":59,"_39":321,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_191":322,"_27":323},{"_44":316,"_32":33,"_30":31,"_133":309,"_42":43,"_41":14,"_135":59,"_39":317,"_13":134,"_34":35,"_36":38,"_24":25,"_138":-5,"_191":318,"_27":319},{"_44":306,"_32":307,"_30":308,"_133":309,"_42":43,"_41":310,"_135":59,"_39":311,"_13":63,"_34":35,"_36":312,"_24":25,"_138":-5,"_191":313,"_27":314},{"_44":302,"_32":285,"_30":279,"_133":155,"_42":43,"_41":289,"_135":59,"_39":303,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_191":304,"_27":305},{"_44":294,"_32":295,"_30":296,"_133":279,"_42":43,"_41":297,"_135":59,"_39":298,"_13":63,"_34":35,"_36":299,"_24":25,"_138":-5,"_191":300,"_27":301},{"_44":286,"_32":287,"_30":288,"_133":279,"_42":43,"_41":289,"_135":59,"_39":290,"_13":63,"_34":35,"_36":291,"_24":25,"_138":-5,"_191":292,"_27":293},{"_44":276,"_32":277,"_30":278,"_133":279,"_42":43,"_41":280,"_135":59,"_39":281,"_13":63,"_34":35,"_36":282,"_24":25,"_138":-5,"_191":283,"_27":284},{"_44":268,"_32":269,"_30":57,"_133":155,"_42":43,"_41":270,"_135":59,"_39":271,"_13":134,"_34":272,"_36":273,"_24":25,"_138":-5,"_191":274,"_27":275},{"_44":147,"_32":148,"_30":149,"_133":-5,"_42":43,"_41":150,"_135":59,"_39":265,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_191":266,"_27":267},{"_44":261,"_32":236,"_30":230,"_133":149,"_42":43,"_41":256,"_135":59,"_39":262,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_191":263,"_27":264},{"_44":253,"_32":254,"_30":255,"_133":230,"_42":43,"_41":256,"_135":59,"_39":257,"_13":63,"_34":35,"_36":258,"_24":25,"_138":-5,"_191":259,"_27":260},{"_44":245,"_32":246,"_30":247,"_133":230,"_42":43,"_41":248,"_135":59,"_39":249,"_13":63,"_34":35,"_36":250,"_24":25,"_138":-5,"_191":251,"_27":252},{"_44":237,"_32":238,"_30":239,"_133":230,"_42":43,"_41":240,"_135":59,"_39":241,"_13":63,"_34":35,"_36":242,"_24":25,"_138":-5,"_191":243,"_27":244},{"_44":227,"_32":228,"_30":229,"_133":230,"_42":43,"_41":231,"_135":59,"_39":232,"_13":63,"_34":35,"_36":233,"_24":25,"_138":-5,"_191":234,"_27":235},{"_44":220,"_32":221,"_30":222,"_133":149,"_42":43,"_41":150,"_135":59,"_39":223,"_13":63,"_34":20,"_36":224,"_24":25,"_138":-5,"_191":225,"_27":226},{"_44":212,"_32":213,"_30":214,"_133":149,"_42":43,"_41":215,"_135":59,"_39":216,"_13":63,"_34":35,"_36":217,"_24":25,"_138":-5,"_191":218,"_27":219},{"_44":204,"_32":205,"_30":206,"_133":149,"_42":43,"_41":207,"_135":59,"_39":208,"_13":63,"_34":20,"_36":209,"_24":25,"_138":-5,"_191":210,"_27":211},{"_44":140,"_32":141,"_30":142,"_133":-5,"_42":43,"_41":143,"_135":59,"_39":201,"_13":63,"_34":145,"_36":-5,"_24":25,"_138":-5,"_191":202,"_27":203},{"_44":194,"_32":195,"_30":196,"_133":142,"_42":43,"_41":143,"_135":59,"_39":197,"_13":63,"_34":35,"_36":198,"_24":25,"_138":-5,"_191":199,"_27":200},{"_44":130,"_32":131,"_30":132,"_133":-5,"_42":43,"_41":134,"_135":59,"_39":190,"_13":63,"_34":20,"_36":137,"_24":25,"_138":-5,"_191":192,"_27":193},["D",1748860059863],"children",[],[131],"3944eaba-3f9c-11f0-8902-76b3cceeab13","types.ts","3944ebe6-3f9c-11f0-8902-76b3cceeab13",["D",1748860065632],"// 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}",[],[141,195],["D",1748860065632],[188],[141],"7ef6233a-3f9c-11f0-b27f-76b3cceeab13","style.css","7ef623f8-3f9c-11f0-b27f-76b3cceeab13",10,["D",1748860182594],"/* 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}",[],[148,205],"d66e318e-3f9c-11f0-b1ac-76b3cceeab13","index.tsx","d66e3260-3f9c-11f0-b1ac-76b3cceeab13",15,["D",1748860329339],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst container = document.getElementById('root');\nif (container) {\n const root = createRoot(container);\n root.render();\n} else {\n console.error('Root container not found');\n}",[],[148,213],"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",[],[148,221],"a845ee78-3f9c-11f0-8e51-76b3cceeab13","ProductCard.tsx","a845ef22-3f9c-11f0-8e51-76b3cceeab13","040254c3-c489-464f-adb5-0907996d4ec8",12,["D",1748860251902],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Product } from \"../../shared/types.ts\";\n\ninterface ProductCardProps {\n product: Product;\n onAddToCart: (product: Product) => void;\n}\n\nexport default function ProductCard({ product, onAddToCart }: ProductCardProps) {\n const [isAdding, setIsAdding] = useState(false);\n const [imageLoaded, setImageLoaded] = useState(false);\n\n const handleAddToCart = async () => {\n setIsAdding(true);\n onAddToCart(product);\n \n // Add a small delay for visual feedback\n setTimeout(() => {\n setIsAdding(false);\n }, 600);\n };\n\n return (\n

\n {/* Product Image */}\n

\n {!imageLoaded && (\n

\n )}\n setImageLoaded(true)}\n onError={(e) => {\n // Fallback to a placeholder if image fails to load\n (e.target as HTMLImageElement).src = `data:image/svg+xml,`;\n setImageLoaded(true);\n }}\n />\n \n {/* Category Badge */}\n

\n \n {product.category}\n \n

\n\n {/* Stock Status */}\n {product.in_stock && (\n

\n \n In Stock\n \n

\n )}\n

\n\n {/* Product Info */}\n

\n {product.name}\n

\n \n

\n {product.description}\n

\n\n

\n ${product.price.toFixed(2)}\n

\n \n \n {isAdding ? (\n \n \n Adding...\n \n ) : !product.in_stock ? (\n 'Out of Stock'\n ) : (\n \n \n Add to Cart\n \n )}\n \n

\n );\n}",[],[148,236,228],"components","d27c2950-3f9c-11f0-9138-76b3cceeab13","OrderForm.tsx","d27c2a18-3f9c-11f0-9138-76b3cceeab13",14,["D",1748860322723],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CartItem, CreateOrderRequest } from \"../../shared/types.ts\";\n\ninterface OrderFormProps {\n isOpen: boolean;\n onClose: () => void;\n cart: CartItem[];\n total: number;\n onOrderComplete: () => void;\n}\n\nexport default function OrderForm({\n isOpen,\n onClose,\n cart,\n total,\n onOrderComplete\n}: OrderFormProps) {\n const [formData, setFormData] = useState({\n customer_name: '',\n customer_email: '',\n customer_phone: '',\n shipping_address: ''\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [orderSuccess, setOrderSuccess] = useState(false);\n const [orderId, setOrderId] = useState(null);\n const [errors, setErrors] = useState>({});\n\n if (!isOpen) return null;\n\n const validateForm = () => {\n const newErrors: Record = {};\n\n if (!formData.customer_name.trim()) {\n newErrors.customer_name = 'Name is required';\n }\n\n if (!formData.customer_email.trim()) {\n newErrors.customer_email = 'Email is required';\n } else if (!/\\S+@\\S+\\.\\S+/.test(formData.customer_email)) {\n newErrors.customer_email = 'Please enter a valid email';\n }\n\n if (!formData.shipping_address.trim()) {\n newErrors.shipping_address = 'Shipping address is required';\n }\n\n setErrors(newErrors);\n return Object.keys(newErrors).length === 0;\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!validateForm()) return;\n if (cart.length === 0) return;\n\n setIsSubmitting(true);\n\n try {\n const orderData: CreateOrderRequest = {\n ...formData,\n items: cart\n };\n\n const response = await fetch('/api/orders', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(orderData)\n });\n\n const result = await response.json();\n\n if (result.success) {\n setOrderId(result.data);\n setOrderSuccess(true);\n // Reset form\n setFormData({\n customer_name: '',\n customer_email: '',\n customer_phone: '',\n shipping_address: ''\n });\n } else {\n alert('Failed to place order: ' + (result.error || 'Unknown error'));\n }\n } catch (error) {\n console.error('Order submission error:', error);\n alert('Failed to place order. Please try again.');\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleClose = () => {\n if (orderSuccess) {\n onOrderComplete();\n setOrderSuccess(false);\n setOrderId(null);\n }\n onClose();\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n // Clear error when user starts typing\n if (errors[name]) {\n setErrors(prev => ({ ...prev, [name]: '' }));\n }\n };\n\n return (\n <>\n {/* Backdrop */}\n

\n \n {/* Modal */}\n

\n {orderSuccess ? (\n /* Success State */\n

\n \n

\n Order Placed Successfully!\n

\n \n

\n Thank you for your order. Your order number is #{orderId}.\n

\n \n

\n We'll send you an email confirmation shortly with tracking information.\n

\n \n \n Continue Shopping\n \n

\n ) : (\n /* Order Form */\n <>\n {/* Header */}\n

\n Checkout\n

\n \n \n \n

\n\n {/* Order Summary */}\n

Order Summary

\n {cart.map(item => (\n

\n {item.product.name} × {item.quantity}\n ${(item.product.price * item.quantity).toFixed(2)}\n

\n ))}\n

\n Total:\n ${total.toFixed(2)}\n

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

\n {/* Customer Name */}\n

\n \n Full Name *\n \n \n {errors.customer_name && (\n

{errors.customer_name}

\n )}\n

\n\n {/* Email */}\n

\n \n Email Address *\n \n \n {errors.customer_email && (\n

{errors.customer_email}

\n )}\n

\n\n {/* Phone */}\n

\n \n Phone Number\n \n \n

\n\n {/* Shipping Address */}\n

\n \n Shipping Address *\n \n \n {errors.shipping_address && (\n

{errors.shipping_address}

\n )}\n

\n\n {/* Submit Button */}\n \n {isSubmitting ? (\n \n \n Placing Order...\n \n ) : (\n `Place Order - $${total.toFixed(2)}`\n )}\n \n\n

\n By placing this order, you agree to our terms and conditions.\n

\n \n \n )}\n

\n \n );\n}",[],[148,236,238],"b9be609a-3f9c-11f0-ae5a-76b3cceeab13","Cart.tsx","b9be6158-3f9c-11f0-ae5a-76b3cceeab13",13,["D",1748860281213],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { CartItem } from \"../../shared/types.ts\";\n\ninterface CartProps {\n isOpen: boolean;\n onClose: () => void;\n cart: CartItem[];\n onUpdateQuantity: (productId: number, quantity: number) => void;\n onRemoveItem: (productId: number) => void;\n onCheckout: () => void;\n total: number;\n}\n\nexport default function Cart({\n isOpen,\n onClose,\n cart,\n onUpdateQuantity,\n onRemoveItem,\n onCheckout,\n total\n}: CartProps) {\n if (!isOpen) return null;\n\n const itemCount = cart.reduce((sum, item) => sum + item.quantity, 0);\n\n return (\n <>\n {/* Backdrop */}\n

\n \n {/* Cart Sidebar */}\n

\n {/* Header */}\n

\n Shopping Cart ({itemCount})\n

\n \n \n \n

\n\n {/* Cart Items */}\n

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

\n \n

Your cart is empty

\n \n Continue Shopping\n \n

\n ) : (\n

\n {cart.map(item => (\n

\n {/* Product Image */}\n {\n (e.target as HTMLImageElement).src = `data:image/svg+xml,`;\n }}\n />\n \n {/* Product Info */}\n

\n {item.product.name}\n

\n ${item.product.price.toFixed(2)} each\n

\n \n {/* Quantity Controls */}\n

\n onUpdateQuantity(item.product.id, item.quantity - 1)}\n className=\"w-6 h-6 rounded-full bg-gray-200 hover:bg-gray-300 flex items-center justify-center text-gray-600\"\n >\n \n \n \n \n {item.quantity}\n \n \n onUpdateQuantity(item.product.id, item.quantity + 1)}\n className=\"w-6 h-6 rounded-full bg-gray-200 hover:bg-gray-300 flex items-center justify-center text-gray-600\"\n >\n \n \n

\n \n {/* Item Total and Remove */}\n

\n ${(item.product.price * item.quantity).toFixed(2)}\n

\n onRemoveItem(item.product.id)}\n className=\"text-red-500 hover:text-red-700 text-sm mt-1\"\n >\n Remove\n \n

\n ))}\n

\n )}\n

\n\n {/* Footer */}\n {cart.length > 0 && (\n

\n {/* Total */}\n

\n Total:\n ${total.toFixed(2)}\n

\n \n {/* Checkout Button */}\n \n Proceed to Checkout\n \n \n {/* Continue Shopping */}\n \n Continue Shopping\n \n

\n )}\n

\n \n );\n}",[],[148,236,246],"9b8ea350-3f9c-11f0-ae57-76b3cceeab13","App.tsx","9b8ea422-3f9c-11f0-ae57-76b3cceeab13",11,["D",1748860230564],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Product, CartItem } from \"../../shared/types.ts\";\nimport ProductCard from \"./ProductCard.tsx\";\nimport Cart from \"./Cart.tsx\";\nimport OrderForm from \"./OrderForm.tsx\";\n\ninterface InitialData {\n products: Product[];\n categories: string[];\n}\n\nexport default function App() {\n const [products, setProducts] = useState([]);\n const [categories, setCategories] = useState([]);\n const [selectedCategory, setSelectedCategory] = useState(\"all\");\n const [cart, setCart] = useState([]);\n const [isCartOpen, setIsCartOpen] = useState(false);\n const [isCheckoutOpen, setIsCheckoutOpen] = useState(false);\n const [loading, setLoading] = useState(true);\n const [searchTerm, setSearchTerm] = useState(\"\");\n\n useEffect(() => {\n // Load initial data from window or fetch from API\n const initialData = (window as any).__INITIAL_DATA__ as InitialData;\n if (initialData) {\n setProducts(initialData.products);\n setCategories(initialData.categories);\n setLoading(false);\n } else {\n fetchProducts();\n }\n }, []);\n\n const fetchProducts = async () => {\n try {\n const response = await fetch(\"/api/products\");\n const result = await response.json();\n if (result.success) {\n setProducts(result.data);\n const uniqueCategories = [...new Set(result.data.map((p: Product) => p.category))];\n setCategories(uniqueCategories);\n }\n } catch (error) {\n console.error(\"Failed to fetch products:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const addToCart = (product: Product) => {\n setCart(prevCart => {\n const existingItem = prevCart.find(item => item.product.id === product.id);\n if (existingItem) {\n return prevCart.map(item =>\n item.product.id === product.id\n ? { ...item, quantity: item.quantity + 1 }\n : item\n );\n } else {\n return [...prevCart, { product, quantity: 1 }];\n }\n });\n };\n\n const updateCartQuantity = (productId: number, quantity: number) => {\n if (quantity <= 0) {\n removeFromCart(productId);\n return;\n }\n setCart(prevCart =>\n prevCart.map(item =>\n item.product.id === productId\n ? { ...item, quantity }\n : item\n )\n );\n };\n\n const removeFromCart = (productId: number) => {\n setCart(prevCart => prevCart.filter(item => item.product.id !== productId));\n };\n\n const clearCart = () => {\n setCart([]);\n };\n\n const getCartTotal = () => {\n return cart.reduce((total, item) => total + (item.product.price * item.quantity), 0);\n };\n\n const getCartItemCount = () => {\n return cart.reduce((total, item) => total + item.quantity, 0);\n };\n\n const filteredProducts = products.filter(product => {\n const matchesCategory = selectedCategory === \"all\" || product.category === selectedCategory;\n const matchesSearch = product.name.toLowerCase().includes(searchTerm.toLowerCase()) ||\n product.description.toLowerCase().includes(searchTerm.toLowerCase());\n return matchesCategory && matchesSearch && product.in_stock;\n });\n\n if (loading) {\n return (\n

Loading beautiful beaded bags...

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

\n {/* Header */}\n

\n 👜 Beaded Bags Boutique\n

\n \n

\n setIsCartOpen(true)}\n className=\"relative p-2 text-gray-600 hover:text-purple-600 transition-colors\"\n >\n \n {getCartItemCount() > 0 && (\n \n {getCartItemCount()}\n \n )}\n \n

\n\n {/* Hero Section */}\n

\n Handcrafted Beaded Elegance\n

\n Discover our collection of unique, artisan-made beaded bags\n

\n document.getElementById('products')?.scrollIntoView()}\n className=\"bg-white text-purple-600 px-8 py-3 rounded-full font-semibold hover:bg-gray-100 transition-colors\"\n >\n Shop Now\n \n

\n\n {/* Filters and Search */}\n

\n {/* Search */}\n

\n setSearchTerm(e.target.value)}\n className=\"w-full md:w-64 pl-10 pr-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n />\n \n

\n\n {/* Category Filter */}\n

\n setSelectedCategory(\"all\")}\n className={`px-4 py-2 rounded-full text-sm font-medium transition-colors ${\n selectedCategory === \"all\"\n ? \"bg-purple-600 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n All Categories\n \n {categories.map(category => (\n setSelectedCategory(category)}\n className={`px-4 py-2 rounded-full text-sm font-medium transition-colors ${\n selectedCategory === category\n ? \"bg-purple-600 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n {category}\n \n ))}\n

\n\n {/* Products Grid */}\n

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

No bags found matching your criteria.

\n ) : (\n

\n {filteredProducts.map(product => (\n \n ))}\n

\n )}\n

\n\n {/* Footer */}\n \n\n {/* Cart Sidebar */}\n setIsCartOpen(false)}\n cart={cart}\n onUpdateQuantity={updateCartQuantity}\n onRemoveItem={removeFromCart}\n onCheckout={() => {\n setIsCartOpen(false);\n setIsCheckoutOpen(true);\n }}\n total={getCartTotal()}\n />\n\n {/* Checkout Modal */}\n setIsCheckoutOpen(false)}\n cart={cart}\n total={getCartTotal()}\n onOrderComplete={() => {\n clearCart();\n setIsCheckoutOpen(false);\n }}\n />\n

\n );\n}",[],[148,236,254],"9b8ec164-3f9c-11f0-ae57-76b3cceeab13",["D",1748860230564],[180,181,182,183],[148,236],["D",1748860164784],[179,184,185,186],[148],"da9db23e-3f9c-11f0-9101-76b3cceeab13","index.ts",16,["D",1748860336361],"http","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;",[],[154,269],"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;",[],[154,285,277],"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;",[],[154,285,287],"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;",[],[154,285,295],"58cd4436-3f9c-11f0-bed4-76b3cceeab13",["D",1748860118565],[174,175,176],[154,285],"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}",[],[154,315,307],"database","e213c81e-3f9c-11f0-bc48-76b3cceeab13",["D",1748860348876],[],[154,315,33],"4608b984-3f9c-11f0-93d2-76b3cceeab13",["D",1748860087081],[171,172],[154,315],["D",1748860087081],[170,173,177],[154],["D",1748859975748],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":14,"_32":86,"_44":43,"_87":45,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":46,"_94":95},"ctx",{"_79":-5,"_123":364,"_365":366,"_367":368,"_369":25,"_370":25,"_371":25,"_372":59,"_373":-5,"_374":-7,"_375":-7,"_376":63,"_377":25,"_378":25,"_379":-5,"_380":25,"_381":25,"_382":25,"_383":-5},"ENV",{"_335":336,"_337":338,"_339":86,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363},"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 · v17