fix restore recherche temporelle

[auf_rh_dae.git] / project / rh / admin.py

# -*- encoding: utf-8 -*-

import datetime

import reversion
from ajax_select import make_ajax_form
from auf.django.references import models as ref
from django import forms
from django.core.urlresolvers import reverse
from django.contrib import admin
from django.contrib.contenttypes.models import ContentType
from django.conf import settings
from django.db.models import Q, Count
from django.template.defaultfilters import date
from django.utils.formats import date_format

from project.decorators import in_drh_or_admin
from project.groups import grp_correspondants_rh
from project.groups import get_employe_from_user
from project.rh import models as rh
from project.rh.change_list import ChangeList
from project.rh.forms import ContratForm, AyantDroitForm, EmployeAdminForm, \
          AjaxSelect, DossierForm, ResponsableInlineForm


class BaseAdmin(admin.ModelAdmin):

    class Media:
        css = {'screen': (
            'css/admin_custom.css',
            'jquery-autocomplete/jquery.autocomplete.css',
        )}
        js = (
            'https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js',
            'jquery-autocomplete/jquery.autocomplete.min.js',
        )


# Admin pour reversion

class ArchivableAdmin(admin.ModelAdmin):
    """
    Admin pour les modèles archivables
    """
    list_filter = ('archive', )

    def queryset(self, request):
        return self.model.avec_archives.all()

    def _archive(self, obj):
        if obj.archive:
            return "oui"
        else:
            return "non"
    _archive.short_description = u'Archivé'
    _archive.admin_order_field = 'archive'


class RegionProxy(ref.Region):
    """ Proxy utilisé pour les organigrammes par région """
    class Meta:
        proxy = True
        verbose_name = u"Organigramme par région"
        verbose_name_plural = u"Organigramme par région"


class ImplantationProxy(ref.Implantation):
    """ Proxy utilisé pour les organigrammes par implantation """
    class Meta:
        proxy = True
        verbose_name = u"Organigramme par implantations"
        verbose_name_plural = u"Organigramme par implantations"


class ServiceProxy(rh.Service):
    """ Proxy utilisé pour les organigrammes opar service """

    class Meta:
        proxy = True
        verbose_name = u"Organigramme par services"
        verbose_name_plural = u"Organigramme par services"


class EmployeProxy(rh.Employe):
    """ Proxy utilisé pour les organigrammes des employés """
    class Meta:
        proxy = True
        verbose_name = u"Organigramme des employés"
        verbose_name_plural = u"Organigramme des employés"


class DateRangeMixin(object):
    prefixe_recherche_temporelle = ""

    def get_changelist(self, request, **kwargs):
        if 'HTTP_REFERER' in request.META.keys():
                    referer = request.META['HTTP_REFERER']
                    referer = "/".join(referer.split('/')[3:])
                    referer = "/%s" % referer.split('?')[0]
                    change_list_view = 'admin:%s_%s_changelist' % (
                            self.model._meta.app_label,
                            self.model.__name__.lower(),)
                    if referer != reverse(change_list_view):
                        params = request.GET.copy()
                        params.update({'statut': 'Actif'})
                        request.GET = params
        return ChangeList


# Override of the InlineModelAdmin to support the link in the tabular inline
class LinkedInline(admin.options.InlineModelAdmin):
    template = "admin/linked.html"
    admin_model_path = None

    def __init__(self, *args):
        super(LinkedInline, self).__init__(*args)
        if self.admin_model_path is None:
            self.admin_model_path = self.model.__name__.lower()


class ProtectRegionMixin(object):

    def queryset(self, request):
        qs = super(ProtectRegionMixin, self).queryset(request)

        user_groups = request.user.groups.all()
        if in_drh_or_admin(request.user):
            return qs

        if grp_correspondants_rh in user_groups:
            employe = get_employe_from_user(request.user)
            q = Q(**{self.model.prefix_implantation: \
                    employe.implantation.region})
            qs = qs.filter(q).distinct()
            return qs
        return qs.none()

    def has_add_permission(self, request):
        if not in_drh_or_admin(request.user):
            return False
        else:
            return True

    def has_change_permission(self, request, obj=None):
        user_groups = request.user.groups.all()

        # Lock pour autoriser uniquement les DRH à utiliser RH
        if not in_drh_or_admin(request.user):
            return False

        if len(user_groups) == 0 and not request.user.is_superuser:
            return False

        if obj is None:
            return True
        ids = [o.id for o in self.queryset(request)]
        return obj.id in ids


