Changeset 1664

Timestamp:

Oct 4, 2010, 11:28:35 PM (10 years ago)

Author:

goya

Message:

correct affichage nombre comments modérés dans liste citoyens

File:

• cpc/trunk/project/apps/frontend/modules/citoyen/actions/actions.class.php (modified) (1 diff)

cpc/trunk/project/apps/frontend/modules/citoyen/actions/actions.class.php

@@ -26 +26 @@
     $query = Doctrine::getTable('Citoyen')
       ->createQuery('c')
-      ->select('c.*, count(distinct(co.id)) as nb_comment'.$datecom)
+      ->select('c.*, sum(co.is_public) as nb_comment'.$datecom)
       ->leftJoin('c.Commentaires co')
       ->where('c.is_active = ?', true)