<?php
/**
 * Removes Llamly Free data when the plugin is deleted, only if the administrator enabled data removal.
 * Leaves the options of earlier experimental Llamly builds (llamly_mcp_spike_*) untouched.
 */

declare(strict_types=1);

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Llamly reads and writes its own tables and locks WordPress rows inside journal transactions; a cached read would defeat the revision checks.
// phpcs:disable WordPress.DB.DirectDatabaseQuery.SchemaChange -- creates, upgrades, backs up or drops only Llamly tables ({prefix}llamly_free_*).

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

if (!defined('LLAMLY_FREE_ROOT')) {
	$llamlyFreeRoot = is_file(__DIR__ . '/src/Free/Core/Autoloader.php') ? __DIR__ : dirname(__DIR__);
	define('LLAMLY_FREE_ROOT', $llamlyFreeRoot);
}
require_once LLAMLY_FREE_ROOT . '/src/Free/Core/Autoloader.php';
\Llamly\Free\Core\Autoloader::register();

$llamlyFreeUninstallSite = static function (): void {
	global $wpdb;

	wp_clear_scheduled_hook('llamly_free_daily_maintenance');
	// Unfinished uploads in parts are temporary files, never site data: always removed.
	wp_unschedule_hook(\Llamly\Free\Tools\MediaParts::HOOK_EXPIRE);
	\Llamly\Free\Tools\MediaParts::purgeAll();
	// Data is preserved unless an administrator explicitly enabled removal in Settings.
	$settings = get_option('llamly_free_settings', []);
	if (!is_array($settings) || ($settings['delete_data_on_uninstall'] ?? false) !== true) {
		return;
	}

	foreach (\Llamly\Free\Core\Schema::tableNames() as $table) {
		$wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', $table));
		$backups = $wpdb->get_col($wpdb->prepare('SHOW TABLES LIKE %s', $wpdb->esc_like($table . '_bak_v') . '%'));
		foreach ((array) $backups as $backup) {
			$wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', (string) $backup));
		}
	}

	// Tables of features that left the plugin, if an upgrade did not drop them yet.
	\Llamly\Free\Core\Schema::dropRetired();

	// Media retention copies (uploads/llamly-mcp/). Their index rows (llamly_free_mret_*) go with the options below.
	$llamlyFreeUploads = wp_upload_dir(null, false);
	$llamlyFreeBase = realpath((string) ($llamlyFreeUploads['basedir'] ?? ''));
	$llamlyFreeDir = $llamlyFreeBase ? realpath($llamlyFreeBase . '/llamly-mcp') : false;
	if ($llamlyFreeBase && $llamlyFreeDir && strpos($llamlyFreeDir, $llamlyFreeBase . DIRECTORY_SEPARATOR) === 0 && is_dir($llamlyFreeDir) && !is_link($llamlyFreeDir)) {
		$llamlyFreeItems = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($llamlyFreeDir, FilesystemIterator::SKIP_DOTS), RecursiveIteratorIterator::CHILD_FIRST);
		foreach ($llamlyFreeItems as $llamlyFreeItem) {
			if ($llamlyFreeItem->isDir() && !$llamlyFreeItem->isLink()) {
				\Llamly\Free\Core\Filesystem::direct()->rmdir($llamlyFreeItem->getPathname());
			} else {
				wp_delete_file($llamlyFreeItem->getPathname());
			}
		}
		\Llamly\Free\Core\Filesystem::direct()->rmdir($llamlyFreeDir);
	}

	$like = $wpdb->esc_like('llamly_free_') . '%';
	$timeout = $wpdb->esc_like('_transient_timeout_llamly_free_') . '%';
	$transient = $wpdb->esc_like('_transient_llamly_free_') . '%';
	$siteTimeout = $wpdb->esc_like('_site_transient_timeout_llamly_free_') . '%';
	$siteTransient = $wpdb->esc_like('_site_transient_llamly_free_') . '%';
	$wpdb->query($wpdb->prepare(
		"DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s",
		$like,
		$timeout,
		$transient,
		$siteTimeout,
		$siteTransient
	));
	$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->usermeta} WHERE meta_key LIKE %s", $like));

	wp_clear_scheduled_hook('llamly_free_daily_maintenance');
	wp_cache_flush();
};

if (is_multisite()) {
	foreach (get_sites(['fields' => 'ids', 'number' => 0]) as $llamlyFreeBlogId) {
		switch_to_blog((int) $llamlyFreeBlogId);
		$llamlyFreeUninstallSite();
		restore_current_blog();
	}
	global $wpdb;
	$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->sitemeta} WHERE meta_key LIKE %s", $wpdb->esc_like('llamly_free_') . '%'));
} else {
	$llamlyFreeUninstallSite();
}