<?php
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Uninstall explicitly drops this plugin's private tables and options; destructive DDL must run immediately and cannot use the posts API or cache.
/** Uninstall is destructive by design, following other Volixta plugins. */
if (!defined('WP_UNINSTALL_PLUGIN')) exit;
function volixta_task_manager_uninstall_site(): void {
    global $wpdb;
    wp_clear_scheduled_hook('volixta_task_manager_notifications_dispatch');
    // Only delete Media Library attachments that this plugin explicitly linked.
    // phpcs:disable WordPress.DB.SlowDBQuery.slow_db_query_meta_key -- Uninstall identifies legacy attachments by this plugin's unique postmeta key.
    $attached = get_posts([
        'post_type' => 'attachment', 'post_status' => 'inherit',
        'posts_per_page' => -1, 'fields' => 'ids', 'meta_key' => '_volixta_task_manager_task_id',
    ]);
    // phpcs:enable WordPress.DB.SlowDBQuery.slow_db_query_meta_key
    foreach ($attached as $aid) wp_delete_attachment((int)$aid, true);
    // Encrypted files are confined to a dedicated private directory.
    require_once __DIR__ . '/includes/class-volixta-task-manager-files.php';
    Volixta_Task_Manager_Files::remove_all_files();
    foreach (['notifications', 'files', 'activity', 'checks', 'tasks', 'stages', 'members', 'boards'] as $table) {
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange -- Only during uninstall, removes one of this plugin's own tables.
        $wpdb->query($wpdb->prepare('DROP TABLE IF EXISTS %i', $wpdb->prefix . 'volixta_task_manager_' . $table));
    }
    $wpdb->query($wpdb->prepare('DELETE FROM %i WHERE option_name LIKE %s', $wpdb->options, $wpdb->esc_like('volixta_task_manager_') . '%'));
}
if (is_multisite()) {
    $volixta_task_manager_offset = 0;
    do {
        $volixta_task_manager_site_ids = get_sites(['fields'=>'ids', 'number'=>100, 'offset'=>$volixta_task_manager_offset, 'orderby'=>'id', 'order'=>'ASC']);
        foreach ($volixta_task_manager_site_ids as $volixta_task_manager_site_id) { switch_to_blog((int)$volixta_task_manager_site_id); volixta_task_manager_uninstall_site(); restore_current_blog(); }
        $volixta_task_manager_offset += count($volixta_task_manager_site_ids);
    } while (count($volixta_task_manager_site_ids) === 100);
} else {
    volixta_task_manager_uninstall_site();
}

// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching