Ejegg has uploaded a new change for review.
https://gerrit.wikimedia.org/r/324261
Change subject: WIP bandaid for big english board
......................................................................
WIP bandaid for big english board
Really need to allow a generic campaign with configurable start and
end dates. This fix is only good through Dec 29th, and still needs
labels fixed.
Bug: T151820
Change-Id: Id41536ca0613d698305dbfc2cac2540cf9f3514c
---
M widgets/big-english.js
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/dash
refs/changes/61/324261/1
diff --git a/widgets/big-english.js b/widgets/big-english.js
index aac55d6..45600c2 100644
--- a/widgets/big-english.js
+++ b/widgets/big-english.js
@@ -3,7 +3,7 @@
module.exports = {
name: 'big-english',
- query: 'select count(*) as donations, sum(total_amount) as usd_total,\n
IF( day(receive_date) = day(utc_timestamp()) and hour(receive_date) =
hour(utc_timestamp()), CEILING(TIMESTAMPDIFF(SECOND, MIN(receive_date),
MAX(receive_date))/60), 60) as minutes, sum(total_amount)/IF( day(receive_date)
= day(utc_timestamp()) and hour(receive_date) = hour(utc_timestamp()),
CEILING(TIMESTAMPDIFF(SECOND, MIN(receive_date), MAX(receive_date))/60), 60)/60
as usd_per_second, DAY(receive_date) as day, HOUR(receive_date) as hour from '
+ config.civicrmDb + '.civicrm_contribution cc [[WHERE]] GROUP BY
DAY(receive_date), HOUR(receive_date) ORDER BY day ASC, hour ASC;',
+ query: 'select count(*) as donations, sum(total_amount) as usd_total,\n
IF( day(receive_date) = day(utc_timestamp()) and hour(receive_date) =
hour(utc_timestamp()), CEILING(TIMESTAMPDIFF(SECOND, MIN(receive_date),
MAX(receive_date))/60), 60) as minutes, sum(total_amount)/IF( day(receive_date)
= day(utc_timestamp()) and hour(receive_date) = hour(utc_timestamp()),
CEILING(TIMESTAMPDIFF(SECOND, MIN(receive_date), MAX(receive_date))/60), 60)/60
as usd_per_second, DAYOFYEAR(receive_date) - 333 as day, HOUR(receive_date) as
hour from ' + config.civicrmDb + '.civicrm_contribution cc WHERE receive_date
BETWEEN \'2016-11-29\' AND \'2017-01-01\' GROUP BY DAYOFYEAR(receive_date) -
333, HOUR(receive_date) ORDER BY day ASC, hour ASC;',
mainTableAlias: 'cc',
optionalJoins: {},
filters: commonFilters.civicrmContribution,
--
To view, visit https://gerrit.wikimedia.org/r/324261
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Id41536ca0613d698305dbfc2cac2540cf9f3514c
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/dash
Gerrit-Branch: master
Gerrit-Owner: Ejegg <eeggles...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
