<?php
/**
 * Trait AIJE_GSC
 * Google Search Console OAuth, Token-Verwaltung, Daten-Abruf
 * Der Tab-Inhalt liegt in admin/tab-gsc.php
 */

if ( ! defined( 'ABSPATH' ) ) { exit; }

trait AIJE_GSC {

    public function handle_gsc_oauth_callback() {
        if ( ! isset( $_GET['page'] ) || $_GET['page'] !== 'aije-lite' ) { return; }
        if ( ! isset( $_GET['tab'] )  || $_GET['tab']  !== 'gsc' )       { return; }

        if ( isset( $_GET['gsc_callback'], $_GET['code'] ) ) {
            $o             = $this->get_opts();
            $client_id     = $o['gsc_client_id']     ?? '';
            $client_secret = $o['gsc_client_secret'] ?? '';
            $redirect_uri  = admin_url( 'tools.php?page=aije-lite&tab=gsc&gsc_callback=1' );
            $resp = wp_remote_post( 'https://oauth2.googleapis.com/token', array(
                'body' => array( 'code' => sanitize_text_field( $_GET['code'] ), 'client_id' => $client_id, 'client_secret' => $client_secret, 'redirect_uri' => $redirect_uri, 'grant_type' => 'authorization_code' ),
            ) );
            if ( ! is_wp_error( $resp ) ) {
                $token = json_decode( wp_remote_retrieve_body( $resp ), true );
                if ( ! empty( $token['access_token'] ) ) {
                    update_option( 'aije_gsc_access_token',  $token['access_token'] );
                    update_option( 'aije_gsc_refresh_token', $token['refresh_token'] ?? '' );
                    update_option( 'aije_gsc_token_expiry',  time() + ( $token['expires_in'] ?? 3600 ) );
                    wp_safe_redirect( admin_url( 'tools.php?page=aije-lite&tab=gsc&gsc_connected=1' ) ); exit;
                }
            }
            wp_safe_redirect( admin_url( 'tools.php?page=aije-lite&tab=gsc&gsc_error=1' ) ); exit;
        }

        if ( isset( $_GET['gsc_disconnect'] ) ) {
            delete_option( 'aije_gsc_access_token' );
            delete_option( 'aije_gsc_refresh_token' );
            delete_option( 'aije_gsc_token_expiry' );
            wp_safe_redirect( admin_url( 'tools.php?page=aije-lite&tab=gsc' ) ); exit;
        }
    }

    private function refresh_gsc_token() {
        $o             = $this->get_opts();
        $client_id     = $o['gsc_client_id']     ?? '';
        $client_secret = $o['gsc_client_secret'] ?? '';
        $refresh_token = get_option( 'aije_gsc_refresh_token', '' );
        if ( ! $refresh_token || ! $client_id || ! $client_secret ) { return false; }
        $resp  = wp_remote_post( 'https://oauth2.googleapis.com/token', array( 'body' => array( 'client_id' => $client_id, 'client_secret' => $client_secret, 'refresh_token' => $refresh_token, 'grant_type' => 'refresh_token' ), 'timeout' => 10 ) );
        if ( is_wp_error( $resp ) ) { return false; }
        $token = json_decode( wp_remote_retrieve_body( $resp ), true );
        if ( empty( $token['access_token'] ) ) { return false; }
        update_option( 'aije_gsc_access_token', $token['access_token'] );
        update_option( 'aije_gsc_token_expiry', time() + ( $token['expires_in'] ?? 3600 ) );
        return $token['access_token'];
    }

    private function get_valid_gsc_token() {
        $access_token = get_option( 'aije_gsc_access_token', '' );
        $expiry       = (int) get_option( 'aije_gsc_token_expiry', 0 );
        if ( $expiry && time() > $expiry - 300 ) {
            $new_token = $this->refresh_gsc_token();
            if ( $new_token ) { return $new_token; }
            delete_option( 'aije_gsc_access_token' );
            return '';
        }
        return $access_token;
    }

    /**
     * Ruft GSC Search Analytics ab und gibt Rohdaten zurück.
     * Wird von tab-gsc.php (Seitenansicht) und render_gsc_data() genutzt.
     */
    private function gsc_query( $access_token, $property, $body_array, $timeout = 15 ) {
        $resp = wp_remote_post(
            'https://www.googleapis.com/webmasters/v3/sites/' . urlencode( $property ) . '/searchAnalytics/query',
            array( 'headers' => array( 'Authorization' => 'Bearer ' . $access_token, 'Content-Type' => 'application/json' ), 'body' => wp_json_encode( $body_array ), 'timeout' => $timeout )
        );
        if ( is_wp_error( $resp ) ) { return array(); }
        return json_decode( wp_remote_retrieve_body( $resp ), true )['rows'] ?? array();
    }

    private function gsc_get_sites( $access_token ) {
        $resp = wp_remote_get( 'https://www.googleapis.com/webmasters/v3/sites', array( 'headers' => array( 'Authorization' => 'Bearer ' . $access_token ), 'timeout' => 10 ) );
        if ( is_wp_error( $resp ) ) { return array(); }
        if ( wp_remote_retrieve_response_code( $resp ) === 401 ) {
            $new = $this->refresh_gsc_token();
            if ( ! $new ) { delete_option( 'aije_gsc_access_token' ); return array(); }
            $resp = wp_remote_get( 'https://www.googleapis.com/webmasters/v3/sites', array( 'headers' => array( 'Authorization' => 'Bearer ' . $new ), 'timeout' => 10 ) );
            if ( is_wp_error( $resp ) ) { return array(); }
        }
        return json_decode( wp_remote_retrieve_body( $resp ), true )['siteEntry'] ?? array();
    }

    /**
     * Holt query+page Rohdaten für die Opportunity-Berechnungen, gecacht via Transient
     * (Standard-Cache-Dauer 6h, damit GSC-API nicht bei jedem Tab-Aufruf neu abgefragt wird).
     */
    private function gsc_get_query_page_rows( $access_token, $property, $start, $end ) {
        $cache_key = 'aije_gsc_qp_' . md5( $property . $start . $end );
        $cached    = get_transient( $cache_key );
        if ( $cached !== false ) { return $cached; }

        $rows = $this->gsc_query( $access_token, $property, array(
            'startDate'  => $start,
            'endDate'    => $end,
            'dimensions' => array( 'query', 'page' ),
            'rowLimit'   => 5000,
            'orderBy'    => array( array( 'fieldName' => 'impressions', 'sortOrder' => 'DESCENDING' ) ),
        ), 25 );

        set_transient( $cache_key, $rows, 6 * HOUR_IN_SECONDS );
        return $rows;
    }

