<?php
/**
 * Uninstall script for Aegilock WooCommerce Fraud Prevention
 *
 * @package AegilockWooCommerce
 */

// If uninstall not called from WordPress, exit
if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
    exit;
}

// Remove plugin options
delete_option( 'aegilock_wc_settings' );
delete_option( 'aegilock_wizard_completed' );
delete_option( 'aegilock_tg_version' );
delete_option( 'aegilock_tg_active' );
delete_option( 'aegilock_tg_activated_at' );
delete_option( 'aegilock_tg_db_ready' );
delete_option( 'aegilock_tg_db_version' );

// Remove WooCommerce settings
$wc_settings = array(
    'aegilock_enabled',
    'aegilock_api_key',
    'aegilock_fraud_threshold',
    'aegilock_test_mode',
    'aegilock_block_high_risk',
    'aegilock_hold_medium_risk',
    'aegilock_email_alerts',
    'aegilock_alert_email',
);

foreach ( $wc_settings as $setting ) {
    delete_option( $setting );
}

// Remove transients
global $wpdb;

// Clean up all aegilock transients
$wpdb->query(
    $wpdb->prepare(
        "DELETE FROM {$wpdb->options} 
        WHERE option_name LIKE %s 
        OR option_name LIKE %s",
        '%_transient_aegilock_%',
        '%_transient_timeout_aegilock_%'
    )
);

// Drop custom database tables
$tables_to_drop = array(
    $wpdb->prefix . 'aegilock_wc_fraud_logs',
    $wpdb->prefix . 'aegilock_wc_stats',
);

foreach ( $tables_to_drop as $table ) {
    // Escape table name for security - table names can't use prepare() placeholders in WP < 6.2
    $escaped_table = esc_sql( $table );
    $wpdb->query( "DROP TABLE IF EXISTS `{$escaped_table}`" );
}

// Clear scheduled events
wp_clear_scheduled_hook( 'aegilock_wc_daily_cleanup' );

// Remove order meta data
$wpdb->query(
    $wpdb->prepare(
        "DELETE FROM {$wpdb->postmeta}
        WHERE meta_key LIKE %s",
        '%_aegilock_%'
    )
);

// Remove user meta data (dismissed notices, etc)
$wpdb->query(
    $wpdb->prepare(
        "DELETE FROM {$wpdb->usermeta}
        WHERE meta_key LIKE %s",
        '%aegilock%'
    )
);

// Remove ALL remaining aegilock options (catch-all)
$wpdb->query(
    $wpdb->prepare(
        "DELETE FROM {$wpdb->options}
        WHERE option_name LIKE %s",
        '%aegilock%'
    )
);

// Clear any cached data
wp_cache_flush();

// Remove upload directory if exists
$upload_dir = wp_upload_dir();
$plugin_upload_dir = $upload_dir['basedir'] . '/aegilock';
if ( is_dir( $plugin_upload_dir ) ) {
    // Use WP_Filesystem for directory operations
    require_once ABSPATH . 'wp-admin/includes/file.php';
    WP_Filesystem();
    global $wp_filesystem;
    
    if ( $wp_filesystem ) {
        $wp_filesystem->rmdir( $plugin_upload_dir, true );
    }
}