Refactor pour somme remun
[auf_rh_dae.git] / project / rh / lib.py
CommitLineData
6e7c919b
NC
1# -*- encoding: utf-8 -*-
2
8d3e2fff
PP
3from collections import defaultdict
4import datetime
5
babf71ec 6from django.db import models
6e7c919b 7from django.contrib import admin
49449367 8from django.conf import settings
aff1a4c6 9from django.db.models import Q
d6985a3a 10from auf.django.metadata.admin import AUFMetadataAdminMixin, AUFMetadataInlineAdminMixin, AUF_METADATA_READONLY_FIELDS
babf71ec 11from project.rh import models as rh
84cbb4c5 12from forms import DossierForm, ContratForm
aff1a4c6
PP
13from dae.utils import get_employe_from_user
14
15
6318ebea
PP
16# Override of the InlineModelAdmin to support the link in the tabular inline
17class LinkedInline(admin.options.InlineModelAdmin):
18 template = "admin/linked.html"
19 admin_model_path = None
20
21 def __init__(self, *args):
22 super(LinkedInline, self).__init__(*args)
23 if self.admin_model_path is None:
24 self.admin_model_path = self.model.__name__.lower()
25
26
aff1a4c6
PP
27class ProtectRegionMixin(object):
28
29 def queryset(self, request):
30 qs = super(ProtectRegionMixin, self).queryset(request)
31
32 if request.user.is_superuser:
33 return qs
34
35 employe = get_employe_from_user(request.user)
36
37 q = Q(**{self.model.prefix_implantation: employe.implantation.region})
38 qs = qs.filter(q).distinct()
39 return qs
40
41 def has_change_permission(self, request, obj=None):
42 if request.user.is_superuser:
43 return True
44
45 if obj:
46 employe = get_employe_from_user(request.user)
47 if employe.implantation.region in obj.get_regions():
48 return True
49 else:
50 return False
51
52 return True
53
6e7c919b 54
d6985a3a 55# Inlines
6e7c919b 56
d6985a3a
OL
57class ReadOnlyInlineMixin(object):
58 def get_readonly_fields(self, request, obj=None):
59 return [f.name for f in self.model._meta.fields if f.name not in AUF_METADATA_READONLY_FIELDS]
6e7c919b
NC
60
61
51ab4c2c 62class AyantDroitInline(AUFMetadataInlineAdminMixin, admin.StackedInline):
babf71ec 63 model = models.Model # à remplacer dans admin.py
51ab4c2c 64 extra = 0
54d04eed 65
972f50e4
PP
66 fieldsets = (
67 (None, {
68 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', 'lien_parente', )
69 }),
70 )
71
d6985a3a
OL
72
73class AyantDroitCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
cf786fb2 74 readonly_fields = ('owner', )
babf71ec 75 model = models.Model # à remplacer dans admin.py
cf786fb2 76 extra = 1
6e7c919b 77
54d04eed 78
d6985a3a 79class ContratInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
84cbb4c5 80 form = ContratForm
babf71ec 81 model = models.Model # à remplacer dans admin.py
1f2979b8 82 extra = 1
babf71ec
NC
83
84
6318ebea 85class DossierROInline(ReadOnlyInlineMixin, LinkedInline):
d6985a3a 86 exclude = AUF_METADATA_READONLY_FIELDS
babf71ec 87 model = models.Model # à remplacer dans admin.py
54773196 88 extra = 0
babf71ec 89
d6985a3a
OL
90
91class DossierCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
1f2979b8 92 readonly_fields = ('owner', )
babf71ec 93 model = models.Model # à remplacer dans admin.py
1f2979b8 94 extra = 1
babf71ec 95
d6985a3a 96
babf71ec
NC
97class DossierPieceInline(admin.TabularInline):
98 model = models.Model # à remplacer dans admin.py
988af3fb 99 extra = 4
babf71ec
NC
100
101
102class EmployeInline(admin.TabularInline):
103 model = models.Model # à remplacer dans admin.py
104
d6985a3a 105class EmployeCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
cf786fb2 106 readonly_fields = ('owner', )
babf71ec 107 model = models.Model # à remplacer dans admin.py
cf786fb2 108 extra = 1
babf71ec
NC
109
110
111class EmployePieceInline(admin.TabularInline):
112 model = models.Model # à remplacer dans admin.py
988af3fb 113 extra = 4
babf71ec
NC
114
115
d6985a3a 116class EvenementInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
babf71ec 117 model = models.Model # à remplacer dans admin.py
1f2979b8 118 extra = 1
babf71ec
NC
119
120
d6985a3a 121class EvenementRemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
babf71ec 122 model = models.Model # à remplacer dans admin.py
1f2979b8 123 extra = 1
babf71ec
NC
124
125
d6985a3a 126class PosteCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
70561dc2 127 readonly_fields = ('owner', )
babf71ec 128 model = models.Model # à remplacer dans admin.py
70561dc2 129 extra = 1
babf71ec
NC
130
131
132class PosteFinancementInline(admin.TabularInline):
133 model = models.Model # à remplacer dans admin.py
134
135
136class PostePieceInline(admin.TabularInline):
137 model = models.Model # à remplacer dans admin.py
138
139
d6985a3a 140class RemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
babf71ec 141 model = models.Model # à remplacer dans admin.py
1f2979b8 142 extra = 1
babf71ec
NC
143
144
d6985a3a 145class RemunerationROInline(ReadOnlyInlineMixin, RemunerationInline):
6e7c919b
NC
146 pass
147
54d04eed 148
26dacccc 149class TypePosteInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
babf71ec
NC
150 model = models.Model # à remplacer dans admin.py
151
152
153# Admins
154
aff1a4c6 155class AyantDroitAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
cf786fb2
OL
156 """
157 L'ajout d'un nouvel ayantdroit se fait dans l'admin de l'employé.
158 """
387ab827 159 alphabet_filter = 'nom'
cf786fb2 160 search_fields = ('nom', 'prenom', 'employe__nom', 'employe__prenom', )
1a89b1f3 161 list_display = ('_employe', 'lien_parente', '_ayantdroit', )
babf71ec 162 inlines = (AyantDroitCommentaireInline,)
d6985a3a
OL
163 readonly_fields = AUFMetadataAdminMixin.readonly_fields + ('employe',)
164 fieldsets = AUFMetadataAdminMixin.fieldsets + (
cf786fb2 165 ("Lien avec l'employé", {
76e26dfc 166 'fields': (('employe', 'lien_parente'), )
cf786fb2
OL
167 }),
168
169 ('Identification', {
76e26dfc 170 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
cf786fb2
OL
171 }),
172 )
173
174 def save_formset(self, request, form, formset, change):
175 instances = formset.save(commit=False)
176 for instance in instances:
177 if instance.__class__ == rh.AyantDroitCommentaire:
178 instance.owner = request.user
179 instance.save()
cf786fb2
OL
180
181 def _ayantdroit(self, obj):
182 return unicode(obj)
183 _ayantdroit.short_description = u'Ayant droit'
babf71ec 184
cf786fb2
OL
185 def _employe(self, obj):
186 return unicode(obj.employe)
187 _employe.short_description = u'Employé'
188
189 def has_add_permission(self, request):
190 return False
babf71ec
NC
191
192class AyantDroitCommentaireAdmin(admin.ModelAdmin):
6e7c919b
NC
193 pass
194
54d04eed 195
324bf312
OL
196class ClassementAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
197 fieldsets = AUFMetadataAdminMixin.fieldsets + (
198 (None, {
199 'fields': ('type', 'echelon', 'degre', 'coefficient', )
200 }),
201 )
202
6e7c919b 203
6e7c919b
NC
204class CommentaireAdmin(admin.ModelAdmin):
205 pass
206
207
84cbb4c5
OL
208#class ContratAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
209# form = ContratForm
210# alphabet_filter = 'dossier__employe__nom'
211# search_fields = ('dossier__employe__nom', 'dossier__employe__prenom', 'dossier__poste__nom', 'dossier__poste__nom_feminin', )
212# list_display = ('id', '_employe', '_poste', 'date_debut', 'date_fin', '_implantation', )
213# fieldsets = AUFMetadataAdminMixin.fieldsets + (
214# (None, {
215# 'fields': ('dossier', 'type_contrat', 'date_debut', 'date_fin', )
216# }),
217# )
218#
219# def lookup_allowed(self, key, value):
220# if key in ('dossier__employe__nom__istartswith', ):
221# return True
222#
223# def _employe(self, obj):
224# return unicode(obj.dossier.employe)
225# _employe.short_description = "Employé"
226#
227# def _poste(self, obj):
228# return obj.dossier.poste.nom
229# _poste.short_description = "Poste"
230#
231# def _implantation(self, obj):
232# return obj.dossier.poste.implantation
233# _poste.short_description = "Implantation"
54d04eed 234
84fc088b
OL
235class DeviseAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
236 fieldsets = AUFMetadataAdminMixin.fieldsets + (
237 (None, {
238 'fields': ('code', 'nom', ),
239 }),
240 )
6e7c919b 241
54d04eed 242
aff1a4c6 243class DossierAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin,):
84cbb4c5 244 form = DossierForm
387ab827 245 alphabet_filter = 'employe__nom'
d8d7985b 246 search_fields = ('employe__nom', 'employe__prenom', 'poste__nom', 'poste__nom_feminin')
55ca522c 247 list_display = ('_employe', '_poste', 'date_debut', 'date_fin', 'date_modification', '_actif')
1f2979b8 248 inlines = (DossierPieceInline, ContratInline,
cf786fb2
OL
249 RemunerationInline,
250 #EvenementInline,
251 DossierCommentaireInline,
1f2979b8 252 )
d6985a3a 253 fieldsets = AUFMetadataAdminMixin.fieldsets + (
5961a2c9
PP
254 (None, {
255 'fields': ('statut', 'organisme_bstg',)
1f2979b8
OL
256 }),
257 ('Recrutement', {
7c182958 258 'fields': ('statut_residence', 'remplacement', 'remplacement_de', )
1f2979b8
OL
259 }),
260 ('Rémunération', {
cb962802 261 'fields': ('classement', ('regime_travail', 'regime_travail_nb_heure_semaine'),)
1f2979b8
OL
262 }),
263 ('Occupation du Poste par cet Employe', {
cb962802 264 'fields': (('date_debut', 'date_fin'), )
1f2979b8
OL
265 }),
266 )
54d04eed 267
7c182958
PP
268 class Media:
269 js = ('js/dossier.js',)
270
387ab827 271 def lookup_allowed(self, key, value):
49449367 272 if key in ('employe__nom__istartswith', 'actif__exact', ):
387ab827
OL
273 return True
274
49449367
OL
275 def _actif(self, dossier):
276 if dossier.employe.actif:
277 html = """<img alt="True" src="%simg/admin/icon-yes.gif">"""
278 else:
279 html = """<img alt="False" src="%simg/admin/icon-no.gif">"""
280 return html % settings.ADMIN_MEDIA_PREFIX
281 _actif.allow_tags = u'Employé actif'
282 _actif.short_description = u'Employé actif'
283 _actif.admin_order_field = 'employe__actif'
387ab827 284
54d04eed
NC
285 def _poste(self, dossier):
286 return unicode(dossier.poste.nom)
287 _poste.short_description = u'Poste'
d9836879 288 _poste.admin_order_field = 'poste__nom'
54d04eed
NC
289
290 def _employe(self, dossier):
291 return unicode(dossier.employe)
292 _employe.short_description = u'Employé'
d9836879
OL
293 _employe.admin_order_field = 'employe__nom'
294
1f2979b8
OL
295 def save_formset(self, request, form, formset, change):
296 instances = formset.save(commit=False)
297 for instance in instances:
298 if instance.__class__ == rh.DossierCommentaire:
299 instance.owner = request.user
300 instance.save()
6e7c919b 301
8d3e2fff 302 def render_change_form(self, request, context, *args, **kwargs):
49c98347 303 obj = kwargs.get('obj', None)
8d3e2fff 304
49c98347
PP
305 if not obj:
306 return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
8d3e2fff 307
8d3e2fff 308
49c98347 309 remun, remun_sum, remun_sum_euro = calc_remun(obj)
8d3e2fff
PP
310
311 extra = {
312 'remun': remun,
313 'remun_sum': remun_sum,
314 'remun_sum_euro': remun_sum_euro,
5961a2c9
PP
315 'employe': obj.employe,
316 'poste_nom': obj.poste.nom,
317 'poste_service': obj.poste.service,
318 'poste_implantation': obj.poste.implantation,
8d3e2fff
PP
319 }
320
321 context.update(extra)
322
323 return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
324
325
6e7c919b
NC
326class DossierPieceAdmin(admin.ModelAdmin):
327 pass
328
54d04eed 329
6e7c919b
NC
330class DossierCommentaireAdmin(admin.ModelAdmin):
331 pass
332
54d04eed 333
aff1a4c6 334class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
7ffc5aa4 335 alphabet_filter = 'nom'
49449367
OL
336 search_fields = ('id', 'nom', 'prenom', 'nom_affichage', 'actif', )
337 list_filter = ('actif', )
338 ordering = ('nom', )
339 actions = ('desactiver', )
54773196
PP
340 list_display = ('id', 'nom', 'prenom', 'actif', )
341 list_display_links = ('id', 'nom',)
babf71ec
NC
342 inlines = (AyantDroitInline,
343 DossierROInline,
344 EmployePieceInline,
345 EmployeCommentaireInline)
d6985a3a 346 fieldsets = AUFMetadataAdminMixin.fieldsets + (
cf786fb2 347 ('Identification', {
e35610f5 348 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
cf786fb2
OL
349 }),
350 ('Informations personnelles', {
351 'fields': ('situation_famille', 'date_entree', )
352 }),
353 ('Coordonnées', {
e35610f5 354 'fields': (('tel_domicile', 'tel_cellulaire'), ('adresse', 'ville'), ('code_postal', 'province'), 'pays', )
cf786fb2
OL
355 }),
356 )
babf71ec 357
cf786fb2
OL
358 def save_formset(self, request, form, formset, change):
359 instances = formset.save(commit=False)
360 for instance in instances:
361 if instance.__class__ == rh.EmployeCommentaire:
362 instance.owner = request.user
363 instance.save()
babf71ec
NC
364
365class EmployeCommentaireAdmin(admin.ModelAdmin):
6e7c919b
NC
366 pass
367
54d04eed 368
babf71ec 369class EmployePieceAdmin(admin.ModelAdmin):
6e7c919b
NC
370 pass
371
54d04eed 372
6e7c919b 373class EvenementAdmin(admin.ModelAdmin):
babf71ec 374 inlines = (EvenementRemunerationInline,)
6e7c919b 375
54d04eed 376
6e7c919b
NC
377class EvenementRemunerationAdmin(admin.ModelAdmin):
378 pass
379
54d04eed 380
26dacccc 381class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
babf71ec 382 inlines = (TypePosteInline,)
26dacccc
OL
383 fieldsets = AUFMetadataAdminMixin.fieldsets + (
384 (None, {
385 'fields': ('nom', )
386 }),
387 )
6e7c919b 388
54d04eed 389
aff1a4c6 390class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
d8d7985b 391 search_fields = ('nom', )
1c8856ef 392 list_display = ('nom', 'type', 'pays', )
babf71ec 393 inlines = (DossierROInline,)
43f5653a
OL
394 fieldsets = AUFMetadataAdminMixin.fieldsets + (
395 (None, {
396 'fields': ('nom', 'type', 'pays', )
397 }),
398 )
6e7c919b 399
54d04eed 400
aff1a4c6 401class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
387ab827 402 alphabet_filter = 'nom'
70561dc2
OL
403 search_fields = ('nom', 'implantation__code', 'implantation__nom', 'implantation__region__code', 'implantation__region__nom', )
404 list_display = ('nom', 'implantation', 'service', 'type_poste', 'date_debut', 'date_fin', )
d2cf315a 405 fieldsets = AUFMetadataAdminMixin.fieldsets + (
6e7c919b 406 (None, {
4497b3cb 407 'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
6e7c919b
NC
408 'service', 'responsable')
409 }),
410 ('Contrat', {
4497b3cb 411 'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
6e7c919b
NC
412 }),
413 ('Recrutement', {
4497b3cb 414 'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
6e7c919b
NC
415 }),
416 ('Rémunération', {
4497b3cb
PP
417 'fields': (('classement_min', 'classement_max'),
418 ('valeur_point_min', 'valeur_point_max'),
419 ('devise_min', 'devise_max'),
420 ('salaire_min', 'salaire_max'),
421 ('indemn_min', 'indemn_max'),
422 ('autre_min', 'autre_max'))
6e7c919b
NC
423 }),
424 ('Comparatifs de rémunération', {
4497b3cb
PP
425 'fields': ('devise_comparaison',
426 ('comp_locale_min', 'comp_locale_max'),
427 ('comp_universite_min', 'comp_universite_max'),
428 ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
429 ('comp_ong_min', 'comp_ong_max'),
430 ('comp_autre_min', 'comp_autre_max'))
6e7c919b
NC
431 }),
432 ('Justification', {
433 'fields': ('justification',)
434 }),
435 ('Autres Metadata', {
4497b3cb 436 'fields': ('date_validation', ('date_debut', 'date_fin'))
6e7c919b
NC
437 }),
438 )
439
babf71ec
NC
440 inlines = (PosteFinancementInline,
441 PostePieceInline,
70561dc2
OL
442 DossierROInline,
443 PosteCommentaireInline, )
6e7c919b 444
70561dc2
OL
445 def save_formset(self, request, form, formset, change):
446 instances = formset.save(commit=False)
447 for instance in instances:
448 if instance.__class__ == rh.PosteCommentaire:
449 instance.owner = request.user
450 instance.save()
451 formset.save_m2m()
6e7c919b 452
aff1a4c6 453
6e7c919b
NC
454class PosteCommentaireAdmin(admin.ModelAdmin):
455 pass
456
6e7c919b 457
babf71ec 458class PosteFinancementAdmin(admin.ModelAdmin):
6e7c919b
NC
459 pass
460
6e7c919b 461
babf71ec 462class PostePieceAdmin(admin.ModelAdmin):
6e7c919b
NC
463 pass
464
6e7c919b 465
babf71ec 466class RemunerationAdmin(admin.ModelAdmin):
6e7c919b
NC
467 pass
468
6e7c919b 469
1eede0db
OL
470class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
471 fieldsets = AUFMetadataAdminMixin.fieldsets + (
472 (None, {
473 'fields': ('employe', 'implantation', ),
474 }),
475 )
476
6e7c919b 477
43f5653a
OL
478class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
479 list_display = ('nom', 'actif', )
480 fieldsets = AUFMetadataAdminMixin.fieldsets + (
481 (None, {
482 'fields': ('nom', ),
483 }),
484 )
6e7c919b 485
43f5653a
OL
486class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
487 fieldsets = AUFMetadataAdminMixin.fieldsets + (
488 (None, {
489 'fields': ('code', 'nom', ),
490 }),
491 )
6e7c919b 492
babf71ec 493class TauxChangeAdmin(admin.ModelAdmin):
24475cf1
OL
494 list_display = ('taux', 'devise', 'annee', )
495 list_filter = ('devise', )
dcbadfad
OL
496 fieldsets = AUFMetadataAdminMixin.fieldsets + (
497 (None, {
498 'fields': ('taux', 'devise', 'annee', ),
499 }),
500 )
6e7c919b 501
6e7c919b 502class TypeContratAdmin(admin.ModelAdmin):
babf71ec 503 inlines = (ContratInline,)
7376afeb
PP
504 fieldsets = AUFMetadataAdminMixin.fieldsets + (
505 (None, {
506 'fields': ('nom', 'nom_long', ),
507 }),
508 )
6e7c919b 509
6e7c919b 510
240893cb 511class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
d8d7985b 512 search_fields = ('nom', 'nom_feminin', )
52e05b08
OL
513 list_display = ('nom', 'famille_emploi', )
514 list_filter = ('famille_emploi', )
240893cb
OL
515 fieldsets = AUFMetadataAdminMixin.fieldsets + (
516 (None, {
517 'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi', )
518 }),
519 )
6e7c919b 520
6e7c919b 521
3f486b41 522class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
f7efd29a 523 list_display = ('nom', 'type_paiement', 'nature_remuneration', )
3f486b41
OL
524 #inlines = (RemunerationROInline,) utilité?
525 fieldsets = AUFMetadataAdminMixin.fieldsets + (
526 (None, {
527 'fields': ('nom', 'type_paiement', 'nature_remuneration', )
528 }),
529 )
6e7c919b 530
6e7c919b 531
3f486b41
OL
532class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
533 #inlines = (RemunerationROInline,) utilité?
534 fieldsets = AUFMetadataAdminMixin.fieldsets + (
535 (None, {
536 'fields': ('nom', )
537 }),
538 )
6e7c919b 539
6e7c919b 540
84fc088b 541class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
701f3bea 542 list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
84fc088b
OL
543 fieldsets = AUFMetadataAdminMixin.fieldsets + (
544 (None, {
545 'fields': ('valeur', 'devise', 'implantation', 'annee', )
546 }),
547 )
701f3bea
OL
548
549 def _devise_code(self, obj):
550 return obj.devise.code
551 _devise_code.short_description = "Code de la devise"
552
553 def _devise_nom(self, obj):
554 return obj.devise.nom
555 _devise_nom.short_description = "Nom de la devise"
49c98347
PP
556
557
558def calc_remun(dossier):
559 thisyear = datetime.date.today().year
560 thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
561
562 remunnow = dossier.rh_remuneration_remunerations.filter(thisyearfilter)
563
564 remun_sum = 0
565 remun_sum_euro = 0
566 sums = defaultdict(int)
567 sums_euro = defaultdict(int)
568 for r in remunnow:
569 nature = r.type.nature_remuneration
570 sums[nature] += r.montant
571 sums_euro[nature] += r.montant_euro()
572 remun_sum += r.montant
573 remun_sum_euro += r.montant_euro()
574
575 remun = {}
576 sums = dict(sums)
577 for n, s in sums.iteritems():
578 remun[n] = [sums[n], sums_euro[n]]
579
580 return remun, remun_sum, remun_sum_euro