    /**
     * Branchenstandard-Erwartungs-CTR-Kurve nach Position (gerundete Richtwerte).
     * Quelle: aggregierte Industry-Benchmarks (Backlinko/Advanced Web Ranking-Größenordnung).
     */
    private function gsc_expected_ctr( $position ) {
        $curve = array(
            1 => 28.0, 2 => 15.0, 3 => 11.0, 4 => 8.0, 5 => 6.0,
            6 => 5.0, 7 => 4.0, 8 => 3.0, 9 => 2.5, 10 => 2.0,
        );
        $p = max( 1, min( 10, round( $position ) ) );
        if ( $position > 10 ) { return 1.0; }
        return $curve[ $p ] ?? 2.0;
    }

    /**
     * Zentrale Gate-Funktion für das Opportunity Radar.
     * Aktuell: immer true (Free). Später: hier Tier-Check einbauen (z. B. aije_pro_enabled()).
     */
    private function gsc_opportunity_radar_enabled() {
        return true;
    }

    /**
     * Berechnet die drei Opportunity-Kategorien aus query+page Rohdaten.
     * Gibt array mit 'striking_distance', 'ctr_leaks', 'cannibalization' zurück.
     */
    private function gsc_compute_opportunities( $rows ) {
        $striking = array();
        $ctr_leaks = array();
        $by_query  = array();

        foreach ( $rows as $r ) {
            $query = $r['keys'][0] ?? '';
            $page  = $r['keys'][1] ?? '';
            if ( $query === '' || $page === '' ) { continue; }

            $clicks = (int) ( $r['clicks'] ?? 0 );
            $impr   = (int) ( $r['impressions'] ?? 0 );
            $ctr    = round( ( $r['ctr'] ?? 0 ) * 100, 2 );
            $pos    = round( $r['position'] ?? 0, 1 );

            // 1) Striking Distance: Position 5–15, Mindest-Impressions, um Rauschen zu filtern
            if ( $pos >= 5 && $pos <= 15 && $impr >= 20 ) {
                $striking[] = array(
                    'query' => $query, 'page' => $page,
                    'position' => $pos, 'impressions' => $impr, 'clicks' => $clicks, 'ctr' => $ctr,
                );
            }

            // 2) CTR-Lecks: tatsächliche CTR deutlich unter Erwartungswert für die Position
            if ( $impr >= 50 && $pos <= 20 ) {
                $expected = $this->gsc_expected_ctr( $pos );
                $gap      = $expected - $ctr; // positiver Wert = Leck
                if ( $gap >= 1.5 ) {
                    $ctr_leaks[] = array(
                        'query' => $query, 'page' => $page,
                        'position' => $pos, 'impressions' => $impr, 'ctr' => $ctr,
                        'expected_ctr' => $expected, 'gap' => round( $gap, 1 ),
                        'lost_clicks_est' => (int) round( $impr * ( $gap / 100 ) ),
                    );
                }
            }

            // 3) Kannibalisierung: gruppiere nach Query, sammle alle Pages
            if ( ! isset( $by_query[ $query ] ) ) { $by_query[ $query ] = array(); }
            $by_query[ $query ][] = array( 'page' => $page, 'impressions' => $impr, 'clicks' => $clicks, 'position' => $pos );
        }

        $cannibalization = array();
        foreach ( $by_query as $query => $pages ) {
            if ( count( $pages ) < 2 ) { continue; }
            // Nur relevant, wenn mehr als eine Seite nennenswerte Impressionen hat
            $relevant = array_filter( $pages, function( $p ) { return $p['impressions'] >= 10; } );
            if ( count( $relevant ) < 2 ) { continue; }
            usort( $relevant, function( $a, $b ) { return $b['impressions'] - $a['impressions']; } );
            $total_impr = array_sum( array_column( $relevant, 'impressions' ) );
            $cannibalization[] = array(
                'query' => $query, 'pages' => $relevant,
                'page_count' => count( $relevant ), 'total_impressions' => $total_impr,
            );
        }
        usort( $cannibalization, function( $a, $b ) { return $b['total_impressions'] - $a['total_impressions']; } );

        usort( $striking, function( $a, $b ) { return $b['impressions'] - $a['impressions']; } );
        usort( $ctr_leaks, function( $a, $b ) { return $b['lost_clicks_est'] - $a['lost_clicks_est']; } );

        return array(
            'striking_distance' => $striking,
            'ctr_leaks'          => $ctr_leaks,
            'cannibalization'    => $cannibalization,
            'counts'             => array(
                'striking_distance' => count( $striking ),
                'ctr_leaks'          => count( $ctr_leaks ),
                'cannibalization'    => count( $cannibalization ),
            ),
        );
    }

    /**
     * Generisches Suchfeld + sortierbare Tabelle (gleiches Bedienkonzept wie der Seiten-Tab).
     * $table_id muss pro Tabelle eindeutig sein, $columns = array( array(key,label,align,sortable) ).
     * $row_renderer ist eine Closure, die für jede Datenzeile <tr>...</tr> als String zurückgibt
     * und dabei data-search auf dem <tr> setzt (für die Filterung).
     */
    private function render_sortable_table( $table_id, $columns, $rows_data, $row_renderer, $default_sort_col = null ) {
        echo '<input type="text" id="' . esc_attr( $table_id ) . '-search" placeholder="Filtern…" style="width:100%;padding:8px 12px;border:1px solid #ddd;border-radius:6px;font-size:13px;margin-bottom:10px;" oninput="aije_tbl_filter(\'' . esc_js( $table_id ) . '\',this.value)">';
        echo '<div style="overflow-x:auto;"><table id="' . esc_attr( $table_id ) . '" style="width:100%;border-collapse:collapse;font-size:13px;">';
        echo '<thead><tr style="border-bottom:2px solid #e5e7eb;">';
        foreach ( $columns as $col ) {
            list( $key, $label, $align, $sortable ) = $col;
            $onclick = $sortable ? ' onclick="aije_tbl_sort(\'' . esc_js( $table_id ) . '\',\'' . esc_js( $key ) . '\',this)"' : '';
            $cursor  = $sortable ? 'cursor:pointer;user-select:none;' : '';
            echo '<th style="text-align:' . esc_attr( $align ) . ';padding:8px 4px;color:#888;font-weight:600;' . $cursor . '"' . $onclick . ' data-col="' . esc_attr( $key ) . '">' . esc_html( $label ) . ( $sortable ? ' <span class="aije-sort-icon" style="font-size:10px;opacity:.5;">↕</span>' : '' ) . '</th>';
        }
        echo '</tr></thead><tbody id="' . esc_attr( $table_id ) . '-tbody">';
        foreach ( $rows_data as $row ) { echo $row_renderer( $row ); }
        echo '</tbody></table></div>';

        if ( $default_sort_col ) {
            echo '<script>document.addEventListener("DOMContentLoaded",function(){var th=document.querySelector("#' . esc_js( $table_id ) . ' th[data-col=\'' . esc_js( $default_sort_col ) . '\']");if(th){aije_tbl_sort_init("' . esc_js( $table_id ) . '","' . esc_js( $default_sort_col ) . '");}});</script>';
        }
    }

