EmmetBlue / Emmet-Blue

src/Core/Builder/QueryBuilder/SelectQueryBuilder.php

Indentation +72 added lines, -72 removed lines

@@ -17,84 +17,84 @@
  */
 class SelectQueryBuilder extends QueryBuilder
 {
-    /**
-     * @var \EmmetBlue\Core\Builder\QueryBuilder
-     */
-    protected $queryBuilder;
+	/**
+	 * @var \EmmetBlue\Core\Builder\QueryBuilder
+	 */
+	protected $queryBuilder;
 
-    /**
-     * @param string|null $tableName
-     */
-    public function __construct()
-    {
-        $SelectKeyword = "SELECT";
-        $this->queryBuilder = $this->build($SelectKeyword);
-    }
+	/**
+	 * @param string|null $tableName
+	 */
+	public function __construct()
+	{
+		$SelectKeyword = "SELECT";
+		$this->queryBuilder = $this->build($SelectKeyword);
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param int $topValue
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function top(int $topValue)
-    {
-        $this->queryBuilder = $this->queryBuilder->build("TOP ".$topValue);
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param int $topValue
+	 *
+	 * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	 */
+	public function top(int $topValue)
+	{
+		$this->queryBuilder = $this->queryBuilder->build("TOP ".$topValue);
 
-        return $this;
-    }
-    /**
-    * This method handles situations that requires to
-    * select all from the table.
-    * @param *
-    */
-    public function all()
-    {
-        $this->queryBuilder = $this->queryBuilder->build("*");
-        return $this;
-    }
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $columns
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function columns(string ...$columns)
-    {
-        $this->queryBuilder = $this->queryBuilder->build(self::getImplodedString($columns));
+		return $this;
+	}
+	/**
+	 * This method handles situations that requires to
+	 * select all from the table.
+	 * @param *
+	 */
+	public function all()
+	{
+		$this->queryBuilder = $this->queryBuilder->build("*");
+		return $this;
+	}
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $columns
+	 *
+	 * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	 */
+	public function columns(string ...$columns)
+	{
+		$this->queryBuilder = $this->queryBuilder->build(self::getImplodedString($columns));
 
-        return $this;
-    }
+		return $this;
+	}
 
-     /**
-     * {@inheritdoc}
-     *
-     * @param string $tableName
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function from(string $tableName)
-    {
-        $this->queryBuilder = $this->queryBuilder->build("FROM ".$tableName);
+	 /**
+	  * {@inheritdoc}
+	  *
+	  * @param string $tableName
+	  *
+	  * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	  */
+	public function from(string $tableName)
+	{
+		$this->queryBuilder = $this->queryBuilder->build("FROM ".$tableName);
 
-        return $this;
-    }
+		return $this;
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $tableName
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function innerJoin(string $tableName, string $condition)
-    {
-        $string = "INNER JOIN ".$tableName." ON ".$condition;
-        $this->queryBuilder = $this->queryBuilder->build($string);
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $tableName
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	 */
+	public function innerJoin(string $tableName, string $condition)
+	{
+		$string = "INNER JOIN ".$tableName." ON ".$condition;
+		$this->queryBuilder = $this->queryBuilder->build($string);
 
-        return $this;
-    }
+		return $this;
+	}
 }

src/Core/Validator/Validators/UserIDValidator.php

Indentation +13 added lines, -13 removed lines

@@ -21,18 +21,18 @@
  */
 class UserIDValidator implements ValidatorInterface
 {
-    public function isValidUserId(string $userId)
-    {
-        $selectQuery = (new Builder('QueryBuilder', 'Select'))->getBuilder();
+	public function isValidUserId(string $userId)
+	{
+		$selectQuery = (new Builder('QueryBuilder', 'Select'))->getBuilder();
 
-        $selectQuery
-            ->top(1)
-            ->columns('StaffID')
-            ->from('[Staffs].[Staff]')
-            ->where(
-                'StaffID',
-                '='.
-                $userId
-            );
-    }
+		$selectQuery
+			->top(1)
+			->columns('StaffID')
+			->from('[Staffs].[Staff]')
+			->where(
+				'StaffID',
+				'='.
+				$userId
+			);
+	}
 }

src/Core/Exception/UnexpectedErrorException.php

Indentation +5 added lines, -5 removed lines

@@ -20,10 +20,10 @@
  */
 class UnexpectedErrorException extends Exception
 {
-    public function __construct(string $message, int $databaseUser)
-    {
-        parent::__construct($message, 0, $previous);
+	public function __construct(string $message, int $databaseUser)
+	{
+		parent::__construct($message, 0, $previous);
 
-        $this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_HIGH);
-    }
+		$this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_HIGH);
+	}
 }

