debug-panel.php

<?php
/**
 * CloudScale Analytics - View Diagnostics Panel  v2.0.0
 *
 * Admin only overlay on singular posts showing:
 *   - Post meta count (_cspv_view_count) = the displayed number
 *   - Log table total (SUM of view_count in wp_cspv_views_v2 for this post)
 *   - Jetpack imported count (only when log table is empty = true Jetpack import)
 *   - Restore offset delta (meta ahead of log, permanent gap from log wipe/restore)
 *   - Daily view chart from the log table
 *
 * Only visible to users with manage_options capability.
 * Button renders INLINE next to the view counter (pink, 🐛 icon).
 *
 * @package CloudScale_Free_Analytics
 */

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

// Enqueue styles for the debug panel (admin-only, singular only).
add_action( 'wp_enqueue_scripts', 'cspv_debug_panel_enqueue' );

/**
 * Enqueue inline CSS and JS for the debug panel on singular admin-visible pages.
 *
 * @since 2.0.0
 * @return void
 */
function cspv_debug_panel_enqueue() {
    if ( ! is_singular() || ! current_user_can( 'manage_options' ) ) {
        return;
    }

    $css = '#cspv-debug-toggle{display:inline-flex;align-items:center;gap:5px;background:linear-gradient(135deg,#db2777,#f472b6);color:#fff;border:none;cursor:pointer;font-size:13px;font-weight:700;line-height:1;padding:7px 14px;border-radius:20px;box-shadow:0 2px 8px rgba(219,39,119,.3);transition:transform .15s,box-shadow .15s;vertical-align:middle;margin-left:8px;letter-spacing:.02em;}'
         . '#cspv-debug-toggle:hover{transform:scale(1.05);box-shadow:0 3px 12px rgba(219,39,119,.4);}'
         . '#cspv-debug-panel{display:none;position:fixed;bottom:16px;right:16px;z-index:99999;width:400px;max-width:calc(100vw - 32px);max-height:calc(100vh - 32px);overflow-y:auto;background:#fff;border-radius:10px;box-shadow:0 4px 24px rgba(0,0,0,.2);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,sans-serif;font-size:13px;color:#1a2332;}'
         . '#cspv-debug-panel.open{display:block;}'
         . '.cspv-dbg-header{background:linear-gradient(135deg,#db2777 0%,#f472b6 100%);color:#fff;padding:12px 16px;font-size:12px;font-weight:700;text-transform:uppercase;letter-spacing:.05em;display:flex;justify-content:space-between;align-items:center;}'
         . '.cspv-dbg-header small{display:block;font-weight:400;opacity:.75;text-transform:none;letter-spacing:0;margin-top:2px;font-size:11px;}'
         . '.cspv-dbg-close{background:rgba(255,255,255,.2);border:none;color:#fff;cursor:pointer;width:28px;height:28px;border-radius:50%;font-size:14px;display:flex;align-items:center;justify-content:center;padding:0;}'
         . '.cspv-dbg-close:hover{background:rgba(255,255,255,.35);}'
         . '.cspv-dbg-body{padding:14px 16px;}'
         . '.cspv-dbg-row{display:flex;justify-content:space-between;align-items:baseline;padding:5px 0;border-bottom:1px solid #f0f0f0;}'
         . '.cspv-dbg-row:last-child{border-bottom:none;}'
         . '.cspv-dbg-label{color:#666;font-size:12px;}'
         . '.cspv-dbg-value{font-weight:700;font-variant-numeric:tabular-nums;}'
         . '.cspv-dbg-value.green{color:#059669;}.cspv-dbg-value.blue{color:#1e6fd9;}.cspv-dbg-value.orange{color:#f47c20;}.cspv-dbg-value.red{color:#e53e3e;}'
         . '.cspv-dbg-section{font-size:11px;font-weight:700;text-transform:uppercase;color:#aaa;letter-spacing:.04em;margin:10px 0 4px;padding-top:6px;border-top:1px solid #eee;}'
         . '.cspv-dbg-section:first-child{border-top:none;margin-top:0;padding-top:0;}'
         . '.cspv-dbg-chart{height:80px;display:flex;align-items:flex-end;gap:2px;margin-top:8px;}'
         . '.cspv-dbg-bar{flex:1;background:linear-gradient(180deg,#db2777,#f9a8d4);border-radius:2px 2px 0 0;min-height:2px;position:relative;cursor:default;}'
         . '.cspv-dbg-bar:hover{opacity:.8;}'
         . '.cspv-dbg-bar-tip{display:none;position:absolute;bottom:100%;left:50%;transform:translateX(-50%);background:#1a2332;color:#fff;font-size:10px;padding:2px 6px;border-radius:3px;white-space:nowrap;pointer-events:none;}'
         . '.cspv-dbg-bar:hover .cspv-dbg-bar-tip{display:block;}'
         . '.cspv-dbg-chart-labels{display:flex;justify-content:space-between;font-size:10px;color:#aaa;margin-top:2px;}'
         . '.cspv-dbg-warn{background:#fef3cd;border:1px solid #f0d060;border-radius:4px;padding:8px 10px;font-size:12px;margin-top:10px;color:#856404;}'
         . '.cspv-dbg-fix-btn{display:inline-block;margin-top:6px;padding:4px 12px;background:#e53e3e;color:#fff;border:none;border-radius:4px;font-size:11px;font-weight:700;cursor:pointer;}'
         . '.cspv-dbg-fix-btn:hover{background:#c53030;}'
         . '.cspv-dbg-override{display:flex;gap:6px;align-items:center;margin-top:8px;}'
         . '.cspv-dbg-override input{flex:1;padding:4px 8px;border:1px solid #ccc;border-radius:4px;font-size:12px;}'
         . '.cspv-dbg-override-btn{padding:4px 12px;background:#7c3aed;color:#fff;border:none;border-radius:4px;font-size:11px;font-weight:700;cursor:pointer;white-space:nowrap;}'
         . '.cspv-dbg-override-btn:hover{background:#6d28d9;}';

    wp_register_style( 'cspv-debug-panel', false );
    wp_enqueue_style( 'cspv-debug-panel' );
    wp_add_inline_style( 'cspv-debug-panel', $css );

    wp_register_script( 'cspv-debug-panel', false, array(), CSPV_VERSION, true );
    wp_enqueue_script( 'cspv-debug-panel' );
}

