Changeset 279 for trunk/client/modules/Elezioni/blocchi/pie_affluenze.php

Timestamp:

Apr 20, 2019, 8:32:48 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/blocchi/pie_affluenze.php (modified) (2 diffs)

trunk/client/modules/Elezioni/blocchi/pie_affluenze.php

@@ -39 +39 @@
         
 
-                $sql="select t3.*  from ".$prefix."_ele_voti_parziale 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' and t3.data='$data' and t3.orario='$orario' $circos  group by t3.id_sez ";
+                $sql="select t3.id_sez from ".$prefix."_ele_voti_parziale 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' and t3.data='$data' and t3.orario='$orario' $circos  group by t3.id_sez ";
         $res1 = $dbi->prepare("$sql");
         $res1->execute();
@@ -54 +54 @@
 #modifica del 26giugno 09 per gestione circoscrizionali
 if($genere==0)  {       $sql="select sum(t1.voti_complessivi), t2.num_gruppo , t2.id_gruppo from ".$prefix."_ele_voti_parziale as t1 left join ".$prefix."_ele_gruppo as t2 on (t1.id_gruppo=t2.id_gruppo) where t1.id_cons='$id_cons' and t1.orario='$orario' and t1.data='$data' group by t2.num_gruppo,t2.id_gruppo order by t2.num_gruppo " ;
-        $resl = $dbi->prepare("$sql");
-        $resl->execute();
+        $res1 = $dbi->prepare("$sql");
+        $res1->execute();
 
                 }else{
                 $sql="select sum(t3.voti_complessivi),0,0  from ".$prefix."_ele_voti_parziale 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' and t3.data='$data' and t3.orario='$orario' $circos";
-        $resl = $dbi->prepare("$sql");
-        $resl->execute();
+        $res1 = $dbi->prepare("$sql");
+        $res1->execute();
                 }
 #fine modifica