| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588 | 
							- <?php
 
- /**
 
-  *	PHPExcel
 
-  *
 
-  *	Copyright (c) 2006 - 2011 PHPExcel
 
-  *
 
-  *	This library is free software; you can redistribute it and/or
 
-  *	modify it under the terms of the GNU Lesser General Public
 
-  *	License as published by the Free Software Foundation; either
 
-  *	version 2.1 of the License, or (at your option) any later version.
 
-  *
 
-  *	This library is distributed in the hope that it will be useful,
 
-  *	but WITHOUT ANY WARRANTY; without even the implied warranty of
 
-  *	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 
-  *	Lesser General Public License for more details.
 
-  *
 
-  *	You should have received a copy of the GNU Lesser General Public
 
-  *	License along with this library; if not, write to the Free Software
 
-  *	Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 
-  *
 
-  *	@category	PHPExcel
 
-  *	@package	PHPExcel
 
-  *	@copyright	Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
 
-  *	@license	http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
 
-  *	@version	1.7.6, 2011-02-27
 
-  */
 
- /**
 
-  * PHPExcel_DocumentProperties
 
-  *
 
-  * @category	PHPExcel
 
-  * @package		PHPExcel
 
-  * @copyright	Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
 
-  */
 
- class PHPExcel_DocumentProperties
 
