Passed
Push — develop ( 111896...eb49e9 )
by Jens
02:45
created
cloudcontrol/library/search/indexer/TermFieldLengthNorm.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -45,18 +45,18 @@  discard block
 block discarded – undo
45 45
 		if ($stmt === false) {
46 46
 			$errorInfo = $db->errorInfo();
47 47
 			$errorMsg = $errorInfo[2];
48
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
48
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
49 49
 		}
50 50
 		if (($stmt->execute()) === false) {
51 51
 			$errorInfo = $db->errorInfo();
52 52
 			$errorMsg = $errorInfo[2];
53
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
53
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
54 54
 		}
55 55
 		$uniqueFieldsPerDocument = $stmt->fetchAll(\PDO::FETCH_OBJ);
56 56
 		$values = array();
57 57
 		$i = 0;
58 58
 		foreach ($uniqueFieldsPerDocument as $fieldRow) {
59
-			$values[] = 'UPDATE term_frequency SET termNorm = 1/sqrt(' . intval($fieldRow->termCount) . ') WHERE documentPath = ' . $db->quote($fieldRow->documentPath) . ' AND field = ' . $db->quote($fieldRow->field) . ';';
59
+			$values[] = 'UPDATE term_frequency SET termNorm = 1/sqrt('.intval($fieldRow->termCount).') WHERE documentPath = '.$db->quote($fieldRow->documentPath).' AND field = '.$db->quote($fieldRow->field).';';
60 60
 			$i += 1;
61 61
 			if ($i >= Indexer::SQLITE_MAX_COMPOUND_SELECT) {
62 62
 				$this->executeUpdateTermNorm($values, $db);
@@ -76,13 +76,13 @@  discard block
 block discarded – undo
76 76
 	 */
77 77
 	private function executeUpdateTermNorm($values, $db)
78 78
 	{
79
-		$sql  = 'BEGIN TRANSACTION;' . PHP_EOL;
80
-		$sql .= implode(PHP_EOL, $values) . PHP_EOL;
79
+		$sql  = 'BEGIN TRANSACTION;'.PHP_EOL;
80
+		$sql .= implode(PHP_EOL, $values).PHP_EOL;
81 81
 		$sql .= 'COMMIT;';
82 82
 		if (($db->exec($sql)) === false) {
83 83
 			$errorInfo = $db->errorInfo();
84 84
 			$errorMsg = $errorInfo[2];
85
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
85
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
86 86
 		}
87 87
 	}
88 88
 }
89 89
\ No newline at end of file
Please login to merge, or discard this patch.
cloudcontrol/library/search/indexer/InverseDocumentFrequency.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -47,14 +47,14 @@
 block discarded – undo
47 47
 		if (!$stmt = $db->prepare($sql)) {
48 48
 			$errorInfo = $db->errorInfo();
49 49
 			$errorMsg = $errorInfo[2];
50
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
50
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
51 51
 		}
52 52
 		$stmt->bindValue(':documentCount', $this->documentCount);
53 53
 		$result = $stmt->execute();
54 54
 		if ($result === false) {
55 55
 			$errorInfo = $db->errorInfo();
56 56
 			$errorMsg = $errorInfo[2];
57
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
57
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
58 58
 		}
59 59
 	}
60 60
 }
61 61
\ No newline at end of file
Please login to merge, or discard this patch.
cloudcontrol/library/search/indexer/TermFrequency.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -52,7 +52,7 @@  discard block
 block discarded – undo
52 52
 			$i = 0;
