Subversion Repositories eFlore/Applications.cel

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2013 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_Excel2007
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 * @version    ##VERSION##, ##DATE##
 */


/**
 * PHPExcel_Writer_Excel2007_Drawing
 *
 * @category   PHPExcel
 * @package    PHPExcel_Writer_Excel2007
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
class PHPExcel_Writer_Excel2007_Drawing extends PHPExcel_Writer_Excel2007_WriterPart
{
        /**
         * Write drawings to XML format
         *
         * @param       PHPExcel_Worksheet      $pWorksheet
         * @param       int                                     &$chartRef              Chart ID
         * @param       boolean                         $includeCharts  Flag indicating if we should include drawing details for charts
         * @return      string                          XML Output
         * @throws      PHPExcel_Writer_Exception
         */
        public function writeDrawings(PHPExcel_Worksheet $pWorksheet = null, &$chartRef, $includeCharts = FALSE)
        {
                // Create XML writer
                $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','yes');

                // xdr:wsDr
                $objWriter->startElement('xdr:wsDr');
                $objWriter->writeAttribute('xmlns:xdr', 'http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing');
                $objWriter->writeAttribute('xmlns:a', 'http://schemas.openxmlformats.org/drawingml/2006/main');

                        // Loop through images and write drawings
                        $i = 1;
                        $iterator = $pWorksheet->getDrawingCollection()->getIterator();
                        while ($iterator->valid()) {
                                $this->_writeDrawing($objWriter, $iterator->current(), $i);

                                $iterator->next();
                                ++$i;
                        }

                        if ($includeCharts) {
                                $chartCount = $pWorksheet->getChartCount();
                                // Loop through charts and write the chart position
                                if ($chartCount > 0) {
                                        for ($c = 0; $c < $chartCount; ++$c) {
                                                $this->_writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c+$i);
                                        }
                                }
                        }


                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }

        /**
         * Write drawings to XML format
         *
         * @param       PHPExcel_Shared_XMLWriter       $objWriter              XML Writer
         * @param       PHPExcel_Chart                          $pChart
         * @param       int                                                     $pRelationId
         * @throws      PHPExcel_Writer_Exception
         */
        public function _writeChart(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Chart $pChart = null, $pRelationId = -1)
        {
                $tl = $pChart->getTopLeftPosition();
                $tl['colRow'] = PHPExcel_Cell::coordinateFromString($tl['cell']);
                $br = $pChart->getBottomRightPosition();
                $br['colRow'] = PHPExcel_Cell::coordinateFromString($br['cell']);

                $objWriter->startElement('xdr:twoCellAnchor');

                        $objWriter->startElement('xdr:from');
                                $objWriter->writeElement('xdr:col', PHPExcel_Cell::columnIndexFromString($tl['colRow'][0]) - 1);
                                $objWriter->writeElement('xdr:colOff', PHPExcel_Shared_Drawing::pixelsToEMU($tl['xOffset']));
                                $objWriter->writeElement('xdr:row', $tl['colRow'][1] - 1);
                                $objWriter->writeElement('xdr:rowOff', PHPExcel_Shared_Drawing::pixelsToEMU($tl['yOffset']));
                        $objWriter->endElement();
                        $objWriter->startElement('xdr:to');
                                $objWriter->writeElement('xdr:col', PHPExcel_Cell::columnIndexFromString($br['colRow'][0]) - 1);
                                $objWriter->writeElement('xdr:colOff', PHPExcel_Shared_Drawing::pixelsToEMU($br['xOffset']));
                                $objWriter->writeElement('xdr:row', $br['colRow'][1] - 1);
                                $objWriter->writeElement('xdr:rowOff', PHPExcel_Shared_Drawing::pixelsToEMU($br['yOffset']));
                        $objWriter->endElement();

                        $objWriter->startElement('xdr:graphicFrame');
                                $objWriter->writeAttribute('macro', '');
                                $objWriter->startElement('xdr:nvGraphicFramePr');
                                        $objWriter->startElement('xdr:cNvPr');
                                                $objWriter->writeAttribute('name', 'Chart '.$pRelationId);
                                                $objWriter->writeAttribute('id', 1025 * $pRelationId);
                                        $objWriter->endElement();
                                        $objWriter->startElement('xdr:cNvGraphicFramePr');
                                                $objWriter->startElement('a:graphicFrameLocks');
                                                $objWriter->endElement();
                                        $objWriter->endElement();
                                $objWriter->endElement();

                                $objWriter->startElement('xdr:xfrm');
                                        $objWriter->startElement('a:off');
                                                $objWriter->writeAttribute('x', '0');
                                                $objWriter->writeAttribute('y', '0');
                                        $objWriter->endElement();
                                        $objWriter->startElement('a:ext');
                                                $objWriter->writeAttribute('cx', '0');
                                                $objWriter->writeAttribute('cy', '0');
                                        $objWriter->endElement();
                                $objWriter->endElement();

                                $objWriter->startElement('a:graphic');
                                        $objWriter->startElement('a:graphicData');
                                                $objWriter->writeAttribute('uri', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
                                                $objWriter->startElement('c:chart');
                                                        $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
                                                        $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
                                                        $objWriter->writeAttribute('r:id', 'rId'.$pRelationId);
                                                $objWriter->endElement();
                                        $objWriter->endElement();
                                $objWriter->endElement();
                        $objWriter->endElement();

                        $objWriter->startElement('xdr:clientData');
                        $objWriter->endElement();

                $objWriter->endElement();
        }

        /**
         * Write drawings to XML format
         *
         * @param       PHPExcel_Shared_XMLWriter                       $objWriter              XML Writer
         * @param       PHPExcel_Worksheet_BaseDrawing          $pDrawing
         * @param       int                                                                     $pRelationId
         * @throws      PHPExcel_Writer_Exception
         */
        public function _writeDrawing(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet_BaseDrawing $pDrawing = null, $pRelationId = -1)
        {
                if ($pRelationId >= 0) {
                        // xdr:oneCellAnchor
                        $objWriter->startElement('xdr:oneCellAnchor');
                                // Image location
                                $aCoordinates           = PHPExcel_Cell::coordinateFromString($pDrawing->getCoordinates());
                                $aCoordinates[0]        = PHPExcel_Cell::columnIndexFromString($aCoordinates[0]);

                                // xdr:from
                                $objWriter->startElement('xdr:from');
                                        $objWriter->writeElement('xdr:col', $aCoordinates[0] - 1);
                                        $objWriter->writeElement('xdr:colOff', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getOffsetX()));
                                        $objWriter->writeElement('xdr:row', $aCoordinates[1] - 1);
                                        $objWriter->writeElement('xdr:rowOff', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getOffsetY()));
                                $objWriter->endElement();

                                // xdr:ext
                                $objWriter->startElement('xdr:ext');
                                        $objWriter->writeAttribute('cx', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getWidth()));
                                        $objWriter->writeAttribute('cy', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getHeight()));
                                $objWriter->endElement();

                                // xdr:pic
                                $objWriter->startElement('xdr:pic');

                                        // xdr:nvPicPr
                                        $objWriter->startElement('xdr:nvPicPr');

                                                // xdr:cNvPr
                                                $objWriter->startElement('xdr:cNvPr');
                                                $objWriter->writeAttribute('id', $pRelationId);
                                                $objWriter->writeAttribute('name', $pDrawing->getName());
                                                $objWriter->writeAttribute('descr', $pDrawing->getDescription());
                                                $objWriter->endElement();

                                                // xdr:cNvPicPr
                                                $objWriter->startElement('xdr:cNvPicPr');

                                                        // a:picLocks
                                                        $objWriter->startElement('a:picLocks');
                                                        $objWriter->writeAttribute('noChangeAspect', '1');
                                                        $objWriter->endElement();

                                                $objWriter->endElement();

                                        $objWriter->endElement();

                                        // xdr:blipFill
                                        $objWriter->startElement('xdr:blipFill');

                                                // a:blip
                                                $objWriter->startElement('a:blip');
                                                $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
                                                $objWriter->writeAttribute('r:embed', 'rId' . $pRelationId);
                                                $objWriter->endElement();

                                                // a:stretch
                                                $objWriter->startElement('a:stretch');
                                                        $objWriter->writeElement('a:fillRect', null);
                                                $objWriter->endElement();

                                        $objWriter->endElement();

                                        // xdr:spPr
                                        $objWriter->startElement('xdr:spPr');

                                                // a:xfrm
                                                $objWriter->startElement('a:xfrm');
                                                $objWriter->writeAttribute('rot', PHPExcel_Shared_Drawing::degreesToAngle($pDrawing->getRotation()));
                                                $objWriter->endElement();

                                                // a:prstGeom
                                                $objWriter->startElement('a:prstGeom');
                                                $objWriter->writeAttribute('prst', 'rect');

                                                        // a:avLst
                                                        $objWriter->writeElement('a:avLst', null);

                                                $objWriter->endElement();

