1 # -*- encoding: utf-8 -*-
3 from collections
import defaultdict
4 from datetime
import date
5 from decimal
import Decimal
7 import pygraphviz
as pgv
8 from auf
.django
.references
import models
as ref
9 from django
.conf
import settings
10 from django
.contrib
.auth
.decorators
import login_required
11 from django
.core
.urlresolvers
import reverse
12 from django
.db
.models
import Q
13 from django
.http
import HttpResponse
14 from django
.shortcuts
import render
, get_object_or_404
16 from project
.decorators
import drh_or_admin_required
17 from project
.decorators
import region_protected
18 from project
.groups
import \
19 get_employe_from_user
, grp_drh
, grp_correspondants_rh
20 from project
.rh
import ods
21 from project
.rh
import graph
as rh_graph
22 from project
.rh
import models
as rh
23 from project
.rh
.change_list
import RechercheTemporelle
24 from project
.rh
.forms
import MasseSalarialeForm
25 from project
.rh
.lib
import get_lookup_params
26 from project
.rh
.templatetags
.rapports
import SortHeaders
28 TWOPLACES
= Decimal('0.01')
33 """Profil personnel de l'employé - éditable"""
34 employe
= get_employe_from_user(request
.user
)
39 return render(request
, 'rh/profil.html', c
)
43 def employes_liste(request
):
44 """Liste des employés."""
46 employes
= rh
.Employe
.objects \
47 .exclude(dossiers__date_debut__gt
=today
) \
48 .exclude(dossiers__date_fin__lt
=today
) \
54 return render(request
, 'rh/employes_liste.html', c
)
58 def employe(request
, id):
59 """Information publique sur un employé."""
61 employe
= rh
.Employe
.objects
.get(pk
=id)
63 employe
= rh
.Employe
.objects
.none()
68 return render(request
, 'rh/employe.html', c
)
72 @drh_or_admin_required
73 def rapports_contrat(request
):
74 # statut default = actif?
75 if 'HTTP_REFERER' in request
.META
.keys():
76 referer
= request
.META
['HTTP_REFERER']
77 referer
= "/".join(referer
.split('/')[3:])
78 referer
= "/%s" % referer
.split('?')[0]
79 if referer
!= reverse('rhr_contrats'):
80 params
= request
.GET
.copy()
81 params
.update({'statut': 'Actif'})
84 contrats
= rh
.Contrat
.objects
.select_related(
85 'dossier', 'dossier__poste', 'dossier__poste__implantation',
86 'type_contrat', 'dossier__employe'
89 # filters et recherche temporelle
90 cl
= RechercheTemporelle(dict(request
.GET
.items()), rh
.Contrat
)
91 lookup_params
= get_lookup_params(request
)
92 lookup_params
= cl
.purge_params(lookup_params
)
93 q_temporel
= cl
.get_q_temporel(contrats
)
94 q
= Q(**lookup_params
) & q_temporel
95 contrats
= contrats
.filter(q
).exclude(dossier__employe__supprime
=1)
98 if 'o' in request
.GET
:
99 contrats
= contrats
.order_by(
100 ('-' if request
.GET
.get('ot') == "desc" else '') + request
.GET
['o']
104 employes
= set([c
.dossier
.employe_id
for c
in contrats
])
106 ("dossier__employe__id", u
"#"),
107 ("dossier__employe__nom", u
"Employé"),
108 ("dossier", u
"Dossier : Poste"),
109 ("type_contrat__nom", u
"Contrat"),
110 ("date_debut", u
"Début contrat"),
111 ("date_fin", u
"Fin contrat"),
112 ("dossier__statut_residence", u
"Statut"),
113 ("dossier__poste__implantation__region", u
"Région"),
114 ("dossier__poste__implantation", u
"Implantation"),
117 request
, headers
, order_field_type
="ot", order_field
="o",
118 not_sortable
=('dossier',)
123 'title': 'Rapport des contrats',
124 'contrats': contrats
,
125 'count_employe': len(employes
),
126 'headers': list(h
.headers()),
128 return render(request
, 'rh/rapports/contrats.html', c
)
132 @drh_or_admin_required
133 def rapports_masse_salariale(request
):
134 form
= MasseSalarialeForm(request
.user
, request
.GET
)
135 if 'annee' in request
.GET
and form
.is_valid():
136 region
= form
.cleaned_data
['region']
137 implantation
= form
.cleaned_data
['implantation']
138 annee
= form
.cleaned_data
['annee']
139 debut_annee
= date(annee
, 1, 1)
140 fin_annee
= date(annee
, 12, 31)
141 jours_annee
= (fin_annee
- debut_annee
).days
+ 1
144 # Récupérer les dossiers actifs
145 dossiers
= rh
.Dossier
.objects \
146 .actifs(annee
=annee
) \
148 'poste', 'poste__implantation',
149 'poste__implantation__region',
150 'poste__implantation__adresse_physique_pays',
151 'employe', 'poste__type_poste', 'classement',
152 'statut', 'organisme_bstg'
155 tables
=['rh_valeurpoint', 'rh_devise'],
157 'rh_valeurpoint.annee = %s',
158 'rh_valeurpoint.implantation = ref_implantation.id',
159 'rh_devise.id = rh_valeurpoint.devise'
163 'valeur_point': 'rh_valeurpoint.valeur',
164 'valeur_point_devise': 'rh_devise.code'
168 dossiers
= dossiers
.filter(poste__implantation__region
=region
)
170 dossiers
= dossiers
.filter(poste__implantation
=implantation
)
172 # Récupérer les rémunérations actives
173 remuns
= rh
.Remuneration
.objects \
174 .actifs(annee
=annee
) \
175 .select_related('devise', 'type') \
177 tables
=['rh_tauxchange'],
179 'rh_tauxchange.annee = %s',
180 'rh_tauxchange.devise = rh_devise.id'
184 'taux_change': 'rh_tauxchange.taux'
187 remuns_par_dossier
= defaultdict(list)
189 remuns_par_dossier
[remun
.dossier_id
].append(remun
)
191 # Récupérer les types de rémunération par nature
192 types_remun_par_nature
= defaultdict(list)
193 for type in rh
.TypeRemuneration
.objects
.all():
194 types_remun_par_nature
[type.nature_remuneration
].append(type)
195 titres_traitements
= [
196 t
.nom
for t
in types_remun_par_nature
[u
'Traitement']
198 titres_indemnites
= [
199 t
.nom
for t
in types_remun_par_nature
[u
'Indemnité']
202 t
.nom
for t
in types_remun_par_nature
[u
'Accessoire']
205 t
.nom
for t
in types_remun_par_nature
[u
'Charges']
208 # Boucler sur les dossiers et préprarer les lignes du rapport
210 masse_salariale_totale
= 0
211 for dossier
in dossiers
:
212 debut_cette_annee
= \
213 max(dossier
.date_debut
or debut_annee
, debut_annee
)
215 min(dossier
.date_fin
or fin_annee
, fin_annee
)
216 jours
= (fin_cette_annee
- debut_cette_annee
).days
+ 1
218 remuns
= remuns_par_dossier
[dossier
.id]
219 devises
= set(remun
.devise
.code
for remun
in remuns
)
220 if len(devises
) == 1:
221 devise
= remuns
[0].devise
.code
222 montant_remun
= lambda r
: r
.montant
223 taux_change
= Decimal(str(remuns
[0].taux_change
))
226 montant_remun
= lambda r
: (
227 r
.montant
* Decimal(str(r
.taux_change
))
229 taux_change
= Decimal(1)
231 remuns_par_type
= defaultdict(lambda: 0)
233 remuns_par_type
[remun
.type_id
] += (
234 montant_remun(remun
) * ((
235 min(remun
.date_fin
or fin_annee
, fin_annee
) -
236 max(remun
.date_debut
or debut_annee
, debut_annee
)
237 ).days
+ 1) / jours_annee
238 ).quantize(TWOPLACES
)
240 remuns_par_type
[type.id]
241 for type in types_remun_par_nature
[u
'Traitement']
244 remuns_par_type
[type.id]
245 for type in types_remun_par_nature
[u
'Indemnité']
248 remuns_par_type
[type.id]
249 for type in types_remun_par_nature
[u
'Accessoire']
252 remuns_par_type
[type.id]
253 for type in types_remun_par_nature
[u
'Charges']
255 masse_salariale
= sum(remuns_par_type
.values())
256 masse_salariale_eur
= (
257 masse_salariale
* taux_change
258 ).quantize(TWOPLACES
)
259 masse_salariale_totale
+= masse_salariale_eur
261 if dossier
.valeur_point
and dossier
.classement \
262 and dossier
.classement
.coefficient
and dossier
.regime_travail
:
263 salaire_theorique
= (Decimal(str(
264 dossier
.valeur_point
* dossier
.classement
.coefficient
265 )) * dossier
.regime_travail
/ 100).quantize(TWOPLACES
)
267 salaire_theorique
= None
271 'poste': dossier
.poste
,
274 if dossier
.date_debut
and dossier
.date_debut
.year
== annee
279 if dossier
.date_fin
and dossier
.date_fin
.year
== annee
284 'valeur_point': dossier
.valeur_point
,
285 'valeur_point_devise': dossier
.valeur_point_devise
,
286 'regime_travail': dossier
.regime_travail
,
288 'local': 'L', 'expat': 'E'
289 }.get(dossier
.statut_residence
),
290 'salaire_bstg': remuns_par_type
[2],
291 'salaire_bstg_eur': (
292 (remuns_par_type
[2] * taux_change
).quantize(TWOPLACES
)
294 'salaire_theorique': salaire_theorique
,
295 'traitements': traitements
,
296 'total_traitements': sum(traitements
),
297 'indemnites': indemnites
,
298 'total_indemnites': sum(indemnites
),
300 'total_primes': sum(primes
),
302 'total_charges': sum(charges
),
303 'masse_salariale': masse_salariale
,
304 'masse_salariale_eur': masse_salariale_eur
,
307 # Récupérer les postes actifs pour déterminer le nombre de jours
310 rh
.Poste
.objects
.actifs(annee
=annee
)
312 'devise_max', 'valeur_point_max', 'classement_max'
315 tables
=['rh_tauxchange'],
317 'rh_tauxchange.annee = %s',
318 'rh_tauxchange.devise = rh_devise.id'
322 'taux_change': 'rh_tauxchange.taux'
326 postes_par_id
= dict((poste
.id, poste
) for poste
in postes
)
327 jours_vacants_date
= dict(
328 (poste
.id, max(today
, poste
.date_debut
or today
))
331 jours_vacants
= defaultdict(lambda: 0)
332 for dossier
in rh
.Dossier
.objects
.actifs(annee
=annee
) \
333 .order_by('date_debut'):
334 if dossier
.poste_id
not in jours_vacants_date
:
336 derniere_date
= jours_vacants_date
[dossier
.poste_id
]
337 if dossier
.date_debut
is not None:
338 jours_vacants
[dossier
.poste_id
] += max((
339 dossier
.date_debut
- derniere_date
341 jours_vacants_date
[dossier
.poste_id
] = max(
342 min(dossier
.date_fin
or fin_annee
, fin_annee
),
346 # Ajouter les lignes des postes vacants au rapport
347 for poste_id
, jours
in jours_vacants
.iteritems():
350 poste
= postes_par_id
[poste_id
]
351 if poste
.valeur_point_max
and poste
.classement_max \
352 and poste
.classement_max
.coefficient
and poste
.regime_travail
:
353 salaire_theorique
= (Decimal(str(
354 poste
.valeur_point_max
.valeur
*
355 poste
.classement_max
.coefficient
356 )) * poste
.regime_travail
/ 100).quantize(TWOPLACES
)
358 salaire_theorique
= None
360 local_expatrie
= '/'.join(
361 (['L'] if poste
.local
else []) +
362 (['E'] if poste
.expatrie
else [])
366 poste
.salaire_max
* jours
/ jours_annee
*
367 poste
.regime_travail
/ 100
368 ).quantize(TWOPLACES
)
370 poste
.indemn_max
* jours
/ jours_annee
*
371 poste
.regime_travail
/ 100
372 ).quantize(TWOPLACES
)
374 poste
.autre_max
* jours
/ jours_annee
*
375 poste
.regime_travail
/ 100
376 ).quantize(TWOPLACES
)
377 masse_salariale
= salaire
+ indemnites
+ charges
378 masse_salariale_eur
= (
379 masse_salariale
* Decimal(str(poste
.taux_change
))
380 ).quantize(TWOPLACES
)
381 masse_salariale_totale
+= masse_salariale_eur
385 'regime_travail': poste
.regime_travail
,
386 'local_expatrie': local_expatrie
,
388 'devise': poste
.devise_max
and poste
.devise_max
.code
,
390 poste
.valeur_point_max
and poste
.valeur_point_max
.valeur
392 'valeur_point_devise': (
393 poste
.valeur_point_max
and \
394 poste
.valeur_point_max
.devise
.code
396 'salaire_theorique': salaire_theorique
,
397 'salaire_de_base': salaire
,
398 'total_indemnites': indemnites
,
399 'total_charges': charges
,
400 'masse_salariale': masse_salariale
,
401 'masse_salariale_eur': masse_salariale_eur
403 if 'ods' in request
.GET
:
404 doc
= ods
.masse_salariale(
407 titres_traitements
=titres_traitements
,
408 titres_indemnites
=titres_indemnites
,
409 titres_primes
=titres_primes
,
410 titres_charges
=titres_charges
,
411 masse_salariale_totale
=masse_salariale_totale
413 response
= HttpResponse(
414 mimetype
='vnd.oasis.opendocument.spreadsheet'
416 response
['Content-Disposition'] = 'filename=masse-salariale.ods'
420 return render(request
, 'rh/rapports/masse_salariale.html', {
422 'titres_traitements': titres_traitements
,
423 'titres_indemnites': titres_indemnites
,
424 'titres_primes': titres_primes
,
425 'titres_charges': titres_charges
,
426 'masse_salariale_totale': masse_salariale_totale
,
430 return render(request
, 'rh/rapports/masse_salariale.html', {
436 @drh_or_admin_required
437 def rapports_employes_sans_contrat(request
):
438 lookup_params
= get_lookup_params(request
)
441 contrats_echus
= rh
.Contrat
.objects
.filter(
442 date_fin__lt
=date
.today()
447 # dossiers en cours sans contrat
448 dossiers_sans_contrat
= rh
.Dossier
.objects
.filter(
449 Q(date_fin
=None) |
Q(date_fin__gt
=date
.today()),
451 date_debut__gt
=date
.today()
453 rh_contrats__in
=contrats_echus
456 # employés sans contrat
457 employes
= rh
.Employe
.objects \
458 .filter(rh_dossiers__in
=dossiers_sans_contrat
).distinct()
459 if 'o' in request
.GET
:
460 employes
= employes
.order_by(
461 ('-' if request
.GET
.get('ot') == "desc" else '') + request
.GET
['o']
468 ("dossier", u
"Dossier : Poste"),
469 ("dossier_date_debut", u
"Début dossier"),
470 ("dossier_date_fin", u
"Fin dossier"),
473 request
, headers
, order_field_type
="ot", order_field
="o",
474 not_sortable
=('dossier', 'dossier_date_debut', 'dossier_date_fin')
478 'title': u
'Rapport des employés sans contrat',
479 'employes': employes
,
480 'dossiers_sans_contrat': dossiers_sans_contrat
,
481 'headers': list(h
.headers()),
484 return render(request
, 'rh/rapports/employes_sans_contrat.html', c
)
488 @drh_or_admin_required
489 def rapports_postes_modelisation(request
):
493 for categorie
in rh
.CategorieEmploi
.objects
.all():
494 types
= rh
.TypePoste
.objects
.filter(categorie_emploi
=categorie
)
496 for t
in types
.all():
497 postes
= rh
.Poste
.objects
.filter(type_poste
=t
)
499 'num_postes': postes
.count(),
500 'postes': postes
.all(),
505 'categorie': categorie
,
506 'nb_types': types
.count(),
512 return render(request
, 'rh/rapports/postes_modelisation.html', c
)
516 @drh_or_admin_required
517 def rapports_postes_implantation(request
):
520 for r
in ref
.Region
.objects
.all():
522 for i
in ref
.Implantation
.objects
.filter(region
=r
):
523 implantations
.append({
525 'postes': rh
.Poste
.objects
.filter(implantation
=i
),
526 'num_postes': rh
.Poste
.objects
.filter(implantation
=i
).count(),
530 'implantations': implantations
535 return render(request
, 'rh/rapports/postes_implantation.html', c
)
539 @drh_or_admin_required
540 def rapports_postes_service(request
):
543 for s
in rh
.Service
.objects
.all():
544 postes
= rh
.Poste
.objects
.filter(service
=s
).all()
545 num_postes
= rh
.Poste
.objects
.filter(service
=s
).count()
546 data
.append({'service': s
, 'num_postes': num_postes
, 'postes': postes
})
549 return render(request
, 'rh/rapports/postes_service.html', c
)
552 @region_protected(rh
.Dossier
)
553 def dossier_apercu(request
, dossier_id
):
554 d
= get_object_or_404(rh
.Dossier
, pk
=dossier_id
)
556 'title': u
"Dossier %s" % (d
, ),
557 'is_popup': request
.GET
.get('_popup', False),
559 'pieces': rh
.DossierPiece
.objects
.filter(dossier__exact
=d
),
560 'contrats': rh
.Contrat
.objects
.filter(dossier__exact
=d
),
561 'commentaires': rh
.DossierCommentaire
.objects
.filter(dossier
=d
).all(),
562 'media_url': settings
.PRIVE_MEDIA_URL
,
564 return render(request
, 'admin/rh/dossier/apercu.html', c
)
567 @region_protected(rh
.Poste
)
568 def poste_apercu(request
, poste_id
):
569 p
= get_object_or_404(rh
.Poste
, pk
=poste_id
)
571 'title': u
"Poste %s" % (p
, ),
572 'is_popup': request
.GET
.get('_popup', False),
575 rh
.PosteFinancement
.objects
.filter(poste
=poste_id
).all()
577 'pieces': rh
.PostePiece
.objects
.filter(poste
=poste_id
).all(),
579 rh
.Dossier
.objects
.filter(poste
=poste_id
)
580 .order_by("-date_debut").all()
583 rh
.PosteComparaison
.objects
.filter(poste
=poste_id
).all()
586 rh
.PosteCommentaire
.objects
.filter(poste
=poste_id
).all()
588 'media_url': settings
.PRIVE_MEDIA_URL
,
590 return render(request
, 'admin/rh/poste/apercu.html', c
)
593 def employe_apercu(request
, employe_id
):
594 employe
= get_object_or_404(rh
.Employe
, pk
=employe_id
)
595 user_groups
= request
.user
.groups
.all()
598 if request
.user
.is_superuser
or \
599 grp_drh
in user_groups
:
600 q
= Q(employe
=employe
)
601 if grp_correspondants_rh
in user_groups
:
603 d
.poste
.implantation
.region
for d
in employe
.rh_dossiers
.all()
605 q
= Q(employe
=employe
) & Q(implantation__region__in
=regions
)
607 dossiers
= rh
.Dossier
.objects
.filter(q
).order_by('-date_debut')
610 'title': u
"Employe %s" % (employe
, ),
611 'is_popup': request
.GET
.get('_popup', False),
613 'dossiers': dossiers
,
614 'media_url': settings
.PRIVE_MEDIA_URL
,
616 return render(request
, 'admin/rh/employe/apercu.html', c
)
620 @drh_or_admin_required
621 def organigrammes_employe(request
, id, level
="all"):
622 poste
= get_object_or_404(rh
.Poste
, pk
=id)
623 dossiers_by_poste
= dict(
625 for d
in rh
.Dossier
.objects
.select_related('employe', 'poste').all()
627 postes_by_id
= dict((p
.id, p
) for p
in rh
.Poste
.objects
.all())
629 e
= dossiers_by_poste
[poste
.id].employe
630 name
= u
"Organigramme de [%s] %s %s" % (e
.id, e
.nom
.upper(), e
.prenom
)
633 if rh
.Poste
.objects
.filter(responsable
=poste
).count() > 0:
634 postes_handle
= [poste
]
636 postes_handle
= rh
.Poste
.objects
.select_related('implantation') \
638 Q(date_fin__gt
=date
.today()) |
Q(date_fin
=None),
639 Q(date_debut__lt
=date
.today()) |
Q(date_debut
=None),
640 responsable__in
=postes_handle
641 ).exclude(supprime
=True).exclude(responsable
=None).all()
643 for p
in postes_handle
:
644 if p
.responsable_id
!= p
.id:
646 dossiers_by_poste
[p
.responsable_id
].poste_id
, p
.id
650 graph
.add_node(poste
.id)
653 postes_niveau
= [poste
.id]
654 for niveau
in range(int(level
)):
657 rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()
663 rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()
666 for p
in postes_niveau
:
667 if graph
.has_node(p
):
671 a
.name
= name
.encode('ascii', 'xmlcharrefreplace')
673 poste_remontant
= poste
674 while poste_remontant
.responsable_id
:
675 a
.add_edge(poste_remontant
.responsable_id
, poste_remontant
.id)
676 poste_remontant
= poste_remontant
.responsable
678 rh_graph
.bind_poste_to_graph(a
, postes_by_id
)
679 #a.graph_attr['normalize'] = True
680 #a.graph_attr['level'] = 2
683 svg
= a
.draw(format
='svg')
689 if 'forcer' in request
.GET
:
690 response
= HttpResponse(svg
, content_type
='image/svg+xml')
691 response
['Content-Disposition'] = \
692 'attachment; filename=organigramme.svg'
695 return render(request
, 'rh/organigrammes/employe.html', c
,
696 content_type
="image/svg+xml"
701 @drh_or_admin_required
702 def organigrammes_service(request
, id):
703 service
= get_object_or_404(rh
.Service
, pk
=id)
704 svg
= rh_graph
.organigramme_postes_cluster( \
705 cluster_filter
={"service": service
}, \
706 titre
=u
"Organigramme du service %s" % service
.nom
,
707 cluster_titre
=service
.nom
)
713 return render(request
, 'rh/organigrammes/vide.html', c
,
714 content_type
="image/svg+xml"
719 @drh_or_admin_required
720 def organigrammes_implantation(request
, id):
721 implantation
= get_object_or_404(ref
.Implantation
, pk
=id)
722 svg
= rh_graph
.organigramme_postes_cluster( \
723 cluster_filter
={"implantation": implantation
}, \
724 titre
=u
"Organigramme de l'implantation %s" % implantation
.nom
,
725 cluster_titre
=implantation
.nom
)
731 return render(request
, 'rh/organigrammes/vide.html', c
,
732 content_type
="image/svg+xml"
737 @drh_or_admin_required
738 def organigrammes_region(request
, id):
739 region
= get_object_or_404(ref
.Region
, pk
=id)
740 svg
= rh_graph
.organigramme_postes_cluster( \
741 cluster_filter
={"implantation__region": region
}, \
742 titre
=u
"Organigramme du bureau de %s" % region
.nom
,
743 cluster_titre
=region
.nom
)
749 return render(request
,
750 'rh/organigrammes/vide.html', c
,
751 content_type
="image/svg+xml"