Changeset 278 for trunk

Timestamp:

Apr 20, 2019, 8:04:50 PM (6 years ago)

Author:

roby

Message:

 

Location:

trunk/client/modules/Elezioni

Files:

• blocchi/gom_affluenze.php (modified) (1 diff)
• blocchi/off_Votanti.php (modified) (1 diff)
• index.php (modified) (1 diff)

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

@@ -34 +34 @@
 
                 $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 ";
-        $resl = $dbi->prepare("$sql");
-        $resl->execute();
+        $res1 = $dbi->prepare("$sql");
+        $res1->execute();
 
                 $numero=$res1->rowCount();

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

@@ -22 +22 @@
 #       $numero=mysql_num_rows($res);
 #       $res = mysql_query("select *  from ".$prefix."_ele_sezioni where id_cons='$id_cons'",$dbi);
-        $sql="select t3.*  from ".$prefix."_ele_voti_".$tab." 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' $circos  group by t3.id_sez ";
+        $sql="select t3.id_sez  from ".$prefix."_ele_voti_".$tab." 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' $circos  group by t3.id_sez ";
         $res = $dbi->prepare("$sql");
         $res->execute();

trunk/client/modules/Elezioni/index.php

@@ -616 +616 @@
                 }
                  $sql="select t1.id_sez,sum(t1.voti)  from ".$prefix."_ele_voti_$tab as t1, ".$prefix."_ele_$tab as t2 where t1.id_$tab=t2.id_$tab and t1.id_cons='$id_cons' and t2.id_circ='$id_circ' group by t1.id_sez";
-        }else $sql="select *  from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons'  group by id_sez ";
+        }else $sql="select id_cons  from ".$prefix."_ele_voti_".$tab." where id_cons='$id_cons'  group by id_sez ";
         $res = $dbi->prepare("$sql");
         $res->execute();