53 53
 			foreach ($termsForDocumentField as $term) {
54 54
 				$frequency = intval($term->count) / $documentField->totalTermCount;
55
-				$values[] = $quotedDocumentPath . ','  . $quotedField . ', ' . $db->quote($term->term) . ', ' . $db->quote($frequency);
55
+				$values[] = $quotedDocumentPath.','.$quotedField.', '.$db->quote($term->term).', '.$db->quote($frequency);
56 56
 				$i += 1;
57 57
 				if ($i >= Indexer::SQLITE_MAX_COMPOUND_SELECT) {
58 58
 					$this->executeStore($sql, $values, $db);
@@ -101,11 +101,11 @@  discard block
 block discarded – undo
101 101
 
102 102
 	private function executeStore($sql, $values, $db)
103 103
 	{
104
-		$sql .= '(' . implode('),' . PHP_EOL . '(', $values) . ');';
104
+		$sql .= '('.implode('),'.PHP_EOL.'(', $values).');';
105 105
 		if (!$db->query($sql)) {
106 106
 			$errorInfo = $db->errorInfo();
107 107
 			$errorMsg = $errorInfo[2];
108
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
108
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
109 109
 		}
110 110
 	}
111 111
 
Please login to merge, or discard this patch.
cloudcontrol/library/search/indexer/TermCount.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -48,7 +48,7 @@  discard block
 block discarded – undo
48 48
 	protected function applyFilters($tokens)
49 49
 	{
50 50
 		foreach ($this->filters as $filterName) {
51
-			$filterClassName = '\library\search\filters\\' . $filterName;
51
+			$filterClassName = '\library\search\filters\\'.$filterName;
52 52
 			$filter = new $filterClassName($tokens);
53 53
 			$tokens = $filter->getFilterResults();
54 54
 		}
@@ -68,7 +68,7 @@  discard block
 block discarded – undo
68 68
 		foreach ($documentTermCount as $field => $countArray) {
69 69
 			$quotedField = $db->quote($field);
70 70
 			foreach ($countArray as $term => $count) {
71
-				$values[] = $quotedDocumentPath . ', ' . $db->quote($term) . ', ' . $db->quote($count) . ', ' . $quotedField;
71
+				$values[] = $quotedDocumentPath.', '.$db->quote($term).', '.$db->quote($count).', '.$quotedField;
72 72
 				$i += 1;
73 73
 				if ($i >= Indexer::SQLITE_MAX_COMPOUND_SELECT) {
74 74
 					$this->executeStoreDocumentTermCount($values, $sql, $db);
@@ -92,13 +92,13 @@  discard block
 block discarded – undo
92 92
 	 */
93 93
 	protected function executeStoreDocumentTermCount($values, $sql, $db)
94 94
 	{
95
-		$sql .= '(' . implode('),' . PHP_EOL . '(', $values) . ');';
95
+		$sql .= '('.implode('),'.PHP_EOL.'(', $values).');';
96 96
 
97 97
 		$stmt = $db->prepare($sql);
98 98
 		if ($stmt === false || !$stmt->execute()) {
99 99
 			$errorInfo = $db->errorInfo();
100 100
 			$errorMsg = $errorInfo[2];
101
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
101
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
102 102
 		}
103 103
 	}
104 104
 }
105 105
\ No newline at end of file
Please login to merge, or discard this patch.
cloudcontrol/library/search/CharacterFilter.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -46,7 +46,7 @@  discard block
 block discarded – undo
46 46
 	{
47 47
 		$string = strip_tags($string);
48 48
 		$string = iconv('UTF-8', 'ASCII//TRANSLIT//IGNORE', $string); // Remove special alphanumeric characters
49
-		$string = str_replace(array('+', '=', '!', ',', '.',';', ':', '?'), ' ', $string); // Replace sentence breaking charaters with spaces
49
+		$string = str_replace(array('+', '=', '!', ',', '.', ';', ':', '?'), ' ', $string); // Replace sentence breaking charaters with spaces
50 50
 		$string = preg_replace("/[\r\n]+/", " ", $string); // Replace multiple newlines with a single space.
51 51
 		$string = preg_replace("/[\t]+/", " ", $string); // Replace multiple tabs with a single space.
52 52
 		$string = preg_replace("/[^a-zA-Z0-9 ]/", '', $string); // Filter out everything that is not alphanumeric or a space
@@ -64,7 +64,7 @@  discard block
 block discarded – undo
64 64
 	{
65 65
 		$encoding = mb_detect_encoding($string, mb_detect_order(), false);
66 66
 
67
-		if($encoding == "UTF-8") {
67
+		if ($encoding == "UTF-8") {
68 68
 			$string = mb_convert_encoding($string, 'UTF-8', 'UTF-8');
69 69
 		}
70 70
 
Please login to merge, or discard this patch.
cloudcontrol/library/search/SearchDbConnected.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -49,7 +49,7 @@  discard block
 block discarded – undo
49 49
 	protected function configureDatabase()
50 50
 	{
51 51
 		$db = $this->getSearchDbHandle();
52
-		$sqlPath = __DIR__ . DIRECTORY_SEPARATOR . '../cc/install/search.sql';
52
+		$sqlPath = __DIR__.DIRECTORY_SEPARATOR.'../cc/install/search.sql';
53 53
 		$searchSql = file_get_contents($sqlPath);
54 54
 		$db->exec($searchSql);
55 55
 	}
@@ -65,8 +65,8 @@  discard block
 block discarded – undo
65 65
 	protected function getSearchDbHandle()
66 66
 	{
67 67
 		if ($this->searchDbHandle === null) {
68
-			$path = __DIR__ . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . $this->storageDir . DIRECTORY_SEPARATOR;
69
-			$this->searchDbHandle = new \PDO('sqlite:' . $path . 'search.db');
68
+			$path = __DIR__.DIRECTORY_SEPARATOR.'..'.DIRECTORY_SEPARATOR.'..'.DIRECTORY_SEPARATOR.$this->storageDir.DIRECTORY_SEPARATOR;
69
+			$this->searchDbHandle = new \PDO('sqlite:'.$path.'search.db');
70 70
 		}
71 71
 		return $this->searchDbHandle;
72 72
 	}
Please login to merge, or discard this patch.
cloudcontrol/library/search/filters/DutchStopWords.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -10,5 +10,5 @@
 block discarded – undo
10 10
 
11 11
 class DutchStopWords extends StopWordsFilter
12 12
 {
13
-	protected $stopWords = array('aan','af','al','alles','als','altijd','andere','ben','bij','daar','dan','dat','de','der','deze','die','dit','doch','doen','door','doorgaans','dus','een','eens','en','er','ge','geen','geweest','haar','had','heb','hebben','heeft','hem','het','hier','hij','hoe','hun','iemand','iets','ik','in','is','ja','je','kan','kon','kunnen','maar','me','meer','men','met','mij','mijn','moet','na','naar','niet','niets','nog','nu','of','om','omdat','ons','ook','op','over','reeds','te','tegen','toch','toen','tot','u','uit','uw','van','veel','voor','want','waren','was','wat','we','wel','werd','wezen','wie','wij','wil','worden','zal','ze','zei','zelf','zich','zij','zijn','zo','zodat','zonder','zou');
13
+	protected $stopWords = array('aan', 'af', 'al', 'alles', 'als', 'altijd', 'andere', 'ben', 'bij', 'daar', 'dan', 'dat', 'de', 'der', 'deze', 'die', 'dit', 'doch', 'doen', 'door', 'doorgaans', 'dus', 'een', 'eens', 'en', 'er', 'ge', 'geen', 'geweest', 'haar', 'had', 'heb', 'hebben', 'heeft', 'hem', 'het', 'hier', 'hij', 'hoe', 'hun', 'iemand', 'iets', 'ik', 'in', 'is', 'ja', 'je', 'kan', 'kon', 'kunnen', 'maar', 'me', 'meer', 'men', 'met', 'mij', 'mijn', 'moet', 'na', 'naar', 'niet', 'niets', 'nog', 'nu', 'of', 'om', 'omdat', 'ons', 'ook', 'op', 'over', 'reeds', 'te', 'tegen', 'toch', 'toen', 'tot', 'u', 'uit', 'uw', 'van', 'veel', 'voor', 'want', 'waren', 'was', 'wat', 'we', 'wel', 'werd', 'wezen', 'wie', 'wij', 'wil', 'worden', 'zal', 'ze', 'zei', 'zelf', 'zich', 'zij', 'zijn', 'zo', 'zodat', 'zonder', 'zou');
14 14
 }
15 15
\ No newline at end of file
Please login to merge, or discard this patch.
cloudcontrol/library/search/filters/StopWordsFilter.php 1 patch
Indentation   +30 added lines, -30 removed lines patch added patch discarded remove patch
@@ -11,37 +11,37 @@
 block discarded – undo
11 11
 
12 12
 abstract class StopWordsFilter implements Filter
13 13
 {
14
-    protected $tokens;
15
-    protected $stopWords = array();
14
+	protected $tokens;
15
+	protected $stopWords = array();
16 16
 
17
-    /**
18
-     * StopWordsFilter constructor.
19
-     * @param array $tokens
20
-     */
21
-    public function __construct($tokens)
22
-    {
23
-        $this->tokens = $tokens;
24
-    }
17
+	/**
18
+	 * StopWordsFilter constructor.
19
+	 * @param array $tokens
20
+	 */
21
+	public function __construct($tokens)
22
+	{
23
+		$this->tokens = $tokens;
24
+	}
25 25
 
26
-    /**
27
-     * @return array
28
-     */
29
-    public function getFilterResults()
30
-    {
31
-        foreach ($this->stopWords as $stopWord) {
32
-            foreach ($this->tokens as $field => $tokens) {
33
-                if (isset($tokens[$stopWord])) {
34
-                    $tokens[$stopWord] = null;
35
-                    unset($tokens[$stopWord]);
36
-                    $tokens = array_filter($tokens);
37
-                    asort($tokens);
38
-                }
26
+	/**
27
+	 * @return array
28
+	 */
29
+	public function getFilterResults()
30
+	{
31
+		foreach ($this->stopWords as $stopWord) {
32
+			foreach ($this->tokens as $field => $tokens) {
33
+				if (isset($tokens[$stopWord])) {
34
+					$tokens[$stopWord] = null;
35
+					unset($tokens[$stopWord]);
36
+					$tokens = array_filter($tokens);
37
+					asort($tokens);
38
+				}
39 39
 
40
-                $this->tokens[$field] = $tokens;
41
-            }
42
-        }
43
-        $this->tokens = array_filter($this->tokens);
44
-        asort($this->tokens);
45
-        return $this->tokens;
46
-    }
40
+				$this->tokens[$field] = $tokens;
41
+			}
42
+		}
43
+		$this->tokens = array_filter($this->tokens);
44
+		asort($this->tokens);
45
+		return $this->tokens;
46
+	}
47 47
 }
48 48
\ No newline at end of file
Please login to merge, or discard this patch.
cloudcontrol/library/search/Search.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -79,13 +79,13 @@  discard block
 block discarded – undo
79 79
 		if (!$stmt = $db->query($sql)) {
80 80
 			$errorInfo = $db->errorInfo();
81 81
 			$errorMsg = $errorInfo[2];
82
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
82
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
83 83
 		}
84 84
 		$result = $stmt->fetch(\PDO::FETCH_COLUMN);
85 85
 		if (false === $result) {
86 86
 			$errorInfo = $db->errorInfo();
87 87
 			$errorMsg = $errorInfo[2];
88
-			throw new \Exception('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
88
+			throw new \Exception('SQLite Exception: '.$errorMsg.' in SQL: <br /><pre>'.$sql.'</pre>');
89 89
 		}
90 90
 		return intval($result);
91 91
 	}
@@ -118,7 +118,7 @@  discard block
 block discarded – undo
118 118
 	protected function applyFilters($tokens)
119 119
 	{
120 120
 		foreach ($this->filters as $filterName) {
121
-			$filterClassName = '\library\search\filters\\' . $filterName;
121
+			$filterClassName = '\library\search\filters\\'.$filterName;
122 122
 			$filter = new $filterClassName($tokens);
123 123
 			$tokens = $filter->getFilterResults();
124 124
 		}
@@ -154,13 +154,13 @@  discard block
 block discarded – undo
154 154
 		  GROUP BY term_frequency.documentPath, term_frequency.term
155 155
 		  ORDER BY score DESC
156 156
 		';
157
-		if(!$stmt = $db->prepare($sql)) {
158
-			throw new \Exception('SQLite exception: <pre>' . print_r($db->errorInfo(), true) . '</pre> for SQL:<pre>' . $sql . '</pre>');
157
+		if (!$stmt = $db->prepare($sql)) {
158
+			throw new \Exception('SQLite exception: <pre>'.print_r($db->errorInfo(), true).'</pre> for SQL:<pre>'.$sql.'</pre>');
159 159
 		}
160 160
 		$stmt->bindValue(':query', $token);
161 161
 		$stmt->bindValue(':queryNorm', $queryNorm);
162 162
 		if (!$stmt->execute()) {
163
-			throw new \Exception('SQLite exception: <pre>' . print_r($db->errorInfo(), true) . '</pre> for SQL:<pre>' . $sql . '</pre>');
163
+			throw new \Exception('SQLite exception: <pre>'.print_r($db->errorInfo(), true).'</pre> for SQL:<pre>'.$sql.'</pre>');
164 164
 		}
165 165
 		return $stmt->fetchAll(\PDO::FETCH_CLASS, '\library\search\results\SearchResult');
166 166
 	}
@@ -216,13 +216,13 @@  discard block
 block discarded – undo
216 216
 		$sql = '
217 217
 			SELECT (1 / sqrt(SUM(inverseDocumentFrequency))) as queryNorm
218 218
 			  FROM inverse_document_frequency
219
-			 WHERE term IN (' . $terms . ') 
219
+			 WHERE term IN (' . $terms.') 
220 220
 		';
221
-		if(!$stmt = $db->prepare($sql)) {
222
-			throw new \Exception('SQLite exception: <pre>' . print_r($db->errorInfo(), true) . '</pre> for SQL:<pre>' . $sql . '</pre>');
221
+		if (!$stmt = $db->prepare($sql)) {
222
+			throw new \Exception('SQLite exception: <pre>'.print_r($db->errorInfo(), true).'</pre> for SQL:<pre>'.$sql.'</pre>');
223 223
 		}
224 224
 		if (!$stmt->execute()) {
225
-			throw new \Exception('SQLite exception: <pre>' . print_r($db->errorInfo(), true) . '</pre> for SQL:<pre>' . $sql . '</pre>');
225
+			throw new \Exception('SQLite exception: <pre>'.print_r($db->errorInfo(), true).'</pre> for SQL:<pre>'.$sql.'</pre>');
226 226
 		}
227 227
 		$result = $stmt->fetch(\PDO::FETCH_OBJ);
228 228
 		return $result->queryNorm == null ? 1 : $result->queryNorm;
@@ -272,11 +272,11 @@  discard block
 block discarded – undo
272 272
 			';
273 273
 			$stmt = $db->prepare($sql);
274 274
 			if ($stmt === false) {
275
-				throw new \Exception('SQLite exception: <pre>' . print_r($db->errorInfo(), true) . '</pre> for SQL:<pre>' . $sql . '</pre>');
275
+				throw new \Exception('SQLite exception: <pre>'.print_r($db->errorInfo(), true).'</pre> for SQL:<pre>'.$sql.'</pre>');
276 276
 			}
277 277
 			$stmt->bindValue(':token', $token);
278 278
 			if (($stmt === false) | (!$stmt->execute())) {
279
-				throw new \Exception('SQLite exception: <pre>' . print_r($db->errorInfo(), true) . '</pre> for SQL:<pre>' . $sql . '</pre>');
279
+				throw new \Exception('SQLite exception: <pre>'.print_r($db->errorInfo(), true).'</pre> for SQL:<pre>'.$sql.'</pre>');
280 280
 			}
281 281
 			$result = $stmt->fetchAll(\PDO::FETCH_CLASS, '\library\search\results\SearchSuggestion');
282 282
 			$allResults = array_merge($result, $allResults);
Please login to merge, or discard this patch.