function GetSectionElementsCount($ID, $arFilter = array())
{
global $DB, $USER;
$arJoinProps = array();
$bJoinFlatProp = false;
$arSqlSearch = array();
if (array_key_exists("PROPERTY", $arFilter)) {
$val = $arFilter["PROPERTY"];
foreach ($val as $propID => $propVAL) {
$res = CIBlock::MkOperationFilter($propID);
$propID = $res["FIELD"];
$cOperationType = $res["OPERATION"];
if ($db_prop = CIBlockProperty::GetPropertyArray($propID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
$bSave = false;
if (array_key_exists($db_prop["ID"], $arJoinProps)) {
$iPropCnt = $arJoinProps[$db_prop["ID"]];
} elseif ($db_prop["VERSION"] != 2 || $db_prop["MULTIPLE"] == "Y") {
$bSave = true;
$iPropCnt = count($arJoinProps);
}
if (!is_array($propVAL)) {
$propVAL = array($propVAL);
}
if ($db_prop["PROPERTY_TYPE"] == "N" || $db_prop["PROPERTY_TYPE"] == "G" || $db_prop["PROPERTY_TYPE"] == "E") {
if ($db_prop["VERSION"] == 2 && $db_prop["MULTIPLE"] == "N") {
$r = CIBlock::FilterCreate("FPS.PROPERTY_" . $db_prop["ORIG_ID"], $propVAL, "number", $cOperationType);
$bJoinFlatProp = $db_prop["IBLOCK_ID"];
} else {
$r = CIBlock::FilterCreate("FPV" . $iPropCnt . ".VALUE_NUM", $propVAL, "number", $cOperationType);
}
} else {
if ($db_prop["VERSION"] == 2 && $db_prop["MULTIPLE"] == "N") {
$r = CIBlock::FilterCreate("FPS.PROPERTY_" . $db_prop["ORIG_ID"], $propVAL, "string", $cOperationType);
$bJoinFlatProp = $db_prop["IBLOCK_ID"];
} else {
$r = CIBlock::FilterCreate("FPV" . $iPropCnt . ".VALUE", $propVAL, "string", $cOperationType);
}
}
if (strlen($r) > 0) {
if ($bSave) {
$db_prop["iPropCnt"] = $iPropCnt;
$arJoinProps[$db_prop["ID"]] = $db_prop;
}
$arSqlSearch[] = $r;
}
}
}
}
$strSqlSearch = "";
foreach ($arSqlSearch as $r) {
if (strlen($r) > 0) {
$strSqlSearch .= "\n\t\t\t\tAND (" . $r . ") ";
}
}
$strSqlSearchProp = "";
foreach ($arJoinProps as $propID => $db_prop) {
if ($db_prop["VERSION"] == 2) {
$strTable = "b_iblock_element_prop_m" . $db_prop["IBLOCK_ID"];
} else {
$strTable = "b_iblock_element_property";
}
$i = $db_prop["iPropCnt"];
$strSqlSearchProp .= "\n\t\t\t\tINNER JOIN b_iblock_property FP" . $i . " ON FP" . $i . ".IBLOCK_ID=BS.IBLOCK_ID AND\n\t\t\t\t" . (IntVal($propID) > 0 ? " FP" . $i . ".ID=" . IntVal($propID) . " " : " FP" . $i . ".CODE='" . $DB->ForSQL($propID, 200) . "' ") . "\n\t\t\t\tINNER JOIN " . $strTable . " FPV" . $i . " ON FP" . $i . ".ID=FPV" . $i . ".IBLOCK_PROPERTY_ID AND FPV" . $i . ".IBLOCK_ELEMENT_ID=BE.ID\n\t\t\t";
}
if ($bJoinFlatProp) {
$strSqlSearchProp .= "\n\t\t\t\tINNER JOIN b_iblock_element_prop_s" . $bJoinFlatProp . " FPS ON FPS.IBLOCK_ELEMENT_ID = BE.ID\n\t\t\t";
}
$strHint = $DB->type == "MYSQL" ? "STRAIGHT_JOIN" : "";
$strSql = "\n\t\t\tSELECT " . $strHint . " COUNT(DISTINCT BE.ID) as CNT\n\t\t\tFROM b_iblock_section BS\n\t\t\t\tINNER JOIN b_iblock_section BSTEMP ON (BSTEMP.IBLOCK_ID=BS.IBLOCK_ID\n\t\t\t\t\tAND BSTEMP.LEFT_MARGIN >= BS.LEFT_MARGIN\n\t\t\t\t\tAND BSTEMP.RIGHT_MARGIN <= BS.RIGHT_MARGIN)\n\t\t\t\tINNER JOIN b_iblock_section_element BSE ON BSE.IBLOCK_SECTION_ID=BSTEMP.ID\n\t\t\t\tINNER JOIN b_iblock_element BE ON BE.ID=BSE.IBLOCK_ELEMENT_ID AND BE.IBLOCK_ID=BS.IBLOCK_ID\n\t\t\t" . $strSqlSearchProp . "\n\t\t\tWHERE BS.ID=" . IntVal($ID) . "\n\t\t\t\tAND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL )\n\t\t\t\t" . ($arFilter["CNT_ALL"] == "Y" ? " OR BE.WF_NEW='Y' " : "") . ")\n\t\t\t\t" . ($arFilter["CNT_ACTIVE"] == "Y" ? " AND BE.ACTIVE='Y'\n\t\t\t\t\tAND (BE.ACTIVE_TO >= " . $DB->CurrentTimeFunction() . " OR BE.ACTIVE_TO IS NULL)\n\t\t\t\t\tAND (BE.ACTIVE_FROM <= " . $DB->CurrentTimeFunction() . " OR BE.ACTIVE_FROM IS NULL)" : "") . "\n\t\t\t\t" . $strSqlSearch;
//echo "<pre>",htmlspecialcharsbx($strSql),"</pre>";
$res = $DB->Query($strSql);
$res = $res->Fetch();
return $res["CNT"];
}
function PrepareGetList(&$arIblockElementFields, &$arJoinProps, &$bOnlyCount, &$bDistinct, &$arSelectFields, &$sSelect, &$arAddSelectFields, &$arFilter, &$sWhere, &$sSectionWhere, &$arAddWhereFields, &$arGroupBy, &$sGroupBy, &$arOrder, &$arSqlOrder, &$arAddOrderByFields, &$arIBlockFilter, &$arIBlockMultProps, &$arIBlockConvProps, &$arIBlockAllProps, &$arIBlockNumProps, &$arIBlockLongProps)
{
if (is_array($arSelectFields) && (in_array("DETAIL_PAGE_URL", $arSelectFields) || in_array("CANONICAL_PAGE_URL", $arSelectFields)) && !in_array("LANG_DIR", $arSelectFields)) {
$arSelectFields[] = "LANG_DIR";
}
global $DB, $USER;
if (!is_array($arSelectFields) && $arSelectFields == "" || count($arSelectFields) <= 0 || $arSelectFields === false) {
$arSelectFields = array("*");
}
if (is_bool($arGroupBy) && $arGroupBy !== false) {
$arGroupBy = array();
}
if (is_array($arGroupBy) && count($arGroupBy) == 0) {
$bOnlyCount = true;
}
$iPropCnt = 0;
$arJoinProps = array("FP" => array(), "FPV" => array(), "FPS" => array(), "FPEN" => array(), "BE" => array(), "BE_FP" => array(), "BE_FPV" => array(), "BE_FPS" => array(), "BE_FPEN" => array(), "BES" => "", "RV" => false, "RVU" => false, "RVV" => false, "FC" => "");
$arIBlockMultProps = array();
$arIBlockAllProps = array();
$arIBlockNumProps = array();
$bWasGroup = false;
//********************************ORDER BY PART***********************************************
$arSqlOrder = array();
$arAddOrderByFields = array();
$iOrdNum = -1;
if (!is_array($arOrder)) {
$arOrder = array();
}
foreach ($arOrder as $by => $order) {
$by_orig = $by;
$by = strtoupper($by);
//Remove aliases
if ($by == "EXTERNAL_ID") {
$by = "XML_ID";
} elseif ($by == "DATE_ACTIVE_FROM") {
$by = "ACTIVE_FROM";
} elseif ($by == "DATE_ACTIVE_TO") {
$by = "ACTIVE_TO";
}
if (array_key_exists($by, $arSqlOrder)) {
continue;
}
if (substr($by, 0, 8) == "CATALOG_") {
$iOrdNum++;
$arAddOrderByFields[$iOrdNum] = array($by => $order);
//Reserve for future fill
$arSqlOrder[$iOrdNum] = false;
} else {
if ($by == "ID") {
$arSqlOrder[$by] = CIBlock::_Order("BE.ID", $order, "desc", false);
} elseif ($by == "NAME") {
$arSqlOrder[$by] = CIBlock::_Order("BE.NAME", $order, "desc", false);
} elseif ($by == "STATUS") {
$arSqlOrder[$by] = CIBlock::_Order("BE.WF_STATUS_ID", $order, "desc");
} elseif ($by == "XML_ID") {
$arSqlOrder[$by] = CIBlock::_Order("BE.XML_ID", $order, "desc");
} elseif ($by == "CODE") {
$arSqlOrder[$by] = CIBlock::_Order("BE.CODE", $order, "desc");
} elseif ($by == "TAGS") {
$arSqlOrder[$by] = CIBlock::_Order("BE.TAGS", $order, "desc");
} elseif ($by == "TIMESTAMP_X") {
$arSqlOrder[$by] = CIBlock::_Order("BE.TIMESTAMP_X", $order, "desc");
} elseif ($by == "CREATED") {
$arSqlOrder[$by] = CIBlock::_Order("BE.DATE_CREATE", $order, "desc");
} elseif ($by == "CREATED_DATE") {
$arSqlOrder[$by] = CIBlock::_Order($DB->DateFormatToDB("YYYY.MM.DD", "BE.DATE_CREATE"), $order, "desc");
} elseif ($by == "IBLOCK_ID") {
$arSqlOrder[$by] = CIBlock::_Order("BE.IBLOCK_ID", $order, "desc");
} elseif ($by == "MODIFIED_BY") {
$arSqlOrder[$by] = CIBlock::_Order("BE.MODIFIED_BY", $order, "desc");
} elseif ($by == "CREATED_BY") {
$arSqlOrder[$by] = CIBlock::_Order("BE.CREATED_BY", $order, "desc");
} elseif ($by == "ACTIVE") {
$arSqlOrder[$by] = CIBlock::_Order("BE.ACTIVE", $order, "desc");
} elseif ($by == "ACTIVE_FROM") {
$arSqlOrder[$by] = CIBlock::_Order("BE.ACTIVE_FROM", $order, "desc");
} elseif ($by == "ACTIVE_TO") {
$arSqlOrder[$by] = CIBlock::_Order("BE.ACTIVE_TO", $order, "desc");
} elseif ($by == "SORT") {
$arSqlOrder[$by] = CIBlock::_Order("BE.SORT", $order, "desc");
} elseif ($by == "IBLOCK_SECTION_ID") {
$arSqlOrder[$by] = CIBlock::_Order("BE.IBLOCK_SECTION_ID", $order, "desc");
} elseif ($by == "SHOW_COUNTER") {
$arSqlOrder[$by] = CIBlock::_Order("BE.SHOW_COUNTER", $order, "desc");
} elseif ($by == "SHOW_COUNTER_START") {
$arSqlOrder[$by] = CIBlock::_Order("BE.SHOW_COUNTER_START", $order, "desc");
} elseif ($by == "RAND") {
$arSqlOrder[$by] = CIBlockElement::GetRandFunction(true);
} elseif ($by == "SHOWS") {
$arSqlOrder[$by] = CIBlock::_Order(CIBlockElement::GetShowedFunction(), $order, "desc", false);
} elseif ($by == "HAS_PREVIEW_PICTURE") {
$arSqlOrder[$by] = CIBlock::_Order(CIBlock::_NotEmpty("BE.PREVIEW_PICTURE"), $order, "desc", false);
} elseif ($by == "HAS_DETAIL_PICTURE") {
$arSqlOrder[$by] = CIBlock::_Order(CIBlock::_NotEmpty("BE.DETAIL_PICTURE"), $order, "desc", false);
} elseif ($by == "RATING_TOTAL_VALUE") {
$arSqlOrder[$by] = CIBlock::_Order("RV.TOTAL_VALUE", $order, "desc");
$arJoinProps["RV"] = true;
} elseif ($by == "CNT") {
if (is_array($arGroupBy) && count($arGroupBy) > 0) {
$arSqlOrder[$by] = " CNT " . $order . " ";
}
} elseif (substr($by, 0, 9) == "PROPERTY_") {
$propID = strtoupper(substr($by_orig, 9));
if (preg_match("/^([^.]+)\\.([^.]+)\$/", $propID, $arMatch)) {
$db_prop = CIBlockProperty::GetPropertyArray($arMatch[1], CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]));
if (is_array($db_prop) && $db_prop["PROPERTY_TYPE"] == "E") {
CIBlockElement::MkPropertyOrder($arMatch, $order, false, $db_prop, $arJoinProps, $arSqlOrder);
}
} else {
if ($db_prop = CIBlockProperty::GetPropertyArray($propID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
CIBlockElement::MkPropertyOrder($by, $order, false, $db_prop, $arJoinProps, $arSqlOrder);
}
}
} elseif (substr($by, 0, 13) == "PROPERTYSORT_") {
$propID = strtoupper(substr($by_orig, 13));
if (preg_match("/^([^.]+)\\.([^.]+)\$/", $propID, $arMatch)) {
$db_prop = CIBlockProperty::GetPropertyArray($arMatch[1], CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]));
if (is_array($db_prop) && $db_prop["PROPERTY_TYPE"] == "E") {
CIBlockElement::MkPropertyOrder($arMatch, $order, true, $db_prop, $arJoinProps, $arSqlOrder);
}
} else {
if ($db_prop = CIBlockProperty::GetPropertyArray($propID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
CIBlockElement::MkPropertyOrder($by, $order, true, $db_prop, $arJoinProps, $arSqlOrder);
}
}
} else {
$by = "ID";
if (!array_key_exists($by, $arSqlOrder)) {
$arSqlOrder[$by] = CIBLock::_Order("BE.ID", $order, "desc");
}
}
//Check if have to add select field in order to correctly sort
if (is_array($arSqlOrder[$by])) {
if (is_array($arGroupBy) && count($arGroupBy) > 0) {
$arGroupBy[] = $arSqlOrder[$by][1];
} else {
$arSelectFields[] = $arSqlOrder[$by][1];
}
// COLUMN ALIAS COLUMN EXPRESSION
$arIblockElementFields[$arSqlOrder[$by][1]] = $arSqlOrder[$by][0];
// ORDER EXPRESSION
$arSqlOrder[$by] = $arSqlOrder[$by][2];
}
}
//Add order by fields to the select list
//in order to avoid sql errors
if (is_array($arGroupBy) && count($arGroupBy) > 0) {
if ($by == "STATUS") {
$arGroupBy[] = "WF_STATUS_ID";
} elseif ($by == "CREATED") {
$arGroupBy[] = "DATE_CREATE";
} else {
$arGroupBy[] = $by;
}
} else {
if ($by == "STATUS") {
$arSelectFields[] = "WF_STATUS_ID";
} elseif ($by == "CREATED") {
$arSelectFields[] = "DATE_CREATE";
} else {
$arSelectFields[] = $by;
}
}
}
//*************************GROUP BY PART****************************
$sGroupBy = "";
if (is_array($arGroupBy) && count($arGroupBy) > 0) {
$arSelectFields = $arGroupBy;
$bWasGroup = true;
foreach ($arSelectFields as $key => $val) {
$val = strtoupper($val);
if (array_key_exists($val, $arIblockElementFields)) {
$sGroupBy .= "," . preg_replace("/(\\s+AS\\s+[A-Z_]+)/i", "", $arIblockElementFields[$val]);
} elseif (substr($val, 0, 9) == "PROPERTY_") {
$PR_ID = strtoupper(substr($val, 9));
if ($db_prop = CIBlockProperty::GetPropertyArray($PR_ID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
$sGroupBy .= CIBlockElement::MkPropertyGroup($db_prop, $arJoinProps);
}
} elseif (substr($val, 0, 13) == "PROPERTYSORT_") {
$PR_ID = strtoupper(substr($val, 13));
if ($db_prop = CIBlockProperty::GetPropertyArray($PR_ID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
$sGroupBy .= CIBlockElement::MkPropertyGroup($db_prop, $arJoinProps, true);
}
}
}
if ($sGroupBy != "") {
$sGroupBy = " GROUP BY " . substr($sGroupBy, 1) . " ";
}
}
//*************************SELECT PART****************************
$arAddSelectFields = array();
if ($bOnlyCount) {
$sSelect = "COUNT(%%_DISTINCT_%% BE.ID) as CNT ";
} else {
$sSelect = "";
$arDisplayedColumns = array();
$arProductFields = array("CATALOG_PURCHASING_PRICE" => true, "CATALOG_PURCHASING_CURRENCY" => true, "CATALOG_WEIGHT" => true, "CATALOG_QUANTITY" => true, "CATALOG_QUANTITY_RESERVED" => true, "CATALOG_VAT_INCLUDED" => true, "CATALOG_TYPE" => true, "CATALOG_MEASURE" => true, "CATALOG_AVAILABLE" => true);
$bStar = false;
foreach ($arSelectFields as $key => $val) {
$val = strtoupper($val);
if (array_key_exists($val, $arIblockElementFields)) {
if (array_key_exists($val, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$val] = true;
$arSelectFields[$key] = $val;
$sSelect .= "," . $arIblockElementFields[$val] . " as " . $val;
} elseif ($val == "PROPERTY_*" && !$bWasGroup) {
//We have to analyze arFilter IBLOCK_ID and IBLOCK_CODE
//in a way to be shure we will get properties of the ONE IBLOCK ONLY!
$arPropertyFilter = array("ACTIVE" => "Y", "VERSION" => 2);
if (array_key_exists("IBLOCK_ID", $arFilter)) {
if (is_array($arFilter["IBLOCK_ID"]) && count($arFilter["IBLOCK_ID"]) == 1) {
$arPropertyFilter["IBLOCK_ID"] = $arFilter["IBLOCK_ID"][0];
} elseif (!is_array($arFilter["IBLOCK_ID"]) && intval($arFilter["IBLOCK_ID"]) > 0) {
$arPropertyFilter["IBLOCK_ID"] = $arFilter["IBLOCK_ID"];
}
}
if (!array_key_exists("IBLOCK_ID", $arPropertyFilter)) {
if (array_key_exists("IBLOCK_CODE", $arFilter)) {
if (is_array($arFilter["IBLOCK_CODE"]) && count($arFilter["IBLOCK_CODE"]) == 1) {
$arPropertyFilter["IBLOCK_CODE"] = $arFilter["IBLOCK_CODE"][0];
} elseif (!is_array($arFilter["IBLOCK_CODE"]) && strlen($arFilter["IBLOCK_CODE"]) > 0) {
$arPropertyFilter["IBLOCK_CODE"] = $arFilter["IBLOCK_CODE"];
} else {
continue;
}
} else {
continue;
}
}
$rs_prop = CIBlockProperty::GetList(array("sort" => "asc"), $arPropertyFilter);
while ($db_prop = $rs_prop->Fetch()) {
$arIBlockAllProps[] = $db_prop;
}
$iblock_id = false;
foreach ($arIBlockAllProps as $db_prop) {
if ($db_prop["USER_TYPE"] != "") {
$arUserType = CIBlockProperty::GetUserType($db_prop["USER_TYPE"]);
if (array_key_exists("ConvertFromDB", $arUserType)) {
$arIBlockConvProps["PROPERTY_" . $db_prop["ID"]] = array("ConvertFromDB" => $arUserType["ConvertFromDB"], "PROPERTY" => $db_prop);
}
}
$db_prop["ORIG_ID"] = $db_prop["ID"];
if ($db_prop["MULTIPLE"] == "Y") {
$arIBlockMultProps["PROPERTY_" . $db_prop["ID"]] = $db_prop;
}
$iblock_id = $db_prop["IBLOCK_ID"];
}
if ($iblock_id !== false) {
if (!array_key_exists($iblock_id, $arJoinProps["FPS"])) {
$arJoinProps["FPS"][$iblock_id] = count($arJoinProps["FPS"]);
}
$iPropCnt = $arJoinProps["FPS"][$iblock_id];
$sSelect .= ", FPS" . $iPropCnt . ".*";
}
} elseif (substr($val, 0, 9) == "PROPERTY_") {
$PR_ID = strtoupper($val);
if (array_key_exists($PR_ID, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$PR_ID] = true;
$PR_ID = substr($PR_ID, 9);
if (preg_match("/^([^.]+)\\.([^.]+)\$/", $PR_ID, $arMatch)) {
$db_prop = CIBlockProperty::GetPropertyArray($arMatch[1], CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]));
if (is_array($db_prop) && $db_prop["PROPERTY_TYPE"] == "E") {
CIBlockElement::MkPropertySelect($arMatch, $db_prop, $arIBlockLongProps, $arIBlockConvProps, $arJoinProps, $arIBlockMultProps, $arIBlockNumProps, $bWasGroup, $sGroupBy, $sSelect);
}
} else {
if ($db_prop = CIBlockProperty::GetPropertyArray($PR_ID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
CIBlockElement::MkPropertySelect($PR_ID, $db_prop, $arIBlockLongProps, $arIBlockConvProps, $arJoinProps, $arIBlockMultProps, $arIBlockNumProps, $bWasGroup, $sGroupBy, $sSelect);
}
}
} elseif (substr($val, 0, 13) == "PROPERTYSORT_") {
$PR_ID = strtoupper($val);
if (array_key_exists($PR_ID, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$PR_ID] = true;
$PR_ID = substr($PR_ID, 13);
if (preg_match("/^([^.]+)\\.([^.]+)\$/", $PR_ID, $arMatch)) {
$db_prop = CIBlockProperty::GetPropertyArray($arMatch[1], CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]));
if (is_array($db_prop) && $db_prop["PROPERTY_TYPE"] == "E") {
CIBlockElement::MkPropertySelect($arMatch, $db_prop, $arIBlockLongProps, $arIBlockConvProps, $arJoinProps, $arIBlockMultProps, $arIBlockNumProps, $bWasGroup, $sGroupBy, $sSelect, true);
}
} else {
if ($db_prop = CIBlockProperty::GetPropertyArray($PR_ID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
CIBlockElement::MkPropertySelect($PR_ID, $db_prop, $arIBlockLongProps, $arIBlockConvProps, $arJoinProps, $arIBlockMultProps, $arIBlockNumProps, $bWasGroup, $sGroupBy, $sSelect, true);
}
}
} elseif ($val == "*") {
$bStar = true;
} elseif (substr($val, 0, 14) == "CATALOG_GROUP_") {
$arAddSelectFields[] = $val;
} elseif (substr($val, 0, 21) == "CATALOG_STORE_AMOUNT_") {
$arAddSelectFields[] = $val;
} elseif (isset($arProductFields[$val])) {
$arAddSelectFields[] = $val;
} elseif ($val == "RATING_TOTAL_VALUE" || $val == "RATING_TOTAL_VOTES" || $val == "RATING_TOTAL_POSITIVE_VOTES" || $val == "RATING_TOTAL_NEGATIVE_VOTES") {
if (array_key_exists($val, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$val] = true;
$arSelectFields[$key] = $val;
$sSelect .= "," . preg_replace("/^RATING_/", "RV.", $val) . " as " . $val;
$arJoinProps["RV"] = true;
} elseif ($val == "RATING_USER_VOTE_VALUE") {
if (array_key_exists($val, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$val] = true;
$arSelectFields[$key] = $val;
if (isset($USER) && is_object($USER)) {
$sSelect .= "," . $DB->IsNull('RVU.VALUE', '0') . " as " . $val;
$arJoinProps["RVU"] = true;
} else {
$sSelect .= ",0 as " . $val;
}
}
}
if ($bStar) {
foreach ($arIblockElementFields as $key => $val) {
if (array_key_exists($key, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$key] = true;
$arSelectFields[] = $key;
$sSelect .= "," . $val . " as " . $key;
}
} elseif ($sGroupBy == "") {
//Try to add missing fields for correct URL translation (only then no grouping)
if (array_key_exists("DETAIL_PAGE_URL", $arDisplayedColumns)) {
$arAddFields = array("LANG_DIR", "ID", "CODE", "EXTERNAL_ID", "IBLOCK_SECTION_ID", "IBLOCK_TYPE_ID", "IBLOCK_ID", "IBLOCK_CODE", "IBLOCK_EXTERNAL_ID", "LID");
} elseif (array_key_exists("CANONICAL_PAGE_URL", $arDisplayedColumns)) {
$arAddFields = array("LANG_DIR", "ID", "CODE", "EXTERNAL_ID", "IBLOCK_SECTION_ID", "IBLOCK_TYPE_ID", "IBLOCK_ID", "IBLOCK_CODE", "IBLOCK_EXTERNAL_ID", "LID");
} elseif (array_key_exists("SECTION_PAGE_URL", $arDisplayedColumns)) {
$arAddFields = array("LANG_DIR", "ID", "CODE", "EXTERNAL_ID", "IBLOCK_SECTION_ID", "IBLOCK_TYPE_ID", "IBLOCK_ID", "IBLOCK_CODE", "IBLOCK_EXTERNAL_ID", "LID");
} elseif (array_key_exists("LIST_PAGE_URL", $arDisplayedColumns)) {
$arAddFields = array("LANG_DIR", "IBLOCK_TYPE_ID", "IBLOCK_ID", "IBLOCK_CODE", "IBLOCK_EXTERNAL_ID", "LID");
} else {
$arAddFields = array();
}
//Try to add missing fields for correct PREVIEW and DETAIL text formatting
if (array_key_exists("DETAIL_TEXT", $arDisplayedColumns)) {
$arAddFields[] = "DETAIL_TEXT_TYPE";
}
if (array_key_exists("PREVIEW_TEXT", $arDisplayedColumns)) {
$arAddFields[] = "PREVIEW_TEXT_TYPE";
}
foreach ($arAddFields as $key) {
if (array_key_exists($key, $arDisplayedColumns)) {
continue;
}
$arDisplayedColumns[$key] = true;
$arSelectFields[] = $key;
$sSelect .= "," . $arIblockElementFields[$key] . " as " . $key;
}
}
if ($sGroupBy != "") {
$sSelect = substr($sSelect, 1) . ", COUNT(%%_DISTINCT_%% BE.ID) as CNT ";
} elseif (strlen($sSelect) > 0) {
$sSelect = "%%_DISTINCT_%% " . substr($sSelect, 1) . " ";
}
}
//*********************WHERE PART*********************
$arAddWhereFields = array();
if (is_array($arFilter) && array_key_exists("CATALOG", $arFilter)) {
$arAddWhereFields = $arFilter["CATALOG"];
unset($arFilter["CATALOG"]);
}
$arSqlSearch = CIBlockElement::MkFilter($arFilter, $arJoinProps, $arAddWhereFields);
$bDistinct = false;
$sSectionWhere = "";
$sWhere = "";
foreach ($arSqlSearch as $condition) {
if (strlen(trim($condition, "\n\t")) > 0) {
$sWhere .= "\n\t\t\tAND (" . $condition . ")";
}
}
}
protected function UpdateList($arFields, $arFilter = array())
{
global $DB, $USER, $USER_FIELD_MANAGER;
$strUpdate = $DB->PrepareUpdate("b_iblock_section", $arFields, "iblock", false, "BS");
if ($strUpdate == "") {
return false;
}
if (isset($arFilter["IBLOCK_ID"]) && $arFilter["IBLOCK_ID"] > 0) {
$obUserFieldsSql = new CUserTypeSQL();
$obUserFieldsSql->SetEntity("IBLOCK_" . $arFilter["IBLOCK_ID"] . "_SECTION", "BS.ID");
$obUserFieldsSql->SetFilter($arFilter);
} else {
foreach ($arFilter as $key => $val) {
$res = CIBlock::MkOperationFilter($key);
if (preg_match("/^UF_/", $res["FIELD"])) {
trigger_error("arFilter parameter of the CIBlockSection::GetList contains user fields, but has no IBLOCK_ID field.", E_USER_WARNING);
break;
}
}
}
$arJoinProps = array();
$bJoinFlatProp = false;
$arSqlSearch = CIBlockSection::GetFilter($arFilter);
$bCheckPermissions = !array_key_exists("CHECK_PERMISSIONS", $arFilter) || $arFilter["CHECK_PERMISSIONS"] !== "N";
$bIsAdmin = is_object($USER) && $USER->IsAdmin();
if ($bCheckPermissions && !$bIsAdmin) {
$arSqlSearch[] = CIBlockSection::_check_rights_sql($arFilter["MIN_PERMISSION"]);
}
if (array_key_exists("PROPERTY", $arFilter)) {
$val = $arFilter["PROPERTY"];
foreach ($val as $propID => $propVAL) {
$res = CIBlock::MkOperationFilter($propID);
$propID = $res["FIELD"];
$cOperationType = $res["OPERATION"];
if ($db_prop = CIBlockProperty::GetPropertyArray($propID, CIBlock::_MergeIBArrays($arFilter["IBLOCK_ID"], $arFilter["IBLOCK_CODE"]))) {
$bSave = false;
if (array_key_exists($db_prop["ID"], $arJoinProps)) {
$iPropCnt = $arJoinProps[$db_prop["ID"]];
} elseif ($db_prop["VERSION"] != 2 || $db_prop["MULTIPLE"] == "Y") {
$bSave = true;
$iPropCnt = count($arJoinProps);
}
if (!is_array($propVAL)) {
$propVAL = array($propVAL);
}
if ($db_prop["PROPERTY_TYPE"] == "N" || $db_prop["PROPERTY_TYPE"] == "G" || $db_prop["PROPERTY_TYPE"] == "E") {
if ($db_prop["VERSION"] == 2 && $db_prop["MULTIPLE"] == "N") {
$r = CIBlock::FilterCreate("FPS.PROPERTY_" . $db_prop["ORIG_ID"], $propVAL, "number", $cOperationType);
$bJoinFlatProp = $db_prop["IBLOCK_ID"];
} else {
$r = CIBlock::FilterCreate("FPV" . $iPropCnt . ".VALUE_NUM", $propVAL, "number", $cOperationType);
}
} else {
if ($db_prop["VERSION"] == 2 && $db_prop["MULTIPLE"] == "N") {
$r = CIBlock::FilterCreate("FPS.PROPERTY_" . $db_prop["ORIG_ID"], $propVAL, "string", $cOperationType);
$bJoinFlatProp = $db_prop["IBLOCK_ID"];
} else {
$r = CIBlock::FilterCreate("FPV" . $iPropCnt . ".VALUE", $propVAL, "string", $cOperationType);
}
}
if (strlen($r) > 0) {
if ($bSave) {
$db_prop["iPropCnt"] = $iPropCnt;
$arJoinProps[$db_prop["ID"]] = $db_prop;
}
$arSqlSearch[] = $r;
}
}
}
}
$strSqlSearch = "";
foreach ($arSqlSearch as $r) {
if (strlen($r) > 0) {
$strSqlSearch .= "\n\t\t\t\tAND (" . $r . ") ";
}
}
if (isset($obUserFieldsSql)) {
$r = $obUserFieldsSql->GetFilter();
if (strlen($r) > 0) {
$strSqlSearch .= "\n\t\t\t\tAND (" . $r . ") ";
}
}
$strProp1 = "";
foreach ($arJoinProps as $propID => $db_prop) {
if ($db_prop["VERSION"] == 2) {
$strTable = "b_iblock_element_prop_m" . $db_prop["IBLOCK_ID"];
} else {
$strTable = "b_iblock_element_property";
}
$i = $db_prop["iPropCnt"];
$strProp1 .= "\n\t\t\t\tLEFT JOIN b_iblock_property FP" . $i . " ON FP" . $i . ".IBLOCK_ID=B.ID AND\n\t\t\t\t" . (IntVal($propID) > 0 ? " FP" . $i . ".ID=" . IntVal($propID) . " " : " FP" . $i . ".CODE='" . $DB->ForSQL($propID, 200) . "' ") . "\n\t\t\t\tLEFT JOIN " . $strTable . " FPV" . $i . " ON FP" . $i . ".ID=FPV" . $i . ".IBLOCK_PROPERTY_ID AND FPV" . $i . ".IBLOCK_ELEMENT_ID=BE.ID ";
}
if ($bJoinFlatProp) {
$strProp1 .= "\n\t\t\t\tLEFT JOIN b_iblock_element_prop_s" . $bJoinFlatProp . " FPS ON FPS.IBLOCK_ELEMENT_ID = BE.ID\n\t\t\t";
}
$strSql = "\n\t\t\tUPDATE\n\t\t\tb_iblock_section BS\n\t\t\t\tINNER JOIN b_iblock B ON BS.IBLOCK_ID = B.ID\n\t\t\t\t" . (isset($obUserFieldsSql) ? $obUserFieldsSql->GetJoin("BS.ID") : "") . "\n\t\t\t" . (strlen($strProp1) > 0 ? "\tINNER JOIN b_iblock_section BSTEMP ON BSTEMP.IBLOCK_ID = BS.IBLOCK_ID\n\t\t\t\t\tLEFT JOIN b_iblock_section_element BSE ON BSE.IBLOCK_SECTION_ID=BSTEMP.ID\n\t\t\t\t\tLEFT JOIN b_iblock_element BE ON (BSE.IBLOCK_ELEMENT_ID=BE.ID\n\t\t\t\t\t\tAND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL )\n\t\t\t\t\t\tAND BE.IBLOCK_ID = BS.IBLOCK_ID\n\t\t\t\t" . ($arFilter["CNT_ALL"] == "Y" ? " OR BE.WF_NEW='Y' " : "") . ")\n\t\t\t\t" . ($arFilter["CNT_ACTIVE"] == "Y" ? " AND BE.ACTIVE='Y'\n\t\t\t\t\tAND (BE.ACTIVE_TO >= " . $DB->CurrentTimeFunction() . " OR BE.ACTIVE_TO IS NULL)\n\t\t\t\t\tAND (BE.ACTIVE_FROM <= " . $DB->CurrentTimeFunction() . " OR BE.ACTIVE_FROM IS NULL)" : "") . ")\n\t\t\t\t\t" . $strProp1 . " " : "") . "\n\t\t\tSET " . $strUpdate . "\n\t\t\tWHERE 1=1\n\t\t\t" . (strlen($strProp1) > 0 ? "\tAND BSTEMP.LEFT_MARGIN >= BS.LEFT_MARGIN\n\t\t\t\t\tAND BSTEMP.RIGHT_MARGIN <= BS.RIGHT_MARGIN " : "") . "\n\t\t\t" . $strSqlSearch . "\n\t\t";
return $DB->Query($strSql, false, "FILE: " . __FILE__ . "<br> LINE: " . __LINE__);
}
