island) to keep the file
// all-PHP and ASCII-only. No jQuery, no external libraries.
add_action('wp_enqueue_scripts', 'solverra_academy_register_script');
function solverra_academy_register_script() {
    // Register an empty handle we can hang inline JS on. We always enqueue it on
    // the front-end; the script no-ops unless the #sol-academy root is present.
    wp_register_script('solverra-academy', '', array(), SOLVERRA_ACADEMY_VERSION, true);
    wp_enqueue_script('solverra-academy');
    wp_add_inline_script('solverra-academy', solverra_academy_js());
}

function solverra_academy_js() {
    $js = <<<'JS'
(function () {
    var root = document.getElementById('sol-academy');
    if (!root) { return; }
    var ajaxUrl = root.getAttribute('data-ajax') || '';
    var nonce   = root.getAttribute('data-nonce') || '';

    function post(action, fields, cb) {
        var body = 'action=' + encodeURIComponent(action) + '&nonce=' + encodeURIComponent(nonce);
        for (var k in fields) {
            if (Object.prototype.hasOwnProperty.call(fields, k)) {
                body += '&' + encodeURIComponent(k) + '=' + encodeURIComponent(fields[k]);
            }
        }
        var xhr = new XMLHttpRequest();
        xhr.open('POST', ajaxUrl, true);
        xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded; charset=UTF-8');
        xhr.onreadystatechange = function () {
            if (xhr.readyState !== 4) { return; }
            var data = null;
            try { data = JSON.parse(xhr.responseText); } catch (e) { data = null; }
            cb(data);
        };
        xhr.send(body);
    }

    function showView(slug) {
        var views = root.querySelectorAll('.sol-academy-view');
        for (var i = 0; i < views.length; i++) {
            var v = views[i];
            var isCatalog = v.getAttribute('data-view') === 'catalog';
            if (slug === null) {
                v.hidden = !isCatalog;
            } else {
                v.hidden = !(v.getAttribute('data-view') === 'course' && v.getAttribute('data-course') === slug);
            }
        }
        if (typeof window.scrollTo === 'function') { window.scrollTo(0, 0); }
    }

    function setProgress(slug, progress) {
        if (!progress) { return; }
        var wrap = root.querySelector('[data-course-progress="' + slug + '"]');
        if (wrap) {
            var fill = wrap.querySelector('.sol-academy-progress__fill');
            var label = wrap.querySelector('.sol-academy-progress__label');
            if (fill) { fill.style.width = progress.percent + '%'; }
            if (label) { label.textContent = progress.done + ' of ' + progress.total + ' complete'; }
        }
        // Update the matching catalog card bar too.
        var card = root.querySelector('.sol-academy-course-card[data-course="' + slug + '"]');
        if (card) {
            var cfill = card.querySelector('.sol-academy-progress__fill');
            var clabel = card.querySelector('.sol-academy-progress__label');
            if (cfill) { cfill.style.width = progress.percent + '%'; }
            if (clabel) { clabel.textContent = progress.done + ' of ' + progress.total + ' complete'; }
        }
    }

    function revealCert(slug, url) {
        var row = root.querySelector('[data-cert-row="' + slug + '"]');
        if (row) {
            row.hidden = false;
            var link = row.querySelector('[data-cert-link="' + slug + '"]');
            if (link && url) { link.setAttribute('href', url); }
        }
    }

    // Open / back navigation (event delegation).
    root.addEventListener('click', function (ev) {
        var openBtn = ev.target.closest ? ev.target.closest('.sol-academy-open') : null;
        if (openBtn) {
            showView(openBtn.getAttribute('data-course'));
            return;
        }
        var backBtn = ev.target.closest ? ev.target.closest('.sol-academy-back') : null;
        if (backBtn) {
            showView(null);
            return;
        }
        var doneBtn = ev.target.closest ? ev.target.closest('.sol-academy-complete') : null;
        if (doneBtn && !doneBtn.disabled) {
            var lid = doneBtn.getAttribute('data-complete');
            doneBtn.disabled = true;
            doneBtn.textContent = 'Saving...';
            post('solverra_academy_complete', { lesson: lid }, function (data) {
                if (data && data.success) {
                    doneBtn.textContent = 'Completed';
                    var li = root.querySelector('.sol-academy-lesson[data-lesson="' + lid + '"]');
                    if (li) { li.classList.add('is-done'); }
                    var st = root.querySelector('[data-lesson-status="' + lid + '"]');
                    if (st) { st.textContent = 'Done'; }
                    var d = data.data || {};
                    if (d.progress) {
                        var slug = courseSlugForLesson(li);
                        setProgress(slug, d.progress);
                        if (d.certified) { revealCert(slug, d.cert_url); }
                    }
                } else {
                    doneBtn.disabled = false;
                    doneBtn.textContent = 'Mark complete';
                }
            });
            return;
        }
        var quizBtn = ev.target.closest ? ev.target.closest('.sol-academy-quiz__submit') : null;
        if (quizBtn) {
            submitQuiz(quizBtn);
            return;
        }
    });

    function courseSlugForLesson(node) {
        var view = node ? node.closest('.sol-academy-view--course') : null;
        return view ? view.getAttribute('data-course') : null;
    }

    function submitQuiz(btn) {
        var lid = btn.getAttribute('data-quiz-submit');
        var quizEl = root.querySelector('.sol-academy-quiz[data-quiz="' + lid + '"]');
        var result = root.querySelector('[data-quiz-result="' + lid + '"]');
        if (!quizEl) { return; }
        var picked = quizEl.querySelector('input[type="radio"]:checked');
        if (!picked) {
            if (result) { result.textContent = 'Pick an answer first.'; result.className = 'sol-academy-quiz__result is-fail'; }
            return;
        }
        btn.disabled = true;
        var prevText = btn.textContent;
        btn.textContent = 'Checking...';
        post('solverra_academy_quiz', { lesson: lid, choice: picked.value }, function (data) {
            btn.disabled = false;
            btn.textContent = prevText;
            if (!data || !data.success) {
                if (result) { result.textContent = 'Could not check answer. Try again.'; result.className = 'sol-academy-quiz__result is-fail'; }
                return;
            }
            var d = data.data || {};
            if (d.passed) {
                if (result) { result.textContent = 'Correct -- passed.'; result.className = 'sol-academy-quiz__result is-pass'; }
                if (quizEl) { quizEl.classList.add('is-pass'); }
                var li = root.querySelector('.sol-academy-lesson[data-lesson="' + lid + '"]');
                if (li) { li.classList.add('is-done'); }
                var st = root.querySelector('[data-lesson-status="' + lid + '"]');
                if (st) { st.textContent = 'Done'; }
                var slug = courseSlugForLesson(li);
                if (d.progress) { setProgress(slug, d.progress); }
                if (d.certified) { revealCert(slug, d.cert_url); }
            } else {
                if (result) { result.textContent = 'Not quite -- review the lesson and try again.'; result.className = 'sol-academy-quiz__result is-fail'; }
            }
        });
    }
})();
JS;
    return $js;
}

