<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\MathTrig;

use PhpOffice\PhpSpreadsheet\Calculation\Exception;
use PhpOffice\PhpSpreadsheet\Calculation\Functions;

> use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;


use PhpOffice\PhpSpreadsheet\Calculation\Statistical;

class Subtotal
{
    /**
     * @param mixed $cellReference
     * @param mixed $args
     */
    protected static function filterHiddenArgs($cellReference, $args): array
    {
        return array_filter(
            $args,
            function ($index) use ($cellReference) {

<                 [, $row, ] = explode('.', $index);



>                 $explodeArray = explode('.', $index);
>                 $row = $explodeArray[1] ?? '';
>                 if (!is_numeric($row)) {
>                     return true;
>                 }



                return $cellReference->getWorksheet()->getRowDimension($row)->getVisible();
            },
            ARRAY_FILTER_USE_KEY
        );
    }

    /**
     * @param mixed $cellReference
     * @param mixed $args
     */
    protected static function filterFormulaArgs($cellReference, $args): array
    {
        return array_filter(
            $args,
            function ($index) use ($cellReference) {

<                 [, $row, $column] = explode('.', $index);



>                 $explodeArray = explode('.', $index);
>                 $row = $explodeArray[1] ?? '';
>                 $column = $explodeArray[2] ?? '';


                $retVal = true;
                if ($cellReference->getWorksheet()->cellExists($column . $row)) {
                    //take this cell out if it contains the SUBTOTAL or AGGREGATE functions in a formula
                    $isFormula = $cellReference->getWorksheet()->getCell($column . $row)->isFormula();

<                     $cellFormula = !preg_match('/^=.*\b(SUBTOTAL|AGGREGATE)\s*\(/i', $cellReference->getWorksheet()->getCell($column . $row)->getValue());



>                     $cellFormula = !preg_match(
>                         '/^=.*\b(SUBTOTAL|AGGREGATE)\s*\(/i',
>                         $cellReference->getWorksheet()->getCell($column . $row)->getValue() ?? ''
>                     );



                    $retVal = !$isFormula || $cellFormula;
                }

                return $retVal;
            },
            ARRAY_FILTER_USE_KEY
        );
    }


<     /** @var callable[] */


    private const CALL_FUNCTIONS = [

<         1 => [Statistical\Averages::class, 'average'],
<         [Statistical\Counts::class, 'COUNT'], // 2
<         [Statistical\Counts::class, 'COUNTA'], // 3
<         [Statistical\Maximum::class, 'max'], // 4
<         [Statistical\Minimum::class, 'min'], // 5
<         [Operations::class, 'product'], // 6
<         [Statistical\StandardDeviations::class, 'STDEV'], // 7
<         [Statistical\StandardDeviations::class, 'STDEVP'], // 8
<         [Sum::class, 'sumIgnoringStrings'], // 9
<         [Statistical\Variances::class, 'VAR'], // 10
<         [Statistical\Variances::class, 'VARP'], // 11



>         1 => [Statistical\Averages::class, 'average'], // 1 and 101
>         [Statistical\Counts::class, 'COUNT'], // 2 and 102
>         [Statistical\Counts::class, 'COUNTA'], // 3 and 103
>         [Statistical\Maximum::class, 'max'], // 4 and 104
>         [Statistical\Minimum::class, 'min'], // 5 and 105
>         [Operations::class, 'product'], // 6 and 106
>         [Statistical\StandardDeviations::class, 'STDEV'], // 7 and 107
>         [Statistical\StandardDeviations::class, 'STDEVP'], // 8 and 108
>         [Sum::class, 'sumIgnoringStrings'], // 9 and 109
>         [Statistical\Variances::class, 'VAR'], // 10 and 110
>         [Statistical\Variances::class, 'VARP'], // 111 and 111


    ];

    /**
     * SUBTOTAL.
     *
     * Returns a subtotal in a list or database.
     *
     * @param mixed $functionType
     *            A number 1 to 11 that specifies which function to
     *                    use in calculating subtotals within a range
     *                    list
     *            Numbers 101 to 111 shadow the functions of 1 to 11
     *                    but ignore any values in the range that are
     *                    in hidden rows
     * @param mixed[] $args A mixed data series of values
     *
     * @return float|string
     */
    public static function evaluate($functionType, ...$args)
    {
        $cellReference = array_pop($args);

<         $aArgs = Functions::flattenArrayIndexed($args);



>         $bArgs = Functions::flattenArrayIndexed($args);
>         $aArgs = [];
>         // int keys must come before string keys for PHP 8.0+
>         // Otherwise, PHP thinks positional args follow keyword
>         //    in the subsequent call to call_user_func_array.
>         // Fortunately, order of args is unimportant to Subtotal.
>         foreach ($bArgs as $key => $value) {
>             if (is_int($key)) {
>                 $aArgs[$key] = $value;
>             }
>         }
>         foreach ($bArgs as $key => $value) {
>             if (!is_int($key)) {
>                 $aArgs[$key] = $value;
>             }
>         }



        try {
            $subtotal = (int) Helpers::validateNumericNullBool($functionType);
        } catch (Exception $e) {
            return $e->getMessage();
        }

        // Calculate
        if ($subtotal > 100) {
            $aArgs = self::filterHiddenArgs($cellReference, $aArgs);
            $subtotal -= 100;
        }

        $aArgs = self::filterFormulaArgs($cellReference, $aArgs);
        if (array_key_exists($subtotal, self::CALL_FUNCTIONS)) {
            /** @var callable */
            $call = self::CALL_FUNCTIONS[$subtotal];

            return call_user_func_array($call, $aArgs);
        }


<         return Functions::VALUE();



>         return ExcelError::VALUE();


    }
}