<?php

namespace Tests\Unit\Services\Families;

use App\Services\Families\FamilyFinanceService;
use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Support\Facades\DB;
use Tests\TestCase;

class FamilyFinanceServiceTest extends TestCase
{
    use RefreshDatabase;

    public function test_load_financials_for_parents_returns_summary(): void
    {
        DB::table('invoices')->insert([
            'parent_id' => 1,
            'invoice_number' => 'INV-1',
            'status' => 'open',
            'total_amount' => 100,
            'paid_amount' => 20,
            'balance' => 80,
            'school_year' => '2025-2026',
            'issue_date' => now()->toDateString(),
            'due_date' => now()->addDays(5)->toDateString(),
            'created_at' => now(),
            'updated_at' => now(),
        ]);

        DB::table('payments')->insert([
            'parent_id' => 1,
            'invoice_id' => 1,
            'total_amount' => 100,
            'paid_amount' => 20,
            'balance' => 80,
            'number_of_installments' => 1,
            'payment_method' => 'cash',
            'payment_date' => now()->toDateString(),
            'status' => 'completed',
            'school_year' => '2024-2025',
            'created_at' => now(),
            'updated_at' => now(),
        ]);

        $service = new FamilyFinanceService;
        $result = $service->loadFinancialsForParents([1], '2025-2026');

        $this->assertSame(1, $result['summary']['invoices_count']);
        $this->assertSame(100.0, $result['summary']['total_amount']);
        $this->assertSame(80.0, $result['summary']['positive_unpaid_balance']);
        $this->assertSame(0.0, $result['summary']['credit_balance']);
        $this->assertNotEmpty($result['invoices']);
        $this->assertNotEmpty($result['payments']);
    }

    public function test_load_financials_filters_invoices_and_payments_by_selected_year(): void
    {
        DB::table('invoices')->insert([
            [
                'id' => 10,
                'parent_id' => 1,
                'invoice_number' => 'INV-2025',
                'status' => 'open',
                'total_amount' => 100,
                'paid_amount' => 0,
                'balance' => 100,
                'school_year' => '2025-2026',
                'issue_date' => now()->toDateString(),
                'due_date' => now()->addDays(5)->toDateString(),
                'created_at' => now(),
                'updated_at' => now(),
            ],
            [
                'id' => 11,
                'parent_id' => 1,
                'invoice_number' => 'INV-2024',
                'status' => 'open',
                'total_amount' => 75,
                'paid_amount' => 0,
                'balance' => -25,
                'school_year' => '2024-2025',
                'issue_date' => now()->subYear()->toDateString(),
                'due_date' => now()->subYear()->addDays(5)->toDateString(),
                'created_at' => now(),
                'updated_at' => now(),
            ],
        ]);

        DB::table('payments')->insert([
            [
                'parent_id' => 1,
                'invoice_id' => 10,
                'total_amount' => 100,
                'paid_amount' => 50,
                'balance' => 50,
                'number_of_installments' => 1,
                'payment_method' => 'cash',
                'payment_date' => now()->toDateString(),
                'status' => 'completed',
                'school_year' => '2025-2026',
                'created_at' => now(),
                'updated_at' => now(),
            ],
            [
                'parent_id' => 1,
                'invoice_id' => 11,
                'total_amount' => 75,
                'paid_amount' => 75,
                'balance' => -25,
                'number_of_installments' => 1,
                'payment_method' => 'cash',
                'payment_date' => now()->subYear()->toDateString(),
                'status' => 'completed',
                'school_year' => '2025-2026',
                'created_at' => now(),
                'updated_at' => now(),
            ],
        ]);

        $service = new FamilyFinanceService;
        $result = $service->loadFinancialsForParents([1], '2025-2026');

        $this->assertSame(['INV-2025'], array_column($result['invoices'], 'invoice_number'));
        $this->assertSame([10], array_column($result['payments'], 'invoice_id'));
    }
}