tests/phpunit/WebTest/Import/AddressImportTest.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 4.6                                                |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2014                                |
   7  +--------------------------------------------------------------------+
   8  | This file is a part of CiviCRM.                                    |
   9  |                                                                    |
  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.   |
  13  |                                                                    |
  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.        |
  18  |                                                                    |
  19  | You should have received a copy of the GNU Affero General Public   |
  20  | License along with this program; if not, contact CiviCRM LLC       |
  21  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  22  | GNU Affero General Public License or the licensing of CiviCRM,     |
  23  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  24  +--------------------------------------------------------------------+
  25  */
  26
  27 require_once 'WebTest/Import/ImportCiviSeleniumTestCase.php';
  28
  29 /**
  30  * Class WebTest_Import_AddressImportTest
  31  */
  32 class WebTest_Import_AddressImportTest extends ImportCiviSeleniumTestCase {
  33
  34   protected function setUp() {
  35     parent::setUp();
  36   }
  37
  38   public function testCustomAddressDataImport() {
  39     $this->webtestLogin();
  40
  41     $firstName1 = 'Ma_' . substr(sha1(rand()), 0, 7);
  42     // Add a custom group and custom field
  43     $customDataParams = $this->_addCustomData();
  44
  45     // Get sample import data.
  46     list($headers, $rows) = $this->_individualCustomCSVData($customDataParams, $firstName1);
  47
  48     $this->importContacts($headers, $rows, 'Individual', 'Skip', array());
  49
  50     // Type search name in autocomplete.
  51     $this->click('sort_name_navigation');
  52     $this->type('css=input#sort_name_navigation', $firstName1);
  53     $this->typeKeys('css=input#sort_name_navigation', $firstName1);
  54
  55     // Wait for result list.
  56     $this->waitForElementPresent("css=ul.ui-autocomplete li");
  57
  58     // Visit contact summary page.
  59     $this->click("css=ul.ui-autocomplete li");
  60     $this->waitForPageToLoad($this->getTimeoutMsec());
  61
  62     foreach ($customDataParams['customFields'] as $key => $value) {
  63       $this->assertTrue($this->isElementPresent("xpath=//div[@class='crm-summary-row']/div[@class='crm-label'][contains(text(), '$key')]"));
  64       $this->assertElementContainsText('address-block-1', "$value");
  65     }
  66   }
  67
  68   /**
  69    * Helper function to provide data for custom data import.
  70    *
  71    * @param array $customDataParams
  72    * @param string $firstName1
  73    *
  74    * @return array
  75    */
  76   public function _individualCustomCSVData($customDataParams, $firstName1) {
  77
  78     $headers = array(
  79       'first_name' => 'First Name',
  80       'last_name' => 'Last Name',
  81       'address_1' => 'Additional Address 1',
  82       'address_2' => 'Additional Address 2',
  83       'city' => 'City',
  84       'state' => 'State',
  85       'country' => 'Country',
  86     );
  87     foreach ($customDataParams['headers'] as $key => $value) {
  88       $headers[$key] = $value;
  89     }
  90
  91     $rows = array(
  92       0 => array(
  93         'first_name' => $firstName1,
  94         'last_name' => 'Anderson',
  95         'address_1' => 'Add 1',
  96         'address_2' => 'Add 2',
  97         'city' => 'Watson',
  98         'state' => 'NY',
  99         'country' => 'United States',
 100       ),
 101     );
 102     foreach ($customDataParams['rows'][0] as $key => $values) {
 103       $rows[0][$key] = $values;
 104     }
 105     return array($headers, $rows);
 106   }
 107
 108   /**
 109    * @return array
 110    */
 111   public function _addCustomData() {
 112
 113     $this->openCiviPage('admin/custom/group', 'reset=1');
 114
 115     //add new custom data
 116     $this->click("//a[@id='newCustomDataGroup']/span");
 117     $this->waitForPageToLoad($this->getTimeoutMsec());
 118
 119     //fill custom group title
 120     $customGroupTitle = 'Custom ' . substr(sha1(rand()), 0, 7);
 121     $this->click('title');
 122     $this->type('title', $customGroupTitle);
 123
 124     //custom group extends
 125     $this->click('extends[0]');
 126     $this->select('extends[0]', "value=Address");
 127     $this->click("//option[@value='Address']");
 128     $this->clickLink('_qf_Group_next-bottom');
 129
 130     //Is custom group created?
 131     $this->waitForText('crm-notification-container', "Your custom field set '{$customGroupTitle}' has been added. You can add custom fields now.");
 132     $gid = $this->urlArg('gid');
 133     $this->waitForElementPresent('_qf_Field_cancel-bottom');
 134
 135     // create custom field "alphanumeric text"
 136     $customField = 'Custom field ' . substr(sha1(rand()), 0, 4);
 137     $this->type('label', $customField);
 138
 139     // clicking save
 140     $this->click('_qf_Field_done-bottom');
 141
 142     $this->waitForText('crm-notification-container', "Custom field '{$customField}' has been saved.");
 143     $this->assertTrue($this->isTextPresent($customField), 'Missing text: ' . $customField);
 144     $customFieldId = explode('&id=', $this->getAttribute("xpath=//div[@id='field_page']//table/tbody//tr/td/div[text()='$customField']/../../td[8]/span/a@href"));
 145     $customFieldId = $customFieldId[1];
 146
 147     // create custom field - Integer
 148     $this->click("newCustomField");
 149     $this->waitForElementPresent('_qf_Field_done-bottom');
 150     $customField1 = 'Customfield_int ' . substr(sha1(rand()), 0, 4);
 151     $this->type('label', $customField1);
 152     $this->select("data_type[0]", "value=1");
 153
 154     // clicking save
 155     $this->click('_qf_Field_done-bottom');
 156     $this->waitForElementPresent('newCustomField');
 157     $this->waitForText('crm-notification-container', "Custom field '{$customField1}' has been saved.");
 158     $this->assertTrue($this->isTextPresent($customField1), 'Missing text: ' . $customField1);
 159     $customFieldId1 = explode('&id=', $this->getAttribute("xpath=//div[@id='field_page']//table/tbody//tr/td/div[text()='$customField1']/../../td[8]/span/a@href"));
 160     $customFieldId1 = $customFieldId1[1];
 161
 162     // create custom field - Number
 163     $this->click("newCustomField");
 164     $this->waitForElementPresent('_qf_Field_done-bottom');
 165     $customField2 = 'Customfield_Number ' . substr(sha1(rand()), 0, 4);
 166     $this->type('label', $customField2);
 167     $this->select("data_type[0]", "value=2");
 168
 169     // clicking save
 170     $this->click('_qf_Field_done-bottom');
 171     $this->waitForElementPresent('newCustomField');
 172     $this->waitForText('crm-notification-container', "Custom field '{$customField2}' has been saved.");
 173     $this->assertTrue($this->isTextPresent($customField2), 'Missing text: ' . $customField2);
 174     $customFieldId2 = explode('&id=', $this->getAttribute("xpath=//div[@id='field_page']//table/tbody//tr/td/div[text()='$customField2']/../../td[8]/span/a@href"));
 175     $customFieldId2 = $customFieldId2[1];
 176
 177     // create custom field - "alphanumeric select"
 178     $this->click("newCustomField");
 179     $this->waitForElementPresent('_qf_Field_done-bottom');
 180     $customField3 = 'Customfield_alp_select' . substr(sha1(rand()), 0, 4);
 181     $customFieldId3 = $this->_createMultipleValueCustomField($customField3, 'Select');
 182
 183     // create custom field - "alphanumeric radio"
 184     $this->click("newCustomField");
 185     $this->waitForElementPresent('_qf_Field_done-bottom');
 186     $customField4 = 'Customfield_alp_radio' . substr(sha1(rand()), 0, 4);
 187     $customFieldId4 = $this->_createMultipleValueCustomField($customField4, 'Radio');
 188
 189     // create custom field - "alphanumeric checkbox"
 190     $this->click("newCustomField");
 191     $this->waitForElementPresent('_qf_Field_done-bottom');
 192     $customField5 = 'Customfield_alp_checkbox' . substr(sha1(rand()), 0, 4);
 193     $customFieldId5 = $this->_createMultipleValueCustomField($customField5, 'CheckBox');
 194
 195     // create custom field - "alphanumeric multiselect"
 196     $this->click("newCustomField");
 197     $this->waitForElementPresent('_qf_Field_done-bottom');
 198     $customField6 = 'Customfield_alp_multiselect' . substr(sha1(rand()), 0, 4);
 199     $customFieldId6 = $this->_createMultipleValueCustomField($customField6, 'Multi-Select');
 200
 201     // create custom field - "alphanumeric advmultiselect"
 202     $this->click("newCustomField");
 203     $this->waitForElementPresent('_qf_Field_done-bottom');
 204     $customField7 = 'Customfield_alp_advmultiselect' . substr(sha1(rand()), 0, 4);
 205     $customFieldId7 = $this->_createMultipleValueCustomField($customField7, 'AdvMulti-Select');
 206
 207     // create custom field - "alphanumeric autocompleteselect"
 208     $this->click("newCustomField");
 209     $this->waitForElementPresent('_qf_Field_done-bottom');
 210     $customField8 = 'Customfield_alp_autocompleteselect' . substr(sha1(rand()), 0, 4);
 211     $customFieldId8 = $this->_createMultipleValueCustomField($customField8, 'Autocomplete-Select');
 212
 213     // create custom field - Money
 214     $this->click("newCustomField");
 215     $this->waitForElementPresent('_qf_Field_done-bottom');
 216     $customField9 = 'Customfield_Money' . substr(sha1(rand()), 0, 4);
 217     $this->type('label', $customField9);
 218     $this->select("data_type[0]", "value=3");
 219
 220     // clicking save
 221     $this->click('_qf_Field_done-bottom');
 222     $this->waitForElementPresent('newCustomField');
 223     $this->waitForText('crm-notification-container', "Custom field '{$customField9}' has been saved.");
 224     $this->assertTrue($this->isTextPresent($customField9), 'Missing text: ' . $customField9);
 225     $customFieldId9 = explode('&id=', $this->getAttribute("xpath=//div[@id='field_page']//table/tbody//tr/td/div[text()='$customField9']/../../td[8]/span/a@href"));
 226     $customFieldId9 = $customFieldId9[1];
 227
 228     // create custom field - Date
 229     $this->click("newCustomField");
 230     $this->waitForElementPresent('_qf_Field_done-bottom');
 231     $customField10 = 'Customfield_Date' . substr(sha1(rand()), 0, 4);
 232     $this->type('label', $customField10);
 233     $this->select("data_type[0]", "value=5");
 234     $this->select("date_format", "value=yy-mm-dd");
 235
 236     // clicking save
 237     $this->click('_qf_Field_done-bottom');
 238     $this->waitForElementPresent('newCustomField');
 239     $this->waitForText('crm-notification-container', "Custom field '{$customField10}' has been saved.");
 240     $this->assertTrue($this->isTextPresent($customField9), 'Missing text: ' . $customField9);
 241     $customFieldId10 = explode('&id=', $this->getAttribute("xpath=//div[@id='field_page']//table/tbody//tr/td/div[text()='$customField10']/../../td[8]/span/a@href"));
 242     $customFieldId10 = $customFieldId10[1];
 243
 244     return array(
 245       'headers' => array(
 246         "custom_{$customFieldId}" => "$customField :: $customGroupTitle",
 247         "custom_{$customFieldId3}" => "$customField3 :: $customGroupTitle",
 248         "custom_{$customFieldId4}" => "$customField4 :: $customGroupTitle",
 249         "custom_{$customFieldId5}" => "$customField5 :: $customGroupTitle",
 250         "custom_{$customFieldId6}" => "$customField6 :: $customGroupTitle",
 251         "custom_{$customFieldId7}" => "$customField7 :: $customGroupTitle",
 252         "custom_{$customFieldId8}" => "$customField8 :: $customGroupTitle",
 253         "custom_{$customFieldId1}" => "$customField1 :: $customGroupTitle",
 254         "custom_{$customFieldId2}" => "$customField2 :: $customGroupTitle",
 255         "custom_{$customFieldId9}" => "$customField9 :: $customGroupTitle",
 256         "custom_{$customFieldId10}" => "$customField10 :: $customGroupTitle",
 257       ),
 258       'rows' => array(
 259         0 => array(
 260           "custom_{$customFieldId}" => "This is a test field",
 261           "custom_{$customFieldId3}" => "label1",
 262           "custom_{$customFieldId4}" => "label1",
 263           "custom_{$customFieldId5}" => "label1",
 264           "custom_{$customFieldId6}" => "label1",
 265           "custom_{$customFieldId7}" => "label1",
 266           "custom_{$customFieldId8}" => "label1",
 267           "custom_{$customFieldId1}" => 1,
 268           "custom_{$customFieldId2}" => 12345,
 269           "custom_{$customFieldId9}" => 123456,
 270           "custom_{$customFieldId10}" => "2009-12-31",
 271         ),
 272       ),
 273       'customFields' => array(
 274         $customField => 'This is a test field',
 275         $customField3 => 'label1',
 276         $customField4 => 'label1',
 277         $customField5 => 'label1',
 278         $customField6 => 'label1',
 279         $customField7 => 'label1',
 280         $customField8 => 'label1',
 281         $customField1 => '1',
 282         $customField2 => '12345',
 283         $customField9 => '123,456.00',
 284         $customField10 => 'December 31st, 2009',
 285       ),
 286     );
 287   }
 288
 289   /**
 290    * @param string $customFieldName
 291    * @param $type
 292    *
 293    * @return array
 294    */
 295   public function _createMultipleValueCustomField($customFieldName, $type) {
 296     $this->type('label', $customFieldName);
 297     $this->select("data_type[0]", "value=0");
 298     $this->select("data_type[1]", "value=" . $type);
 299     $this->type("option_label_1", "label1");
 300     $this->type("option_value_1", "label1");
 301     $this->type("option_label_2", "label2");
 302     $this->type("option_value_2", "label2");
 303
 304     // clicking save
 305     $this->click('_qf_Field_done-bottom');
 306     $this->waitForElementPresent('newCustomField');
 307     $this->waitForText('crm-notification-container', "Custom field '{$customFieldName}' has been saved.");
 308     $this->assertTrue($this->isTextPresent($customFieldName), 'Missing text: ' . $customFieldName);
 309     $customFieldId = explode('&id=', $this->getAttribute("xpath=//div[@id='field_page']//table/tbody//tr/td/div[text()='$customFieldName']/../../td[8]/span/a@href"));
 310     $customFieldId = $customFieldId[1];
 311     return $customFieldId;
 312   }
 313
 314 }