File manager

File manager - Edit - /home/c14075/dragmet-ural.ru/www/webizi.csv.tar

Back
lang/en/install/index.php��0000644��00000000264�15125205703�0011357 0��ustar�00��<? $MESS['WI_MODULE_NAME'] = "Import/Export CSV"; $MESS['WI_MODULE_DESCRIPTION'] = "Import/Export CSV with support for multiple properties"; $MESS["WI_PARTNER_NAME"] = "WEBIZI"; ?>��lang/en/admin/menu.php��0000644��00000000177�15125205703�0010641 0��ustar�00��<? $MESS ['WI_CSV'] = "WI Working with CSV"; $MESS["MCART_EXCEL_IMPORT"] = "Import"; $MESS["MCART_EXCEL_EXPORT"] = "Export"; ?>��lang/en/admin/data_import.php��0000644��00000001242�15125205703�0012172 0��ustar�00��<? $MESS["WI_MULTI_SEPARATOR"] = "Separator for properties with multiple choice"; $MESS["WI_SEPARATOR"] = "Delimiter"; $MESS["WI_EXAMPLE"] = 'For example, "\|", for the field with the value "red \| blue \| black"'; $MESS["WI_USE_TRANSLITERATION"] = 'Use the information block settings for transliteration character codes'; $MESS["WI_LANGUAGE_TRANSLITERATION"] = 'Language Transliteration'; $MESS ['CATI_NO_IBLOCK'] = "Information block not selected. Unable to import."; $MESS["CATI_USE_CODE_TRANSLIT_OUT"] = "Cannot perform transliteration because an external service is selected."; $MESS["CATI_CODE_TRANSLIT_LANG_ERR"] = "No transliteration language specified."; ?>��lang/en/admin/data_export.php��0000644��00000005247�15125205703�0012212 0��ustar�00��<? $MESS ['IBLOCK_ADM_EXP_NO_IBLOCK'] = "No information block has been selected. Cannot export."; $MESS ['IBLOCK_ADM_EXP_NO_FORMAT'] = "Please set the data file format and properties."; $MESS ['IBLOCK_ADM_EXP_NO_DELIMITER'] = "Please set the field delimiter."; $MESS ['IBLOCK_ADM_EXP_NO_FILE_NAME'] = "Please select the output file."; $MESS ['IBLOCK_ADM_EXP_FILE_NAME_ERROR'] = "Please select the output file."; $MESS ['IBLOCK_ADM_EXP_CANNOT_CREATE_FILE'] = "Error creating output file."; $MESS ['IBLOCK_ADM_EXP_NO_FIELDS'] = "No export fields have been selected."; $MESS ['IBLOCK_ADM_EXP_PAGE_TITLE'] = "Information block export: step"; $MESS ['IBLOCK_ADM_EXP_TAB1'] = "Info. block"; $MESS ['IBLOCK_ADM_EXP_TAB1_ALT'] = "Select information block for export"; $MESS ['IBLOCK_ADM_EXP_TAB2'] = "Export settings"; $MESS ['IBLOCK_ADM_EXP_TAB2_ALT'] = "Edit export parameters"; $MESS ['IBLOCK_ADM_EXP_TAB3'] = "Result"; $MESS ['IBLOCK_ADM_EXP_TAB3_ALT'] = "Export result"; $MESS ['IBLOCK_ADM_EXP_CHOOSE_IBLOCK'] = "Export information block:"; $MESS ['IBLOCK_ADM_EXP_CHOOSE_FORMAT'] = "Please set the file format settings"; $MESS ['IBLOCK_ADM_EXP_DELIMITER'] = "Delimiter"; $MESS ['IBLOCK_ADM_EXP_DELIM_TZP'] = "semicolon"; $MESS ['IBLOCK_ADM_EXP_DELIM_ZPT'] = "comma"; $MESS ['IBLOCK_ADM_EXP_DELIM_TAB'] = "tab"; $MESS ['IBLOCK_ADM_EXP_DELIM_SPS'] = "space"; $MESS ['IBLOCK_ADM_EXP_DELIM_OTR'] = "other"; $MESS ['IBLOCK_ADM_EXP_FIRST_LINE_NAMES'] = "First row is a header (contains field names)"; $MESS ['IBLOCK_ADM_EXP_FIELDS_MAPPING'] = "Please assign file fields to database fields"; $MESS ['IBLOCK_ADM_EXP_IS_FIELD_NEEDED'] = "Export"; $MESS ['IBLOCK_ADM_EXP_FIELD_NAME'] = "Field name"; $MESS ['IBLOCK_ADM_EXP_FIELD_SORT'] = "Sort order"; $MESS ['IBLOCK_ADM_EXP_PROPERTY'] = "Property "#PROPERTY_NAME#""; $MESS ['IBLOCK_ADM_EXP_GROUP_LEVEL'] = "Group of level (#LEVEL_NUM#)"; $MESS ['IBLOCK_ADM_EXP_FILE_NAME'] = "Save data file as..."; $MESS ['IBLOCK_ADM_EXP_ENTER_FILE_NAME'] = "Data file name relative to site root"; $MESS ['IBLOCK_ADM_EXP_FILE_WARNING'] = "If this file exists already, it will be overwritten"; $MESS ['IBLOCK_ADM_EXP_SUCCESS'] = "Export completed"; $MESS ['IBLOCK_ADM_EXP_LINES_EXPORTED'] = "Total exported lines: #LINES#"; $MESS ['IBLOCK_ADM_EXP_DOWNLOAD_RESULT'] = "Download file #HREF#"; $MESS ['IBLOCK_ADM_EXP_BACK_BUTTON'] = "Back"; $MESS ['IBLOCK_ADM_EXP_FINISH_BUTTON'] = "Start"; $MESS ['IBLOCK_ADM_EXP_NEXT_BUTTON'] = "Next"; $MESS ['IBLOCK_ADM_EXP_RESTART_BUTTON'] = "Back to first step"; $MESS["WI_MULTI_SEPARATOR"] = "Separator for properties with multiple choice"; $MESS["WI_SEPARATOR"] = "Delimiter"; $MESS["WI_EXAMPLE"] = 'For example, "\|", leads to mind "red \| blue \| black"'; ?>��lang/ru/install/index.php��0000644��00000000360�15125205703�0011400 0��ustar�00��<? $MESS ['WI_MODULE_NAME'] = "Импорт/экспорт CSV"; $MESS ['WI_MODULE_DESCRIPTION'] = "Импорт/экспорт CSV с поддержкой множественных свойств"; $MESS ["WI_PARTNER_NAME"] = "WEBIZI"; ?>��lang/ru/admin/menu.php��0000644��00000000220�15125205703�0010652 0��ustar�00��<? $MESS ['WI_CSV'] = "WI работа с CSV"; $MESS["MCART_EXCEL_IMPORT"] = "Импорт"; $MESS["MCART_EXCEL_EXPORT"] = "Экспорт"; ?>��lang/ru/admin/data_import.php��0000644��00000001650�15125205703�0012221 0��ustar�00��<? $MESS["WI_MULTI_SEPARATOR"] = "Разделитель для свойств с множественным выбором"; $MESS["WI_SEPARATOR"] = "Разделитель"; $MESS["WI_EXAMPLE"] = 'Например "\|", для поля со значением: "красный\|синий\|черный"'; $MESS["WI_USE_TRANSLITERATION"] = 'Использовать настройки инфоблока для транслитерации символьных кодов'; $MESS["WI_LANGUAGE_TRANSLITERATION"] = 'Язык для транслитерации'; $MESS ['CATI_NO_IBLOCK'] = "Информационный блок не выбран. Загрузка невозможна."; $MESS["CATI_USE_CODE_TRANSLIT_OUT"] = "Транслитерация невозможна - выбран внешний сервис"; $MESS["CATI_CODE_TRANSLIT_LANG_ERR"] = "Не задан язык для транслитерации"; ?>��lang/ru/admin/data_export.php��0000644��00000007230�15125205703�0012230 0��ustar�00��<? $MESS ['IBLOCK_ADM_EXP_NO_IBLOCK'] = "Информационный блок не выбран. Выгрузка невозможна."; $MESS ['IBLOCK_ADM_EXP_NO_FORMAT'] = "Укажите формат файла данных и его свойства."; $MESS ['IBLOCK_ADM_EXP_NO_DELIMITER'] = "Укажите символ-разделитель полей."; $MESS ['IBLOCK_ADM_EXP_NO_FILE_NAME'] = "Укажите файл для сохранения результата."; $MESS ['IBLOCK_ADM_EXP_FILE_NAME_ERROR'] = "Укажите файл для сохранения результата."; $MESS ['IBLOCK_ADM_EXP_CANNOT_CREATE_FILE'] = "Ошибка создания файла данных."; $MESS ['IBLOCK_ADM_EXP_NO_FIELDS'] = "Не заданы поля для экспорта."; $MESS ['IBLOCK_ADM_EXP_PAGE_TITLE'] = "Выгрузка информационного блока: шаг"; $MESS ['IBLOCK_ADM_EXP_TAB1'] = "Инфоблок"; $MESS ['IBLOCK_ADM_EXP_TAB1_ALT'] = "Выбор информационного блока для экспорта"; $MESS ['IBLOCK_ADM_EXP_TAB2'] = "Параметры экспорта"; $MESS ['IBLOCK_ADM_EXP_TAB2_ALT'] = "Настройка параметров экспорта"; $MESS ['IBLOCK_ADM_EXP_TAB3'] = "Результат"; $MESS ['IBLOCK_ADM_EXP_TAB3_ALT'] = "Результат экспорта"; $MESS ['IBLOCK_ADM_EXP_CHOOSE_IBLOCK'] = "Информационный блок для экспорта:"; $MESS ['IBLOCK_ADM_EXP_CHOOSE_FORMAT'] = "Задайте свойства формата файла"; $MESS ['IBLOCK_ADM_EXP_DELIMITER'] = "Разделитель полей"; $MESS ['IBLOCK_ADM_EXP_DELIM_TZP'] = "точка с запятой"; $MESS ['IBLOCK_ADM_EXP_DELIM_ZPT'] = "запятая"; $MESS ['IBLOCK_ADM_EXP_DELIM_TAB'] = "табуляция"; $MESS ['IBLOCK_ADM_EXP_DELIM_SPS'] = "пробел"; $MESS ['IBLOCK_ADM_EXP_DELIM_OTR'] = "другой"; $MESS ['IBLOCK_ADM_EXP_FIRST_LINE_NAMES'] = "Первая строка содержит имена полей"; $MESS ['IBLOCK_ADM_EXP_FIELDS_MAPPING'] = "Задайте соответствие полей в файле полям в базе"; $MESS ['IBLOCK_ADM_EXP_IS_FIELD_NEEDED'] = "Выгружать"; $MESS ['IBLOCK_ADM_EXP_FIELD_NAME'] = "Название поля"; $MESS ['IBLOCK_ADM_EXP_FIELD_SORT'] = "Порядок"; $MESS ['IBLOCK_ADM_EXP_PROPERTY'] = "Свойство "#PROPERTY_NAME#""; $MESS ['IBLOCK_ADM_EXP_GROUP_LEVEL'] = "Группа уровня (#LEVEL_NUM#)"; $MESS ['IBLOCK_ADM_EXP_FILE_NAME'] = "Сохранить файл данных как..."; $MESS ['IBLOCK_ADM_EXP_ENTER_FILE_NAME'] = "Имя файла данных относительно корня сайта"; $MESS ['IBLOCK_ADM_EXP_FILE_WARNING'] = "Если такой файл существует, то он будет перезаписан"; $MESS ['IBLOCK_ADM_EXP_SUCCESS'] = "Выгрузка завершена"; $MESS ['IBLOCK_ADM_EXP_LINES_EXPORTED'] = "Всего выгружено строк: #LINES#"; $MESS ['IBLOCK_ADM_EXP_DOWNLOAD_RESULT'] = "Скачать файл #HREF# на свой компьютер"; $MESS ['IBLOCK_ADM_EXP_BACK_BUTTON'] = "Назад"; $MESS ['IBLOCK_ADM_EXP_FINISH_BUTTON'] = "Начать выгрузку"; $MESS ['IBLOCK_ADM_EXP_NEXT_BUTTON'] = "Далее"; $MESS ['IBLOCK_ADM_EXP_RESTART_BUTTON'] = "Вернуться на первый шаг"; $MESS["WI_MULTI_SEPARATOR"] = "Разделитель для свойств с множественным выбором"; $MESS["WI_SEPARATOR"] = "Разделитель"; $MESS["WI_EXAMPLE"] = 'Например "\|", приведет к виду: "красный\|синий\|черный"'; ?>��install/version.php��0000644��00000000131�15125205703�0010403 0��ustar�00��<? $arModuleVersion = array( "VERSION" => "1.1.1", "VERSION_DATE" => "2016-10-19" ); ?>��install/admin/wi_csv_import.php��0000644��00000000132�15125205703�0012673 0��ustar�00��<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/webizi.csv/admin/data_import.php");?>��install/admin/wi_csv_export.php��0000644��00000000132�15125205703�0012702 0��ustar�00��<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/webizi.csv/admin/data_export.php");?>��install/index.php��0000644��00000004020�15125205703�0010026 0��ustar�00��<? IncludeModuleLangFile( __FILE__); if(class_exists("webizi_csv")) return; Class webizi_csv extends CModule { var $MODULE_ID = "webizi.csv"; var $MODULE_VERSION; var $MODULE_VERSION_DATE; var $MODULE_NAME; var $MODULE_DESCRIPTION; var $MODULE_GROUP_RIGHTS = "Y"; function webizi_csv() { $arModuleVersion = array(); $path = str_replace("\\", "/", __FILE__); $path = substr($path, 0, strlen($path) - strlen("/index.php")); include($path."/version.php"); if (is_array($arModuleVersion) && array_key_exists("VERSION", $arModuleVersion)){ $this->MODULE_VERSION = $arModuleVersion["VERSION"]; $this->MODULE_VERSION_DATE = $arModuleVersion["VERSION_DATE"]; }else{ $this->MODULE_VERSION=TASKFROMEMAIL_MODULE_VERSION; $this->MODULE_VERSION_DATE=TASKFROMEMAIL_MODULE_VERSION_DATE; } $this->MODULE_NAME = GetMessage("WI_MODULE_NAME"); $this->MODULE_DESCRIPTION = GetMessage("WI_MODULE_DESCRIPTION"); $this->PARTNER_NAME = GetMessage("WI_PARTNER_NAME"); $this->PARTNER_URI = "http://webizi.ru/"; } function DoInstall() { if (!IsModuleInstalled("webizi.csv")) { $this->InstallFiles(); } return true; } function DoUninstall() { $this->UnInstallFiles(); return true; } function InstallFiles() { CopyDirFiles($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/webizi.csv/install/admin", $_SERVER["DOCUMENT_ROOT"]."/bitrix/admin", true); CopyDirFiles($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/webizi.csv/themes/.default", $_SERVER["DOCUMENT_ROOT"]."/bitrix/themes/.default", true); RegisterModule("webizi.csv"); return true; } function UnInstallFiles() { DeleteDirFiles($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/webizi.csv/install/admin/", $_SERVER["DOCUMENT_ROOT"]."/bitrix/admin"); DeleteDirFiles($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/webizi.csv/themes/.default", $_SERVER["DOCUMENT_ROOT"]."/bitrix/themes/.default"); UnRegisterModule("webizi.csv"); return true; } } ?>��admin/menu.php��0000644��00000001434�15125205703�0007313 0��ustar�00��<? IncludeModuleLangFile(__FILE__); $aMenu = array ( "parent_menu" => "global_menu_services", "sort" => 800, "icon" => "wi-csv-ico", "text" => GetMessage("WI_CSV"), "title" => GetMessage("WI_CSV"), "module_id" => "webizi.csv", "items_id" => "menu_wi_import_csv", ); $aMenu["items"][] = array ( "text" => GetMessage("MCART_EXCEL_IMPORT"), "items_id" => "iblock_import", "module_id" => "webizi.csv", "title" => GetMessage("MCART_EXCEL_IMPORT"), "url" => "wi_csv_import.php?lang=".LANGUAGE_ID, ); $aMenu["items"][] = array ( "text" => GetMessage("MCART_EXCEL_EXPORT"), "items_id" => "iblock_export", "module_id" => "webizi.csv", "title" => GetMessage("MCART_EXCEL_EXPORT"), "url" => "wi_csv_export.php?lang=".LANGUAGE_ID, ); return $aMenu; ?>��admin/data_import.php��0000644��00000156351�15125205703�0010663 0��ustar�00��<? require_once ($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_before.php"); CModule::IncludeModule("iblock"); require_once ($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/iblock/prolog.php"); require_once($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/webizi.csv/classes/general/wi_csv.php"); IncludeModuleLangFile($_SERVER["DOCUMENT_ROOT"].'/bitrix/modules/iblock/admin/data_import.php'); IncludeModuleLangFile(__FILE__); set_time_limit(0); $IBLOCK_ID = intval($IBLOCK_ID); $STEP = intval($STEP); if ($STEP <= 0) $STEP = 1; if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["backButton"]) && strlen($_POST["backButton"]) > 0) $STEP = $STEP - 2; if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["backButton2"]) && strlen($_POST["backButton2"]) > 0) $STEP = 1; $NUM_CATALOG_LEVELS = (int)COption::GetOptionInt('iblock', 'num_catalog_levels'); if ($NUM_CATALOG_LEVELS <= 0) $NUM_CATALOG_LEVELS = 3; $max_execution_time = intval($max_execution_time); if ($max_execution_time <= 0) $max_execution_time = 0; if (isset($_REQUEST["CUR_LOAD_SESS_ID"]) && strlen($_REQUEST["CUR_LOAD_SESS_ID"]) > 0) $CUR_LOAD_SESS_ID = $_REQUEST["CUR_LOAD_SESS_ID"]; else $CUR_LOAD_SESS_ID = "CL".time(); $bAllLinesLoaded = True; $CUR_FILE_POS = isset($_REQUEST["CUR_FILE_POS"]) ? intval($_REQUEST["CUR_FILE_POS"]) : 0; $strError = ""; $line_num = 0; $correct_lines = 0; $error_lines = 0; $killed_lines = 0; $io = CBXVirtualIo::GetInstance(); ///////////////////////////////////////////////////////////////////// $arIBlockAvailProdFields = array( "IE_XML_ID" => array( "field" => "XML_ID", "important" => "Y", "name" => GetMessage("IBLOCK_ADM_IMP_FI_UNIXML")." (B_IBLOCK_ELEMENT.XML_ID)", ) , "IE_NAME" => array( "field" => "NAME", "important" => "Y", "name" => GetMessage("IBLOCK_ADM_IMP_FI_NAME")." (B_IBLOCK_ELEMENT.NAME)", ) , "IE_PREVIEW_PICTURE" => array( "field" => "PREVIEW_PICTURE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_CATIMG")." (B_IBLOCK_ELEMENT.PREVIEW_PICTURE)", ) , "IE_PREVIEW_TEXT" => array( "field" => "PREVIEW_TEXT", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_CATDESCR")." (B_IBLOCK_ELEMENT.PREVIEW_TEXT)", ) , "IE_PREVIEW_TEXT_TYPE" => array( "field" => "PREVIEW_TEXT_TYPE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_CATDESCRTYPE")." (B_IBLOCK_ELEMENT.PREVIEW_TEXT_TYPE)", ) , "IE_DETAIL_PICTURE" => array( "field" => "DETAIL_PICTURE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_DETIMG")." (B_IBLOCK_ELEMENT.DETAIL_PICTURE)", ) , "IE_DETAIL_TEXT" => array( "field" => "DETAIL_TEXT", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_DETDESCR")." (B_IBLOCK_ELEMENT.DETAIL_TEXT)", ) , "IE_DETAIL_TEXT_TYPE" => array( "field" => "DETAIL_TEXT_TYPE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_DETDESCRTYPE")." (B_IBLOCK_ELEMENT.DETAIL_TEXT_TYPE)", ) , "IE_ACTIVE" => array( "field" => "ACTIVE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_ACTIV")." (B_IBLOCK_ELEMENT.ACTIVE)", ) , "IE_ACTIVE_FROM" => array( "field" => "ACTIVE_FROM", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_ACTIVFROM")." (B_IBLOCK_ELEMENT.ACTIVE_FROM)", ) , "IE_ACTIVE_TO" => array( "field" => "ACTIVE_TO", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_ACTIVTO")." (B_IBLOCK_ELEMENT.ACTIVE_TO)", ) , "IE_SORT" => array( "field" => "SORT", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_SORT")." (B_IBLOCK_ELEMENT.SORT)", ) , "IE_CODE" => array( "field" => "CODE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_CODE")." (B_IBLOCK_ELEMENT.CODE)", ) , "IE_TAGS" => array( "field" => "TAGS", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FI_TAGS")." (B_IBLOCK_ELEMENT.TAGS)", ) , ); $arIBlockAvailGroupFields = array( "IC_GROUP" => array( "field" => "NAME", "important" => "Y", "name" => GetMessage("IBLOCK_ADM_IMP_FG_NAME")." (B_IBLOCK_SECTION.NAME)", ) , "IC_XML_ID" => array( "field" => "XML_ID", "important" => "Y", "name" => GetMessage("IBLOCK_ADM_IMP_FG_UNIXML")." (B_IBLOCK_SECTION.XML_ID)", ) , "IC_ACTIVE" => array( "field" => "ACTIVE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FG_ACTIV")." (B_IBLOCK_SECTION.ACTIVE)", ) , "IC_SORT" => array( "field" => "SORT", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FG_SORT")." (B_IBLOCK_SECTION.SORT)", ) , "IC_DESCRIPTION" => array( "field" => "DESCRIPTION", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FG_DESCR")." (B_IBLOCK_SECTION.DESCRIPTION)", ) , "IC_DESCRIPTION_TYPE" => array( "field" => "DESCRIPTION_TYPE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FG_DESCRTYPE")." (B_IBLOCK_SECTION.DESCRIPTION_TYPE)", ) , "IC_CODE" => array( "field" => "CODE", "important" => "N", "name" => GetMessage("IBLOCK_ADM_IMP_FG_CODE")." (B_IBLOCK_SECTION.CODE)", ), ); ///////////////////////////////////////////////////////////////////// class CAssocData extends CCSVData { var $__rows = array(); var $__pos = array(); var $__last_pos = 0; var $NUM_FIELDS = 0; var $IBLOCK_ID = 0; var $tmpid = ""; var $PK = array(); var $GROUP_REGEX = ""; function __construct($fields_type = "R", $first_header = false, $NUM_FIELDS = 0) { parent::__construct($fields_type, $first_header); $this->NUM_FIELDS = (int)$NUM_FIELDS; } function GetPos() { if(empty($this->__pos)) return parent::GetPos(); else return $this->__pos[count($this->__pos) - 1]; } function Fetch() { if (empty($this->__rows)) { $this->__last_pos = $this->GetPos(); return parent::Fetch(); } else { $this->__last_pos = array_pop($this->__pos); return array_pop($this->__rows); } } function PutBack($row) { $this->__rows[] = $row; $this->__pos[] = $this->__last_pos; } function AddPrimaryKey($field_name, $field_ind) { $this->PK[$field_name] = $field_ind; } function SetGroupFields($arGroupFields) { $ar = array(); foreach ($arGroupFields as $name => $arField) $ar[] = $name; $this->GROUP_REGEX = "/^(".implode("\|", $ar).")\\d+\$/"; } function FetchAssoc() { global $line_num; $result = array(); while ($ar = $this->Fetch()) { $line_num++; //Search for "PRIMARY KEY" foreach ($this->PK as $pk_field => $pk_ind) { if (array_key_exists($pk_field, $result)) { //Check for Next record if ($result[$pk_field] !== "".trim($ar[$pk_ind])) { $line_num--; $this->PutBack($ar); return $result; } else { //When XML_ID do match we skip NAME check break; } } } for ($i = 0; $i < $this->NUM_FIELDS; $i++) { $key = $GLOBALS["field_".$i]; $value = "".trim($ar[$i]); if (preg_match($this->GROUP_REGEX, $key)) { //IBlockSection if (!array_key_exists($key, $result)) $result[$key] = array(); $result[$key][] = $value; } elseif (preg_match("/^IP_PROP/", $key)) { //Multiple values only for properties if (!array_key_exists($key, $result)) { $result[$key] = $value; } elseif (!is_array($result[$key]) && $result[$key] !== $value) { $result[$key] = array( $result[$key], ); $result[$key][] = $value; } elseif (is_array($result[$key]) && !in_array($value, $result[$key])) { $result[$key][] = $value; } else { //we ignore repeated values } } else { $result[$key] = $value; } } if (empty($this->PK)) return $result; } //eof if (empty($result)) return $ar; else return $result; } function MapSections($arRes) { global $NUM_CATALOG_LEVELS, $arIBlockAvailGroupFields, $USE_TRANSLIT; $USE_TRANSLIT = (isset($USE_TRANSLIT) && 'Y' == $USE_TRANSLIT ? 'Y' : 'N'); static $arSectionCache = array(); $bs = new CIBlockSection; $result = array(); while (true) { // this array is path to element $arGroupsTmp = array(); for ($i = 0; $i < $NUM_CATALOG_LEVELS; $i++) { $bOK = false; //will be true when at least one important field met $arGroupsTmp1 = array( "TMP_ID" => $this->tmpid, ); foreach ($arIBlockAvailGroupFields as $key => $value) { $fkey = $value["field"]; if (array_key_exists($key.$i, $arRes) && !empty($arRes[$key.$i])) { $arGroupsTmp1[$fkey] = array_shift($arRes[$key.$i]); } if ($value["important"] == "Y" && isset($arGroupsTmp1[$fkey]) && strlen($arGroupsTmp1[$fkey]) > 0) $bOK = true; } // drop empty target sections if ($bOK) { // When group does not have name "<Empty name>" if (strlen($arGroupsTmp1["NAME"]) <= 0) $arGroupsTmp1["NAME"] = GetMessage("IBLOCK_ADM_IMP_NOMAME"); $arGroupsTmp[] = $arGroupsTmp1; } else { break; } } //Finished with groups if (empty($arGroupsTmp)) break; // Create sections tree. Save section code for elemet insertions $LAST_GROUP_CODE = 0; foreach ($arGroupsTmp as $i => $arGroup) { $arFilter = array( "IBLOCK_ID" => $this->IBLOCK_ID, "CHECK_PERMISSIONS" => "N", ); if (isset($arGroup["XML_ID"]) && strlen($arGroup["XML_ID"])) { $arFilter["=XML_ID"] = $arGroup["XML_ID"]; } elseif (isset($arGroup["NAME"]) && strlen($arGroup["NAME"])) { $arFilter["=NAME"] = $arGroup["NAME"]; } if ($LAST_GROUP_CODE > 0) { $arFilter["SECTION_ID"] = $LAST_GROUP_CODE; $arGroupsTmp[$i]["IBLOCK_SECTION_ID"] = $LAST_GROUP_CODE; } else { $arFilter["SECTION_ID"] = 0; $arGroupsTmp[$i]["IBLOCK_SECTION_ID"] = false; } if ($USE_TRANSLIT == "Y") { $arGroupsTmp[$i]["CODE"] = $this->ToTranslite($arGroup["NAME"], "SECTION"); } $cache_id = md5(serialize($arFilter)); if (array_key_exists($cache_id, $arSectionCache)) { $arr = $arSectionCache[$cache_id]; } else { $res = CIBlockSection::GetList(array() , $arFilter); if ($arr = $res->Fetch()) $arSectionCache[$cache_id] = $arr; } if ($arr) { $arGroupsTmp[$i]["IBLOCK_ID"] = $arr["IBLOCK_ID"]; $LAST_GROUP_CODE = $arr["ID"]; $bUpdate = false; foreach ($arGroupsTmp[$i] as $field_code => $field_value) { if ($field_value."" !== $arr[$field_code]."") { $bUpdate = true; break; } } if ($bUpdate) { $res = $bs->Update($LAST_GROUP_CODE, $arGroupsTmp[$i]); unset($arSectionCache[$cache_id]); } } else { $arGroupsTmp[$i]["IBLOCK_ID"] = $this->IBLOCK_ID; $arGroupsTmp[$i]["ACTIVE"] = "Y"; $LAST_GROUP_CODE = $bs->Add($arGroupsTmp[$i]); } } if ($LAST_GROUP_CODE > 0) $result[$LAST_GROUP_CODE] = $LAST_GROUP_CODE; } return $result; } function MapEnum($prop_id, $value) { global $multi_separator_type; if ($multi_separator_type != "" && strpos($value, $multi_separator_type) !== false) { $arrEnum = WICsv::GetEnumList($this->IBLOCK_ID); $tmpEnum = explode($multi_separator_type, $value); foreach ($tmpEnum as $eval) { $newArr[] = (array_search(trim($eval), $arrEnum[$prop_id])) ? array_search(trim($eval), $arrEnum[$prop_id]) : CIBlockPropertyEnum::Add(array( "PROPERTY_ID" => $prop_id, "VALUE" => $eval, "TMP_ID" => $this->tmpid, )); } return $newArr; } static $arEnumCache = array(); if (is_array($value)) { foreach ($value as $k => $v) $value[$k] = $this->MapEnum($prop_id, $v); } else { if (!isset($arEnumCache[$prop_id])) $arEnumCache[$prop_id] = array(); if (array_key_exists($value, $arEnumCache[$prop_id])) { $value = $arEnumCache[$prop_id][$value]; } else { $res2 = CIBlockProperty::GetPropertyEnum($prop_id, array() , array( "IBLOCK_ID" => $this->IBLOCK_ID, "VALUE" => $value, )); if ($arRes2 = $res2->Fetch()) $value = $arEnumCache[$prop_id][$value] = $arRes2["ID"]; else $value = $arEnumCache[$prop_id][$value] = CIBlockPropertyEnum::Add(array( "PROPERTY_ID" => $prop_id, "VALUE" => $value, "TMP_ID" => $this->tmpid, )); } } return $value; } function MapString($value) { global $multi_separator_type; if ($multi_separator_type != "") return explode($multi_separator_type, $value); else return $value; } function MapNumbers($value) { global $multi_separator_type; if ($multi_separator_type != "") return explode($multi_separator_type, str_replace(",", ".", $value)); else return $value; } function MapFiles($value) { global $PATH2PROP_FILES, $multi_separator_type; $io = CBXVirtualIo::GetInstance(); if ($multi_separator_type != "") $value = explode($multi_separator_type, $value); if (!is_array($value)) $value = array( $value, ); $result = array(); $j = 0; foreach ($value as $i => $file_name) { if (strlen($file_name) > 0) { if (preg_match("/^(http\|https):\\/\\//", $file_name)) $arFile = CFile::MakeFileArray($file_name); else $arFile = CFile::MakeFileArray($io->GetPhysicalName($_SERVER["DOCUMENT_ROOT"].$PATH2PROP_FILES."/".$file_name)); if (isset($arFile["tmp_name"])) $result["n".($j++)] = $arFile; } } return $result; } function ToTranslite($name, $type) { global $IBLOCK_ID, $TRANSLIT_LANG, $USE_TRANSLIT; if ($IBLOCK_ID <= 0) { $strError .= GetMessage("CATI_NO_IBLOCK")."<br>"; } else { $arIBlock = CIBlock::GetArrayByID($IBLOCK_ID); if (false === $arIBlock) { $strError .= GetMessage("CATI_NO_IBLOCK")."<br>"; } } $USE_TRANSLIT = (isset($USE_TRANSLIT) && 'Y' == $USE_TRANSLIT ? 'Y' : 'N'); if ('Y' == $USE_TRANSLIT) { $boolOutTranslit = false; if (isset($arIBlock['FIELDS']['CODE']['DEFAULT_VALUE'])) { if ('Y' == $arIBlock['FIELDS']['CODE']['DEFAULT_VALUE']['TRANSLITERATION'] && 'Y' == $arIBlock['FIELDS']['CODE']['DEFAULT_VALUE']['USE_GOOGLE']) { $boolOutTranslit = true; } } if (isset($arIBlock['FIELDS']['SECTION_CODE']['DEFAULT_VALUE'])) { if ('Y' == $arIBlock['FIELDS']['SECTION_CODE']['DEFAULT_VALUE']['TRANSLITERATION'] && 'Y' == $arIBlock['FIELDS']['SECTION_CODE']['DEFAULT_VALUE']['USE_GOOGLE']) { $boolOutTranslit = true; } } if ($boolOutTranslit) { $USE_TRANSLIT = 'N'; $strError .= GetMessage("CATI_USE_CODE_TRANSLIT_OUT")."<br>"; } } if ('Y' == $USE_TRANSLIT) { $TRANSLIT_LANG = (isset($TRANSLIT_LANG) ? strval($TRANSLIT_LANG) : ''); if (!empty($TRANSLIT_LANG)) { $rsTransLangs = CLanguage::GetByID($TRANSLIT_LANG); if (!($arTransLang = $rsTransLangs->Fetch())) { $TRANSLIT_LANG = ''; } } if (empty($TRANSLIT_LANG)) { $USE_TRANSLIT = 'N'; $strError .= GetMessage("CATI_CODE_TRANSLIT_LANG_ERR")."<br>"; } } if ('Y' == $USE_TRANSLIT) { if (isset($arIBlock['FIELDS']['CODE']['DEFAULT_VALUE']) && $type == "ELEMENT") { $arTransSettings = $arIBlock['FIELDS']['CODE']['DEFAULT_VALUE']; $boolTranslitElement = ('Y' == $arTransSettings['TRANSLITERATION'] ? true : false); $arTranslitElement = array( "max_len" => $arTransSettings['TRANS_LEN'], "change_case" => $arTransSettings['TRANS_CASE'], "replace_space" => $arTransSettings['TRANS_SPACE'], "replace_other" => $arTransSettings['TRANS_OTHER'], "delete_repeat_replace" => ('Y' == $arTransSettings['TRANS_EAT'] ? true : false), "use_google" => ('Y' == $arTransSettings['USE_GOOGLE'] ? true : false), ); } if (isset($arIBlock['FIELDS']['SECTION_CODE']['DEFAULT_VALUE']) && $type == "SECTION") { $arTransSettings = $arIBlock['FIELDS']['SECTION_CODE']['DEFAULT_VALUE']; $boolTranslitSection = ('Y' == $arTransSettings['TRANSLITERATION'] ? true : false); $arTranslitSection = array( "max_len" => $arTransSettings['TRANS_LEN'], "change_case" => $arTransSettings['TRANS_CASE'], "replace_space" => $arTransSettings['TRANS_SPACE'], "replace_other" => $arTransSettings['TRANS_OTHER'], "delete_repeat_replace" => ('Y' == $arTransSettings['TRANS_EAT'] ? true : false), "use_google" => ('Y' == $arTransSettings['USE_GOOGLE'] ? true : false), ); } } if ($boolTranslitElement && $type == "ELEMENT") { return CUtil::translit($name, $TRANSLIT_LANG, $arTranslitElement); } if ($boolTranslitSection && $type == "SECTION") { return CUtil::translit($name, $TRANSLIT_LANG, $arTranslitSection); } } } ///////////////////////////////////////////////////////////////////// if (($REQUEST_METHOD == "POST" \|\| $CUR_FILE_POS > 0) && $STEP > 1 && check_bitrix_sessid()) { //***************************************************************// if ($STEP > 1) { //*************************************************************// $DATA_FILE_NAME = ""; if (isset($_FILES["DATA_FILE"]) && is_uploaded_file($_FILES["DATA_FILE"]["tmp_name"])) { if (strtolower(GetFileExtension($_FILES["DATA_FILE"]["name"])) != "csv") { $strError.= GetMessage("IBLOCK_ADM_IMP_NOT_CSV")."<br>"; } else { $DATA_FILE_NAME = "/".COption::GetOptionString("main", "upload_dir", "upload")."/".basename($_FILES["DATA_FILE"]["name"]); if ($APPLICATION->GetFileAccessPermission($DATA_FILE_NAME) >= "W") copy($_FILES["DATA_FILE"]["tmp_name"], $_SERVER["DOCUMENT_ROOT"].$DATA_FILE_NAME); else $DATA_FILE_NAME = ""; } } if (strlen($strError) <= 0) { if (strlen($DATA_FILE_NAME) <= 0) { if (strlen($URL_DATA_FILE) > 0) { $URL_DATA_FILE = trim(str_replace("\\", "/", trim($URL_DATA_FILE)) , "/"); $FILE_NAME = rel2abs($_SERVER["DOCUMENT_ROOT"], "/".$URL_DATA_FILE); if ( (strlen($FILE_NAME) > 1) && ($FILE_NAME === "/".$URL_DATA_FILE) && $io->FileExists($_SERVER["DOCUMENT_ROOT"].$FILE_NAME) && ($APPLICATION->GetFileAccessPermission($FILE_NAME) >= "W") ) { $DATA_FILE_NAME = $FILE_NAME; } } } if (strlen($DATA_FILE_NAME) <= 0) $strError.= GetMessage("IBLOCK_ADM_IMP_NO_DATA_FILE_SIMPLE")."<br>"; if (!CIBlockRights::UserHasRightTo($IBLOCK_ID, $IBLOCK_ID, "element_edit_any_wf_status")) $strError.= GetMessage("IBLOCK_ADM_IMP_NO_IBLOCK")."<br>"; } if (strlen($strError) <= 0) { if ($CUR_FILE_POS > 0 && is_set($_SESSION, $CUR_LOAD_SESS_ID) && is_set($_SESSION[$CUR_LOAD_SESS_ID], "LOAD_SCHEME")) { parse_str($_SESSION[$CUR_LOAD_SESS_ID]["LOAD_SCHEME"]); $STEP = 4; } } if (strlen($strError) > 0) $STEP = 1; //*************************************************************// } if ($STEP > 2) { //*************************************************************// $csvFile = new CAssocData; $csvFile->LoadFile($io->GetPhysicalName($_SERVER["DOCUMENT_ROOT"].$DATA_FILE_NAME)); if ($fields_type != "F" && $fields_type != "R") $strError.= GetMessage("IBLOCK_ADM_IMP_NO_FILE_FORMAT")."<br>"; $arDataFileFields = array(); if (strlen($strError) <= 0) { $fields_type = (($fields_type == "F") ? "F" : "R"); $csvFile->SetFieldsType($fields_type); if ($fields_type == "R") { $first_names_r = (($first_names_r == "Y") ? "Y" : "N"); $csvFile->SetFirstHeader(($first_names_r == "Y") ? true : false); $delimiter_r_char = ""; switch ($delimiter_r) { case "TAB": $delimiter_r_char = "\t"; break; case "ZPT": $delimiter_r_char = ","; break; case "SPS": $delimiter_r_char = " "; break; case "OTR": $delimiter_r_char = substr($delimiter_other_r, 0, 1); break; case "TZP": $delimiter_r_char = ";"; break; } if (strlen($delimiter_r_char) != 1) $strError.= GetMessage("IBLOCK_ADM_IMP_NO_DELIMITER")."<br>"; if (strlen($strError) <= 0) { $csvFile->SetDelimiter($delimiter_r_char); } } else { $first_names_f = (($first_names_f == "Y") ? "Y" : "N"); $csvFile->SetFirstHeader(($first_names_f == "Y") ? true : false); if (strlen($metki_f) <= 0) $strError.= GetMessage("IBLOCK_ADM_IMP_NO_METKI")."<br>"; if (strlen($strError) <= 0) { $arMetki = array(); foreach (preg_split("/[\D]/i", $metki_f) as $metka) { $metka = intval($metka); if ($metka > 0) $arMetki[] = $metka; } if (!is_array($arMetki) \|\| count($arMetki) < 1) $strError.= GetMessage("IBLOCK_ADM_IMP_NO_METKI")."<br>"; if (strlen($strError) <= 0) { $csvFile->SetWidthMap($arMetki); } } } if (strlen($strError) <= 0) { $bFirstHeaderTmp = $csvFile->GetFirstHeader(); $csvFile->SetFirstHeader(false); if ($arRes = $csvFile->Fetch()) { foreach ($arRes as $i => $ar) { $arDataFileFields[$i] = $ar; } } else { $strError.= GetMessage("IBLOCK_ADM_IMP_NO_DATA")."<br>"; } $NUM_FIELDS = count($arDataFileFields); } } if (strlen($strError) > 0) $STEP = 2; //*************************************************************// } if ($STEP > 3) { //*************************************************************// $bFieldsPres = False; for ($i = 0; $i < $NUM_FIELDS; $i++) { if (strlen(${"field_".$i}) > 0) { $bFieldsPres = True; break; } } if (!$bFieldsPres) $strError.= GetMessage("IBLOCK_ADM_IMP_NO_FIELDS")."<br>"; if (strlen($strError) <= 0) { $csvFile->SetPos($CUR_FILE_POS); if ($CUR_FILE_POS <= 0 && $bFirstHeaderTmp) { $arRes = $csvFile->Fetch(); } $io = CBXVirtualIo::GetInstance(); $bs = new CIBlockSection; $el = new CIBlockElement; $el->CancelWFSetMove(); $tmpid = md5(uniqid("")); $arIBlockProperty = array(); $bThereIsGroups = False; if ($CUR_FILE_POS > 0 && is_set($_SESSION, $CUR_LOAD_SESS_ID)) { if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "tmpid")) $tmpid = $_SESSION[$CUR_LOAD_SESS_ID]["tmpid"]; if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "line_num")) $line_num = intval($_SESSION[$CUR_LOAD_SESS_ID]["line_num"]); if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "correct_lines")) $correct_lines = intval($_SESSION[$CUR_LOAD_SESS_ID]["correct_lines"]); if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "error_lines")) $error_lines = intval($_SESSION[$CUR_LOAD_SESS_ID]["error_lines"]); if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "killed_lines")) $killed_lines = intval($_SESSION[$CUR_LOAD_SESS_ID]["killed_lines"]); if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "arIBlockProperty")) $arIBlockProperty = $_SESSION[$CUR_LOAD_SESS_ID]["arIBlockProperty"]; if (is_set($_SESSION[$CUR_LOAD_SESS_ID], "bThereIsGroups")) $bThereIsGroups = $_SESSION[$CUR_LOAD_SESS_ID]["bThereIsGroups"]; } // Prepare arrays for elements load $bWorkFlow = CModule::IncludeModule('workflow'); foreach ($arIBlockAvailProdFields as $key => $arField) { if ($arField["field"] === "XML_ID") { for ($i = 0; $i < $NUM_FIELDS; $i++) if ($key === $GLOBALS["field_".$i]) $csvFile->AddPrimaryKey($key, $i); } elseif ($arField["field"] === "NAME") { for ($i = 0; $i < $NUM_FIELDS; $i++) if ($key === $GLOBALS["field_".$i]) $csvFile->AddPrimaryKey($key, $i); } } $csvFile->tmpid = $tmpid; $csvFile->IBLOCK_ID = $IBLOCK_ID; $csvFile->NUM_FIELDS = $NUM_FIELDS; $csvFile->SetGroupFields($arIBlockAvailGroupFields); $arIBlockFileProperty = array(); // Main loop while ($arRes = $csvFile->FetchAssoc()) { $strErrorR = ""; // Create element $arLoadProductArray = array( "MODIFIED_BY" => $USER->GetID() , "IBLOCK_ID" => $IBLOCK_ID, "TMP_ID" => $tmpid, "IBLOCK_SECTION" => $csvFile->MapSections($arRes) , ); //Preserve existing sections if(empty($arLoadProductArray["IBLOCK_SECTION"])) unset($arLoadProductArray["IBLOCK_SECTION"]); $bThereIsGroups \|= !empty($arLoadProductArray["IBLOCK_SECTION"]); foreach ($arIBlockAvailProdFields as $key => $arField) { if (array_key_exists($key, $arRes)) $arLoadProductArray[$arField["field"]] = $arRes[$key]; } $USE_TRANSLIT = (isset($USE_TRANSLIT) && 'Y' == $USE_TRANSLIT ? 'Y' : 'N'); if ($USE_TRANSLIT == "Y") { $arLoadProductArray["CODE"] = $csvFile->ToTranslite($arLoadProductArray["NAME"], "ELEMENT"); } $arFilter = array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", ); if (strlen($arLoadProductArray["XML_ID"])) $arFilter["=XML_ID"] = $arLoadProductArray["XML_ID"]; elseif (strlen($arLoadProductArray["NAME"])) $arFilter["=NAME"] = $arLoadProductArray["NAME"]; else $strErrorR.= GetMessage("IBLOCK_ADM_IMP_LINE_NO")." ".$line_num.". ".GetMessage("IBLOCK_ADM_IMP_NOIDNAME")."<br>"; if (strlen($strErrorR) <= 0) { $arLoadProductArray["PROPERTY_VALUES"] = array(); foreach ($arRes as $key => $value) { if (strncmp($key, "IP_PROP", 7) == 0) { $cur_prop_id = (int)substr($key, 7); if (!array_key_exists($cur_prop_id, $arIBlockProperty)) { $res1 = CIBlockProperty::GetByID($cur_prop_id, $IBLOCK_ID); $arIBlockProperty[$cur_prop_id] = $res1->Fetch(); } if (is_array($arIBlockProperty[$cur_prop_id])) { if ($arIBlockProperty[$cur_prop_id]["PROPERTY_TYPE"] == "L") $value = $csvFile->MapEnum($cur_prop_id, $value); elseif ($arIBlockProperty[$cur_prop_id]["PROPERTY_TYPE"] == "N") $value = $csvFile->MapNumbers($value); elseif ($arIBlockProperty[$cur_prop_id]["PROPERTY_TYPE"] == "S") $value = $csvFile->MapString($value); elseif ($arIBlockProperty[$cur_prop_id]["PROPERTY_TYPE"] == "F") { $value = $csvFile->MapFiles($value); $arIBlockFileProperty[$cur_prop_id] = $cur_prop_id; } else { $value = explode($multi_separator_type, $value); } $arLoadProductArray["PROPERTY_VALUES"][$cur_prop_id] = $value; } } } } if (strlen($strErrorR) <= 0) { if (array_key_exists("PREVIEW_PICTURE", $arLoadProductArray)) { if (strlen($arLoadProductArray["PREVIEW_PICTURE"]) > 0) { if (preg_match("/^(http\|https):\\/\\//", $arLoadProductArray["PREVIEW_PICTURE"])) { $arLoadProductArray["PREVIEW_PICTURE"] = CFile::MakeFileArray($arLoadProductArray["PREVIEW_PICTURE"]); } else { $arLoadProductArray["PREVIEW_PICTURE"] = CFile::MakeFileArray($io->GetPhysicalName($_SERVER["DOCUMENT_ROOT"].$PATH2IMAGE_FILES."/".$arLoadProductArray["PREVIEW_PICTURE"])); if (is_array($arLoadProductArray["PREVIEW_PICTURE"])) $arLoadProductArray["PREVIEW_PICTURE"]["COPY_FILE"] = "Y"; } } if (!is_array($arLoadProductArray["PREVIEW_PICTURE"])) unset($arLoadProductArray["PREVIEW_PICTURE"]); } if (array_key_exists("DETAIL_PICTURE", $arLoadProductArray)) { if (strlen($arLoadProductArray["DETAIL_PICTURE"]) > 0) { if (preg_match("/^(http\|https):\\/\\//", $arLoadProductArray["DETAIL_PICTURE"])) { $arLoadProductArray["DETAIL_PICTURE"] = CFile::MakeFileArray($arLoadProductArray["DETAIL_PICTURE"]); } else { $arLoadProductArray["DETAIL_PICTURE"] = CFile::MakeFileArray($io->GetPhysicalName($_SERVER["DOCUMENT_ROOT"].$PATH2IMAGE_FILES."/".$arLoadProductArray["DETAIL_PICTURE"])); if (is_array($arLoadProductArray["DETAIL_PICTURE"])) $arLoadProductArray["DETAIL_PICTURE"]["COPY_FILE"] = "Y"; } } if (!is_array($arLoadProductArray["DETAIL_PICTURE"])) unset($arLoadProductArray["DETAIL_PICTURE"]); } $res = CIBlockElement::GetList(array() , $arFilter, false, false, array( "ID", "IBLOCK_ID", "TMP_ID", "PREVIEW_PICTURE", "DETAIL_PICTURE", )); if ($arr = $res->Fetch()) { $PRODUCT_ID = $arr["ID"]; if ($arr["TMP_ID"] != $tmpid) { if (is_set($arLoadProductArray, "PREVIEW_PICTURE") && IntVal($arr["PREVIEW_PICTURE"]) > 0) { $arLoadProductArray["PREVIEW_PICTURE"]["old_file"] = $arr["PREVIEW_PICTURE"]; } if (is_set($arLoadProductArray, "DETAIL_PICTURE") && IntVal($arr["DETAIL_PICTURE"]) > 0) { $arLoadProductArray["DETAIL_PICTURE"]["old_file"] = $arr["DETAIL_PICTURE"]; } if (!empty($arLoadProductArray["PROPERTY_VALUES"])) { $arPropsLoaded = $arLoadProductArray["PROPERTY_VALUES"]; $dbPropFiles = CIBlockElement::GetProperty($IBLOCK_ID, $PRODUCT_ID, "sort", "asc", array( "CHECK_PERMISSIONS" => "N", )); while ($arPropFile = $dbPropFiles->Fetch()) { if($arPropFile["PROPERTY_TYPE"] == "F" && array_key_exists($arPropFile["ID"], $arPropsLoaded)) $arLoadProductArray["PROPERTY_VALUES"][$arPropFile["ID"]][$arPropFile["PROPERTY_VALUE_ID"]] = array( "del" => "Y", "tmp_name" => "", ); elseif( $arPropFile["PROPERTY_TYPE"] != "F" && !array_key_exists($arPropFile["ID"], $arPropsLoaded) && (is_array($arPropFile["VALUE"]) \|\| strlen($arPropFile["VALUE"]) > 0) ) { $arLoadProductArray["PROPERTY_VALUES"][$arPropFile["ID"]][$arPropFile["PROPERTY_VALUE_ID"]] = array( "VALUE" => $arPropFile["VALUE"], "DESCRIPTION" => $arPropFile["DESCRIPTION"], ); } } } else { unset($arLoadProductArray["PROPERTY_VALUES"]); } $res = $el->Update($PRODUCT_ID, $arLoadProductArray, $bWorkFlow, true, $IMAGE_RESIZE === "Y"); } else { $res = true; } } else { if ($arLoadProductArray["ACTIVE"] != "N") $arLoadProductArray["ACTIVE"] = "Y"; $PRODUCT_ID = $el->Add($arLoadProductArray, $bWorkFlow, true, $IMAGE_RESIZE === "Y"); $res = ($PRODUCT_ID > 0); } if (!$res) { $strErrorR.= GetMessage("IBLOCK_ADM_IMP_LINE_NO")." ".$line_num.". ".GetMessage("IBLOCK_ADM_IMP_ERROR_LOADING")." ".$el->LAST_ERROR."<br>"; } } if (strlen($strErrorR) <= 0) { $correct_lines++; } else { $error_lines++; $strError.= $strErrorR; } if (intval($max_execution_time) > 0 && (getmicrotime() - START_EXEC_TIME) > intval($max_execution_time)) { $bAllLinesLoaded = False; break; } } // delete sections and elements which no in datafile. Properties does not deleted if ($bAllLinesLoaded) { if (is_set($_SESSION, $CUR_LOAD_SESS_ID)) unset($_SESSION[$CUR_LOAD_SESS_ID]); if ($bThereIsGroups) { if ($outFileAction == "D") { $res = CIBlockSection::GetList(array() , array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", "!TMP_ID" => $tmpid, )); while ($arr = $res->Fetch()) CIBlockSection::Delete($arr["ID"]); } elseif ($outFileAction == "F") { } else { $res = CIBlockSection::GetList(array() , array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", "!TMP_ID" => $tmpid, "ACTIVE" => "Y", )); while ($arr = $res->Fetch()) $bs->Update($arr["ID"], array( "NAME" => $arr["NAME"], "ACTIVE" => "N", )); } if ($inFileAction == "A") { $res = CIBlockSection::GetList(array() , array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", "TMP_ID" => $tmpid, "ACTIVE" => "N", )); while ($arr = $res->Fetch()) $bs->Update($arr["ID"], array( "NAME" => $arr["NAME"], "ACTIVE" => "Y", )); } } if ($outFileAction == "D") { $res = CIBlockElement::GetList(array() , array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", "!=TMP_ID" => $tmpid, ) , false, false, array( "ID", "IBLOCK_ID", )); while ($arr = $res->Fetch()) { CIBlockElement::Delete($arr["ID"], "Y", "N"); $killed_lines++; } } elseif ($outFileAction == "F") { } else { $res = CIBlockElement::GetList(array() , array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", "!=TMP_ID" => $tmpid, "ACTIVE" => "Y", ) , false, false, array( "ID", "IBLOCK_ID", )); while ($arr = $res->Fetch()) { $el->Update($arr["ID"], array( "ACTIVE" => "N", )); $killed_lines++; } } if ($inFileAction == "A") { $res = CIBlockElement::GetList(array() , array( "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", "TMP_ID" => $tmpid, "ACTIVE" => "N", ) , false, false, array( "ID", "IBLOCK_ID", )); while ($arr = $res->Fetch()) { $el->Update($arr["ID"], array( "ACTIVE" => "Y", )); } } } else { if (strlen($CUR_LOAD_SESS_ID) <= 0) $CUR_LOAD_SESS_ID = "CL".time(); $_SESSION[$CUR_LOAD_SESS_ID]["tmpid"] = $tmpid; $_SESSION[$CUR_LOAD_SESS_ID]["line_num"] = $line_num; $_SESSION[$CUR_LOAD_SESS_ID]["correct_lines"] = $correct_lines; $_SESSION[$CUR_LOAD_SESS_ID]["error_lines"] = $error_lines; $_SESSION[$CUR_LOAD_SESS_ID]["killed_lines"] = $killed_lines; $_SESSION[$CUR_LOAD_SESS_ID]["arIBlockProperty"] = $arIBlockProperty; $_SESSION[$CUR_LOAD_SESS_ID]["bThereIsGroups"] = $bThereIsGroups; $paramsStr = "fields_type=".urlencode($fields_type); $paramsStr.= "&first_names_r=".urlencode($first_names_r); $paramsStr.= "&delimiter_r=".urlencode($delimiter_r); $paramsStr.= "&delimiter_other_r=".urlencode($delimiter_other_r); $paramsStr.= "&first_names_f=".urlencode($first_names_f); $paramsStr.= "&metki_f=".urlencode($metki_f); for ($i = 0; $i < $NUM_FIELDS; $i++) { $paramsStr.= "&field_".$i."=".urlencode(${"field_".$i}); } $paramsStr.= "&PATH2IMAGE_FILES=".urlencode($PATH2IMAGE_FILES); $paramsStr.= "&IMAGE_RESIZE=".urlencode($IMAGE_RESIZE); $paramsStr.= "&PATH2PROP_FILES=".urlencode($PATH2PROP_FILES); $paramsStr.= "&outFileAction=".urlencode($outFileAction); $paramsStr.= "&inFileAction=".urlencode($inFileAction); $paramsStr.= "&multi_separator_type=".urlencode($multi_separator_type); $paramsStr.= "&TRANSLIT_LANG=".urlencode($TRANSLIT_LANG); $paramsStr.= "&USE_TRANSLIT=".urlencode($USE_TRANSLIT); $paramsStr.= "&max_execution_time=".urlencode($max_execution_time); $_SESSION[$CUR_LOAD_SESS_ID]["LOAD_SCHEME"] = $paramsStr; $curFilePos = $csvFile->GetPos(); } } if (strlen($strError) > 0) { $strError.= GetMessage("IBLOCK_ADM_IMP_TOTAL_ERRS")." ".$error_lines.".<br>"; $strError.= GetMessage("IBLOCK_ADM_IMP_TOTAL_COR1")." ".$correct_lines." ".GetMessage("IBLOCK_ADM_IMP_TOTAL_COR2")."<br>"; $STEP = 3; } //*************************************************************// } //*************************************************************// } ///////////////////////////////////////////////////////////////////// $APPLICATION->SetTitle(GetMessage("IBLOCK_ADM_IMP_PAGE_TITLE").$STEP); require ($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_after.php"); /*****************************************************************/ /**************** BODY *************************************/ /******************************************************************/ CAdminMessage::ShowMessage($strError); if (!$bAllLinesLoaded) { $strParams = bitrix_sessid_get()."&CUR_FILE_POS=".$curFilePos."&CUR_LOAD_SESS_ID=".urlencode($CUR_LOAD_SESS_ID)."&STEP=4&URL_DATA_FILE=".urlencode($DATA_FILE_NAME)."&IBLOCK_ID=".$IBLOCK_ID."&fields_type=".urlencode($fields_type)."&max_execution_time=".IntVal($max_execution_time); if ($fields_type == "R") $strParams.= "&delimiter_r=".urlencode($delimiter_r)."&delimiter_other_r=".urlencode($delimiter_other_r)."&first_names_r=".urlencode($first_names_r); else $strParams.= "&metki_f=".urlencode($metki_f)."&first_names_f=".urlencode($first_names_f); ?> <?=GetMessage("IBLOCK_ADM_IMP_AUTO_REFRESH")?> <a href="<?echo $APPLICATION->GetCurPage()?>?lang=<?echo LANG ?>&<?echo $strParams ?>"><?=GetMessage("IBLOCK_ADM_IMP_AUTO_REFRESH_STEP")?></a><br> <script type="text/javascript"> function DoNext() { window.location="<?echo $APPLICATION->GetCurPage()?>?lang=<?echo LANG ?>&<?echo $strParams ?>"; } setTimeout('DoNext()', 2000); </script> <? } ?> <form method="POST" action="<?echo $sDocPath ?>?lang=<?echo LANG ?>" ENCTYPE="multipart/form-data" name="dataload" id="dataload"> <?$aTabs = array( array( "DIV" => "edit1", "TAB" => GetMessage("IBLOCK_ADM_IMP_TAB1") , "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_IMP_TAB1_ALT"), ) , array( "DIV" => "edit2", "TAB" => GetMessage("IBLOCK_ADM_IMP_TAB2") , "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_IMP_TAB2_ALT"), ) , array( "DIV" => "edit3", "TAB" => GetMessage("IBLOCK_ADM_IMP_TAB3") , "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_IMP_TAB3_ALT"), ) , array( "DIV" => "edit4", "TAB" => GetMessage("IBLOCK_ADM_IMP_TAB4") , "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_IMP_TAB4_ALT"), ) , ); $tabControl = new CAdminTabControl("tabControl", $aTabs, false, true); $tabControl->Begin(); ?> <?$tabControl->BeginNextTab(); if ($STEP == 1) { ?> <tr> <td width="40%"><?=GetMessage("IBLOCK_ADM_IMP_DATA_FILE")?></td> <td width="60%"> <input type="text" name="URL_DATA_FILE" value="<?echo htmlspecialcharsbx($URL_DATA_FILE)?>" size="30"> <input type="button" value="<?=GetMessage("IBLOCK_ADM_IMP_OPEN")?>" OnClick="BtnClick()"> <?CAdminFileDialog::ShowScript(array( "event" => "BtnClick", "arResultDest" => array( "FORM_NAME" => "dataload", "FORM_ELEMENT_NAME" => "URL_DATA_FILE", ) , "arPath" => array( "SITE" => SITE_ID, "PATH" => "/".COption::GetOptionString("main", "upload_dir", "upload"), ) , "select" => 'F', // F - file only, D - folder only "operation" => 'O', // O - open, S - save "showUploadTab" => true, "showAddToMenuTab" => false, "fileFilter" => 'csv', "allowAllFiles" => true, "SaveConfig" => true, )); ?> </td> </tr> <tr> <td><?=GetMessage("IBLOCK_ADM_IMP_INFOBLOCK")?></td> <td> <?echo GetIBlockDropDownList($IBLOCK_ID, 'IBLOCK_TYPE_ID', 'IBLOCK_ID', false, 'class="adm-detail-iblock-types"', 'class="adm-detail-iblock-list"')?> </td> </tr> <? } $tabControl->EndTab(); ?> <?$tabControl->BeginNextTab(); if ($STEP == 2) { ?> <tr> <td width="40%"> </td> <td width="60%"> <script type="text/javascript"> function DeactivateAllExtra() { document.getElementById("table_r").disabled = true; document.getElementById("table_r1").disabled = true; document.getElementById("table_r2").disabled = true; document.getElementById("table_f").disabled = true; document.getElementById("table_f1").disabled = true; document.getElementById("table_f2").disabled = true; document.dataload.metki_f.disabled = true; /document.dataload.first_names_f.disabled = true; / document.getElementById("first_names_f_Y").disabled = true; var i; for (i = 0 ; i < document.dataload.delimiter_r.length; i++) { document.dataload.delimiter_r[i].disabled = true; } document.dataload.delimiter_other_r.disabled = true; /document.dataload.first_names_r.disabled = true; / document.getElementById("first_names_r_Y").disabled = true; } function ChangeExtra() { if (document.dataload.fields_type[0].checked) { document.getElementById("table_r").disabled = false; document.getElementById("table_r1").disabled = false; document.getElementById("table_r2").disabled = false; document.getElementById("table_f").disabled = true; document.getElementById("table_f1").disabled = true; document.getElementById("table_f2").disabled = true; var i; for (i = 0 ; i < document.dataload.delimiter_r.length; i++) { document.dataload.delimiter_r[i].disabled = false; } document.dataload.delimiter_other_r.disabled = false; / document.dataload.first_names_r.disabled = false; / document.getElementById("first_names_r_Y").disabled = false; document.dataload.metki_f.disabled = true; / document.dataload.first_names_f.disabled = true; / document.getElementById("first_names_f_Y").disabled = true; document.dataload.submit_btn.disabled = false; } else { if (document.dataload.fields_type[1].checked) { document.getElementById("table_r").disabled = true; document.getElementById("table_r1").disabled = true; document.getElementById("table_r2").disabled = true; document.getElementById("table_f").disabled = false; document.getElementById("table_f1").disabled = false; document.getElementById("table_f2").disabled = false; var i; for (i = 0 ; i < document.dataload.delimiter_r.length; i++) { document.dataload.delimiter_r[i].disabled = true; } document.dataload.delimiter_other_r.disabled = true; / document.dataload.first_names_r.disabled = true; / document.getElementById("first_names_r_Y").disabled = true; document.dataload.metki_f.disabled = false; / document.dataload.first_names_f.disabled = false; / document.getElementById("first_names_f_Y").disabled = false; document.dataload.submit_btn.disabled = false; } } } </script> <input type="radio" name="fields_type" id="fields_type_R" value="R" <? if ($fields_type == "R" \|\| strlen($fields_type) <= 0) echo "checked"?> onClick="ChangeExtra()"><label for="fields_type_R"><?=GetMessage("IBLOCK_ADM_IMP_RAZDELITEL")?></label><br> <input type="radio" name="fields_type" id="fields_type_F" value="F" <? if ($fields_type == "F") echo "checked"?> onClick="ChangeExtra()"><label for="fields_type_F"><?=GetMessage("IBLOCK_ADM_IMP_FIXED")?></label> </td> </tr> <tr id="table_r" class="heading"> <td colspan="2"><?=GetMessage("IBLOCK_ADM_IMP_RAZDEL1")?></td> </tr> <tr id="table_r1"> <td class="adm-detail-valign-top"><?=GetMessage("IBLOCK_ADM_IMP_RAZDEL_TYPE")?>:</td> <td> <input type="radio" name="delimiter_r" id="delimiter_r_TZP" value="TZP" <? if ($delimiter_r == "TZP" \|\| strlen($delimiter_r) <= 0) echo "checked" ?>><label for="delimiter_r_TZP"><?=GetMessage("IBLOCK_ADM_IMP_TZP")?></label><br> <input type="radio" name="delimiter_r" id="delimiter_r_ZPT" value="ZPT" <? if ($delimiter_r == "ZPT") echo "checked" ?>><label for="delimiter_r_ZPT"><?=GetMessage("IBLOCK_ADM_IMP_ZPT")?></label><br> <input type="radio" name="delimiter_r" id="delimiter_r_TAB" value="TAB" <? if ($delimiter_r == "TAB") echo "checked" ?>><label for="delimiter_r_TAB"><?=GetMessage("IBLOCK_ADM_IMP_TAB")?></label><br> <input type="radio" name="delimiter_r" id="delimiter_r_SPS" value="SPS" <? if ($delimiter_r == "SPS") echo "checked" ?>><label for="delimiter_r_SPS"><?=GetMessage("IBLOCK_ADM_IMP_SPS")?></label><br> <input type="radio" name="delimiter_r" id="delimiter_r_OTR" value="OTR" <? if ($delimiter_r == "OTR") echo "checked" ?>><label for="delimiter_r_OTR"><?=GetMessage("IBLOCK_ADM_IMP_OTR")?></label> <input type="text" name="delimiter_other_r" size="3" value="<?echo htmlspecialcharsbx($delimiter_other_r)?>"> </td> </tr> <tr id="table_r2"> <td><?=GetMessage("IBLOCK_ADM_IMP_FIRST_NAMES")?>:</td> <td> <input type="hidden" name="first_names_r" id="first_names_r_N" value="N"> <input type="checkbox" name="first_names_r" id="first_names_r_Y" value="Y" <? if ($first_names_r != "N") echo "checked" ?>> </td> </tr> <tr id="table_f" class="heading"> <td colspan="2"><?=GetMessage("IBLOCK_ADM_IMP_FIX1")?></td> </tr> <tr id="table_f1"> <td class="adm-detail-valign-top"> <?=GetMessage("IBLOCK_ADM_IMP_FIX_MET")?><br> <small><?=GetMessage("IBLOCK_ADM_IMP_FIX_MET_DESCR")?></small>: </td> <td> <textarea name="metki_f" rows="7" cols="3"><?echo htmlspecialcharsbx($metki_f)?></textarea> </td> </tr> <tr id="table_f2"> <td><?=GetMessage("IBLOCK_ADM_IMP_FIRST_NAMES")?>:</td> <td> <input type="hidden" name="first_names_f" id="first_names_f_N" value="N"> <input type="checkbox" name="first_names_f" id="first_names_f_Y" value="Y" <? if ($first_names_f == "Y") echo "checked" ?>> </td> </tr> <tr id="multi_separator" class="heading"> <td colspan="2"><label><?=GetMessage("WI_MULTI_SEPARATOR")?></label><br></td> </tr> <tr id="multi_separator1"> <td class="adm-detail-valign-top"> <?=GetMessage("WI_SEPARATOR")?><br> <small><?=GetMessage("WI_EXAMPLE")?></small>: </td> <td> <input type="text" name="multi_separator_type" size="3" value="<?echo htmlspecialcharsbx($multi_separator_type)?>"> </td> </tr> <tr class="heading"> <td colspan="2"><?=GetMessage("IBLOCK_ADM_IMP_DATA_SAMPLES")?></td> </tr> <tr> <td align="center" colspan="2"> <?$sContent = ""; if (strlen($DATA_FILE_NAME) > 0) { $DATA_FILE_NAME = trim(str_replace("\\", "/", trim($DATA_FILE_NAME)) , "/"); $FILE_NAME = rel2abs($_SERVER["DOCUMENT_ROOT"], "/".$DATA_FILE_NAME); if ( (strlen($FILE_NAME) > 1) && ($FILE_NAME == "/".$DATA_FILE_NAME) && $APPLICATION->GetFileAccessPermission($FILE_NAME) >= "W" ) { $f = $io->GetFile($_SERVER["DOCUMENT_ROOT"].$FILE_NAME); $file_id = $f->open("rb"); $sContent = fread($file_id, 10000); fclose($file_id); } } ?> <textarea name="data" wrap="OFF" rows="10" cols="80" style="width:100%"><?echo htmlspecialcharsbx($sContent)?></textarea> </td> </tr> <? } $tabControl->EndTab(); ?> <?$tabControl->BeginNextTab(); if ($STEP == 3) { ?> <tr class="heading"> <td colspan="2"><?=GetMessage("IBLOCK_ADM_IMP_FIELDS_SOOT")?></td> </tr> <? $arAvailFields = array(); foreach ($arIBlockAvailProdFields as $field_name => $arField) { $arAvailFields[] = array( "value" => $field_name, "name" => $arField["name"], ); } $properties = CIBlockProperty::GetList(array( "sort" => "asc", "name" => "asc", ) , array( "ACTIVE" => "Y", "IBLOCK_ID" => $IBLOCK_ID, "CHECK_PERMISSIONS" => "N", )); while ($prop_fields = $properties->Fetch()) { $arAvailFields[] = array( "value" => "IP_PROP".$prop_fields["ID"], "name" => GetMessage("IBLOCK_ADM_IMP_FI_PROPS")." \"".$prop_fields["NAME"]."\"", "code" => "IP_PROP_".$prop_fields["CODE"], ); } for ($k = 0; $k < $NUM_CATALOG_LEVELS; $k++) { foreach ($arIBlockAvailGroupFields as $field_name => $arField) { $arAvailFields[] = array( "value" => $field_name.$k, "name" => GetMessage("IBLOCK_ADM_IMP_FI_GROUP_LEV")." ".($k + 1).": ".$arField["name"], ); } } foreach ($arDataFileFields as $i => $field) { ?> <tr> <td width="40%"> <b><?=GetMessage("IBLOCK_ADM_IMP_FIELD")?> <?echo $i + 1 ?></b> (<?echo htmlspecialcharsbx($field)?>): </td> <td width="60%"> <select name="field_<?echo $i ?>"> <option value=""> - </option> <? foreach ($arAvailFields as $ar) { $bSelected = ${"field_".$i} == $ar["value"]; if (!$bSelected && !isset(${"field_".$i})) $bSelected = $ar["value"] == $field; if (!$bSelected && !isset(${"field_".$i})) $bSelected = $ar["code"] == $field; ?> <option value="<?echo $ar["value"] ?>" <? if ($bSelected) echo "selected" ?>><?echo htmlspecialcharsbx($ar["name"])?></option> <? } ?> </select> </td> </tr> <? } ?> <tr class="heading"> <td colspan="2"><?=GetMessage("IBLOCK_ADM_IMP_ADDIT_SETTINGS")?></td> </tr> <tr> <td class="adm-detail-valign-top"><?=GetMessage("IBLOCK_ADM_IMP_IMG_PATH")?>:</td> <td> <input type="text" name="PATH2IMAGE_FILES" size="40" value="<?echo htmlspecialcharsbx($PATH2IMAGE_FILES)?>"><br> <small><?=GetMessage("IBLOCK_ADM_IMP_IMG_PATH_DESCR")?><br></small> </td> </tr> <tr> <td><label for="IMAGE_RESIZE"><?=GetMessage("IBLOCK_ADM_IMP_IMG_RESIZE")?>:</label></td> <td> <input type="checkbox" name="IMAGE_RESIZE" id="IMAGE_RESIZE" value="Y" <?echo ($IMAGE_RESIZE === "Y" ? "checked" : "")?>> </td> </tr> <tr> <td width="40%"><label for="USE_TRANSLIT_Y"><?=GetMessage("WI_USE_TRANSLITERATION")?></label>:</td> <td width="60%"> <input type="hidden" name="USE_TRANSLIT" id="USE_TRANSLIT_N" value="N"><? if ($boolOutTranslit) { echo GetMessage('CATI_USE_CODE_TRANSLIT_OUT'); } else { ?><input type="checkbox" name="USE_TRANSLIT" id="USE_TRANSLIT_Y" value="Y" <? echo (isset($USE_TRANSLIT) && 'Y' == $USE_TRANSLIT ? ' checked' : ''); ?>><? } ?> </td> </tr> <? if (!isset($TRANSLIT_LANG) \|\| empty($TRANSLIT_LANG)) $TRANSLIT_LANG = LANGUAGE_ID; if ($boolOutTranslit) { ?><input type="hidden" name="TRANSLIT_LANG" value="<? echo htmlspecialcharsbx($TRANSLIT_LANG); ?>"><? } else { ?><tr> <td width="40%"><?=GetMessage("WI_LANGUAGE_TRANSLITERATION")?>:</td> <td width="60%"> <? echo CLanguage::SelectBox('TRANSLIT_LANG', $TRANSLIT_LANG); ?> </td> </tr><? } ?> <tr> <td class="adm-detail-valign-top"><?=GetMessage("IBLOCK_ADM_IMP_PROP_PATH")?>:</td> <td> <input type="text" name="PATH2PROP_FILES" size="40" value="<?echo htmlspecialcharsbx($PATH2PROP_FILES)?>"><br> <small><?=GetMessage("IBLOCK_ADM_IMP_PROP_PATH_DESCR")?><br></small> </td> </tr> <tr> <td class="adm-detail-valign-top"><?=GetMessage("IBLOCK_ADM_IMP_OUTFILE")?>:</td> <td> <input type="radio" id="outFileAction_H" name="outFileAction" value="H" <? if ($outFileAction == "H") echo "checked"?>><label for="outFileAction_H"><?=GetMessage("IBLOCK_ADM_IMP_OF_DEACT")?></label><br> <input type="radio" id="outFileAction_D" name="outFileAction" value="D" <? if ($outFileAction == "D") echo "checked"?>><label for="outFileAction_D"><?=GetMessage("IBLOCK_ADM_IMP_OF_DEL")?></label><br> <input type="radio" id="outFileAction_F" name="outFileAction" value="F" <? if (strlen($outFileAction) <= 0 \|\| $outFileAction == "F") echo "checked"?>><label for="outFileAction_F"><?=GetMessage("IBLOCK_ADM_IMP_OF_KEEP")?></label> </td> </tr> <tr> <td class="adm-detail-valign-top"><?=GetMessage("IBLOCK_ADM_IMP_INACTIVE_PRODS")?>:</td> <td> <input type="radio" id="inFileAction_F" name="inFileAction" value="F" <? if (strlen($inFileAction) <= 0 \|\| ($inFileAction == "F")) echo "checked"?>><label for="inFileAction_F"><?=GetMessage("IBLOCK_ADM_IMP_KEEP_AS_IS")?></label><br> <input type="radio" id="inFileAction_A" name="inFileAction" value="A" <? if ($inFileAction == "A") echo "checked"?>><label for="inFileAction_A"><?=GetMessage("IBLOCK_ADM_IMP_ACTIVATE_PROD")?></label> </td> </tr> <tr> <td class="adm-detail-valign-top"><?=GetMessage("IBLOCK_ADM_IMP_AUTO_STEP_TIME")?>:</td> <td align="left"> <input type="text" name="max_execution_time" size="6" value="<?echo htmlspecialcharsbx($max_execution_time)?>"><br> <small><?=GetMessage("IBLOCK_ADM_IMP_AUTO_STEP_TIME_NOTE")?><br></small> </td> </tr> <tr class="heading"> <td colspan="2"><?=GetMessage("IBLOCK_ADM_IMP_DATA_SAMPLES")?></td> </tr> <tr> <td colspan="2" align="center"> <?$sContent = ""; if (strlen($DATA_FILE_NAME) > 0) { $DATA_FILE_NAME = trim(str_replace("\\", "/", trim($DATA_FILE_NAME)) , "/"); $FILE_NAME = rel2abs($_SERVER["DOCUMENT_ROOT"], "/".$DATA_FILE_NAME); if ( (strlen($FILE_NAME) > 1) && ($FILE_NAME == "/".$DATA_FILE_NAME) && $APPLICATION->GetFileAccessPermission($FILE_NAME) >= "W" ) { $f = $io->GetFile($_SERVER["DOCUMENT_ROOT"].$FILE_NAME); $file_id = $f->open("rb"); $sContent = fread($file_id, 10000); fclose($file_id); } } ?> <textarea name="data" wrap="OFF" rows="10" cols="80" style="width:100%"><?echo htmlspecialcharsbx($sContent)?></textarea> </td> </tr> <? } $tabControl->EndTab(); ?> <?$tabControl->BeginNextTab(); if ($STEP == 4) { ?> <tr> <td> <?echo CAdminMessage::ShowMessage(array( "TYPE" => "PROGRESS", "MESSAGE" => !$bAllLinesLoaded? GetMessage("IBLOCK_ADM_IMP_AUTO_REFRESH_CONTINUE"): GetMessage("IBLOCK_ADM_IMP_SUCCESS"), "DETAILS" => GetMessage("IBLOCK_ADM_IMP_SU_ALL").' <b>'.$line_num.'</b><br>' .GetMessage("IBLOCK_ADM_IMP_SU_CORR").' <b>'.$correct_lines.'</b><br>' .GetMessage("IBLOCK_ADM_IMP_SU_ER").' <b>'.$error_lines.'</b><br>' .($outFileAction == "D" ?GetMessage("IBLOCK_ADM_IMP_SU_KILLED")." <b>".$killed_lines."</b>" :($outFileAction == "F" ? "" : GetMessage("IBLOCK_ADM_IMP_SU_HIDED")." <b>".$killed_lines."</b>" ) ), "HTML" => true, ))?> </td> </tr> <? } $tabControl->EndTab(); ?> <?$tabControl->Buttons(); ?> <? if ($STEP < 4): ?> <input type="hidden" name="STEP" value="<?echo $STEP + 1?>"> <?echo bitrix_sessid_post()?> <? if ($STEP > 1): ?> <input type="hidden" name="URL_DATA_FILE" value="<?echo htmlspecialcharsbx($DATA_FILE_NAME)?>"> <input type="hidden" name="IBLOCK_ID" value="<?echo $IBLOCK_ID ?>"> <? endif?> <? if ($STEP <> 2): ?> <input type="hidden" name="fields_type" value="<?echo htmlspecialcharsbx($fields_type)?>"> <input type="hidden" name="delimiter_r" value="<?echo htmlspecialcharsbx($delimiter_r)?>"> <input type="hidden" name="multi_separator_type" value="<?echo htmlspecialcharsbx($multi_separator_type)?>"> <input type="hidden" name="delimiter_other_r" value="<?echo htmlspecialcharsbx($delimiter_other_r)?>"> <input type="hidden" name="first_names_r" value="<?echo htmlspecialcharsbx($first_names_r)?>"> <input type="hidden" name="metki_f" value="<?echo htmlspecialcharsbx($metki_f)?>"> <input type="hidden" name="first_names_f" value="<?echo htmlspecialcharsbx($first_names_f)?>"> <? endif?> <? if ($STEP <> 3): ?> <? foreach ($_POST as $name => $value): ?> <? if (preg_match("/^field_(\\d+)$/", $name)): ?> <input type="hidden" name="<?echo $name ?>" value="<?echo htmlspecialcharsbx($value)?>"> <? endif ?> <? endforeach ?> <input type="hidden" name="PATH2IMAGE_FILES" value="<?echo htmlspecialcharsbx($PATH2IMAGE_FILES)?>"> <input type="hidden" name="IMAGE_RESIZE" value="<?echo htmlspecialcharsbx($IMAGE_RESIZE)?>"> <input type="hidden" name="PATH2PROP_FILES" value="<?echo htmlspecialcharsbx($PATH2PROP_FILES)?>"> <input type="hidden" name="outFileAction" value="<?echo htmlspecialcharsbx($outFileAction)?>"> <input type="hidden" name="inFileAction" value="<?echo htmlspecialcharsbx($inFileAction)?>"> <input type="hidden" name="USE_TRANSLIT" value="<?echo htmlspecialcharsbx($USE_TRANSLIT)?>"> <input type="hidden" name="max_execution_time" value="<?echo htmlspecialcharsbx($max_execution_time)?>"> <? endif?> <? if ($STEP > 1): ?> <input type="submit" name="backButton" value="<< <?=GetMessage("IBLOCK_ADM_IMP_BACK")?>"> <? endif ?> <input type="submit" value="<?echo ($STEP == 3) ? GetMessage("IBLOCK_ADM_IMP_NEXT_STEP_F") : GetMessage("IBLOCK_ADM_IMP_NEXT_STEP")?> >>" name="submit_btn" class="adm-btn-save"> <?if ($STEP == 2) { ?> <SCRIPT LANGUAGE="JavaScript"> DeactivateAllExtra(); ChangeExtra(); </SCRIPT> <? } ?> <? else: ?> <input type="submit" name="backButton2" value="<< <?=GetMessage("IBLOCK_ADM_IMP_2_1_STEP")?>" class="adm-btn-save"> <? endif?> <?$tabControl->End(); ?> </form> <script language="JavaScript"> <!-- <?if ($STEP < 2): ?> tabControl.SelectTab("edit1"); tabControl.DisableTab("edit2"); tabControl.DisableTab("edit3"); tabControl.DisableTab("edit4"); <?elseif ($STEP == 2): ?> tabControl.SelectTab("edit2"); tabControl.DisableTab("edit1"); tabControl.DisableTab("edit3"); tabControl.DisableTab("edit4"); <?elseif ($STEP == 3): ?> tabControl.SelectTab("edit3"); tabControl.DisableTab("edit1"); tabControl.DisableTab("edit2"); tabControl.DisableTab("edit4"); <?elseif ($STEP > 3): ?> tabControl.SelectTab("edit4"); tabControl.DisableTab("edit1"); tabControl.DisableTab("edit2"); tabControl.DisableTab("edit3"); <?endif?> //--> </script> <?require ($DOCUMENT_ROOT."/bitrix/modules/main/include/epilog_admin.php"); ?> ��admin/data_export.php��0000644��00000053457�15125205703�0010675 0��ustar�00��<? require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_before.php"); CModule::IncludeModule("iblock"); require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/iblock/prolog.php"); IncludeModuleLangFile(__FILE__); $bPublicMode = defined('BX_PUBLIC_MODE') && BX_PUBLIC_MODE == 1; set_time_limit(0); $IBLOCK_ID = IntVal($IBLOCK_ID); $STEP = IntVal($STEP); if ($STEP <= 0) $STEP = 1; if ($_SERVER["REQUEST_METHOD"] == "POST" && strlen($backButton) > 0) $STEP = $STEP - 2; if ($_SERVER["REQUEST_METHOD"] == "POST" && strlen($backButton2) > 0) $STEP = 1; $NUM_CATALOG_LEVELS = intval(COption::GetOptionInt('iblock', 'num_catalog_levels', 3)); if ($NUM_CATALOG_LEVELS <= 0) $NUM_CATALOG_LEVELS = 3; $strError = ""; $DATA_FILE_NAME = ""; ///////////////////////////////////////////////////////////////////// function GetValueByCodeTmp($code) { global $NUM_FIELDS; for ($i = 0; $i < $NUM_FIELDS; $i++) { if ($GLOBALS["field_".$i] == $code) return $i; } return -1; } / This function takes an array (arTuple) which is mix of scalar values and arrays and return "rectangular" array of arrays. For example: array(1, array(1, 2), 3, arrays(4, 5)) will be transformed as array( array(1, 1, 3, 4), array(1, 1, 3, 5), array(1, 2, 3, 4), array(1, 2, 3, 5), ) / function ArrayMultiply(&$arResult, $arTuple, $arTemp = array()) { global $csvFile, $DATA_FILE_NAME, $num_rows_writed; if(count($arTuple) == 0) { $csvFile->SaveFile($_SERVER["DOCUMENT_ROOT"].$DATA_FILE_NAME, $arTemp); $num_rows_writed++; } else { $head = array_shift($arTuple); $arTemp[] = false; if(is_array($head)) { if(empty($head)) { $arTemp[count($arTemp)-1] = ""; ArrayMultiply($arResult, $arTuple, $arTemp); } else { foreach($head as $key=>$value) { $arTemp[count($arTemp)-1] = $value; ArrayMultiply($arResult, $arTuple, $arTemp); } } } else { $arTemp[count($arTemp)-1] = $head; ArrayMultiply($arResult, $arTuple, $arTemp); } } } ///////////////////////////////////////////////////////////////////// if ($_SERVER['REQUEST_METHOD'] == "POST" && $STEP > 1 && check_bitrix_sessid()) { //**************************************************************// if ($STEP > 1) { //*************************************************************// $arIBlockRes = CIBlock::GetList( array("sort" => "asc"), array( "ID" => $IBLOCK_ID, "MIN_PERMISSION" => "X", "OPERATION" => "iblock_export", ) ); $arIBlockRes = new CIBlockResult($arIBlockRes); if ($IBLOCK_ID <= 0 \|\| !($arIBlock = $arIBlockRes->GetNext())) $strError .= GetMessage("IBLOCK_ADM_EXP_NO_IBLOCK")."<br>"; if (strlen($strError) > 0) $STEP = 1; //*************************************************************// } if ($STEP > 2) { //**************************************************************// $csvFile = new CCSVData(); if ($fields_type != "F" && $fields_type != "R") $strError .= GetMessage("IBLOCK_ADM_EXP_NO_FORMAT")."<br>"; $csvFile->SetFieldsType($fields_type); $delimiter_r_char = ""; switch ($delimiter_r) { case "TAB": $delimiter_r_char = "\t"; break; case "ZPT": $delimiter_r_char = ","; break; case "SPS": $delimiter_r_char = " "; break; case "OTR": $delimiter_r_char = substr($delimiter_other_r, 0, 1); break; case "TZP": $delimiter_r_char = ";"; break; } if (strlen($delimiter_r_char) != 1) $strError .= GetMessage("IBLOCK_ADM_EXP_NO_DELIMITER")."<br>"; if (strlen($strError) <= 0) $csvFile->SetDelimiter($delimiter_r_char); if (strlen($_REQUEST["DATA_FILE_NAME"]) <= 0) { $strError .= GetMessage("IBLOCK_ADM_EXP_NO_FILE_NAME")."<br>"; } elseif ( preg_match('/[^a-zA-Z0-9\s!#\$%&\[\]\{\}+\.;=@\^_\~\/\\\\\-]/i', $_REQUEST["DATA_FILE_NAME"]) \|\| preg_match('/^[a-z]+:\\/\\//i', $_REQUEST["DATA_FILE_NAME"]) \|\| HasScriptExtension($_REQUEST["DATA_FILE_NAME"]) ) { $strError .= GetMessage("IBLOCK_ADM_EXP_FILE_NAME_ERROR")."<br>"; } else { $DATA_FILE_NAME = Rel2Abs("/", $_REQUEST["DATA_FILE_NAME"]); if (strtolower(substr($DATA_FILE_NAME, strlen($DATA_FILE_NAME)-4)) != ".csv") $DATA_FILE_NAME .= ".csv"; } if (strlen($strError) <= 0) { $fp = fopen($_SERVER["DOCUMENT_ROOT"].$DATA_FILE_NAME, "w"); if(!is_resource($fp)) { $strError .= GetMessage("IBLOCK_ADM_EXP_CANNOT_CREATE_FILE")."<br>"; $DATA_FILE_NAME = ""; } else { fclose($fp); } } if (!is_array($field_needed) \|\| !in_array("Y", $field_needed)) $strError .= GetMessage("IBLOCK_ADM_EXP_NO_FIELDS")."<br>"; $num_rows_writed = 0; if (strlen($strError) <= 0) { $selectArray = array( "ID", "IBLOCK_ID", "IBLOCK_SECTION_ID", ); $bNeedGroups = false; $bNeedProps = false; $arNeedFields = array(); foreach($field_code as $i => $value) { if($field_needed[$i]=="Y") { if(strncmp($value, "IE_", 3) == 0) { $selectArray[] = substr($value, 3); } elseif(strncmp($value, "IC_GROUP", 8) == 0) { $bNeedGroups = true; } elseif(!$bNeedProps && (strncmp($value, "IP_PROP", 7) == 0)) { $selectArray[] = "PROPERTY_"; $bNeedProps = true; } $j = $field_num[$i]; while(array_key_exists($j, $arNeedFields)) $j++; $arNeedFields[$j] = $value; } } ksort($arNeedFields); if($first_line_names == "Y") { $arResFields = array(); foreach($arNeedFields as $field_name) $arResFields[] = $field_name; $csvFile->SaveFile($_SERVER["DOCUMENT_ROOT"].$DATA_FILE_NAME, $arResFields); } $res = CIBlockElement::GetList( array(), array("IBLOCK_ID" => $IBLOCK_ID, "MIN_PERMISSION" => "W"), false, false, $selectArray ); $arUserTypeFormat = false; while ($obElement = $res->GetNextElement()) { $arElement = $obElement->GetFields(); if(array_key_exists("PREVIEW_PICTURE", $arElement)) { $arElement["PREVIEW_PICTURE"] = CFile::GetFileArray($arElement["PREVIEW_PICTURE"]); if($arElement["PREVIEW_PICTURE"]) $arElement["~PREVIEW_PICTURE"] = $arElement["PREVIEW_PICTURE"]["SRC"]; } if(array_key_exists("DETAIL_PICTURE", $arElement)) { $arElement["DETAIL_PICTURE"] = CFile::GetFileArray($arElement["DETAIL_PICTURE"]); if($arElement["DETAIL_PICTURE"]) $arElement["~DETAIL_PICTURE"] = $arElement["DETAIL_PICTURE"]["SRC"]; } if($bNeedProps) $arProperties = $obElement->GetProperties(); else $arProperties = array(); if($arUserTypeFormat === false) { $arUserTypeFormat = array(); foreach($arProperties as $prop_id => $arProperty) { $arUserTypeFormat[$arProperty["ID"]] = false; if(strlen($arProperty["USER_TYPE"])) { $arUserType = CIBlockProperty::GetUserType($arProperty["USER_TYPE"]); if(isset($arUserType["GetPublicViewHTML"])) $arUserTypeFormat[$arProperty["ID"]] = $arUserType["GetPublicViewHTML"]; } } } $arPropsValues = array(); foreach($arProperties as $prop_id => $arProperty) { if($arUserTypeFormat[$arProperty["ID"]]) { if ($arProperty['MULTIPLE'] == 'Y' && is_array($arProperty["~VALUE"])) { $arValues = array(); foreach($arProperty["~VALUE"] as $value) $arValues[] = call_user_func_array($arUserTypeFormat[$arProperty["ID"]], array( $arProperty, array("VALUE" => $value), array("MODE" => "CSV_EXPORT"), )); } else { $arValues = call_user_func_array($arUserTypeFormat[$arProperty["ID"]], array( $arProperty, array("VALUE" => $arProperty["~VALUE"]), array("MODE" => "CSV_EXPORT"), )); } } elseif($arProperty["PROPERTY_TYPE"] == "F") { if(is_array($arProperty["~VALUE"])) { $arValues = array(); foreach($arProperty["~VALUE"] as $file_id) { $file = CFile::GetFileArray($file_id); if($file) $arValues[] = $file["SRC"]; } } elseif($arProperty["~VALUE"] > 0) { $file = CFile::GetFileArray($arProperty["~VALUE"]); if($file) $arValues = $file["SRC"]; else $arValues = ""; } else { $arValues = ""; } } else { $arValues = $arProperty["~VALUE"]; } if (is_array($arValues) && $multi_separator_type != "") $arPropsValues[$arProperty["ID"]] = implode($multi_separator_type, $arValues); else $arPropsValues[$arProperty["ID"]] = $arValues; } $arResSections = array(); if($bNeedGroups) { $rsSections = CIBlockElement::GetElementGroups($arElement["ID"], true); while($arSection = $rsSections->Fetch()) { $arPath = array(); $rsPath = CIBlockSection::GetNavChain($IBLOCK_ID, $arSection["ID"], array("NAME")); while($arPathSection = $rsPath->Fetch()) { $arPath[] = $arPathSection["NAME"]; } $arResSections[] = $arPath; } if(count($arResSections) <= 0) $arResSections[] = array(); } else { $arResSections[] = array(); } $arResFields = array(); foreach($arResSections as $arPath) { $arTuple = array(); foreach($arNeedFields as $field_name) { if(strncmp($field_name, "IE_", 3) == 0) $arTuple[] = $arElement["~".substr($field_name, 3)]; elseif(strncmp($field_name, "IP_PROP", 7) == 0) $arTuple[] = $arPropsValues[IntVal(substr($field_name, 7))]; elseif(strncmp($field_name, "IC_GROUP", 8) == 0) $arTuple[] = $arPath[IntVal(substr($field_name, 8))]; } ArrayMultiply($arResFields, $arTuple); } } } if (strlen($strError) > 0) $STEP = 2; elseif ($bPublicMode) { ?> <div id="result"> <div style="text-align: center; margin: 20px;"> <?echo GetMessage("IBLOCK_ADM_EXP_LINES_EXPORTED", array("#LINES#" => "<b>".intval($num_rows_writed)."</b>")) ?><br /> <?echo GetMessage("IBLOCK_ADM_EXP_DOWNLOAD_RESULT", array("#HREF#" => "<a href=\"".htmlspecialcharsbx($DATA_FILE_NAME)."\">".htmlspecialcharsbx($DATA_FILE_NAME)."</a>")) ?> </div> </div> <script type="text/javaScript"> top.BX.closeWait(); var w = top.BX.WindowManager.Get(); w.SetTitle('<?=CUtil::JSEscape(GetMessage("IBLOCK_ADM_EXP_PAGE_TITLE")." ".$STEP)?>'); w.SetHead(''); w.ClearButtons(); w.SetContent(document.getElementById('result').innerHTML); w.SetButtons(w.btnClose); </script> <? die(); } //***************************************************************// } //*************************************************************// } ///////////////////////////////////////////////////////////////////// $APPLICATION->SetTitle(GetMessage("IBLOCK_ADM_EXP_PAGE_TITLE")." ".$STEP); require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_after.php"); /*****************************************************************/ /**************** BODY *************************************/ /******************************************************************/ CAdminMessage::ShowMessage($strError); ?> <form method="POST" action="<?echo $sDocPath?>?lang=<?echo LANG ?>" ENCTYPE="multipart/form-data" name="dataload"> <input type="hidden" name="STEP" value="<?echo $STEP + 1;?>"> <?=bitrix_sessid_post()?> <? if ($STEP > 1) { ?><input type="hidden" name="IBLOCK_ID" value="<?echo $IBLOCK_ID ?>"><? } ?> <? if (!$bPublicMode) $aTabs = array( array("DIV" => "edit1", "TAB" => GetMessage("IBLOCK_ADM_EXP_TAB1"), "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_EXP_TAB1_ALT")), array("DIV" => "edit2", "TAB" => GetMessage("IBLOCK_ADM_EXP_TAB2"), "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_EXP_TAB2_ALT")), array("DIV" => "edit3", "TAB" => GetMessage("IBLOCK_ADM_EXP_TAB3"), "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_EXP_TAB3_ALT")), ); else $aTabs = array( array("DIV" => "edit2", "TAB" => GetMessage("IBLOCK_ADM_EXP_TAB2"), "ICON" => "iblock", "TITLE" => GetMessage("IBLOCK_ADM_EXP_TAB2_ALT")) ); $tabControl = new CAdminTabControl("tabControl", $aTabs, false, true); $tabControl->Begin(); if (!$bPublicMode) { $tabControl->BeginNextTab(); if ($STEP < 2) { ?> <tr> <td width="40%"><?echo GetMessage("IBLOCK_ADM_EXP_CHOOSE_IBLOCK") ?></td> <td width="60%"> <?echo GetIBlockDropDownListEx( $IBLOCK_ID, 'IBLOCK_TYPE_ID', 'IBLOCK_ID', array( "MIN_PERMISSION" => "X", "OPERATION" => "iblock_export", ), '', '', 'class="adm-detail-iblock-types"', 'class="adm-detail-iblock-list"' );?> </td> </tr> <? } $tabControl->EndTab(); } $tabControl->BeginNextTab(); if ($STEP == 2) { ?> <tr class="heading"> <td colspan="2"> <?echo GetMessage("IBLOCK_ADM_EXP_CHOOSE_FORMAT") ?> <input type="hidden" name="fields_type" value="R"> </td> </tr> <tr> <td width="40%" class="adm-detail-valign-top"><?echo GetMessage("IBLOCK_ADM_EXP_DELIMITER") ?>:</td> <td width="60%"> <input type="radio" name="delimiter_r" id="delimiter_TZP" value="TZP" <?if ($delimiter_r=="TZP" \|\| strlen($delimiter_r)<=0) echo "checked"?>><label for="delimiter_TZP"><?echo GetMessage("IBLOCK_ADM_EXP_DELIM_TZP") ?></label><br> <input type="radio" name="delimiter_r" id="delimiter_ZPT" value="ZPT" <?if ($delimiter_r=="ZPT") echo "checked"?>><label for="delimiter_ZPT"><?echo GetMessage("IBLOCK_ADM_EXP_DELIM_ZPT") ?></label><br> <input type="radio" name="delimiter_r" id="delimiter_TAB" value="TAB" <?if ($delimiter_r=="TAB") echo "checked"?>><label for="delimiter_TAB"><?echo GetMessage("IBLOCK_ADM_EXP_DELIM_TAB") ?></label><br> <input type="radio" name="delimiter_r" id="delimiter_SPS" value="SPS" <?if ($delimiter_r=="SPS") echo "checked"?>><label for="delimiter_SPS"><?echo GetMessage("IBLOCK_ADM_EXP_DELIM_SPS") ?></label><br> <input type="radio" name="delimiter_r" id="delimiter_OTR" value="OTR" <?if ($delimiter_r=="OTR") echo "checked"?>><label for="delimiter_OTR"><?echo GetMessage("IBLOCK_ADM_EXP_DELIM_OTR") ?></label> <input type="text" name="delimiter_other_r" size="3" value="<?echo htmlspecialcharsbx($delimiter_other_r) ?>"> </td> </tr> <tr> <td><?echo GetMessage("IBLOCK_ADM_EXP_FIRST_LINE_NAMES") ?>:</td> <td> <input type="checkbox" name="first_line_names" value="Y" <?if ($first_line_names=="Y" \|\| strlen($strError)<=0) echo "checked"?>> </td> </tr> <tr id="multi_separator" class="heading"> <td colspan="2"><label><?=GetMessage("WI_MULTI_SEPARATOR")?></label><br></td> </tr> <tr id="multi_separator1"> <td class="adm-detail-valign-top"> <?=GetMessage("WI_SEPARATOR")?><br> <small><?=GetMessage("WI_EXAMPLE")?></small>: </td> <td> <input type="text" name="multi_separator_type" size="3" value="<?echo htmlspecialcharsbx($multi_separator_type)?>"> </td> </tr> <tr class="heading"> <td colspan="2"><?echo GetMessage("IBLOCK_ADM_EXP_FIELDS_MAPPING") ?></td> </tr> <tr> <td colspan="2"> <? $arAvailFields = array( array("value"=>"IE_XML_ID", "name"=>GetMessage("IBLOCK_FIELD_XML_ID")." (B_IBLOCK_ELEMENT.XML_ID)"), array("value"=>"IE_NAME", "name"=>GetMessage("IBLOCK_FIELD_NAME")." (B_IBLOCK_ELEMENT.NAME)"), array("value"=>"IE_ID", "name"=>GetMessage("IBLOCK_FIELD_ID")." (B_IBLOCK_ELEMENT.ID)"), array("value"=>"IE_ACTIVE", "name"=>GetMessage("IBLOCK_FIELD_ACTIVE")." (B_IBLOCK_ELEMENT.ACTIVE)"), array("value"=>"IE_ACTIVE_FROM", "name"=>GetMessage("IBLOCK_FIELD_ACTIVE_FROM")." (B_IBLOCK_ELEMENT.ACTIVE_FROM)"), array("value"=>"IE_ACTIVE_TO", "name"=>GetMessage("IBLOCK_FIELD_ACTIVE_TO")." (B_IBLOCK_ELEMENT.ACTIVE_TO)"), array("value"=>"IE_PREVIEW_PICTURE", "name"=>GetMessage("IBLOCK_FIELD_PREVIEW_PICTURE")." (B_IBLOCK_ELEMENT.PREVIEW_PICTURE)"), array("value"=>"IE_PREVIEW_TEXT", "name"=>GetMessage("IBLOCK_FIELD_PREVIEW_TEXT")." (B_IBLOCK_ELEMENT.PREVIEW_TEXT)"), array("value"=>"IE_PREVIEW_TEXT_TYPE", "name"=>GetMessage("IBLOCK_FIELD_PREVIEW_TEXT_TYPE")." (B_IBLOCK_ELEMENT.PREVIEW_TEXT_TYPE)"), array("value"=>"IE_DETAIL_PICTURE", "name"=>GetMessage("IBLOCK_FIELD_DETAIL_PICTURE")." (B_IBLOCK_ELEMENT.DETAIL_PICTURE)"), array("value"=>"IE_DETAIL_TEXT", "name"=>GetMessage("IBLOCK_FIELD_DETAIL_TEXT")." (B_IBLOCK_ELEMENT.DETAIL_TEXT)"), array("value"=>"IE_DETAIL_TEXT_TYPE", "name"=>GetMessage("IBLOCK_FIELD_DETAIL_TEXT_TYPE")." (B_IBLOCK_ELEMENT.DETAIL_TEXT_TYPE)"), array("value"=>"IE_CODE", "name"=>GetMessage("IBLOCK_FIELD_CODE")." (B_IBLOCK_ELEMENT.CODE)"), array("value"=>"IE_SORT", "name"=>GetMessage("IBLOCK_FIELD_SORT")." (B_IBLOCK_ELEMENT.SORT)"), array("value"=>"IE_TAGS", "name"=>GetMessage("IBLOCK_FIELD_TAGS")." (B_IBLOCK_ELEMENT.TAGS)"), ); $properties = CIBlockProperty::GetList(Array("sort"=>"asc", "name"=>"asc"), Array("ACTIVE"=>"Y", "IBLOCK_ID"=>$IBLOCK_ID)); while ($prop_fields = $properties->Fetch()) { $arAvailFields[] = array( "value" => "IP_PROP".$prop_fields["ID"], "name" => GetMessage("IBLOCK_ADM_EXP_PROPERTY", array("#PROPERTY_NAME#" => htmlspecialcharsex($prop_fields["NAME"]))), ); } for ($i = 0; $i < $NUM_CATALOG_LEVELS; $i++) { $arAvailFields[] = array( "value" => "IC_GROUP".$i, "name" => GetMessage("IBLOCK_ADM_EXP_GROUP_LEVEL", array("#LEVEL_NUM#" => ($i+1))), ); } $intCountFields = count($arAvailFields); $intCountChecked = 0; $arCheckID = array(); for ($i = 0; $i < $intCountFields; $i++) { if ($field_needed[$i]=="Y" \|\| (!isset($field_needed) && strlen($strCSVError)<=0)) { $arCheckID[] = $i; $intCountChecked++; } } ?><table width="100%" border="0" cellspacing="0" cellpadding="0" class="internal"> <tr class="heading"> <td style="text-align: left !important;"><input type="checkbox" name="field_needed_all" id="field_needed_all" value="Y" onclick="checkAll(this,<? echo $intCountFields; ?>);"<? echo ($intCountChecked == $intCountFields ? ' checked' : ''); ?>> <?echo GetMessage("IBLOCK_ADM_EXP_IS_FIELD_NEEDED") ?></td> <td><?echo GetMessage("IBLOCK_ADM_EXP_FIELD_NAME") ?></td> <td><?echo GetMessage("IBLOCK_ADM_EXP_FIELD_SORT") ?></td> </tr><? for ($i = 0; $i < $intCountFields; $i++) { ?> <tr> <td style="text-align: left !important;"> <input type="checkbox" name="field_needed[<?echo $i ?>]" id="field_needed_<? echo $i; ?>"<?/if ($field_needed[$i]=="Y" \|\| strlen($strError)<=0) echo "checked"; / if (in_array($i,$arCheckID)) echo "checked"; ?> value="Y" onclick="checkOne(this,<? echo $intCountFields; ?>);"> </td> <td> <?if ($i < 2) echo "<b>";?> <?echo $arAvailFields[$i]["name"]?> <?if ($i < 2) echo "</b>";?> </td> <td align="center"> <?if ($i < 2) echo "<b>";?> <input type="text" name="field_num[<?echo $i ?>]" value="<?echo (is_array($field_num)?$field_num[$i]:(10($i+1))) ?>" size="2"> <input type="hidden" name="field_code[<?echo $i ?>]" value="<?echo $arAvailFields[$i]["value"] ?>"> <?if ($i < 2) echo "</b>";?> </td> </tr> <? } ?> </table> <input type="hidden" name="count_checked" id="count_checked" value="<? echo $intCountChecked; ?>"> <script type="text/javascript"> function checkAll(obj,cnt) { var boolCheck = obj.checked; for (i = 0; i < cnt; i++) { BX('field_needed_'+i).checked = boolCheck; } BX('count_checked').value = (boolCheck ? cnt : 0); } function checkOne(obj,cnt) { var boolCheck = obj.checked; var intCurrent = parseInt(BX('count_checked').value); intCurrent += (boolCheck ? 1 : -1); BX('field_needed_all').checked = (intCurrent < cnt ? false : true); BX('count_checked').value = intCurrent; } </script> <br><br> </td> </tr> <tr class="heading"> <td colspan="2"><?echo GetMessage("IBLOCK_ADM_EXP_FILE_NAME") ?></td> </tr> <tr> <td><?echo GetMessage("IBLOCK_ADM_EXP_ENTER_FILE_NAME") ?>:</td> <td> <input type="text" name="DATA_FILE_NAME" size="40" value="<?echo htmlspecialcharsbx(strlen($DATA_FILE_NAME) > 0? $DATA_FILE_NAME: "/".COption::GetOptionString("main", "upload_dir", "upload")."/export_file_".mt_rand(0, 999999).".csv")?>"><br> <small><?echo GetMessage("IBLOCK_ADM_EXP_FILE_WARNING") ?></small> </td> </tr> <? } $tabControl->EndTab(); if (!$bPublicMode) { $tabControl->BeginNextTab(); if ($STEP > 2) { ?> <tr> <td> <?echo CAdminMessage::ShowMessage(array( "TYPE" => "PROGRESS", "MESSAGE" => GetMessage("IBLOCK_ADM_EXP_SUCCESS"), "DETAILS" => GetMessage("IBLOCK_ADM_EXP_LINES_EXPORTED", array("#LINES#" => "<b>".intval($num_rows_writed)."</b>")).'<br>'.GetMessage("IBLOCK_ADM_EXP_DOWNLOAD_RESULT", array("#HREF#" => "<a href=\"".htmlspecialcharsbx($DATA_FILE_NAME)."\" target=\"_blank\">".htmlspecialcharsex($DATA_FILE_NAME)."</a>")), "HTML" => true, ))?> </td> </tr> <? } $tabControl->EndTab(); } if ($bPublicMode): $tabControl->Buttons(array()); else: $tabControl->Buttons(); if ($STEP < 3): if ($STEP > 1): ?> <input type="submit" name="backButton" value="<< <?echo GetMessage("IBLOCK_ADM_EXP_BACK_BUTTON") ?>"> <? endif; ?> <input type="submit" value="<?echo ($STEP==2)?GetMessage("IBLOCK_ADM_EXP_FINISH_BUTTON"):GetMessage("IBLOCK_ADM_EXP_NEXT_BUTTON") ?> >>" name="submit_btn" class="adm-btn-save"> <? else: ?> <input type="submit" name="backButton2" value="<< <?echo GetMessage("IBLOCK_ADM_EXP_RESTART_BUTTON") ?>" class="adm-btn-save"> <? endif; endif; $tabControl->End(); if (!$bPublicMode): ?> <script type="text/javaScript"> <!-- BX.ready(function() { <?if ($STEP < 2):?> tabControl.SelectTab("edit1"); tabControl.DisableTab("edit2"); tabControl.DisableTab("edit3"); <?elseif ($STEP == 2):?> tabControl.SelectTab("edit2"); tabControl.DisableTab("edit1"); tabControl.DisableTab("edit3"); <?elseif ($STEP > 2):?> tabControl.SelectTab("edit3"); tabControl.DisableTab("edit1"); tabControl.DisableTab("edit2"); <?endif;?> }); //--> </script> <? endif; ?> </form> <? require($DOCUMENT_ROOT."/bitrix/modules/main/include/epilog_admin.php"); ?>��themes/.default/webizi.csv.css��0000644��00000000576�15125205703�0012340 0��ustar�00��.wi-csv-ico { background: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAVCAMAAAB44J7gAAAAG1BMVEUAwRZBQTyT5K1U3IrK8tQDwTZcWFXu+vAV0W3w1M8bAAAAB3RSTlP9Av78+8ERJ3ENpQAAAFdJREFUGNO1jjEOAjAQw9xc2uT/L2YAIcoM3mLJUti82WetxQfjc4ta5xaxD1czM/yISTSJDC5A1FolMwFQAMVI1rN43ZykgCa25IgYoEVqNdDyJ/bXfAAoJwGWHC0OPwAAAABJRU5ErkJggg==) no-repeat center center; background-size: 16px 21px; }��classes/general/wi_csv.php��0000644��00000000563�15125205703�0011625 0��ustar�00��<? class WICSV { public static function GetEnumList($IBLOCK_ID) { $arrEnum = Array(); $db_enum_list = CIBlockPropertyEnum::GetList(Array(), Array("IBLOCK_ID" => intval($IBLOCK_ID))); while($ar_enum_list = $db_enum_list->GetNext(true, false)) { $arrEnum[$ar_enum_list["PROPERTY_ID"]][$ar_enum_list["ID"]] = $ar_enum_list["VALUE"]; } return $arrEnum; } } ?>��

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.24 | proxy | phpinfo | Settings