/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'required' => true), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_Domain'), 'header_id' => array('name' => 'header_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'footer_id' => array('name' => 'footer_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'reply_id' => array('name' => 'reply_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'unsubscribe_id' => array('name' => 'unsubscribe_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'resubscribe_id' => array('name' => 'resubscribe_id', 'type' => CRM_Utils_Type::T_INT), 'optout_id' => array('name' => 'optout_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'from_name' => array('name' => 'from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('From Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'from_email' => array('name' => 'from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('From Email'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'replyto_email' => array('name' => 'replyto_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Replyto Email'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'body_text' => array('name' => 'body_text', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Body Text')), 'body_html' => array('name' => 'body_html', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Body Html')), 'url_tracking' => array('name' => 'url_tracking', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Url Tracking')), 'forward_replies' => array('name' => 'forward_replies', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Forward Replies')), 'auto_responder' => array('name' => 'auto_responder', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Auto Responder')), 'open_tracking' => array('name' => 'open_tracking', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Open Tracking')), 'is_completed' => array('name' => 'is_completed', 'type' => CRM_Utils_Type::T_BOOLEAN), 'msg_template_id' => array('name' => 'msg_template_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_MessageTemplate'), 'override_verp' => array('name' => 'override_verp', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Override Verp')), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Created Date')), 'scheduled_id' => array('name' => 'scheduled_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'scheduled_date' => array('name' => 'scheduled_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Scheduled Date')), 'approver_id' => array('name' => 'approver_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'approval_date' => array('name' => 'approval_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Approved Date')), 'approval_status_id' => array('name' => 'approval_status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Approval Status'), 'pseudoconstant' => array('optionGroupName' => 'mail_approval_status')), 'approval_note' => array('name' => 'approval_note', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Approval Note')), 'is_archived' => array('name' => 'is_archived', 'type' => CRM_Utils_Type::T_BOOLEAN), 'visibility' => array('name' => 'visibility', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('Visibility'), 'default' => 'User and User Admin Only', 'enumValues' => 'User and User Admin Only,Public Pages'), 'campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'dedupe_email' => array('name' => 'dedupe_email', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Dedupe Email')), 'sms_provider_id' => array('name' => 'sms_provider_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_SMS_DAO_Provider'));
}
return self::$_fields;
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing ID'), 'required' => true), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Domain'), 'description' => 'Which site is this mailing for', 'FKClassName' => 'CRM_Core_DAO_Domain', 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'header_id' => array('name' => 'header_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Header'), 'description' => 'FK to the header component.', 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'footer_id' => array('name' => 'footer_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Footer'), 'description' => 'FK to the footer component.', 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'reply_id' => array('name' => 'reply_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Reply'), 'description' => 'FK to the auto-responder component.', 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'unsubscribe_id' => array('name' => 'unsubscribe_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Unsubscribe'), 'description' => 'FK to the unsubscribe component.', 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'resubscribe_id' => array('name' => 'resubscribe_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Resubscribe')), 'optout_id' => array('name' => 'optout_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Opt Out'), 'description' => 'FK to the opt-out component.', 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing Name'), 'description' => 'Mailing Name.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'mailing_type' => array('name' => 'mailing_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing Type'), 'description' => 'differentiate between standalone mailings, A/B tests, and A/B final-winner', 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Mailing_PseudoConstant::mailingTypes')), 'from_name' => array('name' => 'from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing From Name'), 'description' => 'From Header of mailing', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'from_email' => array('name' => 'from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing From Email'), 'description' => 'From Email of mailing', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'replyto_email' => array('name' => 'replyto_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Replyto Email'), 'description' => 'Reply-To Email of mailing', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'description' => 'Subject of mailing', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'body_text' => array('name' => 'body_text', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Body Text'), 'description' => 'Body of the mailing in text format.'), 'body_html' => array('name' => 'body_html', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Body Html'), 'description' => 'Body of the mailing in html format.'), 'url_tracking' => array('name' => 'url_tracking', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Url Tracking'), 'description' => 'Should we track URL click-throughs for this mailing?', 'html' => array('type' => 'CheckBox')), 'forward_replies' => array('name' => 'forward_replies', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Forward Replies'), 'description' => 'Should we forward replies back to the author?', 'html' => array('type' => 'CheckBox')), 'auto_responder' => array('name' => 'auto_responder', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Auto Responder'), 'description' => 'Should we enable the auto-responder?', 'html' => array('type' => 'CheckBox')), 'open_tracking' => array('name' => 'open_tracking', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Track Mailing?'), 'description' => 'Should we track when recipients open/read this mailing?'), 'is_completed' => array('name' => 'is_completed', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Mailing Completed'), 'description' => 'Has at least one job associated with this mailing finished?', 'html' => array('type' => 'CheckBox')), 'msg_template_id' => array('name' => 'msg_template_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Message Template'), 'description' => 'FK to the message template.', 'FKClassName' => 'CRM_Core_DAO_MessageTemplate'), 'override_verp' => array('name' => 'override_verp', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Override Verp'), 'description' => 'Should we overrite VERP address in Reply-To', 'html' => array('type' => 'CheckBox')), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Creator'), 'description' => 'FK to Contact ID who first created this mailing', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Created Date'), 'description' => 'Date and time this mailing was created.', 'html' => array('type' => 'Select Date')), 'scheduled_id' => array('name' => 'scheduled_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Scheduled By'), 'description' => 'FK to Contact ID who scheduled this mailing', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'scheduled_date' => array('name' => 'scheduled_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Scheduled Date'), 'description' => 'Date and time this mailing was scheduled.'), 'approver_id' => array('name' => 'approver_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Approved By'), 'description' => 'FK to Contact ID who approved this mailing', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'approval_date' => array('name' => 'approval_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Approved Date'), 'description' => 'Date and time this mailing was approved.'), 'approval_status_id' => array('name' => 'approval_status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Approval Status'), 'description' => 'The status of this mailing. Values: none, approved, rejected', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'mail_approval_status', 'optionEditPath' => 'civicrm/admin/options/mail_approval_status')), 'approval_note' => array('name' => 'approval_note', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Approval Note'), 'description' => 'Note behind the decision.', 'html' => array('type' => 'TextArea')), 'is_archived' => array('name' => 'is_archived', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Mailing Archived?'), 'description' => 'Is this mailing archived?', 'html' => array('type' => 'CheckBox')), 'visibility' => array('name' => 'visibility', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing Visibility'), 'description' => 'In what context(s) is the mailing contents visible (online viewing)', 'maxlength' => 40, 'size' => CRM_Utils_Type::BIG, 'default' => 'Public Pages', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::groupVisibility')), 'campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Campaign'), 'description' => 'The campaign for which this mailing has been initiated.', 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'dedupe_email' => array('name' => 'dedupe_email', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('No Duplicate emails?'), 'description' => 'Remove duplicate emails?', 'html' => array('type' => 'CheckBox')), 'sms_provider_id' => array('name' => 'sms_provider_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing SMS Provider'), 'FKClassName' => 'CRM_SMS_DAO_Provider', 'html' => array('type' => 'Select')), 'hash' => array('name' => 'hash', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing Hash'), 'description' => 'Key for validating requests related to this mailing.', 'maxlength' => 16, 'size' => CRM_Utils_Type::TWELVE), 'location_type_id' => array('name' => 'location_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Location Type'), 'description' => 'With email_selection_method, determines which email address to use', 'FKClassName' => 'CRM_Core_DAO_LocationType', 'pseudoconstant' => array('table' => 'civicrm_location_type', 'keyColumn' => 'id', 'labelColumn' => 'display_name')), 'email_selection_method' => array('name' => 'email_selection_method', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Email Selection Method'), 'description' => 'With location_type_id, determine how to choose the email address to use.', 'maxlength' => 20, 'size' => CRM_Utils_Type::MEDIUM, 'default' => 'automatic', 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::emailSelectMethods')));
}
return self::$_fields;
}
/**
* returns all the column names of this table
*
* @access public
* @return array
*/
function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'required' => true), 'header_id' => array('name' => 'header_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'footer_id' => array('name' => 'footer_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'reply_id' => array('name' => 'reply_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'unsubscribe_id' => array('name' => 'unsubscribe_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'resubscribe_id' => array('name' => 'resubscribe_id', 'type' => CRM_Utils_Type::T_INT), 'optout_id' => array('name' => 'optout_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Mailing_DAO_Component'), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'from_name' => array('name' => 'from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('From Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'from_email' => array('name' => 'from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('From Email'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'replyto_email' => array('name' => 'replyto_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Replyto Email'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'body_text' => array('name' => 'body_text', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Body Text')), 'body_html' => array('name' => 'body_html', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Body Html')), 'url_tracking' => array('name' => 'url_tracking', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Url Tracking')), 'forward_replies' => array('name' => 'forward_replies', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Forward Replies')), 'auto_responder' => array('name' => 'auto_responder', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Auto Responder')), 'open_tracking' => array('name' => 'open_tracking', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Open Tracking')), 'is_completed' => array('name' => 'is_completed', 'type' => CRM_Utils_Type::T_BOOLEAN), 'msg_template_id' => array('name' => 'msg_template_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_MessageTemplates'), 'override_verp' => array('name' => 'override_verp', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Override Verp')), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Mailing Created Date')), 'scheduled_id' => array('name' => 'scheduled_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'is_archived' => array('name' => 'is_archived', 'type' => CRM_Utils_Type::T_BOOLEAN));
}
return self::$_fields;
}
