from __future__ import unicode_literals
from django.db import models
from django.contrib.auth.models import User
from collections import OrderedDict

# Choice Fields :

RELACAO_PESSOA_PESSOA = (

    (0, 'Filho(a)'),
    (1, 'Pai'),
    (2, 'Mãe'),
    (3, 'Casado(a)'),
    (4, 'Viúvo(a)'),
    (5, 'Parente'),
)

ESTADOS_CIVIS = (

    ('Solteiro(a)', 'Solteiro(a)'),
    ('Casado(a)', 'Casado(a)'),
    ('Viúvo(a)', 'Viúvo(a)'),
    ('Divorciado(a)', 'Divorciado(a)'),

    )

class Ccir(models.Model):

    cod_ccir = models.AutoField(primary_key=True)
    codigo_imovel_rural = models.CharField(max_length=150, blank=True, null=True)
    area_total_hec = models.CharField(max_length=150, blank=True, null=True)
    nun_modulos_rurais = models.CharField(max_length=150, blank=True, null=True)
    modulo_fiscal_hec = models.CharField(max_length=150, blank=True, null=True)
    num_modulo_fiscais = models.CharField(max_length=150, blank=True, null=True)
    fmp_hec = models.CharField(max_length=150, blank=True, null=True)
    valor_cobrado = models.CharField(max_length=150, blank=True, null=True)
    valor_total = models.CharField(max_length=150, blank=True, null=True)
    documento = models.CharField(max_length=150, blank=True, null=True)
    declarante = models.CharField(max_length=150, blank=True, null=True)
    status = models.CharField(max_length=150, blank=True, null=True)
    created_user = models.CharField(max_length=765, blank=True, null=True)
    created_date = models.DateTimeField(blank=True, null=True)
    last_edited_user = models.CharField(max_length=765, blank=True, null=True)
    last_edited_date = models.DateTimeField(blank=True, null=True)

    documentos = models.ManyToManyField(
        'Doc',
        through = 'Ccir_Doc'
        )

    pessoas = models.ManyToManyField(
        'Pessoa',
        through = 'Ccir_Pessoa'
        )

class Ccir_Doc(models.Model):
    cod_ccir = models.ForeignKey('Ccir', on_delete=models.CASCADE)
    cod_doc = models.ForeignKey('Doc', on_delete=models.CASCADE)

class Ccir_Pessoa(models.Model):
    cod_ccir = models.ForeignKey('Ccir', on_delete=models.CASCADE)
    cod_pessoa = models.ForeignKey('Pessoa', on_delete=models.CASCADE)

class Pessoa(models.Model):
    cod_pessoa = models.AutoField(primary_key=True, verbose_name="Cód. Pessoa")
    nome = models.CharField(max_length=150, blank=True, null=True, verbose_name="Nome")
    estado_civil = models.CharField(choices = ESTADOS_CIVIS, default = 'Solteiro(a)', max_length = 255, verbose_name="Estado Civil")
    endereço = models.CharField(max_length=150, blank=True, null=True, verbose_name="Endereço")
    telefone = models.CharField(max_length=150, blank=True, null=True, verbose_name="Telefone")
    email = models.CharField(max_length=150, blank=True, null=True, verbose_name="Email")
    rg = models.CharField(max_length=150, blank=True, null=True, verbose_name="RG")
    created_user = models.CharField(max_length=765, blank=True, null=True)
    created_date = models.DateTimeField(blank=True, null=True)
    last_edited_user = models.CharField(max_length=765, blank=True, null=True)
    last_edited_date = models.DateTimeField(blank=True, null=True)

    relacoes = models.ManyToManyField(
        'self',
        through = 'Pessoa_Pessoa', #This lets you define the model that will act as an intermadiary
        symmetrical = False, #This needs to be set with recursive relationships
        )

    itrs = models.ManyToManyField(
        'Itr',
        through = 'Pessoa_Itr',
        )

class Pessoa_Pessoa(models.Model):
    cod_pessoa_1 = models.ForeignKey('Pessoa', on_delete=models.CASCADE,
        related_name='%(class)s_cod_pessoa_1', verbose_name="Pessoa 1")
    cod_pessoa_2 = models.ForeignKey('Pessoa', on_delete=models.CASCADE,
        related_name='%(class)s_cod_pessoa_2', verbose_name="Pessoa 2")
    relacao = models.IntegerField(choices = RELACAO_PESSOA_PESSOA, default = 5, verbose_name="Relação")

class Pessoa_Itr(models.Model):
    cod_pessoa = models.ForeignKey('Pessoa', on_delete=models.CASCADE)
    cod_itr = models.ForeignKey('Itr', on_delete=models.CASCADE)

    #class Meta:
        #db_table = '"GEO"."django_pessoa_itr"'

class Itr(models.Model):
    cod_itr = models.AutoField(primary_key=True)
    nirf = models.CharField(max_length=150, blank=True, null=True)
    nome_imovel = models.CharField(max_length=150, blank=True, null=True)
    area_hec = models.CharField(max_length=150, blank=True, null=True)
    emissao_cn = models.CharField(max_length=150, blank=True, null=True)
    validade_cn = models.CharField(max_length=150, blank=True, null=True)
    declarante = models.CharField(max_length=150, blank=True, null=True)
    status = models.CharField(max_length=150, blank=True, null=True)
    municipio = models.CharField(max_length=150, blank=True, null=True)
    uf = models.CharField(max_length=150, blank=True, null=True)
    created_user = models.CharField(max_length=765, blank=True, null=True)
    created_date = models.DateTimeField(blank=True, null=True)
    last_edited_user = models.CharField(max_length=765, blank=True, null=True)
    last_edited_date = models.DateTimeField(blank=True, null=True)

class Doc(models.Model):
    cod_doc = models.AutoField(primary_key=True)
    tipo = models.CharField(max_length=150, blank=True, null=True)
    num_documento = models.CharField(max_length=150, blank=True, null=True)
    registro_averbacao = models.CharField(max_length=150, blank=True, null=True)
    registro_anterior = models.CharField(max_length=150, blank=True, null=True)
    area_doc = models.CharField(max_length=150, blank=True, null=True)
    comarca = models.CharField(max_length=150, blank=True, null=True)
    municipio = models.CharField(max_length=150, blank=True, null=True)
    uf = models.CharField(max_length=150, blank=True, null=True)
    tipo_imovel = models.CharField(max_length=150, blank=True, null=True)
    contrato_eol = models.CharField(max_length=150, blank=True, null=True)
    created_user = models.CharField(max_length=765, blank=True, null=True)
    created_date = models.DateTimeField(blank=True, null=True)
    last_edited_user = models.CharField(max_length=765, blank=True, null=True)
    last_edited_date = models.DateTimeField(blank=True, null=True)
    status = models.CharField(max_length=150, blank=True, null=True)

    pessoas = models.ManyToManyField(
        'Pessoa',
        through = 'Doc_Pessoa',
        )

class Doc_Pessoa(models.Model):
    cod_doc = models.ForeignKey('Doc', on_delete=models.CASCADE)
    cod_pessoa = models.ForeignKey('Pessoa', on_delete=models.CASCADE)
    percentual_area = models.IntegerField()
    rid = models.IntegerField()
    valor_area = models.IntegerField()