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     def save_formset(self, request, form, formset, change):
 361         instances = formset.save(commit=False)
 362         for instance in instances:
 363             if instance.__class__ == rh.EmployeCommentaire:
 364                 instance.owner = request.user
 365             instance.save()
 366
 367 class EmployeCommentaireAdmin(admin.ModelAdmin):
 368     pass
 369
 370
 371 class EmployePieceAdmin(admin.ModelAdmin):
 372     pass
 373
 374
 375 class EvenementAdmin(admin.ModelAdmin):
 376     inlines = (EvenementRemunerationInline,)
 377
 378
 379 class EvenementRemunerationAdmin(admin.ModelAdmin):
 380     pass
 381
 382
 383 class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 384     inlines = (TypePosteInline,)
 385     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 386         (None, {
 387             'fields': ('nom', )
 388         }),
 389         )
 390
 391
 392 class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 393     search_fields = ('nom', )
 394     list_display = ('nom', 'type', 'pays', )
 395     inlines = (DossierROInline,)
 396     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 397         (None, {
 398             'fields': ('nom', 'type', 'pays', )
 399         }),
 400         )
 401
 402
 403 class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 404     alphabet_filter = 'nom'
 405     search_fields = ('nom', 'implantation__code', 'implantation__nom', 'implantation__region__code', 'implantation__region__nom', )
 406     list_display = ('nom', 'implantation', 'service', 'type_poste', 'date_debut', 'date_fin', )
 407     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 408         (None, {
 409             'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
 410                        'service', 'responsable')
 411         }),
 412         ('Contrat', {
 413             'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
 414         }),
 415         ('Recrutement', {
 416             'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
 417         }),
 418         ('Rémunération', {
 419             'fields': (('classement_min', 'classement_max'),
 420                        ('valeur_point_min', 'valeur_point_max'),
 421                        ('devise_min', 'devise_max'),
 422                        ('salaire_min', 'salaire_max'),
 423                        ('indemn_min', 'indemn_max'),
 424                        ('autre_min', 'autre_max'))
 425         }),
 426         ('Comparatifs de rémunération', {
 427             'fields': ('devise_comparaison',
 428                        ('comp_locale_min', 'comp_locale_max'),
 429                        ('comp_universite_min', 'comp_universite_max'),
 430                        ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
 431                        ('comp_ong_min', 'comp_ong_max'),
 432                        ('comp_autre_min', 'comp_autre_max'))
 433         }),
 434         ('Justification', {
 435             'fields': ('justification',)
 436         }),
 437         ('Autres Metadata', {
 438             'fields': ('date_validation', ('date_debut', 'date_fin'))
 439         }),
 440     )
 441
 442     inlines = (PosteFinancementInline,
 443                PostePieceInline,
 444                DossierROInline,
 445                PosteCommentaireInline, )
 446
 447     def save_formset(self, request, form, formset, change):
 448         instances = formset.save(commit=False)
 449         for instance in instances:
 450             if instance.__class__ == rh.PosteCommentaire:
 451                 instance.owner = request.user
 452             instance.save()
 453         formset.save_m2m()
 454
 455
 456 class PosteCommentaireAdmin(admin.ModelAdmin):
 457     pass
 458
 459
 460 class PosteFinancementAdmin(admin.ModelAdmin):
 461     pass
 462
 463
 464 class PostePieceAdmin(admin.ModelAdmin):
 465     pass
 466
 467
 468 class RemunerationAdmin(admin.ModelAdmin):
 469     pass
 470
 471
 472 class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 473     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 474         (None, {
 475             'fields': ('employe', 'implantation', ),
 476         }),
 477         )
 478
 479
 480 class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 481     list_display = ('nom', 'actif', )
 482     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 483         (None, {
 484             'fields': ('nom', ),
 485         }),
 486         )
 487
 488 class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 489     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 490         (None, {
 491             'fields': ('code', 'nom', ),
 492         }),
 493         )
 494
 495 class TauxChangeAdmin(admin.ModelAdmin):
 496     list_display = ('taux', 'devise', 'annee', )
 497     list_filter = ('devise', )
 498     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 499         (None, {
 500             'fields': ('taux', 'devise', 'annee', ),
 501         }),
 502         )
 503
 504 class TypeContratAdmin(admin.ModelAdmin):
 505     inlines = (ContratInline,)
 506     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 507         (None, {
 508             'fields': ('nom', 'nom_long', ),
 509         }),
 510         )
 511
 512
 513 class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 514     search_fields = ('nom', 'nom_feminin', )
 515     list_display = ('nom', 'famille_emploi', )
 516     list_filter = ('famille_emploi', )
 517     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 518         (None, {
 519             'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi',  )
 520         }),
 521         )
 522
 523
 524 class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 525     list_display = ('nom', 'type_paiement', 'nature_remuneration', )
 526     #inlines = (RemunerationROInline,) utilité?
 527     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 528         (None, {
 529             'fields': ('nom', 'type_paiement', 'nature_remuneration', )
 530         }),
 531         )
 532
 533
 534 class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 535     #inlines = (RemunerationROInline,) utilité?
 536     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 537         (None, {
 538             'fields': ('nom', )
 539         }),
 540         )
 541
 542
 543 class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 544     list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
 545     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 546         (None, {
 547             'fields': ('valeur', 'devise', 'implantation', 'annee', )
 548         }),
 549         )
 550
 551     def _devise_code(self, obj):
 552         return obj.devise.code
 553     _devise_code.short_description = "Code de la devise"
 554
 555     def _devise_nom(self, obj):
 556         return obj.devise.nom
 557     _devise_nom.short_description = "Nom de la devise"
 558
 559
 560 def calc_remun(dossier):
 561         thisyear = datetime.date.today().year
 562         thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
 563
 564         remunnow = dossier.rh_remuneration_remunerations.filter(thisyearfilter)
 565
 566         remun_sum = 0
 567         remun_sum_euro = 0
 568         sums = defaultdict(int)
 569         sums_euro = defaultdict(int)
 570         for r in remunnow:
 571             nature = r.type.nature_remuneration
 572             sums[nature] += r.montant
 573             sums_euro[nature] += r.montant_euro()
 574             remun_sum += r.montant
 575             remun_sum_euro += r.montant_euro()
 576
 577         remun = {}
 578         sums = dict(sums)
 579         for n, s in sums.iteritems():
 580             remun[n] = [sums[n], sums_euro[n]]
 581
 582         return remun, remun_sum, remun_sum_euro