[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_296":297,"_298":299},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_38":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",11,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/components/App.tsx","latestPath","fileId","9b8ea422-3f9c-11f0-ae57-76b3cceeab13","name","App.tsx","fileType","script","content","/** @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}","createdAt",["D",1748860230564],"branchVersion","branchId","03abe386-3f9c-11f0-b85d-76b3cceeab13",{"_30":45,"_32":46,"_34":47,"_36":-5,"_38":48,"_40":14,"_41":42,"_24":25},"frontend/components","040254c3-c489-464f-adb5-0907996d4ec8","components","directory",["D",1748860230564],"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",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"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",{"_49":50,"_32":51,"_38":292,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":293,"_86":294,"_88":295,"_90":25},"tree",[174,183,188,190],"files",[174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190],"counts",{"_164":68,"_165":140,"_166":68,"_167":168,"_169":170},"contents",[132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":158,"_32":159,"_30":160,"_139":-5,"_41":42,"_40":161,"_141":64,"_38":162,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":163},{"_49":152,"_32":153,"_30":154,"_139":-5,"_41":42,"_40":155,"_141":64,"_38":156,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":157},{"_49":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":64,"_38":150,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_27":151},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":64,"_38":142,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_27":145},"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",[137],"3944f212-3f9c-11f0-8902-76b3cceeab13","shared","bc1baa3a-fef4-42ca-a50c-34e9bd02c7e3",2,["D",1748860065632],[147],"74594f10-3f9c-11f0-b40a-76b3cceeab13","frontend","9cfd62c7-a7f4-473b-b2b6-56ad010d23c8",9,["D",1748860164784],[153],"4608b6be-3f9c-11f0-93d2-76b3cceeab13","backend","49ce3d59-b9c2-459d-97ac-e1597c001084",3,["D",1748860087081],[159],"pulls","branches","forks","envVars",{"_171":68,"_173":68},"connections",{"_171":68,"_172":68},"count","unfilledCount","emptyCount",{"_49":158,"_32":159,"_30":160,"_139":-5,"_41":42,"_40":161,"_141":64,"_38":289,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_192":290,"_27":291},{"_49":285,"_32":277,"_30":271,"_139":160,"_41":42,"_40":161,"_141":64,"_38":286,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_192":287,"_27":288},{"_49":278,"_32":279,"_30":280,"_139":271,"_41":42,"_40":161,"_141":25,"_38":281,"_13":68,"_34":35,"_36":282,"_24":25,"_144":-5,"_192":283,"_27":284},{"_49":268,"_32":269,"_30":270,"_139":271,"_41":42,"_40":272,"_141":64,"_38":273,"_13":68,"_34":35,"_36":274,"_24":25,"_144":-5,"_192":275,"_27":276},{"_49":264,"_32":247,"_30":241,"_139":160,"_41":42,"_40":251,"_141":64,"_38":265,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_192":266,"_27":267},{"_49":256,"_32":257,"_30":258,"_139":241,"_41":42,"_40":259,"_141":64,"_38":260,"_13":68,"_34":35,"_36":261,"_24":25,"_144":-5,"_192":262,"_27":263},{"_49":248,"_32":249,"_30":250,"_139":241,"_41":42,"_40":251,"_141":64,"_38":252,"_13":68,"_34":35,"_36":253,"_24":25,"_144":-5,"_192":254,"_27":255},{"_49":238,"_32":239,"_30":240,"_139":241,"_41":42,"_40":242,"_141":64,"_38":243,"_13":68,"_34":35,"_36":244,"_24":25,"_144":-5,"_192":245,"_27":246},{"_49":231,"_32":232,"_30":62,"_139":160,"_41":42,"_40":233,"_141":25,"_38":234,"_13":68,"_34":35,"_36":235,"_24":25,"_144":-5,"_192":236,"_27":237},{"_49":152,"_32":153,"_30":154,"_139":-5,"_41":42,"_40":155,"_141":64,"_38":228,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_192":229,"_27":230},{"_49":224,"_32":46,"_30":45,"_139":154,"_41":42,"_40":14,"_141":64,"_38":225,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_192":226,"_27":227},{"_49":220,"_32":33,"_30":31,"_139":45,"_41":42,"_40":14,"_141":64,"_38":221,"_13":68,"_34":35,"_36":37,"_24":25,"_144":-5,"_192":222,"_27":223},{"_49":213,"_32":214,"_30":215,"_139":154,"_41":42,"_40":155,"_141":64,"_38":216,"_13":68,"_34":21,"_36":217,"_24":25,"_144":-5,"_192":218,"_27":219},{"_49":205,"_32":206,"_30":207,"_139":154,"_41":42,"_40":208,"_141":64,"_38":209,"_13":68,"_34":21,"_36":210,"_24":25,"_144":-5,"_192":211,"_27":212},{"_49":146,"_32":147,"_30":148,"_139":-5,"_41":42,"_40":149,"_141":64,"_38":202,"_13":68,"_34":47,"_36":-5,"_24":25,"_144":-5,"_192":203,"_27":204},{"_49":195,"_32":196,"_30":197,"_139":148,"_41":42,"_40":149,"_141":64,"_38":198,"_13":68,"_34":35,"_36":199,"_24":25,"_144":-5,"_192":200,"_27":201},{"_49":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":64,"_38":191,"_13":68,"_34":21,"_36":143,"_24":25,"_144":-5,"_192":193,"_27":194},["D",1748860059863],"children",[],[137],"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}",[],[147,196],["D",1748860065632],[189],[147],"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}",[],[153,206],"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",[],[153,214],"9b8ea350-3f9c-11f0-ae57-76b3cceeab13",["D",1748860230564],[],[153,46,33],"9b8ec164-3f9c-11f0-ae57-76b3cceeab13",["D",1748860230564],[185],[153,46],["D",1748860164784],[184,186,187],[153],"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;",[],[159,232],"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;",[],[159,247,239],"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;",[],[159,247,249],"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;",[],[159,247,257],"58cd4436-3f9c-11f0-bed4-76b3cceeab13",["D",1748860118565],[179,180,181],[159,247],"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}",[],[159,277,269],"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 };",[],[159,277,279],"4608b984-3f9c-11f0-93d2-76b3cceeab13",["D",1748860087081],[176,177],[159,277],["D",1748860087081],[175,178,182],[159],["D",1748859975748],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":42,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":329,"_330":331,"_332":333,"_334":25,"_335":25,"_336":25,"_337":64,"_338":-5,"_339":-7,"_340":-7,"_341":68,"_342":25,"_343":25,"_344":-5,"_345":25,"_346":25,"_347":25,"_348":-5},"ENV",{"_300":301,"_302":303,"_304":92,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328},"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 · v11