<?php
/**
 * Remove owned state only; merchant catalog and descriptions are preserved.
 *
 * @package Selectika
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

global $wpdb;
foreach ( array( 'selectika_catalog_tick', 'selectika_catalog_continue', 'selectika_orders_send' ) as $selectika_hook ) {
	wp_clear_scheduled_hook( $selectika_hook ); }
foreach ( array( 'selectika_options', 'selectika_connection', 'selectika_schema_version', 'selectika_catalog_manifest', 'selectika_catalog_job', 'selectika_catalog_lock', 'selectika_catalog_revision', 'selectika_catalog_error', 'selectika_orders_lock', 'selectika_orders_error', 'selectika_orders_last_success' ) as $selectika_name ) {
	delete_option( $selectika_name ); }
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Enumerate only owned options during explicit uninstall; WordPress has no prefix-listing API.
$selectika_names = $wpdb->get_col( $wpdb->prepare( "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( 'selectika_catalog_manifest_' ) . '%', $wpdb->esc_like( '_transient_selectika_token_' ) . '%', $wpdb->esc_like( '_transient_timeout_selectika_token_' ) . '%' ) );
foreach ( $selectika_names as $selectika_name ) {
	delete_option( $selectika_name ); }
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Explicit plugin uninstall removes only the three owned private tables; no merchant tables are modified.
$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS %i, %i, %i', $wpdb->prefix . 'selectika_catalog', $wpdb->prefix . 'selectika_outbox', $wpdb->prefix . 'selectika_events' ) );