WealthTrack

\n\n

\n \n\n \n

กำลังโหลด…

Asset Allocation

กำไร/ขาดทุน รายตัว

Holdings

ดึงราคาจาก Yahoo Finance · ราคาสด ราคาเก่า

⬡

ยังไม่มีข้อมูล

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

\n\n\n\n`;\n}\n\n// ─── Main HTTP Handler ─────────────────────────────────────────────────────────\nexport default async function(req: Request): Promise {\n await initDB();\n const url = new URL(req.url);\n const path = url.pathname;\n const method = req.method;\n const json = (data: unknown, status = 200) =>\n new Response(JSON.stringify(data), { status, headers: { \"Content-Type\": \"application/json\" } });\n\n // ── GET /api/portfolio?base=THB ─────────────────────────────────────────────\n if (path === \"/api/portfolio\" && method === \"GET\") {\n const base = url.searchParams.get(\"base\") || \"THB\";\n return json(await calcPortfolio(base));\n }\n\n // ── GET /api/price?symbol=PTT&market=TH ────────────────────────────────────\n if (path === \"/api/price\" && method === \"GET\") {\n const symbol = url.searchParams.get(\"symbol\") || \"\";\n const market = url.searchParams.get(\"market\") || \"US\";\n const result = await getPrice(symbol, market);\n return json(result);\n }\n\n // ── GET /api/prices ─────────────────────────────────────────────────────────\n if (path === \"/api/prices\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT symbol,price,currency,source,fetched_at FROM price_cache ORDER BY fetched_at DESC\"\n );\n return json(r.rows);\n }\n\n // ── POST /api/prices/refresh ────────────────────────────────────────────────\n if (path === \"/api/prices/refresh\" && method === \"POST\") {\n const result = await refreshAllPrices();\n return json(result);\n }\n\n // ── GET /api/fx ──────────────────────────────────────────────────────────────\n if (path === \"/api/fx\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT pair,rate,fetched_at FROM fx_cache ORDER BY fetched_at DESC\"\n );\n return json(r.rows);\n }\n\n // ── GET /api/transactions ───────────────────────────────────────────────────\n if (path === \"/api/transactions\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT id,symbol,name,market,type,shares,price,fee,currency,date,notes FROM transactions ORDER BY date DESC, id DESC\"\n );\n return json(r.rows);\n }\n\n // ── POST /api/transactions ──────────────────────────────────────────────────\n if (path === \"/api/transactions\" && method === \"POST\") {\n const b = await req.json();\n await sqlite.execute(\n \"INSERT INTO transactions(symbol,name,market,type,shares,price,fee,currency,date,notes) VALUES(?,?,?,?,?,?,?,?,?,?)\",\n [b.symbol, b.name || b.symbol, b.market || \"TH\", b.type, b.shares, b.price, b.fee ?? 0, b.currency || \"THB\", b.date, b.notes || \"\"]\n );\n // Also cache price\n await sqlite.execute(\n \"INSERT OR IGNORE INTO price_cache(symbol,price,currency,source,fetched_at) VALUES(?,?,?,?,datetime('now','-13 hours'))\",\n [b.symbol, b.price, b.currency || \"THB\", \"manual\"]\n );\n return json({ ok: true });\n }\n\n // ── DELETE /api/transactions/:id ────────────────────────────────────────────\n if (path.startsWith(\"/api/transactions/\") && method === \"DELETE\") {\n const id = path.split(\"/\").pop();\n await sqlite.execute(\"DELETE FROM transactions WHERE id=?\", [id]);\n return json({ ok: true });\n }\n\n // ── GET /api/dividends ──────────────────────────────────────────────────────\n if (path === \"/api/dividends\" && method === \"GET\") {\n const r = await sqlite.execute(\n \"SELECT id,symbol,amount,tax_withheld,currency,ex_date,pay_date,notes FROM dividends ORDER BY ex_date DESC\"\n );\n return json(r.rows);\n }\n\n // ── POST /api/dividends ─────────────────────────────────────────────────────\n if (path === \"/api/dividends\" && method === \"POST\") {\n const b = await req.json();\n await sqlite.execute(\n \"INSERT INTO dividends(symbol,amount,tax_withheld,currency,ex_date,pay_date,notes) VALUES(?,?,?,?,?,?,?)\",\n [b.symbol, b.amount, b.tax_withheld ?? 0, b.currency || \"THB\", b.ex_date, b.pay_date || \"\", b.notes || \"\"]\n );\n return json({ ok: true });\n }\n\n // ── DELETE /api/dividends/:id ───────────────────────────────────────────────\n if (path.startsWith(\"/api/dividends/\") && method === \"DELETE\") {\n const id = path.split(\"/\").pop();\n await sqlite.execute(\"DELETE FROM dividends WHERE id=?\", [id]);\n return json({ ok: true });\n }\n\n // ── POST /api/chat ──────────────────────────────────────────────────────────\n if (path === \"/api/chat\" && method === \"POST\") {\n const b = await req.json();\n const key = Deno.env.get(\"ANTHROPIC_API_KEY\") ?? \"\";\n if (!key) return json({ reply: \"⚠️ กรุณาตั้งค่า ANTHROPIC_API_KEY ใน Val.town Environment Variables ก่อน\" });\n\n const portfolioContext = b.portfolioSummary\n ? `\\n\\nพอร์ตปัจจุบันของผู้ใช้: ${b.portfolioSummary.holdings} หุ้น, มูลค่ารวม ${b.portfolioSummary.totalValue?.toFixed(2)} ${b.portfolioSummary.baseCurrency}, กำไร/ขาดทุน ${b.portfolioSummary.totalPL?.toFixed(2)} ${b.portfolioSummary.baseCurrency}`\n : \"\";\n\n const r = await fetch(\"https://api.anthropic.com/v1/messages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", \"x-api-key\": key, \"anthropic-version\": \"2023-06-01\" },\n body: JSON.stringify({\n model: \"claude-opus-4-5\",\n max_tokens: 1024,\n system: `คุณคือที่ปรึกษาการลงทุนผู้เชี่ยวชาญ ตอบเป็นภาษาไทย วิเคราะห์หุ้นไทยและต่างประเทศ\nให้ความรู้ด้านการวิเคราะห์ทางเทคนิค (RSI, MACD, Moving Average) และปัจจัยพื้นฐาน\nตอบกระชับ ชัดเจน และมีประโยชน์ พร้อมตัวเลขและข้อมูลเมื่อเป็นไปได้${portfolioContext}`,\n messages: b.messages ?? [],\n }),\n });\n const d = await r.json();\n const reply = d.content?.[0]?.text ?? \"ไม่สามารถตอบได้ในขณะนี้\";\n return json({ reply });\n }\n\n // ── Serve HTML ──────────────────────────────────────────────────────────────\n return new Response(html(), { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}","deleted","label",[105],"permalink","https://www.val.town/x/purinut1997/untitled-8871/code/Wealthtrack.ts","extension","actionData","errors"]