from pathlib import Path

import pytest
from openpyxl import load_workbook

from finreport_agent.pipeline import convert_report


SAMPLE_PDF = (
    Path(__file__).resolve().parents[2] / "TI2_2025.06 (1).pdf"
)


@pytest.mark.skipif(not SAMPLE_PDF.exists(), reason="Local golden PDF is unavailable")
def test_generated_workbook_has_audit_structure(tmp_path):
    output = tmp_path / "golden.xlsx"
    result = convert_report(SAMPLE_PDF, output)

    assert result.output_path == str(output.resolve())
    assert output.exists()

    formulas = load_workbook(output, data_only=False)
    values = load_workbook(output, data_only=True)
    assert formulas.sheetnames == [
        "Özet",
        "Hisse Senetleri",
        "T. Repo",
        "Türev",
        "Kontroller",
        "Kaynak İzleri",
    ]
    assert formulas["Özet"]["E9"].value == "=D9-C9"
    assert values["Özet"]["E9"].value == 0
    assert values["Hisse Senetleri"].max_row == 74
    assert values["Kontroller"]["B8"].value == "EQUITY_NOMINAL_ROUNDING"

    klypv_rows = [
        row
        for row in values["Hisse Senetleri"].iter_rows(min_row=5, values_only=True)
        if row[0] == "KLYPV"
    ]
    assert len(klypv_rows) == 1
    assert klypv_rows[0][7] is None
    assert klypv_rows[0][8] == 64.2