CRM/Event/DAO/Participant.php

   1 <?php
   2
   3 /**
   4  * @package CRM
   5  * @copyright CiviCRM LLC (c) 2004-2018
   6  *
   7  * Generated from xml/schema/CRM/Event/Participant.xml
   8  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
   9  * (GenCodeChecksum:2fe76154a50c0317faace43c47c3456a)
  10  */
  11
  12 /**
  13  * Database access object for the Participant entity.
  14  */
  15 class CRM_Event_DAO_Participant extends CRM_Core_DAO {
  16
  17   /**
  18    * Static instance to hold the table name.
  19    *
  20    * @var string
  21    */
  22   static $_tableName = 'civicrm_participant';
  23
  24   /**
  25    * Should CiviCRM log any modifications to this table in the civicrm_log table.
  26    *
  27    * @var bool
  28    */
  29   static $_log = TRUE;
  30
  31   /**
  32    * Participant Id
  33    *
  34    * @var int unsigned
  35    */
  36   public $id;
  37
  38   /**
  39    * FK to Contact ID
  40    *
  41    * @var int unsigned
  42    */
  43   public $contact_id;
  44
  45   /**
  46    * FK to Event ID
  47    *
  48    * @var int unsigned
  49    */
  50   public $event_id;
  51
  52   /**
  53    * Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = Registered.
  54    *
  55    * @var int unsigned
  56    */
  57   public $status_id;
  58
  59   /**
  60    * Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.
  61    *
  62    * @var string
  63    */
  64   public $role_id;
  65
  66   /**
  67    * When did contact register for event?
  68    *
  69    * @var datetime
  70    */
  71   public $register_date;
  72
  73   /**
  74    * Source of this event registration.
  75    *
  76    * @var string
  77    */
  78   public $source;
  79
  80   /**
  81    * Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that
  82    we store the label value and not the key
  83    *
  84    * @var text
  85    */
  86   public $fee_level;
  87
  88   /**
  89    * @var boolean
  90    */
  91   public $is_test;
  92
  93   /**
  94    * @var boolean
  95    */
  96   public $is_pay_later;
  97
  98   /**
  99    * actual processor fee if known - may be 0.
 100    *
 101    * @var float
 102    */
 103   public $fee_amount;
 104
 105   /**
 106    * FK to Participant ID
 107    *
 108    * @var int unsigned
 109    */
 110   public $registered_by_id;
 111
 112   /**
 113    * FK to Discount ID
 114    *
 115    * @var int unsigned
 116    */
 117   public $discount_id;
 118
 119   /**
 120    * 3 character string, value derived from config setting.
 121    *
 122    * @var string
 123    */
 124   public $fee_currency;
 125
 126   /**
 127    * The campaign for which this participant has been registered.
 128    *
 129    * @var int unsigned
 130    */
 131   public $campaign_id;
 132
 133   /**
 134    * Discount Amount
 135    *
 136    * @var int unsigned
 137    */
 138   public $discount_amount;
 139
 140   /**
 141    * FK to civicrm_event_carts
 142    *
 143    * @var int unsigned
 144    */
 145   public $cart_id;
 146
 147   /**
 148    * On Waiting List
 149    *
 150    * @var int
 151    */
 152   public $must_wait;
 153
 154   /**
 155    * FK to Contact ID
 156    *
 157    * @var int unsigned
 158    */
 159   public $transferred_to_contact_id;
 160
 161   /**
 162    * Class constructor.
 163    */
 164   public function __construct() {
 165     $this->__table = 'civicrm_participant';
 166     parent::__construct();
 167   }
 168
 169   /**
 170    * Returns foreign keys and entity references.
 171    *
 172    * @return array
 173    *   [CRM_Core_Reference_Interface]
 174    */
 175   public static function getReferenceColumns() {
 176     if (!isset(Civi::$statics[__CLASS__]['links'])) {
 177       Civi::$statics[__CLASS__]['links'] = static ::createReferenceColumns(__CLASS__);
 178       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'contact_id', 'civicrm_contact', 'id');
 179       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'event_id', 'civicrm_event', 'id');
 180       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'status_id', 'civicrm_participant_status_type', 'id');
 181       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'registered_by_id', 'civicrm_participant', 'id');
 182       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'discount_id', 'civicrm_discount', 'id');
 183       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
 184       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'cart_id', 'civicrm_event_carts', 'id');
 185       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'transferred_to_contact_id', 'civicrm_contact', 'id');
 186       CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
 187     }
 188     return Civi::$statics[__CLASS__]['links'];
 189   }
 190
 191   /**
 192    * Returns all the column names of this table
 193    *
 194    * @return array
 195    */
 196   public static function &fields() {
 197     if (!isset(Civi::$statics[__CLASS__]['fields'])) {
 198       Civi::$statics[__CLASS__]['fields'] = [
 199         'participant_id' => [
 200           'name' => 'id',
 201           'type' => CRM_Utils_Type::T_INT,
 202           'title' => ts('Participant ID'),
 203           'description' => ts('Participant Id'),
 204           'required' => TRUE,
 205           'import' => TRUE,
 206           'where' => 'civicrm_participant.id',
 207           'headerPattern' => '/(^(participant(.)?)?id$)/i',
 208           'dataPattern' => '',
 209           'export' => TRUE,
 210           'table_name' => 'civicrm_participant',
 211           'entity' => 'Participant',
 212           'bao' => 'CRM_Event_BAO_Participant',
 213           'localizable' => 0,
 214         ],
 215         'participant_contact_id' => [
 216           'name' => 'contact_id',
 217           'type' => CRM_Utils_Type::T_INT,
 218           'title' => ts('Contact ID'),
 219           'description' => ts('FK to Contact ID'),
 220           'required' => TRUE,
 221           'import' => TRUE,
 222           'where' => 'civicrm_participant.contact_id',
 223           'headerPattern' => '/contact(.?id)?/i',
 224           'dataPattern' => '',
 225           'export' => TRUE,
 226           'table_name' => 'civicrm_participant',
 227           'entity' => 'Participant',
 228           'bao' => 'CRM_Event_BAO_Participant',
 229           'localizable' => 0,
 230           'FKClassName' => 'CRM_Contact_DAO_Contact',
 231         ],
 232         'event_id' => [
 233           'name' => 'event_id',
 234           'type' => CRM_Utils_Type::T_INT,
 235           'title' => ts('Event'),
 236           'description' => ts('FK to Event ID'),
 237           'required' => TRUE,
 238           'import' => TRUE,
 239           'where' => 'civicrm_participant.event_id',
 240           'headerPattern' => '/event id$/i',
 241           'dataPattern' => '',
 242           'export' => TRUE,
 243           'table_name' => 'civicrm_participant',
 244           'entity' => 'Participant',
 245           'bao' => 'CRM_Event_BAO_Participant',
 246           'localizable' => 0,
 247           'FKClassName' => 'CRM_Event_DAO_Event',
 248         ],
 249         'participant_status_id' => [
 250           'name' => 'status_id',
 251           'type' => CRM_Utils_Type::T_INT,
 252           'title' => ts('Participant Status'),
 253           'description' => ts('Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = Registered.'),
 254           'required' => TRUE,
 255           'import' => TRUE,
 256           'where' => 'civicrm_participant.status_id',
 257           'headerPattern' => '/(participant.)?(status)$/i',
 258           'dataPattern' => '',
 259           'export' => TRUE,
 260           'default' => '1',
 261           'table_name' => 'civicrm_participant',
 262           'entity' => 'Participant',
 263           'bao' => 'CRM_Event_BAO_Participant',
 264           'localizable' => 0,
 265           'FKClassName' => 'CRM_Event_DAO_ParticipantStatusType',
 266           'html' => [
 267             'type' => 'Select',
 268           ],
 269           'pseudoconstant' => [
 270             'table' => 'civicrm_participant_status_type',
 271             'keyColumn' => 'id',
 272             'labelColumn' => 'label',
 273           ]
 274         ],
 275         'participant_role_id' => [
 276           'name' => 'role_id',
 277           'type' => CRM_Utils_Type::T_STRING,
 278           'title' => ts('Participant Role'),
 279           'description' => ts('Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.'),
 280           'maxlength' => 128,
 281           'size' => CRM_Utils_Type::HUGE,
 282           'import' => TRUE,
 283           'where' => 'civicrm_participant.role_id',
 284           'headerPattern' => '/(participant.)?(role)$/i',
 285           'dataPattern' => '',
 286           'export' => TRUE,
 287           'default' => 'NULL',
 288           'table_name' => 'civicrm_participant',
 289           'entity' => 'Participant',
 290           'bao' => 'CRM_Event_BAO_Participant',
 291           'localizable' => 0,
 292           'serialize' => self::SERIALIZE_SEPARATOR_TRIMMED,
 293           'html' => [
 294             'type' => 'Select',
 295           ],
 296           'pseudoconstant' => [
 297             'optionGroupName' => 'participant_role',
 298             'optionEditPath' => 'civicrm/admin/options/participant_role',
 299           ]
 300         ],
 301         'participant_register_date' => [
 302           'name' => 'register_date',
 303           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 304           'title' => ts('Register date'),
 305           'description' => ts('When did contact register for event?'),
 306           'import' => TRUE,
 307           'where' => 'civicrm_participant.register_date',
 308           'headerPattern' => '/^(r(egister\s)?date)$/i',
 309           'dataPattern' => '',
 310           'export' => TRUE,
 311           'table_name' => 'civicrm_participant',
 312           'entity' => 'Participant',
 313           'bao' => 'CRM_Event_BAO_Participant',
 314           'localizable' => 0,
 315           'html' => [
 316             'type' => 'Select Date',
 317             'formatType' => 'activityDateTime',
 318           ],
 319         ],
 320         'participant_source' => [
 321           'name' => 'source',
 322           'type' => CRM_Utils_Type::T_STRING,
 323           'title' => ts('Participant Source'),
 324           'description' => ts('Source of this event registration.'),
 325           'maxlength' => 128,
 326           'size' => CRM_Utils_Type::HUGE,
 327           'import' => TRUE,
 328           'where' => 'civicrm_participant.source',
 329           'headerPattern' => '/(participant.)?(source)$/i',
 330           'dataPattern' => '',
 331           'export' => TRUE,
 332           'table_name' => 'civicrm_participant',
 333           'entity' => 'Participant',
 334           'bao' => 'CRM_Event_BAO_Participant',
 335           'localizable' => 0,
 336           'html' => [
 337             'type' => 'Text',
 338           ],
 339         ],
 340         'participant_fee_level' => [
 341           'name' => 'fee_level',
 342           'type' => CRM_Utils_Type::T_TEXT,
 343           'title' => ts('Fee level'),
 344           'description' => ts('Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that
 345       we store the label value and not the key
 346     '),
 347           'import' => TRUE,
 348           'where' => 'civicrm_participant.fee_level',
 349           'headerPattern' => '/^(f(ee\s)?level)$/i',
 350           'dataPattern' => '',
 351           'export' => TRUE,
 352           'table_name' => 'civicrm_participant',
 353           'entity' => 'Participant',
 354           'bao' => 'CRM_Event_BAO_Participant',
 355           'localizable' => 0,
 356           'serialize' => self::SERIALIZE_SEPARATOR_BOOKEND,
 357         ],
 358         'participant_is_test' => [
 359           'name' => 'is_test',
 360           'type' => CRM_Utils_Type::T_BOOLEAN,
 361           'title' => ts('Test'),
 362           'import' => TRUE,
 363           'where' => 'civicrm_participant.is_test',
 364           'headerPattern' => '',
 365           'dataPattern' => '',
 366           'export' => TRUE,
 367           'default' => '0',
 368           'table_name' => 'civicrm_participant',
 369           'entity' => 'Participant',
 370           'bao' => 'CRM_Event_BAO_Participant',
 371           'localizable' => 0,
 372         ],
 373         'participant_is_pay_later' => [
 374           'name' => 'is_pay_later',
 375           'type' => CRM_Utils_Type::T_BOOLEAN,
 376           'title' => ts('Is Pay Later'),
 377           'import' => TRUE,
 378           'where' => 'civicrm_participant.is_pay_later',
 379           'headerPattern' => '/(is.)?(pay(.)?later)$/i',
 380           'dataPattern' => '',
 381           'export' => TRUE,
 382           'default' => '0',
 383           'table_name' => 'civicrm_participant',
 384           'entity' => 'Participant',
 385           'bao' => 'CRM_Event_BAO_Participant',
 386           'localizable' => 0,
 387         ],
 388         'participant_fee_amount' => [
 389           'name' => 'fee_amount',
 390           'type' => CRM_Utils_Type::T_MONEY,
 391           'title' => ts('Fee Amount'),
 392           'description' => ts('actual processor fee if known - may be 0.'),
 393           'precision' => [
 394             20,
 395             2
 396           ],
 397           'import' => TRUE,
 398           'where' => 'civicrm_participant.fee_amount',
 399           'headerPattern' => '/fee(.?am(ou)?nt)?/i',
 400           'dataPattern' => '/^\d+(\.\d{2})?$/',
 401           'export' => TRUE,
 402           'table_name' => 'civicrm_participant',
 403           'entity' => 'Participant',
 404           'bao' => 'CRM_Event_BAO_Participant',
 405           'localizable' => 0,
 406         ],
 407         'participant_registered_by_id' => [
 408           'name' => 'registered_by_id',
 409           'type' => CRM_Utils_Type::T_INT,
 410           'title' => ts('Registered By ID'),
 411           'description' => ts('FK to Participant ID'),
 412           'import' => TRUE,
 413           'where' => 'civicrm_participant.registered_by_id',
 414           'headerPattern' => '',
 415           'dataPattern' => '',
 416           'export' => TRUE,
 417           'default' => 'NULL',
 418           'table_name' => 'civicrm_participant',
 419           'entity' => 'Participant',
 420           'bao' => 'CRM_Event_BAO_Participant',
 421           'localizable' => 0,
 422           'FKClassName' => 'CRM_Event_DAO_Participant',
 423         ],
 424         'participant_discount_id' => [
 425           'name' => 'discount_id',
 426           'type' => CRM_Utils_Type::T_INT,
 427           'title' => ts('Discount ID'),
 428           'description' => ts('FK to Discount ID'),
 429           'default' => 'NULL',
 430           'table_name' => 'civicrm_participant',
 431           'entity' => 'Participant',
 432           'bao' => 'CRM_Event_BAO_Participant',
 433           'localizable' => 0,
 434           'FKClassName' => 'CRM_Core_DAO_Discount',
 435         ],
 436         'participant_fee_currency' => [
 437           'name' => 'fee_currency',
 438           'type' => CRM_Utils_Type::T_STRING,
 439           'title' => ts('Fee Currency'),
 440           'description' => ts('3 character string, value derived from config setting.'),
 441           'maxlength' => 3,
 442           'size' => CRM_Utils_Type::FOUR,
 443           'import' => TRUE,
 444           'where' => 'civicrm_participant.fee_currency',
 445           'headerPattern' => '/(fee)?.?cur(rency)?/i',
 446           'dataPattern' => '/^[A-Z]{3}$/i',
 447           'export' => TRUE,
 448           'default' => 'NULL',
 449           'table_name' => 'civicrm_participant',
 450           'entity' => 'Participant',
 451           'bao' => 'CRM_Event_BAO_Participant',
 452           'localizable' => 0,
 453           'html' => [
 454             'type' => 'Select',
 455           ],
 456           'pseudoconstant' => [
 457             'table' => 'civicrm_currency',
 458             'keyColumn' => 'name',
 459             'labelColumn' => 'full_name',
 460             'nameColumn' => 'name',
 461           ]
 462         ],
 463         'participant_campaign_id' => [
 464           'name' => 'campaign_id',
 465           'type' => CRM_Utils_Type::T_INT,
 466           'title' => ts('Campaign'),
 467           'description' => ts('The campaign for which this participant has been registered.'),
 468           'import' => TRUE,
 469           'where' => 'civicrm_participant.campaign_id',
 470           'headerPattern' => '',
 471           'dataPattern' => '',
 472           'export' => TRUE,
 473           'table_name' => 'civicrm_participant',
 474           'entity' => 'Participant',
 475           'bao' => 'CRM_Event_BAO_Participant',
 476           'localizable' => 0,
 477           'FKClassName' => 'CRM_Campaign_DAO_Campaign',
 478           'pseudoconstant' => [
 479             'table' => 'civicrm_campaign',
 480             'keyColumn' => 'id',
 481             'labelColumn' => 'title',
 482           ]
 483         ],
 484         'discount_amount' => [
 485           'name' => 'discount_amount',
 486           'type' => CRM_Utils_Type::T_INT,
 487           'title' => ts('Discount Amount'),
 488           'description' => ts('Discount Amount'),
 489           'table_name' => 'civicrm_participant',
 490           'entity' => 'Participant',
 491           'bao' => 'CRM_Event_BAO_Participant',
 492           'localizable' => 0,
 493         ],
 494         'cart_id' => [
 495           'name' => 'cart_id',
 496           'type' => CRM_Utils_Type::T_INT,
 497           'title' => ts('Event Cart ID'),
 498           'description' => ts('FK to civicrm_event_carts'),
 499           'table_name' => 'civicrm_participant',
 500           'entity' => 'Participant',
 501           'bao' => 'CRM_Event_BAO_Participant',
 502           'localizable' => 0,
 503           'FKClassName' => 'CRM_Event_Cart_DAO_Cart',
 504         ],
 505         'must_wait' => [
 506           'name' => 'must_wait',
 507           'type' => CRM_Utils_Type::T_INT,
 508           'title' => ts('Must Wait on List'),
 509           'description' => ts('On Waiting List'),
 510           'table_name' => 'civicrm_participant',
 511           'entity' => 'Participant',
 512           'bao' => 'CRM_Event_BAO_Participant',
 513           'localizable' => 0,
 514         ],
 515         'transferred_to_contact_id' => [
 516           'name' => 'transferred_to_contact_id',
 517           'type' => CRM_Utils_Type::T_INT,
 518           'title' => ts('Transferred to Contact ID'),
 519           'description' => ts('FK to Contact ID'),
 520           'import' => TRUE,
 521           'where' => 'civicrm_participant.transferred_to_contact_id',
 522           'headerPattern' => '/transfer(.?id)?/i',
 523           'dataPattern' => '',
 524           'export' => TRUE,
 525           'default' => 'NULL',
 526           'table_name' => 'civicrm_participant',
 527           'entity' => 'Participant',
 528           'bao' => 'CRM_Event_BAO_Participant',
 529           'localizable' => 0,
 530           'FKClassName' => 'CRM_Contact_DAO_Contact',
 531         ],
 532       ];
 533       CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
 534     }
 535     return Civi::$statics[__CLASS__]['fields'];
 536   }
 537
 538   /**
 539    * Return a mapping from field-name to the corresponding key (as used in fields()).
 540    *
 541    * @return array
 542    *   Array(string $name => string $uniqueName).
 543    */
 544   public static function &fieldKeys() {
 545     if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
 546       Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
 547     }
 548     return Civi::$statics[__CLASS__]['fieldKeys'];
 549   }
 550
 551   /**
 552    * Returns the names of this table
 553    *
 554    * @return string
 555    */
 556   public static function getTableName() {
 557     return self::$_tableName;
 558   }
 559
 560   /**
 561    * Returns if this table needs to be logged
 562    *
 563    * @return bool
 564    */
 565   public function getLog() {
 566     return self::$_log;
 567   }
 568
 569   /**
 570    * Returns the list of fields that can be imported
 571    *
 572    * @param bool $prefix
 573    *
 574    * @return array
 575    */
 576   public static function &import($prefix = FALSE) {
 577     $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'participant', $prefix, []);
 578     return $r;
 579   }
 580
 581   /**
 582    * Returns the list of fields that can be exported
 583    *
 584    * @param bool $prefix
 585    *
 586    * @return array
 587    */
 588   public static function &export($prefix = FALSE) {
 589     $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'participant', $prefix, []);
 590     return $r;
 591   }
 592
 593   /**
 594    * Returns the list of indices
 595    *
 596    * @param bool $localize
 597    *
 598    * @return array
 599    */
 600   public static function indices($localize = TRUE) {
 601     $indices = [
 602       'index_status_id' => [
 603         'name' => 'index_status_id',
 604         'field' => [
 605           0 => 'status_id',
 606         ],
 607         'localizable' => FALSE,
 608         'sig' => 'civicrm_participant::0::status_id',
 609       ],
 610       'index_role_id' => [
 611         'name' => 'index_role_id',
 612         'field' => [
 613           0 => 'role_id',
 614         ],
 615         'localizable' => FALSE,
 616         'sig' => 'civicrm_participant::0::role_id',
 617       ],
 618     ];
 619     return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
 620   }
 621
 622 }