<?php
/**
 * Uninstall AI Semantic Handshake.
 *
 * @package AI_Semantic_Handshake
 */

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

global $wpdb;
$aish_wpdb = $wpdb;

$aish_delete_data = get_option( 'aish_delete_data_on_uninstall', null );
if ( null === $aish_delete_data ) {
	// Carbon Fields / legacy installs may store underscored option keys.
	$aish_delete_data = get_option( '_aish_delete_data_on_uninstall', false );
}

if ( ! $aish_delete_data ) {
	return;
}

if ( ! isset( $aish_wpdb->options ) ) {
	return;
}

$aish_patterns = array(
	'aish_%',
	'_aish_%',
	'_transient_aish_%',
	'_transient_timeout_aish_%',
	'_site_transient_aish_%',
	'_site_transient_timeout_aish_%',
);

foreach ( $aish_patterns as $aish_pattern ) {
	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Wildcard option cleanup for plugin-owned keys.
	$aish_wpdb->query(
		$aish_wpdb->prepare(
			"DELETE FROM {$aish_wpdb->options} WHERE option_name LIKE %s",
			$aish_pattern
		)
	);
}

if ( function_exists( 'wp_clear_scheduled_hook' ) ) {
	wp_clear_scheduled_hook( 'aish_daily_verification' );
	wp_clear_scheduled_hook( 'aish_retry_pending_sync' );
}

if ( is_multisite() && isset( $aish_wpdb->sitemeta ) ) {
	foreach ( array( '_site_transient_aish_%', '_site_transient_timeout_aish_%' ) as $aish_pattern ) {
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Wildcard site transient cleanup for plugin-owned keys.
		$aish_wpdb->query(
			$aish_wpdb->prepare(
				"DELETE FROM {$aish_wpdb->sitemeta} WHERE meta_key LIKE %s",
				$aish_pattern
			)
		);
	}
}