- Модуль: statistic
- Путь к файлу: ~/bitrix/modules/statistic/classes/mysql/statistic.php
- Класс: CStatistics
- Вызов: CStatistics::SetNewDayForSite
static function SetNewDayForSite($SITE_ID=false, $HOSTS=0, $TOTAL_HOSTS=0, $SESSIONS=0, $HITS=0)
{
$err_mess = "File: ".__FILE__."
Line: ";
$DB = CDatabase::GetModuleConnection('statistic');
if ($SITE_ID===false)
{
$SITE_ID = "";
if (!(defined("ADMIN_SECTION") && ADMIN_SECTION===true) && defined("SITE_ID"))
{
$SITE_ID = SITE_ID;
}
}
if ($SITE_ID <> '')
{
$strSql = "SELECT D.ID FROM b_stat_day_site D WHERE D.DATE_STAT=CURDATE() AND SITE_ID = '".$DB->ForSql($SITE_ID, 2)."'";
$rs = $DB->Query($strSql, false, $err_mess.__LINE__);
if (!$rs->Fetch())
{
$arFields = Array(
"DATE_STAT" => "curdate()",
"SITE_ID" => "'".$DB->ForSql($SITE_ID, 2)."'",
"C_HOSTS" => intval($HOSTS),
"SESSIONS" => intval($SESSIONS),
"HITS" => intval($HITS),
);
$ID = $DB->Insert("b_stat_day_site", $arFields, $err_mess.__LINE__, false, "", true);
}
//Calculate attentiveness for yesturday
$strSql = "
SELECT D.ID, ".$DB->DateToCharFunction("D.DATE_STAT","SHORT")." DATE_STAT
FROM b_stat_day_site D
WHERE D.DATE_STAT=DATE_SUB(CURDATE(),INTERVAL 1 DAY)
AND SITE_ID = '".$DB->ForSql($SITE_ID, 2)."'
";
$rs = $DB->Query($strSql, false, $err_mess.__LINE__);
if($ar=$rs->Fetch())
{
$arF = CSession::GetAttentiveness($ar["DATE_STAT"], $SITE_ID);
if (is_array($arF)) $DB->Update("b_stat_day_site",$arF,"WHERE ID='".$ar["ID"]."'",$err_mess.__LINE__);
}
}
}