485 lines
19 KiB
PHP
485 lines
19 KiB
PHP
|
<?php
|
||
|
|
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
|
||
|
|
/*********************************************************************************
|
||
|
|
* SugarCRM is a customer relationship management program developed by
|
||
|
|
* SugarCRM, Inc. Copyright (C) 2004-2010 SugarCRM Inc.
|
||
|
|
*
|
||
|
|
* This program is free software; you can redistribute it and/or modify it under
|
||
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
||
|
|
* Free Software Foundation with the addition of the following permission added
|
||
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
||
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
|
||
|
|
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
||
|
|
*
|
||
|
|
* This program is distributed in the hope that it will be useful, but WITHOUT
|
||
|
|
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
|
||
|
|
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
|
||
|
|
* details.
|
||
|
|
*
|
||
|
|
* You should have received a copy of the GNU Affero General Public License along with
|
||
|
|
* this program; if not, see http://www.gnu.org/licenses or write to the Free
|
||
|
|
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
|
||
|
|
* 02110-1301 USA.
|
||
|
|
*
|
||
|
|
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
|
||
|
|
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
|
||
|
|
*
|
||
|
|
* The interactive ecmemployee interfaces in modified source and object code versions
|
||
|
|
* of this program must display Appropriate Legal Notices, as required under
|
||
|
|
* Section 5 of the GNU Affero General Public License version 3.
|
||
|
|
*
|
||
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
|
||
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by
|
||
|
|
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
|
||
|
|
* technical reasons, the Appropriate Legal Notices must display the words
|
||
|
|
* "Powered by SugarCRM".
|
||
|
|
********************************************************************************/
|
||
|
|
/*********************************************************************************
|
||
|
|
|
||
|
|
* Description: Handles the EcmEmployee Preferences and stores them in a seperate table.
|
||
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
|
||
|
|
* All Rights Reserved.
|
||
|
|
* Contributor(s): ______________________________________..
|
||
|
|
********************************************************************************/
|
||
|
|
|
||
|
|
class EcmEmployeePreference extends SugarBean
|
||
|
|
{
|
||
|
|
public $db;
|
||
|
|
public $field_name_map;
|
||
|
|
|
||
|
|
// Stored fields
|
||
|
|
public $id;
|
||
|
|
public $date_entered;
|
||
|
|
public $date_modified;
|
||
|
|
public $assigned_ecmemployee_id;
|
||
|
|
public $assigned_ecmemployee_name;
|
||
|
|
public $name;
|
||
|
|
public $category;
|
||
|
|
public $contents;
|
||
|
|
public $deleted;
|
||
|
|
|
||
|
|
public $object_name = 'EcmEmployeePreference';
|
||
|
|
public $table_name = 'ecmemployee_preferences';
|
||
|
|
|
||
|
|
public $disable_row_level_security = true;
|
||
|
|
public $module_dir = 'EcmEmployeePreferences';
|
||
|
|
public $field_defs = array();
|
||
|
|
public $field_defs_map = array();
|
||
|
|
public $new_schema = true;
|
||
|
|
|
||
|
|
protected $_ecmemployeeFocus;
|
||
|
|
|
||
|
|
// Do not actually declare, use the functions statically
|
||
|
|
public function __construct(
|
||
|
|
EcmEmployee $ecmemployee = null
|
||
|
|
)
|
||
|
|
{
|
||
|
|
parent::SugarBean();
|
||
|
|
|
||
|
|
$this->_ecmemployeeFocus = $ecmemployee;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Get preference by name and category. Lazy loads preferences from the database per category
|
||
|
|
*
|
||
|
|
* @param string $name name of the preference to retreive
|
||
|
|
* @param string $category name of the category to retreive, defaults to global scope
|
||
|
|
* @return mixed the value of the preference (string, array, int etc)
|
||
|
|
*/
|
||
|
|
public function getPreference(
|
||
|
|
$name,
|
||
|
|
$category = 'global'
|
||
|
|
)
|
||
|
|
{
|
||
|
|
global $sugar_config;
|
||
|
|
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
// if the unique key in session doesn't match the app or prefereces are empty
|
||
|
|
if(!isset($_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category]) || (!empty($_SESSION['unique_key']) && $_SESSION['unique_key'] != $sugar_config['unique_key'])) {
|
||
|
|
$this->loadPreferences($category);
|
||
|
|
}
|
||
|
|
if(isset($_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category][$name])) {
|
||
|
|
return $_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category][$name];
|
||
|
|
}
|
||
|
|
|
||
|
|
// check to see if a default preference ( i.e. $sugar_config setting ) exists for this value )
|
||
|
|
// if so, return it
|
||
|
|
$value = $this->getDefaultPreference($name,$category);
|
||
|
|
if ( !is_null($value) ) {
|
||
|
|
return $value;
|
||
|
|
}
|
||
|
|
return null;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Get preference by name and category from the system settings.
|
||
|
|
*
|
||
|
|
* @param string $name name of the preference to retreive
|
||
|
|
* @param string $category name of the category to retreive, defaults to global scope
|
||
|
|
* @return mixed the value of the preference (string, array, int etc)
|
||
|
|
*/
|
||
|
|
public function getDefaultPreference(
|
||
|
|
$name,
|
||
|
|
$category = 'global'
|
||
|
|
)
|
||
|
|
{
|
||
|
|
global $sugar_config;
|
||
|
|
|
||
|
|
// Doesn't support any prefs but global ones
|
||
|
|
if ( $category != 'global' )
|
||
|
|
return null;
|
||
|
|
|
||
|
|
// First check for name matching $sugar_config variable
|
||
|
|
if ( isset($sugar_config[$name]) )
|
||
|
|
return $sugar_config[$name];
|
||
|
|
|
||
|
|
// Next, check to see if it's one of the common problem ones
|
||
|
|
if ( isset($sugar_config['default_'.$name]) )
|
||
|
|
return $sugar_config['default_'.$name];
|
||
|
|
if ( $name == 'datef' )
|
||
|
|
return $sugar_config['default_date_format'];
|
||
|
|
if ( $name == 'timef' )
|
||
|
|
return $sugar_config['default_time_format'];
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Set preference by name and category. Saving will be done in utils.php -> sugar_cleanup
|
||
|
|
*
|
||
|
|
* @param string $name name of the preference to retreive
|
||
|
|
* @param mixed $value value of the preference to set
|
||
|
|
* @param string $category name of the category to retreive, defaults to global scope
|
||
|
|
*/
|
||
|
|
public function setPreference(
|
||
|
|
$name,
|
||
|
|
$value,
|
||
|
|
$category = 'global'
|
||
|
|
)
|
||
|
|
{
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
if ( empty($ecmemployee->ecmemployee_name) )
|
||
|
|
return;
|
||
|
|
|
||
|
|
if(!isset($_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category])) {
|
||
|
|
if(!$ecmemployee->loadPreferences($category))
|
||
|
|
$_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category] = array();
|
||
|
|
}
|
||
|
|
|
||
|
|
// preferences changed or a new preference, save it to DB
|
||
|
|
if(!isset($_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category][$name])
|
||
|
|
|| (isset($_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category][$name]) && $_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category][$name] != $value)) {
|
||
|
|
$GLOBALS['savePreferencesToDB'] = true;
|
||
|
|
if(!isset($GLOBALS['savePreferencesToDBCats'])) $GLOBALS['savePreferencesToDBCats'] = array();
|
||
|
|
$GLOBALS['savePreferencesToDBCats'][$category] = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
$_SESSION[$ecmemployee->ecmemployee_name.'_PREFERENCES'][$category][$name] = $value;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Loads preference by category from database. Saving will be done in utils.php -> sugar_cleanup
|
||
|
|
*
|
||
|
|
* @param string $category name of the category to retreive, defaults to global scope
|
||
|
|
* @return bool successful?
|
||
|
|
*/
|
||
|
|
public function loadPreferences(
|
||
|
|
$category = 'global'
|
||
|
|
)
|
||
|
|
{
|
||
|
|
global $sugar_config;
|
||
|
|
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
if($ecmemployee->object_name != 'EcmEmployee')
|
||
|
|
return;
|
||
|
|
if(!empty($ecmemployee->id) && (!isset($_SESSION[$ecmemployee->ecmemployee_name . '_PREFERENCES'][$category]) || (!empty($_SESSION['unique_key']) && $_SESSION['unique_key'] != $sugar_config['unique_key']))) {
|
||
|
|
// cn: moving this to only log when valid - throwing errors on install
|
||
|
|
return $this->reloadPreferences($category);
|
||
|
|
}
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Unconditionally reloads ecmemployee preferences from the DB and updates the session
|
||
|
|
* @param string $category name of the category to retreive, defaults to global scope
|
||
|
|
* @return bool successful?
|
||
|
|
*/
|
||
|
|
public function reloadPreferences($category = 'global')
|
||
|
|
{
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
if($ecmemployee->object_name != 'EcmEmployee' || empty($ecmemployee->id) || empty($ecmemployee->ecmemployee_name)) {
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
$GLOBALS['log']->debug('Loading Preferences DB ' . $ecmemployee->ecmemployee_name);
|
||
|
|
if(!isset($_SESSION[$ecmemployee->ecmemployee_name . '_PREFERENCES'])) $_SESSION[$ecmemployee->ecmemployee_name . '_PREFERENCES'] = array();
|
||
|
|
if(!isset($ecmemployee->ecmemployee_preferences) || !is_array($ecmemployee->ecmemployee_preferences)) $ecmemployee->ecmemployee_preferences = array();
|
||
|
|
$result = $GLOBALS['db']->query("SELECT contents FROM ecmemployee_preferences WHERE assigned_ecmemployee_id='$ecmemployee->id' AND category = '" . $category . "' AND deleted = 0", false, 'Failed to load ecmemployee preferences');
|
||
|
|
$row = $GLOBALS['db']->fetchByAssoc($result);
|
||
|
|
if ($row) {
|
||
|
|
$_SESSION[$ecmemployee->ecmemployee_name . '_PREFERENCES'][$category] = unserialize(base64_decode($row['contents']));
|
||
|
|
$ecmemployee->ecmemployee_preferences[$category] = unserialize(base64_decode($row['contents']));
|
||
|
|
return true;
|
||
|
|
} else {
|
||
|
|
$_SESSION[$ecmemployee->ecmemployee_name . '_PREFERENCES'][$category] = array();
|
||
|
|
$ecmemployee->ecmemployee_preferences[$category] = array();
|
||
|
|
}
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Loads ecmemployees timedate preferences
|
||
|
|
*
|
||
|
|
* @return array 'date' - date format for ecmemployee ; 'time' - time format for ecmemployee
|
||
|
|
*/
|
||
|
|
public function getEcmEmployeeDateTimePreferences()
|
||
|
|
{
|
||
|
|
global $sugar_config, $db, $timezones, $timedate, $current_ecmemployee;
|
||
|
|
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
$prefDate = array();
|
||
|
|
|
||
|
|
if(!empty($ecmemployee) && $this->loadPreferences('global')) {
|
||
|
|
// forced to set this to a variable to compare b/c empty() wasn't working
|
||
|
|
$timeZone = $ecmemployee->getPreference("timezone");
|
||
|
|
$timeFormat = $ecmemployee->getPreference("timef");
|
||
|
|
$dateFormat = $ecmemployee->getPreference("datef");
|
||
|
|
|
||
|
|
// cn: bug xxxx cron.php fails because of missing preference when admin hasn't logged in yet
|
||
|
|
$timeZone = empty($timeZone) ? 'America/Los_Angeles' : $timeZone;
|
||
|
|
|
||
|
|
if(empty($timeZone)) $timeZone = '';
|
||
|
|
if(empty($timeFormat)) $timeFormat = $sugar_config['default_time_format'];
|
||
|
|
if(empty($dateFormat)) $dateFormat = $sugar_config['default_date_format'];
|
||
|
|
|
||
|
|
$equinox = date('I');
|
||
|
|
|
||
|
|
$serverHourGmt = date('Z') / 60 / 60;
|
||
|
|
|
||
|
|
$ecmemployeeOffsetFromServerHour = $ecmemployee->getPreference("timez");
|
||
|
|
|
||
|
|
$ecmemployeeHourGmt = $serverHourGmt + $ecmemployeeOffsetFromServerHour;
|
||
|
|
|
||
|
|
$prefDate['date'] = $dateFormat;
|
||
|
|
$prefDate['time'] = $timeFormat;
|
||
|
|
$prefDate['ecmemployeeGmt'] = "(GMT".($timezones[$timeZone]['gmtOffset'] / 60).")";
|
||
|
|
$prefDate['ecmemployeeGmtOffset'] = $timezones[$timeZone]['gmtOffset'] / 60;
|
||
|
|
|
||
|
|
return $prefDate;
|
||
|
|
} else {
|
||
|
|
$prefDate['date'] = $timedate->get_date_format();
|
||
|
|
$prefDate['time'] = $timedate->get_time_format();
|
||
|
|
|
||
|
|
if(!empty($ecmemployee) && $ecmemployee->object_name == 'EcmEmployee') {
|
||
|
|
$timeZone = $ecmemployee->getPreference("timezone");
|
||
|
|
// cn: bug 9171 - if ecmemployee has no time zone, cron.php fails for InboundEmail
|
||
|
|
if(!empty($timeZone)) {
|
||
|
|
$prefDate['ecmemployeeGmt'] = "(GMT".($timezones[$timeZone]['gmtOffset'] / 60).")";
|
||
|
|
$prefDate['ecmemployeeGmtOffset'] = $timezones[$timeZone]['gmtOffset'] / 60;
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$timeZone = $current_ecmemployee->getPreference("timezone");
|
||
|
|
if(!empty($timeZone)) {
|
||
|
|
$prefDate['ecmemployeeGmt'] = "(GMT".($timezones[$timeZone]['gmtOffset'] / 60).")";
|
||
|
|
$prefDate['ecmemployeeGmtOffset'] = $timezones[$timeZone]['gmtOffset'] / 60;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
return $prefDate;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Saves all preferences into the database that are in the session. Expensive, this is called by default in
|
||
|
|
* sugar_cleanup if a setPreference has been called during one round trip.
|
||
|
|
*
|
||
|
|
* @global ecmemployee will use current_ecmemployee if no ecmemployee specificed in $ecmemployee param
|
||
|
|
* @param ecmemployee $ecmemployee EcmEmployee object to retrieve, otherwise ecmemployee current_ecmemployee
|
||
|
|
* @param bool $all save all of the preferences? (Dangerous)
|
||
|
|
*
|
||
|
|
*/
|
||
|
|
public function savePreferencesToDB(
|
||
|
|
$all = false
|
||
|
|
)
|
||
|
|
{
|
||
|
|
global $sugar_config;
|
||
|
|
$GLOBALS['savePreferencesToDB'] = false;
|
||
|
|
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
// these are not the preferences you are looking for [ hand waving ]
|
||
|
|
if(!empty($_SESSION['unique_key']) && $_SESSION['unique_key'] != $sugar_config['unique_key']) return;
|
||
|
|
|
||
|
|
$GLOBALS['log']->debug('Saving Preferences to DB ' . $ecmemployee->ecmemployee_name);
|
||
|
|
if(isset($_SESSION[$ecmemployee->ecmemployee_name. '_PREFERENCES']) && is_array($_SESSION[$ecmemployee->ecmemployee_name. '_PREFERENCES'])) {
|
||
|
|
$GLOBALS['log']->debug("Saving Preferences to DB: {$ecmemployee->ecmemployee_name}");
|
||
|
|
// only save the categories that have been modified or all?
|
||
|
|
if(!$all && isset($GLOBALS['savePreferencesToDBCats']) && is_array($GLOBALS['savePreferencesToDBCats'])) {
|
||
|
|
$catsToSave = array();
|
||
|
|
foreach($GLOBALS['savePreferencesToDBCats'] as $category => $value) {
|
||
|
|
if ( isset($_SESSION[$ecmemployee->ecmemployee_name. '_PREFERENCES'][$category]) )
|
||
|
|
$catsToSave[$category] = $_SESSION[$ecmemployee->ecmemployee_name. '_PREFERENCES'][$category];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
$catsToSave = $_SESSION[$ecmemployee->ecmemployee_name. '_PREFERENCES'];
|
||
|
|
}
|
||
|
|
|
||
|
|
foreach ($catsToSave as $category => $contents) {
|
||
|
|
$focus = new EcmEmployeePreference($this->_ecmemployeeFocus);
|
||
|
|
$result = $focus->retrieve_by_string_fields(array(
|
||
|
|
'assigned_ecmemployee_id' => $ecmemployee->id,
|
||
|
|
'category' => $category,
|
||
|
|
));
|
||
|
|
$focus->assigned_ecmemployee_id = $ecmemployee->id; // MFH Bug #13862
|
||
|
|
$focus->deleted = 0;
|
||
|
|
$focus->contents = base64_encode(serialize($contents));
|
||
|
|
$focus->category = $category;
|
||
|
|
$focus->save();
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Resets preferences for a particular ecmemployee. If $category is null all ecmemployee preferences will be reset
|
||
|
|
*
|
||
|
|
* @param string $category category to reset
|
||
|
|
*/
|
||
|
|
public function resetPreferences(
|
||
|
|
$category = null
|
||
|
|
)
|
||
|
|
{
|
||
|
|
$ecmemployee = $this->_ecmemployeeFocus;
|
||
|
|
|
||
|
|
$GLOBALS['log']->debug('Reseting Preferences for ecmemployee ' . $ecmemployee->ecmemployee_name);
|
||
|
|
|
||
|
|
$remove_tabs = $this->getPreference('remove_tabs');
|
||
|
|
$favorite_reports = $this->getPreference('favorites', 'Reports');
|
||
|
|
$home_pages = $this->getPreference('pages', 'home');
|
||
|
|
$home_dashlets = $this->getPreference('dashlets', 'home');
|
||
|
|
$ut = $this->getPreference('ut');
|
||
|
|
$timezone = $this->getPreference('timezone');
|
||
|
|
|
||
|
|
$query = "UPDATE ecmemployee_preferences SET deleted = 1 WHERE assigned_ecmemployee_id = '" . $ecmemployee->id . "'";
|
||
|
|
if($category)
|
||
|
|
$query .= " AND category = '" . $category . "'";
|
||
|
|
$this->db->query($query);
|
||
|
|
|
||
|
|
|
||
|
|
if($category) {
|
||
|
|
unset($_SESSION[$ecmemployee->ecmemployee_name."_PREFERENCES"][$category]);
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
unset($_SESSION[$ecmemployee->ecmemployee_name."_PREFERENCES"]);
|
||
|
|
if($ecmemployee->id == $GLOBALS['current_ecmemployee']->id) {
|
||
|
|
session_destroy();
|
||
|
|
}
|
||
|
|
$this->setPreference('remove_tabs', $remove_tabs);
|
||
|
|
$this->setPreference('favorites', $favorite_reports, 'Reports');
|
||
|
|
$this->setPreference('pages', $home_pages, 'home');
|
||
|
|
$this->setPreference('dashlets', $home_dashlets, 'home');
|
||
|
|
$this->setPreference('ut', $ut);
|
||
|
|
$this->setPreference('timezone', $timezone);
|
||
|
|
$this->savePreferencesToDB();
|
||
|
|
if($ecmemployee->id == $GLOBALS['current_ecmemployee']->id) {
|
||
|
|
SugarApplication::redirect('index.php');
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Updates every ecmemployee pref with a new key value supports 2 levels deep, use append to
|
||
|
|
* array if you want to append the value to an array
|
||
|
|
*/
|
||
|
|
public static function updateAllEcmEmployeePrefs(
|
||
|
|
$key,
|
||
|
|
$new_value,
|
||
|
|
$sub_key = '',
|
||
|
|
$is_value_array = false,
|
||
|
|
$unset_value = false )
|
||
|
|
{
|
||
|
|
global $current_ecmemployee, $db;
|
||
|
|
|
||
|
|
// Admin-only function; die if calling as a non-admin
|
||
|
|
if(!is_admin($current_ecmemployee)){
|
||
|
|
sugar_die('only admins may call this function');
|
||
|
|
}
|
||
|
|
|
||
|
|
// we can skip this if we've already upgraded to the ecmemployee_preferences format.
|
||
|
|
if ( !array_key_exists('ecmemployee_preferences',$db->getHelper()->get_columns('ecmemployees')) )
|
||
|
|
return;
|
||
|
|
|
||
|
|
$result = $db->query("SELECT id, ecmemployee_preferences, ecmemployee_name FROM ecmemployees");
|
||
|
|
while ($row = $db->fetchByAssoc($result)) {
|
||
|
|
$prefs = array();
|
||
|
|
$newprefs = array();
|
||
|
|
|
||
|
|
$prefs = unserialize(base64_decode($row['ecmemployee_preferences']));
|
||
|
|
|
||
|
|
if(!empty($sub_key)){
|
||
|
|
if($is_value_array ){
|
||
|
|
if(!isset($prefs[$key][$sub_key])){
|
||
|
|
continue;
|
||
|
|
}
|
||
|
|
|
||
|
|
if(empty($prefs[$key][$sub_key])){
|
||
|
|
$prefs[$key][$sub_key] = array();
|
||
|
|
}
|
||
|
|
$already_exists = false;
|
||
|
|
foreach($prefs[$key][$sub_key] as $k=>$value){
|
||
|
|
if($value == $new_value){
|
||
|
|
|
||
|
|
$already_exists = true;
|
||
|
|
if($unset_value){
|
||
|
|
unset($prefs[$key][$sub_key][$k]);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if(!$already_exists && !$unset_value){
|
||
|
|
$prefs[$key][$sub_key][] = $new_value;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else{
|
||
|
|
if(!$unset_value)$prefs[$key][$sub_key] = $new_value;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else{
|
||
|
|
if($is_value_array ){
|
||
|
|
if(!isset($prefs[$key])){
|
||
|
|
continue;
|
||
|
|
}
|
||
|
|
|
||
|
|
if(empty($prefs[$key])){
|
||
|
|
$prefs[$key] = array();
|
||
|
|
}
|
||
|
|
$already_exists = false;
|
||
|
|
foreach($prefs[$key] as $k=>$value){
|
||
|
|
if($value == $new_value){
|
||
|
|
$already_exists = true;
|
||
|
|
|
||
|
|
if($unset_value){
|
||
|
|
unset($prefs[$key][$k]);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if(!$already_exists && !$unset_value){
|
||
|
|
|
||
|
|
$prefs[$key][] = $new_value;
|
||
|
|
}
|
||
|
|
}else{
|
||
|
|
if(!$unset_value)$prefs[$key] = $new_value;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$newstr = $GLOBALS['db']->quote(base64_encode(serialize($prefs)));
|
||
|
|
$db->query("UPDATE ecmemployees SET ecmemployee_preferences = '{$newstr}' WHERE id = '{$row['id']}'");
|
||
|
|
}
|
||
|
|
|
||
|
|
unset($prefs);
|
||
|
|
unset($newprefs);
|
||
|
|
unset($newstr);
|
||
|
|
}
|
||
|
|
}
|