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
|
<?php
namespace Civi\Test\Api4\Action;
use Civi\Test\Api4\UnitTestCase;
use Civi\Api4\Activity;
use Civi\Api4\Contact;
/**
* @group headless
*/
class FkJoinTest extends UnitTestCase {
public function setUpHeadless() {
$relatedTables = [
'civicrm_activity',
'civicrm_phone',
'civicrm_activity_contact',
];
$this->cleanup(['tablesToTruncate' => $relatedTables]);
$this->loadDataSet('DefaultDataSet');
return parent::setUpHeadless();
}
/**
* Fetch all phone call activities. Expects a single activity
* loaded from the data set.
*/
public function testThreeLevelJoin() {
$results = Activity::get()
->setCheckPermissions(FALSE)
->addWhere('activity_type.name', '=', 'Phone Call')
->execute();
$this->assertCount(1, $results);
}
public function testActivityContactJoin() {
$results = Activity::get()
->setCheckPermissions(FALSE)
->addSelect('assignees.id')
->addSelect('assignees.first_name')
->addSelect('assignees.display_name')
->addWhere('assignees.first_name', '=', 'Phoney')
->execute();
$firstResult = $results->first();
$this->assertCount(1, $results);
$this->assertTrue(is_array($firstResult['assignees']));
$firstAssignee = array_shift($firstResult['assignees']);
$this->assertEquals($firstAssignee['first_name'], 'Phoney');
}
public function testContactPhonesJoin() {
$testContact = $this->getReference('test_contact_1');
$testPhone = $this->getReference('test_phone_1');
$results = Contact::get()
->setCheckPermissions(FALSE)
->addSelect('phones.phone')
->addWhere('id', '=', $testContact['id'])
->addWhere('phones.location_type.name', '=', 'Home')
->execute()
->first();
$this->assertArrayHasKey('phones', $results);
$this->assertCount(1, $results['phones']);
$firstPhone = array_shift($results['phones']);
$this->assertEquals($testPhone['phone'], $firstPhone['phone']);
}
}
|