from django.db import models
from datetime import date

today = date.today()
# Create your models here.

class Collection(models.Model):
    id_collection = models.AutoField(primary_key=True)
    nom_collection = models.CharField(max_length=200, null=True)

class Type_article(models.Model):
    id_type_article = models.AutoField(primary_key=True)
    libelle_type_article = models.CharField(max_length=200, null=True)

class Editeur(models.Model):
    id_editeur = models.AutoField(primary_key=True)
    nom_editeur = models.CharField(max_length=200, null=True)

class Distributeur(models.Model):
    id_distrib =models.AutoField(primary_key=True)
    nom_distrib = models.CharField(max_length=200, null=True)
    adresse_distrib = models.CharField(max_length=200, null=True)

class Contributeur(models.Model):
    id_contributeur = models.AutoField(primary_key=True)
    nom_contributeur = models.CharField(max_length=200, null=True)

class Article(models.Model):
    id_article = models.AutoField(primary_key=True)
    ref_dilicom_article = models.CharField(max_length=200, null=True)
    nom_article = models.CharField(max_length=200, null=True)
    description_article = models.TextField(null=True)
    poids_article = models.IntegerField(null=True)
    code_EAN13_article = models.CharField(max_length=200, null=True)
    disponibilite_article = models.CharField(max_length=200, null=True)
    prix_HT_article = models.FloatField(null=True)
    prix_TTC_article = models.FloatField(null=True)
    date_creation_article = models.DateField(null=True,default=today.strftime("%Y-%m-%d"))
    id_collection = models.ForeignKey(Collection, on_delete=models.CASCADE,null=True)
    id_type_article =models.ForeignKey(Type_article, on_delete=models.CASCADE,null=True)

class Edition(models.Model):
    id_editeur = models.ForeignKey(Editeur, on_delete=models.CASCADE)
    id_article = models.ForeignKey(Article, on_delete=models.CASCADE)
    date_fin_edition = models.CharField(max_length=200, null=True)
    date_edition = models.CharField(max_length=200,null=True)

class Distribution(models.Model):
    id_distrib = models.ForeignKey(Distributeur, on_delete=models.CASCADE)
    id_article = models.ForeignKey(Article, on_delete=models.CASCADE)
    statut_dist= models.IntegerField(null=True)

class Participation(models.Model):
    id_contributeur = models.ForeignKey(Contributeur, on_delete=models.CASCADE)
    id_article = models.ForeignKey(Article, on_delete=models.CASCADE)
    role= models.CharField(max_length=200, null=True)

class Operation(models.Model):
    id_operation = models.AutoField(primary_key=True)
    date_operation = models.DateField(null=True,default=today.strftime("%Y-%m-%d"))
    utilisateur = models.TextField(null=False)