from django.db import models


class InfraccionSinPagar(models.Model):
    folio_infraccion = models.IntegerField(primary_key=True, db_column='FOLIO_INFRACCION')
    serie_infraccion = models.CharField(max_length=25, db_column='SERIE_INFRACCION')
    rfc_infractor = models.CharField(max_length=15, db_column='RFC_INFRACTOR')
    curp_infractor = models.CharField(max_length=18, db_column='CURP_INFRACTOR')
    ape_paterno_infractor = models.CharField(max_length=30, db_column='APE_PATERNO_INFRACTOR')
    ape_materno_infractor = models.CharField(max_length=30, db_column='APE_MATERNO_INFRACTOR')
    nombre_infractor = models.CharField(max_length=30, db_column='NOMBRE_INFRACTOR')
    numero_licencia = models.CharField(max_length=30, db_column='NUMERO_LICENCIA')
    monto_infraccion = models.FloatField(db_column='MONTO_INFRACCION')
    fecha_infraccion = models.DateField(db_column='FECHA_INFRACCION')
    concepto_infraccion = models.TextField(db_column='CONCEPTO_INFRACCION')
    ley_infraccion = models.TextField(db_column='LEY_INFRACCION')
    estatus_pago = models.CharField(max_length=9, db_column='ESTATUS_PAGO')

    class Meta:
        verbose_name = "Infraccion Sin Pagar"
        verbose_name_plural = "Infracciones Sin Pagar"
        db_table = "V_INFRACCIONES_SIN_PAGAR"

    def __unicode__(self):
        return u'%d - %s %s %s - %s [%s]' % (self.folio_infraccion, self.nombre_infractor, self.ape_paterno_infractor, self.ape_materno_infractor, self.concepto_infraccion, self.estatus_pago)


class InfraccionCondonada(models.Model):
    id = models.IntegerField(primary_key=True, db_column="ID")
    folio_infraccion = models.IntegerField(db_column="FOLIO_INFRACCION")
    fecha_movimiento = models.DateField(auto_now_add=True, db_column='FECHA_MOVIMIENTO')
    comentarios = models.TextField(db_column="COMENTARIOS")

    class Meta:
        verbose_name = "Infraccion Condonada"
        verbose_name_plural = "Infracciones Condonadas"
        db_table = 'infracciones_condonada'

    def __str__(self):
        return u'%d' % self.folio_infraccion