--- /dev/null
+<?php
+/**
+ * Zend Framework
+ *
+ * LICENSE
+ *
+ * This source file is subject to the new BSD license that is bundled
+ * with this package in the file LICENSE.txt.
+ * It is also available through the world-wide-web at this URL:
+ * http://framework.zend.com/license/new-bsd
+ * If you did not receive a copy of the license and are unable to
+ * obtain it through the world-wide-web, please send an email
+ * to license@zend.com so we can send you a copy immediately.
+ *
+ * @category Zend
+ * @package Zend_Search_Lucene
+ * @subpackage Document
+ * @copyright Copyright (c) 2005-2009 Zend Technologies USA Inc. (http://www.zend.com)
+ * @license http://framework.zend.com/license/new-bsd New BSD License
+ * @version $Id: Xlsx.php 16971 2009-07-22 18:05:45Z mikaelkael $
+ */
+
+
+/** Zend_Search_Lucene_Document_OpenXml */
+require_once 'Zend/Search/Lucene/Document/OpenXml.php';
+
+if (class_exists('ZipArchive', false)) {
+
+/**
+ * Xlsx document.
+ *
+ * @category Zend
+ * @package Zend_Search_Lucene
+ * @subpackage Document
+ * @copyright Copyright (c) 2005-2009 Zend Technologies USA Inc. (http://www.zend.com)
+ * @license http://framework.zend.com/license/new-bsd New BSD License
+ */
+class Zend_Search_Lucene_Document_Xlsx extends Zend_Search_Lucene_Document_OpenXml
+{
+ /**
+ * Xml Schema - SpreadsheetML
+ *
+ * @var string
+ */
+ const SCHEMA_SPREADSHEETML = 'http://schemas.openxmlformats.org/spreadsheetml/2006/main';
+
+ /**
+ * Xml Schema - DrawingML
+ *
+ * @var string
+ */
+ const SCHEMA_DRAWINGML = 'http://schemas.openxmlformats.org/drawingml/2006/main';
+
+ /**
+ * Xml Schema - Shared Strings
+ *
+ * @var string
+ */
+ const SCHEMA_SHAREDSTRINGS = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings';
+
+ /**
+ * Xml Schema - Worksheet relation
+ *
+ * @var string
+ */
+ const SCHEMA_WORKSHEETRELATION = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet';
+
+ /**
+ * Xml Schema - Slide notes relation
+ *
+ * @var string
+ */
+ const SCHEMA_SLIDENOTESRELATION = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/notesSlide';
+
+ /**
+ * Object constructor
+ *
+ * @param string $fileName
+ * @param boolean $storeContent
+ */
+ private function __construct($fileName, $storeContent)
+ {
+ // Document data holders
+ $sharedStrings = array();
+ $worksheets = array();
+ $documentBody = array();
+ $coreProperties = array();
+
+ // Open OpenXML package
+ $package = new ZipArchive();
+ $package->open($fileName);
+
+ // Read relations and search for officeDocument
+ $relations = simplexml_load_string($package->getFromName("_rels/.rels"));
+ foreach ($relations->Relationship as $rel) {
+ if ($rel["Type"] == Zend_Search_Lucene_Document_OpenXml::SCHEMA_OFFICEDOCUMENT) {
+ // Found office document! Read relations for workbook...
+ $workbookRelations = simplexml_load_string($package->getFromName( $this->absoluteZipPath(dirname($rel["Target"]) . "/_rels/" . basename($rel["Target"]) . ".rels")) );
+ $workbookRelations->registerXPathNamespace("rel", Zend_Search_Lucene_Document_OpenXml::SCHEMA_RELATIONSHIP);
+
+ // Read shared strings
+ $sharedStringsPath = $workbookRelations->xpath("rel:Relationship[@Type='" . Zend_Search_Lucene_Document_Xlsx::SCHEMA_SHAREDSTRINGS . "']");
+ $sharedStringsPath = (string)$sharedStringsPath[0]['Target'];
+ $xmlStrings = simplexml_load_string($package->getFromName( $this->absoluteZipPath(dirname($rel["Target"]) . "/" . $sharedStringsPath)) );
+ if (isset($xmlStrings) && isset($xmlStrings->si)) {
+ foreach ($xmlStrings->si as $val) {
+ if (isset($val->t)) {
+ $sharedStrings[] = (string)$val->t;
+ } elseif (isset($val->r)) {
+ $sharedStrings[] = $this->_parseRichText($val);
+ }
+ }
+ }
+
+ // Loop relations for workbook and extract worksheets...
+ foreach ($workbookRelations->Relationship as $workbookRelation) {
+ if ($workbookRelation["Type"] == Zend_Search_Lucene_Document_Xlsx::SCHEMA_WORKSHEETRELATION) {
+ $worksheets[ str_replace( 'rId', '', (string)$workbookRelation["Id"]) ] = simplexml_load_string(
+ $package->getFromName( $this->absoluteZipPath(dirname($rel["Target"]) . "/" . dirname($workbookRelation["Target"]) . "/" . basename($workbookRelation["Target"])) )
+ );
+ }
+ }
+
+ break;
+ }
+ }
+
+ // Sort worksheets
+ ksort($worksheets);
+
+ // Extract contents from worksheets
+ foreach ($worksheets as $sheetKey => $worksheet) {
+ foreach ($worksheet->sheetData->row as $row) {
+ foreach ($row->c as $c) {
+ // Determine data type
+ $dataType = (string)$c["t"];
+ switch ($dataType) {
+ case "s":
+ // Value is a shared string
+ if ((string)$c->v != '') {
+ $value = $sharedStrings[intval($c->v)];
+ } else {
+ $value = '';
+ }
+
+ break;
+
+ case "b":
+ // Value is boolean
+ $value = (string)$c->v;
+ if ($value == '0') {
+ $value = false;
+ } else if ($value == '1') {
+ $value = true;
+ } else {
+ $value = (bool)$c->v;
+ }
+
+ break;
+
+ case "inlineStr":
+ // Value is rich text inline
+ $value = $this->_parseRichText($c->is);
+
+ break;
+
+ case "e":
+ // Value is an error message
+ if ((string)$c->v != '') {
+ $value = (string)$c->v;
+ } else {
+ $value = '';
+ }
+
+ break;
+
+ default:
+ // Value is a string
+ $value = (string)$c->v;
+
+ // Check for numeric values
+ if (is_numeric($value) && $dataType != 's') {
+ if ($value == (int)$value) $value = (int)$value;
+ elseif ($value == (float)$value) $value = (float)$value;
+ elseif ($value == (double)$value) $value = (double)$value;
+ }
+ }
+
+ $documentBody[] = $value;
+ }
+ }
+ }
+
+ // Read core properties
+ $coreProperties = $this->extractMetaData($package);
+
+ // Close file
+ $package->close();
+
+ // Store filename
+ $this->addField(Zend_Search_Lucene_Field::Text('filename', $fileName, 'UTF-8'));
+
+ // Store contents
+ if ($storeContent) {
+ $this->addField(Zend_Search_Lucene_Field::Text('body', implode(' ', $documentBody), 'UTF-8'));
+ } else {
+ $this->addField(Zend_Search_Lucene_Field::UnStored('body', implode(' ', $documentBody), 'UTF-8'));
+ }
+
+ // Store meta data properties
+ foreach ($coreProperties as $key => $value)
+ {
+ $this->addField(Zend_Search_Lucene_Field::Text($key, $value, 'UTF-8'));
+ }
+
+ // Store title (if not present in meta data)
+ if (!isset($coreProperties['title']))
+ {
+ $this->addField(Zend_Search_Lucene_Field::Text('title', $fileName, 'UTF-8'));
+ }
+ }
+
+ /**
+ * Parse rich text XML
+ *
+ * @param SimpleXMLElement $is
+ * @return string
+ */
+ private function _parseRichText($is = null) {
+ $value = array();
+
+ if (isset($is->t)) {
+ $value[] = (string)$is->t;
+ } else {
+ foreach ($is->r as $run) {
+ $value[] = (string)$run->t;
+ }
+ }
+
+ return implode('', $value);
+ }
+
+ /**
+ * Load Xlsx document from a file
+ *
+ * @param string $fileName
+ * @param boolean $storeContent
+ * @return Zend_Search_Lucene_Document_Xlsx
+ */
+ public static function loadXlsxFile($fileName, $storeContent = false)
+ {
+ return new Zend_Search_Lucene_Document_Xlsx($fileName, $storeContent);
+ }
+}
+
+} // end if (class_exists('ZipArchive'))