[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 Poste(models.Model):
    # Modèle existant
    id_rh = models.ForeignKey(rh.Poste, null=True, related_name='+',
                              editable=False)
    nom = models.CharField(max_length=255)
    implantation = models.ForeignKey(ref.Implantation)
    type_poste = models.ForeignKey(rh.TypePoste, null=True, related_name='+')
    service = models.ForeignKey(rh.Service, related_name='+')
    responsable = models.ForeignKey(rh.Poste, 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',
                                        choices=STATUT_RESIDENCE_CHOICES)
    # TODO null?
    mise_a_disposition = models.BooleanField()
    appel = models.CharField(max_length=10, default='interne',
                             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()
    date_fin = models.DateField(null=True)
    actif = models.BooleanField(default=True)

    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):
    id = models.IntegerField(primary_key=True)

    # 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)


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


class Dossier(models.Model):

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

    # Données antérieures
    employe_anterieur = models.ForeignKey('Employe', related_name='+')
    statut_anterieur = models.ForeignKey(rh.Statut, related_name='+')
    classement_anterieur = models.ForeignKey(rh.Classement, related_name='+',
                                             verbose_name='Classement proposé')
    salaire_anterieur = models.DecimalField(max_digits=12, decimal_places=2,
                                            verbose_name='Salaire de base',
                                            null=True, default=None)

    # 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)
    regime_travail_nb_heure_semaine = \
        models.DecimalField(max_digits=12, decimal_places=2)

    # 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(null=True, blank=True)
    date_desactivation = models.DateField(null=True, blank=True)
    user_desactivation = models.IntegerField(null=True, blank=True)
    annule = models.BooleanField(null=True, blank=True)
    date_annule = models.DateField(null=True, blank=True)
    user_annule = 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
bd28238f	1	# -=- encoding: utf-8 -=-
3f3cf5f3	2	from django.db import models
3f3cf5f3	3
bd28238f	4	import datamaster_modeles.models as ref
5d680e84	5	import project.rh_v1.models as rh
bd28238f NC	6
	7
	8	STATUT_RESIDENCE_CHOICES = (
5d680e84 NC	9	('local', 'Local'),
5d680e84 NC	10	('expat', 'Expatrié'),
bd28238f NC	11	)
	12
	13	POSTE_APPEL_CHOICES = (
5d680e84 NC	14	('interne', 'Interne'),
5d680e84 NC	15	('externe', 'Externe'),
bd28238f NC	16	)
	17
	18	POSTE_STATUT_CHOICES = (
	19	('MAD', 'Mise à disposition'),
	20	('DET', 'Détachement'),
	21	)
	22
	23
	24	class Poste(models.Model):
bd28238f	25	# Modèle existant
5d680e84 NC	26	id_rh = models.ForeignKey(rh.Poste, null=True, related_name='+',
5d680e84 NC	27	editable=False)
bd28238f	28	nom = models.CharField(max_length=255)
5d680e84 NC	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)
bd28238f NC	38
bd28238f NC	39	# Recrutement
5d680e84	40	statut_residence = models.CharField(max_length=10, default='MAD',
bd28238f	41	choices=STATUT_RESIDENCE_CHOICES)
5d680e84 NC	42	# TODO null?
	43	mise_a_disposition = models.BooleanField()
	44	appel = models.CharField(max_length=10, default='interne',
	45	choices=POSTE_APPEL_CHOICES)
bd28238f NC	46
bd28238f NC	47	# Rémunération
5d680e84 NC	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)
bd28238f NC	88
bd28238f NC	89	# Méta
5d680e84 NC	90	date_creation = models.DateTimeField(auto_now_add=True)
5d680e84 NC	91	date_modification = models.DateTimeField(auto_now=True)
bd28238f NC	92	date_debut = models.DateField()
bd28238f NC	93	date_fin = models.DateField(null=True)
bd28238f NC	94	actif = models.BooleanField(default=True)
bd28238f NC	95
5d680e84 NC	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):
bd28238f NC	101	# calculate nb_mois = nb of months between date_debut and date_fin
bd28238f NC	102	from datetime import date
bd28238f NC	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
5d680e84 NC	116	POSTE_FINANCEMENT_CHOICES = (
	117	('A', 'A - Frais de personnel'),
	118	('B', 'B - Projet(s)-Titre(s)'),
	119	('C', 'C - Autre')
	120	)
bd28238f NC	121
bd28238f NC	122
5d680e84 NC	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()
bd28238f NC	129
	130
	131	GENRE_CHOICES = (
bc2848da NC	132	('M', 'Homme'),
bc2848da NC	133	('F', 'Femme'),
bd28238f NC	134	)
	135
	136
	137	class Employe(models.Model):
	138	id = models.IntegerField(primary_key=True)
	139
	140	# Modèle existant
5d680e84	141	id_rh = models.ForeignKey(rh.Employe, null=True, related_name='+')
bd28238f NC	142	nom = models.CharField(max_length=255)
bd28238f NC	143	prenom = models.CharField(max_length=255)
494ff2be NC	144	genre = models.CharField(max_length=1, choices=GENRE_CHOICES,
494ff2be NC	145	null=True, blank=True)
bd28238f NC	146
	147
	148	COMPTE_COMPTA_CHOICES = (
494ff2be NC	149	('coda', 'CODA'),
	150	('scs', 'SCS'),
	151	('aucun', 'Aucun'),
bd28238f NC	152	)
	153
	154
	155	class Dossier(models.Model):
