Context Navigation

ele.php@ 430

Last change on this file since 430 was 430, checked in by roby, 2 weeks ago

ADMIN

-- Aggiunti nel menu filtri di attivazione per la funzione di estrazione del file csv con le preferenze ai consiglieri

File size: 14.7 KB

Rev	Line
[2]	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	/* Modulo menu */
	9	/* Amministrazione */
	10	/************************************************************************/
	11
	12	if (!defined('ADMIN_FILE')) {
	13	die ("You can't access this file directly...");
	14	}
	15	if (!ini_get("register_globals")) {
	16	$php_ver = phpversion();
	17	$php_ver = explode(".", $php_ver);
	18	$phpver = "$php_ver[0]$php_ver[1]";
	19	if ($phpver >= 41) {
	20	$PHP_SELF = $_SERVER['PHP_SELF'];
	21	}
	22	}
[255]	23	global $dbi;
[2]	24	$aid=$_SESSION['aid'];
[255]	25	#$dbi=$_SESSION['dbi'];
[2]	26	$id_comune=$_SESSION['id_comune'];
	27	$prefix=$_SESSION['prefix'];
	28	$currentlang=$_SESSION['lang'];
	29	$bgcolor1=$_SESSION['bgcolor1'];
	30	$bgcolor2=$_SESSION['bgcolor2'];
	31	$bgcolor1='#e7e7e7';
	32	$param=strtolower($_SERVER['REQUEST_METHOD']) == 'get' ? $_GET : $_POST;
	33
	34	if (!isset($id_cons_gen)) if (isset($param['id_cons_gen'])) $id_cons_gen=$param['id_cons_gen'];else $id_cons_gen='0';
	35	$perms=ChiSei($id_cons_gen);
	36
	37	##modifica
	38	if ($perms>128){
	39	if (isset($param['id_comune']) && intval($param['id_comune'])>0) {
	40	$id_comune=intval($param['id_comune']);
	41	$_SESSION['id_comune']=$id_comune;
	42	}
	43	}
[255]	44	include_once("modules/Elezioni/query.sql");
[2]	45
[336]	46	$row=setconsultazione();
	47	if(isset($row[0])) {
	48	$tipo_cons=$row[0]; $descr_cons=$row[1]; $id_cons_gen=$row[2];
	49	} else {
	50	$tipo_cons=0; $descr_cons=''; $id_cons_gen=0;
	51	}
	52	$row=tipocons();
	53	if(isset($row[0])) {
	54	$genere=$row[0];$votog=$row[1];$votol=$row[2];$votoc=$row[3];$conscirc=$row[4];
	55	} else {
	56	$genere=0;$votog=0;$votol=0;$votoc=0;$conscirc=0;
	57	}
[2]	58
	59	if (!$perms) $perms=ChiSei($id_cons_gen);
