from django.db import models
from django.contrib.auth.models import User
from django.utils import timezone

from Company.models import company_details


# ============================================================
# SUPER ADMIN
# ============================================================

class SuperAdminProfile(models.Model):

    user = models.OneToOneField(
        User,
        on_delete=models.CASCADE,
        related_name="superadmin_profile"
    )

    full_name = models.CharField(
        max_length=150
    )

    email = models.EmailField(
        unique=True
    )

    phone_number = models.CharField(
        max_length=15,
        blank=True,
        null=True
    )

    is_active = models.BooleanField(
        default=True
    )

    created_at = models.DateTimeField(
        auto_now_add=True
    )

    updated_at = models.DateTimeField(
        auto_now=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )

    def __str__(self):

        return self.full_name


# ============================================================
# SUPERADMIN COMPANY ASSIGNMENT
# ============================================================

class SuperAdminCompany(models.Model):

    superadmin = models.ForeignKey(
        SuperAdminProfile,
        on_delete=models.CASCADE,
        related_name="companies"
    )

    company = models.OneToOneField(
        company_details,
        on_delete=models.CASCADE,
        related_name="superadmin_assignment"
    )

    assigned_at = models.DateTimeField(
        auto_now_add=True
    )

    is_active = models.BooleanField(
        default=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )

    def __str__(self):

        return (
            f"{self.superadmin.full_name} - "
            f"{self.company}"
        )


# ============================================================
# COMPANY ADMIN
# ============================================================

class CompanyAdmin(models.Model):

    company = models.ForeignKey(
        company_details,
        on_delete=models.CASCADE,
        related_name="company_admins"
    )

    user = models.OneToOneField(
        User,
        on_delete=models.CASCADE,
        related_name="company_admin_profile"
    )

    employee = models.OneToOneField(
        "Employee.EmployeeDT",
        on_delete=models.SET_NULL,
        blank=True,
        null=True,
        related_name="company_admin"
    )

    admin_name = models.CharField(
        max_length=150
    )

    email = models.EmailField()

    is_active = models.BooleanField(
        default=True
    )

    created_at = models.DateTimeField(
        auto_now_add=True
    )

    updated_at = models.DateTimeField(
        auto_now=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )

    def __str__(self):

        return (
            f"{self.admin_name} - "
            f"{self.company}"
        )


# ============================================================
# COMPANY USAGE
# ============================================================

class CompanyUsage(models.Model):

    company = models.OneToOneField(
        company_details,
        on_delete=models.CASCADE,
        related_name="usage"
    )

    total_employees = models.PositiveIntegerField(
        default=0
    )

    active_employees = models.PositiveIntegerField(
        default=0
    )

    inactive_employees = models.PositiveIntegerField(
        default=0
    )

    total_admins = models.PositiveIntegerField(
        default=0
    )

    total_hr_users = models.PositiveIntegerField(
        default=0
    )

    total_devices = models.PositiveIntegerField(
        default=0
    )

    last_calculated = models.DateTimeField(
        auto_now=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )
    is_active = models.BooleanField(
        default=True,
    )

    def __str__(self):

        return (
            f"{self.company} Usage"
        )

    def refresh(self):

        self.total_employees = (
            self.company.total_employees()
        )

        self.active_employees = (
            self.company.active_employees()
        )

        self.inactive_employees = (
            self.company.inactive_employees()
        )

        self.total_admins = (
            self.company.company_admins
            .filter(is_active=True)
            .count()
        )

        self.save()


# ============================================================
# SUPERADMIN AUDIT LOG
# ============================================================

class SuperAdminAuditLog(models.Model):

    ACTION_CHOICES = [

        ("CREATE_COMPANY", "Create Company"),

        ("UPDATE_COMPANY", "Update Company"),

        ("ACTIVATE_COMPANY", "Activate Company"),

        ("DEACTIVATE_COMPANY", "Deactivate Company"),

        ("SUSPEND_COMPANY", "Suspend Company"),

        ("DELETE_COMPANY", "Delete Company"),

        ("CREATE_ADMIN", "Create Admin"),

        ("UPDATE_ADMIN", "Update Admin"),

        ("CREATE_ROLE", "Create Role"),

        ("UPDATE_ROLE", "Update Role"),

        ("OTHER", "Other"),
    ]

    superadmin = models.ForeignKey(
        SuperAdminProfile,
        on_delete=models.SET_NULL,
        blank=True,
        null=True,
        related_name="audit_logs"
    )

    company = models.ForeignKey(
        company_details,
        on_delete=models.SET_NULL,
        blank=True,
        null=True,
        related_name="superadmin_audit_logs"
    )

    action = models.CharField(
        max_length=50,
        choices=ACTION_CHOICES
    )

    description = models.TextField(
        blank=True,
        null=True
    )

    ip_address = models.GenericIPAddressField(
        blank=True,
        null=True
    )

    created_at = models.DateTimeField(
        auto_now_add=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )
    is_active = models.BooleanField(
        default=True,
    )

    def __str__(self):

        return (
            f"{self.action} - "
            f"{self.created_at}"
        )


# ============================================================
# COMPANY SUBSCRIPTION HISTORY
# ============================================================

