<?php
/**
 * Cleanup when the plugin is deleted.
 *
 * Two rules apply to this file:
 *
 *   1. WordPress includes it directly and does NOT load mybot.php first. Every constant used
 *      here must come from a file that can be loaded on its own — mybot-constants.php — or it
 *      is an undefined constant, which is a fatal error on PHP 8.
 *   2. Nothing in here may throw. An uncaught error stops WordPress before it removes the
 *      files, so the plugin stays on disk and cannot be deleted from the admin at all.
 *
 * @package AI House
 */

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

require_once __DIR__ . '/mybot-constants.php';

/**
 * Deletes AI House data for a single site.
 *
 * @return void
 */
function mybot_uninstall_site() {
	global $wpdb;

	// Everything after this point touches the database, so it is guarded as a group: a broken
	// table or a missing privilege must not stop the plugin from being removed.
	try {
		$options = array(
			MYBOT_OPTION_KEY,
			MYBOT_DB_VERSION_OPTION,
			MYBOT_CONTENT_DEFAULTS_OPTION,
			MYBOT_INDEX_STATE_OPTION,
			MYBOT_DEGRADED_OPTION,
			MYBOT_RAG_TRACE_OPTION,
			MYBOT_SUPPORT_TRACE_OPTION,
			// 1.10.0 removed MYBOT_LOCK_NOTICE_OPTION; the literal outlives the constant so that a
			// site upgrading from 1.9.x still has that row cleaned out of wp_options.
			'mybot_lock_notice',
		);

		foreach ( $options as $option ) {
			delete_option( $option );
		}

		$transients = array(
			MYBOT_INDEX_PROGRESS_TRANSIENT,
			MYBOT_BUDGET_TRANSIENT,
		);

		foreach ( $transients as $transient ) {
			delete_transient( $transient );
		}

		/*
		 * Model lists are cached per provider and per filter, so there is no fixed list of
		 * names to delete. Sweep by prefix instead.
		 *
		 * The second prefix is the one used up to 1.3.7, before the provider became part of the
		 * key. Transients do expire on their own after six hours, but leaving rows behind in
		 * wp_options after an uninstall is exactly the kind of half-cleanup that made the
		 * plugin impossible to remove in 1.3.1.
		 */
		foreach ( array( MYBOT_MODELS_TRANSIENT, 'mybot_openrouter_models_' ) as $prefix ) {
			$names = $wpdb->get_col(
				$wpdb->prepare(
					"SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s",
					$wpdb->esc_like( '_transient_' . $prefix ) . '%'
				)
			);

			foreach ( (array) $names as $name ) {
				delete_transient( substr( $name, strlen( '_transient_' ) ) );
			}
		}

		$tables = array(
			$wpdb->prefix . 'mybot_messages',
			$wpdb->prefix . 'mybot_ratelimit',
			$wpdb->prefix . 'mybot_queue',
			$wpdb->prefix . 'mybot_cache',
			// Questions left for a human. Removed with the plugin: they hold visitor contact
			// details, and leaving personal data behind after an uninstall is not a tidy default.
			$wpdb->prefix . 'mybot_requests',
			// The visitor cards (1.17.0). Same reason, and a stronger one: this table is nothing
			// BUT personal data — a name, a phone number, an email address and the sentence the
			// visitor agreed to. It is dropped first in spirit and in fact.
			$wpdb->prefix . 'mybot_contacts',
		);

		foreach ( $tables as $table ) {
			// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.NotPrepared
			$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i', $table ) );
		}

		// Indexing fingerprints. The knowledge posts themselves are kept on purpose: they are
		// content the site owner may want to keep, and docs/08 explains how to remove them.
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
		$wpdb->delete( $wpdb->postmeta, array( 'meta_key' => MYBOT_INDEX_HASH_META ) );
	} catch ( Throwable $error ) {
		// Report to the PHP log and carry on: deletion must still succeed.
		// phpcs:ignore WordPress.PHP.DevelopmentFunctions.error_log_error_log
		error_log( 'AI House uninstall: ' . $error->getMessage() );
	}
}

if ( is_multisite() ) {
	$mybot_site_ids = get_sites( array( 'fields' => 'ids' ) );

	foreach ( $mybot_site_ids as $mybot_site_id ) {
		switch_to_blog( $mybot_site_id );
		mybot_uninstall_site();
		restore_current_blog();
	}
} else {
	mybot_uninstall_site();
}