| Server IP : 37.220.80.31 / Your IP : 3.12.74.189 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/iblock/classes/mysql/ |
Upload File : |
<?php
class CIBlock extends CAllIBlock
{
///////////////////////////////////////////////////////////////////
// List of blocks
///////////////////////////////////////////////////////////////////
public static function GetList($arOrder=Array("SORT"=>"ASC"), $arFilter=Array(), $bIncCnt = false)
{
global $DB, $USER;
$strSqlSearch = "";
$bAddSites = false;
foreach($arFilter as $key => $val)
{
$res = CIBlock::MkOperationFilter($key);
$key = mb_strtoupper($res["FIELD"]);
$cOperationType = $res["OPERATION"];
switch($key)
{
case "ACTIVE":
$sql = CIBlock::FilterCreate("B.ACTIVE", $val, "string_equal", $cOperationType);
break;
case "LID":
case "SITE_ID":
$sql = CIBlock::FilterCreate("BS.SITE_ID", $val, "string_equal", $cOperationType);
if($sql <> '')
{
$bAddSites = true;
}
break;
case "NAME":
case "CODE":
case "XML_ID":
case "PROPERTY_INDEX":
$sql = CIBlock::FilterCreate("B.".$key, $val, "string", $cOperationType);
break;
case "EXTERNAL_ID":
$sql = CIBlock::FilterCreate("B.XML_ID", $val, "string", $cOperationType);
break;
case "TYPE":
$sql = CIBlock::FilterCreate("B.IBLOCK_TYPE_ID", $val, "string", $cOperationType);
break;
case "ID":
case "VERSION":
case "SOCNET_GROUP_ID":
$sql = CIBlock::FilterCreate("B.".$key, $val, "number", $cOperationType);
break;
default:
$sql = "";
break;
}
if($sql <> '')
{
$strSqlSearch .= " AND (".$sql.") ";
}
}
$bCheckPermissions =
!array_key_exists("CHECK_PERMISSIONS", $arFilter)
|| $arFilter["CHECK_PERMISSIONS"] !== "N"
|| array_key_exists("OPERATION", $arFilter)
;
$bIsAdmin = is_object($USER) && $USER->IsAdmin();
$permissionsBy = null;
if ($bCheckPermissions && isset($arFilter['PERMISSIONS_BY']))
{
$permissionsBy = (int)$arFilter['PERMISSIONS_BY'];
if ($permissionsBy < 0)
$permissionsBy = null;
}
if($bCheckPermissions && ($permissionsBy !== null || !$bIsAdmin))
{
$min_permission = (mb_strlen($arFilter["MIN_PERMISSION"]) == 1) ? $arFilter["MIN_PERMISSION"] : "R";
if ($permissionsBy !== null)
{
$iUserID = $permissionsBy;
$strGroups = implode(',', CUser::GetUserGroup($permissionsBy));
$bAuthorized = false;
}
else
{
if (is_object($USER))
{
$iUserID = (int)$USER->GetID();
$strGroups = $USER->GetGroups();
$bAuthorized = $USER->IsAuthorized();
}
else
{
$iUserID = 0;
$strGroups = "2";
$bAuthorized = false;
}
}
$stdPermissions = "
SELECT IBLOCK_ID
FROM b_iblock_group IBG
WHERE IBG.GROUP_ID IN (".$strGroups.")
AND IBG.PERMISSION >= '".$min_permission."'
";
if(!defined("ADMIN_SECTION"))
$stdPermissions .= "
AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
";
if ($arFilter["OPERATION"] <> '')
$operation = "'".$DB->ForSql($arFilter["OPERATION"])."'";
elseif($min_permission >= "X")
$operation = "'iblock_edit'";
elseif($min_permission >= "U")
$operation = "'element_edit'";
elseif($min_permission >= "S")
$operation = "'iblock_admin_display'";
else
$operation = "'section_read', 'element_read', 'section_element_bind', 'section_section_bind'";
if($operation)
{
$acc = new CAccess;
$acc->UpdateCodes($permissionsBy !== null ? array('USER_ID' => $permissionsBy) : false);
$extPermissions = "
SELECT IBLOCK_ID
FROM b_iblock_right IBR
INNER JOIN b_task_operation T ON T.TASK_ID = IBR.TASK_ID
INNER JOIN b_operation O ON O.ID = T.OPERATION_ID
".($iUserID > 0? "LEFT": "INNER")." JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = ".$iUserID."
WHERE IBR.ENTITY_TYPE = 'iblock'
AND O.NAME in (".$operation.")
".($bAuthorized || $iUserID > 0? "AND (UA.USER_ID IS NOT NULL OR IBR.GROUP_CODE = 'AU')": "")."
";
$sqlPermissions = "AND (
B.ID IN ($stdPermissions)
OR (B.RIGHTS_MODE = 'E' AND B.ID IN ($extPermissions))
)";
}
else
{
$sqlPermissions = "AND (
B.ID IN ($stdPermissions)
)";
}
}
else
{
$sqlPermissions = "";
}
if ($bAddSites)
$sqlJoinSites = "LEFT JOIN b_iblock_site BS ON B.ID=BS.IBLOCK_ID
LEFT JOIN b_lang L ON L.LID=BS.SITE_ID";
else
$sqlJoinSites = "INNER JOIN b_lang L ON L.LID=B.LID";
if(!$bIncCnt)
{
$strSql = "
SELECT DISTINCT
B.*
,B.XML_ID as EXTERNAL_ID
,".$DB->DateToCharFunction("B.TIMESTAMP_X")." as TIMESTAMP_X
,L.DIR as LANG_DIR
,L.SERVER_NAME
FROM
b_iblock B
".$sqlJoinSites."
WHERE 1 = 1
".$sqlPermissions."
".$strSqlSearch."
";
}
else
{
$strSql = "
SELECT
B.*
,B.XML_ID as EXTERNAL_ID
,".$DB->DateToCharFunction("B.TIMESTAMP_X")." as TIMESTAMP_X
,L.DIR as LANG_DIR
,L.SERVER_NAME
,COUNT(DISTINCT BE.ID) as ELEMENT_CNT
FROM
b_iblock B
".$sqlJoinSites."
LEFT JOIN b_iblock_element BE ON (BE.IBLOCK_ID=B.ID
AND (
(BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL )
".($arFilter["CNT_ALL"]=="Y"? " OR BE.WF_NEW='Y' ":"")."
)
".($arFilter["CNT_ACTIVE"]=="Y"?
"AND BE.ACTIVE='Y'
AND (BE.ACTIVE_TO >= ".$DB->CurrentDateFunction()." OR BE.ACTIVE_TO IS NULL)
AND (BE.ACTIVE_FROM <= ".$DB->CurrentDateFunction()." OR BE.ACTIVE_FROM IS NULL)
":
"")."
)
WHERE 1 = 1
".$sqlPermissions."
".$strSqlSearch."
GROUP BY B.ID
";
}
$arSqlOrder = Array();
if(is_array($arOrder))
{
foreach($arOrder as $by=>$order)
{
$by = mb_strtolower($by);
$order = mb_strtolower($order);
if ($order!="asc")
$order = "desc";
if ($by == "id") $arSqlOrder[$by] = " B.ID ".$order." ";
elseif ($by == "lid") $arSqlOrder[$by] = " B.LID ".$order." ";
elseif ($by == "iblock_type") $arSqlOrder[$by] = " B.IBLOCK_TYPE_ID ".$order." ";
elseif ($by == "name") $arSqlOrder[$by] = " B.NAME ".$order." ";
elseif ($by == "active") $arSqlOrder[$by] = " B.ACTIVE ".$order." ";
elseif ($by == "sort") $arSqlOrder[$by] = " B.SORT ".$order." ";
elseif ($by == "code") $arSqlOrder[$by] = " B.CODE ".$order." ";
elseif ($bIncCnt && $by == "element_cnt") $arSqlOrder[$by] = " ELEMENT_CNT ".$order." ";
else
{
$by = "timestamp_x";
$arSqlOrder[$by] = " B.TIMESTAMP_X ".$order." ";
}
}
}
if(count($arSqlOrder) > 0)
$strSqlOrder = " ORDER BY ".implode(",", $arSqlOrder);
else
$strSqlOrder = "";
$res = $DB->Query($strSql.$strSqlOrder, false, "FILE: ".__FILE__."<br> LINE: ".__LINE__);
return $res;
}
public static function _Upper($str)
{
return $str;
}
public function _Add($ID)
{
global $DB;
$err_mess = "FILE: ".__FILE__."<br>LINE: ";
$ID = intval($ID);
if(defined("MYSQL_TABLE_TYPE") && MYSQL_TABLE_TYPE <> '')
{
$DB->Query("SET storage_engine = '".MYSQL_TABLE_TYPE."'", true);
}
$strSql = "
CREATE TABLE IF NOT EXISTS b_iblock_element_prop_s".$ID." (
IBLOCK_ELEMENT_ID int(11) not null REFERENCES b_iblock_element(ID),
primary key (IBLOCK_ELEMENT_ID)
)
";
$rs = $DB->DDL($strSql, false, $err_mess.__LINE__);
$strSql = "
CREATE TABLE IF NOT EXISTS b_iblock_element_prop_m".$ID." (
ID int(11) not null auto_increment,
IBLOCK_ELEMENT_ID int(11) not null REFERENCES b_iblock_element(ID),
IBLOCK_PROPERTY_ID int(11) not null REFERENCES b_iblock_property(ID),
VALUE text not null,
VALUE_ENUM int(11),
VALUE_NUM numeric(18,4),
DESCRIPTION VARCHAR(255) NULL,
PRIMARY KEY (ID),
INDEX ix_iblock_elem_prop_m".$ID."_1(IBLOCK_ELEMENT_ID,IBLOCK_PROPERTY_ID),
INDEX ix_iblock_elem_prop_m".$ID."_2(IBLOCK_PROPERTY_ID),
INDEX ix_iblock_elem_prop_m".$ID."_3(VALUE_ENUM,IBLOCK_PROPERTY_ID)
)
";
if($rs)
$rs = $DB->DDL($strSql, false, $err_mess.__LINE__);
return $rs;
}
public static function _Order($by, $order, $default_order, $nullable = true)
{
$o = parent::_Order($by, $order, $default_order, $nullable);
//$o[0] - bNullsFirst
//$o[1] - asc|desc
if($o[0])
{
if($o[1] == "asc")
{
return $by." asc";
}
else
{
return "length(".$by.")>0 asc, ".$by." desc";
}
}
else
{
if($o[1] == "asc")
{
return "length(".$by.")>0 desc, ".$by." asc";
}
else
{
return $by." desc";
}
}
}
public static function _NotEmpty($column)
{
return "if(".$column." is null, 0, 1)";
}
}