Pleets / SQLWebManager

module/Connections/source/Controller/Tools.php

Braces +114 added lines, -96 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,8 +901,9 @@ 
             {
                 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;
+                    }
                 }
             }
 
@@ -905,8 +918,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, ';');
 
@@ -914,8 +928,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
@@ -936,8 +951,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 {
 
@@ -983,8 +999,7 @@ 
 
                 # redirect view
                 $this->setMethod('error');
-            }
-            catch (\Exception $e)
+            } catch (\Exception $e)
             {
                 # SUCCESS-MESSAGE
                 $data["process"] = "error";
@@ -1055,8 +1070,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";
@@ -1075,8 +1091,9 @@ 
 
                             foreach ($row as $column => $value)
                             {
-                                if ($isShowStm)
-                                    $column++;
+                                if ($isShowStm) {
+                                                                    $column++;
+                                }
 
                                 if (gettype($value) == 'object')
                                 {
@@ -1089,11 +1106,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;
                                 }
                             }
@@ -1125,8 +1141,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)
@@ -1143,8 +1160,9 @@ 
 
                             foreach ($row as $column => $value)
                             {
-                                if ($isShowStm)
-                                    $column++;
+                                if ($isShowStm) {
+                                                                    $column++;
+                                }
 
                                 if (gettype($value) == 'object')
                                 {
@@ -1157,11 +1175,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;
                                 }
                             }
@@ -1198,20 +1215,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");
@@ -1226,8 +1242,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();
@@ -1263,15 +1280,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