Context Navigation

source: trunk/client/modules/Elezioni/gruppo.php@ 346

Last change on this file since 346 was 346, checked in by roby, 4 years ago
ulteriori modifiche per adeguamento a php7 Client: aggiornamento jpgraph
File size: 44.9 KB

Rev	Line
[254]	1	<?php
	2	/************************************************************************/
	3	/* Eleonline - Raccolta e diffusione dei dati elettorali */
	4	/* by Luciano Apolito & Roberto Gigli */
	5	/* http://www.eleonline.it */
	6	/* info@eleonline.it rgigli@libero.it */
	7	/************************************************************************/
	8
	9	if (!defined('MODULE_FILE')) {
	10	die ("You can't access this file directly...");
	11	}
	12	if ($xls=='1' or $pdf=='1') {
	13	include_once("modules/Elezioni/language/lang-$lang.php");
	14	include_once("modules/Elezioni/funzioni.php");
	15	}
	16	$param=strtolower($_SERVER['REQUEST_METHOD']) == 'get' ?
	17	$_GET : $_POST;
	18
	19	if (isset($param['id_cons_gen'])) $id_cons_gen=intval($param['id_cons_gen']); else $id_cons_gen='';
	20	//if (isset($param['op'])) $op=$param['op']; else $op='';
	21	if (isset($param['minsez'])) $minsez=intval($param['minsez']); else $minsez='';
	22	if (isset($param['id_lista'])) $id_lista=intval($param['id_lista']); else $id_lista='';
	23	if (isset($param['id_circ'])) $id_circ=intval($param['id_circ']); else $id_circ='';
	24	if (isset($param['csv'])) $csv=intval($param['csv']); else $csv='';
	25	if (isset($param['min'])) $min=intval($param['min']); else $min= 0;
	26	if (isset($param['orvert'])) $orvert=intval($param['orvert']); else $orvert='';
	27	if (isset($param['offset'])) $offset=intval($param['offset']); else $offset='';
	28	if (isset($param['offsetsez'])) $offsetsez=intval($param['offsetsez']); else $offsetsez='';
	29	if (isset($param['perc'])) $perc=$param['perc']; else $perc='';
	30	if (isset($param['info'])) $info=addslashes($param['info']); else $info='';
	31	if (isset($param['files'])) $files=addslashes($param['files']); else $files='';
	32	if (isset($param['voti_lista'])) $voti_lista=intval($param['voti_lista']); else $voti_lista= 0;
	33	if (isset($param['perc_lista'])) $perc_lista=$param['perc_lista']; else $perc_lista= 0;
	34	if (isset($param['lettera'])) $lettera=addslashes($param['lettera']); else $lettera='';
	35	if (isset($param['id_gruppo'])) $id_gruppo=intval($param['id_gruppo']); else $id_gruppo='';
	36	#if (isset($param['tipo_cons'])) $tipo_cons=intval($param['tipo_cons']); else $tipo_cons='';
	37	if (isset($param['pdf'])) $pdf=intval($param['pdf']); else $pdf='';
	38	if (isset($param['orienta'])) $orienta=addslashes($param['orienta']); else $orienta='';
	39	if (isset($param['datipdf'])) $datipdf=addslashes($param['datipdf']); else $datipdf='';
	40	if (isset($param['formato'])) $formato=addslashes($param['formato']); else $formato='';
	41	# anti-xss nov. 2009
	42	$id_comune=htmlentities($id_comune);
	43	$id_comune=intval($id_comune);
	44	$perc=htmlentities($perc);
	45	$perc_lista=floatval($perc_lista);
	46	#$datipdf= htmlentities($datipdf);
	47	$op= htmlentities($op);
	48	$info= htmlentities($info);
	49	$files=htmlentities($files);
	50	$lettera=htmlentities($lettera);
	51	$orienta=htmlentities($orienta);
	52	$formato=htmlentities($formato);
	53
	54
	55
	56
	57
	58	include("crea_pagina.php");
	59
[318]	60	$sql="SELECT descrizione from ".$prefix."_ele_comuni where id_comune='$id_comune'" ;
	61	$res = $dbi->prepare("$sql");
	62	$res->execute();
[254]	63
[265]	64	list($descr_comune) = $res->fetch(PDO::FETCH_NUM);
[254]	65
[318]	66	$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' ";
	67	$res = $dbi->prepare("$sql");
	68	$res->execute();
[254]	69
[265]	70	list($descr_cons,$tipo_cons,$genere,$votog,$votol,$votoc,$circo) = $res->fetch(PDO::FETCH_NUM);
[318]	71	$sql="SELECT t2.id_cons,t2.solo_gruppo,t2.disgiunto 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'" ;
	72	$res = $dbi->prepare("$sql");
	73	$res->execute();
[254]	74
[265]	75	list($id_cons,$dettnulli,$disgiunto) = $res->fetch(PDO::FETCH_NUM);
[254]	76
	77
	78
	79
[265]	80
	81
	82
