Commit | Line | Data |
---|---|---|
5d680e84 | 1 | # -*- encoding: utf-8 -*- |
f87fe1a1 | 2 | |
cea09938 | 3 | from datetime import date, datetime |
139686f2 | 4 | |
cea09938 | 5 | from auf.django.permissions.decorators import get_object |
5a1f75cb | 6 | from django.contrib import messages |
7f432a0b | 7 | from django.contrib.auth.decorators import login_required, user_passes_test |
5a1f75cb | 8 | from django.contrib.contenttypes.models import ContentType |
3f5cbabe | 9 | from django.core.exceptions import MultipleObjectsReturned |
44055779 | 10 | from django.core.paginator import Paginator, InvalidPage |
5a1f75cb | 11 | from django.db.models import Q |
86f1e48d | 12 | from django.http import Http404, HttpResponse, HttpResponseGone |
890b80e7 | 13 | from django.shortcuts import redirect, render, get_object_or_404 |
e3563bcf | 14 | from sendfile import sendfile |
cea09938 | 15 | from simplejson import dumps |
75f0e87b | 16 | |
5a1f75cb EMS |
17 | from project.dae import models as dae |
18 | from project.dae.decorators import \ | |
acbc95a1 | 19 | dae_groupe_requis, \ |
8684fcaa EMS |
20 | poste_dans_ma_region_ou_service, \ |
21 | dossier_dans_ma_region_ou_service, \ | |
22 | vieux_dossier_dans_ma_region_ou_service, \ | |
23 | employe_dans_ma_region_ou_service, \ | |
24 | dossier_est_modifiable, \ | |
25 | poste_est_modifiable, get_contrat | |
874949f3 OL |
26 | from project.dae.forms import FinancementFormSet, FinancementFormSetInitial |
27 | from project.dae.forms import PosteComparaisonFormSet, PosteComparaisonFormSetInitial | |
5a1f75cb | 28 | from project.dae.forms import \ |
874949f3 OL |
29 | PosteWorkflowForm, PosteForm, PostePieceFormSet, \ |
30 | DossierWorkflowForm, ChoosePosteForm, \ | |
5a1f75cb EMS |
31 | EmployeForm, DossierForm, DossierPieceForm, \ |
32 | DossierComparaisonFormSet, RemunForm, ContratForm, DAENumeriseeForm, \ | |
cbfd7bd4 | 33 | label_poste_display, DAEFinaliseesSearchForm |
5a1f75cb EMS |
34 | from project.dae.mail import send_drh_finalisation_mail |
35 | from project.dae.workflow import \ | |
36 | DOSSIER_ETAT_FINALISE, DOSSIER_ETAT_REGION_FINALISATION, \ | |
37 | DOSSIER_ETAT_DRH_FINALISATION, POSTE_ETAT_FINALISE | |
580630f0 EMS |
38 | from project.decorators import \ |
39 | redirect_interdiction, drh_or_admin_required, in_drh_or_admin | |
5a1f75cb | 40 | from project.rh import models as rh |
8684fcaa | 41 | |
ed1982f3 | 42 | |
cea09938 EMS |
43 | # Helpers |
44 | ||
0a085c42 OL |
45 | def devises(): |
46 | liste = [] | |
47 | for d in rh.Devise.objects.all(): | |
48 | annee = date.today().year | |
49 | taux = rh.TauxChange.objects.filter(annee=annee, devise=d) | |
50 | data = {} | |
51 | if len(taux) == 0: | |
52 | data['taux_euro'] = 0 | |
53 | else: | |
54 | data['taux_euro'] = taux[0].taux | |
378ffe6c | 55 | data['devise_code'] = d.id |
0a085c42 OL |
56 | liste.append(data) |
57 | return liste | |
58 | ||
5a1f75cb | 59 | |
5633fa41 | 60 | @dae_groupe_requis |
5d680e84 | 61 | def index(request): |
890b80e7 | 62 | return render(request, 'dae/index.html', {}) |
5d680e84 | 63 | |
e3563bcf EMS |
64 | |
65 | ### POSTE | |
66 | ||
5633fa41 OL |
67 | @dae_groupe_requis |
68 | @poste_dans_ma_region_ou_service | |
c0413a6f OL |
69 | def poste_consulter(request, key): |
70 | source, id = key.split('-') | |
71 | poste = get_object_or_404(dae.Poste, pk=id) | |
8684fcaa | 72 | |
e6f52402 | 73 | if request.POST: |
5a1f75cb EMS |
74 | validationForm = PosteWorkflowForm( |
75 | request.POST, instance=poste, request=request | |
76 | ) | |
e6f52402 | 77 | if validationForm.is_valid(): |
5a1f75cb EMS |
78 | messages.add_message( |
79 | request, messages.SUCCESS, "La validation a été enregistrée." | |
80 | ) | |
18c6d4c0 | 81 | return redirect('dae_postes_liste') |
e6f52402 OL |
82 | else: |
83 | validationForm = PosteWorkflowForm(instance=poste, request=request) | |
8684fcaa | 84 | |
5a1f75cb EMS |
85 | comparaisons_internes = \ |
86 | poste.dae_comparaisons_internes.ma_region_ou_service(request.user) | |
580630f0 | 87 | return render(request, 'dae/poste_consulter.html', { |
1de3da13 EMS |
88 | 'poste': poste, |
89 | 'validationForm': validationForm, | |
580630f0 EMS |
90 | 'comparaisons_internes': comparaisons_internes, |
91 | 'importer': in_drh_or_admin(request.user) | |
92 | }) | |
868a9322 | 93 | |
5a1f75cb | 94 | |
c0413a6f | 95 | |
580630f0 | 96 | @drh_or_admin_required |
6fcc7644 EMS |
97 | def poste_importer(request, id): |
98 | poste_dae = get_object_or_404(dae.Poste, id=id) | |
99 | if request.method == 'POST': | |
100 | if 'confirmer' in request.POST: | |
101 | poste_rh = poste_dae.importer_dans_rh() | |
102 | return redirect('admin:rh_poste_change', poste_rh.id) | |
103 | else: | |
104 | return redirect('poste_consulter', 'dae-' + id) | |
105 | else: | |
890b80e7 DB |
106 | c = { |
107 | 'poste': poste_dae, | |
108 | } | |
109 | return render(request, 'dae/poste_importer.html', c) | |
6fcc7644 EMS |
110 | |
111 | ||
5633fa41 | 112 | @dae_groupe_requis |
1b217058 | 113 | @poste_dans_ma_region_ou_service |
6e80b20c | 114 | @poste_est_modifiable |
3ed49093 | 115 | def poste(request, key=None): |
5d680e84 NC |
116 | """ Formulaire pour un poste. |
117 | ||
118 | Permet de créer ou modifier un poste. Si le poste n'existe que dans rh_v1 | |
119 | il est automatiquement copié dans dae. | |
120 | ||
121 | """ | |
874949f3 OL |
122 | |
123 | def _dupliquer_poste(poste_dae, poste_rh): | |
124 | """ | |
125 | Recopie les fields d'un poste RH dans un poste DAE | |
126 | avec ceux-ci précédemment crées | |
127 | """ | |
128 | exclus = ('id', 'supprime', 'date_creation', | |
129 | 'user_creation', 'date_modification', | |
130 | 'user_modification', ) | |
131 | fields = [f for f in poste_rh._meta.fields if f.name not in exclus] | |
132 | for field in fields: | |
133 | setattr(poste_dae, field.name, getattr(poste_rh, field.name)) | |
134 | return poste_dae | |
135 | ||
5d680e84 NC |
136 | poste, data, vars = None, dict(), dict() |
137 | ||
874949f3 OL |
138 | # Sans key, c'est un nouveau poste |
139 | if key is None: | |
140 | new = True | |
141 | else: | |
142 | new = False | |
143 | ||
73516366 OL |
144 | # Type intervention |
145 | if 'type_intervention' in request.GET: | |
146 | data['type_intervention'] = request.GET['type_intervention'] | |
147 | ||
874949f3 OL |
148 | # Poste existant |
149 | poste_rh = None | |
150 | if not new: | |
139686f2 | 151 | source, id = key.split('-') |
5d680e84 | 152 | |
139686f2 | 153 | if source == 'dae': |
5d680e84 | 154 | poste = get_object_or_404(dae.Poste, pk=id) |
73516366 | 155 | data['poste'] = key |
139686f2 | 156 | elif source == 'rh': |
2e672700 | 157 | poste_rh = get_object_or_404(rh.Poste, pk=id) |
2e672700 | 158 | poste = dae.Poste(id_rh=poste_rh) |
874949f3 OL |
159 | # Initialisation avec les valeurs du poste de rh_v1 |
160 | poste = _dupliquer_poste(poste, poste_rh) | |
73516366 | 161 | data['poste'] = 'rh-' + str(poste.id_rh_id) |
5d680e84 | 162 | |
2e672700 | 163 | # prépopuler pour la modification de poste |
874949f3 OL |
164 | if poste_rh is not None: |
165 | FinancementForm = FinancementFormSetInitial | |
166 | PosteComparaisonForm = PosteComparaisonFormSetInitial | |
2e672700 | 167 | |
2e672700 OL |
168 | qs_financements = poste_rh.rh_financements.all() |
169 | qs_comparaisons = poste_rh.rh_comparaisons_internes.all() | |
874949f3 OL |
170 | financements = [{'type': f.type, 'pourcentage': f.pourcentage, |
171 | 'commentaire': f.commentaire} for f in qs_financements] | |
172 | comparaisons = [{'implantation': c.implantation, 'nom': c.nom, | |
173 | 'montant': c.montant, 'devise': c.devise} for c in qs_comparaisons] | |
174 | # formulaires normaux, avec modifications des objects FK | |
175 | else: | |
176 | FinancementForm = FinancementFormSet | |
177 | PosteComparaisonForm = PosteComparaisonFormSet | |
178 | financements = [] | |
179 | comparaisons = [] | |
2e672700 OL |
180 | |
181 | ||
5d680e84 | 182 | if request.POST: |
3ed49093 | 183 | data.update(dict(request.POST.items())) |
f258e4e7 | 184 | form = PosteForm(data, instance=poste, request=request) |
874949f3 OL |
185 | financementForm = FinancementForm(request.POST, instance=poste, ) |
186 | piecesForm = PostePieceFormSet(request.POST, request.FILES, instance=poste, ) | |
187 | comparaisons_formset = PosteComparaisonForm( | |
c4bfc2a0 | 188 | request.POST, |
874949f3 | 189 | instance=poste, |
c4bfc2a0 | 190 | ) |
5a1f75cb EMS |
191 | if form.is_valid() and piecesForm.is_valid() and \ |
192 | financementForm.is_valid() and comparaisons_formset.is_valid(): | |
5d680e84 | 193 | poste = form.save() |
eb8c3edb OL |
194 | piecesForm.instance = poste |
195 | piecesForm.save() | |
151e7bd0 OL |
196 | financementForm.instance = poste |
197 | financementForm.save() | |
320d7584 EMS |
198 | |
199 | # Ne remplacer que les comparaisons de ma région | |
200 | comparaisons = comparaisons_formset.save(commit=False) | |
201 | for comparaison in comparaisons: | |
202 | comparaison.poste = poste | |
203 | comparaison.save() | |
204 | ||
2e672700 OL |
205 | # dans le cas d'une modification de poste de RH, on recopie les PJ |
206 | if poste_rh is not None: | |
207 | for piece in poste_rh.rh_pieces.all(): | |
208 | dae.PostePiece(poste=poste, nom=piece.nom, | |
209 | fichier=piece.fichier).save() | |
5a1f75cb EMS |
210 | messages.add_message( |
211 | request, messages.SUCCESS, | |
212 | "Le poste %s a été sauvegardé." % poste | |
213 | ) | |
214 | if 'save' in request.POST: | |
5bc760f9 OL |
215 | return redirect('poste_consulter', key='dae-%s' % poste.id) |
216 | else: | |
217 | return redirect('poste', key='dae-%s' % poste.id) | |
8684fcaa | 218 | |
9cb4de55 | 219 | else: |
5a1f75cb EMS |
220 | messages.add_message( |
221 | request, messages.ERROR, | |
222 | 'Il y a des erreurs dans le formulaire.' | |
223 | ) | |
8684fcaa | 224 | |
5d680e84 NC |
225 | else: |
226 | # 'initial' évite la validation prémature lors d'une copie de poste de | |
227 | # rh_v1 vers dae. | |
f258e4e7 | 228 | form = PosteForm(initial=data, instance=poste, request=request) |
874949f3 | 229 | piecesForm = PostePieceFormSet(instance=poste) |
2e672700 | 230 | |
874949f3 OL |
231 | if poste_rh is not None: |
232 | financementForm = FinancementForm(initial=financements, instance=poste) | |
233 | comparaisons_formset = PosteComparaisonForm( | |
2e672700 | 234 | initial=comparaisons, |
874949f3 | 235 | instance=poste, |
829eb351 | 236 | ) |
874949f3 | 237 | # cas de la création d'un nouveau poste |
829eb351 | 238 | else: |
874949f3 OL |
239 | financementForm = FinancementForm(instance=poste) |
240 | comparaisons_formset = PosteComparaisonForm(instance=poste) | |
5d680e84 | 241 | |
320d7584 EMS |
242 | vars.update(dict( |
243 | form=form, poste=poste, poste_key=key, piecesForm=piecesForm, | |
244 | financementForm=financementForm, | |
2e672700 OL |
245 | comparaisons_formset=comparaisons_formset, |
246 | poste_rh=poste_rh, | |
320d7584 | 247 | )) |
5d680e84 | 248 | |
890b80e7 | 249 | return render(request, 'dae/poste.html', vars) |
3ed49093 | 250 | |
5a1f75cb | 251 | |
5633fa41 | 252 | @dae_groupe_requis |
498881f4 | 253 | def postes_liste(request): |
0f23302a | 254 | """ Liste des postes. """ |
92741270 EMS |
255 | content_type = ContentType.objects.get_for_model(dae.Poste) |
256 | extra_select = {'derniere_validation': ( | |
257 | "SELECT MAX(date) FROM workflow_workflowcommentaire " | |
5a1f75cb EMS |
258 | "WHERE content_type_id = '%s' AND object_id = dae_poste.id" % |
259 | content_type.id | |
92741270 EMS |
260 | )} |
261 | postes_a_traiter = dae.Poste.objects.mes_choses_a_faire(request.user) \ | |
cea09938 | 262 | .extra(select=extra_select).order_by('-id') |
92741270 | 263 | postes_en_cours = dae.Poste.objects.ma_region_ou_service(request.user) \ |
5a1f75cb EMS |
264 | .extra(select=extra_select) \ |
265 | .filter(~Q(etat=POSTE_ETAT_FINALISE)) \ | |
cea09938 EMS |
266 | .order_by('-id') |
267 | return render(request, 'dae/postes_liste.html', { | |
92741270 EMS |
268 | 'postes_a_traiter': postes_a_traiter, |
269 | 'postes_en_cours': postes_en_cours, | |
cea09938 | 270 | }) |
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) |
580630f0 | 320 | return render(request, 'dae/embauche_consulter.html', { |
291bbfd9 EMS |
321 | 'dossier': dossier, |
322 | 'validationForm': validationForm, | |
320d7584 | 323 | 'comparaisons_internes': comparaisons_internes, |
580630f0 EMS |
324 | 'comparaisons': comparaisons, |
325 | 'importer': in_drh_or_admin(request.user) | |
326 | }) | |
5a1f75cb | 327 | |
7f432a0b | 328 | @user_passes_test(lambda u: u.is_superuser) |
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) \ | |
cea09938 | 500 | .extra(select=extra_select).order_by('-id') |
5a1f75cb EMS |
501 | embauches_en_cours = dae.Dossier.objects \ |
502 | .ma_region_ou_service(request.user) \ | |
503 | .extra(select=extra_select) \ | |
cea09938 | 504 | .order_by('-id') \ |
5a1f75cb | 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 | |
580630f0 | 585 | return render(request, 'dae/embauches_finalisees.html', { |
cbfd7bd4 | 586 | 'embauches': page, |
890b80e7 | 587 | 'search_form': search_form, |
580630f0 EMS |
588 | 'importer': in_drh_or_admin(request.user) |
589 | }) | |
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 | |
c1908209 | 827 | data['poste'] = dossier.poste.nom |
3803341b OL |
828 | |
829 | # Toutes les rémunérations d'un dossier | |
830 | remunerations = [r for r in dossier.remunerations().order_by('-date_debut') if \ | |
831 | r.type.nature_remuneration == "Traitement"] | |
832 | ||
833 | # On prend les dernières avec le postulat que les rémun à la même date | |
834 | # constituent le dernier salaire | |
835 | if len(remunerations) > 0: | |
836 | date_debut = remunerations[0].date_debut | |
837 | remunerations = [r for r in remunerations if r.date_debut == date_debut] | |
838 | ||
839 | montant = 0.0 | |
840 | montant_euros = 0.0 | |
841 | devise = None | |
842 | ||
843 | # Les remun sont sensées être dans la même devise | |
844 | for r in remunerations: | |
845 | montant += float(r.montant) | |
846 | montant_euros += r.montant_euros() | |
847 | devise = r.devise.id | |
848 | ||
849 | data['devise'] = devise | |
850 | data['montant'] = montant | |
851 | data['montant_euros'] = montant_euros | |
852 | ||
85668061 | 853 | return HttpResponse(dumps(data)) |
f87fe1a1 | 854 | |
5a1f75cb | 855 | |
068d1462 OL |
856 | @dae_groupe_requis |
857 | @vieux_dossier_dans_ma_region_ou_service | |
858 | def poste_resume(request, dossier_id=None): | |
859 | """ | |
860 | On travaille, en réalité sur le dossier mais on cache | |
861 | l'identité de la personne. | |
862 | """ | |
863 | try: | |
864 | dossier = rh.Dossier.objects.get(id=dossier_id) | |
865 | except: | |
866 | return HttpResponseGone("Ce dossier n'est pas accessible") | |
867 | ||
3f5cbabe | 868 | salaire = dossier.get_salaire() |
068d1462 | 869 | data = {} |
09aa8374 | 870 | data['implantation'] = dossier.poste.implantation.id |
83c5ebb7 | 871 | data['poste'] = dossier.poste.nom |
068d1462 OL |
872 | if salaire is not None: |
873 | data['devise'] = salaire.devise.id | |
e503e64d | 874 | data['montant'] = float(salaire.montant) |
e84c8ef1 | 875 | data['montant_euros'] = salaire.montant_euros() |
068d1462 OL |
876 | else: |
877 | data['devise'] = None | |
e503e64d OL |
878 | data['montant'] = "" |
879 | data['montant_euros'] = "" | |
5d84008f OL |
880 | data['statut'] = dossier.statut_id |
881 | data['classement'] = dossier.classement_id | |
068d1462 OL |
882 | return HttpResponse(dumps(data)) |
883 | ||
5a1f75cb | 884 | |
6d047148 | 885 | def liste_postes(request): |
8684fcaa | 886 | """ Appel AJAX : |
6d047148 OL |
887 | input : implantation_id |
888 | output : JSON liste de valeur point | |
889 | """ | |
890 | method = request.method | |
891 | params = getattr(request, method, []) | |
892 | data = [] | |
893 | ||
5a1f75cb EMS |
894 | if 'implantation_id' in params \ |
895 | and params.get('implantation_id') is not u"": | |
6d047148 | 896 | implantation_id = params.get('implantation_id') |
9c1ff333 OL |
897 | q = Q(implantation__id=implantation_id) |
898 | else: | |
899 | q = Q() | |
9536ea21 | 900 | |
9c1ff333 OL |
901 | postes_rh = rh.Poste.objects.ma_region_ou_service(request.user).filter(q) |
902 | postes_rh = postes_rh.select_related(depth=1) | |
4bce4d24 | 903 | |
5a1f75cb | 904 | data = [('', 'Nouveau poste')] + \ |
9c1ff333 OL |
905 | sorted([('rh-%s' % p.id, label_poste_display(p)) for p in |
906 | postes_rh], | |
907 | key=lambda t: t[1]) | |
6d047148 OL |
908 | return HttpResponse(dumps(data)) |
909 | ||
5a1f75cb | 910 | |
e3563bcf | 911 | @login_required |
67a94eaf | 912 | def dossier_piece(request, id, filename): |
e3563bcf EMS |
913 | """Téléchargement d'une pièce jointe à un poste.""" |
914 | piece = get_object_or_404(dae.DossierPiece, pk=id) | |
5a1f75cb EMS |
915 | if dae.Dossier.objects.ma_region_ou_service(request.user) \ |
916 | .filter(id=piece.dossier_id).exists(): | |
67a94eaf | 917 | return sendfile(request, piece.fichier.path) |
e3563bcf EMS |
918 | else: |
919 | return redirect_interdiction(request) | |
920 | ||
5a1f75cb | 921 | |
04380fba | 922 | # AJAX SECURITE non nécessaire |
5a1f75cb | 923 | |
04380fba | 924 | def coefficient(request): |
9536ea21 | 925 | """ Appel AJAX : |
04380fba OL |
926 | input : classement |
927 | output : coefficient | |
928 | """ | |
929 | method = request.method | |
930 | params = getattr(request, method, []) | |
931 | data = dict() | |
932 | if 'classement' in params and params.get('classement') is not u"": | |
933 | classement = params.get('classement') | |
934 | classement = rh.Classement.objects.get(pk=classement) | |
935 | data['coefficient'] = classement.coefficient | |
936 | else: | |
937 | data['coefficient'] = 0 | |
938 | return HttpResponse(dumps(data)) | |
939 | ||
940 | ||
3d627bfd | 941 | def devise(request): |
8684fcaa | 942 | """ Appel AJAX : |
3d627bfd | 943 | input : valeur_point |
8e30e17f | 944 | output : devise, devise_code, taux_euro |
3d627bfd | 945 | """ |
f87fe1a1 OL |
946 | method = request.method |
947 | params = getattr(request, method, []) | |
3d627bfd | 948 | data = dict() |
8684fcaa | 949 | if 'valeur_point' in params and params.get('valeur_point') is not u"": |
f87fe1a1 | 950 | valeur_point = params.get('valeur_point') |
3d627bfd | 951 | valeur_point = rh.ValeurPoint.objects.get(pk=valeur_point) |
952 | annee = valeur_point.annee | |
3f5cbabe | 953 | try: |
5a1f75cb EMS |
954 | taux = rh.TauxChange.objects.get( |
955 | annee=annee, devise=valeur_point.devise | |
956 | ) | |
3f5cbabe | 957 | except MultipleObjectsReturned: |
5a1f75cb EMS |
958 | return HttpResponseGone( |
959 | u"Il existe plusieurs taux pour la devise %s " | |
960 | u"cette année-là : %s" % (valeur_point.devise.code, annee) | |
961 | ) | |
3f5cbabe | 962 | |
3d627bfd | 963 | data['devise'] = taux.devise.id |
f87fe1a1 | 964 | data['valeur'] = valeur_point.valeur |
3d627bfd | 965 | data['devise_code'] = taux.devise.code |
8e30e17f | 966 | data['taux_euro'] = taux.taux |
be3c51e9 OL |
967 | else: |
968 | return HttpResponseGone("Vous devez choisir une valeur de point") | |
3d627bfd | 969 | return HttpResponse(dumps(data)) |
9536ea21 | 970 | |
5a1f75cb | 971 | |
3d627bfd | 972 | def devise_code(request): |
8684fcaa | 973 | """ Appel AJAX : |
3d627bfd | 974 | input : devise |
8e30e17f | 975 | output : devise_code, taux_euro |
3d627bfd | 976 | """ |
f87fe1a1 OL |
977 | method = request.method |
978 | params = getattr(request, method, []) | |
3d627bfd | 979 | data = dict() |
f87fe1a1 OL |
980 | if 'devise' in params: |
981 | devise = params.get('devise') | |
3d627bfd | 982 | devise = rh.Devise.objects.get(pk=devise) |
8e30e17f | 983 | annee = date.today().year |
984 | taux = rh.TauxChange.objects.filter(annee=annee, devise=devise) | |
86f1e48d OL |
985 | if len(taux) == 0: |
986 | return HttpResponseGone("Le taux n'est pas disponible") | |
3d627bfd | 987 | data['devise_code'] = devise.code |
8e30e17f | 988 | data['taux_euro'] = taux[0].taux |
3d627bfd | 989 | return HttpResponse(dumps(data)) |
85668061 | 990 | |
5a1f75cb | 991 | |
cb1d62b5 NC |
992 | def add_remun(request, dossier, type_remun): |
993 | dossier = get_object_or_404(dae.Dossier, pk=dossier) | |
994 | type_remun = get_object_or_404(rh.TypeRemuneration, pk=type_remun) | |
995 | dae.Remuneration(dossier=dossier, devise=dossier.devise, | |
996 | type=type_remun).save() | |
997 | ||
890b80e7 DB |
998 | c = { |
999 | 'dossier': dossier, | |
1000 | } | |
1001 | return render(request, 'dae/embauche-remun.html', c) | |
03b395db | 1002 | |
5a1f75cb | 1003 | |
04380fba OL |
1004 | def salaire(request, implantation, devise, classement): |
1005 | if not devise or not classement: | |
1006 | raise Http404 | |
1007 | ||
04380fba | 1008 | taux = rh.TauxChange.objects.filter(devise=devise).order_by('-annee') |
5a1f75cb EMS |
1009 | vp = rh.ValeurPoint.objects \ |
1010 | .filter(implantation=implantation, devise=devise) \ | |
1011 | .order_by('-annee') | |
aa512122 OL |
1012 | |
1013 | if vp.count() == 0: | |
1014 | raise Exception(u"pas de valeur de point pour le couple\ | |
1015 | implantation/devise (%s/%s)" % (implantation, devise)) | |
1016 | ||
1017 | if taux.count() == 0: | |
1018 | raise Exception(u"Pas de taux pour la devise %s" % devise) | |
04380fba OL |
1019 | |
1020 | classement = get_object_or_404(rh.Classement, pk=classement) | |
e2968ebb EMS |
1021 | if classement.coefficient is None: |
1022 | raise Http404 | |
90716392 | 1023 | taux, vp = taux[0].taux, vp[0].valeur |
04380fba | 1024 | |
90716392 | 1025 | salaire_euro = round(vp * classement.coefficient * taux, 2) |
04380fba OL |
1026 | data = dict(salaire_euro=salaire_euro, taux=taux, |
1027 | salaire_devise=round(salaire_euro / taux, 2)) | |
1028 | ||
1029 | return HttpResponse(dumps(data)) | |
1030 | ||
5a1f75cb | 1031 | |
04380fba | 1032 | def liste_valeurs_point(request): |
8684fcaa | 1033 | """ Appel AJAX : |
04380fba OL |
1034 | input : implantation_id |
1035 | output : JSON liste de valeur point | |
03b395db | 1036 | """ |
04380fba OL |
1037 | method = request.method |
1038 | params = getattr(request, method, []) | |
1039 | data = [] | |
cea09938 | 1040 | annee_courante = datetime.now().year |
5a1f75cb EMS |
1041 | if 'implantation_id' in params \ |
1042 | and params.get('implantation_id') is not u"": | |
04380fba | 1043 | implantation_id = params.get('implantation_id') |
5a1f75cb EMS |
1044 | preselectionne = rh.ValeurPoint.objects \ |
1045 | .filter(implantation=implantation_id, annee=annee_courante) \ | |
1046 | .order_by("-annee") | |
7ad0549c | 1047 | for o in preselectionne: |
5a1f75cb EMS |
1048 | data.append({ |
1049 | 'id': o.id, | |
1050 | 'label': o.__unicode__(), | |
1051 | 'devise': o.devise_id, | |
1052 | 'suggestion': True | |
1053 | }) | |
b1f7765e | 1054 | else: |
7ad0549c OL |
1055 | preselectionne = rh.ValeurPoint.objects.none() |
1056 | ||
5a1f75cb EMS |
1057 | liste_complete = rh.ValeurPoint.objects \ |
1058 | .filter(annee__in=(annee_courante,)) \ | |
1059 | .order_by("-annee") | |
7ad0549c | 1060 | for o in liste_complete.exclude(id__in=[p.id for p in preselectionne]): |
5a1f75cb EMS |
1061 | data.append({ |
1062 | 'id': o.id, | |
1063 | 'label': o.__unicode__(), | |
1064 | 'devise': o.devise_id, | |
1065 | 'suggestion': False | |
1066 | }) | |
3f5cbabe | 1067 | return HttpResponse(dumps(data, indent=4)) |