from django.db import models

from management.models.fascicolo import Fascicolo
from management.models.tipo_commessa import TipoCommessa

class Pratica(models.Model):
    id = models.AutoField(primary_key=True)
    title = models.CharField(max_length=255, null=True, blank=True)
    commessa = models.ForeignKey(TipoCommessa, on_delete=models.SET_NULL, null=True, blank=True)
    tipologia = models.CharField(max_length=10, null=True, blank=True)
    fascicolo = models.ForeignKey(Fascicolo, on_delete=models.SET_NULL, null=True, blank=True)
    settimana_standard = models.JSONField(default=list, blank=True)
    mese_standard = models.JSONField(default=list, blank=True)
    anno_standard = models.JSONField(default=list, blank=True)
    tariffa = models.DecimalField(max_digits=9, decimal_places=2, default=0)
    spese = models.DecimalField(max_digits=9, decimal_places=2, default=0)
    data_ora_modifica = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "Master_pratiche"