| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429 | 
							- <?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_Style
 
-  * @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 1.8.0, 2014-03-02
 
-  */
 
- /**
 
-  * PHPExcel_Style_Color
 
-  *
 
-  * @category   PHPExcel
 
-  * @package	PHPExcel_Style
 
-  * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 
-  */
 
- class PHPExcel_Style_Color extends PHPExcel_Style_Supervisor implements PHPExcel_IComparable
 
- {
 
- 	/* Colors */
 
- 	const COLOR_BLACK						= 'FF000000';
 
- 	const COLOR_WHITE						= 'FFFFFFFF';
 
- 	const COLOR_RED							= 'FFFF0000';
 
- 	const COLOR_DARKRED						= 'FF800000';
 
- 	const COLOR_BLUE						= 'FF0000FF';
 
- 	const COLOR_DARKBLUE					= 'FF000080';
 
- 	const COLOR_GREEN						= 'FF00FF00';
 
- 	const COLOR_DARKGREEN					= 'FF008000';
 
- 	const COLOR_YELLOW						= 'FFFFFF00';
 
- 	const COLOR_DARKYELLOW					= 'FF808000';
 
- 	/**
 
- 	 * Indexed colors array
 
- 	 *
 
- 	 * @var array
 
- 	 */
 
- 	protected static $_indexedColors;
 
- 	/**
 
- 	 * ARGB - Alpha RGB
 
- 	 *
 
- 	 * @var string
 
- 	 */
 
- 	protected $_argb	= NULL;
 
- 	/**
 
- 	 * Parent property name
 
- 	 *
 
- 	 * @var string
 
- 	 */
 
- 	protected $_parentPropertyName;
 
- 	/**
 
- 	 * Create a new PHPExcel_Style_Color
 
- 	 *
 
- 	 * @param	string	$pARGB			ARGB value for the colour
 
- 	 * @param	boolean	$isSupervisor	Flag indicating if this is a supervisor or not
 
- 	 *									Leave this value at default unless you understand exactly what
 
- 	 *										its ramifications are
 
- 	 * @param	boolean	$isConditional	Flag indicating if this is a conditional style or not
 
- 	 *									Leave this value at default unless you understand exactly what
 
- 	 *										its ramifications are
 
- 	 */
 
- 	public function __construct($pARGB = PHPExcel_Style_Color::COLOR_BLACK, $isSupervisor = FALSE, $isConditional = FALSE)
 
- 	{
 
- 		//	Supervisor?
 
- 		parent::__construct($isSupervisor);
 
- 		//	Initialise values
 
- 		if (!$isConditional) {
 
- 			$this->_argb = $pARGB;
 
- 		}
 
- 	}
 
- 	/**
 
- 	 * Bind parent. Only used for supervisor
 
- 	 *
 
- 	 * @param mixed $parent
 
- 	 * @param string $parentPropertyName
 
- 	 * @return PHPExcel_Style_Color
 
- 	 */
 
- 	public function bindParent($parent, $parentPropertyName=NULL)
 
- 	{
 
- 		$this->_parent = $parent;
 
- 		$this->_parentPropertyName = $parentPropertyName;
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get the shared style component for the currently active cell in currently active sheet.
 
- 	 * Only used for style supervisor
 
- 	 *
 
- 	 * @return PHPExcel_Style_Color
 
- 	 */
 
- 	public function getSharedComponent()
 
- 	{
 
- 		switch ($this->_parentPropertyName) {
 
- 			case '_endColor':
 
- 				return $this->_parent->getSharedComponent()->getEndColor();		break;
 
- 			case '_color':
 
- 				return $this->_parent->getSharedComponent()->getColor();		break;
 
- 			case '_startColor':
 
- 				return $this->_parent->getSharedComponent()->getStartColor();	break;
 
- 		}
 
- 	}
 
- 	/**
 
- 	 * Build style array from subcomponents
 
- 	 *
 
- 	 * @param array $array
 
- 	 * @return array
 
- 	 */
 
- 	public function getStyleArray($array)
 
- 	{
 
- 		switch ($this->_parentPropertyName) {
 
- 			case '_endColor':
 
- 				$key = 'endcolor';
 
- 				break;
 
- 			case '_color':
 
- 				$key = 'color';
 
- 				break;
 
- 			case '_startColor':
 
- 				$key = 'startcolor';
 
- 				break;
 
- 		}
 
- 		return $this->_parent->getStyleArray(array($key => $array));
 
- 	}
 
- 	/**
 
- 	 * Apply styles from array
 
- 	 *
 
- 	 * <code>
 
- 	 * $objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->getColor()->applyFromArray( array('rgb' => '808080') );
 
- 	 * </code>
 
- 	 *
 
- 	 * @param	array	$pStyles	Array containing style information
 
- 	 * @throws	PHPExcel_Exception
 
- 	 * @return PHPExcel_Style_Color
 
- 	 */
 
- 	public function applyFromArray($pStyles = NULL) {
 
- 		if (is_array($pStyles)) {
 
- 			if ($this->_isSupervisor) {
 
- 				$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles));
 
- 			} else {
 
- 				if (array_key_exists('rgb', $pStyles)) {
 
- 					$this->setRGB($pStyles['rgb']);
 
- 				}
 
- 				if (array_key_exists('argb', $pStyles)) {
 
- 					$this->setARGB($pStyles['argb']);
 
- 				}
 
- 			}
 
- 		} else {
 
- 			throw new PHPExcel_Exception("Invalid style array passed.");
 
- 		}
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get ARGB
 
- 	 *
 
- 	 * @return string
 
- 	 */
 
- 	public function getARGB() {
 
- 		if ($this->_isSupervisor) {
 
- 			return $this->getSharedComponent()->getARGB();
 
- 		}
 
- 		return $this->_argb;
 
- 	}
 
- 	/**
 
- 	 * Set ARGB
 
- 	 *
 
- 	 * @param string $pValue
 
- 	 * @return PHPExcel_Style_Color
 
- 	 */
 
- 	public function setARGB($pValue = PHPExcel_Style_Color::COLOR_BLACK) {
 
- 		if ($pValue == '') {
 
- 			$pValue = PHPExcel_Style_Color::COLOR_BLACK;
 
- 		}
 
- 		if ($this->_isSupervisor) {
 
- 			$styleArray = $this->getStyleArray(array('argb' => $pValue));
 
- 			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
 
- 		} else {
 
- 			$this->_argb = $pValue;
 
- 		}
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get RGB
 
- 	 *
 
- 	 * @return string
 
- 	 */
 
- 	public function getRGB() {
 
- 		if ($this->_isSupervisor) {
 
- 			return $this->getSharedComponent()->getRGB();
 
- 		}
 
- 		return substr($this->_argb, 2);
 
- 	}
 
- 	/**
 
- 	 * Set RGB
 
- 	 *
 
- 	 * @param	string	$pValue	RGB value
 
- 	 * @return PHPExcel_Style_Color
 
- 	 */
 
- 	public function setRGB($pValue = '000000') {
 
- 		if ($pValue == '') {
 
- 			$pValue = '000000';
 
- 		}
 
- 		if ($this->_isSupervisor) {
 
- 			$styleArray = $this->getStyleArray(array('argb' => 'FF' . $pValue));
 
- 			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
 
- 		} else {
 
- 			$this->_argb = 'FF' . $pValue;
 
- 		}
 
- 		return $this;
 
- 	}
 
- 	/**
 
- 	 * Get a specified colour component of an RGB value
 
- 	 *
 
- 	 * @private
 
- 	 * @param	string		$RGB		The colour as an RGB value (e.g. FF00CCCC or CCDDEE
 
- 	 * @param	int			$offset		Position within the RGB value to extract
 
- 	 * @param	boolean		$hex		Flag indicating whether the component should be returned as a hex or a
 
- 	 *									decimal value
 
- 	 * @return	string		The extracted colour component
 
- 	 */
 
- 	private static function _getColourComponent($RGB,$offset,$hex=TRUE) {
 
- 		$colour = substr($RGB, $offset, 2);
 
- 		if (!$hex)
 
- 			$colour = hexdec($colour);
 
- 		return $colour;
 
- 	}
 
- 	/**
 
- 	 * Get the red colour component of an RGB value
 
- 	 *
 
- 	 * @param	string		$RGB		The colour as an RGB value (e.g. FF00CCCC or CCDDEE
 
- 	 * @param	boolean		$hex		Flag indicating whether the component should be returned as a hex or a
 
- 	 *									decimal value
 
- 	 * @return	string		The red colour component
 
- 	 */
 
- 	public static function getRed($RGB,$hex=TRUE) {
 
- 		return self::_getColourComponent($RGB, strlen($RGB) - 6, $hex);
 
- 	}
 
- 	/**
 
- 	 * Get the green colour component of an RGB value
 
- 	 *
 
- 	 * @param	string		$RGB		The colour as an RGB value (e.g. FF00CCCC or CCDDEE
 
- 	 * @param	boolean		$hex		Flag indicating whether the component should be returned as a hex or a
 
- 	 *									decimal value
 
- 	 * @return	string		The green colour component
 
- 	 */
 
- 	public static function getGreen($RGB,$hex=TRUE) {
 
- 		return self::_getColourComponent($RGB, strlen($RGB) - 4, $hex);
 
- 	}
 
- 	/**
 
- 	 * Get the blue colour component of an RGB value
 
- 	 *
 
- 	 * @param	string		$RGB		The colour as an RGB value (e.g. FF00CCCC or CCDDEE
 
- 	 * @param	boolean		$hex		Flag indicating whether the component should be returned as a hex or a
 
- 	 *									decimal value
 
- 	 * @return	string		The blue colour component
 
- 	 */
 
- 	public static function getBlue($RGB,$hex=TRUE) {
 
- 		return self::_getColourComponent($RGB, strlen($RGB) - 2, $hex);
 
- 	}
 
- 	/**
 
- 	 * Adjust the brightness of a color
 
- 	 *
 
- 	 * @param	string		$hex	The colour as an RGBA or RGB value (e.g. FF00CCCC or CCDDEE)
 
- 	 * @param	float		$adjustPercentage	The percentage by which to adjust the colour as a float from -1 to 1
 
- 	 * @return	string		The adjusted colour as an RGBA or RGB value (e.g. FF00CCCC or CCDDEE)
 
- 	 */
 
- 	public static function changeBrightness($hex, $adjustPercentage) {
 
- 		$rgba = (strlen($hex) == 8);
 
- 		$red	= self::getRed($hex, FALSE);
 
- 		$green	= self::getGreen($hex, FALSE);
 
- 		$blue	= self::getBlue($hex, FALSE);
 
- 		if ($adjustPercentage > 0) {
 
- 			$red	+= (255 - $red) * $adjustPercentage;
 
- 			$green	+= (255 - $green) * $adjustPercentage;
 
- 			$blue	+= (255 - $blue) * $adjustPercentage;
 
- 		} else {
 
- 			$red	+= $red * $adjustPercentage;
 
- 			$green	+= $green * $adjustPercentage;
 
- 			$blue	+= $blue * $adjustPercentage;
 
- 		}
 
- 		if ($red < 0) $red = 0;
 
- 		elseif ($red > 255) $red = 255;
 
- 		if ($green < 0) $green = 0;
 
- 		elseif ($green > 255) $green = 255;
 
- 		if ($blue < 0) $blue = 0;
 
- 		elseif ($blue > 255) $blue = 255;
 
- 		$rgb = strtoupper(	str_pad(dechex($red), 2, '0', 0) .
 
- 							str_pad(dechex($green), 2, '0', 0) .
 
- 							str_pad(dechex($blue), 2, '0', 0)
 
- 						 );
 
- 		return (($rgba) ? 'FF' : '') . $rgb;
 
- 	}
 
- 	/**
 
- 	 * Get indexed color
 
- 	 *
 
- 	 * @param	int			$pIndex			Index entry point into the colour array
 
- 	 * @param	boolean		$background		Flag to indicate whether default background or foreground colour
 
- 	 *											should be returned if the indexed colour doesn't exist
 
- 	 * @return	PHPExcel_Style_Color
 
- 	 */
 
- 	public static function indexedColor($pIndex, $background=FALSE) {
 
- 		// Clean parameter
 
- 		$pIndex = intval($pIndex);
 
- 		// Indexed colors
 
- 		if (is_null(self::$_indexedColors)) {
 
- 			self::$_indexedColors = array(
 
- 					1	=> 'FF000000',	//	System Colour #1 - Black
 
- 					2	=> 'FFFFFFFF',	//	System Colour #2 - White
 
- 					3	=> 'FFFF0000',	//	System Colour #3 - Red
 
- 					4	=> 'FF00FF00',	//	System Colour #4 - Green
 
- 					5	=> 'FF0000FF',	//	System Colour #5 - Blue
 
- 					6	=> 'FFFFFF00',	//	System Colour #6 - Yellow
 
- 					7	=> 'FFFF00FF',	//	System Colour #7- Magenta
 
- 					8	=> 'FF00FFFF',	//	System Colour #8- Cyan
 
- 					9	=> 'FF800000',	//	Standard Colour #9
 
- 					10	=> 'FF008000',	//	Standard Colour #10
 
- 					11	=> 'FF000080',	//	Standard Colour #11
 
- 					12	=> 'FF808000',	//	Standard Colour #12
 
- 					13	=> 'FF800080',	//	Standard Colour #13
 
- 					14	=> 'FF008080',	//	Standard Colour #14
 
- 					15	=> 'FFC0C0C0',	//	Standard Colour #15
 
- 					16	=> 'FF808080',	//	Standard Colour #16
 
- 					17	=> 'FF9999FF',	//	Chart Fill Colour #17
 
- 					18	=> 'FF993366',	//	Chart Fill Colour #18
 
- 					19	=> 'FFFFFFCC',	//	Chart Fill Colour #19
 
- 					20	=> 'FFCCFFFF',	//	Chart Fill Colour #20
 
- 					21	=> 'FF660066',	//	Chart Fill Colour #21
 
- 					22	=> 'FFFF8080',	//	Chart Fill Colour #22
 
- 					23	=> 'FF0066CC',	//	Chart Fill Colour #23
 
- 					24	=> 'FFCCCCFF',	//	Chart Fill Colour #24
 
- 					25	=> 'FF000080',	//	Chart Line Colour #25
 
- 					26	=> 'FFFF00FF',	//	Chart Line Colour #26
 
- 					27	=> 'FFFFFF00',	//	Chart Line Colour #27
 
- 					28	=> 'FF00FFFF',	//	Chart Line Colour #28
 
- 					29	=> 'FF800080',	//	Chart Line Colour #29
 
- 					30	=> 'FF800000',	//	Chart Line Colour #30
 
- 					31	=> 'FF008080',	//	Chart Line Colour #31
 
- 					32	=> 'FF0000FF',	//	Chart Line Colour #32
 
- 					33	=> 'FF00CCFF',	//	Standard Colour #33
 
- 					34	=> 'FFCCFFFF',	//	Standard Colour #34
 
- 					35	=> 'FFCCFFCC',	//	Standard Colour #35
 
- 					36	=> 'FFFFFF99',	//	Standard Colour #36
 
- 					37	=> 'FF99CCFF',	//	Standard Colour #37
 
- 					38	=> 'FFFF99CC',	//	Standard Colour #38
 
- 					39	=> 'FFCC99FF',	//	Standard Colour #39
 
- 					40	=> 'FFFFCC99',	//	Standard Colour #40
 
- 					41	=> 'FF3366FF',	//	Standard Colour #41
 
- 					42	=> 'FF33CCCC',	//	Standard Colour #42
 
- 					43	=> 'FF99CC00',	//	Standard Colour #43
 
- 					44	=> 'FFFFCC00',	//	Standard Colour #44
 
- 					45	=> 'FFFF9900',	//	Standard Colour #45
 
- 					46	=> 'FFFF6600',	//	Standard Colour #46
 
- 					47	=> 'FF666699',	//	Standard Colour #47
 
- 					48	=> 'FF969696',	//	Standard Colour #48
 
- 					49	=> 'FF003366',	//	Standard Colour #49
 
- 					50	=> 'FF339966',	//	Standard Colour #50
 
- 					51	=> 'FF003300',	//	Standard Colour #51
 
- 					52	=> 'FF333300',	//	Standard Colour #52
 
- 					53	=> 'FF993300',	//	Standard Colour #53
 
- 					54	=> 'FF993366',	//	Standard Colour #54
 
- 					55	=> 'FF333399',	//	Standard Colour #55
 
- 					56	=> 'FF333333'	//	Standard Colour #56
 
- 				);
 
- 		}
 
- 		if (array_key_exists($pIndex, self::$_indexedColors)) {
 
- 			return new PHPExcel_Style_Color(self::$_indexedColors[$pIndex]);
 
- 		}
 
- 		if ($background) {
 
- 			return new PHPExcel_Style_Color('FFFFFFFF');
 
- 		}
 
- 		return new PHPExcel_Style_Color('FF000000');
 
- 	}
 
- 	/**
 
- 	 * Get hash code
 
- 	 *
 
- 	 * @return string	Hash code
 
- 	 */
 
- 	public function getHashCode() {
 
- 		if ($this->_isSupervisor) {
 
- 			return $this->getSharedComponent()->getHashCode();
 
- 		}
 
- 		return md5(
 
- 			  $this->_argb
 
- 			. __CLASS__
 
- 		);
 
- 	}
 
- }
 
 
  |