henrystivens / upload-image-and-data

core/libs/kumbia_active_record/kumbia_active_record.php

Spacing +52 added lines, -52 removed lines

@@ -258,7 +258,7 @@ 
      *
      * @param array $data
      */
-    function __construct($data=null)
+    function __construct($data = null)
     {
         if (!$this->source) {
             $this->_model_name();
@@ -278,7 +278,7 @@ 
 
         if ($data) {
             if (!is_array($data)) $data = Util::getParams(func_get_args());
-            foreach($this->fields as $field) {
+            foreach ($this->fields as $field) {
                 if (isset($data[$field])) {
                     $this->$field = $data[$field];
                 }
@@ -382,8 +382,8 @@ 
         } elseif (array_key_exists($mmodel, $this->_has_and_belongs_to_many)) {
             $relation = $this->_has_and_belongs_to_many[$mmodel];
             $relation_model = self::get($relation->model);
-            $source = ($this->schema ? "{$this->schema}." : NULL ) . $this->source;
-            $relation_source = ($relation_model->schema ? "{$relation_model->schema}." : NULL ) . $relation_model->source;
+            $source = ($this->schema ? "{$this->schema}." : NULL) . $this->source;
+            $relation_source = ($relation_model->schema ? "{$relation_model->schema}." : NULL) . $relation_model->source;
             /**
              * Cargo atraves de que tabla se efectuara la relacion
              *
@@ -394,7 +394,7 @@ 
                 } else {
                     $relation->through = "{$relation_source}_{$this->source}";
                 }
-            }else{
+            } else {
                 $through = explode('/', $relation->through);
                 $relation->through = end($through);
             }
@@ -634,7 +634,7 @@ 
      * @param $key
      * @return array
      */
-    public function get_alias($key=null)
+    public function get_alias($key = null)
     {
         if ($key && array_key_exists($key, $this->alias)) {
             return $this->alias[$key];
@@ -649,7 +649,7 @@ 
      * @param string $key
      * @param string $value
      */
-    public function set_alias($key=null, $value=null)
+    public function set_alias($key = null, $value = null)
     {
         if ($key && array_key_exists($key, $this->alias)) {
             $this->alias[$key] = $value;
@@ -685,7 +685,7 @@ 
      */
     public function begin()
     {
-        $this->_connect();//(true);
+        $this->_connect(); //(true);
         return $this->db->begin();
     }
 
@@ -745,20 +745,20 @@ 
         $what = Util::getParams(func_get_args());
         $select = "SELECT ";
         if (isset($what['columns'])) {
-            $select.= self::sql_sanitize($what['columns']);
+            $select .= self::sql_sanitize($what['columns']);
         } elseif (isset($what['distinct'])) {
-            $select.= 'DISTINCT ';
-            $select.= $what['distinct'] ? self::sql_sanitize($what['distinct']) : join(",", $this->fields);
+            $select .= 'DISTINCT ';
+            $select .= $what['distinct'] ? self::sql_sanitize($what['distinct']) : join(",", $this->fields);
         } else {
-            $select.= join(",", $this->fields);
+            $select .= join(",", $this->fields);
         }
         if ($this->schema) {
-            $select.= " FROM {$this->schema}.{$this->source}";
+            $select .= " FROM {$this->schema}.{$this->source}";
         } else {
-            $select.= " FROM {$this->source}";
+            $select .= " FROM {$this->source}";
         }
         $what['limit'] = 1;
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $resp = false;
 
         $result = $this->db->fetch_one($select);
@@ -789,19 +789,19 @@ 
         $what = Util::getParams(func_get_args());
         $select = "SELECT ";
         if (isset($what['columns'])) {
-            $select.= $what['columns'] ? self::sql_sanitize($what['columns']) : join(",", $this->fields);
+            $select .= $what['columns'] ? self::sql_sanitize($what['columns']) : join(",", $this->fields);
         } elseif (isset($what['distinct'])) {
-            $select.= 'DISTINCT ';
-            $select.= $what['distinct'] ? self::sql_sanitize($what['distinct']) : join(",", $this->fields);
+            $select .= 'DISTINCT ';
+            $select .= $what['distinct'] ? self::sql_sanitize($what['distinct']) : join(",", $this->fields);
         } else {
-            $select.= join(",", $this->fields);
+            $select .= join(",", $this->fields);
         }
         if ($this->schema) {
-            $select.= " FROM {$this->schema}.{$this->source}";
+            $select .= " FROM {$this->schema}.{$this->source}";
         } else {
-            $select.= " FROM {$this->source}";
+            $select .= " FROM {$this->source}";
         }
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $results = array();
         $all_results = $this->db->in_query($select);
         foreach ($all_results AS $result) {
@@ -845,7 +845,7 @@ 
                 self::sql_item_sanitize($this->primary_key[0]);
                 if (isset($what[0])) {
                     if (is_numeric($what[0])) {
-                        $what['conditions'] = "{$this->primary_key[0]} = ".(int)$what[0] ;
+                        $what['conditions'] = "{$this->primary_key[0]} = " . (int) $what[0];
                     } else {
                         if ($what[0] == '') {
                             $what['conditions'] = "{$this->primary_key[0]} = ''";
@@ -856,27 +856,27 @@ 
                 }
             }
             if (isset($what['join'])) {
-                $select.= " {$what['join']}";
+                $select .= " {$what['join']}";
             }
             if (isset($what['conditions'])) {
-                $select.= " WHERE {$what['conditions']}";
+                $select .= " WHERE {$what['conditions']}";
             }
             if (isset($what['group'])) {
-                $select.= " GROUP BY {$what['group']}";
+                $select .= " GROUP BY {$what['group']}";
             }
             if (isset($what['having'])) {
-                $select.= " HAVING {$what['having']}";
+                $select .= " HAVING {$what['having']}";
             }
             if (isset($what['order'])) {
                 self::sql_sanitize($what['order']);
-                $select.= " ORDER BY {$what['order']}";
+                $select .= " ORDER BY {$what['order']}";
             }
             $limit_args = array($select);
             if (isset($what['limit'])) {
-                array_push($limit_args, "limit: ".(int)$what['limit']);
+                array_push($limit_args, "limit: " . (int) $what['limit']);
             }
             if (isset($what['offset'])) {
-                array_push($limit_args, "offset: ".(int)$what['offset']);
+                array_push($limit_args, "offset: " . (int) $what['offset']);
             }
             if (count($limit_args) > 1) {
                 $select = call_user_func_array(array($this, 'limit'), $limit_args);
@@ -884,9 +884,9 @@ 
         } else {
             if (strlen($what)) {
                 if (is_numeric($what)) {
-                    $select.= "WHERE {$this->primary_key[0]} = ".(int)$what[0] ;
+                    $select .= "WHERE {$this->primary_key[0]} = " . (int) $what[0];
                 } else {
-                    $select.= "WHERE $what";
+                    $select .= "WHERE $what";
                 }
             }
         }
@@ -938,7 +938,7 @@ 
          * Se elimina el de indice cero ya que por defecto convert_params_to_sql lo considera como una condicion en WHERE
          */
         unset($what[0]);
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $results = array();
         foreach ($this->db->fetch_all($select) as $result) {
             $results[] = $result[0];
@@ -980,15 +980,15 @@ 
         if (isset($what['distinct']) && $what['distinct']) {
             if (isset($what['group'])) {
                 $select = "SELECT COUNT(*) FROM (SELECT DISTINCT {$what['distinct']} FROM $table ";
-                $select.= $this->convert_params_to_sql($what);
-                $select.= ') AS t ';
+                $select .= $this->convert_params_to_sql($what);
+                $select .= ') AS t ';
             } else {
                 $select = "SELECT COUNT(DISTINCT {$what['distinct']}) FROM $table ";
-                $select.= $this->convert_params_to_sql($what);
+                $select .= $this->convert_params_to_sql($what);
             }
         } else {
             $select = "SELECT COUNT(*) FROM $table ";
-            $select.= $this->convert_params_to_sql($what);
+            $select .= $this->convert_params_to_sql($what);
         }
         $num = $this->db->fetch_one($select);
         return $num[0];
@@ -1018,7 +1018,7 @@ 
             $table = $this->source;
         }
         $select = "SELECT AVG({$what['column']}) FROM $table ";
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $num = $this->db->fetch_one($select);
         return $num[0];
     }
@@ -1041,7 +1041,7 @@ 
             $table = $this->source;
         }
         $select = "SELECT SUM({$what['column']}) FROM $table ";
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $num = $this->db->fetch_one($select);
         return $num[0];
     }
@@ -1070,7 +1070,7 @@ 
             $table = $this->source;
         }
         $select = "SELECT MAX({$what['column']}) FROM $table ";
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $num = $this->db->fetch_one($select);
         return $num[0];
     }
@@ -1099,7 +1099,7 @@ 
             $table = $this->source;
         }
         $select = "SELECT MIN({$what['column']}) FROM $table ";
-        $select.= $this->convert_params_to_sql($what);
+        $select .= $this->convert_params_to_sql($what);
         $num = $this->db->fetch_one($select);
         return $num[0];
     }
@@ -1279,7 +1279,7 @@ 
      * @param array $values array de valores a cargar
      * @return boolean success
      */
-    public function save($values=null)
+    public function save($values = null)
     {
         if ($values) {
             if (!is_array($values))
@@ -1644,7 +1644,7 @@ 
                 }
                 if (isset($this->$np)) {
                     $fields[] = $np;
-                    if (is_null($this->$np) || $this->$np == '' && $this->$np!='0') {
+                    if (is_null($this->$np) || $this->$np == '' && $this->$np != '0') {
                         $values[] = 'NULL';
                     } else {
                         /**
@@ -2006,7 +2006,7 @@ 
      * message: mensaje a mostrar
      * field: nombre de campo a mostrar en el mensaje
      */
-    protected function validates_presence_of($field, $params=array())
+    protected function validates_presence_of($field, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2027,7 +2027,7 @@ 
      * too_long: mensaje a mostrar cuando sea muy largo
      * field: nombre de campo a mostrar en el mensaje
      */
-    protected function validates_length_of($field, $max, $min=0, $params=array())
+    protected function validates_length_of($field, $max, $min = 0, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2047,7 +2047,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_inclusion_in($field, $list, $params=array())
+    protected function validates_inclusion_in($field, $list, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2066,7 +2066,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_exclusion_of($field, $list, $params=array())
+    protected function validates_exclusion_of($field, $list, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2085,7 +2085,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_format_of($field, $pattern, $params=array())
+    protected function validates_format_of($field, $pattern, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2103,7 +2103,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_numericality_of($field, $params=array())
+    protected function validates_numericality_of($field, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2120,7 +2120,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_email_in($field, $params=array())
+    protected function validates_email_in($field, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2137,7 +2137,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_uniqueness_of($field, $params=array())
+    protected function validates_uniqueness_of($field, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());
@@ -2154,7 +2154,7 @@ 
      * message: mensaje a mostrar
      * field: nombre del campo a mostrar en el mensaje
      */
-    protected function validates_date_in($field, $params=array())
+    protected function validates_date_in($field, $params = array())
     {
         if (is_string($params))
             $params = Util::getParams(func_get_args());

core/libs/kumbia_active_record/behaviors/paginate.php

Spacing +4 added lines, -4 removed lines

@@ -79,7 +79,7 @@ 
         if ($page_number < 1 && $per_page < 1) {
             throw new KumbiaException("La página $page_number no existe en el páginador");
         }
-        $start = $per_page * ($page_number - 1);
+        $start = $per_page*($page_number - 1);
         //Instancia del objeto contenedor de página
         $page = new stdClass();
         //Si es un array, se hace páginacion de array
@@ -140,7 +140,7 @@ 
         $page->next = ($start + $per_page) < $n ? ($page_number + 1) : false;
         $page->prev = ($page_number > 1) ? ($page_number - 1) : false;
         $page->current = $page_number;
-        $page->total = ceil($n / $per_page);
+        $page->total = ceil($n/$per_page);
         $page->count = $n;
         $page->per_page = $per_page;
         return $page;
@@ -178,7 +178,7 @@ 
         if ($page_number < 1 || $per_page < 1) {
             throw new KumbiaException("La página $page_number no existe en el páginador");
         }
-        $start = $per_page * ($page_number - 1);
+        $start = $per_page*($page_number - 1);
         //Instancia del objeto contenedor de página
         $page = new stdClass();
         //Cuento las apariciones atraves de una tabla derivada
@@ -193,7 +193,7 @@ 
         $page->next = ($start + $per_page) < $n ? ($page_number + 1) : false;
         $page->prev = ($page_number > 1) ? ($page_number - 1) : false;
         $page->current = $page_number;
-        $page->total = ceil($n / $per_page);
+        $page->total = ceil($n/$per_page);
         $page->count = $n;
         $page->per_page = $per_page;
         return $page;

core/libs/db/db.php

Spacing +1 added lines, -1 removed lines

@@ -85,7 +85,7 @@
             $dbclass = "DbPdo{$config['type']}";
             $db_file = "$path/adapters/pdo/{$config['type']}.php";
         } else {
-            if($config['type'] == 'mysql') $config['type'] = 'mysqli';
+            if ($config['type'] == 'mysql') $config['type'] = 'mysqli';
             $dbclass = "Db{$config['type']}";
             $db_file = "$path/adapters/{$config['type']}.php";
         }

core/libs/db/adapters/mysqli.php

Spacing +17 added lines, -17 removed lines

@@ -121,7 +121,7 @@ 
 
         $this->id_connection = new mysqli($config['host'], $config['username'], $config['password'], $config['name'], $config['port']);
         //no se usa $object->error() ya que solo funciona a partir de 5.2.9 y 5.3
-        if (mysqli_connect_error ()) throw new KumbiaException(mysqli_connect_error());
+        if (mysqli_connect_error()) throw new KumbiaException(mysqli_connect_error());
         //Selecciona charset
         if (isset($config['charset'])) $this->id_connection->set_charset($config['charset']);
         return TRUE;
@@ -168,7 +168,7 @@ 
      * @param int $opt
      * @return array
      */
-    public function fetch_array($result_query='', $opt=MYSQLI_BOTH)
+    public function fetch_array($result_query = '', $opt = MYSQLI_BOTH)
     {
         if (!$result_query) {
             $result_query = $this->last_result_query;
@@ -192,7 +192,7 @@ 
     /**
      * Devuelve el numero de filas de un select
      */
-    public function num_rows($result_query='')
+    public function num_rows($result_query = '')
     {
         if (!$result_query) {
             $result_query = $this->last_result_query;
@@ -214,7 +214,7 @@ 
      * @param resource $result_query
      * @return string
      */
-    public function field_name($number, $result_query='')
+    public function field_name($number, $result_query = '')
     {
 
         if (!$result_query) {
@@ -238,7 +238,7 @@ 
      * @param resource $result_query
      * @return boolean
      */
-    public function data_seek($number, $result_query='')
+    public function data_seek($number, $result_query = '')
     {
         if (!$result_query) {
             $result_query = $this->last_result_query;
@@ -259,7 +259,7 @@ 
      * @param resource $result_query
      * @return int
      */
-    public function affected_rows($result_query='')
+    public function affected_rows($result_query = '')
     {
         if (($numberRows = mysqli_affected_rows($this->id_connection)) !== false) {
             return $numberRows;
@@ -273,10 +273,10 @@ 
      *
      * @return string
      */
-    public function error($err='')
+    public function error($err = '')
     {
         $this->last_error = mysqli_error($this->id_connection) ? mysqli_error($this->id_connection) : "[Error Desconocido en MySQL: $err]";
-        $this->last_error.= $err;
+        $this->last_error .= $err;
         if ($this->logger) {
             Logger::error($this->last_error);
         }
@@ -298,7 +298,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         return mysqli_insert_id($this->id_connection);
     }
@@ -309,7 +309,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema='')
+    public function table_exists($table, $schema = '')
     {
         $table = addslashes("$table");
         if ($schema == '') {
@@ -333,11 +333,11 @@ 
         $sql_new = $sql;
 
         if (isset($params['limit']) && is_numeric($params['limit'])) {
-            $sql_new.=" LIMIT $params[limit]";
+            $sql_new .= " LIMIT $params[limit]";
         }
 
         if (isset($params['offset']) && is_numeric($params['offset'])) {
-            $sql_new.=" OFFSET $params[offset]";
+            $sql_new .= " OFFSET $params[offset]";
         }
 
         return $sql_new;
@@ -349,7 +349,7 @@ 
      * @param string $table
      * @return resource
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             return $this->query("DROP TABLE IF EXISTS $table");
@@ -371,7 +371,7 @@ 
      * @param array $definition
      * @return resource
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -421,7 +421,7 @@ 
             }
             $create_lines[] = "`$field` " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -433,7 +433,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -454,7 +454,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         if ($schema == '') {
             return $this->fetch_all("DESCRIBE `$table`");

core/libs/db/adapters/pdo.php

Spacing +13 added lines, -13 removed lines

@@ -196,7 +196,7 @@ 
      * @param int $opt
      * @return array
      */
-    public function fetch_array($pdo_statement=NULL, $opt='')
+    public function fetch_array($pdo_statement = NULL, $opt = '')
     {
         if ($opt === '') {
             $opt = self::DB_BOTH;
@@ -235,7 +235,7 @@ 
      * @deprecated
      * @return int
      */
-    public function num_rows($pdo_statement='')
+    public function num_rows($pdo_statement = '')
     {
         if ($pdo_statement) {
             $pdo = clone $pdo_statement;
@@ -252,7 +252,7 @@ 
      * @param resource $pdo_statement
      * @return string
      */
-    public function field_name($number, $pdo_statement=NULL)
+    public function field_name($number, $pdo_statement = NULL)
     {
         if (!$this->pdo) {
             throw new KumbiaException('No hay conexión para realizar esta acción');
@@ -278,7 +278,7 @@ 
      * @param PDOStatement $pdo_statement
      * @return boolean
      */
-    public function data_seek($number, $pdo_statement=NULL)
+    public function data_seek($number, $pdo_statement = NULL)
     {
         return false;
     }
@@ -290,7 +290,7 @@ 
      * @deprecated
      * @return int
      */
-    public function affected_rows($pdo_statement=NULL)
+    public function affected_rows($pdo_statement = NULL)
     {
         if (!$this->pdo) {
             throw new KumbiaException('No hay conexión para realizar esta acción');
@@ -315,7 +315,7 @@ 
      *
      * @return string
      */
-    public function error($err='')
+    public function error($err = '')
     {
         if ($this->pdo) {
             $error = $this->pdo->errorInfo();
@@ -323,7 +323,7 @@ 
         } else {
             $error = "";
         }
-        $this->last_error.= $error . " [" . $err . "]";
+        $this->last_error .= $error . " [" . $err . "]";
         if ($this->logger) {
             Logger::error($this->last_error);
         }
@@ -335,7 +335,7 @@ 
      *
      * @return int
      */
-    public function no_error($number=0)
+    public function no_error($number = 0)
     {
         if ($this->pdo) {
             $error = $this->pdo->errorInfo();
@@ -349,7 +349,7 @@ 
      *
      * @return string
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         return $this->pdo->lastInsertId();
     }
@@ -399,7 +399,7 @@ 
      * @param array $fields
      * @return integer
      */
-    public function insert($table, $values, $fields=null)
+    public function insert($table, $values, $fields = null)
     {
         //$insert_sql = "";
         if (is_array($values)) {
@@ -426,7 +426,7 @@ 
      * @param string $where_condition
      * @return integer
      */
-    public function update($table, $fields, $values, $where_condition=null)
+    public function update($table, $fields, $values, $where_condition = null)
     {
         $update_sql = "UPDATE $table SET ";
         if (count($fields) != count($values)) {
@@ -438,9 +438,9 @@ 
             $update_values[] = $field . ' = ' . $values[$i];
             $i++;
         }
-        $update_sql.= join(',', $update_values);
+        $update_sql .= join(',', $update_values);
         if ($where_condition != null) {
-            $update_sql.= " WHERE $where_condition";
+            $update_sql .= " WHERE $where_condition";
         }
         return $this->exec($update_sql);
     }

core/libs/db/adapters/oracle.php

Spacing +15 added lines, -15 removed lines

@@ -195,7 +195,7 @@ 
      * @param int $opt
      * @return array
      */
-    function fetch_array($resultQuery=NULL, $opt=OCI_BOTH)
+    function fetch_array($resultQuery = NULL, $opt = OCI_BOTH)
     {
 
         if (!$resultQuery) {
@@ -228,7 +228,7 @@ 
     /**
      * Devuelve el numero de filas de un select
      */
-    function num_rows($resultQuery=NULL)
+    function num_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -267,7 +267,7 @@ 
      * @param resource $resultQuery
      * @return string
      */
-    function field_name($number, $resultQuery=NULL)
+    function field_name($number, $resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -291,7 +291,7 @@ 
      * @param resource $resultQuery
      * @return boolean
      */
-    function data_seek($number, $resultQuery=NULL)
+    function data_seek($number, $resultQuery = NULL)
     {
         if (!$resultQuery) {
             $resultQuery = $this->last_result_query;
@@ -325,7 +325,7 @@ 
      * @param resource $resultQuery
      * @return int
      */
-    function affected_rows($resultQuery=NULL)
+    function affected_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -346,12 +346,12 @@ 
      *
      * @return string
      */
-    function error($err='')
+    function error($err = '')
     {
         if (!$this->id_connection) {
             $error = oci_error() ? oci_error() : "[Error Desconocido en Oracle]";
             if (is_array($error)) {
-                $error['message'].=" > $err ";
+                $error['message'] .= " > $err ";
                 return $error['message'];
             } else {
                 //$error.=" $php_errormsg ";
@@ -360,7 +360,7 @@ 
         }
         $error = oci_error($this->id_connection);
         if ($error) {
-            $error['message'].=" > $err ";
+            $error['message'] .= " > $err ";
         } else {
             $error['message'] = $err;
         }
@@ -418,7 +418,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -444,7 +444,7 @@ 
      * @param array $definition
      * @return resource
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -494,7 +494,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -506,7 +506,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -526,7 +526,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         if (!$this->id_connection) {
             return false;
@@ -548,7 +548,7 @@ 
      * @param string $table
      * @return boolean
      */
-    function table_exists($table, $schema='')
+    function table_exists($table, $schema = '')
     {
         $num = $this->fetch_one("SELECT COUNT(*) FROM ALL_TABLES WHERE TABLE_NAME = '" . strtoupper($table) . "'");
         return $num[0];
@@ -560,7 +560,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         /**
          * Soporta schemas?

core/libs/db/adapters/mssql.php

Spacing +54 added lines, -54 removed lines

@@ -26,7 +26,7 @@ 
  * @package    Db
  * @subpackage Adapters
  */
-class DbMsSQL extends DbBase implements DbBaseInterface  {
+class DbMsSQL extends DbBase implements DbBaseInterface {
 
     /**
      * Resource de la Conexión a MsSQL
@@ -116,17 +116,17 @@ 
      * @param array $config
      * @return bool
      */
-    public function connect($config){
-        if(!extension_loaded('mssql')){
+    public function connect($config) {
+        if (!extension_loaded('mssql')) {
             throw new KumbiaException('Debe cargar la extensión de PHP llamada php_mssql');
         }
-        if(!isset($config['port']) || !$config['port']) {
+        if (!isset($config['port']) || !$config['port']) {
             $config['port'] = 1433;
         }
         //if($this->id_connection = mssql_connect("{$config['host']},{$config['port']}", $config['username'], $config['password'], true)){
-        if($this->id_connection = mssql_connect($config['host'], $config['username'], $config['password'], true)){
-            if($config['name']!=='') {
-                if(!mssql_select_db($config['name'], $this->id_connection)){
+        if ($this->id_connection = mssql_connect($config['host'], $config['username'], $config['password'], true)) {
+            if ($config['name'] !== '') {
+                if (!mssql_select_db($config['name'], $this->id_connection)) {
                     throw new KumbiaException($this->error());
                 }
             }
@@ -141,25 +141,25 @@ 
      * @param string $sql_query
      * @return resource or false
      */
-    public function query($sql_query){
+    public function query($sql_query) {
         $this->debug($sql_query);
-        if($this->logger){
+        if ($this->logger) {
             Logger::debug($sql_query);
         }
 
         $this->last_query = $sql_query;
-        if($result_query = mssql_query($sql_query, $this->id_connection)){
+        if ($result_query = mssql_query($sql_query, $this->id_connection)) {
             $this->last_result_query = $result_query;
             return $result_query;
-        }else{
+        } else {
             throw new KumbiaException($this->error(" al ejecutar <em>\"$sql_query\"</em>"));
         }
     }
     /**
      * Cierra la Conexión al Motor de Base de datos
      */
-    public function close(){
-        if($this->id_connection) {
+    public function close() {
+        if ($this->id_connection) {
             return mssql_close();
         }
         return false;
@@ -171,11 +171,11 @@ 
      * @param int $opt
      * @return array
      */
-    public function fetch_array($result_query='', $opt=MSSQL_BOTH){
+    public function fetch_array($result_query = '', $opt = MSSQL_BOTH) {
 
-        if(!$result_query){
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
@@ -186,21 +186,21 @@ 
      *
      * @param array $config
      */
-    public function __construct($config){
+    public function __construct($config) {
         $this->connect($config);
     }
     /**
      * Devuelve el número de filas de un select
      */
-    public function num_rows($result_query=''){
+    public function num_rows($result_query = '') {
 
-        if(!$result_query){
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
-        if(($number_rows = mssql_num_rows($result_query))!==false){
+        if (($number_rows = mssql_num_rows($result_query)) !== false) {
             return $number_rows;
         } else {
             throw new KumbiaException($this->error());
@@ -214,15 +214,15 @@ 
      * @param resource $result_query
      * @return string
      */
-    public function field_name($number, $result_query=''){
+    public function field_name($number, $result_query = '') {
 
-        if(!$result_query){
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
-        if(($fieldName = mssql_field_name($result_query, $number))!==false){
+        if (($fieldName = mssql_field_name($result_query, $number)) !== false) {
             return $fieldName;
         } else {
             throw new KumbiaException($this->error());
@@ -235,14 +235,14 @@ 
      * @param resource $result_query
      * @return boolean
      */
-    public function data_seek($number, $result_query=''){
-        if(!$result_query){
+    public function data_seek($number, $result_query = '') {
+        if (!$result_query) {
             $result_query = $this->last_result_query;
-            if(!$result_query){
+            if (!$result_query) {
                 return false;
             }
         }
-        if(($success = mssql_data_seek($result_query, $number))!==false){
+        if (($success = mssql_data_seek($result_query, $number)) !== false) {
             return $success;
         } else {
             throw new KumbiaException($this->error());
@@ -255,8 +255,8 @@ 
      * @param resource $result_query
      * @return int
      */
-    public function affected_rows($result_query=''){
-        if(($numberRows = mssql_affected_rows())!==false){
+    public function affected_rows($result_query = '') {
+        if (($numberRows = mssql_affected_rows()) !== false) {
             return $numberRows;
         } else {
             throw new KumbiaException($this->error());
@@ -268,17 +268,17 @@ 
      *
      * @return string
      */
-    public function error($err=''){
-        if(!$this->id_connection){
+    public function error($err = '') {
+        if (!$this->id_connection) {
             $this->last_error = mssql_get_last_message() ? mssql_get_last_message() : "[Error Desconocido en MsSQL: $err]";
-            if($this->logger){
+            if ($this->logger) {
                 Logger::error($this->last_error);
             }
             return $this->last_error;
         }
         $this->last_error = mssql_get_last_message() ? mssql_get_last_message() : "[Error Desconocido en MsSQL: $err]";
-        $this->last_error.= $err;
-        if($this->logger){
+        $this->last_error .= $err;
+        if ($this->logger) {
             Logger::error($this->last_error);
         }
         return $this->last_error;
@@ -288,7 +288,7 @@ 
      *
      * @return int
      */
-    public function no_error(){
+    public function no_error() {
         return mssql_errno();
     }
     /**
@@ -296,7 +296,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key=''){
+    public function last_insert_id($table = '', $primary_key = '') {
 
         //$id = false;
         $result = mssql_query("select max({$primary_key}) from $table");
@@ -312,9 +312,9 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema=''){
+    public function table_exists($table, $schema = '') {
         $table = addslashes("$table");
-        if($schema==''){
+        if ($schema == '') {
             $num = $this->fetch_one("SELECT COUNT(*) FROM
                         INFORMATION_SCHEMA.TABLES
                         WHERE TABLE_NAME = '$table'");
@@ -333,11 +333,11 @@ 
      * @param string $sql consulta sql
      * @return string
      */
-    public function limit($sql){
+    public function limit($sql) {
         $params = Util::getParams(func_get_args());
 
         //TODO: añadirle el offset
-        if(isset($params['limit'])){
+        if (isset($params['limit'])) {
             $sql = str_ireplace("SELECT ", "SELECT TOP $params[limit] ", $sql);
         }
         return $sql;
@@ -349,8 +349,8 @@ 
      * @param string $table
      * @return resource
      */
-    public function drop_table($table, $if_exists=true){
-        if($if_exists){
+    public function drop_table($table, $if_exists = true) {
+        if ($if_exists) {
             $sql = "IF EXISTS(SELECT TABLE_NAME FROM
             INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '$table')
             DROP TABLE $table;";
@@ -364,7 +364,7 @@ 
      *
      * @return array
      */
-    public function list_tables(){
+    public function list_tables() {
         return $this->fetch_all("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
     }
 
@@ -388,20 +388,20 @@ 
         return $this->fetch_all($sql);
     }
     */
-        public function describe_table($table, $schema=''){
+        public function describe_table($table, $schema = '') {
                 $describeTable = $this->fetch_all("exec sp_columns @table_name = '$table'");
                 $finalDescribe = array();
-                foreach($describeTable as $field){
+                foreach ($describeTable as $field) {
                         $finalDescribe[] = array(
                                 'Field' => $field['COLUMN_NAME'],
-                                'Type' => $field['LENGTH'] ? $field['TYPE_NAME'] : $field['TYPE_NAME'].'('.$field['LENGTH'].')',
+                                'Type' => $field['LENGTH'] ? $field['TYPE_NAME'] : $field['TYPE_NAME'] . '(' . $field['LENGTH'] . ')',
                                 'Null' => $field['NULLABLE'] == 1 ? 'YES' : 'NO'
                         );
                 }
                 $describeKeys = $this->fetch_all("exec sp_pkeys @table_name = '$table'");
-                foreach($describeKeys as $field){
-                        for($i=0;$i<=count($finalDescribe)-1;++$i){
-                                if($finalDescribe[$i]['Field']==$field['COLUMN_NAME']){
+                foreach ($describeKeys as $field) {
+                        for ($i = 0; $i <= count($finalDescribe) - 1; ++$i) {
+                                if ($finalDescribe[$i]['Field'] == $field['COLUMN_NAME']) {
                                         $finalDescribe[$i]['Key'] = 'PRI';
                                 } else {
                                         $finalDescribe[$i]['Key'] = "";
@@ -418,14 +418,14 @@ 
      * @param resource $result_query
      * @return object
      */
-    public function fetch_object($result_query = NULL){
-        if(!$result_query){
+    public function fetch_object($result_query = NULL) {
+        if (!$result_query) {
             $result_query = $this->last_result_query;
         }
         return mssql_fetch_object($result_query);
     }
 
-    public function create_table ($table, $definition, $index = array()){
+    public function create_table($table, $definition, $index = array()) {
 
     }
 }

core/libs/db/adapters/pgsql.php

Spacing +17 added lines, -17 removed lines

@@ -174,7 +174,7 @@ 
      * @param int $opt
      * @return array
      */
-    function fetch_array($resultQuery=NULL, $opt=PGSQL_BOTH)
+    function fetch_array($resultQuery = NULL, $opt = PGSQL_BOTH)
     {
 
         if (!$resultQuery) {
@@ -199,7 +199,7 @@ 
     /**
      * Devuelve el numero de filas de un select
      */
-    function num_rows($resultQuery=NULL)
+    function num_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -222,7 +222,7 @@ 
      * @param resource $resultQuery
      * @return string
      */
-    function field_name($number, $resultQuery=NULL)
+    function field_name($number, $resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -245,7 +245,7 @@ 
      * @param resource $resultQuery
      * @return boolean
      */
-    function data_seek($number, $resultQuery=NULL)
+    function data_seek($number, $resultQuery = NULL)
     {
         if (!$resultQuery) {
             $resultQuery = $this->last_result_query;
@@ -266,7 +266,7 @@ 
      * @param resource $resultQuery
      * @return int
      */
-    function affected_rows($resultQuery=NULL)
+    function affected_rows($resultQuery = NULL)
     {
 
         if (!$resultQuery) {
@@ -287,7 +287,7 @@ 
      *
      * @return string
      */
-    function error($err='')
+    function error($err = '')
     {
         if (!$this->id_connection) {
             $this->last_error = @pg_last_error() ? @pg_last_error() . $err : "[Error Desconocido en PostgreSQL \"$err\"]";
@@ -297,7 +297,7 @@ 
             return $this->last_error;
         }
         $this->last_error = @pg_last_error() ? @pg_last_error() . $err : "[Error Desconocido en PostgreSQL: $err]";
-        $this->last_error.= $err;
+        $this->last_error .= $err;
         if ($this->logger) {
             Logger::error($this->last_error);
         }
@@ -320,7 +320,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
 
         $last_id = $this->fetch_one("SELECT CURRVAL('{$table}_{$primary_key}_seq')");
@@ -333,7 +333,7 @@ 
      * @param string $table
      * @return boolean
      */
-    function table_exists($table, $schema='')
+    function table_exists($table, $schema = '')
     {
         $table = addslashes(strtolower($table));
         if (strpos($table, ".")) {
@@ -360,11 +360,11 @@ 
         $sql_new = $sql;
 
         if (isset($params['limit']) && is_numeric($params['limit'])) {
-            $sql_new.=" LIMIT $params[limit]";
+            $sql_new .= " LIMIT $params[limit]";
         }
 
         if (isset($params['offset']) && is_numeric($params['offset'])) {
-            $sql_new.=" OFFSET $params[offset]";
+            $sql_new .= " OFFSET $params[offset]";
         }
 
         return $sql_new;
@@ -376,7 +376,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -402,7 +402,7 @@ 
      * @param array $definition
      * @return resource
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -452,7 +452,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -464,7 +464,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -493,7 +493,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         $describe = $this->fetch_all("SELECT a.attname AS Field, t.typname AS Type,
                 CASE WHEN attnotnull=false THEN 'YES' ELSE 'NO' END AS Null,
@@ -523,7 +523,7 @@ 
      * @param string $class clase de objeto
      * @return object
      */
-    public function fetch_object($query_result=null, $class='stdClass')
+    public function fetch_object($query_result = null, $class = 'stdClass')
     {
         if (!$query_result) {
             $query_result = $this->last_result_query;

core/libs/db/adapters/firebird.php

Spacing +17 added lines, -17 removed lines

@@ -175,9 +175,9 @@ 
      * @param int $opt
      * @return array
      */
-    public function fetch_array($result_query=NULL, $opt=MYSQL_BOTH)
+    public function fetch_array($result_query = NULL, $opt = MYSQL_BOTH)
     {
-        $result=array();
+        $result = array();
         if (!$result_query) {
             $result_query = $this->last_result_query;
             if (!$result_query) {
@@ -216,7 +216,7 @@ 
     /**
      * Devuelve el numero de filas de un select
      */
-    public function num_rows($result_query='')
+    public function num_rows($result_query = '')
     {
         // GDS Interbase no soporta esta funcion (No debe ser usada)
         return false;
@@ -229,7 +229,7 @@ 
      * @param resource $result_query
      * @return string
      */
-    public function field_name($number, $result_query='')
+    public function field_name($number, $result_query = '')
     {
 
         if (!$result_query) {
@@ -252,7 +252,7 @@ 
      * @param resource $result_query
      * @return boolean
      */
-    public function data_seek($number, $result_query=NULL)
+    public function data_seek($number, $result_query = NULL)
     {
         if (!$result_query) {
             $result_query = $this->last_result_query;
@@ -273,7 +273,7 @@ 
      * @param resource $result_query
      * @return int
      */
-    public function affected_rows($result_query=NULL)
+    public function affected_rows($result_query = NULL)
     {
         if (($numberRows = ibase_affected_rows()) !== false) {
             return $numberRows;
@@ -287,7 +287,7 @@ 
      *
      * @return string
      */
-    public function error($err='')
+    public function error($err = '')
     {
         if (!$this->id_connection) {
             $this->last_error = ibase_errmsg() ? ibase_errmsg() : "[Error Desconocido en Firebird: $err]";
@@ -297,7 +297,7 @@ 
             return $this->last_error;
         }
         $this->last_error = ibase_errmsg() ? ibase_errmsg() : "[Error Desconocido en Firebird: $err]";
-        $this->last_error.= $err;
+        $this->last_error .= $err;
         if ($this->logger) {
             Logger::error($this->last_error);
         }
@@ -336,7 +336,7 @@ 
      *
      * @return int
      */
-    public function last_insert_id($table='', $primary_key='')
+    public function last_insert_id($table = '', $primary_key = '')
     {
         return ibase_insert_id($this->id_connection);
     }
@@ -347,7 +347,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function table_exists($table, $schema='')
+    public function table_exists($table, $schema = '')
     {
         $table = strtoupper(addslashes("$table"));
         // NOT LIKE 'RDB\$%'
@@ -367,11 +367,11 @@ 
         $sql_new = $sql;
 
         if (isset($params['limit']) && is_numeric($params['limit'])) {
-            $sql_new.=" FIRST $params[limit]";
+            $sql_new .= " FIRST $params[limit]";
         }
 
         if (isset($params['offset']) && is_numeric($params['offset'])) {
-            $sql_new.=" SKIP $params[offset]";
+            $sql_new .= " SKIP $params[offset]";
         }
 
         return $sql_new;
@@ -383,7 +383,7 @@ 
      * @param string $table
      * @return boolean
      */
-    public function drop_table($table, $if_exists=true)
+    public function drop_table($table, $if_exists = true)
     {
         if ($if_exists) {
             if ($this->table_exists($table)) {
@@ -409,7 +409,7 @@ 
      * @param array $definition
      * @return resource
      */
-    public function create_table($table, $definition, $index=array())
+    public function create_table($table, $definition, $index = array())
     {
         $create_sql = "CREATE TABLE $table (";
         if (!is_array($definition)) {
@@ -463,7 +463,7 @@ 
             }
             $create_lines[] = "$field " . $field_def['type'] . $size . ' ' . $not_null . ' ' . $extra;
         }
-        $create_sql.= join(',', $create_lines);
+        $create_sql .= join(',', $create_lines);
         $last_lines = array();
         if (count($primary)) {
             $last_lines[] = 'PRIMARY KEY(' . join(",", $primary) . ')';
@@ -475,7 +475,7 @@ 
             $last_lines[] = join(',', $unique_index);
         }
         if (count($last_lines)) {
-            $create_sql.= ',' . join(',', $last_lines) . ')';
+            $create_sql .= ',' . join(',', $last_lines) . ')';
         }
         return $this->query($create_sql);
     }
@@ -496,7 +496,7 @@ 
      * @param string $table
      * @return array
      */
-    public function describe_table($table, $schema='')
+    public function describe_table($table, $schema = '')
     {
         if ($schema == '') {
             return $this->fetch_all("DESCRIBE $table");