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