Changeset 4599 for branches/2.2.0.1/contactcenter/inc/class.so_group.inc.php

Timestamp:

06/11/11 16:42:10 (13 years ago)

Author:

rafaelraymundo

Message:

Ticket #2006 - Incluir Contato Compartilhado duplicado

File:

• branches/2.2.0.1/contactcenter/inc/class.so_group.inc.php (modified) (1 diff)

branches/2.2.0.1/contactcenter/inc/class.so_group.inc.php

@@ -370 +370 @@
                         return $return;
                 }               
-                
+
+                function verifySharedContact($owner,$email)
+                {
+                        $query = 'select A.names_ordered, C.id_connection from phpgw_cc_contact A,'.
+                        'phpgw_cc_contact_conns B, phpgw_cc_connections C where '.
+                        'A.id_contact = B.id_contact and B.id_connection = C.id_connection '.
+                        'and B.id_typeof_contact_connection = 1 and '.
+                        'A.id_owner ='.$owner.' and C.connection_value = \''.$email.'\'';
+
+                        if (!$this->db->query($query))
+                        {
+                                exit ('Query failed! File: '.__FILE__.' on line'.__LINE__);
+                        }
+
+                        $return = false;
+
+                        while($this->db->next_record())
+                        {
+                                $row = $this->db->row();
+                                $return[] =  $row['names_ordered'];
+                                $return[] =  $row['id_connection'];
+                        }
+
+                        return $return;
+                }
+
                 function selectContactsByGroup($idGroup)
                 {