class DerniereModificationAdmin(admin.ModelAdmin):

    def queryset(self, request):
        qs = super(DerniereModificationAdmin, self).queryset(request)
        ct = ContentType.objects.get_for_model(self.model)
        db_table = self.model._meta.db_table
        pk = self.model._meta.pk.column
        return qs.extra(select={
            'date_modification':
            "SELECT action_time FROM django_admin_log "
            "WHERE content_type_id = %d AND object_id = %s.%s "
            "ORDER BY action_time DESC "
            "LIMIT 1" % (ct.id, db_table, pk),
            'user_modification':
            "SELECT u.username "
            "FROM auth_user u "
            "INNER JOIN django_admin_log l ON l.user_id = u.id "
            "WHERE l.content_type_id = %d AND object_id = %s.%s "
            "ORDER BY action_time DESC "
            "LIMIT 1" % (ct.id, db_table, pk),
        })

    def derniere_modification(self, obj):
        text = ''
        if obj.date_modification:
            text += obj.date_modification.strftime('%d-%m-%Y %H:%M')
        if obj.user_modification:
            text += ' par ' + obj.user_modification
        return text
    derniere_modification.short_description = u'dernière modification'
    derniere_modification.admin_order_field = 'date_modification'


# Inlines

class CommentaireInlineForm(forms.ModelForm):

    def save(self, commit=True):

        # Hack: reversion.VersionAdmin ne sauvegarde pas les champs qui ne
        # sont pas explicitement dans le formulaire. Il plante cependant
        # leur valeur dans `self.initial`. Ceci est un peu fragile. Si
        # c'est possible, il serait plus approprié que Reversion se rende
        # compte qu'il manque des champs.
        instance = super(CommentaireInlineForm, self).save(commit=False)
        if instance.owner_id is None and 'owner' in self.initial:
            instance.owner_id = self.initial['owner']
        if instance.date_creation is None and 'date_creation' in self.initial:
            instance.date_creation = self.initial['date_creation']
        if commit:
            instance.save()
            self.save_m2m()
        return instance


class ReadOnlyInlineMixin(object):

    def get_readonly_fields(self, request, obj=None):
        return [f.name for f in self.model._meta.fields]


class AyantDroitInline(admin.StackedInline):
    model = rh.AyantDroit
    form = AyantDroitForm
    extra = 0

    fieldsets = (
        (None, {
            'fields': (
                ('nom', 'prenom'),
                ('nom_affichage', 'genre'),
                'nationalite',
                'date_naissance',
                'lien_parente',
                )}),
    )


class AyantDroitCommentaireInline(admin.TabularInline):
    readonly_fields = ('owner',)
    model = rh.AyantDroitCommentaire
    extra = 1
    form = CommentaireInlineForm


class ContratInline(admin.TabularInline):
    form = ContratForm
    model = rh.Contrat
    extra = 1


class DossierROInline(ReadOnlyInlineMixin, LinkedInline):
    template = "admin/rh/dossier/linked.html"
    model = rh.Dossier
    extra = 0
    can_delete = False

    def has_add_permission(self, request=None):
        return False

    def has_change_permission(self, request, obj=None):
        return False

    def has_delete_permission(self, request, obj=None):
        return False


class DossierCommentaireInline(admin.TabularInline):
    readonly_fields = ('owner',)
    model = rh.DossierCommentaire
    extra = 1
    form = CommentaireInlineForm


class DossierPieceInline(admin.TabularInline):
    model = rh.DossierPiece
    extra = 4


class EmployeInline(admin.TabularInline):
    model = rh.Employe


class EmployeCommentaireInline(admin.TabularInline):
    readonly_fields = ('owner',)
    model = rh.EmployeCommentaire
    extra = 1
    form = CommentaireInlineForm


class EmployePieceInline(admin.TabularInline):
    model = rh.EmployePiece
    extra = 4


class PosteCommentaireInline(admin.TabularInline):
    readonly_fields = ('owner',)
    model = rh.PosteCommentaire
    extra = 1
    form = CommentaireInlineForm


class PosteFinancementInline(admin.TabularInline):
    model = rh.PosteFinancement


class PostePieceInline(admin.TabularInline):
    model = rh.PostePiece


class RemunerationInline(admin.TabularInline):
    model = rh.Remuneration
    extra = 1


class RemunerationROInline(ReadOnlyInlineMixin, RemunerationInline):
    pass


class TypePosteInline(admin.TabularInline):
    model = rh.TypePoste


class PosteComparaisonInline(admin.TabularInline):
    model = rh.PosteComparaison


class ClassementAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                      BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = ('_classement', 'derniere_modification')
    fieldsets = (
        (None, {'fields': ('type', 'echelon', 'degre', 'coefficient',)}),
    )

    def _classement(self, obj):
        return unicode(obj)
    _classement.short_description = u"Classement"


