<?php
/**
 * Uninstall: leaves nothing of the plugin behind.
 *
 *   1. Revokes a YOM Connect install (its keys stop working in YOM at once).
 *   2. Deletes the settings, the delivery status and the plugin's transients.
 *   3. Unschedules queued deliveries (Action Scheduler and WP-Cron).
 *   4. Deletes the plugin's order meta (`_yomanalytics_purchase_sent`, `_yomanalytics_consent`) from both order
 *      stores, in batches: the HPOS meta table and the posts meta table (legacy storage and the
 *      HPOS compatibility-mode copy). Direct SQL because WooCommerce may be inactive here and a
 *      large store can have millions of orders; nothing else reads these keys.
 *
 * @package YOMAnalytics
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

global $wpdb;

$yomanalytics_settings = get_option( 'yomanalytics_settings', array() );
$yomanalytics_settings = is_array( $yomanalytics_settings ) ? $yomanalytics_settings : array();

// 1. Revoke the Connect install with its own secret key (best effort, short timeout).
if ( ! empty( $yomanalytics_settings['install_id'] ) && ! empty( $yomanalytics_settings['secret_key_sealed'] ) ) {
	require_once __DIR__ . '/includes/class-yomanalytics-settings.php';
	require_once __DIR__ . '/includes/class-yomanalytics-client.php';
	YOMAnalytics_Client::connect_revoke( (string) $yomanalytics_settings['install_id'], YOMAnalytics_Settings::unseal( (string) $yomanalytics_settings['secret_key_sealed'] ), 5 );
}

// 2. Options and transients.
delete_option( 'yomanalytics_settings' );
delete_option( 'yomanalytics_status' );
delete_transient( 'yomanalytics_test_result' );
$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- per-user transients have no list API; one-off cleanup.
	$wpdb->prepare(
		"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
		$wpdb->esc_like( '_transient_yomanalytics_' ) . '%',
		$wpdb->esc_like( '_transient_timeout_yomanalytics_' ) . '%'
	)
);

// 3. Queued deliveries would otherwise run (and fail) after the plugin is gone.
if ( function_exists( 'as_unschedule_all_actions' ) ) {
	as_unschedule_all_actions( 'yomanalytics_send' );
}
wp_unschedule_hook( 'yomanalytics_send' );

// 4. Order meta, batched, in every table WooCommerce may keep order meta in.
$yomanalytics_meta_tables = array( $wpdb->postmeta );
$yomanalytics_hpos_meta   = $wpdb->prefix . 'wc_orders_meta';
if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $yomanalytics_hpos_meta ) ) ) === $yomanalytics_hpos_meta ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- one-off check at uninstall.
	$yomanalytics_meta_tables[] = $yomanalytics_hpos_meta;
}
foreach ( $yomanalytics_meta_tables as $yomanalytics_table ) {
	do {
		$yomanalytics_deleted = $wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- batched one-off cleanup.
			$wpdb->prepare(
				'DELETE FROM %i WHERE meta_key IN (%s, %s) LIMIT %d',
				$yomanalytics_table,
				'_yomanalytics_purchase_sent',
				'_yomanalytics_consent',
				1000
			)
		);
	} while ( $yomanalytics_deleted > 0 );
}
if ( function_exists( 'wp_cache_flush_group' ) ) {
	wp_cache_flush_group( 'orders' );
}