User::getModuleAdminList

static function getModuleAdminList($siteIdList)
{
	global $DB;

	$cacheKey = serialize($siteIdList);
	if (!array_key_exists($cacheKey, self::$moduleAdminListCache))
	{
		$cache = new CPHPCache;
		$cacheTime = 31536000;
		$cacheId = 'site'.($siteIdList ? '_'.implode('|', $siteIdList) : '').'new';
		$cachePath = "/sonet/user_admin/";

		$adminList = $moduleAdminList = array();

		if ($cache->initCache($cacheTime, $cacheId, $cachePath))
		{
			$cacheVars = $cache->getVars();
			$adminList = $cacheVars["ADMIN"];
			$moduleAdminList = $cacheVars["MODULE_ADMIN"];
		}
		else
		{
			$cache->startDataCache($cacheTime, $cacheId, $cachePath);

			$connection = MainHttpApplication::getConnection();
			$helper = $connection->getSqlHelper();

			$sql = "SELECT 
				UG.USER_ID U_ID, 
				MAX(".$DB->datetimeToTimestampFunction("UG.DATE_ACTIVE_FROM").") UG_DATE_FROM_TS, 
				MAX(".$DB->datetimeToTimestampFunction("UG.DATE_ACTIVE_TO").") UG_DATE_TO_TS
				FROM 
					b_user_group UG 
				WHERE
					UG.GROUP_ID = 1
				GROUP BY 
					UG.USER_ID";

			$result = $connection->query($sql);

			while($ar = $result->fetch())
			{
				if(!array_key_exists($ar["U_ID"], $moduleAdminList))
				{
					$adminList[$ar["U_ID"]] = array(
						"USER_ID" => $ar["U_ID"],
						"DATE_FROM_TS" => $ar["UG_DATE_FROM_TS"],
						"DATE_TO_TS" => $ar["UG_DATE_TO_TS"]
					);
				}
			}

			if(!$siteIdList)
			{
				$sqlSite = "AND MG.SITE_ID IS NULL";
			}
			else
			{
				$sqlSite = " AND (";
				foreach($siteIdList as $i => $siteId)
				{
					if($i > 0)
					{
						$sqlSite .= " OR ";
					}

					$sqlSite .= "MG.SITE_ID " . ($siteId ? "= '" . $helper->forSQL($siteId) . "'" : "IS NULL");
				}
				$sqlSite .= ")";
			}

			$sql = "SELECT 
				UG.USER_ID U_ID, 
				G.ID G_ID, 
				MAX(".$DB->datetimeToTimestampFunction("UG.DATE_ACTIVE_FROM").") UG_DATE_FROM_TS, 
				MAX(".$DB->datetimeToTimestampFunction("UG.DATE_ACTIVE_TO").") UG_DATE_TO_TS, 
				MAX(MG.G_ACCESS) G_ACCESS 
				FROM 
					b_user_group UG, 
					b_module_group MG, 
					b_group G  
				WHERE
					G.ID = UG.GROUP_ID
					AND (
						G.ID = MG.GROUP_ID 
						AND MG.MODULE_ID = 'socialnetwork' 
						AND G.ACTIVE = 'Y' 
						AND G_ACCESS >= 'W' 
						AND (
							G.ANONYMOUS <> 'Y' 
							OR G.ANONYMOUS IS NULL
						) ".
						$sqlSite ."
					)
				GROUP BY 
					UG.USER_ID, G.ID";

			$result = $connection->query($sql);

			while($ar = $result->fetch())
			{
				if(!array_key_exists($ar["U_ID"], $moduleAdminList))
				{
					$moduleAdminList[$ar["U_ID"]] = array(
						"USER_ID" => $ar["U_ID"],
						"DATE_FROM_TS" => $ar["UG_DATE_FROM_TS"],
						"DATE_TO_TS" => $ar["UG_DATE_TO_TS"]
					);
				}
			}
		}

		$cacheData = Array(
			"ADMIN" => $adminList,
			"MODULE_ADMIN" => $moduleAdminList
		);

		$cache->endDataCache($cacheData);

		foreach ($adminList as $key => $arUserData)
		{
			if (
				(
					!empty($arUserData["DATE_FROM_TS"])
					&& $arUserData["DATE_FROM_TS"] > time()
				)
				|| (
					!empty($arUserData["DATE_TO_TS"])
					&& $arUserData["DATE_TO_TS"] < time()
				)
			)
			{
				unset($adminList[$key]);
			}
		}

		foreach ($moduleAdminList as $key => $arUserData)
		{
			if (
				(
					!empty($arUserData["DATE_FROM_TS"])
					&& $arUserData["DATE_FROM_TS"] > time()
				)
				|| (
					!empty($arUserData["DATE_TO_TS"])
					&& $arUserData["DATE_TO_TS"] < time()
				)
				|| (
					isset($adminList[$key])
					&& (
						empty($adminList[$key]["DATE_TO_TS"])
						|| $adminList[$key]["DATE_TO_TS"] > $arUserData["DATE_FROM_TS"]
					)
				)
			)
			{
				unset($moduleAdminList[$key]);
			}
		}

		self::$moduleAdminListCache[$cacheKey] = $adminList + $moduleAdminList;
	}

	return self::$moduleAdminListCache[$cacheKey];
}