Merge pull request #17203 from artfulrobot/artfulrobot-cleanup-job-improvements

[civicrm-core.git] / tests / phpunit / api / v4 / Query / OptionValueJoinTest.php

<?php

/*
 +--------------------------------------------------------------------+
 | Copyright CiviCRM LLC. All rights reserved.                        |
 |                                                                    |
 | This work is published under the GNU AGPLv3 license with some      |
 | permitted exceptions and without any warranty. For full license    |
 | and copyright information, see https://civicrm.org/licensing       |
 +--------------------------------------------------------------------+
 */

/**
 *
 * @package CRM
 * @copyright CiviCRM LLC https://civicrm.org/licensing
 * $Id$
 *
 */


namespace api\v4\Query;

use Civi\Api4\Query\Api4SelectQuery;
use api\v4\UnitTestCase;

/**
 * @group headless
 */
class OptionValueJoinTest extends UnitTestCase {

  public function setUpHeadless() {
    $relatedTables = [
      'civicrm_address',
      'civicrm_email',
      'civicrm_phone',
      'civicrm_openid',
      'civicrm_im',
      'civicrm_website',
      'civicrm_activity',
      'civicrm_activity_contact',
    ];

    $this->cleanup(['tablesToTruncate' => $relatedTables]);
    $this->loadDataSet('SingleContact');

    return parent::setUpHeadless();
  }

  public function testCommunicationMethodJoin() {
    $api = \Civi\API\Request::create('Contact', 'get', ['version' => 4, 'checkPermissions' => FALSE]);
    $query = new Api4SelectQuery($api);
    $query->select[] = 'first_name';
    $query->select[] = 'preferred_communication_method:label';
    $query->where[] = ['preferred_communication_method', 'IS NOT NULL'];
    $results = $query->run();
    $first = array_shift($results);
    $keys = array_keys($first);
    sort($keys);
    $this->assertEquals(['first_name', 'id', 'preferred_communication_method:label'], $keys);
    $firstPreferredMethod = array_shift($first['preferred_communication_method:label']);

    $this->assertEquals(
      'Phone',
      $firstPreferredMethod
    );
  }

}