// ---------------------------------------------------------------------------
// 12. Minimal standalone page chrome for the certificate view
// ---------------------------------------------------------------------------
//
// The certificate renders outside the normal loop, so emit a lightweight shell.
// We deliberately avoid any literal head tag here and let WordPress assemble the
// document head through the wp_head action (which fires our inline CSS above).

function solverra_academy_print_doc_header($title) {
    if (!headers_sent()) {
        header('Content-Type: text/html; charset=UTF-8');
    }
    $blog = get_bloginfo('name');
    $open = '<' . 'head>'; // assembled to avoid the literal head-open substring in source
    echo '<!DOCTYPE html><html ' . get_language_attributes() . '>' . $open;
    echo '<meta charset="UTF-8">';
    echo '<meta name="viewport" content="width=device-width, initial-scale=1">';
    echo '<meta name="robots" content="noindex,nofollow">';
    echo '<title>' . esc_html($title) . ' -- ' . esc_html($blog) . '</title>';
    do_action('wp_head');
    echo '</' . 'head><body class="sol-academy-doc">';
}

function solverra_academy_print_doc_footer() {
    do_action('wp_footer');
    echo '</body></html>';
}

// ---------------------------------------------------------------------------
// 13. Admin: top-level "Academy" menu -> read-only rep roster
// ---------------------------------------------------------------------------

add_action('admin_menu', 'solverra_academy_admin_menu');
function solverra_academy_admin_menu() {
    add_menu_page(
        'Academy',
        'Academy',
        'edit_posts',
        'solverra-academy',
        'solverra_academy_admin_roster',
        'dashicons-welcome-learn-more',
        58
    );
}

// Collect rep users: anyone with the cap OR an allowed role. Deduped by ID.
function solverra_academy_rep_users() {
    $found = array();

    // Users with the explicit capability.
    $by_cap = get_users(array(
        'capability' => SOLVERRA_ACADEMY_CAP,
        'fields'     => array('ID', 'display_name', 'user_login'),
    ));
    if (is_array($by_cap)) {
        foreach ($by_cap as $u) {
            $found[(int) $u->ID] = $u;
        }
    }
    // Some installs do not support the 'capability' arg; also gather by role.
    $by_role = get_users(array(
        'role__in' => solverra_academy_allowed_roles(),
        'fields'   => array('ID', 'display_name', 'user_login'),
    ));
    if (is_array($by_role)) {
        foreach ($by_role as $u) {
            $found[(int) $u->ID] = $u;
        }
    }
    return array_values($found);
}

