Skip to content

microsoft/power-platform-skills / plugins/power-pages/skills/audit-permissions

audit-permissions

Verified

Audits existing table permissions on a Power Pages site by analyzing them against site code and Dataverse metadata, then GRADES the configuration with deterministic 1–5 scores across 3 security/usability/correctness categories (9 dimensions). Detection is anchored by a recurring-issue catalog so findings and severities stay consistent run-to-run. Generates an HTML report with an at-a-glance verdict and per-category scores in the Overview plus a single list of **major/minor** issues (each major issue labelled permissions-only or upstream-caused with a short justification), and suggested fixes. Use when the user wants to review, verify, check, score, or grade table permissions for security issues. Supports SPA and PAC-downloaded non-SPA sites.

assets/audit-report.html

View on GitHub
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8"/>
<meta name="viewport" content="width=device-width,initial-scale=1.0"/>
<title>Permissions Audit — __SITE_NAME__</title>
<style>
:root {
  --bg:#faf9f8; --surface:#ffffff; --surface2:#f3f2f1; --surface3:#edebe9;
  --border:#e1dfdd; --border-light:#c8c6c4;
  --text:#323130; --text-dim:#605e5c; --text-bright:#201f1e;
  --accent:#0078d4; --accent-bg:#0078d40a; --accent-border:#0078d425;
  --critical:#d13438; --critical-bg:#d134380a; --critical-border:#d1343825;
  --warning:#ca5010; --warning-bg:#ca50100a; --warning-border:#ca501025;
  --pass:#107c10; --pass-bg:#107c100a; --pass-border:#107c1025;
  --info:#0078d4; --info-bg:#0078d40a; --info-border:#0078d425;
  --purple:#8764b8; --purple-bg:#8764b80a; --purple-border:#8764b825;
  --mono:'Cascadia Code','Consolas',monospace;
  --sans:'Segoe UI','Segoe UI Web (West European)',-apple-system,system-ui,sans-serif;
  --radius:8px; --radius-sm:4px;
  --shadow-4:0 1.6px 3.6px 0 rgba(0,0,0,0.132),0 0.3px 0.9px 0 rgba(0,0,0,0.108);
  --shadow-8:0 3.2px 7.2px 0 rgba(0,0,0,0.132),0 0.6px 1.8px 0 rgba(0,0,0,0.108);
}
*{margin:0;padding:0;box-sizing:border-box;}
html{scroll-behavior:smooth;}
body{font-family:var(--sans);background:var(--bg);color:var(--text);font-size:14px;line-height:1.6;}


/* Top Bar */
.topbar{z-index:100;background:var(--surface);box-shadow:var(--shadow-4);padding:14px 28px;display:flex;justify-content:space-between;align-items:center;flex-wrap:wrap;gap:10px;}
.topbar-left{display:flex;align-items:center;gap:14px;}
.logo{width:36px;height:36px;object-fit:contain;display:block;flex-shrink:0;}
.topbar-title{font-size:16px;font-weight:700;color:var(--text-bright);}
.topbar-sub{font-size:11px;color:var(--text-dim);margin-top:1px;}

/* Layout */
.layout{display:flex;min-height:calc(100vh - 61px);}

/* Sidebar */
.sidebar{width:200px;background:var(--surface);border-right:1px solid var(--border);padding:20px 0;flex-shrink:0;}
.nav-btn{display:flex;align-items:center;gap:10px;width:100%;padding:11px 22px;background:none;border:none;border-left:2px solid transparent;color:var(--text-dim);font-size:13px;font-weight:500;cursor:pointer;font-family:var(--sans);text-align:left;transition:all 0.15s;position:relative;}
.nav-btn:hover{color:var(--text);background:var(--surface2);}
.nav-btn.active{color:var(--accent);font-weight:600;border-left-color:var(--accent);background:var(--accent-bg);}
.nav-btn .nav-icon{font-size:15px;opacity:0.5;width:18px;text-align:center;}
.nav-btn.active .nav-icon{opacity:0.9;}
.nav-badge{position:absolute;right:14px;font-size:10px;font-family:var(--mono);padding:1px 6px;border-radius:8px;font-weight:700;}

