1 # -*- encoding: utf-8 -*-
3 from datetime
import date
, datetime
4 from dateutil
.relativedelta
import relativedelta
6 from auf
.django
.permissions
.decorators
import get_object
7 from auf
.django
.references
import models
as ref
8 from django
.contrib
import messages
9 from django
.contrib
.auth
.decorators
import login_required
, user_passes_test
10 from django
.contrib
.contenttypes
.models
import ContentType
11 from django
.core
.paginator
import Paginator
, InvalidPage
12 from django
.db
.models
import Q
, Count
13 from django
.http
import Http404
, HttpResponse
, HttpResponseNotFound
14 from django
.shortcuts
import redirect
, render
, get_object_or_404
15 from sendfile
import sendfile
16 from simplejson
import dumps
18 from project
.dae
import models
as dae
19 from project
.dae
.decorators
import \
21 poste_dans_ma_region_ou_service
, \
22 dossier_dans_ma_region_ou_service
, \
23 vieux_dossier_dans_ma_region_ou_service
, \
24 employe_dans_ma_region_ou_service
, \
25 dossier_est_modifiable
, \
26 poste_est_modifiable
, get_contrat
27 from project
.dae
.forms
import FinancementFormSet
, FinancementFormSetInitial
28 from project
.dae
.forms
import \
29 PosteComparaisonFormSet
, PosteComparaisonFormSetInitial
30 from project
.dae
.forms
import \
31 PosteWorkflowForm
, PosteForm
, PostePieceFormSet
, \
32 DossierWorkflowForm
, ChoosePosteForm
, \
33 EmployeForm
, DossierForm
, DossierPieceForm
, \
34 DossierComparaisonFormSet
, RemunForm
, ContratForm
, DAENumeriseeForm
, \
35 label_poste_display
, DAEFinaliseesSearchForm
, \
36 remun_formset_factory
, ReadOnlyRemunFormSet
37 from project
.dae
.mail
import send_drh_finalisation_mail
38 from project
.dae
.workflow
import \
39 DOSSIER_ETAT_FINALISE
, DOSSIER_ETAT_REGION_FINALISATION
, \
40 DOSSIER_ETAT_DRH_FINALISATION
, POSTE_ETAT_FINALISE
41 from project
.decorators
import redirect_interdiction
,\
42 drh_or_admin_required
,\
45 from project
.rh
import models
as rh
46 from project
import groups
53 for d
in rh
.Devise
.objects
.all():
54 annee
= date
.today().year
55 taux
= rh
.TauxChange
.objects
.filter(annee
=annee
, devise
=d
)
60 data
['taux_euro'] = taux
[0].taux
61 data
['devise_code'] = d
.id
68 return render(request
, 'dae/index.html', {})
74 @poste_dans_ma_region_ou_service
75 def poste_consulter(request
, key
):
76 source
, id = key
.split('-')
77 poste
= get_object_or_404(dae
.Poste
, pk
=id)
80 validationForm
= PosteWorkflowForm(
81 request
.POST
, instance
=poste
, request
=request
83 if validationForm
.is_valid():
86 request
, messages
.SUCCESS
, "La validation a été enregistrée."
88 return redirect('dae_postes_liste')
90 validationForm
= PosteWorkflowForm(instance
=poste
, request
=request
)
92 comparaisons_internes
= \
93 poste
.dae_comparaisons_internes
.ma_region_ou_service(request
.user
)
94 return render(request
, 'dae/poste_consulter.html', {
97 'validationForm': validationForm
,
98 'comparaisons_internes': comparaisons_internes
,
99 'importer': in_drh_or_admin(request
.user
),
103 @user_passes_test(lambda u
: in_drh_or_admin(u
))
104 @drh_or_admin_required
105 def poste_importer(request
, id):
106 poste_dae
= get_object_or_404(dae
.Poste
, id=id)
107 if request
.method
== 'POST':
108 if 'confirmer' in request
.POST
:
109 poste_rh
= poste_dae
.importer_dans_rh()
110 return redirect('admin:rh_poste_change', poste_rh
.id)
112 return redirect('poste_consulter', 'dae-' + id)
117 return render(request
, 'dae/poste_importer.html', c
)
121 @poste_dans_ma_region_ou_service
122 @poste_est_modifiable
123 @in_one_of_group((groups
.CORRESPONDANT_RH
,
124 groups
.ADMINISTRATEURS
,
125 groups
.DIRECTEUR_DE_BUREAU
,
127 groups
.DRH_NIVEAU_2
))
128 def poste(request
, key
=None):
129 """ Formulaire pour un poste.
131 Permet de créer ou modifier un poste. Si le poste n'existe que dans rh_v1
132 il est automatiquement copié dans dae.
135 if 'creer_dossier_dae' in request
.GET
:
136 creer_dossier_dae
= True
138 creer_dossier_dae
= False
140 def _dupliquer_poste(poste_dae
, poste_rh
):
142 Recopie les fields d'un poste RH dans un poste DAE
143 avec ceux-ci précédemment crées
145 exclus
= ('id', 'supprime', 'date_creation',
146 'user_creation', 'date_modification',
147 'user_modification', )
148 fields
= [f
for f
in poste_rh
._meta
.fields
if f
.name
not in exclus
]
150 setattr(poste_dae
, field
.name
, getattr(poste_rh
, field
.name
))
153 poste
, data
, vars = None, dict(), dict()
155 # Sans key, c'est un nouveau poste
162 if 'type_intervention' in request
.GET
:
163 data
['type_intervention'] = request
.GET
['type_intervention']
164 if creer_dossier_dae
:
165 data
['type_intervention'] = request
.GET
['creer_dossier_dae']
170 source
, id = key
.split('-')
173 poste
= get_object_or_404(dae
.Poste
, pk
=id)
176 poste_rh
= get_object_or_404(rh
.Poste
, pk
=id)
177 poste
= dae
.Poste(id_rh
=poste_rh
)
178 # Initialisation avec les valeurs du poste de rh_v1
179 poste
= _dupliquer_poste(poste
, poste_rh
)
180 data
['poste'] = 'rh-' + str(poste
.id_rh_id
)
182 # prépopuler pour la modification de poste
183 if poste_rh
is not None:
184 FinancementForm
= FinancementFormSetInitial
185 PosteComparaisonForm
= PosteComparaisonFormSetInitial
187 qs_financements
= poste_rh
.rh_financements
.all()
188 qs_comparaisons
= poste_rh
.rh_comparaisons_internes
.all()
189 financements
= [{'type': f
.type, 'pourcentage': f
.pourcentage
,
190 'commentaire': f
.commentaire
} for f
in qs_financements
]
191 comparaisons
= [{'implantation': c
.implantation
, 'nom': c
.nom
,
192 'montant': c
.montant
, 'devise': c
.devise
} for c
in qs_comparaisons
]
193 # formulaires normaux, avec modifications des objects FK
195 FinancementForm
= FinancementFormSet
196 PosteComparaisonForm
= PosteComparaisonFormSet
201 data
.update(dict(request
.POST
.items()))
202 form
= PosteForm(data
, instance
=poste
, request
=request
)
203 financementForm
= FinancementForm(request
.POST
, instance
=poste
, )
204 piecesForm
= PostePieceFormSet(
205 request
.POST
, request
.FILES
, instance
=poste
207 comparaisons_formset
= PosteComparaisonForm(
211 if form
.is_valid() and piecesForm
.is_valid() and \
212 financementForm
.is_valid() and comparaisons_formset
.is_valid():
214 piecesForm
.instance
= poste
216 financementForm
.instance
= poste
217 financementForm
.save()
219 # Ne remplacer que les comparaisons de ma région
220 comparaisons
= comparaisons_formset
.save(commit
=False)
221 for comparaison
in comparaisons
:
222 comparaison
.poste
= poste
224 saved_cmps
= [x
.id for x
in comparaisons
]
226 for cmp_f
in comparaisons_formset
.forms
:
227 comparaison
= (cmp_f
.instance
, cmp_f
)
229 cmp_dossier_id
= comparaison
[1].cleaned_data
.get(
231 if (not cmp_dossier_id
or
232 comparaison
[0].id not in saved_cmps
):
234 cmp_dossier_qs
= rh
.Dossier
.objects
.filter(id=cmp_dossier_id
)
235 if not cmp_dossier_qs
.count() > 0:
237 dossier
= rh
.Dossier
.objects
.get(id=cmp_dossier_qs
.get().id)
239 # Get all remunerations for a period of 1 year,
240 # going back from either: today (if dossier has not
241 # yet ended), or from dossier's date_fin.
242 cmp_date
= min(dossier
.date_fin
or date
.today(), date
.today())
243 for remuneration
in _filter_remunerations(
244 dossier
.remunerations().order_by('-date_debut'),
245 only_traitement
=False,
247 dae
.PosteComparaisonRemuneration
.objects
.create(
248 poste_comparaison
= comparaison
[0],
249 type=remuneration
.type,
250 type_revalorisation
=remuneration
.type_revalorisation
,
251 montant
=remuneration
.montant
,
252 devise
=remuneration
.devise
,
253 commentaire
=remuneration
.commentaire
,
254 date_debut
=remuneration
.date_debut
,
255 date_fin
=remuneration
.date_fin
,
258 # dans le cas d'une modification de poste de RH, on recopie les PJ
259 if poste_rh
is not None:
260 for piece
in poste_rh
.rh_pieces
.all():
261 dae
.PostePiece(poste
=poste
, nom
=piece
.nom
,
262 fichier
=piece
.fichier
).save()
263 messages
.add_message(
264 request
, messages
.SUCCESS
,
265 "Le poste %s a été sauvegardé." % poste
267 if creer_dossier_dae
:
268 return redirect('embauche', key
='dae-%s' % poste
.id)
270 if 'save' in request
.POST
:
271 return redirect('poste_consulter', key
='dae-%s' % poste
.id)
273 return redirect('poste', key
='dae-%s' % poste
.id)
276 messages
.add_message(
277 request
, messages
.ERROR
,
278 'Il y a des erreurs dans le formulaire.'
282 # 'initial' évite la validation prémature lors d'une copie de poste de
284 form
= PosteForm(initial
=data
, instance
=poste
, request
=request
)
285 piecesForm
= PostePieceFormSet(instance
=poste
)
287 if poste_rh
is not None:
288 financementForm
= FinancementForm(
289 initial
=financements
, instance
=poste
291 comparaisons_formset
= PosteComparaisonForm(
292 initial
=comparaisons
,
295 # cas de la création d'un nouveau poste
297 financementForm
= FinancementForm(instance
=poste
)
298 comparaisons_formset
= PosteComparaisonForm(instance
=poste
)
301 # Modify queryset so that it is limited to users' rights:
302 imp_qs
= dae
.ProxyImplantation
.dae_manager
.ma_region_ou_service(
305 for cmp_form
in comparaisons_formset
.forms
:
306 cmp_form
.fields
['implantation'].queryset
= imp_qs
309 form
=form
, poste
=poste
, poste_key
=key
, piecesForm
=piecesForm
,
310 financementForm
=financementForm
,
311 comparaisons_formset
=comparaisons_formset
,
313 creer_dossier_dae
=creer_dossier_dae
,
316 return render(request
, 'dae/poste.html', vars)
320 def postes_liste(request
):
321 """ Liste des postes. """
322 content_type
= ContentType
.objects
.get_for_model(dae
.Poste
)
323 extra_select
= {'derniere_validation': (
324 "SELECT MAX(date) FROM workflow_workflowcommentaire "
325 "WHERE content_type_id = '%s' AND object_id = dae_poste.id" %
328 postes_a_traiter
= dae
.Poste
.objects
.mes_choses_a_faire(request
.user
) \
329 .annotate(num_dae
=Count('dae_dossiers')) \
331 .extra(select
=extra_select
).order_by('-id')
332 postes_en_cours
= dae
.Poste
.objects
.ma_region_ou_service(request
.user
) \
333 .annotate(num_dae
=Count('dae_dossiers')) \
335 .extra(select
=extra_select
) \
336 .filter(~
Q(etat
=POSTE_ETAT_FINALISE
)) \
338 return render(request
, 'dae/postes_liste.html', {
339 'postes_a_traiter': postes_a_traiter
,
340 'postes_en_cours': postes_en_cours
,
345 def poste_piece(request
, id, filename
):
346 """Téléchargement d'une pièce jointe à un poste."""
347 piece
= get_object_or_404(dae
.PostePiece
, pk
=id)
348 if dae
.Poste
.objects
.ma_region_ou_service(request
.user
) \
349 .filter(id=piece
.poste_id
).exists():
350 return sendfile(request
, piece
.fichier
.path
)
352 return redirect_interdiction(request
)
357 def filtered_type_remun():
358 defaut
= (2, 3, 8, 17) # salaire de base, indemnité de fonction,
360 return rh
.TypeRemuneration
.objects
.filter(pk__in
=defaut
)
364 @dossier_dans_ma_region_ou_service
365 def embauche_consulter(request
, dossier_id
):
366 dossier
= get_object_or_404(dae
.Dossier
, pk
=dossier_id
)
367 etat_precedent
= dossier
.etat
370 validationForm
= DossierWorkflowForm(
371 request
.POST
, instance
=dossier
, request
=request
373 if validationForm
.is_valid():
374 if etat_precedent
== DOSSIER_ETAT_REGION_FINALISATION
and \
375 validationForm
.cleaned_data
['etat'] == \
376 DOSSIER_ETAT_DRH_FINALISATION
:
377 send_drh_finalisation_mail(request
, dossier
)
378 validationForm
.save()
379 messages
.add_message(
380 request
, messages
.SUCCESS
, "La validation a été enregistrée."
382 return redirect('dae_embauches_liste')
384 validationForm
= DossierWorkflowForm(instance
=dossier
, request
=request
)
386 comparaisons_internes
= \
387 dossier
.poste
.dae_comparaisons_internes
.ma_region_ou_service(
390 comparaisons
= dossier
.dae_comparaisons
.ma_region_ou_service(request
.user
)
392 return render(request
, 'dae/embauche_consulter.html', {
394 'devises': devises(),
395 'validationForm': validationForm
,
396 'comparaisons_internes': comparaisons_internes
,
397 'comparaisons': comparaisons
,
398 'importer': in_drh_or_admin(request
.user
),
402 @user_passes_test(lambda u
: in_drh_or_admin(u
))
404 @dossier_dans_ma_region_ou_service
405 def embauche_importer(request
, dossier_id
=None):
406 dossier_dae
= get_object_or_404(dae
.Dossier
, id=dossier_id
)
407 if request
.method
== 'POST':
408 if 'confirmer' in request
.POST
:
409 dossier_rh
= dossier_dae
.importer_dans_rh()
410 return redirect('admin:rh_dossier_change', dossier_rh
.id)
412 return redirect('embauches_finalisees')
415 'dossier': dossier_dae
,
417 return render(request
, 'dae/embauche_importer.html', c
)
421 def embauche_choisir_poste(request
):
423 form
= ChoosePosteForm(data
=request
.POST
, request
=request
)
425 return form
.redirect()
427 form
= ChoosePosteForm(request
=request
)
431 return render(request
, 'dae/embauche-choisir-poste.html', c
)
435 @dossier_dans_ma_region_ou_service
436 @dossier_est_modifiable
437 def embauche(request
, key
=None, dossier_id
=None):
438 """ Formulaire d'autorisation d'embauche. """
440 # Récupérer ou créer un poste et un dossier
441 source
, id = key
.split('-')
444 poste
= get_object_or_404(dae
.Poste
, pk
=id)
447 if request
.POST
['employe'] == '':
449 employe
= dae
.Employe()
451 employe_source
, id = request
.POST
['employe'].split('-')
452 if employe_source
== 'dae':
454 employe
= get_object_or_404(dae
.Employe
, pk
=id)
455 elif employe_source
== 'rh':
456 # Employé RH, on le copie dans DAE
457 e
= get_object_or_404(rh
.Employe
, pk
=id)
458 employe
= dae
.Employe(id_rh
=e
, prenom
=e
.prenom
, nom
=e
.nom
,
463 employe_form
= EmployeForm(
464 request
.POST
, instance
=employe
, request
=request
467 if employe_form
.is_valid():
468 data
= dict(request
.POST
.items())
469 employe
= employe_form
.save()
470 data
['employe'] = 'dae-%s' % employe
.id
471 employe_form
= EmployeForm(data
, instance
=employe
, request
=request
)
474 dossier
= dae
.Dossier(poste
=poste
, employe
=employe
)
476 dossier
= get_object_or_404(dae
.Dossier
, pk
=dossier_id
)
477 dossier
.employe
= employe_form
.instance
479 dossier_form
= DossierForm(request
.POST
, instance
=dossier
)
480 piecesForm
= DossierPieceForm(
481 request
.POST
, request
.FILES
, instance
=dossier
483 comparaisons_formset
= DossierComparaisonFormSet(
485 queryset
=dossier
.dae_comparaisons
.ma_region_ou_service(
490 remunForm
= RemunForm(request
.POST
, instance
=dossier
)
492 if employe_form
.is_valid() and \
493 dossier_form
.is_valid() and \
494 piecesForm
.is_valid() and \
495 comparaisons_formset
.is_valid() and \
496 remunForm
.is_valid():
502 # Ne remplacer que les comparaisons de ma région
504 comparaisons
= comparaisons_formset
.save(commit
=False)
505 for comparaison
in comparaisons
:
506 comparaison
.dossier
= dossier
508 saved_cmps
= [x
.id for x
in comparaisons
]
510 for cmp_f
in comparaisons_formset
.forms
:
511 comparaison
= (cmp_f
.instance
, cmp_f
)
513 cmp_dossier_id
= comparaison
[1].cleaned_data
.get(
515 if (not cmp_dossier_id
or
516 comparaison
[0].id not in saved_cmps
):
518 cmp_dossier_qs
= rh
.Dossier
.objects
.filter(id=cmp_dossier_id
)
519 if not cmp_dossier_qs
.count() > 0:
521 rhdossier
= rh
.Dossier
.objects
.get(id=cmp_dossier_qs
.get().id)
524 # Get all remunerations for a period of 1 year,
525 # going back from either: today (if cdossier has not
526 # yet ended), or from cdossier's date_fin.
527 cmp_date
= min(rhdossier
.date_fin
or date
.today(), date
.today())
528 for remuneration
in _filter_remunerations(
529 rhdossier
.remunerations().order_by('-date_debut'),
530 only_traitement
=False,
532 dae
.DossierComparaisonRemuneration
.objects
.create(
533 dossier_comparaison
= comparaison
[0],
534 type=remuneration
.type,
535 type_revalorisation
=remuneration
.type_revalorisation
,
536 montant
=remuneration
.montant
,
537 devise
=remuneration
.devise
,
538 commentaire
=remuneration
.commentaire
,
539 date_debut
=remuneration
.date_debut
,
540 date_fin
=remuneration
.date_fin
,
544 request
, "Le dossier %s a été sauvegardé." % dossier
546 if 'save' in request
.POST
:
547 return redirect('embauche_consulter', dossier_id
=dossier
.id)
550 'embauche', key
=dossier
.poste
.key
, dossier_id
=dossier
.id
554 messages
.add_message(
555 request
, messages
.ERROR
,
556 'Il y a des erreurs dans le formulaire.'
560 # Initialisation d'un formulaire vide
562 dossier
= get_object_or_404(dae
.Dossier
, pk
=dossier_id
)
563 employe
= dossier
.employe
564 data
= dict(employe
='dae-%s' % employe
.id)
565 employe_form
= EmployeForm(
566 initial
=data
, instance
=employe
, request
=request
569 dossier_rh
= rh
.Dossier()
570 poste_rh
= poste
.id_rh
571 dossier
= pre_filled_dossier(dossier_rh
, 'new', poste_rh
)
572 employe_form
= EmployeForm(request
=request
)
574 dossier_form
= DossierForm(instance
=dossier
)
575 piecesForm
= DossierPieceForm(instance
=dossier
)
576 comparaisons_formset
= DossierComparaisonFormSet(
577 queryset
=dossier
.dae_comparaisons
.ma_region_ou_service(
581 remunForm
= RemunForm(instance
=dossier
)
584 comparaisons_internes
= \
585 dossier
.poste
.dae_comparaisons_internes
.ma_region_ou_service(
588 except dae
.Poste
.DoesNotExist
:
589 comparaisons_internes
= []
591 # Modify queryset so that it is limited to users' rights:
592 imp_qs
= dae
.ProxyImplantation
.dae_manager
.ma_region_ou_service(
595 for cmp_form
in comparaisons_formset
.forms
:
596 cmp_form
.fields
['implantation'].queryset
= imp_qs
598 # Comment out for now.
600 rh_poste
= poste
.id_rh
601 except rh
.Poste
.DoesNotExist
:
604 dossier_form
.fields
['employe_anterieur'].queryset
= (
605 dossier_form
.fields
['employe_anterieur'].queryset
.filter(
606 rh_dossiers__poste__pk
=rh_poste
.pk
,
611 'type_remun': filtered_type_remun(),
612 'devises': devises(),
615 'piecesForm': piecesForm
,
616 'remunForm': remunForm
,
617 'comparaisons_formset': comparaisons_formset
,
618 'forms': dict(employe
=employe_form
, dossier
=dossier_form
, ),
619 'comparaisons_internes': comparaisons_internes
,
621 return render(request
, 'dae/embauche.html', c
)
625 @dossier_dans_ma_region_ou_service
626 def embauches_liste(request
):
627 """ Liste des embauches. """
628 content_type
= ContentType
.objects
.get_for_model(dae
.Dossier
)
629 extra_select
= {'derniere_validation': (
630 "SELECT MAX(date) FROM workflow_workflowcommentaire "
631 "WHERE content_type_id = '%s' AND object_id = dae_dossier.id" %
634 embauches_a_traiter
= dae
.Dossier
.objects \
635 .mes_choses_a_faire(request
.user
) \
636 .extra(select
=extra_select
).order_by('-id')
637 embauches_en_cours
= dae
.Dossier
.objects \
638 .ma_region_ou_service(request
.user
) \
639 .extra(select
=extra_select
) \
641 .exclude(etat
=DOSSIER_ETAT_FINALISE
)
643 'embauches_a_traiter': embauches_a_traiter
,
644 'embauches_en_cours': embauches_en_cours
,
646 return render(request
, 'dae/embauches_liste.html', c
)
650 def embauches_finalisees(request
):
651 """Liste des embauches finalisées."""
655 if request
.method
== 'POST':
656 if 'supprimer' in request
.POST
:
657 ids
= request
.POST
.getlist('ids')
658 dossiers
= dae
.Dossier
.objects
.filter(id__in
=ids
)
659 count
= dossiers
.count()
662 messages
.success(request
, u
'%d dossiers supprimés' % count
)
663 return redirect(request
.get_full_path())
667 embauches
= dae
.Dossier
.objects
.ma_region_ou_service(request
.user
) \
668 .filter(etat
=DOSSIER_ETAT_FINALISE
)
671 search_form
= DAEFinaliseesSearchForm(request
.GET
)
672 if search_form
.is_valid():
673 q
= search_form
.cleaned_data
.get('q').strip()
674 importees
= search_form
.cleaned_data
.get('importees')
678 'poste__implantation__zone_administrative__nom__icontains':
681 Q(poste__implantation__zone_administrative__code
=word
) |
682 Q(poste__implantation__nom__icontains
=word
) |
683 Q(poste__nom__icontains
=word
) |
684 Q(employe__nom__icontains
=word
) |
685 Q(employe__prenom__icontains
=word
)
686 for word
in q
.split()
688 embauches
= embauches
.filter(*criteria
)
689 if importees
== 'oui':
690 embauches
= embauches
.exclude(dossier_rh
=None)
691 elif importees
== 'non':
692 embauches
= embauches
.filter(dossier_rh
=None)
695 tri
= request
.GET
.get('tri', None)
696 if tri
and tri
.startswith('-'):
702 embauches
= embauches
.order_by(
703 dir + 'poste__implantation__zone_administrative__nom'
705 elif tri
== 'implantation':
706 embauches
= embauches
.order_by(dir + 'poste__implantation__nom')
708 embauches
= embauches
.order_by(dir + 'poste__nom')
709 elif tri
== 'personne':
710 embauches
= embauches
.order_by(dir + 'employe__nom',
711 dir + 'employe__prenom')
712 elif tri
== 'date_debut':
713 embauches
= embauches
.order_by(dir + 'debut_contrat')
714 elif tri
== 'date_fin':
715 embauches
= embauches
.order_by(dir + 'fin_contrat')
718 paginator
= Paginator(embauches
, 20)
720 page
= paginator
.page(request
.GET
.get('page', 1))
722 page
= paginator
.page(1)
724 return render(request
, 'dae/embauches_finalisees.html', {
726 'search_form': search_form
,
727 'importer': in_drh_or_admin(request
.user
)
731 def employe(request
, key
):
732 """ Récupération AJAX de l'employé pour la page d'embauche. """
733 data
= dict(employe
=key
)
737 employe
= dae
.Employe()
740 source
, id = key
.split('-')
743 employe
= get_object_or_404(dae
.Employe
, pk
=id)
745 e
= get_object_or_404(rh
.Employe
, id=id)
746 # Initialisation avec les valeurs de l'employé de rh_v1
747 employe
= dae
.Employe(id_rh
=e
)
748 for field
in ('prenom', 'nom', 'genre'):
749 setattr(employe
, field
, getattr(e
, field
))
752 EmployeForm(initial
=data
, instance
=employe
, request
=request
).as_table()
760 def contrat(request
, contrat
, filename
):
761 return sendfile(request
, contrat
.fichier
.path
)
766 def contrat_supprimer(request
, contrat
):
767 if request
.method
== 'POST':
768 if 'oui' in request
.POST
:
770 return redirect('embauche_consulter', dossier_id
=contrat
.dossier
.id)
774 return render(request
, 'dae/contrat-supprimer.html', c
)
778 @dossier_dans_ma_region_ou_service
779 def embauche_ajouter_contrat(request
, dossier_id
=None):
780 dossier
= get_object_or_404(dae
.Dossier
, pk
=dossier_id
)
781 if request
.method
== 'POST':
782 form
= ContratForm(request
.POST
, request
.FILES
)
784 contrat
= form
.save(commit
=False)
785 contrat
.dossier
= dossier
786 contrat
.date_debut
= dossier
.contrat_date_debut
787 contrat
.date_fin
= dossier
.contrat_date_fin
789 return redirect('embauche_consulter', dossier_id
=dossier
.id)
796 return render(request
, 'dae/embauche-ajouter-contrat.html', c
)
801 @get_object(dae
.Dossier
, 'consulter')
802 def dae_numerisee(request
, dossier
):
803 return sendfile(request
, dossier
.dae_numerisee
.path
)
806 @get_object(dae
.Dossier
, 'modifier_dae_numerisee')
807 def dae_numerisee_modifier(request
, dossier
):
808 if request
.method
== 'POST':
809 form
= DAENumeriseeForm(request
.POST
, request
.FILES
, instance
=dossier
)
812 return redirect('embauche_consulter', dossier_id
=dossier
.id)
814 form
= DAENumeriseeForm(instance
=dossier
)
819 return render(request
, 'dae/dae_numerisee_modifier.html', c
)
822 @get_object(dae
.Dossier
, 'modifier_dae_numerisee')
823 def dae_numerisee_supprimer(request
, dossier
):
824 if request
.method
== 'POST':
825 if 'oui' in request
.POST
:
826 dossier
.dae_numerisee
= None
828 return redirect('embauche_consulter', dossier_id
=dossier
.id)
829 return render(request
, 'dae/dae_numerisee_supprimer.html', {})
835 @employe_dans_ma_region_ou_service
836 def dossier(request
, poste_key
, employe_key
):
837 """ Récupération AJAX du dossier pour la page d'embauche. """
840 poste_source
, poste_id
= poste_key
.split('-')
841 poste
= get_object_or_404(dae
.Poste
, pk
=poste_id
)
843 # Récupérer la devise de l'implantation lié au poste
844 implantation_devise
= poste
.get_default_devise()
845 data
.update({'devise': implantation_devise
})
847 if poste
.id_rh_id
is not None:
848 poste_rh
= get_object_or_404(rh
.Poste
, pk
=poste
.id_rh_id
)
853 if employe_key
== '':
854 employe_source
= 'new'
856 dossier_rh
= rh
.Dossier()
857 dossier
= pre_filled_dossier(dossier_rh
, employe_source
, poste_rh
)
860 if employe_key
.startswith('dae'):
861 employe_source
, employe_id
= employe_key
.split('-')
862 employe_dae
= get_object_or_404(dae
.Employe
, pk
=employe_id
)
864 # récupération de l'ancien dossier rh v1 pour l'employe DAE
866 dossier_rh
= rh
.Dossier
.objects
.get(
867 employe
=employe_dae
.id_rh_id
, date_fin
=None
869 except (rh
.Dossier
.DoesNotExist
):
870 dossier_rh
= rh
.Dossier()
872 # on tente de récupérer le dossier DAE, au pire on le contruit en le
873 # prépoluant avec son dossier rh v1.
875 dossier
= dae
.Dossier
.objects
.get(employe
=employe_dae
, poste
=poste
)
876 except (dae
.Dossier
.DoesNotExist
):
877 dossier
= pre_filled_dossier(dossier_rh
, employe_source
, poste_rh
)
878 employe
= employe_dae
.id_rh
881 if employe_key
.startswith('rh'):
882 employe_source
, employe_id
= employe_key
.split('-')
883 employe_rh
= get_object_or_404(rh
.Employe
, pk
=employe_id
)
885 # récupération de l'ancien dossier rh v1 pour l'employe rh v1, s'il
886 # n'en a pas, on en fournit un nouveau qui servira uniquement un
887 # créer un nouveau dossier DAE.
889 dossier_rh
= rh
.Dossier
.objects
.get(
890 employe
=employe_rh
, date_fin
=None
892 except (rh
.Dossier
.DoesNotExist
):
893 dossier_rh
= rh
.Dossier()
894 dossier
= pre_filled_dossier(dossier_rh
, employe_source
, poste_rh
)
897 dossier_form
= DossierForm(initial
=data
, instance
=dossier
)
900 dossier_form
.fields
['employe_anterieur'].queryset
= (
901 dossier_form
.fields
['employe_anterieur'].queryset
.filter(
902 rh_dossiers__poste__pk
=poste_rh
.pk
,
906 vars = dict(form
=dossier_form
, poste
=poste
, employe
=employe
)
907 return render(request
, 'dae/embauche-dossier.html', vars)
910 # Cette fonction est appelée à partir de fonctions déjà sécurisée
911 def pre_filled_dossier(dossier_rh
, employe_source
, poste_rh
):
912 dossier
= dae
.Dossier()
914 if employe_source
!= 'new' and dossier_rh
.id:
915 dossier
.statut_anterieur
= dossier_rh
.statut
917 # Certains dossiers ont un classement à zéro
918 if dossier_rh
.classement_id
> 0:
919 dossier
.classement_anterieur
= dossier_rh
.classement
921 # Récupération du salaire de base
922 remun
= dossier_rh
.remunerations() \
923 .filter(type=1).order_by('-date_debut')
925 dossier
.salaire_anterieur
= remun
[0].montant
926 dossier
.devise_anterieur
= remun
[0].devise
928 # Récupération du titulaire précédent
930 dossiers
= rh
.Dossier
.objects
.order_by('-date_debut')
932 dossiers
= dossiers
.filter(poste
=poste_rh
)
934 dossiers
= rh
.Dossier
.objects
.none()
936 # Ce bloc ignore toutes les erreurs, car les données de rh
937 # manquantes peuvent en générer
940 titulaire
= d
.employe
941 dossier
.employe_anterieur
= titulaire
942 dossier
.classement_titulaire_anterieur
= d
.classement
943 dossier
.statut_titulaire_anterieur
= d
.statut
944 remun
= d
.remunerations().filter(type=1) \
945 .order_by('-date_debut')[0]
946 dossier
.salaire_titulaire_anterieur
= remun
.montant
947 dossier
.devise_titulaire_anterieur
= remun
.devise
950 # TODO: afficher l'info, les champs ne sont pas dans le
951 # modèle dae.Dossier: nom, prenom, classement, salaire
954 except (rh
.Dossier
.DoesNotExist
):
955 dossier_rh
= rh
.Dossier()
960 def _filter_remunerations(remun_qs
, only_traitement
=True):
962 Type de remun traitement derniers commencant a la meme date
964 # Toutes les rémunérations d'un dossier
965 remunerations
= remun_qs
970 if r
.type.nature_remuneration
== "Traitement"
973 # On prend les dernières avec le postulat que les rémun à la même date
974 # constituent le dernier salaire
975 if len(remunerations
) > 0:
976 date_debut
= remunerations
[0].date_debut
978 return [r
for r
in remunerations
if r
.date_debut
== date_debut
]
982 def _get_salaire_traitement(dossier
):
985 remunerations
= _filter_remunerations(dossier
.remunerations().order_by('-date_debut'))
991 # Les remun sont sensées être dans la même devise
992 for r
in remunerations
:
993 montant
+= float(r
.montant
)
994 montant_euros
+= r
.montant_euros()
997 data
['devise'] = devise
998 data
['montant'] = montant
999 data
['montant_euros'] = montant_euros
1004 @vieux_dossier_dans_ma_region_ou_service
1005 def dossier_resume(request
, dossier_id
=None):
1007 dossier
= rh
.Dossier
.objects
.get(id=dossier_id
)
1009 return HttpResponseNotFound("Ce dossier n'est pas accessible")
1012 data
['personne'] = unicode(dossier
.employe
)
1013 if dossier
.classement
is not None:
1014 data
['classement'] = dossier
.classement
.id
1015 if dossier
.statut
is not None:
1016 data
['statut'] = dossier
.statut
.id
1017 data
['implantation'] = dossier
.poste
.implantation
.id
1018 data
['poste'] = dossier
.poste
.nom
1019 data
['d_id'] = dossier
.id
1020 data
.update(_get_salaire_traitement(dossier
))
1021 return HttpResponse(dumps(data
))
1025 @vieux_dossier_dans_ma_region_ou_service
1026 def poste_resume(request
, dossier_id
=None):
1028 On travaille, en réalité sur le dossier mais on cache
1029 l'identité de la personne.
1032 dossier
= rh
.Dossier
.objects
.get(id=dossier_id
)
1034 return HttpResponseNotFound("Ce dossier n'est pas accessible")
1037 data
['implantation'] = dossier
.poste
.implantation
.id
1038 data
['poste'] = dossier
.poste
.nom
1039 data
['statut'] = dossier
.statut_id
1040 data
['classement'] = dossier
.classement_id
1041 data
['d_id'] = dossier
.id
1042 data
.update(_get_salaire_traitement(dossier
))
1044 return HttpResponse(dumps(data
))
1047 def liste_postes(request
):
1049 input : implantation_id
1050 output : JSON liste de valeur point
1052 method
= request
.method
1053 params
= getattr(request
, method
, [])
1056 if 'implantation_id' in params \
1057 and params
.get('implantation_id') is not u
"":
1058 implantation_id
= params
.get('implantation_id')
1059 q
= Q(implantation__id
=implantation_id
)
1063 postes_rh
= rh
.Poste
.objects
.ma_region_ou_service(request
.user
).filter(q
)
1064 postes_rh
= postes_rh
.select_related(depth
=1)
1066 data
= [('', 'Nouveau poste')] + \
1067 sorted([('rh-%s' % p
.id, label_poste_display(p
)) for p
in
1070 return HttpResponse(dumps(data
))
1074 def dossier_piece(request
, id, filename
):
1075 """Téléchargement d'une pièce jointe à un poste."""
1076 piece
= get_object_or_404(dae
.DossierPiece
, pk
=id)
1077 if dae
.Dossier
.objects
.ma_region_ou_service(request
.user
) \
1078 .filter(id=piece
.dossier_id
).exists():
1079 return sendfile(request
, piece
.fichier
.path
)
1081 return redirect_interdiction(request
)
1084 # AJAX SECURITE non nécessaire
1086 def coefficient(request
):
1089 output : coefficient
1091 method
= request
.method
1092 params
= getattr(request
, method
, [])
1094 if 'classement' in params
and params
.get('classement') is not u
"":
1095 classement
= params
.get('classement')
1096 classement
= rh
.Classement
.objects
.get(pk
=classement
)
1097 data
['coefficient'] = classement
.coefficient
1099 data
['coefficient'] = 0
1100 return HttpResponse(dumps(data
))
1103 def devise(request
):
1105 input : valeur_point
1106 output : devise, devise_code, taux_euro
1108 method
= request
.method
1109 params
= getattr(request
, method
, [])
1111 if 'valeur_point' in params
and params
.get('valeur_point') is not u
"":
1112 valeur_point
= params
.get('valeur_point')
1113 valeur_point
= rh
.ValeurPoint
.objects
.get(pk
=valeur_point
)
1114 annee
= valeur_point
.annee
1116 taux
= rh
.TauxChange
.objects
.get(
1117 annee
=annee
, devise
=valeur_point
.devise
1119 except rh
.TauxChange
.DoesNotExist
:
1120 return HttpResponseNotFound(
1121 u
"Taux de change introuvable pour la devise %s "
1122 u
"pour l'année %d" % (valeur_point
.devise
.code
, annee
)
1124 except rh
.TauxChange
.MultipleObjectsReturned
:
1125 return HttpResponseNotFound(
1126 u
"Il existe plusieurs taux pour la devise %s "
1127 u
"cette année-là : %s" % (valeur_point
.devise
.code
, annee
)
1130 data
['devise'] = taux
.devise
.id
1131 data
['valeur'] = valeur_point
.valeur
1132 data
['devise_code'] = taux
.devise
.code
1133 data
['taux_euro'] = taux
.taux
1135 return HttpResponseNotFound("Vous devez choisir une valeur de point")
1136 return HttpResponse(dumps(data
))
1139 def devise_code(request
):
1142 output : devise_code, taux_euro
1144 method
= request
.method
1145 params
= getattr(request
, method
, [])
1147 if 'devise' in params
:
1148 devise
= params
.get('devise')
1149 devise
= rh
.Devise
.objects
.get(pk
=devise
)
1150 annee
= date
.today().year
1151 taux
= rh
.TauxChange
.objects
.filter(annee
=annee
, devise
=devise
)
1153 return HttpResponseNotFound("Le taux n'est pas disponible")
1154 data
['devise_code'] = devise
.code
1155 data
['taux_euro'] = taux
[0].taux
1156 return HttpResponse(dumps(data
))
1159 def add_remun(request
, dossier
, type_remun
):
1160 dossier
= get_object_or_404(dae
.Dossier
, pk
=dossier
)
1161 type_remun
= get_object_or_404(rh
.TypeRemuneration
, pk
=type_remun
)
1162 dae
.Remuneration(dossier
=dossier
, devise
=dossier
.devise
,
1163 type=type_remun
).save()
1168 return render(request
, 'dae/embauche-remun.html', c
)
1171 def salaire(request
, implantation
, devise
, classement
):
1172 if not devise
or not classement
:
1175 taux
= rh
.TauxChange
.objects
.filter(devise
=devise
).order_by('-annee')
1176 vp
= rh
.ValeurPoint
.objects \
1177 .filter(implantation
=implantation
, devise
=devise
) \
1181 status
= u
"pas de valeur de point pour le couple \
1182 implantation/devise (%s/%s)" % (implantation
, devise
)
1183 return HttpResponse(dumps(dict(status
=status
)))
1185 if taux
.count() == 0:
1186 status
= u
"Pas de taux pour la devise %s" % devise
1187 return HttpResponse(dumps(dict(status
=status
)))
1189 classement
= get_object_or_404(rh
.Classement
, pk
=classement
)
1190 if classement
.coefficient
is None:
1192 taux
, vp
= taux
[0].taux
, vp
[0].valeur
1194 salaire_euro
= round(vp
* classement
.coefficient
* taux
, 2)
1195 data
= dict(status
='OK',
1196 salaire_euro
=salaire_euro
, taux
=taux
,
1197 salaire_devise
=round(salaire_euro
/ taux
, 2))
1199 return HttpResponse(dumps(data
))
1202 def liste_valeurs_point(request
):
1204 input : implantation_id
1205 output : JSON liste de valeur point
1207 method
= request
.method
1208 params
= getattr(request
, method
, [])
1210 annee_courante
= datetime
.now().year
1211 if 'implantation_id' in params \
1212 and params
.get('implantation_id') is not u
"":
1213 implantation_id
= params
.get('implantation_id')
1214 preselectionne
= rh
.ValeurPoint
.objects \
1215 .filter(implantation
=implantation_id
, annee
=annee_courante
) \
1217 for o
in preselectionne
:
1220 'label': o
.__unicode__(),
1221 'devise': o
.devise_id
,
1225 preselectionne
= rh
.ValeurPoint
.objects
.none()
1227 liste_complete
= rh
.ValeurPoint
.objects \
1228 .filter(annee__in
=(annee_courante
,)) \
1230 for o
in liste_complete
.exclude(id__in
=[p
.id for p
in preselectionne
]):
1233 'label': o
.__unicode__(),
1234 'devise': o
.devise_id
,
1237 return HttpResponse(dumps(data
, indent
=4))