EmmetBlue / Emmet-Blue

src/Core/Builder/QueryBuilder/QueryBuilder.php

Indentation +165 added lines, -165 removed lines

@@ -20,169 +20,169 @@
  */
 class QueryBuilder implements BuildableInterface
 {
-    /**
-     * @var string Global Sql Statement
-     */
-    private $sqlStatement;
-
-    /**
-     * @var string SPACE
-     */
-    const SPACE = ' ';
-
-    /**
-     * @param string | null $sqlStatement SQL Statement to be processed by the build method
-     *
-     * @throws {@todo Write exception class}
-     */
-    public function __construct(string $sqlStatement = null)
-    {
-        self::setSqlStatement($sqlStatement);
-    }
-
-    /**
-     * Returns the string value of the global sqlStatement variable.
-     *
-     * @return string
-     */
-    private function getSqlStatement()
-    {
-        return $this->sqlStatement;
-    }
-
-    /**
-     * Sets/Modifies the value of the global sqlStatement variable.
-     *
-     * @param string $sqlStatement to set/replace global equivalent to.
-     *
-     * @return null
-     */
-    private function setSqlStatement(string $sqlStatement = null)
-    {
-        $this->sqlStatement = $sqlStatement;
-    }
-
-    /**
-     * Builds a QueryBuilder object.
-     * {@see QueryBuildableInterface}.
-     *
-     * @param string | null $sqlStringToAppend
-     *
-     * @throws {@todo Create exceptions}
-     *
-     * @return QueryBuilder new instance of the QueryBuilder object.
-     */
-    public function build(string $sqlStringToAppend) : BuildableInterface
-    {
-        $separator = (empty(self::getSqlStatement())) ? '' : self::SPACE;
-        $newSqlString = self::getSqlStatement().$separator.$sqlStringToAppend;
-        self::setSqlStatement($newSqlString);
-
-        return $this;
-    }
-
-    /**
-     * returns a `built sql` when the QueryBuilder object is casted to a string.
-     *
-     * @return string
-     */
-    public function __toString()
-    {
-        return self::getSqlStatement();
-    }
-
-    /**
-     * Implodes an array into a string.
-     *
-     * @param array  $arrayToImplode
-     * @param string $delimiter      Optional.
-     *
-     * @return string
-     */
-    protected function getImplodedString(array $arrayToImplode, string $delimiter = ',') : string
-    {
-        return implode($delimiter, $arrayToImplode);
-    }
-
-    /**
-     * Implodes an array into a string while keeping track of the keys.
-     *
-     * @param array  $arrayToImplode
-     * @param string $delimiter Optional.
-     *
-     * @return string
-     */
-    protected function getImplodedStringWithKeys(array $arrayToImplode, string $keyDelimiter='=', string $delimiter = ',') : string
-    {
-        $implodedStrings = []; 
-
-        foreach ($arrayToImplode as $key=>$value)
-        {
-            $implodedStrings[] = $key.$keyDelimiter.$value;
-        }
-
-        return implode($delimiter, $implodedStrings);
-    }
-
-    /**
-     * Wraps a string with specified characters.
-     *
-     * @param string      $strBefore
-     * @param string|null $strAfter
-     * @param string      $strToWrap
-     *
-     * @return string
-     */
-    public static function wrapString(string $strToWrap, string $strBefore, string $strAfter = null) : string
-    {
-        return $strBefore.$strToWrap.(is_null($strAfter) ? $strBefore : $strAfter);
-    }
-
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\BuildableInterface
-     */
-    public function where(string $condition)
-    {
-        $whereString = "WHERE $condition";
-
-        $this->queryBuilder = $this->queryBuilder->build($whereString);
-
-        return $this;
-    }
-
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\BuildableInterface
-     */
-    public function andWhere(string $condition)
-    {
-         $whereString = "AND $condition";
-
-        $this->queryBuilder = $this->queryBuilder->build($whereString);
-
-        return $this;
-    }
-
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\BuildableInterface
-     */
-    public function orWhere(string $condition)
-    {
-         $whereString = "OR $condition";
-
-        $this->queryBuilder = $this->queryBuilder->build($whereString);
-
-        return $this;
-    }
+	/**
+	 * @var string Global Sql Statement
+	 */
+	private $sqlStatement;
+
+	/**
+	 * @var string SPACE
+	 */
+	const SPACE = ' ';
+
+	/**
+	 * @param string | null $sqlStatement SQL Statement to be processed by the build method
+	 *
+	 * @throws {@todo Write exception class}
+	 */
+	public function __construct(string $sqlStatement = null)
+	{
+		self::setSqlStatement($sqlStatement);
+	}
+
+	/**
+	 * Returns the string value of the global sqlStatement variable.
+	 *
+	 * @return string
+	 */
+	private function getSqlStatement()
+	{
+		return $this->sqlStatement;
+	}
+
+	/**
+	 * Sets/Modifies the value of the global sqlStatement variable.
+	 *
+	 * @param string $sqlStatement to set/replace global equivalent to.
+	 *
+	 * @return null
+	 */
+	private function setSqlStatement(string $sqlStatement = null)
+	{
+		$this->sqlStatement = $sqlStatement;
+	}
+
+	/**
+	 * Builds a QueryBuilder object.
+	 * {@see QueryBuildableInterface}.
+	 *
+	 * @param string | null $sqlStringToAppend
+	 *
+	 * @throws {@todo Create exceptions}
+	 *
+	 * @return QueryBuilder new instance of the QueryBuilder object.
+	 */
+	public function build(string $sqlStringToAppend) : BuildableInterface
+	{
+		$separator = (empty(self::getSqlStatement())) ? '' : self::SPACE;
+		$newSqlString = self::getSqlStatement().$separator.$sqlStringToAppend;
+		self::setSqlStatement($newSqlString);
+
+		return $this;
+	}
+
+	/**
+	 * returns a `built sql` when the QueryBuilder object is casted to a string.
+	 *
+	 * @return string
+	 */
+	public function __toString()
+	{
+		return self::getSqlStatement();
+	}
+
+	/**
+	 * Implodes an array into a string.
+	 *
+	 * @param array  $arrayToImplode
+	 * @param string $delimiter      Optional.
+	 *
+	 * @return string
+	 */
+	protected function getImplodedString(array $arrayToImplode, string $delimiter = ',') : string
+	{
+		return implode($delimiter, $arrayToImplode);
+	}
+
+	/**
+	 * Implodes an array into a string while keeping track of the keys.
+	 *
+	 * @param array  $arrayToImplode
+	 * @param string $delimiter Optional.
+	 *
+	 * @return string
+	 */
+	protected function getImplodedStringWithKeys(array $arrayToImplode, string $keyDelimiter='=', string $delimiter = ',') : string
+	{
+		$implodedStrings = []; 
+
+		foreach ($arrayToImplode as $key=>$value)
+		{
+			$implodedStrings[] = $key.$keyDelimiter.$value;
+		}
+
+		return implode($delimiter, $implodedStrings);
+	}
+
+	/**
+	 * Wraps a string with specified characters.
+	 *
+	 * @param string      $strBefore
+	 * @param string|null $strAfter
+	 * @param string      $strToWrap
+	 *
+	 * @return string
+	 */
+	public static function wrapString(string $strToWrap, string $strBefore, string $strAfter = null) : string
+	{
+		return $strBefore.$strToWrap.(is_null($strAfter) ? $strBefore : $strAfter);
+	}
+
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\BuildableInterface
+	 */
+	public function where(string $condition)
+	{
+		$whereString = "WHERE $condition";
+
+		$this->queryBuilder = $this->queryBuilder->build($whereString);
+
+		return $this;
+	}
+
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\BuildableInterface
+	 */
+	public function andWhere(string $condition)
+	{
+		 $whereString = "AND $condition";
+
+		$this->queryBuilder = $this->queryBuilder->build($whereString);
+
+		return $this;
+	}
+
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\BuildableInterface
+	 */
+	public function orWhere(string $condition)
+	{
+		 $whereString = "OR $condition";
+
+		$this->queryBuilder = $this->queryBuilder->build($whereString);
+
+		return $this;
+	}
 }