\n \n

SharePoint 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(\n \"INSERT INTO sharepoint_admin_sessions (session_id) VALUES (?)\",\n [newSessionId],\n );\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(\n \"DELETE FROM sharepoint_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(\n \"DELETE FROM sharepoint_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\" });\n});\n\n// ====================================================================\n// 5. LOGIC HELPERS: KIỂM TRA LINK SHAREPOINT (Giữ nguyên gốc)\n// ====================================================================\nasync function checkSingleSharepoint(row) {\n if (row.is_paused) {\n return { id: row.id, status: \"PAUSED\", details: \"Đang ngừng theo dõi\" };\n }\n if (!row.resource_link || !row.resource_link.startsWith(\"http\")) {\n return { id: row.id, status: \"WARNING\", details: \"Link không hợp lệ\" };\n }\n\n try {\n let currentUrl = row.resource_link;\n let cookies = [];\n\n for (let i = 0; i < 7; i++) {\n const cookieHeader = cookies.join(\"; \");\n const response = await fetch(currentUrl, {\n method: \"GET\",\n redirect: \"manual\",\n headers: {\n \"User-Agent\":\n \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36\",\n \"Accept\":\n \"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8\",\n \"Accept-Language\": \"vi-VN,vi;q=0.9,en-US;q=0.8,en;q=0.7\",\n ...(cookieHeader ? { \"Cookie\": cookieHeader } : {}),\n },\n });\n\n if (typeof response.headers.getSetCookie === \"function\") {\n const newCookies = response.headers.getSetCookie();\n newCookies.forEach((c) => cookies.push(c.split(\";\")[0]));\n } else {\n const rawCookie = response.headers.get(\"set-cookie\");\n if (rawCookie) cookies.push(rawCookie.split(\";\")[0]);\n }\n\n const status = response.status;\n\n if (status === 429 || status === 503) {\n return {\n id: row.id,\n status: \"WARNING\",\n details: \"Bị giới hạn truy cập (HTTP 429) - Link vẫn sống\",\n };\n }\n\n if (status >= 300 && status < 400) {\n const location = response.headers.get(\"location\");\n if (!location) break;\n\n currentUrl = location.startsWith(\"http\")\n ? location\n : new URL(location, currentUrl).href;\n const finalUrlLower = currentUrl.toLowerCase();\n\n if (\n finalUrlLower.includes(\"login.microsoftonline.com\") ||\n finalUrlLower.includes(\"accessdenied.aspx\")\n ) {\n return {\n id: row.id,\n status: \"ERROR\",\n details: \"Yêu cầu đăng nhập (Link bị khóa)\",\n };\n }\n continue;\n }\n\n if (status === 200) {\n const htmlContent = await response.text();\n const lowerHtml = htmlContent.toLowerCase();\n if (\n lowerHtml.includes(\"this link has been removed\") ||\n lowerHtml.includes(\"this link has expired\") ||\n lowerHtml.includes(\"item does not exist\") ||\n lowerHtml.includes(\"liên kết này đã bị xóa\") ||\n lowerHtml.includes(\"we're sorry, but\") ||\n lowerHtml.includes('id=\"loginheader\"')\n ) {\n return {\n id: row.id,\n status: \"ERROR\",\n details: \"Link đã hết hạn hoặc bị xóa\",\n };\n }\n return { id: row.id, status: \"OK\", details: \"Link đang hoạt động tốt\" };\n }\n return { id: row.id, status: \"ERROR\", details: `HTTP Lỗi: ${status}` };\n }\n return {\n id: row.id,\n status: \"ERROR\",\n details: \"Lỗi: Quá nhiều vòng chuyển hướng\",\n };\n } catch (e) {\n return {\n id: row.id,\n status: \"ERROR\",\n details: `Lỗi hệ thống: ${e.message}`,\n };\n }\n}\n\n// ====================================================================\n// 6. API ROUTES\n// ====================================================================\napp.get(\"/api/list\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT * FROM sharepoint_monitor ORDER BY sort_order ASC, created_at DESC\",\n );\n return c.json(result.rows);\n});\n\napp.post(\"/api/add\", async (c) => {\n const body = await c.req.json();\n const maxOrderRes = await sqlite.execute(\n \"SELECT MAX(sort_order) as max FROM sharepoint_monitor\",\n );\n const nextOrder = (maxOrderRes.rows[0].max !== null)\n ? maxOrderRes.rows[0].max + 1\n : 0;\n await sqlite.execute(\n `INSERT INTO sharepoint_monitor (name, resource_link, status, is_paused, sort_order, created_at) VALUES (?, ?, ?, 0, ?, datetime('now'))`,\n [body.name, body.resource_link, \"PENDING\", nextOrder],\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/update\", async (c) => {\n const body = await c.req.json();\n await sqlite.execute(\n `UPDATE sharepoint_monitor SET name = ?, resource_link = ? WHERE id = ?`,\n [body.name, body.resource_link, body.id],\n );\n return c.json({ success: true });\n});\n\napp.post(\"/api/save-order\", async (c) => {\n const body = await c.req.json();\n for (let i = 0; i < body.order.length; i++) {\n await sqlite.execute(\n \"UPDATE sharepoint_monitor SET sort_order = ? WHERE id = ?\",\n [i, body.order[i]],\n );\n }\n return c.json({ success: true });\n});\n\napp.post(\"/api/toggle-pause\", async (c) => {\n const body = await c.req.json();\n const cur = await sqlite.execute(\n \"SELECT is_paused FROM sharepoint_monitor WHERE id = ?\",\n [body.id],\n );\n const newState = cur.rows[0].is_paused ? 0 : 1;\n const newStatus = newState ? \"PAUSED\" : \"PENDING\";\n await sqlite.execute(\n `UPDATE sharepoint_monitor SET is_paused = ?, status = ? WHERE id = ?`,\n [newState, newStatus, body.id],\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 sharepoint_monitor WHERE id = ?`, [\n body.id,\n ]);\n return c.json({ success: true });\n});\n\napp.post(\"/api/check-all\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM sharepoint_monitor\");\n const currentErrors = [];\n const updates = [];\n\n for (const row of result.rows) {\n const res = await checkSingleSharepoint(row);\n await sqlite.execute(\n `UPDATE sharepoint_monitor SET status = ?, details = ?, last_check = datetime('now') WHERE id = ?`,\n [res.status, res.details, res.id],\n );\n updates.push(res);\n if (res.status === \"ERROR\") currentErrors.push(res.id);\n await new Promise((resolve) => setTimeout(resolve, 800));\n }\n return c.json({ success: true, updates, current_errors: currentErrors });\n});\n\n// ====================================================================\n// 7. UI TEMPLATE & ROUTE\n// ====================================================================\napp.get(\"/\", (c) => {\n return c.html(`\n \n \n \n \n \n SharePoint Sentinel\n \n \n \n \n \n \n \n \n

\n SharePoint Sentinel\n

\n \n \n \n

\n \n \n

\n\n \n\n \n\n \n \n \n `);\n});\n\nexport default function (req: Request): Response | Promise {\n return app.fetch(req);\n}","deleted","label",[113],"f6491588-395f-11f1-a880-42b51c65c3df","cron.ts","019c784e-8a1e-7323-9e6b-710a5e365db9",["D",1776321974166],"interval","import sqlite from \"https://esm.town/v/std/db/main.ts\";\n\n// --- CẤU HÌNH ---\nconst VAL_MAIN_API_URL = `${Deno.env.get(\"VAL_MAIN_API_URL\")}/api/check-all`;\nconst NTFY_TOPIC = Deno.env.get(\"NTFY_TOPIC\");\n\nexport default async function (interval: Interval) {\n console.log(\"🕒 Starting SharePoint Cron Check...\");\n\n // LẤY MẬT KHẨU TỪ ENVIRONMENT ĐỂ MỞ CỬA API\n const ADMIN_PASS = Deno.env.get(\"ADMIN_PASS\");\n\n // 1. Gọi API Check-All từ Val Chính CÓ KÈM AUTHORIZATION HEADER\n const response = await fetch(VAL_MAIN_API_URL, {\n method: \"POST\",\n headers: {\n \"Authorization\": `Bearer ${ADMIN_PASS}`, // <--- ĐIỂM BẢO MẬT\n },\n });\n\n if (!response.ok) {\n if (response.status === 401) {\n console.error(\n \"❌ Lỗi 401: Cron Job không được cấp quyền (Sai ADMIN_PASS). Hãy kiểm tra lại biến môi trường.\",\n );\n } else {\n console.error(\"❌ Failed to trigger check:\", response.statusText);\n }\n return;\n }\n\n const data = await response.json();\n const currentErrors = data.current_errors || [];\n\n // 2. Lấy danh sách lỗi cũ từ DB (Lưu tạm trong 1 bảng riêng cho Cron này)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS cron_sharepoint_error (\n id INTEGER PRIMARY KEY,\n error_ids TEXT\n )\n `);\n\n const prevRes = await sqlite.execute(\n \"SELECT error_ids FROM cron_sharepoint_error WHERE id = 1\",\n );\n\n let previousErrors = [];\n if (prevRes.rows.length > 0) {\n previousErrors = JSON.parse(prevRes.rows[0].error_ids || \"[]\");\n } else {\n // Lần đầu chạy -> Insert\n await sqlite.execute(\n \"INSERT INTO cron_sharepoint_error (id, error_ids) VALUES (1, '[]')\",\n );\n }\n\n // 3. So sánh: Tìm các lỗi MỚI xuất hiện\n const newErrors = currentErrors.filter((id) => !previousErrors.includes(id));\n\n // 4. Nếu có lỗi mới -> Gửi thông báo\n if (newErrors.length > 0) {\n console.log(\n `⚠️ Found ${newErrors.length} new SharePoint errors. Sending notification...`,\n );\n\n await fetch(`https://ntfy.sh/${NTFY_TOPIC}`, {\n method: \"POST\",\n body:\n \"Cảnh báo: Phát hiện tài nguyên SharePoint/OneDrive bị lỗi hoặc mất quyền truy cập. Kiểm tra ngay.\",\n headers: {\n \"Title\": \"SharePoint Sentinel Alert\", // ASCII chuẩn\n \"Priority\": \"high\",\n \"Tags\": \"warning\",\n },\n });\n } else {\n console.log(\"✅ No new errors found.\");\n }\n\n // 5. Cập nhật lại danh sách lỗi hiện tại vào DB\n await sqlite.execute(\n \"UPDATE cron_sharepoint_error SET error_ids = ? WHERE id = 1\",\n [JSON.stringify(currentErrors)],\n );\n}",[131],"pulls","branches","forks","envVars",{"_144":119,"_146":41},"connections",{"_144":41,"_145":41},"count","unfilledCount","emptyCount",{"_18":130,"_20":131,"_114":132,"_116":-5,"_117":70,"_118":68,"_120":105,"_22":153,"_67":119,"_123":134,"_125":135,"_127":26,"_128":-5,"_150":154,"_88":155},{"_18":112,"_20":113,"_114":115,"_116":-5,"_117":70,"_118":119,"_120":105,"_22":149,"_67":122,"_123":124,"_125":126,"_127":26,"_128":-5,"_150":151,"_88":152},["D",1772187667109],"children",[],[113],["D",1776321974166],[],[131],["D",1771544938953],["D",1789529498250],{"_16":17,"_86":82},{"_16":17,"_79":80,"_81":82,"_34":35,"_83":84,"_85":26},{"_67":68,"_20":69,"_18":70,"_71":19,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":21,"_78":17},"ctx",{"_60":-5,"_107":194,"_195":196,"_197":198,"_199":26,"_200":26,"_201":26,"_202":105,"_203":-5,"_204":-7,"_205":-7,"_206":41,"_207":26,"_208":26,"_209":-5,"_210":26,"_211":26,"_212":26,"_213":-5},"ENV",{"_165":166,"_167":168,"_169":69,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

SharePoint Sentinel

\n SharePoint Sentinel\n

Thêm tài nguyên SharePoint

Resource Name

Search