Completed
Pull Request — master (#26)
by Adeniyi
03:18
created
src/Interface/RelationshipsInterface.php 1 patch
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -11,7 +11,7 @@
 block discarded – undo
11 11
 
12 12
 interface RelationshipsInterface
13 13
 {
14
-	public function joinClause();
14
+    public function joinClause();
15 15
 
16 16
     public function whereClause($data, $condition);
17 17
 }
18 18
\ No newline at end of file
Please login to merge, or discard this patch.
src/Database/DatabaseQuery.php 1 patch
Braces   +7 added lines, -6 removed lines patch added patch discarded remove patch
@@ -216,8 +216,9 @@  discard block
 block discarded – undo
216 216
         {
217 217
             $counter++;
218 218
             $insertQuery .= self::sanitize($key);
219
-            if($arraySize > $counter)
220
-                $insertQuery .= ", ";
219
+            if($arraySize > $counter) {
220
+                            $insertQuery .= ", ";
221
+            }
221 222
         }
222 223
 
223 224
         return $insertQuery;
@@ -241,8 +242,9 @@  discard block
 block discarded – undo
241 242
         {
242 243
             $counter++;
243 244
             $insertQuery .= "'".self::sanitize($value) ."'";
244
-            if($arraySize > $counter)
245
-                $insertQuery .= ", ";
245
+            if($arraySize > $counter) {
246
+                            $insertQuery .= ", ";
247
+            }
246 248
         }
247 249
         return $insertQuery;
248 250
     }
@@ -326,8 +328,7 @@  discard block
 block discarded – undo
326 328
             if($arraySize > 1 && $condition == NULL)
327 329
             {
328 330
                 $query = "Please Supply the condition";
329
-            }
330
-            else
331
+            } else
331 332
             {
332 333
                 $columnName = self::whereAndClause($tableName, $data, $condition);
333 334
                 $query =  "SELECT $fields FROM $tableName WHERE $columnName";
Please login to merge, or discard this patch.
src/Helper/Relationships.php 1 patch
Indentation   +21 added lines, -21 removed lines patch added patch discarded remove patch
@@ -25,36 +25,36 @@
 block discarded – undo
25 25
         $i = 0;
26 26
 
27 27
         if ($data[0]->REFERENCED_TABLE_NAME !== null) {
28
-			$arraySize  = count($data);
29
-
30
-	        foreach($data as $key => $value) {
31
-	        	$output .= ' JOIN '.$value->REFERENCED_TABLE_NAME;
32
-	        }
33
-	        foreach($data as $key => $value) {
34
-	        	$i++;
35
-	        	$whereAnd = $i > 1 ? 'AND' : 'WHERE';
36
-	        	$output .= ' '.$whereAnd.' '.self::getTableName($connection).'.'.$value->COLUMN_NAME.'='.$value->REFERENCED_TABLE_NAME.'.'.$value->REFERENCED_COLUMN_NAME.' ';
37
-	        }
38
-	     } else {
39
-	     	$output = false;
40
-	     }
28
+            $arraySize  = count($data);
29
+
30
+            foreach($data as $key => $value) {
31
+                $output .= ' JOIN '.$value->REFERENCED_TABLE_NAME;
32
+            }
33
+            foreach($data as $key => $value) {
34
+                $i++;
35
+                $whereAnd = $i > 1 ? 'AND' : 'WHERE';
36
+                $output .= ' '.$whereAnd.' '.self::getTableName($connection).'.'.$value->COLUMN_NAME.'='.$value->REFERENCED_TABLE_NAME.'.'.$value->REFERENCED_COLUMN_NAME.' ';
37
+            }
38
+            } else {
39
+                $output = false;
40
+            }
41 41
         return $output;
42 42
     }
43 43
 
44 44
     public function whereClause($data = null, $condition = null, $con = null)
45 45
     {
46
-    	$joinClause = self::joinClause();
46
+        $joinClause = self::joinClause();
47 47
         $connection = self::checkConnection($con);
48 48
         $tableName  = self::getTableName($connection);
49 49
         $columnName = self::whereAndClause($tableName, $data, $condition);
50 50
 
51
-    	$query = 'SELECT * FROM '.$tableName;
51
+        $query = 'SELECT * FROM '.$tableName;
52 52
 
53
-    	if (! $joinClause) {
54
-    		$query .= ' WHERE '.$columnName;
55
-    	} else {
56
-    		$query .= ($data === null) ? $joinClause : $joinClause .' AND '.$columnName;
57
-    	}
58
-    	return $query;
53
+        if (! $joinClause) {
54
+            $query .= ' WHERE '.$columnName;
55
+        } else {
56
+            $query .= ($data === null) ? $joinClause : $joinClause .' AND '.$columnName;
57
+        }
58
+        return $query;
59 59
     }
60 60
 }
61 61
\ No newline at end of file
Please login to merge, or discard this patch.