project/rh/lib.py

   1 # -*- encoding: utf-8 -*-
   2
   3 from collections import defaultdict
   4 import datetime
   5
   6 from django.db import models
   7 from django.contrib import admin
   8 from django.conf import settings
   9 from django.db.models import Q
  10 from auf.django.metadata.admin import AUFMetadataAdminMixin, AUFMetadataInlineAdminMixin, AUF_METADATA_READONLY_FIELDS
  11 from project.rh import models as rh
  12 from forms import DossierForm, ContratForm
  13 from dae.utils import get_employe_from_user
  14
  15
  16 # Override of the InlineModelAdmin to support the link in the tabular inline
  17 class LinkedInline(admin.options.InlineModelAdmin):
  18     template = "admin/linked.html"
  19     admin_model_path = None
  20
  21     def __init__(self, *args):
  22         super(LinkedInline, self).__init__(*args)
  23         if self.admin_model_path is None:
  24             self.admin_model_path = self.model.__name__.lower()
  25
  26
  27 class ProtectRegionMixin(object):
  28
  29     def queryset(self, request):
  30         qs = super(ProtectRegionMixin, self).queryset(request)
  31
  32         if request.user.is_superuser:
  33             return qs
  34
  35         employe = get_employe_from_user(request.user)
  36
  37         q = Q(**{self.model.prefix_implantation: employe.implantation.region})
  38         qs = qs.filter(q).distinct()
  39         return qs
  40
  41     def has_change_permission(self, request, obj=None):
  42         if request.user.is_superuser:
  43             return True
  44
  45         if obj:
  46             employe = get_employe_from_user(request.user)
  47             if employe.implantation.region in obj.get_regions():
  48                 return True
  49             else:
  50                 return False
  51
  52         return True
  53
  54
  55 # Inlines
  56
  57 class ReadOnlyInlineMixin(object):
  58     def get_readonly_fields(self, request, obj=None):
  59         return [f.name for f in self.model._meta.fields if f.name not in AUF_METADATA_READONLY_FIELDS]
  60
  61
  62 class AyantDroitInline(AUFMetadataInlineAdminMixin, admin.StackedInline):
  63     model = models.Model  # à remplacer dans admin.py
  64     extra = 0
  65
  66     fieldsets = (
  67         (None, {
  68             'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', 'lien_parente', )
  69         }),
  70     )
  71
  72
  73 class AyantDroitCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
  74     readonly_fields = ('owner', )
  75     model = models.Model  # à remplacer dans admin.py
  76     extra = 1
  77
  78
  79 class ContratInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
  80     form = ContratForm
  81     model = models.Model  # à remplacer dans admin.py
  82     extra = 1
  83
  84
  85 class DossierROInline(ReadOnlyInlineMixin, LinkedInline):
  86     exclude = AUF_METADATA_READONLY_FIELDS
  87     model = models.Model  # à remplacer dans admin.py
  88     extra = 0
  89
  90
  91 class DossierCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
  92     readonly_fields = ('owner', )
  93     model = models.Model  # à remplacer dans admin.py
  94     extra = 1
  95
  96
  97 class DossierPieceInline(admin.TabularInline):
  98     model = models.Model  # à remplacer dans admin.py
  99     extra = 4
 100
 101
 102 class EmployeInline(admin.TabularInline):
 103     model = models.Model  # à remplacer dans admin.py
 104
 105 class EmployeCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
 106     readonly_fields = ('owner', )
 107     model = models.Model  # à remplacer dans admin.py
 108     extra = 1
 109
 110
 111 class EmployePieceInline(admin.TabularInline):
 112     model = models.Model  # à remplacer dans admin.py
 113     extra = 4
 114
 115
 116 class EvenementInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
 117     model = models.Model  # à remplacer dans admin.py
 118     extra = 1
 119
 120
 121 class EvenementRemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
 122     model = models.Model  # à remplacer dans admin.py
 123     extra = 1
 124
 125
 126 class PosteCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
 127     readonly_fields = ('owner', )
 128     model = models.Model  # à remplacer dans admin.py
 129     extra = 1
 130
 131
 132 class PosteFinancementInline(admin.TabularInline):
 133     model = models.Model  # à remplacer dans admin.py
 134
 135
 136 class PostePieceInline(admin.TabularInline):
 137     model = models.Model  # à remplacer dans admin.py
 138
 139
 140 class RemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
 141     model = models.Model  # à remplacer dans admin.py
 142     extra = 1
 143
 144
 145 class RemunerationROInline(ReadOnlyInlineMixin, RemunerationInline):
 146     pass
 147
 148
 149 class TypePosteInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
 150     model = models.Model  # à remplacer dans admin.py
 151
 152
 153 # Admins
 154
 155 class AyantDroitAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 156     """
 157     L'ajout d'un nouvel ayantdroit se fait dans l'admin de l'employé.
 158     """
 159     alphabet_filter = 'nom'
 160     search_fields = ('nom', 'prenom', 'employe__nom', 'employe__prenom', )
 161     list_display = ('_employe', 'lien_parente', '_ayantdroit', )
 162     inlines = (AyantDroitCommentaireInline,)
 163     readonly_fields = AUFMetadataAdminMixin.readonly_fields + ('employe',)
 164     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 165         ("Lien avec l'employé", {
 166             'fields': (('employe', 'lien_parente'), )
 167         }),
 168
 169         ('Identification', {
 170             'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
 171         }),
 172     )
 173
 174     def save_formset(self, request, form, formset, change):
 175         instances = formset.save(commit=False)
 176         for instance in instances:
 177             if instance.__class__ == rh.AyantDroitCommentaire:
 178                 instance.owner = request.user
 179             instance.save()
 180
 181     def _ayantdroit(self, obj):
 182         return unicode(obj)
 183     _ayantdroit.short_description = u'Ayant droit'
 184
 185     def _employe(self, obj):
 186         return unicode(obj.employe)
 187     _employe.short_description = u'Employé'
 188
 189     def has_add_permission(self, request):
 190         return False
 191
 192 class AyantDroitCommentaireAdmin(admin.ModelAdmin):
 193     pass
 194
 195
 196 class ClassementAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 197     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 198         (None, {
 199             'fields': ('type', 'echelon', 'degre', 'coefficient',  )
 200         }),
 201     )
 202
 203
 204 class CommentaireAdmin(admin.ModelAdmin):
 205     pass
 206
 207
 208 #class ContratAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 209 #    form = ContratForm
 210 #    alphabet_filter = 'dossier__employe__nom'
 211 #    search_fields = ('dossier__employe__nom', 'dossier__employe__prenom', 'dossier__poste__nom', 'dossier__poste__nom_feminin', )
 212 #    list_display = ('id', '_employe', '_poste', 'date_debut', 'date_fin', '_implantation', )
 213 #    fieldsets = AUFMetadataAdminMixin.fieldsets + (
 214 #        (None, {
 215 #            'fields': ('dossier', 'type_contrat', 'date_debut', 'date_fin', )
 216 #        }),
 217 #    )
 218 #
 219 #    def lookup_allowed(self, key, value):
 220 #        if key in ('dossier__employe__nom__istartswith',  ):
 221 #            return True
 222 #
 223 #    def _employe(self, obj):
 224 #        return unicode(obj.dossier.employe)
 225 #    _employe.short_description = "Employé"
 226 #
 227 #    def _poste(self, obj):
 228 #        return obj.dossier.poste.nom
 229 #    _poste.short_description = "Poste"
 230 #
 231 #    def _implantation(self, obj):
 232 #        return obj.dossier.poste.implantation
 233 #    _poste.short_description = "Implantation"
 234
 235 class DeviseAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 236     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 237         (None, {
 238             'fields': ('code', 'nom', ),
 239         }),
 240     )
 241
 242
 243 class DossierAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin,):
 244     form = DossierForm
 245     alphabet_filter = 'employe__nom'
 246     search_fields = ('employe__nom', 'employe__prenom', 'poste__nom', 'poste__nom_feminin')
 247     list_display = ('_employe', '_poste', 'date_debut', 'date_fin', 'date_modification', '_actif')
 248     inlines = (DossierPieceInline, ContratInline,
 249                RemunerationInline,
 250                #EvenementInline,
 251                DossierCommentaireInline,
 252               )
 253     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 254         (None, {
 255             'fields': ('employe', 'poste', 'statut', 'organisme_bstg',)
 256         }),
 257         ('Recrutement', {
 258             'fields': ('statut_residence', 'remplacement', 'remplacement_de', )
 259         }),
 260         ('Rémunération', {
 261             'fields': ('classement', ('regime_travail', 'regime_travail_nb_heure_semaine'),)
 262         }),
 263         ('Occupation du Poste par cet Employe', {
 264             'fields': (('date_debut', 'date_fin'), )
 265         }),
 266     )
 267
 268     add_form_template = 'admin/change_form.html'
 269
 270     class Media:
 271         js = ('js/dossier.js',)
 272
 273     def lookup_allowed(self, key, value):
 274         if key in ('employe__nom__istartswith', 'actif__exact', ):
 275             return True
 276
 277     def _actif(self, dossier):
 278         if dossier.employe.actif:
 279           html = """<img alt="True" src="%simg/admin/icon-yes.gif">"""
 280         else:
 281           html = """<img alt="False" src="%simg/admin/icon-no.gif">"""
 282         return html % settings.ADMIN_MEDIA_PREFIX
 283     _actif.allow_tags = u'Employé actif'
 284     _actif.short_description = u'Employé actif'
 285     _actif.admin_order_field = 'employe__actif'
 286
 287     def _poste(self, dossier):
 288         return unicode(dossier.poste.nom)
 289     _poste.short_description = u'Poste'
 290     _poste.admin_order_field = 'poste__nom'
 291
 292     def _employe(self, dossier):
 293         return unicode(dossier.employe)
 294     _employe.short_description = u'Employé'
 295     _employe.admin_order_field = 'employe__nom'
 296
 297     def save_formset(self, request, form, formset, change):
 298         instances = formset.save(commit=False)
 299         for instance in instances:
 300             if instance.__class__ == rh.DossierCommentaire:
 301                 instance.owner = request.user
 302             instance.save()
 303
 304     def render_change_form(self, request, context, *args, **kwargs):
 305         obj = kwargs.get('obj', None)
 306
 307         if not obj:
 308             return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
 309
 310
 311         remun, remun_sum, remun_sum_euro = calc_remun(obj)
 312
 313         extra = {
 314             'remun': remun,
 315             'remun_sum': remun_sum,
 316             'remun_sum_euro': remun_sum_euro,
 317             'employe': obj.employe,
 318             'poste_nom': obj.poste.nom,
 319             'poste_service': obj.poste.service,
 320             'poste_implantation': obj.poste.implantation,
 321         }
 322
 323         context.update(extra)
 324
 325         return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
 326
 327
 328 class DossierPieceAdmin(admin.ModelAdmin):
 329     pass
 330
 331
 332 class DossierCommentaireAdmin(admin.ModelAdmin):
 333     pass
 334
 335
 336 class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 337     alphabet_filter = 'nom'
 338     search_fields = ('id', 'nom', 'prenom', 'nom_affichage', 'actif', )
 339     list_filter = ('actif', )
 340     ordering = ('nom', )
 341     actions = ('desactiver', )
 342     list_display = ('id', 'nom', 'prenom', 'actif', )
 343     list_display_links = ('id', 'nom',)
 344     inlines = (AyantDroitInline,
 345                DossierROInline,
 346                EmployePieceInline,
 347                EmployeCommentaireInline)
 348     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 349         ('Identification', {
 350             'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
 351         }),
 352         ('Informations personnelles', {
 353             'fields': ('situation_famille', 'date_entree', )
 354         }),
 355         ('Coordonnées', {
 356             'fields': (('tel_domicile', 'tel_cellulaire'), ('adresse', 'ville'), ('code_postal', 'province'), 'pays', )
 357         }),
 358         )
 359
 360     add_form_template = 'admin/change_form.html'
 361
 362     def save_formset(self, request, form, formset, change):
 363         instances = formset.save(commit=False)
 364         for instance in instances:
 365             if instance.__class__ == rh.EmployeCommentaire:
 366                 instance.owner = request.user
 367             instance.save()
 368
 369     def render_change_form(self, request, context, *args, **kwargs):
 370         obj = kwargs.get('obj', None)
 371
 372         if not obj:
 373             return super(EmployeAdmin, self).render_change_form(request, context, *args, **kwargs)
 374
 375         remun = {}
 376         remun_sum = 0
 377         remun_sum_euro = 0
 378         dossiers = obj.dossiers.all()
 379
 380         for dossier in dossiers:
 381             this_remun, this_remun_sum, this_remun_sum_euro = calc_remun(dossier)
 382
 383             for item in this_remun:
 384                 if item not in remun:
 385                     remun[item] = this_remun[item]
 386                 else:
 387                     remun[item][0] += this_remun[item][0]
 388                     remun[item][1] += this_remun[item][1]
 389
 390             remun_sum += this_remun_sum
 391             remun_sum_euro += this_remun_sum_euro
 392
 393         extra = {
 394             'remun': remun,
 395             'remun_sum': remun_sum,
 396             'remun_sum_euro': remun_sum_euro,
 397         }
 398
 399         context.update(extra)
 400
 401         return super(EmployeAdmin, self).render_change_form(request, context, *args, **kwargs)
 402
 403
 404 class EmployeCommentaireAdmin(admin.ModelAdmin):
 405     pass
 406
 407
 408 class EmployePieceAdmin(admin.ModelAdmin):
 409     pass
 410
 411
 412 class EvenementAdmin(admin.ModelAdmin):
 413     inlines = (EvenementRemunerationInline,)
 414
 415
 416 class EvenementRemunerationAdmin(admin.ModelAdmin):
 417     pass
 418
 419
 420 class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 421     inlines = (TypePosteInline,)
 422     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 423         (None, {
 424             'fields': ('nom', )
 425         }),
 426         )
 427
 428
 429 class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 430     search_fields = ('nom', )
 431     list_display = ('nom', 'type', 'pays', )
 432     inlines = (DossierROInline,)
 433     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 434         (None, {
 435             'fields': ('nom', 'type', 'pays', )
 436         }),
 437         )
 438
 439
 440 class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 441     alphabet_filter = 'nom'
 442     search_fields = ('nom', 'implantation__code', 'implantation__nom', 'implantation__region__code', 'implantation__region__nom', )
 443     list_display = ('nom', 'implantation', 'service', 'type_poste', 'date_debut', 'date_fin', )
 444     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 445         (None, {
 446             'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
 447                        'service', 'responsable')
 448         }),
 449         ('Contrat', {
 450             'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
 451         }),
 452         ('Recrutement', {
 453             'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
 454         }),
 455         ('Rémunération', {
 456             'fields': (('classement_min', 'classement_max'),
 457                        ('valeur_point_min', 'valeur_point_max'),
 458                        ('devise_min', 'devise_max'),
 459                        ('salaire_min', 'salaire_max'),
 460                        ('indemn_min', 'indemn_max'),
 461                        ('autre_min', 'autre_max'))
 462         }),
 463         ('Comparatifs de rémunération', {
 464             'fields': ('devise_comparaison',
 465                        ('comp_locale_min', 'comp_locale_max'),
 466                        ('comp_universite_min', 'comp_universite_max'),
 467                        ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
 468                        ('comp_ong_min', 'comp_ong_max'),
 469                        ('comp_autre_min', 'comp_autre_max'))
 470         }),
 471         ('Justification', {
 472             'fields': ('justification',)
 473         }),
 474         ('Autres Metadata', {
 475             'fields': ('date_validation', ('date_debut', 'date_fin'))
 476         }),
 477     )
 478
 479     inlines = (PosteFinancementInline,
 480                PostePieceInline,
 481                DossierROInline,
 482                PosteCommentaireInline, )
 483
 484     def save_formset(self, request, form, formset, change):
 485         instances = formset.save(commit=False)
 486         for instance in instances:
 487             if instance.__class__ == rh.PosteCommentaire:
 488                 instance.owner = request.user
 489             instance.save()
 490         formset.save_m2m()
 491
 492
 493 class PosteCommentaireAdmin(admin.ModelAdmin):
 494     pass
 495
 496
 497 class PosteFinancementAdmin(admin.ModelAdmin):
 498     pass
 499
 500
 501 class PostePieceAdmin(admin.ModelAdmin):
 502     pass
 503
 504
 505 class RemunerationAdmin(admin.ModelAdmin):
 506     pass
 507
 508
 509 class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 510     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 511         (None, {
 512             'fields': ('employe', 'implantation', ),
 513         }),
 514         )
 515
 516
 517 class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 518     list_display = ('nom', 'actif', )
 519     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 520         (None, {
 521             'fields': ('nom', ),
 522         }),
 523         )
 524
 525 class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 526     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 527         (None, {
 528             'fields': ('code', 'nom', ),
 529         }),
 530         )
 531
 532 class TauxChangeAdmin(admin.ModelAdmin):
 533     list_display = ('taux', 'devise', 'annee', )
 534     list_filter = ('devise', )
 535     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 536         (None, {
 537             'fields': ('taux', 'devise', 'annee', ),
 538         }),
 539         )
 540
 541 class TypeContratAdmin(admin.ModelAdmin):
 542     inlines = (ContratInline,)
 543     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 544         (None, {
 545             'fields': ('nom', 'nom_long', ),
 546         }),
 547         )
 548
 549
 550 class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 551     search_fields = ('nom', 'nom_feminin', )
 552     list_display = ('nom', 'famille_emploi', )
 553     list_filter = ('famille_emploi', )
 554     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 555         (None, {
 556             'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi',  )
 557         }),
 558         )
 559
 560
 561 class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 562     list_display = ('nom', 'type_paiement', 'nature_remuneration', )
 563     #inlines = (RemunerationROInline,) utilité?
 564     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 565         (None, {
 566             'fields': ('nom', 'type_paiement', 'nature_remuneration', )
 567         }),
 568         )
 569
 570
 571 class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 572     #inlines = (RemunerationROInline,) utilité?
 573     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 574         (None, {
 575             'fields': ('nom', )
 576         }),
 577         )
 578
 579
 580 class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 581     list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
 582     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 583         (None, {
 584             'fields': ('valeur', 'devise', 'implantation', 'annee', )
 585         }),
 586         )
 587
 588     def _devise_code(self, obj):
 589         return obj.devise.code
 590     _devise_code.short_description = "Code de la devise"
 591
 592     def _devise_nom(self, obj):
 593         return obj.devise.nom
 594     _devise_nom.short_description = "Nom de la devise"
 595
 596
 597 def calc_remun(dossier):
 598         thisyear = datetime.date.today().year
 599         thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
 600
 601         remunnow = dossier.rh_remuneration_remunerations.filter(thisyearfilter)
 602
 603         remun_sum = 0
 604         remun_sum_euro = 0
 605         sums = defaultdict(int)
 606         sums_euro = defaultdict(int)
 607         for r in remunnow:
 608             nature = r.type.nature_remuneration
 609             sums[nature] += r.montant
 610             sums_euro[nature] += r.montant_euro()
 611             remun_sum += r.montant
 612             remun_sum_euro += r.montant_euro()
 613
 614         remun = {}
 615         sums = dict(sums)
 616         for n, s in sums.iteritems():
 617             remun[n] = [sums[n], sums_euro[n]]
 618
 619         return remun, remun_sum, remun_sum_euro