"""A report's fiscal year is "2024-25" (split year) or "2024" (one year): both are accepted and handled the same way."""
import pytest

from app.ocr import database
from app.ocr.services import series_keys as sk
from app.ocr.services.csv_service import build_raw_csv_from_metrics, extract_year_int
from tests.test_ocr import _MD, _item, _seed_page, full_results, ocr  # noqa: F401  (fixture)

HEADERS = {"X-API-Key": "k3y", "X-Username": "tester"}


@pytest.mark.parametrize("fy", ["2024-25", "2024", "1999-00"])
def test_both_formats_are_accepted_on_every_route_kind(ocr, fy):
    r = ocr.post("/ocr/register-document", headers=HEADERS,
                 data={"instrument_code": "FYCO", "fiscal_year": fy, "filename": "a.pdf", "total_pages": 3})
    assert r.status_code == 200 and r.json()["fiscal_year"] == fy
    assert ocr.get(f"/ocr/company/FYCO/year/{fy}/pages", headers=HEADERS).status_code == 200      # path parameter
    j = ocr.post("/ocr/pipeline/extract", headers=HEADERS,                                         # JSON body
                 json={"instrument_code": "FYCO", "fiscal_year": fy, "page_numbers": [1]})
    assert j.status_code != 422


@pytest.mark.parametrize("fy", ["FY 2024", "2024-2025", "24-25", "2024-5", "24", "2024/25", "", "2024-25-26"])
def test_other_shapes_are_still_refused(ocr, fy):
    r = ocr.post("/ocr/register-document", headers=HEADERS,
                 data={"instrument_code": "FYCO", "fiscal_year": fy, "filename": "a.pdf", "total_pages": 3})
    assert r.status_code == 422


def test_upload_validation_message_names_both_formats(ocr):
    from app.ocr import router
    with pytest.raises(Exception) as e:
        router._validate_fiscal_year("2024-2025")
    assert "2024-25 or 2024" in str(e.value.detail)
    assert router._validate_fiscal_year("2024") == "2024" and router._validate_fiscal_year("2024-25") == "2024-25"


def test_report_end_year_of_both_formats():
    assert sk.report_end_year("2024-25") == 2025
    assert sk.report_end_year("2024") == 2024
    assert sk.report_end_year("1999-00") == 2000
    assert extract_year_int("FY 2024") == 2024


def test_merge_run_label_years_in_both_formats():
    assert database._merge_run_years("2023-24-2024-25", None) == ["2023-24", "2024-25"]
    assert database._merge_run_years("2023-2024", None) == ["2023", "2024"]
    assert database._merge_run_years("2024", None) == ["2024"]


def test_raw_table_of_single_year_reports(ocr):
    """FY "2023" and "2024" reports: columns are keyed "<report>__<year>" and ordered by report year."""
    _seed_page("ONEY", "2024", 5, _MD, [_item("Total assets", [(2024, 1000), (2023, 900)])])
    _seed_page("ONEY", "2023", 7, _MD, [_item("Total assets", [(2023, 880), (2022, 800)])])
    r = ocr.get("/ocr/company/ONEY/results/raw", headers=HEADERS, params={"view": "full"}).json()
    assert [c["key"] for c in r["raw_columns"]] == ["2023__2022", "2023__2023", "2024__2023", "2024__2024"]
    assert r["raw_columns"][2]["group_header"] == "FY 2024"
    cell = r["raw_rows"][0]["cells"]["2024__2024"]
    assert cell["report_fiscal_year"] == "2024" and cell["page_number"] == 5
    assert r["years"] == [2022, 2023, 2024]


def test_raw_table_with_both_formats_in_one_company(ocr):
    _seed_page("MIXY", "2023-24", 7, _MD, [_item("Total assets", [(2024, 950), (2023, 800)])])
    _seed_page("MIXY", "2025", 5, _MD, [_item("Total assets", [(2025, 1100), (2024, 960)])])
    cols = [c["key"] for c in ocr.get("/ocr/company/MIXY/results/raw", headers=HEADERS).json()["raw_columns"]]
    assert cols == ["2023-24__2023", "2023-24__2024", "2025__2024", "2025__2025"]


def test_cell_by_position_with_a_single_year_report(ocr):
    _seed_page("ONEZ", "2024", 5, _MD, [_item("Total assets", [(2024, 1000), (2023, 900)])])
    r = ocr.get("/ocr/company/ONEZ/cell-by-position", headers=HEADERS,
                params={"fiscal_year": "2024", "page_number": 5, "table_num": 1, "table_row": 1, "table_col": 3})
    assert r.status_code == 200 and r.json()["found"] is True and r.json()["coordinates"]["fiscal_year"] == "2024"
    by_ref = ocr.get("/ocr/company/ONEZ/cell-by-position", headers=HEADERS,
                     params={"ref": "FY 2024 | P-5 | T-1 | R-1 | C-3"})
    assert by_ref.status_code == 200 and by_ref.json()["found"] is True


def test_build_raw_csv_labels_a_single_year_report():
    metric = {"fiscal_year": "2024", "page_number": 1, "field": "Total assets", "raw_field": "Total assets",
              "statement_type": "BALANCE_SHEET", "scope": {"type": "CONSOLIDATED"}, "concept": {"name": "Total assets"},
              "data": [{"year": 2024, "numeric_value": 5.0, "unit": "BDT", "multiplier": 1.0,
                        "table_num": 1, "table_row": 1, "table_col": 3}]}
    out = build_raw_csv_from_metrics([metric])
    assert out["raw_columns"][0]["report_fiscal_year"] == "2024" and out["raw_columns"][0]["group_header"] == "FY 2024"