// Inject the debug button right after the auto-display counter
add_filter( 'the_content', 'cspv_inject_debug_button', 100 );

/**
 * Prepend a hidden debug toggle button to post content for admins.
 *
 * JavaScript relocates the button into the view counter element after load.
 *
 * @since 2.0.0
 * @param string $content Post content.
 * @return string Content with debug button prepended, or unchanged for non-admins.
 */
function cspv_inject_debug_button( $content ) {
    if ( ! is_singular() ) { return $content; }
    if ( ! current_user_can( 'manage_options' ) ) { return $content; }

    // Always prepend a hidden button; JS will relocate it into the counter container
    $btn = '<button id="cspv-debug-toggle" style="display:none" title="View Diagnostics">🐛 Debug</button>';
    $content = wp_kses_post( $btn ) . $content;

    return $content;
}

// Render the panel in wp_footer
add_action( 'wp_footer', 'cspv_render_debug_panel' );

/**
 * Render the diagnostics panel overlay in wp_footer for admin users.
 *
 * Outputs meta count vs log count comparison, timeline, daily chart,
 * and any mismatch warnings for the current singular post.
 *
 * @since 2.0.0
 * @return void
 */
function cspv_render_debug_panel() {
    if ( ! is_singular() ) { return; }
    if ( ! current_user_can( 'manage_options' ) ) { return; }

    global $wpdb;
    $post_id = get_the_ID();
    $table   = cspv_views_table();
    $cnt     = cspv_count_expr();

    $meta_count = (int) get_post_meta( $post_id, CSPV_META_KEY, true );

    $table_exists = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table ) );
    $log_count    = 0;
    $first_log    = null;
    $last_log     = null;
    $daily_data   = array();

    if ( $table_exists ) {
        $log_count = (int) $wpdb->get_var( $wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- trusted internal table name/expression
            "SELECT {$cnt} FROM `{$table}` WHERE post_id = %d", $post_id ) );

        $first_log = $wpdb->get_var( $wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- trusted internal table name/expression
            "SELECT MIN(viewed_at) FROM `{$table}` WHERE post_id = %d", $post_id ) );

        $last_log = $wpdb->get_var( $wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- trusted internal table name/expression
            "SELECT MAX(viewed_at) FROM `{$table}` WHERE post_id = %d", $post_id ) );

        $rows = $wpdb->get_results( $wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- trusted internal table name/expression
            "SELECT DATE(viewed_at) AS day, {$cnt} AS views
             FROM `{$table}`
             WHERE post_id = %d AND viewed_at >= %s
             GROUP BY day ORDER BY day ASC", $post_id, wp_date( 'Y-m-d H:i:s', strtotime( current_time( 'mysql' ) ) - ( 30 * 86400 ) ) ) );
        if ( is_array( $rows ) ) {
            foreach ( $rows as $r ) {
                $daily_data[] = array( 'day' => $r->day, 'views' => (int) $r->views );
            }
        }
    }

    $meta_ahead       = max( 0, $meta_count - $log_count );
    // A true Jetpack import means ALL counts came from Jetpack (no log rows at all).
    // A non-zero delta when log rows exist is just an unlogged-view discrepancy.
    $jetpack_imported = ( $log_count === 0 ) ? $meta_ahead : 0;
    $unlogged_delta   = ( $log_count > 0 ) ? $meta_ahead : 0;
    $mismatch         = ( $meta_count !== $log_count && $meta_ahead === 0 );
    $jp_meta          = get_post_meta( $post_id, 'jetpack_post_views', true );
    $jp_views         = $jp_meta ? (int) $jp_meta : null;

    ?>
