/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Address Format ID'), 'description' => 'Address Format Id', 'required' => true), 'format' => array('name' => 'format', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Address Format'), 'description' => 'The format of an address'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('World Region ID'), 'description' => 'Country Id', 'required' => true), 'world_region' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('World Region'), 'description' => 'Region name to be associated with countries', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'export' => true, 'where' => 'civicrm_worldregion.name', 'headerPattern' => '', 'dataPattern' => ''));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['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')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Premium ID'), 'required' => true), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Premium Entity'), 'description' => 'Joins these premium settings to another object. Always civicrm_contribution_page for now.', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Premium entity ID'), 'required' => true), 'premiums_active' => array('name' => 'premiums_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Premium Active?'), 'description' => 'Is the Premiums feature enabled for this page?', 'required' => true), 'premiums_intro_title' => array('name' => 'premiums_intro_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Title for Premiums section'), 'description' => 'Title for Premiums section.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'premiums_intro_text' => array('name' => 'premiums_intro_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Premium Introductory Text'), 'description' => 'Displayed in <div> at top of Premiums section of page. Text and HTML allowed.'), 'premiums_contact_email' => array('name' => 'premiums_contact_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Premium Contact Email'), 'description' => 'This email address is included in receipts if it is populated and a premium has been selected.', 'maxlength' => 100, 'size' => CRM_Utils_Type::HUGE), 'premiums_contact_phone' => array('name' => 'premiums_contact_phone', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Premiums Contact Phone'), 'description' => 'This phone number is included in receipts if it is populated and a premium has been selected.', 'maxlength' => 50, 'size' => CRM_Utils_Type::BIG), 'premiums_display_min_contribution' => array('name' => 'premiums_display_min_contribution', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Display Minimum Contribution?'), 'description' => 'Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.', 'required' => true), 'premiums_nothankyou_label' => array('name' => 'premiums_nothankyou_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('No Thank-you Text'), 'description' => 'Label displayed for No Thank-you option in premiums block (e.g. No thank you)', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'premiums_nothankyou_position' => array('name' => 'premiums_nothankyou_position', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('No Thank-you Position'), 'default' => '1'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('PCP Block ID'), 'description' => 'PCP block Id', 'required' => true), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Table'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Entity'), 'description' => 'FK to civicrm_contribution_page.id OR civicrm_event.id', 'required' => true), 'target_entity_type' => array('name' => 'target_entity_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Target Entity'), 'description' => 'The type of entity that this pcp targets', 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'contribute'), 'target_entity_id' => array('name' => 'target_entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Target Entity ID'), 'description' => 'The entity that this pcp targets', 'required' => true), 'supporter_profile_id' => array('name' => 'supporter_profile_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Supporter Profile'), 'description' => 'FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?', 'default' => 'NULL', 'FKClassName' => 'CRM_Core_DAO_UFGroup'), 'owner_notify_id' => array('name' => 'owner_notify_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Owner Notification'), 'description' => 'FK to civicrm_option_group with name = PCP owner notifications', 'html' => array('type' => 'Radio'), 'pseudoconstant' => array('optionGroupName' => 'pcp_owner_notify', 'optionEditPath' => 'civicrm/admin/options/pcp_owner_notify')), 'is_approval_needed' => array('name' => 'is_approval_needed', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Approval Required?'), 'description' => 'Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)?', 'default' => 'NULL'), 'is_tellfriend_enabled' => array('name' => 'is_tellfriend_enabled', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Tell a Friend Enabled?'), 'description' => 'Does Personal Campaign Page allow using tell a friend?', 'default' => 'NULL'), 'tellfriend_limit' => array('name' => 'tellfriend_limit', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Tell A Friend Limit'), 'description' => 'Maximum recipient fields allowed in tell a friend', 'default' => 'NULL'), 'link_text' => array('name' => 'link_text', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Link Text'), 'description' => 'Link text for PCP.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'NULL'), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Enabled?'), 'description' => 'Is Personal Campaign Page Block enabled/active?', 'default' => '1'), 'notify_email' => array('name' => 'notify_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Notification Email'), 'description' => 'If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'NULL'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Type ID'), 'description' => 'ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp', 'required' => true), 'financial_type' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Financial Type'), 'description' => 'Financial Type Name.', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_financial_type.name', 'headerPattern' => '/(finan(cial)?)?type/i', 'dataPattern' => '/donation|member|campaign/i', 'export' => true), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Description'), 'description' => 'Financial Type Description.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'is_deductible' => array('name' => 'is_deductible', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Tax Deductible?'), 'description' => 'Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.', 'default' => '1'), 'is_reserved' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Financial Type is Reserved?'), 'description' => 'Is this a predefined system object?'), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Financial Type Is Active?'), 'description' => 'Is this property active?'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'description' => 'Unique Contact ID', 'required' => true, 'import' => true, 'where' => 'civicrm_contact.id', 'headerPattern' => '/internal|contact?|id$/i', 'dataPattern' => '', 'export' => true), 'contact_type' => array('name' => 'contact_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contact Type'), 'description' => 'Type of Contact.', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'export' => true, 'where' => 'civicrm_contact.contact_type', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_contact_type', 'keyColumn' => 'name', 'labelColumn' => 'label', 'condition' => 'parent_id IS NULL')), 'contact_sub_type' => array('name' => 'contact_sub_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contact Subtype'), 'description' => 'May be used to over-ride contact view and edit templates.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.contact_sub_type', 'headerPattern' => '/C(ontact )?(subtype|sub-type|sub type)/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_contact_type', 'keyColumn' => 'name', 'labelColumn' => 'label', 'condition' => 'parent_id IS NOT NULL')), 'do_not_email' => array('name' => 'do_not_email', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Do Not Email'), 'import' => true, 'where' => 'civicrm_contact.do_not_email', 'headerPattern' => '/d(o )?(not )?(email)/i', 'dataPattern' => '/^\\d{1,}$/', 'export' => true, 'html' => array('type' => 'CheckBox')), 'do_not_phone' => array('name' => 'do_not_phone', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Do Not Phone'), 'import' => true, 'where' => 'civicrm_contact.do_not_phone', 'headerPattern' => '/d(o )?(not )?(call|phone)/i', 'dataPattern' => '/^\\d{1,}$/', 'export' => true, 'html' => array('type' => 'CheckBox')), 'do_not_mail' => array('name' => 'do_not_mail', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Do Not Mail'), 'import' => true, 'where' => 'civicrm_contact.do_not_mail', 'headerPattern' => '/^(d(o\\s)?n(ot\\s)?mail)|(\\w*)?bulk\\s?(\\w*)$/i', 'dataPattern' => '/^\\d{1,}$/', 'export' => true, 'html' => array('type' => 'CheckBox')), 'do_not_sms' => array('name' => 'do_not_sms', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Do Not Sms'), 'import' => true, 'where' => 'civicrm_contact.do_not_sms', 'headerPattern' => '/d(o )?(not )?(sms)/i', 'dataPattern' => '/^\\d{1,}$/', 'export' => true, 'html' => array('type' => 'CheckBox')), 'do_not_trade' => array('name' => 'do_not_trade', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Do Not Trade'), 'import' => true, 'where' => 'civicrm_contact.do_not_trade', 'headerPattern' => '/d(o )?(not )?(trade)/i', 'dataPattern' => '/^\\d{1,}$/', 'export' => true, 'html' => array('type' => 'CheckBox')), 'is_opt_out' => array('name' => 'is_opt_out', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('No Bulk Emails (User Opt Out)'), 'description' => 'Has the contact opted out from receiving all bulk email from the organization or site domain?', 'required' => true, 'import' => true, 'where' => 'civicrm_contact.is_opt_out', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'CheckBox')), 'legal_identifier' => array('name' => 'legal_identifier', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Legal Identifier'), 'description' => 'May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.
', 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM, 'import' => true, 'where' => 'civicrm_contact.legal_identifier', 'headerPattern' => '/legal\\s?id/i', 'dataPattern' => '/\\w+?\\d{5,}/', 'export' => true, 'html' => array('type' => 'Text')), 'external_identifier' => array('name' => 'external_identifier', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('External Identifier'), 'description' => 'Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.', 'maxlength' => 64, 'size' => 8, 'import' => true, 'where' => 'civicrm_contact.external_identifier', 'headerPattern' => '/external\\s?id/i', 'dataPattern' => '/^\\d{11,}$/', 'export' => true, 'html' => array('type' => 'Text')), 'sort_name' => array('name' => 'sort_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Sort Name'), 'description' => 'Name used for sorting different contact types', 'maxlength' => 128, 'size' => 30, 'export' => true, 'where' => 'civicrm_contact.sort_name', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'Text')), 'display_name' => array('name' => 'display_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Display Name'), 'description' => 'Formatted name representing preferred format for display/print/other output.', 'maxlength' => 128, 'size' => 30, 'export' => true, 'where' => 'civicrm_contact.display_name', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'Text')), 'nick_name' => array('name' => 'nick_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Nickname'), 'description' => 'Nickname.', 'maxlength' => 128, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.nick_name', 'headerPattern' => '/n(ick\\s)name|nick$/i', 'dataPattern' => '/^\\w+$/', 'export' => true, 'html' => array('type' => 'Text')), 'legal_name' => array('name' => 'legal_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Legal Name'), 'description' => 'Legal Name.', 'maxlength' => 128, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.legal_name', 'headerPattern' => '/^legal|(l(egal\\s)?name)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'image_URL' => array('name' => 'image_URL', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Image Url'), 'description' => 'optional URL for preferred image (photo, logo, etc.) to display for this contact.', 'import' => true, 'where' => 'civicrm_contact.image_URL', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'File')), 'preferred_communication_method' => array('name' => 'preferred_communication_method', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Preferred Communication Method'), 'description' => 'What is the preferred mode of communication.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.preferred_communication_method', 'headerPattern' => '/^p(ref\\w*\\s)?c(omm\\w*)|( meth\\w*)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'preferred_communication_method', 'optionEditPath' => 'civicrm/admin/options/preferred_communication_method')), 'preferred_language' => array('name' => 'preferred_language', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Preferred Language'), 'description' => 'Which language is preferred for communication. FK to languages in civicrm_option_value.', 'maxlength' => 5, 'size' => CRM_Utils_Type::SIX, 'import' => true, 'where' => 'civicrm_contact.preferred_language', 'headerPattern' => '/^lang/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'languages', 'keyColumn' => 'name', 'optionEditPath' => 'civicrm/admin/options/languages')), 'preferred_mail_format' => array('name' => 'preferred_mail_format', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Preferred Mail Format'), 'description' => 'What is the preferred mode of sending an email.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'import' => true, 'where' => 'civicrm_contact.preferred_mail_format', 'headerPattern' => '/^p(ref\\w*\\s)?m(ail\\s)?f(orm\\w*)$/i', 'dataPattern' => '', 'export' => true, 'default' => 'Both', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::pmf')), 'hash' => array('name' => 'hash', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contact Hash'), 'description' => 'Key for validating requests related to this contact.', 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM, 'export' => true, 'where' => 'civicrm_contact.hash', 'headerPattern' => '', 'dataPattern' => ''), 'api_key' => array('name' => 'api_key', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Api Key'), 'description' => 'API Key for validating requests related to this contact.', 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'contact_source' => array('name' => 'source', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contact Source'), 'description' => 'where contact come from, e.g. import, donate module insert...', 'maxlength' => 255, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.source', 'headerPattern' => '/(C(ontact\\s)?Source)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'first_name' => array('name' => 'first_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('First Name'), 'description' => 'First Name.', 'maxlength' => 64, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.first_name', 'headerPattern' => '/^first|(f(irst\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true, 'html' => array('type' => 'Text')), 'middle_name' => array('name' => 'middle_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Middle Name'), 'description' => 'Middle Name.', 'maxlength' => 64, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.middle_name', 'headerPattern' => '/^middle|(m(iddle\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true, 'html' => array('type' => 'Text')), 'last_name' => array('name' => 'last_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Last Name'), 'description' => 'Last Name.', 'maxlength' => 64, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.last_name', 'headerPattern' => '/^last|(l(ast\\s)?name)$/i', 'dataPattern' => '/^\\w+(\\s\\w+)?+$/', 'export' => true, 'html' => array('type' => 'Text')), 'prefix_id' => array('name' => 'prefix_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Individual Prefix'), 'description' => 'Prefix or Title for name (Ms, Mr...). FK to prefix ID', 'import' => true, 'where' => 'civicrm_contact.prefix_id', 'headerPattern' => '/^(prefix|title)/i', 'dataPattern' => '/^(mr|ms|mrs|sir|dr)\\.?$/i', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'individual_prefix', 'optionEditPath' => 'civicrm/admin/options/individual_prefix')), 'suffix_id' => array('name' => 'suffix_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Individual Suffix'), 'description' => 'Suffix for name (Jr, Sr...). FK to suffix ID', 'import' => true, 'where' => 'civicrm_contact.suffix_id', 'headerPattern' => '/^suffix$/i', 'dataPattern' => '/^(sr|jr)\\.?|i{2,}$/', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'individual_suffix', 'optionEditPath' => 'civicrm/admin/options/individual_suffix')), 'formal_title' => array('name' => 'formal_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Formal Title'), 'description' => 'Formal (academic or similar) title in front of name. (Prof., Dr. etc.)', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_contact.formal_title', 'headerPattern' => '/^title/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'communication_style_id' => array('name' => 'communication_style_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Communication Style'), 'description' => 'Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value.', 'export' => true, 'where' => 'civicrm_contact.communication_style_id', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'communication_style', 'optionEditPath' => 'civicrm/admin/options/communication_style')), 'email_greeting_id' => array('name' => 'email_greeting_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Email Greeting ID'), 'description' => 'FK to civicrm_option_value.id, that has to be valid registered Email Greeting.'), 'email_greeting_custom' => array('name' => 'email_greeting_custom', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Email Greeting Custom'), 'description' => 'Custom Email Greeting.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.email_greeting_custom', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'html' => array('type' => 'Text')), 'email_greeting_display' => array('name' => 'email_greeting_display', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Email Greeting'), 'description' => 'Cache Email Greeting.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'postal_greeting_id' => array('name' => 'postal_greeting_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Postal Greeting ID'), 'description' => 'FK to civicrm_option_value.id, that has to be valid registered Postal Greeting.', 'html' => array('type' => 'Text')), 'postal_greeting_custom' => array('name' => 'postal_greeting_custom', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Postal Greeting Custom'), 'description' => 'Custom Postal greeting.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.postal_greeting_custom', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'html' => array('type' => 'Text')), 'postal_greeting_display' => array('name' => 'postal_greeting_display', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Postal Greeting'), 'description' => 'Cache Postal greeting.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'addressee_id' => array('name' => 'addressee_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Addressee ID'), 'description' => 'FK to civicrm_option_value.id, that has to be valid registered Addressee.'), 'addressee_custom' => array('name' => 'addressee_custom', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Addressee Custom'), 'description' => 'Custom Addressee.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.addressee_custom', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'html' => array('type' => 'Text')), 'addressee_display' => array('name' => 'addressee_display', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Addressee'), 'description' => 'Cache Addressee.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'job_title' => array('name' => 'job_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Job Title'), 'description' => 'Job Title', 'maxlength' => 255, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.job_title', 'headerPattern' => '/^job|(j(ob\\s)?title)$/i', 'dataPattern' => '//', 'export' => true, 'html' => array('type' => 'Text')), 'gender_id' => array('name' => 'gender_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Gender'), 'description' => 'FK to gender ID', 'import' => true, 'where' => 'civicrm_contact.gender_id', 'headerPattern' => '/^gender$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'gender', 'optionEditPath' => 'civicrm/admin/options/gender')), 'birth_date' => array('name' => 'birth_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Birth Date'), 'description' => 'Date of birth', 'import' => true, 'where' => 'civicrm_contact.birth_date', 'headerPattern' => '/^birth|(b(irth\\s)?date)|D(\\W*)O(\\W*)B(\\W*)$/i', 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/', 'export' => true, 'html' => array('type' => 'Select Date')), 'is_deceased' => array('name' => 'is_deceased', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Deceased'), 'import' => true, 'where' => 'civicrm_contact.is_deceased', 'headerPattern' => '/i(s\\s)?d(eceased)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'CheckBox')), 'deceased_date' => array('name' => 'deceased_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Deceased Date'), 'description' => 'Date of deceased', 'import' => true, 'where' => 'civicrm_contact.deceased_date', 'headerPattern' => '/^deceased|(d(eceased\\s)?date)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'household_name' => array('name' => 'household_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Household Name'), 'description' => 'Household Name.', 'maxlength' => 128, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.household_name', 'headerPattern' => '/^household|(h(ousehold\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true, 'html' => array('type' => 'Text')), 'primary_contact_id' => array('name' => 'primary_contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Household Primary Contact ID'), 'description' => 'Optional FK to Primary Contact for this household.', 'FKClassName' => 'CRM_Contact_DAO_Contact', 'html' => array('type' => 'Select')), 'organization_name' => array('name' => 'organization_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Organization Name'), 'description' => 'Organization Name.', 'maxlength' => 128, 'size' => 30, 'import' => true, 'where' => 'civicrm_contact.organization_name', 'headerPattern' => '/^organization|(o(rganization\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true, 'html' => array('type' => 'Text')), 'sic_code' => array('name' => 'sic_code', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Sic Code'), 'description' => 'Standard Industry Classification Code.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'import' => true, 'where' => 'civicrm_contact.sic_code', 'headerPattern' => '/^sic|(s(ic\\s)?code)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'user_unique_id' => array('name' => 'user_unique_id', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Unique ID (OpenID)'), 'description' => 'the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.user_unique_id', 'headerPattern' => '/^Open\\s?ID|u(niq\\w*)?\\s?ID/i', 'dataPattern' => '/^[\\w\\/\\:\\.]+$/', 'export' => true, 'rule' => 'url', 'html' => array('type' => 'Text')), 'current_employer_id' => array('name' => 'employer_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Current Employer'), 'description' => 'OPTIONAL FK to civicrm_contact record.', 'export' => true, 'where' => 'civicrm_contact.employer_id', 'headerPattern' => '', 'dataPattern' => '', 'FKClassName' => 'CRM_Contact_DAO_Contact', 'html' => array('type' => 'EntityRef')), 'contact_is_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Contact is in Trash'), 'required' => true, 'export' => true, 'where' => 'civicrm_contact.is_deleted', 'headerPattern' => '', 'dataPattern' => '', 'html' => array('type' => 'CheckBox')), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_TIMESTAMP, 'title' => ts('Created Date'), 'description' => 'When was the contact was created.', 'required' => false, 'export' => true, 'where' => 'civicrm_contact.created_date', 'headerPattern' => '', 'dataPattern' => '', 'default' => 'NULL'), 'modified_date' => array('name' => 'modified_date', 'type' => CRM_Utils_Type::T_TIMESTAMP, 'title' => ts('Modified Date'), 'description' => 'When was the contact (or closely related entity) was created or modified or deleted.', 'required' => false, 'export' => true, 'where' => 'civicrm_contact.modified_date', 'headerPattern' => '', 'dataPattern' => '', 'default' => 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('ACL ID'), 'description' => 'Unique table ID', 'required' => true), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ACL Name'), 'description' => 'ACL Name.', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'html' => array('type' => 'Text')), 'deny' => array('name' => 'deny', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Deny ACL?'), 'description' => 'Is this ACL entry Allow (0) or Deny (1) ?', 'required' => true, 'html' => array('type' => 'Radio')), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ACL Entity'), 'description' => 'Table of the object possessing this ACL entry (Contact, Group, or ACL Group)', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Entity ID'), 'description' => 'ID of the object possessing this ACL'), 'operation' => array('name' => 'operation', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ACL Operation'), 'description' => 'What operation does this ACL entry control?', 'required' => true, 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_ACL_BAO_ACL::operation')), 'object_table' => array('name' => 'object_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ACL Object'), 'description' => 'The table of the object controlled by this ACL entry', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'object_id' => array('name' => 'object_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('ACL Object ID'), 'description' => 'The ID of the object controlled by this ACL entry'), 'acl_table' => array('name' => 'acl_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ACL Table'), 'description' => 'If this is a grant/revoke entry, what table are we granting?', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'acl_id' => array('name' => 'acl_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('ACL Group ID'), 'description' => 'ID of the ACL or ACL group being granted/revoked'), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('ACL Is Active?'), 'description' => 'Is this property active?', 'html' => array('type' => 'Checkbox')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Navigation ID'), 'required' => true), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Navigation Domain'), 'description' => 'Which Domain is this navigation item for', 'required' => true, 'FKClassName' => 'CRM_Core_DAO_Domain', 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'label' => array('name' => 'label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Navigation Item Label'), 'description' => 'Navigation Title', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Navigation Item Machine Name'), 'description' => 'Internal Name', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'url' => array('name' => 'url', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Url'), 'description' => 'url in case of custom navigation link', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'permission' => array('name' => 'permission', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Required Permission'), 'description' => 'Permission for menu item', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'permission_operator' => array('name' => 'permission_operator', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Permission Operator'), 'description' => 'Permission Operator', 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR), 'parent_id' => array('name' => 'parent_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Navigation parent ID'), 'description' => 'Parent navigation item, used for grouping', 'FKClassName' => 'CRM_Core_DAO_Navigation', 'pseudoconstant' => array('table' => 'civicrm_navigation', 'keyColumn' => 'id', 'labelColumn' => 'label', 'nameColumn' => 'name')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Active'), 'description' => 'Is this navigation item active?'), 'has_separator' => array('name' => 'has_separator', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Use separator'), 'description' => 'If separator needs to be added after this menu item'), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Order'), 'description' => 'Ordering of the navigation items in various blocks.'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing Event Queue ID'), 'required' => true), 'job_id' => array('name' => 'job_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Job ID'), 'description' => 'FK to Job', 'required' => true, 'FKClassName' => 'CRM_Mailing_DAO_MailingJob'), 'email_id' => array('name' => 'email_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Email ID'), 'description' => 'FK to Email', 'default' => 'NULL', 'FKClassName' => 'CRM_Core_DAO_Email'), 'contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'description' => 'FK to Contact', 'required' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'hash' => array('name' => 'hash', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Security Hash'), 'description' => 'Security hash', 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'phone_id' => array('name' => 'phone_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Phone ID'), 'description' => 'FK to Phone', 'default' => 'NULL', 'FKClassName' => 'CRM_Core_DAO_Phone'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contribution Page ID'), 'description' => 'Contribution Id', 'required' => true), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contribution Page Title'), 'description' => 'Contribution Page title. For top of page display', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'intro_text' => array('name' => 'intro_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Contribution Page Introduction Text'), 'description' => 'Text and html allowed. Displayed below title.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'RichTextEditor')), 'financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Type'), 'description' => 'default financial type assigned to contributions submitted via this page, e.g. Contribution, Campaign Contribution', 'FKClassName' => 'CRM_Financial_DAO_FinancialType', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_financial_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'payment_processor' => array('name' => 'payment_processor', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Payment Processor'), 'description' => 'Payment Processors configured for this contribution Page', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_payment_processor', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'is_credit_card_only' => array('name' => 'is_credit_card_only', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Credit Card Only?'), 'description' => 'if true - processing logic must reject transaction at confirmation stage if pay method != credit card'), 'is_monetary' => array('name' => 'is_monetary', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Monetary'), 'description' => 'if true - allows real-time monetary transactions otherwise non-monetary transactions', 'default' => '1'), 'is_recur' => array('name' => 'is_recur', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Recurring'), 'description' => 'if true - allows recurring contributions, valid only for PayPal_Standard'), 'is_confirm_enabled' => array('name' => 'is_confirm_enabled', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Confirmation Page?'), 'description' => 'if false, the confirm page in contribution pages gets skipped', 'default' => '1'), 'recur_frequency_unit' => array('name' => 'recur_frequency_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recurring Frequency'), 'description' => 'Supported recurring frequency units.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE), 'is_recur_interval' => array('name' => 'is_recur_interval', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Support Recurring Intervals'), 'description' => 'if true - supports recurring intervals'), 'is_recur_installments' => array('name' => 'is_recur_installments', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Recurring Installments?'), 'description' => 'if true - asks user for recurring installments'), 'adjust_recur_start_date' => array('name' => 'adjust_recur_start_date', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Adjust Recurring Start Date'), 'description' => 'if true - user is able to adjust payment start date'), 'is_pay_later' => array('name' => 'is_pay_later', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Pay Later'), 'description' => 'if true - allows the user to send payment directly to the org later'), 'pay_later_text' => array('name' => 'pay_later_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Text'), 'description' => 'The text displayed to the user in the main form'), 'pay_later_receipt' => array('name' => 'pay_later_receipt', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Receipt'), 'description' => 'The receipt sent to the user instead of the normal receipt text'), 'is_partial_payment' => array('name' => 'is_partial_payment', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Allow Partial Payment'), 'description' => 'is partial payment enabled for this online contribution page'), 'initial_amount_label' => array('name' => 'initial_amount_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Initial Amount Label'), 'description' => 'Initial amount label for partial payment', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'initial_amount_help_text' => array('name' => 'initial_amount_help_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Initial Amount Help Text'), 'description' => 'Initial amount help text for partial payment'), 'min_initial_amount' => array('name' => 'min_initial_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Min Initial Amount'), 'description' => 'Minimum initial amount for partial payment', 'precision' => array(20, 2)), 'is_allow_other_amount' => array('name' => 'is_allow_other_amount', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Allow Other Amounts'), 'description' => 'if true, page will include an input text field where user can enter their own amount'), 'default_amount_id' => array('name' => 'default_amount_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Default Amount'), 'description' => 'FK to civicrm_option_value.'), 'min_amount' => array('name' => 'min_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Minimum Amount'), 'description' => 'if other amounts allowed, user can configure minimum allowed.', 'precision' => array(20, 2)), 'max_amount' => array('name' => 'max_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Maximum Amount'), 'description' => 'if other amounts allowed, user can configure maximum allowed.', 'precision' => array(20, 2)), 'goal_amount' => array('name' => 'goal_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Goal Amount'), 'description' => 'The target goal for this page, allows people to build a goal meter', 'precision' => array(20, 2)), 'thankyou_title' => array('name' => 'thankyou_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Thank-you Title'), 'description' => 'Title for Thank-you page (header title tag, and display at the top of the page).', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'thankyou_text' => array('name' => 'thankyou_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Thank-you Text'), 'description' => 'text and html allowed. displayed above result on success page', 'rows' => 8, 'cols' => 60, 'html' => array('type' => 'RichTextEditor')), 'thankyou_footer' => array('name' => 'thankyou_footer', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Thank-you Footer'), 'description' => 'Text and html allowed. displayed at the bottom of the success page. Common usage is to include link(s) to other pages such as tell-a-friend, etc.', 'rows' => 8, 'cols' => 60, 'html' => array('type' => 'RichTextEditor')), 'is_email_receipt' => array('name' => 'is_email_receipt', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Send email Receipt'), 'description' => 'if true, receipt is automatically emailed to contact on success'), 'receipt_from_name' => array('name' => 'receipt_from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Receipt From'), 'description' => 'FROM email name used for receipts generated by contributions to this contribution page.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'receipt_from_email' => array('name' => 'receipt_from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Receipt From email'), 'description' => 'FROM email address used for receipts generated by contributions to this contribution page.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'cc_receipt' => array('name' => 'cc_receipt', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Receipt cc'), 'description' => 'comma-separated list of email addresses to cc each time a receipt is sent', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'bcc_receipt' => array('name' => 'bcc_receipt', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Receipt bcc'), 'description' => 'comma-separated list of email addresses to bcc each time a receipt is sent', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'receipt_text' => array('name' => 'receipt_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Receipt Text'), 'description' => 'text to include above standard receipt info on receipt email. emails are text-only, so do not allow html for now', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Page Active?'), 'description' => 'Is this property active?'), 'footer_text' => array('name' => 'footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'description' => 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'RichTextEditor')), 'amount_block_is_active' => array('name' => 'amount_block_is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Amount Block Active?'), 'description' => 'Is this property active?', 'default' => '1'), 'start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Contribution Page Start Date'), 'description' => 'Date and time that this page starts.'), 'end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Contribution Page End Date'), 'description' => 'Date and time that this page ends. May be NULL if no defined end date/time'), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contribution Page Created By'), 'description' => 'FK to civicrm_contact, who created this contribution page', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Contribution Page Created Date'), 'description' => 'Date and time that contribution page was created.'), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contribution Page Currency'), 'description' => '3 character string, value from config setting or input via user.', 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'default' => 'NULL', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'name')), 'campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contribution Page Campaign ID'), 'description' => 'The campaign for which we are collecting contributions with this page.', 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'is_share' => array('name' => 'is_share', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Contribution Page Shared?'), 'description' => 'Can people share the contribution page through social media?', 'default' => '1'), 'is_billing_required' => array('name' => 'is_billing_required', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is billing block required'), 'description' => 'if true - billing block is required for online contribution page'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('SMS Provider ID'), 'description' => 'SMS Provider ID', 'required' => true), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('SMS Provider Name'), 'description' => 'Provider internal name points to option_value of option_group sms_provider_name', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('SMS Provider Title'), 'description' => 'Provider name visible to user', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'html' => array('type' => 'Text')), 'username' => array('name' => 'username', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('SMS Provider Username'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'password' => array('name' => 'password', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('SMS Provider Password'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'api_type' => array('name' => 'api_type', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('SMS Provider API'), 'description' => 'points to value in civicrm_option_value for group sms_api_type', 'required' => true, 'html' => array('type' => 'Select')), 'api_url' => array('name' => 'api_url', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('SMS Provider API URL'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'api_params' => array('name' => 'api_params', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('SMS Provider API Params'), 'description' => 'the api params in xml, http or smtp format', 'html' => array('type' => 'Text')), 'is_default' => array('name' => 'is_default', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('SMS Provider is Default?'), 'html' => array('type' => 'CheckBox')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('SMS Provider is Active?'), 'html' => array('type' => 'CheckBox')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Processor ID'), 'description' => 'Payment Processor ID', 'required' => true), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Processor Domain'), 'description' => 'Which Domain is this match entry for', 'required' => true, 'FKClassName' => 'CRM_Core_DAO_Domain', 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Payment Processor'), 'description' => 'Payment Processor Name.', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Processor Description'), 'description' => 'Payment Processor Description.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'payment_processor_type_id' => array('name' => 'payment_processor_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Processor Type ID'), 'FKClassName' => 'CRM_Financial_DAO_PaymentProcessorType', 'pseudoconstant' => array('table' => 'civicrm_payment_processor_type', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Processor is Active?'), 'description' => 'Is this processor active?'), 'is_default' => array('name' => 'is_default', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Processor Is Default?'), 'description' => 'Is this processor the default?'), 'is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Test Processor?'), 'description' => 'Is this processor for a test site?'), 'user_name' => array('name' => 'user_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('User Name'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'password' => array('name' => 'password', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Password'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'signature' => array('name' => 'signature', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Signature')), 'url_site' => array('name' => 'url_site', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Site URL'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'url_api' => array('name' => 'url_api', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('API URL'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'url_recur' => array('name' => 'url_recur', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Recurring Payments URL'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'url_button' => array('name' => 'url_button', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Button URL'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Subject'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'class_name' => array('name' => 'class_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Suffix for PHP class name implementation'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'billing_mode' => array('name' => 'billing_mode', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Processor Billing Mode'), 'description' => 'Billing Mode (deprecated)', 'required' => true), 'is_recur' => array('name' => 'is_recur', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Processor Supports Recurring?'), 'description' => 'Can process recurring contributions'), 'payment_type' => array('name' => 'payment_type', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Type'), 'description' => 'Payment Type: Credit or Debit (deprecated)', 'default' => '1'), 'payment_instrument_id' => array('name' => 'payment_instrument_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Method'), 'description' => 'Payment Instrument ID', 'default' => '1', 'pseudoconstant' => array('optionGroupName' => 'payment_instrument', 'optionEditPath' => 'civicrm/admin/options/payment_instrument')), 'accepted_credit_cards' => array('name' => 'accepted_credit_cards', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Accepted Credit Cards'), 'description' => 'array of accepted credit card types', 'default' => 'NULL'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Entity Financial Account ID'), 'description' => 'ID', 'required' => true), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Table'), 'description' => 'Links to an entity_table like civicrm_financial_type', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_entity_financial_account.entity_table', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Entity ID'), 'description' => 'Links to an id in the entity_table, such as vid in civicrm_financial_type', 'required' => true), 'account_relationship' => array('name' => 'account_relationship', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Account Relationship'), 'description' => 'FK to a new civicrm_option_value (account_relationship)', 'required' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'account_relationship', 'optionEditPath' => 'civicrm/admin/options/account_relationship')), 'financial_account_id' => array('name' => 'financial_account_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Account'), 'description' => 'FK to the financial_account_id', 'required' => true, 'FKClassName' => 'CRM_Financial_DAO_FinancialAccount', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_financial_account', 'keyColumn' => 'id', 'labelColumn' => 'name')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Product ID'), 'required' => true), 'product_name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Product Name'), 'description' => 'Required product/premium name', 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'export' => true, 'where' => 'civicrm_product.name', 'headerPattern' => '', 'dataPattern' => ''), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Description'), 'description' => 'Optional description of the product/premium.'), 'sku' => array('name' => 'sku', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('SKU'), 'description' => 'Optional product sku or code.', 'maxlength' => 50, 'size' => CRM_Utils_Type::BIG, 'export' => true, 'where' => 'civicrm_product.sku', 'headerPattern' => '', 'dataPattern' => ''), 'options' => array('name' => 'options', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Options'), 'description' => 'Store comma-delimited list of color, size, etc. options for the product.'), 'image' => array('name' => 'image', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Image'), 'description' => 'Full or relative URL to uploaded image - fullsize.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'thumbnail' => array('name' => 'thumbnail', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Thumbnail'), 'description' => 'Full or relative URL to image thumbnail.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'price' => array('name' => 'price', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Price'), 'description' => 'Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record.', 'precision' => array(20, 2)), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Currency'), 'description' => '3 character string, value from config setting or input via user.', 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'default' => 'NULL', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'name')), 'financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Type'), 'description' => 'FK to Financial Type.', 'default' => 'NULL', 'FKClassName' => 'CRM_Financial_DAO_FinancialType', 'pseudoconstant' => array('table' => 'civicrm_financial_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'min_contribution' => array('name' => 'min_contribution', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Minimum Contribution'), 'description' => 'Minimum contribution required to be eligible to select this premium.', 'precision' => array(20, 2)), 'cost' => array('name' => 'cost', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Cost'), 'description' => 'Actual cost of this product. Useful to determine net return from sale or using this as an incentive.', 'precision' => array(20, 2)), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Active'), 'description' => 'Disabling premium removes it from the premiums_premium join table below.', 'required' => true), 'period_type' => array('name' => 'period_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Period Type'), 'description' => 'Rolling means we set start/end based on current day, fixed means we set start/end for current year or month
(e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) ', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'default' => 'rolling', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::periodType')), 'fixed_period_start_day' => array('name' => 'fixed_period_start_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Fixed Period Start Day'), 'description' => 'Month and day (MMDD) that fixed period type subscription or membership starts.', 'default' => '0101'), 'duration_unit' => array('name' => 'duration_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Duration Unit'), 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'default' => 'year', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::getPremiumUnits')), 'duration_interval' => array('name' => 'duration_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Duration Interval'), 'description' => 'Number of units for total duration of subscription, service, membership (e.g. 12 Months).'), 'frequency_unit' => array('name' => 'frequency_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Frequency Unit'), 'description' => 'Frequency unit and interval allow option to store actual delivery frequency for a subscription or service.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'default' => 'month', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::getPremiumUnits')), 'frequency_interval' => array('name' => 'frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Frequency Interval'), 'description' => 'Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months).'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('case_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case ID'), 'description' => 'Unique Case ID', 'required' => true, 'import' => true, 'where' => 'civicrm_case.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'case_type_id' => array('name' => 'case_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case Type'), 'description' => 'FK to civicrm_case_type.id', 'import' => true, 'where' => 'civicrm_case.case_type_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'FKClassName' => 'CRM_Case_DAO_CaseType', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_case_type', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'case_subject' => array('name' => 'subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Case Subject'), 'description' => 'Short name of the case.', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_case.subject', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'case_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Case Start Date'), 'description' => 'Date on which given case starts.', 'import' => true, 'where' => 'civicrm_case.start_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'case_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Case End Date'), 'description' => 'Date on which given case ends.', 'import' => true, 'where' => 'civicrm_case.end_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'details' => array('name' => 'details', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Details'), 'description' => 'Details about the meeting (agenda, notes, etc).', 'rows' => 8, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'case_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case Status'), 'description' => 'Id of case status.', 'required' => true, 'import' => true, 'where' => 'civicrm_case.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'case_status', 'optionEditPath' => 'civicrm/admin/options/case_status')), 'case_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Case is in the Trash'), 'import' => true, 'where' => 'civicrm_case.is_deleted', 'headerPattern' => '', 'dataPattern' => '', 'export' => true));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Case Type ID'), 'description' => 'Autoincremented type id', 'required' => true), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Case Type Name'), 'description' => 'Machine name for Case Type', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Case Type Title'), 'description' => 'Natural language name for Case Type', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Case Type Description'), 'description' => 'Description of the Case Type', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Case Type Is Active'), 'description' => 'Is this entry active?'), 'is_reserved' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Case Type Is Reserved'), 'description' => 'Is this case type a predefined system type?'), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Order'), 'description' => 'Ordering of the case types', 'required' => true, 'default' => '1'), 'definition' => array('name' => 'definition', 'type' => CRM_Utils_Type::T_BLOB, 'title' => ts('Case Type Definition'), 'description' => 'xml definition of case type'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Trackable URL ID'), 'required' => true), 'url' => array('name' => 'url', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Url'), 'description' => 'The URL to be tracked.', 'required' => true), 'mailing_id' => array('name' => 'mailing_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mailing'), 'description' => 'FK to the mailing', 'required' => true, 'FKClassName' => 'CRM_Mailing_DAO_Mailing'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Dedupe Rule ID'), 'description' => 'Unique dedupe rule id', 'required' => true), 'dedupe_rule_group_id' => array('name' => 'dedupe_rule_group_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Dedupe Rule Group'), 'description' => 'The id of the rule group this rule belongs to', 'required' => true, 'FKClassName' => 'CRM_Dedupe_DAO_RuleGroup'), 'rule_table' => array('name' => 'rule_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Rule Table'), 'description' => 'The name of the table this rule is about', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'rule_field' => array('name' => 'rule_field', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Rule Field'), 'description' => 'The name of the field of the table referenced in rule_table', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'rule_length' => array('name' => 'rule_length', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Rule Length'), 'description' => 'The length of the matching substring', 'html' => array('type' => 'Text')), 'rule_weight' => array('name' => 'rule_weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Order'), 'description' => 'The weight of the rule', 'required' => true, 'html' => array('type' => 'Text')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Message Template ID'), 'description' => 'Message Template ID', 'required' => true), 'msg_title' => array('name' => 'msg_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Message Template Title'), 'description' => 'Descriptive title of message', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'msg_subject' => array('name' => 'msg_subject', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Message Template Subject'), 'description' => 'Subject for email message.'), 'msg_text' => array('name' => 'msg_text', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Message Template Text'), 'description' => 'Text formatted message', 'html' => array('type' => 'TextArea')), 'msg_html' => array('name' => 'msg_html', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Message Template HTML'), 'description' => 'HTML formatted message', 'html' => array('type' => 'RichTextEditor')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Active'), 'default' => '1'), 'workflow_id' => array('name' => 'workflow_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Message Template Workflow'), 'description' => 'a pseudo-FK to civicrm_option_value'), 'is_default' => array('name' => 'is_default', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Message Template Is Default?'), 'description' => 'is this the default message template for the workflow referenced by workflow_id?', 'default' => '1'), 'is_reserved' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Message Template Is Reserved?'), 'description' => 'is this the reserved message template which we ship for the workflow referenced by workflow_id?'), 'is_sms' => array('name' => 'is_sms', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Message Template is used for SMS?'), 'description' => 'Is this message template used for sms?'), 'pdf_format_id' => array('name' => 'pdf_format_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Message Template Format'), 'description' => 'a pseudo-FK to civicrm_option_value containing PDF Page Format.', 'pseudoconstant' => array('optionGroupName' => 'pdf_format', 'keyColumn' => 'id', 'optionEditPath' => 'civicrm/admin/options/pdf_format')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['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' => 64, 'size' => CRM_Utils_Type::BIG), '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));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Delivered ID'), 'required' => true), 'event_queue_id' => array('name' => 'event_queue_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Event Queue'), 'description' => 'FK to EventQueue', 'required' => true, 'FKClassName' => 'CRM_Mailing_Event_DAO_Queue'), 'time_stamp' => array('name' => 'time_stamp', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Timestamp'), 'description' => 'When this delivery event occurred.', 'required' => true));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Word Replacement ID'), 'description' => 'Word replacement ID', 'required' => true), 'find_word' => array('name' => 'find_word', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Replaced Word'), 'description' => 'Word which need to be replaced', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'replace_word' => array('name' => 'replace_word', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Replacement Word'), 'description' => 'Word which will replace the word in find', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Word Replacement is Active'), 'description' => 'Is this entry active?', 'default' => '1'), 'match_type' => array('name' => 'match_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Word Replacement Match Type'), 'maxlength' => 16, 'size' => CRM_Utils_Type::TWELVE, 'default' => 'wildcardMatch', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('callback' => 'CRM_Core_SelectValues::getWordReplacementMatchType')), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Word Replacement Domain ID'), 'description' => 'FK to Domain ID. This is for Domain specific word replacement', 'FKClassName' => 'CRM_Core_DAO_Domain', 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Report Instance ID'), 'description' => 'Report Instance ID', 'required' => true), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Report Instance Domain ID'), 'description' => 'Which Domain is this instance for', 'required' => true, 'FKClassName' => 'CRM_Core_DAO_Domain', 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report Instance Title'), 'description' => 'Report Instance Title.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'report_id' => array('name' => 'report_id', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report template ID'), 'description' => 'FK to civicrm_option_value for the report template', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'html' => array('type' => 'Select')), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report instance Name'), 'description' => 'when combined with report_id/template uniquely identifies the instance', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'args' => array('name' => 'args', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report Instance Arguments'), 'description' => 'arguments that are passed in the url when invoking the instance', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report Instance description'), 'description' => 'Report Instance description.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'permission' => array('name' => 'permission', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report Instance Permissions'), 'description' => 'permission required to be able to run this instance', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'grouprole' => array('name' => 'grouprole', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report Instance Assigned to Roles'), 'description' => 'role required to be able to run this instance', 'maxlength' => 1024, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'form_values' => array('name' => 'form_values', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Submitted Form Values'), 'description' => 'Submitted form values for this report', 'import' => true, 'where' => 'civicrm_report_instance.form_values', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Report Instance is Active'), 'description' => 'Is this entry active?', 'html' => array('type' => 'CheckBox')), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Report Instance Created By'), 'description' => 'FK to contact table.', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'owner_id' => array('name' => 'owner_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Report Instance Owned By'), 'description' => 'FK to contact table.', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'email_subject' => array('name' => 'email_subject', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Report Instance email Subject'), 'description' => 'Subject of email', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'email_to' => array('name' => 'email_to', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Email Report Instance To'), 'description' => 'comma-separated list of email addresses to send the report to', 'html' => array('type' => 'Text')), 'email_cc' => array('name' => 'email_cc', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('cc Email Report Instance To'), 'description' => 'comma-separated list of email addresses to send the report to', 'html' => array('type' => 'Text')), 'header' => array('name' => 'header', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Report Instance Header'), 'description' => 'comma-separated list of email addresses to send the report to', 'rows' => 4, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'footer' => array('name' => 'footer', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Report Instance Footer'), 'description' => 'comma-separated list of email addresses to send the report to', 'rows' => 4, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'navigation_id' => array('name' => 'navigation_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Navigation ID'), 'description' => 'FK to navigation ID', 'import' => true, 'where' => 'civicrm_report_instance.navigation_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Core_DAO_Navigation'), 'drilldown_id' => array('name' => 'drilldown_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Drilldown Report ID'), 'description' => 'FK to instance ID drilldown to', 'import' => true, 'where' => 'civicrm_report_instance.drilldown_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Report_DAO_ReportInstance'), 'is_reserved' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Instance is Reserved'), 'html' => array('type' => 'CheckBox')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment ID'), 'description' => 'Participant Payment Id', 'required' => true), 'participant_id' => array('name' => 'participant_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Participant ID'), 'description' => 'Participant Id (FK)', 'required' => true, 'FKClassName' => 'CRM_Event_DAO_Participant'), 'contribution_id' => array('name' => 'contribution_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contribution'), 'description' => 'FK to contribution table.', 'required' => true, 'FKClassName' => 'CRM_Contribute_DAO_Contribution'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('ID'), 'required' => true), 'parent_id' => array('name' => 'parent_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Parent ID'), 'description' => 'Recurring Entity Parent ID', 'required' => true), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Entity ID'), 'description' => 'Recurring Entity Child ID'), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Entity Table'), 'description' => 'Physical tablename for entity, e.g. civicrm_event', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'mode' => array('name' => 'mode', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Cascade Type'), 'description' => '1-this entity, 2-this and the following entities, 3-all the entities', 'required' => true, 'default' => '1'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['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')), 'language' => array('name' => 'language', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Mailing Language'), 'description' => 'Language of the content of the mailing. Useful for tokens.', 'maxlength' => 5, 'size' => CRM_Utils_Type::SIX, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'languages', 'keyColumn' => 'name', 'optionEditPath' => 'civicrm/admin/options/languages')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mapping ID'), 'description' => 'Mapping ID', 'required' => true), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Name'), 'description' => 'Name of Mapping', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Description'), 'description' => 'Description of Mapping.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'mapping_type_id' => array('name' => 'mapping_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Mapping Type'), 'description' => 'Mapping Type', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'mapping_type', 'optionEditPath' => 'civicrm/admin/options/mapping_type')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Price Set ID'), 'description' => 'Price Set', 'required' => true), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Price Set Domain'), 'description' => 'Which Domain is this price-set for', 'FKClassName' => 'CRM_Core_DAO_Domain', 'html' => array('type' => 'Text'), 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Name'), 'description' => 'Variable name/programmatic handle for this set of price fields.', 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Price Set Title'), 'description' => 'Displayed title for the Price Set.', 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Price Set Is Active?'), 'description' => 'Is this price set active', 'default' => '1', 'html' => array('type' => 'CheckBox')), 'help_pre' => array('name' => 'help_pre', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Price Set Pre Help'), 'description' => 'Description and/or help text to display before fields in form.', 'rows' => 4, 'cols' => 80, 'html' => array('type' => 'TextArea')), 'help_post' => array('name' => 'help_post', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Price Set Post Help'), 'description' => 'Description and/or help text to display after fields in form.', 'rows' => 4, 'cols' => 80, 'html' => array('type' => 'TextArea')), 'javascript' => array('name' => 'javascript', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Price Set Javascript'), 'description' => 'Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'html' => array('type' => 'Text')), 'extends' => array('name' => 'extends', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Price Set Extends'), 'description' => 'What components are using this price set?', 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text'), 'pseudoconstant' => array('table' => 'civicrm_component', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Type'), 'description' => 'FK to Financial Type(for membership price sets only).', 'default' => 'NULL', 'FKClassName' => 'CRM_Financial_DAO_FinancialType', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_financial_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'is_quick_config' => array('name' => 'is_quick_config', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Price Set Quick Config?'), 'description' => 'Is set if edited on Contribution or Event Page rather than through Manage Price Sets', 'html' => array('type' => 'CheckBox')), 'is_reserved' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Price Set Is Reserved'), 'description' => 'Is this a predefined system price set (i.e. it can not be deleted, edited)?', 'html' => array('type' => 'CheckBox')));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!isset(Civi::$statics[__CLASS__]['fields'])) {
Civi::$statics[__CLASS__]['fields'] = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('UF Join ID'), 'description' => 'Unique table ID', 'required' => true), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Profile Use is active'), 'description' => 'Is this join currently active?', 'default' => '1'), 'module' => array('name' => 'module', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Profile Module'), 'description' => 'Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc.', 'required' => true, 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG), 'entity_table' => array('name' => 'entity_table', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Profile Entity Table'), 'description' => 'Name of table where item being referenced is stored. Modules which only need a single collection of uf_join instances may choose not to populate entity_table and entity_id.', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'pseudoconstant' => array('callback' => 'CRM_Core_BAO_UFJoin::entityTables')), 'entity_id' => array('name' => 'entity_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Profile Entity ID'), 'description' => 'Foreign key to the referenced item.'), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Order'), 'description' => 'Controls display order when multiple user framework groups are setup for concurrent display.', 'required' => true, 'default' => '1'), 'uf_group_id' => array('name' => 'uf_group_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Profile ID'), 'description' => 'Which form does this field belong to.', 'required' => true, 'FKClassName' => 'CRM_Core_DAO_UFGroup', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_uf_group', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'module_data' => array('name' => 'module_data', 'type' => CRM_Utils_Type::T_LONGTEXT, 'title' => ts('Profile Use Data'), 'description' => 'Json serialized array of data used by the ufjoin.module'));
CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
}
return Civi::$statics[__CLASS__]['fields'];
}
