Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php declare(strict_types=1); namespace PhpOffice\PhpSpreadsheetTests\Calculation\Funct..
Decoded Output download
<?php
declare(strict_types=1);
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Logical;
use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
class SwitchTest extends AllSetupTeardown
{
/**
* @dataProvider providerSwitch
*/
public function testSWITCH(mixed $expectedResult, mixed ...$args): void
{
$this->runTestCase('SWITCH', $expectedResult, ...$args);
}
public static function providerSwitch(): array
{
return require 'tests/data/Calculation/Logical/SWITCH.php';
}
/**
* @dataProvider providerSwitchArray
*/
public function testIfsArray(array $expectedResult, int $expression, int $value1, string $result1, int $value2, string $result2, string $default): void
{
$calculation = Calculation::getInstance();
$formula = "=SWITCH($expression, $value1, {" . "$result1}, $value2, {" . "$result2}, {" . "$default})";
$result = $calculation->_calculateFormulaValue($formula);
self::assertEquals($expectedResult, $result);
}
public static function providerSwitchArray(): array
{
return [
'Array return' => [
[[4, 5, 6]],
2,
1,
'1, 2, 3',
2,
'4, 5, 6',
'7, 8, 9',
],
'Array return default' => [
[[7, 8, 9]],
3,
1,
'1, 2, 3',
2,
'4, 5, 6',
'7, 8, 9',
],
];
}
}
?>
Did this file decode correctly?
Original Code
<?php
declare(strict_types=1);
namespace PhpOffice\PhpSpreadsheetTests\Calculation\Functions\Logical;
use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
class SwitchTest extends AllSetupTeardown
{
/**
* @dataProvider providerSwitch
*/
public function testSWITCH(mixed $expectedResult, mixed ...$args): void
{
$this->runTestCase('SWITCH', $expectedResult, ...$args);
}
public static function providerSwitch(): array
{
return require 'tests/data/Calculation/Logical/SWITCH.php';
}
/**
* @dataProvider providerSwitchArray
*/
public function testIfsArray(array $expectedResult, int $expression, int $value1, string $result1, int $value2, string $result2, string $default): void
{
$calculation = Calculation::getInstance();
$formula = "=SWITCH($expression, $value1, {" . "$result1}, $value2, {" . "$result2}, {" . "$default})";
$result = $calculation->_calculateFormulaValue($formula);
self::assertEquals($expectedResult, $result);
}
public static function providerSwitchArray(): array
{
return [
'Array return' => [
[[4, 5, 6]],
2,
1,
'1, 2, 3',
2,
'4, 5, 6',
'7, 8, 9',
],
'Array return default' => [
[[7, 8, 9]],
3,
1,
'1, 2, 3',
2,
'4, 5, 6',
'7, 8, 9',
],
];
}
}
Function Calls
None |
Stats
MD5 | 394e0b8e1f05ddfe0fa9f5d69a4b259f |
Eval Count | 0 |
Decode Time | 95 ms |