<?php
if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly

/**
 * Admin UI and AJAX handlers for 404 Scout.
 *
 * @since      1.0
 * @package    AILinkMaster
 * @subpackage AILinkMaster/modules/404-scout
 */
class AILM_Scout_Admin {

    public function __construct() {
        add_action( 'wp_ajax_ailm_scout_start_scan', array( $this, 'ajax_start_scan' ) );
        add_action( 'wp_ajax_ailm_scout_cancel_scan', array( $this, 'ajax_cancel_scan' ) );
        add_action( 'wp_ajax_ailm_scout_get_status', array( $this, 'ajax_get_status' ) );
        add_action( 'wp_ajax_ailm_scout_unlink', array( $this, 'ajax_unlink_ailm' ) );
    }

    public function ajax_start_scan(){ if(!current_user_can('manage_options') || !check_ajax_referer('ailm_scout_start_scan_nonce', '_ajax_nonce', false))wp_send_json_error('Permission denied.'); AILM_Scout_Background_Processor::start_scan(); wp_send_json_success('Scan started.'); }
    public function ajax_cancel_scan(){ if(!current_user_can('manage_options') || !check_ajax_referer('ailm_scout_cancel_scan_nonce', '_ajax_nonce', false))wp_send_json_error('Permission denied.'); AILM_Scout_Background_Processor::cancel_scan(); wp_send_json_success('Scan cancelled.'); }
    public function ajax_get_status(){ if(!current_user_can('manage_options') || !check_ajax_referer('ailm_scout_get_status_nonce', '_ajax_nonce', false))wp_send_json_error('Permission denied.'); wp_send_json_success(AILM_Scout_Background_Processor::get_status()); }
    public function ajax_unlink_ailm(){
        if(!current_user_can('manage_options') || !check_ajax_referer('ailm_scout_unlink_nonce', '_ajax_nonce', false)) {
            wp_send_json_error('Permission denied.');
        }
        
        $post_id = isset($_POST['post_id']) ? intval($_POST['post_id']) : 0;
        $url_to_remove = isset($_POST['url']) ? esc_url_raw(wp_unslash($_POST['url'])) : '';
        
        if(!$post_id || empty($url_to_remove)) {
            wp_send_json_error('Invalid data');
        }

        $frozen_map = get_post_meta($post_id, '_ailm_frozen_map', true);
        
        if (is_array($frozen_map)) {
            $updated = false;
            foreach ($frozen_map as $key => $item) {
                if ($item['url'] === $url_to_remove) {
                    unset($frozen_map[$key]);
                    $updated = true;
                    $target_id = url_to_postid($url_to_remove);
                    if ($target_id) {
                        $count = (int) get_post_meta($target_id, '_ailm_inbound_count', true);
                        update_post_meta($target_id, '_ailm_inbound_count', max(0, $count - 1));
                    }
                }
            }

            if ($updated) {
                update_post_meta($post_id, '_ailm_frozen_map', array_values($frozen_map));
                
                global $wpdb;
                $table_name = AILM_Scout_DB::get_table_name();
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery
                $wpdb->delete(
                    $table_name,
                    array(
                        'post_id' => $post_id,
                        'url' => $url_to_remove,
                        'link_origin' => 'ailm'
                    ),
                    array('%d', '%s', '%s')
                );
                wp_send_json_success('Link removed from AILM map.');
            }
        }
        
        wp_send_json_error('Link not found in map.');
    }

    /**
     * Helper function for generating sorting links.
     * @param string $orderby_val   The column to sort by.
     * @param string $current_orderby The current sorting column.
     * @param string $current_order   The current sort order.
     * @return string The new sort URL.
     */
    private function get_sort_link($orderby_val, $current_orderby, $current_order) {
        if ($orderby_val === $current_orderby) {
            $order = (strtolower($current_order) === 'desc') ? 'asc' : 'desc';
        } else {
            $order = 'desc';
        }
        return add_query_arg(['orderby' => $orderby_val, 'order' => $order]);
    }