    /**
     * Gibt das gemeinsame JS für Sortierung/Filterung aller generischen Tabellen aus.
     * Wird einmal pro Seitenaufruf benötigt — aufgerufen am Ende von render_gsc_data().
     */
    private function render_sortable_table_script() {
        ?>
<script>
var aije_tbl_state={};
function aije_tbl_sort_init(tableId,col){aije_tbl_state[tableId]={col:col,dir:-1};aije_tbl_apply_sort(tableId);}
function aije_tbl_sort(tableId,col,th){
  var st=aije_tbl_state[tableId]||{col:null,dir:-1};
  if(st.col===col){st.dir*=-1;}else{st.col=col;st.dir=-1;}
  aije_tbl_state[tableId]=st;
  document.querySelectorAll('#'+tableId+' .aije-sort-icon').forEach(function(el){el.textContent='↕';el.style.opacity='.5';});
  if(th){var icon=th.querySelector('.aije-sort-icon');if(icon){icon.textContent=st.dir<0?'↓':'↑';icon.style.opacity='1';}}
  aije_tbl_apply_sort(tableId);
}
function aije_tbl_apply_sort(tableId){
  var st=aije_tbl_state[tableId];if(!st)return;
  var table=document.getElementById(tableId);if(!table)return;
  var ths=Array.from(table.querySelectorAll('th'));var idx=ths.findIndex(function(t){return t.dataset.col===st.col;});if(idx<0)return;
  var tbody=document.getElementById(tableId+'-tbody'),rows=Array.from(tbody.querySelectorAll('tr'));
  rows.sort(function(a,b){
    var ca=a.cells[idx],cb=b.cells[idx];
    var av=ca&&ca.dataset.val!==undefined?parseFloat(ca.dataset.val):(ca?ca.textContent.trim():'');
    var bv=cb&&cb.dataset.val!==undefined?parseFloat(cb.dataset.val):(cb?cb.textContent.trim():'');
    if(typeof av==='string')return st.dir*av.localeCompare(bv);
    return st.dir*(av-bv);
  });
  rows.forEach(function(r){tbody.appendChild(r);});
}
function aije_tbl_filter(tableId,val){
  val=val.toLowerCase();
  document.querySelectorAll('#'+tableId+'-tbody tr').forEach(function(r){
    r.style.display=(r.dataset.search||'').indexOf(val)!==-1?'':'none';
  });
}
</script>
        <?php
    }

    /**
     * Tab "Quick Wins (Striking Distance)": vollständige sortierbare Tabelle.
     */
    private function render_gsc_striking_distance_tab( $access_token, $property, $start, $end ) {
        $rows = $this->gsc_get_query_page_rows( $access_token, $property, $start, $end );
        if ( empty( $rows ) ) { echo '<p style="color:#888;">Noch keine ausreichenden Suchdaten im gewählten Zeitraum.</p>'; return; }
        $opp = $this->gsc_compute_opportunities( $rows );
        $data = $opp['striking_distance'];

        echo '<p style="font-size:12px;color:#888;margin:0 0 14px;">🚀 Keywords auf Position 5–15 mit Quick-Win-Potenzial Richtung Top 5 · ' . count( $data ) . ' gefunden</p>';
        if ( empty( $data ) ) { echo '<p style="color:#888;">Keine Quick-Win-Keywords im aktuellen Zeitraum.</p>'; return; }

        $columns = array(
            array( 'query', 'Suchbegriff', 'left', true ),
            array( 'page', 'Seite', 'left', true ),
            array( 'position', 'Position', 'right', true ),
            array( 'impressions', 'Impressionen', 'right', true ),
            array( 'clicks', 'Klicks', 'right', true ),
            array( 'ctr', 'CTR', 'right', true ),
        );
        $path = function( $url ) { return str_replace( home_url(), '', $url ) ?: '/'; };
        $renderer = function( $r ) use ( $path ) {
            $p = $path( $r['page'] );
            $search = strtolower( $r['query'] . ' ' . $p );
            $html  = '<tr style="border-bottom:1px solid #f3f4f6;" data-search="' . esc_attr( $search ) . '">';
            $html .= '<td style="padding:8px 4px;font-weight:600;">' . esc_html( $r['query'] ) . '</td>';
            $html .= '<td style="padding:8px 4px;max-width:220px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;"><a href="' . esc_url( $r['page'] ) . '" target="_blank" style="color:#3b82f6;text-decoration:none;" title="' . esc_attr( $p ) . '">' . esc_html( strlen( $p ) > 35 ? substr( $p, 0, 32 ) . '…' : $p ) . '</a></td>';
            $html .= '<td style="text-align:right;padding:8px 4px;font-weight:700;color:#0369a1;" data-val="' . esc_attr( $r['position'] ) . '">' . esc_html( $r['position'] ) . '</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;" data-val="' . esc_attr( $r['impressions'] ) . '">' . esc_html( number_format_i18n( $r['impressions'] ) ) . '</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;" data-val="' . esc_attr( $r['clicks'] ) . '">' . esc_html( number_format_i18n( $r['clicks'] ) ) . '</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;" data-val="' . esc_attr( $r['ctr'] ) . '">' . esc_html( $r['ctr'] ) . '%</td>';
            $html .= '</tr>';
            return $html;
        };
        $this->render_sortable_table( 'aije-gsc-striking', $columns, $data, $renderer, 'impressions' );
    }

