<?php

namespace AdvancedBlockControls;

// Exit if the file is accessed directly
if ( !defined('ABSPATH') ) {
    exit; 
}

class RegistrationManager
{
    private $charset_collate; // Declaring the property here

    const BLOCKS_TABLE_NAME = "abcon_blocks";

    const CONTROLS_TABLE_NAME = "abcon_controls";

    public function __construct()
    {
        global $wpdb;
        $this->charset_collate = $wpdb->get_charset_collate();
        $plugin_file = plugin_dir_path(dirname(__FILE__)) . 'advanced-block-controls.php';

        // Register activation hook for default options setup
        register_activation_hook($plugin_file, [$this, 'activate_plugin']);
    }

    public function activate_plugin() {
        $this->setup_default_options();
        $this->create_custom_tables();

        // Setup default data only if the tables are empty
        if ($this->are_tables_empty()) {
            $this->setup_default_data();
        }
    }

    public function setup_default_options()
    {
        $default_settings = array(
            'editor_specificity_core' => '',
            'editor_specificity_third_party' => '',
            'front_end_specificity_core' => '',
            'front_end_specificity_third_party' => '',
            'force_rules_core' => true,
            'force_rules_third_party' => true,
            'breakpoints' => array(
                'Tablet' =>  array(
                    'value' => '1024',
                    'unit' => 'px'
                ),
                'Mobile' => array(
                    'value' => '767',
                    'unit' => 'px'
                ),
            )
        );

        // General settings option
        add_option('abcon_settings', wp_json_encode($default_settings));

        // Deny list option
        add_option('abcon_deny_list', wp_json_encode(array()));
    }

    public function create_custom_tables()
    {
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

        global $wpdb;
        
        // Create blocks table only if it doesn't exist
        if (!$this->blocks_table_exists()) {
            // SQL for creating blocks table table
            $sql_blocks = "CREATE TABLE {$wpdb->prefix}" . self::BLOCKS_TABLE_NAME . " (
                id mediumint(9) NOT NULL AUTO_INCREMENT,
                block_name text NOT NULL,
                config text NOT NULL,
                is_default_settings boolean DEFAULT true,
                target text NOT NULL,
                date_added datetime DEFAULT CURRENT_TIMESTAMP,
                date_edited datetime DEFAULT NULL,
                PRIMARY KEY  (id)
            ) $this->charset_collate;";

            // Execute the SQL for blocks table
            dbDelta($sql_blocks);
        }

        // Check if the controls table exists
        if (!$this->controls_table_exists()) {
            // SQL for creating controls table
            // default_clone if this is a clone of the default control (happens when the control is opted out)
            $sql_controls = "CREATE TABLE {$wpdb->prefix}" . self::CONTROLS_TABLE_NAME . " (
                id mediumint(9) NOT NULL AUTO_INCREMENT,
                default_clone boolean,
                default_id mediumint(9), 
                blockId mediumint(9) NOT NULL,
                title text NOT NULL,
                type text NOT NULL,
                state text NOT NULL,
                target text NOT NULL,
                config text NOT NULL,
                order_num int NOT NULL DEFAULT 0,
                date_added datetime DEFAULT CURRENT_TIMESTAMP,
                date_edited datetime DEFAULT NULL,
                PRIMARY KEY  (id)
            ) {$this->charset_collate};";
            // Execute the SQL for controls table
            dbDelta($sql_controls);

            // Adding foreign keys seprately.
            $sql_add_fk = "ALTER TABLE {$wpdb->prefix}" . self::CONTROLS_TABLE_NAME . "
                ADD CONSTRAINT fk_blockId
                FOREIGN KEY (blockId)
                REFERENCES {$wpdb->prefix}" . self::BLOCKS_TABLE_NAME . "(id)
                ON DELETE CASCADE;";
            $wpdb->query($sql_add_fk); 
        }
    }

    // Setup default data for the plugin
    public function setup_default_data () {
        global $wpdb;
        $table_prefix = $wpdb->prefix;
        $sql_file = dirname(__FILE__) . '/../initial-setup.sql';
        $sql = file_get_contents($sql_file);
    
        // Replace the placeholder with the actual table prefix
        $sql = str_replace('{prefix}_', $table_prefix, $sql);
    
        // Split the SQL file into individual queries
        $queries = explode(';', $sql);
        foreach ($queries as $query) {
            if (trim($query) != '') {
                $wpdb->query($query);
            }
        }
    }

    /**
     * Checks if the blocks table exists in the database.
     *
     * @return bool True if the table exists, false otherwise.
     */
    public function blocks_table_exists() {
        global $wpdb;

        $table_name = $wpdb->prefix . self::BLOCKS_TABLE_NAME;
        $query = $wpdb->prepare('SHOW TABLES LIKE %s', $wpdb->esc_like($table_name));

        if ($wpdb->get_var($query) == $table_name) {
            return true; // Table exists.
        } else {
            return false; // Table does not exist.
        }
    }

    /**
     * Checks if the controls table exists in the database.
     *
     * @return bool True if the table exists, false otherwise.
     */
    public function controls_table_exists() {
        global $wpdb;

        $table_name = $wpdb->prefix . self::CONTROLS_TABLE_NAME;
        $query = $wpdb->prepare('SHOW TABLES LIKE %s', $wpdb->esc_like($table_name));

        if ($wpdb->get_var($query) == $table_name) {
            return true; // Table exists.
        } else {
            return false; // Table does not exist.
        }
    }


    /**
     * Checks if the blocks and controls tables are empty.
     *
     * @return bool True if both tables are empty, false otherwise.
     */
    public function are_tables_empty() {
        global $wpdb;

        $blocks_table_name = $wpdb->prefix . self::BLOCKS_TABLE_NAME;
        $controls_table_name = $wpdb->prefix . self::CONTROLS_TABLE_NAME;

        $blocks_query = "SELECT COUNT(*) FROM {$blocks_table_name}";
        $controls_query = "SELECT COUNT(*) FROM {$controls_table_name}";

        $blocks_count = $wpdb->get_var($blocks_query);
        $controls_count = $wpdb->get_var($controls_query);

        return $blocks_count == 0 && $controls_count == 0;
    }

}