Changeset 1280 for trunk/contactcenter/inc/class.so_group.inc.php

Timestamp:

08/05/09 18:20:55 (15 years ago)

Author:

eduardoalex

Message:

Ticket #453 - Edição de grupos compartilhados.

File:

• trunk/contactcenter/inc/class.so_group.inc.php (modified) (2 diffs)

trunk/contactcenter/inc/class.so_group.inc.php

@@ -107 +107 @@
                 }
                 
-                
-                function selectAllContacts( $field = false )
-                {
-                                                
-                        $query = 'select C.id_connection, A.id_contact, A.names_ordered, C.connection_value , B.id_typeof_contact_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 '.
-                        'A.id_owner ='.$this->owner.' and C.connection_is_default = true ';
+                //Owner = null means the owner setted on constructor.
+                function selectAllContacts( $field = false ,$shared_from=null)
+                {
+                        if($shared_from==null) {                
+                                $query = 'select C.id_connection, A.id_contact, A.names_ordered, C.connection_value , B.id_typeof_contact_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 '.
+                                'A.id_owner ='.$this->owner.' and C.connection_is_default = true ';
+                        }
+                        else {
+                                $sub_query = 'select A.id_related from phpgw_cc_contact_rels A,phpgw_acl B
+                                                          where B.acl_location!=\'run\' and A.id_contact = B.acl_location::bigint and A.id_related = B.acl_account and 
+                                                          B.acl_appname = \'contactcenter\' and B.acl_rights & 1 <> 0 
+                                                          and A.id_typeof_contact_relation=1 and A.id_contact = '.$shared_from.' and A.id_related='.$this->owner;
+                                
+                                $query = 'select C.id_connection, A.id_contact, A.names_ordered, C.connection_value , B.id_typeof_contact_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 '.
+                                'A.id_owner in ('.$shared_from.',('.$sub_query.'))'.
+                                ' and C.connection_is_default = true ';
+                        }
 
                         if ( $field == 'only_email' )
@@ -256 +269 @@
                         'A.id_contact = B.id_contact and B.id_connection = C.id_connection '.
                         'and B.id_typeof_contact_connection = 1 and '.
-                        'A.id_owner ='.$this->owner.' and D.id_connection = C.id_connection and D.id_group = '.$id_group.
+                        //'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?
                         ' order by A.names_ordered';