/* Content */
.content{flex:1;padding:32px 40px;max-width:960px;}
.section{display:none;}
.section.active{display:block;animation:fadeIn 0.3s ease;}
@keyframes fadeIn{from{opacity:0;transform:translateY(8px);}to{opacity:1;transform:translateY(0);}}

h2{font-size:21px;font-weight:800;color:var(--text-bright);letter-spacing:-0.3px;margin-bottom:5px;}
.section-desc{font-size:13px;color:var(--text-dim);margin-bottom:20px;}
h3{font-size:15px;font-weight:700;color:var(--text-bright);margin-top:24px;margin-bottom:12px;}

/* Cards */
.card{background:var(--surface);border:1px solid var(--border);border-radius:var(--radius);padding:18px 20px;margin-bottom:10px;transition:box-shadow 0.2s;}
.card:hover{box-shadow:var(--shadow-4);}

/* Stats Grid */
.stats-grid{display:grid;grid-template-columns:repeat(4,1fr);gap:10px;margin-bottom:24px;}
.stat-card{background:var(--surface);border:1px solid var(--border);border-radius:var(--radius);padding:18px 16px;text-align:center;position:relative;overflow:hidden;box-shadow:var(--shadow-4);}
.stat-card::after{content:'';position:absolute;top:0;left:50%;transform:translateX(-50%);width:40px;height:2px;border-radius:0 0 2px 2px;}
.stat-num{font-size:28px;font-weight:800;font-family:var(--mono);line-height:1;}
.stat-label{font-size:10px;color:var(--text-dim);text-transform:uppercase;letter-spacing:1px;margin-top:6px;}

/* Severity badges */
.severity{font-size:9px;font-weight:700;padding:3px 8px;border-radius:3px;font-family:var(--mono);display:inline-block;text-transform:uppercase;letter-spacing:0.5px;}
.sev-legend{font-size:11px;color:var(--text-dim);line-height:1.75;margin-top:10px;}
.sev-legend b{font-weight:700;}
.severity-critical{color:var(--critical);background:var(--critical-bg);border:1px solid var(--critical-border);}
.severity-warning{color:var(--warning);background:var(--warning-bg);border:1px solid var(--warning-border);}
.severity-info{color:var(--info);background:var(--info-bg);border:1px solid var(--info-border);}
.severity-pass{color:var(--pass);background:var(--pass-bg);border:1px solid var(--pass-border);}
.severity-major{color:var(--critical);background:var(--critical-bg);border:1px solid var(--critical-border);}
.severity-minor{color:var(--warning);background:var(--warning-bg);border:1px solid var(--warning-border);}

/* Root-cause badges */
.rc{font-size:10px;font-weight:600;padding:2px 8px;border-radius:10px;display:inline-block;white-space:nowrap;}
.rc-permissions{color:var(--accent);background:var(--accent-bg);border:1px solid var(--accent-border);}
.rc-mixed{color:var(--purple);background:var(--purple-bg);border:1px solid var(--purple-border);}
.rc-upstream{color:var(--info);background:var(--info-bg);border:1px solid var(--info-border);}
.rootcause-block{background:var(--surface2);border-left:2px solid var(--purple);border-radius:var(--radius-sm);padding:10px 14px;margin-top:10px;font-size:12px;color:var(--text);line-height:1.7;}

/* Finding cards */
.finding-card{background:var(--surface);border:1px solid var(--border);border-radius:var(--radius);margin-bottom:12px;transition:box-shadow 0.2s;overflow:hidden;}
.finding-card:hover{box-shadow:var(--shadow-4);}
.finding-header{display:flex;align-items:flex-start;gap:12px;padding:16px 20px;cursor:pointer;-webkit-user-select:none;user-select:none;}
.finding-header:hover{background:var(--surface2);}
.finding-title{font-size:14px;font-weight:600;color:var(--text-bright);flex:1;}
.finding-table{font-size:11px;color:var(--accent);background:var(--accent-bg);padding:1px 6px;border-radius:3px;border:1px solid var(--accent-border);font-family:var(--mono);}
.finding-chevron{color:var(--text-dim);font-size:12px;transition:transform 0.2s;flex-shrink:0;margin-top:3px;}
.finding-card.expanded .finding-chevron{transform:rotate(90deg);}
.finding-body{display:none;padding:0 20px 16px;border-top:1px solid var(--border);}
.finding-card.expanded .finding-body{display:block;animation:fadeIn 0.2s ease;}

