Changeset 327 for trunk/admin/modules/Elezioni/salva_ref.php

Timestamp:

Feb 14, 2020, 5:32:35 PM (5 years ago)

Author:

roby

Message:

Correzioni per la funzione di salvataggio dei dati dei referendum

File:

• trunk/admin/modules/Elezioni/salva_ref.php (modified) (1 diff)

trunk/admin/modules/Elezioni/salva_ref.php

@@ -43 +43 @@
 
 global $prefix,$id_parz,$fileout;
-$sql="select num_gruppo from ".$prefix."_ele_gruppo where id_cons='$id_cons' $circo ORDER BY num_gruppo  ";
-$result = $dbi->prepare("$sql");
-$result->execute();
-while(list($i)=$result->fetch(PDO::FETCH_BOTH)) {
-        $gruv="id_gruppo$i";$siv="si$i";$nov="no$i";$valv="val$i";$biav="bia$i";$conv="con$i";$nulv="nul$i";
-        if (isset($_GET[$gruv])) $id_gruppo[$i]=intval($_GET[$gruv]); else $id_gruppo[$i]='0';
-        if (isset($_GET[$siv])) $si[$i]=intval($_GET[$siv]); else $si[$i]='0';
-        if (isset($_GET[$nov])) $no[$i]=intval($_GET[$nov]); else $no[$i]='0';
-        if (isset($_GET[$valv])) $val[$i]=intval($_GET[$valv]); else $val[$i]='0';
-        if (isset($_GET[$biav])) $bia[$i]=intval($_GET[$biav]); else $bia[$i]='0';
-        if (isset($_GET[$conv])) $con[$i]=intval($_GET[$conv]); else $con[$i]='0';
-        if (isset($_GET[$nulv])) $nul[$i]=intval($_GET[$nulv]); else $nul[$i]='0';
-
-}
+$sql="select num_gruppo,id_gruppo from ".$prefix."_ele_gruppo where id_cons='$id_cons' ORDER BY num_gruppo  ";
+$resultg = $dbi->prepare("$sql");
+$resultg->execute();
 
 if (!isset($fileout)) $fileout='';
-#if(($voti_u+$voti_d) and !$voti_t) $voti_t=$voti_u+$voti_d;
+
 if ($fileout) while (!$fp = fopen($fileout,"a"));
 
 ##################
         if($do==1) {
-                $sql="delete from ".$prefix."_ele_gruppo where id_cons='$id_cons'";
+                $sql="delete from ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez=$id_sez";
                 $res = $dbi->prepare("$sql");
                 $res->execute();
         }else{
+                while(list($i,$idgruppo)=$resultg->fetch(PDO::FETCH_BOTH)) {
+                        $gruv="id_gruppo$i";$siv="si$i";$nov="no$i";$valv="val$i";$biav="bia$i";$conv="con$i";$nulv="nul$i";
+                        if (isset($_GET[$gruv])) $id_gruppo[$i]=intval($_GET[$gruv]); else $id_gruppo[$i]='0';
+                        if (isset($_GET[$siv])) $si[$i]=intval($_GET[$siv]); else $si[$i]='0';
+                        if (isset($_GET[$nov])) $no[$i]=intval($_GET[$nov]); else $no[$i]='0';
+                        if (isset($_GET[$valv])) $val[$i]=intval($_GET[$valv]); else $val[$i]='0';
+                        if (isset($_GET[$biav])) $bia[$i]=intval($_GET[$biav]); else $bia[$i]='0';
+                        if (isset($_GET[$conv])) $con[$i]=intval($_GET[$conv]); else $con[$i]='0';
+                        if (isset($_GET[$nulv])) $nul[$i]=intval($_GET[$nulv]); else $nul[$i]='0';
 
-                $sql="select num_gruppo from ".$prefix."_ele_gruppo where id_cons='$id_cons'";
-                $result = $dbi->prepare("$sql");
-                $result->execute();
-                if($result->rowCount()) {
-                        while(list($i)=$result->fetch(PDO::FETCH_NUM)){
+                        $sql="select num_gruppo from ".$prefix."_ele_voti_ref where id_gruppo='$idgruppo'  and id_sez=$id_sez";
+                        $result = $dbi->prepare("$sql");
+                        $result->execute();
+                        if($result->rowCount()) {
                                 $sql="update  ".$prefix."_ele_voti_ref set si='".$si[$i]."',no='".$no[$i]."',validi='".$val[$i]."',bianchi='".$bia[$i]."',contestati='".$con[$i]."',nulli='".$nul[$i]."' where id_cons='$id_cons' and id_sez='$id_sez' and id_gruppo='".$id_gruppo[$i]."'";
                                 $res = $dbi->prepare("$sql");
                                 $res->execute();
-                        }
-                }else{
-                        $sql="select num_gruppo,id_gruppo from ".$prefix."_ele_gruppo where id_cons='$id_cons'";
-                        $result = $dbi->prepare("$sql");
-                        $result->execute();
-                        while(list($i,$id_gruppo)=$result->fetch(PDO::FETCH_NUM)){
-                                $sql="insert into  ".$prefix."_ele_voti_ref values('$id_cons','$id_gruppo','$id_sez','$i','".$si[$i]."','".$no[$i]."','".$val[$i]."','".$bia[$i]."','".$con[$i]."','".$nul[$i]."')";
+                        }else{
+                                $sql="insert into  ".$prefix."_ele_voti_ref values('$id_cons','$idgruppo','$id_sez','$i','".$si[$i]."','".$no[$i]."','".$val[$i]."','".$nul[$i]."','".$bia[$i]."','".$con[$i]."')";  
                                 $res = $dbi->prepare("$sql");
                                 $res->execute();
+                        
                         }
-                        
                 }
 }