from django.db import models
from django.utils.translation import gettext_lazy as _
from django.utils.text import slugify

class CrawlerSource(models.Model):
    name = models.CharField(_("Name"), max_length=255)
    url = models.URLField(_("URL"))
    is_active = models.BooleanField(_("Active"), default=True)
    last_crawled_at = models.DateTimeField(_("Last Crawled At"), null=True, blank=True)
    
    def __str__(self):
        return self.name
    
    class Meta:
        verbose_name = _("Crawler Source")
        verbose_name_plural = _("Crawler Sources")

class CrawledDevelopment(models.Model):

    source = models.ForeignKey(CrawlerSource, on_delete=models.CASCADE, related_name="developments")
    external_id = models.CharField(_("External ID"), max_length=255, null=True, blank=True)
    reference_id = models.CharField(_("Reference ID"), max_length=150, db_index=True, null=True, blank=True)
    title = models.CharField(_("Title"), max_length=150, db_index=True)
    slug = models.SlugField(_("Slug"), max_length=250, db_index=True, null=True, blank=True)
    address = models.CharField(_("Address"), max_length=250, null=True, blank=True)
    base_price = models.IntegerField(_("Base Price"), default=0)
    
    # فیلدهای مرتبط با موقعیت جغرافیایی
    latitude = models.FloatField(_("Latitude"), null=True, blank=True)
    longitude = models.FloatField(_("Longitude"), null=True, blank=True)
    country_code = models.CharField(_("Country Code"), max_length=10, null=True, blank=True)
    city_name = models.CharField(_("City Name"), max_length=100, null=True, blank=True)
    
    is_active = models.BooleanField(_("Active"), default=True)
    is_sold_out = models.BooleanField(_("Sold Out"), default=False)
    completed_status = models.IntegerField(_("Completed Status"), default=0)
    completed_date = models.CharField(_("Completed Date"), max_length=255, null=True, blank=True)
    
    is_synced = models.BooleanField(_("Synced"), default=False)
    last_sync_at = models.DateTimeField(_("Last Sync At"), null=True, blank=True)
    sync_status = models.IntegerField(_("Sync Status"), default=0, choices=[
        (0, _("Not Synced")),
        (1, _("Pending")),
        (2, _("Synced")),
        (3, _("Failed")),
        (4, _("Rejected")),
    ])
    sync_message = models.TextField(_("Sync Message"), null=True, blank=True)
    
    raw_data = models.JSONField(_("Raw Data"), null=True, blank=True)
    
    created_at = models.DateTimeField(_("Created At"), auto_now_add=True)
    updated_at = models.DateTimeField(_("Updated At"), auto_now=True)
    
    def save(self, *args, **kwargs):
        if self.title and not self.slug:
            self.slug = slugify(self.title, allow_unicode=True)
        super().save(*args, **kwargs)
    
    def __str__(self):
        return self.title
    
    class Meta:
        verbose_name = _("Crawled Development")
        verbose_name_plural = _("Crawled Developments")
        ordering = ["-updated_at"]

class CrawledFlat(models.Model):
    development = models.ForeignKey(CrawledDevelopment, on_delete=models.CASCADE, related_name="flats")
    external_id = models.CharField(_("External ID"), max_length=255, null=True, blank=True)
    bedrooms_num = models.IntegerField(_("Bedrooms Number"), default=0)
    bathrooms_num = models.IntegerField(_("Bathrooms Number"), default=0)
    area = models.FloatField(_("Area"), default=0)
    base_price = models.FloatField(_("Base Price"), default=0)
    price_per_meter = models.FloatField(_("Price Per Meter"), default=0)
    is_sold_out = models.BooleanField(_("Sold Out"), default=False)
    
    raw_data = models.JSONField(_("Raw Data"), null=True, blank=True)
    
    is_synced = models.BooleanField(_("Synced"), default=False)
    last_sync_at = models.DateTimeField(_("Last Sync At"), null=True, blank=True)
    sync_status = models.IntegerField(_("Sync Status"), default=0, choices=[
        (0, _("Not Synced")),
        (1, _("Pending")),
        (2, _("Synced")),
        (3, _("Failed")),
        (4, _("Rejected")),
    ])
    
    created_at = models.DateTimeField(_("Created At"), auto_now_add=True)
    updated_at = models.DateTimeField(_("Updated At"), auto_now=True)
    
    def __str__(self):
        return f"{self.development.title} - {self.bedrooms_num} BR"
    
    class Meta:
        verbose_name = _("Crawled Flat")
        verbose_name_plural = _("Crawled Flats")

class CrawledAttachment(models.Model):
    development = models.ForeignKey(CrawledDevelopment, on_delete=models.CASCADE, related_name="attachments")
    external_id = models.CharField(_("External ID"), max_length=255, null=True, blank=True)
    file_url = models.URLField(_("File URL"))
    file_type = models.IntegerField(_("File Type"), default=0, choices=[
        (0, _("Image")),
        (1, _("Video")),
        (2, _("Audio")),
        (3, _("Document")),
        (4, _("Video URL")),
        (5, _("Audio URL")),
        (6, _("Document URL")),
    ])
    category = models.IntegerField(_("Category"), default=0, choices=[
        (0, _("Public")),
        (1, _("Exterior")),
        (2, _("Interior")),
        (3, _("Amenities")),
        (4, _("Floor Plans")),
        (5, _("Site Plans")),
        (6, _("Flat Plans")),
        (7, _("Street View")),
    ])
    title = models.CharField(_("Title"), max_length=255, null=True, blank=True)
    
    is_synced = models.BooleanField(_("Synced"), default=False)
    last_sync_at = models.DateTimeField(_("Last Sync At"), null=True, blank=True)
    
    created_at = models.DateTimeField(_("Created At"), auto_now_add=True)
    updated_at = models.DateTimeField(_("Updated At"), auto_now=True)
    
    def __str__(self):
        return f"{self.development.title} - {self.get_file_type_display()}"
    
    class Meta:
        verbose_name = _("Crawled Attachment")
        verbose_name_plural = _("Crawled Attachments")

class SyncLog(models.Model):
    
    development = models.ForeignKey(CrawledDevelopment, on_delete=models.CASCADE, related_name="sync_logs", null=True, blank=True)
    flat = models.ForeignKey(CrawledFlat, on_delete=models.CASCADE, related_name="sync_logs", null=True, blank=True)
    attachment = models.ForeignKey(CrawledAttachment, on_delete=models.CASCADE, related_name="sync_logs", null=True, blank=True)
    
    sync_type = models.IntegerField(_("Sync Type"), choices=[
        (0, _("Create")),
        (1, _("Update")),
        (2, _("Delete")),
    ])
    status = models.IntegerField(_("Status"), choices=[
        (0, _("Pending")),
        (1, _("Success")),
        (2, _("Failed")),
        (3, _("Rejected")),
    ])
    message = models.TextField(_("Message"), null=True, blank=True)
    response_data = models.JSONField(_("Response Data"), null=True, blank=True)
    
    created_at = models.DateTimeField(_("Created At"), auto_now_add=True)
    
    def __str__(self):
        if self.development:
            return f"{self.development.title} - {self.get_sync_type_display()}"
        elif self.flat:
            return f"{self.flat.development.title} Flat - {self.get_sync_type_display()}"
        elif self.attachment:
            return f"{self.attachment.development.title} Attachment - {self.get_sync_type_display()}"
        return f"Sync Log {self.id}"
    
    class Meta:
        verbose_name = _("Sync Log")
        verbose_name_plural = _("Sync Logs")
        ordering = ["-created_at"]