Changeset 407 for trunk/admin/modules/Elezioni/salva_liste.php
- Timestamp:
- Mar 5, 2024, 10:09:23 PM (2 months ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/salva_liste.php
r360 r407 50 50 51 51 global $prefix,$id_parz,$fileout; 52 $sql="SELECT tipo_cons FROM ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'";52 $sql="SELECT chiusa FROM ".$prefix."_ele_cons_comune where id_cons='$id_cons' "; 53 53 $res = $dbi->prepare("$sql"); 54 54 $res->execute(); 55 list($tipo_cons) = $res->fetch(PDO::FETCH_NUM); 56 $sql="SELECT circo FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' "; 57 $res = $dbi->prepare("$sql"); 58 $res->execute(); 59 list($circo)=$res->fetch(PDO::FETCH_NUM); 60 if ($circo) $iscirco="and id_circ=$id_circ"; else $iscirco=''; 61 if($id_lista){ 62 $sql="select num_cand,id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista' ORDER BY num_cand "; 63 $result = $dbi->prepare("$sql"); 64 $result->execute(); 65 while(list($i,$y)=$result->fetch(PDO::FETCH_NUM)) { 66 $vot="voti$i";$cand="id_cand$i"; 67 if (isset($_GET[$cand])) $idcand[$i]=intval($_GET[$cand]); else $idcand[$i]=$y; 68 if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0'; 69 # if (isset($_GET[$solo])) $solog[$i]=intval($_GET[$solo]); else $solog[$i]='0'; 55 list($chiusa)=$res->fetch(PDO::FETCH_NUM); 56 if(!$chiusa){ 57 $sql="SELECT tipo_cons FROM ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'" ; 58 $res = $dbi->prepare("$sql"); 59 $res->execute(); 60 list($tipo_cons) = $res->fetch(PDO::FETCH_NUM); 61 $sql="SELECT circo FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' "; 62 $res = $dbi->prepare("$sql"); 63 $res->execute(); 64 list($circo)=$res->fetch(PDO::FETCH_NUM); 65 if ($circo) $iscirco="and id_circ=$id_circ"; else $iscirco=''; 66 if($id_lista){ 67 $sql="select num_cand,id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista' ORDER BY num_cand "; 68 $result = $dbi->prepare("$sql"); 69 $result->execute(); 70 while(list($i,$y)=$result->fetch(PDO::FETCH_NUM)) { 71 $vot="voti$i";$cand="id_cand$i"; 72 if (isset($_GET[$cand])) $idcand[$i]=intval($_GET[$cand]); else $idcand[$i]=$y; 73 if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0'; 74 # if (isset($_GET[$solo])) $solog[$i]=intval($_GET[$solo]); else $solog[$i]='0'; 70 75 76 } 77 }else{ 78 $sql="select num_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco ORDER BY num_lista "; 79 $result = $dbi->prepare("$sql"); 80 $result->execute(); 81 $sololiste=0; 82 while(list($i)=$result->fetch(PDO::FETCH_NUM)) { 83 $vot="voti$i";$vnp="vnpl$i";$slp="slpl$i";$idlist="id_lista$i"; 84 if (isset($_GET[$vnp])) $vnpl[$i]=intval($_GET[$vnp]); else $vnpl[$i]='0'; 85 if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0'; 86 if (isset($_GET[$slp])) $slpl[$i]=intval($_GET[$slp]); else $slpl[$i]='0'; 87 if (isset($_GET[$idlist])) $idlista[$i]=intval($_GET[$idlist]); else $idlista[$i]='0'; 88 $sololiste+=$slpl[$i]; 89 } 71 90 } 72 }else{ 73 $sql="select num_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco ORDER BY num_lista "; 74 $result = $dbi->prepare("$sql"); 75 $result->execute(); 76 $sololiste=0; 77 while(list($i)=$result->fetch(PDO::FETCH_NUM)) { 78 $vot="voti$i";$vnp="vnpl$i";$slp="slpl$i";$idlist="id_lista$i"; 79 if (isset($_GET[$vnp])) $vnpl[$i]=intval($_GET[$vnp]); else $vnpl[$i]='0'; 80 if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0'; 81 if (isset($_GET[$slp])) $slpl[$i]=intval($_GET[$slp]); else $slpl[$i]='0'; 82 if (isset($_GET[$idlist])) $idlista[$i]=intval($_GET[$idlist]); else $idlista[$i]='0'; 83 $sololiste+=$slpl[$i]; 84 } 85 } 86 if (!isset($fileout)) $fileout=''; 87 #if(($voti_u+$voti_d) and !$voti_t) $voti_t=$voti_u+$voti_d; 88 if ($fileout) while (!$fp = fopen($fileout,"a")); 91 if (!isset($fileout)) $fileout=''; 92 #if(($voti_u+$voti_d) and !$voti_t) $voti_t=$voti_u+$voti_d; 93 if ($fileout) while (!$fp = fopen($fileout,"a")); 89 94 90 ##################91 # if($id_lista){95 ################## 96 # if($id_lista){ 92 97 93 #$andlis="and 94 if($pwd3==1) { 95 if($id_lista) $condiz="and id_cand in (select id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista')"; else $condiz=''; 96 $sql="delete from ".$prefix."_ele_voti_candidati where id_sez='$id_sez' $condiz"; 97 $res = $dbi->prepare("$sql"); 98 $res->execute(); 99 $sql="delete from ".$prefix."_ele_controlli where tipo='candidato' and id_sez='$id_sez' "; 100 $res = $dbi->prepare("$sql"); 101 $res->execute(); 102 if(!$id_lista){ 103 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 98 #$andlis="and 99 if($pwd3==1) { 100 if($id_lista) $condiz="and id_cand in (select id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista')"; else $condiz=''; 101 $sql="delete from ".$prefix."_ele_voti_candidati where id_sez='$id_sez' $condiz"; 104 102 $res = $dbi->prepare("$sql"); 105 103 $res->execute(); 106 $sql="delete from ".$prefix."_ele_controlli where tipo=' lista' and id_sez='$id_sez' ";104 $sql="delete from ".$prefix."_ele_controlli where tipo='candidato' and id_sez='$id_sez' "; 107 105 $res = $dbi->prepare("$sql"); 108 106 $res->execute(); 109 $sql="update ".$prefix."_ele_sezioni set validi_lista='0',contestati_lista='0',voti_nulli_lista='0',solo_gruppo='0',solo_lista='0' where id_cons='$id_cons' and id_sez='$id_sez'"; 110 $res = $dbi->prepare("$sql"); 111 $res->execute(); 112 } 113 114 }elseif($id_lista){ 107 if(!$id_lista){ 108 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 109 $res = $dbi->prepare("$sql"); 110 $res->execute(); 111 $sql="delete from ".$prefix."_ele_controlli where tipo='lista' and id_sez='$id_sez' "; 112 $res = $dbi->prepare("$sql"); 113 $res->execute(); 114 $sql="update ".$prefix."_ele_sezioni set validi_lista='0',contestati_lista='0',voti_nulli_lista='0',solo_gruppo='0',solo_lista='0' where id_cons='$id_cons' and id_sez='$id_sez'"; 115 $res = $dbi->prepare("$sql"); 116 $res->execute(); 117 } 118 119 }elseif($id_lista){ 115 120 116 foreach($idcand as $idkey=>$idc){ 117 $sql="select num_cand from ".$prefix."_ele_voti_candidati where id_sez='$id_sez' and id_cand='$idc'"; 118 $result = $dbi->prepare("$sql"); 119 $result->execute(); 120 if($result->rowCount()) 121 $sql="update ".$prefix."_ele_voti_candidati set voti='".$voti[$idkey]."' where id_sez='$id_sez' and id_cand='$idc'"; 122 else 123 $sql="insert into ".$prefix."_ele_voti_candidati values('$id_cons','$idc','$id_sez','$idkey','".$voti[$idkey]."')"; 124 $result = $dbi->prepare("$sql"); 125 $result->execute(); 126 } 127 }else{ 128 $sql="update ".$prefix."_ele_sezioni set validi_lista='$validi',contestati_lista='$contestati',voti_nulli_lista='$votinulli',solo_gruppo='$sg' where id_cons='$id_cons' and id_sez='$id_sez'"; 129 $res = $dbi->prepare("$sql"); 130 $res->execute(); 131 $sql="select num_lista,id_lista from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 132 $result = $dbi->prepare("$sql"); 133 $result->execute(); 134 if($result->rowCount()){ 135 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 121 foreach($idcand as $idkey=>$idc){ 122 $sql="select num_cand from ".$prefix."_ele_voti_candidati where id_sez='$id_sez' and id_cand='$idc'"; 136 123 $result = $dbi->prepare("$sql"); 137 124 $result->execute(); 138 while(list($i,$idl)=$result->fetch(PDO::FETCH_NUM)){ 139 $sql="update ".$prefix."_ele_voti_lista set num_lista='$i',voti='".$voti[$i]."',nulli_lista='".$vnpl[$i]."',solo_lista='".$slpl[$i]."' where num_lista='$i' and id_sez='$id_sez'"; 140 $res = $dbi->prepare("$sql"); 141 $res->execute(); 142 } 143 144 }else{ 145 146 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 125 if($result->rowCount()) 126 $sql="update ".$prefix."_ele_voti_candidati set voti='".$voti[$idkey]."' where id_sez='$id_sez' and id_cand='$idc'"; 127 else 128 $sql="insert into ".$prefix."_ele_voti_candidati values('$id_cons','$idc','$id_sez','$idkey','".$voti[$idkey]."')"; 147 129 $result = $dbi->prepare("$sql"); 148 130 $result->execute(); 149 while(list($i,$idl)=$result->fetch(PDO::FETCH_NUM)){ 150 $sql="insert into ".$prefix."_ele_voti_lista values('$id_cons','$idl','$id_sez','$i','".$voti[$i]."','".$vnpl[$i]."','".$slpl[$i]."')"; 151 $res = $dbi->prepare("$sql"); 152 $res->execute(); 131 } 132 }else{ 133 $sql="update ".$prefix."_ele_sezioni set validi_lista='$validi',contestati_lista='$contestati',voti_nulli_lista='$votinulli',solo_gruppo='$sg' where id_cons='$id_cons' and id_sez='$id_sez'"; 134 $res = $dbi->prepare("$sql"); 135 $res->execute(); 136 $sql="select num_lista,id_lista from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 137 $result = $dbi->prepare("$sql"); 138 $result->execute(); 139 if($result->rowCount()){ 140 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 141 $result = $dbi->prepare("$sql"); 142 $result->execute(); 143 while(list($i,$idl)=$result->fetch(PDO::FETCH_NUM)){ 144 $sql="update ".$prefix."_ele_voti_lista set num_lista='$i',voti='".$voti[$i]."',nulli_lista='".$vnpl[$i]."',solo_lista='".$slpl[$i]."' where num_lista='$i' and id_sez='$id_sez'"; 145 $res = $dbi->prepare("$sql"); 146 $res->execute(); 147 } 148 149 }else{ 150 151 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 152 $result = $dbi->prepare("$sql"); 153 $result->execute(); 154 while(list($i,$idl)=$result->fetch(PDO::FETCH_NUM)){ 155 $sql="insert into ".$prefix."_ele_voti_lista values('$id_cons','$idl','$id_sez','$i','".$voti[$i]."','".$vnpl[$i]."','".$slpl[$i]."')"; 156 $res = $dbi->prepare("$sql"); 157 $res->execute(); 158 } 153 159 } 154 } 155 } 156 157 158 159 include("ele_controlli.php"); 160 controllo_votil($id_cons,$id_sez,$id_lista); 161 include("ele_colora_sez.php"); 162 163 if ($fileout) fclose($fp); 160 } 161 include("ele_controlli.php"); 162 controllo_votil($id_cons,$id_sez,$id_lista); 163 include("ele_colora_sez.php"); 164 if ($fileout) fclose($fp); 165 } 164 166 $BASE=substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['REQUEST_URI'], "/")-16); 165 167 Header("Location: ".$BASE."admin.php?op=voti&id_cons_gen=$id_cons_gen&id_circ=$id_circ&id_sede=$id_sede&id_sez=$id_sez&do=spoglio&ops=$ops"); 166 168 167 168 169 170 169 ################################# 171 172 173 174 175 176 177 178 170 ?>
Note:
See TracChangeset
for help on using the changeset viewer.