4 * @copyright CiviCRM LLC (c) 2004-2017
6 * Generated from {$table.sourceFile}
8 * (GenCodeChecksum:{$genCodeChecksum})
12 * Database access object for the {$table.entity} entity.
14 class {$table.className} extends CRM_Core_DAO {ldelim}
17 * Static instance to hold the table name.
21 static $_tableName = '{$table.name}';
24 * Should CiviCRM log any modifications to this table in the civicrm_log table.
28 static $_log = {$table.log|strtoupper};
30 {foreach from=$table.fields item=field}
36 * @var {$field.phpType}
38 public ${$field.name};
40 {/foreach} {* table.fields *}
45 public function __construct( ) {ldelim}
46 $this->__table = '{$table.name}';
48 parent::__construct( );
51 {if $table.foreignKey || $table.dynamicForeignKey}
53 * Returns foreign keys and entity references.
56 * [CRM_Core_Reference_Interface]
58 public static function getReferenceColumns() {ldelim}
59 if (!isset(Civi::$statics[__CLASS__]['links'])) {ldelim}
60 Civi::$statics[__CLASS__]['links'] = static::createReferenceColumns(__CLASS__);
61 {foreach from=$table.foreignKey item=foreign}
62 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), '{$foreign.name}', '{$foreign.table}', '{$foreign.key}');
65 {foreach from=$table.dynamicForeignKey item=foreign}
66 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Dynamic(self::getTableName(), '{$foreign.idColumn}', NULL, '{$foreign.key|default:'id'}', '{$foreign.typeColumn}');
68 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
70 return Civi::$statics[__CLASS__]['links'];
72 {/if} {* table.foreignKey *}
75 * Returns all the column names of this table
79 public static function &fields( ) {ldelim}
80 if ( ! isset(Civi::$statics[__CLASS__]['fields']) ) {ldelim}
81 Civi::$statics[__CLASS__]['fields'] = array(
82 {foreach from=$table.fields item=field}
84 {if $field.uniqueName}
90 'name' => '{$field.name}',
91 'type' => {$field.crmType},
93 'title' => ts('{$field.title}'),
96 'description' => '{$field.comment|replace:"'":"\'"}',
99 'required' => {$field.required|strtoupper},
100 {/if} {* field.required *}
102 'maxlength' => {$field.length},
103 {/if} {* field.length *}
104 {if $field.precision}
105 'precision' => array({$field.precision}),
108 'size' => {$field.size},
109 {/if} {* field.size *}
111 'rows' => {$field.rows},
112 {/if} {* field.rows *}
114 'cols' => {$field.cols},
115 {/if} {* field.cols *}
118 'import' => {$field.import|strtoupper},
119 'where' => '{$table.name}.{$field.name}',
120 'headerPattern' => '{$field.headerPattern}',
121 'dataPattern' => '{$field.dataPattern}',
122 {/if} {* field.import *}
124 'export' => {$field.export|strtoupper},
126 'where' => '{$table.name}.{$field.name}',
127 'headerPattern' => '{$field.headerPattern}',
128 'dataPattern' => '{$field.dataPattern}',
130 {/if} {* field.export *}
132 'rule' => '{$field.rule}',
133 {/if} {* field.rule *}
135 'default' => '{if ($field.default[0]=="'" or $field.default[0]=='"')}{$field.default|substring:1:-1}{else}{$field.default}{/if}',
136 {/if} {* field.default *}
137 'table_name' => '{$table.name}',
138 'entity' => '{$table.entity}',
139 'bao' => '{$table.bao}',
140 'localizable' => {if ($field.localizable)}{1}{else}{0}{/if},
142 {if $field.FKClassName}
143 'FKClassName' => '{$field.FKClassName}',
145 {if $field.serialize}
146 'serialize' => self::SERIALIZE_{$field.serialize|strtoupper},
149 'html' => {$field.html|@print_array},
150 {/if} {* field.html *}
151 {if $field.pseudoconstant}
152 'pseudoconstant' => {$field.pseudoconstant|@print_array}
153 {/if} {* field.pseudoconstant *} ),
154 {/foreach} {* table.fields *}
156 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
158 return Civi::$statics[__CLASS__]['fields'];
162 * Return a mapping from field-name to the corresponding key (as used in fields()).
165 * Array(string $name => string $uniqueName).
167 public static function &fieldKeys( ) {ldelim}
168 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {ldelim}
169 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
171 return Civi::$statics[__CLASS__]['fieldKeys'];
175 * Returns the names of this table
179 public static function getTableName( ) {ldelim}
180 {if $table.localizable}
181 return CRM_Core_DAO::getLocaleTableName( self::$_tableName );
183 return self::$_tableName;
188 * Returns if this table needs to be logged
192 public function getLog( ) {ldelim}
197 * Returns the list of fields that can be imported
199 * @param bool $prefix
203 public static function &import( $prefix = FALSE ) {ldelim}
204 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, '{$table.labelName}', $prefix, array(
205 {if $table.foreignKey}{foreach from=$table.foreignKey item=foreign}
206 {if $foreign.import}'{$foreign.className}',{/if}
213 * Returns the list of fields that can be exported
215 * @param bool $prefix
219 public static function &export( $prefix = FALSE ) {ldelim}
220 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, '{$table.labelName}', $prefix, array(
221 {if $table.foreignKey}{foreach from=$table.foreignKey item=foreign}
222 {if $foreign.export}'{$foreign.className}',{/if}
229 * Returns the list of indices
231 * @param bool $localize
235 public static function indices($localize = TRUE) {ldelim}
236 $indices = {$indicesPhp};
237 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;