project/rh/views.py

   1 # -*- encoding: utf-8 -*-
   2 from datetime import date
   3
   4 from django.db.models import Q
   5 from django.contrib.auth.decorators import login_required
   6 from django.utils.encoding import smart_str
   7 from django.shortcuts import redirect, render_to_response, get_object_or_404
   8 from django.template import RequestContext
   9 from django.http import Http404
  10 from sendfile import sendfile
  11
  12 from datamaster_modeles import models as ref
  13 from project.lib import get_employe_from_id
  14
  15 from rh import models as rh
  16 from rh.lib import calc_remun
  17 from rh.decorators import drh_or_admin_required
  18 from rh.templatetags.rapports import SortHeaders
  19 from project.lib import multikeysort
  20
  21 # pas de reference a DAE devrait etre refactorisé
  22 from dae.utils import get_employe_from_user
  23 from dae.decorators import redirect_interdiction
  24 from dae.workflow import grp_drh, grp_correspondants_rh
  25
  26 @login_required
  27 def piece(request, filename):
  28     """Téléchargement d'une pièce jointe à un poste."""
  29     model, id, f = filename.split('/')
  30     if model == 'employe':
  31         # TODO definir peut-être un controle d'accès
  32         piece = get_object_or_404(rh.EmployePiece, fichier=filename)
  33         return sendfile(request, piece.fichier.path)
  34     if model == 'poste':
  35         piece = get_object_or_404(rh.PostePiece, fichier=filename)
  36         if rh.Poste.objects.ma_region_ou_service(request.user).filter(id=piece.poste_id).exists():
  37             return sendfile(request, piece.fichier.path)
  38         else:
  39             return redirect_interdiction(request)
  40
  41 # homes
  42 @login_required
  43 def profil(request):
  44     """Profil personnel de l'employé - éditable"""
  45     rc = RequestContext(request)
  46     c = {}
  47
  48     employe = rc['this_employe']
  49
  50     c['user'] = request.user
  51     c['employe'] = employe
  52     return render_to_response('rh/profil.html', c, rc)
  53
  54 # employes
  55 @login_required
  56 def employes_liste(request):
  57     """Liste des employés."""
  58     today = date.today()
  59     employes = rh.Employe.objects   \
  60                     .filter(actif=True, supprime=False)   \
  61                     .filter(dossiers__actif=True, dossiers__supprime=False) \
  62                     .exclude(dossiers__date_debut__gt=today) \
  63                     .exclude(dossiers__date_fin__lt=today) \
  64                     .order_by('nom')
  65     c = {
  66         'user':request.user,
  67         'employes':employes,
  68         }
  69     return render_to_response('rh/employes_liste.html', c, RequestContext(request))
  70
  71 @login_required
  72 def employe(request, id):
  73     """Information publique sur un employé."""
  74     try:
  75         employe = rh.Employe.objects.get(pk=id)
  76     except:
  77         employe = rh.Employe.objects.none()
  78     c = {
  79         'user':request.user,
  80         'employe':employe,
  81         }
  82     return render_to_response('rh/employe.html', c, RequestContext(request))
  83
  84
  85 # Rapports
  86
  87 @login_required
  88 @drh_or_admin_required
  89 def rapports_poste(request):
  90
  91     lookup_params = dict(request.GET.items())
  92
  93     comble = 'all'
  94
  95     for key, value in lookup_params.items():
  96         if key == 'o' or key == 'ot':
  97             del lookup_params[key]
  98             continue
  99         if not isinstance(key, str):
 100             # 'key' will be used as a keyword argument later, so Python
 101             # requires it to be a string.
 102             del lookup_params[key]
 103             lookup_params[smart_str(key)] = value
 104
 105         if key == 'comble':
 106             comble = value
 107             del lookup_params[key]
 108
 109     postes = rh.Poste.actifs.select_related('implantation').all()
 110     postes = postes.filter(**lookup_params)
 111
 112     poste_ids = set([p.pk for p in postes])
 113
 114     dossiers = rh.Dossier.objects.select_related('poste', 'employe').filter(poste__in=poste_ids)
 115
 116     employes = dict((d.poste.id, d.employe) for d in dossiers)
 117
 118     out = []
 119
 120     for p in postes:
 121         employe = employes.get(p.id)
 122
 123         if comble == 'c' and not employe:
 124             continue
 125
 126         if comble == 'n' and employe:
 127             continue
 128
 129         line = {}
 130         out.append(line)
 131
 132         line['id'] = p.id
 133         line['nom'] = p.nom
 134         line['implantation'] = p.implantation.nom
 135         if employe:
 136             line['employe_id'] = employe.id
 137             line['employe_nom'] = employe.nom
 138             line['employe_prenom'] = employe.prenom
 139         else:
 140             line['employe_id'] = None
 141             line['employe_nom'] = None
 142             line['employe_prenom'] = None
 143
 144     if 'o' in request.GET:
 145         try:
 146             out = multikeysort(out, [request.GET['o']])
 147         except KeyError:
 148             raise Http404
 149
 150     c = {
 151         'title': 'Rapport des postes',
 152         'postes': out,
 153         'count': len(out),
 154         'headers': list(SortHeaders(request, (
 155                 (u"# de l'employé", "id"),
 156                 (u"Nom", "nom"),
 157                 (u"Implantation", "implantation"),
 158                 (u"# de l'employé", "employe_id"),
 159                 (u"Nom", "employe_nom"),
 160                 (u"Prénom", "employe_prenom"),
 161             )).headers())
 162     }
 163
 164     return render_to_response('rh/rapports/postes.html', c, RequestContext(request))
 165
 166 @login_required
 167 @drh_or_admin_required
 168 def rapports_contrat(request):
 169
 170     lookup_params = dict(request.GET.items())
 171
 172     for key, value in lookup_params.items():
 173         if not isinstance(key, str):
 174             # 'key' will be used as a keyword argument later, so Python
 175             # requires it to be a string.
 176             del lookup_params[key]
 177             lookup_params[smart_str(key)] = value
 178
 179     contrats = rh.Contrat.objects.select_related('dossier', 'dossier__poste', 'dossier__poste__implantation', 'type_contrat', 'dossier__employe').all()
 180     contrats = contrats.filter(**lookup_params)
 181
 182     employes = set([c.dossier.employe_id for c in contrats])
 183
 184     c = {
 185         'title': 'Rapport des contrats',
 186         'contrats': contrats,
 187         'count': len(contrats),
 188         'count_employe' : len(employes),
 189     }
 190
 191     return render_to_response('rh/rapports/contrats.html', c, RequestContext(request))
 192
 193
 194 @login_required
 195 @drh_or_admin_required
 196 def rapports_remuneration(request):
 197
 198     lookup_params = dict(request.GET.items())
 199
 200     for key, value in lookup_params.items():
 201         if not isinstance(key, str):
 202             # 'key' will be used as a keyword argument later, so Python
 203             # requires it to be a string.
 204             del lookup_params[key]
 205             lookup_params[smart_str(key)] = value
 206
 207     employes = rh.Employe.objects.all()
 208     employes = employes.filter(**lookup_params)
 209
 210     output = []
 211
 212     for employe in employes:
 213         line = {}
 214         output.append(line)
 215
 216         dossiers = employe.rh_dossiers.all()
 217
 218         remun = {}
 219         remun_sum_euro = 0
 220
 221         for dossier in dossiers:
 222             this_remun, this_remun_sum, this_remun_sum_euro = calc_remun(dossier)
 223
 224             for item in this_remun:
 225                 if item not in remun:
 226                     remun[item] = this_remun[item]
 227                 else:
 228                     remun[item][0] += this_remun[item][0]
 229                     remun[item][1] += this_remun[item][1]
 230
 231             remun_sum_euro += this_remun_sum_euro
 232
 233         line['remun_sum_euro'] = remun_sum_euro
 234
 235         for r in remun:
 236             if r == u'Indemnité':
 237                 line['Indemnite'] = remun[r][1]
 238             else:
 239                 line[r] = remun[r][1]
 240
 241         line['id'] = employe.id
 242         line['nom'] = employe.nom
 243         line['prenom'] = employe.prenom
 244
 245
 246     c = {
 247         'title': 'Rapport de remuneration',
 248         'employes': output,
 249     }
 250
 251     return render_to_response('rh/rapports/remuneration.html', c, RequestContext(request))
 252
 253 def region_protected(model):
 254     def wrapper(func):
 255         def wrapped(request, id):
 256             if request.user.is_superuser:
 257                 return func(request, id)
 258             user_groups = request.user.groups.all()
 259             if grp_drh in user_groups:
 260                 return func(request, id)
 261             if grp_correspondants_rh in user_groups:
 262                 employe = get_employe_from_user(request.user)
 263                 q = Q(**{model.prefix_implantation: employe.implantation.region})
 264                 qs = model.objects.filter(q)
 265                 if int(id) in [o.id for o in qs]:
 266                     return func(request, id)
 267             return redirect_interdiction(request)
 268         return wrapped
 269     return wrapper
 270
 271
 272 @region_protected(rh.Dossier)
 273 def dossier_apercu(request, dossier_id):
 274     c = {
 275         'is_popup' : request.GET.get('_popup', False),
 276         'dossier' : get_object_or_404(rh.Dossier, pk=dossier_id)
 277
 278     }
 279     return render_to_response('admin/rh/dossier/apercu.html', c, RequestContext(request))
 280
 281 @region_protected(rh.Poste)
 282 def poste_apercu(request, poste_id):
 283     c = {
 284         'is_popup' : request.GET.get('_popup', False),
 285         'poste' : get_object_or_404(rh.Poste, pk=poste_id)
 286
 287     }
 288     return render_to_response('admin/rh/poste/apercu.html', c, RequestContext(request))
 289
 290 def employe_apercu(request, employe_id):
 291     from dae.workflow import grp_drh, grp_correspondants_rh
 292     employe = get_object_or_404(rh.Employe, pk=employe_id)
 293     user_groups = request.user.groups.all()
 294
 295     dernier_dossier = None
 296     dossiers = None
 297
 298     if request.user.is_superuser or \
 299        grp_drh in user_groups:
 300         q = Q(employe=employe)
 301     if grp_correspondants_rh in user_groups:
 302         regions = [d.poste.implantation.region for d in employe.rh_dossiers.all()]
 303         q = Q(employe=employe) & Q(implantation__region__in=regions)
 304
 305     dossiers = rh.Dossier.objects.filter(employe=employe).order_by('-date_debut')
 306
 307     c = {
 308         'is_popup' : request.GET.get('_popup', False),
 309         'employe' : employe,
 310         'dossiers' : dossiers,
 311     }
 312     return render_to_response('admin/rh/employe/apercu.html', c, RequestContext(request))
 313
 314