PHP CRM_Contact_DAO_Contact::_fields方法代码示例

 /**
  * returns all the column names of this table
  *
  * @access public
  * @return array
  */
 function &fields()
 {
     if (!self::$_fields) {
         self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Internal 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'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'export' => true, 'where' => 'civicrm_contact.contact_type', 'headerPattern' => '', 'dataPattern' => ''), 'contact_sub_type' => array('name' => 'contact_sub_type', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Contact Subtype'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_contact.contact_sub_type', 'headerPattern' => '/C(ontact )?(subtype|sub-type|sub type)/i', 'dataPattern' => '', 'export' => true), '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), '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), '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), '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), '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), 'is_opt_out' => array('name' => 'is_opt_out', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('No Bulk Emails (User Opt Out)'), 'required' => true, 'import' => true, 'where' => 'civicrm_contact.is_opt_out', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'legal_identifier' => array('name' => 'legal_identifier', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Legal Identifier'), '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), 'external_identifier' => array('name' => 'external_identifier', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('External Identifier'), 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM, 'import' => true, 'where' => 'civicrm_contact.external_identifier', 'headerPattern' => '/external\\s?id/i', 'dataPattern' => '/^\\d{11,}$/', 'export' => true), 'sort_name' => array('name' => 'sort_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Sort Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'export' => true, 'where' => 'civicrm_contact.sort_name', 'headerPattern' => '', 'dataPattern' => ''), 'display_name' => array('name' => 'display_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Display Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'export' => true, 'where' => 'civicrm_contact.display_name', 'headerPattern' => '', 'dataPattern' => ''), 'nick_name' => array('name' => 'nick_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Nick Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.nick_name', 'headerPattern' => '/n(ick\\s)name|nick$/i', 'dataPattern' => '/^\\w+$/', 'export' => true), 'legal_name' => array('name' => 'legal_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Legal Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.legal_name', 'headerPattern' => '/^legal|(l(egal\\s)?name)$/i', 'dataPattern' => '', 'export' => true), 'image_URL' => array('name' => 'image_URL', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Image Url'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.image_URL', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'preferred_communication_method' => array('name' => 'preferred_communication_method', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Preferred Communication Method'), '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), 'preferred_language' => array('name' => 'preferred_language', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Preferred Language'), 'maxlength' => 5, 'size' => CRM_Utils_Type::EIGHT, 'import' => true, 'where' => 'civicrm_contact.preferred_language', 'headerPattern' => '/^lang/i', 'dataPattern' => '', 'export' => true), 'preferred_mail_format' => array('name' => 'preferred_mail_format', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('Preferred Mail Format'), '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', 'enumValues' => 'Text, HTML, Both'), 'hash' => array('name' => 'hash', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Hash'), 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'api_key' => array('name' => 'api_key', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Api Key'), 'maxlength' => 32, 'size' => CRM_Utils_Type::MEDIUM), 'contact_source' => array('name' => 'source', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Source of Contact Data'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.source', 'headerPattern' => '/(S(ource\\s)?o(f\\s)?C(ontact\\s)?Data)$/i', 'dataPattern' => '', 'export' => true), 'first_name' => array('name' => 'first_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('First Name'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_contact.first_name', 'headerPattern' => '/^first|(f(irst\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true), 'middle_name' => array('name' => 'middle_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Middle Name'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_contact.middle_name', 'headerPattern' => '/^middle|(m(iddle\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true), 'last_name' => array('name' => 'last_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Last Name'), 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_contact.last_name', 'headerPattern' => '/^last|(l(ast\\s)?name)$/i', 'dataPattern' => '/^\\w+(\\s\\w+)?+$/', 'export' => true), 'prefix_id' => array('name' => 'prefix_id', 'type' => CRM_Utils_Type::T_INT), 'suffix_id' => array('name' => 'suffix_id', 'type' => CRM_Utils_Type::T_INT), 'email_greeting_id' => array('name' => 'email_greeting_id', 'type' => CRM_Utils_Type::T_INT), 'email_greeting_custom' => array('name' => 'email_greeting_custom', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Email Greeting Custom'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.email_greeting_custom', 'headerPattern' => '', 'dataPattern' => '', 'export' => false), 'email_greeting_display' => array('name' => 'email_greeting_display', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Email Greeting'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'postal_greeting_id' => array('name' => 'postal_greeting_id', 'type' => CRM_Utils_Type::T_INT), 'postal_greeting_custom' => array('name' => 'postal_greeting_custom', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Postal Greeting Custom'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.postal_greeting_custom', 'headerPattern' => '', 'dataPattern' => '', 'export' => false), 'postal_greeting_display' => array('name' => 'postal_greeting_display', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Postal Greeting'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'addressee_id' => array('name' => 'addressee_id', 'type' => CRM_Utils_Type::T_INT), 'addressee_custom' => array('name' => 'addressee_custom', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Addressee Custom'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.addressee_custom', 'headerPattern' => '', 'dataPattern' => '', 'export' => false), 'addressee_display' => array('name' => 'addressee_display', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Addressee'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'job_title' => array('name' => 'job_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Job Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.job_title', 'headerPattern' => '/^job|(j(ob\\s)?title)$/i', 'dataPattern' => '//', 'export' => true), 'gender_id' => array('name' => 'gender_id', 'type' => CRM_Utils_Type::T_INT), 'birth_date' => array('name' => 'birth_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Birth Date'), '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), 'is_deceased' => array('name' => 'is_deceased', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Deceased'), 'import' => true, 'where' => 'civicrm_contact.is_deceased', 'headerPattern' => '/i(s\\s)?d(eceased)$/i', 'dataPattern' => '', 'export' => true), 'deceased_date' => array('name' => 'deceased_date', 'type' => CRM_Utils_Type::T_DATE, 'title' => ts('Deceased Date'), 'import' => true, 'where' => 'civicrm_contact.deceased_date', 'headerPattern' => '/^deceased|(d(eceased\\s)?date)$/i', 'dataPattern' => '', 'export' => true), 'household_name' => array('name' => 'household_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Household Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.household_name', 'headerPattern' => '/^household|(h(ousehold\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true), 'primary_contact_id' => array('name' => 'primary_contact_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'organization_name' => array('name' => 'organization_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Organization Name'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_contact.organization_name', 'headerPattern' => '/^organization|(o(rganization\\s)?name)$/i', 'dataPattern' => '/^\\w+$/', 'export' => true), 'sic_code' => array('name' => 'sic_code', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Sic 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), 'user_unique_id' => array('name' => 'user_unique_id', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Unique ID (OpenID)'), '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'), 'current_employer_id' => array('name' => 'employer_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Current Employer ID'), 'export' => true, 'where' => 'civicrm_contact.employer_id', 'headerPattern' => '', 'dataPattern' => '', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'is_deleted' => array('name' => 'is_deleted', 'type' => CRM_Utils_Type::T_BOOLEAN, 'required' => true));
     }
     return self::$_fields;
 }