From a6f3544ff3bfd978b760376f50f5e368dbfd4a57 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 31 Jul 2019 13:00:58 -0400 Subject: [PATCH] Updating the flag for export contact for (billing active) When comparing renewal date go 1 year and 3 months from now. --- models/admin/ajax/contactsListExport.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/models/admin/ajax/contactsListExport.php b/models/admin/ajax/contactsListExport.php index 329f8b9..6d35ffb 100644 --- a/models/admin/ajax/contactsListExport.php +++ b/models/admin/ajax/contactsListExport.php @@ -149,7 +149,7 @@ class GlmMembersAdmin_ajax_contactsListExport extends GlmDataContacts SELECT DISTINCT(ref_dest) FROM " . GLM_MEMBERS_BILLING_PLUGIN_DB_PREFIX . "accounts WHERE renewal_date IS NOT NULL - AND renewal_date + INTERVAL 1 YEAR + INTERVAL $days_after_expired DAY > '$current_date' + AND renewal_date > ( NOW() - INTERVAL 1 YEAR - INTERVAL 3 MONTH ) ) "; } -- 2.17.1