Changeset 101 for trunk/client/modules/Elezioni

Timestamp:

May 26, 2011, 9:42:24 AM (13 years ago)

Author:

roby

Message:

• sistemata visualizzazione affluenze per multireferendum
• sistemato caricamento blocchi laterali

Location:

trunk/client/modules/Elezioni

Files:

• affluenze.php (modified) (3 diffs)
• funzioni.php (modified) (2 diffs)

trunk/client/modules/Elezioni/affluenze.php

@@ -184 +184 @@
                 
 
-
-        $ressomma = mysql_query("select t3.data,t3.orario,sum(t3.voti_complessivi),sum(t3.voti_uomini),sum(t3.voti_donne)  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' $circos  group by t3.data,t3.orario,t3.id_gruppo order by t3.data,t3.orario",$dbi);
+        $ressomma = mysql_query("select t3.data,t3.orario,sum(t3.voti_complessivi),sum(t3.voti_uomini),sum(t3.voti_donne)  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' $circos $cond group by t3.data,t3.orario,t3.id_gruppo order by t3.data,t3.orario",$dbi);
 
 #die("select t3.data,t3.orario,sum(t3.voti_complessivi),sum(t3.voti_uomini),sum(t3.voti_donne)  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' $circos  group by t3.data,t3.orario,t3.id_gruppo ");
@@ -253 +252 @@
 #foreach($ar[['num_sez'] as $i)
 ##########
-        $resvoti = mysql_query("select t1.num_sez  from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t2.id_cons='$id_cons' $circos $cond order by t1.num_sez ",$dbi);
-
+        $resvoti = mysql_query("select t1.num_sez  from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t2.id_cons='$id_cons' $circos order by t1.num_sez ",$dbi);
 ###########
 #               for ($i=$sez_da;$i<=$sez_a;$i++)
@@ -265 +263 @@
         }
         $resvoti = mysql_query("select t3.data,t3.orario,t1.num_sez,voti_uomini, voti_donne, voti_complessivi  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' $circos $cond order by data,orario,t1.num_sez ",$dbi);
-        
         
 #       $resvoti = mysql_query("SELECT  data,orario,t2.num_sez,voti_uomini, voti_donne, voti_complessivi from ".$prefix."_ele_voti_parziale as t1, ".$prefix."_ele_sezioni as t2 where t1.id_cons=$id_cons and t1.id_sez=t2.id_sez $cond order by data,orario,t2.num_sez", $dbi);

trunk/client/modules/Elezioni/funzioni.php

@@ -403 +403 @@
         if($pos=="dx") $p=0; elseif($pos=="sx")$p=1;else $p='';
         
-        $result = mysql_query("SELECT * FROM ".$prefix."_ele_widget where pos_or='$p' and attivo='1' order by pos_ver asc", $dbi);
-        if($result){
-                while ($row = mysql_fetch_array($result)) {
+        $resblk = mysql_query("SELECT * FROM ".$prefix."_ele_widget where pos_or='$p' and attivo='1' order by pos_ver asc", $dbi);
+        if($resblk){
+                while ($row = mysql_fetch_array($resblk)) {
                 $nome=$row['nome_file'];
                 include ("modules/Elezioni/blocchi/$nome");
@@ -417 +417 @@
 if($pos=="dx") $p=0; elseif($pos=="sx")$p=1;else $p='';
         
-        $result = mysql_query("SELECT * FROM ".$prefix."_ele_widget where pos_or='$p' and attivo='1' order by pos_ver asc", $dbi);
-        if ($result) $numero=mysql_num_rows($result);else $numero=0;    
+        $reschk = mysql_query("SELECT * FROM ".$prefix."_ele_widget where pos_or='$p' and attivo='1' order by pos_ver asc", $dbi);
+        if ($reschk) $numero=mysql_num_rows($reschk);else $numero=0;    
 
                 return  $numero;