<?php
/**
 * Uninstall routine for Admin Views Column for Matomo.
 *
 * Removes all data stored by the plugin: options, transients and post meta.
 */

declare(strict_types=1);

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

$admivico_cache_keys = get_option('admivico_cache_keys', []);
if (is_array($admivico_cache_keys)) {
    foreach ($admivico_cache_keys as $admivico_cache_key) {
        if (is_string($admivico_cache_key) && strpos($admivico_cache_key, 'admivico_') === 0) {
            delete_transient($admivico_cache_key);
        }
    }
}

// Fallback: remove any plugin transient the registry may have missed.
global $wpdb;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- One-time cleanup at uninstall; caching is not applicable.
$wpdb->query(
    $wpdb->prepare(
        "DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s",
        $wpdb->esc_like('_transient_admivico_') . '%',
        $wpdb->esc_like('_transient_timeout_admivico_') . '%'
    )
);

delete_option('admivico_options');
delete_option('admivico_cache_keys');

delete_post_meta_by_key('_admivico_views_count');

// Per-user screen options: the reporting period of the admin lists and of the
// dashboard widget.
delete_metadata('user', 0, 'admivico_list_periods', '', true);
delete_metadata('user', 0, 'admivico_widget_period', '', true);

wp_cache_flush();