"""
«Отложить» — перенос одной записью на задачу (24.09.2026, OTLOZHIT, раздел 8).
"""

import pathlib

ROOT = pathlib.Path(__file__).resolve().parents[2]
SRC = (ROOT / "engine" / "timesheet" / "kanbandb.py").read_text(encoding="utf-8")
SQL = (ROOT / "sql" / "83_kanban_postpone_by_task.sql").read_text(encoding="utf-8")
BOARD = (ROOT / "engine" / "timesheet" / "templates" / "kanban.html").read_text(encoding="utf-8")


def test_postpone_lives_per_task():
    assert "PRIMARY KEY (org_unit_id, task_key)" in SQL
    assert "parked = postpones(conn, unit_id)" in SRC


def test_forecast_rows_get_the_postpone():
    #  ошибка 1: прогнозная строка недели «в работе» теперь получает перенос
    assert "WHERE k.status IN ('open', 'skipped')" in SRC


def test_return_removes_the_postpone_everywhere():
    #  ошибка 2: «Вернуть в работу» снимает перенос на всех неделях
    body = SRC[SRC.index('elif status == "open":'):]
    assert "DELETE FROM app.kanban_postpone" in body[:800]
    assert "week_start >= %s AND status = 'skipped'" in body[:1500]


def test_postpones_are_logged():
    assert '"kanban_postpone"' in SRC and '"kanban_return"' in SRC


def test_counters_are_filters_and_the_hide_button_is_gone():
    assert "Скрыть выполненные и отложенные" not in BOARD
    assert "&state=open" in BOARD and "&state=done" in BOARD and "&state=skipped" in BOARD
    assert 'class="qhint"' in BOARD
