Pleets / SQLWebManager

module/Auth/source/Controller/LogOut.php

Braces +3 added lines, -2 removed lines

@@ -30,8 +30,9 @@
         switch ($method)
         {
             case '_COOKIE':
-                if (array_key_exists($key, $_COOKIE) || !empty($_COOKIE[$key]))
-                    setcookie($key, $_COOKIE[$key], time() - 1, '/');
+                if (array_key_exists($key, $_COOKIE) || !empty($_COOKIE[$key])) {
+                                    setcookie($key, $_COOKIE[$key], time() - 1, '/');
+                }
                 break;
 
             case '_SESSION':

module/Auth/source/Model/Authentication.php

Braces +3 added lines, -2 removed lines

@@ -21,9 +21,10 @@
         $db->setDbuser($user);
         $db->setDbpass($pass);
 
-        if ($db->isConnected())
-            return $db->reconnect()
+        if ($db->isConnected()) {
+                    return $db->reconnect()
         else
             return $db->connect();
+        }
     }
 }
\ No newline at end of file

module/Auth/lang/en.php

Indentation +6 added lines, -6 removed lines

@@ -3,12 +3,12 @@
 return [
     "Register form" => "Register form",
     "User registering" => "User registering",
-	"Username" => "Username",
-	"username" => "username",
-	"Email" => "Email",
-	"email" => "email",
-	"Password" => "Password",
-	"password" => "password",
+    "Username" => "Username",
+    "username" => "username",
+    "Email" => "Email",
+    "email" => "email",
+    "Password" => "Password",
+    "password" => "password",
     "Repeat your password" => "Repeat your password",
     "Register now" => "Register now",
     "Log in" => "Log in",

module/Auth/config/module.config.php

Indentation +5 added lines, -5 removed lines

@@ -3,11 +3,11 @@
 return [
     'router' => [
         'routes' => [
-        	'Auth' => [
-        		'module' => 'Auth',
-        		'controller' => 'LogIn',
-        		'view' => 'index'
-        	]
+            'Auth' => [
+                'module' => 'Auth',
+                'controller' => 'LogIn',
+                'view' => 'index'
+            ]
         ],
     ],
     'view_manager' => [

module/Utils/source/Model/Entity.php

Indentation +1 added lines, -1 removed lines

@@ -6,5 +6,5 @@
 
 class Entity extends DbEntity
 {
-	// general table gateway
+    // general table gateway
 }
\ No newline at end of file

module/Utils/Module.php

Indentation +4 added lines, -4 removed lines

@@ -7,8 +7,8 @@
 
 class Module extends AbstractionModule
 {
-	public function init(AbstractionController $c)
-	{
-		// init procedures
-	}
+    public function init(AbstractionController $c)
+    {
+        // init procedures
+    }
 }
\ No newline at end of file

module/Utils/config/module.config.php

Indentation +5 added lines, -5 removed lines

@@ -3,11 +3,11 @@
 return [
     'router' => [
         'routes' => [
-        	'Utils' => [
-        		'module' => 'Utils',
-        		'controller' => '',
-        		'view' => ''
-        	]
+            'Utils' => [
+                'module' => 'Utils',
+                'controller' => '',
+                'view' => ''
+            ]
         ],
     ],
     'view_manager' => [

module/Connections/source/Controller/Tools.php

Indentation +2 added lines, -2 removed lines

@@ -481,7 +481,7 @@ 
                     $sql_text = strstr($sql_text, ';', true);
             }
 
-             # clean comments and other characters
+                # clean comments and other characters
 
             // (/**/)
             $clean_code = preg_replace('/(\s)*\/\*([^*]|[\r\n]|(\*+([^*\/]|[\r\n])))*\*+\//', '', $sql_text);
@@ -923,7 +923,7 @@ 
                     $sql_text = strstr($sql_text, ';', true);
             }
 
-             # clean comments and other characters
+                # clean comments and other characters
 
             // (/**/)
             $clean_code = preg_replace('/(\s)*\/\*([^*]|[\r\n]|(\*+([^*\/]|[\r\n])))*\*+\//', '', $sql_text);

Braces +117 added lines, -98 removed lines

@@ -96,8 +96,9 @@ 
      */
     private function getUsersEntity()
     {
-        if (!is_null($this->usersEntity))
-            return $this->usersEntity;
+        if (!is_null($this->usersEntity)) {
+                    return $this->usersEntity;
+        }
 
         $this->usersEntity = new EntityAdapter(new TableGateway(new UserModel()));
 
@@ -109,8 +110,9 @@ 
      */
     private function getIdentifiersEntity()
     {
-        if (!is_null($this->identifiersEntity))
-            return $this->identifiersEntity;
+        if (!is_null($this->identifiersEntity)) {
+                    return $this->identifiersEntity;
+        }
 
         $this->identifiersEntity = new EntityAdapter(new TableGateway(new Identifiers()));
 
@@ -122,8 +124,9 @@ 
      */
     private function getConnectionTypesEntity()
     {
-        if (!is_null($this->connectionTypesEntity))
-            return $this->connectionTypesEntity;
+        if (!is_null($this->connectionTypesEntity)) {
+                    return $this->connectionTypesEntity;
+        }
 
         $this->connectionTypesEntity = new EntityAdapter(new TableGateway(new ConnectionType()));
 
@@ -135,8 +138,9 @@ 
      */
     private function getConnectionFieldsEntity()
     {
-        if (!is_null($this->connectionFieldsEntity))
-            return $this->connectionFieldsEntity;
+        if (!is_null($this->connectionFieldsEntity)) {
+                    return $this->connectionFieldsEntity;
+        }
 
         $this->connectionFieldsEntity = new EntityAdapter(new TableGateway(new ConnectionTypeField()));
 
@@ -148,8 +152,9 @@ 
      */
     private function getUserConnectionEntity()
     {
-        if (!is_null($this->userConnectionEntity))
-            return $this->userConnectionEntity;
+        if (!is_null($this->userConnectionEntity)) {
+                    return $this->userConnectionEntity;
+        }
 
         $this->userConnectionEntity = new EntityAdapter(new UserConnectionsTable(new UserConnection()));
 
@@ -161,8 +166,9 @@ 
      */
     private function getUserConnectionDetailsEntity()
     {
-        if (!is_null($this->userConnectionDetailsEntity))
-            return $this->userConnectionDetailsEntity;
+        if (!is_null($this->userConnectionDetailsEntity)) {
+                    return $this->userConnectionDetailsEntity;
+        }
 
         $this->userConnectionDetailsEntity = new EntityAdapter(new TableGateway(new UserConnectionDetails()));
 
@@ -226,12 +232,12 @@ 
                 {
                     foreach ($idenfiers as $identifier)
                     {
-                        if ($field->CONN_IDENTI_ID == $identifier->CONN_IDENTI_ID)
-                            $dbconfig[$identifier->CONN_IDENTI_NAME] = $field->FIELD_VALUE;
+                        if ($field->CONN_IDENTI_ID == $identifier->CONN_IDENTI_ID) {
+                                                    $dbconfig[$identifier->CONN_IDENTI_NAME] = $field->FIELD_VALUE;
+                        }
                     }
                 }
-            }
-            else
+            } else
             {
                 # STANDARD VALIDATIONS [check needed arguments]
                 $needles = ['type', 'aliasname'];
@@ -287,8 +293,9 @@ 
                 {
                     foreach ($idenfiers as $identifier)
                     {
-                        if ($field_number == $identifier->CONN_IDENTI_ID)
-                            $dbconfig[$identifier->CONN_IDENTI_NAME] = $field_value;
+                        if ($field_number == $identifier->CONN_IDENTI_ID) {
+                                                    $dbconfig[$identifier->CONN_IDENTI_NAME] = $field_value;
+                        }
                     }
                 }
             }
@@ -300,8 +307,7 @@ 
 
                 $driverAdapter = new \Drone\Db\Driver\DriverAdapter($dbconfig, false);
                 $driverAdapter->getDb()->connect();
-            }
-            catch (\Exception $e)
+            } catch (\Exception $e)
             {
                 # SUCCESS-MESSAGE
                 $data["process"] = "error";
@@ -312,14 +318,12 @@ 
 
             # SUCCESS-MESSAGE
             $data["process"] = "success";
-        }
-        catch (\Drone\Exception\Exception $e)
+        } catch (\Drone\Exception\Exception $e)
         {
             # ERROR-MESSAGE
             $data["process"] = "warning";
             $data["message"] = $e->getMessage();
-        }
-        catch (\Exception $e)
+        } catch (\Exception $e)
         {
             $file = str_replace('\\', '', __CLASS__);
             $storage = new \Drone\Exception\Storage("cache/$file.json");
@@ -427,13 +431,15 @@ 
                 "USER_CONN_ID" => $id
             ]);
 
-            if (!count($connection))
-                throw new \Exception("The Connection does not exists");
+            if (!count($connection)) {
+                            throw new \Exception("The Connection does not exists");
+            }
 
             $connection = array_shift($connection);
 
-            if ($connection->STATE == 'I')
-                throw new \Drone\Exception\Exception("This connection was deleted", 300);
+            if ($connection->STATE == 'I') {
+                            throw new \Drone\Exception\Exception("This connection was deleted", 300);
+            }
 
             $details = $this->getUserConnectionDetailsEntity()->select([
                 "USER_CONN_ID" => $id
@@ -447,16 +453,18 @@ 
             {
                 foreach ($idenfiers as $identifier)
                 {
-                    if ($field->CONN_IDENTI_ID == $identifier->CONN_IDENTI_ID)
-                        $dbconfig[$identifier->CONN_IDENTI_NAME] = $field->FIELD_VALUE;
+                    if ($field->CONN_IDENTI_ID == $identifier->CONN_IDENTI_ID) {
+                                            $dbconfig[$identifier->CONN_IDENTI_NAME] = $field->FIELD_VALUE;
+                    }
                 }
             }
 
             /* identifies if sql is base64 encoded */
             if (array_key_exists('base64', $post))
             {
-                if ((bool) $post["base64"])
-                    $post["sql"] = base64_decode($post["sql"]);
+                if ((bool) $post["base64"]) {
+                                    $post["sql"] = base64_decode($post["sql"]);
+                }
             }
 
             $data["sql"] = base64_encode($post["sql"]);
@@ -468,8 +476,9 @@ 
              */
             $sql_text = trim($sql_text);
 
-            if (empty($sql_text))
-                throw new \Drone\Exception\Exception("Empty statement");
+            if (empty($sql_text)) {
+                            throw new \Drone\Exception\Exception("Empty statement");
+            }
 
             $pos = strpos($sql_text, ';');
 
@@ -477,8 +486,9 @@ 
             {
                 $end_stament = strstr($sql_text, ';');
 
-                if ($end_stament == ';')
-                    $sql_text = strstr($sql_text, ';', true);
+                if ($end_stament == ';') {
+                                    $sql_text = strstr($sql_text, ';', true);
+                }
             }
 
              # clean comments and other characters
@@ -556,10 +566,11 @@ 
                     case 'mysqli':
 
                         # show statement cannot be a subquery
-                        if (!$isShowStm)
-                            $sql_text = "SELECT (@ROW_NUM:=@ROW_NUM + 1) AS ROW_NUM, V.* FROM (
+                        if (!$isShowStm) {
+                                                    $sql_text = "SELECT (@ROW_NUM:=@ROW_NUM + 1) AS ROW_NUM, V.* FROM (
                                             " . $sql_text . "
                                         ) V LIMIT $row_start, $step";
+                        }
                         break;
 
                     case 'oci8':
@@ -636,8 +647,7 @@ 
 
                 # redirect view
                 $this->setMethod('error');
-            }
-            catch (\Exception $e)
+            } catch (\Exception $e)
             {
                 # SUCCESS-MESSAGE
                 $data["process"] = "error";
@@ -689,8 +699,9 @@ 
 
                     foreach ($row as $column => $value)
                     {
-                        if ($isShowStm)
-                            $column++;
+                        if ($isShowStm) {
+                                                    $column++;
+                        }
 
                         if (gettype($value) == 'object')
                         {
@@ -703,11 +714,10 @@ 
                                 }
 
                                 $data["data"][$key][$column] = $val;
+                            } else {
+                                                            $data["data"][$key][$column] = $value;
                             }
-                            else
-                                $data["data"][$key][$column] = $value;
-                        }
-                        else {
+                        } else {
                             $data["data"][$key][$column] = $value;
                         }
                     }
