/**
* <p>Возвращает данные по указанному <a href="http://dev.1c-bitrix.ru/api_help/statistic/terms.php#guest">посетителю</a>.</p>
*
*
*
*
* @param int $guest_id ID посетителя.
*
*
*
* @return CDBResult
*
*
* <h4>Example</h4>
* <pre>
* <?
* $guest_id = 1;
* if ($rs = <b>CGuest::GetByID</b>($guest_id))
* {
* $ar = $rs->Fetch();
* // выведем параметры посетителя
* echo "<pre>"; print_r($ar); echo "</pre>";
* }
* ?>
* </pre>
*
*
*
* <h4>See Also</h4>
* <ul><li> <a href="http://dev.1c-bitrix.ru/api_help/statistic/terms.php#guest">Термин "Посетитель"</a>
* </li></ul><a name="examples"></a>
*
*
* @static
* @link http://dev.1c-bitrix.ru/api_help/statistic/classes/cguest/getbyid.php
* @author Bitrix
*/
public static function GetByID($ID)
{
$DB = CDatabase::GetModuleConnection('statistic');
$ID = intval($ID);
$res = $DB->Query("
SELECT
G.*,
".$DB->DateToCharFunction("G.FIRST_DATE")." FIRST_DATE,
".$DB->DateToCharFunction("G.LAST_DATE")." LAST_DATE,
".CStatistics::DBDateDiff("FS.DATE_LAST","FS.DATE_FIRST")." FSESSION_TIME,
".CStatistics::DBDateDiff("LS.DATE_LAST","LS.DATE_FIRST")." LSESSION_TIME,
FS.HITS FSESSION_HITS,
LS.HITS LSESSION_HITS,
C.NAME COUNTRY_NAME,
CITY.REGION REGION_NAME,
CITY.NAME CITY_NAME,
G.LAST_CITY_INFO
FROM
b_stat_guest G
INNER JOIN b_stat_country C ON (C.ID = G.LAST_COUNTRY_ID)
LEFT JOIN b_stat_session FS ON (FS.ID = G.FIRST_SESSION_ID)
LEFT JOIN b_stat_session LS ON (LS.ID = G.LAST_SESSION_ID)
LEFT JOIN b_stat_city CITY ON (CITY.ID = G.LAST_CITY_ID)
WHERE
G.ID = '$ID'
", false, "File: ".__FILE__."<br>Line: ".__LINE__);
$res = new CStatResult($res);
return $res;
}