| Server IP : 37.220.80.31 / Your IP : 3.142.114.199 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/perfmon/classes/general/ |
Upload File : |
<?php
class CPerfomanceHistory
{
public static function GetList($arOrder, $arFilter = array())
{
global $DB;
if (!is_array($arOrder))
$arOrder = array();
if (count($arOrder) < 1)
$arOrder = array(
"ID" => "DESC",
);
$arQueryOrder = array();
foreach ($arOrder as $strColumn => $strDirection)
{
$strColumn = mb_strtoupper($strColumn);
$strDirection = mb_strtoupper($strDirection) == "ASC"? "ASC": "DESC";
switch ($strColumn)
{
case "ID":
$arQueryOrder[$strColumn] = $strColumn." ".$strDirection;
break;
}
}
static $arWhereFields = array(
"ID" => array(
"TABLE_ALIAS" => "h",
"FIELD_NAME" => "ID",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
);
$obQueryWhere = new CSQLWhere;
$obQueryWhere->SetFields($arWhereFields);
$strSql = "
SELECT
h.*
,".$DB->DateToCharFunction("h.TIMESTAMP_X")." TIMESTAMP_X
FROM
b_perf_history h
";
if (!is_array($arFilter))
$arFilter = array();
if ($strQueryWhere = $obQueryWhere->GetQuery($arFilter))
{
$strSql .= "
WHERE
".$strQueryWhere."
";
}
if (count($arQueryOrder) > 0)
{
$strSql .= "
ORDER BY
".implode(", ", $arQueryOrder)."
";
}
return $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
}
public static function Delete($ID)
{
global $DB;
$ID = intval($ID);
return $DB->Query("DELETE FROM b_perf_history WHERE ID = ".$ID);
}
public static function Add($arFields)
{
global $DB;
if ($arFields["TOTAL_MARK"] > 0)
{
$arFields["ACCELERATOR_ENABLED"] = $arFields["ACCELERATOR_ENABLED"] === "Y"? "Y": "N";
$arFields["~TIMESTAMP_X"] = $DB->CurrentTimeFunction();
return $DB->Add("b_perf_history", $arFields);
}
else
{
return false;
}
}
}