SPB Git

Repository Public

AdminPanel.tsx 21.0 KB 109 lines tsx

1// UQO Éval — Métré : console d'administration — sources (ingestion SEAO / permis, import CSV de barèmes, QA), codes d'accès, devoirs, audit.2"use client";3import { useCallback, useEffect, useState } from "react";4import { useLang } from "@/components/LangContext";5import { api, Block, Btn, Crumbs, dt, Err, Field, Input, Kicker, LoginCard, num, Select, Textarea, useMe } from "./ui";67interface Overview { sources: Record<string, unknown>[]; documents: Record<string, unknown>[]; runs: Record<string, unknown>[]; flags: Record<string, unknown>[]; byClass: { evidenceClass: string; n: number; first: string | null; last: string | null }[] }89export default function AdminPanel() {10  const { lang } = useLang(); const fr = lang === "fr";11  const me = useMe();12  const [ov, setOv] = useState<Overview | null>(null);13  const [codes, setCodes] = useState<Record<string, unknown>[]>([]);14  const [audit, setAudit] = useState<Record<string, unknown>[]>([]);15  const [err, setErr] = useState<string | null>(null);16  const [msg, setMsg] = useState<string | null>(null);17  const [busy, setBusy] = useState(false);18  const [imp, setImp] = useState({ source: "mtl_dtni", title: "", url: "", publicationDate: "", effectiveDate: "", license: "", evidenceClass: "published_schedule", geography: "Montréal", regionCode: "QC-MTL", csv: "" });19  const [code, setCode] = useState({ role: "student", label: "", course: "IMM1033", maxUses: "", expiresAt: "" });20  const [assign, setAssign] = useState({ course: "IMM1033", title: "", instructions: "", dueAt: "", answerKey: "" });21  const load = () => Promise.all([api<Overview>("/admin/sources").then(setOv), api<{ codes: Record<string, unknown>[] }>("/admin/access-codes").then((r) => setCodes(r.codes)), api<{ events: Record<string, unknown>[] }>("/admin/audit?limit=100").then((r) => setAudit(r.events))]).catch((e) => setErr(e.message));22  useEffect(() => { if (me.user && (me.user.role === "admin" || me.user.role === "instructor")) void load(); }, [me.user]);23  if (me.loading) return null;24  if (!me.user || (me.user.role !== "admin" && me.user.role !== "instructor")) return <LoginCard onDone={me.refresh} />;25  const admin = me.user.role === "admin";26  const run = async (fn: () => Promise<unknown>, okMsg?: string) => { setBusy(true); setErr(null); setMsg(null); try { const r = await fn(); setMsg(okMsg ?? JSON.stringify(r).slice(0, 400)); await load(); } catch (e) { setErr((e as Error).message); } finally { setBusy(false); } };27  return (28    <div className="py-8">29      <section className="rise"><div className="border-b-2 border-ink pb-2.5"><Crumbs items={[{ href: "/", label: "UQO Éval" }, { href: "/quantity-survey", label: "Quantity Survey" }, { label: fr ? "Administration" : "Administration" }]} /></div>30        <div className="mt-5"><Kicker>{fr ? "Administration du module" : "Module administration"}</Kicker><h1 className="vp-display mt-2 text-[clamp(22px,3.4vw,34px)] font-bold uppercase leading-[1.02] tracking-[-0.03em]">{fr ? "Sources, qualité des données, accès, devoirs, journal" : "Sources, data quality, access, assignments, log"}</h1></div>31        <Err msg={err} />{msg && <p className="vp-mono mt-2 text-[11px] text-accent break-all">{msg}</p>}32      </section>33      <div className="mt-8 space-y-12">34        <Block num="01" title={fr ? "Sources et licences" : "Sources and licences"} aside={admin && <div className="flex gap-2"><Btn small disabled={busy} onClick={() => run(() => api("/admin/sources", { method: "POST", json: { action: "ingest", source: "seao", weeks: 2 } }))}>{fr ? "Ingérer SEAO (2 sem.)" : "Ingest SEAO (2 wk)"}</Btn><Btn small disabled={busy} onClick={() => run(() => api("/admin/sources", { method: "POST", json: { action: "ingest", source: "mtl_permits" } }))}>{fr ? "Ingérer permis Montréal" : "Ingest Montréal permits"}</Btn></div>}>35          <div className="src-wrap"><table className="src-table"><thead><tr><th>{fr ? "Clé" : "Key"}</th><th>{fr ? "Source" : "Source"}</th><th>{fr ? "Classe" : "Class"}</th><th>{fr ? "Accès" : "Access"}</th><th>{fr ? "Licence" : "Licence"}</th><th className="text-right">Docs</th><th className="text-right">Obs.</th><th>{fr ? "Dernier run" : "Last run"}</th></tr></thead><tbody>36            {ov?.sources.map((s) => <tr key={String(s.key)}><td className="vp-mono text-[11px]">{String(s.key)}</td><td className="text-[12.5px]">{String(s.name)}<div className="text-[10.5px] text-ink-3">{String(s.publisher)}{s.url ? <> · <a className="text-accent" href={String(s.url)} target="_blank" rel="noreferrer">{fr ? "lien" : "link"}</a></> : null}</div><div className="text-[10.5px] text-ink-2">{String(s.notes ?? "")}</div></td><td className="vp-mono text-[10.5px] uppercase">{String(s.evidence_class)}</td><td className="vp-mono text-[10.5px] uppercase">{String(s.access)}</td><td className="text-[11.5px]">{s.license_url ? <a className="text-accent" href={String(s.license_url)} target="_blank" rel="noreferrer">{String(s.license)}</a> : String(s.license)}</td><td className="vp-mono text-right">{String(s.documents)}</td><td className="vp-mono text-right">{String(s.observations)}</td><td className="vp-mono text-[10.5px]">{s.last_run_at ? `${dt(String(s.last_run_at), lang)} · ${String(s.last_status)}` : "—"}{s.last_error ? <div className="text-[var(--danger)]">{String(s.last_error).slice(0, 120)}</div> : null}</td></tr>)}37          </tbody></table></div>38          <div className="flex flex-wrap gap-x-5 gap-y-2">{ov?.byClass.map((c) => <span key={c.evidenceClass} className="stat-chip"><b>{num(c.n, lang, 0)}</b> {c.evidenceClass} · {c.first ?? "?"} → {c.last ?? "?"}</span>)}</div>39        </Block>40        <Block num="02" title={fr ? "Import manuel d'un barème (CSV)" : "Manual schedule import (CSV)"}>41          <p className="text-[13.5px] text-ink-2">{fr ? "Pour les documents sans accès automatisé (DTNI-11A/11B de Montréal, bordereaux MTMD, grilles). Téléchargez légalement le document, transcrivez-le en CSV (colonnes : code, description, unite, prix, categorie, inclut_materiau, inclut_main_doeuvre, inclut_equipement, taxes, date_effet, region, note) et indiquez la licence / les droits de réutilisation. Le fichier brut est conservé avec son empreinte ; chaque ligne devient une observation à vérifier." : "For documents without automated access (Montréal DTNI-11A/11B, MTMD schedules, grids). Download the document legally, transcribe it to CSV (columns: code, description, unit, price, category, includes_material, includes_labour, includes_equipment, tax, effective_date, region, note) and state the licence / reuse rights. The raw file is kept with its hash; each row becomes an observation to verify."}</p>42          <div className="grid gap-4 sm:grid-cols-2 lg:grid-cols-4">43            <Field label="Source"><Select value={imp.source} onChange={(e) => setImp({ ...imp, source: e.target.value })}>{ov?.sources.filter((s) => s.access === "manual_import" || s.key === "uqo_catalogue").map((s) => <option key={String(s.key)} value={String(s.key)}>{String(s.key)}</option>)}</Select></Field>44            <Field label={fr ? "Titre du document" : "Document title"}><Input value={imp.title} onChange={(e) => setImp({ ...imp, title: e.target.value })} /></Field>45            <Field label="URL"><Input value={imp.url} onChange={(e) => setImp({ ...imp, url: e.target.value })} /></Field>46            <Field label={fr ? "Licence / droits (obligatoire)" : "Licence / rights (required)"}><Input value={imp.license} onChange={(e) => setImp({ ...imp, license: e.target.value })} /></Field>47            <Field label={fr ? "Date de publication" : "Publication date"}><Input type="date" value={imp.publicationDate} onChange={(e) => setImp({ ...imp, publicationDate: e.target.value })} /></Field>48            <Field label={fr ? "Date d'effet" : "Effective date"}><Input type="date" value={imp.effectiveDate} onChange={(e) => setImp({ ...imp, effectiveDate: e.target.value })} /></Field>49            <Field label={fr ? "Classe d'évidence" : "Evidence class"}><Select value={imp.evidenceClass} onChange={(e) => setImp({ ...imp, evidenceClass: e.target.value })}>{["published_schedule", "awarded_unit_bid", "supplier_quote", "contractor_quote"].map((c) => <option key={c} value={c}>{c}</option>)}</Select></Field>50            <Field label={fr ? "Géographie / région" : "Geography / region"}><div className="flex gap-2"><Input value={imp.geography} onChange={(e) => setImp({ ...imp, geography: e.target.value })} /><Input value={imp.regionCode} onChange={(e) => setImp({ ...imp, regionCode: e.target.value })} className="vp-mono w-[90px]" /></div></Field>51          </div>52          <Field label="CSV"><Textarea rows={6} value={imp.csv} onChange={(e) => setImp({ ...imp, csv: e.target.value })} className="vp-mono text-[12px]" placeholder={"code,description,unite,prix,categorie,inclut_materiau,inclut_main_doeuvre,inclut_equipement,taxes,date_effet,region,note\n11A-0301,Béton de ciment 30 MPa,m3,285.00,Béton,oui,non,non,avant,2026-06-01,Montréal,"} /></Field>53          <Btn small tone="primary" disabled={busy || !imp.csv || !imp.license} onClick={() => run(() => api("/admin/sources", { method: "POST", json: { action: "import", ...imp } }))}>{fr ? "Importer" : "Import"}</Btn>54        </Block>55        <Block num="03" title={fr ? "Documents ingérés et contrôle qualité" : "Ingested documents and quality control"}>56          <div className="src-wrap"><table className="src-table"><thead><tr><th>Source</th><th>{fr ? "Titre" : "Title"}</th><th>{fr ? "Récupéré" : "Retrieved"}</th><th>{fr ? "Hash" : "Hash"}</th><th className="text-right">{fr ? "Enreg." : "Records"}</th><th>QA</th>{admin && <th></th>}</tr></thead><tbody>57            {ov?.documents.map((x) => <tr key={String(x.id)}><td className="vp-mono text-[11px]">{String(x.sourceKey)}</td><td className="text-[12.5px]">{String(x.title)}<div className="text-[10.5px] text-ink-3">{String(x.license)} · {String(x.parserVersion)} · {Math.round(Number(x.bytes) / 1024)} ko</div></td><td className="vp-mono text-[10.5px]">{dt(String(x.retrievedAt), lang)}</td><td className="vp-mono text-[10px] text-ink-3">{String(x.hash).slice(0, 12)}…</td><td className="vp-mono text-right">{String(x.records)}</td><td className="vp-mono text-[10.5px] uppercase">{String(x.qaStatus)}</td>{admin && <td className="whitespace-nowrap"><Btn small onClick={() => run(() => api("/admin/sources", { method: "POST", json: { action: "qa", documentId: x.id, status: "published" } }), "publié")}>{fr ? "Publier" : "Publish"}</Btn> <Btn small onClick={() => run(() => api("/admin/sources", { method: "POST", json: { action: "qa", documentId: x.id, status: "rejected" } }), "rejeté")}>{fr ? "Rejeter" : "Reject"}</Btn></td>}</tr>)}58            {!ov?.documents.length && <tr><td colSpan={7} className="text-ink-2">—</td></tr>}59          </tbody></table></div>60          {ov?.flags.length ? <ul className="space-y-0.5 text-[12.5px]">{ov.flags.map((f) => <li key={String(f.id)}><span className="vp-mono text-[10px] uppercase text-[var(--amber)]">{String(f.severity)} {String(f.code)}</span> {String(f.message)} <span className="text-ink-3">({String(f.entityType)} {String(f.entityId).slice(0, 8)})</span></li>)}</ul> : null}61          {ov?.runs.length ? <div className="src-wrap"><table className="src-table"><thead><tr><th>Run</th><th>Source</th><th>{fr ? "Début" : "Start"}</th><th>{fr ? "État" : "Status"}</th><th className="text-right">Docs</th><th className="text-right">{fr ? "Enreg." : "Records"}</th><th className="text-right">{fr ? "Ignorés" : "Skipped"}</th><th className="text-right">{fr ? "Erreurs" : "Errors"}</th></tr></thead><tbody>{ov.runs.map((r) => <tr key={String(r.id)}><td className="vp-mono">{String(r.id)}</td><td className="vp-mono text-[11px]">{String(r.sourceKey)}</td><td className="vp-mono text-[10.5px]">{dt(String(r.startedAt), lang)}</td><td className="vp-mono text-[10.5px] uppercase">{String(r.status)}</td><td className="vp-mono text-right">{String(r.documents)}</td><td className="vp-mono text-right">{String(r.records)}</td><td className="vp-mono text-right">{String(r.skipped)}</td><td className="vp-mono text-right">{String(r.errors)}</td></tr>)}</tbody></table></div> : null}62        </Block>63        <Block num="04" title={fr ? "Codes d'accès" : "Access codes"}>64          <div className="grid gap-4 sm:grid-cols-2 lg:grid-cols-5">65            <Field label={fr ? "Rôle" : "Role"}><Select value={code.role} onChange={(e) => setCode({ ...code, role: e.target.value })}><option value="student">{fr ? "étudiant" : "student"}</option>{admin && <><option value="instructor">{fr ? "enseignant" : "instructor"}</option><option value="professional">{fr ? "professionnel" : "professional"}</option><option value="admin">admin</option></>}</Select></Field>66            <Field label={fr ? "Libellé" : "Label"}><Input value={code.label} onChange={(e) => setCode({ ...code, label: e.target.value })} /></Field>67            <Field label={fr ? "Cours" : "Course"}><Input value={code.course} onChange={(e) => setCode({ ...code, course: e.target.value })} /></Field>68            <Field label={fr ? "Usages max" : "Max uses"}><Input type="number" min={1} value={code.maxUses} onChange={(e) => setCode({ ...code, maxUses: e.target.value })} /></Field>69            <Field label={fr ? "Expire le" : "Expires on"}><Input type="date" value={code.expiresAt} onChange={(e) => setCode({ ...code, expiresAt: e.target.value })} /></Field>70          </div>71          <Btn small tone="primary" disabled={busy} onClick={() => run(() => api<{ code: string }>("/admin/access-codes", { method: "POST", json: { ...code, maxUses: code.maxUses ? Number(code.maxUses) : null, expiresAt: code.expiresAt || null } }).then((r) => `${fr ? "CODE (affiché une seule fois)" : "CODE (shown once)"} : ${r.code}`))}>{fr ? "Générer un code" : "Generate a code"}</Btn>72          <div className="src-wrap"><table className="src-table"><thead><tr><th>{fr ? "Indice" : "Hint"}</th><th>{fr ? "Rôle" : "Role"}</th><th>{fr ? "Libellé" : "Label"}</th><th>{fr ? "Cours" : "Course"}</th><th className="text-right">{fr ? "Usages" : "Uses"}</th><th>{fr ? "Expire" : "Expires"}</th><th>{fr ? "Actif" : "Active"}</th><th></th></tr></thead><tbody>{codes.map((c) => <tr key={String(c.id)}><td className="vp-mono">{String(c.hint)}</td><td className="vp-mono text-[11px] uppercase">{String(c.role)}</td><td className="text-[12.5px]">{String(c.label ?? "")}</td><td className="vp-mono text-[11px]">{String(c.course ?? "")}</td><td className="vp-mono text-right">{String(c.uses)}{c.maxUses ? ` / ${String(c.maxUses)}` : ""}</td><td className="vp-mono text-[11px]">{c.expiresAt ? String(c.expiresAt).slice(0, 10) : "—"}</td><td>{c.active ? "✓" : "✕"}</td><td>{c.active ? <Btn small onClick={() => run(() => api("/admin/access-codes", { method: "DELETE", json: { id: c.id } }), "désactivé")}>{fr ? "Désactiver" : "Deactivate"}</Btn> : null}</td></tr>)}</tbody></table></div>73        </Block>74        <Block num="05" title={fr ? "Devoirs (corrigé protégé)" : "Assignments (protected answer key)"}>75          <div className="grid gap-4 sm:grid-cols-2 lg:grid-cols-4"><Field label={fr ? "Cours" : "Course"}><Input value={assign.course} onChange={(e) => setAssign({ ...assign, course: e.target.value })} /></Field><Field label={fr ? "Titre" : "Title"}><Input value={assign.title} onChange={(e) => setAssign({ ...assign, title: e.target.value })} /></Field><Field label={fr ? "Échéance" : "Due"}><Input type="datetime-local" value={assign.dueAt} onChange={(e) => setAssign({ ...assign, dueAt: e.target.value })} /></Field></div>76          <Field label={fr ? "Consignes (visibles par les étudiants)" : "Instructions (visible to students)"}><Textarea rows={3} value={assign.instructions} onChange={(e) => setAssign({ ...assign, instructions: e.target.value })} /></Field>77          <Field label={fr ? "Corrigé (JSON libre — JAMAIS renvoyé aux étudiants)" : "Answer key (free JSON — NEVER returned to students)"}><Textarea rows={3} value={assign.answerKey} onChange={(e) => setAssign({ ...assign, answerKey: e.target.value })} className="vp-mono text-[12px]" placeholder='{"total_attendu": 412000, "tolerance_pct": 8}' /></Field>78          <Btn small tone="primary" disabled={busy || !assign.title} onClick={() => run(() => { let key: unknown = null; if (assign.answerKey.trim()) { try { key = JSON.parse(assign.answerKey); } catch { throw new Error("Corrigé : JSON invalide"); } } return api("/assignments", { method: "POST", json: { ...assign, dueAt: assign.dueAt || null, answerKey: key } }); }, fr ? "Devoir créé." : "Assignment created.")}>{fr ? "Créer le devoir" : "Create assignment"}</Btn>79        </Block>80        <Block num="06" title={fr ? "Assistance IA — usage et classification des observations" : "AI assistance — usage and observation classification"}>81          <AiAdmin fr={fr} lang={lang} admin={admin} sources={(ov?.sources ?? []).map((s) => String(s.key))} />82        </Block>83        <Block num="07" title={fr ? "Journal d'audit" : "Audit log"}>84          <div className="src-wrap"><table className="src-table"><thead><tr><th>{fr ? "Quand" : "When"}</th><th>{fr ? "Qui" : "Who"}</th><th>Action</th><th>{fr ? "Entité" : "Entity"}</th><th>{fr ? "Détails" : "Details"}</th></tr></thead><tbody>{audit.map((e) => <tr key={String(e.id)}><td className="vp-mono text-[10.5px]">{dt(String(e.at), lang)}</td><td className="text-[12px]">{String(e.userName ?? e.userId ?? "—")} <span className="vp-mono text-[10px] text-ink-3">{String(e.role ?? "")}</span></td><td className="vp-mono text-[11px]">{String(e.action)}</td><td className="vp-mono text-[10px] text-ink-3">{String(e.entityType ?? "")} {String(e.entityId ?? "").slice(0, 8)}</td><td className="vp-mono text-[10px] text-ink-2 break-all">{String(e.details ?? "").slice(0, 160)}</td></tr>)}</tbody></table></div>85        </Block>86      </div>87    </div>88  );89}909192function AiAdmin({ fr, lang, admin, sources }: { fr: boolean; lang: string; admin: boolean; sources: string[] }) {93  const [usage, setUsage] = useState<{ today: { n: number; usd: number; input: number; output: number }; byKind: { kind: string; status: string; n: number; usd: number }[]; dailyBudgetUsd: number; model: string } | null>(null);94  const [items, setItems] = useState<{ id: string; kind: string; status: string; model: string; createdAt: string; inputSummary: string | null; output: unknown }[]>([]);95  const [src, setSrc] = useState("mtl_dtni"); const [busy, setBusy] = useState(false); const [msg, setMsg] = useState<string | null>(null);96  const load = useCallback(() => api<{ suggestions: typeof items; usage: typeof usage }>("/ai").then((r) => { setItems(r.suggestions.filter((s) => s.kind === "classify")); setUsage(r.usage); }).catch(() => undefined), []);97  useEffect(() => { void load(); }, [load]);98  const classify = async () => { setBusy(true); setMsg(null); try { await api("/ai", { method: "POST", json: { kind: "classify", sourceKey: src } }); await load(); } catch (e) { setMsg((e as Error).message); } finally { setBusy(false); } };99  const review = async (id: string, status: string) => { try { const r = await api<{ applied: number | null }>(`/ai/${id}`, { method: "POST", json: { status, apply: status === "accepted" } }); setMsg(r.applied != null ? `${r.applied} observation(s) classée(s)` : null); await load(); } catch (e) { setMsg((e as Error).message); } };100  return (101    <div className="space-y-3">102      {usage && <div className="flex flex-wrap gap-x-5 gap-y-2"><span className="stat-chip"><b>{usage.model}</b></span><span className="stat-chip"><b>{usage.today.n}</b> {fr ? "appels aujourd'hui" : "calls today"}</span><span className="stat-chip"><b>{num(usage.today.usd, lang, 4)} $ US</b> / {usage.dailyBudgetUsd} $ {fr ? "budget" : "budget"}</span>{usage.byKind.map((k) => <span key={k.kind + k.status} className="stat-chip"><b>{k.n}</b> {k.kind} · {k.status}</span>)}</div>}103      {admin && <div className="flex flex-wrap items-end gap-3"><Field label={fr ? "Classer les observations d'une source (MasterFormat)" : "Classify a source's observations (MasterFormat)"}><Select value={src} onChange={(e) => setSrc(e.target.value)}>{sources.map((k) => <option key={k} value={k}>{k}</option>)}</Select></Field><Btn small disabled={busy} onClick={() => void classify()}>{busy ? "…" : fr ? "Proposer une classification" : "Propose a classification"}</Btn></div>}104      {msg && <p className="vp-mono text-[11px] text-accent">{msg}</p>}105      <ul className="divide-y divide-[var(--line)] text-[12.5px]">{items.map((s) => { const o = s.output as { items?: { id: string; division: string; infrastructure: boolean; confidence: number }[] }; return <li key={s.id} className="flex flex-wrap items-baseline justify-between gap-2 py-2"><span><span className="vp-mono text-[10px] uppercase text-accent">{s.kind}</span> {s.inputSummary} · {o.items?.length ?? 0} {fr ? "propositions" : "proposals"} · <span className="vp-mono text-[10px] text-ink-3">{s.model} · {dt(s.createdAt, lang)}</span> <span className={`pill ${s.status === "accepted" ? "pill-conf-A" : s.status === "rejected" ? "pill-conf-D" : "pill-conf-C"}`}>{s.status}</span></span>{admin && s.status === "pending" && <span className="flex gap-1"><Btn small tone="accent" onClick={() => void review(s.id, "accepted")}>{fr ? "Accepter et appliquer" : "Accept and apply"}</Btn><Btn small onClick={() => void review(s.id, "rejected")}>{fr ? "Refuser" : "Reject"}</Btn></span>}</li>; })}</ul>106    </div>107  );108}109
Files main
Menu

Theme