Changeset 428 for trunk/admin/admin.php

Timestamp:

Oct 9, 2024, 10:47:10 AM (3 weeks ago)

Author:

roby

Message:

• ADMIN

-- modifica alle autorizzazioni per singola sezione

File:

• trunk/admin/admin.php (modified) (3 diffs)

trunk/admin/admin.php

@@ -513 +513 @@
                 list($id_sez) = $resmod->fetch(PDO::FETCH_NUM); 
                 if($id_sez) {
-                        $sql="select t1.id_cons_gen,t1.descrizione,t2.id_cons from ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_comune=$id_comune and date_add(t1.data_fine, interval 3 day)>CURDATE() and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and id_sez>0 and permessi>0)";
+                        if(isset($id_cons_gen) and $id_cons_gen>0) {$singola="and t1.id_cons_gen=$id_cons_gen";}
+                        else{ $singola='';}
+                        $sql="select t1.id_cons_gen,t1.descrizione,t2.id_cons from ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen $singola and t2.id_comune=$id_comune and date_add(t1.data_fine, interval $giorniaut day)>CURDATE() and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and id_sez>0 and permessi>0)";
                         $resmod = $dbi->prepare("$sql");
                         $resmod->execute();
@@ -520 +522 @@
                                 $tema='Futura2'; 
                                 $_SESSION['tema']=$tema;
-                        } #else {die("TEST: $sql"); logout();}
+                        } 
                 }
         } 
@@ -529 +531 @@
 #echo "op:".$param['op']." -- aid:".$_SESSION['aid']."remote:".$_SESSION['remote']."REMOTE:".$_SERVER['REMOTE_ADDR'];
 if (isset($param['op'])) $op=addslashes($param['op']); else $op='ele';
-//if (isset($param['op'])) $op=$param['op']; else $op='ele';
 #
 #die("TEST: qui2 op:$op - $aid $id_cons $id_sez ".$_SESSION['aid']);