"""
Тесты итогов табеля.

Контрольные примеры взяты из действующего файла «Расчет ЗП Депо Барановичи»,
лист «Табель», август 2026 — то есть движок проверяется против реальных цифр,
которые уже ушли в расчёт.
"""

from datetime import date

import pytest

from timesheet.totals import (
    FactDay,
    compare_with_norm,
    compute_totals,
    parse_legacy_cell,
    validate_days,
)

AUG = 2026, 8


def day(n: int, **kw) -> FactDay:
    return FactDay(work_date=date(AUG[0], AUG[1], n), **kw)


# ---------------------------------------------------------------------------
#  Контрольный пример 1: Мотылевич А.С., август 2026
#  Ожидание из листа: Раб. дней 16, Раб. часы 168, В 15, ночь 0
# ---------------------------------------------------------------------------

def motylevich_days() -> list[FactDay]:
    hours_days = [3, 4, 7, 8, 11, 12, 15, 16, 19, 20, 23, 24, 27, 28, 31]
    rows = []
    for n in range(1, 32):
        if n == 13:
            rows.append(day(n, hours_day=3))
        elif n in hours_days:
            rows.append(day(n, hours_day=11))
        else:
            rows.append(day(n, day_code="В"))
    return rows


def test_motylevich_totals_match_production_sheet():
    t = compute_totals(motylevich_days())
    assert t.worked_days == 16
    assert t.hours_total == 168.0
    assert t.hours_night == 0.0
    assert t.code("В") == 15
    assert t.worked_days + t.code("В") == 31


def test_motylevich_summary_row_matches_form_columns():
    summary = compute_totals(motylevich_days()).as_summary_row()
    assert summary["Раб. дней"] == 16
    assert summary["Раб. часы"] == 168.0
    assert summary["Раб. часы ночь"] == 0.0
    assert summary["В"] == 15
    assert summary["О"] == 0
    assert summary["Б"] == 0


def test_motylevich_matches_month_norm():
    """Норма августа 2026 — 168 часов, отклонения быть не должно."""
    t = compute_totals(motylevich_days())
    cmpn = compare_with_norm(t, 168)
    assert cmpn.deviation == 0.0
    assert cmpn.is_matched


# ---------------------------------------------------------------------------
#  Контрольный пример 2: Гаврилко И.И., август 2026
#  Ожидание из листа: Раб. дней 10, Раб. часы 110, О 10, В 11
# ---------------------------------------------------------------------------

def gavrilko_days() -> list[FactDay]:
    worked = [13, 14, 17, 18, 21, 22, 25, 26, 29, 30]
    rows = []
    for n in range(1, 32):
        if n <= 10:
            rows.append(day(n, day_code="О"))
        elif n in worked:
            rows.append(day(n, hours_day=11))
        else:
            rows.append(day(n, day_code="В"))
    return rows


def test_gavrilko_totals_match_production_sheet():
    t = compute_totals(gavrilko_days())
    assert t.worked_days == 10
    assert t.hours_total == 110.0
    assert t.code("О") == 10
    assert t.code("В") == 11
    assert t.worked_days + t.code("О") + t.code("В") == 31


def test_gavrilko_deviation_from_norm():
    t = compute_totals(gavrilko_days())
    cmpn = compare_with_norm(t, 168)
    assert cmpn.deviation == -58.0


# ---------------------------------------------------------------------------
#  Ночные часы, работа в выходной, сверхурочные
# ---------------------------------------------------------------------------

def test_night_hours_counted_separately_and_included_in_total():
    days = [day(1, hours_day=4, hours_night=7), day(2, hours_day=11)]
    t = compute_totals(days)
    assert t.hours_day == 15.0
    assert t.hours_night == 7.0
    assert t.hours_total == 22.0
    assert t.worked_days == 2


def test_weekend_and_overtime_are_subsets_not_additions():
    days = [day(1, hours_day=4, hours_weekend=4), day(2, hours_day=11, hours_overtime=3)]
    t = compute_totals(days)
    assert t.hours_total == 15.0        # 4 + 11, а не 4+4+11+3
    assert t.hours_weekend == 4.0
    assert t.hours_overtime == 3.0


# ---------------------------------------------------------------------------
#  Проверки корректности
# ---------------------------------------------------------------------------

def test_validation_catches_code_with_hours():
    errors = validate_days([day(1, day_code="О", hours_day=8)])
    assert any("вместе с отработанными часами" in e for e in errors)


def test_validation_catches_empty_day():
    errors = validate_days([day(1)])
    assert any("не указаны ни часы, ни код" in e for e in errors)


def test_validation_catches_duplicate_day():
    errors = validate_days([day(1, hours_day=8), day(1, hours_day=8)])
    assert any("дважды" in e for e in errors)


def test_validation_catches_subset_violation():
    errors = validate_days([day(1, hours_day=4, hours_overtime=9)])
    assert any("больше отработанных" in e for e in errors)


def test_clean_days_have_no_errors():
    assert validate_days(motylevich_days()) == []
    assert validate_days(gavrilko_days()) == []


# ---------------------------------------------------------------------------
#  Разбор клеток старого табеля (нужен при миграции)
# ---------------------------------------------------------------------------

@pytest.mark.parametrize(
    "cell, hours_day, code, weekend, overtime",
    [
        (11,       11.0, None, 0.0, 0.0),
        ("11",     11.0, None, 0.0, 0.0),
        ("В",       0.0, "В",  0.0, 0.0),
        ("ОЖ",      0.0, "ОЖ", 0.0, 0.0),
        ("РВ 4",    4.0, None, 4.0, 0.0),
        ("4 С",     4.0, None, 0.0, 4.0),
    ],
)
def test_parse_legacy_cell(cell, hours_day, code, weekend, overtime):
    d = parse_legacy_cell(cell)
    assert d is not None
    assert d.hours_day == hours_day
    assert d.day_code == code
    assert d.hours_weekend == weekend
    assert d.hours_overtime == overtime


def test_parse_legacy_cell_empty():
    assert parse_legacy_cell(None) is None
    assert parse_legacy_cell("   ") is None
