<?php
/**
 * Uninstall routine.
 *
 * Runs only when the site owner deletes the plugin, and only does anything if they asked for their
 * data to go with it. Deleting quietly by default would mean an accidental delete-and-reinstall
 * costs a site its credentials and its unreported orders.
 *
 * @package AdPix\Analytics
 */

declare( strict_types = 1 );

// Only WordPress may run this file, and only as part of a real uninstall.
defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

/**
 * Remove everything this plugin stored on the current site.
 *
 * @return void
 */
function adpix_analytics_uninstall_site() {
	global $wpdb;

	$settings = get_option( 'adpix_analytics_settings' );

	if ( ! is_array( $settings ) || empty( $settings['delete_on_uninstall'] ) ) {
		return;
	}

	foreach ( array( 'adpix_analytics_settings', 'adpix_analytics_queue', 'adpix_analytics_log', 'adpix_analytics_version', 'adpix_analytics_mode' ) as $option ) {
		delete_option( $option );
	}

	delete_metadata( 'user', 0, 'adpix_analytics_setup_dismissed', '', true );

	wp_clear_scheduled_hook( 'adpix_analytics_drain' );

	// Action Scheduler owns its own storage, so its own API is the only correct way to withdraw what
	// this plugin put there. When it is not installed there is nothing of ours in it.
	if ( function_exists( 'as_unschedule_all_actions' ) ) {
		as_unschedule_all_actions( 'adpix_analytics_deliver', array(), 'adpix-analytics' );
	}

	// The checkout context and the sent marker are the plugin's own order meta.
	if ( function_exists( 'delete_post_meta_by_key' ) ) {
		delete_post_meta_by_key( '_adpix_visitor' );
		delete_post_meta_by_key( '_adpix_sent' );
	}

	// The same two keys again, for stores whose orders live in WooCommerce's own tables rather than
	// in posts. There is no meta API that spans both, and leaving them behind would mean an
	// uninstall the owner asked for did not finish.
	$orders_meta = $wpdb->prefix . 'wc_orders_meta';
	$exists      = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $orders_meta ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery

	if ( $orders_meta === $exists ) {
		foreach ( array( '_adpix_visitor', '_adpix_sent' ) as $key ) {
			$wpdb->delete( $orders_meta, array( 'meta_key' => $key ), array( '%s' ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.SlowDBQuery
		}
	}

	// Cached attribution lookups. Named with a shared prefix precisely so they can be found again.
	$wpdb->query( // phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL.NotPrepared
		$wpdb->prepare(
			"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
			$wpdb->esc_like( '_transient_adpix_attr_' ) . '%',
			$wpdb->esc_like( '_transient_timeout_adpix_attr_' ) . '%'
		)
	);

	wp_cache_flush();
}

if ( is_multisite() ) {
	$adpix_sites = get_sites(
		array(
			'fields' => 'ids',
			'number' => 0,
		)
	);

	foreach ( $adpix_sites as $adpix_site_id ) {
		switch_to_blog( (int) $adpix_site_id );
		adpix_analytics_uninstall_site();
		restore_current_blog();
	}

	unset( $adpix_sites, $adpix_site_id );
} else {
	adpix_analytics_uninstall_site();
}