<?php

namespace Better_Payment\Lite\Classes;

/**
 * Exit if accessed directly
 */
if (!defined('ABSPATH')) {
    exit;
}

/**
 * The plugin migrator class
 * 
 * @since 0.0.2
 */
class Migrator
{

    /**
     * Initialize the plugin
     * 
     * @since 0.0.2
     */
    public static function migrator() {
        self::create_missing_tables();
        self::update_tables();
    }

    /**
     * Create any table added since this install was activated (dbDelta is
     * idempotent). The migrator only runs once per version change, so an
     * existing install picks up e.g. the better_payment_subscription_order table
     * on its first load after an update — activation never re-runs there.
     *
     * Kept separate from update_tables(), which stays ALTER-only: the test
     * environment rewrites CREATE TABLE to CREATE TEMPORARY TABLE, so a
     * create inside a column-migration test would shadow the real table.
     *
     * @since 2.4.0
     */
    public static function create_missing_tables() {
        ( new \Better_Payment\Lite\Installer() )->create_tables();
    }

    /**
     * Update the plugin tables
     *
     * @since 0.0.2
     */
    public static function update_tables() {
        //Add column
        // Transitional: only Better Payment Pro's refunds write `refund_info`. Pro 1.4.4
        // adds the column itself (Pro Installer::add_refund_info_column()); Pro <= 1.4.3
        // relies on this. Stop adding it when ProCompatibility::MIN_PRO_VERSION >= 1.4.4.
        self::add_column( 'refund_info', 'longtext' );
        self::add_column( 'campaign_id', 'text' );
    }
    
    private static function add_column( $column_name, $column_type ) {
        global $wpdb;
        $wpdb->hide_errors();
        $table_name = "{$wpdb->prefix}better_payment";
        
        // $row = $wpdb->get_results(  "SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '$table_name' AND column_name = '$column_name'"  );
        
        $columns = $wpdb->get_col( "DESC $table_name", 0 );
        
        if (in_array($column_name, $columns)) {
            return;
        }
        
        $wpdb->query($wpdb->prepare("ALTER TABLE $table_name ADD $column_name $column_type"));
    }
}