1 # -*- encoding: utf-8 -*-
3 from datetime
import date
4 from itertools
import izip
6 import pygraphviz
as pgv
8 from django
.core
.urlresolvers
import reverse
9 from django
.db
.models
import Q
10 from django
.contrib
.auth
.decorators
import login_required
11 from django
.utils
.encoding
import smart_str
12 from django
.shortcuts
import render_to_response
, get_object_or_404
13 from django
.template
import RequestContext
14 from django
.http
import HttpResponse
16 from datamaster_modeles
import models
as ref
18 from rh
import models
as rh
19 from rh
.lib
import calc_remun
20 from rh
.decorators
import drh_or_admin_required
21 from rh
.templatetags
.rapports
import SortHeaders
22 from rh
.change_list
import RechercheTemporelle
23 from rh
import graph
as rh_graph
24 from rh
.masse_salariale
import MasseSalariale
26 # pas de reference a DAE devrait etre refactorisé
27 from dae
.utils
import get_employe_from_user
28 from dae
.decorators
import redirect_interdiction
29 from dae
.workflow
import grp_drh
, grp_correspondants_rh
30 from django
.conf
import settings
35 """Profil personnel de l'employé - éditable"""
36 rc
= RequestContext(request
)
39 employe
= rc
['this_employe']
41 c
['user'] = request
.user
42 c
['employe'] = employe
43 return render_to_response('rh/profil.html', c
, rc
)
47 def employes_liste(request
):
48 """Liste des employés."""
50 employes
= rh
.Employe
.objects \
51 .exclude(dossiers__date_debut__gt
=today
) \
52 .exclude(dossiers__date_fin__lt
=today
) \
58 return render_to_response('rh/employes_liste.html',
60 RequestContext(request
))
64 def employe(request
, id):
65 """Information publique sur un employé."""
67 employe
= rh
.Employe
.objects
.get(pk
=id)
69 employe
= rh
.Employe
.objects
.none()
74 return render_to_response('rh/employe.html', c
, RequestContext(request
))
78 @drh_or_admin_required
79 def rapports_poste(request
):
81 lookup_params
= dict(request
.GET
.items())
83 for key
, value
in lookup_params
.items():
84 if key
== 'o' or key
== 'ot':
85 del lookup_params
[key
]
87 if not isinstance(key
, str):
88 # 'key' will be used as a keyword argument later, so Python
89 # requires it to be a string.
90 del lookup_params
[key
]
91 lookup_params
[smart_str(key
)] = value
94 del lookup_params
[key
]
96 postes
= rh
.Poste
.objects
.select_related('implantation') \
97 .extra(select
={'employe_id':'select group_concat(employe separator "|") from rh_dossier where poste=rh_poste.id and rh_dossier.date_fin is null %s' % \
98 ("%s" % (('order by employe %s' % ('asc' if 'ot' in request
.GET
and request
.GET
['ot'] == "asc" else "desc"))) if 'o' in request
.GET
and request
.GET
['o'] == "employe_id" else "") \
100 .extra(select
={'employe_nom':'select group_concat(rh_employe.nom separator "|") from rh_dossier inner join rh_employe on rh_dossier.employe = rh_employe.id where poste=rh_poste.id and rh_dossier.date_fin is null %s' % \
101 ("%s" % (('order by rh_employe.nom %s' % ('asc' if 'ot' in request
.GET
and request
.GET
['ot'] == "asc" else "desc"))) if 'o' in request
.GET
and request
.GET
['o'] == "employe_nom" else "") \
103 .extra(select
={'employe_prenom':'select group_concat(rh_employe.prenom separator "|") from rh_dossier inner join rh_employe on rh_dossier.employe = rh_employe.id where poste=rh_poste.id and rh_dossier.date_fin is null %s' % \
104 ("%s" % (('order by rh_employe.prenom %s' % ('asc' if 'ot' in request
.GET
and request
.GET
['ot'] == "asc" else "desc"))) if 'o' in request
.GET
and request
.GET
['o'] == "employe_prenom" else "") \
107 postes
= postes
.filter(**lookup_params
)
108 if 'o' in request
.GET
:
109 postes
= postes
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
116 'implantation': p
.implantation
,
117 'employes': [] if not p
.employe_id
else [{'id': id, 'nom': nom
, 'prenom': prenom
} for id, nom
, prenom
in izip(p
.employe_id
.split('|'), p
.employe_nom
.split('|'), p
.employe_prenom
.split('|'))] })
121 ("id", u
"# du poste"),
122 ("nom", u
"Nom du poste"),
123 ("implantation__id", u
"Implantation"),
124 ("employe_nom", u
"Nom"),
126 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
128 'title': 'Rapport des postes',
131 'headers': list(h
.headers()),
134 return render_to_response('rh/rapports/postes.html', c
, RequestContext(request
))
137 @drh_or_admin_required
138 def rapports_contrat(request
):
139 if 'HTTP_REFERER' in request
.META
.keys():
140 referer
= request
.META
['HTTP_REFERER']
141 referer
= "/".join(referer
.split('/')[3:])
142 referer
= "/%s" % referer
.split('?')[0]
143 if referer
!= reverse('rhr_contrats'):
144 params
= request
.GET
.copy()
145 params
.update({'statut': 'Actif'})
148 lookup_params
= dict(request
.GET
.items())
149 if 'ot' in lookup_params
:
150 del lookup_params
['ot']
151 if 'o' in lookup_params
:
152 del lookup_params
['o']
154 for key
, value
in lookup_params
.items():
155 if not isinstance(key
, str):
156 # 'key' will be used as a keyword argument later, so Python
157 # requires it to be a string.
158 del lookup_params
[key
]
159 lookup_params
[smart_str(key
)] = value
161 contrats
= rh
.Contrat
.objects
.select_related('dossier', 'dossier__poste', 'dossier__poste__implantation', 'type_contrat', 'dossier__employe')
163 cl
= RechercheTemporelle(dict(request
.GET
.items()), rh
.Contrat
)
164 lookup_params
= cl
.purge_params(lookup_params
)
165 q_temporel
= cl
.get_q_temporel(contrats
)
166 q
= Q(**lookup_params
) & q_temporel
167 contrats
= contrats
.filter(q
).exclude(dossier__employe__supprime
=1)
169 if 'o' in request
.GET
:
170 contrats
= contrats
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
172 employes
= set([c
.dossier
.employe_id
for c
in contrats
])
175 ("dossier__employe__id", u
"# de l'employé"),
176 ("dossier__employe__nom", u
"Nom"),
177 ("dossier__employe__prenom", u
"Prénom"),
178 ("type_contrat__nom", u
"Poste"),
179 ("type_contrat__nom", u
"Type de contrat"),
180 ("date_debut", u
"Date début"),
181 ("date_fin", u
"Date fin"),
183 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
187 'title': 'Rapport des contrats',
188 'contrats': contrats
,
189 'count': len(contrats
),
190 'count_employe' : len(employes
),
191 'headers': list(h
.headers()),
194 return render_to_response('rh/rapports/contrats.html', c
, RequestContext(request
))
198 @drh_or_admin_required
199 def rapports_masse_salariale(request
):
201 date_debut
= request
.GET
.get("date_debut", None)
202 date_fin
= request
.GET
.get("date_fin", None)
204 implantation
= request
.GET
.get('dossier__poste__implantation')
205 region
= request
.GET
.get('dossier__poste__implantation__region')
209 custom_filter
['dossier__poste__implantation'] = implantation
211 custom_filter
['dossier__poste__implantation__region'] = region
216 if date_debut
or date_fin
:
217 masse
= MasseSalariale(date_debut
, date_fin
, custom_filter
)
219 c
['rapport'] = masse
.rapport
220 headers
= masse
.headers
221 c
['header_keys'] = [h
[0] for h
in masse
.headers
]
222 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
223 c
['headers'] = list(h
.headers())
225 return render_to_response('rh/rapports/masse_salariale.html', c
, RequestContext(request
))
229 @drh_or_admin_required
230 def rapports_remuneration(request
):
232 lookup_params
= dict(request
.GET
.items())
233 if 'ot' in lookup_params
:
234 del lookup_params
['ot']
235 if 'o' in lookup_params
:
236 del lookup_params
['o']
238 for key
, value
in lookup_params
.items():
239 if not isinstance(key
, str):
240 # 'key' will be used as a keyword argument later, so Python
241 # requires it to be a string.
242 del lookup_params
[key
]
243 lookup_params
[smart_str(key
)] = value
245 employes
= rh
.Employe
.objects
.all()
246 if 'o' in request
.GET
:
247 employes
= employes
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
249 employes
= employes
.filter(**lookup_params
)
253 ("id", u
"# de l'employé"),
255 ("prenom", u
"Prénom"),
260 ("", u
"Charges patronales"),
263 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
265 for employe
in employes
:
269 dossiers
= employe
.rh_dossiers
.all()
274 for dossier
in dossiers
:
275 this_remun
, this_remun_sum
, this_remun_sum_euro
= calc_remun(dossier
)
277 for item
in this_remun
:
278 if item
not in remun
:
279 remun
[item
] = this_remun
[item
]
281 remun
[item
][0] += this_remun
[item
][0]
282 remun
[item
][1] += this_remun
[item
][1]
284 remun_sum_euro
+= this_remun_sum_euro
286 line
['remun_sum_euro'] = remun_sum_euro
289 if r
== u
'Indemnité':
290 line
['Indemnite'] = remun
[r
][1]
292 line
[r
] = remun
[r
][1]
294 line
['id'] = employe
.id
295 line
['nom'] = employe
.nom
296 line
['prenom'] = employe
.prenom
300 'title': 'Rapport de remuneration',
302 'headers': list(h
.headers()),
305 return render_to_response('rh/rapports/remuneration.html', c
, RequestContext(request
))
308 @drh_or_admin_required
309 def rapports_employe_sans_contrat(request
):
311 lookup_params
= dict(request
.GET
.items())
312 if 'ot' in lookup_params
:
313 del lookup_params
['ot']
314 if 'o' in lookup_params
:
315 del lookup_params
['o']
317 for key
, value
in lookup_params
.items():
318 if not isinstance(key
, str):
319 # 'key' will be used as a keyword argument later, so Python
320 # requires it to be a string.
321 del lookup_params
[key
]
322 lookup_params
[smart_str(key
)] = value
324 employes_query
= rh
.Employe
.objects
325 if 'o' in request
.GET
:
326 employes_query
= employes_query
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
330 dossiers_en_cours
= rh
.Dossier
.objects
.filter(Q(date_fin
=None) |
Q(date_fin__gt
=date
.today()))
331 tous_contrats_echus
= rh
.Contrat
.objects
.filter(date_fin__lt
=date
.today(), dossier__in
=dossiers_en_cours
)
332 contrats
= tous_contrats_echus
.filter(**lookup_params
).all()
334 if c
.dossier
.employe
.id not in employes
.keys():
335 employes
[c
.dossier
.employe
.id] = {'employe': c
.dossier
.employe
, 'dossiers': []}
336 employes
[c
.dossier
.employe
.id]['dossiers'] += [c
.dossier
,]
341 ("id", u
"# de l'employé"),
343 ("prenom", u
"Prénom"),
344 ("dossier", u
"Dossiers"),
346 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o", not_sortable
=('dossier',))
349 'title': u
'Rapport des employés sans contrat',
350 'employes': employes
,
351 'count': len(employes
),
352 'headers': list(h
.headers()),
355 return render_to_response('rh/rapports/employes_sans_contrat.html', c
, RequestContext(request
))
358 @drh_or_admin_required
359 def rapports_postes_modelisation(request
):
363 for f
in rh
.FamilleEmploi
.objects
.all():
364 types
= rh
.TypePoste
.objects
.filter(famille_emploi
=f
)
366 for t
in types
.all():
367 postes
= rh
.Poste
.objects
.filter(type_poste
=t
)
369 'num_postes': postes
.count(),
370 'postes': postes
.all(),
376 'nb_types': types
.count(),
383 return render_to_response('rh/rapports/postes_modelisation.html', c
, RequestContext(request
))
387 @drh_or_admin_required
388 def rapports_postes_implantation(request
):
391 for r
in ref
.Region
.objects
.all():
393 for i
in ref
.Implantation
.objects
.filter(region
=r
):
394 implantations
.append({
396 'postes': rh
.Poste
.objects
.filter(implantation
=i
),
397 'num_postes': rh
.Poste
.objects
.filter(implantation
=i
).count(),
401 'implantations': implantations
407 return render_to_response('rh/rapports/postes_implantation.html', c
, RequestContext(request
))
411 @drh_or_admin_required
412 def rapports_postes_service(request
):
415 for s
in rh
.Service
.objects
.all():
416 postes
= rh
.Poste
.objects
.filter(service
=s
).all()
417 num_postes
= rh
.Poste
.objects
.filter(service
=s
).count()
418 data
.append({'service': s
, 'num_postes': num_postes
, 'postes': postes
})
421 return render_to_response('rh/rapports/postes_service.html', c
, RequestContext(request
))
424 def region_protected(model
):
426 def wrapped(request
, id):
427 if request
.user
.is_superuser
:
428 return func(request
, id)
429 user_groups
= request
.user
.groups
.all()
430 if grp_drh
in user_groups
:
431 return func(request
, id)
432 if grp_correspondants_rh
in user_groups
:
433 employe
= get_employe_from_user(request
.user
)
434 q
= Q(**{model
.prefix_implantation
: employe
.implantation
.region
})
435 qs
= model
.objects
.filter(q
)
436 if int(id) in [o
.id for o
in qs
]:
437 return func(request
, id)
438 return redirect_interdiction(request
)
443 @region_protected(rh
.Dossier
)
444 def dossier_apercu(request
, dossier_id
):
445 d
= get_object_or_404(rh
.Dossier
, pk
=dossier_id
)
447 'is_popup' : request
.GET
.get('_popup', False),
449 'pieces' : rh
.DossierPiece
.objects
.filter(dossier__exact
=d
),
450 'contrats' : rh
.Contrat
.objects
.filter(dossier__exact
=d
),
451 'commentaires' : rh
.DossierCommentaire
.objects
.filter(dossier__exact
=d
).all(),
452 'media_url': settings
.PRIVE_MEDIA_URL
,
454 return render_to_response('admin/rh/dossier/apercu.html', c
, RequestContext(request
))
456 @region_protected(rh
.Poste
)
457 def poste_apercu(request
, poste_id
):
459 'is_popup' : request
.GET
.get('_popup', False),
460 'poste' : get_object_or_404(rh
.Poste
, pk
=poste_id
),
461 'financements' : rh
.PosteFinancement
.objects
.filter(poste
=poste_id
).all(),
462 'pieces' : rh
.PostePiece
.objects
.filter(poste
=poste_id
).all(),
463 'dossiers' : rh
.Dossier
.objects
.filter(poste
=poste_id
).order_by("-date_debut").all(),
464 'comparaisons' : rh
.PosteComparaison
.objects
.filter(poste
=poste_id
).all(),
465 'commentaires' : rh
.PosteCommentaire
.objects
.filter(poste
=poste_id
).all(),
466 'media_url': settings
.PRIVE_MEDIA_URL
,
468 return render_to_response('admin/rh/poste/apercu.html', c
, RequestContext(request
))
470 def employe_apercu(request
, employe_id
):
471 employe
= get_object_or_404(rh
.Employe
, pk
=employe_id
)
472 user_groups
= request
.user
.groups
.all()
475 if request
.user
.is_superuser
or \
476 grp_drh
in user_groups
:
477 q
= Q(employe
=employe
)
478 if grp_correspondants_rh
in user_groups
:
479 regions
= [d
.poste
.implantation
.region
for d
in employe
.rh_dossiers
.all()]
480 q
= Q(employe
=employe
) & Q(implantation__region__in
=regions
)
482 dossiers
= rh
.Dossier
.objects
.filter(q
).order_by('-date_debut')
485 'is_popup' : request
.GET
.get('_popup', False),
487 'dossiers' : dossiers
,
488 'media_url': settings
.PRIVE_MEDIA_URL
,
490 return render_to_response('admin/rh/employe/apercu.html', c
, RequestContext(request
))
493 @drh_or_admin_required
494 def organigrammes_employe(request
, id, level
="all"):
496 poste
= get_object_or_404(rh
.Poste
, pk
=id)
497 dossiers_by_poste
= dict((d
.poste_id
, d
) for d
in rh
.Dossier
.objects
.select_related('employe', 'poste').all())
498 postes_by_id
= dict((p
.id, p
) for p
in rh
.Poste
.objects
.all())
500 e
= dossiers_by_poste
[poste
.id].employe
501 name
= u
"Organigramme de [%s] %s %s" % (e
.id, e
.nom
.upper(), e
.prenom
)
504 if rh
.Poste
.objects
.filter(responsable
=poste
).count() > 0:
505 postes_handle
= [poste
]
507 postes_handle
= rh
.Poste
.objects
.select_related('implantation').filter((Q(date_fin__gt
=date
.today()) |
Q(date_fin
=None)) & (Q(date_debut__lt
=date
.today()) |
Q(date_debut
=None)) ).filter(responsable__in
=postes_handle
).exclude(supprime
=True).exclude(responsable
=None).all()
509 for p
in postes_handle
:
510 if p
.responsable_id
!= p
.id:
511 graph
.add_edge(dossiers_by_poste
[p
.responsable_id
].poste_id
, p
.id)
514 graph
.add_node(poste
.id)
517 postes_niveau
= [poste
.id]
518 for niveau
in range(int(level
)):
519 postes_niveau
= [p
.id for p
in rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()]
522 postes_niveau
= [p
.id for p
in rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()]
524 for p
in postes_niveau
:
525 if graph
.has_node(p
):
529 a
.name
= name
.encode('ascii', 'xmlcharrefreplace')
531 poste_remontant
= poste
532 while poste_remontant
.responsable_id
:
533 a
.add_edge(poste_remontant
.responsable_id
, poste_remontant
.id)
534 poste_remontant
= poste_remontant
.responsable
536 rh_graph
.bind_poste_to_graph(a
, postes_by_id
)
537 #a.graph_attr['normalize'] = True
538 #a.graph_attr['level'] = 2
541 svg
= a
.draw(format
='svg')
547 if 'forcer' in request
.GET
:
548 response
= HttpResponse(svg
, mimetype
='image/svg+xml')
549 response
['Content-Disposition'] = 'attachment; filename=organigramme.svg'
552 return render_to_response('rh/organigrammes/employe.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
556 @drh_or_admin_required
557 def organigrammes_service(request
, id):
559 service
= get_object_or_404(rh
.Service
, pk
=id)
560 svg
= rh_graph
.organigramme_postes_cluster( \
561 cluster_filter
={"service": service
}, \
562 titre
=u
"Organigramme du service %s" % service
.nom
,
563 cluster_titre
=service
.nom
)
569 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
572 @drh_or_admin_required
573 def organigrammes_implantation(request
, id):
575 implantation
= get_object_or_404(ref
.Implantation
, pk
=id)
576 svg
= rh_graph
.organigramme_postes_cluster( \
577 cluster_filter
={"implantation": implantation
}, \
578 titre
=u
"Organigramme de l'implantation %s" % implantation
.nom
,
579 cluster_titre
=implantation
.nom
)
585 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
588 @drh_or_admin_required
589 def organigrammes_region(request
, id):
591 region
= get_object_or_404(ref
.Region
, pk
=id)
592 svg
= rh_graph
.organigramme_postes_cluster( \
593 cluster_filter
={"implantation__region": region
}, \
594 titre
=u
"Organigramme du bureau de %s" % region
.nom
,
595 cluster_titre
=region
.nom
)
601 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")