Merge pull request #20115 from larssandergreen/fix-internal-anchor-URLs-in-mailings
[civicrm-core.git] / CRM / Member / DAO / MembershipStatus.php
CommitLineData
e501603b 1<?php
c3fc2621 2
e501603b
TO
3/**
4 * @package CRM
ca5cec67 5 * @copyright CiviCRM LLC https://civicrm.org/licensing
e501603b
TO
6 *
7 * Generated from xml/schema/CRM/Member/MembershipStatus.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
495f49d4 9 * (GenCodeChecksum:e60a982e078b6f3b7d14b16ea2139f14)
e501603b 10 */
c3fc2621 11
f41f0342 12/**
c3fc2621 13 * Database access object for the MembershipStatus entity.
f41f0342 14 */
e501603b 15class CRM_Member_DAO_MembershipStatus extends CRM_Core_DAO {
929a1c14
CW
16 const EXT = 'civicrm';
17 const TABLE_ADDED = '1.5';
d31fb4e3 18 const COMPONENT = 'CiviMember';
c3fc2621 19
e501603b 20 /**
f41f0342 21 * Static instance to hold the table name.
e501603b
TO
22 *
23 * @var string
24 */
fa45b5b9 25 public static $_tableName = 'civicrm_membership_status';
c3fc2621 26
8ab43c93
CW
27 /**
28 * Field to show when displaying a record.
29 *
30 * @var string
31 */
32 public static $_labelField = 'label';
33
e501603b 34 /**
f41f0342 35 * Should CiviCRM log any modifications to this table in the civicrm_log table.
e501603b 36 *
c3fc2621 37 * @var bool
e501603b 38 */
fa45b5b9 39 public static $_log = TRUE;
c3fc2621 40
e501603b 41 /**
2cbbebe8 42 * Membership ID
e501603b 43 *
e6ca0a57 44 * @var int
e501603b
TO
45 */
46 public $id;
c3fc2621 47
e501603b
TO
48 /**
49 * Name for Membership Status
50 *
51 * @var string
52 */
53 public $name;
c3fc2621 54
e501603b
TO
55 /**
56 * Label for Membership Status
57 *
58 * @var string
59 */
60 public $label;
c3fc2621 61
e501603b
TO
62 /**
63 * Event when this status starts.
64 *
65 * @var string
66 */
67 public $start_event;
c3fc2621 68
e501603b
TO
69 /**
70 * Unit used for adjusting from start_event.
71 *
72 * @var string
73 */
74 public $start_event_adjust_unit;
c3fc2621 75
e501603b
TO
76 /**
77 * Status range begins this many units from start_event.
78 *
79 * @var int
80 */
81 public $start_event_adjust_interval;
c3fc2621 82
e501603b
TO
83 /**
84 * Event after which this status ends.
85 *
86 * @var string
87 */
88 public $end_event;
c3fc2621 89
e501603b
TO
90 /**
91 * Unit used for adjusting from the ending event.
92 *
93 * @var string
94 */
95 public $end_event_adjust_unit;
c3fc2621 96
e501603b
TO
97 /**
98 * Status range ends this many units from end_event.
99 *
100 * @var int
101 */
102 public $end_event_adjust_interval;
c3fc2621 103
e501603b
TO
104 /**
105 * Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).
106 *
e6ca0a57 107 * @var bool
e501603b
TO
108 */
109 public $is_current_member;
c3fc2621 110
e501603b
TO
111 /**
112 * Is this status for admin/manual assignment only.
113 *
e6ca0a57 114 * @var bool
e501603b
TO
115 */
116 public $is_admin;
c3fc2621 117
e501603b 118 /**
e501603b
TO
119 * @var int
120 */
121 public $weight;
c3fc2621 122
e501603b
TO
123 /**
124 * Assign this status to a membership record if no other status match is found.
125 *
e6ca0a57 126 * @var bool
e501603b
TO
127 */
128 public $is_default;
c3fc2621 129
e501603b
TO
130 /**
131 * Is this membership_status enabled.
132 *
e6ca0a57 133 * @var bool
e501603b
TO
134 */
135 public $is_active;
c3fc2621 136
e501603b
TO
137 /**
138 * Is this membership_status reserved.
139 *
e6ca0a57 140 * @var bool
e501603b
TO
141 */
142 public $is_reserved;
c3fc2621 143
e501603b 144 /**
f41f0342 145 * Class constructor.
e501603b 146 */
c3fc2621 147 public function __construct() {
e501603b
TO
148 $this->__table = 'civicrm_membership_status';
149 parent::__construct();
150 }
c3fc2621 151
449c4e6b
CW
152 /**
153 * Returns localized title of this entity.
7b66c3b5
AH
154 *
155 * @param bool $plural
156 * Whether to return the plural version of the title.
449c4e6b 157 */
7b66c3b5
AH
158 public static function getEntityTitle($plural = FALSE) {
159 return $plural ? ts('Membership Statuses') : ts('Membership Status');
449c4e6b
CW
160 }
161
e501603b
TO
162 /**
163 * Returns all the column names of this table
164 *
165 * @return array
166 */
c3fc2621 167 public static function &fields() {
346aaaba 168 if (!isset(Civi::$statics[__CLASS__]['fields'])) {
c3fc2621
CW
169 Civi::$statics[__CLASS__]['fields'] = [
170 'id' => [
e501603b
TO
171 'name' => 'id',
172 'type' => CRM_Utils_Type::T_INT,
c3fc2621 173 'title' => ts('Membership Status ID'),
2cbbebe8 174 'description' => ts('Membership ID'),
c3fc2621 175 'required' => TRUE,
a36434b9 176 'where' => 'civicrm_membership_status.id',
522a26c9 177 'table_name' => 'civicrm_membership_status',
178 'entity' => 'MembershipStatus',
179 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 180 'localizable' => 0,
2cbbebe8
A
181 'html' => [
182 'type' => 'Number',
183 ],
1fe423d6 184 'readonly' => TRUE,
a9d0587b 185 'add' => '1.5',
c3fc2621
CW
186 ],
187 'membership_status' => [
e501603b
TO
188 'name' => 'name',
189 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 190 'title' => ts('Membership Status'),
215b423e 191 'description' => ts('Name for Membership Status'),
495f49d4 192 'required' => TRUE,
e501603b
TO
193 'maxlength' => 128,
194 'size' => CRM_Utils_Type::HUGE,
c3fc2621 195 'import' => TRUE,
e501603b 196 'where' => 'civicrm_membership_status.name',
c3fc2621 197 'export' => TRUE,
522a26c9 198 'table_name' => 'civicrm_membership_status',
199 'entity' => 'MembershipStatus',
200 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 201 'localizable' => 0,
a9d0587b 202 'add' => '1.5',
c3fc2621
CW
203 ],
204 'label' => [
e501603b
TO
205 'name' => 'label',
206 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 207 'title' => ts('Label'),
215b423e 208 'description' => ts('Label for Membership Status'),
e501603b
TO
209 'maxlength' => 128,
210 'size' => CRM_Utils_Type::HUGE,
a36434b9 211 'where' => 'civicrm_membership_status.label',
522a26c9 212 'table_name' => 'civicrm_membership_status',
213 'entity' => 'MembershipStatus',
214 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 215 'localizable' => 1,
3a0ba1c5 216 'html' => [
217 'type' => 'Text',
218 ],
a9d0587b 219 'add' => '3.2',
c3fc2621
CW
220 ],
221 'start_event' => [
e501603b
TO
222 'name' => 'start_event',
223 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 224 'title' => ts('Start Event'),
215b423e 225 'description' => ts('Event when this status starts.'),
e501603b
TO
226 'maxlength' => 12,
227 'size' => CRM_Utils_Type::TWELVE,
a36434b9 228 'where' => 'civicrm_membership_status.start_event',
522a26c9 229 'table_name' => 'civicrm_membership_status',
230 'entity' => 'MembershipStatus',
231 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 232 'localizable' => 0,
c3fc2621 233 'html' => [
e501603b 234 'type' => 'Select',
c23563e3 235 'label' => ts("Start Event"),
c3fc2621
CW
236 ],
237 'pseudoconstant' => [
e501603b 238 'callback' => 'CRM_Core_SelectValues::eventDate',
e6ca0a57 239 ],
a9d0587b 240 'add' => '1.5',
c3fc2621
CW
241 ],
242 'start_event_adjust_unit' => [
e501603b
TO
243 'name' => 'start_event_adjust_unit',
244 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 245 'title' => ts('Start Event Adjust Unit'),
215b423e 246 'description' => ts('Unit used for adjusting from start_event.'),
e501603b
TO
247 'maxlength' => 8,
248 'size' => CRM_Utils_Type::EIGHT,
a36434b9 249 'where' => 'civicrm_membership_status.start_event_adjust_unit',
522a26c9 250 'table_name' => 'civicrm_membership_status',
251 'entity' => 'MembershipStatus',
252 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 253 'localizable' => 0,
c3fc2621 254 'html' => [
e501603b 255 'type' => 'Select',
c23563e3 256 'label' => ts("Start Event Adjust Unit"),
c3fc2621
CW
257 ],
258 'pseudoconstant' => [
e501603b 259 'callback' => 'CRM_Core_SelectValues::unitList',
e6ca0a57 260 ],
a9d0587b 261 'add' => '1.5',
c3fc2621
CW
262 ],
263 'start_event_adjust_interval' => [
e501603b
TO
264 'name' => 'start_event_adjust_interval',
265 'type' => CRM_Utils_Type::T_INT,
c3fc2621 266 'title' => ts('Start Event Adjust Interval'),
215b423e 267 'description' => ts('Status range begins this many units from start_event.'),
a36434b9 268 'where' => 'civicrm_membership_status.start_event_adjust_interval',
522a26c9 269 'table_name' => 'civicrm_membership_status',
270 'entity' => 'MembershipStatus',
271 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 272 'localizable' => 0,
c23563e3
SL
273 'html' => [
274 'label' => ts("Start Event Adjust Interval"),
275 ],
a9d0587b 276 'add' => '1.5',
c3fc2621
CW
277 ],
278 'end_event' => [
e501603b
TO
279 'name' => 'end_event',
280 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 281 'title' => ts('End Event'),
215b423e 282 'description' => ts('Event after which this status ends.'),
e501603b
TO
283 'maxlength' => 12,
284 'size' => CRM_Utils_Type::TWELVE,
a36434b9 285 'where' => 'civicrm_membership_status.end_event',
522a26c9 286 'table_name' => 'civicrm_membership_status',
287 'entity' => 'MembershipStatus',
288 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 289 'localizable' => 0,
c3fc2621 290 'html' => [
e501603b 291 'type' => 'Select',
c23563e3 292 'label' => ts("End Event"),
c3fc2621
CW
293 ],
294 'pseudoconstant' => [
e501603b 295 'callback' => 'CRM_Core_SelectValues::eventDate',
e6ca0a57 296 ],
a9d0587b 297 'add' => '1.5',
c3fc2621
CW
298 ],
299 'end_event_adjust_unit' => [
e501603b
TO
300 'name' => 'end_event_adjust_unit',
301 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 302 'title' => ts('End Event Adjust Unit'),
215b423e 303 'description' => ts('Unit used for adjusting from the ending event.'),
e501603b
TO
304 'maxlength' => 8,
305 'size' => CRM_Utils_Type::EIGHT,
a36434b9 306 'where' => 'civicrm_membership_status.end_event_adjust_unit',
522a26c9 307 'table_name' => 'civicrm_membership_status',
308 'entity' => 'MembershipStatus',
309 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 310 'localizable' => 0,
c3fc2621 311 'html' => [
e501603b 312 'type' => 'Select',
c23563e3 313 'label' => ts("End Event Adjust Unit"),
c3fc2621
CW
314 ],
315 'pseudoconstant' => [
e501603b 316 'callback' => 'CRM_Core_SelectValues::unitList',
e6ca0a57 317 ],
a9d0587b 318 'add' => '1.5',
c3fc2621
CW
319 ],
320 'end_event_adjust_interval' => [
e501603b
TO
321 'name' => 'end_event_adjust_interval',
322 'type' => CRM_Utils_Type::T_INT,
c3fc2621 323 'title' => ts('End Event Adjust Interval'),
215b423e 324 'description' => ts('Status range ends this many units from end_event.'),
a36434b9 325 'where' => 'civicrm_membership_status.end_event_adjust_interval',
522a26c9 326 'table_name' => 'civicrm_membership_status',
327 'entity' => 'MembershipStatus',
328 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 329 'localizable' => 0,
c23563e3
SL
330 'html' => [
331 'label' => ts("End Event Adjust Interval"),
332 ],
a9d0587b 333 'add' => '1.5',
c3fc2621
CW
334 ],
335 'is_current_member' => [
e501603b
TO
336 'name' => 'is_current_member',
337 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 338 'title' => ts('Current Membership?'),
215b423e 339 'description' => ts('Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).'),
a36434b9 340 'where' => 'civicrm_membership_status.is_current_member',
522a26c9 341 'table_name' => 'civicrm_membership_status',
342 'entity' => 'MembershipStatus',
343 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 344 'localizable' => 0,
a9d0587b 345 'add' => '1.5',
c3fc2621
CW
346 ],
347 'is_admin' => [
e501603b
TO
348 'name' => 'is_admin',
349 'type' => CRM_Utils_Type::T_BOOLEAN,
3a0ba1c5 350 'title' => ts('Administrator Only?'),
215b423e 351 'description' => ts('Is this status for admin/manual assignment only.'),
a36434b9 352 'where' => 'civicrm_membership_status.is_admin',
522a26c9 353 'table_name' => 'civicrm_membership_status',
354 'entity' => 'MembershipStatus',
355 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 356 'localizable' => 0,
3a0ba1c5 357 'html' => [
358 'type' => 'CheckBox',
359 ],
a9d0587b 360 'add' => '1.5',
c3fc2621
CW
361 ],
362 'weight' => [
e501603b
TO
363 'name' => 'weight',
364 'type' => CRM_Utils_Type::T_INT,
c3fc2621 365 'title' => ts('Order'),
a36434b9 366 'where' => 'civicrm_membership_status.weight',
522a26c9 367 'table_name' => 'civicrm_membership_status',
368 'entity' => 'MembershipStatus',
369 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 370 'localizable' => 0,
a9d0587b 371 'add' => '1.5',
c3fc2621
CW
372 ],
373 'is_default' => [
e501603b
TO
374 'name' => 'is_default',
375 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 376 'title' => ts('Default Status?'),
215b423e 377 'description' => ts('Assign this status to a membership record if no other status match is found.'),
a36434b9 378 'where' => 'civicrm_membership_status.is_default',
522a26c9 379 'table_name' => 'civicrm_membership_status',
380 'entity' => 'MembershipStatus',
381 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 382 'localizable' => 0,
3a0ba1c5 383 'html' => [
384 'type' => 'CheckBox',
385 ],
a9d0587b 386 'add' => '1.5',
c3fc2621
CW
387 ],
388 'is_active' => [
e501603b
TO
389 'name' => 'is_active',
390 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 391 'title' => ts('Is Active'),
215b423e 392 'description' => ts('Is this membership_status enabled.'),
a36434b9 393 'where' => 'civicrm_membership_status.is_active',
e501603b 394 'default' => '1',
522a26c9 395 'table_name' => 'civicrm_membership_status',
396 'entity' => 'MembershipStatus',
397 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 398 'localizable' => 0,
3a0ba1c5 399 'html' => [
400 'type' => 'CheckBox',
401 ],
a9d0587b 402 'add' => '1.5',
c3fc2621
CW
403 ],
404 'is_reserved' => [
e501603b
TO
405 'name' => 'is_reserved',
406 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 407 'title' => ts('Is Reserved'),
215b423e 408 'description' => ts('Is this membership_status reserved.'),
a36434b9 409 'where' => 'civicrm_membership_status.is_reserved',
45a83e42 410 'default' => '0',
522a26c9 411 'table_name' => 'civicrm_membership_status',
412 'entity' => 'MembershipStatus',
413 'bao' => 'CRM_Member_BAO_MembershipStatus',
6a7e5e5d 414 'localizable' => 0,
3a0ba1c5 415 'html' => [
416 'type' => 'CheckBox',
417 ],
a9d0587b 418 'add' => '2.1',
c3fc2621
CW
419 ],
420 ];
346aaaba 421 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
e501603b 422 }
346aaaba 423 return Civi::$statics[__CLASS__]['fields'];
e501603b 424 }
c3fc2621 425
e501603b 426 /**
bd8e0b14 427 * Return a mapping from field-name to the corresponding key (as used in fields()).
e501603b
TO
428 *
429 * @return array
bd8e0b14 430 * Array(string $name => string $uniqueName).
e501603b 431 */
c3fc2621 432 public static function &fieldKeys() {
bd8e0b14
TO
433 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
434 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
e501603b 435 }
bd8e0b14 436 return Civi::$statics[__CLASS__]['fieldKeys'];
e501603b 437 }
c3fc2621 438
e501603b
TO
439 /**
440 * Returns the names of this table
441 *
442 * @return string
443 */
c3fc2621 444 public static function getTableName() {
e501603b
TO
445 return CRM_Core_DAO::getLocaleTableName(self::$_tableName);
446 }
c3fc2621 447
e501603b
TO
448 /**
449 * Returns if this table needs to be logged
450 *
c3fc2621 451 * @return bool
e501603b 452 */
c3fc2621 453 public function getLog() {
e501603b
TO
454 return self::$_log;
455 }
c3fc2621 456
e501603b
TO
457 /**
458 * Returns the list of fields that can be imported
459 *
460 * @param bool $prefix
461 *
462 * @return array
463 */
c3fc2621
CW
464 public static function &import($prefix = FALSE) {
465 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'membership_status', $prefix, []);
60808919 466 return $r;
e501603b 467 }
c3fc2621 468
e501603b
TO
469 /**
470 * Returns the list of fields that can be exported
471 *
472 * @param bool $prefix
473 *
474 * @return array
475 */
c3fc2621
CW
476 public static function &export($prefix = FALSE) {
477 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'membership_status', $prefix, []);
60808919 478 return $r;
e501603b 479 }
c3fc2621 480
e7a6b91a
AS
481 /**
482 * Returns the list of indices
c3fc2621
CW
483 *
484 * @param bool $localize
485 *
486 * @return array
e7a6b91a
AS
487 */
488 public static function indices($localize = TRUE) {
c3fc2621 489 $indices = [];
e7a6b91a
AS
490 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
491 }
c3fc2621 492
e501603b 493}