source: trunk/admin/modules/Elezioni/ele_comuni.php@ 257

Last change on this file since 257 was 257, checked in by roby, 6 years ago
File size: 14.0 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 Comuni */
9/* Amministrazione */
10/************************************************************************/
11if (!defined('ADMIN_FILE')) {
12 die ("You can't access this file directly...");
13}
14#foreach($_SESSION as $key=>$val) echo "$key : $val<br>";die();
15global $dbi;
16$aid=$_SESSION['aid'];
17#$dbi=$_SESSION['dbi'];
18$prefix=$_SESSION['prefix'];
19$id_comune=$_SESSION['id_comune'];
20$param=strtolower($_SERVER['REQUEST_METHOD']) == 'get' ? $_GET : $_POST;
21$id_cons_gen=intval($param['id_cons_gen']);
22$perms=ChiSei(0);
23//if ($perms<128 or !$id_cons_gen) die("$perms Non hai i permessi per inserire dati, o non hai scelto la consultazione!");
24if ($perms!=256) die("$perms Non hai i permessi per inserire dati!");
25if (isset($param['desc'])) get_magic_quotes_gpc() ? $desc=$param['desc']:$desc=addslashes($param['desc']); else $desc='';
26if (isset($param['indirizzo'])) get_magic_quotes_gpc() ? $indirizzo=$param['indirizzo']:$indirizzo=addslashes($param['indirizzo']); else $indirizzo='';
27if (isset($param['centralino'])) get_magic_quotes_gpc() ? $centralino=$param['centralino']:$centralino=addslashes($param['centralino']); else $centralino='';
28if (isset($param['fax'])) get_magic_quotes_gpc() ? $fax=$param['fax']:$fax=addslashes($param['fax']); else $fax='';
29if (isset($param['email'])) get_magic_quotes_gpc() ? $email=$param['email']:$email=addslashes($param['email']); else $email='';
30if (isset($param['id_comune2'])) $id_comune2=intval($param['id_comune2']); else $id_comune2='';
31if (isset($param['min'])) $min=intval($param['min']); else $min='';
32if (isset($param['ok'])) $ok=addslashes($param['ok']); else $ok='';
33if (isset($param['fascia'])) $fasciatmp=intval($param['fascia']); else $fasciatmp=0;
34if (isset($param['prov'])) $prov=intval($param['prov']); else $prov=0;
35if (isset($param['simbolo'])) get_magic_quotes_gpc() ? $simbolo=$param['simbolo']:$simbolo=addslashes($param['simbolo']); else $simbolo='';
36if (isset($param['cerca'])) get_magic_quotes_gpc() ? $cerca=$param['cerca']:$cerca=addslashes($param['cerca']); else $cerca='';
37if (isset($param['cap'])) get_magic_quotes_gpc() ? $cap=$param['cap']:$cap=addslashes($param['cap']); else $cap='';
38
39 $sql="SELECT t1.tipo_cons 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' ";
40 $res = $dbi->prepare("$sql");
41 $res->execute();
42 list($tipo_cons) = $res->fetch(PDO::FETCH_NUM);
43 $sql="SELECT genere FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' ";
44 $res = $dbi->prepare("$sql");
45 $res->execute();
46 list($genere) = $res->fetch(PDO::FETCH_NUM);
47 include("modules/Elezioni/funzionidata.php");
48 include("modules/Elezioni/ele.php");
49 // Offset - visualizza il numero di elementi per pagina
50
51 $offset=15;
52 if (!isset($min)) $min=0;
53
54 $hiddenInfo = "<input type=\"hidden\" name=\"min\" value=\"$min\">";
55
56
57
58 /******************************************************/
59 /*Funzione di visualizzazione globale */
60 /*****************************************************/
61 //crea la pagina delle affluenze
62function all() {
63 global $bgcolor1, $bgcolor2, $prefix, $dbi,$id_cons,$desc,$indirizzo,$centralino,$fax,$email,$fasciatmp,$prov,$id_comune2,$id_cons_gen,$cerca,$cap;
64 if( !isset($id_conf) ) $id_conf=1;
65 echo "<SCRIPT type=\"text/javascript\">\n\n<!--\n";
66 echo "function controllo_id() {\n";
67 echo "var is_num = /^[0-9]+$/;";
68 echo "if (document.modello.id_comune2.value.match(is_num)) \n return true;\n";
69 echo "else {\n";
70 echo "document.modello.id_comune2.bgColor=\"#FF0000\" \n";
71 echo "alert ('"._COD_NV."!')\n return false; \n";
72 echo "}\n";
73 echo "}\n//-->\n";
74 echo "</script>\n";
75
76
77 $sql="SELECT id_comune,descrizione,indirizzo,centralino,fax,email,fascia,capoluogo,simbolo,cap FROM ".$prefix."_ele_comuni where descrizione like '$cerca%' order by descrizione";
78 $resmod = $dbi->prepare("$sql");
79 $resmod->execute();
80# list($tipo_cons) = $resmod->fetch(PDO::FETCH_NUM);
81 echo "<table width=\"100%\"><tr><td bgcolor=\"$bgcolor2\"> <form name=\"cerca\" action=\"admin.php\">"
82 ."<input type=\"hidden\" name=\"op\" value=\"inscomuni\">";
83 echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">";
84 echo "<table>";
85 echo "<tr><td><b>"._FILTRO."</b><input name=\"cerca\"></td>";
86 echo "<td><input type=\"submit\" name=\"invia\" value=\""._OK."\"></td></tr></table></form></td></tr></table>";
87
88 echo "<form name=\"modello\" enctype=\"multipart/form-data\" method=\"post\" action=\"admin.php\" onSubmit=\"return controllo_id()\">"
89 ."<input type=\"hidden\" name=\"op\" value=\"inscomuni\">";
90 echo "<table width=\"100%\"><tr>";
91 echo "<td bgcolor=\"$bgcolor1\"><b>"._STEMMA."</b></td><td><input type=\"file\" name=\"stemma\" size=\"10\"></td>";
92 echo "<td bgcolor=\"$bgcolor1\"><b>"._CODICE."</b></td>";
93 if ($id_comune2)
94 echo "<td><input type=\"hidden\" name=\"id_comune2\" value=\"$id_comune2\">$id_comune2</td>";
95 else
96 echo "<td><input name=\"id_comune2\" value=\"$id_comune2\" size=\"4\"></td>";
97 echo "</tr>";
98 $sel[1]='';$sel[2]='';$sel[3]='';$sel[4]='';$sel[5]='';$sel[6]='';$sel[7]='';$sel[8]='';$sel[9]='';
99 $sel[$fasciatmp]='selected';
100 if($prov==1) $selpv='selected'; else $selpv='';
101 echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._PROV."</b></td><td><select name=\"prov\"> <option value=\"0\">No<option value=\"1\" $selpv>Si</select></td>";
102 echo "<td bgcolor=\"$bgcolor1\"><b>"._DESCR."</b></td><td><input name=\"desc\" value=\"".stripslashes($desc)."\"></td></tr>";
103 echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._INDIRIZZO."</b></td><td><input name=\"indirizzo\" value=\"".stripslashes($indirizzo)."\"></td>";
104 echo "<td bgcolor=\"$bgcolor1\"><b>"._CENTRALINO."</b></td><td><input name=\"centralino\" value=\"$centralino\" size=\"6\"></td></tr>";
105 echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._FASCIA."</b></td><td><select name=\"fascia\">";
106 $descr2="<";
107 $sql="select id_fascia, abitanti from ".$prefix."_ele_fasce where id_conf=1 order by id_fascia";
108 $resopt1 = $dbi->prepare("$sql");
109 $resopt1->execute();
110 while(list($id,$descr)=$resopt1->fetch(PDO::FETCH_NUM)){
111 $selid= ($id == $fasciatmp) ? "selected":"";
112
113 echo "<option value=\"$id\" $selid>$descr2 $descr";
114 $descr2="$descr -";
115 }
116 echo "</select></td>";
117
118 echo "<td bgcolor=\"$bgcolor1\"><b>"._FAX."</b></td><td><input name=\"fax\" value=\"$fax\" size=\"6\"></td></tr>";
119 echo "<tr><td bgcolor=\"$bgcolor1\"><b>"._EMAIL."</b></td><td><input name=\"email\" value=\"$email\"></td>";
120 echo "<td bgcolor=\"$bgcolor1\"><b>CAP</b></td><td><input name=\"cap\" value=\"$cap\" size=\"6\"> (<i>per googlemaps</i>) </td></tr>";
121 echo "<td></td><td></td><td></td><td><input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">";
122 echo "<input type=\"hidden\" name=\"ok\" value=0>";
123 if ($id_comune2) {
124 echo "<input type=\"hidden\" name=\"do\" value=\"update\">";
125 echo "<input type=\"submit\" name=\"add\" value=\""._MODIFY."\"></td></tr></form>";
126 }else{
127 echo "<input type=\"hidden\" name=\"do\" value=\"add\">";
128 echo "<input type=\"submit\" name=\"add\" value=\""._ADD."\"></td></tr></form>";
129 }
130 $i=1;
131####
132echo "</table><hr>";
133 echo "<table><tr><td bgcolor=\"$bgcolor1\"><b>"._STEMMA."</b></td>";
134 echo "<td bgcolor=\"$bgcolor1\"><b>"._CODICE."</b></td>";
135 echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._PROV."</b></td>";
136 echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._DESCR."</b></td>";
137 echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._INDIRIZZO."</b></td>";
138 //."<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._CENTRALINO."</b></td>";
139 //echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._FAX."</b></td>";
140 echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._EMAIL."</b></td>";
141 echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>CAP</b></td>";
142 echo "<td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._FASCIA."</b></td></tr>";
143
144
145####
146 while (list($id_comune2,$desc,$indirizzo,$centralino,$fax,$email,$fasciatmp,$prov,$simbolo,$cap) = $resmod->fetch(PDO::FETCH_NUM)){ //elenco dei modelli inseriti
147 $bgcolor1=($bgcolor1==$_SESSION['bgcolor1'])?$_SESSION['bgcolor2']:$_SESSION['bgcolor1'];
148 if (!$simbolo) $simbolo="nulla.jpg";
149 $valprov= $prov==0 ? 'No':'Si';
150 echo "<form name=\"modello$i\" action=\"admin.php\">"
151 ."<input type=\"hidden\" name=\"op\" value=\"inscomuni\">";
152 echo "<input type=\"hidden\" name=\"do\" value=\"delete\">";
153 echo "<input type=\"hidden\" name=\"desc\" value=\"$desc\">";
154 echo "<tr align=\"left\" bgcolor=\"$bgcolor1\">";
155 echo "<td align=\"center\">
156 <img src=\"admin.php?op=foto&amp;id_comune=$id_comune2&amp;prefix=$prefix\" width=\"50\" heigth=\"50\"></td>";
157
158 echo "<td width=\"32\"><b>$id_comune2</b></td>";
159 echo "<td width=\"32\"><b>$valprov</b></td>";
160 echo "<td><b>$desc</b></td>";
161 echo "<td><b>$indirizzo</b></td>";
162 //echo "<td><b>$centralino</b></td>";
163 //echo "<td><b>$fax</b></td>";
164 echo "<td><b>".substr($email,0,15)."...</b></td>";
165 echo "<td><b>$cap</b></td>";
166 $sql="select abitanti from ".$prefix."_ele_fasce where id_fascia=$fasciatmp and id_conf=$id_conf";
167 $resopt1 = $dbi->prepare("$sql");
168 $resopt1->execute();
169 list($tmpfascia)=$resopt1->fetch(PDO::FETCH_NUM);
170 $fasciaref=$fasciatmp-1;
171 $sql="select abitanti from ".$prefix."_ele_fasce where id_fascia=$fasciaref and id_conf=$id_conf";
172 $resopt1 = $dbi->prepare("$sql");
173 $resopt1->execute();
174 if($resopt1->rowCount()==0) $valfascia="< $tmpfascia";
175 else
176 {
177 list($tmp2fascia)=$resopt1->fetch(PDO::FETCH_NUM);
178 $valfascia="$tmp2fascia - $tmpfascia";
179 }
180
181/*
182 switch ($fasciatmp) {
183 case '0': $valfascia="-"; break;
184 case '1': $valfascia="< 3.000"; break;
185 case '2': $valfascia="3.001-10.000"; break;
186 case '3':$valfascia="10.001-15.000"; break;
187 case '4':$valfascia="15.001-30.000"; break;
188 case '5':$valfascia="30.001-100.000"; break;
189 case '6':$valfascia="100.001-250.000"; break;
190 case '7':$valfascia="250.001-500.000"; break;
191 case '8':$valfascia="500.001-1000.000"; break;
192 case '9': $valfascia=" >1.000.000"; break;
193 } */
194 echo "<td><b>$valfascia</b></td>";
195 echo "<input type=\"hidden\" name=\"ok\" value=0>";
196 echo "</td><td nowrap>[<a
197 href=\"admin.php?op=inscomuni&amp;desc=$desc&amp;id_comune2=$id_comune2&amp;indirizzo=$indirizzo&amp;centralino=$centralino&amp;fax=$fax&amp;email=$email&amp;fascia=$fasciatmp&amp;prov=$prov&amp;id_cons_gen=$id_cons_gen&amp;cap=$cap\"><img align=\"center\" src=\"modules/Elezioni/images/edit.gif\"
198 border=\"0\"> "._EDIT."</a>]";
199 echo "</tr></form>";
200 $i++;
201 }
202 echo "</table>";
203 CloseTable();
204 }
205
206function comuni($ok, $do,$desc,$indirizzo,$centralino,$fax,$email,$id_comune,$fasciatmp,$prov,$simbolo,$cap) {
207 global $bgcolor1, $bgcolor2, $prefix, $dbi, $descr_cons, $id_cons_gen,$genere;
208/* if ($do == "delete") {
209 if ($ok !="1") {
210// ele($id_cons);operatori
211 echo "<center><br><br>"._DOMCANCELLA." "._COMUNE." $desc ?<br>";
212 echo "[ <a href=\"admin.php?op=inscomuni&amp;id_comune=$id_comune&amp;desc=$desc\">"._NO."</a> ] - [<a href=\"admin.php?op=inscomuni&amp;do=delete&amp;desc=$desc&amp;id_comune=$id_comune&amp;ok=1\">"._YES."</a> ]";
213 }else{
214 $result = sql_query("delete from ".$prefix."_ele_comuni where id_comune='$id_comune'", $dbi) || die("<br><br>Errore di eliminazione: ".mysql_error());
215 if (!$result) return;
216 Header("Location: admin.php?op=inscomuni&id_comune=$id_comune");
217 }
218 }else*/
219 $_SESSION['id_comune']=$id_comune;
220 if ($do == "add") {
221 if ($desc) {
222 $stemmablob='';
223 $stemmanome='';
224 $STEMM=$_FILES['stemma'];
225 $filestemma=$STEMM['tmp_name'];
226 $nomestemma=$STEMM['name'];
227 $sqlset='';
228 if ($filestemma){
229 $fdstemma = fopen ("$filestemma", "rb");
230 $stemmacontents = fread ($fdstemma, filesize ("$filestemma"));
231 fclose ($fdstemma);
232 $stemmablob=addslashes($stemmacontents);
233 $stemmanome=addslashes($nomestemma);
234 }
235 $sql = "insert into ".$prefix."_ele_comuni (id_comune,descrizione,indirizzo,centralino,fax,email,fascia,capoluogo,simbolo,stemma,cap) values ('$id_comune','$desc','$indirizzo','$centralino','$fax','$email','$fasciatmp','$prov','$stemmanome','$stemmablob','$cap')";
236 $result = $dbi->prepare("$sql");
237 $result->execute();
238 Header("Location: admin.php?op=inscomuni&id_cons_gen=$id_cons_gen");
239 } else {
240 OpenTable();
241 echo "<center>"._GESTIONE." "._OPERATORI." desc=$desc; ";
242 echo "<br><br><a href=\"admin.php?op=inscomuni&amp;id_comune=$id_comune\">"._IMM." "._OPERATORI."</a></center>";
243 CloseTable();
244 }
245 }else if ($do == "update") {
246 $stemmablob='';
247 $stemmanome='';
248 $STEMM=$_FILES['stemma'];
249 $filestemma=$STEMM['tmp_name'];
250 $nomestemma=$STEMM['name'];
251 $sqlset='';
252 if ($filestemma){
253 $fdstemma = fopen ("$filestemma", "rb");
254 $stemmacontents = fread ($fdstemma, filesize ("$filestemma"));
255 fclose ($fdstemma);
256 $stemmablob=addslashes($stemmacontents);
257 $stemmanome=addslashes($nomestemma);
258 $cond=", simbolo='$stemmanome', stemma='$stemmablob'";
259 } else {$cond='';$stemmanome=''; $stemmablob='';}
260 $sql = "update ".$prefix."_ele_comuni set descrizione='$desc' , indirizzo='$indirizzo', centralino='$centralino', fax='$fax' , cap='$cap' , email='$email', fascia='$fasciatmp',capoluogo='$prov' $cond where id_comune='$id_comune'";
261 $result = $dbi->prepare("$sql");
262 $result->execute();
263 Header("Location: admin.php?op=inscomuni&id_cons_gen=$id_cons_gen");
264 }
265}
266
267if (isset($param['do'])) get_magic_quotes_gpc() ? $do=$param['do']:$do=addslashes($param['do']); else $do='';
268
269if ($do)
270 comuni($ok, $do,$desc,$indirizzo,$centralino,$fax,$email,$id_comune2,$fasciatmp,$prov,$simbolo,$cap);
271ele();
272all();
273include("footer.php");
274
275?>
276
Note: See TracBrowser for help on using the repository browser.