tests/phpunit/CRM/Core/PseudoConstantTest.php

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