Changeset 1914 for sandbox/expresso2.2/phpgwapi/inc/class.preferences.inc.php

Timestamp:

01/05/10 08:37:12 (14 years ago)

Author:

amuller

Message:

Ticket #670 - Implementação de pref. obrig. por grupo

File:

• sandbox/expresso2.2/phpgwapi/inc/class.preferences.inc.php (modified) (6 diffs)

sandbox/expresso2.2/phpgwapi/inc/class.preferences.inc.php

@@ -222 +222 @@
                                 $this->session = array();
                         }
+                        $groups = $GLOBALS['phpgw']->accounts->membership();
+                        foreach($groups as $group)
+                                $gids .= ",".$group['account_id'];
+                        $account_id = (int)$this->account_id;
+
                         $this->db->query("SELECT * FROM phpgw_preferences"
-                                . " WHERE preference_owner IN (-1,-2," . (int)$this->account_id . ')',__LINE__,__FILE__);
+                                . " WHERE preference_owner IN (-1,-2," . $account_id . $gids . ')',__LINE__,__FILE__);
 
                         $this->forced = $this->default = $this->user = array();
@@ -244 +249 @@
                                                 $this->default[$app] = $value;
                                                 break;
-                                        default:        // user
+                                        case $account_id: //user
                                                 $this->user[$app] = $value;
+                                                break;
+                                        default: // group
+                                                $this->group[$app] = $value;
                                                 break;
                                 }
@@ -273 +281 @@
                                 }
                         }
+                        // now set/force forced values for groups
+                        //
+                        foreach($this->group as $app => $values)
+                        {
+                                foreach($values as $var => $value)
+                                {
+                                        $this->data[$app][$var] = $value;
+                                }
+                        }
+
                         // now set/force forced values
                         //
@@ -532 +550 @@
                 @note the user prefs for saveing are in $this->user not in $this->data, which are the effectiv prefs only
                 */
-                function save_repository($update_session_info = False,$type='user')
+                function save_repository($update_session_info = False,$type='user',$account_id = null)
                 {
                         switch($type)
                         {
                                 case 'forced':
-                                        $account_id = -1;
+                                        if ($account_id == null)
+                                                $account_id = -1;
                                         $prefs = &$this->forced;
                                         break;
@@ -554 +573 @@
                         {
                                 $this->db->transaction_begin();
-                                //$this->db->query("DELETE FROM phpgw_preferences WHERE preference_owner='$account_id'",
-                                $this->db->query("DELETE FROM phpgw_preferences WHERE preference_owner='$account_id' and preference_app <> 'jabberit_messenger'",
-                                        __LINE__,__FILE__
-                                );
-
                                 foreach($prefs as $app => $value)
                                 {
@@ -566 +580 @@
                                         }
                                         $this->quote($value);
-                                        $value = $this->db->db_addslashes(serialize($value));   // this addslashes is for the database
+                                        $value = $this->db->db_addslashes(serialize($value));    // this addslashes is for the database
                                         $app = $this->db->db_addslashes($app);
 
-                                        $this->db->query($sql = "INSERT INTO phpgw_preferences"
-                                                . " (preference_owner,preference_app,preference_value)"
-                                                . " VALUES ($account_id,'$app','$value')",__LINE__,__FILE__);
+                                        $query = "SELECT (preference_owner, preference_app) FROM phpgw_preferences WHERE preference_owner = '".$account_id."' AND preference_app = '".$app."'";
+
+                                        $this->db->query($query, __LINE__, __FILE__);
+
+                                        if(!$this->db->next_record())
+                                        {
+                                                // Insert Db
+                                                $query = "INSERT INTO phpgw_preferences(preference_owner,preference_app, preference_value) ".
+                                                        "VALUES('".$account_id."','".$app."','".$value."')";
+                                        }
+                                        else
+                                        {      
+                                                // Update Db
+                                                $query = "UPDATE phpgw_preferences SET preference_value = '".$value."' WHERE ".
+                                                        "preference_owner = '".$account_id."' AND preference_app = '".$app."'";
+                                        }
+                                        $this->db->query($query, __LINE__, __FILE__);                
                                 }
                                 $this->db->transaction_commit();