<?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_Writer_OpenDocument

 * @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    ##VERSION##, ##DATE##

 */





/**

 * PHPExcel_Writer_OpenDocument_Content

 *

 * @category   PHPExcel

 * @package    PHPExcel_Writer_OpenDocument

 * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

 * @author     Alexander Pervakov <frost-nzcr4@jagmort.com>

 */

class PHPExcel_Writer_OpenDocument_Content extends PHPExcel_Writer_OpenDocument_WriterPart

{

    const NUMBER_COLS_REPEATED_MAX = 1024;

    const NUMBER_ROWS_REPEATED_MAX = 1048576;



    /**

     * Write content.xml to XML format

     *

     * @param   PHPExcel                   $pPHPExcel

     * @return  string                     XML Output

     * @throws  PHPExcel_Writer_Exception

     */

    public function write(PHPExcel $pPHPExcel = null)

    {

        if (!$pPHPExcel) {

            $pPHPExcel = $this->getParentWriter()->getPHPExcel(); /* @var $pPHPExcel PHPExcel */

        }



        $objWriter = null;

        if ($this->getParentWriter()->getUseDiskCaching()) {

            $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());

        } else {

            $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);

        }



        // XML header

        $objWriter->startDocument('1.0', 'UTF-8');



        // Content

        $objWriter->startElement('office:document-content');

            $objWriter->writeAttribute('xmlns:office', 'urn:oasis:names:tc:opendocument:xmlns:office:1.0');

            $objWriter->writeAttribute('xmlns:style', 'urn:oasis:names:tc:opendocument:xmlns:style:1.0');

            $objWriter->writeAttribute('xmlns:text', 'urn:oasis:names:tc:opendocument:xmlns:text:1.0');

            $objWriter->writeAttribute('xmlns:table', 'urn:oasis:names:tc:opendocument:xmlns:table:1.0');

            $objWriter->writeAttribute('xmlns:draw', 'urn:oasis:names:tc:opendocument:xmlns:drawing:1.0');

            $objWriter->writeAttribute('xmlns:fo', 'urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0');

            $objWriter->writeAttribute('xmlns:xlink', 'http://www.w3.org/1999/xlink');

            $objWriter->writeAttribute('xmlns:dc', 'http://purl.org/dc/elements/1.1/');

            $objWriter->writeAttribute('xmlns:meta', 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0');

            $objWriter->writeAttribute('xmlns:number', 'urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0');

            $objWriter->writeAttribute('xmlns:presentation', 'urn:oasis:names:tc:opendocument:xmlns:presentation:1.0');

            $objWriter->writeAttribute('xmlns:svg', 'urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0');

            $objWriter->writeAttribute('xmlns:chart', 'urn:oasis:names:tc:opendocument:xmlns:chart:1.0');

            $objWriter->writeAttribute('xmlns:dr3d', 'urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0');

            $objWriter->writeAttribute('xmlns:math', 'http://www.w3.org/1998/Math/MathML');

            $objWriter->writeAttribute('xmlns:form', 'urn:oasis:names:tc:opendocument:xmlns:form:1.0');

            $objWriter->writeAttribute('xmlns:script', 'urn:oasis:names:tc:opendocument:xmlns:script:1.0');

            $objWriter->writeAttribute('xmlns:ooo', 'http://openoffice.org/2004/office');

            $objWriter->writeAttribute('xmlns:ooow', 'http://openoffice.org/2004/writer');

            $objWriter->writeAttribute('xmlns:oooc', 'http://openoffice.org/2004/calc');

            $objWriter->writeAttribute('xmlns:dom', 'http://www.w3.org/2001/xml-events');

            $objWriter->writeAttribute('xmlns:xforms', 'http://www.w3.org/2002/xforms');

            $objWriter->writeAttribute('xmlns:xsd', 'http://www.w3.org/2001/XMLSchema');

            $objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');

            $objWriter->writeAttribute('xmlns:rpt', 'http://openoffice.org/2005/report');

            $objWriter->writeAttribute('xmlns:of', 'urn:oasis:names:tc:opendocument:xmlns:of:1.2');

            $objWriter->writeAttribute('xmlns:xhtml', 'http://www.w3.org/1999/xhtml');

            $objWriter->writeAttribute('xmlns:grddl', 'http://www.w3.org/2003/g/data-view#');

            $objWriter->writeAttribute('xmlns:tableooo', 'http://openoffice.org/2009/table');

            $objWriter->writeAttribute('xmlns:field', 'urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0');

            $objWriter->writeAttribute('xmlns:formx', 'urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0');

            $objWriter->writeAttribute('xmlns:css3t', 'http://www.w3.org/TR/css3-text/');

            $objWriter->writeAttribute('office:version', '1.2');



            $objWriter->writeElement('office:scripts');

            $objWriter->writeElement('office:font-face-decls');

            $objWriter->writeElement('office:automatic-styles');



            $objWriter->startElement('office:body');

                $objWriter->startElement('office:spreadsheet');

                    $objWriter->writeElement('table:calculation-settings');

                    $this->_writeSheets($objWriter);

                    $objWriter->writeElement('table:named-expressions');

                $objWriter->endElement();

            $objWriter->endElement();

        $objWriter->endElement();



        return $objWriter->getData();

    }



    /**

     * Write sheets

     *

     * @param PHPExcel_Shared_XMLWriter $objWriter

     */

    private function _writeSheets(PHPExcel_Shared_XMLWriter $objWriter)

    {

        $pPHPExcel = $this->getParentWriter()->getPHPExcel(); /* @var $pPHPExcel PHPExcel */



        $sheet_count = $pPHPExcel->getSheetCount();

        for ($i = 0; $i < $sheet_count; $i++) {

            //$this->getWriterPart('Worksheet')->writeWorksheet());

            $objWriter->startElement('table:table');

                $objWriter->writeAttribute('table:name', $pPHPExcel->getSheet($i)->getTitle());

                $objWriter->writeElement('office:forms');

                $objWriter->startElement('table:table-column');

                    $objWriter->writeAttribute('table:number-columns-repeated', self::NUMBER_COLS_REPEATED_MAX);

                $objWriter->endElement();

                $this->_writeRows($objWriter, $pPHPExcel->getSheet($i));

            $objWriter->endElement();

        }

    }



    /**

     * Write rows of the specified sheet

     *

     * @param PHPExcel_Shared_XMLWriter $objWriter

     * @param PHPExcel_Worksheet $sheet

     */

    private function _writeRows(PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Worksheet $sheet)

    {

        $number_rows_repeated = self::NUMBER_ROWS_REPEATED_MAX;

        $span_row = 0;

        $rows = $sheet->getRowIterator();

        while ($rows->valid()) {

            $number_rows_repeated--;

            $row = $rows->current();

            if ($row->getCellIterator()->valid()) {

                if ($span_row) {

                    $objWriter->startElement('table:table-row');

                    if ($span_row > 1) {

                        $objWriter->writeAttribute('table:number-rows-repeated', $span_row);

                    }

                    $objWriter->startElement('table:table-cell');

                        $objWriter->writeAttribute('table:number-columns-repeated', self::NUMBER_COLS_REPEATED_MAX);

                    $objWriter->endElement();

                    $objWriter->endElement();

                    $span_row = 0;

                }

                $objWriter->startElement('table:table-row');

                $this->_writeCells($objWriter, $row);

                $objWriter->endElement();

            } else {

                $span_row++;

            }

            $rows->next();

        }

    }



    /**

     * Write cells of the specified row

     *

     * @param PHPExcel_Shared_XMLWriter $objWriter

     * @param PHPExcel_Worksheet_Row $row

     * @throws PHPExcel_Writer_Exception

     */

    private function _writeCells(PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Worksheet_Row $row)

    {

        $number_cols_repeated = self::NUMBER_COLS_REPEATED_MAX;

        $prev_column = -1;

        $cells = $row->getCellIterator();

        while ($cells->valid()) {

            $cell = $cells->current();

            $column = PHPExcel_Cell::columnIndexFromString($cell->getColumn()) - 1;



            $this->_writeCellSpan($objWriter, $column, $prev_column);

            $objWriter->startElement('table:table-cell');



            switch ($cell->getDataType()) {

                case PHPExcel_Cell_DataType::TYPE_BOOL:

                    $objWriter->writeAttribute('office:value-type', 'boolean');

                    $objWriter->writeAttribute('office:value', $cell->getValue());

                    $objWriter->writeElement('text:p', $cell->getValue());

                    break;



                case PHPExcel_Cell_DataType::TYPE_ERROR:

                    throw new PHPExcel_Writer_Exception('Writing of error not implemented yet.');

                    break;



                case PHPExcel_Cell_DataType::TYPE_FORMULA:

                    try {

                        $formula_value = $cell->getCalculatedValue();

                    } catch (Exception $e) {

                        $formula_value = $cell->getValue();

                    }

                    $objWriter->writeAttribute('table:formula', 'of:' . $cell->getValue());

                    if (is_numeric($formula_value)) {

                        $objWriter->writeAttribute('office:value-type', 'float');

                    } else {

                        $objWriter->writeAttribute('office:value-type', 'string');

                    }

                    $objWriter->writeAttribute('office:value', $formula_value);

                    $objWriter->writeElement('text:p', $formula_value);

                    break;



                case PHPExcel_Cell_DataType::TYPE_INLINE:

                    throw new PHPExcel_Writer_Exception('Writing of inline not implemented yet.');

                    break;



                case PHPExcel_Cell_DataType::TYPE_NUMERIC:

                    $objWriter->writeAttribute('office:value-type', 'float');

                    $objWriter->writeAttribute('office:value', $cell->getValue());

                    $objWriter->writeElement('text:p', $cell->getValue());

                    break;



                case PHPExcel_Cell_DataType::TYPE_STRING:

                    $objWriter->writeAttribute('office:value-type', 'string');

                    $objWriter->writeElement('text:p', $cell->getValue());

                    break;

            }

            PHPExcel_Writer_OpenDocument_Cell_Comment::write($objWriter, $cell);

            $objWriter->endElement();

            $prev_column = $column;

            $cells->next();

        }

        $number_cols_repeated = $number_cols_repeated - $prev_column - 1;

        if ($number_cols_repeated > 0) {

            if ($number_cols_repeated > 1) {

                $objWriter->startElement('table:table-cell');

                $objWriter->writeAttribute('table:number-columns-repeated', $number_cols_repeated);

                $objWriter->endElement();

            } else {

                $objWriter->writeElement('table:table-cell');

            }

        }

    }



    /**

     * Write span

     *

     * @param PHPExcel_Shared_XMLWriter $objWriter

     * @param integer $curColumn

     * @param integer $prevColumn

     */

    private function _writeCellSpan(PHPExcel_Shared_XMLWriter $objWriter, $curColumn, $prevColumn)

    {

        $diff = $curColumn - $prevColumn - 1;

        if (1 === $diff) {

            $objWriter->writeElement('table:table-cell');

        } elseif ($diff > 1) {

            $objWriter->startElement('table:table-cell');

                $objWriter->writeAttribute('table:number-columns-repeated', $diff);

            $objWriter->endElement();

        }

    }

}