bd28238f NC	156
bd28238f NC	157	# Modèle existant
494ff2be NC	158	employe = models.ForeignKey('Employe', related_name='+')
494ff2be NC	159	poste = models.ForeignKey('Poste', related_name='+')
5d680e84 NC	160	statut = models.ForeignKey(rh.Statut, related_name='+')
5d680e84 NC	161	organisme_bstg = models.ForeignKey(rh.OrganismeBstg, related_name='+')
bd28238f	162
494ff2be NC	163	# Données antérieures
	164	employe_anterieur = models.ForeignKey('Employe', related_name='+')
	165	statut_anterieur = models.ForeignKey(rh.Statut, related_name='+')
	166	classement_anterieur = models.ForeignKey(rh.Classement, related_name='+',
	167	verbose_name='Classement proposé')
	168	salaire_anterieur = models.DecimalField(max_digits=12, decimal_places=2,
	169	verbose_name='Salaire de base',
	170	null=True, default=None)
	171
bd28238f NC	172	# Recrutement
bd28238f NC	173	remplacement = models.BooleanField()
bd28238f NC	174	statut_residence = models.CharField(max_length=10,
	175	choices=STATUT_RESIDENCE_CHOICES)
	176
	177	# Rémunération
494ff2be NC	178	classement = models.ForeignKey(rh.Classement, related_name='+',
	179	verbose_name='Classement proposé')
	180	salaire = models.DecimalField(max_digits=12, decimal_places=2,
bd28238f	181	verbose_name='Salaire de base',
494ff2be	182	null=True, default=None)
5d680e84 NC	183	devise = models.ForeignKey(rh.Devise, related_name='+')
5d680e84 NC	184	regime_travail = models.DecimalField(max_digits=12, decimal_places=2)
bd28238f	185	regime_travail_nb_heure_semaine = \
5d680e84	186	models.DecimalField(max_digits=12, decimal_places=2)
bd28238f NC	187
bd28238f NC	188	# Contrat
5d680e84	189	type_contrat = models.ForeignKey(rh.TypeContrat, related_name='+')
bd28238f NC	190	contrat_date_debut = models.DateField()
bd28238f NC	191	contrat_date_fin = models.DateField()
bd28238f NC	192
	193	# Comptes
	194	compte_compta = models.CharField(max_length=10,
	195	choices=COMPTE_COMPTA_CHOICES)
	196	compte_courriel = models.BooleanField()
	197
	198
	199	class Remuneration(models.Model):
5d680e84	200	# Identification
bd28238f NC	201	id = models.IntegerField(primary_key=True)
	202	dossier = models.ForeignKey('Dossier', db_column='dossier')
	203	type = models.ForeignKey('TypeRemuneration', db_column='type')
5d680e84 NC	204	# TODO: what's that?
	205	# type_revalorisation = models.ForeignKey('TypeRevalorisation',
	206	# db_column='type_revalorisation')
494ff2be NC	207	montant = models.DecimalField(max_digits=12, decimal_places=2) # Annuel
494ff2be NC	208	devise = models.ForeignKey(rh.Devise, to_field='code',
5d680e84	209	db_column='devise', related_name='+')
494ff2be NC	210	date_effective = models.DateField(null=True, blank=True)
494ff2be NC	211	pourcentage = models.IntegerField(null=True, blank=True)
bd28238f	212
5d680e84	213	# Méta
bd28238f	214	date_creation = models.DateField(auto_now_add=True)
494ff2be NC	215	user_creation = models.IntegerField(null=True, blank=True)
	216	desactivation = models.BooleanField(null=True, blank=True)
	217	date_desactivation = models.DateField(null=True, blank=True)
	218	user_desactivation = models.IntegerField(null=True, blank=True)
	219	annule = models.BooleanField(null=True, blank=True)
	220	date_annule = models.DateField(null=True, blank=True)
	221	user_annule = models.IntegerField(null=True, blank=True)
bd28238f NC	222
	223
	224	class JustificationPoste(models.Model):
	225	pass
	226
	227
	228	class JustificationEmploye(models.Model):
	229	pass
	230
	231
	232	class DocumentPoste(models.Model):
	233	pass
	234
	235
	236	class DocumentEmploye(models.Model):
	237	pass
	238
	239
	240	class Validation(models.Model):
	241	# user
	242	date = models.DateField()
	243
	244	# avis = ? (CHOICES?)
	245
	246
	247	class ValidationPoste(models.Model):
	248	poste = models.ForeignKey('Poste')
	249
	250
	251	class ValidationEmploye(models.Model):
	252	employe = models.ForeignKey('Employe')
	253
	254
	255	class TypeRemuneration(models.Model):
	256	ordre = models.IntegerField()
	257	groupe = models.ForeignKey('GroupeTypeRemuneration')
	258
	259
	260	class GroupeTypeRemuneration(models.Model):
	261	nom = models.CharField(max_length=255)
	262	ordre = models.IntegerField()