Subversion Repositories eFlore/Applications.cel

<?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_Worksheet

 * @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_Worksheet_AutoFilter_Column

 *

 * @category	PHPExcel

 * @package		PHPExcel_Worksheet

 * @copyright	Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 */

class PHPExcel_Worksheet_AutoFilter_Column

{

	const AUTOFILTER_FILTERTYPE_FILTER			= 'filters';

	const AUTOFILTER_FILTERTYPE_CUSTOMFILTER	= 'customFilters';

	//	Supports no more than 2 rules, with an And/Or join criteria

	//		if more than 1 rule is defined

	const AUTOFILTER_FILTERTYPE_DYNAMICFILTER	= 'dynamicFilter';

	//	Even though the filter rule is constant, the filtered data can vary

	//		e.g. filtered by date = TODAY

	const AUTOFILTER_FILTERTYPE_TOPTENFILTER	= 'top10';

	/**

	 * Types of autofilter rules

	 *

	 * @var string[]

	 */

	private static $_filterTypes = array(

		//	Currently we're not handling

		//		colorFilter

		//		extLst

		//		iconFilter

		self::AUTOFILTER_FILTERTYPE_FILTER,

		self::AUTOFILTER_FILTERTYPE_CUSTOMFILTER,

		self::AUTOFILTER_FILTERTYPE_DYNAMICFILTER,

		self::AUTOFILTER_FILTERTYPE_TOPTENFILTER,

	);

	/* Multiple Rule Connections */

	const AUTOFILTER_COLUMN_JOIN_AND	= 'and';

	const AUTOFILTER_COLUMN_JOIN_OR		= 'or';

	/**

	 * Join options for autofilter rules

	 *

	 * @var string[]

	 */

	private static $_ruleJoins = array(

		self::AUTOFILTER_COLUMN_JOIN_AND,

		self::AUTOFILTER_COLUMN_JOIN_OR,

	);

	/**

	 * Autofilter

	 *

	 * @var PHPExcel_Worksheet_AutoFilter

	 */

	private $_parent = NULL;

	/**

	 * Autofilter Column Index

	 *

	 * @var string

	 */

	private $_columnIndex = '';

	/**

	 * Autofilter Column Filter Type

	 *

	 * @var string

	 */

	private $_filterType = self::AUTOFILTER_FILTERTYPE_FILTER;

	/**

	 * Autofilter Multiple Rules And/Or

	 *

	 * @var string

	 */

	private $_join = self::AUTOFILTER_COLUMN_JOIN_OR;

	/**

	 * Autofilter Column Rules

	 *

	 * @var array of PHPExcel_Worksheet_AutoFilter_Column_Rule

	 */

	private $_ruleset = array();

	/**

	 * Autofilter Column Dynamic Attributes

	 *

	 * @var array of mixed

	 */

	private $_attributes = array();

	/**

	 * Create a new PHPExcel_Worksheet_AutoFilter_Column

	 *

	 *	@param	string		                   $pColumn		Column (e.g. A)

	 *	@param	PHPExcel_Worksheet_AutoFilter  $pParent		Autofilter for this column

	 */

	public function __construct($pColumn, PHPExcel_Worksheet_AutoFilter $pParent = NULL)

	{

		$this->_columnIndex = $pColumn;

		$this->_parent = $pParent;

	}

	/**

	 * Get AutoFilter Column Index

	 *

	 * @return string

	 */

	public function getColumnIndex() {

		return $this->_columnIndex;

	}

	/**

	 *	Set AutoFilter Column Index

	 *

	 *	@param	string		$pColumn		Column (e.g. A)

	 *	@throws	PHPExcel_Exception

	 *	@return PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function setColumnIndex($pColumn) {

		// Uppercase coordinate

		$pColumn = strtoupper($pColumn);

		if ($this->_parent !== NULL) {

			$this->_parent->testColumnInRange($pColumn);

		}

		$this->_columnIndex = $pColumn;

		return $this;

	}

	/**

	 * Get this Column's AutoFilter Parent

	 *

	 * @return PHPExcel_Worksheet_AutoFilter

	 */

	public function getParent() {

		return $this->_parent;

	}

	/**

	 * Set this Column's AutoFilter Parent

	 *

	 * @param PHPExcel_Worksheet_AutoFilter

	 * @return PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function setParent(PHPExcel_Worksheet_AutoFilter $pParent = NULL) {

		$this->_parent = $pParent;

		return $this;

	}

	/**

	 * Get AutoFilter Type

	 *

	 * @return string

	 */

	public function getFilterType() {

		return $this->_filterType;

	}

	/**

	 *	Set AutoFilter Type

	 *

	 *	@param	string		$pFilterType

	 *	@throws	PHPExcel_Exception

	 *	@return PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function setFilterType($pFilterType = self::AUTOFILTER_FILTERTYPE_FILTER) {

		if (!in_array($pFilterType,self::$_filterTypes)) {

			throw new PHPExcel_Exception('Invalid filter type for column AutoFilter.');

		}

		$this->_filterType = $pFilterType;

		return $this;

	}

	/**

	 * Get AutoFilter Multiple Rules And/Or Join

	 *

	 * @return string

	 */

	public function getJoin() {

		return $this->_join;

	}

