+++ /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 auf.django.references.models import Pays, Implantation
-from 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(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(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(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(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(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(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(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)