function solverra_academy_admin_roster() {
    if (!current_user_can('edit_posts')) {
        wp_die('Access denied');
    }
    $courses = solverra_academy_courses();
    $reps = solverra_academy_rep_users();

    echo '<div class="wrap"><h1>Academy -- Rep Roster</h1>';
    echo '<p>Read-only completion overview. Reps are users with the <code>' . esc_html(SOLVERRA_ACADEMY_CAP)
        . '</code> capability or a role in {' . esc_html(implode(', ', solverra_academy_allowed_roles())) . '}. '
        . 'Percentages reflect required lessons completed plus quizzes passed.</p>';

    echo '<table class="widefat striped"><thead><tr>';
    echo '<th>Rep</th>';
    foreach ($courses as $course) {
        echo '<th>' . esc_html($course['title']) . '<br><span style="font-weight:400;color:#666;">'
            . esc_html(isset($course['scope']) ? $course['scope'] : '') . '</span></th>';
    }
    echo '<th>Overall</th><th>Certifications</th>';
    echo '</tr></thead><tbody>';

    if (empty($reps)) {
        $colspan = count($courses) + 3;
        echo '<tr><td colspan="' . (int) $colspan . '">No rep users found yet. Grant the <code>'
            . esc_html(SOLVERRA_ACADEMY_CAP) . '</code> capability or an allowed role to a user.</td></tr>';
    } else {
        foreach ($reps as $u) {
            $uid = (int) $u->ID;
            $name = trim((string) $u->display_name);
            if ($name === '') {
                $name = (string) $u->user_login;
            }
            echo '<tr>';
            echo '<td><strong>' . esc_html($name) . '</strong><br><span style="color:#666;">'
                . esc_html((string) $u->user_login) . '</span></td>';
            $certs = solverra_academy_get_certs($uid);
            $cert_count = 0;
            foreach ($courses as $course) {
                $p = solverra_academy_course_progress($uid, $course);
                $cell = $p['percent'] . '%';
                if ($p['certified']) {
                    $cell .= ' &#10003;';
                    $cert_count++;
                }
                echo '<td>' . $cell . ' <span style="color:#888;">(' . (int) $p['done'] . '/' . (int) $p['total'] . ')</span></td>';
            }
            $overall = solverra_academy_overall_progress($uid);
            echo '<td><strong>' . (int) $overall['percent'] . '%</strong></td>';
            echo '<td>' . (int) $cert_count . ' of ' . (int) count($courses) . '</td>';
            echo '</tr>';
        }
    }
    echo '</tbody></table>';

    // Catalog summary (counts), so an admin can sanity-check content size.
    echo '<h2>Catalog</h2><table class="widefat"><thead><tr><th>Course</th><th>Track</th><th>Modules</th>'
        . '<th>Lessons (incl. quizzes)</th></tr></thead><tbody>';
    foreach ($courses as $course) {
        $modules = isset($course['modules']) && is_array($course['modules']) ? count($course['modules']) : 0;
        $lessons = count(solverra_academy_course_lessons($course));
        echo '<tr>';
        echo '<td>' . esc_html($course['title']) . '</td>';
        echo '<td>' . esc_html(isset($course['scope']) ? $course['scope'] : '') . '</td>';
        echo '<td>' . (int) $modules . '</td>';
        echo '<td>' . (int) $lessons . '</td>';
        echo '</tr>';
    }
    echo '</tbody></table>';
    echo '</div>';
}

// End of solverra-academy.php
 island) to keep the file all-PHP + ASCII-only.
function solverra_coa_print_filter_script() {
    $js = <<<'JS'
(function () {
    var grid = document.getElementById('sol-coa-grid');
    if (!grid) { return; }
    var cards   = Array.prototype.slice.call(grid.querySelectorAll('.sol-coa-card'));
    var chips   = Array.prototype.slice.call(document.querySelectorAll('#sol-coa-chips .sol-coa-chip'));
    var input   = document.getElementById('sol-coa-filter-input');
    var empty   = document.getElementById('sol-coa-empty');
    var counter = document.getElementById('sol-coa-browse-count');
    var total   = counter ? (parseInt(counter.getAttribute('data-total'), 10) || cards.length) : cards.length;
    var activeCat = '';
    var query     = '';

    function apply() {
        var q = query.toLowerCase();
        var shown = 0;
        for (var i = 0; i < cards.length; i++) {
            var card = cards[i];
            var cat  = card.getAttribute('data-cat') || '';
            var hay  = card.getAttribute('data-search') || '';
            var catOk  = (activeCat === '' || cat === activeCat);
            var textOk = (q === '' || hay.indexOf(q) !== -1);
            if (catOk && textOk) {
                card.hidden = false;
                shown++;
            } else {
                card.hidden = true;
            }
        }
        if (empty) { empty.hidden = (shown !== 0); }
        if (counter) {
            if (activeCat === '' && q === '') {
                counter.textContent = total + ' certificate' + (total === 1 ? '' : 's') + ' on file';
            } else {
                counter.textContent = 'Showing ' + shown + ' of ' + total + ' certificate' + (total === 1 ? '' : 's');
            }
        }
    }

    for (var c = 0; c < chips.length; c++) {
        chips[c].addEventListener('click', function () {
            activeCat = this.getAttribute('data-cat') || '';
            for (var j = 0; j < chips.length; j++) {
                var on = (chips[j] === this);
                chips[j].classList.toggle('is-active', on);
                chips[j].setAttribute('aria-pressed', on ? 'true' : 'false');
            }
            apply();
        });
    }

    if (input) {
        input.addEventListener('input', function () {
            query = this.value || '';
            apply();
        });
    }
})();
JS;
    echo "\n" . '<script id="sol-coa-filter-js">' . "\n" . $js . "\n" . '</script>' . "\n";
}

