Pleets / SQLWebManager

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();

module/Connections/config/module.config.php

Indentation +5 added lines, -5 removed lines

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

module/Catcher/source/Controller/Index.php

Spacing +1 added lines, -1 removed lines

@@ -81,7 +81,7 @@
         {
             $new = array();
 
-            foreach($obj as $key => $val)
+            foreach ($obj as $key => $val)
             {
                 $new[$key] = $this->object_to_array($val);
             }

Braces +8 added lines, -6 removed lines

@@ -26,8 +26,9 @@ 
 
             foreach ($files as $file)
             {
-                if (!in_array($file, ['.', '..']))
-                    $_files[] = $file;
+                if (!in_array($file, ['.', '..'])) {
+                                    $_files[] = $file;
+                }
             }
 
             $_folders[$folder] = $_files;
@@ -74,8 +75,9 @@ 
 
     private function object_to_array($obj)
     {
-        if (is_object($obj))
-            $obj = (array) $obj;
+        if (is_object($obj)) {
+                    $obj = (array) $obj;
+        }
 
         if (is_array($obj))
         {
@@ -85,9 +87,9 @@ 
             {
                 $new[$key] = $this->object_to_array($val);
             }
+        } else {
+                    $new = $obj;
         }
-        else
-            $new = $obj;
 
         return $new;
     }

module/Workarea/source/Controller/Connections.php

Spacing +17 added lines, -17 removed lines

@@ -156,7 +156,7 @@ 
         $data = array();
 
         # environment settings
-        $this->setTerminal(true);           # set terminal
+        $this->setTerminal(true); # set terminal
 
         # TRY-CATCH-BLOCK
         try {
@@ -167,7 +167,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) . ')!!');
             }
 
             $data["connections"] = $this->getUserConnectionEntity()->select([
@@ -227,8 +227,8 @@ 
         $data = array();
 
         # 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 {
@@ -239,7 +239,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]
@@ -251,7 +251,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) . ')!!');
                 }
             });
 
@@ -359,8 +359,8 @@ 
         $data = array();
 
         # 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 {
@@ -399,7 +399,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) . ')!!');
                     }
                 });
 
@@ -492,7 +492,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) . ')!!');
             }
         }
         catch (\Drone\Exception\Exception $e)
@@ -544,9 +544,9 @@ 
         $data = array();
 
         # environment settings
-        $post = $this->getPost();           # catch $_POST
-        $get = $_GET;                       # catch $_GET
-        $this->setTerminal(true);           # set terminal
+        $post = $this->getPost(); # catch $_POST
+        $get = $_GET; # catch $_GET
+        $this->setTerminal(true); # set terminal
 
         # TRY-CATCH-BLOCK
         try {
@@ -562,7 +562,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) . ')!!');
                     }
                 });
 
@@ -624,7 +624,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) . ')!!');
                     }
                 });
 
@@ -729,7 +729,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) . ')!!');
             }
         }
         catch (\Drone\Exception\Exception $e)
@@ -776,7 +776,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 +50 added lines, -50 removed lines

@@ -85,8 +85,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()));
 
@@ -98,8 +99,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()));
 
@@ -111,8 +113,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()));
 
@@ -124,8 +127,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()));
 
@@ -137,8 +141,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()));
 
@@ -177,14 +182,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");
@@ -289,13 +292,15 @@ 
                 "USER_CONN_ID" => $post["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);
+            }
 
             $connection->exchangeArray([
                 "STATE" =>  'I'
@@ -309,14 +314,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");
@@ -387,8 +390,7 @@ 
 
                 # SUCCESS-MESSAGE
                 $data["process"] = "register-form";
-            }
-            else if ($this->isPost())
+            } else if ($this->isPost())
             {
                 # STANDARD VALIDATIONS [check needed arguments]
                 $needles = ['field', 'type', 'aliasname'];
@@ -486,22 +488,19 @@ 
 
                 # SUCCESS-MESSAGE
                 $data["process"] = "process-response";
-            }
-            else
+            } else
             {
                 $http = new Http();
                 $http->writeStatus($http::HTTP_METHOD_NOT_ALLOWED);
 
                 die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED .' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
             }
-        }
-        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");
@@ -588,13 +587,15 @@ 
                     "USER_CONN_ID" => $get["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);
+                }
 
                 $connection_details = $this->getUserConnectionDetailsEntity()->select([
                     "USER_CONN_ID" => $get["id"]
@@ -612,8 +613,7 @@ 
 
                 # SUCCESS-MESSAGE
                 $data["process"] = "update-form";
-            }
-            else if ($this->isPost())
+            } else if ($this->isPost())
             {
                 # STANDARD VALIDATIONS [check needed arguments]
                 $needles = ['_conn_id', 'type', 'aliasname'];
@@ -685,13 +685,15 @@ 
                     "USER_CONN_ID"    => $post["_conn_id"],
                 ]);
 
-                if (!count($userConnection))
-                    throw new \Exception("The Connection does not exists");
+                if (!count($userConnection)) {
+                                    throw new \Exception("The Connection does not exists");
+                }
 
                 $userConnection = array_shift($userConnection);
 
