Skip to content

Beautiful Open-Source Form Builder

3.1 KB
Raw Blame
<?php

namespace App\Service\Formulas\Functions;

class MathFunctions
{
    private static function toNumber(mixed $value): ?float
    {
        if ($value === null || $value === '') {
            return null;
        }
        if (is_numeric($value)) {
            return (float) $value;
        }
        return null;
    }

    private static function getNumbers(array $values): array
    {
        $numbers = [];
        foreach ($values as $value) {
            if (is_array($value)) {
                $numbers = array_merge($numbers, self::getNumbers($value));
            } else {
                $num = self::toNumber($value);
                if ($num !== null) {
                    $numbers[] = $num;
                }
            }
        }
        return $numbers;
    }

    public static function SUM(...$values): float
    {
        $numbers = self::getNumbers($values);
        return array_sum($numbers);
    }

    public static function AVERAGE(...$values): ?float
    {
        $numbers = self::getNumbers($values);
        if (empty($numbers)) {
            return null;
        }
        return array_sum($numbers) / count($numbers);
    }

    public static function MIN(...$values): ?float
    {
        $numbers = self::getNumbers($values);
        if (empty($numbers)) {
            return null;
        }
        return min($numbers);
    }

    public static function MAX(...$values): ?float
    {
        $numbers = self::getNumbers($values);
        if (empty($numbers)) {
            return null;
        }
        return max($numbers);
    }

    public static function ROUND(mixed $value, int $decimals = 0): ?float
    {
        $num = self::toNumber($value);
        if ($num === null) {
            return null;
        }
        return round($num, $decimals);
    }

    public static function FLOOR(mixed $value): ?float
    {
        $num = self::toNumber($value);
        if ($num === null) {
            return null;
        }
        return floor($num);
    }

    public static function CEIL(mixed $value): ?float
    {
        $num = self::toNumber($value);
        if ($num === null) {
            return null;
        }
        return ceil($num);
    }

    public static function ABS(mixed $value): ?float
    {
        $num = self::toNumber($value);
        if ($num === null) {
            return null;
        }
        return abs($num);
    }

    public static function MOD(mixed $value, mixed $divisor): ?float
    {
        $num = self::toNumber($value);
        $div = self::toNumber($divisor);
        if ($num === null || $div === null || $div == 0) {
            return null;
        }
        return fmod($num, $div);
    }

    public static function POWER(mixed $base, mixed $exponent): ?float
    {
        $b = self::toNumber($base);
        $e = self::toNumber($exponent);
        if ($b === null || $e === null) {
            return null;
        }
        return pow($b, $e);
    }

    public static function SQRT(mixed $value): ?float
    {
        $num = self::toNumber($value);
        if ($num === null || $num < 0) {
            return null;
        }
        return sqrt($num);
    }
}