123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611 |
- <?php
- class PHPExcel_DocumentProperties
- {
-
- 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';
-
- private $creator = 'Unknown Creator';
-
- private $lastModifiedBy;
-
- private $created;
-
- private $modified;
-
- private $title = 'Untitled Spreadsheet';
-
- private $description = '';
-
- private $subject = '';
-
- private $keywords = '';
-
- private $category = '';
-
- private $manager = '';
-
- private $company = 'Microsoft Corporation';
-
- private $customProperties = array();
-
- public function __construct()
- {
-
- $this->lastModifiedBy = $this->creator;
- $this->created = time();
- $this->modified = time();
- }
-
- public function getCreator()
- {
- return $this->creator;
- }
-
- public function setCreator($pValue = '')
- {
- $this->creator = $pValue;
- return $this;
- }
-
- public function getLastModifiedBy()
- {
- return $this->lastModifiedBy;
- }
-
- public function setLastModifiedBy($pValue = '')
- {
- $this->lastModifiedBy = $pValue;
- return $this;
- }
-
- public function getCreated()
- {
- return $this->created;
- }
-
- 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;
- }
-
- public function getModified()
- {
- return $this->modified;
- }
-
- 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;
- }
-
- public function getTitle()
- {
- return $this->title;
- }
-
- public function setTitle($pValue = '')
- {
- $this->title = $pValue;
- return $this;
- }
-
- public function getDescription()
- {
- return $this->description;
- }
-
- public function setDescription($pValue = '')
- {
- $this->description = $pValue;
- return $this;
- }
-
- public function getSubject()
- {
- return $this->subject;
- }
-
- public function setSubject($pValue = '')
- {
- $this->subject = $pValue;
- return $this;
- }
-
- public function getKeywords()
- {
- return $this->keywords;
- }
-
- public function setKeywords($pValue = '')
- {
- $this->keywords = $pValue;
- return $this;
- }
-
- public function getCategory()
- {
- return $this->category;
- }
-
- public function setCategory($pValue = '')
- {
- $this->category = $pValue;
- return $this;
- }
-
- public function getCompany()
- {
- return $this->company;
- }
-
- public function setCompany($pValue = '')
- {
- $this->company = $pValue;
- return $this;
- }
-
- public function getManager()
- {
- return $this->manager;
- }
-
- public function setManager($pValue = '')
- {
- $this->manager = $pValue;
- return $this;
- }
-
- public function getCustomProperties()
- {
- return array_keys($this->customProperties);
- }
-
- public function isCustomPropertySet($propertyName)
- {
- return isset($this->customProperties[$propertyName]);
- }
-
- public function getCustomPropertyValue($propertyName)
- {
- if (isset($this->customProperties[$propertyName])) {
- return $this->customProperties[$propertyName]['value'];
- }
- }
-
- public function getCustomPropertyType($propertyName)
- {
- if (isset($this->customProperties[$propertyName])) {
- return $this->customProperties[$propertyName]['type'];
- }
- }
-
- 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;
- }
-
- 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':
- return '';
- break;
- case 'null':
- return null;
- break;
- case 'i1':
- case 'i2':
- case 'i4':
- case 'i8':
- case 'int':
- return (int) $propertyValue;
- break;
- case 'ui1':
- case 'ui2':
- case 'ui4':
- case 'ui8':
- case 'uint':
- return abs((int) $propertyValue);
- break;
- case 'r4':
- case 'r8':
- case 'decimal':
- return (float) $propertyValue;
- break;
- case 'lpstr':
- case 'lpwstr':
- case 'bstr':
- return $propertyValue;
- break;
- case 'date':
- case 'filetime':
- return strtotime($propertyValue);
- break;
- case 'bool':
- return ($propertyValue == 'true') ? true : false;
- break;
- case 'cy':
- case 'error':
- case 'vector':
- case 'array':
- case 'blob':
- case 'oblob':
- case 'stream':
- case 'ostream':
- case 'storage':
- case 'ostorage':
- case 'vstream':
- case 'clsid':
- case 'cf':
- return $propertyValue;
- break;
- }
- return $propertyValue;
- }
- public static function convertPropertyType($propertyType)
- {
- switch ($propertyType) {
- case 'i1':
- case 'i2':
- case 'i4':
- case 'i8':
- case 'int':
- case 'ui1':
- case 'ui2':
- case 'ui4':
- case 'ui8':
- case 'uint':
- return self::PROPERTY_TYPE_INTEGER;
- break;
- case 'r4':
- case 'r8':
- case 'decimal':
- return self::PROPERTY_TYPE_FLOAT;
- break;
- case 'empty':
- case 'null':
- case 'lpstr':
- case 'lpwstr':
- case 'bstr':
- return self::PROPERTY_TYPE_STRING;
- break;
- case 'date':
- case 'filetime':
- return self::PROPERTY_TYPE_DATE;
- break;
- case 'bool':
- return self::PROPERTY_TYPE_BOOLEAN;
- break;
- case 'cy':
- case 'error':
- case 'vector':
- case 'array':
- case 'blob':
- case 'oblob':
- case 'stream':
- case 'ostream':
- case 'storage':
- case 'ostorage':
- case 'vstream':
- case 'clsid':
- case 'cf':
- return self::PROPERTY_TYPE_UNKNOWN;
- break;
- }
- return self::PROPERTY_TYPE_UNKNOWN;
- }
- }
|