+++ /dev/null
-# coding: utf-8
-
-"""
-Application servant à l'importation des données du système de RH PHP4.
-"""
-
-class DatabaseRouter(object):
-
- """
- Routeur qui associe les modèles de l'app pg_db à la BD pg_db.
- """
-
- def db_for_read(self, model, **hints):
- if model._meta.app_label == 'legacy':
- return 'legacy'
- return None
-
- db_for_write = db_for_read
-
+++ /dev/null
-# coding: utf-8
-
-from datetime import datetime, date, timedelta
-from decimal import Decimal
-
-from django.contrib.auth.models import User
-from django.core.management.base import BaseCommand
-from django.db import connection
-from django.db.models import Q, Max
-
-from auf.django.references import models as ref
-from project.legacy import models as legacy
-from project.rh import models as rh
-
-
-def clean_date(date):
- if date == '2003-06-31': # date inexistante (dossier 791-1)
- return '2003-06-30'
- elif date:
- return date
- else:
- return None
-
-
-class Command(BaseCommand):
- help = 'Importe les données du système RH legacy'
-
- def handle(self, *args, **options):
- self.stdout.write("Import de rh_classement...\n")
- sync_classement()
- self.stdout.write("Import de rh_employe...\n")
- sync_employe()
- self.stdout.write("Import de rh_familleemploi...\n")
- sync_familleemploi()
- self.stdout.write("Import de rh_typeposte...\n")
- sync_typeposte()
- self.stdout.write("Import de rh_service...\n")
- sync_service()
- self.stdout.write("Import de rh_poste...\n")
- sync_poste()
- self.stdout.write("Import de rh_organismebstg...\n")
- sync_organismebstg()
- self.stdout.write("Import de rh_statut...\n")
- sync_statut()
- self.stdout.write("Import de rh_tauxchange...\n")
- sync_tauxchange()
- self.stdout.write("Import de rh_valeurpoint...\n")
- sync_valeurpoint()
- self.stdout.write("Import de rh_typecontrat...\n")
- sync_typecontrat()
- self.stdout.write("Import de rh_typerevalorisation...\n")
- sync_typerevalorisation()
- self.stdout.write("Import de rh_typeremuneration...\n")
- sync_typeremuneration()
- self.stdout.write("Import de rh_dossier...\n")
- sync_dossier()
- self.stdout.write("Import de rh_ayantdroit...\n")
- sync_ayantdroit()
- self.stdout.write("Setup des devises dans rh.Poste...\n")
- sync_devises()
-
-
-def sync_classement():
- connection.cursor().execute('TRUNCATE rh_classement')
- for classement in legacy.Classement.objects.all():
- rh.Classement.objects.create(
- id=classement.id_classement,
- type=classement.type_classement,
- echelon=classement.echelon or 0,
- degre=classement.degre or 0,
- coefficient=classement.coefficient,
- commentaire=classement.commentaire,
- date_modification=classement.date_modif,
- )
-
-
-def sync_employe():
- cursor = connection.cursor()
- cursor.execute('TRUNCATE rh_employe')
- cursor.execute('TRUNCATE rh_employecommentaire')
- odette = User.objects.get(username='odette.tremblay')
- for fiche in legacy.Fiches.objects.extra():
- employe = rh.Employe.objects.create(
- id=fiche.no_employe,
- nom=fiche.nom,
- prenom=fiche.prenom,
- nationalite_id=fiche.nationalite,
- date_naissance=(fiche.date_naissance if fiche.date_naissance
- else None),
- genre=fiche.sexe.upper(),
- situation_famille=(None if fiche.situation_famille == '-1'
- else fiche.situation_famille),
- date_entree=fiche.date_entree,
- tel_domicile=fiche.tel_domicile,
- tel_cellulaire=fiche.tel_cellulaire,
- adresse=fiche.no_rue,
- ville=fiche.ville,
- province=fiche.etat_province,
- code_postal=fiche.code_postal_cedex,
- pays_id=fiche.pays_iso2 if fiche.pays_iso2 != '-1' else None,
- date_creation=fiche.date_ouverture,
- date_modification=fiche.date_maj,
- supprime=False,
- nb_postes=None, # meta
- )
- if fiche.remarque:
- rh.EmployeCommentaire.objects.create(
- employe=employe,
- texte=fiche.remarque,
- owner=odette
- )
-
-
-def sync_familleemploi():
- cursor = connection.cursor()
- cursor.execute('TRUNCATE rh_familleemploi')
- for famille in legacy.FamilleEmploi.objects.all():
- rh.CategorieEmploi.objects.create(
- id=famille.id_famille_emploi,
- nom=famille.famille_emploi,
- )
-
-
-def sync_typeposte():
- cursor = connection.cursor()
- cursor.execute('TRUNCATE rh_typeposte')
- for type in legacy.Postes.objects.all():
- rh.TypePoste.objects.create(
- id=type.id_poste,
- nom=type.titre_poste_m,
- nom_feminin=type.titre_poste_f,
- is_responsable=bool(int(type.poste_responsable)),
- famille_emploi_id=type.id_famille_emploi,
- date_modification=type.datemaj,
- )
-
-
-def sync_service():
- cursor = connection.cursor()
- cursor.execute('TRUNCATE rh_service')
-
- # Création des services à partir de la table de références
- for s in ref.Service.objects.all():
- rh.Service.objects.create(
- id=s.id,
- nom=s.nom,
- archive=not bool(s.actif),
- )
-
-
-def sync_poste():
- cursor = connection.cursor()
- cursor.execute('TRUNCATE rh_poste')
- for poste in legacy.ImplantationPostes.objects \
- .select_related('type_poste'):
-
- # Aller chercher certaines informations dans le dernier dossier
- # associé à ce poste
- dossiers = legacy.Dossiers.objects.filter(
- Q(poste_1=poste.id_implantation_postes) |
- Q(poste_2=poste.id_implantation_postes)
- ).order_by('-id_dossier')
- complement = ''
-
- if dossiers.count() == 0:
- service = None
- poste_du_responsable = None
- date_debut = None
- date_fin = None
-
- if dossiers.count() > 0:
-
- for d in dossiers:
- if d.ids_direction_service not in (None, ''):
- dossier = d
- break
-
- # Déterminer le service
- services = dossier.ids_direction_service
- service = int(services.split('|')[0]) if services else 1
- if poste.id_implantation_postes == dossier.poste_1:
- complement = dossier.complement_1
- else:
- complement = dossier.complement_2
- complement = ' ' + complement if complement else ''
-
- # Déterminer le poste du responsable
- try:
- responsable = dossier.responsable
- dossiers_du_responsable = responsable.dossiers \
- .order_by('-id_dossier')
- if dossiers_du_responsable.count() > 0:
- poste_du_responsable = dossiers_du_responsable[0].poste_1
- except:
- poste_du_responsable = None
-
- date_debut = clean_date(min(d.date_debut_mandat for d in dossiers))
- if '' in (d.date_fin_mandat for d in dossiers):
- date_fin = None
- else:
- date_fin = clean_date(max(d.date_fin_mandat for d in dossiers))
-
- # Créer le poste
- rh_poste = rh.Poste.objects.create(
- id=poste.id_implantation_postes,
- nom=poste.type_poste.titre_poste_m + complement,
- nom_feminin=poste.type_poste.titre_poste_f + complement,
- implantation_id=poste.id_implantation,
- type_poste_id=poste.type_poste_id,
- date_modification=poste.date_maj,
- service_id=service,
- supprime=False,
- responsable_id=poste_du_responsable,
- date_debut=date_debut,
- date_fin=date_fin,
- )
-
- if service is None and poste.actif in ('0', 0, False):
- rh_poste.date_fin = rh_poste.date_modification
- rh_poste.save()
-
-
-def sync_organismebstg():
- connection.cursor().execute('TRUNCATE rh_organismebstg')
- for organisme in legacy.OrganismesBstg.objects.all():
- rh.OrganismeBstg.objects.create(
- id=organisme.id_bstg,
- nom=organisme.organisme_nom,
- type=organisme.bstg_type,
- )
-
-
-def sync_statut():
- connection.cursor().execute('TRUNCATE rh_statut')
- for statut in legacy.Statut.objects.all():
- rh.Statut.objects.create(
- id=statut.id_statut,
- code=statut.statut_contractuel,
- nom=statut.description_statut_contractuel,
- )
-
-
-def sync_tauxchange():
- connection.cursor().execute('TRUNCATE rh_tauxchange')
- connection.cursor().execute('TRUNCATE rh_devise')
-
- # Certaines devises ont besoin d'un id spécifique (#2581)
- rh.Devise.objects.create(id=1, code='AMD', nom='Dram arménien')
- rh.Devise.objects.create(id=2, code='CAD', nom='Dollar canadien')
- rh.Devise.objects.create(id=3, code='CAN', nom='Dollar canadien')
- rh.Devise.objects.create(id=4, code='DZD', nom='Dinar algérien')
- rh.Devise.objects.create(id=5, code='EUR', nom='Euro')
- rh.Devise.objects.create(id=6, code='GNF', nom='Franc Guinéen')
- rh.Devise.objects.create(id=7, code='KMF', nom='Franc comorien')
- rh.Devise.objects.create(id=8, code='LBP', nom='Livre libanaise')
- rh.Devise.objects.create(id=9, code='MAD', nom='Dirham marocain')
- rh.Devise.objects.create(id=10, code='MGF', nom='Franc Malgache')
- rh.Devise.objects.create(id=11, code='MRO', nom='Ouguiya')
- rh.Devise.objects.create(id=12, code='MUR', nom='Roupie mauricienne')
- rh.Devise.objects.create(id=13, code='SYP', nom='Livre syrienne')
- rh.Devise.objects.create(id=14, code='TND', nom='Dinar tunisien')
- rh.Devise.objects.create(id=15, code='US ', nom='Dollar américain')
- rh.Devise.objects.create(id=16, code='USD', nom='Dollar américain')
- rh.Devise.objects.create(id=17, code='VUV', nom='Vatu')
- rh.Devise.objects.create(id=18, code='XAF', nom='Franc CFA')
- rh.Devise.objects.create(id=19, code='XOF', nom='Franc CFA')
-
- for taux in legacy.TauxChangeAnnuel.objects.exclude(taux_annuel=None):
-
- # Créer la devise
- devise, created = rh.Devise.objects.get_or_create(
- code=taux.code_devise
- )
- if created:
- devise.nom = taux.nom_devise
- devise.save()
-
- # Créer le taux de change
- rh.TauxChange.objects.get_or_create(
- devise=devise,
- annee=taux.annee,
- taux=taux.taux_annuel,
- )
-
-
-def sync_valeurpoint():
- connection.cursor().execute('TRUNCATE rh_valeurpoint')
- for vp in legacy.ValeurPoint.objects.all():
-
- # Trouver la devise associée à cette implantation
- annee = vp.date_actif[:4]
- try:
- taux = legacy.TauxChangeAnnuel.objects.get(
- annee=annee, id_implantation=vp.id_implantation
- )
- except:
- continue
- devise = rh.Devise.objects.get(code=taux.code_devise)
-
- rh.ValeurPoint.objects.create(
- id=vp.id_valeur_point,
- valeur=vp.valeur_point,
- implantation_id=vp.id_implantation,
- annee=vp.date_actif[:4],
- devise=devise
- )
-
-
-def sync_typecontrat():
- connection.cursor().execute('TRUNCATE rh_typecontrat')
- for type in legacy.TypeContrat.objects.all():
- rh.TypeContrat.objects.create(
- id=type.id_type_contrat,
- nom=type.nom_contrat,
- nom_long=type.description_contrat,
- )
-
-
-def sync_typerevalorisation():
- connection.cursor().execute('TRUNCATE rh_typerevalorisation')
- for type in legacy.TypeRevalorisation.objects.all():
- rh.TypeRevalorisation.objects.create(
- id=type.id_type_revalorisation,
- nom=type.type_revalorisation,
- )
-
-
-def sync_typeremuneration():
- connection.cursor().execute('TRUNCATE rh_typeremuneration')
- for type in legacy.TypeRemuneration.objects.all():
- rh.TypeRemuneration.objects.create(
- id=type.id_type_remuneration,
- nom=type.type_remuneration,
- type_paiement=type.type_paiement,
- nature_remuneration=type.nature_remuneration,
- )
-
-
-def sync_dossier():
- taux_cache = {}
-
- def get_taux(annee, devise):
- taux = taux_cache.get((annee, devise))
- if taux is not None:
- return taux
- taux = rh.TauxChange.objects.filter(annee__gte=annee) \
- .order_by('annee')[0].taux
- taux_cache[(annee, devise)] = taux
- return taux
-
- cursor = connection.cursor()
- cursor.execute('TRUNCATE rh_contrat')
- cursor.execute('TRUNCATE rh_dossier')
- cursor.execute('TRUNCATE rh_remuneration')
- cursor.execute('TRUNCATE rh_dossiercommentaire')
- cursor.execute('TRUNCATE rh_responsableimplantation')
- odette = User.objects.get(username='odette.tremblay')
- type_contrat_inconnu = rh.TypeContrat.objects.create(
- nom='Inconnu',
- nom_long='Inconnu',
- )
- dossiers = legacy.Dossiers.objects \
- .annotate(timestamp_modif=Max('historique__stamp')) \
- .order_by('no_dossier')
- for dossier in dossiers:
- date_modification = datetime.fromtimestamp(dossier.timestamp_modif) \
- if dossier.timestamp_modif else None
- dossier1 = rh.Dossier.objects.create(
- employe_id=dossier.employe_id,
- poste_id=dossier.poste_1,
- statut_id=dossier.id_statut,
- organisme_bstg_id=dossier.id_bstg,
- statut_residence=('expat' if dossier.id_local_expatrie == 1
- else 'local'),
- classement_id=dossier.id_classement,
- regime_travail=dossier.regime_travail,
- date_debut=clean_date(dossier.date_debut_mandat),
- date_fin=clean_date(dossier.date_fin_mandat),
- date_modification=date_modification,
- remplacement=False,
- supprime=False
- )
-
- # Commentaires
- if dossier.remarque:
- rh.DossierCommentaire.objects.create(
- dossier=dossier1,
- texte=dossier.remarque,
- owner=odette
- )
-
- # Responsables d'implantation
- today = date.today().isoformat()
- if not dossier.date_fin_mandat or dossier.date_fin_mandat >= today:
- if dossier.responsable_implantation_1:
- responsable, created = rh.ResponsableImplantation.objects \
- .get_or_create(
- implantation_id=dossier.id_implantation_1
- )
- responsable.employe_id = dossier.employe_id
- responsable.save()
- if dossier.responsable_implantation_2:
- responsable, created = rh.ResponsableImplantation.objects \
- .get_or_create(
- implantation_id=dossier.id_implantation_2
- )
- responsable.employe_id = dossier.employe_id
- responsable.save()
-
- # Contrats
- rh.Contrat.objects.create(
- dossier=dossier1,
- type_contrat_id=dossier.id_type_contrat or type_contrat_inconnu.id,
- date_debut=clean_date(dossier.date_debut_contrat),
- date_fin=clean_date(dossier.date_fin_contrat),
- supprime=False
- )
-
- # Rémunération
- remuns_precedentes = {}
- charges_precedentes = None
- pourcentage_charges = 0
- devise_charges = rh.Devise.objects.get(code='EUR')
- for remun in legacy.HistoRemuneration.objects \
- .filter(no_dossier=dossier.no_dossier) \
- .order_by('id_histo_remuneration'):
-
- # Calcul de la période
- date_debut = remun.date_effective
- if date_debut == '200-08-09':
- date_debut = '2000-08-09'
- elif date_debut == '2003-06-31':
- date_debut = '2003-06-30'
- date_debut = date(
- int(date_debut[:4]), int(date_debut[5:7]), int(date_debut[8:])
- )
- if remun.type_remuneration.type_paiement == 'Ponctuel':
- date_fin = date_debut
- else:
- date_fin = None
- remun_precedente = remuns_precedentes.get(
- remun.type_remuneration_id
- )
- if remun_precedente:
- if str(remun_precedente.date_debut) == str(date_debut):
- remun_precedente.delete()
- else:
- remun_precedente.date_fin = \
- date_debut - timedelta(days=1)
- remun_precedente.save()
-
- # Création de la ligne de rémunération
- if remun.type_remuneration.nature_remuneration != 'Charges' \
- and remun.montant != 0:
- devise, created = rh.Devise.objects.get_or_create(
- code=remun.code_devise
- )
-
- rh_remun = rh.Remuneration.objects.create(
- dossier=dossier1,
- type_id=remun.type_remuneration_id,
- type_revalorisation_id=remun.id_type_revalorisation,
- montant=remun.montant,
- devise=devise,
- supprime=False,
- date_debut=date_debut,
- date_fin=date_fin
- )
-
- # Se souvenir de ce type de rémunération
- if remun.type_remuneration.type_paiement == u'Régulier':
- remuns_precedentes[remun.type_remuneration_id] = rh_remun
-
- # Charges patronales
- if remun.type_remuneration.nature_remuneration == 'Charges':
- pourcentage_charges = remun.pourcentage
-
- if remun.type_remuneration.nature_remuneration == 'Traitement':
- devise_charges = rh.Devise.objects.get(code=remun.code_devise)
-
- if remun.type_remuneration.type_paiement == u'Régulier':
- charges = 0
- annee_charges = date_debut.year
- taux2 = get_taux(annee_charges, devise_charges)
- if pourcentage_charges:
- for remun_precedente in remuns_precedentes.values():
- montant = remun_precedente.montant
- devise = remun_precedente.devise
- if devise != devise_charges:
- taux1 = get_taux(annee_charges, devise)
- montant = (montant * Decimal(str(taux1)) /
- Decimal(str(taux2)))
- if remun_precedente.type.nature_remuneration == \
- 'Traitement':
- montant = (
- montant *
- remun_precedente.dossier.regime_travail / 100
- )
- montant = montant * pourcentage_charges / 100
- montant.quantize(remun_precedente.montant)
- charges += montant
- charges = charges * pourcentage_charges / 100
- if charges_precedentes:
- if charges_precedentes.date_debut == date_debut:
- charges_precedentes.delete()
- else:
- charges_precedentes.date_fin = date_debut - \
- timedelta(days=1)
- charges_precedentes.save()
- if charges > 0 and \
- (not charges_precedentes or
- charges_precedentes.montant != charges or
- charges_precedentes.date_debut == date_debut):
- charges_precedentes = rh.Remuneration.objects.create(
- dossier=dossier1,
- type_id=17,
- type_revalorisation_id=None,
- montant=Decimal(str(charges)),
- devise=devise_charges,
- supprime=False,
- date_debut=date_debut,
- commentaire=(u'Charges patronales: %s%%' %
- pourcentage_charges)
- )
-
- # Dossier différent pour le deuxième poste
- if dossier.poste_2:
- dossier2 = rh.Dossier.objects.create(
- employe_id=dossier.employe_id,
- poste_id=dossier.poste_2,
- statut_id=dossier.id_statut,
- organisme_bstg_id=dossier.id_bstg,
- statut_residence=('expat' if dossier.id_local_expatrie == 1
- else 'local'),
- classement_id=dossier.id_classement,
- regime_travail=dossier.regime_travail,
- date_debut=clean_date(dossier.date_debut_mandat),
- date_fin=clean_date(dossier.date_fin_mandat),
- remplacement=False,
- supprime=False
- )
- if dossier.remarque:
- rh.DossierCommentaire.objects.create(
- dossier=dossier2,
- texte=dossier.remarque,
- owner=odette
- )
- rh.Contrat.objects.create(
- dossier=dossier2,
- type_contrat_id=(dossier.id_type_contrat or
- type_contrat_inconnu.id),
- date_debut=clean_date(dossier.date_debut_contrat),
- date_fin=clean_date(dossier.date_fin_contrat),
- supprime=False
- )
-
-
-def sync_ayantdroit():
- connection.cursor().execute('TRUNCATE rh_ayantdroit')
- odette = User.objects.get(username='odette.tremblay')
- for ad in legacy.AyantDroit.objects.all():
- rh_ad = rh.AyantDroit.objects.create(
- id=ad.id_ayant_droit,
- nom=ad.nom_ayant_droit,
- prenom=ad.prenom_ayant_droit,
- employe_id=ad.no_employe,
- lien_parente=(None if ad.lien_parente == 'Autre'
- else ad.lien_parente),
- )
- if ad.commentaire_ayant_droit:
- rh.AyantDroitCommentaire.objects.create(
- ayant_droit=rh_ad,
- texte=ad.commentaire_ayant_droit,
- owner=odette
- )
-
-
-def sync_devises():
- for p in rh.Poste.objects.all():
- if p.implantation is not None:
- qs = rh.ValeurPoint.objects \
- .filter(implantation=p.implantation) \
- .order_by('-id')
- if qs.exists():
- point = qs[0]
- p.devise_min = point.devise
- p.devise_max = point.devise
- p.devise_comparaison = point.devise
- p.save()
+++ /dev/null
-from django.db import models
-
-class Classement(models.Model):
- id_classement = models.IntegerField(primary_key=True)
- type_classement = models.CharField(max_length=4)
- echelon = models.CharField(max_length=127)
- degre = models.CharField(max_length=32)
- commentaire = models.CharField(max_length=127)
- coefficient = models.FloatField()
- date_modif = models.CharField(max_length=10)
- actif = models.IntegerField()
- class Meta:
- db_table = u'classement'
- managed = False
-
-class Fiches(models.Model):
- no_employe = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=128)
- prenom = models.CharField(max_length=128)
- date_ouverture = models.CharField(max_length=10)
- situation_famille = models.CharField(max_length=2)
- nationalite = models.CharField(max_length=2)
- tel_domicile = models.CharField(max_length=20)
- tel_cellulaire = models.CharField(max_length=20)
- no_rue = models.CharField(max_length=128)
- ville = models.CharField(max_length=128)
- etat_province = models.CharField(max_length=128)
- code_postal_cedex = models.CharField(max_length=64)
- pays_iso2 = models.CharField(max_length=2)
- sexe = models.CharField(max_length=1)
- date_entree = models.CharField(max_length=10)
- remarque = models.TextField()
- date_maj = models.CharField(max_length=10)
- date_naissance = models.CharField(max_length=10)
- class Meta:
- db_table = u'fiches'
- managed = False
-
-class Dossiers(models.Model):
- id_dossier = models.IntegerField(primary_key=True)
- no_dossier = models.CharField(max_length=10, unique=True)
- employe = models.ForeignKey(Fiches, related_name='dossiers', db_column='no_employe')
- id_implantation_1 = models.SmallIntegerField()
- poste_1 = models.SmallIntegerField()
- complement_1 = models.CharField(max_length=128)
- id_implantation_2 = models.SmallIntegerField()
- poste_2 = models.SmallIntegerField()
- complement_2 = models.CharField(max_length=128)
- ids_direction_service = models.CharField(max_length=128)
- remplacement_de = models.IntegerField()
- responsable = models.ForeignKey(Fiches, related_name='+', db_column='responsable')
- id_local_expatrie = models.IntegerField()
- date_debut_mandat = models.CharField(max_length=10)
- date_fin_mandat = models.CharField(max_length=10)
- id_statut = models.IntegerField()
- id_bstg = models.IntegerField()
- id_classement = models.IntegerField()
- id_type_contrat = models.IntegerField()
- regime_travail = models.SmallIntegerField()
- date_debut_contrat = models.CharField(max_length=10)
- date_fin_contrat = models.CharField(max_length=10)
- remarque = models.TextField()
- responsable_implantation_1 = models.IntegerField()
- responsable_implantation_2 = models.IntegerField()
- class Meta:
- db_table = u'dossiers'
- managed = False
-
-class TypeRemuneration(models.Model):
- id_type_remuneration = models.IntegerField(primary_key=True)
- type_remuneration = models.CharField(max_length=127)
- type_paiement = models.CharField(max_length=127)
- nature_remuneration = models.CharField(max_length=127)
- actif = models.IntegerField()
- class Meta:
- db_table = u'type_remuneration'
- managed = False
-
-class HistoRemuneration(models.Model):
- id_histo_remuneration = models.IntegerField(primary_key=True)
- type_remuneration = models.ForeignKey(TypeRemuneration, db_column='id_type_remuneration',
- related_name='+')
- no_dossier = models.CharField(max_length=10)
- montant = models.DecimalField(max_digits=20, decimal_places=4)
- pourcentage = models.DecimalField(max_digits=20, decimal_places=4)
- date_effective = models.CharField(max_length=10)
- id_type_revalorisation = models.IntegerField()
- code_devise = models.CharField(max_length=3)
- usager = models.IntegerField()
- stamp = models.IntegerField()
- desactive = models.BooleanField()
- desactive_par = models.IntegerField()
- annule = models.BooleanField()
- annule_par = models.IntegerField()
- stamp_annule = models.IntegerField()
- stamp_desactive = models.IntegerField()
- class Meta:
- db_table = u'histo_remuneration'
- managed = False
-
-class HistoFiches(models.Model):
- id_histo = models.IntegerField(primary_key=True)
- fiche = models.ForeignKey(Fiches, db_column='no_employe', related_name='historique')
- nom = models.CharField(max_length=128)
- prenom = models.CharField(max_length=128)
- date_ouverture = models.CharField(max_length=10)
- situation_famille = models.CharField(max_length=2)
- nationalite = models.CharField(max_length=2)
- tel_domicile = models.CharField(max_length=20)
- tel_cellulaire = models.CharField(max_length=20)
- no_rue = models.CharField(max_length=128)
- ville = models.CharField(max_length=128)
- etat_province = models.CharField(max_length=128)
- code_postal_cedex = models.CharField(max_length=64)
- pays_iso2 = models.CharField(max_length=2)
- sexe = models.CharField(max_length=1)
- date_entree = models.CharField(max_length=10)
- remarque = models.TextField()
- date_maj = models.CharField(max_length=10)
- date_naissance = models.CharField(max_length=10)
- stamp = models.IntegerField()
- ip = models.CharField(max_length=15)
- usager = models.IntegerField()
- action = models.CharField(max_length=1)
- requete = models.TextField()
- class Meta:
- db_table = u'histo_fiches'
- managed = False
-
-class HistoDossiers(models.Model):
- id_histo = models.IntegerField(primary_key=True)
- dossier = models.ForeignKey(Dossiers, db_column='no_dossier',
- related_name='historique',
- to_field='no_dossier')
- no_employe = models.IntegerField()
- id_implantation_1 = models.SmallIntegerField()
- poste_1 = models.SmallIntegerField()
- complement_1 = models.CharField(max_length=128)
- id_implantation_2 = models.SmallIntegerField()
- poste_2 = models.SmallIntegerField()
- complement_2 = models.CharField(max_length=128)
- ids_direction_service = models.CharField(max_length=128)
- remplacement_de = models.IntegerField()
- responsable = models.IntegerField()
- id_local_expatrie = models.IntegerField()
- date_debut_mandat = models.CharField(max_length=10)
- date_fin_mandat = models.CharField(max_length=10)
- id_statut = models.IntegerField()
- id_bstg = models.IntegerField()
- id_classement = models.IntegerField()
- id_type_contrat = models.IntegerField()
- regime_travail = models.SmallIntegerField()
- date_debut_contrat = models.CharField(max_length=10)
- date_fin_contrat = models.CharField(max_length=10)
- remarque = models.TextField()
- stamp = models.IntegerField()
- ip = models.CharField(max_length=15)
- usager = models.IntegerField()
- action = models.CharField(max_length=1)
- requete = models.TextField()
- responsable_implantation_1 = models.IntegerField()
- responsable_implantation_2 = models.IntegerField()
- class Meta:
- db_table = u'histo_dossiers'
- managed = False
-
-class FamilleEmploi(models.Model):
- id_famille_emploi = models.SmallIntegerField(primary_key=True)
- famille_emploi = models.CharField(max_length=64)
- actif = models.IntegerField()
- class Meta:
- db_table = u'famille_emploi'
- managed = False
-
-class DirectionService(models.Model):
- id_direction_service = models.SmallIntegerField(primary_key=True)
- direction_service = models.CharField(max_length=256)
- actif = models.IntegerField()
- class Meta:
- db_table = u'direction_service'
- managed = False
-
-class Postes(models.Model):
- id_poste = models.SmallIntegerField(primary_key=True)
- id_famille_emploi = models.SmallIntegerField()
- titre_poste_m = models.CharField(max_length=128)
- titre_poste_f = models.CharField(max_length=128)
- datemaj = models.CharField(max_length=10)
- actif = models.CharField(max_length=1)
- poste_responsable = models.CharField(max_length=1)
- description = models.CharField(max_length=128)
- class Meta:
- db_table = u'postes'
- managed = False
-
-class ImplantationPostes(models.Model):
- id_implantation_postes = models.IntegerField(primary_key=True)
- id_implantation = models.SmallIntegerField()
- proportion = models.FloatField()
- date_maj = models.CharField(max_length=10)
- actif = models.TextField() # This field type is a guess.
- type_poste = models.ForeignKey(Postes, db_column='id_poste')
- class Meta:
- db_table = u'implantation_postes'
- managed = False
-
-class OrganismesBstg(models.Model):
- id_bstg = models.IntegerField(primary_key=True)
- organisme_nom = models.CharField(max_length=128)
- actif = models.IntegerField()
- bstg_type = models.CharField(max_length=3)
- class Meta:
- db_table = u'organismes_bstg'
- managed = False
-
-class TauxChangeAnnuel(models.Model):
- id_taux_change_annuel = models.IntegerField(primary_key=True)
- code_devise = models.CharField(max_length=3)
- nom_devise = models.CharField(max_length=32)
- id_implantation = models.SmallIntegerField()
- taux_annuel = models.DecimalField(max_digits=100, decimal_places=50)
- annee = models.CharField(max_length=4)
- class Meta:
- db_table = u'taux_change_annuel'
- managed = False
-
-class ValeurPoint(models.Model):
- id_valeur_point = models.IntegerField(primary_key=True)
- id_implantation = models.SmallIntegerField()
- valeur_point = models.DecimalField(max_digits=100, decimal_places=50)
- date_actif = models.CharField(max_length=10)
- class Meta:
- db_table = u'valeur_point'
- managed = False
-
-class TypeContrat(models.Model):
- id_type_contrat = models.IntegerField(primary_key=True)
- nom_contrat = models.CharField(max_length=127)
- categorie = models.CharField(max_length=1)
- description_contrat = models.CharField(max_length=127)
- actif_contrat = models.IntegerField()
- class Meta:
- db_table = u'type_contrat'
- managed = False
-
-class TypeRevalorisation(models.Model):
- id_type_revalorisation = models.IntegerField(primary_key=True)
- type_revalorisation = models.CharField(max_length=127)
- actif = models.IntegerField()
- class Meta:
- db_table = u'type_revalorisation'
- managed = False
-
-class Statut(models.Model):
- id_statut = models.IntegerField(primary_key=True)
- statut_contractuel = models.CharField(max_length=127)
- type_contrat = models.CharField(max_length=1)
- description_statut_contractuel = models.CharField(max_length=127)
- actif = models.IntegerField()
- class Meta:
- db_table = u'statut'
- managed = False
-
-class TypeRemuneration(models.Model):
- id_type_remuneration = models.IntegerField(primary_key=True)
- type_remuneration = models.CharField(max_length=127)
- type_paiement = models.CharField(max_length=127)
- nature_remuneration = models.CharField(max_length=127)
- actif = models.IntegerField()
- class Meta:
- db_table = u'type_remuneration'
- managed = False
-
-class AyantDroit(models.Model):
- id_ayant_droit = models.IntegerField(primary_key=True)
- no_employe = models.IntegerField()
- nom_ayant_droit = models.CharField(max_length=128)
- prenom_ayant_droit = models.CharField(max_length=128)
- commentaire_ayant_droit = models.CharField(max_length=512)
- lien_parente = models.CharField(max_length=10)
- actif = models.IntegerField()
- class Meta:
- db_table = u'ayant_droit'
- managed = False
-
+++ /dev/null
-# 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):
-
- # Adding model 'Employe'
- db.create_table('rh_v1_employe', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('prenom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nationalite', self.gf('django.db.models.fields.related.ForeignKey')(related_name='nationalite', db_column='nationalite', to=orm['datamaster_modeles.Pays'])),
- ('date_naissance', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('genre', self.gf('django.db.models.fields.CharField')(max_length=1, null=True, blank=True)),
- ('situation_famille', self.gf('django.db.models.fields.CharField')(max_length=1, null=True, blank=True)),
- ('date_entree', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
- ('tel_domicile', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('tel_cellulaire', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('adresse', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('no_rue', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('ville', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('province', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('code_postal', self.gf('django.db.models.fields.CharField')(max_length=255, null=True, blank=True)),
- ('pays', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='pays', null=True, db_column='pays', to=orm['datamaster_modeles.Pays'])),
- ('date_creation', self.gf('django.db.models.fields.DateField')(auto_now_add=True, blank=True)),
- ('date_maj', self.gf('django.db.models.fields.DateField')(auto_now=True, blank=True)),
- ('commentaire', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ))
- db.send_create_signal('rh_v1', ['Employe'])
-
- # Adding model 'Dossier'
- db.create_table('rh_v1_dossier', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(unique=True, max_length=10)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Employe'], db_column='employe')),
- ('poste1', self.gf('django.db.models.fields.related.ForeignKey')(related_name='poste1', db_column='poste1', to=orm['rh_v1.Poste'])),
- ('implantation1', self.gf('django.db.models.fields.related.ForeignKey')(related_name='implantation1', db_column='implantation1', to=orm['datamaster_modeles.Implantation'])),
- ('complement1', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('responsable_implantation1', self.gf('django.db.models.fields.IntegerField')()),
- ('poste2', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='poste2', null=True, db_column='poste2', to=orm['rh_v1.Poste'])),
- ('implantation2', self.gf('django.db.models.fields.related.ForeignKey')(related_name='implantation2', db_column='implantation2', to=orm['datamaster_modeles.Implantation'])),
- ('complement2', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('responsable_implantation2', self.gf('django.db.models.fields.IntegerField')()),
- ('service', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Service'], db_column='service')),
- ('responsable', self.gf('django.db.models.fields.related.ForeignKey')(related_name='responsable', db_column='responsable', to=orm['rh_v1.Employe'])),
- ('remplacement_de', self.gf('django.db.models.fields.related.ForeignKey')(related_name='remplacement_de', db_column='remplacement_de', to=orm['rh_v1.Employe'])),
- ('type', self.gf('django.db.models.fields.CharField')(max_length=1)),
- ('statut', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Statut'], db_column='statut')),
- ('organisme_bstg', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.OrganismeBstg'], db_column='organisme_bstg')),
- ('classement', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Classement'], db_column='classement')),
- ('regime_travail', self.gf('django.db.models.fields.IntegerField')()),
- ('mandat_date_debut', self.gf('django.db.models.fields.DateField')()),
- ('mandat_date_fin', self.gf('django.db.models.fields.DateField')()),
- ('contrat_date_debut', self.gf('django.db.models.fields.DateField')()),
- ('contrat_date_fin', self.gf('django.db.models.fields.DateField')()),
- ('type_contrat', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeContrat'], db_column='type_contrat')),
- ('date_creation', self.gf('django.db.models.fields.DateField')(auto_now_add=True, blank=True)),
- ('date_maj', self.gf('django.db.models.fields.DateField')(auto_now=True, blank=True)),
- ('commentaire', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ))
- db.send_create_signal('rh_v1', ['Dossier'])
-
- # Adding model 'AyantDroit'
- db.create_table('rh_v1_ayantdroit', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('prenom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('employe', self.gf('django.db.models.fields.related.ForeignKey')(related_name='employe', db_column='employe', to=orm['rh_v1.Employe'])),
- ('lien_parente', self.gf('django.db.models.fields.CharField')(max_length=10, null=True, blank=True)),
- ('commentaire', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['AyantDroit'])
-
- # Adding model 'Remuneration'
- db.create_table('rh_v1_remuneration', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('dossier', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Dossier'], db_column='dossier')),
- ('type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeRemuneration'], db_column='type')),
- ('type_revalorisation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeRevalorisation'], db_column='type_revalorisation')),
- ('montant', self.gf('django.db.models.fields.FloatField')()),
- ('devise', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'], to_field='code', db_column='devise')),
- ('date_effective', self.gf('django.db.models.fields.DateField')()),
- ('pourcentage', self.gf('django.db.models.fields.IntegerField')()),
- ('date_creation', self.gf('django.db.models.fields.DateField')(auto_now_add=True, blank=True)),
- ('user_creation', self.gf('django.db.models.fields.IntegerField')()),
- ('desactivation', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ('date_desactivation', self.gf('django.db.models.fields.DateField')()),
- ('user_desactivation', self.gf('django.db.models.fields.IntegerField')()),
- ('annulation', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ('date_annulation', self.gf('django.db.models.fields.DateField')()),
- ('user_annulation', self.gf('django.db.models.fields.IntegerField')()),
- ))
- db.send_create_signal('rh_v1', ['Remuneration'])
-
- # Adding model 'FamilleEmploi'
- db.create_table('rh_v1_familleemploi', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['FamilleEmploi'])
-
- # Adding model 'TypePoste'
- db.create_table('rh_v1_typeposte', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_feminin', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('description', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('is_responsable', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ('famille_emploi', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.FamilleEmploi'], db_column='famille_emploi')),
- ('date_modification', self.gf('django.db.models.fields.DateField')(auto_now=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['TypePoste'])
-
- # Adding model 'TypeRemuneration'
- db.create_table('rh_v1_typeremuneration', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('type_paiement', self.gf('django.db.models.fields.CharField')(max_length=30)),
- ('nature_remuneration', self.gf('django.db.models.fields.CharField')(max_length=30)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['TypeRemuneration'])
-
- # Adding model 'TypeRevalorisation'
- db.create_table('rh_v1_typerevalorisation', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['TypeRevalorisation'])
-
- # Adding model 'Poste'
- db.create_table('rh_v1_poste', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['datamaster_modeles.Implantation'], db_column='implantation')),
- ('type_poste', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypePoste'], db_column='type_poste')),
- ('proportion', self.gf('django.db.models.fields.CharField')(max_length=10)),
- ('date_modification', self.gf('django.db.models.fields.DateField')(auto_now=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['Poste'])
-
- # Adding model 'Service'
- db.create_table('rh_v1_service', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['Service'])
-
- # Adding model 'OrganismeBstg'
- db.create_table('rh_v1_organismebstg', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('type', self.gf('django.db.models.fields.CharField')(max_length=10)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['OrganismeBstg'])
-
- # Adding model 'Statut'
- db.create_table('rh_v1_statut', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(unique=True, max_length=25)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('type_contrat_categorie', self.gf('django.db.models.fields.CharField')(max_length=10)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['Statut'])
-
- # Adding model 'Classement'
- db.create_table('rh_v1_classement', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('type', self.gf('django.db.models.fields.CharField')(max_length=10)),
- ('echelon', self.gf('django.db.models.fields.IntegerField')()),
- ('degre', self.gf('django.db.models.fields.IntegerField')()),
- ('coefficient', self.gf('django.db.models.fields.FloatField')()),
- ('commentaire', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
- ('date_modification', self.gf('django.db.models.fields.DateField')(auto_now=True, blank=True)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['Classement'])
-
- # Adding model 'ValeurPoint'
- db.create_table('rh_v1_valeurpoint', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('valeur', self.gf('django.db.models.fields.FloatField')()),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['datamaster_modeles.Implantation'], db_column='implantation')),
- ('annee', self.gf('django.db.models.fields.IntegerField')()),
- ))
- db.send_create_signal('rh_v1', ['ValeurPoint'])
-
- # Adding model 'TauxChange'
- db.create_table('rh_v1_tauxchange', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('devise', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'], to_field='code', db_column='devise')),
- ('annee', self.gf('django.db.models.fields.IntegerField')()),
- ('taux', self.gf('django.db.models.fields.FloatField')()),
- ('implantation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['datamaster_modeles.Implantation'], db_column='implantation')),
- ))
- db.send_create_signal('rh_v1', ['TauxChange'])
-
- # Adding model 'Devise'
- db.create_table('rh_v1_devise', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('code', self.gf('django.db.models.fields.CharField')(unique=True, max_length=10)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ))
- db.send_create_signal('rh_v1', ['Devise'])
-
- # Adding model 'TypeContrat'
- db.create_table('rh_v1_typecontrat', (
- ('id', self.gf('django.db.models.fields.IntegerField')(primary_key=True)),
- ('nom', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('nom_long', self.gf('django.db.models.fields.CharField')(max_length=255)),
- ('categorie', self.gf('django.db.models.fields.CharField')(max_length=10)),
- ('actif', self.gf('django.db.models.fields.BooleanField')(default=False)),
- ))
- db.send_create_signal('rh_v1', ['TypeContrat'])
-
-
- def backwards(self, orm):
-
- # Deleting model 'Employe'
- db.delete_table('rh_v1_employe')
-
- # Deleting model 'Dossier'
- db.delete_table('rh_v1_dossier')
-
- # Deleting model 'AyantDroit'
- db.delete_table('rh_v1_ayantdroit')
-
- # Deleting model 'Remuneration'
- db.delete_table('rh_v1_remuneration')
-
- # Deleting model 'FamilleEmploi'
- db.delete_table('rh_v1_familleemploi')
-
- # Deleting model 'TypePoste'
- db.delete_table('rh_v1_typeposte')
-
- # Deleting model 'TypeRemuneration'
- db.delete_table('rh_v1_typeremuneration')
-
- # Deleting model 'TypeRevalorisation'
- db.delete_table('rh_v1_typerevalorisation')
-
- # Deleting model 'Poste'
- db.delete_table('rh_v1_poste')
-
- # Deleting model 'Service'
- db.delete_table('rh_v1_service')
-
- # Deleting model 'OrganismeBstg'
- db.delete_table('rh_v1_organismebstg')
-
- # Deleting model 'Statut'
- db.delete_table('rh_v1_statut')
-
- # Deleting model 'Classement'
- db.delete_table('rh_v1_classement')
-
- # Deleting model 'ValeurPoint'
- db.delete_table('rh_v1_valeurpoint')
-
- # Deleting model 'TauxChange'
- db.delete_table('rh_v1_tauxchange')
-
- # Deleting model 'Devise'
- db.delete_table('rh_v1_devise')
-
- # Deleting model 'TypeContrat'
- db.delete_table('rh_v1_typecontrat')
-
-
- models = {
- 'datamaster_modeles.bureau': {
- 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.implantation': {
- 'Meta': {'ordering': "('nom',)", 'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- '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'", 'db_column': "'adresse_physique_pays'", 'to': "orm['datamaster_modeles.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', 'blank': 'True'}),
- 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', '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', 'blank': 'True'}),
- 'adresse_postale_pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'impl_adresse_postale'", 'db_column': "'adresse_postale_pays'", 'to': "orm['datamaster_modeles.Pays']"}),
- 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
- 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.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'})
- },
- 'datamaster_modeles.pays': {
- 'Meta': {'ordering': "('nom',)", 'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'primary_key': 'True'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3', 'blank': 'True'}),
- 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {}),
- '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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.region': {
- 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.ayantdroit': {
- 'Meta': {'object_name': 'AyantDroit'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employe'", 'db_column': "'employe'", 'to': "orm['rh_v1.Employe']"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'lien_parente': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.classement': {
- 'Meta': {'object_name': 'Classement'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'coefficient': ('django.db.models.fields.FloatField', [], {}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'degre': ('django.db.models.fields.IntegerField', [], {}),
- 'echelon': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.devise': {
- 'Meta': {'object_name': 'Devise'},
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.dossier': {
- 'Meta': {'object_name': 'Dossier'},
- 'classement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Classement']", 'db_column': "'classement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement1': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement2': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'contrat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'contrat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'implantation1'", 'db_column': "'implantation1'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'implantation2': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'implantation2'", 'db_column': "'implantation2'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'mandat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'mandat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'organisme_bstg': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.OrganismeBstg']", 'db_column': "'organisme_bstg'"}),
- 'poste1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'poste1'", 'db_column': "'poste1'", 'to': "orm['rh_v1.Poste']"}),
- 'poste2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste2'", 'null': 'True', 'db_column': "'poste2'", 'to': "orm['rh_v1.Poste']"}),
- 'regime_travail': ('django.db.models.fields.IntegerField', [], {}),
- 'remplacement_de': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'remplacement_de'", 'db_column': "'remplacement_de'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'responsable'", 'db_column': "'responsable'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable_implantation1': ('django.db.models.fields.IntegerField', [], {}),
- 'responsable_implantation2': ('django.db.models.fields.IntegerField', [], {}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Service']", 'db_column': "'service'"}),
- 'statut': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Statut']", 'db_column': "'statut'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
- 'type_contrat': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeContrat']", 'db_column': "'type_contrat'"})
- },
- 'rh_v1.employe': {
- 'Meta': {'object_name': 'Employe'},
- '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'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nationalite'", 'db_column': "'nationalite'", 'to': "orm['datamaster_modeles.Pays']"}),
- 'no_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'pays'", 'null': 'True', 'db_column': "'pays'", 'to': "orm['datamaster_modeles.Pays']"}),
- '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'}),
- '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'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.familleemploi': {
- 'Meta': {'object_name': 'FamilleEmploi'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.organismebstg': {
- 'Meta': {'object_name': 'OrganismeBstg'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.poste': {
- 'Meta': {'object_name': 'Poste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'proportion': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypePoste']", 'db_column': "'type_poste'"})
- },
- 'rh_v1.remuneration': {
- 'Meta': {'object_name': 'Remuneration'},
- 'annulation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_annulation': ('django.db.models.fields.DateField', [], {}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_desactivation': ('django.db.models.fields.DateField', [], {}),
- 'date_effective': ('django.db.models.fields.DateField', [], {}),
- 'desactivation': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'to_field': "'code'", 'db_column': "'devise'"}),
- 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Dossier']", 'db_column': "'dossier'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'montant': ('django.db.models.fields.FloatField', [], {}),
- 'pourcentage': ('django.db.models.fields.IntegerField', [], {}),
- 'type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRemuneration']", 'db_column': "'type'"}),
- 'type_revalorisation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRevalorisation']", 'db_column': "'type_revalorisation'"}),
- 'user_annulation': ('django.db.models.fields.IntegerField', [], {}),
- 'user_creation': ('django.db.models.fields.IntegerField', [], {}),
- 'user_desactivation': ('django.db.models.fields.IntegerField', [], {})
- },
- 'rh_v1.service': {
- 'Meta': {'object_name': 'Service'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.statut': {
- 'Meta': {'object_name': 'Statut'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '25'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_contrat_categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.tauxchange': {
- 'Meta': {'object_name': 'TauxChange'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'to_field': "'code'", 'db_column': "'devise'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'taux': ('django.db.models.fields.FloatField', [], {})
- },
- 'rh_v1.typecontrat': {
- 'Meta': {'object_name': 'TypeContrat'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeposte': {
- 'Meta': {'object_name': 'TypePoste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'description': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'famille_emploi': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.FamilleEmploi']", 'db_column': "'famille_emploi'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'is_responsable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeremuneration': {
- 'Meta': {'object_name': 'TypeRemuneration'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nature_remuneration': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_paiement': ('django.db.models.fields.CharField', [], {'max_length': '30'})
- },
- 'rh_v1.typerevalorisation': {
- 'Meta': {'object_name': 'TypeRevalorisation'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.valeurpoint': {
- 'Meta': {'object_name': 'ValeurPoint'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'valeur': ('django.db.models.fields.FloatField', [], {})
- }
- }
-
- complete_apps = ['rh_v1']
+++ /dev/null
-# 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 'Employe.nationalite'
- db.alter_column('rh_v1_employe', 'nationalite', self.gf('django.db.models.fields.related.ForeignKey')(to_field='code', db_column='nationalite', to=orm['datamaster_modeles.Pays']))
-
- # Changing field 'Employe.pays'
- db.alter_column('rh_v1_employe', 'pays', self.gf('django.db.models.fields.related.ForeignKey')(db_column='pays', to_field='code', to=orm['datamaster_modeles.Pays'], null=True))
-
- # Changing field 'Remuneration.user_annulation'
- db.alter_column('rh_v1_remuneration', 'user_annulation', self.gf('django.db.models.fields.IntegerField')(null=True))
-
- # Changing field 'Remuneration.date_desactivation'
- db.alter_column('rh_v1_remuneration', 'date_desactivation', self.gf('django.db.models.fields.DateField')(null=True))
-
- # Changing field 'Remuneration.pourcentage'
- db.alter_column('rh_v1_remuneration', 'pourcentage', self.gf('django.db.models.fields.IntegerField')(null=True))
-
- # Changing field 'Remuneration.montant'
- db.alter_column('rh_v1_remuneration', 'montant', self.gf('django.db.models.fields.FloatField')(null=True))
-
- # Changing field 'Remuneration.user_creation'
- db.alter_column('rh_v1_remuneration', 'user_creation', self.gf('django.db.models.fields.IntegerField')(null=True))
-
- # Changing field 'Remuneration.user_desactivation'
- db.alter_column('rh_v1_remuneration', 'user_desactivation', self.gf('django.db.models.fields.IntegerField')(null=True))
-
- # Changing field 'Remuneration.annulation'
- db.alter_column('rh_v1_remuneration', 'annulation', self.gf('django.db.models.fields.NullBooleanField')(null=True))
-
- # Changing field 'Remuneration.devise'
- db.alter_column('rh_v1_remuneration', 'devise', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'], to_field='code', null=True, db_column='devise'))
-
- # Changing field 'Remuneration.date_effective'
- db.alter_column('rh_v1_remuneration', 'date_effective', self.gf('django.db.models.fields.DateField')(null=True))
-
- # Changing field 'Remuneration.type_revalorisation'
- db.alter_column('rh_v1_remuneration', 'type_revalorisation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeRevalorisation'], null=True, db_column='type_revalorisation'))
-
- # Changing field 'Remuneration.date_annulation'
- db.alter_column('rh_v1_remuneration', 'date_annulation', self.gf('django.db.models.fields.DateField')(null=True))
-
- # Changing field 'Remuneration.desactivation'
- db.alter_column('rh_v1_remuneration', 'desactivation', self.gf('django.db.models.fields.NullBooleanField')(null=True))
-
-
- def backwards(self, orm):
-
- # Changing field 'Employe.nationalite'
- db.alter_column('rh_v1_employe', 'nationalite', self.gf('django.db.models.fields.related.ForeignKey')(db_column='nationalite', to=orm['datamaster_modeles.Pays']))
-
- # Changing field 'Employe.pays'
- db.alter_column('rh_v1_employe', 'pays', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['datamaster_modeles.Pays'], db_column='pays'))
-
- # Changing field 'Remuneration.user_annulation'
- db.alter_column('rh_v1_remuneration', 'user_annulation', self.gf('django.db.models.fields.IntegerField')(default=False))
-
- # Changing field 'Remuneration.date_desactivation'
- db.alter_column('rh_v1_remuneration', 'date_desactivation', self.gf('django.db.models.fields.DateField')(default=datetime.date(2011, 4, 5)))
-
- # Changing field 'Remuneration.pourcentage'
- db.alter_column('rh_v1_remuneration', 'pourcentage', self.gf('django.db.models.fields.IntegerField')(default=0))
-
- # Changing field 'Remuneration.montant'
- db.alter_column('rh_v1_remuneration', 'montant', self.gf('django.db.models.fields.FloatField')(default=0))
-
- # Changing field 'Remuneration.user_creation'
- db.alter_column('rh_v1_remuneration', 'user_creation', self.gf('django.db.models.fields.IntegerField')(default=datetime.date(2011, 4, 5)))
-
- # Changing field 'Remuneration.user_desactivation'
- db.alter_column('rh_v1_remuneration', 'user_desactivation', self.gf('django.db.models.fields.IntegerField')(default=0))
-
- # Changing field 'Remuneration.annulation'
- db.alter_column('rh_v1_remuneration', 'annulation', self.gf('django.db.models.fields.BooleanField')())
-
- # Changing field 'Remuneration.devise'
- db.alter_column('rh_v1_remuneration', 'devise', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.Devise'], to_field='code', db_column='devise'))
-
- # Changing field 'Remuneration.date_effective'
- db.alter_column('rh_v1_remuneration', 'date_effective', self.gf('django.db.models.fields.DateField')(default=datetime.date(2011, 4, 5)))
-
- # Changing field 'Remuneration.type_revalorisation'
- db.alter_column('rh_v1_remuneration', 'type_revalorisation', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.TypeRevalorisation'], db_column='type_revalorisation'))
-
- # Changing field 'Remuneration.date_annulation'
- db.alter_column('rh_v1_remuneration', 'date_annulation', self.gf('django.db.models.fields.DateField')(default=datetime.date(2011, 4, 5)))
-
- # Changing field 'Remuneration.desactivation'
- db.alter_column('rh_v1_remuneration', 'desactivation', self.gf('django.db.models.fields.BooleanField')())
-
-
- models = {
- 'datamaster_modeles.bureau': {
- 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.implantation': {
- 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- '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['datamaster_modeles.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['datamaster_modeles.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['datamaster_modeles.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.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'})
- },
- 'datamaster_modeles.pays': {
- 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3', '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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.region': {
- 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.ayantdroit': {
- 'Meta': {'object_name': 'AyantDroit'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employe'", 'db_column': "'employe'", 'to': "orm['rh_v1.Employe']"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'lien_parente': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.classement': {
- 'Meta': {'object_name': 'Classement'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'coefficient': ('django.db.models.fields.FloatField', [], {}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'degre': ('django.db.models.fields.IntegerField', [], {}),
- 'echelon': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.devise': {
- 'Meta': {'object_name': 'Devise'},
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.dossier': {
- 'Meta': {'object_name': 'Dossier'},
- 'classement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Classement']", 'db_column': "'classement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement1': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement2': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'contrat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'contrat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'implantation1'", 'db_column': "'implantation1'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'implantation2': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'implantation2'", 'db_column': "'implantation2'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'mandat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'mandat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'organisme_bstg': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.OrganismeBstg']", 'db_column': "'organisme_bstg'"}),
- 'poste1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'poste1'", 'db_column': "'poste1'", 'to': "orm['rh_v1.Poste']"}),
- 'poste2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste2'", 'null': 'True', 'db_column': "'poste2'", 'to': "orm['rh_v1.Poste']"}),
- 'regime_travail': ('django.db.models.fields.IntegerField', [], {}),
- 'remplacement_de': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'remplacement_de'", 'db_column': "'remplacement_de'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'responsable'", 'db_column': "'responsable'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable_implantation1': ('django.db.models.fields.IntegerField', [], {}),
- 'responsable_implantation2': ('django.db.models.fields.IntegerField', [], {}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Service']", 'db_column': "'service'"}),
- 'statut': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Statut']", 'db_column': "'statut'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
- 'type_contrat': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeContrat']", 'db_column': "'type_contrat'"})
- },
- 'rh_v1.employe': {
- 'Meta': {'object_name': 'Employe'},
- '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'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nationalite'", 'to_field': "'code'", 'db_column': "'nationalite'", 'to': "orm['datamaster_modeles.Pays']"}),
- 'no_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'pays'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['datamaster_modeles.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'}),
- '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'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.familleemploi': {
- 'Meta': {'object_name': 'FamilleEmploi'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.organismebstg': {
- 'Meta': {'object_name': 'OrganismeBstg'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.poste': {
- 'Meta': {'object_name': 'Poste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'implantation'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'proportion': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypePoste']", 'db_column': "'type_poste'"})
- },
- 'rh_v1.remuneration': {
- 'Meta': {'object_name': 'Remuneration'},
- 'annulation': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'date_annulation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_desactivation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_effective': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'desactivation': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'to_field': "'code'", 'null': 'True', 'db_column': "'devise'", 'blank': 'True'}),
- 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Dossier']", 'db_column': "'dossier'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'montant': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
- 'pourcentage': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRemuneration']", 'db_column': "'type'"}),
- 'type_revalorisation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRevalorisation']", 'null': 'True', 'db_column': "'type_revalorisation'", 'blank': 'True'}),
- 'user_annulation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'user_creation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'user_desactivation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.service': {
- 'Meta': {'object_name': 'Service'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.statut': {
- 'Meta': {'object_name': 'Statut'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '25'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_contrat_categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.tauxchange': {
- 'Meta': {'object_name': 'TauxChange'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'to_field': "'code'", 'db_column': "'devise'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'taux': ('django.db.models.fields.FloatField', [], {})
- },
- 'rh_v1.typecontrat': {
- 'Meta': {'object_name': 'TypeContrat'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeposte': {
- 'Meta': {'object_name': 'TypePoste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'description': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'famille_emploi': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.FamilleEmploi']", 'db_column': "'famille_emploi'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'is_responsable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeremuneration': {
- 'Meta': {'object_name': 'TypeRemuneration'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nature_remuneration': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_paiement': ('django.db.models.fields.CharField', [], {'max_length': '30'})
- },
- 'rh_v1.typerevalorisation': {
- 'Meta': {'object_name': 'TypeRevalorisation'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.valeurpoint': {
- 'Meta': {'object_name': 'ValeurPoint'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'valeur': ('django.db.models.fields.FloatField', [], {})
- }
- }
-
- complete_apps = ['rh_v1']
+++ /dev/null
-# 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 'TauxChange.devise'
- db.alter_column('rh_v1_tauxchange', 'devise', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'], db_column='devise'))
-
-
- def backwards(self, orm):
-
- # Changing field 'TauxChange.devise'
- db.alter_column('rh_v1_tauxchange', 'devise', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Devise'], to_field='code', db_column='devise'))
-
-
- models = {
- 'datamaster_modeles.bureau': {
- 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.implantation': {
- 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- '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['datamaster_modeles.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['datamaster_modeles.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['datamaster_modeles.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.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'})
- },
- 'datamaster_modeles.pays': {
- 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3', '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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.region': {
- 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.ayantdroit': {
- 'Meta': {'object_name': 'AyantDroit'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employe'", 'db_column': "'employe'", 'to': "orm['rh_v1.Employe']"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'lien_parente': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.classement': {
- 'Meta': {'object_name': 'Classement'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'coefficient': ('django.db.models.fields.FloatField', [], {}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'degre': ('django.db.models.fields.IntegerField', [], {}),
- 'echelon': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.devise': {
- 'Meta': {'object_name': 'Devise'},
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.dossier': {
- 'Meta': {'object_name': 'Dossier'},
- 'classement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Classement']", 'db_column': "'classement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement1': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement2': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'contrat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'contrat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'implantation1'", 'db_column': "'implantation1'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'implantation2': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'implantation2'", 'db_column': "'implantation2'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'mandat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'mandat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'organisme_bstg': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.OrganismeBstg']", 'db_column': "'organisme_bstg'"}),
- 'poste1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'poste1'", 'db_column': "'poste1'", 'to': "orm['rh_v1.Poste']"}),
- 'poste2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste2'", 'null': 'True', 'db_column': "'poste2'", 'to': "orm['rh_v1.Poste']"}),
- 'regime_travail': ('django.db.models.fields.IntegerField', [], {}),
- 'remplacement_de': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'remplacement_de'", 'db_column': "'remplacement_de'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'responsable'", 'db_column': "'responsable'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable_implantation1': ('django.db.models.fields.IntegerField', [], {}),
- 'responsable_implantation2': ('django.db.models.fields.IntegerField', [], {}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Service']", 'db_column': "'service'"}),
- 'statut': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Statut']", 'db_column': "'statut'"}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
- 'type_contrat': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeContrat']", 'db_column': "'type_contrat'"})
- },
- 'rh_v1.employe': {
- 'Meta': {'object_name': 'Employe'},
- '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'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nationalite'", 'to_field': "'code'", 'db_column': "'nationalite'", 'to': "orm['datamaster_modeles.Pays']"}),
- 'no_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'pays'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['datamaster_modeles.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'}),
- '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'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.familleemploi': {
- 'Meta': {'object_name': 'FamilleEmploi'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.organismebstg': {
- 'Meta': {'object_name': 'OrganismeBstg'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.poste': {
- 'Meta': {'object_name': 'Poste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'implantation'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'proportion': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypePoste']", 'db_column': "'type_poste'"})
- },
- 'rh_v1.remuneration': {
- 'Meta': {'object_name': 'Remuneration'},
- 'annulation': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'date_annulation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_desactivation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_effective': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'desactivation': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'to_field': "'code'", 'null': 'True', 'db_column': "'devise'", 'blank': 'True'}),
- 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Dossier']", 'db_column': "'dossier'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'montant': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
- 'pourcentage': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRemuneration']", 'db_column': "'type'"}),
- 'type_revalorisation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRevalorisation']", 'null': 'True', 'db_column': "'type_revalorisation'", 'blank': 'True'}),
- 'user_annulation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'user_creation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'user_desactivation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.service': {
- 'Meta': {'object_name': 'Service'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.statut': {
- 'Meta': {'object_name': 'Statut'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '25'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_contrat_categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.tauxchange': {
- 'Meta': {'object_name': 'TauxChange'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'db_column': "'devise'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'taux': ('django.db.models.fields.FloatField', [], {})
- },
- 'rh_v1.typecontrat': {
- 'Meta': {'object_name': 'TypeContrat'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeposte': {
- 'Meta': {'object_name': 'TypePoste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'description': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'famille_emploi': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.FamilleEmploi']", 'db_column': "'famille_emploi'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'is_responsable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeremuneration': {
- 'Meta': {'object_name': 'TypeRemuneration'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nature_remuneration': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_paiement': ('django.db.models.fields.CharField', [], {'max_length': '30'})
- },
- 'rh_v1.typerevalorisation': {
- 'Meta': {'object_name': 'TypeRevalorisation'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.valeurpoint': {
- 'Meta': {'object_name': 'ValeurPoint'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'valeur': ('django.db.models.fields.FloatField', [], {})
- }
- }
-
- complete_apps = ['rh_v1']
+++ /dev/null
-# 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 'Dossier.classement'
- db.alter_column('rh_v1_dossier', 'classement', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Classement'], null=True, db_column='classement'))
-
- # Changing field 'Dossier.responsable'
- db.alter_column('rh_v1_dossier', 'responsable', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='responsable', to=orm['rh_v1.Employe']))
-
- # Changing field 'Dossier.type_contrat'
- db.alter_column('rh_v1_dossier', 'type_contrat', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.TypeContrat'], null=True, db_column='type_contrat'))
-
- # Changing field 'Dossier.organisme_bstg'
- db.alter_column('rh_v1_dossier', 'organisme_bstg', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.OrganismeBstg'], null=True, db_column='organisme_bstg'))
-
- # Changing field 'Dossier.service'
- db.alter_column('rh_v1_dossier', 'service', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Service'], null=True, db_column='service'))
-
- # Changing field 'Dossier.implantation1'
- db.alter_column('rh_v1_dossier', 'implantation1', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='implantation1', to=orm['datamaster_modeles.Implantation']))
-
- # Changing field 'Dossier.implantation2'
- db.alter_column('rh_v1_dossier', 'implantation2', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='implantation2', to=orm['datamaster_modeles.Implantation']))
-
- # Changing field 'Dossier.statut'
- db.alter_column('rh_v1_dossier', 'statut', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['rh_v1.Statut'], null=True, db_column='statut'))
-
- # Changing field 'Dossier.remplacement_de'
- db.alter_column('rh_v1_dossier', 'remplacement_de', self.gf('django.db.models.fields.related.ForeignKey')(null=True, db_column='remplacement_de', to=orm['rh_v1.Employe']))
-
- # Changing field 'Dossier.mandat_date_fin'
- db.alter_column('rh_v1_dossier', 'mandat_date_fin', self.gf('django.db.models.fields.DateField')(null=True))
-
-
- def backwards(self, orm):
-
- # Changing field 'Dossier.classement'
- db.alter_column('rh_v1_dossier', 'classement', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.Classement'], db_column='classement'))
-
- # Changing field 'Dossier.responsable'
- db.alter_column('rh_v1_dossier', 'responsable', self.gf('django.db.models.fields.related.ForeignKey')(default=0, db_column='responsable', to=orm['rh_v1.Employe']))
-
- # Changing field 'Dossier.type_contrat'
- db.alter_column('rh_v1_dossier', 'type_contrat', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.TypeContrat'], db_column='type_contrat'))
-
- # Changing field 'Dossier.organisme_bstg'
- db.alter_column('rh_v1_dossier', 'organisme_bstg', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.OrganismeBstg'], db_column='organisme_bstg'))
-
- # Changing field 'Dossier.service'
- db.alter_column('rh_v1_dossier', 'service', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.Service'], db_column='service'))
-
- # Changing field 'Dossier.implantation1'
- db.alter_column('rh_v1_dossier', 'implantation1', self.gf('django.db.models.fields.related.ForeignKey')(default=0, db_column='implantation1', to=orm['datamaster_modeles.Implantation']))
-
- # Changing field 'Dossier.implantation2'
- db.alter_column('rh_v1_dossier', 'implantation2', self.gf('django.db.models.fields.related.ForeignKey')(default=0, db_column='implantation2', to=orm['datamaster_modeles.Implantation']))
-
- # Changing field 'Dossier.statut'
- db.alter_column('rh_v1_dossier', 'statut', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['rh_v1.Statut'], db_column='statut'))
-
- # Changing field 'Dossier.remplacement_de'
- db.alter_column('rh_v1_dossier', 'remplacement_de', self.gf('django.db.models.fields.related.ForeignKey')(default=0, db_column='remplacement_de', to=orm['rh_v1.Employe']))
-
- # Changing field 'Dossier.mandat_date_fin'
- db.alter_column('rh_v1_dossier', 'mandat_date_fin', self.gf('django.db.models.fields.DateField')(default=0))
-
-
- models = {
- 'datamaster_modeles.bureau': {
- 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.implantation': {
- 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- '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['datamaster_modeles.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['datamaster_modeles.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['datamaster_modeles.Implantation']", 'db_column': "'bureau_rattachement'"}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.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'})
- },
- 'datamaster_modeles.pays': {
- 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '2'}),
- 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
- 'code_iso3': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '3', '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['datamaster_modeles.Region']", 'db_column': "'region'"})
- },
- 'datamaster_modeles.region': {
- 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'"},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
- '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['datamaster_modeles.Implantation']"}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.ayantdroit': {
- 'Meta': {'object_name': 'AyantDroit'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'employe'", 'db_column': "'employe'", 'to': "orm['rh_v1.Employe']"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'lien_parente': ('django.db.models.fields.CharField', [], {'max_length': '10', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.classement': {
- 'Meta': {'object_name': 'Classement'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'coefficient': ('django.db.models.fields.FloatField', [], {}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'degre': ('django.db.models.fields.IntegerField', [], {}),
- 'echelon': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.devise': {
- 'Meta': {'object_name': 'Devise'},
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.dossier': {
- 'Meta': {'object_name': 'Dossier'},
- 'classement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Classement']", 'null': 'True', 'db_column': "'classement'", 'blank': 'True'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '10'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement1': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'complement2': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'contrat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'contrat_date_fin': ('django.db.models.fields.DateField', [], {}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'employe': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Employe']", 'db_column': "'employe'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation1': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'implantation1'", 'null': 'True', 'db_column': "'implantation1'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'implantation2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'implantation2'", 'null': 'True', 'db_column': "'implantation2'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'mandat_date_debut': ('django.db.models.fields.DateField', [], {}),
- 'mandat_date_fin': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'organisme_bstg': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.OrganismeBstg']", 'null': 'True', 'db_column': "'organisme_bstg'", 'blank': 'True'}),
- 'poste1': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'poste1'", 'db_column': "'poste1'", 'to': "orm['rh_v1.Poste']"}),
- 'poste2': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'poste2'", 'null': 'True', 'db_column': "'poste2'", 'to': "orm['rh_v1.Poste']"}),
- 'regime_travail': ('django.db.models.fields.IntegerField', [], {}),
- 'remplacement_de': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'remplacement_de'", 'null': 'True', 'db_column': "'remplacement_de'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'responsable'", 'null': 'True', 'db_column': "'responsable'", 'to': "orm['rh_v1.Employe']"}),
- 'responsable_implantation1': ('django.db.models.fields.IntegerField', [], {}),
- 'responsable_implantation2': ('django.db.models.fields.IntegerField', [], {}),
- 'service': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Service']", 'null': 'True', 'db_column': "'service'", 'blank': 'True'}),
- 'statut': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Statut']", 'null': 'True', 'db_column': "'statut'", 'blank': 'True'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
- 'type_contrat': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeContrat']", 'null': 'True', 'db_column': "'type_contrat'", 'blank': 'True'})
- },
- 'rh_v1.employe': {
- 'Meta': {'object_name': 'Employe'},
- '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'}),
- 'commentaire': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_entree': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_maj': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'date_naissance': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1', 'null': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nationalite'", 'to_field': "'code'", 'db_column': "'nationalite'", 'to': "orm['datamaster_modeles.Pays']"}),
- 'no_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'pays'", 'db_column': "'pays'", 'to_field': "'code'", 'to': "orm['datamaster_modeles.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'}),
- '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'}),
- 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.familleemploi': {
- 'Meta': {'object_name': 'FamilleEmploi'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.organismebstg': {
- 'Meta': {'object_name': 'OrganismeBstg'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.poste': {
- 'Meta': {'object_name': 'Poste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'implantation'", 'to': "orm['datamaster_modeles.Implantation']"}),
- 'proportion': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'type_poste': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypePoste']", 'db_column': "'type_poste'"})
- },
- 'rh_v1.remuneration': {
- 'Meta': {'object_name': 'Remuneration'},
- 'annulation': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'date_annulation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
- 'date_desactivation': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'date_effective': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
- 'desactivation': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'to_field': "'code'", 'null': 'True', 'db_column': "'devise'", 'blank': 'True'}),
- 'dossier': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Dossier']", 'db_column': "'dossier'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'montant': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
- 'pourcentage': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRemuneration']", 'db_column': "'type'"}),
- 'type_revalorisation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.TypeRevalorisation']", 'null': 'True', 'db_column': "'type_revalorisation'", 'blank': 'True'}),
- 'user_annulation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'user_creation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
- 'user_desactivation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
- },
- 'rh_v1.service': {
- 'Meta': {'object_name': 'Service'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.statut': {
- 'Meta': {'object_name': 'Statut'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '25'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_contrat_categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'})
- },
- 'rh_v1.tauxchange': {
- 'Meta': {'object_name': 'TauxChange'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'devise': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.Devise']", 'db_column': "'devise'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'taux': ('django.db.models.fields.FloatField', [], {})
- },
- 'rh_v1.typecontrat': {
- 'Meta': {'object_name': 'TypeContrat'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'categorie': ('django.db.models.fields.CharField', [], {'max_length': '10'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeposte': {
- 'Meta': {'object_name': 'TypePoste'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'date_modification': ('django.db.models.fields.DateField', [], {'auto_now': 'True', 'blank': 'True'}),
- 'description': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'famille_emploi': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['rh_v1.FamilleEmploi']", 'db_column': "'famille_emploi'"}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'is_responsable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'nom_feminin': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.typeremuneration': {
- 'Meta': {'object_name': 'TypeRemuneration'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nature_remuneration': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
- 'type_paiement': ('django.db.models.fields.CharField', [], {'max_length': '30'})
- },
- 'rh_v1.typerevalorisation': {
- 'Meta': {'object_name': 'TypeRevalorisation'},
- 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
- },
- 'rh_v1.valeurpoint': {
- 'Meta': {'object_name': 'ValeurPoint'},
- 'annee': ('django.db.models.fields.IntegerField', [], {}),
- 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
- 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
- 'valeur': ('django.db.models.fields.FloatField', [], {})
- }
- }
-
- complete_apps = ['rh_v1']
+++ /dev/null
-# -=- encoding: utf-8 -=-
-
-import datetime
-
-from django.db import models
-
-from datamaster_modeles.models import Pays, Implantation
-
-from project.dae.managers import SecurityManager
-
-GENRE_CHOICES = (
- ('m', 'Homme'),
- ('f', 'Femme'),
-)
-SITUATION_CHOICES = (
- ('C', 'Célibataire'),
- ('F', 'Fiancé'),
- ('M', 'Marié'),
-)
-
-class Employe(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- prenom = models.CharField(max_length=255)
- nationalite = models.ForeignKey('datamaster_modeles.Pays', to_field='code',
- related_name='nationalite',
- db_column='nationalite')
- date_naissance = models.DateField(null=True, blank=True)
- # Infos personnelles
- genre = models.CharField(max_length=1, null=True, blank=True,
- choices=GENRE_CHOICES)
- situation_famille = models.CharField(max_length=1, null=True, blank=True,
- choices=SITUATION_CHOICES)
- date_entree = models.DateField(null=True, blank=True) #devrait pas être là
- # Coordonnées
- tel_domicile = models.CharField(max_length=255, null=True, blank=True)
- tel_cellulaire = models.CharField(max_length=255, null=True, blank=True)
- adresse = models.CharField(max_length=255, null=True, blank=True)
- no_rue = models.CharField(max_length=255, null=True, blank=True)
- ville = models.CharField(max_length=255, null=True, blank=True)
- province = models.CharField(max_length=255, null=True, blank=True)
- code_postal = models.CharField(max_length=255, null=True, blank=True)
- pays = models.ForeignKey('datamaster_modeles.Pays', to_field='code',
- null=True, blank=True,
- related_name='pays', db_column='pays')
- # Métas
- date_creation = models.DateField(auto_now_add=True)
- date_maj = models.DateField(auto_now=True)
- commentaire = models.TextField(null=True, blank=True)
-
- def __unicode__(self):
- return u'%s %s' % (self.prenom, self.nom)
-
-
-TYPE_DOSSIER_CHOICES = (
- ('2', 'Local'),
- ('1', 'Expatrié'),
-)
-
-class DossierManager(models.Manager):
- """
- Chargement de tous les objets FK existants sur chaque QuerySet.
- """
- prefixe_service = "poste1__service"
- prefixe_implantation = "poste1__implantation__region"
-
- def get_query_set(self):
- fkeys = (
- 'employe',
- 'poste1',
- 'implantation1',
- 'poste2',
- 'implantation2',
- 'service',
- 'responsable',
- 'remplacement_de',
- 'statut',
- 'organisme_bstg',
- 'classement',
- 'type_contrat',
- )
- return super(DossierManager, self).get_query_set().select_related(*fkeys).all()
-
-class Dossier(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=10, unique=True)
- employe = models.ForeignKey('Employe', db_column='employe')
- # Postes
- poste1 = models.ForeignKey('Poste', db_column='poste1',
- related_name='poste1')
- implantation1 = models.ForeignKey('datamaster_modeles.Implantation',
- db_column='implantation1',
- related_name='implantation1',
- blank=True, null=True)
- complement1 = models.TextField(null=True, blank=True)
- responsable_implantation1 = models.IntegerField()
- poste2 = models.ForeignKey('Poste', db_column='poste2',
- related_name='poste2',
- blank=True, null=True)
- implantation2 = models.ForeignKey('datamaster_modeles.Implantation',
- db_column='implantation2',
- related_name='implantation2',
- null=True, blank=True)
- complement2 = models.TextField(null=True, blank=True)
- responsable_implantation2 = models.IntegerField()
- # Relations
- service = models.ForeignKey('Service', db_column='service',
- blank=True, null=True)
- responsable = models.ForeignKey('Employe', db_column='responsable',
- related_name='responsable',
- blank=True, null=True)
- remplacement_de = models.ForeignKey('Employe', db_column='remplacement_de',
- related_name='remplacement_de',
- blank=True, null=True)
- type = models.CharField(max_length=1, choices=TYPE_DOSSIER_CHOICES)
- statut = models.ForeignKey('Statut', db_column='statut',
- blank=True, null=True)
- organisme_bstg = models.ForeignKey('OrganismeBstg',
- db_column='organisme_bstg',
- blank=True, null=True)
- # Rémunération
- classement = models.ForeignKey('Classement', db_column='classement',
- blank=True, null=True)
- regime_travail = models.IntegerField()
- # Mandat
- mandat_date_debut = models.DateField()
- mandat_date_fin = models.DateField(null=True, blank=True)
- # Contrat
- contrat_date_debut = models.DateField()
- contrat_date_fin = models.DateField()
- type_contrat = models.ForeignKey('TypeContrat', db_column='type_contrat',
- blank=True, null=True)
- # Meta
- date_creation = models.DateField(auto_now_add=True)
- date_maj = models.DateField(auto_now=True)
- commentaire = models.TextField(null=True, blank=True)
-
- # Managers
- objects = DossierManager()
-
- def __unicode__(self):
- return u'%s : %s %s' % (self.employe, self.poste1, self.complement1)
-
- def get_dernier_salaire_remun(self):
- remun = [r for r in self.remuneration_set.all().order_by('-id') if r.type_id == 1] # type salaire de base
- if len(remun) == 0:
- return None
- else:
- return remun[0]
-
- def get_salaire(self):
- remun = self.get_dernier_salaire_remun()
- if remun is not None:
- return int(remun.montant)
- else:
- return None
-
- def get_salaire_display(self):
- """
- Moyen rapide de récupérer le salaire correspodant à un dossier. Par contre,
- toutes les rémuérations n'ont pas de devise associées, c'est pourquoi on récupère
- les anciennes rémunérations pour rechercher si elle existait auparavant.
- """
- if self.dernier_salaire_remun() is not None:
- devise_code = self.dernier_salaire_remun().devise.code
- else:
- devise_code = '???'
- return "%s %s" % (self.get_salaire(), devise_code, )
-
- def get_salaire_euro_display(self):
- """
- Moyen rapide de récupérer le salaire correspodant à un dossier. Par contre,
- toutes les rémuérations n'ont pas de devise associées, c'est pourquoi on récupère
- les anciennes rémunérations pour rechercher si elle existait auparavant.
- La valeur est est affichée en Euros en se servant du taux actuel.
- """
- return "%s EUR" % (self.get_dernier_salaire_remun().en_euros())
-
-LIEN_PARENTE_CHOICES = (
- ('Conjoint', 'Conjoint'),
- ('Conjointe', 'Conjointe'),
- ('Fille', 'Fille'),
- ('Fils', 'Fils'),
-)
-
-class AyantDroit(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- prenom = models.CharField(max_length=255)
- # Relation
- employe = models.ForeignKey('Employe', db_column='employe',
- related_name='employe')
- lien_parente = models.CharField(max_length=10, null=True, blank=True,
- choices=LIEN_PARENTE_CHOICES)
- # Méta
- commentaire = models.TextField(null=True, blank=True)
- actif = models.BooleanField()
-
-
-class Remuneration(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- dossier = models.ForeignKey('Dossier', db_column='dossier')
- type = models.ForeignKey('TypeRemuneration', db_column='type')
- type_revalorisation = models.ForeignKey('TypeRevalorisation',
- db_column='type_revalorisation',
- null=True, blank=True)
- montant = models.FloatField(null=True, blank=True)
- devise = models.ForeignKey('Devise', to_field='id', db_column='devise', null=True, blank=True)
- date_effective = models.DateField(null=True, blank=True)
- pourcentage = models.IntegerField(null=True, blank=True)
- # Méta
- date_creation = models.DateField(auto_now_add=True)
- user_creation = models.IntegerField(null=True, blank=True) #User ou employé
- desactivation = models.NullBooleanField(null=True, blank=True) #
- date_desactivation = models.DateField(null=True, blank=True)
- user_desactivation = models.IntegerField(null=True, blank=True) #User ou employé
- annulation = models.NullBooleanField(null=True, blank=True)
- date_annulation = models.DateField(null=True, blank=True)
- user_annulation = models.IntegerField(null=True, blank=True) #User ou employé
-
- def __unicode__(self):
- try:
- devise = self.devise.code
- except:
- devise = "???"
- return "%s %s (%s EUR - %s)" % (self.montant, devise, self.en_euros(), self.get_taux_historique(), )
-
- def get_taux_historique(self):
- """
- Retourne le taux en vigueur durant l'année considérée. Un taux de 0 est crée, si le taux de change
- n'existe pas.
- """
- taux = TauxChange.objects.filter(devise=self.devise, annee=self.date_creation.year)
- if len(taux) > 0:
- return taux[0]
- else:
- return None
-
- def en_euros(self):
- tauxchange = self.get_taux_historique()
- if tauxchange is not None:
- return int(self.montant * tauxchange.taux)
- else:
- return 0
-
-class FamilleEmploi(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- # Méta
- actif = models.BooleanField()
-
-class TypePoste(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- nom_feminin = models.CharField(max_length=255)
- description = models.CharField(max_length=255)
- is_responsable = models.BooleanField()
- famille_emploi = models.ForeignKey('FamilleEmploi',
- db_column='famille_emploi')
- # Méta
- date_modification = models.DateField(auto_now=True)
- actif = models.BooleanField()
-
- def __unicode__(self):
- return u'%s' % self.nom
-
- class Meta:
- ordering = ['nom']
-
-
-TYPE_PAIEMENT_CHOICES = (
- ('Régulier', 'Régulier'),
- ('Ponctuel', 'Ponctuel'),
-)
-
-NATURE_REMUNERATION_CHOICES = (
- ('Accessoire', 'Accessoire'),
- ('Charges', 'Charges'),
- ('Indemnité', 'Indemnité'),
- ('RAS', 'RAS'),
- ('Traitement', 'Traitement'),
-)
-
-class TypeRemuneration(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- type_paiement = models.CharField(max_length=30,
- choices=TYPE_PAIEMENT_CHOICES)
- nature_remuneration = models.CharField(max_length=30,
- choices=NATURE_REMUNERATION_CHOICES)
- # Méta
- actif = models.BooleanField()
-
- def __unicode__(self):
- return u'%s' % self.nom
-
-
-class TypeRevalorisation(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- # Méta
- actif = models.BooleanField()
-
-PROPORTION_CHOICES = (
- ('0.5', '0.5'),
- ('1', '1'),
-)
-
-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(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- implantation = models.ForeignKey('datamaster_modeles.Implantation',
- db_column='implantation', related_name='+')
- type_poste = models.ForeignKey('TypePoste', db_column='type_poste')
- proportion = models.CharField(max_length=10, choices=PROPORTION_CHOICES)
- #(sert à quoi?) renommer "regime_travail" ou autre? convertir data en % (data * 100; ex: 1 = 100%)
- # Méta
- date_modification = models.DateField(auto_now=True)
- actif = models.BooleanField()
-
- # Managers
- objects = PosteManager()
-
- def __unicode__(self):
- return u'%s - %s [%s]' % (self.implantation, self.type_poste.nom,
- self.id)
-
-
-class Service(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- # Méta
- actif = models.BooleanField()
-
- def __unicode__(self):
- return u'%s' % self.nom
-
- class Meta:
- ordering = ['nom']
-
-
-TYPE_ORGANISME_CHOICES = (
- ('MAD', 'Mise à disposition'),
- ('DET', 'Détachement'),
-)
-
-class OrganismeBstg(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- type = models.CharField(max_length=10, choices=TYPE_ORGANISME_CHOICES)
- # Méta
- actif = models.BooleanField()
-
- def __unicode__(self):
- return u'%s (%s)' % (self.nom, self.type)
-
- class Meta:
- ordering = ['type', 'nom']
-
-
-CONTRAT_CATEGORIE_CHOICES= (
- ('A', 'A'),
- ('C', 'C'),
-)
-class Statut(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=25, unique=True)
- nom = models.CharField(max_length=255)
- type_contrat_categorie = models.CharField(max_length=10,
- choices=CONTRAT_CATEGORIE_CHOICES)
- #CHOICES A, C (veut dire quoi?) voir TypeContrat.categorie
- # Méta
- actif = models.BooleanField()
-
- def __unicode__(self):
- return u'%s : %s' % (self.code, self.nom)
-
-TYPE_CLASSEMENT_CHOICES = (
- ('S', 'S'),
- ('T', 'T'),
-)
-
-class ClassementManager(models.Manager):
- """
- Ordonner les spcéfiquement les classements.
- """
- def get_query_set(self):
- qs = super(self.__class__, self).get_query_set()
- qs = qs.extra(select={'ponderation': 'FIND_IN_SET(type,"SO,HG,S,T,P,C,D")'})
- qs = qs.extra(order_by=('ponderation', ))
- return qs.all()
-
-
-class Classement(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- type = models.CharField(max_length=10, choices=TYPE_CLASSEMENT_CHOICES)
- echelon = models.IntegerField()
- degre = models.IntegerField()
- coefficient = models.FloatField()
- # Méta
- commentaire = models.TextField(null=True, blank=True)
- date_modification = models.DateField(auto_now=True)
- actif = models.BooleanField()
-
- # managers
- objects = ClassementManager()
-
- def __unicode__(self):
- return u'%s.%s.%s' % (self.type, self.echelon, self.degre )
-
- class Meta:
- ordering = ['type','echelon','degre','coefficient']
-
-class TauxChange(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- devise = models.ForeignKey('Devise', to_field='id', db_column='devise')
- annee = models.IntegerField()
- taux = models.FloatField()
- # Relations
- implantation = models.ForeignKey('datamaster_modeles.Implantation',
- db_column='implantation',
- related_name='taux_change')
-
- def __unicode__(self):
- return u"%s %s : %s" % (self.devise, self.annee, self.taux)
-
-class ValeurPointManager(models.Manager):
- """
- Manager qui travaille uniquement sur les valeurs du point de l'année en cours.
- """
- mois = datetime.datetime.now().month
- annee_courante = datetime.datetime.now().year
-
- # Pour le mois de janvier et décembre on mets les 2 années pour faire la transition
- if mois == 1:
- filtre_annee = (annee_courante-1, annee_courante)
- elif mois == 12:
- filtre_annee = (annee_courante, annee_courante+1)
- else:
- filtre_annee = (annee_courante,)
-
- def get_query_set(self):
- return super(ValeurPointManager, self).get_query_set().select_related('implantation').filter(annee__in=self.filtre_annee)
-
-
-class ValeurPoint(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- valeur = models.FloatField()
- implantation = models.ForeignKey('datamaster_modeles.Implantation',
- db_column='implantation',
- related_name='valeurs_point')
- # Méta
- annee = models.IntegerField()
-
- # Stockage de tous les taux de change pour optimiser la recherche de la devise associée
- annee_courante = datetime.datetime.now().year
- tauxchange = TauxChange.objects.select_related('devise').filter(annee=annee_courante)
-
- 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):
- tx = self.get_tauxchange_courant()
- if tx:
- devise_code = tx.devise.code
- else:
- devise_code = "??"
- return u'%s %s (%s-%s)' % (self.valeur, devise_code, self.implantation.nom, self.annee)
-
- class Meta:
- ordering = ['valeur']
-
- objects = models.Manager()
- actuelles = ValeurPointManager()
-
-class DeviseManager(models.Manager):
- """
- On oublie le US et le CAN
- """
- def get_query_set(self):
- return super(DeviseManager, self).get_query_set().exclude(id__in=(3, 15))
-
-class Devise(models.Model):
-
- objects = DeviseManager()
-
- id = models.IntegerField(primary_key=True)
- code = models.CharField(max_length=10, unique=True)
- nom = models.CharField(max_length=255)
-
- def __unicode__(self):
- return u'%s - %s' % (self.code, self.nom)
-
-
-class TypeContrat(models.Model):
- # Identification
- id = models.IntegerField(primary_key=True)
- nom = models.CharField(max_length=255)
- nom_long = models.CharField(max_length=255) #description
- categorie = models.CharField(max_length=10,
- choices=CONTRAT_CATEGORIE_CHOICES)
- # Méta
- actif = models.BooleanField()
-
- def __unicode__(self):
- return u'%s' % (self.nom)