import pytest

from app.ocr import database
from app.ocr.router import parse_coordinate_ref
from tests.test_ocr import KEY, _item, _seed_page, ocr  # noqa: F401


def test_parse_coordinate_ref():
    # Standard format with T-
    res1 = parse_coordinate_ref("FY 2002-03 | P-59 | T-2 | R-9 | C-3")
    assert res1 == {
        "fiscal_year": "2002-03",
        "page_number": 59,
        "table_num": 2,
        "table_row": 9,
        "table_col": 3
    }

    # Format without 'FY ' prefix
    res2 = parse_coordinate_ref("2016-17 | P-35 | T-1 | R-16 | C-4")
    assert res2 == {
        "fiscal_year": "2016-17",
        "page_number": 35,
        "table_num": 1,
        "table_row": 16,
        "table_col": 4
    }

    # Format without T- (defaults to 1)
    res3 = parse_coordinate_ref("FY 2016-17 | P-35 | R-16 | C-4")
    assert res3 == {
        "fiscal_year": "2016-17",
        "page_number": 35,
        "table_num": 1,
        "table_row": 16,
        "table_col": 4
    }

    # Format with single 4-digit year (e.g. FY 2016)
    res4 = parse_coordinate_ref("FY 2016 | P-36 | T-2 | R-1 | C-2")
    assert res4 == {
        "fiscal_year": "2016",
        "page_number": 36,
        "table_num": 2,
        "table_row": 1,
        "table_col": 2
    }

    # Invalid / empty strings
    assert parse_coordinate_ref("") is None
    assert parse_coordinate_ref(None) is None
    assert parse_coordinate_ref("random string") is None


_SAMPLE_MD = (
    "| Particulars | Note | 2024 | 2023 |\n"
    "|---|---|---|---|\n"
    "| Net Sales Revenue | 23 | 15,508 | 12,965 |\n"
    "| Profit after Tax | 25 | 2,226 | 1,954 |\n"
)


@pytest.fixture
def seeded_cell_page(ocr):
    items = [
        {
            "concept": {"name": "Net Sales Revenue", "statement": "INCOME_STATEMENT"},
            "scope": {"type": "STANDALONE"},
            "raw_field": "Net Sales Revenue",
            "data": [
                {"year": 2024, "numeric_value": 15508.0, "unit": "BDT", "multiplier": 1.0,
                 "table_num": 1, "table_row": 1, "table_col": 3},
                {"year": 2023, "numeric_value": 12965.0, "unit": "BDT", "multiplier": 1.0,
                 "table_num": 1, "table_row": 1, "table_col": 4},
            ],
            "notes": ["Note 23"],
        },
        {
            "concept": {"name": "Profit after Tax", "statement": "INCOME_STATEMENT"},
            "scope": {"type": "STANDALONE"},
            "raw_field": "Profit after Tax",
            "segment": "18 Months",
            "data": [
                {"year": 2024, "numeric_value": 2226.0, "unit": "BDT", "multiplier": 1.0,
                 "table_num": 1, "table_row": 2, "table_col": 3},
            ],
            "notes": ["Note 25"],
        }
    ]
    _seed_page("TESTCO", "2023-24", 12, _SAMPLE_MD, items)
    return ocr


def test_database_get_extracted_cell_by_position(seeded_cell_page):
    # 1. Query extracted metric (Row 1, Col 3 -> Net Sales Revenue)
    cell = database.get_extracted_cell_by_position(
        instrument_code="TESTCO",
        fiscal_year="2023-24",
        page_number=12,
        table_num=1,
        table_row=1,
        table_col=3
    )
    assert cell["found"] is True
    assert cell["coordinates"]["fiscal_year"] == "2023-24"
    assert cell["coordinates"]["page_number"] == 12
    assert cell["coordinates"]["table_row"] == 1
    assert cell["coordinates"]["table_col"] == 3
    assert cell["raw_cell_content"] == "15,508"
    assert cell["metric"]["concept_name"] == "Net Sales Revenue"
    assert cell["metric"]["numeric_value"] == 15508.0
    assert cell["metric"]["data_year"] == 2024
    assert cell["metric"]["notes"] == ["Note 23"]

    # 2. Query segmented metric (Row 2, Col 3 -> Profit after Tax 18 Months)
    cell2 = database.get_extracted_cell_by_position(
        instrument_code="TESTCO",
        fiscal_year="2023-24",
        page_number=12,
        table_num=1,
        table_row=2,
        table_col=3
    )
    assert cell2["found"] is True
    assert cell2["metric"]["concept_name"] == "Profit after Tax"
    assert cell2["metric"]["segment"] == "18 Months"
    assert cell2["metric"]["display_field"] == "Profit after Tax (18 Months)"
    assert cell2["metric"]["numeric_value"] == 2226.0

    # 3. Query non-metric cell (Row header label at Row 1, Col 1)
    label_cell = database.get_extracted_cell_by_position(
        instrument_code="TESTCO",
        fiscal_year="2023-24",
        page_number=12,
        table_num=1,
        table_row=1,
        table_col=1
    )
    assert label_cell["found"] is False
    assert label_cell["raw_cell_content"] == "Net Sales Revenue"
    assert "No numeric metric extracted" in label_cell["message"]


def test_api_cell_by_position_endpoint(seeded_cell_page):
    client = seeded_cell_page

    # 1. Query by 'ref' parameter
    r = client.get(
        "/ocr/company/TESTCO/cell-by-position",
        headers=KEY,
        params={"ref": "FY 2023-24 | P-12 | T-1 | R-1 | C-3"}
    )
    assert r.status_code == 200
    data = r.json()
    assert data["found"] is True
    assert data["coordinates"]["reference"] == "FY 2023-24 | P-12 | T-1 | R-1 | C-3"
    assert data["metric"]["numeric_value"] == 15508.0
    assert data["metric"]["concept_name"] == "Net Sales Revenue"

    # 2. Query by individual parameters
    r2 = client.get(
        "/ocr/company/TESTCO/cell-by-position",
        headers=KEY,
        params={
            "fiscal_year": "2023-24",
            "page_number": 12,
            "table_num": 1,
            "table_row": 2,
            "table_col": 3
        }
    )
    assert r2.status_code == 200
    data2 = r2.json()
    assert data2["found"] is True
    assert data2["metric"]["numeric_value"] == 2226.0
    assert data2["metric"]["segment"] == "18 Months"

    # 3. Query with single-year ref AND explicit fiscal_year parameter (explicit FY takes precedence)
    r3 = client.get(
        "/ocr/company/TESTCO/cell-by-position",
        headers=KEY,
        params={
            "ref": "FY 2024 | P-12 | T-1 | R-1 | C-3",
            "fiscal_year": "2023-24"
        }
    )
    assert r3.status_code == 200
    data3 = r3.json()
    assert data3["found"] is True
    assert data3["coordinates"]["fiscal_year"] == "2023-24"
    assert data3["metric"]["numeric_value"] == 15508.0

    # 4. Query with single-year ref alone (resolves via single-year fallback)
    r4 = client.get(
        "/ocr/company/TESTCO/cell-by-position",
        headers=KEY,
        params={"ref": "FY 2024 | P-12 | T-1 | R-1 | C-3"}
    )
    assert r4.status_code == 200
    data4 = r4.json()
    assert data4["found"] is True
    assert data4["coordinates"]["fiscal_year"] == "2023-24"

    # 5. Missing coordinates without 'ref' gives 422
    r_bad = client.get(
        "/ocr/company/TESTCO/cell-by-position",
        headers=KEY,
        params={"fiscal_year": "2023-24"}
    )
    assert r_bad.status_code == 422