- {
 
- 	/** constants */
 
- 	const PROPERTY_TYPE_BOOLEAN		= 'b';
 
- 	const PROPERTY_TYPE_INTEGER		= 'i';
 
- 	const PROPERTY_TYPE_FLOAT		= 'f';
 
- 	const PROPERTY_TYPE_DATE		= 'd';
 
- 	const PROPERTY_TYPE_STRING		= 's';
 
- 	const PROPERTY_TYPE_UNKNOWN		= 'u';
 
- 	/**
 
- 	 * Creator
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_creator	= 'Unknown Creator';
 
- 	/**
 
- 	 * LastModifiedBy
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_lastModifiedBy;
 
- 	/**
 
- 	 * Created
 
- 	 *
 
- 	 * @var	datetime
 
- 	 */
 
- 	private $_created;
 
- 	/**
 
- 	 * Modified
 
- 	 *
 
- 	 * @var	datetime
 
- 	 */
 
- 	private $_modified;
 
- 	/**
 
- 	 * Title
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_title			= 'Untitled Spreadsheet';
 
- 	/**
 
- 	 * Description
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_description	= '';
 
- 	/**
 
- 	 * Subject
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_subject		= '';
 
- 	/**
 
- 	 * Keywords
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_keywords		= '';
 
- 	/**
 
- 	 * Category
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_category		= '';
 
- 	/**
 
- 	 * Manager
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_manager		= '';
 
- 	/**
 
- 	 * Company
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_company		= 'Microsoft Corporation';
 
- 	/**
 
- 	 * Custom Properties
 
- 	 *
 
- 	 * @var	string
 
- 	 */
 
- 	private $_customProperties	= array();
 
- 	/**
 
- 	 * Create a new PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function __construct()
 
- 	{
 
- 		// Initialise values
 
- 		$this->_lastModifiedBy	= $this->_creator;
 
- 		$this->_created		= time();
 
- 		$this->_modified	= time();
 
- 	}
 
- 	/**
 
- 	 * Get Creator
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getCreator() {
 
- 		return $this->_creator;
 
- 	}
 
- 	/**
 
- 	 * Set Creator
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setCreator($pValue = '') {
 
- 		$this->_creator = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Last Modified By
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getLastModifiedBy() {
 
- 		return $this->_lastModifiedBy;
 
- 	}
 
- 	/**
 
- 	 * Set Last Modified By
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setLastModifiedBy($pValue = '') {
 
- 		$this->_lastModifiedBy = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Created
 
- 	 *
 
- 	 * @return	datetime
 
- 	 */
 
- 	public function getCreated() {
 
- 		return $this->_created;
 
- 	}
 
- 	/**
 
- 	 * Set Created
 
- 	 *
 
- 	 * @param	datetime	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setCreated($pValue = null) {
 
- 		if (is_null($pValue)) {
 
- 			$pValue = time();
 
- 		} elseif (is_string($pValue)) {
 
- 			if (is_numeric($pValue)) {
 
- 				$pValue = intval($pValue);
 
- 			} else {
 
- 				$pValue = strtotime($pValue);
 
- 			}
 
- 		}
 
- 		$this->_created = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Modified
 
- 	 *
 
- 	 * @return	datetime
 
- 	 */
 
- 	public function getModified() {
 
- 		return $this->_modified;
 
- 	}
 
- 	/**
 
- 	 * Set Modified
 
- 	 *
 
- 	 * @param	datetime	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setModified($pValue = null) {
 
- 		if (is_null($pValue)) {
 
- 			$pValue = time();
 
- 		} elseif (is_string($pValue)) {
 
- 			if (is_numeric($pValue)) {
 
- 				$pValue = intval($pValue);
 
- 			} else {
 
- 				$pValue = strtotime($pValue);
 
- 			}
 
- 		}
 
- 		$this->_modified = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Title
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getTitle() {
 
- 		return $this->_title;
 
- 	}
 
- 	/**
 
- 	 * Set Title
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setTitle($pValue = '') {
 
- 		$this->_title = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Description
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getDescription() {
 
- 		return $this->_description;
 
- 	}
 
- 	/**
 
- 	 * Set Description
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setDescription($pValue = '') {
 
- 		$this->_description = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Subject
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getSubject() {
 
- 		return $this->_subject;
 
- 	}
 
- 	/**
 
- 	 * Set Subject
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setSubject($pValue = '') {
 
- 		$this->_subject = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Keywords
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getKeywords() {
 
- 		return $this->_keywords;
 
- 	}
 
- 	/**
 
- 	 * Set Keywords
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setKeywords($pValue = '') {
 
- 		$this->_keywords = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Category
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getCategory() {
 
- 		return $this->_category;
 
- 	}
 
- 	/**
 
- 	 * Set Category
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setCategory($pValue = '') {
 
- 		$this->_category = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Company
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getCompany() {
 
- 		return $this->_company;
 
- 	}
 
- 	/**
 
- 	 * Set Company
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setCompany($pValue = '') {
 
- 		$this->_company = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get Manager
 
- 	 *
 
- 	 * @return	string
 
- 	 */
 
- 	public function getManager() {
 
- 		return $this->_manager;
 
- 	}
 
- 	/**
 
- 	 * Set Manager
 
- 	 *
 
- 	 * @param	string	$pValue
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setManager($pValue = '') {
 
- 		$this->_manager = $pValue;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get a List of Custom Property Names
 
- 	 *
 
- 	 * @return	array of string
 
- 	 */
 
- 	public function getCustomProperties() {
 
- 		return array_keys($this->_customProperties);
 
- 	}
 
- 	/**
 
- 	 * Check if a Custom Property is defined
 
- 	 *
 
- 	 * @param	string	$propertyName
 
- 	 * @return	boolean
 
- 	 */
 
- 	public function isCustomPropertySet($propertyName) {
 
- 		return isset($this->_customProperties[$propertyName]);
 
- 	}
 
- 	/**
 
- 	 * Get a Custom Property Value
 
- 	 *
 
- 	 * @param	string	$propertyName
 
- 	 * @return	string
 
- 	 */
 
- 	public function getCustomPropertyValue($propertyName) {
 
- 		if (isset($this->_customProperties[$propertyName])) {
 
- 			return $this->_customProperties[$propertyName]['value'];
 
- 		}
 
- 	}
 
- 	/**
 
- 	 * Get a Custom Property Type
 
- 	 *
 
- 	 * @param	string	$propertyName
 
- 	 * @return	string
 
- 	 */
 
- 	public function getCustomPropertyType($propertyName) {
 
- 		if (isset($this->_customProperties[$propertyName])) {
 
- 			return $this->_customProperties[$propertyName]['type'];
 
- 		}
 
- 	}
 
- 	/**
 
- 	 * Set a Custom Property
 
- 	 *
 
- 	 * @param	string	$propertyName
 
- 	 * @param	mixed	$propertyValue
 
- 	 * @param	string	$propertyType
 
- 	 *						'i'	: Integer
 
- 	 *						'f' : Floating Point
 
- 	 *						's' : String
 
- 	 *						'd' : Date/Time
 
- 	 *						'b' : Boolean
 
- 	 * @return	PHPExcel_DocumentProperties
 
- 	 */
 
- 	public function setCustomProperty($propertyName,$propertyValue='',$propertyType=NULL) {
 
- 		if ((is_null($propertyType)) || (!in_array($propertyType,array(self::PROPERTY_TYPE_INTEGER,
 
- 																	   self::PROPERTY_TYPE_FLOAT,
 
- 																	   self::PROPERTY_TYPE_STRING,
 
- 																	   self::PROPERTY_TYPE_DATE,
 
- 																	   self::PROPERTY_TYPE_BOOLEAN)))) {
 
- 			if (is_null($propertyValue)) {
 
- 				$propertyType = self::PROPERTY_TYPE_STRING;
 
- 			} elseif (is_float($propertyValue)) {
 
- 				$propertyType = self::PROPERTY_TYPE_FLOAT;
 
- 			} elseif(is_int($propertyValue)) {
 
- 				$propertyType = self::PROPERTY_TYPE_INTEGER;
 
- 			} elseif (is_bool($propertyValue)) {
 
- 				$propertyType = self::PROPERTY_TYPE_BOOLEAN;
 
- 			} else {
 
- 				$propertyType = self::PROPERTY_TYPE_STRING;
 
- 			}
 
- 		}
 
- 		$this->_customProperties[$propertyName] = array('value' => $propertyValue, 'type' => $propertyType);
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Implement PHP __clone to create a deep clone, not just a shallow copy.
 
- 	 */
 
- 	public function __clone() {
 
- 		$vars = get_object_vars($this);
 
- 		foreach ($vars as $key => $value) {
 
- 			if (is_object($value)) {
 
- 				$this->$key = clone $value;
 
- 			} else {
 
- 				$this->$key = $value;
 
- 			}
 
- 		}
 
- 	}
 
- 	public static function convertProperty($propertyValue,$propertyType) {
 
- 		switch ($propertyType) {
 
- 			case 'empty'	:	//	Empty
 
- 				return '';
 
- 				break;
 
- 			case 'null'		:	//	Null
 
- 				return NULL;
 
- 				break;
 
- 			case 'i1'		:	//	1-Byte Signed Integer
 
- 			case 'i2'		:	//	2-Byte Signed Integer
 
- 			case 'i4'		:	//	4-Byte Signed Integer
 
- 			case 'i8'		:	//	8-Byte Signed Integer
 
- 			case 'int'		:	//	Integer
 
- 				return (int) $propertyValue;
 
- 				break;
 
- 			case 'ui1'		:	//	1-Byte Unsigned Integer
 
- 			case 'ui2'		:	//	2-Byte Unsigned Integer
 
- 			case 'ui4'		:	//	4-Byte Unsigned Integer
 
- 			case 'ui8'		:	//	8-Byte Unsigned Integer
 
- 			case 'uint'		:	//	Unsigned Integer
 
- 				return abs((int) $propertyValue);
 
- 				break;
 
- 			case 'r4'		:	//	4-Byte Real Number
 
- 			case 'r8'		:	//	8-Byte Real Number
 
- 			case 'decimal'	:	//	Decimal
 
- 				return (float) $propertyValue;
 
- 				break;
 
- 			case 'lpstr'	:	//	LPSTR
 
- 			case 'lpwstr'	:	//	LPWSTR
 
- 			case 'bstr'		:	//	Basic String
 
- 				return $propertyValue;
 
- 				break;
 
- 			case 'date'		:	//	Date and Time
 
- 			case 'filetime'	:	//	File Time
 
- 				return strtotime($propertyValue);
 
- 				break;
 
- 			case 'bool'		:	//	Boolean
 
- 				return ($propertyValue == 'true') ? True : False;
 
- 				break;
 
- 			case 'cy'		:	//	Currency
 
- 			case 'error'	:	//	Error Status Code
 
- 			case 'vector'	:	//	Vector
 
- 			case 'array'	:	//	Array
 
- 			case 'blob'		:	//	Binary Blob
 
- 			case 'oblob'	:	//	Binary Blob Object
 
- 			case 'stream'	:	//	Binary Stream
 
- 			case 'ostream'	:	//	Binary Stream Object
 
- 			case 'storage'	:	//	Binary Storage
 
- 			case 'ostorage'	:	//	Binary Storage Object
 
- 			case 'vstream'	:	//	Binary Versioned Stream
 
- 			case 'clsid'	:	//	Class ID
 
- 			case 'cf'		:	//	Clipboard Data
 
- 				return $propertyValue;
 
- 				break;
 
- 		}
 
- 		return $propertyValue;
 
- 	}
 
- 	public static function convertPropertyType($propertyType) {
 
- 		switch ($propertyType) {
 
- 			case 'i1'		:	//	1-Byte Signed Integer
 
- 			case 'i2'		:	//	2-Byte Signed Integer
 
- 			case 'i4'		:	//	4-Byte Signed Integer
 
- 			case 'i8'		:	//	8-Byte Signed Integer
 
- 			case 'int'		:	//	Integer
 
- 			case 'ui1'		:	//	1-Byte Unsigned Integer
 
- 			case 'ui2'		:	//	2-Byte Unsigned Integer
 
- 			case 'ui4'		:	//	4-Byte Unsigned Integer
 
- 			case 'ui8'		:	//	8-Byte Unsigned Integer
 
- 			case 'uint'		:	//	Unsigned Integer
 
- 				return self::PROPERTY_TYPE_INTEGER;
 
- 				break;
 
- 			case 'r4'		:	//	4-Byte Real Number
 
- 			case 'r8'		:	//	8-Byte Real Number
 
- 			case 'decimal'	:	//	Decimal
 
- 				return self::PROPERTY_TYPE_FLOAT;
 
- 				break;
 
- 			case 'empty'	:	//	Empty
 
- 			case 'null'		:	//	Null
 
- 			case 'lpstr'	:	//	LPSTR
 
- 			case 'lpwstr'	:	//	LPWSTR
 
- 			case 'bstr'		:	//	Basic String
 
- 				return self::PROPERTY_TYPE_STRING;
 
- 				break;
 
- 			case 'date'		:	//	Date and Time
 
- 			case 'filetime'	:	//	File Time
 
- 				return self::PROPERTY_TYPE_DATE;
 
- 				break;
 
- 			case 'bool'		:	//	Boolean
 
- 				return self::PROPERTY_TYPE_BOOLEAN;
 
- 				break;
 
- 			case 'cy'		:	//	Currency
 
- 			case 'error'	:	//	Error Status Code
 
- 			case 'vector'	:	//	Vector
 
- 			case 'array'	:	//	Array
 
- 			case 'blob'		:	//	Binary Blob
 
- 			case 'oblob'	:	//	Binary Blob Object
 
- 			case 'stream'	:	//	Binary Stream
 
- 			case 'ostream'	:	//	Binary Stream Object
 
- 			case 'storage'	:	//	Binary Storage
 
- 			case 'ostorage'	:	//	Binary Storage Object
 
- 			case 'vstream'	:	//	Binary Versioned Stream
 
- 			case 'clsid'	:	//	Class ID
 
- 			case 'cf'		:	//	Clipboard Data
 
- 				return self::PROPERTY_TYPE_UNKNOWN;
 
- 				break;
 
- 		}
 
- 		return self::PROPERTY_TYPE_UNKNOWN;
 
- 	}
 
- }
 
 
  |