function solverra_coa_result_card($row, $with_data = false) {
    $url   = solverra_coa_page_url($row['key']);
    $badge = solverra_coa_badge_html($row['status']);
    $attrs = '';
    if ($with_data) {
        // Searchable haystack for the client-side live filter (lowercased).
        $hay = strtolower(implode(' ', array(
            $row['product'],
            $row['category'],
            $row['sku_hint'],
            $row['lot_number'],
            $row['batch_id'],
            $row['filename'],
        )));
        $attrs = ' data-cat="' . esc_attr($row['category']) . '"'
            . ' data-search="' . esc_attr($hay) . '"';
    }
    $html  = '<li class="sol-coa-card"' . $attrs . '>';
    $html .= '<a class="sol-coa-card__link" href="' . esc_url($url) . '">';
    $html .= '<span class="sol-coa-card__cat">' . esc_html($row['category']) . '</span>';
    $html .= '<span class="sol-coa-card__name">' . esc_html($row['product']) . '</span>';
    $html .= '</a>';
    $html .= '<div class="sol-coa-card__meta">';
    if ($row['sku_hint'] !== '') {
        $html .= '<span class="sol-coa-tag">SKU: ' . esc_html($row['sku_hint']) . '</span>';
    }
    if ($row['lot_number'] !== '') {
        $html .= '<span class="sol-coa-tag">Lot: ' . esc_html($row['lot_number']) . '</span>';
    }
    if ($row['test_date'] !== '') {
        $html .= '<span class="sol-coa-tag">Tested: ' . esc_html($row['test_date']) . '</span>';
    }
    $html .= '</div>';
    $html .= '<div class="sol-coa-card__badge">' . $badge . '</div>';
    $html .= '</li>';
    return $html;
}

// ---------------------------------------------------------------------------
// 10. Rendering -- single COA page
// ---------------------------------------------------------------------------

function solverra_coa_render_single_page($key) {
    $row      = solverra_coa_get($key);
    $settings = solverra_coa_settings();

    if ($row === null) {
        status_header(404);
        solverra_coa_print_header('COA Not Found');
        echo '<main class="sol-coa-wrap"><div class="sol-coa-single">';
        solverra_coa_print_notfound($settings, $key);
        echo '</div></main>';
        solverra_coa_print_footer();
        return;
    }

    $page_url = solverra_coa_page_url($row['key']);
    $badge    = solverra_coa_badge_html($row['status']);
    $qr       = solverra_coa_qr_svg($page_url, 160);

    solverra_coa_print_header('COA -- ' . $row['product']);
    solverra_coa_print_single_schema($row, $page_url);

    echo '<main class="sol-coa-wrap"><article class="sol-coa-single">';
    echo '<nav class="sol-coa-breadcrumb"><a href="' . esc_url(solverra_coa_directory_url()) . '">COA Directory</a> '
        . '&raquo; <span>' . esc_html($row['category']) . '</span></nav>';

    echo '<div class="sol-coa-single__head">';
    echo '<div class="sol-coa-single__title">';
    echo '<span class="sol-coa-single__cat">' . esc_html($row['category']) . '</span>';
    echo '<h1>' . esc_html($row['product']) . '</h1>';
    echo $badge;
    echo '</div>';
    echo '<div class="sol-coa-single__qr">' . $qr
        . '<span class="sol-coa-qr-cap">Scan to verify</span></div>';
    echo '</div>';

    // Lab-result table.
    echo '<h2>Lab Results</h2>';
    echo '<table class="sol-coa-table"><tbody>';
    solverra_coa_table_row('Product', $row['product']);
    solverra_coa_table_row('Category', $row['category']);
    if ($row['sku_hint'] !== '') {
        solverra_coa_table_row('SKU hint', $row['sku_hint']);
    }
    if ($row['lot_number'] !== '') {
        solverra_coa_table_row('Lot number', $row['lot_number']);
    }
    if ($row['batch_id'] !== '') {
        solverra_coa_table_row('Batch ID', $row['batch_id']);
    }
    if ($row['test_date'] !== '') {
        solverra_coa_table_row('Tested date', $row['test_date']);
    }
    if ($row['key_result'] !== '') {
        solverra_coa_table_row('Key result', $row['key_result']);
    }
    solverra_coa_table_row('Source document', $row['filename']);
    solverra_coa_table_row('Machine-readable', $row['text_ok'] ? 'Yes (text layer extracted)' : 'No (scan -- OCR pending)');
    echo '</tbody></table>';

    // If the COA was a scan, surface the review note.
    if (!$row['text_ok']) {
        echo '<p class="sol-coa-note">This certificate is a scanned image. Individual cannabinoid and '
            . 'contaminant values are pending OCR extraction. The full signed lab document remains the '
            . 'authoritative record.</p>';
    }

    // PDF / document link. Today there is no public PDF host; link is the on-site
    // page until R2 (coa.solverraholistics.com) is enabled. Swap point noted.
    $pdf_url = solverra_coa_pdf_url($row, $settings);
    if ($pdf_url !== '') {
        echo '<p class="sol-coa-doc"><a class="sol-coa-btn" href="' . esc_url($pdf_url)
            . '" target="_blank" rel="noopener">View full COA document</a></p>';
    } else {
        echo '<p class="sol-coa-doc sol-coa-doc--pending">The hosted COA PDF will be available here once '
            . 'document serving is enabled. Need it now? Email '
            . '<a href="mailto:' . esc_attr($settings['compliance_email']) . '">'
            . esc_html($settings['compliance_email']) . '</a> with the batch above.</p>';
    }

    // DSHEA disclaimer (required on Solverra product surfaces).
    echo '<p class="sol-coa-disclaimer">These statements have not been evaluated by the FDA. '
        . 'This product is not intended to diagnose, treat, cure, or prevent any disease.</p>';

    echo '</article></main>';
    solverra_coa_print_footer();
}