/* Field label */
.field-label{font-size:11px;font-weight:600;color:var(--text-dim);text-transform:uppercase;letter-spacing:0.5px;margin-bottom:4px;}

/* Reasoning & fix blocks */
.reasoning-block{background:var(--surface2);border-left:2px solid var(--accent);border-radius:var(--radius-sm);padding:10px 14px;margin-top:10px;font-size:12px;color:var(--text);line-height:1.7;}
.fix-block{background:var(--pass-bg);border-left:2px solid var(--pass);border-radius:var(--radius-sm);padding:10px 14px;margin-top:8px;font-size:12px;color:var(--text);line-height:1.7;}
.fix-block strong{color:var(--pass);}

/* Scope Tags */
.scope-tag{font-size:10px;font-weight:700;padding:2px 8px;border-radius:3px;font-family:var(--mono);display:inline-block;text-align:center;min-width:58px;}
.scope-Global{color:var(--critical);background:var(--critical-bg);border:1px solid var(--critical-border);}
.scope-Contact{color:var(--pass);background:var(--pass-bg);border:1px solid var(--pass-border);}
.scope-Account{color:var(--accent);background:var(--accent-bg);border:1px solid var(--accent-border);}
.scope-Parent{color:var(--purple);background:var(--purple-bg);border:1px solid var(--purple-border);}
.scope-Self{color:var(--text-dim);background:var(--surface2);border:1px solid var(--border);}

/* Privilege Chips */
.priv{font-size:9px;font-weight:700;padding:2px 5px;border-radius:3px;font-family:var(--mono);}
.priv-on{color:var(--pass);background:var(--pass-bg);}
.priv-off{color:var(--text-dim);background:var(--surface2);opacity:0.5;}

/* Inventory table */
.inv-table{width:100%;border-collapse:collapse;font-size:13px;margin:10px 0;}
.inv-table th{text-align:left;font-size:10px;font-weight:700;text-transform:uppercase;letter-spacing:0.8px;color:var(--text-dim);padding:10px 12px;border-bottom:2px solid var(--border);}
.inv-table td{padding:10px 12px;border-bottom:1px solid var(--border);vertical-align:top;}
.inv-table tr:last-child td{border-bottom:none;}
.inv-table tr:hover td{background:var(--surface2);}

/* Filter buttons */
.filter-bar{display:flex;gap:6px;margin-bottom:16px;flex-wrap:wrap;}
.filter-btn{padding:5px 12px;border:1px solid var(--border);border-radius:var(--radius-sm);background:var(--surface);color:var(--text-dim);font-size:12px;font-weight:600;cursor:pointer;font-family:var(--sans);transition:all 0.15s;}
.filter-btn:hover{border-color:var(--border-light);color:var(--text);}
.filter-btn.active{background:var(--accent-bg);border-color:var(--accent-border);color:var(--accent);}
.filter-count{font-family:var(--mono);font-size:10px;margin-left:4px;opacity:0.7;}

/* Responsive */
@media(max-width:768px){
  .sidebar{display:none;}
  .content{padding:20px 16px;}
  .stats-grid{grid-template-columns:repeat(2,1fr);}
}
</style>
</head>
<body>

