Completed
Push — master ( b5da35...f9f0d3 )
by Sam
03:08
created
src/Xtools/EditCounter.php 1 patch
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -41,7 +41,7 @@  discard block
 block discarded – undo
41 41
      */
42 42
     protected function getRevisionCounts()
43 43
     {
44
-        if (! is_array($this->revisionCounts)) {
44
+        if (!is_array($this->revisionCounts)) {
45 45
             $this->revisionCounts = $this->getRepository()
46 46
                 ->getRevisionCounts($this->project, $this->user);
47 47
         }
@@ -54,7 +54,7 @@  discard block
 block discarded – undo
54 54
      */
55 55
     protected function getRevisionDates()
56 56
     {
57
-        if (! is_array($this->revisionDates)) {
57
+        if (!is_array($this->revisionDates)) {
58 58
             $this->revisionDates = $this->getRepository()
59 59
                 ->getRevisionDates($this->project, $this->user);
60 60
         }
@@ -67,7 +67,7 @@  discard block
 block discarded – undo
67 67
      */
68 68
     protected function getPageCounts()
69 69
     {
70
-        if (! is_array($this->pageCounts)) {
70
+        if (!is_array($this->pageCounts)) {
71 71
             $this->pageCounts = $this->getRepository()
72 72
                 ->getPageCounts($this->project, $this->user);
73 73
         }
@@ -80,7 +80,7 @@  discard block
 block discarded – undo
80 80
      */
81 81
     protected function getLogCounts()
82 82
     {
83
-        if (! is_array($this->logCounts)) {
83
+        if (!is_array($this->logCounts)) {
84 84
             $this->logCounts = $this->getRepository()
85 85
                 ->getLogCounts($this->project, $this->user);
86 86
         }
@@ -109,7 +109,7 @@  discard block
 block discarded – undo
109 109
      */
110 110
     public function countAllRevisions()
111 111
     {
112
-        return $this->countLiveRevisions() + $this->countDeletedRevisions();
112
+        return $this->countLiveRevisions()+$this->countDeletedRevisions();
113 113
     }
114 114
 
115 115
     /**
@@ -128,7 +128,7 @@  discard block
 block discarded – undo
128 128
      */
129 129
     public function countRevisionsWithoutComments()
130 130
     {
131
-        return $this->countAllRevisions() - $this->countRevisionsWithComments();
131
+        return $this->countAllRevisions()-$this->countRevisionsWithComments();
132 132
     }
133 133
 
134 134
     /**
@@ -195,7 +195,7 @@  discard block
 block discarded – undo
195 195
      */
196 196
     public function countAllPagesEdited()
197 197
     {
198
-        return $this->countLivePagesEdited() + $this->countDeletedPagesEdited();
198
+        return $this->countLivePagesEdited()+$this->countDeletedPagesEdited();
199 199
     }
200 200
 
201 201
     /**
@@ -213,7 +213,7 @@  discard block
 block discarded – undo
213 213
      */
214 214
     public function countPagesCreated()
215 215
     {
216
-        return $this->countCreatedPagesLive() + $this->countPagesCreatedDeleted();
216
+        return $this->countCreatedPagesLive()+$this->countPagesCreatedDeleted();
217 217
     }
218 218
 
219 219
     /**
@@ -359,9 +359,9 @@  discard block
 block discarded – undo
359 359
     public function approvals()
360 360
     {
361 361
         $logCounts = $this->getLogCounts();
362
-        $total = $logCounts['review-approve'] +
363
-        (!empty($logCounts['review-approve-a']) ? $logCounts['review-approve-a'] : 0) +
364
-        (!empty($logCounts['review-approve-i']) ? $logCounts['review-approve-i'] : 0) +
362
+        $total = $logCounts['review-approve']+
363
+        (!empty($logCounts['review-approve-a']) ? $logCounts['review-approve-a'] : 0)+
364
+        (!empty($logCounts['review-approve-i']) ? $logCounts['review-approve-i'] : 0)+
365 365
         (!empty($logCounts['review-approve-ia']) ? $logCounts['review-approve-ia'] : 0);
366 366
         return $total;
367 367
     }
@@ -387,8 +387,8 @@  discard block
 block discarded – undo
387 387
         // Get counts.
388 388
         $editCounts = $this->getRepository()->getRevisionCountsAllProjects($user, $project);
389 389
         // Sort.
390
-        uasort($editCounts, function ($a, $b) {
391
-            return $b['total'] - $a['total'];
390
+        uasort($editCounts, function($a, $b) {
391
+            return $b['total']-$a['total'];
392 392
         });
393 393
         // Truncate, and return.
394 394
         return array_slice($editCounts, 0, $numProjects);
@@ -457,14 +457,14 @@  discard block
 block discarded – undo
457 457
             if (!isset($out['totals'][$ns])) {
458 458
                 $out['totals'][$ns] = [];
459 459
             }
460
-            $out['totals'][$ns][$total['year'] . $total['month']] = $total['count'];
460
+            $out['totals'][$ns][$total['year'].$total['month']] = $total['count'];
461 461
         }
462 462
         // Fill in the blanks (where no edits were made in a given month for a namespace).
463 463
         for ($y = $out['min_year']; $y <= $out['max_year']; $y++) {
464 464
             for ($m = 1; $m <= 12; $m++) {
465 465
                 foreach ($out['totals'] as $nsId => &$total) {
466
-                    if (!isset($total[$y . $m])) {
467
-                        $total[$y . $m] = 0;
466
+                    if (!isset($total[$y.$m])) {
467
+                        $total[$y.$m] = 0;
468 468
                     }
469 469
                 }
470 470
             }
Please login to merge, or discard this patch.
src/AppBundle/Controller/AdminScoreController.php 2 patches
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -27,9 +27,9 @@  discard block
 block discarded – undo
27 27
         $username = $request->query->get('username');
28 28
 
29 29
         if ($projectQuery != "" && $username != "") {
30
-            return $this->redirectToRoute("AdminScoreResult", [ 'project'=>$projectQuery, 'username' => $username ]);
30
+            return $this->redirectToRoute("AdminScoreResult", ['project'=>$projectQuery, 'username' => $username]);
31 31
         } elseif ($projectQuery != "") {
32
-            return $this->redirectToRoute("AdminScoreProject", [ 'project'=>$projectQuery ]);
32
+            return $this->redirectToRoute("AdminScoreProject", ['project'=>$projectQuery]);
33 33
         }
34 34
 
35 35
         // Otherwise fall through.
@@ -67,20 +67,20 @@  discard block
 block discarded – undo
67 67
         $archiveTable = $lh->getTable("archive", $dbName);
68 68
 
69 69
         // MULTIPLIERS (to review)
70
-        $ACCT_AGE_MULT = 1.25;   # 0 if = 365 jours
71
-        $EDIT_COUNT_MULT = 1.25;     # 0 if = 10 000
72
-        $USER_PAGE_MULT = 0.1;     # 0 if =
70
+        $ACCT_AGE_MULT = 1.25; # 0 if = 365 jours
71
+        $EDIT_COUNT_MULT = 1.25; # 0 if = 10 000
72
+        $USER_PAGE_MULT = 0.1; # 0 if =
73 73
         $PATROLS_MULT = 1; # 0 if =
74
-        $BLOCKS_MULT = 1.4;     # 0 if = 10
74
+        $BLOCKS_MULT = 1.4; # 0 if = 10
75 75
         $AFD_MULT = 1.15;
76
-        $RECENT_ACTIVITY_MULT = 0.9;     # 0 if =
76
+        $RECENT_ACTIVITY_MULT = 0.9; # 0 if =
77 77
         $AIV_MULT = 1.15;
78
-        $EDIT_SUMMARIES_MULT = 0.8;   # 0 if =
79
-        $NAMESPACES_MULT = 1.0;     # 0 if =
78
+        $EDIT_SUMMARIES_MULT = 0.8; # 0 if =
79
+        $NAMESPACES_MULT = 1.0; # 0 if =
80 80
         $PAGES_CREATED_LIVE_MULT = 1.4; # 0 if =
81 81
         $PAGES_CREATED_ARCHIVE_MULT = 1.4; # 0 if =
82
-        $RPP_MULT = 1.15;     # 0 if =
83
-        $USERRIGHTS_MULT = 0.75;   # 0 if =
82
+        $RPP_MULT = 1.15; # 0 if =
83
+        $USERRIGHTS_MULT = 0.75; # 0 if =
84 84
 
85 85
         // Grab the connection to the replica database (which is separate from the above)
86 86
         $conn = $this->get('doctrine')->getManager("replicas")->getConnection();
@@ -156,15 +156,15 @@  discard block
 block discarded – undo
156 156
                 $now = new DateTime();
157 157
                 $date = new DateTime($value);
158 158
                 $diff = $date->diff($now);
159
-                $formula = 365*$diff->format("%y")+30*$diff->format("%m")+$diff->format("%d");
159
+                $formula = 365 * $diff->format("%y")+30 * $diff->format("%m")+$diff->format("%d");
160 160
                 $value = $formula-365;
161 161
             }
162 162
 
163 163
             if ($key == "id") {
164 164
                 $id = $value;
165 165
             } else {
166
-                $multiplierKey = strtoupper($row["source"] . "_MULT");
167
-                $multiplier = ( isset($$multiplierKey) ? $$multiplierKey : 1 );
166
+                $multiplierKey = strtoupper($row["source"]."_MULT");
167
+                $multiplier = (isset($$multiplierKey) ? $$multiplierKey : 1);
168 168
                 $score = max(min($value * $multiplier, 100), -100);
169 169
                 $master[$key]["mult"] = $multiplier;
170 170
                 $master[$key]["value"] = $value;
@@ -174,8 +174,8 @@  discard block
 block discarded – undo
174 174
         }
175 175
 
176 176
         if ($id == 0) {
177
-            $this->addFlash("notice", [ "no-result", $username ]);
178
-            return $this->redirectToRoute("AdminScore", [ "project"=>$project ]);
177
+            $this->addFlash("notice", ["no-result", $username]);
178
+            return $this->redirectToRoute("AdminScore", ["project"=>$project]);
179 179
         }
180 180
 
181 181
         return $this->render('adminscore/result.html.twig', [
Please login to merge, or discard this patch.
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -5,7 +5,6 @@
 block discarded – undo
5 5
 use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
6 6
 use Symfony\Bundle\FrameworkBundle\Controller\Controller;
7 7
 use Symfony\Component\HttpFoundation\Request;
8
-use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
9 8
 use DateTime;
10 9
 use Xtools\ProjectRepository;
11 10
 
Please login to merge, or discard this patch.
src/AppBundle/Controller/SimpleEditCounterController.php 2 patches
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -31,10 +31,10 @@  discard block
 block discarded – undo
31 31
         $username = $request->query->get('username');
32 32
 
33 33
         if ($projectQuery != "" && $username != "") {
34
-            $routeParams = [ 'project'=>$projectQuery, 'username' => $username ];
34
+            $routeParams = ['project'=>$projectQuery, 'username' => $username];
35 35
             return $this->redirectToRoute("SimpleEditCounterResult", $routeParams);
36 36
         } elseif ($projectQuery != "") {
37
-            return $this->redirectToRoute("SimpleEditCounterProject", [ 'project'=>$projectQuery ]);
37
+            return $this->redirectToRoute("SimpleEditCounterProject", ['project'=>$projectQuery]);
38 38
         }
39 39
 
40 40
         // Otherwise fall through.
@@ -87,8 +87,8 @@  discard block
 block discarded – undo
87 87
         $resultQuery->execute();
88 88
 
89 89
         if ($resultQuery->errorCode() > 0) {
90
-            $this->addFlash("notice", [ "no-result", $username ]);
91
-            return $this->redirectToRoute("SimpleEditCounterProject", [ "project"=>$project ]);
90
+            $this->addFlash("notice", ["no-result", $username]);
91
+            return $this->redirectToRoute("SimpleEditCounterProject", ["project"=>$project]);
92 92
         }
93 93
 
94 94
         // Fetch the result data
@@ -112,16 +112,16 @@  discard block
 block discarded – undo
112 112
                 $rev = $row["value"];
113 113
             }
114 114
             if ($row["source"] == "groups") {
115
-                $groups .= $row["value"]. ", ";
115
+                $groups .= $row["value"].", ";
116 116
             }
117 117
         }
118 118
 
119 119
         // Unknown user - If the user is created the $results variable will have 3 entries.
120 120
         // This is a workaround to detect non-existent IPs.
121 121
         if (count($results) < 3 && $arch == 0 && $rev == 0) {
122
-            $this->addFlash('notice', [ "no-result", $username ]);
122
+            $this->addFlash('notice', ["no-result", $username]);
123 123
 
124
-            return $this->redirectToRoute("SimpleEditCounterProject", [ "project"=>$project ]);
124
+            return $this->redirectToRoute("SimpleEditCounterProject", ["project"=>$project]);
125 125
         }
126 126
 
127 127
         // Remove the last comma and space
@@ -151,7 +151,7 @@  discard block
 block discarded – undo
151 151
             'project_url' => $url,
152 152
             'id' => $id,
153 153
             'arch' => $arch,
154
-            'rev' => $rev + $arch,
154
+            'rev' => $rev+$arch,
155 155
             'live' => $rev,
156 156
             'groups' => $groups,
157 157
             'globalGroups' => $globalGroups,
Please login to merge, or discard this patch.
Unused Use Statements   -2 removed lines patch added patch discarded remove patch
@@ -4,9 +4,7 @@
 block discarded – undo
4 4
 
5 5
 use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
6 6
 use Symfony\Bundle\FrameworkBundle\Controller\Controller;
7
-use Symfony\Component\Config\Definition\Exception\Exception;
8 7
 use Symfony\Component\HttpFoundation\Request;
9
-use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
10 8
 use Xtools\ProjectRepository;
11 9
 
12 10
 class SimpleEditCounterController extends Controller
Please login to merge, or discard this patch.
src/AppBundle/Controller/PagesController.php 2 patches
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -6,7 +6,6 @@
 block discarded – undo
6 6
 use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
7 7
 use Symfony\Bundle\FrameworkBundle\Controller\Controller;
8 8
 use Symfony\Component\HttpFoundation\Request;
9
-use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
10 9
 use Xtools\ProjectRepository;
11 10
 
12 11
 class PagesController extends Controller
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -57,7 +57,7 @@  discard block
 block discarded – undo
57 57
                 'username' => $username,
58 58
             ]);
59 59
         } elseif ($projectQuery != "") {
60
-            return $this->redirectToRoute("PagesProject", [ 'project'=>$projectQuery ]);
60
+            return $this->redirectToRoute("PagesProject", ['project'=>$projectQuery]);
61 61
         }
62 62
 
63 63
         // set default wiki so we can populate the namespace selector
@@ -183,7 +183,7 @@  discard block
 block discarded – undo
183 183
             JOIN $revisionTable ON page_id = rev_page
184 184
             $paJoin
185 185
             WHERE $whereRev AND rev_parent_id = '0' $namespaceConditionRev $redirectCondition
186
-            " . ($hasPageAssessments ? "GROUP BY rev_page" : "") . "
186
+            ".($hasPageAssessments ? "GROUP BY rev_page" : "")."
187 187
             )
188 188
 
189 189
             UNION
@@ -267,8 +267,8 @@  discard block
 block discarded – undo
267 267
         }
268 268
 
269 269
         if ($total < 1) {
270
-            $this->addFlash("notice", [ "no-result", $username ]);
271
-            return $this->redirectToRoute("PagesProject", [ "project"=>$project ]);
270
+            $this->addFlash("notice", ["no-result", $username]);
271
+            return $this->redirectToRoute("PagesProject", ["project"=>$project]);
272 272
         }
273 273
 
274 274
         ksort($pagesByNamespaceByDate);
Please login to merge, or discard this patch.
src/AppBundle/Helper/LabsHelper.php 2 patches
Unused Use Statements   -2 removed lines patch added patch discarded remove patch
@@ -2,10 +2,8 @@
 block discarded – undo
2 2
 
3 3
 namespace AppBundle\Helper;
4 4
 
5
-use Symfony\Component\Config\Definition\Exception\Exception;
6 5
 use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
7 6
 use Symfony\Component\DependencyInjection\ContainerInterface;
8
-use Symfony\Component\VarDumper\VarDumper;
9 7
 
10 8
 class LabsHelper
11 9
 {
Please login to merge, or discard this patch.
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
         // Create the query we're going to run against the meta database
79 79
         $wikiQuery = $this->client->createQueryBuilder();
80 80
         $wikiQuery
81
-            ->select([ 'dbname', 'name', 'url', 'lang' ])
81
+            ->select(['dbname', 'name', 'url', 'lang'])
82 82
             ->from('wiki')
83 83
             ->where($wikiQuery->expr()->eq('dbname', ':project'))
84 84
             // The meta database will have the project's URL stored as https://en.wikipedia.org
@@ -129,7 +129,7 @@  discard block
 block discarded – undo
129 129
     public function allProjects()
130 130
     {
131 131
         $wikiQuery = $this->client->createQueryBuilder();
132
-        $wikiQuery->select([ 'dbName', 'name', 'url' ])->from('wiki');
132
+        $wikiQuery->select(['dbName', 'name', 'url'])->from('wiki');
133 133
         $stmt = $wikiQuery->execute();
134 134
         $out = $stmt->fetchAll();
135 135
         return $out;
@@ -152,7 +152,7 @@  discard block
 block discarded – undo
152 152
         // as required by Labs.  We combine $table with
153 153
         // $table_extension in order to generate the new table name
154 154
         if ($this->isLabs() && $table_extension !== null) {
155
-            $table = $table . "_" . $table_extension;
155
+            $table = $table."_".$table_extension;
156 156
         }
157 157
 
158 158
         // Use the table specified in the table mapping configuration, if present.
Please login to merge, or discard this patch.
src/Xtools/EditCounterRepository.php 2 patches
Doc Comments   +1 added lines, -5 removed lines patch added patch discarded remove patch
@@ -250,7 +250,6 @@  discard block
 block discarded – undo
250 250
      * Get a user's total edit count on one or more project.
251 251
      * Requires the CentralAuth extension to be installed on the project.
252 252
      *
253
-     * @param string $username The username.
254 253
      * @param Project $project The project to start from.
255 254
      * @return mixed[]|boolean Array of total edit counts, or false if none could be found.
256 255
      */
@@ -300,7 +299,7 @@  discard block
 block discarded – undo
300 299
 
301 300
     /**
302 301
      * Get total edit counts for the top 10 projects for this user.
303
-     * @param string $username The username.
302
+     * @param string $stopwatchName
304 303
      * @return string[] Elements are arrays with 'dbName', 'url', 'name', and 'total'.
305 304
      */
306 305
     protected function getRevisionCountsAllProjectsNoCentralAuth(
@@ -395,7 +394,6 @@  discard block
 block discarded – undo
395 394
 
396 395
     /**
397 396
      * Get this user's most recent 10 edits across all projects.
398
-     * @param string $username The username.
399 397
      * @param integer $topN The number of items to return.
400 398
      * @param integer $days The number of days to search from each wiki.
401 399
      * @return string[]
@@ -453,7 +451,6 @@  discard block
 block discarded – undo
453 451
 
454 452
     /**
455 453
      * Get data for a bar chart of monthly edit totals per namespace.
456
-     * @param string $username The username.
457 454
      * @return string[]
458 455
      */
459 456
     public function getMonthCounts(Project $project, User $user)
@@ -489,7 +486,6 @@  discard block
 block discarded – undo
489 486
 
490 487
     /**
491 488
      * Get yearly edit totals for this user, grouped by namespace.
492
-     * @param string $username
493 489
      * @return string[] ['<namespace>' => ['<year>' => 'total', ... ], ... ]
494 490
      */
495 491
     public function getYearCounts(Project $project, User $user)
Please login to merge, or discard this patch.
Spacing   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -18,7 +18,7 @@  discard block
 block discarded – undo
18 18
     public function getRevisionCounts(Project $project, User $user)
19 19
     {
20 20
         // Set up cache.
21
-        $cacheKey = 'revisioncounts.' . $project->getDatabaseName() . '.' . $user->getUsername();
21
+        $cacheKey = 'revisioncounts.'.$project->getDatabaseName().'.'.$user->getUsername();
22 22
         if ($this->cache->hasItem($cacheKey)) {
23 23
             return $this->cache->getItem($cacheKey)->get();
24 24
         }
@@ -79,7 +79,7 @@  discard block
 block discarded – undo
79 79
     public function getRevisionDates(Project $project, User $user)
80 80
     {
81 81
         // Set up cache.
82
-        $cacheKey = 'revisiondates.' . $project->getDatabaseName() . '.' . $user->getUsername();
82
+        $cacheKey = 'revisiondates.'.$project->getDatabaseName().'.'.$user->getUsername();
83 83
         if ($this->cache->hasItem($cacheKey)) {
84 84
             return $this->cache->getItem($cacheKey)->get();
85 85
         }
@@ -151,10 +151,10 @@  discard block
 block discarded – undo
151 151
         $results = $resultQuery->fetchAll();
152 152
 
153 153
         $pageCounts = array_combine(
154
-            array_map(function ($e) {
154
+            array_map(function($e) {
155 155
                 return $e['source'];
156 156
             }, $results),
157
-            array_map(function ($e) {
157
+            array_map(function($e) {
158 158
                 return $e['value'];
159 159
             }, $results)
160 160
         );
@@ -185,7 +185,7 @@  discard block
 block discarded – undo
185 185
 
186 186
         // Query.
187 187
         $sql = "SELECT CONCAT(log_type, '-', log_action) AS source, COUNT(log_id) AS value
188
-            FROM " . $this->getTableName($project->getDatabaseName(), 'logging') . "
188
+            FROM " . $this->getTableName($project->getDatabaseName(), 'logging')."
189 189
             WHERE log_user = :userId
190 190
             GROUP BY log_type, log_action";
191 191
         $resultQuery = $this->getProjectsConnection()->prepare($sql);
@@ -194,10 +194,10 @@  discard block
 block discarded – undo
194 194
         $resultQuery->execute();
195 195
         $results = $resultQuery->fetchAll();
196 196
         $logCounts = array_combine(
197
-            array_map(function ($e) {
197
+            array_map(function($e) {
198 198
                 return $e['source'];
199 199
             }, $results),
200
-            array_map(function ($e) {
200
+            array_map(function($e) {
201 201
                 return $e['value'];
202 202
             }, $results)
203 203
         );
@@ -346,9 +346,9 @@  discard block
 block discarded – undo
346 346
         $resultQuery->bindParam(":id", $userId);
347 347
         $resultQuery->execute();
348 348
         $results = $resultQuery->fetchAll();
349
-        $namespaceTotals = array_combine(array_map(function ($e) {
349
+        $namespaceTotals = array_combine(array_map(function($e) {
350 350
             return $e['page_namespace'];
351
-        }, $results), array_map(function ($e) {
351
+        }, $results), array_map(function($e) {
352 352
             return $e['total'];
353 353
         }, $results));
354 354
         return $namespaceTotals;
@@ -412,14 +412,14 @@  discard block
 block discarded – undo
412 412
                 $revisions = $this->cache->getItem($cacheKey)->get();
413 413
             } else {
414 414
                 $sql =
415
-                    "SELECT rev_id, rev_timestamp, UNIX_TIMESTAMP(rev_timestamp) AS unix_timestamp, " .
416
-                    " rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_comment, " .
417
-                    " page_title, page_namespace " . " FROM " .
418
-                    $this->getTableName($project['dbname'], 'revision') . "    JOIN " .
419
-                    $this->getTableName($project['dbname'], 'page') .
420
-                    "    ON (rev_page = page_id)" .
421
-                    " WHERE rev_timestamp > NOW() - INTERVAL $days DAY AND rev_user_text LIKE :username" .
422
-                    " ORDER BY rev_timestamp DESC" . " LIMIT 10";
415
+                    "SELECT rev_id, rev_timestamp, UNIX_TIMESTAMP(rev_timestamp) AS unix_timestamp, ".
416
+                    " rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_comment, ".
417
+                    " page_title, page_namespace "." FROM ".
418
+                    $this->getTableName($project['dbname'], 'revision')."    JOIN ".
419
+                    $this->getTableName($project['dbname'], 'page').
420
+                    "    ON (rev_page = page_id)".
421
+                    " WHERE rev_timestamp > NOW() - INTERVAL $days DAY AND rev_user_text LIKE :username".
422
+                    " ORDER BY rev_timestamp DESC"." LIMIT 10";
423 423
                 $resultQuery = $this->getProjectsConnection()->prepare($sql);
424 424
                 $resultQuery->bindParam(":username", $username);
425 425
                 $resultQuery->execute();
@@ -434,7 +434,7 @@  discard block
 block discarded – undo
434 434
             if (count($revisions) === 0) {
435 435
                 continue;
436 436
             }
437
-            $revsWithProject = array_map(function (&$item) use ($project) {
437
+            $revsWithProject = array_map(function(&$item) use ($project) {
438 438
                 $item['project_name'] = $project['wikiName'];
439 439
                 $item['project_url'] = $project['url'];
440 440
                 $item['project_db_name'] = $project['dbName'];
@@ -444,8 +444,8 @@  discard block
 block discarded – undo
444 444
             }, $revisions);
445 445
             $allRevisions = array_merge($allRevisions, $revsWithProject);
446 446
         }
447
-        usort($allRevisions, function ($a, $b) {
448
-            return $b['rev_timestamp'] - $a['rev_timestamp'];
447
+        usort($allRevisions, function($a, $b) {
448
+            return $b['rev_timestamp']-$a['rev_timestamp'];
449 449
         });
450 450
 
451 451
         return array_slice($allRevisions, 0, $topN);
@@ -467,12 +467,12 @@  discard block
 block discarded – undo
467 467
         $revisionTable = $this->getTableName($project->getDatabaseName(), 'revision');
468 468
         $pageTable = $this->getTableName($project->getDatabaseName(), 'page');
469 469
         $sql =
470
-            "SELECT " . "     YEAR(rev_timestamp) AS `year`," .
471
-            "     MONTH(rev_timestamp) AS `month`," . "     page_namespace," .
470
+            "SELECT "."     YEAR(rev_timestamp) AS `year`,".
471
+            "     MONTH(rev_timestamp) AS `month`,"."     page_namespace,".
472 472
             "     COUNT(rev_id) AS `count` "
473
-            . " FROM $revisionTable    JOIN $pageTable ON (rev_page = page_id)" .
474
-            " WHERE rev_user_text = :username" .
475
-            " GROUP BY YEAR(rev_timestamp), MONTH(rev_timestamp), page_namespace " .
473
+            . " FROM $revisionTable    JOIN $pageTable ON (rev_page = page_id)".
474
+            " WHERE rev_user_text = :username".
475
+            " GROUP BY YEAR(rev_timestamp), MONTH(rev_timestamp), page_namespace ".
476 476
             " ORDER BY rev_timestamp DESC";
477 477
         $resultQuery = $this->getProjectsConnection()->prepare($sql);
478 478
         $resultQuery->bindParam(":username", $username);
Please login to merge, or discard this patch.
tests/AppBundle/Controller/ApiControllerTest.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -34,7 +34,7 @@
 block discarded – undo
34 34
             $this->assertEquals(200, $client->getResponse()->getStatusCode());
35 35
 
36 36
             // Check that a correct namespace value was returned
37
-            $namespaces = (array) json_decode($client->getResponse()->getContent());
37
+            $namespaces = (array)json_decode($client->getResponse()->getContent());
38 38
             $this->assertEquals('Utilisateur', array_values($namespaces)[2]); // User in French
39 39
         }
40 40
     }
Please login to merge, or discard this patch.
app/autoload.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -8,6 +8,6 @@
 block discarded – undo
8 8
  */
9 9
 $loader = require __DIR__.'/../vendor/autoload.php';
10 10
 
11
-AnnotationRegistry::registerLoader([ $loader, 'loadClass' ]);
11
+AnnotationRegistry::registerLoader([$loader, 'loadClass']);
12 12
 
13 13
 return $loader;
Please login to merge, or discard this patch.
app/AppKernel.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -27,7 +27,7 @@
 block discarded – undo
27 27
             new AppBundle\AppBundle(),
28 28
         ];
29 29
 
30
-        if (in_array($this->getEnvironment(), [ 'dev', 'test' ], true)) {
30
+        if (in_array($this->getEnvironment(), ['dev', 'test'], true)) {
31 31
             $bundles[] = new Symfony\Bundle\DebugBundle\DebugBundle();
32 32
             $bundles[] = new Symfony\Bundle\WebProfilerBundle\WebProfilerBundle();
33 33
             $bundles[] = new Sensio\Bundle\DistributionBundle\SensioDistributionBundle();
Please login to merge, or discard this patch.