<?php

namespace Tests\Feature;

use App\Campaigns\PerformanceVerdict;
use App\Models\Campaign;
use App\Models\CampaignPerformanceHourStat;
use App\Models\CampaignPerformanceStat;
use App\Models\CampaignPerformanceSuggestion;
use App\Models\User;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Facades\Schema;
use Tests\TestCase;

class CampaignPerformanceWhaleMapTest extends TestCase
{
    use RefreshDatabase;

    protected function setUp(): void
    {
        parent::setUp();

        Config::set('campaign-performance.whale_enabled', true);
        Config::set('campaign-performance.llm_enabled', false);

        if (! Schema::connection('whale')->hasTable('arb_adops_campaign_performance')) {
            Schema::connection('whale')->create('arb_adops_campaign_performance', function (Blueprint $table): void {
                $table->unsignedBigInteger('id')->primary();
                $table->date('date');
                $table->string('campaign_id', 32);
                $table->unsignedInteger('clicks');
                $table->decimal('sum_cpc', 12, 4);
                $table->decimal('orders', 12, 4);
                $table->decimal('net_revenue', 12, 4);
                $table->json('debug_json')->nullable();
            });
        }
    }

    public function test_map_uses_whale_revenue_to_soften_pause_verdict(): void
    {
        $this->travelTo('2026-09-22 12:00:00');

        $user = User::factory()->create();
        $externalId = '120251915605170683';

        Campaign::create([
            'user_id' => $user->id,
            'name' => 'Whale test',
            'platform' => 'meta',
            'status' => 'published',
            'budget' => 20,
            'ad_account_id' => 'act_111',
            'external_campaign_id' => $externalId,
        ]);

        foreach (range(0, 6) as $offset) {
            CampaignPerformanceStat::create([
                'user_id' => $user->id,
                'platform' => 'meta',
                'external_campaign_id' => $externalId,
                'stat_date' => now()->subDays(6 - $offset)->toDateString(),
                'spend' => 6.0,
                'impressions' => 100,
                'clicks' => 0,
                'platform_status' => 'ACTIVE',
                'fetched_at' => now(),
            ]);
        }

        foreach (range(0, 6) as $offset) {
            CampaignPerformanceHourStat::create([
                'user_id' => $user->id,
                'platform' => 'meta',
                'external_campaign_id' => $externalId,
                'stat_hour' => now()->copy()->startOfHour()->subHours(6 - $offset),
                'spend' => 1.0,
                'impressions' => 20,
                'clicks' => 0,
                'platform_status' => 'ACTIVE',
                'fetched_at' => now(),
            ]);
        }

        DB::connection('whale')->table('arb_adops_campaign_performance')->insert([
            'id' => 105,
            'date' => '2026-09-19',
            'campaign_id' => $externalId,
            'clicks' => 3,
            'sum_cpc' => 0.15,
            'orders' => 3,
            'net_revenue' => 89.44,
            'debug_json' => null,
        ]);

        Http::fake();

        $this->artisan('campaigns:sync-performance', [
            '--map' => true,
            '--campaign' => $externalId,
        ])->assertSuccessful();

        $suggestion = CampaignPerformanceSuggestion::query()->first();

        $this->assertNotNull($suggestion);
        $this->assertSame(PerformanceVerdict::Continue->value, $suggestion->status);
        $this->assertTrue(data_get($suggestion->snapshot, 'affiliate.matched'));
        $this->assertStringContainsString('affiliate data', strtolower((string) $suggestion->reason));
    }
}