    /**
     * Tab "CTR-Lecks": vollständige sortierbare Tabelle.
     */
    private function render_gsc_ctr_leaks_tab( $access_token, $property, $start, $end ) {
        $rows = $this->gsc_get_query_page_rows( $access_token, $property, $start, $end );
        if ( empty( $rows ) ) { echo '<p style="color:#888;">Noch keine ausreichenden Suchdaten im gewählten Zeitraum.</p>'; return; }
        $opp = $this->gsc_compute_opportunities( $rows );
        $data = $opp['ctr_leaks'];

        echo '<p style="font-size:12px;color:#888;margin:0 0 14px;">📉 Suchbegriffe, deren CTR deutlich unter dem Erwartungswert für ihre Position liegt · ' . count( $data ) . ' gefunden</p>';
        if ( empty( $data ) ) { echo '<p style="color:#888;">Keine auffälligen CTR-Lecks gefunden.</p>'; return; }

        $columns = array(
            array( 'query', 'Suchbegriff', 'left', true ),
            array( 'page', 'Seite', 'left', true ),
            array( 'position', 'Position', 'right', true ),
            array( 'impressions', 'Impressionen', 'right', true ),
            array( 'ctr', 'CTR (ist)', 'right', true ),
            array( 'expected_ctr', 'CTR (erwartet)', 'right', true ),
            array( 'lost_clicks_est', 'Verpasste Klicks (≈)', 'right', true ),
        );
        $path = function( $url ) { return str_replace( home_url(), '', $url ) ?: '/'; };
        $renderer = function( $r ) use ( $path ) {
            $p = $path( $r['page'] );
            $search = strtolower( $r['query'] . ' ' . $p );
            $html  = '<tr style="border-bottom:1px solid #f3f4f6;" data-search="' . esc_attr( $search ) . '">';
            $html .= '<td style="padding:8px 4px;font-weight:600;">' . esc_html( $r['query'] ) . '</td>';
            $html .= '<td style="padding:8px 4px;max-width:220px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;"><a href="' . esc_url( $r['page'] ) . '" target="_blank" style="color:#3b82f6;text-decoration:none;" title="' . esc_attr( $p ) . '">' . esc_html( strlen( $p ) > 35 ? substr( $p, 0, 32 ) . '…' : $p ) . '</a></td>';
            $html .= '<td style="text-align:right;padding:8px 4px;font-weight:700;" data-val="' . esc_attr( $r['position'] ) . '">' . esc_html( $r['position'] ) . '</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;" data-val="' . esc_attr( $r['impressions'] ) . '">' . esc_html( number_format_i18n( $r['impressions'] ) ) . '</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;color:#b45309;font-weight:600;" data-val="' . esc_attr( $r['ctr'] ) . '">' . esc_html( $r['ctr'] ) . '%</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;color:#888;" data-val="' . esc_attr( $r['expected_ctr'] ) . '">' . esc_html( $r['expected_ctr'] ) . '%</td>';
            $html .= '<td style="text-align:right;padding:8px 4px;font-weight:700;color:#ef4444;" data-val="' . esc_attr( $r['lost_clicks_est'] ) . '">~' . esc_html( number_format_i18n( $r['lost_clicks_est'] ) ) . '</td>';
            $html .= '</tr>';
            return $html;
        };
        $this->render_sortable_table( 'aije-gsc-ctrleaks', $columns, $data, $renderer, 'lost_clicks_est' );
    }

