[auf_rh_dae.git] / project / dae / models.py

# -=- encoding: utf-8 -=-
from django.db import models

import datamaster_modeles.models as ref
import project.rh_v1.models as rh


STATUT_RESIDENCE_CHOICES = (
    ('local', 'Local'),
    ('expat', 'Expatrié'),
)

POSTE_APPEL_CHOICES = (
    ('interne', 'Interne'),
    ('externe', 'Externe'),
)

POSTE_STATUT_CHOICES = (
    ('MAD', 'Mise à disposition'),
    ('DET', 'Détachement'),
)


class PosteManager(models.Manager):
    """
    Chargement de tous les objets FK existants sur chaque QuerySet.
    """
    def get_query_set(self):
        fkeys = (
            'id_rh',
            'responsable',
            'implantation',
            'type_poste',
            'service',
            'classement_min',
            'classement_max',
            'valeur_point_min',
            'valeur_point_max',
        )
        return super(PosteManager, self).get_query_set().select_related(*fkeys).all()


class Poste(models.Model):
    # Modèle existant
    id_rh = models.ForeignKey(rh.Poste, null=True, related_name='+',
                              editable=False, verbose_name="Mise à jour du poste")
    nom = models.CharField(verbose_name="Titre du poste", max_length=255)
    implantation = models.ForeignKey(ref.Implantation)
    type_poste = models.ForeignKey(rh.TypePoste, null=True, related_name='+')
    service = models.ForeignKey(rh.Service, verbose_name=u"Direction/Service/Pôle support", related_name='+')
    responsable = models.ForeignKey(rh.Poste, verbose_name="Poste du responsable", related_name='+')


    regime_travail = models.DecimalField(max_digits=12, decimal_places=2,
                                         default=100)
    regime_travail_nb_heure_semaine = models.DecimalField(max_digits=12,
                                                          decimal_places=2,
                                                          default=40)

    # Recrutement
    statut_residence = models.CharField(max_length=10, default='MAD', verbose_name="Recrutement",
                                        choices=STATUT_RESIDENCE_CHOICES)
    # TODO null?
    mise_a_disposition = models.BooleanField()
    appel = models.CharField(max_length=10, default='interne', verbose_name="Appel à candidature",
                             choices=POSTE_APPEL_CHOICES)

    # Rémunération
    classement_min = models.ForeignKey(rh.Classement, related_name='+')
    classement_max = models.ForeignKey(rh.Classement, related_name='+')
    valeur_point_min = models.ForeignKey(rh.ValeurPoint, related_name='+')
    valeur_point_max = models.ForeignKey(rh.ValeurPoint, related_name='+')
    salaire_min = models.DecimalField(max_digits=12, decimal_places=2,
                                      default=0)
    salaire_max = models.DecimalField(max_digits=12, decimal_places=2,
                                      default=0)
    indemn_min = models.DecimalField(max_digits=12, decimal_places=2,
                                      default=0)
    indemn_max = models.DecimalField(max_digits=12, decimal_places=2,
                                      default=0)
    autre_min = models.DecimalField(max_digits=12, decimal_places=2,
                                      default=0)
    autre_max = models.DecimalField(max_digits=12, decimal_places=2,
                                      default=0)

    # Comparatifs de rémunération
    devise_comparaison = models.ForeignKey(rh.Devise, related_name='+',
                                           null=True, blank=True)
    comp_locale_min = models.DecimalField(max_digits=12, decimal_places=2,
                                          null=True, blank=True)
    comp_locale_max = models.DecimalField(max_digits=12, decimal_places=2,
                                          null=True, blank=True)
    comp_universite_min = models.DecimalField(max_digits=12, decimal_places=2,
                                              null=True, blank=True)
    comp_universite_max = models.DecimalField(max_digits=12, decimal_places=2,
                                              null=True, blank=True)
    comp_fonctionpub_min = models.DecimalField(max_digits=12, decimal_places=2,
                                               null=True, blank=True)
    comp_fonctionpub_max = models.DecimalField(max_digits=12, decimal_places=2,
                                               null=True, blank=True)
    comp_ong_min = models.DecimalField(max_digits=12, decimal_places=2,
                                       null=True, blank=True)
    comp_ong_max = models.DecimalField(max_digits=12, decimal_places=2,
                                       null=True, blank=True)
    comp_autre_min = models.DecimalField(max_digits=12, decimal_places=2,
                                         null=True, blank=True)
    comp_autre_max = models.DecimalField(max_digits=12, decimal_places=2,
                                         null=True, blank=True)

    # Méta
    date_creation = models.DateTimeField(auto_now_add=True)
    date_modification = models.DateTimeField(auto_now=True)
    date_debut = models.DateField(verbose_name="Date de début", help_text="format: aaaa-mm-jj")
    date_fin = models.DateField(null=True, verbose_name="Date de fin", help_text="format: aaaa-mm-jj")
    actif = models.BooleanField(default=True)

    # Managers
    objects = PosteManager()

    def __unicode__(self):
        return u'%s - %s (%s)' % (self.implantation, self.type_poste.nom,
                                  self.nom)

    def DISABLED_save(self, *args, **kwargs):
        # calculate nb_mois = nb of months between date_debut and date_fin
        from datetime import date
        if not self.salaire_min:
            self.salaire_min = self.classement_min * self.valeur_point_min
        if not self.salaire_max:
            self.salaire_max = self.classement_max * self.valeur_point_min
        if not self.valeur_point_min:
            self.valeur_point_min = \
                rh.ValeurPoint.objects.filter(implantation=self.implantation)
        if not self.valeur_point_max:
            self.valeur_point_max = \
                rh.ValeurPoint.objects.filter(implantation=self.implantation)
        super(Subject, self).save(*args, **kwargs)


