Pass menubar preference as a param. Simplify cache mechanics. (#8)
[civicrm-core.git] / CRM / Core / DAO / Note.php
CommitLineData
e501603b 1<?php
c3fc2621 2
e501603b
TO
3/**
4 * @package CRM
6b83d5bd 5 * @copyright CiviCRM LLC (c) 2004-2019
e501603b
TO
6 *
7 * Generated from xml/schema/CRM/Core/Note.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
afbbfe95 9 * (GenCodeChecksum:daafebd13390de67d82735263e9fa886)
e501603b 10 */
c3fc2621 11
f41f0342 12/**
c3fc2621 13 * Database access object for the Note entity.
f41f0342 14 */
e501603b 15class CRM_Core_DAO_Note extends CRM_Core_DAO {
c3fc2621 16
e501603b 17 /**
f41f0342 18 * Static instance to hold the table name.
e501603b
TO
19 *
20 * @var string
21 */
fa45b5b9 22 public static $_tableName = 'civicrm_note';
c3fc2621 23
e501603b 24 /**
f41f0342 25 * Should CiviCRM log any modifications to this table in the civicrm_log table.
e501603b 26 *
c3fc2621 27 * @var bool
e501603b 28 */
fa45b5b9 29 public static $_log = TRUE;
c3fc2621 30
e501603b
TO
31 /**
32 * Note ID
33 *
34 * @var int unsigned
35 */
36 public $id;
c3fc2621 37
e501603b
TO
38 /**
39 * Name of table where item being referenced is stored.
40 *
41 * @var string
42 */
43 public $entity_table;
c3fc2621 44
e501603b
TO
45 /**
46 * Foreign key to the referenced item.
47 *
48 * @var int unsigned
49 */
50 public $entity_id;
c3fc2621 51
e501603b
TO
52 /**
53 * Note and/or Comment.
54 *
55 * @var text
56 */
57 public $note;
c3fc2621 58
e501603b
TO
59 /**
60 * FK to Contact ID creator
61 *
62 * @var int unsigned
63 */
64 public $contact_id;
c3fc2621 65
e501603b
TO
66 /**
67 * When was this note last modified/edited
68 *
69 * @var date
70 */
71 public $modified_date;
c3fc2621 72
e501603b
TO
73 /**
74 * subject of note description
75 *
76 * @var string
77 */
78 public $subject;
c3fc2621 79
e501603b
TO
80 /**
81 * Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)
82 *
83 * @var string
84 */
85 public $privacy;
c3fc2621 86
e501603b 87 /**
f41f0342 88 * Class constructor.
e501603b 89 */
c3fc2621 90 public function __construct() {
e501603b
TO
91 $this->__table = 'civicrm_note';
92 parent::__construct();
93 }
c3fc2621 94
e501603b 95 /**
f41f0342 96 * Returns foreign keys and entity references.
e501603b
TO
97 *
98 * @return array
99 * [CRM_Core_Reference_Interface]
100 */
c3fc2621 101 public static function getReferenceColumns() {
346aaaba 102 if (!isset(Civi::$statics[__CLASS__]['links'])) {
fa45b5b9 103 Civi::$statics[__CLASS__]['links'] = static::createReferenceColumns(__CLASS__);
c3fc2621
CW
104 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'contact_id', 'civicrm_contact', 'id');
105 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Dynamic(self::getTableName(), 'entity_id', NULL, 'id', 'entity_table');
346aaaba 106 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
e501603b 107 }
346aaaba 108 return Civi::$statics[__CLASS__]['links'];
e501603b 109 }
c3fc2621 110
e501603b
TO
111 /**
112 * Returns all the column names of this table
113 *
114 * @return array
115 */
c3fc2621 116 public static function &fields() {
346aaaba 117 if (!isset(Civi::$statics[__CLASS__]['fields'])) {
c3fc2621
CW
118 Civi::$statics[__CLASS__]['fields'] = [
119 'id' => [
e501603b
TO
120 'name' => 'id',
121 'type' => CRM_Utils_Type::T_INT,
c3fc2621 122 'title' => ts('Note ID'),
215b423e 123 'description' => ts('Note ID'),
c3fc2621 124 'required' => TRUE,
522a26c9 125 'table_name' => 'civicrm_note',
126 'entity' => 'Note',
127 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 128 'localizable' => 0,
c3fc2621
CW
129 ],
130 'entity_table' => [
e501603b
TO
131 'name' => 'entity_table',
132 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 133 'title' => ts('Note Entity'),
215b423e 134 'description' => ts('Name of table where item being referenced is stored.'),
c3fc2621 135 'required' => TRUE,
e501603b
TO
136 'maxlength' => 64,
137 'size' => CRM_Utils_Type::BIG,
522a26c9 138 'table_name' => 'civicrm_note',
139 'entity' => 'Note',
140 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 141 'localizable' => 0,
c3fc2621 142 'pseudoconstant' => [
e501603b 143 'callback' => 'CRM_Core_BAO_Note::entityTables',
c3fc2621
CW
144 ]
145 ],
146 'entity_id' => [
e501603b
TO
147 'name' => 'entity_id',
148 'type' => CRM_Utils_Type::T_INT,
c3fc2621 149 'title' => ts('Note Entity ID'),
215b423e 150 'description' => ts('Foreign key to the referenced item.'),
c3fc2621 151 'required' => TRUE,
522a26c9 152 'table_name' => 'civicrm_note',
153 'entity' => 'Note',
154 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 155 'localizable' => 0,
c3fc2621
CW
156 ],
157 'note' => [
e501603b
TO
158 'name' => 'note',
159 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 160 'title' => ts('Note'),
215b423e 161 'description' => ts('Note and/or Comment.'),
e501603b
TO
162 'rows' => 4,
163 'cols' => 60,
c3fc2621 164 'import' => TRUE,
e501603b
TO
165 'where' => 'civicrm_note.note',
166 'headerPattern' => '/Note|Comment/i',
167 'dataPattern' => '//',
c3fc2621 168 'export' => TRUE,
522a26c9 169 'table_name' => 'civicrm_note',
170 'entity' => 'Note',
171 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 172 'localizable' => 0,
c3fc2621 173 'html' => [
e501603b 174 'type' => 'TextArea',
c3fc2621
CW
175 ],
176 ],
177 'contact_id' => [
e501603b
TO
178 'name' => 'contact_id',
179 'type' => CRM_Utils_Type::T_INT,
c3fc2621 180 'title' => ts('Note Created By'),
215b423e 181 'description' => ts('FK to Contact ID creator'),
522a26c9 182 'table_name' => 'civicrm_note',
183 'entity' => 'Note',
184 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 185 'localizable' => 0,
e501603b 186 'FKClassName' => 'CRM_Contact_DAO_Contact',
c3fc2621
CW
187 ],
188 'modified_date' => [
e501603b
TO
189 'name' => 'modified_date',
190 'type' => CRM_Utils_Type::T_DATE,
c3fc2621 191 'title' => ts('Note Modified By'),
215b423e 192 'description' => ts('When was this note last modified/edited'),
522a26c9 193 'table_name' => 'civicrm_note',
194 'entity' => 'Note',
195 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 196 'localizable' => 0,
c3fc2621
CW
197 ],
198 'subject' => [
e501603b
TO
199 'name' => 'subject',
200 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 201 'title' => ts('Subject'),
215b423e 202 'description' => ts('subject of note description'),
e501603b
TO
203 'maxlength' => 255,
204 'size' => 60,
522a26c9 205 'table_name' => 'civicrm_note',
206 'entity' => 'Note',
207 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 208 'localizable' => 0,
c3fc2621 209 'html' => [
e501603b 210 'type' => 'Text',
c3fc2621
CW
211 ],
212 ],
213 'privacy' => [
e501603b
TO
214 'name' => 'privacy',
215 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 216 'title' => ts('Privacy'),
215b423e 217 'description' => ts('Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)'),
e501603b
TO
218 'maxlength' => 255,
219 'size' => CRM_Utils_Type::HUGE,
522a26c9 220 'table_name' => 'civicrm_note',
221 'entity' => 'Note',
222 'bao' => 'CRM_Core_BAO_Note',
6a7e5e5d 223 'localizable' => 0,
afbbfe95
PN
224 'html' => [
225 'type' => 'Select',
226 ],
c3fc2621 227 'pseudoconstant' => [
e501603b
TO
228 'optionGroupName' => 'note_privacy',
229 'optionEditPath' => 'civicrm/admin/options/note_privacy',
c3fc2621
CW
230 ]
231 ],
232 ];
346aaaba 233 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
e501603b 234 }
346aaaba 235 return Civi::$statics[__CLASS__]['fields'];
e501603b 236 }
c3fc2621 237
e501603b 238 /**
bd8e0b14 239 * Return a mapping from field-name to the corresponding key (as used in fields()).
e501603b
TO
240 *
241 * @return array
bd8e0b14 242 * Array(string $name => string $uniqueName).
e501603b 243 */
c3fc2621 244 public static function &fieldKeys() {
bd8e0b14
TO
245 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
246 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
e501603b 247 }
bd8e0b14 248 return Civi::$statics[__CLASS__]['fieldKeys'];
e501603b 249 }
c3fc2621 250
e501603b
TO
251 /**
252 * Returns the names of this table
253 *
254 * @return string
255 */
c3fc2621 256 public static function getTableName() {
e501603b
TO
257 return self::$_tableName;
258 }
c3fc2621 259
e501603b
TO
260 /**
261 * Returns if this table needs to be logged
262 *
c3fc2621 263 * @return bool
e501603b 264 */
c3fc2621 265 public function getLog() {
e501603b
TO
266 return self::$_log;
267 }
c3fc2621 268
e501603b
TO
269 /**
270 * Returns the list of fields that can be imported
271 *
272 * @param bool $prefix
273 *
274 * @return array
275 */
c3fc2621
CW
276 public static function &import($prefix = FALSE) {
277 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'note', $prefix, []);
60808919 278 return $r;
e501603b 279 }
c3fc2621 280
e501603b
TO
281 /**
282 * Returns the list of fields that can be exported
283 *
284 * @param bool $prefix
285 *
286 * @return array
287 */
c3fc2621
CW
288 public static function &export($prefix = FALSE) {
289 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'note', $prefix, []);
60808919 290 return $r;
e501603b 291 }
c3fc2621 292
e7a6b91a
AS
293 /**
294 * Returns the list of indices
c3fc2621
CW
295 *
296 * @param bool $localize
297 *
298 * @return array
e7a6b91a
AS
299 */
300 public static function indices($localize = TRUE) {
c3fc2621
CW
301 $indices = [
302 'index_entity' => [
e7a6b91a 303 'name' => 'index_entity',
c3fc2621 304 'field' => [
e7a6b91a
AS
305 0 => 'entity_table',
306 1 => 'entity_id',
c3fc2621
CW
307 ],
308 'localizable' => FALSE,
e7a6b91a 309 'sig' => 'civicrm_note::0::entity_table::entity_id',
c3fc2621
CW
310 ],
311 ];
e7a6b91a
AS
312 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
313 }
c3fc2621 314
e501603b 315}