/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Event'), 'required' => true), 'event_title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.title', 'headerPattern' => '/(event.)?title$/i', 'dataPattern' => '', 'export' => true), 'summary' => array('name' => 'summary', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Summary'), 'rows' => 4, 'cols' => 60), 'event_description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Description'), 'rows' => 8, 'cols' => 60), 'event_type_id' => array('name' => 'event_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Event Type'), 'pseudoconstant' => array('optionGroupName' => 'event_type')), 'participant_listing_id' => array('name' => 'participant_listing_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Participant Listing'), 'pseudoconstant' => array('optionGroupName' => 'participant_listing')), 'is_public' => array('name' => 'is_public', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Event Public'), 'default' => '1'), 'event_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event Start Date'), 'import' => true, 'where' => 'civicrm_event.start_date', 'headerPattern' => '/^start|(s(tart\\s)?date)$/i', 'dataPattern' => '', 'export' => true), 'event_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event End Date'), 'import' => true, 'where' => 'civicrm_event.end_date', 'headerPattern' => '/^end|(e(nd\\s)?date)$/i', 'dataPattern' => '', 'export' => true), 'is_online_registration' => array('name' => 'is_online_registration', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Online Registration')), 'registration_link_text' => array('name' => 'registration_link_text', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Registration Link Text'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'registration_start_date' => array('name' => 'registration_start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Registration Start Date')), 'registration_end_date' => array('name' => 'registration_end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Registration End Date')), 'max_participants' => array('name' => 'max_participants', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Max Participants'), 'default' => 'NULL'), 'event_full_text' => array('name' => 'event_full_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Information'), 'rows' => 4, 'cols' => 60), 'is_monetary' => array('name' => 'is_monetary', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is this a PAID event?')), 'financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Type'), 'default' => 'NULL', 'pseudoconstant' => array('table' => 'civicrm_financial_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'payment_processor' => array('name' => 'payment_processor', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Payment Processor'), 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'pseudoconstant' => array('table' => 'civicrm_payment_processor', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'is_map' => array('name' => 'is_map', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Map Enabled')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Active')), 'fee_label' => array('name' => 'fee_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Fee Label'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.fee_label', 'headerPattern' => '/^fee|(f(ee\\s)?label)$/i', 'dataPattern' => '', 'export' => true), 'is_show_location' => array('name' => 'is_show_location', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('show location'), 'default' => '1'), 'loc_block_id' => array('name' => 'loc_block_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Location Block ID'), 'FKClassName' => 'CRM_Core_DAO_LocBlock'), 'default_role_id' => array('name' => 'default_role_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Participant Role'), 'import' => true, 'where' => 'civicrm_event.default_role_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'default' => '1', 'pseudoconstant' => array('optionGroupName' => 'participant_role')), 'intro_text' => array('name' => 'intro_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Introductory Message'), 'rows' => 6, 'cols' => 50), 'footer_text' => array('name' => 'footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Message'), 'rows' => 6, 'cols' => 50), 'confirm_title' => array('name' => 'confirm_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirmation Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'NULL'), 'confirm_text' => array('name' => 'confirm_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Confirm Text'), 'rows' => 6, 'cols' => 50), 'confirm_footer_text' => array('name' => 'confirm_footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'rows' => 6, 'cols' => 50), 'is_email_confirm' => array('name' => 'is_email_confirm', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is confirm email')), 'confirm_email_text' => array('name' => 'confirm_email_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Confirmation Email Text'), 'rows' => 4, 'cols' => 50), 'confirm_from_name' => array('name' => 'confirm_from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirm From Name'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'confirm_from_email' => array('name' => 'confirm_from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirm From Email'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'cc_confirm' => array('name' => 'cc_confirm', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Cc Confirm'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'bcc_confirm' => array('name' => 'bcc_confirm', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Bcc Confirm'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'default_fee_id' => array('name' => 'default_fee_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Default Fee ID')), 'default_discount_fee_id' => array('name' => 'default_discount_fee_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Default Discount Fee ID')), 'thankyou_title' => array('name' => 'thankyou_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ThankYou Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'NULL'), 'thankyou_text' => array('name' => 'thankyou_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('ThankYou Text'), 'rows' => 6, 'cols' => 50), 'thankyou_footer_text' => array('name' => 'thankyou_footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'rows' => 6, 'cols' => 50), 'is_pay_later' => array('name' => 'is_pay_later', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Pay Later Allowed')), 'pay_later_text' => array('name' => 'pay_later_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Text')), 'pay_later_receipt' => array('name' => 'pay_later_receipt', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Receipt Text')), 'is_partial_payment' => array('name' => 'is_partial_payment', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Partial Payments Enabled')), 'initial_amount_label' => array('name' => 'initial_amount_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Initial Amount Label'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'initial_amount_help_text' => array('name' => 'initial_amount_help_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Initial Amount Help Text')), 'min_initial_amount' => array('name' => 'min_initial_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Minimum Initial Amount')), 'is_multiple_registrations' => array('name' => 'is_multiple_registrations', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Allow Multiple Registrations')), 'allow_same_participant_emails' => array('name' => 'allow_same_participant_emails', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Does Event allow multiple registrations from same email address?')), 'has_waitlist' => array('name' => 'has_waitlist', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Waitlist Enabled')), 'requires_approval' => array('name' => 'requires_approval', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Requires Approval')), 'expiration_time' => array('name' => 'expiration_time', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Expiration Time')), 'waitlist_text' => array('name' => 'waitlist_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Waitlist Text'), 'rows' => 4, 'cols' => 60), 'approval_req_text' => array('name' => 'approval_req_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Approval Req Text'), 'rows' => 4, 'cols' => 60), 'is_template' => array('name' => 'is_template', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is an Event Template')), 'template_title' => array('name' => 'template_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Template Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.template_title', 'headerPattern' => '/(template.)?title$/i', 'dataPattern' => '', 'export' => true), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Created By Contact ID'), 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event Created Date')), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Currency'), 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'import' => true, 'where' => 'civicrm_event.currency', 'headerPattern' => '/cur(rency)?/i', 'dataPattern' => '/^[A-Z]{3}$/i', 'export' => true, 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'numeric_code')), 'campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign'), 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'is_share' => array('name' => 'is_share', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is shared through social media'), 'default' => '1'), 'parent_event_id' => array('name' => 'parent_event_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Parent Event ID'), 'default' => 'NULL'), 'slot_label_id' => array('name' => 'slot_label_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Subevent Slot Label ID'), 'default' => 'NULL'));
}
return self::$_fields;
}
/**
* returns all the column names of this table
*
* @access public
* @return array
*/
function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'required' => true), 'event_title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.title', 'headerPattern' => '/(event.)?title$/i', 'dataPattern' => '', 'export' => true), 'summary' => array('name' => 'summary', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Summary'), 'rows' => 4, 'cols' => 60), 'event_description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Description'), 'rows' => 8, 'cols' => 60), 'event_type_id' => array('name' => 'event_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Event Type ID')), 'participant_listing_id' => array('name' => 'participant_listing_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Participant Listing ID')), 'is_public' => array('name' => 'is_public', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Event Public'), 'default' => ''), 'event_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event Start Date'), 'import' => true, 'where' => 'civicrm_event.start_date', 'headerPattern' => '/^start|(s(tart\\s)?date)$/i', 'dataPattern' => '', 'export' => true), 'event_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event End Date'), 'import' => true, 'where' => 'civicrm_event.end_date', 'headerPattern' => '/^end|(e(nd\\s)?date)$/i', 'dataPattern' => '', 'export' => true), 'is_online_registration' => array('name' => 'is_online_registration', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Online Registration')), 'registration_link_text' => array('name' => 'registration_link_text', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Registration Link Text'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'registration_start_date' => array('name' => 'registration_start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Registration Start Date')), 'registration_end_date' => array('name' => 'registration_end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Registration End Date')), 'max_participants' => array('name' => 'max_participants', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Max Participants'), 'default' => 'UL'), 'event_full_text' => array('name' => 'event_full_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Information'), 'rows' => 4, 'cols' => 60), 'is_monetary' => array('name' => 'is_monetary', 'type' => CRM_Utils_Type::T_BOOLEAN), 'contribution_type_id' => array('name' => 'contribution_type_id', 'type' => CRM_Utils_Type::T_INT), 'payment_processor_id' => array('name' => 'payment_processor_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_PaymentProcessor'), 'is_map' => array('name' => 'is_map', 'type' => CRM_Utils_Type::T_BOOLEAN), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN), 'fee_label' => array('name' => 'fee_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Fee Label'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.fee_label', 'headerPattern' => '/^fee|(f(ee\\s)?label)$/i', 'dataPattern' => '', 'export' => true), 'is_show_location' => array('name' => 'is_show_location', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('show location'), 'default' => ''), 'loc_block_id' => array('name' => 'loc_block_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_LocBlock'), 'default_role_id' => array('name' => 'default_role_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Participant Role'), 'import' => true, 'where' => 'civicrm_event.default_role_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'default' => ''), 'intro_text' => array('name' => 'intro_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Introductory Message'), 'rows' => 6, 'cols' => 50), 'footer_text' => array('name' => 'footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Message'), 'rows' => 6, 'cols' => 50), 'confirm_title' => array('name' => 'confirm_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirmation Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'UL'), 'confirm_text' => array('name' => 'confirm_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Confirm Text'), 'rows' => 6, 'cols' => 50), 'confirm_footer_text' => array('name' => 'confirm_footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'rows' => 6, 'cols' => 50), 'is_email_confirm' => array('name' => 'is_email_confirm', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is confirm email')), 'confirm_email_text' => array('name' => 'confirm_email_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Confirmation Email Text'), 'rows' => 4, 'cols' => 50), 'confirm_from_name' => array('name' => 'confirm_from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirm From Name'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'confirm_from_email' => array('name' => 'confirm_from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirm From Email'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'cc_confirm' => array('name' => 'cc_confirm', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Cc Confirm'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'bcc_confirm' => array('name' => 'bcc_confirm', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Bcc Confirm'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'default_fee_id' => array('name' => 'default_fee_id', 'type' => CRM_Utils_Type::T_INT), 'default_discount_fee_id' => array('name' => 'default_discount_fee_id', 'type' => CRM_Utils_Type::T_INT), 'thankyou_title' => array('name' => 'thankyou_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ThankYou Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'UL'), 'thankyou_text' => array('name' => 'thankyou_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('ThankYou Text'), 'rows' => 6, 'cols' => 50), 'thankyou_footer_text' => array('name' => 'thankyou_footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'rows' => 6, 'cols' => 50), 'is_pay_later' => array('name' => 'is_pay_later', 'type' => CRM_Utils_Type::T_BOOLEAN), 'pay_later_text' => array('name' => 'pay_later_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Text')), 'pay_later_receipt' => array('name' => 'pay_later_receipt', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Receipt')), 'is_multiple_registrations' => array('name' => 'is_multiple_registrations', 'type' => CRM_Utils_Type::T_BOOLEAN), 'allow_same_participant_emails' => array('name' => 'allow_same_participant_emails', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Does Event allow multiple registrations from same email address?')), 'has_waitlist' => array('name' => 'has_waitlist', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Has Waitlist')), 'requires_approval' => array('name' => 'requires_approval', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Requires Approval')), 'expiration_time' => array('name' => 'expiration_time', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Expiration Time')), 'waitlist_text' => array('name' => 'waitlist_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Waitlist Text'), 'rows' => 4, 'cols' => 60), 'approval_req_text' => array('name' => 'approval_req_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Approval Req Text'), 'rows' => 4, 'cols' => 60), 'is_template' => array('name' => 'is_template', 'type' => CRM_Utils_Type::T_BOOLEAN), 'template_title' => array('name' => 'template_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Template Title'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.template_title', 'headerPattern' => '/(template.)?title$/i', 'dataPattern' => '', 'export' => true), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event Created Date')));
}
return self::$_fields;
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Event ID'), 'description' => 'Event', 'required' => true), 'event_title' => array('name' => 'title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Title'), 'description' => 'Event Title (e.g. Fall Fundraiser Dinner)', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.title', 'headerPattern' => '/(event.)?title$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'summary' => array('name' => 'summary', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Summary'), '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.', 'rows' => 4, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'event_description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Description'), 'description' => 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.', 'rows' => 8, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'event_type_id' => array('name' => 'event_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Event Type'), 'description' => 'Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'event_type', 'optionEditPath' => 'civicrm/admin/options/event_type')), 'participant_listing_id' => array('name' => 'participant_listing_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Participant Listing'), 'description' => 'Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'participant_listing', 'optionEditPath' => 'civicrm/admin/options/participant_listing')), 'is_public' => array('name' => 'is_public', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Event Public'), 'description' => 'Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.', 'default' => '1', 'html' => array('type' => 'CheckBox')), 'event_start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event Start Date'), 'description' => 'Date and time that event starts.', 'import' => true, 'where' => 'civicrm_event.start_date', 'headerPattern' => '/^start|(s(tart\\s)?date)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'event_end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event End Date'), 'description' => 'Date and time that event ends. May be NULL if no defined end date/time', 'import' => true, 'where' => 'civicrm_event.end_date', 'headerPattern' => '/^end|(e(nd\\s)?date)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'is_online_registration' => array('name' => 'is_online_registration', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Online Registration'), 'description' => 'If true, include registration link on Event Info page.', 'html' => array('type' => 'CheckBox')), 'registration_link_text' => array('name' => 'registration_link_text', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Registration Link Text'), 'description' => 'Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'registration_start_date' => array('name' => 'registration_start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Registration Start Date'), 'description' => 'Date and time that online registration starts.', 'html' => array('type' => 'Select Date')), 'registration_end_date' => array('name' => 'registration_end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Registration End Date'), 'description' => 'Date and time that online registration ends.', 'html' => array('type' => 'Select Date')), 'max_participants' => array('name' => 'max_participants', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Max Participants'), '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.', 'default' => 'NULL', 'html' => array('type' => 'Text')), 'event_full_text' => array('name' => 'event_full_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Event Information'), '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.', 'rows' => 4, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'is_monetary' => array('name' => 'is_monetary', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is this a PAID event?'), 'description' => 'If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.', 'html' => array('type' => 'CheckBox')), 'financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Financial Type'), 'description' => 'Financial type assigned to paid event registrations for this event. Required if is_monetary is true.', 'default' => 'NULL', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_financial_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'payment_processor' => array('name' => 'payment_processor', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Payment Processor'), 'description' => 'Payment Processors configured for this Event (if is_monetary is true)', 'maxlength' => 128, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_payment_processor', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'is_map' => array('name' => 'is_map', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Map Enabled'), 'description' => 'Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?', 'html' => array('type' => 'CheckBox')), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is Active'), 'description' => 'Is this Event enabled or disabled/cancelled?', 'html' => array('type' => 'CheckBox')), 'fee_label' => array('name' => 'fee_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Fee Label'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.fee_label', 'headerPattern' => '/^fee|(f(ee\\s)?label)$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'is_show_location' => array('name' => 'is_show_location', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('show location'), 'description' => 'If true, show event location.', 'default' => '1', 'html' => array('type' => 'CheckBox')), 'loc_block_id' => array('name' => 'loc_block_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Location Block ID'), 'description' => 'FK to Location Block ID', 'FKClassName' => 'CRM_Core_DAO_LocBlock'), 'default_role_id' => array('name' => 'default_role_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Default Role ID'), 'description' => 'Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.', 'import' => true, 'where' => 'civicrm_event.default_role_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'default' => '1', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'participant_role', 'optionEditPath' => 'civicrm/admin/options/participant_role')), 'intro_text' => array('name' => 'intro_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Introductory Message'), 'description' => 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'footer_text' => array('name' => 'footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Message'), 'description' => 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'confirm_title' => array('name' => 'confirm_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirmation Title'), 'description' => 'Title for Confirmation page.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'NULL', 'html' => array('type' => 'Text')), 'confirm_text' => array('name' => 'confirm_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Confirm Text'), 'description' => 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'confirm_footer_text' => array('name' => 'confirm_footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'description' => 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'is_email_confirm' => array('name' => 'is_email_confirm', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is confirm email'), 'description' => 'If true, confirmation is automatically emailed to contact on successful registration.', 'html' => array('type' => 'CheckBox')), 'confirm_email_text' => array('name' => 'confirm_email_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Confirmation Email Text'), 'description' => 'text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now', 'rows' => 4, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'confirm_from_name' => array('name' => 'confirm_from_name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirm From Name'), 'description' => 'FROM email name used for confirmation emails.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'confirm_from_email' => array('name' => 'confirm_from_email', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Confirm From Email'), 'description' => 'FROM email address used for confirmation emails.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'cc_confirm' => array('name' => 'cc_confirm', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Cc Confirm'), 'description' => 'comma-separated list of email addresses to cc each time a confirmation is sent', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'bcc_confirm' => array('name' => 'bcc_confirm', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Bcc Confirm'), 'description' => 'comma-separated list of email addresses to bcc each time a confirmation is sent', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'default_fee_id' => array('name' => 'default_fee_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Default Fee ID'), 'description' => 'FK to civicrm_option_value.'), 'default_discount_fee_id' => array('name' => 'default_discount_fee_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Default Discount Fee ID'), 'description' => 'FK to civicrm_option_value.'), 'thankyou_title' => array('name' => 'thankyou_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('ThankYou Title'), 'description' => 'Title for ThankYou page.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'default' => 'NULL', 'html' => array('type' => 'Text')), 'thankyou_text' => array('name' => 'thankyou_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('ThankYou Text'), 'description' => 'ThankYou Text.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'thankyou_footer_text' => array('name' => 'thankyou_footer_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Footer Text'), 'description' => 'Footer message.', 'rows' => 6, 'cols' => 50, 'html' => array('type' => 'TextArea')), 'is_pay_later' => array('name' => 'is_pay_later', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Pay Later Allowed'), 'description' => 'if true - allows the user to send payment directly to the org later', 'html' => array('type' => 'CheckBox')), 'pay_later_text' => array('name' => 'pay_later_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Text'), 'description' => 'The text displayed to the user in the main form', 'html' => array('type' => 'Text')), 'pay_later_receipt' => array('name' => 'pay_later_receipt', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Pay Later Receipt Text'), 'description' => 'The receipt sent to the user instead of the normal receipt text', 'html' => array('type' => 'Text')), 'is_partial_payment' => array('name' => 'is_partial_payment', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Partial Payments Enabled'), 'description' => 'is partial payment enabled for this event', 'html' => array('type' => 'CheckBox')), 'initial_amount_label' => array('name' => 'initial_amount_label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Initial Amount Label'), 'description' => 'Initial amount label for partial payment', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'html' => array('type' => 'Text')), 'initial_amount_help_text' => array('name' => 'initial_amount_help_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Initial Amount Help Text'), 'description' => 'Initial amount help text for partial payment', 'html' => array('type' => 'Text')), 'min_initial_amount' => array('name' => 'min_initial_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Minimum Initial Amount'), 'description' => 'Minimum initial amount for partial payment', 'precision' => array(20, 2), 'html' => array('type' => 'Text')), 'is_multiple_registrations' => array('name' => 'is_multiple_registrations', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Allow Multiple Registrations'), 'description' => 'if true - allows the user to register multiple participants for event', 'html' => array('type' => 'CheckBox')), 'allow_same_participant_emails' => array('name' => 'allow_same_participant_emails', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Does Event allow multiple registrations from same email address?'), 'description' => 'if true - allows the user to register multiple registrations from same email address.', 'html' => array('type' => 'CheckBox')), 'has_waitlist' => array('name' => 'has_waitlist', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Waitlist Enabled'), 'description' => 'Whether the event has waitlist support.', 'html' => array('type' => 'CheckBox')), 'requires_approval' => array('name' => 'requires_approval', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Requires Approval'), 'description' => 'Whether participants require approval before they can finish registering.', 'html' => array('type' => 'CheckBox')), 'expiration_time' => array('name' => 'expiration_time', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Expiration Time'), 'description' => 'Expire pending but unconfirmed registrations after this many hours.', 'html' => array('type' => 'Text')), 'waitlist_text' => array('name' => 'waitlist_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Waitlist Text'), 'description' => 'Text to display when the event is full, but participants can signup for a waitlist.', 'rows' => 4, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'approval_req_text' => array('name' => 'approval_req_text', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Approval Req Text'), 'description' => 'Text to display when the approval is required to complete registration for an event.', 'rows' => 4, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'is_template' => array('name' => 'is_template', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is an Event Template'), 'description' => 'whether the event has template', 'required' => true, 'html' => array('type' => 'CheckBox')), 'template_title' => array('name' => 'template_title', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Event Template Title'), 'description' => 'Event Template Title', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_event.template_title', 'headerPattern' => '/(template.)?title$/i', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'created_id' => array('name' => 'created_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Created By Contact ID'), 'description' => 'FK to civicrm_contact, who created this event', 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'created_date' => array('name' => 'created_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Event Created Date'), 'description' => 'Date and time that event was created.'), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Currency'), 'description' => '3 character string, value from config setting or input via user.', 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'import' => true, 'where' => 'civicrm_event.currency', 'headerPattern' => '/cur(rency)?/i', 'dataPattern' => '/^[A-Z]{3}$/i', 'export' => true, 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'numeric_code')), 'campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign'), 'description' => 'The campaign for which this event has been created.', 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'html' => array('type' => 'Autocomplete-Select'), 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')), 'is_share' => array('name' => 'is_share', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is shared through social media'), 'description' => 'Can people share the event through social media?', 'default' => '1', 'html' => array('type' => 'CheckBox')), 'is_confirm_enabled' => array('name' => 'is_confirm_enabled', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is the booking confirmation screen enabled?'), 'description' => 'If false, the event booking confirmation screen gets skipped', 'default' => '1', 'html' => array('type' => 'CheckBox')), 'parent_event_id' => array('name' => 'parent_event_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Parent Event ID'), 'description' => 'Implicit FK to civicrm_event: parent event', 'default' => 'NULL', 'html' => array('type' => 'Autocomplete-Select')), 'slot_label_id' => array('name' => 'slot_label_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Subevent Slot Label ID'), 'description' => 'Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.', 'default' => 'NULL', 'html' => array('type' => 'Select')), 'dedupe_rule_group_id' => array('name' => 'dedupe_rule_group_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Dedupe Rule'), 'description' => 'Rule to use when matching registrations for this event', 'default' => 'NULL', 'FKClassName' => 'CRM_Dedupe_DAO_RuleGroup', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_dedupe_rule_group', 'keyColumn' => 'id', 'labelColumn' => 'title', 'nameColumn' => 'name')), 'is_billing_required' => array('name' => 'is_billing_required', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Is billing block required'), 'description' => 'if true than billing block is required this event', 'html' => array('type' => 'CheckBox')));
}
return self::$_fields;
}
