Changeset 259 for trunk/admin/modules/Elezioni/salva_liste.php
- Timestamp:
- Apr 5, 2019, 9:26:39 PM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/salva_liste.php
r258 r259 197 197 198 198 } 199 $sql="select * from ".$prefix."_ele_controllosez where id_cons='$id_cons' and id_sez='$id_sez'"; 200 $resc = $dbi->prepare("$sql"); 201 $resc->execute(); 202 $aff=$resc->fetch(PDO::FETCH_BOTH); 203 if($id_lista) {$cur=$aff['stato_lis']; $campo='stato_can';} else {$curr=$aff['stato_can']; $campo='stato_lis';} 204 if($aff['status']) { 205 if ($aff['stato_aff'] ||$curr || $aff['stato_gru'] || $aff['stato_val']) { 206 $sql="update ".$prefix."_ele_controllosez set $campo='$err' where id_cons='$id_cons' and id_sez='$id_sez'"; 207 $res = $dbi->prepare("$sql");include("$sql"); 208 $res->execute(); 209 }else{ 210 $sql="update ".$prefix."_ele_controllosez set $campo='$err',status='$err' where id_cons='$id_cons' and id_sez='$id_sez'"; 199 200 $tipo='lista'; 201 $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez'"; 202 $res = $dbi->prepare("$sql"); 203 $res->execute(); 204 $righe=$res->rowCount(); 205 if($righe){ 206 if(!$err){ 207 $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' "; 211 208 $res = $dbi->prepare("$sql"); 212 209 $res->execute(); 213 210 } 214 215 } 216 if($err || $aff['status']) 217 $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: #FF3300;' where id_cons='$id_cons' and id_sez='$id_sez'"; #ROSSO 218 else { 219 $col="#F0E68C;"; 220 $sql="select id_cand from ".$prefix."_ele_voti_candidati where id_sez='$id_sez' group by id_cand"; 221 $res = $dbi->prepare("$sql"); 222 $res->execute(); 223 $vv=$res->rowCount(); 224 $sql="select id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons'"; 225 $res = $dbi->prepare("$sql"); 226 $res->execute(); 227 $vvt=$res->rowCount(); 228 if($vvt=$vv) $col="#32CD32;"; #"LIMEGREEN" colore se finito l'inserimento dei voti ai candidati 229 else{ 230 $sql="select id_lista from ".$prefix."_ele_voti_lista where id_sez='$id_sez' group by id_lista"; 231 $res = $dbi->prepare("$sql"); 232 $res->execute(); 233 $vv=$res->rowCount(); 234 $sql="select id_lista from ".$prefix."_ele_lista where id_cons='id_cons'"; 235 $res = $dbi->prepare("$sql"); 236 $res->execute(); 237 $vvt=$res->rowCount(); 238 if($vvt=$vv) $col="#F0E68C;"; #"KHAKY" colore se finito l'inserimento dei voti alle liste 239 } 240 $sql="UPDATE ".$prefix."_ele_sezioni set colore='style=\" background: $col' where id_cons='$id_cons' and id_sez='$id_sez'"; 241 } 242 $res = $dbi->prepare("$sql"); 243 $res->execute(); 211 $err=0; 212 } 213 if($err){ 214 $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')"; 215 $res = $dbi->prepare("$sql"); 216 $res->execute(); 217 } 218 include("ele_colora_sez.php"); 219 220 221 222 244 223 245 224 }
Note:
See TracChangeset
for help on using the changeset viewer.