crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/tests/phpunit/CRM/Contact/BAO/QueryTest.php

   1 <?php
   2 require_once 'CiviTest/CiviUnitTestCase.php';
   3 require_once 'CiviTest/Contact.php';
   4
   5 /**
   6  *  Include dataProvider for tests
   7  */
   8 class CRM_Contact_BAO_QueryTest extends CiviUnitTestCase {
   9
  10   /**
  11    * @return CRM_Contact_BAO_QueryTestDataProvider
  12    */
  13   public function dataProvider() {
  14     return new CRM_Contact_BAO_QueryTestDataProvider();
  15   }
  16
  17   public function setUp() {
  18     parent::setUp();
  19   }
  20
  21   public function tearDown() {
  22     $tablesToTruncate = array(
  23       'civicrm_group_contact',
  24       'civicrm_group',
  25       'civicrm_saved_search',
  26       'civicrm_entity_tag',
  27       'civicrm_tag',
  28       'civicrm_contact',
  29     );
  30     $this->quickCleanup($tablesToTruncate);
  31   }
  32
  33   /**
  34    *  Test CRM_Contact_BAO_Query::searchQuery()
  35    * @dataProvider dataProvider
  36    * @param $fv
  37    * @param $count
  38    * @param $ids
  39    * @param $full
  40    */
  41   public function testSearch($fv, $count, $ids, $full) {
  42     $op = new PHPUnit_Extensions_Database_Operation_Insert();
  43     $op->execute($this->_dbconn,
  44       $this->createFlatXMLDataSet(
  45         dirname(__FILE__) . '/queryDataset.xml'
  46       )
  47     );
  48
  49     $params = CRM_Contact_BAO_Query::convertFormValues($fv);
  50     $obj = new CRM_Contact_BAO_Query($params);
  51
  52     // let's set useGroupBy=true since we are listing contacts here who might belong to
  53     // more than one group / tag / notes etc.
  54     $obj->_useGroupBy = TRUE;
  55
  56     $dao = $obj->searchQuery();
  57
  58     $contacts = array();
  59     while ($dao->fetch()) {
  60       $contacts[] = $dao->contact_id;
  61     }
  62
  63     sort($contacts, SORT_NUMERIC);
  64
  65     $this->assertEquals($ids, $contacts, 'In line ' . __LINE__);
  66   }
  67
  68   /**
  69    * Check that we get a successful result querying for home address.
  70    * CRM-14263 search builder failure with search profile & address in criteria
  71    */
  72   public function testSearchProfileHomeCityCRM14263() {
  73     $contactID = $this->individualCreate();
  74     CRM_Core_Config::singleton()->defaultSearchProfileID = 1;
  75     $this->callAPISuccess('address', 'create', array(
  76         'contact_id' => $contactID,
  77         'city' => 'Cool City',
  78         'location_type_id' => 1,
  79       ));
  80     $params = array(
  81       0 => array(
  82         0 => 'city-1',
  83         1 => '=',
  84         2 => 'Cool City',
  85         3 => 1,
  86         4 => 0,
  87       ),
  88     );
  89     $returnProperties = array(
  90       'contact_type' => 1,
  91       'contact_sub_type' => 1,
  92       'sort_name' => 1,
  93     );
  94
  95     $queryObj = new CRM_Contact_BAO_Query($params, $returnProperties);
  96     try {
  97       $resultDAO = $queryObj->searchQuery(0, 0, NULL,
  98         FALSE, FALSE,
  99         FALSE, FALSE,
 100         FALSE);
 101       $this->assertTrue($resultDAO->fetch());
 102     }
 103     catch (PEAR_Exception $e) {
 104       $err = $e->getCause();
 105       $this->fail('invalid SQL created' . $e->getMessage() . " " . $err->userinfo);
 106
 107     }
 108   }
 109
 110   /**
 111    * Check that we get a successful result querying for home address.
 112    * CRM-14263 search builder failure with search profile & address in criteria
 113    */
 114   public function testSearchProfileHomeCityNoResultsCRM14263() {
 115     $contactID = $this->individualCreate();
 116     CRM_Core_Config::singleton()->defaultSearchProfileID = 1;
 117     $this->callAPISuccess('address', 'create', array(
 118         'contact_id' => $contactID,
 119         'city' => 'Cool City',
 120         'location_type_id' => 1,
 121       ));
 122     $params = array(
 123       0 => array(
 124         0 => 'city-1',
 125         1 => '=',
 126         2 => 'Dumb City',
 127         3 => 1,
 128         4 => 0,
 129       ),
 130     );
 131     $returnProperties = array(
 132       'contact_type' => 1,
 133       'contact_sub_type' => 1,
 134       'sort_name' => 1,
 135     );
 136
 137     $queryObj = new CRM_Contact_BAO_Query($params, $returnProperties);
 138     try {
 139       $resultDAO = $queryObj->searchQuery(0, 0, NULL,
 140         FALSE, FALSE,
 141         FALSE, FALSE,
 142         FALSE);
 143       $this->assertFalse($resultDAO->fetch());
 144     }
 145     catch (PEAR_Exception $e) {
 146       $err = $e->getCause();
 147       $this->fail('invalid SQL created' . $e->getMessage() . " " . $err->userinfo);
 148
 149     }
 150   }
 151
 152   /**
 153    * CRM-14263 search builder failure with search profile & address in criteria
 154    * We are retrieving primary here - checking the actual sql seems super prescriptive - but since the massive query object has
 155    * so few tests detecting any change seems good here :-)
 156    */
 157   public function testSearchProfilePrimaryCityCRM14263() {
 158     $contactID = $this->individualCreate();
 159     CRM_Core_Config::singleton()->defaultSearchProfileID = 1;
 160     $this->callAPISuccess('address', 'create', array(
 161         'contact_id' => $contactID,
 162         'city' => 'Cool City',
 163         'location_type_id' => 1,
 164       ));
 165     $params = array(
 166       0 => array(
 167         0 => 'city',
 168         1 => '=',
 169         2 => 'Cool City',
 170         3 => 1,
 171         4 => 0,
 172       ),
 173     );
 174     $returnProperties = array(
 175       'contact_type' => 1,
 176       'contact_sub_type' => 1,
 177       'sort_name' => 1,
 178     );
 179     $expectedSQL = "SELECT contact_a.id as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, civicrm_address.id as address_id, civicrm_address.city as `city`  FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) WHERE  (  ( LOWER(civicrm_address.city) = 'cool city' )  )  AND (contact_a.is_deleted = 0)    ORDER BY `contact_a`.`sort_name` asc, `contact_a`.`id` ";
 180     $queryObj = new CRM_Contact_BAO_Query($params, $returnProperties);
 181     try {
 182       $this->assertEquals($expectedSQL, $queryObj->searchQuery(0, 0, NULL,
 183         FALSE, FALSE,
 184         FALSE, FALSE,
 185         TRUE));
 186     }
 187     catch (PEAR_Exception $e) {
 188       $err = $e->getCause();
 189       $this->fail('invalid SQL created' . $e->getMessage() . " " . $err->userinfo);
 190
 191     }
 192   }
 193
 194   /**
 195    * CRM-19562 ensure that only ids are used for contactid searching.
 196    */
 197   public function testContactIDClause() {
 198     $params = array(
 199       array("mark_x_2", "=", 1, 0, 0),
 200       array("mark_x_foo@example.com", "=", 1, 0, 0),
 201     );
 202     $returnProperties = array(
 203       "sort_name" => 1,
 204       "email" => 1,
 205       "do_not_email" => 1,
 206       "is_deceased" => 1,
 207       "on_hold" => 1,
 208       "display_name" => 1,
 209       "preferred_mail_format" => 1,
 210     );
 211     $numberofContacts = 2;
 212     $query = new CRM_Contact_BAO_Query($params, $returnProperties);
 213     try {
 214       $query->apiQuery($params, $returnProperties, NULL, NULL, 0, $numberofContacts);
 215     }
 216     catch (Exception $e) {
 217       $this->assertEquals("A fatal error was triggered: One of parameters  (value: foo@example.com) is not of the type Positive",
 218         $e->getMessage());
 219       return $this->assertTrue(TRUE);
 220     }
 221     return $this->fail('Test failed for some reason which is not good');
 222   }
 223
 224 }