/**
* 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('Action Schedule ID'), 'required' => true), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Name'), 'description' => 'Name of the action(reminder)', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Title'), 'description' => 'Title of the action(reminder)', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'recipient' => array('name' => 'recipient', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recipient'), 'description' => 'Recipient', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'limit_to' => array('name' => 'limit_to', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Limit To'), 'description' => 'Is this the recipient criteria limited to OR in addition to?'), 'entity_value' => array('name' => 'entity_value', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Value'), 'description' => 'Entity value', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'entity_status' => array('name' => 'entity_status', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Status'), 'description' => 'Entity status', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'start_action_offset' => array('name' => 'start_action_offset', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Start Action Offset'), 'description' => 'Reminder Interval.'), 'start_action_unit' => array('name' => 'start_action_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Start Action Unit'), 'description' => 'Time units for reminder.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::getRecurringFrequencyUnits')), 'start_action_condition' => array('name' => 'start_action_condition', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Start Action Condition'), 'description' => 'Reminder Action', 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'start_action_date' => array('name' => 'start_action_date', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Start Action Date'), 'description' => 'Entity date', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'is_repeat' => array('name' => 'is_repeat', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Repeat?')), 'repetition_frequency_unit' => array('name' => 'repetition_frequency_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Repetition Frequency Unit'), 'description' => 'Time units for repetition of reminder.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::getRecurringFrequencyUnits')), 'repetition_frequency_interval' => array('name' => 'repetition_frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Repetition Frequency Interval'), 'description' => 'Time interval for repeating the reminder.'), 'end_frequency_unit' => array('name' => 'end_frequency_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('End Frequency Unit'), 'description' => 'Time units till repetition of reminder.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::getRecurringFrequencyUnits')), 'end_frequency_interval' => array('name' => 'end_frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('End Frequency Interval'), 'description' => 'Time interval till repeating the reminder.'), 'end_action' => array('name' => 'end_action', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('End Action'), 'description' => 'Reminder Action till repeating the reminder.', 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('End Date'), 'description' => 'Entity end date', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Schedule is Active?'), 'description' => 'Is this option active?', 'default' => '1'), 'recipient_manual' => array('name' => 'recipient_manual', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recipient Manual'), 'description' => 'Contact IDs to which reminder should be sent.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'recipient_listing' => array('name' => 'recipient_listing', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recipient Listing'), 'description' => 'listing based on recipient field.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'body_text' => array('name' => 'body_text', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Reminder Text'), 'description' => 'Body of the mailing in text format.'), 'body_html' => array('name' => 'body_html', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Reminder HTML'), 'description' => 'Body of the mailing in html format.'), 'sms_body_text' => array('name' => 'sms_body_text', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('SMS Reminder Text'), 'description' => 'Content of the SMS text.'), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Reminder Subject'), 'description' => 'Subject of mailing', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'record_activity' => array('name' => 'record_activity', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Record Activity for Reminder?'), 'description' => 'Record Activity for this reminder?', 'default' => 'NULL'), 'mapping_id' => array('name' => 'mapping_id', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Reminder Mapping'), 'description' => 'Name/ID of the mapping to use on this table', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'group_id' => array('name' => 'group_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Reminder Group'), 'description' => 'FK to Group', 'FKClassName' => 'CRM_Contact_DAO_Group', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_group', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'msg_template_id' => array('name' => 'msg_template_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Reminder Template'), 'description' => 'FK to the message template.', 'FKClassName' => 'CRM_Core_DAO_MessageTemplate'), 'sms_template_id' => array('name' => 'sms_template_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('SMS Reminder Template'), 'description' => 'FK to the message template.', 'FKClassName' => 'CRM_Core_DAO_MessageTemplate'), 'absolute_date' => array('name' => 'absolute_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Fixed Date for Reminder'), 'description' => 'Date on which the reminder be sent.'), 'from_name' => array('name' => 'from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Reminder from Name'), 'description' => 'Name in "from" field', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'from_email' => array('name' => 'from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Reminder From Email'), 'description' => 'Email address in "from" field', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'mode' => array('name' => 'mode', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Message Mode'), 'description' => 'Send the message as email or sms or both.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'default' => 'Email', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'msg_mode', 'optionEditPath' => 'civicrm/admin/options/msg_mode')), 'sms_provider_id' => array('name' => 'sms_provider_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('SMS Provider'), 'FKClassName' => 'CRM_SMS_DAO_Provider', 'html' => array('type' => 'Select')), 'used_for' => array('name' => 'used_for', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Used For'), 'description' => 'Used for repeating entity', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'filter_contact_language' => array('name' => 'filter_contact_language', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Filter Contact Language'), 'description' => 'Used for multilingual installation', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'communication_language' => array('name' => 'communication_language', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Communication Language'), 'description' => 'Used for multilingual installation', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT));
}
return self::$_fields;
}
/**
* 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), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Name'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Title'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'recipient' => array('name' => 'recipient', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recipient'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'limit_to' => array('name' => 'limit_to', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Limit To'), 'default' => '1'), 'entity_value' => array('name' => 'entity_value', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Value'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_status' => array('name' => 'entity_status', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Status'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'start_action_offset' => array('name' => 'start_action_offset', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Start Action Offset')), 'start_action_unit' => array('name' => 'start_action_unit', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('Start Action Unit'), 'enumValues' => 'hour,day,week,month,year'), 'start_action_condition' => array('name' => 'start_action_condition', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Start Action Condition'), 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'start_action_date' => array('name' => 'start_action_date', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Start Action Date'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'is_repeat' => array('name' => 'is_repeat', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Repeat?')), 'repetition_frequency_unit' => array('name' => 'repetition_frequency_unit', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('Repetition Frequency Unit'), 'enumValues' => 'hour,day,week,month,year'), 'repetition_frequency_interval' => array('name' => 'repetition_frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Repetition Frequency Interval')), 'end_frequency_unit' => array('name' => 'end_frequency_unit', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('End Frequency Unit'), 'enumValues' => 'hour,day,week,month,year'), 'end_frequency_interval' => array('name' => 'end_frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('End Frequency Interval')), 'end_action' => array('name' => 'end_action', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('End Action'), 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('End Date'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'default' => '1'), 'recipient_manual' => array('name' => 'recipient_manual', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recipient Manual'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'recipient_listing' => array('name' => 'recipient_listing', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recipient Listing'), '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')), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'record_activity' => array('name' => 'record_activity', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Record Activity'), 'default' => 'NULL'), 'mapping_id' => array('name' => 'mapping_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_ActionMapping'), 'group_id' => array('name' => 'group_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Group', 'pseudoconstant' => array('table' => 'civicrm_group', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'msg_template_id' => array('name' => 'msg_template_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_MessageTemplate'), 'absolute_date' => array('name' => 'absolute_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Absolute Date')));
}
return self::$_fields;
}
