xpressengine / xe-core

classes/db/queryparts/condition/ConditionGroup.class.php

Spacing +12 added lines, -12 removed lines

@@ -32,14 +32,14 @@ 
 	function __construct($conditions, $pipe = "")
 	{
 		$this->conditions = array();
-		foreach($conditions as $condition)
+		foreach ($conditions as $condition)
 		{
-			if($condition->show())
+			if ($condition->show())
 			{
 				$this->conditions[] = $condition;
 			}
 		}
-		if(count($this->conditions) === 0)
+		if (count($this->conditions) === 0)
 		{
 			$this->_show = false;
 		}
@@ -58,7 +58,7 @@ 
 
 	function setPipe($pipe)
 	{
-		if($this->pipe !== $pipe)
+		if ($this->pipe !== $pipe)
 		{
 			$this->_group = null;
 		}
@@ -72,24 +72,24 @@ 
 	 */
 	function toString($with_value = true)
 	{
-		if(!isset($this->_group))
+		if (!isset($this->_group))
 		{
 			$cond_indx = 0;
 			$group = '';
 
-			foreach($this->conditions as $condition)
+			foreach ($this->conditions as $condition)
 			{
-				if($cond_indx === 0)
+				if ($cond_indx === 0)
 				{
 					$condition->setPipe("");
 				}
-				$group .= $condition->toString($with_value) . ' ';
+				$group .= $condition->toString($with_value).' ';
 				$cond_indx++;
 			}
 
-			if($this->pipe !== "" && trim($group) !== '')
+			if ($this->pipe !== "" && trim($group) !== '')
 			{
-				$group = $this->pipe . ' (' . $group . ')';
+				$group = $this->pipe.' ('.$group.')';
 			}
 
 			$this->_group = $group;
@@ -104,10 +104,10 @@ 
 	function getArguments()
 	{
 		$args = array();
-		foreach($this->conditions as $condition)
+		foreach ($this->conditions as $condition)
 		{
 			$arg = $condition->getArgument();
-			if($arg)
+			if ($arg)
 			{
 				$args[] = $arg;
 			}

Braces +1 added lines, -2 removed lines

@@ -42,8 +42,7 @@
 		if(count($this->conditions) === 0)
 		{
 			$this->_show = false;
-		}
-		else
+		} else
 		{
 			$this->_show = true;
 		}

classes/db/queryparts/Subquery.class.php

Spacing +2 added lines, -2 removed lines

@@ -56,7 +56,7 @@ 
 
 	function isJoinTable()
 	{
-		if($this->join_type)
+		if ($this->join_type)
 		{
 			return true;
 		}
@@ -67,7 +67,7 @@ 
 	{
 		$oDB = &DB::getInstance();
 
-		return '(' . $oDB->getSelectSql($this, $with_values) . ')';
+		return '('.$oDB->getSelectSql($this, $with_values).')';
 	}
 
 	function isSubquery()

classes/db/queryparts/expression/UpdateExpressionWithoutArgument.class.php

Spacing +4 added lines, -4 removed lines

@@ -38,21 +38,21 @@
 	{
 		// TODO Escape value according to column type instead of variable type
 		$value = $this->argument;
-		if(!is_numeric($value))
+		if (!is_numeric($value))
 		{
-			return "'" . $value . "'";
+			return "'".$value."'";
 		}
 		return $value;
 	}
 
 	function show()
 	{
-		if(!$this->argument)
+		if (!$this->argument)
 		{
 			return false;
 		}
 		$value = $this->argument;
-		if(!isset($value))
+		if (!isset($value))
 		{
 			return false;
 		}

classes/db/queryparts/expression/SelectExpression.class.php

Spacing +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
 	 */
 	function getExpression()
 	{
-		return sprintf("%s%s", $this->column_name, $this->column_alias ? " as " . $this->column_alias : "");
+		return sprintf("%s%s", $this->column_name, $this->column_alias ? " as ".$this->column_alias : "");
 	}
 
 	function show()

classes/db/queryparts/expression/InsertExpression.class.php

Spacing +4 added lines, -4 removed lines

@@ -31,7 +31,7 @@ 
 
 	function getValue($with_values = true)
 	{
-		if($with_values)
+		if ($with_values)
 		{
 			return $this->argument->getValue();
 		}
@@ -40,12 +40,12 @@ 
 
 	function show()
 	{
-		if(!$this->argument)
+		if (!$this->argument)
 		{
 			return false;
 		}
 		$value = $this->argument->getValue();
-		if(!isset($value))
+		if (!isset($value))
 		{
 			return false;
 		}
@@ -59,7 +59,7 @@ 
 
 	function getArguments()
 	{
-		if($this->argument)
+		if ($this->argument)
 		{
 			return array($this->argument);
 		}

Braces +1 added lines, -2 removed lines

@@ -62,8 +62,7 @@
 		if($this->argument)
 		{
 			return array($this->argument);
-		}
-		else
+		} else
 		{
 			return array();
 		}

classes/db/queryparts/expression/DeleteExpression.class.php

Spacing +3 added lines, -3 removed lines

@@ -42,16 +42,16 @@
 	function getValue()
 	{
 		// TODO Escape value according to column type instead of variable type
-		if(!is_numeric($this->value))
+		if (!is_numeric($this->value))
 		{
-			return "'" . $this->value . "'";
+			return "'".$this->value."'";
 		}
 		return $this->value;
 	}
 
 	function show()
 	{
-		if(!$this->value)
+		if (!$this->value)
 		{
 			return false;
 		}

classes/db/queryparts/expression/ClickCountExpression.class.php

Spacing +2 added lines, -2 removed lines

@@ -27,7 +27,7 @@ 
 	{
 		parent::__construct($column_name, $alias);
 
-		if(!is_bool($click_count))
+		if (!is_bool($click_count))
 		{
 			// error_log("Click_count value for $column_name was not boolean", 0);
 			$this->click_count = false;
@@ -47,7 +47,7 @@ 
 	function getExpression()
 	{
 		$db_type = Context::getDBType();
-		if($db_type == 'cubrid')
+		if ($db_type == 'cubrid')
 		{
 			return "INCR($this->column_name)";
 		}

Braces +1 added lines, -2 removed lines

@@ -50,8 +50,7 @@
 		if($db_type == 'cubrid')
 		{
 			return "INCR($this->column_name)";
-		}
-		else
+		} else
 		{
 			return "$this->column_name";
 		}

classes/db/queryparts/table/CubridTableWithHint.class.php

Spacing +4 added lines, -4 removed lines

@@ -52,13 +52,13 @@
 		$db_info = Context::getDBInfo();
 		$prefix = $db_info->master_db["db_table_prefix"];
 
-		foreach($this->index_hints_list as $index_hint)
+		foreach ($this->index_hints_list as $index_hint)
 		{
 			$index_hint_type = $index_hint->getIndexHintType();
-			if($index_hint_type !== 'IGNORE')
+			if ($index_hint_type !== 'IGNORE')
 			{
-				$result .= $this->alias . '.'
-						. '"' . $prefix . substr($index_hint->getIndexName(), 1)
+				$result .= $this->alias.'.'
+						. '"'.$prefix.substr($index_hint->getIndexName(), 1)
 						. ($index_hint_type == 'FORCE' ? '(+)' : '')
 						. ', ';
 			}

classes/db/queryparts/table/MssqlTableWithHint.class.php

Spacing +5 added lines, -5 removed lines

@@ -46,17 +46,17 @@
 
 		$index_hint_string = '';
 		$indexTypeList = array('USE' => 1, 'FORCE' => 1);
-		foreach($this->index_hints_list as $index_hint)
+		foreach ($this->index_hints_list as $index_hint)
 		{
 			$index_hint_type = $index_hint->getIndexHintType();
-			if(isset($indexTypeList[$index_hint_type]))
+			if (isset($indexTypeList[$index_hint_type]))
 			{
-				$index_hint_string .= 'INDEX(' . $index_hint->getIndexName() . '), ';
+				$index_hint_string .= 'INDEX('.$index_hint->getIndexName().'), ';
 			}
 		}
-		if($index_hint_string != '')
+		if ($index_hint_string != '')
 		{
-			$result .= ' WITH(' . substr($index_hint_string, 0, -2) . ') ';
+			$result .= ' WITH('.substr($index_hint_string, 0, -2).') ';
 		}
 		return $result;
 	}