@@ -41,7 +41,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -27,9 +27,9 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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', [ |
@@ -5,7 +5,6 @@ |
||
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 |
@@ -31,10 +31,10 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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, |
@@ -4,9 +4,7 @@ |
||
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 |
@@ -6,7 +6,6 @@ |
||
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 |
@@ -57,7 +57,7 @@ discard block |
||
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 |
||
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 |
||
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); |
@@ -2,10 +2,8 @@ |
||
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 | { |
@@ -78,7 +78,7 @@ discard block |
||
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 |
||
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 |
||
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. |
@@ -250,7 +250,6 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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) |
@@ -18,7 +18,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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); |
@@ -34,7 +34,7 @@ |
||
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 | } |
@@ -8,6 +8,6 @@ |
||
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; |
@@ -27,7 +27,7 @@ |
||
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(); |