Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/form/classes/mysql/ |
Upload File : |
<?php class CForm extends CAllForm { public static function GetList($by = 's_sort', $order = 'asc', $arFilter = [], $is_filtered = null, $min_permission = 10) { global $DB, $USER, $strError; $min_permission = intval($min_permission); $arSqlSearch = Array(); $left_join = ''; if (is_array($arFilter)) { if (!empty($arFilter["SID"])) $arFilter["VARNAME"] = $arFilter["SID"]; elseif (!empty($arFilter["VARNAME"])) $arFilter["SID"] = $arFilter["VARNAME"]; $filter_keys = array_keys($arFilter); $keyCount = count($filter_keys); for ($i=0; $i<$keyCount; $i++) { $key = $filter_keys[$i]; $val = $arFilter[$filter_keys[$i]]; if(is_array($val)) { if(empty($val)) continue; } else { if((string)$val == '' || $val === "NOT_REF") continue; } $match_value_set = (in_array($key."_EXACT_MATCH", $filter_keys)); $key = strtoupper($key); switch($key) { case "ID": case "SID": $match = (isset($arFilter[$key."_EXACT_MATCH"]) && $arFilter[$key."_EXACT_MATCH"]=="N" && $match_value_set) ? "Y" : "N"; $arSqlSearch[] = GetFilterQuery("F.".$key, $val, $match); break; case "NAME": case "DESCRIPTION": $match = (isset($arFilter[$key."_EXACT_MATCH"]) && $arFilter[$key."_EXACT_MATCH"]=="Y" && $match_value_set) ? "N" : "Y"; $arSqlSearch[] = GetFilterQuery("F.".$key, $val, $match); break; case "SITE": if (is_array($val)) $val = implode(" | ", $val); $match = (isset($arFilter[$key."_EXACT_MATCH"]) && $arFilter[$key."_EXACT_MATCH"]=="N" && $match_value_set) ? "Y" : "N"; $arSqlSearch[] = GetFilterQuery("FS.SITE_ID", $val, $match); $left_join = "LEFT JOIN b_form_2_site FS ON (F.ID = FS.FORM_ID)"; break; } } } if ($by == "s_id") $strSqlOrder = "ORDER BY F.ID"; elseif ($by == "s_c_sort" || $by == "s_sort") $strSqlOrder = "ORDER BY F.C_SORT"; elseif ($by == "s_name") $strSqlOrder = "ORDER BY F.NAME"; elseif ($by == "s_varname" || $by == "s_sid") $strSqlOrder = "ORDER BY F.SID"; else { $strSqlOrder = "ORDER BY F.C_SORT"; } if ($order!="desc") { $strSqlOrder .= " asc "; } else { $strSqlOrder .= " desc "; } $strSqlSearch = GetFilterSqlSearch($arSqlSearch); if (CForm::IsAdmin()) { $strSql = " SELECT F.*, F.SID VARNAME, F.FIRST_SITE_ID, F.FIRST_SITE_ID LID, ".$DB->DateToCharFunction("F.TIMESTAMP_X")." TIMESTAMP_X, count(distinct D1.ID) C_FIELDS, count(distinct D2.ID) QUESTIONS, count(distinct S.ID) STATUSES FROM b_form F LEFT JOIN b_form_status S ON (S.FORM_ID = F.ID) LEFT JOIN b_form_field D1 ON (D1.FORM_ID = F.ID and D1.ADDITIONAL='Y') LEFT JOIN b_form_field D2 ON (D2.FORM_ID = F.ID and D2.ADDITIONAL<>'Y') $left_join WHERE $strSqlSearch GROUP BY F.ID $strSqlOrder "; } else { $arGroups = $USER->GetUserGroupArray(); if (!is_array($arGroups)) $arGroups[] = 2; $groups = implode(",",$arGroups); $def_permission = COption::GetOptionInt("form", "FORM_DEFAULT_PERMISSION", 10); $strSql = " SELECT F.*, F.SID VARNAME, F.FIRST_SITE_ID, F.FIRST_SITE_ID LID, ".$DB->DateToCharFunction("F.TIMESTAMP_X")." TIMESTAMP_X, count(distinct D1.ID) C_FIELDS, count(distinct D2.ID) QUESTIONS, count(distinct S.ID) STATUSES FROM b_form F ". ($def_permission >=$min_permission? " LEFT JOIN b_form_2_group G ON (G.FORM_ID=F.ID and G.GROUP_ID in ($groups)) " : " INNER JOIN b_form_2_group G ON (G.FORM_ID=F.ID and G.PERMISSION>=$min_permission and G.GROUP_ID in ($groups)) " )." LEFT JOIN b_form_status S ON (S.FORM_ID = F.ID) LEFT JOIN b_form_field D1 ON (D1.FORM_ID = F.ID and D1.ADDITIONAL='Y') LEFT JOIN b_form_field D2 ON (D2.FORM_ID = F.ID and D2.ADDITIONAL<>'Y') $left_join WHERE $strSqlSearch ". ($def_permission >=$min_permission? " AND (G.FORM_ID IS NULL OR G.PERMISSION>=$min_permission) " : "" ). " GROUP BY F.ID $strSqlOrder "; } $res = $DB->Query($strSql); return $res; } public static function GetByID($ID, $GET_BY_SID="N") { global $DB, $strError; $where = ($GET_BY_SID=="N") ? " F.ID = '".intval($ID)."' " : " F.SID='".$DB->ForSql($ID,50)."' "; $strSql = " SELECT F.*, F.FIRST_SITE_ID, F.FIRST_SITE_ID LID, F.SID, F.SID VARNAME, ".$DB->DateToCharFunction("F.TIMESTAMP_X")." TIMESTAMP_X, count(distinct D1.ID) C_FIELDS, count(distinct D2.ID) QUESTIONS, count(distinct S.ID) STATUSES FROM b_form F LEFT JOIN b_form_status S ON (S.FORM_ID = F.ID) LEFT JOIN b_form_field D1 ON (D1.FORM_ID = F.ID and D1.ADDITIONAL='Y') LEFT JOIN b_form_field D2 ON (D2.FORM_ID = F.ID and D2.ADDITIONAL<>'Y') WHERE $where GROUP BY F.ID "; $res = $DB->Query($strSql); return $res; } public static function GetFormTemplateByID($ID, $GET_BY_SID="N") { global $DB, $strError; $where = ($GET_BY_SID=="N") ? " F.ID = '".intval($ID)."' " : " F.SID='".$DB->ForSql($ID,50)."' "; $strSql = " SELECT F.FORM_TEMPLATE FT FROM b_form F WHERE $where "; $res = $DB->Query($strSql); if ($arRes = $res->Fetch()) return $arRes["FT"]; else return ""; } }