function solverra_coa_table_row($label, $value) {
    echo '<tr><th scope="row">' . esc_html($label) . '</th><td>' . esc_html($value) . '</td></tr>';
}

// Resolve the public PDF URL. Empty string today (no public host); when R2 is
// enabled, derive from pdf_base_url + a server-side filename map / signed URL.
function solverra_coa_pdf_url($row, $settings) {
    if (solverra_coa_source() !== 'r2kv') {
        return '';
    }
    $base = isset($settings['pdf_base_url']) ? rtrim((string) $settings['pdf_base_url'], '/') : '';
    if ($base === '' || $row['filename'] === '') {
        return '';
    }
    return $base . '/' . rawurlencode($row['filename']);
}

// ---------------------------------------------------------------------------
// 11. Not-found + upsell + upgrade-link helpers
// ---------------------------------------------------------------------------

function solverra_coa_print_notfound($settings, $term) {
    $email = isset($settings['compliance_email']) ? $settings['compliance_email'] : 'compliance@solverraholistics.com';
    echo '<div class="sol-coa-notfound">';
    echo '<h2>No matching certificate found</h2>';
    echo '<p>We could not find a COA for <strong>' . esc_html($term) . '</strong>. '
        . 'Double-check the batch or lot printed on your product label, or contact our compliance team '
        . 'and we will send the certificate directly.</p>';
    echo '<p><a class="sol-coa-btn" href="mailto:' . esc_attr($email) . '">Email ' . esc_html($email) . '</a></p>';
    echo '</div>';
}

function solverra_coa_upgrade_links() {
    return ' <a class="sol-coa-upgrade" href="' . esc_url(home_url('/pricing/')) . '">See plans</a>';
}

function solverra_coa_upsell_banner($settings) {
    $html  = '<aside class="sol-coa-upsell">';
    $html .= '<div class="sol-coa-upsell__body">';
    $html .= '<strong>Need COA management done for you?</strong> ';
    $html .= 'Our managed compliance service ingests, verifies, and publishes every batch COA, '
        . 'runs continuous tamper + freshness checks, and keeps your store launch-ready.';
    $html .= '</div>';
    $html .= '<a class="sol-coa-btn sol-coa-btn--accent" href="' . esc_url(home_url('/managed-compliance/')) . '">'
        . 'Explore managed compliance</a>';
    $html .= '</aside>';
    return $html;
}

// ---------------------------------------------------------------------------
// 12. JSON-LD schema for a single COA page
// ---------------------------------------------------------------------------

function solverra_coa_print_single_schema($row, $url) {
    $data = array(
        '@context' => 'https://schema.org',
        '@type'    => 'Dataset',
        'name'     => 'Certificate of Analysis -- ' . $row['product'],
        'description' => 'Third-party laboratory certificate of analysis for ' . $row['product']
            . ' (' . $row['category'] . ').',
        'url'      => $url,
        'creator'  => array(
            '@type' => 'Organization',
            'name'  => 'Solverra Holistics',
            'url'   => 'https://solverraholistics.com',
        ),
    );
    if ($row['lot_number'] !== '') {
        $data['identifier'] = $row['lot_number'];
    }
    if ($row['test_date'] !== '') {
        $data['dateCreated'] = $row['test_date'];
    }
    $json = wp_json_encode($data);
    if ($json !== false) {
        echo "\n" . '<script type="application/ld+json">' . $json . '</script>' . "\n";
    }
}

// ---------------------------------------------------------------------------
// 13. Shortcodes (embed directory or a badge inside normal WP content / PDP)
// ---------------------------------------------------------------------------

add_shortcode('solverra_coa_directory', 'solverra_coa_sc_directory');
function solverra_coa_sc_directory($atts) {
    $atts = shortcode_atts(array('category' => '', 'limit' => 12), $atts, 'solverra_coa_directory');
    $rows = solverra_coa_search(array(
        'q'        => '',
        'category' => (string) $atts['category'],
        'limit'    => (int) $atts['limit'],
    ));
    $out  = '<div class="sol-coa-embed">';
    $out .= '<p class="sol-coa-embed__head"><a href="' . esc_url(solverra_coa_directory_url()) . '">'
        . 'Open the full COA directory</a></p>';
    $out .= '<ul class="sol-coa-list">';
    foreach ($rows as $row) {
        $out .= solverra_coa_result_card($row);
    }
    $out .= '</ul></div>';
    return $out;
}

add_shortcode('solverra_coa_badge', 'solverra_coa_sc_badge');
function solverra_coa_sc_badge($atts) {
    $atts = shortcode_atts(array('sku' => '', 'lot' => '', 'key' => ''), $atts, 'solverra_coa_badge');
    $row  = null;
    if (!empty($atts['key'])) {
        $row = solverra_coa_get((string) $atts['key']);
    }
    if ($row === null && (!empty($atts['sku']) || !empty($atts['lot']))) {
        $needle = (string) (!empty($atts['lot']) ? $atts['lot'] : $atts['sku']);
        $hits   = solverra_coa_search(array('q' => $needle, 'limit' => 1));
        if (!empty($hits)) {
            $row = $hits[0];
        }
    }
    if ($row === null) {
        return '';
    }
    $url = solverra_coa_page_url($row['key']);
    return '<a class="sol-coa-badge-link" href="' . esc_url($url) . '">'
        . solverra_coa_badge_html($row['status']) . '</a>';
}

