Passed
Push — master ( 8f5295...39bb9c )
by Tom
02:11
created
Maphper/Lib/Sql/WhereBuilder.php 3 patches
Indentation   +62 added lines, -62 removed lines patch added patch discarded remove patch
@@ -2,87 +2,87 @@
 block discarded – undo
2 2
 namespace Maphper\Lib\Sql;
3 3
 
4 4
 class WhereBuilder {
5
-    private $conditionals = [];
6
-
7
-    public function __construct() {
8
-        $defaultConditionals = [
9
-            'Maphper\Lib\Sql\Between',
10
-            'Maphper\Lib\Sql\In',
11
-            'Maphper\Lib\Sql\NullConditional',
12
-            'Maphper\Lib\Sql\Like',
13
-            'Maphper\Lib\Sql\GeneralOperator'
14
-        ];
15
-
16
-        foreach ($defaultConditionals as $conditional) $this->addConditional(new $conditional);
17
-    }
5
+	private $conditionals = [];
6
+
7
+	public function __construct() {
8
+		$defaultConditionals = [
9
+			'Maphper\Lib\Sql\Between',
10
+			'Maphper\Lib\Sql\In',
11
+			'Maphper\Lib\Sql\NullConditional',
12
+			'Maphper\Lib\Sql\Like',
13
+			'Maphper\Lib\Sql\GeneralOperator'
14
+		];
15
+
16
+		foreach ($defaultConditionals as $conditional) $this->addConditional(new $conditional);
17
+	}
18 18
 
19
-    public function addConditional(WhereConditional $conditional) {
20
-        $this->conditionals[] = $conditional;
21
-    }
19
+	public function addConditional(WhereConditional $conditional) {
20
+		$this->conditionals[] = $conditional;
21
+	}
22 22
 
23 23
 	public function createSql($fields, $mode = \Maphper\Maphper::FIND_EXACT | \Maphper\Maphper::FIND_AND) {
24 24
 		$args = [];
25 25
 		$sql = [];
26 26
 
27
-        foreach ($fields as $key => $value) {
28
-            $value = $this->convertDates($value);
27
+		foreach ($fields as $key => $value) {
28
+			$value = $this->convertDates($value);
29 29
 
30
-            if (is_object($value)) continue;
30
+			if (is_object($value)) continue;
31 31
 			$result = $this->getResult($key, $value, $mode);
32
-            $result = $this->fixDuplicateArgs($args, $result);
33
-            $sql = array_merge($sql, (array)$result['sql']);
34
-            $args = array_merge($args, $result['args']);
35
-        }
32
+			$result = $this->fixDuplicateArgs($args, $result);
33
+			$sql = array_merge($sql, (array)$result['sql']);
34
+			$args = array_merge($args, $result['args']);
35
+		}
36 36
 
37 37
 		return ['args' => $args, 'sql' => $this->sqlArrayToString($sql, $mode)];
38 38
 	}
39 39
 
40
-    // Returns result with duplicate issues removed
41
-    private function fixDuplicateArgs($origArgs, $result) {
42
-        $duplicates = array_intersect_key($result['args'], $origArgs); // Holds all keys in results already in the args
43
-        if (count($duplicates) === 0) return $result;
40
+	// Returns result with duplicate issues removed
41
+	private function fixDuplicateArgs($origArgs, $result) {
42
+		$duplicates = array_intersect_key($result['args'], $origArgs); // Holds all keys in results already in the args
43
+		if (count($duplicates) === 0) return $result;
44 44
 
45
-        foreach ($duplicates as $argKey => $argVal) {
46
-            $valHash = substr(md5($argVal), 0, 5);
47
-            $newKey = $argKey . $valHash;
45
+		foreach ($duplicates as $argKey => $argVal) {
46
+			$valHash = substr(md5($argVal), 0, 5);
47
+			$newKey = $argKey . $valHash;
48 48
 
49
-            // Replace occurences of duplicate key with key + hash as arg
50
-            $result['sql'] = str_replace(':' . $argKey, ':' . $newKey, $result['sql']);
51
-            unset($result['args'][$argKey]);
52
-            $result['args'][$newKey] = $argVal;
53
-        }
49
+			// Replace occurences of duplicate key with key + hash as arg
50
+			$result['sql'] = str_replace(':' . $argKey, ':' . $newKey, $result['sql']);
51
+			unset($result['args'][$argKey]);
52
+			$result['args'][$newKey] = $argVal;
53
+		}
54 54
 
55
-        return $result;
56
-    }
55
+		return $result;
56
+	}
57 57
 
58
-    /*
58
+	/*
59 59
      * Either get sql from a conditional or call createSql again because the mode needs to be changed
60 60
      */
61
-    private function getResult($key, $value, $mode) {
62
-        if (is_numeric($key) && is_array($value)) return $this->createSql($value, $key);
63
-        return $this->getConditional($key, $value, $mode);
64
-    }
61
+	private function getResult($key, $value, $mode) {
62
+		if (is_numeric($key) && is_array($value)) return $this->createSql($value, $key);
63
+		return $this->getConditional($key, $value, $mode);
64
+	}
65 65
 
66
-    private function sqlArrayToString($sql, $mode) {
67
-        if (\Maphper\Maphper::FIND_OR & $mode) $query = implode(' OR  ', $sql);
66
+	private function sqlArrayToString($sql, $mode) {
67
+		if (\Maphper\Maphper::FIND_OR & $mode) $query = implode(' OR  ', $sql);
68 68
 		else $query = implode(' AND ', $sql);
69 69
 		if (!empty($query)) $query = '(' . $query . ')';
70
-        return $query;
71
-    }
72
-
73
-    private function getConditional($key, $value, $mode) {
74
-        foreach ($this->conditionals as $conditional) {
75
-            if ($conditional->matches($key, $value, $mode))
76
-                return $conditional->getSql($key, $value, $mode);
77
-        }
78
-        throw new \Exception("Invalid WHERE query");
79
-    }
80
-
81
-    private function convertDates($value) {
82
-        if ($value instanceof \DateTimeInterface) {
83
-            if ($value->format('H:i:s')  == '00:00:00') $value = $value->format('Y-m-d');
84
-            else $value = $value->format('Y-m-d H:i:s');
85
-        }
86
-        return $value;
87
-    }
70
+		return $query;
71
+	}
72
+
73
+	private function getConditional($key, $value, $mode) {
74
+		foreach ($this->conditionals as $conditional) {
75
+			if ($conditional->matches($key, $value, $mode))
76
+				return $conditional->getSql($key, $value, $mode);
77
+		}
78
+		throw new \Exception("Invalid WHERE query");
79
+	}
80
+
81
+	private function convertDates($value) {
82
+		if ($value instanceof \DateTimeInterface) {
83
+			if ($value->format('H:i:s')  == '00:00:00') $value = $value->format('Y-m-d');
84
+			else $value = $value->format('Y-m-d H:i:s');
85
+		}
86
+		return $value;
87
+	}
88 88
 }
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -80,7 +80,7 @@
 block discarded – undo
