project/dae/models.py

   1 # -=- encoding: utf-8 -=-
   2 from django.db import models
   3
   4 import datamaster_modeles.models as ref
   5 import project.rh_v1.models as rh
   6
   7
   8 STATUT_RESIDENCE_CHOICES = (
   9     ('local', 'Local'),
  10     ('expat', 'Expatrié'),
  11 )
  12
  13 POSTE_APPEL_CHOICES = (
  14     ('interne', 'Interne'),
  15     ('externe', 'Externe'),
  16 )
  17
  18 POSTE_STATUT_CHOICES = (
  19     ('MAD', 'Mise à disposition'),
  20     ('DET', 'Détachement'),
  21 )
  22
  23
  24 class Poste(models.Model):
  25     # Modèle existant
  26     id_rh = models.ForeignKey(rh.Poste, null=True, related_name='+',
  27                               editable=False)
  28     nom = models.CharField(max_length=255)
  29     implantation = models.ForeignKey(ref.Implantation)
  30     type_poste = models.ForeignKey(rh.TypePoste, null=True, related_name='+')
  31     service = models.ForeignKey(rh.Service, related_name='+')
  32     responsable = models.ForeignKey(rh.Poste, related_name='+')
  33     regime_travail = models.DecimalField(max_digits=12, decimal_places=2,
  34                                          default=100)
  35     regime_travail_nb_heure_semaine = models.DecimalField(max_digits=12,
  36                                                           decimal_places=2,
  37                                                           default=40)
  38
  39     # Recrutement
  40     statut_residence = models.CharField(max_length=10, default='MAD',
  41                                         choices=STATUT_RESIDENCE_CHOICES)
  42     # TODO null?
  43     mise_a_disposition = models.BooleanField()
  44     appel = models.CharField(max_length=10, default='interne',
  45                              choices=POSTE_APPEL_CHOICES)
  46
  47     # Rémunération
  48     classement_min = models.ForeignKey(rh.Classement, related_name='+')
  49     classement_max = models.ForeignKey(rh.Classement, related_name='+')
  50     valeur_point_min = models.ForeignKey(rh.ValeurPoint, related_name='+')
  51     valeur_point_max = models.ForeignKey(rh.ValeurPoint, related_name='+')
  52     salaire_min = models.DecimalField(max_digits=12, decimal_places=2,
  53                                       default=0)
  54     salaire_max = models.DecimalField(max_digits=12, decimal_places=2,
  55                                       default=0)
  56     indemn_min = models.DecimalField(max_digits=12, decimal_places=2,
  57                                       default=0)
  58     indemn_max = models.DecimalField(max_digits=12, decimal_places=2,
  59                                       default=0)
  60     autre_min = models.DecimalField(max_digits=12, decimal_places=2,
  61                                       default=0)
  62     autre_max = models.DecimalField(max_digits=12, decimal_places=2,
  63                                       default=0)
  64
  65     # Comparatifs de rémunération
  66     devise_comparaison = models.ForeignKey(rh.Devise, related_name='+',
  67                                            null=True, blank=True)
  68     comp_locale_min = models.DecimalField(max_digits=12, decimal_places=2,
  69                                           null=True, blank=True)
  70     comp_locale_max = models.DecimalField(max_digits=12, decimal_places=2,
  71                                           null=True, blank=True)
  72     comp_universite_min = models.DecimalField(max_digits=12, decimal_places=2,
  73                                               null=True, blank=True)
  74     comp_universite_max = models.DecimalField(max_digits=12, decimal_places=2,
  75                                               null=True, blank=True)
  76     comp_fonctionpub_min = models.DecimalField(max_digits=12, decimal_places=2,
  77                                                null=True, blank=True)
  78     comp_fonctionpub_max = models.DecimalField(max_digits=12, decimal_places=2,
  79                                                null=True, blank=True)
  80     comp_ong_min = models.DecimalField(max_digits=12, decimal_places=2,
  81                                        null=True, blank=True)
  82     comp_ong_max = models.DecimalField(max_digits=12, decimal_places=2,
  83                                        null=True, blank=True)
  84     comp_autre_min = models.DecimalField(max_digits=12, decimal_places=2,
  85                                          null=True, blank=True)
  86     comp_autre_max = models.DecimalField(max_digits=12, decimal_places=2,
  87                                          null=True, blank=True)
  88
  89     # Méta
  90     date_creation = models.DateTimeField(auto_now_add=True)
  91     date_modification = models.DateTimeField(auto_now=True)
  92     date_debut = models.DateField()
  93     date_fin = models.DateField(null=True)
  94     actif = models.BooleanField(default=True)
  95
  96     def __unicode__(self):
  97         return u'%s - %s (%s)' % (self.implantation, self.type_poste.nom,
  98                                   self.nom)
  99
 100     def DISABLED_save(self, *args, **kwargs):
 101         # calculate nb_mois = nb of months between date_debut and date_fin
 102         from datetime import date
 103         if not self.salaire_min:
 104             self.salaire_min = self.classement_min * self.valeur_point_min
 105         if not self.salaire_max:
 106             self.salaire_max = self.classement_max * self.valeur_point_min
 107         if not self.valeur_point_min:
 108             self.valeur_point_min = \
 109                 rh.ValeurPoint.objects.filter(implantation=self.implantation)
 110         if not self.valeur_point_max:
 111             self.valeur_point_max = \
 112                 rh.ValeurPoint.objects.filter(implantation=self.implantation)
 113         super(Subject, self).save(*args, **kwargs)
 114
 115
 116 POSTE_FINANCEMENT_CHOICES = (
 117     ('A', 'A - Frais de personnel'),
 118     ('B', 'B - Projet(s)-Titre(s)'),
 119     ('C', 'C - Autre')
 120 )
 121
 122
 123 class PosteFinancement(models.Model):
 124     montant = models.DecimalField(max_digits=12, decimal_places=2)
 125     poste = models.ForeignKey('Poste', related_name='financements')
 126     type = models.CharField(max_length=1, choices=POSTE_FINANCEMENT_CHOICES)
 127     pourcentage = models.DecimalField(max_digits=12, decimal_places=2)
 128     commentaire = models.TextField()
 129
 130
 131 GENRE_CHOICES = (
 132     ('M', 'Homme'),
 133     ('F', 'Femme'),
 134 )
 135
 136
 137 class Employe(models.Model):
 138     id = models.IntegerField(primary_key=True)
 139
 140     # Modèle existant
 141     id_rh = models.ForeignKey(rh.Employe, null=True, related_name='+')
 142     nom = models.CharField(max_length=255)
 143     prenom = models.CharField(max_length=255)
 144     genre = models.CharField(max_length=1,
 145                              choices=GENRE_CHOICES,
 146                              null=True,
 147                              blank=True)
 148
 149
 150 COMPTE_COMPTA_CHOICES = (
 151     ('coda', 'coda'),
 152     ('scs', 'scs'),
 153     ('aucun', 'aucun'),
 154 )
 155
 156
 157 class Dossier(models.Model):
 158     statut_anterieur = models.ForeignKey(rh.Statut, related_name='+')
 159
 160     # Modèle existant
 161     poste = models.ForeignKey('Poste')
 162     statut = models.ForeignKey(rh.Statut, related_name='+')
 163     organisme_bstg = models.ForeignKey(rh.OrganismeBstg, related_name='+')
 164
 165     # Recrutement
 166     remplacement = models.BooleanField()
 167     mobilite_interne = models.BooleanField()
 168     statut_residence = models.CharField(max_length=10,
 169                                         choices=STATUT_RESIDENCE_CHOICES)
 170
 171     # Rémunération
 172     classement = models.ForeignKey(rh.Classement,
 173                                    verbose_name='Classement proposé',
 174                                    related_name='+')
 175     salaire = models.DecimalField(max_digits=12,
 176                                   decimal_places=2,
 177                                   verbose_name='Salaire de base',
 178                                   null=True,
 179                                   default=None)
 180     devise = models.ForeignKey(rh.Devise, related_name='+')
 181     regime_travail = models.DecimalField(max_digits=12, decimal_places=2)
 182     regime_travail_nb_heure_semaine = \
 183         models.DecimalField(max_digits=12, decimal_places=2)
 184
 185     # Contrat
 186     type_contrat = models.ForeignKey(rh.TypeContrat, related_name='+')
 187     contrat_date_debut = models.DateField()
 188     contrat_date_fin = models.DateField()
 189     contrat_nb_mois = models.IntegerField()
 190
 191     # Comptes
 192     compte_compta = models.CharField(max_length=10,
 193                                      choices=COMPTE_COMPTA_CHOICES)
 194     compte_courriel = models.BooleanField()
 195
 196
 197 class Remuneration(models.Model):
 198     # Identification
 199     id = models.IntegerField(primary_key=True)
 200     dossier = models.ForeignKey('Dossier', db_column='dossier')
 201     type = models.ForeignKey('TypeRemuneration', db_column='type')
 202     # TODO: what's that?
 203     # type_revalorisation = models.ForeignKey('TypeRevalorisation',
 204                                             # db_column='type_revalorisation')
 205     montant = models.DecimalField(max_digits=12, decimal_places=2)
 206     devise = models.ForeignKey(rh.Devise,
 207                                to_field='code',
 208                                db_column='devise', related_name='+')
 209     date_effective = models.DateField()
 210     pourcentage = models.IntegerField()
 211
 212     # Méta
 213     date_creation = models.DateField(auto_now_add=True)
 214     user_creation = models.IntegerField()
 215     desactivation = models.BooleanField()
 216     date_desactivation = models.DateField()
 217     user_desactivation = models.IntegerField()
 218     annule = models.BooleanField()
 219     date_annule = models.DateField()
 220     user_annule = models.IntegerField()
 221
 222
 223 class JustificationPoste(models.Model):
 224     pass
 225
 226
 227 class JustificationEmploye(models.Model):
 228     pass
 229
 230
 231 class DocumentPoste(models.Model):
 232     pass
 233
 234
 235 class DocumentEmploye(models.Model):
 236     pass
 237
 238
 239 class Validation(models.Model):
 240     # user
 241     date = models.DateField()
 242
 243     # avis = ? (CHOICES?)
 244
 245
 246 class ValidationPoste(models.Model):
 247     poste = models.ForeignKey('Poste')
 248
 249
 250 class ValidationEmploye(models.Model):
 251     employe = models.ForeignKey('Employe')
 252
 253
 254 class TypeRemuneration(models.Model):
 255     ordre = models.IntegerField()
 256     groupe = models.ForeignKey('GroupeTypeRemuneration')
 257
 258
 259 class GroupeTypeRemuneration(models.Model):
 260     nom = models.CharField(max_length=255)
 261     ordre = models.IntegerField()