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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
|
<?php
namespace Civi\Test\Api4\Action;
use Civi\Api4\Contact;
use Civi\Api4\CustomField;
use Civi\Api4\CustomGroup;
/**
* @group headless
*/
class BasicCustomFieldTest extends BaseCustomValueTest {
public function testWithSingleField() {
$customGroup = CustomGroup::create()
->setCheckPermissions(FALSE)
->addValue('name', 'MyContactFields')
->addValue('extends', 'Contact')
->execute()
->first();
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavColor')
->addValue('custom_group_id', $customGroup['id'])
->addValue('html_type', 'Text')
->addValue('data_type', 'String')
->execute();
$contactId = Contact::create()
->setCheckPermissions(FALSE)
->addValue('first_name', 'Johann')
->addValue('last_name', 'Tester')
->addValue('contact_type', 'Individual')
->addValue('MyContactFields.FavColor', 'Red')
->execute()
->first()['id'];
$contact = Contact::get()
->setCheckPermissions(FALSE)
->addSelect('first_name')
->addSelect('MyContactFields.FavColor')
->addWhere('id', '=', $contactId)
->addWhere('MyContactFields.FavColor', '=', 'Red')
->execute()
->first();
$this->assertArrayHasKey('MyContactFields', $contact);
$contactFields = $contact['MyContactFields'];
$this->assertArrayHasKey('FavColor', $contactFields);
$this->assertEquals('Red', $contactFields['FavColor']);
Contact::update()
->addWhere('id', '=', $contactId)
->addValue('MyContactFields.FavColor', 'Blue')
->execute();
$contact = Contact::get()
->setCheckPermissions(FALSE)
->addSelect('MyContactFields.FavColor')
->addWhere('id', '=', $contactId)
->execute()
->first();
$contactFields = $contact['MyContactFields'];
$this->assertEquals('Blue', $contactFields['FavColor']);
}
public function testWithTwoFields() {
$customGroup = CustomGroup::create()
->setCheckPermissions(FALSE)
->addValue('name', 'MyContactFields')
->addValue('extends', 'Contact')
->execute()
->first();
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavColor')
->addValue('custom_group_id', $customGroup['id'])
->addValue('html_type', 'Text')
->addValue('data_type', 'String')
->execute();
CustomField::create()
->setCheckPermissions(FALSE)
->addValue('label', 'FavFood')
->addValue('custom_group_id', $customGroup['id'])
->addValue('html_type', 'Text')
->addValue('data_type', 'String')
->execute();
$contactId1 = Contact::create()
->setCheckPermissions(FALSE)
->addValue('first_name', 'Johann')
->addValue('last_name', 'Tester')
->addValue('MyContactFields.FavColor', 'Red')
->addValue('MyContactFields.FavFood', 'Cherry')
->execute()
->first()['id'];
$contactId2 = Contact::create()
->setCheckPermissions(FALSE)
->addValue('first_name', 'MaryLou')
->addValue('last_name', 'Tester')
->addValue('MyContactFields.FavColor', 'Purple')
->addValue('MyContactFields.FavFood', 'Grapes')
->execute()
->first()['id'];
$contact = Contact::get()
->setCheckPermissions(FALSE)
->addSelect('first_name')
->addSelect('MyContactFields.FavColor')
->addSelect('MyContactFields.FavFood')
->addWhere('id', '=', $contactId1)
->addWhere('MyContactFields.FavColor', '=', 'Red')
->addWhere('MyContactFields.FavFood', '=', 'Cherry')
->execute()
->first();
$this->assertArrayHasKey('MyContactFields', $contact);
$contactFields = $contact['MyContactFields'];
$this->assertArrayHasKey('FavColor', $contactFields);
$this->assertEquals('Red', $contactFields['FavColor']);
Contact::update()
->addWhere('id', '=', $contactId1)
->addValue('MyContactFields.FavColor', 'Blue')
->execute();
$contact = Contact::get()
->setCheckPermissions(FALSE)
->addSelect('MyContactFields.FavColor')
->addWhere('id', '=', $contactId1)
->execute()
->first();
$contactFields = $contact['MyContactFields'];
$this->assertEquals('Blue', $contactFields['FavColor']);
$search = Contact::get()
->setCheckPermissions(FALSE)
->addClause('OR', ['MyContactFields.FavColor', '=', 'Blue'], ['MyContactFields.FavFood', '=', 'Grapes'])
->addSelect('id')
->addOrderBy('id')
->execute()
->indexBy('id');
$this->assertEquals([$contactId1, $contactId2], array_keys((array) $search));
$search = Contact::get()
->setCheckPermissions(FALSE)
->addClause('NOT', ['MyContactFields.FavColor', '=', 'Purple'], ['MyContactFields.FavFood', '=', 'Grapes'])
->addSelect('id')
->addOrderBy('id')
->execute()
->indexBy('id');
$this->assertNotContains($contactId2, array_keys((array) $search));
$search = Contact::get()
->setCheckPermissions(FALSE)
->addClause('NOT', ['MyContactFields.FavColor', '=', 'Purple'], ['MyContactFields.FavFood', '=', 'Grapes'])
->addSelect('id')
->addOrderBy('id')
->execute()
->indexBy('id');
$this->assertContains($contactId1, array_keys((array) $search));
$this->assertNotContains($contactId2, array_keys((array) $search));
$search = Contact::get()
->setCheckPermissions(FALSE)
->setWhere([['NOT', ['OR', [['MyContactFields.FavColor', '=', 'Blue'], ['MyContactFields.FavFood', '=', 'Grapes']]]]])
->addSelect('id')
->addOrderBy('id')
->execute()
->indexBy('id');
$this->assertNotContains($contactId1, array_keys((array) $search));
$this->assertNotContains($contactId2, array_keys((array) $search));
}
}
|