source: trunk/admin/modules/Elezioni/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
Line 
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
12if (!defined('ADMIN_FILE')) {
13 die ("You can't access this file directly...");
14}
15if (!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}
23global $dbi;
24$aid=$_SESSION['aid'];
25#$dbi=$_SESSION['dbi'];
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
34if (!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
38if ($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}
44include_once("modules/Elezioni/query.sql");
45
46$row=setconsultazione();
47if(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();
53if(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}
58
59if (!$perms) $perms=ChiSei($id_cons_gen);
60 include_once("modules/Elezioni/language/lang-$currentlang.php");
61 //**************************************************************************
62 // ELE
63 //**************************************************************************
64
65
66function ele() {
67
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;
69
70 include ("header.php");
71# include("modules/Elezioni/testa.php");
72 //immagine bullet
73 $bullet="<img src=\"temi/$tema/images/bullet.gif\" alt =\" \" align=\"left\" border=\"0\">";
74 $bullet_red="<img src=\"temi/$tema/images/bullet_red.gif\" alt =\" \" align=\"left\" border=\"0\">";
75 $bgcolor1='#e7e7e7';
76 $row=descr_comune();$descr_comu=$row['descrizione'];
77
78 $row=daticonscom();
79 if (isset($row['id_fascia'])) $fascia=$row['id_fascia'];
80 else
81 $fascia=0;
82 $otable= "<table bgcolor=\"$bgcolor1\" width=\"100%\" cellpadding=\"0\" cellspacing=\"2\" BORDER=\"0\">\n <tr><td>&nbsp;&nbsp;&nbsp;</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\">";
93###########################
94$row=elenco_cons();
95
96
97##################################
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\">";
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)) {
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
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; }
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; }
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; }
136 if ($genere==0) $tmpval='voti_ref'; else $tmpval='sezioni';
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);
141 if ($perms==256) // il superuser puo' scegliere il comune su cui lavorare
142 {
143 $row=elenco_comuni();
144 echo "<select name=\"id_comune\" onChange=\"top.location.href=this.form.pag_cons.value+$id_cons_gen+'&amp;id_comune='+this.form.id_comune.options[this.form.id_comune.selectedIndex].value;return false\"><option value=\"\">";
145 foreach($row as $riga)
146 {
147 $id=$riga[0];$descrizione=$riga[1];
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>";
161 echo "<tr align=\"left\" bgcolor=\"$bgcolor1\"><td valign=\"top\" align=\"left\" width=\"150\" colspan=\"2\">
162 <a href=\"admin.php?op=$op&amp;id_cons_gen=$id_cons_gen&amp;help=1\">$bullet"._HELP."</a>
163 </td></tr>";
164
165 if ($perms>128) {
166
167# <a href=\"admin.php?op=inscollegi&amp;id_cons_gen=$id_cons_gen\">$bullet"._COLLEGI."</a><br>
168
169 echo "
170 <tr align=\"left\" bgcolor=\"$bgcolor1\">
171 <td valign=\"top\" align=\"center\" bgcolor=\"#000000\" rowspan=\"3\"><font face=\"Arial,Helvetica\" size=-1><font color=\"#ffffff\"><b>"._SUPER."
172 </b></font></font>
173 </td>";
174 echo "<td valign=\"top\" align=\"left\" width=\"150\">";
175 if(!$BACKUP){
176 echo "<a href=\"admin.php?op=configurazione&amp;id_cons_gen=$id_cons_gen\">$bullet"._CONFIGURAZIONE."</a><br>";
177 if($op=="configurazione" || $op=="widget" || $op=="plugin"){
178 echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - <a href=\"admin.php?op=widget&amp;id_cons_gen=$id_cons_gen\"> "._WIDGET."</a>";
179 echo "<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - "._PLUGINS."";
180 echo "<hr>";
181 }
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;
195
196
197 }
198 $myrev=$_SESSION['localrev'];
199 if($newrev==$myrev or $newrev==0) echo "<a href=\"admin.php?op=aggiorna&amp;id_cons_gen=$id_cons_gen\">$bullet"._AGGIORNA."</a><br>";
200 else echo "<a href=\"admin.php?op=aggiorna&amp;id_cons_gen=$id_cons_gen\">$bullet_red<b>"._AGGIORNA."</b></a><br>";
201 if(!$BACKUP){
202 echo "<a href=\"admin.php?op=confconsiglio&amp;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&amp;id_cons_gen=$id_cons_gen\">$bullet"._DEFCOMUNE."</a><br>
205 <a href=\"admin.php?op=oper_admin&amp;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&amp;id_cons_gen=$id_cons_gen\">$bullet"._CONSULTAZIONE_ADM."</a><br>";
208 echo "<a href=\"admin.php?op=rec_add_aff&amp;id_cons_gen=$id_cons_gen\">$bullet"._AFFLUENZE."</a><br>
209 <a href=\"admin.php?op=associazioni&amp;id_cons_gen=$id_cons_gen\">$bullet"._INSCOMUNE."</a>";
210 }else{
211 echo "</td></tr><tr align=\"left\" bgcolor=\"$bgcolor1\"><td valign=\"top\" align=\"left\" width=\"150\" rowspan=\"2\">";
212 echo "<a href=\"admin.php?op=aggcons&amp;id_cons_gen=$id_cons_gen\">$bullet"._AGGDATI."</a>";
213 echo "</td></tr><tr><td>";
214 }
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>
217
218 # <a href=\"admin.php?op=backup&amp;id_cons_gen=$id_cons_gen\">$bullet"._BACKUP."</a><br>
219
220 }
221// Amministrazione locale solo superuser e adminuser
222 if ($perms>16 and ! $espandi and !$BACKUP) {
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&amp;id_cons_gen=$id_cons_gen\">$bullet"._CONSULTAZIONI."</a><br>
233 <a href=\"admin.php?op=scarica&amp;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&amp;id_cons_gen=$id_cons_gen\">$bullet"._IMPORTA."</a><br>";
236 echo "<a href=\"admin.php?op=operatori&amp;id_cons_gen=$id_cons_gen\">$bullet"._OPERATORI."</a> <br><a href=\"admin.php?op=permessi&amp;id_cons_gen=$id_cons_gen\">$bullet"._PERMESSI."</a> <br>";
237 }
238 echo "<a href=\"admin.php?op=come&amp;vai=come&amp;id_cons_gen=$id_cons_gen\">$bullet "._COME."</a> <br>
239 <a href=\"admin.php?op=numeri&amp;vai=numeri&amp;id_cons_gen=$id_cons_gen\">$bullet "._NUMERI."</a> <br>
240 <a href=\"admin.php?op=servizi&amp;vai=servizi&amp;id_cons_gen=$id_cons_gen\">$bullet "._SERVIZI."</a> <br>
241 <a href=\"admin.php?op=link&amp;vai=link&amp;id_cons_gen=$id_cons_gen\">$bullet "._LINK."</a> <br>
242 <a href=\"admin.php?op=circo&amp;id_cons_gen=$id_cons_gen\">
243
244 $bullet"._CIRCO."</a> <br>";
245 if ($nrcirco){
246 echo "<a href=\"admin.php?op=sede&amp;id_cons_gen=$id_cons_gen\">$bullet "._SEDE."</a> <br>";
247 if ($nrsede){
248 echo "<a href=\"admin.php?op=sezione&amp;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&amp;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&amp;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&amp;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\">";
287 if ($op!='consultazione' and $perms>0 and $nrcirco and ($nrlista or $nrgruppo) and ! $espandi) {
288 if(!$BACKUP) echo "<a href=\"admin.php?op=voti&amp;id_cons_gen=$id_cons_gen&amp;do=spoglio\">$bullet "._GEST." "._SPOGLIO."</a><br>";
289 if ($nraff) {
290 echo "<a href=\"admin.php?op=controllo_votanti&amp;id_cons_gen=$id_cons_gen\">$bullet "._STATO." "._AFFLUENZE."</a><br>";
291 }else{
292 echo "$bullet "._STATO." "._AFFLUENZE."<br>";
293 }
294 if ($nrvoti)
295 echo "<a href=\"admin.php?op=controllo_voti&amp;id_cons_gen=$id_cons_gen\">$bullet "._STATO." "._VOTI."</a><br>";
296 else
297 echo "$bullet "._STATO." "._VOTI."<br>";
298 if($nrcandidati)
299 echo "<a href=\"admin.php?op=estraidati&amp;id_cons_gen=$id_cons_gen\">$bullet "._ESTRAIDATI."</a><br>";
300 else
301 echo "$bullet "._ESTRAIDATI."<br>";
302 echo "<a href=\"admin.php?op=riepilogo&amp;id_cons_gen=$id_cons_gen\">$bullet "._RIEPILOGO."</a><br>";
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&amp;id_cons_gen=$id_cons_gen\">$bullet Tabella dei Totali</a><br>";
307 }
308
309
310 echo "<br><a href=\"admin.php?op=cambiopwd&amp;id_cons_gen=$id_cons_gen\">$bullet"._CAMBIOPWD."</a><br>";
311
312 if (file_exists("../client/modules.php"))
313 echo "<hr><a href=\"../client/modules.php?id_comune=$id_comune&amp;id_cons_gen=$id_cons_gen&amp;op=gruppo\" target=\"_blank\">$bullet Guarda il sito</a><br><hr>";
314
315 //echo "<hr /><a href=\"../client/modules.php\" target=\"_blank\">$bullet Guarda il sito</a><br /><hr />";
316 echo "<a href=\"admin.php?op=logout&msglogout=0\">$bullet "._ESCI."</a>";
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}
325 if(!isset($op)) $op='';
326 switch ($op){
327 case "ele":
328 ele();
329 global $language;
330 include("language/$currentlang/ele.html");
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.