%PDF- %PDF-
Server IP : 37.220.80.31 / Your IP : 3.148.107.193 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/mysql/ |
Upload File : |
<?php use Bitrix\Catalog; require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/catalog/general/store.php"); class CCatalogStore extends CAllCatalogStore { /** Add new store in table b_catalog_store, * @static * @param $arFields * @return bool|int */ public static function Add($arFields) { /** @global CDataBase $DB */ global $DB; foreach (GetModuleEvents("catalog", "OnBeforeCatalogStoreAdd", true) as $arEvent) { if(ExecuteModuleEventEx($arEvent, array(&$arFields)) === false) return false; } if(array_key_exists('DATE_CREATE', $arFields)) unset($arFields['DATE_CREATE']); if(array_key_exists('DATE_MODIFY', $arFields)) unset($arFields['DATE_MODIFY']); $arFields['~DATE_MODIFY'] = $DB->GetNowFunction(); $arFields['~DATE_CREATE'] = $DB->GetNowFunction(); if(!self::CheckFields('ADD',$arFields)) return false; $arInsert = $DB->PrepareInsert("b_catalog_store", $arFields); $strSql = "INSERT INTO b_catalog_store (".$arInsert[0].") VALUES(".$arInsert[1].")"; $res = $DB->Query($strSql, False, "File: ".__FILE__."<br>Line: ".__LINE__); if(!$res) return false; $lastId = intval($DB->LastID()); Catalog\StoreTable::getEntity()->cleanCache(); foreach(GetModuleEvents("catalog", "OnCatalogStoreAdd", true) as $arEvent) ExecuteModuleEventEx($arEvent, array($lastId, $arFields)); return $lastId; } public static function GetList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array()) { global $DB; if (empty($arSelectFields)) $arSelectFields = array( "ID", "ACTIVE", "TITLE", "PHONE", "SCHEDULE", "ADDRESS", "DESCRIPTION", "GPS_N", "GPS_S", "IMAGE_ID", "DATE_CREATE", "DATE_MODIFY", "USER_ID", "XML_ID", "SORT", "EMAIL", "ISSUING_CENTER", "SHIPPING_CENTER", "SITE_ID", "CODE" ); $keyForDelete = array_search("PRODUCT_AMOUNT", $arSelectFields); if (!isset($arFilter["PRODUCT_ID"]) && $keyForDelete !== false) unset($arSelectFields[$keyForDelete]); if ($keyForDelete == false) { $keyForDelete = array_search("ELEMENT_ID", $arSelectFields); if($keyForDelete !== false) unset($arSelectFields[$keyForDelete]); } $productID = '('; if (is_array($arFilter["PRODUCT_ID"])) { foreach($arFilter["PRODUCT_ID"] as $id) $productID .= intval($id).','; $productID = rtrim($productID, ',').')'; } else { $productID .= intval($arFilter["PRODUCT_ID"]) . ')'; } $arFields = array( "ID" => array("FIELD" => "CS.ID", "TYPE" => "int"), "ACTIVE" => array("FIELD" => "CS.ACTIVE", "TYPE" => "string"), "TITLE" => array("FIELD" => "CS.TITLE", "TYPE" => "string"), "PHONE" => array("FIELD" => "CS.PHONE", "TYPE" => "string"), "SCHEDULE" => array("FIELD" => "CS.SCHEDULE", "TYPE" => "string"), "ADDRESS" => array("FIELD" => "CS.ADDRESS", "TYPE" => "string"), "DESCRIPTION" => array("FIELD" => "CS.DESCRIPTION", "TYPE" => "string"), "GPS_N" => array("FIELD" => "CS.GPS_N", "TYPE" => "string"), "GPS_S" => array("FIELD" => "CS.GPS_S", "TYPE" => "string"), "IMAGE_ID" => array("FIELD" => "CS.IMAGE_ID", "TYPE" => "int"), "LOCATION_ID" => array("FIELD" => "CS.LOCATION_ID", "TYPE" => "int"), "DATE_CREATE" => array("FIELD" => "CS.DATE_CREATE", "TYPE" => "datetime"), "DATE_MODIFY" => array("FIELD" => "CS.DATE_MODIFY", "TYPE" => "datetime"), "USER_ID" => array("FIELD" => "CS.USER_ID", "TYPE" => "int"), "MODIFIED_BY" => array("FIELD" => "CS.MODIFIED_BY", "TYPE" => "int"), "XML_ID" => array("FIELD" => "CS.XML_ID", "TYPE" => "string"), "SORT" => array("FIELD" => "CS.SORT", "TYPE" => "int"), "EMAIL" => array("FIELD" => "CS.EMAIL", "TYPE" => "string"), "ISSUING_CENTER" => array("FIELD" => "CS.ISSUING_CENTER", "TYPE" => "char"), "SHIPPING_CENTER" => array("FIELD" => "CS.SHIPPING_CENTER", "TYPE" => "char"), "SITE_ID" => array("FIELD" => "CS.SITE_ID", "TYPE" => "string"), "CODE" => array("FIELD" => "CS.CODE", "TYPE" => "string"), "PRODUCT_AMOUNT" => array("FIELD" => "CP.AMOUNT", "TYPE" => "double", "FROM" => "LEFT JOIN b_catalog_store_product CP ON (CS.ID = CP.STORE_ID AND CP.PRODUCT_ID IN ".$productID.")"), "ELEMENT_ID" => array("FIELD" => "CP.PRODUCT_ID", "TYPE" => "int") ); if (!is_array($arOrder)) { $arOrder = []; } if (!empty($arOrder)) { $arOrder = array_change_key_case($arOrder, CASE_UPPER); foreach (array_keys($arOrder) as $field) { $arOrder[$field] = strtoupper($arOrder[$field]); if ($arOrder[$field] !== 'DESC') { $arOrder[$field] = 'ASC'; } } } $userField = new CUserTypeSQL(); $userField->SetEntity("CAT_STORE", "CS.ID"); $userField->SetSelect($arSelectFields); $userField->SetFilter($arFilter); $userField->SetOrder($arOrder); $strUfFilter = $userField->GetFilter(); $strSqlUfFilter = ($strUfFilter <> '') ? " (".$strUfFilter.") " : ""; $strSqlUfOrder = ""; foreach ($arOrder as $field => $by) { $field = $userField->GetOrder($field); if (empty($field)) continue; if ($strSqlUfOrder <> '') $strSqlUfOrder .= ', '; $strSqlUfOrder .= $field." ".$by; } $arSqls = CCatalog::PrepareSql($arFields, $arOrder, $arFilter, $arGroupBy, $arSelectFields); $arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]); if (empty($arGroupBy) && is_array($arGroupBy)) { $strSql = "SELECT ".$arSqls["SELECT"]." ".$userField->GetSelect()." FROM b_catalog_store CS ".$arSqls["FROM"]. " ".$userField->GetJoin("CS.ID"); if (!empty($arSqls["WHERE"])) $strSql .= " WHERE ".$arSqls["WHERE"]." "; if ($arSqls["WHERE"] <> '' && $strSqlUfFilter <> '') $strSql .= " AND ".$strSqlUfFilter." "; elseif ($arSqls["WHERE"] == '' && $strSqlUfFilter <> '') $strSql .= " WHERE ".$strSqlUfFilter." "; if (!empty($arSqls["GROUPBY"])) $strSql .= " GROUP BY ".$arSqls["GROUPBY"]; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) return $arRes["CNT"]; else return false; } $strSql = "SELECT ".$arSqls["SELECT"]." ".$userField->GetSelect()." FROM b_catalog_store CS ".$arSqls["FROM"]." ".$userField->GetJoin("CS.ID"); if (!empty($arSqls["WHERE"])) $strSql .= " WHERE ".$arSqls["WHERE"]." "; if ($arSqls["WHERE"] <> '' && $strSqlUfFilter <> '') $strSql .= " AND ".$strSqlUfFilter." "; elseif ($arSqls["WHERE"] == '' && $strSqlUfFilter <> '') $strSql .= " WHERE ".$strSqlUfFilter." "; if (!empty($arSqls["GROUPBY"])) $strSql .= " GROUP BY ".$arSqls["GROUPBY"]; if (!empty($arSqls["ORDERBY"])) $strSql .= " ORDER BY ".$arSqls["ORDERBY"]; elseif ($arSqls["ORDERBY"] == '' && $strSqlUfOrder <> '') $strSql .= " ORDER BY ".$strSqlUfOrder; $intTopCount = 0; $boolNavStartParams = (!empty($arNavStartParams) && is_array($arNavStartParams)); if ($boolNavStartParams && array_key_exists('nTopCount', $arNavStartParams)) $intTopCount = intval($arNavStartParams["nTopCount"]); if ($boolNavStartParams && 0 >= $intTopCount) { $strSql_tmp = "SELECT COUNT('x') as CNT FROM b_catalog_store CS ".$arSqls["FROM"]. " ".$userField->GetJoin("CS.ID"); if (!empty($arSqls["WHERE"])) $strSql_tmp .= " WHERE ".$arSqls["WHERE"]; if ($arSqls["WHERE"] <> '' && $strSqlUfFilter <> '') $strSql_tmp .= " AND ".$strSqlUfFilter." "; elseif ($arSqls["WHERE"] == '' && $strSqlUfFilter <> '') $strSql_tmp .= " WHERE ".$strSqlUfFilter." "; if (!empty($arSqls["GROUPBY"])) $strSql_tmp .= " GROUP BY ".$arSqls["GROUPBY"]; $dbRes = $DB->Query($strSql_tmp, false, "File: ".__FILE__."<br>Line: ".__LINE__); $cnt = 0; if (empty($arSqls["GROUPBY"])) if ($arRes = $dbRes->Fetch()) $cnt = $arRes["CNT"]; else $cnt = $dbRes->SelectedRowsCount(); $dbRes = new CDBResult(); $dbRes->NavQuery($strSql, $cnt, $arNavStartParams); } else { if($boolNavStartParams && 0 < $intTopCount) $strSql .= " LIMIT ".$intTopCount; $dbRes = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__); } return $dbRes; } }