project/rh/views.py

   1 # -*- encoding: utf-8 -*-
   2
   3 import urllib
   4 from datetime import date
   5 from itertools import izip
   6
   7 import pygraphviz as pgv
   8
   9 from django.core.urlresolvers import reverse
  10 from django.db.models import Q
  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
  15 from django import forms
  16 from django.contrib.auth.decorators import login_required
  17 from django.contrib.admin import widgets as adminwidgets
  18
  19 from datamaster_modeles import models as ref
  20
  21 from rh import models as rh
  22 from rh.lib import calc_remun
  23 from rh.decorators import drh_or_admin_required
  24 from rh.templatetags.rapports import SortHeaders
  25 from rh.change_list import RechercheTemporelle
  26 from rh import graph as rh_graph
  27 from rh.masse_salariale import MasseSalariale
  28
  29 # pas de reference a DAE devrait etre refactorisé
  30 from dae.utils import get_employe_from_user
  31 from dae.decorators import redirect_interdiction
  32 from dae.workflow import grp_drh, grp_correspondants_rh
  33 from django.conf import settings
  34
  35
  36 @login_required
  37 def profil(request):
  38     """Profil personnel de l'employé - éditable"""
  39     rc = RequestContext(request)
  40     c = {}
  41
  42     employe = rc['this_employe']
  43
  44     c['user'] = request.user
  45     c['employe'] = employe
  46     return render_to_response('rh/profil.html', c, rc)
  47
  48
  49 @login_required
  50 def employes_liste(request):
  51     """Liste des employés."""
  52     today = date.today()
  53     employes = rh.Employe.objects   \
  54                     .exclude(dossiers__date_debut__gt=today) \
  55                     .exclude(dossiers__date_fin__lt=today) \
  56                     .order_by('nom')
  57     c = {
  58         'user': request.user,
  59         'employes': employes,
  60         }
  61     return render_to_response('rh/employes_liste.html',
  62             c,
  63             RequestContext(request))
  64
  65
  66 @login_required
  67 def employe(request, id):
  68     """Information publique sur un employé."""
  69     try:
  70         employe = rh.Employe.objects.get(pk=id)
  71     except:
  72         employe = rh.Employe.objects.none()
  73     c = {
  74         'user': request.user,
  75         'employe': employe,
  76         }
  77     return render_to_response('rh/employe.html', c, RequestContext(request))
  78
  79
  80 @login_required
  81 @drh_or_admin_required
  82 def rapports_poste(request):
  83
  84     lookup_params = dict(request.GET.items())
  85
  86     for key, value in lookup_params.items():
  87         if key == 'o' or key == 'ot':
  88             del lookup_params[key]
  89             continue
  90         if not isinstance(key, str):
  91             # 'key' will be used as a keyword argument later, so Python
  92             # requires it to be a string.
  93             del lookup_params[key]
  94             lookup_params[smart_str(key)] = value
  95
  96         if key == 'comble':
  97             del lookup_params[key]
  98
  99     postes = rh.Poste.objects.select_related('implantation') \
 100             .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' % \
 101                 ("%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 "") \
 102             }) \
 103             .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' % \
 104                 ("%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 "") \
 105             }) \
 106             .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' % \
 107                 ("%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 "") \
 108             })
 109
 110     postes = postes.filter(**lookup_params)
 111     if 'o' in request.GET:
 112         postes = postes.order_by("%s%s" % ('-' if 'ot' in request.GET and request.GET['ot'] == "desc" else '', request.GET['o']))
 113
 114     out = []
 115     for p in postes:
 116         out.append({
 117             'id': p.id,
 118             'nom': p.nom,
 119             'implantation': p.implantation,
 120             '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
 122
 123     headers = [
 124         ("id", u"# du poste"),
 125         ("nom", u"Nom du poste"),
 126         ("implantation__id", u"Implantation"),
 127         ("employe_nom", u"Nom"),
 128     ]
 129     h = SortHeaders(request, headers, order_field_type="ot", order_field="o")
 130     c = {
 131         'title': 'Rapport des postes',
 132         'postes': out,
 133         'count': len(out),
 134         'headers': list(h.headers()),
 135     }
 136
 137     return render_to_response('rh/rapports/postes.html', c, RequestContext(request))
 138
 139 @login_required
 140 @drh_or_admin_required
 141 def rapports_contrat(request):
 142     if 'HTTP_REFERER' in request.META.keys():
 143                 referer = request.META['HTTP_REFERER']
 144                 referer = "/".join(referer.split('/')[3:])
 145                 referer = "/%s" % referer.split('?')[0]
 146                 if referer != reverse('rhr_contrats'):
 147                     params = request.GET.copy()
 148                     params.update({'statut': 'Actif'})
 149                     request.GET = params
 150
 151     lookup_params = dict(request.GET.items())
 152     if 'ot' in lookup_params:
 153         del lookup_params['ot']
 154     if 'o' in lookup_params:
 155         del lookup_params['o']
 156
 157     for key, value in lookup_params.items():
 158         if not isinstance(key, str):
 159             # 'key' will be used as a keyword argument later, so Python
 160             # requires it to be a string.
 161             del lookup_params[key]
 162             lookup_params[smart_str(key)] = value
 163
 164     contrats = rh.Contrat.objects.select_related('dossier', 'dossier__poste', 'dossier__poste__implantation', 'type_contrat', 'dossier__employe')
 165
 166     cl = RechercheTemporelle(dict(request.GET.items()), rh.Contrat)
 167     lookup_params = cl.purge_params(lookup_params)
 168     q_temporel = cl.get_q_temporel(contrats)
 169     q = Q(**lookup_params) & q_temporel
 170     contrats = contrats.filter(q).exclude(dossier__employe__supprime=1)
 171
 172     if 'o' in request.GET:
 173         contrats = contrats.order_by("%s%s" % ('-' if 'ot' in request.GET and request.GET['ot'] == "desc" else '', request.GET['o']))
 174
 175     employes = set([c.dossier.employe_id for c in contrats])
 176
 177     headers = [
 178         ("dossier__employe__id", u"# de l'employé"),
 179         ("dossier__employe__nom", u"Nom"),
 180         ("dossier__employe__prenom", u"Prénom"),
 181         ("type_contrat__nom", u"Poste"),
 182         ("type_contrat__nom", u"Type de contrat"),
 183         ("date_debut", u"Date début"),
 184         ("date_fin", u"Date fin"),
 185     ]
 186     h = SortHeaders(request, headers, order_field_type="ot", order_field="o")
 187
 188     c = {
 189         'cl' : cl,
 190         'title': 'Rapport des contrats',
 191         'contrats': contrats,
 192         'count': len(contrats),
 193         'count_employe' : len(employes),
 194         'headers': list(h.headers()),
 195     }
 196
 197     return render_to_response('rh/rapports/contrats.html', c, RequestContext(request))
 198
 199
 200 @login_required
 201 @drh_or_admin_required
 202 def rapports_masse_salariale(request):
 203
 204     class RechercheTemporelle(forms.Form):
 205         CHOICE_ANNEES = range(
 206                 rh.Remuneration.objects.exclude(date_debut=None) \
 207                         .order_by('date_debut')[0].date_debut.year
 208                 , date.today().year + 1)
 209
 210         annee = forms.CharField(initial=date.today().year,
 211                 widget=forms.Select(choices=
 212                     ((a, a) for a in reversed(CHOICE_ANNEES)
 213                 ))
 214         )
 215
 216         region = forms.CharField(
 217                 widget=forms.Select(choices=[('', '')] +
 218                     [(i.id, i) for i in ref.Region.objects.all()]
 219                 )
 220             )
 221
 222         implantation = forms.CharField(
 223                 widget=forms.Select(choices=[('', '')] +
 224                     [(i.id, i) for i in ref.Implantation.objects.all()]
 225                 )
 226             )
 227
 228         #date_debut = forms.DateField(widget=adminwidgets.AdminDateWidget)
 229         #date_fin = forms.DateField(widget=adminwidgets.AdminDateWidget)
 230
 231
 232     form = RechercheTemporelle(request.GET)
 233     get_filtre = [(k, v) for k,v in request.GET.items() \
 234             if k not in ('date_debut', 'date_fin', 'implantation', )]
 235     query_string = urllib.urlencode(get_filtre)
 236
 237     date_debut = None
 238     date_fin = None
 239     if request.GET.get('annee', None):
 240         date_debut = "01-01-%s" % request.GET.get('annee', None)
 241         date_fin = "31-12-%s" % request.GET.get('annee', None)
 242
 243     implantation = request.GET.get('implantation')
 244     region = request.GET.get('region')
 245
 246     custom_filter = {}
 247     if implantation:
 248         custom_filter['dossier__poste__implantation'] = implantation
 249     if region:
 250         custom_filter['dossier__poste__implantation__region'] = region
 251
 252     c = {
 253             'title': 'Rapport de masse salariale',
 254             'form': form,
 255             'headers': [],
 256             'query_string': query_string,
 257     }
 258     if date_debut or date_fin:
 259         masse = MasseSalariale(date_debut, date_fin, custom_filter,
 260                 request.GET.get('ne_pas_grouper', False))
 261         if masse.rapport:
 262             c['rapport'] = masse.rapport
 263             headers = masse.headers
 264             c['header_keys'] = [h[0] for h in masse.headers]
 265             h = SortHeaders(request, headers, order_field_type="ot",
 266                     not_sortable=c['header_keys'], order_field="o")
 267             c['headers'] = list(h.headers())
 268             c['total'] = masse.grand_totaux[0]
 269             c['total_euro'] = masse.grand_totaux[1]
 270             c['colspan'] = len(c['header_keys']) - 2
 271
 272     return render_to_response('rh/rapports/masse_salariale.html', c, RequestContext(request))
 273
 274
 275 @login_required
 276 @drh_or_admin_required
 277 def rapports_remuneration(request):
 278
 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']
 284
 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
 291
 292     employes = rh.Employe.objects.all()
 293     if 'o' in request.GET:
 294         employes = employes.order_by("%s%s" % ('-' if 'ot' in request.GET and request.GET['ot'] == "desc" else '', request.GET['o']))
 295
 296     employes = employes.filter(**lookup_params)
 297
 298     output = []
 299     headers = [
 300             ("id", u"# de l'employé"),
 301             ("nom", u"Nom"),
 302             ("prenom", u"Prénom"),
 303             ("", u"Salaire"),
 304             ("", u"RAS"),
 305             ("", u"Indemnités"),
 306             ("", u"Accessoire"),
 307             ("", u"Charges patronales"),
 308             ("", u"Total"),
 309     ]
 310     h = SortHeaders(request, headers, order_field_type="ot", order_field="o")
 311
 312     for employe in employes:
 313         line = {}
 314         output.append(line)
 315
 316         dossiers = employe.rh_dossiers.all()
 317
 318         remun = {}
 319         remun_sum_euro = 0
 320
 321         for dossier in dossiers:
 322             this_remun, this_remun_sum, this_remun_sum_euro = calc_remun(dossier)
 323
 324             for item in this_remun:
 325                 if item not in remun:
 326                     remun[item] = this_remun[item]
 327                 else:
 328                     remun[item][0] += this_remun[item][0]
 329                     remun[item][1] += this_remun[item][1]
 330
 331             remun_sum_euro += this_remun_sum_euro
 332
 333         line['remun_sum_euro'] = remun_sum_euro
 334
 335         for r in remun:
 336             if r == u'Indemnité':
 337                 line['Indemnite'] = remun[r][1]
 338             else:
 339                 line[r] = remun[r][1]
 340
 341         line['id'] = employe.id
 342         line['nom'] = employe.nom
 343         line['prenom'] = employe.prenom
 344
 345
 346     c = {
 347         'title': 'Rapport de remuneration',
 348         'employes': output,
 349         'headers': list(h.headers()),
 350     }
 351
 352     return render_to_response('rh/rapports/remuneration.html', c, RequestContext(request))
 353
 354 @login_required
 355 @drh_or_admin_required
 356 def rapports_employe_sans_contrat(request):
 357
 358     lookup_params = dict(request.GET.items())
 359     if 'ot' in lookup_params:
 360         del lookup_params['ot']
 361     if 'o' in lookup_params:
 362         del lookup_params['o']
 363
 364     for key, value in lookup_params.items():
 365         if not isinstance(key, str):
 366             # 'key' will be used as a keyword argument later, so Python
 367             # requires it to be a string.
 368             del lookup_params[key]
 369             lookup_params[smart_str(key)] = value
 370
 371     employes_query = rh.Employe.objects
 372     if 'o' in request.GET:
 373         employes_query = employes_query.order_by("%s%s" % ('-' if 'ot' in request.GET and request.GET['ot'] == "desc" else '', request.GET['o']))
 374
 375     employes = {}
 376
 377     dossiers_en_cours = rh.Dossier.objects.filter(Q(date_fin=None) | Q(date_fin__gt=date.today()))
 378     tous_contrats_echus = rh.Contrat.objects.filter(date_fin__lt=date.today(), dossier__in=dossiers_en_cours)
 379     contrats = tous_contrats_echus.filter(**lookup_params).all()
 380     for c in contrats:
 381         if c.dossier.employe.id not in employes.keys():
 382             employes[c.dossier.employe.id] = {'employe': c.dossier.employe, 'dossiers': []}
 383         employes[c.dossier.employe.id]['dossiers'] += [c.dossier,]
 384
 385
 386
 387     headers = [
 388         ("id", u"# de l'employé"),
 389         ("nom", u"Nom"),
 390         ("prenom", u"Prénom"),
 391         ("dossier", u"Dossiers"),
 392     ]
 393     h = SortHeaders(request, headers, order_field_type="ot", order_field="o", not_sortable=('dossier',))
 394
 395     c = {
 396         'title': u'Rapport des employés sans contrat',
 397         'employes': employes,
 398         'count': len(employes),
 399         'headers': list(h.headers()),
 400     }
 401
 402     return render_to_response('rh/rapports/employes_sans_contrat.html', c, RequestContext(request))
 403
 404 @login_required
 405 @drh_or_admin_required
 406 def rapports_postes_modelisation(request):
 407     c = {}
 408     data = []
 409
 410     for f in rh.FamilleEmploi.objects.all():
 411         types = rh.TypePoste.objects.filter(famille_emploi=f)
 412         data_types = []
 413         for t in types.all():
 414             postes = rh.Poste.objects.filter(type_poste=t)
 415             data_types.append({
 416                 'num_postes': postes.count(),
 417                 'postes': postes.all(),
 418                 'type': f,
 419                 })
 420
 421         data.append({
 422             'famille': f,
 423             'nb_types': types.count(),
 424             'types' : data_types
 425             })
 426
 427     c['data'] = data
 428
 429
 430     return render_to_response('rh/rapports/postes_modelisation.html', c, RequestContext(request))
 431
 432
 433 @login_required
 434 @drh_or_admin_required
 435 def rapports_postes_implantation(request):
 436     c = {}
 437     data = []
 438     for r in ref.Region.objects.all():
 439         implantations = []
 440         for i in ref.Implantation.objects.filter(region=r):
 441             implantations.append({
 442                 'implantation': i,
 443                 'postes': rh.Poste.objects.filter(implantation=i),
 444                 'num_postes': rh.Poste.objects.filter(implantation=i).count(),
 445                 })
 446         data.append({
 447             'region': r,
 448             'implantations': implantations
 449             })
 450
 451     c['data'] = data
 452
 453
 454     return render_to_response('rh/rapports/postes_implantation.html', c, RequestContext(request))
 455
 456
 457 @login_required
 458 @drh_or_admin_required
 459 def rapports_postes_service(request):
 460     c = {}
 461     data = []
 462     for s in rh.Service.objects.all():
 463         postes = rh.Poste.objects.filter(service=s).all()
 464         num_postes = rh.Poste.objects.filter(service=s).count()
 465         data.append({'service': s, 'num_postes': num_postes, 'postes': postes})
 466
 467     c['data'] = data
 468     return render_to_response('rh/rapports/postes_service.html', c, RequestContext(request))
 469
 470
 471 def region_protected(model):
 472     def wrapper(func):
 473         def wrapped(request, id):
 474             if request.user.is_superuser:
 475                 return func(request, id)
 476             user_groups = request.user.groups.all()
 477             if grp_drh in user_groups:
 478                 return func(request, id)
 479             if grp_correspondants_rh in user_groups:
 480                 employe = get_employe_from_user(request.user)
 481                 q = Q(**{model.prefix_implantation: employe.implantation.region})
 482                 qs = model.objects.filter(q)
 483                 if int(id) in [o.id for o in qs]:
 484                     return func(request, id)
 485             return redirect_interdiction(request)
 486         return wrapped
 487     return wrapper
 488
 489
 490 @region_protected(rh.Dossier)
 491 def dossier_apercu(request, dossier_id):
 492     d = get_object_or_404(rh.Dossier, pk=dossier_id)
 493     c = {
 494         'title': u"Dossier %s" % (d, ),
 495         'is_popup' : request.GET.get('_popup', False),
 496         'dossier' : d,
 497         'pieces' :  rh.DossierPiece.objects.filter(dossier__exact=d),
 498         'contrats' : rh.Contrat.objects.filter(dossier__exact=d),
 499         'commentaires' : rh.DossierCommentaire.objects.filter(dossier__exact=d).all(),
 500         'media_url': settings.PRIVE_MEDIA_URL,
 501     }
 502     return render_to_response('admin/rh/dossier/apercu.html', c, RequestContext(request))
 503
 504 @region_protected(rh.Poste)
 505 def poste_apercu(request, poste_id):
 506     p = get_object_or_404(rh.Poste, pk=poste_id)
 507     c = {
 508         'title': u"Poste %s" % (p, ),
 509         'is_popup' : request.GET.get('_popup', False),
 510         'poste' : p,
 511         'financements' : rh.PosteFinancement.objects.filter(poste=poste_id).all(),
 512         'pieces' : rh.PostePiece.objects.filter(poste=poste_id).all(),
 513         'dossiers' : rh.Dossier.objects.filter(poste=poste_id).order_by("-date_debut").all(),
 514         'comparaisons' : rh.PosteComparaison.objects.filter(poste=poste_id).all(),
 515         'commentaires' : rh.PosteCommentaire.objects.filter(poste=poste_id).all(),
 516         'media_url': settings.PRIVE_MEDIA_URL,
 517     }
 518     return render_to_response('admin/rh/poste/apercu.html', c, RequestContext(request))
 519
 520 def employe_apercu(request, employe_id):
 521     employe = get_object_or_404(rh.Employe, pk=employe_id)
 522     user_groups = request.user.groups.all()
 523     dossiers = None
 524
 525     if request.user.is_superuser or \
 526        grp_drh in user_groups:
 527         q = Q(employe=employe)
 528     if grp_correspondants_rh in user_groups:
 529         regions = [d.poste.implantation.region for d in employe.rh_dossiers.all()]
 530         q = Q(employe=employe) & Q(implantation__region__in=regions)
 531
 532     dossiers = rh.Dossier.objects.filter(q).order_by('-date_debut')
 533
 534     c = {
 535         'is_popup' : request.GET.get('_popup', False),
 536         'employe' : employe,
 537         'dossiers' : dossiers,
 538         'media_url': settings.PRIVE_MEDIA_URL,
 539     }
 540     return render_to_response('admin/rh/employe/apercu.html', c, RequestContext(request))
 541
 542 @login_required
 543 @drh_or_admin_required
 544 def organigrammes_employe(request, id, level="all"):
 545
 546     poste = get_object_or_404(rh.Poste, pk=id)
 547     dossiers_by_poste = dict((d.poste_id, d) for d in rh.Dossier.objects.select_related('employe', 'poste').all())
 548     postes_by_id = dict((p.id, p) for p in rh.Poste.objects.all())
 549
 550     e = dossiers_by_poste[poste.id].employe
 551     name = u"Organigramme de [%s] %s %s" % (e.id, e.nom.upper(), e.prenom)
 552     graph = pgv.AGraph()
 553
 554     if rh.Poste.objects.filter(responsable=poste).count() > 0:
 555         postes_handle = [poste]
 556         while postes_handle:
 557             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()
 558
 559             for p in postes_handle:
 560                 if p.responsable_id != p.id:
 561                     graph.add_edge(dossiers_by_poste[p.responsable_id].poste_id, p.id)
 562
 563     else:
 564         graph.add_node(poste.id)
 565
 566     if level != "all":
 567         postes_niveau = [poste.id]
 568         for niveau in range(int(level)):
 569             postes_niveau = [p.id for p in rh.Poste.objects.filter(responsable__in=postes_niveau).all()]
 570
 571         while postes_niveau:
 572             postes_niveau = [p.id for p in rh.Poste.objects.filter(responsable__in=postes_niveau).all()]
 573             if postes_niveau:
 574                 for p in postes_niveau:
 575                     if graph.has_node(p):
 576                         graph.remove_node(p)
 577
 578     a = graph
 579     a.name = name.encode('ascii', 'xmlcharrefreplace')
 580
 581     poste_remontant = poste
 582     while poste_remontant.responsable_id:
 583         a.add_edge(poste_remontant.responsable_id, poste_remontant.id)
 584         poste_remontant = poste_remontant.responsable
 585
 586     rh_graph.bind_poste_to_graph(a, postes_by_id)
 587     #a.graph_attr['normalize'] = True
 588     #a.graph_attr['level'] = 2
 589     a.layout(prog='dot')
 590
 591     svg = a.draw(format='svg')
 592
 593     c = {
 594         'svg': svg
 595     }
 596
 597     if 'forcer' in request.GET:
 598         response = HttpResponse(svg, mimetype='image/svg+xml')
 599         response['Content-Disposition'] = 'attachment; filename=organigramme.svg'
 600         return response
 601
 602     return render_to_response('rh/organigrammes/employe.html', c, RequestContext(request), mimetype="image/svg+xml")
 603
 604
 605 @login_required
 606 @drh_or_admin_required
 607 def organigrammes_service(request, id):
 608
 609     service = get_object_or_404(rh.Service, pk=id)
 610     svg = rh_graph.organigramme_postes_cluster( \
 611             cluster_filter={"service": service}, \
 612             titre=u"Organigramme du service %s" % service.nom,
 613             cluster_titre=service.nom)
 614
 615     c = {
 616         'svg': svg
 617     }
 618
 619     return render_to_response('rh/organigrammes/vide.html', c, RequestContext(request), mimetype="image/svg+xml")
 620
 621 @login_required
 622 @drh_or_admin_required
 623 def organigrammes_implantation(request, id):
 624
 625     implantation = get_object_or_404(ref.Implantation, pk=id)
 626     svg = rh_graph.organigramme_postes_cluster( \
 627             cluster_filter={"implantation": implantation}, \
 628             titre=u"Organigramme de l'implantation %s" % implantation.nom,
 629             cluster_titre=implantation.nom)
 630
 631     c = {
 632         'svg': svg
 633     }
 634
 635     return render_to_response('rh/organigrammes/vide.html', c, RequestContext(request), mimetype="image/svg+xml")
 636
 637 @login_required
 638 @drh_or_admin_required
 639 def organigrammes_region(request, id):
 640
 641     region = get_object_or_404(ref.Region, pk=id)
 642     svg = rh_graph.organigramme_postes_cluster( \
 643             cluster_filter={"implantation__region": region}, \
 644             titre=u"Organigramme du bureau de %s" % region.nom,
 645             cluster_titre=region.nom)
 646
 647     c = {
 648         'svg': svg
 649     }
 650
 651     return render_to_response('rh/organigrammes/vide.html', c, RequestContext(request), mimetype="image/svg+xml")