POSTE_FINANCEMENT_CHOICES = (
    ('A', 'A - Frais de personnel'),
    ('B', 'B - Projet(s)-Titre(s)'),
    ('C', 'C - Autre')
)


class PosteFinancement(models.Model):
    montant = models.DecimalField(max_digits=12, decimal_places=2)
    poste = models.ForeignKey('Poste', related_name='financements')
    type = models.CharField(max_length=1, choices=POSTE_FINANCEMENT_CHOICES)
    pourcentage = models.DecimalField(max_digits=12, decimal_places=2)
    commentaire = models.TextField()


GENRE_CHOICES = (
    ('m', 'Homme'),
    ('f', 'Femme'),
)


class Employe(models.Model):

    # Modèle existant
    id_rh = models.ForeignKey(rh.Employe, null=True, related_name='+')
    nom = models.CharField(max_length=255)
    prenom = models.CharField(max_length=255)
    genre = models.CharField(max_length=1, choices=GENRE_CHOICES,
                             null=True, blank=True)

    def __unicode__(self):
        return u'%s %s' % (self.prenom, self.nom)


COMPTE_COMPTA_CHOICES = (
    ('coda', 'CODA'),
    ('scs', 'SCS'),
    ('aucun', 'Aucun'),
)


class Dossier(models.Model):

    # Modèle existant
    employe = models.ForeignKey('Employe', related_name='+', editable=False)
    poste = models.ForeignKey('Poste', related_name='+', editable=False)
    statut = models.ForeignKey(rh.Statut, related_name='+')
    organisme_bstg = models.ForeignKey(rh.OrganismeBstg, related_name='+')

    # Données antérieures de l'employé
    statut_anterieur = models.ForeignKey(
            rh.Statut, related_name='+', null=True, blank=True,
            verbose_name='Statut précédent')
    classement_anterieur = models.ForeignKey(
            rh.Classement, related_name='+', null=True, blank=True,
            verbose_name='Classement précédent')
    salaire_anterieur = models.DecimalField(
            max_digits=12, decimal_places=2, null=True, default=None,
            blank=True, verbose_name='Salaire précédent')

    # Données du titulaire précédent
    employe_anterieur = models.ForeignKey(
            rh.Employe, related_name='+', null=True, blank=True,
            verbose_name='Employé précédent')
    statut_titulaire_anterieur = models.ForeignKey(
            rh.Statut, related_name='+', null=True, blank=True,
            verbose_name='Statut titulaire précédent')
    classement_titulaire_anterieur = models.ForeignKey(
            rh.Classement, related_name='+', null=True, blank=True,
            verbose_name='Classement titulaire précédent')
    salaire_titulaire_anterieur = models.DecimalField(
            max_digits=12, decimal_places=2, default=None, null=True,
            blank=True, verbose_name='Salaire titulaire précédent')

    # Recrutement
    remplacement = models.BooleanField()
    statut_residence = models.CharField(max_length=10,
                                        choices=STATUT_RESIDENCE_CHOICES)

    # Rémunération
    classement = models.ForeignKey(rh.Classement, related_name='+',
                                   verbose_name='Classement proposé')
    salaire = models.DecimalField(max_digits=12, decimal_places=2,
                                  verbose_name='Salaire de base',
                                  null=True, default=None)
    devise = models.ForeignKey(rh.Devise, related_name='+')
    regime_travail = models.DecimalField(max_digits=12, decimal_places=2,
                                         verbose_name="Régime de travail")
    regime_travail_nb_heure_semaine = models.DecimalField(max_digits=12,
            decimal_places=2, verbose_name="Nbr heures par semaine")

    # Contrat
    type_contrat = models.ForeignKey(rh.TypeContrat, related_name='+')
    contrat_date_debut = models.DateField()
    contrat_date_fin = models.DateField()

    # Comptes
    compte_compta = models.CharField(max_length=10,
                                     choices=COMPTE_COMPTA_CHOICES)
    compte_courriel = models.BooleanField()


