<?php

class CAllSocNetLogSmartFilter
{
	public static function GetList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array())
	{
		global $DB;

		if (count($arSelectFields) <= 0)
			$arSelectFields = array("USER_ID", "TYPE");

		// FIELDS -->
		$arFields = array(
			"USER_ID" => Array("FIELD" => "SLSF.USER_ID", "TYPE" => "int"),
			"TYPE" => array("FIELD" => "SLSF.TYPE", "TYPE" => "char")
		);
		// <-- FIELDS

		$arSqls = CSocNetGroup::PrepareSql($arFields, $arOrder, $arFilter, false, $arSelectFields);

		$arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]);

		$strSql =
			"SELECT ".$arSqls["SELECT"]." ".
			"FROM b_sonet_log_smartfilter SLSF ".
			"	".$arSqls["FROM"]." ";
		if ($arSqls["WHERE"] <> '')
			$strSql .= "WHERE ".$arSqls["WHERE"]." ";
		if ($arSqls["ORDERBY"] <> '')
			$strSql .= "ORDER BY ".$arSqls["ORDERBY"]." ";

		$dbRes = $DB->Query($strSql);

		return $dbRes;
	}

	public static function DeleteEx($user_id)
	{
		global $DB;
		
		$user_id = intval($user_id);

		if ($user_id <= 0)
			return false;
		
		$strWhere = " USER_ID = ".$user_id;

		$strSQL = "DELETE FROM b_sonet_log_smartfilter WHERE ".$strWhere;
		if ($DB->Query($strSQL))
			return true;
		else
			return false;
	}

	public static function GetDefaultValue($user_id)
	{
		if (intval($user_id) <= 0)
			return false;

		if(defined("BX_COMP_MANAGED_CACHE"))
			$ttl = 2592000;
		else
			$ttl = 600;

		$cache_id = 'sonet_smartfilter_default_'.$user_id;
		$obCache = new CPHPCache;
		$cache_dir = '/sonet/log_smartfilter/';

		if($obCache->InitCache($ttl, $cache_id, $cache_dir))
		{
			$tmpVal = $obCache->GetVars();
			$default_value = $tmpVal["VALUE"];
			unset($tmpVal);
		}
		else
		{
			$default_value = false;
			
			if (is_object($obCache))
				$obCache->StartDataCache($ttl, $cache_id, $cache_dir);

			$rsSmartFilter = CSocNetLogSmartFilter::GetList(
				array(),
				array(
					"USER_ID" => $user_id
				),
				array("TYPE")
			);
			if ($arSmartFilter = $rsSmartFilter->Fetch())
				$default_value = $arSmartFilter["TYPE"];

			if (is_object($obCache))
			{
				$arCacheData = Array(
					"VALUE" => $default_value
				);
				$obCache->EndDataCache($arCacheData);
			}
		}
		unset($obCache);

		if (!$default_value)
			$default_value = COption::GetOptionString("socialnetwork", "sonet_log_smart_filter", "N", "");

		return $default_value;
	}
}