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/cvetdv.ru/bitrix/modules/catalog/mysql/ |
Upload File : |
<?php use Bitrix\Catalog\Document\StoreDocumentTableManager; use Bitrix\Catalog\Integration\PullManager; use Bitrix\Main\Config\Option; use Bitrix\Main\Localization\Loc; require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/catalog/general/store_docs.php"); class CCatalogDocs extends CAllCatalogDocs { /** * @static * @param $arFields * @return bool|int */ public static function add($arFields) { global $DB; global $USER_FIELD_MANAGER; foreach (GetModuleEvents("catalog", "OnBeforeDocumentAdd", true) as $arEvent) { if (ExecuteModuleEventEx($arEvent, [&$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(); $arFields['WAS_CANCELLED'] = 'N'; if (!self::checkFields('ADD', $arFields)) { return false; } if (!static::checkRequiredFields($arFields, $arFields['DOC_TYPE'])) { return false; } self::increaseDocumentTypeNumber($arFields['DOC_TYPE']); if (empty($arFields['TITLE'])) { $arFields['TITLE'] = self::getCurrentDocumentNameByNumber($arFields['DOC_TYPE']); } $arInsert = $DB->PrepareInsert("b_catalog_store_docs", $arFields); $strSql = "INSERT INTO b_catalog_store_docs (".$arInsert[0].") VALUES(".$arInsert[1].")"; $res = $DB->Query($strSql); if (!$res) { return false; } $lastId = (int)$DB->LastID(); $typeTableClass = StoreDocumentTableManager::getTableClassByType($arFields['DOC_TYPE']); if ($typeTableClass) { $USER_FIELD_MANAGER->Update($typeTableClass::getUfId(), $lastId, $arFields); } $item = [ 'id' => $lastId, 'data' => [ 'fields' => $arFields, ], ]; PullManager::getInstance()->sendDocumentAddedEvent([ $item ]); if (isset($arFields["ELEMENT"]) && is_array($arFields["ELEMENT"])) { self::saveElements($lastId, $arFields['ELEMENT']); } if (isset($arFields["DOCUMENT_FILES"]) && is_array($arFields["DOCUMENT_FILES"])) { static::saveFiles($lastId, $arFields['DOCUMENT_FILES']); } foreach (GetModuleEvents("catalog", "OnDocumentAdd", true) as $arEvent) { ExecuteModuleEventEx($arEvent, [$lastId, $arFields]); } return $lastId; } private static function saveElements($documentID, $elements) { foreach($elements as $arElement) { $lastDocElementId = 0; if(isset($arElement['ID'])) { unset($arElement['ID']); } $arElement['DOC_ID'] = $documentID; if (is_array($arElement)) { $lastDocElementId = CCatalogStoreDocsElement::add($arElement); } if(isset($arElement['BARCODE']) && $lastDocElementId && is_array($arElement['BARCODE'])) { foreach($arElement['BARCODE'] as $barcode) { CCatalogStoreDocsBarcode::add([ 'DOC_ID' => $documentID, 'DOC_ELEMENT_ID' => $lastDocElementId, 'BARCODE' => $barcode, ]); } } } } public static function getList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array()) { global $DB; if (empty($arSelectFields)) $arSelectFields = array("ID", "DOC_TYPE", "SITE_ID", "CONTRACTOR_ID", "CURRENCY", "STATUS", "DATE_DOCUMENT", "TOTAL", "DATE_STATUS", "COMMENTARY"); $arFields = array( "ID" => array("FIELD" => "CD.ID", "TYPE" => "int"), "DOC_TYPE" => array("FIELD" => "CD.DOC_TYPE", "TYPE" => "char"), "SITE_ID" => array("FIELD" => "CD.SITE_ID", "TYPE" => "string"), "CURRENCY" => array("FIELD" => "CD.CURRENCY", "TYPE" => "string"), "CONTRACTOR_ID" => array("FIELD" => "CD.CONTRACTOR_ID", "TYPE" => "int"), "DATE_CREATE" => array("FIELD" => "CD.DATE_CREATE", "TYPE" => "datetime"), "DATE_MODIFY" => array("FIELD" => "CD.DATE_MODIFY", "TYPE" => "datetime"), "DATE_DOCUMENT" => array("FIELD" => "CD.DATE_DOCUMENT", "TYPE" => "datetime"), "DATE_STATUS" => array("FIELD" => "CD.DATE_STATUS", "TYPE" => "datetime"), "CREATED_BY" => array("FIELD" => "CD.CREATED_BY", "TYPE" => "int"), "MODIFIED_BY" => array("FIELD" => "CD.MODIFIED_BY", "TYPE" => "int"), "RESPONSIBLE_ID" => array("FIELD" => "CD.RESPONSIBLE_ID", "TYPE" => "int"), "STATUS_BY" => array("FIELD" => "CD.STATUS_BY", "TYPE" => "int"), "STATUS" => array("FIELD" => "CD.STATUS", "TYPE" => "char"), "TOTAL" => array("FIELD" => "CD.TOTAL", "TYPE" => "double"), "COMMENTARY" => array("FIELD" => "CD.COMMENTARY", "TYPE" => "string"), 'TITLE' => ['FIELD' => 'CD.TITLE', 'TYPE' => 'string'], 'ITEMS_ORDER_DATE' => ['FIELD' => 'CD.ITEMS_ORDER_DATE', 'TYPE' => 'datetime'], 'ITEMS_RECEIVED_DATE' => ['FIELD' => 'CD.ITEMS_RECEIVED_DATE', 'TYPE' => 'datetime'], 'DOC_NUMBER' => ['FIELD' => 'CD.DOC_NUMBER', 'TYPE' => 'string'], 'WAS_CANCELLED' => ['FIELD' => 'CD.WAS_CANCELLED', 'TYPE' => 'char'], "PRODUCTS_ID" => array("FIELD" => "DE.ID", "TYPE" => "int", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), "PRODUCTS_DOC_ID" => array("FIELD" => "DE.DOC_ID", "TYPE" => "int", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), "PRODUCTS_STORE_FROM" => array("FIELD" => "DE.STORE_FROM", "TYPE" => "int", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), "PRODUCTS_STORE_TO" => array("FIELD" => "DE.STORE_TO", "TYPE" => "int", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), "PRODUCTS_ELEMENT_ID" => array("FIELD" => "DE.ELEMENT_ID", "TYPE" => "int", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), "PRODUCTS_AMOUNT" => array("FIELD" => "DE.AMOUNT", "TYPE" => "double", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), "PRODUCTS_PURCHASING_PRICE" => array("FIELD" => "DE.PURCHASING_PRICE", "TYPE" => "double", "FROM" => "INNER JOIN b_catalog_docs_element DE ON (CD.ID = DE.DOC_ID)"), ); $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"]." FROM b_catalog_store_docs CD ".$arSqls["FROM"]; if (!empty($arSqls["WHERE"])) $strSql .= " WHERE ".$arSqls["WHERE"]; if (!empty($arSqls["GROUPBY"])) $strSql .= " GROUP BY ".$arSqls["GROUPBY"]; $dbRes = $DB->Query($strSql); if ($arRes = $dbRes->Fetch()) return $arRes["CNT"]; else return false; } $strSql = "SELECT ".$arSqls["SELECT"]." FROM b_catalog_store_docs CD ".$arSqls["FROM"]; if (!empty($arSqls["WHERE"])) $strSql .= " WHERE ".$arSqls["WHERE"]; if (!empty($arSqls["GROUPBY"])) $strSql .= " GROUP BY ".$arSqls["GROUPBY"]; if (!empty($arSqls["ORDERBY"])) $strSql .= " ORDER BY ".$arSqls["ORDERBY"]; $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_docs CD ".$arSqls["FROM"]; if (!empty($arSqls["WHERE"])) $strSql_tmp .= " WHERE ".$arSqls["WHERE"]; if (!empty($arSqls["GROUPBY"])) $strSql_tmp .= " GROUP BY ".$arSqls["GROUPBY"]; $dbRes = $DB->Query($strSql_tmp); $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); } return $dbRes; } private static function increaseDocumentTypeNumber(string $type): void { $name = self::getDocumentTypeNumberName($type); $value = (int)Option::get('catalog', $name) + 1; Option::set('catalog', $name, $value); } public static function getCurrentDocumentNameByNumber(string $type): string { $value = Option::get( 'catalog', self::getDocumentTypeNumberName($type) ); return Loc::getMessage( 'CATALOG_STORE_DOCUMENT_TITLE_DEFAULT_NAME_' . $type, [ '%DOCUMENT_NUMBER%' => $value, ] ); } public static function getNextDocumentNameByNumber(string $type): string { $value = (int)Option::get( 'catalog', self::getDocumentTypeNumberName($type) ) + 1; return Loc::getMessage( 'CATALOG_STORE_DOCUMENT_TITLE_DEFAULT_NAME_' . $type, [ '%DOCUMENT_NUMBER%' => $value, ] ); } private static function getDocumentTypeNumberName(string $type): string { return 'store_document_numbers_' . $type; } }