order by moyenne
[auf_rh_dae.git] / project / recrutement / migrations / 0002_tpl_courriel.py
CommitLineData
bddb6902
OL
1# encoding: utf-8
2import datetime
3from south.db import db
4from south.v2 import DataMigration
5from django.db import models
6
7class Migration(DataMigration):
8
9 def forwards(self, orm):
10 "Write your forwards methods here."
11
12 # Création du template de courriel par défaut. (Confirmation de postulation à l'offre d'emploi
13 template = orm.CourrielTemplate()
14 template.id = 1
15 template.nom_modele = "Confirmation de postulation pour une offre d'emploi (envoi automatique)"
16 template.sujet = "Confirmation de postulation pour l'offre d'emploi: {{ offre_emploi }}"
17 template.plain_text = "Bonjour {{ genre_candidat }} {{ nom_candidat }},\n\nCe courriel est pour vous confirmer que nous avons bien reçu votre candidature pour l'offre d'emploi {{ offre_emploi }}.\n\n Merci de l'intérêt que vous portez à l'AUF."
18 template.html = "<p>Bonjour {{ genre_candidat }} {{ nom_candidat }},<br /> \
19 Ce courriel est pour vous confirmer que nous \
20 avons bien reçu votre candidature pour l'offre \
21 d'emploi {{ offre_emploi }}. <br /> <br /> \
22 Merci de l'intérêt que vous portez à l'AUF.</p>"
23 template.save()
24
25
26 def backwards(self, orm):
27 "Write your backwards methods here."
28 template = orm.CourrielTemplate.objects.get(id=1).delete()
29
30 models = {
31 'auth.group': {
32 'Meta': {'object_name': 'Group'},
33 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
34 'name': ('django.db.models.fields.CharField', [], {'max_length': '80', 'unique': 'True'}),
35 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
36 },
37 'auth.permission': {
38 'Meta': {'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
39 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
40 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
41 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
42 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
43 },
44 'auth.user': {
45 'Meta': {'object_name': 'User'},
46 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
47 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
48 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
49 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
50 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
51 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
52 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
53 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
54 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
55 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
56 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
57 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
58 'username': ('django.db.models.fields.CharField', [], {'max_length': '30', 'unique': 'True'})
59 },
60 'contenttypes.contenttype': {
61 'Meta': {'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
62 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
63 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
64 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
65 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
66 },
67 'datamaster_modeles.bureau': {
68 'Meta': {'object_name': 'Bureau', 'db_table': "u'ref_bureau'"},
69 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
70 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
71 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
72 'implantation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
73 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
74 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
75 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
76 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"})
77 },
78 'datamaster_modeles.implantation': {
79 'Meta': {'object_name': 'Implantation', 'db_table': "u'ref_implantation'"},
80 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
81 'adresse_physique_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
82 'adresse_physique_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
83 'adresse_physique_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
84 'adresse_physique_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
85 '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']"}),
86 'adresse_physique_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
87 'adresse_physique_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
88 'adresse_physique_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
89 'adresse_physique_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
90 'adresse_physique_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
91 'adresse_postale_boite_postale': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
92 'adresse_postale_bureau': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
93 'adresse_postale_code_postal': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
94 'adresse_postale_code_postal_avant_ville': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
95 'adresse_postale_no': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
96 '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']"}),
97 'adresse_postale_precision': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
98 'adresse_postale_precision_avant': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
99 'adresse_postale_region': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
100 'adresse_postale_rue': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
101 'adresse_postale_ville': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
102 'bureau_rattachement': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'bureau_rattachement'"}),
103 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
104 'code_meteo': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
105 'commentaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
106 'courriel': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
107 'courriel_interne': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
108 'date_extension': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
109 'date_fermeture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
110 'date_inauguration': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
111 'date_ouverture': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
112 'fax': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
113 'fax_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
114 'fuseau_horaire': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
115 'hebergement_convention': ('django.db.models.fields.NullBooleanField', [], {'null': 'True', 'blank': 'True'}),
116 'hebergement_convention_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
117 'hebergement_etablissement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
118 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
119 'modif_date': ('django.db.models.fields.DateField', [], {}),
120 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
121 'nom_court': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
122 'nom_long': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
123 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"}),
124 'remarque': ('django.db.models.fields.TextField', [], {}),
125 'responsable_implantation': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
126 'statut': ('django.db.models.fields.IntegerField', [], {}),
127 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
128 'telephone_interne': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
129 'type': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
130 'url': ('django.db.models.fields.URLField', [], {'max_length': '255', 'blank': 'True'})
131 },
132 'datamaster_modeles.pays': {
133 'Meta': {'object_name': 'Pays', 'db_table': "u'ref_pays'"},
134 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
135 'code': ('django.db.models.fields.CharField', [], {'max_length': '2', 'unique': 'True'}),
136 'code_bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'to_field': "'code'", 'db_column': "'code_bureau'"}),
137 'code_iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'unique': 'True', 'blank': 'True'}),
138 'developpement': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
139 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
140 'monnaie': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
141 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
142 'nord_sud': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
143 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"})
144 },
145 'datamaster_modeles.region': {
146 'Meta': {'object_name': 'Region', 'db_table': "u'ref_region'"},
147 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
148 'code': ('django.db.models.fields.CharField', [], {'max_length': '255', 'unique': 'True'}),
149 'id': ('django.db.models.fields.IntegerField', [], {'primary_key': 'True'}),
150 'implantation_bureau': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'gere_region'", 'db_column': "'implantation_bureau'", 'to': "orm['datamaster_modeles.Implantation']"}),
151 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'})
152 },
153 'emploi.candidat': {
154 'Meta': {'object_name': 'Candidat'},
155 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
156 'adresse': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
157 'code_postal': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
158 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
159 'domaine_professionnel': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
160 'email': ('django.db.models.fields.EmailField', [], {'max_length': '255'}),
161 'employeur_actuel': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
162 'etat_province': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
163 'genre': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
164 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
165 'nationalite': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'nationalite'", 'to': "orm['datamaster_modeles.Pays']"}),
166 'niveau_diplome': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
167 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
168 'nombre_dependant': ('django.db.models.fields.IntegerField', [], {}),
169 'offre_emploi': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'offre_emploi'", 'to': "orm['emploi.OffreEmploi']"}),
170 'pays': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'pays'", 'to': "orm['datamaster_modeles.Pays']"}),
171 'poste_actuel': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
172 'prenom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
173 'situation_famille': ('django.db.models.fields.CharField', [], {'max_length': '1'}),
174 'statut': ('django.db.models.fields.CharField', [], {'default': "'NOUV'", 'max_length': '4'}),
175 'telephone': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
176 'ville': ('django.db.models.fields.CharField', [], {'max_length': '255'})
177 },
178 'emploi.offreemploi': {
179 'Meta': {'object_name': 'OffreEmploi'},
180 'actif': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
181 'bureau': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Bureau']", 'db_column': "'bureau'"}),
182 'date_creation': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
183 'date_limite': ('django.db.models.fields.DateField', [], {}),
184 'debut_affectation': ('django.db.models.fields.DateField', [], {}),
185 'description': ('django.db.models.fields.TextField', [], {}),
186 'duree_affectation': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
187 'est_affiche': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
188 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
189 'lieu_affectation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Implantation']", 'db_column': "'implantation'"}),
190 'nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
191 'poste': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
192 'poste_nom': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
193 'region': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['datamaster_modeles.Region']", 'db_column': "'region'"}),
194 'renumeration': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
195 'resume': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
196 'statut': ('django.db.models.fields.CharField', [], {'default': "'NOUV'", 'max_length': '4'})
197 },
198 'recrutement.candidat': {
199 'Meta': {'object_name': 'Candidat', 'db_table': "'emploi_candidat'", '_ormbases': ['emploi.Candidat']}
200 },
201 'recrutement.candidatcourriel': {
202 'Meta': {'object_name': 'CandidatCourriel'},
203 'candidats': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['emploi.Candidat']", 'symmetrical': 'False'}),
204 'html': ('tinymce.models.HTMLField', [], {'null': 'True', 'blank': 'True'}),
205 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
206 'plain_text': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
207 'sujet': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
208 'template': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'template'", 'to': "orm['recrutement.CourrielTemplate']"})
209 },
210 'recrutement.candidatevaluation': {
211 'Meta': {'object_name': 'CandidatEvaluation'},
212 'candidat': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'candidat'", 'to': "orm['emploi.Candidat']"}),
213 'commentaire': ('django.db.models.fields.TextField', [], {'default': "'Aucun'", 'null': 'True', 'blank': 'True'}),
214 'date': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}),
215 'evaluateur': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'+'", 'db_column': "'evaluateur'", 'to': "orm['recrutement.Evaluateur']"}),
216 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
217 'note': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'})
218 },
219 'recrutement.courrieltemplate': {
220 'Meta': {'object_name': 'CourrielTemplate'},
221 'html': ('tinymce.models.HTMLField', [], {}),
222 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
223 'nom_modele': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
224 'plain_text': ('django.db.models.fields.TextField', [], {}),
225 'sujet': ('django.db.models.fields.CharField', [], {'max_length': '100'})
226 },
227 'recrutement.evaluateur': {
228 'Meta': {'object_name': 'Evaluateur'},
229 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
230 'offres_emploi': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'evaluateurs'", 'blank': 'True', 'to': "orm['emploi.OffreEmploi']"}),
231 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'unique': 'True'})
232 }
233 }
234
235 complete_apps = ['recrutement']