[358]	60	include_once("modules/Elezioni/language/lang-$currentlang.php");
[2]	61	//**************************************************************************
	62	// ELE
	63	//**************************************************************************
	64
	65
	66	function ele() {
	67
[426]	68	global $espandi, $aid, $bgcolor1, $bgcolor2,$bgcolor5, $prefix, $dbi, $offset, $min,$descr_cons, $id_cons_gen,$tipo_cons,$genere,$op,$id_comune,$perms,$id_cons,$votog,$votol,$votoc,$votocirc,$tema,$fascia,$limite,$BACKUP,$versione;
[397]	69
[2]	70	include ("header.php");
[258]	71	# include("modules/Elezioni/testa.php");
[2]	72	//immagine bullet
[358]	73	$bullet="<img src=\"temi/$tema/images/bullet.gif\" alt =\" \" align=\"left\" border=\"0\">";
[230]	74	$bullet_red="<img src=\"temi/$tema/images/bullet_red.gif\" alt =\" \" align=\"left\" border=\"0\">";
[2]	75	$bgcolor1='#e7e7e7';
[255]	76	$row=descr_comune();$descr_comu=$row['descrizione'];
[256]	77
	78	$row=daticonscom();
[362]	79	if (isset($row['id_fascia'])) $fascia=$row['id_fascia'];
[196]	80	else
	81	$fascia=0;
[2]	82	$otable= "<table bgcolor=\"$bgcolor1\" width=\"100%\" cellpadding=\"0\" cellspacing=\"2\" BORDER=\"0\">\n <tr><td>   </td><td valign=\"top\" align=\"left\">";
	83	$otable1= "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"2\" BORDER=\"0\">\n <tr><td valign=\"top\" width=\"180\">";
	84	$ctable= "</td></tr></table>";
	85	$currentlang=$_SESSION['lang'];
	86
	87
	88
	89	echo "<form name=\"scelta\" action=\"admin.php\">";
	90	echo $otable;
	91	echo "<input type=\"hidden\" name=\"pag_cons\" value=\"admin.php?id_cons_gen=\">";
	92	echo "<input type=\"hidden\" name=\"op\" value=\"ele\">";
[255]	93	###########################
	94	$row=elenco_cons();
	95
	96
	97	##################################
[2]	98	echo "<font size=-1><b>"._SCELTA_CONS.":</b> </font><select name=\"id_cons_gen\" onChange=\"top.location.href=this.form.pag_cons.value+this.form.id_cons_gen.options[this.form.id_cons_gen.selectedIndex].value;return false\">";
[255]	99
	100	foreach ($row as $riga)
	101	{
	102	$id=$riga[0];$descrizione=$riga[1];$gen2=$riga[2];$idgen=$riga[3];$chiusa=$riga[4];
	103	# while(list() = mysql_fetch_row($res)) {
[2]	104	if (($chiusa==0) OR ($perms>32)) {
	105	if (($idgen==$id_cons_gen or !$id_cons_gen)) {
	106	$sel = "selected";
	107	$genere=$gen2;
	108	$id_cons_gen=$idgen;
	109	} else {
	110	$sel = "";
	111	}
	112	echo "<option value=\"$idgen\" $sel>$descrizione";
	113	}
	114	}
	115	echo "</select>";
	116	// controllo delle opzioni utilizzabili: sono quelle che hanno genitori in quella precedente
	117	// esempio si possono inserire i candidati solo se prima sono state inserite le liste
[256]	118	$sql="select count(0) from ".$prefix."_ele_circoscrizione where id_cons=$id_cons";
	119	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH);$nrcirco=$row[0];}
	120	catch(PDOException $e) {$nrcirco=0; }
	121	$sql="select count(0) from ".$prefix."_ele_sede where id_cons=$id_cons";
	122	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH);$nrsede=$row[0];}
	123	catch(PDOException $e) {$nrsede=0; }
	124	$sql="select count(0) from ".$prefix."_ele_gruppo where id_cons=$id_cons";
	125	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH);$nrgruppo=$row[0];}
	126	catch(PDOException $e) {$nrgruppo=0; }
	127	$sql = "select count(0) from ".$prefix."_ele_lista where id_cons=$id_cons";
	128	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH);$nrlista=$row[0];}
	129	catch(PDOException $e) {$nrlista=0; }
[430]	130	$sql = "select sum(voti) from ".$prefix."_ele_voti_candidati where id_cons=$id_cons";
	131	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH);$nrcandidati=$row[0];}
	132	catch(PDOException $e) {$nrcandidati=0; }
[256]	133	$sql = "SELECT sum(voti_complessivi) from ".$prefix."_ele_voti_parziale where id_cons=$id_cons";
	134	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH); $nraff=$row[0];}
	135	catch(PDOException $e) {$nraff=0; }
[2]	136	if ($genere==0) $tmpval='voti_ref'; else $tmpval='sezioni';
[256]	137	$sql = "SELECT sum(validi) from ".$prefix."_ele_$tmpval where id_cons=$id_cons";
	138	try { $sth = $dbi->prepare("$sql"); $sth->execute(); $row = $sth->fetch(PDO::FETCH_BOTH);$nrvoti=$row[0];}
	139	catch(PDOException $e) {$nrvoti=0; }
	140	unset($row);
