se/SE/se-lib/UserProfile.php

<?php

/**
 * User profile.
 * @use User
 * @require User
 * 
 * $_SESSION['USER_PROFILE']['{$idTable}-hidden'] = [ idField, ... ]
 * $_SESSION['USER_PROFILE']['_table_ajax_settings'] = [ idField, ... ]
 * 
 * old:
 * $_SESSION['USER_PROFILE'][$idTable] = [ idField => 1 | 0, ... ] // old version
 */
class UserProfile {

	static function getStorageTableHiddenCols($idTable) {
		if (!empty($_SESSION['USER_PROFILE']["{$idTable}-hidden"])) {
			return $_SESSION['USER_PROFILE']["{$idTable}-hidden"];
		}
		if (!empty($_SESSION['USER_PROFILE']["{$idTable}"])) { // read from old version
			return array_keys(array_filter($_SESSION['USER_PROFILE']["{$idTable}"], function ($isFieldVisible) {
				return (!$isFieldVisible);
			}));
		}
		return [];
	}
	static function setStorageTableProfile($idTable, $tableProfile) {
		$_SESSION['USER_PROFILE'][$idTable] = $tableProfile;
	}
	static function setStorageTableHiddenCols($idTable, $hiddenCols) {
		unset($_SESSION['USER_PROFILE'][$idTable]); // clean up old version
		$filteredHiddenCols = array_filter($hiddenCols, [ 'V', 'filterPositiveInteger' ]);
		if (empty($filteredHiddenCols)) {
			unset($_SESSION['USER_PROFILE']["{$idTable}-hidden"]);
		} else {
			$_SESSION['USER_PROFILE']["{$idTable}-hidden"] = $filteredHiddenCols;
		}
	}
	static function removeStorageTableProfile($idTable) {
		unset($_SESSION['USER_PROFILE'][$idTable]); // every column is visible
	}

	public static function load($force = false) {
		if ($force) {
			$_SESSION['USER_PROFILE'] = array();
		}
		if (empty($_SESSION['USER_PROFILE'])) {
			$_SESSION['USER_PROFILE'] = array();
			// load user profile (hidden column, UserBookmarks)
			$sql = "select `ADM_WWW_PROFILE` from `ADMIN_USERS` where `ADM_ACCOUNT`='".User::getName()."' limit 0,1 ";
			$db = DB::getDB();
			$res = $db->query($sql);
			while ($h = $db->fetch($res)) {
				$ADM_WWW_PROFILE = "{$h->ADM_WWW_PROFILE}";
				if (!empty($ADM_WWW_PROFILE)) {
					if (' Array' === substr($ADM_WWW_PROFILE, 0, 6) || 'Array' === substr($ADM_WWW_PROFILE, 0, 5)) {
						eval("\$_SESSION['USER_PROFILE'] = {$ADM_WWW_PROFILE} ;");
					} else {
						$profileFromJson = json_decode($ADM_WWW_PROFILE);
						if ($profileFromJson && !empty($profileFromJson)) {
							$profileFromJson = (array)$profileFromJson;
							foreach ($profileFromJson as $k => $v) {
								$profileFromJson[$k] = (array)$v;
							}
							$_SESSION['USER_PROFILE'] = $profileFromJson;
						} else {
							$_SESSION['USER_PROFILE'] = array();
						}
					}
				} else {
					$_SESSION['USER_PROFILE'] = array();
				}
			}
		}
		return $_SESSION['USER_PROFILE'];
	}

	public static function set($key, $val) {
		self::load();// profile must be loaded
		$_SESSION['USER_PROFILE'][$key] = $val;
	}

	public static function get($key) {
		self::load();// profile must be loaded
		return V::get($key, '', $_SESSION['USER_PROFILE']);
	}

	public static function getColumn($column_name, $key) { // TODO: use only in Column.php (only by procesy5.php)
		self::load();// profile must be loaded
		if (!empty($_SESSION['USER_PROFILE'][$column_name][$key])) {
			return $_SESSION['USER_PROFILE'][$column_name][$key];
		}
		return null;
	}

	public static function save() {
		self::load();// profile must be loaded
		$db = DB::getDB();

		if(0){// old way
			$USER_PROFILE = $_SESSION['USER_PROFILE'];
			reset($USER_PROFILE);
			$VAR = " Array ( ";
			for ( ;(key($USER_PROFILE)); next($USER_PROFILE)) {
				$VAR = $VAR . "\"" .  key($USER_PROFILE) . "\" => Array ( ";
				for ( ;(key($USER_PROFILE[key($USER_PROFILE)])); next($USER_PROFILE[key($USER_PROFILE)])) {
					$VAR = $VAR . " \"" . key($USER_PROFILE[key($USER_PROFILE)]) . "\"=>\"" . $USER_PROFILE[key($USER_PROFILE)][key($USER_PROFILE[key($USER_PROFILE)])] . "\"," ;
				}
				$VAR = $VAR . " ), ";
			}
			$VAR = $VAR . " ) " ;
			if(0){// old way debug
				echo'<pre>$VAR('.strlen($VAR).'):';print_r($VAR);echo'</pre>';//!!
				$profileJson = json_encode($_SESSION['USER_PROFILE']);
				echo'<pre>json_encode('.strlen($profileJson).'):';print_r($profileJson);echo'</pre>';//!!
				echo'<pre>profileRaw:';print_r($_SESSION['USER_PROFILE']);echo'</pre>';//!!
				$profileFromJson = json_decode($profileJson);
				echo'<pre>profileFromJson:';print_r($profileFromJson);echo'</pre>';
			}// old way debug
		}// old way
		$VAR = json_encode($_SESSION['USER_PROFILE']);
		$sql = "update `ADMIN_USERS` set `ADM_WWW_PROFILE`='{$VAR}' where  `ADM_ACCOUNT`='".User::getName()."' limit 1 ";
		$res = $db->query($sql);
		if (($affected = $db->affected_rows($res)) != 1) {
			// TODO: error msg
		}
		return $VAR;
	}

	public static function isHiddenColumn($idTable, $idField) {
		return in_array($idField, self::getStorageTableHiddenCols($idTable));
	}

	static function setTableFieldVisible($idTable, $idField) {
		self::setStorageTableHiddenCols($idTable, array_filter(
			self::getStorageTableHiddenCols($idTable),
			function ($idHiddenCol) use ($idField) {
				return ($idHiddenCol != $idField);
			}
		));
	}
	static function setTableFieldHidden($idTable, $idField) {
		self::setStorageTableHiddenCols($idTable, array_unique(array_merge(
			self::getStorageTableHiddenCols($idTable),
			[ $idField ]
		)));
	}

	public static function getTableAjaxSettings() {
		$tableAjaxSettings = array();
		if (array_key_exists('_table_ajax_settings', $_SESSION['USER_PROFILE'])) {
			$tableAjaxSettings = $_SESSION['USER_PROFILE']['_table_ajax_settings'];
		}
		return $tableAjaxSettings;
	}

	public static function setTableAjaxSettings($tableAjaxSettings) { // @used 'pageSize' in TableAjax
		$_SESSION['USER_PROFILE']['_table_ajax_settings'] = $tableAjaxSettings;
	}

}