<?php

namespace Booktics;

use Booktics\Dummy_Data\Dummy_Data_Manager;

class Installer {
    /**
     * Initializes the Booktics plugin by performing necessary setup tasks.
     *
     * This method performs the following setup operations:
     * - Creates or updates required database tables
     * - Initializes user roles and capabilities
     * - Generates initial onboarding data using dummy data manager
     */
    public static function run(): void {
        self::create_tables();
        ( new Role() )->init();
        ( new Dummy_Data_Manager() )->generate_onboarding_data();
    }

    /**
     * Creates and updates database tables required for the Booktics plugin.
     *
     * Creates the following tables if they don't exist:
     * - booktics_schedules: Stores scheduling information for team members and services
     * - booktics_carts: Stores shopping cart information
     * - booktics_cart_items: Stores individual items in shopping carts
     * - booktics_orders: Stores order information and payment details
     * - booktics_payments: Stores payment transaction records
     *
     * Also handles table structure updates by adding missing columns to existing tables
     * and performing necessary column modifications.
     */
    private static function create_tables(): void {
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';

        global $wpdb;
        $charset_collate = $wpdb->get_charset_collate();

        $table_prefix = $wpdb->prefix;
        error_log( $table_prefix );
        $table_schema = array(
            "CREATE TABLE IF NOT EXISTS {$table_prefix}booktics_schedules (
                id mediumint(9) NOT NULL AUTO_INCREMENT,
                team_member_id int(11) NOT NULL,
                service_id int(11) NOT NULL,
                location_id int(11) NOT NULL,
                start_time varchar(100) NOT NULL,
                end_time varchar(100) NOT NULL,
                week_day varchar(100) NOT NULL,
                custom_date varchar(100) NOT NULL,
                created_at datetime DEFAULT NULL,
                updated_at datetime DEFAULT NULL,
                PRIMARY KEY (id)
            ) $charset_collate;",

            "CREATE TABLE IF NOT EXISTS {$table_prefix}booktics_carts (
                id mediumint(9) NOT NULL AUTO_INCREMENT,
                uuid varchar(36) NOT NULL,
                user_id int(11) NOT NULL,
                coupon_code varchar(100) DEFAULT NULL,
                total decimal(10,2) DEFAULT NULL,
                created_at datetime DEFAULT NULL,
                updated_at datetime DEFAULT NULL,
                PRIMARY KEY (id)
            ) $charset_collate;",

            "CREATE TABLE IF NOT EXISTS {$table_prefix}booktics_cart_items (
                id mediumint(9) NOT NULL AUTO_INCREMENT,
                uuid varchar(36) NOT NULL,
                cart_id mediumint(9) NOT NULL,
                team_member_id int(11) DEFAULT NULL,
                service_id int(11) DEFAULT NULL,
                date date DEFAULT NULL,
                start_time varchar(100) DEFAULT NULL,
                end_time varchar(100) DEFAULT NULL,
                price VARCHAR(100) DEFAULT NULL,
                created_at datetime DEFAULT NULL,
                updated_at datetime DEFAULT NULL,
                PRIMARY KEY (id)
            ) $charset_collate;",

            "CREATE TABLE IF NOT EXISTS {$table_prefix}booktics_orders (
                id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
                order_no VARCHAR(100) NOT NULL,
                customer_id BIGINT UNSIGNED NOT NULL,
                customer_note VARCHAR(100) DEFAULT NULL,
                status VARCHAR(50) DEFAULT 'pending',
                payment_status VARCHAR(50) DEFAULT NULL,
                timezone VARCHAR(50) DEFAULT 'UTC',
                price_breakdown JSON DEFAULT NULL,
                tax_total VARCHAR(100) DEFAULT NULL,
                coupon_code VARCHAR(100) DEFAULT NULL,
                coupon_discount VARCHAR(100) DEFAULT NULL,
                subtotal VARCHAR(100) DEFAULT 0,
                total VARCHAR(100) DEFAULT 0,
                payment_method VARCHAR(50) DEFAULT NULL,
                payment_intent_id VARCHAR(250) DEFAULT NULL,
                payment_transaction_id VARCHAR(250) DEFAULT NULL,
                created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
                updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                PRIMARY KEY (id),
                INDEX (order_no)
            ) $charset_collate;",

            "CREATE TABLE IF NOT EXISTS {$table_prefix}booktics_payments (
                id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                order_id BIGINT UNSIGNED NOT NULL,
                customer_id BIGINT UNSIGNED NOT NULL,
                amount VARCHAR(20) NOT NULL,
                currency VARCHAR(10) DEFAULT 'usd',
                intent_id VARCHAR(255),
                transaction_id VARCHAR(255),
                status varchar(100) NOT NULL DEFAULT 'pending',
                payment_method VARCHAR(50) NOT NULL,
                refunded_amount VARCHAR(20) DEFAULT '0.00',
                failure_reason TEXT,
                date DATE NOT NULL,
                date_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
                INDEX (order_id),
                INDEX (customer_id),
                INDEX (intent_id),
                INDEX (transaction_id)
            ) $charset_collate;",
        );

        foreach ( $table_schema as $table_sql ) {
            dbDelta( $table_sql );
        }

        // Add missing columns to booktics_orders table
        $orders_table = "{$table_prefix}booktics_orders";
        $orders_columns = $wpdb->get_col( 'DESC `' . esc_sql( $orders_table ) . '`', 0 );

        $orders_columns_to_add = array(
            'payment_method'         => 'VARCHAR(50) DEFAULT NULL',
            'payment_intent_id'      => 'VARCHAR(250) DEFAULT NULL',
            'payment_transaction_id' => 'VARCHAR(250) DEFAULT NULL',
        );

        foreach ( $orders_columns_to_add as $column => $definition ) {
            if ( ! in_array( $column, $orders_columns, true ) ) {
                $query = sprintf(
                    'ALTER TABLE `%s` ADD COLUMN `%s` %s',
                    esc_sql( $orders_table ),
                    esc_sql( $column ),
                    $definition
                );
                $wpdb->query( $query );
            }
        }

        // Handle booktics_cart_items table
        $cart_items_table = "{$table_prefix}booktics_cart_items";
        $cart_items_columns = $wpdb->get_col( 'DESC `' . esc_sql( $cart_items_table ) . '`', 0 );

        // Rename sub_total to subtotal if exists
        if ( in_array( 'sub_total', $cart_items_columns, true ) ) {
            $wpdb->query(
                sprintf(
                    'ALTER TABLE `%s` CHANGE COLUMN `sub_total` `subtotal` VARCHAR(20) NOT NULL',
                    esc_sql( $cart_items_table )
                )
            );
        } elseif ( ! in_array( 'subtotal', $cart_items_columns, true ) ) {
            $wpdb->query(
                sprintf(
                    'ALTER TABLE `%s` ADD COLUMN `subtotal` VARCHAR(20) NOT NULL',
                    esc_sql( $cart_items_table )
                )
            );
        }

        $cart_items_columns_to_add = array(
            'extra_services'         => 'TEXT DEFAULT NULL',
            'total'                  => 'VARCHAR(20) NOT NULL',
            'additional_duration_id' => 'VARCHAR(100) NOT NULL',
            'group_booking'          => 'TEXT DEFAULT NULL',
        );

        foreach ( $cart_items_columns_to_add as $column => $definition ) {
            if ( ! in_array( $column, $cart_items_columns, true ) ) {
                $query = sprintf(
                    'ALTER TABLE `%s` ADD COLUMN `%s` %s',
                    esc_sql( $cart_items_table ),
                    esc_sql( $column ),
                    $definition
                );
                $wpdb->query( $query );
            }
        }
    }
}