<div id="cspv-debug-panel">
    <div class="cspv-dbg-header">
        <div>🐛 View Diagnostics — Post #<?php echo (int) $post_id; ?>
        <small><?php echo esc_html( get_the_title( $post_id ) ); ?></small></div>
        <button class="cspv-dbg-close" id="cspv-dbg-close" title="Close">✕</button>
    </div>
    <div class="cspv-dbg-body">

        <div class="cspv-dbg-section">Counts</div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Displayed count (post meta)</span>
            <span class="cspv-dbg-value <?php echo $mismatch ? 'red' : 'green'; ?>"><?php echo number_format( $meta_count ); ?></span>
        </div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Log table total — SUM(view_count) in wp_cspv_views_v2</span>
            <span class="cspv-dbg-value blue"><?php echo number_format( $log_count ); ?></span>
        </div>
        <?php if ( $jetpack_imported > 0 ) : ?>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Jetpack imported (no log rows)</span>
            <span class="cspv-dbg-value orange"><?php echo number_format( $jetpack_imported ); ?></span>
        </div>
        <?php endif; ?>
        <?php if ( $unlogged_delta > 0 ) : ?>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Restore offset (meta ahead of log)</span>
            <span class="cspv-dbg-value orange"><?php echo number_format( $unlogged_delta ); ?></span>
        </div>
        <?php endif; ?>
        <?php if ( $jp_views !== null ) : ?>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Jetpack meta (jetpack_post_views)</span>
            <span class="cspv-dbg-value"><?php echo number_format( $jp_views ); ?></span>
        </div>
        <?php endif; ?>

        <div class="cspv-dbg-section">Timeline</div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">First logged view</span>
            <span class="cspv-dbg-value"><?php echo $first_log ? esc_html( $first_log ) : 'none'; ?></span>
        </div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Last logged view</span>
            <span class="cspv-dbg-value"><?php echo $last_log ? esc_html( $last_log ) : 'none'; ?></span>
        </div>

        <?php if ( ! empty( $daily_data ) ) : ?>
        <div class="cspv-dbg-section">Last 30 days (log table only)</div>
        <?php
            $max_v = max( array_column( $daily_data, 'views' ) );
            $max_v = max( 1, $max_v );
        ?>
        <div class="cspv-dbg-chart">
            <?php foreach ( $daily_data as $d ) :
                $pct = round( ( $d['views'] / $max_v ) * 100 );
            ?>
            <div class="cspv-dbg-bar" style="height:<?php echo max( 2, $pct ); ?>%">
                <span class="cspv-dbg-bar-tip"><?php echo esc_html( wp_date( 'j M', strtotime( $d['day'] ) ) . ': ' . number_format( $d['views'] ) ); ?></span>
            </div>
            <?php endforeach; ?>
        </div>
        <div class="cspv-dbg-chart-labels">
            <span><?php echo esc_html( wp_date( 'j M', strtotime( $daily_data[0]['day'] ) ) ); ?></span>
            <span><?php echo esc_html( wp_date( 'j M', strtotime( end( $daily_data )['day'] ) ) ); ?></span>
        </div>
        <?php endif; ?>

        <?php if ( $jetpack_imported > 0 ) : ?>
        <div class="cspv-dbg-warn">
            All <?php echo number_format( $meta_count ); ?> views came from Jetpack import. No log table rows exist for this post.
        </div>
        <?php elseif ( $mismatch ) : ?>
        <div class="cspv-dbg-warn">
            ⚠ Meta count (<?php echo number_format( $meta_count ); ?>) does not match log count (<?php echo number_format( $log_count ); ?>) and no Jetpack import accounts for the difference. The meta may have been corrupted.
            <br>
            <button class="cspv-dbg-fix-btn" id="cspv-dbg-resync">Resync meta from log table</button>
        </div>
        <?php endif; ?>

        <div class="cspv-dbg-section">Manual Override</div>
        <div class="cspv-dbg-row" style="flex-direction:column;align-items:flex-start;gap:4px;">
            <span class="cspv-dbg-label">Set displayed count to a specific value (e.g. after a data restore)</span>
            <div class="cspv-dbg-override">
                <input type="number" id="cspv-dbg-override-val" min="0" placeholder="e.g. 2000" value="<?php echo (int) $meta_count; ?>">
                <button class="cspv-dbg-override-btn" id="cspv-dbg-override-save">Set count</button>
            </div>
        </div>

        <div class="cspv-dbg-section">System</div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Plugin version</span>
            <span class="cspv-dbg-value"><?php echo esc_html( CSPV_VERSION ); ?></span>
        </div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Stored version (cspv_version)</span>
            <span class="cspv-dbg-value"><?php echo esc_html( get_option( 'cspv_version', 'none' ) ); ?></span>
        </div>
        <div class="cspv-dbg-row">
            <span class="cspv-dbg-label">Dedup</span>
            <span class="cspv-dbg-value"><?php
                $dd = get_option( 'cspv_dedup_enabled', 'yes' );
                echo ( $dd !== 'no' ) ? 'On' : 'Off';
            ?></span>
        </div>
    </div>
