# ============================================================
# ADDITIVE: Per-company SMTP (outgoing mail) - models.  Imported at the bottom of People/models.py.
#
#   CompanyEmailConfig  one SMTP account of ONE company (many allowed: e.g. one for employees, one for candidates)
#   CompanyEmailLog     one row per recipient of every mail sent through a company SMTP (no body stored)
#
# Passwords are stored ENCRYPTED (People/mail_crypto.py) and are never returned by any API.
# ============================================================
from django.db import models

from Company.models import company_details
from Employee.models import EmployeeDT


class CompanyEmailConfig(models.Model):
    AUDIENCES = [("ALL", "Employees & Candidates"), ("EMPLOYEE", "Employees only"), ("CANDIDATE", "Candidates only")]
    SECURITY = [("SSL", "SSL/TLS (usually port 465)"), ("STARTTLS", "STARTTLS (usually port 587)"),
                ("NONE", "No encryption (not recommended)")]

    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="email_configs")
    name = models.CharField(max_length=80)
    name_key = models.CharField(max_length=80, editable=False)                       # lower-case name -> no duplicates per company
    audience = models.CharField(max_length=10, choices=AUDIENCES, default="ALL", db_index=True)
    host = models.CharField(max_length=255)
    port = models.PositiveIntegerField(default=465)
    security = models.CharField(max_length=10, choices=SECURITY, default="SSL")
    username = models.CharField(max_length=254, blank=True, default="")
    password_enc = models.TextField(blank=True, default="")                         # Fernet token, never plain text
    from_email = models.EmailField(max_length=254)
    from_name = models.CharField(max_length=100, blank=True, default="")
    reply_to = models.EmailField(max_length=254, blank=True, default="")
    timeout_seconds = models.PositiveSmallIntegerField(default=20)
    daily_limit = models.PositiveIntegerField(default=500)                          # recipients per day, 0 = unlimited
    is_default = models.BooleanField(default=False)                                 # default for its audience
    enabled = models.BooleanField(default=True)
    mailbox_key = models.CharField(max_length=320, editable=False, db_index=True)   # host|username (or from address)
    last_test_at = models.DateTimeField(null=True, blank=True)
    last_test_ok = models.BooleanField(null=True, blank=True)
    last_test_message = models.CharField(max_length=300, blank=True, default="")
    created_by = models.CharField(max_length=150, null=True, blank=True)
    updated_by = models.CharField(max_length=150, null=True, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        unique_together = (("company", "name_key"), ("company", "mailbox_key"))     # DB-level duplicate protection
        ordering = ["company_id", "audience", "-is_default", "id"]


class CompanyEmailLog(models.Model):
    company = models.ForeignKey(company_details, on_delete=models.CASCADE, related_name="email_logs")
    config = models.ForeignKey(CompanyEmailConfig, null=True, blank=True, on_delete=models.SET_NULL, related_name="logs")
    config_name = models.CharField(max_length=80, blank=True, default="")           # snapshot, survives config deletion
    from_email = models.CharField(max_length=254, blank=True, default="")
    recipient_type = models.CharField(max_length=10, default="EMPLOYEE")            # EMPLOYEE | CANDIDATE
    employee = models.ForeignKey(EmployeeDT, null=True, blank=True, on_delete=models.SET_NULL,
                                 related_name="received_email_logs")
    to_email = models.CharField(max_length=254, db_index=True)
    subject = models.CharField(max_length=250, blank=True, default="")
    kind = models.CharField(max_length=40, blank=True, default="general")
    status = models.CharField(max_length=10, default="SENT", db_index=True)         # SENT | FAILED
    via = models.CharField(max_length=20, default="COMPANY_SMTP")                   # COMPANY_SMTP | GLOBAL_FALLBACK
    error = models.CharField(max_length=500, blank=True, default="")
    sent_by = models.CharField(max_length=150, blank=True, default="")
    batch_id = models.CharField(max_length=36, blank=True, default="")
    created_at = models.DateTimeField(auto_now_add=True, db_index=True)

    class Meta:
        ordering = ["-id"]
        indexes = [models.Index(fields=["company", "created_at"])]


class CompanyWelcomeMail(models.Model):
    """What the automatic 'your login is ready' mail contains - editable per company (dynamic, nothing hard-coded)."""
    company = models.OneToOneField(company_details, on_delete=models.CASCADE, related_name="welcome_mail_settings")
    enabled = models.BooleanField(default=True)              # send automatically when a candidate is converted to an employee
    include_password = models.BooleanField(default=True)
    include_salary = models.BooleanField(default=True)
    fields = models.JSONField(default=list, blank=True)      # ordered details block, [] = standard set
    subject = models.CharField(max_length=150, default="Welcome to {company} - your login details")
    intro = models.TextField(default="Dear {name},\n\nWelcome to {company}! Your employee login has been created. "
                                     "Your joining details are below.")
    footer = models.TextField(default="Please keep these details safe and change your password after the first login.\n\n"
                                      "Regards,\nHR Team, {company}")
    login_url = models.CharField(max_length=255, blank=True, default="")      # blank = settings.SITE_BASE_URL
    updated_by = models.CharField(max_length=150, null=True, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)
