Logical.php

Go to the documentation of this file.

<?php
if (!defined('PHPEXCEL_ROOT')) {
        define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
        require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
}


class PHPExcel_Calculation_Logical {

        public static function TRUE() {
                return true;
        }       //      function TRUE()


        public static function FALSE() {
                return false;
        }       //      function FALSE()


        public static function LOGICAL_AND() {
                // Return value
                $returnValue = True;

                // Loop through the arguments
                $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
                $argCount = 0;
                foreach ($aArgs as $arg) {
                        // Is it a boolean value?
                        if (is_bool($arg)) {
                                $returnValue = $returnValue && $arg;
                        } elseif ((is_numeric($arg)) && (!is_string($arg))) {
                                $returnValue = $returnValue && ($arg != 0);
                        } elseif (is_string($arg)) {
                                $arg = strtoupper($arg);
                                if (($arg == 'TRUE') || ($arg == PHPExcel_Calculation::getTRUE())) {
                                        $arg = true;
                                } elseif (($arg == 'FALSE') || ($arg == PHPExcel_Calculation::getFALSE())) {
                                        $arg = false;
                                } else {
                                        return PHPExcel_Calculation_Functions::VALUE();
                                }
                                $returnValue = $returnValue && ($arg != 0);
                        }
                        ++$argCount;
                }

                // Return
                if ($argCount == 0) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }
                return $returnValue;
        }       //      function LOGICAL_AND()


        public static function LOGICAL_OR() {
                // Return value
                $returnValue = False;

                // Loop through the arguments
                $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
                $argCount = 0;
                foreach ($aArgs as $arg) {
                        // Is it a boolean value?
                        if (is_bool($arg)) {
                                $returnValue = $returnValue || $arg;
                        } elseif ((is_numeric($arg)) && (!is_string($arg))) {
                                $returnValue = $returnValue || ($arg != 0);
                        } elseif (is_string($arg)) {
                                $arg = strtoupper($arg);
                                if (($arg == 'TRUE') || ($arg == PHPExcel_Calculation::getTRUE())) {
                                        $arg = true;
                                } elseif (($arg == 'FALSE') || ($arg == PHPExcel_Calculation::getFALSE())) {
                                        $arg = false;
                                } else {
                                        return PHPExcel_Calculation_Functions::VALUE();
                                }
                                $returnValue = $returnValue || ($arg != 0);
                        }
                        ++$argCount;
                }

                // Return
                if ($argCount == 0) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }
                return $returnValue;
        }       //      function LOGICAL_OR()


        public static function NOT($logical) {
                $logical = PHPExcel_Calculation_Functions::flattenSingleValue($logical);
                if (is_string($logical)) {
                        $logical = strtoupper($logical);
                        if (($logical == 'TRUE') || ($logical == PHPExcel_Calculation::getTRUE())) {
                                return false;
                        } elseif (($logical == 'FALSE') || ($logical == PHPExcel_Calculation::getFALSE())) {
                                return true;
                        } else {
                                return PHPExcel_Calculation_Functions::VALUE();
                        }
                }

                return !$logical;
        }       //      function NOT()

        public static function STATEMENT_IF($condition = true, $returnIfTrue = 0, $returnIfFalse = False) {
                $condition              = (is_null($condition))         ? True :        (boolean) PHPExcel_Calculation_Functions::flattenSingleValue($condition);
                $returnIfTrue   = (is_null($returnIfTrue))      ? 0 :           PHPExcel_Calculation_Functions::flattenSingleValue($returnIfTrue);
                $returnIfFalse  = (is_null($returnIfFalse))     ? False :       PHPExcel_Calculation_Functions::flattenSingleValue($returnIfFalse);

                return ($condition ? $returnIfTrue : $returnIfFalse);
        }       //      function STATEMENT_IF()


        public static function IFERROR($testValue = '', $errorpart = '') {
                $testValue      = (is_null($testValue)) ? '' :  PHPExcel_Calculation_Functions::flattenSingleValue($testValue);
                $errorpart      = (is_null($errorpart)) ? '' :  PHPExcel_Calculation_Functions::flattenSingleValue($errorpart);

                return self::STATEMENT_IF(PHPExcel_Calculation_Functions::IS_ERROR($testValue), $errorpart, $testValue);
        }       //      function IFERROR()

}       //      class PHPExcel_Calculation_Logical