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': ('statut', 'organisme_bstg',)
 256         }),
 257         ('Recrutement', {
 258             'fields': (('remplacement', 'statut_residence'), )
 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     def lookup_allowed(self, key, value):
 269         if key in ('employe__nom__istartswith', 'actif__exact', ):
 270             return True
 271
 272     def _actif(self, dossier):
 273         if dossier.employe.actif:
 274           html = """<img alt="True" src="%simg/admin/icon-yes.gif">"""
 275         else:
 276           html = """<img alt="False" src="%simg/admin/icon-no.gif">"""
 277         return html % settings.ADMIN_MEDIA_PREFIX
 278     _actif.allow_tags = u'Employé actif'
 279     _actif.short_description = u'Employé actif'
 280     _actif.admin_order_field = 'employe__actif'
 281
 282     def _poste(self, dossier):
 283         return unicode(dossier.poste.nom)
 284     _poste.short_description = u'Poste'
 285     _poste.admin_order_field = 'poste__nom'
 286
 287     def _employe(self, dossier):
 288         return unicode(dossier.employe)
 289     _employe.short_description = u'Employé'
 290     _employe.admin_order_field = 'employe__nom'
 291
 292     def save_formset(self, request, form, formset, change):
 293         instances = formset.save(commit=False)
 294         for instance in instances:
 295             if instance.__class__ == rh.DossierCommentaire:
 296                 instance.owner = request.user
 297             instance.save()
 298
 299     def render_change_form(self, request, context, *args, **kwargs):
 300         obj = kwargs['obj']
 301
 302         thisyear = datetime.date.today().year
 303         thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
 304
 305         remunnow = obj.rh_remuneration_remunerations.filter(thisyearfilter)
 306
 307         remun_sum = 0
 308         remun_sum_euro = 0
 309         sums = defaultdict(int)
 310         sums_euro = defaultdict(int)
 311         for r in remunnow:
 312             nature = r.type.nature_remuneration
 313             sums[nature] += r.montant
 314             sums_euro[nature] += r.montant_euro()
 315             remun_sum += r.montant
 316             remun_sum_euro += r.montant_euro()
 317
 318         remun = {}
 319         sums = dict(sums)
 320         for n, s in sums.iteritems():
 321             remun[n] = [sums[n], sums_euro[n]]
 322
 323         extra = {
 324             'remun': remun,
 325             'remun_sum': remun_sum,
 326             'remun_sum_euro': remun_sum_euro,
 327             'employe': obj.employe,
 328             'poste_nom': obj.poste.nom,
 329             'poste_service': obj.poste.service,
 330             'poste_implantation': obj.poste.implantation,
 331         }
 332
 333         context.update(extra)
 334
 335         return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
 336
 337
 338 class DossierPieceAdmin(admin.ModelAdmin):
 339     pass
 340
 341
 342 class DossierCommentaireAdmin(admin.ModelAdmin):
 343     pass
 344
 345
 346 class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 347     alphabet_filter = 'nom'
 348     search_fields = ('id', 'nom', 'prenom', 'nom_affichage', 'actif', )
 349     list_filter = ('actif', )
 350     ordering = ('nom', )
 351     actions = ('desactiver', )
 352     list_display = ('id', 'nom', 'prenom', 'actif', )
 353     list_display_links = ('id', 'nom',)
 354     inlines = (AyantDroitInline,
 355                DossierROInline,
 356                EmployePieceInline,
 357                EmployeCommentaireInline)
 358     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 359         ('Identification', {
 360             'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
 361         }),
 362         ('Informations personnelles', {
 363             'fields': ('situation_famille', 'date_entree', )
 364         }),
 365         ('Coordonnées', {
 366             'fields': (('tel_domicile', 'tel_cellulaire'), ('adresse', 'ville'), ('code_postal', 'province'), 'pays', )
 367         }),
 368         )
 369
 370     def save_formset(self, request, form, formset, change):
 371         instances = formset.save(commit=False)
 372         for instance in instances:
 373             if instance.__class__ == rh.EmployeCommentaire:
 374                 instance.owner = request.user
 375             instance.save()
 376
 377 class EmployeCommentaireAdmin(admin.ModelAdmin):
 378     pass
 379
 380
 381 class EmployePieceAdmin(admin.ModelAdmin):
 382     pass
 383
 384
 385 class EvenementAdmin(admin.ModelAdmin):
 386     inlines = (EvenementRemunerationInline,)
 387
 388
 389 class EvenementRemunerationAdmin(admin.ModelAdmin):
 390     pass
 391
 392
 393 class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 394     inlines = (TypePosteInline,)
 395     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 396         (None, {
 397             'fields': ('nom', )
 398         }),
 399         )
 400
 401
 402 class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 403     search_fields = ('nom', )
 404     list_display = ('nom', 'type', 'pays', )
 405     inlines = (DossierROInline,)
 406     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 407         (None, {
 408             'fields': ('nom', 'type', 'pays', )
 409         }),
 410         )
 411
 412
 413 class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
 414     alphabet_filter = 'nom'
 415     search_fields = ('nom', 'implantation__code', 'implantation__nom', 'implantation__region__code', 'implantation__region__nom', )
 416     list_display = ('nom', 'implantation', 'service', 'type_poste', 'date_debut', 'date_fin', )
 417     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 418         (None, {
 419             'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
 420                        'service', 'responsable')
 421         }),
 422         ('Contrat', {
 423             'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
 424         }),
 425         ('Recrutement', {
 426             'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
 427         }),
 428         ('Rémunération', {
 429             'fields': (('classement_min', 'classement_max'),
 430                        ('valeur_point_min', 'valeur_point_max'),
 431                        ('devise_min', 'devise_max'),
 432                        ('salaire_min', 'salaire_max'),
 433                        ('indemn_min', 'indemn_max'),
 434                        ('autre_min', 'autre_max'))
 435         }),
 436         ('Comparatifs de rémunération', {
 437             'fields': ('devise_comparaison',
 438                        ('comp_locale_min', 'comp_locale_max'),
 439                        ('comp_universite_min', 'comp_universite_max'),
 440                        ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
 441                        ('comp_ong_min', 'comp_ong_max'),
 442                        ('comp_autre_min', 'comp_autre_max'))
 443         }),
 444         ('Justification', {
 445             'fields': ('justification',)
 446         }),
 447         ('Autres Metadata', {
 448             'fields': ('date_validation', ('date_debut', 'date_fin'))
 449         }),
 450     )
 451
 452     inlines = (PosteFinancementInline,
 453                PostePieceInline,
 454                DossierROInline,
 455                PosteCommentaireInline, )
 456
 457     def save_formset(self, request, form, formset, change):
 458         instances = formset.save(commit=False)
 459         for instance in instances:
 460             if instance.__class__ == rh.PosteCommentaire:
 461                 instance.owner = request.user
 462             instance.save()
 463         formset.save_m2m()
 464
 465
 466 class PosteCommentaireAdmin(admin.ModelAdmin):
 467     pass
 468
 469
 470 class PosteFinancementAdmin(admin.ModelAdmin):
 471     pass
 472
 473
 474 class PostePieceAdmin(admin.ModelAdmin):
 475     pass
 476
 477
 478 class RemunerationAdmin(admin.ModelAdmin):
 479     pass
 480
 481
 482 class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 483     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 484         (None, {
 485             'fields': ('employe', 'implantation', ),
 486         }),
 487         )
 488
 489
 490 class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 491     list_display = ('nom', 'actif', )
 492     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 493         (None, {
 494             'fields': ('nom', ),
 495         }),
 496         )
 497
 498 class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 499     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 500         (None, {
 501             'fields': ('code', 'nom', ),
 502         }),
 503         )
 504
 505 class TauxChangeAdmin(admin.ModelAdmin):
 506     list_display = ('taux', 'devise', 'annee', )
 507     list_filter = ('devise', )
 508     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 509         (None, {
 510             'fields': ('taux', 'devise', 'annee', ),
 511         }),
 512         )
 513
 514 class TypeContratAdmin(admin.ModelAdmin):
 515     inlines = (ContratInline,)
 516     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 517         (None, {
 518             'fields': ('nom', 'nom_long', ),
 519         }),
 520         )
 521
 522
 523 class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 524     search_fields = ('nom', 'nom_feminin', )
 525     list_display = ('nom', 'famille_emploi', )
 526     list_filter = ('famille_emploi', )
 527     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 528         (None, {
 529             'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi',  )
 530         }),
 531         )
 532
 533
 534 class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 535     list_display = ('nom', 'type_paiement', 'nature_remuneration', )
 536     #inlines = (RemunerationROInline,) utilité?
 537     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 538         (None, {
 539             'fields': ('nom', 'type_paiement', 'nature_remuneration', )
 540         }),
 541         )
 542
 543
 544 class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 545     #inlines = (RemunerationROInline,) utilité?
 546     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 547         (None, {
 548             'fields': ('nom', )
 549         }),
 550         )
 551
 552
 553 class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
 554     list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
 555     fieldsets = AUFMetadataAdminMixin.fieldsets + (
 556         (None, {
 557             'fields': ('valeur', 'devise', 'implantation', 'annee', )
 558         }),
 559         )
 560
 561     def _devise_code(self, obj):
 562         return obj.devise.code
 563     _devise_code.short_description = "Code de la devise"
 564
 565     def _devise_nom(self, obj):
 566         return obj.devise.nom
 567     _devise_nom.short_description = "Nom de la devise"