-                if ($userConnection->STATE == 'I')
-                    throw new \Drone\Exception\Exception("This connection was deleted", 300);
+                if ($userConnection->STATE == 'I') {
+                                    throw new \Drone\Exception\Exception("This connection was deleted", 300);
+                }
 
                 $userConnection->exchangeArray([
                     "CONN_TYPE_ID"    => $post["type"],
@@ -723,22 +725,19 @@ 
 
                 # SUCCESS-MESSAGE
                 $data["process"] = "process-response";
-            }
-            else
+            } else
             {
                 $http = new Http();
                 $http->writeStatus($http::HTTP_METHOD_NOT_ALLOWED);
 
                 die('Error ' . $http::HTTP_METHOD_NOT_ALLOWED .' (' . $http->getStatusText($http::HTTP_METHOD_NOT_ALLOWED) . ')!!');
             }
-        }
-        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");
@@ -786,15 +785,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/Workarea/source/Model/Identifiers.php

Indentation +9 added lines, -9 removed lines

@@ -6,19 +6,19 @@
 
 class Identifiers extends Entity
 {
-	/**
-	* @var integer
-	*/
-	public $CONN_IDENTI_ID;
+    /**
+     * @var integer
+     */
+    public $CONN_IDENTI_ID;
 
-	/**
-	* @var string
-	*/
-	public $CONN_IDENTI_NAME;
+    /**
+     * @var string
+     */
+    public $CONN_IDENTI_NAME;
 
     public function __construct($data = [])
     {
-    	parent::__construct($data);
+        parent::__construct($data);
         $this->setTableName("SWM_CONN_IDENTIFIERS");
     }
 }
\ No newline at end of file

module/Workarea/source/Model/ConnectionType.php

Indentation +9 added lines, -9 removed lines

@@ -6,19 +6,19 @@
 
 class ConnectionType extends Entity
 {
-	/**
-	* @var integer
-	*/
-	public $CONN_TYPE_ID;
+    /**
+     * @var integer
+     */
+    public $CONN_TYPE_ID;
 
-	/**
-	* @var string
-	*/
-	public $CONN_TYPE_NAME;
+    /**
+     * @var string
+     */
+    public $CONN_TYPE_NAME;
 
     public function __construct($data = [])
     {
-    	parent::__construct($data);
+        parent::__construct($data);
         $this->setTableName("SWM_CONNECTION_TYPES");
     }
 }
\ No newline at end of file

module/Workarea/source/Model/ConnectionTypeField.php

Indentation +17 added lines, -17 removed lines

@@ -6,29 +6,29 @@
 
 class ConnectionTypeField extends Entity
 {
-	/**
-	* @var integer
-	*/
-	public $CONN_TYPE_ID;
+    /**
+     * @var integer
+     */
+    public $CONN_TYPE_ID;
 
-	/**
-	* @var integer
-	*/
-	public $CONN_IDENTI_ID;
+    /**
+     * @var integer
+     */
+    public $CONN_IDENTI_ID;
 
-	/**
-	* @var string
-	*/
-	public $FIELD_NAME;
+    /**
+     * @var string
+     */
+    public $FIELD_NAME;
 
-	/**
-	* @var string
-	*/
-	public $PLACEHOLDER;
+    /**
+     * @var string
+     */
+    public $PLACEHOLDER;
 
     public function __construct($data = [])
     {
-    	parent::__construct($data);
+        parent::__construct($data);
         $this->setTableName("SWM_CONN_TYPE_FIELDS");
     }
 }
\ No newline at end of file

module/Workarea/source/Model/UserConnectionDetails.php

Indentation +13 added lines, -13 removed lines

@@ -6,24 +6,24 @@
 
 class UserConnectionDetails extends Entity
 {
-	/**
-	* @var integer
-	*/
-	public $USER_CONN_ID;
+    /**
+     * @var integer
+     */
+    public $USER_CONN_ID;
 
-	/**
-	* @var integer
-	*/
-	public $CONN_IDENTI_ID;
+    /**
+     * @var integer
+     */
+    public $CONN_IDENTI_ID;
 
-	/**
-	* @var string
-	*/
-	public $FIELD_VALUE;
+    /**
+     * @var string
+     */
+    public $FIELD_VALUE;
 
     public function __construct($data = [])
     {
-    	parent::__construct($data);
+        parent::__construct($data);
         $this->setTableName("SWM_USER_CONN_DETAILS");
     }
 }
\ No newline at end of file

module/Workarea/source/Model/UserConnection.php

Indentation +30 added lines, -30 removed lines

@@ -6,39 +6,39 @@
 
 class UserConnection extends Entity
 {
-	/**
-	* @var integer
-	*/
-	public $USER_CONN_ID;
-
-	/**
-	* @var integer
-	*/
-	public $USER_ID;
-
-	/**
-	* @var integer
-	*/
-	public $CONN_TYPE_ID;
-
-	/**
-	* @var string
-	*/
-	public $CONNECTION_NAME;
-
-	/**
-	* @var string
-	*/
-	public $STATE;
-
-	/**
-	* @var date
-	*/
-	public $RECORD_DATE;
+    /**
+     * @var integer
+     */
+    public $USER_CONN_ID;
+
+    /**
+     * @var integer
+     */
+    public $USER_ID;
+
+    /**
+     * @var integer
+     */
+    public $CONN_TYPE_ID;
+
+    /**
+     * @var string
+     */
+    public $CONNECTION_NAME;
+
+    /**
+     * @var string
+     */
+    public $STATE;
+
+    /**
+     * @var date
+     */
+    public $RECORD_DATE;
 
     public function __construct($data = [])
     {
-    	parent::__construct($data);
+        parent::__construct($data);
         $this->setTableName("SWM_USER_CONNECTIONS");
     }
 }
\ No newline at end of file