Changeset 1280 for trunk/phpgwapi

Timestamp:

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

Author:

eduardoalex

Message:

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

Location:

trunk/phpgwapi/inc

Files:

• class.acl.inc.php (modified) (1 diff)
• class.db.inc.php (modified) (1 diff)

trunk/phpgwapi/inc/class.acl.inc.php

@@ -194 +194 @@
                         return $this->data;
                 }
-
+                
+                function persist_shared_groups($location)
+                {
+                        $this->db->persist_shared_groups($location,$this->account_id);
+                }
+                
                 /*!
                 @function delete

trunk/phpgwapi/inc/class.db.inc.php

@@ -1134 +1134 @@
                 }
 
+                function persist_shared_groups($location,$account_id)
+                {
+
+                        $sql = "delete from phpgw_cc_contact_grps where oid in (
+                                select A.oid from phpgw_cc_contact_grps A inner join phpgw_cc_groups B on A.id_group=B.id_group 
+                                inner join phpgw_cc_contact_conns C on A.id_connection=C.id_connection 
+                                inner join phpgw_cc_contact D on C.id_contact=D.id_contact
+                                where B.owner=$location and D.id_owner=$account_id );";
+
+                        return $this->query($sql);
+                }
+
                 /**
                 * Updates the data of one or more rows in a table, all data is quoted according to it's type