@@ -25,12 +25,12 @@ discard block |
||
| 25 | 25 | $i = 0; |
| 26 | 26 | |
| 27 | 27 | if ($data[0]->REFERENCED_TABLE_NAME !== null) { |
| 28 | - $arraySize = count($data); |
|
| 28 | + $arraySize = count($data); |
|
| 29 | 29 | |
| 30 | - foreach($data as $key => $value) { |
|
| 30 | + foreach ($data as $key => $value) { |
|
| 31 | 31 | $output .= ' JOIN '.$value->REFERENCED_TABLE_NAME; |
| 32 | 32 | } |
| 33 | - foreach($data as $key => $value) { |
|
| 33 | + foreach ($data as $key => $value) { |
|
| 34 | 34 | $i++; |
| 35 | 35 | $whereAnd = $i > 1 ? 'AND' : 'WHERE'; |
| 36 | 36 | $output .= ' '.$whereAnd.' '.self::getTableName($connection).'.'.$value->COLUMN_NAME.'='.$value->REFERENCED_TABLE_NAME.'.'.$value->REFERENCED_COLUMN_NAME.' '; |
@@ -50,10 +50,10 @@ discard block |
||
| 50 | 50 | |
| 51 | 51 | $query = 'SELECT * FROM '.$tableName; |
| 52 | 52 | |
| 53 | - if (! $joinClause) { |
|
| 53 | + if ( ! $joinClause) { |
|
| 54 | 54 | $query .= ' WHERE '.$columnName; |
| 55 | 55 | } else { |
| 56 | - $query .= ($data === null) ? $joinClause : $joinClause .' AND '.$columnName; |
|
| 56 | + $query .= ($data === null) ? $joinClause : $joinClause.' AND '.$columnName; |
|
| 57 | 57 | } |
| 58 | 58 | return $query; |
| 59 | 59 | } |