Dolibarr / dolibarr

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Database.php

Spacing +5 added lines, -5 removed lines

@@ -67,12 +67,12 @@ 
             $testConditionCount = 0;
             foreach ($criteria as $row => $criterion) {
                 if ($criterion[$key] > '') {
-                    $testCondition[] = '[:' . $criteriaName . ']' . Functions::ifCondition($criterion[$key]);
+                    $testCondition[] = '[:'.$criteriaName.']'.Functions::ifCondition($criterion[$key]);
                     ++$testConditionCount;
                 }
             }
             if ($testConditionCount > 1) {
-                $testConditions[] = 'OR(' . implode(',', $testCondition) . ')';
+                $testConditions[] = 'OR('.implode(',', $testCondition).')';
                 ++$testConditionsCount;
             } elseif ($testConditionCount == 1) {
                 $testConditions[] = $testCondition[0];
@@ -81,7 +81,7 @@ 
         }
 
         if ($testConditionsCount > 1) {
-            $testConditionSet = 'AND(' . implode(',', $testConditions) . ')';
+            $testConditionSet = 'AND('.implode(',', $testConditions).')';
         } elseif ($testConditionsCount == 1) {
             $testConditionSet = $testConditions[0];
         }
@@ -95,11 +95,11 @@ 
                 if (isset($dataValues[$k])) {
                     $dataValue = $dataValues[$k];
                     $dataValue = (is_string($dataValue)) ? Calculation::wrapResult(strtoupper($dataValue)) : $dataValue;
-                    $testConditionList = str_replace('[:' . $criteriaName . ']', $dataValue, $testConditionList);
+                    $testConditionList = str_replace('[:'.$criteriaName.']', $dataValue, $testConditionList);
                 }
             }
             //    evaluate the criteria against the row data
-            $result = Calculation::getInstance()->_calculateFormulaValue('=' . $testConditionList);
+            $result = Calculation::getInstance()->_calculateFormulaValue('='.$testConditionList);
             //    If the row failed to meet the criteria, remove it from the database
             if (!$result) {
                 unset($database[$dataRow]);

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Token/Stack.php

Spacing +1 added lines, -1 removed lines

@@ -141,7 +141,7 @@
             while (is_array($value)) {
                 $value = array_pop($value);
             }
-            $str .= $value . ' |> ';
+            $str .= $value.' |> ';
         }
 
         return $str;

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Logical.php

Spacing +3 added lines, -3 removed lines

@@ -94,7 +94,7 @@ 
             return Functions::VALUE();
         }
 
