Commit | Line | Data |
---|---|---|
5d680e84 | 1 | # -*- encoding: utf-8 -*- |
f87fe1a1 OL |
2 | |
3 | import datetime | |
8e30e17f | 4 | from datetime import date |
3feae3c6 | 5 | from simplejson import dumps |
139686f2 | 6 | |
5a1f75cb EMS |
7 | from django.contrib import messages |
8 | from django.contrib.auth.decorators import login_required | |
9 | from django.contrib.contenttypes.models import ContentType | |
3f5cbabe | 10 | from django.core.exceptions import MultipleObjectsReturned |
44055779 | 11 | from django.core.paginator import Paginator, InvalidPage |
5a1f75cb | 12 | from django.db.models import Q |
86f1e48d | 13 | from django.http import Http404, HttpResponse, HttpResponseGone |
890b80e7 | 14 | from django.shortcuts import redirect, render, get_object_or_404 |
75f0e87b | 15 | |
e3563bcf EMS |
16 | from sendfile import sendfile |
17 | ||
75f0e87b DB |
18 | from auf.django.permissions.decorators import get_object |
19 | ||
5a1f75cb EMS |
20 | from project.dae import models as dae |
21 | from project.dae.decorators import \ | |
acbc95a1 | 22 | dae_groupe_requis, \ |
8684fcaa EMS |
23 | poste_dans_ma_region_ou_service, \ |
24 | dossier_dans_ma_region_ou_service, \ | |
25 | vieux_dossier_dans_ma_region_ou_service, \ | |
26 | employe_dans_ma_region_ou_service, \ | |
27 | dossier_est_modifiable, \ | |
28 | poste_est_modifiable, get_contrat | |
5a1f75cb EMS |
29 | from project.dae.forms import \ |
30 | PosteWorkflowForm, PosteForm, FinancementForm, PostePieceForm, \ | |
31 | PosteComparaisonFormSet, DossierWorkflowForm, ChoosePosteForm, \ | |
32 | EmployeForm, DossierForm, DossierPieceForm, \ | |
33 | DossierComparaisonFormSet, RemunForm, ContratForm, DAENumeriseeForm, \ | |
cbfd7bd4 | 34 | label_poste_display, DAEFinaliseesSearchForm |
5a1f75cb EMS |
35 | from project.dae.mail import send_drh_finalisation_mail |
36 | from project.dae.workflow import \ | |
37 | DOSSIER_ETAT_FINALISE, DOSSIER_ETAT_REGION_FINALISATION, \ | |
38 | DOSSIER_ETAT_DRH_FINALISATION, POSTE_ETAT_FINALISE | |
1b31de9f | 39 | from project.decorators import redirect_interdiction |
5a1f75cb | 40 | from project.rh import models as rh |
8684fcaa | 41 | |
ed1982f3 | 42 | |
0a085c42 OL |
43 | def devises(): |
44 | liste = [] | |
45 | for d in rh.Devise.objects.all(): | |
46 | annee = date.today().year | |
47 | taux = rh.TauxChange.objects.filter(annee=annee, devise=d) | |
48 | data = {} | |
49 | if len(taux) == 0: | |
50 | data['taux_euro'] = 0 | |
51 | else: | |
52 | data['taux_euro'] = taux[0].taux | |
378ffe6c | 53 | data['devise_code'] = d.id |
0a085c42 OL |
54 | liste.append(data) |
55 | return liste | |
56 | ||
5a1f75cb | 57 | |
5633fa41 | 58 | @dae_groupe_requis |
5d680e84 | 59 | def index(request): |
890b80e7 | 60 | return render(request, 'dae/index.html', {}) |
5d680e84 | 61 | |
e3563bcf EMS |
62 | |
63 | ### POSTE | |
64 | ||
5633fa41 OL |
65 | @dae_groupe_requis |
66 | @poste_dans_ma_region_ou_service | |
c0413a6f OL |
67 | def poste_consulter(request, key): |
68 | source, id = key.split('-') | |
69 | poste = get_object_or_404(dae.Poste, pk=id) | |
8684fcaa | 70 | |
e6f52402 | 71 | if request.POST: |
5a1f75cb EMS |
72 | validationForm = PosteWorkflowForm( |
73 | request.POST, instance=poste, request=request | |
74 | ) | |
e6f52402 OL |
75 | if validationForm.is_valid(): |
76 | validationForm.save() | |
5a1f75cb EMS |
77 | messages.add_message( |
78 | request, messages.SUCCESS, "La validation a été enregistrée." | |
79 | ) | |
18c6d4c0 | 80 | return redirect('dae_postes_liste') |
e6f52402 OL |
81 | else: |
82 | validationForm = PosteWorkflowForm(instance=poste, request=request) | |
8684fcaa | 83 | |
5a1f75cb EMS |
84 | comparaisons_internes = \ |
85 | poste.dae_comparaisons_internes.ma_region_ou_service(request.user) | |
1de3da13 EMS |
86 | vars = { |
87 | 'poste': poste, | |
88 | 'validationForm': validationForm, | |
89 | 'comparaisons_internes': comparaisons_internes | |
90 | } | |
868a9322 | 91 | |
890b80e7 | 92 | return render(request, 'dae/poste_consulter.html', vars) |
5a1f75cb | 93 | |
c0413a6f | 94 | |
6fcc7644 EMS |
95 | def poste_importer(request, id): |
96 | poste_dae = get_object_or_404(dae.Poste, id=id) | |
97 | if request.method == 'POST': | |
98 | if 'confirmer' in request.POST: | |
99 | poste_rh = poste_dae.importer_dans_rh() | |
100 | return redirect('admin:rh_poste_change', poste_rh.id) | |
101 | else: | |
102 | return redirect('poste_consulter', 'dae-' + id) | |
103 | else: | |
890b80e7 DB |
104 | c = { |
105 | 'poste': poste_dae, | |
106 | } | |
107 | return render(request, 'dae/poste_importer.html', c) | |
6fcc7644 EMS |
108 | |
109 | ||
5633fa41 | 110 | @dae_groupe_requis |
1b217058 | 111 | @poste_dans_ma_region_ou_service |
6e80b20c | 112 | @poste_est_modifiable |
3ed49093 | 113 | def poste(request, key=None): |
5d680e84 NC |
114 | """ Formulaire pour un poste. |
115 | ||
116 | Permet de créer ou modifier un poste. Si le poste n'existe que dans rh_v1 | |
117 | il est automatiquement copié dans dae. | |
118 | ||
119 | """ | |
120 | poste, data, vars = None, dict(), dict() | |
121 | ||
3ed49093 | 122 | if key: |
5d680e84 | 123 | # Poste existant |
139686f2 | 124 | source, id = key.split('-') |
5d680e84 | 125 | |
139686f2 | 126 | if source == 'dae': |
5d680e84 | 127 | poste = get_object_or_404(dae.Poste, pk=id) |
2e672700 | 128 | poste_rh = None |
139686f2 | 129 | elif source == 'rh': |
2e672700 | 130 | poste_rh = get_object_or_404(rh.Poste, pk=id) |
5d680e84 | 131 | # Initialisation avec les valeurs du poste de rh_v1 |
2e672700 OL |
132 | poste = dae.Poste(id_rh=poste_rh) |
133 | exclus = ('id', 'supprime', 'date_creation', | |
134 | 'user_creation', 'date_modification', | |
135 | 'user_modification', ) | |
136 | fields = [f for f in poste_rh._meta.fields if f.name not in exclus] | |
137 | for field in fields: | |
138 | setattr(poste, field.name, getattr(poste_rh, field.name)) | |
139 | ||
925ba6c3 EMS |
140 | if poste.id_rh_id: |
141 | data['poste'] = 'rh-' + str(poste.id_rh_id) | |
142 | else: | |
143 | data['poste'] = key | |
3ed49093 NC |
144 | else: |
145 | # Nouveau poste | |
146 | vars['new'] = True | |
5d680e84 | 147 | |
2e672700 OL |
148 | # prépopuler pour la modification de poste |
149 | ||
150 | if poste_rh is None: # poste RH n'est pas un modele | |
151 | qs_financements = poste.dae_financements.all() | |
152 | qs_comparaisons = poste.dae_comparaisons_internes.all() | |
153 | else: | |
154 | qs_financements = poste_rh.rh_financements.all() | |
155 | qs_comparaisons = poste_rh.rh_comparaisons_internes.all() | |
156 | ||
157 | financements = [{'type': f.type, 'pourcentage': f.pourcentage, | |
158 | 'commentaire': f.commentaire} for f in qs_financements] | |
159 | comparaisons = [{'implantation': c.implantation, 'nom': c.nom, | |
160 | 'montant': c.montant, 'devise': c.devise} for c in qs_comparaisons] | |
161 | ||
162 | ||
5d680e84 | 163 | if request.POST: |
3ed49093 | 164 | data.update(dict(request.POST.items())) |
f258e4e7 | 165 | form = PosteForm(data, instance=poste, request=request) |
2e672700 OL |
166 | financementForm = FinancementForm(request.POST, instance=poste, |
167 | ) | |
5a1f75cb | 168 | piecesForm = PostePieceForm( |
2e672700 | 169 | request.POST, request.FILES, instance=poste, |
5a1f75cb | 170 | ) |
c4bfc2a0 EMS |
171 | if isinstance(poste, dae.Poste): |
172 | comparaisons_formset = PosteComparaisonFormSet( | |
173 | request.POST, | |
5a1f75cb | 174 | queryset=poste.dae_comparaisons_internes.ma_region_ou_service( |
2e672700 | 175 | request.user, |
5a1f75cb | 176 | ) |
c4bfc2a0 EMS |
177 | ) |
178 | else: | |
179 | comparaisons_formset = PosteComparaisonFormSet( | |
180 | request.POST, | |
2e672700 OL |
181 | initial=comparaisons, |
182 | queryset=dae.PosteComparaison.objects.none(), | |
c4bfc2a0 | 183 | ) |
5a1f75cb EMS |
184 | if form.is_valid() and piecesForm.is_valid() and \ |
185 | financementForm.is_valid() and comparaisons_formset.is_valid(): | |
5d680e84 | 186 | poste = form.save() |
eb8c3edb OL |
187 | piecesForm.instance = poste |
188 | piecesForm.save() | |
151e7bd0 OL |
189 | financementForm.instance = poste |
190 | financementForm.save() | |
320d7584 EMS |
191 | |
192 | # Ne remplacer que les comparaisons de ma région | |
193 | comparaisons = comparaisons_formset.save(commit=False) | |
194 | for comparaison in comparaisons: | |
195 | comparaison.poste = poste | |
196 | comparaison.save() | |
197 | ||
2e672700 OL |
198 | # dans le cas d'une modification de poste de RH, on recopie les PJ |
199 | if poste_rh is not None: | |
200 | for piece in poste_rh.rh_pieces.all(): | |
201 | dae.PostePiece(poste=poste, nom=piece.nom, | |
202 | fichier=piece.fichier).save() | |
5a1f75cb EMS |
203 | messages.add_message( |
204 | request, messages.SUCCESS, | |
205 | "Le poste %s a été sauvegardé." % poste | |
206 | ) | |
207 | if 'save' in request.POST: | |
5bc760f9 OL |
208 | return redirect('poste_consulter', key='dae-%s' % poste.id) |
209 | else: | |
210 | return redirect('poste', key='dae-%s' % poste.id) | |
8684fcaa | 211 | |
9cb4de55 | 212 | else: |
5a1f75cb EMS |
213 | messages.add_message( |
214 | request, messages.ERROR, | |
215 | 'Il y a des erreurs dans le formulaire.' | |
216 | ) | |
8684fcaa | 217 | |
5d680e84 NC |
218 | else: |
219 | # 'initial' évite la validation prémature lors d'une copie de poste de | |
220 | # rh_v1 vers dae. | |
f258e4e7 | 221 | form = PosteForm(initial=data, instance=poste, request=request) |
2e672700 OL |
222 | |
223 | piecesForm = PostePieceForm( | |
224 | #initial=pieces, | |
225 | instance=poste) | |
226 | financementForm = FinancementForm(initial=financements, instance=poste) | |
227 | ||
829eb351 EMS |
228 | if isinstance(poste, dae.Poste): |
229 | comparaisons_formset = PosteComparaisonFormSet( | |
2e672700 | 230 | initial=comparaisons, |
5a1f75cb EMS |
231 | queryset=poste.dae_comparaisons_internes.ma_region_ou_service( |
232 | request.user | |
233 | ) | |
829eb351 EMS |
234 | ) |
235 | else: | |
236 | comparaisons_formset = PosteComparaisonFormSet( | |
2e672700 | 237 | initial=comparaisons, |
829eb351 EMS |
238 | queryset=dae.PosteComparaison.objects.none() |
239 | ) | |
5d680e84 | 240 | |
320d7584 EMS |
241 | vars.update(dict( |
242 | form=form, poste=poste, poste_key=key, piecesForm=piecesForm, | |
243 | financementForm=financementForm, | |
2e672700 OL |
244 | comparaisons_formset=comparaisons_formset, |
245 | poste_rh=poste_rh, | |
320d7584 | 246 | )) |
5d680e84 | 247 | |
890b80e7 | 248 | return render(request, 'dae/poste.html', vars) |
3ed49093 | 249 | |
5a1f75cb | 250 | |
5633fa41 | 251 | @dae_groupe_requis |
498881f4 | 252 | def postes_liste(request): |
0f23302a | 253 | """ Liste des postes. """ |
92741270 EMS |
254 | content_type = ContentType.objects.get_for_model(dae.Poste) |
255 | extra_select = {'derniere_validation': ( | |
256 | "SELECT MAX(date) FROM workflow_workflowcommentaire " | |
5a1f75cb EMS |
257 | "WHERE content_type_id = '%s' AND object_id = dae_poste.id" % |
258 | content_type.id | |
92741270 EMS |
259 | )} |
260 | postes_a_traiter = dae.Poste.objects.mes_choses_a_faire(request.user) \ | |
261 | .extra(select=extra_select).order_by('-date_creation') | |
262 | postes_en_cours = dae.Poste.objects.ma_region_ou_service(request.user) \ | |
5a1f75cb EMS |
263 | .extra(select=extra_select) \ |
264 | .filter(~Q(etat=POSTE_ETAT_FINALISE)) \ | |
265 | .order_by('-date_creation') | |
890b80e7 | 266 | c = { |
92741270 EMS |
267 | 'postes_a_traiter': postes_a_traiter, |
268 | 'postes_en_cours': postes_en_cours, | |
890b80e7 DB |
269 | } |
270 | return render(request, 'dae/postes_liste.html', c) | |
98d51b59 | 271 | |
5a1f75cb | 272 | |
e3563bcf | 273 | @login_required |
67a94eaf | 274 | def poste_piece(request, id, filename): |
e3563bcf EMS |
275 | """Téléchargement d'une pièce jointe à un poste.""" |
276 | piece = get_object_or_404(dae.PostePiece, pk=id) | |
5a1f75cb EMS |
277 | if dae.Poste.objects.ma_region_ou_service(request.user) \ |
278 | .filter(id=piece.poste_id).exists(): | |
67a94eaf | 279 | return sendfile(request, piece.fichier.path) |
e3563bcf EMS |
280 | else: |
281 | return redirect_interdiction(request) | |
282 | ||
283 | ||
284 | ### DOSSIER | |
285 | ||
cb1d62b5 | 286 | def filtered_type_remun(): |
5a1f75cb EMS |
287 | defaut = (2, 3, 8, 17) # salaire de base, indemnité de fonction, |
288 | # charges patronales | |
0a085c42 | 289 | return rh.TypeRemuneration.objects.filter(pk__in=defaut) |
cb1d62b5 | 290 | |
5a1f75cb | 291 | |
5633fa41 | 292 | @dae_groupe_requis |
62d3903d | 293 | @dossier_dans_ma_region_ou_service |
5d5a57a4 OL |
294 | def embauche_consulter(request, dossier_id): |
295 | dossier = get_object_or_404(dae.Dossier, pk=dossier_id) | |
8684fcaa | 296 | etat_precedent = dossier.etat |
e6f52402 OL |
297 | |
298 | if request.POST: | |
5a1f75cb EMS |
299 | validationForm = DossierWorkflowForm( |
300 | request.POST, instance=dossier, request=request | |
301 | ) | |
e6f52402 | 302 | if validationForm.is_valid(): |
8684fcaa | 303 | if etat_precedent == DOSSIER_ETAT_REGION_FINALISATION and \ |
5a1f75cb EMS |
304 | validationForm.cleaned_data['etat'] == \ |
305 | DOSSIER_ETAT_DRH_FINALISATION: | |
8684fcaa | 306 | send_drh_finalisation_mail(request, dossier) |
e6f52402 | 307 | validationForm.save() |
5a1f75cb EMS |
308 | messages.add_message( |
309 | request, messages.SUCCESS, "La validation a été enregistrée." | |
310 | ) | |
18c6d4c0 | 311 | return redirect('dae_embauches_liste') |
e6f52402 OL |
312 | else: |
313 | validationForm = DossierWorkflowForm(instance=dossier, request=request) | |
9536ea21 | 314 | |
5a1f75cb EMS |
315 | comparaisons_internes = \ |
316 | dossier.poste.dae_comparaisons_internes.ma_region_ou_service( | |
317 | request.user | |
318 | ) | |
a4125771 | 319 | comparaisons = dossier.dae_comparaisons.ma_region_ou_service(request.user) |
5d5a57a4 | 320 | vars = { |
291bbfd9 EMS |
321 | 'dossier': dossier, |
322 | 'validationForm': validationForm, | |
320d7584 EMS |
323 | 'comparaisons_internes': comparaisons_internes, |
324 | 'comparaisons': comparaisons | |
325 | } | |
890b80e7 | 326 | return render(request, 'dae/embauche_consulter.html', vars) |
5a1f75cb | 327 | |
5d5a57a4 | 328 | |
5633fa41 | 329 | @dae_groupe_requis |
fb0ed970 EMS |
330 | @dossier_dans_ma_region_ou_service |
331 | def embauche_importer(request, dossier_id=None): | |
332 | dossier_dae = get_object_or_404(dae.Dossier, id=dossier_id) | |
47b60f16 EMS |
333 | if request.method == 'POST': |
334 | if 'confirmer' in request.POST: | |
335 | dossier_rh = dossier_dae.importer_dans_rh() | |
336 | return redirect('admin:rh_dossier_change', dossier_rh.id) | |
337 | else: | |
338 | return redirect('embauches_finalisees') | |
339 | else: | |
890b80e7 DB |
340 | c = { |
341 | 'dossier': dossier_dae, | |
342 | } | |
343 | return render(request, 'dae/embauche_importer.html', c) | |
fb0ed970 EMS |
344 | |
345 | ||
346 | @dae_groupe_requis | |
577dcb77 | 347 | def embauche_choisir_poste(request): |
890b80e7 DB |
348 | c = { |
349 | 'form': ChoosePosteForm(request=request), | |
350 | } | |
351 | return render(request, 'dae/embauche-choisir-poste.html', c) | |
577dcb77 | 352 | |
5a1f75cb | 353 | |
577dcb77 | 354 | @dae_groupe_requis |
62d3903d | 355 | @dossier_dans_ma_region_ou_service |
62cfa562 | 356 | @dossier_est_modifiable |
62d3903d | 357 | def embauche(request, key=None, dossier_id=None): |
139686f2 | 358 | """ Formulaire d'autorisation d'embauche. """ |
139686f2 | 359 | |
577dcb77 EMS |
360 | # Récupérer ou créer un poste et un dossier |
361 | source, id = key.split('-') | |
362 | if source != 'dae': | |
363 | return Http404 | |
364 | poste = get_object_or_404(dae.Poste, pk=id) | |
365 | ||
366 | if request.POST: | |
367 | if request.POST['employe'] == '': | |
368 | # Nouvel employé | |
369 | employe = dae.Employe() | |
370 | else: | |
371 | employe_source, id = request.POST['employe'].split('-') | |
372 | if employe_source == 'dae': | |
373 | # Employé DAE | |
374 | employe = get_object_or_404(dae.Employe, pk=id) | |
375 | elif employe_source == 'rh': | |
376 | # Employé RH, on le copie dans DAE | |
377 | e = get_object_or_404(rh.Employe, pk=id) | |
378 | employe = dae.Employe(id_rh=e, prenom=e.prenom, nom=e.nom, | |
379 | genre=e.genre) | |
139686f2 | 380 | else: |
577dcb77 EMS |
381 | raise Http404 |
382 | ||
5a1f75cb EMS |
383 | employe_form = EmployeForm( |
384 | request.POST, instance=employe, request=request | |
385 | ) | |
577dcb77 EMS |
386 | |
387 | if employe_form.is_valid(): | |
388 | data = dict(request.POST.items()) | |
389 | employe = employe_form.save() | |
390 | data['employe'] = 'dae-%s' % employe.id | |
391 | employe_form = EmployeForm(data, instance=employe, request=request) | |
392 | ||
393 | if not dossier_id: | |
394 | dossier = dae.Dossier(poste=poste, employe=employe) | |
395 | else: | |
396 | dossier = get_object_or_404(dae.Dossier, pk=dossier_id) | |
16b1454e | 397 | dossier.employe = employe_form.instance |
577dcb77 EMS |
398 | |
399 | dossier_form = DossierForm(request.POST, instance=dossier) | |
5a1f75cb EMS |
400 | piecesForm = DossierPieceForm( |
401 | request.POST, request.FILES, instance=dossier | |
402 | ) | |
320d7584 EMS |
403 | comparaisons_formset = DossierComparaisonFormSet( |
404 | request.POST, | |
5a1f75cb EMS |
405 | queryset=dossier.dae_comparaisons.ma_region_ou_service( |
406 | request.user | |
407 | ) | |
320d7584 | 408 | ) |
577dcb77 EMS |
409 | remunForm = RemunForm(request.POST, instance=dossier) |
410 | ||
55360d7d EMS |
411 | if employe_form.is_valid() and \ |
412 | dossier_form.is_valid() and \ | |
577dcb77 | 413 | piecesForm.is_valid() and \ |
320d7584 | 414 | comparaisons_formset.is_valid() and \ |
577dcb77 EMS |
415 | remunForm.is_valid(): |
416 | employe.save() | |
55360d7d | 417 | dossier_form.save() |
577dcb77 | 418 | piecesForm.save() |
577dcb77 | 419 | remunForm.save() |
320d7584 EMS |
420 | |
421 | # Ne remplacer que les comparaisons de ma région | |
422 | comparaisons = comparaisons_formset.save(commit=False) | |
423 | for comparaison in comparaisons: | |
424 | comparaison.dossier = dossier | |
425 | comparaison.save() | |
426 | ||
5a1f75cb EMS |
427 | messages.success( |
428 | request, "Le dossier %s a été sauvegardé." % dossier | |
429 | ) | |
430 | if 'save' in request.POST: | |
577dcb77 | 431 | return redirect('embauche_consulter', dossier_id=dossier.id) |
768d7e1b | 432 | else: |
5a1f75cb EMS |
433 | return redirect( |
434 | 'embauche', key=dossier.poste.key, dossier_id=dossier.id | |
435 | ) | |
9536ea21 | 436 | |
577dcb77 | 437 | else: |
5a1f75cb EMS |
438 | messages.add_message( |
439 | request, messages.ERROR, | |
440 | 'Il y a des erreurs dans le formulaire.' | |
441 | ) | |
9536ea21 | 442 | |
577dcb77 EMS |
443 | else: |
444 | # Initialisation d'un formulaire vide | |
445 | if dossier_id: | |
446 | dossier = get_object_or_404(dae.Dossier, pk=dossier_id) | |
447 | employe = dossier.employe | |
448 | data = dict(employe='dae-%s' % employe.id) | |
5a1f75cb EMS |
449 | employe_form = EmployeForm( |
450 | initial=data, instance=employe, request=request | |
451 | ) | |
ed1982f3 NC |
452 | else: |
453 | dossier_rh = rh.Dossier() | |
454 | poste_rh = poste.id_rh | |
577dcb77 EMS |
455 | dossier = pre_filled_dossier(dossier_rh, 'new', poste_rh) |
456 | employe_form = EmployeForm(request=request) | |
457 | ||
458 | dossier_form = DossierForm(instance=dossier) | |
459 | piecesForm = DossierPieceForm(instance=dossier) | |
320d7584 | 460 | comparaisons_formset = DossierComparaisonFormSet( |
5a1f75cb EMS |
461 | queryset=dossier.dae_comparaisons.ma_region_ou_service( |
462 | request.user | |
463 | ) | |
320d7584 | 464 | ) |
577dcb77 EMS |
465 | remunForm = RemunForm(instance=dossier) |
466 | ||
829eb351 | 467 | try: |
5a1f75cb EMS |
468 | comparaisons_internes = \ |
469 | dossier.poste.dae_comparaisons_internes.ma_region_ou_service( | |
470 | request.user | |
471 | ) | |
829eb351 EMS |
472 | except dae.Poste.DoesNotExist: |
473 | comparaisons_internes = [] | |
890b80e7 | 474 | c = { |
577dcb77 EMS |
475 | 'type_remun': filtered_type_remun(), |
476 | 'devises': devises(), | |
477 | 'poste': poste, | |
478 | 'dossier': dossier, | |
479 | 'piecesForm': piecesForm, | |
480 | 'remunForm': remunForm, | |
320d7584 | 481 | 'comparaisons_formset': comparaisons_formset, |
291bbfd9 | 482 | 'forms': dict(employe=employe_form, dossier=dossier_form, ), |
890b80e7 DB |
483 | 'comparaisons_internes': comparaisons_internes, |
484 | } | |
485 | return render(request, 'dae/embauche.html', c) | |
139686f2 | 486 | |
5a1f75cb | 487 | |
5633fa41 | 488 | @dae_groupe_requis |
62d3903d | 489 | @dossier_dans_ma_region_ou_service |
0140cbd2 | 490 | def embauches_liste(request): |
491 | """ Liste des embauches. """ | |
92741270 EMS |
492 | content_type = ContentType.objects.get_for_model(dae.Dossier) |
493 | extra_select = {'derniere_validation': ( | |
494 | "SELECT MAX(date) FROM workflow_workflowcommentaire " | |
5a1f75cb EMS |
495 | "WHERE content_type_id = '%s' AND object_id = dae_dossier.id" % |
496 | content_type.id | |
92741270 | 497 | )} |
5a1f75cb EMS |
498 | embauches_a_traiter = dae.Dossier.objects \ |
499 | .mes_choses_a_faire(request.user) \ | |
92741270 | 500 | .extra(select=extra_select).order_by('-date_creation') |
5a1f75cb EMS |
501 | embauches_en_cours = dae.Dossier.objects \ |
502 | .ma_region_ou_service(request.user) \ | |
503 | .extra(select=extra_select) \ | |
504 | .order_by('-date_creation') \ | |
505 | .exclude(etat=DOSSIER_ETAT_FINALISE) | |
890b80e7 | 506 | c = { |
92741270 EMS |
507 | 'embauches_a_traiter': embauches_a_traiter, |
508 | 'embauches_en_cours': embauches_en_cours, | |
890b80e7 DB |
509 | } |
510 | return render(request, 'dae/embauches_liste.html', c) | |
355c80c8 | 511 | |
5a1f75cb | 512 | |
44055779 EMS |
513 | @dae_groupe_requis |
514 | def embauches_finalisees(request): | |
515 | """Liste des embauches finalisées.""" | |
bed096fc EMS |
516 | |
517 | ### POST | |
518 | ||
519 | if request.method == 'POST': | |
520 | if 'supprimer' in request.POST: | |
521 | ids = request.POST.getlist('ids') | |
522 | dossiers = dae.Dossier.objects.filter(id__in=ids) | |
523 | count = dossiers.count() | |
524 | if count > 0: | |
525 | dossiers.delete() | |
526 | messages.success(request, u'%d dossiers supprimés' % count) | |
527 | return redirect(request.get_full_path()) | |
528 | ||
529 | ### GET | |
530 | ||
44055779 EMS |
531 | embauches = dae.Dossier.objects.ma_region_ou_service(request.user) \ |
532 | .filter(etat=DOSSIER_ETAT_FINALISE) | |
533 | ||
cbfd7bd4 EMS |
534 | # Recherche |
535 | search_form = DAEFinaliseesSearchForm(request.GET) | |
536 | if search_form.is_valid(): | |
537 | q = search_form.cleaned_data.get('q').strip() | |
538 | importees = search_form.cleaned_data.get('importees') | |
539 | if q: | |
540 | criteria = [ | |
541 | Q(poste__implantation__region__nom__icontains=word) | | |
542 | Q(poste__implantation__region__code=word) | | |
543 | Q(poste__implantation__nom__icontains=word) | | |
544 | Q(poste__nom__icontains=word) | | |
545 | Q(employe__nom__icontains=word) | | |
546 | Q(employe__prenom__icontains=word) | |
547 | for word in q.split() | |
548 | ] | |
549 | embauches = embauches.filter(*criteria) | |
550 | if importees == 'oui': | |
551 | embauches = embauches.exclude(dossier_rh=None) | |
552 | elif importees == 'non': | |
553 | embauches = embauches.filter(dossier_rh=None) | |
554 | ||
44055779 EMS |
555 | # Tri |
556 | tri = request.GET.get('tri', None) | |
7652a4c3 | 557 | if tri and tri.startswith('-'): |
44055779 EMS |
558 | dir = '-' |
559 | tri = tri[1:] | |
560 | else: | |
561 | dir = '' | |
562 | if tri == 'region': | |
5a1f75cb EMS |
563 | embauches = embauches.order_by( |
564 | dir + 'poste__implantation__region__nom' | |
565 | ) | |
44055779 EMS |
566 | elif tri == 'implantation': |
567 | embauches = embauches.order_by(dir + 'poste__implantation__nom') | |
568 | elif tri == 'poste': | |
569 | embauches = embauches.order_by(dir + 'poste__nom') | |
570 | elif tri == 'personne': | |
8684fcaa EMS |
571 | embauches = embauches.order_by(dir + 'employe__nom', |
572 | dir + 'employe__prenom') | |
44055779 EMS |
573 | elif tri == 'date_debut': |
574 | embauches = embauches.order_by(dir + 'debut_contrat') | |
575 | elif tri == 'date_fin': | |
576 | embauches = embauches.order_by(dir + 'fin_contrat') | |
577 | ||
578 | # Pagination | |
579 | paginator = Paginator(embauches, 20) | |
580 | try: | |
581 | page = paginator.page(request.GET.get('page', 1)) | |
582 | except InvalidPage: | |
583 | page = paginator.page(1) | |
1b31de9f | 584 | |
890b80e7 | 585 | c = { |
cbfd7bd4 | 586 | 'embauches': page, |
890b80e7 DB |
587 | 'search_form': search_form, |
588 | } | |
589 | return render(request, 'dae/embauches_finalisees.html', c) | |
44055779 | 590 | |
5a1f75cb | 591 | |
139686f2 NC |
592 | def employe(request, key): |
593 | """ Récupération AJAX de l'employé pour la page d'embauche. """ | |
594 | data = dict(employe=key) | |
595 | ||
596 | if key == '': | |
597 | # Nouvel employé | |
598 | employe = dae.Employe() | |
599 | else: | |
600 | # Employé existant | |
601 | source, id = key.split('-') | |
602 | ||
603 | if source == 'dae': | |
604 | employe = get_object_or_404(dae.Employe, pk=id) | |
605 | elif source == 'rh': | |
606 | e = get_object_or_404(rh.Employe, id=id) | |
607 | # Initialisation avec les valeurs de l'employé de rh_v1 | |
608 | employe = dae.Employe(id_rh=e) | |
609 | for field in ('prenom', 'nom', 'genre'): | |
610 | setattr(employe, field, getattr(e, field)) | |
611 | ||
5a1f75cb EMS |
612 | return HttpResponse( |
613 | EmployeForm(initial=data, instance=employe, request=request).as_table() | |
614 | ) | |
615 | ||
139686f2 | 616 | |
9536ea21 EMS |
617 | ### CONTRATS |
618 | ||
619 | @dae_groupe_requis | |
620 | @get_contrat | |
67a94eaf EMS |
621 | def contrat(request, contrat, filename): |
622 | return sendfile(request, contrat.fichier.path) | |
9536ea21 | 623 | |
5a1f75cb | 624 | |
9536ea21 EMS |
625 | @dae_groupe_requis |
626 | @get_contrat | |
627 | def contrat_supprimer(request, contrat): | |
628 | if request.method == 'POST': | |
629 | if 'oui' in request.POST: | |
630 | contrat.delete() | |
631 | return redirect('embauche_consulter', dossier_id=contrat.dossier.id) | |
890b80e7 DB |
632 | c = { |
633 | 'contrat': contrat, | |
634 | } | |
635 | return render(request, 'dae/contrat-supprimer.html', c) | |
9536ea21 | 636 | |
5a1f75cb | 637 | |
9536ea21 EMS |
638 | @dae_groupe_requis |
639 | @dossier_dans_ma_region_ou_service | |
640 | def embauche_ajouter_contrat(request, dossier_id=None): | |
641 | dossier = get_object_or_404(dae.Dossier, pk=dossier_id) | |
642 | if request.method == 'POST': | |
643 | form = ContratForm(request.POST, request.FILES) | |
644 | if form.is_valid(): | |
645 | contrat = form.save(commit=False) | |
646 | contrat.dossier = dossier | |
9dfa4296 OL |
647 | contrat.date_debut = dossier.contrat_date_debut |
648 | contrat.date_fin = dossier.contrat_date_fin | |
9536ea21 EMS |
649 | contrat.save() |
650 | return redirect('embauche_consulter', dossier_id=dossier.id) | |
651 | else: | |
652 | form = ContratForm() | |
1b31de9f | 653 | |
890b80e7 DB |
654 | c = { |
655 | 'form': form, | |
656 | } | |
657 | return render(request, 'dae/embauche-ajouter-contrat.html', c) | |
9536ea21 | 658 | |
5a1f75cb | 659 | |
c3f0b49f EMS |
660 | ### DAE NUMERISEE |
661 | ||
662 | @get_object(dae.Dossier, 'consulter') | |
663 | def dae_numerisee(request, dossier): | |
664 | return sendfile(request, dossier.dae_numerisee.path) | |
665 | ||
5a1f75cb | 666 | |
c3f0b49f EMS |
667 | @get_object(dae.Dossier, 'modifier_dae_numerisee') |
668 | def dae_numerisee_modifier(request, dossier): | |
669 | if request.method == 'POST': | |
670 | form = DAENumeriseeForm(request.POST, request.FILES, instance=dossier) | |
671 | if form.is_valid(): | |
672 | form.save() | |
673 | return redirect('embauche_consulter', dossier_id=dossier.id) | |
674 | else: | |
675 | form = DAENumeriseeForm(instance=dossier) | |
1b31de9f | 676 | |
890b80e7 DB |
677 | c = { |
678 | 'form': form, | |
679 | } | |
680 | return render(request, 'dae/dae_numerisee_modifier.html', c) | |
c3f0b49f | 681 | |
5a1f75cb | 682 | |
c3f0b49f EMS |
683 | @get_object(dae.Dossier, 'modifier_dae_numerisee') |
684 | def dae_numerisee_supprimer(request, dossier): | |
685 | if request.method == 'POST': | |
686 | if 'oui' in request.POST: | |
687 | dossier.dae_numerisee = None | |
688 | dossier.save() | |
689 | return redirect('embauche_consulter', dossier_id=dossier.id) | |
890b80e7 | 690 | return render(request, 'dae/dae_numerisee_supprimer.html', {}) |
5a1f75cb | 691 | |
c3f0b49f | 692 | |
04380fba | 693 | # AJAX SECURISE |
5a1f75cb | 694 | |
04380fba OL |
695 | @dae_groupe_requis |
696 | @employe_dans_ma_region_ou_service | |
139686f2 NC |
697 | def dossier(request, poste_key, employe_key): |
698 | """ Récupération AJAX du dossier pour la page d'embauche. """ | |
699 | data = dict() | |
700 | ||
701 | poste_source, poste_id = poste_key.split('-') | |
702 | poste = get_object_or_404(dae.Poste, pk=poste_id) | |
179f6b49 OL |
703 | |
704 | # Récupérer la devise de l'implantation lié au poste | |
705 | implantation_devise = poste.get_default_devise() | |
5a1f75cb | 706 | data.update({'devise': implantation_devise}) |
9536ea21 | 707 | |
e27db04c OL |
708 | if poste.id_rh_id is not None: |
709 | poste_rh = get_object_or_404(rh.Poste, pk=poste.id_rh_id) | |
710 | else: | |
711 | poste_rh = None | |
139686f2 | 712 | |
eabaed81 | 713 | # NOUVEL EMPLOYE |
139686f2 NC |
714 | if employe_key == '': |
715 | employe_source = 'new' | |
eabaed81 | 716 | employe = None |
139686f2 | 717 | dossier_rh = rh.Dossier() |
ed1982f3 | 718 | dossier = pre_filled_dossier(dossier_rh, employe_source, poste_rh) |
139686f2 | 719 | |
eabaed81 | 720 | # EMPLOYE DAE |
eabaed81 | 721 | if employe_key.startswith('dae'): |
5a1f75cb EMS |
722 | employe_source, employe_id = employe_key.split('-') |
723 | employe_dae = get_object_or_404(dae.Employe, pk=employe_id) | |
724 | ||
725 | # récupération de l'ancien dossier rh v1 pour l'employe DAE | |
726 | try: | |
727 | dossier_rh = rh.Dossier.objects.get( | |
728 | employe=employe_dae.id_rh_id, date_fin=None | |
729 | ) | |
730 | except (rh.Dossier.DoesNotExist): | |
731 | dossier_rh = rh.Dossier() | |
732 | ||
733 | # on tente de récupérer le dossier DAE, au pire on le contruit en le | |
734 | # prépoluant avec son dossier rh v1. | |
735 | try: | |
736 | dossier = dae.Dossier.objects.get(employe=employe_dae, poste=poste) | |
737 | except (dae.Dossier.DoesNotExist): | |
738 | dossier = pre_filled_dossier(dossier_rh, employe_source, poste_rh) | |
739 | employe = employe_dae.id_rh | |
740 | ||
eabaed81 | 741 | # EMPLOYE RH v1 |
eabaed81 | 742 | if employe_key.startswith('rh'): |
5a1f75cb EMS |
743 | employe_source, employe_id = employe_key.split('-') |
744 | employe_rh = get_object_or_404(rh.Employe, pk=employe_id) | |
745 | ||
746 | # récupération de l'ancien dossier rh v1 pour l'employe rh v1, s'il | |
747 | # n'en a pas, on en fournit un nouveau qui servira uniquement un | |
748 | # créer un nouveau dossier DAE. | |
749 | try: | |
750 | dossier_rh = rh.Dossier.objects.get( | |
751 | employe=employe_rh, date_fin=None | |
752 | ) | |
753 | except (rh.Dossier.DoesNotExist): | |
754 | dossier_rh = rh.Dossier() | |
755 | dossier = pre_filled_dossier(dossier_rh, employe_source, poste_rh) | |
756 | employe = employe_rh | |
da3ca955 | 757 | |
eabaed81 OL |
758 | dossier_form = DossierForm(initial=data, instance=dossier) |
759 | vars = dict(form=dossier_form, poste=poste, employe=employe) | |
890b80e7 | 760 | return render(request, 'dae/embauche-dossier.html', vars) |
139686f2 | 761 | |
5a1f75cb EMS |
762 | |
763 | # Cette fonction est appelée à partir de fonctions déjà sécurisée | |
ed1982f3 NC |
764 | def pre_filled_dossier(dossier_rh, employe_source, poste_rh): |
765 | dossier = dae.Dossier() | |
766 | ||
767 | if employe_source != 'new' and dossier_rh.id: | |
768 | dossier.statut_anterieur = dossier_rh.statut | |
769 | ||
770 | # Certains dossiers ont un classement à zéro | |
771 | if dossier_rh.classement_id > 0: | |
772 | dossier.classement_anterieur = dossier_rh.classement | |
773 | ||
774 | # Récupération du salaire de base | |
5a1f75cb EMS |
775 | remun = dossier_rh.remunerations() \ |
776 | .filter(type=1).order_by('-date_debut') | |
ed1982f3 NC |
777 | if remun: |
778 | dossier.salaire_anterieur = remun[0].montant | |
80bcc96b | 779 | dossier.devise_anterieur = remun[0].devise |
ed1982f3 NC |
780 | |
781 | # Récupération du titulaire précédent | |
782 | try: | |
09aa8374 | 783 | dossiers = rh.Dossier.objects.order_by('-date_debut') |
32f26ff3 | 784 | if poste_rh: |
09aa8374 | 785 | dossiers = dossiers.filter(poste=poste_rh) |
32f26ff3 AJ |
786 | else: |
787 | dossiers = rh.Dossier.objects.none() | |
ed1982f3 NC |
788 | if len(dossiers): |
789 | # Ce bloc ignore toutes les erreurs, car les données de rh | |
790 | # manquantes peuvent en générer | |
791 | d = dossiers[0] | |
792 | try: | |
793 | titulaire = d.employe | |
794 | dossier.employe_anterieur = titulaire | |
795 | dossier.classement_titulaire_anterieur = d.classement | |
796 | dossier.statut_titulaire_anterieur = d.statut | |
5a1f75cb EMS |
797 | remun = d.remunerations().filter(type=1) \ |
798 | .order_by('-date_debut')[0] | |
80bcc96b OL |
799 | dossier.salaire_titulaire_anterieur = remun.montant |
800 | dossier.devise_titulaire_anterieur = remun.devise | |
ed1982f3 NC |
801 | except: |
802 | pass | |
803 | # TODO: afficher l'info, les champs ne sont pas dans le | |
804 | # modèle dae.Dossier: nom, prenom, classement, salaire | |
805 | pass | |
806 | ||
807 | except (rh.Dossier.DoesNotExist): | |
808 | dossier_rh = rh.Dossier() | |
809 | ||
810 | return dossier | |
811 | ||
5a1f75cb | 812 | |
04380fba | 813 | @dae_groupe_requis |
c0492570 | 814 | @vieux_dossier_dans_ma_region_ou_service |
04380fba | 815 | def dossier_resume(request, dossier_id=None): |
04380fba OL |
816 | try: |
817 | dossier = rh.Dossier.objects.get(id=dossier_id) | |
818 | except: | |
819 | return HttpResponseGone("Ce dossier n'est pas accessible") | |
f87fe1a1 | 820 | |
04380fba OL |
821 | data = {} |
822 | data['personne'] = unicode(dossier.employe) | |
0ebb99b3 | 823 | data['classement'] = dossier.classement.id |
09aa8374 OL |
824 | if dossier.statut is not None: |
825 | data['statut'] = dossier.statut.id | |
826 | data['implantation'] = dossier.poste.implantation.id | |
5a1f75cb EMS |
827 | data['poste'] = u"%s %s" % ( |
828 | dossier.poste.type_poste.nom, dossier.poste.nom | |
829 | ) | |
09aa8374 | 830 | salaire = dossier.get_salaire() |
a4125771 | 831 | if salaire is not None: |
5a64aab4 | 832 | data['montant'] = float(salaire.montant) |
a4125771 OL |
833 | else: |
834 | data['montant'] = None | |
835 | if salaire is not None and salaire.devise is not None: | |
10b6780c | 836 | data['devise'] = salaire.devise.id |
e84c8ef1 | 837 | data['montant_euros'] = salaire.montant_euros() |
f87fe1a1 | 838 | else: |
04380fba OL |
839 | data['devise'] = None |
840 | data['montant_euros'] = 0 | |
85668061 | 841 | return HttpResponse(dumps(data)) |
f87fe1a1 | 842 | |
5a1f75cb | 843 | |
068d1462 OL |
844 | @dae_groupe_requis |
845 | @vieux_dossier_dans_ma_region_ou_service | |
846 | def poste_resume(request, dossier_id=None): | |
847 | """ | |
848 | On travaille, en réalité sur le dossier mais on cache | |
849 | l'identité de la personne. | |
850 | """ | |
851 | try: | |
852 | dossier = rh.Dossier.objects.get(id=dossier_id) | |
853 | except: | |
854 | return HttpResponseGone("Ce dossier n'est pas accessible") | |
855 | ||
3f5cbabe | 856 | salaire = dossier.get_salaire() |
068d1462 | 857 | data = {} |
09aa8374 | 858 | data['implantation'] = dossier.poste.implantation.id |
5a1f75cb EMS |
859 | data['poste'] = u"%s %s" % ( |
860 | dossier.poste.type_poste.nom, dossier.poste.nom | |
861 | ) | |
068d1462 OL |
862 | if salaire is not None: |
863 | data['devise'] = salaire.devise.id | |
e503e64d | 864 | data['montant'] = float(salaire.montant) |
e84c8ef1 | 865 | data['montant_euros'] = salaire.montant_euros() |
068d1462 OL |
866 | else: |
867 | data['devise'] = None | |
e503e64d OL |
868 | data['montant'] = "" |
869 | data['montant_euros'] = "" | |
5d84008f OL |
870 | data['statut'] = dossier.statut_id |
871 | data['classement'] = dossier.classement_id | |
068d1462 OL |
872 | return HttpResponse(dumps(data)) |
873 | ||
5a1f75cb | 874 | |
6d047148 | 875 | def liste_postes(request): |
8684fcaa | 876 | """ Appel AJAX : |
6d047148 OL |
877 | input : implantation_id |
878 | output : JSON liste de valeur point | |
879 | """ | |
880 | method = request.method | |
881 | params = getattr(request, method, []) | |
882 | data = [] | |
883 | ||
884 | # Voir le code de _poste_choices dans forms.py | |
5a1f75cb EMS |
885 | copies = dae.Poste.objects.exclude(id_rh__isnull=True) \ |
886 | .filter(etat=POSTE_ETAT_FINALISE) | |
aa512122 | 887 | rh_postes_actifs = rh.Poste.objects.all() |
6d047148 | 888 | |
5a1f75cb EMS |
889 | if 'implantation_id' in params \ |
890 | and params.get('implantation_id') is not u"": | |
6d047148 | 891 | implantation_id = params.get('implantation_id') |
6d047148 | 892 | copies = copies.filter(implantation__id=implantation_id) |
5a1f75cb EMS |
893 | rh_postes_actifs = rh_postes_actifs.filter( |
894 | implantation__id=implantation_id | |
895 | ) | |
9536ea21 | 896 | |
6d047148 OL |
897 | id_copies = [p.id_rh_id for p in copies.all()] |
898 | rhv1 = rh_postes_actifs.exclude(id__in=id_copies) | |
899 | rhv1 = rhv1.select_related(depth=1) | |
4bce4d24 | 900 | |
5a1f75cb EMS |
901 | data = [('', 'Nouveau poste')] + \ |
902 | sorted([('rh-%s' % p.id, label_poste_display(p)) for p in rhv1], | |
903 | key=lambda t: t[1]) | |
6d047148 OL |
904 | return HttpResponse(dumps(data)) |
905 | ||
5a1f75cb | 906 | |
e3563bcf | 907 | @login_required |
67a94eaf | 908 | def dossier_piece(request, id, filename): |
e3563bcf EMS |
909 | """Téléchargement d'une pièce jointe à un poste.""" |
910 | piece = get_object_or_404(dae.DossierPiece, pk=id) | |
5a1f75cb EMS |
911 | if dae.Dossier.objects.ma_region_ou_service(request.user) \ |
912 | .filter(id=piece.dossier_id).exists(): | |
67a94eaf | 913 | return sendfile(request, piece.fichier.path) |
e3563bcf EMS |
914 | else: |
915 | return redirect_interdiction(request) | |
916 | ||
5a1f75cb | 917 | |
04380fba | 918 | # AJAX SECURITE non nécessaire |
5a1f75cb | 919 | |
04380fba | 920 | def coefficient(request): |
9536ea21 | 921 | """ Appel AJAX : |
04380fba OL |
922 | input : classement |
923 | output : coefficient | |
924 | """ | |
925 | method = request.method | |
926 | params = getattr(request, method, []) | |
927 | data = dict() | |
928 | if 'classement' in params and params.get('classement') is not u"": | |
929 | classement = params.get('classement') | |
930 | classement = rh.Classement.objects.get(pk=classement) | |
931 | data['coefficient'] = classement.coefficient | |
932 | else: | |
933 | data['coefficient'] = 0 | |
934 | return HttpResponse(dumps(data)) | |
935 | ||
936 | ||
3d627bfd | 937 | def devise(request): |
8684fcaa | 938 | """ Appel AJAX : |
3d627bfd | 939 | input : valeur_point |
8e30e17f | 940 | output : devise, devise_code, taux_euro |
3d627bfd | 941 | """ |
f87fe1a1 OL |
942 | method = request.method |
943 | params = getattr(request, method, []) | |
3d627bfd | 944 | data = dict() |
8684fcaa | 945 | if 'valeur_point' in params and params.get('valeur_point') is not u"": |
f87fe1a1 | 946 | valeur_point = params.get('valeur_point') |
3d627bfd | 947 | valeur_point = rh.ValeurPoint.objects.get(pk=valeur_point) |
948 | annee = valeur_point.annee | |
3f5cbabe | 949 | try: |
5a1f75cb EMS |
950 | taux = rh.TauxChange.objects.get( |
951 | annee=annee, devise=valeur_point.devise | |
952 | ) | |
3f5cbabe | 953 | except MultipleObjectsReturned: |
5a1f75cb EMS |
954 | return HttpResponseGone( |
955 | u"Il existe plusieurs taux pour la devise %s " | |
956 | u"cette année-là : %s" % (valeur_point.devise.code, annee) | |
957 | ) | |
3f5cbabe | 958 | |
3d627bfd | 959 | data['devise'] = taux.devise.id |
f87fe1a1 | 960 | data['valeur'] = valeur_point.valeur |
3d627bfd | 961 | data['devise_code'] = taux.devise.code |
8e30e17f | 962 | data['taux_euro'] = taux.taux |
be3c51e9 OL |
963 | else: |
964 | return HttpResponseGone("Vous devez choisir une valeur de point") | |
3d627bfd | 965 | return HttpResponse(dumps(data)) |
9536ea21 | 966 | |
5a1f75cb | 967 | |
3d627bfd | 968 | def devise_code(request): |
8684fcaa | 969 | """ Appel AJAX : |
3d627bfd | 970 | input : devise |
8e30e17f | 971 | output : devise_code, taux_euro |
3d627bfd | 972 | """ |
f87fe1a1 OL |
973 | method = request.method |
974 | params = getattr(request, method, []) | |
3d627bfd | 975 | data = dict() |
f87fe1a1 OL |
976 | if 'devise' in params: |
977 | devise = params.get('devise') | |
3d627bfd | 978 | devise = rh.Devise.objects.get(pk=devise) |
8e30e17f | 979 | annee = date.today().year |
980 | taux = rh.TauxChange.objects.filter(annee=annee, devise=devise) | |
86f1e48d OL |
981 | if len(taux) == 0: |
982 | return HttpResponseGone("Le taux n'est pas disponible") | |
3d627bfd | 983 | data['devise_code'] = devise.code |
8e30e17f | 984 | data['taux_euro'] = taux[0].taux |
3d627bfd | 985 | return HttpResponse(dumps(data)) |
85668061 | 986 | |
5a1f75cb | 987 | |
cb1d62b5 NC |
988 | def add_remun(request, dossier, type_remun): |
989 | dossier = get_object_or_404(dae.Dossier, pk=dossier) | |
990 | type_remun = get_object_or_404(rh.TypeRemuneration, pk=type_remun) | |
991 | dae.Remuneration(dossier=dossier, devise=dossier.devise, | |
992 | type=type_remun).save() | |
993 | ||
890b80e7 DB |
994 | c = { |
995 | 'dossier': dossier, | |
996 | } | |
997 | return render(request, 'dae/embauche-remun.html', c) | |
03b395db | 998 | |
5a1f75cb | 999 | |
04380fba OL |
1000 | def salaire(request, implantation, devise, classement): |
1001 | if not devise or not classement: | |
1002 | raise Http404 | |
1003 | ||
04380fba | 1004 | taux = rh.TauxChange.objects.filter(devise=devise).order_by('-annee') |
5a1f75cb EMS |
1005 | vp = rh.ValeurPoint.objects \ |
1006 | .filter(implantation=implantation, devise=devise) \ | |
1007 | .order_by('-annee') | |
aa512122 OL |
1008 | |
1009 | if vp.count() == 0: | |
1010 | raise Exception(u"pas de valeur de point pour le couple\ | |
1011 | implantation/devise (%s/%s)" % (implantation, devise)) | |
1012 | ||
1013 | if taux.count() == 0: | |
1014 | raise Exception(u"Pas de taux pour la devise %s" % devise) | |
04380fba OL |
1015 | |
1016 | classement = get_object_or_404(rh.Classement, pk=classement) | |
e2968ebb EMS |
1017 | if classement.coefficient is None: |
1018 | raise Http404 | |
90716392 | 1019 | taux, vp = taux[0].taux, vp[0].valeur |
04380fba | 1020 | |
90716392 | 1021 | salaire_euro = round(vp * classement.coefficient * taux, 2) |
04380fba OL |
1022 | data = dict(salaire_euro=salaire_euro, taux=taux, |
1023 | salaire_devise=round(salaire_euro / taux, 2)) | |
1024 | ||
1025 | return HttpResponse(dumps(data)) | |
1026 | ||
5a1f75cb | 1027 | |
04380fba | 1028 | def liste_valeurs_point(request): |
8684fcaa | 1029 | """ Appel AJAX : |
04380fba OL |
1030 | input : implantation_id |
1031 | output : JSON liste de valeur point | |
03b395db | 1032 | """ |
04380fba OL |
1033 | method = request.method |
1034 | params = getattr(request, method, []) | |
1035 | data = [] | |
1036 | annee_courante = datetime.datetime.now().year | |
5a1f75cb EMS |
1037 | if 'implantation_id' in params \ |
1038 | and params.get('implantation_id') is not u"": | |
04380fba | 1039 | implantation_id = params.get('implantation_id') |
5a1f75cb EMS |
1040 | preselectionne = rh.ValeurPoint.objects \ |
1041 | .filter(implantation=implantation_id, annee=annee_courante) \ | |
1042 | .order_by("-annee") | |
7ad0549c | 1043 | for o in preselectionne: |
5a1f75cb EMS |
1044 | data.append({ |
1045 | 'id': o.id, | |
1046 | 'label': o.__unicode__(), | |
1047 | 'devise': o.devise_id, | |
1048 | 'suggestion': True | |
1049 | }) | |
b1f7765e | 1050 | else: |
7ad0549c OL |
1051 | preselectionne = rh.ValeurPoint.objects.none() |
1052 | ||
5a1f75cb EMS |
1053 | liste_complete = rh.ValeurPoint.objects \ |
1054 | .filter(annee__in=(annee_courante,)) \ | |
1055 | .order_by("-annee") | |
7ad0549c | 1056 | for o in liste_complete.exclude(id__in=[p.id for p in preselectionne]): |
5a1f75cb EMS |
1057 | data.append({ |
1058 | 'id': o.id, | |
1059 | 'label': o.__unicode__(), | |
1060 | 'devise': o.devise_id, | |
1061 | 'suggestion': False | |
1062 | }) | |
3f5cbabe | 1063 | return HttpResponse(dumps(data, indent=4)) |