INVENTORY MANAGER

Add New Piece

\n \n

\n\n

\n ${\n items.map((i) => `\n

\n \n \n

\n `).join(\"\")\n }\n

\n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n\n // 3. ADMIN ACTIONS (The Backend Logic)\n if (req.method === \"POST\" && url.pathname === \"/admin-action\") {\n const formData = await req.formData();\n const action = formData.get(\"action\");\n\n if (action === \"add\") {\n await sqlite.execute(\n \"INSERT INTO okeyez_inventory (name, price, category, img) VALUES (?, ?, ?, ?)\",\n [\n formData.get(\"name\"),\n formData.get(\"price\"),\n formData.get(\"category\"),\n formData.get(\"img\"),\n ],\n );\n } else if (action === \"update\") {\n await sqlite.execute(\n \"UPDATE okeyez_inventory SET price = ?, in_stock = ? WHERE id = ?\",\n [formData.get(\"price\"), formData.get(\"in_stock\"), formData.get(\"id\")],\n );\n } else if (action === \"delete\") {\n await sqlite.execute(\"DELETE FROM okeyez_inventory WHERE id = ?\", [\n formData.get(\"id\"),\n ]);\n }\n return Response.redirect(url.origin + \"/admin\");\n }\n\n // 4. PUBLIC STOREFRONT (Fetching live data)\n const res = await sqlite.execute(\n \"SELECT * FROM okeyez_inventory WHERE in_stock = 1 ORDER BY id DESC\",\n );\n const inventory = res.rows;\n\n // --- START OF YOUR ORIGINAL UI ---\n const html = `\n \n \n \n \n \n ${shopName} | Elite Streetwear\n \n \n \n \n

${shopName}

Accra's Premium Source

\n \n

\n \n \n \n \n

\n \n \n\n \n\n

\n VIEW ORDER\n GHS 0\n

\n\n \n \n \n `;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n}","deleted","label",[102],"permalink","https://www.val.town/x/okeyezz/untitled-9563/code/main.ts","extension","actionData","errors"]

INVENTORY MANAGER

Add New Piece

YOUR ORDER