1: <?php
  2: /**
  3:  * PHPExcel
  4:  *
  5:  * Copyright (c) 2006 - 2014 PHPExcel
  6:  *
  7:  * This library is free software; you can redistribute it and/or
  8:  * modify it under the terms of the GNU Lesser General Public
  9:  * License as published by the Free Software Foundation; either
 10:  * version 2.1 of the License, or (at your option) any later version.
 11:  *
 12:  * This library is distributed in the hope that it will be useful,
 13:  * but WITHOUT ANY WARRANTY; without even the implied warranty of
 14:  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 15:  * Lesser General Public License for more details.
 16:  *
 17:  * You should have received a copy of the GNU Lesser General Public
 18:  * License along with this library; if not, write to the Free Software
 19:  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 20:  *
 21:  * @category   PHPExcel
 22:  * @package    PHPExcel_CachedObjectStorage
 23:  * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 24:  * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 25:  * @version    1.8.0, 2014-03-02
 26:  */
 27: 
 28: 
 29: /**
 30:  * PHPExcel_CachedObjectStorage_MemorySerialized
 31:  *
 32:  * @category   PHPExcel
 33:  * @package    PHPExcel_CachedObjectStorage
 34:  * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 35:  */
 36: class PHPExcel_CachedObjectStorage_MemorySerialized extends PHPExcel_CachedObjectStorage_CacheBase implements PHPExcel_CachedObjectStorage_ICache {
 37: 
 38:     /**
 39:      * Store cell data in cache for the current cell object if it's "dirty",
 40:      *     and the 'nullify' the current cell object
 41:      *
 42:      * @return  void
 43:      * @throws  PHPExcel_Exception
 44:      */
 45:     protected function _storeData() {
 46:         if ($this->_currentCellIsDirty && !empty($this->_currentObjectID)) {
 47:             $this->_currentObject->detach();
 48: 
 49:             $this->_cellCache[$this->_currentObjectID] = serialize($this->_currentObject);
 50:             $this->_currentCellIsDirty = false;
 51:         }
 52:         $this->_currentObjectID = $this->_currentObject = null;
 53:     }   //  function _storeData()
 54: 
 55: 
 56:     /**
 57:      * Add or Update a cell in cache identified by coordinate address
 58:      *
 59:      * @param   string          $pCoord     Coordinate address of the cell to update
 60:      * @param   PHPExcel_Cell   $cell       Cell to update
 61:      * @return  void
 62:      * @throws  PHPExcel_Exception
 63:      */
 64:     public function addCacheData($pCoord, PHPExcel_Cell $cell) {
 65:         if (($pCoord !== $this->_currentObjectID) && ($this->_currentObjectID !== null)) {
 66:             $this->_storeData();
 67:         }
 68: 
 69:         $this->_currentObjectID = $pCoord;
 70:         $this->_currentObject = $cell;
 71:         $this->_currentCellIsDirty = true;
 72: 
 73:         return $cell;
 74:     }   //  function addCacheData()
 75: 
 76: 
 77:     /**
 78:      * Get cell at a specific coordinate
 79:      *
 80:      * @param   string          $pCoord     Coordinate of the cell
 81:      * @throws  PHPExcel_Exception
 82:      * @return  PHPExcel_Cell   Cell that was found, or null if not found
 83:      */
 84:     public function getCacheData($pCoord) {
 85:         if ($pCoord === $this->_currentObjectID) {
 86:             return $this->_currentObject;
 87:         }
 88:         $this->_storeData();
 89: 
 90:         //  Check if the entry that has been requested actually exists
 91:         if (!isset($this->_cellCache[$pCoord])) {
 92:             //  Return null if requested entry doesn't exist in cache
 93:             return null;
 94:         }
 95: 
 96:         //  Set current entry to the requested entry
 97:         $this->_currentObjectID = $pCoord;
 98:         $this->_currentObject = unserialize($this->_cellCache[$pCoord]);
 99:         //    Re-attach this as the cell's parent
100:         $this->_currentObject->attach($this);
101: 
102:         //  Return requested entry
103:         return $this->_currentObject;
104:     }   //  function getCacheData()
105: 
106: 
107:     /**
108:      * Get a list of all cell addresses currently held in cache
109:      *
110:      * @return  array of string
111:      */
112:     public function getCellList() {
113:         if ($this->_currentObjectID !== null) {
114:             $this->_storeData();
115:         }
116: 
117:         return parent::getCellList();
118:     }
119: 
120: 
121:     /**
122:      * Clear the cell collection and disconnect from our parent
123:      *
124:      * @return  void
125:      */
126:     public function unsetWorksheetCells() {
127:         if(!is_null($this->_currentObject)) {
128:             $this->_currentObject->detach();
129:             $this->_currentObject = $this->_currentObjectID = null;
130:         }
131:         $this->_cellCache = array();
132: 
133:         //  detach ourself from the worksheet, so that it can then delete this object successfully
134:         $this->_parent = null;
135:     }   //  function unsetWorksheetCells()
136: 
137: }
138: