ce6172822ac18672d1f71225c48c028fa2c3a001
[auf_rh_dae.git] / project / rh / lib.py
1 # -*- encoding: utf-8 -*-
2
3 from collections import defaultdict
4 import datetime
5
6 from django.db import models
7 from django import forms
8 from django.core.urlresolvers import reverse
9 from django.contrib import admin
10 from django.conf import settings
11 from django.db.models import Q
12 from auf.django.metadata.admin import AUFMetadataAdminMixin, AUFMetadataInlineAdminMixin, AUF_METADATA_READONLY_FIELDS
13 from project.rh import models as rh
14 from forms import DossierForm, ContratForm
15 from dae.utils import get_employe_from_user
16
17
18
19 # Override of the InlineModelAdmin to support the link in the tabular inline
20 class LinkedInline(admin.options.InlineModelAdmin):
21 template = "admin/linked.html"
22 admin_model_path = None
23
24 def __init__(self, *args):
25 super(LinkedInline, self).__init__(*args)
26 if self.admin_model_path is None:
27 self.admin_model_path = self.model.__name__.lower()
28
29
30 class ProtectRegionMixin(object):
31
32 def queryset(self, request):
33 from dae.workflow import grp_drh, grp_correspondants_rh
34 qs = super(ProtectRegionMixin, self).queryset(request)
35
36 if request.user.is_superuser:
37 return qs
38
39 user_groups = request.user.groups.all()
40
41 if grp_drh in user_groups:
42 return qs
43
44 if grp_correspondants_rh in user_groups:
45 employe = get_employe_from_user(request.user)
46 q = Q(**{self.model.prefix_implantation: employe.implantation.region})
47 qs = qs.filter(q).distinct()
48 return qs
49 return qs.none()
50
51 def has_change_permission(self, request, obj=None):
52 if obj is None:
53 return True
54 ids = [o.id for o in self.queryset(request)]
55 return obj.id in ids
56
57
58 # Inlines
59
60 class ReadOnlyInlineMixin(object):
61 def get_readonly_fields(self, request, obj=None):
62 return [f.name for f in self.model._meta.fields if f.name not in AUF_METADATA_READONLY_FIELDS]
63
64
65 class AyantDroitInline(AUFMetadataInlineAdminMixin, admin.StackedInline):
66 model = models.Model # à remplacer dans admin.py
67 extra = 0
68
69 fieldsets = (
70 (None, {
71 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', 'lien_parente', )
72 }),
73 )
74
75
76 class AyantDroitCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
77 readonly_fields = ('owner', )
78 model = models.Model # à remplacer dans admin.py
79 extra = 1
80
81
82 class ContratInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
83 form = ContratForm
84 model = models.Model # à remplacer dans admin.py
85 extra = 1
86
87
88 class DossierROInline(ReadOnlyInlineMixin, LinkedInline):
89 template = "admin/rh/dossier/linked.html"
90 exclude = AUF_METADATA_READONLY_FIELDS
91 model = models.Model # à remplacer dans admin.py
92 extra = 0
93 can_delete = False
94
95 def has_add_permission(self, request=None):
96 return False
97
98 def has_change_permission(self, request, obj=None):
99 return False
100
101 def has_delete_permission(self, request, obj=None):
102 return False
103
104
105 class DossierCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
106 readonly_fields = ('owner', )
107 model = models.Model # à remplacer dans admin.py
108 extra = 1
109
110
111 class DossierPieceInline(admin.TabularInline):
112 model = models.Model # à remplacer dans admin.py
113 extra = 4
114
115
116 class EmployeInline(admin.TabularInline):
117 model = models.Model # à remplacer dans admin.py
118
119 class EmployeCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
120 readonly_fields = ('owner', )
121 model = models.Model # à remplacer dans admin.py
122 extra = 1
123
124
125 class EmployePieceInline(admin.TabularInline):
126 model = models.Model # à remplacer dans admin.py
127 extra = 4
128
129
130 class EvenementInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
131 model = models.Model # à remplacer dans admin.py
132 extra = 1
133
134
135 class EvenementRemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
136 model = models.Model # à remplacer dans admin.py
137 extra = 1
138
139
140 class PosteCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
141 readonly_fields = ('owner', )
142 model = models.Model # à remplacer dans admin.py
143 extra = 1
144
145
146 class PosteFinancementInline(admin.TabularInline):
147 model = models.Model # à remplacer dans admin.py
148
149
150 class PostePieceInline(admin.TabularInline):
151 model = models.Model # à remplacer dans admin.py
152
153
154 class RemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
155 model = models.Model # à remplacer dans admin.py
156 extra = 1
157
158
159 class RemunerationROInline(ReadOnlyInlineMixin, RemunerationInline):
160 pass
161
162
163 class TypePosteInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
164 model = models.Model # à remplacer dans admin.py
165
166
167 # Admins
168
169 class AyantDroitAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
170 """
171 L'ajout d'un nouvel ayantdroit se fait dans l'admin de l'employé.
172 """
173 alphabet_filter = 'nom'
174 search_fields = ('nom', 'prenom', 'employe__nom', 'employe__prenom', )
175 list_display = ('_employe', 'lien_parente', '_ayantdroit', )
176 inlines = (AyantDroitCommentaireInline,)
177 readonly_fields = AUFMetadataAdminMixin.readonly_fields + ('employe',)
178 fieldsets = AUFMetadataAdminMixin.fieldsets + (
179 ("Lien avec l'employé", {
180 'fields': (('employe', 'lien_parente'), )
181 }),
182
183 ('Identification', {
184 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
185 }),
186 )
187
188 def save_formset(self, request, form, formset, change):
189 instances = formset.save(commit=False)
190 for instance in instances:
191 if instance.__class__ == rh.AyantDroitCommentaire:
192 instance.owner = request.user
193 instance.save()
194
195 def _ayantdroit(self, obj):
196 return unicode(obj)
197 _ayantdroit.short_description = u'Ayant droit'
198
199 def _employe(self, obj):
200 return unicode(obj.employe)
201 _employe.short_description = u'Employé'
202
203 def has_add_permission(self, request):
204 return False
205
206 class AyantDroitCommentaireAdmin(admin.ModelAdmin):
207 pass
208
209
210 class ClassementAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
211 fieldsets = AUFMetadataAdminMixin.fieldsets + (
212 (None, {
213 'fields': ('type', 'echelon', 'degre', 'coefficient', )
214 }),
215 )
216
217
218 class CommentaireAdmin(admin.ModelAdmin):
219 pass
220
221
222 #class ContratAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
223 # form = ContratForm
224 # alphabet_filter = 'dossier__employe__nom'
225 # search_fields = ('dossier__employe__nom', 'dossier__employe__prenom', 'dossier__poste__nom', 'dossier__poste__nom_feminin', )
226 # list_display = ('id', '_employe', '_poste', 'date_debut', 'date_fin', '_implantation', )
227 # fieldsets = AUFMetadataAdminMixin.fieldsets + (
228 # (None, {
229 # 'fields': ('dossier', 'type_contrat', 'date_debut', 'date_fin', )
230 # }),
231 # )
232 #
233 # def lookup_allowed(self, key, value):
234 # if key in ('dossier__employe__nom__istartswith', ):
235 # return True
236 #
237 # def _employe(self, obj):
238 # return unicode(obj.dossier.employe)
239 # _employe.short_description = "Employé"
240 #
241 # def _poste(self, obj):
242 # return obj.dossier.poste.nom
243 # _poste.short_description = "Poste"
244 #
245 # def _implantation(self, obj):
246 # return obj.dossier.poste.implantation
247 # _poste.short_description = "Implantation"
248
249 class DeviseAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
250 fieldsets = AUFMetadataAdminMixin.fieldsets + (
251 (None, {
252 'fields': ('code', 'nom', ),
253 }),
254 )
255
256
257 class DossierAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin,):
258 form = DossierForm
259 alphabet_filter = 'employe__nom'
260 search_fields = ('employe__nom', 'employe__prenom', 'poste__nom', 'poste__nom_feminin')
261 list_display = ('_id', '_employe', '_actif', '_poste', 'date_debut', 'date_fin', 'date_modification')
262 list_filter = ('poste__implantation__region', 'poste__implantation', )
263 inlines = (DossierPieceInline, ContratInline,
264 RemunerationInline,
265 #EvenementInline,
266 DossierCommentaireInline,
267 )
268 fieldsets = AUFMetadataAdminMixin.fieldsets + (
269 (None, {
270 'fields': ('employe', 'poste', 'statut', 'organisme_bstg',)
271 }),
272 ('Recrutement', {
273 'fields': ('statut_residence', 'remplacement', 'remplacement_de', )
274 }),
275 ('Rémunération', {
276 'fields': ('classement', ('regime_travail', 'regime_travail_nb_heure_semaine'),)
277 }),
278 ('Occupation du Poste par cet Employe', {
279 'fields': (('date_debut', 'date_fin'), )
280 }),
281 )
282
283 class Media:
284 js = ('js/dossier.js',)
285
286 def lookup_allowed(self, key, value):
287 if key in (
288 'employe__nom__istartswith',
289 'actif__exact',
290 'poste__implantation__region__id__exact',
291 'poste__implantation__id__exact',
292 ):
293 return True
294
295 def _id(self, d):
296 link = u"""<a onclick="return showAddAnotherPopup(this);" href='%s'>%s</a> <a href="%s" title="Modifier le dossier"><img src="%simg/page_edit.png" /></a>""" % \
297 (reverse('dossier_apercu', args=(d.id,)),
298 d.id,
299 reverse('admin:rh_dossier_change', args=(d.id,)),
300 settings.MEDIA_URL,
301 )
302 return link
303 _id.allow_tags = True
304 _id.short_description = u'Numéro de dossier'
305 _id.admin_order_field = 'id'
306
307
308 def _actif(self, dossier):
309 if dossier.employe.actif:
310 html = """<img alt="True" src="%simg/admin/icon-yes.gif">"""
311 else:
312 html = """<img alt="False" src="%simg/admin/icon-no.gif">"""
313 return html % settings.ADMIN_MEDIA_PREFIX
314 _actif.allow_tags = True
315 _actif.short_description = u'Employé actif'
316 _actif.admin_order_field = 'employe__actif'
317
318 def _poste(self, dossier):
319 link = u"""<a onclick="return showAddAnotherPopup(this);" href='%s'>%s</a> <a href="%s" title="Modifier le poste"><img src="%simg/page_edit.png" /></a>""" % \
320 (reverse('poste_apercu', args=(dossier.poste.id,)),
321 dossier.poste,
322 reverse('admin:rh_poste_change', args=(dossier.poste.id,)),
323 settings.MEDIA_URL,
324 )
325 return link
326 _poste.allow_tags = True
327 _poste.short_description = u'Poste'
328 _poste.admin_order_field = 'poste__nom'
329
330 def _employe(self, obj):
331 employe = obj.employe
332 view_link = reverse('employe_apercu', args=(employe.id,))
333 edit_link = reverse('admin:rh_employe_change', args=(employe.id,))
334 return u"""<a onclick="return showAddAnotherPopup(this);" href='%s'>[%s] %s %s</a>
335 <a href="%s" title="Modifier l'employé"><img src="%simg/user_edit.png" /></a>""" % \
336 (view_link, employe.id, employe.nom.upper(), employe.prenom.title(), edit_link, settings.MEDIA_URL,)
337 _employe.allow_tags = True
338 _employe.short_description = u"Employé ([code] NOM Prénom)"
339 _employe.admin_order_field = "employe__nom"
340
341 def save_formset(self, request, form, formset, change):
342 instances = formset.save(commit=False)
343 for instance in instances:
344 if instance.__class__ == rh.DossierCommentaire:
345 instance.owner = request.user
346 instance.save()
347
348
349 class DossierPieceAdmin(admin.ModelAdmin):
350 pass
351
352
353 class DossierCommentaireAdmin(admin.ModelAdmin):
354 pass
355
356
357 class EmployeAdminForm(forms.ModelForm):
358 class Meta:
359 model = rh.Employe
360
361 def __init__(self, *args, **kwargs):
362 super(EmployeAdminForm, self).__init__(*args, **kwargs)
363 self.fields['date_naissance'].widget = forms.widgets.DateInput()
364
365
366 class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
367 alphabet_filter = 'nom'
368 DEFAULT_ALPHABET = u'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
369 search_fields = ('id', 'nom', 'prenom', 'nom_affichage', )
370 ordering = ('nom', )
371 actions = ('desactiver', )
372 form = EmployeAdminForm
373 list_display = ('_nom', '_dossiers', 'date_modification', 'user_modification',)
374 list_filter = ('rh_dossiers__poste__implantation__region', 'rh_dossiers__poste__implantation', 'actif', )
375 inlines = (AyantDroitInline,
376 DossierROInline,
377 EmployePieceInline,
378 EmployeCommentaireInline)
379 fieldsets = AUFMetadataAdminMixin.fieldsets + (
380 ('Identification', {
381 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
382 }),
383 ('Informations personnelles', {
384 'fields': ('situation_famille', 'date_entree', )
385 }),
386 ('Coordonnées', {
387 'fields': (('tel_domicile', 'tel_cellulaire'), ('adresse', 'ville'), ('code_postal', 'province'), 'pays', )
388 }),
389 )
390
391 def _nom(self, obj):
392 view_link = reverse('employe_apercu', args=(obj.id,))
393 edit_link = reverse('admin:rh_employe_change', args=(obj.id,))
394 return u"""<a onclick="return showAddAnotherPopup(this);" href='%s'>[%s] %s %s</a>
395 <a href="%s" title="Modifier l'employé"><img src="%simg/user_edit.png" /></a>""" % \
396 (view_link, obj.id, obj.nom.upper(), obj.prenom.title(), edit_link, settings.MEDIA_URL,)
397 _nom.allow_tags = True
398 _nom.short_description = u"Employé ([code] NOM Prénom)"
399 _nom.admin_order_field = "nom"
400
401 def _dossiers(self, obj):
402 l = []
403 for d in obj.dossiers.all().order_by('-date_debut'):
404 style = ""
405 if d.date_fin is not None:
406 style = "color: grey";
407 link = u"""<li><a style="%s;" onclick="return showAddAnotherPopup(this);" href='%s'>%s : %s</a> <a href="%s" title="Modifier le dossier"><img src="%simg/page_edit.png" /></a> </li>""" % \
408 (style,
409 reverse('dossier_apercu', args=(d.id,)),
410 d.date_debut.year,
411 d.poste,
412 reverse('admin:rh_dossier_change', args=(d.id,)),
413 settings.MEDIA_URL,
414 )
415 l.append(link)
416 return "<ul>%s</ul>" % "\n".join(l)
417 _dossiers.allow_tags = True
418
419 def queryset(self, request):
420 qs = super(EmployeAdmin, self).queryset(request)
421 return qs.filter(actif=True).select_related(depth=1).order_by('nom')
422
423 def save_formset(self, request, form, formset, change):
424 instances = formset.save(commit=False)
425 for instance in instances:
426 if instance.__class__ == rh.EmployeCommentaire:
427 instance.owner = request.user
428 instance.save()
429
430
431
432 class EmployeCommentaireAdmin(admin.ModelAdmin):
433 pass
434
435
436 class EmployePieceAdmin(admin.ModelAdmin):
437 pass
438
439
440 class EvenementAdmin(admin.ModelAdmin):
441 inlines = (EvenementRemunerationInline,)
442
443
444 class EvenementRemunerationAdmin(admin.ModelAdmin):
445 pass
446
447
448 class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
449 inlines = (TypePosteInline,)
450 fieldsets = AUFMetadataAdminMixin.fieldsets + (
451 (None, {
452 'fields': ('nom', )
453 }),
454 )
455
456
457 class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
458 search_fields = ('nom', )
459 list_display = ('nom', 'type', 'pays', )
460 inlines = (DossierROInline,)
461 fieldsets = AUFMetadataAdminMixin.fieldsets + (
462 (None, {
463 'fields': ('nom', 'type', 'pays', )
464 }),
465 )
466
467
468 class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
469 alphabet_filter = 'nom'
470 search_fields = ('nom',
471 'implantation__code',
472 'implantation__nom',
473 'implantation__region__code',
474 'implantation__region__nom',
475 )
476 list_display = (
477 '_nom',
478 '_occupe_par',
479 'implantation',
480 'service',
481 'date_debut',
482 'date_fin',
483 'date_modification',
484 'user_modification',
485 )
486 list_filter = ('service',
487 'implantation__region',
488 'implantation',
489 )
490 fieldsets = AUFMetadataAdminMixin.fieldsets + (
491 (None, {
492 'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
493 'service', 'responsable')
494 }),
495 ('Contrat', {
496 'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
497 }),
498 ('Recrutement', {
499 'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
500 }),
501 ('Rémunération', {
502 'fields': (('classement_min', 'classement_max'),
503 ('valeur_point_min', 'valeur_point_max'),
504 ('devise_min', 'devise_max'),
505 ('salaire_min', 'salaire_max'),
506 ('indemn_min', 'indemn_max'),
507 ('autre_min', 'autre_max'))
508 }),
509 ('Comparatifs de rémunération', {
510 'fields': ('devise_comparaison',
511 ('comp_locale_min', 'comp_locale_max'),
512 ('comp_universite_min', 'comp_universite_max'),
513 ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
514 ('comp_ong_min', 'comp_ong_max'),
515 ('comp_autre_min', 'comp_autre_max'))
516 }),
517 ('Justification', {
518 'fields': ('justification',)
519 }),
520 ('Autres Metadata', {
521 'fields': ('date_validation', ('date_debut', 'date_fin'))
522 }),
523 )
524
525 inlines = (PosteFinancementInline,
526 PostePieceInline,
527 DossierROInline,
528 PosteCommentaireInline, )
529
530 def _nom(self, poste):
531 link = u"""<a onclick="return showAddAnotherPopup(this);" href='%s'>%s</a> <a href="%s" title="Modifier le poste"><img src="%simg/page_edit.png" /></a>""" % \
532 (reverse('poste_apercu', args=(poste.id,)),
533 poste.nom,
534 reverse('admin:rh_poste_change', args=(poste.id,)),
535 settings.MEDIA_URL,
536 )
537 return link
538 _nom.allow_tags = True
539 _nom.short_description = u'Nom'
540 _nom.admin_order_field = 'nom'
541
542 def _occupe_par(self, obj):
543 """Formatte la méthode Poste.occupe_par() pour l'admin"""
544 output = "VACANT"
545 employes = obj.occupe_par()
546 if employes:
547 l = []
548 for e in employes:
549 link = "<a href='%s'>%s</a>" % \
550 (reverse('admin:rh_employe_change', args=(e.id,)),
551 e)
552 l.append(link)
553 output = "\n<br />".join(l)
554 return output
555 _occupe_par.allow_tags = True
556 _occupe_par.short_description = "Occupé par"
557
558 def save_formset(self, request, form, formset, change):
559 instances = formset.save(commit=False)
560 for instance in instances:
561 if instance.__class__ == rh.PosteCommentaire:
562 instance.owner = request.user
563 instance.save()
564 formset.save_m2m()
565
566
567 class PosteCommentaireAdmin(admin.ModelAdmin):
568 pass
569
570
571 class PosteFinancementAdmin(admin.ModelAdmin):
572 pass
573
574
575 class PostePieceAdmin(admin.ModelAdmin):
576 fk_name = 'poste'
577
578
579 class RemunerationAdmin(admin.ModelAdmin):
580 pass
581
582
583 class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
584 fieldsets = AUFMetadataAdminMixin.fieldsets + (
585 (None, {
586 'fields': ('employe', 'implantation', ),
587 }),
588 )
589
590
591 class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
592 list_display = ('nom', 'actif', )
593 fieldsets = AUFMetadataAdminMixin.fieldsets + (
594 (None, {
595 'fields': ('nom', ),
596 }),
597 )
598
599 class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
600 fieldsets = AUFMetadataAdminMixin.fieldsets + (
601 (None, {
602 'fields': ('code', 'nom', ),
603 }),
604 )
605
606 class TauxChangeAdmin(admin.ModelAdmin):
607 list_display = ('taux', 'devise', 'annee', )
608 list_filter = ('devise', )
609 fieldsets = AUFMetadataAdminMixin.fieldsets + (
610 (None, {
611 'fields': ('taux', 'devise', 'annee', ),
612 }),
613 )
614
615 class TypeContratAdmin(admin.ModelAdmin):
616 inlines = (ContratInline,)
617 fieldsets = AUFMetadataAdminMixin.fieldsets + (
618 (None, {
619 'fields': ('nom', 'nom_long', ),
620 }),
621 )
622
623
624 class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
625 search_fields = ('nom', 'nom_feminin', )
626 list_display = ('nom', 'famille_emploi', )
627 list_filter = ('famille_emploi', )
628 fieldsets = AUFMetadataAdminMixin.fieldsets + (
629 (None, {
630 'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi', )
631 }),
632 )
633
634
635 class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
636 list_display = ('nom', 'type_paiement', 'nature_remuneration', )
637 #inlines = (RemunerationROInline,) utilité?
638 fieldsets = AUFMetadataAdminMixin.fieldsets + (
639 (None, {
640 'fields': ('nom', 'type_paiement', 'nature_remuneration', )
641 }),
642 )
643
644
645 class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
646 #inlines = (RemunerationROInline,) utilité?
647 fieldsets = AUFMetadataAdminMixin.fieldsets + (
648 (None, {
649 'fields': ('nom', )
650 }),
651 )
652
653
654 class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
655 list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
656 fieldsets = AUFMetadataAdminMixin.fieldsets + (
657 (None, {
658 'fields': ('valeur', 'devise', 'implantation', 'annee', )
659 }),
660 )
661
662 def _devise_code(self, obj):
663 return obj.devise.code
664 _devise_code.short_description = "Code de la devise"
665
666 def _devise_nom(self, obj):
667 return obj.devise.nom
668 _devise_nom.short_description = "Nom de la devise"
669
670
671 def calc_remun(dossier):
672 thisyear = datetime.date.today().year
673 thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
674
675 remunnow = dossier.rh_remuneration_remunerations.filter(thisyearfilter)
676
677 remun_sum = 0
678 remun_sum_euro = 0
679 sums = defaultdict(int)
680 sums_euro = defaultdict(int)
681 for r in remunnow:
682 nature = r.type.nature_remuneration
683 sums[nature] += r.montant
684 sums_euro[nature] += r.montant_euro()
685 remun_sum += r.montant
686 remun_sum_euro += r.montant_euro()
687
688 remun = {}
689 sums = dict(sums)
690 for n, s in sums.iteritems():
691 remun[n] = [sums[n], sums_euro[n]]
692
693 return remun, remun_sum, remun_sum_euro