Changeset 366 for trunk/admin/modules/Elezioni

Timestamp:

May 15, 2022, 10:18:37 PM (3 years ago)

Author:

roby

Message:

Modifiche in admin:

• Modificata la funzione di assegnazione dei permessi per semplificare la gestione degli election day.
• Eliminati alcuni warning nella gestione di più referendum

Location:

trunk/admin/modules/Elezioni

Files:

• ele_permessi.php (modified) (1 diff)
• ele_spoglio.php (modified) (1 diff)
• salva_ref.php (modified) (1 diff)

trunk/admin/modules/Elezioni/ele_permessi.php

@@ -200 +200 @@
         if ($perms>32 and $permessi<$perms and $aid2) {
                 if ($do == "autorizza") {
-                        $sql="insert into ".$prefix."_ele_operatori (id_cons,id_sede,id_comune,permessi,aid,id_sez) values ('$id_cons','$id_sede','$id_comune','$permessi','$aid2','$id_sez')";
+                        $sql="select num_sez from ".$prefix."_ele_sezioni where id_sez='$id_sez'";
                         $res = $dbi->prepare("$sql");
-                        $res->execute();                                
+                        $res->execute();
+                        list ($num_sez)=$res->fetch(PDO::FETCH_NUM);                    
+                        $sql="select data_inizio from ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'";
+                        $compl = $dbi->prepare("$sql");
+                        $compl->execute();
+                        list ($datarif)= $compl->fetch(PDO::FETCH_NUM);                 
+                        $sql="select id_cons from ".$prefix."_ele_cons_comune where id_comune='$id_comune' and id_cons_gen in (select id_cons_gen from ".$prefix."_ele_consultazione where data_inizio='$datarif')";
+                        $compl = $dbi->prepare("$sql");
+                        $compl->execute();
+                        while(list ($id_cons)= $compl->fetch(PDO::FETCH_NUM)){
+                                $sql="select id_sez, id_sede from ".$prefix."_ele_sezioni where id_cons='$id_cons' and num_sez='$num_sez'";
+                                $res = $dbi->prepare("$sql");
+                                $res->execute();
+                                if(!$res->rowCount()) continue;
+                                list ($id_sez,$id_sede)=$res->fetch(PDO::FETCH_NUM);                    
+                                $sql="select aid from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid2'";
+                                $res = $dbi->prepare("$sql");
+                                $res->execute();
+                                if($res->rowCount()) continue;
+                                $sql="insert into ".$prefix."_ele_operatori (id_cons,id_sede,id_comune,permessi,aid,id_sez) values ('$id_cons','$id_sede','$id_comune','$permessi','$aid2','$id_sez')";
+                                $res = $dbi->prepare("$sql");
+                                $res->execute();
+                        }
                         Header("Location: admin.php?op=permessi&id_cons_gen=$id_cons_gen");
                 } elseif ($do == "update") {

trunk/admin/modules/Elezioni/ele_spoglio.php

@@ -961 +961 @@
                                         $res = $dbi->prepare("$sql");
                                         $res->execute();
+                                        $numpro=$res->rowCount();
                                         $pro= $res->fetch(PDO::FETCH_BOTH);
                                         echo "<tr><td colspan=\"6\">&nbsp;</td></tr>";
-                                        if ($pro['si']+$pro['no']!=$pro['validi'] or ($pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=$tot and $pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=0)){
+                                        if ($numpro and ($pro['si']+$pro['no']!=$pro['validi'] or ($pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=$tot and $pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=0))){
                                                 echo "<tr style=\"background-color: rgb(255, 0, 0); text-align:center\">";
-                                        }elseif($pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=0)
+                                        }elseif($numpro and ($pro['validi']+$pro['nulli']+$pro['bianchi']+$pro['contestati']!=0))
                                                 echo "<tr style=\"background-color:#99CC33; text-align:center\">"; 
                                         else 

trunk/admin/modules/Elezioni/salva_ref.php

@@ -62 +62 @@
                 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($_GET[$siv]=='' and $_GET[$nov]=='' and $_GET[$biav]=='' and $_GET[$conv]=='' and $_GET[$nulv]=='') continue;
                         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';