Niharika29 has uploaded a new change for review.
https://gerrit.wikimedia.org/r/197897
Change subject: Fix review queue to show my unreviewed, globally unreviewed, all
......................................................................
Fix review queue to show my unreviewed, globally unreviewed, all
Change-Id: I7394899ab6616b9cf4210ec2d0f000f47866837d
---
M src/Dao/Proposals.php
1 file changed, 5 insertions(+), 5 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/iegreview
refs/changes/97/197897/1
diff --git a/src/Dao/Proposals.php b/src/Dao/Proposals.php
index fcb0898..d25408e 100644
--- a/src/Dao/Proposals.php
+++ b/src/Dao/Proposals.php
@@ -131,7 +131,7 @@
'title' => null,
'theme' => null,
'campaign' => null,
- 'sort' => 'id',
+ 'sort' => 'title',
'order' => 'asc',
'items' => 20,
'page' => 0,
@@ -196,14 +196,14 @@
}
$reviewCountSql = self::concat(
- 'SELECT proposal, count(*) as reviews',
- 'FROM reviews',
+ 'SELECT proposal, count(DISTINCT proposal, reviewer) as
reviews',
+ 'FROM review_answers',
'GROUP BY proposal'
);
$myReviewCountSql = self::concat(
- 'SELECT proposal, count(*) as myreviews',
- 'FROM reviews',
+ 'SELECT proposal, count(DISTINCT proposal, reviewer) as
myreviews',
+ 'FROM review_answers',
'WHERE reviewer = :int_userid',
'GROUP BY proposal'
);
--
To view, visit https://gerrit.wikimedia.org/r/197897
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I7394899ab6616b9cf4210ec2d0f000f47866837d
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/iegreview
Gerrit-Branch: master
Gerrit-Owner: Niharika29 <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
