Skip to content

Beautiful Open-Source Form Builder

3.8 KB
Raw Blame
<?php

namespace App\Service\Formulas\Functions;

class LogicFunctions
{
    private static function isTruthy(mixed $value): bool
    {
        if ($value === null || $value === '') {
            return false;
        }
        if (is_bool($value)) {
            return $value;
        }
        if (is_numeric($value)) {
            return $value != 0;
        }
        if (is_string($value)) {
            $lower = strtolower($value);
            if ($lower === 'false' || $lower === 'no' || $lower === '0') {
                return false;
            }
            return true;
        }
        return (bool) $value;
    }

    private static function isBlankValue(mixed $value): bool
    {
        return $value === null || $value === '' || $value === [];
    }

    public static function IF(mixed $condition, mixed $valueIfTrue, mixed $valueIfFalse = '')
    {
        return self::isTruthy($condition) ? $valueIfTrue : $valueIfFalse;
    }

    public static function AND(...$conditions): bool
    {
        if (empty($conditions)) {
            return true;
        }
        foreach ($conditions as $condition) {
            if (!self::isTruthy($condition)) {
                return false;
            }
        }
        return true;
    }

    public static function OR(...$conditions): bool
    {
        if (empty($conditions)) {
            return false;
        }
        foreach ($conditions as $condition) {
            if (self::isTruthy($condition)) {
                return true;
            }
        }
        return false;
    }

    public static function NOT(mixed $condition): bool
    {
        return !self::isTruthy($condition);
    }

    public static function XOR(...$conditions): bool
    {
        $trueCount = 0;
        foreach ($conditions as $condition) {
            if (self::isTruthy($condition)) {
                $trueCount++;
            }
        }
        return $trueCount % 2 === 1;
    }

    public static function ISBLANK(mixed $value): bool
    {
        return self::isBlankValue($value);
    }

    public static function ISNUMBER(mixed $value): bool
    {
        if ($value === null || $value === '') {
            return false;
        }
        return is_numeric($value);
    }

    public static function ISTEXT(mixed $value): bool
    {
        return is_string($value) && $value !== '';
    }

    public static function IFERROR(mixed $value, mixed $fallback = '')
    {
        if ($value === null) {
            return $fallback;
        }
        return $value;
    }

    public static function IFBLANK(mixed $value, mixed $fallback = '')
    {
        if (self::isBlankValue($value)) {
            return $fallback;
        }
        return $value;
    }

    public static function COALESCE(...$values)
    {
        foreach ($values as $value) {
            if (!self::isBlankValue($value)) {
                return $value;
            }
        }
        return null;
    }

    public static function SWITCH(mixed $value, ...$caseResults)
    {
        for ($i = 0; $i < count($caseResults) - 1; $i += 2) {
            if ($value === $caseResults[$i]) {
                return $caseResults[$i + 1];
            }
        }
        // Return default if provided (odd number of arguments)
        if (count($caseResults) % 2 === 1) {
            return $caseResults[count($caseResults) - 1];
        }
        return null;
    }

    public static function IFS(...$conditionResults)
    {
        for ($i = 0; $i < count($conditionResults); $i += 2) {
            if (self::isTruthy($conditionResults[$i])) {
                return $conditionResults[$i + 1] ?? null;
            }
        }
        return null;
    }

    public static function CHOOSE(mixed $index, ...$values)
    {
        $idx = (int) $index;
        if ($idx < 1 || $idx > count($values)) {
            return null;
        }
        return $values[$idx - 1];
    }
}