Ejegg has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/375027 )
Change subject: Resolve ty batch start timestamp in PHP
......................................................................
Resolve ty batch start timestamp in PHP
Bug: T149745
Change-Id: I81cde571e7dbb9459aa036200ee924694a1ad7a3
---
M sites/all/modules/thank_you/thank_you.module
1 file changed, 4 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm
refs/changes/27/375027/1
diff --git a/sites/all/modules/thank_you/thank_you.module
b/sites/all/modules/thank_you/thank_you.module
index 796cea9..e6fbb6c 100644
--- a/sites/all/modules/thank_you/thank_you.module
+++ b/sites/all/modules/thank_you/thank_you.module
@@ -1,5 +1,6 @@
<?php
+use SmashPig\Core\UtcDate;
use wmf_communication\CiviMailStore;
use wmf_communication\CiviMailingInsertException;
use wmf_communication\CiviMailingMissingException;
@@ -732,19 +733,20 @@
$dbs = wmf_civicrm_get_dbs();
$dbs->push( 'civicrm' );
+ $earliest = UtcDate::getUtcDatabaseString( "-$days days" );
$ty_query = <<<EOT
SELECT civicrm_contribution.id, trxn_id
FROM civicrm_contribution
JOIN wmf_contribution_extra
ON wmf_contribution_extra.entity_id =
civicrm_contribution.id
WHERE
- receive_date > DATE_SUB( NOW(), INTERVAL :interval DAY
) AND
+ receive_date > :earliest AND
thankyou_date IS NULL AND
no_thank_you IS NULL
ORDER BY receive_date ASC LIMIT {$batch};
EOT;
- $result = db_query( $ty_query, array( ':interval' => $days ) );
+ $result = db_query( $ty_query, array( ':earliest' => $earliest ) );
$count = 0;
$consecutiveFailures = 0;
--
To view, visit https://gerrit.wikimedia.org/r/375027
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I81cde571e7dbb9459aa036200ee924694a1ad7a3
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm
Gerrit-Branch: master
Gerrit-Owner: Ejegg <ej...@ejegg.com>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
