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
25 # pas de reference a DAE devrait etre refactorisé
26 from dae
.utils
import get_employe_from_user
27 from dae
.decorators
import redirect_interdiction
28 from dae
.workflow
import grp_drh
, grp_correspondants_rh
29 from django
.conf
import settings
34 """Profil personnel de l'employé - éditable"""
35 rc
= RequestContext(request
)
38 employe
= rc
['this_employe']
40 c
['user'] = request
.user
41 c
['employe'] = employe
42 return render_to_response('rh/profil.html', c
, rc
)
46 def employes_liste(request
):
47 """Liste des employés."""
49 employes
= rh
.Employe
.objects \
50 .exclude(dossiers__date_debut__gt
=today
) \
51 .exclude(dossiers__date_fin__lt
=today
) \
57 return render_to_response('rh/employes_liste.html',
59 RequestContext(request
))
63 def employe(request
, id):
64 """Information publique sur un employé."""
66 employe
= rh
.Employe
.objects
.get(pk
=id)
68 employe
= rh
.Employe
.objects
.none()
73 return render_to_response('rh/employe.html', c
, RequestContext(request
))
77 @drh_or_admin_required
78 def rapports_poste(request
):
80 lookup_params
= dict(request
.GET
.items())
82 for key
, value
in lookup_params
.items():
83 if key
== 'o' or key
== 'ot':
84 del lookup_params
[key
]
86 if not isinstance(key
, str):
87 # 'key' will be used as a keyword argument later, so Python
88 # requires it to be a string.
89 del lookup_params
[key
]
90 lookup_params
[smart_str(key
)] = value
93 del lookup_params
[key
]
95 postes
= rh
.Poste
.objects
.select_related('implantation') \
96 .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' % \
97 ("%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 "") \
99 .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' % \
100 ("%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 "") \
102 .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' % \
103 ("%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 "") \
106 postes
= postes
.filter(**lookup_params
)
107 if 'o' in request
.GET
:
108 postes
= postes
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
115 'implantation': p
.implantation
,
116 '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('|'))] })
120 ("id", u
"# du poste"),
121 ("nom", u
"Nom du poste"),
122 ("implantation__id", u
"Implantation"),
123 ("employe_nom", u
"Nom"),
125 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
127 'title': 'Rapport des postes',
130 'headers': list(h
.headers()),
133 return render_to_response('rh/rapports/postes.html', c
, RequestContext(request
))
136 @drh_or_admin_required
137 def rapports_contrat(request
):
138 if 'HTTP_REFERER' in request
.META
.keys():
139 referer
= request
.META
['HTTP_REFERER']
140 referer
= "/".join(referer
.split('/')[3:])
141 referer
= "/%s" % referer
.split('?')[0]
142 if referer
!= reverse('rhr_contrats'):
143 params
= request
.GET
.copy()
144 params
.update({'statut': 'Actif'})
147 lookup_params
= dict(request
.GET
.items())
148 if 'ot' in lookup_params
:
149 del lookup_params
['ot']
150 if 'o' in lookup_params
:
151 del lookup_params
['o']
153 for key
, value
in lookup_params
.items():
154 if not isinstance(key
, str):
155 # 'key' will be used as a keyword argument later, so Python
156 # requires it to be a string.
157 del lookup_params
[key
]
158 lookup_params
[smart_str(key
)] = value
160 contrats
= rh
.Contrat
.objects
.select_related('dossier', 'dossier__poste', 'dossier__poste__implantation', 'type_contrat', 'dossier__employe')
162 cl
= RechercheTemporelle(dict(request
.GET
.items()), rh
.Contrat
)
163 lookup_params
= cl
.purge_params(lookup_params
)
164 q_temporel
= cl
.get_q_temporel(contrats
)
165 q
= Q(**lookup_params
) & q_temporel
166 contrats
= contrats
.filter(q
).exclude(dossier__employe__supprime
=1)
168 if 'o' in request
.GET
:
169 contrats
= contrats
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
171 employes
= set([c
.dossier
.employe_id
for c
in contrats
])
174 ("dossier__employe__id", u
"# de l'employé"),
175 ("dossier__employe__nom", u
"Nom"),
176 ("dossier__employe__prenom", u
"Prénom"),
177 ("type_contrat__nom", u
"Poste"),
178 ("type_contrat__nom", u
"Type de contrat"),
179 ("date_debut", u
"Date début"),
180 ("date_fin", u
"Date fin"),
182 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
186 'title': 'Rapport des contrats',
187 'contrats': contrats
,
188 'count': len(contrats
),
189 'count_employe' : len(employes
),
190 'headers': list(h
.headers()),
193 return render_to_response('rh/rapports/contrats.html', c
, RequestContext(request
))
197 @drh_or_admin_required
198 def rapports_remuneration(request
):
200 lookup_params
= dict(request
.GET
.items())
201 if 'ot' in lookup_params
:
202 del lookup_params
['ot']
203 if 'o' in lookup_params
:
204 del lookup_params
['o']
206 for key
, value
in lookup_params
.items():
207 if not isinstance(key
, str):
208 # 'key' will be used as a keyword argument later, so Python
209 # requires it to be a string.
210 del lookup_params
[key
]
211 lookup_params
[smart_str(key
)] = value
213 employes
= rh
.Employe
.objects
.all()
214 if 'o' in request
.GET
:
215 employes
= employes
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
217 employes
= employes
.filter(**lookup_params
)
221 ("id", u
"# de l'employé"),
223 ("prenom", u
"Prénom"),
228 ("", u
"Charges patronales"),
231 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
233 for employe
in employes
:
237 dossiers
= employe
.rh_dossiers
.all()
242 for dossier
in dossiers
:
243 this_remun
, this_remun_sum
, this_remun_sum_euro
= calc_remun(dossier
)
245 for item
in this_remun
:
246 if item
not in remun
:
247 remun
[item
] = this_remun
[item
]
249 remun
[item
][0] += this_remun
[item
][0]
250 remun
[item
][1] += this_remun
[item
][1]
252 remun_sum_euro
+= this_remun_sum_euro
254 line
['remun_sum_euro'] = remun_sum_euro
257 if r
== u
'Indemnité':
258 line
['Indemnite'] = remun
[r
][1]
260 line
[r
] = remun
[r
][1]
262 line
['id'] = employe
.id
263 line
['nom'] = employe
.nom
264 line
['prenom'] = employe
.prenom
268 'title': 'Rapport de remuneration',
270 'headers': list(h
.headers()),
273 return render_to_response('rh/rapports/remuneration.html', c
, RequestContext(request
))
276 @drh_or_admin_required
277 def rapports_employe_sans_contrat(request
):
279 lookup_params
= dict(request
.GET
.items())
280 if 'ot' in lookup_params
:
281 del lookup_params
['ot']
282 if 'o' in lookup_params
:
283 del lookup_params
['o']
285 for key
, value
in lookup_params
.items():
286 if not isinstance(key
, str):
287 # 'key' will be used as a keyword argument later, so Python
288 # requires it to be a string.
289 del lookup_params
[key
]
290 lookup_params
[smart_str(key
)] = value
292 employes_query
= rh
.Employe
.objects
293 if 'o' in request
.GET
:
294 employes_query
= employes_query
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
298 dossiers_en_cours
= rh
.Dossier
.objects
.filter(Q(date_fin
=None) |
Q(date_fin__gt
=date
.today()))
299 tous_contrats_echus
= rh
.Contrat
.objects
.filter(date_fin__lt
=date
.today(), dossier__in
=dossiers_en_cours
)
300 contrats
= tous_contrats_echus
.filter(**lookup_params
).all()
302 if c
.dossier
.employe
.id not in employes
.keys():
303 employes
[c
.dossier
.employe
.id] = {'employe': c
.dossier
.employe
, 'dossiers': []}
304 employes
[c
.dossier
.employe
.id]['dossiers'] += [c
.dossier
,]
309 ("id", u
"# de l'employé"),
311 ("prenom", u
"Prénom"),
312 ("dossier", u
"Dossiers"),
314 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o", not_sortable
=('dossier',))
317 'title': u
'Rapport des employés sans contrat',
318 'employes': employes
,
319 'count': len(employes
),
320 'headers': list(h
.headers()),
323 return render_to_response('rh/rapports/employes_sans_contrat.html', c
, RequestContext(request
))
326 @drh_or_admin_required
327 def rapports_postes_modelisation(request
):
331 for f
in rh
.FamilleEmploi
.objects
.all():
332 types
= rh
.TypePoste
.objects
.filter(famille_emploi
=f
)
334 for t
in types
.all():
335 postes
= rh
.Poste
.objects
.filter(type_poste
=t
)
337 'num_postes': postes
.count(),
338 'postes': postes
.all(),
344 'nb_types': types
.count(),
351 return render_to_response('rh/rapports/postes_modelisation.html', c
, RequestContext(request
))
355 @drh_or_admin_required
356 def rapports_postes_implantation(request
):
359 for r
in ref
.Region
.objects
.all():
361 for i
in ref
.Implantation
.objects
.filter(region
=r
):
362 implantations
.append({
364 'postes': rh
.Poste
.objects
.filter(implantation
=i
),
365 'num_postes': rh
.Poste
.objects
.filter(implantation
=i
).count(),
369 'implantations': implantations
375 return render_to_response('rh/rapports/postes_implantation.html', c
, RequestContext(request
))
379 @drh_or_admin_required
380 def rapports_postes_service(request
):
383 for s
in rh
.Service
.objects
.all():
384 postes
= rh
.Poste
.objects
.filter(service
=s
).all()
385 num_postes
= rh
.Poste
.objects
.filter(service
=s
).count()
386 data
.append({'service': s
, 'num_postes': num_postes
, 'postes': postes
})
389 return render_to_response('rh/rapports/postes_service.html', c
, RequestContext(request
))
392 def region_protected(model
):
394 def wrapped(request
, id):
395 if request
.user
.is_superuser
:
396 return func(request
, id)
397 user_groups
= request
.user
.groups
.all()
398 if grp_drh
in user_groups
:
399 return func(request
, id)
400 if grp_correspondants_rh
in user_groups
:
401 employe
= get_employe_from_user(request
.user
)
402 q
= Q(**{model
.prefix_implantation
: employe
.implantation
.region
})
403 qs
= model
.objects
.filter(q
)
404 if int(id) in [o
.id for o
in qs
]:
405 return func(request
, id)
406 return redirect_interdiction(request
)
411 @region_protected(rh
.Dossier
)
412 def dossier_apercu(request
, dossier_id
):
413 d
= get_object_or_404(rh
.Dossier
, pk
=dossier_id
)
415 'title': u
"Dossier %s" % (d
, ),
416 'is_popup' : request
.GET
.get('_popup', False),
418 'pieces' : rh
.DossierPiece
.objects
.filter(dossier__exact
=d
),
419 'contrats' : rh
.Contrat
.objects
.filter(dossier__exact
=d
),
420 'commentaires' : rh
.DossierCommentaire
.objects
.filter(dossier__exact
=d
).all(),
421 'media_url': settings
.PRIVE_MEDIA_URL
,
423 return render_to_response('admin/rh/dossier/apercu.html', c
, RequestContext(request
))
425 @region_protected(rh
.Poste
)
426 def poste_apercu(request
, poste_id
):
427 p
= get_object_or_404(rh
.Poste
, pk
=poste_id
)
429 'title': u
"Poste %s" % (p
, ),
430 'is_popup' : request
.GET
.get('_popup', False),
432 'financements' : rh
.PosteFinancement
.objects
.filter(poste
=poste_id
).all(),
433 'pieces' : rh
.PostePiece
.objects
.filter(poste
=poste_id
).all(),
434 'dossiers' : rh
.Dossier
.objects
.filter(poste
=poste_id
).order_by("-date_debut").all(),
435 'comparaisons' : rh
.PosteComparaison
.objects
.filter(poste
=poste_id
).all(),
436 'commentaires' : rh
.PosteCommentaire
.objects
.filter(poste
=poste_id
).all(),
437 'media_url': settings
.PRIVE_MEDIA_URL
,
439 return render_to_response('admin/rh/poste/apercu.html', c
, RequestContext(request
))
441 def employe_apercu(request
, employe_id
):
442 employe
= get_object_or_404(rh
.Employe
, pk
=employe_id
)
443 user_groups
= request
.user
.groups
.all()
446 if request
.user
.is_superuser
or \
447 grp_drh
in user_groups
:
448 q
= Q(employe
=employe
)
449 if grp_correspondants_rh
in user_groups
:
450 regions
= [d
.poste
.implantation
.region
for d
in employe
.rh_dossiers
.all()]
451 q
= Q(employe
=employe
) & Q(implantation__region__in
=regions
)
453 dossiers
= rh
.Dossier
.objects
.filter(q
).order_by('-date_debut')
456 'title': u
"Employe %s" % (employe
, ),
457 'is_popup' : request
.GET
.get('_popup', False),
459 'dossiers' : dossiers
,
460 'media_url': settings
.PRIVE_MEDIA_URL
,
462 return render_to_response('admin/rh/employe/apercu.html', c
, RequestContext(request
))
465 @drh_or_admin_required
466 def organigrammes_employe(request
, id, level
="all"):
468 poste
= get_object_or_404(rh
.Poste
, pk
=id)
469 dossiers_by_poste
= dict((d
.poste_id
, d
) for d
in rh
.Dossier
.objects
.select_related('employe', 'poste').all())
470 postes_by_id
= dict((p
.id, p
) for p
in rh
.Poste
.objects
.all())
472 e
= dossiers_by_poste
[poste
.id].employe
473 name
= u
"Organigramme de [%s] %s %s" % (e
.id, e
.nom
.upper(), e
.prenom
)
476 if rh
.Poste
.objects
.filter(responsable
=poste
).count() > 0:
477 postes_handle
= [poste
]
479 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()
481 for p
in postes_handle
:
482 if p
.responsable_id
!= p
.id:
483 graph
.add_edge(dossiers_by_poste
[p
.responsable_id
].poste_id
, p
.id)
486 graph
.add_node(poste
.id)
489 postes_niveau
= [poste
.id]
490 for niveau
in range(int(level
)):
491 postes_niveau
= [p
.id for p
in rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()]
494 postes_niveau
= [p
.id for p
in rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()]
496 for p
in postes_niveau
:
497 if graph
.has_node(p
):
501 a
.name
= name
.encode('ascii', 'xmlcharrefreplace')
503 poste_remontant
= poste
504 while poste_remontant
.responsable_id
:
505 a
.add_edge(poste_remontant
.responsable_id
, poste_remontant
.id)
506 poste_remontant
= poste_remontant
.responsable
508 rh_graph
.bind_poste_to_graph(a
, postes_by_id
)
509 #a.graph_attr['normalize'] = True
510 #a.graph_attr['level'] = 2
513 svg
= a
.draw(format
='svg')
519 if 'forcer' in request
.GET
:
520 response
= HttpResponse(svg
, mimetype
='image/svg+xml')
521 response
['Content-Disposition'] = 'attachment; filename=organigramme.svg'
524 return render_to_response('rh/organigrammes/employe.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
528 @drh_or_admin_required
529 def organigrammes_service(request
, id):
531 service
= get_object_or_404(rh
.Service
, pk
=id)
532 svg
= rh_graph
.organigramme_postes_cluster( \
533 cluster_filter
={"service": service
}, \
534 titre
=u
"Organigramme du service %s" % service
.nom
,
535 cluster_titre
=service
.nom
)
541 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
544 @drh_or_admin_required
545 def organigrammes_implantation(request
, id):
547 implantation
= get_object_or_404(ref
.Implantation
, pk
=id)
548 svg
= rh_graph
.organigramme_postes_cluster( \
549 cluster_filter
={"implantation": implantation
}, \
550 titre
=u
"Organigramme de l'implantation %s" % implantation
.nom
,
551 cluster_titre
=implantation
.nom
)
557 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
560 @drh_or_admin_required
561 def organigrammes_region(request
, id):
563 region
= get_object_or_404(ref
.Region
, pk
=id)
564 svg
= rh_graph
.organigramme_postes_cluster( \
565 cluster_filter
={"implantation__region": region
}, \
566 titre
=u
"Organigramme du bureau de %s" % region
.nom
,
567 cluster_titre
=region
.nom
)
573 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")