<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;

return new class extends Migration {
    public function up(): void
    {
        // Sync existing AB test statuses into campaign.status before dropping
        $p = DB::getTablePrefix();
        DB::statement("
            UPDATE {$p}campaigns c
            JOIN {$p}ab_tests ab ON ab.campaign_id = c.id
            SET c.status = CASE ab.status
                WHEN 'awaiting_winner' THEN 'awaiting_winner'
                WHEN 'sending_winner'  THEN 'sending_winner'
                ELSE c.status
            END
        ");

        Schema::table('ab_tests', function (Blueprint $table) {
            $table->dropColumn('status');
        });
    }

    public function down(): void
    {
        Schema::table('ab_tests', function (Blueprint $table) {
            $table->string('status', 20)->default('draft')->after('campaign_id');
        });
    }
};