SPB Git

Repository Public

stats.ts 3.1 KB 67 lines typescript

1import crypto from "node:crypto";2import { getDb, getSetting, setSetting, tx } from "./db";3import { addDays, todayLocal } from "./booking/tz";45/**6 * Statistiques de fréquentation internes : compteurs agrégés par jour et par page.7 * Aucun témoin, aucune adresse IP conservée. Les visiteurs uniques du jour sont comptés8 * à l'aide d'une empreinte salée par un sel quotidien jetable, effacée le lendemain.9 */10const BOT = /bot|crawl|spider|slurp|headless|lighthouse|pingdom|monitor|curl|wget|python|node-fetch|axios|playwright/i;1112function dailySalt(day: string): string {13  const cur = getSetting<{ day: string; salt: string } | null>("stats_salt", null);14  if (cur && cur.day === day) return cur.salt;15  const salt = crypto.randomBytes(24).toString("base64url");16  setSetting("stats_salt", { day, salt });17  return salt;18}1920export function recordView(pathname: string, ip: string, userAgent: string, now = Date.now()): boolean {21  if (!userAgent || BOT.test(userAgent)) return false;22  const path = pathname.split(/[?#]/)[0].slice(0, 120);23  if (!/^\/[A-Za-z0-9\-/_]*$/.test(path) || /^\/(admin|api|media|_next)/.test(path)) return false;24  const day = todayLocal(now);25  const db = getDb();26  const hash = crypto.createHash("sha256").update(`${dailySalt(day)}|${ip}|${userAgent}`).digest("hex").slice(0, 20);27  tx(db, () => {28    db.prepare("INSERT INTO page_views (day, path, views) VALUES (?, ?, 1) ON CONFLICT(day, path) DO UPDATE SET views = views + 1").run(day, path);29    const r = db.prepare("INSERT OR IGNORE INTO daily_visitors (day, hash) VALUES (?, ?)").run(day, hash);30    if (Number(r.changes) > 0) {31      db.prepare("INSERT INTO page_views (day, path, views) VALUES (?, '#visiteurs', 1) ON CONFLICT(day, path) DO UPDATE SET views = views + 1").run(day);32    }33    db.prepare("DELETE FROM daily_visitors WHERE day < ?").run(day);34  });35  return true;36}3738export interface StatsSummary {39  series: { day: string; views: number; visitors: number }[];40  top: { path: string; views: number }[];41  totals: { views: number; visitors: number };42}4344export function statsSummary(days: number, now = Date.now()): StatsSummary {45  const db = getDb();46  const end = todayLocal(now);47  const start = addDays(end, -(days - 1));48  const rows = db.prepare("SELECT day, path, views FROM page_views WHERE day >= ? AND day <= ?").all(start, end) as { day: string; path: string; views: number }[];49  const series = Array.from({ length: days }, (_, i) => ({ day: addDays(start, i), views: 0, visitors: 0 }));50  const idx = new Map(series.map((s, i) => [s.day, i]));51  const top = new Map<string, number>();52  for (const r of rows) {53    const s = series[idx.get(r.day) ?? -1];54    if (!s) continue;55    if (r.path === "#visiteurs") s.visitors += r.views;56    else {57      s.views += r.views;58      top.set(r.path, (top.get(r.path) ?? 0) + r.views);59    }60  }61  return {62    series,63    top: [...top.entries()].map(([path, views]) => ({ path, views })).sort((a, b) => b.views - a.views).slice(0, 10),64    totals: { views: series.reduce((n, s) => n + s.views, 0), visitors: series.reduce((n, s) => n + s.visitors, 0) },65  };66}67
Files main
Menu

Theme