tests/phpunit/api/v4/Query/OptionValueJoinTest.php

   1 <?php
   2
   3 /*
   4  +--------------------------------------------------------------------+
   5  | CiviCRM version 5                                                  |
   6  +--------------------------------------------------------------------+
   7  | Copyright CiviCRM LLC (c) 2004-2019                                |
   8  +--------------------------------------------------------------------+
   9  | This file is a part of CiviCRM.                                    |
  10  |                                                                    |
  11  | CiviCRM is free software; you can copy, modify, and distribute it  |
  12  | under the terms of the GNU Affero General Public License           |
  13  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  14  |                                                                    |
  15  | CiviCRM is distributed in the hope that it will be useful, but     |
  16  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  17  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  18  | See the GNU Affero General Public License for more details.        |
  19  |                                                                    |
  20  | You should have received a copy of the GNU Affero General Public   |
  21  | License and the CiviCRM Licensing Exception along                  |
  22  | with this program; if not, contact CiviCRM LLC                     |
  23  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  24  | GNU Affero General Public License or the licensing of CiviCRM,     |
  25  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  26  +--------------------------------------------------------------------+
  27  */
  28
  29 /**
  30  *
  31  * @package CRM
  32  * @copyright CiviCRM LLC (c) 2004-2019
  33  * $Id$
  34  *
  35  */
  36
  37
  38 namespace api\v4\Query;
  39
  40 use Civi\Api4\Query\Api4SelectQuery;
  41 use api\v4\UnitTestCase;
  42
  43 /**
  44  * @group headless
  45  */
  46 class OptionValueJoinTest extends UnitTestCase {
  47
  48   public function setUpHeadless() {
  49     $relatedTables = [
  50       'civicrm_address',
  51       'civicrm_email',
  52       'civicrm_phone',
  53       'civicrm_openid',
  54       'civicrm_im',
  55       'civicrm_website',
  56       'civicrm_activity',
  57       'civicrm_activity_contact',
  58     ];
  59
  60     $this->cleanup(['tablesToTruncate' => $relatedTables]);
  61     $this->loadDataSet('SingleContact');
  62
  63     return parent::setUpHeadless();
  64   }
  65
  66   public function testCommunicationMethodJoin() {
  67     $query = new Api4SelectQuery('Contact', FALSE, civicrm_api4('Contact', 'getFields', ['includeCustom' => FALSE, 'checkPermissions' => FALSE, 'action' => 'get'], 'name'));
  68     $query->select[] = 'first_name';
  69     $query->select[] = 'preferred_communication_method.label';
  70     $query->where[] = ['preferred_communication_method', 'IS NOT NULL'];
  71     $results = $query->run();
  72     $first = array_shift($results);
  73     $firstPreferredMethod = array_shift($first['preferred_communication_method']);
  74
  75     $this->assertEquals(
  76       'Phone',
  77       $firstPreferredMethod['label']
  78     );
  79   }
  80
  81 }