Changeset 3334 for branches/2.2/contactcenter/inc/class.so_group.inc.php

Timestamp:

10/06/10 16:14:29 (14 years ago)

Author:

eduardoalex

Message:

Ticket #1370 - Adicionada a opcao de escolha do grupo para os contatos importados

File:

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

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

@@ -105 +105 @@
                                                                         
                         return True;            
+                }
+                
+                function selectGroupsOwnerCanImportContacts($owner) {
+                        $query = "select id_group,title,short_name from phpgw_cc_groups where owner=$owner or owner in (select B.acl_location::bigint from phpgw_acl A, phpgw_acl B where 
+                                                A.acl_location=B.acl_account and A.acl_account=B.acl_location
+                                                and A.acl_appname = 'contactcenter' and B.acl_appname = 'contactcenter'
+                                                and A.acl_rights & 4 <> 0 and B.acl_rights & 1 <> 0
+                                                and A.acl_location = $owner)"; //He can import contacts only to his groups, or shared groups that he gave read permission.
+                        $this->db->query($query);
+                        
+                        $return = array();
+                        
+                        while($this->db->next_record())
+                        {
+                                $return[] = $this->db->row(); 
+                        }
+                        
+                        return $return;
+                        
                 }
                 
@@ -492 +511 @@
                         return True;            
                 }
+                
+                function add_user_by_name($id_group){
+                        $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.last_update = (select max(up.last_update) from phpgw_cc_contact up where up.id_owner ='.$this->owner.")".
+                                                ' and A.id_owner ='.$this->owner.' and C.connection_is_default = true'.
+                                         ' order by A.names_ordered,C.connection_value';
+                        
+                                                
+                        if (!$this->db->query($query)){
+                                exit ('Query failed! File: '.__FILE__.' on line'.__LINE__);
+                        }
+                         
+                        $return = array(); 
+                        
+                        $array_connections = array();
+                        while($this->db->next_record()){
+                                $return = $this->db->row();
+                                array_push($array_connections, $return['id_connection']);                               
+                        }                       
+                        $this -> insertContactsByGroup($id_group, $array_connections);
+                                                                        
+                }
+                
         }
 ?>