joenilson / fsRepublicaDominicana

Model/NCFRango.php

Spacing +1 added lines, -1 removed lines

@@ -184,7 +184,7 @@
                 . $idempresa
                 . ' AND tipocomprobante = '
                 . $dataBase->var2str($tipocomprobante)
-                . ' AND estado = ' . $dataBase->var2str(true)
+                . ' AND estado = '.$dataBase->var2str(true)
                 . ';';
         $data = $dataBase->select($sql);
         if (in_array($data[0], [null, ''], true)) {

Model/Join/FiscalReport606.php

Spacing +19 added lines, -19 removed lines

@@ -69,17 +69,17 @@ 
     protected function getGroupFields(): string
     {
         //return parent::getGroupFields(); // TODO: Change the autogenerated stub
-        return  static::MAIN_TABLE.'.idfactura, ' .
-                static::MAIN_TABLE.'.idempresa, ' .
-                static::MAIN_TABLE.'.codalmacen, ' .
-                static::MAIN_TABLE.'.cifnif, ' .
-                static::MAIN_TABLE.'.ncftipomovimiento, ' .
-                static::MAIN_TABLE.'.numproveedor, ' .
-                static::SECONDARY_TABLE_ALIAS.'.numproveedor, ' .
-                static::MAIN_TABLE.'.fecha, ' .
-                static::ESTADOSDOC_TABLE.'.nombre, ' .
-                static::MAIN_TABLE.'.neto, ' .
-                static::MAIN_TABLE.'.totaliva' .
+        return  static::MAIN_TABLE.'.idfactura, '.
+                static::MAIN_TABLE.'.idempresa, '.
+                static::MAIN_TABLE.'.codalmacen, '.
+                static::MAIN_TABLE.'.cifnif, '.
+                static::MAIN_TABLE.'.ncftipomovimiento, '.
+                static::MAIN_TABLE.'.numproveedor, '.
+                static::SECONDARY_TABLE_ALIAS.'.numproveedor, '.
+                static::MAIN_TABLE.'.fecha, '.
+                static::ESTADOSDOC_TABLE.'.nombre, '.
+                static::MAIN_TABLE.'.neto, '.
+                static::MAIN_TABLE.'.totaliva'.
             ' ';
     }
 
@@ -90,14 +90,14 @@ 
     protected function getSQLFrom(): string
     {
         return static::MAIN_TABLE
-            . ' LEFT JOIN '. static::SECONDARY_TABLE . ' ON ('
-            . static::MAIN_TABLE . '.idfacturarect = ' . static::SECONDARY_TABLE_ALIAS . '.idfactura)'
-            . ' LEFT JOIN '. static::LINES_TABLE . ' ON ('
-            . static::MAIN_TABLE . '.idfactura = ' . static::LINES_TABLE . '.idfactura)'
-            . ' LEFT JOIN '. static::PRODS_TABLE . ' ON ('
-            . static::LINES_TABLE . '.referencia = ' . static::PRODS_TABLE . '.referencia)'
-            . ' LEFT JOIN ' . static::ESTADOSDOC_TABLE . ' ON ('
-            . static::MAIN_TABLE . '.idestado = ' . static::ESTADOSDOC_TABLE . '.idestado)';
+            . ' LEFT JOIN '.static::SECONDARY_TABLE.' ON ('
+            . static::MAIN_TABLE.'.idfacturarect = '.static::SECONDARY_TABLE_ALIAS.'.idfactura)'
+            . ' LEFT JOIN '.static::LINES_TABLE.' ON ('
+            . static::MAIN_TABLE.'.idfactura = '.static::LINES_TABLE.'.idfactura)'
+            . ' LEFT JOIN '.static::PRODS_TABLE.' ON ('
+            . static::LINES_TABLE.'.referencia = '.static::PRODS_TABLE.'.referencia)'
+            . ' LEFT JOIN '.static::ESTADOSDOC_TABLE.' ON ('
+            . static::MAIN_TABLE.'.idestado = '.static::ESTADOSDOC_TABLE.'.idestado)';
     }
 
     /**

Model/RNCDGIIDB.php

Spacing +11 added lines, -11 removed lines

@@ -133,7 +133,7 @@ 
     private function slowParser()
     {
         $dataBase = new DataBase();
-        $sqlDelete = "DELETE FROM " . $this->tableName() . ";";
+        $sqlDelete = "DELETE FROM ".$this->tableName().";";
         $dataBase->exec($sqlDelete);
 
         [$handle, $totalLines] = $this->utf8FopenRead($this->fileNameTxt);
@@ -142,7 +142,7 @@ 
         while (($raw_string = fgets($handle)) !== false) {
             $totalLines--;
             if ($maxLine === 2000) {
-                $query = 'INSERT INTO ' . $this->tableName() .
+                $query = 'INSERT INTO '.$this->tableName().
                     ' (rnc, nombre, razonsocial, categoria, inicioactividad, estado, regimenpagos) VALUES ';
             }
             $linea = str_getcsv($raw_string, "|");
@@ -159,7 +159,7 @@ 
                 $maxLine--;
                 $lineNumber++;
             } else {
-                $this->toolBox()->i18nLog()->error("Error RNC TXT Linea: ".count($linea) . " - " . $raw_string);
+                $this->toolBox()->i18nLog()->error("Error RNC TXT Linea: ".count($linea)." - ".$raw_string);
             }
         }
         fclose($handle);
@@ -171,14 +171,14 @@ 
         $fecha = ($colArray[8] === '00/00/0000')
             ? "2000-01-01"
             : \date('Y-m-d', strtotime(str_replace("/", "-", $colArray[8])));
-        return "('" .
-            $colArray[0] . "','" .
-            str_replace('"', '', str_replace("'", "''", str_replace("  ", " ", $colArray[1]))) . "','" .
-            str_replace('"', '', str_replace("'", "''", str_replace("  ", " ", $colArray[2]))) . "','" .
-            $colArray[3] . "','" .
-            $fecha . "','" .
-            $colArray[9] . "','" .
-            $colArray[10] . "')" . $semiColon;
+        return "('".
+            $colArray[0]."','".
+            str_replace('"', '', str_replace("'", "''", str_replace("  ", " ", $colArray[1])))."','".
+            str_replace('"', '', str_replace("'", "''", str_replace("  ", " ", $colArray[2])))."','".
+            $colArray[3]."','".
+            $fecha."','".
+            $colArray[9]."','".
+            $colArray[10]."')".$semiColon;
     }
 
     private function utf8FopenRead($fileName)