Changeset 320 for trunk/client/modules/Elezioni/gruppo.php

Timestamp:

Jun 4, 2019, 9:27:56 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/gruppo.php (modified) (3 diffs)

trunk/client/modules/Elezioni/gruppo.php

@@ -258 +258 @@
                         and t3.id_sede=t4.id_sede
                         and t4.id_circ=t5.id_circ $condcirc
-                        group by t1.num_cand,$tab3, nome
+                        group by t1.num_cand,$tab2, t1.cognome,t1.nome
                         order by $tab3,t1.num_cand";
                         $res_voti = $dbi->prepare("$sqlvoti");
@@ -788 +788 @@
                         left join ".$prefix."_ele_circoscrizione as t5 on (t4.id_circ=t5.id_circ)
                         where   t1.id_cons='$id_cons' and t1.id_gruppo=$id_gruppo
-                        group by t2.id_gruppo,$tab3
+                        group by t2.id_gruppo,$tab2, t1.num_gruppo, t1.descrizione , t1.simbolo
                         order by $tab3, t1.num_gruppo
                         ";
@@ -856 +856 @@
 
 // numero sezioni scrutinate
-        $sql="select t3.*  from ".$prefix."_ele_voti_ref as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons'  group by t3.id_sez ";
+        $sql="select t3.id_sez  from ".$prefix."_ele_voti_ref as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons'  group by t3.id_sez ";
         $res4 = $dbi->prepare("$sql");
         $res4->execute();