| 1 | <?php
|
|---|
| 2 | /************************************************************************/
|
|---|
| 3 | /* Eleonline - Raccolta e diffusione dei dati elettorali */
|
|---|
| 4 | /* by Roberto Gigli & Luciano Apolito */
|
|---|
| 5 | /* http://www.eleonline.it */
|
|---|
| 6 | /* info@eleonline.it luciano@aniene.net rgigli@libero.it */
|
|---|
| 7 | /************************************************************************/
|
|---|
| 8 | /* widget pie google affluenze
|
|---|
| 9 | by luc 25 giugno 2009 */
|
|---|
| 10 |
|
|---|
| 11 | if (!defined('MODULE_FILE')) {
|
|---|
| 12 | die ("You can't access this file dirrectly...");
|
|---|
| 13 | }
|
|---|
| 14 |
|
|---|
| 15 |
|
|---|
| 16 |
|
|---|
| 17 | global $circo,$prefix,$dbi,$id_cons,$genere,$id_circ,$id_comune,$id_cons_gen;
|
|---|
| 18 |
|
|---|
| 19 | if (isset($circo) and $circo) $circos="and t2.id_circ='$id_circ'";
|
|---|
| 20 | else $circos='';
|
|---|
| 21 | // numero sezioni scrutinate
|
|---|
| 22 |
|
|---|
| 23 | $res2 = 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);
|
|---|
| 24 | $sezioni=mysql_num_rows($res2);
|
|---|
| 25 |
|
|---|
| 26 | $res = mysql_query("select orario,data from ".$prefix."_ele_voti_parziale where id_cons='$id_cons' order by data desc,orario desc limit 1", $dbi);
|
|---|
| 27 | if($res){
|
|---|
| 28 |
|
|---|
| 29 | while(list($orario,$data) = mysql_fetch_row($res)) {
|
|---|
| 30 | list ($ore,$minuti,$secondi)=explode(':',$orario);
|
|---|
| 31 | list ($anno,$mese,$giorno)=explode('-',$data);
|
|---|
| 32 | $tot_v_m=0;$tot_v_d=0;$tot_t=0;
|
|---|
| 33 |
|
|---|
| 34 |
|
|---|
| 35 | $res1 = mysql_query("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 ",$dbi);
|
|---|
| 36 | $numero=mysql_num_rows($res1);
|
|---|
| 37 |
|
|---|
| 38 | echo "<h5>Ultime Affluenze</h5>";
|
|---|
| 39 | echo "<div style=\"text-align:center;color:#ff0000\"><b>"._ORE." $ore,$minuti "._DEL." $giorno/$mese/$anno</b></div>";
|
|---|
| 40 |
|
|---|
| 41 |
|
|---|
| 42 |
|
|---|
| 43 |
|
|---|
| 44 | # $res1 = 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);
|
|---|
| 45 | #modifica del 26giugno 09 per gestione circoscrizionali
|
|---|
| 46 | if($genere==0) $res1 = 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);
|
|---|
| 47 | else
|
|---|
| 48 | $res1 = mysql_query("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",$dbi);
|
|---|
| 49 | #fine modifica
|
|---|
| 50 |
|
|---|
| 51 |
|
|---|
| 52 |
|
|---|
| 53 |
|
|---|
| 54 |
|
|---|
| 55 | while(list($voti_t, $num_gruppo,$id_gruppo) = mysql_fetch_row($res1)) {
|
|---|
| 56 |
|
|---|
| 57 | $query="select sum(t3.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' and t3.data='$data' and t3.orario='$orario' $circos";
|
|---|
| 58 | if ($genere==0){$query.=" and t3.id_gruppo=$id_gruppo";}
|
|---|
| 59 | $res_aff=mysql_query($query, $dbi);
|
|---|
| 60 | $voti_numero=mysql_num_rows($res_aff);
|
|---|
| 61 |
|
|---|
| 62 | $query="select sum(t1.maschi+t1.femmine) 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";
|
|---|
| 63 |
|
|---|
| 64 | if ($genere==0){$query.=" and id_gruppo=$id_gruppo";}
|
|---|
| 65 | $res1234=mysql_query($query, $dbi);
|
|---|
| 66 | list($tot)=mysql_fetch_row($res1234);
|
|---|
| 67 | if ($tot)
|
|---|
| 68 | $perc=number_format($voti_t*100/$tot,2);
|
|---|
| 69 | else {$tot=0;$perc="0.00";}
|
|---|
| 70 |
|
|---|
| 71 | $resto=100-$perc;
|
|---|
| 72 | if ($genere==0){echo "<div style=\"text-align:center\">referendum n. $num_gruppo</div";}
|
|---|
| 73 |
|
|---|
| 74 | echo "<center><img src=\"http://chart.apis.google.com/chart?
|
|---|
| 75 | chs=200x70
|
|---|
| 76 | &chd=t:$resto,$perc
|
|---|
| 77 | &cht=p3
|
|---|
| 78 | &chl=|$perc%
|
|---|
| 79 | &chco=ff0000,ffff00 \"
|
|---|
| 80 | alt=\"Sample chart\" />
|
|---|
| 81 | <a href=\"modules.php?id_cons_gen=$id_cons_gen&name=Elezioni&id_comune=$id_comune&file=index&op=affluenze_graf\">Tutte le affluenze</a>
|
|---|
| 82 | </center>";
|
|---|
| 83 |
|
|---|
| 84 |
|
|---|
| 85 |
|
|---|
| 86 | }
|
|---|
| 87 |
|
|---|
| 88 | }
|
|---|
| 89 | }
|
|---|
| 90 | ?>
|
|---|
