';
echo '
Elezioni on line
';
$oggi=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-3,date("Y")));
$sql="select t1.id_cons_gen,t1.descrizione from ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_comune=$id_comune and t1.data_fine>'$oggi' and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and id_sez>0 and permessi>0)";
$rese = $dbi->prepare("$sql");
$rese->execute();
if ($rese->rowCount()>1){
echo "";
}
$sql="select tipo from ".$prefix."_ele_controlli where id_sez='$id_sez' group by tipo";
$rese = $dbi->prepare("$sql");
$rese->execute();
$bordoini="style='cursor: pointer;";
$errbordoa='';
$errbordog='';
$errbordol='';
while (list($tipo)=$rese->fetch(PDO::FETCH_NUM)) {
if ($tipo=='affluenze') $errbordoa="border: 6px solid; border-color: rgb(255, 0, 0);";
if ($tipo=='gruppo' or $tipo=='referendum') $errbordog="border: 6px solid; border-color: rgb(255, 0, 0);";
if ($tipo=='lista') $errbordol="border: 6px solid; border-color: rgb(255, 0, 0);";
}
$bordoa=$bordoini.$errbordoa."'";
$bordog=$bordoini.$errbordog."'";
$bordol=$bordoini.$errbordol."'";
if($rese->rowCount()) $segna="style=\"background-color: #dd0000;\""; else $segna='';
if($ops=="4" ) {$bgcolorg="yellow"; $tcolorg='blue';} else {$bgcolorg="grey"; $tcolorg='white';} #$active_gruppo=" class=\"ui-btn-active\""; else $active_gruppo='';
if($ops=="3") {$bgcolorl="yellow"; $tcolorl='blue';} else {$bgcolorl="grey"; $tcolorl='white';} # $active_lista=" class=\"ui-btn-active\""; else $active_lista='';
if($ops=="1") {$bgcolora="yellow"; $tcolora='blue';} else {$bgcolora="grey"; $tcolora='white';} # $active_aff=" class=\"ui-btn-active\""; else $active_aff='';
echo "";
echo'
'.$logo.' Comune di '.$descr_com.'
Consultazione: '.$descr_cons.'
';
###############
//************************************
// Menu spoglio
//************************************
$sql="select id_sez from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid' and id_comune='$id_comune'";
$sth = $dbi->prepare("$sql"); #echo $sql;
$sth->execute();
list($id_sez)=$sth->fetch(PDO::FETCH_NUM);
$sql="select id_cons,id_sez,id_sede,num_sez, maschi, femmine, colore from ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";
$result = $dbi->prepare("$sql");#echo $sql;
$result->execute();
list($id_cons2,$id_sez2,$id_sede,$num_sez, $maschi, $femmine, $colore) = $result->fetch(PDO::FETCH_NUM);
echo "
Sezione
N. $num_sez | ";
#
echo "\n"._AFFLUENZE." | \n";
if(!($genere==4) and !($votog)){ //if(!($genere==4) and !($tipo_cons==10 or $tipo_cons==11)){
echo ""._GRUPPO." | \n";
}
if($genere==2 and $votog)
echo ""._GRUPPO." | \n";
elseif($genere>=4 and !$votoc)
echo ""._LISTAPREF." | \n";
elseif(($genere>2 or $votog)){ //if(($genere>2 or $tipo_cons==10 or $tipo_cons==11)){
echo ""._LISTA." | \n";
}
echo "
|
\n";
if($ops=="1")votanti($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops,$ov,$mv,$gv,$msv,$av);
elseif($ops=="3")preferenze($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops);
elseif($ops=="4")preferenze_gruppi($id_cons,$do,$id_circ,$id_sede,$id_sez,$ops);
footer_mon();
die();
}
########################################
function footer_mon(){
global $id_comune,$id_cons_gen,$tema,$colortheme,$rss;
echo '