/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('pledge_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.contact_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'pledge_financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Type'), 'FKClassName' => 'CRM_Financial_DAO_FinancialType'), 'pledge_contribution_page_id' => array('name' => 'contribution_page_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Contribution Page'), 'FKClassName' => 'CRM_Contribute_DAO_ContributionPage'), 'pledge_amount' => array('name' => 'amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Total Pledged'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_original_installment_amount' => array('name' => 'original_installment_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Original Installment Amount'), 'required' => true), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Pledge Currency'), 'maxlength' => 3, 'size' => CRM_Utils_Type::FOUR, 'default' => 'NULL', 'pseudoconstant' => array('table' => 'civicrm_currency', 'keyColumn' => 'name', 'labelColumn' => 'full_name', 'nameColumn' => 'numeric_code')), 'pledge_frequency_unit' => array('name' => 'frequency_unit', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('Pledge Frequency Unit'), 'default' => 'month', 'enumValues' => 'day,week,month,year'), 'pledge_frequency_interval' => array('name' => 'frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Frequency Interval'), 'required' => true, 'default' => '1'), 'frequency_day' => array('name' => 'frequency_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge day'), 'required' => true, 'default' => '3'), 'installments' => array('name' => 'installments', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Number of Installments'), 'default' => '1'), 'start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Start Date'), 'required' => true), 'pledge_create_date' => array('name' => 'create_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Made'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.create_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'acknowledge_date' => array('name' => 'acknowledge_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Acknowledged')), 'modified_date' => array('name' => 'modified_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Modified Date')), 'cancel_date' => array('name' => 'cancel_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Cancelled Date')), 'end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge End Date')), 'honor_contact_id' => array('name' => 'honor_contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Honor Contact'), 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'honor_type_id' => array('name' => 'honor_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Honor Type'), 'pseudoconstant' => array('optionGroupName' => 'honor_type')), 'max_reminders' => array('name' => 'max_reminders', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Maximum Number of Reminders'), 'default' => '1'), 'initial_reminder_day' => array('name' => 'initial_reminder_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Initial Reminder Day'), 'default' => '5'), 'additional_reminder_day' => array('name' => 'additional_reminder_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Additional Reminder Days'), 'default' => '5'), 'pledge_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Status Id'), 'import' => true, 'where' => 'civicrm_pledge.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false), 'pledge_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_pledge.is_test', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign'), 'import' => true, 'where' => 'civicrm_pledge.campaign_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')));
}
return self::$_fields;
}
/**
* returns all the column names of this table
*
* @access public
* @return array
*/
function &fields()
{
if (!self::$_fields) {
self::$_fields = array('pledge_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.contact_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'contribution_type_id' => array('name' => 'contribution_type_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contribute_DAO_ContributionType'), 'contribution_page_id' => array('name' => 'contribution_page_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contribute_DAO_ContributionPage'), 'pledge_amount' => array('name' => 'amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Total Pledged'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'frequency_unit' => array('name' => 'frequency_unit', 'type' => CRM_Utils_Type::T_ENUM, 'title' => ts('Frequency Unit'), 'default' => 'month', 'enumValues' => 'day,week,month,year'), 'frequency_interval' => array('name' => 'frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Frequency Interval'), 'required' => true, 'default' => ''), 'frequency_day' => array('name' => 'frequency_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Frequency Day'), 'required' => true, 'default' => ''), 'installments' => array('name' => 'installments', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Installments'), 'default' => ''), 'start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Start Date'), 'required' => true), 'pledge_create_date' => array('name' => 'create_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Made'), 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.create_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'acknowledge_date' => array('name' => 'acknowledge_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Acknowledge Date')), 'modified_date' => array('name' => 'modified_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Modified Date')), 'cancel_date' => array('name' => 'cancel_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Cancel Date')), 'end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('End Date')), 'honor_contact_id' => array('name' => 'honor_contact_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Contact_DAO_Contact'), 'honor_type_id' => array('name' => 'honor_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Honor Type')), 'max_reminders' => array('name' => 'max_reminders', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Maximum Number of Reminders'), 'default' => ''), 'initial_reminder_day' => array('name' => 'initial_reminder_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Initial Reminder Day'), 'default' => ''), 'additional_reminder_day' => array('name' => 'additional_reminder_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Additional Reminder Days'), 'default' => ''), 'pledge_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Status'), 'import' => true, 'where' => 'civicrm_pledge.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_pledge.is_test', 'headerPattern' => '', 'dataPattern' => '', 'export' => true));
}
return self::$_fields;
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('pledge_id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge ID'), 'description' => 'Pledge ID', 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'pledge_contact_id' => array('name' => 'contact_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Contact ID'), 'description' => 'Foreign key to civicrm_contact.id .', 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.contact_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Contact_DAO_Contact', 'html' => array('type' => 'EntityRef')), 'pledge_financial_type_id' => array('name' => 'financial_type_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Type'), 'description' => 'FK to Financial Type', 'FKClassName' => 'CRM_Financial_DAO_FinancialType', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_financial_type', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'pledge_contribution_page_id' => array('name' => 'contribution_page_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Contribution Page'), 'description' => 'The Contribution Page which triggered this contribution', 'FKClassName' => 'CRM_Contribute_DAO_ContributionPage'), 'pledge_amount' => array('name' => 'amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Total Pledged'), 'description' => 'Total pledged amount.', 'required' => true, 'precision' => array(20, 2), 'import' => true, 'where' => 'civicrm_pledge.amount', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Text')), 'pledge_original_installment_amount' => array('name' => 'original_installment_amount', 'type' => CRM_Utils_Type::T_MONEY, 'title' => ts('Original Installment Amount'), 'description' => 'Original amount for each of the installments.', 'required' => true, 'precision' => array(20, 2), 'html' => array('type' => 'Text')), 'currency' => array('name' => 'currency', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Pledge 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_frequency_unit' => array('name' => 'frequency_unit', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Pledge Frequency Unit'), 'description' => 'Time units for recurrence of pledge payments.', 'maxlength' => 8, 'size' => CRM_Utils_Type::EIGHT, 'default' => 'month', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('optionGroupName' => 'recur_frequency_units', 'keyColumn' => 'name', 'optionEditPath' => 'civicrm/admin/options/recur_frequency_units')), 'pledge_frequency_interval' => array('name' => 'frequency_interval', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Frequency Interval'), 'description' => 'Number of time units for recurrence of pledge payments.', 'required' => true, 'default' => '1', 'html' => array('type' => 'Text')), 'frequency_day' => array('name' => 'frequency_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge day'), 'description' => '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.', 'required' => true, 'default' => '3', 'html' => array('type' => 'Select')), 'installments' => array('name' => 'installments', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Number of Installments'), 'description' => 'Total number of payments to be made.', 'default' => '1', 'html' => array('type' => 'Text')), 'start_date' => array('name' => 'start_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Start Date'), 'description' => 'The date the first scheduled pledge occurs.', 'required' => true, 'html' => array('type' => 'Select Date')), 'pledge_create_date' => array('name' => 'create_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Made'), 'description' => 'When this pledge record was created.', 'required' => true, 'import' => true, 'where' => 'civicrm_pledge.create_date', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'Select Date')), 'acknowledge_date' => array('name' => 'acknowledge_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Acknowledged'), 'description' => 'When a pledge acknowledgement message was sent to the contributor.', 'html' => array('type' => 'Select Date')), 'modified_date' => array('name' => 'modified_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Modified Date'), 'description' => 'Last updated date for this pledge record.'), 'cancel_date' => array('name' => 'cancel_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge Cancelled Date'), 'description' => 'Date this pledge was cancelled by contributor.', 'html' => array('type' => 'Select Date')), 'end_date' => array('name' => 'end_date', 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME, 'title' => ts('Pledge End Date'), 'description' => 'Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount).', 'html' => array('type' => 'Select Date')), 'max_reminders' => array('name' => 'max_reminders', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Maximum Number of Reminders'), 'description' => 'The maximum number of payment reminders to send for any given payment.', 'default' => '1', 'html' => array('type' => 'Text')), 'initial_reminder_day' => array('name' => 'initial_reminder_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Initial Reminder Day'), 'description' => 'Send initial reminder this many days prior to the payment due date.', 'default' => '5', 'html' => array('type' => 'Select')), 'additional_reminder_day' => array('name' => 'additional_reminder_day', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Additional Reminder Days'), 'description' => 'Send additional reminder this many days after last one sent, up to maximum number of reminders.', 'default' => '5', 'html' => array('type' => 'Text')), 'pledge_status_id' => array('name' => 'status_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Pledge Status Id'), 'description' => 'Implicit foreign key to civicrm_option_values in the contribution_status option group.', 'import' => true, 'where' => 'civicrm_pledge.status_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => false), 'pledge_is_test' => array('name' => 'is_test', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Test'), 'import' => true, 'where' => 'civicrm_pledge.is_test', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'html' => array('type' => 'CheckBox')), 'pledge_campaign_id' => array('name' => 'campaign_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Campaign'), 'description' => 'The campaign for which this pledge has been initiated.', 'import' => true, 'where' => 'civicrm_pledge.campaign_id', 'headerPattern' => '', 'dataPattern' => '', 'export' => true, 'FKClassName' => 'CRM_Campaign_DAO_Campaign', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_campaign', 'keyColumn' => 'id', 'labelColumn' => 'title')));
}
return self::$_fields;
}
