"Jpostlethwaite" posted a comment on Wikimedia.r1336. URL: http://www.mediawiki.org/wiki/Special:Code/Wikimedia/1336#c31517
Commit summary for Wikimedia.r1336: Added two methods to query the database for payments: _civicrm_recurring_globalcollect_get_next_sched_contribution() and _civicrm_recurring_globalcollect_get_failure_retry_date(). See r1335. Jpostlethwaite's comment: I will run a few tests with some sample data to see which is better. Here are three possible search patterns: 1. Using LIKE: <pre> `civicrm_contribution_recur`.`next_sched_contribution` LIKE '2011-12-31%' </pre> 2. Using BETWEEN: <pre> `civicrm_contribution_recur`.`next_sched_contribution` BETWEEN '2012-12-31 00:00:00' AND '2012-12-31 23:59:59' </pre> 3. Using greater or less: <pre> `civicrm_contribution_recur`.`next_sched_contribution` >= '2012-12-31 00:00:00' AND `civicrm_contribution_recur`.`next_sched_contribution` <= '2012-12-31 23:59:59' </pre> _______________________________________________ MediaWiki-CodeReview mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-codereview
