6718b8541fdf8585ed84ace6e46328d3d2c51977
[civicrm-core.git] / xml / templates / dao.tpl
1 <?php
2 /**
3 * @package CRM
4 * @copyright CiviCRM LLC https://civicrm.org/licensing
5 *
6 * Generated from {$table.sourceFile}
7 * {$generated}
8 * (GenCodeChecksum:{$genCodeChecksum})
9 */
10
11 /**
12 * Database access object for the {$table.entity} entity.
13 */
14 class {$table.className} extends CRM_Core_DAO {ldelim}
15
16 /**
17 * Static instance to hold the table name.
18 *
19 * @var string
20 */
21 public static $_tableName = '{$table.name}';
22
23 /**
24 * Should CiviCRM log any modifications to this table in the civicrm_log table.
25 *
26 * @var bool
27 */
28 public static $_log = {$table.log|strtoupper};
29
30 {foreach from=$table.fields item=field}
31 /**
32 {if $field.comment}
33 * {$field.comment|regex_replace:"/\n[ ]*/":"\n* "}
34 *
35 {/if}
36 * @var {$field.phpType}
37 */
38 public ${$field.name};
39
40 {/foreach} {* table.fields *}
41
42 /**
43 * Class constructor.
44 */
45 public function __construct( ) {ldelim}
46 $this->__table = '{$table.name}';
47
48 parent::__construct( );
49 {rdelim}
50
51 {if $table.foreignKey || $table.dynamicForeignKey}
52 /**
53 * Returns foreign keys and entity references.
54 *
55 * @return array
56 * [CRM_Core_Reference_Interface]
57 */
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}');
63 {/foreach}
64
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}');
67 {/foreach}
68 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
69 {rdelim}
70 return Civi::$statics[__CLASS__]['links'];
71 {rdelim}
72 {/if} {* table.foreignKey *}
73
74 /**
75 * Returns all the column names of this table
76 *
77 * @return array
78 */
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}
83
84 {if $field.uniqueName}
85 '{$field.uniqueName}'
86 {else}
87 '{$field.name}'
88 {/if}
89 => array(
90 'name' => '{$field.name}',
91 'type' => {$field.crmType},
92 {if $field.title}
93 'title' => {$tsFunctionName}('{$field.title}'),
94 {/if}
95 {if $field.comment}
96 'description' => {$tsFunctionName}('{$field.comment|replace:"'":"\'"}'),
97 {/if}
98 {if $field.required}
99 'required' => {$field.required|strtoupper},
100 {/if} {* field.required *}
101 {if $field.length}
102 'maxlength' => {$field.length},
103 {/if} {* field.length *}
104 {if $field.precision}
105 'precision' => array({$field.precision}),
106 {/if}
107 {if $field.size}
108 'size' => {$field.size},
109 {/if} {* field.size *}
110 {if $field.rows}
111 'rows' => {$field.rows},
112 {/if} {* field.rows *}
113 {if $field.cols}
114 'cols' => {$field.cols},
115 {/if} {* field.cols *}
116
117 {if $field.import}
118 'import' => {$field.import|strtoupper},
119
120 {/if} {* field.import *}
121 'where' => '{$table.name}.{$field.name}',
122 {if $field.headerPattern}'headerPattern' => '{$field.headerPattern}',{/if}
123 {if $field.dataPattern}'dataPattern' => '{$field.dataPattern}',{/if}
124 {if $field.export}
125 'export' => {$field.export|strtoupper},
126 {/if} {* field.export *}
127
128 {if $field.rule}
129 'rule' => '{$field.rule}',
130 {/if} {* field.rule *}
131 {if !empty($field.permission)}
132 'permission' => {$field.permission|@print_array},
133 {/if}
134 {if $field.default || $field.default === '0'}
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},
141 {if $field.localize_context}'localize_context' => '{$field.localize_context}',{/if}
142
143 {if $field.FKClassName}
144 'FKClassName' => '{$field.FKClassName}',
145 {/if}
146 {if $field.serialize}
147 'serialize' => self::SERIALIZE_{$field.serialize|strtoupper},
148 {/if}
149 {if $field.uniqueTitle}
150 'unique_title' => {$tsFunctionName}('{$field.uniqueTitle}'),
151 {/if}
152 {if $field.html}
153 'html' => array(
154 {foreach from=$field.html item=val key=key}
155 '{$key}' => {if $key eq 'label'}{$tsFunctionName}("{$val}"){else}'{$val}'{/if},
156 {/foreach}
157 ),
158 {/if}
159 {if $field.pseudoconstant}
160 'pseudoconstant' => {$field.pseudoconstant|@print_array},
161 {/if} {* field.pseudoconstant *} ),
162 {/foreach} {* table.fields *}
163 );
164 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
165 {rdelim}
166 return Civi::$statics[__CLASS__]['fields'];
167 {rdelim}
168
169 /**
170 * Return a mapping from field-name to the corresponding key (as used in fields()).
171 *
172 * @return array
173 * Array(string $name => string $uniqueName).
174 */
175 public static function &fieldKeys( ) {ldelim}
176 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {ldelim}
177 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
178 {rdelim}
179 return Civi::$statics[__CLASS__]['fieldKeys'];
180 {rdelim}
181
182 /**
183 * Returns the names of this table
184 *
185 * @return string
186 */
187 public static function getTableName( ) {ldelim}
188 {if $table.localizable}
189 return CRM_Core_DAO::getLocaleTableName( self::$_tableName );
190 {else}
191 return self::$_tableName;
192 {/if}
193 {rdelim}
194
195 /**
196 * Returns if this table needs to be logged
197 *
198 * @return bool
199 */
200 public function getLog( ) {ldelim}
201 return self::$_log;
202 {rdelim}
203
204 /**
205 * Returns the list of fields that can be imported
206 *
207 * @param bool $prefix
208 *
209 * @return array
210 */
211 public static function &import( $prefix = FALSE ) {ldelim}
212 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, '{$table.labelName}', $prefix, array(
213 {if $table.foreignKey}{foreach from=$table.foreignKey item=foreign}
214 {if $foreign.import}'{$foreign.className}',{/if}
215 {/foreach}{/if}
216 ));
217 return $r;
218 {rdelim}
219
220 /**
221 * Returns the list of fields that can be exported
222 *
223 * @param bool $prefix
224 *
225 * @return array
226 */
227 public static function &export( $prefix = FALSE ) {ldelim}
228 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, '{$table.labelName}', $prefix, array(
229 {if $table.foreignKey}{foreach from=$table.foreignKey item=foreign}
230 {if $foreign.export}'{$foreign.className}',{/if}
231 {/foreach}{/if}
232 ));
233 return $r;
234 {rdelim}
235
236 /**
237 * Returns the list of indices
238 *
239 * @param bool $localize
240 *
241 * @return array
242 */
243 public static function indices($localize = TRUE) {ldelim}
244 $indices = {$indicesPhp};
245 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
246 {rdelim}
247
248 {rdelim}