</div>

<?php
    $js_data = 'var cspvDebug=' . wp_json_encode( array(
        'ajaxUrl' => admin_url( 'admin-ajax.php' ),
        'nonce'   => wp_create_nonce( 'cspv_resync' ),
        'postId'  => $post_id,
    ) ) . ';';

    $js = $js_data . '
(function(){
    var toggle=document.getElementById("cspv-debug-toggle");
    var panel=document.getElementById("cspv-debug-panel");
    var close=document.getElementById("cspv-dbg-close");
    if(!toggle||!panel)return;
    var container=document.querySelector(".cspv-auto-views");
    if(container&&toggle.parentElement!==container){container.appendChild(toggle);}
    toggle.style.display="";
    toggle.addEventListener("click",function(){panel.classList.toggle("open");});
    if(close)close.addEventListener("click",function(){panel.classList.remove("open");});
    var resync=document.getElementById("cspv-dbg-resync");
    if(resync){
        resync.addEventListener("click",function(){
            resync.disabled=true;
            resync.textContent="Resyncing\u2026";
            fetch(cspvDebug.ajaxUrl,{
                method:"POST",credentials:"same-origin",
                headers:{"Content-Type":"application/x-www-form-urlencoded"},
                body:"action=cspv_resync_meta&nonce="+encodeURIComponent(cspvDebug.nonce)+"&post_id="+cspvDebug.postId
            }).then(function(r){return r.json();})
            .then(function(resp){
                if(resp.success){
                    resync.textContent="\u2713 Resynced to "+resp.data.new_count.toLocaleString();
                    resync.style.background="#059669";
                }else{resync.textContent="\u2717 Failed";}
            }).catch(function(){resync.textContent="\u2717 Error";});
        });
    }
    var overrideSave=document.getElementById("cspv-dbg-override-save");
    var overrideVal=document.getElementById("cspv-dbg-override-val");
    if(overrideSave&&overrideVal){
        overrideSave.addEventListener("click",function(){
            var v=parseInt(overrideVal.value,10);
            if(isNaN(v)||v<0){overrideVal.style.borderColor="#e53e3e";return;}
            overrideVal.style.borderColor="";
            if(!confirm("Set view count for this post to "+v.toLocaleString()+"?"))return;
            overrideSave.disabled=true;
            overrideSave.textContent="Saving\u2026";
            fetch(cspvDebug.ajaxUrl,{
                method:"POST",credentials:"same-origin",
                headers:{"Content-Type":"application/x-www-form-urlencoded"},
                body:"action=cspv_set_view_count&nonce="+encodeURIComponent(cspvDebug.nonce)+"&post_id="+cspvDebug.postId+"&count="+v
            }).then(function(r){return r.json();})
            .then(function(resp){
                if(resp.success){
                    overrideSave.textContent="\u2713 Set to "+resp.data.new_count.toLocaleString();
                    overrideSave.style.background="#059669";
                }else{overrideSave.textContent="\u2717 Failed";overrideSave.disabled=false;}
            }).catch(function(){overrideSave.textContent="\u2717 Error";overrideSave.disabled=false;});
        });
    }
})();';

    wp_add_inline_script( 'cspv-debug-panel', $js );
}

