from django.db import models
import time
from django.contrib.auth.models import User
from PIL import Image

# Create your models here.

class Usuario(models.Model):
    id_anfitriao = models.IntegerField(null=True)
    id_pertence = models.IntegerField(null=True)
    contacto = models.CharField(max_length=9,null=True)
    primeiro_nome = models.CharField(max_length=50,null=True)
    apelido = models.CharField(max_length=50,null=True)
    provincia = models.CharField(max_length=100,null=True)
    imagem = models.ImageField(upload_to='usuarios',null=True)
    tipo_de_conta = models.CharField(max_length=20,null=True)
    type_sys = models.CharField(max_length=100,null=True,default='normal')
    

    # conta
    data_inicio = models.CharField(max_length=20,null=True)
    seguranca = models.CharField(max_length=20,null=True)
    tema = models.CharField(max_length=20,null=True)
    status_trabalho = models.CharField(max_length=20,null=True,default='habilitado')
    feixo = models.CharField(max_length=20,null=True,default='desabilitado')
    supervisor = models.CharField(max_length=20,null=True,default='na')

    # automacao horarios de entrada
    hora_entrada_seg = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_seg = models.CharField(max_length=20,null=True,default='12:00')
    hora_entrada_ter = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_ter = models.CharField(max_length=20,null=True,default='12:00')
    hora_entrada_qua = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_qua = models.CharField(max_length=20,null=True,default='12:00')
    hora_entrada_qui = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_qui = models.CharField(max_length=20,null=True,default='12:00')
    hora_entrada_sex = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_sex = models.CharField(max_length=20,null=True,default='12:00')
    hora_entrada_sab = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_sab = models.CharField(max_length=20,null=True,default='12:00')
    hora_entrada_dom = models.CharField(max_length=20,null=True,default='07:40')
    hora_saida_dom = models.CharField(max_length=20,null=True,default='12:00')

    # plano
    pacote = models.CharField(max_length=50,default='basico')

    #pagamentos
    
    status_pagamento = models.CharField(max_length=50,default='activo')
    data_pagamento = models.CharField(max_length=20,null=True)
    data_validade_pagamento = models.CharField(max_length=20,null=True)
    mensalidade_pagamento = models.IntegerField(null=True,default=1500)


    # funcionalidades
    typeview_caixa = models.IntegerField(default=0)


    def __str__(self):
        nome = User.objects.get(id=self.id_pertence)
        nome = nome.username
        return nome
        
    # def save(self,*args,**kwargs):
    #     super().save(*args,**kwargs)
    #     try:
    #         img = Image.open(self.imagem.path)
    #         if img.height > 300 or img.weight > 300:
    #             output_size = (600,600)
    #             img.thumbnail(output_size)
    #             img.save(self.imagem.path)
    #     except:
        
    #             output_size = (600,600)
    #             img.thumbnail(output_size)
    #             img.save(self.imagem.path)


    

class Clientes(models.Model):
    id_anfitriao = models.IntegerField(null=True)
    id_pertence = models.IntegerField(null=True)

    assunto = models.CharField(max_length=40,null=True)
    data = models.CharField(max_length=20)
    datas_anteriores = models.CharField(max_length=40)