from django.db import models  

from apps.common.models import BaseModel
from apps.channels.models import Channel




class AnalyticsSource(models.TextChoices):
    Sfr = "Sfr"
    Bouygues = "Bouygues"
    Prediction = "Prediction"
    Impressions = "Impressions"


class Analytics(BaseModel):  

    channel = models.ForeignKey(Channel, on_delete=models.SET_NULL, null=True)

    region = models.CharField(max_length=255, blank=True, null=True)

    day = models.DateField(blank=True, null=True)
    
    cible = models.CharField(max_length=255, blank=True, null=True)
    indicateur = models.CharField(max_length=255, blank=True, null=True)
    minute = models.CharField(max_length=255, blank=True, null=True)
    purcent = models.CharField(max_length=255, blank=True, null=True)

    source = models.CharField(
        max_length=255,
        choices=AnalyticsSource.choices,
        blank=True,
        null=True
    )

    class Meta: 
        db_table = 'Analytics'
 
 
class Impressions(BaseModel): 
    tool_name = models.CharField(max_length=255)
    total_users = models.IntegerField()
    market_share_purcent = models.FloatField(blank=True, null=True)
    region = models.CharField(max_length=255)

    class Meta : 
        db_table = "SFR_market_share"