byjg / anydataset

src/Database/DBSQLRelayDriver.php

Spacing +1 added lines, -1 removed lines

@@ -56,7 +56,7 @@
             sqlrcur_prepareQuery($cur, $sql);
             $bindCount = 1;
             foreach ($array as $key => $value) {
-                $field = strval($bindCount ++);
+                $field = strval($bindCount++);
                 sqlrcur_inputBind($cur, $field, $value);
             }
             $success = sqlrcur_executeQuery($cur);

src/Database/DBDblibFunctions.php

Switch Indentation +44 added lines, -44 removed lines

@@ -76,50 +76,50 @@
             if ($s) $s .= '+';
             $ch = $fmt[$i];
             switch ($ch) {
-                case 'Y':
-                case 'y':
-                    $s .= "datename(yyyy,$col)";
-                    break;
-                case 'M':
-                    $s .= "convert(char(3),$col,0)";
-                    break;
-                case 'm':
-                    $s .= "replace(str(month($col),2),' ','0')";
-                    break;
-                case 'Q':
-                case 'q':
-                    $s .= "datename(quarter,$col)";
-                    break;
-                case 'D':
-                case 'd':
-                    $s .= "replace(str(day($col),2),' ','0')";
-                    break;
-                case 'h':
-                    $s .= "substring(convert(char(14),$col,0),13,2)";
-                    break;
-
-                case 'H':
-                    $s .= "replace(str(datepart(hh,$col),2),' ','0')";
-                    break;
-
-                case 'i':
-                    $s .= "replace(str(datepart(mi,$col),2),' ','0')";
-                    break;
-                case 's':
-                    $s .= "replace(str(datepart(ss,$col),2),' ','0')";
-                    break;
-                case 'a':
-                case 'A':
-                    $s .= "substring(convert(char(19),$col,0),18,2)";
-                    break;
-
-                default:
-                    if ($ch == '\\') {
-                        $i++;
-                        $ch = substr($fmt, $i, 1);
-                    }
-                    $s .= $this->qstr($ch);
-                    break;
+            case 'Y':
+            case 'y':
+                $s .= "datename(yyyy,$col)";
+                break;
+            case 'M':
+                $s .= "convert(char(3),$col,0)";
+                break;
+            case 'm':
+                $s .= "replace(str(month($col),2),' ','0')";
+                break;
+            case 'Q':
+            case 'q':
+                $s .= "datename(quarter,$col)";
+                break;
+            case 'D':
+            case 'd':
+                $s .= "replace(str(day($col),2),' ','0')";
+                break;
+            case 'h':
+                $s .= "substring(convert(char(14),$col,0),13,2)";
+                break;
+
+            case 'H':
+                $s .= "replace(str(datepart(hh,$col),2),' ','0')";
+                break;
+
+            case 'i':
+                $s .= "replace(str(datepart(mi,$col),2),' ','0')";
+                break;
+            case 's':
+                $s .= "replace(str(datepart(ss,$col),2),' ','0')";
+                break;
+            case 'a':
+            case 'A':
+                $s .= "substring(convert(char(19),$col,0),18,2)";
+                break;
+
+            default:
+                if ($ch == '\\') {
+                    $i++;
+                    $ch = substr($fmt, $i, 1);
+                }
+                $s .= $this->qstr($ch);
+                break;
             }
         }
         return $s;

Spacing +1 added lines, -1 removed lines