class CompanySubscription(models.Model):

    PLAN_CHOICES = [
        ("FREE", "Free"),
        ("BASIC", "Basic"),
        ("PRO", "Professional"),
        ("ENTERPRISE", "Enterprise"),
    ]

    company = models.ForeignKey(
        company_details,
        on_delete=models.CASCADE,
        related_name="subscription_history"
    )

    plan = models.CharField(
        max_length=20,
        choices=PLAN_CHOICES
    )

    employee_limit = models.PositiveIntegerField(
        default=10
    )

    admin_limit = models.PositiveIntegerField(
        default=1
    )

    device_limit = models.PositiveIntegerField(
        default=1
    )

    start_date = models.DateField()

    end_date = models.DateField(
        blank=True,
        null=True
    )

    amount = models.DecimalField(
        max_digits=12,
        decimal_places=2,
        default=0
    )

    is_active = models.BooleanField(
        default=True
    )

    created_at = models.DateTimeField(
        auto_now_add=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )

    def __str__(self):

        return (
            f"{self.company} - "
            f"{self.plan}"
        )


# ============================================================
# SUPERADMIN PLATFORM SETTINGS
# ============================================================

class SuperAdminSettings(models.Model):

    platform_name = models.CharField(
        max_length=150,
        default="HRMS"
    )

    support_email = models.EmailField(
        blank=True,
        null=True
    )

    support_phone = models.CharField(
        max_length=20,
        blank=True,
        null=True
    )

    default_employee_limit = models.PositiveIntegerField(
        default=10
    )

    default_admin_limit = models.PositiveIntegerField(
        default=1
    )

    default_hr_limit = models.PositiveIntegerField(
        default=2
    )

    default_device_limit = models.PositiveIntegerField(
        default=1
    )

    default_trial_days = models.PositiveIntegerField(
        default=14
    )

    allow_new_company_registration = models.BooleanField(
        default=True
    )

    maintenance_mode = models.BooleanField(
        default=False
    )

    updated_at = models.DateTimeField(
        auto_now=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )
    is_active = models.BooleanField(
        default=True,
    )

    def __str__(self):

        return self.platform_name  
        
        

# ============================================================
# SUBSCRIPTION PACKAGE
# Additive model for selling HRMS packages to companies
# ============================================================

class SubscriptionPackage(models.Model):

    PLAN_CHOICES = [
        ("FREE", "Free"),
        ("BASIC", "Basic"),
        ("PRO", "Professional"),
        ("ENTERPRISE", "Enterprise"),
    ]

    BILLING_CHOICES = [
        ("MONTHLY", "Monthly"),
        ("YEARLY", "Yearly"),
        ("CUSTOM", "Custom"),
    ]

    # --------------------------------------------------------
    # BASIC INFORMATION
    # --------------------------------------------------------

    name = models.CharField(
        max_length=100
    )

    code = models.CharField(
        max_length=30,
        unique=True
    )

    plan = models.CharField(
        max_length=20,
        choices=PLAN_CHOICES,
        default="FREE"
    )

    description = models.TextField(
        blank=True,
        null=True
    )

    # --------------------------------------------------------
    # PRICING
    # --------------------------------------------------------

    monthly_price = models.DecimalField(
        max_digits=12,
        decimal_places=2,
        default=0
    )

    yearly_price = models.DecimalField(
        max_digits=12,
        decimal_places=2,
        default=0
    )

    billing_cycle = models.CharField(
        max_length=20,
        choices=BILLING_CHOICES,
        default="MONTHLY"
    )

    # --------------------------------------------------------
    # LIMITS
    # --------------------------------------------------------

    employee_limit = models.PositiveIntegerField(
        default=10
    )

    admin_limit = models.PositiveIntegerField(
        default=1
    )

    hr_limit = models.PositiveIntegerField(
        default=1
    )

    device_limit = models.PositiveIntegerField(
        default=1
    )

    # --------------------------------------------------------
    # TRIAL
    # --------------------------------------------------------

    trial_days = models.PositiveIntegerField(
        default=14
    )

    # --------------------------------------------------------
    # FEATURES
    # --------------------------------------------------------

    attendance_enabled = models.BooleanField(
        default=True
    )

    leave_enabled = models.BooleanField(
        default=True
    )

    payroll_enabled = models.BooleanField(
        default=False
    )

    recruitment_enabled = models.BooleanField(
        default=False
    )

    performance_enabled = models.BooleanField(
        default=False
    )

    employee_self_service = models.BooleanField(
        default=False
    )

    reports_enabled = models.BooleanField(
        default=True
    )

    api_access_enabled = models.BooleanField(
        default=False
    )

    audit_logs_enabled = models.BooleanField(
        default=True
    )

    # --------------------------------------------------------
    # PACKAGE STATUS
    # --------------------------------------------------------

    is_active = models.BooleanField(
        default=True
    )

    is_public = models.BooleanField(
        default=True
    )

    sort_order = models.PositiveIntegerField(
        default=0
    )

    created_at = models.DateTimeField(
        auto_now_add=True
    )

    updated_at = models.DateTimeField(
        auto_now=True
    )

    # ---- audit fields (additive) ----
    created_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who created this record (e.g. admin:<id> / employee:<id>)",
    )
    updated_by = models.CharField(
        max_length=150,
        null=True,
        blank=True,
        help_text="Who last updated this record (e.g. admin:<id> / employee:<id>)",
    )
    id_version = models.PositiveIntegerField(
        default=1,
        help_text="Record version counter",
    )

    # --------------------------------------------------------
    # STRING
    # --------------------------------------------------------

    def __str__(self):

        return self.name


# ---- ADDITIVE: platform panel models (registration, billing, RBAC) ----
from .platform_models import *  # noqa: E402,F401,F403


# ---- ADDITIVE: Book-a-Demo requests (website form) ----
from .demo_models import DemoRequest  # noqa: E402,F401


    