Document

Operation	:	Linux server.tradinguniversity.rs 3.10.0-1160.119.1.vz7.224.4 #1 SMP Mon Sep 30 15:36:27 MSK 2024 x86_64
Software	:	Apache
Server IP	:	68.66.251.59 \| Your IP: 216.73.216.158
Domains	:	4 Domain
Permission	:	[ drwxr-xr-x ]

/ home / tradinguniversit / public_html / vendor / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Writer / Xlsx /

Web File Manager

主页上传上传 V2 命令行

AutoFilter.php

<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;

use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
use PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column;
use PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column\Rule;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet as ActualWorksheet;

class AutoFilter extends WriterPart
{
    /**
     * Write AutoFilter.
     */
    public static function writeAutoFilter(XMLWriter $objWriter, ActualWorksheet $worksheet): void
    {
        $autoFilterRange = $worksheet->getAutoFilter()->getRange();
        if (!empty($autoFilterRange)) {
            // autoFilter
            $objWriter->startElement('autoFilter');

// Strip any worksheet reference from the filter coordinates
            $range = Coordinate::splitRange($autoFilterRange);
            $range = $range[0];
            //    Strip any worksheet ref
            [$ws, $range[0]] = ActualWorksheet::extractSheetTitle($range[0], true);
            $range = implode(':', $range);

$objWriter->writeAttribute('ref', str_replace('$', '', $range));

$columns = $worksheet->getAutoFilter()->getColumns();
            if (count($columns) > 0) {
                foreach ($columns as $columnID => $column) {
                    $colId = $worksheet->getAutoFilter()->getColumnOffset($columnID);
                    self::writeAutoFilterColumn($objWriter, $column, $colId);
                }
            }
            $objWriter->endElement();
        }
    }

/**
     * Write AutoFilter's filterColumn.
     */
    public static function writeAutoFilterColumn(XMLWriter $objWriter, Column $column, int $colId): void
    {
        $rules = $column->getRules();
        if (count($rules) > 0) {
            $objWriter->startElement('filterColumn');
            $objWriter->writeAttribute('colId', "$colId");

$objWriter->startElement($column->getFilterType());
            if ($column->getJoin() == Column::AUTOFILTER_COLUMN_JOIN_AND) {
                $objWriter->writeAttribute('and', '1');
            }

foreach ($rules as $rule) {
                self::writeAutoFilterColumnRule($column, $rule, $objWriter);
            }

$objWriter->endElement();

$objWriter->endElement();
        }
    }

/**
     * Write AutoFilter's filterColumn Rule.
     */
    private static function writeAutoFilterColumnRule(Column $column, Rule $rule, XMLWriter $objWriter): void
    {
        if (
            ($column->getFilterType() === Column::AUTOFILTER_FILTERTYPE_FILTER) &&
            ($rule->getOperator() === Rule::AUTOFILTER_COLUMN_RULE_EQUAL) &&
            ($rule->getValue() === '')
        ) {
            //    Filter rule for Blanks
            $objWriter->writeAttribute('blank', '1');
        } elseif ($rule->getRuleType() === Rule::AUTOFILTER_RULETYPE_DYNAMICFILTER) {
            //    Dynamic Filter Rule
            $objWriter->writeAttribute('type', $rule->getGrouping());
            $val = $column->getAttribute('val');
            if ($val !== null) {
                $objWriter->writeAttribute('val', "$val");
            }
            $maxVal = $column->getAttribute('maxVal');
            if ($maxVal !== null) {
                $objWriter->writeAttribute('maxVal', "$maxVal");
            }
        } elseif ($rule->getRuleType() === Rule::AUTOFILTER_RULETYPE_TOPTENFILTER) {
            //    Top 10 Filter Rule
            $ruleValue = $rule->getValue();
            if (!is_array($ruleValue)) {
                $objWriter->writeAttribute('val', "$ruleValue");
            }
            $objWriter->writeAttribute('percent', (($rule->getOperator() === Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_PERCENT) ? '1' : '0'));
            $objWriter->writeAttribute('top', (($rule->getGrouping() === Rule::AUTOFILTER_COLUMN_RULE_TOPTEN_TOP) ? '1' : '0'));
        } else {
            //    Filter, DateGroupItem or CustomFilter
            $objWriter->startElement($rule->getRuleType());

if ($rule->getOperator() !== Rule::AUTOFILTER_COLUMN_RULE_EQUAL) {
                $objWriter->writeAttribute('operator', $rule->getOperator());
            }
            if ($rule->getRuleType() === Rule::AUTOFILTER_RULETYPE_DATEGROUP) {
                // Date Group filters
                $ruleValue = $rule->getValue();
                if (is_array($ruleValue)) {
                    foreach ($ruleValue as $key => $value) {
                        $objWriter->writeAttribute($key, "$value");
                    }
                }
                $objWriter->writeAttribute('dateTimeGrouping', $rule->getGrouping());
            } else {
                $ruleValue = $rule->getValue();
                if (!is_array($ruleValue)) {
                    $objWriter->writeAttribute('val', "$ruleValue");
                }
            }

$objWriter->endElement();
        }
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	tradinguniversit/tradinguniversit	drwxr-xr-x	2025-02-08 02:56:14
..	dir	-	tradinguniversit/tradinguniversit	drwxr-xr-x	2025-02-08 02:56:14
AutoFilter.php	text/x-php	4.83 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Chart.php	text/x-php	74.72 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Comments.php	text/x-php	7.75 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
ContentTypes.php	text/x-php	11.88 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
DefinedNames.php	text/x-php	8.52 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
DocProps.php	text/x-php	8.58 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Drawing.php	text/x-php	21.29 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
FunctionPrefix.php	text/x-php	4.82 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Rels.php	text/x-php	16.24 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
RelsRibbon.php	text/x-php	1.52 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
RelsVBA.php	text/x-php	1.24 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
StringTable.php	text/x-php	12.85 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Style.php	text/x-php	26.69 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Table.php	text/x-php	4.68 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Theme.php	text/x-php	21.15 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Workbook.php	text/x-php	7.8 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
Worksheet.php	text/x-php	61.93 KB	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14
WriterPart.php	text/x-php	529 B	tradinguniversit/tradinguniversit	-rw-r--r--	2025-02-08 02:56:14