From 3f5cbabe77412be26c65f3286cce135b0acf0137 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Olivier=20Larchev=C3=AAque?= Date: Fri, 13 Jan 2012 14:47:13 -0500 Subject: [PATCH] dae.Poste heritage --- buildout.cfg | 1 + project/dae/catalogues.py | 24 +- project/dae/decorators.py | 23 +- project/dae/managers.py | 115 +- ...pe__chg_field_dossiercomparaison_classement_.py | 980 ++++++++++++++ project/dae/models.py | 90 +- project/dae/templatetags/dae.py | 2 +- project/dae/views.py | 24 +- project/dae/workflow.py | 36 +- project/recrutement/urls.py | 2 +- project/rh/groups.py | 40 + project/rh/managers.py | 119 ++ ...raison_implantation__chg_field_evenement_dat.py | 1336 ++++++++++++++++++++ project/rh/models.py | 37 +- project/urls.py | 2 +- 15 files changed, 2536 insertions(+), 295 deletions(-) create mode 100644 project/dae/migrations/0058_auto__chg_field_contrat_type__chg_field_dossiercomparaison_classement_.py create mode 100644 project/rh/groups.py create mode 100644 project/rh/managers.py create mode 100644 project/rh/migrations/0003_auto__chg_field_postecomparaison_implantation__chg_field_evenement_dat.py diff --git a/buildout.cfg b/buildout.cfg index 17b5623..f1606fe 100644 --- a/buildout.cfg +++ b/buildout.cfg @@ -15,6 +15,7 @@ find-links = http://pypi.auf.org/simple/auf.recipe.django/ http://pypi.auf.org/simple/auf.django.references/ develop = src/qbe + /net/nfs-authnss.b.ca.auf/home/olivier.larcheveque/Projets/olivier/auf.django.metadata eggs = django diff --git a/project/dae/catalogues.py b/project/dae/catalogues.py index 9474baf..082cf10 100644 --- a/project/dae/catalogues.py +++ b/project/dae/catalogues.py @@ -13,16 +13,16 @@ class Responsable(object): self.q = q postes = rh.Poste.objects.filter( - Q(poste1__complement1__icontains=q) | + Q(nom__icontains=q) | Q(type_poste__nom__icontains=q) | - Q(poste1__employe__nom__icontains=q) | - Q(poste1__employe__prenom__icontains=q) + Q(dossiers__employe__nom__icontains=q) | + Q(dossiers__employe__prenom__icontains=q) ).distinct() return postes def format_result(self, poste): q = self.q - filtre = Q(poste1=poste) & (Q(complement1__icontains=q) | Q(employe__nom__icontains=q) | Q(employe__prenom__icontains=q)) + filtre = Q(poste=poste) & (Q(poste__nom__icontains=q) | Q(employe__nom__icontains=q) | Q(employe__prenom__icontains=q)) dossiers = rh.Dossier.objects.filter(filtre) # certains postes ont un id de type de poste qui n'existe pas @@ -33,11 +33,14 @@ class Responsable(object): if len(dossiers) == 1: dossier = dossiers[0] - return "[%s] %s %s (%s) (%s)" % (poste.implantation.id, nom_poste, dossier.complement1, poste.id, dossier.employe) + if nom_poste == poste.nom: + return "[%s] %s (%s) (%s)" % (poste.implantation.id, nom_poste, poste.id, dossier.employe) + else: + return "[%s] %s %s (%s) (%s)" % (poste.implantation.id, nom_poste, poste.nom, poste.id, dossier.employe) else: - dossiers = poste.poste1.all().order_by("-id") + dossiers = poste.dossiers.all() if len(dossiers) > 0: - complement1 = dossiers[0].complement1 + complement1 = dossiers[0].poste.nom employe = unicode(dossiers[0].employe) return "[%s] %s %s (%s) (%s)" % (poste.implantation.id, nom_poste, complement1, poste.id, employe) @@ -91,11 +94,10 @@ class Dossier(object): class Poste(object): def get_query(self,q,request): - employe = get_employe_from_user(request.user) - prefixe_implantation = 'poste1__implantation' + prefixe_implantation = 'poste__implantation' - q_recherche = Q(complement1__icontains=q) | Q(poste1__type_poste__nom__icontains=q) + q_recherche = Q(poste__nom__icontains=q) | Q(poste__type_poste__nom__icontains=q) if is_user_dans_services_centraux(request.user): q_place = Q(**{ '%s' % prefixe_implantation : employe.implantation }) @@ -110,7 +112,7 @@ class Poste(object): return rh.Dossier.objects.filter(q_filtre).distinct() def format_result(self, dossier): - return u"[%s] %s" % (dossier.poste1.implantation, dossier.poste1.type_poste.nom) + return u"[%s] %s" % (dossier.poste.implantation, dossier.poste.type_poste.nom) def format_item(self, dossier): """ the display of a currently selected object in the area below the search box. html is OK """ diff --git a/project/dae/decorators.py b/project/dae/decorators.py index 5ba749d..49f53fa 100644 --- a/project/dae/decorators.py +++ b/project/dae/decorators.py @@ -112,27 +112,10 @@ def vieux_dossier_dans_ma_region_ou_service(fn): def inner(request, *args, **kwargs): user = request.user dossier_id = kwargs.get('dossier_id', None) - - employe = get_employe_from_user(request.user) - prefixe_implantation = 'poste__implantation' - - #if is_user_dans_service(request.user): - # q_place = Q(**{ '%s' % prefixe_implantation : employe.implantation }) - #else: - # q_place = Q(**{ '%s__region' % prefixe_implantation : employe.implantation.region }) - - q_place = Q(**{ '%s__region' % prefixe_implantation : employe.implantation.region }) - - - if grp_drh in request.user.groups.all(): - q_filtre = Q(id=dossier_id) - else: - q_filtre = q_place & Q(id=dossier_id) - - try: - dossier = rh.Dossier.objects.get(q_filtre) + dossiers = rh.Dossier.objects.ma_region_ou_service(user).filter(id=dossier_id) + if len(dossiers) > 0: return fn(request, *args, **kwargs) - except Exception, e: + else: msg = u"Vous n'avez pas le droit de consulter ce dossier d'embauche." return redirect_interdiction(request, msg) diff --git a/project/dae/managers.py b/project/dae/managers.py index c38d8d0..197d64c 100644 --- a/project/dae/managers.py +++ b/project/dae/managers.py @@ -3,12 +3,7 @@ from django.db import models from django.db.models import Q from utils import get_employe_from_user -from workflow import POSTE_ETAT_HAUTE_DIRECTION, \ - POSTE_ETAT_ACCIOR, \ - POSTE_ETAT_ABF, \ - DOSSIER_ETAT_ACCIOR, \ - DOSSIER_ETAT_ABF, \ - MAP_GROUPE_ETATS_A_FAIRE +from workflow import MAP_GROUPE_ETATS_A_FAIRE from workflow import dae_groupes, \ grp_administrateurs, \ grp_directeurs_bureau, \ @@ -20,11 +15,13 @@ from workflow import dae_groupes, \ grp_service_utilisateurs, \ grp_correspondants_rh +from rh.managers import DossierManager as RHDossierManager +from rh.managers import PosteManager as RHPosteManager +from rh.managers import PosteComparaisonManager as RHPosteComparaisonManager +from rh.managers import DossierComparaisonManager as RHDossierComparaisonManager -class SecurityManager(models.Manager): - prefixe_service = None - prefixe_implantation = None +class TodoManagerMixin(object): def mes_choses_a_faire(self, user): q = Q() @@ -48,99 +45,15 @@ class SecurityManager(models.Manager): return qs - def ma_region_ou_service(self, user): - """ - Filtrage des postes en fonction du user connecté (region / service) - On s'intéresse aussi au groupe auquel appartient le user car certains groupes - peuvent tout voir. - """ - employe = get_employe_from_user(user) - - ############################################ - # TRAITEMENT NORMAL - ############################################ - # REGION - q = Q(**{ self.prefixe_implantation : employe.implantation.region }) - - # SERVICE - if self.prefixe_service and grp_service_utilisateurs in user.groups.all(): - q = q | Q(**{ self.prefixe_service : employe.service}) - - liste = self.get_query_set().filter(q) - - ############################################ - # TRAITEMENT ACCIOR - ############################################ - if grp_accior in user.groups.all(): - liste = self.get_query_set().all() - - ############################################ - # TRAITEMENT ABF - ############################################ - if grp_abf in user.groups.all(): - liste = self.get_query_set().all() - - ############################################ - # TRAITEMENT HAUTE DIRECTION - ############################################ - if grp_haute_direction in user.groups.all(): - liste = self.get_query_set().all() - - ############################################ - # TRAITEMENT DRH - ############################################ - if grp_drh in user.groups.all() or grp_drh2 in user.groups.all(): - liste = self.get_query_set().all() - - return liste - - -class PosteManager(SecurityManager): - """ - Chargement de tous les objets FK existants sur chaque QuerySet. - """ - prefixe_service = "service" - prefixe_implantation = "implantation__region" - - def ma_region_ou_service(self, user): - return super(PosteManager, self).ma_region_ou_service(user).filter(actif=True) - - def get_query_set(self): - fkeys = ( - 'id_rh', - 'responsable', - 'implantation', - 'implantation.bureau_rattachement', - '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 DossierManager(SecurityManager): - prefixe_service = "poste__service" - prefixe_implantation = "poste__implantation__region" - - def get_query_set(self): - fkeys = ( - 'poste', - ) - return super(DossierManager, self).get_query_set() \ - .select_related(*fkeys).all() +class DossierManager(RHDossierManager, TodoManagerMixin): + pass - def ma_region_ou_service(self, user): - return super(DossierManager, self).ma_region_ou_service(user).filter(poste__actif=True) +class PosteManager(RHPosteManager, TodoManagerMixin): + pass +class PosteComparaisonManager(RHPosteComparaisonManager, TodoManagerMixin): + pass -class PosteComparaisonManager(SecurityManager): - use_for_related_fields = True - prefixe_implantation = "implantation__region" +class DossierComparaisonManager(RHDossierComparaisonManager, TodoManagerMixin): + pass -class DossierComparaisonManager(SecurityManager): - use_for_related_fields = True - prefixe_implantation = "implantation__region" diff --git a/project/dae/migrations/0058_auto__chg_field_contrat_type__chg_field_dossiercomparaison_classement_.py b/project/dae/migrations/0058_auto__chg_field_contrat_type__chg_field_dossiercomparaison_classement_.py new file mode 100644 index 0000000..c2337f7 --- /dev/null +++ b/project/dae/migrations/0058_auto__chg_field_contrat_type__chg_field_dossiercomparaison_classement_.py @@ -0,0 +1,980 @@ +# encoding: utf-8 +import datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + +class Migration(SchemaMigration): + + def forwards(self, orm): + + # Changing field 'Contrat.type' + db.alter_column('dae_contrat', 'type_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh.TypeContrat'])) + + # Changing field 'DossierComparaison.classement' + db.alter_column('dae_dossiercomparaison', 'classement_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Classement'])) + + # Changing field 'DossierComparaison.statut' + db.alter_column('dae_dossiercomparaison', 'statut_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Statut'])) + + # Changing field 'DossierComparaison.devise' + db.alter_column('dae_dossiercomparaison', 'devise_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Devise'])) + + # Changing field 'PosteComparaison.classement' + db.alter_column('dae_postecomparaison', 'classement_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Classement'])) + + # Changing field 'PosteComparaison.statut' + db.alter_column('dae_postecomparaison', 'statut_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Statut'])) + + # Changing field 'PosteComparaison.devise' + db.alter_column('dae_postecomparaison', 'devise_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Devise'])) + + # Changing field 'Dossier.classement' + db.alter_column('dae_dossier', 'classement_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Classement'])) + + # Changing field 'Dossier.statut_anterieur' + db.alter_column('dae_dossier', 'statut_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Statut'])) + + # Changing field 'Dossier.devise' + db.alter_column('dae_dossier', 'devise_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh.Devise'])) + + # Changing field 'Dossier.type_contrat_anterieur' + db.alter_column('dae_dossier', 'type_contrat_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.TypeContrat'])) + + # Changing field 'Dossier.classement_anterieur' + db.alter_column('dae_dossier', 'classement_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Classement'])) + + # Changing field 'Dossier.organisme_bstg' + db.alter_column('dae_dossier', 'organisme_bstg_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.OrganismeBstg'])) + + # Changing field 'Dossier.type_contrat' + db.alter_column('dae_dossier', 'type_contrat_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh.TypeContrat'])) + + # Changing field 'Dossier.devise_anterieur' + db.alter_column('dae_dossier', 'devise_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Devise'])) + + # Changing field 'Dossier.classement_titulaire_anterieur' + db.alter_column('dae_dossier', 'classement_titulaire_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Classement'])) + + # Changing field 'Dossier.statut' + db.alter_column('dae_dossier', 'statut_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh.Statut'])) + + # Changing field 'Dossier.statut_titulaire_anterieur' + db.alter_column('dae_dossier', 'statut_titulaire_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Statut'])) + + # Changing field 'Dossier.employe_anterieur' + db.alter_column('dae_dossier', 'employe_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Employe'])) + + # Changing field 'Dossier.devise_titulaire_anterieur' + db.alter_column('dae_dossier', 'devise_titulaire_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['rh.Devise'])) + + # Adding field 'Poste.indemn_min' + db.add_column('dae_poste', 'indemn_min', self.gf('django.db.models.fields.DecimalField')(default=0, null=True, max_digits=12, decimal_places=2), keep_default=False) + + # Adding field 'Poste.supprime' + db.add_column('dae_poste', 'supprime', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True), keep_default=False) + + # Adding field 'Poste.user_activation' + db.add_column('dae_poste', 'user_activation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='user_activation', to=orm['auth.User']), keep_default=False) + + # Adding field 'Poste.date_validation' + db.add_column('dae_poste', 'date_validation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True), keep_default=False) + + # Adding field 'Poste.indemn_max' + db.add_column('dae_poste', 'indemn_max', self.gf('django.db.models.fields.DecimalField')(default=0, null=True, max_digits=12, decimal_places=2), keep_default=False) + + # Adding field 'Poste.nom_feminin' + db.add_column('dae_poste', 'nom_feminin', self.gf('django.db.models.fields.CharField')(max_length=255, null=True), keep_default=False) + + # Adding field 'Poste.user_creation' + db.add_column('dae_poste', 'user_creation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='user_creation', to=orm['auth.User']), keep_default=False) + + # Adding field 'Poste.date_activation' + db.add_column('dae_poste', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True), keep_default=False) + + # Adding field 'Poste.user_modification' + db.add_column('dae_poste', 'user_modification', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='user_modification', to=orm['auth.User']), keep_default=False) + + # Adding field 'Poste.user_desactivation' + db.add_column('dae_poste', 'user_desactivation', self.gf('django.db.models.fields.related.ForeignKey')(related_name='+', blank=True, null=True, db_column='user_desactivation', to=orm['auth.User']), keep_default=False) + + # Adding field 'Poste.date_desactivation' + db.add_column('dae_poste', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True), keep_default=False) + + # Renaming column for 'Poste.devise_max' to match new field type. + db.rename_column('dae_poste', 'devise_max_id', 'devise_max') + # Changing field 'Poste.devise_max' + db.alter_column('dae_poste', 'devise_max', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='devise_max', to=orm['rh.Devise'])) + + # Changing field 'Poste.expatrie' + db.alter_column('dae_poste', 'expatrie', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)) + + # Changing field 'Poste.salaire_min' + db.alter_column('dae_poste', 'salaire_min', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)) + + # Renaming column for 'Poste.type_poste' to match new field type. + db.rename_column('dae_poste', 'type_poste_id', 'type_poste') + # Changing field 'Poste.type_poste' + db.alter_column('dae_poste', 'type_poste', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='type_poste', to=orm['rh.TypePoste'])) + + # Renaming column for 'Poste.devise_comparaison' to match new field type. + db.rename_column('dae_poste', 'devise_comparaison_id', 'devise_comparaison') + # Changing field 'Poste.devise_comparaison' + db.alter_column('dae_poste', 'devise_comparaison', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='devise_comparaison', to=orm['rh.Devise'])) + + # Renaming column for 'Poste.service' to match new field type. + db.rename_column('dae_poste', 'service_id', 'service') + # Changing field 'Poste.service' + db.alter_column('dae_poste', 'service', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='service', to=orm['rh.Service'])) + + # Renaming column for 'Poste.valeur_point_max' to match new field type. + db.rename_column('dae_poste', 'valeur_point_max_id', 'valeur_point_max') + # Changing field 'Poste.valeur_point_max' + db.alter_column('dae_poste', 'valeur_point_max', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, db_column='valeur_point_max', to=orm['rh.ValeurPoint'])) + + # Renaming column for 'Poste.implantation' to match new field type. + db.rename_column('dae_poste', 'implantation_id', 'implantation') + # Changing field 'Poste.implantation' + db.alter_column('dae_poste', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(db_column='implantation', to=orm['references.Implantation'])) + + # Renaming column for 'Poste.responsable' to match new field type. + db.rename_column('dae_poste', 'responsable_id', 'responsable') + # Changing field 'Poste.responsable' + db.alter_column('dae_poste', 'responsable', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='responsable', to=orm['rh.Poste'])) + + # Changing field 'Poste.regime_travail' + db.alter_column('dae_poste', 'regime_travail', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)) + + # Changing field 'Poste.date_modification' + db.alter_column('dae_poste', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Renaming column for 'Poste.devise_min' to match new field type. + db.rename_column('dae_poste', 'devise_min_id', 'devise_min') + # Changing field 'Poste.devise_min' + db.alter_column('dae_poste', 'devise_min', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='devise_min', to=orm['rh.Devise'])) + + # Changing field 'Poste.mise_a_disposition' + db.alter_column('dae_poste', 'mise_a_disposition', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)) + + # Changing field 'Poste.justification' + db.alter_column('dae_poste', 'justification', self.gf('django.db.models.fields.TextField')(null=True, blank=True)) + + # Changing field 'Poste.indemn_expat_min' + db.alter_column('dae_poste', 'indemn_expat_min', self.gf('django.db.models.fields.DecimalField')(max_digits=13, decimal_places=2)) + + # Changing field 'Poste.autre_min' + db.alter_column('dae_poste', 'autre_min', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)) + + # Changing field 'Poste.appel' + db.alter_column('dae_poste', 'appel', self.gf('django.db.models.fields.CharField')(max_length=10, null=True)) + + # Changing field 'Poste.date_creation' + db.alter_column('dae_poste', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Poste.autre_max' + db.alter_column('dae_poste', 'autre_max', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)) + + # Renaming column for 'Poste.valeur_point_min' to match new field type. + db.rename_column('dae_poste', 'valeur_point_min_id', 'valeur_point_min') + # Changing field 'Poste.valeur_point_min' + db.alter_column('dae_poste', 'valeur_point_min', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, db_column='valeur_point_min', to=orm['rh.ValeurPoint'])) + + # Changing field 'Poste.local' + db.alter_column('dae_poste', 'local', self.gf('django.db.models.fields.NullBooleanField')(null=True, blank=True)) + + # Renaming column for 'Poste.classement_max' to match new field type. + db.rename_column('dae_poste', 'classement_max_id', 'classement_max') + # Changing field 'Poste.classement_max' + db.alter_column('dae_poste', 'classement_max', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, db_column='classement_max', to=orm['rh.Classement'])) + + # Changing field 'Poste.id_rh' + db.alter_column('dae_poste', 'id_rh_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh.Poste'])) + + # Changing field 'Poste.salaire_max' + db.alter_column('dae_poste', 'salaire_max', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)) + + # Renaming column for 'Poste.classement_min' to match new field type. + db.rename_column('dae_poste', 'classement_min_id', 'classement_min') + # Changing field 'Poste.classement_min' + db.alter_column('dae_poste', 'classement_min', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, db_column='classement_min', to=orm['rh.Classement'])) + + # Changing field 'Poste.regime_travail_nb_heure_semaine' + db.alter_column('dae_poste', 'regime_travail_nb_heure_semaine', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)) + + # Changing field 'Remuneration.devise' + db.alter_column('dae_remuneration', 'devise', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='devise', to=orm['rh.Devise'])) + + # Changing field 'Remuneration.type' + db.alter_column('dae_remuneration', 'type', self.gf('django.db.models.fields.related.ForeignKey')(db_column='type', to=orm['rh.TypeRemuneration'])) + + # Changing field 'Employe.id_rh' + db.alter_column('dae_employe', 'id_rh_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh.Employe'])) + + + def backwards(self, orm): + + # Changing field 'Contrat.type' + db.alter_column('dae_contrat', 'type_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeContrat'])) + + # Changing field 'DossierComparaison.classement' + db.alter_column('dae_dossiercomparaison', 'classement_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'DossierComparaison.statut' + db.alter_column('dae_dossiercomparaison', 'statut_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Statut'], blank=True)) + + # Changing field 'DossierComparaison.devise' + db.alter_column('dae_dossiercomparaison', 'devise_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Devise'], blank=True)) + + # Changing field 'PosteComparaison.classement' + db.alter_column('dae_postecomparaison', 'classement_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'PosteComparaison.statut' + db.alter_column('dae_postecomparaison', 'statut_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Statut'], blank=True)) + + # Changing field 'PosteComparaison.devise' + db.alter_column('dae_postecomparaison', 'devise_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Devise'], blank=True)) + + # Changing field 'Dossier.classement' + db.alter_column('dae_dossier', 'classement_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'Dossier.statut_anterieur' + db.alter_column('dae_dossier', 'statut_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Statut'], blank=True)) + + # Changing field 'Dossier.devise' + db.alter_column('dae_dossier', 'devise_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'])) + + # Changing field 'Dossier.type_contrat_anterieur' + db.alter_column('dae_dossier', 'type_contrat_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.TypeContrat'], blank=True)) + + # Changing field 'Dossier.classement_anterieur' + db.alter_column('dae_dossier', 'classement_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'Dossier.organisme_bstg' + db.alter_column('dae_dossier', 'organisme_bstg_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.OrganismeBstg'], blank=True)) + + # Changing field 'Dossier.type_contrat' + db.alter_column('dae_dossier', 'type_contrat_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeContrat'])) + + # Changing field 'Dossier.devise_anterieur' + db.alter_column('dae_dossier', 'devise_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Devise'], blank=True)) + + # Changing field 'Dossier.classement_titulaire_anterieur' + db.alter_column('dae_dossier', 'classement_titulaire_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'Dossier.statut' + db.alter_column('dae_dossier', 'statut_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Statut'])) + + # Changing field 'Dossier.statut_titulaire_anterieur' + db.alter_column('dae_dossier', 'statut_titulaire_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Statut'], blank=True)) + + # Changing field 'Dossier.employe_anterieur' + db.alter_column('dae_dossier', 'employe_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Employe'], blank=True)) + + # Changing field 'Dossier.devise_titulaire_anterieur' + db.alter_column('dae_dossier', 'devise_titulaire_anterieur_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Devise'], blank=True)) + + # Deleting field 'Poste.indemn_min' + db.delete_column('dae_poste', 'indemn_min') + + # Deleting field 'Poste.supprime' + db.delete_column('dae_poste', 'supprime') + + # Deleting field 'Poste.user_activation' + db.delete_column('dae_poste', 'user_activation') + + # Deleting field 'Poste.date_validation' + db.delete_column('dae_poste', 'date_validation') + + # Deleting field 'Poste.indemn_max' + db.delete_column('dae_poste', 'indemn_max') + + # Deleting field 'Poste.nom_feminin' + db.delete_column('dae_poste', 'nom_feminin') + + # Deleting field 'Poste.user_creation' + db.delete_column('dae_poste', 'user_creation') + + # Deleting field 'Poste.date_activation' + db.delete_column('dae_poste', 'date_activation') + + # Deleting field 'Poste.user_modification' + db.delete_column('dae_poste', 'user_modification') + + # Deleting field 'Poste.user_desactivation' + db.delete_column('dae_poste', 'user_desactivation') + + # Deleting field 'Poste.date_desactivation' + db.delete_column('dae_poste', 'date_desactivation') + + # Renaming column for 'Poste.devise_max' to match new field type. + db.rename_column('dae_poste', 'devise_max', 'devise_max_id') + # Changing field 'Poste.devise_max' + db.alter_column('dae_poste', 'devise_max_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'])) + + # Changing field 'Poste.expatrie' + db.alter_column('dae_poste', 'expatrie', self.gf('django.db.models.fields.BooleanField')(blank=True)) + + # Changing field 'Poste.salaire_min' + db.alter_column('dae_poste', 'salaire_min', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Renaming column for 'Poste.type_poste' to match new field type. + db.rename_column('dae_poste', 'type_poste', 'type_poste_id') + # Changing field 'Poste.type_poste' + db.alter_column('dae_poste', 'type_poste_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.TypePoste'])) + + # Renaming column for 'Poste.devise_comparaison' to match new field type. + db.rename_column('dae_poste', 'devise_comparaison', 'devise_comparaison_id') + # Changing field 'Poste.devise_comparaison' + db.alter_column('dae_poste', 'devise_comparaison_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'])) + + # Renaming column for 'Poste.service' to match new field type. + db.rename_column('dae_poste', 'service', 'service_id') + # Changing field 'Poste.service' + db.alter_column('dae_poste', 'service_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Service'])) + + # Renaming column for 'Poste.valeur_point_max' to match new field type. + db.rename_column('dae_poste', 'valeur_point_max', 'valeur_point_max_id') + # Changing field 'Poste.valeur_point_max' + db.alter_column('dae_poste', 'valeur_point_max_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.ValeurPoint'], blank=True)) + + # Renaming column for 'Poste.implantation' to match new field type. + db.rename_column('dae_poste', 'implantation', 'implantation_id') + # Changing field 'Poste.implantation' + db.alter_column('dae_poste', 'implantation_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['references.Implantation'])) + + # Renaming column for 'Poste.responsable' to match new field type. + db.rename_column('dae_poste', 'responsable', 'responsable_id') + # Changing field 'Poste.responsable' + db.alter_column('dae_poste', 'responsable_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Poste'])) + + # Changing field 'Poste.regime_travail' + db.alter_column('dae_poste', 'regime_travail', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Changing field 'Poste.date_modification' + db.alter_column('dae_poste', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)) + + # Renaming column for 'Poste.devise_min' to match new field type. + db.rename_column('dae_poste', 'devise_min', 'devise_min_id') + # Changing field 'Poste.devise_min' + db.alter_column('dae_poste', 'devise_min_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'])) + + # Changing field 'Poste.mise_a_disposition' + db.alter_column('dae_poste', 'mise_a_disposition', self.gf('django.db.models.fields.BooleanField')(blank=True)) + + # Changing field 'Poste.justification' + db.alter_column('dae_poste', 'justification', self.gf('django.db.models.fields.TextField')()) + + # Changing field 'Poste.indemn_expat_min' + db.alter_column('dae_poste', 'indemn_expat_min', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Changing field 'Poste.autre_min' + db.alter_column('dae_poste', 'autre_min', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Changing field 'Poste.appel' + db.alter_column('dae_poste', 'appel', self.gf('django.db.models.fields.CharField')(max_length=10)) + + # Changing field 'Poste.date_creation' + db.alter_column('dae_poste', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)) + + # Changing field 'Poste.autre_max' + db.alter_column('dae_poste', 'autre_max', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Renaming column for 'Poste.valeur_point_min' to match new field type. + db.rename_column('dae_poste', 'valeur_point_min', 'valeur_point_min_id') + # Changing field 'Poste.valeur_point_min' + db.alter_column('dae_poste', 'valeur_point_min_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.ValeurPoint'], blank=True)) + + # Changing field 'Poste.local' + db.alter_column('dae_poste', 'local', self.gf('django.db.models.fields.BooleanField')(blank=True)) + + # Renaming column for 'Poste.classement_max' to match new field type. + db.rename_column('dae_poste', 'classement_max', 'classement_max_id') + # Changing field 'Poste.classement_max' + db.alter_column('dae_poste', 'classement_max_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'Poste.id_rh' + db.alter_column('dae_poste', 'id_rh_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Poste'])) + + # Changing field 'Poste.salaire_max' + db.alter_column('dae_poste', 'salaire_max', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Renaming column for 'Poste.classement_min' to match new field type. + db.rename_column('dae_poste', 'classement_min', 'classement_min_id') + # Changing field 'Poste.classement_min' + db.alter_column('dae_poste', 'classement_min_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Classement'], blank=True)) + + # Changing field 'Poste.regime_travail_nb_heure_semaine' + db.alter_column('dae_poste', 'regime_travail_nb_heure_semaine', self.gf('django.db.models.fields.DecimalField')(max_digits=12, decimal_places=2)) + + # Changing field 'Remuneration.devise' + db.alter_column('dae_remuneration', 'devise', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='devise', to=orm['rh_v1.Devise'])) + + # Changing field 'Remuneration.type' + db.alter_column('dae_remuneration', 'type', self.gf('django.db.models.fields.related.ForeignKey')(db_column='type', to=orm['rh_v1.TypeRemuneration'])) + + # Changing field 'Employe.id_rh' + db.alter_column('dae_employe', 'id_rh_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['rh_v1.Employe'])) + + + models = { + 'auth.group': { + 'Meta': {'object_name': 'Group'}, + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '80', 'unique': 'True'}), + 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}) + }, + 'auth.permission': { + 'Meta': {'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'}, + 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) + }, + 'auth.user': { + 'Meta': {'object_name': 'User'}, + 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}), + 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}), + 'username': ('django.db.models.fields.CharField', [], {'max_length': '30', 'unique': 'True'}) + }, + 'contenttypes.contenttype': { + 'Meta': {'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"}, + 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}) + }, + 'dae.contrat': { + 'Meta': {'object_name': 'Contrat'}, + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'contrats'", 'to': "orm['dae.Dossier']"}), + 'fichier': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['rh.TypeContrat']"}) + }, + 'dae.dossier': { + 'Meta': {'object_name': 'Dossier'}, + 'classement': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Classement']"}), + 'classement_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Classement']"}), + 'classement_titulaire_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Classement']"}), + 'compte_compta': ('django.db.models.fields.CharField', [], {'default': "'aucun'", 'max_length': '10'}), + 'compte_courriel': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'contrat_date_debut': ('django.db.models.fields.DateField', [], {}), + 'contrat_date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'dae_numerisee': ('django.db.models.fields.files.FileField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'to': "orm['rh.Devise']"}), + 'devise_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Devise']"}), + 'devise_titulaire_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Devise']"}), + 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['dae.Employe']"}), + 'employe_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Employe']"}), + 'etat': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'justif_nouveau_commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_nouveau_salaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_nouveau_statut': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_nouveau_tmp_remplacement': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_rempl_commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_rempl_evaluation': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_rempl_salaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_rempl_statut_employe': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'justif_rempl_type_contrat': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'organisme_bstg': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.OrganismeBstg']"}), + 'organisme_bstg_autre': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'dossiers'", 'to': "orm['dae.Poste']"}), + 'regime_travail': ('django.db.models.fields.DecimalField', [], {'default': '100.0', 'max_digits': '12', 'decimal_places': '2'}), + 'regime_travail_nb_heure_semaine': ('django.db.models.fields.DecimalField', [], {'default': '35.0', 'max_digits': '12', 'decimal_places': '2'}), + 'remplacement': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'salaire': ('django.db.models.fields.DecimalField', [], {'default': 'None', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'salaire_anterieur': ('django.db.models.fields.DecimalField', [], {'default': 'None', 'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'salaire_titulaire_anterieur': ('django.db.models.fields.DecimalField', [], {'default': 'None', 'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'statut': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['rh.Statut']"}), + 'statut_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Statut']"}), + 'statut_residence': ('django.db.models.fields.CharField', [], {'default': "'local'", 'max_length': '10'}), + 'statut_titulaire_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Statut']"}), + 'type_contrat': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to': "orm['rh.TypeContrat']"}), + 'type_contrat_anterieur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.TypeContrat']"}) + }, + 'dae.dossiercomparaison': { + 'Meta': {'object_name': 'DossierComparaison'}, + 'classement': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Classement']"}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Devise']"}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'comparaisons'", 'to': "orm['dae.Dossier']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['references.Implantation']"}), + 'montant': ('django.db.models.fields.IntegerField', [], {'null': 'True'}), + 'personne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'statut': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Statut']"}) + }, + 'dae.dossierpiece': { + 'Meta': {'object_name': 'DossierPiece'}, + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dae.Dossier']"}), + 'fichier': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}) + }, + 'dae.employe': { + 'Meta': {'object_name': 'Employe'}, + 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'id_rh': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'to': "orm['rh.Employe']"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}) + }, + 'dae.poste': { + 'Meta': {'object_name': 'Poste'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'appel': ('django.db.models.fields.CharField', [], {'default': "'interne'", 'max_length': '10', 'null': 'True'}), + 'autre_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'autre_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'charges_patronales_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '12', 'decimal_places': '2'}), + 'charges_patronales_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '12', 'decimal_places': '2'}), + 'classement_max': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement_max'", 'to': "orm['rh.Classement']"}), + 'classement_min': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement_min'", 'to': "orm['rh.Classement']"}), + 'comp_autre_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_autre_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_fonctionpub_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_fonctionpub_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_locale_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_locale_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_ong_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_ong_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_universite_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_universite_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_validation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise_comparaison': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_comparaison'", 'to': "orm['rh.Devise']"}), + 'devise_max': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_max'", 'to': "orm['rh.Devise']"}), + 'devise_min': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_min'", 'to': "orm['rh.Devise']"}), + 'etat': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'expatrie': ('django.db.models.fields.NullBooleanField', [], {'default': 'False', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'id_rh': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'to': "orm['rh.Poste']"}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'implantation'", 'to': "orm['references.Implantation']"}), + 'indemn_expat_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '12', 'decimal_places': '2'}), + 'indemn_expat_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '13', 'decimal_places': '2'}), + 'indemn_fct_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '12', 'decimal_places': '2'}), + 'indemn_fct_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '12', 'decimal_places': '2'}), + 'indemn_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'indemn_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'justification': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'local': ('django.db.models.fields.NullBooleanField', [], {'default': 'True', 'null': 'True', 'blank': 'True'}), + 'mise_a_disposition': ('django.db.models.fields.NullBooleanField', [], {'default': 'False', 'null': 'True', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}), + 'regime_travail': ('django.db.models.fields.DecimalField', [], {'default': '100.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'regime_travail_nb_heure_semaine': ('django.db.models.fields.DecimalField', [], {'default': '35.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'default': '149', 'related_name': "'+'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['rh.Poste']"}), + 'salaire_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'salaire_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'service': ('django.db.models.fields.related.ForeignKey', [], {'default': '1', 'related_name': "'+'", 'null': 'True', 'db_column': "'service'", 'to': "orm['rh.Service']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type_intervention': ('django.db.models.fields.CharField', [], {'default': "'N'", 'max_length': '1'}), + 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'db_column': "'type_poste'", 'to': "orm['rh.TypePoste']"}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'valeur_point_max': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'valeur_point_max'", 'to': "orm['rh.ValeurPoint']"}), + 'valeur_point_min': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'valeur_point_min'", 'to': "orm['rh.ValeurPoint']"}) + }, + 'dae.postecomparaison': { + 'Meta': {'object_name': 'PosteComparaison'}, + 'classement': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Classement']"}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Devise']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['references.Implantation']"}), + 'montant': ('django.db.models.fields.IntegerField', [], {'null': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'comparaisons_internes'", 'to': "orm['dae.Poste']"}), + 'statut': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Statut']"}) + }, + 'dae.postefinancement': { + 'Meta': {'object_name': 'PosteFinancement'}, + 'commentaire': ('django.db.models.fields.TextField', [], {}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'financements'", 'to': "orm['dae.Poste']"}), + 'pourcentage': ('django.db.models.fields.DecimalField', [], {'max_digits': '12', 'decimal_places': '2'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '1'}) + }, + 'dae.postepiece': { + 'Meta': {'object_name': 'PostePiece'}, + 'fichier': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dae.Poste']"}) + }, + 'dae.remuneration': { + 'Meta': {'object_name': 'Remuneration'}, + 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'to_field': "'code'", 'db_column': "'devise'", 'to': "orm['rh.Devise']"}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dae.Dossier']", 'db_column': "'dossier'"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'montant': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'type'", 'to': "orm['rh.TypeRemuneration']"}), + 'user_creation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}) + }, + 'references.bureau': { + 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Implantation']", 'db_column': "'implantation'"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Region']", 'db_column': "'region'"}) + }, + 'references.implantation': { + 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), + 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'adresse_physique_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_physique'", 'to_field': "'code'", 'db_column': "'adresse_physique_pays'", 'to': "orm['references.Pays']"}), + 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), + 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_postale'", 'to_field': "'code'", 'db_column': "'adresse_postale_pays'", 'to': "orm['references.Pays']"}), + 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Implantation']", 'db_column': "'bureau_rattachement'"}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}), + 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), + 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'modif_date': ('django.db.models.fields.DateField', [], {}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Region']", 'db_column': "'region'"}), + 'remarque': ('django.db.models.fields.TextField', [], {}), + 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'statut': ('django.db.models.fields.IntegerField', [], {}), + 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'}) + }, + 'references.pays': { + 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}), + 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}), + 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True', 'blank': 'True'}), + 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Region']", 'db_column': "'region'"}) + }, + 'references.region': { + 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'db_column': "'implantation_bureau'", 'to': "orm['references.Implantation']"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}) + }, + 'rh.classement': { + 'Meta': {'object_name': 'Classement'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'coefficient': ('django.db.models.fields.FloatField', [], {'default': '0', 'null': 'True'}), + 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'degre': ('django.db.models.fields.IntegerField', [], {}), + 'echelon': ('django.db.models.fields.IntegerField', [], {}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.devise': { + 'Meta': {'object_name': 'Devise'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'unique': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.employe': { + 'Meta': {'object_name': 'Employe'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employes_nationalite'", 'to_field': "'code'", 'db_column': "'nationalite'", 'to': "orm['references.Pays']"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_affichage': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employes'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['references.Pays']", 'blank': 'True', 'null': 'True'}), + 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'situation_famille': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'tel_cellulaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'tel_domicile': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}) + }, + 'rh.familleemploi': { + 'Meta': {'object_name': 'FamilleEmploi'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.organismebstg': { + 'Meta': {'object_name': 'OrganismeBstg'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'organismes_bstg'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['references.Pays']", 'blank': 'True', 'null': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.poste': { + 'Meta': {'object_name': 'Poste'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'appel': ('django.db.models.fields.CharField', [], {'default': "'interne'", 'max_length': '10', 'null': 'True'}), + 'autre_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'autre_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'classement_max': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement_max'", 'to': "orm['rh.Classement']"}), + 'classement_min': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement_min'", 'to': "orm['rh.Classement']"}), + 'comp_autre_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_autre_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_fonctionpub_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_fonctionpub_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_locale_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_locale_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_ong_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_ong_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_universite_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_universite_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_validation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise_comparaison': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_comparaison'", 'to': "orm['rh.Devise']"}), + 'devise_max': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_max'", 'to': "orm['rh.Devise']"}), + 'devise_min': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_min'", 'to': "orm['rh.Devise']"}), + 'expatrie': ('django.db.models.fields.NullBooleanField', [], {'default': 'False', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'implantation'", 'to': "orm['references.Implantation']"}), + 'indemn_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'indemn_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'justification': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'local': ('django.db.models.fields.NullBooleanField', [], {'default': 'True', 'null': 'True', 'blank': 'True'}), + 'mise_a_disposition': ('django.db.models.fields.NullBooleanField', [], {'default': 'False', 'null': 'True', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}), + 'regime_travail': ('django.db.models.fields.DecimalField', [], {'default': '100.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'regime_travail_nb_heure_semaine': ('django.db.models.fields.DecimalField', [], {'default': '35.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'default': '149', 'related_name': "'+'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['rh.Poste']"}), + 'salaire_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'salaire_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'service': ('django.db.models.fields.related.ForeignKey', [], {'default': '1', 'related_name': "'+'", 'null': 'True', 'db_column': "'service'", 'to': "orm['rh.Service']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'db_column': "'type_poste'", 'to': "orm['rh.TypePoste']"}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'valeur_point_max': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'valeur_point_max'", 'to': "orm['rh.ValeurPoint']"}), + 'valeur_point_min': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'valeur_point_min'", 'to': "orm['rh.ValeurPoint']"}) + }, + 'rh.service': { + 'Meta': {'object_name': 'Service'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.statut': { + 'Meta': {'object_name': 'Statut'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '25', 'unique': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typecontrat': { + 'Meta': {'object_name': 'TypeContrat'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typeposte': { + 'Meta': {'object_name': 'TypePoste'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'famille_emploi': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'famille_emploi'", 'to': "orm['rh.FamilleEmploi']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_responsable': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typeremuneration': { + 'Meta': {'object_name': 'TypeRemuneration'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nature_remuneration': ('django.db.models.fields.CharField', [], {'max_length': '30'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type_paiement': ('django.db.models.fields.CharField', [], {'max_length': '30'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.valeurpoint': { + 'Meta': {'object_name': 'ValeurPoint'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'annee': ('django.db.models.fields.IntegerField', [], {}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise'", 'to': "orm['rh.Devise']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'rh_valeur_point'", 'db_column': "'implantation'", 'to': "orm['references.Implantation']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'valeur': ('django.db.models.fields.FloatField', [], {'null': 'True'}) + }, + 'workflow.workflowcommentaire': { + 'Meta': {'object_name': 'WorkflowCommentaire'}, + 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}), + 'date': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'etat_final': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'etat_initial': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'object_id': ('django.db.models.fields.PositiveIntegerField', [], {}), + 'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']"}), + 'texte': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}) + } + } + + complete_apps = ['dae'] diff --git a/project/dae/models.py b/project/dae/models.py index d268a3f..12e80cf 100644 --- a/project/dae/models.py +++ b/project/dae/models.py @@ -5,13 +5,12 @@ from django.conf import settings from django.core.files.storage import FileSystemStorage from django.db import models import reversion +from rh import models as rh from workflow import PosteWorkflow, DossierWorkflow from workflow import DOSSIER_ETAT_DRH_FINALISATION, DOSSIER_ETAT_REGION_FINALISATION, \ DOSSIER_ETAT_FINALISE -from managers import DossierManager, PosteManager, PosteComparaisonManager, \ - DossierComparaisonManager import auf.django.references.models as ref -from rh import models as rh +from managers import * # Constantes @@ -40,7 +39,7 @@ class DeviseException(Exception): silent_variable_failure = True -class Poste(PosteWorkflow, models.Model): +class Poste(PosteWorkflow, rh.Poste_): type_intervention = models.CharField(max_length=1, choices=POSTE_ACTION, default='N') @@ -48,93 +47,14 @@ class Poste(PosteWorkflow, models.Model): id_rh = models.ForeignKey(rh.Poste, null=True, related_name='+', editable=False, verbose_name=u"Mise à jour du poste") - nom = models.CharField(verbose_name=u"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, related_name='+', - verbose_name=u"Direction/Service/Pôle support") - responsable = models.ForeignKey(rh.Poste, related_name='+', - verbose_name=u"Poste du responsable") - - # Contrat - regime_travail = models.DecimalField(max_digits=12, decimal_places=2, - default=REGIME_TRAVAIL_DEFAULT, - verbose_name=u"Temps de travail", - help_text="% du temps complet") - regime_travail_nb_heure_semaine = models.DecimalField(max_digits=12, - decimal_places=2, - default=REGIME_TRAVAIL_NB_HEURE_SEMAINE_DEFAULT, - verbose_name=u"Nb. heures par semaine") - - # Recrutement - local = models.BooleanField(verbose_name=u"Local", default=True, blank=True) - expatrie = models.BooleanField(verbose_name=u"Expatrié", default=False, - blank=True) - mise_a_disposition = models.BooleanField(verbose_name=u"Mise à disposition") - appel = models.CharField(max_length=10, default='interne', - verbose_name=u"Appel à candidature", - choices=POSTE_APPEL_CHOICES) # Rémunération - classement_min = models.ForeignKey(rh.Classement, related_name='+', - blank=True, null=True) - classement_max = models.ForeignKey(rh.Classement, related_name='+', - blank=True, null=True) - valeur_point_min = models.ForeignKey(rh.ValeurPoint, related_name='+', - blank=True, null=True) - valeur_point_max = models.ForeignKey(rh.ValeurPoint, related_name='+', - blank=True, null=True) - devise_min = models.ForeignKey(rh.Devise, default=5, related_name='+') - devise_max = models.ForeignKey(rh.Devise, default=5, 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_expat_min = models.DecimalField(max_digits=12, decimal_places=2, default=0) + indemn_expat_min = models.DecimalField(max_digits=13, decimal_places=2, default=0) indemn_expat_max = models.DecimalField(max_digits=12, decimal_places=2, default=0) indemn_fct_min = models.DecimalField(max_digits=12, decimal_places=2, default=0) indemn_fct_max = models.DecimalField(max_digits=12, decimal_places=2, default=0) charges_patronales_min = models.DecimalField(max_digits=12, decimal_places=2, default=0) charges_patronales_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='+', - default=5) - 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) - - # Justification - justification = models.TextField() - - # Méta - date_creation = models.DateTimeField(auto_now_add=True) - date_modification = models.DateTimeField(auto_now=True) - date_debut = models.DateField(verbose_name=u"Date de début", - help_text=HELP_TEXT_DATE, - null=True, blank=True) - date_fin = models.DateField(null=True, blank=True, - verbose_name=u"Date de fin", - help_text=HELP_TEXT_DATE) - actif = models.BooleanField(default=True) # Managers objects = PosteManager() @@ -406,6 +326,8 @@ class PosteComparaison(models.Model): objects = PosteComparaisonManager() def taux_devise(self): + if not self.devise: + return None if self.devise.code == 'EUR': return 1 liste_taux = self.devise.tauxchange_set.order_by('-annee') diff --git a/project/dae/templatetags/dae.py b/project/dae/templatetags/dae.py index 45ead51..fbcf420 100644 --- a/project/dae/templatetags/dae.py +++ b/project/dae/templatetags/dae.py @@ -4,7 +4,7 @@ import os from django import template from project.dae.workflow import ETATS_EDITABLE -from project.dae.workflow import grp_correspondants_rh, grp_administrateurs, grp_drh +from project.rh.groups import grp_correspondants_rh, grp_administrateurs, grp_drh register = template.Library() diff --git a/project/dae/views.py b/project/dae/views.py index 3519796..13450ef 100644 --- a/project/dae/views.py +++ b/project/dae/views.py @@ -8,6 +8,7 @@ from datetime import date from simplejson import dumps import warnings +from django.core.exceptions import MultipleObjectsReturned from django.core.urlresolvers import reverse from django.core.paginator import Paginator, InvalidPage from django.http import Http404, HttpResponse, HttpResponseGone @@ -656,14 +657,14 @@ def poste_resume(request, dossier_id=None): except: return HttpResponseGone("Ce dossier n'est pas accessible") + salaire = dossier.get_salaire() data = {} data['implantation'] = dossier.poste.implantation.id - data['poste'] = u"%s %s" % (dossier.poste1.type_poste.nom, dossier.complement1) - data['montant'] = dossier.get_salaire() - salaire = dossier.get_dernier_salaire_remun() + data['poste'] = u"%s %s" % (dossier.poste.type_poste.nom, dossier.poste.nom) + data['montant'] = salaire.montant if salaire is not None: data['devise'] = salaire.devise.id - data['montant_euros'] = salaire.en_euros() + data['montant_euros'] = salaire.montant_euro() else: data['devise'] = None data['montant_euros'] = 0 @@ -738,9 +739,12 @@ def devise(request): valeur_point = params.get('valeur_point') valeur_point = rh.ValeurPoint.objects.get(pk=valeur_point) annee = valeur_point.annee - implantation = valeur_point.implantation - taux = rh.TauxChange.objects.get(annee=annee, - implantation=implantation) + try: + taux = rh.TauxChange.objects.get(annee=annee, devise=valeur_point.devise) + except MultipleObjectsReturned: + return HttpResponseGone(u"Il existe plusieurs taux pour la devise %s cette année-là : %s" % \ + (valeur_point.devise.code, annee)) + data['devise'] = taux.devise.id data['valeur'] = valeur_point.valeur data['devise_code'] = taux.devise.code @@ -811,11 +815,11 @@ def liste_valeurs_point(request): implantation_id = params.get('implantation_id') preselectionne = rh.ValeurPoint.objects.filter(implantation=implantation_id, annee__in=(annee_courante,)).order_by("-annee") for o in preselectionne: - data.append({'id' : o.id, 'label' : o.__unicode__(), 'devise' : o.get_tauxchange_courant().devise.id, 'suggestion' : True}) + data.append({'id' : o.id, 'label' : o.__unicode__(), 'devise' : o.devise_id, 'suggestion' : True}) else: preselectionne = rh.ValeurPoint.objects.none() liste_complete = rh.ValeurPoint.objects.filter(annee__in=(annee_courante,)).order_by("-annee") for o in liste_complete.exclude(id__in=[p.id for p in preselectionne]): - data.append({'id' : o.id, 'label' : o.__unicode__(), 'devise' : o.get_tauxchange_courant().devise.id, 'suggestion' : False}) - return HttpResponse(dumps(data)) + data.append({'id' : o.id, 'label' : o.__unicode__(), 'devise' : o.devise_id, 'suggestion' : False}) + return HttpResponse(dumps(data, indent=4)) diff --git a/project/dae/workflow.py b/project/dae/workflow.py index 399a409..b22924e 100644 --- a/project/dae/workflow.py +++ b/project/dae/workflow.py @@ -3,41 +3,7 @@ from django.contrib.auth.models import Group from auf.django.workflow.models import WorkflowMixin from utils import is_user_dans_services_centraux, is_user_dans_region - -def safe_create_groupe(name): - """ - Création d'un groupe prédéfini. Retourne None, quand la création - ne peut se faire. (C'est le cas au syncdb, quand la table de groupe - n'a pas été crée encore). - """ - try: - grp, created = Group.objects.get_or_create(name=name) - except: - return None - return grp - -# Groupes impliqués dans le Worflow -grp_correspondants_rh = safe_create_groupe(name='Correspondants RH') -grp_administrateurs = safe_create_groupe(name='Administrateurs') -grp_directeurs_bureau = safe_create_groupe(name='Directeurs de bureau') -grp_drh = safe_create_groupe(name='DRH') -grp_drh2 = safe_create_groupe(name='DRH-2') -grp_accior = safe_create_groupe(name='ACCIOR') -grp_abf = safe_create_groupe(name='ABF') -grp_haute_direction = safe_create_groupe(name='Haute direction') -grp_service_utilisateurs = safe_create_groupe(name='Service utilisateurs') - -dae_groupes = ( - grp_correspondants_rh, - grp_administrateurs, - grp_directeurs_bureau, - grp_drh, - grp_drh2, - grp_accior, - grp_abf, - grp_haute_direction, - grp_service_utilisateurs, -) +from rh.groups import * # codes états POSTE_ETAT_BROUILLON = 'BROUILLON' diff --git a/project/recrutement/urls.py b/project/recrutement/urls.py index c774b20..6db004b 100644 --- a/project/recrutement/urls.py +++ b/project/recrutement/urls.py @@ -4,7 +4,7 @@ from django.conf.urls.defaults import patterns, url from auf.django.emploi import settings urlpatterns = patterns('recrutement.views', - url(r'^$', 'index', name='index'), + url(r'^$', 'index', name='recrutement_index'), (r'^prive/(?P.*)$', 'mediaserve', {'document_root': settings.OE_PRIVE_MEDIA_ROOT}), diff --git a/project/rh/groups.py b/project/rh/groups.py new file mode 100644 index 0000000..02dc367 --- /dev/null +++ b/project/rh/groups.py @@ -0,0 +1,40 @@ +# -*- encoding: utf-8 -*- + +from django.contrib.auth.models import Group + +def safe_create_groupe(name): + """ + Création d'un groupe prédéfini. Retourne None, quand la création + ne peut se faire. (C'est le cas au syncdb, quand la table de groupe + n'a pas été crée encore). + """ + try: + grp, created = Group.objects.get_or_create(name=name) + except Exception, e: + print e + return None + return grp + +# Groupes impliqués dans le Worflow +grp_correspondants_rh = safe_create_groupe(name='Correspondants RH') +grp_administrateurs = safe_create_groupe(name='Administrateurs') +grp_directeurs_bureau = safe_create_groupe(name='Directeurs de bureau') +grp_drh = safe_create_groupe(name='DRH') +grp_drh2 = safe_create_groupe(name='DRH-2') +grp_accior = safe_create_groupe(name='ACCIOR') +grp_abf = safe_create_groupe(name='ABF') +grp_haute_direction = safe_create_groupe(name='Haute direction') +grp_service_utilisateurs = safe_create_groupe(name='Service utilisateurs') + +dae_groupes = ( + grp_correspondants_rh, + grp_administrateurs, + grp_directeurs_bureau, + grp_drh, + grp_drh2, + grp_accior, + grp_abf, + grp_haute_direction, + grp_service_utilisateurs, +) + diff --git a/project/rh/managers.py b/project/rh/managers.py new file mode 100644 index 0000000..591ffec --- /dev/null +++ b/project/rh/managers.py @@ -0,0 +1,119 @@ + +# -*- encoding: utf-8 -*- + +from django.db import models +from django.db.models import Q +from utils import get_employe_from_user +from workflow import dae_groupes, \ + grp_administrateurs, \ + grp_directeurs_bureau, \ + grp_drh, \ + grp_drh2, \ + grp_accior, \ + grp_abf, \ + grp_haute_direction, \ + grp_service_utilisateurs, \ + grp_correspondants_rh + + +class SecurityManager(models.Manager): + + prefixe_service = None + prefixe_implantation = None + + def ma_region_ou_service(self, user): + """ + Filtrage des postes en fonction du user connecté (region / service) + On s'intéresse aussi au groupe auquel appartient le user car certains groupes + peuvent tout voir. + """ + employe = get_employe_from_user(user) + + ############################################ + # TRAITEMENT NORMAL + ############################################ + # REGION + q = Q(**{ self.prefixe_implantation : employe.implantation.region }) + + # SERVICE + if self.prefixe_service and grp_service_utilisateurs in user.groups.all(): + q = q | Q(**{ self.prefixe_service : employe.service}) + + liste = self.get_query_set().filter(q) + + ############################################ + # TRAITEMENT ACCIOR + ############################################ + if grp_accior in user.groups.all(): + liste = self.get_query_set().all() + + ############################################ + # TRAITEMENT ABF + ############################################ + if grp_abf in user.groups.all(): + liste = self.get_query_set().all() + + ############################################ + # TRAITEMENT HAUTE DIRECTION + ############################################ + if grp_haute_direction in user.groups.all(): + liste = self.get_query_set().all() + + ############################################ + # TRAITEMENT DRH + ############################################ + if grp_drh in user.groups.all() or grp_drh2 in user.groups.all(): + liste = self.get_query_set().all() + + return liste + + +class PosteManager(SecurityManager): + """ + Chargement de tous les objets FK existants sur chaque QuerySet. + """ + prefixe_service = "service" + prefixe_implantation = "implantation__region" + + def ma_region_ou_service(self, user): + return super(PosteManager, self).ma_region_ou_service(user).filter(actif=True) + + def get_query_set(self): + fkeys = ( + 'id_rh', + 'responsable', + 'implantation', + 'implantation.bureau_rattachement', + '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 DossierManager(SecurityManager): + prefixe_service = "poste__service" + prefixe_implantation = "poste__implantation__region" + + def get_query_set(self): + fkeys = ( + 'poste', + ) + return super(DossierManager, self).get_query_set() \ + .select_related(*fkeys).all() + + def ma_region_ou_service(self, user): + return super(DossierManager, self).ma_region_ou_service(user).filter(poste__actif=True) + + +class PosteComparaisonManager(SecurityManager): + use_for_related_fields = True + prefixe_implantation = "implantation__region" + +class DossierComparaisonManager(SecurityManager): + use_for_related_fields = True + prefixe_implantation = "implantation__region" diff --git a/project/rh/migrations/0003_auto__chg_field_postecomparaison_implantation__chg_field_evenement_dat.py b/project/rh/migrations/0003_auto__chg_field_postecomparaison_implantation__chg_field_evenement_dat.py new file mode 100644 index 0000000..c79505d --- /dev/null +++ b/project/rh/migrations/0003_auto__chg_field_postecomparaison_implantation__chg_field_evenement_dat.py @@ -0,0 +1,1336 @@ +# encoding: utf-8 +import datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + +class Migration(SchemaMigration): + + def forwards(self, orm): + + # Changing field 'PosteComparaison.implantation' + db.alter_column('rh_postecomparaison', 'implantation_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['references.Implantation'])) + + # Changing field 'Evenement.date_creation' + db.alter_column('rh_evenement', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Evenement.date_activation' + db.alter_column('rh_evenement', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Evenement.date_modification' + db.alter_column('rh_evenement', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Evenement.date_desactivation' + db.alter_column('rh_evenement', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Contrat.date_creation' + db.alter_column('rh_contrat', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Contrat.date_activation' + db.alter_column('rh_contrat', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Contrat.date_modification' + db.alter_column('rh_contrat', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Contrat.date_desactivation' + db.alter_column('rh_contrat', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_creation' + db.alter_column('rh_postecommentaire', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_desactivation' + db.alter_column('rh_postecommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_activation' + db.alter_column('rh_postecommentaire', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_modification' + db.alter_column('rh_postecommentaire', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Classement.date_creation' + db.alter_column('rh_classement', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Classement.date_activation' + db.alter_column('rh_classement', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Classement.date_modification' + db.alter_column('rh_classement', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Classement.date_desactivation' + db.alter_column('rh_classement', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'DossierComparaison.implantation' + db.alter_column('rh_dossiercomparaison', 'implantation_id', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, null=True, to=orm['references.Implantation'])) + + # Changing field 'TauxChange.date_creation' + db.alter_column('rh_tauxchange', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TauxChange.date_activation' + db.alter_column('rh_tauxchange', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TauxChange.date_modification' + db.alter_column('rh_tauxchange', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TauxChange.date_desactivation' + db.alter_column('rh_tauxchange', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_creation' + db.alter_column('rh_typeremuneration', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_desactivation' + db.alter_column('rh_typeremuneration', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_activation' + db.alter_column('rh_typeremuneration', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_modification' + db.alter_column('rh_typeremuneration', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_activation' + db.alter_column('rh_typeposte', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_modification' + db.alter_column('rh_typeposte', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_desactivation' + db.alter_column('rh_typeposte', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_creation' + db.alter_column('rh_typeposte', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Poste.implantation' + db.alter_column('rh_poste', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(db_column='implantation', to=orm['references.Implantation'])) + + # Changing field 'Poste.date_modification' + db.alter_column('rh_poste', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Poste.date_activation' + db.alter_column('rh_poste', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Poste.date_creation' + db.alter_column('rh_poste', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Poste.date_desactivation' + db.alter_column('rh_poste', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Employe.pays' + db.alter_column('rh_employe', 'pays', self.gf('django.db.models.fields.related.ForeignKey')(db_column='pays', to_field='code', to=orm['references.Pays'], blank=True, null=True)) + + # Changing field 'Employe.date_modification' + db.alter_column('rh_employe', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Employe.nationalite' + db.alter_column('rh_employe', 'nationalite', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='nationalite', to=orm['references.Pays'])) + + # Changing field 'Employe.date_activation' + db.alter_column('rh_employe', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Employe.date_creation' + db.alter_column('rh_employe', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Employe.date_desactivation' + db.alter_column('rh_employe', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.implantation' + db.alter_column('rh_responsableimplantation', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(unique=True, db_column='implantation', to=orm['references.Implantation'])) + + # Changing field 'ResponsableImplantation.date_creation' + db.alter_column('rh_responsableimplantation', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.date_desactivation' + db.alter_column('rh_responsableimplantation', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.date_activation' + db.alter_column('rh_responsableimplantation', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.date_modification' + db.alter_column('rh_responsableimplantation', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.date_creation' + db.alter_column('rh_valeurpoint', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.date_desactivation' + db.alter_column('rh_valeurpoint', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.implantation' + db.alter_column('rh_valeurpoint', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(db_column='implantation', to=orm['references.Implantation'])) + + # Changing field 'ValeurPoint.date_activation' + db.alter_column('rh_valeurpoint', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.date_modification' + db.alter_column('rh_valeurpoint', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_creation' + db.alter_column('rh_dossiercommentaire', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_desactivation' + db.alter_column('rh_dossiercommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_activation' + db.alter_column('rh_dossiercommentaire', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_modification' + db.alter_column('rh_dossiercommentaire', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Service.date_creation' + db.alter_column('rh_service', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Service.date_desactivation' + db.alter_column('rh_service', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Service.date_activation' + db.alter_column('rh_service', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Service.date_modification' + db.alter_column('rh_service', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroit.nationalite' + db.alter_column('rh_ayantdroit', 'nationalite', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='nationalite', to=orm['references.Pays'])) + + # Changing field 'AyantDroit.date_activation' + db.alter_column('rh_ayantdroit', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroit.date_modification' + db.alter_column('rh_ayantdroit', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroit.date_desactivation' + db.alter_column('rh_ayantdroit', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroit.date_creation' + db.alter_column('rh_ayantdroit', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Dossier.date_modification' + db.alter_column('rh_dossier', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Dossier.date_activation' + db.alter_column('rh_dossier', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Dossier.date_creation' + db.alter_column('rh_dossier', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Dossier.date_desactivation' + db.alter_column('rh_dossier', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_creation' + db.alter_column('rh_typecontrat', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_activation' + db.alter_column('rh_typecontrat', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_modification' + db.alter_column('rh_typecontrat', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_desactivation' + db.alter_column('rh_typecontrat', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_creation' + db.alter_column('rh_ayantdroitcommentaire', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_desactivation' + db.alter_column('rh_ayantdroitcommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_activation' + db.alter_column('rh_ayantdroitcommentaire', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_modification' + db.alter_column('rh_ayantdroitcommentaire', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_creation' + db.alter_column('rh_familleemploi', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_desactivation' + db.alter_column('rh_familleemploi', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_activation' + db.alter_column('rh_familleemploi', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_modification' + db.alter_column('rh_familleemploi', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_creation' + db.alter_column('rh_evenementremuneration', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_desactivation' + db.alter_column('rh_evenementremuneration', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_modification' + db.alter_column('rh_evenementremuneration', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_activation' + db.alter_column('rh_evenementremuneration', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_creation' + db.alter_column('rh_typerevalorisation', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_desactivation' + db.alter_column('rh_typerevalorisation', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_activation' + db.alter_column('rh_typerevalorisation', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_modification' + db.alter_column('rh_typerevalorisation', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.date_creation' + db.alter_column('rh_organismebstg', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.date_desactivation' + db.alter_column('rh_organismebstg', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.date_activation' + db.alter_column('rh_organismebstg', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.pays' + db.alter_column('rh_organismebstg', 'pays', self.gf('django.db.models.fields.related.ForeignKey')(db_column='pays', to_field='code', to=orm['references.Pays'], blank=True, null=True)) + + # Changing field 'OrganismeBstg.date_modification' + db.alter_column('rh_organismebstg', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_creation' + db.alter_column('rh_remuneration', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_desactivation' + db.alter_column('rh_remuneration', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_modification' + db.alter_column('rh_remuneration', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_activation' + db.alter_column('rh_remuneration', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_creation' + db.alter_column('rh_employecommentaire', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_desactivation' + db.alter_column('rh_employecommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_activation' + db.alter_column('rh_employecommentaire', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_modification' + db.alter_column('rh_employecommentaire', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Devise.date_creation' + db.alter_column('rh_devise', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Devise.date_desactivation' + db.alter_column('rh_devise', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Devise.date_activation' + db.alter_column('rh_devise', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Devise.date_modification' + db.alter_column('rh_devise', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Statut.date_creation' + db.alter_column('rh_statut', 'date_creation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Statut.date_desactivation' + db.alter_column('rh_statut', 'date_desactivation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Statut.date_activation' + db.alter_column('rh_statut', 'date_activation', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + # Changing field 'Statut.date_modification' + db.alter_column('rh_statut', 'date_modification', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)) + + + def backwards(self, orm): + + # Changing field 'PosteComparaison.implantation' + db.alter_column('rh_postecomparaison', 'implantation_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['datamaster_modeles.Implantation'], blank=True)) + + # Changing field 'Evenement.date_creation' + db.alter_column('rh_evenement', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Evenement.date_activation' + db.alter_column('rh_evenement', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Evenement.date_modification' + db.alter_column('rh_evenement', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Evenement.date_desactivation' + db.alter_column('rh_evenement', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Contrat.date_creation' + db.alter_column('rh_contrat', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Contrat.date_activation' + db.alter_column('rh_contrat', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Contrat.date_modification' + db.alter_column('rh_contrat', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Contrat.date_desactivation' + db.alter_column('rh_contrat', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_creation' + db.alter_column('rh_postecommentaire', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_desactivation' + db.alter_column('rh_postecommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_activation' + db.alter_column('rh_postecommentaire', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'PosteCommentaire.date_modification' + db.alter_column('rh_postecommentaire', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Classement.date_creation' + db.alter_column('rh_classement', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Classement.date_activation' + db.alter_column('rh_classement', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Classement.date_modification' + db.alter_column('rh_classement', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Classement.date_desactivation' + db.alter_column('rh_classement', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'DossierComparaison.implantation' + db.alter_column('rh_dossiercomparaison', 'implantation_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['datamaster_modeles.Implantation'], blank=True)) + + # Changing field 'TauxChange.date_creation' + db.alter_column('rh_tauxchange', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TauxChange.date_activation' + db.alter_column('rh_tauxchange', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TauxChange.date_modification' + db.alter_column('rh_tauxchange', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TauxChange.date_desactivation' + db.alter_column('rh_tauxchange', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_creation' + db.alter_column('rh_typeremuneration', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_desactivation' + db.alter_column('rh_typeremuneration', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_activation' + db.alter_column('rh_typeremuneration', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRemuneration.date_modification' + db.alter_column('rh_typeremuneration', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_activation' + db.alter_column('rh_typeposte', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_modification' + db.alter_column('rh_typeposte', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_desactivation' + db.alter_column('rh_typeposte', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypePoste.date_creation' + db.alter_column('rh_typeposte', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Poste.implantation' + db.alter_column('rh_poste', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(db_column='implantation', to=orm['datamaster_modeles.Implantation'])) + + # Changing field 'Poste.date_modification' + db.alter_column('rh_poste', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Poste.date_activation' + db.alter_column('rh_poste', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Poste.date_creation' + db.alter_column('rh_poste', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Poste.date_desactivation' + db.alter_column('rh_poste', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Employe.pays' + db.alter_column('rh_employe', 'pays', self.gf('django.db.models.fields.related.ForeignKey')(db_column='pays', to_field='code', to=orm['datamaster_modeles.Pays'], blank=True, null=True)) + + # Changing field 'Employe.date_modification' + db.alter_column('rh_employe', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Employe.nationalite' + db.alter_column('rh_employe', 'nationalite', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='nationalite', to=orm['datamaster_modeles.Pays'])) + + # Changing field 'Employe.date_activation' + db.alter_column('rh_employe', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Employe.date_creation' + db.alter_column('rh_employe', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Employe.date_desactivation' + db.alter_column('rh_employe', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.implantation' + db.alter_column('rh_responsableimplantation', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(unique=True, db_column='implantation', to=orm['datamaster_modeles.Implantation'])) + + # Changing field 'ResponsableImplantation.date_creation' + db.alter_column('rh_responsableimplantation', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.date_desactivation' + db.alter_column('rh_responsableimplantation', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.date_activation' + db.alter_column('rh_responsableimplantation', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ResponsableImplantation.date_modification' + db.alter_column('rh_responsableimplantation', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.date_creation' + db.alter_column('rh_valeurpoint', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.date_desactivation' + db.alter_column('rh_valeurpoint', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.implantation' + db.alter_column('rh_valeurpoint', 'implantation', self.gf('django.db.models.fields.related.ForeignKey')(db_column='implantation', to=orm['datamaster_modeles.Implantation'])) + + # Changing field 'ValeurPoint.date_activation' + db.alter_column('rh_valeurpoint', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'ValeurPoint.date_modification' + db.alter_column('rh_valeurpoint', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_creation' + db.alter_column('rh_dossiercommentaire', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_desactivation' + db.alter_column('rh_dossiercommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_activation' + db.alter_column('rh_dossiercommentaire', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'DossierCommentaire.date_modification' + db.alter_column('rh_dossiercommentaire', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Service.date_creation' + db.alter_column('rh_service', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Service.date_desactivation' + db.alter_column('rh_service', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Service.date_activation' + db.alter_column('rh_service', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Service.date_modification' + db.alter_column('rh_service', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroit.nationalite' + db.alter_column('rh_ayantdroit', 'nationalite', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='nationalite', to=orm['datamaster_modeles.Pays'])) + + # Changing field 'AyantDroit.date_activation' + db.alter_column('rh_ayantdroit', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroit.date_modification' + db.alter_column('rh_ayantdroit', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroit.date_desactivation' + db.alter_column('rh_ayantdroit', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroit.date_creation' + db.alter_column('rh_ayantdroit', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Dossier.date_modification' + db.alter_column('rh_dossier', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Dossier.date_activation' + db.alter_column('rh_dossier', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Dossier.date_creation' + db.alter_column('rh_dossier', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Dossier.date_desactivation' + db.alter_column('rh_dossier', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_creation' + db.alter_column('rh_typecontrat', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_activation' + db.alter_column('rh_typecontrat', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_modification' + db.alter_column('rh_typecontrat', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeContrat.date_desactivation' + db.alter_column('rh_typecontrat', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_creation' + db.alter_column('rh_ayantdroitcommentaire', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_desactivation' + db.alter_column('rh_ayantdroitcommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_activation' + db.alter_column('rh_ayantdroitcommentaire', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'AyantDroitCommentaire.date_modification' + db.alter_column('rh_ayantdroitcommentaire', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_creation' + db.alter_column('rh_familleemploi', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_desactivation' + db.alter_column('rh_familleemploi', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_activation' + db.alter_column('rh_familleemploi', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'FamilleEmploi.date_modification' + db.alter_column('rh_familleemploi', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_creation' + db.alter_column('rh_evenementremuneration', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_desactivation' + db.alter_column('rh_evenementremuneration', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_modification' + db.alter_column('rh_evenementremuneration', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EvenementRemuneration.date_activation' + db.alter_column('rh_evenementremuneration', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_creation' + db.alter_column('rh_typerevalorisation', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_desactivation' + db.alter_column('rh_typerevalorisation', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_activation' + db.alter_column('rh_typerevalorisation', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'TypeRevalorisation.date_modification' + db.alter_column('rh_typerevalorisation', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.date_creation' + db.alter_column('rh_organismebstg', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.date_desactivation' + db.alter_column('rh_organismebstg', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.date_activation' + db.alter_column('rh_organismebstg', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'OrganismeBstg.pays' + db.alter_column('rh_organismebstg', 'pays', self.gf('django.db.models.fields.related.ForeignKey')(db_column='pays', to_field='code', to=orm['datamaster_modeles.Pays'], blank=True, null=True)) + + # Changing field 'OrganismeBstg.date_modification' + db.alter_column('rh_organismebstg', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_creation' + db.alter_column('rh_remuneration', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_desactivation' + db.alter_column('rh_remuneration', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_modification' + db.alter_column('rh_remuneration', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Remuneration.date_activation' + db.alter_column('rh_remuneration', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_creation' + db.alter_column('rh_employecommentaire', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_desactivation' + db.alter_column('rh_employecommentaire', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_activation' + db.alter_column('rh_employecommentaire', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'EmployeCommentaire.date_modification' + db.alter_column('rh_employecommentaire', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Devise.date_creation' + db.alter_column('rh_devise', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Devise.date_desactivation' + db.alter_column('rh_devise', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Devise.date_activation' + db.alter_column('rh_devise', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Devise.date_modification' + db.alter_column('rh_devise', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Statut.date_creation' + db.alter_column('rh_statut', 'date_creation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Statut.date_desactivation' + db.alter_column('rh_statut', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Statut.date_activation' + db.alter_column('rh_statut', 'date_activation', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + # Changing field 'Statut.date_modification' + db.alter_column('rh_statut', 'date_modification', self.gf('django.db.models.fields.DateField')(null=True, blank=True)) + + + models = { + 'auth.group': { + 'Meta': {'object_name': 'Group'}, + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '80', 'unique': 'True'}), + 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}) + }, + 'auth.permission': { + 'Meta': {'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'}, + 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}) + }, + 'auth.user': { + 'Meta': {'object_name': 'User'}, + 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}), + 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}), + 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}), + 'username': ('django.db.models.fields.CharField', [], {'max_length': '30', 'unique': 'True'}) + }, + 'contenttypes.contenttype': { + 'Meta': {'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"}, + 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}), + 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}) + }, + 'references.bureau': { + 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Implantation']", 'db_column': "'implantation'"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Region']", 'db_column': "'region'"}) + }, + 'references.implantation': { + 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), + 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}), + 'adresse_physique_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_physique'", 'to_field': "'code'", 'db_column': "'adresse_physique_pays'", 'to': "orm['references.Pays']"}), + 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), + 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_postale'", 'to_field': "'code'", 'db_column': "'adresse_postale_pays'", 'to': "orm['references.Pays']"}), + 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Implantation']", 'db_column': "'bureau_rattachement'"}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}), + 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}), + 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}), + 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'modif_date': ('django.db.models.fields.DateField', [], {}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Region']", 'db_column': "'region'"}), + 'remarque': ('django.db.models.fields.TextField', [], {}), + 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}), + 'statut': ('django.db.models.fields.IntegerField', [], {}), + 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'}) + }, + 'references.pays': { + 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}), + 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}), + 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True', 'blank': 'True'}), + 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['references.Region']", 'db_column': "'region'"}) + }, + 'references.region': { + 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'", 'managed': 'False'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}), + 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}), + 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'db_column': "'implantation_bureau'", 'to': "orm['references.Implantation']"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}) + }, + 'rh.ayantdroit': { + 'Meta': {'object_name': 'AyantDroit'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ayantdroits'", 'db_column': "'employe'", 'to': "orm['rh.Employe']"}), + 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'lien_parente': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}), + 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ayantdroits_nationalite'", 'to_field': "'code'", 'db_column': "'nationalite'", 'to': "orm['references.Pays']"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_affichage': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.ayantdroitcommentaire': { + 'Meta': {'object_name': 'AyantDroitCommentaire'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'ayant_droit': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'ayant_droit'", 'to': "orm['rh.AyantDroit']"}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'owner': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'owner'", 'to': "orm['auth.User']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'texte': ('django.db.models.fields.TextField', [], {}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.classement': { + 'Meta': {'object_name': 'Classement'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'coefficient': ('django.db.models.fields.FloatField', [], {'default': '0', 'null': 'True'}), + 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'degre': ('django.db.models.fields.IntegerField', [], {}), + 'echelon': ('django.db.models.fields.IntegerField', [], {}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.contrat': { + 'Meta': {'object_name': 'Contrat'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'contrats'", 'db_column': "'dossier'", 'to': "orm['rh.Dossier']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type_contrat': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'type_contrat'", 'to': "orm['rh.TypeContrat']"}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.devise': { + 'Meta': {'object_name': 'Devise'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '10', 'unique': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.dossier': { + 'Meta': {'object_name': 'Dossier'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'classement': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement'", 'to': "orm['rh.Classement']"}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'dossiers'", 'db_column': "'employe'", 'to': "orm['rh.Employe']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'organisme_bstg': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'organisme_bstg'", 'to': "orm['rh.OrganismeBstg']"}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'dossiers'", 'db_column': "'poste'", 'to': "orm['rh.Poste']"}), + 'regime_travail': ('django.db.models.fields.DecimalField', [], {'default': '100.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'regime_travail_nb_heure_semaine': ('django.db.models.fields.DecimalField', [], {'default': '35.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'remplacement': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'remplacement_de': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Dossier']"}), + 'statut': ('django.db.models.fields.related.ForeignKey', [], {'default': '3', 'related_name': "'+'", 'null': 'True', 'to': "orm['rh.Statut']"}), + 'statut_residence': ('django.db.models.fields.CharField', [], {'default': "'local'", 'max_length': '10', 'null': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.dossiercommentaire': { + 'Meta': {'object_name': 'DossierCommentaire'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'dossier'", 'to': "orm['rh.Dossier']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'owner': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'owner'", 'to': "orm['auth.User']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'texte': ('django.db.models.fields.TextField', [], {}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.dossiercomparaison': { + 'Meta': {'object_name': 'DossierComparaison'}, + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Devise']"}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'comparaisons'", 'to': "orm['rh.Dossier']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['references.Implantation']"}), + 'montant': ('django.db.models.fields.IntegerField', [], {'null': 'True'}), + 'personne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'poste': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}) + }, + 'rh.dossierpiece': { + 'Meta': {'object_name': 'DossierPiece'}, + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'dossier'", 'to': "orm['rh.Dossier']"}), + 'fichier': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}) + }, + 'rh.employe': { + 'Meta': {'object_name': 'Employe'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employes_nationalite'", 'to_field': "'code'", 'db_column': "'nationalite'", 'to': "orm['references.Pays']"}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_affichage': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employes'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['references.Pays']", 'blank': 'True', 'null': 'True'}), + 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'situation_famille': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'tel_cellulaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'tel_domicile': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}) + }, + 'rh.employecommentaire': { + 'Meta': {'object_name': 'EmployeCommentaire'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'employe'", 'to': "orm['rh.Employe']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'owner': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'owner'", 'to': "orm['auth.User']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'texte': ('django.db.models.fields.TextField', [], {}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.employepiece': { + 'Meta': {'object_name': 'EmployePiece'}, + 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh.Employe']", 'db_column': "'employe'"}), + 'fichier': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}) + }, + 'rh.evenement': { + 'Meta': {'object_name': 'Evenement'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'dossier'", 'to': "orm['rh.Dossier']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.evenementremuneration': { + 'Meta': {'object_name': 'EvenementRemuneration'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'db_column': "'devise'", 'to': "orm['rh.Devise']"}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'rh_evenementremuneration_remunerations'", 'db_column': "'dossier'", 'to': "orm['rh.Dossier']"}), + 'evenement': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'evenement'", 'to': "orm['rh.Evenement']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'montant': ('django.db.models.fields.FloatField', [], {'default': '0', 'null': 'True', 'blank': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'type'", 'to': "orm['rh.TypeRemuneration']"}), + 'type_revalorisation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'type_revalorisation'", 'to': "orm['rh.TypeRevalorisation']"}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.familleemploi': { + 'Meta': {'object_name': 'FamilleEmploi'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.organismebstg': { + 'Meta': {'object_name': 'OrganismeBstg'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'organismes_bstg'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['references.Pays']", 'blank': 'True', 'null': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.poste': { + 'Meta': {'object_name': 'Poste'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'appel': ('django.db.models.fields.CharField', [], {'default': "'interne'", 'max_length': '10', 'null': 'True'}), + 'autre_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'autre_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'classement_max': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement_max'", 'to': "orm['rh.Classement']"}), + 'classement_min': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'classement_min'", 'to': "orm['rh.Classement']"}), + 'comp_autre_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_autre_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_fonctionpub_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_fonctionpub_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_locale_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_locale_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_ong_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_ong_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_universite_max': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'comp_universite_min': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_validation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise_comparaison': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_comparaison'", 'to': "orm['rh.Devise']"}), + 'devise_max': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_max'", 'to': "orm['rh.Devise']"}), + 'devise_min': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise_min'", 'to': "orm['rh.Devise']"}), + 'expatrie': ('django.db.models.fields.NullBooleanField', [], {'default': 'False', 'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'implantation'", 'to': "orm['references.Implantation']"}), + 'indemn_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'indemn_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'justification': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}), + 'local': ('django.db.models.fields.NullBooleanField', [], {'default': 'True', 'null': 'True', 'blank': 'True'}), + 'mise_a_disposition': ('django.db.models.fields.NullBooleanField', [], {'default': 'False', 'null': 'True', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}), + 'regime_travail': ('django.db.models.fields.DecimalField', [], {'default': '100.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'regime_travail_nb_heure_semaine': ('django.db.models.fields.DecimalField', [], {'default': '35.0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'default': '149', 'related_name': "'+'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['rh.Poste']"}), + 'salaire_max': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'salaire_min': ('django.db.models.fields.DecimalField', [], {'default': '0', 'null': 'True', 'max_digits': '12', 'decimal_places': '2'}), + 'service': ('django.db.models.fields.related.ForeignKey', [], {'default': '1', 'related_name': "'+'", 'null': 'True', 'db_column': "'service'", 'to': "orm['rh.Service']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'null': 'True', 'db_column': "'type_poste'", 'to': "orm['rh.TypePoste']"}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'valeur_point_max': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'valeur_point_max'", 'to': "orm['rh.ValeurPoint']"}), + 'valeur_point_min': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'valeur_point_min'", 'to': "orm['rh.ValeurPoint']"}) + }, + 'rh.postecommentaire': { + 'Meta': {'object_name': 'PosteCommentaire'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'owner': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'owner'", 'to': "orm['auth.User']"}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'poste'", 'to': "orm['rh.Poste']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'texte': ('django.db.models.fields.TextField', [], {}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.postecomparaison': { + 'Meta': {'object_name': 'PosteComparaison'}, + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['rh.Devise']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'to': "orm['references.Implantation']"}), + 'montant': ('django.db.models.fields.IntegerField', [], {'null': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'comparaisons_internes'", 'to': "orm['rh.Poste']"}) + }, + 'rh.postefinancement': { + 'Meta': {'object_name': 'PosteFinancement'}, + 'commentaire': ('django.db.models.fields.TextField', [], {}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'rh_financements'", 'db_column': "'poste'", 'to': "orm['rh.Poste']"}), + 'pourcentage': ('django.db.models.fields.DecimalField', [], {'max_digits': '12', 'decimal_places': '2'}), + 'type': ('django.db.models.fields.CharField', [], {'max_length': '1'}) + }, + 'rh.postepiece': { + 'Meta': {'object_name': 'PostePiece'}, + 'fichier': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'poste': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'pieces'", 'db_column': "'poste'", 'to': "orm['rh.Poste']"}) + }, + 'rh.remuneration': { + 'Meta': {'object_name': 'Remuneration'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_debut': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'db_column': "'devise'", 'to': "orm['rh.Devise']"}), + 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'rh_remuneration_remunerations'", 'db_column': "'dossier'", 'to': "orm['rh.Dossier']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'montant': ('django.db.models.fields.FloatField', [], {'default': '0', 'null': 'True', 'blank': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'type'", 'to': "orm['rh.TypeRemuneration']"}), + 'type_revalorisation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'type_revalorisation'", 'to': "orm['rh.TypeRevalorisation']"}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.responsableimplantation': { + 'Meta': {'object_name': 'ResponsableImplantation'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'employe'", 'to': "orm['rh.Employe']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'unique': 'True', 'db_column': "'implantation'", 'to': "orm['references.Implantation']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.service': { + 'Meta': {'object_name': 'Service'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.statut': { + 'Meta': {'object_name': 'Statut'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'code': ('django.db.models.fields.CharField', [], {'max_length': '25', 'unique': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.tauxchange': { + 'Meta': {'object_name': 'TauxChange'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'annee': ('django.db.models.fields.IntegerField', [], {}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh.Devise']", 'db_column': "'devise'"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'taux': ('django.db.models.fields.FloatField', [], {}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typecontrat': { + 'Meta': {'object_name': 'TypeContrat'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typeposte': { + 'Meta': {'object_name': 'TypePoste'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'famille_emploi': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'famille_emploi'", 'to': "orm['rh.FamilleEmploi']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'is_responsable': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typeremuneration': { + 'Meta': {'object_name': 'TypeRemuneration'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nature_remuneration': ('django.db.models.fields.CharField', [], {'max_length': '30'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'type_paiement': ('django.db.models.fields.CharField', [], {'max_length': '30'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.typerevalorisation': { + 'Meta': {'object_name': 'TypeRevalorisation'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}) + }, + 'rh.valeurpoint': { + 'Meta': {'object_name': 'ValeurPoint'}, + 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}), + 'annee': ('django.db.models.fields.IntegerField', [], {}), + 'date_activation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_creation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_desactivation': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'date_modification': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}), + 'devise': ('django.db.models.fields.related.ForeignKey', [], {'default': '5', 'related_name': "'+'", 'null': 'True', 'db_column': "'devise'", 'to': "orm['rh.Devise']"}), + 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'rh_valeur_point'", 'db_column': "'implantation'", 'to': "orm['references.Implantation']"}), + 'supprime': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}), + 'user_activation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_activation'", 'to': "orm['auth.User']"}), + 'user_creation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_creation'", 'to': "orm['auth.User']"}), + 'user_desactivation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_desactivation'", 'to': "orm['auth.User']"}), + 'user_modification': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'blank': 'True', 'null': 'True', 'db_column': "'user_modification'", 'to': "orm['auth.User']"}), + 'valeur': ('django.db.models.fields.FloatField', [], {'null': 'True'}) + } + } + + complete_apps = ['rh'] diff --git a/project/rh/models.py b/project/rh/models.py index 817a7e6..21b0be8 100644 --- a/project/rh/models.py +++ b/project/rh/models.py @@ -10,7 +10,7 @@ from auf.django.metadata.models import AUFMetadata from auf.django.metadata.managers import NoDeleteManager import auf.django.references.models as ref from validators import validate_date_passee -from dae.managers import SecurityManager +from managers import PosteManager, DossierManager # Constantes REGIME_TRAVAIL_DEFAULT = 100.00 @@ -53,19 +53,6 @@ POSTE_APPEL_CHOICES = ( ('externe', 'Externe'), ) -class PosteManager(SecurityManager): - """ - Chargement de tous les objets FK existants sur chaque QuerySet. - """ - prefixe_implantation = "implantation__region" - - def get_query_set(self): - fkeys = ( - 'implantation', - 'type_poste', - ) - return super(PosteManager, self).get_query_set().select_related(*fkeys).all() - class Poste_(AUFMetadata): """Un Poste est un emploi (job) à combler dans une implantation. Un Poste peut être comblé par un Employe, auquel cas un Dossier est créé. @@ -87,12 +74,10 @@ class Poste_(AUFMetadata): null=True) service = models.ForeignKey('Service', db_column='service', null=True, related_name='+', - verbose_name = u"Direction/Service/Pôle support", - default=1) # default = Rectorat + verbose_name = u"Direction/Service/Pôle support", ) responsable = models.ForeignKey('Poste', db_column='responsable', related_name='+', null=True, - verbose_name = u"Poste du responsable", - default=149) # default = Recteur + verbose_name = u"Poste du responsable", ) # Contrat regime_travail = models.DecimalField(max_digits=12, decimal_places=2, @@ -541,6 +526,9 @@ class Dossier_(AUFMetadata): Une structure de Remuneration est rattachée au Dossier. Un Poste pour lequel aucun Dossier n'existe est un poste vacant. """ + + objects = DossierManager() + # Identification employe = models.ForeignKey('Employe', db_column='employe', related_name='dossiers', @@ -1084,19 +1072,6 @@ class ValeurPoint_(AUFMetadata): verbose_name = u"Valeur du point" verbose_name_plural = u"Valeurs du point" - # TODO : cette fonction n'était pas présente dans la branche dev, utilité? - def get_tauxchange_courant(self): - """ - Recherche le taux courant associé à la valeur d'un point. - Tous les taux de l'année courante sont chargés, pour optimiser un - affichage en liste. (On pourrait probablement améliorer le manager pour - lui greffer le taux courant sous forme de JOIN) - """ - for tauxchange in self.tauxchange: - if tauxchange.implantation_id == self.implantation_id: - return tauxchange - return None - def __unicode__(self): return u'%s %s (%s)' % (self.valeur, self.devise, self.annee) diff --git a/project/urls.py b/project/urls.py index b010fce..39d22ee 100644 --- a/project/urls.py +++ b/project/urls.py @@ -13,7 +13,7 @@ handler500 # Pyflakes urlpatterns = patterns( '', - (r'^$', 'project.views.index'), + url(r'^$', 'project.views.index', name='index'), url(r'^admin_tools/', include('admin_tools.urls')), (r'^admin/', include(admin.site.urls)), url(r'^api/(?P[a-z_-]+)/(?P\d+)/$', 'recrutement.api.api', -- 1.7.10.4