false, PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); $sql = "use $dbname"; $dbi->exec($sql); } catch(PDOException $e) { echo $sql . "
" . $e->getMessage(); } if (isset($_GET['id_cons_gen'])) $id_cons_gen=intval($_GET['id_cons_gen']); else $id_cons_gen='0'; if (isset($_GET['op'])) $op=intval($_GET['op']); else $op='0'; if (isset($_GET['id_circ'])) $id_circ=intval($_GET['id_circ']); else $id_circ='0'; if (isset($_GET['id_sez'])) $id_sez=intval($_GET['id_sez']); else $id_sez=''; if (isset($_GET['id_sede'])) $id_sede=intval($_GET['id_sede']); else $id_sede='0'; if (isset($_GET['voti_u'])) $voti_u=intval($_GET['voti_u']); else $voti_u='0'; if (isset($_GET['voti_d'])) $voti_d=intval($_GET['voti_d']); else $voti_d='0'; if (isset($_GET['voti_t'])) $voti_t=intval($_GET['voti_t']); else $voti_t='0'; if (isset($_GET['orario'])) get_magic_quotes_gpc() ? $orario=$_GET['orario']:$orario=addslashes($_GET['orario']); else $orario=''; if (isset($_GET['data'])) get_magic_quotes_gpc() ? $data=$_GET['data']:$data=addslashes($_GET['data']); else $data='01-01-1900'; if (isset($_GET['id_comune'])) $id_comune=intval($_GET['id_comune']); else $id_comune='0'; if (isset($_GET['id_gruppo'])) $id_gruppo=intval($_GET['id_gruppo']); else $id_gruppo='0'; if (isset($_GET['delete'])) get_magic_quotes_gpc() ? $delete=$_GET['delete']:$delete=addslashes($_GET['delete']); else $delete=''; global $prefix,$id_parz,$tempo,$username,$aid,$dbi,$genere; /* ############ $sql="SELECT orario,data FROM ".$prefix."_ele_rilaff where id_cons_gen=$id_cons_gen order by data,orario "; $res = $dbi->prepare("$sql"); $res->execute(); $num = $res->rowCount(); $y=0; while(list($i,$a)=$result->fetch(PDO::FETCH_BOTH)) { $y++; $sql="SELECT * FROM ".$prefix."_ele_gruppo where id_cons='$id_cons' "; $res2 = $dbi->prepare("$sql"); $res2->execute(); for($i=1;$i<=$max;$i++){ $idg="id_gruppo$i";$vnp="vnpl$i";$slp="slpl$i";$idlist="id_lista$i"; if (isset($_GET[$vnp])) $vnpl[$i]=intval($_GET[$vnp]); else $vnpl[$i]='0'; if (isset($_GET[$vot])) $voti[$i]=intval($_GET[$vot]); else $voti[$i]='0'; if (isset($_GET[$slp])) $slpl[$i]=intval($_GET[$slp]); else $slpl[$i]='0'; if (isset($_GET[$idlist])) $idlista[$i]=intval($_GET[$idlist]); else $idlista[$i]='0'; $sololiste+=$slpl[$i]; } } ############# */ if (!isset($fileout)) $fileout=''; if(($voti_u+$voti_d) and !$voti_t) $voti_t=$voti_u+$voti_d; $salvato=0; $query="select id_cons from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' and id_comune='$id_comune'"; $res = $dbi->prepare("$query"); $res->execute(); $BASE=substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['REQUEST_URI'], "/")-16); list($id_cons)=$res->fetch(PDO::FETCH_NUM); $query="select id_parz from ".$prefix."_ele_voti_parziale where data='$data' and orario='$orario' and id_sez='$id_sez' and id_gruppo='$id_gruppo'"; $res = $dbi->prepare("$query"); $res->execute(); $righe=$res->rowCount(); list($id_parz)=$res->fetch(PDO::FETCH_NUM); if($righe){ #la riga è presente e viene aggiorata $arr=$res->fetch(PDO::FETCH_BOTH); $sql="update ".$prefix."_ele_voti_parziale set voti_uomini='$voti_u',voti_donne='$voti_d',voti_complessivi='$voti_t' where id_parz='$id_parz'"; $compl = $dbi->prepare("$sql"); $compl->execute(); if($compl->rowCount()) $salvato=1; if($delete=="true"){ $sql="delete from ".$prefix."_ele_voti_parziale where id_parz='$id_parz'"; $res = $dbi->prepare("$sql"); $res->execute(); if($res->rowCount()) $salvato=1; } }else{ # è un nuovo inserimento $sql="insert into ".$prefix."_ele_voti_parziale values ('$id_cons', '$id_sez','','$orario','$data','$voti_u','$voti_d','$voti_t','$id_gruppo')"; $res = $dbi->prepare("$sql"); $res->execute(); if($res->rowCount()) $salvato=1; } if ($fileout) { while (!$fp = fopen($fileout,"a")); fwrite($fp,"$sql;\n"); fclose($fp); } if($salvato){ $riga=addslashes($sql); $sqlog="insert into ".$prefix."_ele_log values('$id_cons','$id_sez','$username','$data','$orario','','$riga','".$prefix."_ele_voti_parziale')"; $res = $dbi->prepare("$sqlog"); $res->execute(); } controllo_aff($id_cons,$id_sez,$id_parz); 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&ops=1&do=spoglio"); function controllo_aff($id_cons,$id_sez,$id_parz){ global $prefix,$dbi,$id_sede,$id_con_gen; ############################## # $sql="select * from ".$prefix."_ele_controllosez where id_cons='$id_cons' and id_sez='$id_sez'"; # $resc = $dbi->prepare("$sql"); # $resc->execute(); # $conta=$resc->rowCount(); $err=0; # $err2=0; $sql="select maschi,femmine from ".$prefix."_ele_sezioni where id_sez='$id_sez'"; $res = $dbi->prepare("$sql"); $res->execute(); list($maschi,$femmine)=$res->fetch(PDO::FETCH_NUM); $sql="select voti_uomini,voti_donne,voti_complessivi from ".$prefix."_ele_voti_parziale where id_sez='$id_sez' and id_parz='$id_parz'"; $res = $dbi->prepare("$sql"); $res->execute(); while(list($voti_u,$voti_d,$voti_t)=$res->fetch(PDO::FETCH_NUM)) if(($voti_u+$voti_d!=$voti_t || $voti_u>$maschi || $voti_d>$femmine) and ($voti_u+$voti_d>0)) {$err=1; break;} /* if($conta){ $aff=$resc->fetch(PDO::FETCH_BOTH); if($aff['status']) if ($aff['stato_val'] || $aff['stato_lis'] || $aff['stato_gru'] || $aff['stato_can']) $err2=1; } if($conta && !$err2) { $sql="update ".$prefix."_ele_controllosez set stato_aff='$err',status='$err' where id_cons='$id_cons' and id_sez='$id_sez'"; $res = $dbi->prepare("$sql"); $res->execute(); } elseif($conta && !$err){ $sql="update ".$prefix."_ele_controllosez set stato_aff='$err' where id_cons='$id_cons' and id_sez='$id_sez'"; $res = $dbi->prepare("$sql"); $res->execute(); return; } else { $sql="insert into ".$prefix."_ele_controllosez values ('$id_sez','$id_cons','$err','0','0','0','0','$err')"; $res = $dbi->prepare("$sql"); $res->execute(); }*/ ####################### $tipo='affluenze'; $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez' "; $res = $dbi->prepare("$sql"); $res->execute(); $righe=$res->rowCount(); if($righe){ while(list($id)=$res->fetch(PDO::FETCH_NUM)){ if($id==$id_parz){ if(!$err){ $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_parz' "; $res = $dbi->prepare("$sql"); $res->execute(); } $err=0; break; } } } if($err){ $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_parz')"; $res = $dbi->prepare("$sql"); $res->execute(); } ####################### include("ele_colora_sez.php"); } ?>