123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587 |
- <?php
- /**
- * PHPExcel
- *
- * Copyright (c) 2006 - 2014 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 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
- * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
- * @version 1.8.0, 2014-03-02
- */
- /**
- * PHPExcel_DocumentProperties
- *
- * @category PHPExcel
- * @package PHPExcel
- * @copyright Copyright (c) 2006 - 2014 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 ($pValue === NULL) {
- $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 ($pValue === NULL) {
- $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 (($propertyType === NULL) || (!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 ($propertyValue === NULL) {
- $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;
- }
- }
|