Merge pull request #12054 from mattwire/deprecated_paymentprocessortype
[civicrm-core.git] / CRM / Event / DAO / Event.php
CommitLineData
e501603b 1<?php
c3fc2621 2
e501603b
TO
3/**
4 * @package CRM
8c9251b3 5 * @copyright CiviCRM LLC (c) 2004-2018
e501603b
TO
6 *
7 * Generated from xml/schema/CRM/Event/Event.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
e7a6b91a 9 * (GenCodeChecksum:6c0950f3a5f6305f8d7e0a05d4703018)
e501603b 10 */
c3fc2621 11
f41f0342 12/**
c3fc2621 13 * Database access object for the Event entity.
f41f0342 14 */
e501603b 15class CRM_Event_DAO_Event extends CRM_Core_DAO {
c3fc2621 16
e501603b 17 /**
f41f0342 18 * Static instance to hold the table name.
e501603b
TO
19 *
20 * @var string
21 */
22 static $_tableName = 'civicrm_event';
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 */
c3fc2621
CW
29 static $_log = TRUE;
30
e501603b
TO
31 /**
32 * Event
33 *
34 * @var int unsigned
35 */
36 public $id;
c3fc2621 37
e501603b
TO
38 /**
39 * Event Title (e.g. Fall Fundraiser Dinner)
40 *
41 * @var string
42 */
43 public $title;
c3fc2621 44
e501603b
TO
45 /**
46 * Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.
47 *
48 * @var text
49 */
50 public $summary;
c3fc2621 51
e501603b
TO
52 /**
53 * Full description of event. Text and html allowed. Displayed on built-in Event Information screens.
54 *
55 * @var text
56 */
57 public $description;
c3fc2621 58
e501603b
TO
59 /**
60 * Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.
61 *
62 * @var int unsigned
63 */
64 public $event_type_id;
c3fc2621 65
e501603b
TO
66 /**
67 * Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.
68 *
69 * @var int unsigned
70 */
71 public $participant_listing_id;
c3fc2621 72
e501603b
TO
73 /**
74 * Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.
75 *
76 * @var boolean
77 */
78 public $is_public;
c3fc2621 79
e501603b
TO
80 /**
81 * Date and time that event starts.
82 *
83 * @var datetime
84 */
85 public $start_date;
c3fc2621 86
e501603b
TO
87 /**
88 * Date and time that event ends. May be NULL if no defined end date/time
89 *
90 * @var datetime
91 */
92 public $end_date;
c3fc2621 93
e501603b
TO
94 /**
95 * If true, include registration link on Event Info page.
96 *
97 * @var boolean
98 */
99 public $is_online_registration;
c3fc2621 100
e501603b
TO
101 /**
102 * Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.
103 *
104 * @var string
105 */
106 public $registration_link_text;
c3fc2621 107
e501603b
TO
108 /**
109 * Date and time that online registration starts.
110 *
111 * @var datetime
112 */
113 public $registration_start_date;
c3fc2621 114
e501603b
TO
115 /**
116 * Date and time that online registration ends.
117 *
118 * @var datetime
119 */
120 public $registration_end_date;
c3fc2621 121
e501603b
TO
122 /**
123 * Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.
124 *
125 * @var int unsigned
126 */
127 public $max_participants;
c3fc2621 128
e501603b
TO
129 /**
130 * Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.
131 *
132 * @var text
133 */
134 public $event_full_text;
c3fc2621 135
e501603b
TO
136 /**
137 * If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.
138 *
139 * @var boolean
140 */
141 public $is_monetary;
c3fc2621 142
e501603b
TO
143 /**
144 * Financial type assigned to paid event registrations for this event. Required if is_monetary is true.
145 *
146 * @var int unsigned
147 */
148 public $financial_type_id;
c3fc2621 149
e501603b
TO
150 /**
151 * Payment Processors configured for this Event (if is_monetary is true)
152 *
153 * @var string
154 */
155 public $payment_processor;
c3fc2621 156
e501603b
TO
157 /**
158 * Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?
159 *
160 * @var boolean
161 */
162 public $is_map;
c3fc2621 163
e501603b
TO
164 /**
165 * Is this Event enabled or disabled/cancelled?
166 *
167 * @var boolean
168 */
169 public $is_active;
c3fc2621 170
e501603b 171 /**
e501603b
TO
172 * @var string
173 */
174 public $fee_label;
c3fc2621 175
e501603b
TO
176 /**
177 * If true, show event location.
178 *
179 * @var boolean
180 */
181 public $is_show_location;
c3fc2621 182
e501603b
TO
183 /**
184 * FK to Location Block ID
185 *
186 * @var int unsigned
187 */
188 public $loc_block_id;
c3fc2621 189
e501603b
TO
190 /**
191 * Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
192 *
193 * @var int unsigned
194 */
195 public $default_role_id;
c3fc2621 196
e501603b
TO
197 /**
198 * Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
199 *
200 * @var text
201 */
202 public $intro_text;
c3fc2621 203
e501603b
TO
204 /**
205 * Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
206 *
207 * @var text
208 */
209 public $footer_text;
c3fc2621 210
e501603b
TO
211 /**
212 * Title for Confirmation page.
213 *
214 * @var string
215 */
216 public $confirm_title;
c3fc2621 217
e501603b
TO
218 /**
219 * Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
220 *
221 * @var text
222 */
223 public $confirm_text;
c3fc2621 224
e501603b
TO
225 /**
226 * Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
227 *
228 * @var text
229 */
230 public $confirm_footer_text;
c3fc2621 231
e501603b
TO
232 /**
233 * If true, confirmation is automatically emailed to contact on successful registration.
234 *
235 * @var boolean
236 */
237 public $is_email_confirm;
c3fc2621 238
e501603b
TO
239 /**
240 * text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now
241 *
242 * @var text
243 */
244 public $confirm_email_text;
c3fc2621 245
e501603b
TO
246 /**
247 * FROM email name used for confirmation emails.
248 *
249 * @var string
250 */
251 public $confirm_from_name;
c3fc2621 252
e501603b
TO
253 /**
254 * FROM email address used for confirmation emails.
255 *
256 * @var string
257 */
258 public $confirm_from_email;
c3fc2621 259
e501603b
TO
260 /**
261 * comma-separated list of email addresses to cc each time a confirmation is sent
262 *
263 * @var string
264 */
265 public $cc_confirm;
c3fc2621 266
e501603b
TO
267 /**
268 * comma-separated list of email addresses to bcc each time a confirmation is sent
269 *
270 * @var string
271 */
272 public $bcc_confirm;
c3fc2621 273
e501603b
TO
274 /**
275 * FK to civicrm_option_value.
276 *
277 * @var int unsigned
278 */
279 public $default_fee_id;
c3fc2621 280
e501603b
TO
281 /**
282 * FK to civicrm_option_value.
283 *
284 * @var int unsigned
285 */
286 public $default_discount_fee_id;
c3fc2621 287
e501603b
TO
288 /**
289 * Title for ThankYou page.
290 *
291 * @var string
292 */
293 public $thankyou_title;
c3fc2621 294
e501603b
TO
295 /**
296 * ThankYou Text.
297 *
298 * @var text
299 */
300 public $thankyou_text;
c3fc2621 301
e501603b
TO
302 /**
303 * Footer message.
304 *
305 * @var text
306 */
307 public $thankyou_footer_text;
c3fc2621 308
e501603b
TO
309 /**
310 * if true - allows the user to send payment directly to the org later
311 *
312 * @var boolean
313 */
314 public $is_pay_later;
c3fc2621 315
e501603b
TO
316 /**
317 * The text displayed to the user in the main form
318 *
319 * @var text
320 */
321 public $pay_later_text;
c3fc2621 322
e501603b
TO
323 /**
324 * The receipt sent to the user instead of the normal receipt text
325 *
326 * @var text
327 */
328 public $pay_later_receipt;
c3fc2621 329
e501603b
TO
330 /**
331 * is partial payment enabled for this event
332 *
333 * @var boolean
334 */
335 public $is_partial_payment;
c3fc2621 336
e501603b
TO
337 /**
338 * Initial amount label for partial payment
339 *
340 * @var string
341 */
342 public $initial_amount_label;
c3fc2621 343
e501603b
TO
344 /**
345 * Initial amount help text for partial payment
346 *
347 * @var text
348 */
349 public $initial_amount_help_text;
c3fc2621 350
e501603b
TO
351 /**
352 * Minimum initial amount for partial payment
353 *
354 * @var float
355 */
356 public $min_initial_amount;
c3fc2621 357
e501603b
TO
358 /**
359 * if true - allows the user to register multiple participants for event
360 *
361 * @var boolean
362 */
363 public $is_multiple_registrations;
c3fc2621 364
e501603b
TO
365 /**
366 * Maximum number of additional participants that can be registered on a single booking
367 *
368 * @var int unsigned
369 */
370 public $max_additional_participants;
c3fc2621 371
e501603b
TO
372 /**
373 * if true - allows the user to register multiple registrations from same email address.
374 *
375 * @var boolean
376 */
377 public $allow_same_participant_emails;
c3fc2621 378
e501603b
TO
379 /**
380 * Whether the event has waitlist support.
381 *
382 * @var boolean
383 */
384 public $has_waitlist;
c3fc2621 385
e501603b
TO
386 /**
387 * Whether participants require approval before they can finish registering.
388 *
389 * @var boolean
390 */
391 public $requires_approval;
c3fc2621 392
e501603b
TO
393 /**
394 * Expire pending but unconfirmed registrations after this many hours.
395 *
396 * @var int unsigned
397 */
398 public $expiration_time;
c3fc2621 399
e501603b
TO
400 /**
401 * Allow self service cancellation or transfer for event?
402 *
403 * @var boolean
404 */
405 public $allow_selfcancelxfer;
c3fc2621 406
e501603b
TO
407 /**
408 * Number of hours prior to event start date to allow self-service cancellation or transfer.
409 *
410 * @var int unsigned
411 */
412 public $selfcancelxfer_time;
c3fc2621 413
e501603b
TO
414 /**
415 * Text to display when the event is full, but participants can signup for a waitlist.
416 *
417 * @var text
418 */
419 public $waitlist_text;
c3fc2621 420
e501603b
TO
421 /**
422 * Text to display when the approval is required to complete registration for an event.
423 *
424 * @var text
425 */
426 public $approval_req_text;
c3fc2621 427
e501603b
TO
428 /**
429 * whether the event has template
430 *
431 * @var boolean
432 */
433 public $is_template;
c3fc2621 434
e501603b
TO
435 /**
436 * Event Template Title
437 *
438 * @var string
439 */
440 public $template_title;
c3fc2621 441
e501603b
TO
442 /**
443 * FK to civicrm_contact, who created this event
444 *
445 * @var int unsigned
446 */
447 public $created_id;
c3fc2621 448
e501603b
TO
449 /**
450 * Date and time that event was created.
451 *
452 * @var datetime
453 */
454 public $created_date;
c3fc2621 455
e501603b
TO
456 /**
457 * 3 character string, value from config setting or input via user.
458 *
459 * @var string
460 */
461 public $currency;
c3fc2621 462
e501603b
TO
463 /**
464 * The campaign for which this event has been created.
465 *
466 * @var int unsigned
467 */
468 public $campaign_id;
c3fc2621 469
e501603b
TO
470 /**
471 * Can people share the event through social media?
472 *
473 * @var boolean
474 */
475 public $is_share;
c3fc2621 476
e501603b
TO
477 /**
478 * If false, the event booking confirmation screen gets skipped
479 *
480 * @var boolean
481 */
482 public $is_confirm_enabled;
c3fc2621 483
e501603b
TO
484 /**
485 * Implicit FK to civicrm_event: parent event
486 *
487 * @var int unsigned
488 */
489 public $parent_event_id;
c3fc2621 490
e501603b
TO
491 /**
492 * Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.
493 *
494 * @var int unsigned
495 */
496 public $slot_label_id;
c3fc2621 497
e501603b
TO
498 /**
499 * Rule to use when matching registrations for this event
500 *
501 * @var int unsigned
502 */
503 public $dedupe_rule_group_id;
c3fc2621 504
e501603b
TO
505 /**
506 * if true than billing block is required this event
507 *
508 * @var boolean
509 */
510 public $is_billing_required;
c3fc2621 511
e501603b 512 /**
f41f0342 513 * Class constructor.
e501603b 514 */
c3fc2621 515 public function __construct() {
e501603b
TO
516 $this->__table = 'civicrm_event';
517 parent::__construct();
518 }
c3fc2621 519
e501603b 520 /**
f41f0342 521 * Returns foreign keys and entity references.
e501603b
TO
522 *
523 * @return array
524 * [CRM_Core_Reference_Interface]
525 */
c3fc2621 526 public static function getReferenceColumns() {
346aaaba
TO
527 if (!isset(Civi::$statics[__CLASS__]['links'])) {
528 Civi::$statics[__CLASS__]['links'] = static ::createReferenceColumns(__CLASS__);
c3fc2621
CW
529 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'loc_block_id', 'civicrm_loc_block', 'id');
530 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'created_id', 'civicrm_contact', 'id');
531 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
532 Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'dedupe_rule_group_id', 'civicrm_dedupe_rule_group', 'id');
346aaaba 533 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
e501603b 534 }
346aaaba 535 return Civi::$statics[__CLASS__]['links'];
e501603b 536 }
c3fc2621 537
e501603b
TO
538 /**
539 * Returns all the column names of this table
540 *
541 * @return array
542 */
c3fc2621 543 public static function &fields() {
346aaaba 544 if (!isset(Civi::$statics[__CLASS__]['fields'])) {
c3fc2621
CW
545 Civi::$statics[__CLASS__]['fields'] = [
546 'id' => [
e501603b
TO
547 'name' => 'id',
548 'type' => CRM_Utils_Type::T_INT,
c3fc2621 549 'title' => ts('Event ID'),
e501603b 550 'description' => 'Event',
c3fc2621 551 'required' => TRUE,
522a26c9 552 'table_name' => 'civicrm_event',
553 'entity' => 'Event',
554 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 555 'localizable' => 0,
c3fc2621
CW
556 ],
557 'event_title' => [
e501603b
TO
558 'name' => 'title',
559 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 560 'title' => ts('Event Title'),
e501603b
TO
561 'description' => 'Event Title (e.g. Fall Fundraiser Dinner)',
562 'maxlength' => 255,
563 'size' => CRM_Utils_Type::HUGE,
c3fc2621 564 'import' => TRUE,
e501603b
TO
565 'where' => 'civicrm_event.title',
566 'headerPattern' => '/(event.)?title$/i',
567 'dataPattern' => '',
c3fc2621 568 'export' => TRUE,
522a26c9 569 'table_name' => 'civicrm_event',
570 'entity' => 'Event',
571 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 572 'localizable' => 1,
c3fc2621 573 'html' => [
e501603b 574 'type' => 'Text',
c3fc2621
CW
575 ],
576 ],
577 'summary' => [
e501603b
TO
578 'name' => 'summary',
579 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 580 'title' => ts('Event Summary'),
e501603b
TO
581 'description' => 'Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.',
582 'rows' => 4,
583 'cols' => 60,
522a26c9 584 'table_name' => 'civicrm_event',
585 'entity' => 'Event',
586 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 587 'localizable' => 1,
c3fc2621 588 'html' => [
e501603b 589 'type' => 'TextArea',
c3fc2621
CW
590 ],
591 ],
592 'event_description' => [
e501603b
TO
593 'name' => 'description',
594 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 595 'title' => ts('Event Description'),
e501603b
TO
596 'description' => 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.',
597 'rows' => 8,
598 'cols' => 60,
522a26c9 599 'table_name' => 'civicrm_event',
600 'entity' => 'Event',
601 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 602 'localizable' => 1,
c3fc2621 603 'html' => [
e501603b 604 'type' => 'TextArea',
c3fc2621
CW
605 ],
606 ],
607 'event_type_id' => [
e501603b
TO
608 'name' => 'event_type_id',
609 'type' => CRM_Utils_Type::T_INT,
c3fc2621 610 'title' => ts('Event Type'),
e501603b 611 'description' => 'Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.',
522a26c9 612 'table_name' => 'civicrm_event',
613 'entity' => 'Event',
614 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 615 'localizable' => 0,
c3fc2621 616 'html' => [
e501603b 617 'type' => 'Select',
c3fc2621
CW
618 ],
619 'pseudoconstant' => [
e501603b
TO
620 'optionGroupName' => 'event_type',
621 'optionEditPath' => 'civicrm/admin/options/event_type',
c3fc2621
CW
622 ]
623 ],
624 'participant_listing_id' => [
e501603b
TO
625 'name' => 'participant_listing_id',
626 'type' => CRM_Utils_Type::T_INT,
c3fc2621 627 'title' => ts('Participant Listing'),
e501603b 628 'description' => 'Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.',
522a26c9 629 'table_name' => 'civicrm_event',
630 'entity' => 'Event',
631 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 632 'localizable' => 0,
c3fc2621 633 'html' => [
e501603b 634 'type' => 'Select',
c3fc2621
CW
635 ],
636 'pseudoconstant' => [
e501603b
TO
637 'optionGroupName' => 'participant_listing',
638 'optionEditPath' => 'civicrm/admin/options/participant_listing',
c3fc2621
CW
639 ]
640 ],
641 'is_public' => [
e501603b
TO
642 'name' => 'is_public',
643 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 644 'title' => ts('Is Event Public'),
e501603b
TO
645 'description' => 'Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.',
646 'default' => '1',
522a26c9 647 'table_name' => 'civicrm_event',
648 'entity' => 'Event',
649 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 650 'localizable' => 0,
c3fc2621 651 'html' => [
e501603b 652 'type' => 'CheckBox',
c3fc2621
CW
653 ],
654 ],
655 'event_start_date' => [
e501603b
TO
656 'name' => 'start_date',
657 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
c3fc2621 658 'title' => ts('Event Start Date'),
e501603b 659 'description' => 'Date and time that event starts.',
c3fc2621 660 'import' => TRUE,
e501603b
TO
661 'where' => 'civicrm_event.start_date',
662 'headerPattern' => '/^start|(s(tart\s)?date)$/i',
663 'dataPattern' => '',
c3fc2621 664 'export' => TRUE,
522a26c9 665 'table_name' => 'civicrm_event',
666 'entity' => 'Event',
667 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 668 'localizable' => 0,
c3fc2621 669 'html' => [
e501603b 670 'type' => 'Select Date',
c3fc2621
CW
671 ],
672 ],
673 'event_end_date' => [
e501603b
TO
674 'name' => 'end_date',
675 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
c3fc2621 676 'title' => ts('Event End Date'),
e501603b 677 'description' => 'Date and time that event ends. May be NULL if no defined end date/time',
c3fc2621 678 'import' => TRUE,
e501603b
TO
679 'where' => 'civicrm_event.end_date',
680 'headerPattern' => '/^end|(e(nd\s)?date)$/i',
681 'dataPattern' => '',
c3fc2621 682 'export' => TRUE,
522a26c9 683 'table_name' => 'civicrm_event',
684 'entity' => 'Event',
685 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 686 'localizable' => 0,
c3fc2621 687 'html' => [
e501603b 688 'type' => 'Select Date',
c3fc2621
CW
689 ],
690 ],
691 'is_online_registration' => [
e501603b
TO
692 'name' => 'is_online_registration',
693 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 694 'title' => ts('Is Online Registration'),
e501603b 695 'description' => 'If true, include registration link on Event Info page.',
522a26c9 696 'table_name' => 'civicrm_event',
697 'entity' => 'Event',
698 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 699 'localizable' => 0,
c3fc2621 700 'html' => [
e501603b 701 'type' => 'CheckBox',
c3fc2621
CW
702 ],
703 ],
704 'registration_link_text' => [
e501603b
TO
705 'name' => 'registration_link_text',
706 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 707 'title' => ts('Event Registration Link Text'),
e501603b
TO
708 'description' => 'Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.',
709 'maxlength' => 255,
710 'size' => CRM_Utils_Type::HUGE,
522a26c9 711 'table_name' => 'civicrm_event',
712 'entity' => 'Event',
713 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 714 'localizable' => 1,
c3fc2621 715 'html' => [
e501603b 716 'type' => 'Text',
c3fc2621
CW
717 ],
718 ],
719 'registration_start_date' => [
e501603b
TO
720 'name' => 'registration_start_date',
721 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
c3fc2621 722 'title' => ts('Registration Start Date'),
e501603b 723 'description' => 'Date and time that online registration starts.',
522a26c9 724 'table_name' => 'civicrm_event',
725 'entity' => 'Event',
726 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 727 'localizable' => 0,
c3fc2621 728 'html' => [
e501603b 729 'type' => 'Select Date',
c3fc2621
CW
730 ],
731 ],
732 'registration_end_date' => [
e501603b
TO
733 'name' => 'registration_end_date',
734 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
c3fc2621 735 'title' => ts('Registration End Date'),
e501603b 736 'description' => 'Date and time that online registration ends.',
522a26c9 737 'table_name' => 'civicrm_event',
738 'entity' => 'Event',
739 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 740 'localizable' => 0,
c3fc2621 741 'html' => [
e501603b 742 'type' => 'Select Date',
c3fc2621
CW
743 ],
744 ],
745 'max_participants' => [
e501603b
TO
746 'name' => 'max_participants',
747 'type' => CRM_Utils_Type::T_INT,
c3fc2621 748 'title' => ts('Max Participants'),
e501603b
TO
749 'description' => 'Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.',
750 'default' => 'NULL',
522a26c9 751 'table_name' => 'civicrm_event',
752 'entity' => 'Event',
753 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 754 'localizable' => 0,
c3fc2621 755 'html' => [
e501603b 756 'type' => 'Text',
c3fc2621
CW
757 ],
758 ],
759 'event_full_text' => [
e501603b
TO
760 'name' => 'event_full_text',
761 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 762 'title' => ts('Event Information'),
e501603b
TO
763 'description' => 'Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.',
764 'rows' => 4,
765 'cols' => 60,
522a26c9 766 'table_name' => 'civicrm_event',
767 'entity' => 'Event',
768 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 769 'localizable' => 1,
c3fc2621 770 'html' => [
e501603b 771 'type' => 'TextArea',
c3fc2621
CW
772 ],
773 ],
774 'is_monetary' => [
e501603b
TO
775 'name' => 'is_monetary',
776 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 777 'title' => ts('Is this a PAID event?'),
e501603b 778 'description' => 'If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.',
522a26c9 779 'table_name' => 'civicrm_event',
780 'entity' => 'Event',
781 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 782 'localizable' => 0,
c3fc2621 783 'html' => [
e501603b 784 'type' => 'CheckBox',
c3fc2621
CW
785 ],
786 ],
787 'financial_type_id' => [
e501603b
TO
788 'name' => 'financial_type_id',
789 'type' => CRM_Utils_Type::T_INT,
c3fc2621 790 'title' => ts('Financial Type'),
e501603b
TO
791 'description' => 'Financial type assigned to paid event registrations for this event. Required if is_monetary is true.',
792 'default' => 'NULL',
522a26c9 793 'table_name' => 'civicrm_event',
794 'entity' => 'Event',
795 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 796 'localizable' => 0,
c3fc2621 797 'html' => [
e501603b 798 'type' => 'Select',
c3fc2621
CW
799 ],
800 'pseudoconstant' => [
e501603b
TO
801 'table' => 'civicrm_financial_type',
802 'keyColumn' => 'id',
803 'labelColumn' => 'name',
c3fc2621
CW
804 ]
805 ],
806 'payment_processor' => [
e501603b
TO
807 'name' => 'payment_processor',
808 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 809 'title' => ts('Payment Processor'),
e501603b
TO
810 'description' => 'Payment Processors configured for this Event (if is_monetary is true)',
811 'maxlength' => 128,
812 'size' => CRM_Utils_Type::HUGE,
522a26c9 813 'table_name' => 'civicrm_event',
814 'entity' => 'Event',
815 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 816 'localizable' => 0,
c3fc2621 817 'html' => [
e501603b 818 'type' => 'Select',
c3fc2621
CW
819 ],
820 'pseudoconstant' => [
e501603b
TO
821 'table' => 'civicrm_payment_processor',
822 'keyColumn' => 'id',
823 'labelColumn' => 'name',
c3fc2621
CW
824 ]
825 ],
826 'is_map' => [
e501603b
TO
827 'name' => 'is_map',
828 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 829 'title' => ts('Map Enabled'),
e501603b 830 'description' => 'Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?',
522a26c9 831 'table_name' => 'civicrm_event',
832 'entity' => 'Event',
833 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 834 'localizable' => 0,
c3fc2621 835 'html' => [
e501603b 836 'type' => 'CheckBox',
c3fc2621
CW
837 ],
838 ],
839 'is_active' => [
e501603b
TO
840 'name' => 'is_active',
841 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 842 'title' => ts('Is Active'),
e501603b 843 'description' => 'Is this Event enabled or disabled/cancelled?',
522a26c9 844 'table_name' => 'civicrm_event',
845 'entity' => 'Event',
846 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 847 'localizable' => 0,
c3fc2621 848 'html' => [
e501603b 849 'type' => 'CheckBox',
c3fc2621
CW
850 ],
851 ],
852 'fee_label' => [
e501603b
TO
853 'name' => 'fee_label',
854 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 855 'title' => ts('Fee Label'),
e501603b
TO
856 'maxlength' => 255,
857 'size' => CRM_Utils_Type::HUGE,
c3fc2621 858 'import' => TRUE,
e501603b
TO
859 'where' => 'civicrm_event.fee_label',
860 'headerPattern' => '/^fee|(f(ee\s)?label)$/i',
861 'dataPattern' => '',
c3fc2621 862 'export' => TRUE,
522a26c9 863 'table_name' => 'civicrm_event',
864 'entity' => 'Event',
865 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 866 'localizable' => 1,
c3fc2621 867 'html' => [
e501603b 868 'type' => 'Text',
c3fc2621
CW
869 ],
870 ],
871 'is_show_location' => [
e501603b
TO
872 'name' => 'is_show_location',
873 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 874 'title' => ts('show location'),
e501603b
TO
875 'description' => 'If true, show event location.',
876 'default' => '1',
522a26c9 877 'table_name' => 'civicrm_event',
878 'entity' => 'Event',
879 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 880 'localizable' => 0,
c3fc2621 881 'html' => [
e501603b 882 'type' => 'CheckBox',
c3fc2621
CW
883 ],
884 ],
885 'loc_block_id' => [
e501603b
TO
886 'name' => 'loc_block_id',
887 'type' => CRM_Utils_Type::T_INT,
c3fc2621 888 'title' => ts('Location Block ID'),
e501603b 889 'description' => 'FK to Location Block ID',
522a26c9 890 'table_name' => 'civicrm_event',
891 'entity' => 'Event',
892 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 893 'localizable' => 0,
e501603b 894 'FKClassName' => 'CRM_Core_DAO_LocBlock',
c3fc2621
CW
895 ],
896 'default_role_id' => [
e501603b
TO
897 'name' => 'default_role_id',
898 'type' => CRM_Utils_Type::T_INT,
c3fc2621 899 'title' => ts('Default Role'),
e501603b 900 'description' => 'Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.',
c3fc2621 901 'import' => TRUE,
e501603b
TO
902 'where' => 'civicrm_event.default_role_id',
903 'headerPattern' => '',
904 'dataPattern' => '',
c3fc2621 905 'export' => TRUE,
e501603b 906 'default' => '1',
522a26c9 907 'table_name' => 'civicrm_event',
908 'entity' => 'Event',
909 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 910 'localizable' => 0,
c3fc2621 911 'html' => [
e501603b 912 'type' => 'Select',
c3fc2621
CW
913 ],
914 'pseudoconstant' => [
e501603b
TO
915 'optionGroupName' => 'participant_role',
916 'optionEditPath' => 'civicrm/admin/options/participant_role',
c3fc2621
CW
917 ]
918 ],
919 'intro_text' => [
e501603b
TO
920 'name' => 'intro_text',
921 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 922 'title' => ts('Introductory Message'),
e501603b
TO
923 'description' => 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.',
924 'rows' => 6,
925 'cols' => 50,
522a26c9 926 'table_name' => 'civicrm_event',
927 'entity' => 'Event',
928 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 929 'localizable' => 1,
c3fc2621 930 'html' => [
e501603b 931 'type' => 'TextArea',
c3fc2621
CW
932 ],
933 ],
934 'footer_text' => [
e501603b
TO
935 'name' => 'footer_text',
936 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 937 'title' => ts('Footer Message'),
e501603b
TO
938 'description' => 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.',
939 'rows' => 6,
940 'cols' => 50,
522a26c9 941 'table_name' => 'civicrm_event',
942 'entity' => 'Event',
943 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 944 'localizable' => 1,
c3fc2621 945 'html' => [
e501603b 946 'type' => 'TextArea',
c3fc2621
CW
947 ],
948 ],
949 'confirm_title' => [
e501603b
TO
950 'name' => 'confirm_title',
951 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 952 'title' => ts('Confirmation Title'),
e501603b
TO
953 'description' => 'Title for Confirmation page.',
954 'maxlength' => 255,
955 'size' => CRM_Utils_Type::HUGE,
956 'default' => 'NULL',
522a26c9 957 'table_name' => 'civicrm_event',
958 'entity' => 'Event',
959 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 960 'localizable' => 1,
c3fc2621 961 'html' => [
e501603b 962 'type' => 'Text',
c3fc2621
CW
963 ],
964 ],
965 'confirm_text' => [
e501603b
TO
966 'name' => 'confirm_text',
967 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 968 'title' => ts('Confirm Text'),
e501603b
TO
969 'description' => 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.',
970 'rows' => 6,
971 'cols' => 50,
522a26c9 972 'table_name' => 'civicrm_event',
973 'entity' => 'Event',
974 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 975 'localizable' => 1,
c3fc2621 976 'html' => [
e501603b 977 'type' => 'TextArea',
c3fc2621
CW
978 ],
979 ],
980 'confirm_footer_text' => [
e501603b
TO
981 'name' => 'confirm_footer_text',
982 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 983 'title' => ts('Footer Text'),
e501603b
TO
984 'description' => 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.',
985 'rows' => 6,
986 'cols' => 50,
522a26c9 987 'table_name' => 'civicrm_event',
988 'entity' => 'Event',
989 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 990 'localizable' => 1,
c3fc2621 991 'html' => [
e501603b 992 'type' => 'TextArea',
c3fc2621
CW
993 ],
994 ],
995 'is_email_confirm' => [
e501603b
TO
996 'name' => 'is_email_confirm',
997 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 998 'title' => ts('Is confirm email'),
e501603b 999 'description' => 'If true, confirmation is automatically emailed to contact on successful registration.',
522a26c9 1000 'table_name' => 'civicrm_event',
1001 'entity' => 'Event',
1002 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1003 'localizable' => 0,
c3fc2621 1004 'html' => [
e501603b 1005 'type' => 'CheckBox',
c3fc2621
CW
1006 ],
1007 ],
1008 'confirm_email_text' => [
e501603b
TO
1009 'name' => 'confirm_email_text',
1010 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1011 'title' => ts('Confirmation Email Text'),
e501603b
TO
1012 'description' => 'text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now',
1013 'rows' => 4,
1014 'cols' => 50,
522a26c9 1015 'table_name' => 'civicrm_event',
1016 'entity' => 'Event',
1017 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1018 'localizable' => 1,
c3fc2621 1019 'html' => [
e501603b 1020 'type' => 'TextArea',
c3fc2621
CW
1021 ],
1022 ],
1023 'confirm_from_name' => [
e501603b
TO
1024 'name' => 'confirm_from_name',
1025 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1026 'title' => ts('Confirm From Name'),
e501603b
TO
1027 'description' => 'FROM email name used for confirmation emails.',
1028 'maxlength' => 255,
1029 'size' => CRM_Utils_Type::HUGE,
522a26c9 1030 'table_name' => 'civicrm_event',
1031 'entity' => 'Event',
1032 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1033 'localizable' => 1,
c3fc2621 1034 'html' => [
e501603b 1035 'type' => 'Text',
c3fc2621
CW
1036 ],
1037 ],
1038 'confirm_from_email' => [
e501603b
TO
1039 'name' => 'confirm_from_email',
1040 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1041 'title' => ts('Confirm From Email'),
e501603b
TO
1042 'description' => 'FROM email address used for confirmation emails.',
1043 'maxlength' => 255,
1044 'size' => CRM_Utils_Type::HUGE,
522a26c9 1045 'table_name' => 'civicrm_event',
1046 'entity' => 'Event',
1047 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1048 'localizable' => 0,
c3fc2621 1049 'html' => [
e501603b 1050 'type' => 'Text',
c3fc2621
CW
1051 ],
1052 ],
1053 'cc_confirm' => [
e501603b
TO
1054 'name' => 'cc_confirm',
1055 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1056 'title' => ts('Cc Confirm'),
e501603b
TO
1057 'description' => 'comma-separated list of email addresses to cc each time a confirmation is sent',
1058 'maxlength' => 255,
1059 'size' => CRM_Utils_Type::HUGE,
522a26c9 1060 'table_name' => 'civicrm_event',
1061 'entity' => 'Event',
1062 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1063 'localizable' => 0,
c3fc2621 1064 'html' => [
e501603b 1065 'type' => 'Text',
c3fc2621
CW
1066 ],
1067 ],
1068 'bcc_confirm' => [
e501603b
TO
1069 'name' => 'bcc_confirm',
1070 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1071 'title' => ts('Bcc Confirm'),
e501603b
TO
1072 'description' => 'comma-separated list of email addresses to bcc each time a confirmation is sent',
1073 'maxlength' => 255,
1074 'size' => CRM_Utils_Type::HUGE,
522a26c9 1075 'table_name' => 'civicrm_event',
1076 'entity' => 'Event',
1077 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1078 'localizable' => 0,
c3fc2621 1079 'html' => [
e501603b 1080 'type' => 'Text',
c3fc2621
CW
1081 ],
1082 ],
1083 'default_fee_id' => [
e501603b
TO
1084 'name' => 'default_fee_id',
1085 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1086 'title' => ts('Default Fee ID'),
e501603b 1087 'description' => 'FK to civicrm_option_value.',
522a26c9 1088 'table_name' => 'civicrm_event',
1089 'entity' => 'Event',
1090 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1091 'localizable' => 0,
c3fc2621
CW
1092 ],
1093 'default_discount_fee_id' => [
e501603b
TO
1094 'name' => 'default_discount_fee_id',
1095 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1096 'title' => ts('Default Discount Fee ID'),
e501603b 1097 'description' => 'FK to civicrm_option_value.',
522a26c9 1098 'table_name' => 'civicrm_event',
1099 'entity' => 'Event',
1100 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1101 'localizable' => 0,
c3fc2621
CW
1102 ],
1103 'thankyou_title' => [
e501603b
TO
1104 'name' => 'thankyou_title',
1105 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1106 'title' => ts('ThankYou Title'),
e501603b
TO
1107 'description' => 'Title for ThankYou page.',
1108 'maxlength' => 255,
1109 'size' => CRM_Utils_Type::HUGE,
1110 'default' => 'NULL',
522a26c9 1111 'table_name' => 'civicrm_event',
1112 'entity' => 'Event',
1113 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1114 'localizable' => 1,
c3fc2621 1115 'html' => [
e501603b 1116 'type' => 'Text',
c3fc2621
CW
1117 ],
1118 ],
1119 'thankyou_text' => [
e501603b
TO
1120 'name' => 'thankyou_text',
1121 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1122 'title' => ts('ThankYou Text'),
e501603b
TO
1123 'description' => 'ThankYou Text.',
1124 'rows' => 6,
1125 'cols' => 50,
522a26c9 1126 'table_name' => 'civicrm_event',
1127 'entity' => 'Event',
1128 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1129 'localizable' => 1,
c3fc2621 1130 'html' => [
e501603b 1131 'type' => 'TextArea',
c3fc2621
CW
1132 ],
1133 ],
1134 'thankyou_footer_text' => [
e501603b
TO
1135 'name' => 'thankyou_footer_text',
1136 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1137 'title' => ts('Footer Text'),
e501603b
TO
1138 'description' => 'Footer message.',
1139 'rows' => 6,
1140 'cols' => 50,
522a26c9 1141 'table_name' => 'civicrm_event',
1142 'entity' => 'Event',
1143 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1144 'localizable' => 1,
c3fc2621 1145 'html' => [
e501603b 1146 'type' => 'TextArea',
c3fc2621
CW
1147 ],
1148 ],
1149 'is_pay_later' => [
e501603b
TO
1150 'name' => 'is_pay_later',
1151 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1152 'title' => ts('Pay Later Allowed'),
e501603b 1153 'description' => 'if true - allows the user to send payment directly to the org later',
522a26c9 1154 'table_name' => 'civicrm_event',
1155 'entity' => 'Event',
1156 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1157 'localizable' => 0,
c3fc2621 1158 'html' => [
e501603b 1159 'type' => 'CheckBox',
c3fc2621
CW
1160 ],
1161 ],
1162 'pay_later_text' => [
e501603b
TO
1163 'name' => 'pay_later_text',
1164 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1165 'title' => ts('Pay Later Text'),
e501603b 1166 'description' => 'The text displayed to the user in the main form',
522a26c9 1167 'table_name' => 'civicrm_event',
1168 'entity' => 'Event',
1169 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1170 'localizable' => 1,
c3fc2621 1171 'html' => [
e501603b 1172 'type' => 'Text',
c3fc2621
CW
1173 ],
1174 ],
1175 'pay_later_receipt' => [
e501603b
TO
1176 'name' => 'pay_later_receipt',
1177 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1178 'title' => ts('Pay Later Receipt Text'),
e501603b 1179 'description' => 'The receipt sent to the user instead of the normal receipt text',
522a26c9 1180 'table_name' => 'civicrm_event',
1181 'entity' => 'Event',
1182 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1183 'localizable' => 1,
c3fc2621 1184 'html' => [
e501603b 1185 'type' => 'Text',
c3fc2621
CW
1186 ],
1187 ],
1188 'is_partial_payment' => [
e501603b
TO
1189 'name' => 'is_partial_payment',
1190 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1191 'title' => ts('Partial Payments Enabled'),
e501603b 1192 'description' => 'is partial payment enabled for this event',
522a26c9 1193 'table_name' => 'civicrm_event',
1194 'entity' => 'Event',
1195 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1196 'localizable' => 0,
c3fc2621 1197 'html' => [
e501603b 1198 'type' => 'CheckBox',
c3fc2621
CW
1199 ],
1200 ],
1201 'initial_amount_label' => [
e501603b
TO
1202 'name' => 'initial_amount_label',
1203 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1204 'title' => ts('Initial Amount Label'),
e501603b
TO
1205 'description' => 'Initial amount label for partial payment',
1206 'maxlength' => 255,
1207 'size' => CRM_Utils_Type::HUGE,
522a26c9 1208 'table_name' => 'civicrm_event',
1209 'entity' => 'Event',
1210 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1211 'localizable' => 1,
c3fc2621 1212 'html' => [
e501603b 1213 'type' => 'Text',
c3fc2621
CW
1214 ],
1215 ],
1216 'initial_amount_help_text' => [
e501603b
TO
1217 'name' => 'initial_amount_help_text',
1218 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1219 'title' => ts('Initial Amount Help Text'),
e501603b 1220 'description' => 'Initial amount help text for partial payment',
522a26c9 1221 'table_name' => 'civicrm_event',
1222 'entity' => 'Event',
1223 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1224 'localizable' => 1,
c3fc2621 1225 'html' => [
e501603b 1226 'type' => 'Text',
c3fc2621
CW
1227 ],
1228 ],
1229 'min_initial_amount' => [
e501603b
TO
1230 'name' => 'min_initial_amount',
1231 'type' => CRM_Utils_Type::T_MONEY,
c3fc2621 1232 'title' => ts('Minimum Initial Amount'),
e501603b 1233 'description' => 'Minimum initial amount for partial payment',
c3fc2621 1234 'precision' => [
e501603b
TO
1235 20,
1236 2
c3fc2621 1237 ],
522a26c9 1238 'table_name' => 'civicrm_event',
1239 'entity' => 'Event',
1240 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1241 'localizable' => 0,
c3fc2621 1242 'html' => [
e501603b 1243 'type' => 'Text',
c3fc2621
CW
1244 ],
1245 ],
1246 'is_multiple_registrations' => [
e501603b
TO
1247 'name' => 'is_multiple_registrations',
1248 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1249 'title' => ts('Allow Multiple Registrations'),
e501603b 1250 'description' => 'if true - allows the user to register multiple participants for event',
522a26c9 1251 'table_name' => 'civicrm_event',
1252 'entity' => 'Event',
1253 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1254 'localizable' => 0,
c3fc2621 1255 'html' => [
e501603b 1256 'type' => 'CheckBox',
c3fc2621
CW
1257 ],
1258 ],
1259 'max_additional_participants' => [
e501603b
TO
1260 'name' => 'max_additional_participants',
1261 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1262 'title' => ts('Maximum number of additional participants per registration'),
e501603b 1263 'description' => 'Maximum number of additional participants that can be registered on a single booking',
522a26c9 1264 'table_name' => 'civicrm_event',
1265 'entity' => 'Event',
1266 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1267 'localizable' => 0,
c3fc2621
CW
1268 ],
1269 'allow_same_participant_emails' => [
e501603b
TO
1270 'name' => 'allow_same_participant_emails',
1271 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1272 'title' => ts('Does Event allow multiple registrations from same email address?'),
e501603b 1273 'description' => 'if true - allows the user to register multiple registrations from same email address.',
522a26c9 1274 'table_name' => 'civicrm_event',
1275 'entity' => 'Event',
1276 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1277 'localizable' => 0,
c3fc2621 1278 'html' => [
e501603b 1279 'type' => 'CheckBox',
c3fc2621
CW
1280 ],
1281 ],
1282 'has_waitlist' => [
e501603b
TO
1283 'name' => 'has_waitlist',
1284 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1285 'title' => ts('Waitlist Enabled'),
e501603b 1286 'description' => 'Whether the event has waitlist support.',
522a26c9 1287 'table_name' => 'civicrm_event',
1288 'entity' => 'Event',
1289 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1290 'localizable' => 0,
c3fc2621 1291 'html' => [
e501603b 1292 'type' => 'CheckBox',
c3fc2621
CW
1293 ],
1294 ],
1295 'requires_approval' => [
e501603b
TO
1296 'name' => 'requires_approval',
1297 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1298 'title' => ts('Requires Approval'),
e501603b 1299 'description' => 'Whether participants require approval before they can finish registering.',
522a26c9 1300 'table_name' => 'civicrm_event',
1301 'entity' => 'Event',
1302 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1303 'localizable' => 0,
c3fc2621 1304 'html' => [
e501603b 1305 'type' => 'CheckBox',
c3fc2621
CW
1306 ],
1307 ],
1308 'expiration_time' => [
e501603b
TO
1309 'name' => 'expiration_time',
1310 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1311 'title' => ts('Expiration Time'),
e501603b 1312 'description' => 'Expire pending but unconfirmed registrations after this many hours.',
522a26c9 1313 'table_name' => 'civicrm_event',
1314 'entity' => 'Event',
1315 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1316 'localizable' => 0,
c3fc2621 1317 'html' => [
e501603b 1318 'type' => 'Text',
c3fc2621
CW
1319 ],
1320 ],
1321 'allow_selfcancelxfer' => [
e501603b
TO
1322 'name' => 'allow_selfcancelxfer',
1323 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1324 'title' => ts('Allow Self-service Cancellation or Transfer'),
e501603b 1325 'description' => 'Allow self service cancellation or transfer for event?',
522a26c9 1326 'table_name' => 'civicrm_event',
1327 'entity' => 'Event',
1328 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1329 'localizable' => 0,
c3fc2621 1330 'html' => [
e501603b 1331 'type' => 'CheckBox',
c3fc2621
CW
1332 ],
1333 ],
1334 'selfcancelxfer_time' => [
e501603b
TO
1335 'name' => 'selfcancelxfer_time',
1336 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1337 'title' => ts('Self-service Cancellation or Transfer Time'),
e501603b 1338 'description' => 'Number of hours prior to event start date to allow self-service cancellation or transfer.',
522a26c9 1339 'table_name' => 'civicrm_event',
1340 'entity' => 'Event',
1341 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1342 'localizable' => 0,
c3fc2621 1343 'html' => [
e501603b 1344 'type' => 'Text',
c3fc2621
CW
1345 ],
1346 ],
1347 'waitlist_text' => [
e501603b
TO
1348 'name' => 'waitlist_text',
1349 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1350 'title' => ts('Waitlist Text'),
e501603b
TO
1351 'description' => 'Text to display when the event is full, but participants can signup for a waitlist.',
1352 'rows' => 4,
1353 'cols' => 60,
522a26c9 1354 'table_name' => 'civicrm_event',
1355 'entity' => 'Event',
1356 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1357 'localizable' => 1,
c3fc2621 1358 'html' => [
e501603b 1359 'type' => 'TextArea',
c3fc2621
CW
1360 ],
1361 ],
1362 'approval_req_text' => [
e501603b
TO
1363 'name' => 'approval_req_text',
1364 'type' => CRM_Utils_Type::T_TEXT,
c3fc2621 1365 'title' => ts('Approval Req Text'),
e501603b
TO
1366 'description' => 'Text to display when the approval is required to complete registration for an event.',
1367 'rows' => 4,
1368 'cols' => 60,
522a26c9 1369 'table_name' => 'civicrm_event',
1370 'entity' => 'Event',
1371 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1372 'localizable' => 1,
c3fc2621 1373 'html' => [
e501603b 1374 'type' => 'TextArea',
c3fc2621
CW
1375 ],
1376 ],
1377 'is_template' => [
e501603b
TO
1378 'name' => 'is_template',
1379 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1380 'title' => ts('Is an Event Template'),
e501603b 1381 'description' => 'whether the event has template',
c3fc2621 1382 'required' => TRUE,
522a26c9 1383 'table_name' => 'civicrm_event',
1384 'entity' => 'Event',
1385 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1386 'localizable' => 0,
c3fc2621 1387 'html' => [
e501603b 1388 'type' => 'CheckBox',
c3fc2621
CW
1389 ],
1390 ],
1391 'template_title' => [
e501603b
TO
1392 'name' => 'template_title',
1393 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1394 'title' => ts('Event Template Title'),
e501603b
TO
1395 'description' => 'Event Template Title',
1396 'maxlength' => 255,
1397 'size' => CRM_Utils_Type::HUGE,
c3fc2621 1398 'import' => TRUE,
e501603b
TO
1399 'where' => 'civicrm_event.template_title',
1400 'headerPattern' => '/(template.)?title$/i',
1401 'dataPattern' => '',
c3fc2621 1402 'export' => TRUE,
522a26c9 1403 'table_name' => 'civicrm_event',
1404 'entity' => 'Event',
1405 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1406 'localizable' => 1,
c3fc2621 1407 'html' => [
e501603b 1408 'type' => 'Text',
c3fc2621
CW
1409 ],
1410 ],
1411 'created_id' => [
e501603b
TO
1412 'name' => 'created_id',
1413 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1414 'title' => ts('Created By Contact ID'),
e501603b 1415 'description' => 'FK to civicrm_contact, who created this event',
522a26c9 1416 'table_name' => 'civicrm_event',
1417 'entity' => 'Event',
1418 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1419 'localizable' => 0,
e501603b 1420 'FKClassName' => 'CRM_Contact_DAO_Contact',
c3fc2621
CW
1421 ],
1422 'created_date' => [
e501603b
TO
1423 'name' => 'created_date',
1424 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
c3fc2621 1425 'title' => ts('Event Created Date'),
e501603b 1426 'description' => 'Date and time that event was created.',
522a26c9 1427 'table_name' => 'civicrm_event',
1428 'entity' => 'Event',
1429 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1430 'localizable' => 0,
c3fc2621
CW
1431 ],
1432 'currency' => [
e501603b
TO
1433 'name' => 'currency',
1434 'type' => CRM_Utils_Type::T_STRING,
c3fc2621 1435 'title' => ts('Currency'),
e501603b
TO
1436 'description' => '3 character string, value from config setting or input via user.',
1437 'maxlength' => 3,
1438 'size' => CRM_Utils_Type::FOUR,
c3fc2621 1439 'import' => TRUE,
e501603b
TO
1440 'where' => 'civicrm_event.currency',
1441 'headerPattern' => '/cur(rency)?/i',
1442 'dataPattern' => '/^[A-Z]{3}$/i',
c3fc2621 1443 'export' => TRUE,
522a26c9 1444 'table_name' => 'civicrm_event',
1445 'entity' => 'Event',
1446 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1447 'localizable' => 0,
c3fc2621 1448 'html' => [
e501603b 1449 'type' => 'Select',
c3fc2621
CW
1450 ],
1451 'pseudoconstant' => [
e501603b
TO
1452 'table' => 'civicrm_currency',
1453 'keyColumn' => 'name',
1454 'labelColumn' => 'full_name',
1455 'nameColumn' => 'name',
c3fc2621
CW
1456 ]
1457 ],
1458 'campaign_id' => [
e501603b
TO
1459 'name' => 'campaign_id',
1460 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1461 'title' => ts('Campaign'),
e501603b 1462 'description' => 'The campaign for which this event has been created.',
522a26c9 1463 'table_name' => 'civicrm_event',
1464 'entity' => 'Event',
1465 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1466 'localizable' => 0,
e501603b 1467 'FKClassName' => 'CRM_Campaign_DAO_Campaign',
c3fc2621 1468 'html' => [
e501603b 1469 'type' => 'EntityRef',
c3fc2621
CW
1470 ],
1471 'pseudoconstant' => [
e501603b
TO
1472 'table' => 'civicrm_campaign',
1473 'keyColumn' => 'id',
1474 'labelColumn' => 'title',
c3fc2621
CW
1475 ]
1476 ],
1477 'is_share' => [
e501603b
TO
1478 'name' => 'is_share',
1479 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1480 'title' => ts('Is shared through social media'),
e501603b
TO
1481 'description' => 'Can people share the event through social media?',
1482 'default' => '1',
522a26c9 1483 'table_name' => 'civicrm_event',
1484 'entity' => 'Event',
1485 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1486 'localizable' => 0,
c3fc2621 1487 'html' => [
e501603b 1488 'type' => 'CheckBox',
c3fc2621
CW
1489 ],
1490 ],
1491 'is_confirm_enabled' => [
e501603b
TO
1492 'name' => 'is_confirm_enabled',
1493 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1494 'title' => ts('Is the booking confirmation screen enabled?'),
e501603b
TO
1495 'description' => 'If false, the event booking confirmation screen gets skipped',
1496 'default' => '1',
522a26c9 1497 'table_name' => 'civicrm_event',
1498 'entity' => 'Event',
1499 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1500 'localizable' => 0,
c3fc2621 1501 'html' => [
e501603b 1502 'type' => 'CheckBox',
c3fc2621
CW
1503 ],
1504 ],
1505 'parent_event_id' => [
e501603b
TO
1506 'name' => 'parent_event_id',
1507 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1508 'title' => ts('Parent Event ID'),
e501603b
TO
1509 'description' => 'Implicit FK to civicrm_event: parent event',
1510 'default' => 'NULL',
522a26c9 1511 'table_name' => 'civicrm_event',
1512 'entity' => 'Event',
1513 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1514 'localizable' => 0,
c3fc2621 1515 'html' => [
e501603b 1516 'type' => 'EntityRef',
c3fc2621
CW
1517 ],
1518 ],
1519 'slot_label_id' => [
e501603b
TO
1520 'name' => 'slot_label_id',
1521 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1522 'title' => ts('Subevent Slot Label ID'),
e501603b
TO
1523 'description' => 'Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.',
1524 'default' => 'NULL',
522a26c9 1525 'table_name' => 'civicrm_event',
1526 'entity' => 'Event',
1527 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1528 'localizable' => 0,
c3fc2621 1529 'html' => [
e501603b 1530 'type' => 'Select',
c3fc2621
CW
1531 ],
1532 ],
1533 'dedupe_rule_group_id' => [
e501603b
TO
1534 'name' => 'dedupe_rule_group_id',
1535 'type' => CRM_Utils_Type::T_INT,
c3fc2621 1536 'title' => ts('Dedupe Rule'),
e501603b
TO
1537 'description' => 'Rule to use when matching registrations for this event',
1538 'default' => 'NULL',
522a26c9 1539 'table_name' => 'civicrm_event',
1540 'entity' => 'Event',
1541 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1542 'localizable' => 0,
e501603b 1543 'FKClassName' => 'CRM_Dedupe_DAO_RuleGroup',
c3fc2621 1544 'html' => [
e501603b 1545 'type' => 'Select',
c3fc2621
CW
1546 ],
1547 'pseudoconstant' => [
e501603b
TO
1548 'table' => 'civicrm_dedupe_rule_group',
1549 'keyColumn' => 'id',
1550 'labelColumn' => 'title',
1551 'nameColumn' => 'name',
c3fc2621
CW
1552 ]
1553 ],
1554 'is_billing_required' => [
e501603b
TO
1555 'name' => 'is_billing_required',
1556 'type' => CRM_Utils_Type::T_BOOLEAN,
c3fc2621 1557 'title' => ts('Is billing block required'),
e501603b 1558 'description' => 'if true than billing block is required this event',
522a26c9 1559 'table_name' => 'civicrm_event',
1560 'entity' => 'Event',
1561 'bao' => 'CRM_Event_BAO_Event',
6a7e5e5d 1562 'localizable' => 0,
c3fc2621 1563 'html' => [
e501603b 1564 'type' => 'CheckBox',
c3fc2621
CW
1565 ],
1566 ],
1567 ];
346aaaba 1568 CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
e501603b 1569 }
346aaaba 1570 return Civi::$statics[__CLASS__]['fields'];
e501603b 1571 }
c3fc2621 1572
e501603b 1573 /**
bd8e0b14 1574 * Return a mapping from field-name to the corresponding key (as used in fields()).
e501603b
TO
1575 *
1576 * @return array
bd8e0b14 1577 * Array(string $name => string $uniqueName).
e501603b 1578 */
c3fc2621 1579 public static function &fieldKeys() {
bd8e0b14
TO
1580 if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
1581 Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
e501603b 1582 }
bd8e0b14 1583 return Civi::$statics[__CLASS__]['fieldKeys'];
e501603b 1584 }
c3fc2621 1585
e501603b
TO
1586 /**
1587 * Returns the names of this table
1588 *
1589 * @return string
1590 */
c3fc2621 1591 public static function getTableName() {
e501603b
TO
1592 return CRM_Core_DAO::getLocaleTableName(self::$_tableName);
1593 }
c3fc2621 1594
e501603b
TO
1595 /**
1596 * Returns if this table needs to be logged
1597 *
c3fc2621 1598 * @return bool
e501603b 1599 */
c3fc2621 1600 public function getLog() {
e501603b
TO
1601 return self::$_log;
1602 }
c3fc2621 1603
e501603b
TO
1604 /**
1605 * Returns the list of fields that can be imported
1606 *
1607 * @param bool $prefix
1608 *
1609 * @return array
1610 */
c3fc2621
CW
1611 public static function &import($prefix = FALSE) {
1612 $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'event', $prefix, []);
60808919 1613 return $r;
e501603b 1614 }
c3fc2621 1615
e501603b
TO
1616 /**
1617 * Returns the list of fields that can be exported
1618 *
1619 * @param bool $prefix
1620 *
1621 * @return array
1622 */
c3fc2621
CW
1623 public static function &export($prefix = FALSE) {
1624 $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'event', $prefix, []);
60808919 1625 return $r;
e501603b 1626 }
c3fc2621 1627
e7a6b91a
AS
1628 /**
1629 * Returns the list of indices
c3fc2621
CW
1630 *
1631 * @param bool $localize
1632 *
1633 * @return array
e7a6b91a
AS
1634 */
1635 public static function indices($localize = TRUE) {
c3fc2621
CW
1636 $indices = [
1637 'index_event_type_id' => [
e7a6b91a 1638 'name' => 'index_event_type_id',
c3fc2621 1639 'field' => [
e7a6b91a 1640 0 => 'event_type_id',
c3fc2621
CW
1641 ],
1642 'localizable' => FALSE,
e7a6b91a 1643 'sig' => 'civicrm_event::0::event_type_id',
c3fc2621
CW
1644 ],
1645 'index_participant_listing_id' => [
e7a6b91a 1646 'name' => 'index_participant_listing_id',
c3fc2621 1647 'field' => [
e7a6b91a 1648 0 => 'participant_listing_id',
c3fc2621
CW
1649 ],
1650 'localizable' => FALSE,
e7a6b91a 1651 'sig' => 'civicrm_event::0::participant_listing_id',
c3fc2621
CW
1652 ],
1653 'index_parent_event_id' => [
e7a6b91a 1654 'name' => 'index_parent_event_id',
c3fc2621 1655 'field' => [
e7a6b91a 1656 0 => 'parent_event_id',
c3fc2621
CW
1657 ],
1658 'localizable' => FALSE,
e7a6b91a 1659 'sig' => 'civicrm_event::0::parent_event_id',
c3fc2621
CW
1660 ],
1661 ];
e7a6b91a
AS
1662 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
1663 }
c3fc2621 1664
e501603b 1665}