from pathlib import Path

from timesheet import rmbdb


ROOT = Path(__file__).resolve().parents[2]
ENGINE = ROOT / "engine" / "timesheet"


def test_rmb_domain_keeps_location_stage_and_responsible_separate():
    sql = (ROOT / "sql" / "142_defect_rmb_core.sql").read_text(encoding="utf-8")
    confirmation_sql = (ROOT / "sql" / "143_rmb_discount_confirmation.sql").read_text(
        encoding="utf-8")
    service_sql = (ROOT / "sql" / "144_rmb_service_workflow.sql").read_text(
        encoding="utf-8")
    supplier_sql = (ROOT / "sql" / "145_rmb_supplier_return.sql").read_text(encoding="utf-8")
    manager_source_sql = (ROOT / "sql" / "146_rmb_manager_sources.sql").read_text(
        encoding="utf-8")

    assert "physical_location_type" in sql
    assert "case_status" in sql
    assert "assigned_user_id" in sql
    assert "defect_rmb_case" in sql
    assert "defect_rmb_task" in sql
    assert "defect_rmb_event" in sql
    assert "defect_rmb_rework_request" in sql
    assert "repeat_of_event_id" in sql
    assert "handler_event_id" in sql and "UNIQUE" in sql
    assert "external_action_confirmed" in confirmation_sql
    assert "direction <> 'discount'" in confirmation_sql
    assert "не выполняет автосверку" in confirmation_sql
    assert "defect_rmb_service" in service_sql
    assert "SC-01" in service_sql and "SC-18" in service_sql
    assert "warehouse_received_at" in service_sql
    assert "универсальный норматив 14 дней не применяется" in service_sql
    assert "defect_rmb_supplier_return" in supplier_sql
    assert "transferred_at" in supplier_sql and "supplier_received_at" in supplier_sql
    assert "defect_rmb_manager_source" in manager_source_sql
    assert "defect_rmb_manager_item" in manager_source_sql
    assert "raw_data" in manager_source_sql
    assert "source_sheet = 'РМ'" in manager_source_sql


def test_rmb_routes_and_screens_are_wired():
    web = (ENGINE / "webapp.py").read_text(encoding="utf-8")
    nav = (ENGINE / "templates" / "_defect_nav.html").read_text(encoding="utf-8")
    page = (ENGINE / "templates" / "defect_rmb.html").read_text(encoding="utf-8")
    settings = (ENGINE / "templates" / "defect_rmb_settings.html").read_text(
        encoding="utf-8")

    assert '@app.get("/defects/rmb"' in web
    assert '@app.post("/defects/rmb/cases/{case_id}/decision")' in web
    assert '@app.post("/defects/rmb/tasks/{task_id}/action")' in web
    assert '@app.post("/defects/rmb/cases/{case_id}/close")' in web
    assert '@app.get("/defects/rmb/settings"' in web
    assert '@app.post("/defects/rmb/settings/specialists")' in web
    assert '@app.post("/defects/rmb/service/{task_id}/action")' in web
    assert '@app.post("/defects/rmb/supplier-return/{task_id}/action")' in web
    assert '@app.post("/defects/rmb/bulk")' in web
    assert '@app.post("/defects/rmb/bulk/decision")' in web
    assert '@app.post("/defects/rmb/tasks/bulk")' in web
    assert "rmbdb.ensure_case_from_handler" in web
    assert 'href="/defects/rmb"' in nav
    assert "Физически" in page
    assert "Этап" in page
    assert "Действует сейчас" in page
    assert "Вернуть на складскую дообработку" in page
    assert "Общая очередь группы" in page
    assert "сведения об уценке внесены в 1С" in page
    assert "автоматически с этим делом не сверяется" in page
    assert "Создать специалиста" in settings
    assert "Сервисное событие" in page
    assert "Физически в сервисе" in page
    assert "Событие возврата поставщику" in page
    assert 'action="/defects/rmb/settings/specialists"' in settings
    assert 'action="/defects/rmb/settings/team-roster"' in settings
    assert 'action="/defects/rmb/settings/manager-sources"' in settings
    assert "Номенклатура → менеджер" in settings
    assert "Группы специалистов" in settings
    assert 'name="manager"' in page
    assert 'name="specialist"' in page
    assert 'id="rmb-bulk-form"' in page
    assert "Применить к выбранным" in page
    assert "Обработать по шаблону" in page
    assert "Решение по шаблону" in page
    assert 'data-copy-value="{{ row.external_unit_key }}"' in page
    assert 'href="/defects/handler/{{ row.handler_event_id }}/edit"' not in page
    assert 'href="/defects/handler/{{ row.rework_handler_event_id }}/edit"' not in page
    assert 'id="rmb-task-dialog"' in page
    assert 'id="rmb-manager-decision-dialog"' in page
    assert "Синхронизированные рабочие файлы" in page
    assert callable(rmbdb.bulk_update_cases)


def test_rmb_bulk_ui_is_explicit_and_supports_controlled_templates():
    page = (ENGINE / "templates" / "defect_rmb.html").read_text(encoding="utf-8")
    script = (ENGINE / "static" / "rmb.js").read_text(encoding="utf-8")

    assert 'form="rmb-bulk-form"' in page
    assert 'data-rmb-select-all' in page
    assert 'name="priority"' in page
    assert 'name="due_at"' in page
    assert 'name="specialist_user_id"' in page
    assert 'action="/defects/rmb/bulk/decision"' in page
    assert 'action="/defects/rmb/tasks/bulk"' in page
    assert "bulk_case_update" in (ENGINE / "rmbdb.py").read_text(encoding="utf-8")
    assert "window.confirm" in script
    assert "data-rmb-selected-inputs" in page
    assert "navigator.clipboard" in script
    assert callable(rmbdb.bulk_decide_cases)
    assert callable(rmbdb.bulk_task_action)


def test_rmb_statuses_do_not_mix_control_flags_with_main_state():
    assert "overdue" not in rmbdb.CASE_STATUS_LABELS
    assert "idle" not in rmbdb.CASE_STATUS_LABELS
    assert "reprocessing" in rmbdb.CASE_STATUS_LABELS
    assert "service" in rmbdb.DIRECTION_LABELS
    assert "service" in rmbdb.LOCATION_LABELS
    assert callable(rmbdb.create_specialist)
    assert callable(rmbdb.service_action)
    assert len(rmbdb.SERVICE_STATUS_LABELS) == 18
    assert callable(rmbdb.supplier_return_action)
    assert callable(rmbdb.manager_sources_for_user)
    assert len(rmbdb.SUPPLIER_STATUS_LABELS) == 14


def test_manager_sheet_url_is_limited_to_google_sheet_gid():
    spreadsheet_id, gid, canonical = rmbdb.parse_manager_sheet_url(
        "https://docs.google.com/spreadsheets/d/abc_DEF-123/edit?gid=254370820#gid=254370820")
    assert spreadsheet_id == "abc_DEF-123"
    assert gid == 254370820
    assert canonical.endswith("edit?gid=254370820#gid=254370820")


def test_manager_sheet_parser_normalizes_known_fields_and_keeps_new_columns():
    payload = (
        "Наименование,СС,План, Статус,Результат,Дата,Дата,Местонахождение товра,Новое поле\n"
        '"10282794-БК-2528027, Чайник","22,80",БелВТИ,,,09.09.2026,,Брак Таборы,значение\n'
        '"9507068-БК-2492173, Жаровня","65,68",Распродажа,Заброшено в файл,'
        'Распродажа (выставлено),17.08.2026,12.10.2026,Брак Таборы,другое\n'
    ).encode("utf-8")
    parsed = rmbdb.parse_manager_source_csv(payload)
    active, completed = parsed["rows"]

    assert active["external_unit_key"] == "10282794-БК-2528027"
    assert str(active["unit_cost"]) == "22.80"
    assert active["normalized_direction"] == "service"
    assert active["normalized_state"] == "active"
    assert active["source_date"].isoformat() == "2026-09-09"
    assert active["raw_data"]["Новое поле"] == "значение"
    assert completed["normalized_direction"] == "discount"
    assert completed["normalized_state"] == "completed"
    assert completed["result_date"].isoformat() == "2026-10-12"


def test_default_team_roster_contains_six_distinct_pairs():
    assert len(rmbdb.DEFAULT_TEAM_ROSTER) == 6
    manager_emails = {row[2] for row in rmbdb.DEFAULT_TEAM_ROSTER}
    specialist_emails = {row[4] for row in rmbdb.DEFAULT_TEAM_ROSTER}
    assert len(manager_emails) == len(specialist_emails) == 6
    assert manager_emails.isdisjoint(specialist_emails)


def test_manager_filter_prefers_full_account_name_over_1c_abbreviation():
    options = rmbdb._manager_filter_options([
        {
            "manager_reference_id": 4,
            "manager_reference_name": "Хатляник НА",
            "manager_user_id": 14,
            "manager_name": "Хатляник Наташа",
        },
        {
            "manager_reference_id": 1,
            "manager_reference_name": "Босько МА",
            "manager_user_id": None,
            "manager_name": None,
        },
    ])

    assert options == [
        {"value": "ref:1", "label": "Босько МА · не сопоставлен"},
        {"value": "user:14", "label": "Хатляник Наташа"},
    ]
    assert all("учётная запись" not in item["label"] for item in options)


def test_login_is_branded_for_quality_and_claims_department():
    login = (ENGINE / "templates" / "login.html").read_text(encoding="utf-8")
    assert "Управление качеством товара и рекламациями" in login
    assert "Рабочее место брака" in login
    assert "Управление распределительной логистикой" not in login

