Changeset 1756

Timestamp:

12/04/09 16:41:31 (14 years ago)

Author:

alexandrecorreia

Message:

Ticket #808 - Busca implementada utilizando somente os grupos cadastrados.

File:

• trunk/jabberit_messenger/inc/class.db_im.inc.php (modified) (3 diffs)

trunk/jabberit_messenger/inc/class.db_im.inc.php

@@ -115 +115 @@
         public final function get_accounts_acl()
         {
-                $query  = "select acl_account from phpgw_acl where acl_location in (select cast(acl_account as varchar) from phpgw_acl where acl_appname = 'jabberit_messenger') ";
-                $query .= "union select acl_account from phpgw_acl where acl_appname = 'jabberit_messenger'";
-                
+                $query  = "SELECT acl_account FROM phpgw_acl WHERE acl_location IN (SELECT CAST(acl_account AS varchar) FROM phpgw_acl WHERE acl_appname = 'jabberit_messenger') ";
+                $query .= "UNION SELECT acl_account FROM phpgw_acl WHERE acl_appname = 'jabberit_messenger'";
                 
                 if( $this->db->query($query) )  
@@ -156 +155 @@
                                         $return = $result[0]['config_value'];
                         }
+                }
+                
+                return $return;
+        }
+        
+        public final function getGroupsSearch()
+        {
+                $return = "";
+        
+                if( $this->db )
+                {
+                        $query = "SELECT * FROM phpgw_config WHERE config_app = 'phpgwapi' AND config_name = 'groups_search_jabberit';";
+                        
+                        if($this->db->query($query))
+                        {
+                                while($this->db->next_record())
+                                        $result[] = $this->db->row();                           
+                        }
+
+                        if( count($result) > 0 )
+                                $return = $result[0]['config_value'];
                 }
                 
@@ -314 +334 @@
                 }
                 return false; 
+        }
+
+        public final function setAddGroupsSearch($pData)
+        {
+                if( $pData)
+                {
+                        if( $this->db )
+                        {
+                                $query = "SELECT * FROM phpgw_config WHERE config_app = 'phpgwapi' AND  config_name = 'groups_search_jabberit';";
+                                
+                                if( $this->db->query($query) )
+                                {
+                                        while( $this->db->next_record())
+                                                $result[] = $this->db->row();                           
+                                }
+                                
+                                if( count($result) == 0 )
+                                {
+                                        $query = "INSERT INTO phpgw_config(config_app,config_name,config_value) VALUES('phpgwapi','groups_search_jabberit','".serialize($pData)."');";
+                                        $this->db->query($query);
+                                        return true;
+                                }
+                                else
+                                {
+                                        $resultQuery = unserialize($result[0]['config_value']);
+                                        $keys = array_keys($pData);
+
+                                        $resultQuery[$keys[0]] = $pData[$keys[0]];
+
+                                        $query = "UPDATE phpgw_config SET config_value = '".serialize($resultQuery)."' WHERE config_app = 'phpgwapi' AND config_name = 'groups_search_jabberit';";
+                                        $this->db->query($query);
+                                        return true;
+                                }
+                        }                       
+                }
         }