\n \n

Microsoft Sentinel

Vui lòng đăng nhập hệ thống

\n ${\n error\n ? `

Sai tài khoản hoặc mật khẩu

`\n : \"\"\n }\n \n

\n \n \n \n `);\n});\n\napp.post(\"/login\", async (c) => {\n const body = await c.req.parseBody();\n if (body.username === ADMIN_USER && body.password === ADMIN_PASS) {\n await ensureDB();\n const newSessionId = crypto.randomUUID();\n await sqlite.execute(\"INSERT INTO admin_sessions (session_id) VALUES (?)\", [\n newSessionId,\n ]);\n\n // Bảo mật: sameSite Lax cần thiết cho luồng chuyển hướng OAuth\n setCookie(c, COOKIE_NAME, newSessionId, {\n path: \"/\",\n secure: true,\n httpOnly: true,\n maxAge: 60 * 60 * 24 * 7,\n sameSite: \"Lax\",\n });\n return c.redirect(\"/\");\n }\n return c.redirect(\"/login?error=1\");\n});\n\napp.get(\"/logout\", async (c) => {\n const currentSessionId = getCookie(c, COOKIE_NAME);\n if (currentSessionId) {\n await ensureDB();\n await sqlite.execute(\"DELETE FROM admin_sessions WHERE session_id = ?\", [\n currentSessionId,\n ]);\n }\n deleteCookie(c, COOKIE_NAME, { path: \"/\" });\n return c.redirect(\"/login\");\n});\n\napp.post(\"/api/auth/logout-others\", async (c) => {\n const currentSessionId = c.get(\"sessionId\");\n if (currentSessionId) {\n await sqlite.execute(\"DELETE FROM admin_sessions WHERE session_id != ?\", [\n currentSessionId,\n ]);\n return c.json({ success: true });\n }\n return c.json({ success: false, error: \"Không tìm thấy phiên hoạt động\" });\n});\n\n// ====================================================================\n// 6. ENDPOINT QUẢN LÝ DỮ LIỆU BÊN TRONG HỆ THỐNG\n// ====================================================================\n\n// Kích hoạt luồng Microsoft OAuth\napp.get(\"/api/auth/login\", async (c) => {\n if (!CLIENT_ID || !CLIENT_SECRET) {\n return c.text(\"Lỗi hệ thống: Chưa cấu hình biến môi trường Azure App.\");\n }\n\n const authUrl =\n `https://login.microsoftonline.com/common/oauth2/v2.0/authorize` +\n `?client_id=${CLIENT_ID}` +\n `&response_type=code` +\n `&redirect_uri=${encodeURIComponent(getRedirectUri(c))}` +\n `&response_mode=query` +\n `&scope=${encodeURIComponent(\"User.Read offline_access\")}` +\n `&prompt=select_account`;\n\n return c.redirect(authUrl);\n});\n\n// Nhận mã Code từ Microsoft và đổi lấy Token\napp.get(\"/api/auth/callback\", async (c) => {\n const code = c.req.query(\"code\");\n const error = c.req.query(\"error\");\n\n if (error) return c.text(`Lỗi cấp quyền từ Microsoft: ${error}`);\n if (!code) return c.text(\"Không nhận được Authorization Code.\");\n\n try {\n // 1. Đổi Code lấy Access & Refresh Token\n const tokenParams = new URLSearchParams({\n client_id: CLIENT_ID,\n client_secret: CLIENT_SECRET,\n grant_type: \"authorization_code\",\n code: code,\n redirect_uri: getRedirectUri(c),\n });\n\n const resToken = await fetch(MS_TOKEN_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/x-www-form-urlencoded\" },\n body: tokenParams.toString(),\n });\n\n const tokenData = await resToken.json();\n if (!tokenData.refresh_token) {\n throw new Error(\n \"Cấu hình Azure thiếu quyền offline_access hoặc bị sai lệch.\",\n );\n }\n\n // 2. Lấy thông tin User Profile\n const resMe = await fetch(MS_GRAPH_ME, {\n headers: { \"Authorization\": `Bearer ${tokenData.access_token}` },\n });\n const meData = await resMe.json();\n if (!resMe.ok) {\n throw new Error(\n meData.error?.message || \"Lỗi truy cập dữ liệu User Profile\",\n );\n }\n\n const email = meData.userPrincipalName || meData.mail || \"unknown@ms.com\";\n const displayName = meData.displayName || email;\n\n // 3. Cập nhật hoặc Thêm mới vào DB\n const existing = await sqlite.execute(\n \"SELECT id FROM ms_personal_monitor WHERE ms_user_id = ?\",\n [meData.id],\n );\n\n if (existing.rows.length > 0) {\n await sqlite.execute(\n \"UPDATE ms_personal_monitor SET refresh_token = ?, name = ?, email = ?, status = 'OK', account_status = 'Active', details = 'Vừa kết nối lại', last_check = datetime('now') WHERE ms_user_id = ?\",\n [tokenData.refresh_token, displayName, email, meData.id],\n );\n } else {\n const maxOrderQuery = await sqlite.execute(\n \"SELECT MAX(sort_order) as max FROM ms_personal_monitor\",\n );\n const nextOrder = maxOrderQuery.rows[0].max !== null\n ? maxOrderQuery.rows[0].max + 1\n : 0;\n await sqlite.execute(\n `INSERT INTO ms_personal_monitor (name, ms_user_id, email, refresh_token, status, account_status, details, sort_order) VALUES (?, ?, ?, ?, 'OK', 'Active', 'Mới thêm', ?)`,\n [displayName, meData.id, email, tokenData.refresh_token, nextOrder],\n );\n }\n return c.html(``);\n } catch (err) {\n return c.text(`Lỗi xử lý kết nối: ${err.message}`);\n }\n});\n\n// Các API xử lý cơ sở dữ liệu\napp.get(\"/api/list\", async (c) => {\n const query =\n \"SELECT id, name, ms_user_id, email, status, account_status, last_check, details, is_paused FROM ms_personal_monitor ORDER BY sort_order ASC, created_at DESC\";\n const result = await sqlite.execute(query);\n return c.json(result.rows);\n});\n\napp.post(\"/api/save-order\", async (c) => {\n const { order } = await c.req.json();\n const promises = order.map((id, index) =>\n sqlite.execute(\n \"UPDATE ms_personal_monitor SET sort_order = ? WHERE id = ?\",\n [index, id],\n )\n );\n await Promise.all(promises);\n return c.json({ success: true });\n});\n\napp.post(\"/api/toggle-pause\", async (c) => {\n const { id } = await c.req.json();\n const cur = await sqlite.execute(\n \"SELECT is_paused FROM ms_personal_monitor WHERE id = ?\",\n [id],\n );\n const newState = cur.rows[0].is_paused ? 0 : 1;\n await sqlite.execute(\n \"UPDATE ms_personal_monitor SET is_paused = ?, status = ?, details = ? WHERE id = ?\",\n [\n newState,\n newState ? \"PAUSED\" : \"PENDING\",\n newState ? \"Đang tạm dừng\" : \"Chờ kiểm tra lại\",\n id,\n ],\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/delete\", async (c) => {\n const body = await c.req.json();\n await sqlite.execute(\"DELETE FROM ms_personal_monitor WHERE id = ?\", [\n body.id,\n ]);\n return c.json({ success: true });\n});\n\n// Logic quét kiểm tra tự động (Batch Processor)\napp.post(\"/api/check-all\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM ms_personal_monitor\");\n const redirectUri = getRedirectUri(c);\n\n // Chạy kiểm tra đồng thời cho tất cả tài khoản\n const checkPromises = result.rows.map((row) =>\n checkMicrosoftAccount(row, redirectUri)\n );\n const results = await Promise.all(checkPromises);\n const currentErrors = [];\n\n // Cập nhật lại kết quả vào DB đồng thời\n const updatePromises = results.map((res) => {\n if (res.status === \"ERROR\" || res.status === \"WARNING\") {\n currentErrors.push(res.id);\n }\n\n let query =\n \"UPDATE ms_personal_monitor SET status = ?, account_status = ?, details = ?, email = ?, name = ?, last_check = datetime('now') WHERE id = ?\";\n let params = [\n res.status,\n res.account_status,\n res.details,\n res.email,\n res.name,\n res.id,\n ];\n\n // Cập nhật Token nếu có token mới từ MS\n if (res.new_refresh_token) {\n query =\n \"UPDATE ms_personal_monitor SET status = ?, account_status = ?, details = ?, email = ?, name = ?, refresh_token = ?, last_check = datetime('now') WHERE id = ?\";\n params = [\n res.status,\n res.account_status,\n res.details,\n res.email,\n res.name,\n res.new_refresh_token,\n res.id,\n ];\n }\n return sqlite.execute(query, params);\n });\n\n await Promise.all(updatePromises);\n return c.json({ success: true, current_errors: currentErrors });\n});\n\n// ====================================================================\n// 7. GIAO DIỆN CHÍNH (FRONTEND)\n// ====================================================================\napp.get(\"/\", (c) => {\n const isConfigured = !!(CLIENT_ID && CLIENT_SECRET);\n return c.html(`\n \n \n \n \n \n MS Personal Sentinel\n \n \n \n \n \n \n \n \n

\n MS Sentinel\n

\n \n \n \n

\n ${\n isConfigured\n ? `\n \n \n `\n : ``\n }\n

\n\n \n \n \n `);\n});\n\nexport default app.fetch;","deleted","label",[100],"permalink","https://www.val.town/x/varina_lab/MS_Sentinel/code/main.ts","extension","actionData","errors"]