CRM/Pledge/DAO/Pledge.php

   1 <?php
   2
   3 /**
   4  * @package CRM
   5  * @copyright CiviCRM LLC https://civicrm.org/licensing
   6  *
   7  * Generated from xml/schema/CRM/Pledge/Pledge.xml
   8  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
   9  * (GenCodeChecksum:237bb1983467d1d8ce0f3c77eacc8f93)
  10  */
  11
  12 /**
  13  * Database access object for the Pledge entity.
  14  */
  15 class CRM_Pledge_DAO_Pledge extends CRM_Core_DAO {
  16   const EXT = 'civicrm';
  17   const TABLE_ADDED = '2.1';
  18   const COMPONENT = 'CiviPledge';
  19
  20   /**
  21    * Static instance to hold the table name.
  22    *
  23    * @var string
  24    */
  25   public static $_tableName = 'civicrm_pledge';
  26
  27   /**
  28    * Icon associated with this entity.
  29    *
  30    * @var string
  31    */
  32   public static $_icon = 'fa-paper-plane';
  33
  34   /**
  35    * Should CiviCRM log any modifications to this table in the civicrm_log table.
  36    *
  37    * @var bool
  38    */
  39   public static $_log = TRUE;
  40
  41   /**
  42    * Pledge ID
  43    *
  44    * @var int
  45    */
  46   public $id;
  47
  48   /**
  49    * Foreign key to civicrm_contact.id .
  50    *
  51    * @var int
  52    */
  53   public $contact_id;
  54
  55   /**
  56    * FK to Financial Type
  57    *
  58    * @var int
  59    */
  60   public $financial_type_id;
  61
  62   /**
  63    * The Contribution Page which triggered this contribution
  64    *
  65    * @var int
  66    */
  67   public $contribution_page_id;
  68
  69   /**
  70    * Total pledged amount.
  71    *
  72    * @var float
  73    */
  74   public $amount;
  75
  76   /**
  77    * Original amount for each of the installments.
  78    *
  79    * @var float
  80    */
  81   public $original_installment_amount;
  82
  83   /**
  84    * 3 character string, value from config setting or input via user.
  85    *
  86    * @var string
  87    */
  88   public $currency;
  89
  90   /**
  91    * Time units for recurrence of pledge payments.
  92    *
  93    * @var string
  94    */
  95   public $frequency_unit;
  96
  97   /**
  98    * Number of time units for recurrence of pledge payments.
  99    *
 100    * @var int
 101    */
 102   public $frequency_interval;
 103
 104   /**
 105    * Day in the period when the pledge payment is due e.g. 1st of month, 15th etc. Use this to set the scheduled dates for pledge payments.
 106    *
 107    * @var int
 108    */
 109   public $frequency_day;
 110
 111   /**
 112    * Total number of payments to be made.
 113    *
 114    * @var int
 115    */
 116   public $installments;
 117
 118   /**
 119    * The date the first scheduled pledge occurs.
 120    *
 121    * @var datetime
 122    */
 123   public $start_date;
 124
 125   /**
 126    * When this pledge record was created.
 127    *
 128    * @var datetime
 129    */
 130   public $create_date;
 131
 132   /**
 133    * When a pledge acknowledgement message was sent to the contributor.
 134    *
 135    * @var datetime
 136    */
 137   public $acknowledge_date;
 138
 139   /**
 140    * Last updated date for this pledge record.
 141    *
 142    * @var datetime
 143    */
 144   public $modified_date;
 145
 146   /**
 147    * Date this pledge was cancelled by contributor.
 148    *
 149    * @var datetime
 150    */
 151   public $cancel_date;
 152
 153   /**
 154    * Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).
 155    *
 156    * @var datetime
 157    */
 158   public $end_date;
 159
 160   /**
 161    * The maximum number of payment reminders to send for any given payment.
 162    *
 163    * @var int
 164    */
 165   public $max_reminders;
 166
 167   /**
 168    * Send initial reminder this many days prior to the payment due date.
 169    *
 170    * @var int
 171    */
 172   public $initial_reminder_day;
 173
 174   /**
 175    * Send additional reminder this many days after last one sent, up to maximum number of reminders.
 176    *
 177    * @var int
 178    */
 179   public $additional_reminder_day;
 180
 181   /**
 182    * Implicit foreign key to civicrm_option_values in the pledge_status option group.
 183    *
 184    * @var int
 185    */
 186   public $status_id;
 187
 188   /**
 189    * @var bool
 190    */
 191   public $is_test;
 192
 193   /**
 194    * The campaign for which this pledge has been initiated.
 195    *
 196    * @var int
 197    */
 198   public $campaign_id;
 199
 200   /**
 201    * Class constructor.
 202    */
 203   public function __construct() {
 204     $this->__table = 'civicrm_pledge';
 205     parent::__construct();
 206   }
 207
 208   /**
 209    * Returns localized title of this entity.
 210    *
 211    * @param bool $plural
 212    *   Whether to return the plural version of the title.
 213    */
 214   public static function getEntityTitle($plural = FALSE) {
 215     return $plural ? ts('Pledges') : ts('Pledge');
 216   }
 217
 218   /**
 219    * Returns foreign keys and entity references.
 220    *
 221    * @return array
 222    *   [CRM_Core_Reference_Interface]
 223    */
 224   public static function getReferenceColumns() {
 225     if (!isset(Civi::$statics[__CLASS__]['links'])) {
 226       Civi::$statics[__CLASS__]['links'] = static::createReferenceColumns(__CLASS__);
 227       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'contact_id', 'civicrm_contact', 'id');
 228       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'financial_type_id', 'civicrm_financial_type', 'id');
 229       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'contribution_page_id', 'civicrm_contribution_page', 'id');
 230       Civi::$statics[__CLASS__]['links'][] = new CRM_Core_Reference_Basic(self::getTableName(), 'campaign_id', 'civicrm_campaign', 'id');
 231       CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'links_callback', Civi::$statics[__CLASS__]['links']);
 232     }
 233     return Civi::$statics[__CLASS__]['links'];
 234   }
 235
 236   /**
 237    * Returns all the column names of this table
 238    *
 239    * @return array
 240    */
 241   public static function &fields() {
 242     if (!isset(Civi::$statics[__CLASS__]['fields'])) {
 243       Civi::$statics[__CLASS__]['fields'] = [
 244         'pledge_id' => [
 245           'name' => 'id',
 246           'type' => CRM_Utils_Type::T_INT,
 247           'title' => ts('Pledge ID'),
 248           'description' => ts('Pledge ID'),
 249           'required' => TRUE,
 250           'import' => TRUE,
 251           'where' => 'civicrm_pledge.id',
 252           'export' => TRUE,
 253           'table_name' => 'civicrm_pledge',
 254           'entity' => 'Pledge',
 255           'bao' => 'CRM_Pledge_BAO_Pledge',
 256           'localizable' => 0,
 257           'html' => [
 258             'type' => 'Number',
 259           ],
 260           'add' => '2.1',
 261         ],
 262         'pledge_contact_id' => [
 263           'name' => 'contact_id',
 264           'type' => CRM_Utils_Type::T_INT,
 265           'title' => ts('Contact ID'),
 266           'description' => ts('Foreign key to civicrm_contact.id .'),
 267           'required' => TRUE,
 268           'import' => TRUE,
 269           'where' => 'civicrm_pledge.contact_id',
 270           'export' => TRUE,
 271           'table_name' => 'civicrm_pledge',
 272           'entity' => 'Pledge',
 273           'bao' => 'CRM_Pledge_BAO_Pledge',
 274           'localizable' => 0,
 275           'FKClassName' => 'CRM_Contact_DAO_Contact',
 276           'html' => [
 277             'type' => 'EntityRef',
 278             'label' => ts("Contact"),
 279           ],
 280           'add' => '2.1',
 281         ],
 282         'pledge_financial_type_id' => [
 283           'name' => 'financial_type_id',
 284           'type' => CRM_Utils_Type::T_INT,
 285           'title' => ts('Financial Type ID'),
 286           'description' => ts('FK to Financial Type'),
 287           'where' => 'civicrm_pledge.financial_type_id',
 288           'table_name' => 'civicrm_pledge',
 289           'entity' => 'Pledge',
 290           'bao' => 'CRM_Pledge_BAO_Pledge',
 291           'localizable' => 0,
 292           'FKClassName' => 'CRM_Financial_DAO_FinancialType',
 293           'html' => [
 294             'type' => 'Select',
 295             'label' => ts("Financial Type"),
 296           ],
 297           'pseudoconstant' => [
 298             'table' => 'civicrm_financial_type',
 299             'keyColumn' => 'id',
 300             'labelColumn' => 'name',
 301           ],
 302           'add' => '4.3',
 303         ],
 304         'pledge_contribution_page_id' => [
 305           'name' => 'contribution_page_id',
 306           'type' => CRM_Utils_Type::T_INT,
 307           'title' => ts('Contribution Page ID'),
 308           'description' => ts('The Contribution Page which triggered this contribution'),
 309           'where' => 'civicrm_pledge.contribution_page_id',
 310           'table_name' => 'civicrm_pledge',
 311           'entity' => 'Pledge',
 312           'bao' => 'CRM_Pledge_BAO_Pledge',
 313           'localizable' => 0,
 314           'FKClassName' => 'CRM_Contribute_DAO_ContributionPage',
 315           'html' => [
 316             'label' => ts("Contribution Page"),
 317           ],
 318           'add' => '2.1',
 319         ],
 320         'pledge_amount' => [
 321           'name' => 'amount',
 322           'type' => CRM_Utils_Type::T_MONEY,
 323           'title' => ts('Total Pledged'),
 324           'description' => ts('Total pledged amount.'),
 325           'required' => TRUE,
 326           'precision' => [
 327             20,
 328             2,
 329           ],
 330           'import' => TRUE,
 331           'where' => 'civicrm_pledge.amount',
 332           'export' => TRUE,
 333           'table_name' => 'civicrm_pledge',
 334           'entity' => 'Pledge',
 335           'bao' => 'CRM_Pledge_BAO_Pledge',
 336           'localizable' => 0,
 337           'html' => [
 338             'type' => 'Text',
 339           ],
 340           'add' => '2.1',
 341         ],
 342         'pledge_original_installment_amount' => [
 343           'name' => 'original_installment_amount',
 344           'type' => CRM_Utils_Type::T_MONEY,
 345           'title' => ts('Original Installment Amount'),
 346           'description' => ts('Original amount for each of the installments.'),
 347           'required' => TRUE,
 348           'precision' => [
 349             20,
 350             2,
 351           ],
 352           'where' => 'civicrm_pledge.original_installment_amount',
 353           'export' => TRUE,
 354           'table_name' => 'civicrm_pledge',
 355           'entity' => 'Pledge',
 356           'bao' => 'CRM_Pledge_BAO_Pledge',
 357           'localizable' => 0,
 358           'html' => [
 359             'type' => 'Text',
 360           ],
 361           'add' => '3.2',
 362         ],
 363         'currency' => [
 364           'name' => 'currency',
 365           'type' => CRM_Utils_Type::T_STRING,
 366           'title' => ts('Pledge Currency'),
 367           'description' => ts('3 character string, value from config setting or input via user.'),
 368           'maxlength' => 3,
 369           'size' => CRM_Utils_Type::FOUR,
 370           'where' => 'civicrm_pledge.currency',
 371           'default' => 'NULL',
 372           'table_name' => 'civicrm_pledge',
 373           'entity' => 'Pledge',
 374           'bao' => 'CRM_Pledge_BAO_Pledge',
 375           'localizable' => 0,
 376           'html' => [
 377             'type' => 'Select',
 378           ],
 379           'pseudoconstant' => [
 380             'table' => 'civicrm_currency',
 381             'keyColumn' => 'name',
 382             'labelColumn' => 'full_name',
 383             'nameColumn' => 'name',
 384             'abbrColumn' => 'symbol',
 385           ],
 386           'add' => '3.2',
 387         ],
 388         'pledge_frequency_unit' => [
 389           'name' => 'frequency_unit',
 390           'type' => CRM_Utils_Type::T_STRING,
 391           'title' => ts('Pledge Frequency Unit'),
 392           'description' => ts('Time units for recurrence of pledge payments.'),
 393           'required' => TRUE,
 394           'maxlength' => 8,
 395           'size' => CRM_Utils_Type::EIGHT,
 396           'where' => 'civicrm_pledge.frequency_unit',
 397           'default' => 'month',
 398           'table_name' => 'civicrm_pledge',
 399           'entity' => 'Pledge',
 400           'bao' => 'CRM_Pledge_BAO_Pledge',
 401           'localizable' => 0,
 402           'html' => [
 403             'type' => 'Select',
 404           ],
 405           'pseudoconstant' => [
 406             'optionGroupName' => 'recur_frequency_units',
 407             'keyColumn' => 'name',
 408             'optionEditPath' => 'civicrm/admin/options/recur_frequency_units',
 409           ],
 410           'add' => '2.1',
 411         ],
 412         'pledge_frequency_interval' => [
 413           'name' => 'frequency_interval',
 414           'type' => CRM_Utils_Type::T_INT,
 415           'title' => ts('Pledge Frequency Interval'),
 416           'description' => ts('Number of time units for recurrence of pledge payments.'),
 417           'required' => TRUE,
 418           'where' => 'civicrm_pledge.frequency_interval',
 419           'default' => '1',
 420           'table_name' => 'civicrm_pledge',
 421           'entity' => 'Pledge',
 422           'bao' => 'CRM_Pledge_BAO_Pledge',
 423           'localizable' => 0,
 424           'html' => [
 425             'type' => 'Text',
 426           ],
 427           'add' => '2.1',
 428         ],
 429         'frequency_day' => [
 430           'name' => 'frequency_day',
 431           'type' => CRM_Utils_Type::T_INT,
 432           'title' => ts('Pledge day'),
 433           'description' => ts('Day in the period when the pledge payment is due e.g. 1st of month, 15th etc. Use this to set the scheduled dates for pledge payments.'),
 434           'required' => TRUE,
 435           'where' => 'civicrm_pledge.frequency_day',
 436           'default' => '3',
 437           'table_name' => 'civicrm_pledge',
 438           'entity' => 'Pledge',
 439           'bao' => 'CRM_Pledge_BAO_Pledge',
 440           'localizable' => 0,
 441           'html' => [
 442             'type' => 'Select',
 443           ],
 444           'add' => '2.1',
 445         ],
 446         'installments' => [
 447           'name' => 'installments',
 448           'type' => CRM_Utils_Type::T_INT,
 449           'title' => ts('Pledge Number of Installments'),
 450           'description' => ts('Total number of payments to be made.'),
 451           'required' => TRUE,
 452           'where' => 'civicrm_pledge.installments',
 453           'export' => TRUE,
 454           'default' => '1',
 455           'table_name' => 'civicrm_pledge',
 456           'entity' => 'Pledge',
 457           'bao' => 'CRM_Pledge_BAO_Pledge',
 458           'localizable' => 0,
 459           'html' => [
 460             'type' => 'Text',
 461           ],
 462           'add' => '2.1',
 463         ],
 464         'pledge_start_date' => [
 465           'name' => 'start_date',
 466           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 467           'title' => ts('Pledge Start Date'),
 468           'description' => ts('The date the first scheduled pledge occurs.'),
 469           'required' => TRUE,
 470           'where' => 'civicrm_pledge.start_date',
 471           'export' => TRUE,
 472           'table_name' => 'civicrm_pledge',
 473           'entity' => 'Pledge',
 474           'bao' => 'CRM_Pledge_BAO_Pledge',
 475           'localizable' => 0,
 476           'unique_title' => ts('Payments Start Date'),
 477           'html' => [
 478             'type' => 'Select Date',
 479             'formatType' => 'activityDate',
 480           ],
 481           'add' => '2.1',
 482         ],
 483         'pledge_create_date' => [
 484           'name' => 'create_date',
 485           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 486           'title' => ts('Pledge Made'),
 487           'description' => ts('When this pledge record was created.'),
 488           'required' => TRUE,
 489           'import' => TRUE,
 490           'where' => 'civicrm_pledge.create_date',
 491           'export' => TRUE,
 492           'table_name' => 'civicrm_pledge',
 493           'entity' => 'Pledge',
 494           'bao' => 'CRM_Pledge_BAO_Pledge',
 495           'localizable' => 0,
 496           'html' => [
 497             'type' => 'Select Date',
 498             'formatType' => 'activityDate',
 499           ],
 500           'add' => '2.1',
 501         ],
 502         'acknowledge_date' => [
 503           'name' => 'acknowledge_date',
 504           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 505           'title' => ts('Pledge Acknowledged'),
 506           'description' => ts('When a pledge acknowledgement message was sent to the contributor.'),
 507           'where' => 'civicrm_pledge.acknowledge_date',
 508           'table_name' => 'civicrm_pledge',
 509           'entity' => 'Pledge',
 510           'bao' => 'CRM_Pledge_BAO_Pledge',
 511           'localizable' => 0,
 512           'html' => [
 513             'type' => 'Select Date',
 514             'formatType' => 'activityDate',
 515           ],
 516           'add' => '2.1',
 517         ],
 518         'modified_date' => [
 519           'name' => 'modified_date',
 520           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 521           'title' => ts('Pledge Modified Date'),
 522           'description' => ts('Last updated date for this pledge record.'),
 523           'where' => 'civicrm_pledge.modified_date',
 524           'table_name' => 'civicrm_pledge',
 525           'entity' => 'Pledge',
 526           'bao' => 'CRM_Pledge_BAO_Pledge',
 527           'localizable' => 0,
 528           'add' => '2.1',
 529         ],
 530         'cancel_date' => [
 531           'name' => 'cancel_date',
 532           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 533           'title' => ts('Pledge Cancelled Date'),
 534           'description' => ts('Date this pledge was cancelled by contributor.'),
 535           'where' => 'civicrm_pledge.cancel_date',
 536           'table_name' => 'civicrm_pledge',
 537           'entity' => 'Pledge',
 538           'bao' => 'CRM_Pledge_BAO_Pledge',
 539           'localizable' => 0,
 540           'html' => [
 541             'type' => 'Select Date',
 542             'formatType' => 'activityDate',
 543           ],
 544           'add' => '2.1',
 545         ],
 546         'pledge_end_date' => [
 547           'name' => 'end_date',
 548           'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
 549           'title' => ts('Pledge End Date'),
 550           'description' => ts('Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).'),
 551           'where' => 'civicrm_pledge.end_date',
 552           'export' => TRUE,
 553           'table_name' => 'civicrm_pledge',
 554           'entity' => 'Pledge',
 555           'bao' => 'CRM_Pledge_BAO_Pledge',
 556           'localizable' => 0,
 557           'unique_title' => ts('Payments Ended Date'),
 558           'html' => [
 559             'type' => 'Select Date',
 560             'formatType' => 'activityDate',
 561           ],
 562           'add' => '2.1',
 563         ],
 564         'max_reminders' => [
 565           'name' => 'max_reminders',
 566           'type' => CRM_Utils_Type::T_INT,
 567           'title' => ts('Maximum Number of Reminders'),
 568           'description' => ts('The maximum number of payment reminders to send for any given payment.'),
 569           'where' => 'civicrm_pledge.max_reminders',
 570           'default' => '1',
 571           'table_name' => 'civicrm_pledge',
 572           'entity' => 'Pledge',
 573           'bao' => 'CRM_Pledge_BAO_Pledge',
 574           'localizable' => 0,
 575           'html' => [
 576             'type' => 'Text',
 577           ],
 578           'add' => '2.1',
 579         ],
 580         'initial_reminder_day' => [
 581           'name' => 'initial_reminder_day',
 582           'type' => CRM_Utils_Type::T_INT,
 583           'title' => ts('Initial Reminder Day'),
 584           'description' => ts('Send initial reminder this many days prior to the payment due date.'),
 585           'where' => 'civicrm_pledge.initial_reminder_day',
 586           'default' => '5',
 587           'table_name' => 'civicrm_pledge',
 588           'entity' => 'Pledge',
 589           'bao' => 'CRM_Pledge_BAO_Pledge',
 590           'localizable' => 0,
 591           'html' => [
 592             'type' => 'Select',
 593           ],
 594           'add' => '2.1',
 595         ],
 596         'additional_reminder_day' => [
 597           'name' => 'additional_reminder_day',
 598           'type' => CRM_Utils_Type::T_INT,
 599           'title' => ts('Additional Reminder Days'),
 600           'description' => ts('Send additional reminder this many days after last one sent, up to maximum number of reminders.'),
 601           'where' => 'civicrm_pledge.additional_reminder_day',
 602           'default' => '5',
 603           'table_name' => 'civicrm_pledge',
 604           'entity' => 'Pledge',
 605           'bao' => 'CRM_Pledge_BAO_Pledge',
 606           'localizable' => 0,
 607           'html' => [
 608             'type' => 'Text',
 609           ],
 610           'add' => '2.1',
 611         ],
 612         'pledge_status_id' => [
 613           'name' => 'status_id',
 614           'type' => CRM_Utils_Type::T_INT,
 615           'title' => ts('Pledge Status ID'),
 616           'description' => ts('Implicit foreign key to civicrm_option_values in the pledge_status option group.'),
 617           'required' => TRUE,
 618           'import' => TRUE,
 619           'where' => 'civicrm_pledge.status_id',
 620           'export' => FALSE,
 621           'table_name' => 'civicrm_pledge',
 622           'entity' => 'Pledge',
 623           'bao' => 'CRM_Pledge_BAO_Pledge',
 624           'localizable' => 0,
 625           'html' => [
 626             'type' => 'Select',
 627           ],
 628           'pseudoconstant' => [
 629             'optionGroupName' => 'pledge_status',
 630             'optionEditPath' => 'civicrm/admin/options/pledge_status',
 631           ],
 632           'add' => '2.1',
 633         ],
 634         'pledge_is_test' => [
 635           'name' => 'is_test',
 636           'type' => CRM_Utils_Type::T_BOOLEAN,
 637           'title' => ts('Test'),
 638           'required' => TRUE,
 639           'import' => TRUE,
 640           'where' => 'civicrm_pledge.is_test',
 641           'export' => TRUE,
 642           'default' => '0',
 643           'table_name' => 'civicrm_pledge',
 644           'entity' => 'Pledge',
 645           'bao' => 'CRM_Pledge_BAO_Pledge',
 646           'localizable' => 0,
 647           'html' => [
 648             'type' => 'CheckBox',
 649           ],
 650           'add' => NULL,
 651         ],
 652         'pledge_campaign_id' => [
 653           'name' => 'campaign_id',
 654           'type' => CRM_Utils_Type::T_INT,
 655           'title' => ts('Campaign ID'),
 656           'description' => ts('The campaign for which this pledge has been initiated.'),
 657           'import' => TRUE,
 658           'where' => 'civicrm_pledge.campaign_id',
 659           'export' => TRUE,
 660           'table_name' => 'civicrm_pledge',
 661           'entity' => 'Pledge',
 662           'bao' => 'CRM_Pledge_BAO_Pledge',
 663           'localizable' => 0,
 664           'FKClassName' => 'CRM_Campaign_DAO_Campaign',
 665           'html' => [
 666             'type' => 'Select',
 667             'label' => ts("Campaign"),
 668           ],
 669           'add' => '3.4',
 670         ],
 671       ];
 672       CRM_Core_DAO_AllCoreTables::invoke(__CLASS__, 'fields_callback', Civi::$statics[__CLASS__]['fields']);
 673     }
 674     return Civi::$statics[__CLASS__]['fields'];
 675   }
 676
 677   /**
 678    * Return a mapping from field-name to the corresponding key (as used in fields()).
 679    *
 680    * @return array
 681    *   Array(string $name => string $uniqueName).
 682    */
 683   public static function &fieldKeys() {
 684     if (!isset(Civi::$statics[__CLASS__]['fieldKeys'])) {
 685       Civi::$statics[__CLASS__]['fieldKeys'] = array_flip(CRM_Utils_Array::collect('name', self::fields()));
 686     }
 687     return Civi::$statics[__CLASS__]['fieldKeys'];
 688   }
 689
 690   /**
 691    * Returns the names of this table
 692    *
 693    * @return string
 694    */
 695   public static function getTableName() {
 696     return self::$_tableName;
 697   }
 698
 699   /**
 700    * Returns if this table needs to be logged
 701    *
 702    * @return bool
 703    */
 704   public function getLog() {
 705     return self::$_log;
 706   }
 707
 708   /**
 709    * Returns the list of fields that can be imported
 710    *
 711    * @param bool $prefix
 712    *
 713    * @return array
 714    */
 715   public static function &import($prefix = FALSE) {
 716     $r = CRM_Core_DAO_AllCoreTables::getImports(__CLASS__, 'pledge', $prefix, []);
 717     return $r;
 718   }
 719
 720   /**
 721    * Returns the list of fields that can be exported
 722    *
 723    * @param bool $prefix
 724    *
 725    * @return array
 726    */
 727   public static function &export($prefix = FALSE) {
 728     $r = CRM_Core_DAO_AllCoreTables::getExports(__CLASS__, 'pledge', $prefix, []);
 729     return $r;
 730   }
 731
 732   /**
 733    * Returns the list of indices
 734    *
 735    * @param bool $localize
 736    *
 737    * @return array
 738    */
 739   public static function indices($localize = TRUE) {
 740     $indices = [
 741       'index_status' => [
 742         'name' => 'index_status',
 743         'field' => [
 744           0 => 'status_id',
 745         ],
 746         'localizable' => FALSE,
 747         'sig' => 'civicrm_pledge::0::status_id',
 748       ],
 749     ];
 750     return ($localize && !empty($indices)) ? CRM_Core_DAO_AllCoreTables::multilingualize(__CLASS__, $indices) : $indices;
 751   }
 752
 753 }