<div id="mainApp">
  <div class="topbar">
    <div class="topbar-left">
      <img class="logo" src="./power-pages-icon.png" alt="Power Pages" />
      <div>
        <div class="topbar-title">Permissions Audit Report</div>
        <div class="topbar-sub">__SITE_NAME__</div>
      </div>
    </div>
  </div>

  <div class="layout">
    <div class="sidebar">
      <button class="nav-btn active" data-tab="overview"><span class="nav-icon">&#9673;</span> Overview</button>
      <button class="nav-btn" data-tab="findings"><span class="nav-icon">&#9888;</span> Issues
        <span class="nav-badge" id="navFindingsCount" style="background:var(--critical-bg);color:var(--critical);"></span>
      </button>
      <button class="nav-btn" data-tab="inventory"><span class="nav-icon">&#9638;</span> Inventory</button>
    </div>

    <div class="content">

      <!-- OVERVIEW -->
      <div class="section active" id="tab-overview">
        <h2>Audit Overview</h2>
        <p class="section-desc">__AUDIT_DESC__</p>

        <h3>Audit Summary</h3>
        <div class="card" id="summaryBox" style="line-height:1.75;">__SUMMARY__</div>

        <h3 style="margin-top:18px;">Issues</h3>
        <div class="stats-grid">
          <div class="stat-card" style="--accent-color:var(--critical)"><div class="stat-num" style="color:var(--critical)" id="statMajor">0</div><div class="stat-label">Major</div></div>
          <div class="stat-card"><div class="stat-num" style="color:var(--warning)" id="statMinor">0</div><div class="stat-label">Minor</div></div>
        </div>
        <div class="sev-legend">
          <div><b style="color:var(--critical)">Major</b> &mdash; breaks a flow or exposes data to the wrong audience.</div>
          <div><b style="color:var(--warning)">Minor</b> &mdash; cosmetic, forward-looking, or nice-to-have.</div>
        </div>


        <div id="ovScoreWrap" style="display:none;">
          <h3>Verdict</h3>
          <div style="margin:4px 0 2px;">
            <span id="ovVerdict" style="font-size:30px;font-weight:800;line-height:1.2;">&mdash;</span>
          </div>
          <div id="ovVerdictNote" style="font-size:11px;color:var(--text-dim);margin-bottom:4px;">&nbsp;</div>
          <h3 style="margin-top:18px;">Category Scores</h3>
          <div class="card" id="ovCategoryBox" style="line-height:1.7;"></div>
        </div>

        <div id="ovPartialWrap" style="display:none;">
          <h3>Verdict</h3>
          <div class="card" style="line-height:1.7;"><strong>Partial audit:</strong> the data model was not available, so no verdict or scores were produced. The issues listed were found from the permissions, web roles, site code, and site settings.</div>
        </div>

        <div id="ovReportWrap" style="display:none;">
          <h3>Full evaluation reports</h3>
          <div class="card" id="ovReportBox" style="line-height:1.9;"></div>
        </div>

      </div>

      <!-- FINDINGS -->
      <div class="section" id="tab-findings">
        <h2>Issues</h2>
        <p class="section-desc" id="findingsDesc"></p>
        <div class="sev-legend" style="margin-bottom:14px;">
          <div><b style="color:var(--critical)">Major</b> &mdash; breaks a flow or exposes data to the wrong audience.</div>
          <div><b style="color:var(--warning)">Minor</b> &mdash; cosmetic, forward-looking, or nice-to-have.</div>
        </div>
        <div style="display:flex;justify-content:space-between;align-items:center;flex-wrap:wrap;gap:8px;">
          <div class="filter-bar" id="filterBar" style="margin-bottom:0;"></div>
          <button class="filter-btn" id="expandAllBtn" style="white-space:nowrap;">Expand All</button>
        </div>
        <div id="findingsContainer" style="margin-top:16px;"></div>
      </div>

      <!-- INVENTORY -->
      <div class="section" id="tab-inventory">
        <h2>Permissions Inventory</h2>
        <p class="section-desc" id="invDesc"></p>

        <h3>Legend</h3>
        <div class="card" style="margin-bottom:16px;">
          <div style="display:flex;gap:32px;flex-wrap:wrap;">
            <div>
              <div class="field-label" style="margin-bottom:6px;">Scope</div>
              <div style="display:flex;gap:6px;flex-wrap:wrap;">
                <span class="scope-tag scope-Global">Global</span>
                <span class="scope-tag scope-Contact">Contact</span>
                <span class="scope-tag scope-Account">Account</span>
                <span class="scope-tag scope-Parent">Parent</span>
                <span class="scope-tag scope-Self">Self</span>
              </div>
              <div style="font-size:11px;color:var(--text-dim);margin-top:6px;line-height:1.6;">
                <strong>Global</strong> — all records &nbsp;|&nbsp;
                <strong>Contact</strong> — user's contact &nbsp;|&nbsp;
                <strong>Account</strong> — user's account &nbsp;|&nbsp;
                <strong>Parent</strong> — via parent table &nbsp;|&nbsp;
                <strong>Self</strong> — own record only
              </div>
            </div>
            <div>
              <div class="field-label" style="margin-bottom:6px;">Privileges</div>
              <div style="display:flex;flex-direction:column;gap:4px;font-size:12px;">
                <div style="display:flex;align-items:center;gap:6px;"><span class="priv priv-on">R</span><strong style="color:var(--text-bright);">Read</strong><span style="color:var(--text-dim);">— Retrieve and view records</span></div>
                <div style="display:flex;align-items:center;gap:6px;"><span class="priv priv-on">C</span><strong style="color:var(--text-bright);">Create</strong><span style="color:var(--text-dim);">— Add new records</span></div>
                <div style="display:flex;align-items:center;gap:6px;"><span class="priv priv-on">W</span><strong style="color:var(--text-bright);">Write</strong><span style="color:var(--text-dim);">— Update existing records (includes file uploads via PATCH)</span></div>
                <div style="display:flex;align-items:center;gap:6px;"><span class="priv priv-on">D</span><strong style="color:var(--text-bright);">Delete</strong><span style="color:var(--text-dim);">— Remove records</span></div>
                <div style="display:flex;align-items:center;gap:6px;"><span class="priv priv-on">A</span><strong style="color:var(--text-bright);">Append</strong><span style="color:var(--text-dim);">— Attach this record to another via a lookup</span></div>
                <div style="display:flex;align-items:center;gap:6px;"><span class="priv priv-on">AT</span><strong style="color:var(--text-bright);">AppendTo</strong><span style="color:var(--text-dim);">— Allow other records to reference this one via a lookup</span></div>
              </div>
              <div style="font-size:11px;color:var(--text-dim);margin-top:8px;">
                <span class="priv priv-on" style="font-size:8px;">R</span> enabled &nbsp;
                <span class="priv priv-off" style="font-size:8px;">R</span> disabled
              </div>
            </div>
          </div>
        </div>

        <div id="invContainer"></div>
      </div>

    </div>
  </div>