[2]	141	if ($perms==256) // il superuser puo' scegliere il comune su cui lavorare
	142	{
[255]	143	$row=elenco_comuni();
[2]	144	echo "<select name=\"id_comune\" onChange=\"top.location.href=this.form.pag_cons.value+$id_cons_gen+'&id_comune='+this.form.id_comune.options[this.form.id_comune.selectedIndex].value;return false\"><option value=\"\">";
[255]	145	foreach($row as $riga)
[2]	146	{
[255]	147	$id=$riga[0];$descrizione=$riga[1];
[2]	148	$sel=($id == $id_comune) ? "selected":"";
	149	echo "<option value=\"$id\" $sel>$descrizione";
	150	}
	151	}
	152	echo "</select>";
	153	echo $ctable;
	154	echo "</form>";
	155
	156
	157	echo "<br>";
	158
	159	echo $otable1;
	160	echo "<table width=\"180\" align=\"left\"><tr><td><table>";
[56]	161	echo "<tr align=\"left\" bgcolor=\"$bgcolor1\"><td valign=\"top\" align=\"left\" width=\"150\" colspan=\"2\">
[92]	162	<a href=\"admin.php?op=$op&id_cons_gen=$id_cons_gen&help=1\">$bullet"._HELP."</a>
[45]	163	</td></tr>";
[2]	164
	165	if ($perms>128) {
	166
	167	# <a href=\"admin.php?op=inscollegi&id_cons_gen=$id_cons_gen\">$bullet"._COLLEGI."</a><br>
	168
[424]	169	echo "
[56]	170	<tr align=\"left\" bgcolor=\"$bgcolor1\">
[45]	171	<td valign=\"top\" align=\"center\" bgcolor=\"#000000\" rowspan=\"3\"><font face=\"Arial,Helvetica\" size=-1><font color=\"#ffffff\"><b>"._SUPER."
[424]	172	</b></font></font>
	173	</td>";
[427]	174	echo "<td valign=\"top\" align=\"left\" width=\"150\">";
[424]	175	if(!$BACKUP){
	176	echo "<a href=\"admin.php?op=configurazione&id_cons_gen=$id_cons_gen\">$bullet"._CONFIGURAZIONE."</a><br>";
	177	if($op=="configurazione" \|\| $op=="widget" \|\| $op=="plugin"){
	178	echo "      - <a href=\"admin.php?op=widget&id_cons_gen=$id_cons_gen\"> "._WIDGET."</a>";
	179	echo "<br>       - "._PLUGINS."";
	180	echo "<hr>";
	181	}
[427]	182	}
	183	if(isset($_SESSION['remoterev'])) {
	184	$newrev=$_SESSION['remoterev'];
	185	} else {
	186	$rev=0;
	187	if ($stream = fopen('http://mail.eleonline.it/version/risposta.php', 'r')) {
	188	$rev= stream_get_contents($stream, 4);
	189	fclose($stream);
	190	}
	191	$newrev=(int) filter_var($rev, FILTER_SANITIZE_NUMBER_INT);
	192	$_SESSION['remoterev']=$newrev;
	193	$myrev=intval(substr($versione,-4,4));
	194	$_SESSION['localrev']=$myrev;
[426]	195
	196
[427]	197	}
	198	$myrev=$_SESSION['localrev'];
	199	if($newrev==$myrev or $newrev==0) echo "<a href=\"admin.php?op=aggiorna&id_cons_gen=$id_cons_gen\">$bullet"._AGGIORNA."</a><br>";
	200	else echo "<a href=\"admin.php?op=aggiorna&id_cons_gen=$id_cons_gen\">$bullet_red<b>"._AGGIORNA."</b></a><br>";
	201	if(!$BACKUP){
[424]	202	echo "<a href=\"admin.php?op=confconsiglio&id_cons_gen=$id_cons_gen\">$bullet"._CONFCONS."</a>
	203	</td></tr><tr align=\"left\" bgcolor=\"$bgcolor1\"><td>
	204	<a href=\"admin.php?op=inscomuni&id_cons_gen=$id_cons_gen\">$bullet"._DEFCOMUNE."</a><br>
	205	<a href=\"admin.php?op=oper_admin&id_cons_gen=$id_cons_gen\">$bullet"._AMMINISTRATORI."</a>
	206	</td></tr><tr align=\"left\" bgcolor=\"$bgcolor1\"><td>
	207	<a href=\"admin.php?op=consultazione&id_cons_gen=$id_cons_gen\">$bullet"._CONSULTAZIONE_ADM."</a><br>";
	208	echo "<a href=\"admin.php?op=rec_add_aff&id_cons_gen=$id_cons_gen\">$bullet"._AFFLUENZE."</a><br>
	209	<a href=\"admin.php?op=associazioni&id_cons_gen=$id_cons_gen\">$bullet"._INSCOMUNE."</a>";
	210	}else{
[427]	211	echo "</td></tr><tr align=\"left\" bgcolor=\"$bgcolor1\"><td valign=\"top\" align=\"left\" width=\"150\" rowspan=\"2\">";
[424]	212	echo "<a href=\"admin.php?op=aggcons&id_cons_gen=$id_cons_gen\">$bullet"._AGGDATI."</a>";
	213	echo "</td></tr><tr><td>";
[2]	214	}
[424]	215	echo "</td></tr>";
	216	# <br><a href=\"http://www.eleonline.it/portal/segnala.php?tmp=test123\" target=\"_blank\">$bullet_red <b>"._SEGNALA."</b></a>
[2]	217
[424]	218	# <a href=\"admin.php?op=backup&id_cons_gen=$id_cons_gen\">$bullet"._BACKUP."</a><br>
	219
	220	}
