"""
«Удержание» (23.09.2026): журнал приказов о депремировании и удержаниях.
"""

import pathlib
import sys
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" / "74_penalty_orders.sql").read_text(encoding="utf-8")

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


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


def test_three_kinds_strictly():
    assert [k for k, _ in penaltydb.PENALTY_KINDS] == [
        "depremiation", "deduction", "none"]
    assert [v for _, v in penaltydb.PENALTY_KINDS] == [
        "Депремирование", "Удержание", "Без удержания"]
    assert "CHECK (kind IN ('depremiation', 'deduction', 'none'))" in SQL


@pytest.mark.parametrize("raw, value", [
    ("125,50", Decimal("125.50")), ("125,5", Decimal("125.5")),
    ("1 200,00", Decimal("1200.00")), ("7", Decimal("7")), ("", None),
])
def test_amount_with_kopecks_through_a_comma(raw, value):
    assert penaltydb.parse_amount(raw) == value


@pytest.mark.parametrize("raw", ["12,345", "abc", "-5", "1,2,3",
                                 "125.50", "125.5", "1.200", ",50", "10,"])
def test_bad_amount_is_refused(raw):
    with pytest.raises(ValueError):
        penaltydb.parse_amount(raw)


def test_sum_is_optional_only_without_deduction():
    penaltydb.check_fields("none", None, "1", "2026-09-23")
    with pytest.raises(ValueError):
        penaltydb.check_fields("deduction", None, "1", "2026-09-23")
    with pytest.raises(ValueError):
        penaltydb.check_fields("depremiation", Decimal("5"), " ", "2026-09-23")
    assert "kind = 'none' OR (amount IS NOT NULL AND amount > 0)" in SQL


def test_only_administration_writes_depot_reads_its_own():
    assert "WHERE r.code IN ('admin', 'hq_analyst', 'rc_head', 'rc_deputy')" in SQL
    at = SQL.index("p.code = 'penalty.write'")
    assert "WHERE r.code IN ('admin', 'hq_analyst')" in SQL[at - 120:at]
    assert "has_perm('penalty.read') AND has_unit_access(org_unit_id)" in SQL
    assert SQL.count("has_perm('penalty.write') AND has_unit_access(org_unit_id)") == 4
    assert WEB.count('if not webdb.has_perm(conn, "penalty.write"):') == 3


def test_employee_must_belong_to_the_chosen_depot():
    assert "Сотрудник не числится в выбранном депо" in SQL


def test_journal_only_payroll_untouched():
    assert "penalty" not in (APP / "payroll.py").read_text(encoding="utf-8")
    assert "penalty" not in (APP / "payrolldb.py").read_text(encoding="utf-8")


def test_tabs_in_staff_and_in_the_card():
    #  в разделе — «Удержания» (правка заказчика 05.10.2026), в карточке
    #  сотрудника вкладка осталась «Удержание»
    assert ("penalties", "Удержания") in webapp.STAFF_TABS
    assert ("penalties", "Удержание") in webapp.CARD_TABS
    assert "code == 'penalties' and can_penalty_read" in read("_staff_nav.html")
    assert "{% elif tab == 'penalties' %}" in read("staff.html")
    assert "{% elif card_tab == 'penalties' %}" in read("staff_card.html")


def test_dismissed_leave_the_general_tab_but_stay_in_the_card():
    src = (APP / "penaltydb.py").read_text(encoding="utf-8")
    at = src.index("def penalties(")
    assert "where = [_EMPLOYED]" in src[at:at + 400]
    at = src.index("def penalties_of(")
    assert "_EMPLOYED" not in src[at:src.index("\ndef ", at + 5)].split('"""')[2]


def test_depot_cascades_to_people():
    s = read("staff.html")
    assert 'id="penUnit"' in s and 'id="penPerson"' in s
    assert "penalty_people | tojson" in s
    assert "if (!v) return kind.value === 'none';" in s


def test_buttons_record_and_delete():
    s = read("staff.html")
    assert ">Записать</button>" in s and ">Удалить</button>" in s


def test_the_form_checks_the_sum_and_shows_a_window():
    s = read("staff.html")
    assert 'id="penAmountBad"' in s and "Введите верную сумму" in s
    assert "/^\\d+(,\\d{1,2})?$/" in s
    assert "showModal()" in s


def test_first_start_opens_todays_board():
    assert webapp.START_PAGE == "/kanban?span=day"
    #  30.09.2026: вход идёт на вычисляемую страницу — наблюдателю вместо
    #  доски «Сотрудники» (вычитка 1.24); прямой адрес по-прежнему на доску
    assert WEB.count("RedirectResponse(START_PAGE, status_code=303)") == 1
    #  02.10.2026: стартовую страницу знает учётка (webdb.start_page):
    #  наблюдателю — «Сотрудники», службам — свой кабинет
    assert 'start = user["start_page"] if user else START_PAGE' in WEB
