from django.db import models
from dilicom.models import Collection
from datetime import date
today = date.today()

# Create your models here.
class ArticleIgescom(models.Model):
    id_article_igescom = models.AutoField(primary_key=True)
    code_taxe = models.CharField(null=True,max_length=200)
    code_ta= models.CharField(null=True,max_length=200)
    code_sr= models.CharField(null=True,max_length=200)
    stock_min_gen = models.FloatField(null=True)
    stock_max_gen = models.FloatField(null=True)
    stock_phy_gen = models.FloatField(null=True)
    code_ma = models.FloatField(null=True)
    code_fa= models.CharField(null=True,max_length=200)
    code_ray= models.CharField(null=True,max_length=200)
    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_dilicom = models.FloatField(null=True)
    prix_TTC_article = models.FloatField(null=True)
    prix_article_igescom= models.FloatField(null=True)
    date_creation_article = models.DateField(null=True,default=today.strftime("%Y-%m-%d"))
    collection_article = models.CharField(null=True, max_length=200)