5 * @copyright CiviCRM LLC https://civicrm.org/licensing
7 * Generated from xml/schema/CRM/Event/Event.xml
8 * DO NOT EDIT. Generated by CRM_Core_CodeGen
9 * (GenCodeChecksum:894f53608aa8036de5fab1dc90a407d5)
13 * Database access object for the Event entity.
15 class CRM_Event_DAO_Event
extends CRM_Core_DAO
{
16 const EXT
= 'civicrm';
17 const TABLE_ADDED
= '1.7';
18 const COMPONENT
= 'CiviEvent';
21 * Static instance to hold the table name.
25 public static $_tableName = 'civicrm_event';
28 * Icon associated with this entity.
32 public static $_icon = 'fa-calendar';
35 * Field to show when displaying a record.
39 public static $_labelField = 'title';
42 * Should CiviCRM log any modifications to this table in the civicrm_log table.
46 public static $_log = TRUE;
49 * Paths for accessing this entity in the UI.
53 protected static $_paths = [
54 'add' => 'civicrm/event/add?reset=1',
55 'view' => 'civicrm/event/info?reset=1&id=[id]',
61 * @var int|string|null
62 * (SQL type: int unsigned)
63 * Note that values will be retrieved from the database as a string.
68 * Event Title (e.g. Fall Fundraiser Dinner)
71 * (SQL type: varchar(255))
72 * Note that values will be retrieved from the database as a string.
77 * 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.
81 * Note that values will be retrieved from the database as a string.
86 * Full description of event. Text and html allowed. Displayed on built-in Event Information screens.
90 * Note that values will be retrieved from the database as a string.
95 * Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.
97 * @var int|string|null
98 * (SQL type: int unsigned)
99 * Note that values will be retrieved from the database as a string.
101 public $event_type_id;
104 * Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.
106 * @var int|string|null
107 * (SQL type: int unsigned)
108 * Note that values will be retrieved from the database as a string.
110 public $participant_listing_id;
113 * Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.
115 * @var bool|string|null
116 * (SQL type: tinyint)
117 * Note that values will be retrieved from the database as a string.
122 * Date and time that event starts.
125 * (SQL type: datetime)
126 * Note that values will be retrieved from the database as a string.
131 * Date and time that event ends. May be NULL if no defined end date/time
134 * (SQL type: datetime)
135 * Note that values will be retrieved from the database as a string.
140 * If true, include registration link on Event Info page.
142 * @var bool|string|null
143 * (SQL type: tinyint)
144 * Note that values will be retrieved from the database as a string.
146 public $is_online_registration;
149 * Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.
152 * (SQL type: varchar(255))
153 * Note that values will be retrieved from the database as a string.
155 public $registration_link_text;
158 * Date and time that online registration starts.
161 * (SQL type: datetime)
162 * Note that values will be retrieved from the database as a string.
164 public $registration_start_date;
167 * Date and time that online registration ends.
170 * (SQL type: datetime)
171 * Note that values will be retrieved from the database as a string.
173 public $registration_end_date;
176 * 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.
178 * @var int|string|null
179 * (SQL type: int unsigned)
180 * Note that values will be retrieved from the database as a string.
182 public $max_participants;
185 * 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.
189 * Note that values will be retrieved from the database as a string.
191 public $event_full_text;
194 * If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.
196 * @var bool|string|null
197 * (SQL type: tinyint)
198 * Note that values will be retrieved from the database as a string.
203 * Financial type assigned to paid event registrations for this event. Required if is_monetary is true.
205 * @var int|string|null
206 * (SQL type: int unsigned)
207 * Note that values will be retrieved from the database as a string.
209 public $financial_type_id;
212 * Payment Processors configured for this Event (if is_monetary is true)
215 * (SQL type: varchar(128))
216 * Note that values will be retrieved from the database as a string.
218 public $payment_processor;
221 * Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?
223 * @var bool|string|null
224 * (SQL type: tinyint)
225 * Note that values will be retrieved from the database as a string.
230 * Is this Event enabled or disabled/cancelled?
232 * @var bool|string|null
233 * (SQL type: tinyint)
234 * Note that values will be retrieved from the database as a string.
240 * (SQL type: varchar(255))
241 * Note that values will be retrieved from the database as a string.
246 * If true, show event location.
248 * @var bool|string|null
249 * (SQL type: tinyint)
250 * Note that values will be retrieved from the database as a string.
252 public $is_show_location;
255 * FK to Location Block ID
257 * @var int|string|null
258 * (SQL type: int unsigned)
259 * Note that values will be retrieved from the database as a string.
261 public $loc_block_id;
264 * Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
266 * @var int|string|null
267 * (SQL type: int unsigned)
268 * Note that values will be retrieved from the database as a string.
270 public $default_role_id;
273 * Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
277 * Note that values will be retrieved from the database as a string.
282 * Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
286 * Note that values will be retrieved from the database as a string.
291 * Title for Confirmation page.
294 * (SQL type: varchar(255))
295 * Note that values will be retrieved from the database as a string.
297 public $confirm_title;
300 * Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.
304 * Note that values will be retrieved from the database as a string.
306 public $confirm_text;
309 * Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.
313 * Note that values will be retrieved from the database as a string.
315 public $confirm_footer_text;
318 * If true, confirmation is automatically emailed to contact on successful registration.
320 * @var bool|string|null
321 * (SQL type: tinyint)
322 * Note that values will be retrieved from the database as a string.
324 public $is_email_confirm;
327 * text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now
331 * Note that values will be retrieved from the database as a string.
333 public $confirm_email_text;
336 * FROM email name used for confirmation emails.
339 * (SQL type: varchar(255))
340 * Note that values will be retrieved from the database as a string.
342 public $confirm_from_name;
345 * FROM email address used for confirmation emails.
348 * (SQL type: varchar(255))
349 * Note that values will be retrieved from the database as a string.
351 public $confirm_from_email;
354 * comma-separated list of email addresses to cc each time a confirmation is sent
357 * (SQL type: varchar(255))
358 * Note that values will be retrieved from the database as a string.
363 * comma-separated list of email addresses to bcc each time a confirmation is sent
366 * (SQL type: varchar(255))
367 * Note that values will be retrieved from the database as a string.
372 * FK to civicrm_option_value.
374 * @var int|string|null
375 * (SQL type: int unsigned)
376 * Note that values will be retrieved from the database as a string.
378 public $default_fee_id;
381 * FK to civicrm_option_value.
383 * @var int|string|null
384 * (SQL type: int unsigned)
385 * Note that values will be retrieved from the database as a string.
387 public $default_discount_fee_id;
390 * Title for ThankYou page.
393 * (SQL type: varchar(255))
394 * Note that values will be retrieved from the database as a string.
396 public $thankyou_title;
403 * Note that values will be retrieved from the database as a string.
405 public $thankyou_text;
412 * Note that values will be retrieved from the database as a string.
414 public $thankyou_footer_text;
417 * if true - allows the user to send payment directly to the org later
419 * @var bool|string|null
420 * (SQL type: tinyint)
421 * Note that values will be retrieved from the database as a string.
423 public $is_pay_later;
426 * The text displayed to the user in the main form
430 * Note that values will be retrieved from the database as a string.
432 public $pay_later_text;
435 * The receipt sent to the user instead of the normal receipt text
439 * Note that values will be retrieved from the database as a string.
441 public $pay_later_receipt;
444 * is partial payment enabled for this event
446 * @var bool|string|null
447 * (SQL type: tinyint)
448 * Note that values will be retrieved from the database as a string.
450 public $is_partial_payment;
453 * Initial amount label for partial payment
456 * (SQL type: varchar(255))
457 * Note that values will be retrieved from the database as a string.
459 public $initial_amount_label;
462 * Initial amount help text for partial payment
466 * Note that values will be retrieved from the database as a string.
468 public $initial_amount_help_text;
471 * Minimum initial amount for partial payment
473 * @var float|string|null
474 * (SQL type: decimal(20,2))
475 * Note that values will be retrieved from the database as a string.
477 public $min_initial_amount;
480 * if true - allows the user to register multiple participants for event
482 * @var bool|string|null
483 * (SQL type: tinyint)
484 * Note that values will be retrieved from the database as a string.
486 public $is_multiple_registrations;
489 * Maximum number of additional participants that can be registered on a single booking
491 * @var int|string|null
492 * (SQL type: int unsigned)
493 * Note that values will be retrieved from the database as a string.
495 public $max_additional_participants;
498 * if true - allows the user to register multiple registrations from same email address.
500 * @var bool|string|null
501 * (SQL type: tinyint)
502 * Note that values will be retrieved from the database as a string.
504 public $allow_same_participant_emails;
507 * Whether the event has waitlist support.
509 * @var bool|string|null
510 * (SQL type: tinyint)
511 * Note that values will be retrieved from the database as a string.
513 public $has_waitlist;
516 * Whether participants require approval before they can finish registering.
518 * @var bool|string|null
519 * (SQL type: tinyint)
520 * Note that values will be retrieved from the database as a string.
522 public $requires_approval;
525 * Expire pending but unconfirmed registrations after this many hours.
527 * @var int|string|null
528 * (SQL type: int unsigned)
529 * Note that values will be retrieved from the database as a string.
531 public $expiration_time;
534 * Allow self service cancellation or transfer for event?
536 * @var bool|string|null
537 * (SQL type: tinyint)
538 * Note that values will be retrieved from the database as a string.
540 public $allow_selfcancelxfer;
543 * Number of hours prior to event start date to allow self-service cancellation or transfer.
545 * @var int|string|null
547 * Note that values will be retrieved from the database as a string.
549 public $selfcancelxfer_time;
552 * Text to display when the event is full, but participants can signup for a waitlist.
556 * Note that values will be retrieved from the database as a string.
558 public $waitlist_text;
561 * Text to display when the approval is required to complete registration for an event.
565 * Note that values will be retrieved from the database as a string.
567 public $approval_req_text;
570 * whether the event has template
573 * (SQL type: tinyint)
574 * Note that values will be retrieved from the database as a string.
579 * Event Template Title
582 * (SQL type: varchar(255))
583 * Note that values will be retrieved from the database as a string.
585 public $template_title;
588 * FK to civicrm_contact, who created this event
590 * @var int|string|null
591 * (SQL type: int unsigned)
592 * Note that values will be retrieved from the database as a string.
597 * Date and time that event was created.
600 * (SQL type: datetime)
601 * Note that values will be retrieved from the database as a string.
603 public $created_date;
606 * 3 character string, value from config setting or input via user.
609 * (SQL type: varchar(3))
610 * Note that values will be retrieved from the database as a string.
615 * The campaign for which this event has been created.
617 * @var int|string|null
618 * (SQL type: int unsigned)
619 * Note that values will be retrieved from the database as a string.
624 * Can people share the event through social media?
626 * @var bool|string|null
627 * (SQL type: tinyint)
628 * Note that values will be retrieved from the database as a string.
633 * If false, the event booking confirmation screen gets skipped
635 * @var bool|string|null
636 * (SQL type: tinyint)
637 * Note that values will be retrieved from the database as a string.
639 public $is_confirm_enabled;
642 * Implicit FK to civicrm_event: parent event
644 * @var int|string|null
645 * (SQL type: int unsigned)
646 * Note that values will be retrieved from the database as a string.
648 public $parent_event_id;
651 * Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.
653 * @var int|string|null
654 * (SQL type: int unsigned)
655 * Note that values will be retrieved from the database as a string.
657 public $slot_label_id;
660 * Rule to use when matching registrations for this event
662 * @var int|string|null
663 * (SQL type: int unsigned)
664 * Note that values will be retrieved from the database as a string.
666 public $dedupe_rule_group_id;
669 * if true than billing block is required this event
671 * @var bool|string|null
672 * (SQL type: tinyint)
673 * Note that values will be retrieved from the database as a string.
675 public $is_billing_required;
680 public function __construct() {
681 $this->__table
= 'civicrm_event';
682 parent
::__construct();
686 * Returns localized title of this entity.
688 * @param bool $plural
689 * Whether to return the plural version of the title.
691 public static function getEntityTitle($plural = FALSE) {
692 return $plural ?
ts('Events') : ts('Event');
696 * Returns user-friendly description of this entity.
700 public static function getEntityDescription() {
701 return ts('Scheduled in-person or online events which contacts can register for and attend.');
705 * Returns foreign keys and entity references.
708 * [CRM_Core_Reference_Interface]
710 public static function getReferenceColumns() {
711 if (!isset(Civi
::$statics[__CLASS__
]['links'])) {
712 Civi
::$statics[__CLASS__
]['links'] = static::createReferenceColumns(__CLASS__
);
713 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'loc_block_id', 'civicrm_loc_block', 'id');
714 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'created_id', 'civicrm_contact', 'id');
715 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
716 Civi
::$statics[__CLASS__
]['links'][] = new CRM_Core_Reference_Basic(self
::getTableName(), 'dedupe_rule_group_id', 'civicrm_dedupe_rule_group', 'id');
717 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'links_callback', Civi
::$statics[__CLASS__
]['links']);
719 return Civi
::$statics[__CLASS__
]['links'];
723 * Returns all the column names of this table
727 public static function &fields() {
728 if (!isset(Civi
::$statics[__CLASS__
]['fields'])) {
729 Civi
::$statics[__CLASS__
]['fields'] = [
732 'type' => CRM_Utils_Type
::T_INT
,
733 'title' => ts('Event ID'),
734 'description' => ts('Event'),
736 'where' => 'civicrm_event.id',
737 'table_name' => 'civicrm_event',
739 'bao' => 'CRM_Event_BAO_Event',
749 'type' => CRM_Utils_Type
::T_STRING
,
750 'title' => ts('Event Title'),
751 'description' => ts('Event Title (e.g. Fall Fundraiser Dinner)'),
753 'size' => CRM_Utils_Type
::HUGE
,
755 'where' => 'civicrm_event.title',
756 'headerPattern' => '/(event.)?title$/i',
758 'table_name' => 'civicrm_event',
760 'bao' => 'CRM_Event_BAO_Event',
769 'type' => CRM_Utils_Type
::T_TEXT
,
770 'title' => ts('Event Summary'),
771 'description' => ts('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.'),
774 'where' => 'civicrm_event.summary',
775 'table_name' => 'civicrm_event',
777 'bao' => 'CRM_Event_BAO_Event',
780 'type' => 'TextArea',
784 'event_description' => [
785 'name' => 'description',
786 'type' => CRM_Utils_Type
::T_TEXT
,
787 'title' => ts('Event Description'),
788 'description' => ts('Full description of event. Text and html allowed. Displayed on built-in Event Information screens.'),
791 'where' => 'civicrm_event.description',
792 'table_name' => 'civicrm_event',
794 'bao' => 'CRM_Event_BAO_Event',
797 'type' => 'RichTextEditor',
802 'name' => 'event_type_id',
803 'type' => CRM_Utils_Type
::T_INT
,
804 'title' => ts('Event Type'),
805 'description' => ts('Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.'),
806 'where' => 'civicrm_event.event_type_id',
808 'table_name' => 'civicrm_event',
810 'bao' => 'CRM_Event_BAO_Event',
815 'pseudoconstant' => [
816 'optionGroupName' => 'event_type',
817 'optionEditPath' => 'civicrm/admin/options/event_type',
821 'participant_listing_id' => [
822 'name' => 'participant_listing_id',
823 'type' => CRM_Utils_Type
::T_INT
,
824 'title' => ts('Participant Listing'),
825 'description' => ts('Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.'),
826 'where' => 'civicrm_event.participant_listing_id',
828 'table_name' => 'civicrm_event',
830 'bao' => 'CRM_Event_BAO_Event',
835 'pseudoconstant' => [
836 'optionGroupName' => 'participant_listing',
837 'optionEditPath' => 'civicrm/admin/options/participant_listing',
842 'name' => 'is_public',
843 'type' => CRM_Utils_Type
::T_BOOLEAN
,
844 'title' => ts('Is Event Public'),
845 'description' => ts('Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.'),
846 'where' => 'civicrm_event.is_public',
848 'table_name' => 'civicrm_event',
850 'bao' => 'CRM_Event_BAO_Event',
853 'type' => 'CheckBox',
857 'event_start_date' => [
858 'name' => 'start_date',
859 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
860 'title' => ts('Event Start Date'),
861 'description' => ts('Date and time that event starts.'),
863 'where' => 'civicrm_event.start_date',
864 'headerPattern' => '/^start|(s(tart\s)?date)$/i',
866 'table_name' => 'civicrm_event',
868 'bao' => 'CRM_Event_BAO_Event',
871 'type' => 'Select Date',
872 'formatType' => 'activityDateTime',
876 'event_end_date' => [
877 'name' => 'end_date',
878 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
879 'title' => ts('Event End Date'),
880 'description' => ts('Date and time that event ends. May be NULL if no defined end date/time'),
882 'where' => 'civicrm_event.end_date',
883 'headerPattern' => '/^end|(e(nd\s)?date)$/i',
885 'table_name' => 'civicrm_event',
887 'bao' => 'CRM_Event_BAO_Event',
890 'type' => 'Select Date',
891 'formatType' => 'activityDateTime',
895 'is_online_registration' => [
896 'name' => 'is_online_registration',
897 'type' => CRM_Utils_Type
::T_BOOLEAN
,
898 'title' => ts('Is Online Registration'),
899 'description' => ts('If true, include registration link on Event Info page.'),
900 'where' => 'civicrm_event.is_online_registration',
902 'table_name' => 'civicrm_event',
904 'bao' => 'CRM_Event_BAO_Event',
907 'type' => 'CheckBox',
911 'registration_link_text' => [
912 'name' => 'registration_link_text',
913 'type' => CRM_Utils_Type
::T_STRING
,
914 'title' => ts('Event Registration Link Text'),
915 'description' => ts('Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.'),
917 'size' => CRM_Utils_Type
::HUGE
,
918 'where' => 'civicrm_event.registration_link_text',
919 'table_name' => 'civicrm_event',
921 'bao' => 'CRM_Event_BAO_Event',
928 'registration_start_date' => [
929 'name' => 'registration_start_date',
930 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
931 'title' => ts('Registration Start Date'),
932 'description' => ts('Date and time that online registration starts.'),
933 'where' => 'civicrm_event.registration_start_date',
934 'table_name' => 'civicrm_event',
936 'bao' => 'CRM_Event_BAO_Event',
939 'type' => 'Select Date',
940 'formatType' => 'activityDateTime',
941 'label' => ts("Registration Start Date"),
945 'registration_end_date' => [
946 'name' => 'registration_end_date',
947 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
948 'title' => ts('Registration End Date'),
949 'description' => ts('Date and time that online registration ends.'),
950 'where' => 'civicrm_event.registration_end_date',
951 'table_name' => 'civicrm_event',
953 'bao' => 'CRM_Event_BAO_Event',
956 'type' => 'Select Date',
957 'formatType' => 'activityDateTime',
958 'label' => ts("Registration End Date"),
962 'max_participants' => [
963 'name' => 'max_participants',
964 'type' => CRM_Utils_Type
::T_INT
,
965 'title' => ts('Max Participants'),
966 'description' => ts('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.'),
967 'where' => 'civicrm_event.max_participants',
969 'table_name' => 'civicrm_event',
971 'bao' => 'CRM_Event_BAO_Event',
978 'event_full_text' => [
979 'name' => 'event_full_text',
980 'type' => CRM_Utils_Type
::T_TEXT
,
981 'title' => ts('Event Information'),
982 'description' => ts('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.'),
985 'where' => 'civicrm_event.event_full_text',
986 'table_name' => 'civicrm_event',
988 'bao' => 'CRM_Event_BAO_Event',
991 'type' => 'TextArea',
996 'name' => 'is_monetary',
997 'type' => CRM_Utils_Type
::T_BOOLEAN
,
998 'title' => ts('Is this a PAID event?'),
999 'description' => ts('If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.'),
1000 'where' => 'civicrm_event.is_monetary',
1002 'table_name' => 'civicrm_event',
1003 'entity' => 'Event',
1004 'bao' => 'CRM_Event_BAO_Event',
1007 'type' => 'CheckBox',
1011 'financial_type_id' => [
1012 'name' => 'financial_type_id',
1013 'type' => CRM_Utils_Type
::T_INT
,
1014 'title' => ts('Financial Type'),
1015 'description' => ts('Financial type assigned to paid event registrations for this event. Required if is_monetary is true.'),
1016 'where' => 'civicrm_event.financial_type_id',
1018 'table_name' => 'civicrm_event',
1019 'entity' => 'Event',
1020 'bao' => 'CRM_Event_BAO_Event',
1025 'pseudoconstant' => [
1026 'table' => 'civicrm_financial_type',
1027 'keyColumn' => 'id',
1028 'labelColumn' => 'name',
1032 'payment_processor' => [
1033 'name' => 'payment_processor',
1034 'type' => CRM_Utils_Type
::T_STRING
,
1035 'title' => ts('Payment Processor'),
1036 'description' => ts('Payment Processors configured for this Event (if is_monetary is true)'),
1038 'size' => CRM_Utils_Type
::HUGE
,
1039 'where' => 'civicrm_event.payment_processor',
1040 'table_name' => 'civicrm_event',
1041 'entity' => 'Event',
1042 'bao' => 'CRM_Event_BAO_Event',
1044 'serialize' => self
::SERIALIZE_SEPARATOR_TRIMMED
,
1047 'label' => ts("Payment Processors"),
1049 'pseudoconstant' => [
1050 'table' => 'civicrm_payment_processor',
1051 'keyColumn' => 'id',
1052 'labelColumn' => 'name',
1058 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1059 'title' => ts('Map Enabled'),
1060 'description' => ts('Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?'),
1061 'where' => 'civicrm_event.is_map',
1063 'table_name' => 'civicrm_event',
1064 'entity' => 'Event',
1065 'bao' => 'CRM_Event_BAO_Event',
1068 'type' => 'CheckBox',
1073 'name' => 'is_active',
1074 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1075 'title' => ts('Is Active'),
1076 'description' => ts('Is this Event enabled or disabled/cancelled?'),
1077 'where' => 'civicrm_event.is_active',
1079 'table_name' => 'civicrm_event',
1080 'entity' => 'Event',
1081 'bao' => 'CRM_Event_BAO_Event',
1084 'type' => 'CheckBox',
1089 'name' => 'fee_label',
1090 'type' => CRM_Utils_Type
::T_STRING
,
1091 'title' => ts('Fee Label'),
1093 'size' => CRM_Utils_Type
::HUGE
,
1095 'where' => 'civicrm_event.fee_label',
1096 'headerPattern' => '/^fee|(f(ee\s)?label)$/i',
1098 'table_name' => 'civicrm_event',
1099 'entity' => 'Event',
1100 'bao' => 'CRM_Event_BAO_Event',
1107 'is_show_location' => [
1108 'name' => 'is_show_location',
1109 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1110 'title' => ts('show location'),
1111 'description' => ts('If true, show event location.'),
1112 'where' => 'civicrm_event.is_show_location',
1114 'table_name' => 'civicrm_event',
1115 'entity' => 'Event',
1116 'bao' => 'CRM_Event_BAO_Event',
1119 'type' => 'CheckBox',
1124 'name' => 'loc_block_id',
1125 'type' => CRM_Utils_Type
::T_INT
,
1126 'title' => ts('Location Block ID'),
1127 'description' => ts('FK to Location Block ID'),
1128 'where' => 'civicrm_event.loc_block_id',
1129 'table_name' => 'civicrm_event',
1130 'entity' => 'Event',
1131 'bao' => 'CRM_Event_BAO_Event',
1133 'FKClassName' => 'CRM_Core_DAO_LocBlock',
1135 'label' => ts("Location Block"),
1139 'default_role_id' => [
1140 'name' => 'default_role_id',
1141 'type' => CRM_Utils_Type
::T_INT
,
1142 'title' => ts('Default Role'),
1143 'description' => ts('Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.'),
1145 'where' => 'civicrm_event.default_role_id',
1148 'table_name' => 'civicrm_event',
1149 'entity' => 'Event',
1150 'bao' => 'CRM_Event_BAO_Event',
1155 'pseudoconstant' => [
1156 'optionGroupName' => 'participant_role',
1157 'optionEditPath' => 'civicrm/admin/options/participant_role',
1162 'name' => 'intro_text',
1163 'type' => CRM_Utils_Type
::T_TEXT
,
1164 'title' => ts('Introductory Message'),
1165 'description' => ts('Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.'),
1168 'where' => 'civicrm_event.intro_text',
1169 'table_name' => 'civicrm_event',
1170 'entity' => 'Event',
1171 'bao' => 'CRM_Event_BAO_Event',
1174 'type' => 'RichTextEditor',
1179 'name' => 'footer_text',
1180 'type' => CRM_Utils_Type
::T_TEXT
,
1181 'title' => ts('Footer Message'),
1182 'description' => ts('Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.'),
1185 'where' => 'civicrm_event.footer_text',
1186 'table_name' => 'civicrm_event',
1187 'entity' => 'Event',
1188 'bao' => 'CRM_Event_BAO_Event',
1191 'type' => 'RichTextEditor',
1195 'confirm_title' => [
1196 'name' => 'confirm_title',
1197 'type' => CRM_Utils_Type
::T_STRING
,
1198 'title' => ts('Confirmation Title'),
1199 'description' => ts('Title for Confirmation page.'),
1201 'size' => CRM_Utils_Type
::HUGE
,
1202 'where' => 'civicrm_event.confirm_title',
1204 'table_name' => 'civicrm_event',
1205 'entity' => 'Event',
1206 'bao' => 'CRM_Event_BAO_Event',
1214 'name' => 'confirm_text',
1215 'type' => CRM_Utils_Type
::T_TEXT
,
1216 'title' => ts('Confirm Text'),
1217 'description' => ts('Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.'),
1220 'where' => 'civicrm_event.confirm_text',
1221 'table_name' => 'civicrm_event',
1222 'entity' => 'Event',
1223 'bao' => 'CRM_Event_BAO_Event',
1226 'type' => 'RichTextEditor',
1230 'confirm_footer_text' => [
1231 'name' => 'confirm_footer_text',
1232 'type' => CRM_Utils_Type
::T_TEXT
,
1233 'title' => ts('Footer Text'),
1234 'description' => ts('Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.'),
1237 'where' => 'civicrm_event.confirm_footer_text',
1238 'table_name' => 'civicrm_event',
1239 'entity' => 'Event',
1240 'bao' => 'CRM_Event_BAO_Event',
1243 'type' => 'RichTextEditor',
1247 'is_email_confirm' => [
1248 'name' => 'is_email_confirm',
1249 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1250 'title' => ts('Is confirm email'),
1251 'description' => ts('If true, confirmation is automatically emailed to contact on successful registration.'),
1252 'where' => 'civicrm_event.is_email_confirm',
1254 'table_name' => 'civicrm_event',
1255 'entity' => 'Event',
1256 'bao' => 'CRM_Event_BAO_Event',
1259 'type' => 'CheckBox',
1263 'confirm_email_text' => [
1264 'name' => 'confirm_email_text',
1265 'type' => CRM_Utils_Type
::T_TEXT
,
1266 'title' => ts('Confirmation Email Text'),
1267 'description' => ts('text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now'),
1270 'where' => 'civicrm_event.confirm_email_text',
1271 'table_name' => 'civicrm_event',
1272 'entity' => 'Event',
1273 'bao' => 'CRM_Event_BAO_Event',
1276 'type' => 'TextArea',
1280 'confirm_from_name' => [
1281 'name' => 'confirm_from_name',
1282 'type' => CRM_Utils_Type
::T_STRING
,
1283 'title' => ts('Confirm From Name'),
1284 'description' => ts('FROM email name used for confirmation emails.'),
1286 'size' => CRM_Utils_Type
::HUGE
,
1287 'where' => 'civicrm_event.confirm_from_name',
1288 'table_name' => 'civicrm_event',
1289 'entity' => 'Event',
1290 'bao' => 'CRM_Event_BAO_Event',
1297 'confirm_from_email' => [
1298 'name' => 'confirm_from_email',
1299 'type' => CRM_Utils_Type
::T_STRING
,
1300 'title' => ts('Confirm From Email'),
1301 'description' => ts('FROM email address used for confirmation emails.'),
1303 'size' => CRM_Utils_Type
::HUGE
,
1304 'where' => 'civicrm_event.confirm_from_email',
1305 'table_name' => 'civicrm_event',
1306 'entity' => 'Event',
1307 'bao' => 'CRM_Event_BAO_Event',
1315 'name' => 'cc_confirm',
1316 'type' => CRM_Utils_Type
::T_STRING
,
1317 'title' => ts('Cc Confirm'),
1318 'description' => ts('comma-separated list of email addresses to cc each time a confirmation is sent'),
1320 'size' => CRM_Utils_Type
::HUGE
,
1321 'where' => 'civicrm_event.cc_confirm',
1322 'table_name' => 'civicrm_event',
1323 'entity' => 'Event',
1324 'bao' => 'CRM_Event_BAO_Event',
1328 'label' => ts("CC Confirm"),
1333 'name' => 'bcc_confirm',
1334 'type' => CRM_Utils_Type
::T_STRING
,
1335 'title' => ts('Bcc Confirm'),
1336 'description' => ts('comma-separated list of email addresses to bcc each time a confirmation is sent'),
1338 'size' => CRM_Utils_Type
::HUGE
,
1339 'where' => 'civicrm_event.bcc_confirm',
1340 'table_name' => 'civicrm_event',
1341 'entity' => 'Event',
1342 'bao' => 'CRM_Event_BAO_Event',
1346 'label' => ts("BCC Confirm"),
1350 'default_fee_id' => [
1351 'name' => 'default_fee_id',
1352 'type' => CRM_Utils_Type
::T_INT
,
1353 'title' => ts('Default Fee ID'),
1354 'description' => ts('FK to civicrm_option_value.'),
1355 'where' => 'civicrm_event.default_fee_id',
1356 'table_name' => 'civicrm_event',
1357 'entity' => 'Event',
1358 'bao' => 'CRM_Event_BAO_Event',
1362 'default_discount_fee_id' => [
1363 'name' => 'default_discount_fee_id',
1364 'type' => CRM_Utils_Type
::T_INT
,
1365 'title' => ts('Default Discount Fee ID'),
1366 'description' => ts('FK to civicrm_option_value.'),
1367 'where' => 'civicrm_event.default_discount_fee_id',
1368 'table_name' => 'civicrm_event',
1369 'entity' => 'Event',
1370 'bao' => 'CRM_Event_BAO_Event',
1374 'thankyou_title' => [
1375 'name' => 'thankyou_title',
1376 'type' => CRM_Utils_Type
::T_STRING
,
1377 'title' => ts('ThankYou Title'),
1378 'description' => ts('Title for ThankYou page.'),
1380 'size' => CRM_Utils_Type
::HUGE
,
1381 'where' => 'civicrm_event.thankyou_title',
1383 'table_name' => 'civicrm_event',
1384 'entity' => 'Event',
1385 'bao' => 'CRM_Event_BAO_Event',
1392 'thankyou_text' => [
1393 'name' => 'thankyou_text',
1394 'type' => CRM_Utils_Type
::T_TEXT
,
1395 'title' => ts('ThankYou Text'),
1396 'description' => ts('ThankYou Text.'),
1399 'where' => 'civicrm_event.thankyou_text',
1400 'table_name' => 'civicrm_event',
1401 'entity' => 'Event',
1402 'bao' => 'CRM_Event_BAO_Event',
1405 'type' => 'RichTextEditor',
1409 'thankyou_footer_text' => [
1410 'name' => 'thankyou_footer_text',
1411 'type' => CRM_Utils_Type
::T_TEXT
,
1412 'title' => ts('Footer Text'),
1413 'description' => ts('Footer message.'),
1416 'where' => 'civicrm_event.thankyou_footer_text',
1417 'table_name' => 'civicrm_event',
1418 'entity' => 'Event',
1419 'bao' => 'CRM_Event_BAO_Event',
1422 'type' => 'RichTextEditor',
1427 'name' => 'is_pay_later',
1428 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1429 'title' => ts('Pay Later Allowed'),
1430 'description' => ts('if true - allows the user to send payment directly to the org later'),
1431 'where' => 'civicrm_event.is_pay_later',
1433 'table_name' => 'civicrm_event',
1434 'entity' => 'Event',
1435 'bao' => 'CRM_Event_BAO_Event',
1438 'type' => 'CheckBox',
1442 'pay_later_text' => [
1443 'name' => 'pay_later_text',
1444 'type' => CRM_Utils_Type
::T_TEXT
,
1445 'title' => ts('Pay Later Text'),
1446 'description' => ts('The text displayed to the user in the main form'),
1447 'where' => 'civicrm_event.pay_later_text',
1448 'table_name' => 'civicrm_event',
1449 'entity' => 'Event',
1450 'bao' => 'CRM_Event_BAO_Event',
1453 'type' => 'RichTextEditor',
1457 'pay_later_receipt' => [
1458 'name' => 'pay_later_receipt',
1459 'type' => CRM_Utils_Type
::T_TEXT
,
1460 'title' => ts('Pay Later Receipt Text'),
1461 'description' => ts('The receipt sent to the user instead of the normal receipt text'),
1462 'where' => 'civicrm_event.pay_later_receipt',
1463 'table_name' => 'civicrm_event',
1464 'entity' => 'Event',
1465 'bao' => 'CRM_Event_BAO_Event',
1472 'is_partial_payment' => [
1473 'name' => 'is_partial_payment',
1474 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1475 'title' => ts('Partial Payments Enabled'),
1476 'description' => ts('is partial payment enabled for this event'),
1477 'where' => 'civicrm_event.is_partial_payment',
1479 'table_name' => 'civicrm_event',
1480 'entity' => 'Event',
1481 'bao' => 'CRM_Event_BAO_Event',
1484 'type' => 'CheckBox',
1488 'initial_amount_label' => [
1489 'name' => 'initial_amount_label',
1490 'type' => CRM_Utils_Type
::T_STRING
,
1491 'title' => ts('Initial Amount Label'),
1492 'description' => ts('Initial amount label for partial payment'),
1494 'size' => CRM_Utils_Type
::HUGE
,
1495 'where' => 'civicrm_event.initial_amount_label',
1496 'table_name' => 'civicrm_event',
1497 'entity' => 'Event',
1498 'bao' => 'CRM_Event_BAO_Event',
1505 'initial_amount_help_text' => [
1506 'name' => 'initial_amount_help_text',
1507 'type' => CRM_Utils_Type
::T_TEXT
,
1508 'title' => ts('Initial Amount Help Text'),
1509 'description' => ts('Initial amount help text for partial payment'),
1510 'where' => 'civicrm_event.initial_amount_help_text',
1511 'table_name' => 'civicrm_event',
1512 'entity' => 'Event',
1513 'bao' => 'CRM_Event_BAO_Event',
1520 'min_initial_amount' => [
1521 'name' => 'min_initial_amount',
1522 'type' => CRM_Utils_Type
::T_MONEY
,
1523 'title' => ts('Minimum Initial Amount'),
1524 'description' => ts('Minimum initial amount for partial payment'),
1529 'where' => 'civicrm_event.min_initial_amount',
1530 'table_name' => 'civicrm_event',
1531 'entity' => 'Event',
1532 'bao' => 'CRM_Event_BAO_Event',
1539 'is_multiple_registrations' => [
1540 'name' => 'is_multiple_registrations',
1541 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1542 'title' => ts('Allow Multiple Registrations'),
1543 'description' => ts('if true - allows the user to register multiple participants for event'),
1544 'where' => 'civicrm_event.is_multiple_registrations',
1546 'table_name' => 'civicrm_event',
1547 'entity' => 'Event',
1548 'bao' => 'CRM_Event_BAO_Event',
1551 'type' => 'CheckBox',
1555 'max_additional_participants' => [
1556 'name' => 'max_additional_participants',
1557 'type' => CRM_Utils_Type
::T_INT
,
1558 'title' => ts('Maximum number of additional participants per registration'),
1559 'description' => ts('Maximum number of additional participants that can be registered on a single booking'),
1560 'where' => 'civicrm_event.max_additional_participants',
1562 'table_name' => 'civicrm_event',
1563 'entity' => 'Event',
1564 'bao' => 'CRM_Event_BAO_Event',
1568 'allow_same_participant_emails' => [
1569 'name' => 'allow_same_participant_emails',
1570 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1571 'title' => ts('Does Event allow multiple registrations from same email address?'),
1572 'description' => ts('if true - allows the user to register multiple registrations from same email address.'),
1573 'where' => 'civicrm_event.allow_same_participant_emails',
1575 'table_name' => 'civicrm_event',
1576 'entity' => 'Event',
1577 'bao' => 'CRM_Event_BAO_Event',
1580 'type' => 'CheckBox',
1585 'name' => 'has_waitlist',
1586 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1587 'title' => ts('Waitlist Enabled'),
1588 'description' => ts('Whether the event has waitlist support.'),
1589 'where' => 'civicrm_event.has_waitlist',
1590 'table_name' => 'civicrm_event',
1591 'entity' => 'Event',
1592 'bao' => 'CRM_Event_BAO_Event',
1595 'type' => 'CheckBox',
1599 'requires_approval' => [
1600 'name' => 'requires_approval',
1601 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1602 'title' => ts('Requires Approval'),
1603 'description' => ts('Whether participants require approval before they can finish registering.'),
1604 'where' => 'civicrm_event.requires_approval',
1605 'table_name' => 'civicrm_event',
1606 'entity' => 'Event',
1607 'bao' => 'CRM_Event_BAO_Event',
1610 'type' => 'CheckBox',
1611 'label' => ts("Requires Approval"),
1615 'expiration_time' => [
1616 'name' => 'expiration_time',
1617 'type' => CRM_Utils_Type
::T_INT
,
1618 'title' => ts('Expiration Time'),
1619 'description' => ts('Expire pending but unconfirmed registrations after this many hours.'),
1620 'where' => 'civicrm_event.expiration_time',
1621 'table_name' => 'civicrm_event',
1622 'entity' => 'Event',
1623 'bao' => 'CRM_Event_BAO_Event',
1627 'label' => ts("Expiration Time"),
1631 'allow_selfcancelxfer' => [
1632 'name' => 'allow_selfcancelxfer',
1633 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1634 'title' => ts('Allow Self-service Cancellation or Transfer'),
1635 'description' => ts('Allow self service cancellation or transfer for event?'),
1636 'where' => 'civicrm_event.allow_selfcancelxfer',
1638 'table_name' => 'civicrm_event',
1639 'entity' => 'Event',
1640 'bao' => 'CRM_Event_BAO_Event',
1643 'type' => 'CheckBox',
1647 'selfcancelxfer_time' => [
1648 'name' => 'selfcancelxfer_time',
1649 'type' => CRM_Utils_Type
::T_INT
,
1650 'title' => ts('Self-service Cancellation or Transfer Time'),
1651 'description' => ts('Number of hours prior to event start date to allow self-service cancellation or transfer.'),
1652 'where' => 'civicrm_event.selfcancelxfer_time',
1654 'table_name' => 'civicrm_event',
1655 'entity' => 'Event',
1656 'bao' => 'CRM_Event_BAO_Event',
1663 'waitlist_text' => [
1664 'name' => 'waitlist_text',
1665 'type' => CRM_Utils_Type
::T_TEXT
,
1666 'title' => ts('Waitlist Text'),
1667 'description' => ts('Text to display when the event is full, but participants can signup for a waitlist.'),
1670 'where' => 'civicrm_event.waitlist_text',
1671 'table_name' => 'civicrm_event',
1672 'entity' => 'Event',
1673 'bao' => 'CRM_Event_BAO_Event',
1676 'type' => 'TextArea',
1677 'label' => ts("Waitlist Text"),
1681 'approval_req_text' => [
1682 'name' => 'approval_req_text',
1683 'type' => CRM_Utils_Type
::T_TEXT
,
1684 'title' => ts('Approval Req Text'),
1685 'description' => ts('Text to display when the approval is required to complete registration for an event.'),
1688 'where' => 'civicrm_event.approval_req_text',
1689 'table_name' => 'civicrm_event',
1690 'entity' => 'Event',
1691 'bao' => 'CRM_Event_BAO_Event',
1694 'type' => 'TextArea',
1695 'label' => ts("Approval Required Text"),
1700 'name' => 'is_template',
1701 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1702 'title' => ts('Is an Event Template'),
1703 'description' => ts('whether the event has template'),
1705 'where' => 'civicrm_event.is_template',
1707 'table_name' => 'civicrm_event',
1708 'entity' => 'Event',
1709 'bao' => 'CRM_Event_BAO_Event',
1712 'type' => 'CheckBox',
1716 'template_title' => [
1717 'name' => 'template_title',
1718 'type' => CRM_Utils_Type
::T_STRING
,
1719 'title' => ts('Event Template Title'),
1720 'description' => ts('Event Template Title'),
1722 'size' => CRM_Utils_Type
::HUGE
,
1724 'where' => 'civicrm_event.template_title',
1725 'headerPattern' => '/(template.)?title$/i',
1727 'table_name' => 'civicrm_event',
1728 'entity' => 'Event',
1729 'bao' => 'CRM_Event_BAO_Event',
1737 'name' => 'created_id',
1738 'type' => CRM_Utils_Type
::T_INT
,
1739 'title' => ts('Created By Contact ID'),
1740 'description' => ts('FK to civicrm_contact, who created this event'),
1741 'where' => 'civicrm_event.created_id',
1742 'table_name' => 'civicrm_event',
1743 'entity' => 'Event',
1744 'bao' => 'CRM_Event_BAO_Event',
1746 'FKClassName' => 'CRM_Contact_DAO_Contact',
1748 'label' => ts("Created By"),
1753 'name' => 'created_date',
1754 'type' => CRM_Utils_Type
::T_DATE + CRM_Utils_Type
::T_TIME
,
1755 'title' => ts('Event Created Date'),
1756 'description' => ts('Date and time that event was created.'),
1757 'where' => 'civicrm_event.created_date',
1758 'table_name' => 'civicrm_event',
1759 'entity' => 'Event',
1760 'bao' => 'CRM_Event_BAO_Event',
1765 'name' => 'currency',
1766 'type' => CRM_Utils_Type
::T_STRING
,
1767 'title' => ts('Currency'),
1768 'description' => ts('3 character string, value from config setting or input via user.'),
1770 'size' => CRM_Utils_Type
::FOUR
,
1772 'where' => 'civicrm_event.currency',
1773 'headerPattern' => '/cur(rency)?/i',
1774 'dataPattern' => '/^[A-Z]{3}$/i',
1776 'table_name' => 'civicrm_event',
1777 'entity' => 'Event',
1778 'bao' => 'CRM_Event_BAO_Event',
1782 'label' => ts("Currency"),
1784 'pseudoconstant' => [
1785 'table' => 'civicrm_currency',
1786 'keyColumn' => 'name',
1787 'labelColumn' => 'full_name',
1788 'nameColumn' => 'name',
1789 'abbrColumn' => 'symbol',
1794 'name' => 'campaign_id',
1795 'type' => CRM_Utils_Type
::T_INT
,
1796 'title' => ts('Campaign ID'),
1797 'description' => ts('The campaign for which this event has been created.'),
1798 'where' => 'civicrm_event.campaign_id',
1799 'table_name' => 'civicrm_event',
1800 'entity' => 'Event',
1801 'bao' => 'CRM_Event_BAO_Event',
1803 'FKClassName' => 'CRM_Campaign_DAO_Campaign',
1804 'component' => 'CiviCampaign',
1806 'type' => 'EntityRef',
1807 'label' => ts("Campaign"),
1809 'pseudoconstant' => [
1810 'table' => 'civicrm_campaign',
1811 'keyColumn' => 'id',
1812 'labelColumn' => 'title',
1813 'prefetch' => 'FALSE',
1818 'name' => 'is_share',
1819 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1820 'title' => ts('Is shared through social media'),
1821 'description' => ts('Can people share the event through social media?'),
1822 'where' => 'civicrm_event.is_share',
1824 'table_name' => 'civicrm_event',
1825 'entity' => 'Event',
1826 'bao' => 'CRM_Event_BAO_Event',
1829 'type' => 'CheckBox',
1833 'is_confirm_enabled' => [
1834 'name' => 'is_confirm_enabled',
1835 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1836 'title' => ts('Is the booking confirmation screen enabled?'),
1837 'description' => ts('If false, the event booking confirmation screen gets skipped'),
1838 'where' => 'civicrm_event.is_confirm_enabled',
1840 'table_name' => 'civicrm_event',
1841 'entity' => 'Event',
1842 'bao' => 'CRM_Event_BAO_Event',
1845 'type' => 'CheckBox',
1849 'parent_event_id' => [
1850 'name' => 'parent_event_id',
1851 'type' => CRM_Utils_Type
::T_INT
,
1852 'title' => ts('Parent Event ID'),
1853 'description' => ts('Implicit FK to civicrm_event: parent event'),
1854 'where' => 'civicrm_event.parent_event_id',
1856 'table_name' => 'civicrm_event',
1857 'entity' => 'Event',
1858 'bao' => 'CRM_Event_BAO_Event',
1861 'type' => 'EntityRef',
1865 'slot_label_id' => [
1866 'name' => 'slot_label_id',
1867 'type' => CRM_Utils_Type
::T_INT
,
1868 'title' => ts('Subevent Slot Label ID'),
1869 'description' => ts('Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.'),
1870 'where' => 'civicrm_event.slot_label_id',
1872 'table_name' => 'civicrm_event',
1873 'entity' => 'Event',
1874 'bao' => 'CRM_Event_BAO_Event',
1881 'dedupe_rule_group_id' => [
1882 'name' => 'dedupe_rule_group_id',
1883 'type' => CRM_Utils_Type
::T_INT
,
1884 'title' => ts('Dedupe Rule ID'),
1885 'description' => ts('Rule to use when matching registrations for this event'),
1886 'where' => 'civicrm_event.dedupe_rule_group_id',
1888 'table_name' => 'civicrm_event',
1889 'entity' => 'Event',
1890 'bao' => 'CRM_Event_BAO_Event',
1892 'FKClassName' => 'CRM_Dedupe_DAO_DedupeRuleGroup',
1895 'label' => ts("Dedupe Rule"),
1897 'pseudoconstant' => [
1898 'table' => 'civicrm_dedupe_rule_group',
1899 'keyColumn' => 'id',
1900 'labelColumn' => 'title',
1901 'nameColumn' => 'name',
1905 'is_billing_required' => [
1906 'name' => 'is_billing_required',
1907 'type' => CRM_Utils_Type
::T_BOOLEAN
,
1908 'title' => ts('Is billing block required'),
1909 'description' => ts('if true than billing block is required this event'),
1910 'where' => 'civicrm_event.is_billing_required',
1912 'table_name' => 'civicrm_event',
1913 'entity' => 'Event',
1914 'bao' => 'CRM_Event_BAO_Event',
1917 'type' => 'CheckBox',
1922 CRM_Core_DAO_AllCoreTables
::invoke(__CLASS__
, 'fields_callback', Civi
::$statics[__CLASS__
]['fields']);
1924 return Civi
::$statics[__CLASS__
]['fields'];
1928 * Return a mapping from field-name to the corresponding key (as used in fields()).
1931 * Array(string $name => string $uniqueName).
1933 public static function &fieldKeys() {
1934 if (!isset(Civi
::$statics[__CLASS__
]['fieldKeys'])) {
1935 Civi
::$statics[__CLASS__
]['fieldKeys'] = array_flip(CRM_Utils_Array
::collect('name', self
::fields()));
1937 return Civi
::$statics[__CLASS__
]['fieldKeys'];
1941 * Returns the names of this table
1945 public static function getTableName() {
1946 return CRM_Core_DAO
::getLocaleTableName(self
::$_tableName);
1950 * Returns if this table needs to be logged
1954 public function getLog() {
1959 * Returns the list of fields that can be imported
1961 * @param bool $prefix
1965 public static function &import($prefix = FALSE) {
1966 $r = CRM_Core_DAO_AllCoreTables
::getImports(__CLASS__
, 'event', $prefix, []);
1971 * Returns the list of fields that can be exported
1973 * @param bool $prefix
1977 public static function &export($prefix = FALSE) {
1978 $r = CRM_Core_DAO_AllCoreTables
::getExports(__CLASS__
, 'event', $prefix, []);
1983 * Returns the list of indices
1985 * @param bool $localize
1989 public static function indices($localize = TRUE) {
1991 'index_event_type_id' => [
1992 'name' => 'index_event_type_id',
1994 0 => 'event_type_id',
1996 'localizable' => FALSE,
1997 'sig' => 'civicrm_event::0::event_type_id',
1999 'index_participant_listing_id' => [
2000 'name' => 'index_participant_listing_id',
2002 0 => 'participant_listing_id',
2004 'localizable' => FALSE,
2005 'sig' => 'civicrm_event::0::participant_listing_id',
2007 'index_parent_event_id' => [
2008 'name' => 'index_parent_event_id',
2010 0 => 'parent_event_id',
2012 'localizable' => FALSE,
2013 'sig' => 'civicrm_event::0::parent_event_id',
2016 return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables
::multilingualize(__CLASS__
, $indices) : $indices;