Pleets / SQLWebManager

module/Connections/source/Controller/Tools.php

Spacing +25 added lines, -25 removed lines

@@ -183,8 +183,8 @@ 
         $data = [];
 
         # environment settings
-        $post = $this->getPost();           # catch $_POST
-        $this->setTerminal(true);           # set terminal
+        $post = $this->getPost(); # catch $_POST
+        $this->setTerminal(true); # set terminal
 
         # TRY-CATCH-BLOCK
         try {
@@ -195,7 +195,7 @@ 
                 $http = new Http();
                 $http->writeStatus($http::HTTP_METHOD_NOT_ALLOWED);
 
-                die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED .' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
+                die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED . ' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
             }
 
             $idenfiers = $this->getIdentifiersEntity()->select([]);
@@ -212,7 +212,7 @@ 
                         $http = new Http();
                         $http->writeStatus($http::HTTP_BAD_REQUEST);
 
-                        die('Error ' . $http::HTTP_BAD_REQUEST .' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
+                        die('Error ' . $http::HTTP_BAD_REQUEST . ' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
                     }
                 });
 
@@ -242,7 +242,7 @@ 
                         $http = new Http();
                         $http->writeStatus($http::HTTP_BAD_REQUEST);
 
-                        die('Error ' . $http::HTTP_BAD_REQUEST .' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
+                        die('Error ' . $http::HTTP_BAD_REQUEST . ' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
                     }
                 });
 
@@ -361,14 +361,14 @@ 
             $http = new Http();
             $http->writeStatus($http::HTTP_METHOD_NOT_ALLOWED);
 
-            die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED .' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
+            die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED . ' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
         }
 
         # data to send
         $data = [];
 
-        $this->setTerminal(true);           # set terminal
-        $post = $this->getPost();           # catch $_POST
+        $this->setTerminal(true); # set terminal
+        $post = $this->getPost(); # catch $_POST
 
         $data["id"]   = $post["id"];
         $data["conn"] = $post["conn"];
@@ -390,8 +390,8 @@ 
         $data = [];
 
         # environment settings
-        $post = $this->getPost();           # catch $_POST
-        $this->setTerminal(true);           # set terminal
+        $post = $this->getPost(); # catch $_POST
+        $this->setTerminal(true); # set terminal
 
         # TRY-CATCH-BLOCK
         try {
@@ -402,7 +402,7 @@ 
                 $http = new Http();
                 $http->writeStatus($http::HTTP_METHOD_NOT_ALLOWED);
 
-                die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED .' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
+                die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED . ' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
             }
 
             # STANDARD VALIDATIONS [check needed arguments]
@@ -414,7 +414,7 @@ 
                     $http = new Http();
                     $http->writeStatus($http::HTTP_BAD_REQUEST);
 
-                    die('Error ' . $http::HTTP_BAD_REQUEST .' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
+                    die('Error ' . $http::HTTP_BAD_REQUEST . ' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
                 }
             });
 
@@ -544,7 +544,7 @@ 
                         $http = new Http();
                         $http->writeStatus($http::HTTP_BAD_REQUEST);
 
-                        die('Error ' . $http::HTTP_BAD_REQUEST .' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
+                        die('Error ' . $http::HTTP_BAD_REQUEST . ' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
                     }
 
                     $row_start = $post["row_start"] + $step;
@@ -697,11 +697,11 @@ 
 
                             if (gettype($value) == 'object')
                             {
-                                if  (get_class($value) == 'OCI-Lob')
+                                if (get_class($value) == 'OCI-Lob')
                                 {
                                     if (($val = @$value->load()) === false)
                                     {
-                                        $val = null;   # only for default, this value is not used
+                                        $val = null; # only for default, this value is not used
                                         $column_errors[] = $column;
                                     }
 
@@ -778,8 +778,8 @@ 
         $data = [];
 
         # environment settings
-        $post = $this->getPost();           # catch $_POST
-        $this->setTerminal(true);           # set terminal
+        $post = $this->getPost(); # catch $_POST
+        $this->setTerminal(true); # set terminal
 
         # TRY-CATCH-BLOCK
         try {
@@ -790,7 +790,7 @@ 
                 $http = new Http();
                 $http->writeStatus($http::HTTP_METHOD_NOT_ALLOWED);
 
-                die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED .' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
+                die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED . ' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
             }
 
             # STANDARD VALIDATIONS [check needed arguments]
@@ -802,7 +802,7 @@ 
                     $http = new Http();
                     $http->writeStatus($http::HTTP_BAD_REQUEST);
 
-                    die('Error ' . $http::HTTP_BAD_REQUEST .' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
+                    die('Error ' . $http::HTTP_BAD_REQUEST . ' (' . $http->getStatusText($http::HTTP_BAD_REQUEST) . ')!!');
                 }
             });
 
@@ -1085,11 +1085,11 @@ 
 
                                 if (gettype($value) == 'object')
                                 {
-                                    if  (get_class($value) == 'OCI-Lob')
+                                    if (get_class($value) == 'OCI-Lob')
                                     {
                                         if (($val = @$value->load()) === false)
                                         {
-                                            $val = null;   # only for default, this value is not used
+                                            $val = null; # only for default, this value is not used
                                             $column_errors[] = $column;
                                         }
 
@@ -1111,7 +1111,7 @@ 
 
                             foreach ($column_names as $column_name)
                             {
-                                $table .= "\t\t\t<td>". $row[$column_name] ."</td>\r\n";
+                                $table .= "\t\t\t<td>" . $row[$column_name] . "</td>\r\n";
                             }
 
                             $table .= "\t\t</tr>\r\n";
@@ -1153,11 +1153,11 @@ 
 
                                 if (gettype($value) == 'object')
                                 {
-                                    if  (get_class($value) == 'OCI-Lob')
+                                    if (get_class($value) == 'OCI-Lob')
                                     {
                                         if (($val = @$value->load()) === false)
                                         {
-                                            $val = null;   # only for default, this value is not used
+                                            $val = null; # only for default, this value is not used
                                             $column_errors[] = $column;
                                         }
 
@@ -1258,7 +1258,7 @@ 
             foreach ($errors as $errno => $error)
             {
                 $errorInformation .=
-                    "<strong style='color: #a94442'>".
+                    "<strong style='color: #a94442'>" .
                         $method
                             . "</strong>: <span style='color: #e24f4c'>{$error}</span> \n<br />";
             }

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";
@@ -692,8 +702,9 @@ 
 
                         foreach ($row as $column => $value)
                         {
-                            if ($isShowStm)
-                                $column++;
+                            if ($isShowStm) {
+                                                            $column++;
+                            }
 
                             if (gettype($value) == 'object')
                             {
@@ -706,11 +717,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