[2]	221	// Amministrazione locale solo superuser e adminuser
[424]	222	if ($perms>16 and ! $espandi and !$BACKUP) {
[2]	223	echo "
	224	<tr bgcolor=\"$bgcolor1\">
	225	<td valign=\"top\" align=\"center\" bgcolor=\"#000000\"><font face=\"Arial,Helvetica\" size=-1><font color=\"#ffffff\"><b>"._ADMIN."
	226
	227	</b></font></font>
	228
	229	</td>
	230	<td valign=\"top\">";
	231	if ($perms>32) {
	232	echo "<a href=\"admin.php?op=cons_comuni&id_cons_gen=$id_cons_gen\">$bullet"._CONSULTAZIONI."</a><br>
	233	<a href=\"admin.php?op=scarica&id_cons_gen=$id_cons_gen\">$bullet"._SCARICA."</a><br>";
	234	# if($nrgruppo==0 and $nrlista==0)
	235	echo "<a href=\"admin.php?op=importa&id_cons_gen=$id_cons_gen\">$bullet"._IMPORTA."</a><br>";
	236	echo "<a href=\"admin.php?op=operatori&id_cons_gen=$id_cons_gen\">$bullet"._OPERATORI."</a> <br><a href=\"admin.php?op=permessi&id_cons_gen=$id_cons_gen\">$bullet"._PERMESSI."</a> <br>";
	237	}
	238	echo "<a href=\"admin.php?op=come&vai=come&id_cons_gen=$id_cons_gen\">$bullet "._COME."</a> <br>
	239	<a href=\"admin.php?op=numeri&vai=numeri&id_cons_gen=$id_cons_gen\">$bullet "._NUMERI."</a> <br>
	240	<a href=\"admin.php?op=servizi&vai=servizi&id_cons_gen=$id_cons_gen\">$bullet "._SERVIZI."</a> <br>
	241	<a href=\"admin.php?op=link&vai=link&id_cons_gen=$id_cons_gen\">$bullet "._LINK."</a> <br>
	242	<a href=\"admin.php?op=circo&id_cons_gen=$id_cons_gen\">
	243
	244	$bullet"._CIRCO."</a> <br>";
	245	if ($nrcirco){
	246	echo "<a href=\"admin.php?op=sede&id_cons_gen=$id_cons_gen\">$bullet "._SEDE."</a> <br>";
	247	if ($nrsede){
	248	echo "<a href=\"admin.php?op=sezione&id_cons_gen=$id_cons_gen\">$bullet "._SEZIONE."</a><br>";
	249	}
	250	}
	251	if ($genere!=4) { //gestisce gruppi if ($tipo_cons!=8){ $genere!=2 and
	252	echo "<a href=\"admin.php?op=gruppo&id_cons_gen=$id_cons_gen\">$bullet "._GRUPPO."</a><br>";
	253	}
	254
	255	if ($genere>2 or $genere==1){ ####prova
	256	if ($genere==4 or $nrgruppo){ // or $tipo_cons==10 or $tipo_cons==11){
	257	echo "
	258	<a href=\"admin.php?op=lista&id_cons_gen=$id_cons_gen\">$bullet "._LISTA."</a> <br>";
	259	if ($genere>2){ ####prova
	260	if ($nrlista){
	261	echo "<a href=\"admin.php?op=candidato&id_cons_gen=$id_cons_gen\">$bullet"._CANDIDATO."</a> <br>";
	262	}else{
	263	echo "$bullet "._CANDIDATO." ";
	264	}
	265	}
	266	}else{
	267	echo "
	268	$bullet"._LISTA." <br>";
	269	echo "$bullet "._CANDIDATO." <br>";
	270
	271	}
	272
	273	}
	274
	275	echo "</td></tr>";
	276	}
	277
	278
	279	//Amministrazione normale operatore
	280	echo "<tr bgcolor=\"$bgcolor1\">
	281	<td valign=\"top\" align=\"center\" bgcolor=\"#000000\"><font face=\"Arial,Helvetica\" size=-1><font color=\"#ffffff\"><b>"._OPER."
	282
	283	</b></font></font>
	284
	285	</td>
	286	<td valign=\"top\" width=\"150\">";
