DataObjects/Core_email.php
authorleon <leon@roojs.com>
Mon, 7 Mar 2022 04:34:54 +0000 (12:34 +0800)
committerleon <leon@roojs.com>
Mon, 7 Mar 2022 04:34:54 +0000 (12:34 +0800)
DataObjects/Core_email.php

index 1166a0c..8b3c097 100644 (file)
@@ -142,6 +142,10 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject
                             crm_mailing_list_queue cmlq 
                         WHERE message_id = crm_mailing_list_message.id
                     )
+                AND 
+                    event_id > 0
+                AND 
+                    sent IS NOT NULL
                 AND 
                     is_open = 1
             )  
@@ -168,6 +172,10 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject
                             crm_mailing_list_queue cmlq 
                         WHERE message_id = crm_mailing_list_message.id
                     )
+                AND 
+                    event_id > 0
+                AND 
+                    sent IS NOT NULL
                 AND 
                     is_open = 1
             )