src/Core/Exception/SQLException.php

Indentation +5 added lines, -5 removed lines

@@ -20,10 +20,10 @@
  */
 class SQLException extends Exception
 {
-    public function __construct(string $message, int $databaseUser)
-    {
-        parent::__construct($message, 0, null);
+	public function __construct(string $message, int $databaseUser)
+	{
+		parent::__construct($message, 0, null);
         
-        $this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_NORMAL);
-    }
+		$this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_NORMAL);
+	}
 }

src/Core/Exception/UndefinedValueException.php

Indentation +5 added lines, -5 removed lines

@@ -20,10 +20,10 @@
  */
 class UndefinedValueException extends Exception
 {
-    public function __construct(string $message, int $databaseUser)
-    {
-        parent::__construct($message, 0, null);
+	public function __construct(string $message, int $databaseUser)
+	{
+		parent::__construct($message, 0, null);
         
-        $this->log($databaseUser, Constant::ERROR_404, Constant::ERROR_NORMAL);
-    }
+		$this->log($databaseUser, Constant::ERROR_404, Constant::ERROR_NORMAL);
+	}
 }

src/Core/Session/Session.php

Indentation +29 added lines, -29 removed lines

@@ -17,37 +17,37 @@
  */
 class Session
 {
-    protected $session;
+	protected $session;
     
-    /**
-     * 
-     */
-    public static function init($session = "")
-    {
-        $this->session = $session;
-    }
+	/**
+	 * 
+	 */
+	public static function init($session = "")
+	{
+		$this->session = $session;
+	}
     
-    /**
-     * 
-     */
-    public static function save($key, $value)
-    {
-        $session[$key] = $value;
-    }
+	/**
+	 * 
+	 */
+	public static function save($key, $value)
+	{
+		$session[$key] = $value;
+	}
 
-    /**
-     * 
-     */
-    public static function get($key)
-    {
-        return $session[$key] ?? '';
-    }
+	/**
+	 * 
+	 */
+	public static function get($key)
+	{
+		return $session[$key] ?? '';
+	}
 
-    /**
-     * 
-     */
-    public static function delete($key)
-    {
-       unset($session[$key]);
-    }
+	/**
+	 * 
+	 */
+	public static function delete($key)
+	{
+	   unset($session[$key]);
+	}
 }

src/Core/Connection/Adapters/SQLServer.php

Indentation +93 added lines, -93 removed lines

