Add sort tags list by number of documents.
authorcavaliet
Fri, 04 Nov 2011 16:42:01 +0100
changeset 26 9eab3e86db7d
parent 25 11fd79666374
child 28 85c7e5e965e2
Add sort tags list by number of documents.
Controller/WikiTagController.php
Resources/views/WikiTag/TagListTable.html.twig
--- a/Controller/WikiTagController.php	Fri Nov 04 15:59:49 2011 +0100
+++ b/Controller/WikiTagController.php	Fri Nov 04 16:42:01 2011 +0100
@@ -596,16 +596,18 @@
             $sort = "popd"; // sort by descendent popularity by default.
             $reverse_sort = "popa";
         }
-        $sort_query = "t.popularity DESC t.normalizedLabel ASC t.label ASC";
+        //$sort_query = "nb_docs DESC t.popularity DESC t.normalizedLabel ASC t.label ASC";
         switch($sort){
             case "popd":
                 $qb->addOrderBy('t.popularity','DESC');
+                $qb->addOrderBy('nb_docs','DESC');
                 $qb->addOrderBy('t.normalizedLabel','ASC');
                 $qb->addOrderBy('t.label','ASC');
                 $reverse_sort = "popa";
                 break;
             case "popa":
                 $qb->addOrderBy('t.popularity','ASC');
+                $qb->addOrderBy('nb_docs','DESC');
                 $qb->addOrderBy('t.normalizedLabel','ASC');
                 $qb->addOrderBy('t.label','ASC');
                 $reverse_sort = "popd";
@@ -619,6 +621,19 @@
                 $qb->addOrderBy('t.normalizedLabel','ASC');
                 $qb->addOrderBy('t.label','ASC');
                 $reverse_sort = "labd";
+            case "nbd":
+                $qb->addOrderBy('nb_docs','DESC');
+                $qb->addOrderBy('t.popularity','DESC');
+                $qb->addOrderBy('t.normalizedLabel','ASC');
+                $qb->addOrderBy('t.label','ASC');
+                $reverse_sort = "nba";
+                break;
+            case "nba":
+                $qb->addOrderBy('nb_docs','ASC');
+                $qb->addOrderBy('t.popularity','DESC');
+                $qb->addOrderBy('t.normalizedLabel','ASC');
+                $qb->addOrderBy('t.label','ASC');
+                $reverse_sort = "nbd";
                 break;
         }
         
--- a/Resources/views/WikiTag/TagListTable.html.twig	Fri Nov 04 15:59:49 2011 +0100
+++ b/Resources/views/WikiTag/TagListTable.html.twig	Fri Nov 04 16:42:01 2011 +0100
@@ -29,7 +29,28 @@
         <th>Catégorie</th>
         <th class="large_25 text_centered">Supprimer<br/>le lien W</th>
         <th>Alias</th>
-        <th class="text_centered">Nb de<br/>fiches</th>
+        <th>
+        {% if sort != "nba" and sort != "nbd" %}
+            {% if searched and searched != "" %}
+                <a href="?searched={{searched}}&num_page=1&nb_by_page={{nb_by_page}}&sort=nbd">Nb de<br/>fiches</a>
+            {% else %}
+                <a href="?num_page=1&nb_by_page={{nb_by_page}}&sort=nbd">Nb de<br/>fiches</a>
+            {% endif %}
+        {% else %}
+            Nb de<br/>fiches
+            {% if searched and searched != "" %}
+                <a href="?searched={{searched}}&num_page=1&nb_by_page={{nb_by_page}}&sort={{reverse_sort}}">
+            {% else %}
+                <a href="?num_page=1&nb_by_page={{nb_by_page}}&sort={{reverse_sort}}">
+            {% endif %}
+            {% if sort == "nba" %}
+                <img src="{{ asset('bundles/wikitag/images/sort-desc.png') }}"/>
+            {% else %}
+                <img src="{{ asset('bundles/wikitag/images/sort-asc.png') }}"/>
+            {% endif %}
+            </a>
+        {% endif %}
+        </th>
         <th>
         {% if sort != "popa" and sort != "popd" %}
             {% if searched and searched != "" %}
@@ -45,9 +66,9 @@
                 <a href="?num_page=1&nb_by_page={{nb_by_page}}&sort={{reverse_sort}}">
             {% endif %}
             {% if sort == "popa" %}
-                <img src="{{ asset('bundles/wikitag/images/sort-asc.png') }}"/>
+                <img src="{{ asset('bundles/wikitag/images/sort-desc.png') }}"/>
             {% else %}
-                <img src="{{ asset('bundles/wikitag/images/sort-desc.png') }}"/>
+                <img src="{{ asset('bundles/wikitag/images/sort-asc.png') }}"/>
             {% endif %}
             </a>
         {% endif %}