</div>

<script>
// Data populated by the audit-permissions skill
const FINDINGS = __JSON_FINDINGS_DATA__;
// Each finding: { id, severity (major|minor), title, table, scope, permission, reasoning, fix, details, rootCause, rootCauseReason }

const INVENTORY = __JSON_INVENTORY_DATA__;
// Each item: { name, table, scope, roles, read, create, write, delete, append, appendto }

const SCORECARD = __JSON_SCORECARD_DATA__;
// null when scoring was skipped, else { categories:[{name,score}], reportPaths:[{label,path}] }

// Tab navigation
document.querySelectorAll('.nav-btn').forEach(btn => {
  btn.addEventListener('click', () => {
    document.querySelectorAll('.nav-btn').forEach(b => b.classList.remove('active'));
    btn.classList.add('active');
    document.querySelectorAll('.section').forEach(s => s.classList.remove('active'));
    document.getElementById('tab-' + btn.dataset.tab).classList.add('active');
  });
});

// Severity config
function esc(s) { if (!s) return ''; return String(s).replace(/&/g,'&amp;').replace(/</g,'&lt;').replace(/>/g,'&gt;').replace(/"/g,'&quot;').replace(/'/g,'&#39;'); }
function escAttr(s) { return String(s || '').replace(/[^a-zA-Z0-9_.-]/g, ''); }
const sevConfig = {
  major: { color: 'var(--critical)', label: 'MAJOR' },
  minor: { color: 'var(--warning)',  label: 'MINOR' }
};

const scopeNames = { 756150000:'Global', 756150001:'Contact', 756150002:'Account', 756150003:'Parent', 756150004:'Self' };
function scopeName(s) { return scopeNames[s] || s; }

// Root cause (Step 6) of each major finding.
const rootCauseConfig = {
  'permissions':     { label: 'Permissions only',            cls: 'rc-permissions' },
  'mixed':           { label: 'Permissions + upstream',      cls: 'rc-mixed' },
  'data-model':      { label: 'Upstream: data model',        cls: 'rc-upstream' },
  'webapi-code':     { label: 'Upstream: site code',         cls: 'rc-upstream' },
  'webapi-settings': { label: 'Upstream: Web API settings',  cls: 'rc-upstream' }
};
function rootCauseOf(f) {
  const cfg = rootCauseConfig[f.rootCause];
  return cfg ? { cfg: cfg, reason: f.rootCauseReason || '' } : null;
}

// Stats
const majorCount = FINDINGS.filter(f => f.severity === 'major').length;
const minorCount = FINDINGS.filter(f => f.severity === 'minor').length;
const issueCount = majorCount + minorCount;

document.getElementById('statMajor').textContent = majorCount;
document.getElementById('statMinor').textContent = minorCount;
document.getElementById('navFindingsCount').textContent = issueCount > 0 ? issueCount : '';

document.getElementById('findingsDesc').textContent =
  FINDINGS.length + ' issue' + (FINDINGS.length !== 1 ? 's' : '') +
  ' \u2014 ' + majorCount + ' major, ' + minorCount + ' minor.' +
  (function () {
    const labelled = FINDINGS.filter(f => f.severity === 'major').map(rootCauseOf).filter(Boolean);
    if (!labelled.length) return '';
    const permOnly = labelled.filter(r => r.cfg === rootCauseConfig.permissions).length;
    return ' Of the major issues, ' + permOnly + ' are permissions only and ' + (labelled.length - permOnly) + ' involve upstream artifacts.';
  })();

document.getElementById('invDesc').textContent =
  INVENTORY.length + ' table permission' + (INVENTORY.length !== 1 ? 's' : '') + ' currently configured.';

// Filter bar
let activeFilter = 'all';
function renderFilterBar() {
  const c = document.getElementById('filterBar');
  const counts = { all: FINDINGS.length, major: majorCount, minor: minorCount };
  const labels = { all: 'All', major: 'Major', minor: 'Minor' };
  let html = '';
  Object.entries(labels).forEach(([key, label]) => {
    if (counts[key] === 0 && key !== 'all') return;
    html += '<button class="filter-btn ' + (activeFilter === key ? 'active' : '') + '" data-filter="' + escAttr(key) + '">' + esc(label) + '<span class="filter-count">' + counts[key] + '</span></button>';
  });
  c.innerHTML = html;
}
function setFilter(f) {
  activeFilter = f;
  renderFilterBar();
  renderFindings();
}

// Render findings
function renderFindings() {
  const c = document.getElementById('findingsContainer');
  const filtered = activeFilter === 'all' ? FINDINGS : FINDINGS.filter(f => f.severity === activeFilter);

  const order = { major: 0, minor: 1 };
  const sorted = [...filtered].sort((a, b) => (order[a.severity] ?? 99) - (order[b.severity] ?? 99));

  let html = '';
  sorted.forEach(f => {
    const sev = sevConfig[f.severity] || sevConfig.minor;
    const fid = escAttr(f.id);
    const fsev = escAttr(f.severity);
    const rc = rootCauseOf(f);
    html += '<div class="finding-card" id="finding-' + fid + '">' +
      '<div class="finding-header">' +
        '<span class="severity severity-' + fsev + '">' + esc(sev.label) + '</span>' +
        '<span class="finding-title">' + esc(f.title) + '</span>' +
        (rc ? '<span class="rc ' + rc.cfg.cls + '">' + esc(rc.cfg.label) + '</span>' : '') +
        (f.table ? '<span class="finding-table">' + esc(f.table) + '</span>' : '') +
        '<span class="finding-chevron">&#9654;</span>' +
      '</div>' +
      '<div class="finding-body">' +
        (rc ? '<div style="margin-top:10px;"><div class="field-label">Root cause</div><div class="rootcause-block"><span class="rc ' + rc.cfg.cls + '">' + esc(rc.cfg.label) + '</span>' + (rc.reason ? ' ' + esc(rc.reason) : '') + '</div></div>' : '') +
        (f.permission ? '<div style="margin-top:10px;font-size:12px;"><span class="field-label">Permission:</span> <span style="font-weight:600;color:var(--text-bright)">' + esc(f.permission) + '</span></div>' : '') +
        (f.scope ? '<div style="margin-top:6px;font-size:12px;"><span class="field-label">Scope:</span> <span class="scope-tag scope-' + escAttr(scopeName(f.scope)) + '" style="font-size:10px;padding:1px 6px;min-width:auto;">' + esc(scopeName(f.scope)) + '</span></div>' : '') +
        (f.details ? '<div style="margin-top:10px;font-size:12px;color:var(--text);line-height:1.7;">' + esc(f.details) + '</div>' : '') +
        (f.reasoning ? '<div style="margin-top:10px;"><div class="field-label">Reasoning</div><div class="reasoning-block">' + esc(f.reasoning) + '</div></div>' : '') +
        (f.fix ? '<div style="margin-top:8px;"><div class="field-label">Suggested Fix</div><div class="fix-block"><strong>Fix:</strong> ' + esc(f.fix) + '</div></div>' : '') +
      '</div>' +
    '</div>';
  });

  if (sorted.length === 0) {
    html = '<div style="text-align:center;padding:40px;color:var(--text-dim);font-size:14px;">No issues for this filter.</div>';
  }
  c.innerHTML = html;
}

// Expand/Collapse All
let allExpanded = false;
function toggleExpandAll() {
  allExpanded = !allExpanded;
  document.querySelectorAll('.finding-card').forEach(c => {
    if (allExpanded) c.classList.add('expanded');
    else c.classList.remove('expanded');
  });
  document.getElementById('expandAllBtn').textContent = allExpanded ? 'Collapse All' : 'Expand All';
}

// Render inventory
function renderInventory() {
  const c = document.getElementById('invContainer');
  if (INVENTORY.length === 0) {
    c.innerHTML = '<div style="text-align:center;padding:40px;color:var(--text-dim);font-size:14px;">No table permissions configured.</div>';
    return;
  }
  const privs = ['Read','Create','Write','Delete','Append','AppendTo'];
  let html = '<table class="inv-table"><thead><tr><th>Permission Name</th><th>Table</th><th>Scope</th><th>Roles</th><th>Privileges</th></tr></thead><tbody>';
  INVENTORY.forEach(p => {
    const flags = { Read: p.read, Create: p.create, Write: p.write, Delete: p.delete, Append: p.append, AppendTo: p.appendto };
    html += '<tr>' +
      '<td style="font-weight:600;color:var(--text-bright)">' + esc(p.name) + '</td>' +
      '<td><code style="font-size:11px;color:var(--accent);background:var(--accent-bg);padding:1px 5px;border-radius:3px;border:1px solid var(--accent-border);">' + esc(p.table) + '</code></td>' +
      '<td><span class="scope-tag scope-' + escAttr(scopeName(p.scope)) + '" style="font-size:9px;padding:1px 6px;min-width:auto;">' + esc(scopeName(p.scope)) + '</span></td>' +
      '<td style="font-size:12px;">' + (Array.isArray(p.roles) ? esc(p.roles.join(', ')) : esc(p.roles)) + '</td>' +
      '<td style="display:flex;gap:3px;flex-wrap:wrap;">' + privs.map(function(pr) { return '<span class="priv ' + (flags[pr] ? 'priv-on' : 'priv-off') + '">' + pr[0] + (pr === 'AppendTo' ? 'T' : '') + '</span>'; }).join('') + '</td>' +
    '</tr>';
  });
  html += '</tbody></table>';
  c.innerHTML = html;
}

// Render grader score into the Overview tab (no separate scorecard tab)
function renderOverviewScore() {
  if (!SCORECARD) {
    var partial = document.getElementById('ovPartialWrap');
    if (partial) partial.style.display = '';
    return;
  }
  var S = SCORECARD;

  var ovWrap = document.getElementById('ovScoreWrap');
  if (ovWrap) ovWrap.style.display = '';
  var set = function(id, val){ var el = document.getElementById(id); if (el) el.textContent = val; };
  // Reuses the Major tally from FINDINGS so the verdict can never contradict the Issues row.
  var safe = majorCount === 0;
  var vEl = document.getElementById('ovVerdict');
  if (vEl) {
    vEl.textContent = safe ? 'Safe to go' : 'Needs revision';
    vEl.style.color = safe ? 'var(--pass)' : 'var(--critical)';
  }
  set('ovVerdictNote', safe
    ? 'No major issues identified.'
    : majorCount + ' major issue' + (majorCount === 1 ? '' : 's') + ' identified.');

  var catHtml = (S.categories || []).map(function(c){
    var pct = Math.max(0, Math.min(100, ((c.score||0)/5)*100));
    return '<div style="margin-bottom:12px;">' +
      '<div style="display:flex;justify-content:space-between;font-size:13px;margin-bottom:4px;">' +
        '<span style="color:var(--text-bright);font-weight:600;">' + esc(c.name) + '</span>' +
        '<span style="font-family:var(--mono);color:var(--accent);">' + (typeof c.score==='number'?c.score.toFixed(2):esc(c.score)) + ' / 5.00</span>' +
      '</div>' +
      '<div style="height:8px;background:var(--accent-bg);border-radius:4px;overflow:hidden;"><div style="height:100%;width:' + pct + '%;background:var(--accent);"></div></div>' +
    '</div>';
  }).join('') || '<div style="color:var(--text-dim);">No category data.</div>';
  var cbox = document.getElementById('ovCategoryBox'); if (cbox) cbox.innerHTML = catHtml;

  // Full evaluation report paths
  var paths = (Array.isArray(S.reportPaths) ? S.reportPaths : []).filter(function(p){
    return p && typeof p.path === 'string' && p.path;
  });
  var rWrap = document.getElementById('ovReportWrap');
  var rBox = document.getElementById('ovReportBox');
  if (paths.length && rBox) {
    if (rWrap) rWrap.style.display = '';
    rBox.innerHTML = paths.map(function(p){
      return '<div><span style="color:var(--text-dim);font-size:12px;">' + esc(p.label || 'Report') + ':</span> ' +
        '<code style="font-size:12px;color:var(--accent);background:var(--accent-bg);padding:1px 6px;border-radius:3px;border:1px solid var(--accent-border);word-break:break-all;">' + esc(p.path || '') + '</code></div>';
    }).join('');
  }
}

document.getElementById('expandAllBtn').addEventListener('click', toggleExpandAll);

// Event delegation — no inline onclick handlers
document.addEventListener('click', function(e) {
  var btn = e.target.closest('.filter-btn[data-filter]');
  if (btn) { setFilter(btn.dataset.filter); return; }
  var hdr = e.target.closest('.finding-header');
  if (hdr) { hdr.closest('.finding-card').classList.toggle('expanded'); }
});

// Init
renderFilterBar();
renderFindings();
renderInventory();
renderOverviewScore();
</script>
<footer style="position:fixed;bottom:0;left:0;right:0;text-align:center;padding:10px;font-size:12px;color:#605e5c;border-top:1px solid #c8c6c4;background:#ffffff;z-index:100;">AI-generated content may be incorrect</footer>
</body>
</html>
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall