class Celebration(models.Model):
    celebration_date = models.DateTimeField("Date de la célébration", null = True, blank = True)
    celebration_lieu = models.ForeignKey(Ville, verbose_name = "Ville", on_delete = models.PROTECT, null = True, blank = True)
    celebration_info = models.CharField("Info complémentaire", max_length = 20, null = True, blank = True)
    celebration_jour = models.CharField("Jour", max_length = 3, choices = JOUR_CHOICES, default = 'R03')
    celebration_celebrant = models.ForeignKey(Nom, verbose_name = "Célébrant", on_delete = models.PROTECT, null = True, blank = True)
    celebration_animateur = models.ForeignKey(Nom, verbose_name = "Animateur", on_delete = models.PROTECT, null = True, blank = True, related_name = '+')

    def __str__(self):
        return "%s à %s : %s" % (self.celebration_date, self.celebration_lieu, self.celebration_jour)

    class Meta:
        verbose_name = "Célébration"
        verbose_name_plural = "*02 - Célébrations*"
        ordering = ['celebration_date']

class Obseques(models.Model):
    obseques_acte_deces = models.CharField("Numéro du décès (ex : 2017.007)", max_length = 8, null = True, blank = True)
    obseques_nom = models.ForeignKey(Nom, verbose_name = "Nom", on_delete = models.PROTECT, null = False, blank = False, related_name = '+')
    obseques_inhu_crema = models.CharField("Inhumation/incinération", max_length = 1, choices = OBSEQUES_CHOICES, default = "C")
    obseques_date_inhu_crema = models.DateField("Date inhumation/incinération", null = True, blank = True)
    obseques_lieu_inhu_crema = models.ForeignKey(Ville, verbose_name = "Ville", on_delete = models.PROTECT, null = True, blank = True, related_name = '+')
    obseques_pompes_funebres = models.ForeignKey(Nom, verbose_name = "Pompes funèbres", on_delete = models.PROTECT, null = True, blank = True, related_name = '+')
    obseques_celebration = models.ForeignKey(Celebration, verbose_name = "Célébration", on_delete = models.PROTECT, null= True, blank = True)

    def __str__(self):
        return "%s %s" % (self.obseques_nom, self.obseques_celebration)

    class Meta:
        verbose_name = "Célébration des obsèques"
        verbose_name_plural = "*05 - Obsèques*"
        ordering = ['obseques_acte_deces', 'obseques_celebration']

class Remboursement(models.Model):
    remboursement_date = models.DateField("Déplacement fait le")
    remboursement_nb_kms = models.IntegerField("Nombre de kms")
    remboursement_prix_km = models.DecimalField("Prix du km", max_digits = 4, decimal_places = 2)
    remboursement_nom = models.ForeignKey(Nom, verbose_name = "Bénéficiaire", on_delete = models.PROTECT)
    remboursement_designe = models.CharField("Designation", max_length = 100, null = True, blank = True)

    def remboursement_tt_calc(self):
        return self.remboursement_prix_km * self.remboursement_nb_kms

    remboursement_tt_calc.description = 'Total'
    remboursement_tt_calc.admin_order_field = 'remboursement_tt_calc'
    remboursement_tt_calc.short_description = 'Total'

    def __str__(self):
        return "%s %s" % (self.remboursement_nom, self.remboursement_date)

    class Meta:
        verbose_name = "Remboursement des kms"
        verbose_name_plural = "*10 - Remboursements des kms*"
        ordering = ['remboursement_nom', 'remboursement_date']

class Reunion(models.Model):
    reunion_date = models.DateField("Date de la réunion", null = True, blank = True)
    reunion_lieu = models.ForeignKey(Ville, verbose_name = "Ville", on_delete = models.PROTECT)
    reunion_pour = models.CharField("Projet", max_length = 100)

    def __str__(self):
        return "%s à %s" % (self.reunion_date, self.reunion_lieu)

    class Meta:
        verbose_name = "Réunion"
        verbose_name_plural = "*09 - Réunions*"
        ordering = ['reunion_pour', 'reunion_date', 'reunion_lieu']


