Changeset 4328 for branches/2.2.0.1

Timestamp:

05/11/11 10:05:39 (13 years ago)

Author:

rafaelraymundo

Message:

Ticket #1726 - Resolvendo problema de edição de grupo compartilhado. r4315

File:

• branches/2.2.0.1/contactcenter/inc/class.so_group.inc.php (modified) (3 diffs)

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

@@ -167 +167 @@
 
                                 $query .= ' from'
-                                                . ' phpgw_cc_contact'
-                                                . ' inner join phpgw_cc_contact_conns on ( phpgw_cc_contact.id_contact = phpgw_cc_contact_conns.id_contact )'
-                                                . ' inner join phpgw_cc_connections on ( phpgw_cc_contact_conns.id_connection = phpgw_cc_connections.id_connection )'
-                                                . ' left join phpgw_cc_contact_addrs on ( phpgw_cc_contact.id_contact = phpgw_cc_contact_addrs.id_contact )'
+                                                . ' phpgw_cc_contact A'
+                                                . ' inner join phpgw_cc_contact_conns B on ( A.id_contact = B.id_contact )'
+                                                . ' inner join phpgw_cc_connections C on ( B.id_connection = C.id_connection )'
+                                                . ' left join phpgw_cc_contact_addrs on ( A.id_contact = phpgw_cc_contact_addrs.id_contact )'
                                                 . ' left join phpgw_cc_addresses on ( phpgw_cc_contact_addrs.id_address = phpgw_cc_addresses.id_address )'
                                                 . ' left join phpgw_cc_city on ( phpgw_cc_addresses.id_city = phpgw_cc_city.id_city )'
@@ -177 +177 @@
 
                                 $query .= ' where'
-                                                . " phpgw_cc_contact.id_owner = {$this->owner}"
+                                                . " A.id_owner = {$this->owner}"
                                                 //. ' and phpgw_cc_connections.connection_is_default = true'
                                                 ;
@@ -196 +196 @@
 
                         if ( $field == 'only_email' )
-                                $query .= 'and phpgw_cc_contact_conns.id_typeof_contact_connection = 1 ';
-
-                        $query .= ' order by phpgw_cc_contact.names_ordered, phpgw_cc_connections.connection_value';
+                                $query .= ' and B.id_typeof_contact_connection = 1 ';
+
+                        $query .= ' order by A.names_ordered, C.connection_value';
 
                         if (!$this->db->query($query))