Changeset 400 for trunk/admin/admin.php

Timestamp:

Feb 25, 2024, 3:57:45 PM (9 months ago)

Author:

roby

Message:

• ADMIN

-- Migliorata la gestione di operatori e responsabili

• CLIENT

-- Nuovo tema BSItalia realizzato dal CED di Capo d'Orlando
-- Sistemata la funzione del widget privacy
-- Varie modifiche di allineamento oggetti

File:

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

trunk/admin/admin.php

@@ -387 +387 @@
 $admincomune=$row[1];
 $oper=$row[2]; 
-        
-#if (($adminsuper==1 || $admincomune==1 || $adminop==1)) {
         if ($adminsuper==1)
                 return 256;
@@ -397 +395 @@
         else {
                 $oggi=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-3,date("Y")));
-                $sql="SELECT id_sez FROM ".$prefix."_ele_operatori where  aid='$aid' and permessi>0 and id_cons in (select t1.id_cons from ".$prefix."_ele_cons_comune as t1, ".$prefix."_ele_consultazione as t2 where t1.id_cons_gen=t2.id_cons_gen and t1.id_comune='$id_comune' and t2.data_fine>$oggi)";           
+                $sql="select t1.id_cons from ".$prefix."_ele_cons_comune as t1, ".$prefix."_ele_consultazione as t2 where t1.id_cons_gen=t2.id_cons_gen and t1.id_cons_gen='$id_cons_gen' and t1.chiusa='0' and t1.id_comune='$id_comune' and t2.data_fine>$oggi";
                 $sth = $dbi->prepare("$sql");
                 $sth->execute();        #die("TEST: $sql");     
-                if($sth->rowCount()) {$perms=16; return $perms;}
-                else {$msglogout=1; return 0;}
-        }
-/*      $sth = $dbi->prepare("select id_cons from ".$prefix."_ele_cons_comune where id_comune='$id_comune' and id_cons_gen='$id_cons_gen'");
-        $sth->execute();        
-        $row = $sth->fetch(PDO::FETCH_BOTH);    
-        $id_cons=$row[0];
-        $sth = $dbi->prepare("select permessi from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid' and id_comune='$id_comune'");
-                
-        $sth->execute();
-        list($perms)=$sth->fetch(PDO::FETCH_NUM);
-#       $row =  die("test:$sql".$row[0] );
-        if (!$perms) {die("qui: select permessi from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid' and id_comune='$id_comune'");    $msglogout=1; $perms=0; }
-
-        return $perms; */
-#} else return 0;
+                if(!$sth->rowCount()) {$msglogout=1; $perms=0; return $perms;}
+                list($id_cons) = $sth->fetch(PDO::FETCH_NUM);
+                $sql="select permessi from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid'";
+                $sth = $dbi->prepare("$sql");
+                $sth->execute();        #die("TEST: $sql");     
+                list($perms) = $sth->fetch(PDO::FETCH_NUM);
+        }
 }