from datetime import datetime

employee_db = [
    {
        "employee_id": "EMP001",
        "employee_name": "Jonathan",
        "department": "Engineering",
        "annual_leave_quota": 21,
        "annual_leave_used": 5,
    },
    {
        "employee_id": "EMP002",
        "employee_name": "Andi Saputra",
        "department": "Finance",
        "annual_leave_quota": 21,
        "annual_leave_used": 10,
    },
    {
        "employee_id": "EMP003",
        "employee_name": "Budi Santoso",
        "department": "HR",
        "annual_leave_quota": 21,
        "annual_leave_used": 2,
    },
    {
        "employee_id": "EMP004",
        "employee_name": "Dewi Lestari",
        "department": "Admin",
        "annual_leave_quota": 21,
        "annual_leave_used": 2,
    }
]



leave_db = [
    {
        "id": "LV001",
        "employee_id": "EMP001",
        "employee_name": "Jonathan",
        "leave_type": "annual",
        "start_date": "2026-05-20",
        "end_date": "2026-05-22",
        "reason": "Family vacation",
        "created_at": datetime.now()
    },
    {
        "id": "LV002",
        "employee_id": "EMP002",
        "employee_name": "Andi Saputra",
        "leave_type": "sick",
        "start_date": "2026-05-25",
        "end_date": "2026-05-26",
        "reason": "Fever and flu",
        "created_at": datetime.now()
    }
]


permit_db = [
    {
        "id": "PR001",
        "employee_id": "EMP003",
        "employee_name": "Budi Santoso",
        "permit_type": "medical",
        "permit_date": "2026-05-18",
        "start_time": "09:00",
        "end_time": "11:00",
        "reason": "Dental appointment",
        "created_at": datetime.now()
    },
    {
        "id": "PR002",
        "employee_id": "EMP004",
        "employee_name": "Dewi Lestari",
        "permit_type": "personal",
        "permit_date": "2026-05-19",
        "start_time": "13:00",
        "end_time": "15:00",
        "reason": "Family event",
        "created_at": datetime.now()
    }
]


presence_db = [
    {
        "id": "PS001",
        "employee_id": "EMP001",
        "employee_name": "Jonathan",
        "check_in": "2026-05-18T08:00:00",
        "check_out": "2026-05-18T17:00:00",
        "status": "present",
        "created_at": datetime.now()
    },
    {
        "id": "PS002",
        "employee_id": "EMP002",
        "employee_name": "Andi Saputra",
        "check_in": "2026-05-18T08:20:00",
        "check_out": "2026-05-18T17:05:00",
        "status": "late",
        "created_at": datetime.now()
    }
]