//                                              // a:solidFill
//                                              $objWriter->startElement('a:solidFill');

//                                                      // a:srgbClr
//                                                      $objWriter->startElement('a:srgbClr');
//                                                      $objWriter->writeAttribute('val', 'FFFFFF');

///* SHADE
//                                                              // a:shade
//                                                              $objWriter->startElement('a:shade');
//                                                              $objWriter->writeAttribute('val', '85000');
//                                                              $objWriter->endElement();
//*/

//                                                      $objWriter->endElement();

//                                              $objWriter->endElement();
/*
                                                // a:ln
                                                $objWriter->startElement('a:ln');
                                                $objWriter->writeAttribute('w', '88900');
                                                $objWriter->writeAttribute('cap', 'sq');

                                                        // a:solidFill
                                                        $objWriter->startElement('a:solidFill');

                                                                // a:srgbClr
                                                                $objWriter->startElement('a:srgbClr');
                                                                $objWriter->writeAttribute('val', 'FFFFFF');
                                                                $objWriter->endElement();

                                                        $objWriter->endElement();

                                                        // a:miter
                                                        $objWriter->startElement('a:miter');
                                                        $objWriter->writeAttribute('lim', '800000');
                                                        $objWriter->endElement();

                                                $objWriter->endElement();
*/

                                                if ($pDrawing->getShadow()->getVisible()) {
                                                        // a:effectLst
                                                        $objWriter->startElement('a:effectLst');

                                                                // a:outerShdw
                                                                $objWriter->startElement('a:outerShdw');
                                                                $objWriter->writeAttribute('blurRad',           PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getBlurRadius()));
                                                                $objWriter->writeAttribute('dist',                      PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getDistance()));
                                                                $objWriter->writeAttribute('dir',                       PHPExcel_Shared_Drawing::degreesToAngle($pDrawing->getShadow()->getDirection()));
                                                                $objWriter->writeAttribute('algn',                      $pDrawing->getShadow()->getAlignment());
                                                                $objWriter->writeAttribute('rotWithShape',      '0');

                                                                        // a:srgbClr
                                                                        $objWriter->startElement('a:srgbClr');
                                                                        $objWriter->writeAttribute('val',               $pDrawing->getShadow()->getColor()->getRGB());

                                                                                // a:alpha
                                                                                $objWriter->startElement('a:alpha');
                                                                                $objWriter->writeAttribute('val',       $pDrawing->getShadow()->getAlpha() * 1000);
                                                                                $objWriter->endElement();

                                                                        $objWriter->endElement();

                                                                $objWriter->endElement();

                                                        $objWriter->endElement();
                                                }
