Smoren / query-relation-manager-php

src/Pdo/QueryRelationManager.php

Spacing +2 added lines, -2 removed lines

@@ -40,7 +40,7 @@ 
 
         /** @var array<string> $result */
         $result = [];
-        foreach($rows as $row) {
+        foreach ($rows as $row) {
             $result[] = $row['Field'];
         }
 
@@ -59,7 +59,7 @@ 
 
         /** @var array<string> $result */
         $result = [];
-        foreach($rows as $row) {
+        foreach ($rows as $row) {
             $result[] = $row['Field'];
         }
 

src/Pdo/QueryWrapper.php

Spacing +7 added lines, -7 removed lines

@@ -66,7 +66,7 @@ 
         $this->query .= 'SELECT ';
 
         $buf = [];
-        foreach($arSelect as $alias => $field) {
+        foreach ($arSelect as $alias => $field) {
             $buf[] = addslashes($field).' AS '.addslashes($alias);
         }
 
@@ -82,7 +82,7 @@ 
     {
         $this->query .= ' FROM ';
 
-        foreach($mapFrom as $alias => $tableName) {
+        foreach ($mapFrom as $alias => $tableName) {
             $this->query .= ' '.addslashes($tableName).' '.addslashes($alias).' ';
             break;
         }
@@ -101,14 +101,14 @@ 
     ): QueryWrapperInterface {
         $this->query .= " ".addslashes($type)." JOIN ";
 
-        foreach($mapTable as $alias => $tableName) {
+        foreach ($mapTable as $alias => $tableName) {
             $this->query .= addslashes($tableName).' '.addslashes($alias).' ';
             break;
         }
 
         $this->query .= " ON {$condition} ";
 
-        foreach($extraJoinParams as $key => $val) {
+        foreach ($extraJoinParams as $key => $val) {
             $this->mapParams[$key] = $val;
         }
 
@@ -125,13 +125,13 @@ 
     {
         $db = $db ?? static::$pdo;
 
-        if(!$db) {
+        if (!$db) {
             throw new QueryRelationManagerException('no pdo connection opened');
         }
 
         $q = $db->prepare($this->query);
 
-        foreach($this->mapParams as $key => $val) {
+        foreach ($this->mapParams as $key => $val) {
             $q->bindValue($key, $val);
         }
 
@@ -147,7 +147,7 @@ 
     {
         $from = array_keys($this->mapParams);
         $to = array_values($this->mapParams);
-        foreach($to as &$param) {
+        foreach ($to as &$param) {
             $param = "'{$param}'";
         }
         unset($param);

src/Base/Structs/JoinCondition.php

Spacing +1 added lines, -1 removed lines

@@ -92,7 +92,7 @@
     public function stringify(): string
     {
         $joins = [];
-        foreach($this->joinCondition as $linkBy => $linkTo) {
+        foreach ($this->joinCondition as $linkBy => $linkTo) {
             $joins[] = "{$this->table->alias}.{$linkBy} = {$this->joinTo->alias}.{$linkTo}";
         }
 

src/Base/Structs/Table.php

Spacing +11 added lines, -11 removed lines

@@ -83,14 +83,14 @@ 
         $this->containerFieldAlias = $containerFieldAlias;
 
         $bufMap = [];
-        foreach($fields as $field) {
+        foreach ($fields as $field) {
             $bufMap[$field] = "{$this->alias}_{$field}";
             $this->fieldMap["{$this->alias}.{$field}"] = "{$this->alias}_{$field}";
             $this->fieldMapReverse["{$this->alias}_{$field}"] = $field;
         }
 
-        foreach($this->primaryKey as $field) {
-            if(!isset($bufMap[$field])) {
+        foreach ($this->primaryKey as $field) {
+            if (!isset($bufMap[$field])) {
                 throw new QueryRelationManagerException("pk field {$field} not found in field list");
             }
             $this->pkFieldMapReverse[$bufMap[$field]] = $field;
@@ -132,8 +132,8 @@ 
      */
     public function issetDataInRow(array &$row): bool
     {
-        foreach($this->pkFieldMapReverse as $prefixedKey => $key) {
-            if($row[$prefixedKey] !== null) {
+        foreach ($this->pkFieldMapReverse as $prefixedKey => $key) {
+            if ($row[$prefixedKey] !== null) {
                 return true;
             }
         }
@@ -159,13 +159,13 @@ 
     {
         $item = [];
 
-        foreach($this->fieldMapReverse as $fieldPrefixed => $field) {
+        foreach ($this->fieldMapReverse as $fieldPrefixed => $field) {
             $item[$field] = $row[$fieldPrefixed];
         }
 
         /** @var JoinCondition $cond */
-        foreach($conditionCollection->byJoinTo($this->alias) as $cond) {
-            switch($cond->type) {
+        foreach ($conditionCollection->byJoinTo($this->alias) as $cond) {
+            switch ($cond->type) {
                 case JoinCondition::TYPE_MULTIPLE:
                     $item[$cond->table->containerFieldAlias] = [];
                     break;
@@ -179,7 +179,7 @@ 
 
         $primaryKeyValue = $this->stringifyPrimaryKeyValue($row);
 
-        if($conditionCollection->issetByJoinAs($this->alias)) {
+        if ($conditionCollection->issetByJoinAs($this->alias)) {
             $cond = $conditionCollection->byJoinAs($this->alias);
             $joinTo = $cond->joinTo;
             $aliasTo = $joinTo->alias;
@@ -202,7 +202,7 @@ 
     public function getPrimaryKeyForSelect(): array
     {
         $result = [];
-        foreach($this->primaryKey as $field) {
+        foreach ($this->primaryKey as $field) {
             $result[] = "{$this->alias}.{$field}";
         }
 
@@ -229,7 +229,7 @@ 
     {
         $primaryKeyValues = [];
 
-        foreach($this->pkFieldChain as $field) {
+        foreach ($this->pkFieldChain as $field) {
             $primaryKeyValues[] = $row[$field];
         }
 

src/Base/Structs/TableCollection.php

Spacing +9 added lines, -9 removed lines

@@ -32,7 +32,7 @@ 
      */
     public function add(Table $table): self
     {
-        if($this->mainTable === null) {
+        if ($this->mainTable === null) {
             $this->mainTable = $table;
         }
 
@@ -48,7 +48,7 @@ 
      */
     public function getMainTable(): Table
     {
-        if($this->mainTable === null) {
+        if ($this->mainTable === null) {
             throw new QueryRelationManagerException('no main table found in TableManager');
         }
 
@@ -78,10 +78,10 @@ 
         $tableAliasChain = $this->getTableAliasChain($tableAlias, $joinConditions);
         $result = [];
 
-        foreach($tableAliasChain as $alias) {
+        foreach ($tableAliasChain as $alias) {
             $table = $this->byAlias($alias);
 
-            foreach($table->primaryKey as $field) {
+            foreach ($table->primaryKey as $field) {
                 $result[] = "{$alias}_{$field}";
             }
         }
@@ -99,10 +99,10 @@ 
     {
         $result = [];
 
-        while(true) {
+        while (true) {
             $result[] = $tableAlias;
 
-            if(!$joinConditions->issetByJoinAs($tableAlias)) {
+            if (!$joinConditions->issetByJoinAs($tableAlias)) {
                 break;
             }
 
@@ -118,7 +118,7 @@ 
      */
     public function getIterator(): iterable
     {
-        foreach($this->mapByAlias as $table) {
+        foreach ($this->mapByAlias as $table) {
             yield $table;
         }
     }
@@ -141,7 +141,7 @@ 
      */
     protected function addToMap(string $mapName, string $key, Table $table): self
     {
-        if(isset($this->{$mapName}[$table->{$key}])) {
+        if (isset($this->{$mapName}[$table->{$key}])) {
             throw new QueryRelationManagerException("duplicate key '{$key}' in map '{$mapName}' of TableManager");
         }
         $this->{$mapName}[$table->{$key}] = $table;
@@ -158,7 +158,7 @@ 
      */
     protected function getFromMap(string $mapName, string $key): Table
     {
-        if(!isset($this->{$mapName}[$key])) {
+        if (!isset($this->{$mapName}[$key])) {
             throw new QueryRelationManagerException("key '{$key}' not found in map '{$mapName}' of TableManager");
         }
 

src/Base/Structs/JoinConditionCollection.php

Spacing +6 added lines, -6 removed lines

@@ -33,15 +33,15 @@ 
      */
     public function add(JoinCondition $condition): self
     {
-        if(isset($this->mapByJoinAs[$condition->table->alias])) {
+        if (isset($this->mapByJoinAs[$condition->table->alias])) {
             throw new QueryRelationManagerException("duplicate table alias '{$condition->table->alias}'");
         }
         $this->mapByJoinAs[$condition->table->alias] = $condition;
 
-        if(!isset($this->matrixByJoinTo[$condition->joinTo->alias])) {
+        if (!isset($this->matrixByJoinTo[$condition->joinTo->alias])) {
             $this->matrixByJoinTo[$condition->joinTo->alias] = [];
         }
-        if(isset($this->matrixByJoinTo[$condition->joinTo->alias][$condition->table->alias])) {
+        if (isset($this->matrixByJoinTo[$condition->joinTo->alias][$condition->table->alias])) {
             throw new QueryRelationManagerException("duplicate table alias '{$condition->table->alias}'");
         }
         $this->matrixByJoinTo[$condition->joinTo->alias][$condition->table->alias] = $condition;
@@ -56,7 +56,7 @@ 
      */
     public function issetByJoinAs(string $joinAs): bool
     {
-        if(!isset($this->mapByJoinAs[$joinAs])) {
+        if (!isset($this->mapByJoinAs[$joinAs])) {
             return false;
         }
 
@@ -81,7 +81,7 @@ 
      */
     public function byJoinTo(string $joinTo): array
     {
-        if(!isset($this->matrixByJoinTo[$joinTo])) {
+        if (!isset($this->matrixByJoinTo[$joinTo])) {
             return [];
         }
         return $this->matrixByJoinTo[$joinTo];
@@ -93,7 +93,7 @@ 
      */
     public function getIterator(): iterable
     {
-        foreach($this->mapByJoinAs as $condition) {
+        foreach ($this->mapByJoinAs as $condition) {
             yield $condition;
         }
     }

src/Base/QueryRelationManagerBase.php

Spacing +16 added lines, -16 removed lines

@@ -184,38 +184,38 @@ 
         $rows = $this->query->all($db);
 
         $map = [];
-        foreach($this->tableCollection as $table) {
+        foreach ($this->tableCollection as $table) {
             $map[$table->alias] = [];
         }
 
         $bufMap = [];
 
-        foreach($rows as $row) {
-            foreach($this->tableCollection as $table) {
-                if(!$table->issetDataInRow($row)) {
+        foreach ($rows as $row) {
+            foreach ($this->tableCollection as $table) {
+                if (!$table->issetDataInRow($row)) {
                     continue;
                 }
 
                 [$item, $pkValue, $alias, $aliasTo, $fkValue, $containerFieldAlias, $type]
                     = $table->getDataFromRow($row, $this->joinConditionCollection);
 
-                if(!isset($map[$alias][$pkValue])) {
+                if (!isset($map[$alias][$pkValue])) {
                     $map[$alias][$pkValue] = &$item;
                 }
 
-                if($aliasTo !== null) {
+                if ($aliasTo !== null) {
                     $bufMapKey = implode('-', [$aliasTo, $fkValue, $containerFieldAlias, $pkValue]);
                     /** @var string $type */
-                    switch($type) {
+                    switch ($type) {
                         case JoinCondition::TYPE_SINGLE:
-                            if(!isset($bufMap[$bufMapKey])) {
+                            if (!isset($bufMap[$bufMapKey])) {
                                 /** @var mixed[][][] $map */
                                 $map[$aliasTo][$fkValue][$containerFieldAlias] = &$item;
                                 $bufMap[$bufMapKey] = 1;
                             }
                             break;
                         case JoinCondition::TYPE_MULTIPLE:
-                            if(!isset($bufMap[$bufMapKey])) {
+                            if (!isset($bufMap[$bufMapKey])) {
                                 /** @var mixed[][][][] $map */
                                 $map[$aliasTo][$fkValue][$containerFieldAlias][] = &$item;
                                 $bufMap[$bufMapKey] = 1;
@@ -229,8 +229,8 @@ 
             }
         }
 
-        foreach($this->modifierMap as $alias => $modifier) {
-            foreach($map[$alias] as $pk => &$item) {
+        foreach ($this->modifierMap as $alias => $modifier) {
+            foreach ($map[$alias] as $pk => &$item) {
                 ($modifier)($item);
             }
             unset($item);
@@ -246,7 +246,7 @@ 
      */
     public function prepare(): QueryWrapperInterface
     {
-        foreach($this->tableCollection as $table) {
+        foreach ($this->tableCollection as $table) {
             $table->setPkFieldChain(
                 $this->tableCollection->getPkFieldChain($table->alias, $this->joinConditionCollection)
             );
@@ -255,8 +255,8 @@ 
         $this->query = $this->createQuery();
 
         $arSelect = [];
-        foreach($this->tableCollection as $table) {
-            foreach($table->getFieldMap() as $fieldName => $fieldNamePrefixed) {
+        foreach ($this->tableCollection as $table) {
+            foreach ($table->getFieldMap() as $fieldName => $fieldNamePrefixed) {
                 $arSelect[$fieldNamePrefixed] = $fieldName;
             }
         }
@@ -267,7 +267,7 @@ 
             ->select($arSelect)
             ->from([$mainTable->alias => $mainTable->name]);
 
-        foreach($this->joinConditionCollection as $cond) {
+        foreach ($this->joinConditionCollection as $cond) {
             $this->query->join(
                 $cond->joinType,
                 [$cond->table->alias => $cond->table->name],
@@ -276,7 +276,7 @@ 
             );
         }
 
-        foreach($this->filters as $modifier) {
+        foreach ($this->filters as $modifier) {
             $modifier($this->query->getQuery());
         }