From 99b0f1ebf2c4583557486e75fe82a10efec87388 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Tue, 13 Aug 2019 09:12:20 -0400 Subject: [PATCH] Per Adam to include also the contact with no renewal date. Includeing accounts with no renewal date set. --- models/admin/ajax/contactsListExport.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/models/admin/ajax/contactsListExport.php b/models/admin/ajax/contactsListExport.php index 6d35ffb..5047e80 100644 --- a/models/admin/ajax/contactsListExport.php +++ b/models/admin/ajax/contactsListExport.php @@ -148,8 +148,8 @@ class GlmMembersAdmin_ajax_contactsListExport extends GlmDataContacts $where .= " AND T.ref_dest IN ( SELECT DISTINCT(ref_dest) FROM " . GLM_MEMBERS_BILLING_PLUGIN_DB_PREFIX . "accounts - WHERE renewal_date IS NOT NULL - AND renewal_date > ( NOW() - INTERVAL 1 YEAR - INTERVAL 3 MONTH ) + WHERE renewal_date IS NULL + OR (renewal_date > ( NOW() - INTERVAL 1 YEAR - INTERVAL 3 MONTH )) ) "; } -- 2.17.1