PHP PHPExcel_CachedObjectStorage_CacheBase类代码示例

 public function copyCellCollection(PHPExcel_Worksheet $parent)
 {
     parent::copyCellCollection($parent);
     $newCollection = array();
     foreach ($this->_cellCache as $k => &$cell) {
         $newCollection[$k] = clone $cell;
         $newCollection[$k]->attach($parent);
     }
     $this->_cellCache = $newCollection;
 }

 /**
  * Initialise this new cell collection
  *
  * @param    PHPExcel_Worksheet $parent The worksheet for this cell collection
  */
 public function __construct(PHPExcel_Worksheet $parent)
 {
     parent::__construct($parent);
     if (is_null($this->_DBHandle)) {
         $this->_TableName = str_replace('.', '_', $this->_getUniqueID());
         $_DBName = ':memory:';
         $this->_DBHandle = new SQLiteDatabase($_DBName);
         if ($this->_DBHandle === false) {
             throw new PHPExcel_Exception(sqlite_error_string($this->_DBHandle->lastError()));
         }
         if (!$this->_DBHandle->queryExec('CREATE TABLE kvp_' . $this->_TableName . ' (id VARCHAR(12) PRIMARY KEY, value BLOB)')) {
             throw new PHPExcel_Exception(sqlite_error_string($this->_DBHandle->lastError()));
         }
     }
 }

 /**
  * Initialise this new cell collection
  *
  * @param    PHPExcel_Worksheet $parent The worksheet for this cell collection
  */
 public function __construct(PHPExcel_Worksheet $parent)
 {
     parent::__construct($parent);
     if (is_null($this->_DBHandle)) {
         $this->_TableName = str_replace('.', '_', $this->_getUniqueID());
         $_DBName = ':memory:';
         $this->_DBHandle = new SQLite3($_DBName);
         if ($this->_DBHandle === false) {
             throw new PHPExcel_Exception($this->_DBHandle->lastErrorMsg());
         }
         if (!$this->_DBHandle->exec('CREATE TABLE kvp_' . $this->_TableName . ' (id VARCHAR(12) PRIMARY KEY, value BLOB)')) {
             throw new PHPExcel_Exception($this->_DBHandle->lastErrorMsg());
         }
     }
     $this->_selectQuery = $this->_DBHandle->prepare("SELECT value FROM kvp_" . $this->_TableName . " WHERE id = :id");
     $this->_insertQuery = $this->_DBHandle->prepare("INSERT OR REPLACE INTO kvp_" . $this->_TableName . " VALUES(:id,:data)");
     $this->_updateQuery = $this->_DBHandle->prepare("UPDATE kvp_" . $this->_TableName . " SET id=:toId WHERE id=:fromId");
     $this->_deleteQuery = $this->_DBHandle->prepare("DELETE FROM kvp_" . $this->_TableName . " WHERE id = :id");
 }

 /**
  * Initialise this new cell collection
  *
  * @param PHPExcel_Worksheet $parent    The worksheet for this cell collection
  * @param array of mixed     $arguments Additional initialisation arguments
  */
 public function __construct(PHPExcel_Worksheet $parent, $arguments)
 {
     $cacheTime = isset($arguments['cacheTime']) ? $arguments['cacheTime'] : 600;
     if (is_null($this->cachePrefix)) {
         $baseUnique = $this->getUniqueID();
         $this->cachePrefix = substr(md5($baseUnique), 0, 8) . '.';
         $this->cacheTime = $cacheTime;
         parent::__construct($parent);
     }
 }

 /**
  * Clone the cell collection
  *
  * @param    PHPExcel_Worksheet $parent The new worksheet
  *
  * @return    void
  */
 public function copyCellCollection(PHPExcel_Worksheet $parent)
 {
     parent::copyCellCollection($parent);
     //	Open a new stream for the cell cache data
     $newFileHandle = fopen('php://temp/maxmemory:' . $this->_memoryCacheSize, 'a+');
     //	Copy the existing cell cache data to the new stream
     fseek($this->_fileHandle, 0);
     while (!feof($this->_fileHandle)) {
         fwrite($newFileHandle, fread($this->_fileHandle, 1024));
     }
     $this->_fileHandle = $newFileHandle;
 }

 /**
  * Initialise this new cell collection
  *
  * @param	PHPExcel_Worksheet	$parent		The worksheet for this cell collection
  * @param	array of mixed		$arguments	Additional initialisation arguments
  */
 public function __construct(PHPExcel_Worksheet $parent, $arguments)
 {
     $this->_memoryCacheSize = isset($arguments['memoryCacheSize']) ? $arguments['memoryCacheSize'] : '1MB';
     parent::__construct($parent);
     if (is_null($this->_fileHandle)) {
         $this->_fileHandle = fopen('php://temp/maxmemory:' . $this->_memoryCacheSize, 'a+');
     }
 }

 /**
  * Get a list of all cell addresses currently held in cache
  *
  * @return  array of string
  */
 public function getCellList()
 {
     if ($this->_currentObjectID !== null) {
         $this->_storeData();
     }
     return parent::getCellList();
 }

 /**
  * Initialise this new cell collection
  *
  * @param    PHPExcel_Worksheet    $parent        The worksheet for this cell collection
  * @param    array of mixed        $arguments    Additional initialisation arguments
  */
 public function __construct(PHPExcel_Worksheet $parent, $arguments)
 {
     $this->_cacheDirectory = isset($arguments['dir']) && $arguments['dir'] !== NULL ? $arguments['dir'] : PHPExcel_Shared_File::sys_get_temp_dir();
     parent::__construct($parent);
     if (is_null($this->_fileHandle)) {
         $baseUnique = $this->_getUniqueID();
         $this->_fileName = $this->_cacheDirectory . '/PHPExcel.' . $baseUnique . '.cache';
         $this->_fileHandle = fopen($this->_fileName, 'a+');
     }
 }

 /**
  * Clone the cell collection
  *
  * @param    PHPExcel_Worksheet $parent The new worksheet
  *
  * @return    void
  */
 public function copyCellCollection(PHPExcel_Worksheet $parent)
 {
     parent::copyCellCollection($parent);
     //	Get a new id for the new file name
     $baseUnique = $this->_getUniqueID();
     $newFileName = $this->_cacheDirectory . '/PHPExcel.' . $baseUnique . '.cache';
     //	Copy the existing cell cache file
     copy($this->_fileName, $newFileName);
     $this->_fileName = $newFileName;
     //	Open the copied cell cache file
     $this->_fileHandle = fopen($this->_fileName, 'a+');
 }

 /**
  *	Get parent worksheet
  *
  *	@return PHPExcel_Worksheet
  */
 public function getWorksheet()
 {
     return $this->_parent->getParent();
 }

 public function __construct(PHPExcel_Worksheet $parent)
 {
     parent::__construct($parent);
     if (is_null($this->_fileHandle)) {
         if (function_exists('posix_getpid')) {
             $baseUnique = posix_getpid();
         } else {
             $baseUnique = mt_rand();
         }
         $this->_fileName = sys_get_temp_dir() . '/PHPExcel.' . uniqid($baseUnique, true) . '.cache';
         $this->_fileHandle = fopen($this->_fileName, 'a+');
     }
 }

 /**
  * Clone the cell collection
  *
  * @param    PHPExcel_Worksheet $parent The new worksheet
  *
  * @return    void
  */
 public function copyCellCollection(PHPExcel_Worksheet $parent)
 {
     parent::copyCellCollection($parent);
     //	Get a new id for the new file name
     $baseUnique = $this->_getUniqueID();
     $newCachePrefix = substr(md5($baseUnique), 0, 8) . '.';
     $cacheList = $this->getCellList();
     foreach ($cacheList as $cellID) {
         if ($cellID != $this->_currentObjectID) {
             $obj = $this->_memcache->get($this->_cachePrefix . $cellID . '.cache');
             if ($obj === false) {
                 //	Entry no longer exists in Memcache, so clear it from the cache array
                 parent::deleteCacheData($cellID);
                 throw new PHPExcel_Exception('Cell entry ' . $cellID . ' no longer exists in MemCache');
             }
             if (!$this->_memcache->add($newCachePrefix . $cellID . '.cache', $obj, null, $this->_cacheTime)) {
                 $this->__destruct();
                 throw new PHPExcel_Exception('Failed to store cell ' . $cellID . ' in MemCache');
             }
         }
     }
     $this->_cachePrefix = $newCachePrefix;
 }

 public function __construct(PHPExcel_Worksheet $parent, $arguments)
 {
     $cacheTime = isset($arguments['cacheTime']) ? $arguments['cacheTime'] : 600;
     if (is_null($this->_cachePrefix)) {
         if (function_exists('posix_getpid')) {
             $baseUnique = posix_getpid();
         } else {
             $baseUnique = mt_rand();
         }
         $this->_cachePrefix = substr(md5(uniqid($baseUnique, true)), 0, 8) . '.';
         $this->_cacheTime = $cacheTime;
         parent::__construct($parent);
     }
 }

 public function __construct(PHPExcel_Worksheet $parent, $arguments)
 {
     $memcacheServer = isset($arguments['memcacheServer']) ? $arguments['memcacheServer'] : 'localhost';
     $memcachePort = isset($arguments['memcachePort']) ? $arguments['memcachePort'] : 11211;
     $cacheTime = isset($arguments['cacheTime']) ? $arguments['cacheTime'] : 600;
     if (is_null($this->_cachePrefix)) {
         if (function_exists('posix_getpid')) {
             $baseUnique = posix_getpid();
         } else {
             $baseUnique = mt_rand();
         }
         $this->_cachePrefix = substr(md5(uniqid($baseUnique, true)), 0, 8) . '.';
         //	Set a new Memcache object and connect to the Memcache server
         $this->_memcache = new Memcache();
         if (!$this->_memcache->connect($memcacheServer, $memcachePort)) {
             throw new Exception('Could not connect to Memcache server at ' . $memcacheServer . ':' . $memcachePort);
         }
         $this->_cacheTime = $cacheTime;
         parent::__construct($parent);
     }
 }

 /**
  * Initialise this new cell collection
  *
  * @param	PHPExcel_Worksheet	$parent		The worksheet for this cell collection
  * @param	array of mixed		$arguments	Additional initialisation arguments
  */
 public function __construct(PHPExcel_Worksheet $parent, $arguments)
 {
     $this->_cacheDirectory = isset($arguments['dir']) && $arguments['dir'] !== NULL ? $arguments['dir'] : LEAFLET_PLUGIN_ICONS_DIR;
     parent::__construct($parent);
     if (is_null($this->_fileHandle)) {
         $baseUnique = $this->_getUniqueID();
         $this->_fileName = $this->_cacheDirectory . '/PHPExcel.' . $baseUnique . '.cache';
         $this->_fileHandle = fopen($this->_fileName, 'a+');
     }
 }