Subversion Repositories eFlore/Applications.cel

Rev

Rev 2388 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2388 Rev 2432
Line -... Line 1...
- 
 
 1 
<?php
- 
 
 2 
/**
- 
 
 3 
 * PHPExcel
- 
 
 4 
 *
- 
 
 5 
 * Copyright (c) 2006 - 2013 PHPExcel
- 
 
 6 
 *
- 
 
 7 
 * This library is free software; you can redistribute it and/or
- 
 
 8 
 * modify it under the terms of the GNU Lesser General Public
- 
 
 9 
 * License as published by the Free Software Foundation; either
- 
 
 10 
 * version 2.1 of the License, or (at your option) any later version.
- 
 
 11 
 *
- 
 
 12 
 * This library is distributed in the hope that it will be useful,
- 
 
 13 
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
- 
 
 14 
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
- 
 
 15 
 * Lesser General Public License for more details.
- 
 
 16 
 *
- 
 
 17 
 * You should have received a copy of the GNU Lesser General Public
- 
 
 18 
 * License along with this library; if not, write to the Free Software
- 
 
 19 
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
- 
 
 20 
 *
- 
 
 21 
 * @category   PHPExcel
- 
 
 22 
 * @package    PHPExcel_Style
- 
 
 23 
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
- 
 
 24 
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
- 
 
 25 
 * @version    1.4.5, 2007-08-23
- 
 
 26 
 */
- 
 
 27 
 
- 
 
 28 
 
- 
 
 29 
/**
- 
 
 30 
 * PHPExcel_Style_Protection
- 
 
 31 
 *
- 
 
 32 
 * @category   PHPExcel
- 
 
 33 
 * @package    PHPExcel_Style
- 
 
 34 
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
- 
 
 35 
 */
- 
 
 36 
class PHPExcel_Style_Protection extends PHPExcel_Style_Supervisor implements PHPExcel_IComparable
- 
 
 37 
{
- 
 
 38 
	/** Protection styles */
- 
 
 39 
	const PROTECTION_INHERIT		= 'inherit';
- 
 
 40 
	const PROTECTION_PROTECTED		= 'protected';
- 
 
 41 
	const PROTECTION_UNPROTECTED	= 'unprotected';
- 
 
 42 
 
- 
 
 43 
	/**
- 
 
 44 
	 * Locked
- 
 
 45 
	 *
- 
 
 46 
	 * @var string
- 
 
 47 
	 */
- 
 
 48 
	protected $_locked;
- 
 
 49 
 
- 
 
 50 
	/**
- 
 
 51 
	 * Hidden
- 
 
 52 
	 *
- 
 
 53 
	 * @var string
- 
 
 54 
	 */
- 
 
 55 
	protected $_hidden;
- 
 
 56 
 
- 
 
 57 
	/**
- 
 
 58 
     * Create a new PHPExcel_Style_Protection
- 
 
 59 
	 *
- 
 
 60 
	 * @param	boolean	$isSupervisor	Flag indicating if this is a supervisor or not
- 
 
 61 
	 *									Leave this value at default unless you understand exactly what
- 
 
 62 
	 *										its ramifications are
- 
 
 63 
	 * @param	boolean	$isConditional	Flag indicating if this is a conditional style or not
- 
 
 64 
	 *									Leave this value at default unless you understand exactly what
- 
 
 65 
	 *										its ramifications are
- 
 
 66 
     */
- 
 
 67 
    public function __construct($isSupervisor = FALSE, $isConditional = FALSE)
- 
 
 68 
    {
- 
 
 69 
    	// Supervisor?
- 
 
 70 
		parent::__construct($isSupervisor);
- 
 
 71 
 
- 
 
 72 
    	// Initialise values
- 
 
 73 
		if (!$isConditional) {
- 
 
 74 
	    	$this->_locked			= self::PROTECTION_INHERIT;
- 
 
 75 
	    	$this->_hidden			= self::PROTECTION_INHERIT;
- 
 
 76 
		}
- 
 
 77 
    }
- 
 
 78 
 
- 
 
 79 
	/**
- 
 
 80 
	 * Get the shared style component for the currently active cell in currently active sheet.
- 
 
 81 
	 * Only used for style supervisor
- 
 
 82 
	 *
- 
 
 83 
	 * @return PHPExcel_Style_Protection
- 
 
 84 
	 */
- 
 
 85 
	public function getSharedComponent()
- 
 
 86 
	{
- 
 
 87 
		return $this->_parent->getSharedComponent()->getProtection();
- 
 
 88 
	}
- 
 
 89 
 
- 
 
 90 
	/**
- 
 
 91 
	 * Build style array from subcomponents
- 
 
 92 
	 *
- 
 
 93 
	 * @param array $array
- 
 
 94 
	 * @return array
- 
 
 95 
	 */
- 
 
 96 
	public function getStyleArray($array)
- 
 
 97 
	{
- 
 
 98 
		return array('protection' => $array);
- 
 
 99 
	}
- 
 
 100 
 
- 
 
 101 
    /**
- 
 
 102 
     * Apply styles from array
- 
 
 103 
     *
- 
 
 104 
     * <code>
- 
 
 105 
     * $objPHPExcel->getActiveSheet()->getStyle('B2')->getLocked()->applyFromArray(
- 
 
 106 
     *		array(
- 
 
 107 
     *			'locked' => TRUE,
- 
 
 108 
     *			'hidden' => FALSE
- 
 
 109 
     *		)
- 
 
 110 
     * );
- 
 
 111 
     * </code>
- 
 
 112 
     *
- 
 
 113 
     * @param	array	$pStyles	Array containing style information
- 
 
 114 
     * @throws	PHPExcel_Exception
- 
 
 115 
     * @return PHPExcel_Style_Protection
- 
 
 116 
     */
- 
 
 117 
	public function applyFromArray($pStyles = NULL) {
- 
 
 118 
		if (is_array($pStyles)) {
- 
 
 119 
			if ($this->_isSupervisor) {
- 
 
 120 
				$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles));
- 
 
 121 
			} else {
- 
 
 122 
				if (isset($pStyles['locked'])) {
- 
 
 123 
					$this->setLocked($pStyles['locked']);
- 
 
 124 
				}
- 
 
 125 
				if (isset($pStyles['hidden'])) {
- 
 
 126 
					$this->setHidden($pStyles['hidden']);
- 
 
 127 
				}
- 
 
 128 
			}
- 
 
 129 
		} else {
- 
 
 130 
			throw new PHPExcel_Exception("Invalid style array passed.");
- 
 
 131 
		}