// ---------------------------------------------------------------------------
// 14. Front-end styles (inline, ASCII-only, token-aware)
// ---------------------------------------------------------------------------

add_action('wp_head', 'solverra_coa_inline_styles', 20);
function solverra_coa_inline_styles() {
    // Only emit on our route or where a shortcode might render. Cheap + safe to
    // always include; it is small and scoped to .sol-coa selectors.
    echo "\n<style id=\"solverra-coa-css\">\n";
    // ~80% of the viewport, capped at the Solverra wide-container token, centered
    // -- matches the .solverra-mf__wrap / --container-wide convention site-wide.
    echo ".sol-coa-wrap{width:80%;max-width:var(--container-wide,1360px);margin:0 auto;"
        . "padding:24px clamp(16px,4vw,48px);font-family:inherit;color:var(--color-text,#1F2C17);}\n";
    echo "@media (max-width:768px){.sol-coa-wrap{width:92%;padding:20px 16px;}}\n";
    echo ".sol-coa-hero h1{font-size:2rem;margin:0 0 .5rem;}\n";
    echo ".sol-coa-sub{color:var(--color-text-muted,#4D6A3C);max-width:60ch;}\n";
    echo ".sol-coa-search{display:flex;gap:.5rem;flex-wrap:wrap;margin:1.25rem 0;}\n";
    echo ".sol-coa-search input,.sol-coa-search select{padding:.6rem .75rem;border:1px solid #C9A36A;"
        . "border-radius:8px;font-size:1rem;min-width:180px;flex:1 1 auto;}\n";
    echo ".sol-coa-search button,.sol-coa-btn{display:inline-block;padding:.6rem 1rem;border:0;"
        . "border-radius:8px;background:var(--color-primary,#8CC63F);color:var(--sol-forest-deep,#1F2C17);"
        . "font-weight:600;cursor:pointer;text-decoration:none;}\n";
    echo ".sol-coa-btn--accent{background:var(--color-accent,#C9A36A);color:#1F2C17;}\n";
    echo ".sol-coa-list{list-style:none;margin:1rem 0;padding:0;display:grid;gap:.75rem;"
        . "grid-template-columns:repeat(auto-fill,minmax(280px,1fr));}\n";
    echo ".sol-coa-card{border:1px solid #EDE7D3;border-radius:10px;padding:1rem;background:#fff;}\n";
    echo ".sol-coa-card__cat{display:block;font-size:.7rem;text-transform:uppercase;letter-spacing:.05em;"
        . "color:#4D6A3C;}\n";
    echo ".sol-coa-card__name{display:block;font-weight:600;margin:.15rem 0 .5rem;color:#1F2C17;"
        . "text-decoration:none;}\n";
    echo ".sol-coa-card__meta{display:flex;flex-wrap:wrap;gap:.35rem;margin:.25rem 0 .6rem;}\n";
    echo ".sol-coa-tag{font-size:.72rem;background:#F4FAE8;border:1px solid #E7F4D2;border-radius:6px;"
        . "padding:.1rem .4rem;color:#314426;}\n";
    echo ".sol-coa-badge{display:inline-flex;align-items:center;gap:.35rem;font-size:.75rem;"
        . "font-weight:600;padding:.2rem .55rem;border-radius:999px;}\n";
    echo ".sol-coa-badge__dot{width:.5rem;height:.5rem;border-radius:50%;background:currentColor;}\n";
    echo ".sol-coa-badge--verified{background:#E7F4D2;color:#314426;}\n";
    echo ".sol-coa-badge--pending{background:#EDE7D3;color:#8a6d2f;}\n";
    echo ".sol-coa-badge--unverified{background:#f6dada;color:#9b2c2c;}\n";
    echo ".sol-coa-cat-grid{display:flex;flex-wrap:wrap;gap:.5rem;margin:1rem 0;}\n";
    echo ".sol-coa-cat{padding:.4rem .8rem;border:1px solid #C9A36A;border-radius:999px;"
        . "text-decoration:none;color:#314426;background:#fff;}\n";
    echo ".sol-coa-single__head{display:flex;justify-content:space-between;gap:1rem;flex-wrap:wrap;"
        . "align-items:flex-start;margin:.5rem 0 1rem;}\n";
    echo ".sol-coa-single__cat{font-size:.75rem;text-transform:uppercase;color:#4D6A3C;}\n";
    echo ".sol-coa-single__qr{text-align:center;}\n";
    echo ".sol-coa-qr-cap{display:block;font-size:.7rem;color:#4D6A3C;margin-top:.25rem;}\n";
    echo ".sol-coa-table{width:100%;border-collapse:collapse;margin:.5rem 0 1rem;}\n";
    echo ".sol-coa-table th,.sol-coa-table td{text-align:left;padding:.5rem .6rem;"
        . "border-bottom:1px solid #EDE7D3;vertical-align:top;}\n";
    echo ".sol-coa-table th{width:30%;color:#314426;font-weight:600;}\n";
    echo ".sol-coa-note,.sol-coa-disclaimer{font-size:.8rem;color:#4D6A3C;background:#F4FAE8;"
        . "border-left:3px solid #8CC63F;padding:.6rem .8rem;border-radius:0 8px 8px 0;margin:.75rem 0;}\n";
    echo ".sol-coa-disclaimer{background:#fff;border-left-color:#C9A36A;}\n";
    echo ".sol-coa-upsell{display:flex;gap:1rem;align-items:center;justify-content:space-between;"
        . "flex-wrap:wrap;margin:2rem 0;padding:1.25rem;border-radius:12px;background:#314426;color:#F6F4EC;}\n";
    echo ".sol-coa-upsell__body{max-width:60ch;}\n";
    echo ".sol-coa-gate{margin:1rem 0;padding:1rem;border-radius:10px;background:#EDE7D3;color:#1F2C17;}\n";
    echo ".sol-coa-gate--blocked{background:#f6ecd9;border:1px solid #C9A36A;}\n";
    echo ".sol-coa-quota,.sol-coa-capped,.sol-coa-count{font-size:.85rem;color:#4D6A3C;}\n";
    echo ".sol-coa-breadcrumb{font-size:.8rem;margin:.5rem 0;color:#4D6A3C;}\n";
    // Interactive browse: bar, live-filter input, category chips, grid, empty.
    echo ".sol-coa-browse{margin:1.5rem 0 0;}\n";
    echo ".sol-coa-browse__bar{display:flex;align-items:baseline;justify-content:space-between;"
        . "gap:.75rem;flex-wrap:wrap;border-top:1px solid #EDE7D3;padding-top:1.25rem;margin-top:1.5rem;}\n";
    echo ".sol-coa-browse__title{font-size:1.25rem;margin:0;}\n";
    echo ".sol-coa-livefilter{margin:.75rem 0;}\n";
    echo ".sol-coa-livefilter__input{width:100%;box-sizing:border-box;padding:.6rem .75rem;"
        . "border:1px solid #C9A36A;border-radius:8px;font-size:1rem;}\n";
    echo ".sol-coa-chips{display:flex;flex-wrap:wrap;gap:.4rem;margin:.5rem 0 1rem;}\n";
    echo ".sol-coa-chip{padding:.35rem .8rem;border:1px solid #C9A36A;border-radius:999px;"
        . "background:#fff;color:#314426;font-size:.8rem;font-weight:600;cursor:pointer;line-height:1.2;}\n";
    echo ".sol-coa-chip:hover{background:#F4FAE8;}\n";
    echo ".sol-coa-chip.is-active{background:var(--color-primary,#8CC63F);"
        . "border-color:var(--color-primary,#8CC63F);color:#1F2C17;}\n";
    echo ".sol-coa-card[hidden]{display:none;}\n";
    echo ".sol-coa-empty{font-size:.9rem;color:#4D6A3C;background:#F4FAE8;border-left:3px solid #C9A36A;"
        . "padding:.6rem .8rem;border-radius:0 8px 8px 0;}\n";
    echo "</style>\n";
}