    /**
     * Tab "Keyword-Kannibalisierung": eine Hauptzeile pro Suchbegriff, aufklappbar zu den konkurrierenden URLs.
     */
    private function render_gsc_cannibalization_tab( $access_token, $property, $start, $end ) {
        $rows = $this->gsc_get_query_page_rows( $access_token, $property, $start, $end );
        if ( empty( $rows ) ) { echo '<p style="color:#888;">Noch keine ausreichenden Suchdaten im gewählten Zeitraum.</p>'; return; }
        $opp = $this->gsc_compute_opportunities( $rows );
        $data = $opp['cannibalization'];

        echo '<p style="font-size:12px;color:#888;margin:0 0 14px;">⚔️ Suchbegriffe, für die mehrere eigene Seiten gleichzeitig Impressionen erhalten · ' . count( $data ) . ' betroffene Suchbegriffe · Klick auf eine Zeile zeigt die einzelnen URLs</p>';
        if ( empty( $data ) ) { echo '<p style="color:#888;">Keine Kannibalisierung erkannt.</p>'; return; }

        $path = function( $url ) { return str_replace( home_url(), '', $url ) ?: '/'; };
        $table_id = 'aije-gsc-cannib';

        echo '<input type="text" id="' . $table_id . '-search" placeholder="Suchbegriff filtern…" style="width:100%;padding:8px 12px;border:1px solid #ddd;border-radius:6px;font-size:13px;margin-bottom:10px;" oninput="aije_cannib_filter(this.value)">';
        echo '<div style="overflow-x:auto;"><table id="' . $table_id . '" style="width:100%;border-collapse:collapse;font-size:13px;">';
        echo '<thead><tr style="border-bottom:2px solid #e5e7eb;">';
        foreach ( array(
            array( 'query', 'Suchbegriff', 'left' ),
            array( 'page_count', 'Seiten', 'right' ),
            array( 'impressions', 'Impressionen (gesamt)', 'right' ),
            array( 'clicks', 'Klicks (gesamt)', 'right' ),
            array( '', '', 'center' ),
        ) as $col ) {
            $onclick = $col[0] !== '' ? ' onclick="aije_cannib_sort(\'' . esc_js( $col[0] ) . '\',this)"' : '';
            $cursor  = $col[0] !== '' ? 'cursor:pointer;user-select:none;' : '';
            echo '<th style="text-align:' . $col[2] . ';padding:8px 4px;color:#888;font-weight:600;' . $cursor . '"' . $onclick . ' data-col="' . esc_attr( $col[0] ) . '">' . esc_html( $col[1] ) . ( $col[0] !== '' ? ' <span class="aije-sort-icon" style="font-size:10px;opacity:.5;">↕</span>' : '' ) . '</th>';
        }
        echo '</tr></thead><tbody id="' . $table_id . '-tbody">';

        foreach ( $data as $i => $can ) {
            $total_clicks = array_sum( array_column( $can['pages'], 'clicks' ) );
            $row_id = $table_id . '-row-' . $i;
            $search = strtolower( $can['query'] );

            // Hauptzeile
            echo '<tr style="border-bottom:1px solid #f3f4f6;cursor:pointer;" data-search="' . esc_attr( $search ) . '" onclick="aije_cannib_toggle(\'' . esc_js( $row_id ) . '\')">';
            echo '<td style="padding:8px 4px;font-weight:600;"><span id="' . esc_attr( $row_id ) . '-arrow" style="display:inline-block;width:14px;color:#aaa;">▸</span>' . esc_html( $can['query'] ) . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;color:#be123c;font-weight:700;" data-val="' . esc_attr( $can['page_count'] ) . '">' . esc_html( $can['page_count'] ) . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;" data-val="' . esc_attr( $can['total_impressions'] ) . '">' . esc_html( number_format_i18n( $can['total_impressions'] ) ) . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;" data-val="' . esc_attr( $total_clicks ) . '">' . esc_html( number_format_i18n( $total_clicks ) ) . '</td>';
            echo '<td style="text-align:center;padding:8px 4px;color:#aaa;font-size:11px;">Details</td>';
            echo '</tr>';

            // Detailzeile (initial versteckt) mit den einzelnen URLs
            echo '<tr id="' . esc_attr( $row_id ) . '" style="display:none;background:#fafafa;" data-search="' . esc_attr( $search ) . '">';
            echo '<td colspan="5" style="padding:0;">';
            echo '<table style="width:100%;border-collapse:collapse;font-size:12px;margin:4px 0 8px;">';
            foreach ( $can['pages'] as $p ) {
                $pp = $path( $p['page'] );
                echo '<tr style="border-top:1px solid #eee;">';
                echo '<td style="padding:6px 4px 6px 28px;"><a href="' . esc_url( $p['page'] ) . '" target="_blank" style="color:#3b82f6;text-decoration:none;">' . esc_html( $pp ) . '</a></td>';
                echo '<td style="padding:6px 4px;text-align:right;width:90px;color:#888;">Pos. ' . esc_html( $p['position'] ) . '</td>';
                echo '<td style="padding:6px 4px;text-align:right;width:120px;color:#888;">' . esc_html( number_format_i18n( $p['impressions'] ) ) . ' Impr.</td>';
                echo '<td style="padding:6px 4px;text-align:right;width:100px;color:#888;">' . esc_html( number_format_i18n( $p['clicks'] ) ) . ' Klicks</td>';
                echo '</tr>';
            }
            echo '</table></td></tr>';
        }
        echo '</tbody></table></div>';
        ?>
<script>
function aije_cannib_toggle(rowId){
  var row=document.getElementById(rowId);if(!row)return;
  var arrow=document.getElementById(rowId+'-arrow');
  var open=row.style.display!=='none';
  row.style.display=open?'none':'table-row';
  if(arrow){arrow.textContent=open?'▸':'▾';}
}
var aije_cannib_sort_col=null,aije_cannib_sort_dir=-1;
function aije_cannib_sort(col,th){
  if(aije_cannib_sort_col===col){aije_cannib_sort_dir*=-1;}else{aije_cannib_sort_col=col;aije_cannib_sort_dir=-1;}
  document.querySelectorAll('#aije-gsc-cannib .aije-sort-icon').forEach(function(el){el.textContent='↕';el.style.opacity='.5';});
  if(th){var icon=th.querySelector('.aije-sort-icon');if(icon){icon.textContent=aije_cannib_sort_dir<0?'↓':'↑';icon.style.opacity='1';}}
  var tbody=document.getElementById('aije-gsc-cannib-tbody');
  var pairs=[];
  var children=Array.from(tbody.children);
  for(var i=0;i<children.length;i+=2){pairs.push([children[i],children[i+1]]);}
  var ths=Array.from(document.querySelectorAll('#aije-gsc-cannib th'));
  var idx=ths.findIndex(function(t){return t.dataset.col===col;});
  pairs.sort(function(a,b){
    var ca=a[0].cells[idx],cb=b[0].cells[idx];
    var av=ca&&ca.dataset.val!==undefined?parseFloat(ca.dataset.val):(ca?ca.textContent.trim():'');
    var bv=cb&&cb.dataset.val!==undefined?parseFloat(cb.dataset.val):(cb?cb.textContent.trim():'');
    if(typeof av==='string')return aije_cannib_sort_dir*av.localeCompare(bv);
    return aije_cannib_sort_dir*(av-bv);
  });
  pairs.forEach(function(pair){tbody.appendChild(pair[0]);tbody.appendChild(pair[1]);});
}
function aije_cannib_filter(val){
  val=val.toLowerCase();
  var tbody=document.getElementById('aije-gsc-cannib-tbody');
  var children=Array.from(tbody.children);
  for(var i=0;i<children.length;i+=2){
    var mainRow=children[i],detailRow=children[i+1];
    var match=(mainRow.dataset.search||'').indexOf(val)!==-1;
    mainRow.style.display=match?'':'none';
    if(!match){detailRow.style.display='none';var arrow=detailRow.id?document.getElementById(detailRow.id+'-arrow'):null;if(arrow){arrow.textContent='▸';}}
  }
}
</script>
        <?php
    }

    /**
     * Tab "KI-Antworten": Hinweis-Tab, da Google diese Daten (AI Overviews / AI Mode)
     * seit dem 03.06.2026 zwar in der GSC-UI zeigt, aber bisher NICHT über die
     * Search Analytics API bereitstellt (Stand: Juni 2026). Sobald Google einen
     * entsprechenden type/searchAppearance-Wert in der API freigibt, kann hier
     * echte Datenabfrage nachgerüstet werden.
     */
    private function render_gsc_ai_appearances_tab( $property ) {
        $gsc_ui_link = 'https://search.google.com/search-console/performance/search-analytics?resource_id=' . rawurlencode( $property );

        echo '<div style="background:linear-gradient(135deg,#f5f3ff,#fff);border:1px solid #e0d7fb;border-radius:10px;padding:20px 22px;">';
        echo '<div style="display:flex;align-items:center;gap:8px;margin-bottom:12px;"><span style="font-size:20px;">✨</span><h3 style="margin:0;font-size:15px;font-weight:700;color:#1a1a1a;">Seiten in KI-Antworten (AI Overviews / AI Mode)</h3></div>';

        echo '<p style="font-size:13px;color:#444;line-height:1.6;margin:0 0 14px;">Google zeigt seit dem 3. Juni 2026 in der Search Console, wie oft deine Seiten in <strong>AI Overviews</strong> und <strong>AI Mode</strong> erscheinen. Diese Daten umfassen aktuell nur <strong>Impressionen</strong> — keine Klicks oder Suchbegriffe.</p>';

        echo '<p style="font-size:13px;color:#444;line-height:1.6;margin:0 0 16px;">Google hat diese Daten bisher <strong>nicht</strong> für die Search Console API freigegeben. WP Rankify kann sie deshalb noch nicht automatisch abrufen und in dieser Tabelle anzeigen — das ist eine aktuelle Einschränkung von Google selbst, nicht von diesem Plugin. Sobald Google die API erweitert, wird dieser Tab automatisch mit echten Daten befüllt.</p>';

        echo '<a href="' . esc_url( $gsc_ui_link ) . '" target="_blank" style="display:inline-flex;align-items:center;gap:6px;background:#6d28d9;color:#fff;text-decoration:none;font-size:13px;font-weight:600;padding:10px 18px;border-radius:6px;">🔗 In der echten Search Console prüfen</a>';

        echo '<p style="font-size:11px;color:#999;margin:14px 0 0;">Dort: Performance-Bericht öffnen → Filter „Suchtyp" bzw. „Search Appearance" → AI Overviews / AI Mode auswählen.</p>';
        echo '</div>';
    }

