array('Contribution', 'trxn_id'),
);
- list($tableName, $sqlColumns) = CRM_Export_BAO_Export::exportComponents(
+ list($tableName) = CRM_Export_BAO_Export::exportComponents(
TRUE,
$this->contributionIDs,
array(),
$pattern = '/as `?([^`,]*)/';
$queryFieldAliases = array();
preg_match_all($pattern, $select, $queryFieldAliases, PREG_PATTERN_ORDER);
- $processor = new CRM_Export_BAO_ExportProcessor(CRM_Contact_BAO_Query::MODE_CONTRIBUTE, 'AND');
+ $processor = new CRM_Export_BAO_ExportProcessor(CRM_Contact_BAO_Query::MODE_CONTRIBUTE, NULL, 'AND');
$processor->setQueryFields($query->_fields);
list($outputFields) = CRM_Export_BAO_Export::getExportStructureArrays($returnProperties, $processor, $contactRelationshipTypes, '');
}
}
}
- list($tableName) = $this->doExport($fields, $this->contactIDs[0]);
+ list($tableName, $sqlColumns) = $this->doExport($fields, $this->contactIDs[0]);
$dao = CRM_Core_DAO::executeQuery('SELECT * FROM ' . $tableName);
while ($dao->fetch()) {
}
}
- // early return for now until we solve a leakage issue.
- return;
-
$this->assertEquals([
'billing_im_provider' => 'billing_im_provider text',
'billing_im_screen_name' => 'billing_im_screen_name text',
));
//export and merge contacts with same address
- list($tableName, $sqlColumns) = CRM_Export_BAO_Export::exportComponents(
+ list($tableName) = CRM_Export_BAO_Export::exportComponents(
TRUE,
array($contactA['id'], $contactB['id']),
array(),
}
/**
+ * Do a CiviCRM export.
+ *
* @param $selectedFields
+ * @param int $id
+ *
+ * @param int $exportMode
+ *
* @return array
*/
- protected function doExport($selectedFields, $id) {
+ protected function doExport($selectedFields, $id, $exportMode = CRM_Export_Form_Select::CONTACT_EXPORT) {
list($tableName, $sqlColumns) = CRM_Export_BAO_Export::exportComponents(
TRUE,
array($id),
NULL,
$selectedFields,
NULL,
- CRM_Export_Form_Select::CONTACT_EXPORT,
+ $exportMode,
"contact_a.id IN ({$id})",
NULL,
FALSE,
}
/**
- * Test the column definition when 'all' fields defined.
+ * Test our export all field metadata retrieval.
+ *
+ * @dataProvider additionalFieldsDataProvider
+ * @param int $exportMode
+ * @param $expected
+ */
+ public function testAdditionalReturnProperties($exportMode, $expected) {
+ $this->ensureComponentIsEnabled($exportMode);
+ $processor = new CRM_Export_BAO_ExportProcessor($exportMode, NULL, 'AND');
+ $metadata = $processor->getAdditionalReturnProperties();
+ $this->assertEquals($expected, $metadata);
+ }
+
+ /**
+ * Test our export all field metadata retrieval.
*
- * @param $exportMode
+ * @dataProvider allFieldsDataProvider
+ * @param int $exportMode
* @param $expected
+ */
+ public function testDefaultReturnProperties($exportMode, $expected) {
+ $this->ensureComponentIsEnabled($exportMode);
+ $processor = new CRM_Export_BAO_ExportProcessor($exportMode, NULL, 'AND');
+ $metadata = $processor->getDefaultReturnProperties();
+ $this->assertEquals($expected, $metadata);
+ }
+
+ /**
+ * Get fields returned from additionalFields function.
+ *
+ * @return array
+ */
+ public function additionalFieldsDataProvider() {
+ return [
+ [
+ 'anything that will then be defaulting ton contact',
+ $this->getExtraReturnProperties(),
+ ],
+ [
+ CRM_Export_Form_Select::ACTIVITY_EXPORT,
+ array_merge($this->getExtraReturnProperties(), $this->getActivityReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::CASE_EXPORT,
+ array_merge($this->getExtraReturnProperties(), $this->getCaseReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::CONTRIBUTE_EXPORT,
+ array_merge($this->getExtraReturnProperties(), $this->getContributionReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::EVENT_EXPORT,
+ array_merge($this->getExtraReturnProperties(), $this->getEventReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::MEMBER_EXPORT,
+ array_merge($this->getExtraReturnProperties(), $this->getMembershipReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::PLEDGE_EXPORT,
+ array_merge($this->getExtraReturnProperties(), $this->getPledgeReturnProperties()),
+ ],
+
+ ];
+ }
+
+ /**
+ * get data for testing field metadata by query mode.
+ */
+ public function allFieldsDataProvider() {
+ return [
+ [
+ 'anything that will then be defaulting ton contact',
+ $this->getBasicReturnProperties(TRUE),
+ ],
+ [
+ CRM_Export_Form_Select::ACTIVITY_EXPORT,
+ array_merge($this->getBasicReturnProperties(FALSE), $this->getActivityReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::CASE_EXPORT,
+ array_merge($this->getBasicReturnProperties(FALSE), $this->getCaseReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::CONTRIBUTE_EXPORT,
+ array_merge($this->getBasicReturnProperties(FALSE), $this->getContributionReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::EVENT_EXPORT,
+ array_merge($this->getBasicReturnProperties(FALSE), $this->getEventReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::MEMBER_EXPORT,
+ array_merge($this->getBasicReturnProperties(FALSE), $this->getMembershipReturnProperties()),
+ ],
+ [
+ CRM_Export_Form_Select::PLEDGE_EXPORT,
+ array_merge($this->getBasicReturnProperties(FALSE), $this->getPledgeReturnProperties()),
+ ],
+ ];
+ }
+
+ /**
+ * Get return properties manually added in.
+ */
+ public function getExtraReturnProperties() {
+ return [
+ 'location_type' => 1,
+ 'im_provider' => 1,
+ 'phone_type_id' => 1,
+ 'provider_id' => 1,
+ 'current_employer' => 1,
+ ];
+ }
+
+ /**
+ * Get basic return properties.
+ *
+ * @param bool $isContactMode
+ * Are we in contact mode or not
+ *
+ * @return array
+ */
+ protected function getBasicReturnProperties($isContactMode) {
+ $returnProperties = [
+ 'id' => 1,
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'do_not_email' => 1,
+ 'do_not_phone' => 1,
+ 'do_not_mail' => 1,
+ 'do_not_sms' => 1,
+ 'do_not_trade' => 1,
+ 'is_opt_out' => 1,
+ 'legal_identifier' => 1,
+ 'external_identifier' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'nick_name' => 1,
+ 'legal_name' => 1,
+ 'image_URL' => 1,
+ 'preferred_communication_method' => 1,
+ 'preferred_language' => 1,
+ 'preferred_mail_format' => 1,
+ 'hash' => 1,
+ 'contact_source' => 1,
+ 'first_name' => 1,
+ 'middle_name' => 1,
+ 'last_name' => 1,
+ 'prefix_id' => 1,
+ 'suffix_id' => 1,
+ 'formal_title' => 1,
+ 'communication_style_id' => 1,
+ 'email_greeting_id' => 1,
+ 'postal_greeting_id' => 1,
+ 'addressee_id' => 1,
+ 'job_title' => 1,
+ 'gender_id' => 1,
+ 'birth_date' => 1,
+ 'is_deceased' => 1,
+ 'deceased_date' => 1,
+ 'household_name' => 1,
+ 'organization_name' => 1,
+ 'sic_code' => 1,
+ 'user_unique_id' => 1,
+ 'current_employer_id' => 1,
+ 'contact_is_deleted' => 1,
+ 'created_date' => 1,
+ 'modified_date' => 1,
+ 'addressee' => 1,
+ 'email_greeting' => 1,
+ 'postal_greeting' => 1,
+ 'current_employer' => 1,
+ 'location_type' => 1,
+ 'street_address' => 1,
+ 'street_number' => 1,
+ 'street_number_suffix' => 1,
+ 'street_name' => 1,
+ 'street_unit' => 1,
+ 'supplemental_address_1' => 1,
+ 'supplemental_address_2' => 1,
+ 'supplemental_address_3' => 1,
+ 'city' => 1,
+ 'postal_code_suffix' => 1,
+ 'postal_code' => 1,
+ 'geo_code_1' => 1,
+ 'geo_code_2' => 1,
+ 'address_name' => 1,
+ 'master_id' => 1,
+ 'county' => 1,
+ 'state_province' => 1,
+ 'country' => 1,
+ 'phone' => 1,
+ 'phone_ext' => 1,
+ 'email' => 1,
+ 'on_hold' => 1,
+ 'is_bulkmail' => 1,
+ 'signature_text' => 1,
+ 'signature_html' => 1,
+ 'im_provider' => 1,
+ 'im' => 1,
+ 'openid' => 1,
+ 'world_region' => 1,
+ 'url' => 1,
+ 'groups' => 1,
+ 'tags' => 1,
+ 'notes' => 1,
+ 'phone_type_id' => 1,
+ 'provider_id' => 1,
+ ];
+ if (!$isContactMode) {
+ unset($returnProperties['groups']);
+ unset($returnProperties['tags']);
+ unset($returnProperties['notes']);
+ }
+ return $returnProperties;
+ }
+
+ /**
+ * Get return properties for pledges.
+ *
+ * @return array
+ */
+ public function getPledgeReturnProperties() {
+ return [
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'pledge_id' => 1,
+ 'pledge_amount' => 1,
+ 'pledge_total_paid' => 1,
+ 'pledge_create_date' => 1,
+ 'pledge_start_date' => 1,
+ 'pledge_next_pay_date' => 1,
+ 'pledge_next_pay_amount' => 1,
+ 'pledge_status' => 1,
+ 'pledge_is_test' => 1,
+ 'pledge_contribution_page_id' => 1,
+ 'pledge_financial_type' => 1,
+ 'pledge_frequency_interval' => 1,
+ 'pledge_frequency_unit' => 1,
+ 'pledge_currency' => 1,
+ 'pledge_campaign_id' => 1,
+ 'pledge_balance_amount' => 1,
+ 'pledge_payment_id' => 1,
+ 'pledge_payment_scheduled_amount' => 1,
+ 'pledge_payment_scheduled_date' => 1,
+ 'pledge_payment_paid_amount' => 1,
+ 'pledge_payment_paid_date' => 1,
+ 'pledge_payment_reminder_date' => 1,
+ 'pledge_payment_reminder_count' => 1,
+ 'pledge_payment_status' => 1,
+ ];
+ }
+
+ /**
+ * Get membership return properties.
+ *
+ * @return array
+ */
+ public function getMembershipReturnProperties() {
+ return [
+ 'location_type' => 1,
+ 'im_provider' => 1,
+ 'phone_type_id' => 1,
+ 'provider_id' => 1,
+ 'current_employer' => 1,
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'membership_type' => 1,
+ 'member_is_test' => 1,
+ 'member_is_pay_later' => 1,
+ 'join_date' => 1,
+ 'membership_start_date' => 1,
+ 'membership_end_date' => 1,
+ 'membership_source' => 1,
+ 'membership_status' => 1,
+ 'membership_id' => 1,
+ 'owner_membership_id' => 1,
+ 'max_related' => 1,
+ 'membership_recur_id' => 1,
+ 'member_campaign_id' => 1,
+ 'member_is_override' => 1,
+ 'member_auto_renew' => 1,
+ ];
+ }
+
+ /**
+ * Get return properties for events.
+ *
+ * @return array
+ */
+ public function getEventReturnProperties() {
+ return [
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'event_id' => 1,
+ 'event_title' => 1,
+ 'event_start_date' => 1,
+ 'event_end_date' => 1,
+ 'event_type' => 1,
+ 'participant_id' => 1,
+ 'participant_status' => 1,
+ 'participant_status_id' => 1,
+ 'participant_role' => 1,
+ 'participant_role_id' => 1,
+ 'participant_note' => 1,
+ 'participant_register_date' => 1,
+ 'participant_source' => 1,
+ 'participant_fee_level' => 1,
+ 'participant_is_test' => 1,
+ 'participant_is_pay_later' => 1,
+ 'participant_fee_amount' => 1,
+ 'participant_discount_name' => 1,
+ 'participant_fee_currency' => 1,
+ 'participant_registered_by_id' => 1,
+ 'participant_campaign_id' => 1,
+ ];
+ }
+
+ /**
+ * Get return properties for activities.
+ *
+ * @return array
+ */
+ public function getActivityReturnProperties() {
+ return [
+ 'activity_id' => 1,
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'activity_type' => 1,
+ 'activity_type_id' => 1,
+ 'activity_subject' => 1,
+ 'activity_date_time' => 1,
+ 'activity_duration' => 1,
+ 'activity_location' => 1,
+ 'activity_details' => 1,
+ 'activity_status' => 1,
+ 'activity_priority' => 1,
+ 'source_contact' => 1,
+ 'source_record_id' => 1,
+ 'activity_is_test' => 1,
+ 'activity_campaign_id' => 1,
+ 'result' => 1,
+ 'activity_engagement_level' => 1,
+ 'parent_id' => 1,
+ ];
+ }
+
+ /**
+ * Get return properties for Case.
+ *
+ * @return array
+ */
+ public function getCaseReturnProperties() {
+ return [
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'phone' => 1,
+ 'case_start_date' => 1,
+ 'case_end_date' => 1,
+ 'case_subject' => 1,
+ 'case_source_contact_id' => 1,
+ 'case_activity_status' => 1,
+ 'case_activity_duration' => 1,
+ 'case_activity_medium_id' => 1,
+ 'case_activity_details' => 1,
+ 'case_activity_is_auto' => 1,
+ 'contact_id' => 1,
+ 'case_id' => 1,
+ 'case_activity_subject' => 1,
+ 'case_status' => 1,
+ 'case_type' => 1,
+ 'case_role' => 1,
+ 'case_deleted' => 1,
+ 'case_recent_activity_date' => 1,
+ 'case_recent_activity_type' => 1,
+ 'case_scheduled_activity_date' => 1,
+ ];
+ }
+
+ /**
+ * Get return properties for contribution.
+ *
+ * @return array
+ */
+ public function getContributionReturnProperties() {
+ return [
+ 'contact_type' => 1,
+ 'contact_sub_type' => 1,
+ 'sort_name' => 1,
+ 'display_name' => 1,
+ 'financial_type' => 1,
+ 'contribution_source' => 1,
+ 'receive_date' => 1,
+ 'thankyou_date' => 1,
+ 'cancel_date' => 1,
+ 'total_amount' => 1,
+ 'accounting_code' => 1,
+ 'payment_instrument' => 1,
+ 'payment_instrument_id' => 1,
+ 'contribution_check_number' => 1,
+ 'non_deductible_amount' => 1,
+ 'fee_amount' => 1,
+ 'net_amount' => 1,
+ 'trxn_id' => 1,
+ 'invoice_id' => 1,
+ 'invoice_number' => 1,
+ 'currency' => 1,
+ 'cancel_reason' => 1,
+ 'receipt_date' => 1,
+ 'product_name' => 1,
+ 'sku' => 1,
+ 'product_option' => 1,
+ 'fulfilled_date' => 1,
+ 'contribution_start_date' => 1,
+ 'contribution_end_date' => 1,
+ 'is_test' => 1,
+ 'is_pay_later' => 1,
+ 'contribution_status' => 1,
+ 'contribution_recur_id' => 1,
+ 'amount_level' => 1,
+ 'contribution_note' => 1,
+ 'contribution_batch' => 1,
+ 'contribution_campaign_title' => 1,
+ 'contribution_campaign_id' => 1,
+ 'contribution_product_id' => 1,
+ 'contribution_soft_credit_name' => 1,
+ 'contribution_soft_credit_amount' => 1,
+ 'contribution_soft_credit_type' => 1,
+ 'contribution_soft_credit_contact_id' => 1,
+ 'contribution_soft_credit_contribution_id' => 1,
+ ];
+ }
+
+ /**
+ * Test the column definition when 'all' fields defined.
+ *
+ * @param int $exportMode
+ * @param array $expected
+ * @param array $expectedHeaders
*
* @dataProvider getSqlColumnsOutput
*/
- public function testGetSQLColumns($exportMode, $expected) {
+ public function testGetSQLColumnsAndHeaders($exportMode, $expected, $expectedHeaders) {
$this->ensureComponentIsEnabled($exportMode);
// We need some data so that we can get to the end of the export
// function. Hopefully one day that won't be required to get metadata info out.
)
);
$this->assertEquals($expected, $result[1]);
+ $this->assertEquals($expectedHeaders, $result[2]);
+ }
+
+ /**
+ * Test exported with fields to output specified.
+ *
+ * @dataProvider getAllSpecifiableReturnFields
+ *
+ * @param int $exportMode
+ * @param array $selectedFields
+ * @param array $expected
+ */
+ public function testExportSpecifyFields($exportMode, $selectedFields, $expected) {
+ $this->ensureComponentIsEnabled($exportMode);
+ $this->setUpContributionExportData();
+ list($tableName, $sqlColumns) = $this->doExport($selectedFields, $this->contactIDs[1], $exportMode);
+ $this->assertEquals($expected, $sqlColumns);
+ }
+
+ /**
+ * Test export fields when no payment fields to be exported.
+ */
+ public function textExportParticipantSpecifyFieldsNoPayment() {
+ $selectedFields = $this->getAllSpecifiableParticipantReturnFields();
+ foreach ($selectedFields as $index => $field) {
+ if (substr($field[1], 0, 22) === 'componentPaymentField_') {
+ unset ($selectedFields[$index]);
+ }
+ }
+
+ $expected = $this->getAllSpecifiableParticipantReturnFields();
+ foreach ($expected as $index => $field) {
+ if (substr($index, 0, 22) === 'componentPaymentField_') {
+ unset ($expected[$index]);
+ }
+ }
+
+ list($tableName, $sqlColumns) = $this->doExport($selectedFields, $this->contactIDs[1], CRM_Export_Form_Select::EVENT_EXPORT);
+ $this->assertEquals($expected, $sqlColumns);
+ }
+ /**
+ * Get all return fields (@todo - still being built up.
+ *
+ * @return array
+ */
+ public function getAllSpecifiableReturnFields() {
+ return [
+ [
+ CRM_Export_Form_Select::EVENT_EXPORT,
+ $this->getAllSpecifiableParticipantReturnFields(),
+ $this->getAllSpecifiableParticipantReturnColumns(),
+ ],
+ ];
+ }
+
+ /**
+ * Get expected return column output for participant mode return all columns.
+ *
+ * @return array
+ */
+ public function getAllSpecifiableParticipantReturnColumns() {
+ return [
+ 'participant_campaign_id' => 'participant_campaign_id varchar(128)',
+ 'participant_contact_id' => 'participant_contact_id varchar(16)',
+ 'componentpaymentfield_contribution_status' => 'componentpaymentfield_contribution_status text',
+ 'currency' => 'currency varchar(3)',
+ 'componentpaymentfield_received_date' => 'componentpaymentfield_received_date text',
+ 'default_role_id' => 'default_role_id varchar(16)',
+ 'participant_discount_name' => 'participant_discount_name varchar(16)',
+ 'event_id' => 'event_id varchar(16)',
+ 'event_end_date' => 'event_end_date varchar(32)',
+ 'event_start_date' => 'event_start_date varchar(32)',
+ 'template_title' => 'template_title varchar(255)',
+ 'event_title' => 'event_title varchar(255)',
+ 'participant_fee_amount' => 'participant_fee_amount varchar(32)',
+ 'participant_fee_currency' => 'participant_fee_currency varchar(3)',
+ 'fee_label' => 'fee_label varchar(255)',
+ 'participant_fee_level' => 'participant_fee_level longtext',
+ 'participant_is_pay_later' => 'participant_is_pay_later varchar(16)',
+ 'participant_id' => 'participant_id varchar(16)',
+ 'participant_note' => 'participant_note text',
+ 'participant_role_id' => 'participant_role_id varchar(128)',
+ 'participant_role' => 'participant_role varchar(255)',
+ 'participant_source' => 'participant_source varchar(128)',
+ 'participant_status_id' => 'participant_status_id varchar(16)',
+ 'participant_status' => 'participant_status varchar(255)',
+ 'participant_register_date' => 'participant_register_date varchar(32)',
+ 'participant_registered_by_id' => 'participant_registered_by_id varchar(16)',
+ 'participant_is_test' => 'participant_is_test varchar(16)',
+ 'componentpaymentfield_total_amount' => 'componentpaymentfield_total_amount text',
+ 'componentpaymentfield_transaction_id' => 'componentpaymentfield_transaction_id varchar(255)',
+ 'transferred_to_contact_id' => 'transferred_to_contact_id varchar(16)',
+ ];
+ }
+
+ /**
+ * @return array
+ */
+ public function getAllSpecifiableParticipantReturnFields() {
+ return [
+ 0 =>
+ [
+ 0 => 'Participant',
+ 1 => '',
+ ],
+ 1 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_campaign_id',
+ ],
+ 2 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_contact_id',
+ ],
+ 3 =>
+ [
+ 0 => 'Participant',
+ 1 => 'componentPaymentField_contribution_status',
+ ],
+ 4 =>
+ [
+ 0 => 'Participant',
+ 1 => 'currency',
+ ],
+ 5 =>
+ [
+ 0 => 'Participant',
+ 1 => 'componentPaymentField_received_date',
+ ],
+ 6 =>
+ [
+ 0 => 'Participant',
+ 1 => 'default_role_id',
+ ],
+ 7 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_discount_name',
+ ],
+ 8 =>
+ [
+ 0 => 'Participant',
+ 1 => 'event_id',
+ ],
+ 9 =>
+ [
+ 0 => 'Participant',
+ 1 => 'event_end_date',
+ ],
+ 10 =>
+ [
+ 0 => 'Participant',
+ 1 => 'event_start_date',
+ ],
+ 11 =>
+ [
+ 0 => 'Participant',
+ 1 => 'template_title',
+ ],
+ 12 =>
+ [
+ 0 => 'Participant',
+ 1 => 'event_title',
+ ],
+ 13 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_fee_amount',
+ ],
+ 14 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_fee_currency',
+ ],
+ 15 =>
+ [
+ 0 => 'Participant',
+ 1 => 'fee_label',
+ ],
+ 16 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_fee_level',
+ ],
+ 17 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_is_pay_later',
+ ],
+ 18 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_id',
+ ],
+ 19 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_note',
+ ],
+ 20 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_role_id',
+ ],
+ 21 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_role',
+ ],
+ 22 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_source',
+ ],
+ 23 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_status_id',
+ ],
+ 24 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_status',
+ ],
+ 25 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_status',
+ ],
+ 26 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_register_date',
+ ],
+ 27 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_registered_by_id',
+ ],
+ 28 =>
+ [
+ 0 => 'Participant',
+ 1 => 'participant_is_test',
+ ],
+ 29 =>
+ [
+ 0 => 'Participant',
+ 1 => 'componentPaymentField_total_amount',
+ ],
+ 30 =>
+ [
+ 0 => 'Participant',
+ 1 => 'componentPaymentField_transaction_id',
+ ],
+ 31 =>
+ [
+ 0 => 'Participant',
+ 1 => 'transferred_to_contact_id',
+ ],
+ ];
}
/**
[
'anything that will then be defaulting ton contact',
$this->getBasicSqlColumnDefinition(TRUE),
+ $this->getBasicHeaderDefinition(TRUE),
],
[
CRM_Export_Form_Select::ACTIVITY_EXPORT,
array_merge($this->getBasicSqlColumnDefinition(FALSE), $this->getActivitySqlColumns()),
+ array_merge($this->getBasicHeaderDefinition(FALSE), $this->getActivityHeaderDefinition()),
],
[
CRM_Export_Form_Select::CASE_EXPORT,
array_merge($this->getBasicSqlColumnDefinition(FALSE), $this->getCaseSqlColumns()),
+ array_merge($this->getBasicHeaderDefinition(FALSE), $this->getCaseHeaderDefinition()),
],
[
CRM_Export_Form_Select::CONTRIBUTE_EXPORT,
array_merge($this->getBasicSqlColumnDefinition(FALSE), $this->getContributionSqlColumns()),
+ array_merge($this->getBasicHeaderDefinition(FALSE), $this->getContributeHeaderDefinition()),
],
[
CRM_Export_Form_Select::EVENT_EXPORT,
array_merge($this->getBasicSqlColumnDefinition(FALSE), $this->getParticipantSqlColumns()),
+ array_merge($this->getBasicHeaderDefinition(FALSE), $this->getParticipantHeaderDefinition()),
],
[
CRM_Export_Form_Select::MEMBER_EXPORT,
array_merge($this->getBasicSqlColumnDefinition(FALSE), $this->getMembershipSqlColumns()),
+ array_merge($this->getBasicHeaderDefinition(FALSE), $this->getMemberHeaderDefinition()),
],
[
CRM_Export_Form_Select::PLEDGE_EXPORT,
array_merge($this->getBasicSqlColumnDefinition(FALSE), $this->getPledgeSqlColumns()),
+ array_merge($this->getBasicHeaderDefinition(FALSE), $this->getPledgeHeaderDefinition()),
],
];
}
+ /**
+ * Get the header definition for exports.
+ *
+ * @param bool $isContactExport
+ *
+ * @return array
+ */
+ protected function getBasicHeaderDefinition($isContactExport) {
+ $headers = [
+ 0 => 'Contact ID',
+ 1 => 'Contact Type',
+ 2 => 'Contact Subtype',
+ 3 => 'Do Not Email',
+ 4 => 'Do Not Phone',
+ 5 => 'Do Not Mail',
+ 6 => 'Do Not Sms',
+ 7 => 'Do Not Trade',
+ 8 => 'No Bulk Emails (User Opt Out)',
+ 9 => 'Legal Identifier',
+ 10 => 'External Identifier',
+ 11 => 'Sort Name',
+ 12 => 'Display Name',
+ 13 => 'Nickname',
+ 14 => 'Legal Name',
+ 15 => 'Image Url',
+ 16 => 'Preferred Communication Method',
+ 17 => 'Preferred Language',
+ 18 => 'Preferred Mail Format',
+ 19 => 'Contact Hash',
+ 20 => 'Contact Source',
+ 21 => 'First Name',
+ 22 => 'Middle Name',
+ 23 => 'Last Name',
+ 24 => 'Individual Prefix',
+ 25 => 'Individual Suffix',
+ 26 => 'Formal Title',
+ 27 => 'Communication Style',
+ 28 => 'Email Greeting ID',
+ 29 => 'Postal Greeting ID',
+ 30 => 'Addressee ID',
+ 31 => 'Job Title',
+ 32 => 'Gender',
+ 33 => 'Birth Date',
+ 34 => 'Deceased',
+ 35 => 'Deceased Date',
+ 36 => 'Household Name',
+ 37 => 'Organization Name',
+ 38 => 'Sic Code',
+ 39 => 'Unique ID (OpenID)',
+ 40 => 'Current Employer ID',
+ 41 => 'Contact is in Trash',
+ 42 => 'Created Date',
+ 43 => 'Modified Date',
+ 44 => 'Addressee',
+ 45 => 'Email Greeting',
+ 46 => 'Postal Greeting',
+ 47 => 'Current Employer',
+ 48 => 'Location Type',
+ 49 => 'Street Address',
+ 50 => 'Street Number',
+ 51 => 'Street Number Suffix',
+ 52 => 'Street Name',
+ 53 => 'Street Unit',
+ 54 => 'Supplemental Address 1',
+ 55 => 'Supplemental Address 2',
+ 56 => 'Supplemental Address 3',
+ 57 => 'City',
+ 58 => 'Postal Code Suffix',
+ 59 => 'Postal Code',
+ 60 => 'Latitude',
+ 61 => 'Longitude',
+ 62 => 'Address Name',
+ 63 => 'Master Address Belongs To',
+ 64 => 'County',
+ 65 => 'State',
+ 66 => 'Country',
+ 67 => 'Phone',
+ 68 => 'Phone Extension',
+ 69 => 'Phone Type',
+ 70 => 'Email',
+ 71 => 'On Hold',
+ 72 => 'Use for Bulk Mail',
+ 73 => 'Signature Text',
+ 74 => 'Signature Html',
+ 75 => 'IM Provider',
+ 76 => 'IM Screen Name',
+ 77 => 'OpenID',
+ 78 => 'World Region',
+ 79 => 'Website',
+ 80 => 'Group(s)',
+ 81 => 'Tag(s)',
+ 82 => 'Note(s)',
+ 83 => 'IM Service Provider',
+ ];
+ if (!$isContactExport) {
+ unset($headers[80]);
+ unset($headers[81]);
+ unset($headers[82]);
+ }
+ return $headers;
+ }
+
+ /**
+ * Get the definition for activity headers.
+ *
+ * @return array
+ */
+ protected function getActivityHeaderDefinition() {
+ return [
+ 81 => 'Activity ID',
+ 82 => 'Activity Type',
+ 83 => 'Activity Type ID',
+ 84 => 'Subject',
+ 85 => 'Activity Date',
+ 86 => 'Duration',
+ 87 => 'Location',
+ 88 => 'Details',
+ 89 => 'Activity Status',
+ 90 => 'Activity Priority',
+ 91 => 'Source Contact',
+ 92 => 'source_record_id',
+ 93 => 'Test',
+ 94 => 'Campaign ID',
+ 95 => 'result',
+ 96 => 'Engagement Index',
+ 97 => 'parent_id',
+ ];
+ }
+
+ /**
+ * Get the definition for case headers.
+ *
+ * @return array
+ */
+ protected function getCaseHeaderDefinition() {
+ return [
+ 81 => 'contact_id',
+ 82 => 'Case ID',
+ 83 => 'case_activity_subject',
+ 84 => 'Case Subject',
+ 85 => 'Case Status',
+ 86 => 'Case Type',
+ 87 => 'Role in Case',
+ 88 => 'Case is in the Trash',
+ 89 => 'case_recent_activity_date',
+ 90 => 'case_recent_activity_type',
+ 91 => 'case_scheduled_activity_date',
+ 92 => 'Case Start Date',
+ 93 => 'Case End Date',
+ 94 => 'case_source_contact_id',
+ 95 => 'case_activity_status',
+ 96 => 'case_activity_duration',
+ 97 => 'case_activity_medium_id',
+ 98 => 'case_activity_details',
+ 99 => 'case_activity_is_auto',
+ ];
+ }
+
+ /**
+ * Get the definition for contribute headers.
+ *
+ * @return array
+ */
+ protected function getContributeHeaderDefinition() {
+ return [
+ 81 => 'Financial Type',
+ 82 => 'Contribution Source',
+ 83 => 'Date Received',
+ 84 => 'Thank-you Date',
+ 85 => 'Cancel Date',
+ 86 => 'Total Amount',
+ 87 => 'Accounting Code',
+ 88 => 'payment_instrument',
+ 89 => 'Payment Method ID',
+ 90 => 'Check Number',
+ 91 => 'Non-deductible Amount',
+ 92 => 'Fee Amount',
+ 93 => 'Net Amount',
+ 94 => 'Transaction ID',
+ 95 => 'Invoice Reference',
+ 96 => 'Invoice Number',
+ 97 => 'Currency',
+ 98 => 'Cancel Reason',
+ 99 => 'Receipt Date',
+ 100 => 'Product Name',
+ 101 => 'SKU',
+ 102 => 'Product Option',
+ 103 => 'Fulfilled Date',
+ 104 => 'Start date for premium',
+ 105 => 'End date for premium',
+ 106 => 'Test',
+ 107 => 'Is Pay Later',
+ 108 => 'contribution_status',
+ 109 => 'Recurring Contribution ID',
+ 110 => 'Amount Label',
+ 111 => 'Contribution Note',
+ 112 => 'Batch Name',
+ 113 => 'Campaign Title',
+ 114 => 'Campaign ID',
+ 115 => 'Premium',
+ 116 => 'Soft Credit For',
+ 117 => 'Soft Credit Amount',
+ 118 => 'Soft Credit Type',
+ 119 => 'Soft Credit For Contact ID',
+ 120 => 'Soft Credit For Contribution ID',
+ ];
+ }
+
+ /**
+ * Get the definition for event headers.
+ *
+ * @return array
+ */
+ protected function getParticipantHeaderDefinition() {
+ return [
+ 81 => 'Event',
+ 82 => 'Event Title',
+ 83 => 'Event Start Date',
+ 84 => 'Event End Date',
+ 85 => 'Event Type',
+ 86 => 'Participant ID',
+ 87 => 'Participant Status',
+ 88 => 'Participant Status Id',
+ 89 => 'Participant Role',
+ 90 => 'Participant Role Id',
+ 91 => 'Participant Note',
+ 92 => 'Register date',
+ 93 => 'Participant Source',
+ 94 => 'Fee level',
+ 95 => 'Test',
+ 96 => 'Is Pay Later',
+ 97 => 'Fee Amount',
+ 98 => 'Discount Name',
+ 99 => 'Fee Currency',
+ 100 => 'Registered By ID',
+ 101 => 'Campaign ID',
+ ];
+ }
+
+ /**
+ * Get the definition for member headers.
+ *
+ * @return array
+ */
+ protected function getMemberHeaderDefinition() {
+ return [
+ 81 => 'Membership Type',
+ 82 => 'Test',
+ 83 => 'Is Pay Later',
+ 84 => 'Member Since',
+ 85 => 'Membership Start Date',
+ 86 => 'Membership Expiration Date',
+ 87 => 'Source',
+ 88 => 'Membership Status',
+ 89 => 'Membership ID',
+ 90 => 'Primary Member ID',
+ 91 => 'max_related',
+ 92 => 'membership_recur_id',
+ 93 => 'Campaign ID',
+ 94 => 'member_is_override',
+ 95 => 'member_auto_renew',
+ ];
+ }
+
+ /**
+ * Get the definition for pledge headers.
+ *
+ * @return array
+ */
+ protected function getPledgeHeaderDefinition() {
+ return [
+ 81 => 'Pledge ID',
+ 82 => 'Total Pledged',
+ 83 => 'Total Paid',
+ 84 => 'Pledge Made',
+ 85 => 'pledge_start_date',
+ 86 => 'Next Payment Date',
+ 87 => 'Next Payment Amount',
+ 88 => 'Pledge Status',
+ 89 => 'Test',
+ 90 => 'Pledge Contribution Page Id',
+ 91 => 'pledge_financial_type',
+ 92 => 'Pledge Frequency Interval',
+ 93 => 'Pledge Frequency Unit',
+ 94 => 'pledge_currency',
+ 95 => 'Campaign ID',
+ 96 => 'Balance Amount',
+ 97 => 'Payment ID',
+ 98 => 'Scheduled Amount',
+ 99 => 'Scheduled Date',
+ 100 => 'Paid Amount',
+ 101 => 'Paid Date',
+ 102 => 'Last Reminder',
+ 103 => 'Reminders Sent',
+ 104 => 'Pledge Payment Status',
+ ];
+ }
+
/**
* Get the column definition for exports.
*
'country' => 'country varchar(64)',
'phone' => 'phone varchar(32)',
'phone_ext' => 'phone_ext varchar(16)',
+ 'phone_type_id' => 'phone_type_id varchar(16)',
'email' => 'email varchar(254)',
'on_hold' => 'on_hold varchar(16)',
'is_bulkmail' => 'is_bulkmail varchar(16)',
'groups' => 'groups text',
'tags' => 'tags text',
'notes' => 'notes text',
- 'phone_type_id' => 'phone_type_id varchar(255)',
'provider_id' => 'provider_id varchar(255)',
];
if (!$isContactExport) {
'openid' => 'openid varchar(255)',
'world_region' => 'world_region varchar(128)',
'url' => 'url varchar(128)',
- 'phone_type_id' => 'phone_type_id varchar(255)',
+ 'phone_type_id' => 'phone_type_id varchar(16)',
'provider_id' => 'provider_id varchar(255)',
'financial_type' => 'financial_type varchar(64)',
'contribution_source' => 'contribution_source varchar(255)',
projects / civicrm-core.git / blobdiff