-        $args = array_filter($args, function ($value) {
+        $args = array_filter($args, function($value) {
             return $value !== null || (is_string($value) && trim($value) == '');
         });
         $argCount = count($args);
@@ -137,7 +137,7 @@ 
             return Functions::VALUE();
         }
 
-        $args = array_filter($args, function ($value) {
+        $args = array_filter($args, function($value) {
             return $value !== null || (is_string($value) && trim($value) == '');
         });
 
@@ -180,7 +180,7 @@ 
             return Functions::VALUE();
         }
 
-        $args = array_filter($args, function ($value) {
+        $args = array_filter($args, function($value) {
             return $value !== null || (is_string($value) && trim($value) == '');
         });
 

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/MathTrig.php

Spacing +8 added lines, -8 removed lines

@@ -1119,7 +1119,7 @@ 
         $t = self::romanCut($aValue, 10);
         $aValue %= 10;
 
-        return $roman . $mill[$m] . $cent[$c] . $tens[$t] . $ones[$aValue];
+        return $roman.$mill[$m].$cent[$c].$tens[$t].$ones[$aValue];
     }
 
     /**
@@ -1271,7 +1271,7 @@ 
     {
         return array_filter(
             $args,
-            function ($index) use ($cellReference) {
+            function($index) use ($cellReference) {
                 [, $row, $column] = explode('.', $index);
 
                 return $cellReference->getWorksheet()->getRowDimension($row)->getVisible() &&
@@ -1285,12 +1285,12 @@ 
     {
         return array_filter(
             $args,
-            function ($index) use ($cellReference) {
+            function($index) use ($cellReference) {
                 [, $row, $column] = explode('.', $index);
-                if ($cellReference->getWorksheet()->cellExists($column . $row)) {
+                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());
+                    $isFormula = $cellReference->getWorksheet()->getCell($column.$row)->isFormula();
+                    $cellFormula = !preg_match('/^=.*\b(SUBTOTAL|AGGREGATE)\s*\(/i', $cellReference->getWorksheet()->getCell($column.$row)->getValue());
 
                     return !$isFormula || $cellFormula;
                 }
@@ -1421,7 +1421,7 @@ 
                 $arg = Calculation::wrapResult(strtoupper($arg));
             }
 
-            $testCondition = '=' . $arg . $condition;
+            $testCondition = '='.$arg.$condition;
             $sumValue = array_key_exists($key, $sumArgs) ? $sumArgs[$key] : 0;
 
             if (is_numeric($sumValue) &&
@@ -1476,7 +1476,7 @@ 
                 if (!is_numeric($arg)) {
                     $arg = Calculation::wrapResult(strtoupper($arg));
                 }
-                $testCondition = '=' . $arg . $condition;
+                $testCondition = '='.$arg.$condition;
                 if (!Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                     // Is not a value within our criteria
                     $valid = false;

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Engine/Logger.php

Spacing +2 added lines, -2 removed lines

@@ -102,8 +102,8 @@
                     $message,
                     PHP_EOL;
             }
-            $this->debugLog[] = $cellReference .
-                ($this->cellStack->count() > 0 ? ' => ' : '') .
+            $this->debugLog[] = $cellReference.
+                ($this->cellStack->count() > 0 ? ' => ' : '').
                 $message;
         }
     }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/TextData.php

Spacing +5 added lines, -5 removed lines

@@ -34,7 +34,7 @@ 
             return iconv('UCS-4LE', 'UTF-8', pack('V', $character));
         }
 
-        return mb_convert_encoding('&#' . (int) $character . ';', 'UTF-8', 'HTML-ENTITIES');
+        return mb_convert_encoding('&#'.(int) $character.';', 'UTF-8', 'HTML-ENTITIES');
     }
 
     /**
@@ -165,7 +165,7 @@ 
 
         $mask = '$#,##0';
         if ($decimals > 0) {
-            $mask .= '.' . str_repeat('0', $decimals);
+            $mask .= '.'.str_repeat('0', $decimals);
         } else {
             $round = pow(10, abs($decimals));
             if ($value < 0) {
@@ -460,7 +460,7 @@ 
         $left = self::LEFT($oldText, $start - 1);
         $right = self::RIGHT($oldText, self::STRINGLENGTH($oldText) - ($start + $chars) + 1);
 
-        return $left . $newText . $right;
+        return $left.$newText.$right;
     }
 
     /**
@@ -553,7 +553,7 @@ 
             $numberValue = str_replace(
                 StringHelper::getThousandsSeparator(),
                 '',
-                trim($value, " \t\n\r\0\x0B" . StringHelper::getCurrencyCode())
+                trim($value, " \t\n\r\0\x0B".StringHelper::getCurrencyCode())
             );
             if (is_numeric($numberValue)) {
                 return (float) $numberValue;
@@ -603,7 +603,7 @@ 
             $decimalSeparator = empty($decimalSeparator) ? StringHelper::getDecimalSeparator() : $decimalSeparator;
             $groupSeparator = empty($groupSeparator) ? StringHelper::getThousandsSeparator() : $groupSeparator;
 
-            $decimalPositions = preg_match_all('/' . preg_quote($decimalSeparator) . '/', $value, $matches, PREG_OFFSET_CAPTURE);
+            $decimalPositions = preg_match_all('/'.preg_quote($decimalSeparator).'/', $value, $matches, PREG_OFFSET_CAPTURE);
             if ($decimalPositions > 1) {
                 return Functions::VALUE();
             }

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef.php

Spacing +13 added lines, -13 removed lines

@@ -44,7 +44,7 @@ 
 
         if ($sheetText > '') {
             if (strpos($sheetText, ' ') !== false) {
-                $sheetText = "'" . $sheetText . "'";
+                $sheetText = "'".$sheetText."'";
             }
             $sheetText .= '!';
         }
@@ -58,16 +58,16 @@ 
                 $rowRelative = '';
             }
 
-            return $sheetText . $columnRelative . $column . $rowRelative . $row;
+            return $sheetText.$columnRelative.$column.$rowRelative.$row;
         }
         if (($relativity == 2) || ($relativity == 4)) {
-            $column = '[' . $column . ']';
+            $column = '['.$column.']';
         }
         if (($relativity == 3) || ($relativity == 4)) {
-            $row = '[' . $row . ']';
+            $row = '['.$row.']';
         }
 
-        return $sheetText . 'R' . $row . 'C' . $column;
+        return $sheetText.'R'.$row.'C'.$column;
     }
 
     /**
@@ -288,9 +288,9 @@ 
             [$cellAddress1, $cellAddress2] = explode(':', $cellAddress);
         }
 
-        if ((!preg_match('/^' . Calculation::CALCULATION_REGEXP_CELLREF . '$/i', $cellAddress1, $matches)) ||
-            (($cellAddress2 !== null) && (!preg_match('/^' . Calculation::CALCULATION_REGEXP_CELLREF . '$/i', $cellAddress2, $matches)))) {
-            if (!preg_match('/^' . Calculation::CALCULATION_REGEXP_NAMEDRANGE . '$/i', $cellAddress1, $matches)) {
+        if ((!preg_match('/^'.Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $cellAddress1, $matches)) ||
+            (($cellAddress2 !== null) && (!preg_match('/^'.Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $cellAddress2, $matches)))) {
+            if (!preg_match('/^'.Calculation::CALCULATION_REGEXP_NAMEDRANGE.'$/i', $cellAddress1, $matches)) {
                 return Functions::REF();
             }
 
@@ -396,9 +396,9 @@ 
         }
         $endCellColumn = Coordinate::stringFromColumnIndex($endCellColumn + 1);
 
-        $cellAddress = $startCellColumn . $startCellRow;
+        $cellAddress = $startCellColumn.$startCellRow;
         if (($startCellColumn != $endCellColumn) || ($startCellRow != $endCellRow)) {
-            $cellAddress .= ':' . $endCellColumn . $endCellRow;
+            $cellAddress .= ':'.$endCellColumn.$endCellRow;
         }
 
         if ($sheetName !== null) {
@@ -534,7 +534,7 @@ 
                 if ($matchType === 0) {
                     if ($typeMatch && is_string($lookupValue) && (bool) preg_match('/([\?\*])/', $lookupValue)) {
                         $splitString = $lookupValue;
-                        $chars = array_map(function ($i) use ($splitString) {
+                        $chars = array_map(function($i) use ($splitString) {
                             return mb_substr($splitString, $i, 1);
                         }, range(0, mb_strlen($splitString) - 1));
 
@@ -951,9 +951,9 @@ 
             return Functions::REF();
         }
 
-        preg_match('/^' . Calculation::CALCULATION_REGEXP_CELLREF . '$/i', $cellReference, $matches);
+        preg_match('/^'.Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $cellReference, $matches);
 
-        $cellReference = $matches[6] . $matches[7];
+        $cellReference = $matches[6].$matches[7];
         $worksheetName = trim($matches[3], "'");
         $worksheet = (!empty($worksheetName))
             ? $pCell->getWorksheet()->getParent()->getSheetByName($worksheetName)

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/DateTime.php

Spacing +12 added lines, -12 removed lines

@@ -109,10 +109,10 @@ 
 
         $adjustmentMonthsString = (string) $adjustmentMonths;
         if ($adjustmentMonths > 0) {
-            $adjustmentMonthsString = '+' . $adjustmentMonths;
+            $adjustmentMonthsString = '+'.$adjustmentMonths;
         }
         if ($adjustmentMonths != 0) {
-            $PHPDateObject->modify($adjustmentMonthsString . ' months');
+            $PHPDateObject->modify($adjustmentMonthsString.' months');
         }
         $nMonth = (int) $PHPDateObject->format('m');
         $nYear = (int) $PHPDateObject->format('Y');
@@ -120,7 +120,7 @@ 
         $monthDiff = ($nMonth - $oMonth) + (($nYear - $oYear) * 12);
         if ($monthDiff != $adjustmentMonths) {
             $adjustDays = (int) $PHPDateObject->format('d');
-            $adjustDaysString = '-' . $adjustDays . ' days';
+            $adjustDaysString = '-'.$adjustDays.' days';
             $PHPDateObject->modify($adjustDaysString);
         }
 
@@ -434,9 +434,9 @@ 
                     $dayAdjust = floor($hour / 24);
                     $hour = $hour % 24;
                 }
-                $phpDateObject = new \DateTime('1900-01-01 ' . $hour . ':' . $minute . ':' . $second);
+                $phpDateObject = new \DateTime('1900-01-01 '.$hour.':'.$minute.':'.$second);
                 if ($dayAdjust != 0) {
-                    $phpDateObject->modify($dayAdjust . ' days');
+                    $phpDateObject->modify($dayAdjust.' days');
                 }
 
                 return $phpDateObject;
@@ -529,9 +529,9 @@ 
             if ($testVal1 < 31 && $testVal2 < 12 && $testVal3 < 12 && strlen($testVal3) == 2) {
                 $testVal3 += 2000;
             }
-            $PHPDateArray = date_parse($testVal1 . '-' . $testVal2 . '-' . $testVal3);
+            $PHPDateArray = date_parse($testVal1.'-'.$testVal2.'-'.$testVal3);
             if (($PHPDateArray === false) || ($PHPDateArray['error_count'] > 0)) {
-                $PHPDateArray = date_parse($testVal2 . '-' . $testVal1 . '-' . $testVal3);
+                $PHPDateArray = date_parse($testVal2.'-'.$testVal1.'-'.$testVal3);
                 if (($PHPDateArray === false) || ($PHPDateArray['error_count'] > 0)) {
                     return Functions::VALUE();
                 }
@@ -571,7 +571,7 @@ 
                 case Functions::RETURNDATE_UNIX_TIMESTAMP:
                     return (int) Date::excelToTimestamp($excelDateValue);
                 case Functions::RETURNDATE_PHP_DATETIME_OBJECT:
-                    return new \DateTime($PHPDateArray['year'] . '-' . $PHPDateArray['month'] . '-' . $PHPDateArray['day'] . ' 00:00:00');
+                    return new \DateTime($PHPDateArray['year'].'-'.$PHPDateArray['month'].'-'.$PHPDateArray['day'].' 00:00:00');
             }
         }
 
@@ -633,7 +633,7 @@ 
                 case Functions::RETURNDATE_UNIX_TIMESTAMP:
                     return (int) $phpDateValue = Date::excelToTimestamp($excelDateValue + 25569) - 3600;
                 case Functions::RETURNDATE_PHP_DATETIME_OBJECT:
-                    return new \DateTime('1900-01-01 ' . $PHPDateArray['hour'] . ':' . $PHPDateArray['minute'] . ':' . $PHPDateArray['second']);
+                    return new \DateTime('1900-01-01 '.$PHPDateArray['hour'].':'.$PHPDateArray['minute'].':'.$PHPDateArray['second']);
             }
         }
 
@@ -711,7 +711,7 @@ 
             case 'MD':
                 if ($endDays < $startDays) {
                     $retVal = $endDays;
-                    $PHPEndDateObject->modify('-' . $endDays . ' days');
+                    $PHPEndDateObject->modify('-'.$endDays.' days');
                     $adjustDays = $PHPEndDateObject->format('j');
                     $retVal += ($adjustDays - $startDays);
                 } else {
@@ -1364,7 +1364,7 @@ 
             return (int) $PHPDateObject->format('W');
         }
         $dayOfYear = $PHPDateObject->format('z');
-        $PHPDateObject->modify('-' . $dayOfYear . ' days');
+        $PHPDateObject->modify('-'.$dayOfYear.' days');
         $firstDayOfFirstWeek = $PHPDateObject->format('w');
         $daysInFirstWeek = (6 - $firstDayOfFirstWeek + $method) % 7;
         $daysInFirstWeek += 7 * !$daysInFirstWeek;
@@ -1676,7 +1676,7 @@ 
         // Execute function
         $PHPDateObject = self::adjustDateByMonths($dateValue, $adjustmentMonths + 1);
         $adjustDays = (int) $PHPDateObject->format('d');
-        $adjustDaysString = '-' . $adjustDays . ' days';
+        $adjustDaysString = '-'.$adjustDays.' days';
         $PHPDateObject->modify($adjustDaysString);
 
         switch (Functions::getReturnDateType()) {

htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Functions.php

Spacing +6 added lines, -6 removed lines

@@ -280,7 +280,7 @@ 
                 $condition = Calculation::wrapResult(strtoupper($condition));
             }
 
-            return str_replace('""""', '""', '=' . $condition);
+            return str_replace('""""', '""', '='.$condition);
         }
         preg_match('/(=|<[>=]?|>=?)(.*)/', $condition, $matches);
         [, $operator, $operand] = $matches;
@@ -292,7 +292,7 @@ 
             $operand = Calculation::wrapResult(strtoupper($operand));
         }
 
-        return str_replace('""""', '""', $operator . $operand);
+        return str_replace('""""', '""', $operator.$operand);
     }
 
     /**
@@ -622,10 +622,10 @@ 
                 foreach ($value as $k2 => $val) {
                     if (is_array($val)) {
                         foreach ($val as $k3 => $v) {
-                            $arrayValues[$k1 . '.' . $k2 . '.' . $k3] = $v;
+                            $arrayValues[$k1.'.'.$k2.'.'.$k3] = $v;
                         }
                     } else {
-                        $arrayValues[$k1 . '.' . $k2] = $val;
+                        $arrayValues[$k1.'.'.$k2] = $val;
                     }
                 }
             } else {
@@ -666,9 +666,9 @@ 
             return self::REF();
         }
 
-        preg_match('/^' . Calculation::CALCULATION_REGEXP_CELLREF . '$/i', $cellReference, $matches);
+        preg_match('/^'.Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $cellReference, $matches);
 
-        $cellReference = $matches[6] . $matches[7];
+        $cellReference = $matches[6].$matches[7];
         $worksheetName = trim($matches[3], "'");
 
         $worksheet = (!empty($worksheetName))