Changeset 4498 for sandbox/2.2.0.2/contactcenter/inc/class.so_group.inc.php

Timestamp:

05/24/11 17:58:15 (13 years ago)

Author:

airton

Message:

Ticket #1925 - Permitir associar um contato com um grupo na tela de criação do contato

File:

• sandbox/2.2.0.2/contactcenter/inc/class.so_group.inc.php (modified) (3 diffs)

sandbox/2.2.0.2/contactcenter/inc/class.so_group.inc.php

@@ -104 +104 @@
                         return True;            
                 }               
+                
+                /*!
+                 * @function select_owner_groups
+                 * @abstract Busca todos os grupos do usuário atual.
+                 * @author Luiz Carlos Viana Melo - Prognus
+                 * @param (integer) $id_owner O ID do usuário.
+                 * @return Retorna uma estrutura contendo:
+                 * array(
+                 *              array(
+                 *                      id_group => O ID do grupo;
+                 *                      title => O nome do grupo;
+                 *                      short_name => O nome abreviado do grupo.
+                 *              )
+                 * )
+                 */
+                function select_owner_groups($id_owner = false)
+                {
+                        $query = 'SELECT id_group, title, short_name FROM phpgw_cc_groups ';
+                        if ($id_owner)
+                                $query .= 'WHERE owner = ' . $id_owner. ' ORDER BY title;';
+                        else
+                                $query .= 'WHERE owner = ' . $this->owner . ' ORDER BY title;';
+                                
+                        if (!$this->db->query($query))
+                        {
+                                exit ('Query failed! File: '.__FILE__.' on line'.__LINE__);
+                        }
+                        
+                        $return = false;
+                        
+                        while($this->db->next_record())
+                        {
+                                $return[] = $this->db->row(); 
+                        }
+                        
+                        return $return;
+                }
+                
+                /*!
+                 * @function select_contact_groups
+                 * @abstract Seleciona os grupos do contato.
+                 * @author Luiz Carlos Viana Melo - Prognus
+                 * @param (integer) $id_contact O ID do contato.
+                 * @return Retorna uma estrutura contendo:
+                 * array(
+                 *              array(
+                 *                      id_contact => O ID do contato;
+                 *                      id_group => O ID do grupo;
+                 *                      title => O nome do grupo;
+                 *                      short_name => O nome abreviado do grupo.
+                 *              )
+                 * )
+                 */
+                function select_contact_groups($id_contact)
+                {
+                        $query = 'SELECT Contato.id_contact, ContatoGprs.id_connection, Grupos.id_group, Grupos.title, ' .
+                                'Grupos.short_name FROM phpgw_cc_contact_conns Contato, ' . 
+                                'phpgw_cc_connections Conexao, phpgw_cc_contact_grps ContatoGprs, ' . 
+                                'phpgw_cc_groups Grupos WHERE Contato.id_contact = ' . $id_contact . 
+                                ' AND Contato.id_connection = Conexao.id_connection AND ' . 
+                                'Conexao.id_connection = ContatoGprs.id_connection AND ' . 
+                                'ContatoGprs.id_group = Grupos.id_group ORDER BY title';
+                        
+                        if (!$this->db->query($query))
+                        {
+                                exit ('Query failed! File: '.__FILE__.' on line'.__LINE__);
+                        }
+                        
+                        $return = false;
+                        
+                        while($this->db->next_record())
+                        {
+                                $return[] = $this->db->row(); 
+                        }
+                        
+                        return $return;
+                }
                 
                 function deleteContactFromGroups($id)
@@ -402 +479 @@
                         "phpgw_cc_contact_conns B, phpgw_cc_connections C,phpgw_cc_contact_grps D,phpgw_cc_groups E where ".
                         "A.id_contact = B.id_contact and B.id_connection = C.id_connection ".
-                        "and B.id_typeof_contact_connection = 1 and ".
+                        " and ".
                         "A.id_owner =".$this->owner." and ".                    
                         "D.id_group = E.id_group and ".
@@ -445 +522 @@
                         'phpgw_cc_contact_conns B, phpgw_cc_connections C,phpgw_cc_contact_grps D where '.
                         'A.id_contact = B.id_contact and B.id_connection = C.id_connection '.
-                        'and B.id_typeof_contact_connection = 1 and '.
+                        ' and '.
                         //'A.id_owner ='.$this->owner.' and D.id_connection = C.id_connection and D.id_group = '.$id_group.
                         ' D.id_connection = C.id_connection and D.id_group = '.$id_group. //If I have the group ID, why ask about owner?