4 * Class CRM_Core_DAOTest
7 class CRM_Export_BAO_ExportTest
extends CiviUnitTestCase
{
10 * Contact IDs created for testing.
14 protected $contactIDs = [];
17 * Contribution IDs created for testing.
21 protected $contributionIDs = [];
24 * Contribution IDs created for testing.
28 protected $activityIDs = [];
31 * Master Address ID created for testing.
35 protected $masterAddressID;
37 public function tearDown() {
38 $this->quickCleanup(['civicrm_contact', 'civicrm_email', 'civicrm_address', 'civicrm_relationship']);
39 $this->quickCleanUpFinancialEntities();
44 * Basic test to ensure the exportComponents function completes without error.
46 public function testExportComponentsNull() {
47 list($tableName, $sqlColumns) = CRM_Export_BAO_Export
::exportComponents(
54 CRM_Export_Form_Select
::CONTACT_EXPORT
,
61 'suppress_csv_for_testing' => TRUE,
65 // delete the export temp table and component table
66 $sql = "DROP TABLE IF EXISTS {$tableName}";
67 CRM_Core_DAO
::executeQuery($sql);
71 * Basic test to ensure the exportComponents function can export selected fields for contribution.
73 public function testExportComponentsContribution() {
74 $this->setUpContributionExportData();
75 $selectedFields = array(
76 array('Individual', 'first_name'),
77 array('Individual', 'last_name'),
78 array('Contribution', 'receive_date'),
79 array('Contribution', 'contribution_source'),
80 array('Individual', 'street_address', 1),
81 array('Individual', 'city', 1),
82 array('Individual', 'country', 1),
83 array('Individual', 'email', 1),
84 array('Contribution', 'trxn_id'),
87 list($tableName, $sqlColumns) = CRM_Export_BAO_Export
::exportComponents(
89 $this->contributionIDs
,
94 CRM_Export_Form_Select
::CONTRIBUTE_EXPORT
,
95 'civicrm_contribution.id IN ( ' . implode(',', $this->contributionIDs
) . ')',
100 'exportOption' => CRM_Export_Form_Select
::CONTRIBUTE_EXPORT
,
101 'suppress_csv_for_testing' => TRUE,
105 // delete the export temp table and component table
106 $sql = "DROP TABLE IF EXISTS {$tableName}";
107 CRM_Core_DAO
::executeQuery($sql);
111 * Basic test to ensure the exportComponents function can export selected fields for contribution.
113 public function testExportComponentsActivity() {
114 $this->setUpActivityExportData();
115 $selectedFields = array(
116 array('Individual', 'display_name'),
117 array('Individual', '5_a_b', 'display_name'),
120 list($tableName) = CRM_Export_BAO_Export
::exportComponents(
124 '`activity_date_time` desc',
127 CRM_Export_Form_Select
::ACTIVITY_EXPORT
,
128 'civicrm_activity.id IN ( ' . implode(',', $this->activityIDs
) . ')',
133 'exportOption' => CRM_Export_Form_Select
::ACTIVITY_EXPORT
,
134 'suppress_csv_for_testing' => TRUE,
138 // delete the export temp table and component table
139 $sql = "DROP TABLE IF EXISTS {$tableName}";
140 CRM_Core_DAO
::executeQuery($sql);
144 * Test the function that extracts the arrays used to structure the output.
146 * The keys in the output fields array should by matched by field aliases in the sql query (with
147 * exceptions of course - currently country is one - although maybe a future refactor can change that!).
149 * We are trying to move towards simpler processing in the per row iteration as that may be
150 * repeated 100,000 times and in general we should simply be able to match the query fields to
151 * our expected rows & do a little pseudoconstant mapping.
153 public function testGetExportStructureArrays() {
154 // This is how return properties are formatted internally within the function for passing to the BAO query.
155 $returnProperties = array(
159 'contribution_source' => 1,
162 'street_address' => 1,
173 'contribution_id' => 1,
176 $contactRelationshipTypes = CRM_Contact_BAO_Relationship
::getContactRelationshipType(
186 $query = new CRM_Contact_BAO_Query(array(), $returnProperties, NULL,
187 FALSE, FALSE, CRM_Contact_BAO_Query
::MODE_CONTRIBUTE
,
188 FALSE, TRUE, TRUE, NULL, 'AND'
191 list($select) = $query->query();
192 $pattern = '/as `?([^`,]*)/';
193 $queryFieldAliases = array();
194 preg_match_all($pattern, $select, $queryFieldAliases, PREG_PATTERN_ORDER
);
196 list($outputFields) = CRM_Export_BAO_Export
::getExportStructureArrays($returnProperties, $query, $contactRelationshipTypes, '', array());
197 foreach (array_keys($outputFields) as $fieldAlias) {
198 if ($fieldAlias == 'Home-country') {
199 $this->assertTrue(in_array($fieldAlias . '_id', $queryFieldAliases[1]), 'Country is subject to some funky translate so we make sure country id is present');
202 $this->assertTrue(in_array($fieldAlias, $queryFieldAliases[1]), 'looking for field ' . $fieldAlias . ' in generaly the alias fields need to match the outputfields');
209 * Set up some data for us to do testing on.
211 public function setUpContributionExportData() {
212 $this->setUpContactExportData();
213 $this->contributionIDs
[] = $this->contributionCreate(array('contact_id' => $this->contactIDs
[0], 'trxn_id' => 'null', 'invoice_id' => 'null'));
214 $this->contributionIDs
[] = $this->contributionCreate(array('contact_id' => $this->contactIDs
[1], 'trxn_id' => 'null', 'invoice_id' => 'null'));
218 * Set up some data for us to do testing on.
220 public function setUpActivityExportData() {
221 $this->setUpContactExportData();
222 $this->activityIDs
[] = $this->activityCreate(array('contact_id' => $this->contactIDs
[0]))['id'];
226 * Set up some data for us to do testing on.
228 public function setUpContactExportData() {
229 $this->contactIDs
[] = $contactA = $this->individualCreate(['gender_id' => 'Female']);
230 // Create address for contact A.
232 'contact_id' => $contactA,
233 'location_type_id' => 'Home',
234 'street_address' => 'Ambachtstraat 23',
235 'postal_code' => '6971 BN',
236 'country_id' => '1152',
240 $result = $this->callAPISuccess('address', 'create', $params);
241 $addressId = $result['id'];
243 $this->callAPISuccess('email', 'create', array(
244 'id' => $this->callAPISuccessGetValue('Email', ['contact_id' => $params['contact_id'], 'return' => 'id']),
245 'location_type_id' => 'Home',
246 'email' => 'home@example.com',
249 $this->callAPISuccess('email', 'create', array('contact_id' => $params['contact_id'], 'location_type_id' => 'Work', 'email' => 'work@example.com', 'is_primary' => 0));
251 $params['is_primary'] = 0;
252 $params['location_type_id'] = 'Work';
253 $this->callAPISuccess('address', 'create', $params);
254 $this->contactIDs
[] = $contactB = $this->individualCreate();
256 $this->callAPISuccess('address', 'create', array(
257 'contact_id' => $contactB,
258 'location_type_id' => "Home",
259 'master_id' => $addressId,
261 $this->masterAddressID
= $addressId;
266 * Test variants of primary address exporting.
268 * @param int $isPrimaryOnly
270 * @dataProvider getPrimarySearchOptions
272 public function testExportPrimaryAddress($isPrimaryOnly) {
273 \Civi
::settings()->set('searchPrimaryDetailsOnly', $isPrimaryOnly);
274 $this->setUpContactExportData();
276 $selectedFields = [['Individual', 'email', ' '], ['Individual', 'email', '1'], ['Individual', 'email', '2']];
277 list($tableName) = CRM_Export_BAO_Export
::exportComponents(
280 [['email', 'LIKE', 'c', 0, 1]],
284 CRM_Export_Form_Select
::CONTACT_EXPORT
,
285 "contact_a.id IN ({$this->contactIDs[0]}, {$this->contactIDs[1]})",
290 'exportOption' => CRM_Export_Form_Select
::CONTACT_EXPORT
,
291 'suppress_csv_for_testing' => TRUE,
295 $dao = CRM_Core_DAO
::executeQuery('SELECT * from ' . $tableName);
297 $this->assertEquals('home@example.com', $dao->email
);
298 $this->assertEquals('work@example.com', $dao->work_email
);
299 $this->assertEquals('home@example.com', $dao->home_email
);
300 $this->assertEquals(2, $dao->N
);
301 \Civi
::settings()->set('searchPrimaryDetailsOnly', FALSE);
305 * Get the options for the primary search setting field.
308 public function getPrimarySearchOptions() {
309 return [[TRUE], [FALSE]];
313 * Test that when exporting a pseudoField it is reset for NULL entries.
315 * ie. we have a contact WITH a gender & one without - make sure the latter one
316 * does NOT retain the gender of the former.
318 public function testExportPseudoField() {
319 $this->setUpContactExportData();
320 $selectedFields = [['Individual', 'gender_id']];
321 list($tableName, $sqlColumns) = CRM_Export_BAO_Export
::exportComponents(
323 $this->contactIDs
[1],
328 CRM_Export_Form_Select
::CONTACT_EXPORT
,
329 "contact_a.id IN (" . implode(",", $this->contactIDs
) . ")",
334 'exportOption' => CRM_Export_Form_Select
::CONTACT_EXPORT
,
335 'suppress_csv_for_testing' => TRUE,
338 $this->assertEquals('Female,', CRM_Core_DAO
::singleValueQuery("SELECT GROUP_CONCAT(gender_id) FROM {$tableName}"));
342 * Test that when exporting a pseudoField it is reset for NULL entries.
344 * This is specific to the example in CRM-14398
346 public function testExportPseudoFieldCampaign() {
347 $this->setUpContributionExportData();
348 $campaign = $this->callAPISuccess('Campaign', 'create', ['title' => 'Big campaign']);
349 $this->callAPISuccess('Contribution', 'create', ['campaign_id' => 'Big_campaign', 'id' => $this->contributionIDs
[0]]);
350 $selectedFields = [['Individual', 'gender_id'], ['Contribution', 'contribution_campaign_title']];
351 list($tableName, $sqlColumns) = CRM_Export_BAO_Export
::exportComponents(
353 $this->contactIDs
[1],
358 CRM_Export_Form_Select
::CONTRIBUTE_EXPORT
,
359 "contact_a.id IN (" . implode(",", $this->contactIDs
) . ")",
364 'exportOption' => CRM_Export_Form_Select
::CONTACT_EXPORT
,
365 'suppress_csv_for_testing' => TRUE,
368 $this->assertEquals('Big campaign,', CRM_Core_DAO
::singleValueQuery("SELECT GROUP_CONCAT(contribution_campaign_title) FROM {$tableName}"));
372 * Test exporting relationships.
374 * This is to ensure that CRM-13995 remains fixed.
376 public function testExportRelationshipsMergeToHousehold() {
377 $this->setUpContactExportData();
378 $householdID = $this->householdCreate(['api.Address.create' => ['city' => 'Portland', 'state_province_id' => 'Maine', 'location_type_id' => 'Home']]);
380 $relationshipTypes = $this->callAPISuccess('RelationshipType', 'get', [])['values'];
381 $houseHoldTypeID = NULL;
382 foreach ($relationshipTypes as $id => $relationshipType) {
383 if ($relationshipType['name_a_b'] === 'Household Member of') {
384 $houseHoldTypeID = $relationshipType['id'];
387 $this->callAPISuccess('Relationship', 'create', [
388 'contact_id_a' => $this->contactIDs
[0],
389 'contact_id_b' => $householdID,
390 'relationship_type_id' => $houseHoldTypeID,
392 $this->callAPISuccess('Relationship', 'create', [
393 'contact_id_a' => $this->contactIDs
[1],
394 'contact_id_b' => $householdID,
395 'relationship_type_id' => $houseHoldTypeID,
399 ['Individual', $houseHoldTypeID . '_a_b', 'state_province', ''],
400 ['Individual', $houseHoldTypeID . '_a_b', 'city', ''],
401 ['Individual', 'city', ''],
402 ['Individual', 'state_province', ''],
404 list($tableName) = CRM_Export_BAO_Export
::exportComponents(
411 CRM_Export_Form_Select
::CONTACT_EXPORT
,
412 "contact_a.id IN (" . implode(",", $this->contactIDs
) . ")",
417 'exportOption' => CRM_Export_Form_Select
::CONTACT_EXPORT
,
418 'suppress_csv_for_testing' => TRUE,
421 $dao = CRM_Core_DAO
::executeQuery("SELECT * FROM {$tableName}");
422 while ($dao->fetch()) {
423 $this->assertEquals('Portland', $dao->city
);
424 $this->assertEquals('ME', $dao->state_province
);
425 $this->assertEquals($householdID, $dao->civicrm_primary_id
);
426 $this->assertEquals($householdID, $dao->civicrm_primary_id
);
432 * Test master_address_id field.
434 public function testExportMasterAddress() {
435 $this->setUpContactExportData();
437 //export the master address for contact B
438 $selectedFields = array(
439 array('Individual', 'master_id', 1),
441 list($tableName, $sqlColumns) = CRM_Export_BAO_Export
::exportComponents(
443 array($this->contactIDs
[1]),
448 CRM_Export_Form_Select
::CONTACT_EXPORT
,
449 "contact_a.id IN ({$this->contactIDs[1]})",
454 'exportOption' => CRM_Export_Form_Select
::CONTACT_EXPORT
,
455 'suppress_csv_for_testing' => TRUE,
458 $field = key($sqlColumns);
460 //assert the exported result
461 $masterName = CRM_Core_DAO
::singleValueQuery("SELECT {$field} FROM {$tableName}");
462 $displayName = CRM_Contact_BAO_Contact
::getMasterDisplayName($this->masterAddressID
);
463 $this->assertEquals($displayName, $masterName);
465 // delete the export temp table and component table
466 $sql = "DROP TABLE IF EXISTS {$tableName}";
467 CRM_Core_DAO
::executeQuery($sql);
471 * Test that deceased and do not mail contacts are removed from contacts before
473 public function testExportDeceasedDoNotMail() {
474 $contactA = $this->callAPISuccess('contact', 'create', array(
475 'first_name' => 'John',
476 'last_name' => 'Doe',
477 'contact_type' => 'Individual',
480 $contactB = $this->callAPISuccess('contact', 'create', array(
481 'first_name' => 'Jane',
482 'last_name' => 'Doe',
483 'contact_type' => 'Individual',
487 //create address for contact A
488 $result = $this->callAPISuccess('address', 'create', array(
489 'contact_id' => $contactA['id'],
490 'location_type_id' => 'Home',
491 'street_address' => 'ABC 12',
492 'postal_code' => '123 AB',
493 'country_id' => '1152',
498 //create address for contact B
499 $result = $this->callAPISuccess('address', 'create', array(
500 'contact_id' => $contactB['id'],
501 'location_type_id' => 'Home',
502 'street_address' => 'ABC 12',
503 'postal_code' => '123 AB',
504 'country_id' => '1152',
509 //export and merge contacts with same address
510 list($tableName, $sqlColumns) = CRM_Export_BAO_Export
::exportComponents(
512 array($contactA['id'], $contactB['id']),
517 CRM_Export_Form_Select
::CONTACT_EXPORT
,
518 "contact_a.id IN ({$contactA['id']}, {$contactB['id']})",
523 'exportOption' => CRM_Export_Form_Select
::CONTACT_EXPORT
,
524 'mergeOption' => TRUE,
525 'suppress_csv_for_testing' => TRUE,
526 'postal_mailing_export' => array(
527 'postal_mailing_export' => TRUE,
532 $greeting = CRM_Core_DAO
::singleValueQuery("SELECT email_greeting FROM {$tableName}");
534 //Assert email_greeting is not merged
535 $this->assertNotContains(',', (string) $greeting);
537 // delete the export temp table and component table
538 $sql = "DROP TABLE IF EXISTS {$tableName}";
539 CRM_Core_DAO
::executeQuery($sql);