@@ -718,24 +728,24 @@ 
                 {
                     $data["column_errors"] = $column_errors;
 
-                    if ($row_start > 1)
-                        $this->setMethod('nextResults');
+                    if ($row_start > 1) {
+                                            $this->setMethod('nextResults');
+                    }
                 }
 
-                if (array_key_exists('id', $post))
-                    $data["id"] = $post["id"];
+                if (array_key_exists('id', $post)) {
+                                    $data["id"] = $post["id"];
+                }
 
                 # SUCCESS-MESSAGE
                 $data["process"] = "success";
             }
-        }
-        catch (\Drone\Exception\Exception $e)
+        } catch (\Drone\Exception\Exception $e)
         {
             # ERROR-MESSAGE
             $data["process"] = "warning";
             $data["message"] = $e->getMessage();
-        }
-        catch (\Exception $e)
+        } catch (\Exception $e)
         {
             $file = str_replace('\\', '', __CLASS__);
             $storage = new \Drone\Exception\Storage("cache/$file.json");
@@ -869,13 +879,15 @@ 
                 "USER_CONN_ID" => $id
             ]);
 
-            if (!count($connection))
-                throw new \Exception("The Connection does not exists");
+            if (!count($connection)) {
+                            throw new \Exception("The Connection does not exists");
+            }
 
             $connection = array_shift($connection);
 
