📈 محفظة الأسهم

\n \n \n\n

محفظتي

\n \n \n \n \n \n \n \n \n \n \n \n \n {stocks.map((stock, index) => (\n \n \n \n \n \n \n \n \n ))}\n \n

الرمز	الكمية	سعر الشراء	سعر البيع	الربح/الخسارة	تاريخ الشراء
{stock.symbol}	{stock.quantity}	{stock.purchasePrice}	{stock.sellingPrice \|\| 'غير محدد'}	\n {stock.sellingPrice ? (\n = 0 ? 'green' : 'red'\n }}>\n {calculateProfit(stock)?.toFixed(2) \|\| '0.00'}\n \n ) : 'غير محدد'}\n	{stock.purchaseDate}

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"dedicatedAmethystLeopard\";\n\n // Updated table schema to include optional selling price\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_stocks (\n symbol TEXT NOT NULL,\n quantity INTEGER NOT NULL,\n purchasePrice REAL NOT NULL,\n purchaseDate TEXT NOT NULL,\n sellingPrice REAL\n )\n `);\n\n // Handle stock retrieval\n if (request.method === 'GET' && new URL(request.url).pathname === '/stocks') {\n const result = await sqlite.execute(`SELECT * FROM ${KEY}_stocks`);\n return Response.json(result.rows);\n }\n\n // Handle stock addition\n if (request.method === 'POST' && new URL(request.url).pathname === '/stocks') {\n const stock = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_stocks (symbol, quantity, purchasePrice, purchaseDate, sellingPrice) VALUES (?, ?, ?, ?, ?)`,\n [stock.symbol, stock.quantity, stock.purchasePrice, stock.purchaseDate, stock.sellingPrice || null]\n );\n return Response.json({ success: true });\n }\n\n return new Response(`\n \n \n محفظة الأسهم\n \n \n \n \n

\n \n \n \n \n `, {\n headers: {\n 'Content-Type': 'text/html',\n }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/mohsen/dedicatedAmethystLeopard/code/main.tsx","extension","actionData","errors"]