jenkins-bot has submitted this change and it was merged.
Change subject: Quote date when checking for more recent contributions
......................................................................
Quote date when checking for more recent contributions
And ensure correct format is used to set wmf_donor last_donation_date
Change-Id: I7f27bdd522dc0b4e44a1a434a96a93b82aa05d7d
---
M sites/all/modules/wmf_civicrm/wmf_civicrm.module
1 file changed, 2 insertions(+), 2 deletions(-)
Approvals:
Awight: Looks good to me, approved
jenkins-bot: Verified
diff --git a/sites/all/modules/wmf_civicrm/wmf_civicrm.module
b/sites/all/modules/wmf_civicrm/wmf_civicrm.module
index 8996c51..24fce37 100644
--- a/sites/all/modules/wmf_civicrm/wmf_civicrm.module
+++ b/sites/all/modules/wmf_civicrm/wmf_civicrm.module
@@ -1790,7 +1790,7 @@
$sql = <<<EOS
SELECT id FROM civicrm_contribution
WHERE contact_id = {$contact_id}
-AND receive_date > {$receive_date}
+AND receive_date > '{$contribution_date->format( 'Y-m-d H:i:s' )}'
LIMIT 1
EOS;
$dao = CRM_Core_DAO::executeQuery( $sql );
@@ -1799,7 +1799,7 @@
}
}
if ( $latest ) {
- $wmf_donor['last_donation_date'] = $receive_date;
+ $wmf_donor['last_donation_date'] =
$contribution_date->format( 'YmdHis' );
$wmf_donor['last_donation_usd'] = $total_amount;
if ( isset( $extra['original_currency'] ) ) {
$wmf_donor['last_donation_currency'] =
$extra['original_currency'];
--
To view, visit https://gerrit.wikimedia.org/r/176157
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I7f27bdd522dc0b4e44a1a434a96a93b82aa05d7d
Gerrit-PatchSet: 2
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Ejegg <[email protected]>
Gerrit-Reviewer: Awight <[email protected]>
Gerrit-Reviewer: Ejegg <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
