from django.db import models
from datetime import datetime
from apps.especies.models import Especies

class PeriodoColetaManager(models.Manager):
    def get_queryset(self):
        return super().get_queryset()
    
# Tabela de Produção de Mudas
class ProducaoMudas(models.Model):
    especie = models.ForeignKey(Especies, on_delete=models.CASCADE, null=True)
    beneficiamento_sementes = models.TextField(max_length=800, blank=True)
    substrato_muda = models.TextField(max_length=800, blank=True)
    desenvolvimento_muda_viveiro = models.CharField(max_length=100, blank=True)
    numero_sementes_por_kg = models.PositiveIntegerField(null=True, blank=True)
    armazenamento = models.CharField(max_length=250, blank=True)
    semeadura = models.CharField(max_length=100, blank=True)
    nivel_sombreamento_muda_viveiro = models.DecimalField(
        max_digits=5, decimal_places=2, null=True, blank=True)
    objects = models.Manager()

# Tabela de Período de Coleta
class PeriodoColeta(models.Model):
    especie = models.ForeignKey(Especies, on_delete=models.CASCADE, null=True)
    bioma_nome = models.CharField(max_length=150)
    mes_inicio = models.CharField(max_length=150)
    mes_fim = models.CharField(max_length=150)
    objects = PeriodoColetaManager()

# Tabela de Porcentagem de Coleta
class PorcentagemColeta(models.Model):
    especie = models.ForeignKey(Especies, on_delete=models.CASCADE, null=True)
    valor_minimo = models.DecimalField(max_digits=5, decimal_places=0)
    valor_maximo = models.DecimalField(max_digits=5, decimal_places=0)
    descricao = models.CharField(max_length=100)
    objects = models.Manager()