<?php
declare(strict_types=1);

// block direct invocation outside WordPress uninstallation lifecycle
if (!defined('WP_UNINSTALL_PLUGIN')) {
	exit;
}

global $wpdb;

// remove Finlyzer events tables
$fxli_events_table = $wpdb->prefix . 'fxli_fx_events';
$fxli_products_table = $wpdb->prefix . 'fxli_product_gateway_events';

// phpcs:disable WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', $fxli_events_table));

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', $fxli_products_table));
// phpcs:enable WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching

// delete all Finlyzer and FXLI options and state settings
delete_option('finlyzer_db_version');
delete_option('fxli_db_version');
delete_option('finlyzer_order_state_version');
delete_option('finlyzer_telemetry_logs');
delete_option('finlyzer_worker_hmac_secret_encrypted');
delete_option('finlyzer_worker_hmac_secret');
delete_option('finlyzer_cloud_opt_in');
delete_option('finlyzer_site_id');
delete_option('finlyzer_worker_endpoint');

// unschedule daily scanner cron
wp_clear_scheduled_hook('fxli_daily_scan');

// purge all Finlyzer database options and cached transients
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$wpdb->query(
	"DELETE FROM {$wpdb->options}
	 WHERE option_name LIKE 'finlyzer\\_%'
	    OR option_name LIKE 'fxli\\_%'
	    OR option_name LIKE '\\_transient\\_finlyzer\\_%'
	    OR option_name LIKE '\\_transient\\_timeout\\_finlyzer\\_%'
	    OR option_name LIKE '\\_transient\\_fxli\\_%'
	    OR option_name LIKE '\\_transient\\_timeout\\_fxli\\_%'"
);