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
= [(row
[0], row
[0]) for row
in masse
.rapport
[0]]
221 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
222 c
['headers'] = list(h
.headers())
224 return render_to_response('rh/rapports/masse_salariale.html', c
, RequestContext(request
))
228 @drh_or_admin_required
229 def rapports_remuneration(request
):
231 lookup_params
= dict(request
.GET
.items())
232 if 'ot' in lookup_params
:
233 del lookup_params
['ot']
234 if 'o' in lookup_params
:
235 del lookup_params
['o']
237 for key
, value
in lookup_params
.items():
238 if not isinstance(key
, str):
239 # 'key' will be used as a keyword argument later, so Python
240 # requires it to be a string.
241 del lookup_params
[key
]
242 lookup_params
[smart_str(key
)] = value
244 employes
= rh
.Employe
.objects
.all()
245 if 'o' in request
.GET
:
246 employes
= employes
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
248 employes
= employes
.filter(**lookup_params
)
252 ("id", u
"# de l'employé"),
254 ("prenom", u
"Prénom"),
259 ("", u
"Charges patronales"),
262 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o")
264 for employe
in employes
:
268 dossiers
= employe
.rh_dossiers
.all()
273 for dossier
in dossiers
:
274 this_remun
, this_remun_sum
, this_remun_sum_euro
= calc_remun(dossier
)
276 for item
in this_remun
:
277 if item
not in remun
:
278 remun
[item
] = this_remun
[item
]
280 remun
[item
][0] += this_remun
[item
][0]
281 remun
[item
][1] += this_remun
[item
][1]
283 remun_sum_euro
+= this_remun_sum_euro
285 line
['remun_sum_euro'] = remun_sum_euro
288 if r
== u
'Indemnité':
289 line
['Indemnite'] = remun
[r
][1]
291 line
[r
] = remun
[r
][1]
293 line
['id'] = employe
.id
294 line
['nom'] = employe
.nom
295 line
['prenom'] = employe
.prenom
299 'title': 'Rapport de remuneration',
301 'headers': list(h
.headers()),
304 return render_to_response('rh/rapports/remuneration.html', c
, RequestContext(request
))
307 @drh_or_admin_required
308 def rapports_employe_sans_contrat(request
):
310 lookup_params
= dict(request
.GET
.items())
311 if 'ot' in lookup_params
:
312 del lookup_params
['ot']
313 if 'o' in lookup_params
:
314 del lookup_params
['o']
316 for key
, value
in lookup_params
.items():
317 if not isinstance(key
, str):
318 # 'key' will be used as a keyword argument later, so Python
319 # requires it to be a string.
320 del lookup_params
[key
]
321 lookup_params
[smart_str(key
)] = value
323 employes_query
= rh
.Employe
.objects
324 if 'o' in request
.GET
:
325 employes_query
= employes_query
.order_by("%s%s" % ('-' if 'ot' in request
.GET
and request
.GET
['ot'] == "desc" else '', request
.GET
['o']))
329 dossiers_en_cours
= rh
.Dossier
.objects
.filter(Q(date_fin
=None) |
Q(date_fin__gt
=date
.today()))
330 tous_contrats_echus
= rh
.Contrat
.objects
.filter(date_fin__lt
=date
.today(), dossier__in
=dossiers_en_cours
)
331 contrats
= tous_contrats_echus
.filter(**lookup_params
).all()
333 if c
.dossier
.employe
.id not in employes
.keys():
334 employes
[c
.dossier
.employe
.id] = {'employe': c
.dossier
.employe
, 'dossiers': []}
335 employes
[c
.dossier
.employe
.id]['dossiers'] += [c
.dossier
,]
340 ("id", u
"# de l'employé"),
342 ("prenom", u
"Prénom"),
343 ("dossier", u
"Dossiers"),
345 h
= SortHeaders(request
, headers
, order_field_type
="ot", order_field
="o", not_sortable
=('dossier',))
348 'title': u
'Rapport des employés sans contrat',
349 'employes': employes
,
350 'count': len(employes
),
351 'headers': list(h
.headers()),
354 return render_to_response('rh/rapports/employes_sans_contrat.html', c
, RequestContext(request
))
357 @drh_or_admin_required
358 def rapports_postes_modelisation(request
):
362 for f
in rh
.FamilleEmploi
.objects
.all():
363 types
= rh
.TypePoste
.objects
.filter(famille_emploi
=f
)
365 for t
in types
.all():
366 postes
= rh
.Poste
.objects
.filter(type_poste
=t
)
368 'num_postes': postes
.count(),
369 'postes': postes
.all(),
375 'nb_types': types
.count(),
382 return render_to_response('rh/rapports/postes_modelisation.html', c
, RequestContext(request
))
386 @drh_or_admin_required
387 def rapports_postes_implantation(request
):
390 for r
in ref
.Region
.objects
.all():
392 for i
in ref
.Implantation
.objects
.filter(region
=r
):
393 implantations
.append({
395 'postes': rh
.Poste
.objects
.filter(implantation
=i
),
396 'num_postes': rh
.Poste
.objects
.filter(implantation
=i
).count(),
400 'implantations': implantations
406 return render_to_response('rh/rapports/postes_implantation.html', c
, RequestContext(request
))
410 @drh_or_admin_required
411 def rapports_postes_service(request
):
414 for s
in rh
.Service
.objects
.all():
415 postes
= rh
.Poste
.objects
.filter(service
=s
).all()
416 num_postes
= rh
.Poste
.objects
.filter(service
=s
).count()
417 data
.append({'service': s
, 'num_postes': num_postes
, 'postes': postes
})
420 return render_to_response('rh/rapports/postes_service.html', c
, RequestContext(request
))
423 def region_protected(model
):
425 def wrapped(request
, id):
426 if request
.user
.is_superuser
:
427 return func(request
, id)
428 user_groups
= request
.user
.groups
.all()
429 if grp_drh
in user_groups
:
430 return func(request
, id)
431 if grp_correspondants_rh
in user_groups
:
432 employe
= get_employe_from_user(request
.user
)
433 q
= Q(**{model
.prefix_implantation
: employe
.implantation
.region
})
434 qs
= model
.objects
.filter(q
)
435 if int(id) in [o
.id for o
in qs
]:
436 return func(request
, id)
437 return redirect_interdiction(request
)
442 @region_protected(rh
.Dossier
)
443 def dossier_apercu(request
, dossier_id
):
444 d
= get_object_or_404(rh
.Dossier
, pk
=dossier_id
)
446 'is_popup' : request
.GET
.get('_popup', False),
448 'pieces' : rh
.DossierPiece
.objects
.filter(dossier__exact
=d
),
449 'contrats' : rh
.Contrat
.objects
.filter(dossier__exact
=d
),
450 'commentaires' : rh
.DossierCommentaire
.objects
.filter(dossier__exact
=d
).all(),
451 'media_url': settings
.PRIVE_MEDIA_URL
,
453 return render_to_response('admin/rh/dossier/apercu.html', c
, RequestContext(request
))
455 @region_protected(rh
.Poste
)
456 def poste_apercu(request
, poste_id
):
458 'is_popup' : request
.GET
.get('_popup', False),
459 'poste' : get_object_or_404(rh
.Poste
, pk
=poste_id
),
460 'financements' : rh
.PosteFinancement
.objects
.filter(poste
=poste_id
).all(),
461 'pieces' : rh
.PostePiece
.objects
.filter(poste
=poste_id
).all(),
462 'dossiers' : rh
.Dossier
.objects
.filter(poste
=poste_id
).order_by("-date_debut").all(),
463 'comparaisons' : rh
.PosteComparaison
.objects
.filter(poste
=poste_id
).all(),
464 'commentaires' : rh
.PosteCommentaire
.objects
.filter(poste
=poste_id
).all(),
465 'media_url': settings
.PRIVE_MEDIA_URL
,
467 return render_to_response('admin/rh/poste/apercu.html', c
, RequestContext(request
))
469 def employe_apercu(request
, employe_id
):
470 employe
= get_object_or_404(rh
.Employe
, pk
=employe_id
)
471 user_groups
= request
.user
.groups
.all()
474 if request
.user
.is_superuser
or \
475 grp_drh
in user_groups
:
476 q
= Q(employe
=employe
)
477 if grp_correspondants_rh
in user_groups
:
478 regions
= [d
.poste
.implantation
.region
for d
in employe
.rh_dossiers
.all()]
479 q
= Q(employe
=employe
) & Q(implantation__region__in
=regions
)
481 dossiers
= rh
.Dossier
.objects
.filter(q
).order_by('-date_debut')
484 'is_popup' : request
.GET
.get('_popup', False),
486 'dossiers' : dossiers
,
487 'media_url': settings
.PRIVE_MEDIA_URL
,
489 return render_to_response('admin/rh/employe/apercu.html', c
, RequestContext(request
))
492 @drh_or_admin_required
493 def organigrammes_employe(request
, id, level
="all"):
495 poste
= get_object_or_404(rh
.Poste
, pk
=id)
496 dossiers_by_poste
= dict((d
.poste_id
, d
) for d
in rh
.Dossier
.objects
.select_related('employe', 'poste').all())
497 postes_by_id
= dict((p
.id, p
) for p
in rh
.Poste
.objects
.all())
499 e
= dossiers_by_poste
[poste
.id].employe
500 name
= u
"Organigramme de [%s] %s %s" % (e
.id, e
.nom
.upper(), e
.prenom
)
503 if rh
.Poste
.objects
.filter(responsable
=poste
).count() > 0:
504 postes_handle
= [poste
]
506 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()
508 for p
in postes_handle
:
509 if p
.responsable_id
!= p
.id:
510 graph
.add_edge(dossiers_by_poste
[p
.responsable_id
].poste_id
, p
.id)
513 graph
.add_node(poste
.id)
516 postes_niveau
= [poste
.id]
517 for niveau
in range(int(level
)):
518 postes_niveau
= [p
.id for p
in rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()]
521 postes_niveau
= [p
.id for p
in rh
.Poste
.objects
.filter(responsable__in
=postes_niveau
).all()]
523 for p
in postes_niveau
:
524 if graph
.has_node(p
):
528 a
.name
= name
.encode('ascii', 'xmlcharrefreplace')
530 poste_remontant
= poste
531 while poste_remontant
.responsable_id
:
532 a
.add_edge(poste_remontant
.responsable_id
, poste_remontant
.id)
533 poste_remontant
= poste_remontant
.responsable
535 rh_graph
.bind_poste_to_graph(a
, postes_by_id
)
536 #a.graph_attr['normalize'] = True
537 #a.graph_attr['level'] = 2
540 svg
= a
.draw(format
='svg')
546 if 'forcer' in request
.GET
:
547 response
= HttpResponse(svg
, mimetype
='image/svg+xml')
548 response
['Content-Disposition'] = 'attachment; filename=organigramme.svg'
551 return render_to_response('rh/organigrammes/employe.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
555 @drh_or_admin_required
556 def organigrammes_service(request
, id):
558 service
= get_object_or_404(rh
.Service
, pk
=id)
559 svg
= rh_graph
.organigramme_postes_cluster( \
560 cluster_filter
={"service": service
}, \
561 titre
=u
"Organigramme du service %s" % service
.nom
,
562 cluster_titre
=service
.nom
)
568 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
571 @drh_or_admin_required
572 def organigrammes_implantation(request
, id):
574 implantation
= get_object_or_404(ref
.Implantation
, pk
=id)
575 svg
= rh_graph
.organigramme_postes_cluster( \
576 cluster_filter
={"implantation": implantation
}, \
577 titre
=u
"Organigramme de l'implantation %s" % implantation
.nom
,
578 cluster_titre
=implantation
.nom
)
584 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")
587 @drh_or_admin_required
588 def organigrammes_region(request
, id):
590 region
= get_object_or_404(ref
.Region
, pk
=id)
591 svg
= rh_graph
.organigramme_postes_cluster( \
592 cluster_filter
={"implantation__region": region
}, \
593 titre
=u
"Organigramme du bureau de %s" % region
.nom
,
594 cluster_titre
=region
.nom
)
600 return render_to_response('rh/organigrammes/vide.html', c
, RequestContext(request
), mimetype
="image/svg+xml")