-            if ($connection->STATE == 'I')
-                throw new \Drone\Exception\Exception("This connection was deleted", 300);
+            if ($connection->STATE == 'I') {
+                            throw new \Drone\Exception\Exception("This connection was deleted", 300);
+            }
 
             $details = $this->getUserConnectionDetailsEntity()->select([
                 "USER_CONN_ID" => $id
@@ -889,16 +901,18 @@ 
             {
                 foreach ($idenfiers as $identifier)
                 {
-                    if ($field->CONN_IDENTI_ID == $identifier->CONN_IDENTI_ID)
-                        $dbconfig[$identifier->CONN_IDENTI_NAME] = $field->FIELD_VALUE;
+                    if ($field->CONN_IDENTI_ID == $identifier->CONN_IDENTI_ID) {
+                                            $dbconfig[$identifier->CONN_IDENTI_NAME] = $field->FIELD_VALUE;
+                    }
                 }
             }
 
             /* identifies if sql is base64 encoded */
             if (array_key_exists('base64', $post))
             {
-                if ((bool) $post["base64"])
-                    $post["sql"] = base64_decode($post["sql"]);
+                if ((bool) $post["base64"]) {
+                                    $post["sql"] = base64_decode($post["sql"]);
+                }
             }
 
             $data["sql"] = base64_encode($post["sql"]);
@@ -910,8 +924,9 @@ 
              */
             $sql_text = trim($sql_text);
 
-            if (empty($sql_text))
-                throw new \Drone\Exception\Exception("Empty statement");
+            if (empty($sql_text)) {
+                            throw new \Drone\Exception\Exception("Empty statement");
+            }
 
             $pos = strpos($sql_text, ';');
 
@@ -919,8 +934,9 @@ 
             {
                 $end_stament = strstr($sql_text, ';');
 
-                if ($end_stament == ';')
-                    $sql_text = strstr($sql_text, ';', true);
+                if ($end_stament == ';') {
+                                    $sql_text = strstr($sql_text, ';', true);
+                }
             }
 
              # clean comments and other characters
@@ -941,8 +957,9 @@ 
             $isShowStm   = $data["showStm"]   = (preg_match('/^SHOW/i', $clean_code));
 
             # detect selection
-            if (!$isSelectStm && !$isShowStm)
-                throw new \Exception("You can't export a non-selection statement!");
+            if (!$isSelectStm && !$isShowStm) {
+                            throw new \Exception("You can't export a non-selection statement!");
+            }
 
             try {
 
@@ -988,8 +1005,7 @@ 
 
                 # redirect view
                 $this->setMethod('error');
-            }
-            catch (\Exception $e)
+            } catch (\Exception $e)
             {
                 # SUCCESS-MESSAGE
                 $data["process"] = "error";
@@ -1060,8 +1076,9 @@ 
 
                         foreach ($rows[0] as $column_name => $row)
                         {
-                            if (!is_numeric($column_name))
-                                $column_names[] = $column_name;
+                            if (!is_numeric($column_name)) {
+                                                            $column_names[] = $column_name;
+                            }
                         }
 
                         $table .= "\t<thead>\r\n\t\t<tr>\r\n";
@@ -1080,8 +1097,9 @@ 
 
                             foreach ($row as $column => $value)
                             {
-                                if ($isShowStm)
-                                    $column++;
+                                if ($isShowStm) {
+                                                                    $column++;
+                                }
 
                                 if (gettype($value) == 'object')
                                 {
@@ -1094,11 +1112,10 @@ 
                                         }
 
                                         $data["data"][$key][$column] = $val;
+                                    } else {
+                                                                            $data["data"][$key][$column] = $value;
                                     }
-                                    else
-                                        $data["data"][$key][$column] = $value;
-                                }
-                                else {
+                                } else {
                                     $data["data"][$key][$column] = $value;
                                 }
                             }
