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