/*

                                                // a:scene3d
                                                $objWriter->startElement('a:scene3d');

                                                        // a:camera
                                                        $objWriter->startElement('a:camera');
                                                        $objWriter->writeAttribute('prst', 'orthographicFront');
                                                        $objWriter->endElement();

                                                        // a:lightRig
                                                        $objWriter->startElement('a:lightRig');
                                                        $objWriter->writeAttribute('rig', 'twoPt');
                                                        $objWriter->writeAttribute('dir', 't');

                                                                // a:rot
                                                                $objWriter->startElement('a:rot');
                                                                $objWriter->writeAttribute('lat', '0');
                                                                $objWriter->writeAttribute('lon', '0');
                                                                $objWriter->writeAttribute('rev', '0');
                                                                $objWriter->endElement();

                                                        $objWriter->endElement();

                                                $objWriter->endElement();
*/
/*
                                                // a:sp3d
                                                $objWriter->startElement('a:sp3d');

                                                        // a:bevelT
                                                        $objWriter->startElement('a:bevelT');
                                                        $objWriter->writeAttribute('w', '25400');
                                                        $objWriter->writeAttribute('h', '19050');
                                                        $objWriter->endElement();

                                                        // a:contourClr
                                                        $objWriter->startElement('a:contourClr');

                                                                // a:srgbClr
                                                                $objWriter->startElement('a:srgbClr');
                                                                $objWriter->writeAttribute('val', 'FFFFFF');
                                                                $objWriter->endElement();

                                                        $objWriter->endElement();

                                                $objWriter->endElement();
*/
                                        $objWriter->endElement();

                                $objWriter->endElement();

                                // xdr:clientData
                                $objWriter->writeElement('xdr:clientData', null);

                        $objWriter->endElement();
                } else {
                        throw new PHPExcel_Writer_Exception("Invalid parameters passed.");
                }
        }

        /**
         * Write VML header/footer images to XML format
         *
         * @param       PHPExcel_Worksheet                              $pWorksheet
         * @return      string                                                          XML Output
         * @throws      PHPExcel_Writer_Exception
         */
        public function writeVMLHeaderFooterImages(PHPExcel_Worksheet $pWorksheet = null)
        {
                // Create XML writer
                $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','yes');

                // Header/footer images
                $images = $pWorksheet->getHeaderFooter()->getImages();

                // xml
                $objWriter->startElement('xml');
                $objWriter->writeAttribute('xmlns:v', 'urn:schemas-microsoft-com:vml');
                $objWriter->writeAttribute('xmlns:o', 'urn:schemas-microsoft-com:office:office');
                $objWriter->writeAttribute('xmlns:x', 'urn:schemas-microsoft-com:office:excel');

                        // o:shapelayout
                        $objWriter->startElement('o:shapelayout');
                        $objWriter->writeAttribute('v:ext',             'edit');

                                // o:idmap
                                $objWriter->startElement('o:idmap');
                                $objWriter->writeAttribute('v:ext',     'edit');
                                $objWriter->writeAttribute('data',              '1');
                                $objWriter->endElement();

                        $objWriter->endElement();

                        // v:shapetype
                        $objWriter->startElement('v:shapetype');
                        $objWriter->writeAttribute('id',                                        '_x0000_t75');
                        $objWriter->writeAttribute('coordsize',                         '21600,21600');
                        $objWriter->writeAttribute('o:spt',                             '75');
                        $objWriter->writeAttribute('o:preferrelative',          't');
                        $objWriter->writeAttribute('path',                                      'm@4@5l@4@11@9@11@9@5xe');
                        $objWriter->writeAttribute('filled',                            'f');
                        $objWriter->writeAttribute('stroked',                           'f');

                                // v:stroke
                                $objWriter->startElement('v:stroke');
                                $objWriter->writeAttribute('joinstyle',                 'miter');
                                $objWriter->endElement();

                                // v:formulas
                                $objWriter->startElement('v:formulas');

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'if lineDrawn pixelLineWidth 0');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'sum @0 1 0');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'sum 0 0 @1');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'prod @2 1 2');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'prod @3 21600 pixelWidth');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'prod @3 21600 pixelHeight');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'sum @0 0 1');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'prod @6 1 2');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'prod @7 21600 pixelWidth');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'sum @8 21600 0');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'prod @7 21600 pixelHeight');
                                        $objWriter->endElement();

                                        // v:f
                                        $objWriter->startElement('v:f');
                                        $objWriter->writeAttribute('eqn',               'sum @10 21600 0');
                                        $objWriter->endElement();

                                $objWriter->endElement();

                                // v:path
                                $objWriter->startElement('v:path');
                                $objWriter->writeAttribute('o:extrusionok',     'f');
                                $objWriter->writeAttribute('gradientshapeok',   't');
                                $objWriter->writeAttribute('o:connecttype',     'rect');
                                $objWriter->endElement();

                                // o:lock
                                $objWriter->startElement('o:lock');
                                $objWriter->writeAttribute('v:ext',                     'edit');
                                $objWriter->writeAttribute('aspectratio',               't');
                                $objWriter->endElement();

                        $objWriter->endElement();

                        // Loop through images
                        foreach ($images as $key => $value) {
                                $this->_writeVMLHeaderFooterImage($objWriter, $key, $value);
                        }

                $objWriter->endElement();

                // Return
                return $objWriter->getData();
        }

        /**
         * Write VML comment to XML format
         *
         * @param       PHPExcel_Shared_XMLWriter               $objWriter                      XML Writer
         * @param       string                                                  $pReference                     Reference
         * @param       PHPExcel_Worksheet_HeaderFooterDrawing  $pImage         Image
         * @throws      PHPExcel_Writer_Exception
         */
        public function _writeVMLHeaderFooterImage(PHPExcel_Shared_XMLWriter $objWriter = null, $pReference = '', PHPExcel_Worksheet_HeaderFooterDrawing $pImage = null)
        {
                // Calculate object id
                preg_match('{(\d+)}', md5($pReference), $m);
                $id = 1500 + (substr($m[1], 0, 2) * 1);

                // Calculate offset
                $width = $pImage->getWidth();
                $height = $pImage->getHeight();
                $marginLeft = $pImage->getOffsetX();
                $marginTop = $pImage->getOffsetY();

                // v:shape
                $objWriter->startElement('v:shape');
                $objWriter->writeAttribute('id',                        $pReference);
                $objWriter->writeAttribute('o:spid',            '_x0000_s' . $id);
                $objWriter->writeAttribute('type',                      '#_x0000_t75');
                $objWriter->writeAttribute('style',             "position:absolute;margin-left:{$marginLeft}px;margin-top:{$marginTop}px;width:{$width}px;height:{$height}px;z-index:1");

                        // v:imagedata
                        $objWriter->startElement('v:imagedata');
                        $objWriter->writeAttribute('o:relid',           'rId' . $pReference);
                        $objWriter->writeAttribute('o:title',           $pImage->getName());
                        $objWriter->endElement();

                        // o:lock
                        $objWriter->startElement('o:lock');
                        $objWriter->writeAttribute('v:ext',             'edit');
                        $objWriter->writeAttribute('rotation',          't');
                        $objWriter->endElement();

                $objWriter->endElement();
        }


        /**
         * Get an array of all drawings
         *
         * @param       PHPExcel                                                        $pPHPExcel
         * @return      PHPExcel_Worksheet_Drawing[]            All drawings in PHPExcel
         * @throws      PHPExcel_Writer_Exception
         */
        public function allDrawings(PHPExcel $pPHPExcel = null)
        {
                // Get an array of all drawings
                $aDrawings      = array();

                // Loop through PHPExcel
                $sheetCount = $pPHPExcel->getSheetCount();
                for ($i = 0; $i < $sheetCount; ++$i) {
                        // Loop through images and add to array
                        $iterator = $pPHPExcel->getSheet($i)->getDrawingCollection()->getIterator();
                        while ($iterator->valid()) {
                                $aDrawings[] = $iterator->current();

                                $iterator->next();
                        }
                }

                return $aDrawings;
        }
}