/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('activity_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_activity.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'source_contact_id' => array('name' => 'source_contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Source Contact'), 'import' => true, 'where' => 'civicrm_activity.source_contact_id', 'headerPattern' => '/(activity.)?source(.contact(.id)?)?/i', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'source_record_id' => array('name' => 'source_record_id', 'type' => CRM_Utils_Type::T_INT), 'activity_type_id' => array('name' => 'activity_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity Type ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_activity.activity_type_id', 'headerPattern' => '/(activity.)?type(.id$)/i', 'dataPattern' => '', 'export' => false, 'default' => ''), 'activity_subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_activity.subject', 'headerPattern' => '/(activity.)?subject/i', 'dataPattern' => '', 'export' => true), 'activity_date_time' => array('name' => 'activity_date_time', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Activity Date'), 'import' => true, 'where' => 'civicrm_activity.activity_date_time', 'headerPattern' => '/(activity.)?date(.time$)?/i', 'dataPattern' => '', 'export' => true), 'activity_duration' => array('name' => 'duration', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Duration'), 'import' => true, 'where' => 'civicrm_activity.duration', 'headerPattern' => '/(activity.)?duration(s)?$/i', 'dataPattern' => '', 'export' => true), 'activity_location' => array('name' => 'location', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Location'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_activity.location', 'headerPattern' => '/(activity.)?location$/i', 'dataPattern' => '', 'export' => true), 'phone_id' => array('name' => 'phone_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_Phone'), 'phone_number' => array('name' => 'phone_number', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Phone Number'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'activity_details' => array('name' => 'details', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Details'), 'rows' => 8, 'cols' => 60, 'import' => true, 'where' => 'civicrm_activity.details', 'headerPattern' => '/(activity.)?detail(s)?$/i', 'dataPattern' => '', 'export' => true), 'activity_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity Status Id'), 'import' => true, 'where' => 'civicrm_activity.status_id', 'headerPattern' => '/(activity.)?status(.label$)?/i', 'dataPattern' => '', 'export' => false), 'priority_id' => array('name' => 'priority_id', 'type' => CRM_Utils_Type::T_INT), 'parent_id' => array('name' => 'parent_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Activity_DAO_Activity'), 'activity_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_activity.is_test', 'headerPattern' => '/(is.)?test(.activity)?/i', 'dataPattern' => '', 'export' => true), 'activity_medium_id' => array('name' => 'medium_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity Medium'), 'default' => 'UL'), 'is_auto' => array('name' => 'is_auto', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Auto')), 'relationship_id' => array('name' => 'relationship_id', 'type' => CRM_Utils_Type::T_INT, 'default' => 'UL', 'FKClassName' => 'CRM_Contact_DAO_Relationship'), 'is_current_revision' => array('name' => 'is_current_revision', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is this activity a current revision in versioning chain?'), 'import' => true, 'where' => 'civicrm_activity.is_current_revision', 'headerPattern' => '/(is.)?(current.)?(revision|version(ing)?)/i', 'dataPattern' => '', 'export' => true, 'default' => ''), 'original_id' => array('name' => 'original_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Activity_DAO_Activity'), 'activity_result' => array('name' => 'result', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Result'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'activity_is_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Activity is in the Trash'), 'import' => true, 'where' => 'civicrm_activity.is_deleted', 'headerPattern' => '/(activity.)?(trash|deleted)/i', 'dataPattern' => '', 'export' => true), 'activity_campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign ID'), 'import' => true, 'where' => 'civicrm_activity.campaign_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Campaign_DAO_Campaign'), 'activity_engagement_level' => array('name' => 'engagement_level', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Engagement Index'), 'import' => true, 'where' => 'civicrm_activity.engagement_level', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Weight')));
}
return self::$_fields;
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('activity_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity ID'), 'description' => 'Unique Other Activity ID', 'required' => true, 'import' => true, 'where' => 'civicrm_activity.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'source_record_id' => array('name' => 'source_record_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Source Record'), 'description' => 'Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Table can be figured out through activity_type_id, and further through component registry.'), 'activity_type_id' => array('name' => 'activity_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity Type ID'), 'description' => 'FK to civicrm_option_value.id, that has to be valid, registered activity type.', 'required' => true, 'import' => true, 'where' => 'civicrm_activity.activity_type_id', 'headerPattern' => '/(activity.)?type(.id$)/i', 'dataPattern' => '', 'export' => true, 'default' => '1', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'activity_type', 'optionEditPath' => 'civicrm/admin/options/activity_type')), 'activity_subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'description' => 'The subject/purpose/short description of the activity.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_activity.subject', 'headerPattern' => '/(activity.)?subject/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'activity_date_time' => array('name' => 'activity_date_time', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Activity Date'), 'description' => 'Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.', 'import' => true, 'where' => 'civicrm_activity.activity_date_time', 'headerPattern' => '/(activity.)?date(.time$)?/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'activity_duration' => array('name' => 'duration', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Duration'), 'description' => 'Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes.', 'import' => true, 'where' => 'civicrm_activity.duration', 'headerPattern' => '/(activity.)?duration(s)?$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'activity_location' => array('name' => 'location', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Location'), 'description' => 'Location of the activity (optional, open text).', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_activity.location', 'headerPattern' => '/(activity.)?location$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'phone_id' => array('name' => 'phone_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Phone (called) ID'), 'description' => 'Phone ID of the number called (optional - used if an existing phone number is selected).', 'FKClassName' => 'CRM_Core_DAO_Phone', 'html' => array('type' => 'EntityRef')), 'phone_number' => array('name' => 'phone_number', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Phone (called) Number'), 'description' => 'Phone number in case the number does not exist in the civicrm_phone table.', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'html' => array('type' => 'Text')), 'activity_details' => array('name' => 'details', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Details'), 'description' => 'Details about the activity (agenda, notes, etc).', 'import' => true, 'where' => 'civicrm_activity.details', 'headerPattern' => '/(activity.)?detail(s)?$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'RichTextEditor')), 'activity_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity Status'), 'description' => 'ID of the status this activity is currently in. Foreign key to civicrm_option_value.', 'import' => true, 'where' => 'civicrm_activity.status_id', 'headerPattern' => '/(activity.)?status(.label$)?/i', 'dataPattern' => '', 'export' => false, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'activity_status', 'optionEditPath' => 'civicrm/admin/options/activity_status')), 'priority_id' => array('name' => 'priority_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Priority'), 'description' => 'ID of the priority given to this activity. Foreign key to civicrm_option_value.', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'priority', 'optionEditPath' => 'civicrm/admin/options/priority')), 'parent_id' => array('name' => 'parent_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Parent Activity Id'), 'description' => 'Parent meeting ID (if this is a follow-up item). This is not currently implemented', 'FKClassName' => 'CRM_Activity_DAO_Activity'), 'activity_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_activity.is_test', 'headerPattern' => '/(is.)?test(.activity)?/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select')), 'activity_medium_id' => array('name' => 'medium_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Activity Medium'), 'description' => 'Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.', 'default' => 'NULL', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'encounter_medium', 'optionEditPath' => 'civicrm/admin/options/encounter_medium')), 'is_auto' => array('name' => 'is_auto', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Auto')), 'relationship_id' => array('name' => 'relationship_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Relationship Id'), 'description' => 'FK to Relationship ID', 'default' => 'NULL', 'FKClassName' => 'CRM_Contact_DAO_Relationship'), 'is_current_revision' => array('name' => 'is_current_revision', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is this activity a current revision in versioning chain?'), 'import' => true, 'where' => 'civicrm_activity.is_current_revision', 'headerPattern' => '/(is.)?(current.)?(revision|version(ing)?)/i', 'dataPattern' => '', 'export' => true, 'default' => '1', 'html' => array('type' => 'CheckBox')), 'original_id' => array('name' => 'original_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Original Activity ID '), 'description' => 'Activity ID of the first activity record in versioning chain.', 'FKClassName' => 'CRM_Activity_DAO_Activity'), 'activity_result' => array('name' => 'result', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Result'), 'description' => 'Currently being used to store result id for survey activity, FK to option value.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'activity_is_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Activity is in the Trash'), 'import' => true, 'where' => 'civicrm_activity.is_deleted', 'headerPattern' => '/(activity.)?(trash|deleted)/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'activity_campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign'), 'description' => 'The campaign for which this activity has been triggered.', 'import' => true, 'where' => 'civicrm_activity.campaign_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'html' => array('type' => 'CheckBox'), 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'activity_engagement_level' => array('name' => 'engagement_level', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Engagement Index'), 'description' => 'Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.', 'import' => true, 'where' => 'civicrm_activity.engagement_level', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'engagement_index', 'optionEditPath' => 'civicrm/admin/options/engagement_index')), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Order'), 'html' => array('type' => 'Text')));
}
return self::$_fields;
}
