Changeset 318 for trunk/client/modules/Elezioni/funzioni.php

Timestamp:

Jun 2, 2019, 10:04:20 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/funzioni.php (modified) (4 diffs)

trunk/client/modules/Elezioni/funzioni.php

@@ -259 +259 @@
       
   
-        $sql="select id_cons from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";
+        $sql="select id_sez  from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";
         $res = $dbi->prepare("$sql");
         $res->execute();
@@ -288 +288 @@
                                         and t2.id_lista=t3.id_lista
                                         and t1.id_gruppo=t3.id_gruppo
-                                        group by t1.id_gruppo
+                                        group by t1.id_gruppo, t1.num_gruppo, t1.descrizione
                                         order by somma desc";
                                 }else{
@@ -295 +295 @@
                                 left join ".$prefix."_ele_voti_gruppo as t2 on (t1.id_gruppo=t2.id_gruppo)
                                         where   t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons $circondt1
-                                        group by t2.id_gruppo
+                                        group by t1.id_gruppo, t1.num_gruppo, t1.descrizione
                                         order by somma desc";
                             }
@@ -303 +303 @@
                         left join ".$prefix."_$tab as t2 on (t1.id_lista=t2.id_lista)
                                 where   t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons
-                                group by t2.id_lista
+                                group by t1.id_lista, t1.num_lista, t1.descrizione
                                 order by somma desc";
                         }