[Noalyss-commit] [noalyss] 26/323: Task#1461 : nombre de fiches dans catégorie

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 1717dac2e8f52fdd1f3e9ced1b513eacee3b7380
Author: Dany De Bontridder <address@hidden>
Date:   Mon Jan 8 11:40:07 2018 +0100

    Task#1461 : nombre de fiches dans catégorie
---
 include/fiche.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/fiche.inc.php b/include/fiche.inc.php
index b16423a..e4c6d72 100644
--- a/include/fiche.inc.php
+++ b/include/fiche.inc.php
@@ -36,7 +36,7 @@ global $g_user, $g_failed;
  */
 /* category */
 $categorie = new ISelect('cat');
-$categorie->value = $cn->make_array('select fd_id,fd_label from fiche_def 
order by fd_label');
+$categorie->value = $cn->make_array("select fd_id,fd_label||'('||(select 
count(*) from fiche where fiche.fd_id=fiche_def.fd_id)::text||')' from 
fiche_def order by fd_label");
 $categorie->selected = (isset($_GET['cat'])) ? $_GET['cat'] : 0;
 $str_categorie = $categorie->input();