auf_savoirs_en_partage/chercheurs/models.py

   1 # -*- encoding: utf-8 -*-
   2 from django.db import models
   3 from datamaster_modeles.models import *
   4 from auf_references_modeles.models import Thematique
   5 from savoirs.models import Discipline
   6
   7 GENRE_CHOICES = (('m', 'Homme'), ('f', 'Femme'))
   8 class Personne(models.Model):
   9
  10     id = models.AutoField(primary_key=True)
  11     salutation = models.CharField(max_length=128, null = True, blank = True)
  12     nom = models.CharField(max_length=255)
  13     prenom = models.CharField(max_length=128, verbose_name = 'Prénom')
  14     courriel = models.CharField(max_length=128, blank = True)
  15     fonction = models.CharField(max_length=128, null = True, blank = True)
  16     sousfonction = models.CharField(max_length=128, null = True, blank = True,
  17                                     verbose_name = 'Sous-fonction')
  18     mobile = models.CharField(max_length=32, null = True, blank = True,
  19                               verbose_name = 'Numéro de téléphone portable ')
  20     genre = models.CharField(max_length=1, choices=GENRE_CHOICES)
  21     commentaire = models.TextField(verbose_name = 'Commentaires', null = True,
  22                                    blank = True)
  23     actif = models.BooleanField(editable = False)
  24
  25     def __unicode__(self):
  26         return u"%s %s, %s" % (self.prenom, self.nom, self.courriel)
  27
  28     class Meta:
  29         ordering = ["prenom", "nom"]
  30
  31 FONCTION_CHOICES = (('Professeur', 'Professeur'), ('Chercheur', 'Chercheur'), ('Doctorant', 'Doctorant'), ('Autre', 'Autre'))
  32 class Chercheur(models.Model):
  33     id = models.AutoField(primary_key=True, db_column='id')
  34     personne = models.ForeignKey('Personne', db_column='personne')
  35     pays = models.ForeignKey(Pays, null = True, db_column='pays', to_field='code', verbose_name = 'Nationalité')
  36     fonction = models.CharField(max_length=36, choices=FONCTION_CHOICES)
  37     scolarite = models.CharField(max_length=255, null=True,
  38                                  verbose_name = 'Diplôme le plus élevé')
  39     etablissement = models.ForeignKey(Etablissement, db_column='etablissement', null=True, blank=True)
  40     #Domaine
  41     thematique = models.ForeignKey(Thematique, db_column='thematique', null=True)
  42
  43     mots_cles = models.CharField(max_length=255, null=True, blank=True,
  44                                     verbose_name='Mots-clés')
  45     these = models.CharField(max_length=255, null=True, blank=True,
  46                                     verbose_name='Thèse')
  47     discipline = models.ForeignKey(Discipline, db_column='discipline', null=True, blank=True,
  48                                         verbose_name='Champ disciplinaire')
  49     expertise = models.TextField(null=True, blank=True, verbose_name='Domaine d\'expertise et thèmes de recherche')
  50     url = models.URLField(max_length=255, null=True, blank=True,
  51                                     verbose_name='Adresse site Internet personnel')
  52     publication1 = models.CharField(max_length=255, null=True, blank=True,
  53                                  verbose_name = 'Publication 1')
  54     publication2 = models.CharField(max_length=255, null=True, blank=True,
  55                                  verbose_name = 'Publication 2')
  56     publication3 = models.CharField(max_length=255, null=True, blank=True,
  57                                  verbose_name = 'Publication 3')
  58     publication4 = models.CharField(max_length=255, null=True, blank=True,
  59                                  verbose_name = 'Publication 4')
  60     groupes = models.ManyToManyField('Groupe', through='ChercheurGroupe', blank=True, verbose_name = 'Domaines de recherche')
  61     actif = models.BooleanField(editable = False)
  62
  63     def __unicode__(self):
  64         return u"%s %s" % (self.personne.nom.upper(), self.personne.prenom)
  65
  66
  67 class Groupe(models.Model):
  68     id = models.AutoField(primary_key=True, db_column='id')
  69     nom = models.CharField(max_length=255, db_column='nom')
  70     actif = models.BooleanField(editable = False, db_column='actif')
  71
  72     def __unicode__(self):
  73         return u"%s" % (self.nom)
  74
  75 class ChercheurGroupe(models.Model):
  76     id = models.AutoField(primary_key=True, db_column='id')
  77     chercheur = models.ForeignKey('Chercheur', db_column='chercheur')
  78     groupe = models.ForeignKey('Groupe', db_column='groupe')
  79     date_inscription = models.DateField(auto_now=True)