| Server IP : 37.220.80.31 / Your IP : 3.135.221.112 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 CPerfomanceError
{
public static function Delete($arFilter)
{
global $DB;
$obQueryWhere = new CSQLWhere;
$obQueryWhere->SetFields(array(
"HIT_ID" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "HIT_ID",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
"ERRNO" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRNO",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
"ERRFILE" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRFILE",
"FIELD_TYPE" => "string",
"JOIN" => false,
),
"ERRSTR" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRSTR",
"FIELD_TYPE" => "string",
"JOIN" => false,
),
"ERRLINE" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRLINE",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
));
$strSql = "
DELETE FROM b_perf_error
";
if (!is_array($arFilter))
$arFilter = array();
if ($strQueryWhere = $obQueryWhere->GetQuery($arFilter))
{
$strSql .= "
WHERE
".$strQueryWhere."
";
}
return $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
}
public static function GetList($arSelect, $arFilter, $arOrder, $bGroup = false)
{
global $DB;
if (!is_array($arSelect))
$arSelect = array();
if (count($arSelect) < 1)
$arSelect = array(
"ID",
"HIT_ID",
"ERRNO",
"ERRFILE",
"ERRLINE",
"ERRSTR",
);
if (!is_array($arOrder))
$arOrder = array();
if (count($arOrder) < 1)
$arOrder = array(
"HIT_ID" => "DESC",
"ID" => "DESC",
);
$arQueryOrder = array();
foreach ($arOrder as $strColumn => $strDirection)
{
$strColumn = mb_strtoupper($strColumn);
$strDirection = mb_strtoupper($strDirection) == "ASC"? "ASC": "DESC";
switch ($strColumn)
{
case "ID":
case "HIT_ID":
case "ERRNO":
case "ERRFILE":
case "ERRLINE":
case "ERRSTR":
$arSelect[] = $strColumn;
$arQueryOrder[$strColumn] = $strColumn." ".$strDirection;
break;
case "COUNT":
if ($bGroup)
{
$arSelect[] = $strColumn;
$arQueryOrder[$strColumn] = $strColumn." ".$strDirection;
}
break;
}
}
$arQueryGroup = array();
$arQuerySelect = array();
foreach ($arSelect as $strColumn)
{
$strColumn = mb_strtoupper($strColumn);
switch ($strColumn)
{
case "ID":
case "HIT_ID":
if (!$bGroup)
$arQuerySelect[$strColumn] = "e.".$strColumn;
break;
case "ERRNO":
case "ERRFILE":
case "ERRLINE":
case "ERRSTR":
if ($bGroup)
$arQueryGroup[$strColumn] = "e.".$strColumn;
$arQuerySelect[$strColumn] = "e.".$strColumn;
break;
case "COUNT":
if ($bGroup)
{
$arQuerySelect[$strColumn] = "COUNT(e.ID) ".$strColumn;
}
break;
}
}
$obQueryWhere = new CSQLWhere;
$obQueryWhere->SetFields(array(
"HIT_ID" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "HIT_ID",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
"ERRNO" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRNO",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
"ERRFILE" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRFILE",
"FIELD_TYPE" => "string",
"JOIN" => false,
),
"ERRSTR" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRSTR",
"FIELD_TYPE" => "string",
"JOIN" => false,
),
"ERRLINE" => array(
"TABLE_ALIAS" => "e",
"FIELD_NAME" => "ERRLINE",
"FIELD_TYPE" => "int",
"JOIN" => false,
),
));
if (count($arQuerySelect) < 1)
$arQuerySelect = array("ID" => "e.ID");
$strSql = "
SELECT
".implode(", ", $arQuerySelect)."
FROM
b_perf_error e
";
if (!is_array($arFilter))
$arFilter = array();
if ($strQueryWhere = $obQueryWhere->GetQuery($arFilter))
{
$strSql .= "
WHERE
".$strQueryWhere."
";
}
if ($bGroup && count($arQueryGroup) > 0)
{
$strSql .= "
GROUP BY
".implode(", ", $arQueryGroup)."
";
}
if (count($arQueryOrder) > 0)
{
$strSql .= "
ORDER BY
".implode(", ", $arQueryOrder)."
";
}
return $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
}
public static function Clear()
{
global $DB;
return $DB->Query("TRUNCATE TABLE b_perf_error");
}
}