Example #1
0
 /**
  * Returns all the column names of this table
  *
  * @return array
  */
 static function &fields()
 {
     if (!self::$_fields) {
         self::$_fields = array('pledge_payment_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge_payment.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_id' => array('name' => 'pledge_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge'), 'description' => 'FK to Pledge table', 'required' => true, 'FKClassName' => 'CRM_Pledge_DAO_Pledge'), 'contribution_id' => array('name' => 'contribution_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contribution'), 'description' => 'FK to contribution table.', 'FKClassName' => 'CRM_Contribute_DAO_Contribution'), 'pledge_payment_scheduled_amount' => array('name' => 'scheduled_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Scheduled Amount'), 'description' => 'Pledged amount for this payment (the actual contribution amount might be different).', 'required' => true, 'precision' => array(20, 2), 'import' => true, 'where' => 'civicrm_pledge_payment.scheduled_amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_actual_amount' => array('name' => 'actual_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Actual Amount'), 'description' => 'Actual amount that is paid as the Pledged installment amount.', 'precision' => array(20, 2), 'import' => true, 'where' => 'civicrm_pledge_payment.actual_amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), '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, 'default' => 'NULL', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'numeric_code')), 'pledge_payment_scheduled_date' => array('name' => 'scheduled_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Scheduled Date'), 'description' => 'The date the pledge payment is supposed to happen.', 'required' => true, 'import' => true, 'where' => 'civicrm_pledge_payment.scheduled_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_reminder_date' => array('name' => 'reminder_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Last Reminder'), 'description' => 'The date that the most recent payment reminder was sent.', 'import' => true, 'where' => 'civicrm_pledge_payment.reminder_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_reminder_count' => array('name' => 'reminder_count', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Reminders Sent'), 'description' => 'The number of payment reminders sent.', 'import' => true, 'where' => 'civicrm_pledge_payment.reminder_count', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Status'), 'import' => true, 'where' => 'civicrm_pledge_payment.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false));
     }
     return self::$_fields;
 }
 /**
  * returns all the column names of this table
  *
  * @access public
  * @return array
  */
 static function &fields()
 {
     if (!self::$_fields) {
         self::$_fields = array('pledge_payment_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge_payment.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_id' => array('name' => 'pledge_id', 'type' => CRM_Utils_Type::T_INT, 'required' => true, 'FKClassName' => 'CRM_Pledge_DAO_Pledge'), 'contribution_id' => array('name' => 'contribution_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contribute_DAO_Contribution'), 'pledge_payment_scheduled_amount' => array('name' => 'scheduled_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Scheduled Amount'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge_payment.scheduled_amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_actual_amount' => array('name' => 'actual_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Actual Amount'), 'import' => true, 'where' => 'civicrm_pledge_payment.actual_amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Currency'), 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'default' => 'UL'), 'pledge_payment_scheduled_date' => array('name' => 'scheduled_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Scheduled Date'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge_payment.scheduled_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_reminder_date' => array('name' => 'reminder_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Last Reminder'), 'import' => true, 'where' => 'civicrm_pledge_payment.reminder_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_reminder_count' => array('name' => 'reminder_count', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Reminders Sent'), 'import' => true, 'where' => 'civicrm_pledge_payment.reminder_count', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_payment_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Payment Status'), 'import' => true, 'where' => 'civicrm_pledge_payment.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false));
     }
     return self::$_fields;
 }