    /**
     * Rendert die GSC-Datentabelle (aufgerufen aus tab-gsc.php wenn verbunden).
     */
    private function render_gsc_data( $access_token ) {
        $access_token = $this->get_valid_gsc_token();
        if ( ! $access_token ) {
            echo '<div class="notice notice-warning"><p>⚠ Google Token abgelaufen. Bitte <a href="' . esc_url( admin_url( 'tools.php?page=aije-lite&tab=gsc&gsc_disconnect=1' ) ) . '">Verbindung trennen</a> und neu verbinden.</p></div>';
            return;
        }

        $entries = $this->gsc_get_sites( $access_token );
        if ( empty( $entries ) ) { echo '<p style="color:#888;">Keine Search Console Properties gefunden.</p>'; return; }

        $selected = get_option( 'aije_gsc_property', $entries[0]['siteUrl'] ?? '' );
        if ( isset( $_POST['gsc_property'] ) ) { $selected = sanitize_text_field( $_POST['gsc_property'] ); update_option( 'aije_gsc_property', $selected ); }

        // Property-Auswahl
        echo '<div style="margin-bottom:20px;display:flex;align-items:center;gap:10px;">';
        echo '<label style="font-size:13px;font-weight:600;">Property:</label>';
        $form_url = add_query_arg( array_filter( array( 'page' => 'aije-lite', 'tab' => 'gsc', 'gsc_days' => $_GET['gsc_days'] ?? null, 'gsc_subtab' => $_GET['gsc_subtab'] ?? null, 'gsc_sort' => $_GET['gsc_sort'] ?? null, 'gsc_dir' => $_GET['gsc_dir'] ?? null ) ), admin_url( 'tools.php' ) );
        echo '<form method="post" action="' . esc_url( $form_url ) . '" style="display:inline;"><select name="gsc_property" onchange="this.form.submit()" style="padding:7px 12px;border:1px solid #ddd;border-radius:6px;font-size:13px;">';
        foreach ( $entries as $site ) { $url = $site['siteUrl'] ?? ''; echo '<option value="' . esc_attr( $url ) . '" ' . selected( $selected, $url, false ) . '>' . esc_html( $url ) . '</option>'; }
        echo '</select></form></div>';

        $days_map = array( '7' => 7, '28' => 28, '90' => 90 );
        $days     = isset( $_GET['gsc_days'] ) && isset( $days_map[ $_GET['gsc_days'] ] ) ? (int) $_GET['gsc_days'] : 28;
        $end      = date( 'Y-m-d', strtotime( '-2 days' ) );
        $start    = date( 'Y-m-d', strtotime( '-' . ( $days + 2 ) . ' days' ) );
        $cmp_end  = date( 'Y-m-d', strtotime( '-' . ( $days + 2 ) . ' days' ) );
        $cmp_start = date( 'Y-m-d', strtotime( '-' . ( $days * 2 + 2 ) . ' days' ) );

        // Zeitraum-Umschalter (gilt für alle Sub-Tabs gemeinsam)
        $subtab = isset( $_GET['gsc_subtab'] ) ? sanitize_key( $_GET['gsc_subtab'] ) : 'overview';
        $valid_subtabs = array( 'overview', 'striking', 'ctr_leaks', 'cannibalization', 'ai_appearances' );
        if ( ! in_array( $subtab, $valid_subtabs, true ) ) { $subtab = 'overview'; }

        echo '<div style="display:flex;align-items:center;gap:8px;margin-bottom:14px;"><span style="font-size:12px;color:#888;">Zeitraum:</span>';
        foreach ( array( '7' => '7 Tage', '28' => '28 Tage', '90' => '90 Tage' ) as $d => $label ) {
            $active = ( $days == $d );
            $url_d  = add_query_arg( array( 'gsc_days' => $d, 'gsc_subtab' => $subtab, 'gsc_sort' => $_GET['gsc_sort'] ?? 'clicks', 'gsc_dir' => $_GET['gsc_dir'] ?? 'desc' ), admin_url( 'tools.php?page=aije-lite&tab=gsc' ) );
            echo '<a href="' . esc_url( $url_d ) . '" style="padding:4px 12px;border-radius:5px;font-size:12px;font-weight:600;text-decoration:none;' . ( $active ? 'background:#f29400;color:#fff;' : 'background:#f3f4f6;color:#555;' ) . '">' . esc_html( $label ) . '</a>';
        }
        echo '<span style="font-size:11px;color:#aaa;margin-left:8px;">' . esc_html( $start ) . ' – ' . esc_html( $end ) . '</span></div>';

        // --- Sub-Tab-Leiste ---
        $subtabs_def = array(
            'overview'        => '🔎 Darstellung in der Suche',
            'striking'         => '🚀 Quick Wins',
            'ctr_leaks'        => '📉 CTR-Lecks',
            'cannibalization'  => '⚔️ Kannibalisierung',
            'ai_appearances'   => '✨ KI-Antworten',
        );
        echo '<div style="display:flex;gap:4px;border-bottom:2px solid #e5e7eb;margin-bottom:18px;flex-wrap:wrap;">';
        foreach ( $subtabs_def as $key => $label ) {
            $is_active = ( $subtab === $key );
            $tab_url   = add_query_arg( array( 'gsc_subtab' => $key, 'gsc_days' => $days ), admin_url( 'tools.php?page=aije-lite&tab=gsc' ) );
            $style     = $is_active
                ? 'color:#f29400;border-bottom:2px solid #f29400;font-weight:700;'
                : 'color:#888;border-bottom:2px solid transparent;font-weight:600;';
            echo '<a href="' . esc_url( $tab_url ) . '" style="padding:9px 16px;margin-bottom:-2px;font-size:13px;text-decoration:none;white-space:nowrap;' . $style . '">' . esc_html( $label ) . '</a>';
        }
        echo '</div>';

        if ( $subtab === 'striking' ) {
            $this->render_gsc_striking_distance_tab( $access_token, $selected, $start, $end );
            $this->render_sortable_table_script();
            return;
        }
        if ( $subtab === 'ctr_leaks' ) {
            $this->render_gsc_ctr_leaks_tab( $access_token, $selected, $start, $end );
            $this->render_sortable_table_script();
            return;
        }
        if ( $subtab === 'cannibalization' ) {
            $this->render_gsc_cannibalization_tab( $access_token, $selected, $start, $end );
            return;
        }
        if ( $subtab === 'ai_appearances' ) {
            $this->render_gsc_ai_appearances_tab( $selected );
            return;
        }

        // --- Sub-Tab "overview": bestehende Darstellung in der Suche ---
        $rows     = $this->gsc_query( $access_token, $selected, array( 'startDate' => $start, 'endDate' => $end, 'dimensions' => array( 'page' ), 'rowLimit' => 500, 'orderBy' => array( array( 'fieldName' => 'clicks', 'sortOrder' => 'DESCENDING' ) ) ) );
        $cmp_rows = $this->gsc_query( $access_token, $selected, array( 'startDate' => $cmp_start, 'endDate' => $cmp_end, 'dimensions' => array( 'page' ), 'rowLimit' => 500 ) );

        $cmp_index = array();
        foreach ( $cmp_rows as $cr ) { $cmp_index[ $cr['keys'][0] ] = $cr; }

        echo '<div style="font-size:11px;color:#aaa;margin-bottom:14px;">' . count( $rows ) . ' Seiten im Zeitraum</div>';

        if ( empty( $rows ) ) { echo '<p style="color:#888;">Keine Daten gefunden.</p>'; return; }

        // KPI-Zeile
        $total_clicks = array_sum( array_column( $rows, 'clicks' ) );
        $total_impr   = array_sum( array_column( $rows, 'impressions' ) );
        $cmp_clicks   = array_sum( array_column( $cmp_rows, 'clicks' ) );
        $cmp_impr     = array_sum( array_column( $cmp_rows, 'impressions' ) );
        $ti_avg = $total_impr > 0 ? $total_impr : 1;
        $w_ctr  = 0; $w_pos = 0;
        foreach ( $rows as $r ) { $iw = ( $r['impressions'] ?? 0 ) / $ti_avg; $w_ctr += ( $r['ctr'] ?? 0 ) * $iw; $w_pos += ( $r['position'] ?? 0 ) * $iw; }
        $avg_ctr = round( $w_ctr * 100, 1 ); $avg_pos = round( $w_pos, 1 );
        $dc = $total_clicks - $cmp_clicks; $di = $total_impr - $cmp_impr;
        $fmt = function( $v, $inv = false ) { if ( $v == 0 ) return '<span style="color:#aaa;">±0</span>'; $pos = $inv ? $v < 0 : $v > 0; $c = $pos ? '#22c55e' : '#ef4444'; return '<span style="color:' . $c . ';font-weight:600;">' . ( $v > 0 ? '+' : '' ) . round( $v, 1 ) . '</span>'; };
        echo '<div style="display:grid;grid-template-columns:repeat(auto-fit,minmax(130px,1fr));gap:10px;margin-bottom:20px;">';
        foreach ( array( array( 'Klicks', number_format_i18n( $total_clicks ), $fmt( $dc ), '' ), array( 'Impressionen', number_format_i18n( $total_impr ), $fmt( $di ), '' ), array( 'Ø CTR', $avg_ctr . '%', '', '' ), array( 'Ø Position', $avg_pos, '', '' ) ) as $s ) {
            echo '<div style="background:#fff;border:1px solid #e5e7eb;border-radius:8px;padding:14px 16px;"><div style="font-size:11px;color:#888;margin-bottom:4px;">' . esc_html( $s[0] ) . '</div><div style="font-size:22px;font-weight:700;color:#111;line-height:1.2;">' . esc_html( $s[1] ) . '</div>' . ( $s[2] ? '<div style="font-size:11px;margin-top:3px;">vs. Vorperiode: ' . $s[2] . '</div>' : '' ) . '</div>';
        }
        echo '</div>';

        // SEO-Issues aus Post-Daten
        $o         = $this->get_opts();
        $all_posts = get_posts( array( 'post_type' => $o['enabled_post_types'] ?? array( 'post' ), 'posts_per_page' => -1, 'post_status' => 'publish' ) );
        $url_issues = array();
        foreach ( $all_posts as $p ) {
            $issues = array();
            if ( ! has_post_thumbnail( $p->ID ) ) { $issues[] = array( 'msg' => 'Kein Beitragsbild', 'severity' => 'medium' ); }
            $meta = get_post_meta( $p->ID, '_aije_metadesc', true ) ?: get_post_meta( $p->ID, '_yoast_wpseo_metadesc', true ) ?: get_post_meta( $p->ID, 'rank_math_description', true );
            if ( empty( $meta ) ) { $issues[] = array( 'msg' => 'Keine Meta-Description', 'severity' => 'high' ); }
            if ( str_word_count( wp_strip_all_tags( $p->post_content ) ) < 300 ) { $issues[] = array( 'msg' => 'Text zu kurz', 'severity' => 'medium' ); }
            if ( ! preg_match( '/<h2/i', $p->post_content ) ) { $issues[] = array( 'msg' => 'Kein H2', 'severity' => 'medium' ); }
            if ( empty( get_user_meta( $p->post_author, 'aije_job_title', true ) ) ) { $issues[] = array( 'msg' => 'Kein E-E-A-T Profil', 'severity' => 'high' ); }
            if ( ! empty( $issues ) ) { $url_issues[ trailingslashit( get_permalink( $p->ID ) ) ] = $issues; }
        }

        // Suchfeld + Tabelle
        echo '<input type="text" id="aije-gsc-search" placeholder="Seite filtern…" style="width:100%;padding:8px 12px;border:1px solid #ddd;border-radius:6px;font-size:13px;margin-bottom:10px;" oninput="aije_gsc_filter(this.value)">';
        echo '<div style="overflow-x:auto;"><table id="aije-gsc-table" style="width:100%;border-collapse:collapse;font-size:13px;">';
        echo '<thead><tr style="border-bottom:2px solid #e5e7eb;">';
        foreach ( array( array( 'page', 'Seite', 'left' ), array( 'tasks', 'Tasks', 'left' ), array( 'clicks', 'Klicks', 'right' ), array( 'clicks_d', '±', 'right' ), array( 'impr', 'Impressionen', 'right' ), array( 'ctr', 'CTR', 'right' ), array( 'pos', 'Ø Position', 'right' ), array( 'pos_d', '±', 'right' ) ) as $col ) {
            $no_sort = in_array( $col[0], array( 'tasks' ) );
            $onclick = ! $no_sort ? ' onclick="aije_gsc_sort(\'' . esc_js( $col[0] ) . '\',this)"' : '';
            $cursor  = ! $no_sort ? 'cursor:pointer;user-select:none;' : '';
            echo '<th style="text-align:' . $col[2] . ';padding:8px 4px;color:#888;font-weight:600;' . $cursor . '"' . $onclick . ' data-col="' . $col[0] . '">' . esc_html( $col[1] ) . ( ! $no_sort ? ' <span class="aije-sort-icon" style="font-size:10px;opacity:.5;">↕</span>' : '' ) . '</th>';
        }
        echo '</tr></thead><tbody id="aije-gsc-tbody">';

        foreach ( $rows as $row ) {
            $url       = $row['keys'][0] ?? '';
            $path      = str_replace( home_url(), '', $url );
            $clicks    = (int) ( $row['clicks'] ?? 0 );
            $impr      = (int) ( $row['impressions'] ?? 0 );
            $ctr_raw   = round( ( $row['ctr'] ?? 0 ) * 100, 1 );
            $pos       = round( $row['position'] ?? 0, 1 );
            $pos_c     = $pos <= 3 ? '#22c55e' : ( $pos <= 10 ? '#f59e0b' : '#ef4444' );
            $cmp       = $cmp_index[ $url ] ?? null;
            $d_clicks  = $cmp ? $clicks - (int) ( $cmp['clicks'] ?? 0 ) : null;
            $d_pos     = $cmp ? $pos - round( $cmp['position'] ?? 0, 1 ) : null;
            $issues    = $url_issues[ trailingslashit( $url ) ] ?? array();
            $task_html = '';
            foreach ( $issues as $issue ) { $sev_c = $issue['severity'] === 'high' ? '#ef4444' : '#f59e0b'; $task_html .= '<span title="' . esc_attr( $issue['msg'] ) . '" style="display:inline-block;background:' . $sev_c . '22;color:' . $sev_c . ';border:1px solid ' . $sev_c . '44;border-radius:4px;padding:1px 6px;font-size:10px;margin:1px;">' . esc_html( mb_substr( $issue['msg'], 0, 22 ) ) . '</span>'; }

            $dc_html = $d_clicks !== null ? '<span style="color:' . ( $d_clicks >= 0 ? '#22c55e' : '#ef4444' ) . ';font-weight:600;">' . ( $d_clicks > 0 ? '+' : '' ) . $d_clicks . '</span>' : '<span style="color:#ccc;">–</span>';
            $dp_html = ( $d_pos !== null && $d_pos != 0 ) ? '<span style="color:' . ( $d_pos < 0 ? '#22c55e' : '#ef4444' ) . ';font-weight:600;">' . ( $d_pos > 0 ? '+' : '' ) . round( $d_pos, 1 ) . '</span>' : '<span style="color:#ccc;">–</span>';

            echo '<tr style="border-bottom:1px solid #f3f4f6;" data-url="' . esc_attr( strtolower( $path ) ) . '">';
            echo '<td style="padding:8px 4px;max-width:220px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;"><a href="' . esc_url( $url ) . '" target="_blank" style="color:#3b82f6;text-decoration:none;" title="' . esc_attr( $path ) . '">' . esc_html( strlen( $path ) > 40 ? substr( $path, 0, 37 ) . '…' : $path ) . '</a></td>';
            echo '<td style="padding:8px 4px;max-width:200px;">' . ( $task_html ? '<div style="display:flex;flex-wrap:wrap;gap:2px;">' . $task_html . '</div>' : '<span style="color:#22c55e;font-size:11px;">✓ OK</span>' ) . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;font-weight:600;" data-val="' . $clicks . '">' . number_format_i18n( $clicks ) . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;font-size:11px;" data-val="' . ( $d_clicks ?? 0 ) . '">' . $dc_html . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;color:#888;" data-val="' . $impr . '">' . number_format_i18n( $impr ) . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;" data-val="' . $ctr_raw . '">' . $ctr_raw . '%</td>';
            echo '<td style="text-align:right;padding:8px 4px;font-weight:700;color:' . $pos_c . ';" data-val="' . $pos . '">' . $pos . '</td>';
            echo '<td style="text-align:right;padding:8px 4px;font-size:11px;" data-val="' . ( $d_pos ?? 0 ) . '">' . $dp_html . '</td>';
            echo '</tr>';
        }
        echo '</tbody></table></div>';
        ?>
<script>
var aije_gsc_sort_col='clicks',aije_gsc_sort_dir=-1;
function aije_gsc_sort(col,th){if(aije_gsc_sort_col===col){aije_gsc_sort_dir*=-1;}else{aije_gsc_sort_col=col;aije_gsc_sort_dir=-1;}
document.querySelectorAll('#aije-gsc-table .aije-sort-icon').forEach(function(el){el.textContent='↕';el.style.opacity='.5';});
if(th){var icon=th.querySelector('.aije-sort-icon');if(icon){icon.textContent=aije_gsc_sort_dir<0?'↓':'↑';icon.style.opacity='1';}}
var tbody=document.getElementById('aije-gsc-tbody'),rows=Array.from(tbody.querySelectorAll('tr'));
var ci={'page':0,'tasks':1,'clicks':2,'clicks_d':3,'impr':4,'ctr':5,'pos':6,'pos_d':7};var idx=ci[col]??2;
rows.sort(function(a,b){var av=a.cells[idx]?(a.cells[idx].dataset.val!==undefined?parseFloat(a.cells[idx].dataset.val):a.cells[idx].textContent.trim()):0,bv=b.cells[idx]?(b.cells[idx].dataset.val!==undefined?parseFloat(b.cells[idx].dataset.val):b.cells[idx].textContent.trim()):0;if(typeof av==='string')return aije_gsc_sort_dir*av.localeCompare(bv);return aije_gsc_sort_dir*(av-bv);});
rows.forEach(function(r){tbody.appendChild(r);});}
function aije_gsc_filter(val){val=val.toLowerCase();document.querySelectorAll('#aije-gsc-tbody tr').forEach(function(r){r.style.display=r.dataset.url.indexOf(val)!==-1?'':'none';});}
</script>
        <?php
    }
}