<?php
/**
 * Runs when the plugin is deleted from the Plugins screen.
 *
 * WordPress includes this file on its own: the main plugin file has not been
 * loaded (the plugin is deactivated) and WooCommerce may be active or not. So
 * everything here is standalone. First it tells CommercePing (best effort, short
 * timeout, any failure is swallowed), then it removes the plugin's options,
 * transients, tables and scheduled work by explicit name, independent of whether
 * the notification worked. Order notes and confirmation meta already written to
 * orders are the merchant's order history and are kept.
 *
 * When a new option, table or scheduled hook is added to the plugin, add it to the
 * lists in orderping_uninstall_cleanup() (tests/uninstall-test.mjs fails on leftovers).
 *
 * @package OrderPing
 */

if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
	exit;
}

if ( ! defined( 'ORDERPING_DIR' ) ) {
	define( 'ORDERPING_DIR', plugin_dir_path( __FILE__ ) );
}
if ( ! defined( 'ORDERPING_CONTRACT_VERSION' ) ) {
	define( 'ORDERPING_CONTRACT_VERSION', 1 );
}
if ( ! defined( 'ORDERPING_VERSION' ) ) {
	define( 'ORDERPING_VERSION', 'uninstall' );
}
if ( ! defined( 'ORDERPING_FILE' ) ) {
	define( 'ORDERPING_FILE', __FILE__ );
}

/**
 * Tells the backend the site is gone. Never throws, never blocks the cleanup.
 */
function orderping_uninstall_notify() {
	try {
		if ( ! function_exists( 'orderping_send_disconnect' ) ) {
			foreach ( array( 'signature', 'connection', 'outbox', 'disconnect' ) as $include ) {
				$file = ORDERPING_DIR . 'includes/' . $include . '.php';
				if ( file_exists( $file ) ) {
					require_once $file;
				}
			}
		}
		if ( function_exists( 'orderping_send_disconnect' ) && function_exists( 'orderping_connection' ) && function_exists( 'orderping_sign' ) && function_exists( 'orderping_backend_url' ) ) {
			orderping_send_disconnect( 'uninstalled' );
		}
	} catch ( \Throwable $e ) { // phpcs:ignore Generic.CodeAnalysis.EmptyStatement
		// Best effort only: the cleanup below must always run.
	}
}

/**
 * Removes every option, transient, table and scheduled hook the plugin creates.
 */
function orderping_uninstall_cleanup() {
	global $wpdb;

	$hooks = array( 'orderping_deliver_event', 'orderping_sweep_outbox', 'orderping_emit_order_updated', 'orderping_retry_revoke', 'orderping_prune_nonces' );
	foreach ( $hooks as $hook ) {
		try {
			if ( function_exists( 'as_unschedule_all_actions' ) ) {
				as_unschedule_all_actions( $hook );
			}
		} catch ( \Throwable $e ) { // phpcs:ignore Generic.CodeAnalysis.EmptyStatement
			// Action Scheduler not ready: the direct clean-up below covers it.
		}
		wp_unschedule_hook( $hook );
		wp_clear_scheduled_hook( $hook );
	}

	// Action Scheduler rows (also when WooCommerce is inactive and its API is not loaded).
	// Names are the plugin's own fixed tables and $wpdb->prefix, never user input.
	// phpcs:disable WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
	$as_actions = $wpdb->prefix . 'actionscheduler_actions';
	$as_logs    = $wpdb->prefix . 'actionscheduler_logs';
	if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $as_actions ) ) ) === $as_actions ) {
		$in = "'" . implode( "','", array_map( 'esc_sql', $hooks ) ) . "'";
		if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $as_logs ) ) ) === $as_logs ) {
			$wpdb->query( "DELETE FROM {$as_logs} WHERE action_id IN ( SELECT action_id FROM {$as_actions} WHERE hook IN ( {$in} ) )" );
		}
		$wpdb->query( "DELETE FROM {$as_actions} WHERE hook IN ( {$in} )" );
	}

	foreach ( array( 'orderping_nonces', 'orderping_outbox', 'orderping_confirmation', 'orderping_confirm_action', 'orderping_cancel_action' ) as $table ) {
		$wpdb->query( 'DROP TABLE IF EXISTS `' . $wpdb->prefix . $table . '`' );
	}

	$options = array(
		'orderping_connection',
		'orderping_instance_id',
		'orderping_pairing',
		'orderping_db_version',
		'orderping_pending_revoke',
		'orderping_update_required',
		'orderping_plugin_version',
		'orderping_account_email',
		'orderping_pilot_phone', // "Limit to one phone number".
	);
	foreach ( $options as $option ) {
		delete_option( $option );
		delete_site_option( $option );
	}

	// Transients: the one-time activation redirect and the per-user "settings error" notes.
	delete_transient( 'orderping_activation_redirect' );
	$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient_orderping_' ) . '%', $wpdb->esc_like( '_transient_timeout_orderping_' ) . '%' ) );
	// phpcs:enable
}

orderping_uninstall_notify();
orderping_uninstall_cleanup();