| Server IP : 37.220.80.31 / Your IP : 3.144.25.133 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/esol.allimportexport/lib/export/ |
Upload File : |
<?php
namespace Bitrix\EsolAie\Export;
use Bitrix\Main\Loader;
use Bitrix\Main\Localization\Loc;
Loc::loadMessages(__FILE__);
class WriterCsv {
private $_lineEnding = PHP_EOL;
private $_delimiter = ',';
private $_enclosure = '"';
private $_useBOM = false;
private $_encoding = 'UTF-8';
private $_yandexAdapt = false;
private $fields = 0;
private $totalCols = 0;
private $maxColumn = 0;
private $curRow = 0;
private $arListIndexes = array();
private $dirPath = '';
private $outputFile = '';
private $tmpFile = '';
private $titles = array();
private $ee = false;
function __construct($arParams = array(), $ee = false)
{
$this->dirPath = $arParams['TMPDIR'];
$this->outputFile = $arParams['OUTPUTFILE'];
$this->arListIndexes = $arParams['LIST_INDEXES'];
$this->arFparams = $arParams['EXTRAPARAMS'];
$this->params = $arParams['PARAMS'];
$this->arTitles = $arParams['PARAMS']['FIELDS_LIST_NAMES'];
$this->arListTitle = $arParams['PARAMS']['LIST_NAME'];
$this->arTextRowsTop = $arParams['PARAMS']['TEXT_ROWS_TOP'];
$this->arTextRowsTop2 = $arParams['PARAMS']['TEXT_ROWS_TOP2'];
$this->arHideColumnTitles = $arParams['PARAMS']['HIDE_COLUMN_TITLES'];
$this->SetEObject($ee);
foreach($this->arListIndexes as $indexKey=>$listIndex)
{
$arFields = $this->fields = $this->ee->GetFieldList($listIndex);
$cols = count($arFields);
$this->maxColumn = max($this->maxColumn, $cols);
}
if($arParams['PARAMS']['CSV_SEPARATOR']) $this->SetDelimiter($arParams['PARAMS']['CSV_SEPARATOR']);
if($arParams['PARAMS']['CSV_ENCODING']) $this->SetEncoding($arParams['PARAMS']['CSV_ENCODING']);
if(isset($arParams['PARAMS']['CSV_ENCLOSURE'])) $this->SetEnclosure($arParams['PARAMS']['CSV_ENCLOSURE']);
if($arParams['PARAMS']['CSV_YANDEX']=='Y') $this->SetYandexAdapt(true);
if($this->GetEncoding()=='UTF-8') $this->SetUseBOM(true);
}
public function SetEObject($ee)
{
$this->ee = $ee;
if(!is_object($this->ee))
{
$this->ee = new Exporter();
}
}
public function Save()
{
$this->openExcelWriter();
foreach($this->arListIndexes as $indexKey=>$listIndex)
{
if(isset($this->currentListIndexKey) && $this->currentListIndexKey > $indexKey)
{
continue;
}
$this->openWorkSheet($listIndex);
$arFields = $this->fields;
$fieldsCount = $this->totalCols = count($arFields);
$handle = fopen($this->tmpFile, 'r');
if(isset($this->currentListIndexKey) && $this->currentListIndexKey == $indexKey && isset($this->currentFilePosition))
{
fseek($handle, $this->currentFilePosition);
}
else
{
$this->AddTextRows($this->textRowsTop);
if($this->hideColumnTitles!='Y')
{
$arLine = array();
foreach($arFields as $k=>$field)
{
$val = $this->GetCellValue($this->titles[$k]);
$arLine[] = $val;
}
$this->WriteLine($arLine);
}
$this->AddTextRows($this->textRowsTop2);
}
while(!feof($handle))
{
$buffer = trim(fgets($handle));
if(strlen($buffer) < 1) continue;
$arElement = unserialize(base64_decode($buffer));
if(empty($arElement)) continue;
if(isset($arElement['RTYPE']) && ($arElement['RTYPE']=='SECTION_PATH' || preg_match('/^SECTION_(\d+)$/', $arElement['RTYPE'], $m)))
{
$val = $this->GetCellValue($arElement['NAME']);
$arLine = array($val);
$this->WriteLine($arLine);
}
else
{
$arLine = array();
foreach($arFields as $k=>$field)
{
$val = $this->GetCellValue((array_key_exists($field.'_'.$k, $arElement) ? $arElement[$field.'_'.$k] : $arElement[$field]));
$arLine[] = $val;
}
$this->WriteLine($arLine);
}
if($this->ee->CheckTimeEnding())
{
$this->currentListIndexKey = $indexKey;
$this->currentFilePosition = ftell($handle);
unset($this->ee);
fclose($handle);
$this->closeExcelWriter(true);
return false;
}
}
fclose($handle);
}
$this->closeExcelWriter();
}
public function openExcelWriter()
{
if($this->curRow > 0)
{
$this->csvHandler = fopen($this->outputFile, 'a+');
return;
}
if(file_exists($this->outputFile)) unlink($this->outputFile);
$this->csvHandler = fopen($this->outputFile, 'a+');
if($this->_useBOM) {
fwrite($this->csvHandler, "\xEF\xBB\xBF");
}
}
public function openWorkSheet($listIndex)
{
$this->titles = $this->arTitles[$listIndex];
$this->listTitle = $this->arListTitle[$listIndex];
$this->textRowsTop = $this->arTextRowsTop[$listIndex];
$this->textRowsTop2 = $this->arTextRowsTop2[$listIndex];
$this->fparams = $this->arFparams[$listIndex];
$this->hideColumnTitles = $this->arHideColumnTitles[$listIndex];
$this->tmpFile = $this->dirPath.'data_'.$listIndex.'.txt';
$arFields = $this->fields = $this->ee->GetFieldList($listIndex);
$sheetId = array_search($listIndex, $this->arListIndexes);
if($sheetId==false) $sheetId = 1;
else $sheetId++;
$this->sheetId = $sheetId;
}
private function WriteLine($pValues = null) {
if(!is_array($pValues)) return;
while(count($pValues) < $this->maxColumn) $pValues[] = '';
if(count($pValues) > $this->maxColumn) $pValues = array_slice($pValues, 0, $this->maxColumn);
$writeDelimiter = false;
$line = '';
foreach ($pValues as $element) {
$element = str_replace($this->_enclosure, $this->_enclosure . $this->_enclosure, $element);
if($this->_enclosure == '' || $this->_yandexAdapt)
{
$element = preg_replace("/\s+/s", ' ', $element);
}
if($this->_enclosure == '') $element = str_replace($this->_delimiter, '', $element);
if ($writeDelimiter) $line .= $this->_delimiter;
else $writeDelimiter = true;
if($this->_yandexAdapt && preg_match('/^[\d\w_\-,;. ]*$/', $element))
{
$line .= $element;
}
else
{
$line .= $this->_enclosure . $element . $this->_enclosure;
}
}
$line .= $this->_lineEnding;
fwrite($this->csvHandler, $line);
$this->curRow++;
}
public function GetEncoding()
{
return $this->_encoding;
}
public function SetEncoding($encoding)
{
$this->_encoding = $encoding;
}
public function SetDelimiter($pValue = ',') {
if($pValue=='\t') $pValue = "\t";
$this->_delimiter = $pValue;
return $this;
}
public function SetEnclosure($pValue = '"') {
if ($pValue == '') {
$pValue = null;
}
$this->_enclosure = $pValue;
}
public function SetLineEnding($pValue = PHP_EOL) {
$this->_lineEnding = $pValue;
}
public function SetUseBOM($pValue = false) {
$this->_useBOM = $pValue;
}
public function SetYandexAdapt($pValue = false) {
$this->_yandexAdapt = $pValue;
}
public function AddTextRows($textRows)
{
if(!empty($textRows))
{
foreach($textRows as $k=>$v)
{
$val = $this->GetCellValue($v);
$arLine = array($val);
$this->WriteLine($arLine);
}
}
}
public function closeExcelWriter($break = false)
{
fclose($this->csvHandler);
}
public function GetCellValue($val)
{
if($this->GetEncoding()=='CP1251')
{
if(defined('BX_UTF') && BX_UTF)
{
$val = $GLOBALS['APPLICATION']->ConvertCharset($val, 'UTF-8', 'CP1251');
}
}
elseif(!defined('BX_UTF') || !BX_UTF)
{
$val = $GLOBALS['APPLICATION']->ConvertCharset($val, 'CP1251', 'UTF-8');
}
return $val;
}
}
?>