Mwalker has uploaded a new change for review.
https://gerrit.wikimedia.org/r/108877
Change subject: FR #1332 -- Part 1; Methods
......................................................................
FR #1332 -- Part 1; Methods
Change-Id: I2fd9aeba3faad8b9188e215ce6d491c4c795b6d7
---
M FundraiserStatisticsGen/methodgen.py
1 file changed, 3 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/tools
refs/changes/77/108877/1
diff --git a/FundraiserStatisticsGen/methodgen.py
b/FundraiserStatisticsGen/methodgen.py
index c4226f8..c79637b 100644
--- a/FundraiserStatisticsGen/methodgen.py
+++ b/FundraiserStatisticsGen/methodgen.py
@@ -49,7 +49,7 @@
cur = con.cursor()
cur.execute("""
SELECT
- DATE_FORMAT(c.receive_date, "%Y-%m-%dT%H:00:00+0") as receive_date,
+ DATE_FORMAT(c.receive_date, "%Y-%m-%dT%00:00:00+0") as receive_date,
ov.label,
SUBSTR(c.source, 1, 3),
SUM(IF(c.total_amount >= 0, 1, 0)) as credit_count
@@ -57,9 +57,9 @@
LEFT JOIN civicrm_option_value ov ON
ov.option_group_id=10 AND ov.value=c.payment_instrument_id
WHERE
- c.receive_date >= '2012-12-01'
+ c.receive_date >= '2012-07-01' AND c.receive_date < '2013-07-01'
GROUP BY
- DATE_FORMAT(receive_date, "%Y-%m-%dT%H:00:00+0") ASC,
+ DATE_FORMAT(receive_date, "%Y-%m-%dT%00:00:00+0") ASC,
ov.label,
SUBSTR(c.source, 1, 3);
""")
--
To view, visit https://gerrit.wikimedia.org/r/108877
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2fd9aeba3faad8b9188e215ce6d491c4c795b6d7
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/tools
Gerrit-Branch: master
Gerrit-Owner: Mwalker <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