80 80
 
81 81
     private function convertDates($value) {
82 82
         if ($value instanceof \DateTimeInterface) {
83
-            if ($value->format('H:i:s')  == '00:00:00') $value = $value->format('Y-m-d');
83
+            if ($value->format('H:i:s') == '00:00:00') $value = $value->format('Y-m-d');
84 84
             else $value = $value->format('Y-m-d H:i:s');
85 85
         }
86 86
         return $value;
Please login to merge, or discard this patch.
Braces   +28 added lines, -11 removed lines patch added patch discarded remove patch
@@ -13,7 +13,9 @@  discard block
 block discarded – undo
13 13
             'Maphper\Lib\Sql\GeneralOperator'
14 14
         ];
15 15
 
16
-        foreach ($defaultConditionals as $conditional) $this->addConditional(new $conditional);
16
+        foreach ($defaultConditionals as $conditional) {
17
+        	$this->addConditional(new $conditional);
18
+        }
17 19
     }
18 20
 
19 21
     public function addConditional(WhereConditional $conditional) {
@@ -27,7 +29,9 @@  discard block
 block discarded – undo
27 29
         foreach ($fields as $key => $value) {
28 30
             $value = $this->convertDates($value);
29 31
 
30
-            if (is_object($value)) continue;
32
+            if (is_object($value)) {
33
+            	continue;
34
+            }
31 35
 			$result = $this->getResult($key, $value, $mode);
32 36
             $result = $this->fixDuplicateArgs($args, $result);
33 37
             $sql = array_merge($sql, (array)$result['sql']);
@@ -40,7 +44,9 @@  discard block
 block discarded – undo
40 44
     // Returns result with duplicate issues removed
41 45
     private function fixDuplicateArgs($origArgs, $result) {
42 46
         $duplicates = array_intersect_key($result['args'], $origArgs); // Holds all keys in results already in the args
43
-        if (count($duplicates) === 0) return $result;
47
+        if (count($duplicates) === 0) {
48
+        	return $result;
49
+        }
44 50
 
45 51
         foreach ($duplicates as $argKey => $argVal) {
46 52
             $valHash = substr(md5($argVal), 0, 5);
@@ -59,29 +65,40 @@  discard block
 block discarded – undo
59 65
      * Either get sql from a conditional or call createSql again because the mode needs to be changed
60 66
      */
61 67
     private function getResult($key, $value, $mode) {
62
-        if (is_numeric($key) && is_array($value)) return $this->createSql($value, $key);
68
+        if (is_numeric($key) && is_array($value)) {
69
+        	return $this->createSql($value, $key);
70
+        }
63 71
         return $this->getConditional($key, $value, $mode);
64 72
     }
65 73
 
66 74
     private function sqlArrayToString($sql, $mode) {
67
-        if (\Maphper\Maphper::FIND_OR & $mode) $query = implode(' OR  ', $sql);
68
-		else $query = implode(' AND ', $sql);
69
-		if (!empty($query)) $query = '(' . $query . ')';
75
+        if (\Maphper\Maphper::FIND_OR & $mode) {
76
+        	$query = implode(' OR  ', $sql);
77
+        } else {
78
+			$query = implode(' AND ', $sql);
79
+		}
80
+		if (!empty($query)) {
81
+			$query = '(' . $query . ')';
82
+		}
70 83
         return $query;
71 84
     }
72 85
 
73 86
     private function getConditional($key, $value, $mode) {
74 87
         foreach ($this->conditionals as $conditional) {
75
-            if ($conditional->matches($key, $value, $mode))
76
-                return $conditional->getSql($key, $value, $mode);
88
+            if ($conditional->matches($key, $value, $mode)) {
89
+                            return $conditional->getSql($key, $value, $mode);
90
+            }
77 91
         }
78 92
         throw new \Exception("Invalid WHERE query");
79 93
     }
80 94
 
81 95
     private function convertDates($value) {
82 96
         if ($value instanceof \DateTimeInterface) {
83
-            if ($value->format('H:i:s')  == '00:00:00') $value = $value->format('Y-m-d');
84
-            else $value = $value->format('Y-m-d H:i:s');
97
+            if ($value->format('H:i:s')  == '00:00:00') {
98
+            	$value = $value->format('Y-m-d');
99
+            } else {
100
+            	$value = $value->format('Y-m-d H:i:s');
101
+            }
85 102
         }
86 103
         return $value;
87 104
     }
Please login to merge, or discard this patch.
Maphper/Optimiser/MySql.php 2 patches
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
 		return;
97 97
 
98 98
 		$runAgain = false;
99
-		$columns = $this->pdo->query('SELECT * FROM '. $this->quote($table) . ' PROCEDURE ANALYSE(1,1)')->fetchAll(\PDO::FETCH_OBJ);
99
+		$columns = $this->pdo->query('SELECT * FROM ' . $this->quote($table) . ' PROCEDURE ANALYSE(1,1)')->fetchAll(\PDO::FETCH_OBJ);
100 100
 		foreach ($columns as $column) {
101 101
 			$parts = explode('.', $column->Field_name);
102 102
 			$name = $this->quote(end($parts));
@@ -130,7 +130,7 @@  discard block
 block discarded – undo
130 130
 					}
131 131
 				}
132 132
 
133
-				$this->pdo->query('ALTER TABLE ' . $this->quote($table) . ' MODIFY '. $name . ' ' . $type);
133
+				$this->pdo->query('ALTER TABLE ' . $this->quote($table) . ' MODIFY ' . $name . ' ' . $type);
134 134
 			}
135 135
 		}
136 136
 		//Sometimes a second pass is needed, if a column has gone from varchar -> int(11) a better int type may be needed
Please login to merge, or discard this patch.
Braces   +13 added lines, -7 removed lines patch added patch discarded remove patch
@@ -11,16 +11,21 @@  discard block
 block discarded – undo
11 11
 		foreach ($columns as $column) {
12 12
 			$parts = explode('.', $column->Field_name);
13 13
 			$name = $this->quote(end($parts));
14
-			if ($column->Min_value === null && $column->Max_value === null) $this->pdo->query('ALTER TABLE ' . $this->quote($table) . ' DROP COLUMN ' . $name);
15
-			else {
14
+			if ($column->Min_value === null && $column->Max_value === null) {
15
+				$this->pdo->query('ALTER TABLE ' . $this->quote($table) . ' DROP COLUMN ' . $name);
16
+			} else {
16 17
 				$type = $column->Optimal_fieldtype;
17 18
 				if ($column->Max_length < 11) {
18 19
 					//Check for dates
19 20
 					$count = $this->pdo->query('SELECT count(*) as `count` FROM ' . $this->quote($table) . ' WHERE STR_TO_DATE(' . $name . ',\'%Y-%m-%d %H:%i:s\') IS NULL OR STR_TO_DATE(' . $name . ',\'%Y-%m-%d %H:%i:s\') != ' . $name . ' LIMIT 1')->fetch(\PDO::FETCH_OBJ)->count;
20
-					if ($count == 0) $type = 'DATETIME';
21
+					if ($count == 0) {
22
+						$type = 'DATETIME';
23
+					}
21 24
 
22 25
 					$count = $this->pdo->query('SELECT count(*) as `count` FROM ' . $this->quote($table) . ' WHERE STR_TO_DATE(' . $name . ',\'%Y-%m-%d\') IS NULL OR STR_TO_DATE(' . $name . ',\'%Y-%m-%d\') != ' . $name . ' LIMIT 1')->fetch(\PDO::FETCH_OBJ)->count;
23
-					if ($count == 0) $type = 'DATE';
26
+					if ($count == 0) {
27
+						$type = 'DATE';
28
+					}
24 29
 				}
25 30
 
26 31
 				//If it's text, work out if it would be better to be something else
@@ -30,8 +35,7 @@  discard block
 block discarded – undo
30 35
 					if ($count == 0) {
31 36
 						$type = 'INT(11)';
32 37
 						$runAgain = true;
33
-					}
34
-					else {
38
+					} else {
35 39
 						//See if it's decimal
36 40
 						$count = $this->pdo->query('SELECT count(*) FROM ' . $table . ' WHERE concat(\'\', ' . $name . ' * 1) != ' . $name . ')')->fetch(\PDO::FETCH_OBJ)->count;
37 41
 						if ($count == 0) {
@@ -45,6 +49,8 @@  discard block
 block discarded – undo
45 49
 			}
46 50
 		}
47 51
 		//Sometimes a second pass is needed, if a column has gone from varchar -> int(11) a better int type may be needed
48
-		if ($runAgain) $this->optimiseColumns($table);
52
+		if ($runAgain) {
53
+			$this->optimiseColumns($table);
54
+		}
49 55
 	}
50 56
 }
51 57
\ No newline at end of file
Please login to merge, or discard this patch.
Maphper/Relation/One.php 2 patches
Indentation   +9 added lines, -9 removed lines patch added patch discarded remove patch
@@ -9,7 +9,7 @@  discard block
 block discarded – undo
9 9
 	private $siblings = [];
10 10
 
11 11
 	public function __construct(\Maphper\Maphper $mapper, $parentField, $localField, array $criteria = []) {
12
-        if ($criteria) $mapper = $mapper->filter($this->criteira);
12
+		if ($criteria) $mapper = $mapper->filter($this->criteira);
13 13
 		$this->mapper = $mapper;
14 14
 		$this->parentField = $parentField;
15 15
 		$this->localField = $localField;
@@ -48,17 +48,17 @@  discard block
 block discarded – undo
48 48
 		//Fetch the results so they're in the cache for the corresponding maphper object
49 49
 		$results = $this->mapper->filter([$this->localField => $recordsToLoad]);
50 50
 
51
-        $this->loadDataIntoSiblings($results);
51
+		$this->loadDataIntoSiblings($results);
52 52
 	}
53 53
 
54
-    private function loadDataIntoSiblings($results) {
55
-        $cache = [];
54
+	private function loadDataIntoSiblings($results) {
55
+		$cache = [];
56 56
 		foreach ($results as $result) {
57 57
 			$cache[$result->{$this->localField}] = $result;
58 58
 		}
59 59
 
60 60
 		foreach ($this->siblings as $sibling) {
61
-            if (isset($cache[$sibling->parentObject->{$this->parentField}])) $sibling->data = $cache[$sibling->parentObject->{$this->parentField}];
61
+			if (isset($cache[$sibling->parentObject->{$this->parentField}])) $sibling->data = $cache[$sibling->parentObject->{$this->parentField}];
62 62
 		}
63 63
 		/*
64 64
 		foreach ($this->siblings as $sibling) {
@@ -66,7 +66,7 @@  discard block
 block discarded – undo
66 66
 			else $sibling->data = $sibling->mapper->filter([$sibling->localField => $sibling->parentObject->{$this->parentField}])->item(0);
67 67
 		}
68 68
 		*/
69
-    }
69
+	}
70 70
 
71 71
 	public function __call($func, array $args = []) {
72 72
 		if ($this->lazyLoad() == null) return '';
@@ -75,7 +75,7 @@  discard block
 block discarded – undo
75 75
 
76 76
 	public function __get($name) {
77 77
 		if ($this->lazyLoad()) return $this->lazyLoad()->$name;
78
-        else return null;
78
+		else return null;
79 79
 	}
80 80
 
81 81
 	public function __isset($name) {
@@ -83,9 +83,9 @@  discard block
 block discarded – undo
83 83
 	}
84 84
 
85 85
 	public function overwrite($parentObject, &$data) {
86
-        $this->mapper[] = $data;
86
+		$this->mapper[] = $data;
87 87
 
88
-        if (!isset($parentObject->{$this->parentField}) || $parentObject->{$this->parentField} != $data->{$this->localField}) {
88
+		if (!isset($parentObject->{$this->parentField}) || $parentObject->{$this->parentField} != $data->{$this->localField}) {
89 89
 			$parentObject->{$this->parentField} = $data->{$this->localField};
90 90
 			//Trigger an update of the parent object
91 91
 			return true;
Please login to merge, or discard this patch.
Braces   +20 added lines, -7 removed lines patch added patch discarded remove patch
@@ -9,7 +9,9 @@  discard block
 block discarded – undo
9 9
 	private $siblings = [];
10 10
 
11 11
 	public function __construct(\Maphper\Maphper $mapper, $parentField, $localField, array $criteria = []) {
12
-        if ($criteria) $mapper = $mapper->filter($this->criteira);
12
+        if ($criteria) {
13
+        	$mapper = $mapper->filter($this->criteira);
14
+        }
13 15
 		$this->mapper = $mapper;
14 16
 		$this->parentField = $parentField;
15 17
 		$this->localField = $localField;
@@ -29,7 +31,9 @@  discard block
 block discarded – undo
29 31
 	private function lazyLoad() {
30 32
 		if (!isset($this->data)) {
31 33
 
32
-			if ($this->parentObject == null) throw new \Exception('Error, no object set');
34
+			if ($this->parentObject == null) {
35
+				throw new \Exception('Error, no object set');
36
+			}
33 37
 
34 38
 			$this->eagerLoad();
35 39
 
@@ -41,8 +45,10 @@  discard block
 block discarded – undo
41 45
 		$recordsToLoad = [];
42 46
 		//Get a list of records by FK to eager load
43 47
 		foreach ($this->siblings as $sibling) {
44
-			if ($sibling->parentField === $this->parentField) // Ensure that it is only loading records from the same type of relation
48
+			if ($sibling->parentField === $this->parentField) {
49
+				// Ensure that it is only loading records from the same type of relation
45 50
 				$recordsToLoad[] = $sibling->parentObject->{$sibling->parentField};
51
+			}
46 52
 		}
47 53
 
48 54
 		$recordsToLoad = array_unique($recordsToLoad);
@@ -59,7 +65,9 @@  discard block
 block discarded – undo
59 65
 		}
60 66
 
61 67
 		foreach ($this->siblings as $sibling) {
62
-            if (isset($cache[$sibling->parentObject->{$this->parentField}])) $sibling->data = $cache[$sibling->parentObject->{$this->parentField}];
68
+            if (isset($cache[$sibling->parentObject->{$this->parentField}])) {
69
+            	$sibling->data = $cache[$sibling->parentObject->{$this->parentField}];
70
+            }
63 71
 		}
64 72
 		/*
65 73
 		foreach ($this->siblings as $sibling) {
@@ -70,13 +78,18 @@  discard block
 block discarded – undo
70 78
     }
71 79
 
72 80
 	public function __call($func, array $args = []) {
73
-		if ($this->lazyLoad() == null) return '';
81
+		if ($this->lazyLoad() == null) {
82
+			return '';
83
+		}
74 84
 		return call_user_func_array([$this->lazyLoad(), $func], $args);
75 85
 	}
76 86
 
77 87
 	public function __get($name) {
78
-		if ($this->lazyLoad()) return $this->lazyLoad()->$name;
79
-        else return null;
88
+		if ($this->lazyLoad()) {
89
+			return $this->lazyLoad()->$name;
90
+		} else {
91
+        	return null;
92
+        }
80 93
 	}
81 94
 
82 95
 	public function __isset($name) {
Please login to merge, or discard this patch.
Maphper/Relation/ManyManyIterator.php 2 patches
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -7,17 +7,17 @@
 block discarded – undo
7 7
   private $intermediateName;
8 8
 
9 9
   public function __construct(\Maphper\Iterator $iterator, $intermediateName = null) {
10
-    $this->iterator = $iterator;
11
-    $this->intermediateName = $intermediateName;
10
+	$this->iterator = $iterator;
11
+	$this->intermediateName = $intermediateName;
12 12
   }
13 13
 
14 14
   public function current() {
15
-    if ($this->intermediateName) return $this->iterator->current()->{$this->intermediateName};
15
+	if ($this->intermediateName) return $this->iterator->current()->{$this->intermediateName};
16 16
 		return $this->iterator->current();
17 17
 	}
18 18
 
19 19
 	public function key() {
20
-    return $this->iterator->key();
20
+	return $this->iterator->key();
21 21
 	}
22 22
 
23 23
 	public function next() {
Please login to merge, or discard this patch.
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -12,7 +12,9 @@
 block discarded – undo
12 12
   }
13 13
 
14 14
   public function current() {
15
-    if ($this->intermediateName) return $this->iterator->current()->{$this->intermediateName};
15
+    if ($this->intermediateName) {
16
+    	return $this->iterator->current()->{$this->intermediateName};
17
+    }
16 18
 		return $this->iterator->current();
17 19
 	}
18 20
 
Please login to merge, or discard this patch.
Maphper/Relation/ManyMany.php 3 patches
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -37,7 +37,7 @@  discard block
 block discarded – undo
37 37
 	//bit hacky, breaking encapsulation, but simplest way to work out the info for the other side of the many:many relationship.
38 38
 	private function getOtherFieldNameInfo() {
39 39
 		if ($this->otherInfo == null) {
40
-			$propertyReader = function($name) {return $this->$name;	};
40
+			$propertyReader = function($name) {return $this->$name; };
41 41
 
42 42
 			$reader = $propertyReader->bindTo($this->intermediateMapper, $this->intermediateMapper);
43 43
 
@@ -45,7 +45,7 @@  discard block
 block discarded – undo
45 45
 				$propertyReader = $propertyReader->bindTo($relation, $relation);
46 46
 				if ($propertyReader('parentField') != $this->parentField) {
47 47
 					$relation = $relation->getData($this->object);
48
-					$this->otherInfo = [$propertyReader('localField'),  $propertyReader('parentField'), $propertyReader('mapper')];
48
+					$this->otherInfo = [$propertyReader('localField'), $propertyReader('parentField'), $propertyReader('mapper')];
49 49
 				}
50 50
 			}
51 51
 		}
@@ -103,7 +103,7 @@  discard block
 block discarded – undo
103 103
 
104 104
     private function offsetSetAutotraverse($value, $relatedField, $valueField) {
105 105
         $record = new \stdClass;
106
-        $record->{$this->parentField} =  $value->{$this->localField};
106
+        $record->{$this->parentField} = $value->{$this->localField};
107 107
         $record->$valueField = $this->object->{$relatedField};
108 108
         $this->intermediateMapper[] = $record;
109 109
     }
Please login to merge, or discard this patch.
Braces   +9 added lines, -4 removed lines patch added patch discarded remove patch
@@ -32,8 +32,12 @@  discard block
 block discarded – undo
32 32
 		list($relatedField, $valueField, $mapper) = $this->getOtherFieldNameInfo();
33 33
 		$this->results = $data;
34 34
 		$this->object = $parentObject;
35
-		if (empty($parentObject->{$relatedField})) return;
36
-		foreach ($data as $dt) $this[] = $dt;
35
+		if (empty($parentObject->{$relatedField})) {
36
+			return;
37
+		}
38
+		foreach ($data as $dt) {
39
+			$this[] = $dt;
40
+		}
37 41
 	}
38 42
 
39 43
 	//bit hacky, breaking encapsulation, but simplest way to work out the info for the other side of the many:many relationship.
@@ -88,8 +92,9 @@  discard block
 block discarded – undo
88 92
 
89 93
 	public function offsetSet($name, $value) {
90 94
 		list($relatedField, $valueField, $mapper) = $this->getOtherFieldNameInfo();
91
-		if ($this->autoTraverse) $this->offsetSetAutotraverse($value, $relatedField, $valueField);
92
-		else if ($this->doUpdateInterMapper($value, $relatedField, $valueField)) {
95
+		if ($this->autoTraverse) {
96
+			$this->offsetSetAutotraverse($value, $relatedField, $valueField);
97
+		} else if ($this->doUpdateInterMapper($value, $relatedField, $valueField)) {
93 98
             $record = $value;
94 99
 			$record->{$this->parentField} = $value->{$this->intermediateName}->{$this->localField};
95 100
 			$record->$valueField = $this->object->{$relatedField};
Please login to merge, or discard this patch.
Indentation   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -90,26 +90,26 @@
 block discarded – undo
90 90
 		list($relatedField, $valueField, $mapper) = $this->getOtherFieldNameInfo();
91 91
 		if ($this->autoTraverse) $this->offsetSetAutotraverse($value, $relatedField, $valueField);
92 92
 		else if ($this->doUpdateInterMapper($value, $relatedField, $valueField)) {
93
-            $record = $value;
93
+			$record = $value;
94 94
 			$record->{$this->parentField} = $value->{$this->intermediateName}->{$this->localField};
95 95
 			$record->$valueField = $this->object->{$relatedField};
96 96
 			$this->intermediateMapper[] = $record;
97 97
 		}
98 98
 	}
99 99
 
100
-    private function doUpdateInterMapper($record, $relatedField, $valueField) {
101
-        return !(isset($record->{$this->parentField}) && isset($record->{$this->intermediateName}) &&
102
-            isset($record->$valueField) && isset($this->object->{$relatedField}) &&
103
-            $record->{$this->parentField} == $record->{$this->intermediateName}->{$this->localField} &&
104
-            $record->$valueField == $this->object->{$relatedField});
105
-    }
106
-
107
-    private function offsetSetAutotraverse($value, $relatedField, $valueField) {
108
-        $record = new \stdClass;
109
-        $record->{$this->parentField} =  $value->{$this->localField};
110
-        $record->$valueField = $this->object->{$relatedField};
111
-        $this->intermediateMapper[] = $record;
112
-    }
100
+	private function doUpdateInterMapper($record, $relatedField, $valueField) {
101
+		return !(isset($record->{$this->parentField}) && isset($record->{$this->intermediateName}) &&
102
+			isset($record->$valueField) && isset($this->object->{$relatedField}) &&
103
+			$record->{$this->parentField} == $record->{$this->intermediateName}->{$this->localField} &&
104
+			$record->$valueField == $this->object->{$relatedField});
105
+	}
106
+
107
+	private function offsetSetAutotraverse($value, $relatedField, $valueField) {
108
+		$record = new \stdClass;
109
+		$record->{$this->parentField} =  $value->{$this->localField};
110
+		$record->$valueField = $this->object->{$relatedField};
111
+		$this->intermediateMapper[] = $record;
112
+	}
113 113
 
114 114
 	public function offsetUnset($id) {
115 115
 		//$this->relation->mapper->filter([$relatedField => $this->object->$valueField, $this->relation->parentField => $id])->delete();
Please login to merge, or discard this patch.
Maphper/Relation/Many.php 1 patch
Braces   +14 added lines, -5 removed lines patch added patch discarded remove patch
@@ -6,7 +6,9 @@  discard block
 block discarded – undo
6 6
 	private $localField;
7 7
 	
8 8
 	public function __construct(\Maphper\Maphper $mapper, $parentField, $localField, array $critiera = []) {
9
-		if ($critiera) $mapper->filter($critiera);
9
+		if ($critiera) {
10
+			$mapper->filter($critiera);
11
+		}
10 12
 		$this->mapper = $mapper;
11 13
 		$this->parentField = $parentField;
12 14
 		$this->localField = $localField;		
@@ -14,17 +16,24 @@  discard block
 block discarded – undo
14 16
 	
15 17
 	
16 18
 	public function getData($parentObject) {
17
-		if (!isset($parentObject->{$this->parentField})) $mapper = $this->mapper;
18
-		else $mapper = $this->mapper->filter([$this->localField => $parentObject->{$this->parentField}]);
19
+		if (!isset($parentObject->{$this->parentField})) {
20
+			$mapper = $this->mapper;
21
+		} else {
22
+			$mapper = $this->mapper->filter([$this->localField => $parentObject->{$this->parentField}]);
23
+		}
19 24
 		
20 25
 		return $mapper;
21 26
 	}
22 27
 
23 28
 	
24 29
 	public function overwrite($key, &$mapper) {
25
-		if (!isset($key->{$this->parentField})) return false;
30
+		if (!isset($key->{$this->parentField})) {
31
+			return false;
32
+		}
26 33
 		foreach ($mapper as $k => $val) {
27
-			if (!empty($val->{$this->localField}) && $val->{$this->localField} != $key->{$this->parentField}) continue;
34
+			if (!empty($val->{$this->localField}) && $val->{$this->localField} != $key->{$this->parentField}) {
35
+				continue;
36
+			}
28 37
 			$val->{$this->localField} = $key->{$this->parentField};
29 38
 			$this->mapper[] = $val;
30 39
 		}
Please login to merge, or discard this patch.
Maphper/Lib/Sql/In.php 3 patches
Indentation   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -2,28 +2,28 @@
 block discarded – undo
2 2
 namespace Maphper\Lib\Sql;
3 3
 
4 4
 class In implements WhereConditional {
5
-    public function matches($key, $value, $mode) {
6
-        return !is_numeric($key) && is_array($value);
7
-    }
5
+	public function matches($key, $value, $mode) {
6
+		return !is_numeric($key) && is_array($value);
7
+	}
8 8
 
9
-    public function getSql($key, $value, $mode) {
10
-        $args = [];
11
-        $inSql = [];
12
-        $count = count($value);
13
-        $value = array_values($value); // fix numeric index being different than $i
14
-        for ($i = 0; $i < $count; $i++) {
15
-            $args[$key . $i] = $value[$i];
16
-            $inSql[] = ':' . $key . $i;
17
-        }
9
+	public function getSql($key, $value, $mode) {
10
+		$args = [];
11
+		$inSql = [];
12
+		$count = count($value);
13
+		$value = array_values($value); // fix numeric index being different than $i
14
+		for ($i = 0; $i < $count; $i++) {
15
+			$args[$key . $i] = $value[$i];
16
+			$inSql[] = ':' . $key . $i;
17
+		}
18 18
 
19
-        $notText = '';
20
-        if (\Maphper\Maphper::FIND_NOT & $mode) {
21
-            $notText = ' NOT';
22
-        }
19
+		$notText = '';
20
+		if (\Maphper\Maphper::FIND_NOT & $mode) {
21
+			$notText = ' NOT';
22
+		}
23 23
 
24
-        if (count($inSql) == 0) return ['args' => [], 'sql' => ''];
25
-        else $sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];
24
+		if (count($inSql) == 0) return ['args' => [], 'sql' => ''];
25
+		else $sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];
26 26
 
27
-        return ['args' => $args, 'sql' => $sql];
28
-    }
27
+		return ['args' => $args, 'sql' => $sql];
28
+	}
29 29
 }
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -22,7 +22,7 @@
 block discarded – undo
22 22
         }
23 23
 
24 24
         if (count($inSql) == 0) return ['args' => [], 'sql' => ''];
25
-        else $sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];
25
+        else $sql = [$key . $notText . ' IN ( ' . implode(', ', $inSql) . ')'];
26 26
 
27 27
         return ['args' => $args, 'sql' => $sql];
28 28
     }
Please login to merge, or discard this patch.
Braces   +5 added lines, -2 removed lines patch added patch discarded remove patch
@@ -21,8 +21,11 @@
 block discarded – undo
21 21
             $notText = ' NOT';
22 22
         }
23 23
 
24
-        if (count($inSql) == 0) return ['args' => [], 'sql' => ''];
25
-        else $sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];
24
+        if (count($inSql) == 0) {
25
+        	return ['args' => [], 'sql' => ''];
26
+        } else {
27
+        	$sql = [$key . $notText . ' IN ( ' .  implode(', ', $inSql) . ')'];
28
+        }
26 29
 
27 30
         return ['args' => $args, 'sql' => $sql];
28 31
     }
Please login to merge, or discard this patch.
Maphper/DataSource/Mock.php 2 patches
Indentation   +90 added lines, -90 removed lines patch added patch discarded remove patch
@@ -2,100 +2,100 @@
 block discarded – undo
2 2
 namespace Maphper\DataSource;
3 3
 use Maphper\Maphper;
4 4
 class Mock implements \Maphper\DataSource {
5
-    private $data;
6
-    private $id;
7
-
8
-    public function __construct(\ArrayObject $data, $id) {
9
-        $this->data = $data;
10
-        $this->id = is_array($id) ? $id : [$id];
11
-    }
12
-
13
-    public function getPrimaryKey() {
14
-        return $this->id;
15
-    }
16
-
17
-    public function findById($id) {
18
-        return isset($this->data[$id]) ? (array)$this->data[$id] : [];
19
-    }
20
-
21
-    public function findByField(array $fields, $options = []) {
22
-        $arrayFilter = new \Maphper\Lib\ArrayFilter(iterator_to_array($this->data->getIterator()));
23
-        $filteredArray = $arrayFilter->filter($fields);
24
-        if (isset($options['order'])) {
25
-            list($columns, $order) = explode(' ', $options['order']);
26
-            usort($filteredArray, $this->getOrderFunction($order, $columns));
27
-        }
28
-        if (isset($options['offset'])) $filteredArray = array_slice($filteredArray, $options['offset']);
29
-        if (isset($options['limit'])) $filteredArray = array_slice($filteredArray, 0, $options['limit']);
30
-        return $filteredArray;
31
-    }
5
+	private $data;
6
+	private $id;
7
+
8
+	public function __construct(\ArrayObject $data, $id) {
9
+		$this->data = $data;
10
+		$this->id = is_array($id) ? $id : [$id];
11
+	}
12
+
13
+	public function getPrimaryKey() {
14
+		return $this->id;
15
+	}
16
+
17
+	public function findById($id) {
18
+		return isset($this->data[$id]) ? (array)$this->data[$id] : [];
19
+	}
20
+
21
+	public function findByField(array $fields, $options = []) {
22
+		$arrayFilter = new \Maphper\Lib\ArrayFilter(iterator_to_array($this->data->getIterator()));
23
+		$filteredArray = $arrayFilter->filter($fields);
24
+		if (isset($options['order'])) {
25
+			list($columns, $order) = explode(' ', $options['order']);
26
+			usort($filteredArray, $this->getOrderFunction($order, $columns));
27
+		}
28
+		if (isset($options['offset'])) $filteredArray = array_slice($filteredArray, $options['offset']);
29
+		if (isset($options['limit'])) $filteredArray = array_slice($filteredArray, 0, $options['limit']);
30
+		return $filteredArray;
31
+	}
32 32
 
33 33
   	public function findAggregate($function, $field, $group = null, array $criteria = [], array $options = []) {
34
-        return $function($this->findByField($criteria));
35
-    }
34
+		return $function($this->findByField($criteria));
35
+	}
36 36
 
37 37
   	public function deleteById($id) {
38
-        unset($this->data[$id]);
39
-    }
38
+		unset($this->data[$id]);
39
+	}
40 40
 
41 41
   	public function deleteByField(array $fields, array $options) {
42
-        foreach ($this->findByField($fields, $options) as $val) {
43
-            if (count($this->id) > 1) $id = $this->getMultiPkSaveId($val);
44
-            else $id = $val->{$this->id[0]};
45
-
46
-            unset($this->data[$id]);
47
-        }
48
-    }
49
-
50
-    public function save($data) {
51
-        if (count($this->id) > 1) return $this->saveMultiPk($data);
52
-        else return $this->saveSinglePk($data);
53
-    }
54
-
55
-    private function saveSinglePk($data) {
56
-        if (isset($data->{$this->id[0]})) {
57
-            $id = $data->{$this->id[0]};
58
-        }
59
-        else {
60
-            $id = count($this->data);
61
-            $data->{$this->id[0]} = $id;
62
-        }
63
-
64
-        $this->data[$id] = (object)array_merge($this->findById($id), (array)$data);
65
-    }
66
-
67
-    private function saveMultiPk($data) {
68
-        $saveId = $this->getMultiPkSaveId($data);
69
-
70
-        $this->data[$saveId] = (object)array_merge($this->findById($saveId), (array)$data);
71
-    }
72
-
73
-    private function getMultiPkSaveId($data) {
74
-        $keyVals = [];
75
-        foreach ($this->id as $keyName) {
76
-            $keyVals[] = $data->$keyName;
77
-        }
78
-        return implode(',', $keyVals);
79
-    }
80
-
81
-    public function getErrors() {
82
-        return [];
83
-    }
84
-
85
-    private function getOrderFunction($order, $columns) {
86
-        return function($a, $b) use ($order, $columns) {
87
-          foreach (explode(',', $columns) as $column) {
88
-            $aColumn = $a->$column;
89
-            $bColumn = $b->$column;
90
-            if ($aColumn === $bColumn) {
91
-              $sortVal = 0;
92
-              continue;
93
-            }
94
-            else $sortVal = ($aColumn < $bColumn) ? -1 : 1;
95
-            break;
96
-          }
97
-          if ($order === 'desc') return -$sortVal;
98
-          else return $sortVal;
99
-        };
100
-    }
42
+		foreach ($this->findByField($fields, $options) as $val) {
43
+			if (count($this->id) > 1) $id = $this->getMultiPkSaveId($val);
44
+			else $id = $val->{$this->id[0]};
45
+
46
+			unset($this->data[$id]);
47
+		}
48
+	}
49
+
50
+	public function save($data) {
51
+		if (count($this->id) > 1) return $this->saveMultiPk($data);
52
+		else return $this->saveSinglePk($data);
53
+	}
54
+
55
+	private function saveSinglePk($data) {
56
+		if (isset($data->{$this->id[0]})) {
57
+			$id = $data->{$this->id[0]};
58
+		}
59
+		else {
60
+			$id = count($this->data);
61
+			$data->{$this->id[0]} = $id;
62
+		}
63
+
64
+		$this->data[$id] = (object)array_merge($this->findById($id), (array)$data);
65
+	}
66
+
67
+	private function saveMultiPk($data) {
68
+		$saveId = $this->getMultiPkSaveId($data);
69
+
70
+		$this->data[$saveId] = (object)array_merge($this->findById($saveId), (array)$data);
71
+	}
72
+
73
+	private function getMultiPkSaveId($data) {
74
+		$keyVals = [];
75
+		foreach ($this->id as $keyName) {
76
+			$keyVals[] = $data->$keyName;
77
+		}
78
+		return implode(',', $keyVals);
79
+	}
80
+
81
+	public function getErrors() {
82
+		return [];
83
+	}
84
+
85
+	private function getOrderFunction($order, $columns) {
86
+		return function($a, $b) use ($order, $columns) {
87
+		  foreach (explode(',', $columns) as $column) {
88
+			$aColumn = $a->$column;
89
+			$bColumn = $b->$column;
90
+			if ($aColumn === $bColumn) {
91
+			  $sortVal = 0;
92
+			  continue;
93
+			}
94
+			else $sortVal = ($aColumn < $bColumn) ? -1 : 1;
95
+			break;
96
+		  }
97
+		  if ($order === 'desc') return -$sortVal;
98
+		  else return $sortVal;
99
+		};
100
+	}
101 101
 }
Please login to merge, or discard this patch.
Braces   +24 added lines, -11 removed lines patch added patch discarded remove patch
@@ -25,8 +25,12 @@  discard block
 block discarded – undo
25 25
             list($columns, $order) = explode(' ', $options['order']);
26 26
             usort($filteredArray, $this->getOrderFunction($order, $columns));
27 27
         }
28
-        if (isset($options['offset'])) $filteredArray = array_slice($filteredArray, $options['offset']);
29
-        if (isset($options['limit'])) $filteredArray = array_slice($filteredArray, 0, $options['limit']);
28
+        if (isset($options['offset'])) {
29
+        	$filteredArray = array_slice($filteredArray, $options['offset']);
30
+        }
31
+        if (isset($options['limit'])) {
32
+        	$filteredArray = array_slice($filteredArray, 0, $options['limit']);
33
+        }
30 34
         return $filteredArray;
31 35
     }
32 36
 
@@ -40,23 +44,28 @@  discard block
 block discarded – undo
40 44
 
41 45
   	public function deleteByField(array $fields, array $options) {
42 46
         foreach ($this->findByField($fields, $options) as $val) {
43
-            if (count($this->id) > 1) $id = $this->getMultiPkSaveId($val);
44
-            else $id = $val->{$this->id[0]};
47
+            if (count($this->id) > 1) {
48
+            	$id = $this->getMultiPkSaveId($val);
49
+            } else {
50
+            	$id = $val->{$this->id[0]};
51
+            }
45 52
 
46 53
             unset($this->data[$id]);
47 54
         }
48 55
     }
49 56
 
50 57
     public function save($data) {
51
-        if (count($this->id) > 1) return $this->saveMultiPk($data);
52
-        else return $this->saveSinglePk($data);
58
+        if (count($this->id) > 1) {
59
+        	return $this->saveMultiPk($data);
60
+        } else {
61
+        	return $this->saveSinglePk($data);
62
+        }
53 63
     }
54 64
 
55 65
     private function saveSinglePk($data) {
56 66
         if (isset($data->{$this->id[0]})) {
57 67
             $id = $data->{$this->id[0]};
58
-        }
59
-        else {
68
+        } else {
60 69
             $id = count($this->data);
61 70
             $data->{$this->id[0]} = $id;
62 71
         }
@@ -90,12 +99,16 @@  discard block
 block discarded – undo
90 99
             if ($aColumn === $bColumn) {
91 100
               $sortVal = 0;
92 101
               continue;
102
+            } else {
103
+            	$sortVal = ($aColumn < $bColumn) ? -1 : 1;
93 104
             }
94
-            else $sortVal = ($aColumn < $bColumn) ? -1 : 1;
95 105
             break;
96 106
           }
97
-          if ($order === 'desc') return -$sortVal;
98
-          else return $sortVal;
107
+          if ($order === 'desc') {
108
+          	return -$sortVal;
109
+          } else {
110
+          	return $sortVal;
111
+          }
99 112
         };
100 113
     }
101 114
 }
Please login to merge, or discard this patch.
Maphper/DataSource/DatabaseOptions.php 1 patch
Braces   +6 added lines, -2 removed lines patch added patch discarded remove patch
@@ -10,7 +10,9 @@  discard block
 block discarded – undo
10 10
 	}
11 11
 
12 12
 	public function getAdapter() {
13
-		if ($this->db instanceof \Maphper\DataSource) return $this->db;
13
+		if ($this->db instanceof \Maphper\DataSource) {
14
+			return $this->db;
15
+		}
14 16
 
15 17
 		$adapter = '\\Maphper\\DataSource\\' . ucfirst($this->db->getAttribute(\PDO::ATTR_DRIVER_NAME)) . 'Adapter';
16 18
 
@@ -18,7 +20,9 @@  discard block
 block discarded – undo
18 20
 	}
19 21
 
20 22
 	public function getEditMode() {
21
-		if (!isset($this->options['editmode'])) return false;
23
+		if (!isset($this->options['editmode'])) {
24
+			return false;
25
+		}
22 26
 
23 27
 		return $this->options['editmode'] === true ? Database::EDIT_STRUCTURE | Database::EDIT_INDEX | Database::EDIT_OPTIMISE : $this->options['editmode'];
24 28
 	}
Please login to merge, or discard this patch.