| Server IP : 37.220.80.31 / Your IP : 3.143.203.146 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.importexportexcel/lib/ |
Upload File : |
<?php
namespace Bitrix\KdaImportexcel;
class IUtils
{
public static $moduleId = 'esol.importexportexcel';
public static $moduleSubDir = 'import/';
public static function GetCurUserID()
{
global $USER;
if($USER && is_callable(array($USER, 'GetID'))) return $USER->GetID();
else return 0;
}
public static function Trim($str)
{
$str = trim($str);
$str = preg_replace('/(^(\xC2\xA0|\s)+|(\xC2\xA0|\s)+$)/s', '', $str);
return $str;
}
public static function Translate($string, $langFrom, $langTo=false)
{
if(strlen(trim($string)) > 0 && ($apiKey = \Bitrix\Main\Config\Option::get('main', 'translate_key_yandex', '')))
{
if($langTo===false) $langTo = LANGUAGE_ID;
$client = new \Bitrix\Main\Web\HttpClient(array('socketTimeout'=>10, 'disableSslVerification'=>true));
$client->setHeader('Content-Type', 'application/xml');
$res = $client->get('https://translate.yandex.net/api/v1.5/tr.json/translate?key='.$apiKey.'&lang='.$langFrom.'-'.$langTo.'&text='.urlencode($string));
$arRes = \CUtil::JSObjectToPhp($res);
if(array_key_exists('code', $arRes) && $arRes['code']==200 && array_key_exists('text', $arRes))
{
$string = (is_array($arRes['text']) ? implode('', $arRes['text']) : $arRes['text']);
}
}
return $string;
}
public static function Str2Url($string, $arParams=array())
{
if(!is_array($arParams)) $arParams = array();
if(count($arParams)==0)
{
$arTransParams = \Bitrix\Main\Config\Option::get(static::$moduleId, 'TRANS_PARAMS', '');
if(is_string($arTransParams) && !empty($arTransParams)) $arTransParams = unserialize($arTransParams);
if(!is_array($arTransParams)) $arTransParams = array();
if(!empty($arTransParams))
{
$arTransParams['TRANSLITERATION'] = 'Y';
$arParams = $arTransParams;
}
}
if($arParams['TRANSLITERATION']=='Y')
{
if($arParams['USE_GOOGLE']=='Y' && strlen(trim($string)) > 0 && ($apiKey = \Bitrix\Main\Config\Option::get('main', 'translate_key_yandex', '')))
{
$client = new \Bitrix\Main\Web\HttpClient(array('socketTimeout'=>10, 'disableSslVerification'=>true));
$client->setHeader('Content-Type', 'application/xml');
$res = $client->get('https://translate.yandex.net/api/v1.5/tr.json/translate?key='.$apiKey.'&lang='.LANGUAGE_ID.'-en&text='.urlencode($string));
$arRes = \CUtil::JSObjectToPhp($res);
if(array_key_exists('code', $arRes) && $arRes['code']==200 && array_key_exists('text', $arRes))
{
$string = (is_array($arRes['text']) ? implode('', $arRes['text']) : $arRes['text']);
}
}
if(isset($arParams['TRANS_LEN'])) $arParams['max_len'] = $arParams['TRANS_LEN'];
if(isset($arParams['TRANS_CASE'])) $arParams['change_case'] = $arParams['TRANS_CASE'];
if(isset($arParams['TRANS_SPACE'])) $arParams['replace_space'] = $arParams['TRANS_SPACE'];
if(isset($arParams['TRANS_OTHER'])) $arParams['replace_other'] = $arParams['TRANS_OTHER'];
if(isset($arParams['TRANS_EAT']) && $arParams['TRANS_EAT']=='N') $arParams['delete_repeat_replace'] = false;
}
return \CUtil::translit($string, LANGUAGE_ID, $arParams);
}
public static function DownloadTextTextByLink($val, $altVal='')
{
$client = new \Bitrix\Main\Web\HttpClient(array('socketTimeout'=>10, 'disableSslVerification'=>true));
$path = (strlen(trim($altVal)) > 0 ? trim($altVal) : trim($val));
if(strlen($path)==0) return '';
$arUrl = parse_url($path);
$res = trim($client->get($path));
if($client->getStatus()==404) $res = '';
$hct = ToLower($client->getHeaders()->get('content-type'));
$siteEncoding = \CKDAImportUtils::getSiteEncoding();
if(strlen($res) > 0 && class_exists('\DOMDocument') && $arUrl['fragment'])
{
$res = self::GetHtmlDomVal($res, $arUrl['fragment']);
}
elseif(preg_match('/charset=(.+)(;|$)/Uis', $hct, $m))
{
$fileEncoding = ToLower(trim($m[1]));
if($siteEncoding!=$fileEncoding)
{
$res = \Bitrix\Main\Text\Encoding::convertEncoding($res, $fileEncoding, $siteEncoding);
}
}
else
{
if(\CUtil::DetectUTF8($res))
{
if($siteEncoding!='utf-8') $res = \Bitrix\Main\Text\Encoding::convertEncoding($res, 'utf-8', $siteEncoding);
}
elseif($siteEncoding=='utf-8') $res = \Bitrix\Main\Text\Encoding::convertEncoding($res, 'cp1251', $siteEncoding);
}
return $res;
}
public static function GetHtmlDomVal($html, $selector, $img=false, $multi=false)
{
$finalHtml = '';
if(strlen($html) > 0 && class_exists('\DOMDocument') && $selector)
{
if($multi && !$img) $multi = false;
/*Bom UTF-8*/
if(\CUtil::DetectUTF8(substr($html, 0, 10000)) && (substr($html, 0, 3)!="\xEF\xBB\xBF"))
{
$html = "\xEF\xBB\xBF".$html;
}
/*/Bom UTF-8*/
$doc = new \DOMDocument();
$doc->preserveWhiteSpace = false;
$doc->formatOutput = true;
$doc->loadHTML($html);
$node = $doc;
$arNodes = array();
$arParts = preg_split('/\s+/', $selector);
$i = 0;
while(isset($arParts[$i]) && ($node instanceOf \DOMDocument || $node instanceOf \DOMElement))
{
$part = $arParts[$i];
$tagName = (preg_match('/^([^#\.\[]+)([#\.\[].*$|$)/', $part, $m) ? $m[1] : '');
$tagId = (preg_match('/^[^#]*#([^#\.\[]+)([#\.\[].*$|$)/', $part, $m) ? $m[1] : '');
$arClasses = array_diff(explode('.', (preg_match('/^[^\.]*\.([^#\[]+)([#\.\[].*$|$)/', $part, $m) ? $m[1] : '')), array(''));
$arAttributes = array_map(array(__CLASS__, 'GetDomAttributes'), (preg_match_all('/\[([^\]]+(=[^\]])?)\]/', $part, $m) ? $m[1] : array()));
if($tagName)
{
$nodes = $node->getElementsByTagName($tagName);
if($tagId || !empty($arClasses) || !empty($arAttributes))
{
$find = false;
$key = 0;
while((!$find || $multi) && $key<$nodes->length)
{
$node1 = $nodes->item($key);
$subfind = true;
if($tagId && $node1->getAttribute('id')!=$tagId) $subfind = false;
foreach($arClasses as $className)
{
if($className && !preg_match('/(^|\s)'.preg_quote($className, '/').'(\s|$)/is', $node1->getAttribute('class'))) $subfind = false;
}
foreach($arAttributes as $arAttr)
{
if(!$node1->hasAttribute($arAttr['k']) || (strlen($arAttr['v']) > 0 && $node1->getAttribute($arAttr['k'])!=$arAttr['v'])) $subfind = false;
}
$find = $subfind;
if($multi && $subfind) $arNodes[] = $nodes->item($key);
if(!$find || $multi) $key++;
}
if($find && !$multi) $node = $nodes->item($key);
else $node = null;
}
else
{
$node = $nodes->item(0);
}
}
$i++;
}
if($img && $multi && count($arNodes) > 0)
{
$arLinks = array();
foreach($arNodes as $node)
{
if($node instanceOf \DOMElement)
{
$link = '';
if($node->hasAttribute('src')) $link = $node->getAttribute('src');
elseif($node->hasAttribute('href')) $link = $node->getAttribute('href');
$link = trim($link);
if(strlen($link) > 0) $arLinks[] = $link;
}
}
return $arLinks;
}
if($node instanceOf \DOMElement)
{
$innerHTML = '';
if($img)
{
if($node->hasAttribute('src')) $innerHTML = $node->getAttribute('src');
elseif($node->hasAttribute('href')) $innerHTML = $node->getAttribute('href');
}
else
{
$children = $node->childNodes;
foreach($children as $child)
{
$innerHTML .= $child->ownerDocument->saveHTML($child);
}
if(strlen($innerHTML)==0 && $node->nodeValue) $innerHTML = $node->nodeValue;
}
$finalHtml = trim($innerHTML);
}
else
{
$finalHtml = '';
}
$siteEncoding = \CKDAImportUtils::getSiteEncoding();
if($finalHtml && $siteEncoding!='utf-8')
{
$finalHtml = \Bitrix\Main\Text\Encoding::convertEncoding($res, 'utf-8', $siteEncoding);
}
}
return $finalHtml;
}
public static function DownloadImagesFromText($val, $domain='')
{
$domain = trim($domain);
$imgDir = '/upload/esol_images/';
$arPatterns = array(
'/<img[^>]*src=["\']([^"\']+)["\'][^>]*>/Uis',
'/<a\s[^>]*href=["\']([^"\']+\.(jpg|jpeg|png|gif|svg|webp|bmp|pdf)(\?[^"\']*)?)["\'][^>]*>/Uis',
);
foreach($arPatterns as $pattern)
{
if(preg_match_all($pattern, $val, $m))
{
foreach($m[1] as $k=>$img)
{
if(strpos($img, '//')===0) $img = (($pos = strpos($domain, '//'))!==false ? substr($domain, 0, $pos) : 'http:').$img;
elseif(strpos($img, '/')===0) $img = $domain.$img;
$imgName = md5($img).'.'.preg_replace('/[#\?].*$/', '', bx_basename(rawurldecode($img)));
$imgPathDir1 = $imgDir.substr($imgName, 0, 3).'/';
$imgPathDir = $_SERVER['DOCUMENT_ROOT'].$imgPathDir1;
$imgPath1 = $imgPathDir1.$imgName;
$imgPath = $imgPathDir.$imgName;
$realFile = \Bitrix\Main\IO\Path::convertLogicalToPhysical($imgPath);
if(!file_exists($realFile) || filesize($realFile)==0)
{
CheckDirPath($imgPathDir);
$ob = new \Bitrix\Main\Web\HttpClient(array('disableSslVerification'=>true, 'socketTimeout'=>15, 'streamTimeout'=>15));
$ob->setHeader('User-Agent', \CKDAImportUtils::GetUserAgent());
$ob->download($img, $imgPath);
}
$imgHtml = str_replace($m[1][$k], $imgPath1, $m[0][$k]);
$val = str_replace($m[0][$k], $imgHtml, $val);
}
}
}
return $val;
}
public static function GetDomAttributes($n)
{
list($k,$v)=explode("=", $n, 2);
return array("k"=>$k, "v"=>trim($v, " \"\'"));
}
}