Changeset 180 for trunk/expressoAdmin1_2/inc/class.db_functions.inc.php

Timestamp:

02/26/08 17:04:07 (16 years ago)

Author:

niltonneto

Message:

 

File:

• trunk/expressoAdmin1_2/inc/class.db_functions.inc.php (modified) (1 diff)

trunk/expressoAdmin1_2/inc/class.db_functions.inc.php

@@ -672 +672 @@
                 return $result;
         }
+        
+        function manager_lid_exist($manager_lid)
+        {
+                $query = "SELECT manager_lid FROM phpgw_expressoadmin WHERE manager_lid = '" . $manager_lid . "'";
+                $this->db->query($query);
+                while($this->db->next_record())
+                        $result[] = $this->db->row();
+                if (count($result) > 0)
+                        return true;
+                else
+                        return false;
+        }
+        
+        function create_manager($params, $manager_acl)
+        {
+                //Escrevre no Banco a ACL do gerente
+                $sql = "INSERT INTO phpgw_expressoadmin (manager_lid, context, acl) "
+                . "VALUES('" . $params['ea_select_manager'] . "','" . $params['context'] . "','" . $manager_acl . "')";
+                $this->db->query($sql);
+                        
+                //Escrevre no Banco as aplicações que o gerente tem direito de disponibilizar aos seus usuarios.
+                if (count($_POST['applications_list']))
+                {
+                        foreach($_POST['applications_list'] as $app=>$value)
+                        {
+                                $sql = "INSERT INTO phpgw_expressoadmin_apps (manager_lid, context, app) "
+                                . "VALUES('" . $_POST['manager_lid'] . "','" . $_POST['context'] . "','" . $app . "')";
+                                $this->db->query($sql);
+                        }
+                }
+                
+                return;
+        }
+        
+        function save_manager($params, $manager_acl)
+        {
+                $params['manager_lid'] = $params['hidden_manager_lid'];
+                
+                //Executa update na tabela para atualizar ACL
+                $sql = "UPDATE phpgw_expressoadmin SET context = '" . $params['context'] . "',acl = '" . $manager_acl
+                . "' WHERE manager_lid = '" . $params['manager_lid'] ."'";
+                $this->db->query($sql);
+                        
+                //Deleta as aplicações e adiciona as novas.
+                //Deleta
+                $sql = "DELETE FROM phpgw_expressoadmin_apps WHERE manager_lid = '" . $params['manager_lid'] . "'";
+                $this->db->query($sql);
+                                        
+                // Adiciona
+                if (count($params['applications_list']))
+                {
+                        foreach($params['applications_list'] as $app=>$value)
+                        {
+                                $sql = "INSERT INTO phpgw_expressoadmin_apps (manager_lid, context, app) "
+                                . "VALUES('" . $params['manager_lid'] . "','" . $params['context'] . "','" . $app . "')";
+                                $this->db->query($sql);
+                        }
+                }
+                        
+                return;
+        }
+        
 }
 ?>