From 952ecb37c78ab6eb54aca28ed8818404e438cd87 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Olivier=20Larchev=C3=AAque?= <olivier.larcheveque@auf.org>
Date: Wed, 22 Feb 2012 10:41:57 -0500
Subject: [PATCH] restore ordering on classement

---
 project/rh/models.py |   12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/project/rh/models.py b/project/rh/models.py
index 243b4bf..96ae6d1 100644
--- a/project/rh/models.py
+++ b/project/rh/models.py
@@ -1053,6 +1053,16 @@ TYPE_CLASSEMENT_CHOICES = (
     ('HG', 'HG - Hors grille [direction]'),
 )
 
+class ClassementManager(models.Manager):
+    """
+    Ordonner les spcéfiquement les classements.
+    """
+    def get_query_set(self):
+        qs = super(self.__class__, self).get_query_set()
+        qs = qs.extra(select={'ponderation': 'FIND_IN_SET(type,"SO,HG,S,T,P,C,D")'})
+        qs = qs.extra(order_by=('ponderation', ))
+        return qs.all()
+
 
 class Classement_(AUFMetadata):
     """Éléments de classement de la
@@ -1063,6 +1073,8 @@ class Classement_(AUFMetadata):
 
     salaire de base = coefficient * valeur du point de l'Implantation du Poste
     """
+    objects = ClassementManager()
+
     # Identification
     type = models.CharField(max_length=10, choices=TYPE_CLASSEMENT_CHOICES)
     echelon = models.IntegerField(verbose_name=u"Échelon", blank=True, default=0)
-- 
1.7.10.4