<?php
namespace PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter;
use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;
use PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter;
class 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 = [
// 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 = [
self::AUTOFILTER_COLUMN_JOIN_AND,
self::AUTOFILTER_COLUMN_JOIN_OR,
];
/**
* Autofilter.
*
< * @var AutoFilter
> * @var null|AutoFilter
*/
private $parent;
/**
* 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 Column\Rule
> * @var Column\Rule[]
*/
private $ruleset = [];
/**
* Autofilter Column Dynamic Attributes.
*
< * @var array of mixed
> * @var mixed[]
*/
private $attributes = [];
/**
* Create a new Column.
*
< * @param string $pColumn Column (e.g. A)
< * @param AutoFilter $pParent Autofilter for this column
> * @param string $column Column (e.g. A)
> * @param AutoFilter $parent Autofilter for this column
*/
< public function __construct($pColumn, AutoFilter $pParent = null)
> public function __construct($column, ?AutoFilter $parent = null)
{
< $this->columnIndex = $pColumn;
< $this->parent = $pParent;
> $this->columnIndex = $column;
> $this->parent = $parent;
> }
>
> public function setEvaluatedFalse(): void
> {
> if ($this->parent !== null) {
> $this->parent->setEvaluated(false);
> }
}
/**
* Get AutoFilter column index as string eg: 'A'.
*
* @return string
*/
public function getColumnIndex()
{
return $this->columnIndex;
}
/**
* Set AutoFilter column index as string eg: 'A'.
*
< * @param string $pColumn Column (e.g. A)
< *
< * @throws PhpSpreadsheetException
> * @param string $column Column (e.g. A)
*
< * @return Column
> * @return $this
*/
< public function setColumnIndex($pColumn)
> public function setColumnIndex($column)
{
> $this->setEvaluatedFalse();
// Uppercase coordinate
< $pColumn = strtoupper($pColumn);
> $column = strtoupper($column);
if ($this->parent !== null) {
< $this->parent->testColumnInRange($pColumn);
> $this->parent->testColumnInRange($column);
}
< $this->columnIndex = $pColumn;
> $this->columnIndex = $column;
return $this;
}
/**
* Get this Column's AutoFilter Parent.
*
< * @return AutoFilter
> * @return null|AutoFilter
*/
public function getParent()
{
return $this->parent;
}
/**
* Set this Column's AutoFilter Parent.
*
< * @param AutoFilter $pParent
< *
< * @return Column
> * @return $this
*/
< public function setParent(AutoFilter $pParent = null)
> public function setParent(?AutoFilter $parent = null)
{
< $this->parent = $pParent;
> $this->setEvaluatedFalse();
> $this->parent = $parent;
return $this;
}
/**
* Get AutoFilter Type.
*
* @return string
*/
public function getFilterType()
{
return $this->filterType;
}
/**
* Set AutoFilter Type.
*
< * @param string $pFilterType
< *
< * @throws PhpSpreadsheetException
> * @param string $filterType
*
< * @return Column
> * @return $this
*/
< public function setFilterType($pFilterType)
> public function setFilterType($filterType)
{
< if (!in_array($pFilterType, self::$filterTypes)) {
> $this->setEvaluatedFalse();
> if (!in_array($filterType, self::$filterTypes)) {
throw new PhpSpreadsheetException('Invalid filter type for column AutoFilter.');
}
> if ($filterType === self::AUTOFILTER_FILTERTYPE_CUSTOMFILTER && count($this->ruleset) > 2) {
> throw new PhpSpreadsheetException('No more than 2 rules are allowed in a Custom Filter');
$this->filterType = $pFilterType;
> }
< $this->filterType = $pFilterType;
> $this->filterType = $filterType;
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 PhpSpreadsheetException
> * @param string $join And/Or
*
< * @return Column
> * @return $this
*/
< public function setJoin($pJoin)
> public function setJoin($join)
{
> $this->setEvaluatedFalse();
// Lowercase And/Or
< $pJoin = strtolower($pJoin);
< if (!in_array($pJoin, self::$ruleJoins)) {
> $join = strtolower($join);
> if (!in_array($join, self::$ruleJoins)) {
throw new PhpSpreadsheetException('Invalid rule connection for column AutoFilter.');
}
< $this->join = $pJoin;
> $this->join = $join;
return $this;
}
/**
* Set AutoFilter Attributes.
*
< * @param string[] $attributes
> * @param mixed[] $attributes
*
< * @return Column
> * @return $this
*/
< public function setAttributes(array $attributes)
> public function setAttributes($attributes)
{
> $this->setEvaluatedFalse();
$this->attributes = $attributes;
return $this;
}
/**
* Set An AutoFilter Attribute.
*
< * @param string $pName Attribute Name
< * @param string $pValue Attribute Value
> * @param string $name Attribute Name
> * @param string $value Attribute Value
*
< * @return Column
> * @return $this
*/
< public function setAttribute($pName, $pValue)
> public function setAttribute($name, $value)
{
< $this->attributes[$pName] = $pValue;
> $this->setEvaluatedFalse();
> $this->attributes[$name] = $value;
return $this;
}
/**
* Get AutoFilter Column Attributes.
*
< * @return string[]
> * @return int[]|string[]
*/
public function getAttributes()
{
return $this->attributes;
}
/**
* Get specific AutoFilter Column Attribute.
*
< * @param string $pName Attribute Name
> * @param string $name Attribute Name
*
< * @return string
> * @return null|int|string
*/
< public function getAttribute($pName)
> public function getAttribute($name)
{
< if (isset($this->attributes[$pName])) {
< return $this->attributes[$pName];
> if (isset($this->attributes[$name])) {
> return $this->attributes[$name];
}
return null;
}
> public function ruleCount(): int
/**
> {
* Get all AutoFilter Column Rules.
> return count($this->ruleset);
*
> }
* @return Column\Rule[]
>
*/
public function getRules()
{
return $this->ruleset;
}
/**
* Get a specified AutoFilter Column Rule.
*
< * @param int $pIndex Rule index in the ruleset array
> * @param int $index Rule index in the ruleset array
*
* @return Column\Rule
*/
< public function getRule($pIndex)
> public function getRule($index)
{
< if (!isset($this->ruleset[$pIndex])) {
< $this->ruleset[$pIndex] = new Column\Rule($this);
> if (!isset($this->ruleset[$index])) {
> $this->ruleset[$index] = new Column\Rule($this);
}
< return $this->ruleset[$pIndex];
> return $this->ruleset[$index];
}
/**
* Create a new AutoFilter Column Rule in the ruleset.
*
* @return Column\Rule
*/
public function createRule()
{
> $this->setEvaluatedFalse();
$this->ruleset[] = new Column\Rule($this);
> if ($this->filterType === self::AUTOFILTER_FILTERTYPE_CUSTOMFILTER && count($this->ruleset) >= 2) {
> throw new PhpSpreadsheetException('No more than 2 rules are allowed in a Custom Filter');
return end($this->ruleset);
> }
}
/**
* Add a new AutoFilter Column Rule to the ruleset.
*
< * @param Column\Rule $pRule
< *
< * @return Column
> * @return $this
*/
< public function addRule(Column\Rule $pRule)
> public function addRule(Column\Rule $rule)
{
< $pRule->setParent($this);
< $this->ruleset[] = $pRule;
> $this->setEvaluatedFalse();
> $rule->setParent($this);
> $this->ruleset[] = $rule;
return $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 int $pIndex Rule index in the ruleset array
> * @param int $index Rule index in the ruleset array
*
< * @return Column
> * @return $this
*/
< public function deleteRule($pIndex)
> public function deleteRule($index)
{
< if (isset($this->ruleset[$pIndex])) {
< unset($this->ruleset[$pIndex]);
> $this->setEvaluatedFalse();
> if (isset($this->ruleset[$index])) {
> unset($this->ruleset[$index]);
// 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 Column
> * @return $this
*/
public function clearRules()
{
> $this->setEvaluatedFalse();
$this->ruleset = [];
$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 ($key === 'parent') {
// Detach from autofilter parent
$this->parent = null;
} elseif ($key === 'ruleset') {
// The columns array of \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\AutoFilter objects
$this->ruleset = [];
foreach ($value as $k => $v) {
$cloned = clone $v;
$cloned->setParent($this); // attach the new cloned Rule to this new cloned Autofilter Cloned object
$this->ruleset[$k] = $cloned;
}
< } elseif (is_object($value)) {
< $this->$key = clone $value;
} else {
$this->$key = $value;
}
}
}
}