3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2017 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
29 * Class CRM_Core_BAO_AddressTest
32 class CRM_Core_BAO_AddressTest
extends CiviUnitTestCase
{
33 public function setUp() {
36 $this->quickCleanup(array('civicrm_contact', 'civicrm_address'));
40 * Create() method (create and update modes)
42 public function testCreate() {
43 $contactId = $this->individualCreate();
46 $params['address']['1'] = array(
47 'street_address' => 'Oberoi Garden',
48 'supplemental_address_1' => 'Attn: Accounting',
49 'supplemental_address_2' => 'Powai',
50 'supplemental_address_3' => 'Somewhere',
52 'postal_code' => '01903',
53 'state_province_id' => '1000',
54 'country_id' => '1228',
55 'geo_code_1' => '18.219023',
56 'geo_code_2' => '-105.00973',
57 'location_type_id' => '1',
62 $params['contact_id'] = $contactId;
66 CRM_Core_BAO_Address
::create($params, $fixAddress, $entity = NULL);
67 $addressId = $this->assertDBNotNull('CRM_Core_DAO_Address', 'Oberoi Garden', 'id', 'street_address',
68 'Database check for created address.'
71 // Now call add() to modify an existing address
74 $params['address']['1'] = array(
76 'street_address' => '120 Terminal Road',
77 'supplemental_address_1' => 'A-wing:3037',
78 'supplemental_address_2' => 'Bandra',
79 'supplemental_address_3' => 'Somewhere',
81 'postal_code' => '01903',
82 'state_province_id' => '1000',
83 'country_id' => '1228',
84 'geo_code_1' => '18.219023',
85 'geo_code_2' => '-105.00973',
86 'location_type_id' => '1',
90 $params['contact_id'] = $contactId;
92 $block = CRM_Core_BAO_Address
::create($params, $fixAddress, $entity = NULL);
94 $this->assertDBNotNull('CRM_Core_DAO_Address', $contactId, 'id', 'contact_id',
95 'Database check for updated address by contactId.'
97 $this->assertDBNotNull('CRM_Core_DAO_Address', '120 Terminal Road', 'id', 'street_address',
98 'Database check for updated address by street_name.'
100 $this->contactDelete($contactId);
106 public function testAdd() {
107 $contactId = $this->individualCreate();
110 'street_address' => 'E 906N Pine Pl W',
111 'supplemental_address_1' => 'Editorial Dept',
112 'supplemental_address_2' => '',
113 'supplemental_address_3' => '',
115 'postal_code' => '88575',
116 'postal_code_suffix' => '',
117 'state_province_id' => '1001',
118 'country_id' => '1228',
119 'geo_code_1' => '31.694842',
120 'geo_code_2' => '-106.29998',
121 'location_type_id' => '1',
124 'contact_id' => $contactId,
127 $addAddress = CRM_Core_BAO_Address
::add($fixParams, $fixAddress = TRUE);
129 $addParams = $this->assertDBNotNull('CRM_Core_DAO_Address', $contactId, 'id', 'contact_id',
130 'Database check for created contact address.'
133 $this->assertEquals($addAddress->street_address
, 'E 906N Pine Pl W', 'In line' . __LINE__
);
134 $this->assertEquals($addAddress->supplemental_address_1
, 'Editorial Dept', 'In line' . __LINE__
);
135 $this->assertEquals($addAddress->city
, 'El Paso', 'In line' . __LINE__
);
136 $this->assertEquals($addAddress->postal_code
, '88575', 'In line' . __LINE__
);
137 $this->assertEquals($addAddress->geo_code_1
, '31.694842', 'In line' . __LINE__
);
138 $this->assertEquals($addAddress->geo_code_2
, '-106.29998', 'In line' . __LINE__
);
139 $this->assertEquals($addAddress->country_id
, '1228', 'In line' . __LINE__
);
140 $this->contactDelete($contactId);
144 * AllAddress() method ( )
146 public function testallAddress() {
147 $contactId = $this->individualCreate();
150 'street_address' => 'E 906N Pine Pl W',
151 'supplemental_address_1' => 'Editorial Dept',
152 'supplemental_address_2' => '',
153 'supplemental_address_3' => '',
155 'postal_code' => '88575',
156 'postal_code_suffix' => '',
157 'state_province_id' => '1001',
158 'country_id' => '1228',
159 'geo_code_1' => '31.694842',
160 'geo_code_2' => '-106.29998',
161 'location_type_id' => '1',
164 'contact_id' => $contactId,
167 CRM_Core_BAO_Address
::add($fixParams, $fixAddress = TRUE);
169 $addParams = $this->assertDBNotNull('CRM_Core_DAO_Address', $contactId, 'id', 'contact_id',
170 'Database check for created contact address.'
173 'street_address' => 'SW 719B Beech Dr NW',
174 'supplemental_address_1' => 'C/o OPDC',
175 'supplemental_address_2' => '',
176 'supplemental_address_3' => '',
177 'city' => 'Neillsville',
178 'postal_code' => '54456',
179 'postal_code_suffix' => '',
180 'state_province_id' => '1001',
181 'country_id' => '1228',
182 'geo_code_1' => '44.553719',
183 'geo_code_2' => '-90.61457',
184 'location_type_id' => '2',
187 'contact_id' => $contactId,
190 CRM_Core_BAO_Address
::add($fixParams, $fixAddress = TRUE);
192 $addParams = $this->assertDBNotNull('CRM_Core_DAO_Address', $contactId, 'id', 'contact_id',
193 'Database check for created contact address.'
196 $allAddress = CRM_Core_BAO_Address
::allAddress($contactId);
198 $this->assertEquals(count($allAddress), 2, 'Checking number of returned addresses.');
200 $this->contactDelete($contactId);
204 * AllAddress() method ( ) with null value
206 public function testnullallAddress() {
207 $contactId = $this->individualCreate();
210 'street_address' => 'E 906N Pine Pl W',
211 'supplemental_address_1' => 'Editorial Dept',
212 'supplemental_address_2' => '',
213 'supplemental_address_3' => '',
215 'postal_code' => '88575',
216 'postal_code_suffix' => '',
217 'state_province_id' => '1001',
218 'country_id' => '1228',
219 'geo_code_1' => '31.694842',
220 'geo_code_2' => '-106.29998',
221 'location_type_id' => '1',
224 'contact_id' => $contactId,
227 CRM_Core_BAO_Address
::add($fixParams, $fixAddress = TRUE);
229 $addParams = $this->assertDBNotNull('CRM_Core_DAO_Address', $contactId, 'id', 'contact_id',
230 'Database check for created contact address.'
235 $allAddress = CRM_Core_BAO_Address
::allAddress($contact_Id);
237 $this->assertEquals($allAddress, NULL, 'Checking null for returned addresses.');
239 $this->contactDelete($contactId);
243 * GetValues() method (get Address fields)
245 public function testGetValues() {
246 $contactId = $this->individualCreate();
249 $params['address']['1'] = array(
250 'street_address' => 'Oberoi Garden',
251 'supplemental_address_1' => 'Attn: Accounting',
252 'supplemental_address_2' => 'Powai',
253 'supplemental_address_3' => 'Somewhere',
255 'postal_code' => '01903',
256 'state_province_id' => '1000',
257 'country_id' => '1228',
258 'geo_code_1' => '18.219023',
259 'geo_code_2' => '-105.00973',
260 'location_type_id' => '1',
265 $params['contact_id'] = $contactId;
269 CRM_Core_BAO_Address
::create($params, $fixAddress, $entity = NULL);
271 $addressId = $this->assertDBNotNull('CRM_Core_DAO_Address', $contactId, 'id', 'contact_id',
272 'Database check for created address.'
275 $entityBlock = array('contact_id' => $contactId);
276 $address = CRM_Core_BAO_Address
::getValues($entityBlock);
277 $this->assertEquals($address[1]['id'], $addressId);
278 $this->assertEquals($address[1]['contact_id'], $contactId);
279 $this->assertEquals($address[1]['street_address'], 'Oberoi Garden');
280 $this->contactDelete($contactId);
284 * ParseStreetAddress() method (get street address parsed)
286 public function testParseStreetAddress() {
288 // valid Street address to be parsed ( without locale )
289 $street_address = "54A Excelsior Ave. Apt 1C";
290 $parsedStreetAddress = CRM_Core_BAO_Address
::parseStreetAddress($street_address);
291 $this->assertEquals($parsedStreetAddress['street_name'], 'Excelsior Ave.');
292 $this->assertEquals($parsedStreetAddress['street_unit'], 'Apt 1C');
293 $this->assertEquals($parsedStreetAddress['street_number'], '54');
294 $this->assertEquals($parsedStreetAddress['street_number_suffix'], 'A');
296 // valid Street address to be parsed ( $locale = 'en_US' )
297 $street_address = "54A Excelsior Ave. Apt 1C";
299 $parsedStreetAddress = CRM_Core_BAO_Address
::parseStreetAddress($street_address, $locale);
300 $this->assertEquals($parsedStreetAddress['street_name'], 'Excelsior Ave.');
301 $this->assertEquals($parsedStreetAddress['street_unit'], 'Apt 1C');
302 $this->assertEquals($parsedStreetAddress['street_number'], '54');
303 $this->assertEquals($parsedStreetAddress['street_number_suffix'], 'A');
305 // invalid Street address ( $locale = 'en_US' )
306 $street_address = "West St. Apt 1";
308 $parsedStreetAddress = CRM_Core_BAO_Address
::parseStreetAddress($street_address, $locale);
309 $this->assertEquals($parsedStreetAddress['street_name'], 'West St.');
310 $this->assertEquals($parsedStreetAddress['street_unit'], 'Apt 1');
311 $this->assertNotContains('street_number', $parsedStreetAddress);
312 $this->assertNotContains('street_number_suffix', $parsedStreetAddress);
314 // valid Street address to be parsed ( $locale = 'fr_CA' )
315 $street_address = "2-123CA Main St";
317 $parsedStreetAddress = CRM_Core_BAO_Address
::parseStreetAddress($street_address, $locale);
318 $this->assertEquals($parsedStreetAddress['street_name'], 'Main St');
319 $this->assertEquals($parsedStreetAddress['street_unit'], '2');
320 $this->assertEquals($parsedStreetAddress['street_number'], '123');
321 $this->assertEquals($parsedStreetAddress['street_number_suffix'], 'CA');
323 // invalid Street address ( $locale = 'fr_CA' )
324 $street_address = "123 Main St";
326 $parsedStreetAddress = CRM_Core_BAO_Address
::parseStreetAddress($street_address, $locale);
327 $this->assertEquals($parsedStreetAddress['street_name'], 'Main St');
328 $this->assertEquals($parsedStreetAddress['street_number'], '123');
329 $this->assertNotContains('street_unit', $parsedStreetAddress);
330 $this->assertNotContains('street_number_suffix', $parsedStreetAddress);
334 * CRM-21214 - Ensure all child addresses are updated correctly - 1.
335 * 1. First, create three contacts: A, B, and C
336 * 2. Create an address for contact A
337 * 3. Use contact A's address for contact B
338 * 4. Use contact B's address for contact C
339 * 5. Change contact A's address
340 * Address of Contact C should reflect contact A's address change
341 * Also, Contact C's address' master_id should be Contact A's address id.
343 public function testSharedAddressChaining1() {
344 $contactIdA = $this->individualCreate(array(), 0);
345 $contactIdB = $this->individualCreate(array(), 1);
346 $contactIdC = $this->individualCreate(array(), 2);
348 $addressParamsA = array(
349 'street_address' => '123 Fake St.',
350 'location_type_id' => '1',
352 'contact_id' => $contactIdA,
354 $addAddressA = CRM_Core_BAO_Address
::add($addressParamsA, FALSE);
356 $addressParamsB = array(
357 'street_address' => '123 Fake St.',
358 'location_type_id' => '1',
360 'master_id' => $addAddressA->id
,
361 'contact_id' => $contactIdB,
363 $addAddressB = CRM_Core_BAO_Address
::add($addressParamsB, FALSE);
365 $addressParamsC = array(
366 'street_address' => '123 Fake St.',
367 'location_type_id' => '1',
369 'master_id' => $addAddressB->id
,
370 'contact_id' => $contactIdC,
372 $addAddressC = CRM_Core_BAO_Address
::add($addressParamsC, FALSE);
374 $updatedAddressParamsA = array(
375 'id' => $addAddressA->id
,
376 'street_address' => '1313 New Address Lane',
377 'location_type_id' => '1',
379 'contact_id' => $contactIdA,
381 $updatedAddressA = CRM_Core_BAO_Address
::add($updatedAddressParamsA, FALSE);
383 // CRM-21214 - Has Address C been updated with Address A's new values?
384 $newAddressC = new CRM_Core_DAO_Address();
385 $newAddressC->id
= $addAddressC->id
;
386 $newAddressC->find(TRUE);
387 $newAddressC->fetch(TRUE);
389 $this->assertEquals($updatedAddressA->street_address
, $newAddressC->street_address
);
390 $this->assertEquals($updatedAddressA->id
, $newAddressC->master_id
);
394 * CRM-21214 - Ensure all child addresses are updated correctly - 2.
395 * 1. First, create three contacts: A, B, and C
396 * 2. Create an address for contact A and B
397 * 3. Use contact A's address for contact C
398 * 4. Use contact B's address for contact A
399 * 5. Change contact B's address
400 * Address of Contact C should reflect contact B's address change
401 * Also, Contact C's address' master_id should be Contact B's address id.
403 public function testSharedAddressChaining2() {
404 $contactIdA = $this->individualCreate(array(), 0);
405 $contactIdB = $this->individualCreate(array(), 1);
406 $contactIdC = $this->individualCreate(array(), 2);
408 $addressParamsA = array(
409 'street_address' => '123 Fake St.',
410 'location_type_id' => '1',
412 'contact_id' => $contactIdA,
414 $addAddressA = CRM_Core_BAO_Address
::add($addressParamsA, FALSE);
416 $addressParamsB = array(
417 'street_address' => '123 Fake St.',
418 'location_type_id' => '1',
420 'contact_id' => $contactIdB,
422 $addAddressB = CRM_Core_BAO_Address
::add($addressParamsB, FALSE);
424 $addressParamsC = array(
425 'street_address' => '123 Fake St.',
426 'location_type_id' => '1',
428 'master_id' => $addAddressA->id
,
429 'contact_id' => $contactIdC,
431 $addAddressC = CRM_Core_BAO_Address
::add($addressParamsC, FALSE);
433 $updatedAddressParamsA = array(
434 'id' => $addAddressA->id
,
435 'street_address' => '123 Fake St.',
436 'location_type_id' => '1',
438 'master_id' => $addAddressB->id
,
439 'contact_id' => $contactIdA,
441 $updatedAddressA = CRM_Core_BAO_Address
::add($updatedAddressParamsA, FALSE);
443 $updatedAddressParamsB = array(
444 'id' => $addAddressB->id
,
445 'street_address' => '1313 New Address Lane',
446 'location_type_id' => '1',
448 'contact_id' => $contactIdB,
450 $updatedAddressB = CRM_Core_BAO_Address
::add($updatedAddressParamsB, FALSE);
452 // CRM-21214 - Has Address C been updated with Address B's new values?
453 $newAddressC = new CRM_Core_DAO_Address();
454 $newAddressC->id
= $addAddressC->id
;
455 $newAddressC->find(TRUE);
456 $newAddressC->fetch(TRUE);
458 $this->assertEquals($updatedAddressB->street_address
, $newAddressC->street_address
);
459 $this->assertEquals($updatedAddressB->id
, $newAddressC->master_id
);
463 * CRM-21214 - Ensure all child addresses are updated correctly - 3.
464 * 1. First, create a contact: A
465 * 2. Create an address for contact A
466 * 3. Use contact A's address for contact A's address
467 * An error should be given, and master_id should remain the same.
469 public function testSharedAddressChaining3() {
470 $contactIdA = $this->individualCreate(array(), 0);
472 $addressParamsA = array(
473 'street_address' => '123 Fake St.',
474 'location_type_id' => '1',
476 'contact_id' => $contactIdA,
478 $addAddressA = CRM_Core_BAO_Address
::add($addressParamsA, FALSE);
480 $updatedAddressParamsA = array(
481 'id' => $addAddressA->id
,
482 'street_address' => '123 Fake St.',
483 'location_type_id' => '1',
485 'master_id' => $addAddressA->id
,
486 'contact_id' => $contactIdA,
488 $updatedAddressA = CRM_Core_BAO_Address
::add($updatedAddressParamsA, FALSE);
490 // CRM-21214 - AdressA shouldn't be master of itself.
491 $this->assertEmpty($updatedAddressA->master_id
);