@@ -12,7 +12,7 @@
     {
         for ($i = 0, $numArgs = func_num_args(); $i < $numArgs; $i++) {
             $var = func_get_arg($i);
-            $sql .= ($i == 0 ? "" : "+") . $var;
+            $sql .= ($i == 0 ? "" : "+").$var;
         }
 
         return $sql;

src/Database/DBPgsqlFunctions.php

Switch Indentation +53 added lines, -53 removed lines

@@ -76,59 +76,59 @@
         for ($i = 0; $i < $len; $i++) {
             $ch = $fmt[$i];
             switch ($ch) {
-                case 'Y':
-                case 'y':
-                    $s .= 'YYYY';
-                    break;
-                case 'Q':
-                case 'q':
-                    $s .= 'Q';
-                    break;
-
-                case 'M':
-                    $s .= 'Mon';
-                    break;
-
-                case 'm':
-                    $s .= 'MM';
-                    break;
-                case 'D':
-                case 'd':
-                    $s .= 'DD';
-                    break;
-
-                case 'H':
-                    $s.= 'HH24';
-                    break;
-
-                case 'h':
-                    $s .= 'HH';
-                    break;
-
-                case 'i':
-                    $s .= 'MI';
-                    break;
-
-                case 's':
-                    $s .= 'SS';
-                    break;
-
-                case 'a':
-                case 'A':
-                    $s .= 'AM';
-                    break;
-
-                default:
-                    // handle escape characters...
-                    if ($ch == '\\') {
-                        $i++;
-                        $ch = substr($fmt, $i, 1);
-                    }
-                    if (strpos('-/.:;, ', $ch) !== false) {
-                        $s .= $ch;
-                    } else {
-                        $s .= '"' . $ch . '"';
-                    }
+            case 'Y':
+            case 'y':
+                $s .= 'YYYY';
+                break;
+            case 'Q':
+            case 'q':
+                $s .= 'Q';
+                break;
+
+            case 'M':
+                $s .= 'Mon';
+                break;
+
+            case 'm':
+                $s .= 'MM';
+                break;
+            case 'D':
+            case 'd':
+                $s .= 'DD';
+                break;
+
+            case 'H':
+                $s.= 'HH24';
+                break;
+
+            case 'h':
+                $s .= 'HH';
+                break;
+
+            case 'i':
+                $s .= 'MI';
+                break;
+
+            case 's':
+                $s .= 'SS';
+                break;
+
+            case 'a':
+            case 'A':
+                $s .= 'AM';
+                break;
+
+            default:
+                // handle escape characters...
+                if ($ch == '\\') {
+                    $i++;
+                    $ch = substr($fmt, $i, 1);
+                }
+                if (strpos('-/.:;, ', $ch) !== false) {
+                    $s .= $ch;
+                } else {
+                    $s .= '"' . $ch . '"';
+                }
             }
         }
         return $s . "')";

Spacing +5 added lines, -5 removed lines

@@ -9,7 +9,7 @@ 
     {
         for ($i = 0, $numArgs = func_num_args(); $i < $numArgs; $i++) {
             $var = func_get_arg($i);
-            $sql .= ($i == 0 ? "" : " || ") . $var;
+            $sql .= ($i == 0 ? "" : " || ").$var;
         }
 
         return $sql;
@@ -70,7 +70,7 @@ 
     function sqlDate($fmt, $col = false)
     {
         if (!$col) $col = $this->sysTimeStamp;
-        $s = 'TO_CHAR(' . $col . ",'";
+        $s = 'TO_CHAR('.$col.",'";
 
         $len = strlen($fmt);
         for ($i = 0; $i < $len; $i++) {
@@ -98,7 +98,7 @@ 
                     break;
 
                 case 'H':
-                    $s.= 'HH24';
+                    $s .= 'HH24';
                     break;
 
                 case 'h':
@@ -127,11 +127,11 @@ 
                     if (strpos('-/.:;, ', $ch) !== false) {
                         $s .= $ch;
                     } else {
-                        $s .= '"' . $ch . '"';
+                        $s .= '"'.$ch.'"';
                     }
             }
         }
-        return $s . "')";
+        return $s."')";
     }
 
     /**

src/Database/DBMysqlFunctions.php

Switch Indentation +53 added lines, -53 removed lines

@@ -82,59 +82,59 @@
         for ($i = 0; $i < $len; $i++) {
             $ch = $fmt[$i];
             switch ($ch) {
-                case 'Y':
-                case 'y':
-                    $s .= '%Y';
-                    break;
-                case 'Q':
-                case 'q':
-                    $s .= "'),Quarter($col)";
-
-                    if ($len > $i + 1) $s .= ",DATE_FORMAT($col,'";
-                    else $s .= ",('";
-                    $concat = true;
-                    break;
-                case 'M':
-                    $s .= '%b';
-                    break;
-
-                case 'm':
-                    $s .= '%m';
-                    break;
-                case 'D':
-                case 'd':
-                    $s .= '%d';
-                    break;
-
-                case 'H':
-                    $s .= '%H';
-                    break;
-
-                case 'h':
-                    $s .= '%I';
-                    break;
-
-                case 'i':
-                    $s .= '%i';
-                    break;
-
-                case 's':
-                    $s .= '%s';
-                    break;
-
-                case 'a':
-                case 'A':
-                    $s .= '%p';
-                    break;
-
-                default:
-
-                    if ($ch == '\\') {
-                        $i++;
-                        $ch = substr($fmt, $i, 1);
-                    }
-                    $s .= $ch;
-                    break;
+            case 'Y':
+            case 'y':
+                $s .= '%Y';
+                break;
+            case 'Q':
+            case 'q':
+                $s .= "'),Quarter($col)";
+
+                if ($len > $i + 1) $s .= ",DATE_FORMAT($col,'";
+                else $s .= ",('";
+                $concat = true;
+                break;
+            case 'M':
+                $s .= '%b';
+                break;
+
+            case 'm':
+                $s .= '%m';
+                break;
+            case 'D':
+            case 'd':
+                $s .= '%d';
+                break;
+
+            case 'H':
+                $s .= '%H';
+                break;
+
+            case 'h':
+                $s .= '%I';
+                break;
+
+            case 'i':
+                $s .= '%i';
+                break;
+
+            case 's':
+                $s .= '%s';
+                break;
+
+            case 'a':
+            case 'A':
+                $s .= '%p';
+                break;
+
+            default:
+
+                if ($ch == '\\') {
+                    $i++;
+                    $ch = substr($fmt, $i, 1);
+                }
+                $s .= $ch;
+                break;
             }
         }
         $s.="')";

Spacing +3 added lines, -3 removed lines

@@ -14,7 +14,7 @@ 
         $sql = "concat(";
         for ($i = 0, $numArgs = func_num_args(); $i < $numArgs; $i++) {
             $var = func_get_arg($i);
-            $sql .= ($i == 0 ? "" : ",") . $var;
+            $sql .= ($i == 0 ? "" : ",").$var;
         }
         $sql .= ")";
 
@@ -76,7 +76,7 @@ 
     function sqlDate($fmt, $col = false)
     {
         if (!$col) $col = $this->sysTimeStamp;
-        $s = 'DATE_FORMAT(' . $col . ",'";
+        $s = 'DATE_FORMAT('.$col.",'";
         $concat = false;
         $len = strlen($fmt);
         for ($i = 0; $i < $len; $i++) {
@@ -137,7 +137,7 @@ 
                     break;
             }
         }
-        $s.="')";
+        $s .= "')";
         if ($concat) $s = "CONCAT($s)";
         return $s;
     }

src/Repository/JsonDataset.php

Switch Indentation +21 added lines, -21 removed lines

@@ -23,27 +23,27 @@
         $lastError = json_last_error();
         $lastErrorDesc = "";
         switch ($lastError) {
-            case JSON_ERROR_NONE:
-                $lastErrorDesc = 'No errors';
-                break;
-            case JSON_ERROR_DEPTH:
-                $lastErrorDesc = 'Maximum stack depth exceeded';
-                break;
-            case JSON_ERROR_STATE_MISMATCH:
-                $lastErrorDesc = 'Underflow or the modes mismatch';
-                break;
-            case JSON_ERROR_CTRL_CHAR:
-                $lastErrorDesc = 'Unexpected control character found';
-                break;
-            case JSON_ERROR_SYNTAX:
-                $lastErrorDesc = 'Syntax error, malformed JSON';
-                break;
-            case JSON_ERROR_UTF8:
-                $lastErrorDesc = 'Malformed UTF-8 characters, possibly incorrectly encoded';
-                break;
-            default:
-                $lastErrorDesc = 'Unknown error';
-                break;
+        case JSON_ERROR_NONE:
+            $lastErrorDesc = 'No errors';
+            break;
+        case JSON_ERROR_DEPTH:
+            $lastErrorDesc = 'Maximum stack depth exceeded';
+            break;
+        case JSON_ERROR_STATE_MISMATCH:
+            $lastErrorDesc = 'Underflow or the modes mismatch';
+            break;
+        case JSON_ERROR_CTRL_CHAR:
+            $lastErrorDesc = 'Unexpected control character found';
+            break;
+        case JSON_ERROR_SYNTAX:
+            $lastErrorDesc = 'Syntax error, malformed JSON';
+            break;
+        case JSON_ERROR_UTF8:
+            $lastErrorDesc = 'Malformed UTF-8 characters, possibly incorrectly encoded';
+            break;
+        default:
+            $lastErrorDesc = 'Unknown error';
+            break;
         }
 
         if ($lastError != JSON_ERROR_NONE) {

Spacing +1 added lines, -1 removed lines

@@ -47,7 +47,7 @@
         }
 
         if ($lastError != JSON_ERROR_NONE) {
-            throw new DatasetException("Invalid JSON string: " . $lastErrorDesc);
+            throw new DatasetException("Invalid JSON string: ".$lastErrorDesc);
         }
     }
 

src/Repository/IteratorFilter.php

Switch Indentation +98 added lines, -98 removed lines

@@ -141,38 +141,38 @@ 
 
         $result = "";
         switch ($relation) {
-            case Relation::EQUAL: {
-                    $result = $field . "=" . $value;
-                    break;
-                }
-            case Relation::GREATER_THAN: {
-                    $result = $field . ">" . $value;
-                    break;
-                }
-            case Relation::LESS_THAN: {
-                    $result = $field . "<" . $value;
-                    break;
-                }
-            case Relation::GREATER_OR_EQUAL_THAN: {
-                    $result = $field . ">=" . $value;
-                    break;
-                }
-            case Relation::LESS_OR_EQUAL_THAN: {
-                    $result = $field . "<=" . $value;
-                    break;
-                }
-            case Relation::NOT_EQUAL: {
-                    $result = $field . "!=" . $value;
-                    break;
-                }
-            case Relation::STARTS_WITH: {
-                    $result = " starts-with($field, $value) ";
-                    break;
-                }
-            case Relation::CONTAINS: {
-                    $result = " contains($field, $value) ";
-                    break;
-                }
+        case Relation::EQUAL: {
+                $result = $field . "=" . $value;
+                break;
+            }
+        case Relation::GREATER_THAN: {
+                $result = $field . ">" . $value;
+                break;
+            }
+        case Relation::LESS_THAN: {
+                $result = $field . "<" . $value;
+                break;
+            }
+        case Relation::GREATER_OR_EQUAL_THAN: {
+                $result = $field . ">=" . $value;
+                break;
+            }
+        case Relation::LESS_OR_EQUAL_THAN: {
+                $result = $field . "<=" . $value;
+                break;
+            }
+        case Relation::NOT_EQUAL: {
+                $result = $field . "!=" . $value;
+                break;
+            }
+        case Relation::STARTS_WITH: {
+                $result = " starts-with($field, $value) ";
+                break;
+            }
+        case Relation::CONTAINS: {
+                $result = " contains($field, $value) ";
+                break;
+            }
         }
         return $result;
     }
@@ -200,40 +200,40 @@ 
         $field = " $name ";
         $valueparam = " [[" . $paramName . "]] ";
         switch ($relation) {
-            case Relation::EQUAL: {
-                    $result = $field . "=" . $valueparam;
-                    break;
-                }
-            case Relation::GREATER_THAN: {
-                    $result = $field . ">" . $valueparam;
-                    break;
-                }
-            case Relation::LESS_THAN: {
-                    $result = $field . "<" . $valueparam;
-                    break;
-                }
-            case Relation::GREATER_OR_EQUAL_THAN: {
-                    $result = $field . ">=" . $valueparam;
-                    break;
-                }
-            case Relation::LESS_OR_EQUAL_THAN: {
-                    $result = $field . "<=" . $valueparam;
-                    break;
-                }
-            case Relation::NOT_EQUAL: {
-                    $result = $field . "!=" . $valueparam;
-                    break;
-                }
-            case Relation::STARTS_WITH: {
-                    $param[$paramName] = $value . "%";
-                    $result = $field . " like " . $valueparam;
-                    break;
-                }
-            case Relation::CONTAINS: {
-                    $param[$paramName] = "%" . $value . "%";
-                    $result = $field . " like " . $valueparam;
-                    break;
-                }
+        case Relation::EQUAL: {
+                $result = $field . "=" . $valueparam;
+                break;
+            }
+        case Relation::GREATER_THAN: {
+                $result = $field . ">" . $valueparam;
+                break;
+            }
+        case Relation::LESS_THAN: {
+                $result = $field . "<" . $valueparam;
+                break;
+            }
+        case Relation::GREATER_OR_EQUAL_THAN: {
+                $result = $field . ">=" . $valueparam;
+                break;
+            }
+        case Relation::LESS_OR_EQUAL_THAN: {
+                $result = $field . "<=" . $valueparam;
+                break;
+            }
+        case Relation::NOT_EQUAL: {
+                $result = $field . "!=" . $valueparam;
+                break;
+            }
+        case Relation::STARTS_WITH: {
+                $param[$paramName] = $value . "%";
+                $result = $field . " like " . $valueparam;
+                break;
+            }
+        case Relation::CONTAINS: {
+                $param[$paramName] = "%" . $value . "%";
+                $result = $field . " like " . $valueparam;
+                break;
+            }
         }
 
         return $result;
@@ -268,38 +268,38 @@ 
 
             foreach ($field as $valueparam) {
                 switch ($relation) {
-                    case Relation::EQUAL: {
-                            $result[$pos] &= ($valueparam == $value);
-                            break;
-                        }
-                    case Relation::GREATER_THAN: {
-                            $result[$pos] &= ($valueparam > $value);
-                            break;
-                        }
-                    case Relation::LESS_THAN: {
-                            $result[$pos] &= ($valueparam < $value);
-                            break;
-                        }
-                    case Relation::GREATER_OR_EQUAL_THAN: {
-                            $result[$pos] &= ($valueparam >= $value);
-                            break;
-                        }
-                    case Relation::LESS_OR_EQUAL_THAN: {
-                            $result[$pos] &= ($valueparam <= $value);
-                            break;
-                        }
-                    case Relation::NOT_EQUAL: {
-                            $result[$pos] &= ($valueparam != $value);
-                            break;
-                        }
-                    case Relation::STARTS_WITH: {
-                            $result[$pos] &= (strpos($valueparam, $value) === 0);
-                            break;
-                        }
-                    case Relation::CONTAINS: {
-                            $result[$pos] &= (strpos($valueparam, $value) !== false);
-                            break;
-                        }
+                case Relation::EQUAL: {
+                        $result[$pos] &= ($valueparam == $value);
+                        break;
+                    }
+                case Relation::GREATER_THAN: {
+                        $result[$pos] &= ($valueparam > $value);
+                        break;
+                    }
+                case Relation::LESS_THAN: {
+                        $result[$pos] &= ($valueparam < $value);
+                        break;
+                    }
+                case Relation::GREATER_OR_EQUAL_THAN: {
+                        $result[$pos] &= ($valueparam >= $value);
+                        break;
+                    }
+                case Relation::LESS_OR_EQUAL_THAN: {
+                        $result[$pos] &= ($valueparam <= $value);
+                        break;
+                    }
+                case Relation::NOT_EQUAL: {
+                        $result[$pos] &= ($valueparam != $value);
+                        break;
+                    }
+                case Relation::STARTS_WITH: {
+                        $result[$pos] &= (strpos($valueparam, $value) === 0);
+                        break;
+                    }
+                case Relation::CONTAINS: {
+                        $result[$pos] &= (strpos($valueparam, $value) !== false);
+                        break;
+                    }
                 }
             }
         }

Spacing +20 added lines, -20 removed lines

@@ -37,7 +37,7 @@ 
         if ($xpathFilter == "") {
             return "/anydataset/row";
         } else {
-            return "/anydataset/row[" . $xpathFilter . "]";
+            return "/anydataset/row[".$xpathFilter."]";
         }
     }
 
@@ -136,33 +136,33 @@ 
     private function getStrXpathRelation($name, $relation, $value)
     {
         $str = is_numeric($value) ? "" : "'";
-        $field = "field[@name='" . $name . "'] ";
+        $field = "field[@name='".$name."'] ";
         $value = " $str$value$str ";
 
         $result = "";
         switch ($relation) {
             case Relation::EQUAL: {
-                    $result = $field . "=" . $value;
+                    $result = $field."=".$value;
                     break;
                 }
             case Relation::GREATER_THAN: {
-                    $result = $field . ">" . $value;
+                    $result = $field.">".$value;
                     break;
                 }
             case Relation::LESS_THAN: {
-                    $result = $field . "<" . $value;
+                    $result = $field."<".$value;
                     break;
                 }
             case Relation::GREATER_OR_EQUAL_THAN: {
-                    $result = $field . ">=" . $value;
+                    $result = $field.">=".$value;
                     break;
                 }
             case Relation::LESS_OR_EQUAL_THAN: {
-                    $result = $field . "<=" . $value;
+                    $result = $field."<=".$value;
                     break;
                 }
             case Relation::NOT_EQUAL: {
-                    $result = $field . "!=" . $value;
+                    $result = $field."!=".$value;
                     break;
                 }
             case Relation::STARTS_WITH: {
@@ -191,47 +191,47 @@ 
         $paramName = $name;
         $i = 0;
         while (array_key_exists($paramName, $param)) {
-            $paramName = $name . ($i++);
+            $paramName = $name.($i++);
         }
 
         $param[$paramName] = $value;
 
         $result = "";
         $field = " $name ";
-        $valueparam = " [[" . $paramName . "]] ";
+        $valueparam = " [[".$paramName."]] ";
         switch ($relation) {
             case Relation::EQUAL: {
-                    $result = $field . "=" . $valueparam;
+                    $result = $field."=".$valueparam;
                     break;
                 }
             case Relation::GREATER_THAN: {
-                    $result = $field . ">" . $valueparam;
+                    $result = $field.">".$valueparam;
                     break;
                 }
             case Relation::LESS_THAN: {
-                    $result = $field . "<" . $valueparam;
+                    $result = $field."<".$valueparam;
                     break;
                 }
             case Relation::GREATER_OR_EQUAL_THAN: {
-                    $result = $field . ">=" . $valueparam;
+                    $result = $field.">=".$valueparam;
                     break;
                 }
             case Relation::LESS_OR_EQUAL_THAN: {
-                    $result = $field . "<=" . $valueparam;
+                    $result = $field."<=".$valueparam;
                     break;
                 }
             case Relation::NOT_EQUAL: {
-                    $result = $field . "!=" . $valueparam;
+                    $result = $field."!=".$valueparam;
                     break;
                 }
             case Relation::STARTS_WITH: {
-                    $param[$paramName] = $value . "%";
-                    $result = $field . " like " . $valueparam;
+                    $param[$paramName] = $value."%";
+                    $result = $field." like ".$valueparam;
                     break;
                 }
             case Relation::CONTAINS: {
-                    $param[$paramName] = "%" . $value . "%";
-                    $result = $field . " like " . $valueparam;
+                    $param[$paramName] = "%".$value."%";
+                    $result = $field." like ".$valueparam;
                     break;
                 }
         }

src/ConnectionManagement.php

Spacing +2 added lines, -2 removed lines

@@ -181,14 +181,14 @@
         $pat = "/$patDriver($patCredentials$patHost$patDatabase|$patFile)$patExtra/i";
         $parts = array();
         if (!preg_match($pat, $this->getDbConnectionString(), $parts)) {
-            throw new InvalidArgumentException("Connection string " . $this->getDbConnectionString() . " is invalid! Please fix it.");
+            throw new InvalidArgumentException("Connection string ".$this->getDbConnectionString()." is invalid! Please fix it.");
         }
 
         // Set the Driver
         $this->setDriver($parts ['driver']);
 
         if (!isset($parts['path']) && !isset($parts['host'])) {
-            throw new InvalidArgumentException("Connection string " . $this->getDbConnectionString() . " is invalid! Please fix it.");
+            throw new InvalidArgumentException("Connection string ".$this->getDbConnectionString()." is invalid! Please fix it.");
         }
 
 

src/Database/PdoObdc.php

Spacing +1 added lines, -1 removed lines

@@ -10,7 +10,7 @@
 
     public function __construct(ConnectionManagement $connMngt)
     {
-        $strcnn = $connMngt->getDriver() . ":" . $connMngt->getServer();
+        $strcnn = $connMngt->getDriver().":".$connMngt->getServer();
 
         parent::__construct($connMngt, $strcnn, [], []);
     }

src/Database/SQLHelper.php

Spacing +6 added lines, -6 removed lines

@@ -55,8 +55,8 @@ 
                 if ($sql != "") {
                     $sql .= ", ";
                 }
-                $sql .= " " . $this->_fieldDeliLeft . $fieldname . $this->_fieldDeliRight . " = " . $this->getValue($fieldname,
-                        $fieldvalue, $param, $decimalpoint) . " ";
+                $sql .= " ".$this->_fieldDeliLeft.$fieldname.$this->_fieldDeliRight." = ".$this->getValue($fieldname,
+                        $fieldvalue, $param, $decimalpoint)." ";
             }
             $sql = "update $table set $sql where $filter ";
         } elseif ($type == SQLType::SQL_INSERT) {
@@ -68,7 +68,7 @@ 
                     $campos .= ", ";
                     $valores .= ", ";
                 }
-                $campos .= $this->_fieldDeliLeft . $fieldname . $this->_fieldDeliRight;
+                $campos .= $this->_fieldDeliLeft.$fieldname.$this->_fieldDeliRight;
                 $valores .= $this->getValue($fieldname, $fieldvalue, $param, $decimalpoint);
             }
             $sql = "insert into $table ($campos) values ($valores)";
@@ -89,7 +89,7 @@ 
      */
     protected function getValue($name, $valores, &$param, $decimalpoint)
     {
-        $paramName = "[[" . $name . "]]";
+        $paramName = "[[".$name."]]";
         if (!is_array($valores)) {
             $valores = array(SQLFieldType::TEXT, $valores);
         }
@@ -109,7 +109,7 @@ 
         } elseif ($valores[0] == SQLFieldType::DATE) {
             $date = ($valores[1] instanceof DateTime ? $valores[1]->format(DBBaseFunctions::YMDH) : $valores[1]);
             $param[$name] = $date;
-            if (($this->_db->getDbType() == 'oci8') || ( ($this->_db->getDbType() == 'dsn') && (strpos($this->_db->getDbConnectionString(),
+            if (($this->_db->getDbType() == 'oci8') || (($this->_db->getDbType() == 'dsn') && (strpos($this->_db->getDbConnectionString(),
                     "oci8")))) {
                 return "TO_DATE($paramName, 'YYYY-MM-DD')";
             } else {
@@ -139,7 +139,7 @@ 
         if (strlen($sql) > 4) {
             $sql .= ' and ';
         }
-        $sql = " $fieldName " . $relation . " " . $this->getValue($fieldName, $value, $param, $decimalpoint);
+        $sql = " $fieldName ".$relation." ".$this->getValue($fieldName, $value, $param, $decimalpoint);
     }
 
     public function setFieldDelimeters($left, $right)