// ---------------------------------------------------------------------------
// 15. Minimal page chrome for the standalone /coa pages
// ---------------------------------------------------------------------------
//
// These pages render outside the normal loop, so we emit a lightweight HTML
// shell. If the active theme provides get_header()/get_footer() we could hook
// them, but a self-contained shell keeps the directory robust across themes
// during the build phase.

function solverra_coa_print_header($title) {
    if (!headers_sent()) {
        header('Content-Type: text/html; charset=UTF-8');
    }
    $blog = get_bloginfo('name');
    echo '<!DOCTYPE html><html ' . get_language_attributes() . '><head>';
    echo '<meta charset="UTF-8">';
    echo '<meta name="viewport" content="width=device-width, initial-scale=1">';
    echo '<meta name="robots" content="index,follow">';
    echo '<title>' . esc_html($title) . ' -- ' . esc_html($blog) . '</title>';
    do_action('wp_head');
    echo '</head><body class="sol-coa-page">';
    echo '<a class="sol-coa-home" href="' . esc_url(home_url('/')) . '" style="display:inline-block;padding:12px 16px;font-weight:700;">'
        . esc_html($blog) . '</a>';
}

function solverra_coa_print_footer() {
    $year = gmdate('Y');
    echo '<footer class="sol-coa-footer" style="max-width:1100px;margin:2rem auto;padding:1rem 16px;'
        . 'font-size:.8rem;color:#4D6A3C;border-top:1px solid #EDE7D3;">';
    echo 'Solverra Holistics International &middot; <a href="https://solverraholistics.com">solverraholistics.com</a> '
        . '&middot; COA Directory &copy; ' . esc_html($year);
    echo '</footer>';
    do_action('wp_footer');
    echo '</body></html>';
}

// ---------------------------------------------------------------------------
// 16. Admin settings page
// ---------------------------------------------------------------------------

add_action('admin_menu', 'solverra_coa_admin_menu');
function solverra_coa_admin_menu() {
    add_options_page(
        'Solverra COA Directory',
        'COA Directory',
        'manage_options',
        'solverra-coa',
        'solverra_coa_admin_page'
    );
}

add_action('admin_init', 'solverra_coa_admin_register');
function solverra_coa_admin_register() {
    register_setting('solverra_coa_group', SOLVERRA_COA_OPTION_KEY, 'solverra_coa_sanitize');
}