class Remuneration(models.Model):
    # Identification
    id = models.IntegerField(primary_key=True)
    dossier = models.ForeignKey('Dossier', db_column='dossier')
    type = models.ForeignKey('TypeRemuneration', db_column='type')
    # TODO: what's that?
    # type_revalorisation = models.ForeignKey('TypeRevalorisation',
                                            # db_column='type_revalorisation')
    montant = models.DecimalField(max_digits=12, decimal_places=2) # Annuel
    devise = models.ForeignKey(rh.Devise, to_field='code',
                               db_column='devise', related_name='+')
    date_effective = models.DateField(null=True, blank=True)
    pourcentage = models.IntegerField(null=True, blank=True)

    # Méta
    date_creation = models.DateField(auto_now_add=True)
    user_creation = models.IntegerField(null=True, blank=True)
    desactivation = models.BooleanField(default=False, blank=True)
    date_desactivation = models.DateField(null=True, blank=True)
    user_desactivation = models.IntegerField(null=True, blank=True)
    annulation = models.BooleanField(default=False, blank=True)
    date_annulation = models.DateField(null=True, blank=True)
    user_annulation = models.IntegerField(null=True, blank=True)


class JustificationPoste(models.Model):
    pass


class JustificationEmploye(models.Model):
    pass


class DocumentPoste(models.Model):
    pass


class DocumentEmploye(models.Model):
    pass


class Validation(models.Model):
    # user
    date = models.DateField()

    # avis = ? (CHOICES?)


class ValidationPoste(models.Model):
    poste = models.ForeignKey('Poste')


class ValidationEmploye(models.Model):
    employe = models.ForeignKey('Employe')


class TypeRemuneration(models.Model):
    ordre = models.IntegerField()
    groupe = models.ForeignKey('GroupeTypeRemuneration')


class GroupeTypeRemuneration(models.Model):
    nom = models.CharField(max_length=255)
    ordre = models.IntegerField()