class Prepar(models.Model):
    prepar_date = models.DateTimeField("Date de la préparation", null = True, blank = True)
    prepar_lieu = models.ForeignKey(Ville, verbose_name = "Ville", on_delete = models.PROTECT)
    prepar_pour = models.CharField("Baptême/Mariage", max_length = 1, choices = PREPAR_CHOICES, default = "B")

    def __str__(self):
        return "%s à %s" % (self.prepar_date, self.prepar_lieu)

    class Meta:
        verbose_name = "Préparation"
        verbose_name_plural = "*01 - Préparations*"
        ordering = ['prepar_pour', 'prepar_date', 'prepar_lieu']

class Mariage(models.Model):
    mariage_acte_mariage = models.CharField("Numéro de mariage (ex : 2017.005)",max_length = 8, null = True, blank = True)
    mariage_fiance = models.ForeignKey(Nom, verbose_name = "Nom du fiancé", on_delete = models.PROTECT, related_name = '+')
    mariage_fiancee = models.ForeignKey(Nom, verbose_name = "Nom de la fiancée", on_delete = models.PROTECT, related_name = '+')
    mariage_demande_date = models.DateField("Demande faite le", null = True, blank = True)
    mariage_demande_par = models.CharField("par", max_length = 100, null = True, blank = True)
    mariage_civil_date = models.DateField("Mariés civilement le", null = True, blank = True)
    mariage_civil_lieu = models.ForeignKey(Ville, verbose_name = "Ville", on_delete = models.PROTECT, null = True, blank = True)
    mariage_prepar = models.ForeignKey(Prepar, verbose_name = "Préparation du mariage", on_delete = models.PROTECT, null = True, blank = True)
    mariage_prepar_absent = models.BooleanField("Absent")
    mariage_celebration = models.ForeignKey(Celebration, verbose_name = "Célébration", on_delete = models.PROTECT, null= True, blank = True)

    def __str__(self):
        return "%s" % (self.mariage_celebration)

    class Meta:
        verbose_name = "Célébration du mariage"
        verbose_name_plural = "*04 - Fiancés*"
        ordering = ['mariage_acte_mariage', 'mariage_celebration']

class Baptise(models.Model):
    baptise_acte_bapteme = models.CharField("Numéro du baptême (ex : 1977.005)",max_length = 8, null = True, blank = True)
    baptise_nom = models.ForeignKey(Nom, verbose_name = "Nom du baptisé", on_delete = models.PROTECT, null = False, blank = False, related_name = '+')
    baptise_demande_date = models.DateField("Demande faite le", null = True, blank = True)
    baptise_demande_par = models.CharField("par", max_length = 100, null = True, blank = True)
    baptise_pere = models.ForeignKey(Nom, verbose_name = "Nom du père", on_delete = models.PROTECT, null = True, blank = True, related_name = '+')
    baptise_mere = models.ForeignKey(Nom, verbose_name = "Nom de la mère", on_delete = models.PROTECT, null = True, blank = True, related_name = '+')
    baptise_naissance_acte = models.BooleanField("Acte de naissance")
    baptise_livret_catho = models.BooleanField("Livret de famille catholique")
    baptise_famille_accueil = models.CharField("Famille d'accueil", max_length = 100, null = True, blank = True)
    baptise_prepar = models.ForeignKey(Prepar, verbose_name = "Préparation du baptême", on_delete = models.PROTECT, null = True, blank = True)
    baptise_prepar_absent = models.BooleanField("Absent")
    baptise_celebration = models.ForeignKey(Celebration, verbose_name = "Célébration", on_delete = models.PROTECT, null= True, blank = True)

    def __str__(self):
        return "%s %s" % (self.baptise_nom.nom_prenom, self.baptise_nom.nom_nom)

    class Meta:
        verbose_name = "Enfant à baptiser"
        verbose_name_plural = "*03 - Baptisés*"
        ordering = ['baptise_acte_bapteme', 'baptise_celebration']