Merge pull request #11737 from aydun/CRM-21816-relative-dates-in-search
[civicrm-core.git] / tests / phpunit / CRM / Core / BAO / EmailTest.php
1 <?php
2
3 /**
4 * Class CRM_Core_BAO_EmailTest
5 * @group headless
6 */
7 class CRM_Core_BAO_EmailTest extends CiviUnitTestCase {
8 public function setUp() {
9 parent::setUp();
10
11 $this->quickCleanup(array('civicrm_contact', 'civicrm_email'));
12 }
13
14 /**
15 * Add() method (create and update modes)
16 */
17 public function testAdd() {
18 $contactId = $this->individualCreate();
19
20 $params = array();
21 $params = array(
22 'email' => 'jane.doe@example.com',
23 'is_primary' => 1,
24 'location_type_id' => 1,
25 'contact_id' => $contactId,
26 );
27
28 CRM_Core_BAO_Email::add($params);
29
30 $emailId = $this->assertDBNotNull('CRM_Core_DAO_Email', 'jane.doe@example.com', 'id', 'email',
31 'Database check for created email address.'
32 );
33
34 // Now call add() to modify an existing email address
35
36 $params = array();
37 $params = array(
38 'id' => $emailId,
39 'contact_id' => $contactId,
40 'is_bulkmail' => 1,
41 'on_hold' => 1,
42 );
43
44 CRM_Core_BAO_Email::add($params);
45
46 $isBulkMail = $this->assertDBNotNull('CRM_Core_DAO_Email', $emailId, 'is_bulkmail', 'id',
47 'Database check on updated email record.'
48 );
49 $this->assertEquals($isBulkMail, 1, 'Verify bulkmail value is 1.');
50
51 $this->contactDelete($contactId);
52 }
53
54 /**
55 * HoldEmail() method (set and reset on_hold condition)
56 */
57 public function testHoldEmail() {
58 $contactId = $this->individualCreate();
59
60 $params = array(
61 'email' => 'jane.doe@example.com',
62 'is_primary' => 1,
63 'location_type_id' => 1,
64 'contact_id' => $contactId,
65 );
66
67 CRM_Core_BAO_Email::add($params);
68
69 $emailId = $this->assertDBNotNull('CRM_Core_DAO_Email', 'jane.doe@example.com', 'id', 'email',
70 'Database check for created email address.'
71 );
72
73 // Now call add() to update on_hold=true and check record state
74 $params = array();
75 $params = array(
76 'id' => $emailId,
77 'contact_id' => $contactId,
78 'on_hold' => 1,
79 );
80
81 CRM_Core_BAO_Email::add($params);
82
83 // Use assertDBNotNull to get back value of hold_date and check if it's in the current year.
84 // NOTE: The assertEquals will fail IF this test is run just as the year is changing (low likelihood).
85 $holdDate = $this->assertDBNotNull('CRM_Core_DAO_Email', $emailId, 'hold_date', 'id',
86 'Retrieve hold_date from the updated email record.'
87 );
88
89 $this->assertEquals(substr($holdDate, 0, 4), substr(date('YmdHis'), 0, 4),
90 'Compare hold_date (' . $holdDate . ') in DB to current year.'
91 );
92
93 $this->assertDBCompareValue('CRM_Core_DAO_Email', $emailId, 'on_hold', 'id', 1,
94 'Check if on_hold=1 in updated email record.'
95 );
96
97 // Now call add() with on_hold=false and verify that reset_date is set.
98 $params = array();
99 $params = array(
100 'id' => $emailId,
101 'contact_id' => $contactId,
102 'on_hold' => 'null',
103 );
104
105 CRM_Core_BAO_Email::add($params);
106 $this->assertDBCompareValue('CRM_Core_DAO_Email', $emailId, 'on_hold', 'id', 0,
107 'Check if on_hold=0 in updated email record.'
108 );
109 $this->assertDBCompareValue('CRM_Core_DAO_Email', $emailId, 'hold_date', 'id', '',
110 'Check if hold_date has been set to empty string.'
111 );
112
113 // Use assertDBNotNull to get back value of reset_date and check if it's in the current year.
114 // NOTE: The assertEquals will fail IF this test is run just as the year is changing (low likelihood).
115 $resetDate = $this->assertDBNotNull('CRM_Core_DAO_Email', $emailId, 'reset_date', 'id',
116 'Retrieve reset_date from the updated email record.'
117 );
118
119 $this->assertEquals(substr($resetDate, 0, 4), substr(date('YmdHis'), 0, 4),
120 'Compare reset_date (' . $resetDate . ') in DB to current year.'
121 );
122
123 $this->contactDelete($contactId);
124 }
125
126 /**
127 * AllEmails() method - get all emails for our contact, with primary email first
128 */
129 public function testAllEmails() {
130 $contactParams = array(
131 'first_name' => 'Alan',
132 'last_name' => 'Smith',
133 'email' => 'alan.smith1@example.com',
134 'api.email.create.0' => array('email' => 'alan.smith2@example.com', 'location_type_id' => 'Home'),
135 'api.email.create.1' => array('email' => 'alan.smith3@example.com', 'location_type_id' => 'Main'),
136 );
137
138 $contactId = $this->individualCreate($contactParams);
139
140 $emails = CRM_Core_BAO_Email::allEmails($contactId);
141
142 $this->assertEquals(count($emails), 3, 'Checking number of returned emails.');
143
144 $firstEmailValue = array_slice($emails, 0, 1);
145
146 $this->assertEquals('alan.smith1@example.com', $firstEmailValue[0]['email'], 'Confirm primary email address value.');
147 $this->assertEquals(1, $firstEmailValue[0]['is_primary'], 'Confirm first email address is primary.');
148
149 $this->contactDelete($contactId);
150 }
151
152 /**
153 * Test getting list of Emails for use in Receipts and Single Email sends
154 */
155 public function testGetFromEmail() {
156 $this->createLoggedInUser();
157 $fromEmails = CRM_Core_BAO_Email::getFromEmail();
158 $emails = array_values($fromEmails);
159 $this->assertContains("(preferred)", $emails[0]);
160 Civi::settings()->set("allow_mail_from_logged_in_contact", 0);
161 $this->callAPISuccess('system', 'flush', []);
162 $fromEmails = CRM_Core_BAO_Email::getFromEmail();
163 $emails = array_values($fromEmails);
164 $this->assertNotContains("(preferred)", $emails[0]);
165 $this->assertContains("info@EXAMPLE.ORG", $emails[0]);
166 Civi::settings()->set("allow_mail_from_logged_in_contact", 1);
167 $this->callAPISuccess('system', 'flush', []);
168 }
169
170 }