Commit | Line | Data |
---|---|---|
887a4028 A |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
39de6fd5 | 4 | | CiviCRM version 4.6 | |
887a4028 | 5 | +--------------------------------------------------------------------+ |
06a1bc01 | 6 | | Copyright CiviCRM LLC (c) 2004-2014 | |
887a4028 A |
7 | +--------------------------------------------------------------------+ |
8 | | This file is a part of CiviCRM. | | |
9 | | | | |
10 | | CiviCRM is free software; you can copy, modify, and distribute it | | |
11 | | under the terms of the GNU Affero General Public License | | |
12 | | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
13 | | | | |
14 | | CiviCRM is distributed in the hope that it will be useful, but | | |
15 | | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
16 | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
17 | | See the GNU Affero General Public License for more details. | | |
18 | | | | |
19 | | You should have received a copy of the GNU Affero General Public | | |
20 | | License and the CiviCRM Licensing Exception along | | |
21 | | with this program; if not, contact CiviCRM LLC | | |
22 | | at info[AT]civicrm[DOT]org. If you have questions about the | | |
23 | | GNU Affero General Public License or the licensing of CiviCRM, | | |
24 | | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
25 | +--------------------------------------------------------------------+ | |
26 | */ | |
27 | ||
28 | require_once 'CiviTest/CiviUnitTestCase.php'; | |
29 | ||
30 | /** | |
2158332a | 31 | * Tests for pseudoconstant retrieval |
887a4028 A |
32 | */ |
33 | class CRM_Core_PseudoConstantTest extends CiviUnitTestCase { | |
887a4028 | 34 | |
00be9182 | 35 | public function setUp() { |
887a4028 | 36 | parent::setUp(); |
68fd48d9 CW |
37 | |
38 | $this->loadAllFixtures(); | |
39 | ||
40 | CRM_Core_BAO_ConfigSetting::enableComponent('CiviCase'); | |
874bbfa9 | 41 | CRM_Core_BAO_ConfigSetting::enableComponent('CiviCampaign'); |
887a4028 A |
42 | } |
43 | ||
cd43c5e3 AS |
44 | /** |
45 | * Assure CRM_Core_PseudoConstant::get() is working properly for a range of | |
46 | * DAO fields having a <pseudoconstant> tag in the XML schema. | |
47 | */ | |
00be9182 | 48 | public function testOptionValues() { |
bd44e0df | 49 | |
29494eef | 50 | // Create a custom field group for testing. |
bd44e0df | 51 | $custom_group_name = md5(microtime()); |
cd43c5e3 | 52 | $api_params = array( |
bd44e0df AS |
53 | 'title' => $custom_group_name, |
54 | 'extends' => 'Individual', | |
55 | 'is_active' => TRUE, | |
cd43c5e3 | 56 | ); |
874bbfa9 | 57 | $result = civicrm_api3('customGroup', 'create', $api_params); |
cd43c5e3 | 58 | |
deceed83 CW |
59 | // Add a custom field to the above field group. |
60 | $api_params = array( | |
deceed83 CW |
61 | 'debug' => 1, |
62 | 'custom_group_id' => $result['id'], | |
63 | 'label' => $custom_group_name, | |
64 | 'html_type' => 'Select', | |
65 | 'data_type' => 'String', | |
66 | 'is_active' => TRUE, | |
67 | 'option_values' => array(array( | |
68 | 'label' => 'Foo', | |
69 | 'value' => 'foo', | |
70 | 'is_active' => 1, | |
71 | 'weight' => 0, | |
72 | )), | |
73 | ); | |
874bbfa9 | 74 | $result = civicrm_api3('custom_field', 'create', $api_params); |
deceed83 CW |
75 | $customFieldId = $result['id']; |
76 | ||
77 | // Create a Contact Group for testing. | |
29494eef AS |
78 | $group_name = md5(microtime()); |
79 | $api_params = array( | |
29494eef AS |
80 | 'title' => $group_name, |
81 | 'is_active' => TRUE, | |
82 | ); | |
874bbfa9 | 83 | $result = civicrm_api3('group', 'create', $api_params); |
6d68a4cb CW |
84 | |
85 | // Create a PaymentProcessor for testing. | |
86 | $pp_name = md5(microtime()); | |
87 | $api_params = array( | |
6d68a4cb CW |
88 | 'domain_id' => 1, |
89 | 'payment_processor_type_id' => 10, | |
90 | 'name' => $pp_name, | |
91 | 'user_name' => $pp_name, | |
92 | 'class_name' => 'Payment_Dummy', | |
93 | 'url_site' => 'https://test.com/', | |
94 | 'url_recur' => 'https://test.com/', | |
95 | 'is_active' => 1, | |
96 | ); | |
874bbfa9 CW |
97 | $result = civicrm_api3('payment_processor', 'create', $api_params); |
98 | ||
99 | // Create a Campaign for testing. | |
100 | $campaign_name = md5(microtime()); | |
101 | $api_params = array( | |
102 | 'title' => $campaign_name, | |
103 | 'is_active' => TRUE, | |
104 | 'status_id' => 2, | |
105 | ); | |
106 | $result = civicrm_api3('campaign', 'create', $api_params); | |
107 | ||
108 | // Create a membership type for testing. | |
109 | $membership_type = md5(microtime()); | |
110 | $api_params = array( | |
111 | 'name' => $membership_type, | |
112 | 'is_active' => TRUE, | |
113 | 'financial_type_id' => 1, | |
114 | 'domain_id' => 1, | |
115 | 'member_of_contact_id' => 1, | |
116 | 'duration_unit' => 'day', | |
117 | 'duration_interval' => 1, | |
118 | ); | |
119 | $result = civicrm_api3('membership_type', 'create', $api_params); | |
48b420d7 | 120 | |
874bbfa9 CW |
121 | // Create a contribution page for testing. |
122 | $contribution_page = md5(microtime()); | |
123 | $api_params = array( | |
124 | 'title' => $contribution_page, | |
125 | 'is_active' => TRUE, | |
126 | 'financial_type_id' => 1, | |
127 | ); | |
128 | $result = civicrm_api3('contribution_page', 'create', $api_params); | |
29494eef | 129 | |
cd43c5e3 | 130 | /** |
091fe2a8 | 131 | * daoName/field combinations to test |
cd43c5e3 AS |
132 | * Format: array[DAO Name] = $properties, where properties is an array whose |
133 | * named members can be: | |
091fe2a8 CW |
134 | * - fieldName: the SQL column name within the DAO table. |
135 | * - sample: Any one value which is expected in the list of option values. | |
136 | * - exclude: Any one value which should not be in the list. | |
874bbfa9 | 137 | * - max: integer (default = 20) maximum number of option values expected. |
091fe2a8 | 138 | */ |
398f49ab | 139 | $fields = array( |
874bbfa9 CW |
140 | 'CRM_ACL_DAO_ACL' => array( |
141 | array( | |
142 | 'fieldName' => 'operation', | |
143 | 'sample' => 'View', | |
144 | ), | |
145 | ), | |
146 | 'CRM_Contact_DAO_Group' => array( | |
147 | array( | |
148 | 'fieldName' => 'visibility', | |
149 | 'sample' => 'Public Pages', | |
150 | ), | |
151 | ), | |
29494eef AS |
152 | 'CRM_Contact_DAO_GroupContact' => array( |
153 | array( | |
154 | 'fieldName' => 'group_id', | |
155 | 'sample' => $group_name, | |
156 | ), | |
874bbfa9 CW |
157 | array( |
158 | 'fieldName' => 'status', | |
159 | 'sample' => 'Added', | |
160 | ), | |
29494eef AS |
161 | ), |
162 | 'CRM_Contact_DAO_GroupContactCache' => array( | |
163 | array( | |
164 | 'fieldName' => 'group_id', | |
165 | 'sample' => $group_name, | |
166 | ), | |
167 | ), | |
168 | 'CRM_Contact_DAO_GroupOrganization' => array( | |
169 | array( | |
170 | 'fieldName' => 'group_id', | |
171 | 'sample' => $group_name, | |
172 | ), | |
173 | ), | |
174 | 'CRM_Contact_DAO_SubscriptionHistory' => array( | |
175 | array( | |
176 | 'fieldName' => 'group_id', | |
177 | 'sample' => $group_name, | |
178 | ), | |
874bbfa9 CW |
179 | array( |
180 | 'fieldName' => 'method', | |
181 | 'sample' => 'Web', | |
182 | ), | |
183 | array( | |
184 | 'fieldName' => 'status', | |
185 | 'sample' => 'Added', | |
186 | ), | |
187 | ), | |
188 | 'CRM_Core_DAO_Cache' => array( | |
189 | array( | |
190 | 'fieldName' => 'component_id', | |
191 | 'sample' => 'CiviMail', | |
192 | ), | |
193 | ), | |
194 | 'CRM_Contact_DAO_ACLContactCache' => array( | |
195 | array( | |
196 | 'fieldName' => 'operation', | |
197 | 'sample' => 'All', | |
198 | ), | |
199 | ), | |
200 | 'CRM_Core_DAO_Setting' => array( | |
201 | array( | |
202 | 'fieldName' => 'component_id', | |
203 | 'sample' => 'CiviMail', | |
204 | ), | |
29494eef AS |
205 | ), |
206 | 'CRM_Core_DAO_ActionSchedule' => array( | |
207 | array( | |
208 | 'fieldName' => 'group_id', | |
209 | 'sample' => $group_name, | |
210 | ), | |
874bbfa9 CW |
211 | array( |
212 | 'fieldName' => 'start_action_unit', | |
213 | 'sample' => 'hour', | |
214 | ), | |
215 | array( | |
216 | 'fieldName' => 'repetition_frequency_unit', | |
217 | 'sample' => 'hour', | |
218 | ), | |
219 | array( | |
220 | 'fieldName' => 'end_frequency_unit', | |
221 | 'sample' => 'hour', | |
222 | ), | |
223 | array( | |
224 | 'fieldName' => 'mode', | |
225 | 'sample' => 'Email', | |
226 | ), | |
227 | ), | |
228 | 'CRM_Dedupe_DAO_RuleGroup' => array( | |
229 | array( | |
230 | 'fieldName' => 'contact_type', | |
231 | 'sample' => 'Individual', | |
232 | ), | |
233 | array( | |
234 | 'fieldName' => 'used', | |
235 | 'sample' => 'Unsupervised', | |
236 | ), | |
29494eef AS |
237 | ), |
238 | 'CRM_Mailing_Event_DAO_Subscribe' => array( | |
239 | array( | |
240 | 'fieldName' => 'group_id', | |
241 | 'sample' => $group_name, | |
242 | ), | |
243 | ), | |
4080e473 AS |
244 | 'CRM_Activity_DAO_Activity' => array( |
245 | array( | |
246 | 'fieldName' => 'activity_type_id', | |
a38a89fc | 247 | 'sample' => 'Email', |
68fd48d9 | 248 | 'max' => 100, |
4080e473 AS |
249 | ), |
250 | array( | |
251 | 'fieldName' => 'status_id', | |
252 | 'sample' => 'Scheduled', | |
253 | ), | |
6d68a4cb CW |
254 | array( |
255 | 'fieldName' => 'priority_id', | |
256 | 'sample' => 'Urgent', | |
257 | ), | |
3f3a3ba0 CW |
258 | array( |
259 | 'fieldName' => 'engagement_level', | |
260 | 'sample' => '1', | |
261 | ), | |
262 | array( | |
263 | 'fieldName' => 'medium_id', | |
264 | 'sample' => 'Phone', | |
265 | ), | |
874bbfa9 CW |
266 | array( |
267 | 'fieldName' => 'campaign_id', | |
268 | 'sample' => $campaign_name, | |
269 | ), | |
3f3a3ba0 CW |
270 | ), |
271 | 'CRM_Campaign_DAO_Campaign' => array( | |
874bbfa9 CW |
272 | array( |
273 | 'fieldName' => 'campaign_type_id', | |
274 | 'sample' => 'Constituent Engagement', | |
275 | 'max' => 50, | |
276 | ), | |
3f3a3ba0 CW |
277 | array( |
278 | 'fieldName' => 'status_id', | |
279 | 'sample' => 'Completed', | |
280 | 'max' => 50, | |
281 | ), | |
4080e473 AS |
282 | ), |
283 | 'CRM_Campaign_DAO_Survey' => array( | |
874bbfa9 CW |
284 | array( |
285 | 'fieldName' => 'campaign_id', | |
286 | 'sample' => $campaign_name, | |
287 | ), | |
4080e473 AS |
288 | array( |
289 | 'fieldName' => 'activity_type_id', | |
a38a89fc | 290 | 'sample' => 'Phone Call', |
68fd48d9 | 291 | 'max' => 100, |
4080e473 AS |
292 | ), |
293 | ), | |
874bbfa9 CW |
294 | 'CRM_Campaign_DAO_CampaignGroup' => array( |
295 | array( | |
296 | 'fieldName' => 'campaign_id', | |
297 | 'sample' => $campaign_name, | |
298 | ), | |
299 | array( | |
300 | 'fieldName' => 'group_type', | |
301 | 'sample' => 'Include', | |
302 | ), | |
303 | ), | |
304 | 'CRM_Contact_DAO_RelationshipType' => array( | |
305 | array( | |
306 | 'fieldName' => 'contact_type_a', | |
307 | 'sample' => 'Individual', | |
308 | ), | |
309 | array( | |
310 | 'fieldName' => 'contact_type_b', | |
311 | 'sample' => 'Organization', | |
312 | ), | |
313 | ), | |
4080e473 | 314 | 'CRM_Event_DAO_ParticipantStatusType' => array( |
874bbfa9 CW |
315 | array( |
316 | 'fieldName' => 'class', | |
317 | 'sample' => 'Waiting', | |
318 | ), | |
4080e473 AS |
319 | array( |
320 | 'fieldName' => 'visibility_id', | |
321 | 'sample' => 'Public', | |
322 | ), | |
323 | ), | |
874bbfa9 | 324 | 'CRM_Price_DAO_LineItem' => array( |
4080e473 | 325 | array( |
874bbfa9 CW |
326 | 'fieldName' => 'financial_type_id', |
327 | 'sample' => 'Donation', | |
4080e473 AS |
328 | ), |
329 | ), | |
9da8dc8c | 330 | 'CRM_Price_DAO_PriceField' => array( |
874bbfa9 CW |
331 | array( |
332 | 'fieldName' => 'html_type', | |
333 | 'sample' => 'Select', | |
334 | ), | |
4080e473 AS |
335 | array( |
336 | 'fieldName' => 'visibility_id', | |
337 | 'sample' => 'Public', | |
338 | ), | |
339 | ), | |
874bbfa9 CW |
340 | 'CRM_Price_DAO_PriceFieldValue' => array( |
341 | array( | |
342 | 'fieldName' => 'financial_type_id', | |
343 | 'sample' => 'Donation', | |
344 | ), | |
345 | ), | |
346 | 'CRM_Price_DAO_PriceSet' => array( | |
347 | array( | |
348 | 'fieldName' => 'domain_id', | |
349 | 'sample' => 'Default Domain Name', | |
350 | ), | |
351 | array( | |
352 | 'fieldName' => 'extends', | |
353 | 'sample' => 'CiviEvent', | |
354 | ), | |
355 | array( | |
356 | 'fieldName' => 'financial_type_id', | |
357 | 'sample' => 'Donation', | |
358 | ), | |
359 | ), | |
7611ae71 AS |
360 | 'CRM_Financial_DAO_EntityFinancialAccount' => array( |
361 | array( | |
362 | 'fieldName' => 'financial_account_id', | |
363 | 'sample' => 'Member Dues', | |
7611ae71 AS |
364 | ), |
365 | array( | |
366 | 'fieldName' => 'account_relationship', | |
367 | 'sample' => 'Income Account is', | |
368 | ), | |
369 | ), | |
370 | 'CRM_Financial_DAO_FinancialItem' => array( | |
371 | array( | |
372 | 'fieldName' => 'status_id', | |
373 | 'sample' => 'Partially paid', | |
374 | ), | |
375 | array( | |
376 | 'fieldName' => 'financial_account_id', | |
377 | 'sample' => 'Accounts Receivable', | |
7611ae71 | 378 | ), |
6d68a4cb CW |
379 | array( |
380 | 'fieldName' => 'currency', | |
a38a89fc | 381 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb CW |
382 | 'max' => 200, |
383 | ), | |
7611ae71 AS |
384 | ), |
385 | 'CRM_Financial_DAO_FinancialTrxn' => array( | |
386 | array( | |
387 | 'fieldName' => 'from_financial_account_id', | |
388 | 'sample' => 'Accounts Receivable', | |
7611ae71 AS |
389 | ), |
390 | array( | |
391 | 'fieldName' => 'to_financial_account_id', | |
392 | 'sample' => 'Accounts Receivable', | |
7611ae71 | 393 | ), |
6d68a4cb CW |
394 | array( |
395 | 'fieldName' => 'currency', | |
a38a89fc | 396 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb CW |
397 | 'max' => 200, |
398 | ), | |
874bbfa9 CW |
399 | array( |
400 | 'fieldName' => 'payment_instrument_id', | |
401 | 'sample' => 'Check', | |
402 | ), | |
7611ae71 AS |
403 | ), |
404 | 'CRM_Financial_DAO_FinancialAccount' => array( | |
405 | array( | |
406 | 'fieldName' => 'financial_account_type_id', | |
407 | 'sample' => 'Cost of Sales', | |
408 | ), | |
409 | ), | |
874bbfa9 CW |
410 | 'CRM_Financial_DAO_PaymentProcessor' => array( |
411 | array( | |
412 | 'fieldName' => 'domain_id', | |
413 | 'sample' => 'Default Domain Name', | |
414 | ), | |
415 | ), | |
416 | 'CRM_Financial_BAO_PaymentProcessorType' => array( | |
417 | array( | |
418 | 'fieldName' => 'billing_mode', | |
419 | 'sample' => 'form', | |
420 | ), | |
421 | ), | |
bd44e0df AS |
422 | 'CRM_Core_DAO_UFField' => array( |
423 | array( | |
424 | 'fieldName' => 'uf_group_id', | |
425 | 'sample' => 'Name and Address', | |
874bbfa9 CW |
426 | ), |
427 | array( | |
428 | 'fieldName' => 'visibility', | |
429 | 'sample' => 'Public Pages', | |
bd44e0df AS |
430 | ), |
431 | ), | |
432 | 'CRM_Core_DAO_UFJoin' => array( | |
433 | array( | |
434 | 'fieldName' => 'uf_group_id', | |
435 | 'sample' => 'Name and Address', | |
874bbfa9 CW |
436 | ), |
437 | ), | |
438 | 'CRM_Core_DAO_UFMatch' => array( | |
439 | array( | |
440 | 'fieldName' => 'domain_id', | |
441 | 'sample' => 'Default Domain Name', | |
442 | ), | |
443 | ), | |
444 | 'CRM_Core_DAO_Job' => array( | |
445 | array( | |
446 | 'fieldName' => 'domain_id', | |
447 | 'sample' => 'Default Domain Name', | |
448 | ), | |
449 | array( | |
450 | 'fieldName' => 'run_frequency', | |
451 | 'sample' => 'Daily', | |
452 | ), | |
453 | ), | |
454 | 'CRM_Core_DAO_JobLog' => array( | |
455 | array( | |
456 | 'fieldName' => 'domain_id', | |
457 | 'sample' => 'Default Domain Name', | |
bd44e0df AS |
458 | ), |
459 | ), | |
460 | 'CRM_Contribute_DAO_ContributionSoft' => array( | |
461 | array( | |
462 | 'fieldName' => 'currency', | |
a38a89fc | 463 | 'sample' => array('USD' => 'US Dollar'), |
bd44e0df AS |
464 | 'max' => 200, |
465 | ), | |
d9136461 | 466 | array( |
467 | 'fieldName' => 'soft_credit_type_id', | |
468 | 'sample' => 'In Honor of', | |
469 | ), | |
bd44e0df | 470 | ), |
bd44e0df AS |
471 | 'CRM_Contribute_DAO_Product' => array( |
472 | array( | |
473 | 'fieldName' => 'currency', | |
a38a89fc | 474 | 'sample' => array('USD' => 'US Dollar'), |
bd44e0df AS |
475 | 'max' => 200, |
476 | ), | |
874bbfa9 CW |
477 | array( |
478 | 'fieldName' => 'financial_type_id', | |
479 | 'sample' => 'Donation', | |
480 | ), | |
481 | array( | |
482 | 'fieldName' => 'period_type', | |
483 | 'sample' => 'Rolling', | |
484 | ), | |
485 | array( | |
486 | 'fieldName' => 'duration_unit', | |
487 | 'sample' => 'Day', | |
488 | ), | |
489 | array( | |
490 | 'fieldName' => 'frequency_unit', | |
491 | 'sample' => 'Day', | |
492 | ), | |
493 | ), | |
494 | 'CRM_Contribute_DAO_ContributionProduct' => array( | |
495 | array( | |
496 | 'fieldName' => 'financial_type_id', | |
497 | 'sample' => 'Donation', | |
498 | ), | |
bd44e0df | 499 | ), |
bd44e0df AS |
500 | 'CRM_Contribute_DAO_ContributionRecur' => array( |
501 | array( | |
502 | 'fieldName' => 'currency', | |
a38a89fc | 503 | 'sample' => array('USD' => 'US Dollar'), |
bd44e0df AS |
504 | 'max' => 200, |
505 | ), | |
874bbfa9 CW |
506 | array( |
507 | 'fieldName' => 'frequency_unit', | |
508 | 'sample' => 'month', | |
509 | ), | |
510 | array( | |
511 | 'fieldName' => 'contribution_status_id', | |
512 | 'sample' => 'Completed', | |
513 | ), | |
514 | array( | |
515 | 'fieldName' => 'financial_type_id', | |
516 | 'sample' => 'Donation', | |
517 | ), | |
518 | array( | |
519 | 'fieldName' => 'payment_instrument_id', | |
520 | 'sample' => 'Check', | |
521 | ), | |
522 | array( | |
523 | 'fieldName' => 'campaign_id', | |
524 | 'sample' => $campaign_name, | |
525 | ), | |
bd44e0df | 526 | ), |
5ccc09d8 | 527 | 'CRM_Pledge_DAO_PledgePayment' => array( |
bd44e0df AS |
528 | array( |
529 | 'fieldName' => 'currency', | |
a38a89fc | 530 | 'sample' => array('USD' => 'US Dollar'), |
bd44e0df AS |
531 | 'max' => 200, |
532 | ), | |
533 | ), | |
534 | 'CRM_Pledge_DAO_Pledge' => array( | |
535 | array( | |
536 | 'fieldName' => 'currency', | |
a38a89fc | 537 | 'sample' => array('USD' => 'US Dollar'), |
bd44e0df AS |
538 | 'max' => 200, |
539 | ), | |
874bbfa9 CW |
540 | array( |
541 | 'fieldName' => 'financial_type_id', | |
542 | 'sample' => 'Donation', | |
543 | ), | |
544 | array( | |
545 | 'fieldName' => 'frequency_unit', | |
546 | 'sample' => 'month', | |
547 | ), | |
548 | array( | |
549 | 'fieldName' => 'campaign_id', | |
550 | 'sample' => $campaign_name, | |
551 | ), | |
bd44e0df AS |
552 | ), |
553 | 'CRM_PCP_DAO_PCP' => array( | |
554 | array( | |
555 | 'fieldName' => 'currency', | |
a38a89fc | 556 | 'sample' => array('USD' => 'US Dollar'), |
bd44e0df AS |
557 | 'max' => 200, |
558 | ), | |
6d68a4cb CW |
559 | array( |
560 | 'fieldName' => 'status_id', | |
561 | 'sample' => 'Approved', | |
562 | ), | |
bd44e0df | 563 | ), |
cd43c5e3 AS |
564 | 'CRM_Core_DAO_CustomField' => array( |
565 | array( | |
566 | 'fieldName' => 'custom_group_id', | |
567 | 'sample' => $custom_group_name, | |
568 | ), | |
874bbfa9 CW |
569 | array( |
570 | 'fieldName' => 'data_type', | |
571 | 'sample' => 'Alphanumeric', | |
572 | ), | |
573 | array( | |
574 | 'fieldName' => 'html_type', | |
575 | 'sample' => 'Select Date', | |
576 | ), | |
577 | ), | |
578 | 'CRM_Core_DAO_CustomGroup' => array( | |
579 | array( | |
580 | 'fieldName' => 'style', | |
581 | 'sample' => 'Inline', | |
582 | ), | |
583 | ), | |
584 | 'CRM_Core_DAO_Dashboard' => array( | |
585 | array( | |
586 | 'fieldName' => 'domain_id', | |
587 | 'sample' => 'Default Domain Name', | |
588 | ), | |
589 | ), | |
590 | 'CRM_Core_DAO_Tag' => array( | |
591 | array( | |
592 | 'fieldName' => 'used_for', | |
593 | 'sample' => 'Contacts', | |
594 | ), | |
cd43c5e3 AS |
595 | ), |
596 | 'CRM_Core_DAO_EntityTag' => array( | |
597 | array( | |
598 | 'fieldName' => 'tag_id', | |
599 | 'sample' => 'Government Entity', | |
600 | ), | |
601 | ), | |
874bbfa9 CW |
602 | 'CRM_Core_DAO_Extension' => array( |
603 | array( | |
604 | 'fieldName' => 'type', | |
605 | 'sample' => 'Module', | |
606 | ), | |
607 | ), | |
8f785c9e | 608 | 'CRM_Core_DAO_OptionValue' => array( |
874bbfa9 CW |
609 | array( |
610 | 'fieldName' => 'option_group_id', | |
611 | 'sample' => 'gender', | |
612 | 'max' => 200, | |
613 | ), | |
8f785c9e AS |
614 | array( |
615 | 'fieldName' => 'component_id', | |
616 | 'sample' => 'CiviContribute', | |
617 | ), | |
874bbfa9 CW |
618 | array( |
619 | 'fieldName' => 'domain_id', | |
620 | 'sample' => 'Default Domain Name', | |
621 | ), | |
8f785c9e | 622 | ), |
cbf48754 | 623 | 'CRM_Core_DAO_MailSettings' => array( |
874bbfa9 CW |
624 | array( |
625 | 'fieldName' => 'domain_id', | |
626 | 'sample' => 'Default Domain Name', | |
627 | ), | |
cbf48754 AS |
628 | array( |
629 | 'fieldName' => 'protocol', | |
630 | 'sample' => 'Localdir', | |
631 | ), | |
632 | ), | |
874bbfa9 CW |
633 | 'CRM_Core_DAO_Managed' => array( |
634 | array( | |
635 | 'fieldName' => 'cleanup', | |
636 | 'sample' => 'Always', | |
637 | ), | |
638 | ), | |
cbf48754 AS |
639 | 'CRM_Core_DAO_Mapping' => array( |
640 | array( | |
641 | 'fieldName' => 'mapping_type_id', | |
642 | 'sample' => 'Search Builder', | |
874bbfa9 CW |
643 | ), |
644 | ), | |
645 | 'CRM_Core_DAO_Navigation' => array( | |
646 | array( | |
647 | 'fieldName' => 'domain_id', | |
648 | 'sample' => 'Default Domain Name', | |
cbf48754 AS |
649 | ), |
650 | ), | |
e7e657f0 AS |
651 | 'CRM_Core_DAO_Phone' => array( |
652 | array( | |
653 | 'fieldName' => 'phone_type_id', | |
654 | 'sample' => 'Phone', | |
655 | ), | |
656 | array( | |
657 | 'fieldName' => 'location_type_id', | |
658 | 'sample' => 'Home', | |
659 | ), | |
660 | ), | |
874bbfa9 CW |
661 | 'CRM_Core_DAO_PrintLabel' => array( |
662 | array( | |
663 | 'fieldName' => 'label_format_name', | |
664 | 'sample' => 'Avery 5395', | |
665 | ), | |
666 | array( | |
667 | 'fieldName' => 'label_type_id', | |
668 | 'sample' => 'Event Badge', | |
669 | ), | |
670 | ), | |
e7e657f0 AS |
671 | 'CRM_Core_DAO_Email' => array( |
672 | array( | |
673 | 'fieldName' => 'location_type_id', | |
674 | 'sample' => 'Home', | |
675 | ), | |
676 | ), | |
677 | 'CRM_Core_DAO_Address' => array( | |
678 | array( | |
679 | 'fieldName' => 'location_type_id', | |
680 | 'sample' => 'Home', | |
681 | ), | |
682 | ), | |
cbf48754 AS |
683 | 'CRM_Core_DAO_Website' => array( |
684 | array( | |
685 | 'fieldName' => 'website_type_id', | |
686 | 'sample' => 'Facebook', | |
687 | ), | |
688 | ), | |
874bbfa9 CW |
689 | 'CRM_Core_DAO_WordReplacement' => array( |
690 | array( | |
691 | 'fieldName' => 'match_type', | |
692 | 'sample' => 'Exact Match', | |
693 | ), | |
694 | array( | |
695 | 'fieldName' => 'domain_id', | |
696 | 'sample' => 'Default Domain Name', | |
697 | ), | |
698 | ), | |
cbf48754 | 699 | 'CRM_Core_DAO_MappingField' => array( |
874bbfa9 CW |
700 | array( |
701 | 'fieldName' => 'contact_type', | |
702 | 'sample' => 'Individual', | |
703 | ), | |
cbf48754 AS |
704 | array( |
705 | 'fieldName' => 'website_type_id', | |
706 | 'sample' => 'Facebook', | |
707 | ), | |
e7e657f0 AS |
708 | array( |
709 | 'fieldName' => 'im_provider_id', | |
710 | 'sample' => 'Yahoo', | |
711 | ), | |
874bbfa9 CW |
712 | array( |
713 | 'fieldName' => 'operator', | |
714 | 'sample' => '=', | |
715 | ), | |
cbf48754 | 716 | ), |
398f49ab AS |
717 | 'CRM_Contact_DAO_Contact' => array( |
718 | array( | |
719 | 'fieldName' => 'prefix_id', | |
720 | 'sample' => 'Mr.', | |
721 | ), | |
722 | array( | |
723 | 'fieldName' => 'suffix_id', | |
724 | 'sample' => 'Sr.', | |
725 | ), | |
726 | array( | |
727 | 'fieldName' => 'gender_id', | |
728 | 'sample' => 'Male', | |
729 | ), | |
398f49ab | 730 | array( |
e7e657f0 AS |
731 | 'fieldName' => 'preferred_communication_method', |
732 | 'sample' => 'Postal Mail', | |
398f49ab | 733 | ), |
091fe2a8 CW |
734 | array( |
735 | 'fieldName' => 'contact_type', | |
736 | 'sample' => 'Individual', | |
737 | 'exclude' => 'Team', | |
738 | ), | |
739 | array( | |
740 | 'fieldName' => 'contact_sub_type', | |
741 | 'sample' => 'Team', | |
742 | 'exclude' => 'Individual', | |
743 | ), | |
c0c9cd82 CW |
744 | array( |
745 | 'fieldName' => 'preferred_language', | |
746 | 'sample' => array('en_US' => 'English (United States)'), | |
747 | 'max' => 250, | |
748 | ), | |
874bbfa9 CW |
749 | array( |
750 | 'fieldName' => 'preferred_mail_format', | |
751 | 'sample' => 'Text', | |
752 | ), | |
753 | array( | |
754 | 'fieldName' => 'communication_style_id', | |
755 | 'sample' => 'Formal', | |
756 | ), | |
deceed83 CW |
757 | array( |
758 | 'fieldName' => "custom_$customFieldId", | |
759 | 'sample' => array('foo' => 'Foo'), | |
760 | 'max' => 1, | |
761 | ), | |
398f49ab | 762 | ), |
e7e657f0 | 763 | 'CRM_Batch_DAO_Batch' => array( |
398f49ab | 764 | array( |
e7e657f0 AS |
765 | 'fieldName' => 'type_id', |
766 | 'sample' => 'Membership', | |
398f49ab | 767 | ), |
398f49ab | 768 | array( |
e7e657f0 AS |
769 | 'fieldName' => 'status_id', |
770 | 'sample' => 'Reopened', | |
398f49ab | 771 | ), |
cbf48754 | 772 | array( |
e7e657f0 AS |
773 | 'fieldName' => 'mode_id', |
774 | 'sample' => 'Automatic Batch', | |
cbf48754 | 775 | ), |
874bbfa9 CW |
776 | array( |
777 | 'fieldName' => 'payment_instrument_id', | |
778 | 'sample' => 'Check', | |
779 | ), | |
cbf48754 | 780 | ), |
e7e657f0 | 781 | 'CRM_Core_DAO_IM' => array( |
cbf48754 | 782 | array( |
e7e657f0 AS |
783 | 'fieldName' => 'provider_id', |
784 | 'sample' => 'Yahoo', | |
cbf48754 | 785 | ), |
874bbfa9 CW |
786 | array( |
787 | 'fieldName' => 'location_type_id', | |
788 | 'sample' => 'Home', | |
789 | ), | |
cbf48754 | 790 | ), |
2158332a CW |
791 | 'CRM_Event_DAO_Participant' => array( |
792 | array( | |
793 | 'fieldName' => 'status_id', | |
794 | 'sample' => 'Registered', | |
795 | ), | |
796 | array( | |
797 | 'fieldName' => 'role_id', | |
798 | 'sample' => 'Speaker', | |
799 | ), | |
6d68a4cb CW |
800 | array( |
801 | 'fieldName' => 'fee_currency', | |
a38a89fc | 802 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb CW |
803 | 'max' => 200, |
804 | ), | |
874bbfa9 CW |
805 | array( |
806 | 'fieldName' => 'campaign_id', | |
807 | 'sample' => $campaign_name, | |
808 | ), | |
2158332a CW |
809 | ), |
810 | 'CRM_Event_DAO_Event' => array( | |
811 | array( | |
812 | 'fieldName' => 'event_type_id', | |
813 | 'sample' => 'Fundraiser', | |
814 | ), | |
874bbfa9 CW |
815 | array( |
816 | 'fieldName' => 'participant_listing_id', | |
817 | 'sample' => 'Name and Email', | |
818 | ), | |
2158332a | 819 | array( |
6d68a4cb CW |
820 | 'fieldName' => 'payment_processor', |
821 | 'sample' => $pp_name, | |
822 | ), | |
823 | array( | |
824 | 'fieldName' => 'financial_type_id', | |
825 | 'sample' => 'Donation', | |
826 | ), | |
874bbfa9 CW |
827 | array( |
828 | 'fieldName' => 'default_role_id', | |
829 | 'sample' => 'Attendee', | |
830 | ), | |
6d68a4cb CW |
831 | array( |
832 | 'fieldName' => 'currency', | |
a38a89fc | 833 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb | 834 | 'max' => 200, |
2158332a | 835 | ), |
874bbfa9 CW |
836 | array( |
837 | 'fieldName' => 'campaign_id', | |
838 | 'sample' => $campaign_name, | |
839 | ), | |
840 | ), | |
841 | 'CRM_Core_DAO_Menu' => array( | |
842 | array( | |
843 | 'fieldName' => 'domain_id', | |
844 | 'sample' => 'Default Domain Name', | |
845 | ), | |
846 | array( | |
847 | 'fieldName' => 'component_id', | |
848 | 'sample' => 'CiviMember', | |
849 | ), | |
2158332a | 850 | ), |
f899561e | 851 | 'CRM_Member_DAO_Membership' => array( |
874bbfa9 CW |
852 | array( |
853 | 'fieldName' => 'membership_type_id', | |
854 | 'sample' => $membership_type, | |
855 | ), | |
f899561e CW |
856 | array( |
857 | 'fieldName' => 'status_id', | |
858 | 'sample' => 'New', | |
859 | ), | |
874bbfa9 CW |
860 | array( |
861 | 'fieldName' => 'campaign_id', | |
862 | 'sample' => $campaign_name, | |
863 | ), | |
864 | ), | |
865 | 'CRM_Member_DAO_MembershipStatus' => array( | |
866 | array( | |
867 | 'fieldName' => 'start_event', | |
868 | 'sample' => 'start date', | |
869 | ), | |
870 | array( | |
871 | 'fieldName' => 'end_event', | |
872 | 'sample' => 'member since', | |
873 | ), | |
874 | array( | |
875 | 'fieldName' => 'start_event_adjust_unit', | |
876 | 'sample' => 'month', | |
877 | ), | |
878 | array( | |
879 | 'fieldName' => 'end_event_adjust_unit', | |
880 | 'sample' => 'year', | |
881 | ), | |
882 | ), | |
883 | 'CRM_Member_DAO_MembershipType' => array( | |
884 | array( | |
885 | 'fieldName' => 'visibility', | |
886 | 'sample' => 'Public', | |
887 | ), | |
888 | array( | |
889 | 'fieldName' => 'domain_id', | |
890 | 'sample' => 'Default Domain Name', | |
891 | ), | |
892 | array( | |
893 | 'fieldName' => 'financial_type_id', | |
894 | 'sample' => 'Donation', | |
895 | ), | |
896 | array( | |
897 | 'fieldName' => 'duration_unit', | |
898 | 'sample' => 'lifetime', | |
899 | ), | |
900 | array( | |
901 | 'fieldName' => 'period_type', | |
902 | 'sample' => 'Rolling', | |
903 | ), | |
6ce01b02 CW |
904 | ), |
905 | 'CRM_Mailing_DAO_Mailing' => array( | |
f899561e | 906 | array( |
6ce01b02 CW |
907 | 'fieldName' => 'approval_status_id', |
908 | 'sample' => 'Approved', | |
f899561e | 909 | ), |
874bbfa9 CW |
910 | array( |
911 | 'fieldName' => 'domain_id', | |
912 | 'sample' => 'Default Domain Name', | |
913 | ), | |
914 | array( | |
915 | 'fieldName' => 'visibility', | |
916 | 'sample' => 'Public Pages', | |
917 | ), | |
918 | array( | |
919 | 'fieldName' => 'campaign_id', | |
920 | 'sample' => $campaign_name, | |
921 | ), | |
922 | ), | |
923 | 'CRM_Mailing_DAO_Component' => array( | |
924 | array( | |
925 | 'fieldName' => 'component_type', | |
926 | 'sample' => 'Header', | |
927 | ), | |
928 | ), | |
929 | 'CRM_Mailing_DAO_MailingGroup' => array( | |
930 | array( | |
931 | 'fieldName' => 'group_type', | |
932 | 'sample' => 'Include', | |
933 | ), | |
934 | ), | |
935 | 'CRM_Mailing_DAO_MailingJob' => array( | |
936 | array( | |
937 | 'fieldName' => 'status', | |
938 | 'sample' => 'Scheduled', | |
939 | ), | |
940 | ), | |
941 | 'CRM_Mailing_Event_DAO_Bounce' => array( | |
942 | array( | |
943 | 'fieldName' => 'bounce_type_id', | |
944 | 'sample' => 'Invalid', | |
945 | ), | |
946 | ), | |
947 | 'CRM_Mailing_Event_DAO_Subscribe' => array( | |
948 | array( | |
949 | 'fieldName' => 'group_id', | |
950 | 'sample' => $group_name, | |
951 | ), | |
f899561e | 952 | ), |
fb1fd730 CW |
953 | 'CRM_Grant_DAO_Grant' => array( |
954 | array( | |
955 | 'fieldName' => 'status_id', | |
d7867ce7 | 956 | 'sample' => 'Approved for Payment', |
fb1fd730 CW |
957 | ), |
958 | array( | |
959 | 'fieldName' => 'grant_type_id', | |
960 | 'sample' => 'Emergency', | |
961 | ), | |
6d68a4cb CW |
962 | array( |
963 | 'fieldName' => 'currency', | |
a38a89fc | 964 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb CW |
965 | 'max' => 200, |
966 | ), | |
874bbfa9 CW |
967 | array( |
968 | 'fieldName' => 'financial_type_id', | |
969 | 'sample' => 'Donation', | |
970 | ), | |
6d68a4cb CW |
971 | ), |
972 | 'CRM_Contribute_DAO_Contribution' => array( | |
973 | array( | |
974 | 'fieldName' => 'payment_instrument_id', | |
975 | 'sample' => 'Credit Card', | |
976 | ), | |
977 | array( | |
978 | 'fieldName' => 'financial_type_id', | |
979 | 'sample' => 'Donation', | |
980 | ), | |
981 | array( | |
982 | 'fieldName' => 'currency', | |
a38a89fc | 983 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb CW |
984 | 'max' => 200, |
985 | ), | |
986 | array( | |
987 | 'fieldName' => 'contribution_status_id', | |
988 | 'sample' => 'Completed', | |
989 | ), | |
874bbfa9 CW |
990 | array( |
991 | 'fieldName' => 'contribution_page_id', | |
992 | 'sample' => $contribution_page, | |
993 | ), | |
994 | array( | |
995 | 'fieldName' => 'campaign_id', | |
996 | 'sample' => $campaign_name, | |
997 | ), | |
998 | ), | |
999 | 'CRM_Contribute_DAO_PremiumsProduct' => array( | |
1000 | array( | |
1001 | 'fieldName' => 'financial_type_id', | |
1002 | 'sample' => 'Donation', | |
1003 | ), | |
6d68a4cb CW |
1004 | ), |
1005 | 'CRM_Contribute_DAO_ContributionPage' => array( | |
1006 | array( | |
1007 | 'fieldName' => 'payment_processor', | |
1008 | 'sample' => $pp_name, | |
1009 | ), | |
1010 | array( | |
1011 | 'fieldName' => 'financial_type_id', | |
1012 | 'sample' => 'Donation', | |
1013 | ), | |
1014 | array( | |
1015 | 'fieldName' => 'currency', | |
a38a89fc | 1016 | 'sample' => array('USD' => 'US Dollar'), |
6d68a4cb CW |
1017 | 'max' => 200, |
1018 | ), | |
874bbfa9 CW |
1019 | array( |
1020 | 'fieldName' => 'campaign_id', | |
1021 | 'sample' => $campaign_name, | |
1022 | ), | |
fb1fd730 | 1023 | ), |
3f3a3ba0 CW |
1024 | 'CRM_Case_DAO_Case' => array( |
1025 | array( | |
1026 | 'fieldName' => 'status_id', | |
1027 | 'sample' => 'Ongoing', | |
1028 | ), | |
68fd48d9 CW |
1029 | array( |
1030 | 'fieldName' => 'case_type_id', | |
1031 | 'sample' => 'Housing Support', | |
1032 | ), | |
3f3a3ba0 | 1033 | ), |
874bbfa9 CW |
1034 | 'CRM_Report_DAO_ReportInstance' => array( |
1035 | array( | |
1036 | 'fieldName' => 'domain_id', | |
1037 | 'sample' => 'Default Domain Name', | |
1038 | ), | |
1039 | ), | |
887a4028 | 1040 | ); |
398f49ab AS |
1041 | |
1042 | foreach ($fields as $daoName => $daoFields) { | |
1043 | foreach ($daoFields as $field) { | |
a42ef93c | 1044 | $message = "DAO name: '{$daoName}', field: '{$field['fieldName']}'"; |
398f49ab | 1045 | |
6d68a4cb | 1046 | $optionValues = $daoName::buildOptions($field['fieldName']); |
091fe2a8 CW |
1047 | $this->assertNotEmpty($optionValues, $message); |
1048 | ||
1049 | // Ensure sample value is contained in the returned optionValues. | |
c0c9cd82 CW |
1050 | if (!is_array($field['sample'])) { |
1051 | $this->assertContains($field['sample'], $optionValues, $message); | |
1052 | } | |
1053 | // If sample is an array, we check keys and values | |
1054 | else { | |
1055 | foreach ($field['sample'] as $key => $value) { | |
1056 | $this->assertArrayHasKey($key, $optionValues, $message); | |
1057 | $this->assertEquals(CRM_Utils_Array::value($key, $optionValues), $value, $message); | |
1058 | } | |
1059 | } | |
398f49ab | 1060 | |
6ce01b02 | 1061 | // Ensure exclude value is not contained in the optionValues |
091fe2a8 CW |
1062 | if (!empty($field['exclude'])) { |
1063 | $this->assertNotContains($field['exclude'], $optionValues, $message); | |
1064 | } | |
1065 | ||
398f49ab | 1066 | // Ensure count of optionValues is not extraordinarily high. |
874bbfa9 | 1067 | $max = CRM_Utils_Array::value('max', $field, 20); |
398f49ab AS |
1068 | $this->assertLessThanOrEqual($max, count($optionValues), $message); |
1069 | } | |
1070 | } | |
887a4028 | 1071 | } |
091fe2a8 | 1072 | |
00be9182 | 1073 | public function testContactTypes() { |
091fe2a8 CW |
1074 | $byName = array( |
1075 | 'Individual' => 'Individual', | |
1076 | 'Household' => 'Household', | |
1077 | 'Organization' => 'Organization', | |
1078 | ); | |
1079 | $byId = array( | |
1080 | 1 => 'Individual', | |
1081 | 2 => 'Household', | |
1082 | 3 => 'Organization', | |
1083 | ); | |
a1ef51e2 | 1084 | // By default this should return an array keyed by name |
c0c9cd82 | 1085 | $result = CRM_Contact_DAO_Contact::buildOptions('contact_type'); |
091fe2a8 CW |
1086 | $this->assertEquals($byName, $result); |
1087 | // But we can also fetch by ID | |
1088 | $result = CRM_Core_PseudoConstant::get('CRM_Contact_DAO_Contact', 'contact_type', array('keyColumn' => 'id', 'labelColumn' => 'name')); | |
1089 | $this->assertEquals($byId, $result); | |
1090 | // Make sure flip param works | |
1091 | $result = CRM_Core_PseudoConstant::get('CRM_Contact_DAO_Contact', 'contact_type', array('keyColumn' => 'id', 'labelColumn' => 'name', 'flip' => TRUE)); | |
1092 | $this->assertEquals(array_flip($byId), $result); | |
1093 | } | |
887a4028 | 1094 | } |