"Jpostlethwaite" posted a comment on Wikimedia.r1212. URL: http://www.mediawiki.org/wiki/Special:Code/Wikimedia/1212#c30660
Commit summary for Wikimedia.r1212: Adding module for Global Collect recurring payments. Jpostlethwaite's comment: This is a first stab at two queries that may be used: IF `cycle_day` is greater than the last day of the month: <pre> SELECT `civicrm_contribution_recur`.* FROM `civicrm_contribution_recur` WHERE ( `end_date` = '0000-00-00 00:00:00' OR `end_date` IS NULL ) AND ( `next_sched_contribution` < NOW() OR `failure_retry_date` < NOW() ) AND `failure_count` < 3 AND `cycle_day` > 28 LIMIT 1 </pre> // `cycle_day` = DAYOFMONTH( NOW() ) else: <pre> SELECT `civicrm_contribution_recur`.* FROM `civicrm_contribution_recur` WHERE ( `end_date` = '0000-00-00 00:00:00' OR `end_date` IS NULL ) AND ( `next_sched_contribution` < NOW() OR `failure_retry_date` < NOW() ) AND `failure_count` < 3 AND `cycle_day` = DAYOFMONTH( NOW() ) LIMIT 1 </pre> _______________________________________________ MediaWiki-CodeReview mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-codereview
