<?php

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

// Include the Config class file
require_once plugin_dir_path(__FILE__) . 'includes/class-config.php';
// Include the Article class file
require_once plugin_dir_path(__FILE__) . 'includes/class-article.php';

// Use the Config class method to get the table names
$aizl_table_article = AIZLabs\ChatAgent\Config::get_table_name('article');
$aizl_table_agent = AIZLabs\ChatAgent\Config::get_table_name('agent');
$aizl_table_conversation = AIZLabs\ChatAgent\Config::get_table_name('conversation');
$aizl_table_function = AIZLabs\ChatAgent\Config::get_table_name('function');
$aizl_table_global = AIZLabs\ChatAgent\Config::get_table_name('global');

// Prepare article objects for deletion
$aizl_privacy = AIZLabs\ChatAgent\Article::privacy_policy();
$aizl_custom_function = AIZLabs\ChatAgent\Article::custom_function_doc();

// Remove custom database tables
if (is_multisite()) {
    $aizl_sites = get_sites();
    foreach ($aizl_sites as $aizl_site) {
        switch_to_blog($aizl_site->blog_id);
        global $wpdb;
        $aizl_table_article = AIZLabs\ChatAgent\Config::get_table_name('article');
        $aizl_table_agent = AIZLabs\ChatAgent\Config::get_table_name('agent');
        $aizl_table_conversation = AIZLabs\ChatAgent\Config::get_table_name('conversation');
        $aizl_table_function = AIZLabs\ChatAgent\Config::get_table_name('function');
        $aizl_table_global = AIZLabs\ChatAgent\Config::get_table_name('global');
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
        $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_article));
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
        $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_agent));
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
        $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_conversation));
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
        $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_function));
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
        $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_global));

        // Delete the privacy policy page
        $aizl_page = get_page_by_path($aizl_privacy->page_slug);
        if ($aizl_page) {
            wp_delete_post($aizl_page->ID, true);
        }
        // Delete the custom function doc page
        $aizl_page = get_page_by_path($aizl_custom_function->page_slug);
        if ($aizl_page) {
            wp_delete_post($aizl_page->ID, true);
        }

        restore_current_blog();
    }
} else {
    global $wpdb;
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
    $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_article));
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
    $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_agent));
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
    $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_conversation));
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
    $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_function));
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Dropping custom plugin tables on uninstall
    $wpdb->query("DROP TABLE IF EXISTS " . esc_sql($aizl_table_global));
    // Delete the privacy policy page
    $aizl_page = get_page_by_path($aizl_privacy->page_slug);
    if ($aizl_page) {
        wp_delete_post($aizl_page->ID, true);
    }
    // Delete the custom function doc page
    $aizl_page = get_page_by_path($aizl_custom_function->page_slug);
    if ($aizl_page) {
        wp_delete_post($aizl_page->ID, true);
    }
    
}