محفظة الأسهم

\n {/* Existing stock management UI remains the same */}\n \n {/* New Operations Log Section */}\n

📋 سجل العمليات

\n \n \n \n \n \n \n \n \n \n {operations.map((op, index) => (\n \n \n \n \n \n ))}\n \n

التاريخ	نوع العملية	التفاصيل
{new Date(op.timestamp).toLocaleString()}	{op.type}	{op.details}

\n \n \n عرض المصدر\n \n

\n );\n}\n\n// Rest of the client-side code remains the same\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"captivatingPurpleTapir\";\n const SCHEMA_VERSION = 3; // Increment schema version\n\n // Create stocks table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_stocks_${SCHEMA_VERSION} (\n symbol TEXT NOT NULL,\n shares INTEGER NOT NULL,\n purchasePrice REAL NOT NULL,\n currentPrice REAL,\n sellPrice REAL\n )\n `);\n\n // Create operations log table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_operations_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n type TEXT NOT NULL,\n details TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Function to log operations\n async function logOperation(type: string, details: string) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_operations_${SCHEMA_VERSION} (type, details) VALUES (?, ?)`,\n [type, details]\n );\n }\n\n // Handle GET operations log\n if (request.method === 'GET' && new URL(request.url).pathname.endsWith('/operations')) {\n const operations = await sqlite.execute(`\n SELECT type, details, timestamp \n FROM ${KEY}_operations_${SCHEMA_VERSION} \n ORDER BY timestamp DESC \n LIMIT 50\n `);\n return new Response(JSON.stringify(operations.rows), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // POST method with operation logging\n if (request.method === 'POST') {\n const stock = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_stocks_${SCHEMA_VERSION} (symbol, shares, purchasePrice, currentPrice, sellPrice) \n VALUES (?, ?, ?, ?, ?)`, \n [\n stock.symbol, \n stock.shares, \n stock.purchasePrice, \n await fetchStockPrice(stock.symbol),\n stock.sellPrice || null\n ]\n );\n \n // Log the stock addition operation\n await logOperation('إضافة سهم', `تم إضافة ${stock.shares} سهم من ${stock.symbol} بسعر ${stock.purchasePrice}`);\n \n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // PUT method with operation logging\n if (request.method === 'PUT') {\n const stock = await request.json();\n await sqlite.execute(\n `UPDATE ${KEY}_stocks_${SCHEMA_VERSION} \n SET purchasePrice = ?, sellPrice = ?\n WHERE symbol = ? AND shares = ? AND purchasePrice = ?`, \n [\n stock.purchasePrice, \n stock.sellPrice || null,\n stock.symbol, \n stock.shares, \n stock.purchasePrice\n ]\n );\n \n // Log the stock update operation\n await logOperation('تحديث سهم', `تم تحديث ${stock.symbol} - سعر الشراء: ${stock.purchasePrice}, سعر البيع: ${stock.sellPrice || 'غير محدد'}`);\n \n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // DELETE method with operation logging\n if (request.method === 'DELETE') {\n const stock = await request.json();\n await sqlite.execute(\n `DELETE FROM ${KEY}_stocks_${SCHEMA_VERSION} \n WHERE symbol = ? AND shares = ? AND purchasePrice = ?`, \n [stock.symbol, stock.shares, stock.purchasePrice]\n );\n \n // Log the stock deletion operation\n await logOperation('حذف سهم', `تم حذف ${stock.shares} سهم من ${stock.symbol} بسعر ${stock.purchasePrice}`);\n \n return new Response(JSON.stringify({ success: true }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // GET stocks method remains the same\n if (request.method === 'GET' && new URL(request.url).pathname.endsWith('/stocks')) {\n const stocks = await sqlite.execute(`\n SELECT symbol, shares, purchasePrice, currentPrice, sellPrice\n FROM ${KEY}_stocks_${SCHEMA_VERSION}\n `);\n return new Response(JSON.stringify(stocks.rows), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Existing HTML response remains the same\n return new Response(`\n \n \n محفظة الأسهم\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\n// Existing fetchStockPrice function remains the same\nasync function fetchStockPrice(symbol: string): Promise {\n try {\n const response = await fetch(`https://query1.finance.yahoo.com/v8/finance/chart/${symbol}`);\n const data = await response.json();\n return data.chart.result[0].meta.regularMarketPrice;\n } catch {\n return 0; // Default to 0 if price can't be fetched\n }\n}","deleted","label",[98],"permalink","https://www.val.town/x/mohsen/captivatingPurpleTapir/code/main.tsx","extension","actionData","errors"]