PHPOffice /
PhpSpreadsheet
| @@ 1047-1050 (lines=4) @@ | ||
| 1044 | } |
|
| 1045 | // Standard filters are always an OR join, so no join rule needs to be set |
|
| 1046 | // Entries can be either filter elements |
|
| 1047 | foreach ($filters->filter as $filterRule) { |
|
| 1048 | // Operator is undefined, but always treated as EQUAL |
|
| 1049 | $column->createRule()->setRule(null, (string) $filterRule['val'])->setRuleType(Column\Rule::AUTOFILTER_RULETYPE_FILTER); |
|
| 1050 | } |
|
| 1051 | // Or Date Group elements |
|
| 1052 | foreach ($filters->dateGroupItem as $dateGroupItem) { |
|
| 1053 | $column->createRule()->setRule( |
|
| @@ 1078-1084 (lines=7) @@ | ||
| 1075 | if ((isset($customFilters['and'])) && ($customFilters['and'] == 1)) { |
|
| 1076 | $column->setJoin(Column::AUTOFILTER_COLUMN_JOIN_AND); |
|
| 1077 | } |
|
| 1078 | foreach ($customFilters->customFilter as $filterRule) { |
|
| 1079 | $column->createRule()->setRule( |
|
| 1080 | (string) $filterRule['operator'], |
|
| 1081 | (string) $filterRule['val'] |
|
| 1082 | ) |
|
| 1083 | ->setRuleType(Column\Rule::AUTOFILTER_RULETYPE_CUSTOMFILTER); |
|
| 1084 | } |
|
| 1085 | } |
|
| 1086 | // Check for dynamic filters |
|
| 1087 | if ($filterColumn->dynamicFilter) { |
|
