tests/phpunit/api/v4/Action/DateTest.php

   1 <?php
   2
   3 /*
   4  +--------------------------------------------------------------------+
   5  | CiviCRM version 5                                                  |
   6  +--------------------------------------------------------------------+
   7  | Copyright CiviCRM LLC (c) 2004-2020                                |
   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-2020
  33  * $Id$
  34  *
  35  */
  36
  37
  38 namespace api\v4\Action;
  39
  40 use Civi\Api4\Contact;
  41 use Civi\Api4\Relationship;
  42 use api\v4\UnitTestCase;
  43
  44 /**
  45  * @group headless
  46  */
  47 class DateTest extends UnitTestCase {
  48
  49   public function testRelationshipDate() {
  50     $c1 = Contact::create()
  51       ->addValue('first_name', 'c')
  52       ->addValue('last_name', 'one')
  53       ->execute()
  54       ->first()['id'];
  55     $c2 = Contact::create()
  56       ->addValue('first_name', 'c')
  57       ->addValue('last_name', 'two')
  58       ->execute()
  59       ->first()['id'];
  60     $r = Relationship::create()
  61       ->addValue('contact_id_a', $c1)
  62       ->addValue('contact_id_b', $c2)
  63       ->addValue('relationship_type_id', 1)
  64       ->addValue('start_date', 'now')
  65       ->addValue('end_date', 'now + 1 week')
  66       ->execute()
  67       ->first()['id'];
  68     $result = Relationship::get()
  69       ->addWhere('start_date', '=', 'now')
  70       ->addWhere('end_date', '>', 'now + 1 day')
  71       ->execute()
  72       ->indexBy('id');
  73     $this->assertArrayHasKey($r, $result);
  74     $result = Relationship::get()
  75       ->addWhere('start_date', '<', 'now')
  76       ->execute()
  77       ->indexBy('id');
  78     $this->assertArrayNotHasKey($r, $result);
  79   }
  80
  81 }