__table = 'civicrm_country'; parent::__construct(); } /** * Returns foreign keys and entity references. * * @return array * [CRM_Core_Reference_Interface] */ static function getReferenceColumns() { if (!isset(Civi::$statics[__CLASS__]['links'])) { Civi::$statics[__CLASS__]['links'] = static ::createReferenceColumns(__CLASS__); Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName() , 'address_format_id', 'civicrm_address_format', 'id'); Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName() , 'region_id', 'civicrm_worldregion', 'id'); CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']); } return Civi::$statics[__CLASS__]['links']; } /** * 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('Country ID') , 'description' => 'Country Id', 'required' => true, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , 'name' => array( 'name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Country') , 'description' => 'Country Name', 'maxlength' => 64, 'size' => CRM_Utils_Type::BIG, 'import' => true, 'where' => 'civicrm_country.name', 'headerPattern' => '/country/i', 'dataPattern' => '/^[A-Z][a-z]+\.?(\s+[A-Z][a-z]+){0,3}$/', 'export' => true, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , 'iso_code' => array( 'name' => 'iso_code', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Country ISO Code') , 'description' => 'ISO Code', 'maxlength' => 2, 'size' => CRM_Utils_Type::TWO, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , 'country_code' => array( 'name' => 'country_code', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Country Phone Prefix') , 'description' => 'National prefix to be used when dialing TO this country.', 'maxlength' => 4, 'size' => CRM_Utils_Type::FOUR, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , 'address_format_id' => array( 'name' => 'address_format_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Address Format') , 'description' => 'Foreign key to civicrm_address_format.id.', 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, 'FKClassName' => 'CRM_Core_DAO_AddressFormat', ) , 'idd_prefix' => array( 'name' => 'idd_prefix', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Outgoing Phone Prefix') , 'description' => 'International direct dialing prefix from within the country TO another country', 'maxlength' => 4, 'size' => CRM_Utils_Type::FOUR, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , 'ndd_prefix' => array( 'name' => 'ndd_prefix', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Area Code') , 'description' => 'Access prefix to call within a country to a different area', 'maxlength' => 4, 'size' => CRM_Utils_Type::FOUR, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , 'region_id' => array( 'name' => 'region_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Region') , 'description' => 'Foreign key to civicrm_worldregion.id.', 'required' => true, 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, 'FKClassName' => 'CRM_Core_DAO_Worldregion', ) , 'is_province_abbreviated' => array( 'name' => 'is_province_abbreviated', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Abbreviate Province?') , 'description' => 'Should state/province be displayed as abbreviation for contacts from this country?', 'table_name' => 'civicrm_country', 'entity' => 'Country', 'bao' => 'CRM_Core_BAO_Country', 'localizable' => 0, ) , ); CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']); } return Civi::$statics[__CLASS__]['fields']; } /** * Return a mapping from field-name to the corresponding key (as used in fields()). * * @return array * Array(string $name => string $uniqueName). */ static function &fieldKeys() { if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) { Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields())); } return Civi::$statics[__CLASS__]['fieldKeys']; } /** * Returns the names of this table * * @return string */ static function getTableName() { return self::$_tableName; } /** * Returns if this table needs to be logged * * @return boolean */ function getLog() { return self::$_log; } /** * Returns the list of fields that can be imported * * @param bool $prefix * * @return array */ static function &import($prefix = false) { $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'country', $prefix, array()); return $r; } /** * Returns the list of fields that can be exported * * @param bool $prefix * * @return array */ static function &export($prefix = false) { $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'country', $prefix, array()); return $r; } /** * Returns the list of indices */ public static function indices($localize = TRUE) { $indices = array( 'UI_name_iso_code' => array( 'name' => 'UI_name_iso_code', 'field' => array( 0 => 'name', 1 => 'iso_code', ) , 'localizable' => false, 'unique' => true, 'sig' => 'civicrm_country::1::name::iso_code', ) , ); return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices; } }