    public function render_tab() {
        global $wpdb;
        $table_name = AILM_Scout_DB::get_table_name();

        // phpcs:ignore WordPress.Security.NonceVerification.Recommended
        $per_page = isset( $_GET['per_page'] ) && in_array( $_GET['per_page'], [20, 50, 100] ) ? intval($_GET['per_page']) : 50;
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended
        $paged = isset( $_GET['paged'] ) ? max( 1, intval( $_GET['paged'] ) ) : 1;
        $offset = ( $paged - 1 ) * $per_page;

        // Sanitize and whitelist orderby parameter
        $allowed_orderby = ['internal_cnt', 'external_cnt', 'errors_count'];
        $orderby = 'errors_count';
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended
        if ( isset( $_GET['orderby'] ) ) {
            // phpcs:ignore WordPress.Security.NonceVerification.Recommended
            $requested_orderby = sanitize_key( wp_unslash( $_GET['orderby'] ) );
            if ( in_array( $requested_orderby, $allowed_orderby, true ) ) {
                $orderby = $requested_orderby;
            }
        }
        
        // Sanitize and whitelist order parameter
        $order = 'DESC';
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended
        if ( isset( $_GET['order'] ) ) {
            // phpcs:ignore WordPress.Security.NonceVerification.Recommended
            $requested_order = strtoupper( sanitize_key( wp_unslash( $_GET['order'] ) ) );
            if ( in_array( $requested_order, [ 'ASC', 'DESC' ], true ) ) {
                $order = $requested_order;
            }
        }
        
        $base_query = "SELECT post_id, COUNT(id) as total_links, SUM(CASE WHEN status_code >= 400 THEN 1 ELSE 0 END) as errors_count, SUM(CASE WHEN link_type = 'internal' THEN 1 ELSE 0 END) as internal_cnt, SUM(CASE WHEN link_type = 'external' THEN 1 ELSE 0 END) as external_cnt FROM {$table_name} GROUP BY post_id";
        
        // Note: $orderby and $order are whitelisted above, so they are safe to use here.
        $order_clause = "ORDER BY {$orderby} {$order}, post_id DESC";
        
        $sql = $base_query . ' ' . $order_clause . ' LIMIT %d OFFSET %d';

        // phpcs:ignore WordPress.DB.DirectDatabaseQuery, PluginCheck.Security.DirectDB.UnescapedDBParameter, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
        $total_posts_with_links = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT post_id) FROM {$table_name} WHERE 1=%d", 1 ) );
        $total_pages = $total_posts_with_links ? ceil( $total_posts_with_links / $per_page ) : 0;
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery, PluginCheck.Security.DirectDB.UnescapedDBParameter, WordPress.DB.PreparedSQL.NotPrepared
        $posts_stats = $wpdb->get_results( $wpdb->prepare( $sql, $per_page, $offset ) );
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery, PluginCheck.Security.DirectDB.UnescapedDBParameter, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
        $total_errors = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(id) FROM {$table_name} WHERE status_code >= %d", 400 ) );
        
        ?>
        <div class="wrap">
            <div style="background:#fff; padding:20px; border-left:4px solid #d63638; margin-top:20px;">
                <div style="display:flex; justify-content:space-between; align-items:center;">
                    <div>
                        <h2 style="margin-top:0;">404 Scout: Link Monitor</h2>
                        <p>Checks all internal and external links on your site for errors.<br>Total broken links found: <b style="color:#d63638;"><?php echo intval($total_errors); ?></b></p>
                    </div>
                    <div>
                        <button id="ailm-start-scout" class="button button-primary button-hero">Start Full Scan</button>
                        <button id="ailm-cancel-scout" class="button button-secondary" style="display:none;">Cancel Scan</button>
                    </div>
                </div>
                <div id="ailm-scout-progress-wrap" style="margin-top:20px; padding:15px; background:#f0f0f1; border-radius:4px;">
                    <strong id="ailm-scout-status-text">Ready to scan.</strong>
                    <div style="width:100%; background:#ccc; height:10px; border-radius:5px; margin-top:10px; overflow:hidden;"><div id="ailm-scout-bar" style="width:0%; background:#2271b1; height:100%; transition: width 0.3s;"></div></div>
                </div>
            </div>
            <div style="border: 1px solid #cce5ff; background: #e6f2ff; padding: 15px; margin-top: 20px;">
                <h3 style="margin-top:0; color: #004085;">How to Interpret This Report</h3>
                <p style="font-size:13px; color: #004085;">This table lists **Donor Posts** - these are posts and pages that **contain outgoing links**. The scanner checks these outgoing links for errors. This list is different from "Orphan Articles", which are posts that do not have any **incoming links**.</p>
            </div>
            <hr style="margin: 20px 0;">
            <div style="display:flex; justify-content:space-between; margin-bottom:10px;">
                <form method="get"><input type="hidden" name="page" value="ailinkmaster-internal-auto-manager"><input type="hidden" name="tab" value="scout"><select name="per_page" onchange="this.form.submit()"><option value="20" <?php selected($per_page, 20); ?>>20 posts</option><option value="50" <?php selected($per_page, 50); ?>>50 posts</option><option value="100" <?php selected($per_page, 100); ?>>100 posts</option></select></form>
                <?php if ( $total_pages > 1 ) : ?><div>Page <?php echo (int) $paged; ?> of <?php echo (int) $total_pages; ?> <?php if($paged > 1): ?><a href="<?php echo esc_url(add_query_arg('paged', $paged - 1)); ?>" class="button button-small">« Previous</a><?php endif; ?> <?php if($paged < $total_pages): ?><a href="<?php echo esc_url(add_query_arg('paged', $paged + 1)); ?>" class="button button-small">Next »</a><?php endif; ?></div><?php endif; ?>
            </div>

