Changeset 326 for trunk

Timestamp:

Feb 8, 2020, 2:46:19 PM (4 years ago)

Author:

roby

Message:

Corrette le funzioni di registrazione e controllo dei voti per i referendum

Location:

trunk/admin/modules/Elezioni

Files:

• ele_controlli.php (modified) (3 diffs)
• salva_ref.php (modified) (2 diffs)

trunk/admin/modules/Elezioni/ele_controlli.php

@@ -191 +191 @@
         global $prefix,$dbi,$id_sede,$id_cons_gen,$genere;
                 ##############################
-        $err=0; $err2=0;
+        $err=0; $err2=0; $idrg=0;
         $sql="SELECT id_gruppo FROM ".$prefix."_ele_gruppo where id_cons='$id_cons'";
         $resref = $dbi->prepare("$sql");
@@ -209 +209 @@
                 if(($si+$no==$validi) and ($validi+$nulli+$bianchi+$contestati==$voti)) 
                         continue;
-                else {$err=1; break;}   
-
-        
+                else {$err=1; $idrg=$idrefgruppo; break;}       
+
+        }
 
 #############
                 $tipo='referendum';
-                $sql="select id from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez' and id='$idrefgruppo' ";
+                $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){
-                        if(!$err){ 
-                                $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id='$id_sez' ";
+                        if(!$err){
+                                $sql="delete from ".$prefix."_ele_controlli where tipo='$tipo' and id_sez='$id_sez' ";
                                 $res = $dbi->prepare("$sql");
                                 $res->execute();
@@ -228 +228 @@
                 }
                 if($err){
-                        $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$id_sez')";
+                        $sql="insert into ".$prefix."_ele_controlli value('$id_cons','$id_sez','$tipo','$idrg')";
                         $res = $dbi->prepare("$sql");
                         $res->execute();                
                 }
 #############
-        }
 
 }

trunk/admin/modules/Elezioni/salva_ref.php

@@ -38 +38 @@
 if (isset($_GET['votinulli'])) $votinulli=intval($_GET['votinulli']); else $votinulli='0';
 if (isset($_GET['id_comune'])) $id_comune=intval($_GET['id_comune']); else $id_comune='0';
-if (isset($_GET['ops'])) $ops=intval($_GET['ops']); else $ops='0';
+if (isset($_GET['ops'])) $ops=intval($_GET['ops']); else $ops='4';
 if (isset($_GET['delete'])) $delete=intval($_GET['delete']); else $delete='';
 if (isset($_GET['circo'])) get_magic_quotes_gpc() ? $circo=$_GET['circo']:$circo=addslashes($_GET['circo']); else $circo='';
@@ -64 +64 @@
 ##################
         if($do==1) {
-                $sql="delete from ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez'";
+                $sql="delete from ".$prefix."_ele_gruppo where id_cons='$id_cons'";
                 $res = $dbi->prepare("$sql");
                 $res->execute();
         }else{
 
-                $sql="select num_gruppo from ".$prefix."_ele_voti_ref where id_cons='$id_cons' and id_sez='$id_sez'";
+                $sql="select num_gruppo from ".$prefix."_ele_gruppo where id_cons='$id_cons'";
                 $result = $dbi->prepare("$sql");
                 $result->execute();