jclaveau / php-logical-filter

src/Converter/InlineSqlMinimalConverter.php

Braces +23 added lines, -38 removed lines

@@ -33,13 +33,15 @@ 
      */
     public function addParameter($value)
     {
-        if (is_numeric($value))
-            return $value;
+        if (is_numeric($value)) {
+                    return $value;
+        }
 
         $uid = 'param_'.hash('crc32b', serialize($value));
 
-        if (isset($this->parameters[$uid]))
-            return ':'.$uid;
+        if (isset($this->parameters[$uid])) {
+                    return ':'.$uid;
+        }
 
         $this->parameters[$uid] = $value;
 
@@ -84,77 +86,60 @@ 
     {
         if ($rule instanceof EqualRule) {
             $value = $rule->getValue();
-        }
-        elseif ($rule instanceof InRule) {
+        } elseif ($rule instanceof InRule) {
             $value = $rule->getPossibilities();
             if (is_object($value) && method_exists('toArray', $value)) {
                 $value = $value->toArray();
             }
-        }
-        elseif ($rule instanceof NotInRule) {
+        } elseif ($rule instanceof NotInRule) {
             $operator = 'NOT IN';
             $value = $rule->getPossibilities();
             if (is_object($value) && method_exists('toArray', $value)) {
                 $value = $value->toArray();
             }
-        }
-        elseif ($rule instanceof AboveRule) {
+        } elseif ($rule instanceof AboveRule) {
             $value = $rule->getLowerLimit();
-        }
-        elseif ($rule instanceof BelowRule) {
+        } elseif ($rule instanceof BelowRule) {
             $value = $rule->getUpperLimit();
-        }
-        elseif ($rule instanceof AboveOrEqualRule) {
+        } elseif ($rule instanceof AboveOrEqualRule) {
             $value = $rule->getMinimum();
-        }
-        elseif ($rule instanceof BelowOrEqualRule) {
+        } elseif ($rule instanceof BelowOrEqualRule) {
             $value = $rule->getMaximum();
-        }
-        elseif ($rule instanceof NotEqualRule) {
+        } elseif ($rule instanceof NotEqualRule) {
             $value = $rule->getValue();
-        }
-        elseif ($rule instanceof RegexpRule) {
+        } elseif ($rule instanceof RegexpRule) {
             $value = RegexpRule::php2mariadbPCRE( $rule->getPattern() );
-        }
-        else {
+        } else {
             throw new \InvalidArgumentException(
                 "Unhandled operator '$operator' during SQL query generation"
             );
         }
 
         if (gettype($value) == 'integer') {
-        }
-        elseif (gettype($value) == 'double') {
+        } elseif (gettype($value) == 'double') {
             // TODO disable locale to handle separators
-        }
-        elseif ($value instanceof \DateTime) {
+        } elseif ($value instanceof \DateTime) {
             $value = "'" . $value->format('Y-m-d H:i:s') . "'";
-        }
-        elseif (gettype($value) == 'string') {
+        } elseif (gettype($value) == 'string') {
             $value = $this->addParameter($value);
-        }
-        elseif (gettype($value) == 'array') {
+        } elseif (gettype($value) == 'array') {
             $sql_part = [];
             foreach ($value as $possibility) {
                 $sql_part[] = $this->addParameter($possibility);
             }
             $value = '(' . implode(', ', $sql_part) . ')';
-        }
-        elseif ($value === null) {
+        } elseif ($value === null) {
             $value = "NULL";
             if ($rule instanceof EqualRule) {
                 $operator = 'IS';
-            }
-            elseif ($rule instanceof NotEqualRule) {
+            } elseif ($rule instanceof NotEqualRule) {
                 $operator = 'IS NOT';
-            }
-            else {
+            } else {
                 throw new \InvalidArgumentException(
                     "NULL is only handled for equality / difference"
                 );
             }
-        }
-        else {
+        } else {
             throw new \InvalidArgumentException(
                 "Unhandled type of value: ".gettype($value). ' | ' .var_export($value, true)
             );