@@ -21,110 +21,110 @@
  */
 class SQlServer implements ConnectableInterface
 {
-    /**
-     * @var string $dsn
-     */
-    protected $dsn;
+	/**
+	 * @var string $dsn
+	 */
+	protected $dsn;
 
-    /**
-     * @var \PDO $connectionObject
-     */
-    protected $connectionObject;
+	/**
+	 * @var \PDO $connectionObject
+	 */
+	protected $connectionObject;
 
-    /**
-     * @var array loginData
-     */
-    private $loginData = [];
+	/**
+	 * @var array loginData
+	 */
+	private $loginData = [];
 
-    /**
-     * Setter for the DSN string {@see $dsn}
-     *
-     * MSSQl Server DSN Structure: sqlsrv:Server={srv};Database={db}"
-     * `$dsnArray[0] = {srv}`
-     * `$dsnArray[1] = {db}`
-     * Attributes = [2 - infinity]
-     *
-     * @param array $dsnArray
-     * @return void
-     */
-    public function setDsn(array $dsnArray)
-    {
-        $this->dsn = $dsnArray;
-    }
+	/**
+	 * Setter for the DSN string {@see $dsn}
+	 *
+	 * MSSQl Server DSN Structure: sqlsrv:Server={srv};Database={db}"
+	 * `$dsnArray[0] = {srv}`
+	 * `$dsnArray[1] = {db}`
+	 * Attributes = [2 - infinity]
+	 *
+	 * @param array $dsnArray
+	 * @return void
+	 */
+	public function setDsn(array $dsnArray)
+	{
+		$this->dsn = $dsnArray;
+	}
 
-    /**
-     * Establishes connection
-     *
-     * @param string $username
-     * @param string $password optional
-     * @throws \EmmetBlue\Core\Exception\SQLException
-     * @return void
-     */
-    public function connect(string $username, string $password="")
-    {
-        $server = $this->dsn[0];
-        $database = $this->dsn[1];
+	/**
+	 * Establishes connection
+	 *
+	 * @param string $username
+	 * @param string $password optional
+	 * @throws \EmmetBlue\Core\Exception\SQLException
+	 * @return void
+	 */
+	public function connect(string $username, string $password="")
+	{
+		$server = $this->dsn[0];
+		$database = $this->dsn[1];
 
-        $this->loginData['username'] = $username;
-        $this->loginData['password'] = $password;
+		$this->loginData['username'] = $username;
+		$this->loginData['password'] = $password;
 
-        try
-        {
-            $this->connectionObject = new \PDO("sqlsrv:Server=$server;Database=$database;ConnectionPooling=0", $username, $password);
-        }
-        catch (\PDOException $e)
-        {
-            throw new SQLException("Unable to connect to database", 400, $e);  
-        }
+		try
+		{
+			$this->connectionObject = new \PDO("sqlsrv:Server=$server;Database=$database;ConnectionPooling=0", $username, $password);
+		}
+		catch (\PDOException $e)
+		{
+			throw new SQLException("Unable to connect to database", 400, $e);  
+		}
 
-        $dsn = $this->dsn;
-        unset($dsn[0], $dsn[1]);
+		$dsn = $this->dsn;
+		unset($dsn[0], $dsn[1]);
         
-        foreach ($dsn as $attribute)
-        {
-            foreach ($attribute as $key=>$value)
-            {
-                $this->connectionObject->setAttribute($key, $value);
-            }
-        }
-    }
+		foreach ($dsn as $attribute)
+		{
+			foreach ($attribute as $key=>$value)
+			{
+				$this->connectionObject->setAttribute($key, $value);
+			}
+		}
+	}
 
-    /**
-     * Returns an instance a pdo intance of the connection object
-     *
-     * @return \PDO
-     */
-    public function getConnection() : \PDO
-    {
-        if ($this->connectionObject instanceof \PDO)
-        {
-            return $this->connectionObject;
-        }
+	/**
+	 * Returns an instance a pdo intance of the connection object
+	 *
+	 * @return \PDO
+	 */
+	public function getConnection() : \PDO
+	{
+		if ($this->connectionObject instanceof \PDO)
+		{
+			return $this->connectionObject;
+		}
 
-        $this->connect(
-            $this->loginData['username'] ?? '',
-            $this->loginData['password'] ?? ''
-        );
+		$this->connect(
+			$this->loginData['username'] ?? '',
+			$this->loginData['password'] ?? ''
+		);
 
-        return $this->connectionObject;
-    }
+		return $this->connectionObject;
+	}
 
-    /**
-     * Closes connection
-     */
-    public function disableConnection()
-    {
-        $this->connectionObject = null;
-    }
+	/**
+	 * Closes connection
+	 */
+	public function disableConnection()
+	{
+		$this->connectionObject = null;
+	}
 
-    /**
-     * Sets attributes for the PDO object
-     *
-     * @param \PDO $attribute
-     * @param \PDO $value
-     */
-    public function setAttribute(\PDO $attribute, \PDO $value)
-    {
-         $this->connectionObject->setAttribute($attribute, $value);
-    }
+	/**
+	 * Sets attributes for the PDO object
+	 *
+	 * @param \PDO $attribute
+	 * @param \PDO $value
+	 */
+	public function setAttribute(\PDO $attribute, \PDO $value)
+	{
+		 $this->connectionObject->setAttribute($attribute, $value);
+	}
 }

src/Core/CustomFileNameGenerator.php

Indentation +20 added lines, -20 removed lines

@@ -6,27 +6,27 @@
 
 class CustomFileNameGenerator implements \FileUpload\FileNameGenerator\FileNameGenerator
 {
-    protected $generator;
+	protected $generator;
 
-    /**
-     * @param string|callable|Closure $nameGenerator
-     */
-    public function __construct($nameGenerator)
-    {
-        $this->generator = $nameGenerator;
-    }
+	/**
+	 * @param string|callable|Closure $nameGenerator
+	 */
+	public function __construct($nameGenerator)
+	{
+		$this->generator = $nameGenerator;
+	}
 
-    public function getFileName($source_name, $type, $tmp_name, $index, $content_range, FileUpload $upload)
-    {
-        $sourceNameArray = explode(".", $source_name);
-        $ext = $sourceNameArray[count($sourceNameArray) - 1];
-        if (is_string($this->generator) && !is_callable($this->generator)) {
-            return $this->generator.".".$ext;
-        }
+	public function getFileName($source_name, $type, $tmp_name, $index, $content_range, FileUpload $upload)
+	{
+		$sourceNameArray = explode(".", $source_name);
+		$ext = $sourceNameArray[count($sourceNameArray) - 1];
+		if (is_string($this->generator) && !is_callable($this->generator)) {
+			return $this->generator.".".$ext;
+		}
 
-        return call_user_func_array(
-            $this->generator,
-            func_get_args()
-        );
-    }
+		return call_user_func_array(
+			$this->generator,
+			func_get_args()
+		);
+	}
 }

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;
+	}
 }