Subversion Repositories eFlore/Applications.cel

Rev

Rev 2388 | 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_Excel5
 * @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##
 */

// Original file header of PEAR::Spreadsheet_Excel_Writer_Format (used as the base for this class):
// -----------------------------------------------------------------------------------------
// /*
// *  Module written/ported by Xavier Noguer <xnoguer@rezebra.com>
// *
// *  The majority of this is _NOT_ my code.  I simply ported it from the
// *  PERL Spreadsheet::WriteExcel module.
// *
// *  The author of the Spreadsheet::WriteExcel module is John McNamara
// *  <jmcnamara@cpan.org>
// *
// *  I _DO_ maintain this code, and John McNamara has nothing to do with the
// *  porting of this code to PHP.  Any questions directly related to this
// *  class library should be directed to me.
// *
// *  License Information:
// *
// *    Spreadsheet_Excel_Writer:  A library for generating Excel Spreadsheets
// *    Copyright (c) 2002-2003 Xavier Noguer xnoguer@rezebra.com
// *
// *    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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
// */


/**
 * PHPExcel_Writer_Excel5_Xf
 *
 * @category   PHPExcel
 * @package    PHPExcel_Writer_Excel5
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
class PHPExcel_Writer_Excel5_Xf
{
    /**
         * Style XF or a cell XF ?
         *
         * @var boolean
         */
        private $_isStyleXf;

        /**
         * Index to the FONT record. Index 4 does not exist
         * @var integer
         */
        private $_fontIndex;

        /**
         * An index (2 bytes) to a FORMAT record (number format).
         * @var integer
         */
        public $_numberFormatIndex;

        /**
         * 1 bit, apparently not used.
         * @var integer
         */
        public $_text_justlast;

        /**
         * The cell's foreground color.
         * @var integer
         */
        public $_fg_color;

        /**
         * The cell's background color.
         * @var integer
         */
        public $_bg_color;

        /**
         * Color of the bottom border of the cell.
         * @var integer
         */
        public $_bottom_color;

        /**
         * Color of the top border of the cell.
         * @var integer
         */
        public $_top_color;

        /**
        * Color of the left border of the cell.
        * @var integer
        */
        public $_left_color;

        /**
         * Color of the right border of the cell.
         * @var integer
         */
        public $_right_color;

        /**
         * Constructor
         *
         * @access public
         * @param PHPExcel_Style        The XF format
         */
        public function __construct(PHPExcel_Style $style = null)
        {
                $this->_isStyleXf =     false;
                $this->_fontIndex      = 0;

                $this->_numberFormatIndex     = 0;

                $this->_text_justlast  = 0;

                $this->_fg_color       = 0x40;
                $this->_bg_color       = 0x41;

                $this->_diag           = 0;

                $this->_bottom_color   = 0x40;
                $this->_top_color      = 0x40;
                $this->_left_color     = 0x40;
                $this->_right_color    = 0x40;
                $this->_diag_color     = 0x40;
                $this->_style = $style;

        }


        /**
         * Generate an Excel BIFF XF record (style or cell).
         *
         * @return string The XF record
         */
        function writeXf()
        {
                // Set the type of the XF record and some of the attributes.
                if ($this->_isStyleXf) {
                        $style = 0xFFF5;
                } else {
                        $style   = self::_mapLocked($this->_style->getProtection()->getLocked());
                        $style  |= self::_mapHidden($this->_style->getProtection()->getHidden()) << 1;
                }

                // Flags to indicate if attributes have been set.
                $atr_num     = ($this->_numberFormatIndex != 0)?1:0;
                $atr_fnt     = ($this->_fontIndex != 0)?1:0;
                $atr_alc     = ((int) $this->_style->getAlignment()->getWrapText())?1:0;
                $atr_bdr     = (self::_mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle())   ||
                                                self::_mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle())      ||
                                                self::_mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle())     ||
                                                self::_mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()))?1:0;
                $atr_pat     = (($this->_fg_color != 0x40) ||
                                                ($this->_bg_color != 0x41) ||
                                                self::_mapFillType($this->_style->getFill()->getFillType()))?1:0;
                $atr_prot    = self::_mapLocked($this->_style->getProtection()->getLocked())
                                                | self::_mapHidden($this->_style->getProtection()->getHidden());

                // Zero the default border colour if the border has not been set.
                if (self::_mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) == 0) {
                        $this->_bottom_color = 0;
                }
                if (self::_mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle())  == 0) {
                        $this->_top_color = 0;
                }
                if (self::_mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()) == 0) {
                        $this->_right_color = 0;
                }
                if (self::_mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()) == 0) {
                        $this->_left_color = 0;
                }
                if (self::_mapBorderStyle($this->_style->getBorders()->getDiagonal()->getBorderStyle()) == 0) {
                        $this->_diag_color = 0;
                }

                $record         = 0x00E0;              // Record identifier
                $length         = 0x0014;              // Number of bytes to follow

                $ifnt           = $this->_fontIndex;   // Index to FONT record
                $ifmt           = $this->_numberFormatIndex;  // Index to FORMAT record

                $align          = $this->_mapHAlign($this->_style->getAlignment()->getHorizontal());       // Alignment
                $align         |= (int) $this->_style->getAlignment()->getWrapText()     << 3;
                $align         |= self::_mapVAlign($this->_style->getAlignment()->getVertical())  << 4;
                $align         |= $this->_text_justlast << 7;

                $used_attrib    = $atr_num              << 2;
                $used_attrib   |= $atr_fnt              << 3;
                $used_attrib   |= $atr_alc              << 4;
                $used_attrib   |= $atr_bdr              << 5;
                $used_attrib   |= $atr_pat              << 6;
                $used_attrib   |= $atr_prot             << 7;

                $icv            = $this->_fg_color;      // fg and bg pattern colors
                $icv           |= $this->_bg_color      << 7;

                $border1        = self::_mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle());          // Border line style and color
                $border1       |= self::_mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle())         << 4;
                $border1       |= self::_mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle())           << 8;
                $border1       |= self::_mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle())        << 12;
                $border1       |= $this->_left_color    << 16;
                $border1       |= $this->_right_color   << 23;

                $diagonalDirection = $this->_style->getBorders()->getDiagonalDirection();
                $diag_tl_to_rb = $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_BOTH
                                                        || $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_DOWN;
                $diag_tr_to_lb = $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_BOTH
                                                        || $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_UP;
                $border1       |= $diag_tl_to_rb        << 30;
                $border1       |= $diag_tr_to_lb        << 31;

                $border2        = $this->_top_color;    // Border color
                $border2       |= $this->_bottom_color   << 7;
                $border2       |= $this->_diag_color     << 14;
                $border2       |= self::_mapBorderStyle($this->_style->getBorders()->getDiagonal()->getBorderStyle())           << 21;
                $border2       |= self::_mapFillType($this->_style->getFill()->getFillType())        << 26;

                $header      = pack("vv",       $record, $length);

                //BIFF8 options: identation, shrinkToFit and  text direction
                $biff8_options  = $this->_style->getAlignment()->getIndent();
                $biff8_options |= (int) $this->_style->getAlignment()->getShrinkToFit() << 4;

                $data  = pack("vvvC", $ifnt, $ifmt, $style, $align);
                $data .= pack("CCC"
                        , self::_mapTextRotation($this->_style->getAlignment()->getTextRotation())
                        , $biff8_options
                        , $used_attrib
                        );
                $data .= pack("VVv", $border1, $border2, $icv);

                return($header . $data);
        }

        /**
         * Is this a style XF ?
         *
         * @param boolean $value
         */
        public function setIsStyleXf($value)
        {
                $this->_isStyleXf = $value;
        }

        /**
         * Sets the cell's bottom border color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setBottomColor($colorIndex)
        {
                $this->_bottom_color = $colorIndex;
        }

        /**
         * Sets the cell's top border color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setTopColor($colorIndex)
        {
                $this->_top_color = $colorIndex;
        }

        /**
         * Sets the cell's left border color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setLeftColor($colorIndex)
        {
                $this->_left_color = $colorIndex;
        }

        /**
         * Sets the cell's right border color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setRightColor($colorIndex)
        {
                $this->_right_color = $colorIndex;
        }

        /**
         * Sets the cell's diagonal border color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setDiagColor($colorIndex)
        {
                $this->_diag_color = $colorIndex;
        }


        /**
         * Sets the cell's foreground color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setFgColor($colorIndex)
        {
                $this->_fg_color = $colorIndex;
        }

        /**
         * Sets the cell's background color
         *
         * @access public
         * @param int $colorIndex Color index
         */
        function setBgColor($colorIndex)
        {
                $this->_bg_color = $colorIndex;
        }

        /**
         * Sets the index to the number format record
         * It can be date, time, currency, etc...
         *
         * @access public
         * @param integer $numberFormatIndex Index to format record
         */
        function setNumberFormatIndex($numberFormatIndex)
        {
                $this->_numberFormatIndex = $numberFormatIndex;
        }

        /**
         * Set the font index.
         *
         * @param int $value Font index, note that value 4 does not exist
         */
        public function setFontIndex($value)
        {
                $this->_fontIndex = $value;
        }

        /**
         * Map of BIFF2-BIFF8 codes for border styles
         * @static      array of int
         *
         */
        private static $_mapBorderStyle = array ( PHPExcel_Style_Border::BORDER_NONE                            => 0x00,
                                                                                          PHPExcel_Style_Border::BORDER_THIN                            => 0x01,
                                                                                          PHPExcel_Style_Border::BORDER_MEDIUM                          => 0x02,
                                                                                          PHPExcel_Style_Border::BORDER_DASHED                          => 0x03,
                                                                                          PHPExcel_Style_Border::BORDER_DOTTED                          => 0x04,
                                                                                          PHPExcel_Style_Border::BORDER_THICK                           => 0x05,
                                                                                          PHPExcel_Style_Border::BORDER_DOUBLE                          => 0x06,
                                                                                          PHPExcel_Style_Border::BORDER_HAIR                            => 0x07,
                                                                                          PHPExcel_Style_Border::BORDER_MEDIUMDASHED            => 0x08,
                                                                                          PHPExcel_Style_Border::BORDER_DASHDOT                         => 0x09,
                                                                                          PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT           => 0x0A,
                                                                                          PHPExcel_Style_Border::BORDER_DASHDOTDOT                      => 0x0B,
                                                                                          PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT        => 0x0C,
                                                                                          PHPExcel_Style_Border::BORDER_SLANTDASHDOT            => 0x0D,
                                                                                        );

        /**
         * Map border style
         *
         * @param string $borderStyle
         * @return int
         */
        private static function _mapBorderStyle($borderStyle) {
                if (isset(self::$_mapBorderStyle[$borderStyle]))
                        return self::$_mapBorderStyle[$borderStyle];
                return 0x00;
        }

        /**
         * Map of BIFF2-BIFF8 codes for fill types
         * @static      array of int
         *
         */
        private static $_mapFillType = array( PHPExcel_Style_Fill::FILL_NONE                                    => 0x00,
                                                                                  PHPExcel_Style_Fill::FILL_SOLID                                       => 0x01,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_MEDIUMGRAY          => 0x02,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKGRAY            => 0x03,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRAY           => 0x04,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKHORIZONTAL      => 0x05,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKVERTICAL        => 0x06,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKDOWN            => 0x07,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKUP                      => 0x08,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKGRID            => 0x09,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_DARKTRELLIS         => 0x0A,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTHORIZONTAL     => 0x0B,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTVERTICAL       => 0x0C,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTDOWN           => 0x0D,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTUP                     => 0x0E,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRID           => 0x0F,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_LIGHTTRELLIS        => 0x10,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_GRAY125                     => 0x11,
                                                                                  PHPExcel_Style_Fill::FILL_PATTERN_GRAY0625            => 0x12,
                                                                                  PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR                     => 0x00,        // does not exist in BIFF8
                                                                                  PHPExcel_Style_Fill::FILL_GRADIENT_PATH                       => 0x00,        // does not exist in BIFF8
                                                                                );
        /**
         * Map fill type
         *
         * @param string $fillType
         * @return int
         */
        private static function _mapFillType($fillType) {
                if (isset(self::$_mapFillType[$fillType]))
                        return self::$_mapFillType[$fillType];
                return 0x00;
        }

        /**
         * Map of BIFF2-BIFF8 codes for horizontal alignment
         * @static      array of int
         *
         */
        private static $_mapHAlign = array( PHPExcel_Style_Alignment::HORIZONTAL_GENERAL                        => 0,
                                                                                PHPExcel_Style_Alignment::HORIZONTAL_LEFT                               => 1,
                                                                                PHPExcel_Style_Alignment::HORIZONTAL_CENTER                             => 2,
                                                                                PHPExcel_Style_Alignment::HORIZONTAL_RIGHT                              => 3,
                                                                                PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY                    => 5,
                                                                                PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS  => 6,
                                                                          );
        /**
         * Map to BIFF2-BIFF8 codes for horizontal alignment
         *
         * @param string $hAlign
         * @return int
         */
        private function _mapHAlign($hAlign)
        {
                if (isset(self::$_mapHAlign[$hAlign]))
                        return self::$_mapHAlign[$hAlign];
                return 0;
        }

        /**
         * Map of BIFF2-BIFF8 codes for vertical alignment
         * @static      array of int
         *
         */
        private static $_mapVAlign = array( PHPExcel_Style_Alignment::VERTICAL_TOP              => 0,
                                                                                PHPExcel_Style_Alignment::VERTICAL_CENTER       => 1,
                                                                                PHPExcel_Style_Alignment::VERTICAL_BOTTOM       => 2,
                                                                                PHPExcel_Style_Alignment::VERTICAL_JUSTIFY      => 3,
                                                                          );
        /**
         * Map to BIFF2-BIFF8 codes for vertical alignment
         *
         * @param string $vAlign
         * @return int
         */
        private static function _mapVAlign($vAlign) {
                if (isset(self::$_mapVAlign[$vAlign]))
                        return self::$_mapVAlign[$vAlign];
                return 2;
        }

        /**
         * Map to BIFF8 codes for text rotation angle
         *
         * @param int $textRotation
         * @return int
         */
        private static function _mapTextRotation($textRotation) {
                if ($textRotation >= 0) {
                        return $textRotation;
                }
                if ($textRotation == -165) {
                        return 255;
                }
                if ($textRotation < 0) {
                        return 90 - $textRotation;
                }
        }

        /**
         * Map locked
         *
         * @param string
         * @return int
         */
        private static function _mapLocked($locked) {
                switch ($locked) {
                        case PHPExcel_Style_Protection::PROTECTION_INHERIT:             return 1;
                        case PHPExcel_Style_Protection::PROTECTION_PROTECTED:   return 1;
                        case PHPExcel_Style_Protection::PROTECTION_UNPROTECTED: return 0;
                        default:                                                                                                return 1;
                }
        }

        /**
         * Map hidden
         *
         * @param string
         * @return int
         */
        private static function _mapHidden($hidden) {
                switch ($hidden) {
                        case PHPExcel_Style_Protection::PROTECTION_INHERIT:             return 0;
                        case PHPExcel_Style_Protection::PROTECTION_PROTECTED:   return 1;
                        case PHPExcel_Style_Protection::PROTECTION_UNPROTECTED: return 0;
                        default:                                                                                                return 0;
                }
        }

}