Shell Bypass 403 GE-C666C

Ghost Exploiter Team Official

Directory >> /var/www/html/back/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/

File / Folder	Size	Action
.	-
Address.php	4.688KB	edt ren
ExcelMatch.php	9.957KB	edt ren
Filter.php	2.08KB	edt ren
Formula.php	1.236KB	edt ren
HLookup.php	4.342KB	edt ren
Helpers.php	2.741KB	edt ren
Hyperlink.php	1.335KB	edt ren
Indirect.php	4.956KB	edt ren
Lookup.php	3.481KB	edt ren
LookupBase.php	2.24KB	edt ren
LookupRefValidations.php	0.955KB	edt ren
Matrix.php	4.319KB	edt ren
Offset.php	6.575KB	edt ren
RowColumnInformation.php	7.181KB	edt ren
Selection.php	1.472KB	edt ren
Sort.php	12.12KB	edt ren
Unique.php	4.323KB	edt ren
VLookup.php	4.072KB	edt ren

<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\LookupRef;

use PhpOffice\PhpSpreadsheet\Calculation\Functions;
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;

class Unique
{
    /**
     * UNIQUE
     * The UNIQUE function searches for value either from a one-row or one-column range or from an array.
     *
     * @param mixed $lookupVector The range of cells being searched
     * @param mixed $byColumn Whether the uniqueness should be determined by row (the default) or by column
     * @param mixed $exactlyOnce Whether the function should return only entries that occur just once in the list
     *
     * @return mixed The unique values from the search range
     */
    public static function unique($lookupVector, $byColumn = false, $exactlyOnce = false)
    {
        if (!is_array($lookupVector)) {
            // Scalars are always returned "as is"
            return $lookupVector;
        }

$byColumn = (bool) $byColumn;
        $exactlyOnce = (bool) $exactlyOnce;

return ($byColumn === true)
            ? self::uniqueByColumn($lookupVector, $exactlyOnce)
            : self::uniqueByRow($lookupVector, $exactlyOnce);
    }

/**
     * @return mixed
     */
    private static function uniqueByRow(array $lookupVector, bool $exactlyOnce)
    {
        // When not $byColumn, we count whole rows or values, not individual values
        //      so implode each row into a single string value
        array_walk(
            $lookupVector,
            function (array &$value): void {
                $value = implode(chr(0x00), $value);
            }
        );

$result = self::countValuesCaseInsensitive($lookupVector);

if ($exactlyOnce === true) {
            $result = self::exactlyOnceFilter($result);
        }

if (count($result) === 0) {
            return ExcelError::CALC();
        }

$result = array_keys($result);

// restore rows from their strings
        array_walk(
            $result,
            function (string &$value): void {
                $value = explode(chr(0x00), $value);
            }
        );

return (count($result) === 1) ? array_pop($result) : $result;
    }

/**
     * @return mixed
     */
    private static function uniqueByColumn(array $lookupVector, bool $exactlyOnce)
    {
        $flattenedLookupVector = Functions::flattenArray($lookupVector);

if (count($lookupVector, COUNT_RECURSIVE) > count($flattenedLookupVector, COUNT_RECURSIVE) + 1) {
            // We're looking at a full column check (multiple rows)
            $transpose = Matrix::transpose($lookupVector);
            $result = self::uniqueByRow($transpose, $exactlyOnce);

return (is_array($result)) ? Matrix::transpose($result) : $result;
        }

$result = self::countValuesCaseInsensitive($flattenedLookupVector);

if ($exactlyOnce === true) {
            $result = self::exactlyOnceFilter($result);
        }

if (count($result) === 0) {
            return ExcelError::CALC();
        }

$result = array_keys($result);

return $result;
    }

private static function countValuesCaseInsensitive(array $caseSensitiveLookupValues): array
    {
        $caseInsensitiveCounts = array_count_values(
            array_map(
                function (string $value) {
                    return StringHelper::strToUpper($value);
                },
                $caseSensitiveLookupValues
            )
        );

$caseSensitiveCounts = [];
        foreach ($caseInsensitiveCounts as $caseInsensitiveKey => $count) {
            if (is_numeric($caseInsensitiveKey)) {
                $caseSensitiveCounts[$caseInsensitiveKey] = $count;
            } else {
                foreach ($caseSensitiveLookupValues as $caseSensitiveValue) {
                    if ($caseInsensitiveKey === StringHelper::strToUpper($caseSensitiveValue)) {
                        $caseSensitiveCounts[$caseSensitiveValue] = $count;

break;
                    }
                }
            }
        }

return $caseSensitiveCounts;
    }

private static function exactlyOnceFilter(array $values): array
    {
        return array_filter(
            $values,
            function ($value) {
                return $value === 1;
            }
        );
    }
}

<=Back