"""
Финансы: аренда и услуги связи (24.09.2026, миграция 86).
"""

import pathlib
import sys
from datetime import date
from decimal import Decimal

import pytest

ROOT = pathlib.Path(__file__).resolve().parents[2]
APP = ROOT / "engine" / "timesheet"
WEB = (APP / "webapp.py").read_text(encoding="utf-8")
T = APP / "templates"
SQL = (ROOT / "sql" / "86_finance.sql").read_text(encoding="utf-8")

sys.path.insert(0, str(ROOT / "engine"))
from timesheet import financedb, kanbandb, webapp               # noqa: E402


def read(name):
    return (T / name).read_text(encoding="utf-8")


def test_only_administration_has_the_section():
    at = SQL.index("INSERT INTO role_permission")
    assert "WHERE r.code IN ('admin', 'hq_analyst')" in SQL[at:at + 200]
    assert "p.code IN ('finance.read', 'finance.write')" in SQL[at:at + 250]
    #  Все шесть таблиц под правами, запись — только с finance.write
    for t in ("finance_contract", "finance_contract_amount", "finance_rate",
              "finance_accrual", "finance_payment", "finance_file"):
        assert f"'{t}'" in SQL
    assert "USING (has_perm(''finance.write'')) " in SQL
    base = read("base.html")
    assert "{% if user is defined and user and user.can_finance %}" in base
    assert "app.has_perm('finance.read') AS can_finance" in (APP / "webdb.py").read_text(encoding="utf-8")


def test_two_kinds_three_currencies_two_rate_rules():
    assert financedb.KIND_RU == {"rent": "Аренда", "telecom": "Услуги связи"}
    assert financedb.CURRENCIES == ("BYN", "USD", "EUR")
    assert set(financedb.RATE_RULE_RU) == {"payment", "accrual"}
    assert "CHECK (currency IN ('BYN', 'USD', 'EUR'))" in SQL
    assert "CHECK (kind IN ('rent', 'telecom'))" in SQL


@pytest.mark.parametrize("period, day, month, due", [
    (date(2026, 9, 1), 10, "current", date(2026, 9, 10)),
    (date(2026, 9, 1), 10, "next", date(2026, 10, 10)),
    (date(2026, 2, 1), 31, "current", date(2026, 2, 28)),     # дня нет — последний
    (date(2026, 1, 1), 31, "next", date(2026, 2, 28)),
    (date(2026, 12, 1), 5, "next", date(2027, 1, 5)),
])
def test_due_date(period, day, month, due):
    assert financedb.due_date(period, day, month) == due


def test_months_arithmetic():
    assert financedb.add_months(date(2026, 1, 31), 1) == date(2026, 2, 28)
    assert financedb.add_months(date(2026, 11, 15), 3) == date(2027, 2, 15)
    assert financedb.add_months(date(2026, 3, 1), -2) == date(2026, 1, 1)
    assert financedb.month_end(date(2028, 2, 3)) == date(2028, 2, 29)


@pytest.mark.parametrize("raw, value", [
    ("1250,50", Decimal("1250.50")), ("1 250,5", Decimal("1250.50")),
    ("3000", Decimal("3000.00")), ("9 880,00", Decimal("9880.00")),
])
def test_money_is_read_with_comma_and_spaces(raw, value):
    assert financedb.money(raw, "сумму") == value


@pytest.mark.parametrize("raw", ["", "abc", "-5", "0"])
def test_bad_money_is_refused(raw):
    with pytest.raises(ValueError):
        financedb.money(raw, "сумму")


def test_zero_accrual_allowed_only_where_asked():
    assert financedb.money("0", "сумму", allow_zero=True) == Decimal("0.00")


def test_rate_and_dates():
    assert financedb.rate_value("3,27155") == Decimal("3.2716")
    with pytest.raises(ValueError):
        financedb.rate_value("0")
    assert financedb.parse_day("2026-09-24") == date(2026, 9, 24)
    assert financedb.parse_day("24.09.2026") == date(2026, 9, 24)
    assert financedb.parse_day("2026-09") == date(2026, 9, 1)
    with pytest.raises(ValueError):
        financedb.parse_day("завтра")


def test_status_labels():
    today = date(2026, 9, 24)
    base = {"closed_on": None, "starts_on": date(2026, 1, 1), "auto_renew": False}
    assert financedb.status_of(dict(base, ends_on=None), today) == ("active", "бессрочный")
    assert financedb.status_of(dict(base, ends_on=date(2026, 10, 10)), today)[0] == "expiring"
    assert financedb.status_of(dict(base, ends_on=date(2026, 9, 1)), today)[0] == "ended"
    assert financedb.status_of(dict(base, ends_on=date(2027, 1, 1)), today)[0] == "active"
    assert financedb.status_of(dict(base, ends_on=None, closed_on=today), today)[0] == "closed"
    assert "продлится сам" in financedb.status_of(
        dict(base, ends_on=date(2026, 10, 1), auto_renew=True), today)[1]


def test_manual_accrual_needs_a_reason_and_is_not_overwritten():
    assert "CONSTRAINT finance_accrual_manual CHECK (NOT is_manual OR" in SQL
    src = (APP / "financedb.py").read_text(encoding="utf-8")
    body = src[src.index("def add_amount("):src.index("def close_contract(")]
    assert "NOT is_manual" in body
    assert 'raise ValueError("Укажите причину правки' in src


def test_old_contract_does_not_bring_old_debt():
    #  «Начислять с» — первое число, по умолчанию не раньше текущего месяца
    assert "CONSTRAINT finance_contract_accrue CHECK (accrue_from = date_trunc('month'" in SQL
    src = (APP / "financedb.py").read_text(encoding="utf-8")
    assert "max(month_start(fields[\"starts_on\"]),\n                                            month_start(today))" in src


def test_every_change_goes_to_the_journal():
    assert webapp.JOURNAL_BLOCKS["finance"] == ("finance%",)
    for code in financedb.OPERATION_RU:
        assert code.startswith("finance_")
        assert webapp.OPERATION_RU[code] == financedb.OPERATION_RU[code]
    src = (APP / "financedb.py").read_text(encoding="utf-8")
    for code in financedb.OPERATION_RU:
        assert f'"{code}"' in src[src.index("def ensure("):]


def test_board_tasks_for_administration():
    for kind in ("fin_contract_end", "fin_payment", "fin_rate"):
        assert kind in kanbandb.KIND_RU and kind in kanbandb.HQ_KINDS
        assert kanbandb.RESTRICTED_KINDS[kind] == "finance.read"
        assert kind in kanbandb.ACTION_LABEL
    assert financedb.EXPIRY_LEAD == 30


def test_links_from_the_board():
    rows = [{"task_key": "fin_contract_end:7", "kind": "fin_contract_end"},
            {"task_key": "fin_payment:7:31", "kind": "fin_payment"},
            {"task_key": "fin_rate:USD:2026-09-10", "kind": "fin_rate"}]
    urls = kanbandb.subject_urls(None, 0, "minsk", date(2026, 9, 1), rows)
    assert urls == {"fin_contract_end:7": "/finance/contract/7",
                    "fin_payment:7:31": "/finance/contract/7#accruals",
                    "fin_rate:USD:2026-09-10": "/finance?tab=rates"}


def test_screens_and_routes():
    for route in ('@app.get("/finance"', '@app.post("/finance/contract")',
                  '@app.get("/finance/contract/{contract_id}"',
                  '"/finance/contract/{contract_id}/amount"',
                  '"/finance/accrual/{accrual_id}/pay"',
                  '"/finance/accrual/{accrual_id}/edit"',
                  '"/finance/rate"', '"/finance/contract/{contract_id}/file"',
                  '"/api/finance/summary.xlsx"'):
        assert route in WEB
    page = read("finance.html")
    assert "Новый договор" in page and "Выгрузить в Excel" in page
    card = read("finance_contract.html")
    assert "Отметить оплату" in card and "Причина правки" in card
    assert "Сканы договора и допсоглашений" in card


def test_money_filter():
    assert webapp.money_fmt(Decimal("9880")) == "9 880,00"
    assert webapp.money_fmt(Decimal("-20.5")) == "−20,50"
    assert webapp.money_fmt(None) == "—"


def test_xlsx_export(tmp_path):
    import openpyxl
    m = date(2026, 9, 1)
    data = {"kind": None, "first": m, "last": m, "on_day": date(2026, 9, 24),
            "months": [m],
            "rows": [{"unit_name": "Барановичи", "kind": "rent", "kind_ru": "Аренда",
                      "by_month": {m: {"accrued": Decimal("100"), "paid": Decimal("40")}},
                      "accrued": Decimal("100"), "paid": Decimal("40"),
                      "debt": Decimal("60"), "no_rate": 0}],
            "totals": {"accrued": Decimal("100"), "paid": Decimal("40"),
                       "debt": Decimal("60"), "no_rate": 0,
                       "by_month": {m: {"accrued": Decimal("100"), "paid": Decimal("40")}}}}
    rows = [{"period_month": m, "unit_name": "Барановичи", "kind": "rent",
             "counterparty": "ООО", "contract_no": "1", "contract_date": m,
             "subject": "Склад", "amount_cur": Decimal("100"), "currency": "BYN",
             "rate": None, "rate_date": None, "amount_byn": Decimal("100"),
             "due_date": m, "paid": Decimal("40"), "docs": "п/п №1", "manual_reason": None}]
    out = tmp_path / "f.xlsx"
    financedb.export_xlsx(str(out), data, rows)
    wb = openpyxl.load_workbook(out)
    assert wb.sheetnames == ["Сводка", "Начисления"]
    ws = wb["Сводка"]
    assert ws["A4"].value == "Барановичи" and ws["E4"].value == 100
    assert wb["Начисления"]["N2"].value == 60


def test_board_forecast_does_not_accrue_future_months():
    src = (APP / "kanbandb.py").read_text(encoding="utf-8")
    assert "financedb.ensure(conn, min(today, date.today()), commit=False)" in src


def test_finance_money_filter_does_not_replace_the_common_one():
    #  25.09.2026: фильтр «Финансов» затёр общий «money» — упал «Бюджет»
    assert webapp.templates.env.filters["money"] is webapp.money
    assert webapp.templates.env.filters["fmoney"] is webapp.money_fmt