@@ -1130,8 +1147,9 @@ 
 
                         foreach ($rows[0] as $column_name => $row)
                         {
-                            if (!is_numeric($column_name))
-                                $column_names[] = $column_name;
+                            if (!is_numeric($column_name)) {
+                                                            $column_names[] = $column_name;
+                            }
                         }
 
                         foreach ($column_names as $column_name)
@@ -1148,8 +1166,9 @@ 
 
                             foreach ($row as $column => $value)
                             {
-                                if ($isShowStm)
-                                    $column++;
+                                if ($isShowStm) {
+                                                                    $column++;
+                                }
 
                                 if (gettype($value) == 'object')
                                 {
@@ -1162,11 +1181,10 @@ 
                                         }
 
                                         $data["data"][$key][$column] = $val;
+                                    } else {
+                                                                            $data["data"][$key][$column] = $value;
                                     }
-                                    else
-                                        $data["data"][$key][$column] = $value;
-                                }
-                                else {
+                                } else {
                                     $data["data"][$key][$column] = $value;
                                 }
                             }
@@ -1203,20 +1221,19 @@ 
 
                 $data["filename"] = $filename;
 
-                if (array_key_exists('id', $post))
-                    $data["id"] = $post["id"];
+                if (array_key_exists('id', $post)) {
+                                    $data["id"] = $post["id"];
+                }
 
                 # SUCCESS-MESSAGE
                 $data["process"] = "success";
             }