// AJAX handler for resync (from front end debug panel)
add_action( 'wp_ajax_cspv_resync_meta', 'cspv_ajax_resync_meta' );

/**
 * AJAX handler: resync the post meta count from the log table.
 *
 * Sets _cspv_view_count to the sum of log rows plus any Jetpack imported views.
 * Requires manage_options capability and a valid nonce.
 *
 * @since 2.0.0
 * @return void Sends JSON response.
 */
function cspv_ajax_resync_meta() {
    if ( ! check_ajax_referer( 'cspv_resync', 'nonce', false ) ) {
        wp_send_json_error( array( 'message' => 'Security check failed.' ), 403 );
        return;
    }
    if ( ! current_user_can( 'manage_options' ) ) {
        wp_send_json_error( array( 'message' => 'Insufficient permissions.' ), 403 );
        return;
    }

    global $wpdb;
    $post_id = isset( $_POST['post_id'] ) ? absint( $_POST['post_id'] ) : 0;
    if ( ! $post_id ) {
        wp_send_json_error( array( 'message' => 'Invalid post ID.' ) );
        return;
    }

    $table = cspv_views_table();
    $cnt   = cspv_count_expr();
    $log_count = (int) $wpdb->get_var( $wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- trusted internal table name/expression
        "SELECT {$cnt} FROM `{$table}` WHERE post_id = %d", $post_id ) );
    $jp_views  = (int) get_post_meta( $post_id, 'jetpack_post_views', true );
    $old_count = (int) get_post_meta( $post_id, CSPV_META_KEY, true );
    // Never reduce the meta — take the higher of the two sources so a partial
    // log restore doesn't silently wipe out counts that meta already knows about.
    $new_count = max( $old_count, $log_count + max( 0, $jp_views ) );
    update_post_meta( $post_id, CSPV_META_KEY, $new_count );

    wp_send_json_success( array(
        'post_id'   => $post_id,
        'old_count' => $old_count,
        'new_count' => $new_count,
        'log_rows'  => $log_count,
        'jp_views'  => $jp_views,
    ) );
}

// AJAX handler for manual count override (e.g. after a data restore).
add_action( 'wp_ajax_cspv_set_view_count', 'cspv_ajax_set_view_count' );

/**
 * AJAX handler: manually set the post meta view count to a specific value.
 *
 * Used to correct counts that were lost or corrupted during a data restore.
 * Requires manage_options capability and a valid nonce.
 *
 * @since 2.9.102
 * @return void Sends JSON response.
 */
function cspv_ajax_set_view_count() {
    if ( ! check_ajax_referer( 'cspv_resync', 'nonce', false ) ) {
        wp_send_json_error( array( 'message' => 'Security check failed.' ), 403 );
        return;
    }
    if ( ! current_user_can( 'manage_options' ) ) {
        wp_send_json_error( array( 'message' => 'Insufficient permissions.' ), 403 );
        return;
    }

    $post_id = isset( $_POST['post_id'] ) ? absint( $_POST['post_id'] ) : 0;
    if ( ! $post_id ) {
        wp_send_json_error( array( 'message' => 'Invalid post ID.' ) );
        return;
    }

    $new_count = isset( $_POST['count'] ) ? absint( $_POST['count'] ) : 0;
    $old_count = (int) get_post_meta( $post_id, CSPV_META_KEY, true );
    update_post_meta( $post_id, CSPV_META_KEY, $new_count );

    wp_send_json_success( array(
        'post_id'   => $post_id,
        'old_count' => $old_count,
        'new_count' => $new_count,
    ) );
}