<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2015 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 - 2015 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 - 2015 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 ();
    }
  }
}
