Changeset 366 for trunk/admin/modules/Elezioni/ele_permessi.php

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

File:

• trunk/admin/modules/Elezioni/ele_permessi.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") {