[358]	287	if ($op!='consultazione' and $perms>0 and $nrcirco and ($nrlista or $nrgruppo) and ! $espandi) {
[424]	288	if(!$BACKUP) echo "<a href=\"admin.php?op=voti&id_cons_gen=$id_cons_gen&do=spoglio\">$bullet "._GEST." "._SPOGLIO."</a><br>";
[2]	289	if ($nraff) {
	290	echo "<a href=\"admin.php?op=controllo_votanti&id_cons_gen=$id_cons_gen\">$bullet "._STATO." "._AFFLUENZE."</a><br>";
	291	}else{
[430]	292	echo "$bullet "._STATO." "._AFFLUENZE."<br>";
[2]	293	}
[430]	294	if ($nrvoti)
[2]	295	echo "<a href=\"admin.php?op=controllo_voti&id_cons_gen=$id_cons_gen\">$bullet "._STATO." "._VOTI."</a><br>";
[430]	296	else
	297	echo "$bullet "._STATO." "._VOTI."<br>";
	298	if($nrcandidati)
[429]	299	echo "<a href=\"admin.php?op=estraidati&id_cons_gen=$id_cons_gen\">$bullet "._ESTRAIDATI."</a><br>";
[430]	300	else
	301	echo "$bullet "._ESTRAIDATI."<br>";
[139]	302	echo "<a href=\"admin.php?op=riepilogo&id_cons_gen=$id_cons_gen\">$bullet "._RIEPILOGO."</a><br>";
[362]	303	# if($tipo_cons==18 or $tipo_cons==19)
	304
	305	if($genere==5 and ($fascia>$limite or $limite==0))
	306	echo "<a href=\"admin.php?op=riepilogovoti&id_cons_gen=$id_cons_gen\">$bullet Tabella dei Totali</a><br>";
[2]	307	}
[129]	308
	309
	310	echo "<br><a href=\"admin.php?op=cambiopwd&id_cons_gen=$id_cons_gen\">$bullet"._CAMBIOPWD."</a><br>";
[170]	311
	312	if (file_exists("../client/modules.php"))
[403]	313	echo "<hr><a href=\"../client/modules.php?id_comune=$id_comune&id_cons_gen=$id_cons_gen&op=gruppo\" target=\"_blank\">$bullet Guarda il sito</a><br><hr>";
[170]	314
	315	//echo "<hr /><a href=\"../client/modules.php\" target=\"_blank\">$bullet Guarda il sito</a><br /><hr />";
[400]	316	echo "<a href=\"admin.php?op=logout&msglogout=0\">$bullet "._ESCI."</a>";
[2]	317	echo "</td></tr></table>";
	318	// continua la tabella su ele.voti con le sezioni
	319	// altrimenti inizia la tabella centrale
	320
	321	if ($op!="voti")
	322	echo "</td></tr></table></td><td valign=\"top\" align=left>";
	323
	324	}
[397]	325	if(!isset($op)) $op='';
[2]	326	switch ($op){
	327	case "ele":
[92]	328	ele();
	329	global $language;
[258]	330	include("language/$currentlang/ele.html");
[2]	331	echo"</td></tr></table>";
	332	include("footer.php");
	333
	334	break;
	335
	336	}
	337
	338	?>

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

Context Navigation

source: trunk/admin/modules/Elezioni/ele.php@ 430

Download in other formats: