1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
<?php
namespace Civi\Test\Api4\Action;
use Civi\Api4\Contact;
use Civi\Api4\Relationship;
use Civi\Test\Api4\UnitTestCase;
/**
* @group headless
*/
class DateTest extends UnitTestCase {
public function testRelationshipDate() {
$c1 = Contact::create()
->addValue('first_name', 'c')
->addValue('last_name', 'one')
->execute()
->first()['id'];
$c2 = Contact::create()
->addValue('first_name', 'c')
->addValue('last_name', 'two')
->execute()
->first()['id'];
$r = Relationship::create()
->addValue('contact_id_a', $c1)
->addValue('contact_id_b', $c2)
->addValue('relationship_type_id', 1)
->addValue('start_date', 'now')
->addValue('end_date', 'now + 1 week')
->execute()
->first()['id'];
$result = Relationship::get()
->addWhere('start_date', '=', 'now')
->addWhere('end_date', '>', 'now + 1 day')
->execute()
->indexBy('id');
$this->assertArrayHasKey($r, $result);
$result = Relationship::get()
->addWhere('start_date', '<', 'now')
->execute()
->indexBy('id');
$this->assertArrayNotHasKey($r, $result);
}
}
|