Changeset 262 for trunk/admin/modules/Elezioni/salva_liste.php
- Timestamp:
- Apr 7, 2019, 5:16:46 PM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/salva_liste.php
r260 r262 88 88 $res = $dbi->prepare("$sql"); 89 89 $res->execute(); 90 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 91 $res = $dbi->prepare("$sql"); 92 $res->execute(); 93 $sql="delete from ".$prefix."_ele_controlli where tipo='lista' and id_sez='$id_sez' "; 94 $res = $dbi->prepare("$sql"); 95 $res->execute(); 96 $sql="update ".$prefix."_ele_sezioni set validi_lista='',contestati_lista='',voti_nulli_lista='',solo_gruppo='',solo_lista='' where id_cons='$id_cons' and id_sez='$id_sez'"; 97 $res = $dbi->prepare("$sql"); 98 $res->execute(); 90 if(!$id_lista){ 91 $sql="delete from ".$prefix."_ele_voti_lista where id_cons='$id_cons' and id_sez='$id_sez'"; 92 $res = $dbi->prepare("$sql"); 93 $res->execute(); 94 $sql="delete from ".$prefix."_ele_controlli where tipo='lista' and id_sez='$id_sez' "; 95 $res = $dbi->prepare("$sql"); 96 $res->execute(); 97 $sql="update ".$prefix."_ele_sezioni set validi_lista='',contestati_lista='',voti_nulli_lista='',solo_gruppo='',solo_lista='' where id_cons='$id_cons' and id_sez='$id_sez'"; 98 $res = $dbi->prepare("$sql"); 99 $res->execute(); 100 } 99 101 100 102 }elseif($id_lista){ … … 149 151 150 152 151 153 include("ele_controlli.php"); 152 154 controllo_votil($id_cons,$id_sez,$id_lista); 153 155 include("ele_colora_sez.php"); 156 154 157 if ($fileout) fclose($fp); 155 158 $BASE=substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['REQUEST_URI'], "/")-16); … … 161 164 162 165 163 function controllo_votil($id_cons,$id_sez,$id_lista){164 global $prefix,$dbi,$id_sede,$id_cons_gen,$validi;165 ##############################166 $err=0; $err2=0;167 if($id_lista){168 $sql="SELECT preferenze FROM ".$prefix."_ele_cons_comune where id_cons='$id_cons'";169 $res = $dbi->prepare("$sql");170 $res->execute();171 list($prefs)=$res->fetch(PDO::FETCH_NUM);172 $sql="select voti from ".$prefix."_ele_voti_lista where id_lista='$id_lista' and id_sez='$id_sez'";173 $res = $dbi->prepare("$sql");174 $res->execute();175 list($votil)=$res->fetch(PDO::FETCH_NUM);176 $sql="SELECT sum(voti),max(voti) FROM ".$prefix."_ele_voti_candidati where id_sez='$id_sez' and id_cand in (select id_cand from ".$prefix."_ele_candidati where id_lista='$id_lista')";177 $res = $dbi->prepare("$sql");178 $res->execute();179 list($votic,$mvc)=$res->fetch(PDO::FETCH_NUM);180 if(($votic*$prefs)>$votil || $mvc>$votil)181 $err=1;182 }else{183 $sql="select id_gruppo from ".$prefix."_ele_lista where id_lista='$id_lista'";184 $res = $dbi->prepare("$sql");185 $res->execute();186 list($idg)=$res->fetch(PDO::FETCH_NUM);187 $sql="SELECT id_gruppo, voti, solo_gruppo FROM ".$prefix."_ele_voti_gruppo where id_sez='$id_sez'";188 $resref = $dbi->prepare("$sql");189 $resref->execute();190 $totlis=0;191 $totgru=0;192 $totsg=0;193 $totsl=0;194 $sql="SELECT validi,validi_lista,contestati_lista,voti_nulli_lista,solo_lista FROM ".$prefix."_ele_sezioni where id_cons='$id_cons' and id_sez='$id_sez'";195 $res = $dbi->prepare("$sql");196 $res->execute();197 list($votiv,$validil,$contestatil,$nullil,$solol) = $res->fetch(PDO::FETCH_NUM);198 while (list($idg,$votig,$svg)=$resref->fetch(PDO::FETCH_NUM)) {199 $sql="SELECT sum(voti), sum(solo_lista) FROM ".$prefix."_ele_voti_lista where id_sez='$id_sez' and id_lista in (select id_lista from ".$prefix."_ele_lista where id_gruppo='$idg')";200 $res2 = $dbi->prepare("$sql");201 $res2->execute();202 $totgru+=$votig;203 $totsg+=$svg;204 if($res2->rowCount()){205 list($votil,$svl)=$res2->fetch(PDO::FETCH_NUM);206 $totlis+=$votil;207 $totsl+=$svl;208 if(($votig+$svl)<($votil+$svg))209 $err=1;210 }211 212 }213 if ($validil+$contestatil+$nullil+$solol+$totsg!=$votiv and $validil+$contestatil+$nullil+$solol>0) $err=1;214 }215 216 $tipo='lista';217 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez'";218 $res = $dbi->prepare("$sql");219 $res->execute();220 $righe=$res->rowCount();221 if($righe){222 if(!$err){223 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' ";224 $res = $dbi->prepare("$sql");225 $res->execute();226 }227 $err=0;228 }229 if($err){230 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')";231 $res = $dbi->prepare("$sql");232 $res->execute();233 }234 include("ele_colora_sez.php");235 236 166 237 167 238 239 240 }241 242 168 ?>
Note:
See TracChangeset
for help on using the changeset viewer.