# from django.core.management.base import BaseCommand
# from django.core.mail import EmailMessage
# from django.utils import timezone
# from datetime import timedelta
# from users.models import ClientTravelInsurance, EmailSetup, ReportEmail


# class Command(BaseCommand):
#     help = "Send travel insurance expiry report emails for next week"

#     def handle(self, *args, **kwargs):
#         today = timezone.localdate()

#         # Current Saturday
#         saturday = today + timedelta((5 - today.weekday()) % 7)  # Saturday = 5

#         # Next Monday
#         monday = saturday + timedelta(days=(7 - saturday.weekday() + 0))  # Monday = 0

#         # Next Sunday
#         sunday = monday + timedelta(days=6)

#         # Fetch travel insurance expiring next week
#         insurances = ClientTravelInsurance.objects.filter(
#             ref_client__client_status=1,
#             insurance_to_date__month__gte=monday.month,
#             insurance_to_date__day__gte=monday.day,
#             insurance_to_date__month__lte=sunday.month,
#             insurance_to_date__day__lte=sunday.day,
#         ).select_related("ref_client")

#         if not insurances.exists():
#             self.stdout.write(self.style.WARNING("No travel insurance expiries found for next week."))
#             return

#         report_duration = f"Upcoming Travel Insurance Expiry (From {monday.strftime('%d-%m-%Y')} to {sunday.strftime('%d-%m-%Y')})"

#         # Build email content as HTML table
#         email_content = f"<h2>MyValueTrip</h2><p>{report_duration}</p>"
#         email_content += "<table border='1' cellpadding='5' cellspacing='0'>"
#         email_content += "<tr><th>Client Name</th><th>Expiry Date</th></tr>"

#         for t in insurances:
#             client = t.ref_client
#             client_name = f"{client.client_salutation or ''} {client.client_first_name or ''} {client.client_middle_name or ''} {client.client_last_name or ''}".strip()
#             expiry_formatted = t.insurance_to_date.strftime("%d-%m-%Y")
#             email_content += f"<tr><td>{client_name}</td><td>{expiry_formatted}</td></tr>"

#         email_content += "</table>"

#         # Fetch recipients from ReportEmail table for travel insurance expiry
#         recipients = ReportEmail.objects.filter(
#             setup__report_type="insurance_expiry"
#         ).values_list("email", flat=True)

#         if not recipients:
#             self.stdout.write(self.style.WARNING("No recipient configured for travel insurance expiry."))
#             return

#         # Send email via SMTP
#         email = EmailMessage(
#             subject="Upcoming Travel Insurance Expiry Report",
#             body=email_content,
#             to=list(recipients),
#         )
#         email.content_subtype = "html"

#         try:
#             email.send()
#             self.stdout.write(self.style.SUCCESS(f"Travel insurance expiry report sent to: {', '.join(recipients)}"))
#         except Exception as e:
#             self.stderr.write(self.style.ERROR(f"Failed to send travel insurance expiry email: {e}"))


from django.core.management.base import BaseCommand
from django.core.mail import EmailMessage
from django.utils import timezone
from datetime import timedelta
from users.models import ClientTravelInsurance, EmailSetup
import logging
import os

# Log file for debug
log_file = os.path.join(os.path.dirname(os.path.abspath(__file__)), 'insurance_report.log')
logging.basicConfig(filename=log_file, level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')

class Command(BaseCommand):
    help = "Send travel insurance expiry report emails for next week"

    def handle(self, *args, **kwargs):
        try:
            today = timezone.localdate()
            # Current Saturday (weekday 5)
            saturday = today + timedelta((5 - today.weekday()) % 7)
            # Next Monday (weekday 0)
            monday = saturday + timedelta(days=(7 - saturday.weekday()))
            # Next Sunday
            sunday = monday + timedelta(days=6)

            # Fetch travel insurance expiring next week
            insurances = ClientTravelInsurance.objects.filter(
                ref_client__client_status=1,
                insurance_to_date__gte=monday,
                insurance_to_date__lte=sunday,
            ).select_related("ref_client")

            report_duration = f"Upcoming Travel Insurance Expiry (From {monday.strftime('%d-%m-%Y')} to {sunday.strftime('%d-%m-%Y')})"

            # Build email content as HTML table
            email_content = f"<h2>MyValueTrip</h2><p>{report_duration}</p>"
            email_content += "<table border='1' cellpadding='5' cellspacing='0'>"
            email_content += "<tr><th>Sr. No.</th><th>Client Name</th><th>Expiry Date</th></tr>"

            for idx, t in enumerate(insurances, start=1):
                client = t.ref_client
                client_name = f"{client.client_salutation or ''} {client.client_first_name or ''} {client.client_middle_name or ''} {client.client_last_name or ''}".strip()
                expiry_formatted = t.insurance_to_date.strftime("%d-%m-%Y")
                email_content += f"<tr><td>{idx}<td>{client_name}</td><td>{expiry_formatted}</td></tr>"

            email_content += "</table>"

            # Fetch recipients for Travel Insurance Expiry
            recipients = EmailSetup.objects.filter(
                report_type="Travel Insurance Expiry"
            ).values_list("email", flat=True)

            if not recipients:
                logging.warning("No recipient configured for Travel Insurance Expiry.")
                return

            # Send email
            email = EmailMessage(
                subject="Upcoming Travel Insurance Expiry Report",
                body=email_content,
                to=list(recipients),
            )
            email.content_subtype = "html"
            email.send()

            logging.info(f"Travel insurance expiry report sent to: {', '.join(recipients)}")
        except Exception as e:
            logging.error(f"Failed to send travel insurance expiry email: {e}")