class DeviseAdmin(reversion.VersionAdmin, ArchivableAdmin,
                  DerniereModificationAdmin, BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = (
        'code', 'nom', '_archive', 'derniere_modification',
    )
    list_filter = ('archive', )
    fieldsets = (
        (None, {'fields': ('code', 'nom', 'archive', )}),
    )


class DossierAdmin(DateRangeMixin, ProtectRegionMixin, reversion.VersionAdmin,
                   AjaxSelect, DerniereModificationAdmin, BaseAdmin):
    change_list_template = "admin/rh/dossier/change_list.html"
    ignore_duplicate_revisions = True
    alphabet_filter = 'employe__nom'
    search_fields = (
        'id',
        'employe__id',
        'poste__id',
        'employe__nom',
        'employe__prenom',
        'poste__nom',
        'poste__nom_feminin',
        'poste__implantation__nom',
    )
    list_display = (
        '_id',
        '_apercu',
        '_nom',
        '_employe',
        '_poste',
        '_region',
        '_implantation',
        '_date_debut',
        '_date_fin',
        'derniere_modification',
        '_dae',
    )
    list_display_links = ('_nom',)
    list_filter = (
        'poste__implantation__region',
        'poste__implantation',
        'poste__type_poste__categorie_emploi',
        'poste__type_poste',
        'rh_contrats__type_contrat',
        'principal',
    )
    inlines = (DossierPieceInline, ContratInline,
               RemunerationInline,
               DossierCommentaireInline,
              )
    fieldsets = (
        (None, {
            'fields': (
                'employe',
                'poste',
                'principal',
                'statut',
                'organisme_bstg',)}),
        ('Recrutement', {
            'fields': (
                'statut_residence',
                'remplacement',
                'remplacement_de', )}),
        ('Rémunération', {
            'fields': (
                'classement',
                ('regime_travail', 'regime_travail_nb_heure_semaine'),)}),
        ('Occupation du Poste par cet Employe', {
            'fields': (('date_debut', 'date_fin'), )}
            ),
    )
    form = make_ajax_form(rh.Dossier, {
        'employe': 'employes',
        'poste': 'postes',
        'remplacement_de': 'dossiers',
    }, superclass=DossierForm)

    def lookup_allowed(self, key, value):
        if key in (
            'employe__nom__istartswith',
            'poste__implantation__region__id__exact',
            'poste__implantation__id__exact',
            'poste__type_poste__id__exact',
            'poste__type_poste__categorie_emploi__id__exact',
            'rh_contrats__type_contrat__id__exact',
            'principal__exact',
            'principal__isnull',
            ):
            return True

    def _id(self, obj):
        return obj.id
    _id.short_description = u"#"
    _id.admin_order_field = "id"

    def _apercu(self, d):
        apercu_link = u"""<a title="Aperçu du dossier"
                             onclick="return showAddAnotherPopup(this);"
                             href='%s'>
                             <img src="%simg/dossier-apercu.png" />
                             </a>""" % \
                (reverse('dossier_apercu', args=(d.id,)),
                 settings.STATIC_URL,
                 )
        return apercu_link
    _apercu.allow_tags = True
    _apercu.short_description = u""

    def _nom(self, obj):
        return "Dossier"
    _nom.allow_tags = True
    _nom.short_description = u"Dossier"

    def _employe(self, obj):
        employe = obj.employe
        view_link = reverse('employe_apercu', args=(employe.id,))
        edit_link = reverse('admin:rh_employe_change', args=(employe.id,))
        style = ""
        view = u"""<a href="%s"
                      title="Aperçu l'employé"
                      onclick="return showAddAnotherPopup(this);">
                      <img src="%simg/employe-apercu.png" />
                    </a>""" % (view_link, settings.STATIC_URL,)
        return u"""%s<a href='%s' style="%s;">%s</a>""" % \
        (view, edit_link, style, employe)
    _employe.allow_tags = True
    _employe.short_description = u"Employé"
    _employe.admin_order_field = "employe__nom"

    def _poste(self, dossier):
        link = u"""<a title="Aperçu du poste"
                      onclick="return showAddAnotherPopup(this);"
                      href='%s'><img src="%simg/poste-apercu.png" />
                    </a>
                    <a href="%s" title="Modifier le poste">%s [%d]</a>""" % \
                (reverse('poste_apercu', args=(dossier.poste.id,)),
                 settings.STATIC_URL,
                 reverse('admin:rh_poste_change', args=(dossier.poste.id,)),
                 dossier.poste.nom,
                 dossier.poste.id,
                 )
        return link
    _poste.allow_tags = True
    _poste.short_description = u'Poste'
    _poste.admin_order_field = 'poste__nom'

    def _region(self, obj):
        return obj.poste.implantation.region.code
    _region.short_description = u"Région"
    _region.admin_order_field = 'poste__implantation__region__code'

    def _implantation(self, obj):
        return obj.poste.implantation.nom
    _implantation.short_description = u"Implantation"
    _implantation.admin_order_field = 'poste__implantation__nom'

    def _date_debut(self, obj):
        return date(obj.date_debut)

    _date_debut.short_description = u'Début'
    _date_debut.admin_order_field = 'date_debut'

    def _date_fin(self, obj):
        return date(obj.date_fin)
    _date_fin.short_description = u'Fin'
    _date_fin.admin_order_field = 'date_fin'

    def _date_modification(self, obj):
        return date(obj.date_modification) \
                if obj.date_modification is not None else "(aucune)"
    _date_modification.short_description = u'date modification'
    _date_modification.admin_order_field = 'date_modification'

    def _dae(self, d):
        apercu_link = ""
        dossiers_dae = d.dossiers_dae.all()
        if len(dossiers_dae) > 0:
            dossier_dae = dossiers_dae[0]
            apercu_link = u"""<a title="Aperçu du dossier"
                                 onclick="return showAddAnotherPopup(this);"
                                 href='%s'>
                                 <img src="%simg/loupe.png" />
                                 </a>""" % \
                    (reverse('embauche_consulter', args=(dossier_dae.id,)),
                     settings.STATIC_URL,
                     )
        return apercu_link
    _dae.allow_tags = True
    _dae.short_description = u"DAE"

    def save_formset(self, request, form, formset, change):
        instances = formset.save(commit=False)
        for instance in instances:
            if instance.__class__ == rh.DossierCommentaire:
                instance.owner = request.user
                instance.date_creation = datetime.datetime.now()
            instance.save()


class EmployeAdminBase(DateRangeMixin, ProtectRegionMixin,
                       DerniereModificationAdmin, BaseAdmin):
    prefixe_recherche_temporelle = "rh_dossiers__"
    alphabet_filter = 'nom'
    DEFAULT_ALPHABET = u'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
    search_fields = (
        'id', 'nom', 'prenom', 'nom_affichage',
        'rh_dossiers__poste__nom',
        'rh_dossiers__poste__nom_feminin'
    )
    ordering = ('nom', )
    form = EmployeAdminForm
    list_display = (
        '_id', '_apercu', '_nom', '_dossiers_postes',
        #'_region',
        #'_implantation',
        'date_entree',
        'derniere_modification'
    )
    list_display_links = ('_nom',)
    list_filter = (
        'rh_dossiers__poste__implantation__region',
        'rh_dossiers__poste__implantation', 'nb_postes'
    )
    inlines = (
        AyantDroitInline, DossierROInline, EmployePieceInline,
        EmployeCommentaireInline
    )
    fieldsets = (
        ('Identification', {
            'fields': (
                ('nom', 'prenom'),
                ('nom_affichage', 'genre'),
                'nationalite',
                'date_naissance',
            )
        }),
        ('Informations personnelles', {
            'fields': ('situation_famille', 'date_entree', )
        }),
        ('Coordonnées personnelles', {
            'fields': (
                ('tel_domicile', 'tel_cellulaire'),
                ('adresse', 'ville'),
                ('code_postal', 'province'),
                'pays',
                'courriel_perso'
            )
        }),
    )

    def _id(self, obj):
        return obj.id
    _id.short_description = u"#"
    _id.admin_order_field = "id"

    def _apercu(self, obj):
        return u"""<a title="Aperçu de l'employé"
                      onclick="return showAddAnotherPopup(this);"
                      href='%s'>
                      <img src="%simg/employe-apercu.png" />
                    </a>""" % \
            (reverse('employe_apercu', args=(obj.id,)), settings.STATIC_URL)
    _apercu.allow_tags = True
    _apercu.short_description = u""

    def _nom(self, obj):
        edit_link = reverse('admin:rh_employe_change', args=(obj.id,))
        return u"""<a href='%s'><strong>%s</strong></a>""" % \
        (edit_link, "%s %s" % (obj.nom.upper(), obj.prenom))
    _nom.allow_tags = True
    _nom.short_description = u"Employé"
    _nom.admin_order_field = "nom"

    def _region(self, obj):
        try:
            d = rh.Dossier.objects.filter(employe=obj.id, principal=True)[0]
            region = d.poste.implantation.region.code
        except:
            region = None
        return region
    _region.short_description = u"Région"

    def _implantation(self, obj):
        try:
            d = rh.Dossier.objects.filter(employe=obj.id, principal=True)[0]
            implantation = d.poste.implantation.nom
        except:
            implantation = None
        return implantation
    _implantation.short_description = u"Implantation"

    def _dossiers_postes(self, obj):
        l = []
        for d in obj.rh_dossiers.all().order_by('-date_debut'):
            link_style = u''
            list_style = u''
            if d.date_fin is not None and d.date_fin < datetime.date.today():
                link_style = u' style="color:#666;"'
                list_style = u' style="color:grey;"'

            dossier = u"""<a title="Aperçu du dossier"
                             href="%s"
                             onclick="return showAddAnotherPopup(this);"
                             title="Aperçu du dossier">
                             <img src="%simg/dossier-apercu.png" />
                          </a>
                          <a href="%s"%s>Dossier</a>
                          &nbsp;""" % \
                (reverse('dossier_apercu', args=(d.id,)),
                 settings.STATIC_URL,
                 reverse('admin:rh_dossier_change', args=(d.id,)),
                 link_style,)

            poste = u"""<a title="Aperçu du poste"
                           href="%s"
                           onclick="return showAddAnotherPopup(this);"
                           title="Aperçu du poste">
                           <img src="%simg/poste-apercu.png" />
                        </a>
                        <a href="%s"%s>%s [%d]</a>
                        &nbsp;""" % \
                (reverse('poste_apercu', args=(d.poste.id,)),
                 settings.STATIC_URL,
                 reverse('admin:rh_poste_change', args=(d.poste.id,)),
                 link_style,
                 d.poste.nom,
                 d.poste.id)

            link = u"""<li%s>%s %s</li>""" % \
                (list_style, dossier, poste)

            l.append(link)
        return "<ul>%s</ul>" % "\n".join(l)
    _dossiers_postes.allow_tags = True
    _dossiers_postes.short_description = u"Dossiers et postes"

    def _date_modification(self, obj):
        return date(obj.date_modification) \
                if obj.date_modification is not None else "(aucune)"
    _date_modification.short_description = u'date modification'
    _date_modification.admin_order_field = 'date_modification'

    def queryset(self, request):
        qs = super(EmployeAdminBase, self).queryset(request)
        return qs.select_related(depth=1).order_by('nom')

    def save_formset(self, request, form, formset, change):
        instances = formset.save(commit=False)
        for instance in instances:
            if instance.__class__ == rh.EmployeCommentaire:
                instance.owner = request.user
                instance.date_creation = datetime.datetime.now()
            instance.save()


class EmployeAdmin(reversion.VersionAdmin, EmployeAdminBase):
    change_list_template = "admin/rh/employe/change_list.html"
    ignore_duplicate_revisions = True


class EmployeProxyAdmin(EmployeAdminBase):
    list_display = ('_id', '_apercu', '_nom', '_organigramme')
    list_per_page = 500
    actions = None

    def __init__(self, *args, **kwargs):
        super(EmployeProxyAdmin, self).__init__(*args, **kwargs)
        self.list_display_links = (None, )

    def has_add_permission(self, obj):
        return False

    def _organigramme(self, obj):
        l = []
        for d in rh.Dossier.objects.filter(
            Q(date_fin__gt=datetime.date.today()) | Q(date_fin=None),
            Q(date_debut__lt=datetime.date.today()) | Q(date_debut=None),
            employe=obj.id
        ):
            organigramme = \
                    u'Organigramme, niveau: ' \
                    u'<input type="text" id="level_%s" ' \
                    u'style="width:30px;height:15px;" /> ' \
                    u'<input type="button" value="Générer" ' \
                    u"""onclick="window.location='%s' + """ \
                    u"""document.getElementById('level_%s').value" />""" % (
                        d.poste.id,
                        reverse('rho_employe_sans_niveau', args=(d.poste.id,)),
                        d.poste.id
                    )
            link = u"""<li>%s [%s]:<br />%s</li>""" % (
                    d.poste.nom,
                    d.poste.id,
                    organigramme
            )
            l.append(link)
        return "<ul>%s</ul>" % "\n".join(l)

    _organigramme.allow_tags = True
    _organigramme.short_description = "Organigramme"


class CategorieEmploiAdmin(reversion.VersionAdmin,
                           DerniereModificationAdmin, BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = ('nom', 'derniere_modification')
    inlines = (TypePosteInline,)
    fieldsets = (
        (None, {'fields': ('nom', )}),
    )


class OrganismeBstgAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                         BaseAdmin):
    ignore_duplicate_revisions = True
    search_fields = ('nom',)
    list_display = ('nom', 'type', 'pays', 'derniere_modification')
    list_filter = ('type', )
    inlines = (DossierROInline,)
    fieldsets = (
        (None, {'fields': ('nom', 'type', 'pays',)}),
    )


class PosteAdmin(DateRangeMixin, ProtectRegionMixin, reversion.VersionAdmin,
                 AjaxSelect, DerniereModificationAdmin, BaseAdmin):
    change_list_template = "admin/rh/poste/change_list.html"
    ignore_duplicate_revisions = True
    form = make_ajax_form(rh.Poste, {
        'implantation': 'implantations',
        'type_poste': 'typepostes',
        'responsable': 'postes',
        'valeur_point_min': 'valeurpoints',
        'valeur_point_max': 'valeurpoints',
    })
    alphabet_filter = 'nom'
    search_fields = (
        'id',
        'nom',
        'implantation__nom',
        'implantation__region__code',
        'implantation__region__nom',
        'rh_dossiers__employe__id',
        'rh_dossiers__employe__nom',
        'rh_dossiers__employe__prenom',
    )
    list_display = (
        '_id', '_apercu', '_nom', '_occupe_par', 'implantation', '_service',
        '_responsable', 'date_debut', 'date_fin', 'derniere_modification',
        '_dae'
    )
    list_filter = (
        'implantation__region',
        'implantation',
        'service',
        'type_poste',
        'type_poste__categorie_emploi',
        'type_poste__famille_professionnelle',
        'vacant',
    )
    list_display_links = ('_nom',)
    fieldsets = (
        (None, {'fields': (
                ('nom', 'nom_feminin'),
                'implantation',
                'type_poste',
                'service',
                'responsable',
                )}
                ),
        ('Contrat', {
            'fields': ((
                'regime_travail',
                'regime_travail_nb_heure_semaine'),
                )}
            ),
        ('Recrutement', {
            'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)}
            ),
        ('Rémunération', {
            'fields': (('classement_min',
                        'valeur_point_min',
                        'devise_min',
                        'salaire_min',
                        'indemn_min',
                        'autre_min',),
                       ('classement_max',
                        'valeur_point_max',
                        'devise_max',
                        'salaire_max',
                        'indemn_max',
                        'autre_max',),
                        )}),
        ('Comparatifs de rémunération', {
            'fields': ('devise_comparaison',
                       ('comp_locale_min', 'comp_locale_max'),
                       ('comp_universite_min', 'comp_universite_max'),
                       ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
                       ('comp_ong_min', 'comp_ong_max'),
                       ('comp_autre_min', 'comp_autre_max'))}
            ),
        ('Justification', {
            'fields': ('justification',)}
            ),
        ('Autres Méta-données', {
            'fields': ('date_debut', 'date_fin')}
            ),
    )

    inlines = (PosteFinancementInline,
               PostePieceInline,
               DossierROInline,
               PosteComparaisonInline,
               PosteCommentaireInline, )

    def lookup_allowed(self, key, value):
        return key in (
            'date_debut__gte', 'date_debut__isnull', 'date_fin__lte',
            'date_fin__isnull', 'implantation__region__id__exact',
            'implantation__id__exact', 'type_poste__id__exact',
            'type_poste__categorie_emploi__id__exact', 'service__id__exact',
            'service__isnull', 'vacant__exact', 'vacant__isnull',
        ) or super(PosteAdmin, self).lookup_allowed(key, value)

    def _id(self, obj):
        return "%s" % obj.id
    _id.short_description = '#'
    _id.admin_order_field = 'id'

    def _apercu(self, poste):
        view_link = u"""<a onclick="return showAddAnotherPopup(this);"
                           title="Aperçu du poste"
                           href='%s'>
                        <img src="%simg/poste-apercu.png" />
                        </a>""" % \
                (reverse('poste_apercu', args=(poste.id,)),
                 settings.STATIC_URL,)
        return view_link
    _apercu.allow_tags = True
    _apercu.short_description = ''

    def _nom(self, poste):
        return """<a href="%s">%s</a>""" % \
                (reverse('admin:rh_poste_change', args=(poste.id,)),
                poste.nom)
    _nom.allow_tags = True
    _nom.short_description = u'Poste'
    _nom.admin_order_field = 'nom'

    def _occupe_par(self, obj):
        """Formatte la méthode Poste.occupe_par() pour l'admin"""
        output = u"Vacant"
        if obj.date_fin is not None and obj.date_fin < datetime.date.today():
            return u"s/o"
        employes = obj.occupe_par()
        if employes:
            l = []
            for e in employes:
                link = u"""<a href='%s'
                              title='Aperçu de l\'employé'
                              onclick='return showAddAnotherPopup(this)'>
                              <img src='%simg/employe-apercu.png' />
                            </a>
                            <a href='%s'>%s</a>""" % \
                     (reverse('employe_apercu', args=(e.id,)),
                     settings.STATIC_URL,
                     reverse('admin:rh_employe_change', args=(e.id,)),
                     e)
                l.append(link)
            output = "\n<br />".join(l)
        return output
    _occupe_par.allow_tags = True
    _occupe_par.short_description = "Occupé par"

    def _region(self, poste):
        return poste.implantation.region.code
    _region.short_description = 'Région'
    _region.admin_order_field = 'implantation__region__code'

    def _implantation(self, poste):
        return poste.implantation.nom
    _implantation.short_description = 'Implantation'
    _implantation.admin_order_field = 'implantation'

    def _service(self, obj):
        return obj.service
    _service.short_description = 'Service'
    _service.allow_tags = True

    def _responsable(self, obj):
        try:
            responsable = u"""<a href="%s"
                                 onclick="return showAddAnotherPopup(this)">
                                <img src="%simg/poste-apercu.png"
                                     title="Aperçu du poste" />
                              </a>
                              <a href="%s">%s [%d]</a>
                              <br />""" % \
                (reverse('poste_apercu', args=(obj.responsable.id,)),
                settings.STATIC_URL,
                reverse('admin:rh_poste_change', args=(obj.responsable.id,)),
                obj.responsable.nom,
                obj.responsable.id)
        except:
            responsable = ''

        try:
            dossier = obj.responsable.rh_dossiers.all() \
                    .order_by('-date_debut')[0]
            employe_id = dossier.employe.id
            employe_html = u"""<br />
                    <a href="%s"
                       onclick="return showAddAnotherPopup(this)">
                       <img src="%simg/employe-apercu.png"
                            title="Aperçu de l'employé">
                    </a>
                    <a href="%s">%s</a>""" % \
                    (reverse('employe_apercu', args=(employe_id,)),
                     settings.STATIC_URL,
                     reverse('admin:rh_employe_change', args=(employe_id,)),
                     dossier.employe)
        except:
            employe_html = ""

        return "%s %s" % (responsable, employe_html)
    _responsable.short_description = 'Responsable'
    _responsable.allow_tags = True

    def _date_debut(self, obj):
        return date_format(obj.date_debut)
    _date_debut.short_description = u'Début'
    _date_debut.admin_order_field = 'date_debut'

    def _date_fin(self, obj):
        return date_format(obj.date_fin)
    _date_fin.short_description = u'Fin'
    _date_fin.admin_order_field = 'date_fin'

    def _dae(self, poste):
        apercu_link = ""
        postes_dae = poste.postes_dae.all()
        if len(postes_dae) > 0:
            poste_dae = postes_dae[0]
            apercu_link = \
                    u'<a title="Aperçu du dossier" href="%s" ' \
                    u'onclick="return showAddAnotherPopup(this);">' \
                    u'<img src="%simg/loupe.png" /></a>' % (reverse(
                        'poste_consulter', args=("dae-%s" % poste_dae.id,)
                    ), settings.STATIC_URL)
        return apercu_link
    _dae.allow_tags = True
    _dae.short_description = u"DAE"

    def save_formset(self, request, form, formset, change):
        instances = formset.save(commit=False)
        for instance in instances:
            if instance.__class__ == rh.PosteCommentaire:
                instance.owner = request.user
                instance.date_creation = datetime.datetime.now()
            instance.save()
        formset.save_m2m()


class ResponsableInline(admin.TabularInline):
    model = rh.ResponsableImplantation
    extra = 0
    fk_name = "implantation"
    form = ResponsableInlineForm


class ResponsableImplantationAdmin(BaseAdmin):
    actions = None
    fields = ('nom', )
    inlines = (ResponsableInline, )
    list_filter = ('region', 'statut', )
    list_display = ('_region', '_nom', 'statut', '_responsable', )
    list_display_links = ('_nom',)
    list_per_page = 500
    readonly_fields = ('nom', )
    search_fields = (
            'nom',
            'responsable__employe__id',
            'responsable__employe__nom',
            'responsable__employe__prenom',
            )
    ordering = ('nom',)

    def _region(self, obj):
        return obj.region.code
    _region.short_description = u"Région"
    _region.admin_order_field = 'region__code'

    def _nom(self, obj):
        return obj.nom
    _nom.short_description = u"Implantation"
    _nom.admin_order_field = 'nom'

    def _responsable(self, obj):
        try:
            employe = obj.responsable.employe
            dossiers = employe.dossiers_encours()
            if len(dossiers) == 0:
                return u"<span style='color: red;'>%s %s </span>" % (
                    employe, u"sans dossier actif")
            else:
                return employe
        except Exception:
            if obj.statut in (1, 2):  # ouverte, ouverture imminente
                css = "style='color: red;'"
            else:
                css = ""
            return u"<span %s>Pas de responsable</span>" % css
    _responsable.allow_tags = True
    _responsable.short_description = u"Responsable"
    _responsable.admin_order_field = 'responsable__employe__nom'

    def has_add_permission(self, request=None):
        return False

    def has_change_permission(self, request, obj=None):
        return in_drh_or_admin(request.user)

    def has_delete_permission(self, request, obj=None):
        return False


class ServiceAdminBase(ArchivableAdmin, DerniereModificationAdmin, BaseAdmin):
    list_display = ('nom', '_archive', 'derniere_modification')
    list_filter = ('archive', )
    fieldsets = (
        (None, {'fields': ('nom', 'archive')}),
    )


class ServiceAdmin(reversion.VersionAdmin, ServiceAdminBase):
    ignore_duplicate_revisions = True


class ServiceProxyAdmin(ServiceAdminBase):
    list_display = ('nom', '_organigramme', '_archive', )
    actions = None

    def __init__(self, *args, **kwargs):
        super(ServiceProxyAdmin, self).__init__(*args, **kwargs)
        self.list_display_links = (None, )

    def queryset(self, request):
        return super(ServiceProxyAdmin, self).queryset(request) \
                .annotate(num_postes=Count('rh_postes')) \
                .filter(num_postes__gt=0)

    def has_add_permission(self, obj):
        return False

    def has_change_permission(self, request, obj=None):
        return in_drh_or_admin(request.user)

    def _organigramme(self, obj):
        return """<a href="%s"><strong>Organigramme</strong></a>""" % \
                (reverse('rho_service', args=(obj.id,)))
    _organigramme.allow_tags = True
    _organigramme.short_description = "Organigramme"


class StatutAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                  BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = ('code', 'nom', 'derniere_modification')
    fieldsets = (
        (None, {
            'fields': ('code', 'nom', ),
        }),
    )


class TauxChangeAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                      BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = ('taux', 'devise', 'annee', 'derniere_modification')
    list_filter = ('devise',)
    fieldsets = (
        (None, {
            'fields': ('taux', 'devise', 'annee', ),
        }),
    )


class TypeContratAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                       BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = ('nom', 'nom_long', 'derniere_modification')
    fieldsets = (
        (None, {
            'fields': ('nom', 'nom_long', ),
        }),
    )


class TypePosteAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                     BaseAdmin):
    ignore_duplicate_revisions = True
    search_fields = ('nom', 'nom_feminin', )
    list_display = ('nom', 'categorie_emploi', 'derniere_modification')
    list_filter = ('categorie_emploi', 'famille_professionnelle')
    fieldsets = (
        (None, {
            'fields': (
                'nom', 'nom_feminin', 'is_responsable', 'categorie_emploi',
                'famille_professionnelle',
            )
        }),
    )


class TypeRemunerationAdmin(reversion.VersionAdmin, ArchivableAdmin,
                            DerniereModificationAdmin, BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = (
        'nom', 'type_paiement', 'nature_remuneration', '_archive',
        'derniere_modification'
    )
    list_filter = ('archive', )
    fieldsets = (
        (None, {
            'fields': (
                'nom', 'type_paiement', 'nature_remuneration', 'archive'
            )
        }),
    )


class TypeRevalorisationAdmin(reversion.VersionAdmin,
                              DerniereModificationAdmin, BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = ('nom', 'derniere_modification')
    fieldsets = (
        (None, {'fields': ('nom',)}),
    )


class ValeurPointAdmin(reversion.VersionAdmin, DerniereModificationAdmin,
                       BaseAdmin):
    ignore_duplicate_revisions = True
    list_display = (
        '_devise_code', '_devise_nom', 'annee', 'implantation',
        'valeur', 'derniere_modification'
    )
    list_filter = ('annee', 'devise', 'implantation__region', )
    fieldsets = (
        (None, {'fields': ('valeur', 'devise', 'implantation', 'annee')}),
    )

    def _devise_code(self, obj):
        return obj.devise.code
    _devise_code.short_description = "Code de la devise"

    def _devise_nom(self, obj):
        return obj.devise.nom
    _devise_nom.short_description = "Nom de la devise"


class ImplantationProxyAdmin(BaseAdmin):
    list_display = ('nom', '_organigramme')
    actions = None

    def __init__(self, *args, **kwargs):
        super(ImplantationProxyAdmin, self).__init__(*args, **kwargs)
        self.list_display_links = (None, )

    def has_add_permission(self, obj):
        return False

    def has_change_permission(self, request, obj=None):
        return in_drh_or_admin(request.user)

    def _organigramme(self, obj):
        return '<a href="%s"><strong>Organigramme</strong></a>' % (
            reverse('rho_implantation', args=(obj.id,))
        )
    _organigramme.allow_tags = True
    _organigramme.short_description = "Organigramme"


class RegionProxyAdmin(BaseAdmin):
    list_display = ('nom', '_organigramme')
    actions = None

    def __init__(self, *args, **kwargs):
        super(RegionProxyAdmin, self).__init__(*args, **kwargs)
        self.list_display_links = (None, )

    def has_add_permission(self, obj):
        return False

    def has_change_permission(self, request, obj=None):
        return in_drh_or_admin(request.user)

    def _organigramme(self, obj):
        return """<a href="%s"><strong>Organigramme</strong></a>""" % (
            reverse('rho_region', args=(obj.id,))
        )
    _organigramme.allow_tags = True
    _organigramme.short_description = "Organigramme"


admin.site.register(rh.Classement, ClassementAdmin)
admin.site.register(rh.Devise, DeviseAdmin)
admin.site.register(rh.Dossier, DossierAdmin)
admin.site.register(EmployeProxy, EmployeProxyAdmin)
admin.site.register(ServiceProxy, ServiceProxyAdmin)
admin.site.register(rh.Employe, EmployeAdmin)
admin.site.register(rh.CategorieEmploi, CategorieEmploiAdmin)
admin.site.register(rh.FamilleProfessionnelle)
admin.site.register(rh.OrganismeBstg, OrganismeBstgAdmin)
admin.site.register(rh.Poste, PosteAdmin)
admin.site.register(
    rh.ResponsableImplantationProxy, ResponsableImplantationAdmin
)
admin.site.register(rh.Service, ServiceAdmin)
admin.site.register(rh.Statut, StatutAdmin)
admin.site.register(rh.TauxChange, TauxChangeAdmin)
admin.site.register(rh.TypeContrat, TypeContratAdmin)
admin.site.register(rh.TypePoste, TypePosteAdmin)
admin.site.register(rh.TypeRemuneration, TypeRemunerationAdmin)
admin.site.register(rh.TypeRevalorisation, TypeRevalorisationAdmin)
admin.site.register(rh.ValeurPoint, ValeurPointAdmin)
admin.site.register(ImplantationProxy, ImplantationProxyAdmin)
admin.site.register(RegionProxy, RegionProxyAdmin)