[254]	83	////////////////////////////////////////////////////////////
	84	// Visualizza i dati per liste, gruppi e referendum, per sezione o circoscrizione
	85	////////////////////////////////////////////////////////////
	86
	87	function gruppo_circo(){
	88	global $prefix, $dbi, $descr_cons, $id_cons, $id_cons_gen,$tipo_cons,$votog,$votol,$votoc,$circo, $genere,$id_gruppo,$id_lista,$bgcolor1,$bgcolor2,$id_comune,$descr_comune,$id_circ;
	89	global $id_comune,$id_cons_gen,$op,$minsez,$id_lista,$id_circ,$csv,$min,$orienta,$formato,$dettnulli,$disgiunto,
	90	$orvert,$offset,$offsetsez,$perc,$info,$files,$nomefile;
	91	$nomefile="";
	92	#Denominazione pagine
	93	if($op=="gruppo_circo") $pagina=_GRUPPO." "._PER." "._CIRCO;
	94	if($op=="gruppo_sezione") $pagina=_GRUPPO." "._PER." "._SEZIONI;
	95	if($op=="lista_circo") $pagina=_LISTA." "._PER." "._CIRCO;
	96	if($op=="lista_sezione") $pagina=_LISTA." "._PER." "._SEZIONI;
	97	if($op=="candidato_circo") $pagina=_CONSI." "._PER." "._CIRCO;
	98	if($op=="candidato_sezione") $pagina=_CONSI." "._PER." "._SEZIONI;
	99	if($op=="consiglieri") $pagina=_CALCONS;
	100	if (strstr( $op,'circo')) { //$op=='gruppo_circo' or $op=='lista_circo') {
	101	$tab1="circ";
	102	$tab2="t5.num_circ,t5.descrizione";
	103	$tab3="t5.num_circ";
	104	$tipo1=_DA." "._CIRCO;
	105	$tipo2=_CIRCOS;
	106	$tipo3=_CIRCO;
	107	}else{
	108	$tab1="sez";
	109	$tab2="t3.num_sez,''";
	110	$tab3="t3.num_sez";
	111	$tipo1=_DA." "._SEZIONE;
	112	$tipo2=_SEZIONI;
	113	$tipo3=_SEZIONE;
	114	}
	115	if (strstr( $op,"gruppo")){
	116	$tab="gruppo";
	117	}elseif (strstr( $op,'lista')) {
	118	$tab="lista";
	119	}else{
	120	$tab="candidati";
	121	}
	122	if ($orvert) {
	123	$righe='';
	124	$colonne='checked';
	125	}else{
	126	$righe='checked';
	127	$colonne='';
	128	}
	129
	130	if ($orienta) {
	131	$land='';
	132	$port='checked';
	133	}else{
	134	$land='checked';
	135	$port='';
	136	}
	137
	138	if ($formato) {
	139	$A3='';
	140	$A4='checked';
	141	}else{
	142	$A3='checked';
	143	$A4='';
	144	}
	145
	146
	147
	148	if ($genere>0) { //se non e' un referendum
	149
	150
	151	$voticompl=0;
	152	if (!($offset)) $offset=25;
	153	if (!($min)) $min=1;
	154	if (!($offsetsez)) $offsetsez=22;
	155	if (!($minsez)) $minsez=1;
	156	if ($min>$offset) {
	157	$appo=$min;
	158	$min=$offset;
	159	$offset=$appo;
	160	}
	161	if ($minsez>$offsetsez) {
	162	$appo=$minsez;
	163	$minsez=$offsetsez;
	164	$offsetsez=$appo;
	165	}
	166	if (!$csv){
[265]	167	echo "<form id=\"voti\" method=\"post\" action=\"modules.php\">";
	168	echo "<div><input type=\"hidden\" name=\"pag\" value=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=$id_circ&id_lista=\"></input>";
	169	echo "<input type=\"hidden\" name=\"pagina\" value=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&id_circ=\"></input>";
[254]	170	}
	171	$condcirc='';
	172	if ($circo){ //gestione circoscrizionali
	173	if(!$id_circ){
[318]	174	$sql="SELECT id_circ from ".$prefix."_ele_circoscrizione where id_cons=$id_cons and num_circ=1";
	175	$res_cir = $dbi->prepare("$sql");
	176	$res_cir->execute();
[265]	177	//se non si e' scelta una circoscr. prende la prima
	178	list($id_circ)=$res_cir->fetch(PDO::FETCH_NUM);
[254]	179	}
[318]	180	$sql="SELECT num_circ from ".$prefix."_ele_circoscrizione where id_circ=$id_circ";
	181	$res_cir = $dbi->prepare("$sql");
	182	$res_cir->execute();
[265]	183	//estrae il numero della circoscrizione
	184	list($num_circ)=$res_cir->fetch(PDO::FETCH_NUM);
[254]	185	$condcirc="and id_circ=$id_circ"; //variabile aggiunta nelle select per le circ.
[338]	186	$sql="SELECT count(t1.num_sez),min(t1.num_sez),max(t1.num_sez) from ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons=$id_cons and t1.id_sede=t2.id_sede and t2.id_circ=$id_circ";
[318]	187	$res_sez = $dbi->prepare("$sql");
	188	$res_sez->execute();
[265]	189	//numero di sezioni nella circoscrizione
[318]	190	$sql="SELECT min(t1.num_sez) from ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons=$id_cons and t1.id_sede=t2.id_sede and t2.id_circ=$id_circ";
	191	$res_min = $dbi->prepare("$sql");
	192	$res_min->execute();
[265]	193	//setta minsez sulla prima sezione della circoscrizione
	194	list($minsez)=$res_min->fetch(PDO::FETCH_NUM);
	195	}
	196	elseif (strstr( $op,'circo')){
[318]	197	$sql="SELECT count(num_circ),min(num_circ),max(num_circ) from ".$prefix."_ele_circoscrizione where id_cons=$id_cons";
	198	$res_sez = $dbi->prepare("$sql");
	199	$res_sez->execute();
[265]	200	}
	201	else{
[318]	202	$sql="SELECT count(num_sez),min(num_sez),max(num_sez) from ".$prefix."_ele_sezioni where id_cons=$id_cons";
	203	$res_sez = $dbi->prepare("$sql");
	204	$res_sez->execute();
[265]	205	}
[318]	206	if($res_sez->rowCount()) list($tot_sez,$numsezmin,$numsezmax)=$res_sez->fetch(PDO::FETCH_NUM);
[337]	207	else {$tot_sez=0;$numsezmin=0;$numsezmax=0;}
[318]	208	$sql="SELECT count(num_sez) from ".$prefix."_ele_sezioni where id_cons=$id_cons";
	209	$res_sez = $dbi->prepare("$sql");
	210	$res_sez->execute();
[337]	211
[265]	212	list($tuttelesez)=$res_sez->fetch(PDO::FETCH_NUM);
	213
[254]	214	$num_sez=$tot_sez;//mysql_data_seek($res_sez,0);
	215	if ($circo) $offsetsez=$numsezmax; //$num_sez+$minsez-1;//setta offsetsez sull'ultima sezione della circoscrizione
	216
[265]	217	$visvot='';
[254]	218
[265]	219	if (!$csv) echo "<div><h5>$pagina</h5></div>";
	220	if (!$csv) echo "<div style=\" text-align:left; margin-left:20px;\">";
	221
	222	if(strstr( $op,'candidato')){
[254]	223	// $numliste=mysql_num_rows($res_lis);
[265]	224	$visvot="cand";
	225	if (!$csv){
[318]	226	$sql="SELECT id_lista, descrizione,num_lista from ".$prefix."_ele_lista where id_cons=$id_cons $condcirc order by num_lista";
	227	$res_lis = $dbi->prepare("$sql");
	228	$res_lis->execute();
[254]	229
[265]	230	//elenco delle liste per la scelta
	231	echo "<p>"._SCEGLI_LISTA.":
	232	<select name=\"id_lista\" class=\"modulo\" onChange=\"top.location.href=this.form.pag.value+this.form.id_lista.options[this.form.id_lista.selectedIndex].value;return false\">";
	233	while(list($id_rif,$descrizione,$num_lis) = $res_lis->fetch(PDO::FETCH_NUM)) {
	234	if (!$id_lista) $id_lista=$id_rif;
	235	$sel = ($id_rif == $id_lista) ? "selected=\"selected\"" : "";
	236	echo "<option value=\"$id_rif\" $sel>";
	237	for ($j=strlen($num_lis);$j<2;$j++) { echo "  ";}
	238	echo $num_lis.") ".$descrizione."</option>";
[254]	239	}
[265]	240	echo "</select></p>";
	241	}
[318]	242	$sql="SELECT count(t1.id_sez) from ".$prefix."_ele_voti_$tab as t1, ".$prefix."_ele_$tab as t2 where t2.id_lista=$id_lista and t1.id_cand=t2.id_cand group by t1.id_cand";
	243	$res_scr = $dbi->prepare("$sql");
	244	$res_scr->execute();
[254]	245
[318]	246	$sqlc="SELECT id_cand, concat(cognome,' ', nome), num_cand from ".$prefix."_ele_$tab where id_cons=$id_cons and id_lista=$id_lista order by num_cand";
	247	$res_cand = $dbi->prepare("$sqlc");
	248	$res_cand->execute();
[254]	249
[265]	250	if ($circo) $condcirc="and t5.id_circ=$id_circ";
	251
[318]	252	$sqlvoti="select $tab2, t1.num_cand, concat(t1.cognome,' ', t1.nome) as nome, sum(t2.voti),'','','','',''
[265]	253	from ".$prefix."_ele_candidati as t1, ".$prefix."_ele_voti_candidati as t2, "
	254	.$prefix."_ele_sezioni as t3, ".$prefix."_ele_sede as t4, ".$prefix."_ele_circoscrizione as t5
	255	where t1.id_lista=$id_lista
	256	and t1.id_cons=$id_cons
	257	and t1.id_cand=t2.id_cand
	258	and t2.id_sez=t3.id_sez
	259	and t3.id_sede=t4.id_sede
	260	and t4.id_circ=t5.id_circ $condcirc
[320]	261	group by t1.num_cand,$tab2, t1.cognome,t1.nome
[318]	262	order by $tab3,t1.num_cand";
	263	$res_voti = $dbi->prepare("$sqlvoti");
	264	$res_voti->execute();
[254]	265	}else{
	266	if (!$csv)
	267	echo "<input type=\"hidden\" name=\"id_lista\" value=\"\"></input>";
	268
[265]	269	// camera e senato nel 2006 aggiunte le somme della coalizione
	270	// divise per circo e sez. in quanto nella tabella del gruppo
	271	// all'atto dell'immsione non viene fatta la somma
	272	// quindi leggere prima i voti di lista e poi agganciali al gruppo
	273	// la var $tab diviene lista, $tab15 diviene gruppo in caso di somma
	274	// dei voti di lista...oltre naturalmnte alle condizioni messe in variabile
	275	// 4 aprile 2006 by luc
	276	if ($votog && $tab=="gruppo"){ // camera e senato 2006
	277	$t="t9";
	278	$tab="lista";
	279	$tab15="gruppo";
	280	$add_1= ",".$prefix."_ele_gruppo as t9";
	281	$and_1="and t1.id_gruppo=t9.id_gruppo";
	282	}else{
	283	$t="t1";
	284	$tab15=$tab;
	285	$add_1='';
	286	$and_1='';
	287	}
	288	// fine della modifica
	289
[318]	290	$sql="SELECT count(id_sez) from ".$prefix."_ele_voti_$tab15 where id_cons='$id_cons' group by id_$tab15";
	291	$res_scr = $dbi->prepare("$sql");
	292	$res_scr->execute();
[265]	293	//numero sezioni scrutinate
[318]	294	$sqlc="SELECT id_$tab15, descrizione, num_$tab15 from ".$prefix."_ele_$tab15 where id_cons='$id_cons' $condcirc order by num_$tab15";
	295	$res_cand = $dbi->prepare("$sqlc");
	296	$res_cand->execute();
[254]	297
[265]	298	if ($circo) $condcirc="and t5.id_circ=$id_circ";
[346]	299	if ($tab=="gruppo" or $genere==4 or ($genere==5 and $votog))
[265]	300	$votigl=" sum(t3.validi),sum(t3.nulli),sum(t3.bianchi),sum(t3.contestati),sum(t3.voti_nulli)";
	301	else
	302	if ($votog) $votigl=" (t3.validi_lista),(t3.nulli),(t3.bianchi),(t3.contestati),(t3.voti_nulli)";
	303	else $votigl=" sum(t3.validi_lista),sum(t3.nulli),sum(t3.bianchi),sum(t3.contestati_lista),sum(t3.voti_nulli_lista+t3.voti_nulli)";
	304	$sqlvoti="select $tab2, $t.num_$tab15, $t.descrizione, sum(t2.voti), $votigl
	305	from
	306	".$prefix."_ele_$tab as t1,
	307	".$prefix."_ele_voti_$tab as t2,
	308	".$prefix."_ele_sezioni as t3,
	309	".$prefix."_ele_sede as t4,
	310	".$prefix."_ele_circoscrizione as t5
	311	$add_1
	312
	313	where t1.id_cons=$id_cons
	314	and t1.id_$tab=t2.id_$tab
	315	$and_1
	316
	317	and t2.id_sez=t3.id_sez
	318	and t3.id_sede=t4.id_sede
	319	and t4.id_circ=t5.id_circ $condcirc
	320
	321
[318]	322	group by $t.num_$tab15,$tab3,$tab2, $t.descrizione
	323	order by $tab3,$t.num_$tab15";
	324	$res_voti = $dbi->prepare("$sqlvoti");
	325	$res_voti->execute();
[265]	326	}
	327	if ($res_scr) list($tot_scr)=$res_scr->fetch(PDO::FETCH_NUM);else $tot_scr=0;
	328	if ($res_cand) $num_cand=$res_cand->rowCount(); else $num_cand=0;
	329	if(!$circo){
	330	if (!(0 < $minsez and $minsez<=$numsezmax)) $minsez=1;
	331	if (!(0<$offsetsez and $offsetsez<=$numsezmax)) $offsetsez=$numsezmax;
	332	}
	333	if (!(0 < $min and $min<=$num_cand)) $min=1;
	334	if (!(0<$offset and $offset<=$num_cand)) $offset=$num_cand;
	335	if (!$csv) {
	336	if(strstr( $op,'lista')){$scelta=_SCEGLI_LISTA;}else{$scelta=_SCEGLI_CANDI;}
	337	echo "<p>$scelta "._DA.":  <select name=\"min\" class=\"modulo\">";
	338	while(list($id_rif,$descrizione,$num_lis) = $res_cand->fetch(PDO::FETCH_NUM)) {
	339	if (!$min) $min=$num_lis;
	340	$sel = ($num_lis == $min) ? "selected=\"selected\"" : "";
	341	echo "<option value=\"$num_lis\" $sel>";
	342	for ($j=strlen($num_lis);$j<2;$j++) { echo "  ";}
	343	echo $num_lis.") ".$descrizione."</option>";
	344	}
	345	echo "</select>";
	346	echo "  "._A.":  <select name=\"offset\" class=\"modulo\">";
	347	$res_cand = $dbi->prepare("$sqlc");
	348	$res_cand->execute();
[254]	349
[265]	350	while(list($id_rif,$descrizione,$num_lis) = $res_cand->fetch(PDO::FETCH_NUM)) {
	351	if (!$offset) $offset=$num_lis;
	352	$sel = ($num_lis == $offset) ? "selected=\"selected\"" : "";
	353	echo "<option value=\"$num_lis\" $sel>";
	354	for ($j=strlen($num_lis);$j<2;$j++) { echo "  ";}
	355	echo $num_lis.") ".$descrizione."</option>";
[254]	356
	357	}
[265]	358	echo "</select></p>";
	359	//echo "<div style=\"text-align:left; margin-left:20px;\">";
	360	if(!$circo){
[254]	361	echo "<p>"._SCEGLI." $tipo1 n. <input name=\"minsez\" value=\"$minsez\" size=\"4\" ></input>";
	362	echo _A." n. <input name=\"offsetsez\" value=\"$offsetsez\" size=\"4\" ></input> (max. $numsezmax)";
[265]	363	}
	364	# pagine
[254]	365	############
[337]	366	if(!$offsetsez) $offsetsez=0;
[265]	367	if (strstr( $op,'circo'))
[318]	368	$sql="SELECT count(num_circ) from ".$prefix."_ele_circoscrizione where id_cons=$id_cons and num_circ>=$minsez and num_circ<=$offsetsez";
[265]	369
[318]	370
[265]	371	else
[318]	372	$sql="SELECT count(num_sez) from ".$prefix."_ele_sezioni where id_cons=$id_cons and num_sez>=$minsez and num_sez<=$offsetsez";
[265]	373	$resnsez = $dbi->prepare("$sql");
	374	$resnsez->execute();
	375	list($diff)=$resnsez->fetch(PDO::FETCH_NUM);
	376	########
[254]	377	# $diff=($offsetsez-$minsez);
[338]	378	if ($minsez>1 and !$circo){
[265]	379	$minsez_p= ($minsez-$diff)>1 ? $minsez-$diff:1;
	380	$offsetsez_p=$offsetsez-$diff;
	381	echo "<div style=\"float: right; width:200px;margin-left:10px;margin-right:400px;font-size:12px \"><a href=\"modules.php?name=Elezioni&file=index&id_cons_gen=$id_cons_gen&id_comune=$id_comune&op=$op&min=$min&offset=$offset&minsez=$minsez_p&offsetsez=$offsetsez_p&perc=$perc&id_lista=$id_lista\"> <- $tipo2 Precedenti</a></div>";
	382	}else{echo "";}
	383	if ($offsetsez<$numsezmax){
	384	$minsez_s=$minsez+$diff;
	385	$offsetsez_s= ($offsetsez+$diff)>$num_sez ? $num_sez: $offsetsez+$diff;
	386	echo "<div style=\"float: left; width:200px; margin-left:10px;\"><a href=\"modules.php?name=Elezioni&file=index&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&orvert=$orvert&min=$min&offset=$offset&minsez=$minsez_s&offsetsez=$offsetsez_s&perc=$perc&id_lista=$id_lista\"> $tipo2 Successive -></a></div>";
	387	}else{echo "";}
	388	if(!$circo)
[254]	389	echo "<div style=\"margin-left:10px;\"><br/>"._MOSTRA." $tipo2 "._PERCOL."<input type=\"radio\" name=\"orvert\" $righe value=\"0\"></input>"._PERRIGHE." <input
	390	type=\"radio\" name=\"orvert\" $colonne value=\"1\"></input>";
[265]	391	echo "<input type=\"hidden\" name=\"name\" value=\"Elezioni\"></input></div>";
	392	echo "<p>";
	393	if (!strstr( $op,'candidato')) {
	394	echo ""._VIS_PERC.": <input type=\"checkbox\" name=\"perc\" value=\"true\"";
	395	if($perc=='true') echo " checked=\"true\"";
	396	echo "></input><br/>";
	397	}
	398	echo "";
[254]	399	if($circo)
	400	echo "<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\"></input>";
	401	echo "<input type=\"hidden\" name=\"op\" value=\"$op\"></input>";
	402	echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\"></input>";
	403	echo "<input type=\"hidden\" name=\"id_comune\" value=\"$id_comune\"></input>";
	404
	405	echo "<input type=\"hidden\" name=\"pag2\" value=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&orvert=$orvert&min=$min&offset=$offset&minsez=$minsez&offsetsez=$offsetsez&perc=$perc&id_lista=\"></input>";
	406
	407	echo " <input type=\"submit\" name=\"update\" value=\""._RICARICA."\"></input></p></div></form>";
	408
	409
	410	#### recupera dati stampa supporti diversi dati
	411	//echo "</tr><tr><td><b>"._COMUNE." $descr_comune</b> - "._RISULTATI.": $descr_cons <br/>";
	412	//echo "tot:$tot_scr";
	413	//if ($tipo_cons!=4 && $tot_scr) echo " - Sezioni scrutinate: $tot_scr su $tuttelez";
	414
	415	# liste e gruppi da.... a
	416	if (!strstr( $op,'candidato')) {
[318]	417	$sql="SELECT descrizione from ".$prefix."_ele_$tab15 where id_cons='$id_cons' and num_$tab15 ='$min'";
	418	$res_cand2 = $dbi->prepare("$sql");
	419	$res_cand2->execute();
[265]	420
	421	list($descrizione)= $res_cand2->fetch(PDO::FETCH_NUM);
[254]	422	$list1 ="da $descrizione ";
	423
	424
	425
[318]	426	$sql="SELECT descrizione from ".$prefix."_ele_$tab15 where id_cons='$id_cons' and num_$tab15 ='$offset'";
	427	$res_cand3 = $dbi->prepare("$sql");
	428	$res_cand3->execute();
[265]	429
	430	list($descrizione)= $res_cand3->fetch(PDO::FETCH_NUM);
[254]	431	$list1 .=" a $descrizione <br/>";
	432
	433	}else{$list1='';}
	434
	435	# nome della lista
	436	if (!isset($list2)) $list2='';
	437	if (strstr( $op,'candidato')) {
[318]	438	$sql="SELECT num_lista, descrizione from ".$prefix."_ele_lista where id_lista=$id_lista";
	439	$res_lis2 = $dbi->prepare("$sql");
	440	$res_lis2->execute();
[265]	441
	442	list($num_lista2,$descr_lista2)= $res_lis2->fetch(PDO::FETCH_NUM);
[254]	443	$nomefile=" Lista n. $num_lista2 - $descr_lista2 ";
	444	$list2 .=" Lista n. $num_lista2 - $descr_lista2 <br/>";
	445
[318]	446	$sql="SELECT concat(cognome,' ', nome) from ".$prefix."_ele_$tab where id_cons=$id_cons and id_lista=$id_lista and num_cand=$min";
	447	$res_cand4 = $dbi->prepare("$sql");
	448	$res_cand4->execute();
[265]	449
	450	list($descrizione)= $res_cand4->fetch(PDO::FETCH_NUM);
[254]	451	$list3 ="da $descrizione ";
[318]	452	$sql="SELECT concat(cognome,' ', nome) from ".$prefix."_ele_$tab where id_cons=$id_cons and id_lista=$id_lista and num_cand=$offset";
	453	$res_cand5 = $dbi->prepare("$sql");
	454	$res_cand5->execute();
[265]	455
	456	list($descrizione)= $res_cand5->fetch(PDO::FETCH_NUM);
[254]	457	$list3 .="a $descrizione <br/>";
	458
	459	}else{ $list2 .='';$list3='';}
	460	if(!isset($tab15)) $tab15='';
	461	$nomefile.="$descr_cons $tab15";
	462	$_SESSION['nomefile']=strip_tags(str_replace(" ", "_", $nomefile));
[265]	463	$datipdf="<b>"._COMUNE." $descr_comune</b> - "._RISULTATI.": $descr_cons<br/><b>$pagina</b><br/><br/> $list1 $list2 $list3 ";
	464	# verificare la stampa sulle circoscrizioni
[338]	465	echo "<div style=\"text-align:right;width:40%;margin-left:10px;margin-right:0px;font-size:12px; \">";
[265]	466	echo "<table style=\"text-align:center;margin-right:0px;border-top : 1px solid Blue;width: 140px;\"><tr style=\" background:#eceff5;\"><td>"._ESPORTA."<br />";
	467	if($circo){ echo "<a href=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&orvert=$orvert&min=$min&offset=$offset&minsez=$minsez&offsetsez=$offsetsez&perc=$perc&id_lista=$id_lista&id_circ=$id_circ&datipdf=$datipdf\" ><img class=\"image\" src=\"modules/Elezioni/images/printer.gif\" alt=\"Stampa\" /></a>";
[254]	468	}else{
[265]	469	echo "<a href=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&orvert=$orvert&min=$min&offset=$offset&minsez=$minsez&offsetsez=$offsetsez&perc=$perc&id_lista=$id_lista&datipdf=$datipdf\" ><img class=\"image\" src=\"modules/Elezioni/images/printer.gif\" alt=\"Stampa\" /></a>";
	470	echo "<a href=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&orvert=$orvert&min=$min&offset=$offset&minsez=$minsez&offsetsez=$offsetsez&perc=$perc&id_lista=$id_lista&xls=1&datipdf=$datipdf\" ><img class=\"image\" src=\"modules/Elezioni/images/csv.gif\" alt=\"Export Csv\" /></a>";
	471	echo "<img class=\"image\" src=\"modules/Elezioni/images/rss.png\" alt=\"Export rss\" />";
	472	echo " </td></tr> ";
	473	# stampa pdf
	474	echo "<form id=\"pdf\" method=\"post\" action=\"modules.php\">";
	475	echo "<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\"></input>";
	476	echo "<input type=\"hidden\" name=\"op\" value=\"$op\"></input>";
	477	echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\"></input>";
	478	echo "<input type=\"hidden\" name=\"id_comune\" value=\"$id_comune\"></input>";
	479	echo "<input type=\"hidden\" name=\"csv\" value=\"1\"></input>";
	480	echo "<input type=\"hidden\" name=\"orvert\" value=\"$orvert\"></input>";
	481	echo "<input type=\"hidden\" name=\"min\" value=\"$min\"></input>";
[254]	482	echo "<input type=\"hidden\" name=\"offset\" value=\"$offset\"></input>";
[265]	483	echo "<input type=\"hidden\" name=\"minsez\" value=\"$minsez\"></input>";
	484	echo "<input type=\"hidden\" name=\"offsetsez\" value=\"$offsetsez\"></input>";
	485	echo "<input type=\"hidden\" name=\"perc\" value=\"$perc\"></input>";
	486	echo "<input type=\"hidden\" name=\"id_lista\" value=\"$id_lista\"></input>";
	487	echo "<input type=\"hidden\" name=\"pdf\" value=\"1\"></input>";
	488	echo "<input type=\"hidden\" name=\"datipdf\" value=\"$datipdf\"></input>";
	489	# echo "<input type=\"hidden\" name=\"name\" value=\"$elezioni\"></input>";
	490	echo "<input type=\"hidden\" name=\"name\" value=\"Elezioni\"></input>";
	491	echo "<tr><td>";
	492	echo "<input type=\"image\" name=\"submit\" src=\"modules/Elezioni/images/pdf.gif\" align=\"left\">";
	493	echo "  L  <input type=\"radio\" name=\"orienta\" $land value=\"L\"></input>P  <input
	494	type=\"radio\" name=\"orienta\" $port value=\"P\"></input><br />";
	495	echo "  A3<input type=\"radio\" name=\"formato\" $A3 value=\"A3\"></input>A4<input
	496	type=\"radio\" name=\"formato\" $A4 value=\"A4\"></input>";
	497	echo " </td></tr></table></form> ";
[254]	498	}
	499	echo "</div></br />";
[265]	500	}
[254]	501	if (!$csv){
	502	echo "<h5> Sezioni scrutinate";
	503	if ($tipo_cons!=4) echo ": $tot_scr su $tuttelesez     ";
	504	echo "</h5> ";
	505	}
	506	$y=1;
	507	$ar[0][0]=$tipo3;
	508	$ra[0][0]=$tipo3;
	509	$num_sez++;
	510	$voticompl=0;
	511	$ominsez=$minsez-1;
	512	$valar=array();$percar=array();
	513	////////////////////////////////////////////////////////////////////
	514	// sandro: carica i numeri di sezione dal DB - giugno 2009
	515	// caso: sezioni in collegi diversi non consecutive
	516	if (strstr( $op,'circo'))
[318]	517	$sql="select num_circ,id_circ from ".$prefix."_ele_circoscrizione where id_cons='$id_cons' and num_circ>='$minsez' and num_circ<='$offsetsez' order by num_circ";
[254]	518	else{
	519	if($circo) { $secirco=" and t2.id_circ=$id_circ";} else $secirco="and t1.num_sez >= $minsez and t1.num_sez <= $offsetsez";
	520	$numsezioni = $offsetsez-$ominsez;
[318]	521	$sql="SELECT t1.num_sez,t1.id_sez from ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons=$id_cons and t1.id_sede=t2.id_sede $secirco order by t1.num_sez";
[254]	522	}
[265]	523	$res_numsez = $dbi->prepare("$sql");
[344]	524	$res_numsez->execute();
[318]	525	$sevaltot=0;
	526	$senultot=0;
	527	$sebiatot=0;
	528	$secontot=0;
	529	$sevnutot=0;
[337]	530	while($res=$res_numsez->fetch(PDO::FETCH_NUM)) {
[265]	531	$z=$res[0];
[254]	532	##############inserimento percentuale di scrutinio nella sezione
[265]	533	$scruvalidi=0;
	534	$scrunulli=0;
	535	$grpercscru=0;
	536	$altri=0;
	537	$votiscru=0;
	538	if($op=="gruppo_sezione"){
	539	$sqlr="select sum(validi),sum(solo_lista) from ".$prefix."_ele_sezioni where id_sez='".$res[1]."'";
	540	$sqlv="select sum(voti) from ".$prefix."_ele_voti_gruppo where id_sez='".$res[1]."'";
	541	$resperc = $dbi->prepare("$sqlr");
	542	$resperc->execute();
	543	$votiperc = $dbi->prepare("$sqlv");
	544	$votiperc->execute();
	545	}
	546	elseif($op=="lista_sezione"){
[318]	547	$sqlr="select sum(validi),sum(contestati_lista+solo_gruppo+voti_nulli_lista) from ".$prefix."_ele_sezioni where id_sez='".$res[1]."'";
	548	$sqlv="select sum(voti) from ".$prefix."_ele_voti_lista where id_sez='".$res[1]."'";
[265]	549	$resperc = $dbi->prepare("$sqlr");
	550	$resperc->execute();
	551	$votiperc = $dbi->prepare("$sqlv");
	552	$votiperc->execute();
	553	}
	554	if (isset($resperc) and $resperc)
	555	list($scruvalidi,$scrunulli)=$resperc->fetch(PDO::FETCH_NUM);
	556	if (isset($votiperc) and $votiperc)
	557	list($votiscru)=$votiperc->fetch(PDO::FETCH_NUM);
[318]	558	$sql="select sum(voti_complessivi) from ".$prefix."_ele_voti_parziale where id_sez='".$res[1]."' group by data,orario order by data desc, orario desc limit 0,1 ";
	559	$resperc = $dbi->prepare("$sql");
	560	$resperc->execute();
[254]	561
[265]	562	if ($resperc)
	563	list($totschede)=$resperc->fetch(PDO::FETCH_NUM);
	564	if (isset($scruvalidi) and $scruvalidi>0 )
	565	$grpercscru=$votiscru ? number_format(($votiscru+$scrunulli)*100/$scruvalidi,0) : 0;
	566
[254]	567	################### <span class=\"red\"><i>".$temp3[$key]." %</i></span>
[265]	568	$ar[$z][0]=$res[0]; if($grpercscru) {$ar[$z][0].="<br /><span class=\"red\"><i>$grpercscru%</i></span>";if(!strstr($ar[0][0],'scrutinio')) $ar[0][0].="<br /><span class=\"red\"><i>% scrutinio</i></span>"; }
	569	$pos[$z]=$res[0];
	570	#$valar[$z]=array();
	571	}
[254]	572	if (!isset($pos)) $pos[0]=0;
	573	$minpos=min($pos);
	574	$maxpos=max($pos);
	575	////////////////////////////////////////////////////////////////////
[318]	576
[265]	577	if ($res_voti->rowCount())
	578	while (list($num_circ,$desc_circ,$num_cand,$nome,$voti,$sevalidi,$senulli,$sebianchi,$secontestati,$sevonulli) = $res_voti->fetch(PDO::FETCH_NUM)){
[318]	579	# if($genere==4) $sevalidi=$voti;
[265]	580	$z=array_search($num_circ, $pos);
[254]	581	if (!isset($votitot[($z)])) {
[265]	582	$votitot[($z)]=0;
	583	if($sevalidi) $sevaltot+=$sevalidi;
	584	if($senulli) $senultot+=$senulli;
	585	if($sebianchi) $sebiatot+=$sebianchi;
	586	if($secontestati) $secontot+=$secontestati;
	587	if($sevonulli) $sevnutot+=$sevonulli;
[254]	588	}
	589	$votitot[($z)]+=$voti;
[318]	590	if(!isset($valsez[$z])) $valsez[$z]=0;
	591	$valsez[$z]=$sevalidi;
[254]	592	$voticompl+=$voti;
	593	}
[265]	594	if ($voticompl) {
	595	$res_voti = $dbi->prepare("$sqlvoti");
	596	$res_voti->execute();
	597	}
[254]	598	$piuvot=0;
	599	if ($visvot!='cand') $piuvot=5;
[265]	600	for ($y=$min;$y<=($offset+$piuvot);$y++) $ar[0][$y]=" ";
	601	if (strstr( $op,'circo'))
[318]	602	$sql="select num_circ from ".$prefix."_ele_circoscrizione where id_cons='$id_cons' and num_circ>='$minsez' and num_circ<='$offsetsez' order by num_circ";
[265]	603	else
[318]	604	$sql="select num_sez from ".$prefix."_ele_sezioni where id_cons='$id_cons' and num_sez>='$minsez' and num_sez<='$offsetsez' order by num_sez";
[265]	605	$lis_sez = $dbi->prepare("$sql");
	606	$lis_sez->execute();
	607	$nsezsel=$lis_sez->rowCount();
	608	while(list($z)=$lis_sez->fetch(PDO::FETCH_NUM))
	609	{
	610	for ($y=$min;$y<=($offset+$piuvot);$y++) $ar[$z][$y]=" ";} //inizializza le celle interne
[254]	611
	612	###################################################################
	613	# for ($y=$min;$y<=($offset+$piuvot);$y++) $ar[0][$y]=" ";
	614	# for ($z=1;$z<=($offsetsez-$ominsez);$z++)
	615	# for ($y=$min;$y<=($offset+$piuvot);$y++) $ar[$z][$y]=" "; //inizializza le celle interne
[265]	616	$onetime="";
	617	if ($res_voti)
	618	{
	619	while (list($num_circ,$desc_circ,$num_cand,$nome,$voti,$sevalidi,$senulli,$sebianchi,$secontestati,$sevonulli) = $res_voti->fetch(PDO::FETCH_NUM)){
[254]	620	$z=array_search($num_circ, $pos);
[265]	621	$valar[($z)][$num_cand]=$voti;
[254]	622	}
[318]	623
[254]	624	foreach ($valar as $key=>$val){
	625	if(isset($votitot[($key)]))
	626	$percar[$key]=arrayperc($val,$votitot[($key)]);
[318]	627
	628	}
	629	# if($res_voti->rowCount()) {
	630	$res_voti = $dbi->prepare("$sqlvoti");
	631	$res_voti->execute();
	632	#}
	633
[265]	634	while (list($num_circ,$desc_circ,$num_cand,$nome,$voti,$sevalidi,$senulli,$sebianchi,$secontestati,$sevonulli) = $res_voti->fetch(PDO::FETCH_NUM)){
	635	if($num_cand<$min or $num_cand>$offset) continue;
[318]	636	if($genere==4) $sevalidi=$voti;
	637
[265]	638	if (!isset($temp[$num_cand])) $temp[$num_cand]=0;
	639	$temp[$num_cand]+=$voti;
	640	$z=array_search($num_circ, $pos);
	641	if (!$z) continue;
	642	if ($num_cand>=$min and $num_cand<=$offset){
	643	if($num_circ>=$minpos and $num_circ <=$maxpos){
	644	$ar[0][$num_cand]=$num_cand.") ".$nome;
	645	if ($desc_circ && $onetime!=$desc_circ) {$ar[($z)][0].=") ".$desc_circ; $onetime=$desc_circ;}
	646	$percento=$voti;
	647	if ($perc=='true' and $votitot[($z)])
	648	{
	649	$percento=$voti."<br /><span class=\"red\" style=\"font-size:80%;\"><i>".number_format($percar[$z][$num_cand],2)." %</i></span>";
	650	}
[318]	651
[265]	652	$ar[($z)][$num_cand]=$percento;
	653	}
[254]	654	}
[265]	655	if (!strstr( $op,'candidato')){
	656	if (!isset($tempar[$num_cand])) $tempar[$num_cand]=0;
	657	$tempar[$num_cand]+=$voti;
	658	}
	659	if ($visvot!='cand'){
	660	$posvoti=($offset);
	661	$ar[0][$posvoti+1]='<b>Voti Validi</b>';
	662	$ar[0][$posvoti+2]='<b>Schede Nulle</b>';
	663	$ar[0][$posvoti+3]='<b>Schede Bianche</b>';
	664	$ar[0][$posvoti+4]='<b>Voti Contestati</b>';
	665	$ar[0][$posvoti+5]='<b>Voti Nulli</b>';
	666	if (($maxpos)>=$num_circ and $minpos<=$num_circ){
	667	//$posvoti++;
[318]	668	$ar[($z)][$posvoti+1]="<b>$valsez[$z]</b>";
[265]	669	$ar[($z)][$posvoti+2]="<b>$senulli</b>";
	670	$ar[($z)][$posvoti+3]="<b>$sebianchi</b>";
	671	$ar[($z)][$posvoti+4]="<b>$secontestati</b>";
	672	$ar[($z)][$posvoti+5]="<b>$sevonulli</b>";
	673	}
	674	}
[254]	675	}
	676	}
	677
[265]	678	if (($offsetsez+1)>=$num_sez){
	679	$ar[(1+$numsezmax)][0]="<b>"._TOT."<br />"._COMPLESSIVO."</b>";
	680	if(isset($temp)) {
	681	if (!isset($tab15) or !$tab15) $tab15="candidati";
[318]	682	if($tab15=="gruppo" or $genere==4){
[344]	683	if($votog) $tab15="lista";
	684	$votigl=" sum(validi),sum(nulli),sum(bianchi),sum(contestati),sum(voti_nulli)";
[265]	685	}elseif($votog){
[318]	686	$votigl=" sum(validi),sum(nulli),sum(bianchi),sum(contestati),sum(voti_nulli)";
[265]	687	}else{
[319]	688	if($dettnulli) $votigl=" sum(validi_lista),sum(nulli),sum(bianchi),sum(contestati_lista),sum(voti_nulli_lista+voti_nulli)";
[265]	689	else $votigl=" sum(validi_lista),sum(nulli),sum(bianchi),sum(contestati_lista),sum(voti_nulli)";
	690	}
[254]	691	if($circo)
[318]	692	$sql="SELECT $votigl from ".$prefix."_ele_sezioni AS t1 LEFT JOIN soraldo_ele_sede AS t2 ON t1.id_sede = t2.id_sede WHERE t1.id_cons='$id_cons' and t2.id_circ=$id_circ";
[254]	693	else
[318]	694	$sql="SELECT $votigl from ".$prefix."_ele_sezioni as t1 where t1.id_cons='$id_cons' and t1.id_sez=(select t2.id_sez from ".$prefix."_ele_voti_$tab15 as t2 where t2.id_sez=t1.id_sez group by t2.id_sez)";
[265]	695	$resv = $dbi->prepare("$sql");
[318]	696	$resv->execute();
[265]	697	list ($sevaltot,$senultot,$sebiatot,$secontot,$sevnutot)= $resv->fetch(PDO::FETCH_NUM);
[254]	698	$voticompl=$sevaltot+$senultot+$sebiatot+$secontot+$sevnutot;
[318]	699	$sql="SELECT voti from ".$prefix."_ele_voti_$tab15 where id_cons='$id_cons'";
	700	$resvt = $dbi->prepare("$sql");
[265]	701	$resvt->execute();
	702	if($resvt) list($votlt)=$resvt->fetch(PDO::FETCH_NUM); else $votlt=0;
[254]	703	if($perc) $temp3=arrayperc($temp,$sevaltot);
[344]	704
	705	foreach($temp as $key=>$voti) {
[254]	706	if ($perc=='true' and $voticompl)
	707	{
	708	$percento="<b>$voti<br /><span class=\"red\"><i>".$temp3[$key]." %</i></span></b>";
	709	} else
	710	$percento="<b>$voti</b>";
	711	$ar[1+$numsezmax][$key]=$percento;
	712	}
	713	}
	714	if ($visvot!='cand') {
	715	$key=$offset+1;
	716	$tmp=array($sevaltot,$senultot,$sebiatot,$secontot,$sevnutot);
	717	if($perc) $temp3=arrayperc($tmp,$voticompl);
[344]	718
	719	foreach($tmp as $k=>$voti) {
[254]	720	if ($perc=='true' and $voticompl)
	721	{
	722	$percento="<b>$voti<br /><span class=\"red\"><i>".$temp3[$k]." %</i></span></b>";
	723	} else $percento="<b>$voti</b>";
	724	$ar[1+$numsezmax][++$key]=$percento;
	725
	726	}
	727	}
	728	}
	729	if($orvert!=1) {
	730	$i=0;
	731	foreach ( $ar as $riga) {
	732	$y=0;
	733	foreach($riga as $cella) {
	734	$ra[$y++][$i]=$cella;
	735	}
	736	$i++;
	737	}
	738	crea_tabella($ra);
	739	}else{
	740	crea_tabella($ar);
	741	}
	742	//e' un referendum
	743	}else{
[318]	744	$sql="SELECT id_gruppo, descrizione,num_gruppo from ".$prefix."_ele_gruppo where id_cons=$id_cons order by num_gruppo";
	745	$res_lis = $dbi->prepare("$sql");
	746	$res_lis->execute();
[254]	747
[265]	748	if($res_lis) $numliste=$res_lis->rowCount(); else $numliste=0;
	749
[254]	750	if (!isset($offset)) $offset=10;
	751	if (!isset($min)) $min=1;
	752	if (!isset($offsetsez)) $offsetsez=25; //lo 0 viene sostituito dal totale di sezioni presenti
	753	if (!isset($minsez)) $minsez=1;
	754	if (!$csv){
	755	echo "<div><h5>$pagina</h5></div>";
	756	echo "<form id=\"voti\" method=\"post\" action=\"modules.php\">";
	757	echo "<div style=\"text-align:left;width:700px;margin:auto;font-size:12px \">
	758	<input type=\"hidden\" name=\"name\" value=\"Elezioni\"></input>";
	759	echo "<input type=\"hidden\" name=\"op\" value=\"$op\"></input>";
	760	echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\"></input>";
	761	echo "<input type=\"hidden\" name=\"id_comune\" value=\"$id_comune\"></input>";
	762	echo ""._SCELTA." "._CONSULTAZIONE.": <select name=\"id_gruppo\">";
	763	if($res_lis)
[265]	764	while(list($id_rif,$descrizione,$num_lis) = $res_lis->fetch(PDO::FETCH_NUM)) {
[254]	765	if (!$id_gruppo) $id_gruppo=$id_rif;
	766	$sel = ($id_rif == $id_gruppo) ? "selected=\"selected\"" : "";
	767	echo "<option value=\"$id_rif\" $sel>";
	768	for ($j=strlen($num_lis);$j<2;$j++) { echo "  ";}
	769	echo $num_lis.") ".strip_tags(substr($descrizione,0,50))."</option>";
	770	}
	771	echo "</select>";
	772	echo "<br />"._VIS_PERC.": <input type=\"checkbox\" name=\"perc\" value=\"true\"";
	773	if($perc=='true') echo " checked=\"true\"";
	774	echo ">";
	775	echo "<br /><input type=\"submit\" name=\"update\" value=\""._RICARICA."\"></form></div>";
	776
	777
	778
	779	}
	780
[318]	781	$sql="select num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id_gruppo";
	782	$res_ref = $dbi->prepare("$sql");
	783	$res_ref ->execute();
[265]	784
	785	$sql="select $tab2, t1.num_gruppo, t1.descrizione , t1.simbolo,
[254]	786	sum(t2.si), sum(t2.no),sum(t2.validi), sum(t2.nulli),sum(t2.bianchi), sum(t2.contestati)
	787	from ".$prefix."_ele_gruppo as t1
	788	left join ".$prefix."_ele_voti_ref as t2 on (t1.id_gruppo=t2.id_gruppo)
	789	left join ".$prefix."_ele_sezioni as t3 on (t2.id_sez=t3.id_sez)
	790	left join ".$prefix."_ele_sede as t4 on (t3.id_sede=t4.id_sede)
	791	left join ".$prefix."_ele_circoscrizione as t5 on (t4.id_circ=t5.id_circ)
	792	where t1.id_cons='$id_cons' and t1.id_gruppo=$id_gruppo
[320]	793	group by t2.id_gruppo,$tab2, t1.num_gruppo, t1.descrizione , t1.simbolo
[254]	794	order by $tab3, t1.num_gruppo
[318]	795	";
	796	$res = $dbi->prepare("$sql");
	797	$res->execute();
[265]	798
	799	if($res) $num_sez=$res->rowCount(); else $num_sez=0;
	800	if($res_ref) list($num_gruppo,$descr)= $res_ref->fetch(PDO::FETCH_NUM); else {$num_gruppo=0;$descr='';}
[254]	801
	802	if (!$csv){
	803	# stampa
	804
	805	$datipdf="<b>"._COMUNE." $descr_comune</b> - "._RISULTATI.": $descr_cons<br/><b>$pagina</b><br/><br/> ";
	806	$datipdf .="<br/><b>Referendum n. ".$num_gruppo." </b><br/>".$descr."";
	807	echo "<div style=\"text-align:right;width:900px;margin-left:10px;margin-right:20px;font-size:12px \">";
	808	echo "<table style=\"text-align:center;margin-right:0px;border-top : 1px solid Blue;width: 140px;\"><tr style=\" background:#eceff5;\"><td>"._ESPORTA."<br />";
	809
	810	echo "<a href=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&perc=$perc&id_gruppo=$id_gruppo&datipdf=$datipdf\" ><img class=\"image\" src=\"modules/Elezioni/images/printer.gif\" alt=\"Stampa\" /></a>";
	811	echo "<a href=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&perc=$perc&id_gruppo=$id_gruppo&xls=1&datipdf=$datipdf\" ><img class=\"image\" src=\"modules/Elezioni/images/csv.gif\" alt=\"Export Csv\" /></a>";
	812
	813	//echo "<a href=\"modules.php?name=Elezioni&op=$op&id_cons_gen=$id_cons_gen&id_comune=$id_comune&csv=1&perc=$perc&id_gruppo=$id_gruppo&pdf=1&datipdf=$datipdf\" ><img class=\"image\" src=\"modules/Elezioni/images/pdf.gif\" alt=\"Export Pdf\" /></a>";
	814
	815
	816	echo "<img class=\"image\" src=\"modules/Elezioni/images/rss.png\" alt=\"Export rss\" />";
	817
	818	echo " </td></tr>";
	819
	820
	821	echo "<form id=\"pdf\" method=\"post\" action=\"modules.php\">";
	822
	823	echo "<input type=\"hidden\" name=\"id_circ\" value=\"$id_circ\"></input>";
	824	echo "<input type=\"hidden\" name=\"op\" value=\"$op\"></input>";
	825	echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\"></input>";
	826	echo "<input type=\"hidden\" name=\"id_comune\" value=\"$id_comune\"></input>";
	827	echo "<input type=\"hidden\" name=\"csv\" value=\"1\"></input>";
	828	echo "<input type=\"hidden\" name=\"orvert\" value=\"$orvert\"></input>";
	829	echo "<input type=\"hidden\" name=\"min\" value=\"$min\"></input>";
	830	echo "<input type=\"hidden\" name=\"offset\" value=\"$offset\"></input>";
	831	echo "<input type=\"hidden\" name=\"minsez\" value=\"$minsez\"></input>";
	832	echo "<input type=\"hidden\" name=\"offsetsez\" value=\"$offsetsez\"></input>";
	833	echo "<input type=\"hidden\" name=\"perc\" value=\"$perc\"></input>";
	834	echo "<input type=\"hidden\" name=\"id_gruppo\" value=\"$id_gruppo\"></input>";
	835	echo "<input type=\"hidden\" name=\"pdf\" value=\"1\"></input>";
	836	echo "<input type=\"hidden\" name=\"datipdf\" value=\"$datipdf\"></input>";
	837	echo "<input type=\"hidden\" name=\"name\" value=\"Elezioni\"></input>";
	838
	839	echo "<tr><td>";
	840	echo "<input type=\"image\" name=\"submit\" src=\"modules/Elezioni/images/pdf.gif\" align=\"left\">";
	841	echo "  L  <input type=\"radio\" name=\"orienta\" $land value=\"L\"></input>P  <input
	842	type=\"radio\" name=\"orienta\" $port value=\"P\"></input><br />";
	843	echo "  A3<input type=\"radio\" name=\"formato\" $A3 value=\"A3\"></input>A4<input
	844	type=\"radio\" name=\"formato\" $A4 value=\"A4\"></input>";
	845
	846
	847	echo " </td></tr></table></form> ";
	848
	849
	850
	851
	852
	853
	854
	855
	856
	857	echo "</div>";
	858
	859
	860	// numero sezioni scrutinate
[320]	861	$sql="select t3.id_sez from ".$prefix."_ele_voti_ref 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' group by t3.id_sez ";
[318]	862	$res4 = $dbi->prepare("$sql");
	863	$res4->execute();
[265]	864
	865	$numero=$res4->rowCount();
[318]	866	$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' ";
	867	$res5 = $dbi->prepare("$sql");
	868	$res5->execute();
[265]	869
	870	$sezioni=$res5->rowCount();
[254]	871	if ($numero!=0) echo "<h5><i> "._SEZSCRU." $numero "._SU." $sezioni </i></h5>";
	872
	873	}
[318]	874	$sql="select count(0) from ".$prefix."_ele_sezioni where id_cons='$id_cons'";
	875	$res5 = $dbi->prepare("$sql");
	876	$res5->execute();
[254]	877
[265]	878	list($num_sez) = $res5->fetch(PDO::FETCH_NUM);
[254]	879
	880
	881
	882
[265]	883
[254]	884	if (!$csv)echo "<b>Referendum n. ".$num_gruppo." </b><br />".$descr."";
	885
	886	$y=1;
	887	$ar[0][0]=$tipo2;
	888	$ar[0][1]=_SI;
	889	$ar[0][2]=_NO;
	890	$ar[0][3]=_VALIDI;
	891	$ar[0][4]=_NULLI;
	892	$ar[0][5]=_BIANCHI;
	893	$ar[0][6]=_CONTESTATI;
	894	if($res_ref)
[265]	895	while (list($num_gruppo,$desc_ref) = $res_ref->fetch(PDO::FETCH_NUM)){
[254]	896	$ar[0][$i++]= $num_gruppo.") ".$desc_ref;
	897	$ar[1][$y++]= "SI";
	898	$ar[1][$y++]= "NO";
	899	}
	900	$num_sez++;
	901	$tot_si=0;
	902	$tot_no=0;
	903	$tot_va=0;
	904	$tot_nu=0;
	905	$tot_bi=0;
	906	$tot_co=0;
	907	if($res)
[265]	908	while (list($num_circ,$desc_circ,$num_gruppo,$desc_ref,$simbolo,$si,$no,$validi,$nulli,$bianchi, $contestati) = $res->fetch(PDO::FETCH_NUM)){
[254]	909	$i=1;
	910	$votanti=$validi+$nulli+$bianchi+$contestati;
	911	$tot_si+=$si;
	912	$tot_no+=$no;
	913	$tot_va+=$validi;
	914	$tot_nu+=$nulli;
	915	$tot_bi+=$bianchi;
	916	$tot_co+=$contestati;
	917	$ar[$num_circ][0]=$num_circ."<br />".$desc_circ;
	918	if($validi){
	919	$ar[$num_circ][$i++]= $perc=='true' ? $si."<br /><span class=\"red\"><i>".number_format($si*100/$validi,2)."%</i></span>":$si;
	920	$ar[$num_circ][$i++]= $perc=='true' ? $no."<br /><span class=\"red\"><i>".number_format($no*100/$validi,2)."%</i></span>":$no;
	921	}else{
	922	$ar[$num_circ][$i++]= $perc=='true' ? $si."<br /><span class=\"red\"><i>0.00%</i></span>":$si;
	923	$ar[$num_circ][$i++]= $perc=='true' ? $no."<br /><span class=\"red\"><i>0.00%</i></span>":$no;
	924	}
	925	if($votanti){
	926	$ar[$num_circ][$i++]= $perc=='true' ? $validi."<br /><span class=\"red\"><i>".number_format($validi*100/$votanti,2)."%</i></span>":$validi;
	927	$ar[$num_circ][$i++]= $perc=='true' ? $nulli."<br /><span class=\"red\"><i>".number_format($nulli*100/$votanti,2)."%</i></span>":$nulli;
	928	$ar[$num_circ][$i++]= $perc=='true' ? $bianchi."<br /><span class=\"red\"><i>".number_format($bianchi*100/$votanti,2)."%</i></span>":$bianchi;
	929	$ar[$num_circ][$i++]= $perc=='true' ? $contestati."<br /><span class=\"red\"><i>".number_format($contestati*100/$votanti,2)."%</i></span>":$contestati;
	930	}else{
	931	$ar[$num_circ][$i++]= $perc=='true' ? $validi."<br /><span class=\"red\"><i>0.00%</i></span>":$validi;
	932	$ar[$num_circ][$i++]= $perc=='true' ? $nulli."<br /><span class=\"red\"><i>0.00%</i></span>":$nulli;
	933	$ar[$num_circ][$i++]= $perc=='true' ? $bianchi."<br /><span class=\"red\"><i>0.00%</i></span>":$bianchi;
	934	$ar[$num_circ][$i++]= $perc=='true' ? $contestati."<br /><span class=\"red\"><i>0.00%</i></span>":$contestati;
	935	}
	936	}
	937	$i=1;
	938	$tot_vo=$tot_va+$tot_nu+$tot_bi+$tot_co;
	939	# if($tot_va==0) $tot_va=1;
	940	# if($tot_vo==0) $tot_vo=1;
	941	$ar[$num_sez][0]=_TOT."<br />"._COMPLESSIVO;
	942	if($tot_va){
	943	$ar[$num_sez][$i++]= $perc=='true' ? $tot_si."<br /><span class=\"red\">".number_format($tot_si*100/$tot_va,2)."%</span>":$tot_si;
	944	$ar[$num_sez][$i++]= $perc=='true' ? $tot_no."<br /><span class=\"red\">".number_format($tot_no*100/$tot_va,2)."%</span>":$tot_no;
	945	}else{
	946	$ar[$num_sez][$i++]= $perc=='true' ? $tot_si."<br /><span class=\"red\">0.00%</span>":$tot_si;
	947	$ar[$num_sez][$i++]= $perc=='true' ? $tot_no."<br /><span class=\"red\">0.00%</span>":$tot_no;
	948	}
	949	if($tot_vo){
	950	$ar[$num_sez][$i++]= $perc=='true' ? $tot_va."<br /><span class=\"red\">".number_format($tot_va*100/$tot_vo,2)."%</span>":$tot_va;
	951	$ar[$num_sez][$i++]= $perc=='true' ? $tot_nu."<br /><span class=\"red\">".number_format($tot_nu*100/$tot_vo,2)."%</span>":$tot_nu;
	952	$ar[$num_sez][$i++]= $perc=='true' ? $tot_bi."<br /><span class=\"red\">".number_format($tot_bi*100/$tot_vo,2)."%</span>":$tot_bi;
	953	$ar[$num_sez][$i++]= $perc=='true' ? $tot_co."<br /><span class=\"red\">".number_format($tot_co*100/$tot_vo,2)."%</span>":$tot_co;
	954	}else{
	955	$ar[$num_sez][$i++]= $perc=='true' ? $tot_va."<br /><span class=\"red\">0.00%</span>":$tot_va;
	956	$ar[$num_sez][$i++]= $perc=='true' ? $tot_nu."<br /><span class=\"red\">0.00%</span>":$tot_nu;
	957	$ar[$num_sez][$i++]= $perc=='true' ? $tot_bi."<br /><span class=\"red\">0.00%</span>":$tot_bi;
	958	$ar[$num_sez][$i++]= $perc=='true' ? $tot_co."<br /><span class=\"red\">0.00%</span>":$tot_co;
	959	}
	960	crea_tabella($ar);
	961	}
	962	if ($csv) echo "</body>\n</html>";
	963	}
	964
	965	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: