Completed
Pull Request — master (#74)
by
unknown
12:12 queued 11:52
created
src/Repositories/StatisticsRepository.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -64,7 +64,7 @@  discard block
 block discarded – undo
64 64
 			return $this->db->setQuery(
65 65
 				$this->db->getQuery(true)
66 66
 					->select('*')
67
-					->from($this->db->quoteName('#__jstats_counter_' . $column))
67
+					->from($this->db->quoteName('#__jstats_counter_'.$column))
68 68
 			)->loadAssocList();
69 69
 		}
70 70
 
@@ -75,7 +75,7 @@  discard block
 block discarded – undo
75 75
 			$return[$column] = $this->db->setQuery(
76 76
 				$this->db->getQuery(true)
77 77
 					->select('*')
78
-					->from($this->db->quoteName('#__jstats_counter_' . $column))
78
+					->from($this->db->quoteName('#__jstats_counter_'.$column))
79 79
 			)->loadAssocList();
80 80
 		}
81 81
 
@@ -101,7 +101,7 @@  discard block
 block discarded – undo
101 101
 				$return[$column] = $this->db->setQuery(
102 102
 					$this->db->getQuery(true)
103 103
 						->select($column)
104
-						->select('COUNT(' . $column . ') AS count')
104
+						->select('COUNT('.$column.') AS count')
105 105
 						->from($this->db->quoteName('#__jstats'))
106 106
 						->where('modified BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW()')
107 107
 						->group($column)
@@ -113,11 +113,11 @@  discard block
 block discarded – undo
113 113
 			{
114 114
 				$return['cms_php_version'] = $this->db->setQuery(
115 115
 					$this->db->getQuery(true)
116
-						->select('CONCAT(' . $db->qn('cms_version') . ', ' . $db->q(' - ') . ', ' . $db->qn('php_version') . ') AS cms_php_version')
116
+						->select('CONCAT('.$db->qn('cms_version').', '.$db->q(' - ').', '.$db->qn('php_version').') AS cms_php_version')
117 117
 						->select('COUNT(*) AS count')
118 118
 						->from($this->db->quoteName('#__jstats'))
119 119
 						->where('modified BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW()')
120
-						->group('CONCAT(' . $db->qn('cms_version') . ', ' . $db->q(' - ') . ', ' . $db->qn('php_version') . ')')
120
+						->group('CONCAT('.$db->qn('cms_version').', '.$db->q(' - ').', '.$db->qn('php_version').')')
121 121
 				)->loadAssocList();
122 122
 				continue;
123 123
 			}
@@ -126,11 +126,11 @@  discard block
 block discarded – undo
126 126
 			{
127 127
 				$return['db_type_version'] = $this->db->setQuery(
128 128
 					$this->db->getQuery(true)
129
-						->select('CONCAT(' . $db->qn('db_type') . ', ' . $db->q(' - ') . ', ' . $db->qn('db_version') . ') AS db_type_version')
129
+						->select('CONCAT('.$db->qn('db_type').', '.$db->q(' - ').', '.$db->qn('db_version').') AS db_type_version')
130 130
 						->select('COUNT(*) AS count')
131 131
 						->from($this->db->quoteName('#__jstats'))
132 132
 						->where('modified BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW()')
133
-						->group('CONCAT(' . $db->qn('db_type') . ', ' . $db->q(' - ') . ', ' . $db->qn('db_version') . ')')
133
+						->group('CONCAT('.$db->qn('db_type').', '.$db->q(' - ').', '.$db->qn('db_version').')')
134 134
 				)->loadAssocList();
135 135
 				continue;
136 136
 			}
@@ -175,9 +175,9 @@  discard block
 block discarded – undo
175 175
 			$return[$column] = $this->db->setQuery(
176 176
 				$this->db->getQuery(true)
177 177
 					->select($column)
178
-					->select('COUNT(' . $column . ') AS count')
179
-					->from('(SELECT * FROM ' . $this->db->quoteName('#__jstats')
180
-						. ' WHERE modified > DATE_SUB(NOW(), INTERVAL ' . $this->db->quote($timeframe) . ' DAY)) AS tmptable'
178
+					->select('COUNT('.$column.') AS count')
179
+					->from('(SELECT * FROM '.$this->db->quoteName('#__jstats')
180
+						. ' WHERE modified > DATE_SUB(NOW(), INTERVAL '.$this->db->quote($timeframe).' DAY)) AS tmptable'
181 181
 					)
182 182
 					->group($column)
183 183
 			)->loadAssocList();
Please login to merge, or discard this patch.