| Server IP : 37.220.80.31 / Your IP : 3.142.172.166 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/local/php_interface/lib/Excel/ |
Upload File : |
<?php
namespace LocalLib\Excel;
use Cache\Adapter\Memcache\MemcacheCachePool;
use Cache\Bridge\SimpleCache\SimpleCacheBridge;
use Exception;
use Memcache;
use PhpOffice\PhpSpreadsheet as PS;
abstract class BaseExcel {
/** @var PS\Spreadsheet */
protected $obSpreadsheet;
/** @var PS\Worksheet\Worksheet */
protected $obSheet;
public function __construct() {
$this->initMemcache();
$options = LIBXML_DTDATTR;
if (defined('LIBXML_DTDLOAD')) {
$options |= LIBXML_DTDLOAD;
}
if (defined('LIBXML_COMPACT')) {
$options |= LIBXML_COMPACT;
}
if (defined('LIBXML_BIGLINES')) {
$options |= LIBXML_BIGLINES;
}
if (defined('LIBXML_PARSEHUGE')) {
$options |= LIBXML_PARSEHUGE;
}
if (defined('LIBXML_HTML_NOIMPLIED')) {
$options |= LIBXML_HTML_NOIMPLIED;
}
if (defined('LIBXML_HTML_NODEFDTD')) {
$options |= LIBXML_HTML_NODEFDTD;
}
if (defined('LIBXML_NOBLANKS')) {
$options |= LIBXML_NOBLANKS;
}
PS\Settings::setLibXmlLoaderOptions($options);
PS\Shared\Date::setDefaultTimezone(date_default_timezone_get());
// MySQL-like timestamp '2008-12-31' or date string
PS\Cell\Cell::setValueBinder(new PS\Cell\AdvancedValueBinder());
}
private function initMemcache() {
if (!extension_loaded('memcache')) {
return;
}
try {
$client = new Memcache();
if (@$client->connect('localhost', 11211) === true) {
$pool = new MemcacheCachePool($client);
$simpleCache = new SimpleCacheBridge($pool);
PS\Settings::setCache($simpleCache);
}
} catch (Exception $e) {
}
}
public function getSheet() {
return $this->obSheet;
}
}