<?php
/**
 * AWBSEO Uninstall
 *
 * Runs when the user clicks "Delete" in the Plugins screen.
 * Removes all plugin data from the database.
 *
 * WordPress requires uninstall.php to be a separate file (not a hook)
 * to ensure it only runs on intentional deletion, not deactivation.
 */

// Only run when WordPress calls this directly during plugin deletion.
if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
    exit;
}

global $wpdb;

// ── Options ───────────────────────────────────────────────────────────────────
// Option names use the awbseo_ prefix (6 chars) as required by WordPress.org.
// requirement. These are NOT renamed to awbseo_ because doing so would silently
// delete all user settings on plugin update.
$options = [
    'awbseo_arabic',
    'awbseo_local_db_version',
    // Core settings
    'awbseo_settings',
    'awbseo_db_version',

    // GSC - real option names from AWBSEO_GSC constants
    'awbseo_gsc_tokens',    // AWBSEO_GSC::OPTION_TOKENS
    'awbseo_gsc_property',  // AWBSEO_GSC::OPTION_PROPERTY

    // GA4 - real option names from AWBSEO_GA4 constants
    'awbseo_ga4_tokens',    // AWBSEO_GA4::OPTION_TOKENS
    'awbseo_ga4_property',  // AWBSEO_GA4::OPTION_PROPERTY

    // Bing - real option names from AWBSEO_Bing constants
    'awbseo_bing_api_key',  // AWBSEO_Bing::OPTION_API_KEY
    'awbseo_bing_property',   // AWBSEO_Bing::OPTION_PROPERTY
    'awbseo_bing_all_sites',  // AWBSEO_Bing::OPTION_ALL_SITES

    // Rank tracker - real option name from AWBSEO_Rank_Tracker::OPTION_KEYWORDS
    'awbseo_tracked_keywords',

    // Setup wizard - real option names from AWBSEO_Setup_Wizard constants
    'awb_setup_wizard_pending', // AWBSEO_Setup_Wizard::OPTION_PENDING
    'awb_setup_wizard_done',    // AWBSEO_Setup_Wizard::OPTION_DONE

    // Upgrade prompts - AWBSEO_Upgrade_Prompts::DISMISS_OPTION
    'awbseo_pro_notice_dismissed',

    // Robots.txt - AWBSEO_Robots_Txt::OPTION_KEY
    'awbseo_robots_txt',

    // WooCommerce SEO - AWBSEO_Woocommerce_SEO::OPTION_SETTINGS
    'awbseo_woo_settings',

    // Hreflang pairs (stored directly via option name)
    'awbseo_hreflang_pairs',

    // Instant Indexing - AWBSEO_Instant_Indexing constants
    'awbseo_indexnow_key',   // OPT_KEY
    'awbseo_indexnow_log',   // OPT_LOG
    'awbseo_indexnow_auto',  // OPT_AUTO

    // Broken link scanner - AWBSEO_Broken_Links::OPT_AUTO
    'awbseo_bls_auto',
];
foreach ( $options as $opt ) {
    delete_option( $opt );
}

// ── Transients - bulk delete via LIKE pattern ──────────────────────────────────
// Individual delete_transient() calls can't cover dynamically-hashed keys;
// LIKE queries remove all of them in one pass.
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery
    "DELETE FROM {$wpdb->options}
     WHERE option_name LIKE '\_transient\_awbseo\_%'
        OR option_name LIKE '\_transient\_timeout\_awbseo\_%'"
);

// ── Custom tables ─────────────────────────────────────────────────────────────
$tables = [
    $wpdb->prefix . 'awb_redirects',
    $wpdb->prefix . 'awb_broken_links',
    $wpdb->prefix . 'awb_rank_history',
    $wpdb->prefix . 'awb_local_seo',
];
foreach ( $tables as $table ) {
    $wpdb->query( "DROP TABLE IF EXISTS `{$table}`" ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
}

// ── Post meta ─────────────────────────────────────────────────────────────────
$meta_keys = [
    '_awb_seo_title',
    '_awb_seo_description',
    '_awb_seo_focus_keyword',
    '_awb_seo_robots_index',
    '_awb_seo_robots_follow',
    '_awb_seo_noindex',
    '_awb_seo_nofollow',
    '_awb_seo_canonical',
    '_awb_seo_og_title',
    '_awb_seo_og_description',
    '_awb_seo_og_image',
    '_awb_seo_twitter_title',
    '_awb_seo_twitter_desc',
    '_awb_seo_twitter_image',
    '_awb_seo_schema',
    '_awb_seo_schema_type',
    '_awb_seo_schema_data',
    '_awb_seo_schema_fields',
    '_awb_seo_ar_quality',
    '_awb_seo_score',
    '_awb_seo_issues',
    '_awb_seo_failed_checks',
];
foreach ( $meta_keys as $key ) {
    $wpdb->delete( $wpdb->postmeta, [ 'meta_key' => $key ] ); // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_key
}

// Allow Pro plugin to clean up its own data on uninstall.
do_action( 'awbseo_uninstall' );