1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
<?php
namespace Civi\Test\Api4\Query;
use Civi\Api4\Query\Api4SelectQuery;
use Civi\Test\Api4\UnitTestCase;
/**
* @group headless
*/
class Api4SelectQueryComplexJoinTest extends UnitTestCase {
public function setUpHeadless() {
$relatedTables = [
'civicrm_address',
'civicrm_email',
'civicrm_phone',
'civicrm_openid',
'civicrm_im',
'civicrm_website',
'civicrm_activity',
'civicrm_activity_contact',
];
$this->cleanup(['tablesToTruncate' => $relatedTables]);
$this->loadDataSet('SingleContact');
return parent::setUpHeadless();
}
public function testWithComplexRelatedEntitySelect() {
$query = new Api4SelectQuery('Contact', FALSE);
$query->select[] = 'id';
$query->select[] = 'display_name';
$query->select[] = 'phones.phone';
$query->select[] = 'emails.email';
$query->select[] = 'emails.location_type.name';
$query->select[] = 'created_activities.contact_id';
$query->select[] = 'created_activities.activity.subject';
$query->select[] = 'created_activities.activity.activity_type.name';
$query->where[] = ['first_name', '=', 'Single'];
$query->where[] = ['id', '=', $this->getReference('test_contact_1')['id']];
$results = $query->run();
$testActivities = [
$this->getReference('test_activity_1'),
$this->getReference('test_activity_2'),
];
$activitySubjects = array_column($testActivities, 'subject');
$this->assertCount(1, $results);
$firstResult = array_shift($results);
$this->assertArrayHasKey('created_activities', $firstResult);
$firstCreatedActivity = array_shift($firstResult['created_activities']);
$this->assertArrayHasKey('activity', $firstCreatedActivity);
$firstActivity = $firstCreatedActivity['activity'];
$this->assertContains($firstActivity['subject'], $activitySubjects);
$this->assertArrayHasKey('activity_type', $firstActivity);
$activityType = $firstActivity['activity_type'];
$this->assertArrayHasKey('name', $activityType);
}
public function testWithSelectOfOrphanDeepValues() {
$query = new Api4SelectQuery('Contact', FALSE);
$query->select[] = 'id';
$query->select[] = 'first_name';
$query->select[] = 'emails.location_type.name'; // emails not selected
$results = $query->run();
$firstResult = array_shift($results);
$this->assertEmpty($firstResult['emails']);
}
public function testOrderDoesNotMatter() {
$query = new Api4SelectQuery('Contact', FALSE);
$query->select[] = 'id';
$query->select[] = 'first_name';
$query->select[] = 'emails.location_type.name'; // before emails selection
$query->select[] = 'emails.email';
$query->where[] = ['emails.email', 'IS NOT NULL'];
$results = $query->run();
$firstResult = array_shift($results);
$this->assertNotEmpty($firstResult['emails'][0]['location_type']['name']);
}
}
|