-        }
-        catch (\Drone\Exception\Exception $e)
+        } catch (\Drone\Exception\Exception $e)
         {
             # ERROR-MESSAGE
             $data["process"] = "warning";
             $data["message"] = $e->getMessage();
-        }
-        catch (\Exception $e)
+        } catch (\Exception $e)
         {
             $file = str_replace('\\', '', __CLASS__);
             $storage = new \Drone\Exception\Storage("cache/$file.json");
@@ -1231,8 +1248,9 @@ 
             }
 
             # errors retrived by the use of ErrorTrait
-            if (count($this->getErrors()))
-                $this->handleErrors($this->getErrors(), __METHOD__);
+            if (count($this->getErrors())) {
+                            $this->handleErrors($this->getErrors(), __METHOD__);
+            }
 
             $data["code"]    = $errorCode;
             $data["message"] = $e->getMessage();
@@ -1268,15 +1286,16 @@ 
             if (!$hd || !@fwrite($hd, $errorInformation))
             {
                 # error storing are not mandatory!
+            } else {
+                            @fclose($hd);
             }
-            else
-                @fclose($hd);
 
             $config = include 'config/application.config.php';
             $dev = $config["environment"]["dev_mode"];
 
-            if ($dev)
-                echo $errorInformation;
+            if ($dev) {
+                            echo $errorInformation;
+            }
         }
     }
 }
\ No newline at end of file

module/Connections/source/Model/Authentication.php

Indentation +18 added lines, -18 removed lines

@@ -12,24 +12,24 @@
 
         foreach ($dbconfig as $key => $value)
         {
-        	switch ($key)
-        	{
-        		case 'dbhost':
-        			$db->setDbhost($value);
-        			break;
-        		case 'dbuser':
-        			$db->setDbuser($value);
-        			break;
-        		case 'dbpass':
-        			$db->setDbpass($value);
-        			break;
-        		case 'dbname':
-        			$db->setDbname($value);
-        			break;
-        		case 'dbchar':
-        			$db->setDbChar($value);
-        			break;
-        	}
+            switch ($key)
+            {
+                case 'dbhost':
+                    $db->setDbhost($value);
+                    break;
+                case 'dbuser':
+                    $db->setDbuser($value);
+                    break;
+                case 'dbpass':
+                    $db->setDbpass($value);
+                    break;
+                case 'dbname':
+                    $db->setDbname($value);
+                    break;
+                case 'dbchar':
+                    $db->setDbChar($value);
+                    break;
+            }
         }
 
         return $db->reconnect();