            <table class="widefat striped">
                <thead>
                    <tr>
                        <th>Source Post (Donor)</th>
                        <th class="sorted <?php echo esc_attr( $orderby === 'internal_cnt' ? strtolower($order) : '' ); ?>">
                            <a href="<?php echo esc_url($this->get_sort_link('internal_cnt', $orderby, $order)); ?>">
                                <span>Internal Links</span>
                                <span class="sorting-indicator"></span>
                            </a>
                        </th>
                        <th class="sorted <?php echo esc_attr( $orderby === 'external_cnt' ? strtolower($order) : '' ); ?>">
                             <a href="<?php echo esc_url($this->get_sort_link('external_cnt', $orderby, $order)); ?>">
                                <span>External Links</span>
                                <span class="sorting-indicator"></span>
                            </a>
                        </th>
                        <th class="sorted <?php echo esc_attr( $orderby === 'errors_count' ? strtolower($order) : '' ); ?>">
                             <a href="<?php echo esc_url($this->get_sort_link('errors_count', $orderby, $order)); ?>">
                                <span>Errors</span>
                                <span class="sorting-indicator"></span>
                            </a>
                        </th>
                        <th style="width:120px;">Details</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if ( empty( $posts_stats ) ) : ?>
                        <tr><td colspan="5">No data found. Please run a scan or refresh the page if a scan has just completed.</td></tr>
                    <?php else : foreach ( $posts_stats as $stat ) : 
                            $post_title = get_the_title( $stat->post_id ) ?: '(Untitled)';
                            $edit_link = get_edit_post_link( $stat->post_id );
                            // phpcs:ignore WordPress.DB.DirectDatabaseQuery, PluginCheck.Security.DirectDB.UnescapedDBParameter, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
                            $links = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$table_name} WHERE post_id = %d ORDER BY status_code DESC", $stat->post_id ) );
                        ?>
                        <tr>
                            <td><strong><a href="<?php echo esc_url($edit_link); ?>" target="_blank"><?php echo esc_html($post_title); ?></a></strong></td>
                            <td><?php echo (int) $stat->internal_cnt; ?></td>
                            <td><?php echo (int) $stat->external_cnt; ?></td>
                            <td><?php if ($stat->errors_count > 0): ?><span style="color:#fff; background:#d63638; padding:3px 8px; border-radius:3px; font-weight:bold; font-size:12px;"><?php echo (int) $stat->errors_count; ?> broken</span><?php else: ?><span style="color:#46b450;">All OK</span><?php endif; ?></td>
                            <td><button class="button ailm-toggle-links" data-target="links-<?php echo (int) $stat->post_id; ?>">Show Links ▾</button></td>
                        </tr>
                        <tr id="links-<?php echo (int) $stat->post_id; ?>" style="display:none; background:#f9f9f9;"><td colspan="5" style="padding:0;">
                            <table class="widefat" style="margin:0; border:none; box-shadow:none;"><thead style="background:#f1f1f1;"><tr><th>Type</th><th>URL &amp; Anchor</th><th>Status</th><th>Action</th></tr></thead>
                                <tbody><?php foreach ($links as $l): 
                                        $is_error = ($l->status_code >= 400 || $l->status_code == 500);
                                        $status_color = $is_error ? '#d63638' : ($l->status_code == 200 ? '#46b450' : '#888');
                                        $status_text = $l->status_code == 0 ? 'Pending' : $l->status_code;
                                    ?>
                                    <tr>
                                        <td style="width:100px;"><?php if($l->link_origin === 'ailm'): ?><span style="background:#826eb4; color:#fff; padding:2px 5px; border-radius:3px; font-size:11px;">AILM Auto</span><?php else: ?><span style="background:#666; color:#fff; padding:2px 5px; border-radius:3px; font-size:11px;">Manual</span><?php endif; ?></td>
                                        <td><a href="<?php echo esc_url($l->url); ?>" target="_blank" style="word-break:break-all;"><?php echo esc_html($l->url); ?></a><br><i style="color:#666;">Anchor: "<?php echo esc_html($l->anchor); ?>"</i></td>
                                        <td style="width:80px; font-weight:bold; color:<?php echo esc_attr($status_color); ?>;"><?php echo (int) $status_text; ?></td>
                                        <td style="width:150px;"><?php if($l->link_origin === 'ailm' && $is_error): ?><button class="button button-small ailm-unlink-btn" data-post="<?php echo (int) $l->post_id; ?>" data-url="<?php echo esc_attr($l->url); ?>">Remove from Pool</button><?php elseif($l->link_origin === 'manual' && $is_error): ?><a href="<?php echo esc_url($edit_link); ?>" target="_blank" class="button button-small">Edit Post</a><?php endif; ?></td>
                                    </tr>
                                    <?php endforeach; ?></tbody>
                            </table>
                        </td></tr>
                        <?php endforeach; endif; ?>
                </tbody>
            </table>
        </div>

        <script>
        jQuery(document).ready(function($) {
            var statusInterval;
            function updateStatus() {$.post(ajaxurl,{action:'ailm_scout_get_status',_ajax_nonce: '<?php echo esc_js( wp_create_nonce('ailm_scout_get_status_nonce') ); ?>'},function(res){if(!res.success){clearInterval(statusInterval);return;}var status=res.data;$('#ailm-scout-status-text').text(status.status_text);$('#ailm-scout-bar').css('width',status.percent+'%');if(status.running){$('#ailm-start-scout').prop('disabled',true).hide();$('#ailm-cancel-scout').show();}else{$('#ailm-start-scout').prop('disabled',false).show();$('#ailm-cancel-scout').hide();$('#ailm-scout-bar').css('width','100%');if(status.status_text.includes('Complete')){$('#ailm-scout-bar').css('background','#46b450');}clearInterval(statusInterval);statusInterval=null;}}); }
            if( $('#ailm-scout-status-text').length ) { statusInterval = setInterval(updateStatus, 5000); updateStatus(); }
            $('#ailm-start-scout').click(function(e) {e.preventDefault(); if(!confirm('Run a full scan in the background? You can safely leave this page.'))return; $(this).prop('disabled',true);$('#ailm-scout-bar').css('width','0%').css('background','#2271b1');$('#ailm-scout-status-text').text('Starting scan...'); $.post(ajaxurl,{action:'ailm_scout_start_scan',_ajax_nonce: '<?php echo esc_js( wp_create_nonce('ailm_scout_start_scan_nonce') ); ?>'},function(res){if(res.success){if(!statusInterval){statusInterval=setInterval(updateStatus,5000);}updateStatus();}else{$('#ailm-scout-status-text').text('Failed to start scan.');}}); });
            $('#ailm-cancel-scout').click(function(e) {e.preventDefault(); if(!confirm('Cancel the scan?'))return; $(this).prop('disabled',true).text('Cancelling...'); $.post(ajaxurl,{action:'ailm_scout_cancel_scan',_ajax_nonce: '<?php echo esc_js( wp_create_nonce('ailm_scout_cancel_scan_nonce') ); ?>'},function(res){updateStatus();}); });
            $('.ailm-toggle-links').click(function(e) {e.preventDefault(); $('#' + $(this).data('target')).toggle(); });
            $('.ailm-unlink-btn').click(function(e) {e.preventDefault(); if(!confirm('Remove this broken link from the plugin\'s pool?'))return; var btn=$(this);btn.prop('disabled',true).text('Removing...'); $.post(ajaxurl,{action:'ailm_scout_unlink',post_id:btn.data('post'),url:btn.data('url'),_ajax_nonce: '<?php echo esc_js( wp_create_nonce('ailm_scout_unlink_nonce') ); ?>'}).done(function(res){if(res.success){btn.closest('tr').fadeOut('fast');}else{alert('Error: '+(res.data||'Unknown error'));btn.prop('disabled',false).text('Remove from Pool');}}).fail(function(){alert('Network error.');btn.prop('disabled',false).text('Remove from Pool');}); });
        });
        </script>
        <?php
    }
}