<?php
/**
 * Fired when the plugin is uninstalled.
 *
 * @package AIExplainerPro
 * @since   1.1.0
 */

if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
    die;
}

global $wpdb;

// 1. Delete all plugin options.
$aiep_uninstall_options = [
    'ai_explainer_pro_version',
    'ai_explainer_pro_activated',
    'ai_explainer_pro_show_badges',
    'ai_explainer_pro_detection_threshold',
    'ai_explainer_pro_badge_position',
    
    'ai_explainer_pro_show_on_posts',
    'ai_explainer_pro_show_on_pages',
    'ai_explainer_pro_show_on_home',
    'ai_explainer_pro_show_on_archive',
    'ai_explainer_pro_show_human_badge',
    'ai_explainer_pro_show_ai_badge',
    'ai_explainer_pro_badge_template',
    'ai_explainer_pro_badge_human_color',
    'ai_explainer_pro_badge_ai_color',
    'ai_explainer_pro_badge_uncertain_color',
    'ai_explainer_pro_badge_human_text',
    'ai_explainer_pro_badge_ai_text',
    'ai_explainer_pro_badge_uncertain_text',
    'ai_explainer_pro_api_provider',
    'ai_explainer_pro_detection_api_key',
    'ai_explainer_pro_custom_api_url',
    'ai_explainer_pro_exclude_categories',
    'ai_explainer_pro_exclude_authors',
    'ai_explainer_pro_report_email',
    'ai_explainer_pro_report_frequency',
    'ai_explainer_pro_last_report_sent',
    'ai_explainer_pro_certificates',
    
    'aiep_explainer_settings',
    'aiep_general_settings',
    'ai_explainer_pro_usage_stats',
    'ai_explainer_pro_auto_disclosure',
    'ai_explainer_pro_disclosure_threshold',
    'ai_explainer_pro_disclosure_text',
    'aiep_auto_disclosure',
    'aiep_disclosure_threshold',
    'aiep_disclosure_text',
    'aiep_exclude_categories',
    'aiep_exclude_authors',
    'aiep_report_email',
    'aiep_report_frequency',
    'aiep_last_report_sent',
    'aiep_certificates',
    // Trust & Authenticity Suite (2.2.0+).
    'aiep_scraper_defense_enabled',
    'aiep_scraper_stats',
    'aiep_timestamps_enabled',
    'aiep_authenticity_enabled',
    'aiep_authenticity_slug',
    'aiep_agency_children',
    'aiep_agency_parent',
    'aiep_first_activation_done',
    // Pro 2.3.0+ (Trust & Authenticity Suite expansion).
    'aiep_audit_secret',
    'aiep_audit_log_installed_at',
    'aiep_audit_retention_days',
    'aiep_api_keys_installed_at',
    'aiep_cert_secret',
    'aiep_certificates',
    'aiep_htaccess_backup',
    'aiep_htaccess_deployed_at',
    'aiep_provenance_jsonld_enabled',
    'aiep_provenance_claim_enabled',
    'aiep_brand_name',
    'aiep_brand_logo_url',
    'aiep_brand_primary_color',
    'aiep_brand_support_email',
    
];

foreach ( $aiep_uninstall_options as $aiep_uninstall_opt ) {
    delete_option( $aiep_uninstall_opt );
}

// 2. Delete all post meta created by the plugin.
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall cleanup: must run once at uninstall time, caching is irrelevant.
$wpdb->query( "DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE '_ai_explainer%'" );

// 3. Drop custom database tables.
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Uninstall cleanup: schema change is the goal.
$wpdb->query( "DROP TABLE IF EXISTS {$wpdb->prefix}ai_explainer_scan_history" );
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Uninstall cleanup: schema change is the goal.
$wpdb->query( "DROP TABLE IF EXISTS {$wpdb->prefix}ai_explainer_history" );
// Pro 2.3.0+ tables (audit log + API keys).
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Uninstall cleanup.
$wpdb->query( "DROP TABLE IF EXISTS {$wpdb->prefix}aiep_audit_log" );
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Uninstall cleanup.
$wpdb->query( "DROP TABLE IF EXISTS {$wpdb->prefix}aiep_api_keys" );

// 3b. Unschedule cron events.
$aiep_cron_hooks = [ 'aiep_audit_log_purge', 'aiep_email_report_event', 'aiep_weekly_rescan' ];
foreach ( $aiep_cron_hooks as $aiep_hook ) {
    // phpcs:ignore Generic.CodeAnalysis.AssignmentInCondition.FoundInWhileCondition -- Intentional: unschedule every remaining occurrence of the hook by polling wp_next_scheduled() until it returns false.
    while ( $aiep_ts = wp_next_scheduled( $aiep_hook ) ) {
        wp_unschedule_event( $aiep_ts, $aiep_hook );
    }
}

// 4. Clean transients.
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall cleanup of plugin transients.
$wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '%_transient_aiep_%'" );
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall cleanup of plugin transients.
$wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '%_transient_timeout_aiep_%'" );

// 5. Clear scheduled cron events.

wp_clear_scheduled_hook( 'aiep_send_email_report' );

// 6. Remove user meta (dismissed notices).
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall cleanup of plugin user meta.
$wpdb->query( "DELETE FROM {$wpdb->usermeta} WHERE meta_key LIKE 'aiep_%'" );