CRM-20369 mailing opened report

[civicrm-core.git] / CRM / Report / Form / Mailing / Opened.php

diff --git a/CRM/Report/Form/Mailing/Opened.php b/CRM/Report/Form/Mailing/Opened.php
index e5408d9694505f103fea31f506d5b621d7ae4e98..0943b3e915a683a8bb7950f372230673ec765359 100644 (file)
--- a/CRM/Report/Form/Mailing/Opened.php
+++ b/CRM/Report/Form/Mailing/Opened.php
@@ -110,7 +110,7 @@ class CRM_Report_Form_Mailing_Opened extends CRM_Report_Form {
       'fields' => array(
         'mailing_name' => array(
           'name' => 'name',
-          'title' => ts('Mailing'),
+          'title' => ts('Mailing Name'),
           'default' => TRUE,
         ),
         'mailing_name_alias' => array(
@@ -118,21 +118,36 @@ class CRM_Report_Form_Mailing_Opened extends CRM_Report_Form {
           'required' => TRUE,
           'no_display' => TRUE,
         ),
+        'mailing_subject' => array(
+          'name' => 'subject',
+          'title' => ts('Mailing Subject'),
+          'default' => true,
+        ),
       ),
       'filters' => array(
         'mailing_id' => array(
           'name' => 'id',
-          'title' => ts('Mailing'),
+          'title' => ts('Mailing Name'),
           'operatorType' => CRM_Report_Form::OP_MULTISELECT,
           'type' => CRM_Utils_Type::T_INT,
           'options' => CRM_Mailing_BAO_Mailing::getMailingsList(),
           'operator' => 'like',
         ),
+        'mailing_subject' => array(
+          'name' => 'subject',
+          'title' => ts('Mailing Subject'),
+          'type'=> CRM_Utils_Type::T_STRING,
+          'operator' => 'like',
+        ),
       ),
       'order_bys' => array(
         'mailing_name' => array(
           'name' => 'name',
-          'title' => ts('Mailing'),
+          'title' => ts('Mailing Name'),
+        ),
+        'mailing_subject' => array(
+          'name' => 'subject',
+          'title' => ts('Mailing Subject')
         ),
       ),
       'grouping' => 'mailing-fields',