	/**

	 *	Set AutoFilter Multiple Rules And/Or

	 *

	 *	@param	string		$pJoin		And/Or

	 *	@throws	PHPExcel_Exception

	 *	@return PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function setJoin($pJoin = self::AUTOFILTER_COLUMN_JOIN_OR) {

		// Lowercase And/Or

		$pJoin = strtolower($pJoin);

		if (!in_array($pJoin,self::$_ruleJoins)) {

			throw new PHPExcel_Exception('Invalid rule connection for column AutoFilter.');

		}

		$this->_join = $pJoin;

		return $this;

	}

	/**

	 *	Set AutoFilter Attributes

	 *

	 *	@param	string[]		$pAttributes

	 *	@throws	PHPExcel_Exception

	 *	@return PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function setAttributes($pAttributes = array()) {

		$this->_attributes = $pAttributes;

		return $this;

	}

	/**

	 *	Set An AutoFilter Attribute

	 *

	 *	@param	string		$pName		Attribute Name

	 *	@param	string		$pValue		Attribute Value

	 *	@throws	PHPExcel_Exception

	 *	@return PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function setAttribute($pName, $pValue) {

		$this->_attributes[$pName] = $pValue;

		return $this;

	}

	/**

	 * Get AutoFilter Column Attributes

	 *

	 * @return string

	 */

	public function getAttributes() {

		return $this->_attributes;

	}

	/**

	 * Get specific AutoFilter Column Attribute

	 *

	 *	@param	string		$pName		Attribute Name

	 * @return string

	 */

	public function getAttribute($pName) {

		if (isset($this->_attributes[$pName]))

			return $this->_attributes[$pName];

		return NULL;

	}

	/**

	 * Get all AutoFilter Column Rules

	 *

	 * @throws	PHPExcel_Exception

	 * @return array of PHPExcel_Worksheet_AutoFilter_Column_Rule

	 */

	public function getRules() {

		return $this->_ruleset;

	}

	/**

	 * Get a specified AutoFilter Column Rule

	 *

	 * @param	integer	$pIndex		Rule index in the ruleset array

	 * @return	PHPExcel_Worksheet_AutoFilter_Column_Rule

	 */

	public function getRule($pIndex) {

		if (!isset($this->_ruleset[$pIndex])) {

			$this->_ruleset[$pIndex] = new PHPExcel_Worksheet_AutoFilter_Column_Rule($this);

		}

		return $this->_ruleset[$pIndex];

	}

	/**

	 * Create a new AutoFilter Column Rule in the ruleset

	 *

	 * @return	PHPExcel_Worksheet_AutoFilter_Column_Rule

	 */

	public function createRule() {

		$this->_ruleset[] = new PHPExcel_Worksheet_AutoFilter_Column_Rule($this);

		return end($this->_ruleset);

	}

	/**

	 * Add a new AutoFilter Column Rule to the ruleset

	 *

	 * @param	PHPExcel_Worksheet_AutoFilter_Column_Rule	$pRule

	 * @param	boolean	$returnRule 	Flag indicating whether the rule object or the column object should be returned

	 * @return	PHPExcel_Worksheet_AutoFilter_Column|PHPExcel_Worksheet_AutoFilter_Column_Rule

	 */

	public function addRule(PHPExcel_Worksheet_AutoFilter_Column_Rule $pRule, $returnRule=TRUE) {

		$pRule->setParent($this);

		$this->_ruleset[] = $pRule;

		return ($returnRule) ? $pRule : $this;

	}

	/**

	 * Delete a specified AutoFilter Column Rule

	 *	If the number of rules is reduced to 1, then we reset And/Or logic to Or

	 *

	 * @param	integer	$pIndex		Rule index in the ruleset array

	 * @return	PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function deleteRule($pIndex) {

		if (isset($this->_ruleset[$pIndex])) {

			unset($this->_ruleset[$pIndex]);

			//	If we've just deleted down to a single rule, then reset And/Or joining to Or

			if (count($this->_ruleset) <= 1) {

				$this->setJoin(self::AUTOFILTER_COLUMN_JOIN_OR);

			}

		}

		return $this;

	}

	/**

	 * Delete all AutoFilter Column Rules

	 *

	 * @return	PHPExcel_Worksheet_AutoFilter_Column

	 */

	public function clearRules() {

		$this->_ruleset = array();

		$this->setJoin(self::AUTOFILTER_COLUMN_JOIN_OR);

		return $this;

	}

	/**

	 * Implement PHP __clone to create a deep clone, not just a shallow copy.

	 */

	public function __clone() {

		$vars = get_object_vars($this);

		foreach ($vars as $key => $value) {

			if (is_object($value)) {

				if ($key == '_parent') {

					//	Detach from autofilter parent

					$this->$key = NULL;

				} else {

					$this->$key = clone $value;

				}

			} elseif ((is_array($value)) && ($key == '_ruleset')) {

				//	The columns array of PHPExcel_Worksheet_AutoFilter objects

				$this->$key = array();

				foreach ($value as $k => $v) {

					$this->$key[$k] = clone $v;

					// attach the new cloned Rule to this new cloned Autofilter Cloned object

					$this->$key[$k]->setParent($this);

				}

			} else {

				$this->$key = $value;

			}

		}

	}

}