adumitru68 / QueryBuilder

src/QueryBuild.php

Indentation +59 added lines, -59 removed lines

@@ -17,71 +17,71 @@
 class QueryBuild
 {
 
-    /**
-     * @var integer
-     */
-    private $queryType;
+	/**
+	 * @var integer
+	 */
+	private $queryType;
 
-    /**
-     * QueryBuild constructor.
-     * @param $queryType
-     */
-    protected function __construct($queryType)
-    {
-        $this->queryType = $queryType;
-    }
+	/**
+	 * QueryBuild constructor.
+	 * @param $queryType
+	 */
+	protected function __construct($queryType)
+	{
+		$this->queryType = $queryType;
+	}
 
-    /**
-     * @param $table
-     * @return QuerySelect
-     */
-    public static function select($table)
-    {
-        return new QuerySelect(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QuerySelect
+	 */
+	public static function select($table)
+	{
+		return new QuerySelect(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $table
-     * @return QueryUpdate
-     */
-    public static function update($table)
-    {
-        return new QueryUpdate(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QueryUpdate
+	 */
+	public static function update($table)
+	{
+		return new QueryUpdate(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $table
-     * @return QueryInsert
-     */
-    public static function insert($table)
-    {
-        return new QueryInsert(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QueryInsert
+	 */
+	public static function insert($table)
+	{
+		return new QueryInsert(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $table
-     * @return QueryDelete
-     */
-    public static function delete($table)
-    {
-        return new QueryDelete(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QueryDelete
+	 */
+	public static function delete($table)
+	{
+		return new QueryDelete(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $query
-     * @return QueryCustom
-     */
-    public static function query($query)
-    {
-        return new QueryCustom(new QueryBuild(1), $query);
-    }
+	/**
+	 * @param $query
+	 * @return QueryCustom
+	 */
+	public static function query($query)
+	{
+		return new QueryCustom(new QueryBuild(1), $query);
+	}
 
-    /**
-     * @return integer
-     */
-    public function getType()
-    {
-        return $this->queryType;
-    }
+	/**
+	 * @return integer
+	 */
+	public function getType()
+	{
+		return $this->queryType;
+	}
 
 }
\ No newline at end of file

Spacing +11 added lines, -11 removed lines

@@ -26,7 +26,7 @@ 
      * QueryBuild constructor.
      * @param $queryType
      */
-    protected function __construct($queryType)
+    protected function __construct( $queryType )
     {
         $this->queryType = $queryType;
     }
@@ -35,45 +35,45 @@ 
      * @param $table
      * @return QuerySelect
      */
-    public static function select($table)
+    public static function select( $table )
     {
-        return new QuerySelect(new QueryBuild(0), $table);
+        return new QuerySelect( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $table
      * @return QueryUpdate
      */
-    public static function update($table)
+    public static function update( $table )
     {
-        return new QueryUpdate(new QueryBuild(0), $table);
+        return new QueryUpdate( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $table
      * @return QueryInsert
      */
-    public static function insert($table)
+    public static function insert( $table )
     {
-        return new QueryInsert(new QueryBuild(0), $table);
+        return new QueryInsert( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $table
      * @return QueryDelete
      */
-    public static function delete($table)
+    public static function delete( $table )
     {
-        return new QueryDelete(new QueryBuild(0), $table);
+        return new QueryDelete( new QueryBuild( 0 ), $table );
     }
 
     /**
      * @param $query
      * @return QueryCustom
      */
-    public static function query($query)
+    public static function query( $query )
     {
-        return new QueryCustom(new QueryBuild(1), $query);
+        return new QueryCustom( new QueryBuild( 1 ), $query );
     }
 
     /**

src/Statements/QuerySelect.php

Indentation +174 added lines, -174 removed lines

@@ -29,179 +29,179 @@
 class QuerySelect extends QueryStatement implements QueryStatementInterface
 {
 
-    use SelectFields, Limit, Distinct, Where, Having, WhereAndHavingBuilder, Replacement, OrderBy, GroupBy, Join, DefaultPriority, HighPriority, Utilities;
-
-    /**
-     * @var string
-     */
-    protected $statement = self::QUERY_STATEMENT_SELECT;
-
-
-    /**
-     * QuerySelect constructor.
-     * @param QueryBuild $queryBuild
-     * @param string|QueryStatement $table
-     */
-    public function __construct(QueryBuild $queryBuild, $table)
-    {
-        parent::__construct($queryBuild, $table);
-
-        if (is_a($table, QuerySelect::class)) {
-
-            /**
-             * @var QuerySelect $table
-             */
-            $tableName = '( ' . $table->getSyntax() . ' )';
-            $this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
-
-            $tableSelectParams = $table->getBindParams();
-            foreach ($tableSelectParams as $key => $value)
-                $this->queryStructure->setParams($key, $value);
-
-        }
-    }
-
-    /**
-     * @return $this
-     */
-    public function first()
-    {
-        $this->queryStructure->setElement(QueryStructure::FIRST, 1);
-
-        return $this;
-    }
-
-    /**
-     * @return $this
-     */
-    public function count()
-    {
-        $this->queryStructure->setElement(QueryStructure::COUNT, 1);
-
-        return $this;
-    }
-
-    /**
-     * @param $column
-     * @return $this
-     */
-    public function column($column)
-    {
-        $column = QueryHelper::clearMultipleSpaces($column);
-        $this->queryStructure->setElement(QueryStructure::COLUMN, $column);
-
-        return $this;
-    }
-
-
-    /**
-     * @param bool|int $replacement
-     * @return mixed|string
-     */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-
-        if ($this->queryStructure->getElement(QueryStructure::COUNT)) {
-            $this->queryStructure->setElement(QueryStructure::FIELDS, 'COUNT(*)');
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
-            $this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
-        }
-
-        if ($this->queryStructure->getElement(QueryStructure::FIRST))
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
-
-        $syntax = array();
-
-        /**
-         *  Explain
-         */
-        $syntax[] = $this->getExplainSyntax();
-
-        /**
-         * SELECT statement
-         */
-        $syntax[] = $this->statement;
-
-        /**
-         * PRIORITY
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
-
-        /**
-         * DISTINCT clause
-         */
-        $syntax[] = $this->getDistinctSyntax();
-
-        /**
-         * FIELDS
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::FIELDS);
-
-        /**
-         * FROM table or queryStructure
-         */
-        $syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
-
-        /**
-         * JOIN CLAUSES
-         */
-        $syntax[] = $this->getJoinSyntax();
-
-        /**
-         * WHERE clause
-         */
-        $syntax[] = $this->getWhereSyntax();
-
-        /**
-         * GROUP BY clause
-         */
-        $syntax[] = $this->getGroupBySyntax();
-
-        /**
-         * HAVING clause
-         */
-        $syntax[] = $this->getHavingSyntax();
-
-        /**
-         * ORDER BY clause
-         */
-        $syntax[] = $this->getOrderBySyntax();
-
-        /**
-         * LIMIT clause
-         */
-        $syntax[] = $this->getLimitSyntax();
-
-        $syntax = implode(' ', $syntax);
-
-        return $this->getSyntaxReplace($syntax, $replacement);
-
-    }
-
-
-    /**
-     * @return array|int|mixed|null|string
-     */
-    public function execute()
-    {
-
-        switch (true) {
-            case $this->queryStructure->getElement(QueryStructure::COUNT):
-                return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-            case $this->queryStructure->getElement(QueryStructure::FIRST):
-                if ($this->queryStructure->getElement(QueryStructure::COLUMN))
-                    return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-
-                return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-            case $this->queryStructure->getElement(QueryStructure::COLUMN):
-                return DbService::getInstance()->column($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-            default:
-                return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-        }
-    }
+	use SelectFields, Limit, Distinct, Where, Having, WhereAndHavingBuilder, Replacement, OrderBy, GroupBy, Join, DefaultPriority, HighPriority, Utilities;
+
+	/**
+	 * @var string
+	 */
+	protected $statement = self::QUERY_STATEMENT_SELECT;
+
+
+	/**
+	 * QuerySelect constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string|QueryStatement $table
+	 */
+	public function __construct(QueryBuild $queryBuild, $table)
+	{
+		parent::__construct($queryBuild, $table);
+
+		if (is_a($table, QuerySelect::class)) {
+
+			/**
+			 * @var QuerySelect $table
+			 */
+			$tableName = '( ' . $table->getSyntax() . ' )';
+			$this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
+
+			$tableSelectParams = $table->getBindParams();
+			foreach ($tableSelectParams as $key => $value)
+				$this->queryStructure->setParams($key, $value);
+
+		}
+	}
+
+	/**
+	 * @return $this
+	 */
+	public function first()
+	{
+		$this->queryStructure->setElement(QueryStructure::FIRST, 1);
+
+		return $this;
+	}
+
+	/**
+	 * @return $this
+	 */
+	public function count()
+	{
+		$this->queryStructure->setElement(QueryStructure::COUNT, 1);
+
+		return $this;
+	}
+
+	/**
+	 * @param $column
+	 * @return $this
+	 */
+	public function column($column)
+	{
+		$column = QueryHelper::clearMultipleSpaces($column);
+		$this->queryStructure->setElement(QueryStructure::COLUMN, $column);
+
+		return $this;
+	}
+
+
+	/**
+	 * @param bool|int $replacement
+	 * @return mixed|string
+	 */
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+
+		if ($this->queryStructure->getElement(QueryStructure::COUNT)) {
+			$this->queryStructure->setElement(QueryStructure::FIELDS, 'COUNT(*)');
+			$this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+			$this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
+		}
+
+		if ($this->queryStructure->getElement(QueryStructure::FIRST))
+			$this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+
+		$syntax = array();
+
+		/**
+		 *  Explain
+		 */
+		$syntax[] = $this->getExplainSyntax();
+
+		/**
+		 * SELECT statement
+		 */
+		$syntax[] = $this->statement;
+
+		/**
+		 * PRIORITY
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+
+		/**
+		 * DISTINCT clause
+		 */
+		$syntax[] = $this->getDistinctSyntax();
+
+		/**
+		 * FIELDS
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::FIELDS);
+
+		/**
+		 * FROM table or queryStructure
+		 */
+		$syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+
+		/**
+		 * JOIN CLAUSES
+		 */
+		$syntax[] = $this->getJoinSyntax();
+
+		/**
+		 * WHERE clause
+		 */
+		$syntax[] = $this->getWhereSyntax();
+
+		/**
+		 * GROUP BY clause
+		 */
+		$syntax[] = $this->getGroupBySyntax();
+
+		/**
+		 * HAVING clause
+		 */
+		$syntax[] = $this->getHavingSyntax();
+
+		/**
+		 * ORDER BY clause
+		 */
+		$syntax[] = $this->getOrderBySyntax();
+
+		/**
+		 * LIMIT clause
+		 */
+		$syntax[] = $this->getLimitSyntax();
+
+		$syntax = implode(' ', $syntax);
+
+		return $this->getSyntaxReplace($syntax, $replacement);
+
+	}
+
+
+	/**
+	 * @return array|int|mixed|null|string
+	 */
+	public function execute()
+	{
+
+		switch (true) {
+			case $this->queryStructure->getElement(QueryStructure::COUNT):
+				return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+			case $this->queryStructure->getElement(QueryStructure::FIRST):
+				if ($this->queryStructure->getElement(QueryStructure::COLUMN))
+					return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+
+				return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+			case $this->queryStructure->getElement(QueryStructure::COLUMN):
+				return DbService::getInstance()->column($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+			default:
+				return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+		}
+	}
 
 }
\ No newline at end of file

Spacing +42 added lines, -42 removed lines

@@ -42,21 +42,21 @@ 
      * @param QueryBuild $queryBuild
      * @param string|QueryStatement $table
      */
-    public function __construct(QueryBuild $queryBuild, $table)
+    public function __construct( QueryBuild $queryBuild, $table )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
 
-        if (is_a($table, QuerySelect::class)) {
+        if ( is_a( $table, QuerySelect::class ) ) {
 
             /**
              * @var QuerySelect $table
              */
             $tableName = '( ' . $table->getSyntax() . ' )';
-            $this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
+            $this->queryStructure->setElement( QueryStructure::TABLE, $tableName );
 
             $tableSelectParams = $table->getBindParams();
-            foreach ($tableSelectParams as $key => $value)
-                $this->queryStructure->setParams($key, $value);
+            foreach ( $tableSelectParams as $key => $value )
+                $this->queryStructure->setParams( $key, $value );
 
         }
     }
@@ -66,7 +66,7 @@ 
      */
     public function first()
     {
-        $this->queryStructure->setElement(QueryStructure::FIRST, 1);
+        $this->queryStructure->setElement( QueryStructure::FIRST, 1 );
 
         return $this;
     }
@@ -76,7 +76,7 @@ 
      */
     public function count()
     {
-        $this->queryStructure->setElement(QueryStructure::COUNT, 1);
+        $this->queryStructure->setElement( QueryStructure::COUNT, 1 );
 
         return $this;
     }
@@ -85,10 +85,10 @@ 
      * @param $column
      * @return $this
      */
-    public function column($column)
+    public function column( $column )
     {
-        $column = QueryHelper::clearMultipleSpaces($column);
-        $this->queryStructure->setElement(QueryStructure::COLUMN, $column);
+        $column = QueryHelper::clearMultipleSpaces( $column );
+        $this->queryStructure->setElement( QueryStructure::COLUMN, $column );
 
         return $this;
     }
@@ -98,83 +98,83 @@ 
      * @param bool|int $replacement
      * @return mixed|string
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
 
-        if ($this->queryStructure->getElement(QueryStructure::COUNT)) {
-            $this->queryStructure->setElement(QueryStructure::FIELDS, 'COUNT(*)');
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
-            $this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
+        if ( $this->queryStructure->getElement( QueryStructure::COUNT ) ) {
+            $this->queryStructure->setElement( QueryStructure::FIELDS, 'COUNT(*)' );
+            $this->queryStructure->setElement( QueryStructure::LIMIT, 1 );
+            $this->queryStructure->setElement( QueryStructure::DISTINCT, 0 ); //???
         }
 
-        if ($this->queryStructure->getElement(QueryStructure::FIRST))
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+        if ( $this->queryStructure->getElement( QueryStructure::FIRST ) )
+            $this->queryStructure->setElement( QueryStructure::LIMIT, 1 );
 
         $syntax = array();
 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * SELECT statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * DISTINCT clause
          */
-        $syntax[] = $this->getDistinctSyntax();
+        $syntax[ ] = $this->getDistinctSyntax();
 
         /**
          * FIELDS
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::FIELDS);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::FIELDS );
 
         /**
          * FROM table or queryStructure
          */
-        $syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * JOIN CLAUSES
          */
-        $syntax[] = $this->getJoinSyntax();
+        $syntax[ ] = $this->getJoinSyntax();
 
         /**
          * WHERE clause
          */
-        $syntax[] = $this->getWhereSyntax();
+        $syntax[ ] = $this->getWhereSyntax();
 
         /**
          * GROUP BY clause
          */
-        $syntax[] = $this->getGroupBySyntax();
+        $syntax[ ] = $this->getGroupBySyntax();
 
         /**
          * HAVING clause
          */
-        $syntax[] = $this->getHavingSyntax();
+        $syntax[ ] = $this->getHavingSyntax();
 
         /**
          * ORDER BY clause
          */
-        $syntax[] = $this->getOrderBySyntax();
+        $syntax[ ] = $this->getOrderBySyntax();
 
         /**
          * LIMIT clause
          */
-        $syntax[] = $this->getLimitSyntax();
+        $syntax[ ] = $this->getLimitSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
@@ -185,21 +185,21 @@ 
     public function execute()
     {
 
-        switch (true) {
-            case $this->queryStructure->getElement(QueryStructure::COUNT):
-                return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        switch ( true ) {
+            case $this->queryStructure->getElement( QueryStructure::COUNT ):
+                return DbService::getInstance()->single( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
-            case $this->queryStructure->getElement(QueryStructure::FIRST):
-                if ($this->queryStructure->getElement(QueryStructure::COLUMN))
-                    return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+            case $this->queryStructure->getElement( QueryStructure::FIRST ):
+                if ( $this->queryStructure->getElement( QueryStructure::COLUMN ) )
+                    return DbService::getInstance()->single( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
 
-                return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+                return DbService::getInstance()->row( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
-            case $this->queryStructure->getElement(QueryStructure::COLUMN):
-                return DbService::getInstance()->column($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+            case $this->queryStructure->getElement( QueryStructure::COLUMN ):
+                return DbService::getInstance()->column( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
             default:
-                return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+                return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
                 break;
         }
     }

Braces +9 added lines, -6 removed lines

@@ -55,8 +55,9 @@ 
             $this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
 
             $tableSelectParams = $table->getBindParams();
-            foreach ($tableSelectParams as $key => $value)
-                $this->queryStructure->setParams($key, $value);
+            foreach ($tableSelectParams as $key => $value) {
+                            $this->queryStructure->setParams($key, $value);
+            }
 
         }
     }
@@ -107,8 +108,9 @@ 
             $this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
         }
 
-        if ($this->queryStructure->getElement(QueryStructure::FIRST))
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+        if ($this->queryStructure->getElement(QueryStructure::FIRST)) {
+                    $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+        }
 
         $syntax = array();
 
@@ -190,8 +192,9 @@ 
                 return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
                 break;
             case $this->queryStructure->getElement(QueryStructure::FIRST):
-                if ($this->queryStructure->getElement(QueryStructure::COLUMN))
-                    return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+                if ($this->queryStructure->getElement(QueryStructure::COLUMN)) {
+                                    return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+                }
 
                 return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
                 break;

src/Statements/QueryCustom.php

Indentation +75 added lines, -75 removed lines

@@ -17,81 +17,81 @@
 {
 
 
-    /**
-     * @var string
-     */
-    protected $statement = QueryStatement::QUERY_STATEMENT_CUSTOM;
-
-    /**
-     * @var QueryBuild
-     */
-    protected $queryBuild;
-
-    /**
-     * @var QueryStructure
-     */
-    protected $queryStructure;
-
-    /**
-     * @var array
-     */
-    protected $usedInstanceIds = [];
-
-    /**
-     * @var string
-     */
-    protected $tablePrefix;
-
-
-    /**
-     * QueryCustom constructor.
-     * @param QueryBuild $queryBuild
-     * @param string $query
-     */
-    public function __construct(QueryBuild $queryBuild, $query = '')
-    {
-        $this->queryBuild = $queryBuild;
-        $this->queryStructure = new QueryStructure();
-        $this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
-        $this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
-        $this->queryStructure->setElement(QueryStructure::QUERY_STRING, $query);
-    }
-
-    /**
-     * @param array $params
-     * @return $this
-     */
-    public function withBindParams(array $params = [])
-    {
-        $this->queryStructure->replaceElement(QueryStructure::BIND_PARAMS, $params);
-
-        return $this;
-    }
-
-    /**
-     * @param bool|int $replacement
-     * @return mixed
-     */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-        return $this->queryStructure->getElement(QueryStructure::QUERY_STRING);
-    }
-
-    /**
-     * @return array
-     */
-    public function getBindParams()
-    {
-        return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
-    }
-
-    /**
-     * @return array|int|null
-     */
-    public function execute()
-    {
-        return DbService::getInstance()->query($this->queryStructure->getElement(QueryStructure::QUERY_STRING), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-    }
+	/**
+	 * @var string
+	 */
+	protected $statement = QueryStatement::QUERY_STATEMENT_CUSTOM;
+
+	/**
+	 * @var QueryBuild
+	 */
+	protected $queryBuild;
+
+	/**
+	 * @var QueryStructure
+	 */
+	protected $queryStructure;
+
+	/**
+	 * @var array
+	 */
+	protected $usedInstanceIds = [];
+
+	/**
+	 * @var string
+	 */
+	protected $tablePrefix;
+
+
+	/**
+	 * QueryCustom constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string $query
+	 */
+	public function __construct(QueryBuild $queryBuild, $query = '')
+	{
+		$this->queryBuild = $queryBuild;
+		$this->queryStructure = new QueryStructure();
+		$this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
+		$this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
+		$this->queryStructure->setElement(QueryStructure::QUERY_STRING, $query);
+	}
+
+	/**
+	 * @param array $params
+	 * @return $this
+	 */
+	public function withBindParams(array $params = [])
+	{
+		$this->queryStructure->replaceElement(QueryStructure::BIND_PARAMS, $params);
+
+		return $this;
+	}
+
+	/**
+	 * @param bool|int $replacement
+	 * @return mixed
+	 */
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+		return $this->queryStructure->getElement(QueryStructure::QUERY_STRING);
+	}
+
+	/**
+	 * @return array
+	 */
+	public function getBindParams()
+	{
+		return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
+	}
+
+	/**
+	 * @return array|int|null
+	 */
+	public function execute()
+	{
+		return DbService::getInstance()->query($this->queryStructure->getElement(QueryStructure::QUERY_STRING), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+	}
 
 
 }
\ No newline at end of file

Spacing +11 added lines, -11 removed lines

@@ -35,7 +35,7 @@ 
     /**
      * @var array
      */
-    protected $usedInstanceIds = [];
+    protected $usedInstanceIds = [ ];
 
     /**
      * @var string
@@ -48,22 +48,22 @@ 
      * @param QueryBuild $queryBuild
      * @param string $query
      */
-    public function __construct(QueryBuild $queryBuild, $query = '')
+    public function __construct( QueryBuild $queryBuild, $query = '' )
     {
         $this->queryBuild = $queryBuild;
         $this->queryStructure = new QueryStructure();
-        $this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
-        $this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
-        $this->queryStructure->setElement(QueryStructure::QUERY_STRING, $query);
+        $this->queryStructure->setElement( QueryStructure::STATEMENT, $this->statement );
+        $this->queryStructure->setElement( QueryStructure::QUERY_TYPE, $this->queryBuild->getType() );
+        $this->queryStructure->setElement( QueryStructure::QUERY_STRING, $query );
     }
 
     /**
      * @param array $params
      * @return $this
      */
-    public function withBindParams(array $params = [])
+    public function withBindParams( array $params = [ ] )
     {
-        $this->queryStructure->replaceElement(QueryStructure::BIND_PARAMS, $params);
+        $this->queryStructure->replaceElement( QueryStructure::BIND_PARAMS, $params );
 
         return $this;
     }
@@ -72,9 +72,9 @@ 
      * @param bool|int $replacement
      * @return mixed
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
-        return $this->queryStructure->getElement(QueryStructure::QUERY_STRING);
+        return $this->queryStructure->getElement( QueryStructure::QUERY_STRING );
     }
 
     /**
@@ -82,7 +82,7 @@ 
      */
     public function getBindParams()
     {
-        return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
+        return $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
     }
 
     /**
@@ -90,7 +90,7 @@ 
      */
     public function execute()
     {
-        return DbService::getInstance()->query($this->queryStructure->getElement(QueryStructure::QUERY_STRING), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->queryStructure->getElement( QueryStructure::QUERY_STRING ), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }
 
 

src/Statements/QueryUpdate.php

Indentation +85 added lines, -85 removed lines

@@ -26,89 +26,89 @@
 class QueryUpdate extends QueryStatement implements QueryStatementInterface
 {
 
-    use Limit, Where, WhereAndHavingBuilder, Replacement, OrderBy, SetFields, Ignore, DefaultPriority, LowPriority, Utilities;
-
-    /**
-     * @var string
-     */
-    protected $statement = self::QUERY_STATEMENT_UPDATE;
-
-
-    /**
-     * QueryUpdate constructor.
-     * @param QueryBuild $queryBuild
-     * @param string $table
-     */
-    public function __construct(QueryBuild $queryBuild, $table = null)
-    {
-        parent::__construct($queryBuild, $table);
-    }
-
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-
-        $syntax = array();
-
-        /**
-         *  Explain
-         */
-        $syntax[] = $this->getExplainSyntax();
-
-        /**
-         * UPDATE statement
-         */
-        $syntax[] = $this->statement;
-
-        /**
-         * PRIORITY
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
-
-        /**
-         * IGNORE clause
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
-
-        /**
-         * TABLE update
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::TABLE);
-
-        /**
-         * FIELDS update
-         */
-        $syntax[] = $this->getSettingFieldsSyntax();
-
-        /**
-         * WHERE clause
-         */
-        $syntax[] = $this->getWhereSyntax();
-
-        /**
-         * ORDER BY clause
-         */
-        $syntax[] = $this->getOrderBySyntax();
-
-        /**
-         * LIMIT clause
-         */
-        $syntax[] = $this->getLimitSyntax();
-
-        $syntax = implode(' ', $syntax);
-
-        return $this->getSyntaxReplace($syntax, $replacement);
-
-    }
-
-    /**
-     * @return array|int|null
-     * @throws QueryException
-     */
-    public function execute()
-    {
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
-
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-    }
+	use Limit, Where, WhereAndHavingBuilder, Replacement, OrderBy, SetFields, Ignore, DefaultPriority, LowPriority, Utilities;
+
+	/**
+	 * @var string
+	 */
+	protected $statement = self::QUERY_STATEMENT_UPDATE;
+
+
+	/**
+	 * QueryUpdate constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string $table
+	 */
+	public function __construct(QueryBuild $queryBuild, $table = null)
+	{
+		parent::__construct($queryBuild, $table);
+	}
+
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+
+		$syntax = array();
+
+		/**
+		 *  Explain
+		 */
+		$syntax[] = $this->getExplainSyntax();
+
+		/**
+		 * UPDATE statement
+		 */
+		$syntax[] = $this->statement;
+
+		/**
+		 * PRIORITY
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+
+		/**
+		 * IGNORE clause
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+
+		/**
+		 * TABLE update
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::TABLE);
+
+		/**
+		 * FIELDS update
+		 */
+		$syntax[] = $this->getSettingFieldsSyntax();
+
+		/**
+		 * WHERE clause
+		 */
+		$syntax[] = $this->getWhereSyntax();
+
+		/**
+		 * ORDER BY clause
+		 */
+		$syntax[] = $this->getOrderBySyntax();
+
+		/**
+		 * LIMIT clause
+		 */
+		$syntax[] = $this->getLimitSyntax();
+
+		$syntax = implode(' ', $syntax);
+
+		return $this->getSyntaxReplace($syntax, $replacement);
+
+	}
+
+	/**
+	 * @return array|int|null
+	 * @throws QueryException
+	 */
+	public function execute()
+	{
+		if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
+			throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+
+		return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+	}
 }
\ No newline at end of file

Spacing +17 added lines, -17 removed lines

@@ -39,12 +39,12 @@ 
      * @param QueryBuild $queryBuild
      * @param string $table
      */
-    public function __construct(QueryBuild $queryBuild, $table = null)
+    public function __construct( QueryBuild $queryBuild, $table = null )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
     }
 
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
 
         $syntax = array();
@@ -52,51 +52,51 @@ 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * UPDATE statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * IGNORE clause
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
         /**
          * TABLE update
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * FIELDS update
          */
-        $syntax[] = $this->getSettingFieldsSyntax();
+        $syntax[ ] = $this->getSettingFieldsSyntax();
 
         /**
          * WHERE clause
          */
-        $syntax[] = $this->getWhereSyntax();
+        $syntax[ ] = $this->getWhereSyntax();
 
         /**
          * ORDER BY clause
          */
-        $syntax[] = $this->getOrderBySyntax();
+        $syntax[ ] = $this->getOrderBySyntax();
 
         /**
          * LIMIT clause
          */
-        $syntax[] = $this->getLimitSyntax();
+        $syntax[ ] = $this->getLimitSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
@@ -106,9 +106,9 @@ 
      */
     public function execute()
     {
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
+            throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }
 }
\ No newline at end of file

Braces +3 added lines, -2 removed lines

@@ -106,8 +106,9 @@
      */
     public function execute()
     {
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE))) {
+                    throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        }
 
         return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
     }

src/Statements/QueryInsert.php

Indentation +75 added lines, -75 removed lines

@@ -23,81 +23,81 @@
 class QueryInsert extends QueryStatement implements QueryStatementInterface
 {
 
-    use Replacement, SetFields, Ignore, DefaultPriority, LowPriority, HighPriority, Utilities;
-
-    /**
-     * @var string
-     */
-    protected $statement = self::QUERY_STATEMENT_INSERT;
-
-
-    /**
-     * QueryInsert constructor.
-     * @param QueryBuild $queryBuild
-     * @param string $table
-     */
-    public function __construct(QueryBuild $queryBuild, $table = null)
-    {
-        parent::__construct($queryBuild, $table);
-    }
-
-    /**
-     * @return QueryInsertMultiple
-     */
-    public function multiple()
-    {
-        return new QueryInsertMultiple($this->queryBuild, $this->queryStructure->getElement(QueryStructure::TABLE));
-    }
-
-    /**
-     * @param bool|int $replacement
-     * @return mixed|string
-     */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-        $syntax = array();
-
-        /**
-         *  Explain
-         */
-        $syntax[] = $this->getExplainSyntax();
-
-        /**
-         * UPDATE statement
-         */
-        $syntax[] = $this->statement;
-
-        /**
-         * PRIORITY
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
-
-        /**
-         * IGNORE clause
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
-
-        /**
-         * INTO table
-         */
-        $syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
-
-        /**
-         * FIELDS update
-         */
-        $syntax[] = $this->getSettingFieldsSyntax();
-
-        $syntax = implode(' ', $syntax);
-
-        return $this->getSyntaxReplace($syntax, $replacement);
-
-    }
-
-
-    public function execute()
-    {
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-    }
+	use Replacement, SetFields, Ignore, DefaultPriority, LowPriority, HighPriority, Utilities;
+
+	/**
+	 * @var string
+	 */
+	protected $statement = self::QUERY_STATEMENT_INSERT;
+
+
+	/**
+	 * QueryInsert constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string $table
+	 */
+	public function __construct(QueryBuild $queryBuild, $table = null)
+	{
+		parent::__construct($queryBuild, $table);
+	}
+
+	/**
+	 * @return QueryInsertMultiple
+	 */
+	public function multiple()
+	{
+		return new QueryInsertMultiple($this->queryBuild, $this->queryStructure->getElement(QueryStructure::TABLE));
+	}
+
+	/**
+	 * @param bool|int $replacement
+	 * @return mixed|string
+	 */
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+		$syntax = array();
+
+		/**
+		 *  Explain
+		 */
+		$syntax[] = $this->getExplainSyntax();
+
+		/**
+		 * UPDATE statement
+		 */
+		$syntax[] = $this->statement;
+
+		/**
+		 * PRIORITY
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+
+		/**
+		 * IGNORE clause
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+
+		/**
+		 * INTO table
+		 */
+		$syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+
+		/**
+		 * FIELDS update
+		 */
+		$syntax[] = $this->getSettingFieldsSyntax();
+
+		$syntax = implode(' ', $syntax);
+
+		return $this->getSyntaxReplace($syntax, $replacement);
+
+	}
+
+
+	public function execute()
+	{
+		return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+	}
 
 
 }
\ No newline at end of file

Spacing +13 added lines, -13 removed lines

@@ -36,9 +36,9 @@ 
      * @param QueryBuild $queryBuild
      * @param string $table
      */
-    public function __construct(QueryBuild $queryBuild, $table = null)
+    public function __construct( QueryBuild $queryBuild, $table = null )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
     }
 
     /**
@@ -46,57 +46,57 @@ 
      */
     public function multiple()
     {
-        return new QueryInsertMultiple($this->queryBuild, $this->queryStructure->getElement(QueryStructure::TABLE));
+        return new QueryInsertMultiple( $this->queryBuild, $this->queryStructure->getElement( QueryStructure::TABLE ) );
     }
 
     /**
      * @param bool|int $replacement
      * @return mixed|string
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
         $syntax = array();
 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * UPDATE statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * IGNORE clause
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
         /**
          * INTO table
          */
-        $syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * FIELDS update
          */
-        $syntax[] = $this->getSettingFieldsSyntax();
+        $syntax[ ] = $this->getSettingFieldsSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
 
     public function execute()
     {
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }
 
 

src/Statements/QueryInsertMultiple.php

Indentation +63 added lines, -63 removed lines

@@ -23,67 +23,67 @@
 class QueryInsertMultiple extends QueryStatement implements QueryStatementInterface
 {
 
-    use InsertMultiple, Replacement, Ignore, DefaultPriority, LowPriority, HighPriority, Utilities;
-
-    /**
-     * @var string
-     */
-    protected $statement = self::QUERY_STATEMENT_INSERT;
-
-
-    /**
-     * QueryInsert constructor.
-     * @param QueryBuild $queryBuild
-     * @param string $table
-     */
-    public function __construct(QueryBuild $queryBuild, $table = null)
-    {
-        parent::__construct($queryBuild, $table);
-        $this->queryStructure->setElement(QueryStructure::FIELDS, array());
-    }
-
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-        $syntax = array();
-
-        /**
-         *  Explain
-         */
-        $syntax[] = $this->getExplainSyntax();
-
-        /**
-         * UPDATE statement
-         */
-        $syntax[] = $this->statement;
-
-        /**
-         * PRIORITY
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
-
-        /**
-         * IGNORE clause
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
-
-        /**
-         * INTO table
-         */
-        $syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
-
-        /**
-         * FIELDS update
-         */
-        $syntax[] = $this->getInsertMultipleRowsSyntax();
-
-        $syntax = implode(' ', $syntax);
-
-        return $this->getSyntaxReplace($syntax, $replacement);
-
-    }
-
-    public function execute()
-    {
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-    }
+	use InsertMultiple, Replacement, Ignore, DefaultPriority, LowPriority, HighPriority, Utilities;
+
+	/**
+	 * @var string
+	 */
+	protected $statement = self::QUERY_STATEMENT_INSERT;
+
+
+	/**
+	 * QueryInsert constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string $table
+	 */
+	public function __construct(QueryBuild $queryBuild, $table = null)
+	{
+		parent::__construct($queryBuild, $table);
+		$this->queryStructure->setElement(QueryStructure::FIELDS, array());
+	}
+
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+		$syntax = array();
+
+		/**
+		 *  Explain
+		 */
+		$syntax[] = $this->getExplainSyntax();
+
+		/**
+		 * UPDATE statement
+		 */
+		$syntax[] = $this->statement;
+
+		/**
+		 * PRIORITY
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+
+		/**
+		 * IGNORE clause
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+
+		/**
+		 * INTO table
+		 */
+		$syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+
+		/**
+		 * FIELDS update
+		 */
+		$syntax[] = $this->getInsertMultipleRowsSyntax();
+
+		$syntax = implode(' ', $syntax);
+
+		return $this->getSyntaxReplace($syntax, $replacement);
+
+	}
+
+	public function execute()
+	{
+		return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+	}
 }
\ No newline at end of file

Spacing +13 added lines, -13 removed lines

@@ -36,54 +36,54 @@
      * @param QueryBuild $queryBuild
      * @param string $table
      */
-    public function __construct(QueryBuild $queryBuild, $table = null)
+    public function __construct( QueryBuild $queryBuild, $table = null )
     {
-        parent::__construct($queryBuild, $table);
-        $this->queryStructure->setElement(QueryStructure::FIELDS, array());
+        parent::__construct( $queryBuild, $table );
+        $this->queryStructure->setElement( QueryStructure::FIELDS, array() );
     }
 
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
         $syntax = array();
 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * UPDATE statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * IGNORE clause
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
 
         /**
          * INTO table
          */
-        $syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * FIELDS update
          */
-        $syntax[] = $this->getInsertMultipleRowsSyntax();
+        $syntax[ ] = $this->getInsertMultipleRowsSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
 
     }
 
     public function execute()
     {
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
     }
 }
\ No newline at end of file

src/Statements/QueryStatement.php

Indentation +65 added lines, -65 removed lines

@@ -18,71 +18,71 @@
 abstract class QueryStatement
 {
 
-    use Utilities, TableValidation, ColumnValidation;
-
-
-    /**
-     * Statements
-     */
-    const QUERY_STATEMENT_SELECT = 'SELECT';
-    const QUERY_STATEMENT_UPDATE = 'UPDATE';
-    const QUERY_STATEMENT_DELETE = 'DELETE';
-    const QUERY_STATEMENT_INSERT = 'INSERT';
-    const QUERY_STATEMENT_CUSTOM = 'CUSTOM';
-
-
-    /**
-     * @var string
-     */
-    protected $statement;
-
-    /**
-     * @var QueryBuild
-     */
-    protected $queryBuild;
-
-    /**
-     * @var QueryStructure
-     */
-    protected $queryStructure;
-
-    /**
-     * @var array
-     */
-    protected $usedInstanceIds = [];
-
-    /**
-     * @var string
-     */
-    protected $tablePrefix;
-
-
-    /**
-     * QueryStatement constructor.
-     * @param QueryBuild $queryBuild
-     * @param string|QuerySelect $table
-     * @throws QueryException
-     */
-    public function __construct(QueryBuild $queryBuild, $table = '')
-    {
-
-        $table = $this->validateTable($table);
-
-        $this->queryBuild = $queryBuild;
-        $this->queryStructure = new QueryStructure();
-        $this->queryStructure->setElement(QueryStructure::TABLE, $table);
-        $this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
-        $this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
-
-    }
-
-    /**
-     * @return mixed
-     */
-    public function getBindParams()
-    {
-        return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
-    }
+	use Utilities, TableValidation, ColumnValidation;
+
+
+	/**
+	 * Statements
+	 */
+	const QUERY_STATEMENT_SELECT = 'SELECT';
+	const QUERY_STATEMENT_UPDATE = 'UPDATE';
+	const QUERY_STATEMENT_DELETE = 'DELETE';
+	const QUERY_STATEMENT_INSERT = 'INSERT';
+	const QUERY_STATEMENT_CUSTOM = 'CUSTOM';
+
+
+	/**
+	 * @var string
+	 */
+	protected $statement;
+
+	/**
+	 * @var QueryBuild
+	 */
+	protected $queryBuild;
+
+	/**
+	 * @var QueryStructure
+	 */
+	protected $queryStructure;
+
+	/**
+	 * @var array
+	 */
+	protected $usedInstanceIds = [];
+
+	/**
+	 * @var string
+	 */
+	protected $tablePrefix;
+
+
+	/**
+	 * QueryStatement constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string|QuerySelect $table
+	 * @throws QueryException
+	 */
+	public function __construct(QueryBuild $queryBuild, $table = '')
+	{
+
+		$table = $this->validateTable($table);
+
+		$this->queryBuild = $queryBuild;
+		$this->queryStructure = new QueryStructure();
+		$this->queryStructure->setElement(QueryStructure::TABLE, $table);
+		$this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
+		$this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
+
+	}
+
+	/**
+	 * @return mixed
+	 */
+	public function getBindParams()
+	{
+		return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
+	}
 
 
 }
\ No newline at end of file

Spacing +7 added lines, -7 removed lines

@@ -49,7 +49,7 @@ 
     /**
      * @var array
      */
-    protected $usedInstanceIds = [];
+    protected $usedInstanceIds = [ ];
 
     /**
      * @var string
@@ -63,16 +63,16 @@ 
      * @param string|QuerySelect $table
      * @throws QueryException
      */
-    public function __construct(QueryBuild $queryBuild, $table = '')
+    public function __construct( QueryBuild $queryBuild, $table = '' )
     {
 
-        $table = $this->validateTable($table);
+        $table = $this->validateTable( $table );
 
         $this->queryBuild = $queryBuild;
         $this->queryStructure = new QueryStructure();
-        $this->queryStructure->setElement(QueryStructure::TABLE, $table);
-        $this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
-        $this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
+        $this->queryStructure->setElement( QueryStructure::TABLE, $table );
+        $this->queryStructure->setElement( QueryStructure::STATEMENT, $this->statement );
+        $this->queryStructure->setElement( QueryStructure::QUERY_TYPE, $this->queryBuild->getType() );
 
     }
 
@@ -81,7 +81,7 @@ 
      */
     public function getBindParams()
     {
-        return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
+        return $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
     }
 
 

src/Statements/QueryStatementInterface.php

Indentation +9 added lines, -9 removed lines

@@ -11,17 +11,17 @@
 interface QueryStatementInterface
 {
 
-    const REPLACEMENT_NONE = 0;
-    const REPLACEMENT_VALUES = 1;
+	const REPLACEMENT_NONE = 0;
+	const REPLACEMENT_VALUES = 1;
 
-    /**
-     * @param bool $replacement
-     * @return string
-     */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE);
+	/**
+	 * @param bool $replacement
+	 * @return string
+	 */
+	public function getSyntax($replacement = self::REPLACEMENT_NONE);
 
-    public function execute();
+	public function execute();
 
-    public function getBindParams();
+	public function getBindParams();
 
 }
\ No newline at end of file

Spacing +1 added lines, -1 removed lines

@@ -18,7 +18,7 @@
      * @param bool $replacement
      * @return string
      */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE);
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE );
 
     public function execute();
 

src/Statements/QueryDelete.php

Indentation +75 added lines, -75 removed lines

@@ -27,81 +27,81 @@
 class QueryDelete extends QueryStatement implements QueryStatementInterface
 {
 
-    use Limit, Where, WhereAndHavingBuilder, Replacement, OrderBy, SetFields, Ignore, DefaultPriority, LowPriority, Utilities;
-
-    /**
-     * @var string
-     */
-    protected $statement = self::QUERY_STATEMENT_DELETE;
-
-
-    /**
-     * QueryDelete constructor.
-     * @param QueryBuild $queryBuild
-     * @param string $table
-     */
-    public function __construct(QueryBuild $queryBuild, $table = null)
-    {
-        parent::__construct($queryBuild, $table);
-    }
-
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-        $syntax = array();
-
-        /**
-         *  Explain
-         */
-        $syntax[] = $this->getExplainSyntax();
-
-        /**
-         * UPDATE statement
-         */
-        $syntax[] = $this->statement;
-
-        /**
-         * PRIORITY
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
-
-        /**
-         * TABLE update
-         */
-        $syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
-
-        /**
-         * WHERE clause
-         */
-        $syntax[] = $this->getWhereSyntax();
-
-        /**
-         * ORDER BY clause
-         */
-        $syntax[] = $this->getOrderBySyntax();
-
-        /**
-         * LIMIT clause
-         */
-        $syntax[] = $this->getLimitSyntax();
-
-        $syntax = implode(' ', $syntax);
-
-        return $this->getSyntaxReplace($syntax, $replacement);
-    }
-
-    /**
-     * @return array|int|null
-     * @throws QueryException
-     */
-    public function execute()
-    {
-
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
-
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-
-    }
+	use Limit, Where, WhereAndHavingBuilder, Replacement, OrderBy, SetFields, Ignore, DefaultPriority, LowPriority, Utilities;
+
+	/**
+	 * @var string
+	 */
+	protected $statement = self::QUERY_STATEMENT_DELETE;
+
+
+	/**
+	 * QueryDelete constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string $table
+	 */
+	public function __construct(QueryBuild $queryBuild, $table = null)
+	{
+		parent::__construct($queryBuild, $table);
+	}
+
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+		$syntax = array();
+
+		/**
+		 *  Explain
+		 */
+		$syntax[] = $this->getExplainSyntax();
+
+		/**
+		 * UPDATE statement
+		 */
+		$syntax[] = $this->statement;
+
+		/**
+		 * PRIORITY
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+
+		/**
+		 * TABLE update
+		 */
+		$syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+
+		/**
+		 * WHERE clause
+		 */
+		$syntax[] = $this->getWhereSyntax();
+
+		/**
+		 * ORDER BY clause
+		 */
+		$syntax[] = $this->getOrderBySyntax();
+
+		/**
+		 * LIMIT clause
+		 */
+		$syntax[] = $this->getLimitSyntax();
+
+		$syntax = implode(' ', $syntax);
+
+		return $this->getSyntaxReplace($syntax, $replacement);
+	}
+
+	/**
+	 * @return array|int|null
+	 * @throws QueryException
+	 */
+	public function execute()
+	{
+
+		if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
+			throw new QueryException('Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+
+		return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+
+	}
 
 
 }
\ No newline at end of file

Spacing +15 added lines, -15 removed lines

@@ -40,53 +40,53 @@ 
      * @param QueryBuild $queryBuild
      * @param string $table
      */
-    public function __construct(QueryBuild $queryBuild, $table = null)
+    public function __construct( QueryBuild $queryBuild, $table = null )
     {
-        parent::__construct($queryBuild, $table);
+        parent::__construct( $queryBuild, $table );
     }
 
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
+    public function getSyntax( $replacement = self::REPLACEMENT_NONE )
     {
         $syntax = array();
 
         /**
          *  Explain
          */
-        $syntax[] = $this->getExplainSyntax();
+        $syntax[ ] = $this->getExplainSyntax();
 
         /**
          * UPDATE statement
          */
-        $syntax[] = $this->statement;
+        $syntax[ ] = $this->statement;
 
         /**
          * PRIORITY
          */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+        $syntax[ ] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
 
         /**
          * TABLE update
          */
-        $syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+        $syntax[ ] = 'FROM ' . $this->queryStructure->getElement( QueryStructure::TABLE );
 
         /**
          * WHERE clause
          */
-        $syntax[] = $this->getWhereSyntax();
+        $syntax[ ] = $this->getWhereSyntax();
 
         /**
          * ORDER BY clause
          */
-        $syntax[] = $this->getOrderBySyntax();
+        $syntax[ ] = $this->getOrderBySyntax();
 
         /**
          * LIMIT clause
          */
-        $syntax[] = $this->getLimitSyntax();
+        $syntax[ ] = $this->getLimitSyntax();
 
-        $syntax = implode(' ', $syntax);
+        $syntax = implode( ' ', $syntax );
 
-        return $this->getSyntaxReplace($syntax, $replacement);
+        return $this->getSyntaxReplace( $syntax, $replacement );
     }
 
     /**
@@ -96,10 +96,10 @@ 
     public function execute()
     {
 
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        if ( $this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) && !count( $this->queryStructure->getElement( QueryStructure::WHERE ) ) )
+            throw new QueryException( 'Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
 
-        return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+        return DbService::getInstance()->query( $this->getSyntax(), $this->queryStructure->getElement( QueryStructure::BIND_PARAMS ) );
 
     }
 

Braces +3 added lines, -2 removed lines

@@ -96,8 +96,9 @@
     public function execute()
     {
 
-        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE)))
-            throw new QueryException('Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        if ($this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) && !count($this->queryStructure->getElement(QueryStructure::WHERE))) {
+                    throw new QueryException('Where or Having clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
+        }
 
         return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));