- Timestamp:
- Jul 28, 2025, 10:13:48 AM (4 months ago)
- Location:
- trunk
- Files:
-
- 5 edited
-
admin/modules/Elezioni/dait_europee.php (modified) (4 diffs)
-
admin/modules/Elezioni/dait_politiche.php (modified) (5 diffs)
-
admin/modules/Elezioni/ele.php (modified) (1 diff)
-
admin/versione.php (modified) (1 diff)
-
client/versione.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/dait_europee.php
r442 r479 24 24 list($idcns)=$res->fetch(PDO::FETCH_NUM); 25 25 include("modules/Elezioni/ele.php"); 26 // Funzione per scaricare il file CSV e verificare che venga scaricato correttamente die("TEST: qui");26 // Funzione per scaricare il file CSV e verificare che venga scaricato correttamente 27 27 function downloadCSV($url) { 28 $data = @file_get_contents($url);28 $data = file_get_contents($url); 29 29 if ($data === false) { 30 30 return false; … … 69 69 70 70 // Parsa il CSV riga per riga 71 if( count(str_getcsv($lines[0], ';'))>1) $div=';'; else $div=','; 71 72 foreach ($lines as $line) { 72 73 if (trim($line)) { 73 $csvData[] = str_getcsv($line, ';'); // Usa ';' come delimitatore74 $csvData[] = explode($div,$line); // Usa ';' come delimitatore 74 75 } 75 76 } … … 81 82 // Trova le intestazioni delle colonne 82 83 $header = $csvData[0]; 84 if($header==false or count($header)==1) $header = explode($div,$csvData[0][0]); 83 85 $header = array_map('trim', $header); // Rimuove spazi extra dalle intestazioni 84 85 86 // Verifica che tutte le colonne necessarie siano presenti 86 87 $requiredColumns = [ … … 115 116 foreach ($csvData as $row) { 116 117 if (isset($row[$circoscrizioneColIndex]) && $row[$circoscrizioneColIndex] === $circoscrizione) { 118 117 119 // Crea la colonna unificata "Nome" 118 120 $row[$nomeColIndex] = trim($row[$nomeColIndex] . ' ' . $row[$altNomeColIndex] . ' ' . $row[$altNome1ColIndex]); -
trunk/admin/modules/Elezioni/dait_politiche.php
r447 r479 35 35 $filteredData = []; 36 36 37 ele();38 37 // Funzione per scaricare il file CSV 39 38 function downloadCSV($url) { … … 73 72 foreach($tmp as $val){ 74 73 $collegicamera[]=explode("\t",strtoupper($val)); 75 # echo "<br>TEST: val:$val";76 74 } 77 75 $filtrato = array(); 78 # $filtrato[]=array("DESCR_LISTA","CANDIDATO","DESCR_LISTA_UNI","CANDIDATO_UNI");79 76 foreach($collegicamera as $key=>$val) 80 77 { 81 # $pos=array_search("PIEMONTE 1 - U01 (TORINO: CIRCOSCRIZIONE 2 - SANTA RITA - MIRAFIORI NORD - MIRAFIORI SUD)",array_column($csvData[0],1));82 # $pos=0;83 78 if(strncmp($collegio,$val[1],strlen($val[1]))) { continue; } 84 $collegiuni[]=$val[1]; # echo "<br>TEST4:$collegio: ".$val[1];79 $collegiuni[]=$val[1]; 85 80 $collegipluri[]=$val[0]; 86 81 foreach($csvData[0] as $index => $string) { 87 82 $pos=strncmp($string[1], $val[1], strlen($val[1])); 88 if ( $pos !== 0 or $string[0]!='ITALIA' ) 89 continue; 90 # echo "<br>$pos:TEST$index: ".print_r($string)." ; ".print_r($val); 91 $filtrato[]=array($string[3],$string[2]); 92 # $pos++; 83 if ( $pos !== 0 or $string[0]!='ITALIA' ) 84 continue; 85 $filtrato[]=array($string[3],$string[2]); 93 86 } 94 87 } 95 # echo "<br>TEST: $pos:".print_r($collegiuni);96 # echo "<br>TEST: --- :".print_r($collegipluri);97 # echo "TEST:".var_dump($collegicamera);98 88 if(!isset($filtrato) or (isset($filtrato) and count($filtrato)==0)) { 99 89 $linesuni=$csvData[0]; 100 90 $linespluri=$csvData[1]; 101 # echo "<br>TEST: ".var_dump($linesuni[0])."---".var_dump($linespluri[0]); 102 $i=0;$y=0; 91 $i=0;$y=0; 103 92 foreach ($linesuni as $lineuni) { $i++; 104 # if ($lineuni) {105 # $aruni=str_getcsv($lineuni);106 93 if($lineuni[1]!=$collegio or $lineuni[2]=='DESCR_LISTA') continue; 107 94 foreach($linespluri as $linepluri) 108 # if($linepluri) 109 { $y++;#echo "<br>TEST:collegio:$collegio::".$linepluri[1].":lista:".$lineuni[1]." __ ".$linepluri[2]; 110 # $arpluri=str_getcsv($linepluri); 111 # echo "<br>TEST0: $collegio - ".$linepluri[0]." - ".$linepluri[1]; 112 # echo "<br>TEST3: $collegio ; ".$linepluri[1]." ; ".$lineuni[1]." ; ".$linepluri[2]." ; ".$linepluri[3]; 113 $flag=0; 114 # $collegiorif=substr($tmpcollegio,0,strlen($lineuni[1])) 115 foreach($collegipluri as $tmpcollegio) { 116 if($linepluri[1]==$tmpcollegio and $lineuni[2]==$linepluri[2]) { $flag=1;} 117 # echo "<br>TEST:$flag:$tmpcollegio::".$linepluri[1]." - ".$lineuni[2]." - ".$linepluri[2]; 118 } 119 if(!$flag) continue; 120 if(isset($lineuni[2]) and isset($linepluri[2])){ # and strrpos($lineuni[2],$linepluri[2],0) 121 $filtrato[] = array($lineuni[3],$linepluri[2],$linepluri[3]); 122 } 95 { 96 $y++; 97 $flag=0; 98 foreach($collegipluri as $tmpcollegio) { 99 if($linepluri[1]==$tmpcollegio and $lineuni[2]==$linepluri[2]) { $flag=1;} 123 100 } 124 # } 125 } 126 } 127 # echo "<br>TEST: ".$lineuni[1]."::".$lineuni[2]."::".$lineuni[3]."::".$linepluri[2]."::".$linepluri[3]; 128 #echo "TEST2: ".print_r($filtrato[1]); 129 #foreach($filtrato as $val) echo var_dump($val); 101 if(!$flag) continue; 102 if(isset($lineuni[2]) and isset($linepluri[2])){ # and strrpos($lineuni[2],$linepluri[2],0) 103 $filtrato[] = array($lineuni[3],$linepluri[2],$linepluri[3]); 104 } 105 } 106 } 107 } 130 108 return $filtrato; 131 109 } … … 158 136 // Filtra i dati in base alla circoscrizione e al collegio selezionati 159 137 if (!empty($collegio)) { 160 /* foreach ($csvData as $row) {161 if (162 isset($row[$circoscrizioneColIndex], $row[$collegioColIndex]) &&163 $row[$circoscrizioneColIndex] === $circoscrizione &&164 $row[$collegioColIndex] === $collegio165 ) {166 $filteredData[] = $row;167 }168 } */169 138 $filteredData=filtradati($csvData); 170 139 } … … 208 177 <body> 209 178 179 <?php if ($confermaDati === "si"){ 180 $sql="delete from ".$prefix."_ele_gruppo where id_cons='$idcns'"; 181 $reslnew = $dbi->prepare("$sql"); 182 $reslnew->execute(); 183 $sql="delete from ".$prefix."_ele_voti_gruppo where id_cons='$idcns'"; 184 $reslnew = $dbi->prepare("$sql"); 185 $reslnew->execute(); 186 $sql="delete from ".$prefix."_ele_lista where id_cons='$idcns'"; 187 $reslnew = $dbi->prepare("$sql"); 188 $reslnew->execute(); 189 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$idcns'"; 190 $reslnew = $dbi->prepare("$sql"); 191 $reslnew->execute(); 192 $sql="delete from ".$prefix."_ele_candidati where id_cons='$idcns'"; 193 $reslnew = $dbi->prepare("$sql"); 194 $reslnew->execute(); 195 $sql="delete from ".$prefix."_ele_voti_candidati where id_cons='$idcns'"; 196 $reslnew = $dbi->prepare("$sql"); 197 $reslnew->execute(); 198 $gruppo=''; 199 $numgruppo=1; 200 $lista=''; 201 $numlista=1;# echo "TEST1: ".count($filteredData); 202 foreach ($filteredData as $row){ 203 if($gruppo!=$row[0]){ 204 $gruppo=$row[0]; 205 $valori = $idcns.", null,'".$numgruppo."',".$dbi->quote($row[0]).",'','','0','0','',null,'','','0','0'"; 206 $sql="insert into ".$prefix."_ele_gruppo values($valori)";#echo "<br>TEST: $valori"; 207 try { 208 $res_gruppo = $dbi->prepare("$sql"); 209 $res_gruppo->execute(); 210 } 211 catch(PDOException $e) 212 { 213 ele(); 214 echo "<br>sql:".$sql . "<br>" . $e->getMessage(); 215 unset($valori); 216 die(); 217 } 218 $sql="select id_gruppo,num_gruppo from ".$prefix."_ele_gruppo where num_gruppo='".$numgruppo++."' and id_cons='$idcns'"; 219 $reslnew = $dbi->prepare("$sql"); 220 $reslnew->execute(); 221 list ($newidg,$newnumg) = $reslnew->fetch(PDO::FETCH_NUM); 222 unset($valori); 223 } 224 if($lista!=$row[1]){ 225 $lista=$row[1]; 226 $numcand=1; 227 $valori = $idcns.", null,'".$numlista."','$newidg','$newnumg','0','0',".$dbi->quote($row[1]).",'',null,''"; 228 $sql="insert into ".$prefix."_ele_lista values($valori)"; #echo "<br>TEST: $valori"; 229 try { 230 $res_lista = $dbi->prepare("$sql"); 231 $res_lista->execute(); 232 } 233 catch(PDOException $e) 234 { 235 ele(); 236 echo "<br>sql:".$sql . "<br>" . $e->getMessage(); 237 unset($valori); 238 die(); 239 } 240 241 $sql="select id_lista,num_lista from ".$prefix."_ele_lista where num_lista='".$numlista++."' and id_cons='$idcns'"; 242 $reslnew = $dbi->prepare("$sql"); 243 $reslnew->execute(); 244 list ($newidl,$newnuml) = $reslnew->fetch(PDO::FETCH_NUM); 245 unset($valori); 246 } 247 if(!isset($row[2])) continue; 248 $valori="null,'$idcns','$newidl','$newnuml',".$dbi->quote($row[2]).",'','','','".$numcand++."','','','0'"; 249 $sql="insert into ".$prefix."_ele_candidati values($valori)"; #die("VAL:$sql"); 250 try { 251 $res_lista = $dbi->prepare("$sql"); 252 $res_lista->execute(); 253 } 254 catch(PDOException $e) 255 { 256 ele(); 257 echo "<br>sql:".$sql . "<br>" . $e->getMessage(); 258 unset($valori); 259 die(); 260 } 261 unset($valori); 262 } 263 Header("Location: admin.php?op=gruppo&id_cons_gen=$id_cons_gen"); 264 } 265 ele(); 266 ?> 210 267 <?php if (empty($confermaDati) || $confermaDati === "no"): ?> 211 268 <?php $sql="SELECT tipo_cons FROM ".$prefix."_ele_consultazione where id_cons_gen=$id_cons_gen"; … … 306 363 <?php endif; ?> 307 364 308 <?php if ($confermaDati === "si"){309 $sql="delete from ".$prefix."_ele_gruppo where id_cons='$idcns'";310 $reslnew = $dbi->prepare("$sql");311 $reslnew->execute();312 $sql="delete from ".$prefix."_ele_voti_gruppo where id_cons='$idcns'";313 $reslnew = $dbi->prepare("$sql");314 $reslnew->execute();315 $sql="delete from ".$prefix."_ele_lista where id_cons='$idcns'";316 $reslnew = $dbi->prepare("$sql");317 $reslnew->execute();318 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$idcns'";319 $reslnew = $dbi->prepare("$sql");320 $reslnew->execute();321 $sql="delete from ".$prefix."_ele_candidati where id_cons='$idcns'";322 $reslnew = $dbi->prepare("$sql");323 $reslnew->execute();324 $sql="delete from ".$prefix."_ele_voti_candidati where id_cons='$idcns'";325 $reslnew = $dbi->prepare("$sql");326 $reslnew->execute();327 $gruppo='';328 $numgruppo=1;329 $lista='';330 $numlista=1;# echo "TEST1: ".count($filteredData);331 foreach ($filteredData as $row){332 if($gruppo!=$row[0]){333 $gruppo=$row[0];334 $valori = $idcns.", null,'".$numgruppo."',".$dbi->quote($row[0]).",'0','0','0','0','',null,'','','0'";335 $sql="insert into ".$prefix."_ele_gruppo values($valori)";#echo "<br>TEST: $valori";336 try {337 $res_gruppo = $dbi->prepare("$sql");338 $res_gruppo->execute();339 }340 catch(PDOException $e)341 {342 echo $sql . "<br>" . $e->getMessage();343 }344 $sql="select id_gruppo,num_gruppo from ".$prefix."_ele_gruppo where num_gruppo='".$numgruppo++."' and id_cons='$idcns'";345 $reslnew = $dbi->prepare("$sql");346 $reslnew->execute();347 list ($newidg,$newnumg) = $reslnew->fetch(PDO::FETCH_NUM);348 unset($valori);349 }350 if($lista!=$row[1]){351 $lista=$row[1];352 $numcand=1;353 $valori = $idcns.", null,'".$numlista."','$newidg','$newnumg','0','0',".$dbi->quote($row[1]).",'',null,''";354 $sql="insert into ".$prefix."_ele_lista values($valori)"; #echo "<br>TEST: $valori";355 try {356 $res_lista = $dbi->prepare("$sql");357 $res_lista->execute();358 }359 catch(PDOException $e)360 {361 echo $sql . "<br>" . $e->getMessage();362 }363 364 $sql="select id_lista,num_lista from ".$prefix."_ele_lista where num_lista='".$numlista++."' and id_cons='$idcns'";365 $reslnew = $dbi->prepare("$sql");366 $reslnew->execute();367 list ($newidl,$newnuml) = $reslnew->fetch(PDO::FETCH_NUM);368 unset($valori);369 }370 if(!isset($row[2])) continue;371 $valori="null,'$idcns','$newidl','$newnuml',".$dbi->quote($row[2]).",'','','','".$numcand++."','','','0'";372 $sql="insert into ".$prefix."_ele_candidati values($valori)"; #die("VAL:$sql");373 try {374 $res_lista = $dbi->prepare("$sql");375 $res_lista->execute();376 }377 catch(PDOException $e)378 {379 echo "<br>sql:".$sql . "<br>" . $e->getMessage();380 }381 unset($valori);382 }383 # Header("Location: admin.php?op=lista&id_cons_gen=$id_cons_gen");384 385 }386 387 ?>388 365 389 366 </body> -
trunk/admin/modules/Elezioni/ele.php
r472 r479 230 230 </td> 231 231 <td valign=\"top\">"; 232 if ($perms>32) { 233 #echo "<a href=\"admin.php?op=ws&id_cons_gen=$id_cons_gen&id_comune=$id_comune\">$bullet Webservices</a><br>";234 if($op=='ws' ) {232 if ($perms>32) { 233 echo "<a href=\"admin.php?op=ws&id_cons_gen=$id_cons_gen&id_comune=$id_comune\">$bullet Webservices</a><br>"; 234 if($op=='ws' and 0) { //disabilitata in attesa dello sviluppo delle funzioni 235 235 echo "<a href=\"admin.php?op=ws&funzione=recuperaEventiElettorali&id_cons_gen=$id_cons_gen&id_comune=$id_comune\">$bullet Consultazioni disponibili</a><br>";#die("TEST: $op"); 236 236 $sql="select * from ".$prefix."_ws_consultazione where id_cons='$id_cons'"; -
trunk/admin/versione.php
r478 r479 1 1 <?php 2 2 3 $versione = "3.0 rev 47 8";3 $versione = "3.0 rev 479"; 4 4 $version_number = $versione; 5 $datarel = " 16 giugno 2025";5 $datarel = "28 luglio 2025"; 6 6 $version = "Eleonline $version_number (<i>Data Release: $datarel</i>)"; 7 7 ?> -
trunk/client/versione.php
r478 r479 1 1 <?php 2 $versione = "3.0 rev 47 8";2 $versione = "3.0 rev 479"; 3 3 $version_number = $versione; 4 $datarel = " 16 giugno 2025";4 $datarel = "28 luglio 2025"; 5 5 $version = "Eleonline $version_number (<i>Data Release: $datarel</i>)"; 6 6 ?>
Note:
See TracChangeset
for help on using the changeset viewer.
