# Certificate PDF + calendar (.ics) helpers
import secrets
from io import BytesIO
from xml.sax.saxutils import escape

from django.core.files.base import ContentFile
from django.utils import timezone
from reportlab.lib import colors
from reportlab.lib.pagesizes import A4, landscape
from reportlab.pdfgen import canvas

from People.common import next_seq

from .models import TrainingCertificate


def render_certificate_pdf(company_name, holder, title, program_title, issued_on, cert_no, code, expiry=None):
    buf = BytesIO()
    w, h = landscape(A4)
    c = canvas.Canvas(buf, pagesize=(w, h))
    c.setStrokeColor(colors.HexColor("#4f46e5"))
    c.setLineWidth(6)
    c.rect(18, 18, w - 36, h - 36)
    c.setLineWidth(1)
    c.rect(30, 30, w - 60, h - 60)
    c.setFillColor(colors.HexColor("#111827"))
    c.setFont("Helvetica-Bold", 14)
    c.drawCentredString(w / 2, h - 80, company_name.upper())
    c.setFont("Helvetica-Bold", 34)
    c.setFillColor(colors.HexColor("#4f46e5"))
    c.drawCentredString(w / 2, h - 140, "CERTIFICATE OF COMPLETION")
    c.setFillColor(colors.HexColor("#374151"))
    c.setFont("Helvetica", 14)
    c.drawCentredString(w / 2, h - 190, "This is to certify that")
    c.setFillColor(colors.HexColor("#111827"))
    c.setFont("Helvetica-Bold", 30)
    c.drawCentredString(w / 2, h - 240, holder)
    c.setFillColor(colors.HexColor("#374151"))
    c.setFont("Helvetica", 14)
    c.drawCentredString(w / 2, h - 285, "has successfully completed")
    c.setFillColor(colors.HexColor("#111827"))
    c.setFont("Helvetica-Bold", 20)
    c.drawCentredString(w / 2, h - 320, title)
    if program_title and program_title != title:
        c.setFont("Helvetica", 12)
        c.drawCentredString(w / 2, h - 345, f"Programme: {program_title}")
    c.setFont("Helvetica", 11)
    c.setFillColor(colors.HexColor("#4b5563"))
    line = f"Issued on {issued_on.strftime('%d %B %Y')}" + (f"  |  Valid till {expiry.strftime('%d %B %Y')}" if expiry else "")
    c.drawCentredString(w / 2, 100, line)
    c.setFont("Helvetica", 9)
    c.drawCentredString(w / 2, 78, f"Certificate No: {cert_no}   |   Verification code: {code}")
    c.showPage()
    c.save()
    return buf.getvalue()


def issue_certificate(company, employee, program, enrollment, actor, title=None, issued_on=None):
    """Create a TrainingCertificate (+PDF). Returns the existing issued one if present."""
    if enrollment is not None:
        ex = TrainingCertificate.objects.filter(enrollment=enrollment, status="Issued", is_active=True).first()
        if ex:
            return ex, False
    issued_on = issued_on or timezone.localdate()
    ttl = title or (program.certificate_title if program and program.certificate_title else None) \
        or (f"{program.title} Certificate" if program else "Training Certificate")
    expiry = None
    if program and program.certificate_validity_months:
        m = issued_on.month - 1 + program.certificate_validity_months
        import calendar
        y, mo = issued_on.year + m // 12, m % 12 + 1
        expiry = issued_on.replace(year=y, month=mo, day=min(issued_on.day, calendar.monthrange(y, mo)[1]))
    no = next_seq(TrainingCertificate, company, "certificate_no", f"CERT-{issued_on.year}-")
    cert = TrainingCertificate.objects.create(
        company=company, employee=employee, program=program, enrollment=enrollment, certificate_no=no,
        verification_code=secrets.token_hex(6).upper(), title=ttl, issued_on=issued_on, expiry_date=expiry,
        issued_by=actor, created_by=actor, updated_by=actor)
    pdf = render_certificate_pdf(company.Registered_Company_Name or company.Brand_Name or "Company", employee.name,
                                 ttl, program.title if program else None, issued_on, no, cert.verification_code, expiry)
    cert.file.save(f"{no}.pdf", ContentFile(pdf), save=True)
    return cert, True


def session_ics(session, company_name=""):
    """RFC-5545 calendar entry for 'Add to Outlook'."""
    def fmt(d, t):
        return f"{d.strftime('%Y%m%d')}T{(t or session.start_time).strftime('%H%M%S')}"
    start_t = session.start_time or timezone.datetime.min.time()
    end_t = session.end_time or start_t
    lines = ["BEGIN:VCALENDAR", "VERSION:2.0", f"PRODID:-//{company_name or 'HRMS'}//Training//EN", "CALSCALE:GREGORIAN",
             "METHOD:PUBLISH", "BEGIN:VEVENT", f"UID:training-session-{session.pk}@hrms",
             f"DTSTAMP:{timezone.now().strftime('%Y%m%dT%H%M%SZ')}",
             f"DTSTART;TZID=Asia/Kolkata:{session.session_date.strftime('%Y%m%d')}T{start_t.strftime('%H%M%S')}",
             f"DTEND;TZID=Asia/Kolkata:{session.session_date.strftime('%Y%m%d')}T{end_t.strftime('%H%M%S')}",
             f"SUMMARY:{session.title}"]
    if session.location:
        lines.append(f"LOCATION:{session.location}")
    desc = (session.program.title if session.program_id else "") + (f"\\nJoin: {session.meeting_link}" if session.meeting_link else "")
    lines += [f"DESCRIPTION:{desc}", "END:VEVENT", "END:VCALENDAR"]
    return "\r\n".join(lines) + "\r\n"
