Changeset 3344


Ignore:
Timestamp:
10/13/10 11:32:10 (13 years ago)
Author:
eduardoalex
Message:

Ticket #1370 - Adicionada correcao no sql da funcao selectGroupsOwnerCanImportContacts

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.2/contactcenter/inc/class.so_group.inc.php

    r3334 r3344  
    108108                 
    109109                function selectGroupsOwnerCanImportContacts($owner) { 
    110                         $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  
    111                                                 A.acl_location=B.acl_account and A.acl_account=B.acl_location 
    112                                                 and A.acl_appname = 'contactcenter' and B.acl_appname = 'contactcenter' 
    113                                                 and A.acl_rights & 4 <> 0 and B.acl_rights & 1 <> 0 
    114                                                 and A.acl_location = $owner)"; //He can import contacts only to his groups, or shared groups that he gave read permission. 
     110                        $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 
     111                       A.acl_location=B.acl_account::text and A.acl_account::text=B.acl_location 
     112                       and A.acl_appname = 'contactcenter' and B.acl_appname = 'contactcenter' 
     113                       and A.acl_rights & 4 <> 0 and B.acl_rights & 1 <> 0 
     114                       and A.acl_location = '".$owner."')"; //He can import contacts only to his groups, or shared groups that he gave read permission. 
     115                         
    115116                        $this->db->query($query); 
    116117                         
Note: See TracChangeset for help on using the changeset viewer.