"""
ТО по ролям (замечания к TO_PROCESS, 24.09.2026): ПОПГ и ЧТО для МПРП,
заявка на ТО-2 в три шага, правка отметок Администрацией, ремонт вызовом
специалиста с датой приезда, последние ТО при заведении техники.
"""

import pathlib
from datetime import date

from timesheet.kanbandb import action_label, month25_horizon

ROOT = pathlib.Path(__file__).resolve().parents[2]
SQL = (ROOT / "sql" / "79_maintenance_flow.sql").read_text(encoding="utf-8")
ENGINE = ROOT / "engine" / "timesheet"
DB = (ENGINE / "supplydb.py").read_text(encoding="utf-8")
KAN = (ENGINE / "kanbandb.py").read_text(encoding="utf-8")
CARD = (ENGINE / "templates" / "asset_card.html").read_text(encoding="utf-8")
SUPPLY = (ENGINE / "templates" / "supply.html").read_text(encoding="utf-8")
BOARD = (ENGINE / "templates" / "kanban.html").read_text(encoding="utf-8")


def test_popg_and_cto_are_for_mprp_only():
    assert "('ПОПГ', 'ПОПГ', NULL, 180, false" in SQL
    assert "('ЧТО',  'ЧТО',  NULL, 365, false" in SQL
    assert "'mprp', 'month25'" in SQL
    assert "(t.category_code IS NULL OR t.category_code = c.code)" in DB


def test_month25_horizon():
    assert month25_horizon(date(2026, 9, 24)) == date(2026, 9, 30)
    assert month25_horizon(date(2026, 9, 25)) == date(2026, 10, 31)
    assert month25_horizon(date(2026, 12, 25)) == date(2027, 1, 31)
    assert month25_horizon(date(2026, 1, 31)) == date(2026, 2, 28)


def test_three_steps_are_guarded_by_the_database():
    fill = SQL[SQL.index("FUNCTION maintenance_request_fill"):]
    assert "has_perm('maintenance.do')" in fill[:3000]
    assert "Примечание для специалиста обязательно" in fill[:3000]
    sched = SQL[SQL.index("FUNCTION maintenance_request_schedule"):]
    assert "has_perm('maintenance.plan')" in sched[:2500]
    assert "p_planned < current_date" in sched[:2500]
    assert "Выберите подрядчика из реестра" in sched[:2500]
    done = SQL[SQL.index("FUNCTION maintenance_request_done"):]
    assert "v_req.status <> 'scheduled'" in done[:2000]
    #  Право формировать — только у администрации
    assert "r.code IN ('admin', 'hq_analyst') AND p.code = 'maintenance.plan'" in SQL


def test_specialist_service_needs_a_request():
    body = DB[DB.index("def mark_maintenance_done("):]
    body = body[:body.index("\ndef ")]
    assert 'mtype["announce"] == "month25" and request_id is None and not initial' in body
    assert "app.maintenance_request_done" in body


def test_only_administration_fixes_and_drops_marks():
    assert "CREATE POLICY maintenance_fix ON maintenance FOR UPDATE" in SQL
    assert "CREATE POLICY maintenance_drop ON maintenance FOR DELETE" in SQL
    assert "DROP POLICY IF EXISTS maintenance_write ON maintenance" in SQL
    assert "'maintenance_fix'" in DB and "'maintenance_drop'" in DB
    assert "/supply/maintenance/{{ m.id }}/fix" in CARD
    assert "{% if can_plan %}" in CARD


def test_board_buttons_replace_done():
    assert action_label("maint_request", "ТО-2 — заполнить заявку") == "Заполнить заявку"
    assert action_label("hq_maint", "") == "Сформировать заявку"
    assert action_label("maint_visit", "Провести ТО-2 — ООО, 26.09.2026") == "Пройти ТО-2"
    assert action_label("repair", "Приезд специалиста 25.09.2026 — отметить ремонт") == "Произведён ремонт"
    assert action_label("hq_specialist", "") == "Вызвать специалиста"
    assert action_label("maintenance", "Провести ТО-1") is None
    assert "task_action(t.kind, t.title)" in BOARD


def test_administration_calls_the_specialist():
    assert "FUNCTION repair_call_specialist" in SQL
    assert "CREATE TRIGGER repair_specialist_guard" in SQL
    assert 'key=f"hq_specialist:{r[\'id\']}"' in KAN
    assert "/supply/repair/{{ r.id }}/specialist" in SUPPLY


def test_new_equipment_gets_last_service_dates():
    assert "def _initial_maintenance(" in DB
    assert 'name="last_at_to1"' in SUPPLY and 'name="last_at_popg"' in SUPPLY
    assert "initial=True" in DB


def test_needs_replacement_leaves_the_schedule_but_repair_stays():
    assert "a.status NOT IN ('written_off', 'needs_replacement')" in DB


def test_maintenance_log_pages_by_twenty():
    web = (ENGINE / "webapp.py").read_text(encoding="utf-8")
    assert "LOG_PAGE = 20" in web
    assert "show={{ log_next }}" in SUPPLY
