Changeset 265 for trunk/client/modules/Elezioni/grafici.php
- Timestamp:
- Apr 13, 2019, 8:05:15 PM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/client/modules/Elezioni/grafici.php
r254 r265 7 7 /* info@eleonline.it luciano@aniene.net rgigli@libero.it */ 8 8 /************************************************************************/ 9 9 define('MODULE_FILE'); 10 10 if (!defined('MODULE_FILE')) { 11 die ("You can't access this file directly...");11 # die ("You can't access this file directly..."); 12 12 } 13 13 14 14 15 $res = mysql_query("SELECT t1.descrizione, t1.tipo_cons,t2.genere, t2.voto_g, t2.voto_l, t2.voto_c, t2.circo FROM ".$prefix."_ele_consultazione as t1,".$prefix."_ele_tipo as t2 where t1.tipo_cons=t2.tipo_cons and t1.id_cons_gen='$id_cons_gen' ", $dbi); 16 list($descr_cons,$tipo_cons,$genere,$votog,$votol,$votoc,$circo) = mysql_fetch_row($res); 17 $res = mysql_query("SELECT t2.id_cons FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.id_comune='$id_comune'" , $dbi); 18 list($id_cons) = mysql_fetch_row($res); 15 $sql="SELECT t1.descrizione, t1.tipo_cons,t2.genere, t2.voto_g, t2.voto_l, t2.voto_c, t2.circo FROM ".$prefix."_ele_consultazione as t1,".$prefix."_ele_tipo as t2 where t1.tipo_cons=t2.tipo_cons and t1.id_cons_gen='$id_cons_gen' "; 16 $res = $dbi->prepare("$sql"); 17 $res->execute(); 18 19 list($descr_cons,$tipo_cons,$genere,$votog,$votol,$votoc,$circo) = $res->fetch(PDO::FETCH_NUM); 20 $sql="SELECT t2.id_cons FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.id_comune='$id_comune'" ; 21 $res = $dbi->prepare("$sql"); 22 $res->execute(); 23 24 list($id_cons) = $res->fetch(PDO::FETCH_NUM); 19 25 20 26 … … 37 43 38 44 // circoscrizionali 39 /* da verificare 40 #tolto, gestito globalmente in index.php 41 if ($circo){ // circoscrizione 42 echo "<form name=\"yesy\" method=\"post\" action=\"modules.php\">"; 43 echo "<input type=\"hidden\" name=\"pagina\" value=\"modules.php?name=Elezioni&file=index&id_cons_gen=34&id_comune=$id_comune&op=affluenze_graf&id_circ=\">"; 44 45 $res_sez = mysql_query("SELECT id_circ,descrizione,num_circ from ".$prefix."_ele_circoscrizione where id_cons=$id_cons",$dbi); 46 echo "<td>Scegli la Circoscrizione: <select name=\"id_circ\" onChange=\"top.location.href=this.form.pagina.value+this.form.id_circ.options[this.form.id_circ.selectedIndex].value;return false\">"; 47 while(list($id_rif,$descr_circ,$num_cir)=mysql_fetch_row($res_sez)) { 48 if (!$id_circ) $id_circ=$id_rif; 49 $sel = ($id_rif == $id_circ) ? "selected" : ""; 50 echo "<option value=\"$id_rif\" $sel>"; 51 for ($j=strlen($num_cir);$j<2;$j++) { echo " ";} 52 echo $num_cir.") ".$descr_circ; 53 } 54 echo "</select>"; 55 56 57 58 59 60 //echo "<input type=\"submit\" value=\""._OK."\"></form>"; 61 echo "</td></tr></table>"; 62 $circos="and t2.id_circ='$id_circ'"; 63 64 } 65 66 */ 45 67 46 // numero sezioni scrutinate 68 47 //if ($circo)$circos="and id_circ='$id_circ'"; 69 48 if (!isset($data1)) $data1=''; 70 49 if (!isset($ora_ril)) $ora_ril=''; 71 $res1 = mysql_query("SELECT count(data) 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 t1.id_cons='$id_cons' and data='$data1' and orario='$ora_ril' $circos group by t3.id_gruppo", $dbi); 50 $sql="SELECT count(data) 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 t1.id_cons='$id_cons' and data='$data1' and orario='$ora_ril' $circos group by t3.id_gruppo"; 51 $res1 = $dbi->prepare("$sql"); 52 $res1->execute(); 53 72 54 # mysql_query("select * from ".$prefix."_ele_voti_parziale where id_cons='$id_cons' $circos group by id_sez ",$dbi); 73 $numero=mysql_num_rows($res1); 74 $res2 = mysql_query("SELECT t1.* FROM ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circos order by num_sez", $dbi); 55 $numero=$res1->rowCount(); 56 $sql="SELECT t1.* FROM ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circos order by num_sez"; 57 $res2 = $dbi->prepare("$sql"); 58 $res2->execute(); 59 75 60 #mysql_query("select * from ".$prefix."_ele_sezioni where id_cons='$id_cons' $circos",$dbi); 76 $sezioni= mysql_num_rows($res2);61 $sezioni=$res2->rowCount(); 77 62 78 63 … … 87 72 $m_size2 = getimagesize("modules/Elezioni/images/barre/mainbar2.gif"); 88 73 $r_size2 = getimagesize("modules/Elezioni/images/barre/rightbar2.gif"); 89 90 91 74 // totali 75 76 if($tema=='tour') $andcond="select orario,data from ".$prefix."_ele_voti_parziale where id_cons='$id_cons' order by data desc,orario desc limit 0,1"; else $andcond="select orario,data from ".$prefix."_ele_rilaff where id_cons_gen='$id_cons_gen' order by data,orario"; 92 77 93 $res = mysql_query("$andcond", $dbi); 94 while(list($orario,$data) = mysql_fetch_row($res)) { 78 $sql="$andcond"; 79 $res = $dbi->prepare("$sql"); 80 $res->execute(); 81 82 while(list($orario,$data) = $res->fetch(PDO::FETCH_NUM)) { 95 83 list ($ore,$minuti,$secondi)=explode(':',$orario); 96 84 list ($anno,$mese,$giorno)=explode('-',$data); … … 100 88 echo "<br /><div><h5>"._VOTANTI." "._ALLE." "._ORE." $ore,$minuti "._DEL." $giorno/$mese/$anno</h5></div>"; 101 89 102 $res1 = mysql_query("SELECT count(data) 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 t1.id_cons='$id_cons' and data='$data' and orario='$orario' $circos group by t3.id_gruppo", $dbi); 103 list($numero)=mysql_fetch_row($res1); 104 105 106 $res1 = mysql_query("select sum(t3.voti_complessivi), t4.num_gruppo , t4.id_gruppo 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 left join ".$prefix."_ele_gruppo as t4 on (t3.id_gruppo=t4.id_gruppo) where t3.id_cons='$id_cons' and t3.orario='$orario' and t3.data='$data' $circos group by t4.num_gruppo, t4.id_gruppo order by t4.num_gruppo ",$dbi); 90 $sql="SELECT count(data) 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 t1.id_cons='$id_cons' and data='$data' and orario='$orario' $circos group by t3.id_gruppo"; 91 $res1 = $dbi->prepare("$sql"); 92 $res1->execute(); 93 94 list($numero)=$res1->fetch(PDO::FETCH_NUM); 95 96 97 $sql="select sum(t3.voti_complessivi), t4.num_gruppo , t4.id_gruppo 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 left join ".$prefix."_ele_gruppo as t4 on (t3.id_gruppo=t4.id_gruppo) where t3.id_cons='$id_cons' and t3.orario='$orario' and t3.data='$data' $circos group by t4.num_gruppo, t4.id_gruppo order by t4.num_gruppo "; 98 $res1 = $dbi->prepare("$sql"); 99 $res1->execute(); 100 107 101 #mysql_query("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 " , $dbi); 108 102 … … 111 105 112 106 113 while(list($voti_t, $num_gruppo,$id_gruppo) = mysql_fetch_row($res1)) {107 while(list($voti_t, $num_gruppo,$id_gruppo) = $res1->fetch(PDO::FETCH_NUM)) { 114 108 $query="select sum(voti_complessivi) from ".$prefix."_ele_voti_parziale where orario='$orario' and data='$data' and id_cons='$id_cons'"; 115 109 116 110 if ($genere==0){$query.=" and id_gruppo=$id_gruppo";} 117 $res_aff=mysql_query($query, $dbi); 118 $voti_numero=mysql_num_rows($res_aff); 111 $sql=$query; 112 $res_aff = $dbi->prepare("$sql"); 113 $res_aff->execute(); 114 115 $voti_numero=$res_aff->rowCount(); 119 116 $query="SELECT sum(maschi+femmine) FROM ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circos"; 120 117 #"select sum(maschi+femmine) 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 and orario='$orario' and data='$data' $circos"; … … 122 119 123 120 # if ($genere==0){$query.=" and id_gruppo=$id_gruppo";} 124 $res1234=mysql_query($query, $dbi); 125 list($tot)=mysql_fetch_row($res1234); 121 $sql=$query; 122 $res1234 = $dbi->prepare("$sql"); 123 $res1234->execute(); 124 125 list($tot)=$res1234->fetch(PDO::FETCH_NUM); 126 126 127 127 $perc=number_format($voti_t*100/$tot,2); 128 128 echo "<table class=\"td-80\"><tr class=\"bggray\">"; 129 129 if ($genere==0){echo "<td>Referendum N.</td>";} 130 130 echo "<td><b>"._VOTANTI."</b></td><td><b>"._PERCE."</b></td>"; … … 158 158 159 159 function graf_votanti(){ 160 global $op, $prefix, $dbi, $offset, $min,$descr_cons,$genere,$votog,$votol,$votoc,$circo, $id_cons,$tipo_cons,$id_comune,$id_cons_gen,$id_circ,$csv,$w,$l,$siteistat,$flash,$tour,$tema ;160 global $op, $prefix, $dbi, $offset, $min,$descr_cons,$genere,$votog,$votol,$votoc,$circo, $id_cons,$tipo_cons,$id_comune,$id_cons_gen,$id_circ,$csv,$w,$l,$siteistat,$flash,$tour,$tema,$copy; 161 161 162 162 … … 219 219 */ 220 220 if($genere==0) 221 $ res = mysql_query("select t1.* from ".$prefix."_ele_voti_".$tab." as t1 left join ".$prefix."_ele_$tab as t2 on t1.id_gruppo=t2.id_gruppo where t1.id_cons='$id_cons' $circos group by t1.id_sez ",$dbi);221 $sql="select t1.* from ".$prefix."_ele_voti_".$tab." as t1 left join ".$prefix."_ele_$tab as t2 on t1.id_gruppo=t2.id_gruppo where t1.id_cons='$id_cons' $circos group by t1.id_sez "; 222 222 else 223 $res = mysql_query("select * from ".$prefix."_ele_sezioni where id_cons='$id_cons' and validi+nulli+bianchi+contestati>0", $dbi); 223 $sql="select * from ".$prefix."_ele_sezioni where id_cons='$id_cons' and validi+nulli+bianchi+contestati>0"; 224 $res = $dbi->prepare("$sql"); 225 $res->execute(); 226 224 227 225 228 if($res) 226 $numero= mysql_num_rows($res);229 $numero=$res->rowCount(); 227 230 else 228 231 $numero=1; 229 $res = mysql_query("select t1.* from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos",$dbi); 230 $sezioni=mysql_num_rows($res); 232 $sql="select t1.* from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos"; 233 $res = $dbi->prepare("$sql"); 234 $res->execute(); 235 236 $sezioni=$res->rowCount(); 231 237 if ($numero!=0){ 232 238 … … 234 240 235 241 236 $res1 = mysql_query("SELECT sum(maschi+femmine) from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos",$dbi); 237 list($tot_aventi) = mysql_fetch_row($res1); 242 $sql="SELECT sum(maschi+femmine) from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos"; 243 $res1 = $dbi->prepare("$sql"); 244 $res1->execute(); 245 246 list($tot_aventi) = $res1->fetch(PDO::FETCH_NUM); 238 247 239 248 if ($genere!=0) { … … 243 252 echo "</h2></center>"; 244 253 245 $ res1 = mysql_query("SELECT sum(validi+nulli+bianchi+contestati) as tot,254 $sql="SELECT sum(validi+nulli+bianchi+contestati) as tot, 246 255 sum(validi),sum(nulli),sum(bianchi),sum(contestati), '0' 247 from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos having tot>0",$dbi); 256 from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos having tot>0"; 257 $res1 = $dbi->prepare("$sql"); 258 $res1->execute(); 259 248 260 }else{ 249 261 250 262 if($tema=='tour'){ 251 $res1 = mysql_query("SELECT count(0) 252 from ".$prefix."_ele_gruppo where id_cons=$id_cons",$dbi); 253 254 list($max_ruotag) =mysql_fetch_row($res1); 263 $sql="SELECT count(0) 264 from ".$prefix."_ele_gruppo where id_cons=$id_cons"; 265 $res1 = $dbi->prepare("$sql"); 266 $res1->execute(); 267 268 269 list($max_ruotag) =$res1->fetch(PDO::FETCH_NUM); 255 270 if (isset($_SESSION['ruotag'])) { $ruotag=$_SESSION['ruotag'];} 256 271 else {$ruotag=1;$_SESSION['ruotag']=1;} … … 258 273 else {$ruotag++;} 259 274 $_SESSION['ruotag']=$ruotag; 260 $res1 = mysql_query("SELECT count(0) from ".$prefix."_ele_voti_ref AS t1 LEFT JOIN ".$prefix."_ele_gruppo AS t2 ON t1.id_gruppo = t2.id_gruppo WHERE t1.id_cons ='$id_cons' AND t2.num_gruppo ='$ruotag'",$dbi); 261 list($numero)=mysql_fetch_row($res1); 275 $sql="SELECT count(0) from ".$prefix."_ele_voti_ref AS t1 LEFT JOIN ".$prefix."_ele_gruppo AS t2 ON t1.id_gruppo = t2.id_gruppo WHERE t1.id_cons ='$id_cons' AND t2.num_gruppo ='$ruotag'"; 276 $res1 = $dbi->prepare("$sql"); 277 $res1->execute(); 278 279 list($numero)=$res1->fetch(PDO::FETCH_NUM); 262 280 echo "<center><h2>"; 263 281 echo "<b>"._DETTAGLIO." "._VOTIE."</b> - "; … … 265 283 echo "</h2></center>"; 266 284 267 $ res1 = mysql_query("SELECT sum( t1.validi + t1.nulli + t1.bianchi + t1.contestati ) AS tot, sum( t1.validi ) , sum( t1.nulli ) , sum( t1.bianchi ) , sum( t1.contestati ) , t1.id_gruppo285 $sql="SELECT sum( t1.validi + t1.nulli + t1.bianchi + t1.contestati ) AS tot, sum( t1.validi ) , sum( t1.nulli ) , sum( t1.bianchi ) , sum( t1.contestati ) , t1.id_gruppo 268 286 FROM ".$prefix."_ele_voti_ref AS t1 LEFT JOIN ".$prefix."_ele_gruppo AS t2 ON t1.id_gruppo = t2.id_gruppo 269 WHERE t1.id_cons ='$id_cons' AND t2.num_gruppo ='$ruotag' GROUP BY t1.id_gruppo HAVING tot >0",$dbi); 287 WHERE t1.id_cons ='$id_cons' AND t2.num_gruppo ='$ruotag' GROUP BY t1.id_gruppo HAVING tot >0"; 288 $res1 = $dbi->prepare("$sql"); 289 $res1->execute(); 290 270 291 } else 271 $ res1 = mysql_query("SELECT sum(validi+nulli+bianchi+contestati) as tot,292 $sql="SELECT sum(validi+nulli+bianchi+contestati) as tot, 272 293 sum(validi),sum(nulli),sum(bianchi),sum(contestati), id_gruppo 273 from ".$prefix."_ele_voti_ref where id_cons=$id_cons group by id_gruppo having tot>0",$dbi); 294 from ".$prefix."_ele_voti_ref where id_cons=$id_cons group by id_gruppo having tot>0"; 295 $res1 = $dbi->prepare("$sql"); 296 $res1->execute(); 297 274 298 } 275 while (list($tot_votanti,$validi,$nulli,$bianchi,$contestati,$id) = mysql_fetch_row($res1)){299 while (list($tot_votanti,$validi,$nulli,$bianchi,$contestati,$id) = $res1->fetch(PDO::FETCH_NUM)){ 276 300 $arperc=array(); 277 301 $arval=array($validi,$nulli,$bianchi,$contestati); … … 287 311 288 312 if ($genere==0) { 289 $res = mysql_query("SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id",$dbi); 290 list($num_gruppo,$descr_gruppo) = mysql_fetch_row($res); 313 $sql="SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id"; 314 $res = $dbi->prepare("$sql"); 315 $res->execute(); 316 317 list($num_gruppo,$descr_gruppo) = $res->fetch(PDO::FETCH_NUM); 291 318 } 292 319 … … 364 391 365 392 function graf_gruppo($visgralista){ 366 global $admin, $bgcolor1, $bgcolor5, $prefix, $dbi, $offset, $min,$descr_cons,$genere,$votog,$votol,$votoc,$circo, $id_cons,$id_cons_gen,$id_comune,$id_circ,$tipo_cons,$w,$l,$op,$siteistat,$flash,$tema ;393 global $admin, $bgcolor1, $bgcolor5, $prefix, $dbi, $offset, $min,$descr_cons,$genere,$votog,$votol,$votoc,$circo, $id_cons,$id_cons_gen,$id_comune,$id_circ,$tipo_cons,$w,$l,$op,$siteistat,$flash,$tema,$copy; 367 394 if ($siteistat==$id_comune) $logo=$siteistat; else $logo=''; // logo per il comune 368 395 $logo=verificasimbolo(); // carica_logo da funzioni.php 369 396 if (!$id_circ and $circo){ 370 $res_sez = mysql_query("SELECT id_circ from ".$prefix."_ele_circoscrizione where id_cons=$id_cons order by num_circ limit 0,1",$dbi); 371 list($id_circ)=mysql_fetch_row($res_sez); 397 $sql="SELECT id_circ from ".$prefix."_ele_circoscrizione where id_cons=$id_cons order by num_circ limit 0,1"; 398 $res_sez = $dbi->prepare("$sql"); 399 $res_sez->execute(); 400 401 list($id_circ)=$res_sez->fetch(PDO::FETCH_NUM); 372 402 } 373 403 $circond='';$circondt1=''; … … 375 405 if ($genere==4 or $visgralista){$tab="ele_voti_lista";} 376 406 if ($votog){$tab="ele_voti_lista";} 377 $res = mysql_query("select * from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ",$dbi); 407 $sql="select * from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez "; 408 $res = $dbi->prepare("$sql"); 409 $res->execute(); 410 378 411 if ($circo){ 379 $res = mysql_query("select t1.* from ".$prefix."_ele_voti_gruppo as t1, ".$prefix."_ele_gruppo as t2 where t1.id_gruppo=t2.id_gruppo and t1.id_cons='$id_cons' and t2.id_circ=$id_circ group by t1.id_sez ",$dbi); 380 $restotv = mysql_query("select sum(t1.voti) from ".$prefix."_ele_voti_gruppo as t1, ".$prefix."_ele_gruppo as t2 where t1.id_gruppo=t2.id_gruppo and t1.id_cons='$id_cons' and t2.id_circ=$id_circ",$dbi); 412 $sql="select t1.* from ".$prefix."_ele_voti_gruppo as t1, ".$prefix."_ele_gruppo as t2 where t1.id_gruppo=t2.id_gruppo and t1.id_cons='$id_cons' and t2.id_circ=$id_circ group by t1.id_sez "; 413 $res = $dbi->prepare("$sql"); 414 $res->execute(); 415 416 $sql="select sum(t1.voti) from ".$prefix."_ele_voti_gruppo as t1, ".$prefix."_ele_gruppo as t2 where t1.id_gruppo=t2.id_gruppo and t1.id_cons='$id_cons' and t2.id_circ=$id_circ"; 417 $restotv = $dbi->prepare("$sql"); 418 $restotv->execute(); 419 381 420 $circond="and id_circ=$id_circ";$circondt1="and t1.id_circ=$id_circ"; 382 421 } 383 if ($res) $numero=mysql_num_rows($res);else $numero=0; 384 $res = mysql_query("select t2.* from ".$prefix."_ele_sezioni as t2, ".$prefix."_ele_sede as t1 where t2.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circondt1",$dbi); 385 if ($res) $sezioni=mysql_num_rows($res);else $sezioni=0; 386 387 #tolta, gestita globalmente in index.php 388 /* if ($circo){ // elenco per scelta circoscrizione 389 echo "<form id=\"test\" action=\"modules.php\"> <input type=\"hidden\" name=\"pagina\" value=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=\">"; 390 $res_sez = mysql_query("SELECT id_circ,descrizione,num_circ from ".$prefix."_ele_circoscrizione where id_cons=$id_cons",$dbi); 391 echo "<table><tr><td>Scegli la Circoscrizione: <select name=\"id_circ\" onChange=\"top.location.href=this.form.pagina.value+this.form.id_circ.options[this.form.id_circ.selectedIndex].value;return false\">"; 392 while(list($id_rif,$descrizione,$num_cir)=mysql_fetch_row($res_sez)) { 393 if (!$id_circ) $id_circ=$id_rif; 394 $sel = ($id_rif == $id_circ) ? "selected" : ""; 395 echo "<option value=\"$id_rif\" $sel>"; 396 for ($j=strlen($num_cir);$j<2;$j++) { echo " ";} 397 echo $num_cir.") ".$descrizione; 398 } 399 echo "</select></td></tr></table></form>"; 400 401 } 402 */ 422 if ($res) $numero=$res->rowCount();else $numero=0; 423 $sql="select t2.* from ".$prefix."_ele_sezioni as t2, ".$prefix."_ele_sede as t1 where t2.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circondt1"; 424 $res = $dbi->prepare("$sql"); 425 $res->execute(); 426 427 if ($res) $sezioni=$res->rowCount();else $sezioni=0; 428 429 403 430 if ($numero>0){ 404 431 echo "<center><h2>"; … … 414 441 // tot voti 415 442 if (!$circo) 416 $ restotv = mysql_query("select sum(voti) from ".$prefix."_$tab where id_cons=$id_cons ", $dbi);443 $sql="select sum(voti) from ".$prefix."_$tab where id_cons=$id_cons "; 417 444 if ($votog) 418 $restotv = mysql_query("select sum(voti) from ".$prefix."_ele_voti_lista where id_cons=$id_cons ", $dbi); 419 list($tot) = mysql_fetch_row($restotv); 445 $sql="select sum(voti) from ".$prefix."_ele_voti_lista where id_cons=$id_cons "; 446 $restotv = $dbi->prepare("$sql"); 447 $restotv->execute(); 448 list($tot) = $restotv->fetch(PDO::FETCH_NUM); 449 420 450 421 451 $i=0; … … 425 455 if ($votog){ 426 456 427 $ res = mysql_query("select t1.id_gruppo, t1.num_gruppo, t1.descrizione, sum(t2.voti) as somma457 $sql="select t1.id_gruppo, t1.num_gruppo, t1.descrizione, sum(t2.voti) as somma 428 458 from ".$prefix."_ele_gruppo as t1, 429 459 ".$prefix."_ele_voti_lista as t2, … … 433 463 and t1.id_gruppo=t3.id_gruppo 434 464 group by t1.id_gruppo 435 order by somma desc", $dbi);$cosa='id_gruppo'; 465 order by somma desc"; 466 $cosa='id_gruppo'; 436 467 437 468 }else{ 438 469 439 470 440 $ res = mysql_query("select t1.id_gruppo, t1.num_gruppo, t1.descrizione, sum(t2.voti) as somma471 $sql="select t1.id_gruppo, t1.num_gruppo, t1.descrizione, sum(t2.voti) as somma 441 472 from ".$prefix."_ele_gruppo as t1 442 473 left join ".$prefix."_$tab as t2 on (t1.id_gruppo=t2.id_gruppo) 443 474 where t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons $circondt1 444 475 group by t2.id_gruppo 445 order by somma desc", $dbi);$cosa='id_gruppo'; 446 } 476 order by somma desc"; 477 $cosa='id_gruppo'; 478 } 479 $res = $dbi->prepare("$sql"); 480 $res->execute(); 447 481 448 482 449 483 }else{ 450 $ res = mysql_query("select t1.id_lista, t1.num_lista, t1.descrizione, sum(t2.voti) as somma484 $sql="select t1.id_lista, t1.num_lista, t1.descrizione, sum(t2.voti) as somma 451 485 from ".$prefix."_ele_lista as t1 452 486 left join ".$prefix."_$tab as t2 on (t1.id_lista=t2.id_lista) 453 487 where t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons $circondt1 454 488 group by t2.id_lista 455 order by somma desc", $dbi);$cosa='id_lista'; 489 order by somma desc"; 490 $res = $dbi->prepare("$sql"); 491 $res->execute(); 492 $cosa='id_lista'; 456 493 } 457 494 … … 467 504 $e=1; 468 505 // fine 469 $gruppinum= mysql_num_rows($res);506 $gruppinum=$res->rowCount(); 470 507 $altrivoti=0; 471 508 ####calcolo percentuale 472 509 $arvoti=array(); 473 510 $arperc=array(); 474 while (list($id,$num,$descrizione,$voti) = mysql_fetch_row($res)){511 while (list($id,$num,$descrizione,$voti) = $res->fetch(PDO::FETCH_NUM)){ 475 512 $arvoti[$id]=$voti; 476 513 } 477 514 $arperc=arrayperc($arvoti,$tot); 478 mysql_data_seek($res,0); 515 $res = $dbi->prepare("$sql"); 516 $res->execute(); 517 479 518 #### 480 519 $altriperc=0; 481 while (list($id,$num,$descrizione,$voti) = mysql_fetch_row($res)){520 while (list($id,$num,$descrizione,$voti) = $res->fetch(PDO::FETCH_NUM)){ 482 521 483 522 … … 572 611 // tot voti 573 612 if($tema=='tour'){ 574 $res1 = mysql_query("SELECT count(0) 575 from ".$prefix."_ele_gruppo where id_cons=$id_cons",$dbi); 576 list($max_ruotag) =mysql_fetch_row($res1); 613 $sql="SELECT count(0) from ".$prefix."_ele_gruppo where id_cons=$id_cons"; 614 $res1 = $dbi->prepare("$sql"); 615 $res1->execute(); 616 617 list($max_ruotag) =$res1->fetch(PDO::FETCH_NUM); 577 618 if (isset($_SESSION['ruotag'])) { $ruotag=$_SESSION['ruotag'];} 578 619 else {$ruotag=1;$_SESSION['ruotag']=1;} 579 $ res = mysql_query("select sum(t1.validi),t1.id_gruppo from ".$prefix."_$tab as t1 left join soraldo_ele_gruppo as t2 on t1.id_gruppo=t2.id_gruppo where t1.id_cons='$id_cons' and t2.num_gruppo='$ruotag' group by t1.id_gruppo", $dbi);620 $sql="select sum(t1.validi),t1.id_gruppo from ".$prefix."_$tab as t1 left join soraldo_ele_gruppo as t2 on t1.id_gruppo=t2.id_gruppo where t1.id_cons='$id_cons' and t2.num_gruppo='$ruotag' group by t1.id_gruppo"; 580 621 }else 581 $res = mysql_query(" 582 select sum(validi),id_gruppo from ".$prefix."_$tab where id_cons=$id_cons group by id_gruppo", $dbi); 583 while (list($tot,$id_gruppo) = mysql_fetch_row($res)){ 622 $sql="select sum(validi),id_gruppo from ".$prefix."_$tab where id_cons=$id_cons group by id_gruppo"; 623 $res = $dbi->prepare("$sql"); 624 $res->execute(); 625 626 while (list($tot,$id_gruppo) = $res->fetch(PDO::FETCH_NUM)){ 584 627 585 628 $s=0; 586 $ res1 = mysql_query("select t1.id_gruppo, t1.num_gruppo, t1.descrizione, sum(t2.si), sum(t2.no)629 $sql="select t1.id_gruppo, t1.num_gruppo, t1.descrizione, sum(t2.si), sum(t2.no) 587 630 from ".$prefix."_ele_gruppo as t1 588 631 left join ".$prefix."_$tab as t2 on (t1.id_gruppo=t2.id_gruppo) 589 632 where t1.id_cons='$id_cons' and t1.id_gruppo='$id_gruppo' 590 633 group by t1.id_gruppo 591 ", $dbi); 592 593 594 while (list($id_gruppo,$num_gruppo,$descrizione,$si,$no) = mysql_fetch_row($res1)){ 634 "; 635 $res1 = $dbi->prepare("$sql"); 636 $res1->execute(); 637 638 639 640 while (list($id_gruppo,$num_gruppo,$descrizione,$si,$no) = $res1->fetch(PDO::FETCH_NUM)){ 595 641 if($tot){ 596 642 $percsi=number_format($si*100/$tot,3); … … 663 709 $tab="ele_voti_candidati"; 664 710 665 $res = mysql_query("select * from ".$prefix."_ele_voti_candidati where id_cons='$id_cons' group by id_sez ",$dbi); 666 $numero=mysql_num_rows($res); 667 $res = mysql_query("select * from ".$prefix."_ele_sezioni where id_cons='$id_cons'",$dbi); 668 $sezioni=mysql_num_rows($res); 711 $sql="select * from ".$prefix."_ele_voti_candidati where id_cons='$id_cons' group by id_sez "; 712 $res = $dbi->prepare("$sql"); 713 $res->execute(); 714 715 $numero=$res->rowCount(); 716 $sql = "select * from ".$prefix."_ele_sezioni where id_cons='$id_cons'"; 717 $res = $dbi->prepare("$sql"); 718 $res->execute(); 719 720 $sezioni=$res->rowCount(); 669 721 if ($numero!=0){ 670 722 echo "<table border=\"0\" align=\"center\"><tr><td>"; … … 674 726 echo "</td></tr></table>"; 675 727 // tot voti 676 $res = mysql_query(" 677 select sum(voti) from ".$prefix."_ele_voti_candidati where id_cons=$id_cons ", $dbi); 678 list($tot) = mysql_fetch_row($res); 728 $sql="select sum(voti) from ".$prefix."_ele_voti_candidati where id_cons=$id_cons "; 729 $res = $dbi->prepare("$sql"); 730 $res->execute(); 731 list($tot) = $res->fetch(PDO::FETCH_NUM); 679 732 680 733 // gruppi o liste per simbolo … … 686 739 } 687 740 $i=0; 688 $ res = mysql_query("select t1.id_lista, t1.id_cand, t1.nome , t1.cognome, sum(t2.voti) as somma741 $sql="select t1.id_lista, t1.id_cand, t1.nome , t1.cognome, sum(t2.voti) as somma 689 742 from ".$prefix."_ele_candidati as t1 690 743 left join ".$prefix."_ele_voti_candidati as t2 on (t1.id_cand=t2.id_cand) … … 695 748 order by somma desc 696 749 697 ", $dbi); 698 $n_candi=mysql_num_rows($res); 750 "; 751 $res = $dbi->prepare("$sql"); 752 $res->execute(); 753 754 $n_candi=$res->rowCount(); 699 755 echo "<table><tr><td><table>"; // inizio tabella dati 700 while (list($id_lista,$id_cand,$nome,$cognome,$voti) = mysql_fetch_row($res)){756 while (list($id_lista,$id_cand,$nome,$cognome,$voti) = $res->fetch(PDO::FETCH_NUM)){ 701 757 $candidato[$i]=$cognome; 702 758 if ($tot) $pro[$i]=number_format($voti*100/$tot,2); else $pro[$i]=0;
Note:
See TracChangeset
for help on using the changeset viewer.