"""
«Доработка» от 24.09.2026 и правка карточки техники.
"""

import pathlib
from datetime import date
from decimal import Decimal

import openpyxl

ROOT = pathlib.Path(__file__).resolve().parents[2]
ENGINE = ROOT / "engine" / "timesheet"
T = ENGINE / "templates"
read = lambda p: p.read_text(encoding="utf-8")
WEB = read(ENGINE / "webapp.py")


def test_hire_button_sits_in_the_search_row():
    nav = read(T / "_staff_nav.html")
    assert "hire-btn" in nav and "{% if show_hire %}" in nav
    assert "{% set show_hire = can_write %}" in read(T / "staff.html")


def test_review_columns_and_flow():
    r = read(T / "review.html")
    assert ">График д/н<" in r and ">План д/н<" not in r
    assert ">Всего план<" not in r and ">Заявлено<" not in r
    assert r.index('<div class="review-flow">') < r.index("<h2>Разрез за")
    assert "{% if gaps and not can_approve %}" in r


def test_depot_board_has_no_single_tab():
    k = read(T / "kanban.html")
    at = k.index('<nav class="subtabs inline">')
    assert "{% if can_all %}" in k[at - 300:at]


def test_ppe_statement_one_day_and_annul():
    db = read(ENGINE / "staffdb.py")
    assert "Выбраны позиции с разными днями выдачи" in db
    assert "Дата составления ведомости должна совпадать с днём" in db
    assert "def annul_ppe_issue(" in db and "def annul_ppe_statement(" in db
    sql = read(ROOT / "sql" / "80_ppe_annul_nosize.sql")
    assert "'annulled'" in sql and "no_size" in sql
    card = read(T / "staff_card.html")
    assert card.index('id="ppe"') < card.index('id="statements"') < card.index('id="ppe-new"')
    assert '<details class="block fold-block" id="ppe-new">' in card
    #  06.10.2026 (правка заказчика): «Положены СИЗ по норме» —
    #  информативное окно, формы выдачи с no_size в нём больше нет
    #  (признак no_size остался в настройках нормы)


def test_settlement_returns_to_itself_and_shows_real_stages():
    s = read(T / "settlement.html")
    assert 'name="back_to" value="/settlement/{{ person.employment_id }}"' in s
    assert "'Депо проверяет', 'Отправлено администрации', 'Посчитано', 'Принято'" in s
    assert "/api/settlement/{{ person.employment_id }}/zp" in s
    assert 're.fullmatch(r"/settlement/\\d+", back_to or "")' in WEB


def test_zp_file_matches_the_template(tmp_path):
    from timesheet.zp_print import export_zp, TEMPLATE
    row = dict(fio_full="Рудковский Алексей Геннадьевич", personnel_no="3014950351",
               position_label="Кладовщик г.Гродно", amount_salary=Decimal("747.62"),
               amount_piecework=Decimal("1266.14"), amount_night=Decimal("53.33"),
               net_total=Decimal("2067.09"), hours_day=Decimal(101), hours_night=Decimal(56),
               gross_total=Decimal("2465.61"), gross_salary=Decimal("869.32"),
               gross_premium=Decimal("1534.27"), gross_night=Decimal("62.02"), kpis=[])
    out = tmp_path / "zp.xlsx"
    export_zp(str(out), date(2026, 8, 1), 168, [row])
    ws = openpyxl.load_workbook(out).active
    tpl = openpyxl.load_workbook(TEMPLATE).active
    assert ws["A3"].value == "августа" and ws["C3"].value == 168
    assert ws["A5"].value == "Рудковский Алексей Геннадьевич"
    assert abs(ws["K5"].value - 2067.10) < 0.02 and ws["P5"].value == 157
    assert ws["E1"].value == tpl["E1"].value == "Расчет чистыми"
    assert sorted(map(str, ws.merged_cells.ranges)) == sorted(map(str, tpl.merged_cells.ranges))
    #  В шаблоне приложения нет чужих данных
    assert tpl["A5"].value is None


