<?php
require_once __DIR__ . '/../helpers/Env.php';
require_once __DIR__ . '/../config/database.php';

try {
    $db = Database::getInstance();
    
    echo "Adding translation columns to variant_type_options table...\n";
    
    // Check if columns already exist
    $stmt = $db->query("SHOW COLUMNS FROM variant_type_options LIKE 'label_en'");
    if ($stmt->fetch()) {
        echo "Translation columns already exist. Skipping migration.\n";
        exit(0);
    }
    
    // Add translation columns
    $db->exec("ALTER TABLE variant_type_options 
        ADD COLUMN label_en VARCHAR(100) DEFAULT NULL AFTER label,
        ADD COLUMN label_sr VARCHAR(100) DEFAULT NULL AFTER label_en,
        ADD COLUMN label_de VARCHAR(100) DEFAULT NULL AFTER label_sr,
        ADD COLUMN label_es VARCHAR(100) DEFAULT NULL AFTER label_de,
        ADD COLUMN label_fr VARCHAR(100) DEFAULT NULL AFTER label_es,
        ADD COLUMN label_it VARCHAR(100) DEFAULT NULL AFTER label_fr,
        ADD COLUMN label_pt VARCHAR(100) DEFAULT NULL AFTER label_it,
        ADD COLUMN label_nl VARCHAR(100) DEFAULT NULL AFTER label_pt,
        ADD COLUMN label_pl VARCHAR(100) DEFAULT NULL AFTER label_nl,
        ADD COLUMN label_ru VARCHAR(100) DEFAULT NULL AFTER label_pl,
        ADD COLUMN label_tr VARCHAR(100) DEFAULT NULL AFTER label_ru,
        ADD COLUMN label_cs VARCHAR(100) DEFAULT NULL AFTER label_tr,
        ADD COLUMN label_el VARCHAR(100) DEFAULT NULL AFTER label_cs,
        ADD COLUMN label_hu VARCHAR(100) DEFAULT NULL AFTER label_el,
        ADD COLUMN label_ro VARCHAR(100) DEFAULT NULL AFTER label_hu,
        ADD COLUMN label_sv VARCHAR(100) DEFAULT NULL AFTER label_ro,
        ADD COLUMN label_no VARCHAR(100) DEFAULT NULL AFTER label_sv,
        ADD COLUMN label_jp VARCHAR(100) DEFAULT NULL AFTER label_no,
        ADD COLUMN label_cn VARCHAR(100) DEFAULT NULL AFTER label_jp,
        ADD COLUMN label_il VARCHAR(100) DEFAULT NULL AFTER label_cn");
    
    echo "Translation columns added successfully.\n";
    
    // Migrate existing Serbian data to label_sr column
    echo "Migrating existing data to label_sr column...\n";
    $db->exec("UPDATE variant_type_options SET label_sr = label WHERE label_sr IS NULL");
    echo "Data migration completed.\n";
    
    echo "Migration completed successfully!\n";
    
} catch (PDOException $e) {
    echo "Migration failed: " . $e->getMessage() . "\n";
    exit(1);
}