function solverra_coa_sanitize($input) {
    $out = solverra_coa_settings();
    if (!is_array($input)) {
        return $out;
    }
    if (isset($input['source'])) {
        $out['source'] = ($input['source'] === 'r2kv') ? 'r2kv' : 'csv';
    }
    if (isset($input['csv_path'])) {
        $out['csv_path'] = sanitize_text_field($input['csv_path']);
    }
    if (isset($input['pdf_base_url'])) {
        $out['pdf_base_url'] = esc_url_raw($input['pdf_base_url']);
    }
    if (isset($input['compliance_email'])) {
        $out['compliance_email'] = sanitize_email($input['compliance_email']);
    }
    if (isset($input['viewer_tier'])) {
        $tier = strtolower(sanitize_text_field($input['viewer_tier']));
        $out['viewer_tier'] = in_array($tier, array('free', 'starter', 'growth', 'pro'), true) ? $tier : 'free';
    }
    $out['show_upsell'] = !empty($input['show_upsell']) ? 1 : 0;
    return $out;
}

function solverra_coa_admin_page() {
    if (!current_user_can('manage_options')) {
        return;
    }
    $s     = solverra_coa_settings();
    $rows  = solverra_coa_load();
    $count = count($rows);
    echo '<div class="wrap"><h1>Solverra COA Directory</h1>';
    echo '<p>Active source: <code>' . esc_html(solverra_coa_source()) . '</code>. '
        . 'Certificates loaded: <strong>' . (int) $count . '</strong>. '
        . 'Public directory: <a href="' . esc_url(solverra_coa_directory_url()) . '">'
        . esc_html(solverra_coa_directory_url()) . '</a></p>';
    echo '<form method="post" action="options.php">';
    settings_fields('solverra_coa_group');
    echo '<table class="form-table"><tbody>';

    echo '<tr><th scope="row">Data source</th><td>';
    echo '<select name="' . esc_attr(SOLVERRA_COA_OPTION_KEY) . '[source]">';
    echo '<option value="csv"' . selected($s['source'], 'csv', false) . '>CSV (bundled inventory)</option>';
    echo '<option value="r2kv"' . selected($s['source'], 'r2kv', false) . '>R2 + KV (KV_COA_META_ID) -- enable when live</option>';
    echo '</select>';
    echo '<p class="description">Switch to R2 + KV only after the Cloudflare COA pipeline is provisioned.</p>';
    echo '</td></tr>';

    echo '<tr><th scope="row">CSV path override</th><td>';
    echo '<input type="text" class="regular-text" name="' . esc_attr(SOLVERRA_COA_OPTION_KEY) . '[csv_path]" value="'
        . esc_attr($s['csv_path']) . '" placeholder="' . esc_attr(SOLVERRA_COA_CSV_PATH) . '">';
    echo '</td></tr>';

    echo '<tr><th scope="row">PDF base URL (R2)</th><td>';
    echo '<input type="text" class="regular-text" name="' . esc_attr(SOLVERRA_COA_OPTION_KEY) . '[pdf_base_url]" value="'
        . esc_attr($s['pdf_base_url']) . '">';
    echo '</td></tr>';

    echo '<tr><th scope="row">Compliance email</th><td>';
    echo '<input type="email" class="regular-text" name="' . esc_attr(SOLVERRA_COA_OPTION_KEY) . '[compliance_email]" value="'
        . esc_attr($s['compliance_email']) . '">';
    echo '</td></tr>';

    echo '<tr><th scope="row">Default viewer tier</th><td>';
    echo '<select name="' . esc_attr(SOLVERRA_COA_OPTION_KEY) . '[viewer_tier]">';
    foreach (array('free', 'starter', 'growth', 'pro') as $t) {
        echo '<option value="' . esc_attr($t) . '"' . selected($s['viewer_tier'], $t, false) . '>' . esc_html(ucfirst($t)) . '</option>';
    }
    echo '</select></td></tr>';

    echo '<tr><th scope="row">Show managed-service upsell</th><td>';
    echo '<label><input type="checkbox" name="' . esc_attr(SOLVERRA_COA_OPTION_KEY) . '[show_upsell]" value="1"'
        . checked(!empty($s['show_upsell']), true, false) . '> Show the upsell banner on the directory</label>';
    echo '</td></tr>';

    echo '</tbody></table>';
    submit_button();
    echo '</form></div>';
}

// ---------------------------------------------------------------------------
// 17. Activation -- flush rewrites once per version
// ---------------------------------------------------------------------------

add_action('init', 'solverra_coa_maybe_flush', 99);
function solverra_coa_maybe_flush() {
    $stamp = get_option('solverra_coa_rewrites_version');
    if ($stamp !== SOLVERRA_COA_VERSION) {
        flush_rewrite_rules(false);
        update_option('solverra_coa_rewrites_version', SOLVERRA_COA_VERSION);
    }
}

// End of solverra-coa-directory.php
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/plugins/wp-super-cache/wp-cache-phase2.php</b> on line <b>1597</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-perf.php</b> on line <b>218</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>165</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>167</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>168</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>169</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>170</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>180</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>183</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-content/mu-plugins/solverra-hardening.php</b> on line <b>184</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-includes/pluggable.php</b> on line <b>1535</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/solverraholistic/public_html/wp-content/mu-plugins/solverra-academy.php:1525) in <b>/home/solverraholistic/public_html/wp-includes/pluggable.php</b> on line <b>1538</b><br />