# ADDITIVE tests - direct eSSL/ZK device pull + .xls import      python manage.py test People.tests_essl_direct
import os
from datetime import datetime, timedelta
from types import SimpleNamespace
from unittest import mock

from django.core.files.uploadedfile import SimpleUploadedFile
from django.utils import timezone

from Employee.models import EMP_check_in_check_out
from People.att_models import BiometricEnrollment, BiometricPunch
from People.essl_direct_models import BiometricDeviceLink
from People.tests_att import ABase, H

REAL_XLS = "/mnt/user-data/uploads/WorkDurationReportFourPunch10022026.xls"


class FakeConn:
    def __init__(self, logs):
        self.logs = logs

    def get_attendance(self):
        return self.logs

    def get_serialnumber(self):
        return "CDQ123456"

    get_device_name = lambda self: "eSSL X990"
    get_firmware_version = lambda self: "Ver 6.60"
    get_time = lambda self: datetime(2026, 10, 28, 10, 0)
    disconnect = lambda self: None


class FakeZK:
    def __init__(self, logs):
        self.logs = logs

    def connect(self):
        return FakeConn(self.logs)


def rec(uid, ts):
    return SimpleNamespace(user_id=uid, timestamp=ts, status=1, punch=0, uid=1)


class DirectDeviceTests(ABase):
    def setUp(self):
        super().setUp()
        d = self.admin.post(f"{H}/devices/", {"name": "eSSL Main Door", "vendor": "eSSL", "ip_address": "192.168.1.201", "port": 80}, format="json")
        self.assertEqual(d.status_code, 201, d.json())
        self.dev = d.json()["data"]["id"]
        BiometricEnrollment.objects.create(company=self.co, employee=self.asha, biometric_id="7", created_by="t", updated_by="t")
        self.day = timezone.localdate() - timedelta(days=1)

    def logs(self):
        n = lambda h, m: datetime(self.day.year, self.day.month, self.day.day, h, m)
        return [rec("7", n(9, 5)), rec("7", n(18, 10)), rec("99", n(9, 30))]

    def test_connection_credentials_are_write_only(self):
        r = self.admin.patch(f"{H}/devices/{self.dev}/connection/", {"comm_key": "1234", "zk_port": 4370, "direction_mode": "auto"}, format="json")
        self.assertEqual(r.status_code, 200, r.json())
        data = r.json()["data"]
        self.assertTrue(data["comm_key_set"])
        self.assertNotIn("1234", str(data))
        self.assertNotEqual(BiometricDeviceLink.objects.get(device_id=self.dev).comm_key_enc, "1234")
        self.assertEqual(self.admin.patch(f"{H}/devices/{self.dev}/connection/", {"comm_key": "abc"}, format="json").status_code, 400)

    def test_pull_is_idempotent_and_reconciles(self):
        with mock.patch("People.essl_direct._zk", return_value=FakeZK(self.logs())):
            r = self.admin.post(f"{H}/devices/{self.dev}/pull/", {}, format="json")
            self.assertEqual(r.status_code, 200, r.json())
            run = r.json()["data"]["run"]
            self.assertEqual((run["status"], run["rows_fetched"], run["reconciled"], run["unmatched"]), ("Success", 3, 2, 1))
            rec_ = EMP_check_in_check_out.objects.get(company=self.co, Employee_ID="EMP001", login_date=self.day)
            self.assertEqual((rec_.login_time[:5], rec_.logout_time[:5]), ("09:05", "18:10"))
            before = BiometricPunch.objects.count()
            again = self.admin.post(f"{H}/devices/{self.dev}/pull/", {}, format="json").json()["data"]["run"]
            self.assertEqual(again["rows_fetched"], 0)
            self.assertEqual(BiometricPunch.objects.count(), before)
            link = BiometricDeviceLink.objects.get(device_id=self.dev)
            link.cursor_time = None
            link.save()
            self.admin.post(f"{H}/devices/{self.dev}/pull/", {}, format="json")        # full re-read: still no duplicates
            self.assertEqual(BiometricPunch.objects.count(), before)
            self.assertEqual(EMP_check_in_check_out.objects.filter(company=self.co, Employee_ID="EMP001", login_date=self.day).count(), 1)

    def test_connection_test_and_errors(self):
        with mock.patch("People.essl_direct._zk", return_value=FakeZK([])):
            t = self.admin.post(f"{H}/devices/{self.dev}/connection/test/", {}, format="json").json()["data"]
        self.assertEqual((t["connected"], t["serial_number"]), (True, "CDQ123456"))
        with mock.patch("People.essl_direct._zk", side_effect=ValueError("timed out")):
            run = self.admin.post(f"{H}/devices/{self.dev}/pull/", {}, format="json").json()["data"]["run"]
        self.assertEqual((run["status"], run["error"]), ("Error", "timed out"))

    def test_permissions_and_isolation(self):
        for u in (f"{H}/devices/{self.dev}/pull/", f"{H}/devices/pull-all/", f"{H}/devices/{self.dev}/connection/test/"):
            self.assertEqual(self.cl["view"].post(u, {}, format="json").status_code, 403, u)
            self.assertEqual(self.cl["str"].post(u, {}, format="json").status_code, 403, u)
        self.assertEqual(self.other_admin.post(f"{H}/devices/{self.dev}/pull/", {}, format="json").status_code, 404)

    def test_xls_import_dry_run_then_import(self):
        if not os.path.exists(REAL_XLS):
            self.skipTest("sample .xls not available")
        body = open(REAL_XLS, "rb").read()
        up = lambda: SimpleUploadedFile("r.xls", body)
        r = self.admin.post(f"{H}/essl/import/xls/", {"file": up(), "dry_run": "true"}, format="multipart")
        self.assertEqual(r.status_code, 200, r.json())
        self.assertEqual(r.json()["data"]["report"]["employees_in_report"], 75)
        self.assertEqual(BiometricPunch.objects.count(), 0)
        bad = self.admin.post(f"{H}/essl/import/xls/", {"file": SimpleUploadedFile("x.xls", b"not excel")}, format="multipart")
        self.assertEqual(bad.status_code, 400)
        r = self.admin.post(f"{H}/essl/import/xls/", {"file": up(), "dry_run": "false", "employee_map": '{"4": "EMP001"}', "day_status": "none"}, format="multipart")
        self.assertEqual(r.status_code, 201, r.json())
        first = BiometricPunch.objects.count()
        self.assertGreater(first, 0)
        self.admin.post(f"{H}/essl/import/xls/", {"file": up(), "dry_run": "false", "employee_map": '{"4": "EMP001"}', "day_status": "none"}, format="multipart")
        self.assertEqual(BiometricPunch.objects.count(), first)