Commit	Line	Data
	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
	25	class PosteManager(models.Manager):
	26	"""
	27	Chargement de tous les objets FK existants sur chaque QuerySet.
	28	"""
	29	def get_query_set(self):
	30	fkeys = (
	31	'id_rh',
	32	'responsable',
	33	'implantation',
	34	'type_poste',
	35	'service',
	36	'classement_min',
	37	'classement_max',
	38	'valeur_point_min',
	39	'valeur_point_max',
	40	)
	41	return super(PosteManager, self).get_query_set().select_related(*fkeys).all()
	42
	43
	44	class Poste(models.Model):
	45	# Modèle existant
	46	id_rh = models.ForeignKey(rh.Poste, null=True, related_name='+',
	47	editable=False, verbose_name="Mise à jour du poste")
	48	nom = models.CharField(verbose_name="Titre du poste", max_length=255)
	49	implantation = models.ForeignKey(ref.Implantation)
	50	type_poste = models.ForeignKey(rh.TypePoste, null=True, related_name='+')
	51	service = models.ForeignKey(rh.Service, verbose_name=u"Direction/Service/Pôle support", related_name='+')
	52	responsable = models.ForeignKey(rh.Poste, verbose_name="Poste du responsable", related_name='+')
	53
	54
	55	regime_travail = models.DecimalField(max_digits=12, decimal_places=2,
	56	default=100)
	57	regime_travail_nb_heure_semaine = models.DecimalField(max_digits=12,
	58	decimal_places=2,
	59	default=40)
	60
	61	# Recrutement
	62	statut_residence = models.CharField(max_length=10, default='MAD', verbose_name="Recrutement",
	63	choices=STATUT_RESIDENCE_CHOICES)
	64	# TODO null?
	65	mise_a_disposition = models.BooleanField()
	66	appel = models.CharField(max_length=10, default='interne', verbose_name="Appel à candidature",
	67	choices=POSTE_APPEL_CHOICES)
	68
	69	# Rémunération
	70	classement_min = models.ForeignKey(rh.Classement, related_name='+')
	71	classement_max = models.ForeignKey(rh.Classement, related_name='+')
	72	valeur_point_min = models.ForeignKey(rh.ValeurPoint, related_name='+')
	73	valeur_point_max = models.ForeignKey(rh.ValeurPoint, related_name='+')
	74	salaire_min = models.DecimalField(max_digits=12, decimal_places=2,
	75	default=0)
	76	salaire_max = models.DecimalField(max_digits=12, decimal_places=2,
	77	default=0)
	78	indemn_min = models.DecimalField(max_digits=12, decimal_places=2,
	79	default=0)
	80	indemn_max = models.DecimalField(max_digits=12, decimal_places=2,
	81	default=0)
	82	autre_min = models.DecimalField(max_digits=12, decimal_places=2,
	83	default=0)
	84	autre_max = models.DecimalField(max_digits=12, decimal_places=2,
	85	default=0)
	86
	87	# Comparatifs de rémunération
	88	devise_comparaison = models.ForeignKey(rh.Devise, related_name='+',
	89	null=True, blank=True)
	90	comp_locale_min = models.DecimalField(max_digits=12, decimal_places=2,
	91	null=True, blank=True)
	92	comp_locale_max = models.DecimalField(max_digits=12, decimal_places=2,
	93	null=True, blank=True)
	94	comp_universite_min = models.DecimalField(max_digits=12, decimal_places=2,
	95	null=True, blank=True)
	96	comp_universite_max = models.DecimalField(max_digits=12, decimal_places=2,
	97	null=True, blank=True)
	98	comp_fonctionpub_min = models.DecimalField(max_digits=12, decimal_places=2,
	99	null=True, blank=True)
	100	comp_fonctionpub_max = models.DecimalField(max_digits=12, decimal_places=2,
	101	null=True, blank=True)
	102	comp_ong_min = models.DecimalField(max_digits=12, decimal_places=2,
	103	null=True, blank=True)
	104	comp_ong_max = models.DecimalField(max_digits=12, decimal_places=2,
	105	null=True, blank=True)
	106	comp_autre_min = models.DecimalField(max_digits=12, decimal_places=2,
	107	null=True, blank=True)
	108	comp_autre_max = models.DecimalField(max_digits=12, decimal_places=2,
	109	null=True, blank=True)
	110
	111	# Méta
	112	date_creation = models.DateTimeField(auto_now_add=True)
	113	date_modification = models.DateTimeField(auto_now=True)
	114	date_debut = models.DateField(verbose_name="Date de début", help_text="format: aaaa-mm-jj")
	115	date_fin = models.DateField(null=True, verbose_name="Date de fin", help_text="format: aaaa-mm-jj")
	116	actif = models.BooleanField(default=True)
	117
	118	# Managers
	119	objects = PosteManager()
	120
	121	def __unicode__(self):
	122	return u'%s - %s (%s)' % (self.implantation, self.type_poste.nom,
	123	self.nom)
	124
	125	def DISABLED_save(self, args, *kwargs):
	126	# calculate nb_mois = nb of months between date_debut and date_fin
	127	from datetime import date
	128	if not self.salaire_min:
	129	self.salaire_min = self.classement_min * self.valeur_point_min
	130	if not self.salaire_max:
	131	self.salaire_max = self.classement_max * self.valeur_point_min
	132	if not self.valeur_point_min:
	133	self.valeur_point_min = \
	134	rh.ValeurPoint.objects.filter(implantation=self.implantation)
	135	if not self.valeur_point_max:
	136	self.valeur_point_max = \
	137	rh.ValeurPoint.objects.filter(implantation=self.implantation)
	138	super(Subject, self).save(args, *kwargs)
	139
	140
	141	POSTE_FINANCEMENT_CHOICES = (
	142	('A', 'A - Frais de personnel'),
	143	('B', 'B - Projet(s)-Titre(s)'),
	144	('C', 'C - Autre')
	145	)
	146
	147
	148	class PosteFinancement(models.Model):
	149	montant = models.DecimalField(max_digits=12, decimal_places=2)
	150	poste = models.ForeignKey('Poste', related_name='financements')
	151	type = models.CharField(max_length=1, choices=POSTE_FINANCEMENT_CHOICES)
	152	pourcentage = models.DecimalField(max_digits=12, decimal_places=2)
	153	commentaire = models.TextField()
	154
	155
	156	GENRE_CHOICES = (
	157	('m', 'Homme'),
	158	('f', 'Femme'),
	159	)
	160
	161
	162	class Employe(models.Model):
	163
	164	# Modèle existant
	165	id_rh = models.ForeignKey(rh.Employe, null=True, related_name='+')
	166	nom = models.CharField(max_length=255)
	167	prenom = models.CharField(max_length=255)
	168	genre = models.CharField(max_length=1, choices=GENRE_CHOICES,
	169	null=True, blank=True)
	170
	171	def __unicode__(self):
	172	return u'%s %s' % (self.prenom, self.nom)
	173
	174
	175	COMPTE_COMPTA_CHOICES = (
	176	('coda', 'CODA'),
	177	('scs', 'SCS'),
	178	('aucun', 'Aucun'),
	179	)
	180
	181
	182	class Dossier(models.Model):
	183
	184	# Modèle existant
	185	employe = models.ForeignKey('Employe', related_name='+', editable=False)
	186	poste = models.ForeignKey('Poste', related_name='+', editable=False)
	187	statut = models.ForeignKey(rh.Statut, related_name='+')
	188	organisme_bstg = models.ForeignKey(rh.OrganismeBstg, related_name='+')
	189
	190	# Données antérieures de l'employé
	191	statut_anterieur = models.ForeignKey(
	192	rh.Statut, related_name='+', null=True, blank=True,
	193	verbose_name='Statut précédent')
	194	classement_anterieur = models.ForeignKey(
	195	rh.Classement, related_name='+', null=True, blank=True,
	196	verbose_name='Classement précédent')
	197	salaire_anterieur = models.DecimalField(
	198	max_digits=12, decimal_places=2, null=True, default=None,
	199	blank=True, verbose_name='Salaire précédent')
	200
	201	# Données du titulaire précédent
	202	employe_anterieur = models.ForeignKey(
	203	rh.Employe, related_name='+', null=True, blank=True,
	204	verbose_name='Employé précédent')
	205	statut_titulaire_anterieur = models.ForeignKey(
	206	rh.Statut, related_name='+', null=True, blank=True,
	207	verbose_name='Statut titulaire précédent')
	208	classement_titulaire_anterieur = models.ForeignKey(
	209	rh.Classement, related_name='+', null=True, blank=True,
	210	verbose_name='Classement titulaire précédent')
	211	salaire_titulaire_anterieur = models.DecimalField(
	212	max_digits=12, decimal_places=2, default=None, null=True,
	213	blank=True, verbose_name='Salaire titulaire précédent')
	214
	215	# Recrutement
	216	remplacement = models.BooleanField()
	217	statut_residence = models.CharField(max_length=10,
	218	choices=STATUT_RESIDENCE_CHOICES)
	219
	220	# Rémunération
	221	classement = models.ForeignKey(rh.Classement, related_name='+',
	222	verbose_name='Classement proposé')
	223	salaire = models.DecimalField(max_digits=12, decimal_places=2,
	224	verbose_name='Salaire de base',
	225	null=True, default=None)
	226	devise = models.ForeignKey(rh.Devise, related_name='+')
	227	regime_travail = models.DecimalField(max_digits=12, decimal_places=2,
	228	verbose_name="Régime de travail")
	229	regime_travail_nb_heure_semaine = models.DecimalField(max_digits=12,
	230	decimal_places=2, verbose_name="Nbr heures par semaine")
	231
	232	# Contrat
	233	type_contrat = models.ForeignKey(rh.TypeContrat, related_name='+')
	234	contrat_date_debut = models.DateField()
	235	contrat_date_fin = models.DateField()
	236
	237	# Comptes
	238	compte_compta = models.CharField(max_length=10,
	239	choices=COMPTE_COMPTA_CHOICES)
	240	compte_courriel = models.BooleanField()
	241
	242
	243	class Remuneration(models.Model):
	244	# Identification
	245	id = models.IntegerField(primary_key=True)
	246	dossier = models.ForeignKey('Dossier', db_column='dossier')
	247	type = models.ForeignKey('TypeRemuneration', db_column='type')
	248	# TODO: what's that?
	249	# type_revalorisation = models.ForeignKey('TypeRevalorisation',
	250	# db_column='type_revalorisation')
	251	montant = models.DecimalField(max_digits=12, decimal_places=2) # Annuel
	252	devise = models.ForeignKey(rh.Devise, to_field='code',
	253	db_column='devise', related_name='+')
	254	date_effective = models.DateField(null=True, blank=True)
	255	pourcentage = models.IntegerField(null=True, blank=True)
	256
	257	# Méta
	258	date_creation = models.DateField(auto_now_add=True)
	259	user_creation = models.IntegerField(null=True, blank=True)
	260	desactivation = models.BooleanField(default=False, blank=True)
	261	date_desactivation = models.DateField(null=True, blank=True)
	262	user_desactivation = models.IntegerField(null=True, blank=True)
	263	annulation = models.BooleanField(default=False, blank=True)
	264	date_annulation = models.DateField(null=True, blank=True)
	265	user_annulation = models.IntegerField(null=True, blank=True)
	266
	267
	268	class JustificationPoste(models.Model):
	269	pass
	270
	271
	272	class JustificationEmploye(models.Model):
	273	pass
	274
	275
	276	class DocumentPoste(models.Model):
	277	pass
	278
	279
	280	class DocumentEmploye(models.Model):
	281	pass
	282
	283
	284	class Validation(models.Model):
	285	# user
	286	date = models.DateField()
	287
	288	# avis = ? (CHOICES?)
	289
	290
	291	class ValidationPoste(models.Model):
	292	poste = models.ForeignKey('Poste')
	293
	294
	295	class ValidationEmploye(models.Model):
	296	employe = models.ForeignKey('Employe')
	297
	298
	299	class TypeRemuneration(models.Model):
	300	ordre = models.IntegerField()
	301	groupe = models.ForeignKey('GroupeTypeRemuneration')
	302
	303
	304	class GroupeTypeRemuneration(models.Model):
	305	nom = models.CharField(max_length=255)
	306	ordre = models.IntegerField()