def test_tabel_like_the_depot_files():
    body = WEB[WEB.index("def download_tabel("):]
    body = body[:body.index("\n\n\n")]
    assert 'org_unit="РЦ"' in body and "number=None" in body
    assert "responsible=chief" in body
    assert "position=f\"{r['position_name']} г.{u['name']}\"" in body


def test_asset_card_edit_unlocks_and_confirms():
    card = read(T / "asset_card.html")
    assert 'id="assetEdit"' in card and "Править" in card
    assert "Сохранить изменения в карточке" in card
    assert card.count(" disabled") >= 8
    sup = read(T / "supply.html")
    assert "{% if can_supply_write and not is_eq %}" in sup


def test_header_forklift_rides_the_line_and_can_be_switched_off():
    base = read(T / "base.html")
    css = read(ENGINE / "static" / "app.css")
    assert "{% set fl = header_forklift() %}" in base and "{% if fl != 'off' %}" in base
    assert "@keyframes forklift-in" in css
    assert ".topbar-forklift.fl-auto { animation: none; }" in css   # prefers-reduced-motion
    from timesheet.settingsdb import APP_SETTINGS
    opts = [v for s in APP_SETTINGS if s["code"] == "header_forklift" for v, _ in s["options"]]
    assert opts == ["auto", "on", "still", "off"]
    assert '_FORKLIFT_CACHE["at"] = 0.0' in WEB


def test_only_administration_edits_equipment_cards():
    card = read(T / "asset_card.html")
    assert card.count("{% if can_edit_card %}") == 2
    assert 'ctx["can_edit_card"] = (ctx["can_plan"] if card["is_equipment"]' in WEB
    assert WEB.count("_is_equipment_asset(conn") >= 2
    sql = read(ROOT / "sql" / "82_asset_card_hq.sql")
    assert "has_perm('maintenance.plan')" in sql and "BEFORE UPDATE OR DELETE ON asset" in sql
    #  отметка поверки депо не должна упираться в правило
    body = sql[sql.index("IS DISTINCT FROM"):]
    assert "verified_at" not in body[:400]


def test_warehouse_tech_always_has_meter():
    s = read(T / "settings.html")
    at = s.index("{% if g.code == 'warehouse_tech' %}")
    assert '<input type="hidden" name="has_meter" value="1">' in s[at:at + 200]
    db = read(ENGINE / "settingsdb.py")
    assert "if group_code == WAREHOUSE_TECH:\n        has_meter = True" in db
    sql = read(ROOT / "sql" / "84_warehouse_meter_required.sql")
    assert "CHECK (group_code IS DISTINCT FROM 'warehouse_tech' OR has_meter)" in sql


def test_initial_maintenance_does_not_block_deleting_a_card():
    sql = read(ROOT / "sql" / "85_maintenance_initial.sql")
    assert "ADD COLUMN IF NOT EXISTS is_initial boolean NOT NULL DEFAULT false" in sql
    db = read(ENGINE / "supplydb.py")
    body = db[db.index("def delete_asset("):db.index("def save_meter(")]
    assert "AND NOT d.is_initial" in body and "i.is_initial" in body
    assert 'DELETE FROM app.maintenance WHERE asset_id = %s' in body
    assert "performed_by, is_initial)" in db and "bool(initial)" in db


def test_card_marks_only_to1_without_a_dropdown():
    card = read(T / "asset_card.html")
    at = card.index('action="/supply/maintenance/done" class="row-form"')
    form = card[at:card.index("</form>", at)]
    assert "<select" not in form
    assert '<input type="hidden" name="type_id" value="{{ to1.id }}">' in form
    #  прошлое ТО со специалистом — отдельной кнопкой, только Администрации
    assert "{% if can_plan and spec_types %}" in card and "Внести прошлое ТО" in card