- 
 
 132 
		return $this;
- 
 
 133 
	}
- 
 
 134 
 
- 
 
 135 
    /**
- 
 
 136 
     * Get locked
- 
 
 137 
     *
- 
 
 138 
     * @return string
- 
 
 139 
     */
- 
 
 140 
    public function getLocked() {
- 
 
 141 
		if ($this->_isSupervisor) {
- 
 
 142 
			return $this->getSharedComponent()->getLocked();
- 
 
 143 
		}
- 
 
 144 
    	return $this->_locked;
- 
 
 145 
    }
- 
 
 146 
 
- 
 
 147 
    /**
- 
 
 148 
     * Set locked
- 
 
 149 
     *
- 
 
 150 
     * @param string $pValue
- 
 
 151 
     * @return PHPExcel_Style_Protection
- 
 
 152 
     */
- 
 
 153 
    public function setLocked($pValue = self::PROTECTION_INHERIT) {
- 
 
 154 
		if ($this->_isSupervisor) {
- 
 
 155 
			$styleArray = $this->getStyleArray(array('locked' => $pValue));
- 
 
 156 
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
- 
 
 157 
		} else {
- 
 
 158 
			$this->_locked = $pValue;
- 
 
 159 
		}
- 
 
 160 
		return $this;
- 
 
 161 
    }
- 
 
 162 
 
- 
 
 163 
    /**
- 
 
 164 
     * Get hidden
- 
 
 165 
     *
- 
 
 166 
     * @return string
- 
 
 167 
     */
- 
 
 168 
    public function getHidden() {
- 
 
 169 
		if ($this->_isSupervisor) {
- 
 
 170 
			return $this->getSharedComponent()->getHidden();
- 
 
 171 
		}
- 
 
 172 
    	return $this->_hidden;
- 
 
 173 
    }
- 
 
 174 
 
- 
 
 175 
    /**
- 
 
 176 
     * Set hidden
- 
 
 177 
     *
- 
 
 178 
     * @param string $pValue
- 
 
 179 
     * @return PHPExcel_Style_Protection
- 
 
 180 
     */
- 
 
 181 
    public function setHidden($pValue = self::PROTECTION_INHERIT) {
- 
 
 182 
		if ($this->_isSupervisor) {
- 
 
 183 
			$styleArray = $this->getStyleArray(array('hidden' => $pValue));
- 
 
 184 
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
- 
 
 185 
		} else {
- 
 
 186 
			$this->_hidden = $pValue;
- 
 
 187 
		}
- 
 
 188 
		return $this;
- 
 
 189 
    }
- 
 
 190 
 
- 
 
 191 
	/**
- 
 
 192 
	 * Get hash code
- 
 
 193 
	 *
- 
 
 194 
	 * @return string	Hash code
- 
 
 195 
	 */
- 
 
 196 
	public function getHashCode() {
- 
 
 197 
		if ($this->_isSupervisor) {
- 
 
 198 
			return $this->getSharedComponent()->getHashCode();
- 
 
 199 
		}
- 
 
 200 
    	return md5(
- 
 
 201 
    		  $this->_locked
- 
 
 202 
    		. $this->_hidden
- 
 
 203 
    		. __CLASS__
- 
 
 204 
    	);
- 
 
 205 
    }
- 
 
 206 
 
- 
 
 207 
}