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

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

import datetime

from django.core.urlresolvers import reverse
from django.contrib import admin
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 ajax_select import make_ajax_form

from auf.django.metadata.admin import \
        AUFMetadataAdminMixin, AUFMetadataInlineAdminMixin, \
        AUF_METADATA_READONLY_FIELDS
import auf.django.references.models as ref

from project.decorators import in_drh_or_admin
from project.groups import grp_correspondants_rh
from project.groups import get_employe_from_user

import project.rh.models as rh
from project.rh.forms import ContratForm, AyantDroitForm, EmployeAdminForm, \
          AjaxSelect, DossierForm, ResponsableInlineForm
        
from project.rh.change_list import ChangeList


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',
        )


class ArchiveMixin(object):
    """
    Archive Mixin pour gérer le queryset et le display
    NON COMPRIS : list_filter, et list_display, field à setter dans la classe.
    """

    def queryset(self, request):
        return self.model._base_manager

    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


# Inlines

class ReadOnlyInlineMixin(object):

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


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

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


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


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


class DossierROInline(ReadOnlyInlineMixin, LinkedInline):
    template = "admin/rh/dossier/linked.html"
    exclude = AUF_METADATA_READONLY_FIELDS
    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(AUFMetadataInlineAdminMixin, \
        admin.TabularInline):
    readonly_fields = ('owner', )
    model = rh.DossierCommentaire
    extra = 1


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


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


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


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


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


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


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


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


class RemunerationROInline(ReadOnlyInlineMixin, RemunerationInline):
    pass


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


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


class ClassementAdmin(AUFMetadataAdminMixin, BaseAdmin):
    list_display = ('_classement', '_date_modification', 'user_modification', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': ('type', 'echelon', 'degre', 'coefficient',)}),
    )

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

    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'


class DeviseAdmin(AUFMetadataAdminMixin, BaseAdmin, ArchiveMixin):
    list_display = (
            'code',
            'nom',
            '_archive',
            '_date_modification',
            'user_modification',
            )
    list_filter = ('archive', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': ('code', 'nom', 'archive', ),
        }),
    )

    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'


class DossierAdmin(DateRangeMixin, AUFMetadataAdminMixin,
                   ProtectRegionMixin, BaseAdmin, AjaxSelect):
    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',
        '_date_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 = AUFMetadataAdminMixin.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 EmployeAdmin(DateRangeMixin, AUFMetadataAdminMixin,
                   ProtectRegionMixin, 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',
            '_date_modification',
            )
    list_display_links = ('_nom',)
    list_filter = (
            'rh_dossiers__poste__implantation__region',
            'rh_dossiers__poste__implantation',
            'nb_postes',
            )
    inlines = (AyantDroitInline,
               DossierROInline,
               EmployePieceInline,
               EmployeCommentaireInline)
    fieldsets = AUFMetadataAdminMixin.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'):
            actif = True
            link_style = u''
            list_style = u''
            if d.date_fin is not None and d.date_fin < datetime.date.today():
                actif = False
                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(EmployeAdmin, 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 EmployeProxyAdmin(EmployeAdmin):
    list_display = ('_id', '_apercu', '_nom', '_organigramme')
    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] %s : %s</li>""" % (
                    d.date_debut.year,
                    d.poste.id,
                    d.poste.nom,
                    organigramme
            )
            l.append(link)
        return "<ul>%s</ul>" % "\n".join(l)

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


class CategorieEmploiAdmin(AUFMetadataAdminMixin, BaseAdmin):
    list_display = ('nom', '_date_modification', 'user_modification', )
    inlines = (TypePosteInline,)
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {'fields': ('nom', )}),)

    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'


class OrganismeBstgAdmin(AUFMetadataAdminMixin, BaseAdmin):
    search_fields = ('nom',)
    list_display = (
            'nom',
            'type',
            'pays',
            '_date_modification',
            'user_modification',
            )
    list_filter = ('type', )
    inlines = (DossierROInline,)
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {'fields': ('nom', 'type', 'pays',)}),
        )

    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'


class PosteAdmin(DateRangeMixin, AUFMetadataAdminMixin,
                 ProtectRegionMixin, BaseAdmin, AjaxSelect):
    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',
        '_region',
        '_implantation',
        '_service',
        '_responsable',
        '_date_debut',
        '_date_fin',
        '_date_modification',
        '_dae',
        )
    list_filter = (
        'implantation__region',
        'implantation',
        'service',
        'type_poste',
        'type_poste__categorie_emploi',
        'type_poste__famille_professionnelle',
        'vacant',
        )
    list_display_links = ('_nom',)
    fieldsets = AUFMetadataAdminMixin.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):
        if obj.service.supprime:
            return """<span style="color:red">%s</span>""" % obj.service
        else:
            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 _date_modification(self, obj):
        return date(obj.date_modification)
    _date_modification.short_description = u'date modification'
    _date_modification.admin_order_field = 'date_modification'

    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',)
    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 ServiceAdmin(AUFMetadataAdminMixin, BaseAdmin, ArchiveMixin):
    list_display = (
            'nom',
            '_archive',
            '_date_modification',
            'user_modification',
            )
    list_filter = ('archive', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': ('nom', 'archive', ),
        }),
        )

    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'


class ServiceProxyAdmin(ServiceAdmin):
    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(AUFMetadataAdminMixin, BaseAdmin):
    list_display = ('code', 'nom', '_date_modification', 'user_modification', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': ('code', 'nom', ),
        }),
        )

    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'


class TauxChangeAdmin(BaseAdmin):
    list_display = (
            'taux',
            'devise',
            'annee',
            '_date_modification',
            'user_modification',
            )
    list_filter = ('devise', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': ('taux', 'devise', 'annee', ),
        }),
        )

    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'


class TypeContratAdmin(BaseAdmin):
    list_display = (
            'nom',
            'nom_long',
            '_date_modification',
            'user_modification',
            )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': ('nom', 'nom_long', ),
        }),
        )

    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'


class TypePosteAdmin(AUFMetadataAdminMixin, BaseAdmin):
    search_fields = ('nom', 'nom_feminin', )
    list_display = (
            'nom',
            'categorie_emploi',
            '_date_modification',
            'user_modification',
            )
    list_filter = ('categorie_emploi', 'famille_professionnelle')
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {
            'fields': (
                'nom',
                'nom_feminin',
                'is_responsable',
                'categorie_emploi',
                'famille_professionnelle',
                )}
            ),
        )

    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'


class TypeRemunerationAdmin(AUFMetadataAdminMixin, BaseAdmin,
                            ArchiveMixin):
    list_display = (
            'nom',
            'type_paiement',
            'nature_remuneration',
            '_archive',
            '_date_modification',
            'user_modification',)
    list_filter = ('archive', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {'fields': ('nom', 'type_paiement', 'nature_remuneration',
        'archive')}),
        )

    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'


class TypeRevalorisationAdmin(AUFMetadataAdminMixin, BaseAdmin):
    list_display = ('nom', '_date_modification', 'user_modification', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {'fields': ('nom', )}),
        )

    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'


class ValeurPointAdmin(AUFMetadataAdminMixin, BaseAdmin):
    list_display = (
            '_devise_code',
            '_devise_nom',
            'annee',
            'implantation',
            'valeur',
            '_date_modification',
            'user_modification',
            )
    list_filter = ('annee', 'devise', 'implantation__region', )
    fieldsets = AUFMetadataAdminMixin.fieldsets + (
        (None, {'fields': ('valeur', 'devise', 'implantation', 'annee', )}),
        )

    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 _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)